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 941: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES; -- Clean up interim tables.

937: -- Re-extract pri/sec rbs data with amounts converted to Global1 and
938: -- Global2 currencies also.
939: -------------------------------------------------------------------------
940:
941: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES; -- Clean up interim tables.
942: print_time(' Cleaned up interim tables. ');
943:
944: print_time(' !!!!!!!!!!!! Begin reextraction !!!!!!!! ');
945:

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

944: print_time(' !!!!!!!!!!!! Begin reextraction !!!!!!!! ');
945:
946:
947: IF (p_process_all = 'F') THEN
948: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(p_fp_version_ids, 'PRI');
949: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(p_fp_version_ids, 'SECRBS');
950: -- PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(p_fp_version_ids, '-3-4');
951: ELSE
952: print_time(' Incorrect parameters to CREATE_SECONDARY_T_PVT: p_process_all = ' || p_process_all );

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

945:
946:
947: IF (p_process_all = 'F') THEN
948: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(p_fp_version_ids, 'PRI');
949: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(p_fp_version_ids, 'SECRBS');
950: -- PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(p_fp_version_ids, '-3-4');
951: ELSE
952: print_time(' Incorrect parameters to CREATE_SECONDARY_T_PVT: p_process_all = ' || p_process_all );
953: RETURN;

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

946:
947: IF (p_process_all = 'F') THEN
948: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(p_fp_version_ids, 'PRI');
949: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(p_fp_version_ids, 'SECRBS');
950: -- PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(p_fp_version_ids, '-3-4');
951: ELSE
952: print_time(' Incorrect parameters to CREATE_SECONDARY_T_PVT: p_process_all = ' || p_process_all );
953: RETURN;
954: END IF;

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

958: print_time(' No data in ver3, returning. ');
959: RETURN;
960: END IF;
961:
962: PJI_FM_PLAN_MAINT_T_PVT.MAP_ORG_CAL_INFO('N') ;
963: print_time(' Updated calendar and org tables. ');
964:
965: PJI_FM_PLAN_MAINT_T_PVT.GET_GLOBAL_EXCHANGE_RATES;
966: print_time(' Got global exchange rates. ');

Line 965: PJI_FM_PLAN_MAINT_T_PVT.GET_GLOBAL_EXCHANGE_RATES;

961:
962: PJI_FM_PLAN_MAINT_T_PVT.MAP_ORG_CAL_INFO('N') ;
963: print_time(' Updated calendar and org tables. ');
964:
965: PJI_FM_PLAN_MAINT_T_PVT.GET_GLOBAL_EXCHANGE_RATES;
966: print_time(' Got global exchange rates. ');
967:
968: SEC_SLICE_CREATE_T;
969: print_time('Proration done and rollups created.');

Line 973: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT;

969: print_time('Proration done and rollups created.');
970:
971: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES;
972:
973: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT;
974: print_time('Merged reversed data.');
975:
976: PJI_FM_PLAN_MAINT_T_PVT.MARK_EXTRACTED_PLANS('SEC');
977: print_time('Marked ');

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

972:
973: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT;
974: print_time('Merged reversed data.');
975:
976: PJI_FM_PLAN_MAINT_T_PVT.MARK_EXTRACTED_PLANS('SEC');
977: print_time('Marked ');
978:
979: PJI_FM_PLAN_MAINT_T_PVT.DELETE_GLOBAL_EXCHANGE_RATES;
980: print_time(' Deleted global exchange rates. ');

Line 979: PJI_FM_PLAN_MAINT_T_PVT.DELETE_GLOBAL_EXCHANGE_RATES;

975:
976: PJI_FM_PLAN_MAINT_T_PVT.MARK_EXTRACTED_PLANS('SEC');
977: print_time('Marked ');
978:
979: PJI_FM_PLAN_MAINT_T_PVT.DELETE_GLOBAL_EXCHANGE_RATES;
980: print_time(' Deleted global exchange rates. ');
981:
982: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES; -- Clean up interim tables.
983:

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

978:
979: PJI_FM_PLAN_MAINT_T_PVT.DELETE_GLOBAL_EXCHANGE_RATES;
980: print_time(' Deleted global exchange rates. ');
981:
982: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES; -- Clean up interim tables.
983:
984: IF (p_commit = 'T') THEN
985: COMMIT;
986: END IF;

