1 PACKAGE igs_en_elgbl_program AS
2 /* $Header: IGSEN79S.pls 120.2 2005/07/13 02:45:39 appldev ship $ */
3
4 /******************************************************************
5 Created By : Vinay Chappidi
6 Date Created By : 19-JUN-2001
7 Purpose : When the user tries to finalize the units he has selected
8 for enrolment, program level validations have to be carried
9 on before the user is actuall enroled. These function's are
10 meant for calling from the Self-Service applications
11
12 Known limitations,
13 enhancements,
14 remarks :
15 Change History
16 Who When What
17 ckasu 15-Jul-2005 Modified eval_program_steps,eval_max_cp,eval_min_cp,eval_unit_forced_type,
18 eval_cross_validation,eval_fail_min_cp Functions spec by adding
19 p_calling_obj as a part of EN317 SS UI Build bug#4377985
20 knaraset 04-Nov-2003 Added functions get_applied_min_cp, get_applied_max_cp as part of TD EN212
21 svenkata 6-Jun-2003 Added the routine eval_cross_validation to check for Cross element
22 Validations - Bug 2829272.
23 amuthu 27-JAN-2003 Change the data type of two out variables from number
24 to varchar in get_per_min_max
25 svenkata 23-Jan-2003 Added new routines calc_min_cp, calc_max_cp and get_per_min_max_cp Bug#2728260.
26 Nishikant 17OCT2002 Enrl Elgbl and Validation Build. Enh Bug#2616692.
27 Four parameters p_enrollment_category, p_comm_type, p_method_type,
28 p_min_credit_point added to the signature of the Function eval_min_cp.
29 Also the parameter p_credit_points made as IN/OUT instead of IN.
30 Three parameters p_enrollment_category, p_comm_type, p_method_type added
31 to the signature of the function eval_unit_forced_type.
32 A new function eval_fail_min_cp has been added.
33 A new Procedure stdnt_crd_pnt_enrl_workflow has been added to raise a
34 bussiness event to send notification to the student that he/she has failed the
35 Minimum CP Validation.
36 ******************************************************************/
37
38 FUNCTION eval_max_cp ( p_person_id NUMBER,
39 p_load_calendar_type VARCHAR2,
40 p_load_cal_sequence_number NUMBER,
41 p_uoo_id NUMBER,
42 p_program_cd VARCHAR2,
43 p_program_version VARCHAR2,
44 p_message OUT NOCOPY VARCHAR2,
45 p_deny_warn VARCHAR2,
46 p_upd_cp IN NUMBER DEFAULT NULL,
47 p_calling_obj IN VARCHAR2
48 ) RETURN BOOLEAN;
49 FUNCTION eval_min_cp( p_person_id NUMBER,
50 p_load_calendar_type VARCHAR2,
51 p_load_cal_sequence_number NUMBER,
52 p_uoo_id NUMBER,
53 p_program_cd VARCHAR2,
54 p_program_version VARCHAR2,
55 p_message OUT NOCOPY VARCHAR2,
56 p_deny_warn VARCHAR2,
57 p_credit_points IN OUT NOCOPY NUMBER,
58 p_enrollment_category IN VARCHAR2 DEFAULT NULL,
59 p_comm_type IN VARCHAR2 DEFAULT NULL,
60 p_method_type IN VARCHAR2 DEFAULT NULL,
61 p_min_credit_point IN OUT NOCOPY NUMBER,
62 p_calling_obj IN VARCHAR2
63 ) RETURN BOOLEAN;
64 FUNCTION eval_program_steps( p_person_id NUMBER,
65 p_person_type VARCHAR2,
66 p_load_calendar_type VARCHAR2,
67 p_load_cal_sequence_number NUMBER,
68 p_uoo_id NUMBER,
69 p_program_cd VARCHAR2,
70 p_program_version VARCHAR2,
71 p_enrollment_category VARCHAR2,
72 p_comm_type VARCHAR2,
73 p_method_type VARCHAR2,
74 p_message OUT NOCOPY VARCHAR2,
75 p_deny_warn OUT NOCOPY VARCHAR2,
76 p_calling_obj IN VARCHAR2
77 ) RETURN BOOLEAN;
78 FUNCTION eval_unit_forced_type( p_person_id NUMBER,
79 p_load_calendar_type VARCHAR2,
80 p_load_cal_sequence_number VARCHAR2,
81 p_uoo_id NUMBER,
82 p_course_cd VARCHAR2,
83 p_course_version VARCHAR2,
84 p_message OUT NOCOPY VARCHAR2,
85 p_deny_warn VARCHAR2,
86 p_enrollment_category IN VARCHAR2 DEFAULT NULL,
87 p_comm_type IN VARCHAR2 DEFAULT NULL,
88 p_method_type IN VARCHAR2 DEFAULT NULL,
89 p_calling_obj IN VARCHAR2
90 ) RETURN BOOLEAN;
91 FUNCTION eval_fail_min_cp(
92 p_person_id NUMBER,
93 p_course_cd VARCHAR2,
94 p_version_number NUMBER,
95 p_acad_cal VARCHAR2,
96 p_load_cal VARCHAR2,
97 p_load_ci_sequence_number NUMBER,
98 p_method VARCHAR2
99 ) RETURN VARCHAR2;
100 PROCEDURE stdnt_crd_pnt_enrl_workflow(
101 p_user_name IN VARCHAR2,
102 p_course_cd IN VARCHAR2,
103 p_version_number IN NUMBER,
104 p_enrolled_cp IN NUMBER,
105 p_min_cp IN NUMBER
106 );
107
108 FUNCTION calc_min_cp (
109 p_person_id NUMBER,
110 p_load_calendar_type VARCHAR2,
111 p_load_cal_sequence_number NUMBER,
112 p_uoo_id NUMBER,
113 p_program_cd VARCHAR2,
114 p_program_version VARCHAR2,
115 p_message OUT NOCOPY VARCHAR2
116 ) RETURN NUMBER ;
117
118 FUNCTION calc_max_cp (
119 p_person_id NUMBER,
120 p_load_calendar_type VARCHAR2,
121 p_load_cal_sequence_number NUMBER,
122 p_uoo_id NUMBER,
123 p_program_cd VARCHAR2,
124 p_program_version VARCHAR2,
125 p_message OUT NOCOPY VARCHAR2
126 ) RETURN NUMBER ;
127
128 PROCEDURE get_per_min_max_cp
129 (
130 p_person_id NUMBER,
131 p_load_calendar_type VARCHAR2,
132 p_load_cal_sequence_number NUMBER,
133 p_program_cd VARCHAR2,
134 p_program_version VARCHAR2,
135 p_min_cp OUT NOCOPY VARCHAR2 ,
136 p_max_cp OUT NOCOPY VARCHAR2 ,
137 p_message OUT NOCOPY VARCHAR2
138 ) ;
139
140 FUNCTION eval_cross_validation(
141 p_person_id IN NUMBER ,
142 p_course_cd IN VARCHAR2 ,
143 p_program_version IN VARCHAR2,
144 p_uoo_id IN NUMBER,
145 p_load_cal_type IN VARCHAR2 ,
146 p_load_ci_sequence_number IN NUMBER ,
147 p_deny_warn IN VARCHAR2,
148 p_upd_cp IN NUMBER ,
149 p_eligibility_step_type IN VARCHAR2 ,
150 p_message IN OUT NOCOPY VARCHAR2,
151 p_calling_obj IN VARCHAR2
152 ) RETURN BOOLEAN ;
153
154
155 FUNCTION get_applied_min_cp (
156 p_person_id IN NUMBER,
157 p_term_cal_type IN VARCHAR2,
158 p_term_sequence_number IN NUMBER,
159 p_program_cd IN VARCHAR2,
160 p_program_version IN VARCHAR2
161 ) RETURN NUMBER;
162
163 FUNCTION get_applied_max_cp (
164 p_person_id IN NUMBER,
165 p_term_cal_type IN VARCHAR2,
166 p_term_sequence_number IN NUMBER,
167 p_program_cd IN VARCHAR2,
168 p_program_version IN VARCHAR2
169 ) RETURN NUMBER;
170
171 END igs_en_elgbl_program ;