APPS.AP_PO_GAPLESS_SBI_PKG dependencies on AP_INVOICES_INTERFACE

Line 13: l_dup_interface AP_INVOICES_INTERFACE.invoice_num%TYPE;

9:
10: l_vendor_id AP_INVOICES_ALL.vendor_id%TYPE;
11: l_org_id number(15);
12: l_dup_invoices AP_INVOICES_ALL.invoice_num%TYPE;
13: l_dup_interface AP_INVOICES_INTERFACE.invoice_num%TYPE;
14: l_dup_history AP_HISTORY_INVOICES_ALL.invoice_num%TYPE;
15:
16: BEGIN
17:

Line 42: -- Checking for duplicates in AP_INVOICES_INTERFACE table

38: When NO_DATA_FOUND Then
39: l_dup_invoices := Null;
40: End;
41:
42: -- Checking for duplicates in AP_INVOICES_INTERFACE table
43:
44: IF l_dup_invoices is Null THEN
45: Begin
46:

Line 49: FROM AP_INVOICES_INTERFACE

45: Begin
46:
47: SELECT invoice_num
48: INTO l_dup_interface
49: FROM AP_INVOICES_INTERFACE
50: WHERE invoice_num = p_invoice_num
51: AND vendor_id = l_vendor_id
52: AND status <> 'PROCESSED'
53: AND rownum = 1;