APPS.PJI_PJP_PRG_PERF_ALL dependencies on FND_STATS

Line 60: FND_STATS.GATHER_TABLE_STATS(

56:
57: BEGIN
58: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();
59: -- Gather table stats
60: FND_STATS.GATHER_TABLE_STATS(
61: ownname => p_ownname
62: , tabname => p_tabname
63: , percent => p_percent
64: , degree => l_degree);

Line 68: FND_STATS.GATHER_TABLE_STATS(

64: , degree => l_degree);
65:
66: IF p_partname IS NOT NULL THEN
67:
68: FND_STATS.GATHER_TABLE_STATS(
69: ownname => p_ownname
70: , tabname => p_tabname
71: , partname => p_partname
72: , percent => p_percent

Line 84: FND_STATS.GATHER_INDEX_STATS(ownname => p_ownname

80: FROM dba_indexes
81: WHERE table_name = p_tabname
82: AND table_owner = p_ownname) LOOP
83:
84: FND_STATS.GATHER_INDEX_STATS(ownname => p_ownname
85: ,indname => ind_lp.index_name
86: ,percent => p_percent
87: ,degree => l_degree);
88:

Line 90: FND_STATS.GATHER_INDEX_STATS(ownname => p_ownname

86: ,percent => p_percent
87: ,degree => l_degree);
88:
89: IF p_partname IS NOT NULL AND ind_lp.partitioned = 'YES' THEN
90: FND_STATS.GATHER_INDEX_STATS(ownname => p_ownname
91: ,indname => ind_lp.index_name
92: ,partname => p_partname
93: ,percent => p_percent
94: ,degree => l_degree);

Line 114: FND_STATS.GATHER_TABLE_STATS(

110:
111: BEGIN
112: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();
113: -- Gather table stats
114: FND_STATS.GATHER_TABLE_STATS(
115: ownname => p_ownname
116: , tabname => p_tabname
117: , percent => p_percent
118: , degree => l_degree);

Line 122: FND_STATS.GATHER_TABLE_STATS(

118: , degree => l_degree);
119:
120: IF p_partname IS NOT NULL THEN
121:
122: FND_STATS.GATHER_TABLE_STATS(
123: ownname => p_ownname
124: , tabname => p_tabname
125: , partname => p_partname
126: , percent => p_percent