APPS.IGS_AD_VAL_APAC SQL Statements

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

Line: 24

  		SELECT DISTINCT course_cd,
  				version_number,
  				acad_cal_type
  		FROM	IGS_AD_PRD_PS_OF_OPT
  		WHERE	adm_cal_type 		= p_old_adm_cal_type AND
  			adm_ci_sequence_number 	= p_old_adm_ci_sequence_number AND
  			admission_cat 		= p_old_admission_cat;

Line: 111

  		Select  cir1.sup_cal_type,
  			cir1.sup_ci_sequence_number
  		FROM	IGS_CA_INST_REL cir1,
  			IGS_CA_TYPE cat
  		WHERE   cir1.sub_cal_type		= p_adm_cal_type AND
  			cir1.sub_ci_sequence_number 	= p_adm_ci_sequence_number AND
  			cir1.sup_cal_type		= cat.cal_type AND
  			cat.s_cal_cat			= 'ACADEMIC';

Line: 123

  		SELECT DISTINCT ci.alternate_code,
  				cir2.sub_cal_type,
  				cir2.sub_ci_sequence_number
  		FROM   	IGS_CA_INST_REL cir2,
  			IGS_CA_INST ci,
  			IGS_CA_TYPE cat
  		WHERE  	cir2.sup_cal_type		= cp_sup_cal_type AND
  			cir2.sup_ci_sequence_number  	= cp_sup_ci_sequence_number  AND
  			(cir2.sub_cal_type		<> p_adm_cal_type	OR
  			cir2.sub_ci_sequence_number 	<> p_adm_ci_sequence_number) AND
  			cat.s_cal_cat			= 'ADMISSION' AND
  			cat.cal_type			= ci.cal_type AND
  			ci.cal_type			= cir2.sub_cal_type AND
  			ci.sequence_number		= cir2.sub_ci_sequence_number;

Line: 141

  		SELECT  admission_cat
  		FROM	IGS_AD_PERD_AD_CAT
  		WHERE   adm_cal_type		= cp_sub_cal_type  AND
  			adm_ci_sequence_number 	= cp_sub_ci_sequence_number;

Line: 234

  	-- Routine to insert admission period admission process categories.
  	-- This will be fired from the form when saving an admission period
  	-- for an admission category.
	-- Enhancement: 3132406 nsinha 9/25/2003 added new parameter p_prior_adm_ci_seq_number
	-- Added logic related to cursor c_apapc_roll.
  DECLARE
  	CURSOR c_apapc(
  		cp_cal_type	IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,
  		cp_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) IS
  		SELECT	'x'
  		FROM	IGS_AD_PRD_AD_PRC_CA
  		WHERE	adm_cal_type 		= cp_cal_type AND
  			adm_ci_sequence_number 	= cp_sequence_number AND
  			admission_cat 		= cp_admission_cat;

Line: 251

  		SELECT	s_admission_process_type
  		FROM	IGS_AD_PRCS_CAT
  		WHERE	admission_cat 	= cp_admission_cat
		AND     closed_ind = 'N';                    --added the closed indicator for bug# 2380108 (rghosh)

Line: 262

  		SELECT	*
  		FROM	IGS_AD_PRD_AD_PRC_CA
  		WHERE	adm_cal_type 		= cp_cal_type AND
  			adm_ci_sequence_number 	= cp_sequence_number AND
  			admission_cat 		= cp_admission_cat AND
            NVL (closed_ind,'N') = 'N';

Line: 288

			   IGS_AD_PRD_AD_PRC_CA_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 => v_apc_rec.s_admission_process_type,
				  X_MODE => 'R');

Line: 299

		-- INSERT INTO IGS_AD_PRD_AD_PRC_CA_PKG, the records fetched by above cursor as follows
		FOR v_apapc_rec IN c_apapc_roll (p_adm_cal_type, p_prior_adm_ci_seq_number, p_admission_cat) LOOP
		     --DECODE(v_apapc_rec.include_sr_in_rollover_flag,'Y', v_apapc_rec.single_response_flag ,'N')
			 IF v_apapc_rec.include_sr_in_rollover_flag = 'Y' THEN
			   l_single_response_flag := v_apapc_rec.single_response_flag;

Line: 308

			 IGS_AD_PRD_AD_PRC_CA_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 => v_apapc_rec.s_admission_process_type,
				  X_SINGLE_RESPONSE_FLAG => l_single_response_flag,
				  X_INCLUDE_SR_IN_ROLLOVER_FLAG => v_apapc_rec.include_sr_in_rollover_flag, /*Rollover flag from  Prior Admission period should be carried to new Rollover period*/
				  X_MODE => 'R');

Line: 356

  		SELECT	cat.s_cal_cat
  		FROM	IGS_CA_TYPE cat
  		WHERE	cat.cal_type 		= cp_adm_cal_type;

Line: 363

  		SELECT	cs.s_cal_status,
  			ci.alternate_code,
  			ci.start_dt,
  			ci.end_dt
  		FROM	IGS_CA_INST ci,
  			IGS_CA_STAT cs
  		WHERE	ci.cal_type 		= cp_adm_cal_type AND
  			ci.sequence_number 	= cp_adm_ci_sequence_number AND
  			ci.cal_status 		= cs.cal_status;