Search Results convert_to_date

Overview

ICX_STORE_BATCH_UTILS is a utility package body in the APPS schema that supports the parsing and manipulation of delimited data streams used by Oracle E-Business Suite store and batch processing routines. Its primary business function is to decompose a long, separator-delimited character buffer into individual lines and fields, and to convert textual representations of dates into native DATE values. The package is closely associated with the Oracle iStore and iProcurement store/batch infrastructure, where inbound or stored content is frequently held in LONG columns and must be tokenized before it can be consumed by downstream PL/SQL logic. The header comment identifies the implementation revision as ICXSTBUB.pls 115.1, dated 1999, indicating that the package is a long-standing component of the ICX module family and remains present through EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

• GET_LINE — Retrieves one line from a LONG string by locating the configured line separator, returning the extracted line and truncating the source string so that subsequent calls advance through the remaining content. The extracted line is appended with the field separator to allow the final field to be parsed correctly by GET_FIELD.
• GET_FIELD — Extracts a single field from a delimited line by locating the field separator, returning that field and removing it from the working line so that successive fields can be retrieved.
• CONVERT_TO_DATE — Converts a character representation of a date into a DATE value. This is the specific routine referenced by the search term "convert_to_date" and is intended to normalize text date values encountered during batch parsing so they can be used in date arithmetic or stored in DATE columns.
• GET_PROMPTS_TABLE — Retrieves a set of prompts in table form, supporting the store/batch presentation layer where prompt information must be materialized for display or processing.
• GET_PROMPTS_INFO — Returns prompt-related information, complementing GET_PROMPTS_TABLE in the retrieval of storefront prompt metadata.
• REPLACE_CRLF — Normalizes carriage-return and line-feed characters within a string, ensuring that embedded newline sequences do not disrupt line and field tokenization.

Tables Accessed

The documented references include HTP and PLITBLM, both accessed through APPS synonyms. HTP is the Oracle Web Toolkit PL/SQL package used for generating HTML output; within this package it is invoked in the exception handlers, for example to emit an error message via htp.p when GET_LINE or GET_FIELD encounters an unexpected condition. PLITBLM is the standard PL/SQL interleaved table helper package commonly used to convert between delimited strings and PL/SQL index-by tables, supporting the GET_PROMPTS_TABLE and related prompt routines. No application data tables are documented as directly read or written by this package.

Usage Notes

ICX_STORE_BATCH_UTILS is typically invoked from PL/SQL batch processes, store content loaders, and custom code that must parse LONG or CLOB-style delimited payloads. The GET_LINE and GET_FIELD pair is designed for iterative consumption: callers repeatedly invoke GET_LINE to advance through a buffer, then GET_FIELD to walk the fields within each extracted line. REPLACE_CRLF is used beforehand to sanitize line endings, and CONVERT_TO_DATE is applied to any field that carries a textual date. The package is referenced by two other packages in the ETRM metadata, confirming its role as a shared utility. Because error handling routes messages through HTP, the package is most naturally invoked in environments where HTML output is acceptable, such as web-enabled concurrent or storefront processes.