Search Results insert_deployed_scripts




Overview
Explore in AI Chat

Overview

The APPS.IES_DEPLOYED_SCRIPTS_PVT package body is a private (PVT-classified) PL/SQL API belonging to the Oracle E-Business Suite Internet Expenses (IES) module. It provides the low-level data manipulation logic used to manage records in the deployed scripts repository — the metadata definitions that drive questionnaire-style data collection within the Expenses and iExpenses framework. A deployed script represents an active, versioned instance of a script definition bound to a language, a panel table, and a question table, and associated with an application and function so that it can be launched through a specific responsibility context.

The package encapsulates insert, update, and delete operations against the IES_DEPLOYED_SCRIPTS entity and its related child structures, centralising validation, sequence-based primary key assignment, and transactional control. As a private package, it is not intended for direct invocation by external callers; instead, it is designed to be called by public wrapper packages or by the forms and concurrent programs that own the deployment lifecycle of IES scripts.

Key Procedures and Functions

The package exposes three documented procedures, each following the standard Oracle EBS API parameter convention (including p_api_version, p_init_msg_list, p_commit, p_validation_level, and the standard x_return_status, x_msg_count, and x_msg_data output parameters).

  • INSERT_DEPLOYED_SCRIPTS — Creates a new row in the deployed scripts table. The procedure obtains a new primary key from the IES_DEPLOYED_SCRIPTS_S sequence and returns it to the caller through the x_dscript_id output parameter, which is the identifier targeted by the user search term "dscript_id". The procedure populates language, panel table, question table, name, active status, application, function, script type, and description attributes, while initialising the BLOB columns dscript_file and schema_mapping to empty BLOB values for later population.
  • UPDATE_DEPLOYED_SCRIPTS — Modifies an existing deployed script record, allowing attributes such as name, active status, description, and associated identifiers to be changed after deployment.
  • DELETE_DEPLOYED_SCRIPTS — Removes a deployed script record, supporting retirement or cleanup of obsolete script deployments.

Tables Accessed

The package references the following tables through APPS synonyms:

  • IES_DEPLOYED_SCRIPTS — The primary entity table holding deployed script header records, including the dscript_id primary key, BLOB content columns, and functional attributes.
  • IES_DEPLOYED_SCRIPTS_S — The sequence object supplying surrogate dscript_id values during inserts.
  • IES_PANELS, IES_PANEL_DATA, IES_QUESTIONS, IES_QUESTION_DATA, IES_ANSWERS — Supporting questionnaire structures that define the layout and responses associated with a deployed script.
  • IES_LOOKUPS — Reference lookup values used for validation of status and type codes.
  • IES_TRANSACTIONS — The transactional context in which deployed scripts are executed.

Usage Notes

This private package is typically invoked indirectly through IES public APIs, Oracle Forms-based setup screens, or concurrent programs that manage script deployment and maintenance. It maintains a savepoint at the start of each operation and rolls back on failure, setting x_return_status to 'E' with the SQLCODE and SQLERRM message. Because the ETRM metadata records zero referencing packages, direct custom integration should be avoided in favour of the supported public API layer.