APPS.AMS_ACTIVATE_EVENTSCHED_PVT dependencies on AMS_EVENT_OFFERS_ALL_B

Line 38: FROM ams_event_offers_all_b offr, ams_event_headers_all_b hdr

34: IS
35:
36: CURSOR c_all_schedule IS
37: SELECT offr.event_offer_id, offr.object_version_number,offr.event_level,offr.parent_id
38: FROM ams_event_offers_all_b offr, ams_event_headers_all_b hdr
39: WHERE offr.system_status_code = 'AVAILABLE'
40: --AND offr.reg_required_flag = 'Y'
41: --AND offr.reg_start_date <= SYSDATE
42: AND offr.event_header_id = hdr.event_header_id

Line 48: FROM ams_event_offers_all_b

44: -- AND offr.event_offer_id in (10136,10147);
45:
46: CURSOR c_all_oneoffevent IS
47: SELECT event_offer_id, object_version_number, parent_id,event_level
48: FROM ams_event_offers_all_b
49: WHERE system_status_code = 'AVAILABLE'
50: --AND reg_required_flag = 'Y'
51: --AND reg_start_date <= SYSDATE
52: AND event_header_id IS NULL

Line 59: FROM ams_event_offers_all_b

55:
56:
57: /* CURSOR c_completed_schedule IS
58: SELECT event_offer_id, object_version_number,event_level
59: FROM ams_event_offers_all_b
60: WHERE system_status_code = 'ACTIVE'
61: AND event_end_date <= SYSDATE
62: AND nvl(parent_type, 'RCAM') <> 'CAMP';*/
63: -- AND event_offer_id = 10134;

Line 70: FROM ams_event_offers_all_b

66:
67: --Will convert the sysdate to the user timezone
68: CURSOR c_completed_schedule_convdate(l_conv_sysdate DATE) IS
69: SELECT event_offer_id, object_version_number,event_level
70: FROM ams_event_offers_all_b
71: WHERE system_status_code = 'ACTIVE'
72: AND event_end_date <= l_conv_sysdate
73: AND nvl(parent_type, 'RCAM') <> 'CAMP';
74: --End Adding

Line 179: /* UPDATE ams_event_offers_all_b

175: FETCH c_all_schedule INTO l_schedule_id, l_obj_version,l_event_level,l_parent_id ;
176: EXIT WHEN c_all_schedule%NOTFOUND ;
177:
178: -- Update the status of the schedule to Active.
179: /* UPDATE ams_event_offers_all_b
180: SET system_status_code = 'ACTIVE',
181: last_status_date = SYSDATE ,
182: user_status_id = l_status_id,
183: object_version_number = l_obj_version + 1

Line 270: /* UPDATE ams_event_offers_all_b

266:
267: IF l_parent_system_status_code = 'ACTIVE' OR l_parent_id IS NULL THEN
268:
269: -- Update the status of the oneoffevent to Active.
270: /* UPDATE ams_event_offers_all_b
271: SET system_status_code = 'ACTIVE',
272: last_status_date = SYSDATE ,
273: user_status_id = l_status_id,
274: object_version_number = l_obj_version + 1