APPS.IGS_EN_VAL_SCT SQL Statements

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

Line: 40

  		SELECT	scae.cal_type,
  			scae.ci_sequence_number,
  			scae.enrolment_cat
  		FROM	IGS_AS_SC_ATMPT_ENR	scae,
  			IGS_CA_INST		ci
  		WHERE	scae.person_id	= p_person_id AND
  			scae.course_cd	= p_course_cd AND
  			scae.cal_type	= ci.cal_type AND
  			scae.ci_sequence_number = ci.sequence_number
  		ORDER BY ci.start_dt DESC;

Line: 119

  		SELECT	sua.cal_type,
  			sua.ci_sequence_number
  		FROM	IGS_EN_SU_ATTEMPT	sua
  		WHERE	person_id		= p_person_id	AND
  			   course_cd		= p_course_cd	AND
  			   uoo_id			= p_uoo_id	;

Line: 176

  FUNCTION enrp_val_sct_insert(
  p_person_id IN NUMBER ,
  p_course_cd IN VARCHAR2 ,
  p_transfer_course_cd IN VARCHAR2 ,
  p_transfer_dt IN DATE ,
  p_message_name OUT NOCOPY VARCHAR2)
  RETURN BOOLEAN AS

  BEGIN	-- enrp_val_sct_insert
  	-- This module validates IGS_PS_STDNT_TRN courses.
  	-- Course_cd and transfer_course_cd must not be the same.
  	-- Course_cd and transfer_course_cd must be in a system defined course transfer
  	-- group type, and must be members of the same group.
  	-- Validate course_cd.
  	-- Validate transfer_course_cd.
  DECLARE
  	cst_unconfirm	CONSTANT	VARCHAR(9) := 'UNCONFIRM';

Line: 209

  		SELECT 	sca.version_number,
  			sca.course_attempt_status,
  			sca.adm_admission_appl_number,
  			sca.adm_nominated_course_cd ,
  			sca.adm_sequence_number
  		FROM	IGS_EN_STDNT_PS_ATT sca
  		WHERE	sca.person_id = p_person_id AND
  			sca.course_cd = p_course_cd;

Line: 218

  		SELECT 	sca.version_number,
  			sca.course_attempt_status
  		FROM	IGS_EN_STDNT_PS_ATT sca
  		WHERE	sca.person_id = p_person_id AND
  			sca.course_cd = p_transfer_course_cd;

Line: 228

  		SELECT	'x'
  		FROM 	IGS_PS_GRP_MBR cgm,
  			IGS_PS_GRP cg,
  			IGS_PS_GRP_TYPE cgt
  		WHERE	cgm.course_cd 		= p_course_cd 			AND
  			cgm.version_number	= cp_to_version_number 		AND
  			cgt.s_course_group_type = cp_s_course_group_type 	AND
  			cg.course_group_cd 	= cgm.course_group_cd 		AND
  			cg.course_group_type 	= cgt.course_group_type 	AND
  			EXISTS	(SELECT 'x'
  				FROM 	IGS_PS_GRP_MBR cgm2
  				WHERE	cgm2.course_cd 		= p_transfer_course_cd 		AND
  					cgm2.version_number 	= cp_from_version_number 	AND
  					cgm2.course_group_cd 	= cgm.course_group_cd);

Line: 338

		FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_SCT.enrp_val_sct_insert');

Line: 341

  END enrp_val_sct_insert;

Line: 396

  		SELECT	generic_course_ind
  		FROM 	IGS_PS_VER cv
  		WHERE 	cv.course_cd 		= p_course_cd AND
  			cv.version_number 	= p_crv_version_number;

Line: 401

  		SELECT 	s_admission_process_type
  		FROM	IGS_AD_APPL aa
  		WHERE	aa.person_id 			= p_person_id AND
  			aa.admission_appl_number 	= p_admission_appl_number;

Line: 406

  		SELECT 	adm_outcome_status,
  			adm_offer_resp_status
  		FROM 	IGS_AD_PS_APPL_INST acai
  		WHERE	acai.person_id 			= p_person_id 			AND
  			acai.admission_appl_number 	= p_admission_appl_number 	AND
  			acai.nominated_course_cd 	= p_nominated_course_cd		AND
  			acai.sequence_number		= p_acai_sequence_number;

Line: 416

  		SELECT 	'x'
  		FROM	IGS_PS_STDNT_TRN sct
  		WHERE	sct.person_id 		= p_person_id 	AND
  			(course_cd 		= p_course_cd 	OR
  			transfer_course_cd 	= p_course_cd) 	AND
  			status_flag = 'U';

Line: 423

  		SELECT	sca.commencement_dt
  		FROM	IGS_EN_STDNT_PS_ATT	sca
  		WHERE	sca.person_id 	= p_person_id AND
  			sca.course_cd 	= p_course_cd;

Line: 585

  		SELECT 	'x'
  		FROM	IGS_PS_STDNT_TRN sct
  		WHERE	sct.person_id 		= p_person_id 	AND
  			(course_cd 		= p_transfer_course_cd 	OR
  			transfer_course_cd 	= p_transfer_course_cd) 	AND
  			status_flag = 'U';

Line: 742

  		SELECT	'x'
  		FROM	IGS_AS_SU_SETATMPT
  		WHERE	person_id 		= p_person_id AND
  			course_cd 		= p_course_cd AND
  			unit_set_cd 		= p_unit_set_cd AND
  			us_version_number 	= p_us_version_number;