APPS.AP_IAW_PKG dependencies on AP_LINE_APRVL_HIST_ALL

Line 1621: Update ap_line_aprvl_hist_all

1617: 'ESC_ROLE_NAME',
1618: l_esc_role);
1619:
1620: --update history for non-responding approver
1621: Update ap_line_aprvl_hist_all
1622: Set Response = 'ESCALATED'
1623: ,Last_Update_Date = sysdate
1624: ,Last_Updated_By = nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1)
1625: ,Last_Update_Login =

Line 2761: Update ap_line_aprvl_hist_all

2757:
2758: --update line history table status
2759: --If this is an escalation approver, need
2760: --condition to avoid clobbering original approvers record.
2761: Update ap_line_aprvl_hist_all
2762: Set Response = p_response
2763: ,Approver_Comments = p_comments
2764: ,Last_Update_Date = sysdate
2765: ,Last_Updated_By = -1

Line 2843: Update ap_line_aprvl_hist_all

2839:
2840: --update line history table status
2841: --If this is an escalation approver, need
2842: --condition to avoid clobbering original approvers record.
2843: Update ap_line_aprvl_hist_all
2844: Set Response = l_result
2845: ,Approver_Comments = l_comments
2846: ,Last_Update_Date = sysdate
2847: ,Last_Updated_By = l_user_id

Line 2930: FROM AP_LINE_APRVL_HIST_ALL

2926:
2927: --Define cursor for this line's history records
2928: CURSOR Item_Cur IS
2929: SELECT Item_Class, Item_Id
2930: FROM AP_LINE_APRVL_HIST_ALL
2931: WHERE Invoice_ID = p_invoice_id
2932: AND Line_Number = p_line_num
2933: GROUP BY Item_Class, Item_Id;
2934: