PACKAGE: APPS.HZ_WORD_ARRAY_PKG

Source

1 PACKAGE HZ_WORD_ARRAY_PKG AS
2 /*$Header: ARHDQWAS.pls 120.0 2005/03/14 22:10:58 cvijayan noship $ */
3 
4 -- VJN created for implementing Associative arrays in DQM Word Replacements
5 TYPE word_rep_array IS
6       TABLE OF hz_word_replacements.original_word%TYPE
7       INDEX BY hz_word_replacements.replacement_word%TYPE ;
8 
9 TYPE word_list_array IS
10       TABLE OF word_rep_array
11       INDEX BY BINARY_INTEGER ;
12 
13 TYPE word_list_ndl_flag_array IS
14       TABLE OF VARCHAR2(1)
15       INDEX BY BINARY_INTEGER ;
16 
17 
18 -- word replacement array
19 word_rep_lookup word_rep_array ;
20 
21 -- word list array for global replacements
22 word_list_global_rep_lookup word_list_array ;
23 
24 -- word list array for non delimited flag lookup
25 word_list_ndl_flag_lookup word_list_ndl_flag_array ;
26 
27 
28 -- Procedure to populate all the above 3 arrays for a word list
29 PROCEDURE populate_word_arrays(wl_id NUMBER) ;
30 
31 -- Getter for a global replacement
32 FUNCTION get_global_repl_word(wl_id NUMBER, original_word VARCHAR2)
33 RETURN VARCHAR2 ;
34 
35 -- Existence check for a word list
36 FUNCTION word_list_exists(wl_id NUMBER)
37 RETURN BOOLEAN ;
38 
39 
40 END;