1 PACKAGE igs_en_enroll_wlst AS
2 /* $Header: IGSEN73S.pls 120.3 2005/09/26 05:08:47 appldev ship $ */
3
4
5 /** Unit - For the Existing Unit validations **/
6
7 FUNCTION validate_unit (
8 p_unit_cd IN igs_ps_unit_ofr_opt.unit_cd%TYPE,
9 p_version_number IN igs_ps_unit_ofr_opt.version_number%TYPE,
10 p_cal_type IN igs_ps_unit_ofr_opt.cal_type%TYPE,
11 p_ci_sequence_number IN igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
12 p_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
13 p_person_id IN IGS_EN_SU_ATTEMPT.person_id%TYPE,
14 p_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,
15 p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
16 p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE,
17 p_deny_warn OUT NOCOPY VARCHAR2,
18 p_course_cd IN IGS_EN_SU_ATTEMPT.course_cd%TYPE)
19
20 RETURN BOOLEAN;
21
22
23 /** Program - For the validations Programs **/
24 FUNCTION validate_prog (
25 p_person_id igs_en_su_attempt.person_id%TYPE,
26 p_cal_type igs_ca_inst.cal_type%TYPE,
27 p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
28 p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
29 p_course_cd igs_en_su_attempt.course_cd%TYPE,
30 p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
31 p_message_name OUT NOCOPY VARCHAR2,
32 p_deny_warn OUT NOCOPY VARCHAR2)
33 RETURN BOOLEAN;
34
35 /** Unit Steps - For the validations Unit Steps **/
36 FUNCTION validate_unit_steps(
37 p_person_id igs_en_su_attempt.person_id%TYPE,
38 p_cal_type igs_ca_inst.cal_type%TYPE,
39 p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
40 p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
41 p_course_cd igs_en_su_attempt.course_cd%TYPE,
42 p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
43 p_message_name OUT NOCOPY VARCHAR2,
44 p_deny_warn OUT NOCOPY VARCHAR2,
45 p_calling_obj IN VARCHAR2)
46 RETURN BOOLEAN;
47
48 /** For Combined validations for Unit Steps and Units - Not used in this package for external use**/
49 FUNCTION validate_combined_unit(
50 p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
51 p_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
52 p_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
53 p_cal_type igs_ca_inst.cal_type%TYPE,
54 p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
55 p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
56 p_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
57 p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
58 p_course_cd igs_en_su_attempt.course_cd%TYPE,
59 p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
60 p_message_name OUT NOCOPY VARCHAR2,
61 p_deny_warn OUT NOCOPY VARCHAR2,
62 p_calling_obj IN VARCHAR2)
63 RETURN BOOLEAN;
64
65
66 /** Finalize Unit - For All the validations - Unit , Unit Steps , Program **/
67 FUNCTION finalize_unit (
68 p_person_id igs_en_su_attempt.person_id%TYPE,
69 p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
70 p_called_from_wlst VARCHAR2,
71 p_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
72 p_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
73 p_cal_type igs_ca_inst.cal_type%TYPE,
74 p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
75 p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
76 p_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
77 p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
78 p_course_cd igs_en_su_attempt.course_cd%TYPE,
79 p_rsv_seat_ext_id igs_en_su_attempt.rsv_seat_ext_id%TYPE,
80 p_message_name OUT NOCOPY VARCHAR2)
81 RETURN BOOLEAN;
82
83 /**************************Declaration of globally used PL-SQL Tables *****/
84
85 TYPE rec_succ_mail
86 IS
87 RECORD (person_id igs_en_su_attempt.person_id%TYPE,
88 course_cd igs_en_su_attempt.course_cd%TYPE);
89
90 TYPE tab_succ_mail
91 IS
92 TABLE OF rec_succ_mail
93 INDEX BY BINARY_INTEGER;
94
95
96
97 TYPE rec_fail_mail
98 IS
99 RECORD (person_id igs_en_su_attempt.person_id%TYPE,
100 course_cd igs_en_su_attempt.course_cd%TYPE,
101 message_name fnd_new_messages.message_name%TYPE);
102
103 TYPE tab_fail_mail
104 IS
105 TABLE OF rec_fail_mail
106 INDEX BY BINARY_INTEGER;
107
108
109 /**************************Declaration of globally used PL-SQL Tables *****/
110
111 /** The main auto enroll procedure - Called from conc now Also to be called from the TBH of IGSPI085B.pls **/
112
113 PROCEDURE enroll_from_waitlist (errbuf OUT NOCOPY VARCHAR2,
114 retcode OUT NOCOPY NUMBER,
115 p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
116 p_org_id IN NUMBER
117 );
118
119 FUNCTION get_message (p_messages VARCHAR2,
120 p_message_index NUMBER)
121 RETURN VARCHAR2;
122
123 FUNCTION get_message_count(p_messages IN VARCHAR2)
124 RETURN NUMBER;
125
126 PROCEDURE ss_eval_min_or_max_cp(
127 p_person_id IN igs_en_su_attempt.person_id%TYPE,
128 p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
129 p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
130 p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
131 p_program_cd IN igs_en_su_attempt.course_cd%TYPE,
132 p_step_type IN igs_en_cpd_ext.s_enrolment_step_type%TYPE,
133 p_credit_points IN NUMBER,
134 p_message_name OUT NOCOPY VARCHAR2,
135 p_deny_warn OUT NOCOPY VARCHAR2,
136 p_return_status OUT NOCOPY VARCHAR2,
137 p_enr_method IN igs_en_cat_prc_dtl.enr_method_type%TYPE DEFAULT NULL);
138
139 END Igs_En_Enroll_Wlst; -- end of package