APPS.IGS_EN_VAL_SCI SQL Statements

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

Line: 21

  		SELECT	census_dt_alias
  		FROM	IGS_GE_S_GEN_CAL_CON
  		WHERE	s_control_num = 1;

Line: 27

  		SELECT	cal_type,
  			ci_sequence_number
  		FROM	IGS_EN_SU_ATTEMPT
  		WHERE	person_id = cp_person_id AND
  			course_cd = cp_course_cd AND
  			unit_attempt_status NOT IN ('UNCONFIRM',
  						    'INVALID',
  						    'DISCONTIN');

Line: 39

  		SELECT	alias_val
  		FROM	IGS_CA_DA_INST_V
  		WHERE	cal_type 	   = cp_cal_type   AND
  			ci_sequence_number = cp_ci_seq_num AND
  			dt_alias	   = cp_dt_alias
  		ORDER BY alias_val;

Line: 62

  	-- selecting IGS_CA_TYPE and ci_sequence_number details
  	FOR v_sua_rec IN c_sua_details(p_person_id,
  				       p_course_cd) LOOP
  		-- looping backwards through the
  		-- student's unit attempt records
  		FOR v_daiv_rec IN c_daiv_details(v_sua_rec.cal_type,
  					         v_sua_rec.ci_sequence_number,
  				       	         v_census_date) LOOP
  			-- set the message number if the census
  			-- date is after the current date and the
  			-- intermssion start date is on or before
  			-- it, as intermission is not permitted
  			IF (SYSDATE > v_daiv_rec.alias_val AND
  			    p_start_dt <= v_daiv_rec.alias_val) THEN
  				p_message_name := 'IGS_EN_INTER_NOTBACK_DATED';

Line: 84

			Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');

Line: 105

  		SELECT 	course_attempt_status
  		FROM	IGS_EN_STDNT_PS_ATT
  		WHERE	person_id = p_person_id AND
  			course_cd = p_course_cd;

Line: 114

  	--	 'LAPSED', 'DELETED' 'COMPLETED'
  	p_message_name := null;

Line: 130

  	ELSIF (v_course_attempt_status = 'DELETED') THEN
  		p_message_name := 'IGS_EN_INTRM_NA_FOR_DELETED';

Line: 165

  		SELECT 	version_number
  		FROM	IGS_EN_STDNT_PS_ATT
  		WHERE	person_id = cp_person_id AND
  			course_cd = cp_course_cd;

Line: 172

  		SELECT 	intrmsn_allowed_ind,
  			num_of_units_before_intrmsn
  		FROM	IGS_PS_VER
  		WHERE	course_cd = cp_course_cd AND
  			version_number = cp_version_num;

Line: 180

  		SELECT 	count(*)
  		FROM	IGS_EN_SU_ATTEMPT
  		WHERE	person_id = cp_person_id AND
  			course_cd = cp_course_cd AND
  			unit_attempt_status = 'COMPLETED';

Line: 272

  		SELECT	max_intrmsn_duration
  		FROM	IGS_PS_VER
  		WHERE	course_cd = p_course_cd AND
  			version_number = p_version_number;

Line: 280

  	--- Select the maximum intermission from the students COURSE version
  	OPEN c_get_mid;

Line: 323

  		SELECT	start_dt,
  			end_dt
  		FROM	IGS_EN_STDNT_PS_INTM
  		WHERE	person_id = cp_person_id AND
  			course_cd = cp_course_cd AND
  			start_dt <> cp_start_dt AND
                        TRUNC(logical_delete_date) = to_date('31-12-4712','DD-MM-YYYY');

Line: 332

  	-- record being created or updated does not overlap with an
  	-- existing intermission record for the nominated
  	-- IGS_EN_STDNT_PS_ATT
  	p_message_name := null;