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_PROCESS_UTIL

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 196: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

192: end if;
193:
194: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
195:
196: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
197: (PJI_FM_SUM_MAIN.g_process,
198: 'EXTRACT_COMMITMENTS');
199:
200: if (l_extraction_type <> 'FULL' and l_extract_commitments = 'Y') then

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 3091: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3087: end if;
3088:
3089: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
3090:
3091: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3092: (PJI_FM_SUM_MAIN.g_process,
3093: 'EXTRACT_COMMITMENTS');
3094:
3095: l_last_update_date := sysdate;

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 3269: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3265: end if;
3266:
3267: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
3268:
3269: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3270: (PJI_FM_SUM_MAIN.g_process,
3271: 'EXTRACT_COMMITMENTS');
3272:
3273: l_last_update_date := sysdate;

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 3467: l_operating_unit := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3463: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_NO_SELECTION');
3464:
3465: l_no_selection := FND_MESSAGE.GET;
3466:
3467: l_operating_unit := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3468: (PJI_FM_SUM_MAIN.g_process, 'PROJECT_OPERATING_UNIT');
3469:
3470: if (nvl(l_operating_unit, -1) = -1) then
3471: l_project_operating_unit_name := l_no_selection;

Line 3480: /* 4604355 l_from_project_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3476: where ORGANIZATION_ID = l_operating_unit;
3477: end if;
3478:
3479:
3480: /* 4604355 l_from_project_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3481: (PJI_FM_SUM_MAIN.g_process, 'FROM_PROJECT_ID');
3482:
3483: if (nvl(l_from_project_id, -1) = -1) then
3484:

Line 3496: l_from_project_num := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3492: where PROJECT_ID = l_from_project_id;
3493:
3494: end if;
3495: 4604355 */
3496: l_from_project_num := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3497: (PJI_FM_SUM_MAIN.g_process, 'FROM_PROJECT');
3498:
3499: if (nvl(l_from_project_num,'PJI$NULL') = 'PJI$NULL') then
3500:

Line 3507: /*4604355 l_to_project_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3503:
3504: l_from_project := l_from_project_num;
3505: end if;
3506:
3507: /*4604355 l_to_project_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3508: (PJI_FM_SUM_MAIN.g_process, 'TO_PROJECT_ID');
3509:
3510: if (nvl(l_to_project_id, -1) = -1) then
3511:

Line 3524: l_to_project_num := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3520:
3521: end if;
3522: 4604355 */
3523:
3524: l_to_project_num := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3525: (PJI_FM_SUM_MAIN.g_process, 'TO_PROJECT');
3526:
3527: if (nvl(l_to_project_num, 'PJI$NULL') = 'PJI$NULL') then
3528:

Line 3535: l_plan_type_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

3531: l_to_project := l_to_project_num;
3532:
3533: end if;
3534:
3535: l_plan_type_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3536: (PJI_FM_SUM_MAIN.g_process, 'PLAN_TYPE_ID');
3537:
3538: if (nvl(l_plan_type_id, -1) = -1) then
3539:

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 3670: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');

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');
3671:
3672: if (l_extraction_type = 'INCREMENTAL') then
3673:
3674: -- Actuals

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 3768: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');

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');
3769:
3770: l_last_update_date := sysdate;
3771: l_last_updated_by := FND_GLOBAL.USER_ID;
3772: l_last_update_login := FND_GLOBAL.LOGIN_ID;

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 3967: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');

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');
3968:
3969: l_last_update_date := sysdate;
3970: l_last_updated_by := FND_GLOBAL.USER_ID;
3971: l_creation_date := sysdate;

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 4136: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');

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');
4137:
4138: if (l_extraction_type = 'INCREMENTAL') then
4139:
4140: delete from PJI_FM_AGGR_FIN7

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 4180: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');

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');
4181:
4182: if (l_extraction_type = 'INCREMENTAL') then
4183:
4184: delete

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 4235: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');

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');
4236:
4237: l_last_update_date := sysdate;
4238: l_last_updated_by := FND_GLOBAL.USER_ID;
4239: l_creation_date := sysdate;

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 4376: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');

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');
4377:
4378: insert into PJI_PJP_RMAP_ACR psi_i
4379: (
4380: WORKER_ID,

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 4426: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');

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');
4427:
4428: if (l_extraction_type = 'FULL' or
4429: l_extraction_type = 'INCREMENTAL' or
4430: l_extraction_type = 'PARTIAL') then

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 4464: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,

4460: begin
4461:
4462: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
4463:
4464: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
4465: 'PJI_FM_AGGR_RES_TYPES',
4466: 'NORMAL',
4467: null);
4468:

Line 4469: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,

4465: 'PJI_FM_AGGR_RES_TYPES',
4466: 'NORMAL',
4467: null);
4468:
4469: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
4470: 'PJI_FM_AGGR_FIN1',
4471: 'NORMAL',
4472: null);
4473:

Line 4474: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,

4470: 'PJI_FM_AGGR_FIN1',
4471: 'NORMAL',
4472: null);
4473:
4474: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
4475: 'PJI_FM_AGGR_FIN2',
4476: 'NORMAL',
4477: null);
4478:

Line 4479: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,

4475: 'PJI_FM_AGGR_FIN2',
4476: 'NORMAL',
4477: null);
4478:
4479: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
4480: 'PJI_FM_AGGR_FIN6',
4481: 'NORMAL',
4482: null);
4483: