Search Results p_common_org




Overview
Explore in AI Chat

Overview

APPS.BOM_BOMRASSY_XMLP_PKG is the server-side PL/SQL package that backs the Oracle E-Business Suite concurrent program commonly known as "Bill of Material Report (Assembly)". Its header declares it as a package specification compiled under the APPS schema, with the original source file BOMRASSYS.pls carrying a header marker dated 2007. The package is a report driver for an XML Publisher (BI Publisher) enablement of the classic Bill of Materials assembly report, meaning it is responsible for accepting concurrent program parameters, building the SQL where-clauses that filter the query, and performing the before- and after-report setup and teardown logic that the XML Publisher engine calls at runtime. In the context of both EBS 12.1.1 and 12.2.2, the package is classified as API classification "OTHER" and is not a public or dedicated API; it is a report-support package.

Key Procedures and Functions

  • BEFOREREPORT — The standard XML Publisher before-report hook. It is invoked by the report engine before any query is executed and performs parameter initialization and defaulting. This is where the package typically resolves global parameters such as P_ORG_ID, P_ASSEMBLY, P_COMMON, and the various where-clause variables.
  • AFTERREPORT — The standard XML Publisher after-report hook. It is invoked once the report data has been produced and handles any final cleanup or post-processing required by the report run.
  • GET_COMMON_ORG — Takes a common organization identifier as input and returns a VARCHAR2. It resolves the "common organization" reference used by the report so that assemblies belonging to a common bill can be reported against the correct organization context.
  • ORG_CODEFORMULA — Takes an organization identifier as input and returns a CHAR. This function is the one matched by the user's search term "org_codeformula". It is a formatting function that transforms an organization ID into its organization code (a display-friendly name), and it is referenced directly from the report's RTF/XSL layout to render the ORGANIZATION_CODE column in the output.

Tables Accessed

The package specification declares a wide set of public package variables used as report parameters (P_ASSEMBLY, P_STRUCT_ASSY, P_ORG_ID, P_BOM_OR_ENG, P_ITEM_FROM, P_ITEM_TO, P_CATG_FROM, P_CATG_TO, P_ALTERNATE, P_ORG_HIERARCHY, P_SEQUENCE_ID, P_ORG_CODE, P_CATEGORY, and others). The documented tables referenced via APPS synonyms are:

  • BOM_LISTS and BOM_LISTS_S — the bill of materials lists and their base tables, which supply the assembly structures reported.
  • MTL_PARAMETERS — the inventory organization parameters, used to validate the organization and derive defaults for the report.
  • DUAL — used for scalar computations and single-row lookups within the report logic.
  • PLITBLM — the standard Oracle Reports/XML Publisher support table used by the pl/sql toolkit for report runtime bookkeeping.

Usage Notes

BOM_BOMRASSY_XMLP_PKG is not intended for direct invocation by custom code. It is driven by the concurrent program definition associated with the BOM Bill of Materials Report, and the XML Publisher engine invokes BEFOREREPORT and AFTERREPORT automatically. The functions GET_COMMON_ORG and ORG_CODEFORMULA are referenced from within the report layout to compute display values for organization-related fields. Because the package spec exposes these references as public globals, any customization that touches the report should preserve them. No other packages reference this package in the ETRM metadata. When debugging an "org_codeformula" issue, the function ORG_CODEFORMULA and the P_ORG_ID, P_ORG_CODE, and P_COMMON_ORG variables are the relevant points to inspect, since they determine how the organization code is derived and displayed on the report output.