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.IBW_PURGE_PVT dependencies on IBW_SITE_VISITS

Line 17: -- IBW_SITE_VISITS, IBW_VISITORS, IBW_PAGE_INSTANCES.

13: -- Private API for purging transaction data
14: --
15: -- NOTES
16: -- Administrator uses this program to purge the transaction data. The tables which will be purged are IBW_PAGE_VIEWS,
17: -- IBW_SITE_VISITS, IBW_VISITORS, IBW_PAGE_INSTANCES.
18:
19: -- HISTORY
20: -- 05/10/2005 VEKANCHA Created
21:

Line 55: SELECT COUNT(distinct(visit_id)) into visit_count FROM ibw_site_visits

51: page_view_count NUMBER;
52:
53: BEGIN
54:
55: SELECT COUNT(distinct(visit_id)) into visit_count FROM ibw_site_visits
56: WHERE visit_start_time BETWEEN start_date AND end_date;
57:
58: /** purge ibw_site_visits */
59: DELETE FROM ibw_site_visits

Line 58: /** purge ibw_site_visits */

54:
55: SELECT COUNT(distinct(visit_id)) into visit_count FROM ibw_site_visits
56: WHERE visit_start_time BETWEEN start_date AND end_date;
57:
58: /** purge ibw_site_visits */
59: DELETE FROM ibw_site_visits
60: WHERE visit_start_time between start_date AND end_date;
61:
62:

Line 59: DELETE FROM ibw_site_visits

55: SELECT COUNT(distinct(visit_id)) into visit_count FROM ibw_site_visits
56: WHERE visit_start_time BETWEEN start_date AND end_date;
57:
58: /** purge ibw_site_visits */
59: DELETE FROM ibw_site_visits
60: WHERE visit_start_time between start_date AND end_date;
61:
62:
63:

Line 66: FROM ibw_site_visits v

62:
63:
64: SELECT count(page_view_id)into page_view_count FROM ibw_page_views pv
65: WHERE 0 = (SELECT COUNT(visit_id)
66: FROM ibw_site_visits v
67: WHERE v.visit_id=pv.visit_id);
68:
69: /** purge ibw_page_views */
70: DELETE FROM ibw_page_views pv

Line 72: FROM ibw_site_visits v

68:
69: /** purge ibw_page_views */
70: DELETE FROM ibw_page_views pv
71: WHERE 0 = (SELECT COUNT(visit_id)
72: FROM ibw_site_visits v
73: WHERE v.visit_id=pv.visit_id);
74:
75: /** purge ibw_page_views_tmp */
76: DELETE FROM ibw_page_views_tmp pv

Line 78: FROM ibw_site_visits v

74:
75: /** purge ibw_page_views_tmp */
76: DELETE FROM ibw_page_views_tmp pv
77: WHERE 0 = (SELECT COUNT(visit_id)
78: FROM ibw_site_visits v
79: WHERE v.visit_id=pv.visit_id);
80:
81:
82: SELECT count(visitor_id) into visitor_count FROM ibw_visitors visitors

Line 84: FROM ibw_site_visits visit

80:
81:
82: SELECT count(visitor_id) into visitor_count FROM ibw_visitors visitors
83: WHERE 0 = (SELECT COUNT(visitor_id)
84: FROM ibw_site_visits visit
85: WHERE visit.visitor_id=visitors.visitor_id);
86:
87: /** purge ibw_visitors */
88: DELETE FROM ibw_visitors visitors

Line 90: FROM ibw_site_visits visit

86:
87: /** purge ibw_visitors */
88: DELETE FROM ibw_visitors visitors
89: WHERE 0 = (SELECT COUNT(visitor_id)
90: FROM ibw_site_visits visit
91: WHERE visit.visitor_id=visitors.visitor_id);
92:
93: /** purge ibw_page_instances */
94: DELETE FROM ibw_page_instances pi

Line 125: /** purge ibw_site_visits */

121: page_instance_count NUMBER;
122:
123: BEGIN
124:
125: /** purge ibw_site_visits */
126: SELECT COUNT(distinct(site_visit_id)) cnt INTO visit_count
127: FROM ibw_site_visits
128: WHERE visit_start_time between start_date AND end_date;
129:

Line 127: FROM ibw_site_visits

123: BEGIN
124:
125: /** purge ibw_site_visits */
126: SELECT COUNT(distinct(site_visit_id)) cnt INTO visit_count
127: FROM ibw_site_visits
128: WHERE visit_start_time between start_date AND end_date;
129:
130: /** purge ibw_page_views */
131: SELECT COUNT(page_view_id) INTO page_view_count

Line 134: FROM ibw_site_visits v

130: /** purge ibw_page_views */
131: SELECT COUNT(page_view_id) INTO page_view_count
132: FROM ibw_page_views pv
133: WHERE visit_id IN (SELECT visit_id
134: FROM ibw_site_visits v
135: WHERE visit_start_time BETWEEN start_date AND end_date);
136:
137: /** purge ibw_visitors */
138: SELECT COUNT(visitor_id) INTO visitor_count

Line 141: FROM ibw_site_visits visit

137: /** purge ibw_visitors */
138: SELECT COUNT(visitor_id) INTO visitor_count
139: FROM ibw_visitors visitors
140: WHERE 0= (SELECT count(visitor_id)
141: FROM ibw_site_visits visit
142: WHERE visit_start_time NOT BETWEEN start_date AND end_date);
143: report_gen(visit_count, visitor_count, page_view_count,start_date, end_date, 'N');
144:
145: END purge_statistics;

Line 295: /** purge ibw_site_visits */

291: ELSIF startDate >= end_date THEN
292: error_messages := 'start date is greater than end date. ';
293:
294: ELSE
295: /** purge ibw_site_visits */
296: SELECT COUNT(site_visit_id) INTO cnt
297: FROM ibw_site_visits
298: WHERE visit_start_time between startDate AND end_date;
299:

Line 297: FROM ibw_site_visits

293:
294: ELSE
295: /** purge ibw_site_visits */
296: SELECT COUNT(site_visit_id) INTO cnt
297: FROM ibw_site_visits
298: WHERE visit_start_time between startDate AND end_date;
299:
300: temp_name := fnd_message.get_string('IBW', 'IBW_TR_PURGE_VISITS');
301: fnd_conc_summarizer.insert_row(temp_name, to_char(cnt));

Line 307: FROM ibw_site_visits v

303: /** purge ibw_page_views */
304: SELECT COUNT(page_view_id) INTO cnt
305: FROM ibw_page_views pv
306: WHERE 0 = (SELECT COUNT(visit_id)
307: FROM ibw_site_visits v
308: WHERE v.visit_id=pv.visit_id);
309:
310: temp_name := fnd_message.get_string('IBW', 'IBW_TR_PURGE_PAGEVIEWS');
311: fnd_conc_summarizer.insert_row(temp_name, to_char(cnt));

Line 318: FROM ibw_site_visits visit

314: /** purge ibw_visitors */
315: SELECT COUNT(visitor_id) INTO cnt
316: FROM ibw_visitors visitors
317: WHERE 0 = (SELECT COUNT(visitor_id)
318: FROM ibw_site_visits visit
319: WHERE visit.visitor_id=visitors.visitor_id);
320:
321: temp_name := fnd_message.get_string('IBW', 'IBW_TR_PURGE_VISITORS');
322: fnd_conc_summarizer.insert_row(temp_name, to_char(cnt));