Results for “check_auto_pub_enabled”

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:

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:

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.