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

Line 4075: IF (NOT PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

4071: BEGIN
4072:
4073: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
4074:
4075: IF (NOT PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
4076: (
4077: l_process,
4078: 'PJI_RM_SUM_AVL.MERGE_ORG_AVL_DUR(p_worker_id);'
4079: )) THEN

Line 4270: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

4266: tmp1.BCKT_5_CM,
4267: tmp1.TOTAL_RES_COUNT
4268: );
4269:
4270: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
4271: (
4272: l_process,
4273: 'PJI_RM_SUM_AVL.MERGE_ORG_AVL_DUR(p_worker_id);'
4274: );

Line 4299: IF (NOT PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

4295: BEGIN
4296:
4297: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
4298:
4299: IF (NOT PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
4300: (
4301: l_process,
4302: 'PJI_RM_SUM_AVL.MERGE_CURR_ORG_AVL(p_worker_id);'
4303: )) THEN

Line 4397: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

4393: tmp1.AVAILABILITY,
4394: tmp1.TOTAL_RES_COUNT
4395: );
4396:
4397: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
4398: (
4399: l_process,
4400: 'PJI_RM_SUM_AVL.MERGE_CURR_ORG_AVL(p_worker_id);'
4401: );

Line 4446: IF (NOT PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

4442: l_process VARCHAR2(30);
4443: BEGIN
4444: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
4445:
4446: IF (NOT PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
4447: (
4448: l_process,
4449: 'PJI_RM_SUM_AVL.RES_CALC_CLEANUP(p_worker_id);'
4450: )) THEN

Line 4466: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

4462: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL5');
4463:
4464: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_RES_BATCH_MAP');
4465:
4466: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
4467: (
4468: l_process,
4469: 'PJI_RM_SUM_AVL.RES_CALC_CLEANUP(p_worker_id);'
4470: );

Line 4508: IF (NOT PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

4504: --of the summarization process for resources in the buckets
4505:
4506: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
4507:
4508: IF (NOT PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
4509: (
4510: l_process,
4511: 'PJI_RM_SUM_AVL.START_RES_AVL_CALC_R1(p_worker_id);'
4512: )) THEN

Line 4552: PJI_PROCESS_UTIL.sleep(PJI_RM_SUM_MAIN.g_process_delay);

4548: END IF;
4549:
4550: IF(l_try_res_again = 'Y') THEN
4551: --Wait for some time and try again
4552: PJI_PROCESS_UTIL.sleep(PJI_RM_SUM_MAIN.g_process_delay);
4553: ELSE
4554: pji_utils.write2log(p_worker_id || ': R1: Before Calculating availability');
4555: CALCULATE_RES_AVL
4556: (

Line 4592: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');

4588: where nvl(WORKER_STATUS, 'X') <> 'C';
4589:
4590: if (l_row_count = 0) then
4591:
4592: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');
4593:
4594: for x in 2 .. l_parallel_processes loop
4595:
4596: update PJI_SYSTEM_PRC_STATUS

Line 4607: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

4603: end loop;
4604:
4605: end if;
4606:
4607: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
4608: (
4609: l_process,
4610: 'PJI_RM_SUM_AVL.START_RES_AVL_CALC_R1(p_worker_id);'
4611: );

Line 4654: IF (NOT PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

4650: --of the summarization process for resources in the buckets
4651:
4652: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
4653:
4654: IF (NOT PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
4655: (
4656: l_process,
4657: 'PJI_RM_SUM_AVL.START_RES_AVL_CALC_R2(p_worker_id);'
4658: )) THEN

Line 4700: PJI_PROCESS_UTIL.sleep(PJI_RM_SUM_MAIN.g_process_delay);

4696: END IF;
4697:
4698: IF(l_try_res_again = 'Y') THEN
4699: --Wait for some time and try again
4700: PJI_PROCESS_UTIL.sleep(PJI_RM_SUM_MAIN.g_process_delay);
4701: ELSE
4702: pji_utils.write2log(p_worker_id || ': R2: Before Calculating availability');
4703: CALCULATE_RES_AVL
4704: (

Line 4740: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');

4736: where nvl(WORKER_STATUS, 'X') <> 'C';
4737:
4738: if (l_row_count = 0) then
4739:
4740: l_parallel_processes := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_RM_SUM_MAIN.g_process, 'PARALLEL_PROCESSES');
4741:
4742: for x in 2 .. l_parallel_processes loop
4743:
4744: update PJI_SYSTEM_PRC_STATUS

Line 4755: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

4751: end loop;
4752:
4753: end if;
4754:
4755: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
4756: (
4757: l_process,
4758: 'PJI_RM_SUM_AVL.START_RES_AVL_CALC_R2(p_worker_id);'
4759: );

Line 4797: IF (NOT PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

4793: percent => 10,
4794: degree => BIS_COMMON_PARAMETERS.
4795: GET_DEGREE_OF_PARALLELISM);
4796:
4797: IF (NOT PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
4798: (
4799: l_process,
4800: 'PJI_RM_SUM_AVL.UPDATE_RES_STA_FOR_RUN2(p_worker_id);'
4801: )) THEN

Line 4830: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

4826: SET worker_id = null,
4827: worker_status = null;
4828: END IF;
4829:
4830: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
4831: (
4832: l_process,
4833: 'PJI_RM_SUM_AVL.UPDATE_RES_STA_FOR_RUN2(p_worker_id);'
4834: );

Line 4860: IF (NOT PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

4856: BEGIN
4857:
4858: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
4859:
4860: IF (NOT PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
4861: (
4862: l_process,
4863: 'PJI_RM_SUM_AVL.INS_INTO_RES_STATUS(p_worker_id);'
4864: )) THEN

Line 4894: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

4890: percent => 10,
4891: degree => BIS_COMMON_PARAMETERS.
4892: GET_DEGREE_OF_PARALLELISM);
4893:
4894: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
4895: (
4896: l_process,
4897: 'PJI_RM_SUM_AVL.INS_INTO_RES_STATUS(p_worker_id);'
4898: );

Line 4925: IF (NOT PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

4921: BEGIN
4922:
4923: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
4924:
4925: IF (NOT PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
4926: (
4927: l_process,
4928: 'PJI_RM_SUM_AVL.REFRESH_AV_ORGO_F_MV(p_worker_id);'
4929: )) THEN

Line 4932: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

4928: 'PJI_RM_SUM_AVL.REFRESH_AV_ORGO_F_MV(p_worker_id);'
4929: )) THEN
4930: RETURN;
4931: END IF;
4932: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
4933: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
4934:
4935: if (upper(nvl(FND_PROFILE.VALUE('PJI_USE_DBI_RSG'), 'N')) = 'Y' and
4936: l_extraction_type <> 'PARTIAL') then

Line 4981: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

4977: percent => 10,
4978: degree => l_p_degree);
4979: end if;
4980:
4981: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
4982: (
4983: l_process,
4984: 'PJI_RM_SUM_AVL.REFRESH_AV_ORGO_F_MV(p_worker_id);'
4985: );

Line 5012: IF (NOT PJI_PROCESS_UTIL.NEED_TO_RUN_STEP

5008: BEGIN
5009:
5010: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
5011:
5012: IF (NOT PJI_PROCESS_UTIL.NEED_TO_RUN_STEP
5013: (
5014: l_process,
5015: 'PJI_RM_SUM_AVL.REFRESH_CA_ORGO_F_MV(p_worker_id);'
5016: )) THEN

Line 5019: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER

5015: 'PJI_RM_SUM_AVL.REFRESH_CA_ORGO_F_MV(p_worker_id);'
5016: )) THEN
5017: RETURN;
5018: END IF;
5019: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
5020: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');
5021:
5022: if (upper(nvl(FND_PROFILE.VALUE('PJI_USE_DBI_RSG'), 'N')) = 'Y' and
5023: l_extraction_type <> 'PARTIAL') then

Line 5063: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION

5059: percent => 10,
5060: degree => l_p_degree);
5061: end if;
5062:
5063: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
5064: (
5065: l_process,
5066: 'PJI_RM_SUM_AVL.REFRESH_CA_ORGO_F_MV(p_worker_id);'
5067: );