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.HZ_GEO_STRUCT_MAP_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package body hz_geo_struct_map_pub_w as
2: /* $Header: ARHGNRJB.pls 120.3 2005/10/25 14:16:07 baianand noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy hz_geo_struct_map_pub.geo_struct_map_dtl_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: ) as
7: ddindx binary_integer; indx binary_integer;
8: begin

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package body hz_geo_struct_map_pub_w as
2: /* $Header: ARHGNRJB.pls 120.3 2005/10/25 14:16:07 baianand noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy hz_geo_struct_map_pub.geo_struct_map_dtl_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: ) as
7: ddindx binary_integer; indx binary_integer;
8: begin
9: if a0 is not null and a0.count > 0 then

Line 27: , a1 out nocopy JTF_VARCHAR2_TABLE_100

23: end if;
24: end if;
25: end rosetta_table_copy_in_p2;
26: procedure rosetta_table_copy_out_p2(t hz_geo_struct_map_pub.geo_struct_map_dtl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
27: , a1 out nocopy JTF_VARCHAR2_TABLE_100
28: , a2 out nocopy JTF_VARCHAR2_TABLE_100
29: ) as
30: ddindx binary_integer; indx binary_integer;
31: begin

Line 28: , a2 out nocopy JTF_VARCHAR2_TABLE_100

24: end if;
25: end rosetta_table_copy_in_p2;
26: procedure rosetta_table_copy_out_p2(t hz_geo_struct_map_pub.geo_struct_map_dtl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
27: , a1 out nocopy JTF_VARCHAR2_TABLE_100
28: , a2 out nocopy JTF_VARCHAR2_TABLE_100
29: ) as
30: ddindx binary_integer; indx binary_integer;
31: begin
32: if t is null or t.count = 0 then

Line 34: a1 := JTF_VARCHAR2_TABLE_100();

30: ddindx binary_integer; indx binary_integer;
31: begin
32: if t is null or t.count = 0 then
33: a0 := JTF_NUMBER_TABLE();
34: a1 := JTF_VARCHAR2_TABLE_100();
35: a2 := JTF_VARCHAR2_TABLE_100();
36: else
37: a0 := JTF_NUMBER_TABLE();
38: a1 := JTF_VARCHAR2_TABLE_100();

Line 35: a2 := JTF_VARCHAR2_TABLE_100();

31: begin
32: if t is null or t.count = 0 then
33: a0 := JTF_NUMBER_TABLE();
34: a1 := JTF_VARCHAR2_TABLE_100();
35: a2 := JTF_VARCHAR2_TABLE_100();
36: else
37: a0 := JTF_NUMBER_TABLE();
38: a1 := JTF_VARCHAR2_TABLE_100();
39: a2 := JTF_VARCHAR2_TABLE_100();

Line 38: a1 := JTF_VARCHAR2_TABLE_100();

34: a1 := JTF_VARCHAR2_TABLE_100();
35: a2 := JTF_VARCHAR2_TABLE_100();
36: else
37: a0 := JTF_NUMBER_TABLE();
38: a1 := JTF_VARCHAR2_TABLE_100();
39: a2 := JTF_VARCHAR2_TABLE_100();
40: if t.count > 0 then
41: a0.extend(t.count);
42: a1.extend(t.count);

Line 39: a2 := JTF_VARCHAR2_TABLE_100();

35: a2 := JTF_VARCHAR2_TABLE_100();
36: else
37: a0 := JTF_NUMBER_TABLE();
38: a1 := JTF_VARCHAR2_TABLE_100();
39: a2 := JTF_VARCHAR2_TABLE_100();
40: if t.count > 0 then
41: a0.extend(t.count);
42: a1.extend(t.count);
43: a2.extend(t.count);

Line 64: , p1_a1 JTF_VARCHAR2_TABLE_100

60: procedure create_geo_struct_mapping(p0_a0 VARCHAR2
61: , p0_a1 VARCHAR2
62: , p0_a2 VARCHAR2
63: , p1_a0 JTF_NUMBER_TABLE
64: , p1_a1 JTF_VARCHAR2_TABLE_100
65: , p1_a2 JTF_VARCHAR2_TABLE_100
66: , p_init_msg_list VARCHAR2
67: , x_map_id out nocopy NUMBER
68: , x_return_status out nocopy VARCHAR2

Line 65: , p1_a2 JTF_VARCHAR2_TABLE_100

61: , p0_a1 VARCHAR2
62: , p0_a2 VARCHAR2
63: , p1_a0 JTF_NUMBER_TABLE
64: , p1_a1 JTF_VARCHAR2_TABLE_100
65: , p1_a2 JTF_VARCHAR2_TABLE_100
66: , p_init_msg_list VARCHAR2
67: , x_map_id out nocopy NUMBER
68: , x_return_status out nocopy VARCHAR2
69: , x_msg_count out nocopy NUMBER

Line 117: , p4_a1 JTF_VARCHAR2_TABLE_100

113: , p_location_table_name VARCHAR2
114: , p_country VARCHAR2
115: , p_address_style VARCHAR2
116: , p4_a0 JTF_NUMBER_TABLE
117: , p4_a1 JTF_VARCHAR2_TABLE_100
118: , p4_a2 JTF_VARCHAR2_TABLE_100
119: , p_init_msg_list VARCHAR2
120: , x_return_status out nocopy VARCHAR2
121: , x_msg_count out nocopy NUMBER

Line 118: , p4_a2 JTF_VARCHAR2_TABLE_100

114: , p_country VARCHAR2
115: , p_address_style VARCHAR2
116: , p4_a0 JTF_NUMBER_TABLE
117: , p4_a1 JTF_VARCHAR2_TABLE_100
118: , p4_a2 JTF_VARCHAR2_TABLE_100
119: , p_init_msg_list VARCHAR2
120: , x_return_status out nocopy VARCHAR2
121: , x_msg_count out nocopy NUMBER
122: , x_msg_data out nocopy VARCHAR2

Line 168: , p1_a1 JTF_VARCHAR2_TABLE_100

164: end;
165:
166: procedure create_geo_struct_map_dtls(p_map_id NUMBER
167: , p1_a0 JTF_NUMBER_TABLE
168: , p1_a1 JTF_VARCHAR2_TABLE_100
169: , p1_a2 JTF_VARCHAR2_TABLE_100
170: , p_init_msg_list VARCHAR2
171: , x_return_status out nocopy VARCHAR2
172: , x_msg_count out nocopy NUMBER

Line 169: , p1_a2 JTF_VARCHAR2_TABLE_100

165:
166: procedure create_geo_struct_map_dtls(p_map_id NUMBER
167: , p1_a0 JTF_NUMBER_TABLE
168: , p1_a1 JTF_VARCHAR2_TABLE_100
169: , p1_a2 JTF_VARCHAR2_TABLE_100
170: , p_init_msg_list VARCHAR2
171: , x_return_status out nocopy VARCHAR2
172: , x_msg_count out nocopy NUMBER
173: , x_msg_data out nocopy VARCHAR2

Line 210: , p1_a1 JTF_VARCHAR2_TABLE_100

206: end;
207:
208: procedure update_geo_struct_map_dtls(p_map_id NUMBER
209: , p1_a0 JTF_NUMBER_TABLE
210: , p1_a1 JTF_VARCHAR2_TABLE_100
211: , p1_a2 JTF_VARCHAR2_TABLE_100
212: , p_init_msg_list VARCHAR2
213: , x_return_status out nocopy VARCHAR2
214: , x_msg_count out nocopy NUMBER

Line 211: , p1_a2 JTF_VARCHAR2_TABLE_100

207:
208: procedure update_geo_struct_map_dtls(p_map_id NUMBER
209: , p1_a0 JTF_NUMBER_TABLE
210: , p1_a1 JTF_VARCHAR2_TABLE_100
211: , p1_a2 JTF_VARCHAR2_TABLE_100
212: , p_init_msg_list VARCHAR2
213: , x_return_status out nocopy VARCHAR2
214: , x_msg_count out nocopy NUMBER
215: , x_msg_data out nocopy VARCHAR2