APPS.ICX_AK_JAVA_QUERY dependencies on ICX_UTIL

Line 12: l_result_row icx_util.char240_table;

8: p_where_clause in varchar2,
9: p_order_clause in varchar2,
10: p_time in varchar2) is
11:
12: l_result_row icx_util.char240_table;
13:
14: begin
15: if icx_sec.validateSession then
16:

Line 42: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(result-1),l_result_row);

38: end loop;
39:
40:
41: for result in 1 .. ak_query_pkg.g_results_table.count loop
42: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(result-1),l_result_row);
43:
44: for l_item_num in 1..ak_query_pkg.g_items_table.count loop
45: if ak_query_pkg.g_items_table(l_item_num-1).object_attribute_flag = 'Y' then
46: htp.p(l_result_row(l_item_num));

Line 80: p_result_row out icx_util.char240_table) is

76:
77:
78:
79: procedure get_result_row(p_row_num in number,
80: p_result_row out icx_util.char240_table) is
81:
82: l_item_num number;
83: l_result_row icx_util.char240_table;
84:

Line 83: l_result_row icx_util.char240_table;

79: procedure get_result_row(p_row_num in number,
80: p_result_row out icx_util.char240_table) is
81:
82: l_item_num number;
83: l_result_row icx_util.char240_table;
84:
85: begin
86:
87: -- transfer one row of the l_results_table into a seperate pl/sql table

Line 92: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(p_row_num),l_result_row);

88: -- that will enable the specific transfer of only those elements of the
89: -- row that are populated (eliminating the need for a 100 member array
90: -- to be allocated in java)
91:
92: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(p_row_num),l_result_row);
93:
94: for l_item_num in 1..ak_query_pkg.g_items_table.count loop
95: if ak_query_pkg.g_items_table(l_item_num - 1).object_attribute_flag = 'Y' then
96: p_result_row(l_item_num) := l_result_row(ak_query_pkg.g_items_table(l_item_num - 1).value_id);