1 PACKAGE igs_en_ivr_pub AS
2 /* $Header: IGSEN95S.pls 120.0 2005/06/01 22:21:04 appldev noship $ */
3 /*
4 ||==============================================================================||
5 || Created By : Nalin Kumar ||
6 || Created On : 16-Jan-2003 ||
7 || Purpose : Created this object as per IVR Build. Bug# 2745985 ||
8 || Known limitations, enhancements or remarks : ||
9 || Change History : ||
10 || Who When What ||
11 || sarakshi 13-Apr-2004 Bug#3555871,changed call_number declaration ||
12 || from NUMBER(10) to NUMBER ||
13 || (reverse chronological order - newest change first) ||
14 ||==============================================================================||
15 */
16 --
17 --Term PL/SQL Table
18 --
19 TYPE term_rec_type IS RECORD(p_term_alt_code VARCHAR2 (10));
20 TYPE term_tbl_type IS TABLE OF term_rec_type INDEX BY BINARY_INTEGER;
21
22 --
23 --Career/Program PL/SQL Table
24 --
25 TYPE career_rec_type IS RECORD (
26 p_career VARCHAR2(10),
27 p_program_code VARCHAR2(6),
28 p_version_number NUMBER(3));
29 TYPE career_tbl_type IS TABLE OF career_rec_type INDEX BY BINARY_INTEGER;
30
31 --
32 -- Schedule PL/SQL Table
33 -- This is the declaration of ref cursor which will be returned from the list_schedule procedure
34 --
35 TYPE schedule_rec_type IS RECORD(
36 p_unit_code VARCHAR2(10),
37 p_unit_class VARCHAR2(10),
38 p_unit_version NUMBER(3),
39 p_teach_alternate_code VARCHAR2(10),
40 p_call_Number NUMBER,
41 p_grading_Schema VARCHAR2(10), -- Computed value
42 p_credit_points NUMBER(10), -- Computed value
43 p_unit_attempt_status VARCHAR2(30),
44 p_uas_meaning VARCHAR2(80),
45 p_uoo_id NUMBER(7), -- To enable to join to other views to get data if required.
46 p_administrative_priority NUMBER -- Waitlist Position
47 );
48 TYPE schedule_tbl_type IS TABLE OF schedule_rec_type INDEX BY BINARY_INTEGER;
49
50 --
51 --Call Number Pl/SQL Table
52 -- This is the declaration of ref cursor which will be returned from the list_section_in_cart procedure
53 --
54 TYPE call_number_rec_type IS RECORD(p_call_number NUMBER);
55 TYPE call_number_tbl_type IS TABLE OF call_number_rec_type INDEX BY BINARY_INTEGER;
56
57 --
58 -- End of declaration for PL?SQL Tables
59 --
60
61 PROCEDURE add_to_cart (
62 p_api_version IN NUMBER ,
63 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
64 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
65 p_person_number IN VARCHAR2,
66 p_career IN VARCHAR2,
67 p_program_code IN VARCHAR2,
68 p_term_alt_code IN VARCHAR2,
69 p_call_number IN NUMBER ,
70 p_audit_ind IN VARCHAR2,
71 p_waitlist_ind OUT NOCOPY VARCHAR2,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2);
75
76 PROCEDURE enroll_cart(
77 p_api_version IN NUMBER ,
78 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
79 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
80 p_person_number IN VARCHAR2,
81 p_career IN VARCHAR2,
82 p_program_code IN VARCHAR2,
83 p_term_alt_code IN VARCHAR2,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2);
87
88 PROCEDURE clean_up_cart(
89 p_api_version IN NUMBER ,
90 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
92 p_person_number IN VARCHAR2,
93 p_career IN VARCHAR2,
94 p_program_code IN VARCHAR2,
95 p_term_alt_code IN VARCHAR2,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2);
99
100 PROCEDURE drop_all_section(
101 p_api_version IN NUMBER ,
102 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
103 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
104 p_person_number IN VARCHAR2,
105 p_career IN VARCHAR2,
106 p_program_code IN VARCHAR2,
107 p_term_alt_code IN VARCHAR2,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2);
111
112 PROCEDURE drop_section_by_call_number(
113 p_api_version IN NUMBER ,
114 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
115 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
116 p_person_number IN VARCHAR2,
117 p_career IN VARCHAR2,
118 p_program_code IN VARCHAR2,
119 p_term_alt_code IN VARCHAR2,
120 p_call_number IN NUMBER ,
121 p_drop_reason IN VARCHAR2,
122 p_adm_status IN VARCHAR2,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2);
126
127 PROCEDURE evaluate_person_steps(
128 p_api_version IN NUMBER ,
129 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
130 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
131 p_person_number IN VARCHAR2,
132 p_career IN VARCHAR2,
133 p_program_code IN VARCHAR2,
134 p_term_alt_code IN VARCHAR2,
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2);
138
139 PROCEDURE list_schedule(
140 p_api_version IN NUMBER ,
141 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
142 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
143 P_person_number IN VARCHAR2,
144 P_career IN VARCHAR2,
145 P_program_code IN VARCHAR2,
146 P_term_alt_code IN VARCHAR2,
147 x_schedule_tbl OUT NOCOPY schedule_tbl_type,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2);
151
152 PROCEDURE list_section_in_cart(
153 p_api_version IN NUMBER ,
154 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
155 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
156 p_person_number IN VARCHAR2,
157 p_career IN VARCHAR2,
158 p_program_code IN VARCHAR2,
159 p_term_alt_code IN VARCHAR2,
160 x_call_number_tbl OUT NOCOPY call_number_tbl_type,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2);
164
165 PROCEDURE remove_from_cart(
166 p_api_version IN NUMBER ,
167 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
168 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
169 p_person_number IN VARCHAR2,
170 p_career IN VARCHAR2,
171 p_program_code IN VARCHAR2,
172 p_term_alt_code IN VARCHAR2,
173 p_call_number IN NUMBER ,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2);
177
178 PROCEDURE update_enroll_stats(
179 p_api_version IN NUMBER ,
180 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
181 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
182 p_person_number IN VARCHAR2,
183 p_career IN VARCHAR2,
184 p_program_code IN VARCHAR2,
185 p_term_alt_code IN VARCHAR2,
186 p_call_number IN NUMBER ,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER,
189 x_msg_data OUT NOCOPY VARCHAR2);
190
191 PROCEDURE validate_career_program(
192 p_api_version IN NUMBER ,
193 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
194 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
195 p_person_number IN VARCHAR2,
196 p_career IN VARCHAR2,
197 p_program_code IN VARCHAR2,
198 x_primary_code OUT NOCOPY VARCHAR2,
199 x_primary_version OUT NOCOPY NUMBER ,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2);
203
204 PROCEDURE validate_person_details(
205 p_api_version IN NUMBER,
206 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
207 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
208 p_person_number IN VARCHAR2,
209 x_default_term_alt_code OUT NOCOPY VARCHAR2,
210 x_career_tbl OUT NOCOPY career_tbl_type,
211 x_term_tbl OUT NOCOPY term_tbl_type,
212 x_multiple_career_program OUT NOCOPY VARCHAR2,
213 x_return_status OUT NOCOPY VARCHAR2,
214 x_msg_count OUT NOCOPY NUMBER,
215 x_msg_data OUT NOCOPY VARCHAR2);
216
217 PROCEDURE validate_term(
218 p_api_version IN NUMBER ,
219 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
220 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
221 p_term_alt_code IN VARCHAR2,
222 x_return_status OUT NOCOPY VARCHAR2,
223 x_msg_count OUT NOCOPY NUMBER,
224 x_msg_data OUT NOCOPY VARCHAR2);
225
226 PROCEDURE waitlist(
227 p_api_version IN NUMBER ,
228 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
229 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
230 p_person_number IN VARCHAR2,
231 p_career IN VARCHAR2,
232 p_program_code IN VARCHAR2,
233 p_term_alt_code IN VARCHAR2,
234 p_call_number IN NUMBER ,
235 p_audit_ind IN VARCHAR2,
236 p_waitlist IN VARCHAR2,
237 x_return_status OUT NOCOPY VARCHAR2,
238 x_msg_count OUT NOCOPY NUMBER,
239 x_msg_data OUT NOCOPY VARCHAR2);
240
241 END igs_en_ivr_pub;