DBA Data[Home] [Help]

APPS.ZPB_WF_ERROR dependencies on FND_GLOBAL

Line 220: LAST_UPDATED_BY = fnd_global.USER_ID,

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:

Line 222: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

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:

Line 232: LAST_UPDATED_BY = fnd_global.USER_ID,

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:

Line 234: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

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,

Line 239: LAST_UPDATED_BY = fnd_global.USER_ID,

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

Line 240: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

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';

Line 465: LAST_UPDATED_BY = fnd_global.USER_ID,

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:

Line 467: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

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:

Line 477: LAST_UPDATED_BY = fnd_global.USER_ID,

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:

Line 479: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

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,

Line 484: LAST_UPDATED_BY = fnd_global.USER_ID,

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

Line 485: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

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';