Results for “get_least_date”

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

Overview

PSP_PREGEN is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM metadata as an API of type OTHER. It belongs to the Oracle Grants / Projects family of modules, as indicated by its name (PSP is a common prefix for Grants-related objects) and by its references to award, project, and task identifiers. The package supports the pre-generation and auto-population of distribution lines — typically burden or cost distribution records — prior to final processing. In the context of Oracle EBS 12.1.1 and 12.2.2, PSP_PREGEN functions as an internal engine used to create, validate, and import pre-generated distribution data associated with awards, projects, tasks, and personnel assignments. It bridges human resources, general ledger, and project accounting data to produce the input records required by the Grants distribution process.

Key Procedures and Functions

The package exposes three documented program units.

• IMPORT_PREGEN_LINES — A procedure that imports pre-generated distribution lines into the application tables. It accepts a batch name together with the business group, set of books, operating unit, and an optional GMS/PA installation indicator. It returns standard error buffer and return code OUT parameters, following the concurrent-program convention for reporting success or failure. Its role is to load staged or externally prepared pre-generation records into the distribution interface.
• GET_LEAST_DATE — A function that returns the earliest applicable date given a set of identifying context values: time period, person, general ledger code combination, project, award, task, and distribution date. It is constrained with PRAGMA RESTRICT_REFERENCES (WNDS, WNPS, RNPS), confirming it performs no database writes and is safe for use inside SQL statements. It is used to determine the correct effective date for a distribution line.
• AUTOPOP — A procedure that performs auto-population of pre-generated distribution lines. It accepts the batch name, set of books, business group, operating unit, and GMS/PA install flag, and returns a status value. This is the primary routine that generates distribution records automatically based on configured elements, assignments, and periods.

Tables Accessed

The package reads and writes a broad set of APPS synonyms spanning HR, GL, PA, and Grants schemas.

• GL_CODE_COMBINATIONS — resolves accounting flexfield combinations for distribution lines.
• GMS_AWARDS — supplies award context for Grants distributions.
• HR_ALL_ORGANIZATION_UNITS and HR_ALL_ORGANIZATION_UNITS_TL — provide organization and operating unit information.
• PA_PROJECTS_ALL and PA_TASKS — supply project and task identifiers for distributions.
• PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, and PER_PERIODS_OF_SERVICE — supply person and assignment data used to determine eligibility and effective dates.
• PER_TIME_PERIODS — provides period definitions used in date calculations.
• PAY_ELEMENT_TYPES_F and PSP_ELEMENT_TYPES — define the element types that drive distribution generation.
• PQP_CONFIGURATION_VALUES — supplies configuration parameters governing the auto-population logic.
• PSP_DISTRIBUTION_INTERFACE and PSP_DISTRIBUTION_LINES_S — the interface and base tables where pre-generated and imported distribution lines are staged and stored.

Usage Notes

PSP_PREGEN is an internal package rather than a public API. The ETRM metadata records no other packages referencing it, indicating it is invoked directly by Grants distribution concurrent programs, Oracle Forms, or controlled custom extensions rather than through a documented public interface. IMPORT_PREGEN_LINES and AUTOPOP follow the standard concurrent-program OUT parameter pattern, so they are typically called from concurrent manager executables or from wrapper PL/SQL. GET_LEAST_DATE, being a pure read-only function, may be safely embedded directly in SQL or PL/SQL expressions. Because the package depends on HR, GL, PA, and Grants tables, callers must ensure the correct business group, set of books, and operating unit context is initialized before invocation. Direct modification of the underlying PSP_DISTRIBUTION_INTERFACE and PSP_DISTRIBUTION_LINES_S tables outside this package is not advisable; the package should be treated as the supported pathway for pre-generation processing in both 12.1.1 and 12.2.2 environments.