1 PACKAGE igs_en_wlst_gen_proc AUTHID CURRENT_USER AS
2 /* $Header: IGSEN76S.pls 115.10 2003/12/11 11:09:46 rnirwani ship $ */
3
4 ------------------------------------------------------------------
5 --Created by : Sanil Madathil, Oracle IDC
6 --Date created: 18-JUL-2001
7 --
8 --Purpose: Package specification contains definition of procedures
9 -- getPersonDetail and getUooDetail
10 -- and procedure to raise event for sending mail to student
11 -- and administrator
12 -- and function to get message text
13 --
14 --
15 --
16 --Known limitations/enhancements and/or remarks:
17 --
18 --Change History:
19 --Who When What
20 --ptandon 26-Aug-2003 Modified the procedure Enrp_Resequence_Wlst and
21 -- added three more procedures Enrp_Wlst_Assign_Pos,
22 -- Enrp_Wlst_Dt_Reseq and Enrp_Wlst_Pri_Pref_Calc as
23 -- part of Waitlist Enhancements Build (Bug# 3052426)
24 -- rnirwani 01-Dec-2003 Bug# 2829263. Term records build
25 -- Parameters to procedure wf_inform_stud have been modified.
26 -------------------------------------------------------------------
27
28 -- Record type for PL/SQL table
29 TYPE t_modified_pos_rec IS RECORD
30 (
31 current_position NUMBER,
32 previous_position NUMBER
33 );
34
35 TYPE t_modified_pos_tab IS TABLE OF t_modified_pos_rec INDEX BY BINARY_INTEGER;
36
37 FUNCTION getmessagetext (p_message_name IN VARCHAR2
38 )RETURN VARCHAR2;
39
40 PROCEDURE getpersondetail ( p_person_id IN igs_pe_person.person_id%TYPE ,
41 p_person_number OUT NOCOPY igs_pe_person.person_number%TYPE ,
42 p_full_name OUT NOCOPY igs_pe_person.full_name%TYPE ,
43 p_email_addr OUT NOCOPY igs_pe_person.email_addr%TYPE ,
44 p_message OUT NOCOPY VARCHAR2
45 ) ;
46
47 PROCEDURE getuoodetail ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
48 p_unit_cd OUT NOCOPY igs_ps_unit_ver.unit_cd%TYPE ,
49 p_unit_title OUT NOCOPY igs_ps_unit_ver.title%TYPE ,
50 p_cal_type OUT NOCOPY igs_ps_unit_ofr_opt.cal_type%TYPE ,
51 p_alternate_code OUT NOCOPY igs_ca_inst.alternate_code%TYPE ,
52 p_location_desc OUT NOCOPY igs_ad_location.description%TYPE ,
53 p_unit_class OUT NOCOPY igs_ps_unit_ofr_opt.unit_class%TYPE ,
54 p_message OUT NOCOPY VARCHAR2
55 ) ;
56
57 PROCEDURE wf_inform_stud ( p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE ,
58 p_program_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
59 P_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
60 P_program_attempt_status IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,
61 p_org_id IN NUMBER,
62 p_old_key_program IN igs_en_stdnt_ps_att.course_cd%TYPE DEFAULT NULL,
63 p_old_prim_program IN igs_en_stdnt_ps_att.course_cd%TYPE DEFAULT NULL,
64 p_load_cal_type IN igs_ca_inst.cal_type%TYPE DEFAULT NULL,
65 p_load_ci_seq_num IN igs_ca_inst.sequence_number%TYPE DEFAULT NULL
66 );
67
68 PROCEDURE wf_send_mail_stud ( p_person_id IN igs_pe_person.person_id%TYPE ,
69 p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
70 p_org_id IN NUMBER
71 );
72
73 PROCEDURE wf_send_mail_adm ( p_person_id_list IN VARCHAR2 ,
74 p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
75 p_org_id IN NUMBER
76 );
77
78 FUNCTION Enrp_Resequence_Wlst ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
79 p_modified_pos_tab IN t_modified_pos_tab
80 ) RETURN BOOLEAN;
81
82 PROCEDURE check_stud_count ( itemtype IN VARCHAR2,
83 itemkey IN VARCHAR2,
84 actid IN NUMBER,
85 funcmode IN VARCHAR2,
86 resultout OUT NOCOPY VARCHAR2
87 );
88
89 PROCEDURE check_manual_ind ( itemtype IN VARCHAR2,
90 itemkey IN VARCHAR2,
91 actid IN NUMBER,
92 funcmode IN VARCHAR2,
93 resultout OUT NOCOPY VARCHAR2
94 );
95
96 -- Procedure to re-sequence the students after calculating the priority/preference for the student in context.
97 PROCEDURE enrp_wlst_assign_pos ( p_person_id IN NUMBER ,
98 p_program_cd IN VARCHAR2 ,
99 p_uoo_id IN NUMBER
100 );
101
102 -- Procedure to re-sequence the remaining students after placing the student in context at appropriate position.
103 PROCEDURE enrp_wlst_dt_reseq ( p_person_id IN NUMBER ,
104 p_program_cd IN VARCHAR2 ,
105 p_uoo_id IN NUMBER ,
106 p_cur_position IN NUMBER
107 );
108
109 -- Procedure to calculate priority/preference weightages.
110 PROCEDURE enrp_wlst_pri_pref_calc ( p_person_id IN NUMBER ,
111 p_program_cd IN VARCHAR2 ,
112 p_uoo_id IN NUMBER ,
113 p_priority_weight OUT NOCOPY NUMBER ,
114 p_preference_weight OUT NOCOPY NUMBER
115 );
116
117 PROCEDURE inform_stud_not ( itemtype IN VARCHAR2,
118 itemkey IN VARCHAR2,
119 actid IN NUMBER,
120 funcmode IN VARCHAR2,
121 resultout OUT NOCOPY VARCHAR2
122 );
123
124 END igs_en_wlst_gen_proc ;