APPS.AP_WFAPPROVAL_PKG dependencies on AP_INV_APRVL_HIST

Line 264: FROM ap_inv_aprvl_hist

260:
261: --check for prior approvers
262: SELECT count(*)
263: INTO l_count
264: FROM ap_inv_aprvl_hist
265: WHERE invoice_id = l_invoice_id
266: AND iteration = l_iteration
267: AND RESPONSE <> 'MANUALLY APPROVED';
268:

Line 446: UPDATE AP_INV_APRVL_HIST

442: l_result := 'WFAPPROVED';
443: END IF;
444:
445: --update the history table
446: UPDATE AP_INV_APRVL_HIST
447: SET RESPONSE = l_result,
448: APPROVER_COMMENTS = l_comments,
449: AMOUNT_APPROVED = l_amount,
450: LAST_UPDATE_DATE = sysdate,

Line 523: SELECT AP_INV_APRVL_HIST_S.nextval

519:
520: --Now set the environment
521: fnd_client_info.set_org_context(l_org_id);
522:
523: SELECT AP_INV_APRVL_HIST_S.nextval
524: INTO l_hist_id
525: FROM dual;
526:
527: --insert into the history table

Line 528: INSERT INTO AP_INV_APRVL_HIST

524: INTO l_hist_id
525: FROM dual;
526:
527: --insert into the history table
528: INSERT INTO AP_INV_APRVL_HIST
529: (APPROVAL_HISTORY_ID
530: ,INVOICE_ID
531: ,ITERATION
532: ,RESPONSE

Line 578: SELECT AP_INV_APRVL_HIST_S.nextval

574: l_hist_id NUMBER;
575: l_amount ap_invoices_all.invoice_amount%TYPE;
576: BEGIN
577: --insert into the history table
578: SELECT AP_INV_APRVL_HIST_S.nextval
579: INTO l_hist_id
580: FROM dual;
581:
582: SELECT invoice_amount

Line 587: INSERT INTO AP_INV_APRVL_HIST

583: INTO l_amount
584: FROM AP_INVOICES_ALL
585: WHERE invoice_id = p_invoice_id;
586:
587: INSERT INTO AP_INV_APRVL_HIST
588: (APPROVAL_HISTORY_ID
589: ,INVOICE_ID
590: ,ITERATION
591: ,RESPONSE

Line 697: UPDATE AP_INV_APRVL_HIST

693: transactionTypeIn => 'APINV',
694: forwardeeIn => l_esc_approver);
695:
696: --update the history table
697: UPDATE AP_INV_APRVL_HIST
698: SET RESPONSE = 'ESCALATED'
699: WHERE APPROVAL_HISTORY_ID = l_hist_id;
700:
701: WF_DIRECTORY.GetRoleName('PER',l_manager_id,l_role,l_role_display);

Line 1141: UPDATE ap_inv_aprvl_hist_all

1137: p_invoice_id IN ap_invoices_all.invoice_id%TYPE) IS
1138:
1139: PRAGMA autonomous_transaction;
1140: BEGIN
1141: UPDATE ap_inv_aprvl_hist_all
1142: SET RESPONSE ='CANCELLED'
1143: WHERE invoice_id = p_invoice_id
1144: AND response ='PENDING';
1145: commit;