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,
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,
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,
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,
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
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: --