DBA Data[Home] [Help]

APPS.HZ_GEOGRAPHY_PUB_UIW dependencies on HZ_GEOGRAPHY_PUB

Line 1: PACKAGE BODY HZ_GEOGRAPHY_PUB_UIW AS

1: PACKAGE BODY HZ_GEOGRAPHY_PUB_UIW AS
2: /*$Header: ARHGEOWB.pls 120.1 2005/10/26 14:06:46 idali noship $ */
3:
4:
5: /**

Line 43: l_master_relation_rec HZ_GEOGRAPHY_PUB.MASTER_RELATION_REC_TYPE;

39: x_return_status OUT NOCOPY VARCHAR2,
40: x_msg_count OUT NOCOPY NUMBER,
41: x_msg_data OUT NOCOPY VARCHAR2
42: ) IS
43: l_master_relation_rec HZ_GEOGRAPHY_PUB.MASTER_RELATION_REC_TYPE;
44: BEGIN
45:
46: l_master_relation_rec.geography_id := p_master_relation_rec.geography_id;
47: l_master_relation_rec.parent_geography_id := p_master_relation_rec.parent_geography_id;

Line 53: HZ_GEOGRAPHY_PUB.create_master_relation (

49: l_master_relation_rec.end_date := p_master_relation_rec.end_date;
50: l_master_relation_rec.created_by_module := p_master_relation_rec.created_by_module;
51: l_master_relation_rec.application_id := p_master_relation_rec.application_id;
52:
53: HZ_GEOGRAPHY_PUB.create_master_relation (
54: p_init_msg_list => p_init_msg_list,
55: p_master_relation_rec => l_master_relation_rec,
56: x_relationship_id => x_relationship_id,
57: x_return_status => x_return_status,

Line 106: HZ_GEOGRAPHY_PUB.update_relationship(

102: x_msg_data OUT NOCOPY VARCHAR2
103: ) IS
104: BEGIN
105:
106: HZ_GEOGRAPHY_PUB.update_relationship(
107: p_init_msg_list => p_init_msg_list,
108: p_relationship_id => p_relationship_id,
109: p_status => p_status,
110: p_object_version_number => p_object_version_number,

Line 154: l_geo_identifier_rec HZ_GEOGRAPHY_PUB.GEO_IDENTIFIER_REC_TYPE;

150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2
153: ) IS
154: l_geo_identifier_rec HZ_GEOGRAPHY_PUB.GEO_IDENTIFIER_REC_TYPE;
155: BEGIN
156:
157: l_geo_identifier_rec.geography_id := p_geo_identifier_rec.geography_id;
158: l_geo_identifier_rec.identifier_subtype := p_geo_identifier_rec.identifier_subtype;

Line 168: HZ_GEOGRAPHY_PUB.create_geo_identifier(

164: l_geo_identifier_rec.created_by_module := p_geo_identifier_rec.created_by_module;
165: l_geo_identifier_rec.application_id := p_geo_identifier_rec.application_id;
166:
167:
168: HZ_GEOGRAPHY_PUB.create_geo_identifier(
169: p_init_msg_list => p_init_msg_list,
170: p_geo_identifier_rec => l_geo_identifier_rec,
171: x_return_status => x_return_status,
172: x_msg_count => x_msg_count,

Line 219: l_geo_identifier_rec HZ_GEOGRAPHY_PUB.GEO_IDENTIFIER_REC_TYPE;

215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2
218: ) IS
219: l_geo_identifier_rec HZ_GEOGRAPHY_PUB.GEO_IDENTIFIER_REC_TYPE;
220: BEGIN
221:
222: l_geo_identifier_rec.geography_id := p_geo_identifier_rec.geography_id;
223: l_geo_identifier_rec.identifier_subtype := p_geo_identifier_rec.identifier_subtype;

Line 235: HZ_GEOGRAPHY_PUB.update_geo_identifier (

231: l_geo_identifier_rec.new_identifier_subtype := p_geo_identifier_rec.new_identifier_subtype; -- Bug 4578867
232: l_geo_identifier_rec.new_identifier_value := p_geo_identifier_rec.new_identifier_value;
233:
234:
235: HZ_GEOGRAPHY_PUB.update_geo_identifier (
236: p_init_msg_list => p_init_msg_list,
237: p_geo_identifier_rec => l_geo_identifier_rec,
238: p_object_version_number => p_object_version_number,
239: x_cp_request_id => x_cp_request_id, --Bug 4578867

Line 292: HZ_GEOGRAPHY_PUB.delete_geo_identifier(

288: x_msg_count OUT NOCOPY NUMBER,
289: x_msg_data OUT NOCOPY VARCHAR2
290: ) IS
291: BEGIN
292: HZ_GEOGRAPHY_PUB.delete_geo_identifier(
293: p_init_msg_list => p_init_msg_list,
294: p_geography_id => p_geography_id,
295: p_identifier_type => p_identifier_type,
296: p_identifier_subtype => p_identifier_subtype,

Line 347: l_master_geography_rec HZ_GEOGRAPHY_PUB.MASTER_GEOGRAPHY_REC_TYPE;

343: x_return_status OUT NOCOPY VARCHAR2,
344: x_msg_count OUT NOCOPY NUMBER,
345: x_msg_data OUT NOCOPY VARCHAR2
346: ) IS
347: l_master_geography_rec HZ_GEOGRAPHY_PUB.MASTER_GEOGRAPHY_REC_TYPE;
348: l_parent_geography_id HZ_GEOGRAPHY_PUB.parent_geography_tbl_type;
349: BEGIN
350:
351: FOR i in 1 ..p_parent_geography_id.count LOOP

Line 348: l_parent_geography_id HZ_GEOGRAPHY_PUB.parent_geography_tbl_type;

344: x_msg_count OUT NOCOPY NUMBER,
345: x_msg_data OUT NOCOPY VARCHAR2
346: ) IS
347: l_master_geography_rec HZ_GEOGRAPHY_PUB.MASTER_GEOGRAPHY_REC_TYPE;
348: l_parent_geography_id HZ_GEOGRAPHY_PUB.parent_geography_tbl_type;
349: BEGIN
350:
351: FOR i in 1 ..p_parent_geography_id.count LOOP
352: l_parent_geography_id(i) := p_parent_geography_id(i);

Line 372: HZ_GEOGRAPHY_PUB.create_master_geography(

368: l_master_geography_rec.timezone_code := p_master_geography_rec.timezone_code;
369: l_master_geography_rec.created_by_module := p_master_geography_rec.created_by_module;
370: l_master_geography_rec.application_id := p_master_geography_rec.application_id;
371:
372: HZ_GEOGRAPHY_PUB.create_master_geography(
373: p_init_msg_list => p_init_msg_list,
374: p_master_geography_rec => l_master_geography_rec,
375: x_geography_id => x_geography_id,
376: x_return_status => x_return_status,

Line 426: HZ_GEOGRAPHY_PUB.update_geography (

422: x_msg_data OUT NOCOPY VARCHAR2
423: ) IS
424: BEGIN
425:
426: HZ_GEOGRAPHY_PUB.update_geography (
427: p_init_msg_list => p_init_msg_list,
428: p_geography_id => p_geography_id,
429: p_end_date => p_end_date,
430: p_geometry => null,

Line 477: l_geography_range_rec HZ_GEOGRAPHY_PUB.GEOGRAPHY_RANGE_REC_TYPE;

473: x_return_status OUT NOCOPY VARCHAR2,
474: x_msg_count OUT NOCOPY NUMBER,
475: x_msg_data OUT NOCOPY VARCHAR2
476: ) IS
477: l_geography_range_rec HZ_GEOGRAPHY_PUB.GEOGRAPHY_RANGE_REC_TYPE;
478: BEGIN
479:
480: l_geography_range_rec.zone_id := p_geography_range_rec.zone_id;
481: l_geography_range_rec.master_ref_geography_id := p_geography_range_rec.master_ref_geography_id;

Line 492: HZ_GEOGRAPHY_PUB.create_geography_range (

488: l_geography_range_rec.created_by_module := p_geography_range_rec.created_by_module;
489: l_geography_range_rec.application_id := p_geography_range_rec.application_id;
490:
491:
492: HZ_GEOGRAPHY_PUB.create_geography_range (
493: p_init_msg_list => p_init_msg_list,
494: p_geography_range_rec => l_geography_range_rec,
495: x_return_status => x_return_status,
496: x_msg_count => x_msg_count,

Line 549: HZ_GEOGRAPHY_PUB.update_geography_range(

545: x_msg_count OUT NOCOPY NUMBER,
546: x_msg_data OUT NOCOPY VARCHAR2
547: ) IS
548: BEGIN
549: HZ_GEOGRAPHY_PUB.update_geography_range(
550: p_init_msg_list => p_init_msg_list,
551: p_geography_id => p_geography_id,
552: p_geography_from => p_geography_from,
553: p_start_date => p_start_date,

Line 607: l_zone_relation_tbl HZ_GEOGRAPHY_PUB.ZONE_RELATION_TBL_TYPE;

603: x_return_status OUT NOCOPY VARCHAR2,
604: x_msg_count OUT NOCOPY NUMBER,
605: x_msg_data OUT NOCOPY VARCHAR2
606: ) IS
607: l_zone_relation_tbl HZ_GEOGRAPHY_PUB.ZONE_RELATION_TBL_TYPE;
608: BEGIN
609:
610: FOR i in 1 .. p_zone_relation_tbl.count LOOP
611: l_zone_relation_tbl(i).included_geography_id := p_zone_relation_tbl(i).included_geography_id;

Line 633: HZ_GEOGRAPHY_PUB.create_zone_relation(

629: END IF;
630:
631: END LOOP;
632:
633: HZ_GEOGRAPHY_PUB.create_zone_relation(
634: p_init_msg_list => p_init_msg_list,
635: p_geography_id => p_geography_id,
636: p_zone_relation_tbl => l_zone_relation_tbl,
637: p_created_by_module => p_created_by_module,

Line 709: l_zone_relation_tbl HZ_GEOGRAPHY_PUB.ZONE_RELATION_TBL_TYPE;

705: x_return_status OUT NOCOPY VARCHAR2,
706: x_msg_count OUT NOCOPY NUMBER,
707: x_msg_data OUT NOCOPY VARCHAR2
708: ) IS
709: l_zone_relation_tbl HZ_GEOGRAPHY_PUB.ZONE_RELATION_TBL_TYPE;
710: BEGIN
711:
712: FOR i in 1 .. p_zone_relation_tbl.count LOOP
713: l_zone_relation_tbl(i).included_geography_id := p_zone_relation_tbl(i).included_geography_id;

Line 732: HZ_GEOGRAPHY_PUB.create_zone(

728: l_zone_relation_tbl(i).end_date := p_zone_relation_tbl(i).end_date;
729: END IF;
730: END LOOP;
731:
732: HZ_GEOGRAPHY_PUB.create_zone(
733: p_init_msg_list => p_init_msg_list,
734: p_zone_type => p_zone_type,
735: p_zone_name => p_zone_name,
736: p_zone_code => p_zone_code,

Line 755: END HZ_GEOGRAPHY_PUB_UIW;

751: );
752: END create_zone;
753:
754:
755: END HZ_GEOGRAPHY_PUB_UIW;