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.PJI_PJP_SUM_MAIN dependencies on PJI_PJP_SUM_ROLLUP

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

1325: -- pji_utils.write2log('Inserted records into pjp1'||sql%rowcount);
1326: -- for -3,-4 lines having prg_rollup_flag = 'N'
1327: -- pji_utils.write2log('Before rollup_fpr_wbs');
1328:
1329: --- pji_pjp_sum_rollup.rollup_fpr_wbs(null);
1330: for c in C_BOTTOM_UP loop
1331:
1332: l_level := c.SUP_LEVEL;
1333:

Line 3699: PJI_PJP_SUM_ROLLUP.POPULATE_TIME_DIMENSION(p_worker_id);

3695: (l_process, 'EXTRACTION_TYPE');
3696:
3697: PJI_PJP_EXTRACTION_UTILS.SEED_PJI_PJP_STATS(p_worker_id);
3698:
3699: PJI_PJP_SUM_ROLLUP.POPULATE_TIME_DIMENSION(p_worker_id);
3700:
3701: PJI_PJP_EXTRACTION_UTILS.POPULATE_ORG_EXTR_INFO;
3702:
3703: -- implicit commit

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

3710: FND_STATS.GATHER_INDEX_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
3711: indname => 'PJI_ORG_EXTR_INFO_N1',
3712: percent => 10);
3713:
3714: PJI_PJP_SUM_ROLLUP.SET_ONLINE_CONTEXT(null, null, null, null, null, null,
3715: null, null, null, null);
3716:
3717: PJI_PJP_SUM_ROLLUP.CREATE_EVENTS_SNAPSHOT(p_worker_id);
3718:

Line 3717: PJI_PJP_SUM_ROLLUP.CREATE_EVENTS_SNAPSHOT(p_worker_id);

3713:
3714: PJI_PJP_SUM_ROLLUP.SET_ONLINE_CONTEXT(null, null, null, null, null, null,
3715: null, null, null, null);
3716:
3717: PJI_PJP_SUM_ROLLUP.CREATE_EVENTS_SNAPSHOT(p_worker_id);
3718:
3719: PJI_PJP_SUM_ROLLUP.LOCK_HEADERS(p_worker_id);
3720:
3721: /* plan type code changes (4882640) This API call will be shifted to step entry */

Line 3719: PJI_PJP_SUM_ROLLUP.LOCK_HEADERS(p_worker_id);

3715: null, null, null, null);
3716:
3717: PJI_PJP_SUM_ROLLUP.CREATE_EVENTS_SNAPSHOT(p_worker_id);
3718:
3719: PJI_PJP_SUM_ROLLUP.LOCK_HEADERS(p_worker_id);
3720:
3721: /* plan type code changes (4882640) This API call will be shifted to step entry */
3722: if (PJI_UTILS.GET_PARAMETER('PJI_PTC_UPGRADE') = 'P') and l_extraction_type <> 'PARTIAL' then
3723: PLAN_TYPE_CODE_CHANGES (p_worker_id);

Line 3728: PJI_PJP_SUM_ROLLUP.PROCESS_RBS_CHANGES(p_worker_id);

3724: end if;
3725: /*---------- plan type code changes (4882640) ------------*/
3726:
3727:
3728: PJI_PJP_SUM_ROLLUP.PROCESS_RBS_CHANGES(p_worker_id);
3729:
3730: PJI_PJP_SUM_DENORM.POPULATE_XBS_DENORM(p_worker_id, 'ALL',
3731: null, null, null);
3732:

Line 3733: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM_FULL(p_worker_id);

3729:
3730: PJI_PJP_SUM_DENORM.POPULATE_XBS_DENORM(p_worker_id, 'ALL',
3731: null, null, null);
3732:
3733: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM_FULL(p_worker_id);
3734:
3735: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_WBS(p_worker_id);
3736: PJI_PJP_SUM_ROLLUP.PURGE_EVENT_DATA(p_worker_id);
3737: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_RBS(p_worker_id);

Line 3735: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_WBS(p_worker_id);

