APPS.IBW_PURGE_PVT dependencies on IBW_PAGE_VIEWS

Line 16: -- Administrator uses this program to purge the transaction data. The tables which will be purged are IBW_PAGE_VIEWS,

12: -- PURPOSE
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

Line 64: SELECT count(page_view_id)into page_view_count FROM ibw_page_views pv

60: WHERE visit_start_time between start_date AND end_date;
61:
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:

Line 69: /** purge ibw_page_views */

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
71: WHERE 0 = (SELECT COUNT(visit_id)
72: FROM ibw_site_visits v
73: WHERE v.visit_id=pv.visit_id);

Line 70: DELETE FROM ibw_page_views pv

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
71: WHERE 0 = (SELECT COUNT(visit_id)
72: FROM ibw_site_visits v
73: WHERE v.visit_id=pv.visit_id);
74:

Line 75: /** purge ibw_page_views_tmp */

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
77: WHERE 0 = (SELECT COUNT(visit_id)
78: FROM ibw_site_visits v
79: WHERE v.visit_id=pv.visit_id);

Line 76: DELETE FROM ibw_page_views_tmp pv

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
77: WHERE 0 = (SELECT COUNT(visit_id)
78: FROM ibw_site_visits v
79: WHERE v.visit_id=pv.visit_id);
80:

Line 96: FROM ibw_page_views pv

92:
93: /** purge ibw_page_instances */
94: DELETE FROM ibw_page_instances pi
95: WHERE 0 = (SELECT COUNT(page_instance_id)
96: FROM ibw_page_views pv
97: WHERE pv.page_instance_id=pi.page_instance_id);
98:
99:
100:

Line 130: /** purge ibw_page_views */

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
132: FROM ibw_page_views pv
133: WHERE visit_id IN (SELECT visit_id
134: FROM ibw_site_visits v

Line 132: FROM ibw_page_views pv

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
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:

Line 303: /** purge ibw_page_views */

299:
300: temp_name := fnd_message.get_string('IBW', 'IBW_TR_PURGE_VISITS');
301: fnd_conc_summarizer.insert_row(temp_name, to_char(cnt));
302:
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

Line 305: FROM ibw_page_views pv

301: fnd_conc_summarizer.insert_row(temp_name, to_char(cnt));
302:
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: