APPS.HZ_GEOGRAPHY_STRUCTURE_PUB dependencies on HZ_GEOGRAPHY_STRUCTURE_PUB

Line 1: PACKAGE BODY HZ_GEOGRAPHY_STRUCTURE_PUB AS

1: PACKAGE BODY HZ_GEOGRAPHY_STRUCTURE_PUB AS
2: /*$Header: ARHGSTSB.pls 120.21 2006/03/23 15:03:02 idali noship $ */
3:
4: -- Type declarations
5:

Line 1395: HZ_GEOGRAPHY_STRUCTURE_PUB.update_geo_rel_type(

1391: AND backward_rel_code = 'CHILD_OF'
1392: AND relationship_type = p_zone_type_rec.geography_use;
1393:
1394: IF l_rel_status = 'I' THEN
1395: HZ_GEOGRAPHY_STRUCTURE_PUB.update_geo_rel_type(
1396: p_init_msg_list => 'F',
1397: p_relationship_type_id => x_relationship_type_id,
1398: p_status => 'A',
1399: p_object_version_number => l_object_version_number,

Line 1414: HZ_GEOGRAPHY_STRUCTURE_PUB.create_geo_rel_type(

1410: -- create a relationship type with this geography type and included geography type
1411: l_geo_rel_type_rec.geography_type := p_zone_type_rec.included_geography_type(i);
1412: x_relationship_type_id := NULL;
1413:
1414: HZ_GEOGRAPHY_STRUCTURE_PUB.create_geo_rel_type(
1415: p_init_msg_list => 'F',
1416: p_geo_rel_type_rec => l_geo_rel_type_rec,
1417: x_relationship_type_id => x_relationship_type_id,
1418: x_return_status => x_return_status,

Line 1618: HZ_GEOGRAPHY_STRUCTURE_PUB.update_geo_rel_type(

1614: AND backward_rel_code = 'CHILD_OF'
1615: AND relationship_type = p_zone_type_rec.geography_use;
1616:
1617: IF l_rel_status = 'I' THEN
1618: HZ_GEOGRAPHY_STRUCTURE_PUB.update_geo_rel_type(
1619: p_init_msg_list => 'F',
1620: p_relationship_type_id => x_relationship_type_id,
1621: p_status => 'A',
1622: p_object_version_number => l_object_version_number,

Line 1638: HZ_GEOGRAPHY_STRUCTURE_PUB.create_geo_rel_type(

1634: l_geo_rel_type_rec.geography_type := p_zone_type_rec.included_geography_type(i);
1635: x_relationship_type_id := NULL;
1636: l_geo_rel_type_rec.status:= 'A';
1637:
1638: HZ_GEOGRAPHY_STRUCTURE_PUB.create_geo_rel_type(
1639: p_init_msg_list => 'F',
1640: p_geo_rel_type_rec => l_geo_rel_type_rec,
1641: x_relationship_type_id => x_relationship_type_id,
1642: x_return_status => x_return_status,

Line 1668: HZ_GEOGRAPHY_STRUCTURE_PUB.update_geo_rel_type(

1664: exit;
1665: end if;
1666: END LOOP;
1667: if(removed) then
1668: HZ_GEOGRAPHY_STRUCTURE_PUB.update_geo_rel_type(
1669: p_init_msg_list => 'F',
1670: p_relationship_type_id => x_relationship_type_id,
1671: p_status => 'I',
1672: p_object_version_number => l_object_version_number,

Line 2558: END HZ_GEOGRAPHY_STRUCTURE_PUB;

2554: p_data => x_msg_data);
2555:
2556: END update_zone_type;
2557:
2558: END HZ_GEOGRAPHY_STRUCTURE_PUB;