APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_EVENT_OFFERS_ALL_B

Line 1372: -- FROM ams_event_offers_all_b

1368: -- WHERE event_header_id = p_channel_id;
1369: --
1370: -- CURSOR c_eveo IS
1371: -- SELECT event_type_code
1372: -- FROM ams_event_offers_all_b
1373: -- WHERE event_offer_id = p_channel_id;
1374:
1375: -- CURSOR c_camp_event IS
1376: -- SELECT 1

Line 3183: UPDATE ams_event_offers_all_b

3179:
3180: END IF;
3181: -- Not handling return_stauts here
3182:
3183: UPDATE ams_event_offers_all_b
3184: SET user_status_id = l_new_status_id,
3185: system_status_code = p_new_status_code,
3186: last_status_date = SYSDATE
3187: WHERE event_offer_id = l_related_event_id;

Line 3857: --dkailash update AMS_EVENT_OFFERS_ALL_B table for l_activity_type_code ='EVENTS' added for bug #11830352

3853: object_version_number = object_version_number + 1,
3854: last_update_date = SYSDATE,
3855: last_updated_by = FND_GLOBAL.user_id
3856: WHERE schedule_id = l_schedule_id ;
3857: --dkailash update AMS_EVENT_OFFERS_ALL_B table for l_activity_type_code ='EVENTS' added for bug #11830352
3858: IF (l_related_event_id IS NOT NULL and l_activity_type_code ='EVENTS')
3859: THEN
3860: l_event_status_id := AMS_Utility_PVT.get_default_user_status('AMS_EVENT_STATUS','ACTIVE');
3861:

Line 3862: UPDATE AMS_EVENT_OFFERS_ALL_B

3858: IF (l_related_event_id IS NOT NULL and l_activity_type_code ='EVENTS')
3859: THEN
3860: l_event_status_id := AMS_Utility_PVT.get_default_user_status('AMS_EVENT_STATUS','ACTIVE');
3861:
3862: UPDATE AMS_EVENT_OFFERS_ALL_B
3863: SET SYSTEM_STATUS_CODE = 'ACTIVE',
3864: USER_STATUS_ID=l_event_status_id,
3865: LAST_STATUS_DATE=SYSDATE,
3866: OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1,