APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_PJP_SUM_MAIN

Line 42: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;

38: l_msg_data varchar2(2000);
39:
40: begin
41:
42: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;
43:
44: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.POPULATE_TIME_DIMENSION(p_worker_id);')) then
45: return;
46: end if;

Line 310: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

306: l_last_update_login number;
307:
308: begin
309:
310: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
311:
312: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.CREATE_EVENTS_SNAPSHOT(p_worker_id);')) then
313: return;
314: end if;

Line 1145: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

1141: l_msg_data varchar2(2000);
1142:
1143: begin
1144:
1145: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
1146:
1147: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.PROCESS_RBS_CHANGES(p_worker_id);')) then
1148: return;
1149: end if;

Line 1208: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

1204: l_msg_data varchar2(2000);
1205:
1206: begin
1207:
1208: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
1209:
1210: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.CREATE_MAPPING_RULES(p_worker_id);')) then
1211: return;
1212: end if;

Line 1259: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

1255: l_msg_data varchar2(2000);
1256:
1257: begin
1258:
1259: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
1260:
1261: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.MAP_RBS_HEADERS(p_worker_id);')) then
1262: return;
1263: end if;

Line 1313: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

1309: l_creation_date := sysdate;
1310: l_created_by := FND_GLOBAL.USER_ID;
1311: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1312:
1313: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
1314:
1315: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM_FULL(p_worker_id);')) then
1316: return;
1317: end if;

Line 1482: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

1478: l_msg_code varchar2(255);
1479:
1480: begin
1481:
1482: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
1483:
1484: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.LOCK_HEADERS(p_worker_id);')) then
1485: return;
1486: end if;

Line 1534: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

1530: l_last_update_login number;
1531:
1532: begin
1533:
1534: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
1535:
1536: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_WBS(p_worker_id);')) then
1537: return;
1538: end if;

Line 1727: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

1723: l_extraction_type varchar2(30);
1724:
1725: begin
1726:
1727: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
1728:
1729: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.PURGE_EVENT_DATA(p_worker_id);')) then
1730: return;
1731: end if;

Line 1955: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

1951: l_last_update_login number;
1952:
1953: begin
1954:
1955: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
1956:
1957: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.UPDATE_PROGRAM_RBS(p_worker_id);')) then
1958: return;
1959: end if;

Line 2528: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

2524: begin
2525:
2526: if (p_worker_id is not null) then
2527:
2528: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
2529:
2530: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.POPULATE_XBS_DENORM_DELTA(p_worker_id);')) then
2531: return;
2532: end if;

Line 3105: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

3101: l_extraction_type varchar2(30);
3102:
3103: begin
3104:
3105: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
3106:
3107: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.POPULATE_RBS_DENORM_DELTA(p_worker_id);')) then
3108: return;
3109: end if;

Line 3227: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

3223:
3224:
3225: begin
3226:
3227: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
3228:
3229: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.AGGREGATE_FP_SLICES(p_worker_id);')) then
3230: return;
3231: end if;

Line 4374: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

4370:
4371:
4372: begin
4373:
4374: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
4375:
4376: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
4377:
4378: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_SLICES(p_worker_id);')) then

Line 5035: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

5031: l_err_msg VARCHAR2(100):= 'Error in PJI_PJP_SUM_ROLLUP.MARK_EXTRACTED_PROJECTS -> PJI_FM_PLAN_MAINT.POPULATE_FIN8';
5032:
5033: begin
5034:
5035: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
5036:
5037: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.MARK_EXTRACTED_PROJECTS(p_worker_id);')) then
5038: return;
5039: end if;

Line 5173: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

5169: l_workplan_type_id number;
5170:
5171: begin
5172:
5173: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
5174:
5175: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
5176: l_refresh_code := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER (l_process, 'REFRESH_CODE'); -- Bug#5099574
5177:

Line 5870: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

5866: l_refresh_code number; -- Bug#5099574
5867: l_plan_type_id number;
5868: begin
5869:
5870: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
5871:
5872: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.AGGREGATE_AC_CUST_SLICES(p_worker_id);')) then
5873: return;
5874: end if;

Line 7013: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

7009: l_msg_data varchar2(2000);
7010:
7011: begin
7012:
7013: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
7014:
7015: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.PULL_DANGLING_PLANS(p_worker_id);')) then
7016: return;
7017: end if;

Line 7055: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

7051: l_plan_type_id number;
7052:
7053: begin
7054:
7055: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
7056:
7057: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_PR(p_worker_id);')) then
7058: return;
7059: end if;

Line 7111: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

7107: l_rbs_version_id number;
7108:
7109: begin
7110:
7111: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
7112:
7113: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.PULL_PLANS_FOR_RBS(p_worker_id);')) then
7114: return;
7115: end if;

Line 7155: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

7151: l_extraction_type varchar2(30);
7152:
7153: begin
7154:
7155: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
7156:
7157: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_TOP(p_worker_id);')) then
7158: return;
7159: end if;

Line 7577: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

7573: begin
7574:
7575: if (p_worker_id is not null) then
7576:
7577: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
7578:
7579: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);')) then
7580: return;
7581: end if;

Line 11111: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

11107: begin
11108:
11109: if (p_worker_id is not null) then
11110:
11111: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
11112:
11113: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_SMART_SLICES(p_worker_id);')) then
11114: return;
11115: end if;

Line 12050: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

12046: begin
12047:
12048: if (p_worker_id is not null) then
12049:
12050: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
12051:
12052: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_WBS(p_worker_id);')) then
12053: return;
12054: end if;

Line 13385: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

13381: l_count number;
13382:
13383: begin
13384:
13385: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
13386:
13387: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_PRG(p_worker_id);')) then
13388: return;
13389: end if;

Line 14623: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

14619: l_count number;
14620:
14621: begin
14622:
14623: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
14624:
14625: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_PRG(p_worker_id);')) then
14626: return;
14627: end if;

Line 15158: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

15154: l_msg_data varchar2(2000);
15155:
15156: begin
15157:
15158: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
15159:
15160: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_NONTP(p_worker_id);')) then
15161: return;
15162: end if;

Line 15197: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

15193: l_msg_data varchar2(2000);
15194:
15195: begin
15196:
15197: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
15198:
15199: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_PA(p_worker_id);')) then
15200: return;
15201: end if;

Line 15236: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

15232: l_msg_data varchar2(2000);
15233:
15234: begin
15235:
15236: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
15237:
15238: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_GL(p_worker_id);')) then
15239: return;
15240: end if;

Line 15275: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

15271: l_msg_data varchar2(2000);
15272:
15273: begin
15274:
15275: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
15276:
15277: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_EN(p_worker_id);')) then
15278: return;
15279: end if;

Line 15314: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

15310: l_msg_data varchar2(2000);
15311:
15312: begin
15313:
15314: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
15315:
15316: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_CAL_ALL(p_worker_id);')) then
15317: return;
15318: end if;

Line 15353: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

15349: l_msg_data varchar2(2000);
15350:
15351: begin
15352:
15353: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
15354:
15355: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_PA(p_worker_id);')) then
15356: return;
15357: end if;

Line 15390: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

15386: l_msg_data varchar2(2000);
15387:
15388: begin
15389:
15390: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
15391:
15392: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_GL(p_worker_id);')) then
15393: return;
15394: end if;

Line 15427: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

15423: l_msg_data varchar2(2000);
15424:
15425: begin
15426:
15427: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
15428:
15429: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_EN(p_worker_id);')) then
15430: return;
15431: end if;

Line 15464: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

15460: l_msg_data varchar2(2000);
15461:
15462: begin
15463:
15464: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
15465:
15466: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.ROLLUP_ACR_CAL_ALL(p_worker_id);')) then
15467: return;
15468: end if;

Line 15500: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

15496: l_extraction_type varchar2(30);
15497:
15498: begin
15499:
15500: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
15501:
15502: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.AGGREGATE_PLAN_DATA(p_worker_id);')) then
15503: return;
15504: end if;

Line 15949: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

15945: l_extraction_type varchar2(30);
15946:
15947: begin
15948:
15949: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
15950:
15951: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.PURGE_PLAN_DATA(p_worker_id);')) then
15952: return;
15953: end if;

Line 16000: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

15996: l_msg_data varchar2(2000);
15997:
15998: begin
15999:
16000: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
16001:
16002: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.GET_FPR_ROWIDS(p_worker_id);')) then
16003: return;
16004: end if;

Line 16039: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

16035: l_msg_data varchar2(2000);
16036:
16037: begin
16038:
16039: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
16040:
16041: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.UPDATE_FPR_ROWS(p_worker_id);')) then
16042: return;
16043: end if;

Line 16078: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

16074: l_msg_data varchar2(2000);
16075:
16076: begin
16077:
16078: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
16079:
16080: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.INSERT_FPR_ROWS(p_worker_id);')) then
16081: return;
16082: end if;

Line 16117: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

16113: l_msg_data varchar2(2000);
16114:
16115: begin
16116:
16117: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
16118:
16119: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.CLEANUP_FPR_ROWID_TABLE(p_worker_id);')) then
16120: return;
16121: end if;

Line 16154: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

16150: l_msg_data varchar2(2000);
16151:
16152: begin
16153:
16154: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
16155:
16156: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.GET_ACR_ROWIDS(p_worker_id);')) then
16157: return;
16158: end if;

Line 16197: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

16193: l_msg_data varchar2(2000);
16194:
16195: begin
16196:
16197: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
16198:
16199: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.UPDATE_ACR_ROWS(p_worker_id);')) then
16200: return;
16201: end if;

Line 16240: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

16236: l_msg_data varchar2(2000);
16237:
16238: begin
16239:
16240: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
16241:
16242: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.INSERT_ACR_ROWS(p_worker_id);')) then
16243: return;
16244: end if;

Line 16287: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

16283: l_msg_data varchar2(2000);
16284:
16285: begin
16286:
16287: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
16288:
16289: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.CLEANUP_ACR_ROWID_TABLE(p_worker_id);')) then
16290: return;
16291: end if;

Line 16343: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

16339: l_last_update_login := FND_GLOBAL.LOGIN_ID;
16340:
16341: if (p_worker_id is not null) then
16342:
16343: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
16344:
16345: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.UPDATE_XBS_DENORM(p_worker_id);')) then
16346: return;
16347: end if;

Line 16829: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

16825: l_fpm_upgrade := PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE');
16826:
16827: if (p_worker_id is not null) then
16828:
16829: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
16830:
16831: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.UPDATE_RBS_DENORM(p_worker_id);')) then
16832: return;
16833: end if;

Line 17072: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

17068: l_msg_data varchar2(2000);
17069:
17070: begin
17071:
17072: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
17073:
17074: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_EVENTS(p_worker_id);')) then
17075: return;
17076: end if;

Line 17114: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

17110: l_msg_data varchar2(2000);
17111:
17112: begin
17113:
17114: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
17115:
17116: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_PLAN_UPDATES(p_worker_id);')) then
17117: return;
17118: end if;

Line 17172: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

17168: l_err_msg2 VARCHAR2(100):= 'Error in PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS -> PJI_FM_PLAN_MAINT.GET_ACTUALS_SUMM';
17169:
17170: begin
17171:
17172: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
17173: l_ret_status := FND_API.G_RET_STS_SUCCESS;
17174:
17175: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.GET_PLANRES_ACTUALS(p_worker_id);')) then
17176: return;

Line 17330: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

17326:
17327: begin
17328:
17329:
17330: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
17331:
17332: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.GET_TASK_ROLLUP_ACTUALS(p_worker_id);')) then
17333: return;
17334: end if;

Line 17414: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

17410: l_msg_code varchar2(255);
17411:
17412: begin
17413:
17414: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
17415:
17416: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.UNLOCK_ALL_HEADERS(p_worker_id);')) then
17417: return;
17418: end if;

Line 17473: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

17469: l_msg_data varchar2(2000);
17470:
17471: begin
17472:
17473: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
17474:
17475: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.EXTRACT_FIN_PLAN_VERS_BULK(p_worker_id);')) then
17476: return;
17477: end if;

Line 17510: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

17506: l_msg_data varchar2(2000);
17507:
17508: begin
17509:
17510: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
17511:
17512: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.POPULATE_WBS_HDR(p_worker_id);')) then
17513: return;
17514: end if;

Line 17547: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

17543: l_msg_data varchar2(2000);
17544:
17545: begin
17546:
17547: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
17548:
17549: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.UPDATE_WBS_HDR(p_worker_id);')) then
17550: return;
17551: end if;

Line 17585: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

17581: l_msg_data varchar2(2000);
17582:
17583: begin
17584:
17585: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
17586:
17587: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.POPULATE_RBS_HDR(p_worker_id);')) then
17588: return;
17589: end if;

Line 17622: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

17618: l_msg_data varchar2(2000);
17619:
17620: begin
17621:
17622: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
17623:
17624: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.EXTRACT_PLAN_AMOUNTS_PRIRBS(p_worker_id);')) then
17625: return;
17626: end if;

Line 17659: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

17655: l_msg_data varchar2(2000);
17656:
17657: begin
17658:
17659: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
17660:
17661: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_RBS_T_SLICE(p_worker_id);')) then
17662: return;
17663: end if;

Line 17696: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

17692: l_msg_data varchar2(2000);
17693:
17694: begin
17695:
17696: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
17697:
17698: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.CREATE_FP_PA_PRI_ROLLUP(p_worker_id);')) then
17699: return;
17700: end if;

Line 17733: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

17729: l_msg_data varchar2(2000);
17730:
17731: begin
17732:
17733: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
17734:
17735: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.CREATE_FP_GL_PRI_ROLLUP(p_worker_id);')) then
17736: return;
17737: end if;

Line 17770: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

17766: l_msg_data varchar2(2000);
17767:
17768: begin
17769:
17770: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
17771:
17772: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.CREATE_FP_ALL_PRI_ROLLUP(p_worker_id);')) then
17773: return;
17774: end if;

Line 17809: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

17805: l_msg_data varchar2(2000);
17806:
17807: begin
17808:
17809: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
17810:
17811: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.INSERT_INTO_FP_FACT(p_worker_id);')) then
17812: return;
17813: end if;

Line 17846: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

17842: l_msg_data varchar2(2000);
17843:
17844: begin
17845:
17846: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
17847:
17848: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.MARK_EXTRACTED_PLANS(p_worker_id);')) then
17849: return;
17850: end if;

Line 17874: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

17870: l_msg_data varchar2(2000);
17871:
17872: begin
17873:
17874: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
17875:
17876: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.REMAP_RBS_TXN_ACCUM_HDRS(p_worker_id);')) then
17877: return;
17878: end if;

Line 17907: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

17903: l_msg_data varchar2(2000);
17904:
17905: begin
17906:
17907: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
17908:
17909: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.RETRIEVE_OVERRIDDEN_WP_ETC(p_worker_id);')) then
17910: return;
17911: end if;

Line 17937: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

17933: l_msg_data varchar2(2000);
17934:
17935: begin
17936:
17937: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
17938:
17939: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.EXTRACT_PLAN_ETC_PRIRBS(p_worker_id);')) then
17940: return;
17941: end if;

Line 17974: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

17970: begin
17971:
17972: if (p_worker_id is not null) then
17973:
17974: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
17975:
17976: /* 5755229 Because No step entry in the delete process FPM Upgrade
17977: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.CLEANUP(p_worker_id);')) then -- Bug#5171542
17978: return;

Line 18090: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

18086: l_msg_data varchar2(2000);
18087:
18088: begin
18089:
18090: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
18091:
18092: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.MERGE_INTO_FP_FACT(p_worker_id);')) then
18093: return;
18094: end if;