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.IA_WF_REQUEST_PKG dependencies on FND_PROFILE

Line 252: l_preparer_user_id := to_number(FND_PROFILE.VALUE('USER_ID'));

248: debugInfo := 'Get User ID of Preparer';
249: -----------------------------------------------------
250: begin
251:
252: l_preparer_user_id := to_number(FND_PROFILE.VALUE('USER_ID'));
253:
254: /* To avoid error when launched from pl/sql
255: if (l_preparer_user_id is NULL) then
256: raise localException;

Line 333: ,last_updated_by = nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)

329: -----------------------------------------------------
330: update ia_request_headers
331: set status = IA_WF_UTIL_PKG.HeaderStatusPendingApproval
332: ,last_update_date = SYSDATE
333: ,last_updated_by = nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
334: ,last_update_login = nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)
335: where request_id = p_request_id;
336:
337: update ia_request_details

Line 334: ,last_update_login = nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)

330: update ia_request_headers
331: set status = IA_WF_UTIL_PKG.HeaderStatusPendingApproval
332: ,last_update_date = SYSDATE
333: ,last_updated_by = nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
334: ,last_update_login = nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)
335: where request_id = p_request_id;
336:
337: update ia_request_details
338: set status = IA_WF_UTIL_PKG.LineStatusPending

Line 340: ,last_updated_by = nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)

336:
337: update ia_request_details
338: set status = IA_WF_UTIL_PKG.LineStatusPending
339: ,last_update_date = SYSDATE
340: ,last_updated_by = nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
341: ,last_update_login = nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)
342: where request_id = p_request_id;
343:
344: exception

Line 341: ,last_update_login = nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)

337: update ia_request_details
338: set status = IA_WF_UTIL_PKG.LineStatusPending
339: ,last_update_date = SYSDATE
340: ,last_updated_by = nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
341: ,last_update_login = nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)
342: where request_id = p_request_id;
343:
344: exception
345: when others then

Line 1319: ,nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)

1315: ,p_approver_id
1316: ,p_approval_status
1317: ,NULL
1318: ,p_approval_chain_phase
1319: ,nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
1320: ,sysdate
1321: ,sysdate
1322: ,nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
1323: ,nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)

Line 1322: ,nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)

1318: ,p_approval_chain_phase
1319: ,nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
1320: ,sysdate
1321: ,sysdate
1322: ,nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
1323: ,nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)
1324: );
1325:
1326: p_approval_id := l_approval_id;

Line 1323: ,nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)

1319: ,nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
1320: ,sysdate
1321: ,sysdate
1322: ,nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
1323: ,nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)
1324: );
1325:
1326: p_approval_id := l_approval_id;
1327:

Line 1453: ,nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)

1449: ,l_approver_id
1450: ,l_approval_order
1451: ,IA_WF_UTIL_PKG.ApprovalStatusPendingApproval -- PENDING
1452: ,l_chain_phase
1453: ,nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
1454: ,sysdate
1455: ,sysdate
1456: ,nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
1457: ,nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)

Line 1456: ,nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)

1452: ,l_chain_phase
1453: ,nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
1454: ,sysdate
1455: ,sysdate
1456: ,nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
1457: ,nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)
1458: );
1459:
1460: end if;

Line 1457: ,nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)

1453: ,nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
1454: ,sysdate
1455: ,sysdate
1456: ,nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
1457: ,nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)
1458: );
1459:
1460: end if;
1461:

Line 1500: ,last_updated_by = nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)

1496: update ia_request_approvals
1497: set notification_id = p_notification_id
1498: ,user_comment = p_user_comment
1499: ,last_update_date = SYSDATE
1500: ,last_updated_by = nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
1501: ,last_update_login = nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)
1502: where approval_id = p_approval_id;
1503:
1504: END Update_Approval_Notify;

Line 1501: ,last_update_login = nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)

1497: set notification_id = p_notification_id
1498: ,user_comment = p_user_comment
1499: ,last_update_date = SYSDATE
1500: ,last_updated_by = nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
1501: ,last_update_login = nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)
1502: where approval_id = p_approval_id;
1503:
1504: END Update_Approval_Notify;
1505: */

Line 1532: ,last_updated_by = nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)

1528: set status = p_approval_status
1529: ,approval_chain_phase = p_chain_phase
1530: ,transaction_date = SYSDATE
1531: ,last_update_date = SYSDATE
1532: ,last_updated_by = nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
1533: ,last_update_login = nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)
1534: where approval_id = p_approval_id;
1535:
1536: COMMIT;

Line 1533: ,last_update_login = nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)

1529: ,approval_chain_phase = p_chain_phase
1530: ,transaction_date = SYSDATE
1531: ,last_update_date = SYSDATE
1532: ,last_updated_by = nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
1533: ,last_update_login = nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)
1534: where approval_id = p_approval_id;
1535:
1536: COMMIT;
1537:

Line 1560: ,last_updated_by = nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)

1556:
1557: update ia_request_headers
1558: set status = p_status
1559: ,last_update_date = SYSDATE
1560: ,last_updated_by = nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
1561: ,last_update_login = nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)
1562: where request_id = p_request_id;
1563:
1564: COMMIT;

Line 1561: ,last_update_login = nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)

1557: update ia_request_headers
1558: set status = p_status
1559: ,last_update_date = SYSDATE
1560: ,last_updated_by = nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
1561: ,last_update_login = nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)
1562: where request_id = p_request_id;
1563:
1564: COMMIT;
1565:

Line 1593: ,last_updated_by = nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)

1589: */
1590: update ia_request_details
1591: set status = p_status
1592: ,last_update_date = SYSDATE
1593: ,last_updated_by = nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
1594: ,last_update_login = nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)
1595: where request_id = p_request_id
1596: and status = IA_WF_UTIL_PKG.LineStatusPending;
1597:

Line 1594: ,last_update_login = nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)

1590: update ia_request_details
1591: set status = p_status
1592: ,last_update_date = SYSDATE
1593: ,last_updated_by = nvl(to_number(FND_PROFILE.VALUE('USER_ID')),-1)
1594: ,last_update_login = nvl(to_number(FND_PROFILE.VALUE('LOGIN_ID')),-1)
1595: where request_id = p_request_id
1596: and status = IA_WF_UTIL_PKG.LineStatusPending;
1597:
1598: COMMIT;