Search Results icx_store_batch_utils




Overview
Explore in AI Chat

Overview

ICX_STORE_BATCH_UTILS is a PL/SQL utility package owned by the APPS schema in Oracle E-Business Suite. It belongs to the ICX (Oracle iProcurement / Internet Commerce Exchange) product family and is classified as an "OTHER" API, meaning it is not a published, customer-facing extension interface but rather an internal support package used by other ICX components. Its name indicates its role: it services the batch processing of stored catalog content, providing helper routines that format, parse, and display data records during the loading and rendering of store content.

The package bridges low-level data records and the presentation layer. It supplies date conversion, string manipulation, and prompt/field extraction services that the store-loading batch logic requires. Because it is a helper rather than a business API, its procedures are invoked internally by sibling packages and are not intended as standalone entry points. It depends on SYS.STANDARD only, and on the HTP (PL/SQL Web Toolkit) and PLITBLM synonym tables, confirming its formatting and rendering responsibilities.

Key Procedures and Functions

  • GET_PROMPTS_TABLE — Returns the collection (table) of prompts associated with a store batch operation, allowing callers to iterate over the full set of field prompts in a single call.
  • GET_PROMPTS_INFO — Retrieves descriptive metadata for the prompts, such as labels and related attributes, used to drive field display during catalog rendering.
  • GET_LINE — Extracts a single line or record from batch input, forming the core step in processing multi-line stored content.
  • GET_FIELD — Extracts an individual field from a parsed record, enabling positional processing of delimited or fixed-format batch data.
  • CONVERT_TO_DATE — Normalizes a string value into a valid date, essential when catalog or store batch files contain date columns requiring consistent internal handling.
  • REPLACE_CRLF — Removes or replaces carriage-return and line-feed characters, cleaning embedded text so that it renders correctly in HTML output generated through HTP.

Tables Accessed

Per the documented dependency list, the package references HTP and PLITBLM through APPS synonyms. HTP is the PL/SQL Web Toolkit output package used to emit HTML; its presence confirms that some routines produce formatted web output for store display. PLITBLM is the Oracle-supplied PL/SQL table of line-feed and whitespace definitions, leveraged by REPLACE_CRLF and line-parsing logic to detect and strip line terminators. No application data tables are listed among the documented dependencies, indicating that ICX_STORE_BATCH_UTILS operates principally on in-memory structures and interface data rather than persisting directly to catalog tables.

Usage Notes

ICX_STORE_BATCH_UTILS is referenced by two other packages, ICX_CATG and ICX_ITEM, together with a self-reference. This dependency pattern shows that it is called during catalog and item processing operations within the ICX/iProcurement store-loading flow. In practice, these utilities are invoked from the batch programs that stage and publish store content, where records must be split into lines and fields, dates standardized, and embedded newline characters cleaned before the content is emitted as HTML.

Because the package carries an "OTHER" classification, it should not be called directly from custom forms, concurrent programs, or extension code. Oracle does not guarantee its signature across releases. Customizations requiring similar parsing or formatting behavior should implement equivalent logic independently rather than depending on this internal helper. Where the package is used, it is expected to run under the standard APPS execution context established by its calling ICX packages.