1 PACKAGE IGS_EN_PLAN_UTILS AS
2 /* $Header: IGSEN94S.pls 120.3 2006/08/24 07:29:33 bdeviset noship $ */
3
4
5 PROCEDURE add_units_to_plan(P_PERSON_ID IN NUMBER,
6 P_COURSE_CD IN VARCHAR2,
7 P_LOAD_CAL_TYPE IN VARCHAR2,
8 P_LOAD_SEQUENCE_NUMBER IN NUMBER,
9 P_UOO_IDS IN VARCHAR2,
10 P_RETURN_STATUS OUT NOCOPY VARCHAR2,
11 P_MESSAGE_NAME OUT NOCOPY VARCHAR2,
12 p_ss_session_id IN NUMBER);
13
14 PROCEDURE update_spa_terms_plan_sht_flag(
15 P_PERSON_ID IN NUMBER,
16 P_COURSE_CD IN VARCHAR2,
17 P_TERM_CAL_TYPE IN VARCHAR2,
18 P_TERM_SEQUENCE_NUMBER IN NUMBER,
19 P_PLAN_SHT_FLAG IN VARCHAR2
20 );
21 PROCEDURE update_plansheet_unitdetails(
22 P_PERSON_ID IN NUMBER,
23 P_COURSE_CD IN VARCHAR2,
24 P_UOOID IN NUMBER,
25 P_CARTFLAG IN VARCHAR2,
26 P_SOURCEFLAG IN VARCHAR2,
27 P_FIELDNAME IN VARCHAR2,
28 P_auditVAL IN VARCHAR2,
29 P_creditVAL IN NUMBER,
30 P_gradingVAL IN VARCHAR2
31 );
32
33 PROCEDURE delete_plansheet_unit(
34 P_PERSON_ID IN NUMBER,
35 P_COURSE_CD IN VARCHAR2,
36 P_UOOID IN NUMBER,
37 P_CARTFLAG IN VARCHAR2,
38 p_return_status OUT NOCOPY VARCHAR2,
39 p_message_name OUT NOCOPY VARCHAR2
40 );
41
42 PROCEDURE delete_sua_from_plan(
43 p_person_id IN NUMBER,
44 p_course_cd IN VARCHAR2,
45 p_uoo_id IN NUMBER,
46 p_tch_cal IN VARCHAR2,
47 p_tch_seq IN NUMBER,
48 p_term_cal IN VARCHAR2,
49 p_term_seq_num IN NUMBER,
50 p_core IN VARCHAR2,
51 p_return_status OUT NOCOPY VARCHAR2,
52 p_message_name OUT NOCOPY VARCHAR2
53 );
54
55 PROCEDURE is_core_replaced(p_n_person_id IN NUMBER,
56 p_c_program_code IN VARCHAR2,
57 p_n_program_ver IN NUMBER,
58 p_c_load_cal IN VARCHAR2,
59 p_n_load_seq_num IN NUMBER,
60 p_c_core_uoo_ids IN VARCHAR2,
61 p_ss_session_id IN NUMBER);
62
63 PROCEDURE swap_delete ( p_person_id IN NUMBER,
64 p_course_cd IN VARCHAR2,
65 p_course_version IN NUMBER,
66 p_usec_dtls IN VARCHAR2,
67 p_uoo_id IN NUMBER,
68 p_term_cal IN VARCHAR2,
69 p_term_seq_num IN NUMBER,
70 p_core IN VARCHAR2,
71 p_rel_type IN VARCHAR2,
72 p_ret_status OUT NOCOPY VARCHAR2,
73 p_msg OUT NOCOPY VARCHAR2);
74
75 Procedure swap_submit (person_id IN NUMBER,
76 program_cd IN VARCHAR2,
77 p_uoo_ids IN VARCHAR2);
78 PROCEDURE swap_drop (
79 p_uoo_ids IN VARCHAR2,
80 p_person_id IN NUMBER,
81 p_person_type IN VARCHAR2,
82 p_load_cal_type IN VARCHAR2,
83 p_load_sequence_number IN NUMBER,
84 p_program_cd IN VARCHAR2,
85 p_program_version IN NUMBER ,
86 p_message OUT NOCOPY VARCHAR2,
87 p_ret_status OUT NOCOPY VARCHAR2,
88 p_ss_session_id IN NUMBER);
89
90 PROCEDURE release_swap_cart(p_n_person_id IN NUMBER,
91 p_c_program_code IN VARCHAR2,
92 p_c_load_cal IN VARCHAR2,
93 p_n_load_seq_num IN NUMBER);
94
95
96
97 FUNCTION is_credit_updatable( p_person_id IN NUMBER,
98 p_course_cd IN NUMBER,
99 p_uoo_id IN NUMBER,
100 p_cal_type IN VARCHAR2,
101 p_ci_sequence_number IN NUMBER
102 ) RETURN CHAR ;
103
104 PROCEDURE swap_update(
105 p_person_id IN NUMBER,
106 p_course_cd IN VARCHAR2,
107 p_uooid IN NUMBER,
108 p_fieldname IN VARCHAR2,
109 p_auditval IN VARCHAR2,
110 p_creditval IN NUMBER,
111 p_gradingval IN VARCHAR2,
112 X_ROWID IN VARCHAR2,
113 X_UNIT_CD IN VARCHAR2,
114 X_CAL_TYPE IN VARCHAR2,
115 X_CI_SEQUENCE_NUMBER IN NUMBER,
116 X_VERSION_NUMBER IN NUMBER,
117 X_LOCATION_CD IN VARCHAR2,
118 X_UNIT_CLASS IN VARCHAR2,
119 X_CI_START_DT IN DATE,
120 X_CI_END_DT IN DATE,
121 X_ENROLLED_DT IN DATE,
122 X_UNIT_ATTEMPT_STATUS IN VARCHAR2,
123 X_ADMINISTRATIVE_UNIT_STATUS IN VARCHAR2,
124 X_DISCONTINUED_DT IN DATE,
125 X_RULE_WAIVED_DT IN DATE,
126 X_RULE_WAIVED_PERSON_ID IN NUMBER,
127 X_NO_ASSESSMENT_IND IN VARCHAR2,
128 X_SUP_UNIT_CD IN VARCHAR2,
129 X_SUP_VERSION_NUMBER IN NUMBER,
130 X_EXAM_LOCATION_CD IN VARCHAR2,
131 X_ALTERNATIVE_TITLE IN VARCHAR2,
132 X_OVERRIDE_ENROLLED_CP IN NUMBER,
133 X_OVERRIDE_EFTSU IN NUMBER,
134 X_OVERRIDE_ACHIEVABLE_CP IN NUMBER,
135 X_OVERRIDE_OUTCOME_DUE_DT IN DATE,
136 X_OVERRIDE_CREDIT_REASON IN VARCHAR2,
137 X_ADMINISTRATIVE_PRIORITY IN NUMBER,
138 X_WAITLIST_DT IN DATE,
139 X_DCNT_REASON_CD IN VARCHAR2,
140 X_GS_VERSION_NUMBER IN NUMBER,
141 X_ENR_METHOD_TYPE IN VARCHAR2,
142 X_FAILED_UNIT_RULE IN VARCHAR2,
143 X_CART IN VARCHAR2,
144 X_RSV_SEAT_EXT_ID IN NUMBER,
145 X_ORG_UNIT_CD IN VARCHAR2,
146 X_GRADING_SCHEMA_CODE IN VARCHAR2,
147 X_subtitle IN VARCHAR2,
148 x_session_id IN NUMBER,
149 X_deg_aud_detail_id IN NUMBER,
150 x_student_career_transcript IN VARCHAR2,
151 x_student_career_statistics IN VARCHAR2,
152 x_waitlist_manual_ind IN VARCHAR2,
153 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
154 X_ATTRIBUTE1 IN VARCHAR2,
155 X_ATTRIBUTE2 IN VARCHAR2,
156 X_ATTRIBUTE3 IN VARCHAR2,
157 X_ATTRIBUTE4 IN VARCHAR2,
158 X_ATTRIBUTE5 IN VARCHAR2,
159 X_ATTRIBUTE6 IN VARCHAR2,
160 X_ATTRIBUTE7 IN VARCHAR2,
161 X_ATTRIBUTE8 IN VARCHAR2,
162 X_ATTRIBUTE9 IN VARCHAR2,
163 X_ATTRIBUTE10 IN VARCHAR2,
164 X_ATTRIBUTE11 IN VARCHAR2,
165 X_ATTRIBUTE12 IN VARCHAR2,
166 X_ATTRIBUTE13 IN VARCHAR2,
167 X_ATTRIBUTE14 IN VARCHAR2,
168 X_ATTRIBUTE15 IN VARCHAR2,
169 X_ATTRIBUTE16 IN VARCHAR2,
170 X_ATTRIBUTE17 IN VARCHAR2,
171 X_ATTRIBUTE18 IN VARCHAR2,
172 X_ATTRIBUTE19 IN VARCHAR2,
173 x_ATTRIBUTE20 IN VARCHAR2,
174 X_WLST_PRIORITY_WEIGHT_NUM IN NUMBER,
175 X_WLST_PREFERENCE_WEIGHT_NUM IN NUMBER,
176 X_CORE_INDICATOR_CODE IN VARCHAR2,
177 X_UPD_AUDIT_FLAG IN VARCHAR2,
178 X_SS_SOURCE_IND IN VARCHAR2);
179
180 PROCEDURE plan_update(
181 p_person_id IN NUMBER,
182 p_course_cd IN VARCHAR2,
183 p_uoo_id IN NUMBER,
184 p_fieldname IN VARCHAR2,
185 p_auditval IN VARCHAR2,
186 p_creditval IN NUMBER,
187 p_gradingval IN VARCHAR2,
188 p_row_id IN VARCHAR2,
189 p_term_cal_type IN VARCHAR2,
190 p_term_ci_sequence_number IN NUMBER,
191 p_no_assessment_ind IN VARCHAR2,
192 p_sup_uoo_id IN NUMBER,
193 p_override_enrolled_cp IN NUMBER,
194 p_grading_schema_code IN VARCHAR2,
195 p_gs_version_number IN NUMBER,
196 p_core_indicator_code IN VARCHAR2,
197 p_alternative_title IN VARCHAR2,
198 p_cart_error_flag IN VARCHAR2,
199 p_session_id IN NUMBER
200 );
201
202
203 PROCEDURE drop_submit (person_id IN NUMBER,
204 program_cd IN VARCHAR2,
205 p_uoo_ids IN VARCHAR2) ;
206
207 FUNCTION get_sua_fin_mark(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,
208 p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,
209 p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE) RETURN NUMBER ;
210
211 FUNCTION get_sua_fin_grade(p_person_id IN igs_en_su_attempt_all.person_id%TYPE,
212 p_course_cd IN igs_en_su_attempt_all.course_Cd%TYPE,
213 p_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE) RETURN VARCHAR2;
214
215 END IGS_EN_PLAN_UTILS;