3731: null, null, null);
3732:
3733: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM_FULL(p_worker_id);
3734:
3735: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_WBS(p_worker_id);
3736: PJI_PJP_SUM_ROLLUP.PURGE_EVENT_DATA(p_worker_id);
3737: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_RBS(p_worker_id);
3738:
3739: PJI_PJP_SUM_ROLLUP.CREATE_MAPPING_RULES(p_worker_id);

Line 3736: PJI_PJP_SUM_ROLLUP.PURGE_EVENT_DATA(p_worker_id);

3732:
3733: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM_FULL(p_worker_id);
3734:
3735: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_WBS(p_worker_id);
3736: PJI_PJP_SUM_ROLLUP.PURGE_EVENT_DATA(p_worker_id);
3737: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_RBS(p_worker_id);
3738:
3739: PJI_PJP_SUM_ROLLUP.CREATE_MAPPING_RULES(p_worker_id);
3740: PJI_PJP_SUM_ROLLUP.MAP_RBS_HEADERS(p_worker_id);

Line 3737: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_RBS(p_worker_id);

3733: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM_FULL(p_worker_id);
3734:
3735: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_WBS(p_worker_id);
3736: PJI_PJP_SUM_ROLLUP.PURGE_EVENT_DATA(p_worker_id);
3737: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_RBS(p_worker_id);
3738:
3739: PJI_PJP_SUM_ROLLUP.CREATE_MAPPING_RULES(p_worker_id);
3740: PJI_PJP_SUM_ROLLUP.MAP_RBS_HEADERS(p_worker_id);
3741:

Line 3739: PJI_PJP_SUM_ROLLUP.CREATE_MAPPING_RULES(p_worker_id);

3735: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_WBS(p_worker_id);
3736: PJI_PJP_SUM_ROLLUP.PURGE_EVENT_DATA(p_worker_id);
3737: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_RBS(p_worker_id);
3738:
3739: PJI_PJP_SUM_ROLLUP.CREATE_MAPPING_RULES(p_worker_id);
3740: PJI_PJP_SUM_ROLLUP.MAP_RBS_HEADERS(p_worker_id);
3741:
3742: PJI_PJP_SUM_DENORM.POPULATE_RBS_DENORM(p_worker_id, 'ALL', null);
3743:

Line 3740: PJI_PJP_SUM_ROLLUP.MAP_RBS_HEADERS(p_worker_id);

3736: PJI_PJP_SUM_ROLLUP.PURGE_EVENT_DATA(p_worker_id);
3737: PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_RBS(p_worker_id);
3738:
3739: PJI_PJP_SUM_ROLLUP.CREATE_MAPPING_RULES(p_worker_id);
3740: PJI_PJP_SUM_ROLLUP.MAP_RBS_HEADERS(p_worker_id);
3741:
3742: PJI_PJP_SUM_DENORM.POPULATE_RBS_DENORM(p_worker_id, 'ALL', null);
3743:
3744: PJI_PJP_SUM_ROLLUP.POPULATE_XBS_DENORM_DELTA(p_worker_id);

Line 3744: PJI_PJP_SUM_ROLLUP.POPULATE_XBS_DENORM_DELTA(p_worker_id);

3740: PJI_PJP_SUM_ROLLUP.MAP_RBS_HEADERS(p_worker_id);
3741:
3742: PJI_PJP_SUM_DENORM.POPULATE_RBS_DENORM(p_worker_id, 'ALL', null);
3743:
3744: PJI_PJP_SUM_ROLLUP.POPULATE_XBS_DENORM_DELTA(p_worker_id);
3745: PJI_PJP_SUM_ROLLUP.POPULATE_RBS_DENORM_DELTA(p_worker_id);
3746:
3747: PJI_FM_SUM_PSI.BALANCES_ROWID_TABLE(p_worker_id);
3748: PJI_FM_SUM_PSI.ACT_ROWID_TABLE(p_worker_id);

Line 3745: PJI_PJP_SUM_ROLLUP.POPULATE_RBS_DENORM_DELTA(p_worker_id);

