APPS.HZ_GEOGRAPHY_PUB dependencies on HZ_GEOGRAPHY_RANGES

Line 2485: /*SELECT count(*) INTO l_count from hz_geography_ranges

2481:
2482:
2483:
2484: -- check for the uniqueness
2485: /*SELECT count(*) INTO l_count from hz_geography_ranges
2486: WHERE geography_id = p_geography_range_rec.zone_id
2487: AND geography_from = p_geography_range_rec.geography_from
2488: AND to_char(start_date,'DD-MON-YYYY') = to_char(p_geography_range_rec.start_date,'DD_MON-YYYY');
2489:

Line 2518: hz_geography_ranges_pkg.insert_row (

2514: SELECT geography_use INTO l_geography_use
2515: FROM hz_geography_types_b
2516: WHERE geography_type=l_zone_type;
2517:
2518: hz_geography_ranges_pkg.insert_row (
2519: x_rowid => l_rowid,
2520: x_geography_id => p_geography_range_rec.zone_id,
2521: x_geography_from => p_geography_range_rec.geography_from,
2522: x_start_date => p_geography_range_rec.start_date,

Line 2595: FROM hz_geography_ranges

2591: -- check if the row exists
2592: BEGIN
2593:
2594: SELECT rowid,start_date,end_date,object_version_number INTO l_rowid,l_start_date,l_end_date,l_object_version_number
2595: FROM hz_geography_ranges
2596: WHERE geography_id = p_geography_id
2597: AND geography_from = p_geography_from
2598: AND start_date = p_start_date
2599: FOR UPDATE OF geography_id,geography_from,start_date NOWAIT;

Line 2604: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geography_ranges');

2600:
2601: --validate object_version_number
2602: IF l_object_version_number <> p_object_version_number THEN
2603: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2604: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geography_ranges');
2605: FND_MSG_PUB.ADD;
2606: RAISE FND_API.G_EXC_ERROR;
2607: ELSE
2608: p_object_version_number := l_object_version_number + 1;

Line 2637: HZ_GEOGRAPHY_RANGES_PKG.update_row(

2633: RAISE FND_API.G_EXC_ERROR;
2634: END IF;
2635:
2636: -- call table handler to update the row
2637: HZ_GEOGRAPHY_RANGES_PKG.update_row(
2638: x_rowid => l_rowid,
2639: x_geography_id => p_geography_id,
2640: x_geography_from => p_geography_from,
2641: x_start_date => p_start_date,

Line 4050: IF p_index_name = 'HZ_GEOGRAPHY_RANGES_U1' THEN

4046: WHEN DUP_VAL_ON_INDEX THEN
4047: ROLLBACK TO create_geography_range;
4048: x_return_status := FND_API.G_RET_STS_ERROR;
4049: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
4050: IF p_index_name = 'HZ_GEOGRAPHY_RANGES_U1' THEN
4051: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
4052: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_id,geography_from and start_date');
4053: FND_MSG_PUB.ADD;
4054: END IF;