eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_SYNC_CALENDAR_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 21: FROM AMS_CAMPAIGN_SCHEDULES_B obj, AMS_CAMPAIGNS_ALL_B b, JTF_CAL_ITEMS_B cal

17: )
18: IS
19: CURSOR c_get_delete_csch_ids (x_criteria_rec cal_criteria_rec) IS
20: SELECT obj.SCHEDULE_ID
21: FROM AMS_CAMPAIGN_SCHEDULES_B obj, AMS_CAMPAIGNS_ALL_B b, JTF_CAL_ITEMS_B cal
22: WHERE (obj.CUSTOM_SETUP_ID = DECODE(x_criteria_rec.CUSTOM_SETUP_ID, NULL, obj.CUSTOM_SETUP_ID, x_criteria_rec.CUSTOM_SETUP_ID)
23: AND obj.schedule_id = cal.source_id
24: AND cal.source_code = 'AMS_CSCH'
25: AND obj.ACTIVITY_TYPE_CODE = DECODE(x_criteria_rec.ACTIVITY_TYPE_CODE, NULL, obj.ACTIVITY_TYPE_CODE, x_criteria_rec.ACTIVITY_TYPE_CODE)

Line 214: FROM AMS_CAMPAIGN_SCHEDULES_B obj, AMS_CAMPAIGNS_ALL_B b

210: , obj.CREATION_DATE
211: , obj.LAST_UPDATED_BY
212: , obj.LAST_UPDATE_DATE
213: , obj.LAST_UPDATE_LOGIN
214: FROM AMS_CAMPAIGN_SCHEDULES_B obj, AMS_CAMPAIGNS_ALL_B b
215: WHERE (obj.CUSTOM_SETUP_ID = DECODE(x_criteria_rec.CUSTOM_SETUP_ID, NULL, obj.CUSTOM_SETUP_ID, x_criteria_rec.CUSTOM_SETUP_ID)
216: AND obj.ACTIVITY_TYPE_CODE = DECODE(x_criteria_rec.ACTIVITY_TYPE_CODE, NULL, obj.ACTIVITY_TYPE_CODE, x_criteria_rec.ACTIVITY_TYPE_CODE)
217: AND DECODE(x_criteria_rec.ACTIVITY_ID,NULL,-9999,obj.ACTIVITY_ID) = DECODE(x_criteria_rec.ACTIVITY_ID, NULL, -9999, x_criteria_rec.ACTIVITY_ID)
218: AND obj.USER_STATUS_ID = DECODE(x_criteria_rec.STATUS_ID, NULL, obj.USER_STATUS_ID, x_criteria_rec.STATUS_ID)

Line 517: FROM AMS_CAMPAIGN_SCHEDULES_B obj, AMS_CAMPAIGNS_ALL_B b, JTF_CAL_ITEMS_B cal

513: , obj.CREATION_DATE
514: , obj.LAST_UPDATED_BY
515: , obj.LAST_UPDATE_DATE
516: , obj.LAST_UPDATE_LOGIN
517: FROM AMS_CAMPAIGN_SCHEDULES_B obj, AMS_CAMPAIGNS_ALL_B b, JTF_CAL_ITEMS_B cal
518: WHERE (obj.CUSTOM_SETUP_ID = DECODE(x_criteria_rec.CUSTOM_SETUP_ID, NULL, obj.CUSTOM_SETUP_ID, x_criteria_rec.CUSTOM_SETUP_ID)
519: AND cal.source_code = 'AMS_CSCH'
520: AND cal.source_id = obj.SCHEDULE_ID
521: AND ( cal.start_date <> obj.START_DATE_TIME

Line 625: FROM JTF_CAL_ITEMS_B jcal, ams_campaign_schedules_b camp

621: l_cal_obj_ver_number NUMBER;
622: --BugFix 4676786 sikalyan
623: CURSOR c_get_cal_item_id (l_source_id NUMBER, l_resource_id NUMBER) IS
624: SELECT cal_item_id, resource_id, source_id, jcal.object_version_number
625: FROM JTF_CAL_ITEMS_B jcal, ams_campaign_schedules_b camp
626: where camp.schedule_id = jcal.source_id and jcal.source_id = l_source_id and jcal.resource_id = l_resource_id ;
627:
628: l_get_cal_item_rec c_get_cal_item_id%ROWTYPE;
629:

Line 878: FROM AMS_CAMPAIGN_SCHEDULES_B obj, JTF_CAL_ITEMS_B cal, AMS_CAMPAIGNS_ALL_B b

874:
875: CURSOR c_get_del_csch_items (x_criteria_rec cal_criteria_rec) IS
876: SELECT cal.cal_item_id
877: , cal.object_version_number
878: FROM AMS_CAMPAIGN_SCHEDULES_B obj, JTF_CAL_ITEMS_B cal, AMS_CAMPAIGNS_ALL_B b
879: WHERE (obj.CUSTOM_SETUP_ID = DECODE(x_criteria_rec.CUSTOM_SETUP_ID, NULL, obj.CUSTOM_SETUP_ID, x_criteria_rec.CUSTOM_SETUP_ID)
880: AND obj.ACTIVITY_TYPE_CODE = DECODE(x_criteria_rec.ACTIVITY_TYPE_CODE, NULL, obj.ACTIVITY_TYPE_CODE, x_criteria_rec.ACTIVITY_TYPE_CODE)
881: AND DECODE(x_criteria_rec.ACTIVITY_ID,NULL,-9999,obj.ACTIVITY_ID) = DECODE(x_criteria_rec.ACTIVITY_ID, NULL, -9999, x_criteria_rec.ACTIVITY_ID)
882: AND obj.USER_STATUS_ID = DECODE(x_criteria_rec.STATUS_ID, NULL, obj.USER_STATUS_ID, x_criteria_rec.STATUS_ID)