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 194: l_extraction_type := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');

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');
195:
196: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
197: (PJI_FM_SUM_MAIN.g_process,
198: 'EXTRACT_COMMITMENTS');

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

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');
247:
248: if (l_extraction_type = 'PARTIAL') then
249:
250: delete

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

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');
2338:
2339: l_last_update_date := sysdate;
2340: l_last_updated_by := FND_GLOBAL.USER_ID;
2341: l_creation_date := sysdate;

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

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');
2509:
2510: l_last_update_date := sysdate;
2511: l_last_updated_by := FND_GLOBAL.USER_ID;
2512: l_creation_date := sysdate;

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

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');
2894:
2895: l_last_update_date := sysdate;
2896: l_last_updated_by := FND_GLOBAL.USER_ID;
2897: l_creation_date := sysdate;

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

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');
3090:
3091: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3092: (PJI_FM_SUM_MAIN.g_process,
3093: 'EXTRACT_COMMITMENTS');

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

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');
3268:
3269: l_extract_commitments := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
3270: (PJI_FM_SUM_MAIN.g_process,
3271: 'EXTRACT_COMMITMENTS');

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

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');
3461:
3462: if (l_extraction_type = 'PARTIAL') then
3463: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_NO_SELECTION');
3464:

Line 3581: PJI_UTILS.WRITE2OUT(l_newline ||

3577: if (l_extraction_type = 'PARTIAL' and l_print_rpt_flag ='Y') then
3578:
3579: FND_MESSAGE.SET_NAME('PJI', 'PJI_PJP_SUM_FORCE_PRTL');
3580:
3581: PJI_UTILS.WRITE2OUT(l_newline ||
3582: l_newline ||
3583: FND_MESSAGE.GET ||
3584: l_newline ||
3585: l_newline);

Line 3591: PJI_UTILS.WRITE2OUT(l_project_operating_unit_tg ||

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

Line 3603: PJI_UTILS.WRITE2OUT(l_from_project_tg ||

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

Line 3615: PJI_UTILS.WRITE2OUT(l_to_project_tg ||

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

Line 3627: PJI_UTILS.WRITE2OUT(l_plan_type_tg ||

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

Line 4462: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

4458: l_schema varchar2(30);
4459:
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',