APPS.PA_PAGE_LAYOUT_UTILS dependencies on PA_PAGE_LAYOUTS

Line 385: pa_page_layouts ppl, pa_page_layout_regions pplr

381:
382: CURSOR get_page_layout
383: IS
384: SELECT ppl.page_id FROM
385: pa_page_layouts ppl, pa_page_layout_regions pplr
386: WHERE ppl.page_id = pplr.page_id
387: AND ppl.page_type_code = p_page_type_code
388: AND pplr.region_source_type = p_region_source_type
389: AND pplr.region_source_code = p_region_source_code;

Line 451: FROM pa_page_layouts

447: IF (x_pagelayout_id IS NOT NULL) THEN
448: IF (x_pagelayout_id >0 AND p_check_id_flag = 'Y') THEN
449: SELECT page_id
450: INTO x_pagelayout_id
451: FROM pa_page_layouts
452: WHERE page_id = x_pagelayout_id;
453: ELSIF (p_check_id_flag = 'N') THEN
454: -- No ID validation is required
455: x_pagelayout_id := x_pagelayout_id;

Line 463: FROM pa_page_layouts

459: ELSE
460: --Find the Id for the name
461: SELECT page_id
462: INTO x_pagelayout_id
463: FROM pa_page_layouts
464: WHERE page_name = p_pagelayout_name
465: AND page_type_code = p_pagetype_code;
466:
467: END IF;

Line 473: FROM pa_page_layouts

469: ELSE
470: IF (p_pagelayout_name is not null) THEN
471: SELECT page_id
472: INTO x_pagelayout_id
473: FROM pa_page_layouts
474: WHERE page_name = p_pagelayout_name
475: AND page_type_code = p_pagetype_code;
476: ELSE
477: x_pagelayout_id := null;

Line 514: FROM pa_page_layouts

510: WHERE page_id = p_page_id;
511:
512: CURSOR c_page_type IS
513: SELECT page_type_code
514: FROM pa_page_layouts
515: WHERE page_id = p_page_id;
516:
517: /*
518: CURSOR c_profile_refernce IS

Line 531: l_page_type_code pa_page_layouts.page_type_code%TYPE;

527: */
528:
529: l_dummy varchar2(1);
530: l_deletable_flag varchar2(1) := 'Y';
531: l_page_type_code pa_page_layouts.page_type_code%TYPE;
532:
533: BEGIN
534: -- The seeded page layout is not deletable
535: IF (p_page_id < 1000) THEN

Line 601: From pa_page_layouts

597: IS
598: Cursor c_get_page_id(v_page_type_code VARCHAR2, v_function_name VARCHAR2)
599: Is
600: Select page_id
601: From pa_page_layouts
602: Where page_type_code = v_page_type_code
603: And pers_function_name = v_function_name;
604:
605: l_page_id NUMBER;

Line 642: DELETE FROM PA_PAGE_LAYOUTS_TMP;

638: pa_debug.set_curr_function( p_function => 'PERS_FUNCTIONS',
639: p_debug_mode => l_debug_mode );
640: END IF;
641:
642: DELETE FROM PA_PAGE_LAYOUTS_TMP;
643: len := p_page_type_code_tbl.count;
644: FORALL i in 1..len
645: INSERT INTO PA_PAGE_LAYOUTS_TMP VALUES(p_page_type_code_tbl(i),p_function_name_tbl(i));
646:

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

641:
642: DELETE FROM PA_PAGE_LAYOUTS_TMP;
643: len := p_page_type_code_tbl.count;
644: FORALL i in 1..len
645: INSERT INTO PA_PAGE_LAYOUTS_TMP VALUES(p_page_type_code_tbl(i),p_function_name_tbl(i));
646:
647: EXCEPTION
648: WHEN OTHERS THEN
649: ROLLBACK TO populate_pers_functions;