3741:
3742: PJI_PJP_SUM_DENORM.POPULATE_RBS_DENORM(p_worker_id, 'ALL', null);
3743:
3744: PJI_PJP_SUM_ROLLUP.POPULATE_XBS_DENORM_DELTA(p_worker_id);
3745: PJI_PJP_SUM_ROLLUP.POPULATE_RBS_DENORM_DELTA(p_worker_id);
3746:
3747: PJI_FM_SUM_PSI.BALANCES_ROWID_TABLE(p_worker_id);
3748: PJI_FM_SUM_PSI.ACT_ROWID_TABLE(p_worker_id);
3749:

Line 3750: PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_SLICES(p_worker_id);

3746:
3747: PJI_FM_SUM_PSI.BALANCES_ROWID_TABLE(p_worker_id);
3748: PJI_FM_SUM_PSI.ACT_ROWID_TABLE(p_worker_id);
3749:
3750: PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_SLICES(p_worker_id);
3751: PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_SLICES(p_worker_id);
3752:
3753: PJI_PJP_SUM_ROLLUP.MARK_EXTRACTED_PROJECTS(p_worker_id);
3754:

Line 3751: PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_SLICES(p_worker_id);

3747: PJI_FM_SUM_PSI.BALANCES_ROWID_TABLE(p_worker_id);
3748: PJI_FM_SUM_PSI.ACT_ROWID_TABLE(p_worker_id);
3749:
3750: PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_SLICES(p_worker_id);
3751: PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_SLICES(p_worker_id);
3752:
3753: PJI_PJP_SUM_ROLLUP.MARK_EXTRACTED_PROJECTS(p_worker_id);
3754:
3755: PJI_PJP_SUM_CUST.PJP_CUSTOM_FPR_API(p_worker_id);

Line 3753: PJI_PJP_SUM_ROLLUP.MARK_EXTRACTED_PROJECTS(p_worker_id);

3749:
3750: PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_SLICES(p_worker_id);
3751: PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_SLICES(p_worker_id);
3752:
3753: PJI_PJP_SUM_ROLLUP.MARK_EXTRACTED_PROJECTS(p_worker_id);
3754:
3755: PJI_PJP_SUM_CUST.PJP_CUSTOM_FPR_API(p_worker_id);
3756: PJI_PJP_SUM_CUST.PJP_CUSTOM_ACR_API(p_worker_id);
3757:

Line 3758: PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_CUST_SLICES(p_worker_id);

3754:
3755: PJI_PJP_SUM_CUST.PJP_CUSTOM_FPR_API(p_worker_id);
3756: PJI_PJP_SUM_CUST.PJP_CUSTOM_ACR_API(p_worker_id);
3757:
3758: PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_CUST_SLICES(p_worker_id);
3759: PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_CUST_SLICES(p_worker_id);
3760:
3761: PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS(p_worker_id);
3762: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_PR(p_worker_id);

Line 3759: PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_CUST_SLICES(p_worker_id);

3755: PJI_PJP_SUM_CUST.PJP_CUSTOM_FPR_API(p_worker_id);
3756: PJI_PJP_SUM_CUST.PJP_CUSTOM_ACR_API(p_worker_id);
3757:
3758: PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_CUST_SLICES(p_worker_id);
3759: PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_CUST_SLICES(p_worker_id);
3760:
3761: PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS(p_worker_id);
3762: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_PR(p_worker_id);
3763: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_RBS(p_worker_id);

Line 3761: PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS(p_worker_id);

3757:
3758: PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_CUST_SLICES(p_worker_id);
3759: PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_CUST_SLICES(p_worker_id);
3760:
3761: PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS(p_worker_id);
3762: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_PR(p_worker_id);
3763: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_RBS(p_worker_id);
3764: PJI_PJP_SUM_ROLLUP.PULL_DANGLING_PLANS(p_worker_id);
3765: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_PLAN_UPDATES(p_worker_id);

Line 3762: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_PR(p_worker_id);

3758: PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_CUST_SLICES(p_worker_id);
3759: PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_CUST_SLICES(p_worker_id);
3760:
3761: PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS(p_worker_id);
3762: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_PR(p_worker_id);
3763: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_RBS(p_worker_id);
3764: PJI_PJP_SUM_ROLLUP.PULL_DANGLING_PLANS(p_worker_id);
3765: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_PLAN_UPDATES(p_worker_id);
3766:

Line 3763: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_RBS(p_worker_id);

3759: PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_CUST_SLICES(p_worker_id);
3760:
3761: PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS(p_worker_id);
3762: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_PR(p_worker_id);
3763: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_RBS(p_worker_id);
3764: PJI_PJP_SUM_ROLLUP.PULL_DANGLING_PLANS(p_worker_id);
3765: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_PLAN_UPDATES(p_worker_id);
3766:
3767: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_ALL(p_worker_id);

Line 3764: PJI_PJP_SUM_ROLLUP.PULL_DANGLING_PLANS(p_worker_id);

3760:
3761: PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS(p_worker_id);
3762: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_PR(p_worker_id);
3763: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_RBS(p_worker_id);
3764: PJI_PJP_SUM_ROLLUP.PULL_DANGLING_PLANS(p_worker_id);
3765: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_PLAN_UPDATES(p_worker_id);
3766:
3767: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_ALL(p_worker_id);
3768: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_ALL(p_worker_id);

Line 3765: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_PLAN_UPDATES(p_worker_id);

3761: PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS(p_worker_id);
3762: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_PR(p_worker_id);
3763: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_RBS(p_worker_id);
3764: PJI_PJP_SUM_ROLLUP.PULL_DANGLING_PLANS(p_worker_id);
3765: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_PLAN_UPDATES(p_worker_id);
3766:
3767: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_ALL(p_worker_id);
3768: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_ALL(p_worker_id);
3769:

Line 3767: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_ALL(p_worker_id);

3763: PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_RBS(p_worker_id);
3764: PJI_PJP_SUM_ROLLUP.PULL_DANGLING_PLANS(p_worker_id);
3765: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_PLAN_UPDATES(p_worker_id);
3766:
3767: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_ALL(p_worker_id);
3768: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_ALL(p_worker_id);
3769:
3770: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_NONTP(p_worker_id);
3771: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_PA(p_worker_id);

Line 3768: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_ALL(p_worker_id);

3764: PJI_PJP_SUM_ROLLUP.PULL_DANGLING_PLANS(p_worker_id);
3765: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_PLAN_UPDATES(p_worker_id);
3766:
3767: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_ALL(p_worker_id);
3768: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_ALL(p_worker_id);
3769:
3770: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_NONTP(p_worker_id);
3771: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_PA(p_worker_id);
3772: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_GL(p_worker_id);

Line 3770: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_NONTP(p_worker_id);

3766:
3767: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_ALL(p_worker_id);
3768: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_ALL(p_worker_id);
3769:
3770: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_NONTP(p_worker_id);
3771: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_PA(p_worker_id);
3772: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_GL(p_worker_id);
3773: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_EN(p_worker_id);
3774: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_PA(p_worker_id);

Line 3771: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_PA(p_worker_id);

3767: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_ALL(p_worker_id);
3768: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_ALL(p_worker_id);
3769:
3770: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_NONTP(p_worker_id);
3771: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_PA(p_worker_id);
3772: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_GL(p_worker_id);
3773: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_EN(p_worker_id);
3774: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_PA(p_worker_id);
3775: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_GL(p_worker_id);

Line 3772: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_GL(p_worker_id);

3768: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_ALL(p_worker_id);
3769:
3770: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_NONTP(p_worker_id);
3771: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_PA(p_worker_id);
3772: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_GL(p_worker_id);
3773: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_EN(p_worker_id);
3774: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_PA(p_worker_id);
3775: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_GL(p_worker_id);
3776: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_EN(p_worker_id);

Line 3773: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_EN(p_worker_id);

3769:
3770: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_NONTP(p_worker_id);
3771: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_PA(p_worker_id);
3772: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_GL(p_worker_id);
3773: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_EN(p_worker_id);
3774: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_PA(p_worker_id);
3775: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_GL(p_worker_id);
3776: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_EN(p_worker_id);
3777:

Line 3774: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_PA(p_worker_id);

3770: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_NONTP(p_worker_id);
3771: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_PA(p_worker_id);
3772: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_GL(p_worker_id);
3773: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_EN(p_worker_id);
3774: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_PA(p_worker_id);
3775: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_GL(p_worker_id);
3776: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_EN(p_worker_id);
3777:
3778: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_TOP(p_worker_id);

Line 3775: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_GL(p_worker_id);

3771: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_PA(p_worker_id);
3772: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_GL(p_worker_id);
3773: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_EN(p_worker_id);
3774: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_PA(p_worker_id);
3775: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_GL(p_worker_id);
3776: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_EN(p_worker_id);
3777:
3778: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_TOP(p_worker_id);
3779: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);

Line 3776: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_EN(p_worker_id);

3772: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_GL(p_worker_id);
3773: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_EN(p_worker_id);
3774: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_PA(p_worker_id);
3775: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_GL(p_worker_id);
3776: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_EN(p_worker_id);
3777:
3778: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_TOP(p_worker_id);
3779: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);
3780: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_WBS(p_worker_id);

Line 3778: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_TOP(p_worker_id);

3774: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_PA(p_worker_id);
3775: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_GL(p_worker_id);
3776: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_EN(p_worker_id);
3777:
3778: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_TOP(p_worker_id);
3779: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);
3780: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_WBS(p_worker_id);
3781:
3782: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_PRG(p_worker_id);

Line 3779: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);

3775: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_GL(p_worker_id);
3776: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_EN(p_worker_id);
3777:
3778: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_TOP(p_worker_id);
3779: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);
3780: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_WBS(p_worker_id);
3781:
3782: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_PRG(p_worker_id);
3783: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_PRG(p_worker_id);

Line 3780: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_WBS(p_worker_id);

3776: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_EN(p_worker_id);
3777:
3778: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_TOP(p_worker_id);
3779: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);
3780: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_WBS(p_worker_id);
3781:
3782: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_PRG(p_worker_id);
3783: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_PRG(p_worker_id);
3784:

Line 3782: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_PRG(p_worker_id);

3778: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_TOP(p_worker_id);
3779: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);
3780: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_WBS(p_worker_id);
3781:
3782: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_PRG(p_worker_id);
3783: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_PRG(p_worker_id);
3784:
3785: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES(p_worker_id);
3786:

Line 3783: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_PRG(p_worker_id);

3779: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);
3780: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_WBS(p_worker_id);
3781:
3782: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_PRG(p_worker_id);
3783: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_PRG(p_worker_id);
3784:
3785: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES(p_worker_id);
3786:
3787: PJI_PJP_SUM_ROLLUP.AGGREGATE_PLAN_DATA(p_worker_id);

Line 3785: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES(p_worker_id);

3781:
3782: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_PRG(p_worker_id);
3783: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_PRG(p_worker_id);
3784:
3785: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES(p_worker_id);
3786:
3787: PJI_PJP_SUM_ROLLUP.AGGREGATE_PLAN_DATA(p_worker_id);
3788: PJI_PJP_SUM_ROLLUP.PURGE_PLAN_DATA(p_worker_id);
3789:

Line 3787: PJI_PJP_SUM_ROLLUP.AGGREGATE_PLAN_DATA(p_worker_id);

3783: PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_PRG(p_worker_id);
3784:
3785: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES(p_worker_id);
3786:
3787: PJI_PJP_SUM_ROLLUP.AGGREGATE_PLAN_DATA(p_worker_id);
3788: PJI_PJP_SUM_ROLLUP.PURGE_PLAN_DATA(p_worker_id);
3789:
3790: PJI_PJP_SUM_ROLLUP.UPDATE_WBS_HDR(p_worker_id);
3791:

Line 3788: PJI_PJP_SUM_ROLLUP.PURGE_PLAN_DATA(p_worker_id);

