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_MAIN

Line 20: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;

16: l_extraction_type varchar2(15);
17:
18: begin
19:
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

Line 139: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;

135: l_extraction_type varchar2(15);
136:
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;

Line 188: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;

184: l_extract_commitments varchar2(30);
185:
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;

Line 197: (PJI_FM_SUM_MAIN.g_process,

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
201:

Line 240: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;

236: l_extraction_type varchar2(15);
237:
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;

Line 486: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;

482: l_process varchar2(30);
483:
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;

Line 1444: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;

1440: l_process varchar2(30);
1441:
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;

Line 2331: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;

2327: l_extraction_type varchar2(15);
2328:
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;

Line 2502: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;

2498: l_extraction_type varchar2(15);
2499:
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;

Line 2887: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;

2883: l_extraction_type varchar2(15);
2884:
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;

Line 3083: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;

3079: l_extract_commitments varchar2(30);
3080:
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;

Line 3092: (PJI_FM_SUM_MAIN.g_process,

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;
3096: l_last_updated_by := FND_GLOBAL.USER_ID;

Line 3261: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;

3257: l_extract_commitments varchar2(30);
3258:
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;

Line 3270: (PJI_FM_SUM_MAIN.g_process,

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;
3274: l_last_updated_by := FND_GLOBAL.USER_ID;

Line 3454: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;

3450: l_project_operating_unit_name varchar2(240);
3451: l_print_rpt_flag varchar2(1) :='Y';
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;

Line 3468: (PJI_FM_SUM_MAIN.g_process, 'PROJECT_OPERATING_UNIT');

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;
3472: else

Line 3481: (PJI_FM_SUM_MAIN.g_process, 'FROM_PROJECT_ID');

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:
3485: l_from_project := l_no_selection;

Line 3497: (PJI_FM_SUM_MAIN.g_process, 'FROM_PROJECT');

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:
3501: l_from_project := l_no_selection;

Line 3508: (PJI_FM_SUM_MAIN.g_process, 'TO_PROJECT_ID');

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:
3512: l_to_project := l_no_selection;

Line 3525: (PJI_FM_SUM_MAIN.g_process, 'TO_PROJECT');

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:
3529: l_to_project := l_no_selection;

Line 3536: (PJI_FM_SUM_MAIN.g_process, 'PLAN_TYPE_ID');

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:
3540: l_plan_type := l_no_selection;

Line 3592: PJI_FM_SUM_MAIN.my_pad(30 - length(l_project_operating_unit_tg),

3588:
3589: l_project_operating_unit_tg := substr(FND_MESSAGE.GET, 1, 30);
3590:
3591: PJI_UTILS.WRITE2OUT(l_project_operating_unit_tg ||
3592: PJI_FM_SUM_MAIN.my_pad(30 - length(l_project_operating_unit_tg),
3593: ' ') ||
3594: ': ' ||
3595: l_project_operating_unit_name ||
3596: l_newline);

Line 3604: PJI_FM_SUM_MAIN.my_pad(30-length(l_from_project_tg),

3600:
3601: l_from_project_tg := substr(FND_MESSAGE.GET, 1, 30);
3602:
3603: PJI_UTILS.WRITE2OUT(l_from_project_tg ||
3604: PJI_FM_SUM_MAIN.my_pad(30-length(l_from_project_tg),
3605: ' ') ||
3606: ': ' ||
3607: l_from_project ||
3608: l_newline);

Line 3616: PJI_FM_SUM_MAIN.my_pad(30 - length(l_to_project_tg),

3612:
3613: l_to_project_tg := substr(FND_MESSAGE.GET, 1, 30);
3614:
3615: PJI_UTILS.WRITE2OUT(l_to_project_tg ||
3616: PJI_FM_SUM_MAIN.my_pad(30 - length(l_to_project_tg),
3617: ' ') ||
3618: ': ' ||
3619: l_to_project ||
3620: l_newline);

Line 3628: PJI_FM_SUM_MAIN.my_pad(30 - length(l_plan_type_tg),

3624:
3625: l_plan_type_tg := substr(FND_MESSAGE.GET, 1, 30);
3626:
3627: PJI_UTILS.WRITE2OUT(l_plan_type_tg ||
3628: PJI_FM_SUM_MAIN.my_pad(30 - length(l_plan_type_tg),
3629: ' ') ||
3630: ': ' ||
3631: l_plan_type ||
3632: l_newline);