Search Results icx_questions_admin




Overview
Explore in AI Chat

Overview

APPS.ICX_QUESTIONS_ADMIN is an administrative PL/SQL package in the Oracle E-Business Suite iStore/eCommerce (ICX) schema. It provides the server-side logic for maintaining the question-and-answer infrastructure used by Oracle iStore and related self-service applications. Questions are application-scoped prompts presented to end users, and each question may be associated with one or more EBS functions. The package encapsulates the full maintenance lifecycle — searching, displaying, creating, updating, and deleting both questions and their function associations — and renders its user interface dynamically through the Oracle Web Toolkit (HTP/HTF) rather than through Oracle Forms. The package is declared AUTHID CURRENT_USER, so it executes with the privileges of the invoking session and relies on APPS synonyms to reach the underlying ICX tables.

Key Procedures and Functions

The documented interface comprises fourteen procedures grouped into question maintenance and function-association maintenance.

  • FIND_QUESTIONS — Presents the search entry screen used to locate questions by a variety of context criteria.
  • DISPLAY_QUESTIONS — Renders the list of existing questions matching the supplied query criteria (application short name, question code, question text).
  • EDIT_QUESTION — Opens an existing question for modification of its code or content, and supports insert-mode processing of the question record.
  • INSERT_QUESTION — Creates a new question record from the supplied application, question code, question text, and find criteria.
  • UPDATE_QUESTION — Persists changes to an existing question.
  • QUESTION_CONFIRM_DELETE — Displays the confirmation prompt before a question is removed.
  • DELETE_QUESTION — Deletes the selected question.
  • DISPLAY_FUNCTIONS — Lists the EBS functions currently associated with a question.
  • APPLICATION_LOV — Renders the list of values for selecting an application.
  • EDIT_FUNCTION — Edits the function association for a question.
  • FUNCTION_LOV — Renders the list of values for selecting an EBS function.
  • INSERT_FUNCTION — Creates a new question-to-function association.
  • UPDATE_FUNCTION — Modifies an existing question-to-function association.
  • DELETE_FUNCTION — Removes a question-to-function association.

Tables Accessed

The package reads and writes three ICX base tables through APPS synonyms. ICX_QUESTIONS stores the question definitions themselves, keyed by application and question code. ICX_QUESTIONS_TL holds the translatable (language-dependent) question text, which is why the insert and update paths must maintain both the base and translated rows. ICX_QUESTION_FUNCTIONS is the intersection table linking questions to EBS functions, and it is the target of INSERT_FUNCTION, UPDATE_FUNCTION, and DELETE_FUNCTION. Output is generated with the HTF and HTP packages, which emit HTML tags and page content, while OWA_UTIL supplies standard web utility routines such as URL handling and HTML escaping.

Usage Notes

The package is an internal administrative component rather than a public API; the source header dates it to 1999, and it is not referenced by any other documented package. It is normally invoked from the administrative pages of Oracle iStore/ICX, where the procedural page flow (find, display, edit, confirm, delete) drives the browser interface. Because every procedure is HTML-emitting, it is not intended for direct call from concurrent programs or batch jobs. Custom code should not call these procedures for data manipulation; instead, direct DML against ICX_QUESTIONS, ICX_QUESTIONS_TL, and ICX_QUESTION_FUNCTIONS — or Oracle-supported APIs — is the appropriate integration path. Note that the procedures accept VARCHAR2 parameters for application identifiers, so callers must perform any required numeric conversion themselves.