[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
* PROCEDURE update_relationship
*
* DESCRIPTION
* Updates Geography Relationships.
*
* 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_master_relation_rec Geography type record.
* p_object_version_number Object version number of the row
* 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-20-2005 Kate Shan o Created.
*
*/
PROCEDURE update_relationship (
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_relationship_id IN NUMBER,
p_status IN VARCHAR2,
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
) IS
BEGIN
HZ_GEOGRAPHY_PUB.update_relationship(
p_init_msg_list => p_init_msg_list,
p_relationship_id => p_relationship_id,
p_status => p_status,
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 );
END update_relationship;
* PROCEDURE update_geo_identifier
*
* DESCRIPTION
* Creates Geography Identifiers.
*
* 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_identifier_rec Geo_identifier type record.
*
* IN/OUT:
* p_object_version_number
* OUT:
* x_cp_request_id Concurrent Program Request Id,whenever CP
* to update denormalized data gets kicked off.
* 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-20-2005 Kate Shan o Created.
* 26-OCT-2005 Idris Ali o Bug 4578867 Added parameter x_cp_request_id.
*
*/
PROCEDURE update_geo_identifier (
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_geo_identifier_rec IN GEO_IDENTIFIER_REC_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_cp_request_id OUT NOCOPY NUMBER, --Bug 4578867
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) IS
l_geo_identifier_rec HZ_GEOGRAPHY_PUB.GEO_IDENTIFIER_REC_TYPE;
HZ_GEOGRAPHY_PUB.update_geo_identifier (
p_init_msg_list => p_init_msg_list,
p_geo_identifier_rec => l_geo_identifier_rec,
p_object_version_number => p_object_version_number,
x_cp_request_id => x_cp_request_id, --Bug 4578867
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
END update_geo_identifier;
* PROCEDURE delete_geo_identifier
*
* DESCRIPTION
* Deletes Geography Identifiers.
*
* 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_geography_id geography id
* p_identifier_type
* p_identifier_subtype
* p_identifier_value
*
* 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-20-2005 Kate Shan o Created.
*
*/
PROCEDURE delete_geo_identifier(
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_geography_id IN NUMBER,
p_identifier_type IN VARCHAR2,
p_identifier_subtype IN VARCHAR2,
p_identifier_value IN VARCHAR2,
p_language_code IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) IS
BEGIN
HZ_GEOGRAPHY_PUB.delete_geo_identifier(
p_init_msg_list => p_init_msg_list,
p_geography_id => p_geography_id,
p_identifier_type => p_identifier_type,
p_identifier_subtype => p_identifier_subtype,
p_identifier_value => p_identifier_value,
p_language_code => p_language_code,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
END delete_geo_identifier;
* PROCEDURE update_geography
*
* DESCRIPTION
* Updates Geography
*
* 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_master_geography_rec Master Geography type record.
*
* IN/OUT:
* p_object_version_number
* 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-20-2005 Kate Shan o Created.
*
*/
PROCEDURE update_geography (
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_geography_id IN NUMBER,
p_end_date IN DATE,
p_timezone_code IN VARCHAR2,
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
) IS
BEGIN
HZ_GEOGRAPHY_PUB.update_geography (
p_init_msg_list => p_init_msg_list,
p_geography_id => p_geography_id,
p_end_date => p_end_date,
p_geometry => null,
p_timezone_code => p_timezone_code,
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
);
END update_geography;
* PROCEDURE update_geography_range
*
* DESCRIPTION
* Updates Geography range
*
* 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.
* geography_id
* geography_from
* start_date
* end_date
*
* IN/OUT:
* p_object_version_number
* 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-20-2005 Kate Shan o Created.
*
*/
PROCEDURE update_geography_range (
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_geography_id IN NUMBER,
p_geography_from IN VARCHAR2,
p_start_date IN DATE,
p_end_date IN DATE,
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
) IS
BEGIN
HZ_GEOGRAPHY_PUB.update_geography_range(
p_init_msg_list => p_init_msg_list,
p_geography_id => p_geography_id,
p_geography_from => p_geography_from,
p_start_date => p_start_date,
p_end_date => p_end_date,
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
);
END update_geography_range;