APPS.IGS_AS_VAL_UAI SQL Statements

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

Line: 21

  		SELECT	COUNT(*)
  		FROM	IGS_AS_ASSESSMNT_ITM
  		WHERE	ass_id = cp_ass_id;

Line: 58

  		SELECT	closed_ind
  		FROM	IGS_AS_UNIT_MODE
  		WHERE	unit_mode = cp_unit_mode;

Line: 96

  		SELECT	closed_ind
  		FROM	IGS_AS_UNIT_CLASS
  		WHERE	unit_class = cp_unit_class;

Line: 157

  		SELECT	ass_item_cutoff_dt_alias
  		FROM	IGS_AS_CAL_CONF
  		WHERE	s_control_num 	= cst_one;

Line: 164

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

Line: 221

  		SELECT 	IGS_CA_STAT.s_cal_status
  		FROM	IGS_CA_INST, IGS_CA_STAT
  		WHERE	IGS_CA_INST.cal_type = cp_cal_type AND
  			IGS_CA_INST.sequence_number = cp_ci_sequence_number AND
  			IGS_CA_INST.cal_status = IGS_CA_STAT.cal_status;

Line: 254

  		SELECT *
  		FROM IGS_CA_TYPE
  		WHERE cal_type	= p_cal_type;

Line: 297

  		SELECT	'x'
  		FROM	IGS_AS_ASSESSMNT_TYP		atyp,
  			IGS_AS_ASSESSMNT_ITM		ai,
  			IGS_AS_UNITASS_ITEM	uai
  		WHERE	atyp.examinable_ind 	= 'Y' AND
  			ai.assessment_type 	= atyp.assessment_type AND
  			uai.ass_id 		= ai.ass_id AND
  			uai.unit_cd 		= p_unit_cd AND
  			uai.version_number 	= p_version_number AND
  			uai.cal_type 		= p_cal_type AND
  			uai.ci_sequence_number 	= p_ci_sequence_number AND
  			uai.ass_id 		<> p_ass_id AND
  			uai.sequence_number 	<> p_sequence_number AND
  			NVL(uai.reference, 'NULL') = NVL(p_reference, 'NULL');

Line: 364

           SELECT	'x'
  		FROM	IGS_AS_ASSESSMNT_TYP		atyp,
  			IGS_AS_ASSESSMNT_ITM		ai,
  			IGS_PS_UNITASS_ITEM	uai,
			IGS_PS_UNIT_OFR_OPT   uoo
  		WHERE	atyp.examinable_ind 	= 'Y' AND
			ai.assessment_type 	= atyp.assessment_type AND
  			uai.ass_id 		= ai.ass_id AND
                      	uoo.unit_cd 		= p_unit_cd AND
  			uoo.version_number 	= p_version_number AND
  			uoo.cal_type 		= p_cal_type AND
  			uoo.ci_sequence_number 	= p_ci_sequence_number AND
                      	uoo.uoo_id              = uai.uoo_id AND
			uai.ass_id 		<> p_ass_id AND
  			uai.sequence_number 	<> p_sequence_number AND
  			NVL(uai.reference, 'NULL') = NVL(p_reference, 'NULL');

Line: 427

  	-- pattern for non-examinable items which have not been deleted.
  	-- This is similar to ASSP_VAL_UAI_UNIQREF except that:
  	-- * The routine validates non-examinable items as opposed
  	--   to examinable items
  	-- * Reference is optional
  	-- * Reference when set is unique within an assessment type and
  	--   only for items that have not been deleted
  DECLARE
  	CURSOR c_uai IS
  		SELECT	'x'
  		FROM	IGS_AS_UNITASS_ITEM	uai,
  			IGS_AS_ASSESSMNT_ITM		ai,
  			IGS_AS_ASSESSMNT_TYP		atyp
  		WHERE	atyp.examinable_ind 	= 'N' AND
  			atyp.ASSESSMENT_TYPE 	= p_assessment_type AND
  			atyp.ASSESSMENT_TYPE 	= ai.ASSESSMENT_TYPE AND
  			uai.ass_id 		= ai.ass_id AND
  			uai.unit_cd 		= p_unit_cd AND
  			uai.version_number 	= p_version_number AND
  			uai.cal_type 		= p_cal_type AND
  			uai.ci_sequence_number 	= p_ci_sequence_number AND
  			uai.ass_id		<> p_ass_id AND
  			uai.sequence_number 	<> p_sequence_number AND
  			uai.reference 		= p_reference AND
  			uai.logical_delete_dt 	IS NULL;

Line: 457

  		-- Select from the table taking care not to select
  		-- record passed in.
  		OPEN c_uai;

Line: 516

  		SELECT	'x'
  		FROM	IGS_AS_ASSESSMNT_TYP		atyp,
  			IGS_AS_ASSESSMNT_ITM		ai,
  			IGS_AS_UNITASS_ITEM	uai
  		WHERE	atyp.examinable_ind 	= 'Y' AND
  			ai.assessment_type 	= atyp.assessment_type AND
  			uai.ass_id 		= ai.ass_id AND
  			uai.unit_cd 		= p_unit_cd AND
  			uai.version_number 	= p_version_number AND
  			uai.cal_type 		= p_cal_type AND
  			uai.ci_sequence_number 	= p_ci_sequence_number AND
  			uai.ass_id 		= p_ass_id AND
  			uai.sequence_number 	<> p_sequence_number AND
  			NVL(uai.reference, 'NULL') <> NVL(p_reference, 'NULL');

Line: 593

  		SELECT	crv.course_type
  		FROM	IGS_EN_STDNT_PS_ATT sca,
  			IGS_PS_VER crv
  		WHERE	sca.person_id = cp_person_id AND
  			sca.course_cd = cp_course_cd AND
  			sca.course_cd = crv.course_cd AND
  			sca.version_number = crv.version_number;

Line: 632

  p_old_logical_delete_dt IN DATE ,
  p_new_location_cd IN VARCHAR2 ,
  p_new_unit_class IN VARCHAR2 ,
  p_new_unit_mode IN VARCHAR2 ,
  p_new_logical_delete_dt IN DATE ,
  p_message_name  OUT NOCOPY VARCHAR2 )
  RETURN BOOLEAN IS
  	gv_other_detail		VARCHAR2(255);

Line: 641

  	-- Validate that can update the IGS_AS_UNITASS_ITEM.
  	-- Modification is not allowed if :
  	-- logically deleting and the item belongs to a pattern. It must be removed
  	-- from the pattern first.
  	-- Updating IGS_AD_LOCATION, IGS_PS_UNIT mode or IGS_PS_UNIT class and the item belongs to a
  	-- pattern. The pattern IGS_AD_LOCATION, IGS_PS_UNIT mode or IGS_PS_UNIT class must be update
  	-- first or the item removed from the pattern(s).
        --stubbed by ijeddy for bug 3881046 on 22 Sept, 2004.
  	RETURN TRUE;