eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WORKFLOW_PKG dependencies on AP_INV_APRVL_HIST

Line 14: PROCEDURE insert_history_table(p_hist_rec IN AP_INV_APRVL_HIST%ROWTYPE) IS

10:
11: -- Public Procedure Specifications
12:
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;

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 22: SELECT AP_INV_APRVL_HIST_S.nextval

18: l_iteration NUMBER;
19:
20: -- Bug 9861713 PRAGMA AUTONOMOUS_TRANSACTION; bug 8450681
21: BEGIN
22: SELECT AP_INV_APRVL_HIST_S.nextval
23: INTO l_hist_id
24: FROM dual;
25:
26: --insert into the history table

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 182: l_hist_id AP_INV_APRVL_HIST.APPROVAL_HISTORY_ID%TYPE;

178: l_org_id NUMBER;
179: l_role VARCHAR2(50);
180: l_role_display VARCHAR2(150);
181: l_display_name VARCHAR2(150);
182: l_hist_id AP_INV_APRVL_HIST.APPROVAL_HISTORY_ID%TYPE;
183: l_name wf_users.name%TYPE; --bug 8620671
184: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
185: l_iteration NUMBER;
186: l_notf_iteration NUMBER;

Line 184: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

180: l_role_display VARCHAR2(150);
181: l_display_name VARCHAR2(150);
182: l_hist_id AP_INV_APRVL_HIST.APPROVAL_HISTORY_ID%TYPE;
183: l_name wf_users.name%TYPE; --bug 8620671
184: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
185: l_iteration NUMBER;
186: l_notf_iteration NUMBER;
187:
188:

Line 390: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

386: l_invoice_id NUMBER;
387: l_hold_id NUMBER;
388: l_approver_id NUMBER;
389: l_display_name VARCHAR2(150);
390: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
391: l_api_name CONSTANT VARCHAR2(200) := 'process_ack_pomatched';
392: l_debug_info VARCHAR2(2000);
393: l_iteration NUMBER;
394: l_notf_iteration NUMBER;

Line 491: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

487: l_invoice_id NUMBER;
488: l_hold_id NUMBER;
489: l_approver_id NUMBER;
490: l_display_name VARCHAR2(150);
491: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
492: l_api_name CONSTANT VARCHAR2(200) := 'process_rel_pomatched';
493: l_debug_info VARCHAR2(2000);
494: l_iteration NUMBER;
495: l_notf_iteration NUMBER;

Line 598: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

594: l_invoice_id NUMBER;
595: l_hold_id NUMBER;
596: l_approver_id NUMBER;
597: l_display_name VARCHAR2(150);
598: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
599: l_api_name CONSTANT VARCHAR2(200) := 'process_ack_pounmatched';
600: l_debug_info VARCHAR2(2000);
601: l_iteration NUMBER;
602: l_notf_iteration NUMBER;

Line 699: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

695: l_invoice_id NUMBER;
696: l_hold_id NUMBER;
697: l_approver_id NUMBER;
698: l_display_name VARCHAR2(150);
699: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
700: l_api_name CONSTANT VARCHAR2(200) := 'process_rel_pounmatched';
701: l_debug_info VARCHAR2(2000);
702: l_iteration NUMBER;
703: l_notf_iteration NUMBER;

Line 848: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

844: l_hold_id NUMBER;
845: l_approver_id NUMBER;
846: l_internal_approver_id NUMBER;
847: l_display_name VARCHAR2(150);
848: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
849: l_api_name CONSTANT VARCHAR2(200) := 'process_accept_ext';
850: l_debug_info VARCHAR2(2000);
851: l_parentkey VARCHAR2(50);
852: l_iteration NUMBER;

Line 1000: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

996: l_invoice_id NUMBER;
997: l_hold_id NUMBER;
998: l_approver_id NUMBER;
999: l_display_name VARCHAR2(150);
1000: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
1001: l_api_name CONSTANT VARCHAR2(200) := 'process_cancel_inv_by_sup';
1002: l_debug_info VARCHAR2(2000);
1003: l_parentkey VARCHAR2(50);
1004: l_result BOOLEAN;

Line 1167: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

1163: l_invoice_id NUMBER;
1164: l_hold_id NUMBER;
1165: l_approver_id NUMBER;
1166: l_display_name VARCHAR2(150);
1167: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
1168: l_api_name CONSTANT VARCHAR2(200) := 'process_accept_int';
1169: l_debug_info VARCHAR2(2000);
1170: l_parentkey VARCHAR2(50);
1171: l_iteration NUMBER;

Line 1307: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

1303:
1304: l_result ame_util.stringlist;
1305: l_reason ame_util.stringlist;
1306: l_invoice_id NUMBER;
1307: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
1308: l_tr_reason VARCHAR2(240);
1309: l_api_name CONSTANT VARCHAR2(200) := 'Check_Header_Requirements';
1310: l_org_id NUMBER;
1311: l_rejected_check BOOLEAN := FALSE;

