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_AW

Line 811: ZPB_AW.INITIALIZE_FOR_AC (p_api_version => 1.0,

807:
808: DLcmd := 'call wf.call.mgr(' || taskID || ');';
809:
810:
811: ZPB_AW.INITIALIZE_FOR_AC (p_api_version => 1.0,
812: p_init_msg_list => FND_API.G_TRUE,
813: x_return_status => returnStat,
814: x_msg_count => thisCount,
815: x_msg_data => msgData,

Line 819: DataAW := ZPB_AW.GET_SHARED_AW;

815: x_msg_data => msgData,
816: p_analysis_cycle_id => ACID,
817: p_shared_rw => FND_API.G_FALSE);
818:
819: DataAW := ZPB_AW.GET_SHARED_AW;
820: CodeAW := ZPB_AW.GET_CODE_AW;
821: AnnoAW := ZPB_AW.GET_ANNOTATION_AW;
822:
823: -- abudnik 17NOV2005 BUSINESS AREA ID.

Line 820: CodeAW := ZPB_AW.GET_CODE_AW;

816: p_analysis_cycle_id => ACID,
817: p_shared_rw => FND_API.G_FALSE);
818:
819: DataAW := ZPB_AW.GET_SHARED_AW;
820: CodeAW := ZPB_AW.GET_CODE_AW;
821: AnnoAW := ZPB_AW.GET_ANNOTATION_AW;
822:
823: -- abudnik 17NOV2005 BUSINESS AREA ID.
824: reqID := FND_REQUEST.SUBMIT_REQUEST ('ZPB', 'ZPB_WF_TO_AW', NULL, NULL, FALSE, ACID, taskID, dataAW, CodeAW, AnnoAW, l_business_area_id);

Line 821: AnnoAW := ZPB_AW.GET_ANNOTATION_AW;

817: p_shared_rw => FND_API.G_FALSE);
818:
819: DataAW := ZPB_AW.GET_SHARED_AW;
820: CodeAW := ZPB_AW.GET_CODE_AW;
821: AnnoAW := ZPB_AW.GET_ANNOTATION_AW;
822:
823: -- abudnik 17NOV2005 BUSINESS AREA ID.
824: reqID := FND_REQUEST.SUBMIT_REQUEST ('ZPB', 'ZPB_WF_TO_AW', NULL, NULL, FALSE, ACID, taskID, dataAW, CodeAW, AnnoAW, l_business_area_id);
825:

