APPS.AP_WORKFLOW_PKG dependencies on AP_INV_APRVL_HIST_ALL

Line 17: l_hist_id AP_INV_APRVL_HIST_ALL.APPROVAL_HISTORY_ID%TYPE;

13: -- Procedure Definitions
14: PROCEDURE insert_history_table(p_hist_rec IN AP_INV_APRVL_HIST%ROWTYPE) IS
15: l_api_name CONSTANT VARCHAR2(200) := 'insert_history_table';
16: l_debug_info VARCHAR2(2000);
17: l_hist_id AP_INV_APRVL_HIST_ALL.APPROVAL_HISTORY_ID%TYPE;
18: l_iteration NUMBER;
19:
20: -- Bug 9861713 PRAGMA AUTONOMOUS_TRANSACTION; bug 8450681
21: BEGIN

Line 27: INSERT INTO AP_INV_APRVL_HIST_ALL

23: INTO l_hist_id
24: FROM dual;
25:
26: --insert into the history table
27: INSERT INTO AP_INV_APRVL_HIST_ALL
28: (APPROVAL_HISTORY_ID
29: ,HISTORY_TYPE
30: ,INVOICE_ID
31: ,ITERATION

Line 65: l_debug_info := 'After Insert into AP_INV_APRVL_HIST_ALL';

61: ,p_hist_rec.HOLD_ID
62: ,p_hist_rec.LINE_NUMBER
63: ,p_hist_rec.APPROVER_COMMENTS
64: ,p_hist_rec.NOTIFICATION_ORDER);
65: l_debug_info := 'After Insert into AP_INV_APRVL_HIST_ALL';
66: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
67: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
68: l_debug_info);
69: END IF;

Line 6306: l_response ap_inv_aprvl_hist_all.response%TYPE;

6302: l_org_id NUMBER(15);
6303: l_line_number ap_invoice_lines_all.line_number%TYPE;
6304: l_line_amount ap_invoice_lines_all.amount%TYPE;
6305: l_notf_iteration NUMBER;
6306: l_response ap_inv_aprvl_hist_all.response%TYPE;
6307: l_sent NUMBER;
6308: BEGIN
6309: l_debug_info := 'Start';
6310: l_sent := 0;