216: if l_TASKID is NOT NULL then
217:
218: update zpb_analysis_cycle_tasks
219: set status_code = 'ERROR',
220: LAST_UPDATED_BY = fnd_global.USER_ID,
221: LAST_UPDATE_DATE = SYSDATE,
222: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
223: where task_id = l_TaskID;
224:
218: update zpb_analysis_cycle_tasks
219: set status_code = 'ERROR',
220: LAST_UPDATED_BY = fnd_global.USER_ID,
221: LAST_UPDATE_DATE = SYSDATE,
222: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
223: where task_id = l_TaskID;
224:
225: end if;
226:
228: if l_instanceID is NOT NULL then
229:
230: update zpb_ANALYSIS_CYCLES
231: set status_code = 'ERROR',
232: LAST_UPDATED_BY = fnd_global.USER_ID,
233: LAST_UPDATE_DATE = SYSDATE,
234: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
235: where ANALYSIS_CYCLE_ID = l_InstanceID;
236:
230: update zpb_ANALYSIS_CYCLES
231: set status_code = 'ERROR',
232: LAST_UPDATED_BY = fnd_global.USER_ID,
233: LAST_UPDATE_DATE = SYSDATE,
234: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
235: where ANALYSIS_CYCLE_ID = l_InstanceID;
236:
237: update zpb_analysis_cycle_instances
238: set last_update_date = sysdate,
235: where ANALYSIS_CYCLE_ID = l_InstanceID;
236:
237: update zpb_analysis_cycle_instances
238: set last_update_date = sysdate,
239: LAST_UPDATED_BY = fnd_global.USER_ID,
240: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
241: where instance_ac_id = l_InstanceID;
242:
243: else
236:
237: update zpb_analysis_cycle_instances
238: set last_update_date = sysdate,
239: LAST_UPDATED_BY = fnd_global.USER_ID,
240: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
241: where instance_ac_id = l_InstanceID;
242:
243: else
244: -- return 'NOINFO';
461: if l_TASKID is NOT NULL then
462:
463: update zpb_analysis_cycle_tasks
464: set status_code = 'ERROR',
465: LAST_UPDATED_BY = fnd_global.USER_ID,
466: LAST_UPDATE_DATE = SYSDATE,
467: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
468: where task_id = l_TaskID;
469:
463: update zpb_analysis_cycle_tasks
464: set status_code = 'ERROR',
465: LAST_UPDATED_BY = fnd_global.USER_ID,
466: LAST_UPDATE_DATE = SYSDATE,
467: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
468: where task_id = l_TaskID;
469:
470: end if;
471:
473: if l_instanceID is NOT NULL then
474:
475: update zpb_ANALYSIS_CYCLES
476: set status_code = 'ERROR',
477: LAST_UPDATED_BY = fnd_global.USER_ID,
478: LAST_UPDATE_DATE = SYSDATE,
479: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
480: where ANALYSIS_CYCLE_ID = l_InstanceID;
481:
475: update zpb_ANALYSIS_CYCLES
476: set status_code = 'ERROR',
477: LAST_UPDATED_BY = fnd_global.USER_ID,
478: LAST_UPDATE_DATE = SYSDATE,
479: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
480: where ANALYSIS_CYCLE_ID = l_InstanceID;
481:
482: update zpb_analysis_cycle_instances
483: set last_update_date = sysdate,
480: where ANALYSIS_CYCLE_ID = l_InstanceID;
481:
482: update zpb_analysis_cycle_instances
483: set last_update_date = sysdate,
484: LAST_UPDATED_BY = fnd_global.USER_ID,
485: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
486: where instance_ac_id = l_InstanceID;
487:
488: else
481:
482: update zpb_analysis_cycle_instances
483: set last_update_date = sysdate,
484: LAST_UPDATED_BY = fnd_global.USER_ID,
485: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
486: where instance_ac_id = l_InstanceID;
487:
488: else
489: -- return 'NOINFO';