4 * This package manages a learner enrollment in a class.
1 PACKAGE OTA_DELEGATE_BOOKING_API AUTHID CURRENT_USER as
2 /* $Header: otenrapi.pkh 120.18 2009/08/13 07:23:10 smahanka ship $ */
3 /*#
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
42 * the enrollment created. If p_validate is true, then it is set to null.
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
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}
140 * OTA_DELEGATE_BOOKINGS.DELEGATE_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
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 p_sign_eval_status in varchar2 default null
283 );
284
285
286 -- ----------------------------------------------------------------------------
287 -- |-------------------------< update_delegate_booking >-----------------------|
288 -- ----------------------------------------------------------------------------
289 --
290 --
291 -- {Start Of Comments}
292 /*#
293 * This API updates the enrollment of a learner in a class.
294 *
295 *
296 * <p><b>Licensing</b><br>
297 * This API is licensed for use with Learning Management.
298 *
299 * <p><b>Prerequisites</b><br>
300 * The learner should have learner access for the class for which enrollment is
301 * going to be updated.
302 *
303 * <p><b>Post Success</b><br>
304 * The enrollment record is updated.
305 *
306 * <p><b>Post Failure</b><br>
307 * The enrollment record is not updated and an error is raised.
308 * @param p_validate If true, then validation alone will be performed and the
309 * database will remain unchanged. If false and all validation checks pass,
310 * then the database will be modified.
311 * @param p_effective_date Reference date for validating lookup values are
312 * applicable during the start to end active date range. This date does not
313 * determine when the changes take effect.
314 * @param p_booking_id Identifies the enrollment to be updated.
315 * @param p_booking_status_type_id {@rep:casecolumn
316 * OTA_BOOKING_STATUS_TYPES.BOOKING_STATUS_TYPE_ID}.
317 * @param p_delegate_person_id Identifies the person for whom the enrollment
318 * record is being updated.
319 * @param p_contact_id Identifies the contact of customer for whom the
320 * enrollment record is being updated.
321 * @param p_business_group_id {@rep:casecolumn OTA_EVENTS.BUSINESS_GROUP_ID}.
322 * @param p_event_id Identifies the class in which person or contact is
323 * enrolled.
324 * @param p_customer_id Identifies the customer for whom the enrollment record
325 * is being updated.
326 * @param p_authorizer_person_id {@rep:casecolumn
327 * OTA_DELEGATE_BOOKINGS.AUTHORIZER_PERSON_ID}.
328 * @param p_date_booking_placed Identifies the date on which the enrollment is
329 * updated.
330 * @param p_corespondent {@rep:casecolumn OTA_DELEGATE_BOOKINGS.CORESPONDENT}.
331 * @param p_internal_booking_flag This flag should have the value Y for
332 * internal enrollments and N for external enrollments.
333 * @param p_number_of_places Identifies the number of places needed in the
334 * class.
335 * @param p_object_version_number Pass the current version number of the
336 * enrollment to be updated.When the API completes if p_validate is false,will
337 * be set to the new version number of the updated enrollment. If p_validate is
338 * true will be set to the same value which was passed in.
339 * @param p_administrator {@rep:casecolumn OTA_DELEGATE_BOOKINGS.ADMINISTRATOR}.
340 * @param p_booking_priority Enrollment Priority. Valid values are defined by
341 * the 'PRIORITY_LEVEL' lookup type.
342 * @param p_comments Comment text.
343 * @param p_contact_address_id {@rep:casecolumn
344 * OTA_DELEGATE_BOOKINGS.CONTACT_ADDRESS_ID}.
345 * @param p_delegate_contact_phone Telephone number for the delegate.
346 * @param p_delegate_contact_fax {@rep:casecolumn
347 * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_FAX}
348 * @param p_third_party_customer_id {@rep:casecolumn
349 * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CUSTOMER_ID}
350 * @param p_third_party_contact_id {@rep:casecolumn
351 * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_ID}
352 * @param p_third_party_address_id {@rep:casecolumn
353 * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_ADDRESS_ID}
354 * @param p_third_party_contact_phone {@rep:casecolumn
355 * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_PHONE}
356 * @param p_third_party_contact_fax {@rep:casecolumn
357 * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_CONTACT_FAX}
358 * @param p_date_status_changed {@rep:casecolumn
359 * OTA_DELEGATE_BOOKINGS.DATE_STATUS_CHANGED}.
360 * @param p_status_change_comments Comments on status change.
361 * @param p_failure_reason Identifies the failure reason. Valid values are
362 * defined by 'DELEGATE_FAILURE_REASON' lookup type.
363 * @param p_attendance_result {@rep:casecolumn
364 * OTA_DELEGATE_BOOKINGS.ATTENDANCE_RESULT}.
365 * @param p_language_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.LANGUAGE_ID}.
366 * @param p_source_of_booking Identifies the source of enrollment. Valid values
367 * are defined by the 'BOOKING_SOURCE' lookup type.
368 * @param p_special_booking_instructions {@rep:casecolumn
369 * OTA_DELEGATE_BOOKINGS.SPECIAL_BOOKING_INSTRUCTIONS}
370 * @param p_successful_attendance_flag {@rep:casecolumn
371 * OTA_DELEGATE_BOOKINGS.SUCCESSFUL_ATTENDANCE_FLAG}.
372 * @param p_tdb_information_category This context value determines which
373 * Flexfield Structure to use with the Descriptive flexfield segment.
374 * @param p_tdb_information1 Descriptive flexfield segment.
375 * @param p_tdb_information2 Descriptive flexfield segment.
376 * @param p_tdb_information3 Descriptive flexfield segment.
377 * @param p_tdb_information4 Descriptive flexfield segment.
378 * @param p_tdb_information5 Descriptive flexfield segment.
379 * @param p_tdb_information6 Descriptive flexfield segment.
380 * @param p_tdb_information7 Descriptive flexfield segment.
381 * @param p_tdb_information8 Descriptive flexfield segment.
382 * @param p_tdb_information9 Descriptive flexfield segment.
383 * @param p_tdb_information10 Descriptive flexfield segment.
384 * @param p_tdb_information11 Descriptive flexfield segment.
385 * @param p_tdb_information12 Descriptive flexfield segment.
386 * @param p_tdb_information13 Descriptive flexfield segment.
387 * @param p_tdb_information14 Descriptive flexfield segment.
388 * @param p_tdb_information15 Descriptive flexfield segment.
389 * @param p_tdb_information16 Descriptive flexfield segment.
390 * @param p_tdb_information17 Descriptive flexfield segment.
391 * @param p_tdb_information18 Descriptive flexfield segment.
392 * @param p_tdb_information19 Descriptive flexfield segment.
393 * @param p_tdb_information20 Descriptive flexfield segment.
394 * @param p_update_finance_line Identifies whether a finance line needs to be
395 * updated.
396 * @param p_tfl_object_version_number If p_validate is false, then set to the
397 * version number of the updated finance line. If p_validate is true, then the
398 * value will be null.
399 * @param p_finance_header_id Identifies the finance header.
400 * @param p_finance_line_id Identifies the finance line.
401 * @param p_standard_amount {@rep:casecolumn OTA_FINANCE_LINES.STANDARD_AMOUNT}.
402 * @param p_unitary_amount {@rep:casecolumn OTA_FINANCE_LINES.UNITARY_AMOUNT}.
403 * @param p_money_amount {@rep:casecolumn OTA_FINANCE_LINES.MONEY_AMOUNT}.
404 * @param p_currency_code {@rep:casecolumn OTA_FINANCE_LINES.CURRENCY_CODE}.
405 * @param p_booking_deal_type Identifies the type of booking deal.
406 * @param p_booking_deal_id {@rep:casecolumn OTA_FINANCE_LINES.BOOKING_DEAL_ID}.
407 * @param p_enrollment_type Enrollment type is S for student, null for others.
408 * @param p_organization_id {@rep:casecolumn
409 * OTA_DELEGATE_BOOKINGS.ORGANIZATION_ID}
410 * @param p_sponsor_person_id {@rep:casecolumn
411 * OTA_DELEGATE_BOOKINGS.SPONSOR_PERSON_ID}
412 * @param p_sponsor_assignment_id {@rep:casecolumn
413 * OTA_DELEGATE_BOOKINGS.SPONSOR_ASSIGNMENT_ID}
414 * @param p_person_address_id {@rep:casecolumn
415 * OTA_DELEGATE_BOOKINGS.PERSON_ADDRESS_ID}
416 * @param p_delegate_assignment_id {@rep:casecolumn
417 * OTA_DELEGATE_BOOKINGS.DELEGATE_ASSIGNMENT_ID}
421 * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_EMAIL}
418 * @param p_delegate_contact_id {@rep:casecolumn
419 * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_ID}
420 * @param p_delegate_contact_email {@rep:casecolumn
422 * @param p_third_party_email {@rep:casecolumn
423 * OTA_DELEGATE_BOOKINGS.THIRD_PARTY_EMAIL}
424 * @param p_person_address_type {@rep:casecolumn
425 * OTA_DELEGATE_BOOKINGS.PERSON_ADDRESS_TYPE}
426 * @param p_line_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.LINE_ID}
427 * @param p_org_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.ORG_ID}
428 * @param p_daemon_flag {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_FLAG}
429 * @param p_daemon_type {@rep:casecolumn OTA_DELEGATE_BOOKINGS.DAEMON_TYPE}
430 * @param p_old_event_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.OLD_EVENT_ID}
431 * @param p_quote_line_id {@rep:casecolumn OTA_DELEGATE_BOOKINGS.QUOTE_LINE_ID}.
432 * @param p_interface_source {@rep:casecolumn
433 * OTA_DELEGATE_BOOKINGS.INTERFACE_SOURCE}.
434 * @param p_total_training_time {@rep:casecolumn
435 * OTA_DELEGATE_BOOKINGS.TOTAL_TRAINING_TIME}.
436 * @param p_content_player_status Player status of Courses imported from
437 * iLearning.
438 * @param p_score Test Score of Courses imported from iLearning.
439 * @param p_completed_content {@rep:casecolumn
440 * OTA_DELEGATE_BOOKINGS.COMPLETED_CONTENT}.
441 * @param p_total_content {@rep:casecolumn OTA_DELEGATE_BOOKINGS.TOTAL_CONTENT}.
442 * @param p_booking_justification_id Identifies the enrollment justification
443 * for the enrollment record.
444 * @param p_is_history_flag Determines whether the enrollment record should be
445 * moved to history. Valid values are Y and N. Default value is N.
446 * @param p_override_prerequisites Determines whether the course and competency
447 * prerequisites check is to be overridden. Valid values are Y and N. Default
448 * value is N.
449 * @param p_override_learner_access Determines whether the learner access
450 * check is to be overridden. Valid values are Y and N. Default value is N.
451 * @param p_source_cancel Specifies whether the unenrollment originates from
452 * the learner or admin. Valid value is 'AME' when coming from the learner;
453 * otherwise it is null.
454 * @rep:displayname Update Enrollment
455 * @rep:category BUSINESS_ENTITY OTA_LEARNER_ENROLLMENT
456 * @rep:scope public
457 * @rep:lifecycle active
458 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
459 */
460 --
461 -- {End Of Comments}
462 --
463 procedure update_delegate_booking
464 (
465 p_validate in boolean default false,
466 p_effective_date in date,
467 p_booking_id in number,
468 p_booking_status_type_id in number default hr_api.g_number,
469 p_delegate_person_id in number default hr_api.g_number,
470 p_contact_id in number default hr_api.g_number,
471 p_business_group_id in number default hr_api.g_number,
472 p_event_id in number default hr_api.g_number,
473 p_customer_id in number default hr_api.g_number,
474 p_authorizer_person_id in number default hr_api.g_number,
475 p_date_booking_placed in date default hr_api.g_date,
476 p_corespondent in varchar2 default hr_api.g_varchar2,
477 p_internal_booking_flag in varchar2 default hr_api.g_varchar2,
478 p_number_of_places in number default hr_api.g_number,
479 p_object_version_number in out nocopy number,
480 p_administrator in number default hr_api.g_number,
481 p_booking_priority in varchar2 default hr_api.g_varchar2,
482 p_comments in varchar2 default hr_api.g_varchar2,
483 p_contact_address_id in number default hr_api.g_number,
484 p_delegate_contact_phone in varchar2 default hr_api.g_varchar2,
485 p_delegate_contact_fax in varchar2 default hr_api.g_varchar2,
486 p_third_party_customer_id in number default hr_api.g_number,
487 p_third_party_contact_id in number default hr_api.g_number,
488 p_third_party_address_id in number default hr_api.g_number,
489 p_third_party_contact_phone in varchar2 default hr_api.g_varchar2,
490 p_third_party_contact_fax in varchar2 default hr_api.g_varchar2,
491 p_date_status_changed in date default hr_api.g_date,
492 p_status_change_comments in varchar2 default hr_api.g_varchar2,
493 p_failure_reason in varchar2 default hr_api.g_varchar2,
494 p_attendance_result in varchar2 default hr_api.g_varchar2,
495 p_language_id in number default hr_api.g_number,
496 p_source_of_booking in varchar2 default hr_api.g_varchar2,
497 p_special_booking_instructions in varchar2 default hr_api.g_varchar2,
498 p_successful_attendance_flag in varchar2 default hr_api.g_varchar2,
499 p_tdb_information_category in varchar2 default hr_api.g_varchar2,
500 p_tdb_information1 in varchar2 default hr_api.g_varchar2,
501 p_tdb_information2 in varchar2 default hr_api.g_varchar2,
502 p_tdb_information3 in varchar2 default hr_api.g_varchar2,
503 p_tdb_information4 in varchar2 default hr_api.g_varchar2,
504 p_tdb_information5 in varchar2 default hr_api.g_varchar2,
505 p_tdb_information6 in varchar2 default hr_api.g_varchar2,
509 p_tdb_information10 in varchar2 default hr_api.g_varchar2,
506 p_tdb_information7 in varchar2 default hr_api.g_varchar2,
507 p_tdb_information8 in varchar2 default hr_api.g_varchar2,
508 p_tdb_information9 in varchar2 default hr_api.g_varchar2,
510 p_tdb_information11 in varchar2 default hr_api.g_varchar2,
511 p_tdb_information12 in varchar2 default hr_api.g_varchar2,
512 p_tdb_information13 in varchar2 default hr_api.g_varchar2,
513 p_tdb_information14 in varchar2 default hr_api.g_varchar2,
514 p_tdb_information15 in varchar2 default hr_api.g_varchar2,
515 p_tdb_information16 in varchar2 default hr_api.g_varchar2,
516 p_tdb_information17 in varchar2 default hr_api.g_varchar2,
517 p_tdb_information18 in varchar2 default hr_api.g_varchar2,
518 p_tdb_information19 in varchar2 default hr_api.g_varchar2,
519 p_tdb_information20 in varchar2 default hr_api.g_varchar2,
520 p_update_finance_line in varchar2 default 'N',
521 p_tfl_object_version_number in out nocopy number,
522 p_finance_header_id in number default hr_api.g_number,
523 p_finance_line_id in out nocopy number,
524 p_standard_amount in number default hr_api.g_number,
525 p_unitary_amount in number default hr_api.g_number,
526 p_money_amount in number default hr_api.g_number,
527 p_currency_code in varchar2 default hr_api.g_varchar2,
528 p_booking_deal_type in varchar2 default hr_api.g_varchar2,
529 p_booking_deal_id in number default hr_api.g_number,
530 p_enrollment_type in varchar2 default hr_api.g_varchar2,
531 p_organization_id in number default hr_api.g_number,
532 p_sponsor_person_id in number default hr_api.g_number,
533 p_sponsor_assignment_id in number default hr_api.g_number,
534 p_person_address_id in number default hr_api.g_number,
535 p_delegate_assignment_id in number default hr_api.g_number,
536 p_delegate_contact_id in number default hr_api.g_number,
537 p_delegate_contact_email in varchar2 default hr_api.g_varchar2,
538 p_third_party_email in varchar2 default hr_api.g_varchar2,
539 p_person_address_type in varchar2 default hr_api.g_varchar2,
540 p_line_id in number default hr_api.g_number,
541 p_org_id in number default hr_api.g_number,
542 p_daemon_flag in varchar2 default hr_api.g_varchar2,
543 p_daemon_type in varchar2 default hr_api.g_varchar2,
544 p_old_event_id in number default hr_api.g_number,
545 p_quote_line_id in number default hr_api.g_number,
546 p_interface_source in varchar2 default hr_api.g_varchar2,
547 p_total_training_time in varchar2 default hr_api.g_varchar2,
548 p_content_player_status in varchar2 default hr_api.g_varchar2,
549 p_score in number default hr_api.g_number,
550 p_completed_content in number default hr_api.g_number,
551 p_total_content in number default hr_api.g_number,
552 p_booking_justification_id in number default hr_api.g_number,
553 p_is_history_flag in varchar2 default hr_api.g_varchar2
554 ,p_override_prerequisites in varchar2 default 'N'
555 ,p_override_learner_access in varchar2 default 'N'
556 ,p_source_cancel in varchar2 default hr_api.g_varchar2
557 ,p_sign_eval_status in varchar2 default null
558 );
559
560 --
561 -- ----------------------------------------------------------------------------
562 -- |-------------------------< delete_delegate_booking >----------------------|
563 -- ----------------------------------------------------------------------------
564 --
565 -- {Start Of Comments}
566 /*#
567 * This API deletes the enrollment of a learner in a class.
568 *
569 *
570 * <p><b>Licensing</b><br>
571 * This API is licensed for use with Learning Management.
572 *
573 * <p><b>Prerequisites</b><br>
574 * The enrollment should not have a finance line attached to it.
575 *
576 * <p><b>Post Success</b><br>
577 * The enrollment record will be deleted from the database.
578 *
579 * <p><b>Post Failure</b><br>
580 * The enrollment will not be deleted and an error will be raised.
581 * @param p_validate If true, then validation alone will be performed and the
582 * database will remain unchanged. If false and all validation checks pass,
583 * then the database will be modified.
584 * @param p_booking_id The unique identifier for the enrollment.
585 * @param p_object_version_number Current version number of the enrollment
586 * to be deleted.
587
588 * @rep:displayname Delete Enrollment
589 * @rep:category BUSINESS_ENTITY OTA_LEARNER_ENROLLMENT
590 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
591 * @rep:scope public
592 * @rep:lifecycle active
593 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
594 */
595 --
596 -- {End Of Comments}
597 --
598 procedure delete_delegate_booking
599 (
603 );
600 p_validate in boolean default false,
601 p_booking_id in number,
602 p_object_version_number in number
604
605 --
606 -- ----------------------------------------------------------------------------
607 -- |----------------------------< update_waitlisted >-------------------------|
608 -- ----------------------------------------------------------------------------
609 --
610 -- {Start Of Comments}
611 /*#
612 * This API updates Waitlisted enrollments from the Waitlist window.
613 *
614 *
615 * <p><b>Licensing</b><br>
616 * This API is licensed for use with Learning Management.
617 *
618 * <p><b>Prerequisites</b><br>
619 * The learner should have learner access for the class for which enrollment
620 * is going to be updated.
621 *
622 * <p><b>Post Success</b><br>
623 * The waitlisted enrollment record is updated.
624 *
625 * <p><b>Post Failure</b><br>
626 * The waitlisted enrollment record is not updated and an error is raised.
627 *
628 * @param p_booking_id The unique identifier for the enrollment.
629 * @param p_object_version_number Pass the current version number of the
630 * enrollment to be updated.When the API completes if p_validate is false,will
631 * be set to the new version number of the updated enrollment. If p_validate
632 * is true will be set to the same value which was passed in.
633 * @param p_event_id Identifies the class in which person or contact is enrolled.
634 * @param p_booking_status_type_id {@rep:casecolumn
635 * OTA_BOOKING_STATUS_TYPES.BOOKING_STATUS_TYPE_ID}.
636 * @param p_date_status_changed {@rep:casecolumn
637 * OTA_DELEGATE_BOOKINGS.DATE_STATUS_CHANGED}.
638 * @param p_status_change_comments Comments on enrollment status change.
639 * @param p_number_of_places Identifies the number of places needed in the class.
640 * @param p_finance_line_id Identifies the finance line.
641 * @param p_tfl_object_version_number If p_validate is false, then set to the
642 * version number of the updated finance line. If p_validate is true, then the
643 * value will be null.
644 * @param p_administrator {@rep:casecolumn
645 * OTA_DELEGATE_BOOKINGS.ADMINISTRATOR}.
646 * @param p_validate If true, then validation alone will be performed and the
647 * database will remain unchanged. If false and all validation checks pass,
648 * then the database will be modified.
649 * @rep:displayname Update Waitlisted Enrollments
650 * @rep:category BUSINESS_ENTITY OTA_LEARNER_ENROLLMENT
651 * @rep:lifecycle active
652 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
653 * @rep:scope private
654 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
655 */
656 --
657 -- {End Of Comments}
658 --
659 Procedure Update_Waitlisted
660 (
661 p_booking_id in number,
662 p_object_version_number in out nocopy number,
663 p_event_id in number,
664 p_booking_status_type_id in number,
665 p_date_status_changed in date,
666 p_status_change_comments in varchar2,
667 p_number_of_places in number,
668 p_finance_line_id in out nocopy number,
669 p_tfl_object_version_number in out nocopy number,
670 p_administrator in number,
671 p_validate in boolean
672 );
673 --
674 -- ----------------------------------------------------------------------------
675 -- |--------------------------< chk_mandatory_prereqs >-----------------------|
676 -- ----------------------------------------------------------------------------
677 --
678 -- {Start Of Comments}
679 /*#
680 * This API checks for all the mandatory prerequisites required for a class.
681 *
682 *
683 * <p><b>Licensing</b><br>
684 * This API is licensed for use with Learning Management.
685 *
686 * <p><b>Prerequisites</b><br>
687 * The Person or Contact must exist.
688 *
689 * <p><b>Post Success</b><br>
690 * The Person or Contact has completed all the mandatory prerequisites required
691 * for the class.
692 *
693 * <p><b>Post Failure</b><br>
694 * The Person or Contact has not completed all the mandatory prerequisites required
695 * for the class and an error is raised.
696 *
697 * @param p_delegate_person_id Identifies the person for whom the enrollment record
698 * is being updated.
699 * @param p_delegate_contact_id {@rep:casecolumn
700 * OTA_DELEGATE_BOOKINGS.DELEGATE_CONTACT_ID}.
701 * @param p_customer_id Identifies the customer for whom the enrollment
702 * record is being updated.
703 * @param p_event_id Identifies the class in which person or
704 * contact is enrolled.
705 * @param p_booking_status_type_id {@rep:casecolumn
706 * OTA_BOOKING_STATUS_TYPES.BOOKING_STATUS_TYPE_ID}.
707 * @rep:displayname Check Mandatory Prerequisites
708 * @rep:category BUSINESS_ENTITY OTA_LEARNER_ENROLLMENT
709 * @rep:lifecycle active
710 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
711 * @rep:scope private
712 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
713 */
714 --
715 -- {End Of Comments}
716 --
717
718 Procedure chk_mandatory_prereqs
719 (p_delegate_person_id in number,
720 p_delegate_contact_id in number,
721 p_customer_id in number,
722 p_event_id number,
723 p_booking_status_type_id in number
724 );
725
726
727 --
728 procedure create_finance_header
729 ( p_finance_header_id in number,
730 p_result_finance_header_id out nocopy number,
734 p_delegate_person_id in number,
731 p_result_create_finance_line out nocopy varchar2,
732 p_create_finance_line in varchar2,
733 p_event_id in number,
735 p_delegate_assignment_id in number,
736 p_business_group_id_from in number,
737 p_booking_status_type_id in number
738 );
739
740 end ota_delegate_booking_api;