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_IAW_PKG dependencies on FND_PROFILE

Line 200: FND_PROFILE.VALUE('AP_IAW_USER');

196: l_h_hist.iteration := l_iteration;
197: l_h_hist.response := 'APPROVED';
198: l_h_hist.approver_comments := l_tr_reason;
199: l_h_hist.approver_id :=
200: FND_PROFILE.VALUE('AP_IAW_USER');
201: l_h_hist.org_id := l_org_id;
202: l_h_hist.created_by :=
203: FND_PROFILE.VALUE('AP_IAW_USER');
204: l_h_hist.creation_date := sysdate;

Line 203: FND_PROFILE.VALUE('AP_IAW_USER');

199: l_h_hist.approver_id :=
200: FND_PROFILE.VALUE('AP_IAW_USER');
201: l_h_hist.org_id := l_org_id;
202: l_h_hist.created_by :=
203: FND_PROFILE.VALUE('AP_IAW_USER');
204: l_h_hist.creation_date := sysdate;
205: l_h_hist.last_update_date := sysdate;
206: l_h_hist.last_updated_by :=
207: FND_PROFILE.VALUE('AP_IAW_USER');

Line 207: FND_PROFILE.VALUE('AP_IAW_USER');

203: FND_PROFILE.VALUE('AP_IAW_USER');
204: l_h_hist.creation_date := sysdate;
205: l_h_hist.last_update_date := sysdate;
206: l_h_hist.last_updated_by :=
207: FND_PROFILE.VALUE('AP_IAW_USER');
208: l_h_hist.last_update_login := -1;
209: l_h_hist.amount_approved := l_amount;
210:
211:

Line 276: FND_PROFILE.VALUE('AP_IAW_USER');

272: l_h_hist.iteration := l_iteration;
273: l_h_hist.response := 'REJECTED';
274: l_h_hist.approver_comments := l_tr_reason;
275: l_h_hist.approver_id :=
276: FND_PROFILE.VALUE('AP_IAW_USER');
277: l_h_hist.org_id := l_org_id;
278: l_h_hist.created_by :=
279: FND_PROFILE.VALUE('AP_IAW_USER');
280: l_h_hist.creation_date := sysdate;

Line 279: FND_PROFILE.VALUE('AP_IAW_USER');

275: l_h_hist.approver_id :=
276: FND_PROFILE.VALUE('AP_IAW_USER');
277: l_h_hist.org_id := l_org_id;
278: l_h_hist.created_by :=
279: FND_PROFILE.VALUE('AP_IAW_USER');
280: l_h_hist.creation_date := sysdate;
281: l_h_hist.last_update_date := sysdate;
282: l_h_hist.last_updated_by :=
283: FND_PROFILE.VALUE('AP_IAW_USER');

Line 283: FND_PROFILE.VALUE('AP_IAW_USER');

279: FND_PROFILE.VALUE('AP_IAW_USER');
280: l_h_hist.creation_date := sysdate;
281: l_h_hist.last_update_date := sysdate;
282: l_h_hist.last_updated_by :=
283: FND_PROFILE.VALUE('AP_IAW_USER');
284: l_h_hist.last_update_login := -1;
285: l_h_hist.amount_approved := l_amount;
286:
287: Insert_Header_History(

Line 427: FND_PROFILE.VALUE('AP_IAW_USER');

423: l_l_hist.iteration := l_iteration;
424: l_l_hist.response := 'APPROVED';
425: l_l_hist.approver_comments := l_tr_reason;
426: l_l_hist.approver_id :=
427: FND_PROFILE.VALUE('AP_IAW_USER');
428: l_l_hist.org_id := l_org_id;
429: l_l_hist.line_number := l_line_number;
430: l_l_hist.line_amount_approved :=
431: l_amount;

Line 433: FND_PROFILE.VALUE('AP_IAW_USER');

429: l_l_hist.line_number := l_line_number;
430: l_l_hist.line_amount_approved :=
431: l_amount;
432: l_l_hist.created_by :=
433: FND_PROFILE.VALUE('AP_IAW_USER');
434: l_l_hist.creation_date := sysdate;
435: l_l_hist.last_updated_by :=
436: FND_PROFILE.VALUE('AP_IAW_USER');
437: l_l_hist.last_update_date := sysdate;

Line 436: FND_PROFILE.VALUE('AP_IAW_USER');

432: l_l_hist.created_by :=
433: FND_PROFILE.VALUE('AP_IAW_USER');
434: l_l_hist.creation_date := sysdate;
435: l_l_hist.last_updated_by :=
436: FND_PROFILE.VALUE('AP_IAW_USER');
437: l_l_hist.last_update_date := sysdate;
438: l_l_hist.last_update_login := -1;
439: l_l_hist.item_class := 'APINV';
440: l_l_hist.item_id := l_invoice_id;

Line 915: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),

911: l_next_approver.ACTION_TYPE_ORDER_NUMBER,
912: l_next_approver.GROUP_OR_CHAIN_ORDER_NUMBER,
913: l_next_approver.MEMBER_ORDER_NUMBER,
914: l_next_approver.APPROVER_ORDER_NUMBER,
915: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
916: sysdate,
917: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
918: -1),
919: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),

