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_PSI dependencies on PJI_FM_SUM_PSI

Line 1: package body PJI_FM_SUM_PSI as

1: package body PJI_FM_SUM_PSI as
2: /* $Header: PJISF09B.pls 120.15.12010000.2 2008/09/21 05:20:34 kmaddi ship $ */
3:
4: -- -----------------------------------------------------
5: -- procedure RESOURCE_LOOKUP_TABLE

Line 24: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.RESOURCE_LOOKUP_TABLE(p_worker_id);')) then

20: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
21:
22: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
23:
24: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.RESOURCE_LOOKUP_TABLE(p_worker_id);')) then
25: return;
26: end if;
27:
28: insert into PJI_FM_AGGR_RES_TYPES

Line 116: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.RESOURCE_LOOKUP_TABLE(p_worker_id);');

112: 'MATERIAL_ITEMS',
113: 'EQUIPMENT',
114: 'PEOPLE');
115:
116: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.RESOURCE_LOOKUP_TABLE(p_worker_id);');
117:
118: commit;
119:
120: end RESOURCE_LOOKUP_TABLE;

Line 141: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.PURGE_FP_BALANCES(p_worker_id);')) then

137: begin
138:
139: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
140:
141: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.PURGE_FP_BALANCES(p_worker_id);')) then
142: return;
143: end if;
144:
145: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

Line 164: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.PURGE_FP_BALANCES(p_worker_id);');

160: where map.WORKER_ID = p_worker_id);
161:
162: end if;
163:
164: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.PURGE_FP_BALANCES(p_worker_id);');
165:
166: commit;
167:
168: end PURGE_FP_BALANCES;

Line 190: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.PURGE_CMT_BALANCES(p_worker_id);')) then

186: begin
187:
188: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
189:
190: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.PURGE_CMT_BALANCES(p_worker_id);')) then
191: return;
192: end if;
193:
194: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

Line 217: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.PURGE_CMT_BALANCES(p_worker_id);');

213: where map.WORKER_ID = p_worker_id);
214:
215: end if;
216:
217: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.PURGE_CMT_BALANCES(p_worker_id);');
218:
219: commit;
220:
221: end PURGE_CMT_BALANCES;

Line 242: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.PURGE_AC_BALANCES(p_worker_id);')) then

238: begin
239:
240: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
241:
242: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.PURGE_AC_BALANCES(p_worker_id);')) then
243: return;
244: end if;
245:
246: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

Line 464: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.PURGE_AC_BALANCES(p_worker_id);');

460: nvl(act4.G2_AR_AMOUNT_OVERDUE , 0) = 0;
461:
462: end if;
463:
464: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.PURGE_AC_BALANCES(p_worker_id);');
465:
466: commit;
467:
468: end PURGE_AC_BALANCES;

Line 488: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.AGGREGATE_FPR_PERIODS(p_worker_id);')) then

484: begin
485:
486: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
487:
488: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.AGGREGATE_FPR_PERIODS(p_worker_id);')) then
489: return;
490: end if;
491:
492: insert /*+ append parallel(tmp6_i) */ into PJI_FM_AGGR_FIN6 tmp6_i

Line 1422: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.AGGREGATE_FPR_PERIODS(p_worker_id);');

1418: 'GL', gl_cal.CAL_PERIOD_ID,
1419: 'PA', pa_cal.CAL_PERIOD_ID),
1420: tmp2.TXN_CURRENCY_CODE;
1421:
1422: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.AGGREGATE_FPR_PERIODS(p_worker_id);');
1423:
1424: commit;
1425:
1426: end AGGREGATE_FPR_PERIODS;

Line 1446: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.AGGREGATE_ACR_PERIODS(p_worker_id);')) then

1442: begin
1443:
1444: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
1445:
1446: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.AGGREGATE_ACR_PERIODS(p_worker_id);')) then
1447: return;
1448: end if;
1449:
1450: insert /*+ append parallel(tmp4_i) */ into PJI_FM_AGGR_ACT4 tmp4_i

Line 2303: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.AGGREGATE_ACR_PERIODS(p_worker_id);');

2299: 'GL', gl_cal.CAL_PERIOD_ID,
2300: 'PA', pa_cal.CAL_PERIOD_ID),
2301: tmp2.TXN_CURRENCY_CODE;
2302:
2303: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.AGGREGATE_ACR_PERIODS(p_worker_id);');
2304:
2305: commit;
2306:
2307: end AGGREGATE_ACR_PERIODS;

Line 2333: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.INSERT_NEW_HEADERS(p_worker_id);')) then

2329: begin
2330:
2331: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
2332:
2333: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.INSERT_NEW_HEADERS(p_worker_id);')) then
2334: return;
2335: end if;
2336:
2337: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

Line 2474: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.INSERT_NEW_HEADERS(p_worker_id);');

2470: tmp6.PROJECT_ROLE_ID = hdr.PROJECT_ROLE_ID and
2471: tmp6.PERSON_TYPE = hdr.PERSON_TYPE and
2472: tmp6.SYSTEM_LINKAGE_FUNCTION = hdr.SYSTEM_LINKAGE_FUNCTION);
2473:
2474: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.INSERT_NEW_HEADERS(p_worker_id);');
2475:
2476: commit;
2477:
2478: end INSERT_NEW_HEADERS;

Line 2504: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.BALANCES_INSERT(p_worker_id);')) then

2500: begin
2501:
2502: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
2503:
2504: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.BALANCES_INSERT(p_worker_id);')) then
2505: return;
2506: end if;
2507:
2508: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

Line 2859: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.BALANCES_INSERT(p_worker_id);');

2855: from PJI_PJP_PROJ_EXTR_STATUS pjp);
2856:
2857: end if;
2858:
2859: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.BALANCES_INSERT(p_worker_id);');
2860:
2861: commit;
2862:
2863: end BALANCES_INSERT;

Line 2889: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.BALANCES_INCR_NEW_PRJ(p_worker_id);')) then

2885: begin
2886:
2887: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
2888:
2889: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.BALANCES_INCR_NEW_PRJ(p_worker_id);')) then
2890: return;
2891: end if;
2892:
2893: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

Line 3054: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.BALANCES_INCR_NEW_PRJ(p_worker_id);');

3050: tmp6.TXN_CURRENCY_CODE;
3051:
3052: end if;
3053:
3054: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.BALANCES_INCR_NEW_PRJ(p_worker_id);');
3055:
3056: commit;
3057:
3058: end BALANCES_INCR_NEW_PRJ;

Line 3085: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.BALANCES_INSERT_CMT(p_worker_id);')) then

3081: begin
3082:
3083: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
3084:
3085: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.BALANCES_INSERT_CMT(p_worker_id);')) then
3086: return;
3087: end if;
3088:
3089: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

Line 3232: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.BALANCES_INSERT_CMT(p_worker_id);');

3228: tmp6.TXN_CURRENCY_CODE;
3229:
3230: end if;
3231:
3232: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.BALANCES_INSERT_CMT(p_worker_id);');
3233:
3234: commit;
3235:
3236: end BALANCES_INSERT_CMT;

Line 3263: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.BALANCES_INCR_NEW_PRJ_CMT(p_worker_id);')) then

3259: begin
3260:
3261: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
3262:
3263: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.BALANCES_INCR_NEW_PRJ_CMT(p_worker_id);')) then
3264: return;
3265: end if;
3266:
3267: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

Line 3407: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.BALANCES_INCR_NEW_PRJ_CMT(p_worker_id);');

3403: tmp6.TXN_CURRENCY_CODE;
3404:
3405: end if;
3406:
3407: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.BALANCES_INCR_NEW_PRJ_CMT(p_worker_id);');
3408:
3409: commit;
3410:
3411: end BALANCES_INCR_NEW_PRJ_CMT;

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

3452: begin
3453:
3454: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
3455:
3456: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.FORCE_SUBSEQUENT_RUN(p_worker_id);')) then
3457: return;
3458: end if;
3459:
3460: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

Line 3637: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.FORCE_SUBSEQUENT_RUN(p_worker_id);');

3633:
3634: end if;
3635:
3636:
3637: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.FORCE_SUBSEQUENT_RUN(p_worker_id);');
3638:
3639: commit;
3640:
3641: end FORCE_SUBSEQUENT_RUN;

Line 3666: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.BALANCES_ROWID_TABLE(p_worker_id);')) then

3662: begin
3663:
3664: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;
3665:
3666: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.BALANCES_ROWID_TABLE(p_worker_id);')) then
3667: return;
3668: end if;
3669:
3670: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');

Line 3732: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.BALANCES_ROWID_TABLE(p_worker_id);');

3728: tmp7.RECORD_TYPE = 'M';
3729:
3730: end if;
3731:
3732: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.BALANCES_ROWID_TABLE(p_worker_id);');
3733:
3734: commit;
3735:
3736: end BALANCES_ROWID_TABLE;

Line 3764: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.BALANCES_UPDATE_DELTA(p_worker_id);')) then

