/*API to repopulate new Tax categories in India GST shipping form*/
DECLARE
lv_process_status VARCHAR2(30);
lv_process_message VARCHAR2(30);
BEGIN
FOR c1 IN (SELECT a.*,
17305 new_tax_cat_id
FROM jai_tax_det_factors a
WHERE 1 = 1
AND a.trx_id = 15562920
AND a.application_id = 707) LOOP
jai_tax_determination_pkg.Override_tax_category_rule(
pn_tax_rule_id => c1.tax_rule_id,
pn_tax_category_id => c1.new_tax_cat_id,
pn_det_factor_id => c1.det_factor_id,
pv_process_status => lv_process_status,
pv_process_message => lv_process_message);
COMMIT;
END LOOP;
dbms_output.Put_line('lv_process_status : '||lv_process_status);
EXCEPTION
WHEN OTHERS THEN
dbms_output.Put_line('Error : '||SQLERRM);
END;
No comments:
Post a Comment