Search Results header_notesformula




Overview
Explore in AI Chat

Overview

PO_POXPRREQ_XMLP_PKG is the PL/SQL package body associated with the Oracle E-Business Suite concurrent program "POXPRREQ" (Purchase Requisition Print / Requisition Report). Its primary business function is to supply the runtime data, session-level parameters, and formatted output values needed by the XML Publisher (BI Publisher) report definition that renders purchase requisition documents. In Oracle EBS 12.1.1 and 12.2.2, requisition printing is invoked against the PO_POXPRREQ_XMLP concurrent program, and this package acts as the report's server-side logic layer: it sets up lexical and bind parameters before the query executes, resolves descriptive flexfields and account structure identifiers, and formats note text and monetary amounts for presentation.

The package is owned by APPS and is classified in ETRM as OTHER, indicating it is a report-support package rather than a public API. It is not referenced by any other package, confirming its role as a leaf-level report implementation object rather than a reusable library.

Key Procedures and Functions

The package exposes ten documented procedures and functions. The report lifecycle is governed by BeforeReport, which initializes the runtime environment and populates package globals, and AfterReport, which performs any necessary cleanup or post-processing. The get_p_struct_num and get_chart_of_accounts_id functions resolve the chart of accounts and accounting structure identifiers used to drive account flexfield display and validation. The g_requisitiongroupfilter function builds the requisition grouping filter, accepting a requisition number type and a requisition value to constrain the data set.

Three formatting functions handle note text:

  • header_notesformula — resolves header-level note text based on the header note data type and media identifiers. This is the function that corresponds to the user's search term "header_notesformula".
  • line_notesformula — resolves line-level note text using the line note data type and media identifiers.
  • item_noteformula — resolves item-level note text using the item note data type and media identifiers.

Two numeric formatting functions, c_amount_precision and c_total_amount_precision, apply currency-aware decimal precision to individual amounts and totals respectively, accepting the GL currency and the amount value.

Tables Accessed

Consistent with the ETRM metadata, the package reads FINANCIALS_SYSTEM_PARAMETERS (via the APPS synonym) to obtain operating unit and system-level defaults such as base currency and accounting setup. It also reads FND_DOCUMENTS_LONG_TEXT and FND_DOCUMENTS_SHORT_TEXT, the standard EBS document text tables, to retrieve the actual note content resolved by the header, line, and item note formula functions.

Usage Notes

PO_POXPRREQ_XMLP_PKG is invoked indirectly through the POXPRREQ concurrent program and its associated XML Publisher data template; end users do not call it directly. The declared package globals (P_TITLE, P_FLEX_ITEM, P_FLEX_CAT, P_FLEX_ACC, P_REQ_NUM_FROM, P_REQ_NUM_TO, P_SINGLE_REQ_PRINT, and related fields) correspond to the concurrent program's parameters and are populated before the report data model runs. Customizations should treat the package as a report implementation artifact and avoid direct dependency, since the requisition print report is maintained with Oracle's standard report template.