Line 1566: l_l_hist AP_INV_APRVL_HIST%ROWTYPE;

1562:
1563: l_result ame_util.stringlist;
1564: l_reason ame_util.stringlist;
1565: l_invoice_id NUMBER;
1566: l_l_hist AP_INV_APRVL_HIST%ROWTYPE;
1567: l_tr_reason VARCHAR2(240);
1568: l_api_name CONSTANT VARCHAR2(200) := 'Check_Line_Requirements';
1569: l_org_id NUMBER;
1570: l_required_check BOOLEAN := TRUE;

Line 1797: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

1793: l_api_name CONSTANT VARCHAR2(200) := 'Get_Approvers';
1794: l_iteration NUMBER;
1795: l_debug_info VARCHAR2(2000);
1796: l_org_id NUMBER;
1797: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
1798:
1799: BEGIN
1800: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1801: FND_LOG.STRING(G_LEVEL_PROCEDURE,

Line 2958: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

2954: l_user_id NUMBER(15);
2955: l_login_id NUMBER(15);
2956: l_api_name CONSTANT VARCHAR2(200) := 'process_doc_rejection';
2957: l_debug_info VARCHAR2(2000);
2958: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
2959: l_approver_name VARCHAR2(150);
2960: l_approver_id NUMBER;
2961: l_esc_flag VARCHAR2(1);
2962: l_esc_approver_name VARCHAR2(150);

Line 3115: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

3111: l_user_id NUMBER(15);
3112: l_login_id NUMBER(15);
3113: l_api_name CONSTANT VARCHAR2(200) := 'process_doc_approval';
3114: l_debug_info VARCHAR2(2000);
3115: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
3116: l_approver_name VARCHAR2(150);
3117: l_approver_id NUMBER;
3118: l_esc_flag VARCHAR2(1);
3119: l_esc_approver_name VARCHAR2(150);

Line 3317: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

3313: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
3314: l_debug_info VARCHAR2(2000);
3315: l_user_id NUMBER(15);
3316: l_login_id NUMBER(15);
3317: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
3318: l_approver_name VARCHAR2(150);
3319: l_approver_id NUMBER;
3320: l_esc_flag VARCHAR2(1);
3321: l_esc_approver_name VARCHAR2(150);

Line 3551: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

3547: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
3548: l_debug_info VARCHAR2(2000);
3549: l_user_id NUMBER(15);
3550: l_login_id NUMBER(15);
3551: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
3552: l_approver_name VARCHAR2(150);
3553: l_approver_id NUMBER;
3554: l_esc_flag VARCHAR2(1);
3555: l_esc_approver_name VARCHAR2(150);

Line 3867: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

3863: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
3864: l_debug_info VARCHAR2(2000);
3865: l_user_id NUMBER(15);
3866: l_login_id NUMBER(15);
3867: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
3868: l_approver_name VARCHAR2(150);
3869: l_approver_id NUMBER;
3870: l_role_name VARCHAR2(150);
3871: l_role VARCHAR2(150);

Line 4044: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

4040: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
4041: l_debug_info VARCHAR2(2000);
4042: l_user_id NUMBER(15);
4043: l_login_id NUMBER(15);
4044: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
4045: l_approver_name VARCHAR2(150);
4046: l_approver_id NUMBER;
4047: l_role_name VARCHAR2(150);
4048: l_role VARCHAR2(150);

Line 4206: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

4202: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
4203: l_debug_info VARCHAR2(2000);
4204: l_user_id NUMBER(15);
4205: l_login_id NUMBER(15);
4206: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
4207: l_approver_name VARCHAR2(150);
4208: l_approver_id NUMBER;
4209: l_role_name VARCHAR2(150);
4210: l_role VARCHAR2(150);

Line 4443: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

4439: l_role VARCHAR2(50);
4440: l_role_display VARCHAR2(150);
4441: l_new_child_ItemKey VARCHAR2(30);
4442: l_person_id NUMBER(15);
4443: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
4444: l_notf_receipient_type VARCHAR2(50);
4445: l_iteration NUMBER;
4446: l_notf_iteration NUMBER;
4447: l_ext_person_id NUMBER(15);

Line 4816: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

4812: l_error_message VARCHAR2(2000);
4813: l_invoice_id NUMBER(15);
4814: l_iteration NUMBER(9);
4815: l_count NUMBER(9);
4816: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
4817: l_notf_iteration NUMBER;
4818: l_complete VARCHAR2(1);
4819: l_next_approvers ame_util.approversTable2;
4820: l_next_approver ame_util.approverRecord2;

Line 4909: FROM ap_inv_aprvl_hist

4905:
4906: --check for prior approvers
4907: SELECT count(*)
4908: INTO l_count
4909: FROM ap_inv_aprvl_hist
4910: WHERE invoice_id = l_invoice_id
4911: AND iteration = l_iteration
4912: AND RESPONSE <> 'MANUALLY APPROVED'
4913: AND history_type = 'DOCUMENTAPPROVAL';

Line 5128: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

5124: 'escalate_doc_approval';
5125: l_debug_info VARCHAR2(2000);
5126: l_iteration NUMBER;
5127: l_invoice_total NUMBER;
5128: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
5129: l_notf_iteration NUMBER;
5130: -- bug 8450681 begin
5131: l_display_name VARCHAR2(150);
5132: l_next_approvers ame_util.approversTable2;

Line 5336: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

5332: l_item_class VARCHAR2(50);
5333: l_item_id NUMBER;
5334: l_line_number ap_invoice_lines_all.line_number%TYPE;
5335: l_line_amount ap_invoice_lines_all.amount%TYPE;
5336: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
5337: l_comments VARCHAR2(240);
5338: l_esc_flag VARCHAR2(1);
5339: l_invoice_key VARCHAR2(50);
5340: l_notf_iteration NUMBER;

Line 5639: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

5635: l_role VARCHAR2(50);
5636: l_role_display VARCHAR2(150);
5637: l_new_child_ItemKey VARCHAR2(30);
5638: l_person_id NUMBER(15);
5639: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
5640: l_notf_receipient_type VARCHAR2(50);
5641: l_iteration NUMBER;
5642: l_notf_iteration NUMBER;
5643: l_invoice_key VARCHAR2(50);

Line 6290: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

6286: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
6287: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
6288: l_user_id NUMBER(15);
6289: l_login_id NUMBER(15);
6290: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
6291: l_approver_name VARCHAR2(150);
6292: l_approver_id NUMBER;
6293: l_esc_flag VARCHAR2(1);
6294: l_esc_approver_name VARCHAR2(150);

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;

Line 7907: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

7903: l_hist_id NUMBER(15);
7904: l_amount ap_invoices_all.invoice_amount%TYPE;
7905: l_user_id NUMBER(15);
7906: l_login_id NUMBER(15);
7907: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
7908: l_notf_iteration NUMBER;
7909: l_role_name VARCHAR2(50);
7910: l_esc_flag VARCHAR2(1);
7911: l_esc_role VARCHAR2(50);

Line 7924: From ap_inv_aprvl_hist

7920: WHERE USER_NAME=p_rec_role;
7921:
7922: CURSOR c_get_response ( p_invoice_id IN NUMBER) IS
7923: Select response
7924: From ap_inv_aprvl_hist
7925: WHERE approval_history_id=(select max(approval_history_id)from ap_inv_aprvl_hist
7926: where invoice_id= p_invoice_id);
7927:
7928: BEGIN

Line 7925: WHERE approval_history_id=(select max(approval_history_id)from ap_inv_aprvl_hist

7921:
7922: CURSOR c_get_response ( p_invoice_id IN NUMBER) IS
7923: Select response
7924: From ap_inv_aprvl_hist
7925: WHERE approval_history_id=(select max(approval_history_id)from ap_inv_aprvl_hist
7926: where invoice_id= p_invoice_id);
7927:
7928: BEGIN
7929: l_nid := WF_ENGINE.context_nid;

Line 8099: UPDATE AP_INV_APRVL_HIST

8095:
8096: insert_history_table(p_hist_rec => l_hist_rec);
8097:
8098: /*--Bug6406901, added the approver_name to the update cmd to populate correct value in AP_INV_APRVL_HLIST
8099: UPDATE AP_INV_APRVL_HIST
8100: set APPROVER_COMMENTS = l_comments, approver_name = l_display_name
8101: WHERE APPROVAL_HISTORY_ID =(select max(APPROVAL_HISTORY_ID) from AP_INV_APRVL_HIST
8102: where invoice_id=l_invoice_id);*/
8103: resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;

Line 8101: WHERE APPROVAL_HISTORY_ID =(select max(APPROVAL_HISTORY_ID) from AP_INV_APRVL_HIST

8097:
8098: /*--Bug6406901, added the approver_name to the update cmd to populate correct value in AP_INV_APRVL_HLIST
8099: UPDATE AP_INV_APRVL_HIST
8100: set APPROVER_COMMENTS = l_comments, approver_name = l_display_name
8101: WHERE APPROVAL_HISTORY_ID =(select max(APPROVAL_HISTORY_ID) from AP_INV_APRVL_HIST
8102: where invoice_id=l_invoice_id);*/
8103: resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;
8104: return;
8105: End if;

Line 8109: From ap_inv_aprvl_hist

8105: End if;
8106:
8107: /* BEGIN
8108: Select response into l_response
8109: From ap_inv_aprvl_hist
8110: WHERE approval_history_id=(select max(approval_history_id)from ap_inv_aprvl_hist
8111: where invoice_id=l_invoice_id);
8112: EXCEPTION
8113: WHEN OTHERS THEN

Line 8110: WHERE approval_history_id=(select max(approval_history_id)from ap_inv_aprvl_hist

8106:
8107: /* BEGIN
8108: Select response into l_response
8109: From ap_inv_aprvl_hist
8110: WHERE approval_history_id=(select max(approval_history_id)from ap_inv_aprvl_hist
8111: where invoice_id=l_invoice_id);
8112: EXCEPTION
8113: WHEN OTHERS THEN
8114: NULL;

Line 8283: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

8279: l_hist_id NUMBER(15);
8280: l_amount ap_invoices_all.invoice_amount%TYPE;
8281: l_user_id NUMBER(15);
8282: l_login_id NUMBER(15);
8283: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
8284: l_notf_iteration NUMBER;
8285: l_line_number ap_invoice_lines_all.line_number%TYPE;
8286: l_line_amount ap_invoice_lines_all.amount%TYPE;
8287: l_role_name varchar2(50);

Line 8299: From ap_inv_aprvl_hist

8295: WHERE USER_NAME=p_rec_role;
8296:
8297: CURSOR c_get_response ( p_invoice_id IN NUMBER) IS
8298: Select response
8299: From ap_inv_aprvl_hist
8300: WHERE approval_history_id=(select max(approval_history_id)from ap_inv_aprvl_hist
8301: where invoice_id= p_invoice_id);
8302:
8303:

Line 8300: WHERE approval_history_id=(select max(approval_history_id)from ap_inv_aprvl_hist

8296:
8297: CURSOR c_get_response ( p_invoice_id IN NUMBER) IS
8298: Select response
8299: From ap_inv_aprvl_hist
8300: WHERE approval_history_id=(select max(approval_history_id)from ap_inv_aprvl_hist
8301: where invoice_id= p_invoice_id);
8302:
8303:
8304: CURSOR Items_Cur(itemkey IN VARCHAR2) IS

Line 8478: UPDATE AP_INV_APRVL_HIST

8474: insert_history_table(p_hist_rec => l_hist_rec);
8475: END LOOP;
8476: CLOSE Items_Cur;
8477: /*--Bug6406901, added the approver_name to the update cmd to populate correct value in AP_INV_APRVL_HLIST
8478: UPDATE AP_INV_APRVL_HIST
8479: set APPROVER_COMMENTS = l_comments, approver_name = l_display_name
8480: WHERE APPROVAL_HISTORY_ID =(select max(APPROVAL_HISTORY_ID) from AP_INV_APRVL_HIST
8481: where invoice_id=l_invoice_id);*/
8482: resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;

Line 8480: WHERE APPROVAL_HISTORY_ID =(select max(APPROVAL_HISTORY_ID) from AP_INV_APRVL_HIST

8476: CLOSE Items_Cur;
8477: /*--Bug6406901, added the approver_name to the update cmd to populate correct value in AP_INV_APRVL_HLIST
8478: UPDATE AP_INV_APRVL_HIST
8479: set APPROVER_COMMENTS = l_comments, approver_name = l_display_name
8480: WHERE APPROVAL_HISTORY_ID =(select max(APPROVAL_HISTORY_ID) from AP_INV_APRVL_HIST
8481: where invoice_id=l_invoice_id);*/
8482: resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;
8483: return;
8484: End if;

Line 8488: From ap_inv_aprvl_hist

8484: End if;
8485:
8486: /* BEGIN
8487: Select response into l_response
8488: From ap_inv_aprvl_hist
8489: WHERE approval_history_id=(select max(approval_history_id)from ap_inv_aprvl_hist
8490: where invoice_id=l_invoice_id);
8491: EXCEPTION
8492: WHEN OTHERS THEN

Line 8489: WHERE approval_history_id=(select max(approval_history_id)from ap_inv_aprvl_hist

8485:
8486: /* BEGIN
8487: Select response into l_response
8488: From ap_inv_aprvl_hist
8489: WHERE approval_history_id=(select max(approval_history_id)from ap_inv_aprvl_hist
8490: where invoice_id=l_invoice_id);
8491: EXCEPTION
8492: WHEN OTHERS THEN
8493: NULL;

Line 8841: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

8837: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
8838: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
8839: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
8840: approver ame_util.approverRecord2;
8841: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
8842: --l_status VARCHAR2(50);
8843: l_comments VARCHAR2(240);
8844: l_display_name VARCHAR2(150);
8845: l_invoice_total NUMBER;