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_INSTANCES

Line 483: update zpb_analysis_cycle_instances

479: LAST_UPDATE_DATE = SYSDATE,
480: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
481: where ANALYSIS_CYCLE_ID = INSTANCEID;
482:
483: update zpb_analysis_cycle_instances
484: set LAST_UPDATED_BY = fnd_global.USER_ID,
485: LAST_UPDATE_DATE = SYSDATE, LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
486: where instance_ac_id = INSTANCEID;
487:

Line 517: update zpb_analysis_cycle_instances

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;
516:
517: update zpb_analysis_cycle_instances
518: set LAST_UPDATED_BY = fnd_global.USER_ID,
519: LAST_UPDATE_DATE = SYSDATE, LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
520: where instance_ac_id = INSTANCEID;
521:

Line 1163: from zpb_analysis_cycle_instances

1159: errbuf varchar2(100);
1160:
1161: CURSOR c_instances is
1162: select instance_ac_id
1163: from zpb_analysis_cycle_instances
1164: where analysis_cycle_id = inACID;
1165:
1166: v_instance c_instances%ROWTYPE;
1167:

Line 1463: from zpb_analysis_cycle_instances

1459: avalue => InstanceID);
1460:
1461: select INSTANCE_DESCRIPTION
1462: into l_InstanceDesc
1463: from zpb_analysis_cycle_instances
1464: where instance_ac_id = InstanceID;
1465:
1466:
1467: wf_engine.SetItemAttrText(Itemtype => InstItemType,

Line 1557: update zpb_analysis_cycle_instances

1553: LAST_UPDATE_DATE = SYSDATE,
1554: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1555: where ANALYSIS_CYCLE_ID = InstanceID;
1556:
1557: update zpb_analysis_cycle_instances
1558: set last_update_date = sysdate,
1559: LAST_UPDATED_BY = fnd_global.USER_ID,
1560: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1561: where instance_ac_id = INSTANCEID;

Line 1650: from zpb_analysis_cycle_instances

1646:
1647:
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'))

Line 1651: where zpb_analysis_cycle_instances.ANALYSIS_CYCLE_ID = ACID

1647:
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;

Line 1702: update zpb_analysis_cycle_instances

1698: LAST_UPDATE_DATE = SYSDATE,
1699: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1700: where ANALYSIS_CYCLE_ID = InstanceID;
1701:
1702: update zpb_analysis_cycle_instances
1703: set last_update_date = sysdate,
1704: LAST_UPDATED_BY = fnd_global.USER_ID,
1705: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1706: where instance_ac_id = INSTANCEID;

Line 2751: from zpb_analysis_cycle_instances i,

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

Line 2783: update zpb_analysis_cycle_instances

2779: LAST_UPDATE_DATE = SYSDATE,
2780: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
2781: where ANALYSIS_CYCLE_ID = INSTANCEID;
2782:
2783: update zpb_analysis_cycle_instances
2784: set last_update_date = sysdate,
2785: LAST_UPDATED_BY = fnd_global.USER_ID,
2786: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
2787: where instance_ac_id = INSTANCEID;

Line 2914: update zpb_analysis_cycle_instances

2910: LAST_UPDATE_DATE = SYSDATE,
2911: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
2912: where ANALYSIS_CYCLE_ID = INSTANCEID;
2913:
2914: update zpb_analysis_cycle_instances
2915: set last_update_date = sysdate,
2916: LAST_UPDATED_BY = fnd_global.USER_ID,
2917: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
2918: where instance_ac_id = INSTANCEID;

Line 3320: FROM ZPB_ANALYSIS_CYCLE_INSTANCES zaci,

3316: -- There may be active overlapping instances of an AC
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

Line 3398: FROM ZPB_ANALYSIS_CYCLE_INSTANCES zaci,

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

Line 3412: FROM ZPB_ANALYSIS_CYCLE_INSTANCES zaci,

3408: SET status_code=CodeToUpdateTo
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

Line 3708: from ZPB_ANALYSIS_CYCLE_INSTANCES

3704: if instance_status='MARKED_FOR_DELETION' then
3705:
3706: -- abudnik 17NOV2005 BUSINESS AREA ID.
3707: select ANALYSIS_CYCLE_ID into ACID
3708: from ZPB_ANALYSIS_CYCLE_INSTANCES
3709: where INSTANCE_AC_ID = p_InstanceID;
3710:
3711: select BUSINESS_AREA_ID
3712: into l_business_area_id

Line 3750: update zpb_analysis_cycle_instances

3746: LAST_UPDATE_DATE = SYSDATE,
3747: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
3748: where ANALYSIS_CYCLE_ID = p_InstanceID;
3749:
3750: update zpb_analysis_cycle_instances
3751: set last_update_date = sysdate,
3752: LAST_UPDATED_BY = fnd_global.USER_ID,
3753: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
3754: where instance_ac_id = p_InstanceID;

Line 3771: update zpb_analysis_cycle_instances

3767: LAST_UPDATE_DATE = SYSDATE,
3768: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
3769: where ANALYSIS_CYCLE_ID = l_InstanceID;
3770:
3771: update zpb_analysis_cycle_instances
3772: set last_update_date = sysdate,
3773: LAST_UPDATED_BY = fnd_global.USER_ID,
3774: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
3775: where instance_ac_id = l_InstanceID;

Line 3786: from ZPB_ANALYSIS_CYCLE_INSTANCES

3782: -- if updated the status to ERROR, should check to see if any instances of this BP now need to be cleaned up
3783: if p_type='ERROR' then
3784:
3785: select ANALYSIS_CYCLE_ID into ACID
3786: from ZPB_ANALYSIS_CYCLE_INSTANCES
3787: where INSTANCE_AC_ID = p_InstanceID;
3788:
3789: ItemKey:='NOT_FOUND';
3790:

Line 3942: instanceDesc ZPB_ANALYSIS_CYCLE_INSTANCES.INSTANCE_DESCRIPTION%type;

3938: IS
3939: attached varchar2(1) := 'N';
3940: l_count number;
3941: --Bug - 5126892: Change start
3942: instanceDesc ZPB_ANALYSIS_CYCLE_INSTANCES.INSTANCE_DESCRIPTION%type;
3943: --Bug - 5126892: Change end
3944: BEGIN
3945:
3946: retcode := '0';

Line 3973: into instanceDesc from zpb_analysis_cycle_instances

3969: -- Bug: 5753320
3970: -- Handled the no_data_found exception
3971: Begin
3972: select instance_description
3973: into instanceDesc from zpb_analysis_cycle_instances
3974: where instance_ac_id = Instanceid;
3975: exception
3976: when no_data_found then
3977: instanceDesc := '-99-';

Line 3981: -- If there was no record in zpb_analysis_cycle_instances,

3977: instanceDesc := '-99-';
3978: end;
3979:
3980: -- Bug: 5753320
3981: -- If there was no record in zpb_analysis_cycle_instances,
3982: -- it means that the instance already got deleted.
3983: -- So, do not call calc.validate
3984: if (instanceDesc <> '-99-') then
3985: ZPB_AW.EXECUTE('call calc.validate(false,'''||To_CHAR(instanceDesc)||''',''' || TO_CHAR(UserID) || ''','''||'View'||''')');

Line 4187: FROM ZPB_ANALYSIS_CYCLE_INSTANCES zaci,

4183: return;
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

Line 4202: FROM ZPB_ANALYSIS_CYCLE_INSTANCES zaci2,

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

Line 4212: FROM ZPB_ANALYSIS_CYCLE_INSTANCES zaci,

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

Line 4484: from ZPB_ANALYSIS_CYCLE_INSTANCES

4480: ITEMTYPE := 'EPBCYCLE';
4481:
4482: -- get ACID ACNAME and ownerid
4483: select ANALYSIS_CYCLE_ID into ACID
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

Line 4537: update zpb_analysis_cycle_instances

4533: LAST_UPDATE_DATE = SYSDATE,
4534: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
4535: where ANALYSIS_CYCLE_ID = p_InstanceID;
4536:
4537: update zpb_analysis_cycle_instances
4538: set last_update_date = sysdate,
4539: LAST_UPDATED_BY = fnd_global.USER_ID,
4540: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
4541: where instance_ac_id = p_InstanceID;

Line 4664: update zpb_analysis_cycle_instances

4660: LAST_UPDATE_DATE = SYSDATE,
4661: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
4662: where ANALYSIS_CYCLE_ID = p_InstanceID;
4663:
4664: update zpb_analysis_cycle_instances
4665: set last_update_date = sysdate,
4666: LAST_UPDATED_BY = fnd_global.USER_ID,
4667: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
4668: where instance_ac_id = p_InstanceID;