APPS.ZPB_EXCP_PVT dependencies on ZPB_EXCP_RESULTS

Line 135: update zpb_excp_results z

131: if l_excp_ct<>'NA' and l_excp_ct<>' ' then
132:
133: if to_number(l_excp_ct) > 0 then
134:
135: update zpb_excp_results z
136: set owner = (
137: select user_name
138: from fnd_user f
139: where f.user_id = z.owner_id),

Line 145: update zpb_excp_results z

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 = (
147: select user_name
148: from fnd_user f
149: where f.user_id = z.approver_id),

Line 287: from zpb_excp_results e

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:
291: -- End of API body.