DBA Data[Home] [Help]

APPS.JAI_AP_IDA_TRIGGER_DTC_PKG dependencies on JAI_AP_TDS_INV_TAXES

Line 1144: Need to update match_status_flag in jai_ap_tds_inv_taxes with the match_status_flag of

1140: Invoked processing of old prepayment application using variable lv_process_old_trxn. Processing of TDS prepayment application for transactions created
1141: prior to upgrade to TDS Threshold will be done only at the time of application and not during validation.
1142:
1143: 9. 18-Jul-2009 Bug 8641199
1144: Need to update match_status_flag in jai_ap_tds_inv_taxes with the match_status_flag of
1145: ap_invoice_distributions_all
1146:
1147: 8. 11-Jan-2010 Xiao Lv for bug#7347508, related 11i bug#6417285
1148: Added new conditions to check if either TDS, WCT or ESSI taxes are getting modified or inserted

Line 1438: FROM jai_ap_tds_inv_taxes

1434:
1435: END IF;
1436: /*Verify if Invoice is processed by process_tds_at_inv_validate before processing Prepayments*/
1437: SELECT max(process_status) INTO ln_processed
1438: FROM jai_ap_tds_inv_taxes
1439: WHERE invoice_id = pr_new.invoice_id;
1440: --should be run, only if prepayment application/unapplication is not already processed
1441: IF lv_prepay_flag IS NULL AND ln_processed = 'P' THEN
1442: lv_process_old_trxn := 'N';