Friday, 11 April 2025

API to repopulate new Tax categories in India GST shipping form of Oracle APPS R12

 /*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