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_SUM_ROLLUP_FIN dependencies on PJI_FM_SUM_ROLLUP_FIN

Line 1: package body PJI_FM_SUM_ROLLUP_FIN as

1: package body PJI_FM_SUM_ROLLUP_FIN as
2: /* $Header: PJISF04B.pls 120.5 2006/04/18 20:07:45 appldev noship $ */
3:
4: -- -----------------------------------------------------
5: -- procedure FIN_ROWID_TABLE

Line 16: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.FIN_ROWID_TABLE(p_worker_id);')) then

12: begin
13:
14: l_process := PJI_RM_SUM_MAIN.g_process || p_worker_id;
15:
16: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.FIN_ROWID_TABLE(p_worker_id);')) then
17: return;
18: end if;
19:
20: insert /*+ append parallel(fin_i) */ into PJI_PJI_RMAP_FIN fin_i

Line 35: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.FIN_ROWID_TABLE(p_worker_id);');

31: where
32: map.WORKER_ID = p_worker_id and
33: fin9.PROJECT_ID = map.PROJECT_ID;
34:
35: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.FIN_ROWID_TABLE(p_worker_id);');
36:
37: commit;
38:
39: end FIN_ROWID_TABLE;

Line 60: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.AGGREGATE_FIN_ET_WT_SLICES(p_worker_id);')) then

56: begin
57:
58: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
59:
60: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.AGGREGATE_FIN_ET_WT_SLICES(p_worker_id);')) then
61: return;
62: end if;
63:
64: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 534: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.AGGREGATE_FIN_ET_WT_SLICES(p_worker_id);');

530: src3.DIFF_ROWNUM,
531: nvl(src3.CURRENCY_CODE, 'PJI$NULL'),
532: src3.PERIOD_TYPE_ID;
533:
534: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.AGGREGATE_FIN_ET_WT_SLICES(p_worker_id);');
535:
536: commit;
537:
538: end AGGREGATE_FIN_ET_WT_SLICES;

Line 553: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.PURGE_FIN_DATA(p_worker_id);')) then

549: begin
550:
551: l_process := PJI_RM_SUM_MAIN.g_process || p_worker_id;
552:
553: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.PURGE_FIN_DATA(p_worker_id);')) then
554: return;
555: end if;
556:
557: delete

Line 563: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.PURGE_FIN_DATA(p_worker_id);');

559: where ROWID in (select STG_ROWID
560: from PJI_PJI_RMAP_FIN
561: where WORKER_ID = p_worker_id);
562:
563: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.PURGE_FIN_DATA(p_worker_id);');
564:
565: commit;
566:
567: end PURGE_FIN_DATA;

Line 582: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.AGGREGATE_FIN_ET_SLICES(p_worker_id);')) then

578: begin
579:
580: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
581:
582: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.AGGREGATE_FIN_ET_SLICES(p_worker_id);')) then
583: return;
584: end if;
585:
586: insert /*+ append parallel(fin5_i) */ into PJI_FM_AGGR_FIN5 fin5_i

Line 664: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.AGGREGATE_FIN_ET_SLICES(p_worker_id);');

660: tmp4.PA_CALENDAR_ID,
661: tmp4.CURR_RECORD_TYPE_ID,
662: tmp4.CURRENCY_CODE;
663:
664: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.AGGREGATE_FIN_ET_SLICES(p_worker_id);');
665:
666: commit;
667:
668: end AGGREGATE_FIN_ET_SLICES;

Line 683: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.AGGREGATE_FIN_SLICES(p_worker_id);')) then

679: begin
680:
681: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
682:
683: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.AGGREGATE_FIN_SLICES(p_worker_id);')) then
684: return;
685: end if;
686:
687: insert /*+ append parallel(fin3_i) */ into PJI_FM_AGGR_FIN3 fin3_i

Line 782: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.AGGREGATE_FIN_SLICES(p_worker_id);');

778: tmp5.PA_CALENDAR_ID,
779: tmp5.CURR_RECORD_TYPE_ID,
780: tmp5.CURRENCY_CODE;
781:
782: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.AGGREGATE_FIN_SLICES(p_worker_id);');
783:
784: commit;
785:
786: end AGGREGATE_FIN_SLICES;

Line 801: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_EN(p_worker_id);')) then

797: begin
798:
799: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
800:
801: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_EN(p_worker_id);')) then
802: return;
803: end if;
804:
805: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 918: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_EN(p_worker_id);');

914: not (grouping(time.ENT_YEAR_ID) = 1 and
915: grouping(time.ENT_QTR_ID) = 1 and
916: grouping(time.ENT_PERIOD_ID) = 1);
917:
918: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_EN(p_worker_id);');
919:
920: commit;
921:
922: end EXPAND_FPW_CAL_EN;

Line 940: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_PA(p_worker_id);')) then

936: end if;
937:
938: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
939:
940: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_PA(p_worker_id);')) then
941: return;
942: end if;
943:
944: insert /*+ append parallel(fin4_i) */ into PJI_FM_AGGR_FIN4 fin4_i -- in EXPAND_FPW_CAL_PA

Line 1054: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_PA(p_worker_id);');

1050: not (grouping(time.CAL_YEAR_ID) = 1 and
1051: grouping(time.CAL_QTR_ID) = 1 and
1052: grouping(time.CAL_PERIOD_ID) = 1);
1053:
1054: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_PA(p_worker_id);');
1055:
1056: commit;
1057:
1058: end EXPAND_FPW_CAL_PA;

Line 1076: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_GL(p_worker_id);')) then

1072: end if;
1073:
1074: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1075:
1076: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_GL(p_worker_id);')) then
1077: return;
1078: end if;
1079:
1080: insert /*+ append parallel(fin4_i) */ into PJI_FM_AGGR_FIN4 fin4_i -- in EXPAND_FPW_CAL_GL

Line 1190: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_GL(p_worker_id);');

1186: not (grouping(time.CAL_YEAR_ID) = 1 and
1187: grouping(time.CAL_QTR_ID) = 1 and
1188: grouping(time.CAL_PERIOD_ID) = 1);
1189:
1190: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_GL(p_worker_id);');
1191:
1192: commit;
1193:
1194: end EXPAND_FPW_CAL_GL;

Line 1209: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_WK(p_worker_id);')) then

1205: begin
1206:
1207: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1208:
1209: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_WK(p_worker_id);')) then
1210: return;
1211: end if;
1212:
1213: insert /*+ append parallel(fin4_i) */ into PJI_FM_AGGR_FIN4 fin4_i -- in EXPAND_FPW_CAL_WK

Line 1293: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_WK(p_worker_id);');

1289: time.WEEK_ID,
1290: bitand(fin.CURR_RECORD_TYPE_ID, 247),
1291: fin.CURRENCY_CODE;
1292:
1293: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPW_CAL_WK(p_worker_id);');
1294:
1295: commit;
1296:
1297: end EXPAND_FPW_CAL_WK;

Line 1311: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_EN(p_worker_id);')) then

1307: begin
1308:
1309: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1310:
1311: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_EN(p_worker_id);')) then
1312: return;
1313: end if;
1314:
1315: insert /*+ append parallel(fin5_i) */ into PJI_FM_AGGR_FIN5 fin5_i -- in EXPAND_FPE_CAL_EN

Line 1422: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_EN(p_worker_id);');

1418: not (grouping(time.ENT_YEAR_ID) = 1 and
1419: grouping(time.ENT_QTR_ID) = 1 and
1420: grouping(time.ENT_PERIOD_ID) = 1);
1421:
1422: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_EN(p_worker_id);');
1423:
1424: commit;
1425:
1426: end EXPAND_FPE_CAL_EN;

Line 1444: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_PA(p_worker_id);')) then

1440: end if;
1441:
1442: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1443:
1444: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_PA(p_worker_id);')) then
1445: return;
1446: end if;
1447:
1448: insert /*+ append parallel(fin5_i) */ into PJI_FM_AGGR_FIN5 fin5_i -- in EXPAND_FPE_CAL_PA

Line 1555: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_PA(p_worker_id);');

1551: not (grouping(time.CAL_YEAR_ID) = 1 and
1552: grouping(time.CAL_QTR_ID) = 1 and
1553: grouping(time.CAL_PERIOD_ID) = 1);
1554:
1555: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_PA(p_worker_id);');
1556:
1557: commit;
1558:
1559: end EXPAND_FPE_CAL_PA;

Line 1577: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_GL(p_worker_id);')) then

1573: end if;
1574:
1575: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1576:
1577: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_GL(p_worker_id);')) then
1578: return;
1579: end if;
1580:
1581: insert /*+ append parallel(fin5_i) */ into PJI_FM_AGGR_FIN5 fin5_i -- in EXPAND_FPE_CAL_GL

Line 1688: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_GL(p_worker_id);');

1684: not (grouping(time.CAL_YEAR_ID) = 1 and
1685: grouping(time.CAL_QTR_ID) = 1 and
1686: grouping(time.CAL_PERIOD_ID) = 1);
1687:
1688: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_GL(p_worker_id);');
1689:
1690: commit;
1691:
1692: end EXPAND_FPE_CAL_GL;

Line 1707: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_WK(p_worker_id);')) then

1703: begin
1704:
1705: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1706:
1707: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_WK(p_worker_id);')) then
1708: return;
1709: end if;
1710:
1711: insert /*+ append parallel(fin5_i) */ into PJI_FM_AGGR_FIN5 fin5_i -- in EXPAND_FPE_CAL_WK

Line 1788: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_WK(p_worker_id);');

1784: time.WEEK_ID,
1785: bitand(fin.CURR_RECORD_TYPE_ID, 247),
1786: fin.CURRENCY_CODE;
1787:
1788: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPE_CAL_WK(p_worker_id);');
1789:
1790: commit;
1791:
1792: end EXPAND_FPE_CAL_WK;

Line 1807: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_EN(p_worker_id);')) then

1803: begin
1804:
1805: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
1806:
1807: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_EN(p_worker_id);')) then
1808: return;
1809: end if;
1810:
1811: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 2172: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_EN(p_worker_id);');

2168: fin.CALENDAR_TYPE,
2169: fin.CURR_RECORD_TYPE_ID,
2170: fin.CURRENCY_CODE;
2171:
2172: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_EN(p_worker_id);');
2173:
2174: commit;
2175:
2176: end EXPAND_FPP_CAL_EN;

Line 2195: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_PA(p_worker_id);')) then

2191: end if;
2192:
2193: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
2194:
2195: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_PA(p_worker_id);')) then
2196: return;
2197: end if;
2198:
2199: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 2559: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_PA(p_worker_id);');

2555: fin.CALENDAR_TYPE,
2556: fin.CURR_RECORD_TYPE_ID,
2557: fin.CURRENCY_CODE;
2558:
2559: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_PA(p_worker_id);');
2560:
2561: commit;
2562:
2563: end EXPAND_FPP_CAL_PA;

Line 2582: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_GL(p_worker_id);')) then

2578: end if;
2579:
2580: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
2581:
2582: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_GL(p_worker_id);')) then
2583: return;
2584: end if;
2585:
2586: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 2955: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_GL(p_worker_id);');

2951: bitand(fin.CURR_RECORD_TYPE_ID,
2952: 247)),
2953: fin.CURRENCY_CODE;
2954:
2955: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_GL(p_worker_id);');
2956:
2957: commit;
2958:
2959: end EXPAND_FPP_CAL_GL;

Line 2975: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_WK(p_worker_id);')) then

2971: begin
2972:
2973: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
2974:
2975: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_WK(p_worker_id);')) then
2976: return;
2977: end if;
2978:
2979: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 3273: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_WK(p_worker_id);');

3269: CALENDAR_TYPE,
3270: CURR_RECORD_TYPE_ID,
3271: CURRENCY_CODE;
3272:
3273: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ROLLUP_FIN.EXPAND_FPP_CAL_WK(p_worker_id);');
3274:
3275: -- truncate intermediate tables no longer required
3276: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
3277: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_AGGR_PLN' , 'NORMAL',null);

Line 3305: 'PJI_FM_SUM_ROLLUP_FIN.MERGE_FIN_INTO_FPW(p_worker_id);'

3301:
3302: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
3303: (
3304: l_process,
3305: 'PJI_FM_SUM_ROLLUP_FIN.MERGE_FIN_INTO_FPW(p_worker_id);'
3306: )) then
3307: return;
3308: end if;
3309:

Line 3763: 'PJI_FM_SUM_ROLLUP_FIN.MERGE_FIN_INTO_FPW(p_worker_id);'

3759:
3760: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
3761: (
3762: l_process,
3763: 'PJI_FM_SUM_ROLLUP_FIN.MERGE_FIN_INTO_FPW(p_worker_id);'
3764: );
3765:
3766: -- truncate intermediate tables no longer required
3767: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

Line 3796: 'PJI_FM_SUM_ROLLUP_FIN.MERGE_FIN_INTO_FPE(p_worker_id);'

3792:
3793: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
3794: (
3795: l_process,
3796: 'PJI_FM_SUM_ROLLUP_FIN.MERGE_FIN_INTO_FPE(p_worker_id);'
3797: )) then
3798: return;
3799: end if;
3800:

Line 4276: 'PJI_FM_SUM_ROLLUP_FIN.MERGE_FIN_INTO_FPE(p_worker_id);'

4272:
4273: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
4274: (
4275: l_process,
4276: 'PJI_FM_SUM_ROLLUP_FIN.MERGE_FIN_INTO_FPE(p_worker_id);'
4277: );
4278:
4279: -- truncate intermediate tables no longer required
4280: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

Line 4309: 'PJI_FM_SUM_ROLLUP_FIN.MERGE_FIN_INTO_FPP(p_worker_id);'

4305:
4306: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
4307: (
4308: l_process,
4309: 'PJI_FM_SUM_ROLLUP_FIN.MERGE_FIN_INTO_FPP(p_worker_id);'
4310: )) then
4311: return;
4312: end if;
4313:

Line 4968: 'PJI_FM_SUM_ROLLUP_FIN.MERGE_FIN_INTO_FPP(p_worker_id);'

4964:
4965: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
4966: (
4967: l_process,
4968: 'PJI_FM_SUM_ROLLUP_FIN.MERGE_FIN_INTO_FPP(p_worker_id);'
4969: );
4970:
4971: -- truncate intermediate tables no longer required
4972: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

Line 5019: 'PJI_FM_SUM_ROLLUP_FIN.PROJECT_ORGANIZATION(p_worker_id);'

5015:
5016: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
5017: (
5018: l_process,
5019: 'PJI_FM_SUM_ROLLUP_FIN.PROJECT_ORGANIZATION(p_worker_id);'
5020: )) then
5021: return;
5022: end if;
5023:

Line 5107: 'PJI_FM_SUM_ROLLUP_FIN.PROJECT_ORGANIZATION(p_worker_id);'

5103:
5104: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
5105: (
5106: l_process,
5107: 'PJI_FM_SUM_ROLLUP_FIN.PROJECT_ORGANIZATION(p_worker_id);'
5108: );
5109:
5110: commit;
5111:

Line 5137: 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FWO(p_worker_id);'

5133:
5134: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
5135: (
5136: l_process,
5137: 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FWO(p_worker_id);'
5138: )) then
5139: return;
5140: end if;
5141:

Line 5217: 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FWO(p_worker_id);'

5213:
5214: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
5215: (
5216: l_process,
5217: 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FWO(p_worker_id);'
5218: );
5219:
5220: commit;
5221:

Line 5246: 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FWC(p_worker_id);'

5242:
5243: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
5244: (
5245: l_process,
5246: 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FWC(p_worker_id);'
5247: )) then
5248: return;
5249: end if;
5250:

Line 5313: 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FWC(p_worker_id);'

5309:
5310: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
5311: (
5312: l_process,
5313: 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FWC(p_worker_id);'
5314: );
5315:
5316: commit;
5317:

Line 5342: 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FEO(p_worker_id);'

5338:
5339: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
5340: (
5341: l_process,
5342: 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FEO(p_worker_id);'
5343: )) then
5344: return;
5345: end if;
5346:

Line 5408: 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FEO(p_worker_id);'

5404:
5405: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
5406: (
5407: l_process,
5408: 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FEO(p_worker_id);'
5409: );
5410:
5411: commit;
5412:

Line 5436: 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FEC(p_worker_id);'

5432:
5433: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
5434: (
5435: l_process,
5436: 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FEC(p_worker_id);'
5437: )) then
5438: return;
5439: end if;
5440:

Line 5498: 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FEC(p_worker_id);'

5494:
5495: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
5496: (
5497: l_process,
5498: 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FEC(p_worker_id);'
5499: );
5500:
5501: commit;
5502:

Line 5527: 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FPO(p_worker_id);'

5523:
5524: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
5525: (
5526: l_process,
5527: 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FPO(p_worker_id);'
5528: )) then
5529: return;
5530: end if;
5531:

Line 5593: 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FPO(p_worker_id);'

5589:
5590: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
5591: (
5592: l_process,
5593: 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FPO(p_worker_id);'
5594: );
5595:
5596: commit;
5597:

Line 5621: 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FPC(p_worker_id);'

5617:
5618: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
5619: (
5620: l_process,
5621: 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FPC(p_worker_id);'
5622: )) then
5623: return;
5624: end if;
5625:

Line 5682: 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FPC(p_worker_id);'

5678:
5679: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
5680: (
5681: l_process,
5682: 'PJI_FM_SUM_ROLLUP_FIN.REFRESH_MVIEW_FPC(p_worker_id);'
5683: );
5684:
5685: commit;
5686:

Line 5689: end PJI_FM_SUM_ROLLUP_FIN;

5685: commit;
5686:
5687: end REFRESH_MVIEW_FPC;
5688:
5689: end PJI_FM_SUM_ROLLUP_FIN;