APPS.JAI_AP_ILA_TRIGGER_PKG dependencies on AP_INVOICES_ALL

Line 21: lv_source ap_invoices_all.source%TYPE;

17: pv_return_code out nocopy varchar2 ,
18: pv_return_message out nocopy varchar2 ) IS
19:
20: /*bug 8425058*/
21: lv_source ap_invoices_all.source%TYPE;
22:
23: BEGIN
24: -- Bug 6780154. Added by Lakshmi Gopalsami
25: -- Removed the cursor and added op_distribution_id is null

Line 42: FROM ap_invoices_all

38: *Fix - Call the ARI_T1 procedure from ARU_T1 when the invoice source is not ERS.*/
39:
40: jai_cmn_utils_pkg.write_fnd_log_msg('After update trigger','Value of invoice_id'||pr_new.invoice_id);
41: SELECT source INTO lv_source
42: FROM ap_invoices_all
43: WHERE invoice_id = pr_new.invoice_id;
44:
45: jai_cmn_utils_pkg.write_fnd_log_msg('After update trigger','Value of source is'||lv_source);
46:

Line 111: FROM ap_invoices_all

107: CURSOR fetch_recpt_num_cur IS
108: SELECT SUBSTR(SUBSTR(invoice_num, INSTR(invoice_num, '-', 1, 1) + 1 ,
109: (INSTR(invoice_num, '-', 1, 2)-1) - INSTR(invoice_num, '-', 1, 1)
110: ),1,30), Source
111: FROM ap_invoices_all
112: WHERE invoice_id = pr_new.Invoice_Id;
113:
114: CURSOR fetch_inv_org_id_cur IS
115: SELECT Inventory_Organization_Id

Line 146: FROM ap_invoices_all

142: ------------Packing Slip---------------------
143: CURSOR vend_info(inv_id NUMBER) IS
144: SELECT vendor_id, vendor_site_id
145: , invoice_type_lookup_code, cancelled_date -- cbabu for Bug# 2560026
146: FROM ap_invoices_all
147: WHERE invoice_id = inv_id;
148:
149: CURSOR set_up_info(ven_id NUMBER, ven_site_id NUMBER, v_org_id NUMBER) IS
150: SELECT pay_on_code, pay_on_receipt_summary_code

Line 220: another ELSIF condition (AP_INVOICES_ALL.invoice_type_lookup_code = 'DEBIT') is added to

216: inserting tax distributions during pay on receipt. And debug code is added to debug whenever
217: there are any issues.
218:
219: 8. 26-NOV-2002 cbabu for Bug# 2560026, Version# 615.2
220: another ELSIF condition (AP_INVOICES_ALL.invoice_type_lookup_code = 'DEBIT') is added to
221: default taxes when debit memo is auto created or matched with a PURCHASE ORDER or RECEIPT.
222: Based on transaction data following two ways are followed.
223:
224: If AP_INVOICES_ALL.source = 'RTS' THEN 'ERS' functionality is invoked Otherwise PO, RECEIPT

Line 224: If AP_INVOICES_ALL.source = 'RTS' THEN 'ERS' functionality is invoked Otherwise PO, RECEIPT

220: another ELSIF condition (AP_INVOICES_ALL.invoice_type_lookup_code = 'DEBIT') is added to
221: default taxes when debit memo is auto created or matched with a PURCHASE ORDER or RECEIPT.
222: Based on transaction data following two ways are followed.
223:
224: If AP_INVOICES_ALL.source = 'RTS' THEN 'ERS' functionality is invoked Otherwise PO, RECEIPT
225: Match functionality is invoked.
226:
227: 9. 23-DEC-2002 cbabu for Bug# 2717471, Version# 615.3
228: functionality is added to default the taxes for debit memo distribution line, when it is

Line 438: UPDATE ap_invoices_all

434: END IF; -- IF v_source IN ( 'ERS','ASBN')
435:
436: /*
437: IF pr_new.attribute11 = 'Y' THEN
438: UPDATE ap_invoices_all
439: SET invoice_amount = invoice_amount + DECODE(pr_new.amount,-1,1,1,-1)
440: WHERE invoice_id = pr_new.invoice_id;
441: END IF;
442: */

Line 741: ELSIF v_source = 'Manual Invoice Entry' THEN -- this code will be fired if v_source (i.e AP_INVOICES_ALL.source) is 'Manual Invoice Entry'

737: -- added, Harshita for Bug 4866533
738: fnd_global.user_id, fnd_global.user_id, sysdate
739: );
740:
741: ELSIF v_source = 'Manual Invoice Entry' THEN -- this code will be fired if v_source (i.e AP_INVOICES_ALL.source) is 'Manual Invoice Entry'
742:
743: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Inside condition of Manual entry');
744:
745: v_rematching := null;