[Home] [Help]
845: P_process_message => lv_process_message,
846: p_codepath => lv_codepath
847: );
848:
849: /* insert into JAI_AP_TDS_INV_CANCELS */
850: lv_codepath := jai_general_pkg.plot_codepath(19, lv_codepath); /* 19 */
851:
852: insert into jai_ap_tds_inv_cancels
853: (
848:
849: /* insert into JAI_AP_TDS_INV_CANCELS */
850: lv_codepath := jai_general_pkg.plot_codepath(19, lv_codepath); /* 19 */
851:
852: insert into jai_ap_tds_inv_cancels
853: (
854: tds_inv_cancel_id ,
855: invoice_id ,
856: threshold_grp_id ,
869: last_update_login
870: )
871: values
872: (
873: jai_ap_tds_inv_cancels_s.nextval ,
874: p_invoice_id ,
875: cur_rec.threshold_grp_id ,
876: cur_rec.taxable_amount ,
877: cur_rec.threshold_trx_id ,
1050: P_process_message => lv_process_message,
1051: p_codepath => lv_codepath
1052: );
1053:
1054: insert into jai_ap_tds_inv_cancels
1055: (
1056: tds_inv_cancel_id ,
1057: invoice_id ,
1058: threshold_grp_id ,
1071: last_update_login
1072: )
1073: values
1074: (
1075: jai_ap_tds_inv_cancels_s.nextval ,
1076: p_invoice_id ,
1077: cur_rec.threshold_grp_id ,
1078: ln_taxable_amount ,
1079: null ,