APPS.AMS_SYNC_CALENDAR_PVT dependencies on AMS_EVENT_OFFERS_ALL_B

Line 45: --BugFix 4256877 ams_event_offers_vl to ams_event_offers_all_b

41: )
42: );
43: l_get_delete_csch_id_rec c_get_delete_csch_ids%ROWTYPE;
44:
45: --BugFix 4256877 ams_event_offers_vl to ams_event_offers_all_b
46:
47: CURSOR c_get_delete_eveo_ids (x_criteria_rec cal_criteria_rec) IS
48: SELECT obj.EVENT_OFFER_ID
49: FROM ams_event_offers_all_b obj, jtf_cal_items_b cal

Line 49: FROM ams_event_offers_all_b obj, jtf_cal_items_b cal

45: --BugFix 4256877 ams_event_offers_vl to ams_event_offers_all_b
46:
47: CURSOR c_get_delete_eveo_ids (x_criteria_rec cal_criteria_rec) IS
48: SELECT obj.EVENT_OFFER_ID
49: FROM ams_event_offers_all_b obj, jtf_cal_items_b cal
50: WHERE (obj.SETUP_TYPE_ID = DECODE(x_criteria_rec.CUSTOM_SETUP_ID, NULL, obj.SETUP_TYPE_ID, x_criteria_rec.CUSTOM_SETUP_ID)
51: AND obj.event_offer_id = cal.source_id
52: AND (cal.source_code = 'AMS_EVEO' or cal.source_code = 'AMS_EONE')
53: AND obj.EVENT_TYPE_CODE = DECODE(x_criteria_rec.ACTIVITY_TYPE_CODE, NULL, obj.EVENT_TYPE_CODE, x_criteria_rec.ACTIVITY_TYPE_CODE)

Line 255: FROM ams_event_offers_all_b obj

251: , obj.CREATION_DATE
252: , obj.LAST_UPDATED_BY
253: , obj.LAST_UPDATE_DATE
254: , obj.LAST_UPDATE_LOGIN
255: FROM ams_event_offers_all_b obj
256: WHERE (obj.SETUP_TYPE_ID = DECODE(x_criteria_rec.CUSTOM_SETUP_ID, NULL, obj.SETUP_TYPE_ID, x_criteria_rec.CUSTOM_SETUP_ID)
257: AND obj.EVENT_TYPE_CODE = DECODE(x_criteria_rec.ACTIVITY_TYPE_CODE, NULL, obj.EVENT_TYPE_CODE, x_criteria_rec.ACTIVITY_TYPE_CODE)
258: AND obj.USER_STATUS_ID = DECODE(x_criteria_rec.STATUS_ID, NULL, obj.USER_STATUS_ID, x_criteria_rec.STATUS_ID)
259: AND obj.EVENT_OFFER_ID = DECODE(x_criteria_rec.OBJECT_ID, NULL, obj.EVENT_OFFER_ID, x_criteria_rec.OBJECT_ID)

Line 558: FROM ams_event_offers_all_b obj, JTF_CAL_ITEMS_B cal

554: , obj.CREATION_DATE
555: , obj.LAST_UPDATED_BY
556: , obj.LAST_UPDATE_DATE
557: , obj.LAST_UPDATE_LOGIN
558: FROM ams_event_offers_all_b obj, JTF_CAL_ITEMS_B cal
559: WHERE (obj.SETUP_TYPE_ID = DECODE(x_criteria_rec.CUSTOM_SETUP_ID, NULL, obj.SETUP_TYPE_ID, x_criteria_rec.CUSTOM_SETUP_ID)
560: AND (cal.source_code = 'AMS_EVEO' OR cal.source_code = 'AMS_EONE')
561: AND cal.source_id = obj.EVENT_OFFER_ID
562: AND ( cal.start_date <> obj.EVENT_START_DATE_TIME

Line 632: FROM JTF_CAL_ITEMS_B jcal, ams_event_offers_all_b aevent

628: l_get_cal_item_rec c_get_cal_item_id%ROWTYPE;
629:
630: CURSOR c_get_e_cal_item_id (l_source_id NUMBER, l_resource_id NUMBER) IS
631: SELECT cal_item_id, resource_id, source_id, jcal.object_version_number
632: FROM JTF_CAL_ITEMS_B jcal, ams_event_offers_all_b aevent
633: where aevent.event_offer_id = jcal.source_id and jcal.source_id = l_source_id and jcal.resource_id = l_resource_id ;
634:
635: l_get_e_cal_item_rec c_get_e_cal_item_id%ROWTYPE;
636:

Line 903: FROM ams_event_offers_all_b obj, JTF_CAL_ITEMS_B cal

899:
900: CURSOR c_get_del_eveo_items (x_criteria_rec cal_criteria_rec) IS
901: SELECT cal.cal_item_id
902: , cal.object_version_number
903: FROM ams_event_offers_all_b obj, JTF_CAL_ITEMS_B cal
904: WHERE (obj.SETUP_TYPE_ID = DECODE(x_criteria_rec.CUSTOM_SETUP_ID, NULL, obj.SETUP_TYPE_ID, x_criteria_rec.CUSTOM_SETUP_ID)
905: AND obj.EVENT_TYPE_CODE = DECODE(x_criteria_rec.ACTIVITY_TYPE_CODE, NULL, obj.EVENT_TYPE_CODE, x_criteria_rec.ACTIVITY_TYPE_CODE)
906: AND obj.USER_STATUS_ID = DECODE(x_criteria_rec.STATUS_ID, NULL, obj.USER_STATUS_ID, x_criteria_rec.STATUS_ID)
907: AND obj.EVENT_OFFER_ID = DECODE(x_criteria_rec.OBJECT_ID, NULL, obj.EVENT_OFFER_ID, x_criteria_rec.OBJECT_ID)