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.ZPB_EXCP_PVT dependencies on ZPB_EXCP_EXPLANATIONS

Line 236: p_task_id IN zpb_excp_explanations.task_id%type,

232: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
233: x_return_status OUT NOCOPY VARCHAR2,
234: x_msg_count OUT NOCOPY number,
235: x_msg_data OUT NOCOPY varchar2,
236: p_task_id IN zpb_excp_explanations.task_id%type,
237: p_notification_id IN zpb_excp_explanations.notification_id%type)
238:
239: IS
240:

Line 237: p_notification_id IN zpb_excp_explanations.notification_id%type)

233: x_return_status OUT NOCOPY VARCHAR2,
234: x_msg_count OUT NOCOPY number,
235: x_msg_data OUT NOCOPY varchar2,
236: p_task_id IN zpb_excp_explanations.task_id%type,
237: p_notification_id IN zpb_excp_explanations.notification_id%type)
238:
239: IS
240:
241: l_api_name CONSTANT VARCHAR2(30) := 'request_child_nodes';

Line 266: delete from zpb_excp_explanations

262:
263: -- API body
264:
265: -- clean up from any previous requests
266: delete from zpb_excp_explanations
267: where task_id = p_task_id
268: and notification_id = p_notification_id;
269:
270:

Line 271: insert into zpb_excp_explanations(NOTIFICATION_ID, TASK_ID, MEMBER_ID, MEMBER_DISPLAY,

267: where task_id = p_task_id
268: and notification_id = p_notification_id;
269:
270:
271: insert into zpb_excp_explanations(NOTIFICATION_ID, TASK_ID, MEMBER_ID, MEMBER_DISPLAY,
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,

Line 277: from zpb_excp_explanations e

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:
281: insert into zpb_excp_explanations(NOTIFICATION_ID, TASK_ID, MEMBER_ID, MEMBER_DISPLAY,

Line 281: insert into zpb_excp_explanations(NOTIFICATION_ID, TASK_ID, MEMBER_ID, MEMBER_DISPLAY,

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)
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,

Line 344: p_notification_id IN zpb_excp_explanations.notification_id%type,

340: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
341: x_return_status OUT nocopy varchar2,
342: x_msg_count OUT nocopy number,
343: x_msg_data OUT nocopy varchar2,
344: p_notification_id IN zpb_excp_explanations.notification_id%type,
345: p_task_id IN zpb_excp_explanations.task_id%type )
346:
347: IS
348:

Line 345: p_task_id IN zpb_excp_explanations.task_id%type )

341: x_return_status OUT nocopy varchar2,
342: x_msg_count OUT nocopy number,
343: x_msg_data OUT nocopy varchar2,
344: p_notification_id IN zpb_excp_explanations.notification_id%type,
345: p_task_id IN zpb_excp_explanations.task_id%type )
346:
347: IS
348:
349: l_api_name CONSTANT VARCHAR2(30) := 'request_children';

Line 459: update zpb_excp_explanations z

455: ZPB_AW.CLEAN_WORKSPACE(1.0, FND_API.G_FALSE, p_validation_level, x_return_status, x_msg_count, x_msg_data);
456:
457: -- add in owner names (need to update who columns)
458: if to_number(l_child_ct) > 0 then
459: update zpb_excp_explanations z
460: set owner = (
461: select user_name
462: from fnd_user f
463: where f.user_id = z.owner_id),