Search Results per_letter_gen_statuses_pkg




Overview
Explore in AI Chat

Overview

PER_LETTER_GEN_STATUSES_PKG is an Oracle EBS PL/SQL package owned by the APPS schema that supports the assignment status framework used by Oracle Human Resources (PER) and, in particular, the correspondence or letter generation functionality. The package is catalogued under the API classification OTHER, indicating that it is an internal utility package rather than a formally published public API. Its role is to supply supporting logic around assignment status types and the statuses that drive letter generation, including the resolution of unique sequence values and the identification of assignment status conditions. The package is documented in release 12.2.2 and is also present in 12.1.1.

Key Procedures and Functions

The package exposes three documented program units:

  • ASSIGNMENT_STATUS_NOT_UNIQUE — Evaluates whether a given assignment status designation is not unique within the relevant status type structure. It is used to detect ambiguous or duplicated status definitions that could otherwise cause incorrect letter generation results.
  • GET_NEXT_SEQUENCE — Returns the next available sequence value for letter generation statuses. This supports ordered rendering of statuses and stable ordering of records written to the status table.
  • GET_ASSIGNMENT_STATUS — Resolves and returns the assignment status associated with a given context, providing the caller with the correct status designation for downstream processing.

No parameter lists are documented in the ETRM metadata; parameter details should be obtained from the package specification in the database.

Tables Accessed

The package operates against the following documented tables, referenced through APPS synonyms:

Usage Notes

PER_LETTER_GEN_STATUSES_PKG is typically invoked internally by other PER components rather than called directly by customers. The documented dependency information shows the package references the SYS.STANDARD package and is referenced only by itself, while the ETRM metadata records zero dependent packages. In practice the package supports the Oracle HRMS letter and correspondence generation flows, where assignment status types are evaluated and letter generation statuses are sequenced. Customisations that need to alter status sequencing or status resolution should call the published HR APIs instead of this internal utility, since its signature and behaviour are not guaranteed across releases.