[Home] [Help]
1541:
1542: printLog('Inserting into site_visits table');
1543:
1544:
1545: MERGE INTO ibw_site_visits sv
1546: USING (SELECT -1 AS site_visit_id
1547: , visit_id
1548: , site_id
1549: , visit_start_time
1562: , visitant_id
1563: , campaign_source_code_id
1564: , DECODE (INSTR (innerquery.visitant_id, 'p', 1, 1),
1565: 0, DECODE ((SELECT COUNT (site_visit_id)
1566: FROM ibw_site_visits
1567: WHERE visitor_id = innerquery.visitor_id
1568: AND visit_id <> innerquery.visit_id
1569: AND visit_start_time < innerquery.visit_start_time
1570: AND ROWNUM = 1
1580: , 'Y'
1581: )
1582: , 'Y'),
1583: DECODE ((SELECT COUNT (site_visit_id)
1584: FROM ibw_site_visits
1585: WHERE party_id = innerquery.party_id
1586: AND visit_id <> innerquery.visit_id
1587: AND visit_start_time < innerquery.visit_start_time
1588: AND ROWNUM = 1
1700: , total_payment_inquiries, total_invoice_inquiries
1701: , total_opt_outs, user_id, visitant_id, campaign_source_code_id
1702: , repeat_visit_flag, created_by, creation_date, last_updated_by
1703: , last_update_date, object_version_number )
1704: VALUES ( ibw_site_visits_s1.NEXTVAL, tmp.visit_id, tmp.site_id
1705: , tmp.visit_start_time, tmp.visitor_id, tmp.referral_category_id
1706: , tmp.party_id, tmp.num_page_views, tmp.site_visit_duration
1707: , tmp.total_carts_created, tmp.total_orders_created
1708: , tmp.total_web_registrations, tmp.total_order_inquiries
1720: printLog('Get visit count for logging output');
1721:
1722: SELECT COUNT(distinct(visit_id))
1723: INTO l_visit_count
1724: FROM ibw_site_visits
1725: WHERE creation_date > l_start_time;
1726:
1727:
1728:
2140:
2141:
2142: printLog('Starting Referral Category Concurrent Program');
2143:
2144: UPDATE ibw_site_visits tmp
2145: SET tmp.referral_category_id =
2146: NVL((SELECT type_id
2147: FROM (SELECT patterns.type_id
2148: ,VISIT_ID, patterns.program_id ,patterns.url_pattern ,patterns.creation_date