Search Results bim_source_code_pkg




Overview
Explore in AI Chat

Overview

APPS.BIM_SOURCE_CODE_PKG is a PL/SQL package that supports source code loading and maintenance within the Oracle E-Business Suite Business Intelligence module for Marketing (BIM). Its principal role is to reconcile and populate marketing source code data used by Oracle Marketing and its associated campaign, event, and offer infrastructure. The package is defined with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than the package owner, a design choice consistent with many APPS-tier utilities that must respect the caller's security context.

The header comment identifies the package as a nonshipped ("noship") development artifact dated 2005, which corresponds to the 11.5.10 / 12.0 era of the application. Nonetheless, the object remains present and documented in Oracle EBS 12.1.1 and 12.2.2, where it continues to be catalogued with an API classification of OTHER, indicating it is a supporting utility rather than a public, formally versioned API.

Key Procedures and Functions

The ETRM metadata documents a single procedure, LOAD_DATA. This procedure is the package's sole entry point and is responsible for orchestrating the load of source code information into the marketing data model. Its signature follows Oracle's standard PL/SQL API conventions, accepting an API version number, an initialization message list flag, and a validation level, while returning message count, message data, and a return status through OUT parameters.

  • LOAD_DATA — Performs the core data load operation, populating and reconciling source code records across the marketing and business intelligence staging tables. It follows the FND_API error-handling pattern, allowing callers to control validation strictness and to inspect return messages on completion.

No additional procedures or functions are documented for this package. Customizations and extensions should confine themselves to invoking LOAD_DATA rather than relying on internal implementation details, which are not part of the documented interface.

Tables Accessed

The package reads from and writes to a set of marketing and business intelligence tables through APPS synonyms, reflecting its role as a bridge between source code definitions and marketing campaign execution:

Usage Notes

BIM_SOURCE_CODE_PKG is referenced by two other packages, indicating it participates in a larger processing chain rather than being called directly by end users. It is most commonly invoked from backend batch processing, concurrent program logic, or dependent PL/SQL packages that require source code data to be refreshed before downstream marketing analytics or reporting runs.

Because the package is classified as OTHER and carries a "noship" header, it should be treated as an internal utility. Custom code that invokes LOAD_DATA must supply the API version, validation level, and message list parameters and must check X_RETURN_STATUS on return. Oracle recommends invoking such loads during scheduled maintenance windows, since the procedure touches multiple AMS and BIM tables and updates optimizer statistics via DBMS_STATS. Direct modification of the package body is not supported; any required extension should be implemented in custom packages that call the documented interface.