Search Results update_question

Overview

APPS.IES_QUESTIONS_PVT is a private (PVT) PL/SQL package body within the Oracle E-Business Suite Internet Expenses (IES) module, which is the component of Oracle EBS responsible for the Web Expenses entry and approval workflow. The package belongs to the question-management layer of IES, specifically the sub-system that governs the presentation, storage, and lifecycle of questions attached to expense entry panels and nodes. In the context of Oracle EBS 12.1.1 and 12.2.2, this package encapsulates the server-side logic used to create and maintain question definitions that are subsequently rendered on the expenses user interface, such as questionnaire-style fields, policy-driven prompts, and configurable data-capture elements.

The header comment indicates an original source control version (115.15) generated by script iesvieqb.pls, confirming the package is an original IES component rather than a later extension. As a PVT package, it is intended to be called only by other IES packages and not directly by external or customer-facing code, although Oracle EBS does not technically enforce private visibility.

Key Procedures and Functions

The ETRM metadata for this object documents six procedures or functions, of which the excerpt explicitly names two: INSERT_QUESTION and UPDATE_QUESTION.

• INSERT_QUESTION — Creates a new question record. The excerpt reveals that this procedure is heavily overloaded. At least three overloads exist, distinguished by parameter combinations. The most minimal overload accepts parameters for API versioning, initialization of message handling, commit control, validation level, standard output parameters (return status, message count, message data), creator identity, panel identifier, lookup identifier, node name, node UID, active status, and an output question identifier. A second overload adds a question type identifier and a question label. A third overload appears to introduce a null-shadowing parameter, suggesting internal delegation to a common implementation. This overload pattern allows callers to supply only the attributes relevant to their integration point while the package fills defaults and forwards to a master insert routine.
• UPDATE_QUESTION — Modifies an existing question record. Although the parameter list is not shown in the excerpt, its counterpart role to INSERT_QUESTION implies it accepts the question identifier plus mutable attributes such as label, lookup, node assignment, and active status, and applies the standard API validation and message-handling conventions.

The consistent use of an API version parameter, initialization flag, commit flag, validation level, and standard x_return_status, x_msg_count, and x_msg_data output parameters conforms to the Oracle Application Object Library (AOL) API programming standard.

Tables Accessed

The provided ETRM metadata does not list the specific tables referenced through APPS synonyms. Based on the package's function and IES schema conventions, the underlying tables are those of the IES question framework, generally named with the IES_ prefix and storing question definitions, panel-to-question associations, node and lookup references, and active-status flags. The package reads and writes these tables to persist question metadata rather than to retrieve transactional expense data.

Usage Notes

IES_QUESTIONS_PVT is invoked internally by IES application logic, typically during administrative configuration of expense questions and when forms or web pages create or edit question definitions. The metadata records zero inbound package dependencies, meaning no other PL/SQL package is documented as referencing it; callers are therefore expected to be forms, OAF pages, or other IES runtime components rather than inter-package dependencies. Because it is a private package, customizations should prefer the corresponding public API or the supported configuration UI rather than invoking INSERT_QUESTION or UPDATE_QUESTION directly.