APPS.AMS_VENUE_RATES_PVT dependencies on AMS_VENUE_RATES_B

Line 54: SELECT AMS_VENUE_RATES_B_s.NEXTVAL

50: l_dummy NUMBER;
51: l_venue_rates_rec AMS_Venue_Rates_PVT.venue_rates_rec_type := p_venue_rates_rec;
52:
53: CURSOR c_id IS
54: SELECT AMS_VENUE_RATES_B_s.NEXTVAL
55: FROM dual;
56:
57: CURSOR c_id_exists (l_id IN NUMBER) IS
58: SELECT 1

Line 59: FROM AMS_VENUE_RATES_B

55: FROM dual;
56:
57: CURSOR c_id_exists (l_id IN NUMBER) IS
58: SELECT 1
59: FROM AMS_VENUE_RATES_B
60: WHERE RATE_ID = l_id;
61:
62: BEGIN
63: -- Standard Start of API savepoint

Line 160: -- Invoke table handler(AMS_VENUE_RATES_B_PKG.Insert_Row)

156:
157: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
158: END IF;
159:
160: -- Invoke table handler(AMS_VENUE_RATES_B_PKG.Insert_Row)
161: AMS_VENUE_RATES_B_PKG.Insert_Row(
162: px_rate_id => l_rate_id,
163: p_last_update_date => SYSDATE,
164: p_last_updated_by => G_USER_ID,

Line 161: AMS_VENUE_RATES_B_PKG.Insert_Row(

157: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
158: END IF;
159:
160: -- Invoke table handler(AMS_VENUE_RATES_B_PKG.Insert_Row)
161: AMS_VENUE_RATES_B_PKG.Insert_Row(
162: px_rate_id => l_rate_id,
163: p_last_update_date => SYSDATE,
164: p_last_updated_by => G_USER_ID,
165: p_creation_date => SYSDATE,

Line 282: FROM AMS_VENUE_RATES_B;

278: IS
279:
280: CURSOR c_get_venue_rates(rate_id NUMBER) IS
281: SELECT *
282: FROM AMS_VENUE_RATES_B;
283: -- Hint: Developer need to provide Where clause
284:
285: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Venue_Rates';
286: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;

Line 394: -- Invoke table handler(AMS_VENUE_RATES_B_PKG.Update_Row)

390:
391: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
392: END IF;
393:
394: -- Invoke table handler(AMS_VENUE_RATES_B_PKG.Update_Row)
395: AMS_VENUE_RATES_B_PKG.Update_Row(
396: p_rate_id => p_venue_rates_rec.rate_id,
397: p_last_update_date => SYSDATE,
398: p_last_updated_by => G_USER_ID,

Line 395: AMS_VENUE_RATES_B_PKG.Update_Row(

391: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
392: END IF;
393:
394: -- Invoke table handler(AMS_VENUE_RATES_B_PKG.Update_Row)
395: AMS_VENUE_RATES_B_PKG.Update_Row(
396: p_rate_id => p_venue_rates_rec.rate_id,
397: p_last_update_date => SYSDATE,
398: p_last_updated_by => G_USER_ID,
399: p_creation_date => SYSDATE,

Line 551: -- Invoke table handler(AMS_VENUE_RATES_B_PKG.Delete_Row)

547:
548: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
549: END IF;
550:
551: -- Invoke table handler(AMS_VENUE_RATES_B_PKG.Delete_Row)
552: AMS_VENUE_RATES_B_PKG.Delete_Row(
553: p_RATE_ID => p_RATE_ID);
554: --
555: -- End of API body

Line 552: AMS_VENUE_RATES_B_PKG.Delete_Row(

548: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
549: END IF;
550:
551: -- Invoke table handler(AMS_VENUE_RATES_B_PKG.Delete_Row)
552: AMS_VENUE_RATES_B_PKG.Delete_Row(
553: p_RATE_ID => p_RATE_ID);
554: --
555: -- End of API body
556: --

Line 640: FROM AMS_VENUE_RATES_B

636: l_RATE_ID NUMBER;
637:
638: CURSOR c_Venue_Rates IS
639: SELECT RATE_ID
640: FROM AMS_VENUE_RATES_B
641: WHERE RATE_ID = p_RATE_ID
642: AND object_version_number = p_object_version
643: FOR UPDATE NOWAIT;
644:

Line 759: 'AMS_VENUE_RATES_B',

755: BEGIN
756: x_return_status := FND_API.g_ret_sts_success;
757: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
758: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
759: 'AMS_VENUE_RATES_B',
760: 'RATE_ID = ''' || p_venue_rates_rec.RATE_ID ||''''
761: );
762: ELSE
763: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 764: 'AMS_VENUE_RATES_B',

760: 'RATE_ID = ''' || p_venue_rates_rec.RATE_ID ||''''
761: );
762: ELSE
763: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
764: 'AMS_VENUE_RATES_B',
765: 'RATE_ID = ''' || p_venue_rates_rec.RATE_ID ||
766: ''' AND RATE_ID <> ' || p_venue_rates_rec.RATE_ID
767: );
768: END IF;

Line 1082: FROM ams_venue_rates_b

1078: l_return_status VARCHAR2(1);
1079:
1080: CURSOR c_complete IS
1081: SELECT *
1082: FROM ams_venue_rates_b
1083: WHERE rate_id = p_venue_rates_rec.rate_id;
1084: l_venue_rates_rec c_complete%ROWTYPE;
1085: BEGIN
1086: x_complete_rec := p_venue_rates_rec;