DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT dependencies on PJI_PJP_SUM_DENORM

Line 340: PJI_PJP_SUM_DENORM.POPULATE_RBS_DENORM(l_worker_id, 'ALL', NULL);

336: -- 0. ... Remap txn accum headers with new rbs element ids.
337: --
338: IF (p_context = 'TRUNCATE') THEN
339: PJI_PJP_SUM_ROLLUP.REMAP_RBS_TXN_ACCUM_HDRS(l_worker_id);
340: PJI_PJP_SUM_DENORM.POPULATE_RBS_DENORM(l_worker_id, 'ALL', NULL);
341: PJI_PJP_SUM_ROLLUP.UPDATE_RBS_DENORM(l_worker_id);
342: END IF;
343:
344: --

Line 366: PJI_PJP_SUM_DENORM.POPULATE_XBS_DENORM(

362:
363: l_count := l_count + 1;
364: print_time('FPM Upgr b ' || l_count);
365:
366: PJI_PJP_SUM_DENORM.POPULATE_XBS_DENORM(
367: p_worker_id => l_worker_id
368: , p_denorm_type => 'ALL'
369: , p_wbs_version_id => NULL
370: , p_prg_group1 => NULL

Line 756: Pji_Pjp_Sum_Denorm.copy_xbs_denorm(

752: FOR i IN p_fp_src_version_ids.first..p_fp_src_version_ids.last LOOP
753:
754: print_time(' ----------- Begin denorm copy..' );
755:
756: Pji_Pjp_Sum_Denorm.copy_xbs_denorm(
757: p_worker_id => 1 ,
758: p_wbs_version_id_from => l_src_wbs_version_id_tbl(i),
759: p_wbs_version_id_to => l_tar_wbs_version_id_tbl(i),
760: p_copy_mode => p_copy_mode

Line 1520: Pji_Pjp_Sum_Denorm.populate_xbs_denorm(

1516: p_new_struct_version => j.wbs_struct_version_id );
1517:
1518: print_time(' row cnt after online context setting ' || SQL%ROWCOUNT );
1519:
1520: Pji_Pjp_Sum_Denorm.populate_xbs_denorm(
1521: p_worker_id => 1,
1522: p_denorm_type => 'WBS',
1523: p_wbs_version_id => j.wbs_struct_version_id,
1524: p_prg_group1 => NULL,

Line 1534: Pji_Pjp_Sum_Denorm.cleanup_xbs_denorm(

1530: Pji_Pjp_Sum_Rollup.update_xbs_denorm;
1531:
1532: print_time(' row cnt after updating xbs denorm ' || SQL%ROWCOUNT );
1533:
1534: Pji_Pjp_Sum_Denorm.cleanup_xbs_denorm(
1535: p_worker_id => 1
1536: , p_extraction_type => 'ONLINE');
1537:
1538: print_time(' row cnt after cleaning up xbs denorm ' || SQL%ROWCOUNT );

Line 1827: Pji_Pjp_Sum_Denorm.populate_xbs_denorm(

1823: g_event_rec.attribute3 := l_plan_version_id;
1824:
1825: PJI_FM_XBS_ACCUM_MAINT.CREATE_EVENT(g_event_rec);
1826:
1827: Pji_Pjp_Sum_Denorm.populate_xbs_denorm(
1828: p_worker_id => 1,
1829: p_denorm_type => 'WBS',
1830: p_wbs_version_id => l_wbs_version_id,
1831: p_prg_group1 => NULL,

Line 1874: Pji_Pjp_Sum_Denorm.cleanup_xbs_denorm(

1870:
1871: Pji_Pjp_Sum_Rollup.update_xbs_denorm;
1872: print_time(' Updated PJI xbs denorm. ');
1873:
1874: Pji_Pjp_Sum_Denorm.cleanup_xbs_denorm(
1875: p_worker_id => 1
1876: , p_extraction_type => 'ONLINE');
1877: print_time(' Cleaned up xbs delta denorm. ');
1878: