PACKAGE: APPS.ICX_STORE_BATCH_UTILS

Source

1 PACKAGE icx_store_batch_utils AUTHID CURRENT_USER AS
2 /* $Header: ICXSTBUS.pls 115.2 99/07/17 03:26:07 porting ship $ */
3 
4 -- Define  tab character
5 -- LSH removed CHR: C_TAB  CONSTANT VARCHAR2(10) := CHR(9);
6 C_TAB  CONSTANT VARCHAR2(10) := '	';
7 -- Define carriage return and line feed
8 -- LSH removed CHR: C_CR_LF  CONSTANT VARCHAR2(10) := CHR(13) || CHR(10);
9 C_CR_LF  CONSTANT VARCHAR2(10) := '
10 ';
11 
12 -- Define the field separator for the spread sheet
13 g_field_sep  VARCHAR2(10) := C_TAB;
14 g_line_sep  VARCHAR2(10) := C_CR_LF;
15 
16 TYPE PROMPT_REC IS RECORD (
17   attribute_label      VARCHAR2(80) := NULL,
18   attribute_code       VARCHAR2(32) := NULL,
19   display_value_length NUMBER(15)   := NULL
20 );
21 
22 TYPE ITEM_PROMPTS_TABLE IS TABLE OF PROMPT_REC
23   INDEX BY BINARY_INTEGER;
24 
25 PROCEDURE get_prompts_table  (p_region_code IN VARCHAR2,
26                               p_prompts_table OUT item_prompts_table);
27 
28 PROCEDURE get_line  (p_text IN OUT LONG,
29                      p_line IN OUT LONG);
30 
31 PROCEDURE get_field  (p_line IN OUT LONG,
32                       p_field OUT LONG);
33 
34 PROCEDURE convert_to_date  (p_field IN VARCHAR2,
35                             p_date_format IN VARCHAR2,
36                             p_date OUT DATE,
37                             p_error_flag OUT VARCHAR2);
38 
39 PROCEDURE get_prompts_info  (p_prompts_table IN item_prompts_table,
40                              p_attribute_code IN VARCHAR2,
41                              p_attribute_info_record OUT prompt_rec);
42 
43 FUNCTION replace_crlf (p_string IN VARCHAR2)
44  RETURN VARCHAR2;
45 
46 END icx_store_batch_utils;