3784:
3785: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES(p_worker_id);
3786:
3787: PJI_PJP_SUM_ROLLUP.AGGREGATE_PLAN_DATA(p_worker_id);
3788: PJI_PJP_SUM_ROLLUP.PURGE_PLAN_DATA(p_worker_id);
3789:
3790: PJI_PJP_SUM_ROLLUP.UPDATE_WBS_HDR(p_worker_id);
3791:
3792: /* Bug 6063826. Commented and used MERGE

Line 3790: PJI_PJP_SUM_ROLLUP.UPDATE_WBS_HDR(p_worker_id);

3786:
3787: PJI_PJP_SUM_ROLLUP.AGGREGATE_PLAN_DATA(p_worker_id);
3788: PJI_PJP_SUM_ROLLUP.PURGE_PLAN_DATA(p_worker_id);
3789:
3790: PJI_PJP_SUM_ROLLUP.UPDATE_WBS_HDR(p_worker_id);
3791:
3792: /* Bug 6063826. Commented and used MERGE
3793: PJI_PJP_SUM_ROLLUP.GET_FPR_ROWIDS(p_worker_id);
3794: PJI_PJP_SUM_ROLLUP.UPDATE_FPR_ROWS(p_worker_id);

Line 3793: PJI_PJP_SUM_ROLLUP.GET_FPR_ROWIDS(p_worker_id);

3789:
3790: PJI_PJP_SUM_ROLLUP.UPDATE_WBS_HDR(p_worker_id);
3791:
3792: /* Bug 6063826. Commented and used MERGE
3793: PJI_PJP_SUM_ROLLUP.GET_FPR_ROWIDS(p_worker_id);
3794: PJI_PJP_SUM_ROLLUP.UPDATE_FPR_ROWS(p_worker_id);
3795: PJI_PJP_SUM_ROLLUP.INSERT_FPR_ROWS(p_worker_id);
3796: PJI_PJP_SUM_ROLLUP.CLEANUP_FPR_ROWID_TABLE(p_worker_id);
3797: */

Line 3794: PJI_PJP_SUM_ROLLUP.UPDATE_FPR_ROWS(p_worker_id);

3790: PJI_PJP_SUM_ROLLUP.UPDATE_WBS_HDR(p_worker_id);
3791:
3792: /* Bug 6063826. Commented and used MERGE
3793: PJI_PJP_SUM_ROLLUP.GET_FPR_ROWIDS(p_worker_id);
3794: PJI_PJP_SUM_ROLLUP.UPDATE_FPR_ROWS(p_worker_id);
3795: PJI_PJP_SUM_ROLLUP.INSERT_FPR_ROWS(p_worker_id);
3796: PJI_PJP_SUM_ROLLUP.CLEANUP_FPR_ROWID_TABLE(p_worker_id);
3797: */
3798: PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACTS(p_worker_id);

Line 3795: PJI_PJP_SUM_ROLLUP.INSERT_FPR_ROWS(p_worker_id);

3791:
3792: /* Bug 6063826. Commented and used MERGE
3793: PJI_PJP_SUM_ROLLUP.GET_FPR_ROWIDS(p_worker_id);
3794: PJI_PJP_SUM_ROLLUP.UPDATE_FPR_ROWS(p_worker_id);
3795: PJI_PJP_SUM_ROLLUP.INSERT_FPR_ROWS(p_worker_id);
3796: PJI_PJP_SUM_ROLLUP.CLEANUP_FPR_ROWID_TABLE(p_worker_id);
3797: */
3798: PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACTS(p_worker_id);
3799: PJI_PJP_SUM_ROLLUP.GET_ACR_ROWIDS(p_worker_id);

Line 3796: PJI_PJP_SUM_ROLLUP.CLEANUP_FPR_ROWID_TABLE(p_worker_id);

3792: /* Bug 6063826. Commented and used MERGE
3793: PJI_PJP_SUM_ROLLUP.GET_FPR_ROWIDS(p_worker_id);
3794: PJI_PJP_SUM_ROLLUP.UPDATE_FPR_ROWS(p_worker_id);
3795: PJI_PJP_SUM_ROLLUP.INSERT_FPR_ROWS(p_worker_id);
3796: PJI_PJP_SUM_ROLLUP.CLEANUP_FPR_ROWID_TABLE(p_worker_id);
3797: */
3798: PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACTS(p_worker_id);
3799: PJI_PJP_SUM_ROLLUP.GET_ACR_ROWIDS(p_worker_id);
3800: PJI_PJP_SUM_ROLLUP.UPDATE_ACR_ROWS(p_worker_id);

Line 3798: PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACTS(p_worker_id);

3794: PJI_PJP_SUM_ROLLUP.UPDATE_FPR_ROWS(p_worker_id);
3795: PJI_PJP_SUM_ROLLUP.INSERT_FPR_ROWS(p_worker_id);
3796: PJI_PJP_SUM_ROLLUP.CLEANUP_FPR_ROWID_TABLE(p_worker_id);
3797: */
3798: PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACTS(p_worker_id);
3799: PJI_PJP_SUM_ROLLUP.GET_ACR_ROWIDS(p_worker_id);
3800: PJI_PJP_SUM_ROLLUP.UPDATE_ACR_ROWS(p_worker_id);
3801: PJI_PJP_SUM_ROLLUP.INSERT_ACR_ROWS(p_worker_id);
3802: PJI_PJP_SUM_ROLLUP.CLEANUP_ACR_ROWID_TABLE(p_worker_id);

Line 3799: PJI_PJP_SUM_ROLLUP.GET_ACR_ROWIDS(p_worker_id);

3795: PJI_PJP_SUM_ROLLUP.INSERT_FPR_ROWS(p_worker_id);
3796: PJI_PJP_SUM_ROLLUP.CLEANUP_FPR_ROWID_TABLE(p_worker_id);
3797: */
3798: PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACTS(p_worker_id);
3799: PJI_PJP_SUM_ROLLUP.GET_ACR_ROWIDS(p_worker_id);
3800: PJI_PJP_SUM_ROLLUP.UPDATE_ACR_ROWS(p_worker_id);
3801: PJI_PJP_SUM_ROLLUP.INSERT_ACR_ROWS(p_worker_id);
3802: PJI_PJP_SUM_ROLLUP.CLEANUP_ACR_ROWID_TABLE(p_worker_id);
3803:

Line 3800: PJI_PJP_SUM_ROLLUP.UPDATE_ACR_ROWS(p_worker_id);

3796: PJI_PJP_SUM_ROLLUP.CLEANUP_FPR_ROWID_TABLE(p_worker_id);
3797: */
3798: PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACTS(p_worker_id);
3799: PJI_PJP_SUM_ROLLUP.GET_ACR_ROWIDS(p_worker_id);
3800: PJI_PJP_SUM_ROLLUP.UPDATE_ACR_ROWS(p_worker_id);
3801: PJI_PJP_SUM_ROLLUP.INSERT_ACR_ROWS(p_worker_id);
3802: PJI_PJP_SUM_ROLLUP.CLEANUP_ACR_ROWID_TABLE(p_worker_id);
3803:
3804: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM(p_worker_id);

Line 3801: PJI_PJP_SUM_ROLLUP.INSERT_ACR_ROWS(p_worker_id);

3797: */
3798: PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACTS(p_worker_id);
3799: PJI_PJP_SUM_ROLLUP.GET_ACR_ROWIDS(p_worker_id);
3800: PJI_PJP_SUM_ROLLUP.UPDATE_ACR_ROWS(p_worker_id);
3801: PJI_PJP_SUM_ROLLUP.INSERT_ACR_ROWS(p_worker_id);
3802: PJI_PJP_SUM_ROLLUP.CLEANUP_ACR_ROWID_TABLE(p_worker_id);
3803:
3804: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM(p_worker_id);
3805: PJI_PJP_SUM_ROLLUP.UPDATE_RBS_DENORM(p_worker_id);

Line 3802: PJI_PJP_SUM_ROLLUP.CLEANUP_ACR_ROWID_TABLE(p_worker_id);

3798: PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACTS(p_worker_id);
3799: PJI_PJP_SUM_ROLLUP.GET_ACR_ROWIDS(p_worker_id);
3800: PJI_PJP_SUM_ROLLUP.UPDATE_ACR_ROWS(p_worker_id);
3801: PJI_PJP_SUM_ROLLUP.INSERT_ACR_ROWS(p_worker_id);
3802: PJI_PJP_SUM_ROLLUP.CLEANUP_ACR_ROWID_TABLE(p_worker_id);
3803:
3804: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM(p_worker_id);
3805: PJI_PJP_SUM_ROLLUP.UPDATE_RBS_DENORM(p_worker_id);
3806:

Line 3804: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM(p_worker_id);

3800: PJI_PJP_SUM_ROLLUP.UPDATE_ACR_ROWS(p_worker_id);
3801: PJI_PJP_SUM_ROLLUP.INSERT_ACR_ROWS(p_worker_id);
3802: PJI_PJP_SUM_ROLLUP.CLEANUP_ACR_ROWID_TABLE(p_worker_id);
3803:
3804: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM(p_worker_id);
3805: PJI_PJP_SUM_ROLLUP.UPDATE_RBS_DENORM(p_worker_id);
3806:
3807: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_EVENTS(p_worker_id);
3808: PJI_PJP_SUM_ROLLUP.GET_TASK_ROLLUP_ACTUALS(p_worker_id);

Line 3805: PJI_PJP_SUM_ROLLUP.UPDATE_RBS_DENORM(p_worker_id);

3801: PJI_PJP_SUM_ROLLUP.INSERT_ACR_ROWS(p_worker_id);
3802: PJI_PJP_SUM_ROLLUP.CLEANUP_ACR_ROWID_TABLE(p_worker_id);
3803:
3804: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM(p_worker_id);
3805: PJI_PJP_SUM_ROLLUP.UPDATE_RBS_DENORM(p_worker_id);
3806:
3807: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_EVENTS(p_worker_id);
3808: PJI_PJP_SUM_ROLLUP.GET_TASK_ROLLUP_ACTUALS(p_worker_id);
3809:

Line 3807: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_EVENTS(p_worker_id);

3803:
3804: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM(p_worker_id);
3805: PJI_PJP_SUM_ROLLUP.UPDATE_RBS_DENORM(p_worker_id);
3806:
3807: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_EVENTS(p_worker_id);
3808: PJI_PJP_SUM_ROLLUP.GET_TASK_ROLLUP_ACTUALS(p_worker_id);
3809:
3810: PJI_FM_SUM_PSI.BALANCES_UPDATE_DELTA(p_worker_id);
3811: PJI_FM_SUM_PSI.BALANCES_INSERT_DELTA(p_worker_id);

Line 3808: PJI_PJP_SUM_ROLLUP.GET_TASK_ROLLUP_ACTUALS(p_worker_id);

3804: PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM(p_worker_id);
3805: PJI_PJP_SUM_ROLLUP.UPDATE_RBS_DENORM(p_worker_id);
3806:
3807: PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_EVENTS(p_worker_id);
3808: PJI_PJP_SUM_ROLLUP.GET_TASK_ROLLUP_ACTUALS(p_worker_id);
3809:
3810: PJI_FM_SUM_PSI.BALANCES_UPDATE_DELTA(p_worker_id);
3811: PJI_FM_SUM_PSI.BALANCES_INSERT_DELTA(p_worker_id);
3812: PJI_FM_SUM_PSI.PURGE_BALANCES_CMT(p_worker_id);

Line 3817: PJI_PJP_SUM_ROLLUP.UNLOCK_ALL_HEADERS(p_worker_id);

3813: PJI_FM_SUM_PSI.BALANCES_INSERT_DELTA_CMT(p_worker_id);
3814: PJI_FM_SUM_PSI.PURGE_INCREMENTAL_BALANCES(p_worker_id);
3815: PJI_FM_SUM_PSI.PURGE_BALANCES_ACT(p_worker_id);
3816:
3817: PJI_PJP_SUM_ROLLUP.UNLOCK_ALL_HEADERS(p_worker_id);
3818: PJI_PJP_SUM_ROLLUP.CLEANUP(p_worker_id);
3819:
3820: -- if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3821: -- (l_process, 'FROM_PROJECT_ID') = -1 and

Line 3818: PJI_PJP_SUM_ROLLUP.CLEANUP(p_worker_id);

3814: PJI_FM_SUM_PSI.PURGE_INCREMENTAL_BALANCES(p_worker_id);
3815: PJI_FM_SUM_PSI.PURGE_BALANCES_ACT(p_worker_id);
3816:
3817: PJI_PJP_SUM_ROLLUP.UNLOCK_ALL_HEADERS(p_worker_id);
3818: PJI_PJP_SUM_ROLLUP.CLEANUP(p_worker_id);
3819:
3820: -- if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3821: -- (l_process, 'FROM_PROJECT_ID') = -1 and
3822: -- PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER