Search Results cf_vendor_nameformula

Overview

JA_JAINPRRG_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the JA (Latin America / Asia localization) India purchase register report, an XML Publisher (BI Publisher)-based concurrent program. The suffix _XMLP_PKG identifies this as the publishing engine support package automatically generated for an XML Publisher concurrent program named JAINPRRG. Its business purpose is to assemble, format, and emit the data required for the Indian Purchase Register, a statutory-style report that lists vendor invoices and their component tax and cost elements (excise, CVD, additional CVD, customs, CST, LST, freight, octroi, and other charges) over a user-specified date range and operating unit.

In the 12.1.1 and 12.2.2 architectures, packages of this type act as the bridge between the concurrent program definition and the XML report template. They expose the report's bind parameters, define formula columns consumed by the RTF/XML layout, and implement the standard report triggers (BeforeReport, AfterPForm, AfterReport). Because the report is a Latin America/India localization deliverable, it is registered under the JA product family and is not part of the core Financials product line.

Key Procedures and Functions

The package declares ten documented procedures and functions, plus a number of public variables (date, org, vendor, run number, and SOB parameters) that hold the runtime context of the concurrent request.

• CF_VENDOR_NAMEFORMULA — A formula column that resolves a supplier (vendor) identifier to its display name, typically via the vendor name lookup against AP supplier tables. This is the function corresponding to the user's search term "cf_vendor_nameformula."
• CF_VENDOR_SITE_CODEFORMULA — A formula column returning the supplier site code derived from a supplier site identifier.
• CF_PO_NUM_N_RELEASEFORMULA — A formula column that concatenates or formats the purchase order number with its release number for display on the register.
• CF_TOTAL_AMOUNTFORMULA — A formula column that aggregates the individual cost components (line amount, excise, CVD, additional CVD, customs, CST, LST, freight, octroi, and others) into a consolidated invoice total.
• P_ORG_ADDR1VALIDTRIGGER — A validation trigger used to populate or validate the organization address parameter.
• AFTERPFORM, BEFOREREPORT, AFTERREPORT — The standard Oracle Reports XML Publisher package triggers, invoked at the corresponding lifecycle events to initialize parameters, prepare data, and clean up after the report executes.
• G_INVOICEGROUPFILTER — A data-model group filter controlling which invoice records are included in the report output.
• CP_SERIAL_P — A function returning the program's serial number used for report sequencing or logging.

Tables Accessed

The package's documented table references, accessed through APPS synonyms, are primarily Oracle Reports and concurrent manager infrastructure rather than transactional tables: FND_CONCURRENT_PROGRAMS and FND_CONCURRENT_REQUESTS are read to identify the current request and its program definition, while V$DATABASE, V$PROCESS, and V$SESSION are used for report session and database context. Transactional purchase register data is supplied through the underlying report query and localization views associated with the JAINPRRG program rather than being declared as direct references in the package metadata.

Usage Notes

JA_JAINPRRG_XMLP_PKG is invoked automatically by the Oracle Reports engine when the JAINPRRG XML Publisher concurrent program is submitted. It is not referenced by any other package, confirming its role as a report-specific support unit. The user-facing "cf_vendor_nameformula" field is a report formula column; when users see an incorrect or blank supplier name, the diagnostic path leads to this function and the underlying vendor identifier parameter. Customization of this package is strongly discouraged, as it is a generated, localization-owned object.