Search Results complete_formula_rec

Overview

APPS.AMS_FORMULA_PVT_W is a private PL/SQL API wrapper belonging to the Oracle Marketing (AMS) product family within Oracle E-Business Suite 12.1.1 and 12.2.2. It supports the maintenance of marketing formulas — structured expressions used by the Marketing module to calculate campaign costs, budgets, scores, and other derived values — and serves as a thin, forward-declared interface layer that the corresponding public API stack and generated forms logic call into. The package is declared with AUTHID CURRENT_USER and carries a legacy header marker (amswfmls.pls 115.4, dated 2002), indicating it is an early-generation API wrapper in the AMS schema toolkit.

The procedures follow the Oracle Application Object Library (AOL) API conventions: a leading p_api_version argument, p_init_msg_list and p_commit control flags, optionally p_validation_level, and the standard triple of OUT parameters x_return_status, x_msg_count, and x_msg_data for result reporting. The _W suffix indicates this is the wrapper layer, delegating actual business logic to the underlying formula entity handlers.

Key Procedures and Functions

The package exposes twelve documented procedures, organized into two functional clusters: formula header processing and formula entry (line) processing.

Formula-level operations:

• CREATE_FORMULA — Creates a new marketing formula record and returns the generated x_formula_id.
• UPDATE_FORMULA — Modifies an existing formula header, including its associated attribute columns.
• VALIDATE_FORMULA — Performs business-rule validation against supplied formula attribute values without writing to the database.
• VALIDATE_FORMULA_ITEMS — Validates a collection of formula attribute items, typically invoked as part of a multi-row operation.
• VALIDATE_FORMULA_REC — Validates an entire formula record assembled in a PL/SQL record structure.
• COMPLETE_FORMULA_REC — Completes a partial formula record by populating derived or defaulted columns, ensuring the record satisfies mandatory-column requirements before processing.

Formula entry (line-level) operations:

• CREATE_FORMULA_ENTRY — Inserts a new formula entry (component line) associated with a formula header.
• UPDATE_FORMULA_ENTRY — Modifies an existing formula entry.
• VALIDATE_FORMULA_ENTRY — Validates a single entry’s attributes against business rules.
• VALIDATE_FORM_ENT_ITEMS — Validates a set of entry attribute items, supporting bulk user-interface validation.
• VALIDATE_FORM_ENT_REC — Validates an entire formula entry record structure.
• COMPLETE_FORM_ENT_REC — Completes a partial formula entry record, applying defaults and derived values before persistence.

The attribute parameters in these signatures are generically named (p7_a0, p6_a1, and so forth), which reflects JDeveloper/forms generation from the underlying AMS formula entity definition. Numeric attributes default to 0-1962.0724 (the AMS miss-value convention), date attributes to fnd_api.g_miss_date, and character attributes to fnd_api.g_miss_char.

Tables Accessed

The ETRM metadata for this wrapper does not enumerate specific base tables. As the private wrapper for the AMS formula entity, it operates through APPS synonyms resolved at runtime, reading and writing the AMS formula header and formula entry tables that store marketing formula definitions, their attribute values, and their component entries. Validation procedures typically query reference and lookup data, while create, update, and complete procedures write to the entity tables. Because access is mediated by synonym resolution rather than direct schema-qualified references, the object remains portable across the APPS schema boundary.

Usage Notes

AMS_FORMULA_PVT_W is an internal wrapper and is not intended for direct customer invocation. It is invoked by the AMS formula public APIs, by Oracle Forms-based Marketing setup windows that manage formula definitions, and potentially by concurrent programs or internal AMS processing that must create or validate formulas programmatically. Custom code requiring formula maintenance should call the supported public AMS API rather than this _W layer. The generate-and-complete pattern (VALIDATE_*, COMPLETE_*_REC, CREATE_*/UPDATE_*) is standard AOL entity-API design and should be respected if the wrapper is ever referenced in extensions. The package is referenced by zero other documented packages, confirming its role as a leaf-level implementation wrapper beneath the public AMS API surface.