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

Line 20: SELECT AP_INV_APRVL_HIST_S.nextval

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
22: FROM dual;
23: --insert into the history table
24: INSERT INTO AP_INV_APRVL_HIST_ALL

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

175: l_org_id NUMBER;
176: l_role VARCHAR2(50);
177: l_role_display VARCHAR2(150);
178: l_display_name VARCHAR2(150);
179: l_hist_id AP_INV_APRVL_HIST.APPROVAL_HISTORY_ID%TYPE;
180: l_name VARCHAR2(30);
181: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
182: l_iteration NUMBER;
183: l_notf_iteration NUMBER;

Line 181: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

177: l_role_display VARCHAR2(150);
178: l_display_name VARCHAR2(150);
179: l_hist_id AP_INV_APRVL_HIST.APPROVAL_HISTORY_ID%TYPE;
180: l_name VARCHAR2(30);
181: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
182: l_iteration NUMBER;
183: l_notf_iteration NUMBER;
184:
185:

Line 382: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

378: l_invoice_id NUMBER;
379: l_hold_id NUMBER;
380: l_approver_id NUMBER;
381: l_display_name VARCHAR2(150);
382: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
383: l_api_name CONSTANT VARCHAR2(200) := 'process_ack_pomatched';
384: l_debug_info VARCHAR2(2000);
385: l_iteration NUMBER;
386: l_notf_iteration NUMBER;

Line 475: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

471: l_invoice_id NUMBER;
472: l_hold_id NUMBER;
473: l_approver_id NUMBER;
474: l_display_name VARCHAR2(150);
475: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
476: l_api_name CONSTANT VARCHAR2(200) := 'process_rel_pomatched';
477: l_debug_info VARCHAR2(2000);
478: l_iteration NUMBER;
479: l_notf_iteration NUMBER;

Line 579: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

575: l_invoice_id NUMBER;
576: l_hold_id NUMBER;
577: l_approver_id NUMBER;
578: l_display_name VARCHAR2(150);
579: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
580: l_api_name CONSTANT VARCHAR2(200) := 'process_ack_pounmatched';
581: l_debug_info VARCHAR2(2000);
582: l_iteration NUMBER;
583: l_notf_iteration NUMBER;

Line 672: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

668: l_invoice_id NUMBER;
669: l_hold_id NUMBER;
670: l_approver_id NUMBER;
671: l_display_name VARCHAR2(150);
672: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
673: l_api_name CONSTANT VARCHAR2(200) := 'process_rel_pounmatched';
674: l_debug_info VARCHAR2(2000);
675: l_iteration NUMBER;
676: l_notf_iteration NUMBER;

Line 816: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

812: l_hold_id NUMBER;
813: l_approver_id NUMBER;
814: l_internal_approver_id NUMBER;
815: l_display_name VARCHAR2(150);
816: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
817: l_api_name CONSTANT VARCHAR2(200) := 'process_accept_ext';
818: l_debug_info VARCHAR2(2000);
819: l_parentkey VARCHAR2(50);
820: l_iteration NUMBER;

Line 968: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

964: l_invoice_id NUMBER;
965: l_hold_id NUMBER;
966: l_approver_id NUMBER;
967: l_display_name VARCHAR2(150);
968: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
969: l_api_name CONSTANT VARCHAR2(200) := 'process_cancel_inv_by_sup';
970: l_debug_info VARCHAR2(2000);
971: l_parentkey VARCHAR2(50);
972: l_result BOOLEAN;

Line 1135: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

1131: l_invoice_id NUMBER;
1132: l_hold_id NUMBER;
1133: l_approver_id NUMBER;
1134: l_display_name VARCHAR2(150);
1135: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
1136: l_api_name CONSTANT VARCHAR2(200) := 'process_accept_int';
1137: l_debug_info VARCHAR2(2000);
1138: l_parentkey VARCHAR2(50);
1139: l_iteration NUMBER;

