APPS.PA_AP_VAL_PKG dependencies on AP_INVOICES_ALL

Line 22: Procedure validate_unprocessed_ded ( invoice_id IN ap_invoices_all.invoice_id%type,

18: -- Parameters Type Required Description
19: -- invoice_id NUMBER YES invoice_id being validated
20: -- cmt_exist_flag VARCHAR returns whether unprocessed dedns exist
21: ----------------------------------------------------------------------------------------------------------*/
22: Procedure validate_unprocessed_ded ( invoice_id IN ap_invoices_all.invoice_id%type,
23: cmt_exist_flag OUT NOCOPY VARCHAR2)
24: IS
25:
26: --Cursor check_cmt_exist will check the number of deductions that have not yet

Line 31: cursor check_cmt_exist(p_invoice_id ap_invoices_all.invoice_id%type) is

27: --resulted in a debit memo in payables. It will include the deductions
28: --in working,submitted statuses as well.
29:
30:
31: cursor check_cmt_exist(p_invoice_id ap_invoices_all.invoice_id%type) is
32: select 1 from pa_deductions_all
33: where not exists
34: (select 1 from ap_invoices_all
35: where source = 'Oracle Project Accounting'

Line 34: (select 1 from ap_invoices_all

30:
31: cursor check_cmt_exist(p_invoice_id ap_invoices_all.invoice_id%type) is
32: select 1 from pa_deductions_all
33: where not exists
34: (select 1 from ap_invoices_all
35: where source = 'Oracle Project Accounting'
36: AND invoice_type_lookup_code = 'DEBIT'
37: AND product_table='PA_DEDUCTIONS_ALL'
38: and deduction_req_id = to_number(reference_key1))

Line 40: from ap_invoices_all inv, ap_invoice_distributions_all apd

36: AND invoice_type_lookup_code = 'DEBIT'
37: AND product_table='PA_DEDUCTIONS_ALL'
38: and deduction_req_id = to_number(reference_key1))
39: and (vendor_id, project_id) in (select inv.vendor_id, apd.project_id
40: from ap_invoices_all inv, ap_invoice_distributions_all apd
41: where inv.invoice_id =p_invoice_id
42: and inv.invoice_id=apd.invoice_id);
43:
44:

Line 45: l_invoice_id ap_invoices_all.invoice_id%type;

41: where inv.invoice_id =p_invoice_id
42: and inv.invoice_id=apd.invoice_id);
43:
44:
45: l_invoice_id ap_invoices_all.invoice_id%type;
46: l_count NUMBER;
47:
48: BEGIN
49: