APPS.AP_IAW_PKG dependencies on AP_INV_APRVL_HIST_ALL

Line 1481: Update ap_inv_aprvl_hist_all

1477: 'ESC_ROLE_NAME',
1478: l_esc_role);
1479:
1480: --update history for non-responding approver
1481: Update ap_inv_aprvl_hist_all
1482: Set Response = 'ESCALATED'
1483: ,Last_Update_Date = sysdate
1484: ,Last_Updated_By = nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1)
1485: ,Last_Update_Login =

Line 2291: FROM ap_inv_aprvl_hist_all

2287: FROM dual;
2288:
2289: SELECT max(notification_order) + 1
2290: INTO l_not_cnt
2291: FROM ap_inv_aprvl_hist_all
2292: WHERE invoice_id = p_inv_aprvl_hist.invoice_id
2293: AND iteration = p_inv_aprvl_hist.iteration;
2294:
2295: --insert into the history table

Line 2296: INSERT INTO AP_INV_APRVL_HIST_ALL

2292: WHERE invoice_id = p_inv_aprvl_hist.invoice_id
2293: AND iteration = p_inv_aprvl_hist.iteration;
2294:
2295: --insert into the history table
2296: INSERT INTO AP_INV_APRVL_HIST_ALL
2297: (APPROVAL_HISTORY_ID
2298: ,INVOICE_ID
2299: ,ITERATION
2300: ,RESPONSE

Line 2393: FROM ap_inv_aprvl_hist_all

2389: FROM dual;
2390:
2391: SELECT max(nvl(notification_order,0)) + 1
2392: INTO l_not_cnt
2393: FROM ap_inv_aprvl_hist_all
2394: WHERE invoice_id = l_invoice_id
2395: AND iteration = l_iteration;
2396:
2397:

Line 2399: INSERT INTO AP_INV_APRVL_HIST_ALL

2395: AND iteration = l_iteration;
2396:
2397:
2398: --insert into the history table
2399: INSERT INTO AP_INV_APRVL_HIST_ALL
2400: (APPROVAL_HISTORY_ID
2401: ,INVOICE_ID
2402: ,ITERATION
2403: ,RESPONSE

Line 2700: Update ap_inv_aprvl_hist_all

2696:
2697: --update history table status
2698: --If this is an escalation approver, need condition
2699: --to avoid clobbering original approvers record.
2700: Update ap_inv_aprvl_hist_all
2701: Set Response = l_result
2702: ,Approver_Comments = l_comments
2703: ,Last_Update_Date = sysdate
2704: ,Last_Updated_By = l_user_id