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.9.12010000.4 2008/09/17 23:21:10 snizam 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 1803: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.DANGLING_FIN_ROWS(p_worker_id);');

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

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

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

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

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

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

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

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

3207:
3208: 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);
3209: -- End for Bug# 7357456
3210:
3211: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.PURGE_DANGLING_FIN_ROWS(p_worker_id);');
3212:
3213: commit;
3214:
3215: end PURGE_DANGLING_FIN_ROWS;

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

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

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

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

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

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

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

4332: tmp1.RECVR_PA_TIME_ID = prj_pa_rt.TIME_ID and
4333: prj_info.PF_CURRENCY_CODE = prj_pa_rt.PF_CURRENCY_CODE
4334: ) tmp1;
4335:
4336: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.FIN_SUMMARY(p_worker_id);');
4337:
4338: -- truncate intermediate tables no longer required
4339: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
4340: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_AGGR_FIN1' , 'NORMAL',null);

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

4354: begin
4355:
4356: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
4357:
4358: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.MOVE_DANGLING_FIN_ROWS(p_worker_id);')) then
4359: return;
4360: end if;
4361:
4362: insert into PJI_FM_DNGL_FIN

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

4665: DANGLING_PRVDR_PA_TIME_FLAG is not null or
4666: DANGLING_RECVR_PA_TIME_FLAG is not null or
4667: DANGLING_EXP_PA_TIME_FLAG is not null);
4668:
4669: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.MOVE_DANGLING_FIN_ROWS(p_worker_id);');
4670:
4671: commit;
4672:
4673: end MOVE_DANGLING_FIN_ROWS;

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

4690: begin
4691:
4692: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
4693:
4694: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.ACT_SUMMARY(p_worker_id);')) then
4695: return;
4696: end if;
4697:
4698: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

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

5691: delete
5692: from PJI_FM_AGGR_DLY_RATES
5693: where WORKER_ID = -1;
5694:
5695: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.ACT_SUMMARY(p_worker_id);');
5696:
5697: -- truncate intermediate tables no longer required
5698: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
5699: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_AGGR_ACT1' , 'NORMAL',null);

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

5713: begin
5714:
5715: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
5716:
5717: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.MOVE_DANGLING_ACT_ROWS(p_worker_id);')) then
5718: return;
5719: end if;
5720:
5721: insert into PJI_FM_DNGL_ACT

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

6044: DANGLING_EN_TIME_FLAG is not null or
6045: DANGLING_GL_TIME_FLAG is not null or
6046: DANGLING_PA_TIME_FLAG is not null);
6047:
6048: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.MOVE_DANGLING_ACT_ROWS(p_worker_id);');
6049:
6050: commit;
6051:
6052: end MOVE_DANGLING_ACT_ROWS;

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

6063: begin
6064:
6065: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
6066:
6067: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.AGGREGATE_RES_SLICES(p_worker_id);')) then
6068: return;
6069: end if;
6070:
6071: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

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

6128: EXPENDITURE_ITEM_TIME_ID,
6129: RS_GL_CALENDAR_ID,
6130: RS_PA_CALENDAR_ID;
6131:
6132: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.AGGREGATE_RES_SLICES(p_worker_id);');
6133:
6134: commit;
6135:
6136: end AGGREGATE_RES_SLICES;

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

6147: begin
6148:
6149: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
6150:
6151: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.AGGREGATE_FIN_SLICES(p_worker_id);')) then
6152: return;
6153: end if;
6154:
6155: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

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

6392: tmp2.PJ_GL_CALENDAR_ID,
6393: tmp2.PJ_PA_CALENDAR_ID,
6394: tmp2.TXN_CURRENCY_CODE;
6395:
6396: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.AGGREGATE_FIN_SLICES(p_worker_id);');
6397:
6398: commit;
6399:
6400: end AGGREGATE_FIN_SLICES;

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

6413: begin
6414:
6415: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
6416:
6417: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.AGGREGATE_ACT_SLICES(p_worker_id);')) then
6418: return;
6419: end if;
6420:
6421: l_pa_calendar_flag := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

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

6982: tmp2.GL_CALENDAR_ID,
6983: tmp2.PA_CALENDAR_ID,
6984: tmp2.TXN_CURRENCY_CODE;
6985:
6986: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.AGGREGATE_ACT_SLICES(p_worker_id);');
6987:
6988: -- truncate intermediate tables no longer required
6989: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
6990: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_AGGR_ACT2' , 'NORMAL',null);

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

7033: begin
7034:
7035: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
7036:
7037: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_EXTR.FORCE_SUBSEQUENT_RUN(p_worker_id);')) then
7038: return;
7039: end if;
7040:
7041: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

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

7233: */
7234:
7235: end if;
7236:
7237: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_EXTR.FORCE_SUBSEQUENT_RUN(p_worker_id);');
7238:
7239: commit;
7240:
7241: end FORCE_SUBSEQUENT_RUN;

Line 7326: PJI_FM_SUM_EXTR.POPULATE_TIME_DIMENSION(p_worker_id);

7322: PJI_EXTRACTION_UTIL.SEED_PJI_FM_STATS;
7323:
7324: PJI_PROCESS_UTIL.CLEAN_HELPER_BATCH_TABLE;
7325:
7326: PJI_FM_SUM_EXTR.POPULATE_TIME_DIMENSION(p_worker_id);
7327: PJI_EXTRACTION_UTIL.POPULATE_ORG_EXTR_INFO;
7328:
7329: PJI_FM_EXTR.EXTRACT_BATCH_DREV(p_worker_id);
7330:

Line 7393: PJI_FM_SUM_EXTR.ORG_EXTR_INFO_TABLE(p_worker_id);

7389: return;
7390: end if;
7391: PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_POST(p_worker_id);
7392:
7393: PJI_FM_SUM_EXTR.ORG_EXTR_INFO_TABLE(p_worker_id);
7394: PJI_FM_SUM_EXTR.CURR_CONV_TABLE(p_worker_id);
7395:
7396: PJI_FM_SUM_EXTR.DANGLING_FIN_ROWS(p_worker_id);
7397: PJI_FM_SUM_EXTR.DANGLING_ACT_ROWS(p_worker_id);

Line 7394: PJI_FM_SUM_EXTR.CURR_CONV_TABLE(p_worker_id);

7390: end if;
7391: PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_POST(p_worker_id);
7392:
7393: PJI_FM_SUM_EXTR.ORG_EXTR_INFO_TABLE(p_worker_id);
7394: PJI_FM_SUM_EXTR.CURR_CONV_TABLE(p_worker_id);
7395:
7396: PJI_FM_SUM_EXTR.DANGLING_FIN_ROWS(p_worker_id);
7397: PJI_FM_SUM_EXTR.DANGLING_ACT_ROWS(p_worker_id);
7398: PJI_FM_SUM_EXTR.PURGE_DANGLING_FIN_ROWS(p_worker_id);

Line 7396: PJI_FM_SUM_EXTR.DANGLING_FIN_ROWS(p_worker_id);

7392:
7393: PJI_FM_SUM_EXTR.ORG_EXTR_INFO_TABLE(p_worker_id);
7394: PJI_FM_SUM_EXTR.CURR_CONV_TABLE(p_worker_id);
7395:
7396: PJI_FM_SUM_EXTR.DANGLING_FIN_ROWS(p_worker_id);
7397: PJI_FM_SUM_EXTR.DANGLING_ACT_ROWS(p_worker_id);
7398: PJI_FM_SUM_EXTR.PURGE_DANGLING_FIN_ROWS(p_worker_id);
7399: PJI_FM_SUM_EXTR.PURGE_DANGLING_ACT_ROWS(p_worker_id);
7400:

Line 7397: PJI_FM_SUM_EXTR.DANGLING_ACT_ROWS(p_worker_id);

7393: PJI_FM_SUM_EXTR.ORG_EXTR_INFO_TABLE(p_worker_id);
7394: PJI_FM_SUM_EXTR.CURR_CONV_TABLE(p_worker_id);
7395:
7396: PJI_FM_SUM_EXTR.DANGLING_FIN_ROWS(p_worker_id);
7397: PJI_FM_SUM_EXTR.DANGLING_ACT_ROWS(p_worker_id);
7398: PJI_FM_SUM_EXTR.PURGE_DANGLING_FIN_ROWS(p_worker_id);
7399: PJI_FM_SUM_EXTR.PURGE_DANGLING_ACT_ROWS(p_worker_id);
7400:
7401: PJI_FM_CMT_EXTR.FIN_CMT_SUMMARY(p_worker_id);

Line 7398: PJI_FM_SUM_EXTR.PURGE_DANGLING_FIN_ROWS(p_worker_id);

7394: PJI_FM_SUM_EXTR.CURR_CONV_TABLE(p_worker_id);
7395:
7396: PJI_FM_SUM_EXTR.DANGLING_FIN_ROWS(p_worker_id);
7397: PJI_FM_SUM_EXTR.DANGLING_ACT_ROWS(p_worker_id);
7398: PJI_FM_SUM_EXTR.PURGE_DANGLING_FIN_ROWS(p_worker_id);
7399: PJI_FM_SUM_EXTR.PURGE_DANGLING_ACT_ROWS(p_worker_id);
7400:
7401: PJI_FM_CMT_EXTR.FIN_CMT_SUMMARY(p_worker_id);
7402:

Line 7399: PJI_FM_SUM_EXTR.PURGE_DANGLING_ACT_ROWS(p_worker_id);

7395:
7396: PJI_FM_SUM_EXTR.DANGLING_FIN_ROWS(p_worker_id);
7397: PJI_FM_SUM_EXTR.DANGLING_ACT_ROWS(p_worker_id);
7398: PJI_FM_SUM_EXTR.PURGE_DANGLING_FIN_ROWS(p_worker_id);
7399: PJI_FM_SUM_EXTR.PURGE_DANGLING_ACT_ROWS(p_worker_id);
7400:
7401: PJI_FM_CMT_EXTR.FIN_CMT_SUMMARY(p_worker_id);
7402:
7403: PJI_FM_SUM_EXTR.FIN_SUMMARY(p_worker_id);

Line 7403: PJI_FM_SUM_EXTR.FIN_SUMMARY(p_worker_id);

7399: PJI_FM_SUM_EXTR.PURGE_DANGLING_ACT_ROWS(p_worker_id);
7400:
7401: PJI_FM_CMT_EXTR.FIN_CMT_SUMMARY(p_worker_id);
7402:
7403: PJI_FM_SUM_EXTR.FIN_SUMMARY(p_worker_id);
7404: PJI_FM_SUM_EXTR.MOVE_DANGLING_FIN_ROWS(p_worker_id);
7405:
7406: PJI_FM_SUM_EXTR.ACT_SUMMARY(p_worker_id);
7407: PJI_FM_SUM_EXTR.MOVE_DANGLING_ACT_ROWS(p_worker_id);

Line 7404: PJI_FM_SUM_EXTR.MOVE_DANGLING_FIN_ROWS(p_worker_id);

7400:
7401: PJI_FM_CMT_EXTR.FIN_CMT_SUMMARY(p_worker_id);
7402:
7403: PJI_FM_SUM_EXTR.FIN_SUMMARY(p_worker_id);
7404: PJI_FM_SUM_EXTR.MOVE_DANGLING_FIN_ROWS(p_worker_id);
7405:
7406: PJI_FM_SUM_EXTR.ACT_SUMMARY(p_worker_id);
7407: PJI_FM_SUM_EXTR.MOVE_DANGLING_ACT_ROWS(p_worker_id);
7408:

Line 7406: PJI_FM_SUM_EXTR.ACT_SUMMARY(p_worker_id);

7402:
7403: PJI_FM_SUM_EXTR.FIN_SUMMARY(p_worker_id);
7404: PJI_FM_SUM_EXTR.MOVE_DANGLING_FIN_ROWS(p_worker_id);
7405:
7406: PJI_FM_SUM_EXTR.ACT_SUMMARY(p_worker_id);
7407: PJI_FM_SUM_EXTR.MOVE_DANGLING_ACT_ROWS(p_worker_id);
7408:
7409: PJI_FM_SUM_PSI.RESOURCE_LOOKUP_TABLE(p_worker_id);
7410:

Line 7407: PJI_FM_SUM_EXTR.MOVE_DANGLING_ACT_ROWS(p_worker_id);

7403: PJI_FM_SUM_EXTR.FIN_SUMMARY(p_worker_id);
7404: PJI_FM_SUM_EXTR.MOVE_DANGLING_FIN_ROWS(p_worker_id);
7405:
7406: PJI_FM_SUM_EXTR.ACT_SUMMARY(p_worker_id);
7407: PJI_FM_SUM_EXTR.MOVE_DANGLING_ACT_ROWS(p_worker_id);
7408:
7409: PJI_FM_SUM_PSI.RESOURCE_LOOKUP_TABLE(p_worker_id);
7410:
7411: PJI_FM_SUM_PSI.PURGE_FP_BALANCES(p_worker_id);

Line 7426: PJI_FM_SUM_EXTR.AGGREGATE_RES_SLICES(p_worker_id);

7422: PJI_FM_SUM_PSI.BALANCES_INCR_NEW_PRJ_CMT(p_worker_id);
7423:
7424: PJI_FM_SUM_PSI.FORCE_SUBSEQUENT_RUN(p_worker_id);
7425:
7426: PJI_FM_SUM_EXTR.AGGREGATE_RES_SLICES(p_worker_id);
7427: PJI_FM_SUM_EXTR.AGGREGATE_FIN_SLICES(p_worker_id);
7428: PJI_FM_SUM_EXTR.AGGREGATE_ACT_SLICES(p_worker_id);
7429:
7430: PJI_FM_SUM_EXTR.FORCE_SUBSEQUENT_RUN(p_worker_id);

Line 7427: PJI_FM_SUM_EXTR.AGGREGATE_FIN_SLICES(p_worker_id);

7423:
7424: PJI_FM_SUM_PSI.FORCE_SUBSEQUENT_RUN(p_worker_id);
7425:
7426: PJI_FM_SUM_EXTR.AGGREGATE_RES_SLICES(p_worker_id);
7427: PJI_FM_SUM_EXTR.AGGREGATE_FIN_SLICES(p_worker_id);
7428: PJI_FM_SUM_EXTR.AGGREGATE_ACT_SLICES(p_worker_id);
7429:
7430: PJI_FM_SUM_EXTR.FORCE_SUBSEQUENT_RUN(p_worker_id);
7431:

Line 7428: PJI_FM_SUM_EXTR.AGGREGATE_ACT_SLICES(p_worker_id);

7424: PJI_FM_SUM_PSI.FORCE_SUBSEQUENT_RUN(p_worker_id);
7425:
7426: PJI_FM_SUM_EXTR.AGGREGATE_RES_SLICES(p_worker_id);
7427: PJI_FM_SUM_EXTR.AGGREGATE_FIN_SLICES(p_worker_id);
7428: PJI_FM_SUM_EXTR.AGGREGATE_ACT_SLICES(p_worker_id);
7429:
7430: PJI_FM_SUM_EXTR.FORCE_SUBSEQUENT_RUN(p_worker_id);
7431:
7432: CLEANUP_WORKER(p_worker_id);

Line 7430: PJI_FM_SUM_EXTR.FORCE_SUBSEQUENT_RUN(p_worker_id);

7426: PJI_FM_SUM_EXTR.AGGREGATE_RES_SLICES(p_worker_id);
7427: PJI_FM_SUM_EXTR.AGGREGATE_FIN_SLICES(p_worker_id);
7428: PJI_FM_SUM_EXTR.AGGREGATE_ACT_SLICES(p_worker_id);
7429:
7430: PJI_FM_SUM_EXTR.FORCE_SUBSEQUENT_RUN(p_worker_id);
7431:
7432: CLEANUP_WORKER(p_worker_id);
7433:
7434: end WORKER;

Line 7691: end PJI_FM_SUM_EXTR;

7687: PJI_FM_SUM_MAIN.g_process_delay);
7688:
7689: end WAIT_FOR_WORKER;
7690:
7691: end PJI_FM_SUM_EXTR;