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_EXTR dependencies on PJI_FM_SUM_EXTR

Line 1: package body PJI_FM_SUM_EXTR as

1: package body PJI_FM_SUM_EXTR as
2: /* $Header: PJISF02B.pls 120.21.12020000.4 2013/03/28 13:46:18 krkondur ship $ */
3:
4: -- -----------------------------------------------------
5: -- procedure POPULATE_TIME_DIMENSION

Line 19: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.POPULATE_TIME_DIMENSION(p_worker_id);')) then

15: begin
16:
17: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
18:
19: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.POPULATE_TIME_DIMENSION(p_worker_id);')) then
20: return;
21: end if;
22:
23: PJI_TIME_C.LOAD(null, null, l_return_status, l_msg_count, l_msg_data);

Line 25: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.POPULATE_TIME_DIMENSION(p_worker_id);');

21: end if;
22:
23: PJI_TIME_C.LOAD(null, null, l_return_status, l_msg_count, l_msg_data);
24:
25: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.POPULATE_TIME_DIMENSION(p_worker_id);');
26:
27: commit;
28:
29: end POPULATE_TIME_DIMENSION;

Line 43: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.ORG_EXTR_INFO_TABLE(p_worker_id);')) then

39: begin
40:
41: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
42:
43: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.ORG_EXTR_INFO_TABLE(p_worker_id);')) then
44: return;
45: end if;
46:
47: PJI_EXTRACTION_UTIL.UPDATE_ORG_EXTR_INFO;

Line 49: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.ORG_EXTR_INFO_TABLE(p_worker_id);');

45: end if;
46:
47: PJI_EXTRACTION_UTIL.UPDATE_ORG_EXTR_INFO;
48:
49: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.ORG_EXTR_INFO_TABLE(p_worker_id);');
50:
51: -- implicit commit
52: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
53: tabname => 'PJI_ORG_EXTR_INFO',

Line 79: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.CURR_CONV_TABLE(p_worker_id);')) then

75: begin
76:
77: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
78:
79: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.CURR_CONV_TABLE(p_worker_id);')) then
80: return;
81: end if;
82:
83: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 364: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.CURR_CONV_TABLE(p_worker_id);');

360: tmp.PF_CURRENCY_CODE = rates.PF_CURRENCY_CODE (+) and
361: tmp.TIME_ID = rates.TIME_ID (+) and
362: rates.WORKER_ID is null;
363:
364: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.CURR_CONV_TABLE(p_worker_id);');
365:
366: commit;
367:
368: end CURR_CONV_TABLE;

Line 387: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.DANGLING_FIN_ROWS(p_worker_id);')) then

383: begin
384:
385: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
386:
387: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.DANGLING_FIN_ROWS(p_worker_id);')) then
388: return;
389: end if;
390:
391: select

Line 1806: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.DANGLING_FIN_ROWS(p_worker_id);');

1802: tmp2.RECVR_PA_TIME_ID = prj_pa_rt.TIME_ID and
1803: prj_info.PF_CURRENCY_CODE = prj_pa_rt.PF_CURRENCY_CODE
1804: ) tmp2;
1805:
1806: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.DANGLING_FIN_ROWS(p_worker_id);');
1807:
1808: commit;
1809:
1810: end DANGLING_FIN_ROWS;

Line 1829: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.DANGLING_ACT_ROWS(p_worker_id);')) then

1825: begin
1826:
1827: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
1828:
1829: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.DANGLING_ACT_ROWS(p_worker_id);')) then
1830: return;
1831: end if;
1832:
1833: select

Line 3178: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.DANGLING_ACT_ROWS(p_worker_id);');

3174: tmp2.PA_TIME_ID = pa_rt.TIME_ID and
3175: prj_info.PF_CURRENCY_CODE = pa_rt.PF_CURRENCY_CODE
3176: ) tmp2;
3177:
3178: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.DANGLING_ACT_ROWS(p_worker_id);');
3179:
3180: commit;
3181:
3182: end DANGLING_ACT_ROWS;

Line 3196: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.PURGE_DANGLING_FIN_ROWS(p_worker_id);')) then

