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

Line 672: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES; print_time(' 3 ..1 ');

668: -------------------------------------------------------------------------
669: -- Preparing for extraction and extracting from budget lines.
670: -------------------------------------------------------------------------
671:
672: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES; print_time(' 3 ..1 ');
673:
674:
675: IF (p_is_primary_rbs = 'T') THEN
676:

Line 677: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(

673:
674:
675: IF (p_is_primary_rbs = 'T') THEN
676:
677: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(
678: p_fp_version_ids => p_fp_version_ids
679: , p_slice_type => 'PRI');
680:
681: ELSE

Line 691: PJI_FM_PLAN_MAINT_T_PVT.MAP_ORG_CAL_INFO('N');

687: IF (CHECK_VER3_NOT_EMPTY(p_online => 'T') = 'F') THEN
688: RETURN;
689: END IF;
690:
691: PJI_FM_PLAN_MAINT_T_PVT.MAP_ORG_CAL_INFO('N');
692: print_time(' 2.. Update org/cal tables. ');
693:
694:
695: print_time(' ************** Denorm processing begin ************** ');

Line 774: --PJI_FM_PLAN_MAINT_T_PVT.GET_GLOBAL_EXCHANGE_RATES; -- Bug 7681331

770: print_time(' ***************************************************** ');
771: print_time(' ************** Denorm processing end **************** ');
772:
773: --Introduced below api call for bug 7187487
774: --PJI_FM_PLAN_MAINT_T_PVT.GET_GLOBAL_EXCHANGE_RATES; -- Bug 7681331
775:
776: IF (p_is_primary_rbs = 'T') THEN
777: --Introduced below api call for bug 7187487
778: -- PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_PLAN_AMTS_PRIRBS_GLC12; --Bug 7681331

Line 778: -- PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_PLAN_AMTS_PRIRBS_GLC12; --Bug 7681331

774: --PJI_FM_PLAN_MAINT_T_PVT.GET_GLOBAL_EXCHANGE_RATES; -- Bug 7681331
775:
776: IF (p_is_primary_rbs = 'T') THEN
777: --Introduced below api call for bug 7187487
778: -- PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_PLAN_AMTS_PRIRBS_GLC12; --Bug 7681331
779: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_PLAN_AMOUNTS_PRIRBS;
780: print_time(' 5.1 .. ');
781:
782: ELSE

Line 779: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_PLAN_AMOUNTS_PRIRBS;

775:
776: IF (p_is_primary_rbs = 'T') THEN
777: --Introduced below api call for bug 7187487
778: -- PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_PLAN_AMTS_PRIRBS_GLC12; --Bug 7681331
779: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_PLAN_AMOUNTS_PRIRBS;
780: print_time(' 5.1 .. ');
781:
782: ELSE
783:

Line 785: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_PLAN_AMOUNTS_SECRBS; print_time(' 5.2 .. ');

781:
782: ELSE
783:
784: MAP_RESOURCE_LIST (p_fp_version_ids);
785: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_PLAN_AMOUNTS_SECRBS; print_time(' 5.2 .. ');
786:
787: END IF;
788:
789: -- With data in ver3 table and pjp1 tables,

Line 796: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT; print_time(' 14 .. ');

792:
793:
794: PRI_SLICE_CREATE_T; print_time(' 6 .. ');
795: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES;
796: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT; print_time(' 14 .. ');
797:
798: PJI_FM_PLAN_MAINT_T_PVT.MARK_EXTRACTED_PLANS('PRI'); print_time(' 15 .. ');
799:
800:

Line 798: PJI_FM_PLAN_MAINT_T_PVT.MARK_EXTRACTED_PLANS('PRI'); print_time(' 15 .. ');

794: PRI_SLICE_CREATE_T; print_time(' 6 .. ');
795: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES;
796: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT; print_time(' 14 .. ');
797:
798: PJI_FM_PLAN_MAINT_T_PVT.MARK_EXTRACTED_PLANS('PRI'); print_time(' 15 .. ');
799:
800:
801: IF (p_commit = 'T') THEN
802: COMMIT;

Line 905: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES; -- Clean up interim tables.

901: -- Re-extract pri/sec rbs data with amounts converted to Global1 and
902: -- Global2 currencies also.
903: -------------------------------------------------------------------------
904:
905: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES; -- Clean up interim tables.
906: print_time(' Cleaned up interim tables. ');
907:
908: print_time(' !!!!!!!!!!!! Begin reextraction !!!!!!!! ');
909:

Line 912: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(p_fp_version_ids, 'PRI');

908: print_time(' !!!!!!!!!!!! Begin reextraction !!!!!!!! ');
909:
910:
911: IF (p_process_all = 'F') THEN
912: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(p_fp_version_ids, 'PRI');
913: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(p_fp_version_ids, 'SECRBS');
914: -- PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(p_fp_version_ids, '-3-4');
915: ELSE
916: print_time(' Incorrect parameters to CREATE_SECONDARY_T_PVT: p_process_all = ' || p_process_all );

Line 913: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(p_fp_version_ids, 'SECRBS');

909:
910:
911: IF (p_process_all = 'F') THEN
912: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(p_fp_version_ids, 'PRI');
913: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(p_fp_version_ids, 'SECRBS');
914: -- PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(p_fp_version_ids, '-3-4');
915: ELSE
916: print_time(' Incorrect parameters to CREATE_SECONDARY_T_PVT: p_process_all = ' || p_process_all );
917: RETURN;

Line 914: -- PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(p_fp_version_ids, '-3-4');

910:
911: IF (p_process_all = 'F') THEN
912: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(p_fp_version_ids, 'PRI');
913: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(p_fp_version_ids, 'SECRBS');
914: -- PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(p_fp_version_ids, '-3-4');
915: ELSE
916: print_time(' Incorrect parameters to CREATE_SECONDARY_T_PVT: p_process_all = ' || p_process_all );
917: RETURN;
918: END IF;

Line 926: PJI_FM_PLAN_MAINT_T_PVT.MAP_ORG_CAL_INFO('N') ;

922: print_time(' No data in ver3, returning. ');
923: RETURN;
924: END IF;
925:
926: PJI_FM_PLAN_MAINT_T_PVT.MAP_ORG_CAL_INFO('N') ;
927: print_time(' Updated calendar and org tables. ');
928:
929: PJI_FM_PLAN_MAINT_T_PVT.GET_GLOBAL_EXCHANGE_RATES;
930: print_time(' Got global exchange rates. ');

Line 929: PJI_FM_PLAN_MAINT_T_PVT.GET_GLOBAL_EXCHANGE_RATES;

925:
926: PJI_FM_PLAN_MAINT_T_PVT.MAP_ORG_CAL_INFO('N') ;
927: print_time(' Updated calendar and org tables. ');
928:
929: PJI_FM_PLAN_MAINT_T_PVT.GET_GLOBAL_EXCHANGE_RATES;
930: print_time(' Got global exchange rates. ');
931:
932: SEC_SLICE_CREATE_T;
933: print_time('Proration done and rollups created.');

Line 937: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT;

933: print_time('Proration done and rollups created.');
934:
935: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES;
936:
937: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT;
938: print_time('Merged reversed data.');
939:
940: PJI_FM_PLAN_MAINT_T_PVT.MARK_EXTRACTED_PLANS('SEC');
941: print_time('Marked ');

Line 940: PJI_FM_PLAN_MAINT_T_PVT.MARK_EXTRACTED_PLANS('SEC');

936:
937: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT;
938: print_time('Merged reversed data.');
939:
940: PJI_FM_PLAN_MAINT_T_PVT.MARK_EXTRACTED_PLANS('SEC');
941: print_time('Marked ');
942:
943: PJI_FM_PLAN_MAINT_T_PVT.DELETE_GLOBAL_EXCHANGE_RATES;
944: print_time(' Deleted global exchange rates. ');

Line 943: PJI_FM_PLAN_MAINT_T_PVT.DELETE_GLOBAL_EXCHANGE_RATES;

939:
940: PJI_FM_PLAN_MAINT_T_PVT.MARK_EXTRACTED_PLANS('SEC');
941: print_time('Marked ');
942:
943: PJI_FM_PLAN_MAINT_T_PVT.DELETE_GLOBAL_EXCHANGE_RATES;
944: print_time(' Deleted global exchange rates. ');
945:
946: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES; -- Clean up interim tables.
947:

Line 946: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES; -- Clean up interim tables.

942:
943: PJI_FM_PLAN_MAINT_T_PVT.DELETE_GLOBAL_EXCHANGE_RATES;
944: print_time(' Deleted global exchange rates. ');
945:
946: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES; -- Clean up interim tables.
947:
948: IF (p_commit = 'T') THEN
949: COMMIT;
950: END IF;

Line 974: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(

970: BEGIN
971:
972: print_time('UPDATE_PRIMARY_PVT: begin.. ');
973:
974: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(
975: p_fp_version_ids => p_plan_version_ids
976: , p_slice_type => 'PRI');
977:
978: print_time ( ' 1.1 ');

Line 987: PJI_FM_PLAN_MAINT_T_PVT.MAP_ORG_CAL_INFO('N');

983:
984: WBSCHANGEPROC_PRERLP_SETUPS;
985: print_time(' Setups before calling WBS rollup code. ');
986:
987: PJI_FM_PLAN_MAINT_T_PVT.MAP_ORG_CAL_INFO('N');
988: print_time(' 1.a3 Updated org/cal tables. ');
989:
990: PJI_FM_PLAN_MAINT_T_PVT.RETRIEVE_DELTA_SLICE; print_time ( ' 2 ');
991: print_time(' 1.a4 Extracted data in plan lines. ');

Line 990: PJI_FM_PLAN_MAINT_T_PVT.RETRIEVE_DELTA_SLICE; print_time ( ' 2 ');

986:
987: PJI_FM_PLAN_MAINT_T_PVT.MAP_ORG_CAL_INFO('N');
988: print_time(' 1.a3 Updated org/cal tables. ');
989:
990: PJI_FM_PLAN_MAINT_T_PVT.RETRIEVE_DELTA_SLICE; print_time ( ' 2 ');
991: print_time(' 1.a4 Extracted data in plan lines. ');
992:
993:
994: -- With data in ver3 table and pjp1 tables,

Line 1004: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT;

1000: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES;
1001: WBSCHANGEPROC_POSTRLP_CLEANUP;
1002: print_time(' Cleanup after calling WBS rollup code. ');
1003:
1004: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT;
1005: print_time(' Merged into FP fact. ');
1006:
1007: PJI_FM_PLAN_MAINT_T_PVT.MARK_EXTRACTED_PLANS('PRI');
1008: print_time(' Marked extracted plans ');

Line 1007: PJI_FM_PLAN_MAINT_T_PVT.MARK_EXTRACTED_PLANS('PRI');

1003:
1004: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT;
1005: print_time(' Merged into FP fact. ');
1006:
1007: PJI_FM_PLAN_MAINT_T_PVT.MARK_EXTRACTED_PLANS('PRI');
1008: print_time(' Marked extracted plans ');
1009:
1010: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES;
1011: print_time(' Cleaned up interim tables.');

Line 1010: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES;

1006:
1007: PJI_FM_PLAN_MAINT_T_PVT.MARK_EXTRACTED_PLANS('PRI');
1008: print_time(' Marked extracted plans ');
1009:
1010: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES;
1011: print_time(' Cleaned up interim tables.');
1012:
1013: print_time('UPDATE_PRIMARY_PVT: end. successful.. ');
1014:

Line 1049: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES; -- Clean up interim tables.

1045: ( p_package_name => g_package_name
1046: , x_return_status => x_return_status );
1047:
1048:
1049: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES; -- Clean up interim tables.
1050:
1051: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_PLN_VER_TABLE; print_time ( ' 1 ');
1052:
1053: -- WBSCHANGEPROC_PRERLP_SETUPS;

Line 1051: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_PLN_VER_TABLE; print_time ( ' 1 ');

1047:
1048:
1049: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES; -- Clean up interim tables.
1050:
1051: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_PLN_VER_TABLE; print_time ( ' 1 ');
1052:
1053: -- WBSCHANGEPROC_PRERLP_SETUPS;
1054: -- print_time(' Setups before calling WBS rollup code. ');
1055:

Line 1056: PJI_FM_PLAN_MAINT_T_PVT.REVERSE_ETC(

1052:
1053: -- WBSCHANGEPROC_PRERLP_SETUPS;
1054: -- print_time(' Setups before calling WBS rollup code. ');
1055:
1056: PJI_FM_PLAN_MAINT_T_PVT.REVERSE_ETC(
1057: p_new_pub_version_id => p_plan_version_id
1058: , p_prev_pub_version_id => p_prev_pub_version_id ) ; print_time ( ' 0.2 ');
1059:
1060: PRI_SLICE_CREATE_T; print_time ( ' 3 ');

Line 1065: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT; print_time(' 4 .. ');

1061: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES;
1062: -- WBSCHANGEPROC_POSTRLP_CLEANUP;
1063: -- print_time(' Cleanup after calling WBS rollup code. ');
1064:
1065: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT; print_time(' 4 .. ');
1066:
1067: print_time('UPDATE_PRIMARY_PVT_ACT_ETC: end. successful.. ');
1068:
1069: EXCEPTION

Line 1180: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_RBS_HDR;

1176:
1177: --------------------------------
1178: -- Header table population.
1179: --------------------------------
1180: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_RBS_HDR;
1181: print_time('Populated new records into RBS Header Table.');
1182:
1183: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_WBS_HDR;
1184: print_time('Populated new records into WBS Header Table.');

Line 1183: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_WBS_HDR;

1179: --------------------------------
1180: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_RBS_HDR;
1181: print_time('Populated new records into RBS Header Table.');
1182:
1183: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_WBS_HDR;
1184: print_time('Populated new records into WBS Header Table.');
1185:
1186: --------------------------------
1187: -- Time rollups.

Line 1208: PJI_FM_PLAN_MAINT_T_PVT.ROLLUP_FPR_RBS_T_SLICE;

1204: --------------------------------
1205: -- RBS/WBS/Program rollups.
1206: --------------------------------
1207:
1208: PJI_FM_PLAN_MAINT_T_PVT.ROLLUP_FPR_RBS_T_SLICE;
1209: print_time('RBS rollup done.');
1210:
1211: PJI_FM_PLAN_MAINT_T_PVT.CREATE_WBSRLP;
1212: print_time('WBS rollup done.');

Line 1211: PJI_FM_PLAN_MAINT_T_PVT.CREATE_WBSRLP;

1207:
1208: PJI_FM_PLAN_MAINT_T_PVT.ROLLUP_FPR_RBS_T_SLICE;
1209: print_time('RBS rollup done.');
1210:
1211: PJI_FM_PLAN_MAINT_T_PVT.CREATE_WBSRLP;
1212: print_time('WBS rollup done.');
1213:
1214: PJI_FM_PLAN_MAINT_T_PVT.UPDATE_WBS_HDR;
1215: print_time('Updated the WBS header table with min max txn dates.');

Line 1214: PJI_FM_PLAN_MAINT_T_PVT.UPDATE_WBS_HDR;

1210:
1211: PJI_FM_PLAN_MAINT_T_PVT.CREATE_WBSRLP;
1212: print_time('WBS rollup done.');
1213:
1214: PJI_FM_PLAN_MAINT_T_PVT.UPDATE_WBS_HDR;
1215: print_time('Updated the WBS header table with min max txn dates.');
1216:
1217: EXCEPTION
1218: WHEN OTHERS THEN

Line 1237: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_RBS_HDR;

1233: --------------------------------
1234: -- Header table population.
1235: --------------------------------
1236:
1237: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_RBS_HDR;
1238: print_time('Populated new records into RBS Header Table.');
1239:
1240: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_WBS_HDR;
1241: print_time('Populated new records into WBS Header Table.');

Line 1240: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_WBS_HDR;

1236:
1237: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_RBS_HDR;
1238: print_time('Populated new records into RBS Header Table.');
1239:
1240: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_WBS_HDR;
1241: print_time('Populated new records into WBS Header Table.');
1242:
1243: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_PLAN_AMTS_PRIRBS_GLC12;
1244: print_time(' Extracted plan data for primary RBSes.');

Line 1243: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_PLAN_AMTS_PRIRBS_GLC12;

1239:
1240: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_WBS_HDR;
1241: print_time('Populated new records into WBS Header Table.');
1242:
1243: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_PLAN_AMTS_PRIRBS_GLC12;
1244: print_time(' Extracted plan data for primary RBSes.');
1245:
1246: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_PLAN_AMTS_SECRBS_GLC12;
1247: print_time(' Extracted plan data for secondary RBSes.');

Line 1246: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_PLAN_AMTS_SECRBS_GLC12;

1242:
1243: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_PLAN_AMTS_PRIRBS_GLC12;
1244: print_time(' Extracted plan data for primary RBSes.');
1245:
1246: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_PLAN_AMTS_SECRBS_GLC12;
1247: print_time(' Extracted plan data for secondary RBSes.');
1248:
1249: --
1250: -- Prorate

Line 1255: PJI_FM_PLAN_MAINT_T_PVT.PRORATE_TO_ALL_CALENDARS;

1251: -- 1. GL cal and Non time phased entries into PA cal.
1252: -- 2. PA cal and Non time phased entries into GL cal.
1253: -- 3. PA, GL cals and Non time phased entries into Ent cal.
1254: --
1255: PJI_FM_PLAN_MAINT_T_PVT.PRORATE_TO_ALL_CALENDARS;
1256: print_time(' Prorated to all calendars. ');
1257:
1258:
1259: --------------------------------

Line 1274: PJI_FM_PLAN_MAINT_T_PVT.ROLLUP_FPR_RBS_T_SLICE;

1270: --------------------------------
1271: -- RBS/WBS/Program rollups.
1272: --------------------------------
1273:
1274: PJI_FM_PLAN_MAINT_T_PVT.ROLLUP_FPR_RBS_T_SLICE;
1275: print_time(' RBS rollups done. ');
1276:
1277: PJI_FM_PLAN_MAINT_T_PVT.CREATE_WBSRLP;
1278: print_time(' WBS rollups done. ');

Line 1277: PJI_FM_PLAN_MAINT_T_PVT.CREATE_WBSRLP;

1273:
1274: PJI_FM_PLAN_MAINT_T_PVT.ROLLUP_FPR_RBS_T_SLICE;
1275: print_time(' RBS rollups done. ');
1276:
1277: PJI_FM_PLAN_MAINT_T_PVT.CREATE_WBSRLP;
1278: print_time(' WBS rollups done. ');
1279:
1280: PJI_FM_PLAN_MAINT_T_PVT.UPDATE_WBS_HDR;
1281: print_time('Updated the WBS header table with min max txn dates.');

Line 1280: PJI_FM_PLAN_MAINT_T_PVT.UPDATE_WBS_HDR;

1276:
1277: PJI_FM_PLAN_MAINT_T_PVT.CREATE_WBSRLP;
1278: print_time(' WBS rollups done. ');
1279:
1280: PJI_FM_PLAN_MAINT_T_PVT.UPDATE_WBS_HDR;
1281: print_time('Updated the WBS header table with min max txn dates.');
1282:
1283: EXCEPTION
1284: WHEN OTHERS THEN

Line 1879: Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_AC_FACT;

1875: p_worker_id => 1
1876: , p_extraction_type => 'ONLINE');
1877: print_time(' Cleaned up xbs delta denorm. ');
1878:
1879: Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_AC_FACT;
1880: print_time(' Merged into AC fact. ');
1881:
1882:
1883: /*