APPS.IBW_OE_PVT dependencies on IBW_PAGES_TL

Line 48: l_page_name IBW_PAGES_TL.PAGE_NAME%TYPE;

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);
52: l_message_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

Line 1790: FROM ibw_pages_tl pages_tl

1786: fnd_message.set_name('IBW','IBW_OE_INVALID_CTX_ID');
1787: l_page_id := page_view.page_id;
1788: SELECT pages_tl.page_name
1789: INTO l_page_name
1790: FROM ibw_pages_tl pages_tl
1791: WHERE pages_tl.page_id = l_page_id
1792: AND language = userenv('LANG');
1793: fnd_message.set_token('PAGE_NAME',l_page_name);
1794: fnd_message.set_token('CONTEXT_ID',page_view.business_context_value);

Line 1810: FROM ibw_pages_tl pages_tl

1806: l_page_id := page_view.page_id;
1807: BEGIN
1808: SELECT pages_tl.page_name
1809: INTO l_page_name
1810: FROM ibw_pages_tl pages_tl
1811: WHERE pages_tl.page_id = l_page_id
1812: AND language = userenv('LANG');
1813: EXCEPTION
1814: WHEN OTHERS THEN

Line 1832: FROM ibw_pages_tl pages_tl

1828: fnd_message.set_name('IBW','IBW_OE_INACTIVEPAGE_MATCH');
1829: l_page_id := page_view.page_id;
1830: SELECT pages_tl.page_name
1831: INTO l_page_name
1832: FROM ibw_pages_tl pages_tl
1833: WHERE pages_tl.page_id = l_page_id
1834: AND language = userenv('LANG');
1835: fnd_message.set_token('PAGE_NAME',l_page_name);
1836: l_message_text := fnd_message.get;