Results for “pqp_aat_api”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PQP_AAT_API is a public PL/SQL API package owned by the APPS schema and classified as an API within Oracle E-Business Suite. Its name derives from the "Assignment Attribute" (AAT) functional area, and the package header documents it explicitly as a repository of APIs for assignment attributes. In business terms, assignment attributes capture contract type and the details of work patterns associated with an employee assignment. These attributes are principally consumed by public sector installations, where contract classification and working-pattern definitions are required for statutory reporting and workforce administration. The package is licensed for use with Oracle Human Resources and carries a product designation of PER (Human Resources). The header comment further records that, although legacy columns for vehicle information persist in the underlying structures, vehicle data is no longer maintained through this package; the dedicated APIs PQP_VEHICLE_REPOSITORY_API and PQP_VEHICLE_ALLOCATION_API now handle vehicle repositories and allocations respectively.

Key Procedures and Functions

The ETRM metadata documents three public procedures on this package, corresponding to the standard create, update, and delete lifecycle for assignment attribute records:

• CREATE_ASSIGNMENT_ATTRIBUTE — Creates an assignment attribute record for an employee, encompassing contract type and work-pattern details. Documented prerequisites require that the employee already holds an assignment as of the effective date. On success, the attribute rows are inserted into the database; on failure, no records are created and an error is raised. The header confirms that the assignment attributes are validated against the effective date and business group context before insertion.
• UPDATE_ASSIGNMENT_ATTRIBUTE — Modifies an existing assignment attribute record. As with the create operation, the API operates in a DateTrack context, so changes are applied relative to the effective date supplied by the caller.
• DELETE_ASSIGNMENT_ATTRIBUTE — Removes an assignment attribute record, subject to the same effective-dating semantics used throughout the package.

All three procedures share a common parameter convention documented in the header, including a validation flag that permits validation-only execution without modifying the database, an effective date that determines when the DateTrack operation takes effect, and a business group identifier. The metadata does not expose the complete parameter lists, and these are therefore not reproduced here.

Tables Accessed

According to the documented table references accessed through APPS synonyms, the package reads and writes the following:

• PQP_ASSIGNMENT_ATTRIBUTES_F — The primary DateTrack-enabled entity table holding the assignment attribute records created, updated, and deleted by this API.
• PAY_USER_COLUMNS, PAY_USER_TABLES — Flexible definition tables describing user-defined column and table metadata.
• PAY_USER_COLUMN_INSTANCES_F, PAY_USER_ROWS_F — DateTrack-enabled instance and row structures that store the actual values corresponding to the flexible column definitions.

This combination indicates that assignment attributes are modeled through Oracle HR's descriptive flexfield framework, in which attribute values are persisted generically rather than as discrete physical columns.

Usage Notes

PQP_AAT_API is a server-side API intended for programmatic invocation rather than direct end-user access. It is typically called from concurrent programs, from other PL/SQL packages (the metadata records three dependent packages), and from custom extensions that need to maintain assignment attributes without navigating the Assignment form. The presence of the validation flag allows callers to perform pre-insertion checks during batch loads. Because the API is DateTrack-aware, callers must supply an effective date and a business group identifier in the correct context; failure to do so, or attempting to create attributes for an employee without an assignment on the effective date, results in validation errors. The package is licensed for Human Resources and should be treated as a supported public interface for assignment attribute maintenance.