APPS.IBW_OE_PVT dependencies on IBW_PAGES_B

Line 47: l_page_id IBW_PAGES_B.PAGE_ID%TYPE;

43: l_pat_count PLS_INTEGER;
44: l_pat_3_count PLS_INTEGER;
45: l_pat_4_count PLS_INTEGER;
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);

Line 108: FROM ibw_pages_b pages

104: UPPER(REPLACE (patterns.url_pattern, '*', '%') || '%' ));
105:
106: CURSOR inactive_pages is
107: SELECT pages.page_id as page_id
108: FROM ibw_pages_b pages
109: WHERE pages.page_status = 'N'
110: AND exists (SELECT tmp.page_id
111: FROM ibw_page_views_tmp tmp
112: WHERE tmp.page_id = pages.page_id);

Line 421: FROM ibw_pages_b pages

417: )
418: )
419: , 5
420: ) AS process_flag
421: FROM ibw_pages_b pages
422: , ( SELECT DECODE( pat.attribute16
423: ,'I', NVL ( sites1.msite_id, -1 ) --Put site id as -1 if not there, for processing later
424: ,'E', NVL ( sites2.msite_id -- If doesnt have site id , resolve it.
425: , NVL( ( SELECT type_id -- Match the URL stripping query string with all the url_pattern and take the site id

Line 1258: UPDATE ibw_pages_b pag

1254:
1255:
1256: -- populate reference column for exisiting pages
1257:
1258: UPDATE ibw_pages_b pag
1259: SET REFERENCE = ( SELECT tracked_page_url
1260: FROM ibw_page_views_tmp
1261: WHERE page_id = pag.page_id and rownum = 1) -- Changed by Venky. Added rownum=1 because select query could return more than 1 row
1262: WHERE REFERENCE IS NULL

Line 1952: FROM ibw_pages_b pages

1948:
1949: BEGIN --Changed by Venky. Added code to handle no_data_found exception
1950: SELECT page_id
1951: INTO pageid
1952: FROM ibw_pages_b pages
1953: WHERE pages.page_matching_criteria =
1954: NVL2(l_template_access_name
1955: ,'R'
1956: ,DECODE (pagecode,

Line 1999: FROM ibw_pages_b pages

1995:
1996: BEGIN --Changed by Venky. Added code to handle no_data_found exception
1997: SELECT page_id
1998: INTO pageid
1999: FROM ibw_pages_b pages
2000: WHERE pages.page_matching_criteria =
2001: DECODE (pagecode,
2002: NULL, DECODE (pagename,
2003: NULL, 'U',