Search Results acct_from_param

Overview

GL_SEL_SEG_TURNOVER_RPT_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the "Segment Turnover" reporting flow within Oracle General Ledger. Its role is to provision the runtime parameters, dynamic SQL fragments, and supporting logic required by an Oracle Reports-based concurrent program that reports period activity and balances across selected accounting flexfield segments. The package encapsulates the parameter values collected at report submission time — ledger, accounting period range, segment ranges, balance type, currency options, and access set — into package-level variables that the report triggers and queries consume at execution. In Oracle EBS 12.1.1 and 12.2.2 the design is unchanged; the package header carries a 2007-era revision ($Header: glxssegs.pls 120.0.12000000.1) and remains part of the standard GL report library. The name "SEL_SEG" refers to selectable segments, and the report presents turnover information for those segments as defined by the Accounting Flexfield structure associated with the ledger. Because it is classified as OTHER rather than as a public API, it is intended for internal consumption by its companion report, not as a general-purpose integration interface.

Key Procedures and Functions

• BEFOREREPORT — The Oracle Reports before-report trigger entry point. It is responsible for initialising the package variables from the report's parameter list, resolving derived context such as the chart of accounts, currency and access set, populating the lexical (dynamic SQL) variables, and performing the validation needed before the report queries execute.
• INT_DOC_NUMBER — A function that supports the "Print Internal Document Number" report option, controlled by PRINT_INTERNAL_DOC_NUM_PARAM. It resolves and returns the internal document number associated with journal entries so the report can display it alongside the accounting lines. This is the object users reach when searching for "int_doc_number".

The package also declares numerous parameter-holding variables (LEDGER_ID_PARAM, PERIOD_FROM_PARAM, PERIOD_TO_PARAM, ACCT_FROM_PARAM, BALANCE_TYPE_PARAM, PRINT_INTERNAL_DOC_NUM_PARAM, and others) and lexical variables (GC_INT_DOC_NUM, GC_BALANCE_WHERE, GC_SECURITY_WHERE, GC_CURRENCY_WHERE) that shape the SQL executed by the report.

Tables Accessed

The package and its report queries reference the following APPS synonyms: GL_LEDGERS and GL_LEDGER_SET_ASSIGNMENTS for ledger and ledger set context; GL_PERIOD_STATUSES to determine open/closed period ranges; GL_ACCESS_SETS, FND_ID_FLEX_STRUCTURES and FND_ID_FLEX_SEGMENTS for security and Accounting Flexfield definition; GL_IMPORT_REFERENCES, AP_INVOICES, AP_BANK_ACCOUNTS, CE_STATEMENT_HEADERS and CE_STATEMENT_LINES for the internal document number and source-document detail shown on journal lines. The package mainly reads these objects to build the report's dynamic WHERE clauses and currency-aware selects.

Usage Notes

The package is invoked exclusively through its Oracle Reports concurrent program, which calls BEFOREREPORT to seed the package state and then uses INT_DOC_NUMBER when internal document numbers are requested. It is not referenced by any other documented package and should not be called directly by custom code, since its variables and lexical strings are designed for a single report run within one session. Customisations to internal document display should be made by extending the report, not the package, to avoid conflicts during patching.