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_UTILS

Line 175: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

171: );
172: END LOOP;
173:
174: -- implicit commit
175: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
176: tabname => 'PJI_ROLL_WEEK_OFFSET',
177: percent => 100,
178: degree => 1);
179:

Line 4454: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL1');

4450: )) THEN
4451: RETURN;
4452: END IF;
4453:
4454: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL1');
4455:
4456: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL2');
4457:
4458: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL3');

Line 4456: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL2');

4452: END IF;
4453:
4454: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL1');
4455:
4456: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL2');
4457:
4458: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL3');
4459:
4460: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL4');

Line 4458: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL3');

4454: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL1');
4455:
4456: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL2');
4457:
4458: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL3');
4459:
4460: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL4');
4461:
4462: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL5');

Line 4460: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL4');

4456: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL2');
4457:
4458: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL3');
4459:
4460: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL4');
4461:
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');

Line 4462: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL5');

4458: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL3');
4459:
4460: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL4');
4461:
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

Line 4464: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_RES_BATCH_MAP');

4460: execute immediate ('truncate table ' || PJI_UTILS.get_pji_schema_name || '.PJI_RM_AGGR_AVL4');
4461:
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,

Line 4530: pji_utils.write2log(p_worker_id || ': R1: Before updating PJI_RM_RES_BATCH_MAP and returning resource id');

4526:
4527: FOR i in 1.. l_count_res_status
4528: LOOP
4529: l_try_res_again := 'N';
4530: pji_utils.write2log(p_worker_id || ': R1: Before updating PJI_RM_RES_BATCH_MAP and returning resource id');
4531: UPDATE PJI_RM_RES_BATCH_MAP
4532: SET worker_id = p_worker_id
4533: WHERE worker_status IS NULL
4534: and worker_id IS NULL

Line 4538: pji_utils.write2log(p_worker_id || ': R1: After updating PJI_RM_RES_BATCH_MAP and returning resource id');

4534: and worker_id IS NULL
4535: and rownum < 2
4536: RETURNING person_id
4537: INTO l_person_id;
4538: pji_utils.write2log(p_worker_id || ': R1: After updating PJI_RM_RES_BATCH_MAP and returning resource id');
4539: IF SQL%ROWCOUNT <> 0 THEN
4540: COMMIT;
4541: ELSE
4542: CALC_CURR_RES_COUNT;

Line 4554: pji_utils.write2log(p_worker_id || ': R1: Before Calculating availability');

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: (
4557: p_worker_id => p_worker_id,
4558: p_person_id => l_person_id,

Line 4562: pji_utils.write2log(p_worker_id || ': R1: After Calculating availability');

4558: p_person_id => l_person_id,
4559: p_run_mode => 'OLD_FACT_RECORDS',
4560: x_return_status => l_return_status
4561: );
4562: pji_utils.write2log(p_worker_id || ': R1: After Calculating availability');
4563: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4564: /*
4565: UPDATE PJI_RM_RES_BATCH_MAP
4566: SET worker_id = null

Line 4574: pji_utils.write2log(p_worker_id || ': R1: Before Updating PJI_RM_RES_BATCH_MAP for completion');

4570: */
4571: --Raise the error here
4572: raise RAISE_USER_DEF_EXCEPTION;
4573: ELSE
4574: pji_utils.write2log(p_worker_id || ': R1: Before Updating PJI_RM_RES_BATCH_MAP for completion');
4575: UPDATE PJI_RM_RES_BATCH_MAP
4576: SET worker_status = 'C'
4577: WHERE person_id = l_person_id
4578: and worker_id = p_worker_id;

Line 4579: pji_utils.write2log(p_worker_id || ': R1: After Updating PJI_RM_RES_BATCH_MAP for completion');

4575: UPDATE PJI_RM_RES_BATCH_MAP
4576: SET worker_status = 'C'
4577: WHERE person_id = l_person_id
4578: and worker_id = p_worker_id;
4579: pji_utils.write2log(p_worker_id || ': R1: After Updating PJI_RM_RES_BATCH_MAP for completion');
4580: COMMIT;
4581: END IF;
4582: END IF;
4583: END LOOP;

Line 4678: pji_utils.write2log(p_worker_id || ': R2: Before updating PJI_RM_RES_BATCH_MAP and returning resource id');

4674:
4675: FOR i in 1.. l_count_res_status
4676: LOOP
4677: l_try_res_again := 'N';
4678: pji_utils.write2log(p_worker_id || ': R2: Before updating PJI_RM_RES_BATCH_MAP and returning resource id');
4679: UPDATE PJI_RM_RES_BATCH_MAP
4680: SET worker_id = p_worker_id
4681: WHERE worker_status IS NULL
4682: and worker_id IS NULL

Line 4686: pji_utils.write2log(p_worker_id || ': R2: After updating PJI_RM_RES_BATCH_MAP and returning resource id');

4682: and worker_id IS NULL
4683: and rownum < 2
4684: RETURNING person_id
4685: INTO l_person_id;
4686: pji_utils.write2log(p_worker_id || ': R2: After updating PJI_RM_RES_BATCH_MAP and returning resource id');
4687: IF SQL%ROWCOUNT <> 0 THEN
4688: COMMIT;
4689: ELSE
4690: CALC_CURR_RES_COUNT;

Line 4702: pji_utils.write2log(p_worker_id || ': R2: Before Calculating availability');

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: (
4705: p_worker_id => p_worker_id,
4706: p_person_id => l_person_id,

Line 4710: pji_utils.write2log(p_worker_id || ': R2: After Calculating availability');

4706: p_person_id => l_person_id,
4707: p_run_mode => 'NEW_FACT_RECORDS',
4708: x_return_status => l_return_status
4709: );
4710: pji_utils.write2log(p_worker_id || ': R2: After Calculating availability');
4711: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4712: /*
4713: UPDATE PJI_RM_RES_BATCH_MAP
4714: SET worker_id = null

Line 4722: pji_utils.write2log(p_worker_id || ': R2: Before Updating PJI_RM_RES_BATCH_MAP for completion');

4718: */
4719: --Raise the error here
4720: raise RAISE_USER_DEF_EXCEPTION;
4721: ELSE
4722: pji_utils.write2log(p_worker_id || ': R2: Before Updating PJI_RM_RES_BATCH_MAP for completion');
4723: UPDATE PJI_RM_RES_BATCH_MAP
4724: SET worker_status = 'C'
4725: WHERE person_id = l_person_id
4726: and worker_id = p_worker_id;

Line 4727: pji_utils.write2log(p_worker_id || ': R2: After Updating PJI_RM_RES_BATCH_MAP for completion');

4723: UPDATE PJI_RM_RES_BATCH_MAP
4724: SET worker_status = 'C'
4725: WHERE person_id = l_person_id
4726: and worker_id = p_worker_id;
4727: pji_utils.write2log(p_worker_id || ': R2: After Updating PJI_RM_RES_BATCH_MAP for completion');
4728: COMMIT;
4729: END IF;
4730: END IF;
4731: END LOOP;

Line 4784: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

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',
4786: percent => 10,
4787: degree => BIS_COMMON_PARAMETERS.
4788: GET_DEGREE_OF_PARALLELISM);

Line 4790: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

4786: percent => 10,
4787: degree => BIS_COMMON_PARAMETERS.
4788: GET_DEGREE_OF_PARALLELISM);
4789: -- implicit commit
4790: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
4791: tabname => 'PJI_RM_AGGR_RES2',
4792: colname => 'PERSON_ID',
4793: percent => 10,
4794: degree => BIS_COMMON_PARAMETERS.

Line 4881: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

4877: SELECT DISTINCT person_id from PJI_RM_AGGR_RES2;
4878: END IF;
4879:
4880: -- implicit commit
4881: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
4882: tabname => 'PJI_RM_RES_BATCH_MAP',
4883: percent => 10,
4884: degree => BIS_COMMON_PARAMETERS.
4885: GET_DEGREE_OF_PARALLELISM);

Line 4887: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

4883: percent => 10,
4884: degree => BIS_COMMON_PARAMETERS.
4885: GET_DEGREE_OF_PARALLELISM);
4886: -- implicit commit
4887: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
4888: tabname => 'PJI_RM_RES_BATCH_MAP',
4889: colname => 'PERSON_ID',
4890: percent => 10,
4891: degree => BIS_COMMON_PARAMETERS.

Line 4940: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

4936: l_extraction_type <> 'PARTIAL') then
4937: return;
4938: end if;
4939:
4940: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
4941: l_apps_schema := PJI_UTILS.GET_APPS_SCHEMA_NAME;
4942: l_p_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();
4943: if (l_p_degree = 1) then
4944: l_p_degree := 0;

Line 4941: l_apps_schema := PJI_UTILS.GET_APPS_SCHEMA_NAME;

4937: return;
4938: end if;
4939:
4940: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
4941: l_apps_schema := PJI_UTILS.GET_APPS_SCHEMA_NAME;
4942: l_p_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();
4943: if (l_p_degree = 1) then
4944: l_p_degree := 0;
4945: end if;

Line 5027: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

5023: l_extraction_type <> 'PARTIAL') then
5024: return;
5025: end if;
5026:
5027: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
5028: l_apps_schema := PJI_UTILS.GET_APPS_SCHEMA_NAME;
5029: l_p_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();
5030: if (l_p_degree = 1) then
5031: l_p_degree := 0;

Line 5028: l_apps_schema := PJI_UTILS.GET_APPS_SCHEMA_NAME;

5024: return;
5025: end if;
5026:
5027: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
5028: l_apps_schema := PJI_UTILS.GET_APPS_SCHEMA_NAME;
5029: l_p_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();
5030: if (l_p_degree = 1) then
5031: l_p_degree := 0;
5032: end if;