1 PACKAGE OTA_DELEGATE_BOOKING_API as
2 /* $Header: otenrapi.pkh 120.13.12010000.3 2008/08/12 10:22:42 shwnayak ship $ */
3 /*#
4 * This package manages a learner enrollment in a class.
5 * @rep:scope public
6 * @rep:product ota
7 * @rep:displayname Enrollment
8 */
9 --
10 --
11 -- Package Variables
12 --
13 --
14 -- ----------------------------------------------------------------------------
15 -- |-------------------------< create_delegate_booking >----------------------|
16 -- ----------------------------------------------------------------------------
17 --
18 -- {Start Of Comments}
19 /*#
20 * This API creates a learner enrollment in a class.
21 *
22 *
23 * <p><b>Licensing</b><br>
24 * This API is licensed for use with Learning Management.
25 *
26 * <p><b>Prerequisites</b><br>
27 * User should have learner access for the class for which enrollment is to be
28 * created.
29 *
30 * <p><b>Post Success</b><br>
31 * An enrollment record created in the database.
32 *
33 * <p><b>Post Failure</b><br>
34 * An enrollment record is not created and an error is raised.
35 * @param p_validate If true, then validation alone will be performed and the
36 * database will remain unchanged. If false and all validation checks pass,
37 * then the database will be modified.
38 * @param p_effective_date Reference date for validating lookup values are
39 * applicable during the start to end active date range. This date does not
40 * determine when the changes take effect.
41 * @param p_booking_id If p_validate is false, then this ID uniquely identifies
42 * the enrollment created. If p_validate is true, then it is set to null.
43 * @param p_booking_status_type_id {@rep:casecolumn
44 * OTA_BOOKING_STATUS_TYPES.BOOKING_STATUS_TYPE_ID}.
45 * @param p_delegate_person_id Identifies the person for whom the enrollment
46 * record will be created.
47 * @param p_contact_id Identifies the contact of the customer for which the
48 * enrollment record is created.
49 * @param p_business_group_id {@rep:casecolumn OTA_EVENTS.BUSINESS_GROUP_ID}.
50 * @param p_event_id Identifies the class in which the person or contact is
51 * enrolling.
52 * @param p_customer_id Identifies the customer for which the enrollment record
53 * is being created.
54 * @param p_authorizer_person_id {@rep:casecolumn
55 * OTA_DELEGATE_BOOKINGS.AUTHORIZER_PERSON_ID}.
56 * @param p_date_booking_placed Identifies the date on which the enrollment is
57 * being created.
58 * @param p_corespondent {@rep:casecolumn OTA_DELEGATE_BOOKINGS.CORESPONDENT}.
59 * @param p_internal_booking_flag This flag should have value Y for internal
60 * enrollments and N for external enrollments.
61 * @param p_number_of_places Identifies the number of places needed in the
62 * class.
63 * @param p_object_version_number If p_validate is false, then set to the
64 * version number of the created enrollment. If p_validate is true, then the
65 * value will be null.
66 * @param p_administrator {@rep:casecolumn OTA_DELEGATE_BOOKINGS.ADMINISTRATOR}.
67 * @param p_booking_priority Enrollment Priority. Valid values are defined by
68 * the 'PRIORITY_LEVEL' lookup type.
69 * @param p_comments Comment text.
70 * @param p_contact_address_id {@rep:casecolumn
71 * OTA_DELEGATE_BOOKINGS.CONTACT_ADDRESS_ID}.
72 * @param p_delegate_contact_phone Telephone number for the delegate.
73 * @param p_delegate_contact_fax {@rep:casecolumn
74 * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_FAX}
75 * @param p_third_party_customer_id {@rep:casecolumn
76 * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CUSTOMER_ID}
77 * @param p_third_party_contact_id {@rep:casecolumn
78 * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_ID}
79 * @param p_third_party_address_id {@rep:casecolumn
80 * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_ADDRESS_ID}
81 * @param p_third_party_contact_phone {@rep:casecolumn
82 * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_PHONE}
83 * @param p_third_party_contact_fax {@rep:casecolumn
84 * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_FAX}
85 * @param p_date_status_changed {@rep:casecolumn
86 * OTA_DELEGATE_BOOKINGS.DATE_STATUS_CHANGED}.
87 * @param p_failure_reason Identifies the failure reason. Valid values are
88 * defined by the 'DELEGATE_FAILURE_REASON' lookup type.
89 * @param p_attendance_result {@rep:casecolumn
90 * OTA_DELEGATE_BOOKINGS.ATTENDANCE_RESULT}.
91 * @param p_language_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.LANGUAGE_ID}.
92 * @param p_source_of_booking Identifies the source of the enrollment. Valid
93 * values are defined by the 'BOOKING_SOURCE' lookup type.
94 * @param p_special_booking_instructions {@rep:casecolumn
95 * OTA_DELEGATE_BOOKINGS.SPECIAL_BOOKING_INSTRUCTIONS}
96 * @param p_successful_attendance_flag {@rep:casecolumn
97 * OTA_DELEGATE_BOOKINGS.SUCCESSFUL_ATTENDANCE_FLAG}.
98 * @param p_tdb_information_category This context value determines which
99 * Flexfield Structure to use with the Descriptive flexfield segment.
100 * @param p_tdb_information1 Descriptive flexfield segment.
101 * @param p_tdb_information2 Descriptive flexfield segment.
102 * @param p_tdb_information3 Descriptive flexfield segment.
103 * @param p_tdb_information4 Descriptive flexfield segment.
104 * @param p_tdb_information5 Descriptive flexfield segment.
105 * @param p_tdb_information6 Descriptive flexfield segment.
106 * @param p_tdb_information7 Descriptive flexfield segment.
107 * @param p_tdb_information8 Descriptive flexfield segment.
108 * @param p_tdb_information9 Descriptive flexfield segment.
109 * @param p_tdb_information10 Descriptive flexfield segment.
110 * @param p_tdb_information11 Descriptive flexfield segment.
111 * @param p_tdb_information12 Descriptive flexfield segment.
112 * @param p_tdb_information13 Descriptive flexfield segment.
113 * @param p_tdb_information14 Descriptive flexfield segment.
114 * @param p_tdb_information15 Descriptive flexfield segment.
115 * @param p_tdb_information16 Descriptive flexfield segment.
116 * @param p_tdb_information17 Descriptive flexfield segment.
117 * @param p_tdb_information18 Descriptive flexfield segment.
118 * @param p_tdb_information19 Descriptive flexfield segment.
119 * @param p_tdb_information20 Descriptive flexfield segment.
120 * @param p_create_finance_line Identifies whether a finance line needs to be
121 * created.
122 * @param p_finance_header_id Identifies the finance header.
123 * @param p_currency_code {@rep:casecolumn OTA_FINANCE_LINES.CURRENCY_CODE}.
124 * @param p_standard_amount {@rep:casecolumn OTA_FINANCE_LINES.STANDARD_AMOUNT}.
125 * @param p_unitary_amount {@rep:casecolumn OTA_FINANCE_LINES.UNITARY_AMOUNT}.
126 * @param p_money_amount {@rep:casecolumn OTA_FINANCE_LINES.MONEY_AMOUNT}.
127 * @param p_booking_deal_id {@rep:casecolumn OTA_FINANCE_LINES.BOOKING_DEAL_ID}.
128 * @param p_booking_deal_type Identifies the type of booking deal.
129 * @param p_finance_line_id Identifies the finance line.
130 * @param p_enrollment_type Enrollment type is S for student, null for others.
131 * @param p_organization_id {@rep:casecolumn
132 * OTA_DELEGATE_BOOKINGS.ORGANIZATION_ID}
133 * @param p_sponsor_person_id {@rep:casecolumn
134 * OTA_DELEGATE_BOOKINGS.SPONSOR_PERSON_ID}
135 * @param p_sponsor_assignment_id {@rep:casecolumn
136 * OTA_DELEGATE_BOOKINGS.SPONSOR_ASSIGNMENT_ID}
137 * @param p_person_address_id {@rep:casecolumn
138 * OTA_DELEGATE_BOOKINGS.PERSON_ADDRESS_ID}
139 * @param p_delegate_assignment_id {@rep:casecolumn
140 * OTA_DELEGATE_BOOKINGS.DELEGATE_ASSIGNMENT_ID}
141 * @param p_delegate_contact_id Identifies the contact of the customer for whom
142 * the enrollment record is being created.
143 * @param p_delegate_contact_email {@rep:casecolumn
144 * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_EMAIL}
145 * @param p_third_party_email {@rep:casecolumn
146 * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_EMAIL}
147 * @param p_person_address_type {@rep:casecolumn
148 * OTA_DELEGATE_BOOKINGS.PERSON_ADDRESS_TYPE}
149 * @param p_line_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.LINE_ID}
150 * @param p_org_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.ORG_ID}
151 * @param p_daemon_flag {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_FLAG}
152 * @param p_daemon_type {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_TYPE}
153 * @param p_old_event_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.OLD_EVENT_ID}
154 * @param p_quote_line_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.QUOTE_LINE_ID}.
155 * @param p_interface_source {@rep:casecolumn
156 * OTA_DELEGATE_BOOKINGS.INTERFACE_SOURCE}.
157 * @param p_total_training_time {@rep:casecolumn
158 * OTA_DELEGATE_BOOKINGS.TOTAL_TRAINING_TIME}.
159 * @param p_content_player_status Player status of Courses imported from
160 * iLearning.
161 * @param p_score Test Score of Courses imported from iLearning.
162 * @param p_completed_content {@rep:casecolumn
163 * OTA_DELEGATE_BOOKINGS.COMPLETED_CONTENT}.
164 * @param p_total_content {@rep:casecolumn OTA_DELEGATE_BOOKINGS.TOTAL_CONTENT}.
165 * @param p_booking_justification_id Identifies the enrollment justification
166 * for the enrollment record.
167 * @param p_is_history_flag Determines whether the enrollment record should
168 * be moved to history. Valid values are Y and N. Default value is N.
169 * @param p_override_prerequisites Determines whether the course and
170 * competency prerequisites check is to be overridden. Valid values are Y and
171 * N. Default value is N.
172 * @param p_override_learner_access Determines whether the learner access
173 * check is to be overridden. Valid values are Y and N. Default value is N.
174 * @param p_book_from Specifies whether the enrollment originates from the
175 * learner or admin. Valid value is 'AME' when coming from the learner;
176 * otherwise it is null.
177 * @param p_is_mandatory_enrollment Determines whether the enrollment is
178 * mandatory or not. Gets the value Y only when enrollments are created
179 * through concurrent program.
180 * @rep:displayname Create Enrollment
181 * @rep:category BUSINESS_ENTITY OTA_LEARNER_ENROLLMENT
182 * @rep:scope public
183 * @rep:lifecycle active
184 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
185 */
186 --
187 -- {End Of Comments}
188 --
189 procedure create_delegate_booking
190 (
191 p_validate in boolean default false,
192 p_effective_date in date,
193 p_booking_id out nocopy number,
194 p_booking_status_type_id in number,
195 p_delegate_person_id in number default null,
196 p_contact_id in number,
197 p_business_group_id in number,
198 p_event_id in number,
199 p_customer_id in number default null,
200 p_authorizer_person_id in number default null,
201 p_date_booking_placed in date,
202 p_corespondent in varchar2 default null,
203 p_internal_booking_flag in varchar2,
204 p_number_of_places in number,
205 p_object_version_number out nocopy number,
206 p_administrator in number default null,
207 p_booking_priority in varchar2 default null,
208 p_comments in varchar2 default null,
209 p_contact_address_id in number default null,
210 p_delegate_contact_phone in varchar2 default null,
211 p_delegate_contact_fax in varchar2 default null,
212 p_third_party_customer_id in number default null,
213 p_third_party_contact_id in number default null,
214 p_third_party_address_id in number default null,
215 p_third_party_contact_phone in varchar2 default null,
216 p_third_party_contact_fax in varchar2 default null,
217 p_date_status_changed in date default null,
218 p_failure_reason in varchar2 default null,
219 p_attendance_result in varchar2 default null,
220 p_language_id in number default null,
221 p_source_of_booking in varchar2 default null,
222 p_special_booking_instructions in varchar2 default null,
223 p_successful_attendance_flag in varchar2 default null,
224 p_tdb_information_category in varchar2 default null,
225 p_tdb_information1 in varchar2 default null,
226 p_tdb_information2 in varchar2 default null,
227 p_tdb_information3 in varchar2 default null,
228 p_tdb_information4 in varchar2 default null,
229 p_tdb_information5 in varchar2 default null,
230 p_tdb_information6 in varchar2 default null,
231 p_tdb_information7 in varchar2 default null,
232 p_tdb_information8 in varchar2 default null,
233 p_tdb_information9 in varchar2 default null,
234 p_tdb_information10 in varchar2 default null,
235 p_tdb_information11 in varchar2 default null,
236 p_tdb_information12 in varchar2 default null,
237 p_tdb_information13 in varchar2 default null,
238 p_tdb_information14 in varchar2 default null,
239 p_tdb_information15 in varchar2 default null,
240 p_tdb_information16 in varchar2 default null,
241 p_tdb_information17 in varchar2 default null,
245 p_create_finance_line in varchar2 default null,
242 p_tdb_information18 in varchar2 default null,
243 p_tdb_information19 in varchar2 default null,
244 p_tdb_information20 in varchar2 default null,
246 p_finance_header_id in number default null,
247 p_currency_code in varchar2 default null,
248 p_standard_amount in number default null,
249 p_unitary_amount in number default null,
250 p_money_amount in number default null,
251 p_booking_deal_id in number default null,
252 p_booking_deal_type in varchar2 default null,
253 p_finance_line_id in out nocopy number,
254 p_enrollment_type in varchar2 default null,
255 p_organization_id in number default null,
256 p_sponsor_person_id in number default null,
257 p_sponsor_assignment_id in number default null,
258 p_person_address_id in number default null,
259 p_delegate_assignment_id in number default null,
260 p_delegate_contact_id in number default null,
261 p_delegate_contact_email in varchar2 default null,
262 p_third_party_email in varchar2 default null,
263 p_person_address_type in varchar2 default null,
264 p_line_id in number default null,
265 p_org_id in number default null,
266 p_daemon_flag in varchar2 default null,
267 p_daemon_type in varchar2 default null,
268 p_old_event_id in number default null,
269 p_quote_line_id in number default null,
270 p_interface_source in varchar2 default null,
271 p_total_training_time in varchar2 default null,
272 p_content_player_status in varchar2 default null,
273 p_score in number default null,
274 p_completed_content in number default null,
275 p_total_content in number default null,
276 p_booking_justification_id in number default null,
277 p_is_history_flag in varchar2 default 'N',
278 p_override_prerequisites in varchar2 default 'N',
279 p_override_learner_access in varchar2 default 'N',
280 p_book_from in varchar2 default null,
281 p_is_mandatory_enrollment in varchar2 default 'N'
282 );
283
284
285 -- ----------------------------------------------------------------------------
286 -- |-------------------------< update_delegate_booking >-----------------------|
287 -- ----------------------------------------------------------------------------
288 --
289 --
290 -- {Start Of Comments}
291 /*#
292 * This API updates the enrollment of a learner in a class.
293 *
294 *
295 * <p><b>Licensing</b><br>
296 * This API is licensed for use with Learning Management.
297 *
298 * <p><b>Prerequisites</b><br>
299 * The learner should have learner access for the class for which enrollment is
300 * going to be updated.
301 *
302 * <p><b>Post Success</b><br>
303 * The enrollment record is updated.
304 *
305 * <p><b>Post Failure</b><br>
306 * The enrollment record is not updated and an error is raised.
307 * @param p_validate If true, then validation alone will be performed and the
308 * database will remain unchanged. If false and all validation checks pass,
309 * then the database will be modified.
310 * @param p_effective_date Reference date for validating lookup values are
311 * applicable during the start to end active date range. This date does not
312 * determine when the changes take effect.
313 * @param p_booking_id Identifies the enrollment to be updated.
314 * @param p_booking_status_type_id {@rep:casecolumn
315 * OTA_BOOKING_STATUS_TYPES.BOOKING_STATUS_TYPE_ID}.
316 * @param p_delegate_person_id Identifies the person for whom the enrollment
317 * record is being updated.
318 * @param p_contact_id Identifies the contact of customer for whom the
319 * enrollment record is being updated.
320 * @param p_business_group_id {@rep:casecolumn OTA_EVENTS.BUSINESS_GROUP_ID}.
321 * @param p_event_id Identifies the class in which person or contact is
322 * enrolled.
323 * @param p_customer_id Identifies the customer for whom the enrollment record
324 * is being updated.
325 * @param p_authorizer_person_id {@rep:casecolumn
326 * OTA_DELEGATE_BOOKINGS.AUTHORIZER_PERSON_ID}.
327 * @param p_date_booking_placed Identifies the date on which the enrollment is
328 * updated.
329 * @param p_corespondent {@rep:casecolumn OTA_DELEGATE_BOOKINGS.CORESPONDENT}.
330 * @param p_internal_booking_flag This flag should have the value Y for
331 * internal enrollments and N for external enrollments.
332 * @param p_number_of_places Identifies the number of places needed in the
333 * class.
334 * @param p_object_version_number Pass the current version number of the
335 * enrollment to be updated.When the API completes if p_validate is false,will
336 * be set to the new version number of the updated enrollment. If p_validate is
337 * true will be set to the same value which was passed in.
338 * @param p_administrator {@rep:casecolumn OTA_DELEGATE_BOOKINGS.ADMINISTRATOR}.
339 * @param p_booking_priority Enrollment Priority. Valid values are defined by
340 * the 'PRIORITY_LEVEL' lookup type.
341 * @param p_comments Comment text.
342 * @param p_contact_address_id {@rep:casecolumn
343 * OTA_DELEGATE_BOOKINGS.CONTACT_ADDRESS_ID}.
344 * @param p_delegate_contact_phone Telephone number for the delegate.
345 * @param p_delegate_contact_fax {@rep:casecolumn
346 * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_FAX}
347 * @param p_third_party_customer_id {@rep:casecolumn
348 * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CUSTOMER_ID}
349 * @param p_third_party_contact_id {@rep:casecolumn
350 * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_ID}
351 * @param p_third_party_address_id {@rep:casecolumn
352 * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_ADDRESS_ID}
353 * @param p_third_party_contact_phone {@rep:casecolumn
354 * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_PHONE}
355 * @param p_third_party_contact_fax {@rep:casecolumn
356 * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_FAX}
357 * @param p_date_status_changed {@rep:casecolumn
358 * OTA_DELEGATE_BOOKINGS.DATE_STATUS_CHANGED}.
359 * @param p_status_change_comments Comments on status change.
360 * @param p_failure_reason Identifies the failure reason. Valid values are
361 * defined by 'DELEGATE_FAILURE_REASON' lookup type.
362 * @param p_attendance_result {@rep:casecolumn
363 * OTA_DELEGATE_BOOKINGS.ATTENDANCE_RESULT}.
364 * @param p_language_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.LANGUAGE_ID}.
365 * @param p_source_of_booking Identifies the source of enrollment. Valid values
366 * are defined by the 'BOOKING_SOURCE' lookup type.
367 * @param p_special_booking_instructions {@rep:casecolumn
368 * OTA_DELEGATE_BOOKINGS.SPECIAL_BOOKING_INSTRUCTIONS}
369 * @param p_successful_attendance_flag {@rep:casecolumn
370 * OTA_DELEGATE_BOOKINGS.SUCCESSFUL_ATTENDANCE_FLAG}.
371 * @param p_tdb_information_category This context value determines which
372 * Flexfield Structure to use with the Descriptive flexfield segment.
373 * @param p_tdb_information1 Descriptive flexfield segment.
374 * @param p_tdb_information2 Descriptive flexfield segment.
375 * @param p_tdb_information3 Descriptive flexfield segment.
376 * @param p_tdb_information4 Descriptive flexfield segment.
377 * @param p_tdb_information5 Descriptive flexfield segment.
378 * @param p_tdb_information6 Descriptive flexfield segment.
379 * @param p_tdb_information7 Descriptive flexfield segment.
380 * @param p_tdb_information8 Descriptive flexfield segment.
381 * @param p_tdb_information9 Descriptive flexfield segment.
382 * @param p_tdb_information10 Descriptive flexfield segment.
383 * @param p_tdb_information11 Descriptive flexfield segment.
384 * @param p_tdb_information12 Descriptive flexfield segment.
385 * @param p_tdb_information13 Descriptive flexfield segment.
386 * @param p_tdb_information14 Descriptive flexfield segment.
387 * @param p_tdb_information15 Descriptive flexfield segment.
388 * @param p_tdb_information16 Descriptive flexfield segment.
389 * @param p_tdb_information17 Descriptive flexfield segment.
390 * @param p_tdb_information18 Descriptive flexfield segment.
391 * @param p_tdb_information19 Descriptive flexfield segment.
392 * @param p_tdb_information20 Descriptive flexfield segment.
393 * @param p_update_finance_line Identifies whether a finance line needs to be
394 * updated.
395 * @param p_tfl_object_version_number If p_validate is false, then set to the
396 * version number of the updated finance line. If p_validate is true, then the
397 * value will be null.
398 * @param p_finance_header_id Identifies the finance header.
399 * @param p_finance_line_id Identifies the finance line.
400 * @param p_standard_amount {@rep:casecolumn OTA_FINANCE_LINES.STANDARD_AMOUNT}.
401 * @param p_unitary_amount {@rep:casecolumn OTA_FINANCE_LINES.UNITARY_AMOUNT}.
402 * @param p_money_amount {@rep:casecolumn OTA_FINANCE_LINES.MONEY_AMOUNT}.
403 * @param p_currency_code {@rep:casecolumn OTA_FINANCE_LINES.CURRENCY_CODE}.
404 * @param p_booking_deal_type Identifies the type of booking deal.
405 * @param p_booking_deal_id {@rep:casecolumn OTA_FINANCE_LINES.BOOKING_DEAL_ID}.
406 * @param p_enrollment_type Enrollment type is S for student, null for others.
407 * @param p_organization_id {@rep:casecolumn
408 * OTA_DELEGATE_BOOKINGS.ORGANIZATION_ID}
409 * @param p_sponsor_person_id {@rep:casecolumn
410 * OTA_DELEGATE_BOOKINGS.SPONSOR_PERSON_ID}
411 * @param p_sponsor_assignment_id {@rep:casecolumn
412 * OTA_DELEGATE_BOOKINGS.SPONSOR_ASSIGNMENT_ID}
413 * @param p_person_address_id {@rep:casecolumn
414 * OTA_DELEGATE_BOOKINGS.PERSON_ADDRESS_ID}
415 * @param p_delegate_assignment_id {@rep:casecolumn
416 * OTA_DELEGATE_BOOKINGS.DELEGATE_ASSIGNMENT_ID}
417 * @param p_delegate_contact_id {@rep:casecolumn
421 * @param p_third_party_email {@rep:casecolumn
418 * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_ID}
419 * @param p_delegate_contact_email {@rep:casecolumn
420 * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_EMAIL}
422 * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_EMAIL}
423 * @param p_person_address_type {@rep:casecolumn
424 * OTA_DELEGATE_BOOKINGS.PERSON_ADDRESS_TYPE}
425 * @param p_line_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.LINE_ID}
426 * @param p_org_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.ORG_ID}
427 * @param p_daemon_flag {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_FLAG}
428 * @param p_daemon_type {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_TYPE}
429 * @param p_old_event_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.OLD_EVENT_ID}
430 * @param p_quote_line_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.QUOTE_LINE_ID}.
431 * @param p_interface_source {@rep:casecolumn
432 * OTA_DELEGATE_BOOKINGS.INTERFACE_SOURCE}.
433 * @param p_total_training_time {@rep:casecolumn
434 * OTA_DELEGATE_BOOKINGS.TOTAL_TRAINING_TIME}.
435 * @param p_content_player_status Player status of Courses imported from
436 * iLearning.
437 * @param p_score Test Score of Courses imported from iLearning.
438 * @param p_completed_content {@rep:casecolumn
439 * OTA_DELEGATE_BOOKINGS.COMPLETED_CONTENT}.
440 * @param p_total_content {@rep:casecolumn OTA_DELEGATE_BOOKINGS.TOTAL_CONTENT}.
441 * @param p_booking_justification_id Identifies the enrollment justification
442 * for the enrollment record.
443 * @param p_is_history_flag Determines whether the enrollment record should be
444 * moved to history. Valid values are Y and N. Default value is N.
445 * @param p_override_prerequisites Determines whether the course and competency
446 * prerequisites check is to be overridden. Valid values are Y and N. Default
447 * value is N.
448 * @param p_override_learner_access Determines whether the learner access
449 * check is to be overridden. Valid values are Y and N. Default value is N.
450 * @param p_source_cancel Specifies whether the unenrollment originates from
451 * the learner or admin. Valid value is 'AME' when coming from the learner;
452 * otherwise it is null.
453 * @rep:displayname Update Enrollment
454 * @rep:category BUSINESS_ENTITY OTA_LEARNER_ENROLLMENT
455 * @rep:scope public
456 * @rep:lifecycle active
457 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
458 */
459 --
460 -- {End Of Comments}
461 --
462 procedure update_delegate_booking
463 (
464 p_validate in boolean default false,
465 p_effective_date in date,
466 p_booking_id in number,
467 p_booking_status_type_id in number default hr_api.g_number,
468 p_delegate_person_id in number default hr_api.g_number,
469 p_contact_id in number default hr_api.g_number,
470 p_business_group_id in number default hr_api.g_number,
471 p_event_id in number default hr_api.g_number,
472 p_customer_id in number default hr_api.g_number,
473 p_authorizer_person_id in number default hr_api.g_number,
474 p_date_booking_placed in date default hr_api.g_date,
475 p_corespondent in varchar2 default hr_api.g_varchar2,
476 p_internal_booking_flag in varchar2 default hr_api.g_varchar2,
477 p_number_of_places in number default hr_api.g_number,
478 p_object_version_number in out nocopy number,
479 p_administrator in number default hr_api.g_number,
480 p_booking_priority in varchar2 default hr_api.g_varchar2,
481 p_comments in varchar2 default hr_api.g_varchar2,
482 p_contact_address_id in number default hr_api.g_number,
483 p_delegate_contact_phone in varchar2 default hr_api.g_varchar2,
484 p_delegate_contact_fax in varchar2 default hr_api.g_varchar2,
485 p_third_party_customer_id in number default hr_api.g_number,
486 p_third_party_contact_id in number default hr_api.g_number,
487 p_third_party_address_id in number default hr_api.g_number,
488 p_third_party_contact_phone in varchar2 default hr_api.g_varchar2,
489 p_third_party_contact_fax in varchar2 default hr_api.g_varchar2,
490 p_date_status_changed in date default hr_api.g_date,
491 p_status_change_comments in varchar2 default hr_api.g_varchar2,
492 p_failure_reason in varchar2 default hr_api.g_varchar2,
493 p_attendance_result in varchar2 default hr_api.g_varchar2,
494 p_language_id in number default hr_api.g_number,
495 p_source_of_booking in varchar2 default hr_api.g_varchar2,
496 p_special_booking_instructions in varchar2 default hr_api.g_varchar2,
497 p_successful_attendance_flag in varchar2 default hr_api.g_varchar2,
498 p_tdb_information_category in varchar2 default hr_api.g_varchar2,
499 p_tdb_information1 in varchar2 default hr_api.g_varchar2,
500 p_tdb_information2 in varchar2 default hr_api.g_varchar2,
501 p_tdb_information3 in varchar2 default hr_api.g_varchar2,
502 p_tdb_information4 in varchar2 default hr_api.g_varchar2,
503 p_tdb_information5 in varchar2 default hr_api.g_varchar2,
504 p_tdb_information6 in varchar2 default hr_api.g_varchar2,
505 p_tdb_information7 in varchar2 default hr_api.g_varchar2,
509 p_tdb_information11 in varchar2 default hr_api.g_varchar2,
506 p_tdb_information8 in varchar2 default hr_api.g_varchar2,
507 p_tdb_information9 in varchar2 default hr_api.g_varchar2,
508 p_tdb_information10 in varchar2 default hr_api.g_varchar2,
510 p_tdb_information12 in varchar2 default hr_api.g_varchar2,
511 p_tdb_information13 in varchar2 default hr_api.g_varchar2,
512 p_tdb_information14 in varchar2 default hr_api.g_varchar2,
513 p_tdb_information15 in varchar2 default hr_api.g_varchar2,
514 p_tdb_information16 in varchar2 default hr_api.g_varchar2,
515 p_tdb_information17 in varchar2 default hr_api.g_varchar2,
516 p_tdb_information18 in varchar2 default hr_api.g_varchar2,
517 p_tdb_information19 in varchar2 default hr_api.g_varchar2,
518 p_tdb_information20 in varchar2 default hr_api.g_varchar2,
519 p_update_finance_line in varchar2 default 'N',
520 p_tfl_object_version_number in out nocopy number,
521 p_finance_header_id in number default hr_api.g_number,
522 p_finance_line_id in out nocopy number,
523 p_standard_amount in number default hr_api.g_number,
524 p_unitary_amount in number default hr_api.g_number,
525 p_money_amount in number default hr_api.g_number,
526 p_currency_code in varchar2 default hr_api.g_varchar2,
527 p_booking_deal_type in varchar2 default hr_api.g_varchar2,
528 p_booking_deal_id in number default hr_api.g_number,
529 p_enrollment_type in varchar2 default hr_api.g_varchar2,
530 p_organization_id in number default hr_api.g_number,
531 p_sponsor_person_id in number default hr_api.g_number,
532 p_sponsor_assignment_id in number default hr_api.g_number,
533 p_person_address_id in number default hr_api.g_number,
534 p_delegate_assignment_id in number default hr_api.g_number,
535 p_delegate_contact_id in number default hr_api.g_number,
536 p_delegate_contact_email in varchar2 default hr_api.g_varchar2,
537 p_third_party_email in varchar2 default hr_api.g_varchar2,
538 p_person_address_type in varchar2 default hr_api.g_varchar2,
539 p_line_id in number default hr_api.g_number,
540 p_org_id in number default hr_api.g_number,
541 p_daemon_flag in varchar2 default hr_api.g_varchar2,
542 p_daemon_type in varchar2 default hr_api.g_varchar2,
543 p_old_event_id in number default hr_api.g_number,
544 p_quote_line_id in number default hr_api.g_number,
545 p_interface_source in varchar2 default hr_api.g_varchar2,
546 p_total_training_time in varchar2 default hr_api.g_varchar2,
547 p_content_player_status in varchar2 default hr_api.g_varchar2,
548 p_score in number default hr_api.g_number,
549 p_completed_content in number default hr_api.g_number,
550 p_total_content in number default hr_api.g_number,
551 p_booking_justification_id in number default hr_api.g_number,
552 p_is_history_flag in varchar2 default hr_api.g_varchar2
553 ,p_override_prerequisites in varchar2 default 'N'
554 ,p_override_learner_access in varchar2 default 'N'
555 ,p_source_cancel in varchar2 default hr_api.g_varchar2
556 );
557
558 --
559 -- ----------------------------------------------------------------------------
560 -- |-------------------------< delete_delegate_booking >----------------------|
561 -- ----------------------------------------------------------------------------
562 --
563 -- {Start Of Comments}
564 /*#
565 * This API deletes the enrollment of a learner in a class.
566 *
567 *
568 * <p><b>Licensing</b><br>
569 * This API is licensed for use with Learning Management.
570 *
571 * <p><b>Prerequisites</b><br>
572 * The enrollment should not have a finance line attached to it.
573 *
574 * <p><b>Post Success</b><br>
575 * The enrollment record will be deleted from the database.
576 *
577 * <p><b>Post Failure</b><br>
578 * The enrollment will not be deleted and an error will be raised.
579 * @param p_validate If true, then validation alone will be performed and the
580 * database will remain unchanged. If false and all validation checks pass,
581 * then the database will be modified.
582 * @param p_booking_id The unique identifier for the enrollment.
583 * @param p_object_version_number Current version number of the enrollment
584 * to be deleted.
585
586 * @rep:displayname Delete Enrollment
587 * @rep:category BUSINESS_ENTITY OTA_LEARNER_ENROLLMENT
588 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
589 * @rep:scope public
590 * @rep:lifecycle active
591 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
592 */
593 --
594 -- {End Of Comments}
595 --
596 procedure delete_delegate_booking
597 (
598 p_validate in boolean default false,
599 p_booking_id in number,
600 p_object_version_number in number
601 );
602
603 --
604 -- ----------------------------------------------------------------------------
605 -- |----------------------------< update_waitlisted >-------------------------|
606 -- ----------------------------------------------------------------------------
607 --
608 -- {Start Of Comments}
609 /*#
610 * This API updates Waitlisted enrollments from the Waitlist window.
611 *
612 *
613 * <p><b>Licensing</b><br>
614 * This API is licensed for use with Learning Management.
615 *
616 * <p><b>Prerequisites</b><br>
617 * The learner should have learner access for the class for which enrollment
618 * is going to be updated.
619 *
620 * <p><b>Post Success</b><br>
621 * The waitlisted enrollment record is updated.
622 *
623 * <p><b>Post Failure</b><br>
624 * The waitlisted enrollment record is not updated and an error is raised.
625 *
626 * @param p_booking_id The unique identifier for the enrollment.
627 * @param p_object_version_number Pass the current version number of the
628 * enrollment to be updated.When the API completes if p_validate is false,will
629 * be set to the new version number of the updated enrollment. If p_validate
630 * is true will be set to the same value which was passed in.
631 * @param p_event_id Identifies the class in which person or contact is enrolled.
632 * @param p_booking_status_type_id {@rep:casecolumn
633 * OTA_BOOKING_STATUS_TYPES.BOOKING_STATUS_TYPE_ID}.
634 * @param p_date_status_changed {@rep:casecolumn
635 * OTA_DELEGATE_BOOKINGS.DATE_STATUS_CHANGED}.
636 * @param p_status_change_comments Comments on enrollment status change.
637 * @param p_number_of_places Identifies the number of places needed in the class.
638 * @param p_finance_line_id Identifies the finance line.
639 * @param p_tfl_object_version_number If p_validate is false, then set to the
640 * version number of the updated finance line. If p_validate is true, then the
641 * value will be null.
642 * @param p_administrator {@rep:casecolumn
643 * OTA_DELEGATE_BOOKINGS.ADMINISTRATOR}.
644 * @param p_validate If true, then validation alone will be performed and the
645 * database will remain unchanged. If false and all validation checks pass,
646 * then the database will be modified.
647 * @rep:displayname Update Waitlisted Enrollments
648 * @rep:category BUSINESS_ENTITY OTA_LEARNER_ENROLLMENT
649 * @rep:lifecycle active
650 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
651 * @rep:scope private
652 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
653 */
654 --
655 -- {End Of Comments}
656 --
657 Procedure Update_Waitlisted
658 (
659 p_booking_id in number,
660 p_object_version_number in out nocopy number,
661 p_event_id in number,
662 p_booking_status_type_id in number,
663 p_date_status_changed in date,
664 p_status_change_comments in varchar2,
665 p_number_of_places in number,
666 p_finance_line_id in out nocopy number,
667 p_tfl_object_version_number in out nocopy number,
668 p_administrator in number,
669 p_validate in boolean
670 );
671 --
672 -- ----------------------------------------------------------------------------
673 -- |--------------------------< chk_mandatory_prereqs >-----------------------|
674 -- ----------------------------------------------------------------------------
675 --
676 -- {Start Of Comments}
677 /*#
678 * This API checks for all the mandatory prerequisites required for a class.
679 *
680 *
681 * <p><b>Licensing</b><br>
682 * This API is licensed for use with Learning Management.
683 *
684 * <p><b>Prerequisites</b><br>
685 * The Person or Contact must exist.
686 *
687 * <p><b>Post Success</b><br>
688 * The Person or Contact has completed all the mandatory prerequisites required
689 * for the class.
690 *
691 * <p><b>Post Failure</b><br>
692 * The Person or Contact has not completed all the mandatory prerequisites required
693 * for the class and an error is raised.
694 *
695 * @param p_delegate_person_id Identifies the person for whom the enrollment record
696 * is being updated.
697 * @param p_delegate_contact_id {@rep:casecolumn
698 * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_ID}.
699 * @param p_customer_id Identifies the customer for whom the enrollment
700 * record is being updated.
701 * @param p_event_id Identifies the class in which person or
702 * contact is enrolled.
703 * @param p_booking_status_type_id {@rep:casecolumn
704 * OTA_BOOKING_STATUS_TYPES.BOOKING_STATUS_TYPE_ID}.
705 * @rep:displayname Check Mandatory Prerequisites
706 * @rep:category BUSINESS_ENTITY OTA_LEARNER_ENROLLMENT
707 * @rep:lifecycle active
708 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
709 * @rep:scope private
710 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
711 */
712 --
713 -- {End Of Comments}
714 --
715
716 Procedure chk_mandatory_prereqs
717 (p_delegate_person_id in number,
718 p_delegate_contact_id in number,
719 p_customer_id in number,
720 p_event_id number,
721 p_booking_status_type_id in number
722 );
723
724
725 --
726 procedure create_finance_header
727 ( p_finance_header_id in number,
728 p_result_finance_header_id out nocopy number,
729 p_result_create_finance_line out nocopy varchar2,
730 p_create_finance_line in varchar2,
731 p_event_id in number,
732 p_delegate_person_id in number,
733 p_delegate_assignment_id in number,
734 p_business_group_id_from in number
735 );
736
737 end ota_delegate_booking_api;