Search Results c_sob_name

Overview

JA_JAINPRRG_XMLP_PKG is an Oracle Application Object Library (APPS) package body that supports the JA_JAINPRRG XML Publisher (BI Publisher) concurrent program report. The prefix "JA" identifies the object as belonging to the Oracle Financials for India (Asia/Pacific localizations) product family, and the "_XMLP_PKG" suffix indicates that it is an auto-generated XML Publisher report package produced by the XML Publisher report definition generator. Its role is to supply the PL/SQL functions and procedures that the report template invokes through its data model, including derived formulas, group-level filters, before-report and after-report logic, and address/set-of-books lookup logic. The object is classified as OTHER in the ETRM metadata and is not exposed as a public API; it is a private, report-support package. The user search term "c_sob_name" corresponds to a cursor declared inside the package (C_SOB_NAME) that resolves the set of books name from GL_SETS_OF_BOOKS, which supplies the SOB Name value displayed on the report.

Key Procedures and Functions

The package exposes ten documented procedures and functions, all of which serve the report data model:

• CF_PO_NUM_N_RELEASEFORMULA — Concatenates a purchase order number with its release number in the form "PO_NUMBER(release)" for display on the report.
• CF_TOTAL_AMOUNTFORMULA — Sums the individual line amount components (line amount, excise, CVD, additional CVD, customs, CST, LST, freight, octroi, and other charges) into a single total amount value.
• P_ORG_ADDR1VALIDTRIGGER — A validation trigger that resolves the organization name, its formatted address, and the associated set of books identifier and name; this is where the C_SOB_NAME cursor (the "c_sob_name" search term) is declared.
• CF_VENDOR_NAMEFORMULA — Returns the formatted vendor name for the report row.
• CF_VENDOR_SITE_CODEFORMULA — Returns the vendor site code value associated with the row.
• AFTERPFORM — Post-parameter-form logic executed after parameter entry, used to prepare the report run.
• AFTERREPORT — Cleanup/teardown logic executed after the report completes.
• G_INVOICEGROUPFILTER — Group-level filter function used by the XML Publisher template to conditionally render or suppress invoice group sections.
• BEFOREREPORT — Initialization logic executed before the data model fetches rows, used to set session or context values prior to query execution.
• CP_SERIAL_P — Report-specific serial/processing helper, likely supplying serial number or sequence values consumed by the template.

Tables Accessed

The package reads HR_ORGANIZATION_UNITS, HR_LOCATIONS, HR_OPERATING_UNITS, and GL_SETS_OF_BOOKS to derive organization name, address text, set of books identifier, and set of books name (the C_SOB_NAME cursor). In the API context, it also references FND_CONCURRENT_PROGRAMS, FND_CONCURRENT_REQUESTS, V$DATABASE, V$PROCESS, and V$SESSION, accessed via APPS synonyms. These FND and V$ tables are used for concurrent request context, database identity, and session information typically captured by XML Publisher report packages during BEFOREREPORT and AFTERREPORT processing.

Usage Notes

This package is not intended for direct invocation by custom code. It is called exclusively by the XML Publisher runtime when the JA_JAINPRRG concurrent program is submitted. In EBS 12.1.1 and 12.2.2, XML Publisher report packages are executed in the context of the concurrent manager, with BEFOREREPORT running at submission time and AFTERREPORT running on completion. The "_XMLP_PKG" the report definition associates each formula and group filter with its corresponding PL/SQL function. Because no other package references this object (Referenced by 0), it has no downstream dependents and can be considered a self-contained report artifact. Any modification should be made through the XML Publisher report definition so that the auto-generated package is regenerated consistently.