Results for “find_system_data_extract”

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

Overview

PSB_BUDGET_REVISIONS_PVT is an Oracle E-Business Suite private PL/SQL package owned by the APPS schema and classified as a PVT (private) API. It forms the core processing engine for the Position Control (PSB) budget revision functionality within the Public Sector / Human Resources budgeting module. Its principal business purpose is to create, modify, and maintain budget revisions—structured adjustments to an organization's baseline budget—together with the accounts, positions, and funding checks that such revisions require. Because it is a private package, it is not intended for direct invocation by external or customer code; instead, it is consumed by the public Position Control APIs, concurrent programs, reports, and views that together deliver the budget revision feature set.

Key Procedures and Functions

The package exposes twenty-eight documented procedures and functions, all centered on the budget revision lifecycle. The primary entry points are CREATE_BUDGET_REVISION, CREATE_BASE_BUDGET_REVISION, and CREATE_MASS_REVISION_ENTRIES, which instantiate new revision headers and, in the mass case, generate multiple revision entries in a single pass. Structural detail is handled by CREATE_REVISION_ACCOUNTS and CREATE_REVISION_POSITIONS, which build the account and position lines attached to a revision, with corresponding DELETE_ROW, DELETE_REVISION_ACCOUNTS, and DELETE_REVISION_POSITIONS procedures providing maintenance and rollback. Calculation and validation logic is delivered through CALCULATE_POSITION_COST, UPDATE_BASELINE_VALUES, BUDGET_REVISION_FUNDS_CHECK, FIND_ORIGINAL_BUDGET_BALANCE, FIND_FTE, FIND_SYSTEM_DATA_EXTRACT, GET_GL_BALANCE, and GET_ROUNDED_AMOUNT, supporting costing, full-time-equivalent determination, and general ledger balance retrieval. Parameter and constraint handling is performed by APPLY_REVISION_ACCT_PARAMETERS and APPLY_CONSTRAINTS, while CACHE_REVISION_VARIABLES improves performance during processing. MASS_BUDGET_REVISION_CP and CALCULATE_POSITION_COST support the concurrent and cost-capture paths respectively.

Tables Accessed

The package reads and writes through APPS synonyms across several functional areas. Budget revision data resides in PSB_BUDGET_REVISIONS, PSB_BUDGET_REVISIONS_S, PSB_BUDGET_REVISION_ACCOUNTS, PSB_BUDGET_REVISION_ACCOUNTS_S, PSB_BUDGET_REVISION_LINES, and PSB_BUDGET_REVISION_POSITIONS, which together store revision headers, lines, accounts, and positions. Budget configuration and baseline information come from PSB_BUDGET_ACCOUNTS, PSB_BUDGET_GROUPS, PSB_BUDGET_POSITIONS, and PSB_ATTRIBUTE_VALUES. General ledger integration and validation rely on GL_CODE_COMBINATIONS, GL_PERIOD_STATUSES, GL_BC_PACKETS, and GL_BC_PACKETS_S, while FND_CURRENCIES supplies currency definitions for monetary processing. Collectively these tables allow the package to build revisions, validate funding and periods, and prepare general ledger interface records.

Usage Notes

PSB_BUDGET_REVISIONS_PVT is normally invoked indirectly. It is referenced by thirteen other packages, including PSB_BUDGET_REVISION_ACCTS_PVT, PSB_BUDGET_REVISION_POS_PVT, PSB_CREATE_BR_PVT, PSB_GL_INTERFACE_PVT, PSB_HR_POPULATE_DATA_PVT, PSB_POSITION_CONTROL_PVT, PSB_POSITION_PAY_DISTR_PVT, PSB_SUBMIT_REVISION_PVT, PSB_WS_POS3, and the reports PSB_PSBRPBRS_XMLP_PKG, PSB_PSBRPBRT_XMLP_PKG, plus the view PSB_BUDGET_REVISION_SUMMARY_V and PSB_DISCOVERER_FUNCTIONS. It depends on FND_API for the standard API framework and FND_FLEX_EXT for key flexfield validation. Customers and integrators should call the public Position Control APIs rather than this private package directly. Because it underlies concurrent programs, OAF/Forms pages, and reporting, changes to its behavior are governed by Oracle and should not be modified. The package is valid in release 12.1.1 and continues to be supported in 12.2.2.