APPS.HZ_GEO_STRUCT_MAP_PUB_W dependencies on HZ_GEO_STRUCT_MAP_PUB

Line 1: package body hz_geo_struct_map_pub_w as

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

Line 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

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;

Line 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

22: end loop;
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;

Line 74: ddp_geo_struct_map_rec hz_geo_struct_map_pub.geo_struct_map_rec_type;

70: , x_msg_data out nocopy VARCHAR2
71: )
72:
73: as
74: ddp_geo_struct_map_rec hz_geo_struct_map_pub.geo_struct_map_rec_type;
75: ddp_geo_struct_map_dtl_tbl hz_geo_struct_map_pub.geo_struct_map_dtl_tbl_type;
76: ddindx binary_integer; indx binary_integer;
77: begin
78:

Line 75: ddp_geo_struct_map_dtl_tbl hz_geo_struct_map_pub.geo_struct_map_dtl_tbl_type;

71: )
72:
73: as
74: ddp_geo_struct_map_rec hz_geo_struct_map_pub.geo_struct_map_rec_type;
75: ddp_geo_struct_map_dtl_tbl hz_geo_struct_map_pub.geo_struct_map_dtl_tbl_type;
76: ddindx binary_integer; indx binary_integer;
77: begin
78:
79: -- copy data to the local IN or IN-OUT args, if any

Line 84: hz_geo_struct_map_pub_w.rosetta_table_copy_in_p2(ddp_geo_struct_map_dtl_tbl, p1_a0

80: ddp_geo_struct_map_rec.country_code := p0_a0;
81: ddp_geo_struct_map_rec.loc_tbl_name := p0_a1;
82: ddp_geo_struct_map_rec.address_style := p0_a2;
83:
84: hz_geo_struct_map_pub_w.rosetta_table_copy_in_p2(ddp_geo_struct_map_dtl_tbl, p1_a0
85: , p1_a1
86: , p1_a2
87: );
88:

Line 95: hz_geo_struct_map_pub.create_geo_struct_mapping(ddp_geo_struct_map_rec,

91:
92:
93:
94: -- here's the delegated call to the old PL/SQL routine
95: hz_geo_struct_map_pub.create_geo_struct_mapping(ddp_geo_struct_map_rec,
96: ddp_geo_struct_map_dtl_tbl,
97: p_init_msg_list,
98: x_map_id,
99: x_return_status,

Line 126: ddp_geo_struct_map_dtl_tbl hz_geo_struct_map_pub.geo_struct_map_dtl_tbl_type;

122: , x_msg_data out nocopy VARCHAR2
123: )
124:
125: as
126: ddp_geo_struct_map_dtl_tbl hz_geo_struct_map_pub.geo_struct_map_dtl_tbl_type;
127: ddindx binary_integer; indx binary_integer;
128: begin
129:
130: -- copy data to the local IN or IN-OUT args, if any

Line 135: hz_geo_struct_map_pub_w.rosetta_table_copy_in_p2(ddp_geo_struct_map_dtl_tbl, p4_a0

131:
132:
133:
134:
135: hz_geo_struct_map_pub_w.rosetta_table_copy_in_p2(ddp_geo_struct_map_dtl_tbl, p4_a0
136: , p4_a1
137: , p4_a2
138: );
139:

Line 145: hz_geo_struct_map_pub.delete_geo_struct_mapping(p_map_id,

141:
142:
143:
144: -- here's the delegated call to the old PL/SQL routine
145: hz_geo_struct_map_pub.delete_geo_struct_mapping(p_map_id,
146: p_location_table_name,
147: p_country,
148: p_address_style,
149: ddp_geo_struct_map_dtl_tbl,

Line 177: ddp_geo_struct_map_dtl_tbl hz_geo_struct_map_pub.geo_struct_map_dtl_tbl_type;

173: , x_msg_data out nocopy VARCHAR2
174: )
175:
176: as
177: ddp_geo_struct_map_dtl_tbl hz_geo_struct_map_pub.geo_struct_map_dtl_tbl_type;
178: ddindx binary_integer; indx binary_integer;
179: begin
180:
181: -- copy data to the local IN or IN-OUT args, if any

Line 183: hz_geo_struct_map_pub_w.rosetta_table_copy_in_p2(ddp_geo_struct_map_dtl_tbl, p1_a0

179: begin
180:
181: -- copy data to the local IN or IN-OUT args, if any
182:
183: hz_geo_struct_map_pub_w.rosetta_table_copy_in_p2(ddp_geo_struct_map_dtl_tbl, p1_a0
184: , p1_a1
185: , p1_a2
186: );
187:

Line 193: hz_geo_struct_map_pub.create_geo_struct_map_dtls(p_map_id,

189:
190:
191:
192: -- here's the delegated call to the old PL/SQL routine
193: hz_geo_struct_map_pub.create_geo_struct_map_dtls(p_map_id,
194: ddp_geo_struct_map_dtl_tbl,
195: p_init_msg_list,
196: x_return_status,
197: x_msg_count,

Line 219: ddp_geo_struct_map_dtl_tbl hz_geo_struct_map_pub.geo_struct_map_dtl_tbl_type;

215: , x_msg_data out nocopy VARCHAR2
216: )
217:
218: as
219: ddp_geo_struct_map_dtl_tbl hz_geo_struct_map_pub.geo_struct_map_dtl_tbl_type;
220: ddindx binary_integer; indx binary_integer;
221: begin
222:
223: -- copy data to the local IN or IN-OUT args, if any

Line 225: hz_geo_struct_map_pub_w.rosetta_table_copy_in_p2(ddp_geo_struct_map_dtl_tbl, p1_a0

221: begin
222:
223: -- copy data to the local IN or IN-OUT args, if any
224:
225: hz_geo_struct_map_pub_w.rosetta_table_copy_in_p2(ddp_geo_struct_map_dtl_tbl, p1_a0
226: , p1_a1
227: , p1_a2
228: );
229:

Line 235: hz_geo_struct_map_pub.update_geo_struct_map_dtls(p_map_id,

231:
232:
233:
234: -- here's the delegated call to the old PL/SQL routine
235: hz_geo_struct_map_pub.update_geo_struct_map_dtls(p_map_id,
236: ddp_geo_struct_map_dtl_tbl,
237: p_init_msg_list,
238: x_return_status,
239: x_msg_count,

Line 250: end hz_geo_struct_map_pub_w;

246:
247:
248: end;
249:
250: end hz_geo_struct_map_pub_w;