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_VL

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 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: