Search Results get_db_defaults

Overview

The APPS.PER_BULK_APP_ASG_CHANGE_PKG package is an Oracle E-Business Suite database object stored in the APPS schema and classified under the "OTHER" API category in the ETRM repository. Its documented status is VALID across the 12.1.1 and 12.2.2 releases. The package supports bulk processing of assignment-related change transactions within Oracle Human Resources (PER), specifically those originating from the applicant and assignment management flows that generate events, bookings, letters, and secondary status records. Rather than enforcing a single-assignment transactional update, the package centralizes validation, defaulting, and row-level update logic so that multiple assignment change records can be processed consistently. The prefix BULK indicates the code path is intended for set-based handling of applicant/assignment changes, while APP_ASG_CHANGE identifies the functional scope as application and assignment change management.

Key Procedures and Functions

ETRM documents three callable units in this package. Parameter lists are not published in the metadata and are therefore not reproduced here.

• GET_DB_DEFAULTS — Retrieves server-side and database-level default values required before an assignment change can be applied. This typically includes session context and organization defaults that the subsequent validation and update steps depend upon, ensuring the change is evaluated against the correct business group and session.
• VALIDATE_ASG_CHANGE — Performs the business-rule validation of a pending application or assignment change. It confirms that the proposed change is permissible given the current assignment, applicant, secondary status, and related HR data, returning or raising errors where the change violates HR policy or data integrity rules.
• UPDATE_ROW — Executes the actual row-level update to the assignment change record after defaults are resolved and validation succeeds. This is the final write step in the bulk flow.

Tables Accessed

The package references the following tables through APPS synonyms:

• PER_ALL_ASSIGNMENTS_F — the core assignment date-tracked table; read to evaluate the current assignment and written when assignment changes are applied.
• PER_APPLICATIONS — applicant records associated with the change being processed.
• PER_SECONDARY_ASS_STATUSES — secondary assignment status lines validated and updated alongside the assignment.
• PER_EVENTS — HR events generated or updated as a result of the change.
• PER_BOOKINGS — booking records linked to the applicant or assignment activity.
• PER_LETTER_REQUESTS and PER_LETTER_REQUEST_LINES — letter generation requests and their lines triggered by the change.
• FND_SESSIONS — the current application session, used for context and default derivation.

Usage Notes

This package is an internal HR utility rather than a public, supported API. It is not referenced by any other documented package (zero inbound references), so it functions as a leaf dependency invoked directly by the HR forms or concurrent processing logic that drives applicant and assignment changes. In practice it would be called from the Assignment, Applicant, or related HR maintenance forms during bulk or multi-row change operations, and potentially from concurrent programs that apply assignment changes in a set-based manner. Because it is classified as "OTHER" rather than a certified public API, customizations should avoid calling it directly; instead, standard HR APIs and form-based flows should be used. Its dependencies are limited to the SYS.STANDARD package, indicating a self-contained implementation with no reliance on other APPS packages.