Line 1275: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

1271:
1272: l_result ame_util.stringlist;
1273: l_reason ame_util.stringlist;
1274: l_invoice_id NUMBER;
1275: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
1276: l_tr_reason VARCHAR2(240);
1277: l_api_name CONSTANT VARCHAR2(200) := 'Check_Header_Requirements';
1278: l_org_id NUMBER;
1279: l_rejected_check BOOLEAN := FALSE;

Line 1534: l_l_hist AP_INV_APRVL_HIST%ROWTYPE;

1530:
1531: l_result ame_util.stringlist;
1532: l_reason ame_util.stringlist;
1533: l_invoice_id NUMBER;
1534: l_l_hist AP_INV_APRVL_HIST%ROWTYPE;
1535: l_tr_reason VARCHAR2(240);
1536: l_api_name CONSTANT VARCHAR2(200) := 'Check_Line_Requirements';
1537: l_org_id NUMBER;
1538: l_required_check BOOLEAN := TRUE;

Line 1765: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

1761: l_api_name CONSTANT VARCHAR2(200) := 'Get_Approvers';
1762: l_iteration NUMBER;
1763: l_debug_info VARCHAR2(2000);
1764: l_org_id NUMBER;
1765: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
1766:
1767: BEGIN
1768: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1769: FND_LOG.STRING(G_LEVEL_PROCEDURE,

Line 2859: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

2855: l_user_id NUMBER(15);
2856: l_login_id NUMBER(15);
2857: l_api_name CONSTANT VARCHAR2(200) := 'process_doc_rejection';
2858: l_debug_info VARCHAR2(2000);
2859: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
2860: l_approver_name VARCHAR2(150);
2861: l_approver_id NUMBER;
2862: l_esc_flag VARCHAR2(1);
2863: l_esc_approver_name VARCHAR2(150);

Line 3016: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

3012: l_user_id NUMBER(15);
3013: l_login_id NUMBER(15);
3014: l_api_name CONSTANT VARCHAR2(200) := 'process_doc_approval';
3015: l_debug_info VARCHAR2(2000);
3016: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
3017: l_approver_name VARCHAR2(150);
3018: l_approver_id NUMBER;
3019: l_esc_flag VARCHAR2(1);
3020: l_esc_approver_name VARCHAR2(150);

Line 3216: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

3212: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
3213: l_debug_info VARCHAR2(2000);
3214: l_user_id NUMBER(15);
3215: l_login_id NUMBER(15);
3216: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
3217: l_approver_name VARCHAR2(150);
3218: l_approver_id NUMBER;
3219: l_esc_flag VARCHAR2(1);
3220: l_esc_approver_name VARCHAR2(150);

Line 3444: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

3440: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
3441: l_debug_info VARCHAR2(2000);
3442: l_user_id NUMBER(15);
3443: l_login_id NUMBER(15);
3444: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
3445: l_approver_name VARCHAR2(150);
3446: l_approver_id NUMBER;
3447: l_esc_flag VARCHAR2(1);
3448: l_esc_approver_name VARCHAR2(150);

Line 3740: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

3736: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
3737: l_debug_info VARCHAR2(2000);
3738: l_user_id NUMBER(15);
3739: l_login_id NUMBER(15);
3740: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
3741: l_approver_name VARCHAR2(150);
3742: l_approver_id NUMBER;
3743: l_role_name VARCHAR2(150);
3744: l_role VARCHAR2(150);

Line 3917: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

3913: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
3914: l_debug_info VARCHAR2(2000);
3915: l_user_id NUMBER(15);
3916: l_login_id NUMBER(15);
3917: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
3918: l_approver_name VARCHAR2(150);
3919: l_approver_id NUMBER;
3920: l_role_name VARCHAR2(150);
3921: l_role VARCHAR2(150);

Line 4079: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

4075: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
4076: l_debug_info VARCHAR2(2000);
4077: l_user_id NUMBER(15);
4078: l_login_id NUMBER(15);
4079: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
4080: l_approver_name VARCHAR2(150);
4081: l_approver_id NUMBER;
4082: l_role_name VARCHAR2(150);
4083: l_role VARCHAR2(150);

Line 4316: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

4312: l_role VARCHAR2(50);
4313: l_role_display VARCHAR2(150);
4314: l_new_child_ItemKey VARCHAR2(30);
4315: l_person_id NUMBER(15);
4316: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
4317: l_notf_receipient_type VARCHAR2(50);
4318: l_iteration NUMBER;
4319: l_notf_iteration NUMBER;
4320: l_ext_person_id NUMBER(15);

Line 4681: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

4677: l_error_message VARCHAR2(2000);
4678: l_invoice_id NUMBER(15);
4679: l_iteration NUMBER(9);
4680: l_count NUMBER(9);
4681: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
4682: l_notf_iteration NUMBER;
4683: l_complete VARCHAR2(1);
4684: l_next_approvers ame_util.approversTable2;
4685: l_next_approver ame_util.approverRecord2;

Line 4774: FROM ap_inv_aprvl_hist

4770:
4771: --check for prior approvers
4772: SELECT count(*)
4773: INTO l_count
4774: FROM ap_inv_aprvl_hist
4775: WHERE invoice_id = l_invoice_id
4776: AND iteration = l_iteration
4777: AND RESPONSE <> 'MANUALLY APPROVED'
4778: AND history_type = 'DOCUMENTAPPROVAL';

Line 4968: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

4964: 'escalate_doc_approval';
4965: l_debug_info VARCHAR2(2000);
4966: l_iteration NUMBER;
4967: l_invoice_total NUMBER;
4968: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
4969: l_notf_iteration NUMBER;
4970:
4971:
4972: BEGIN

Line 5148: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

5144: l_item_class VARCHAR2(50);
5145: l_item_id NUMBER;
5146: l_line_number ap_invoice_lines_all.line_number%TYPE;
5147: l_line_amount ap_invoice_lines_all.amount%TYPE;
5148: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
5149: l_comments VARCHAR2(240);
5150: l_esc_flag VARCHAR2(1);
5151: l_invoice_key VARCHAR2(50);
5152: l_notf_iteration NUMBER;

Line 5398: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

5394: l_role VARCHAR2(50);
5395: l_role_display VARCHAR2(150);
5396: l_new_child_ItemKey VARCHAR2(30);
5397: l_person_id NUMBER(15);
5398: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
5399: l_notf_receipient_type VARCHAR2(50);
5400: l_iteration NUMBER;
5401: l_notf_iteration NUMBER;
5402: l_invoice_key VARCHAR2(50);

Line 6023: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

6019: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
6020: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
6021: l_user_id NUMBER(15);
6022: l_login_id NUMBER(15);
6023: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
6024: l_approver_name VARCHAR2(150);
6025: l_approver_id NUMBER;
6026: l_esc_flag VARCHAR2(1);
6027: l_esc_approver_name VARCHAR2(150);

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;

Line 7541: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

7537: l_hist_id NUMBER(15);
7538: l_amount ap_invoices_all.invoice_amount%TYPE;
7539: l_user_id NUMBER(15);
7540: l_login_id NUMBER(15);
7541: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
7542: l_notf_iteration NUMBER;
7543: l_role_name VARCHAR2(50);
7544: l_esc_flag VARCHAR2(1);
7545: l_esc_role VARCHAR2(50);

Line 7558: From ap_inv_aprvl_hist

7554: WHERE USER_NAME=p_rec_role;
7555:
7556: CURSOR c_get_response ( p_invoice_id IN NUMBER) IS
7557: Select response
7558: From ap_inv_aprvl_hist
7559: WHERE approval_history_id=(select max(approval_history_id)from ap_inv_aprvl_hist
7560: where invoice_id= p_invoice_id);
7561:
7562: BEGIN

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

7555:
7556: CURSOR c_get_response ( p_invoice_id IN NUMBER) IS
7557: Select response
7558: From ap_inv_aprvl_hist
7559: WHERE approval_history_id=(select max(approval_history_id)from ap_inv_aprvl_hist
7560: where invoice_id= p_invoice_id);
7561:
7562: BEGIN
7563: l_nid := WF_ENGINE.context_nid;

Line 7727: UPDATE AP_INV_APRVL_HIST

7723:
7724: insert_history_table(p_hist_rec => l_hist_rec);
7725:
7726: /*--Bug6406901, added the approver_name to the update cmd to populate correct value in AP_INV_APRVL_HLIST
7727: UPDATE AP_INV_APRVL_HIST
7728: set APPROVER_COMMENTS = l_comments, approver_name = l_display_name
7729: WHERE APPROVAL_HISTORY_ID =(select max(APPROVAL_HISTORY_ID) from AP_INV_APRVL_HIST
7730: where invoice_id=l_invoice_id);*/
7731: resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;

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

7725:
7726: /*--Bug6406901, added the approver_name to the update cmd to populate correct value in AP_INV_APRVL_HLIST
7727: UPDATE AP_INV_APRVL_HIST
7728: set APPROVER_COMMENTS = l_comments, approver_name = l_display_name
7729: WHERE APPROVAL_HISTORY_ID =(select max(APPROVAL_HISTORY_ID) from AP_INV_APRVL_HIST
7730: where invoice_id=l_invoice_id);*/
7731: resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;
7732: return;
7733: End if;

Line 7737: From ap_inv_aprvl_hist

7733: End if;
7734:
7735: /* BEGIN
7736: Select response into l_response
7737: From ap_inv_aprvl_hist
7738: WHERE approval_history_id=(select max(approval_history_id)from ap_inv_aprvl_hist
7739: where invoice_id=l_invoice_id);
7740: EXCEPTION
7741: WHEN OTHERS THEN

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

7734:
7735: /* BEGIN
7736: Select response into l_response
7737: From ap_inv_aprvl_hist
7738: WHERE approval_history_id=(select max(approval_history_id)from ap_inv_aprvl_hist
7739: where invoice_id=l_invoice_id);
7740: EXCEPTION
7741: WHEN OTHERS THEN
7742: NULL;

Line 7904: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

7900: l_hist_id NUMBER(15);
7901: l_amount ap_invoices_all.invoice_amount%TYPE;
7902: l_user_id NUMBER(15);
7903: l_login_id NUMBER(15);
7904: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
7905: l_notf_iteration NUMBER;
7906: l_line_number ap_invoice_lines_all.line_number%TYPE;
7907: l_line_amount ap_invoice_lines_all.amount%TYPE;
7908: l_role_name varchar2(50);

Line 7920: From ap_inv_aprvl_hist

7916: WHERE USER_NAME=p_rec_role;
7917:
7918: CURSOR c_get_response ( p_invoice_id IN NUMBER) IS
7919: Select response
7920: From ap_inv_aprvl_hist
7921: WHERE approval_history_id=(select max(approval_history_id)from ap_inv_aprvl_hist
7922: where invoice_id= p_invoice_id);
7923:
7924:

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

7917:
7918: CURSOR c_get_response ( p_invoice_id IN NUMBER) IS
7919: Select response
7920: From ap_inv_aprvl_hist
7921: WHERE approval_history_id=(select max(approval_history_id)from ap_inv_aprvl_hist
7922: where invoice_id= p_invoice_id);
7923:
7924:
7925: CURSOR Items_Cur(itemkey IN VARCHAR2) IS

Line 8099: UPDATE AP_INV_APRVL_HIST

8095: insert_history_table(p_hist_rec => l_hist_rec);
8096: END LOOP;
8097: CLOSE Items_Cur;
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: CLOSE Items_Cur;
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;