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_PROCESS_UTIL

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 64: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

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
65: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
66:
67: select
68: TXN_CURR_FLAG,

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 805: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

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
806: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
807:
808: insert /*+ append parallel(fin4_i) */ into PJI_FM_AGGR_FIN4 fin4_i -- in EXPAND_FPW_CAL_EN
809: (

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 934: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process, 'PA_CALENDAR_FLAG') = 'N') then

930: l_process varchar2(30);
931:
932: begin
933:
934: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process, 'PA_CALENDAR_FLAG') = 'N') then
935: return;
936: end if;
937:
938: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

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 1070: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process, 'GL_CALENDAR_FLAG') = 'N') then

1066: l_process varchar2(30);
1067:
1068: begin
1069:
1070: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process, 'GL_CALENDAR_FLAG') = 'N') then
1071: return;
1072: end if;
1073:
1074: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

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 1438: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process, 'PA_CALENDAR_FLAG') = 'N') then

1434: l_process varchar2(30);
1435:
1436: begin
1437:
1438: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process, 'PA_CALENDAR_FLAG') = 'N') then
1439: return;
1440: end if;
1441:
1442: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

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 1571: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process, 'GL_CALENDAR_FLAG') = 'N') then

1567: l_process varchar2(30);
1568:
1569: begin
1570:
1571: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process, 'GL_CALENDAR_FLAG') = 'N') then
1572: return;
1573: end if;
1574:
1575: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

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 1811: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

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
1812: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
1813:
1814: insert /*+ append parallel(fin3_i) */ into PJI_FM_AGGR_FIN3 fin3_i -- in EXPAND_FPP_CAL_EN
1815: (

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 2189: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process, 'PA_CALENDAR_FLAG') = 'N') then

2185: l_extraction_type varchar2(30);
2186:
2187: begin
2188:
2189: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process, 'PA_CALENDAR_FLAG') = 'N') then
2190: return;
2191: end if;
2192:
2193: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

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 2199: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

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
2200: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
2201:
2202: insert /*+ append parallel(fin3_i) */ into PJI_FM_AGGR_FIN3 fin3_i -- in EXPAND_FPP_CAL_PA
2203: (

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 2576: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process, 'GL_CALENDAR_FLAG') = 'N') then

2572: l_extraction_type varchar2(30);
2573:
2574: begin
2575:
2576: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process, 'GL_CALENDAR_FLAG') = 'N') then
2577: return;
2578: end if;
2579:
2580: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

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 2586: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

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
2587: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
2588:
2589: insert /*+ append parallel(fin3_i) */ into PJI_FM_AGGR_FIN3 fin3_i -- in EXPAND_FPP_CAL_GL
2590: (

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 2979: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

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
2980: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
2981:
2982: insert /*+ append parallel(fin3_i) */ into PJI_FM_AGGR_FIN3 fin3_i -- in EXPAND_FPP_CAL_WK
2983: (

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 3277: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_AGGR_PLN' , 'NORMAL',null);

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);
3278:
3279: commit;
3280:
3281: end EXPAND_FPP_CAL_WK;

Line 3302: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

3298: begin
3299:
3300: l_process := PJI_RM_SUM_MAIN.g_process || to_char(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

Line 3310: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3306: )) then
3307: return;
3308: end if;
3309:
3310: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3311: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
3312:
3313: l_last_update_date := sysdate;
3314: l_last_updated_by := FND_GLOBAL.USER_ID;

Line 3760: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

3756: );
3757:
3758: end if;
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: );

Line 3768: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema , 'PJI_FM_AGGR_FIN4' , 'NORMAL',null);

3764: );
3765:
3766: -- truncate intermediate tables no longer required
3767: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
3768: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema , 'PJI_FM_AGGR_FIN4' , 'NORMAL',null);
3769:
3770: commit;
3771:
3772: end MERGE_FIN_INTO_FPW;

Line 3793: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

3789: begin
3790:
3791: l_process := PJI_RM_SUM_MAIN.g_process || to_char(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

Line 3801: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3797: )) then
3798: return;
3799: end if;
3800:
3801: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3802: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
3803:
3804: l_last_update_date := sysdate;
3805: l_last_updated_by := FND_GLOBAL.USER_ID;

Line 4273: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

4269: );
4270:
4271: end if;
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: );

Line 4281: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema , 'PJI_FM_AGGR_FIN5' , 'NORMAL',null);

4277: );
4278:
4279: -- truncate intermediate tables no longer required
4280: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
4281: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema , 'PJI_FM_AGGR_FIN5' , 'NORMAL',null);
4282:
4283: commit;
4284:
4285: end MERGE_FIN_INTO_FPE;

Line 4306: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

4302: begin
4303:
4304: l_process := PJI_RM_SUM_MAIN.g_process || to_char(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

Line 4314: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

4310: )) then
4311: return;
4312: end if;
4313:
4314: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4315: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
4316:
4317: l_last_update_date := sysdate;
4318: l_last_updated_by := FND_GLOBAL.USER_ID;

Line 4965: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

4961: );
4962:
4963: end if;
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: );

Line 4973: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema , 'PJI_FM_AGGR_FIN3' , 'NORMAL',null);

4969: );
4970:
4971: -- truncate intermediate tables no longer required
4972: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
4973: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema , 'PJI_FM_AGGR_FIN3' , 'NORMAL',null);
4974:
4975: commit;
4976:
4977: end MERGE_FIN_INTO_FPP;

Line 5016: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

5012: begin
5013:
5014: l_process := PJI_RM_SUM_MAIN.g_process || to_char(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

Line 5104: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

5100:
5101: CLOSE update_scope;
5102:
5103:
5104: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
5105: (
5106: l_process,
5107: 'PJI_FM_SUM_ROLLUP_FIN.PROJECT_ORGANIZATION(p_worker_id);'
5108: );

Line 5134: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

5130: begin
5131:
5132: l_process := PJI_RM_SUM_MAIN.g_process || to_char(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

Line 5142: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

5138: )) then
5139: return;
5140: end if;
5141:
5142: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
5143: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
5144:
5145: if (upper(nvl(FND_PROFILE.VALUE('PJI_USE_DBI_RSG'), 'N')) = 'Y' and
5146: l_extraction_type <> 'PARTIAL') then

Line 5160: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_top_process,

5156:
5157: /*
5158: l_params_util_flag :=
5159: nvl(PJI_UTILS.GET_PARAMETER('CONFIG_UTIL_FLAG'),
5160: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_top_process,
5161: 'CONFIG_UTIL_FLAG'), 'N'));
5162:
5163: if (l_params_util_flag = 'N') then
5164: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,

Line 5214: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

5210: percent => 10,
5211: degree => l_p_degree);
5212: end if;
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: );

Line 5243: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

5239: begin
5240:
5241: l_process := PJI_RM_SUM_MAIN.g_process || to_char(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

Line 5251: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

5247: )) then
5248: return;
5249: end if;
5250:
5251: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
5252: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
5253:
5254: if (upper(nvl(FND_PROFILE.VALUE('PJI_USE_DBI_RSG'), 'N')) = 'Y' and
5255: l_extraction_type <> 'PARTIAL') then

Line 5310: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

5306: percent => 10,
5307: degree => l_p_degree);
5308: end if;
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: );

Line 5339: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

5335: begin
5336:
5337: l_process := PJI_RM_SUM_MAIN.g_process || to_char(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

Line 5347: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

5343: )) then
5344: return;
5345: end if;
5346:
5347: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
5348: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
5349:
5350: if (upper(nvl(FND_PROFILE.VALUE('PJI_USE_DBI_RSG'), 'N')) = 'Y' and
5351: l_extraction_type <> 'PARTIAL') then

Line 5405: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

5401: percent => 10,
5402: degree => l_p_degree);
5403: end if;
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: );

Line 5433: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

5429: begin
5430:
5431: l_process := PJI_RM_SUM_MAIN.g_process || to_char(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

Line 5441: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

5437: )) then
5438: return;
5439: end if;
5440:
5441: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
5442: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
5443:
5444: if (upper(nvl(FND_PROFILE.VALUE('PJI_USE_DBI_RSG'), 'N')) = 'Y' and
5445: l_extraction_type <> 'PARTIAL') then

Line 5495: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

5491: percent => 10,
5492: degree => l_p_degree);
5493: end if;
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: );

Line 5524: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

5520: begin
5521:
5522: l_process := PJI_RM_SUM_MAIN.g_process || to_char(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

Line 5532: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

5528: )) then
5529: return;
5530: end if;
5531:
5532: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
5533: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
5534:
5535: if (upper(nvl(FND_PROFILE.VALUE('PJI_USE_DBI_RSG'), 'N')) = 'Y' and
5536: l_extraction_type <> 'PARTIAL') then

Line 5590: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

5586: percent => 10,
5587: degree => l_p_degree);
5588: end if;
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: );

Line 5618: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

5614: begin
5615:
5616: l_process := PJI_RM_SUM_MAIN.g_process || to_char(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

Line 5626: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

5622: )) then
5623: return;
5624: end if;
5625:
5626: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
5627: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
5628:
5629: if (upper(nvl(FND_PROFILE.VALUE('PJI_USE_DBI_RSG'), 'N')) = 'Y' and
5630: l_extraction_type <> 'PARTIAL') then

Line 5679: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

5675: percent => 10,
5676: degree => l_p_degree);
5677: end if;
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: );