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_CYCLES

Line 89: from zpb_analysis_cycles

85: --
86: -- AGB 11/07/2003 Publish change
87: select STATUS_CODE, NAME, PUBLISHED_BY
88: into ACstatusCode, ACname, OwnerID
89: from zpb_analysis_cycles
90: where ANALYSIS_CYCLE_ID = ACID;
91: Owner := ZPB_WF_NTF.ID_to_FNDUser(OwnerID);
92:
93:

Line 162: from ZPB_ANALYSIS_CYCLES

158:
159: -- abudnik 17NOV2005 BUSINESS AREA ID.
160: select BUSINESS_AREA_ID
161: into l_business_area_id
162: from ZPB_ANALYSIS_CYCLES
163: where ANALYSIS_CYCLE_ID = ACId;
164:
165: -- create itemkey for workflow
166: charDate := to_char(sysdate, 'MM/DD/YYYY-HH24-MI-SS');

Line 427: from ZPB_ANALYSIS_CYCLES

423:
424: -- agb DISABLE 07/16/2003
425: select STATUS_CODE
426: into ACstatusCode
427: from ZPB_ANALYSIS_CYCLES
428: where ANALYSIS_CYCLE_ID = ACID;
429:
430:
431: /* agb DISABLE 07/16/2003

Line 458: from ZPB_ANALYSIS_CYCLES

454: end loop;
455:
456: select STATUS_CODE
457: into InstatusCode
458: from ZPB_ANALYSIS_CYCLES
459: where ANALYSIS_CYCLE_ID = InstanceID;
460:
461: -- If instance is marked for deletion do not mark it as complete
462: -- Clean up the instance measures and quit

Line 476: update zpb_ANALYSIS_CYCLES

472:
473: -- LAST TASK FOR THIS INSTANCE
474: if workflowprocess = 'NONE' then
475:
476: update zpb_ANALYSIS_CYCLES
477: set status_code = 'COMPLETE',
478: LAST_UPDATED_BY = fnd_global.USER_ID,
479: LAST_UPDATE_DATE = SYSDATE,
480: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 509: from zpb_ANALYSIS_CYCLES where ANALYSIS_CYCLE_ID = INSTANCEID;

505: resultout :='COMPLETE:PAUSED';
506: return;
507: elsif (InstatusCode = 'PAUSING') THEN
508: select LAST_UPDATED_BY into usr_paused_BP_ID
509: from zpb_ANALYSIS_CYCLES where ANALYSIS_CYCLE_ID = INSTANCEID;
510:
511: update zpb_ANALYSIS_CYCLES
512: set status_code = 'PAUSED',
513: LAST_UPDATED_BY = fnd_global.USER_ID,

Line 511: update zpb_ANALYSIS_CYCLES

507: elsif (InstatusCode = 'PAUSING') THEN
508: select LAST_UPDATED_BY into usr_paused_BP_ID
509: from zpb_ANALYSIS_CYCLES where ANALYSIS_CYCLE_ID = INSTANCEID;
510:
511: update zpb_ANALYSIS_CYCLES
512: set status_code = 'PAUSED',
513: LAST_UPDATED_BY = fnd_global.USER_ID,
514: LAST_UPDATE_DATE = SYSDATE, LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
515: where ANALYSIS_CYCLE_ID = INSTANCEID;

Line 1317: from ZPB_ANALYSIS_CYCLES

1313:
1314: select STATUS_CODE
1315: into ACstatusCode
1316: -- from ZPB_PUBLISHED_CYCLES_V
1317: from ZPB_ANALYSIS_CYCLES
1318: where ANALYSIS_CYCLE_ID = ACID;
1319:
1320: -- Do not run if DISABLED!
1321: if instr(ACstatusCode, 'DISABLE') > 0 then

Line 1550: update zpb_ANALYSIS_CYCLES

1546: LAST_UPDATE_DATE = SYSDATE,
1547: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1548: where ANALYSIS_CYCLE_ID = InstanceID and task_id = TaskID;
1549:
1550: update zpb_ANALYSIS_CYCLES
1551: set status_code = 'ACTIVE',
1552: LAST_UPDATED_BY = fnd_global.USER_ID,
1553: LAST_UPDATE_DATE = SYSDATE,
1554: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 1652: and instance_ac_id = (select ac.ANALYSIS_CYCLE_ID from zpb_ANALYSIS_CYCLES ac

1648: CURSOR c_instances is
1649: select instance_ac_id
1650: from zpb_analysis_cycle_instances
1651: where zpb_analysis_cycle_instances.ANALYSIS_CYCLE_ID = ACID
1652: and instance_ac_id = (select ac.ANALYSIS_CYCLE_ID from zpb_ANALYSIS_CYCLES ac
1653: where ac.ANALYSIS_CYCLE_ID = instance_ac_id and
1654: ac.status_code in ('COMPLETE','COMPLETE_WITH_WARNING', 'ERROR'))
1655: order by instance_ac_id DESC;
1656:

Line 1672: from ZPB_ANALYSIS_CYCLES

1668:
1669: -- abudnik 17NOV2005 BUSINESS AREA ID.
1670: select BUSINESS_AREA_ID
1671: into l_business_area_id
1672: from ZPB_ANALYSIS_CYCLES
1673: where ANALYSIS_CYCLE_ID = ACId;
1674:
1675: InstancesToKeep := -1;
1676:

Line 1695: update zpb_ANALYSIS_CYCLES

1691: -- update delete flag
1692:
1693: InstanceID := v_instances.instance_ac_id;
1694:
1695: update zpb_ANALYSIS_CYCLES
1696: set status_code = 'MARKED_FOR_DELETION',
1697: LAST_UPDATED_BY = fnd_global.USER_ID,
1698: LAST_UPDATE_DATE = SYSDATE,
1699: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 2610: from ZPB_ANALYSIS_CYCLES

2606: BEGIN
2607:
2608: select STATUS_CODE
2609: into InstatusCode
2610: from ZPB_ANALYSIS_CYCLES
2611: where ANALYSIS_CYCLE_ID = InstanceID
2612: for update nowait;
2613:
2614: if InstatusCode = 'ACTIVE' or InstatusCode = 'WARNING' then

Line 2617: update ZPB_ANALYSIS_CYCLES

2613:
2614: if InstatusCode = 'ACTIVE' or InstatusCode = 'WARNING' then
2615:
2616:
2617: update ZPB_ANALYSIS_CYCLES
2618: set prev_status_code = status_code
2619: where ANALYSIS_CYCLE_ID = InstanceID;
2620:
2621: -- agb 04/22/04 change from PAUSED to PAUSING.

Line 2622: update ZPB_ANALYSIS_CYCLES

2618: set prev_status_code = status_code
2619: where ANALYSIS_CYCLE_ID = InstanceID;
2620:
2621: -- agb 04/22/04 change from PAUSED to PAUSING.
2622: update ZPB_ANALYSIS_CYCLES
2623: set status_code = 'PAUSING',
2624: LAST_UPDATED_BY = fnd_global.USER_ID,
2625: LAST_UPDATE_DATE = SYSDATE,
2626: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 2702: from zpb_analysis_cycles

2698: begin
2699:
2700: select status_code, prev_status_code
2701: into InstanceStatusCode, InPrevStatusCode
2702: from zpb_analysis_cycles
2703: where analysis_cycle_id = InstanceID;
2704:
2705: EXCEPTION
2706: WHEN NO_DATA_FOUND THEN

Line 2718: update zpb_analysis_cycles

2714:
2715: -- if the status of the instance to be resumed is PAUSING
2716: -- all we need to do is set the status to previous status code
2717: if InstanceStatusCode = 'PAUSING' then
2718: update zpb_analysis_cycles
2719: set status_code= InPrevStatusCode
2720: where analysis_cycle_id = InstanceID;
2721:
2722: resultout :='COMPLETE:Y';

Line 2752: zpb_analysis_cycles c

2748: -- 5867453 bkport of 5371156 new source for base parmameters ownerID from task table above.
2749: select i.ANALYSIS_CYCLE_ID, c.name, c.BUSINESS_AREA_ID
2750: into ACID, ACNAME, l_business_area_id
2751: from zpb_analysis_cycle_instances i,
2752: zpb_analysis_cycles c
2753: where i.INSTANCE_AC_ID = InstanceID
2754: and i.ANALYSIS_CYCLE_ID = c.ANALYSIS_CYCLE_ID;
2755:
2756: Owner := ZPB_WF_NTF.ID_to_FNDUser(OwnerID);

Line 2776: update zpb_ANALYSIS_CYCLES

2772:
2773: -- LAST TASK FOR THIS INSTANCE
2774: if workflowprocess = 'NONE' then
2775:
2776: update zpb_ANALYSIS_CYCLES
2777: set status_code = 'COMPLETE',
2778: LAST_UPDATED_BY = fnd_global.USER_ID,
2779: LAST_UPDATE_DATE = SYSDATE,
2780: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 2907: update ZPB_ANALYSIS_CYCLES

2903: LAST_UPDATE_DATE = SYSDATE,
2904: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
2905: where ANALYSIS_CYCLE_ID = INSTANCEID and task_id = TaskID;
2906:
2907: update ZPB_ANALYSIS_CYCLES
2908: set status_code = InPrevStatusCode,
2909: LAST_UPDATED_BY = fnd_global.USER_ID,
2910: LAST_UPDATE_DATE = SYSDATE,
2911: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 2978: from zpb_analysis_cycles

2974:
2975: -- set olap page pool size based on ZPB_OPPS_DATA_MOVE param for BP publisher
2976: begin
2977: select published_by into l_published_by
2978: from zpb_analysis_cycles
2979: where analysis_cycle_id = ACID;
2980:
2981: zpb_util_pvt.set_opps(ZPB_UTIL_PVT.ZPB_OPPS_DATA_MOVE, l_published_by);
2982:

Line 3101: from ZPB_ANALYSIS_CYCLES

3097: DLcmd := 'call CM.SETCURRINST ('''||instanceID||''' '''||ACID||''')';
3098:
3099: select BUSINESS_AREA_ID
3100: into l_business_area_id
3101: from ZPB_ANALYSIS_CYCLES
3102: where ANALYSIS_CYCLE_ID = ACId;
3103:
3104: -- change agb to dbdata.
3105: ZPB_AW_WRITE_BACK.SUBMIT_WRITEBACK_REQUEST(l_business_area_id,

Line 3322: ZPB_ANALYSIS_CYCLES zac

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
3326: zac.status_code = 'DISABLE_ASAP' and

Line 3334: from zpb_analysis_cycles C, zpb_account_states A, fnd_responsibility_vl R

3330: -- 5867453 bkport of b5371156 new way to get params for setting context
3331: -- before submiting a request to the concurrent manager
3332: CURSOR c_owner_resp is
3333: select C.OWNER_ID, A.RESP_ID
3334: from zpb_analysis_cycles C, zpb_account_states A, fnd_responsibility_vl R
3335: where ANALYSIS_CYCLE_ID = Pacid
3336: AND A.ACCOUNT_STATUS = 0
3337: AND A.USER_ID = C.OWNER_ID
3338: AND C.BUSINESS_AREA_ID = A.BUSINESS_AREA_ID

Line 3352: from ZPB_ANALYSIS_CYCLES

3348:
3349: -- abudnik 17NOV2005 BUSINESS AREA ID.
3350: select STATUS_CODE, BUSINESS_AREA_ID
3351: into ACstatusCode, l_business_area_id
3352: from ZPB_ANALYSIS_CYCLES
3353: where ANALYSIS_CYCLE_ID = Pacid;
3354:
3355: if instr(ACstatusCode, 'DISABLE') > 0 then
3356:

Line 3358: update ZPB_ANALYSIS_CYCLES

3354:
3355: if instr(ACstatusCode, 'DISABLE') > 0 then
3356:
3357: -- Set the BP Status to Enable
3358: update ZPB_ANALYSIS_CYCLES
3359: set STATUS_CODE = 'ENABLE_TASK',
3360: LAST_UPDATED_BY = fnd_global.USER_ID,
3361: LAST_UPDATE_DATE = SYSDATE,
3362: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 3393: UPDATE zpb_analysis_cycles

3389: -- previously saved status
3390:
3391: if CodeToUpdateTo = 'ACTIVE' then
3392:
3393: UPDATE zpb_analysis_cycles
3394: SET status_code=decode(prev_status_code, null, 'ACTIVE', prev_status_code)
3395: where analysis_cycle_id in
3396:
3397: (select distinct zac.analysis_cycle_id

Line 3400: ZPB_ANALYSIS_CYCLES zac

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
3404: zac.status_code = 'DISABLE_ASAP' and

Line 3407: UPDATE zpb_analysis_cycles

3403: zac.analysis_cycle_id = zact.analysis_cycle_id and
3404: zac.status_code = 'DISABLE_ASAP' and
3405: zact.status_code in ('ACTIVE', 'PENDING'));
3406: else
3407: UPDATE zpb_analysis_cycles
3408: SET status_code=CodeToUpdateTo
3409: where analysis_cycle_id in
3410:
3411: (select distinct zac.analysis_cycle_id

Line 3414: ZPB_ANALYSIS_CYCLES zac

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
3418: zac.status_code = 'DISABLE_ASAP' and

Line 3454: update zpb_analysis_cycles

3450: if PStatus = 'ENABLE_FIRST' then
3451:
3452: -- for monitor page display set stauts to enable_first here
3453: -- it will get reset to active once instance restarts
3454: update zpb_analysis_cycles
3455: set status_code='ENABLE_FIRST'
3456: where analysis_cycle_id=InstanceID;
3457:
3458: l_REQID := FND_REQUEST.SUBMIT_REQUEST ('ZPB', 'ZPB_CLEANANDRESTARTINST', NULL, NULL, FALSE, Pacid, InstanceID, l_business_area_id);

Line 3463: update zpb_analysis_cycles

3459: end if;
3460:
3461: if PStatus = 'ENABLE_NEXT' then
3462: -- In the case of Enabling Next, Both active and inactive instances should be set to MARKED_FOR_DELETION
3463: update zpb_analysis_cycles
3464: set status_code='MARKED_FOR_DELETION'
3465: where analysis_cycle_id=InstanceID;
3466:
3467: -- clean the measure

Line 3692: from zpb_analysis_cycles

3688:
3689: begin
3690:
3691: select status_code, published_by into instance_status, ownerID
3692: from zpb_analysis_cycles
3693: where analysis_cycle_id=p_InstanceID;
3694:
3695: EXCEPTION
3696: WHEN NO_DATA_FOUND THEN

Line 3713: from ZPB_ANALYSIS_CYCLES

3709: where INSTANCE_AC_ID = p_InstanceID;
3710:
3711: select BUSINESS_AREA_ID
3712: into l_business_area_id
3713: from ZPB_ANALYSIS_CYCLES
3714: where ANALYSIS_CYCLE_ID = ACId;
3715:
3716: -- abudnik 17NOV2005 BUSINESS AREA ID.
3717: l_REQID := FND_REQUEST.SUBMIT_REQUEST ('ZPB', 'ZPB_WF_DELAWINST', NULL, NULL, FALSE, p_InstanceID, ownerID, l_business_area_id);

Line 3743: update zpb_ANALYSIS_CYCLES

3739:
3740:
3741: if p_instanceID is NOT NULL then
3742:
3743: update zpb_ANALYSIS_CYCLES
3744: set status_code = p_type,
3745: LAST_UPDATED_BY = fnd_global.USER_ID,
3746: LAST_UPDATE_DATE = SYSDATE,
3747: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 3764: update zpb_ANALYSIS_CYCLES

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,
3766: LAST_UPDATED_BY = fnd_global.USER_ID,
3767: LAST_UPDATE_DATE = SYSDATE,
3768: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 3847: from ZPB_ANALYSIS_CYCLES A,

3843: l_business_area_id number;
3844: begin
3845: select distinct A.BUSINESS_AREA_ID
3846: into l_business_area_id
3847: from ZPB_ANALYSIS_CYCLES A,
3848: ZPB_DC_OBJECTS B
3849: where B.AC_INSTANCE_ID = A.ANALYSIS_CYCLE_ID
3850: and B.TEMPLATE_ID = p_templateID;
3851:

Line 4151: from zpb_analysis_cycles

4147:
4148: -- abudnik 17NOV2005 BUSINESS AREA ID
4149: select status_code, BUSINESS_AREA_ID
4150: into ACStatusCode, l_business_area_id
4151: from zpb_analysis_cycles
4152: where analysis_cycle_id = ACId;
4153:
4154: EXCEPTION
4155: WHEN NO_DATA_FOUND THEN

Line 4170: from zpb_analysis_cycles

4166: -- does not have a Current Instance, do not attempt to remove the
4167: -- non-existent current instance
4168: begin
4169: select current_instance_id into currInstanceId
4170: from zpb_analysis_cycles
4171: where analysis_cycle_id = ACId;
4172:
4173: select count(*) into currInstExistsCnt
4174: from zpb_measures

Line 4189: ZPB_ANALYSIS_CYCLES zac

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
4193: zact.status_code in ('ACTIVE', 'PENDING');

Line 4204: ZPB_ANALYSIS_CYCLES zac2

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
4208: zact2.wf_process_name='SET_CURRENT_INSTANCE' and

Line 4214: ZPB_ANALYSIS_CYCLES zac

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
4218: zact.wf_process_name='SET_CURRENT_INSTANCE' and

Line 4287: from ZPB_ANALYSIS_CYCLES

4283: ACId||''')';
4284:
4285: select BUSINESS_AREA_ID
4286: into l_business_area_id
4287: from ZPB_ANALYSIS_CYCLES
4288: where ANALYSIS_CYCLE_ID = ACId;
4289:
4290: -- change agb to dbdata.
4291: ZPB_AW_WRITE_BACK.SUBMIT_WRITEBACK_REQUEST(l_business_area_id,

Line 4331: from zpb_analysis_cycles

4327:
4328: begin
4329:
4330: select published_by into ownerID
4331: from zpb_analysis_cycles
4332: where analysis_cycle_id = P_ACId;
4333:
4334:
4335: -- First delete the associated AW measure

Line 4442: from zpb_analysis_cycles

4438: begin
4439:
4440: select status_code, prev_status_code
4441: into InstanceStatusCode, InPrevStatusCode
4442: from zpb_analysis_cycles
4443: where analysis_cycle_id = p_InstanceID;
4444:
4445: EXCEPTION
4446: WHEN NO_DATA_FOUND THEN

Line 4488: from ZPB_ANALYSIS_CYCLES

4484: from ZPB_ANALYSIS_CYCLE_INSTANCES
4485: where INSTANCE_AC_ID = p_InstanceID;
4486:
4487: select NAME, CREATED_BY into ACNAME, ownerID
4488: from ZPB_ANALYSIS_CYCLES
4489: where ANALYSIS_CYCLE_ID = ACID;
4490:
4491: -- Converted from zpb_analysis_cycles select above
4492: Owner := ZPB_WF_NTF.ID_to_FNDUser(OwnerID);

Line 4491: -- Converted from zpb_analysis_cycles select above

4487: select NAME, CREATED_BY into ACNAME, ownerID
4488: from ZPB_ANALYSIS_CYCLES
4489: where ANALYSIS_CYCLE_ID = ACID;
4490:
4491: -- Converted from zpb_analysis_cycles select above
4492: Owner := ZPB_WF_NTF.ID_to_FNDUser(OwnerID);
4493:
4494: -- Using ZPB_CONTROLLER_RESP as the source for this
4495: select RESPONSIBILITY_ID

Line 4510: update zpb_analysis_cycles

4506: -- if the status of the instance to be resumed is PAUSING
4507: -- all we need to do is set the status to previous status code
4508: /*
4509: if InstanceStatusCode = 'PAUSING' then
4510: update zpb_analysis_cycles
4511: set status_code= InPrevStatusCode
4512: where analysis_cycle_id = p_InstanceID;
4513: commit;
4514: return;

Line 4530: update zpb_ANALYSIS_CYCLES

4526:
4527: -- LAST TASK FOR THIS INSTANCE
4528: if workflowprocess = 'NONE' then
4529:
4530: update zpb_ANALYSIS_CYCLES
4531: set status_code = 'ERROR',
4532: LAST_UPDATED_BY = fnd_global.USER_ID,
4533: LAST_UPDATE_DATE = SYSDATE,
4534: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 4657: update ZPB_ANALYSIS_CYCLES

4653: LAST_UPDATE_DATE = SYSDATE,
4654: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
4655: where ANALYSIS_CYCLE_ID = p_InstanceID and task_id = TaskID;
4656:
4657: update ZPB_ANALYSIS_CYCLES
4658: set status_code = InPrevStatusCode,
4659: LAST_UPDATED_BY = fnd_global.USER_ID,
4660: LAST_UPDATE_DATE = SYSDATE,
4661: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID