Search Results x_structure_type

Overview

PA_PROJ_PROGRESS_ATTR_PKG is an Oracle EBS Projects (PA) package body owned by the APPS schema that encapsulates the maintenance logic for the PA_PROJ_PROGRESS_ATTR entity. This entity stores project-level and object-level configuration attributes that govern how progress is captured and calculated for a project, including progress cycles, work quantity enablement, remaining effort, percent complete, task weighting, and collaborative progress entry behavior. The package functions as the single point of record for inserting, updating, and deleting rows in the underlying progress attribute table, and it is classified under the ETRM API taxonomy as OTHER rather than as a public, fully documented API. The package is significant because the identifier PROJ_PROGRESS_ATTR_ID is the surrogate primary key of the progress attribute record, and this package is responsible for generating that key when a new attribute row is created. The naming prefix X_ on the identifier reflects the EBS convention that such values are derived internally by the package rather than supplied by the caller, and the presence of X_PROJ_PROGRESS_ATTR_ID as an IN OUT NOCOPY parameter in the insert procedure confirms that key generation is centralized here.

Key Procedures and Functions

• INSERT_ROW — Creates a new row in PA_PROJ_PROGRESS_ATTR. The procedure exposes the full column set of the target table, including project context (X_PROJECT_ID), object targeting (X_OBJECT_TYPE and X_OBJECT_ID), audit columns (last update and creation metadata), and the functional attribute columns such as X_PROGRESS_CYCLE_ID, X_WQ_ENABLE_FLAG, X_REMAIN_EFFORT_ENABLE_FLAG, X_PERCENT_COMP_ENABLE_FLAG, X_NEXT_PROGRESS_UPDATE_DATE, X_TASK_WEIGHT_BASIS_CODE, X_ALLOW_COLLAB_PROG_ENTRY, X_ALLW_PHY_PRCNT_CMP_OVERRIDES, and X_STRUCTURE_TYPE. The procedure checks whether X_PROJ_PROGRESS_ATTR_ID is null and, if so, derives the next value from the PA_PROJ_PROGRESS_ATTR_S sequence before performing the insert. RECORD_VERSION_NUMBER is seeded to 1 at creation time.
• UPDATE_ROW — Modifies an existing progress attribute row identified by its primary key, allowing changes to the same functional attribute set. It is the supported path for altering progress cycle assignment, enablement flags, weighting basis, and date-driven behavior after initial creation.
• DELETE_ROW — Removes a progress attribute row by identifier, providing the controlled deletion path used when project or object progress configuration must be retired.

Tables Accessed

• PA_PROJ_PROGRESS_ATTR — The primary transactional table. The insert logic maps every exposed parameter to a corresponding column, with PROJ_PROGRESS_ATTR_ID as the key and RECORD_VERSION_NUMBER hard-coded to 1. Updates and deletes operate against this same table.
• PA_PROJ_PROGRESS_ATTR_S — The sequence used to generate new PROJ_PROGRESS_ATTR_ID values when the caller does not supply one.
• DUAL — Used solely to fetch the sequence nextval during unconditional key derivation.

Usage Notes

The package is invoked primarily from project setup and progress configuration flows, including Progress Collection and Progress Setup forms, and from any concurrent or custom process that needs to create or modify project progress attributes. Because the INSERT_ROW signature accepts X_PROJ_PROGRESS_ATTR_ID as IN OUT NOCOPY, callers that require the generated identifier must declare a host variable and pass it by reference so the package can populate it. The package is referenced by two other packages, indicating that it is also used internally by higher-level Projects routines rather than only by user-facing forms. Because the object is classified as OTHER in ETRM, its parameters are not guaranteed as a supported public interface across releases, and developers should prefer documented Projects public APIs where available. The exception handler on INSERT_ROW resets the OUT parameter on failure, so callers must treat any raised exception as an indication that no valid identifier was returned.