APPS.PA_PAGE_LAYOUT_PVT dependencies on PA_PAGE_LAYOUT_REGIONS

Line 546: DELETE FROM pa_page_layout_regions

542: -- RAISE no_data_found;
543: -- end if;
544:
545:
546: DELETE FROM pa_page_layout_regions
547: WHERE page_id = p_page_id;
548:
549: END IF;
550: ELSE --Bug#3302984 added this part of code.

Line 573: DELETE FROM pa_page_layout_regions

569: ,x_msg_count => x_msg_count
570: ,x_msg_data => x_msg_data
571: );
572:
573: DELETE FROM pa_page_layout_regions
574: WHERE page_id = p_page_id;
575: END IF;
576:
577: CLOSE check_object_page_versions;

Line 775: FROM pa_page_layout_regions

771: l_row_id ROWID;
772:
773: CURSOR check_page_region IS
774: SELECT rowid
775: FROM pa_page_layout_regions
776: WHERE (page_id = p_page_id
777: AND region_source_type = p_region_source_type
778: AND region_source_code = p_region_source_code
779: AND record_version_number = Nvl(p_record_version_number, record_version_number));

Line 876: FROM pa_page_layout_regions pplr

872: SELECT distinct pplr.page_id
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

Line 973: FROM pa_page_layout_regions pplr

969: SELECT distinct pplr.page_id
970: , pplr.region_source_type
971: , pplr.region_source_code
972: , pplr.record_version_number
973: FROM pa_page_layout_regions pplr
974: WHERE pplr.page_id = p_page_id
975: AND Nvl(pplr.region_style, 'N') = 'LINK';
976: --and pptr.default_region_position =
977: --nvl(p_region_position, pptr.default_region_position);

Line 1049: from pa_page_layout_regions

1045: l_ret varchar2(1) := 'N';
1046: BEGIN
1047: select 'N'
1048: into l_ret
1049: from pa_page_layout_regions
1050: where region_source_type = p_region_source_type
1051: and region_source_code = p_region_source_code;
1052: return l_ret;
1053: exception