3760: begin
3761:
3762: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;
3763:
3764: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.BALANCES_UPDATE_DELTA(p_worker_id);')) then
3765: return;
3766: end if;
3767:
3768: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');

Line 3929: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.BALANCES_UPDATE_DELTA(p_worker_id);');

3925: tmp7_r.TXN_ROWID is not null);
3926:
3927: end if;
3928:
3929: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.BALANCES_UPDATE_DELTA(p_worker_id);');
3930:
3931: commit;
3932:
3933: end BALANCES_UPDATE_DELTA;

Line 3963: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.BALANCES_INSERT_DELTA(p_worker_id);')) then

3959: begin
3960:
3961: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;
3962:
3963: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.BALANCES_INSERT_DELTA(p_worker_id);')) then
3964: return;
3965: end if;
3966:
3967: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');

Line 4103: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.BALANCES_INSERT_DELTA(p_worker_id);');

4099: tmp7.TXN_CURRENCY_CODE;
4100:
4101: end if;
4102:
4103: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.BALANCES_INSERT_DELTA(p_worker_id);');
4104:
4105: commit;
4106:
4107: end BALANCES_INSERT_DELTA;

Line 4132: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.PURGE_INCREMENTAL_BALANCES(p_worker_id);')) then

4128: begin
4129:
4130: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;
4131:
4132: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.PURGE_INCREMENTAL_BALANCES(p_worker_id);')) then
4133: return;
4134: end if;
4135:
4136: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');

Line 4147: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.PURGE_INCREMENTAL_BALANCES(p_worker_id);');

4143: where WORKER_ID = p_worker_id);
4144:
4145: end if;
4146:
4147: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.PURGE_INCREMENTAL_BALANCES(p_worker_id);');
4148:
4149: commit;
4150:
4151: end PURGE_INCREMENTAL_BALANCES;

Line 4176: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.PURGE_BALANCES_CMT(p_worker_id);')) then

4172: begin
4173:
4174: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;
4175:
4176: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.PURGE_BALANCES_CMT(p_worker_id);')) then
4177: return;
4178: end if;
4179:
4180: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');

Line 4197: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.PURGE_BALANCES_CMT(p_worker_id);');

4193:
4194:
4195: end if;
4196:
4197: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.PURGE_BALANCES_CMT(p_worker_id);');
4198:
4199: commit;
4200:
4201: end PURGE_BALANCES_CMT;

Line 4231: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.BALANCES_INSERT_DELTA_CMT(p_worker_id);')) then

4227: begin
4228:
4229: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;
4230:
4231: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.BALANCES_INSERT_DELTA_CMT(p_worker_id);')) then
4232: return;
4233: end if;
4234:
4235: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');

Line 4343: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.BALANCES_INSERT_DELTA_CMT(p_worker_id);');

4339: tmp7.TXN_CURRENCY_CODE;
4340:
4341: end if;
4342:
4343: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.BALANCES_INSERT_DELTA_CMT(p_worker_id);');
4344:
4345: commit;
4346:
4347: end BALANCES_INSERT_DELTA_CMT;

Line 4372: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.ACT_ROWID_TABLE(p_worker_id);')) then

4368: begin
4369:
4370: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;
4371:
4372: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.ACT_ROWID_TABLE(p_worker_id);')) then
4373: return;
4374: end if;
4375:
4376: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');

Line 4393: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.ACT_ROWID_TABLE(p_worker_id);');

4389: where
4390: map.WORKER_ID = p_worker_id and
4391: act4.PROJECT_ID = map.PROJECT_ID;
4392:
4393: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.ACT_ROWID_TABLE(p_worker_id);');
4394:
4395: commit;
4396:
4397: end ACT_ROWID_TABLE;

Line 4422: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.PURGE_BALANCES_ACT(p_worker_id);')) then

4418: begin
4419:
4420: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;
4421:
4422: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.PURGE_BALANCES_ACT(p_worker_id);')) then
4423: return;
4424: end if;
4425:
4426: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');

Line 4440: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.PURGE_BALANCES_ACT(p_worker_id);');

4436: where WORKER_ID = p_worker_id);
4437:
4438: end if;
4439:
4440: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.PURGE_BALANCES_ACT(p_worker_id);');
4441:
4442: commit;
4443:
4444: end PURGE_BALANCES_ACT;

Line 4486: end PJI_FM_SUM_PSI;

4482: null);
4483:
4484: end CLEANUP;
4485:
4486: end PJI_FM_SUM_PSI;