Results for “get_status_description”

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

Overview

APPS.PSP_GENERAL is a shared PL/SQL utility package body in the Oracle E-Business Suite HR/Payroll family, commonly associated with the Public Sector/PSP (Payroll, Statutory, and Projects) functionality delivered for Oracle Public Sector Payroll and the Projects/Effort Reporting modules. In EBS 12.1.1 and 12.2.2, it is a VALID database object owned by the APPS schema. Its role is to centralize common lookup, validation, and derivation logic used across the PSP suite and by other EBS modules that must resolve payroll, HR, GL, and Grants-related values. The package body does not define a public API in the FND_API sense (classification OTHER); instead it exposes a broad library of helper procedures and functions — 70 documented program units — that other packages call. ETRM records that it is referenced by 48 other packages and itself references a large set of dictionary and application tables, confirming it is a low-level shared service rather than an entry-point API.

Key Procedures and Functions

The 70 documented units fall into functional groups:

• Payroll and salary helpers: GET_ANNUAL_SALARY, GET_PAYROLL_NAME, GET_ASSIGNMENT_NUM, GET_PERSON_NAME. These resolve payroll names, assignment numbers, and annualized salary values from HR and payroll tables.
• Accounting/flexfield helpers: GET_GL_CCID, GET_GL_VALUES, GET_GL_DESCRIPTION, FIND_CHART_OF_ACCTS, FIND_GLOBAL_SUSPENSE. These build or validate GL code combinations and return GL descriptions and suspense accounts using the Accounting Flexfield.
• Date and business-calendar utilities: BUSINESS_DAYS, LAST_WORKING_DATE, POETA_EFFECTIVE_DATE, GET_GMS_EFFECTIVE_DATE, AWARD_DATE_VALIDATION. These compute business day counts, last working dates, and validate Grants award effective dates.
• Profile and setup helpers: GET_SPECIFIC_PROFILE, IS_LD_ENABLED, MULTIORG_CLIENT_INFO, IGW_PERCENT_EFFORT. These read profile options, determine whether a localization is enabled, return multi-org client information, and compute IGW percent effort.
• Project and transaction helpers: GET_PROJECT_NUMBER, TRANSACTION_CHANGE_PURGEBLE. These resolve project numbers and determine whether a transaction change is purgeable.

The listed names (GET_ANNUAL_SALARY, GET_GL_CCID, TRANSACTION_CHANGE_PURGEBLE, BUSINESS_DAYS, LAST_WORKING_DATE, FIND_CHART_OF_ACCTS, GET_GL_DESCRIPTION, FIND_GLOBAL_SUSPENSE, POETA_EFFECTIVE_DATE, MULTIORG_CLIENT_INFO, GET_SPECIFIC_PROFILE, IS_LD_ENABLED, GET_GMS_EFFECTIVE_DATE, AWARD_DATE_VALIDATION, GET_GL_VALUES, GET_PERSON_NAME, GET_ASSIGNMENT_NUM, GET_PAYROLL_NAME, IGW_PERCENT_EFFORT, GET_PROJECT_NUMBER) represent the documented subset of the 70 units.

Tables Accessed

The package reads and writes through APPS synonyms. Documented tables include: FF_FORMULAS_F (formula definitions), FND_LOOKUP_VALUES (lookups), FND_PRODUCT_INSTALLATIONS (installed products), FND_USER (user identity), GL_CODE_COMBINATIONS (account combinations), GMS_AWARDS_ALL and GMS_IMPLEMENTATIONS (Grants awards and implementations), HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION, and HR_SOFT_CODING_KEYFLEX (HR organizations and soft-coding key flexfield), PAY_ALL_PAYROLLS_F, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_TYPES_F, PAY_LEGISLATION_RULES, and PAY_PAYROLL_GL_FLEX_MAPS (payroll definitions, element entries/types, legislation rules, and payroll GL flexfield mapping). The broader dependency list additionally shows CAC availability tables, FND_CURRENCY, FND_DATE, FND_FLEX_KEYVAL, FND_MESSAGE/FND_MSG_PUB, GL_SETS_OF_BOOKS, HR_POSITIONS_F, HR_WRK_SCH_PKG, MO_GLOBAL, PA_PROJECTS_ALL, PA_TASKS, PA_TRANSACTION_SOURCES, PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F, PER_PAY_BASES, PER_PAY_PROPOSALS, PER_TIME_PERIODS, PQP_CONFIGURATION_VALUES, and the PSP_* tables such as PSP_CLEARING_ACCOUNT, PSP_EFF_REPORTS, PSP_ORGANIZATION_ACCOUNTS, PSP_PAYROLL_SOURCES, and PSP_REPORT_ERRORS.

Usage Notes

PSP_GENERAL is invoked indirectly rather than directly by end users. It is called from other PL/SQL packages (48 referrers documented), from Oracle Forms and OAF pages in the PSP and payroll modules, and from concurrent programs that generate effort reports, validate awards, or derive GL accounting. Because it consolidates payroll, HR, GL, and Grants lookups, customizations and extensions commonly call PSP_GENERAL functions to obtain consistent values rather than re-querying base tables. It is not referenced by any database object itself, meaning it is a leaf-level consumer of the data dictionary and application tables. When upgrading between 12.1.1 and 12.2.2, its helper logic should be treated as internal: direct calls should be avoided where a public API exists, and any custom code depending on it must be revalidated after patching since behavior is bound to the underlying HR, PAY, GL, and GMS schemas.