1 Package ota_tdb_api_upd2 AUTHID CURRENT_USER as
2 /* $Header: ottdb02t.pkh 120.9.12010000.2 2009/08/12 14:12:22 smahanka ship $ */
3 /*#
4 * This package updates the enrollment of a learner in a class.
5 * @rep:scope private
6 * @rep:product ota
7 * @rep:displayname Enrollment
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |----------------------------< update_enrollment >-------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API updates the enrollment of a learner in a class.
17 *
18 *
19 * <p><b>Licensing</b><br>
20 * This API is licensed for use with Learning Management.
21 *
22 * <p><b>Prerequisites</b><br>
23 * The learner should have learner access for the class for which enrollment is
24 * going to be updated.
25 *
26 * <p><b>Post Success</b><br>
27 * The enrollment record is updated.
28 *
29 * <p><b>Post Failure</b><br>
30 * The enrollment record is not updated and an error is raised.
31 * @param p_booking_id Identifies the enrollment to be updated.
32 * @param p_booking_status_type_id {@rep:casecolumn
33 * OTA_BOOKING_STATUS_TYPES.BOOKING_STATUS_TYPE_ID}.
34 * @param p_delegate_person_id Identifies the person for whom the enrollment
35 * record is being updated.
36 * @param p_contact_id Identifies the contact of customer for whom the
37 * enrollment record is being updated.
38 * @param p_business_group_id {@rep:casecolumn OTA_EVENTS.BUSINESS_GROUP_ID}.
39 * @param p_event_id Identifies the class in which person or contact is
40 * enrolled.
41 * @param p_customer_id Identifies the customer for whom the enrollment record
42 * is being updated.
43 * @param p_authorizer_person_id {@rep:casecolumn
44 * OTA_DELEGATE_BOOKINGS.AUTHORIZER_PERSON_ID}.
45 * @param p_date_booking_placed Identifies the date on which the enrollment is
46 * updated.
47 * @param p_corespondent {@rep:casecolumn OTA_DELEGATE_BOOKINGS.CORESPONDENT}.
48 * @param p_internal_booking_flag This flag should have the value Y for
49 * internal enrollments and N for external enrollments.
50 * @param p_number_of_places Identifies the number of places needed in the
51 * class.
52 * @param p_object_version_number Pass the current version number of the
53 * enrollment to be updated.When the API completes if p_validate is false,will
54 * be set to the new version number of the updated enrollment. If p_validate is
55 * true will be set to the same value which was passed in.
56 * @param p_administrator {@rep:casecolumn OTA_DELEGATE_BOOKINGS.ADMINISTRATOR}.
57 * @param p_booking_priority Enrollment Priority. Valid values are defined by
58 * the 'PRIORITY_LEVEL' lookup type.
59 * @param p_comments Comment text.
60 * @param p_contact_address_id {@rep:casecolumn
61 * OTA_DELEGATE_BOOKINGS.CONTACT_ADDRESS_ID}.
62 * @param p_delegate_contact_phone {@rep:casecolumn
63 * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_PHONE}.
64 * @param p_delegate_contact_fax {@rep:casecolumn
65 * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_FAX}.
66 * @param p_third_party_customer_id {@rep:casecolumn
67 * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CUSTOMER_ID}.
68 * @param p_third_party_contact_id {@rep:casecolumn
69 * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_ID}.
70 * @param p_third_party_address_id {@rep:casecolumn
71 * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_ADDRESS_ID}.
72 * @param p_third_party_contact_phone {@rep:casecolumn
73 * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_PHONE}.
74 * @param p_third_party_contact_fax {@rep:casecolumn
75 * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_FAX}.
76 * @param p_date_status_changed {@rep:casecolumn
77 * OTA_DELEGATE_BOOKINGS.DATE_STATUS_CHANGED}.
78 * @param p_status_change_comments Comments on status change.
79 * @param p_failure_reason Identifies the failure reason. Valid values are
80 * defined by 'DELEGATE_FAILURE_REASON' lookup type.
81 * @param p_attendance_result {@rep:casecolumn
82 * OTA_DELEGATE_BOOKINGS.ATTENDANCE_RESULT}.
83 * @param p_language_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.LANGUAGE_ID}.
84 * @param p_source_of_booking Identifies the source of enrollment. Valid values
85 * are defined by the 'BOOKING_SOURCE' lookup type.
86 * @param p_special_booking_instructions {@rep:casecolumn
87 * OTA_DELEGATE_BOOKINGS.SPECIAL_BOOKING_INSTRUCTIONS}.
88 * @param p_successful_attendance_flag {@rep:casecolumn
89 * OTA_DELEGATE_BOOKINGS.SUCCESSFUL_ATTENDANCE_FLAG}.
90 * @param p_tdb_information_category This context value determines which
91 * Flexfield Structure to use with the Descriptive flexfield segment
92 * @param p_tdb_information1 Descriptive flexfield segment.
93 * @param p_tdb_information2 Descriptive flexfield segment.
94 * @param p_tdb_information3 Descriptive flexfield segment.
95 * @param p_tdb_information4 Descriptive flexfield segment.
96 * @param p_tdb_information5 Descriptive flexfield segment.
97 * @param p_tdb_information6 Descriptive flexfield segment.
98 * @param p_tdb_information7 Descriptive flexfield segment.
99 * @param p_tdb_information8 Descriptive flexfield segment.
100 * @param p_tdb_information9 Descriptive flexfield segment.
101 * @param p_tdb_information10 Descriptive flexfield segment.
102 * @param p_tdb_information11 Descriptive flexfield segment.
103 * @param p_tdb_information12 Descriptive flexfield segment.
104 * @param p_tdb_information13 Descriptive flexfield segment.
105 * @param p_tdb_information14 Descriptive flexfield segment.
106 * @param p_tdb_information15 Descriptive flexfield segment.
107 * @param p_tdb_information16 Descriptive flexfield segment.
108 * @param p_tdb_information17 Descriptive flexfield segment.
109 * @param p_tdb_information18 Descriptive flexfield segment.
110 * @param p_tdb_information19 Descriptive flexfield segment.
111 * @param p_tdb_information20 Descriptive flexfield segment.
112 * @param p_update_finance_line Identifies whether a finance line needs to be
113 * updated.
114 * @param p_tfl_object_version_number If p_validate is false, then set to the
115 * version number of the updated finance line. If p_validate is true, then the
116 * value will be null.
117 * @param p_finance_header_id Identifies the finance header.
118 * @param p_finance_line_id Identifies the finance line.
119 * @param p_standard_amount {@rep:casecolumn OTA_FINANCE_LINES.STANDARD_AMOUNT}.
120 * @param p_unitary_amount {@rep:casecolumn OTA_FINANCE_LINES.UNITARY_AMOUNT}.
121 * @param p_money_amount {@rep:casecolumn OTA_FINANCE_LINES.MONEY_AMOUNT}.
122 * @param p_currency_code {@rep:casecolumn OTA_EVENTS.CURRENCY_CODE}.
123 * @param p_booking_deal_type Identifies the type of booking deal.
124 * @param p_booking_deal_id {@rep:casecolumn OTA_FINANCE_LINES.BOOKING_DEAL_ID}.
125 * @param p_enrollment_type Enrollment type is S for student, null for others.
126 * @param p_validate If true, then validation alone will be performed and the
127 * database will remain unchanged. If false and all validation checks pass,
128 * then the database will be modified.
129 * @param p_organization_id {@rep:casecolumn
130 * OTA_DELEGATE_BOOKINGS.ORGANIZATION_ID}.
131 * @param p_sponsor_person_id {@rep:casecolumn
132 * OTA_DELEGATE_BOOKINGS.SPONSOR_PERSON_ID}.
133 * @param p_sponsor_assignment_id {@rep:casecolumn
134 * OTA_DELEGATE_BOOKINGS.SPONSOR_ASSIGNMENT_ID}.
135 * @param p_person_address_id {@rep:casecolumn
136 * OTA_DELEGATE_BOOKINGS.PERSON_ADDRESS_ID}.
137 * @param p_delegate_assignment_id {@rep:casecolumn
138 * OTA_DELEGATE_BOOKINGS.DELEGATE_ASSIGNMENT_ID}.
139 * @param p_delegate_contact_id {@rep:casecolumn
140 * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_ID}.
141 * @param p_delegate_contact_email {@rep:casecolumn
142 * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_EMAIL}.
143 * @param p_third_party_email {@rep:casecolumn
144 * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_EMAIL}.
145 * @param p_person_address_type {@rep:casecolumn
146 * OTA_DELEGATE_BOOKINGS.PERSON_ADDRESS_TYPE}.
147 * @param p_line_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.LINE_ID}.
148 * @param p_org_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.ORG_ID}.
149 * @param p_daemon_flag {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_FLAG}.
150 * @param p_daemon_type {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_TYPE}.
151 * @param p_old_event_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.OLD_EVENT_ID}.
152 * @param p_quote_line_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.QUOTE_LINE_ID}.
153 * @param p_interface_source {@rep:casecolumn
154 * OTA_DELEGATE_BOOKINGS.INTERFACE_SOURCE}.
155 * @param p_total_training_time {@rep:casecolumn
156 * OTA_DELEGATE_BOOKINGS.TOTAL_TRAINING_TIME}.
157 * @param p_content_player_status Player status of Courses imported from
158 * iLearning.
159 * @param p_score Test Score of Courses imported from iLearning.
160 * @param p_completed_content {@rep:casecolumn
161 * OTA_DELEGATE_BOOKINGS.COMPLETED_CONTENT}.
162 * @param p_total_content {@rep:casecolumn OTA_DELEGATE_BOOKINGS.TOTAL_CONTENT}.
163 * @param p_source_cancel Specifies whether the unenrollment originates from
164 * the learner or admin. Valid value is 'AME' when coming from the learner;
165 * otherwise it is null.
166 * @param p_booking_justification_id Identifies the enrollment justification
167 * for the enrollment record.
168 * @param p_override_prerequisites Determines whether the course and competency
169 * prerequisites check is to be overridden. Valid values are Y and N. Default
170 * value is N.
171 * @param p_is_history_flag Determines whether the enrollment record should be
172 * moved to history. Valid values are Y and N. Default value is N.
173 * @param p_override_learner_access Determines whether the learner access
177 * @rep:scope private
174 * check is to be overridden. Valid values are Y and N. Default value is N.
175 * @rep:displayname Update Enrollment
176 * @rep:category BUSINESS_ENTITY OTA_LEARNER_ENROLLMENT
178 * @rep:lifecycle active
179 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
180 */
181 --
182 -- {End Of Comments}
183 --
184 procedure Update_Enrollment
185 (
186 p_booking_id in number,
187 p_booking_status_type_id in number default hr_api.g_number,
188 p_delegate_person_id in number default hr_api.g_number,
189 p_contact_id in number default hr_api.g_number,
190 p_business_group_id in number default hr_api.g_number,
191 p_event_id in number default hr_api.g_number,
192 p_customer_id in number default hr_api.g_number,
193 p_authorizer_person_id in number default hr_api.g_number,
194 p_date_booking_placed in date default hr_api.g_date,
195 p_corespondent in varchar2 default hr_api.g_varchar2,
196 p_internal_booking_flag in varchar2 default hr_api.g_varchar2,
197 p_number_of_places in number default hr_api.g_number,
198 p_object_version_number in out nocopy number,
199 p_administrator in number default hr_api.g_number,
200 p_booking_priority in varchar2 default hr_api.g_varchar2,
201 p_comments in varchar2 default hr_api.g_varchar2,
202 p_contact_address_id in number default hr_api.g_number,
203 p_delegate_contact_phone in varchar2 default hr_api.g_varchar2,
204 p_delegate_contact_fax in varchar2 default hr_api.g_varchar2,
205 p_third_party_customer_id in number default hr_api.g_number,
206 p_third_party_contact_id in number default hr_api.g_number,
207 p_third_party_address_id in number default hr_api.g_number,
208 p_third_party_contact_phone in varchar2 default hr_api.g_varchar2,
209 p_third_party_contact_fax in varchar2 default hr_api.g_varchar2,
210 p_date_status_changed in date default hr_api.g_date,
211 p_status_change_comments in varchar2 default hr_api.g_varchar2,
212 p_failure_reason in varchar2 default hr_api.g_varchar2,
213 p_attendance_result in varchar2 default hr_api.g_varchar2,
214 p_language_id in number default hr_api.g_number,
215 p_source_of_booking in varchar2 default hr_api.g_varchar2,
216 p_special_booking_instructions in varchar2 default hr_api.g_varchar2,
217 p_successful_attendance_flag in varchar2 default hr_api.g_varchar2,
218 p_tdb_information_category in varchar2 default hr_api.g_varchar2,
219 p_tdb_information1 in varchar2 default hr_api.g_varchar2,
220 p_tdb_information2 in varchar2 default hr_api.g_varchar2,
221 p_tdb_information3 in varchar2 default hr_api.g_varchar2,
222 p_tdb_information4 in varchar2 default hr_api.g_varchar2,
223 p_tdb_information5 in varchar2 default hr_api.g_varchar2,
224 p_tdb_information6 in varchar2 default hr_api.g_varchar2,
225 p_tdb_information7 in varchar2 default hr_api.g_varchar2,
226 p_tdb_information8 in varchar2 default hr_api.g_varchar2,
227 p_tdb_information9 in varchar2 default hr_api.g_varchar2,
228 p_tdb_information10 in varchar2 default hr_api.g_varchar2,
229 p_tdb_information11 in varchar2 default hr_api.g_varchar2,
230 p_tdb_information12 in varchar2 default hr_api.g_varchar2,
231 p_tdb_information13 in varchar2 default hr_api.g_varchar2,
232 p_tdb_information14 in varchar2 default hr_api.g_varchar2,
233 p_tdb_information15 in varchar2 default hr_api.g_varchar2,
234 p_tdb_information16 in varchar2 default hr_api.g_varchar2,
235 p_tdb_information17 in varchar2 default hr_api.g_varchar2,
236 p_tdb_information18 in varchar2 default hr_api.g_varchar2,
237 p_tdb_information19 in varchar2 default hr_api.g_varchar2,
238 p_tdb_information20 in varchar2 default hr_api.g_varchar2,
239 p_update_finance_line in varchar2 default 'N',
240 p_tfl_object_version_number in out nocopy number,
241 p_finance_header_id in number default hr_api.g_number,
242 p_finance_line_id in out nocopy number,
243 p_standard_amount in number default hr_api.g_number,
244 p_unitary_amount in number default hr_api.g_number,
245 p_money_amount in number default hr_api.g_number,
246 p_currency_code in varchar2 default hr_api.g_varchar2,
247 p_booking_deal_type in varchar2 default hr_api.g_varchar2,
248 p_booking_deal_id in number default hr_api.g_number,
249 p_enrollment_type in varchar2 default hr_api.g_varchar2,
250 p_validate in boolean default false,
251 p_organization_id in number default hr_api.g_number,
252 p_sponsor_person_id in number default hr_api.g_number,
253 p_sponsor_assignment_id in number default hr_api.g_number,
254 p_person_address_id in number default hr_api.g_number,
255 p_delegate_assignment_id in number default hr_api.g_number,
256 p_delegate_contact_id in number default hr_api.g_number,
257 p_delegate_contact_email in varchar2 default hr_api.g_varchar2,
258 p_third_party_email in varchar2 default hr_api.g_varchar2,
259 p_person_address_type in varchar2 default hr_api.g_varchar2,
260 p_line_id in number default hr_api.g_number,
261 p_org_id in number default hr_api.g_number,
262 p_daemon_flag in varchar2 default hr_api.g_varchar2,
263 p_daemon_type in varchar2 default hr_api.g_varchar2,
264 p_old_event_id in number default hr_api.g_number,
265 p_quote_line_id in number default hr_api.g_number,
266 p_interface_source in varchar2 default hr_api.g_varchar2,
267 p_total_training_time in varchar2 default hr_api.g_varchar2,
268 p_content_player_status in varchar2 default hr_api.g_varchar2,
269 p_score in number default hr_api.g_number,
270 p_completed_content in number default hr_api.g_number,
271 p_total_content in number default hr_api.g_number,
272 p_booking_justification_id in number default hr_api.g_number,
273 p_source_cancel in varchar2 default null,
274 p_override_prerequisites in varchar2 default 'N',
275 p_is_history_flag in varchar2 default hr_api.g_varchar2
276 ,p_override_learner_access in varchar2 default 'N',
277 p_sign_eval_status in varchar2 default null
278 );
279 --
280 -- ----------------------------------------------------------------------------
281 -- |--------------------------< Update Waitlisted >---------------------------|
282 -- ----------------------------------------------------------------------------
283 --
284 -- Description: Updates Waitlisted enrollments from the Waitlist window.
285 --
286 --
287 Procedure Update_Waitlisted
288 (
289 p_booking_id in number,
290 p_object_version_number in out nocopy number,
291 p_event_id in number,
292 p_booking_status_type_id in number,
293 p_date_status_changed in date,
294 p_status_change_comments in varchar2,
295 p_number_of_places in number,
296 p_finance_line_id in out nocopy number,
297 p_tfl_object_version_number in out nocopy number,
298 p_administrator in number,
299 p_validate in boolean
300 );
301 --
302 --
303 -- ----------------------------------------------------------------------------
304 -- |--------------------------< chk_mandatory_prereqs >------------------------|
305 -- ----------------------------------------------------------------------------
306 --
307 Procedure chk_mandatory_prereqs
308 (p_delegate_person_id ota_delegate_bookings.delegate_person_id%TYPE,
309 p_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE,
310 p_customer_id ota_delegate_bookings.customer_id%TYPE,
311 p_event_id ota_events.event_id%TYPE,
312 p_booking_status_type_id in ota_delegate_bookings.booking_status_type_id%TYPE
313 );
314 --
315 end ota_tdb_api_upd2;