Search Results create_decision_factors

Overview

AS_DECISION_FACTOR_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Oracle Trade Management / Sales Foundation (AS) product family. The package encapsulates the core business logic required to create, maintain, and validate decision factors — the weighted criteria that influence qualification, ranking, and prioritization of leads and opportunities within the Oracle EBS lead-to-opportunity pipeline. The package is declared with AUTHID CURRENT_USER and follows the standard EBS private API convention: it is not intended to be called directly by external consumers but instead is invoked through public wrapper APIs, most notably those declared in AS_OPPORTUNITY_PUB. The "PVT" classification signals that this is an internal, private implementation unit whose interface may change without notice between releases, and whose procedures should only be referenced indirectly through supported public APIs.

Key Procedures and Functions

The package exposes twelve documented procedures and functions. The primary transactional APIs are CREATE_DECISION_FACTORS, UPDATE_DECISION_FACTORS, and DELETE_DECISION_FACTORS. CREATE_DECISION_FACTORS accepts a vertically structured decision factor table of type As_Opportunity_Pub.Decision_Factor_Tbl_Type, standard EBS API control parameters (API version, initialization of message list, commit flag, and validation level), and returns an output table of type decision_factor_out_tbl_type together with the standard return status, message count, and message data. Parameter defaults such as P_Init_Msg_List and P_Commit are set to FND_API.G_FALSE, and the validation level defaults to full validation. The package also exposes a constant G_DEFAULT_NUM_REC_FETCH set to 30, controlling the default fetch batch size.

The remaining procedures are validation helpers called internally by the create, update, and delete logic. VALIDATE_DECISION_FACTOR_REC and VALIDATE_DECISION_FACTOR perform record-level and attribute-level validation against the decision factor entity. VALIDATE_DECISION_FACTOR_CODE, VALIDATE_DECISION_RANK, and VALIDATE_DECISION_PRIOR_CODE validate the business codes and ranking attributes assigned to a factor. VALIDATE_L_DECISION_FACTOR_ID and VALIDATE_LEAD_LINE_ID validate primary and foreign key identifiers against the underlying lead structures. VALIDATE_REQUEST_ID and VALIDATE_CREATE_BY support audit and concurrency checks. Together these routines enforce data integrity before any DML is committed.

Tables Accessed

The package reads and writes the AS_LEAD_DECISION_FACTORS table, which stores the decision factor records themselves, including their codes, ranks, and priority classifications. It references AS_LEAD_LINES_ALL, the lead line base table, to associate decision factors with specific lead lines and to validate lead line identifiers. The package also accesses PLITBLM, the standard EBS PL/SQL index-by table used by the message and validation framework for handling bulk records and error messages. All access occurs through APPS synonyms, consistent with standard EBS naming conventions.

Usage Notes

Because AS_DECISION_FACTOR_PVT is a private package, it is not invoked directly from Oracle Forms, concurrent programs, or customer-written code. Instead, it is called by public layer packages — the ETRM metadata indicates it is referenced by one other package (AS_OPPORTUNITY_PUB) — which surface decision factor maintenance to the Trade Management application UI and to downstream integrations. Developers extending or debugging decision factor behavior on EBS 12.1.1 or 12.2.2 should trace calls forward from AS_OPPORTUNITY_PUB, and treat direct calls to this package as unsupported, since its signature and internals are subject to change in patching and upgrades.