DBA Data[Home] [Help]

APPS.AP_WEB_UTIL_PKG dependencies on AP_CHECKS_ALL

Line 91: l_checkNumber AP_CHECKS_ALL.CHECK_NUMBER%TYPE;

87: l_debug_info VARCHAR2(1000);
88:
89: l_sse_cc_payment_notify VARCHAR2(1);
90:
91: l_checkNumber AP_CHECKS_ALL.CHECK_NUMBER%TYPE;
92: l_paymentCurrency AP_CHECKS_ALL.CURRENCY_CODE%TYPE;
93: l_paymentDate AP_CHECKS_ALL.CHECK_DATE%TYPE;
94: l_paymentMethod AP_CHECKS_ALL.PAYMENT_METHOD_LOOKUP_CODE%TYPE := NULL;
95: l_paymentProfileId AP_CHECKS_ALL.PAYMENT_PROFILE_ID%TYPE := NULL;

Line 92: l_paymentCurrency AP_CHECKS_ALL.CURRENCY_CODE%TYPE;

88:
89: l_sse_cc_payment_notify VARCHAR2(1);
90:
91: l_checkNumber AP_CHECKS_ALL.CHECK_NUMBER%TYPE;
92: l_paymentCurrency AP_CHECKS_ALL.CURRENCY_CODE%TYPE;
93: l_paymentDate AP_CHECKS_ALL.CHECK_DATE%TYPE;
94: l_paymentMethod AP_CHECKS_ALL.PAYMENT_METHOD_LOOKUP_CODE%TYPE := NULL;
95: l_paymentProfileId AP_CHECKS_ALL.PAYMENT_PROFILE_ID%TYPE := NULL;
96: l_ext_bank_account_id AP_CHECKS_ALL.EXTERNAL_BANK_ACCOUNT_ID%TYPE; -- bug 2426077

Line 93: l_paymentDate AP_CHECKS_ALL.CHECK_DATE%TYPE;

89: l_sse_cc_payment_notify VARCHAR2(1);
90:
91: l_checkNumber AP_CHECKS_ALL.CHECK_NUMBER%TYPE;
92: l_paymentCurrency AP_CHECKS_ALL.CURRENCY_CODE%TYPE;
93: l_paymentDate AP_CHECKS_ALL.CHECK_DATE%TYPE;
94: l_paymentMethod AP_CHECKS_ALL.PAYMENT_METHOD_LOOKUP_CODE%TYPE := NULL;
95: l_paymentProfileId AP_CHECKS_ALL.PAYMENT_PROFILE_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;

Line 94: l_paymentMethod AP_CHECKS_ALL.PAYMENT_METHOD_LOOKUP_CODE%TYPE := NULL;

90:
91: l_checkNumber AP_CHECKS_ALL.CHECK_NUMBER%TYPE;
92: l_paymentCurrency AP_CHECKS_ALL.CURRENCY_CODE%TYPE;
93: l_paymentDate AP_CHECKS_ALL.CHECK_DATE%TYPE;
94: l_paymentMethod AP_CHECKS_ALL.PAYMENT_METHOD_LOOKUP_CODE%TYPE := NULL;
95: l_paymentProfileId AP_CHECKS_ALL.PAYMENT_PROFILE_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:

Line 95: l_paymentProfileId AP_CHECKS_ALL.PAYMENT_PROFILE_ID%TYPE := NULL;

91: l_checkNumber AP_CHECKS_ALL.CHECK_NUMBER%TYPE;
92: l_paymentCurrency AP_CHECKS_ALL.CURRENCY_CODE%TYPE;
93: l_paymentDate AP_CHECKS_ALL.CHECK_DATE%TYPE;
94: l_paymentMethod AP_CHECKS_ALL.PAYMENT_METHOD_LOOKUP_CODE%TYPE := NULL;
95: l_paymentProfileId AP_CHECKS_ALL.PAYMENT_PROFILE_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;

Line 96: l_ext_bank_account_id AP_CHECKS_ALL.EXTERNAL_BANK_ACCOUNT_ID%TYPE; -- bug 2426077

92: l_paymentCurrency AP_CHECKS_ALL.CURRENCY_CODE%TYPE;
93: l_paymentDate AP_CHECKS_ALL.CHECK_DATE%TYPE;
94: l_paymentMethod AP_CHECKS_ALL.PAYMENT_METHOD_LOOKUP_CODE%TYPE := NULL;
95: l_paymentProfileId AP_CHECKS_ALL.PAYMENT_PROFILE_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;

Line 151: FROM AP_CHECKS_ALL

147: l_paymentCurrency,
148: l_paymentDate,
149: l_paymentProfileId,
150: l_ext_bank_account_id -- bug 2426077
151: FROM AP_CHECKS_ALL
152: WHERE check_id = P_Check_ID;
153:
154: LogStatement('NotifyEmployeeOnPayment', 'Getting Payment Processing Type for Profile ' || l_paymentProfileId);
155: if (l_paymentProfileId is not null) then -- Bug 7118709(sodash)