Search Results budget_position

Overview

GL_GLXRLSEG_XMLP_PKG is an Oracle E-Business Suite 12.1.1 / 12.2.2 package body owned by APPS and classified under the ETRM as OTHER. It serves as the report logic package for an Oracle Reports-based concurrent program (GLXRLSEG) that produces the Accounting Flexfield Segment Values listing — a General Ledger diagnostic report that presents the structure, prompts, and validation information associated with the segments of a specific Accounting Flexfield structure. The package encapsulates the PL/SQL constructs embedded in the report's data model, including the BeforeReport and AfterReport triggers and a series of formula column or placeholder functions that surface derived values to the report layout. The $Header directive in the source identifies the file as GLXRLSEGB.pls.

The most important logic resides in BeforeReport, which resolves the chart of accounts name, derives the flex value set identifier, application column name, and above-prompt for a requested segment, and reads the GL_ACCOUNT segment attribute that controls printing. The user search term get_position refers to the private cursor get_position declared inside BeforeReport. This cursor accepts a value set id and queries FND_FLEX_VALIDATION_QUALIFIERS for value_attribute_type, filtered on id_flex_code = 'GL#', id_flex_application_id = 101, and the supplied flex_value_set_id, ordered by assignment_date and value_attribute_type. The package uses the result to determine the account qualifier position, initialised to 1, for the report output.

Key Procedures and Functions

Twelve program units are documented in the ETRM metadata. BEFOREREPORT is the report-level pre-query trigger; it performs the name and attribute resolution described above and raises raise_application_error(-20101, null) when the chart of accounts lookup fails. AFTERREPORT provides the corresponding post-report clean-up or terminating logic. The remaining ten units are lightweight accessor functions that expose report-local variables to the layout: COA_NAME_P returns the chart of accounts name, APROMPT_P returns the resolved above-prompt, APRINTSWITCH_P returns the print switch derived from the segment attribute, VSETID_P returns the flex value set id, PAPROMPT_P and PVSETID_P return the corresponding prompt and value set id parameters, SEGMENT_TYPE_P returns the segment type, and POSITION_P, POST_POSITION_P, and BUDGET_POSITION_P return the numeric account positions (regular, posting, and budget) determined for the segment.

Tables Accessed

The package reads five General Ledger and Application Object Library configuration tables through APPS synonyms: FND_FLEX_VALIDATION_QUALIFIERS (validation qualifier definitions used by get_position to classify value attribute types), FND_FLEX_VALUE_SETS (value set metadata), FND_ID_FLEX_SEGMENTS and FND_ID_FLEX_SEGMENTS_TL (joined to obtain the application column name, enabled segment list, and language-specific above-prompt), and FND_SEGMENT_ATTRIBUTE_VALUES (the GL_ACCOUNT attribute value that drives the print switch). All access is read-only.

Usage Notes

This package is not an application programming interface and is not referenced by any other package. It is invoked exclusively by the Oracle Reports executable behind the GL Accounting Flexfield segment values concurrent program or its corresponding request submission path. Customisations should treat it as internal report infrastructure: the documented functions are layout accessors, not callable APIs, and direct invocation from forms or custom code is neither supported nor required. The metadata indicates 0 dependent packages.