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_PS_OFR

Line 44: v_location_cd IGS_PS_OFR_PAT.location_cd%TYPE;

40: BEGIN -- admpl_val_option
41: -- validate options
42: DECLARE
43: v_return_val BOOLEAN DEFAULT FALSE;
44: v_location_cd IGS_PS_OFR_PAT.location_cd%TYPE;
45: v_attendance_mode IGS_PS_OFR_PAT.attendance_mode%TYPE;
46: v_attendance_type IGS_PS_OFR_PAT.attendance_type%TYPE;
47: -- Validate option
48: CURSOR c_acov (

Line 45: v_attendance_mode IGS_PS_OFR_PAT.attendance_mode%TYPE;

41: -- validate options
42: DECLARE
43: v_return_val BOOLEAN DEFAULT FALSE;
44: v_location_cd IGS_PS_OFR_PAT.location_cd%TYPE;
45: v_attendance_mode IGS_PS_OFR_PAT.attendance_mode%TYPE;
46: v_attendance_type IGS_PS_OFR_PAT.attendance_type%TYPE;
47: -- Validate option
48: CURSOR c_acov (
49: cp_s_admission_process_type

Line 46: v_attendance_type IGS_PS_OFR_PAT.attendance_type%TYPE;

42: DECLARE
43: v_return_val BOOLEAN DEFAULT FALSE;
44: v_location_cd IGS_PS_OFR_PAT.location_cd%TYPE;
45: v_attendance_mode IGS_PS_OFR_PAT.attendance_mode%TYPE;
46: v_attendance_type IGS_PS_OFR_PAT.attendance_type%TYPE;
47: -- Validate option
48: CURSOR c_acov (
49: cp_s_admission_process_type
50: IGS_AD_PRCS_CAT.s_admission_process_type%TYPE) IS

Line 54: FROM IGS_PS_OFR_PAT_APCOOD_V acov

50: IGS_AD_PRCS_CAT.s_admission_process_type%TYPE) IS
51: SELECT acov.location_cd,
52: acov.attendance_mode,
53: acov.attendance_type
54: FROM IGS_PS_OFR_PAT_APCOOD_V acov
55: WHERE acov.adm_cal_type = p_adm_cal_type AND
56: acov.adm_ci_sequence_number = p_adm_ci_sequence_number AND
57: acov.admission_cat = p_admission_cat AND
58: acov.s_admission_process_type = cp_s_admission_process_type AND

Line 175: cp_course_cd IGS_PS_OFR.course_cd%TYPE,

171: CURSOR c_cop_cir (
172: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
173: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
174: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
175: cp_course_cd IGS_PS_OFR.course_cd%TYPE,
176: cp_version_number IGS_PS_OFR.version_number%TYPE) IS
177: SELECT cop.course_cd,
178: cop.version_number,
179: cop.cal_type,

Line 176: cp_version_number IGS_PS_OFR.version_number%TYPE) IS

172: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
173: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
174: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
175: cp_course_cd IGS_PS_OFR.course_cd%TYPE,
176: cp_version_number IGS_PS_OFR.version_number%TYPE) IS
177: SELECT cop.course_cd,
178: cop.version_number,
179: cop.cal_type,
180: cop.location_cd,

Line 183: FROM IGS_PS_OFR_PAT cop,

179: cop.cal_type,
180: cop.location_cd,
181: cop.attendance_mode,
182: cop.attendance_type
183: FROM IGS_PS_OFR_PAT cop,
184: IGS_CA_INST_REL cir
185: WHERE cir.sup_cal_type = cp_acad_cal_type AND
186: cir.sub_cal_type = cp_adm_cal_type AND
187: cir.sub_ci_sequence_number = cp_adm_ci_sequence_number AND