APPS.IBW_OE_PVT dependencies on IBW_PAGE_INSTANCES

Line 50: l_page_instance_id IBW_PAGE_INSTANCES.PAGE_INSTANCE_ID%TYPE;

46: l_rec_count PLS_INTEGER;
47: l_page_id IBW_PAGES_B.PAGE_ID%TYPE;
48: l_page_name IBW_PAGES_TL.PAGE_NAME%TYPE;
49: l_ref_catg_id IBW_REFERRAL_CATEGORIES_B.REFERRAL_CATEGORY_ID%TYPE;
50: l_page_instance_id IBW_PAGE_INSTANCES.PAGE_INSTANCE_ID%TYPE;
51: l_return NUMBER(30);
52: l_message_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
53: TEMP_CREATE_ERR EXCEPTION;
54:

Line 77: FROM ibw_page_instances

73: WHERE page_instance_id = -1
74: AND process_flag is null
75: AND page_id <> -1
76: AND not exists ( SELECT page_instance_id
77: FROM ibw_page_instances
78: WHERE page_id = tmp.page_id
79: AND business_context=tmp.business_context
80: AND business_context_value = NVL(tmp.business_context_value,'-999'));
81:

Line 1276: IBW_PAGE_INSTANCES_PVT.INSERT_row (l_page_instance_id

1272: LOOP
1273: --Changed by Venky. Using Exceptions to handle no_data condition
1274:
1275:
1276: IBW_PAGE_INSTANCES_PVT.INSERT_row (l_page_instance_id
1277: ,page_view.page_id
1278: ,page_view.business_context
1279: ,page_view.business_context_value
1280: ,error_messages);

Line 1287: FROM ibw_page_instances pi

1283:
1284: UPDATE ibw_page_views_tmp pv
1285: SET pv.page_instance_id =
1286: NVL ( ( SELECT pi.page_instance_id
1287: FROM ibw_page_instances pi
1288: WHERE pi.page_id = pv.page_id
1289: AND pi.business_context_value = pv.business_context_value )
1290: , -1 );
1291:

Line 2299: FROM ibw_page_instances page

2295: MERGE INTO ibw_context_interface_b cont
2296: USING (SELECT page.business_context
2297: ,sect.section_id
2298: ,sect.access_name
2299: FROM ibw_page_instances page
2300: -- To get the section related information for all the pages that have been tracked by web analytics.
2301: ,ibe_dsp_sections_vl sect
2302: -- To get the sections related information FROM this iStore view
2303: WHERE page.business_context = 'SECTION'