3192: begin
3193:
3194: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
3195:
3196: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.PURGE_DANGLING_FIN_ROWS(p_worker_id);')) then
3197: return;
3198: end if;
3199:
3200: /* delete /*+ parallel(fin)

Line 3214: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.PURGE_DANGLING_FIN_ROWS(p_worker_id);');

3210:
3211: delete from PJI_FM_DNGL_FIN where worker_id = 0 and ROWID in (select row_id from PJI_FM_AGGR_FIN2 where worker_id = p_worker_id);
3212: -- End for Bug# 7357456
3213:
3214: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.PURGE_DANGLING_FIN_ROWS(p_worker_id);');
3215:
3216: commit;
3217:
3218: end PURGE_DANGLING_FIN_ROWS;

Line 3232: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.PURGE_DANGLING_ACT_ROWS(p_worker_id);')) then

3228: begin
3229:
3230: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
3231:
3232: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.PURGE_DANGLING_ACT_ROWS(p_worker_id);')) then
3233: return;
3234: end if;
3235:
3236: delete /*+ parallel(act) */

Line 3243: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.PURGE_DANGLING_ACT_ROWS(p_worker_id);');

3239: ROWID in (select ROW_ID
3240: from PJI_FM_AGGR_ACT2
3241: where WORKER_ID = p_worker_id);
3242:
3243: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.PURGE_DANGLING_ACT_ROWS(p_worker_id);');
3244:
3245: commit;
3246:
3247: end PURGE_DANGLING_ACT_ROWS;

Line 3270: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.FIN_SUMMARY(p_worker_id);')) then

3266: begin
3267:
3268: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
3269:
3270: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.FIN_SUMMARY(p_worker_id);')) then
3271: return;
3272: end if;
3273:
3274: l_transition_flag :=

Line 4344: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.FIN_SUMMARY(p_worker_id);');

4340: tmp1.RECVR_PA_TIME_ID = prj_pa_rt.TIME_ID and
4341: prj_info.PF_CURRENCY_CODE = prj_pa_rt.PF_CURRENCY_CODE
4342: ) tmp1;
4343:
4344: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.FIN_SUMMARY(p_worker_id);');
4345:
4346: -- truncate intermediate tables no longer required
4347: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
4348: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_AGGR_FIN1' , 'NORMAL',null);

Line 4366: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.MOVE_DANGLING_FIN_ROWS(p_worker_id);')) then

4362: begin
4363:
4364: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
4365:
4366: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.MOVE_DANGLING_FIN_ROWS(p_worker_id);')) then
4367: return;
4368: end if;
4369:
4370: insert into PJI_FM_DNGL_FIN

Line 4679: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.MOVE_DANGLING_FIN_ROWS(p_worker_id);');

4675: DANGLING_PRVDR_PA_TIME_FLAG is not null or
4676: DANGLING_RECVR_PA_TIME_FLAG is not null or
4677: DANGLING_EXP_PA_TIME_FLAG is not null);
4678:
4679: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.MOVE_DANGLING_FIN_ROWS(p_worker_id);');
4680:
4681: commit;
4682:
4683: end MOVE_DANGLING_FIN_ROWS;

Line 4704: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.ACT_SUMMARY(p_worker_id);')) then

4700: begin
4701:
4702: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
4703:
4704: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.ACT_SUMMARY(p_worker_id);')) then
4705: return;
4706: end if;
4707:
4708: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

Line 5705: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.ACT_SUMMARY(p_worker_id);');

5701: delete
5702: from PJI_FM_AGGR_DLY_RATES
5703: where WORKER_ID = -1;
5704:
5705: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.ACT_SUMMARY(p_worker_id);');
5706:
5707: -- truncate intermediate tables no longer required
5708: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
5709: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_AGGR_ACT1' , 'NORMAL',null);

Line 5727: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.MOVE_DANGLING_ACT_ROWS(p_worker_id);')) then

5723: begin
5724:
5725: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
5726:
5727: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.MOVE_DANGLING_ACT_ROWS(p_worker_id);')) then
5728: return;
5729: end if;
5730:
5731: insert into PJI_FM_DNGL_ACT

Line 6058: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.MOVE_DANGLING_ACT_ROWS(p_worker_id);');

6054: DANGLING_EN_TIME_FLAG is not null or
6055: DANGLING_GL_TIME_FLAG is not null or
6056: DANGLING_PA_TIME_FLAG is not null);
6057:
6058: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.MOVE_DANGLING_ACT_ROWS(p_worker_id);');
6059:
6060: commit;
6061:
6062: end MOVE_DANGLING_ACT_ROWS;

Line 6077: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.AGGREGATE_RES_SLICES(p_worker_id);')) then

6073: begin
6074:
6075: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
6076:
6077: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.AGGREGATE_RES_SLICES(p_worker_id);')) then
6078: return;
6079: end if;
6080:
6081: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

Line 6142: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.AGGREGATE_RES_SLICES(p_worker_id);');

6138: EXPENDITURE_ITEM_TIME_ID,
6139: RS_GL_CALENDAR_ID,
6140: RS_PA_CALENDAR_ID;
6141:
6142: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.AGGREGATE_RES_SLICES(p_worker_id);');
6143:
6144: commit;
6145:
6146: end AGGREGATE_RES_SLICES;

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

6157: begin
6158:
6159: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
6160:
6161: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.AGGREGATE_FIN_SLICES(p_worker_id);')) then
6162: return;
6163: end if;
6164:
6165: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

Line 6776: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.AGGREGATE_FIN_SLICES(p_worker_id);');

6772: end if;
6773: /* Added for bug 9249905
6774: Commented for bug 13011859 */
6775:
6776: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.AGGREGATE_FIN_SLICES(p_worker_id);');
6777:
6778: commit;
6779:
6780: end AGGREGATE_FIN_SLICES;

Line 6797: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.AGGREGATE_ACT_SLICES(p_worker_id);')) then

6793: begin
6794:
6795: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
6796:
6797: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.AGGREGATE_ACT_SLICES(p_worker_id);')) then
6798: return;
6799: end if;
6800:
6801: l_pa_calendar_flag := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

Line 7366: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.AGGREGATE_ACT_SLICES(p_worker_id);');

7362: tmp2.GL_CALENDAR_ID,
7363: tmp2.PA_CALENDAR_ID,
7364: tmp2.TXN_CURRENCY_CODE; Commented for bug 13011859*/
7365:
7366: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.AGGREGATE_ACT_SLICES(p_worker_id);');
7367:
7368: -- truncate intermediate tables no longer required
7369: -- l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
7370: -- PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_AGGR_ACT2' , 'NORMAL',null);

Line 7417: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.FORCE_SUBSEQUENT_RUN(p_worker_id);')) then

7413: begin
7414:
7415: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
7416:
7417: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.FORCE_SUBSEQUENT_RUN(p_worker_id);')) then
7418: return;
7419: end if;
7420:
7421: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

Line 7617: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.FORCE_SUBSEQUENT_RUN(p_worker_id);');

7613: */
7614:
7615: end if;
7616:
7617: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.FORCE_SUBSEQUENT_RUN(p_worker_id);');
7618:
7619: commit;
7620:
7621: end FORCE_SUBSEQUENT_RUN;

Line 7706: PJI_FM_SUM_EXTR.POPULATE_TIME_DIMENSION(p_worker_id);

7702: PJI_EXTRACTION_UTIL.SEED_PJI_FM_STATS;
7703:
7704: PJI_PROCESS_UTIL.CLEAN_HELPER_BATCH_TABLE;
7705:
7706: PJI_FM_SUM_EXTR.POPULATE_TIME_DIMENSION(p_worker_id);
7707: PJI_EXTRACTION_UTIL.POPULATE_ORG_EXTR_INFO;
7708:
7709: PJI_FM_EXTR.EXTRACT_BATCH_DREV(p_worker_id);
7710:

Line 7773: PJI_FM_SUM_EXTR.ORG_EXTR_INFO_TABLE(p_worker_id);

7769: return;
7770: end if;
7771: PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_POST(p_worker_id);
7772:
7773: PJI_FM_SUM_EXTR.ORG_EXTR_INFO_TABLE(p_worker_id);
7774: PJI_FM_SUM_EXTR.CURR_CONV_TABLE(p_worker_id);
7775:
7776: PJI_FM_SUM_EXTR.DANGLING_FIN_ROWS(p_worker_id);
7777: PJI_FM_SUM_EXTR.DANGLING_ACT_ROWS(p_worker_id);

Line 7774: PJI_FM_SUM_EXTR.CURR_CONV_TABLE(p_worker_id);

7770: end if;
7771: PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_POST(p_worker_id);
7772:
7773: PJI_FM_SUM_EXTR.ORG_EXTR_INFO_TABLE(p_worker_id);
7774: PJI_FM_SUM_EXTR.CURR_CONV_TABLE(p_worker_id);
7775:
7776: PJI_FM_SUM_EXTR.DANGLING_FIN_ROWS(p_worker_id);
7777: PJI_FM_SUM_EXTR.DANGLING_ACT_ROWS(p_worker_id);
7778: PJI_FM_SUM_EXTR.PURGE_DANGLING_FIN_ROWS(p_worker_id);

Line 7776: PJI_FM_SUM_EXTR.DANGLING_FIN_ROWS(p_worker_id);

7772:
7773: PJI_FM_SUM_EXTR.ORG_EXTR_INFO_TABLE(p_worker_id);
7774: PJI_FM_SUM_EXTR.CURR_CONV_TABLE(p_worker_id);
7775:
7776: PJI_FM_SUM_EXTR.DANGLING_FIN_ROWS(p_worker_id);
7777: PJI_FM_SUM_EXTR.DANGLING_ACT_ROWS(p_worker_id);
7778: PJI_FM_SUM_EXTR.PURGE_DANGLING_FIN_ROWS(p_worker_id);
7779: PJI_FM_SUM_EXTR.PURGE_DANGLING_ACT_ROWS(p_worker_id);
7780:

Line 7777: PJI_FM_SUM_EXTR.DANGLING_ACT_ROWS(p_worker_id);

7773: PJI_FM_SUM_EXTR.ORG_EXTR_INFO_TABLE(p_worker_id);
7774: PJI_FM_SUM_EXTR.CURR_CONV_TABLE(p_worker_id);
7775:
7776: PJI_FM_SUM_EXTR.DANGLING_FIN_ROWS(p_worker_id);
7777: PJI_FM_SUM_EXTR.DANGLING_ACT_ROWS(p_worker_id);
7778: PJI_FM_SUM_EXTR.PURGE_DANGLING_FIN_ROWS(p_worker_id);
7779: PJI_FM_SUM_EXTR.PURGE_DANGLING_ACT_ROWS(p_worker_id);
7780:
7781: PJI_FM_CMT_EXTR.FIN_CMT_SUMMARY(p_worker_id);

Line 7778: PJI_FM_SUM_EXTR.PURGE_DANGLING_FIN_ROWS(p_worker_id);

7774: PJI_FM_SUM_EXTR.CURR_CONV_TABLE(p_worker_id);
7775:
7776: PJI_FM_SUM_EXTR.DANGLING_FIN_ROWS(p_worker_id);
7777: PJI_FM_SUM_EXTR.DANGLING_ACT_ROWS(p_worker_id);
7778: PJI_FM_SUM_EXTR.PURGE_DANGLING_FIN_ROWS(p_worker_id);
7779: PJI_FM_SUM_EXTR.PURGE_DANGLING_ACT_ROWS(p_worker_id);
7780:
7781: PJI_FM_CMT_EXTR.FIN_CMT_SUMMARY(p_worker_id);
7782:

Line 7779: PJI_FM_SUM_EXTR.PURGE_DANGLING_ACT_ROWS(p_worker_id);

7775:
7776: PJI_FM_SUM_EXTR.DANGLING_FIN_ROWS(p_worker_id);
7777: PJI_FM_SUM_EXTR.DANGLING_ACT_ROWS(p_worker_id);
7778: PJI_FM_SUM_EXTR.PURGE_DANGLING_FIN_ROWS(p_worker_id);
7779: PJI_FM_SUM_EXTR.PURGE_DANGLING_ACT_ROWS(p_worker_id);
7780:
7781: PJI_FM_CMT_EXTR.FIN_CMT_SUMMARY(p_worker_id);
7782:
7783: PJI_FM_SUM_EXTR.FIN_SUMMARY(p_worker_id);

Line 7783: PJI_FM_SUM_EXTR.FIN_SUMMARY(p_worker_id);

7779: PJI_FM_SUM_EXTR.PURGE_DANGLING_ACT_ROWS(p_worker_id);
7780:
7781: PJI_FM_CMT_EXTR.FIN_CMT_SUMMARY(p_worker_id);
7782:
7783: PJI_FM_SUM_EXTR.FIN_SUMMARY(p_worker_id);
7784: PJI_FM_SUM_EXTR.MOVE_DANGLING_FIN_ROWS(p_worker_id);
7785:
7786: PJI_FM_SUM_EXTR.ACT_SUMMARY(p_worker_id);
7787: PJI_FM_SUM_EXTR.MOVE_DANGLING_ACT_ROWS(p_worker_id);

Line 7784: PJI_FM_SUM_EXTR.MOVE_DANGLING_FIN_ROWS(p_worker_id);

7780:
7781: PJI_FM_CMT_EXTR.FIN_CMT_SUMMARY(p_worker_id);
7782:
7783: PJI_FM_SUM_EXTR.FIN_SUMMARY(p_worker_id);
7784: PJI_FM_SUM_EXTR.MOVE_DANGLING_FIN_ROWS(p_worker_id);
7785:
7786: PJI_FM_SUM_EXTR.ACT_SUMMARY(p_worker_id);
7787: PJI_FM_SUM_EXTR.MOVE_DANGLING_ACT_ROWS(p_worker_id);
7788:

Line 7786: PJI_FM_SUM_EXTR.ACT_SUMMARY(p_worker_id);

