APPS.PA_PAGE_LAYOUT_UTILS dependencies on PA_PAGE_LAYOUTS

Line 394: pa_page_layouts ppl, pa_page_layout_regions pplr

390:
391: CURSOR get_page_layout
392: IS
393: SELECT ppl.page_id FROM
394: pa_page_layouts ppl, pa_page_layout_regions pplr
395: WHERE ppl.page_id = pplr.page_id
396: AND ppl.page_type_code = p_page_type_code
397: AND pplr.region_source_type = p_region_source_type
398: AND pplr.region_source_code = p_region_source_code;

Line 460: FROM pa_page_layouts

456: IF (x_pagelayout_id IS NOT NULL) THEN
457: IF (x_pagelayout_id >0 AND p_check_id_flag = 'Y') THEN
458: SELECT page_id
459: INTO x_pagelayout_id
460: FROM pa_page_layouts
461: WHERE page_id = x_pagelayout_id;
462: ELSIF (p_check_id_flag = 'N') THEN
463: -- No ID validation is required
464: x_pagelayout_id := x_pagelayout_id;

Line 472: FROM pa_page_layouts

468: ELSE
469: --Find the Id for the name
470: SELECT page_id
471: INTO x_pagelayout_id
472: FROM pa_page_layouts
473: WHERE page_name = p_pagelayout_name
474: AND page_type_code = p_pagetype_code;
475:
476: END IF;

Line 482: FROM pa_page_layouts

478: ELSE
479: IF (p_pagelayout_name is not null) THEN
480: SELECT page_id
481: INTO x_pagelayout_id
482: FROM pa_page_layouts
483: WHERE page_name = p_pagelayout_name
484: AND page_type_code = p_pagetype_code;
485: ELSE
486: x_pagelayout_id := null;

Line 523: FROM pa_page_layouts

519: WHERE page_id = p_page_id;
520:
521: CURSOR c_page_type IS
522: SELECT page_type_code
523: FROM pa_page_layouts
524: WHERE page_id = p_page_id;
525:
526: /*
527: CURSOR c_profile_refernce IS

Line 540: l_page_type_code pa_page_layouts.page_type_code%TYPE;

536: */
537:
538: l_dummy varchar2(1);
539: l_deletable_flag varchar2(1) := 'Y';
540: l_page_type_code pa_page_layouts.page_type_code%TYPE;
541:
542: BEGIN
543: -- The seeded page layout is not deletable
544: IF (p_page_id < 1000) THEN

Line 610: From pa_page_layouts

606: IS
607: Cursor c_get_page_id(v_page_type_code VARCHAR2, v_function_name VARCHAR2)
608: Is
609: Select page_id
610: From pa_page_layouts
611: Where page_type_code = v_page_type_code
612: And pers_function_name = v_function_name;
613:
614: l_page_id NUMBER;

Line 651: DELETE FROM PA_PAGE_LAYOUTS_TMP;

647: pa_debug.set_curr_function( p_function => 'PERS_FUNCTIONS',
648: p_debug_mode => l_debug_mode );
649: END IF;
650:
651: DELETE FROM PA_PAGE_LAYOUTS_TMP;
652: len := p_page_type_code_tbl.count;
653: FORALL i in 1..len
654: INSERT INTO PA_PAGE_LAYOUTS_TMP VALUES(p_page_type_code_tbl(i),p_function_name_tbl(i));
655:

Line 654: INSERT INTO PA_PAGE_LAYOUTS_TMP VALUES(p_page_type_code_tbl(i),p_function_name_tbl(i));

650:
651: DELETE FROM PA_PAGE_LAYOUTS_TMP;
652: len := p_page_type_code_tbl.count;
653: FORALL i in 1..len
654: INSERT INTO PA_PAGE_LAYOUTS_TMP VALUES(p_page_type_code_tbl(i),p_function_name_tbl(i));
655:
656: EXCEPTION
657: WHEN OTHERS THEN
658: ROLLBACK TO populate_pers_functions;