13:
14: begin
15: if icx_sec.validateSession then
16:
17: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => p_region_app_id,
18: P_PARENT_REGION_CODE => p_region_code,
19: P_WHERE_CLAUSE => p_where_clause,
20: P_ORDER_BY_CLAUSE => p_order_clause,
21: P_RETURN_PARENTS => 'T',
21: P_RETURN_PARENTS => 'T',
22: P_RETURN_CHILDREN => 'F');
23:
24:
25: htp.p(ak_query_pkg.g_items_table.count);
26: htp.p(ak_query_pkg.g_results_table.count);
27:
28: for item in 1..ak_query_pkg.g_items_table.count loop
29: if ak_query_pkg.g_items_table(item-1).object_attribute_flag = 'Y' then
22: P_RETURN_CHILDREN => 'F');
23:
24:
25: htp.p(ak_query_pkg.g_items_table.count);
26: htp.p(ak_query_pkg.g_results_table.count);
27:
28: for item in 1..ak_query_pkg.g_items_table.count loop
29: if ak_query_pkg.g_items_table(item-1).object_attribute_flag = 'Y' then
30: htp.p(ak_query_pkg.g_items_table(item-1).attribute_code);
24:
25: htp.p(ak_query_pkg.g_items_table.count);
26: htp.p(ak_query_pkg.g_results_table.count);
27:
28: for item in 1..ak_query_pkg.g_items_table.count loop
29: if ak_query_pkg.g_items_table(item-1).object_attribute_flag = 'Y' then
30: htp.p(ak_query_pkg.g_items_table(item-1).attribute_code);
31: htp.p(ak_query_pkg.g_items_table(item-1).value_id);
32: htp.p(ak_query_pkg.g_items_table(item-1).attribute_label_long);
25: htp.p(ak_query_pkg.g_items_table.count);
26: htp.p(ak_query_pkg.g_results_table.count);
27:
28: for item in 1..ak_query_pkg.g_items_table.count loop
29: if ak_query_pkg.g_items_table(item-1).object_attribute_flag = 'Y' then
30: htp.p(ak_query_pkg.g_items_table(item-1).attribute_code);
31: htp.p(ak_query_pkg.g_items_table(item-1).value_id);
32: htp.p(ak_query_pkg.g_items_table(item-1).attribute_label_long);
33: htp.p(ak_query_pkg.g_items_table(item-1).display_sequence);
26: htp.p(ak_query_pkg.g_results_table.count);
27:
28: for item in 1..ak_query_pkg.g_items_table.count loop
29: if ak_query_pkg.g_items_table(item-1).object_attribute_flag = 'Y' then
30: htp.p(ak_query_pkg.g_items_table(item-1).attribute_code);
31: htp.p(ak_query_pkg.g_items_table(item-1).value_id);
32: htp.p(ak_query_pkg.g_items_table(item-1).attribute_label_long);
33: htp.p(ak_query_pkg.g_items_table(item-1).display_sequence);
34: htp.p(ak_query_pkg.g_items_table(item-1).object_attribute_flag);
27:
28: for item in 1..ak_query_pkg.g_items_table.count loop
29: if ak_query_pkg.g_items_table(item-1).object_attribute_flag = 'Y' then
30: htp.p(ak_query_pkg.g_items_table(item-1).attribute_code);
31: htp.p(ak_query_pkg.g_items_table(item-1).value_id);
32: htp.p(ak_query_pkg.g_items_table(item-1).attribute_label_long);
33: htp.p(ak_query_pkg.g_items_table(item-1).display_sequence);
34: htp.p(ak_query_pkg.g_items_table(item-1).object_attribute_flag);
35: htp.p(ak_query_pkg.g_items_table(item-1).node_display_flag);
28: for item in 1..ak_query_pkg.g_items_table.count loop
29: if ak_query_pkg.g_items_table(item-1).object_attribute_flag = 'Y' then
30: htp.p(ak_query_pkg.g_items_table(item-1).attribute_code);
31: htp.p(ak_query_pkg.g_items_table(item-1).value_id);
32: htp.p(ak_query_pkg.g_items_table(item-1).attribute_label_long);
33: htp.p(ak_query_pkg.g_items_table(item-1).display_sequence);
34: htp.p(ak_query_pkg.g_items_table(item-1).object_attribute_flag);
35: htp.p(ak_query_pkg.g_items_table(item-1).node_display_flag);
36: htp.p(ak_query_pkg.g_items_table(item-1).display_value_length);
29: if ak_query_pkg.g_items_table(item-1).object_attribute_flag = 'Y' then
30: htp.p(ak_query_pkg.g_items_table(item-1).attribute_code);
31: htp.p(ak_query_pkg.g_items_table(item-1).value_id);
32: htp.p(ak_query_pkg.g_items_table(item-1).attribute_label_long);
33: htp.p(ak_query_pkg.g_items_table(item-1).display_sequence);
34: htp.p(ak_query_pkg.g_items_table(item-1).object_attribute_flag);
35: htp.p(ak_query_pkg.g_items_table(item-1).node_display_flag);
36: htp.p(ak_query_pkg.g_items_table(item-1).display_value_length);
37: end if;
30: htp.p(ak_query_pkg.g_items_table(item-1).attribute_code);
31: htp.p(ak_query_pkg.g_items_table(item-1).value_id);
32: htp.p(ak_query_pkg.g_items_table(item-1).attribute_label_long);
33: htp.p(ak_query_pkg.g_items_table(item-1).display_sequence);
34: htp.p(ak_query_pkg.g_items_table(item-1).object_attribute_flag);
35: htp.p(ak_query_pkg.g_items_table(item-1).node_display_flag);
36: htp.p(ak_query_pkg.g_items_table(item-1).display_value_length);
37: end if;
38: end loop;
31: htp.p(ak_query_pkg.g_items_table(item-1).value_id);
32: htp.p(ak_query_pkg.g_items_table(item-1).attribute_label_long);
33: htp.p(ak_query_pkg.g_items_table(item-1).display_sequence);
34: htp.p(ak_query_pkg.g_items_table(item-1).object_attribute_flag);
35: htp.p(ak_query_pkg.g_items_table(item-1).node_display_flag);
36: htp.p(ak_query_pkg.g_items_table(item-1).display_value_length);
37: end if;
38: end loop;
39:
32: htp.p(ak_query_pkg.g_items_table(item-1).attribute_label_long);
33: htp.p(ak_query_pkg.g_items_table(item-1).display_sequence);
34: htp.p(ak_query_pkg.g_items_table(item-1).object_attribute_flag);
35: htp.p(ak_query_pkg.g_items_table(item-1).node_display_flag);
36: htp.p(ak_query_pkg.g_items_table(item-1).display_value_length);
37: end if;
38: end loop;
39:
40:
37: end if;
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
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));
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));
47: end if;
48: end loop;
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));
47: end if;
48: end loop;
49: end loop;
63: p_display_length out number) is
64:
65: begin
66:
67: p_attribute_code := ak_query_pkg.g_items_table(p_item_id).attribute_code;
68: p_value_id := ak_query_pkg.g_items_table(p_item_id).value_id;
69: p_attribute_label_long := ak_query_pkg.g_items_table(p_item_id).attribute_label_long;
70: p_display_sequence := ak_query_pkg.g_items_table(p_item_id).display_sequence;
71: p_object_attribute_flag := ak_query_pkg.g_items_table(p_item_id).object_attribute_flag;
64:
65: begin
66:
67: p_attribute_code := ak_query_pkg.g_items_table(p_item_id).attribute_code;
68: p_value_id := ak_query_pkg.g_items_table(p_item_id).value_id;
69: p_attribute_label_long := ak_query_pkg.g_items_table(p_item_id).attribute_label_long;
70: p_display_sequence := ak_query_pkg.g_items_table(p_item_id).display_sequence;
71: p_object_attribute_flag := ak_query_pkg.g_items_table(p_item_id).object_attribute_flag;
72: p_node_display_flag := ak_query_pkg.g_items_table(p_item_id).node_display_flag;
65: begin
66:
67: p_attribute_code := ak_query_pkg.g_items_table(p_item_id).attribute_code;
68: p_value_id := ak_query_pkg.g_items_table(p_item_id).value_id;
69: p_attribute_label_long := ak_query_pkg.g_items_table(p_item_id).attribute_label_long;
70: p_display_sequence := ak_query_pkg.g_items_table(p_item_id).display_sequence;
71: p_object_attribute_flag := ak_query_pkg.g_items_table(p_item_id).object_attribute_flag;
72: p_node_display_flag := ak_query_pkg.g_items_table(p_item_id).node_display_flag;
73: p_display_length := ak_query_pkg.g_items_table(p_item_id).display_value_length;
66:
67: p_attribute_code := ak_query_pkg.g_items_table(p_item_id).attribute_code;
68: p_value_id := ak_query_pkg.g_items_table(p_item_id).value_id;
69: p_attribute_label_long := ak_query_pkg.g_items_table(p_item_id).attribute_label_long;
70: p_display_sequence := ak_query_pkg.g_items_table(p_item_id).display_sequence;
71: p_object_attribute_flag := ak_query_pkg.g_items_table(p_item_id).object_attribute_flag;
72: p_node_display_flag := ak_query_pkg.g_items_table(p_item_id).node_display_flag;
73: p_display_length := ak_query_pkg.g_items_table(p_item_id).display_value_length;
74:
67: p_attribute_code := ak_query_pkg.g_items_table(p_item_id).attribute_code;
68: p_value_id := ak_query_pkg.g_items_table(p_item_id).value_id;
69: p_attribute_label_long := ak_query_pkg.g_items_table(p_item_id).attribute_label_long;
70: p_display_sequence := ak_query_pkg.g_items_table(p_item_id).display_sequence;
71: p_object_attribute_flag := ak_query_pkg.g_items_table(p_item_id).object_attribute_flag;
72: p_node_display_flag := ak_query_pkg.g_items_table(p_item_id).node_display_flag;
73: p_display_length := ak_query_pkg.g_items_table(p_item_id).display_value_length;
74:
75: end;
68: p_value_id := ak_query_pkg.g_items_table(p_item_id).value_id;
69: p_attribute_label_long := ak_query_pkg.g_items_table(p_item_id).attribute_label_long;
70: p_display_sequence := ak_query_pkg.g_items_table(p_item_id).display_sequence;
71: p_object_attribute_flag := ak_query_pkg.g_items_table(p_item_id).object_attribute_flag;
72: p_node_display_flag := ak_query_pkg.g_items_table(p_item_id).node_display_flag;
73: p_display_length := ak_query_pkg.g_items_table(p_item_id).display_value_length;
74:
75: end;
76:
69: p_attribute_label_long := ak_query_pkg.g_items_table(p_item_id).attribute_label_long;
70: p_display_sequence := ak_query_pkg.g_items_table(p_item_id).display_sequence;
71: p_object_attribute_flag := ak_query_pkg.g_items_table(p_item_id).object_attribute_flag;
72: p_node_display_flag := ak_query_pkg.g_items_table(p_item_id).node_display_flag;
73: p_display_length := ak_query_pkg.g_items_table(p_item_id).display_value_length;
74:
75: end;
76:
77:
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);
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);
97: else
98: p_result_row(l_item_num) := '';
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);
97: else
98: p_result_row(l_item_num) := '';
99: end if;
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);
97: else
98: p_result_row(l_item_num) := '';
99: end if;
100: end loop;