Results for “chg_req_num_mode”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.OKE_CHG_REQUESTS_PKG package body implements the server-side business logic for Oracle E-Business Suite change request management, part of the Oracle Contracts (OKE/OKC) module family. A change request represents a controlled amendment to an existing contract, and this package provides the procedural interface used by the Change Request form and dependent subsystems to create, lock, modify, validate, and workflow-route those requests. The package has a declared status of VALID in the APPS schema and carries an API classification of OTHER, indicating that it is an internal implementation package rather than a formally published public API. In Oracle EBS 12.1.1 and 12.2.2 the package operates against the same core contract tables and is not itself referenced by any other database object, so its consumers are application-tier artifacts such as forms and concurrent processes rather than other PL/SQL units.

Key Procedures and Functions

• START_WF_PROCESS — Initiates the Oracle Workflow (WF_ENGINE) process associated with a change request, driving the approval and notification routing for the request lifecycle.
• INSERT_ROW — Creates a new change request record in the underlying change request entity, including assignment of the change request number.
• LOCK_ROW — Acquires a row-level lock on an existing change request to enforce optimistic concurrency control during update operations.
• UPDATE_ROW — Persists modifications to an existing change request record after validation.
• VALIDATE_CHG_REQUEST_NUM — Validates the change request number, typically by checking uniqueness and structural correctness before insert or update.
• CHG_REQ_NUM_TYPE — Returns the numbering type applicable to change request number generation, used to drive the numbering scheme.
• CHG_REQ_NUM_MODE — Returns the numbering mode, complementing the type function in resolving how numbers are allocated.

Tables Accessed

The package reads and writes OKE_CHG_REQUESTS, the primary change request entity, and accesses the OKE_CHG_REQUESTS_S sequence for surrogate key generation; references to OKE_CHG_REQUESTS_S in documentation typically derive from the underscore-suffixed sequence name the user searched for. It consults OKE_CHG_LOGS for change tracking and audit history, and OKE_K_HEADERS together with OKC_K_HEADERS_B for the contract header that the request modifies. Numbering behavior relies on OKE_NUMBER_OPTIONS and the OKE_NUMBER_SEQUENCES_PKG package. DUAL supports single-row PL/SQL evaluation. Supporting infrastructure includes FND_MESSAGE for translatable message text, APP_EXCEPTION for error propagation, and WF_ENGINE for workflow invocation.

Usage Notes

The package is invoked principally from the Oracle Contracts change request form and related UI actions, where insert, lock, update, and validate operations map directly to end-user form events. Workflow initiation occurs when a request is submitted for approval. Custom integrations may call the package only with caution: it is classified OTHER, its parameter lists are not part of a supported public contract, and behavior may differ between 12.1.1 and 12.2.2. Direct table access by custom code bypasses validation and numbering logic and should be avoided. The package does not depend on any other object for its own definition but relies on the APPS synonyms listed above, so callers must run in an environment where those synonyms resolve correctly.