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_FM_XBS_ACCUM_MAINT dependencies on PJI_FM_PLAN_MAINT_T_PVT

Line 735: --Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_FP_FACT;

731:
732: l_plan_version_id_tbl.DELETE;
733:
734: --PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES;
735: --Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_FP_FACT;
736:
737: CLEANUP_TEMP_TABLES;
738: --maintain_smart_slice does not clean data populated by itself
739:

Line 1237: Pji_Fm_Plan_Maint_T_Pvt.COPY_PRIMARY

1233: l_d_fp_version_ids := SYSTEM.pa_num_tbl_type (p_dest_fp_version_ids(i) );
1234:
1235: print_time ( ' plan copy api .. 008 ' );
1236:
1237: Pji_Fm_Plan_Maint_T_Pvt.COPY_PRIMARY
1238: (
1239: p_source_fp_version_ids => l_s_fp_version_ids
1240: , p_dest_fp_version_ids => l_d_fp_version_ids
1241: , p_commit => 'F'

Line 1323: Pji_Fm_Plan_Maint_T_Pvt.COPY_PRIMARY

1319: END IF;
1320:
1321: print_time ( ' plan copy PVT api .. 005 ' );
1322:
1323: Pji_Fm_Plan_Maint_T_Pvt.COPY_PRIMARY
1324: (
1325: p_source_fp_version_ids => l_s_fp_version_ids
1326: , p_dest_fp_version_ids => l_d_fp_version_ids
1327: , p_commit => 'F'

Line 1901: Pji_Fm_Plan_Maint_T_Pvt.CLEANUP_INTERIM_TABLES; -- Clean up interim tables.

1897: p_new_original_version => l_new_orig_ver_id,
1898: p_old_struct_version => NULL,
1899: p_new_struct_version => NULL);
1900:
1901: Pji_Fm_Plan_Maint_T_Pvt.CLEANUP_INTERIM_TABLES; -- Clean up interim tables.
1902: print_time(' Mark original private: Cleaned up interim tables. ');
1903:
1904: -- Populated ver3 just to get the level info in rollup_fpr_wbs Bug 5528058
1905: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(l_fp_version_ids, 'PRI');

Line 1905: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(l_fp_version_ids, 'PRI');

1901: Pji_Fm_Plan_Maint_T_Pvt.CLEANUP_INTERIM_TABLES; -- Clean up interim tables.
1902: print_time(' Mark original private: Cleaned up interim tables. ');
1903:
1904: -- Populated ver3 just to get the level info in rollup_fpr_wbs Bug 5528058
1905: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(l_fp_version_ids, 'PRI');
1906: -- PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(l_fp_version_ids, 'SECRBS');
1907: print_time(' Populated ver3. ');
1908:
1909: PJI_FM_PLAN_MAINT_T_PVT.CREATE_WBSRLP;

Line 1906: -- PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(l_fp_version_ids, 'SECRBS');

1902: print_time(' Mark original private: Cleaned up interim tables. ');
1903:
1904: -- Populated ver3 just to get the level info in rollup_fpr_wbs Bug 5528058
1905: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(l_fp_version_ids, 'PRI');
1906: -- PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(l_fp_version_ids, 'SECRBS');
1907: print_time(' Populated ver3. ');
1908:
1909: PJI_FM_PLAN_MAINT_T_PVT.CREATE_WBSRLP;
1910: print_time(' Mark original private: Created WBS rollups. ');

Line 1909: PJI_FM_PLAN_MAINT_T_PVT.CREATE_WBSRLP;

1905: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(l_fp_version_ids, 'PRI');
1906: -- PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(l_fp_version_ids, 'SECRBS');
1907: print_time(' Populated ver3. ');
1908:
1909: PJI_FM_PLAN_MAINT_T_PVT.CREATE_WBSRLP;
1910: print_time(' Mark original private: Created WBS rollups. ');
1911:
1912: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES;
1913:

Line 1914: PJI_FM_PLAN_MAINT_T_PVT.UPDATE_WBS_HDR;

1910: print_time(' Mark original private: Created WBS rollups. ');
1911:
1912: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES;
1913:
1914: PJI_FM_PLAN_MAINT_T_PVT.UPDATE_WBS_HDR;
1915: print_time('Updated the WBS header table with min max txn dates.');
1916:
1917: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT;
1918: print_time(' Mark original private: Merged into fact. ');

Line 1917: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT;

1913:
1914: PJI_FM_PLAN_MAINT_T_PVT.UPDATE_WBS_HDR;
1915: print_time('Updated the WBS header table with min max txn dates.');
1916:
1917: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT;
1918: print_time(' Mark original private: Merged into fact. ');
1919:
1920:
1921: ------------------------------------------

Line 1932: Pji_Fm_Plan_Maint_T_Pvt.CLEANUP_INTERIM_TABLES;

1928: p_event_ids => l_event_ids
1929: , x_return_status => l_return_status
1930: , x_msg_code => l_msg_code );
1931:
1932: Pji_Fm_Plan_Maint_T_Pvt.CLEANUP_INTERIM_TABLES;
1933: print_time(' Mark original private: Cleaned up interim tables. ');
1934:
1935: EXCEPTION
1936: WHEN OTHERS THEN

Line 2782: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES;

2778: l_baseline_fp_ver_id.EXTEND;
2779: l_baseline_fp_ver_id(l_baseline_fp_ver_id.COUNT) := l_fp_version_ids(l_count);
2780:
2781:
2782: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES;
2783: print_time(' Cleaned up ver3_t table. ');
2784:
2785:
2786: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(l_baseline_fp_ver_id, 'PRI');

Line 2786: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(l_baseline_fp_ver_id, 'PRI');

2782: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES;
2783: print_time(' Cleaned up ver3_t table. ');
2784:
2785:
2786: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(l_baseline_fp_ver_id, 'PRI');
2787: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(l_baseline_fp_ver_id, 'SECRBS');
2788: print_time(' Populated ver3. ');
2789:
2790:

Line 2787: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(l_baseline_fp_ver_id, 'SECRBS');

2783: print_time(' Cleaned up ver3_t table. ');
2784:
2785:
2786: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(l_baseline_fp_ver_id, 'PRI');
2787: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(l_baseline_fp_ver_id, 'SECRBS');
2788: print_time(' Populated ver3. ');
2789:
2790:
2791: INSERT INTO PJI_FM_EXTR_PLNVER3_T ver3

Line 2849: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_RBS_HDR;

2845: WHERE plan_version_id > 0;
2846: print_time(' Need only -3, -4 records, deleted other plan version. ');
2847:
2848:
2849: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_RBS_HDR;
2850: print_time ( ' Inserted -3, -4 RBS headers inserted. ' );
2851:
2852: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_WBS_HDR;
2853: print_time ( ' Inserted -3, -4 WBS headers inserted. ' );

Line 2852: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_WBS_HDR;

2848:
2849: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_RBS_HDR;
2850: print_time ( ' Inserted -3, -4 RBS headers inserted. ' );
2851:
2852: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_WBS_HDR;
2853: print_time ( ' Inserted -3, -4 WBS headers inserted. ' );
2854:
2855:
2856: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES;

Line 2856: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES;

2852: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_WBS_HDR;
2853: print_time ( ' Inserted -3, -4 WBS headers inserted. ' );
2854:
2855:
2856: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES;
2857: print_time ( ' Cleaned up ver3. ' );
2858:
2859:
2860: SELECT COUNT(1)

Line 4030: Pji_Fm_Plan_Maint_T_Pvt.EXTRACT_FIN_PLAN_VERSIONS(

4026: --RETURN;
4027: NULL;
4028: ELSE
4029:
4030: Pji_Fm_Plan_Maint_T_Pvt.EXTRACT_FIN_PLAN_VERSIONS(
4031: p_fp_version_ids => l_plan_version_id_tbl
4032: , p_slice_type => 'PRI'
4033: );
4034:

Line 4079: Pji_Utils.write2log(' WBS_MAINT_PVT: Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_FP_FACT',null,3);

4075: p_worker_id => 1
4076: ,p_extraction_type => 'ONLINE');
4077:
4078: IF g_debug_mode='Y' THEN
4079: Pji_Utils.write2log(' WBS_MAINT_PVT: Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_FP_FACT',null,3);
4080: end if;
4081: Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_FP_FACT;
4082:
4083:

Line 4081: Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_FP_FACT;

4077:
4078: IF g_debug_mode='Y' THEN
4079: Pji_Utils.write2log(' WBS_MAINT_PVT: Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_FP_FACT',null,3);
4080: end if;
4081: Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_FP_FACT;
4082:
4083:
4084: Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_AC_FACT;
4085:

Line 4084: Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_AC_FACT;

4080: end if;
4081: Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_FP_FACT;
4082:
4083:
4084: Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_AC_FACT;
4085:
4086:
4087:
4088: END IF;

Line 5697: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(

5693: END;
5694:
5695: CLEANUP_TEMP_TABLES;
5696:
5697: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(
5698: p_fp_version_ids => l_plan_version_id_tbl
5699: , p_slice_type => 'PRI'
5700: );
5701: IF g_debug_mode='Y' THEN

Line 5702: Pji_Utils.write2log(' maintain smart slice44.02:PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS' ,null,3);

5698: p_fp_version_ids => l_plan_version_id_tbl
5699: , p_slice_type => 'PRI'
5700: );
5701: IF g_debug_mode='Y' THEN
5702: Pji_Utils.write2log(' maintain smart slice44.02:PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS' ,null,3);
5703: end if;
5704:
5705: IF g_debug_mode='Y' THEN
5706: Pji_Utils.write2log(' maintain smart slice55:l_plan_version_id_tbl.COUNT: '||l_plan_version_id_tbl.COUNT||

Line 6457: Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_FP_FACT;

6453: IF g_debug_mode='Y' THEN
6454: Pji_Utils.write2log(' Inserted RBS rollup for all slices ' || SQL%ROWCOUNT ,null,3);
6455: end if;
6456:
6457: Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_FP_FACT;
6458:
6459: IF p_commit = 'Y' THEN
6460: COMMIT;
6461: END IF;