DBA Data[Home] [Help]

APPS.AMS_CAMP_SCHEDULE_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_B_PKG

Line 410: -- Invoke table handler(AMS_CAMPAIGN_SCHEDULES_B_PKG.Insert_Row)

406:
407: -- Debug Message
408: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler source :'||p_schedule_rec.source_code); END IF;
409:
410: -- Invoke table handler(AMS_CAMPAIGN_SCHEDULES_B_PKG.Insert_Row)
411: AMS_CAMPAIGN_SCHEDULES_B_PKG.Insert_Row(
412: px_schedule_id => l_schedule_id,
413: -- modified by soagrawa on 12-jun-2002 for ATT bug# 2376329
414: p_last_update_date => SYSDATE,

Line 411: AMS_CAMPAIGN_SCHEDULES_B_PKG.Insert_Row(

407: -- Debug Message
408: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler source :'||p_schedule_rec.source_code); END IF;
409:
410: -- Invoke table handler(AMS_CAMPAIGN_SCHEDULES_B_PKG.Insert_Row)
411: AMS_CAMPAIGN_SCHEDULES_B_PKG.Insert_Row(
412: px_schedule_id => l_schedule_id,
413: -- modified by soagrawa on 12-jun-2002 for ATT bug# 2376329
414: p_last_update_date => SYSDATE,
415: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 1202: -- Invoke table handler(AMS_CAMPAIGN_SCHEDULES_B_PKG.Update_Row)

1198:
1199: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler sched : '||to_char(p_schedule_rec.schedule_id));
1200: END IF;
1201:
1202: -- Invoke table handler(AMS_CAMPAIGN_SCHEDULES_B_PKG.Update_Row)
1203: AMS_CAMPAIGN_SCHEDULES_B_PKG.Update_Row(
1204: p_schedule_id => p_schedule_rec.schedule_id,
1205: p_last_update_date => SYSDATE,
1206: p_last_updated_by => G_USER_ID,

Line 1203: AMS_CAMPAIGN_SCHEDULES_B_PKG.Update_Row(

1199: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler sched : '||to_char(p_schedule_rec.schedule_id));
1200: END IF;
1201:
1202: -- Invoke table handler(AMS_CAMPAIGN_SCHEDULES_B_PKG.Update_Row)
1203: AMS_CAMPAIGN_SCHEDULES_B_PKG.Update_Row(
1204: p_schedule_id => p_schedule_rec.schedule_id,
1205: p_last_update_date => SYSDATE,
1206: p_last_updated_by => G_USER_ID,
1207: p_creation_date => SYSDATE,

Line 1540: -- Invoke table handler(AMS_CAMPAIGN_SCHEDULES_B_PKG.Delete_Row)

1536: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1537: END IF;
1538:
1539: -- Delete schedule only if the status is new.
1540: -- Invoke table handler(AMS_CAMPAIGN_SCHEDULES_B_PKG.Delete_Row)
1541: IF l_status_code = 'NEW' THEN
1542: AMS_CAMPAIGN_SCHEDULES_B_PKG.Delete_Row(p_schedule_id => p_schedule_id);
1543: ELSE
1544: UPDATE ams_campaign_schedules_b

Line 1542: AMS_CAMPAIGN_SCHEDULES_B_PKG.Delete_Row(p_schedule_id => p_schedule_id);

1538:
1539: -- Delete schedule only if the status is new.
1540: -- Invoke table handler(AMS_CAMPAIGN_SCHEDULES_B_PKG.Delete_Row)
1541: IF l_status_code = 'NEW' THEN
1542: AMS_CAMPAIGN_SCHEDULES_B_PKG.Delete_Row(p_schedule_id => p_schedule_id);
1543: ELSE
1544: UPDATE ams_campaign_schedules_b
1545: SET object_version_number = object_version_number + 1 ,
1546: active_flag = 'N'