eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_RUN_FLOW_PKG dependencies on AK_QUERY_PKG

Line 17: l_regions_table AK_QUERY_PKG.regions_table_type;

13: and ar.region_code = x_region_code
14: and ao.object_type in ('TABLE', 'VIEW');
15: TYPE label_table_type is TABLE of varchar2(50)
16: index by binary_integer;
17: l_regions_table AK_QUERY_PKG.regions_table_type;
18: l_items_table AK_QUERY_PKG.items_table_type;
19: l_results_table AK_QUERY_PKG.results_table_type;
20: l_label1_table label_table_type;
21: l_label2_table label_table_type;

Line 18: l_items_table AK_QUERY_PKG.items_table_type;

14: and ao.object_type in ('TABLE', 'VIEW');
15: TYPE label_table_type is TABLE of varchar2(50)
16: index by binary_integer;
17: l_regions_table AK_QUERY_PKG.regions_table_type;
18: l_items_table AK_QUERY_PKG.items_table_type;
19: l_results_table AK_QUERY_PKG.results_table_type;
20: l_label1_table label_table_type;
21: l_label2_table label_table_type;
22: l_label3_table label_table_type;

Line 19: l_results_table AK_QUERY_PKG.results_table_type;

15: TYPE label_table_type is TABLE of varchar2(50)
16: index by binary_integer;
17: l_regions_table AK_QUERY_PKG.regions_table_type;
18: l_items_table AK_QUERY_PKG.items_table_type;
19: l_results_table AK_QUERY_PKG.results_table_type;
20: l_label1_table label_table_type;
21: l_label2_table label_table_type;
22: l_label3_table label_table_type;
23:

Line 43: AK_QUERY_PKG.exec_query(

39: close check_object_csr;
40: --
41: -- Call exec_query to obtain the list values
42: --
43: AK_QUERY_PKG.exec_query(
44: p_flow_appl_id => null,
45: p_flow_code => null,
46: p_parent_page_appl_id => null,
47: p_parent_page_code => null,

Line 78: l_regions_table := ak_query_pkg.g_regions_table;

74: -- display_value.
75: -- *Note 2: The PL/SQL table is sparse, and the region_rec_id returned
76: -- from execute_query will be used as index
77: --
78: l_regions_table := ak_query_pkg.g_regions_table;
79: l_items_table := ak_query_pkg.g_items_table;
80: l_results_table := ak_query_pkg.g_results_table;
81:
82: if l_items_table.count > 0 then

Line 79: l_items_table := ak_query_pkg.g_items_table;

75: -- *Note 2: The PL/SQL table is sparse, and the region_rec_id returned
76: -- from execute_query will be used as index
77: --
78: l_regions_table := ak_query_pkg.g_regions_table;
79: l_items_table := ak_query_pkg.g_items_table;
80: l_results_table := ak_query_pkg.g_results_table;
81:
82: if l_items_table.count > 0 then
83: l_index := l_items_table.first;

Line 80: l_results_table := ak_query_pkg.g_results_table;

76: -- from execute_query will be used as index
77: --
78: l_regions_table := ak_query_pkg.g_regions_table;
79: l_items_table := ak_query_pkg.g_items_table;
80: l_results_table := ak_query_pkg.g_results_table;
81:
82: if l_items_table.count > 0 then
83: l_index := l_items_table.first;
84: while l_index is not null loop