DBA Data[Home] [Help]

APPS.ZPB_SC_REASSIGN dependencies on FND_GLOBAL

Line 57: last_updated_by = fnd_global.USER_ID,

53: UPDATE
54: zpb_analysis_cycles
55: SET
56: owner_id = p_new_owner_id,
57: last_updated_by = fnd_global.USER_ID,
58: last_update_date = SYSDATE,
59: last_update_login = fnd_global.LOGIN_ID
60: WHERE
61: owner_id = p_owner_id AND

Line 59: last_update_login = fnd_global.LOGIN_ID

55: SET
56: owner_id = p_new_owner_id,
57: last_updated_by = fnd_global.USER_ID,
58: last_update_date = SYSDATE,
59: last_update_login = fnd_global.LOGIN_ID
60: WHERE
61: owner_id = p_owner_id AND
62: business_area_id = p_business_area_id;
63:

Line 189: last_updated_by = fnd_global.USER_ID,

185: UPDATE
186: zpb_analysis_cycle_tasks
187: SET
188: owner_id = p_new_owner_id,
189: last_updated_by = fnd_global.USER_ID,
190: last_update_date = SYSDATE,
191: last_update_login = fnd_global.LOGIN_ID
192: WHERE
193: owner_id = p_owner_id and

Line 191: last_update_login = fnd_global.LOGIN_ID

187: SET
188: owner_id = p_new_owner_id,
189: last_updated_by = fnd_global.USER_ID,
190: last_update_date = SYSDATE,
191: last_update_login = fnd_global.LOGIN_ID
192: WHERE
193: owner_id = p_owner_id and
194: analysis_cycle_id in (SELECT
195: distinct(ZACT.analysis_cycle_id)

Line 210: last_updated_by = fnd_global.USER_ID,

206: UPDATE
207: zpb_task_parameters
208: SET
209: value = p_new_owner_id,
210: last_updated_by = fnd_global.USER_ID,
211: last_update_date = SYSDATE,
212: last_update_login = fnd_global.LOGIN_ID
213: WHERE
214: name = 'OWNER_ID' and

Line 212: last_update_login = fnd_global.LOGIN_ID

208: SET
209: value = p_new_owner_id,
210: last_updated_by = fnd_global.USER_ID,
211: last_update_date = SYSDATE,
212: last_update_login = fnd_global.LOGIN_ID
213: WHERE
214: name = 'OWNER_ID' and
215: value = p_owner_id and
216: task_id in (SELECT

Line 232: last_updated_by = fnd_global.USER_ID,

228: UPDATE
229: zpb_task_parameters
230: SET
231: value = l_new_owner_user_name,
232: last_updated_by = fnd_global.USER_ID,
233: last_update_date = SYSDATE,
234: last_update_login = fnd_global.LOGIN_ID
235: WHERE
236: name = 'SPECIFIED_NOTIFICATION_RECIPIENT' and

Line 234: last_update_login = fnd_global.LOGIN_ID

230: SET
231: value = l_new_owner_user_name,
232: last_updated_by = fnd_global.USER_ID,
233: last_update_date = SYSDATE,
234: last_update_login = fnd_global.LOGIN_ID
235: WHERE
236: name = 'SPECIFIED_NOTIFICATION_RECIPIENT' and
237: value = l_owner_user_name and
238: task_id in (SELECT

Line 255: last_updated_by = fnd_global.USER_ID,

251: zpb_excp_results
252: SET
253: owner_id = p_new_owner_id,
254: owner = l_new_owner_user_name,
255: last_updated_by = fnd_global.USER_ID,
256: last_update_date = SYSDATE,
257: last_update_login = fnd_global.LOGIN_ID
258: WHERE
259: owner_id = p_owner_id and

Line 257: last_update_login = fnd_global.LOGIN_ID

253: owner_id = p_new_owner_id,
254: owner = l_new_owner_user_name,
255: last_updated_by = fnd_global.USER_ID,
256: last_update_date = SYSDATE,
257: last_update_login = fnd_global.LOGIN_ID
258: WHERE
259: owner_id = p_owner_id and
260: task_id in (SELECT
261: ZTP.task_id

Line 277: last_updated_by = fnd_global.USER_ID,

273: zpb_excp_results
274: SET
275: approver_id = p_new_owner_id,
276: approver = l_new_owner_user_name,
277: last_updated_by = fnd_global.USER_ID,
278: last_update_date = SYSDATE,
279: last_update_login = fnd_global.LOGIN_ID
280: WHERE
281: approver_id = p_owner_id and

Line 279: last_update_login = fnd_global.LOGIN_ID

275: approver_id = p_new_owner_id,
276: approver = l_new_owner_user_name,
277: last_updated_by = fnd_global.USER_ID,
278: last_update_date = SYSDATE,
279: last_update_login = fnd_global.LOGIN_ID
280: WHERE
281: approver_id = p_owner_id and
282: task_id in (SELECT
283: ZTP.task_id

Line 299: last_updated_by = fnd_global.USER_ID,

295: zpb_excp_explanations
296: SET
297: owner_id = p_new_owner_id,
298: owner = l_new_owner_user_name,
299: last_updated_by = fnd_global.USER_ID,
300: last_update_date = SYSDATE,
301: last_update_login = fnd_global.LOGIN_ID
302: WHERE
303: owner_id = p_owner_id and

Line 301: last_update_login = fnd_global.LOGIN_ID

297: owner_id = p_new_owner_id,
298: owner = l_new_owner_user_name,
299: last_updated_by = fnd_global.USER_ID,
300: last_update_date = SYSDATE,
301: last_update_login = fnd_global.LOGIN_ID
302: WHERE
303: owner_id = p_owner_id and
304: task_id in (SELECT
305: ZTP.task_id

Line 322: last_updated_by = fnd_global.USER_ID,

318: zpb_excp_explanations
319: SET
320: approver_id = p_new_owner_id,
321: approver = l_new_owner_user_name,
322: last_updated_by = fnd_global.USER_ID,
323: last_update_date = SYSDATE,
324: last_update_login = fnd_global.LOGIN_ID
325: WHERE
326: approver_id = p_owner_id and

Line 324: last_update_login = fnd_global.LOGIN_ID

320: approver_id = p_new_owner_id,
321: approver = l_new_owner_user_name,
322: last_updated_by = fnd_global.USER_ID,
323: last_update_date = SYSDATE,
324: last_update_login = fnd_global.LOGIN_ID
325: WHERE
326: approver_id = p_owner_id and
327: task_id in (SELECT
328: ZTP.task_id