Search Results pa_page_layout_utils
Overview
PA_PAGE_LAYOUT_UTILS is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM taxonomy as an "OTHER" API type. It belongs to the Oracle Projects (PA) module and provides the foundational programmatic infrastructure for the Oracle Projects page layout framework. This framework governs how project-related pages, regions, and user interface layouts are configured, validated, cloned, and rendered across the Projects application.
The package serves as the central utility layer that other Projects components call upon to resolve page identifiers, validate layout definitions, translate layout metadata into application-specific region codes, and manage personalization functions. It is not a public-facing business API in the sense of a transaction-processing interface; rather, it is an internal service package used by the page layout maintenance screens, concurrent processing logic, and dependent packages such as PA_OBJECT_REGIONS_PKG, PA_PROGRESS_REPORT_PKG, and PA_PROGRESS_REPORT_UTILS.
The package status is VALID, and it references several Oracle Foundation and Public dependencies including FND_API, FND_DESCR_FLEX_CONTEXTS_VL, FND_GLOBAL, FND_MSG_PUB, FND_PROFILE, PLITBLM, STANDARD, and SYSTEM. Notably, it is not referenced by any other database object, confirming its position as a top-level utility consumer rather than a dependency of external modules.
Key Procedures and Functions
- COPY_OBJECT_PAGE_LAYOUTS — Copies page layout definitions associated with an object, enabling layout reuse across objects or configuration contexts.
- CHECK_COLS_IN_PROJ_HEADER — Validates the columns configured for a project header layout, ensuring required fields and structural integrity.
- GET_AK_REGION_CODE — Retrieves the Oracle Application Framework (OAF) region code corresponding to a defined layout region.
- GET_REGION_SOURCE_CODE — Returns the source code identifier for a region, used to resolve the underlying implementation of a layout region.
- IS_PAGE_TYPE_REGION_DELETABLE — Determines whether a region of a given page type can be safely deleted without violating framework constraints.
- GET_CONTEXT_NAME — Resolves the descriptive context name for a layout, typically tied to descriptive flexfield context handling.
- CHECK_PAGELAYOUT_NAME_OR_ID — Validates the uniqueness and existence of a page layout name or identifier.
- CHECK_PAGE_LAYOUT_DELETABLE — Determines whether an entire page layout can be deleted based on dependencies and usage.
- GET_PAGE_ID_FROM_FUNCTION — Maps an application function to its associated page identifier, bridging function security and page layout metadata.
- POPULATE_PERS_FUNCTIONS — Populates personalization function records used to drive personalized page rendering behavior.
Tables Accessed
- PA_OBJECT_PAGE_LAYOUTS — Stores the association between business objects and their page layouts.
- PA_OBJECT_REGIONS — Defines regions belonging to objects.
- PA_PAGE_LAYOUTS and PA_PAGE_LAYOUTS_TMP — Hold page layout definitions and temporary working data.
- PA_PAGE_LAYOUT_REGIONS — Maps regions to page layouts.
- PA_PROJECTS_ALL — Provides project header data validated by CHECK_COLS_IN_PROJ_HEADER.
- PA_REPORT_TYPES — Supplies report type definitions referenced during layout resolution.
- PLITBLM — A public synonym table used for PL/SQL table-indexed storage; PA_VARCHAR2_30_TBL_TYPE supports array handling.
Usage Notes
This package is typically invoked indirectly through Oracle Projects setup forms, the page layout administration UI, and concurrent programs that generate or validate layout metadata. Dependent packages such as PA_OBJECT_REGIONS_PKG and PA_PROGRESS_REPORT_UTILS call it during region and report layout processing. Custom code should not invoke it directly without understanding its validation semantics, as it assumes FND_GLOBAL session context and message stack availability. Exception handling leverages FND_API and FND_MSG_PUB conventions.
-
PACKAGE BODY: APPS.PA_PAGE_LAYOUT_UTILS
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PAGE_LAYOUT_UTILS, status:VALID,
-
PACKAGE: APPS.PA_PAGE_LAYOUT_UTILS
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PA_PAGE_LAYOUT_UTILS, status:VALID,
-
PACKAGE BODY: APPS.PA_PAGE_LAYOUT_UTILS
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PAGE_LAYOUT_UTILS, status:VALID,
-
PACKAGE: APPS.PA_PAGE_LAYOUT_UTILS
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PA_PAGE_LAYOUT_UTILS, status:VALID,
-
SYNONYM: APPS.PA_PAGE_LAYOUTS_TMP
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PA_PAGE_LAYOUTS_TMP, status:VALID,
-
SYNONYM: APPS.PA_PAGE_LAYOUTS_TMP
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PA_PAGE_LAYOUTS_TMP, status:VALID,
-
PACKAGE: APPS.PA_PAGE_LAYOUT_UTILS
12.2.2
-
PACKAGE: APPS.PA_OBJECT_REGIONS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PA_OBJECT_REGIONS_PKG, status:VALID,
-
SYNONYM: APPS.PA_PAGE_LAYOUT_REGIONS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PA_PAGE_LAYOUT_REGIONS, status:VALID,
-
SYNONYM: APPS.PA_PAGE_LAYOUT_REGIONS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PA_PAGE_LAYOUT_REGIONS, status:VALID,
-
PACKAGE: APPS.PA_PROGRESS_REPORT_UTILS
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PA_PROGRESS_REPORT_UTILS, status:VALID,
-
PACKAGE: APPS.PA_PROGRESS_REPORT_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PA_PROGRESS_REPORT_PKG, status:VALID,
-
SYNONYM: APPS.PA_OBJECT_REGIONS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PA_OBJECT_REGIONS, status:VALID,
-
PACKAGE: APPS.PA_PAGE_LAYOUT_UTILS
12.1.1
-
PACKAGE: APPS.PA_PROGRESS_REPORT_UTILS
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PA_PROGRESS_REPORT_UTILS, status:VALID,
-
SYNONYM: APPS.PA_OBJECT_REGIONS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PA_OBJECT_REGIONS, status:VALID,
-
PACKAGE: APPS.PA_OBJECT_REGIONS_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PA_OBJECT_REGIONS_PKG, status:VALID,
-
PACKAGE: APPS.PA_DISTRIBUTION_LIST_UTILS
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PA_DISTRIBUTION_LIST_UTILS, status:VALID,
-
PACKAGE: APPS.PA_DISTRIBUTION_LIST_UTILS
12.1.1
owner:APPS, object_type:PACKAGE, object_name:PA_DISTRIBUTION_LIST_UTILS, status:VALID,
-
PACKAGE: APPS.PA_PROGRESS_REPORT_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:PA_PROGRESS_REPORT_PKG, status:VALID,
-
PACKAGE BODY: APPS.PA_TASK_TYPE_PUB
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_TASK_TYPE_PUB, status:VALID,
-
SYNONYM: APPS.PA_REPORT_TYPES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PA_REPORT_TYPES, status:VALID,
-
SYNONYM: APPS.PA_REPORT_TYPES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PA_REPORT_TYPES, status:VALID,
-
SYNONYM: APPS.PA_OBJECT_PAGE_LAYOUTS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PA_OBJECT_PAGE_LAYOUTS, status:VALID,
-
PACKAGE BODY: APPS.PA_TASK_TYPE_PUB
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_TASK_TYPE_PUB, status:VALID,
-
PACKAGE BODY: APPS.PA_PAGE_TYPE_REGION_PUB
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PAGE_TYPE_REGION_PUB, status:VALID,
-
PACKAGE BODY: APPS.PA_PAGE_TYPE_REGION_PUB
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PAGE_TYPE_REGION_PUB, status:VALID,
-
SYNONYM: APPS.PA_PAGE_LAYOUTS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PA_PAGE_LAYOUTS, status:VALID,
-
SYNONYM: APPS.PA_OBJECT_PAGE_LAYOUTS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PA_OBJECT_PAGE_LAYOUTS, status:VALID,
-
SYNONYM: APPS.PA_PAGE_LAYOUTS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PA_PAGE_LAYOUTS, status:VALID,
-
VIEW: APPS.PA_UDS_SECTIONS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_UDS_SECTIONS_V, object_name:PA_UDS_SECTIONS_V, status:VALID,
-
VIEW: APPS.PA_UDS_SECTIONS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_UDS_SECTIONS_V, object_name:PA_UDS_SECTIONS_V, status:VALID,
-
TYPE: SYSTEM.PA_VARCHAR2_30_TBL_TYPE
12.1.1
owner:SYSTEM, object_type:TYPE, object_name:PA_VARCHAR2_30_TBL_TYPE, status:VALID,
-
PACKAGE BODY: APPS.PA_TASK_PUB1
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_TASK_PUB1, status:VALID,
-
TYPE: SYSTEM.PA_VARCHAR2_30_TBL_TYPE
12.2.2
owner:SYSTEM, object_type:TYPE, object_name:PA_VARCHAR2_30_TBL_TYPE, status:VALID,
-
PACKAGE BODY: APPS.PA_TASK_PUB1
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_TASK_PUB1, status:VALID,
-
PACKAGE BODY: APPS.PA_PROJECT_CORE1
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PROJECT_CORE1, status:VALID,
-
PACKAGE BODY: APPS.PA_PROJECT_CORE1
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PROJECT_CORE1, status:VALID,
-
VIEW: APPS.FND_DESCR_FLEX_CONTEXTS_VL
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:FND.FND_DESCR_FLEX_CONTEXTS_VL, object_name:FND_DESCR_FLEX_CONTEXTS_VL, status:VALID,
-
VIEW: APPS.FND_DESCR_FLEX_CONTEXTS_VL
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:FND.FND_DESCR_FLEX_CONTEXTS_VL, object_name:FND_DESCR_FLEX_CONTEXTS_VL, status:VALID,
-
PACKAGE BODY: APPS.PA_PAGE_LAYOUT_UTILS
12.1.1
-
PACKAGE BODY: APPS.PA_PAGE_LAYOUT_UTILS
12.2.2
-
APPS.PA_PAGE_LAYOUT_UTILS dependencies on PA_PAGE_LAYOUT_UTILS
12.2.2
-
12.1.1 DBA Data
12.1.1
-
12.2.2 DBA Data
12.2.2
-
12.1.1 DBA Data
12.1.1
-
APPS.PA_TASK_TYPE_PUB dependencies on PA_PAGE_LAYOUT_UTILS
12.1.1
-
12.2.2 DBA Data
12.2.2
-
APPS.PA_TASK_PUB1 dependencies on PA_PAGE_LAYOUT_UTILS
12.1.1
-
APPS.PA_PAGE_TYPE_REGION_PUB dependencies on PA_PAGE_LAYOUT_UTILS
12.1.1