APPS.ICX_AK_JAVA_QUERY dependencies on AK_QUERY_PKG

Line 17: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => p_region_app_id,

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',

Line 25: htp.p(ak_query_pkg.g_items_table.count);

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

Line 26: htp.p(ak_query_pkg.g_results_table.count);

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

Line 28: for item in 1..ak_query_pkg.g_items_table.count loop

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

Line 29: if ak_query_pkg.g_items_table(item-1).object_attribute_flag = 'Y' then

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

Line 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);

Line 31: htp.p(ak_query_pkg.g_items_table(item-1).value_id);

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

Line 32: htp.p(ak_query_pkg.g_items_table(item-1).attribute_label_long);

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

Line 33: htp.p(ak_query_pkg.g_items_table(item-1).display_sequence);

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;

Line 34: htp.p(ak_query_pkg.g_items_table(item-1).object_attribute_flag);

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;

Line 35: htp.p(ak_query_pkg.g_items_table(item-1).node_display_flag);

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:

Line 36: htp.p(ak_query_pkg.g_items_table(item-1).display_value_length);

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:

Line 41: for result in 1 .. ak_query_pkg.g_results_table.count loop

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

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 44: for l_item_num in 1..ak_query_pkg.g_items_table.count loop

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;

Line 45: if ak_query_pkg.g_items_table(l_item_num-1).object_attribute_flag = 'Y' then

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;

Line 67: p_attribute_code := ak_query_pkg.g_items_table(p_item_id).attribute_code;

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;

Line 68: p_value_id := ak_query_pkg.g_items_table(p_item_id).value_id;

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;

Line 69: p_attribute_label_long := ak_query_pkg.g_items_table(p_item_id).attribute_label_long;

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;

Line 70: p_display_sequence := ak_query_pkg.g_items_table(p_item_id).display_sequence;

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:

Line 71: p_object_attribute_flag := ak_query_pkg.g_items_table(p_item_id).object_attribute_flag;

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;

Line 72: p_node_display_flag := ak_query_pkg.g_items_table(p_item_id).node_display_flag;

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:

Line 73: p_display_length := ak_query_pkg.g_items_table(p_item_id).display_value_length;

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:

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

Line 94: for l_item_num in 1..ak_query_pkg.g_items_table.count loop

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) := '';

Line 95: if ak_query_pkg.g_items_table(l_item_num - 1).object_attribute_flag = 'Y' then

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;

Line 96: p_result_row(l_item_num) := l_result_row(ak_query_pkg.g_items_table(l_item_num - 1).value_id);

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;