DBA Data[Home] [Help]

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: BEGIN
20: SELECT AP_INV_APRVL_HIST_S.nextval
21: INTO l_hist_id

Line 24: INSERT INTO AP_INV_APRVL_HIST_ALL

20: SELECT AP_INV_APRVL_HIST_S.nextval
21: INTO l_hist_id
22: FROM dual;
23: --insert into the history table
24: INSERT INTO AP_INV_APRVL_HIST_ALL
25: (APPROVAL_HISTORY_ID
26: ,HISTORY_TYPE
27: ,INVOICE_ID
28: ,ITERATION

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

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

Line 6039: l_response ap_inv_aprvl_hist_all.response%TYPE;

6035: l_org_id NUMBER(15);
6036: l_line_number ap_invoice_lines_all.line_number%TYPE;
6037: l_line_amount ap_invoice_lines_all.amount%TYPE;
6038: l_notf_iteration NUMBER;
6039: l_response ap_inv_aprvl_hist_all.response%TYPE;
6040: l_sent NUMBER;
6041: BEGIN
6042: l_debug_info := 'Start';
6043: l_sent := 0;