Line 1258: zpb_aw.initialize (p_api_version => 1.0,

1254: l_tmpVar := l_tmpVar || opRec.lookup_code || ','||opRec.value ||':';
1255: end loop;
1256: l_tmpVar := l_tmpVar || ''' ''FROM_MAKE_INSTANCE'' )';
1257:
1258: zpb_aw.initialize (p_api_version => 1.0,
1259: x_return_status => l_retStat,
1260: x_msg_count => l_msgCnt,
1261: x_msg_data => l_msgData,
1262: p_business_area_id => sys_context('ZPB_CONTEXT', 'business_area_id'),

Line 1265: zpb_aw.execute(l_tmpVar);

1261: x_msg_data => l_msgData,
1262: p_business_area_id => sys_context('ZPB_CONTEXT', 'business_area_id'),
1263: p_shadow_id => sys_context('ZPB_CONTEXT','user_id'),
1264: p_shared_rw => FND_API.G_FALSE);
1265: zpb_aw.execute(l_tmpVar);
1266:
1267: return ;
1268: exception
1269: when others then

Line 2997: ZPB_AW.INITIALIZE_FOR_AC (p_api_version => 1.0,

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,
2999: x_return_status => returnStat,
3000: x_msg_count => thisCount,
3001: x_msg_data => msgData,

Line 3025: ZPB_AW.DETACH_ALL;

3021: -- for warnings from just above flow of calls.
3022: retcode := ZPB_ERROR_HANDLER.GET_CONC_REQ_STATUS;
3023:
3024:
3025: ZPB_AW.DETACH_ALL;
3026:
3027: return;
3028:
3029: exception

Line 3035: ZPB_AW.DETACH_ALL;

3031: when others then
3032: retcode :='2';
3033:
3034: if attached = 'Y' then
3035: ZPB_AW.DETACH_ALL;
3036: end if;
3037:
3038: -- update zpb instance info with ERROR
3039: UPDATE_STATUS('ERROR', l_InstanceID, taskid, NULL);

Line 3105: ZPB_AW_WRITE_BACK.SUBMIT_WRITEBACK_REQUEST(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,
3106: ownerID,
3107: respID,
3108: sessionID,
3109: 'SPL',

Line 3539: ZPB_AW.INITIALIZE_FOR_AC (p_api_version => 1.0,

3535: --log START Generate Physical Model
3536: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_GENPHYS_START');
3537: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
3538:
3539: ZPB_AW.INITIALIZE_FOR_AC (p_api_version => 1.0,
3540: p_init_msg_list => FND_API.G_TRUE,
3541: x_return_status => returnStat,
3542: x_msg_count => thisCount,
3543: x_msg_data => msgData,

Line 3551: ZPB_AW.DETACH_ALL;

3547: attached := 'Y';
3548:
3549: ZPB_GEN_PHYS_MODEL.GEN_PHYSICAL_MODEL(InstanceID);
3550:
3551: ZPB_AW.DETACH_ALL;
3552: attached := 'N';
3553:
3554: --log END Generate Physical Model has completed
3555: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_GENPHYS_END');

Line 3572: ZPB_AW.DETACH_ALL;

3568: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_GENPHYS_ERROR');
3569: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
3570:
3571: if attached = 'Y' then
3572: ZPB_AW.DETACH_ALL;
3573: end if;
3574:
3575: -- update zpb instance info with ERROR
3576: UPDATE_STATUS('ERROR', Instanceid);

Line 3600: ZPB_AW.INITIALIZE_FOR_AC (p_api_version => 1.0,

3596: -- set olap page pool size based on ZPB_OPPS_DATA_SOLVE profile setting
3597: zpb_util_pvt.set_opps(ZPB_UTIL_PVT.ZPB_OPPS_DATA_SOLVE, UserID);
3598:
3599: -- Test run of solve
3600: ZPB_AW.INITIALIZE_FOR_AC (p_api_version => 1.0,
3601: p_init_msg_list => FND_API.G_TRUE,
3602: x_return_status => retcode,
3603: x_msg_count => l_count,
3604: x_msg_data => errbuf,

Line 3609: l_dbname := ZPB_AW.GET_SCHEMA || '.' || ZPB_AW.GET_SHARED_AW;

3605: p_analysis_cycle_id => InstanceID,
3606: p_shared_rw => FND_API.G_TRUE);
3607: attached := 'Y';
3608:
3609: l_dbname := ZPB_AW.GET_SCHEMA || '.' || ZPB_AW.GET_SHARED_AW;
3610: ZPB_AW.EXECUTE('APPS_USER_ID = ''' || TO_CHAR(UserID) || '''');
3611:
3612: -- b 5170327 intializes the pv_status variable
3613: ZPB_ERROR_HANDLER.INIT_CONC_REQ_STATUS;

Line 3610: ZPB_AW.EXECUTE('APPS_USER_ID = ''' || TO_CHAR(UserID) || '''');

3606: p_shared_rw => FND_API.G_TRUE);
3607: attached := 'Y';
3608:
3609: l_dbname := ZPB_AW.GET_SCHEMA || '.' || ZPB_AW.GET_SHARED_AW;
3610: ZPB_AW.EXECUTE('APPS_USER_ID = ''' || TO_CHAR(UserID) || '''');
3611:
3612: -- b 5170327 intializes the pv_status variable
3613: ZPB_ERROR_HANDLER.INIT_CONC_REQ_STATUS;
3614: ZPB_AW.EXECUTE('call SV.RUN.SOLVE(''' || l_dbname || ''', ''' || TO_CHAR(Instanceid) || ''', ''' || TO_CHAR(taskid) || ''')');

Line 3614: ZPB_AW.EXECUTE('call SV.RUN.SOLVE(''' || l_dbname || ''', ''' || TO_CHAR(Instanceid) || ''', ''' || TO_CHAR(taskid) || ''')');

3610: ZPB_AW.EXECUTE('APPS_USER_ID = ''' || TO_CHAR(UserID) || '''');
3611:
3612: -- b 5170327 intializes the pv_status variable
3613: ZPB_ERROR_HANDLER.INIT_CONC_REQ_STATUS;
3614: ZPB_AW.EXECUTE('call SV.RUN.SOLVE(''' || l_dbname || ''', ''' || TO_CHAR(Instanceid) || ''', ''' || TO_CHAR(taskid) || ''')');
3615: -- b 5170327 - retcode is an OUT parameter conc program standard - 0=success, 1=warning or 2=error.
3616: retcode := ZPB_ERROR_HANDLER.GET_CONC_REQ_STATUS;
3617:
3618: -- update

Line 3619: ZPB_AW.EXECUTE('upd');

3615: -- b 5170327 - retcode is an OUT parameter conc program standard - 0=success, 1=warning or 2=error.
3616: retcode := ZPB_ERROR_HANDLER.GET_CONC_REQ_STATUS;
3617:
3618: -- update
3619: ZPB_AW.EXECUTE('upd');
3620: commit;
3621:
3622: ZPB_AW.DETACH_ALL;
3623: attached := 'N';

Line 3622: ZPB_AW.DETACH_ALL;

3618: -- update
3619: ZPB_AW.EXECUTE('upd');
3620: commit;
3621:
3622: ZPB_AW.DETACH_ALL;
3623: attached := 'N';
3624:
3625: --log solve OK
3626: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_SOLVEOK');

Line 3637: ZPB_AW.DETACH_ALL;

3633: when others then
3634: retcode :='2';
3635:
3636: if attached = 'Y' then
3637: ZPB_AW.DETACH_ALL;
3638: end if;
3639:
3640: --log solve OK
3641: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_SOLVE_NOTOK');

Line 3852: ZPB_AW_WRITE_BACK.SUBMIT_WRITEBACK_REQUEST

3848: ZPB_DC_OBJECTS B
3849: where B.AC_INSTANCE_ID = A.ANALYSIS_CYCLE_ID
3850: and B.TEMPLATE_ID = p_templateID;
3851:
3852: ZPB_AW_WRITE_BACK.SUBMIT_WRITEBACK_REQUEST
3853: (l_business_area_id,
3854: p_user,
3855: FND_GLOBAL.RESP_ID,
3856: FND_GLOBAL.SESSION_ID,

Line 3886: ZPB_AW.INITIALIZE_FOR_AC (p_api_version => 1.0,

3882: --log Initialization of Business Process Run data has started
3883: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_INIT_DATA_START');
3884: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
3885:
3886: ZPB_AW.INITIALIZE_FOR_AC (p_api_version => 1.0,
3887: p_init_msg_list => FND_API.G_TRUE,
3888: x_return_status => retcode,
3889: x_msg_count => l_count,
3890: x_msg_data => msgData,

Line 3894: l_dbname := ZPB_AW.GET_SCHEMA || '.' || ZPB_AW.GET_SHARED_AW;

3890: x_msg_data => msgData,
3891: p_analysis_cycle_id => InstanceID,
3892: p_shared_rw => FND_API.G_TRUE);
3893:
3894: l_dbname := ZPB_AW.GET_SCHEMA || '.' || ZPB_AW.GET_SHARED_AW;
3895: attached := 'Y';
3896:
3897:
3898: ZPB_AW.EXECUTE('call in.run.init(''' || l_dbname || ''', ''' || TO_CHAR(ACID) || ''', ''' || TO_CHAR(taskid) || ''', ''' || TO_CHAR(Instanceid) || ''')');

Line 3898: ZPB_AW.EXECUTE('call in.run.init(''' || l_dbname || ''', ''' || TO_CHAR(ACID) || ''', ''' || TO_CHAR(taskid) || ''', ''' || TO_CHAR(Instanceid) || ''')');

3894: l_dbname := ZPB_AW.GET_SCHEMA || '.' || ZPB_AW.GET_SHARED_AW;
3895: attached := 'Y';
3896:
3897:
3898: ZPB_AW.EXECUTE('call in.run.init(''' || l_dbname || ''', ''' || TO_CHAR(ACID) || ''', ''' || TO_CHAR(taskid) || ''', ''' || TO_CHAR(Instanceid) || ''')');
3899:
3900: -- update
3901: ZPB_AW.EXECUTE('upd');
3902: commit;

Line 3901: ZPB_AW.EXECUTE('upd');

3897:
3898: ZPB_AW.EXECUTE('call in.run.init(''' || l_dbname || ''', ''' || TO_CHAR(ACID) || ''', ''' || TO_CHAR(taskid) || ''', ''' || TO_CHAR(Instanceid) || ''')');
3899:
3900: -- update
3901: ZPB_AW.EXECUTE('upd');
3902: commit;
3903:
3904: ZPB_AW.DETACH_ALL;
3905: attached := 'N';

Line 3904: ZPB_AW.DETACH_ALL;

3900: -- update
3901: ZPB_AW.EXECUTE('upd');
3902: commit;
3903:
3904: ZPB_AW.DETACH_ALL;
3905: attached := 'N';
3906:
3907: --log Initialization of Business Process Run data has completed
3908: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_INIT_DATA_END');

Line 3918: ZPB_AW.DETACH_ALL;

3914: when others then
3915: -- retcode :='2';
3916:
3917: if attached = 'Y' then
3918: ZPB_AW.DETACH_ALL;
3919: end if;
3920:
3921: --log Initialization of Business Process Run data encountered an error
3922: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_INIT_DATA_ERROR');

Line 3955: ZPB_AW.INITIALIZE_FOR_AC (p_api_version => 1.0,

3951:
3952: delete from zpb_measures
3953: where instance_id = InstanceID;
3954:
3955: ZPB_AW.INITIALIZE_FOR_AC (p_api_version => 1.0,
3956: p_init_msg_list => FND_API.G_TRUE,
3957: x_return_status => retcode,
3958: x_msg_count => l_count,
3959: x_msg_data => errbuf,

Line 3965: ZPB_AW.EXECUTE('call cm.delshinsts(''' || TO_CHAR(Instanceid) || ''')');

3961: p_shared_rw => FND_API.G_TRUE,
3962: p_annot_rw => FND_API.G_TRUE);
3963: attached := 'Y';
3964:
3965: ZPB_AW.EXECUTE('call cm.delshinsts(''' || TO_CHAR(Instanceid) || ''')');
3966:
3967: --Bug - 5126892: Change start
3968:
3969: -- Bug: 5753320

Line 3985: ZPB_AW.EXECUTE('call calc.validate(false,'''||To_CHAR(instanceDesc)||''',''' || TO_CHAR(UserID) || ''','''||'View'||''')');

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'||''')');
3986: end if;
3987: --Bug - 5126892: Change end
3988:
3989: -- update

Line 3990: ZPB_AW.EXECUTE('upd');

3986: end if;
3987: --Bug - 5126892: Change end
3988:
3989: -- update
3990: ZPB_AW.EXECUTE('upd');
3991: commit;
3992:
3993: ZPB_AW.DETACH_ALL;
3994: attached := 'N';

Line 3993: ZPB_AW.DETACH_ALL;

3989: -- update
3990: ZPB_AW.EXECUTE('upd');
3991: commit;
3992:
3993: ZPB_AW.DETACH_ALL;
3994: attached := 'N';
3995:
3996: --log DEL INST OK
3997: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_ENDDELINST');

Line 4008: ZPB_AW.DETACH_ALL;

4004: when others then
4005: retcode :='2';
4006:
4007: if attached = 'Y' then
4008: ZPB_AW.DETACH_ALL;
4009: end if;
4010:
4011: --log DEL INST ERR
4012: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_WF_ERRDELINST');

Line 4291: ZPB_AW_WRITE_BACK.SUBMIT_WRITEBACK_REQUEST(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,
4292: ownerID,
4293: respID,
4294: sessionID,
4295: 'SPL',