Line 1010: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(

1006: BEGIN
1007:
1008: print_time('UPDATE_PRIMARY_PVT: begin.. ');
1009:
1010: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_FIN_PLAN_VERSIONS(
1011: p_fp_version_ids => p_plan_version_ids
1012: , p_slice_type => 'PRI');
1013:
1014: print_time ( ' 1.1 ');

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

1019:
1020: WBSCHANGEPROC_PRERLP_SETUPS;
1021: print_time(' Setups before calling WBS rollup code. ');
1022:
1023: PJI_FM_PLAN_MAINT_T_PVT.MAP_ORG_CAL_INFO('N');
1024: print_time(' 1.a3 Updated org/cal tables. ');
1025:
1026: PJI_FM_PLAN_MAINT_T_PVT.RETRIEVE_DELTA_SLICE; print_time ( ' 2 ');
1027: print_time(' 1.a4 Extracted data in plan lines. ');

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

1022:
1023: PJI_FM_PLAN_MAINT_T_PVT.MAP_ORG_CAL_INFO('N');
1024: print_time(' 1.a3 Updated org/cal tables. ');
1025:
1026: PJI_FM_PLAN_MAINT_T_PVT.RETRIEVE_DELTA_SLICE; print_time ( ' 2 ');
1027: print_time(' 1.a4 Extracted data in plan lines. ');
1028:
1029:
1030: -- With data in ver3 table and pjp1 tables,

Line 1040: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT;

1036: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES;
1037: WBSCHANGEPROC_POSTRLP_CLEANUP;
1038: print_time(' Cleanup after calling WBS rollup code. ');
1039:
1040: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT;
1041: print_time(' Merged into FP fact. ');
1042:
1043: PJI_FM_PLAN_MAINT_T_PVT.MARK_EXTRACTED_PLANS('PRI');
1044: print_time(' Marked extracted plans ');

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

1039:
1040: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT;
1041: print_time(' Merged into FP fact. ');
1042:
1043: PJI_FM_PLAN_MAINT_T_PVT.MARK_EXTRACTED_PLANS('PRI');
1044: print_time(' Marked extracted plans ');
1045:
1046: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES;
1047: print_time(' Cleaned up interim tables.');

Line 1046: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES;

1042:
1043: PJI_FM_PLAN_MAINT_T_PVT.MARK_EXTRACTED_PLANS('PRI');
1044: print_time(' Marked extracted plans ');
1045:
1046: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES;
1047: print_time(' Cleaned up interim tables.');
1048:
1049: print_time('UPDATE_PRIMARY_PVT: end. successful.. ');
1050:

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

1081: ( p_package_name => g_package_name
1082: , x_return_status => x_return_status );
1083:
1084:
1085: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES; -- Clean up interim tables.
1086:
1087: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_PLN_VER_TABLE; print_time ( ' 1 ');
1088:
1089: -- WBSCHANGEPROC_PRERLP_SETUPS;

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

1083:
1084:
1085: PJI_FM_PLAN_MAINT_T_PVT.CLEANUP_INTERIM_TABLES; -- Clean up interim tables.
1086:
1087: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_PLN_VER_TABLE; print_time ( ' 1 ');
1088:
1089: -- WBSCHANGEPROC_PRERLP_SETUPS;
1090: -- print_time(' Setups before calling WBS rollup code. ');
1091:

Line 1092: PJI_FM_PLAN_MAINT_T_PVT.REVERSE_ETC(

1088:
1089: -- WBSCHANGEPROC_PRERLP_SETUPS;
1090: -- print_time(' Setups before calling WBS rollup code. ');
1091:
1092: PJI_FM_PLAN_MAINT_T_PVT.REVERSE_ETC(
1093: p_new_pub_version_id => p_plan_version_id
1094: , p_prev_pub_version_id => p_prev_pub_version_id ) ; print_time ( ' 0.2 ');
1095:
1096: PRI_SLICE_CREATE_T; print_time ( ' 3 ');

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

1097: PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES;
1098: -- WBSCHANGEPROC_POSTRLP_CLEANUP;
1099: -- print_time(' Cleanup after calling WBS rollup code. ');
1100:
1101: PJI_FM_PLAN_MAINT_T_PVT.MERGE_INTO_FP_FACT; print_time(' 4 .. ');
1102:
1103: print_time('UPDATE_PRIMARY_PVT_ACT_ETC: end. successful.. ');
1104:
1105: EXCEPTION

Line 1223: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_RBS_HDR;

1219:
1220: --------------------------------
1221: -- Header table population.
1222: --------------------------------
1223: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_RBS_HDR;
1224: print_time('Populated new records into RBS Header Table.');
1225:
1226: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_WBS_HDR;
1227: print_time('Populated new records into WBS Header Table.');

Line 1226: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_WBS_HDR;

1222: --------------------------------
1223: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_RBS_HDR;
1224: print_time('Populated new records into RBS Header Table.');
1225:
1226: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_WBS_HDR;
1227: print_time('Populated new records into WBS Header Table.');
1228:
1229: --------------------------------
1230: -- Time rollups.

Line 1251: PJI_FM_PLAN_MAINT_T_PVT.ROLLUP_FPR_RBS_T_SLICE;

1247: --------------------------------
1248: -- RBS/WBS/Program rollups.
1249: --------------------------------
1250:
1251: PJI_FM_PLAN_MAINT_T_PVT.ROLLUP_FPR_RBS_T_SLICE;
1252: print_time('RBS rollup done.');
1253:
1254: PJI_FM_PLAN_MAINT_T_PVT.CREATE_WBSRLP;
1255: print_time('WBS rollup done.');

Line 1254: PJI_FM_PLAN_MAINT_T_PVT.CREATE_WBSRLP;

1250:
1251: PJI_FM_PLAN_MAINT_T_PVT.ROLLUP_FPR_RBS_T_SLICE;
1252: print_time('RBS rollup done.');
1253:
1254: PJI_FM_PLAN_MAINT_T_PVT.CREATE_WBSRLP;
1255: print_time('WBS rollup done.');
1256:
1257: PJI_FM_PLAN_MAINT_T_PVT.UPDATE_WBS_HDR;
1258: print_time('Updated the WBS header table with min max txn dates.');

Line 1257: PJI_FM_PLAN_MAINT_T_PVT.UPDATE_WBS_HDR;

1253:
1254: PJI_FM_PLAN_MAINT_T_PVT.CREATE_WBSRLP;
1255: print_time('WBS rollup done.');
1256:
1257: PJI_FM_PLAN_MAINT_T_PVT.UPDATE_WBS_HDR;
1258: print_time('Updated the WBS header table with min max txn dates.');
1259:
1260: EXCEPTION
1261: WHEN OTHERS THEN

Line 1283: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_RBS_HDR;

1279: --------------------------------
1280: -- Header table population.
1281: --------------------------------
1282:
1283: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_RBS_HDR;
1284: print_time('Populated new records into RBS Header Table.');
1285:
1286: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_WBS_HDR;
1287: print_time('Populated new records into WBS Header Table.');

Line 1286: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_WBS_HDR;

1282:
1283: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_RBS_HDR;
1284: print_time('Populated new records into RBS Header Table.');
1285:
1286: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_WBS_HDR;
1287: print_time('Populated new records into WBS Header Table.');
1288:
1289: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_PLAN_AMTS_PRIRBS_GLC12;
1290: print_time(' Extracted plan data for primary RBSes.');

Line 1289: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_PLAN_AMTS_PRIRBS_GLC12;

1285:
1286: PJI_FM_PLAN_MAINT_T_PVT.POPULATE_WBS_HDR;
1287: print_time('Populated new records into WBS Header Table.');
1288:
1289: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_PLAN_AMTS_PRIRBS_GLC12;
1290: print_time(' Extracted plan data for primary RBSes.');
1291:
1292: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_PLAN_AMTS_SECRBS_GLC12;
1293: print_time(' Extracted plan data for secondary RBSes.');

Line 1292: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_PLAN_AMTS_SECRBS_GLC12;

1288:
1289: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_PLAN_AMTS_PRIRBS_GLC12;
1290: print_time(' Extracted plan data for primary RBSes.');
1291:
1292: PJI_FM_PLAN_MAINT_T_PVT.EXTRACT_PLAN_AMTS_SECRBS_GLC12;
1293: print_time(' Extracted plan data for secondary RBSes.');
1294:
1295: --
1296: -- Prorate

Line 1307: PJI_FM_PLAN_MAINT_T_PVT.PRORATE_TO_ALL_CALENDARS;

1303:
1304: if l_time_phase_flag = 'Y' then
1305: null;
1306: else
1307: PJI_FM_PLAN_MAINT_T_PVT.PRORATE_TO_ALL_CALENDARS;
1308: print_time(' Prorated to all calendars. ');
1309: end if;
1310: /* Added for bug 8708651 */
1311:

Line 1327: PJI_FM_PLAN_MAINT_T_PVT.ROLLUP_FPR_RBS_T_SLICE;

1323: --------------------------------
1324: -- RBS/WBS/Program rollups.
1325: --------------------------------
1326:
1327: PJI_FM_PLAN_MAINT_T_PVT.ROLLUP_FPR_RBS_T_SLICE;
1328: print_time(' RBS rollups done. ');
1329:
1330: PJI_FM_PLAN_MAINT_T_PVT.CREATE_WBSRLP;
1331: print_time(' WBS rollups done. ');

Line 1330: PJI_FM_PLAN_MAINT_T_PVT.CREATE_WBSRLP;

1326:
1327: PJI_FM_PLAN_MAINT_T_PVT.ROLLUP_FPR_RBS_T_SLICE;
1328: print_time(' RBS rollups done. ');
1329:
1330: PJI_FM_PLAN_MAINT_T_PVT.CREATE_WBSRLP;
1331: print_time(' WBS rollups done. ');
1332:
1333: PJI_FM_PLAN_MAINT_T_PVT.UPDATE_WBS_HDR;
1334: print_time('Updated the WBS header table with min max txn dates.');

Line 1333: PJI_FM_PLAN_MAINT_T_PVT.UPDATE_WBS_HDR;

1329:
1330: PJI_FM_PLAN_MAINT_T_PVT.CREATE_WBSRLP;
1331: print_time(' WBS rollups done. ');
1332:
1333: PJI_FM_PLAN_MAINT_T_PVT.UPDATE_WBS_HDR;
1334: print_time('Updated the WBS header table with min max txn dates.');
1335:
1336: EXCEPTION
1337: WHEN OTHERS THEN

Line 1939: Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_AC_FACT;

1935: p_worker_id => 1
1936: , p_extraction_type => 'ONLINE');
1937: print_time(' Cleaned up xbs delta denorm. ');
1938:
1939: Pji_Fm_Plan_Maint_T_Pvt.MERGE_INTO_AC_FACT;
1940: print_time(' Merged into AC fact. ');
1941:
1942:
1943: /*