DBA Data[Home] [Help]

APPS.PJI_RM_SUM_AVL dependencies on PJI_RM_SUM_MAIN

Line 4073: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

4069: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
4070: l_process VARCHAR2(30);
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,

Line 4297: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

4293: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
4294: l_process VARCHAR2(30);
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,

Line 4444: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

4440: IS
4441: --Defining local variables
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,

Line 4506: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

4502: --PHASE 2
4503: --PHASE 3
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,

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 4598: where PROCESS_NAME = PJI_RM_SUM_MAIN.g_process || to_char(x)

4594: for x in 2 .. l_parallel_processes loop
4595:
4596: update PJI_SYSTEM_PRC_STATUS
4597: set STEP_STATUS = 'C'
4598: where PROCESS_NAME = PJI_RM_SUM_MAIN.g_process || to_char(x)
4599: and STEP_NAME = 'PJI_RM_SUM_AVL.START_RES_AVL_CALC_R1(p_worker_id);';
4600:
4601: commit;
4602:

Line 4652: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

4648: --PHASE 2
4649: --PHASE 3
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,

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 4746: where PROCESS_NAME = PJI_RM_SUM_MAIN.g_process || to_char(x)

4742: for x in 2 .. l_parallel_processes loop
4743:
4744: update PJI_SYSTEM_PRC_STATUS
4745: set STEP_STATUS = 'C'
4746: where PROCESS_NAME = PJI_RM_SUM_MAIN.g_process || to_char(x)
4747: and STEP_NAME = 'PJI_RM_SUM_AVL.START_RES_AVL_CALC_R2(p_worker_id);';
4748:
4749: commit;
4750:

Line 4781: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

4777: l_res_process_cnt NUMBER(15):=0;
4778: l_res_full_cnt NUMBER(15):=0;
4779: BEGIN
4780:
4781: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);
4782:
4783: -- implicit commit
4784: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
4785: tabname => 'PJI_RM_AGGR_RES2',

Line 4858: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

4854: l_process VARCHAR2(30);
4855: l_count_res_status NUMBER := 0;
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,

Line 4923: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

4919: l_errbuf varchar2(255);
4920: l_retcode varchar2(255);
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,

Line 4933: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');

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
4937: return;

Line 5010: l_process := PJI_RM_SUM_MAIN.g_process || to_char(p_worker_id);

5006: l_errbuf varchar2(255);
5007: l_retcode varchar2(255);
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,

Line 5020: (PJI_RM_SUM_MAIN.g_process, 'EXTRACTION_TYPE');

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
5024: return;