DBA Data[Home] [Help]

APPS.AD_STATS_UTIL_PKG dependencies on FND_HISTOGRAM_COLS

Line 64: from FND_HISTOGRAM_COLS

60: if p_subsystem_code = 'PATCH_HIST' then
61: begin
62: select distinct('EXIST')
63: into exist_flag
64: from FND_HISTOGRAM_COLS
65: where application_id = 50
66: and table_name = 'AD_PATCH_COMMON_ACTIONS'
67: and column_name = 'ACTION_CODE';
68:

Line 75: column from FND_HISTOGRAM_COLS');

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');
76: end;
77:
78: -- Bug: 4661028. sgaruday
79: begin

Line 82: from FND_HISTOGRAM_COLS

78: -- Bug: 4661028. sgaruday
79: begin
80: select distinct('EXIST')
81: into exist_flag
82: from FND_HISTOGRAM_COLS
83: where application_id = 50
84: and table_name = 'AD_FILES'
85: and column_name = 'IS_FLAGGED_FILE';
86:

Line 93: column from FND_HISTOGRAM_COLS');

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');
94: end;
95: --
96:
97: fnd_stats.gather_table_stats(G_UN_FND, 'AD_RELEASES');