Search Results p_order_by1

Overview

PSB_GL_INTERFACE_PVT is a private PL/SQL API belonging to the Oracle Public Sector Budgeting (PSB) product family within the Oracle E-Business Suite. Its primary business function is to generate and manage General Ledger interface data on behalf of PSB budgeting and revision workflows. The package sits between PSB transaction logic and the Oracle General Ledger, assembling journal records, budget journals, and adopted budget entries, then populating the GL_INTERFACE staging tables so that the standard GL Journal Import program can create the resulting journal entries.

The API classification of "PVT" indicates that this package is intended for internal use by other PSB components rather than for direct customer invocation. Consistent with that designation, the ETRM documentation records that PSB_GL_INTERFACE_PVT is referenced by two other packages — PSB_PSBRPBRS_XMLP_PKG and PSB_SUBMIT_REVISION_PVT — which confirm its role as a supporting utility within the PSB revision and reporting architecture. The package depends on FND_API and the SYS STANDARD package, reflecting adherence to the standard EBS API error-handling conventions and PL/SQL runtime primitives.

Key Procedures and Functions

The documented interface exposes six procedures and functions. Each addresses a distinct stage of budget or revision journal preparation:

• CREATE_REVISION_JOURNAL — Builds the GL journal entries that correspond to a PSB budget revision, allowing revised amounts to be reflected in General Ledger.
• TRANSFER_GLI_TO_GL_CP — Moves records from the GL interface staging area into General Ledger, typically associated with a concurrent program that drives the transfer.
• CREATE_BUDGET_JOURNAL_CP — Concurrent-program-oriented routine that creates budget journals from PSB budget data.
• CREATE_ADOPTED_BUDGET_CP — Generates journals for adopted budget amounts, supporting the legislative or administrative adoption cycle.
• GET_QUALIFIER_SEGNUM — Resolves the segment number of a qualifier within the key flexfield structure, used to correctly map accounting flexfield segments.
• FIND_DOCUMENT_POSTING_STATUS — Retrieves the posting status of a document so callers can determine whether associated GL entries have been posted.

Tables Accessed

The package reads and writes a defined set of tables through APPS synonyms. On the GL side, it accesses GL_INTERFACE, GL_INTERFACE_CONTROL, GL_INTERFACE_CONTROL_S, GL_BC_PACKETS, GL_BC_PACKETS_S, and GL_JOURNAL_IMPORT_S to stage and control journal import activity; GL_JE_CATEGORIES and GL_JE_SOURCES to validate journal categories and sources; GL_PERIOD_STATUSES to confirm open accounting periods; GL_BUDGET_VERSIONS to align budget journals with the correct version; and GL_CODE_COMBINATIONS for account validation. On the application foundation side, FND_ID_FLEX_SEGMENTS supports key flexfield segment resolution, FND_LANGUAGES enables multilingual descriptions, and FND_PRODUCT_GROUPS identifies the operating context. PSB_BUDGET_ACCOUNTS provides the PSB budget account mapping that feeds journal generation.

Usage Notes

Because PSB_GL_INTERFACE_PVT is a private API, it is not intended for direct invocation by end users or custom extensions. It is invoked internally by PSB concurrent programs and by the PSB_SUBMIT_REVISION_PVT and PSB_PSBRPBRS_XMLP_PKG packages during revision submission and budget reporting. In Oracle EBS 12.1.1 and 12.2.2, execution ultimately populates GL_INTERFACE, after which the standard Journal Import concurrent program creates the journals. Customers should treat this package as read-only reference material and rely on supported PSB flows — such as submitting budget revisions — rather than calling its procedures directly, since signatures and behavior may change without notice.