APPS.AMS_SCHEDULER_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 225: from ams_campaign_schedules_b

221:
222: -- soagrawa added on 21-apr-2004 for bug# 3570234
223: CURSOR c_max_sch_det(p_schedule_id NUMBER) IS
224: select schedule_id
225: from ams_campaign_schedules_b
226: where creation_date = (select max(creation_date)
227: from ams_campaign_schedules_b
228: where nvl(orig_csch_id, schedule_id) = p_schedule_id);
229:

Line 227: from ams_campaign_schedules_b

223: CURSOR c_max_sch_det(p_schedule_id NUMBER) IS
224: select schedule_id
225: from ams_campaign_schedules_b
226: where creation_date = (select max(creation_date)
227: from ams_campaign_schedules_b
228: where nvl(orig_csch_id, schedule_id) = p_schedule_id);
229:
230: l_tgrp_copy_from_csch_id NUMBER;
231:

Line 578: UPDATE AMS_CAMPAIGN_SCHEDULES_B

574: OPEN c_def_status('AVAILABLE');
575: FETCH c_def_status INTO l_def_avail_status;
576: CLOSE c_def_status;
577:
578: UPDATE AMS_CAMPAIGN_SCHEDULES_B
579: SET STATUS_CODE = 'AVAILABLE' ,
580: status_date = sysdate,
581: user_status_id = l_def_avail_status
582: WHERE SCHEDULE_ID = l_new_sched_id;