APPS.PJI_PJP_SUM_MAIN dependencies on PJI_PJP_SUM_ROLLUP

Line 1352: --- pji_pjp_sum_rollup.rollup_fpr_wbs(null);

1348: -- pji_utils.write2log('Inserted records into pjp1'||sql%rowcount);
1349: -- for -3,-4 lines having prg_rollup_flag = 'N'
1350: -- pji_utils.write2log('Before rollup_fpr_wbs');
1351:
1352: --- pji_pjp_sum_rollup.rollup_fpr_wbs(null);
1353: for c in C_BOTTOM_UP loop
1354:
1355: l_level := c.SUP_LEVEL;
1356:

Line 3905: PJI_PJP_SUM_ROLLUP.POPULATE_TIME_DIMENSION(p_worker_id);

3901: l_profile_check := FND_PROFILE.VALUE('PJI_SUM_CLEANALL');
3902:
3903: PJI_PJP_EXTRACTION_UTILS.SEED_PJI_PJP_STATS(p_worker_id);
3904:
3905: PJI_PJP_SUM_ROLLUP.POPULATE_TIME_DIMENSION(p_worker_id);
3906:
3907: PJI_PJP_EXTRACTION_UTILS.POPULATE_ORG_EXTR_INFO;
3908:
3909: -- implicit commit

Line 3920: PJI_PJP_SUM_ROLLUP.SET_ONLINE_CONTEXT(null, null, null, null, null, null,

3916: FND_STATS.GATHER_INDEX_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3917: indname => 'PJI_ORG_EXTR_INFO_N1',
3918: percent => 10);
3919:
3920: PJI_PJP_SUM_ROLLUP.SET_ONLINE_CONTEXT(null, null, null, null, null, null,
3921: null, null, null, null);
3922:
3923: PJI_PJP_SUM_ROLLUP.CREATE_EVENTS_SNAPSHOT(p_worker_id);
3924:

Line 3923: PJI_PJP_SUM_ROLLUP.CREATE_EVENTS_SNAPSHOT(p_worker_id);

3919:
3920: PJI_PJP_SUM_ROLLUP.SET_ONLINE_CONTEXT(null, null, null, null, null, null,
3921: null, null, null, null);
3922:
3923: PJI_PJP_SUM_ROLLUP.CREATE_EVENTS_SNAPSHOT(p_worker_id);
3924:
3925: PJI_PJP_SUM_ROLLUP.LOCK_HEADERS(p_worker_id);
3926:
3927: /* plan type code changes (4882640) This API call will be shifted to step entry */

Line 3925: PJI_PJP_SUM_ROLLUP.LOCK_HEADERS(p_worker_id);

3921: null, null, null, null);
3922:
3923: PJI_PJP_SUM_ROLLUP.CREATE_EVENTS_SNAPSHOT(p_worker_id);
3924:
3925: PJI_PJP_SUM_ROLLUP.LOCK_HEADERS(p_worker_id);
3926:
3927: /* plan type code changes (4882640) This API call will be shifted to step entry */
3928: if (PJI_UTILS.GET_PARAMETER('PJI_PTC_UPGRADE') = 'P') and l_extraction_type <> 'PARTIAL' then
3929: PLAN_TYPE_CODE_CHANGES (p_worker_id);

Line 3934: PJI_PJP_SUM_ROLLUP.PROCESS_RBS_CHANGES(p_worker_id);

3930: end if;
3931: /*---------- plan type code changes (4882640) ------------*/
3932:
3933:
3934: PJI_PJP_SUM_ROLLUP.PROCESS_RBS_CHANGES(p_worker_id);
3935:
3936: PJI_PJP_SUM_DENORM.POPULATE_XBS_DENORM(p_worker_id, 'ALL',
3937: null, null, null);
3938:

Line 3939: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM_FULL(p_worker_id);

3935:
3936: PJI_PJP_SUM_DENORM.POPULATE_XBS_DENORM(p_worker_id, 'ALL',
3937: null, null, null);
3938:
3939: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM_FULL(p_worker_id);
3940:
3941: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_WBS(p_worker_id);
3942: PJI_PJP_SUM_ROLLUP.PURGE_EVENT_DATA(p_worker_id);
3943: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_RBS(p_worker_id);

