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.

[Home] [Help]

APPS.ZPB_EXCP_PVT dependencies on FND_GLOBAL

Line 140: LAST_UPDATED_BY = fnd_global.USER_ID,

136: set owner = (
137: select user_name
138: from fnd_user f
139: where f.user_id = z.owner_id),
140: LAST_UPDATED_BY = fnd_global.USER_ID,
141: LAST_UPDATE_DATE = SYSDATE,
142: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
143: where task_id = l_task_id;
144:

Line 142: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

138: from fnd_user f
139: where f.user_id = z.owner_id),
140: LAST_UPDATED_BY = fnd_global.USER_ID,
141: LAST_UPDATE_DATE = SYSDATE,
142: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
143: where task_id = l_task_id;
144:
145: update zpb_excp_results z
146: set approver = (

Line 150: LAST_UPDATED_BY = fnd_global.USER_ID,

146: set approver = (
147: select user_name
148: from fnd_user f
149: where f.user_id = z.approver_id),
150: LAST_UPDATED_BY = fnd_global.USER_ID,
151: LAST_UPDATE_DATE = SYSDATE,
152: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
153: where task_id = l_task_id;
154: end if;

Line 152: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

148: from fnd_user f
149: where f.user_id = z.approver_id),
150: LAST_UPDATED_BY = fnd_global.USER_ID,
151: LAST_UPDATE_DATE = SYSDATE,
152: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
153: where task_id = l_task_id;
154: end if;
155: end if;
156:

Line 276: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id

272: OWNER_ID, OWNER, APPROVER_ID, APPROVER, STATUS, VALUE_flag, value_number,
273: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
274: (select p_notification_id, e.TASK_ID, e.MEMBER_ID, e.MEMBER_DISPLAY,
275: e.OWNER_ID, e.OWNER, e.APPROVER_ID, e.APPROVER, g_req_child_nodes, e.VALUE_flag, e.value_number,
276: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
277: from zpb_excp_explanations e
278: where e.task_id = p_task_id
279: and e.owner_id = nvl(sys_context('ZPB_CONTEXT', 'shadow_id'), fnd_global.user_id));
280:

Line 279: and e.owner_id = nvl(sys_context('ZPB_CONTEXT', 'shadow_id'), fnd_global.user_id));

275: e.OWNER_ID, e.OWNER, e.APPROVER_ID, e.APPROVER, g_req_child_nodes, e.VALUE_flag, e.value_number,
276: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
277: from zpb_excp_explanations e
278: where e.task_id = p_task_id
279: and e.owner_id = nvl(sys_context('ZPB_CONTEXT', 'shadow_id'), fnd_global.user_id));
280:
281: insert into zpb_excp_explanations(NOTIFICATION_ID, TASK_ID, MEMBER_ID, MEMBER_DISPLAY,
282: OWNER_ID, OWNER, APPROVER_ID, APPROVER, STATUS, VALUE_flag, value_number,
283: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)

Line 286: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id

282: OWNER_ID, OWNER, APPROVER_ID, APPROVER, STATUS, VALUE_flag, value_number,
283: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
284: (select p_notification_id, e.TASK_ID, e.MEMBER_ID, e.MEMBER_DISPLAY,
285: e.OWNER_ID, e.OWNER, e.APPROVER_ID, e.APPROVER, g_req_child_nodes, e.VALUE_flag, e.value_number,
286: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
287: from zpb_excp_results e
288: where e.task_id = p_task_id
289: and e.owner_id = nvl(sys_context('ZPB_CONTEXT', 'shadow_id'), fnd_global.user_id));
290:

Line 289: and e.owner_id = nvl(sys_context('ZPB_CONTEXT', 'shadow_id'), fnd_global.user_id));

285: e.OWNER_ID, e.OWNER, e.APPROVER_ID, e.APPROVER, g_req_child_nodes, e.VALUE_flag, e.value_number,
286: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
287: from zpb_excp_results e
288: where e.task_id = p_task_id
289: and e.owner_id = nvl(sys_context('ZPB_CONTEXT', 'shadow_id'), fnd_global.user_id));
290:
291: -- End of API body.
292:
293: -- Standard check of p_commit.

Line 396: l_user_id := FND_GLOBAL.USER_ID;

392: -- Initialize API return status to success
393: x_return_status := FND_API.G_RET_STS_SUCCESS;
394:
395: -- API body
396: l_user_id := FND_GLOBAL.USER_ID;
397: l_resp_id := FND_GLOBAL.RESP_ID;
398:
399: --l_user_id := 1005262;
400: --l_resp_id := 57124;

Line 397: l_resp_id := FND_GLOBAL.RESP_ID;

393: x_return_status := FND_API.G_RET_STS_SUCCESS;
394:
395: -- API body
396: l_user_id := FND_GLOBAL.USER_ID;
397: l_resp_id := FND_GLOBAL.RESP_ID;
398:
399: --l_user_id := 1005262;
400: --l_resp_id := 57124;
401: --dbms_output.put_line(l_user_id);

Line 464: LAST_UPDATED_BY = fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,

460: set owner = (
461: select user_name
462: from fnd_user f
463: where f.user_id = z.owner_id),
464: LAST_UPDATED_BY = fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,
465: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
466: where task_id = p_task_id
467: and notification_id = p_notification_id;
468: end if;

Line 465: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

461: select user_name
462: from fnd_user f
463: where f.user_id = z.owner_id),
464: LAST_UPDATED_BY = fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,
465: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
466: where task_id = p_task_id
467: and notification_id = p_notification_id;
468: end if;
469: