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_ROLLUP_RES dependencies on PJI_UTILS

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

27: return;
28: end if;
29:
30: -- implicit commit
31: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
32: tabname => 'PJI_RES_DELTA',
33: percent => 10,
34: degree => BIS_COMMON_PARAMETERS.
35: GET_DEGREE_OF_PARALLELISM);

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

33: percent => 10,
34: degree => BIS_COMMON_PARAMETERS.
35: GET_DEGREE_OF_PARALLELISM);
36: -- implicit commit
37: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
38: tabname => 'PJI_RES_DELTA',
39: colname => 'CHANGE_TYPE',
40: percent => 10,
41: degree => BIS_COMMON_PARAMETERS.

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

40: percent => 10,
41: degree => BIS_COMMON_PARAMETERS.
42: GET_DEGREE_OF_PARALLELISM);
43: -- implicit commit
44: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
45: tabname => 'PJI_RES_DELTA',
46: colname => 'RESOURCE_ID',
47: percent => 10,
48: degree => BIS_COMMON_PARAMETERS.

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

47: percent => 10,
48: degree => BIS_COMMON_PARAMETERS.
49: GET_DEGREE_OF_PARALLELISM);
50: -- implicit commit
51: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
52: tabname => 'PJI_RES_DELTA',
53: colname => 'PERSON_ID',
54: percent => 10,
55: degree => BIS_COMMON_PARAMETERS.

Line 2399: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME,

2395: l_process,
2396: 'PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMR(p_worker_id);'
2397: );
2398:
2399: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME,
2400: 'PJI_RM_AGGR_RES1','NORMAL',null);
2401:
2402: commit;
2403:

Line 3117: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME,

3113: l_process,
3114: 'PJI_RM_SUM_ROLLUP_RES.CLEANUP_RMS(p_worker_id);'
3115: );
3116:
3117: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME,
3118: 'PJI_RM_AGGR_RES2','NORMAL',null);
3119:
3120: commit;
3121:

Line 3159: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

3155: l_extraction_type <> 'PARTIAL') then
3156: return;
3157: end if;
3158:
3159: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
3160: l_apps_schema := PJI_UTILS.GET_APPS_SCHEMA_NAME;
3161: l_p_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();
3162: if (l_p_degree = 1) then
3163: l_p_degree := 0;

Line 3160: l_apps_schema := PJI_UTILS.GET_APPS_SCHEMA_NAME;

3156: return;
3157: end if;
3158:
3159: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
3160: l_apps_schema := PJI_UTILS.GET_APPS_SCHEMA_NAME;
3161: l_p_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();
3162: if (l_p_degree = 1) then
3163: l_p_degree := 0;
3164: end if;

Line 3261: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

3257: l_extraction_type <> 'PARTIAL') then
3258: return;
3259: end if;
3260:
3261: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
3262: l_apps_schema := PJI_UTILS.GET_APPS_SCHEMA_NAME;
3263: l_p_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();
3264: if (l_p_degree = 1) then
3265: l_p_degree := 0;

Line 3262: l_apps_schema := PJI_UTILS.GET_APPS_SCHEMA_NAME;

3258: return;
3259: end if;
3260:
3261: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
3262: l_apps_schema := PJI_UTILS.GET_APPS_SCHEMA_NAME;
3263: l_p_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();
3264: if (l_p_degree = 1) then
3265: l_p_degree := 0;
3266: end if;

Line 3355: l_apps_schema := PJI_UTILS.GET_APPS_SCHEMA_NAME;

3351: l_extraction_type <> 'PARTIAL') then
3352: return;
3353: end if;
3354:
3355: l_apps_schema := PJI_UTILS.GET_APPS_SCHEMA_NAME;
3356: l_p_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();
3357: if (l_p_degree = 1) then
3358: l_p_degree := 0;
3359: end if;

Line 3443: l_apps_schema := PJI_UTILS.GET_APPS_SCHEMA_NAME;

3439: l_extraction_type <> 'PARTIAL') then
3440: return;
3441: end if;
3442:
3443: l_apps_schema := PJI_UTILS.GET_APPS_SCHEMA_NAME;
3444: l_p_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();
3445: if (l_p_degree = 1) then
3446: l_p_degree := 0;
3447: end if;

Line 3504: l_apps_schema := PJI_UTILS.GET_APPS_SCHEMA_NAME;

3500: l_extraction_type <> 'PARTIAL') then
3501: return;
3502: end if;
3503:
3504: l_apps_schema := PJI_UTILS.GET_APPS_SCHEMA_NAME;
3505: l_p_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();
3506: if (l_p_degree = 1) then
3507: l_p_degree := 0;
3508: end if;

Line 3565: l_apps_schema := PJI_UTILS.GET_APPS_SCHEMA_NAME;

3561: l_extraction_type <> 'PARTIAL') then
3562: return;
3563: end if;
3564:
3565: l_apps_schema := PJI_UTILS.GET_APPS_SCHEMA_NAME;
3566: l_p_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();
3567: if (l_p_degree = 1) then
3568: l_p_degree := 0;
3569: end if;

Line 3602: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

3598: l_schema varchar2(30);
3599:
3600: begin
3601:
3602: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
3603:
3604: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
3605: 'PJI_RM_AGGR_RES1','NORMAL',null);
3606: