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_ACAI dependencies on IGS_AD_PS_APPL_INST

Line 35: -- Validate insert of an IGS_AD_PS_APPL_INST record.

31: -- rghosh 03-mar-2003 Changed the signature of the function ADMP_VAL_DFRMNT_CAL (bug#2765260)
32: -------------------------------------------------------------------------------------------
33:
34: --
35: -- Validate insert of an IGS_AD_PS_APPL_INST record.
36:
37: FUNCTION admp_val_acai_insert(
38: p_person_id IN NUMBER ,
39: p_admission_appl_number IN NUMBER ,

Line 58: -- Routine to validate the insert of an IGS_AD_PS_APPL_INST record.

54: p_return_type OUT NOCOPY VARCHAR2 )
55: RETURN BOOLEAN AS
56: gv_validate_aa_only VARCHAR2(1);
57: BEGIN -- admp_val_acai_insert
58: -- Routine to validate the insert of an IGS_AD_PS_APPL_INST record.
59: DECLARE
60: cst_completed CONSTANT VARCHAR2(9) := 'COMPLETED';
61: cst_withdrawn CONSTANT VARCHAR2(9) := 'WITHDRAWN';
62: cst_warn CONSTANT VARCHAR2(1) := 'W';

Line 68: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,

64: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
65: v_message_name VARCHAR2(30);
66: v_return BOOLEAN := TRUE;
67: CURSOR c_acaiv (
68: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
69: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
70: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
71: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
72: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,

Line 69: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,

65: v_message_name VARCHAR2(30);
66: v_return BOOLEAN := TRUE;
67: CURSOR c_acaiv (
68: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
69: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
70: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
71: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
72: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
73: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,

Line 70: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

66: v_return BOOLEAN := TRUE;
67: CURSOR c_acaiv (
68: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
69: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
70: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
71: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
72: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
73: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
74: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,

Line 71: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,

67: CURSOR c_acaiv (
68: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
69: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
70: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
71: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
72: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
73: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
74: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,
75: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,

Line 72: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,

68: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
69: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
70: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
71: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
72: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
73: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
74: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,
75: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,
76: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,

Line 73: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,

69: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
70: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
71: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
72: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
73: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
74: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,
75: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,
76: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,
77: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,

Line 74: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,

70: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
71: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
72: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
73: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
74: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,
75: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,
76: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,
77: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
78: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS

Line 75: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,

71: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
72: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
73: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
74: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,
75: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,
76: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,
77: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
78: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS
79: SELECT 'x'

Line 76: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,

72: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
73: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
74: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,
75: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,
76: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,
77: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
78: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS
79: SELECT 'x'
80: FROM IGS_AD_APPL aav, IGS_AD_PS_APPL_INST acaiv

Line 80: FROM IGS_AD_APPL aav, IGS_AD_PS_APPL_INST acaiv

76: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,
77: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
78: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS
79: SELECT 'x'
80: FROM IGS_AD_APPL aav, IGS_AD_PS_APPL_INST acaiv
81: WHERE aav.person_id = acaiv.person_id AND
82: aav.admission_appl_number = acaiv.admission_appl_number AND
83: acaiv.person_id = cp_person_id AND
84: acaiv.course_cd = cp_course_cd AND

Line 102: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,

98: -- Added the following cursor definitions for UK Bug 2462198
99: -- by rrengara on 24-JUL-2002
100:
101: CURSOR c_acaiv_uk (
102: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
103: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
104: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
105: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
106: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,

Line 103: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,

99: -- by rrengara on 24-JUL-2002
100:
101: CURSOR c_acaiv_uk (
102: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
103: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
104: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
105: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
106: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
107: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,

Line 104: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

100:
101: CURSOR c_acaiv_uk (
102: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
103: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
104: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
105: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
106: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
107: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
108: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,

Line 105: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,

101: CURSOR c_acaiv_uk (
102: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
103: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
104: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
105: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
106: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
107: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
108: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,
109: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,

Line 106: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,

102: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
103: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
104: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
105: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
106: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
107: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
108: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,
109: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,
110: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,

Line 107: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,

103: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
104: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
105: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
106: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
107: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
108: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,
109: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,
110: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,
111: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,

Line 108: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,

104: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
105: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
106: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
107: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
108: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,
109: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,
110: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,
111: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
112: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE,

Line 109: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,

105: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
106: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
107: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
108: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,
109: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,
110: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,
111: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
112: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE,
113: cp_choice_number IGS_AD_APPL.choice_number%TYPE,

Line 110: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,

106: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
107: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
108: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,
109: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,
110: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,
111: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
112: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE,
113: cp_choice_number IGS_AD_APPL.choice_number%TYPE,
114: cp_alt_appl_id IGS_AD_APPL.alt_appl_id%TYPE) IS

Line 116: FROM IGS_AD_APPL aav, IGS_AD_PS_APPL_INST acaiv

112: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE,
113: cp_choice_number IGS_AD_APPL.choice_number%TYPE,
114: cp_alt_appl_id IGS_AD_APPL.alt_appl_id%TYPE) IS
115: SELECT 'x'
116: FROM IGS_AD_APPL aav, IGS_AD_PS_APPL_INST acaiv
117: WHERE aav.person_id = acaiv.person_id AND
118: aav.admission_appl_number = acaiv.admission_appl_number AND
119: acaiv.person_id = cp_person_id AND
120: acaiv.course_cd = cp_course_cd AND

Line 163: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,

159: -- End definitions for UK Bug 2462198 by rrengara on 24-JUL-2002
160:
161:
162: CURSOR c_acaiv_aa (
163: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
164: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
165: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
166: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
167: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,

Line 164: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,

160:
161:
162: CURSOR c_acaiv_aa (
163: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
164: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
165: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
166: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
167: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
168: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,

Line 165: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

161:
162: CURSOR c_acaiv_aa (
163: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
164: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
165: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
166: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
167: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
168: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
169: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,

Line 166: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,

162: CURSOR c_acaiv_aa (
163: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
164: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
165: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
166: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
167: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
168: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
169: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,
170: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,

Line 167: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,

163: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
164: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
165: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
166: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
167: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
168: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
169: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,
170: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,
171: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,

Line 168: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,

164: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
165: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
166: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
167: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
168: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
169: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,
170: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,
171: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,
172: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,

Line 169: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,

165: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
166: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
167: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
168: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
169: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,
170: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,
171: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,
172: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
173: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS

Line 170: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,

166: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
167: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
168: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
169: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,
170: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,
171: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,
172: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
173: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS
174: SELECT aa.adm_appl_status

Line 171: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,

167: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
168: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
169: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE,
170: cp_unit_set_cd IGS_AD_PS_APPL_INST.unit_set_cd%TYPE,
171: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,
172: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
173: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS
174: SELECT aa.adm_appl_status
175: FROM IGS_AD_PS_APPL_INST acaiv,

Line 175: FROM IGS_AD_PS_APPL_INST acaiv,

171: cp_us_version_number IGS_AD_PS_APPL_INST.us_version_number%TYPE,
172: cp_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
173: cp_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS
174: SELECT aa.adm_appl_status
175: FROM IGS_AD_PS_APPL_INST acaiv,
176: IGS_AD_APPL aa
177: WHERE acaiv.person_id = cp_person_id AND
178: acaiv.nominated_course_cd = cp_course_cd AND
179: (acaiv.admission_appl_number <> cp_admission_appl_number OR

Line 192: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,

188: acaiv.person_id = aa.person_id AND
189: acaiv.admission_appl_number = aa.admission_appl_number;
190:
191: CURSOR c_aal (
192: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
193: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE)
194: IS
195: SELECT 'x'
196: FROM IGS_AD_APPL_LTR aal

Line 193: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE)

189: acaiv.admission_appl_number = aa.admission_appl_number;
190:
191: CURSOR c_aal (
192: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
193: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE)
194: IS
195: SELECT 'x'
196: FROM IGS_AD_APPL_LTR aal
197: WHERE aal.person_id = cp_person_id AND

Line 350: -- Validate update of an IGS_AD_PS_APPL_INST record.

346: IGS_GE_MSG_STACK.ADD;
347: APP_EXCEPTION.RAISE_EXCEPTION;
348: END admp_val_acai_insert;
349: --
350: -- Validate update of an IGS_AD_PS_APPL_INST record.
351: FUNCTION admp_val_acai_update(
352: p_adm_appl_status IN VARCHAR2 ,
353: p_person_id IN NUMBER ,
354: p_admission_appl_number IN NUMBER ,

Line 361: --This module validates update of an IGS_AD_PS_APPL_INST record.

357: p_message_name OUT NOCOPY VARCHAR2 ,
358: p_update_non_enrol_detail_ind OUT NOCOPY VARCHAR2 )
359: RETURN BOOLEAN AS
360: BEGIN --admp_val_acai_update
361: --This module validates update of an IGS_AD_PS_APPL_INST record.
362: DECLARE
363: v_s_appl_inst_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
364: v_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE;
365: cst_withdrawn CONSTANT VARCHAR2(10) := 'WITHDRAWN';

Line 385: FROM IGS_AD_PS_APPL_INST

381: sca.student_confirmed_ind = 'Y';
382:
383: CURSOR c_ais IS --arvsrini igsm
384: SELECT appl_inst_status
385: FROM IGS_AD_PS_APPL_INST
386: WHERE person_id= p_person_id AND
387: admission_appl_number= p_admission_appl_number AND
388: nominated_course_cd= p_nominated_course_cd AND
389: sequence_number =p_acai_sequence_number;

Line 450: -- Validate delete of an IGS_AD_PS_APPL_INST record.

446: IGS_GE_MSG_STACK.ADD;
447: APP_EXCEPTION.RAISE_EXCEPTION;
448: END admp_val_acai_update;
449: --
450: -- Validate delete of an IGS_AD_PS_APPL_INST record.
451: FUNCTION admp_val_acai_delete(
452: p_person_id IN NUMBER ,
453: p_admission_appl_number IN NUMBER ,
454: p_adm_outcome_status IN VARCHAR2 ,

Line 459: -- Validate delete of an IGS_AD_PS_APPL_INST record

455: p_message_name OUT NOCOPY VARCHAR2 ,
456: p_return_type OUT NOCOPY VARCHAR2 )
457: RETURN BOOLEAN AS
458: BEGIN -- admp_val_acai_delete
459: -- Validate delete of an IGS_AD_PS_APPL_INST record
460: DECLARE
461: CURSOR c_aal IS
462: SELECT 'x'
463: FROM IGS_AD_APPL_LTR

Line 1036: v_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE;

1032: DECLARE
1033: cst_error CONSTANT VARCHAR2(1) := 'E';
1034: cst_warn CONSTANT VARCHAR2(1) := 'W';
1035: v_ret_val BOOLEAN := TRUE;
1036: v_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE;
1037: v_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE;
1038: v_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE;
1039: v_message_name VARCHAR2(30);
1040: v_late_ind VARCHAR2(1) := 'N';

Line 1037: v_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE;

1033: cst_error CONSTANT VARCHAR2(1) := 'E';
1034: cst_warn CONSTANT VARCHAR2(1) := 'W';
1035: v_ret_val BOOLEAN := TRUE;
1036: v_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE;
1037: v_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE;
1038: v_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE;
1039: v_message_name VARCHAR2(30);
1040: v_late_ind VARCHAR2(1) := 'N';
1041: v_return_type VARCHAR2(1);

Line 1038: v_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE;

1034: cst_warn CONSTANT VARCHAR2(1) := 'W';
1035: v_ret_val BOOLEAN := TRUE;
1036: v_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE;
1037: v_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE;
1038: v_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE;
1039: v_message_name VARCHAR2(30);
1040: v_late_ind VARCHAR2(1) := 'N';
1041: v_return_type VARCHAR2(1);
1042: BEGIN

Line 1162: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,

1158: version_number = p_version_number AND
1159: cal_type = p_acad_cal_type AND
1160: delete_flag= 'N';
1161: CURSOR c_cop (
1162: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
1163: cp_version_number IGS_AD_PS_APPL_INST.crv_version_number%TYPE,
1164: cp_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE,
1165: cp_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE,
1166: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,

Line 1163: cp_version_number IGS_AD_PS_APPL_INST.crv_version_number%TYPE,

1159: cal_type = p_acad_cal_type AND
1160: delete_flag= 'N';
1161: CURSOR c_cop (
1162: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
1163: cp_version_number IGS_AD_PS_APPL_INST.crv_version_number%TYPE,
1164: cp_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE,
1165: cp_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE,
1166: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
1167: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,

Line 1166: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,

1162: cp_course_cd IGS_AD_PS_APPL_INST.course_cd%TYPE,
1163: cp_version_number IGS_AD_PS_APPL_INST.crv_version_number%TYPE,
1164: cp_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE,
1165: cp_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE,
1166: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
1167: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
1168: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE) IS
1169: SELECT 'x'
1170: FROM IGS_PS_OFR_PAT

Line 1167: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,

1163: cp_version_number IGS_AD_PS_APPL_INST.crv_version_number%TYPE,
1164: cp_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE,
1165: cp_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE,
1166: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
1167: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
1168: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE) IS
1169: SELECT 'x'
1170: FROM IGS_PS_OFR_PAT
1171: WHERE course_cd = cp_course_cd AND

Line 1168: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE) IS

1164: cp_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE,
1165: cp_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE,
1166: cp_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE,
1167: cp_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE,
1168: cp_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE) IS
1169: SELECT 'x'
1170: FROM IGS_PS_OFR_PAT
1171: WHERE course_cd = cp_course_cd AND
1172: version_number = cp_version_number AND

Line 1183: v_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE;

1179: entry_point_ind = 'Y';
1180: cst_error CONSTANT VARCHAR2(1) := 'E';
1181: cst_warn CONSTANT VARCHAR2(1) := 'W';
1182: v_cop_exists VARCHAR2(1);
1183: v_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE;
1184: v_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE;
1185: v_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE;
1186: v_message_name VARCHAR2(30);
1187: v_record_found BOOLEAN := FALSE;

Line 1184: v_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE;

1180: cst_error CONSTANT VARCHAR2(1) := 'E';
1181: cst_warn CONSTANT VARCHAR2(1) := 'W';
1182: v_cop_exists VARCHAR2(1);
1183: v_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE;
1184: v_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE;
1185: v_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE;
1186: v_message_name VARCHAR2(30);
1187: v_record_found BOOLEAN := FALSE;
1188: v_cop_found BOOLEAN := FALSE;

Line 1185: v_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE;

1181: cst_warn CONSTANT VARCHAR2(1) := 'W';
1182: v_cop_exists VARCHAR2(1);
1183: v_location_cd IGS_AD_PS_APPL_INST.location_cd%TYPE;
1184: v_attendance_mode IGS_AD_PS_APPL_INST.attendance_mode%TYPE;
1185: v_attendance_type IGS_AD_PS_APPL_INST.attendance_type%TYPE;
1186: v_message_name VARCHAR2(30);
1187: v_record_found BOOLEAN := FALSE;
1188: v_cop_found BOOLEAN := FALSE;
1189: v_ac_match BOOLEAN := FALSE; -- admission process category

Line 1380: -- Validate if the IGS_AD_PS_APPL_INST is late.

1376: END IF;
1377: END;
1378: END admp_val_acai_coo;
1379: --
1380: -- Validate if the IGS_AD_PS_APPL_INST is late.
1381: FUNCTION admp_val_acai_late(
1382: p_appl_dt IN DATE ,
1383: p_course_cd IN VARCHAR2 ,
1384: p_crv_version_number IN NUMBER ,

Line 1397: -- Validate if the IGS_AD_PS_APPL_INST is late.

1393: p_late_appl_allowed IN VARCHAR2 ,
1394: p_message_name OUT NOCOPY VARCHAR2 )
1395: RETURN BOOLEAN AS
1396: BEGIN -- admp_val_acai_late
1397: -- Validate if the IGS_AD_PS_APPL_INST is late.
1398: -- Validate against the due date when late applications are not allowed.
1399: -- Validate against the final date when late applications are allowed.
1400: DECLARE
1401: CURSOR c_sacc IS

Line 2000: -- Do encumbrance checks for the IGS_AD_PS_APPL_INST.unit_set_cd.

1996: IGS_GE_MSG_STACK.ADD;
1997: APP_EXCEPTION.RAISE_EXCEPTION;
1998: END crsp_val_cacus_sub;
1999: --
2000: -- Do encumbrance checks for the IGS_AD_PS_APPL_INST.unit_set_cd.
2001: FUNCTION admp_val_us_encmb(
2002: p_person_id IN NUMBER ,
2003: p_course_cd IN VARCHAR2 ,
2004: p_unit_set_cd IN VARCHAR2 ,

Line 2068: -- Validate the IGS_AD_PS_APPL_INST.offer_dt.

2064: IGS_GE_MSG_STACK.ADD;
2065: APP_EXCEPTION.RAISE_EXCEPTION;
2066: END admp_val_us_encmb;
2067: --
2068: -- Validate the IGS_AD_PS_APPL_INST.offer_dt.
2069: FUNCTION admp_val_offer_dt(
2070: p_offer_dt IN DATE ,
2071: p_adm_outcome_status IN VARCHAR2 ,
2072: p_adm_cal_type IN VARCHAR2 ,

Line 2077: -- Validate the IGS_AD_PS_APPL_INST.offer_dt.

2073: p_adm_ci_sequence_number IN NUMBER ,
2074: p_message_name OUT NOCOPY VARCHAR2 )
2075: RETURN BOOLEAN AS
2076: BEGIN -- admp_val_offer_dt
2077: -- Validate the IGS_AD_PS_APPL_INST.offer_dt.
2078: DECLARE
2079: v_s_adm_outcome_status VARCHAR2(255);
2080: v_course_start_dt DATE;
2081: BEGIN

Line 2113: -- Validate the IGS_AD_PS_APPL_INST.offer_response_dt.

2109: IGS_GE_MSG_STACK.ADD;
2110: APP_EXCEPTION.RAISE_EXCEPTION;
2111: END admp_val_offer_dt;
2112: --
2113: -- Validate the IGS_AD_PS_APPL_INST.offer_response_dt.
2114: FUNCTION admp_val_off_resp_dt(
2115: p_offer_response_dt IN DATE ,
2116: p_adm_outcome_status IN VARCHAR2 ,
2117: p_offer_dt IN DATE ,

Line 2121: -- Validate the IGS_AD_PS_APPL_INST.offer_response_dt.

2117: p_offer_dt IN DATE ,
2118: p_message_name OUT NOCOPY VARCHAR2 )
2119: RETURN BOOLEAN AS
2120: BEGIN -- admp_val_off_resp_dt
2121: -- Validate the IGS_AD_PS_APPL_INST.offer_response_dt.
2122: DECLARE
2123: v_s_adm_outcome_status VARCHAR2(255);
2124: BEGIN
2125: p_message_name := NULL;

Line 2158: -- Validate the IGS_AD_PS_APPL_INST.actual_response_dt.

2154: IGS_GE_MSG_STACK.ADD;
2155: APP_EXCEPTION.RAISE_EXCEPTION;
2156: END admp_val_off_resp_dt;
2157: --
2158: -- Validate the IGS_AD_PS_APPL_INST.actual_response_dt.
2159: FUNCTION admp_val_act_resp_dt(
2160: p_actual_response_dt IN DATE ,
2161: p_adm_offer_resp_status IN VARCHAR2 ,
2162: p_offer_dt IN DATE ,

Line 2166: -- Validate the IGS_AD_PS_APPL_INST.actual_response_dt.

2162: p_offer_dt IN DATE ,
2163: p_message_name OUT NOCOPY VARCHAR2 )
2164: RETURN BOOLEAN AS
2165: BEGIN -- admp_val_act_resp_dt
2166: -- Validate the IGS_AD_PS_APPL_INST.actual_response_dt.
2167: DECLARE
2168: v_s_adm_offer_resp_status VARCHAR2(255);
2169: BEGIN
2170: p_message_name := NULL;

Line 2211: -- Validate the IGS_AD_PS_APPL_INST.cndtnl_offer_satisfied_dt.

2207: IGS_GE_MSG_STACK.ADD;
2208: APP_EXCEPTION.RAISE_EXCEPTION;
2209: END admp_val_act_resp_dt;
2210: --
2211: -- Validate the IGS_AD_PS_APPL_INST.cndtnl_offer_satisfied_dt.
2212: FUNCTION admp_val_stsfd_dt(
2213: p_cndtnl_offer_satisfied_dt IN DATE ,
2214: p_adm_cndtnl_offer_status IN VARCHAR2 ,
2215: p_message_name OUT NOCOPY VARCHAR2 )

Line 2218: -- Validate the IGS_AD_PS_APPL_INST.cndtnl_offer_satisfied_dt.

2214: p_adm_cndtnl_offer_status IN VARCHAR2 ,
2215: p_message_name OUT NOCOPY VARCHAR2 )
2216: RETURN BOOLEAN AS
2217: BEGIN -- admp_val_stsfd_dt
2218: -- Validate the IGS_AD_PS_APPL_INST.cndtnl_offer_satisfied_dt.
2219: DECLARE
2220: v_s_adm_cndtnl_offer_status VARCHAR2(255);
2221: BEGIN
2222: p_message_name := NULL;

Line 2259: -- Validate the IGS_AD_PS_APPL_INST.cndtnl_offer_cndtn.

2255: IGS_GE_MSG_STACK.ADD;
2256: APP_EXCEPTION.RAISE_EXCEPTION;
2257: END admp_val_stsfd_dt;
2258: --
2259: -- Validate the IGS_AD_PS_APPL_INST.cndtnl_offer_cndtn.
2260: FUNCTION admp_val_offer_cndtn(
2261: p_cndtnl_offer_cndtn IN VARCHAR2 ,
2262: p_adm_cndtnl_offer_status IN VARCHAR2 ,
2263: p_message_name OUT NOCOPY VARCHAR2 )

Line 2266: -- Validate the IGS_AD_PS_APPL_INST.cndtnl_offer_cndtn.

2262: p_adm_cndtnl_offer_status IN VARCHAR2 ,
2263: p_message_name OUT NOCOPY VARCHAR2 )
2264: RETURN BOOLEAN AS
2265: BEGIN -- admp_val_offer_cndtn
2266: -- Validate the IGS_AD_PS_APPL_INST.cndtnl_offer_cndtn.
2267: -- Validations are:
2268: -- * The conditional offer condition may only have a value when a
2269: -- conditional offer has been made.
2270: DECLARE

Line 2299: -- Validate the IGS_AD_PS_APPL_INST.applicant_acptnce_cndtn.

2295: IGS_GE_MSG_STACK.ADD;
2296: APP_EXCEPTION.RAISE_EXCEPTION;
2297: END admp_val_offer_cndtn;
2298: --
2299: -- Validate the IGS_AD_PS_APPL_INST.applicant_acptnce_cndtn.
2300: FUNCTION admp_val_acpt_cndtn(
2301: p_applicant_acptnce_cndtn IN VARCHAR2 ,
2302: p_adm_offer_resp_status IN VARCHAR2 ,
2303: p_message_name OUT NOCOPY VARCHAR2 )

Line 2306: -- Validate the IGS_AD_PS_APPL_INST.applicant_acptnce_cndtn.

2302: p_adm_offer_resp_status IN VARCHAR2 ,
2303: p_message_name OUT NOCOPY VARCHAR2 )
2304: RETURN BOOLEAN AS
2305: BEGIN -- admp_val_acpt_cndtn
2306: -- Validate the IGS_AD_PS_APPL_INST.applicant_acptnce_cndtn.
2307: -- Validations are:
2308: -- * The applicant acceptance condition may only have a value when the
2309: -- applicant has responded to an offer of admission.
2310: DECLARE

Line 2342: -- Validate the IGS_AD_PS_APPL_INST.cndtnl_offer_must_be_stsfd_ind.

2338: IGS_GE_MSG_STACK.ADD;
2339: APP_EXCEPTION.RAISE_EXCEPTION;
2340: END admp_val_acpt_cndtn;
2341: --
2342: -- Validate the IGS_AD_PS_APPL_INST.cndtnl_offer_must_be_stsfd_ind.
2343: FUNCTION admp_val_must_stsfd(
2344: p_cndtnl_off_must_be_stsfd_ind IN VARCHAR2 ,
2345: p_adm_cndtnl_offer_status IN VARCHAR2 ,
2346: p_adm_offer_resp_status IN VARCHAR2 ,

Line 2351: -- Validate the IGS_AD_PS_APPL_INST.cndtnl_offer_must_be_stsfd_ind.

2347: p_cndtnl_offer_satisfied_dt IN DATE ,
2348: p_message_name OUT NOCOPY VARCHAR2 )
2349: RETURN BOOLEAN AS
2350: BEGIN -- admp_val_must_stsfd
2351: -- Validate the IGS_AD_PS_APPL_INST.cndtnl_offer_must_be_stsfd_ind.
2352: DECLARE
2353: v_s_adm_cndtnl_offer_status
2354: IGS_AD_CNDNL_OFRSTAT.adm_cndtnl_offer_status%TYPE;
2355: v_s_adm_offer_resp_status IGS_AD_OFR_RESP_STAT.adm_offer_resp_status%TYPE;

Line 2785: -- Validate the IGS_AD_PS_APPL_INST.adm_outcome_status_auth_dt.

2781: APP_EXCEPTION.RAISE_EXCEPTION;
2782: END admp_val_acai_hpo;
2783: --
2784: --
2785: -- Validate the IGS_AD_PS_APPL_INST.adm_outcome_status_auth_dt.
2786: FUNCTION admp_val_ovrd_dt(
2787: p_adm_outcome_status_auth_dt IN DATE ,
2788: p_override_outcome_allowed IN VARCHAR2 ,
2789: p_message_name OUT NOCOPY VARCHAR2 )

Line 2792: -- Validate the IGS_AD_PS_APPL_INST.adm_outcome_status_auth_dt so that

2788: p_override_outcome_allowed IN VARCHAR2 ,
2789: p_message_name OUT NOCOPY VARCHAR2 )
2790: RETURN BOOLEAN AS
2791: BEGIN -- admp_val_ovrd_dt
2792: -- Validate the IGS_AD_PS_APPL_INST.adm_outcome_status_auth_dt so that
2793: -- * The admission outcome status authorising date must be null if the outcome
2794: -- status cannot be overridden for the admission process category of the
2795: -- admission application.
2796: -- * If set, the admission outcome status authorising date must be less than or

Line 2825: -- Validate the IGS_AD_PS_APPL_INST.adm_otcm_status_auth_person_id.

2821: IGS_GE_MSG_STACK.ADD;
2822: APP_EXCEPTION.RAISE_EXCEPTION;
2823: END admp_val_ovrd_dt;
2824: --
2825: -- Validate the IGS_AD_PS_APPL_INST.adm_otcm_status_auth_person_id.
2826: FUNCTION admp_val_ovrd_person(
2827: p_adm_otcm_status_auth_person IN NUMBER ,
2828: p_adm_outcome_status_auth_dt IN DATE ,
2829: p_override_outcome_allowed IN VARCHAR2 ,

Line 3007: -- Validate the IGS_AD_PS_APPL_INST.adm_outcome_status_reason.

3003: RETURN TRUE;
3004: END genp_val_staff_fac_eva_prsn;
3005:
3006: --
3007: -- Validate the IGS_AD_PS_APPL_INST.adm_outcome_status_reason.
3008: FUNCTION admp_val_ovrd_reason(
3009: p_adm_outcome_status_reason IN VARCHAR2 ,
3010: p_adm_outcome_status_auth_dt IN DATE ,
3011: p_override_outcome_allowed IN VARCHAR2 ,

Line 3015: -- Validate the IGS_AD_PS_APPL_INST.adm_outcome_status_reason so that

3011: p_override_outcome_allowed IN VARCHAR2 ,
3012: p_message_name OUT NOCOPY VARCHAR2 )
3013: RETURN BOOLEAN AS
3014: BEGIN -- admp_val_ovrd_reason
3015: -- Validate the IGS_AD_PS_APPL_INST.adm_outcome_status_reason so that
3016: -- * The admission outcome status reason must be null if the outcome
3017: -- status cannot be overridden for the admission process category of the
3018: -- admission application.
3019: -- * The admission outcome status reason must be null if the admission outcome

Line 3360: -- Validate if the specified IGS_AD_PS_APPL_INST is complete.

3356: IGS_GE_MSG_STACK.ADD;
3357: APP_EXCEPTION.RAISE_EXCEPTION;
3358: END admp_val_offer_comp;
3359: --
3360: -- Validate if the specified IGS_AD_PS_APPL_INST is complete.
3361: FUNCTION admp_val_acai_comp(
3362: p_person_id IN NUMBER ,
3363: p_admission_appl_number IN NUMBER ,
3364: p_nominated_course_cd IN VARCHAR2 ,

Line 3426: -- Validate if the specified IGS_AD_PS_APPL_INST is complete

3422: -- ssawhney 24-oct-2002 SWS104 build 2630860, AD_ACAD_HONOR reference moved to PE.
3423: -------------------------------------------------------------------------------------------
3424:
3425: BEGIN -- admp_val_acai_comp
3426: -- Validate if the specified IGS_AD_PS_APPL_INST is complete
3427: DECLARE
3428: cst_re_admit VARCHAR2(10) := 'RE-ADMIT';
3429: v_check_research BOOLEAN := FALSE;
3430: v_valid_referee BOOLEAN := FALSE;

Line 3452: v_location_cd IGS_AD_PS_APPL_INST_APLINST_V.location_cd%TYPE;

3448: v_valid_location BOOLEAN := FALSE;
3449: v_valid_att_mode BOOLEAN := FALSE;
3450: v_valid_att_type BOOLEAN := FALSE;
3451: v_valid_unit_set BOOLEAN := FALSE;
3452: v_location_cd IGS_AD_PS_APPL_INST_APLINST_V.location_cd%TYPE;
3453: v_attendance_mode IGS_AD_PS_APPL_INST_APLINST_V.attendance_mode%TYPE;
3454: v_attendance_type IGS_AD_PS_APPL_INST_APLINST_V.attendance_type%TYPE;
3455: v_unit_set_cd IGS_AD_PS_APPL_INST_APLINST_V.unit_set_cd%TYPE;
3456: v_us_version_number IGS_AD_PS_APPL_INST_APLINST_V.us_version_number%TYPE;

Line 3453: v_attendance_mode IGS_AD_PS_APPL_INST_APLINST_V.attendance_mode%TYPE;

3449: v_valid_att_mode BOOLEAN := FALSE;
3450: v_valid_att_type BOOLEAN := FALSE;
3451: v_valid_unit_set BOOLEAN := FALSE;
3452: v_location_cd IGS_AD_PS_APPL_INST_APLINST_V.location_cd%TYPE;
3453: v_attendance_mode IGS_AD_PS_APPL_INST_APLINST_V.attendance_mode%TYPE;
3454: v_attendance_type IGS_AD_PS_APPL_INST_APLINST_V.attendance_type%TYPE;
3455: v_unit_set_cd IGS_AD_PS_APPL_INST_APLINST_V.unit_set_cd%TYPE;
3456: v_us_version_number IGS_AD_PS_APPL_INST_APLINST_V.us_version_number%TYPE;
3457: v_ass_rank IGS_AD_PS_APPL_INST_APLINST_V.ass_rank%TYPE;

Line 3454: v_attendance_type IGS_AD_PS_APPL_INST_APLINST_V.attendance_type%TYPE;

3450: v_valid_att_type BOOLEAN := FALSE;
3451: v_valid_unit_set BOOLEAN := FALSE;
3452: v_location_cd IGS_AD_PS_APPL_INST_APLINST_V.location_cd%TYPE;
3453: v_attendance_mode IGS_AD_PS_APPL_INST_APLINST_V.attendance_mode%TYPE;
3454: v_attendance_type IGS_AD_PS_APPL_INST_APLINST_V.attendance_type%TYPE;
3455: v_unit_set_cd IGS_AD_PS_APPL_INST_APLINST_V.unit_set_cd%TYPE;
3456: v_us_version_number IGS_AD_PS_APPL_INST_APLINST_V.us_version_number%TYPE;
3457: v_ass_rank IGS_AD_PS_APPL_INST_APLINST_V.ass_rank%TYPE;
3458: v_intrntnl_accptnce_advice_num

Line 3455: v_unit_set_cd IGS_AD_PS_APPL_INST_APLINST_V.unit_set_cd%TYPE;

3451: v_valid_unit_set BOOLEAN := FALSE;
3452: v_location_cd IGS_AD_PS_APPL_INST_APLINST_V.location_cd%TYPE;
3453: v_attendance_mode IGS_AD_PS_APPL_INST_APLINST_V.attendance_mode%TYPE;
3454: v_attendance_type IGS_AD_PS_APPL_INST_APLINST_V.attendance_type%TYPE;
3455: v_unit_set_cd IGS_AD_PS_APPL_INST_APLINST_V.unit_set_cd%TYPE;
3456: v_us_version_number IGS_AD_PS_APPL_INST_APLINST_V.us_version_number%TYPE;
3457: v_ass_rank IGS_AD_PS_APPL_INST_APLINST_V.ass_rank%TYPE;
3458: v_intrntnl_accptnce_advice_num
3459: IGS_AD_PS_APPL_INST_APLINST_V.intrntnl_acceptance_advice_num%TYPE;

Line 3456: v_us_version_number IGS_AD_PS_APPL_INST_APLINST_V.us_version_number%TYPE;

3452: v_location_cd IGS_AD_PS_APPL_INST_APLINST_V.location_cd%TYPE;
3453: v_attendance_mode IGS_AD_PS_APPL_INST_APLINST_V.attendance_mode%TYPE;
3454: v_attendance_type IGS_AD_PS_APPL_INST_APLINST_V.attendance_type%TYPE;
3455: v_unit_set_cd IGS_AD_PS_APPL_INST_APLINST_V.unit_set_cd%TYPE;
3456: v_us_version_number IGS_AD_PS_APPL_INST_APLINST_V.us_version_number%TYPE;
3457: v_ass_rank IGS_AD_PS_APPL_INST_APLINST_V.ass_rank%TYPE;
3458: v_intrntnl_accptnce_advice_num
3459: IGS_AD_PS_APPL_INST_APLINST_V.intrntnl_acceptance_advice_num%TYPE;
3460: v_ass_tracking_id IGS_AD_PS_APPL_INST_APLINST_V.ass_tracking_id%TYPE;

Line 3457: v_ass_rank IGS_AD_PS_APPL_INST_APLINST_V.ass_rank%TYPE;

3453: v_attendance_mode IGS_AD_PS_APPL_INST_APLINST_V.attendance_mode%TYPE;
3454: v_attendance_type IGS_AD_PS_APPL_INST_APLINST_V.attendance_type%TYPE;
3455: v_unit_set_cd IGS_AD_PS_APPL_INST_APLINST_V.unit_set_cd%TYPE;
3456: v_us_version_number IGS_AD_PS_APPL_INST_APLINST_V.us_version_number%TYPE;
3457: v_ass_rank IGS_AD_PS_APPL_INST_APLINST_V.ass_rank%TYPE;
3458: v_intrntnl_accptnce_advice_num
3459: IGS_AD_PS_APPL_INST_APLINST_V.intrntnl_acceptance_advice_num%TYPE;
3460: v_ass_tracking_id IGS_AD_PS_APPL_INST_APLINST_V.ass_tracking_id%TYPE;
3461: v_fee_cat IGS_AD_PS_APPL_INST_APLINST_V.fee_cat%TYPE;

Line 3459: IGS_AD_PS_APPL_INST_APLINST_V.intrntnl_acceptance_advice_num%TYPE;

3455: v_unit_set_cd IGS_AD_PS_APPL_INST_APLINST_V.unit_set_cd%TYPE;
3456: v_us_version_number IGS_AD_PS_APPL_INST_APLINST_V.us_version_number%TYPE;
3457: v_ass_rank IGS_AD_PS_APPL_INST_APLINST_V.ass_rank%TYPE;
3458: v_intrntnl_accptnce_advice_num
3459: IGS_AD_PS_APPL_INST_APLINST_V.intrntnl_acceptance_advice_num%TYPE;
3460: v_ass_tracking_id IGS_AD_PS_APPL_INST_APLINST_V.ass_tracking_id%TYPE;
3461: v_fee_cat IGS_AD_PS_APPL_INST_APLINST_V.fee_cat%TYPE;
3462: v_expected_completion_yr IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_yr%TYPE;
3463: v_expected_completion_perd

Line 3460: v_ass_tracking_id IGS_AD_PS_APPL_INST_APLINST_V.ass_tracking_id%TYPE;

3456: v_us_version_number IGS_AD_PS_APPL_INST_APLINST_V.us_version_number%TYPE;
3457: v_ass_rank IGS_AD_PS_APPL_INST_APLINST_V.ass_rank%TYPE;
3458: v_intrntnl_accptnce_advice_num
3459: IGS_AD_PS_APPL_INST_APLINST_V.intrntnl_acceptance_advice_num%TYPE;
3460: v_ass_tracking_id IGS_AD_PS_APPL_INST_APLINST_V.ass_tracking_id%TYPE;
3461: v_fee_cat IGS_AD_PS_APPL_INST_APLINST_V.fee_cat%TYPE;
3462: v_expected_completion_yr IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_yr%TYPE;
3463: v_expected_completion_perd
3464: IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_perd%TYPE;

Line 3461: v_fee_cat IGS_AD_PS_APPL_INST_APLINST_V.fee_cat%TYPE;

3457: v_ass_rank IGS_AD_PS_APPL_INST_APLINST_V.ass_rank%TYPE;
3458: v_intrntnl_accptnce_advice_num
3459: IGS_AD_PS_APPL_INST_APLINST_V.intrntnl_acceptance_advice_num%TYPE;
3460: v_ass_tracking_id IGS_AD_PS_APPL_INST_APLINST_V.ass_tracking_id%TYPE;
3461: v_fee_cat IGS_AD_PS_APPL_INST_APLINST_V.fee_cat%TYPE;
3462: v_expected_completion_yr IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_yr%TYPE;
3463: v_expected_completion_perd
3464: IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_perd%TYPE;
3465: v_correspondence_cat IGS_AD_PS_APPL_INST_APLINST_V.correspondence_cat%TYPE;

Line 3462: v_expected_completion_yr IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_yr%TYPE;

3458: v_intrntnl_accptnce_advice_num
3459: IGS_AD_PS_APPL_INST_APLINST_V.intrntnl_acceptance_advice_num%TYPE;
3460: v_ass_tracking_id IGS_AD_PS_APPL_INST_APLINST_V.ass_tracking_id%TYPE;
3461: v_fee_cat IGS_AD_PS_APPL_INST_APLINST_V.fee_cat%TYPE;
3462: v_expected_completion_yr IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_yr%TYPE;
3463: v_expected_completion_perd
3464: IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_perd%TYPE;
3465: v_correspondence_cat IGS_AD_PS_APPL_INST_APLINST_V.correspondence_cat%TYPE;
3466: v_enrolment_cat IGS_AD_PS_APPL_INST_APLINST_V.enrolment_cat%TYPE;

Line 3464: IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_perd%TYPE;

3460: v_ass_tracking_id IGS_AD_PS_APPL_INST_APLINST_V.ass_tracking_id%TYPE;
3461: v_fee_cat IGS_AD_PS_APPL_INST_APLINST_V.fee_cat%TYPE;
3462: v_expected_completion_yr IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_yr%TYPE;
3463: v_expected_completion_perd
3464: IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_perd%TYPE;
3465: v_correspondence_cat IGS_AD_PS_APPL_INST_APLINST_V.correspondence_cat%TYPE;
3466: v_enrolment_cat IGS_AD_PS_APPL_INST_APLINST_V.enrolment_cat%TYPE;
3467: v_funding_source IGS_AD_PS_APPL_INST_APLINST_V.funding_source%TYPE;
3468: v_basis_for_admission_type

Line 3465: v_correspondence_cat IGS_AD_PS_APPL_INST_APLINST_V.correspondence_cat%TYPE;

3461: v_fee_cat IGS_AD_PS_APPL_INST_APLINST_V.fee_cat%TYPE;
3462: v_expected_completion_yr IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_yr%TYPE;
3463: v_expected_completion_perd
3464: IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_perd%TYPE;
3465: v_correspondence_cat IGS_AD_PS_APPL_INST_APLINST_V.correspondence_cat%TYPE;
3466: v_enrolment_cat IGS_AD_PS_APPL_INST_APLINST_V.enrolment_cat%TYPE;
3467: v_funding_source IGS_AD_PS_APPL_INST_APLINST_V.funding_source%TYPE;
3468: v_basis_for_admission_type
3469: IGS_AD_PS_APPL_INST_APLINST_V.basis_for_admission_type%TYPE;

Line 3466: v_enrolment_cat IGS_AD_PS_APPL_INST_APLINST_V.enrolment_cat%TYPE;

3462: v_expected_completion_yr IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_yr%TYPE;
3463: v_expected_completion_perd
3464: IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_perd%TYPE;
3465: v_correspondence_cat IGS_AD_PS_APPL_INST_APLINST_V.correspondence_cat%TYPE;
3466: v_enrolment_cat IGS_AD_PS_APPL_INST_APLINST_V.enrolment_cat%TYPE;
3467: v_funding_source IGS_AD_PS_APPL_INST_APLINST_V.funding_source%TYPE;
3468: v_basis_for_admission_type
3469: IGS_AD_PS_APPL_INST_APLINST_V.basis_for_admission_type%TYPE;
3470: v_admission_cd IGS_AD_PS_APPL_INST_APLINST_V.admission_cd%TYPE;

Line 3467: v_funding_source IGS_AD_PS_APPL_INST_APLINST_V.funding_source%TYPE;

3463: v_expected_completion_perd
3464: IGS_AD_PS_APPL_INST_APLINST_V.expected_completion_perd%TYPE;
3465: v_correspondence_cat IGS_AD_PS_APPL_INST_APLINST_V.correspondence_cat%TYPE;
3466: v_enrolment_cat IGS_AD_PS_APPL_INST_APLINST_V.enrolment_cat%TYPE;
3467: v_funding_source IGS_AD_PS_APPL_INST_APLINST_V.funding_source%TYPE;
3468: v_basis_for_admission_type
3469: IGS_AD_PS_APPL_INST_APLINST_V.basis_for_admission_type%TYPE;
3470: v_admission_cd IGS_AD_PS_APPL_INST_APLINST_V.admission_cd%TYPE;
3471: v_course_rank_set IGS_AD_PS_APPL_INST_APLINST_V.course_rank_set%TYPE;

Line 3469: IGS_AD_PS_APPL_INST_APLINST_V.basis_for_admission_type%TYPE;

3465: v_correspondence_cat IGS_AD_PS_APPL_INST_APLINST_V.correspondence_cat%TYPE;
3466: v_enrolment_cat IGS_AD_PS_APPL_INST_APLINST_V.enrolment_cat%TYPE;
3467: v_funding_source IGS_AD_PS_APPL_INST_APLINST_V.funding_source%TYPE;
3468: v_basis_for_admission_type
3469: IGS_AD_PS_APPL_INST_APLINST_V.basis_for_admission_type%TYPE;
3470: v_admission_cd IGS_AD_PS_APPL_INST_APLINST_V.admission_cd%TYPE;
3471: v_course_rank_set IGS_AD_PS_APPL_INST_APLINST_V.course_rank_set%TYPE;
3472: v_course_rank_schedule IGS_AD_PS_APPL_INST_APLINST_V.course_rank_schedule%TYPE;
3473: v_sca_fee_cat IGS_EN_STDNT_PS_ATT.fee_cat%TYPE;

Line 3470: v_admission_cd IGS_AD_PS_APPL_INST_APLINST_V.admission_cd%TYPE;

3466: v_enrolment_cat IGS_AD_PS_APPL_INST_APLINST_V.enrolment_cat%TYPE;
3467: v_funding_source IGS_AD_PS_APPL_INST_APLINST_V.funding_source%TYPE;
3468: v_basis_for_admission_type
3469: IGS_AD_PS_APPL_INST_APLINST_V.basis_for_admission_type%TYPE;
3470: v_admission_cd IGS_AD_PS_APPL_INST_APLINST_V.admission_cd%TYPE;
3471: v_course_rank_set IGS_AD_PS_APPL_INST_APLINST_V.course_rank_set%TYPE;
3472: v_course_rank_schedule IGS_AD_PS_APPL_INST_APLINST_V.course_rank_schedule%TYPE;
3473: v_sca_fee_cat IGS_EN_STDNT_PS_ATT.fee_cat%TYPE;
3474: v_sca_funding_source IGS_EN_STDNT_PS_ATT.funding_source%TYPE;

Line 3471: v_course_rank_set IGS_AD_PS_APPL_INST_APLINST_V.course_rank_set%TYPE;

3467: v_funding_source IGS_AD_PS_APPL_INST_APLINST_V.funding_source%TYPE;
3468: v_basis_for_admission_type
3469: IGS_AD_PS_APPL_INST_APLINST_V.basis_for_admission_type%TYPE;
3470: v_admission_cd IGS_AD_PS_APPL_INST_APLINST_V.admission_cd%TYPE;
3471: v_course_rank_set IGS_AD_PS_APPL_INST_APLINST_V.course_rank_set%TYPE;
3472: v_course_rank_schedule IGS_AD_PS_APPL_INST_APLINST_V.course_rank_schedule%TYPE;
3473: v_sca_fee_cat IGS_EN_STDNT_PS_ATT.fee_cat%TYPE;
3474: v_sca_funding_source IGS_EN_STDNT_PS_ATT.funding_source%TYPE;
3475: v_sca_correspondence_cat IGS_EN_STDNT_PS_ATT.correspondence_cat%TYPE;

Line 3472: v_course_rank_schedule IGS_AD_PS_APPL_INST_APLINST_V.course_rank_schedule%TYPE;

3468: v_basis_for_admission_type
3469: IGS_AD_PS_APPL_INST_APLINST_V.basis_for_admission_type%TYPE;
3470: v_admission_cd IGS_AD_PS_APPL_INST_APLINST_V.admission_cd%TYPE;
3471: v_course_rank_set IGS_AD_PS_APPL_INST_APLINST_V.course_rank_set%TYPE;
3472: v_course_rank_schedule IGS_AD_PS_APPL_INST_APLINST_V.course_rank_schedule%TYPE;
3473: v_sca_fee_cat IGS_EN_STDNT_PS_ATT.fee_cat%TYPE;
3474: v_sca_funding_source IGS_EN_STDNT_PS_ATT.funding_source%TYPE;
3475: v_sca_correspondence_cat IGS_EN_STDNT_PS_ATT.correspondence_cat%TYPE;
3476: v_scae_enrolment_cat IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;

Line 3499: FROM IGS_AD_PS_APPL_INST acaiv,

3495: acav.basis_for_admission_type,
3496: acav.admission_cd,
3497: acav.course_rank_set,
3498: acav.course_rank_schedule
3499: FROM IGS_AD_PS_APPL_INST acaiv,
3500: IGS_AD_PS_APPL acav
3501: WHERE acaiv.person_id = p_person_id AND
3502: acaiv.admission_appl_number = p_admission_appl_number AND
3503: acaiv.nominated_course_cd = p_nominated_course_cd AND

Line 3622: FROM igs_ad_ps_appl_inst

3618: hecs_payment_option,
3619: app_source_id,
3620: correspondence_cat,
3621: funding_source
3622: FROM igs_ad_ps_appl_inst
3623: WHERE person_id = p_person_id AND
3624: admission_appl_number = p_admission_appl_number AND
3625: nominated_course_cd = p_nominated_course_cd;
3626:

Line 3650: v_app_file_location1 igs_ad_ps_appl_inst.app_file_location%TYPE;

3646: AND name = final_decision_code
3647: AND system_status <> 'PENDING'
3648: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES');
3649:
3650: v_app_file_location1 igs_ad_ps_appl_inst.app_file_location%TYPE;
3651: v_late_adm_fee_status1 igs_ad_ps_appl_inst.late_adm_fee_status%TYPE;
3652: v_enrolment_cat1 igs_ad_ps_appl_inst.enrolment_cat%TYPE;
3653: v_fee_cat1 igs_ad_ps_appl_inst.fee_cat%TYPE;
3654: v_hecs_payment_option1 igs_ad_ps_appl_inst.hecs_payment_option%TYPE;

Line 3651: v_late_adm_fee_status1 igs_ad_ps_appl_inst.late_adm_fee_status%TYPE;

3647: AND system_status <> 'PENDING'
3648: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES');
3649:
3650: v_app_file_location1 igs_ad_ps_appl_inst.app_file_location%TYPE;
3651: v_late_adm_fee_status1 igs_ad_ps_appl_inst.late_adm_fee_status%TYPE;
3652: v_enrolment_cat1 igs_ad_ps_appl_inst.enrolment_cat%TYPE;
3653: v_fee_cat1 igs_ad_ps_appl_inst.fee_cat%TYPE;
3654: v_hecs_payment_option1 igs_ad_ps_appl_inst.hecs_payment_option%TYPE;
3655: v_app_source_id1 igs_ad_ps_appl_inst.app_source_id%TYPE;

Line 3652: v_enrolment_cat1 igs_ad_ps_appl_inst.enrolment_cat%TYPE;

3648: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES');
3649:
3650: v_app_file_location1 igs_ad_ps_appl_inst.app_file_location%TYPE;
3651: v_late_adm_fee_status1 igs_ad_ps_appl_inst.late_adm_fee_status%TYPE;
3652: v_enrolment_cat1 igs_ad_ps_appl_inst.enrolment_cat%TYPE;
3653: v_fee_cat1 igs_ad_ps_appl_inst.fee_cat%TYPE;
3654: v_hecs_payment_option1 igs_ad_ps_appl_inst.hecs_payment_option%TYPE;
3655: v_app_source_id1 igs_ad_ps_appl_inst.app_source_id%TYPE;
3656: v_correspondence_cat1 igs_ad_ps_appl_inst.correspondence_cat%TYPE;

Line 3653: v_fee_cat1 igs_ad_ps_appl_inst.fee_cat%TYPE;

3649:
3650: v_app_file_location1 igs_ad_ps_appl_inst.app_file_location%TYPE;
3651: v_late_adm_fee_status1 igs_ad_ps_appl_inst.late_adm_fee_status%TYPE;
3652: v_enrolment_cat1 igs_ad_ps_appl_inst.enrolment_cat%TYPE;
3653: v_fee_cat1 igs_ad_ps_appl_inst.fee_cat%TYPE;
3654: v_hecs_payment_option1 igs_ad_ps_appl_inst.hecs_payment_option%TYPE;
3655: v_app_source_id1 igs_ad_ps_appl_inst.app_source_id%TYPE;
3656: v_correspondence_cat1 igs_ad_ps_appl_inst.correspondence_cat%TYPE;
3657: v_funding_source1 igs_ad_ps_appl_inst.funding_source%TYPE;

Line 3654: v_hecs_payment_option1 igs_ad_ps_appl_inst.hecs_payment_option%TYPE;

3650: v_app_file_location1 igs_ad_ps_appl_inst.app_file_location%TYPE;
3651: v_late_adm_fee_status1 igs_ad_ps_appl_inst.late_adm_fee_status%TYPE;
3652: v_enrolment_cat1 igs_ad_ps_appl_inst.enrolment_cat%TYPE;
3653: v_fee_cat1 igs_ad_ps_appl_inst.fee_cat%TYPE;
3654: v_hecs_payment_option1 igs_ad_ps_appl_inst.hecs_payment_option%TYPE;
3655: v_app_source_id1 igs_ad_ps_appl_inst.app_source_id%TYPE;
3656: v_correspondence_cat1 igs_ad_ps_appl_inst.correspondence_cat%TYPE;
3657: v_funding_source1 igs_ad_ps_appl_inst.funding_source%TYPE;
3658: v_apply_for_finaid VARCHAR2(1);

Line 3655: v_app_source_id1 igs_ad_ps_appl_inst.app_source_id%TYPE;

3651: v_late_adm_fee_status1 igs_ad_ps_appl_inst.late_adm_fee_status%TYPE;
3652: v_enrolment_cat1 igs_ad_ps_appl_inst.enrolment_cat%TYPE;
3653: v_fee_cat1 igs_ad_ps_appl_inst.fee_cat%TYPE;
3654: v_hecs_payment_option1 igs_ad_ps_appl_inst.hecs_payment_option%TYPE;
3655: v_app_source_id1 igs_ad_ps_appl_inst.app_source_id%TYPE;
3656: v_correspondence_cat1 igs_ad_ps_appl_inst.correspondence_cat%TYPE;
3657: v_funding_source1 igs_ad_ps_appl_inst.funding_source%TYPE;
3658: v_apply_for_finaid VARCHAR2(1);
3659: BEGIN

Line 3656: v_correspondence_cat1 igs_ad_ps_appl_inst.correspondence_cat%TYPE;

3652: v_enrolment_cat1 igs_ad_ps_appl_inst.enrolment_cat%TYPE;
3653: v_fee_cat1 igs_ad_ps_appl_inst.fee_cat%TYPE;
3654: v_hecs_payment_option1 igs_ad_ps_appl_inst.hecs_payment_option%TYPE;
3655: v_app_source_id1 igs_ad_ps_appl_inst.app_source_id%TYPE;
3656: v_correspondence_cat1 igs_ad_ps_appl_inst.correspondence_cat%TYPE;
3657: v_funding_source1 igs_ad_ps_appl_inst.funding_source%TYPE;
3658: v_apply_for_finaid VARCHAR2(1);
3659: BEGIN
3660: -- Initialise the output 'valid' parameters

Line 3657: v_funding_source1 igs_ad_ps_appl_inst.funding_source%TYPE;

3653: v_fee_cat1 igs_ad_ps_appl_inst.fee_cat%TYPE;
3654: v_hecs_payment_option1 igs_ad_ps_appl_inst.hecs_payment_option%TYPE;
3655: v_app_source_id1 igs_ad_ps_appl_inst.app_source_id%TYPE;
3656: v_correspondence_cat1 igs_ad_ps_appl_inst.correspondence_cat%TYPE;
3657: v_funding_source1 igs_ad_ps_appl_inst.funding_source%TYPE;
3658: v_apply_for_finaid VARCHAR2(1);
3659: BEGIN
3660: -- Initialise the output 'valid' parameters
3661: IF (p_check_referee) THEN

Line 4848: -- Validate the IGS_AD_PS_APPL_INST.preference_number.

4844: IGS_GE_MSG_STACK.ADD;
4845: APP_EXCEPTION.RAISE_EXCEPTION;
4846: END admp_val_acaiu_defer;
4847: --
4848: -- Validate the IGS_AD_PS_APPL_INST.preference_number.
4849: FUNCTION admp_val_acai_pref(
4850: p_preference_number IN NUMBER ,
4851: p_pref_allowed IN VARCHAR2 ,
4852: p_pref_limit IN NUMBER ,

Line 4857: -- Validate the IGS_AD_PS_APPL_INST.preference_number.

4853: p_s_admission_process_type IN VARCHAR2 ,
4854: p_message_name OUT NOCOPY VARCHAR2 )
4855: RETURN BOOLEAN AS
4856: BEGIN -- admp_val_acai_pref
4857: -- Validate the IGS_AD_PS_APPL_INST.preference_number.
4858: -- Validations are -
4859: -- - Preference number must be specified for a course preference application.
4860: -- - If specified, the preference number must not exceed the preference limit.
4861: DECLARE