APPS.JAI_AP_PSA_TRIGGER_PKG dependencies on JAI_AP_TDS_THHOLD_TRXS

Line 20: cursor c_jai_ap_tds_thhold_trxs(p_invoice_id number) is

16: invoice_type_lookup_code
17: from ap_invoices_all
18: where invoice_id = p_invoice_id;
19:
20: cursor c_jai_ap_tds_thhold_trxs(p_invoice_id number) is
21: select parent_inv_payment_priority
22: from jai_ap_tds_thhold_trxs
23: where invoice_to_vendor_id = p_invoice_id;
24:

Line 22: from jai_ap_tds_thhold_trxs

18: where invoice_id = p_invoice_id;
19:
20: cursor c_jai_ap_tds_thhold_trxs(p_invoice_id number) is
21: select parent_inv_payment_priority
22: from jai_ap_tds_thhold_trxs
23: where invoice_to_vendor_id = p_invoice_id;
24:
25: ln_parent_inv_payment_priority jai_ap_tds_thhold_trxs.parent_inv_payment_priority%type;
26: r_ap_invoices_all c_ap_invoices_all%rowtype;

Line 25: ln_parent_inv_payment_priority jai_ap_tds_thhold_trxs.parent_inv_payment_priority%type;

21: select parent_inv_payment_priority
22: from jai_ap_tds_thhold_trxs
23: where invoice_to_vendor_id = p_invoice_id;
24:
25: ln_parent_inv_payment_priority jai_ap_tds_thhold_trxs.parent_inv_payment_priority%type;
26: r_ap_invoices_all c_ap_invoices_all%rowtype;
27: ln_org_id ap_invoices_all.org_id%type;
28:
29: BEGIN

Line 94: open c_jai_ap_tds_thhold_trxs(pr_new.invoice_id);

90:
91: /* Control will come here only when the invoice is a credit memo to the supplier for TDS */
92:
93: /* Get the payment priority */
94: open c_jai_ap_tds_thhold_trxs(pr_new.invoice_id);
95: fetch c_jai_ap_tds_thhold_trxs into ln_parent_inv_payment_priority;
96: close c_jai_ap_tds_thhold_trxs;
97:
98: if ln_parent_inv_payment_priority is not null then

Line 95: fetch c_jai_ap_tds_thhold_trxs into ln_parent_inv_payment_priority;

91: /* Control will come here only when the invoice is a credit memo to the supplier for TDS */
92:
93: /* Get the payment priority */
94: open c_jai_ap_tds_thhold_trxs(pr_new.invoice_id);
95: fetch c_jai_ap_tds_thhold_trxs into ln_parent_inv_payment_priority;
96: close c_jai_ap_tds_thhold_trxs;
97:
98: if ln_parent_inv_payment_priority is not null then
99: pr_new.payment_priority := ln_parent_inv_payment_priority;

Line 96: close c_jai_ap_tds_thhold_trxs;

92:
93: /* Get the payment priority */
94: open c_jai_ap_tds_thhold_trxs(pr_new.invoice_id);
95: fetch c_jai_ap_tds_thhold_trxs into ln_parent_inv_payment_priority;
96: close c_jai_ap_tds_thhold_trxs;
97:
98: if ln_parent_inv_payment_priority is not null then
99: pr_new.payment_priority := ln_parent_inv_payment_priority;
100: end if;