APPS.WMS_CONFIG_UI dependencies on WMS_PAGE_TEMPLATES_VL

Line 220: from WMS_PAGE_TEMPLATES_VL

216: IF(p_template_name IS NOT NULL) THEN
217: BEGIN
218: select template_id, template_name
219: into x_template_id, x_return_template
220: from WMS_PAGE_TEMPLATES_VL
221: where page_id in (p_page_id, nvl(l_parent_page_id, p_page_id ))
222: and template_name = p_template_name
223: and enabled = 'Y'
224: and decode(common_to_all_orgs,

Line 249: from WMS_PAGE_TEMPLATES_VL

245: DEBUG (' Getting the Default Template for the Page' || x_template_id, l_module_name, 9);
246: BEGIN
247: select template_id, template_name
248: into x_template_id, x_return_template
249: from WMS_PAGE_TEMPLATES_VL
250: where page_id in (p_page_id, nvl(l_parent_page_id, p_page_id ))
251: and enabled = 'Y'
252: and default_flag = 'Y';
253: DEBUG (' x_template_id ==> ' || x_template_id, l_module_name, 9);