Search Results g_status_previewing

Overview

AMS_WFMOD_PVT is a private (PVT) PL/SQL package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to contain the workflow procedures that support Model Building and Scoring within Oracle Marketing. The package orchestrates the lifecycle of data mining models and scores, acting as the integration layer between Oracle Marketing's model management user interface and the underlying Oracle Advanced Analytics (data mining) engine. The module is identified by the constant G_PKG_NAME and is deployed from the source file amsvwmdb.pls.

The user search term "initialize_var" relates to the internal variable initialization logic embedded within the package. The package body defines an extensive set of package-level constants that function as state and status enumerations, which are initialized at invocation time. These include model and score status values such as G_STATUS_DRAFT, G_STATUS_BUILDING, G_STATUS_SCORING, G_STATUS_AVAILABLE, G_STATUS_COMPLETED, G_STATUS_QUEUED, G_STATUS_PREVIEWING, G_STATUS_INVALID, and G_STATUS_FAILED. Object type constants (G_OBJECT_TYPE_MODEL = 'MODL', G_OBJECT_TYPE_SCORE = 'SCOR') and preview control constants (G_PREVIEW_REQUEST, G_PREVIEW_STARTED, G_PREVIEW_COMPLETE) are similarly initialized. These variables drive the decision logic throughout the workflow procedures.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents 16 procedures and functions. Core workflow orchestration is handled by STARTPROCESS, which initiates the model build or scoring workflow. VALIDATE_DATA performs pre-execution validation of the source data and parameters, while VALIDATE_CONCURRENCY verifies concurrent processing eligibility. AGGREGATE_SOURCES and TRANSFORM prepare and shape the input data set prior to mining.

• STARTPROCESS — Initiates the workflow for model building or scoring.
• SELECTOR — Selects the appropriate workflow path or process branch.
• VALIDATE_DATA — Validates source data and input parameters.
• AGGREGATE_SOURCES — Consolidates data sources for mining.
• TRANSFORM — Applies transformations to the prepared data.
• COMMAND — Issues commands to the mining engine.
• CHECK_RESPONSE — Interprets responses returned from the dequeue/engine.
• COLLECT_RESULTS — Gathers and stores the results of the mining run.
• RESET_STATUS — Returns an object to its original state.
• UPDATE_OBJ_STATUS — Updates status on the underlying model or score object.
• CANCEL_PROCESS — Cancels an in-flight build or scoring operation.
• CHANGE_SCHEDULE — Modifies the scheduling of a queued process.
• VALIDATE_CONCURRENCY — Checks concurrency prerequisites.
• IS_PREVIEWING — Determines whether an object is in preview mode.
• GET_ORIGINAL_STATUS — Retrieves the pre-operation status of an object.
• OK_TO_PROCEED — Confirms that processing may continue.

Tables Accessed

The package operates against three documented base tables accessed via APPS synonyms. AMS_DM_MODELS_ALL_B stores model definitions and status, and is updated as models progress through build states. AMS_DM_SCORES_ALL_B stores score definitions and outcomes. AMS_DM_TARGETS_B holds target metadata used during model and score configuration. The package reads and writes status columns and log flags on the model and score tables as workflows transition through their statuses.

Usage Notes

AMS_WFMOD_PVT is a private package invoked indirectly through Oracle Marketing forms, concurrent programs, and the workflow background engine rather than by direct customer call. It is referenced by three other packages, which delegate model building and scoring operations to it. Standard deployments should not customize this package body, as it is an Oracle-owned private API subject to patching. Customizations should rely on documented public APIs and the AMS schema's supported extension points.