141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 10);
143: --
144: Exception
145: When hr_api.check_integrity_violated Then
146: -- A check constraint has been violated
147: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
148: ota_evt_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.check_integrity_violated Then
146: -- A check constraint has been violated
147: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
148: ota_evt_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.parent_integrity_violated Then
151: -- Parent integrity has been violated
152: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
153: ota_evt_shd.constraint_error
146: -- A check constraint has been violated
147: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
148: ota_evt_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.parent_integrity_violated Then
151: -- Parent integrity has been violated
152: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
153: ota_evt_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.parent_integrity_violated Then
151: -- Parent integrity has been violated
152: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
153: ota_evt_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When hr_api.unique_integrity_violated Then
156: -- Unique integrity has been violated
157: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
158: ota_evt_shd.constraint_error
151: -- Parent integrity has been violated
152: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
153: ota_evt_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When hr_api.unique_integrity_violated Then
156: -- Unique integrity has been violated
157: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
158: ota_evt_shd.constraint_error
159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When hr_api.unique_integrity_violated Then
156: -- Unique integrity has been violated
157: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
158: ota_evt_shd.constraint_error
159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: When Others Then
161: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
162: Raise;
163: End update_dml;
310: -- p_rec plsql record structure
311: -- to see if a system default is being used. If a system default
312: -- is being used then we must set to the 'current' argument value.
313: --
314: If (p_rec.vendor_id = hr_api.g_number) then
315: p_rec.vendor_id :=
316: ota_evt_shd.g_old_rec.vendor_id;
317: End If;
318: If (p_rec.activity_version_id = hr_api.g_number) then
314: If (p_rec.vendor_id = hr_api.g_number) then
315: p_rec.vendor_id :=
316: ota_evt_shd.g_old_rec.vendor_id;
317: End If;
318: If (p_rec.activity_version_id = hr_api.g_number) then
319: p_rec.activity_version_id :=
320: ota_evt_shd.g_old_rec.activity_version_id;
321: End If;
322: If (p_rec.business_group_id = hr_api.g_number) then
318: If (p_rec.activity_version_id = hr_api.g_number) then
319: p_rec.activity_version_id :=
320: ota_evt_shd.g_old_rec.activity_version_id;
321: End If;
322: If (p_rec.business_group_id = hr_api.g_number) then
323: p_rec.business_group_id :=
324: ota_evt_shd.g_old_rec.business_group_id;
325: End If;
326: If (p_rec.organization_id = hr_api.g_number) then
322: If (p_rec.business_group_id = hr_api.g_number) then
323: p_rec.business_group_id :=
324: ota_evt_shd.g_old_rec.business_group_id;
325: End If;
326: If (p_rec.organization_id = hr_api.g_number) then
327: p_rec.organization_id :=
328: ota_evt_shd.g_old_rec.organization_id;
329: End If;
330: If (p_rec.event_type = hr_api.g_varchar2) then
326: If (p_rec.organization_id = hr_api.g_number) then
327: p_rec.organization_id :=
328: ota_evt_shd.g_old_rec.organization_id;
329: End If;
330: If (p_rec.event_type = hr_api.g_varchar2) then
331: p_rec.event_type :=
332: ota_evt_shd.g_old_rec.event_type;
333: End If;
334: If (p_rec.title = hr_api.g_varchar2) then
330: If (p_rec.event_type = hr_api.g_varchar2) then
331: p_rec.event_type :=
332: ota_evt_shd.g_old_rec.event_type;
333: End If;
334: If (p_rec.title = hr_api.g_varchar2) then
335: p_rec.title :=
336: ota_evt_shd.g_old_rec.title;
337: End If;
338: If (p_rec.budget_cost = hr_api.g_number) then
334: If (p_rec.title = hr_api.g_varchar2) then
335: p_rec.title :=
336: ota_evt_shd.g_old_rec.title;
337: End If;
338: If (p_rec.budget_cost = hr_api.g_number) then
339: p_rec.budget_cost :=
340: ota_evt_shd.g_old_rec.budget_cost;
341: End If;
342: If (p_rec.actual_cost = hr_api.g_number) then
338: If (p_rec.budget_cost = hr_api.g_number) then
339: p_rec.budget_cost :=
340: ota_evt_shd.g_old_rec.budget_cost;
341: End If;
342: If (p_rec.actual_cost = hr_api.g_number) then
343: p_rec.actual_cost :=
344: ota_evt_shd.g_old_rec.actual_cost;
345: End If;
346: If (p_rec.budget_currency_code = hr_api.g_varchar2) then
342: If (p_rec.actual_cost = hr_api.g_number) then
343: p_rec.actual_cost :=
344: ota_evt_shd.g_old_rec.actual_cost;
345: End If;
346: If (p_rec.budget_currency_code = hr_api.g_varchar2) then
347: p_rec.budget_currency_code :=
348: ota_evt_shd.g_old_rec.budget_currency_code;
349: End If;
350: If (p_rec.centre = hr_api.g_varchar2) then
346: If (p_rec.budget_currency_code = hr_api.g_varchar2) then
347: p_rec.budget_currency_code :=
348: ota_evt_shd.g_old_rec.budget_currency_code;
349: End If;
350: If (p_rec.centre = hr_api.g_varchar2) then
351: p_rec.centre :=
352: ota_evt_shd.g_old_rec.centre;
353: End If;
354: If (p_rec.comments = hr_api.g_varchar2) then
350: If (p_rec.centre = hr_api.g_varchar2) then
351: p_rec.centre :=
352: ota_evt_shd.g_old_rec.centre;
353: End If;
354: If (p_rec.comments = hr_api.g_varchar2) then
355: p_rec.comments :=
356: ota_evt_shd.g_old_rec.comments;
357: End If;
358: If (p_rec.course_end_date = hr_api.g_date) then
354: If (p_rec.comments = hr_api.g_varchar2) then
355: p_rec.comments :=
356: ota_evt_shd.g_old_rec.comments;
357: End If;
358: If (p_rec.course_end_date = hr_api.g_date) then
359: p_rec.course_end_date :=
360: ota_evt_shd.g_old_rec.course_end_date;
361: End If;
362: If (p_rec.course_end_time = hr_api.g_varchar2) then
358: If (p_rec.course_end_date = hr_api.g_date) then
359: p_rec.course_end_date :=
360: ota_evt_shd.g_old_rec.course_end_date;
361: End If;
362: If (p_rec.course_end_time = hr_api.g_varchar2) then
363: p_rec.course_end_time :=
364: ota_evt_shd.g_old_rec.course_end_time;
365: End If;
366: If (p_rec.course_start_date = hr_api.g_date) then
362: If (p_rec.course_end_time = hr_api.g_varchar2) then
363: p_rec.course_end_time :=
364: ota_evt_shd.g_old_rec.course_end_time;
365: End If;
366: If (p_rec.course_start_date = hr_api.g_date) then
367: p_rec.course_start_date :=
368: ota_evt_shd.g_old_rec.course_start_date;
369: End If;
370: If (p_rec.course_start_time = hr_api.g_varchar2) then
366: If (p_rec.course_start_date = hr_api.g_date) then
367: p_rec.course_start_date :=
368: ota_evt_shd.g_old_rec.course_start_date;
369: End If;
370: If (p_rec.course_start_time = hr_api.g_varchar2) then
371: p_rec.course_start_time :=
372: ota_evt_shd.g_old_rec.course_start_time;
373: End If;
374: If (p_rec.duration = hr_api.g_number) then
370: If (p_rec.course_start_time = hr_api.g_varchar2) then
371: p_rec.course_start_time :=
372: ota_evt_shd.g_old_rec.course_start_time;
373: End If;
374: If (p_rec.duration = hr_api.g_number) then
375: p_rec.duration :=
376: ota_evt_shd.g_old_rec.duration;
377: End If;
378: If (p_rec.duration_units = hr_api.g_varchar2) then
374: If (p_rec.duration = hr_api.g_number) then
375: p_rec.duration :=
376: ota_evt_shd.g_old_rec.duration;
377: End If;
378: If (p_rec.duration_units = hr_api.g_varchar2) then
379: p_rec.duration_units :=
380: ota_evt_shd.g_old_rec.duration_units;
381: End If;
382: If (p_rec.enrolment_end_date = hr_api.g_date) then
378: If (p_rec.duration_units = hr_api.g_varchar2) then
379: p_rec.duration_units :=
380: ota_evt_shd.g_old_rec.duration_units;
381: End If;
382: If (p_rec.enrolment_end_date = hr_api.g_date) then
383: p_rec.enrolment_end_date :=
384: ota_evt_shd.g_old_rec.enrolment_end_date;
385: End If;
386: If (p_rec.enrolment_start_date = hr_api.g_date) then
382: If (p_rec.enrolment_end_date = hr_api.g_date) then
383: p_rec.enrolment_end_date :=
384: ota_evt_shd.g_old_rec.enrolment_end_date;
385: End If;
386: If (p_rec.enrolment_start_date = hr_api.g_date) then
387: p_rec.enrolment_start_date :=
388: ota_evt_shd.g_old_rec.enrolment_start_date;
389: End If;
390: If (p_rec.language_id = hr_api.g_number) then
386: If (p_rec.enrolment_start_date = hr_api.g_date) then
387: p_rec.enrolment_start_date :=
388: ota_evt_shd.g_old_rec.enrolment_start_date;
389: End If;
390: If (p_rec.language_id = hr_api.g_number) then
391: p_rec.language_id :=
392: ota_evt_shd.g_old_rec.language_id;
393: End If;
394: If (p_rec.user_status = hr_api.g_varchar2) then
390: If (p_rec.language_id = hr_api.g_number) then
391: p_rec.language_id :=
392: ota_evt_shd.g_old_rec.language_id;
393: End If;
394: If (p_rec.user_status = hr_api.g_varchar2) then
395: p_rec.user_status :=
396: ota_evt_shd.g_old_rec.user_status;
397: End If;
398: If (p_rec.development_event_type = hr_api.g_varchar2) then
394: If (p_rec.user_status = hr_api.g_varchar2) then
395: p_rec.user_status :=
396: ota_evt_shd.g_old_rec.user_status;
397: End If;
398: If (p_rec.development_event_type = hr_api.g_varchar2) then
399: p_rec.development_event_type :=
400: ota_evt_shd.g_old_rec.development_event_type;
401: End If;
402: If (p_rec.event_status = hr_api.g_varchar2) then
398: If (p_rec.development_event_type = hr_api.g_varchar2) then
399: p_rec.development_event_type :=
400: ota_evt_shd.g_old_rec.development_event_type;
401: End If;
402: If (p_rec.event_status = hr_api.g_varchar2) then
403: p_rec.event_status :=
404: ota_evt_shd.g_old_rec.event_status;
405: End If;
406: If (p_rec.price_basis = hr_api.g_varchar2) then
402: If (p_rec.event_status = hr_api.g_varchar2) then
403: p_rec.event_status :=
404: ota_evt_shd.g_old_rec.event_status;
405: End If;
406: If (p_rec.price_basis = hr_api.g_varchar2) then
407: p_rec.price_basis :=
408: ota_evt_shd.g_old_rec.price_basis;
409: End If;
410: If (p_rec.currency_code = hr_api.g_varchar2) then
406: If (p_rec.price_basis = hr_api.g_varchar2) then
407: p_rec.price_basis :=
408: ota_evt_shd.g_old_rec.price_basis;
409: End If;
410: If (p_rec.currency_code = hr_api.g_varchar2) then
411: p_rec.currency_code :=
412: ota_evt_shd.g_old_rec.currency_code;
413: End If;
414: If (p_rec.maximum_attendees = hr_api.g_number) then
410: If (p_rec.currency_code = hr_api.g_varchar2) then
411: p_rec.currency_code :=
412: ota_evt_shd.g_old_rec.currency_code;
413: End If;
414: If (p_rec.maximum_attendees = hr_api.g_number) then
415: p_rec.maximum_attendees :=
416: ota_evt_shd.g_old_rec.maximum_attendees;
417: End If;
418: If (p_rec.maximum_internal_attendees = hr_api.g_number) then
414: If (p_rec.maximum_attendees = hr_api.g_number) then
415: p_rec.maximum_attendees :=
416: ota_evt_shd.g_old_rec.maximum_attendees;
417: End If;
418: If (p_rec.maximum_internal_attendees = hr_api.g_number) then
419: p_rec.maximum_internal_attendees :=
420: ota_evt_shd.g_old_rec.maximum_internal_attendees;
421: End If;
422: If (p_rec.minimum_attendees = hr_api.g_number) then
418: If (p_rec.maximum_internal_attendees = hr_api.g_number) then
419: p_rec.maximum_internal_attendees :=
420: ota_evt_shd.g_old_rec.maximum_internal_attendees;
421: End If;
422: If (p_rec.minimum_attendees = hr_api.g_number) then
423: p_rec.minimum_attendees :=
424: ota_evt_shd.g_old_rec.minimum_attendees;
425: End If;
426: If (p_rec.standard_price = hr_api.g_number) then
422: If (p_rec.minimum_attendees = hr_api.g_number) then
423: p_rec.minimum_attendees :=
424: ota_evt_shd.g_old_rec.minimum_attendees;
425: End If;
426: If (p_rec.standard_price = hr_api.g_number) then
427: p_rec.standard_price :=
428: ota_evt_shd.g_old_rec.standard_price;
429: End If;
430: If (p_rec.category_code = hr_api.g_varchar2) then
426: If (p_rec.standard_price = hr_api.g_number) then
427: p_rec.standard_price :=
428: ota_evt_shd.g_old_rec.standard_price;
429: End If;
430: If (p_rec.category_code = hr_api.g_varchar2) then
431: p_rec.category_code :=
432: ota_evt_shd.g_old_rec.category_code;
433: End If;
434: If (p_rec.parent_event_id = hr_api.g_number) then
430: If (p_rec.category_code = hr_api.g_varchar2) then
431: p_rec.category_code :=
432: ota_evt_shd.g_old_rec.category_code;
433: End If;
434: If (p_rec.parent_event_id = hr_api.g_number) then
435: p_rec.parent_event_id :=
436: ota_evt_shd.g_old_rec.parent_event_id;
437: End If;
438: If (p_rec.book_independent_flag = hr_api.g_varchar2) then
434: If (p_rec.parent_event_id = hr_api.g_number) then
435: p_rec.parent_event_id :=
436: ota_evt_shd.g_old_rec.parent_event_id;
437: End If;
438: If (p_rec.book_independent_flag = hr_api.g_varchar2) then
439: p_rec.book_independent_flag :=
440: ota_evt_shd.g_old_rec.book_independent_flag;
441: End If;
442: If (p_rec.public_event_flag = hr_api.g_varchar2) then
438: If (p_rec.book_independent_flag = hr_api.g_varchar2) then
439: p_rec.book_independent_flag :=
440: ota_evt_shd.g_old_rec.book_independent_flag;
441: End If;
442: If (p_rec.public_event_flag = hr_api.g_varchar2) then
443: p_rec.public_event_flag :=
444: ota_evt_shd.g_old_rec.public_event_flag;
445: End If;
446: If (p_rec.secure_event_flag = hr_api.g_varchar2) then
442: If (p_rec.public_event_flag = hr_api.g_varchar2) then
443: p_rec.public_event_flag :=
444: ota_evt_shd.g_old_rec.public_event_flag;
445: End If;
446: If (p_rec.secure_event_flag = hr_api.g_varchar2) then
447: p_rec.secure_event_flag :=
448: ota_evt_shd.g_old_rec.secure_event_flag;
449: End If;
450: If (p_rec.evt_information_category = hr_api.g_varchar2) then
446: If (p_rec.secure_event_flag = hr_api.g_varchar2) then
447: p_rec.secure_event_flag :=
448: ota_evt_shd.g_old_rec.secure_event_flag;
449: End If;
450: If (p_rec.evt_information_category = hr_api.g_varchar2) then
451: p_rec.evt_information_category :=
452: ota_evt_shd.g_old_rec.evt_information_category;
453: End If;
454: If (p_rec.evt_information1 = hr_api.g_varchar2) then
450: If (p_rec.evt_information_category = hr_api.g_varchar2) then
451: p_rec.evt_information_category :=
452: ota_evt_shd.g_old_rec.evt_information_category;
453: End If;
454: If (p_rec.evt_information1 = hr_api.g_varchar2) then
455: p_rec.evt_information1 :=
456: ota_evt_shd.g_old_rec.evt_information1;
457: End If;
458: If (p_rec.evt_information2 = hr_api.g_varchar2) then
454: If (p_rec.evt_information1 = hr_api.g_varchar2) then
455: p_rec.evt_information1 :=
456: ota_evt_shd.g_old_rec.evt_information1;
457: End If;
458: If (p_rec.evt_information2 = hr_api.g_varchar2) then
459: p_rec.evt_information2 :=
460: ota_evt_shd.g_old_rec.evt_information2;
461: End If;
462: If (p_rec.evt_information3 = hr_api.g_varchar2) then
458: If (p_rec.evt_information2 = hr_api.g_varchar2) then
459: p_rec.evt_information2 :=
460: ota_evt_shd.g_old_rec.evt_information2;
461: End If;
462: If (p_rec.evt_information3 = hr_api.g_varchar2) then
463: p_rec.evt_information3 :=
464: ota_evt_shd.g_old_rec.evt_information3;
465: End If;
466: If (p_rec.evt_information4 = hr_api.g_varchar2) then
462: If (p_rec.evt_information3 = hr_api.g_varchar2) then
463: p_rec.evt_information3 :=
464: ota_evt_shd.g_old_rec.evt_information3;
465: End If;
466: If (p_rec.evt_information4 = hr_api.g_varchar2) then
467: p_rec.evt_information4 :=
468: ota_evt_shd.g_old_rec.evt_information4;
469: End If;
470: If (p_rec.evt_information5 = hr_api.g_varchar2) then
466: If (p_rec.evt_information4 = hr_api.g_varchar2) then
467: p_rec.evt_information4 :=
468: ota_evt_shd.g_old_rec.evt_information4;
469: End If;
470: If (p_rec.evt_information5 = hr_api.g_varchar2) then
471: p_rec.evt_information5 :=
472: ota_evt_shd.g_old_rec.evt_information5;
473: End If;
474: If (p_rec.evt_information6 = hr_api.g_varchar2) then
470: If (p_rec.evt_information5 = hr_api.g_varchar2) then
471: p_rec.evt_information5 :=
472: ota_evt_shd.g_old_rec.evt_information5;
473: End If;
474: If (p_rec.evt_information6 = hr_api.g_varchar2) then
475: p_rec.evt_information6 :=
476: ota_evt_shd.g_old_rec.evt_information6;
477: End If;
478: If (p_rec.evt_information7 = hr_api.g_varchar2) then
474: If (p_rec.evt_information6 = hr_api.g_varchar2) then
475: p_rec.evt_information6 :=
476: ota_evt_shd.g_old_rec.evt_information6;
477: End If;
478: If (p_rec.evt_information7 = hr_api.g_varchar2) then
479: p_rec.evt_information7 :=
480: ota_evt_shd.g_old_rec.evt_information7;
481: End If;
482: If (p_rec.evt_information8 = hr_api.g_varchar2) then
478: If (p_rec.evt_information7 = hr_api.g_varchar2) then
479: p_rec.evt_information7 :=
480: ota_evt_shd.g_old_rec.evt_information7;
481: End If;
482: If (p_rec.evt_information8 = hr_api.g_varchar2) then
483: p_rec.evt_information8 :=
484: ota_evt_shd.g_old_rec.evt_information8;
485: End If;
486: If (p_rec.evt_information9 = hr_api.g_varchar2) then
482: If (p_rec.evt_information8 = hr_api.g_varchar2) then
483: p_rec.evt_information8 :=
484: ota_evt_shd.g_old_rec.evt_information8;
485: End If;
486: If (p_rec.evt_information9 = hr_api.g_varchar2) then
487: p_rec.evt_information9 :=
488: ota_evt_shd.g_old_rec.evt_information9;
489: End If;
490: If (p_rec.evt_information10 = hr_api.g_varchar2) then
486: If (p_rec.evt_information9 = hr_api.g_varchar2) then
487: p_rec.evt_information9 :=
488: ota_evt_shd.g_old_rec.evt_information9;
489: End If;
490: If (p_rec.evt_information10 = hr_api.g_varchar2) then
491: p_rec.evt_information10 :=
492: ota_evt_shd.g_old_rec.evt_information10;
493: End If;
494: If (p_rec.evt_information11 = hr_api.g_varchar2) then
490: If (p_rec.evt_information10 = hr_api.g_varchar2) then
491: p_rec.evt_information10 :=
492: ota_evt_shd.g_old_rec.evt_information10;
493: End If;
494: If (p_rec.evt_information11 = hr_api.g_varchar2) then
495: p_rec.evt_information11 :=
496: ota_evt_shd.g_old_rec.evt_information11;
497: End If;
498: If (p_rec.evt_information12 = hr_api.g_varchar2) then
494: If (p_rec.evt_information11 = hr_api.g_varchar2) then
495: p_rec.evt_information11 :=
496: ota_evt_shd.g_old_rec.evt_information11;
497: End If;
498: If (p_rec.evt_information12 = hr_api.g_varchar2) then
499: p_rec.evt_information12 :=
500: ota_evt_shd.g_old_rec.evt_information12;
501: End If;
502: If (p_rec.evt_information13 = hr_api.g_varchar2) then
498: If (p_rec.evt_information12 = hr_api.g_varchar2) then
499: p_rec.evt_information12 :=
500: ota_evt_shd.g_old_rec.evt_information12;
501: End If;
502: If (p_rec.evt_information13 = hr_api.g_varchar2) then
503: p_rec.evt_information13 :=
504: ota_evt_shd.g_old_rec.evt_information13;
505: End If;
506: If (p_rec.evt_information14 = hr_api.g_varchar2) then
502: If (p_rec.evt_information13 = hr_api.g_varchar2) then
503: p_rec.evt_information13 :=
504: ota_evt_shd.g_old_rec.evt_information13;
505: End If;
506: If (p_rec.evt_information14 = hr_api.g_varchar2) then
507: p_rec.evt_information14 :=
508: ota_evt_shd.g_old_rec.evt_information14;
509: End If;
510: If (p_rec.evt_information15 = hr_api.g_varchar2) then
506: If (p_rec.evt_information14 = hr_api.g_varchar2) then
507: p_rec.evt_information14 :=
508: ota_evt_shd.g_old_rec.evt_information14;
509: End If;
510: If (p_rec.evt_information15 = hr_api.g_varchar2) then
511: p_rec.evt_information15 :=
512: ota_evt_shd.g_old_rec.evt_information15;
513: End If;
514: If (p_rec.evt_information16 = hr_api.g_varchar2) then
510: If (p_rec.evt_information15 = hr_api.g_varchar2) then
511: p_rec.evt_information15 :=
512: ota_evt_shd.g_old_rec.evt_information15;
513: End If;
514: If (p_rec.evt_information16 = hr_api.g_varchar2) then
515: p_rec.evt_information16 :=
516: ota_evt_shd.g_old_rec.evt_information16;
517: End If;
518: If (p_rec.evt_information17 = hr_api.g_varchar2) then
514: If (p_rec.evt_information16 = hr_api.g_varchar2) then
515: p_rec.evt_information16 :=
516: ota_evt_shd.g_old_rec.evt_information16;
517: End If;
518: If (p_rec.evt_information17 = hr_api.g_varchar2) then
519: p_rec.evt_information17 :=
520: ota_evt_shd.g_old_rec.evt_information17;
521: End If;
522: If (p_rec.evt_information18 = hr_api.g_varchar2) then
518: If (p_rec.evt_information17 = hr_api.g_varchar2) then
519: p_rec.evt_information17 :=
520: ota_evt_shd.g_old_rec.evt_information17;
521: End If;
522: If (p_rec.evt_information18 = hr_api.g_varchar2) then
523: p_rec.evt_information18 :=
524: ota_evt_shd.g_old_rec.evt_information18;
525: End If;
526: If (p_rec.evt_information19 = hr_api.g_varchar2) then
522: If (p_rec.evt_information18 = hr_api.g_varchar2) then
523: p_rec.evt_information18 :=
524: ota_evt_shd.g_old_rec.evt_information18;
525: End If;
526: If (p_rec.evt_information19 = hr_api.g_varchar2) then
527: p_rec.evt_information19 :=
528: ota_evt_shd.g_old_rec.evt_information19;
529: End If;
530: If (p_rec.evt_information20 = hr_api.g_varchar2) then
526: If (p_rec.evt_information19 = hr_api.g_varchar2) then
527: p_rec.evt_information19 :=
528: ota_evt_shd.g_old_rec.evt_information19;
529: End If;
530: If (p_rec.evt_information20 = hr_api.g_varchar2) then
531: p_rec.evt_information20 :=
532: ota_evt_shd.g_old_rec.evt_information20;
533: End If;
534: If (p_rec.project_id = hr_api.g_number) then
530: If (p_rec.evt_information20 = hr_api.g_varchar2) then
531: p_rec.evt_information20 :=
532: ota_evt_shd.g_old_rec.evt_information20;
533: End If;
534: If (p_rec.project_id = hr_api.g_number) then
535: p_rec.project_id :=
536: ota_evt_shd.g_old_rec.project_id;
537: End If;
538: If (p_rec.owner_id = hr_api.g_number) then
534: If (p_rec.project_id = hr_api.g_number) then
535: p_rec.project_id :=
536: ota_evt_shd.g_old_rec.project_id;
537: End If;
538: If (p_rec.owner_id = hr_api.g_number) then
539: p_rec.owner_id :=
540: ota_evt_shd.g_old_rec.owner_id;
541: End If;
542: If (p_rec.line_id = hr_api.g_number) then
538: If (p_rec.owner_id = hr_api.g_number) then
539: p_rec.owner_id :=
540: ota_evt_shd.g_old_rec.owner_id;
541: End If;
542: If (p_rec.line_id = hr_api.g_number) then
543: p_rec.line_id :=
544: ota_evt_shd.g_old_rec.line_id;
545: End If;
546: If (p_rec.org_id = hr_api.g_number) then
542: If (p_rec.line_id = hr_api.g_number) then
543: p_rec.line_id :=
544: ota_evt_shd.g_old_rec.line_id;
545: End If;
546: If (p_rec.org_id = hr_api.g_number) then
547: p_rec.org_id :=
548: ota_evt_shd.g_old_rec.org_id;
549: End If;
550: If (p_rec.training_center_id = hr_api.g_number) then
546: If (p_rec.org_id = hr_api.g_number) then
547: p_rec.org_id :=
548: ota_evt_shd.g_old_rec.org_id;
549: End If;
550: If (p_rec.training_center_id = hr_api.g_number) then
551: p_rec.training_center_id :=
552: ota_evt_shd.g_old_rec.training_center_id;
553: End If;
554: If (p_rec.location_id = hr_api.g_number) then
550: If (p_rec.training_center_id = hr_api.g_number) then
551: p_rec.training_center_id :=
552: ota_evt_shd.g_old_rec.training_center_id;
553: End If;
554: If (p_rec.location_id = hr_api.g_number) then
555: p_rec.location_id :=
556: ota_evt_shd.g_old_rec.location_id;
557: End If;
558:
555: p_rec.location_id :=
556: ota_evt_shd.g_old_rec.location_id;
557: End If;
558:
559: If (p_rec.offering_id = hr_api.g_number) then
560: p_rec.offering_id :=
561: ota_evt_shd.g_old_rec.offering_id;
562: End If;
563:
560: p_rec.offering_id :=
561: ota_evt_shd.g_old_rec.offering_id;
562: End If;
563:
564: If (p_rec.timezone = hr_api.g_varchar2) then
565: p_rec.timezone :=
566: ota_evt_shd.g_old_rec.timezone;
567: End If;
568:
565: p_rec.timezone :=
566: ota_evt_shd.g_old_rec.timezone;
567: End If;
568:
569: If (p_rec.parent_offering_id = hr_api.g_number) then
570: p_rec.parent_offering_id :=
571: ota_evt_shd.g_old_rec.parent_offering_id;
572: End If;
573:
570: p_rec.parent_offering_id :=
571: ota_evt_shd.g_old_rec.parent_offering_id;
572: End If;
573:
574: If (p_rec.data_source = hr_api.g_varchar2) then
575: p_rec.data_source :=
576: ota_evt_shd.g_old_rec.data_source;
577: End If;
578:
656: --
657: -- If we are validating then raise the Validate_Enabled exception
658: --
659: If p_validate then
660: Raise HR_Api.Validate_Enabled;
661: End If;
662: -- CODING FOR NTF PROCESS
663:
664: l_course_start_date_changed
762:
763: --
764: hr_utility.set_location(' Leaving:'||l_proc, 10);
765: Exception
766: When HR_Api.Validate_Enabled Then
767: --
768: -- As the Validate_Enabled exception has been raised
769: -- we must rollback to the savepoint
770: --
776: -- ----------------------------------------------------------------------------
777: Procedure upd
778: (
779: p_event_id in number,
780: p_vendor_id in number default hr_api.g_number,
781: p_activity_version_id in number default hr_api.g_number,
782: p_business_group_id in number default hr_api.g_number,
783: p_organization_id in number default hr_api.g_number,
784: p_event_type in varchar2 default hr_api.g_varchar2,
777: Procedure upd
778: (
779: p_event_id in number,
780: p_vendor_id in number default hr_api.g_number,
781: p_activity_version_id in number default hr_api.g_number,
782: p_business_group_id in number default hr_api.g_number,
783: p_organization_id in number default hr_api.g_number,
784: p_event_type in varchar2 default hr_api.g_varchar2,
785: p_object_version_number in out nocopy number,
778: (
779: p_event_id in number,
780: p_vendor_id in number default hr_api.g_number,
781: p_activity_version_id in number default hr_api.g_number,
782: p_business_group_id in number default hr_api.g_number,
783: p_organization_id in number default hr_api.g_number,
784: p_event_type in varchar2 default hr_api.g_varchar2,
785: p_object_version_number in out nocopy number,
786: p_title in varchar2 default hr_api.g_varchar2,
779: p_event_id in number,
780: p_vendor_id in number default hr_api.g_number,
781: p_activity_version_id in number default hr_api.g_number,
782: p_business_group_id in number default hr_api.g_number,
783: p_organization_id in number default hr_api.g_number,
784: p_event_type in varchar2 default hr_api.g_varchar2,
785: p_object_version_number in out nocopy number,
786: p_title in varchar2 default hr_api.g_varchar2,
787: p_budget_cost in number default hr_api.g_number,
780: p_vendor_id in number default hr_api.g_number,
781: p_activity_version_id in number default hr_api.g_number,
782: p_business_group_id in number default hr_api.g_number,
783: p_organization_id in number default hr_api.g_number,
784: p_event_type in varchar2 default hr_api.g_varchar2,
785: p_object_version_number in out nocopy number,
786: p_title in varchar2 default hr_api.g_varchar2,
787: p_budget_cost in number default hr_api.g_number,
788: p_actual_cost in number default hr_api.g_number,
782: p_business_group_id in number default hr_api.g_number,
783: p_organization_id in number default hr_api.g_number,
784: p_event_type in varchar2 default hr_api.g_varchar2,
785: p_object_version_number in out nocopy number,
786: p_title in varchar2 default hr_api.g_varchar2,
787: p_budget_cost in number default hr_api.g_number,
788: p_actual_cost in number default hr_api.g_number,
789: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
790: p_centre in varchar2 default hr_api.g_varchar2,
783: p_organization_id in number default hr_api.g_number,
784: p_event_type in varchar2 default hr_api.g_varchar2,
785: p_object_version_number in out nocopy number,
786: p_title in varchar2 default hr_api.g_varchar2,
787: p_budget_cost in number default hr_api.g_number,
788: p_actual_cost in number default hr_api.g_number,
789: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
790: p_centre in varchar2 default hr_api.g_varchar2,
791: p_comments in varchar2 default hr_api.g_varchar2,
784: p_event_type in varchar2 default hr_api.g_varchar2,
785: p_object_version_number in out nocopy number,
786: p_title in varchar2 default hr_api.g_varchar2,
787: p_budget_cost in number default hr_api.g_number,
788: p_actual_cost in number default hr_api.g_number,
789: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
790: p_centre in varchar2 default hr_api.g_varchar2,
791: p_comments in varchar2 default hr_api.g_varchar2,
792: p_course_end_date in date default hr_api.g_date,
785: p_object_version_number in out nocopy number,
786: p_title in varchar2 default hr_api.g_varchar2,
787: p_budget_cost in number default hr_api.g_number,
788: p_actual_cost in number default hr_api.g_number,
789: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
790: p_centre in varchar2 default hr_api.g_varchar2,
791: p_comments in varchar2 default hr_api.g_varchar2,
792: p_course_end_date in date default hr_api.g_date,
793: p_course_end_time in varchar2 default hr_api.g_varchar2,
786: p_title in varchar2 default hr_api.g_varchar2,
787: p_budget_cost in number default hr_api.g_number,
788: p_actual_cost in number default hr_api.g_number,
789: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
790: p_centre in varchar2 default hr_api.g_varchar2,
791: p_comments in varchar2 default hr_api.g_varchar2,
792: p_course_end_date in date default hr_api.g_date,
793: p_course_end_time in varchar2 default hr_api.g_varchar2,
794: p_course_start_date in date default hr_api.g_date,
787: p_budget_cost in number default hr_api.g_number,
788: p_actual_cost in number default hr_api.g_number,
789: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
790: p_centre in varchar2 default hr_api.g_varchar2,
791: p_comments in varchar2 default hr_api.g_varchar2,
792: p_course_end_date in date default hr_api.g_date,
793: p_course_end_time in varchar2 default hr_api.g_varchar2,
794: p_course_start_date in date default hr_api.g_date,
795: p_course_start_time in varchar2 default hr_api.g_varchar2,
788: p_actual_cost in number default hr_api.g_number,
789: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
790: p_centre in varchar2 default hr_api.g_varchar2,
791: p_comments in varchar2 default hr_api.g_varchar2,
792: p_course_end_date in date default hr_api.g_date,
793: p_course_end_time in varchar2 default hr_api.g_varchar2,
794: p_course_start_date in date default hr_api.g_date,
795: p_course_start_time in varchar2 default hr_api.g_varchar2,
796: p_duration in number default hr_api.g_number,
789: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
790: p_centre in varchar2 default hr_api.g_varchar2,
791: p_comments in varchar2 default hr_api.g_varchar2,
792: p_course_end_date in date default hr_api.g_date,
793: p_course_end_time in varchar2 default hr_api.g_varchar2,
794: p_course_start_date in date default hr_api.g_date,
795: p_course_start_time in varchar2 default hr_api.g_varchar2,
796: p_duration in number default hr_api.g_number,
797: p_duration_units in varchar2 default hr_api.g_varchar2,
790: p_centre in varchar2 default hr_api.g_varchar2,
791: p_comments in varchar2 default hr_api.g_varchar2,
792: p_course_end_date in date default hr_api.g_date,
793: p_course_end_time in varchar2 default hr_api.g_varchar2,
794: p_course_start_date in date default hr_api.g_date,
795: p_course_start_time in varchar2 default hr_api.g_varchar2,
796: p_duration in number default hr_api.g_number,
797: p_duration_units in varchar2 default hr_api.g_varchar2,
798: p_enrolment_end_date in date default hr_api.g_date,
791: p_comments in varchar2 default hr_api.g_varchar2,
792: p_course_end_date in date default hr_api.g_date,
793: p_course_end_time in varchar2 default hr_api.g_varchar2,
794: p_course_start_date in date default hr_api.g_date,
795: p_course_start_time in varchar2 default hr_api.g_varchar2,
796: p_duration in number default hr_api.g_number,
797: p_duration_units in varchar2 default hr_api.g_varchar2,
798: p_enrolment_end_date in date default hr_api.g_date,
799: p_enrolment_start_date in date default hr_api.g_date,
792: p_course_end_date in date default hr_api.g_date,
793: p_course_end_time in varchar2 default hr_api.g_varchar2,
794: p_course_start_date in date default hr_api.g_date,
795: p_course_start_time in varchar2 default hr_api.g_varchar2,
796: p_duration in number default hr_api.g_number,
797: p_duration_units in varchar2 default hr_api.g_varchar2,
798: p_enrolment_end_date in date default hr_api.g_date,
799: p_enrolment_start_date in date default hr_api.g_date,
800: p_language_id in number default hr_api.g_number,
793: p_course_end_time in varchar2 default hr_api.g_varchar2,
794: p_course_start_date in date default hr_api.g_date,
795: p_course_start_time in varchar2 default hr_api.g_varchar2,
796: p_duration in number default hr_api.g_number,
797: p_duration_units in varchar2 default hr_api.g_varchar2,
798: p_enrolment_end_date in date default hr_api.g_date,
799: p_enrolment_start_date in date default hr_api.g_date,
800: p_language_id in number default hr_api.g_number,
801: p_user_status in varchar2 default hr_api.g_varchar2,
794: p_course_start_date in date default hr_api.g_date,
795: p_course_start_time in varchar2 default hr_api.g_varchar2,
796: p_duration in number default hr_api.g_number,
797: p_duration_units in varchar2 default hr_api.g_varchar2,
798: p_enrolment_end_date in date default hr_api.g_date,
799: p_enrolment_start_date in date default hr_api.g_date,
800: p_language_id in number default hr_api.g_number,
801: p_user_status in varchar2 default hr_api.g_varchar2,
802: p_development_event_type in varchar2 default hr_api.g_varchar2,
795: p_course_start_time in varchar2 default hr_api.g_varchar2,
796: p_duration in number default hr_api.g_number,
797: p_duration_units in varchar2 default hr_api.g_varchar2,
798: p_enrolment_end_date in date default hr_api.g_date,
799: p_enrolment_start_date in date default hr_api.g_date,
800: p_language_id in number default hr_api.g_number,
801: p_user_status in varchar2 default hr_api.g_varchar2,
802: p_development_event_type in varchar2 default hr_api.g_varchar2,
803: p_event_status in varchar2 default hr_api.g_varchar2,
796: p_duration in number default hr_api.g_number,
797: p_duration_units in varchar2 default hr_api.g_varchar2,
798: p_enrolment_end_date in date default hr_api.g_date,
799: p_enrolment_start_date in date default hr_api.g_date,
800: p_language_id in number default hr_api.g_number,
801: p_user_status in varchar2 default hr_api.g_varchar2,
802: p_development_event_type in varchar2 default hr_api.g_varchar2,
803: p_event_status in varchar2 default hr_api.g_varchar2,
804: p_price_basis in varchar2 default hr_api.g_varchar2,
797: p_duration_units in varchar2 default hr_api.g_varchar2,
798: p_enrolment_end_date in date default hr_api.g_date,
799: p_enrolment_start_date in date default hr_api.g_date,
800: p_language_id in number default hr_api.g_number,
801: p_user_status in varchar2 default hr_api.g_varchar2,
802: p_development_event_type in varchar2 default hr_api.g_varchar2,
803: p_event_status in varchar2 default hr_api.g_varchar2,
804: p_price_basis in varchar2 default hr_api.g_varchar2,
805: p_currency_code in varchar2 default hr_api.g_varchar2,
798: p_enrolment_end_date in date default hr_api.g_date,
799: p_enrolment_start_date in date default hr_api.g_date,
800: p_language_id in number default hr_api.g_number,
801: p_user_status in varchar2 default hr_api.g_varchar2,
802: p_development_event_type in varchar2 default hr_api.g_varchar2,
803: p_event_status in varchar2 default hr_api.g_varchar2,
804: p_price_basis in varchar2 default hr_api.g_varchar2,
805: p_currency_code in varchar2 default hr_api.g_varchar2,
806: p_maximum_attendees in number default hr_api.g_number,
799: p_enrolment_start_date in date default hr_api.g_date,
800: p_language_id in number default hr_api.g_number,
801: p_user_status in varchar2 default hr_api.g_varchar2,
802: p_development_event_type in varchar2 default hr_api.g_varchar2,
803: p_event_status in varchar2 default hr_api.g_varchar2,
804: p_price_basis in varchar2 default hr_api.g_varchar2,
805: p_currency_code in varchar2 default hr_api.g_varchar2,
806: p_maximum_attendees in number default hr_api.g_number,
807: p_maximum_internal_attendees in number default hr_api.g_number,
800: p_language_id in number default hr_api.g_number,
801: p_user_status in varchar2 default hr_api.g_varchar2,
802: p_development_event_type in varchar2 default hr_api.g_varchar2,
803: p_event_status in varchar2 default hr_api.g_varchar2,
804: p_price_basis in varchar2 default hr_api.g_varchar2,
805: p_currency_code in varchar2 default hr_api.g_varchar2,
806: p_maximum_attendees in number default hr_api.g_number,
807: p_maximum_internal_attendees in number default hr_api.g_number,
808: p_minimum_attendees in number default hr_api.g_number,
801: p_user_status in varchar2 default hr_api.g_varchar2,
802: p_development_event_type in varchar2 default hr_api.g_varchar2,
803: p_event_status in varchar2 default hr_api.g_varchar2,
804: p_price_basis in varchar2 default hr_api.g_varchar2,
805: p_currency_code in varchar2 default hr_api.g_varchar2,
806: p_maximum_attendees in number default hr_api.g_number,
807: p_maximum_internal_attendees in number default hr_api.g_number,
808: p_minimum_attendees in number default hr_api.g_number,
809: p_standard_price in number default hr_api.g_number,
802: p_development_event_type in varchar2 default hr_api.g_varchar2,
803: p_event_status in varchar2 default hr_api.g_varchar2,
804: p_price_basis in varchar2 default hr_api.g_varchar2,
805: p_currency_code in varchar2 default hr_api.g_varchar2,
806: p_maximum_attendees in number default hr_api.g_number,
807: p_maximum_internal_attendees in number default hr_api.g_number,
808: p_minimum_attendees in number default hr_api.g_number,
809: p_standard_price in number default hr_api.g_number,
810: p_category_code in varchar2 default hr_api.g_varchar2,
803: p_event_status in varchar2 default hr_api.g_varchar2,
804: p_price_basis in varchar2 default hr_api.g_varchar2,
805: p_currency_code in varchar2 default hr_api.g_varchar2,
806: p_maximum_attendees in number default hr_api.g_number,
807: p_maximum_internal_attendees in number default hr_api.g_number,
808: p_minimum_attendees in number default hr_api.g_number,
809: p_standard_price in number default hr_api.g_number,
810: p_category_code in varchar2 default hr_api.g_varchar2,
811: p_parent_event_id in number default hr_api.g_number,
804: p_price_basis in varchar2 default hr_api.g_varchar2,
805: p_currency_code in varchar2 default hr_api.g_varchar2,
806: p_maximum_attendees in number default hr_api.g_number,
807: p_maximum_internal_attendees in number default hr_api.g_number,
808: p_minimum_attendees in number default hr_api.g_number,
809: p_standard_price in number default hr_api.g_number,
810: p_category_code in varchar2 default hr_api.g_varchar2,
811: p_parent_event_id in number default hr_api.g_number,
812: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
805: p_currency_code in varchar2 default hr_api.g_varchar2,
806: p_maximum_attendees in number default hr_api.g_number,
807: p_maximum_internal_attendees in number default hr_api.g_number,
808: p_minimum_attendees in number default hr_api.g_number,
809: p_standard_price in number default hr_api.g_number,
810: p_category_code in varchar2 default hr_api.g_varchar2,
811: p_parent_event_id in number default hr_api.g_number,
812: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
813: p_public_event_flag in varchar2 default hr_api.g_varchar2,
806: p_maximum_attendees in number default hr_api.g_number,
807: p_maximum_internal_attendees in number default hr_api.g_number,
808: p_minimum_attendees in number default hr_api.g_number,
809: p_standard_price in number default hr_api.g_number,
810: p_category_code in varchar2 default hr_api.g_varchar2,
811: p_parent_event_id in number default hr_api.g_number,
812: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
813: p_public_event_flag in varchar2 default hr_api.g_varchar2,
814: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
807: p_maximum_internal_attendees in number default hr_api.g_number,
808: p_minimum_attendees in number default hr_api.g_number,
809: p_standard_price in number default hr_api.g_number,
810: p_category_code in varchar2 default hr_api.g_varchar2,
811: p_parent_event_id in number default hr_api.g_number,
812: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
813: p_public_event_flag in varchar2 default hr_api.g_varchar2,
814: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
815: p_evt_information_category in varchar2 default hr_api.g_varchar2,
808: p_minimum_attendees in number default hr_api.g_number,
809: p_standard_price in number default hr_api.g_number,
810: p_category_code in varchar2 default hr_api.g_varchar2,
811: p_parent_event_id in number default hr_api.g_number,
812: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
813: p_public_event_flag in varchar2 default hr_api.g_varchar2,
814: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
815: p_evt_information_category in varchar2 default hr_api.g_varchar2,
816: p_evt_information1 in varchar2 default hr_api.g_varchar2,
809: p_standard_price in number default hr_api.g_number,
810: p_category_code in varchar2 default hr_api.g_varchar2,
811: p_parent_event_id in number default hr_api.g_number,
812: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
813: p_public_event_flag in varchar2 default hr_api.g_varchar2,
814: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
815: p_evt_information_category in varchar2 default hr_api.g_varchar2,
816: p_evt_information1 in varchar2 default hr_api.g_varchar2,
817: p_evt_information2 in varchar2 default hr_api.g_varchar2,
810: p_category_code in varchar2 default hr_api.g_varchar2,
811: p_parent_event_id in number default hr_api.g_number,
812: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
813: p_public_event_flag in varchar2 default hr_api.g_varchar2,
814: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
815: p_evt_information_category in varchar2 default hr_api.g_varchar2,
816: p_evt_information1 in varchar2 default hr_api.g_varchar2,
817: p_evt_information2 in varchar2 default hr_api.g_varchar2,
818: p_evt_information3 in varchar2 default hr_api.g_varchar2,
811: p_parent_event_id in number default hr_api.g_number,
812: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
813: p_public_event_flag in varchar2 default hr_api.g_varchar2,
814: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
815: p_evt_information_category in varchar2 default hr_api.g_varchar2,
816: p_evt_information1 in varchar2 default hr_api.g_varchar2,
817: p_evt_information2 in varchar2 default hr_api.g_varchar2,
818: p_evt_information3 in varchar2 default hr_api.g_varchar2,
819: p_evt_information4 in varchar2 default hr_api.g_varchar2,
812: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
813: p_public_event_flag in varchar2 default hr_api.g_varchar2,
814: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
815: p_evt_information_category in varchar2 default hr_api.g_varchar2,
816: p_evt_information1 in varchar2 default hr_api.g_varchar2,
817: p_evt_information2 in varchar2 default hr_api.g_varchar2,
818: p_evt_information3 in varchar2 default hr_api.g_varchar2,
819: p_evt_information4 in varchar2 default hr_api.g_varchar2,
820: p_evt_information5 in varchar2 default hr_api.g_varchar2,
813: p_public_event_flag in varchar2 default hr_api.g_varchar2,
814: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
815: p_evt_information_category in varchar2 default hr_api.g_varchar2,
816: p_evt_information1 in varchar2 default hr_api.g_varchar2,
817: p_evt_information2 in varchar2 default hr_api.g_varchar2,
818: p_evt_information3 in varchar2 default hr_api.g_varchar2,
819: p_evt_information4 in varchar2 default hr_api.g_varchar2,
820: p_evt_information5 in varchar2 default hr_api.g_varchar2,
821: p_evt_information6 in varchar2 default hr_api.g_varchar2,
814: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
815: p_evt_information_category in varchar2 default hr_api.g_varchar2,
816: p_evt_information1 in varchar2 default hr_api.g_varchar2,
817: p_evt_information2 in varchar2 default hr_api.g_varchar2,
818: p_evt_information3 in varchar2 default hr_api.g_varchar2,
819: p_evt_information4 in varchar2 default hr_api.g_varchar2,
820: p_evt_information5 in varchar2 default hr_api.g_varchar2,
821: p_evt_information6 in varchar2 default hr_api.g_varchar2,
822: p_evt_information7 in varchar2 default hr_api.g_varchar2,
815: p_evt_information_category in varchar2 default hr_api.g_varchar2,
816: p_evt_information1 in varchar2 default hr_api.g_varchar2,
817: p_evt_information2 in varchar2 default hr_api.g_varchar2,
818: p_evt_information3 in varchar2 default hr_api.g_varchar2,
819: p_evt_information4 in varchar2 default hr_api.g_varchar2,
820: p_evt_information5 in varchar2 default hr_api.g_varchar2,
821: p_evt_information6 in varchar2 default hr_api.g_varchar2,
822: p_evt_information7 in varchar2 default hr_api.g_varchar2,
823: p_evt_information8 in varchar2 default hr_api.g_varchar2,
816: p_evt_information1 in varchar2 default hr_api.g_varchar2,
817: p_evt_information2 in varchar2 default hr_api.g_varchar2,
818: p_evt_information3 in varchar2 default hr_api.g_varchar2,
819: p_evt_information4 in varchar2 default hr_api.g_varchar2,
820: p_evt_information5 in varchar2 default hr_api.g_varchar2,
821: p_evt_information6 in varchar2 default hr_api.g_varchar2,
822: p_evt_information7 in varchar2 default hr_api.g_varchar2,
823: p_evt_information8 in varchar2 default hr_api.g_varchar2,
824: p_evt_information9 in varchar2 default hr_api.g_varchar2,
817: p_evt_information2 in varchar2 default hr_api.g_varchar2,
818: p_evt_information3 in varchar2 default hr_api.g_varchar2,
819: p_evt_information4 in varchar2 default hr_api.g_varchar2,
820: p_evt_information5 in varchar2 default hr_api.g_varchar2,
821: p_evt_information6 in varchar2 default hr_api.g_varchar2,
822: p_evt_information7 in varchar2 default hr_api.g_varchar2,
823: p_evt_information8 in varchar2 default hr_api.g_varchar2,
824: p_evt_information9 in varchar2 default hr_api.g_varchar2,
825: p_evt_information10 in varchar2 default hr_api.g_varchar2,
818: p_evt_information3 in varchar2 default hr_api.g_varchar2,
819: p_evt_information4 in varchar2 default hr_api.g_varchar2,
820: p_evt_information5 in varchar2 default hr_api.g_varchar2,
821: p_evt_information6 in varchar2 default hr_api.g_varchar2,
822: p_evt_information7 in varchar2 default hr_api.g_varchar2,
823: p_evt_information8 in varchar2 default hr_api.g_varchar2,
824: p_evt_information9 in varchar2 default hr_api.g_varchar2,
825: p_evt_information10 in varchar2 default hr_api.g_varchar2,
826: p_evt_information11 in varchar2 default hr_api.g_varchar2,
819: p_evt_information4 in varchar2 default hr_api.g_varchar2,
820: p_evt_information5 in varchar2 default hr_api.g_varchar2,
821: p_evt_information6 in varchar2 default hr_api.g_varchar2,
822: p_evt_information7 in varchar2 default hr_api.g_varchar2,
823: p_evt_information8 in varchar2 default hr_api.g_varchar2,
824: p_evt_information9 in varchar2 default hr_api.g_varchar2,
825: p_evt_information10 in varchar2 default hr_api.g_varchar2,
826: p_evt_information11 in varchar2 default hr_api.g_varchar2,
827: p_evt_information12 in varchar2 default hr_api.g_varchar2,
820: p_evt_information5 in varchar2 default hr_api.g_varchar2,
821: p_evt_information6 in varchar2 default hr_api.g_varchar2,
822: p_evt_information7 in varchar2 default hr_api.g_varchar2,
823: p_evt_information8 in varchar2 default hr_api.g_varchar2,
824: p_evt_information9 in varchar2 default hr_api.g_varchar2,
825: p_evt_information10 in varchar2 default hr_api.g_varchar2,
826: p_evt_information11 in varchar2 default hr_api.g_varchar2,
827: p_evt_information12 in varchar2 default hr_api.g_varchar2,
828: p_evt_information13 in varchar2 default hr_api.g_varchar2,
821: p_evt_information6 in varchar2 default hr_api.g_varchar2,
822: p_evt_information7 in varchar2 default hr_api.g_varchar2,
823: p_evt_information8 in varchar2 default hr_api.g_varchar2,
824: p_evt_information9 in varchar2 default hr_api.g_varchar2,
825: p_evt_information10 in varchar2 default hr_api.g_varchar2,
826: p_evt_information11 in varchar2 default hr_api.g_varchar2,
827: p_evt_information12 in varchar2 default hr_api.g_varchar2,
828: p_evt_information13 in varchar2 default hr_api.g_varchar2,
829: p_evt_information14 in varchar2 default hr_api.g_varchar2,
822: p_evt_information7 in varchar2 default hr_api.g_varchar2,
823: p_evt_information8 in varchar2 default hr_api.g_varchar2,
824: p_evt_information9 in varchar2 default hr_api.g_varchar2,
825: p_evt_information10 in varchar2 default hr_api.g_varchar2,
826: p_evt_information11 in varchar2 default hr_api.g_varchar2,
827: p_evt_information12 in varchar2 default hr_api.g_varchar2,
828: p_evt_information13 in varchar2 default hr_api.g_varchar2,
829: p_evt_information14 in varchar2 default hr_api.g_varchar2,
830: p_evt_information15 in varchar2 default hr_api.g_varchar2,
823: p_evt_information8 in varchar2 default hr_api.g_varchar2,
824: p_evt_information9 in varchar2 default hr_api.g_varchar2,
825: p_evt_information10 in varchar2 default hr_api.g_varchar2,
826: p_evt_information11 in varchar2 default hr_api.g_varchar2,
827: p_evt_information12 in varchar2 default hr_api.g_varchar2,
828: p_evt_information13 in varchar2 default hr_api.g_varchar2,
829: p_evt_information14 in varchar2 default hr_api.g_varchar2,
830: p_evt_information15 in varchar2 default hr_api.g_varchar2,
831: p_evt_information16 in varchar2 default hr_api.g_varchar2,
824: p_evt_information9 in varchar2 default hr_api.g_varchar2,
825: p_evt_information10 in varchar2 default hr_api.g_varchar2,
826: p_evt_information11 in varchar2 default hr_api.g_varchar2,
827: p_evt_information12 in varchar2 default hr_api.g_varchar2,
828: p_evt_information13 in varchar2 default hr_api.g_varchar2,
829: p_evt_information14 in varchar2 default hr_api.g_varchar2,
830: p_evt_information15 in varchar2 default hr_api.g_varchar2,
831: p_evt_information16 in varchar2 default hr_api.g_varchar2,
832: p_evt_information17 in varchar2 default hr_api.g_varchar2,
825: p_evt_information10 in varchar2 default hr_api.g_varchar2,
826: p_evt_information11 in varchar2 default hr_api.g_varchar2,
827: p_evt_information12 in varchar2 default hr_api.g_varchar2,
828: p_evt_information13 in varchar2 default hr_api.g_varchar2,
829: p_evt_information14 in varchar2 default hr_api.g_varchar2,
830: p_evt_information15 in varchar2 default hr_api.g_varchar2,
831: p_evt_information16 in varchar2 default hr_api.g_varchar2,
832: p_evt_information17 in varchar2 default hr_api.g_varchar2,
833: p_evt_information18 in varchar2 default hr_api.g_varchar2,
826: p_evt_information11 in varchar2 default hr_api.g_varchar2,
827: p_evt_information12 in varchar2 default hr_api.g_varchar2,
828: p_evt_information13 in varchar2 default hr_api.g_varchar2,
829: p_evt_information14 in varchar2 default hr_api.g_varchar2,
830: p_evt_information15 in varchar2 default hr_api.g_varchar2,
831: p_evt_information16 in varchar2 default hr_api.g_varchar2,
832: p_evt_information17 in varchar2 default hr_api.g_varchar2,
833: p_evt_information18 in varchar2 default hr_api.g_varchar2,
834: p_evt_information19 in varchar2 default hr_api.g_varchar2,
827: p_evt_information12 in varchar2 default hr_api.g_varchar2,
828: p_evt_information13 in varchar2 default hr_api.g_varchar2,
829: p_evt_information14 in varchar2 default hr_api.g_varchar2,
830: p_evt_information15 in varchar2 default hr_api.g_varchar2,
831: p_evt_information16 in varchar2 default hr_api.g_varchar2,
832: p_evt_information17 in varchar2 default hr_api.g_varchar2,
833: p_evt_information18 in varchar2 default hr_api.g_varchar2,
834: p_evt_information19 in varchar2 default hr_api.g_varchar2,
835: p_evt_information20 in varchar2 default hr_api.g_varchar2,
828: p_evt_information13 in varchar2 default hr_api.g_varchar2,
829: p_evt_information14 in varchar2 default hr_api.g_varchar2,
830: p_evt_information15 in varchar2 default hr_api.g_varchar2,
831: p_evt_information16 in varchar2 default hr_api.g_varchar2,
832: p_evt_information17 in varchar2 default hr_api.g_varchar2,
833: p_evt_information18 in varchar2 default hr_api.g_varchar2,
834: p_evt_information19 in varchar2 default hr_api.g_varchar2,
835: p_evt_information20 in varchar2 default hr_api.g_varchar2,
836: p_project_id in number default hr_api.g_number,
829: p_evt_information14 in varchar2 default hr_api.g_varchar2,
830: p_evt_information15 in varchar2 default hr_api.g_varchar2,
831: p_evt_information16 in varchar2 default hr_api.g_varchar2,
832: p_evt_information17 in varchar2 default hr_api.g_varchar2,
833: p_evt_information18 in varchar2 default hr_api.g_varchar2,
834: p_evt_information19 in varchar2 default hr_api.g_varchar2,
835: p_evt_information20 in varchar2 default hr_api.g_varchar2,
836: p_project_id in number default hr_api.g_number,
837: p_owner_id in number default hr_api.g_number,
830: p_evt_information15 in varchar2 default hr_api.g_varchar2,
831: p_evt_information16 in varchar2 default hr_api.g_varchar2,
832: p_evt_information17 in varchar2 default hr_api.g_varchar2,
833: p_evt_information18 in varchar2 default hr_api.g_varchar2,
834: p_evt_information19 in varchar2 default hr_api.g_varchar2,
835: p_evt_information20 in varchar2 default hr_api.g_varchar2,
836: p_project_id in number default hr_api.g_number,
837: p_owner_id in number default hr_api.g_number,
838: p_line_id in number default hr_api.g_number,
831: p_evt_information16 in varchar2 default hr_api.g_varchar2,
832: p_evt_information17 in varchar2 default hr_api.g_varchar2,
833: p_evt_information18 in varchar2 default hr_api.g_varchar2,
834: p_evt_information19 in varchar2 default hr_api.g_varchar2,
835: p_evt_information20 in varchar2 default hr_api.g_varchar2,
836: p_project_id in number default hr_api.g_number,
837: p_owner_id in number default hr_api.g_number,
838: p_line_id in number default hr_api.g_number,
839: p_org_id in number default hr_api.g_number,
832: p_evt_information17 in varchar2 default hr_api.g_varchar2,
833: p_evt_information18 in varchar2 default hr_api.g_varchar2,
834: p_evt_information19 in varchar2 default hr_api.g_varchar2,
835: p_evt_information20 in varchar2 default hr_api.g_varchar2,
836: p_project_id in number default hr_api.g_number,
837: p_owner_id in number default hr_api.g_number,
838: p_line_id in number default hr_api.g_number,
839: p_org_id in number default hr_api.g_number,
840: p_training_center_id in number default hr_api.g_number,
833: p_evt_information18 in varchar2 default hr_api.g_varchar2,
834: p_evt_information19 in varchar2 default hr_api.g_varchar2,
835: p_evt_information20 in varchar2 default hr_api.g_varchar2,
836: p_project_id in number default hr_api.g_number,
837: p_owner_id in number default hr_api.g_number,
838: p_line_id in number default hr_api.g_number,
839: p_org_id in number default hr_api.g_number,
840: p_training_center_id in number default hr_api.g_number,
841: p_location_id in number default hr_api.g_number,
834: p_evt_information19 in varchar2 default hr_api.g_varchar2,
835: p_evt_information20 in varchar2 default hr_api.g_varchar2,
836: p_project_id in number default hr_api.g_number,
837: p_owner_id in number default hr_api.g_number,
838: p_line_id in number default hr_api.g_number,
839: p_org_id in number default hr_api.g_number,
840: p_training_center_id in number default hr_api.g_number,
841: p_location_id in number default hr_api.g_number,
842: p_offering_id in number default hr_api.g_number,
835: p_evt_information20 in varchar2 default hr_api.g_varchar2,
836: p_project_id in number default hr_api.g_number,
837: p_owner_id in number default hr_api.g_number,
838: p_line_id in number default hr_api.g_number,
839: p_org_id in number default hr_api.g_number,
840: p_training_center_id in number default hr_api.g_number,
841: p_location_id in number default hr_api.g_number,
842: p_offering_id in number default hr_api.g_number,
843: p_timezone in varchar2 default hr_api.g_varchar2,
836: p_project_id in number default hr_api.g_number,
837: p_owner_id in number default hr_api.g_number,
838: p_line_id in number default hr_api.g_number,
839: p_org_id in number default hr_api.g_number,
840: p_training_center_id in number default hr_api.g_number,
841: p_location_id in number default hr_api.g_number,
842: p_offering_id in number default hr_api.g_number,
843: p_timezone in varchar2 default hr_api.g_varchar2,
844: p_parent_offering_id in number default hr_api.g_number,
837: p_owner_id in number default hr_api.g_number,
838: p_line_id in number default hr_api.g_number,
839: p_org_id in number default hr_api.g_number,
840: p_training_center_id in number default hr_api.g_number,
841: p_location_id in number default hr_api.g_number,
842: p_offering_id in number default hr_api.g_number,
843: p_timezone in varchar2 default hr_api.g_varchar2,
844: p_parent_offering_id in number default hr_api.g_number,
845: p_data_source in varchar2 default hr_api.g_varchar2,
838: p_line_id in number default hr_api.g_number,
839: p_org_id in number default hr_api.g_number,
840: p_training_center_id in number default hr_api.g_number,
841: p_location_id in number default hr_api.g_number,
842: p_offering_id in number default hr_api.g_number,
843: p_timezone in varchar2 default hr_api.g_varchar2,
844: p_parent_offering_id in number default hr_api.g_number,
845: p_data_source in varchar2 default hr_api.g_varchar2,
846: -- Bug#2200078 Corrected default value for offering_id and timezone
839: p_org_id in number default hr_api.g_number,
840: p_training_center_id in number default hr_api.g_number,
841: p_location_id in number default hr_api.g_number,
842: p_offering_id in number default hr_api.g_number,
843: p_timezone in varchar2 default hr_api.g_varchar2,
844: p_parent_offering_id in number default hr_api.g_number,
845: p_data_source in varchar2 default hr_api.g_varchar2,
846: -- Bug#2200078 Corrected default value for offering_id and timezone
847: -- p_offering_id in number default null,
840: p_training_center_id in number default hr_api.g_number,
841: p_location_id in number default hr_api.g_number,
842: p_offering_id in number default hr_api.g_number,
843: p_timezone in varchar2 default hr_api.g_varchar2,
844: p_parent_offering_id in number default hr_api.g_number,
845: p_data_source in varchar2 default hr_api.g_varchar2,
846: -- Bug#2200078 Corrected default value for offering_id and timezone
847: -- p_offering_id in number default null,
848: -- p_timezone in varchar2 default null,
841: p_location_id in number default hr_api.g_number,
842: p_offering_id in number default hr_api.g_number,
843: p_timezone in varchar2 default hr_api.g_varchar2,
844: p_parent_offering_id in number default hr_api.g_number,
845: p_data_source in varchar2 default hr_api.g_varchar2,
846: -- Bug#2200078 Corrected default value for offering_id and timezone
847: -- p_offering_id in number default null,
848: -- p_timezone in varchar2 default null,
849: p_validate in boolean default false