APPS.AP_PO_GAPLESS_SBI_PKG dependencies on AP_INVOICES_ALL

Line 10: l_vendor_id AP_INVOICES_ALL.vendor_id%TYPE;

6: p_selling_co_id IN VARCHAR2)
7:
8: RETURN BOOLEAN IS
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;

Line 12: l_dup_invoices AP_INVOICES_ALL.invoice_num%TYPE;

8: RETURN BOOLEAN IS
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

Line 28: -- Checking for duplicates in AP_INVOICES_ALL table

24: FROM PO_VENDOR_SITES
25: WHERE selling_company_identifier = p_selling_co_id
26: AND rownum = 1;
27:
28: -- Checking for duplicates in AP_INVOICES_ALL table
29:
30: Begin
31: SELECT invoice_num
32: INTO l_dup_invoices

Line 33: FROM AP_INVOICES_ALL

29:
30: Begin
31: SELECT invoice_num
32: INTO l_dup_invoices
33: FROM AP_INVOICES_ALL
34: WHERE invoice_num = p_invoice_num
35: AND vendor_id = l_vendor_id
36: AND org_id = l_org_id;
37: Exception