Results for “get_sync_buf_days”
8 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PA_WORKPLAN_ATTR_UTILS is an Oracle EBS Projects (PA) utility package owned by the APPS schema and declared with AUTHID CURRENT_USER. It provides the shared validation and attribute-resolution logic that underpins the Project Workplan feature set, which governs lifecycle phases, workplan versions, approval and publication behavior, and automatic date synchronization for projects and tasks. Rather than exposing a business transaction API, the package supplies low-level helper routines that other workplan APIs, forms, and concurrent programs call to validate names and identifiers, confirm that configuration options are enabled, and derive the current lifecycle phase for a project. The package header dates to a 2005 revision (PAPRWPUS.pls 120.1) and remains relevant in both the 12.1.1 and 12.2.2 releases.
Key Procedures and Functions
The package exposes twelve documented routines. Several perform name-or-ID validation across workplan entities:
- CHECK_LIFECYCLE_NAME_OR_ID — validates a lifecycle passed either by name or by identifier and returns the resolved lifecycle identifier.
- CHECK_LIFECYCLE_PHASE_NAME_ID — validates a lifecycle phase supplied by name or ID against its parent lifecycle and returns the resolved phase identifier.
- CHECK_APPROVER_NAME_OR_ID — validates an approver supplied by name or identifier, returning the corresponding identifier.
- CHECK_WP_PROJECT_EXISTS — the routine matching the user's search term; it verifies that a workplan-enabled project exists before downstream workplan processing proceeds.
- CHECK_WP_TASK_EXISTS — verifies the existence of a workplan task.
A second group reports on workplan configuration flags and settings:
- CHECK_WP_VERSIONING_ENABLED — indicates whether workplan versioning is enabled.
- CHECK_AUTO_DATE_SYNC_ENABLED and GET_SYNC_BUF_DAYS — report whether automatic date synchronization is enabled and, where applicable, the synchronization buffer in days.
- CHECK_APPROVAL_REQUIRED — reports whether workplan approval is required.
- CHECK_AUTO_PUB_ENABLED and CHECK_AUTO_PUB_AT_CREATION — report whether automatic publication is enabled, including publication at workplan creation.
UPDATE_CURRENT_PHASE completes the set, writing the current lifecycle phase for a project.
Tables Accessed
The package reads and writes the core workplan and project structure tables through APPS synonyms:
- PA_PROJ_WORKPLAN_ATTR — the principal attribute store for workplan configuration, read by the enablement and synchronization checks and maintained by UPDATE_CURRENT_PHASE.
- PA_LIFECYCLE_USAGES — associates lifecycles with project structure types and supports lifecycle name/ID validation.
- PA_PROJ_ELEMENTS and PA_PROJ_ELEMENT_VERSIONS — hold project/task structure elements and their versioned copies, used by the project and task existence checks.
- PA_PROJ_STRUCTURE_TYPES and PA_STRUCTURE_TYPES — define the structure types that determine which lifecycle applies to a project.
Usage Notes
PA_WORKPLAN_ATTR_UTILS is not invoked directly by end users. It is referenced by 33 other packages, making it a foundational dependency for the workplan APIs, Oracle Projects forms, and any custom code that manipulates workplan attributes. Callers typically invoke CHECK_WP_PROJECT_EXISTS and CHECK_WP_TASK_EXISTS before performing workplan operations, use the validation routines to normalize user-supplied lifecycle, phase, or approver values, and query the configuration checks to decide whether versioning, approval, or automatic publication logic should execute. Because all routines follow the standard FND_API convention of returning X_RETURN_STATUS and X_ERROR_MSG_CODE, callers must inspect return status after every call.