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 203: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;

199: l_extract_commitments varchar2(30);
200:
201: begin
202:
203: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
204:
205: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.PURGE_CMT_BALANCES(p_worker_id);')) then
206: return;
207: end if;

Line 212: (PJI_FM_SUM_MAIN.g_process,

208:
209: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
210:
211: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
212: (PJI_FM_SUM_MAIN.g_process,
213: 'EXTRACT_COMMITMENTS');
214:
215: if (l_extraction_type <> 'FULL' and l_extract_commitments = 'Y') then
216:

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

251: l_extraction_type varchar2(15);
252:
253: begin
254:
255: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
256:
257: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.PURGE_AC_BALANCES(p_worker_id);')) then
258: return;
259: end if;

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

497: l_process varchar2(30);
498:
499: begin
500:
501: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
502:
503: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.AGGREGATE_FPR_PERIODS(p_worker_id);')) then
504: return;
505: end if;

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

1462: l_process varchar2(30);
1463:
1464: begin
1465:
1466: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
1467:
1468: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.AGGREGATE_ACR_PERIODS(p_worker_id);')) then
1469: return;
1470: end if;

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

2349: l_extraction_type varchar2(15);
2350:
2351: begin
2352:
2353: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
2354:
2355: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.INSERT_NEW_HEADERS(p_worker_id);')) then
2356: return;
2357: end if;

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

2528: l_extraction_type varchar2(15);
2529:
2530: begin
2531:
2532: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
2533:
2534: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.BALANCES_INSERT(p_worker_id);')) then
2535: return;
2536: end if;

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

3170: l_extraction_type varchar2(15);
3171:
3172: begin
3173:
3174: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
3175:
3176: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.BALANCES_INCR_NEW_PRJ(p_worker_id);')) then
3177: return;
3178: end if;

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

3431: l_extract_commitments varchar2(30);
3432:
3433: begin
3434:
3435: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
3436:
3437: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.BALANCES_INSERT_CMT(p_worker_id);')) then
3438: return;
3439: end if;

Line 3444: (PJI_FM_SUM_MAIN.g_process,

3440:
3441: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
3442:
3443: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3444: (PJI_FM_SUM_MAIN.g_process,
3445: 'EXTRACT_COMMITMENTS');
3446:
3447: l_last_update_date := sysdate;
3448: l_last_updated_by := FND_GLOBAL.USER_ID;

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

3676: l_extract_commitments varchar2(30);
3677:
3678: begin
3679:
3680: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
3681:
3682: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.BALANCES_INCR_NEW_PRJ_CMT(p_worker_id);')) then
3683: return;
3684: end if;

Line 3689: (PJI_FM_SUM_MAIN.g_process,

3685:
3686: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
3687:
3688: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3689: (PJI_FM_SUM_MAIN.g_process,
3690: 'EXTRACT_COMMITMENTS');
3691:
3692: l_last_update_date := sysdate;
3693: l_last_updated_by := FND_GLOBAL.USER_ID;

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

3934: l_print_rpt_flag varchar2(1) :='Y';
3935: begin
3936: --Commenting out this procedure for Bug 8365073. Please check bug for details
3937: /*
3938: l_process := PJI_FM_SUM_MAIN.g_process || p_worker_id;
3939:
3940: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.FORCE_SUBSEQUENT_RUN(p_worker_id);')) then
3941: return;
3942: end if;

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

3948:
3949: l_no_selection := FND_MESSAGE.GET;
3950:
3951: l_operating_unit := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3952: (PJI_FM_SUM_MAIN.g_process, 'PROJECT_OPERATING_UNIT');
3953:
3954: if (nvl(l_operating_unit, -1) = -1) then
3955: l_project_operating_unit_name := l_no_selection;
3956: else

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

3961: end if;
3962: */
3963:
3964: /* 4604355 l_from_project_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3965: (PJI_FM_SUM_MAIN.g_process, 'FROM_PROJECT_ID');
3966:
3967: if (nvl(l_from_project_id, -1) = -1) then
3968:
3969: l_from_project := l_no_selection;

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

3977:
3978: end if;
3979: 4604355 *//*
3980: l_from_project_num := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3981: (PJI_FM_SUM_MAIN.g_process, 'FROM_PROJECT');
3982:
3983: if (nvl(l_from_project_num,'PJI$NULL') = 'PJI$NULL') then
3984:
3985: l_from_project := l_no_selection;

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

3988: l_from_project := l_from_project_num;
3989: end if;*/
3990:
3991: /*4604355 l_to_project_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3992: (PJI_FM_SUM_MAIN.g_process, 'TO_PROJECT_ID');
3993:
3994: if (nvl(l_to_project_id, -1) = -1) then
3995:
3996: l_to_project := l_no_selection;

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

4005: end if;
4006: 4604355 */
4007: /*
4008: l_to_project_num := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4009: (PJI_FM_SUM_MAIN.g_process, 'TO_PROJECT');
4010:
4011: if (nvl(l_to_project_num, 'PJI$NULL') = 'PJI$NULL') then
4012:
4013: l_to_project := l_no_selection;

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

4016:
4017: end if;
4018:
4019: l_plan_type_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4020: (PJI_FM_SUM_MAIN.g_process, 'PLAN_TYPE_ID');
4021:
4022: if (nvl(l_plan_type_id, -1) = -1) then
4023:
4024: l_plan_type := l_no_selection;

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

4072:
4073: l_project_operating_unit_tg := substr(FND_MESSAGE.GET, 1, 30);
4074:
4075: PJI_UTILS.WRITE2OUT(l_project_operating_unit_tg ||
4076: PJI_FM_SUM_MAIN.my_pad(30 - length(l_project_operating_unit_tg),
4077: ' ') ||
4078: ': ' ||
4079: l_project_operating_unit_name ||
4080: l_newline);

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

4084:
4085: l_from_project_tg := substr(FND_MESSAGE.GET, 1, 30);
4086:
4087: PJI_UTILS.WRITE2OUT(l_from_project_tg ||
4088: PJI_FM_SUM_MAIN.my_pad(30-length(l_from_project_tg),
4089: ' ') ||
4090: ': ' ||
4091: l_from_project ||
4092: l_newline);

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

4096:
4097: l_to_project_tg := substr(FND_MESSAGE.GET, 1, 30);
4098:
4099: PJI_UTILS.WRITE2OUT(l_to_project_tg ||
4100: PJI_FM_SUM_MAIN.my_pad(30 - length(l_to_project_tg),
4101: ' ') ||
4102: ': ' ||
4103: l_to_project ||
4104: l_newline);

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

4108:
4109: l_plan_type_tg := substr(FND_MESSAGE.GET, 1, 30);
4110:
4111: PJI_UTILS.WRITE2OUT(l_plan_type_tg ||
4112: PJI_FM_SUM_MAIN.my_pad(30 - length(l_plan_type_tg),
4113: ' ') ||
4114: ': ' ||
4115: l_plan_type ||
4116: l_newline);