Search Results get_rev_gl_header_id_line_num

Overview

PA_UBR_UER_SUMM_PKG is an Oracle Projects package in the APPS schema that supports the generation and summarization of Unbilled Receivable (UBR) and Unearned Revenue (UER) balances. In Oracle EBS Projects, UBR represents revenue recognized but not yet billed to the customer, while UER represents amounts billed to the customer but not yet recognized as revenue. This package provides the PL/SQL infrastructure that extracts, aggregates, and posts the general ledger account balances associated with these two categories, enabling the reconciliation of Projects subledger activity against GL balances by accounting period.

The package is declared with AUTHID CURRENT_USER and uses a set of package-level global variables to hold invocation context, including organization, set of books, chart of accounts, cost and accounting segment values, GL period name, GL start and end dates, and various GL header and line identifiers. These globals are initialized at runtime, allowing the individual procedures to share state across the processing of invoices, revenue, and summary balances. The header indicates the file was last modified under version 120.1, and the package is classified as an OTHER API, meaning it is not published for unrestricted public use but is invoked by Projects functionality and dependent packages.

Key Procedures and Functions

• CREATE_UBR_UER_SUMMARY_BALANCE — The primary entry point. It accepts the from/to project number range and the GL period name and orchestrates the creation of the UBR/UER summary balance records.
• INITIALIZE — Sets up the package global variables and invocation context prior to processing.
• PROCESS_DRAFT_INVOICES — Processes draft invoice data to derive billed amounts for the UBR/UER summarization.
• PROCESS_DRAFT_REVENUES — Processes draft revenue data to derive recognized revenue amounts for the summarization.
• PROCESS_UBR_UER_SUMMARY — Performs the core aggregation and writes the summary records.
• GET_SEG_VAL — Retrieves a specific accounting or cost segment value from a code combination.
• GET_GL_PERIOD_NAME — Returns the GL period name associated with the requested period or date context. This is the function most commonly referenced by callers searching for period-name derivation logic.
• GET_GL_START_DATE and GET_GL_END_DATE — Return the start and end dates of the GL period, used to bound the accounting window.
• GET_INV_GL_HEADER_ID_LINE_NUM and GET_REV_GL_HEADER_ID_LINE_NUM — Return the GL journal header identifier and line number for invoice and revenue postings respectively, linking subledger activity to GL_JE_HEADERS and GL_JE_LINES.

Tables Accessed

The package reads and writes through APPS synonyms. It queries PA_PROJECTS_ALL and PA_IMPLEMENTATIONS/PA_IMPLEMENTATIONS_ALL for project and installation context. Draft invoice and revenue data are read from PA_DRAFT_INVOICES_ALL and PA_DRAFT_REVENUES_ALL, with intermediate results in PA_DRAFT_REV_INV_TEMP. Summary output is written to PA_UBR_UER_SUMM_ACCT and its corresponding sequence PA_UBR_UER_SUMM_ACCT_S. GL activity is reconciled against GL_JE_BATCHES, GL_JE_HEADERS, GL_JE_LINES, GL_PERIOD_STATUSES, and GL_CODE_COMBINATIONS. Receivables linkage is provided through RA_CUSTOMER_TRX_LINES_ALL and RA_CUST_TRX_LINE_GL_DIST_ALL.

Usage Notes

PA_UBR_UER_SUMM_PKG is invoked from Oracle Projects concurrent programs that produce UBR/UER summary balances and is referenced by five other packages. The GET_GL_PERIOD_NAME function is frequently leveraged by custom extensions and dependent packages needing to derive a GL period from a date. Because the package is classified as OTHER, custom code should treat it as internal and validate signatures against the specific EBS release (12.1.1 or 12.2.2) before use.