APPS.PA_PAGE_LAYOUT_PVT dependencies on PA_PAGE_LAYOUTS

Line 63: from pa_page_layouts

59:
60: cursor get_menu_name
61: is
62: select page_id
63: from pa_page_layouts
64: where page_name = p_page_name and
65: page_type_code = p_page_type;
66:
67: l_type VARCHAR2(250);

Line 251: from pa_lookups l, pa_page_layouts ppl

247: IS
248: select 'Y' from dual
249: where exists(
250: select 'Required'
251: from pa_lookups l, pa_page_layouts ppl
252: where l.lookup_type = 'PA_PAGE_TYPES'
253: and l.lookup_code = ppl.page_type_code
254: AND L.attribute2 = 'Y'
255: and ppl.page_id = p_page_id

Line 266: FROM pa_page_layouts

262: where user_menu_name = p_shortcut_menu_name;
263:
264: CURSOR check_record_version IS
265: SELECT ROWID
266: FROM pa_page_layouts
267: WHERE page_id = p_page_id
268: AND record_version_number = p_record_version_number;
269: l_page_layout_row_id ROWID;
270:

Line 273: SELECT meaning FROM pa_lookups pl, pa_page_layouts ppl

269: l_page_layout_row_id ROWID;
270:
271: CURSOR get_template_type
272: is
273: SELECT meaning FROM pa_lookups pl, pa_page_layouts ppl
274: WHERE pl.lookup_type = 'PA_PAGE_TYPES'
275: AND pl.lookup_code = ppl.PAGE_TYPE_CODE
276: AND ppl.page_id = p_page_id;
277:

Line 451: FROM pa_page_layouts

447: ) IS
448:
449: CURSOR check_page_layout IS
450: SELECT page_id
451: FROM pa_page_layouts
452: WHERE (page_id = p_page_id AND p_page_id IS NOT NULL
453: AND record_version_number = Nvl(p_record_version_number, record_version_number));
454:
455:

Line 463: SELECT meaning FROM pa_lookups pl, pa_page_layouts ppl

459: WHERE (page_id = p_page_id AND p_page_id IS NOT NULL);
460:
461: CURSOR get_template_type
462: is
463: SELECT meaning FROM pa_lookups pl, pa_page_layouts ppl
464: WHERE pl.lookup_type = 'PA_PAGE_TYPES'
465: AND pl.lookup_code = ppl.page_type_code
466: AND ppl.page_id = p_page_id;
467:

Line 469: SELECT page_type_code from pa_page_layouts

465: AND pl.lookup_code = ppl.page_type_code
466: AND ppl.page_id = p_page_id;
467:
468: CURSOR get_page_type_code IS
469: SELECT page_type_code from pa_page_layouts
470: WHERE page_id = p_page_id;
471:
472: l_type VARCHAR2(250);
473:

Line 475: l_page_type_code pa_page_layouts.page_type_code%TYPE;

471:
472: l_type VARCHAR2(250);
473:
474: l_page_id NUMBER;
475: l_page_type_code pa_page_layouts.page_type_code%TYPE;
476: BEGIN
477:
478: -- Initialize the Error Stack
479: PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_PVT.Delete_Page_Layout');

Line 634: FROM pa_page_type_regions pptr, pa_page_layouts ppl

630:
631: CURSOR get_edit_region_code
632: IS
633: SELECT view_region_code, edit_region_code
634: FROM pa_page_type_regions pptr, pa_page_layouts ppl
635: WHERE pptr.page_type_code = ppl.page_type_code
636: AND ppl.page_id = p_page_id
637: AND pptr.region_source_type = P_REGION_SOURCE_TYPE
638: AND pptr.view_region_code = P_VIEW_REGION_CODE;

Line 642: SELECT meaning FROM pa_lookups pl, pa_page_layouts ppl

638: AND pptr.view_region_code = P_VIEW_REGION_CODE;
639:
640: CURSOR get_template_type
641: is
642: SELECT meaning FROM pa_lookups pl, pa_page_layouts ppl
643: WHERE pl.lookup_type = 'PA_PAGE_TYPES'
644: AND pl.lookup_code = ppl.page_type_code
645: AND ppl.page_id = p_page_id;
646:

Line 877: , pa_page_layouts ppl

873: , pplr.region_source_type
874: , pplr.region_source_code
875: , pplr.record_version_number
876: FROM pa_page_layout_regions pplr
877: , pa_page_layouts ppl
878: , pa_page_type_regions pptr
879: WHERE pplr.page_id = p_page_id
880: and ppl.page_id = pplr.page_id
881: and ppl.page_type_code = pptr.page_type_code