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_UTILS

Line 22: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

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
25: return;
26: end if;

Line 145: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

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');
146:
147: if (l_extraction_type = 'PARTIAL') then
148:
149: delete

Line 209: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

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;
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');

Line 261: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

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;
260:
261: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
262:
263: if (l_extraction_type = 'PARTIAL') then
264:
265: delete

Line 2359: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

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;
2358:
2359: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
2360:
2361: l_last_update_date := sysdate;
2362: l_last_updated_by := FND_GLOBAL.USER_ID;
2363: l_creation_date := sysdate;

Line 2538: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

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;
2537:
2538: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
2539:
2540: l_last_update_date := sysdate;
2541: l_last_updated_by := FND_GLOBAL.USER_ID;
2542: l_creation_date := sysdate;

Line 3180: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

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;
3179:
3180: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
3181:
3182: l_last_update_date := sysdate;
3183: l_last_updated_by := FND_GLOBAL.USER_ID;
3184: l_creation_date := sysdate;

Line 3441: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

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;
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');

Line 3686: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

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;
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');

Line 3944: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

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;
3943:
3944: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
3945:
3946: if (l_extraction_type = 'PARTIAL') then
3947: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_NO_SELECTION');
3948:

Line 4065: PJI_UTILS.WRITE2OUT(l_newline ||

4061: if (l_extraction_type = 'PARTIAL' and l_print_rpt_flag ='Y') then
4062:
4063: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_FORCE_PRTL');
4064:
4065: PJI_UTILS.WRITE2OUT(l_newline ||
4066: l_newline ||
4067: FND_MESSAGE.GET ||
4068: l_newline ||
4069: l_newline);

Line 4075: PJI_UTILS.WRITE2OUT(l_project_operating_unit_tg ||

4071: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PRJ_OP_UNIT');
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 ||

Line 4087: PJI_UTILS.WRITE2OUT(l_from_project_tg ||

4083: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_FROM_PRJ');
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 ||

Line 4099: PJI_UTILS.WRITE2OUT(l_to_project_tg ||

4095: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_TO_PRJ');
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 ||

Line 4111: PJI_UTILS.WRITE2OUT(l_plan_type_tg ||

4107: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_PLAN_TYPE');
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 ||

Line 4954: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

4950: l_schema varchar2(30);
4951:
4952: begin
4953:
4954: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
4955:
4956: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
4957: 'PJI_FM_AGGR_RES_TYPES',
4958: 'NORMAL',