7782:
7783: PJI_FM_SUM_EXTR.FIN_SUMMARY(p_worker_id);
7784: PJI_FM_SUM_EXTR.MOVE_DANGLING_FIN_ROWS(p_worker_id);
7785:
7786: PJI_FM_SUM_EXTR.ACT_SUMMARY(p_worker_id);
7787: PJI_FM_SUM_EXTR.MOVE_DANGLING_ACT_ROWS(p_worker_id);
7788:
7789: PJI_FM_SUM_PSI.RESOURCE_LOOKUP_TABLE(p_worker_id);
7790:

Line 7787: PJI_FM_SUM_EXTR.MOVE_DANGLING_ACT_ROWS(p_worker_id);

7783: PJI_FM_SUM_EXTR.FIN_SUMMARY(p_worker_id);
7784: PJI_FM_SUM_EXTR.MOVE_DANGLING_FIN_ROWS(p_worker_id);
7785:
7786: PJI_FM_SUM_EXTR.ACT_SUMMARY(p_worker_id);
7787: PJI_FM_SUM_EXTR.MOVE_DANGLING_ACT_ROWS(p_worker_id);
7788:
7789: PJI_FM_SUM_PSI.RESOURCE_LOOKUP_TABLE(p_worker_id);
7790:
7791: PJI_FM_SUM_PSI.PURGE_FP_BALANCES(p_worker_id);

Line 7806: PJI_FM_SUM_EXTR.AGGREGATE_RES_SLICES(p_worker_id);

7802: PJI_FM_SUM_PSI.BALANCES_INCR_NEW_PRJ_CMT(p_worker_id);
7803:
7804: PJI_FM_SUM_PSI.FORCE_SUBSEQUENT_RUN(p_worker_id);
7805:
7806: PJI_FM_SUM_EXTR.AGGREGATE_RES_SLICES(p_worker_id);
7807: PJI_FM_SUM_EXTR.AGGREGATE_FIN_SLICES(p_worker_id);
7808: PJI_FM_SUM_EXTR.AGGREGATE_ACT_SLICES(p_worker_id);
7809:
7810: PJI_FM_SUM_EXTR.FORCE_SUBSEQUENT_RUN(p_worker_id);

Line 7807: PJI_FM_SUM_EXTR.AGGREGATE_FIN_SLICES(p_worker_id);

7803:
7804: PJI_FM_SUM_PSI.FORCE_SUBSEQUENT_RUN(p_worker_id);
7805:
7806: PJI_FM_SUM_EXTR.AGGREGATE_RES_SLICES(p_worker_id);
7807: PJI_FM_SUM_EXTR.AGGREGATE_FIN_SLICES(p_worker_id);
7808: PJI_FM_SUM_EXTR.AGGREGATE_ACT_SLICES(p_worker_id);
7809:
7810: PJI_FM_SUM_EXTR.FORCE_SUBSEQUENT_RUN(p_worker_id);
7811:

Line 7808: PJI_FM_SUM_EXTR.AGGREGATE_ACT_SLICES(p_worker_id);

7804: PJI_FM_SUM_PSI.FORCE_SUBSEQUENT_RUN(p_worker_id);
7805:
7806: PJI_FM_SUM_EXTR.AGGREGATE_RES_SLICES(p_worker_id);
7807: PJI_FM_SUM_EXTR.AGGREGATE_FIN_SLICES(p_worker_id);
7808: PJI_FM_SUM_EXTR.AGGREGATE_ACT_SLICES(p_worker_id);
7809:
7810: PJI_FM_SUM_EXTR.FORCE_SUBSEQUENT_RUN(p_worker_id);
7811:
7812: CLEANUP_WORKER(p_worker_id);

Line 7810: PJI_FM_SUM_EXTR.FORCE_SUBSEQUENT_RUN(p_worker_id);

7806: PJI_FM_SUM_EXTR.AGGREGATE_RES_SLICES(p_worker_id);
7807: PJI_FM_SUM_EXTR.AGGREGATE_FIN_SLICES(p_worker_id);
7808: PJI_FM_SUM_EXTR.AGGREGATE_ACT_SLICES(p_worker_id);
7809:
7810: PJI_FM_SUM_EXTR.FORCE_SUBSEQUENT_RUN(p_worker_id);
7811:
7812: CLEANUP_WORKER(p_worker_id);
7813:
7814: end WORKER;

Line 8071: end PJI_FM_SUM_EXTR;

8067: PJI_FM_SUM_MAIN.g_process_delay);
8068:
8069: end WAIT_FOR_WORKER;
8070:
8071: end PJI_FM_SUM_EXTR;