eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_WF dependencies on ZPB_ANALYSIS_CYCLE_TASKS

Line 359: from zpb_analysis_cycle_tasks

355: l_InstanceDesc varchar2(300); -- A. Budnik 04/12/2006 bugs 3126256, 3856551 and others
356:
357: CURSOR c_tasks is
358: select *
359: from zpb_analysis_cycle_tasks
360: where ANALYSIS_CYCLE_ID = InstanceID
361: and Sequence = CurrtaskSeq+1;
362: v_tasks c_Tasks%ROWTYPE;
363:

Line 439: update zpb_analysis_cycle_tasks

435: where ANALYSIS_CYCLE_ID = ACID;
436: */
437:
438: -- First set prior task to complete - one that just finished.
439: update zpb_analysis_cycle_tasks
440: set status_code = 'COMPLETE',
441: LAST_UPDATED_BY = fnd_global.USER_ID,
442: LAST_UPDATE_DATE = SYSDATE,
443: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 675: update zpb_analysis_cycle_tasks

671: aname => 'RESPNOTE',
672: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.NON_RESPONDERS/' || newItemKey );
673: end if;
674:
675: update zpb_analysis_cycle_tasks
676: set item_KEY = newitemkey,
677: Start_date = to_Date(charDate,'MM/DD/YYYY-HH24-MI-SS'),
678: status_code = 'ACTIVE',
679: LAST_UPDATED_BY = fnd_global.USER_ID,

Line 1385: from zpb_analysis_cycle_tasks

1381: -- Get next task [wf process] to run
1382:
1383: select WF_Process_Name, TASK_ID, TASK_NAME
1384: into workflowprocess, TaskID, taskName
1385: from zpb_analysis_cycle_tasks
1386: where ANALYSIS_CYCLE_ID = InstanceID and Sequence = 1;
1387:
1388:
1389:

Line 1541: update zpb_analysis_cycle_tasks

1537: aname => 'RESPNOTE',
1538: avalue => 'PLSQL:ZPB_EXCEPTION_ALERT.NON_RESPONDERS/' || newItemKey );
1539: end if;
1540:
1541: update zpb_analysis_cycle_tasks
1542: set item_KEY = newitemkey,
1543: Start_date = to_Date(charDate,'MM/DD/YYYY-HH24-MI-SS'),
1544: status_code = 'ACTIVE',
1545: LAST_UPDATED_BY = fnd_global.USER_ID,

Line 2678: from zpb_analysis_cycle_tasks

2674:
2675:
2676: CURSOR c_tasks is
2677: select *
2678: from zpb_analysis_cycle_tasks
2679: where ANALYSIS_CYCLE_ID = InstanceID
2680: and Sequence = CurrtaskSeq+1;
2681: v_tasks c_Tasks%ROWTYPE;
2682: -- 5867453 bkport of 5371156 get resume parameters from zpb not wf

Line 2730: from ZPB_ANALYSIS_CYCLE_TASKS

2726:
2727: -- 5867453 bkport of 5371156 add ownerID drop Item_key
2728: select sequence, owner_id
2729: into CurrtaskSeq, ownerID
2730: from ZPB_ANALYSIS_CYCLE_TASKS
2731: where ANALYSIS_CYCLE_ID = InstanceID and
2732: sequence = (select MAX(SEQUENCE) from ZPB_ANALYSIS_CYCLE_TASKS
2733: where ANALYSIS_CYCLE_ID = InstanceID and STATUS_CODE = 'COMPLETE');
2734:

Line 2732: sequence = (select MAX(SEQUENCE) from ZPB_ANALYSIS_CYCLE_TASKS

2728: select sequence, owner_id
2729: into CurrtaskSeq, ownerID
2730: from ZPB_ANALYSIS_CYCLE_TASKS
2731: where ANALYSIS_CYCLE_ID = InstanceID and
2732: sequence = (select MAX(SEQUENCE) from ZPB_ANALYSIS_CYCLE_TASKS
2733: where ANALYSIS_CYCLE_ID = InstanceID and STATUS_CODE = 'COMPLETE');
2734:
2735: -- When resume_instance is called from enable_cycle there is a
2736: -- specal case when transitioning from DISABLE_ASAP to ENABLE_FIRST

Line 2740: update ZPB_ANALYSIS_CYCLE_TASKS

2736: -- specal case when transitioning from DISABLE_ASAP to ENABLE_FIRST
2737: if PResumeType = 'RUN_FROM_TOP' then
2738: CurrtaskSeq := 0;
2739: --
2740: update ZPB_ANALYSIS_CYCLE_TASKS
2741: set STATUS_CODE = null,
2742: LAST_UPDATED_BY = fnd_global.USER_ID,
2743: LAST_UPDATE_DATE = SYSDATE,
2744: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 2898: update zpb_analysis_cycle_tasks

2894: -- Now that all is created and set START the PROCESS!
2895: wf_engine.StartProcess(ItemType => ItemType,
2896: ItemKey => newItemKey);
2897:
2898: update zpb_analysis_cycle_tasks
2899: set item_KEY = newitemkey,
2900: Start_date = to_Date(charDate,'MM/DD/YYYY-HH24-MI-SS'),
2901: status_code = 'ACTIVE',
2902: LAST_UPDATED_BY = fnd_global.USER_ID,

Line 2994: from zpb_analysis_cycle_tasks

2990:
2991:
2992:
2993: select analysis_cycle_id into l_InstanceID
2994: from zpb_analysis_cycle_tasks
2995: where task_id = TaskID;
2996:
2997: ZPB_AW.INITIALIZE_FOR_AC (p_api_version => 1.0,
2998: p_init_msg_list => FND_API.G_TRUE,

Line 3321: ZPB_ANALYSIS_CYCLE_TASKS zact,

3317: CURSOR c_instance is
3318:
3319: select distinct zac.analysis_cycle_id
3320: FROM ZPB_ANALYSIS_CYCLE_INSTANCES zaci,
3321: ZPB_ANALYSIS_CYCLE_TASKS zact,
3322: ZPB_ANALYSIS_CYCLES zac
3323: WHERE zaci.analysis_cycle_id = Pacid and
3324: zaci.instance_ac_id = zac.analysis_cycle_id and
3325: zac.analysis_cycle_id = zact.analysis_cycle_id and

Line 3399: ZPB_ANALYSIS_CYCLE_TASKS zact,

3395: where analysis_cycle_id in
3396:
3397: (select distinct zac.analysis_cycle_id
3398: FROM ZPB_ANALYSIS_CYCLE_INSTANCES zaci,
3399: ZPB_ANALYSIS_CYCLE_TASKS zact,
3400: ZPB_ANALYSIS_CYCLES zac
3401: WHERE zaci.analysis_cycle_id = Pacid and
3402: zaci.instance_ac_id = zac.analysis_cycle_id and
3403: zac.analysis_cycle_id = zact.analysis_cycle_id and

Line 3413: ZPB_ANALYSIS_CYCLE_TASKS zact,

3409: where analysis_cycle_id in
3410:
3411: (select distinct zac.analysis_cycle_id
3412: FROM ZPB_ANALYSIS_CYCLE_INSTANCES zaci,
3413: ZPB_ANALYSIS_CYCLE_TASKS zact,
3414: ZPB_ANALYSIS_CYCLES zac
3415: WHERE zaci.analysis_cycle_id = Pacid and
3416: zaci.instance_ac_id = zac.analysis_cycle_id and
3417: zac.analysis_cycle_id = zact.analysis_cycle_id and

Line 3526: from zpb_analysis_cycle_tasks

3522: BEGIN
3523:
3524: select count(wf_process_name)
3525: into thisCount
3526: from zpb_analysis_cycle_tasks
3527: where analysis_cycle_id = InstanceID and
3528: wf_process_name in ('LOAD_DATA', 'GENERATE_TEMPLATE', 'DISTRIBUTE_TEMPLATE', 'SOLVE', 'MANAGE_SUBMISSION');
3529:
3530: if thisCount > 0 then -- build phys model

Line 3724: update zpb_analysis_cycle_tasks

3720:
3721:
3722: if p_TaskID is NOT NULL then
3723:
3724: update zpb_analysis_cycle_tasks
3725: set status_code = p_type,
3726: LAST_UPDATED_BY = fnd_global.USER_ID,
3727: LAST_UPDATE_DATE = SYSDATE,
3728: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 3761: from zpb_analysis_cycle_tasks

3757: else
3758:
3759: if p_TaskID is NOT NULL then
3760: select distinct ANALYSIS_CYCLE_ID into l_InstanceID
3761: from zpb_analysis_cycle_tasks
3762: where task_id = p_TaskID;
3763:
3764: update zpb_ANALYSIS_CYCLES
3765: set status_code = p_type,

Line 4188: ZPB_ANALYSIS_CYCLE_TASKS zact,

4184: end;
4185:
4186: select count(*) into activeInstances
4187: FROM ZPB_ANALYSIS_CYCLE_INSTANCES zaci,
4188: ZPB_ANALYSIS_CYCLE_TASKS zact,
4189: ZPB_ANALYSIS_CYCLES zac
4190: WHERE zaci.analysis_cycle_id = ACId and
4191: zaci.instance_ac_id = zac.analysis_cycle_id and
4192: zac.analysis_cycle_id = zact.analysis_cycle_id and

Line 4203: ZPB_ANALYSIS_CYCLE_TASKS zact2,

4199: begin
4200:
4201: SELECT zac2.analysis_cycle_id into lastCompleted
4202: FROM ZPB_ANALYSIS_CYCLE_INSTANCES zaci2,
4203: ZPB_ANALYSIS_CYCLE_TASKS zact2,
4204: ZPB_ANALYSIS_CYCLES zac2
4205: WHERE zaci2.analysis_cycle_id = ACId and
4206: zaci2.instance_ac_id = zac2.analysis_cycle_id and
4207: zac2.analysis_cycle_id = zact2.analysis_cycle_id and

Line 4213: ZPB_ANALYSIS_CYCLE_TASKS zact,

4209: zac2.status_code in ('COMPLETE', 'COMPLETE_WITH_WARNING') and
4210: zact2.last_update_date =
4211: (SELECT max(zact.last_update_date)
4212: FROM ZPB_ANALYSIS_CYCLE_INSTANCES zaci,
4213: ZPB_ANALYSIS_CYCLE_TASKS zact,
4214: ZPB_ANALYSIS_CYCLES zac
4215: WHERE zaci.analysis_cycle_id = ACId and
4216: zaci.instance_ac_id = zac.analysis_cycle_id and
4217: zac.analysis_cycle_id = zact.analysis_cycle_id and

Line 4345: from zpb_analysis_cycle_tasks

4341:
4342:
4343: select TASK_ID
4344: into TaskId
4345: from zpb_analysis_cycle_tasks
4346: where ANALYSIS_CYCLE_ID = P_InstanceId and Sequence = 1;
4347:
4348: -- b 5170327 intializes the pv_status variable
4349: ZPB_ERROR_HANDLER.INIT_CONC_REQ_STATUS;

Line 4410: from zpb_analysis_cycle_tasks

4406: retcode number;
4407:
4408: CURSOR c_tasks is
4409: select *
4410: from zpb_analysis_cycle_tasks
4411: where ANALYSIS_CYCLE_ID = p_InstanceID
4412: and Sequence = 1;
4413: v_tasks c_Tasks%ROWTYPE;
4414:

Line 4648: update zpb_analysis_cycle_tasks

4644: -- Now that all is created and set START the PROCESS!
4645: wf_engine.StartProcess(ItemType => ItemType,
4646: ItemKey => newItemKey);
4647:
4648: update zpb_analysis_cycle_tasks
4649: set item_KEY = newitemkey,
4650: Start_date = to_Date(charDate,'MM/DD/YYYY-HH24-MI-SS'),
4651: status_code = 'ACTIVE',
4652: LAST_UPDATED_BY = fnd_global.USER_ID,