1 PACKAGE igs_en_gen_015 AS
2 /* $Header: IGSEN81S.pls 120.2 2005/11/25 03:00:54 appldev ship $ */
3 --
4 -- Function get_effective_census_date is used to get the effective
5 -- census date which will be used to check the effectiveness of the hold.
6 --
7 FUNCTION get_effective_census_date
8 (
9 p_load_cal_type IN VARCHAR2,
10 p_load_cal_seq_number IN NUMBER,
11 p_teach_cal_type IN VARCHAR2,
12 p_teach_cal_seq_number IN NUMBER
13 ) RETURN DATE;
14 --
15 -- Function validation_step_overridden is used to check if the given
16 -- Eligibility Step Type is overridden or not and also returns the
17 -- overridden credit point limit if any. (The overridden credit point limit
18 -- will not be present for all the steps. It will be applicable only
19 -- for "Minimum Credit Point Limit", "Maximum Credit Point Limit" and
20 -- "Variable Credit Point Limit" steps.
21 --
22 FUNCTION validation_step_is_overridden
23 (
24 p_eligibility_step_type IN VARCHAR2,
25 p_load_cal_type IN VARCHAR2,
26 p_load_cal_seq_number IN NUMBER,
27 p_person_id IN NUMBER,
28 p_uoo_id IN NUMBER,
29 p_step_override_limit OUT NOCOPY NUMBER
30 ) RETURN BOOLEAN;
31 --
32 -- Function seats_in_unreserved_category is used to check if there are seats
33 -- available in Unreserved Category.
34 --
35 FUNCTION seats_in_unreserved_category
36 (
37 p_uoo_id IN NUMBER,
38 p_level IN VARCHAR2
39 )
40 RETURN NUMBER;
41 --
42 --
43 -- This procedure is used to get the status of the Unit Section and Waitlist Indicator
44 -- whether waitlist is open for this section or not.
45 --
46 --
47 PROCEDURE get_usec_status
48 (
49 p_uoo_id IN NUMBER,
50 p_person_id IN NUMBER,
51 p_unit_section_status OUT NOCOPY VARCHAR2,
52 p_waitlist_ind OUT NOCOPY VARCHAR2,
53 p_load_cal_type IN VARCHAR2 DEFAULT NULL,
54 p_load_ci_sequence_number IN NUMBER DEFAULT NULL,
55 p_course_cd IN VARCHAR2 DEFAULT NULL
56 );
57 --
58 --
59 -- Procedure to get the Academic Calendar and Academic Calenar Sequence Number.
60 --
61 -- This Procedure is modified to add new column (p_effective_dt) in ENCR015 DLD
62
63 PROCEDURE get_academic_cal
64 (
65 p_person_id IN NUMBER,
66 p_course_cd IN VARCHAR2,
67 p_acad_cal_type OUT NOCOPY VARCHAR2,
68 p_acad_ci_sequence_number OUT NOCOPY NUMBER,
69 p_message OUT NOCOPY VARCHAR2,
70 p_effective_dt IN DATE DEFAULT SYSDATE
71 );
72 --
73 -- Function to check whether given Program Stage is completed by the given student.
74 --
75 FUNCTION enrp_val_ps_stage (
76 p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
77 p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
78 p_version_number NUMBER,
79 p_preference_code VARCHAR2
80 ) RETURN BOOLEAN;
81
82 --
83 -- Added as Part of ENCR013 DLD
84 -- This Function returns Approved Credit Points if exists for student in override table
85 --
86 FUNCTION enrp_get_appr_cr_pt(
87 p_person_id IN IGS_EN_SU_ATTEMPT.person_id%TYPE,
88 p_uoo_id IN IGS_EN_SU_ATTEMPT.uoo_id%TYPE
89 ) RETURN NUMBER;
90
91 --
92 -- Added as Part of ENCR015 DLD(Enh Bug : 2158654)
93 -- This Procedure finds the Effective Load Calendar for a given Academic Calendar
94 -- Modified the procedue by adding few more paramerers for bug# 2370100
95
96 PROCEDURE enrp_get_eff_load_ci (
97 p_person_id IN NUMBER,
98 p_course_cd IN VARCHAR2,
99 p_effective_dt IN DATE,
100 p_acad_cal_type OUT NOCOPY VARCHAR2,
101 p_acad_ci_seq_num OUT NOCOPY NUMBER,
102 p_load_cal_type OUT NOCOPY VARCHAR2,
103 p_load_ci_seq_num OUT NOCOPY NUMBER,
104 p_load_ci_alt_code OUT NOCOPY VARCHAR2,
105 p_load_ci_start_dt OUT NOCOPY DATE,
106 p_load_ci_end_dt OUT NOCOPY DATE,
107 p_message_name OUT NOCOPY VARCHAR2);
108
109 -- This Function is created as part of the ENCR015 DLD ( Enh Bug num : 2158654)
110 -- This Function returns the Derived Completion Date of a Student Program Attempt
111 --
112 FUNCTION enrf_drv_cmpl_dt (
113 p_person_id IN NUMBER,
114 p_course_cd IN VARCHAR2,
115 p_achieved_cp IN NUMBER DEFAULT NULL,
116 p_attendance_type IN VARCHAR2 DEFAULT NULL,
117 p_load_cal_type IN VARCHAR2 DEFAULT NULL,
118 p_load_ci_seq_num IN NUMBER DEFAULT NULL,
119 p_load_ci_alt_code IN VARCHAR2 DEFAULT NULL,
120 p_load_ci_start_dt IN DATE DEFAULT NULL,
121 p_load_ci_end_dt IN DATE DEFAULT NULL,
122 p_message_name OUT NOCOPY VARCHAR2
123 ) RETURN DATE;
124
125 PROCEDURE check_spl_perm_exists(
126 p_cal_type IN VARCHAR2,
127 p_ci_sequence_number IN NUMBER,
128 p_person_id IN NUMBER,
129 p_uoo_id IN NUMBER,
130 p_person_type IN VARCHAR2,
131 p_program_cd IN VARCHAR2,
132 p_message_name OUT NOCOPY VARCHAR2,
133 p_return_status OUT NOCOPY VARCHAR2,
134 p_check_audit IN VARCHAR2,
135 p_audit_status OUT NOCOPY VARCHAR2,
136 p_audit_msg_name OUT NOCOPY VARCHAR2);
137
138 PROCEDURE check_audit_perm_exists(
139 p_cal_type IN VARCHAR2,
140 p_ci_sequence_number IN NUMBER,
141 p_person_id IN NUMBER,
142 p_program_cd IN VARCHAR2,
143 p_uoo_id IN NUMBER,
144 p_person_type IN VARCHAR2,
145 p_enr_cat IN VARCHAR2,
146 p_enr_method IN VARCHAR2,
147 p_comm_type IN VARCHAR2,
148 p_return_status OUT NOCOPY VARCHAR2,
149 p_message_name OUT NOCOPY VARCHAR2);
150
151 --
152 -- Added as Part of EN213 Build
153 -- This Function checks whether the core unit attempt can be dropped.
154 --
155 FUNCTION eval_core_unit_drop
156 (
157 p_person_id IN NUMBER,
158 p_course_cd IN VARCHAR2,
159 p_uoo_id IN NUMBER,
160 p_step_type IN VARCHAR2,
161 p_term_cal IN VARCHAR2,
162 p_term_sequence_number IN NUMBER,
163 p_deny_warn OUT NOCOPY VARCHAR2,
164 p_enr_method IN VARCHAR2
165 )
166 RETURN VARCHAR2;
167
168 PROCEDURE get_curr_acad_term_cal (
169 p_acad_cal_type IN VARCHAR,
170 p_effective_dt IN DATE,
171 p_load_cal_type OUT NOCOPY VARCHAR2,
172 p_load_ci_seq_num OUT NOCOPY NUMBER,
173 p_load_ci_alt_code OUT NOCOPY VARCHAR2,
174 p_load_ci_start_dt OUT NOCOPY DATE,
175 p_load_ci_end_dt OUT NOCOPY DATE,
176 p_message_name OUT NOCOPY VARCHAR2);
177
178 PROCEDURE get_curr_term_for_schedule(
179 p_acad_cal_type IN VARCHAR,
180 p_effective_dt IN DATE,
181 p_load_cal_type OUT NOCOPY VARCHAR2,
182 p_load_ci_seq_num OUT NOCOPY NUMBER,
183 p_load_ci_alt_code OUT NOCOPY VARCHAR2,
184 p_load_ci_start_dt OUT NOCOPY DATE,
185 p_load_ci_end_dt OUT NOCOPY DATE,
186 p_message_name OUT NOCOPY VARCHAR2);
187
188 PROCEDURE get_academic_cal_poo_chg
189 (
190 p_person_id IN NUMBER,
191 p_course_cd IN VARCHAR2,
192 p_acad_cal_type IN OUT NOCOPY VARCHAR2,
193 p_acad_ci_sequence_number OUT NOCOPY NUMBER,
194 p_message OUT NOCOPY VARCHAR2,
195 p_effective_dt IN DATE DEFAULT SYSDATE
196 );
197
198 PROCEDURE enrp_get_eff_load_ci_poo_chg (
199 p_person_id IN NUMBER,
200 p_course_cd IN VARCHAR2,
201 p_effective_dt IN DATE,
202 p_acad_cal_type IN OUT NOCOPY VARCHAR2,
203 p_acad_ci_seq_num OUT NOCOPY NUMBER,
204 p_load_cal_type OUT NOCOPY VARCHAR2,
205 p_load_ci_seq_num OUT NOCOPY NUMBER,
206 p_load_ci_alt_code OUT NOCOPY VARCHAR2,
207 p_load_ci_start_dt OUT NOCOPY DATE,
208 p_load_ci_end_dt OUT NOCOPY DATE,
209 p_message_name OUT NOCOPY VARCHAR2);
210
211
212
213
214 END igs_en_gen_015;