362: r_ja_in_deliver_trx.attribute2, 'Y',
363: decode(upper(b.tax_type), 'EXCISE', 'N', 'OTHER EXCISE', 'N', 'ADDL. EXCISE', 'N'
364: , 'CVD', 'N', 'EXCISE_EDUCATION_CESS', 'N', 'CVD_EDUCATION_CESS', 'N'
365: , 'ADDITIONAL_CVD', 'N'
366: , jai_constants.tax_type_sh_exc_edu_cess, 'N'
367: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'
368: , a.modvat_flag)
369: , a.modvat_flag
370: ),
363: decode(upper(b.tax_type), 'EXCISE', 'N', 'OTHER EXCISE', 'N', 'ADDL. EXCISE', 'N'
364: , 'CVD', 'N', 'EXCISE_EDUCATION_CESS', 'N', 'CVD_EDUCATION_CESS', 'N'
365: , 'ADDITIONAL_CVD', 'N'
366: , jai_constants.tax_type_sh_exc_edu_cess, 'N'
367: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'
368: , a.modvat_flag)
369: , a.modvat_flag
370: ),
371: 'N', 1,(1- nvl(b.mod_cr_percentage,0)/100)),
376: r_ja_in_deliver_trx.attribute2, 'Y',
377: decode(upper(b.tax_type), 'EXCISE', 'N', 'OTHER EXCISE', 'N', 'ADDL. EXCISE', 'N'
378: , 'CVD', 'N', 'EXCISE_EDUCATION_CESS', 'N', 'CVD_EDUCATION_CESS', 'N'
379: , 'ADDITIONAL_CVD', 'N'
380: , jai_constants.tax_type_sh_exc_edu_cess, 'N'
381: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'
382: , a.modvat_flag)
383: , a.modvat_flag
384: ),
377: decode(upper(b.tax_type), 'EXCISE', 'N', 'OTHER EXCISE', 'N', 'ADDL. EXCISE', 'N'
378: , 'CVD', 'N', 'EXCISE_EDUCATION_CESS', 'N', 'CVD_EDUCATION_CESS', 'N'
379: , 'ADDITIONAL_CVD', 'N'
380: , jai_constants.tax_type_sh_exc_edu_cess, 'N'
381: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'
382: , a.modvat_flag)
383: , a.modvat_flag
384: ),
385: 'N', 1,(1- nvl(b.mod_cr_percentage,0)/100)
397: r_ja_in_deliver_trx.attribute2, 'Y',
398: decode(upper(b.tax_type), 'EXCISE', 'N', 'OTHER EXCISE', 'N', 'ADDL. EXCISE', 'N'
399: , 'CVD', 'N', 'EXCISE_EDUCATION_CESS', 'N', 'CVD_EDUCATION_CESS', 'N'
400: , 'ADDITIONAL_CVD', 'N'
401: , jai_constants.tax_type_sh_exc_edu_cess, 'N'
402: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'
403: , a.modvat_flag)
404: , a.modvat_flag
405: ),
398: decode(upper(b.tax_type), 'EXCISE', 'N', 'OTHER EXCISE', 'N', 'ADDL. EXCISE', 'N'
399: , 'CVD', 'N', 'EXCISE_EDUCATION_CESS', 'N', 'CVD_EDUCATION_CESS', 'N'
400: , 'ADDITIONAL_CVD', 'N'
401: , jai_constants.tax_type_sh_exc_edu_cess, 'N'
402: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'
403: , a.modvat_flag)
404: , a.modvat_flag
405: ),
406: 'N', 1,(1- nvl(b.mod_cr_percentage,0)/100))
412: r_ja_in_deliver_trx.attribute2, 'Y',
413: decode(upper(b.tax_type), 'EXCISE', 'N', 'OTHER EXCISE', 'N', 'ADDL. EXCISE', 'N'
414: , 'CVD', 'N', 'EXCISE_EDUCATION_CESS', 'N', 'CVD_EDUCATION_CESS', 'N'
415: , 'ADDITIONAL_CVD', 'N'
416: , jai_constants.tax_type_sh_exc_edu_cess, 'N'
417: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'
418: , a.modvat_flag)
419: , a.modvat_flag
420: ),
413: decode(upper(b.tax_type), 'EXCISE', 'N', 'OTHER EXCISE', 'N', 'ADDL. EXCISE', 'N'
414: , 'CVD', 'N', 'EXCISE_EDUCATION_CESS', 'N', 'CVD_EDUCATION_CESS', 'N'
415: , 'ADDITIONAL_CVD', 'N'
416: , jai_constants.tax_type_sh_exc_edu_cess, 'N'
417: , jai_constants.tax_type_sh_cvd_edu_cess, 'N'
418: , a.modvat_flag)
419: , a.modvat_flag
420: ),
421: 'N', 1,(1- nvl(b.mod_cr_percentage,0)/100)
626: , p_xface_id => p_xface_id
627: , p_process_flag => lv_process_flag
628: , p_process_message => lv_process_message
629: );
630: if lv_process_flag <> jai_constants.SUCCESSFUL then
631: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'lv_process_flag='||lv_process_flag ||',Message='||lv_process_message);
632: return;
633: end if;
634: /** Deregister procedure and return*/
939: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);
940:
941: exception
942: when others then
943: p_process_flag := jai_constants.UNEXPECTED_ERROR;
944: p_process_message := sqlerrm;
945: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
946: jai_cmn_debug_contexts_pkg.print_stack;
947: