APPS.AP_WEB_UTIL_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 78: -- trigger AP_SSE_NOTIFY_EMPLOYEE on table AP_INVOICE_PAYMENTS_ALL.

74: --
75: -- This API notifies the employee, when payments are made to employee
76: -- or credit card company in behalf of the employee, based on the
77: -- sse_cc_payment_notify profile option. This replaces the AFTER INSERT
78: -- trigger AP_SSE_NOTIFY_EMPLOYEE on table AP_INVOICE_PAYMENTS_ALL.
79: -- Introduced as part of the bugfix 9557247
80: ------------------------------------------------------------------------
81: PROCEDURE NotifyEmployeeOnPayment (P_Event_Type IN VARCHAR2,
82: P_Check_ID IN NUMBER,

Line 111: l_invoiceId AP_INVOICE_PAYMENTS_ALL.INVOICE_ID%TYPE;

107:
108: l_flag NUMBER := 0;
109: l_source AP_INVOICES_ALL.SOURCE%TYPE;
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);

Line 112: l_reversalFlag AP_INVOICE_PAYMENTS_ALL.REVERSAL_FLAG%TYPE;

108: l_flag NUMBER := 0;
109: l_source AP_INVOICES_ALL.SOURCE%TYPE;
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:

Line 120: from AP_INVOICE_PAYMENTS_ALL

116:
117: -- getting invoice by check id
118: CURSOR get_invoice_cur(P_CHECK_ID number) IS
119: select invoice_id,amount,reversal_flag
120: from AP_INVOICE_PAYMENTS_ALL
121: where check_id = P_CHECK_ID;
122:
123: BEGIN
124: