APPS.PJI_RM_SUM_ROLLUP_RES dependencies on BIS_COMMON_PARAMETERS

Line 34: degree => BIS_COMMON_PARAMETERS.

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);
36: -- implicit commit
37: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
38: tabname => 'PJI_RES_DELTA',

Line 41: degree => BIS_COMMON_PARAMETERS.

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.
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',

Line 48: degree => BIS_COMMON_PARAMETERS.

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.
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',

Line 55: degree => BIS_COMMON_PARAMETERS.

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.
56: GET_DEGREE_OF_PARALLELISM);
57:
58: select count(*)
59: into l_row_count

Line 3161: l_p_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();

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;
3165:

Line 3263: l_p_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();

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;
3267:

Line 3356: l_p_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();

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;
3360:

Line 3444: l_p_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();

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;
3448:

Line 3505: l_p_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();

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;
3509:

Line 3566: l_p_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();

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;
3570: