APPS.AMS_SYNC_CALENDAR_PUB dependencies on AMS_CALENDAR_CRITERIA

Line 39: FROM ams_calendar_criteria obj

35: , obj.CRITERIA_END_DATE
36: , obj.LAST_UPDATE_DATE
37: , obj.CRITERIA_ENABLED
38: , obj.CRITERIA_DELETED
39: FROM ams_calendar_criteria obj
40: WHERE (obj.CRITERIA_ENABLED = 'N'
41: OR obj.CRITERIA_DELETED = 'Y');
42:
43: CURSOR c_get_create_criteria IS

Line 57: FROM ams_calendar_criteria obj

53: , obj.CRITERIA_END_DATE
54: , obj.LAST_UPDATE_DATE
55: , obj.CRITERIA_ENABLED
56: , obj.CRITERIA_DELETED
57: FROM ams_calendar_criteria obj
58: WHERE (obj.CRITERIA_ENABLED = 'Y'
59: AND obj.CRITERIA_DELETED = 'N');
60:
61: l_get_criteria_rec ams_criteria_rec;

Line 245: -- compare in the ams_calendar_criteria. Using last_update_date is not correct. As of today

241: END IF;
242: */
243:
244: -- Bug Fix for 3568819. There is no sense in the Full Mode Logic as there is no dates to
245: -- compare in the ams_calendar_criteria. Using last_update_date is not correct. As of today
246: -- it will always be full mode. Also x_remove_only is T or F and not Y/N
247:
248: IF (x_remove_only = FND_API.G_TRUE) THEN
249: AMS_Sync_Calendar_PVT.Sync_Cal_Items( x_remove_only => FND_API.G_True