The following lines contain the word 'select', 'insert', 'update' or 'delete':
* PROCEDURE delete_geo_structure
*
* DESCRIPTION
* Deletes the row in the structure. Disables the relationship_type if it is not used by any other structure.
*
* EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
*
* ARGUMENTS
* IN:
* p_init_msg_list Initialize message stack if it is set to
* FND_API.G_TRUE. Default is FND_API.G_FALSE.
* p_geo_structure_rec Geography structure type record.
* IN/OUT:
*
* OUT:
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
* x_msg_count Number of messages in message stack.
* x_msg_data Message text if x_msg_count is 1.
*
* NOTES
*
* MODIFICATION HISTORY
*
* 06-28-2005 Kate Shan o Created.
*
*/
PROCEDURE delete_geo_structure(
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_geography_id IN NUMBER,
p_geography_type IN VARCHAR2,
p_parent_geography_type IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) AS
BEGIN
HZ_GEOGRAPHY_STRUCTURE_PUB.delete_geo_structure(
p_init_msg_list => p_init_msg_list,
p_geography_id => p_geography_id,
p_geography_type => p_geography_type,
p_parent_geography_type => p_parent_geography_type,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
* PROCEDURE update_zone_type
*
* DESCRIPTION
* Updates zone type.
*
* EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
*
* ARGUMENTS
* IN:
* p_init_msg_list Initialize message stack if it is set to
* FND_API.G_TRUE. Default is FND_API.G_FALSE.
* p_geographytype Geography type.
* p_limited_by_geography_id
* p_postal_code_range_flag
* IN/OUT:
* p_object_version_number object version number of the row being updated
* OUT:
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
* x_msg_count Number of messages in message stack.
* x_msg_data Message text if x_msg_count is 1.
*
* NOTES
*
* MODIFICATION HISTORY
*
* 06-28-2005 Kate Shan o Created.
*
*/
PROCEDURE update_zone_type(
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_zone_type_rec IN ZONE_TYPE_REC_TYPE,
p_included_geography_type IN INCL_GEO_TYPE_TBL_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
)AS
l_zone_type_rec HZ_GEOGRAPHY_STRUCTURE_PUB.ZONE_TYPE_REC_TYPE;
HZ_GEOGRAPHY_STRUCTURE_PUB.update_zone_type(
p_init_msg_list => p_init_msg_list,
p_zone_type_rec => l_zone_type_rec,
p_object_version_number => p_object_version_number,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);