1 PACKAGE igs_en_gen_legacy AS
2 /* $Header: IGSEN91S.pls 120.1 2005/10/28 04:14:32 appldev ship $ */
3
4 FUNCTION validate_grading_schm (
5 p_grade IN VARCHAR2 ,
6 p_uoo_id IN NUMBER ,
7 p_unit_cd IN VARCHAR2 ,
8 p_version_number IN NUMBER)
9 RETURN BOOLEAN ;
10
11 FUNCTION validate_disc_rsn_cd (
12 p_discontinuation_reason_cd IN VARCHAR2
13 ) RETURN BOOLEAN ;
14
15 FUNCTION validate_trn_unit (
16 p_person_id IN NUMBER ,
17 p_program_cd IN VARCHAR2 ,
18 p_cal_type IN VARCHAR2 ,
19 p_ci_sequence_number IN NUMBER ,
20 p_unit_cd IN VARCHAR2 ,
21 p_location_cd IN VARCHAR2 ,
22 P_unit_class IN VARCHAR2 ,
23 p_unit_attempt_status OUT NOCOPY VARCHAR2
24 ) RETURN BOOLEAN ;
25
26 FUNCTION validate_transfer (
27 p_person_id IN NUMBER ,
28 p_transfer_program_cd IN VARCHAR2
29 ) RETURN BOOLEAN ;
30
31 FUNCTION get_uoo_id (
32 p_cal_type IN VARCHAR2 ,
33 p_ci_sequence_number IN NUMBER ,
34 p_unit_cd IN VARCHAR2 ,
35 p_location_cd IN VARCHAR2 ,
36 P_unit_class IN VARCHAR2 ,
37 p_version_number IN NUMBER ,
38 p_uoo_id OUT NOCOPY NUMBER ,
39 p_owner_org_unit_cd OUT NOCOPY VARCHAR2
40 ) RETURN BOOLEAN ;
41
42 FUNCTION get_unit_ver (
43 p_cal_type IN VARCHAR2 ,
44 p_ci_sequence_number IN NUMBER ,
45 p_unit_cd IN VARCHAR2 ,
46 p_location_cd IN VARCHAR2 ,
47 P_unit_class IN VARCHAR2 ,
48 p_version_number OUT NOCOPY NUMBER
49 ) RETURN BOOLEAN ;
50
51 FUNCTION validate_grad_sch_cd_ver (
52 p_uoo_id IN NUMBER ,
53 p_unit_cd IN VARCHAR2 ,
54 p_version_number IN NUMBER ,
55 p_grading_schema_code IN VARCHAR2 ,
56 p_gs_version_number IN NUMBER ,
57 P_message_name OUT NOCOPY VARCHAR2 )
58 RETURN BOOLEAN ;
59
60 FUNCTION validate_prgm_att_stat (
61 p_person_id IN NUMBER ,
62 p_course_cd IN VARCHAR2 ,
63 p_discontin_dt OUT NOCOPY DATE ,
64 p_program_type OUT NOCOPY VARCHAR2 ,
65 p_commencement_dt OUT NOCOPY DATE ,
66 p_version_number OUT NOCOPY NUMBER)
67 RETURN VARCHAR2;
68
69 PROCEDURE get_last_dt_of_att (
70 x_person_id IN NUMBER,
71 x_course_cd IN VARCHAR2,
72 x_last_date_of_attendance OUT NOCOPY DATE );
73
74 FUNCTION get_coo_id(
75 p_course_cd IN igs_ps_ofr_opt.course_cd%TYPE,
76 p_version_number IN igs_ps_ofr_opt.version_number%TYPE,
77 p_cal_type IN igs_ps_ofr_opt.cal_type%TYPE,
78 p_location_cd IN igs_ps_ofr_opt.location_cd%TYPE,
79 p_attendance_mode IN igs_ps_ofr_opt.attendance_mode%TYPE,
80 p_attendance_type IN igs_ps_ofr_opt.attendance_type%TYPE)
81 RETURN igs_ps_ofr_opt.coo_id%TYPE;
82
83 FUNCTION get_class_std_id(
84 p_class_standing IN igs_pr_class_std.class_standing%TYPE)
85 RETURN igs_pr_class_std.igs_pr_class_std_id%TYPE;
86
87 FUNCTION get_course_att_status(
88 p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
89 p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
90 p_student_confirmed_ind IN igs_en_stdnt_ps_att.student_confirmed_ind%TYPE,
91 p_discontinued_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
92 p_lapsed_dt IN igs_en_stdnt_ps_att.lapsed_dt%TYPE,
93 p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
94 p_primary_pg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
95 p_primary_prog_type_source IN igs_en_stdnt_ps_att.primary_prog_type_source%TYPE,
96 p_course_type IN igs_ps_type.course_type%TYPE,
97 p_career_flag IN VARCHAR2)
98 RETURN igs_en_stdnt_ps_att.course_attempt_status%TYPE;
99
100 FUNCTION get_sca_dropped_by
101 RETURN igs_en_stdnt_ps_att.dropped_by%TYPE;
102
103 FUNCTION get_sca_prog_type(
104 p_course_cd IN igs_ps_ver.course_cd%TYPE,
105 p_version_number IN igs_ps_ver.version_number%TYPE)
106 RETURN igs_ps_ver.course_type%TYPE;
107
108 FUNCTION val_sca_start_dt (
109 p_student_confirmed_ind IN igs_en_stdnt_ps_att.student_confirmed_ind%TYPE,
110 p_commencement_dt IN igs_en_stdnt_ps_att.commencement_dt%TYPE)
111 RETURN BOOLEAN;
112
113 FUNCTION val_sca_disc_date(
114 p_discontinued_dt igs_en_stdnt_ps_att.discontinued_dt%TYPE)
115 RETURN BOOLEAN;
116
117 FUNCTION val_sca_reqcmpl_dt(
118 p_course_rqrmnt_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
119 p_course_rqrmnts_comp_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
120 p_message_name OUT NOCOPY VARCHAR2)
121 RETURN BOOLEAN;
122
123 FUNCTION val_sca_key_prg(
124 p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
125 p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
126 p_key_program IN igs_en_stdnt_ps_att.key_program%TYPE,
127 p_primary_prg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
128 p_course_attempt_st IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,
129 p_career_flag VARCHAR2)
130 RETURN BOOLEAN;
131
132 FUNCTION val_sca_primary_pg(
133 p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
134 p_primary_prog_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
135 p_course_type IN igs_ps_type.course_type%TYPE)
136 RETURN BOOLEAN;
137
138 FUNCTION val_sca_comp_flag (
139 p_course_attempt_status IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,
140 p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE)
141 RETURN BOOLEAN;
142
143 FUNCTION val_sca_per_type(
144 p_person_id igs_en_stdnt_ps_att.person_id%TYPE,
145 p_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
146 p_course_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE)
147 RETURN BOOLEAN;
148
149
150
151
152 FUNCTION check_pre_enroll_prof (
153 p_unit_set_cd IN igs_as_su_setatmpt.unit_set_cd%TYPE,
154 p_us_version_number IN igs_as_su_setatmpt.us_version_number%TYPE)
155 RETURN BOOLEAN;
156
157
158 FUNCTION check_usa_overlap (
159 p_person_id IN igs_as_su_setatmpt.person_id%TYPE,
160 p_program_cd IN igs_as_su_setatmpt.course_cd%TYPE,
161 p_selection_dt IN igs_as_su_setatmpt.selection_dt%TYPE,
162 p_rqrmnts_complete_dt IN igs_as_su_setatmpt.rqrmnts_complete_dt%TYPE,
163 p_end_dt IN igs_as_su_setatmpt.end_dt%TYPE,
164 p_sequence_number IN igs_as_su_setatmpt.sequence_number%TYPE,
165 p_unit_set_cd IN igs_as_su_setatmpt.unit_set_cd%TYPE DEFAULT NULL,
166 p_us_version_number IN igs_as_su_setatmpt.us_version_number%TYPE DEFAULT NULL,
167 p_message_name OUT NOCOPY VARCHAR2)
168 RETURN BOOLEAN;
169
170
171 FUNCTION check_dup_susa (
172 p_person_id IN igs_as_su_setatmpt.person_id%TYPE,
173 p_program_cd IN igs_as_su_setatmpt.course_cd%TYPE,
174 p_unit_set_cd IN igs_as_su_setatmpt.unit_set_cd%TYPE,
175 p_us_version_number IN igs_as_su_setatmpt.us_version_number%TYPE,
176 p_selection_dt IN igs_as_su_setatmpt.selection_dt%TYPE)
177 RETURN BOOLEAN;
178
179 FUNCTION validate_intm_ua_ovrlp (
180 p_person_id IN igs_en_stdnt_ps_intm.person_id%TYPE,
181 p_program_cd IN igs_en_stdnt_ps_intm.course_cd%TYPE,
182 p_start_dt IN igs_en_stdnt_ps_intm.start_dt%TYPE,
183 p_end_dt IN igs_en_stdnt_ps_intm.end_dt%TYPE
184 ) RETURN BOOLEAN;
185
186
187 FUNCTION check_approv_reqd (
188 p_intermission_type IN igs_en_stdnt_ps_intm.intermission_type%TYPE
189 ) RETURN BOOLEAN;
190
191
192 FUNCTION check_study_antr_instu (
193 p_intermission_type IN igs_en_stdnt_ps_intm.intermission_type%TYPE
194 ) RETURN BOOLEAN;
195
196
197 FUNCTION check_institution (
198 p_institution_name IN igs_en_stdnt_ps_intm.institution_name%TYPE
199 ) RETURN BOOLEAN;
200
201
202 FUNCTION check_sca_status_upd (
203 p_person_id IN igs_en_stdnt_ps_intm.person_id%TYPE,
204 p_program_cd IN igs_en_stdnt_ps_intm.course_cd%TYPE,
205 p_called_from IN VARCHAR2,
206 p_course_attempt_status OUT NOCOPY igs_en_stdnt_ps_att.course_attempt_status%TYPE
207 ) RETURN BOOLEAN;
208
209 FUNCTION validate_awd_offer_pgm(
210 p_person_id IN NUMBER,
211 p_program_cd IN VARCHAR2,
212 p_award_cd IN VARCHAR2
213 ) RETURN BOOLEAN;
214
215
216 END igs_en_gen_legacy;