Search Results p_order_column




Overview
Explore in AI Chat

Overview

The APPS.AP_APXVDLBL_XMLP_PKG package is the generated PL/SQL package body associated with the Oracle E-Business Suite XML Publisher (BI Publisher) concurrent program APXVDLBL — the Supplier Mailing Labels report in Oracle Payables. It exists to support report execution under the Oracle EBS report engine: the package holds the report's bind and lexical parameters as package-level globals, provides lifecycle hooks that run before and after the report data model is executed, and exposes SQL fragments and PL/SQL group formulas used by the report's data definition.

The package was last stamped with header version 120.0 dated 2007/12/27, and is declared AUTHID CURRENT_USER. Its API classification in the ETRM repository is OTHER, meaning it is not a public integration API but an internally invoked report-support package. The business purpose of the underlying report is to produce printable mailing labels for supplier sites, which is why the parameter surface is dominated by supplier and site selection attributes: vendor type (P_VENDOR_TYPE/P_VENDOR_TYPE_1), site (P_SITE/P_SITE_1), and the PAY_SITE flag that determines whether Payables payment sites, rather than purchasing or general sites, are selected for label generation.

Key Procedures and Functions

Five callable units are documented.

  • CUSTOM_INIT — a RETURN BOOLEAN initialization function invoked by the report engine at the start of processing. It performs package-level setup, including reading the P_CONC_REQUEST_ID context and resolving default values such as DEFAULT_COUNTRY_CODE, DEFAULT_COUNTRY_NAME, and the sort/print options used later by the label layout.
  • BEFOREREPORT — the pre-report trigger. It establishes the session state required by the data model, including language and territory settings and the vendor/site parameter values, before the main query is executed.
  • AFTERREPORT — the post-report trigger, used to release resources and finalize the run after the XML output has been produced.
  • C_ORDER_BYFORMULA — a group formula returning VARCHAR2 that supplies the dynamic ORDER BY clause. The selected column is driven by P_ORDER_COLUMN and SORT_BY_ALTERNATE, allowing the same report to be sequenced by vendor name, vendor number, or an alternate key.
  • C_ADDRESS_CONCATENATEDFORMULA — the address assembly formula. It takes address lines, city, state, postal code, country name, country code, vendor name, and attention as inputs, and returns a single formatted VARCHAR2 block suitable for printing on a label, respecting the P_PRINT_HOME_COUNTRY flag and the ATTN_MESSAGE text.

Tables Accessed

The documented table reference for this package is AP_SYSTEM_PARAMETERS, accessed via its APPS synonym. The package reads this table to obtain Payables system-level defaults — most notably the home country and related address-formatting attributes — which drive the DEFAULT_COUNTRY_CODE, DEFAULT_COUNTRY_NAME, and P_PRINT_HOME_COUNTRY globals and determine whether the home country is suppressed on the printed label. All remaining supplier and site data is retrieved by the report's own data model queries rather than by this package.

Usage Notes

This package is not intended to be called directly from forms or custom code. It is instantiated by the Oracle EBS concurrent manager when the APXVDLBL (Supplier Mailing Labels) XML Publisher program is submitted, and its procedures are bound as report-level triggers in the corresponding XML Publisher data model and RTF template. The parameter PAY_SITE — the term matched by the user's search — is a package-level variable that controls whether supplier payment sites are included in label output, complementing the P_SITE/P_SITE_1 selections. Because the package is AUTHID CURRENT_USER and owned by APPS, it executes with the APPS schema privileges at runtime. No other package in the repository is documented as referencing it, confirming its role as a leaf-level report support unit. Customizations should be confined to the RTF template or to the concurrent program parameters rather than to this generated package.