Search Results get_gl_values

Overview

PSP_GENERAL is a shared utility package in the Oracle EBS Applications (APPS) schema that centralizes common PL/SQL helper logic used across the payables, projects, human resources, and grants management modules of Oracle EBS 12.1.1 and 12.2.2. It is classified as an OTHER API rather than a business-flow API, reflecting its role as a reusable library of accessors, validation routines, and lookups rather than a transactional interface. The package is declared AUTHID CURRENT_USER and exposes 70 documented procedures and functions, and it is referenced by 48 other packages, indicating broad dependency across the suite. Because it supplies cross-module services such as salary retrieval, GL account resolution, effective-date calculation, and profile lookups, it functions as a foundational component that many application programs call rather than a user-facing feature in its own right.

Key Procedures and Functions

The package provides several categories of service. Payroll and compensation helpers include GET_ANNUAL_SALARY, which returns an assignment's annual salary as of a session date, and GET_PAYROLL_NAME, GET_ASSIGNMENT_NUM, and GET_PERSON_NAME, which resolve descriptive names from identifiers. General ledger integration is served by GET_GL_CCID, which returns a code combination identifier for a payroll and cost keyflex configuration, along with FIND_CHART_OF_ACCTS, GET_GL_DESCRIPTION, GET_GL_VALUES, and FIND_GLOBAL_SUSPENSE for chart-of-accounts and suspense-account resolution. Date and calendar utilities include BUSINESS_DAYS, LAST_WORKING_DATE, and POETA_EFFECTIVE_DATE, which determine valid effective dates for payroll and project/award/task combinations. Grants and projects functionality is represented by GET_GMS_EFFECTIVE_DATE, AWARD_DATE_VALIDATION, IGW_PERCENT_EFFORT, and GET_PROJECT_NUMBER. Supporting infrastructure routines include MULTIORG_CLIENT_INFO, GET_SPECIFIC_PROFILE, IS_LD_ENABLED, TRANSACTION_CHANGE_PURGEBLE, and GET_ASSIGNMENT_NUM. In the context of the search term "add_report_error," the package's error-handling conventions apply, as callers invoke these routines and must capture the OUT return-status parameters or raised exceptions to surface report errors.

Tables Accessed

The package reads and writes documented EBS tables through APPS synonyms. Payroll and element data is drawn from PAY_ALL_PAYROLLS_F, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_TYPES_F, PAY_LEGISLATION_RULES, and PAY_PAYROLL_GL_FLEX_MAPS. Financial data is accessed via GL_CODE_COMBINATIONS and HR_SOFT_CODING_KEYFLEX for account and keyflex resolution. Human resources and organization data comes from HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION. Grants and award information is retrieved from GMS_AWARDS_ALL and GMS_IMPLEMENTATIONS. Application infrastructure is queried through FND_LOOKUP_VALUES, FND_PRODUCT_INSTALLATIONS, FND_USER, and the payroll formula table FF_FORMULAS_F. These tables support the salary, GL, effective-date, and profile operations described above.

Usage Notes

PSP_GENERAL is typically invoked from other PL/SQL packages, OAF or Forms-based EBS pages, and concurrent programs rather than called directly by end users. Given its broad dependency footprint of 48 referencing packages, changes to its behavior can ripple across multiple modules, so it should be treated as a shared resource requiring careful regression testing during upgrades from 12.1.1 to 12.2.2. Custom code may call its lookup and date functions to reuse standard EBS logic. When integrating these routines, developers should implement robust error handling and inspect OUT status parameters, aligned with the "add_report_error" requirement, to ensure failures are propagated correctly to reporting layers.