Search Results copy_to_list
Overview
ICX_JAVASCRIPT is an Oracle Application Object Library-style PL/SQL package owned by APPS and classified as OTHER in the ETRM metadata for release 12.2.2. Its sole purpose is the server-side generation of JavaScript source code that is emitted into Oracle E-Business Suite HTML pages, primarily within the Internet Computing eXtensions (ICX) framework used by self-service web applications. Rather than storing static script files, the package renders script fragments on demand so that each page carries only the JavaScript needed for the controls it actually contains. The package is declared AUTHID CURRENT_USER, meaning that runtime name resolution and privilege checks occur in the context of the invoking user rather than the definer, which is consistent with its role as a utility called from other ICX code rather than a secure business API. The header comment (ICXJSS.pls 120.1, dated 2005) indicates a long-lived, stable utility that predates the 12.x upgrade cycles and has been carried forward largely unchanged into 12.1.1 and 12.2.2.
The package addresses two broad concerns: managing the client-side behavior of multi-row list regions (selection, reordering, copying and clearing of list elements) and producing the JavaScript calls that open Oracle EBS help in pop-up browser windows.
Key Procedures and Functions
The documented interface contains 21 procedures. They fall into four functional groups.
- Script framing: OPEN_SCRIPT and CLOSE_SCRIPT emit the opening and closing <script> tags respectively, with OPEN_SCRIPT accepting a version default of 1.1. OPEN_NOSCRIPT and CLOSE_NOSCRIPT emit the corresponding <noscript> markers for browsers with scripting disabled.
- List manipulation: COPY_TO_LIST, COPY_ALL, APPEND_TO_LIST, DELETE_FROM_LIST, DELETE_LIST_ELEMENT, MOVE_LIST_ELEMENT, CLEAR_LIST, SELECT_ALL and UNSELECT_ALL generate the client routines that add, remove, move or select rows within a list-style region.
- Row ordering and cleanup: SWAP, MOVE_ELEMENT_UP, MOVE_ELEMENT_DOWN, MOVE_ELEMENT_TOP, MOVE_ELEMENT_BOTTOM and DELETE_BLANK_ROW provide the JavaScript used by up/down/top/bottom controls and by logic that removes empty rows from a multi-row block.
- Help integration: SHOW_MAIN_HELP renders the JavaScript function that invokes the main help system, and SHOW_CONTEXT_SENS_HELP renders the function that invokes context-sensitive help; both display results in a new pop-up browser window.
Tables Accessed
The ETRM metadata records a single referenced object, HTP, resolved through an APPS synonym. HTP is the Oracle PL/SQL Web Toolkit Hypertext Procedure package, not a database table. ICX_JAVASCRIPT uses HTP primitives such as HTP.PRINT to write script text into the page buffer during server-side page assembly. The package therefore performs no direct DML against application tables; its "data" is the generated script text streamed to the browser.
Usage Notes
ICX_JAVASCRIPT is a rendering helper rather than a transactional API, and it is not intended for direct invocation from concurrent programs. It is typically called from other PL/SQL packages and JSP/HTML generation code that build ICX self-service pages, so that the JavaScript supporting list regions and help links is produced consistently across applications. The ETRM metadata notes that it is referenced by one other package, confirming this dependent-library relationship. Customizations should treat it as internal Oracle infrastructure: callers may rely on the documented procedure names, but the emitted JavaScript itself is subject to change across releases and should not be parsed or extended. Because of the AUTHID CURRENT_USER declaration, any custom code that calls these procedures must be granted execution rights explicitly and must have the necessary HTP privileges available to the invoking schema.