Search Results gl_currency




Overview
Explore in AI Chat

Overview

APPS.PO_POXPRREQ_XMLP_PKG is the packaged PL/SQL body that backs the Oracle Purchasing requisition print report, internally identified as POXPRREQ. It is a report-support package rather than a business API; its procedures and functions are invoked by the Oracle Reports runtime during execution of the requisition print concurrent program. The package performs the initialization and formatting work required to render a requisition printout, including resolving descriptive flexfield structure information, determining the chart of accounts context used for accounting flexfield display, filtering requisition rows by requisition number, and resolving note text and numeric formatting used in the report layout.

The user search term "gl_currency" does not correspond to any object documented in this package. The closest documented dependency is the chart of accounts resolution performed against GL_SETS_OF_BOOKS, which establishes the accounting flexfield context for the report. Currency display on requisition printing is generally derived from the requisition and purchase order tables rather than from this package.

Key Procedures and Functions

  • BEFOREREPORT — Report-level initialization function. It determines whether a single requisition is being printed by comparing P_req_num_from and P_req_num_to, and sets P_single_req_print accordingly. It calls the initialization helpers and returns TRUE to allow the report to proceed.
  • AFTERREPORT — Report-level cleanup function, invoked after report completion. It returns TRUE.
  • GET_P_STRUCT_NUM — Resolves the descriptive flexfield structure identifier for the requisition functional area from MTL_DEFAULT_SETS_VIEW and assigns it to the P_STRUCT_NUM report parameter.
  • GET_CHART_OF_ACCOUNTS_ID — Resolves the chart of accounts identifier by joining GL_SETS_OF_BOOKS with FINANCIALS_SYSTEM_PARAMETERS, and assigns the result to the P_CHART_OF_ACCOUNTS_ID report parameter.
  • G_REQUISITIONGROUPFILTER — Group filter function used in the report data model to restrict requisition rows. It evaluates whether the requisition identifier is numeric or alphanumeric and applies the from/to requisition number range parameters accordingly.
  • LINE_NOTESFORMULA — Formula column that resolves and returns the note text associated with a requisition line for display in the report output.
  • ITEM_NOTEFORMULA — Formula column that resolves and returns the note text associated with a requisition item.
  • HEADER_NOTESFORMULA — Formula column that resolves and returns the note text associated with the requisition header.
  • C_AMOUNT_PRECISION — Formatting function returning the currency precision applied to individual amount columns in the report.
  • C_TOTAL_AMOUNT_PRECISION — Formatting function returning the currency precision applied to total amount columns in the report.

Tables Accessed

The package accesses FINANCIALS_SYSTEM_PARAMETERS in conjunction with GL_SETS_OF_BOOKS to determine the chart of accounts identifier used for accounting flexfield display. It reads MTL_DEFAULT_SETS_VIEW to obtain the descriptive flexfield structure number for the requisition functional area. Note resolution is performed against FND_DOCUMENTS_LONG_TEXT and FND_DOCUMENTS_SHORT_TEXT, which supply the long and short note text attached to requisition headers, lines, and items. All tables are referenced through APPS synonyms.

Usage Notes

This package is not a general-purpose API and is classified as OTHER in the ETRM metadata. It is invoked exclusively by the POXPRREQ Oracle Reports executable during execution of the requisition print concurrent program in Oracle EBS 12.1.1 and 12.2.2. It is referenced by zero other PL/SQL packages. Customizations should be limited to the report definition and, where required, to the filter and formula logic in this package; direct invocation from forms or custom concurrent programs is not supported. Because the package is report-runtime scoped, any modification must be regression tested against the requisition print output for both single-requisition and range-based printing modes.