APPS.AMS_SYNC_CALENDAR_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 25

   CURSOR c_get_delete_criteria IS
	SELECT  obj.CRITERIA_ID
		, obj.OBJECT_TYPE_CODE
		, obj.CUSTOM_SETUP_ID
		, obj.ACTIVITY_TYPE_CODE
		, obj.ACTIVITY_ID
		, obj.STATUS_ID
		, obj.PRIORITY_ID
		, obj.OBJECT_ID
		, obj.CRITERIA_START_DATE
		, obj.CRITERIA_END_DATE
		, obj.LAST_UPDATE_DATE
		, obj.CRITERIA_ENABLED
		, obj.CRITERIA_DELETED
	FROM ams_calendar_criteria obj
	WHERE (obj.CRITERIA_ENABLED = 'N'
	      OR obj.CRITERIA_DELETED = 'Y');

Line: 44

	SELECT  obj.CRITERIA_ID
		, obj.OBJECT_TYPE_CODE
		, obj.CUSTOM_SETUP_ID
		, obj.ACTIVITY_TYPE_CODE
		, obj.ACTIVITY_ID
		, obj.STATUS_ID
		, obj.PRIORITY_ID
		, obj.OBJECT_ID
		, obj.CRITERIA_START_DATE
		, obj.CRITERIA_END_DATE
		, obj.LAST_UPDATE_DATE
		, obj.CRITERIA_ENABLED
		, obj.CRITERIA_DELETED
	FROM ams_calendar_criteria obj
	WHERE (obj.CRITERIA_ENABLED = 'Y'
	      AND obj.CRITERIA_DELETED = 'N');

Line: 65

   OPEN c_get_delete_criteria;

Line: 67

	FETCH c_get_delete_criteria INTO l_get_criteria_rec;

Line: 68

	IF (c_get_delete_criteria%NOTFOUND) THEN
		l_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 70

		--CLOSE c_get_delete_criteria;

Line: 84

   CLOSE c_get_delete_criteria;

Line: 165

	SELECT MAX(ACTUAL_START_DATE)
	INTO l_inc_mode_start_date
	FROM FND_CONCURRENT_REQUESTS
	WHERE ( PROGRAM_APPLICATION_ID = '530'
		AND CONCURRENT_PROGRAM_ID = (SELECT CONCURRENT_PROGRAM_ID
				    FROM FND_CONCURRENT_PROGRAMS
				    WHERE CONCURRENT_PROGRAM_NAME = 'AMSSYNCCAL')
		AND STATUS_CODE = 'C'
		AND PHASE_CODE = 'C' );

Line: 199

	l_cal_pvt_rec.CRITERIA_DELETED		:= x_criteria_rec.CRITERIA_DELETED;

Line: 204

	IF ((l_inc_mode_start_date is not NULL) AND (x_criteria_rec.LAST_UPDATE_DATE >= l_inc_mode_start_date)) THEN
		IF (x_remove_only = 'Y') THEN
			AMS_Sync_Calendar_PVT.Sync_Cal_Items( x_remove_only => FND_API.G_True
							    , x_return_status => x_return_status
							    , x_msg_count => x_msg_count
							    , x_msg_data => x_msg_data
							    , x_criteria_rec => l_cal_pvt_rec
							    );

Line: 223

		     (x_full_mode = 'Y' AND x_criteria_rec.LAST_UPDATE_DATE < l_inc_mode_start_date)
		   ) THEN
			IF (x_remove_only = 'Y') THEN
				AMS_Sync_Calendar_PVT.Sync_Cal_Items( x_remove_only => FND_API.G_True
								    , x_return_status => x_return_status
								    , x_msg_count => x_msg_count
								    , x_msg_data => x_msg_data
								    , x_criteria_rec => l_cal_pvt_rec
								    );

Line: 245

	-- compare in the ams_calendar_criteria. Using last_update_date is not correct. As of today
	-- it will always be full mode. Also x_remove_only is T or F and not Y/N

			IF (x_remove_only = FND_API.G_TRUE) THEN
				AMS_Sync_Calendar_PVT.Sync_Cal_Items( x_remove_only => FND_API.G_True
								    , x_return_status => x_return_status
								    , x_msg_count => x_msg_count
								    , x_msg_data => x_msg_data
								    , x_criteria_rec => l_cal_pvt_rec
								    );