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