Line 3941: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_WBS(p_worker_id);

3937: null, null, null);
3938:
3939: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM_FULL(p_worker_id);
3940:
3941: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_WBS(p_worker_id);
3942: PJI_PJP_SUM_ROLLUP.PURGE_EVENT_DATA(p_worker_id);
3943: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_RBS(p_worker_id);
3944:
3945: PJI_PJP_SUM_ROLLUP.CREATE_MAPPING_RULES(p_worker_id);

Line 3942: PJI_PJP_SUM_ROLLUP.PURGE_EVENT_DATA(p_worker_id);

3938:
3939: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM_FULL(p_worker_id);
3940:
3941: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_WBS(p_worker_id);
3942: PJI_PJP_SUM_ROLLUP.PURGE_EVENT_DATA(p_worker_id);
3943: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_RBS(p_worker_id);
3944:
3945: PJI_PJP_SUM_ROLLUP.CREATE_MAPPING_RULES(p_worker_id);
3946: PJI_PJP_SUM_ROLLUP.MAP_RBS_HEADERS(p_worker_id);

Line 3943: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_RBS(p_worker_id);

3939: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM_FULL(p_worker_id);
3940:
3941: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_WBS(p_worker_id);
3942: PJI_PJP_SUM_ROLLUP.PURGE_EVENT_DATA(p_worker_id);
3943: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_RBS(p_worker_id);
3944:
3945: PJI_PJP_SUM_ROLLUP.CREATE_MAPPING_RULES(p_worker_id);
3946: PJI_PJP_SUM_ROLLUP.MAP_RBS_HEADERS(p_worker_id);
3947:

Line 3945: PJI_PJP_SUM_ROLLUP.CREATE_MAPPING_RULES(p_worker_id);

3941: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_WBS(p_worker_id);
3942: PJI_PJP_SUM_ROLLUP.PURGE_EVENT_DATA(p_worker_id);
3943: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_RBS(p_worker_id);
3944:
3945: PJI_PJP_SUM_ROLLUP.CREATE_MAPPING_RULES(p_worker_id);
3946: PJI_PJP_SUM_ROLLUP.MAP_RBS_HEADERS(p_worker_id);
3947:
3948: PJI_PJP_SUM_DENORM.POPULATE_RBS_DENORM(p_worker_id, 'ALL', null);
3949:

Line 3946: PJI_PJP_SUM_ROLLUP.MAP_RBS_HEADERS(p_worker_id);

3942: PJI_PJP_SUM_ROLLUP.PURGE_EVENT_DATA(p_worker_id);
3943: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_RBS(p_worker_id);
3944:
3945: PJI_PJP_SUM_ROLLUP.CREATE_MAPPING_RULES(p_worker_id);
3946: PJI_PJP_SUM_ROLLUP.MAP_RBS_HEADERS(p_worker_id);
3947:
3948: PJI_PJP_SUM_DENORM.POPULATE_RBS_DENORM(p_worker_id, 'ALL', null);
3949:
3950: PJI_PJP_SUM_ROLLUP.POPULATE_XBS_DENORM_DELTA(p_worker_id);

Line 3950: PJI_PJP_SUM_ROLLUP.POPULATE_XBS_DENORM_DELTA(p_worker_id);

3946: PJI_PJP_SUM_ROLLUP.MAP_RBS_HEADERS(p_worker_id);
3947:
3948: PJI_PJP_SUM_DENORM.POPULATE_RBS_DENORM(p_worker_id, 'ALL', null);
3949:
3950: PJI_PJP_SUM_ROLLUP.POPULATE_XBS_DENORM_DELTA(p_worker_id);
3951: PJI_PJP_SUM_ROLLUP.POPULATE_RBS_DENORM_DELTA(p_worker_id);
3952:
3953: PJI_FM_SUM_PSI.BALANCES_ROWID_TABLE(p_worker_id);
3954: PJI_FM_SUM_PSI.ACT_ROWID_TABLE(p_worker_id);

Line 3951: PJI_PJP_SUM_ROLLUP.POPULATE_RBS_DENORM_DELTA(p_worker_id);

3947:
3948: PJI_PJP_SUM_DENORM.POPULATE_RBS_DENORM(p_worker_id, 'ALL', null);
3949:
3950: PJI_PJP_SUM_ROLLUP.POPULATE_XBS_DENORM_DELTA(p_worker_id);
3951: PJI_PJP_SUM_ROLLUP.POPULATE_RBS_DENORM_DELTA(p_worker_id);
3952:
3953: PJI_FM_SUM_PSI.BALANCES_ROWID_TABLE(p_worker_id);
3954: PJI_FM_SUM_PSI.ACT_ROWID_TABLE(p_worker_id);
3955:

Line 3956: PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_SLICES(p_worker_id);

3952:
3953: PJI_FM_SUM_PSI.BALANCES_ROWID_TABLE(p_worker_id);
3954: PJI_FM_SUM_PSI.ACT_ROWID_TABLE(p_worker_id);
3955:
3956: PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_SLICES(p_worker_id);
3957: PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_SLICES(p_worker_id);
3958:
3959: /* Added for bug 8353629 */
3960: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

Line 3957: PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_SLICES(p_worker_id);

3953: PJI_FM_SUM_PSI.BALANCES_ROWID_TABLE(p_worker_id);
3954: PJI_FM_SUM_PSI.ACT_ROWID_TABLE(p_worker_id);
3955:
3956: PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_SLICES(p_worker_id);
3957: PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_SLICES(p_worker_id);
3958:
3959: /* Added for bug 8353629 */
3960: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3961: tabname => 'PJI_FP_AGGR_PJP0',

Line 3974: PJI_PJP_SUM_ROLLUP.MARK_EXTRACTED_PROJECTS(p_worker_id);

3970: GET_DEGREE_OF_PARALLELISM);
3971: /* Added for bug 8353629 */
3972:
3973:
3974: PJI_PJP_SUM_ROLLUP.MARK_EXTRACTED_PROJECTS(p_worker_id);
3975:
3976: PJI_PJP_SUM_CUST.PJP_CUSTOM_FPR_API(p_worker_id);
3977: PJI_PJP_SUM_CUST.PJP_CUSTOM_ACR_API(p_worker_id);
3978:

Line 3979: PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_CUST_SLICES(p_worker_id);

3975:
3976: PJI_PJP_SUM_CUST.PJP_CUSTOM_FPR_API(p_worker_id);
3977: PJI_PJP_SUM_CUST.PJP_CUSTOM_ACR_API(p_worker_id);
3978:
3979: PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_CUST_SLICES(p_worker_id);
3980: PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_CUST_SLICES(p_worker_id);
3981:
3982: PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS(p_worker_id);
3983: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_PR(p_worker_id);

Line 3980: PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_CUST_SLICES(p_worker_id);

3976: PJI_PJP_SUM_CUST.PJP_CUSTOM_FPR_API(p_worker_id);
3977: PJI_PJP_SUM_CUST.PJP_CUSTOM_ACR_API(p_worker_id);
3978:
3979: PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_CUST_SLICES(p_worker_id);
3980: PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_CUST_SLICES(p_worker_id);
3981:
3982: PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS(p_worker_id);
3983: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_PR(p_worker_id);
3984: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_RBS(p_worker_id);

Line 3982: PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS(p_worker_id);

3978:
3979: PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_CUST_SLICES(p_worker_id);
3980: PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_CUST_SLICES(p_worker_id);
3981:
3982: PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS(p_worker_id);
3983: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_PR(p_worker_id);
3984: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_RBS(p_worker_id);
3985: PJI_PJP_SUM_ROLLUP.PULL_DANGLING_PLANS(p_worker_id);
3986: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_PLAN_UPDATES(p_worker_id);

Line 3983: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_PR(p_worker_id);

3979: PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_CUST_SLICES(p_worker_id);
3980: PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_CUST_SLICES(p_worker_id);
3981:
3982: PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS(p_worker_id);
3983: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_PR(p_worker_id);
3984: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_RBS(p_worker_id);
3985: PJI_PJP_SUM_ROLLUP.PULL_DANGLING_PLANS(p_worker_id);
3986: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_PLAN_UPDATES(p_worker_id);
3987:

