APPS.ICX_ADMIN_UTILS dependencies on ICX_ON_UTILITIES

Line 25: l_parameters icx_on_utilities.v240_table;

21: p_end_row in number default null,
22: p_where in varchar2 default null) is
23:
24: l_hidden varchar2(2000);
25: l_parameters icx_on_utilities.v240_table;
26: l_key_value_ids icx_on_utilities.number_table;
27: l_key_attributes icx_on_utilities.v30_table;
28: l_link_value_id number;
29: l_link_attribute varchar2(30);

Line 26: l_key_value_ids icx_on_utilities.number_table;

22: p_where in varchar2 default null) is
23:
24: l_hidden varchar2(2000);
25: l_parameters icx_on_utilities.v240_table;
26: l_key_value_ids icx_on_utilities.number_table;
27: l_key_attributes icx_on_utilities.v30_table;
28: l_link_value_id number;
29: l_link_attribute varchar2(30);
30: l_function_code varchar2(30);

Line 27: l_key_attributes icx_on_utilities.v30_table;

23:
24: l_hidden varchar2(2000);
25: l_parameters icx_on_utilities.v240_table;
26: l_key_value_ids icx_on_utilities.number_table;
27: l_key_attributes icx_on_utilities.v30_table;
28: l_link_value_id number;
29: l_link_attribute varchar2(30);
30: l_function_code varchar2(30);
31: l_region_application_id number;

Line 68: icx_on_utilities.unpack_parameters(l_hidden,l_parameters);

64:
65: begin
66:
67: l_hidden := icx_call.decrypt2(p_hidden);
68: icx_on_utilities.unpack_parameters(l_hidden,l_parameters);
69:
70: for i in l_parameters.count..21 loop
71: l_parameters(i) := '';
72: end loop;

Line 113: l_where_clause := icx_on_utilities.whereSegment(a_1,c_1,i_1,a_2,c_2,i_2,a_3,c_3,i_3,a_4,c_4,i_4,a_5,c_5,i_5);

109: if p_where is not null
110: then
111: l_where_clause := icx_call.decrypt2(p_where);
112: else
113: l_where_clause := icx_on_utilities.whereSegment(a_1,c_1,i_1,a_2,c_2,i_2,a_3,c_3,i_3,a_4,c_4,i_4,a_5,c_5,i_5);
114: end if;
115:
116: l_encrypted_where := icx_call.encrypt2(l_where_clause);
117:

Line 143: -- icx_on_utilities2.printPLSQLtables;

139: p_range_low => p_start_row,
140: p_range_high => l_end_row);
141:
142:
143: -- icx_on_utilities2.printPLSQLtables;
144:
145: /* get number of total rows returned by lov to be used to determine if
146: we need to display the next/previous buttons */
147:

Line 252: icx_on_utilities2.displaySetIcons(l_language_code,l_list_proc,p_start_row,l_end_row,l_encrypted_where,l_query_size,l_total_rows,TRUE,'',p_hidden);

248: htp.tableRowClose;
249: htp.tableClose;
250: htp.br;
251:
252: icx_on_utilities2.displaySetIcons(l_language_code,l_list_proc,p_start_row,l_end_row,l_encrypted_where,l_query_size,l_total_rows,TRUE,'',p_hidden);
253:
254: l_count := 0;
255: while l_key_attributes(l_count+1) is not null loop
256: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop

Line 326: icx_on_utilities2.displaySetIcons(l_language_code,l_list_proc,p_start_row,l_end_row,l_encrypted_where,l_query_size,l_total_rows,TRUE,'',p_hidden);

322: end loop; -- Results
323:
324: htp.tableClose;
325:
326: icx_on_utilities2.displaySetIcons(l_language_code,l_list_proc,p_start_row,l_end_row,l_encrypted_where,l_query_size,l_total_rows,TRUE,'',p_hidden);
327:
328: htp.formClose;
329: icx_admin_sig.footer;
330: