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_PROCESS_UTIL dependencies on PJI_PROCESS_UTIL

Line 1: package body PJI_PROCESS_UTIL as

1: package body PJI_PROCESS_UTIL as
2: /* $Header: PJIUT03B.pls 120.27.12020000.3 2013/04/18 05:19:47 rtalakon ship $ */
3:
4: -- Global variables -----------------------------------
5: g_check_step varchar2(1) := 'Y';

Line 8: g_package_name VARCHAR2(100) := 'PJI_PROCESS_UTIL';

4: -- Global variables -----------------------------------
5: g_check_step varchar2(1) := 'Y';
6: /* Added for Bug 10338478 Start */
7: g_worker_id NUMBER := 1;
8: g_package_name VARCHAR2(100) := 'PJI_PROCESS_UTIL';
9:
10: PROCEDURE EXECUTE_ROLLUP_FPR_RBS(p_worker_id IN NUMBER,
11: p_level IN NUMBER,
12: p_partial_mode IN varchar2,

Line 36: l_running_param := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

32:
33: if (p_stage = 'STAGE1_EXTR') then
34:
35: l_permanent_param := PJI_UTILS.GET_PARAMETER('EXTRACTION_TYPE');
36: l_running_param := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
37: (PJI_FM_SUM_MAIN.g_process, 'TRANSITION');
38:
39: if (l_running_param is not null) then
40:

Line 67: l_running_param := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

63:
64: end;
65:
66: l_permanent_param := PJI_UTILS.GET_PARAMETER('LAST_PJI_EXTR_DATE');
67: l_running_param := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
68: -- Remove dependency on STAGE2_PJI
69: (l_stage2_pji_process, 'PROCESS_RUNNING');
70: -- (PJI_RM_SUM_MAIN.g_process, 'PROCESS_RUNNING');
71:

Line 343: l_transition_flag := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

339: -- contain error recovery state from the previous iteration
340:
341: l_process := PJI_FM_SUM_MAIN.g_process;
342:
343: l_transition_flag := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
344: 'TRANSITION');
345:
346: if (l_transition_flag = 'Y') then
347:

Line 349: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

345:
346: if (l_transition_flag = 'Y') then
347:
348: l_params_proj_perf_flag :=
349: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
350: 'CONFIG_PROJ_PERF_FLAG'), 'N');
351: l_params_cost_flag :=
352: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
353: 'CONFIG_COST_FLAG'), 'N');

Line 352: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

348: l_params_proj_perf_flag :=
349: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
350: 'CONFIG_PROJ_PERF_FLAG'), 'N');
351: l_params_cost_flag :=
352: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
353: 'CONFIG_COST_FLAG'), 'N');
354: l_params_profit_flag :=
355: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
356: 'CONFIG_PROFIT_FLAG'), 'N');

Line 355: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

351: l_params_cost_flag :=
352: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
353: 'CONFIG_COST_FLAG'), 'N');
354: l_params_profit_flag :=
355: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
356: 'CONFIG_PROFIT_FLAG'), 'N');
357: l_params_util_flag :=
358: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
359: 'CONFIG_UTIL_FLAG'), 'N');

Line 358: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

354: l_params_profit_flag :=
355: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
356: 'CONFIG_PROFIT_FLAG'), 'N');
357: l_params_util_flag :=
358: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
359: 'CONFIG_UTIL_FLAG'), 'N');
360:
361: else -- l_transition is null or 'N'
362:

Line 638: if (nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

634: l_stage2_pji_running := null;
635:
636: end;
637:
638: if (nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
639: (p_process, 'PROCESS_RUNNING'), 'F') = 'F') then
640: l_done := true;
641: l_worker_count := -1;
642: -- Remove dependency on STAGE2_PJI

Line 7671: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(L_PROCESS,'EXTRACTION_TYPE');

7667: /* Added for bug 13030627 */
7668:
7669: /* Start bug 10338478 */
7670: L_PROCESS := PJI_PJP_SUM_MAIN.G_PROCESS || P_WORKER_ID;
7671: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(L_PROCESS,'EXTRACTION_TYPE');
7672: /* End bug 10338478 */
7673:
7674: /* Added for bug 11843459 */
7675: if PJI_PJP_GEN_PERF_ALL.GET_PARAMETER('PJI_PJP_PERF_PRL') = 'Y' then

Line 44881: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema, 'PJI_HELPER_420','NORMAL',l_partition_name);

44877: l_parallel_proc := nvl(fnd_profile.value('PJI_EXTRACTION_PARALLELISM'), 1);
44878:
44879: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
44880:
44881: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema, 'PJI_HELPER_420','NORMAL',l_partition_name);
44882: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema, 'PJI_BATCH_STATUS_420','NORMAL',l_partition_name);
44883:
44884:
44885: insert into pji_helper_420 (worker_id, project_id, batch_id, level_420, partial_mode_420, fpm_upgrade_420)

Line 44882: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema, 'PJI_BATCH_STATUS_420','NORMAL',l_partition_name);

44878:
44879: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
44880:
44881: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema, 'PJI_HELPER_420','NORMAL',l_partition_name);
44882: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema, 'PJI_BATCH_STATUS_420','NORMAL',l_partition_name);
44883:
44884:
44885: insert into pji_helper_420 (worker_id, project_id, batch_id, level_420, partial_mode_420, fpm_upgrade_420)
44886: (select worker_id, project_id, ceil(ROWNUM / l_batch_size) batch_id, l_level, l_partial_mode, l_fpm_upgrade

Line 44970: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema, 'PJI_BATCH_STATUS_420','NORMAL',null);

44966:
44967: if l_error_count > 0 then
44968: raise_application_error(-20010,'Helper 420 has failed');
44969: else
44970: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema, 'PJI_BATCH_STATUS_420','NORMAL',null);
44971: end if;
44972:
44973: end if;
44974:

Line 45007: IF (PJI_PROCESS_UTIL.REQUEST_STATUS('OKAY',

45003:
45004: FOR i IN l_Batch_t.first..l_Batch_t.last LOOP
45005:
45006: IF (l_Batch_t(i).request_id > 0 ) THEN
45007: IF (PJI_PROCESS_UTIL.REQUEST_STATUS('OKAY',
45008: l_Batch_t(i).request_id,'PJI_HELPER_420')) THEN
45009: IF (PJI_PROCESS_UTIL.REQUEST_STATUS('RUNNING',
45010: l_Batch_t(i).request_id,'PJI_HELPER_420')) THEN
45011: l_Batch_t(i).request_status := 'RUNNING';

Line 45009: IF (PJI_PROCESS_UTIL.REQUEST_STATUS('RUNNING',

45005:
45006: IF (l_Batch_t(i).request_id > 0 ) THEN
45007: IF (PJI_PROCESS_UTIL.REQUEST_STATUS('OKAY',
45008: l_Batch_t(i).request_id,'PJI_HELPER_420')) THEN
45009: IF (PJI_PROCESS_UTIL.REQUEST_STATUS('RUNNING',
45010: l_Batch_t(i).request_id,'PJI_HELPER_420')) THEN
45011: l_Batch_t(i).request_status := 'RUNNING';
45012: ELSE
45013: l_Batch_t(i).request_status := 'COMPLETED';

Line 46607: end PJI_PROCESS_UTIL;

46603: END HELPER_420;
46604: /* Added for Bug 10338478 End */
46605:
46606:
46607: end PJI_PROCESS_UTIL;