Search Results aprintswitch_p

Overview

APPS.GL_GLXRLSEG_XMLP_PKG is a report-support PL/SQL package in Oracle E-Business Suite that underpins the Oracle General Ledger "Segment Values" concurrent report (commonly registered under the XML Publisher report short name GLXRLSEG). The package serves exclusively as the server-side implementation for a seeded report: it declares the global variables, formula columns, and group-level triggers that the Oracle Reports/BI Publisher engine references when executing the underlying query, and supplies the package-level initialization and cleanup logic through its BeforeReport and AfterReport functions.

Its business function is to enumerate and render the account segment value assignments defined in the Accounting Flexfield for a selected Chart of Accounts, including the position and posting characteristics of each segment as configured in the key flexfield definition. The package contains no procedural business API beyond report execution scaffolding, and is classified in ETRM as API classification "OTHER". This classification, together with the report-specific naming convention and the POSITION, POST_POSITION, and BUDGET_POSITION variables — one of which, POST_POSITION, corresponds to the user's search term "post_position_p" — confirms that the package is intended to be invoked only by the report runtime and not by external custom code.

Key Procedures and Functions

• BeforeReport — Report-level trigger that executes prior to query retrieval; it performs parameter validation and setup of the report's global state.
• AfterReport — Report-level trigger that executes after query retrieval, used for cleanup.
• COA_NAME_p — Accessor returning the Chart of Accounts name used by the report layout.
• APROMPT_p — Accessor returning the value of the APROMPT parameter-controlled prompt.
• APRINTSWITCH_p — Accessor returning the print switch controlling conditional report output.
• VSETID_p — Accessor returning the value set identifier associated with the segment.
• PAPROMPT_p — Accessor returning an alternate prompt value.
• SEGMENT_TYPE_p — Accessor returning the segment type descriptor for the report column.
• PVSETID_p — Accessor returning a second value set identifier.
• POSITION_p — Accessor returning the segment's ordinal position within the key flexfield.
• POST_POSITION_p — Accessor returning the posting position, i.e. the relative ordering used when determining which segment is designated for posting.
• BUDGET_POSITION_p — Accessor returning the budget position configured for the segment.

Tables Accessed

• FND_ID_FLEX_SEGMENTS and FND_ID_FLEX_SEGMENTS_TL — the core key flexfield segment definition tables, supplying segment position, type, and translatable names.
• FND_FLEX_VALUE_SETS — provides the value set identifier and attributes for each segment.
• FND_FLEX_VALIDATION_QUALIFIERS — supplies validation criteria associated with the value sets.
• FND_SEGMENT_ATTRIBUTE_VALUES — supplies the segment attribute flags that determine posting, budgeting, and related behavior, directly driving the POST_POSITION and BUDGET_POSITION report columns.

All access is performed through APPS synonyms, and the package performs read-only retrieval for report presentation.

Usage Notes

The package is invoked exclusively by the Segment Values report when that concurrent program is submitted from the General Ledger responsibility. It is not referenced by any other package in the ETRM inventory (referenced by 0 other packages), and its functions are not designed as public APIs. Customizations should copy rather than modify the package, and direct calls from custom code are discouraged because the package depends on runtime context established by the report engine. Both Oracle EBS 12.1.1 and 12.2.2 use the same package body and source, as the header indicates no version-specific branching; the 120.0 source version applies across both releases.