95:
96: SELECT regime_id
97: INTO ln_regime_id
98: FROM jai_rgm_definitions
99: WHERE regime_code = jai_constants.customs_regime;
100:
101: OPEN get_account_setup(ln_regime_id);
102: FETCH get_account_setup
103: INTO ln_ccid;
150: ln_depb_account_id NUMBER;
151: v_debug CHAR(1);
152:
153: BEGIN
154: v_debug := jai_constants.no;
155:
156: SELECT regime_id
157: INTO ln_regime_id
158: FROM jai_rgm_definitions
421: ln_flag number; --0 indicate is not boe tax , 1 indicate belongs to boe tax.
422: BEGIN
423: if(UPPER(nvl(pv_tax_type,'###')) in
424: ('CVD',
425: jai_constants.tax_type_add_cvd ,
426: 'CUSTOMS',
427: jai_constants.tax_type_cvd_Edu_cess,
428: jai_constants.tax_type_customs_edu_cess ,
429: jai_constants.tax_type_sh_customs_edu_cess,
423: if(UPPER(nvl(pv_tax_type,'###')) in
424: ('CVD',
425: jai_constants.tax_type_add_cvd ,
426: 'CUSTOMS',
427: jai_constants.tax_type_cvd_Edu_cess,
428: jai_constants.tax_type_customs_edu_cess ,
429: jai_constants.tax_type_sh_customs_edu_cess,
430: jai_constants.tax_type_sh_cvd_edu_cess,
431: jai_constants.tax_type_boe_other1,
424: ('CVD',
425: jai_constants.tax_type_add_cvd ,
426: 'CUSTOMS',
427: jai_constants.tax_type_cvd_Edu_cess,
428: jai_constants.tax_type_customs_edu_cess ,
429: jai_constants.tax_type_sh_customs_edu_cess,
430: jai_constants.tax_type_sh_cvd_edu_cess,
431: jai_constants.tax_type_boe_other1,
432: jai_constants.tax_type_boe_other2,
425: jai_constants.tax_type_add_cvd ,
426: 'CUSTOMS',
427: jai_constants.tax_type_cvd_Edu_cess,
428: jai_constants.tax_type_customs_edu_cess ,
429: jai_constants.tax_type_sh_customs_edu_cess,
430: jai_constants.tax_type_sh_cvd_edu_cess,
431: jai_constants.tax_type_boe_other1,
432: jai_constants.tax_type_boe_other2,
433: jai_constants.tax_type_boe_other3,
426: 'CUSTOMS',
427: jai_constants.tax_type_cvd_Edu_cess,
428: jai_constants.tax_type_customs_edu_cess ,
429: jai_constants.tax_type_sh_customs_edu_cess,
430: jai_constants.tax_type_sh_cvd_edu_cess,
431: jai_constants.tax_type_boe_other1,
432: jai_constants.tax_type_boe_other2,
433: jai_constants.tax_type_boe_other3,
434: jai_constants.tax_type_boe_other4,
427: jai_constants.tax_type_cvd_Edu_cess,
428: jai_constants.tax_type_customs_edu_cess ,
429: jai_constants.tax_type_sh_customs_edu_cess,
430: jai_constants.tax_type_sh_cvd_edu_cess,
431: jai_constants.tax_type_boe_other1,
432: jai_constants.tax_type_boe_other2,
433: jai_constants.tax_type_boe_other3,
434: jai_constants.tax_type_boe_other4,
435: jai_constants.tax_type_boe_other5,
428: jai_constants.tax_type_customs_edu_cess ,
429: jai_constants.tax_type_sh_customs_edu_cess,
430: jai_constants.tax_type_sh_cvd_edu_cess,
431: jai_constants.tax_type_boe_other1,
432: jai_constants.tax_type_boe_other2,
433: jai_constants.tax_type_boe_other3,
434: jai_constants.tax_type_boe_other4,
435: jai_constants.tax_type_boe_other5,
436: jai_constants.tax_type_boe_surcharge_duty,
429: jai_constants.tax_type_sh_customs_edu_cess,
430: jai_constants.tax_type_sh_cvd_edu_cess,
431: jai_constants.tax_type_boe_other1,
432: jai_constants.tax_type_boe_other2,
433: jai_constants.tax_type_boe_other3,
434: jai_constants.tax_type_boe_other4,
435: jai_constants.tax_type_boe_other5,
436: jai_constants.tax_type_boe_surcharge_duty,
437: jai_constants.tax_type_boe_add_customs))then
430: jai_constants.tax_type_sh_cvd_edu_cess,
431: jai_constants.tax_type_boe_other1,
432: jai_constants.tax_type_boe_other2,
433: jai_constants.tax_type_boe_other3,
434: jai_constants.tax_type_boe_other4,
435: jai_constants.tax_type_boe_other5,
436: jai_constants.tax_type_boe_surcharge_duty,
437: jai_constants.tax_type_boe_add_customs))then
438: ln_flag := 1;
431: jai_constants.tax_type_boe_other1,
432: jai_constants.tax_type_boe_other2,
433: jai_constants.tax_type_boe_other3,
434: jai_constants.tax_type_boe_other4,
435: jai_constants.tax_type_boe_other5,
436: jai_constants.tax_type_boe_surcharge_duty,
437: jai_constants.tax_type_boe_add_customs))then
438: ln_flag := 1;
439: else
432: jai_constants.tax_type_boe_other2,
433: jai_constants.tax_type_boe_other3,
434: jai_constants.tax_type_boe_other4,
435: jai_constants.tax_type_boe_other5,
436: jai_constants.tax_type_boe_surcharge_duty,
437: jai_constants.tax_type_boe_add_customs))then
438: ln_flag := 1;
439: else
440: ln_flag := 0;
433: jai_constants.tax_type_boe_other3,
434: jai_constants.tax_type_boe_other4,
435: jai_constants.tax_type_boe_other5,
436: jai_constants.tax_type_boe_surcharge_duty,
437: jai_constants.tax_type_boe_add_customs))then
438: ln_flag := 1;
439: else
440: ln_flag := 0;
441: end if;