DBA Data[Home] [Help]

APPS.AP_WEB_UTIL_PKG dependencies on PO_VENDORS

Line 100: l_employeeID PO_VENDORS.EMPLOYEE_ID%TYPE := NULL;

96: l_ext_bank_account_id AP_CHECKS_ALL.EXTERNAL_BANK_ACCOUNT_ID%TYPE; -- bug 2426077
97: l_processing_type IBY_PAYMENT_PROFILES.PROCESSING_TYPE%TYPE;
98:
99: l_invoice_type_lookup_code AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
100: l_employeeID PO_VENDORS.EMPLOYEE_ID%TYPE := NULL;
101: l_paid_on_behalf_employee_id AP_INVOICES_ALL.PAID_ON_BEHALF_EMPLOYEE_ID%TYPE := NULL;
102: l_invoiceNumber AP_INVOICES_ALL.INVOICE_NUM%TYPE;
103: l_account IBY_EXT_BANK_ACCOUNTS_V.BANK_ACCOUNT_NUMBER%TYPE := NULL; --1684954
104: l_bankName IBY_EXT_BANK_ACCOUNTS_V.BANK_NAME%TYPE := NULL; --1758619

Line 105: l_cardIssuer PO_VENDORS.VENDOR_NAME%TYPE;

101: l_paid_on_behalf_employee_id AP_INVOICES_ALL.PAID_ON_BEHALF_EMPLOYEE_ID%TYPE := NULL;
102: l_invoiceNumber AP_INVOICES_ALL.INVOICE_NUM%TYPE;
103: l_account IBY_EXT_BANK_ACCOUNTS_V.BANK_ACCOUNT_NUMBER%TYPE := NULL; --1684954
104: l_bankName IBY_EXT_BANK_ACCOUNTS_V.BANK_NAME%TYPE := NULL; --1758619
105: l_cardIssuer PO_VENDORS.VENDOR_NAME%TYPE;
106: l_paidAmount AP_INVOICES_ALL.PAY_CURR_INVOICE_AMOUNT%TYPE;
107:
108: l_flag NUMBER := 0;
109: l_source AP_INVOICES_ALL.SOURCE%TYPE;

Line 114: l_employee_id PO_VENDORS.EMPLOYEE_ID%TYPE := NULL;

110:
111: l_invoiceId AP_INVOICE_PAYMENTS_ALL.INVOICE_ID%TYPE;
112: l_reversalFlag AP_INVOICE_PAYMENTS_ALL.REVERSAL_FLAG%TYPE;
113: l_count NUMBER := 0;
114: l_employee_id PO_VENDORS.EMPLOYEE_ID%TYPE := NULL;
115: l_notify VARCHAR2(1);
116:
117: -- getting invoice by check id
118: CURSOR get_invoice_cur(P_CHECK_ID number) IS

Line 221: SELECT nvl(PV.employee_id,AIA.paid_on_behalf_employee_id) INTO l_employee_id FROM PO_VENDORS PV, AP_INVOICES_ALL AIA

217: -- credit card payment notification is set to 'Y'.
218: fnd_profile.get('SSE_CC_PAYMENT_NOTIFY', l_sse_cc_payment_notify);
219: LogStatement('NotifyEmployeeOnPayment', 'SSE_CC_PAYMENT_NOTIFY ' || l_sse_cc_payment_notify);
220:
221: SELECT nvl(PV.employee_id,AIA.paid_on_behalf_employee_id) INTO l_employee_id FROM PO_VENDORS PV, AP_INVOICES_ALL AIA
222: WHERE PV.vendor_id = AIA.vendor_id AND AIA.invoice_id = l_invoiceId;
223:
224: LogStatement('NotifyEmployeeOnPayment', 'Fetching profile from resp for ' || l_employee_id);
225:

Line 266: PO_VENDORS PV,

262: l_paid_on_behalf_employee_id,
263: l_invoiceNumber,
264: l_cardIssuer
265: FROM
266: PO_VENDORS PV,
267: AP_INVOICES_ALL AIA
268: WHERE
269: PV.vendor_id = AIA.vendor_id
270: AND AIA.invoice_id = l_invoiceId;