Search Results p_all_orgs

Overview

APPS.BOM_BOMRASSY_XMLP_PKG is the server-side PL/SQL package body associated with the Oracle E-Business Suite concurrent program that produces the Bill of Materials Routing Assembly report. Within Oracle EBS 12.1.1 and 12.2.2, this package belongs to the Oracle Bills of Material (BOM) product family and is classified as "OTHER" in the ETRM API registry. Rather than exposing a public callable API, its procedures are designed to be invoked by the Oracle Reports runtime engine through the XML Publisher (BI Publisher) integration layer, which is why the routine names follow the established BEFORE_REPORT / AFTER_REPORT convention used by standard concurrent report packages.

The central business responsibility of the package is to prepare the reporting data set for a multi-organization manufacturing scenario. Its most prominent logic, triggered by the user's search term p_all_orgs, is the handling of the organization selection parameter. When P_ALL_ORGS equals 1, the package expands the request to all organizations sharing the same master organization as the current organization, filtered by the organization access view for the invoking responsibility. When it equals 2, organization resolution is delegated to the organization hierarchy API. This design lets the same report serve a single inventory organization or a consolidated, multi-organization view.

Key Procedures and Functions

The package exposes four documented routines:

• BEFOREREPORT — Executes the initialization logic prior to the report body. It captures the concurrent request identifier, evaluates the item and category range parameters, resolves the organization list from P_ALL_ORGS, allocates a new sequence identifier from BOM_LISTS_S, and seeds the BOM_LISTS table so the report can restrict itself to the selected organizations.
• AFTERREPORT — Performs the complementary teardown after the report completes, cleansing the temporary BOM_LISTS entries created for the run.
• GET_COMMON_ORG — Returns the master organization identifier that is common to the organizations in the reporting scope. This value underpins the requirement that all organizations reported on must share a single master organization.
• ORG_CODEFORMULA — Supplies the organization code value presentation used by the report layout, typically formatting the organization identifier into a display code for the output columns.

Tables Accessed

• BOM_LISTS and BOM_LISTS_S — the sequence supplies the run identifier, and BOM_LISTS is populated with the resolved organization identifiers, sequence identifier, and alternate designators that scope the report query.
• MTL_PARAMETERS — read to resolve the master organization relationship between the current organization and the candidate organizations.
• DUAL — used for the single-row sequence selection.
• PLITBLM — the standard PL/SQL table structure supporting in-memory list manipulation within the report logic.

Usage Notes

This package is not intended to be called directly from custom forms or client code. It is invoked by the Oracle Reports runtime when the associated BOM Routing Assembly concurrent program is submitted. The P_ALL_ORGS parameter drives the widest functional variation in behavior, so submit requests should set it deliberately: value 1 for all accessible organizations sharing the master organization, value 2 for hierarchy-based selection, and other values for single-organization reporting. Because organization resolution for value 1 relies on ORG_ACCESS_VIEW and the responsibility profile options, the report output is naturally constrained to organizations the invoking responsibility may access.