DBA Data[Home] [Help]

APPS.AP_PAY_IN_FULL_PKG dependencies on AP_SUPPLIERS

Line 25: P_vendor_id OUT NOCOPY AP_SUPPLIERS.VENDOR_ID%TYPE, --NUMBER,

21: P_invoice_id_list IN VARCHAR2,
22: P_payment_num_list IN VARCHAR2,
23: P_currency_code OUT NOCOPY VARCHAR2,
24: P_payment_method OUT NOCOPY AP_PAYMENT_SCHEDULES.PAYMENT_METHOD_CODE%TYPE, --VARCHAR2,
25: P_vendor_id OUT NOCOPY AP_SUPPLIERS.VENDOR_ID%TYPE, --NUMBER,
26: P_vendor_site_id OUT NOCOPY AP_SUPPLIER_SITES.VENDOR_SITE_ID%TYPE, --NUMBER,
27: P_party_id OUT NOCOPY AP_SUPPLIERS.PARTY_ID%TYPE, --NUMBER,
28: P_party_site_id OUT NOCOPY AP_SUPPLIER_SITES.PARTY_SITE_ID%TYPE, --NUMBER,
29: P_org_id OUT NOCOPY NUMBER,

Line 27: P_party_id OUT NOCOPY AP_SUPPLIERS.PARTY_ID%TYPE, --NUMBER,

23: P_currency_code OUT NOCOPY VARCHAR2,
24: P_payment_method OUT NOCOPY AP_PAYMENT_SCHEDULES.PAYMENT_METHOD_CODE%TYPE, --VARCHAR2,
25: P_vendor_id OUT NOCOPY AP_SUPPLIERS.VENDOR_ID%TYPE, --NUMBER,
26: P_vendor_site_id OUT NOCOPY AP_SUPPLIER_SITES.VENDOR_SITE_ID%TYPE, --NUMBER,
27: P_party_id OUT NOCOPY AP_SUPPLIERS.PARTY_ID%TYPE, --NUMBER,
28: P_party_site_id OUT NOCOPY AP_SUPPLIER_SITES.PARTY_SITE_ID%TYPE, --NUMBER,
29: P_org_id OUT NOCOPY NUMBER,
30: P_payment_function OUT NOCOPY AP_INVOICES.PAYMENT_FUNCTION%TYPE, --VARCHAR2, -- 4965233
31: P_proc_trxn_type OUT NOCOPY AP_INVOICES.PAY_PROC_TRXN_TYPE_CODE%TYPE, --VARCHAR2, -- 4965233

Line 35: P_remit_vendor_id OUT NOCOPY AP_SUPPLIERS.VENDOR_ID%TYPE, --NUMBER,

31: P_proc_trxn_type OUT NOCOPY AP_INVOICES.PAY_PROC_TRXN_TYPE_CODE%TYPE, --VARCHAR2, -- 4965233
32: P_num_payments OUT NOCOPY NUMBER,
33: P_le_id OUT NOCOPY NUMBER, -- 5617689
34: --Added below variables for the bug 7662240
35: P_remit_vendor_id OUT NOCOPY AP_SUPPLIERS.VENDOR_ID%TYPE, --NUMBER,
36: P_remit_vendor_site_id OUT NOCOPY AP_SUPPLIER_SITES.VENDOR_SITE_ID%TYPE, --NUMBER,
37: P_remit_party_id OUT NOCOPY AP_SUPPLIERS.PARTY_ID%TYPE, --NUMBER,
38: P_remit_party_site_id OUT NOCOPY AP_SUPPLIER_SITES.PARTY_SITE_ID%TYPE, --NUMBER,
39: P_remit_vendor_name OUT NOCOPY AP_SUPPLIERS.VENDOR_NAME%TYPE, --VARCHAR2,

Line 37: P_remit_party_id OUT NOCOPY AP_SUPPLIERS.PARTY_ID%TYPE, --NUMBER,

33: P_le_id OUT NOCOPY NUMBER, -- 5617689
34: --Added below variables for the bug 7662240
35: P_remit_vendor_id OUT NOCOPY AP_SUPPLIERS.VENDOR_ID%TYPE, --NUMBER,
36: P_remit_vendor_site_id OUT NOCOPY AP_SUPPLIER_SITES.VENDOR_SITE_ID%TYPE, --NUMBER,
37: P_remit_party_id OUT NOCOPY AP_SUPPLIERS.PARTY_ID%TYPE, --NUMBER,
38: P_remit_party_site_id OUT NOCOPY AP_SUPPLIER_SITES.PARTY_SITE_ID%TYPE, --NUMBER,
39: P_remit_vendor_name OUT NOCOPY AP_SUPPLIERS.VENDOR_NAME%TYPE, --VARCHAR2,
40: P_remit_vendor_site_name OUT NOCOPY AP_SUPPLIER_SITES.VENDOR_SITE_CODE%TYPE, --VARCHAR2,
41: P_calling_sequence IN VARCHAR2,

Line 39: P_remit_vendor_name OUT NOCOPY AP_SUPPLIERS.VENDOR_NAME%TYPE, --VARCHAR2,

35: P_remit_vendor_id OUT NOCOPY AP_SUPPLIERS.VENDOR_ID%TYPE, --NUMBER,
36: P_remit_vendor_site_id OUT NOCOPY AP_SUPPLIER_SITES.VENDOR_SITE_ID%TYPE, --NUMBER,
37: P_remit_party_id OUT NOCOPY AP_SUPPLIERS.PARTY_ID%TYPE, --NUMBER,
38: P_remit_party_site_id OUT NOCOPY AP_SUPPLIER_SITES.PARTY_SITE_ID%TYPE, --NUMBER,
39: P_remit_vendor_name OUT NOCOPY AP_SUPPLIERS.VENDOR_NAME%TYPE, --VARCHAR2,
40: P_remit_vendor_site_name OUT NOCOPY AP_SUPPLIER_SITES.VENDOR_SITE_CODE%TYPE, --VARCHAR2,
41: P_calling_sequence IN VARCHAR2,
42: --Added below parameter for 7688200
43: p_relationship_id OUT NOCOPY NUMBER)

Line 207: FROM AP_SUPPLIERS APS, AP_SUPPLIER_SITES APSS

203: );
204:
205: SELECT APS.vendor_id, APS.vendor_name, APSS.party_site_id, APSS.vendor_site_code
206: INTO p_remit_vendor_id, p_remit_vendor_name, p_remit_party_site_id, p_remit_vendor_site_name
207: FROM AP_SUPPLIERS APS, AP_SUPPLIER_SITES APSS
208: WHERE APS.party_id = p_remit_party_id
209: AND APS.vendor_id =APSS.vendor_id
210: AND APSS.vendor_site_id = p_remit_vendor_site_id;
211: