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_STRUCTURE_PUB_UIW_JW dependencies on HZ_GEO_STRUCTURE_PUB_UIW

Line 1: package body hz_geo_structure_pub_uiw_jw as

1: package body hz_geo_structure_pub_uiw_jw as
2: /* $Header: ARHGSTJB.pls 120.1 2005/08/26 15:22:37 dmmehta noship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

Line 22: procedure rosetta_table_copy_in_p0(t out nocopy hz_geo_structure_pub_uiw.incl_geo_type_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as

18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p0(t out nocopy hz_geo_structure_pub_uiw.incl_geo_type_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is not null and a0.count > 0 then
26: if a0.count > 0 then

Line 40: procedure rosetta_table_copy_out_p0(t hz_geo_structure_pub_uiw.incl_geo_type_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

36: end loop;
37: end if;
38: end if;
39: end rosetta_table_copy_in_p0;
40: procedure rosetta_table_copy_out_p0(t hz_geo_structure_pub_uiw.incl_geo_type_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
41: ddindx binary_integer; indx binary_integer;
42: begin
43: if t is null or t.count = 0 then
44: a0 := JTF_VARCHAR2_TABLE_100();

Line 73: ddp_geography_type_rec hz_geo_structure_pub_uiw.geography_type_rec_type;

69: , p1_a2 VARCHAR2 := null
70: , p1_a3 NUMBER := null
71: )
72: as
73: ddp_geography_type_rec hz_geo_structure_pub_uiw.geography_type_rec_type;
74: ddindx binary_integer; indx binary_integer;
75: begin
76:
77: -- copy data to the local IN or IN-OUT args, if any

Line 88: hz_geo_structure_pub_uiw.create_geography_type(p_init_msg_list,

84:
85:
86:
87: -- here's the delegated call to the old PL/SQL routine
88: hz_geo_structure_pub_uiw.create_geography_type(p_init_msg_list,
89: ddp_geography_type_rec,
90: x_return_status,
91: x_msg_count,
92: x_msg_data);

Line 112: ddp_geo_structure_rec hz_geo_structure_pub_uiw.geo_structure_rec_type;

108: , p1_a3 VARCHAR2 := null
109: , p1_a4 NUMBER := null
110: )
111: as
112: ddp_geo_structure_rec hz_geo_structure_pub_uiw.geo_structure_rec_type;
113: ddindx binary_integer; indx binary_integer;
114: begin
115:
116: -- copy data to the local IN or IN-OUT args, if any

Line 128: hz_geo_structure_pub_uiw.create_geo_structure(p_init_msg_list,

124:
125:
126:
127: -- here's the delegated call to the old PL/SQL routine
128: hz_geo_structure_pub_uiw.create_geo_structure(p_init_msg_list,
129: ddp_geo_structure_rec,
130: x_return_status,
131: x_msg_count,
132: x_msg_data);

Line 153: ddp_geo_rel_type_rec hz_geo_structure_pub_uiw.geo_rel_type_rec_type;

149: , p1_a3 VARCHAR2 := null
150: , p1_a4 NUMBER := null
151: )
152: as
153: ddp_geo_rel_type_rec hz_geo_structure_pub_uiw.geo_rel_type_rec_type;
154: ddindx binary_integer; indx binary_integer;
155: begin
156:
157: -- copy data to the local IN or IN-OUT args, if any

Line 170: hz_geo_structure_pub_uiw.create_geo_rel_type(p_init_msg_list,

166:
167:
168:
169: -- here's the delegated call to the old PL/SQL routine
170: hz_geo_structure_pub_uiw.create_geo_rel_type(p_init_msg_list,
171: ddp_geo_rel_type_rec,
172: x_relationship_type_id,
173: x_return_status,
174: x_msg_count,

Line 199: ddp_zone_type_rec hz_geo_structure_pub_uiw.zone_type_rec_type;

195: , p1_a5 VARCHAR2 := null
196: , p1_a6 NUMBER := null
197: )
198: as
199: ddp_zone_type_rec hz_geo_structure_pub_uiw.zone_type_rec_type;
200: ddp_included_geography_type hz_geo_structure_pub_uiw.incl_geo_type_tbl_type;
201: ddindx binary_integer; indx binary_integer;
202: begin
203:

Line 200: ddp_included_geography_type hz_geo_structure_pub_uiw.incl_geo_type_tbl_type;

196: , p1_a6 NUMBER := null
197: )
198: as
199: ddp_zone_type_rec hz_geo_structure_pub_uiw.zone_type_rec_type;
200: ddp_included_geography_type hz_geo_structure_pub_uiw.incl_geo_type_tbl_type;
201: ddindx binary_integer; indx binary_integer;
202: begin
203:
204: -- copy data to the local IN or IN-OUT args, if any

Line 214: hz_geo_structure_pub_uiw_jw.rosetta_table_copy_in_p0(ddp_included_geography_type, p_included_geography_type);

210: ddp_zone_type_rec.postal_code_range_flag := p1_a4;
211: ddp_zone_type_rec.created_by_module := p1_a5;
212: ddp_zone_type_rec.application_id := rosetta_g_miss_num_map(p1_a6);
213:
214: hz_geo_structure_pub_uiw_jw.rosetta_table_copy_in_p0(ddp_included_geography_type, p_included_geography_type);
215:
216:
217:
218:

Line 220: hz_geo_structure_pub_uiw.create_zone_type(p_init_msg_list,

216:
217:
218:
219: -- here's the delegated call to the old PL/SQL routine
220: hz_geo_structure_pub_uiw.create_zone_type(p_init_msg_list,
221: ddp_zone_type_rec,
222: ddp_included_geography_type,
223: x_return_status,
224: x_msg_count,

Line 250: ddp_zone_type_rec hz_geo_structure_pub_uiw.zone_type_rec_type;

246: , p1_a5 VARCHAR2 := null
247: , p1_a6 NUMBER := null
248: )
249: as
250: ddp_zone_type_rec hz_geo_structure_pub_uiw.zone_type_rec_type;
251: ddp_included_geography_type hz_geo_structure_pub_uiw.incl_geo_type_tbl_type;
252: ddindx binary_integer; indx binary_integer;
253: begin
254:

Line 251: ddp_included_geography_type hz_geo_structure_pub_uiw.incl_geo_type_tbl_type;

247: , p1_a6 NUMBER := null
248: )
249: as
250: ddp_zone_type_rec hz_geo_structure_pub_uiw.zone_type_rec_type;
251: ddp_included_geography_type hz_geo_structure_pub_uiw.incl_geo_type_tbl_type;
252: ddindx binary_integer; indx binary_integer;
253: begin
254:
255: -- copy data to the local IN or IN-OUT args, if any

Line 265: hz_geo_structure_pub_uiw_jw.rosetta_table_copy_in_p0(ddp_included_geography_type, p_included_geography_type);

261: ddp_zone_type_rec.postal_code_range_flag := p1_a4;
262: ddp_zone_type_rec.created_by_module := p1_a5;
263: ddp_zone_type_rec.application_id := rosetta_g_miss_num_map(p1_a6);
264:
265: hz_geo_structure_pub_uiw_jw.rosetta_table_copy_in_p0(ddp_included_geography_type, p_included_geography_type);
266:
267:
268:
269:

Line 272: hz_geo_structure_pub_uiw.update_zone_type(p_init_msg_list,

268:
269:
270:
271: -- here's the delegated call to the old PL/SQL routine
272: hz_geo_structure_pub_uiw.update_zone_type(p_init_msg_list,
273: ddp_zone_type_rec,
274: ddp_included_geography_type,
275: p_object_version_number,
276: x_return_status,

Line 289: end hz_geo_structure_pub_uiw_jw;

285:
286:
287: end;
288:
289: end hz_geo_structure_pub_uiw_jw;