APPS.JAI_AP_PSA_TRIGGER_PKG dependencies on AP_INVOICES_ALL

Line 14: cursor c_ap_invoices_all(p_invoice_id number) is

10: REM
11: REM +======================================================================+
12: */
13: PROCEDURE BRIUD_T1 ( pr_old t_rec%type , pr_new in out t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
14: cursor c_ap_invoices_all(p_invoice_id number) is
15: select source,
16: invoice_type_lookup_code
17: from ap_invoices_all
18: where invoice_id = p_invoice_id;

Line 17: from ap_invoices_all

13: PROCEDURE BRIUD_T1 ( pr_old t_rec%type , pr_new in out t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
14: cursor c_ap_invoices_all(p_invoice_id number) is
15: select source,
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

Line 26: r_ap_invoices_all c_ap_invoices_all%rowtype;

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
30: pv_return_code := jai_constants.successful ;

Line 27: ln_org_id ap_invoices_all.org_id%type;

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
30: pv_return_code := jai_constants.successful ;
31: /*------------------------------------------------------------------------------------------

Line 83: open c_ap_invoices_all(pr_new.invoice_id);

79: /* Payment Priority Functionality */
80:
81: if pv_action = jai_constants.inserting then
82:
83: open c_ap_invoices_all(pr_new.invoice_id);
84: fetch c_ap_invoices_all into r_ap_invoices_all;
85: close c_ap_invoices_all;
86:
87: if not (r_ap_invoices_all.invoice_type_lookup_code = 'CREDIT' and r_ap_invoices_all.source = 'INDIA TDS' ) then /*--Ramanand for bug#4388958 --'TDS') then*/

Line 84: fetch c_ap_invoices_all into r_ap_invoices_all;

80:
81: if pv_action = jai_constants.inserting then
82:
83: open c_ap_invoices_all(pr_new.invoice_id);
84: fetch c_ap_invoices_all into r_ap_invoices_all;
85: close c_ap_invoices_all;
86:
87: if not (r_ap_invoices_all.invoice_type_lookup_code = 'CREDIT' and r_ap_invoices_all.source = 'INDIA TDS' ) then /*--Ramanand for bug#4388958 --'TDS') then*/
88: goto exit_from_trigger;

Line 85: close c_ap_invoices_all;

81: if pv_action = jai_constants.inserting then
82:
83: open c_ap_invoices_all(pr_new.invoice_id);
84: fetch c_ap_invoices_all into r_ap_invoices_all;
85: close c_ap_invoices_all;
86:
87: if not (r_ap_invoices_all.invoice_type_lookup_code = 'CREDIT' and r_ap_invoices_all.source = 'INDIA TDS' ) then /*--Ramanand for bug#4388958 --'TDS') then*/
88: goto exit_from_trigger;
89: end if;

Line 87: if not (r_ap_invoices_all.invoice_type_lookup_code = 'CREDIT' and r_ap_invoices_all.source = 'INDIA TDS' ) then /*--Ramanand for bug#4388958 --'TDS') then*/

83: open c_ap_invoices_all(pr_new.invoice_id);
84: fetch c_ap_invoices_all into r_ap_invoices_all;
85: close c_ap_invoices_all;
86:
87: if not (r_ap_invoices_all.invoice_type_lookup_code = 'CREDIT' and r_ap_invoices_all.source = 'INDIA TDS' ) then /*--Ramanand for bug#4388958 --'TDS') then*/
88: goto exit_from_trigger;
89: end if;
90:
91: /* Control will come here only when the invoice is a credit memo to the supplier for TDS */