APPS.IBW_PURGE_PVT dependencies on IBW_VISITORS

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 82: SELECT count(visitor_id) into visitor_count FROM ibw_visitors visitors

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
83: WHERE 0 = (SELECT COUNT(visitor_id)
84: FROM ibw_site_visits visit
85: WHERE visit.visitor_id=visitors.visitor_id);
86:

Line 87: /** purge ibw_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
89: WHERE 0 = (SELECT COUNT(visitor_id)
90: FROM ibw_site_visits visit
91: WHERE visit.visitor_id=visitors.visitor_id);

Line 88: DELETE FROM ibw_visitors visitors

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
89: WHERE 0 = (SELECT COUNT(visitor_id)
90: FROM ibw_site_visits visit
91: WHERE visit.visitor_id=visitors.visitor_id);
92:

Line 137: /** purge ibw_visitors */

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
139: FROM ibw_visitors visitors
140: WHERE 0= (SELECT count(visitor_id)
141: FROM ibw_site_visits visit

Line 139: FROM ibw_visitors visitors

135: WHERE visit_start_time BETWEEN start_date AND end_date);
136:
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');

Line 314: /** purge ibw_visitors */

310: temp_name := fnd_message.get_string('IBW', 'IBW_TR_PURGE_PAGEVIEWS');
311: fnd_conc_summarizer.insert_row(temp_name, to_char(cnt));
312:
313:
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

Line 316: FROM ibw_visitors visitors

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