1 package icx_util AUTHID CURRENT_USER as
2 /* $Header: ICXUTILS.pls 120.0 2005/10/07 12:21:16 gjimenez noship $ */
3
4 -- Declaration of a table of varchar2(240) that is returned by the
5 -- transfer_Row_To_Column utility
6 type char240_table is table of varchar2(240) index by binary_integer;
7
8 type char4000_table is table of varchar2(4000) index by binary_integer;
9
10 type g_prompts_table is table of varchar2(80)
11 index by binary_integer;
12
13 type g_lookup_code_table is table of varchar2(30)
14 index by binary_integer;
15
16 type g_lookup_meaning_table is table of varchar2(80)
17 index by binary_integer;
18
19 type attributes_table is table of varchar2(30)
20 index by binary_integer;
21
22 procedure LOVScript;
23
24 function LOVButton (c_attribute_app_id in number,
25 c_attribute_code in varchar2,
26 c_region_app_id in number,
27 c_region_code in varchar2,
28 c_form_name in varchar2,
29 c_frame_name in varchar2 default null,
30 c_where_clause in varchar2 default null,
31 c_image_align in varchar2 default 'CENTER')
32 return varchar2;
33
34
35 procedure LOV (c_attribute_app_id in number,
36 c_attribute_code in varchar2,
37 c_region_app_id in number,
38 c_region_code in varchar2,
39 c_form_name in varchar2,
40 c_frame_name in varchar2 default null,
41 c_where_clause in varchar2 default null,
42 c_js_where_clause in varchar2 default null);
43
44
45 procedure LOVHeader (c_attribute_code in varchar2,
46 p_LOV_foreign_key_name in varchar2,
47 p_LOV_region_id in number,
48 p_LOV_region in varchar2,
49 c_form_name in varchar2,
50 c_frame_name in varchar2 default null,
51 c_lines in number default 1,
52 x in number default 1,
53 a_1 in varchar2 default null,
54 c_1 in varchar2 default 'DSTART',
55 i_1 in varchar2 default null,
56 a_2 in varchar2 default null,
57 c_2 in varchar2 default null,
58 i_2 in varchar2 default null,
59 a_3 in varchar2 default null,
60 c_3 in varchar2 default null,
61 i_3 in varchar2 default null,
62 a_4 in varchar2 default null,
63 c_4 in varchar2 default null,
64 i_4 in varchar2 default null,
65 a_5 in varchar2 default null,
66 c_5 in varchar2 default null,
67 i_5 in varchar2 default null);
68
69 procedure LOVValues (p_LOV_foreign_key_name in varchar2,
70 p_LOV_region_id in number,
71 p_LOV_region in varchar2,
72 p_attribute_app_id in number,
73 p_attribute_code in varchar2,
74 p_region_app_id in number,
75 p_region_code in varchar2,
76 c_form_name in varchar2,
77 c_frame_name in varchar2 default null,
78 c_where_clause in varchar2 default null,
79 x in number default 0,
80 start_row in number default 1,
81 p_end_row in number default null,
82 a_1 in varchar2 default null,
83 c_1 in varchar2 default 'DSTART',
84 i_1 in varchar2 default null,
85 a_2 in varchar2 default null,
86 c_2 in varchar2 default null,
87 i_2 in varchar2 default null,
88 a_3 in varchar2 default null,
89 c_3 in varchar2 default null,
90 i_3 in varchar2 default null,
91 a_4 in varchar2 default null,
92 c_4 in varchar2 default null,
93 i_4 in varchar2 default null,
94 a_5 in varchar2 default null,
95 c_5 in varchar2 default null,
96 i_5 in varchar2 default null,
97 case_sensitive in varchar2 default null);
98
99 procedure copyright;
100
101 procedure getPrompts( p_region_application_id in number,
102 p_region_code in varchar2,
103 p_title out NOCOPY varchar2,
104 p_prompts out NOCOPY g_prompts_table);
105
106 function getPrompt( p_region_application_id in number,
107 p_region_code in varchar2,
108 p_attribute_application_id in number,
109 p_attribute_code in varchar2)
110 return varchar2;
111
112 procedure getLookups( p_lookup_type in varchar2,
113 p_lookup_codes out NOCOPY g_lookup_code_table,
114 p_lookup_meanings out NOCOPY g_lookup_meaning_table);
115
116 procedure getLookup( p_lookup_type in varchar2,
117 p_lookup_code in varchar2,
118 p_meaning out NOCOPY varchar2);
119
120 procedure error_page_setup;
121
122 procedure add_error(V_ERROR_IN varchar2);
123
124 function error_count
125 return number;
126
127 procedure error_page_print;
128
129 procedure no_html_error_page_print;
130
131 function get_color(v_name in varchar2)
132 return varchar2;
133
134
135 procedure parse_string (
136 in_str in varchar2,
137 delimiter in varchar2,
138 str_part1 out NOCOPY varchar2,
139 str_part2 out NOCOPY varchar2);
140
141 function item_flex_seg (
142 ri in rowid)
143 return varchar2;
144
145 pragma restrict_references (item_flex_seg,WNDS,RNPS,WNPS);
146
147 function category_flex_seg (
148 cat_id in number)
149 return varchar2;
150
151 pragma restrict_references (category_flex_seg,WNDS,RNPS,WNPS);
152
153 -- The transfer_Row_To_Column utility takes one record returned by an
154 -- Object Navigator query and changes the record into a pl/sql table
155 procedure transfer_Row_To_Column(result_record in ak_query_pkg.result_rec,
156 result_table out NOCOPY icx_util.char240_table);
157
158 procedure transfer_Row_To_Column(result_record in ak_query_pkg.result_rec,
159 result_table out NOCOPY icx_util.char4000_table);
160
161 PROCEDURE DynamicButton(P_ButtonText varchar2,
162 P_ImageFileName varchar2,
163 P_OnMouseOverText varchar2,
164 P_HyperTextCall varchar2,
165 P_LanguageCode varchar2,
166 P_JavaScriptFlag boolean,
167 P_DisabledFlag boolean default FALSE);
168
169 PROCEDURE paintDynamicButton(P_ButtonText varchar2,
170 P_ImageFileName varchar2,
171 P_OnMouseOverText varchar2,
172 P_HyperTextCall varchar2,
173 P_LanguageCode varchar2,
174 P_DisabledFlag boolean default FALSE);
175
176 PROCEDURE DynamicButtonIn(P_ButtonText varchar2,
177 P_ImageFileName varchar2,
178 P_OnMouseOverText varchar2,
179 P_HyperTextCall varchar2,
180 P_LanguageCode varchar2,
181 P_JavaScriptFlag boolean,
182 P_DisabledFlag boolean default FALSE);
183
184 -- The replace_quotes function takes a string as an in parameter, and
185 -- returns a string with all single and double quotes preceeded with a \.
186 -- This function is designed to escape out all quotes in a phrase that is
187 -- used with javascript. The \ character is the escape character for
188 -- javascript. If a string with quotes already preceeded by the \ escape
189 -- character is passed to the replace_quotes function, the return string
190 -- will only have one \ infront of each quote.
191 function replace_quotes(p_string in varchar2) return varchar2;
192
193 function replace_jsdw_quotes(p_string in varchar2) return varchar2;
194
195 function replace_onMouseOver_quotes(p_string in varchar2) return varchar2;
196
197 -- The replace_alt_quotes function takes a string as an in parameter, and
198 -- returns a string with all single and double quotes preceeded with a \.
199 -- This function is designed to escape out all quotes in a phrase that is
200 -- used for alt text for html images. The \ character is the escape character
201 -- for javascript. If a string with quotes already preceeded by the \ escape
202 -- character is passed to the replace_quotes function, the return string
203 -- will only have one \ infront of each quote.
204 function replace_alt_quotes(p_string in varchar2) return varchar2;
205
206
207 end icx_util;