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.AD_STATS_UTIL_PKG dependencies on FND_STATS

Line 71: fnd_stats.load_histogram_cols('INSERT', 50, 'AD_PATCH_COMMON_ACTIONS',

67: and column_name = 'ACTION_CODE';
68:
69: exception
70: when no_data_found then
71: fnd_stats.load_histogram_cols('INSERT', 50, 'AD_PATCH_COMMON_ACTIONS',
72: 'ACTION_CODE',NULL, hsize=>250);
73: when others then
74: raise_application_error(-20000 ,sqlerrm||': Error getting hisotgram
75: column from FND_HISTOGRAM_COLS');

Line 89: fnd_stats.load_histogram_cols('INSERT', 50, 'AD_FILES',

85: and column_name = 'IS_FLAGGED_FILE';
86:
87: exception
88: when no_data_found then
89: fnd_stats.load_histogram_cols('INSERT', 50, 'AD_FILES',
90: 'IS_FLAGGED_FILE', NULL, hsize=>250);
91: when others then
92: raise_application_error(-20000 ,sqlerrm||': Error getting hisotgram
93: column from FND_HISTOGRAM_COLS');

Line 97: fnd_stats.gather_table_stats(G_UN_FND, 'AD_RELEASES');

93: column from FND_HISTOGRAM_COLS');
94: end;
95: --
96:
97: fnd_stats.gather_table_stats(G_UN_FND, 'AD_RELEASES');
98: fnd_stats.gather_table_stats(G_UN_FND, 'AD_APPL_TOPS');
99: fnd_stats.gather_table_stats(G_UN_FND, 'AD_APPLIED_PATCHES');
100: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVERS');
101: fnd_stats.gather_table_stats(G_UN_FND, 'AD_COMPRISING_PATCHES');

Line 98: fnd_stats.gather_table_stats(G_UN_FND, 'AD_APPL_TOPS');

94: end;
95: --
96:
97: fnd_stats.gather_table_stats(G_UN_FND, 'AD_RELEASES');
98: fnd_stats.gather_table_stats(G_UN_FND, 'AD_APPL_TOPS');
99: fnd_stats.gather_table_stats(G_UN_FND, 'AD_APPLIED_PATCHES');
100: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVERS');
101: fnd_stats.gather_table_stats(G_UN_FND, 'AD_COMPRISING_PATCHES');
102: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVER_MINIPKS');

Line 99: fnd_stats.gather_table_stats(G_UN_FND, 'AD_APPLIED_PATCHES');

95: --
96:
97: fnd_stats.gather_table_stats(G_UN_FND, 'AD_RELEASES');
98: fnd_stats.gather_table_stats(G_UN_FND, 'AD_APPL_TOPS');
99: fnd_stats.gather_table_stats(G_UN_FND, 'AD_APPLIED_PATCHES');
100: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVERS');
101: fnd_stats.gather_table_stats(G_UN_FND, 'AD_COMPRISING_PATCHES');
102: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVER_MINIPKS');
103: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVER_LANGS');

Line 100: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVERS');

96:
97: fnd_stats.gather_table_stats(G_UN_FND, 'AD_RELEASES');
98: fnd_stats.gather_table_stats(G_UN_FND, 'AD_APPL_TOPS');
99: fnd_stats.gather_table_stats(G_UN_FND, 'AD_APPLIED_PATCHES');
100: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVERS');
101: fnd_stats.gather_table_stats(G_UN_FND, 'AD_COMPRISING_PATCHES');
102: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVER_MINIPKS');
103: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVER_LANGS');
104: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUNS');

Line 101: fnd_stats.gather_table_stats(G_UN_FND, 'AD_COMPRISING_PATCHES');

97: fnd_stats.gather_table_stats(G_UN_FND, 'AD_RELEASES');
98: fnd_stats.gather_table_stats(G_UN_FND, 'AD_APPL_TOPS');
99: fnd_stats.gather_table_stats(G_UN_FND, 'AD_APPLIED_PATCHES');
100: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVERS');
101: fnd_stats.gather_table_stats(G_UN_FND, 'AD_COMPRISING_PATCHES');
102: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVER_MINIPKS');
103: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVER_LANGS');
104: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUNS');
105: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUN_BUGS');

Line 102: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVER_MINIPKS');

98: fnd_stats.gather_table_stats(G_UN_FND, 'AD_APPL_TOPS');
99: fnd_stats.gather_table_stats(G_UN_FND, 'AD_APPLIED_PATCHES');
100: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVERS');
101: fnd_stats.gather_table_stats(G_UN_FND, 'AD_COMPRISING_PATCHES');
102: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVER_MINIPKS');
103: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVER_LANGS');
104: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUNS');
105: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUN_BUGS');
106: fnd_stats.gather_table_stats(G_UN_FND, 'AD_BUGS');

Line 103: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVER_LANGS');

99: fnd_stats.gather_table_stats(G_UN_FND, 'AD_APPLIED_PATCHES');
100: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVERS');
101: fnd_stats.gather_table_stats(G_UN_FND, 'AD_COMPRISING_PATCHES');
102: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVER_MINIPKS');
103: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVER_LANGS');
104: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUNS');
105: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUN_BUGS');
106: fnd_stats.gather_table_stats(G_UN_FND, 'AD_BUGS');
107: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_COMMON_ACTIONS');

Line 104: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUNS');

100: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVERS');
101: fnd_stats.gather_table_stats(G_UN_FND, 'AD_COMPRISING_PATCHES');
102: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVER_MINIPKS');
103: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVER_LANGS');
104: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUNS');
105: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUN_BUGS');
106: fnd_stats.gather_table_stats(G_UN_FND, 'AD_BUGS');
107: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_COMMON_ACTIONS');
108: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUN_BUG_ACTIONS');

Line 105: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUN_BUGS');

101: fnd_stats.gather_table_stats(G_UN_FND, 'AD_COMPRISING_PATCHES');
102: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVER_MINIPKS');
103: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVER_LANGS');
104: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUNS');
105: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUN_BUGS');
106: fnd_stats.gather_table_stats(G_UN_FND, 'AD_BUGS');
107: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_COMMON_ACTIONS');
108: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUN_BUG_ACTIONS');
109: fnd_stats.gather_table_stats(G_UN_FND, 'AD_FILE_VERSIONS');

Line 106: fnd_stats.gather_table_stats(G_UN_FND, 'AD_BUGS');

102: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVER_MINIPKS');
103: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVER_LANGS');
104: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUNS');
105: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUN_BUGS');
106: fnd_stats.gather_table_stats(G_UN_FND, 'AD_BUGS');
107: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_COMMON_ACTIONS');
108: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUN_BUG_ACTIONS');
109: fnd_stats.gather_table_stats(G_UN_FND, 'AD_FILE_VERSIONS');
110: fnd_stats.gather_table_stats(G_UN_FND, 'AD_FILES');

Line 107: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_COMMON_ACTIONS');

103: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_DRIVER_LANGS');
104: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUNS');
105: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUN_BUGS');
106: fnd_stats.gather_table_stats(G_UN_FND, 'AD_BUGS');
107: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_COMMON_ACTIONS');
108: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUN_BUG_ACTIONS');
109: fnd_stats.gather_table_stats(G_UN_FND, 'AD_FILE_VERSIONS');
110: fnd_stats.gather_table_stats(G_UN_FND, 'AD_FILES');
111: elsif p_subsystem_code = 'SNAPSHOT' then

Line 108: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUN_BUG_ACTIONS');

104: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUNS');
105: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUN_BUGS');
106: fnd_stats.gather_table_stats(G_UN_FND, 'AD_BUGS');
107: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_COMMON_ACTIONS');
108: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUN_BUG_ACTIONS');
109: fnd_stats.gather_table_stats(G_UN_FND, 'AD_FILE_VERSIONS');
110: fnd_stats.gather_table_stats(G_UN_FND, 'AD_FILES');
111: elsif p_subsystem_code = 'SNAPSHOT' then
112: fnd_stats.gather_table_stats(G_UN_FND, 'AD_SNAPSHOTS');

Line 109: fnd_stats.gather_table_stats(G_UN_FND, 'AD_FILE_VERSIONS');

105: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUN_BUGS');
106: fnd_stats.gather_table_stats(G_UN_FND, 'AD_BUGS');
107: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_COMMON_ACTIONS');
108: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUN_BUG_ACTIONS');
109: fnd_stats.gather_table_stats(G_UN_FND, 'AD_FILE_VERSIONS');
110: fnd_stats.gather_table_stats(G_UN_FND, 'AD_FILES');
111: elsif p_subsystem_code = 'SNAPSHOT' then
112: fnd_stats.gather_table_stats(G_UN_FND, 'AD_SNAPSHOTS');
113: fnd_stats.gather_table_stats(G_UN_FND, 'AD_SNAPSHOT_BUGFIXES');

Line 110: fnd_stats.gather_table_stats(G_UN_FND, 'AD_FILES');

106: fnd_stats.gather_table_stats(G_UN_FND, 'AD_BUGS');
107: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_COMMON_ACTIONS');
108: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUN_BUG_ACTIONS');
109: fnd_stats.gather_table_stats(G_UN_FND, 'AD_FILE_VERSIONS');
110: fnd_stats.gather_table_stats(G_UN_FND, 'AD_FILES');
111: elsif p_subsystem_code = 'SNAPSHOT' then
112: fnd_stats.gather_table_stats(G_UN_FND, 'AD_SNAPSHOTS');
113: fnd_stats.gather_table_stats(G_UN_FND, 'AD_SNAPSHOT_BUGFIXES');
114: fnd_stats.gather_table_stats(G_UN_FND, 'AD_SNAPSHOT_FILES');

Line 112: fnd_stats.gather_table_stats(G_UN_FND, 'AD_SNAPSHOTS');

108: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUN_BUG_ACTIONS');
109: fnd_stats.gather_table_stats(G_UN_FND, 'AD_FILE_VERSIONS');
110: fnd_stats.gather_table_stats(G_UN_FND, 'AD_FILES');
111: elsif p_subsystem_code = 'SNAPSHOT' then
112: fnd_stats.gather_table_stats(G_UN_FND, 'AD_SNAPSHOTS');
113: fnd_stats.gather_table_stats(G_UN_FND, 'AD_SNAPSHOT_BUGFIXES');
114: fnd_stats.gather_table_stats(G_UN_FND, 'AD_SNAPSHOT_FILES');
115: elsif p_subsystem_code = 'TASK_TIMING' then
116: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PROGRAM_RUN_TASKS');

Line 113: fnd_stats.gather_table_stats(G_UN_FND, 'AD_SNAPSHOT_BUGFIXES');

109: fnd_stats.gather_table_stats(G_UN_FND, 'AD_FILE_VERSIONS');
110: fnd_stats.gather_table_stats(G_UN_FND, 'AD_FILES');
111: elsif p_subsystem_code = 'SNAPSHOT' then
112: fnd_stats.gather_table_stats(G_UN_FND, 'AD_SNAPSHOTS');
113: fnd_stats.gather_table_stats(G_UN_FND, 'AD_SNAPSHOT_BUGFIXES');
114: fnd_stats.gather_table_stats(G_UN_FND, 'AD_SNAPSHOT_FILES');
115: elsif p_subsystem_code = 'TASK_TIMING' then
116: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PROGRAM_RUN_TASKS');
117: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PROGRAM_RUN_TASK_JOBS');

Line 114: fnd_stats.gather_table_stats(G_UN_FND, 'AD_SNAPSHOT_FILES');

110: fnd_stats.gather_table_stats(G_UN_FND, 'AD_FILES');
111: elsif p_subsystem_code = 'SNAPSHOT' then
112: fnd_stats.gather_table_stats(G_UN_FND, 'AD_SNAPSHOTS');
113: fnd_stats.gather_table_stats(G_UN_FND, 'AD_SNAPSHOT_BUGFIXES');
114: fnd_stats.gather_table_stats(G_UN_FND, 'AD_SNAPSHOT_FILES');
115: elsif p_subsystem_code = 'TASK_TIMING' then
116: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PROGRAM_RUN_TASKS');
117: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PROGRAM_RUN_TASK_JOBS');
118: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUN_SESS_ATTRIBS');

Line 116: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PROGRAM_RUN_TASKS');

112: fnd_stats.gather_table_stats(G_UN_FND, 'AD_SNAPSHOTS');
113: fnd_stats.gather_table_stats(G_UN_FND, 'AD_SNAPSHOT_BUGFIXES');
114: fnd_stats.gather_table_stats(G_UN_FND, 'AD_SNAPSHOT_FILES');
115: elsif p_subsystem_code = 'TASK_TIMING' then
116: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PROGRAM_RUN_TASKS');
117: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PROGRAM_RUN_TASK_JOBS');
118: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUN_SESS_ATTRIBS');
119: else
120: raise_application_error(-20000, 'Invalid p_subsystem_code: '||

Line 117: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PROGRAM_RUN_TASK_JOBS');

113: fnd_stats.gather_table_stats(G_UN_FND, 'AD_SNAPSHOT_BUGFIXES');
114: fnd_stats.gather_table_stats(G_UN_FND, 'AD_SNAPSHOT_FILES');
115: elsif p_subsystem_code = 'TASK_TIMING' then
116: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PROGRAM_RUN_TASKS');
117: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PROGRAM_RUN_TASK_JOBS');
118: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUN_SESS_ATTRIBS');
119: else
120: raise_application_error(-20000, 'Invalid p_subsystem_code: '||
121: p_subsystem_code);

Line 118: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUN_SESS_ATTRIBS');

114: fnd_stats.gather_table_stats(G_UN_FND, 'AD_SNAPSHOT_FILES');
115: elsif p_subsystem_code = 'TASK_TIMING' then
116: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PROGRAM_RUN_TASKS');
117: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PROGRAM_RUN_TASK_JOBS');
118: fnd_stats.gather_table_stats(G_UN_FND, 'AD_PATCH_RUN_SESS_ATTRIBS');
119: else
120: raise_application_error(-20000, 'Invalid p_subsystem_code: '||
121: p_subsystem_code);
122: end if;