Search Results p_dblink

Overview

MSC_CL_CONT_COLL_FW is a framework package body in the Oracle Advanced Supply Chain Planning (ASCP) schema, owned by APPS. It supports the collection of planning data by defining and managing "refresh types" that govern how the collection process (the Collections Manager, or CL) determines which entities to collect and how to refresh them. The package is part of the MSC_CL_CONT namespace, which handles continuous or on-demand collection of source data from E-Business Suite and external systems into the planning server. Its central role is to translate a requested collection mode into an entity-level refresh type that downstream collection programs use to decide whether to perform a full refresh, an incremental refresh, or a targeted refresh of specific planning entities.

Key Procedures and Functions

• INIT_ENTITY_REFRESH_TYPE — Initializes the refresh-type state for the collection entities. It establishes the base refresh mode values that the other routines build upon, ensuring a consistent starting point before any organization- or instance-specific overrides are applied.
• SET_CONT_REFRESH_TYPE — Sets the effective refresh type for the collection run based on the supplied context and configuration. This is the primary entry point for establishing the refresh behavior used by the collection tasks.
• SET_CONT_REFRESH_TYPE_ODS — A variant of SET_CONT_REFRESH_TYPE tailored to the operational data store (ODS) path, used when collection is directed at the ODS staging layer rather than the planning schema directly. It applies the same refresh-type logic within the ODS collection context.

The body also declares numerous task-level constants (TSK_RM_*) with default values, such as TSK_RM_DEMANDS := 3 and TSK_RM_PARTNER_CONTACTS := 2, which identify the individual collection entities and their ordering or weighting during collection.

h4>Tables Accessed

• MSC_APPS_INSTANCES — Provides information about configured applications instances participating in collection, used to scope the refresh type to the correct source instance.
• MSC_INSTANCE_ORGS — Supplies the organizations associated with each instance, allowing the package to determine whether a process organization is present (v_process_org_present) and to apply organization-level refresh decisions.
• FND_LOOKUP_VALUES — Supplies lookup codes and meanings that define valid refresh-type values and related configuration, ensuring the package interprets collection modes correctly.
• DUAL — Used for singleton evaluations and simple assignments of computed values.

Usage Notes

MSC_CL_CONT_COLL_FW is invoked internally by the ASCP collection framework rather than directly by end users. The supplied search term "p_dblink" reflects the package's association with distributed collection, where a database link is used to reach remote source instances; the MSC_APPS_INSTANCES and MSC_INSTANCE_ORGS lookups support determining which dblink target is in scope for the refresh operation. The package is referenced by two other packages, indicating it is a shared utility called during the setup and execution of collection runs, including those launched from the Collections Manager concurrent programs. Because it does not expose a public forms interface, it should be treated as an internal API; customizations that call these procedures must preserve the expected refresh-type semantics, and any direct invocation should occur only within the supported collection call sequence.