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.JTF_REGION_PUB dependencies on AK_REGION_ITEMS

Line 5: attribute_label_long ak_region_items_vl.attribute_label_long%type -- varchar2(50)

1: PACKAGE BODY jtf_region_pub AS
2: /* $Header: jtfregnb.pls 120.3 2005/11/01 21:25:22 psanyal ship $ */
3: JTT_IGNORE_COLUMN_NAME varchar2(23) := 'JTT_IGNORE_COLUMN_NAME_';
4: TYPE region_item is record (
5: attribute_label_long ak_region_items_vl.attribute_label_long%type -- varchar2(50)
6: , attribute_label_short ak_region_items_vl.attribute_label_short%type -- varchar2(30)
7: , data_type ak_region_items_vl.data_type%type -- varchar2(30)
8: , attribute_name ak_region_items_vl.attribute_name%type -- varchar2(30)
9: , attribute_code ak_region_items_vl.attribute_code%type -- varchar2(30)

Line 6: , attribute_label_short ak_region_items_vl.attribute_label_short%type -- varchar2(30)

2: /* $Header: jtfregnb.pls 120.3 2005/11/01 21:25:22 psanyal ship $ */
3: JTT_IGNORE_COLUMN_NAME varchar2(23) := 'JTT_IGNORE_COLUMN_NAME_';
4: TYPE region_item is record (
5: attribute_label_long ak_region_items_vl.attribute_label_long%type -- varchar2(50)
6: , attribute_label_short ak_region_items_vl.attribute_label_short%type -- varchar2(30)
7: , data_type ak_region_items_vl.data_type%type -- varchar2(30)
8: , attribute_name ak_region_items_vl.attribute_name%type -- varchar2(30)
9: , attribute_code ak_region_items_vl.attribute_code%type -- varchar2(30)
10: , attribute_description ak_region_items_vl.attribute_description%type -- varchar2(2000)

Line 7: , data_type ak_region_items_vl.data_type%type -- varchar2(30)

3: JTT_IGNORE_COLUMN_NAME varchar2(23) := 'JTT_IGNORE_COLUMN_NAME_';
4: TYPE region_item is record (
5: attribute_label_long ak_region_items_vl.attribute_label_long%type -- varchar2(50)
6: , attribute_label_short ak_region_items_vl.attribute_label_short%type -- varchar2(30)
7: , data_type ak_region_items_vl.data_type%type -- varchar2(30)
8: , attribute_name ak_region_items_vl.attribute_name%type -- varchar2(30)
9: , attribute_code ak_region_items_vl.attribute_code%type -- varchar2(30)
10: , attribute_description ak_region_items_vl.attribute_description%type -- varchar2(2000)
11: , display_value_length ak_region_items_vl.display_value_length%type -- number

Line 8: , attribute_name ak_region_items_vl.attribute_name%type -- varchar2(30)

4: TYPE region_item is record (
5: attribute_label_long ak_region_items_vl.attribute_label_long%type -- varchar2(50)
6: , attribute_label_short ak_region_items_vl.attribute_label_short%type -- varchar2(30)
7: , data_type ak_region_items_vl.data_type%type -- varchar2(30)
8: , attribute_name ak_region_items_vl.attribute_name%type -- varchar2(30)
9: , attribute_code ak_region_items_vl.attribute_code%type -- varchar2(30)
10: , attribute_description ak_region_items_vl.attribute_description%type -- varchar2(2000)
11: , display_value_length ak_region_items_vl.display_value_length%type -- number
12: , lov_region_code ak_region_items_vl.lov_region_code%type -- varchar2(30)

Line 9: , attribute_code ak_region_items_vl.attribute_code%type -- varchar2(30)

5: attribute_label_long ak_region_items_vl.attribute_label_long%type -- varchar2(50)
6: , attribute_label_short ak_region_items_vl.attribute_label_short%type -- varchar2(30)
7: , data_type ak_region_items_vl.data_type%type -- varchar2(30)
8: , attribute_name ak_region_items_vl.attribute_name%type -- varchar2(30)
9: , attribute_code ak_region_items_vl.attribute_code%type -- varchar2(30)
10: , attribute_description ak_region_items_vl.attribute_description%type -- varchar2(2000)
11: , display_value_length ak_region_items_vl.display_value_length%type -- number
12: , lov_region_code ak_region_items_vl.lov_region_code%type -- varchar2(30)
13: , node_display_flag ak_region_items_vl.node_display_flag%type -- varchar2(1)

Line 10: , attribute_description ak_region_items_vl.attribute_description%type -- varchar2(2000)

6: , attribute_label_short ak_region_items_vl.attribute_label_short%type -- varchar2(30)
7: , data_type ak_region_items_vl.data_type%type -- varchar2(30)
8: , attribute_name ak_region_items_vl.attribute_name%type -- varchar2(30)
9: , attribute_code ak_region_items_vl.attribute_code%type -- varchar2(30)
10: , attribute_description ak_region_items_vl.attribute_description%type -- varchar2(2000)
11: , display_value_length ak_region_items_vl.display_value_length%type -- number
12: , lov_region_code ak_region_items_vl.lov_region_code%type -- varchar2(30)
13: , node_display_flag ak_region_items_vl.node_display_flag%type -- varchar2(1)
14: , node_query_flag ak_region_items_vl.node_query_flag%type -- varchar2(1)

Line 11: , display_value_length ak_region_items_vl.display_value_length%type -- number

7: , data_type ak_region_items_vl.data_type%type -- varchar2(30)
8: , attribute_name ak_region_items_vl.attribute_name%type -- varchar2(30)
9: , attribute_code ak_region_items_vl.attribute_code%type -- varchar2(30)
10: , attribute_description ak_region_items_vl.attribute_description%type -- varchar2(2000)
11: , display_value_length ak_region_items_vl.display_value_length%type -- number
12: , lov_region_code ak_region_items_vl.lov_region_code%type -- varchar2(30)
13: , node_display_flag ak_region_items_vl.node_display_flag%type -- varchar2(1)
14: , node_query_flag ak_region_items_vl.node_query_flag%type -- varchar2(1)
15: );

Line 12: , lov_region_code ak_region_items_vl.lov_region_code%type -- varchar2(30)

8: , attribute_name ak_region_items_vl.attribute_name%type -- varchar2(30)
9: , attribute_code ak_region_items_vl.attribute_code%type -- varchar2(30)
10: , attribute_description ak_region_items_vl.attribute_description%type -- varchar2(2000)
11: , display_value_length ak_region_items_vl.display_value_length%type -- number
12: , lov_region_code ak_region_items_vl.lov_region_code%type -- varchar2(30)
13: , node_display_flag ak_region_items_vl.node_display_flag%type -- varchar2(1)
14: , node_query_flag ak_region_items_vl.node_query_flag%type -- varchar2(1)
15: );
16:

Line 13: , node_display_flag ak_region_items_vl.node_display_flag%type -- varchar2(1)

9: , attribute_code ak_region_items_vl.attribute_code%type -- varchar2(30)
10: , attribute_description ak_region_items_vl.attribute_description%type -- varchar2(2000)
11: , display_value_length ak_region_items_vl.display_value_length%type -- number
12: , lov_region_code ak_region_items_vl.lov_region_code%type -- varchar2(30)
13: , node_display_flag ak_region_items_vl.node_display_flag%type -- varchar2(1)
14: , node_query_flag ak_region_items_vl.node_query_flag%type -- varchar2(1)
15: );
16:
17: TYPE region_items_table IS TABLE OF region_item INDEX BY BINARY_INTEGER;

Line 14: , node_query_flag ak_region_items_vl.node_query_flag%type -- varchar2(1)

10: , attribute_description ak_region_items_vl.attribute_description%type -- varchar2(2000)
11: , display_value_length ak_region_items_vl.display_value_length%type -- number
12: , lov_region_code ak_region_items_vl.lov_region_code%type -- varchar2(30)
13: , node_display_flag ak_region_items_vl.node_display_flag%type -- varchar2(1)
14: , node_query_flag ak_region_items_vl.node_query_flag%type -- varchar2(1)
15: );
16:
17: TYPE region_items_table IS TABLE OF region_item INDEX BY BINARY_INTEGER;
18:

Line 23: -- each of the attribute_code in the ak_region_items table

19: function ever_varies_based_on_resp_id(
20: p_region_code varchar2,
21: p_application_id number) return number is
22: temp number;
23: -- each of the attribute_code in the ak_region_items table
24: cursor each_attribute_code is select attribute_code
25: from ak_region_items
26: where region_code = p_region_code and
27: region_application_id = p_application_id;

Line 25: from ak_region_items

21: p_application_id number) return number is
22: temp number;
23: -- each of the attribute_code in the ak_region_items table
24: cursor each_attribute_code is select attribute_code
25: from ak_region_items
26: where region_code = p_region_code and
27: region_application_id = p_application_id;
28:
29: cursor excluded_resps (p_attribute_code varchar2) is select

Line 71: p_region_items_table jtf_region_pub.ak_region_items_table,

67: p_respid number,
68: p_object_name varchar2,
69: p_region_name varchar2,
70: p_region_description varchar2,
71: p_region_items_table jtf_region_pub.ak_region_items_table,
72: p_ret_region_codes in out nocopy short_varchar2_table,
73: p_ret_resp_ids in out nocopy number_table,
74: p_ret_object_name in out nocopy short_varchar2_table,
75: p_ret_region_name in out nocopy short_varchar2_table,

Line 77: p_ret_region_items_table IN OUT nocopy jtf_region_pub.ak_region_items_table) is

73: p_ret_resp_ids in out nocopy number_table,
74: p_ret_object_name in out nocopy short_varchar2_table,
75: p_ret_region_name in out nocopy short_varchar2_table,
76: p_ret_region_description in out nocopy long_varchar2_table,
77: p_ret_region_items_table IN OUT nocopy jtf_region_pub.ak_region_items_table) is
78: t_row number := 1+p_ret_region_codes.count;
79: t_idx number;
80: begin
81: if p_region_items_table.count = 0 then return; end if;

Line 116: p_ret_region_items_table OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.ak_region_items_table) is

112: p_ret_resp_ids OUT NOCOPY /* file.sql.39 change */ number_table,
113: p_ret_object_name OUT NOCOPY /* file.sql.39 change */ short_varchar2_table,
114: p_ret_region_name OUT NOCOPY /* file.sql.39 change */ short_varchar2_table,
115: p_ret_region_description OUT NOCOPY /* file.sql.39 change */ long_varchar2_table,
116: p_ret_region_items_table OUT NOCOPY /* file.sql.39 change */ jtf_region_pub.ak_region_items_table) is
117: t_region_codes short_varchar2_table;
118: t_respids number_table;
119: t_respids_first number;
120: t_respids_index number;

Line 127: t_region_items_table jtf_region_pub.ak_region_items_table;

123: t_respid_index number := 1;
124: t_object_name ak_regions_vl.object_name%type;
125: t_region_name ak_regions_vl.name%type;
126: t_region_description ak_regions_vl.description%type;
127: t_region_items_table jtf_region_pub.ak_region_items_table;
128: t_missing_or_invalid boolean;
129: t_prefix varchar2(25);
130: begin
131:

Line 249: , p_region_items_table OUT NOCOPY /* file.sql.39 change */ ak_region_items_table

245: , p_responsibility_id in number
246: , p_object_name OUT NOCOPY /* file.sql.39 change */ varchar2
247: , p_region_name OUT NOCOPY /* file.sql.39 change */ varchar2
248: , p_region_description OUT NOCOPY /* file.sql.39 change */ varchar2
249: , p_region_items_table OUT NOCOPY /* file.sql.39 change */ ak_region_items_table
250: ) IS
251: cnt number := 0;
252: l_region_items_table region_items_table;
253: p_column_name varchar2(30) := null;

Line 284: from ak_region_items_vl a

280: attribute_name , object_attribute_flag, attribute_code,
281: attribute_description, display_value_length,lov_region_code,
282: node_display_flag,node_query_flag
283:
284: from ak_region_items_vl a
285: where region_code=t_region_code and
286: region_application_id = p_application_id and
287: attribute_code not in
288: (select attribute_code from ak_excluded_items where

Line 336: from ak_region_items_vl a

332: l_attribute_label_long varchar2(50);
333: BEGIN
334:
335: select attribute_label_long into l_attribute_label_long
336: from ak_region_items_vl a
337: where region_code=p_region_code and attribute_code = p_attribute_code;
338:
339: return l_attribute_label_long;
340: