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);
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:
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;
50: