1 package icx_on_utilities AUTHID CURRENT_USER as
2 /* $Header: ICXONUS.pls 120.0 2005/10/07 12:16:42 gjimenez noship $ */
3
4 type v4000_table is table of varchar2(4000)
5 index by binary_integer;
6
7 type v2000_table is table of varchar2(2000)
8 index by binary_integer;
9
10 type v240_table is table of varchar2(240)
11 index by binary_integer;
12
13 type v80_table is table of varchar2(80)
14 index by binary_integer;
15
16 type v50_table is table of varchar2(50)
17 index by binary_integer;
18
19 type v30_table is table of varchar2(30)
20 index by binary_integer;
21
22 type v1_table is table of varchar2(30)
23 index by binary_integer;
24
25 type number_table is table of number
26 index by binary_integer;
27
28 type rowid_table is table of rowid
29 index by binary_integer;
30
31 procedure findPage(p_flow_appl_id in number default null,
32 p_flow_code in varchar2 default null,
33 p_page_appl_id in number default null,
34 p_page_code in varchar2 default null,
35 p_region_appl_id in number default null,
36 p_region_code in varchar2 default null,
37 p_goto_url in varchar2 default null,
38 p_lines_now in number default null,
39 p_lines_url in varchar2 default null,
40 p_lines_next in number default null,
41 p_hidden_name in varchar2 default null,
42 p_hidden_value in varchar2 default null,
43 p_help_url in varchar2 default null,
44 p_new_url in varchar2 default null);
45
46 procedure findForm(p_region_appl_id in number,
47 p_region_code in varchar2,
48 p_goto_url in varchar2 default null,
49 p_goto_target in varchar2 default null,
50 p_lines_now in number default 1,
51 p_lines_url in varchar2 default null,
52 p_lines_target in varchar2 default null,
53 p_lines_next in number default 5,
54 p_hidden_name in varchar2 default null,
55 p_hidden_value in varchar2 default null,
56 p_help_url in varchar2 default null,
57 p_new_url in varchar2 default null,
58 p_LOV_mode in varchar2 default 'N',
59 p_default_title in varchar2 default 'Y',
60 p_flow_appl_id in number default null,
61 p_flow_code in varchar2 default null,
62 p_page_appl_id in number default null,
63 p_page_code in varchar2 default null,
64 p_clear_button in varchar2 default 'Y',
65 p_advanced_button in varchar2 default 'Y');
66
67 procedure getRegions(p_where in varchar2 default null);
68
69 procedure displayPage;
70
71 function formatText(c_text in varchar2,
72 c_bold in varchar2,
73 c_italic in varchar2) return varchar2;
74
75 function formatData(c_text in varchar2,
76 c_halign in varchar2,
77 c_valign in varchar2) return varchar2;
78
79 function whereSegment(a_1 in varchar2 default null,
80 c_1 in varchar2 default null,
81 i_1 in varchar2 default null,
82 a_2 in varchar2 default null,
83 c_2 in varchar2 default null,
84 i_2 in varchar2 default null,
85 a_3 in varchar2 default null,
86 c_3 in varchar2 default null,
87 i_3 in varchar2 default null,
88 a_4 in varchar2 default null,
89 c_4 in varchar2 default null,
90 i_4 in varchar2 default null,
91 a_5 in varchar2 default null,
92 c_5 in varchar2 default null,
93 i_5 in varchar2 default null,
94 m in varchar2 default null,
95 o in varchar2 default 'AND')
96 return varchar2;
97
98 function whereSegment(c_attributes in v80_table,
99 c_conditions in v80_table,
100 c_inputs in v80_table,
101 p_match in varchar2,
102 p_and_or in varchar2)
103 return varchar2;
104
105 procedure unpack_whereSegment(p_whereSegment in varchar2,
106 p_where_clause out NOCOPY varchar2,
107 p_query_binds out NOCOPY ak_query_pkg.bind_tab);
108
109 --added by mputman for 1576202
110 procedure unpack_whereSegment(p_whereSegment in varchar2,
111 p_query_binds IN out NOCOPY ak_query_pkg.bind_tab,
112 p_query_binds_index IN NUMBER);
113
114 procedure unpack_parameters(Y in varchar2,
115 c_parameters out NOCOPY v80_table);
116
117 procedure unpack_parameters(Y in varchar2,
118 c_parameters out NOCOPY v240_table);
119
120 procedure unpack_parameters(Y in varchar2,
121 c_parameters out NOCOPY v2000_table);
122
123 procedure checkDate(p_date in varchar2);
124
125 function buildOracleONstring(p_rowid in varchar2,
126 p_primary_key in varchar2,
127 p1 in varchar2 default null,
128 p2 in varchar2 default null,
129 p3 in varchar2 default null,
130 p4 in varchar2 default null,
131 p5 in varchar2 default null,
132 p6 in varchar2 default null,
133 p7 in varchar2 default null,
134 p8 in varchar2 default null,
135 p9 in varchar2 default null,
136 p10 in varchar2 default null)
137 return varchar2;
138
139 function buildOracleONstring2(p_flow_application_id in varchar2,
140 p_flow_code in varchar2,
141 p_page_application_id in varchar2,
142 p_page_code in varchar2,
143 p_where_segment in varchar2 default null)
144 return varchar2;
145
146 procedure printRegions(p_rowid in varchar2,
147 p_primary_key in varchar2,
148 p1 in varchar2 default null,
149 p2 in varchar2 default null,
150 p3 in varchar2 default null,
151 p4 in varchar2 default null,
152 p5 in varchar2 default null,
153 p6 in varchar2 default null,
154 p7 in varchar2 default null,
155 p8 in varchar2 default null,
156 p9 in varchar2 default null,
157 p10 in varchar2 default null);
158
159 procedure printRegions2(p_flow_application_id in varchar2,
160 p_flow_code in varchar2,
161 p_page_application_id in varchar2,
162 p_page_code in varchar2,
163 p_where_segment in varchar2 default null);
164
165
166 g_on_parameters v240_table;
167 /* g_on_parameters definition
168 1 type -- Defines query type
169 'DQ' - Query based on Find Form
170 'W' - Direct query
171 'D' or else - Unique Key query
172 2 flow_appl_id
173 3 flow_code
174 4 page_appl_id
175 5 page_code
176 6 start_row -- Starting row of query set
177 7 end_row -- Ending row of query set
178 8 start_region -- Region that start applies to in multi region page
179 9 encrypted_where
180 10 rowid -- rowid of AK_FLOW_REGION_RELATIONS
181 11 unique_key_name -- Unique key to be used in ak_query_pkg
182 12-21 keys(1-10) -- Key values for unique_key_name
183 22 display page headers and footers Y/N
184 */
185
186 c_ampersand constant varchar2(1) := '&';
187 c_percent constant varchar2(1) := '%';
188
189 end icx_on_utilities;