Line 917: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

913: l_next_approver.MEMBER_ORDER_NUMBER,
914: l_next_approver.APPROVER_ORDER_NUMBER,
915: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
916: sysdate,
917: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
918: -1),
919: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
920: sysdate,
921: 200,

Line 919: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),

915: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
916: sysdate,
917: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
918: -1),
919: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
920: sysdate,
921: 200,
922: 0,
923: sysdate,

Line 1036: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),

1032: l_next_approver.ACTION_TYPE_ORDER_NUMBER,
1033: l_next_approver.GROUP_OR_CHAIN_ORDER_NUMBER,
1034: l_next_approver.MEMBER_ORDER_NUMBER,
1035: l_next_approver.APPROVER_ORDER_NUMBER,
1036: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
1037: sysdate,
1038: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
1039: -1),
1040: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),

Line 1038: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

1034: l_next_approver.MEMBER_ORDER_NUMBER,
1035: l_next_approver.APPROVER_ORDER_NUMBER,
1036: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
1037: sysdate,
1038: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
1039: -1),
1040: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
1041: sysdate,
1042: 200,

Line 1040: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),

1036: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
1037: sysdate,
1038: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
1039: -1),
1040: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
1041: sysdate,
1042: 200,
1043: 0,
1044: sysdate,

Line 1484: ,Last_Updated_By = nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1)

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 =
1486: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1)
1487: Where invoice_id = l_invoice_id
1488: AND iteration = l_iteration

Line 1486: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1)

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 =
1486: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1)
1487: Where invoice_id = l_invoice_id
1488: AND iteration = l_iteration
1489: AND approver_id = l_approver_id;
1490:

Line 1624: ,Last_Updated_By = nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1)

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 =
1626: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1)
1627: Where invoice_id = l_invoice_id
1628: AND approver_id = l_approver_id

Line 1626: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1)

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 =
1626: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1)
1627: Where invoice_id = l_invoice_id
1628: AND approver_id = l_approver_id
1629: AND notification_key = itemkey;
1630:

Line 2419: ,-1 --nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1)

2415: ,l_invoice_id
2416: ,l_iteration
2417: ,'PENDING'
2418: ,l_approver_id
2419: ,-1 --nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1)
2420: ,sysdate
2421: ,sysdate
2422: ,-1 --nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1)
2423: ,-1 --nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1)

Line 2422: ,-1 --nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1)

2418: ,l_approver_id
2419: ,-1 --nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1)
2420: ,sysdate
2421: ,sysdate
2422: ,-1 --nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1)
2423: ,-1 --nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1)
2424: ,l_org_id
2425: ,l_amount
2426: ,l_not_cnt);

Line 2423: ,-1 --nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1)

2419: ,-1 --nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1)
2420: ,sysdate
2421: ,sysdate
2422: ,-1 --nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1)
2423: ,-1 --nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1)
2424: ,l_org_id
2425: ,l_amount
2426: ,l_not_cnt);
2427:

Line 2623: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1)

2619: ,'PENDING'
2620: ,l_approver_id
2621: ,itemkey
2622: ,l_line_amt
2623: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1)
2624: ,sysdate
2625: ,sysdate
2626: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1)
2627: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1)

Line 2626: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1)

2622: ,l_line_amt
2623: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1)
2624: ,sysdate
2625: ,sysdate
2626: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1)
2627: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1)
2628: ,l_org_id
2629: ,l_item_class
2630: ,l_item_id

Line 2627: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1)

2623: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1)
2624: ,sysdate
2625: ,sysdate
2626: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1)
2627: ,nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1)
2628: ,l_org_id
2629: ,l_item_class
2630: ,l_item_id
2631: ,l_not_cnt);

Line 2690: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);

2686: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
2687: itemkey,
2688: 'ORG_ID');
2689:
2690: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
2691: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
2692:
2693: IF l_result = 'APPROVED' THEN
2694: l_result := 'WFAPPROVED';

Line 2691: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);

2687: itemkey,
2688: 'ORG_ID');
2689:
2690: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
2691: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
2692:
2693: IF l_result = 'APPROVED' THEN
2694: l_result := 'WFAPPROVED';
2695: END IF;

Line 2833: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);

2829: l_org_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
2830: itemkey,
2831: 'ORG_ID');
2832:
2833: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
2834: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
2835:
2836: IF l_result = 'APPROVED' THEN
2837: l_result := 'WFAPPROVED';

Line 2834: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);

2830: itemkey,
2831: 'ORG_ID');
2832:
2833: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
2834: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
2835:
2836: IF l_result = 'APPROVED' THEN
2837: l_result := 'WFAPPROVED';
2838: END IF;

Line 3933: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')), -1),

3929: decode(p_invoice_source,'ISP', p_ext_user_name, null),
3930: 'NEGOTIATE',
3931: 'I',
3932: p_invoice_source,
3933: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')), -1),
3934: sysdate,
3935: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')), -1),
3936: sysdate,
3937: 200,

Line 3935: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')), -1),

3931: 'I',
3932: p_invoice_source,
3933: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')), -1),
3934: sysdate,
3935: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')), -1),
3936: sysdate,
3937: 200,
3938: 0,
3939: sysdate,