[Home] [Help]
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY VARCHAR2
40: ) AS
41: l_geography_type_rec HZ_GEOGRAPHY_STRUCTURE_PUB.GEOGRAPHY_TYPE_REC_TYPE;
42: BEGIN
43: l_geography_type_rec.geography_type := p_geography_type_rec.geography_type;
44: l_geography_type_rec.geography_type_name := p_geography_type_rec.geography_type_name;
45: l_geography_type_rec.created_by_module := p_geography_type_rec.created_by_module;
44: l_geography_type_rec.geography_type_name := p_geography_type_rec.geography_type_name;
45: l_geography_type_rec.created_by_module := p_geography_type_rec.created_by_module;
46: l_geography_type_rec.application_id := p_geography_type_rec.application_id;
47:
48: HZ_GEOGRAPHY_STRUCTURE_PUB.create_geography_type (
49: p_init_msg_list => p_init_msg_list,
50: p_geography_type_rec => l_geography_type_rec,
51: x_return_status => x_return_status,
52: x_msg_count => x_msg_count,
92: x_return_status OUT NOCOPY VARCHAR2,
93: x_msg_count OUT NOCOPY NUMBER,
94: x_msg_data OUT NOCOPY VARCHAR2
95: ) AS
96: l_geo_structure_rec HZ_GEOGRAPHY_STRUCTURE_PUB.GEO_STRUCTURE_REC_TYPE;
97: BEGIN
98:
99: l_geo_structure_rec.geography_id := p_geo_structure_rec.geography_id;
100: l_geo_structure_rec.geography_type := p_geo_structure_rec.geography_type;
101: l_geo_structure_rec.parent_geography_type:= p_geo_structure_rec.parent_geography_type;
102: l_geo_structure_rec.created_by_module := p_geo_structure_rec.created_by_module;
103: l_geo_structure_rec.application_id := p_geo_structure_rec.application_id;
104:
105: HZ_GEOGRAPHY_STRUCTURE_PUB.create_geo_structure(
106: p_init_msg_list => p_init_msg_list,
107: p_geo_structure_rec => l_geo_structure_rec,
108: x_return_status => x_return_status,
109: x_msg_count => x_msg_count,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2
155: ) AS
156: BEGIN
157: HZ_GEOGRAPHY_STRUCTURE_PUB.delete_geo_structure(
158: p_init_msg_list => p_init_msg_list,
159: p_geography_id => p_geography_id,
160: p_geography_type => p_geography_type,
161: p_parent_geography_type => p_parent_geography_type,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2
205: )AS
206: l_geo_rel_type_rec HZ_GEOGRAPHY_STRUCTURE_PUB.GEO_REL_TYPE_REC_TYPE;
207: BEGIN
208: l_geo_rel_type_rec.geography_type := p_geo_rel_type_rec.geography_type ;
209: l_geo_rel_type_rec.parent_geography_type := p_geo_rel_type_rec.parent_geography_type ;
210: l_geo_rel_type_rec.status := p_geo_rel_type_rec.status ;
210: l_geo_rel_type_rec.status := p_geo_rel_type_rec.status ;
211: l_geo_rel_type_rec.created_by_module := p_geo_rel_type_rec.created_by_module ;
212: l_geo_rel_type_rec.application_id := p_geo_rel_type_rec.application_id ;
213:
214: HZ_GEOGRAPHY_STRUCTURE_PUB.create_geo_rel_type(
215: p_init_msg_list => p_init_msg_list,
216: p_geo_rel_type_rec => l_geo_rel_type_rec,
217: x_relationship_type_id => x_relationship_type_id,
218: x_return_status => x_return_status,
260: x_return_status OUT NOCOPY VARCHAR2,
261: x_msg_count OUT NOCOPY NUMBER,
262: x_msg_data OUT NOCOPY VARCHAR2
263: )AS
264: l_zone_type_rec HZ_GEOGRAPHY_STRUCTURE_PUB.ZONE_TYPE_REC_TYPE;
265: BEGIN
266:
267: FOR i in 1 .. p_included_geography_type.count LOOP
268: l_zone_type_rec.included_geography_type(i) := p_included_geography_type(i);
275: l_zone_type_rec.postal_code_range_flag := p_zone_type_rec.postal_code_range_flag;
276: l_zone_type_rec.created_by_module := p_zone_type_rec.created_by_module;
277: l_zone_type_rec.application_id := p_zone_type_rec.application_id;
278:
279: HZ_GEOGRAPHY_STRUCTURE_PUB.create_zone_type(
280: p_init_msg_list => p_init_msg_list,
281: p_zone_type_rec => l_zone_type_rec,
282: x_return_status => x_return_status,
283: x_msg_count => x_msg_count,
328: x_return_status OUT NOCOPY VARCHAR2,
329: x_msg_count OUT NOCOPY NUMBER,
330: x_msg_data OUT NOCOPY VARCHAR2
331: )AS
332: l_zone_type_rec HZ_GEOGRAPHY_STRUCTURE_PUB.ZONE_TYPE_REC_TYPE;
333:
334: BEGIN
335: FOR i in 1 .. p_included_geography_type.count LOOP
336: l_zone_type_rec.included_geography_type(i) := p_included_geography_type(i);
343: l_zone_type_rec.postal_code_range_flag := p_zone_type_rec.postal_code_range_flag;
344: l_zone_type_rec.created_by_module := p_zone_type_rec.created_by_module;
345: l_zone_type_rec.application_id := p_zone_type_rec.application_id;
346:
347: HZ_GEOGRAPHY_STRUCTURE_PUB.update_zone_type(
348: p_init_msg_list => p_init_msg_list,
349: p_zone_type_rec => l_zone_type_rec,
350: p_object_version_number => p_object_version_number,
351: x_return_status => x_return_status,