Line 3984: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_RBS(p_worker_id);

3980: PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_CUST_SLICES(p_worker_id);
3981:
3982: PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS(p_worker_id);
3983: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_PR(p_worker_id);
3984: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_RBS(p_worker_id);
3985: PJI_PJP_SUM_ROLLUP.PULL_DANGLING_PLANS(p_worker_id);
3986: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_PLAN_UPDATES(p_worker_id);
3987:
3988: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_ALL(p_worker_id);

Line 3985: PJI_PJP_SUM_ROLLUP.PULL_DANGLING_PLANS(p_worker_id);

3981:
3982: PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS(p_worker_id);
3983: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_PR(p_worker_id);
3984: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_RBS(p_worker_id);
3985: PJI_PJP_SUM_ROLLUP.PULL_DANGLING_PLANS(p_worker_id);
3986: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_PLAN_UPDATES(p_worker_id);
3987:
3988: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_ALL(p_worker_id);
3989: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_ALL(p_worker_id);

Line 3986: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_PLAN_UPDATES(p_worker_id);

3982: PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS(p_worker_id);
3983: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_PR(p_worker_id);
3984: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_RBS(p_worker_id);
3985: PJI_PJP_SUM_ROLLUP.PULL_DANGLING_PLANS(p_worker_id);
3986: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_PLAN_UPDATES(p_worker_id);
3987:
3988: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_ALL(p_worker_id);
3989: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_ALL(p_worker_id);
3990:

Line 3988: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_ALL(p_worker_id);

3984: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_RBS(p_worker_id);
3985: PJI_PJP_SUM_ROLLUP.PULL_DANGLING_PLANS(p_worker_id);
3986: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_PLAN_UPDATES(p_worker_id);
3987:
3988: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_ALL(p_worker_id);
3989: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_ALL(p_worker_id);
3990:
3991: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_NONTP(p_worker_id);
3992: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_PA(p_worker_id);

Line 3989: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_ALL(p_worker_id);

3985: PJI_PJP_SUM_ROLLUP.PULL_DANGLING_PLANS(p_worker_id);
3986: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_PLAN_UPDATES(p_worker_id);
3987:
3988: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_ALL(p_worker_id);
3989: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_ALL(p_worker_id);
3990:
3991: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_NONTP(p_worker_id);
3992: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_PA(p_worker_id);
3993: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_GL(p_worker_id);

Line 3991: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_NONTP(p_worker_id);

3987:
3988: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_ALL(p_worker_id);
3989: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_ALL(p_worker_id);
3990:
3991: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_NONTP(p_worker_id);
3992: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_PA(p_worker_id);
3993: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_GL(p_worker_id);
3994: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_EN(p_worker_id);
3995: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_PA(p_worker_id);

Line 3992: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_PA(p_worker_id);

3988: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_ALL(p_worker_id);
3989: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_ALL(p_worker_id);
3990:
3991: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_NONTP(p_worker_id);
3992: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_PA(p_worker_id);
3993: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_GL(p_worker_id);
3994: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_EN(p_worker_id);
3995: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_PA(p_worker_id);
3996: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_GL(p_worker_id);

Line 3993: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_GL(p_worker_id);

3989: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_ALL(p_worker_id);
3990:
3991: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_NONTP(p_worker_id);
3992: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_PA(p_worker_id);
3993: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_GL(p_worker_id);
3994: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_EN(p_worker_id);
3995: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_PA(p_worker_id);
3996: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_GL(p_worker_id);
3997: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_EN(p_worker_id);

Line 3994: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_EN(p_worker_id);

3990:
3991: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_NONTP(p_worker_id);
3992: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_PA(p_worker_id);
3993: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_GL(p_worker_id);
3994: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_EN(p_worker_id);
3995: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_PA(p_worker_id);
3996: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_GL(p_worker_id);
3997: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_EN(p_worker_id);
3998:

Line 3995: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_PA(p_worker_id);

3991: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_NONTP(p_worker_id);
3992: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_PA(p_worker_id);
3993: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_GL(p_worker_id);
3994: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_EN(p_worker_id);
3995: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_PA(p_worker_id);
3996: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_GL(p_worker_id);
3997: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_EN(p_worker_id);
3998:
3999: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_TOP(p_worker_id);

Line 3996: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_GL(p_worker_id);

3992: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_PA(p_worker_id);
3993: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_GL(p_worker_id);
3994: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_EN(p_worker_id);
3995: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_PA(p_worker_id);
3996: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_GL(p_worker_id);
3997: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_EN(p_worker_id);
3998:
3999: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_TOP(p_worker_id);
4000: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);

Line 3997: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_EN(p_worker_id);

3993: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_GL(p_worker_id);
3994: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_EN(p_worker_id);
3995: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_PA(p_worker_id);
3996: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_GL(p_worker_id);
3997: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_EN(p_worker_id);
3998:
3999: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_TOP(p_worker_id);
4000: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);
4001: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_WBS(p_worker_id);

Line 3999: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_TOP(p_worker_id);

3995: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_PA(p_worker_id);
3996: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_GL(p_worker_id);
3997: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_EN(p_worker_id);
3998:
3999: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_TOP(p_worker_id);
4000: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);
4001: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_WBS(p_worker_id);
4002:
4003: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_PRG(p_worker_id);

Line 4000: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);

3996: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_GL(p_worker_id);
3997: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_EN(p_worker_id);
3998:
3999: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_TOP(p_worker_id);
4000: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);
4001: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_WBS(p_worker_id);
4002:
4003: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_PRG(p_worker_id);
4004: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_PRG(p_worker_id);

Line 4001: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_WBS(p_worker_id);

3997: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_EN(p_worker_id);
3998:
3999: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_TOP(p_worker_id);
4000: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);
4001: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_WBS(p_worker_id);
4002:
4003: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_PRG(p_worker_id);
4004: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_PRG(p_worker_id);
4005:

Line 4003: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_PRG(p_worker_id);

3999: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_TOP(p_worker_id);
4000: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);
4001: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_WBS(p_worker_id);
4002:
4003: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_PRG(p_worker_id);
4004: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_PRG(p_worker_id);
4005:
4006: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES(p_worker_id);
4007:

Line 4004: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_PRG(p_worker_id);

4000: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);
4001: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_WBS(p_worker_id);
4002:
4003: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_PRG(p_worker_id);
4004: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_PRG(p_worker_id);
4005:
4006: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES(p_worker_id);
4007:
4008: PJI_PJP_SUM_ROLLUP.AGGREGATE_PLAN_DATA(p_worker_id);

Line 4006: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES(p_worker_id);

4002:
4003: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_PRG(p_worker_id);
4004: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_PRG(p_worker_id);
4005:
4006: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES(p_worker_id);
4007:
4008: PJI_PJP_SUM_ROLLUP.AGGREGATE_PLAN_DATA(p_worker_id);
4009: PJI_PJP_SUM_ROLLUP.PURGE_PLAN_DATA(p_worker_id);
4010:

Line 4008: PJI_PJP_SUM_ROLLUP.AGGREGATE_PLAN_DATA(p_worker_id);

4004: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_PRG(p_worker_id);
4005:
4006: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES(p_worker_id);
4007:
4008: PJI_PJP_SUM_ROLLUP.AGGREGATE_PLAN_DATA(p_worker_id);
4009: PJI_PJP_SUM_ROLLUP.PURGE_PLAN_DATA(p_worker_id);
4010:
4011: PJI_PJP_SUM_ROLLUP.UPDATE_WBS_HDR(p_worker_id);
4012:

Line 4009: PJI_PJP_SUM_ROLLUP.PURGE_PLAN_DATA(p_worker_id);

4005:
4006: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES(p_worker_id);
4007:
4008: PJI_PJP_SUM_ROLLUP.AGGREGATE_PLAN_DATA(p_worker_id);
4009: PJI_PJP_SUM_ROLLUP.PURGE_PLAN_DATA(p_worker_id);
4010:
4011: PJI_PJP_SUM_ROLLUP.UPDATE_WBS_HDR(p_worker_id);
4012:
4013:

Line 4011: PJI_PJP_SUM_ROLLUP.UPDATE_WBS_HDR(p_worker_id);

4007:
4008: PJI_PJP_SUM_ROLLUP.AGGREGATE_PLAN_DATA(p_worker_id);
4009: PJI_PJP_SUM_ROLLUP.PURGE_PLAN_DATA(p_worker_id);
4010:
4011: PJI_PJP_SUM_ROLLUP.UPDATE_WBS_HDR(p_worker_id);
4012:
4013:
4014: /* Addded for Bug 8708651 Start */
4015: /* if (l_profile_check = 'Y') then

Line 4016: PJI_PJP_SUM_ROLLUP.GET_FPR_ROWIDS(p_worker_id);

4012:
4013:
4014: /* Addded for Bug 8708651 Start */
4015: /* if (l_profile_check = 'Y') then
4016: PJI_PJP_SUM_ROLLUP.GET_FPR_ROWIDS(p_worker_id);
4017: PJI_PJP_SUM_ROLLUP.UPDATE_FPR_ROWS(p_worker_id);
4018: PJI_PJP_SUM_ROLLUP.INSERT_FPR_ROWS(p_worker_id);
4019: PJI_PJP_SUM_ROLLUP.CLEANUP_FPR_ROWID_TABLE(p_worker_id);
4020: else

Line 4017: PJI_PJP_SUM_ROLLUP.UPDATE_FPR_ROWS(p_worker_id);

4013:
4014: /* Addded for Bug 8708651 Start */
4015: /* if (l_profile_check = 'Y') then
4016: PJI_PJP_SUM_ROLLUP.GET_FPR_ROWIDS(p_worker_id);
4017: PJI_PJP_SUM_ROLLUP.UPDATE_FPR_ROWS(p_worker_id);
4018: PJI_PJP_SUM_ROLLUP.INSERT_FPR_ROWS(p_worker_id);
4019: PJI_PJP_SUM_ROLLUP.CLEANUP_FPR_ROWID_TABLE(p_worker_id);
4020: else
4021: PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACTS(p_worker_id);

Line 4018: PJI_PJP_SUM_ROLLUP.INSERT_FPR_ROWS(p_worker_id);

4014: /* Addded for Bug 8708651 Start */
4015: /* if (l_profile_check = 'Y') then
4016: PJI_PJP_SUM_ROLLUP.GET_FPR_ROWIDS(p_worker_id);
4017: PJI_PJP_SUM_ROLLUP.UPDATE_FPR_ROWS(p_worker_id);
4018: PJI_PJP_SUM_ROLLUP.INSERT_FPR_ROWS(p_worker_id);
4019: PJI_PJP_SUM_ROLLUP.CLEANUP_FPR_ROWID_TABLE(p_worker_id);
4020: else
4021: PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACTS(p_worker_id);
4022: end if;*/ -- Commented for AWE bug 13727835

Line 4019: PJI_PJP_SUM_ROLLUP.CLEANUP_FPR_ROWID_TABLE(p_worker_id);

4015: /* if (l_profile_check = 'Y') then
4016: PJI_PJP_SUM_ROLLUP.GET_FPR_ROWIDS(p_worker_id);
4017: PJI_PJP_SUM_ROLLUP.UPDATE_FPR_ROWS(p_worker_id);
4018: PJI_PJP_SUM_ROLLUP.INSERT_FPR_ROWS(p_worker_id);
4019: PJI_PJP_SUM_ROLLUP.CLEANUP_FPR_ROWID_TABLE(p_worker_id);
4020: else
4021: PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACTS(p_worker_id);
4022: end if;*/ -- Commented for AWE bug 13727835
4023: /* Addded for Bug 8708651 End */

Line 4021: PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACTS(p_worker_id);

4017: PJI_PJP_SUM_ROLLUP.UPDATE_FPR_ROWS(p_worker_id);
4018: PJI_PJP_SUM_ROLLUP.INSERT_FPR_ROWS(p_worker_id);
4019: PJI_PJP_SUM_ROLLUP.CLEANUP_FPR_ROWID_TABLE(p_worker_id);
4020: else
4021: PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACTS(p_worker_id);
4022: end if;*/ -- Commented for AWE bug 13727835
4023: /* Addded for Bug 8708651 End */
4024:
4025: PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACTS(p_worker_id); -- Added for AWE bug 13727835

Line 4025: PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACTS(p_worker_id); -- Added for AWE bug 13727835

4021: PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACTS(p_worker_id);
4022: end if;*/ -- Commented for AWE bug 13727835
4023: /* Addded for Bug 8708651 End */
4024:
4025: PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACTS(p_worker_id); -- Added for AWE bug 13727835
4026:
4027: PJI_PJP_SUM_ROLLUP.GET_ACR_ROWIDS(p_worker_id);
4028: PJI_PJP_SUM_ROLLUP.UPDATE_ACR_ROWS(p_worker_id);
4029: PJI_PJP_SUM_ROLLUP.INSERT_ACR_ROWS(p_worker_id);

Line 4027: PJI_PJP_SUM_ROLLUP.GET_ACR_ROWIDS(p_worker_id);

4023: /* Addded for Bug 8708651 End */
4024:
4025: PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACTS(p_worker_id); -- Added for AWE bug 13727835
4026:
4027: PJI_PJP_SUM_ROLLUP.GET_ACR_ROWIDS(p_worker_id);
4028: PJI_PJP_SUM_ROLLUP.UPDATE_ACR_ROWS(p_worker_id);
4029: PJI_PJP_SUM_ROLLUP.INSERT_ACR_ROWS(p_worker_id);
4030: PJI_PJP_SUM_ROLLUP.CLEANUP_ACR_ROWID_TABLE(p_worker_id);
4031:

Line 4028: PJI_PJP_SUM_ROLLUP.UPDATE_ACR_ROWS(p_worker_id);

4024:
4025: PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACTS(p_worker_id); -- Added for AWE bug 13727835
4026:
4027: PJI_PJP_SUM_ROLLUP.GET_ACR_ROWIDS(p_worker_id);
4028: PJI_PJP_SUM_ROLLUP.UPDATE_ACR_ROWS(p_worker_id);
4029: PJI_PJP_SUM_ROLLUP.INSERT_ACR_ROWS(p_worker_id);
4030: PJI_PJP_SUM_ROLLUP.CLEANUP_ACR_ROWID_TABLE(p_worker_id);
4031:
4032: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM(p_worker_id);

Line 4029: PJI_PJP_SUM_ROLLUP.INSERT_ACR_ROWS(p_worker_id);

4025: PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACTS(p_worker_id); -- Added for AWE bug 13727835
4026:
4027: PJI_PJP_SUM_ROLLUP.GET_ACR_ROWIDS(p_worker_id);
4028: PJI_PJP_SUM_ROLLUP.UPDATE_ACR_ROWS(p_worker_id);
4029: PJI_PJP_SUM_ROLLUP.INSERT_ACR_ROWS(p_worker_id);
4030: PJI_PJP_SUM_ROLLUP.CLEANUP_ACR_ROWID_TABLE(p_worker_id);
4031:
4032: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM(p_worker_id);
4033: PJI_PJP_SUM_ROLLUP.UPDATE_RBS_DENORM(p_worker_id);

Line 4030: PJI_PJP_SUM_ROLLUP.CLEANUP_ACR_ROWID_TABLE(p_worker_id);

4026:
4027: PJI_PJP_SUM_ROLLUP.GET_ACR_ROWIDS(p_worker_id);
4028: PJI_PJP_SUM_ROLLUP.UPDATE_ACR_ROWS(p_worker_id);
4029: PJI_PJP_SUM_ROLLUP.INSERT_ACR_ROWS(p_worker_id);
4030: PJI_PJP_SUM_ROLLUP.CLEANUP_ACR_ROWID_TABLE(p_worker_id);
4031:
4032: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM(p_worker_id);
4033: PJI_PJP_SUM_ROLLUP.UPDATE_RBS_DENORM(p_worker_id);
4034:

Line 4032: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM(p_worker_id);

4028: PJI_PJP_SUM_ROLLUP.UPDATE_ACR_ROWS(p_worker_id);
4029: PJI_PJP_SUM_ROLLUP.INSERT_ACR_ROWS(p_worker_id);
4030: PJI_PJP_SUM_ROLLUP.CLEANUP_ACR_ROWID_TABLE(p_worker_id);
4031:
4032: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM(p_worker_id);
4033: PJI_PJP_SUM_ROLLUP.UPDATE_RBS_DENORM(p_worker_id);
4034:
4035: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_EVENTS(p_worker_id);
4036: PJI_PJP_SUM_ROLLUP.GET_TASK_ROLLUP_ACTUALS(p_worker_id);

Line 4033: PJI_PJP_SUM_ROLLUP.UPDATE_RBS_DENORM(p_worker_id);

4029: PJI_PJP_SUM_ROLLUP.INSERT_ACR_ROWS(p_worker_id);
4030: PJI_PJP_SUM_ROLLUP.CLEANUP_ACR_ROWID_TABLE(p_worker_id);
4031:
4032: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM(p_worker_id);
4033: PJI_PJP_SUM_ROLLUP.UPDATE_RBS_DENORM(p_worker_id);
4034:
4035: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_EVENTS(p_worker_id);
4036: PJI_PJP_SUM_ROLLUP.GET_TASK_ROLLUP_ACTUALS(p_worker_id);
4037:

Line 4035: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_EVENTS(p_worker_id);

4031:
4032: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM(p_worker_id);
4033: PJI_PJP_SUM_ROLLUP.UPDATE_RBS_DENORM(p_worker_id);
4034:
4035: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_EVENTS(p_worker_id);
4036: PJI_PJP_SUM_ROLLUP.GET_TASK_ROLLUP_ACTUALS(p_worker_id);
4037:
4038: PJI_FM_SUM_PSI.BALANCES_UPDATE_DELTA(p_worker_id);
4039: PJI_FM_SUM_PSI.BALANCES_INSERT_DELTA(p_worker_id);

Line 4036: PJI_PJP_SUM_ROLLUP.GET_TASK_ROLLUP_ACTUALS(p_worker_id);

4032: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM(p_worker_id);
4033: PJI_PJP_SUM_ROLLUP.UPDATE_RBS_DENORM(p_worker_id);
4034:
4035: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_EVENTS(p_worker_id);
4036: PJI_PJP_SUM_ROLLUP.GET_TASK_ROLLUP_ACTUALS(p_worker_id);
4037:
4038: PJI_FM_SUM_PSI.BALANCES_UPDATE_DELTA(p_worker_id);
4039: PJI_FM_SUM_PSI.BALANCES_INSERT_DELTA(p_worker_id);
4040: PJI_FM_SUM_PSI.PURGE_BALANCES_CMT(p_worker_id);

Line 4045: PJI_PJP_SUM_ROLLUP.UNLOCK_ALL_HEADERS(p_worker_id);

4041: PJI_FM_SUM_PSI.BALANCES_INSERT_DELTA_CMT(p_worker_id);
4042: PJI_FM_SUM_PSI.PURGE_INCREMENTAL_BALANCES(p_worker_id);
4043: PJI_FM_SUM_PSI.PURGE_BALANCES_ACT(p_worker_id);
4044:
4045: PJI_PJP_SUM_ROLLUP.UNLOCK_ALL_HEADERS(p_worker_id);
4046: PJI_PJP_SUM_ROLLUP.CLEANUP(p_worker_id);
4047:
4048: -- if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4049: -- (l_process, 'FROM_PROJECT_ID') = -1 and

Line 4046: PJI_PJP_SUM_ROLLUP.CLEANUP(p_worker_id);

4042: PJI_FM_SUM_PSI.PURGE_INCREMENTAL_BALANCES(p_worker_id);
4043: PJI_FM_SUM_PSI.PURGE_BALANCES_ACT(p_worker_id);
4044:
4045: PJI_PJP_SUM_ROLLUP.UNLOCK_ALL_HEADERS(p_worker_id);
4046: PJI_PJP_SUM_ROLLUP.CLEANUP(p_worker_id);
4047:
4048: -- if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4049: -- (l_process, 'FROM_PROJECT_ID') = -1 and
4050: -- PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER