APPS.IGS_AD_VAL_APCOO SQL Statements

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

Line: 32

  	SELECT	cop.course_cd,
  		cop.version_number,
  		cop.cal_type,
  		cop.location_cd,
  		cop.attendance_mode,
  		cop.attendance_type
  	FROM	IGS_CA_INST_REL	cir,
  		IGS_PS_OFR_PAT		cop
  	WHERE	cir.sub_cal_type		= p_adm_cal_type		AND
  		cir.sub_ci_sequence_number	= p_adm_ci_sequence_number	AND
  		cir.sup_cal_type		= p_acad_cal_type 		AND
  		cop.course_cd			= p_course_cd			AND
  		cop.version_number		= p_crv_version_number		AND
  		cop.offered_ind			= 'Y'				AND
  		cop.entry_point_ind		= 'Y'				AND
  		cop.cal_type			= cir.sup_cal_type		AND
  		cop.ci_sequence_number		= cir.sup_ci_sequence_number;

Line: 126

   		SELECT	closed_ind
   		FROM	IGS_EN_ATD_TYPE
   		WHERE	attendance_type = p_attendance_type;

Line: 177

  	--  IGS_EN_ATD_TYPE tables when inserting or updating an admission period
  	-- IGS_PS_COURSE offering option record  to avoid
  	-- conflicting or duplicate course offering option components.
  DECLARE
  	v_message_name	VARCHAR2(30);

Line: 193

  		SELECT	apcoo.location_cd,
  			apcoo.attendance_mode,
  			apcoo.attendance_type
  		FROM	IGS_AD_PRD_PS_OF_OPT apcoo
  		WHERE	apcoo.adm_cal_type	= cp_adm_cal_type AND
  			apcoo.adm_ci_sequence_number = cp_adm_ci_sequence_number AND
  			apcoo.admission_cat	= cp_admission_cat AND
  			apcoo.s_admission_process_type = cp_s_admission_process_type AND
  			apcoo.course_cd		=  cp_course_cd AND
  			apcoo.version_number	=  cp_version_number AND
  			apcoo.acad_cal_type	=  cp_acad_cal_type AND
  			apcoo.sequence_number	<> cp_sequence_number;

Line: 216

  		-- Validate parameter linkages against the selected record's linkages
  		IF(IGS_AD_VAL_APCOO.genp_val_optnl_coo(
  					p_location_cd,
  					p_attendance_mode,
  					p_attendance_type,
  					v_apcoo_rec.location_cd,
  					v_apcoo_rec.attendance_mode,
  					v_apcoo_rec.attendance_type,
  					v_message_name) = FALSE) THEN
  			IF(v_message_name = 'IGS_AS_SPECIFIED_LINK_CONFLIC') THEN
  				p_message_name := 'IGS_AD_LINKCONFLICT_ADMPRD';

Line: 257

  	-- Routine to insert admission period course offering options.
  	-- This will be fired from the form when defining an admission
  	-- period for an admission category and process type.
  DECLARE
  	CURSOR c_apcoo(
  		cp_adm_cal_type			IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,
  		cp_adm_ci_sequence_number  	IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,
  		cp_admission_cat		      IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE,
  		cp_s_admission_process_type 	IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE) IS
  		SELECT  'x'
  		FROM    IGS_AD_PRD_PS_OF_OPT
  		WHERE   adm_cal_type 		= cp_adm_cal_type AND
  			adm_ci_sequence_number 	= cp_adm_ci_sequence_number AND
  			admission_cat	= cp_admission_cat AND
  			s_admission_process_type 	= cp_s_admission_process_type;

Line: 276

  		SELECT DISTINCT	acov.course_cd,
  				      acov.version_number,
  				      acov.acad_cal_type
  		FROM    	IGS_PS_OFR_PAT_APCOO_V acov
  		WHERE	acov.adm_cal_type 	= cp_adm_cal_type AND
  			acov.adm_ci_sequence_number = cp_adm_ci_sequence_number AND
  			acov.admission_cat = p_admission_cat AND
  			acov.s_admission_process_type = p_s_admission_process_type AND
  			( IGS_AD_GEN_013.ADMS_GET_COO_CRV(
  					acov.course_cd,
  					acov.version_number,
  					p_s_admission_process_type,
  					'N') = 'Y' );

Line: 315

                  select IGS_AD_PRD_PS_OF_OPT_SEQ_NUM_S.NEXTVAL into
                  v_sequence_number
                  from dual;

Line: 319

           IGS_AD_PRD_PS_OF_OPT_PKG.INSERT_ROW(
              X_ROWID => v_rowid,
              X_ADM_CAL_TYPE => p_adm_cal_type,
              X_ADM_CI_SEQUENCE_NUMBER => p_adm_ci_sequence_number,
              X_ADMISSION_CAT => p_admission_cat,
              X_S_ADMISSION_PROCESS_TYPE => p_s_admission_process_type,
              X_COURSE_CD => v_acov_rec.course_cd,
              X_VERSION_NUMBER => v_acov_rec.version_number,
              X_ACAD_CAL_TYPE => v_acov_rec.acad_cal_type,
              X_SEQUENCE_NUMBER => v_sequence_number,
              X_LOCATION_CD  => NULL,
              X_ATTENDANCE_MODE => NULL,
              X_ATTENDANCE_TYPE => NULL,
              X_ROLLOVER_INCLUSION_IND => 'Y',
              X_MODE => 'R');

Line: 621

  		SELECT	closed_ind
  		FROM	IGS_EN_ATD_MODE
  		WHERE	attendance_mode = p_attendance_mode;

Line: 668

  		SELECT	location_cd,
                 		attendance_mode,
         			attendance_type
  		FROM	IGS_PS_OFR_PAT_APCOO_V
  		WHERE	course_cd                   = p_course_cd AND
  			version_number              = p_version_number AND
  			acad_cal_type         	    = p_acad_cal_type AND
  			adm_cal_type		    = p_adm_cal_type AND
  			adm_ci_sequence_number      = p_adm_ci_sequence_number AND
  			admission_cat		    = p_admission_cat AND
  			s_admission_process_type    = p_s_admission_process_type AND
  			(IGS_AD_GEN_013.ADMS_GET_COO_CRV(
  				course_cd,
  				version_number,
  				s_admission_process_type,
  				'N') = 'Y') AND
  			(IGS_AD_GEN_013.ADMS_GET_COO_ADM_CAT (
  				course_cd,
  				version_number,
  				acad_cal_type,
  				location_cd,
  				attendance_mode,
  				attendance_type,
  				admission_cat) = 'Y') AND
  			(p_location_cd IS NULL OR
  			location_cd		= p_location_cd) AND
  			(p_attendance_mode IS NULL OR
  			attendance_mode		= p_attendance_mode) AND
  			(p_attendance_type IS NULL OR
  			attendance_type 		= p_attendance_type);