APPS.AD_STATS_UTIL_PKG dependencies on AD_TIMESTAMPS

Line 184: from ad_timestamps

180: nvl(to_number(attribute2), 0)
181: into
182: l_count_when_last_analyzed,
183: l_count_till_last_run
184: from ad_timestamps
185: where type = 'COUNTS_FOR_ANALYZE'
186: and attribute = p_subsystem_code;
187:
188: l_found := TRUE;

Line 212: -- AD_TIMESTAMPS.

208:
209: p_gathered_stats_flag := TRUE;
210:
211: -- save both counts (count-till-date and count-when-last-analyzed) in
212: -- AD_TIMESTAMPS.
213:
214: update ad_timestamps
215: set attribute1 = to_char(l_newcount),
216: attribute2 = to_char(l_newcount),

Line 214: update ad_timestamps

210:
211: -- save both counts (count-till-date and count-when-last-analyzed) in
212: -- AD_TIMESTAMPS.
213:
214: update ad_timestamps
215: set attribute1 = to_char(l_newcount),
216: attribute2 = to_char(l_newcount),
217: timestamp = sysdate
218: where type = 'COUNTS_FOR_ANALYZE'

Line 223: -- save (only) the count-till-date in AD_TIMESTAMPS.

219: and attribute = p_subsystem_code;
220:
221: else
222:
223: -- save (only) the count-till-date in AD_TIMESTAMPS.
224:
225: update ad_timestamps
226: set attribute2 = to_char(l_newcount),
227: timestamp = sysdate

Line 225: update ad_timestamps

221: else
222:
223: -- save (only) the count-till-date in AD_TIMESTAMPS.
224:
225: update ad_timestamps
226: set attribute2 = to_char(l_newcount),
227: timestamp = sysdate
228: where type = 'COUNTS_FOR_ANALYZE'
229: and attribute = p_subsystem_code;

Line 253: insert into ad_timestamps

249: l_count_when_last_analyzed := l_newcount;
250: end if;
251:
252: begin
253: insert into ad_timestamps
254: (
255: type, attribute, timestamp,
256: attribute1, attribute2
257: ) values