eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_VAL_APCOOD dependencies on IGS_AD_PRD_PS_OF_OPT

Line 163: v_s_adm_proc_type IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE;

159: BEGIN -- admp_val_apcood_co
160: -- Routine to verify that the course offering is valid for the admission
161: -- period course offering option date override.
162: DECLARE
163: v_s_adm_proc_type IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE;
164: v_cop_cir_rec_found BOOLEAN DEFAULT FALSE;
165: v_apapc_rec_found BOOLEAN DEFAULT FALSE;
166: v_crv_valid BOOLEAN DEFAULT FALSE;
167: v_adm_perd_valid BOOLEAN DEFAULT FALSE;

Line 197: cp_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE) IS

193: cop.ci_sequence_number = cir.sup_ci_sequence_number;
194: CURSOR c_apapc (
195: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
196: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
197: cp_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE) IS
198: SELECT apapc.s_admission_process_type
199: FROM IGS_AD_PRD_AD_PRC_CA apapc
200: WHERE apapc.adm_cal_type = cp_adm_cal_type AND
201: apapc.adm_ci_sequence_number = cp_adm_ci_sequence_number AND