eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_EVT_UPD dependencies on HR_API

Line 146: When hr_api.check_integrity_violated Then

142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: --
145: Exception
146: When hr_api.check_integrity_violated Then
147: -- A check constraint has been violated
148: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
149: ota_evt_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

146: When hr_api.check_integrity_violated Then
147: -- A check constraint has been violated
148: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
149: ota_evt_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When hr_api.parent_integrity_violated Then
152: -- Parent integrity has been violated
153: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
154: ota_evt_shd.constraint_error

Line 151: When hr_api.parent_integrity_violated Then

147: -- A check constraint has been violated
148: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
149: ota_evt_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When hr_api.parent_integrity_violated Then
152: -- Parent integrity has been violated
153: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
154: ota_evt_shd.constraint_error
155: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 155: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

151: When hr_api.parent_integrity_violated Then
152: -- Parent integrity has been violated
153: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
154: ota_evt_shd.constraint_error
155: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
156: When hr_api.unique_integrity_violated Then
157: -- Unique integrity has been violated
158: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
159: ota_evt_shd.constraint_error

Line 156: When hr_api.unique_integrity_violated Then

152: -- Parent integrity has been violated
153: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
154: ota_evt_shd.constraint_error
155: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
156: When hr_api.unique_integrity_violated Then
157: -- Unique integrity has been violated
158: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
159: ota_evt_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

156: When hr_api.unique_integrity_violated Then
157: -- Unique integrity has been violated
158: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
159: ota_evt_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When Others Then
162: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
163: Raise;
164: End update_dml;

Line 315: If (p_rec.vendor_id = hr_api.g_number) then

311: -- p_rec plsql record structure
312: -- to see if a system default is being used. If a system default
313: -- is being used then we must set to the 'current' argument value.
314: --
315: If (p_rec.vendor_id = hr_api.g_number) then
316: p_rec.vendor_id :=
317: ota_evt_shd.g_old_rec.vendor_id;
318: End If;
319: If (p_rec.activity_version_id = hr_api.g_number) then

Line 319: If (p_rec.activity_version_id = hr_api.g_number) then

315: If (p_rec.vendor_id = hr_api.g_number) then
316: p_rec.vendor_id :=
317: ota_evt_shd.g_old_rec.vendor_id;
318: End If;
319: If (p_rec.activity_version_id = hr_api.g_number) then
320: p_rec.activity_version_id :=
321: ota_evt_shd.g_old_rec.activity_version_id;
322: End If;
323: If (p_rec.business_group_id = hr_api.g_number) then

Line 323: If (p_rec.business_group_id = hr_api.g_number) then

319: If (p_rec.activity_version_id = hr_api.g_number) then
320: p_rec.activity_version_id :=
321: ota_evt_shd.g_old_rec.activity_version_id;
322: End If;
323: If (p_rec.business_group_id = hr_api.g_number) then
324: p_rec.business_group_id :=
325: ota_evt_shd.g_old_rec.business_group_id;
326: End If;
327: If (p_rec.organization_id = hr_api.g_number) then

Line 327: If (p_rec.organization_id = hr_api.g_number) then

323: If (p_rec.business_group_id = hr_api.g_number) then
324: p_rec.business_group_id :=
325: ota_evt_shd.g_old_rec.business_group_id;
326: End If;
327: If (p_rec.organization_id = hr_api.g_number) then
328: p_rec.organization_id :=
329: ota_evt_shd.g_old_rec.organization_id;
330: End If;
331: If (p_rec.event_type = hr_api.g_varchar2) then

Line 331: If (p_rec.event_type = hr_api.g_varchar2) then

327: If (p_rec.organization_id = hr_api.g_number) then
328: p_rec.organization_id :=
329: ota_evt_shd.g_old_rec.organization_id;
330: End If;
331: If (p_rec.event_type = hr_api.g_varchar2) then
332: p_rec.event_type :=
333: ota_evt_shd.g_old_rec.event_type;
334: End If;
335: If (p_rec.title = hr_api.g_varchar2) then

Line 335: If (p_rec.title = hr_api.g_varchar2) then

331: If (p_rec.event_type = hr_api.g_varchar2) then
332: p_rec.event_type :=
333: ota_evt_shd.g_old_rec.event_type;
334: End If;
335: If (p_rec.title = hr_api.g_varchar2) then
336: p_rec.title :=
337: ota_evt_shd.g_old_rec.title;
338: End If;
339: If (p_rec.budget_cost = hr_api.g_number) then

Line 339: If (p_rec.budget_cost = hr_api.g_number) then

335: If (p_rec.title = hr_api.g_varchar2) then
336: p_rec.title :=
337: ota_evt_shd.g_old_rec.title;
338: End If;
339: If (p_rec.budget_cost = hr_api.g_number) then
340: p_rec.budget_cost :=
341: ota_evt_shd.g_old_rec.budget_cost;
342: End If;
343: If (p_rec.actual_cost = hr_api.g_number) then

Line 343: If (p_rec.actual_cost = hr_api.g_number) then

339: If (p_rec.budget_cost = hr_api.g_number) then
340: p_rec.budget_cost :=
341: ota_evt_shd.g_old_rec.budget_cost;
342: End If;
343: If (p_rec.actual_cost = hr_api.g_number) then
344: p_rec.actual_cost :=
345: ota_evt_shd.g_old_rec.actual_cost;
346: End If;
347: If (p_rec.budget_currency_code = hr_api.g_varchar2) then

Line 347: If (p_rec.budget_currency_code = hr_api.g_varchar2) then

343: If (p_rec.actual_cost = hr_api.g_number) then
344: p_rec.actual_cost :=
345: ota_evt_shd.g_old_rec.actual_cost;
346: End If;
347: If (p_rec.budget_currency_code = hr_api.g_varchar2) then
348: p_rec.budget_currency_code :=
349: ota_evt_shd.g_old_rec.budget_currency_code;
350: End If;
351: If (p_rec.centre = hr_api.g_varchar2) then

Line 351: If (p_rec.centre = hr_api.g_varchar2) then

347: If (p_rec.budget_currency_code = hr_api.g_varchar2) then
348: p_rec.budget_currency_code :=
349: ota_evt_shd.g_old_rec.budget_currency_code;
350: End If;
351: If (p_rec.centre = hr_api.g_varchar2) then
352: p_rec.centre :=
353: ota_evt_shd.g_old_rec.centre;
354: End If;
355: If (p_rec.comments = hr_api.g_varchar2) then

Line 355: If (p_rec.comments = hr_api.g_varchar2) then

351: If (p_rec.centre = hr_api.g_varchar2) then
352: p_rec.centre :=
353: ota_evt_shd.g_old_rec.centre;
354: End If;
355: If (p_rec.comments = hr_api.g_varchar2) then
356: p_rec.comments :=
357: ota_evt_shd.g_old_rec.comments;
358: End If;
359: If (p_rec.course_end_date = hr_api.g_date) then

Line 359: If (p_rec.course_end_date = hr_api.g_date) then

355: If (p_rec.comments = hr_api.g_varchar2) then
356: p_rec.comments :=
357: ota_evt_shd.g_old_rec.comments;
358: End If;
359: If (p_rec.course_end_date = hr_api.g_date) then
360: p_rec.course_end_date :=
361: ota_evt_shd.g_old_rec.course_end_date;
362: End If;
363: If (p_rec.course_end_time = hr_api.g_varchar2) then

Line 363: If (p_rec.course_end_time = hr_api.g_varchar2) then

359: If (p_rec.course_end_date = hr_api.g_date) then
360: p_rec.course_end_date :=
361: ota_evt_shd.g_old_rec.course_end_date;
362: End If;
363: If (p_rec.course_end_time = hr_api.g_varchar2) then
364: p_rec.course_end_time :=
365: ota_evt_shd.g_old_rec.course_end_time;
366: End If;
367: If (p_rec.course_start_date = hr_api.g_date) then

Line 367: If (p_rec.course_start_date = hr_api.g_date) then

363: If (p_rec.course_end_time = hr_api.g_varchar2) then
364: p_rec.course_end_time :=
365: ota_evt_shd.g_old_rec.course_end_time;
366: End If;
367: If (p_rec.course_start_date = hr_api.g_date) then
368: p_rec.course_start_date :=
369: ota_evt_shd.g_old_rec.course_start_date;
370: End If;
371: If (p_rec.course_start_time = hr_api.g_varchar2) then

Line 371: If (p_rec.course_start_time = hr_api.g_varchar2) then

367: If (p_rec.course_start_date = hr_api.g_date) then
368: p_rec.course_start_date :=
369: ota_evt_shd.g_old_rec.course_start_date;
370: End If;
371: If (p_rec.course_start_time = hr_api.g_varchar2) then
372: p_rec.course_start_time :=
373: ota_evt_shd.g_old_rec.course_start_time;
374: End If;
375: If (p_rec.duration = hr_api.g_number) then

Line 375: If (p_rec.duration = hr_api.g_number) then

371: If (p_rec.course_start_time = hr_api.g_varchar2) then
372: p_rec.course_start_time :=
373: ota_evt_shd.g_old_rec.course_start_time;
374: End If;
375: If (p_rec.duration = hr_api.g_number) then
376: p_rec.duration :=
377: ota_evt_shd.g_old_rec.duration;
378: End If;
379: If (p_rec.duration_units = hr_api.g_varchar2) then

Line 379: If (p_rec.duration_units = hr_api.g_varchar2) then

375: If (p_rec.duration = hr_api.g_number) then
376: p_rec.duration :=
377: ota_evt_shd.g_old_rec.duration;
378: End If;
379: If (p_rec.duration_units = hr_api.g_varchar2) then
380: p_rec.duration_units :=
381: ota_evt_shd.g_old_rec.duration_units;
382: End If;
383: If (p_rec.enrolment_end_date = hr_api.g_date) then

Line 383: If (p_rec.enrolment_end_date = hr_api.g_date) then

379: If (p_rec.duration_units = hr_api.g_varchar2) then
380: p_rec.duration_units :=
381: ota_evt_shd.g_old_rec.duration_units;
382: End If;
383: If (p_rec.enrolment_end_date = hr_api.g_date) then
384: p_rec.enrolment_end_date :=
385: ota_evt_shd.g_old_rec.enrolment_end_date;
386: End If;
387: If (p_rec.enrolment_start_date = hr_api.g_date) then

Line 387: If (p_rec.enrolment_start_date = hr_api.g_date) then

383: If (p_rec.enrolment_end_date = hr_api.g_date) then
384: p_rec.enrolment_end_date :=
385: ota_evt_shd.g_old_rec.enrolment_end_date;
386: End If;
387: If (p_rec.enrolment_start_date = hr_api.g_date) then
388: p_rec.enrolment_start_date :=
389: ota_evt_shd.g_old_rec.enrolment_start_date;
390: End If;
391: If (p_rec.language_id = hr_api.g_number) then

Line 391: If (p_rec.language_id = hr_api.g_number) then

387: If (p_rec.enrolment_start_date = hr_api.g_date) then
388: p_rec.enrolment_start_date :=
389: ota_evt_shd.g_old_rec.enrolment_start_date;
390: End If;
391: If (p_rec.language_id = hr_api.g_number) then
392: p_rec.language_id :=
393: ota_evt_shd.g_old_rec.language_id;
394: End If;
395: If (p_rec.user_status = hr_api.g_varchar2) then

Line 395: If (p_rec.user_status = hr_api.g_varchar2) then

391: If (p_rec.language_id = hr_api.g_number) then
392: p_rec.language_id :=
393: ota_evt_shd.g_old_rec.language_id;
394: End If;
395: If (p_rec.user_status = hr_api.g_varchar2) then
396: p_rec.user_status :=
397: ota_evt_shd.g_old_rec.user_status;
398: End If;
399: If (p_rec.development_event_type = hr_api.g_varchar2) then

Line 399: If (p_rec.development_event_type = hr_api.g_varchar2) then

395: If (p_rec.user_status = hr_api.g_varchar2) then
396: p_rec.user_status :=
397: ota_evt_shd.g_old_rec.user_status;
398: End If;
399: If (p_rec.development_event_type = hr_api.g_varchar2) then
400: p_rec.development_event_type :=
401: ota_evt_shd.g_old_rec.development_event_type;
402: End If;
403: If (p_rec.event_status = hr_api.g_varchar2) then

Line 403: If (p_rec.event_status = hr_api.g_varchar2) then

399: If (p_rec.development_event_type = hr_api.g_varchar2) then
400: p_rec.development_event_type :=
401: ota_evt_shd.g_old_rec.development_event_type;
402: End If;
403: If (p_rec.event_status = hr_api.g_varchar2) then
404: p_rec.event_status :=
405: ota_evt_shd.g_old_rec.event_status;
406: End If;
407: If (p_rec.price_basis = hr_api.g_varchar2) then

Line 407: If (p_rec.price_basis = hr_api.g_varchar2) then

403: If (p_rec.event_status = hr_api.g_varchar2) then
404: p_rec.event_status :=
405: ota_evt_shd.g_old_rec.event_status;
406: End If;
407: If (p_rec.price_basis = hr_api.g_varchar2) then
408: p_rec.price_basis :=
409: ota_evt_shd.g_old_rec.price_basis;
410: End If;
411: If (p_rec.currency_code = hr_api.g_varchar2) then

Line 411: If (p_rec.currency_code = hr_api.g_varchar2) then

407: If (p_rec.price_basis = hr_api.g_varchar2) then
408: p_rec.price_basis :=
409: ota_evt_shd.g_old_rec.price_basis;
410: End If;
411: If (p_rec.currency_code = hr_api.g_varchar2) then
412: p_rec.currency_code :=
413: ota_evt_shd.g_old_rec.currency_code;
414: End If;
415: If (p_rec.maximum_attendees = hr_api.g_number) then

Line 415: If (p_rec.maximum_attendees = hr_api.g_number) then

411: If (p_rec.currency_code = hr_api.g_varchar2) then
412: p_rec.currency_code :=
413: ota_evt_shd.g_old_rec.currency_code;
414: End If;
415: If (p_rec.maximum_attendees = hr_api.g_number) then
416: p_rec.maximum_attendees :=
417: ota_evt_shd.g_old_rec.maximum_attendees;
418: End If;
419: If (p_rec.maximum_internal_attendees = hr_api.g_number) then

Line 419: If (p_rec.maximum_internal_attendees = hr_api.g_number) then

415: If (p_rec.maximum_attendees = hr_api.g_number) then
416: p_rec.maximum_attendees :=
417: ota_evt_shd.g_old_rec.maximum_attendees;
418: End If;
419: If (p_rec.maximum_internal_attendees = hr_api.g_number) then
420: p_rec.maximum_internal_attendees :=
421: ota_evt_shd.g_old_rec.maximum_internal_attendees;
422: End If;
423: If (p_rec.minimum_attendees = hr_api.g_number) then

Line 423: If (p_rec.minimum_attendees = hr_api.g_number) then

419: If (p_rec.maximum_internal_attendees = hr_api.g_number) then
420: p_rec.maximum_internal_attendees :=
421: ota_evt_shd.g_old_rec.maximum_internal_attendees;
422: End If;
423: If (p_rec.minimum_attendees = hr_api.g_number) then
424: p_rec.minimum_attendees :=
425: ota_evt_shd.g_old_rec.minimum_attendees;
426: End If;
427: If (p_rec.standard_price = hr_api.g_number) then

Line 427: If (p_rec.standard_price = hr_api.g_number) then

423: If (p_rec.minimum_attendees = hr_api.g_number) then
424: p_rec.minimum_attendees :=
425: ota_evt_shd.g_old_rec.minimum_attendees;
426: End If;
427: If (p_rec.standard_price = hr_api.g_number) then
428: p_rec.standard_price :=
429: ota_evt_shd.g_old_rec.standard_price;
430: End If;
431: If (p_rec.category_code = hr_api.g_varchar2) then

Line 431: If (p_rec.category_code = hr_api.g_varchar2) then

427: If (p_rec.standard_price = hr_api.g_number) then
428: p_rec.standard_price :=
429: ota_evt_shd.g_old_rec.standard_price;
430: End If;
431: If (p_rec.category_code = hr_api.g_varchar2) then
432: p_rec.category_code :=
433: ota_evt_shd.g_old_rec.category_code;
434: End If;
435: If (p_rec.parent_event_id = hr_api.g_number) then

Line 435: If (p_rec.parent_event_id = hr_api.g_number) then

431: If (p_rec.category_code = hr_api.g_varchar2) then
432: p_rec.category_code :=
433: ota_evt_shd.g_old_rec.category_code;
434: End If;
435: If (p_rec.parent_event_id = hr_api.g_number) then
436: p_rec.parent_event_id :=
437: ota_evt_shd.g_old_rec.parent_event_id;
438: End If;
439: If (p_rec.book_independent_flag = hr_api.g_varchar2) then

Line 439: If (p_rec.book_independent_flag = hr_api.g_varchar2) then

435: If (p_rec.parent_event_id = hr_api.g_number) then
436: p_rec.parent_event_id :=
437: ota_evt_shd.g_old_rec.parent_event_id;
438: End If;
439: If (p_rec.book_independent_flag = hr_api.g_varchar2) then
440: p_rec.book_independent_flag :=
441: ota_evt_shd.g_old_rec.book_independent_flag;
442: End If;
443: If (p_rec.public_event_flag = hr_api.g_varchar2) then

Line 443: If (p_rec.public_event_flag = hr_api.g_varchar2) then

439: If (p_rec.book_independent_flag = hr_api.g_varchar2) then
440: p_rec.book_independent_flag :=
441: ota_evt_shd.g_old_rec.book_independent_flag;
442: End If;
443: If (p_rec.public_event_flag = hr_api.g_varchar2) then
444: p_rec.public_event_flag :=
445: ota_evt_shd.g_old_rec.public_event_flag;
446: End If;
447: If (p_rec.secure_event_flag = hr_api.g_varchar2) then

Line 447: If (p_rec.secure_event_flag = hr_api.g_varchar2) then

443: If (p_rec.public_event_flag = hr_api.g_varchar2) then
444: p_rec.public_event_flag :=
445: ota_evt_shd.g_old_rec.public_event_flag;
446: End If;
447: If (p_rec.secure_event_flag = hr_api.g_varchar2) then
448: p_rec.secure_event_flag :=
449: ota_evt_shd.g_old_rec.secure_event_flag;
450: End If;
451: If (p_rec.evt_information_category = hr_api.g_varchar2) then

Line 451: If (p_rec.evt_information_category = hr_api.g_varchar2) then

447: If (p_rec.secure_event_flag = hr_api.g_varchar2) then
448: p_rec.secure_event_flag :=
449: ota_evt_shd.g_old_rec.secure_event_flag;
450: End If;
451: If (p_rec.evt_information_category = hr_api.g_varchar2) then
452: p_rec.evt_information_category :=
453: ota_evt_shd.g_old_rec.evt_information_category;
454: End If;
455: If (p_rec.evt_information1 = hr_api.g_varchar2) then

Line 455: If (p_rec.evt_information1 = hr_api.g_varchar2) then

451: If (p_rec.evt_information_category = hr_api.g_varchar2) then
452: p_rec.evt_information_category :=
453: ota_evt_shd.g_old_rec.evt_information_category;
454: End If;
455: If (p_rec.evt_information1 = hr_api.g_varchar2) then
456: p_rec.evt_information1 :=
457: ota_evt_shd.g_old_rec.evt_information1;
458: End If;
459: If (p_rec.evt_information2 = hr_api.g_varchar2) then

Line 459: If (p_rec.evt_information2 = hr_api.g_varchar2) then

455: If (p_rec.evt_information1 = hr_api.g_varchar2) then
456: p_rec.evt_information1 :=
457: ota_evt_shd.g_old_rec.evt_information1;
458: End If;
459: If (p_rec.evt_information2 = hr_api.g_varchar2) then
460: p_rec.evt_information2 :=
461: ota_evt_shd.g_old_rec.evt_information2;
462: End If;
463: If (p_rec.evt_information3 = hr_api.g_varchar2) then

Line 463: If (p_rec.evt_information3 = hr_api.g_varchar2) then

459: If (p_rec.evt_information2 = hr_api.g_varchar2) then
460: p_rec.evt_information2 :=
461: ota_evt_shd.g_old_rec.evt_information2;
462: End If;
463: If (p_rec.evt_information3 = hr_api.g_varchar2) then
464: p_rec.evt_information3 :=
465: ota_evt_shd.g_old_rec.evt_information3;
466: End If;
467: If (p_rec.evt_information4 = hr_api.g_varchar2) then

Line 467: If (p_rec.evt_information4 = hr_api.g_varchar2) then

463: If (p_rec.evt_information3 = hr_api.g_varchar2) then
464: p_rec.evt_information3 :=
465: ota_evt_shd.g_old_rec.evt_information3;
466: End If;
467: If (p_rec.evt_information4 = hr_api.g_varchar2) then
468: p_rec.evt_information4 :=
469: ota_evt_shd.g_old_rec.evt_information4;
470: End If;
471: If (p_rec.evt_information5 = hr_api.g_varchar2) then

Line 471: If (p_rec.evt_information5 = hr_api.g_varchar2) then

467: If (p_rec.evt_information4 = hr_api.g_varchar2) then
468: p_rec.evt_information4 :=
469: ota_evt_shd.g_old_rec.evt_information4;
470: End If;
471: If (p_rec.evt_information5 = hr_api.g_varchar2) then
472: p_rec.evt_information5 :=
473: ota_evt_shd.g_old_rec.evt_information5;
474: End If;
475: If (p_rec.evt_information6 = hr_api.g_varchar2) then

Line 475: If (p_rec.evt_information6 = hr_api.g_varchar2) then

471: If (p_rec.evt_information5 = hr_api.g_varchar2) then
472: p_rec.evt_information5 :=
473: ota_evt_shd.g_old_rec.evt_information5;
474: End If;
475: If (p_rec.evt_information6 = hr_api.g_varchar2) then
476: p_rec.evt_information6 :=
477: ota_evt_shd.g_old_rec.evt_information6;
478: End If;
479: If (p_rec.evt_information7 = hr_api.g_varchar2) then

Line 479: If (p_rec.evt_information7 = hr_api.g_varchar2) then

475: If (p_rec.evt_information6 = hr_api.g_varchar2) then
476: p_rec.evt_information6 :=
477: ota_evt_shd.g_old_rec.evt_information6;
478: End If;
479: If (p_rec.evt_information7 = hr_api.g_varchar2) then
480: p_rec.evt_information7 :=
481: ota_evt_shd.g_old_rec.evt_information7;
482: End If;
483: If (p_rec.evt_information8 = hr_api.g_varchar2) then

Line 483: If (p_rec.evt_information8 = hr_api.g_varchar2) then

479: If (p_rec.evt_information7 = hr_api.g_varchar2) then
480: p_rec.evt_information7 :=
481: ota_evt_shd.g_old_rec.evt_information7;
482: End If;
483: If (p_rec.evt_information8 = hr_api.g_varchar2) then
484: p_rec.evt_information8 :=
485: ota_evt_shd.g_old_rec.evt_information8;
486: End If;
487: If (p_rec.evt_information9 = hr_api.g_varchar2) then

Line 487: If (p_rec.evt_information9 = hr_api.g_varchar2) then

483: If (p_rec.evt_information8 = hr_api.g_varchar2) then
484: p_rec.evt_information8 :=
485: ota_evt_shd.g_old_rec.evt_information8;
486: End If;
487: If (p_rec.evt_information9 = hr_api.g_varchar2) then
488: p_rec.evt_information9 :=
489: ota_evt_shd.g_old_rec.evt_information9;
490: End If;
491: If (p_rec.evt_information10 = hr_api.g_varchar2) then

Line 491: If (p_rec.evt_information10 = hr_api.g_varchar2) then

487: If (p_rec.evt_information9 = hr_api.g_varchar2) then
488: p_rec.evt_information9 :=
489: ota_evt_shd.g_old_rec.evt_information9;
490: End If;
491: If (p_rec.evt_information10 = hr_api.g_varchar2) then
492: p_rec.evt_information10 :=
493: ota_evt_shd.g_old_rec.evt_information10;
494: End If;
495: If (p_rec.evt_information11 = hr_api.g_varchar2) then

Line 495: If (p_rec.evt_information11 = hr_api.g_varchar2) then

491: If (p_rec.evt_information10 = hr_api.g_varchar2) then
492: p_rec.evt_information10 :=
493: ota_evt_shd.g_old_rec.evt_information10;
494: End If;
495: If (p_rec.evt_information11 = hr_api.g_varchar2) then
496: p_rec.evt_information11 :=
497: ota_evt_shd.g_old_rec.evt_information11;
498: End If;
499: If (p_rec.evt_information12 = hr_api.g_varchar2) then

Line 499: If (p_rec.evt_information12 = hr_api.g_varchar2) then

495: If (p_rec.evt_information11 = hr_api.g_varchar2) then
496: p_rec.evt_information11 :=
497: ota_evt_shd.g_old_rec.evt_information11;
498: End If;
499: If (p_rec.evt_information12 = hr_api.g_varchar2) then
500: p_rec.evt_information12 :=
501: ota_evt_shd.g_old_rec.evt_information12;
502: End If;
503: If (p_rec.evt_information13 = hr_api.g_varchar2) then

Line 503: If (p_rec.evt_information13 = hr_api.g_varchar2) then

499: If (p_rec.evt_information12 = hr_api.g_varchar2) then
500: p_rec.evt_information12 :=
501: ota_evt_shd.g_old_rec.evt_information12;
502: End If;
503: If (p_rec.evt_information13 = hr_api.g_varchar2) then
504: p_rec.evt_information13 :=
505: ota_evt_shd.g_old_rec.evt_information13;
506: End If;
507: If (p_rec.evt_information14 = hr_api.g_varchar2) then

Line 507: If (p_rec.evt_information14 = hr_api.g_varchar2) then

503: If (p_rec.evt_information13 = hr_api.g_varchar2) then
504: p_rec.evt_information13 :=
505: ota_evt_shd.g_old_rec.evt_information13;
506: End If;
507: If (p_rec.evt_information14 = hr_api.g_varchar2) then
508: p_rec.evt_information14 :=
509: ota_evt_shd.g_old_rec.evt_information14;
510: End If;
511: If (p_rec.evt_information15 = hr_api.g_varchar2) then

Line 511: If (p_rec.evt_information15 = hr_api.g_varchar2) then

507: If (p_rec.evt_information14 = hr_api.g_varchar2) then
508: p_rec.evt_information14 :=
509: ota_evt_shd.g_old_rec.evt_information14;
510: End If;
511: If (p_rec.evt_information15 = hr_api.g_varchar2) then
512: p_rec.evt_information15 :=
513: ota_evt_shd.g_old_rec.evt_information15;
514: End If;
515: If (p_rec.evt_information16 = hr_api.g_varchar2) then

Line 515: If (p_rec.evt_information16 = hr_api.g_varchar2) then

511: If (p_rec.evt_information15 = hr_api.g_varchar2) then
512: p_rec.evt_information15 :=
513: ota_evt_shd.g_old_rec.evt_information15;
514: End If;
515: If (p_rec.evt_information16 = hr_api.g_varchar2) then
516: p_rec.evt_information16 :=
517: ota_evt_shd.g_old_rec.evt_information16;
518: End If;
519: If (p_rec.evt_information17 = hr_api.g_varchar2) then

Line 519: If (p_rec.evt_information17 = hr_api.g_varchar2) then

515: If (p_rec.evt_information16 = hr_api.g_varchar2) then
516: p_rec.evt_information16 :=
517: ota_evt_shd.g_old_rec.evt_information16;
518: End If;
519: If (p_rec.evt_information17 = hr_api.g_varchar2) then
520: p_rec.evt_information17 :=
521: ota_evt_shd.g_old_rec.evt_information17;
522: End If;
523: If (p_rec.evt_information18 = hr_api.g_varchar2) then

Line 523: If (p_rec.evt_information18 = hr_api.g_varchar2) then

519: If (p_rec.evt_information17 = hr_api.g_varchar2) then
520: p_rec.evt_information17 :=
521: ota_evt_shd.g_old_rec.evt_information17;
522: End If;
523: If (p_rec.evt_information18 = hr_api.g_varchar2) then
524: p_rec.evt_information18 :=
525: ota_evt_shd.g_old_rec.evt_information18;
526: End If;
527: If (p_rec.evt_information19 = hr_api.g_varchar2) then

Line 527: If (p_rec.evt_information19 = hr_api.g_varchar2) then

523: If (p_rec.evt_information18 = hr_api.g_varchar2) then
524: p_rec.evt_information18 :=
525: ota_evt_shd.g_old_rec.evt_information18;
526: End If;
527: If (p_rec.evt_information19 = hr_api.g_varchar2) then
528: p_rec.evt_information19 :=
529: ota_evt_shd.g_old_rec.evt_information19;
530: End If;
531: If (p_rec.evt_information20 = hr_api.g_varchar2) then

Line 531: If (p_rec.evt_information20 = hr_api.g_varchar2) then

527: If (p_rec.evt_information19 = hr_api.g_varchar2) then
528: p_rec.evt_information19 :=
529: ota_evt_shd.g_old_rec.evt_information19;
530: End If;
531: If (p_rec.evt_information20 = hr_api.g_varchar2) then
532: p_rec.evt_information20 :=
533: ota_evt_shd.g_old_rec.evt_information20;
534: End If;
535: If (p_rec.project_id = hr_api.g_number) then

Line 535: If (p_rec.project_id = hr_api.g_number) then

531: If (p_rec.evt_information20 = hr_api.g_varchar2) then
532: p_rec.evt_information20 :=
533: ota_evt_shd.g_old_rec.evt_information20;
534: End If;
535: If (p_rec.project_id = hr_api.g_number) then
536: p_rec.project_id :=
537: ota_evt_shd.g_old_rec.project_id;
538: End If;
539: If (p_rec.owner_id = hr_api.g_number) then

Line 539: If (p_rec.owner_id = hr_api.g_number) then

535: If (p_rec.project_id = hr_api.g_number) then
536: p_rec.project_id :=
537: ota_evt_shd.g_old_rec.project_id;
538: End If;
539: If (p_rec.owner_id = hr_api.g_number) then
540: p_rec.owner_id :=
541: ota_evt_shd.g_old_rec.owner_id;
542: End If;
543: If (p_rec.line_id = hr_api.g_number) then

Line 543: If (p_rec.line_id = hr_api.g_number) then

539: If (p_rec.owner_id = hr_api.g_number) then
540: p_rec.owner_id :=
541: ota_evt_shd.g_old_rec.owner_id;
542: End If;
543: If (p_rec.line_id = hr_api.g_number) then
544: p_rec.line_id :=
545: ota_evt_shd.g_old_rec.line_id;
546: End If;
547: If (p_rec.org_id = hr_api.g_number) then

Line 547: If (p_rec.org_id = hr_api.g_number) then

543: If (p_rec.line_id = hr_api.g_number) then
544: p_rec.line_id :=
545: ota_evt_shd.g_old_rec.line_id;
546: End If;
547: If (p_rec.org_id = hr_api.g_number) then
548: p_rec.org_id :=
549: ota_evt_shd.g_old_rec.org_id;
550: End If;
551: If (p_rec.training_center_id = hr_api.g_number) then

Line 551: If (p_rec.training_center_id = hr_api.g_number) then

547: If (p_rec.org_id = hr_api.g_number) then
548: p_rec.org_id :=
549: ota_evt_shd.g_old_rec.org_id;
550: End If;
551: If (p_rec.training_center_id = hr_api.g_number) then
552: p_rec.training_center_id :=
553: ota_evt_shd.g_old_rec.training_center_id;
554: End If;
555: If (p_rec.location_id = hr_api.g_number) then

Line 555: If (p_rec.location_id = hr_api.g_number) then

551: If (p_rec.training_center_id = hr_api.g_number) then
552: p_rec.training_center_id :=
553: ota_evt_shd.g_old_rec.training_center_id;
554: End If;
555: If (p_rec.location_id = hr_api.g_number) then
556: p_rec.location_id :=
557: ota_evt_shd.g_old_rec.location_id;
558: End If;
559:

Line 560: If (p_rec.offering_id = hr_api.g_number) then

556: p_rec.location_id :=
557: ota_evt_shd.g_old_rec.location_id;
558: End If;
559:
560: If (p_rec.offering_id = hr_api.g_number) then
561: p_rec.offering_id :=
562: ota_evt_shd.g_old_rec.offering_id;
563: End If;
564:

Line 565: If (p_rec.timezone = hr_api.g_varchar2) then

561: p_rec.offering_id :=
562: ota_evt_shd.g_old_rec.offering_id;
563: End If;
564:
565: If (p_rec.timezone = hr_api.g_varchar2) then
566: p_rec.timezone :=
567: ota_evt_shd.g_old_rec.timezone;
568: End If;
569:

Line 570: If (p_rec.parent_offering_id = hr_api.g_number) then

566: p_rec.timezone :=
567: ota_evt_shd.g_old_rec.timezone;
568: End If;
569:
570: If (p_rec.parent_offering_id = hr_api.g_number) then
571: p_rec.parent_offering_id :=
572: ota_evt_shd.g_old_rec.parent_offering_id;
573: End If;
574:

Line 575: If (p_rec.data_source = hr_api.g_varchar2) then

571: p_rec.parent_offering_id :=
572: ota_evt_shd.g_old_rec.parent_offering_id;
573: End If;
574:
575: If (p_rec.data_source = hr_api.g_varchar2) then
576: p_rec.data_source :=
577: ota_evt_shd.g_old_rec.data_source;
578: End If;
579:

Line 580: If (p_rec.event_availability = hr_api.g_varchar2) then

576: p_rec.data_source :=
577: ota_evt_shd.g_old_rec.data_source;
578: End If;
579:
580: If (p_rec.event_availability = hr_api.g_varchar2) then
581: p_rec.event_availability :=
582: ota_evt_shd.g_old_rec.event_availability;
583: End If;
584:

Line 667: Raise HR_Api.Validate_Enabled;

663: --
664: -- If we are validating then raise the Validate_Enabled exception
665: --
666: If p_validate then
667: Raise HR_Api.Validate_Enabled;
668: End If;
669: -- CODING FOR NTF PROCESS
670:
671: l_course_start_date_changed

Line 784: When HR_Api.Validate_Enabled Then

780:
781: --
782: hr_utility.set_location(' Leaving:'||l_proc, 10);
783: Exception
784: When HR_Api.Validate_Enabled Then
785: --
786: -- As the Validate_Enabled exception has been raised
787: -- we must rollback to the savepoint
788: --

Line 798: p_vendor_id in number default hr_api.g_number,

794: -- ----------------------------------------------------------------------------
795: Procedure upd
796: (
797: p_event_id in number,
798: p_vendor_id in number default hr_api.g_number,
799: p_activity_version_id in number default hr_api.g_number,
800: p_business_group_id in number default hr_api.g_number,
801: p_organization_id in number default hr_api.g_number,
802: p_event_type in varchar2 default hr_api.g_varchar2,

Line 799: p_activity_version_id in number default hr_api.g_number,

795: Procedure upd
796: (
797: p_event_id in number,
798: p_vendor_id in number default hr_api.g_number,
799: p_activity_version_id in number default hr_api.g_number,
800: p_business_group_id in number default hr_api.g_number,
801: p_organization_id in number default hr_api.g_number,
802: p_event_type in varchar2 default hr_api.g_varchar2,
803: p_object_version_number in out nocopy number,

Line 800: p_business_group_id in number default hr_api.g_number,

796: (
797: p_event_id in number,
798: p_vendor_id in number default hr_api.g_number,
799: p_activity_version_id in number default hr_api.g_number,
800: p_business_group_id in number default hr_api.g_number,
801: p_organization_id in number default hr_api.g_number,
802: p_event_type in varchar2 default hr_api.g_varchar2,
803: p_object_version_number in out nocopy number,
804: p_title in varchar2 default hr_api.g_varchar2,

Line 801: p_organization_id in number default hr_api.g_number,

797: p_event_id in number,
798: p_vendor_id in number default hr_api.g_number,
799: p_activity_version_id in number default hr_api.g_number,
800: p_business_group_id in number default hr_api.g_number,
801: p_organization_id in number default hr_api.g_number,
802: p_event_type in varchar2 default hr_api.g_varchar2,
803: p_object_version_number in out nocopy number,
804: p_title in varchar2 default hr_api.g_varchar2,
805: p_budget_cost in number default hr_api.g_number,

Line 802: p_event_type in varchar2 default hr_api.g_varchar2,

798: p_vendor_id in number default hr_api.g_number,
799: p_activity_version_id in number default hr_api.g_number,
800: p_business_group_id in number default hr_api.g_number,
801: p_organization_id in number default hr_api.g_number,
802: p_event_type in varchar2 default hr_api.g_varchar2,
803: p_object_version_number in out nocopy number,
804: p_title in varchar2 default hr_api.g_varchar2,
805: p_budget_cost in number default hr_api.g_number,
806: p_actual_cost in number default hr_api.g_number,

Line 804: p_title in varchar2 default hr_api.g_varchar2,

800: p_business_group_id in number default hr_api.g_number,
801: p_organization_id in number default hr_api.g_number,
802: p_event_type in varchar2 default hr_api.g_varchar2,
803: p_object_version_number in out nocopy number,
804: p_title in varchar2 default hr_api.g_varchar2,
805: p_budget_cost in number default hr_api.g_number,
806: p_actual_cost in number default hr_api.g_number,
807: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
808: p_centre in varchar2 default hr_api.g_varchar2,

Line 805: p_budget_cost in number default hr_api.g_number,

801: p_organization_id in number default hr_api.g_number,
802: p_event_type in varchar2 default hr_api.g_varchar2,
803: p_object_version_number in out nocopy number,
804: p_title in varchar2 default hr_api.g_varchar2,
805: p_budget_cost in number default hr_api.g_number,
806: p_actual_cost in number default hr_api.g_number,
807: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
808: p_centre in varchar2 default hr_api.g_varchar2,
809: p_comments in varchar2 default hr_api.g_varchar2,

Line 806: p_actual_cost in number default hr_api.g_number,

802: p_event_type in varchar2 default hr_api.g_varchar2,
803: p_object_version_number in out nocopy number,
804: p_title in varchar2 default hr_api.g_varchar2,
805: p_budget_cost in number default hr_api.g_number,
806: p_actual_cost in number default hr_api.g_number,
807: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
808: p_centre in varchar2 default hr_api.g_varchar2,
809: p_comments in varchar2 default hr_api.g_varchar2,
810: p_course_end_date in date default hr_api.g_date,

Line 807: p_budget_currency_code in varchar2 default hr_api.g_varchar2,

803: p_object_version_number in out nocopy number,
804: p_title in varchar2 default hr_api.g_varchar2,
805: p_budget_cost in number default hr_api.g_number,
806: p_actual_cost in number default hr_api.g_number,
807: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
808: p_centre in varchar2 default hr_api.g_varchar2,
809: p_comments in varchar2 default hr_api.g_varchar2,
810: p_course_end_date in date default hr_api.g_date,
811: p_course_end_time in varchar2 default hr_api.g_varchar2,

Line 808: p_centre in varchar2 default hr_api.g_varchar2,

804: p_title in varchar2 default hr_api.g_varchar2,
805: p_budget_cost in number default hr_api.g_number,
806: p_actual_cost in number default hr_api.g_number,
807: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
808: p_centre in varchar2 default hr_api.g_varchar2,
809: p_comments in varchar2 default hr_api.g_varchar2,
810: p_course_end_date in date default hr_api.g_date,
811: p_course_end_time in varchar2 default hr_api.g_varchar2,
812: p_course_start_date in date default hr_api.g_date,

Line 809: p_comments in varchar2 default hr_api.g_varchar2,

805: p_budget_cost in number default hr_api.g_number,
806: p_actual_cost in number default hr_api.g_number,
807: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
808: p_centre in varchar2 default hr_api.g_varchar2,
809: p_comments in varchar2 default hr_api.g_varchar2,
810: p_course_end_date in date default hr_api.g_date,
811: p_course_end_time in varchar2 default hr_api.g_varchar2,
812: p_course_start_date in date default hr_api.g_date,
813: p_course_start_time in varchar2 default hr_api.g_varchar2,

Line 810: p_course_end_date in date default hr_api.g_date,

806: p_actual_cost in number default hr_api.g_number,
807: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
808: p_centre in varchar2 default hr_api.g_varchar2,
809: p_comments in varchar2 default hr_api.g_varchar2,
810: p_course_end_date in date default hr_api.g_date,
811: p_course_end_time in varchar2 default hr_api.g_varchar2,
812: p_course_start_date in date default hr_api.g_date,
813: p_course_start_time in varchar2 default hr_api.g_varchar2,
814: p_duration in number default hr_api.g_number,

Line 811: p_course_end_time in varchar2 default hr_api.g_varchar2,

807: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
808: p_centre in varchar2 default hr_api.g_varchar2,
809: p_comments in varchar2 default hr_api.g_varchar2,
810: p_course_end_date in date default hr_api.g_date,
811: p_course_end_time in varchar2 default hr_api.g_varchar2,
812: p_course_start_date in date default hr_api.g_date,
813: p_course_start_time in varchar2 default hr_api.g_varchar2,
814: p_duration in number default hr_api.g_number,
815: p_duration_units in varchar2 default hr_api.g_varchar2,

Line 812: p_course_start_date in date default hr_api.g_date,

808: p_centre in varchar2 default hr_api.g_varchar2,
809: p_comments in varchar2 default hr_api.g_varchar2,
810: p_course_end_date in date default hr_api.g_date,
811: p_course_end_time in varchar2 default hr_api.g_varchar2,
812: p_course_start_date in date default hr_api.g_date,
813: p_course_start_time in varchar2 default hr_api.g_varchar2,
814: p_duration in number default hr_api.g_number,
815: p_duration_units in varchar2 default hr_api.g_varchar2,
816: p_enrolment_end_date in date default hr_api.g_date,

Line 813: p_course_start_time in varchar2 default hr_api.g_varchar2,

809: p_comments in varchar2 default hr_api.g_varchar2,
810: p_course_end_date in date default hr_api.g_date,
811: p_course_end_time in varchar2 default hr_api.g_varchar2,
812: p_course_start_date in date default hr_api.g_date,
813: p_course_start_time in varchar2 default hr_api.g_varchar2,
814: p_duration in number default hr_api.g_number,
815: p_duration_units in varchar2 default hr_api.g_varchar2,
816: p_enrolment_end_date in date default hr_api.g_date,
817: p_enrolment_start_date in date default hr_api.g_date,

Line 814: p_duration in number default hr_api.g_number,

810: p_course_end_date in date default hr_api.g_date,
811: p_course_end_time in varchar2 default hr_api.g_varchar2,
812: p_course_start_date in date default hr_api.g_date,
813: p_course_start_time in varchar2 default hr_api.g_varchar2,
814: p_duration in number default hr_api.g_number,
815: p_duration_units in varchar2 default hr_api.g_varchar2,
816: p_enrolment_end_date in date default hr_api.g_date,
817: p_enrolment_start_date in date default hr_api.g_date,
818: p_language_id in number default hr_api.g_number,

Line 815: p_duration_units in varchar2 default hr_api.g_varchar2,

811: p_course_end_time in varchar2 default hr_api.g_varchar2,
812: p_course_start_date in date default hr_api.g_date,
813: p_course_start_time in varchar2 default hr_api.g_varchar2,
814: p_duration in number default hr_api.g_number,
815: p_duration_units in varchar2 default hr_api.g_varchar2,
816: p_enrolment_end_date in date default hr_api.g_date,
817: p_enrolment_start_date in date default hr_api.g_date,
818: p_language_id in number default hr_api.g_number,
819: p_user_status in varchar2 default hr_api.g_varchar2,

Line 816: p_enrolment_end_date in date default hr_api.g_date,

812: p_course_start_date in date default hr_api.g_date,
813: p_course_start_time in varchar2 default hr_api.g_varchar2,
814: p_duration in number default hr_api.g_number,
815: p_duration_units in varchar2 default hr_api.g_varchar2,
816: p_enrolment_end_date in date default hr_api.g_date,
817: p_enrolment_start_date in date default hr_api.g_date,
818: p_language_id in number default hr_api.g_number,
819: p_user_status in varchar2 default hr_api.g_varchar2,
820: p_development_event_type in varchar2 default hr_api.g_varchar2,

Line 817: p_enrolment_start_date in date default hr_api.g_date,

813: p_course_start_time in varchar2 default hr_api.g_varchar2,
814: p_duration in number default hr_api.g_number,
815: p_duration_units in varchar2 default hr_api.g_varchar2,
816: p_enrolment_end_date in date default hr_api.g_date,
817: p_enrolment_start_date in date default hr_api.g_date,
818: p_language_id in number default hr_api.g_number,
819: p_user_status in varchar2 default hr_api.g_varchar2,
820: p_development_event_type in varchar2 default hr_api.g_varchar2,
821: p_event_status in varchar2 default hr_api.g_varchar2,

Line 818: p_language_id in number default hr_api.g_number,

814: p_duration in number default hr_api.g_number,
815: p_duration_units in varchar2 default hr_api.g_varchar2,
816: p_enrolment_end_date in date default hr_api.g_date,
817: p_enrolment_start_date in date default hr_api.g_date,
818: p_language_id in number default hr_api.g_number,
819: p_user_status in varchar2 default hr_api.g_varchar2,
820: p_development_event_type in varchar2 default hr_api.g_varchar2,
821: p_event_status in varchar2 default hr_api.g_varchar2,
822: p_price_basis in varchar2 default hr_api.g_varchar2,

Line 819: p_user_status in varchar2 default hr_api.g_varchar2,

815: p_duration_units in varchar2 default hr_api.g_varchar2,
816: p_enrolment_end_date in date default hr_api.g_date,
817: p_enrolment_start_date in date default hr_api.g_date,
818: p_language_id in number default hr_api.g_number,
819: p_user_status in varchar2 default hr_api.g_varchar2,
820: p_development_event_type in varchar2 default hr_api.g_varchar2,
821: p_event_status in varchar2 default hr_api.g_varchar2,
822: p_price_basis in varchar2 default hr_api.g_varchar2,
823: p_currency_code in varchar2 default hr_api.g_varchar2,

Line 820: p_development_event_type in varchar2 default hr_api.g_varchar2,

816: p_enrolment_end_date in date default hr_api.g_date,
817: p_enrolment_start_date in date default hr_api.g_date,
818: p_language_id in number default hr_api.g_number,
819: p_user_status in varchar2 default hr_api.g_varchar2,
820: p_development_event_type in varchar2 default hr_api.g_varchar2,
821: p_event_status in varchar2 default hr_api.g_varchar2,
822: p_price_basis in varchar2 default hr_api.g_varchar2,
823: p_currency_code in varchar2 default hr_api.g_varchar2,
824: p_maximum_attendees in number default hr_api.g_number,

Line 821: p_event_status in varchar2 default hr_api.g_varchar2,

817: p_enrolment_start_date in date default hr_api.g_date,
818: p_language_id in number default hr_api.g_number,
819: p_user_status in varchar2 default hr_api.g_varchar2,
820: p_development_event_type in varchar2 default hr_api.g_varchar2,
821: p_event_status in varchar2 default hr_api.g_varchar2,
822: p_price_basis in varchar2 default hr_api.g_varchar2,
823: p_currency_code in varchar2 default hr_api.g_varchar2,
824: p_maximum_attendees in number default hr_api.g_number,
825: p_maximum_internal_attendees in number default hr_api.g_number,

Line 822: p_price_basis in varchar2 default hr_api.g_varchar2,

818: p_language_id in number default hr_api.g_number,
819: p_user_status in varchar2 default hr_api.g_varchar2,
820: p_development_event_type in varchar2 default hr_api.g_varchar2,
821: p_event_status in varchar2 default hr_api.g_varchar2,
822: p_price_basis in varchar2 default hr_api.g_varchar2,
823: p_currency_code in varchar2 default hr_api.g_varchar2,
824: p_maximum_attendees in number default hr_api.g_number,
825: p_maximum_internal_attendees in number default hr_api.g_number,
826: p_minimum_attendees in number default hr_api.g_number,

Line 823: p_currency_code in varchar2 default hr_api.g_varchar2,

819: p_user_status in varchar2 default hr_api.g_varchar2,
820: p_development_event_type in varchar2 default hr_api.g_varchar2,
821: p_event_status in varchar2 default hr_api.g_varchar2,
822: p_price_basis in varchar2 default hr_api.g_varchar2,
823: p_currency_code in varchar2 default hr_api.g_varchar2,
824: p_maximum_attendees in number default hr_api.g_number,
825: p_maximum_internal_attendees in number default hr_api.g_number,
826: p_minimum_attendees in number default hr_api.g_number,
827: p_standard_price in number default hr_api.g_number,

Line 824: p_maximum_attendees in number default hr_api.g_number,

820: p_development_event_type in varchar2 default hr_api.g_varchar2,
821: p_event_status in varchar2 default hr_api.g_varchar2,
822: p_price_basis in varchar2 default hr_api.g_varchar2,
823: p_currency_code in varchar2 default hr_api.g_varchar2,
824: p_maximum_attendees in number default hr_api.g_number,
825: p_maximum_internal_attendees in number default hr_api.g_number,
826: p_minimum_attendees in number default hr_api.g_number,
827: p_standard_price in number default hr_api.g_number,
828: p_category_code in varchar2 default hr_api.g_varchar2,

Line 825: p_maximum_internal_attendees in number default hr_api.g_number,

821: p_event_status in varchar2 default hr_api.g_varchar2,
822: p_price_basis in varchar2 default hr_api.g_varchar2,
823: p_currency_code in varchar2 default hr_api.g_varchar2,
824: p_maximum_attendees in number default hr_api.g_number,
825: p_maximum_internal_attendees in number default hr_api.g_number,
826: p_minimum_attendees in number default hr_api.g_number,
827: p_standard_price in number default hr_api.g_number,
828: p_category_code in varchar2 default hr_api.g_varchar2,
829: p_parent_event_id in number default hr_api.g_number,

Line 826: p_minimum_attendees in number default hr_api.g_number,

822: p_price_basis in varchar2 default hr_api.g_varchar2,
823: p_currency_code in varchar2 default hr_api.g_varchar2,
824: p_maximum_attendees in number default hr_api.g_number,
825: p_maximum_internal_attendees in number default hr_api.g_number,
826: p_minimum_attendees in number default hr_api.g_number,
827: p_standard_price in number default hr_api.g_number,
828: p_category_code in varchar2 default hr_api.g_varchar2,
829: p_parent_event_id in number default hr_api.g_number,
830: p_book_independent_flag in varchar2 default hr_api.g_varchar2,

Line 827: p_standard_price in number default hr_api.g_number,

823: p_currency_code in varchar2 default hr_api.g_varchar2,
824: p_maximum_attendees in number default hr_api.g_number,
825: p_maximum_internal_attendees in number default hr_api.g_number,
826: p_minimum_attendees in number default hr_api.g_number,
827: p_standard_price in number default hr_api.g_number,
828: p_category_code in varchar2 default hr_api.g_varchar2,
829: p_parent_event_id in number default hr_api.g_number,
830: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
831: p_public_event_flag in varchar2 default hr_api.g_varchar2,

Line 828: p_category_code in varchar2 default hr_api.g_varchar2,

824: p_maximum_attendees in number default hr_api.g_number,
825: p_maximum_internal_attendees in number default hr_api.g_number,
826: p_minimum_attendees in number default hr_api.g_number,
827: p_standard_price in number default hr_api.g_number,
828: p_category_code in varchar2 default hr_api.g_varchar2,
829: p_parent_event_id in number default hr_api.g_number,
830: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
831: p_public_event_flag in varchar2 default hr_api.g_varchar2,
832: p_secure_event_flag in varchar2 default hr_api.g_varchar2,

Line 829: p_parent_event_id in number default hr_api.g_number,

825: p_maximum_internal_attendees in number default hr_api.g_number,
826: p_minimum_attendees in number default hr_api.g_number,
827: p_standard_price in number default hr_api.g_number,
828: p_category_code in varchar2 default hr_api.g_varchar2,
829: p_parent_event_id in number default hr_api.g_number,
830: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
831: p_public_event_flag in varchar2 default hr_api.g_varchar2,
832: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
833: p_evt_information_category in varchar2 default hr_api.g_varchar2,

Line 830: p_book_independent_flag in varchar2 default hr_api.g_varchar2,

826: p_minimum_attendees in number default hr_api.g_number,
827: p_standard_price in number default hr_api.g_number,
828: p_category_code in varchar2 default hr_api.g_varchar2,
829: p_parent_event_id in number default hr_api.g_number,
830: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
831: p_public_event_flag in varchar2 default hr_api.g_varchar2,
832: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
833: p_evt_information_category in varchar2 default hr_api.g_varchar2,
834: p_evt_information1 in varchar2 default hr_api.g_varchar2,

Line 831: p_public_event_flag in varchar2 default hr_api.g_varchar2,

827: p_standard_price in number default hr_api.g_number,
828: p_category_code in varchar2 default hr_api.g_varchar2,
829: p_parent_event_id in number default hr_api.g_number,
830: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
831: p_public_event_flag in varchar2 default hr_api.g_varchar2,
832: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
833: p_evt_information_category in varchar2 default hr_api.g_varchar2,
834: p_evt_information1 in varchar2 default hr_api.g_varchar2,
835: p_evt_information2 in varchar2 default hr_api.g_varchar2,

Line 832: p_secure_event_flag in varchar2 default hr_api.g_varchar2,

828: p_category_code in varchar2 default hr_api.g_varchar2,
829: p_parent_event_id in number default hr_api.g_number,
830: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
831: p_public_event_flag in varchar2 default hr_api.g_varchar2,
832: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
833: p_evt_information_category in varchar2 default hr_api.g_varchar2,
834: p_evt_information1 in varchar2 default hr_api.g_varchar2,
835: p_evt_information2 in varchar2 default hr_api.g_varchar2,
836: p_evt_information3 in varchar2 default hr_api.g_varchar2,

Line 833: p_evt_information_category in varchar2 default hr_api.g_varchar2,

829: p_parent_event_id in number default hr_api.g_number,
830: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
831: p_public_event_flag in varchar2 default hr_api.g_varchar2,
832: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
833: p_evt_information_category in varchar2 default hr_api.g_varchar2,
834: p_evt_information1 in varchar2 default hr_api.g_varchar2,
835: p_evt_information2 in varchar2 default hr_api.g_varchar2,
836: p_evt_information3 in varchar2 default hr_api.g_varchar2,
837: p_evt_information4 in varchar2 default hr_api.g_varchar2,

Line 834: p_evt_information1 in varchar2 default hr_api.g_varchar2,

830: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
831: p_public_event_flag in varchar2 default hr_api.g_varchar2,
832: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
833: p_evt_information_category in varchar2 default hr_api.g_varchar2,
834: p_evt_information1 in varchar2 default hr_api.g_varchar2,
835: p_evt_information2 in varchar2 default hr_api.g_varchar2,
836: p_evt_information3 in varchar2 default hr_api.g_varchar2,
837: p_evt_information4 in varchar2 default hr_api.g_varchar2,
838: p_evt_information5 in varchar2 default hr_api.g_varchar2,

Line 835: p_evt_information2 in varchar2 default hr_api.g_varchar2,

831: p_public_event_flag in varchar2 default hr_api.g_varchar2,
832: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
833: p_evt_information_category in varchar2 default hr_api.g_varchar2,
834: p_evt_information1 in varchar2 default hr_api.g_varchar2,
835: p_evt_information2 in varchar2 default hr_api.g_varchar2,
836: p_evt_information3 in varchar2 default hr_api.g_varchar2,
837: p_evt_information4 in varchar2 default hr_api.g_varchar2,
838: p_evt_information5 in varchar2 default hr_api.g_varchar2,
839: p_evt_information6 in varchar2 default hr_api.g_varchar2,

Line 836: p_evt_information3 in varchar2 default hr_api.g_varchar2,

832: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
833: p_evt_information_category in varchar2 default hr_api.g_varchar2,
834: p_evt_information1 in varchar2 default hr_api.g_varchar2,
835: p_evt_information2 in varchar2 default hr_api.g_varchar2,
836: p_evt_information3 in varchar2 default hr_api.g_varchar2,
837: p_evt_information4 in varchar2 default hr_api.g_varchar2,
838: p_evt_information5 in varchar2 default hr_api.g_varchar2,
839: p_evt_information6 in varchar2 default hr_api.g_varchar2,
840: p_evt_information7 in varchar2 default hr_api.g_varchar2,

Line 837: p_evt_information4 in varchar2 default hr_api.g_varchar2,

833: p_evt_information_category in varchar2 default hr_api.g_varchar2,
834: p_evt_information1 in varchar2 default hr_api.g_varchar2,
835: p_evt_information2 in varchar2 default hr_api.g_varchar2,
836: p_evt_information3 in varchar2 default hr_api.g_varchar2,
837: p_evt_information4 in varchar2 default hr_api.g_varchar2,
838: p_evt_information5 in varchar2 default hr_api.g_varchar2,
839: p_evt_information6 in varchar2 default hr_api.g_varchar2,
840: p_evt_information7 in varchar2 default hr_api.g_varchar2,
841: p_evt_information8 in varchar2 default hr_api.g_varchar2,

Line 838: p_evt_information5 in varchar2 default hr_api.g_varchar2,

834: p_evt_information1 in varchar2 default hr_api.g_varchar2,
835: p_evt_information2 in varchar2 default hr_api.g_varchar2,
836: p_evt_information3 in varchar2 default hr_api.g_varchar2,
837: p_evt_information4 in varchar2 default hr_api.g_varchar2,
838: p_evt_information5 in varchar2 default hr_api.g_varchar2,
839: p_evt_information6 in varchar2 default hr_api.g_varchar2,
840: p_evt_information7 in varchar2 default hr_api.g_varchar2,
841: p_evt_information8 in varchar2 default hr_api.g_varchar2,
842: p_evt_information9 in varchar2 default hr_api.g_varchar2,

Line 839: p_evt_information6 in varchar2 default hr_api.g_varchar2,

835: p_evt_information2 in varchar2 default hr_api.g_varchar2,
836: p_evt_information3 in varchar2 default hr_api.g_varchar2,
837: p_evt_information4 in varchar2 default hr_api.g_varchar2,
838: p_evt_information5 in varchar2 default hr_api.g_varchar2,
839: p_evt_information6 in varchar2 default hr_api.g_varchar2,
840: p_evt_information7 in varchar2 default hr_api.g_varchar2,
841: p_evt_information8 in varchar2 default hr_api.g_varchar2,
842: p_evt_information9 in varchar2 default hr_api.g_varchar2,
843: p_evt_information10 in varchar2 default hr_api.g_varchar2,

Line 840: p_evt_information7 in varchar2 default hr_api.g_varchar2,

836: p_evt_information3 in varchar2 default hr_api.g_varchar2,
837: p_evt_information4 in varchar2 default hr_api.g_varchar2,
838: p_evt_information5 in varchar2 default hr_api.g_varchar2,
839: p_evt_information6 in varchar2 default hr_api.g_varchar2,
840: p_evt_information7 in varchar2 default hr_api.g_varchar2,
841: p_evt_information8 in varchar2 default hr_api.g_varchar2,
842: p_evt_information9 in varchar2 default hr_api.g_varchar2,
843: p_evt_information10 in varchar2 default hr_api.g_varchar2,
844: p_evt_information11 in varchar2 default hr_api.g_varchar2,

Line 841: p_evt_information8 in varchar2 default hr_api.g_varchar2,

837: p_evt_information4 in varchar2 default hr_api.g_varchar2,
838: p_evt_information5 in varchar2 default hr_api.g_varchar2,
839: p_evt_information6 in varchar2 default hr_api.g_varchar2,
840: p_evt_information7 in varchar2 default hr_api.g_varchar2,
841: p_evt_information8 in varchar2 default hr_api.g_varchar2,
842: p_evt_information9 in varchar2 default hr_api.g_varchar2,
843: p_evt_information10 in varchar2 default hr_api.g_varchar2,
844: p_evt_information11 in varchar2 default hr_api.g_varchar2,
845: p_evt_information12 in varchar2 default hr_api.g_varchar2,

Line 842: p_evt_information9 in varchar2 default hr_api.g_varchar2,

838: p_evt_information5 in varchar2 default hr_api.g_varchar2,
839: p_evt_information6 in varchar2 default hr_api.g_varchar2,
840: p_evt_information7 in varchar2 default hr_api.g_varchar2,
841: p_evt_information8 in varchar2 default hr_api.g_varchar2,
842: p_evt_information9 in varchar2 default hr_api.g_varchar2,
843: p_evt_information10 in varchar2 default hr_api.g_varchar2,
844: p_evt_information11 in varchar2 default hr_api.g_varchar2,
845: p_evt_information12 in varchar2 default hr_api.g_varchar2,
846: p_evt_information13 in varchar2 default hr_api.g_varchar2,

Line 843: p_evt_information10 in varchar2 default hr_api.g_varchar2,

839: p_evt_information6 in varchar2 default hr_api.g_varchar2,
840: p_evt_information7 in varchar2 default hr_api.g_varchar2,
841: p_evt_information8 in varchar2 default hr_api.g_varchar2,
842: p_evt_information9 in varchar2 default hr_api.g_varchar2,
843: p_evt_information10 in varchar2 default hr_api.g_varchar2,
844: p_evt_information11 in varchar2 default hr_api.g_varchar2,
845: p_evt_information12 in varchar2 default hr_api.g_varchar2,
846: p_evt_information13 in varchar2 default hr_api.g_varchar2,
847: p_evt_information14 in varchar2 default hr_api.g_varchar2,

Line 844: p_evt_information11 in varchar2 default hr_api.g_varchar2,

840: p_evt_information7 in varchar2 default hr_api.g_varchar2,
841: p_evt_information8 in varchar2 default hr_api.g_varchar2,
842: p_evt_information9 in varchar2 default hr_api.g_varchar2,
843: p_evt_information10 in varchar2 default hr_api.g_varchar2,
844: p_evt_information11 in varchar2 default hr_api.g_varchar2,
845: p_evt_information12 in varchar2 default hr_api.g_varchar2,
846: p_evt_information13 in varchar2 default hr_api.g_varchar2,
847: p_evt_information14 in varchar2 default hr_api.g_varchar2,
848: p_evt_information15 in varchar2 default hr_api.g_varchar2,

Line 845: p_evt_information12 in varchar2 default hr_api.g_varchar2,

841: p_evt_information8 in varchar2 default hr_api.g_varchar2,
842: p_evt_information9 in varchar2 default hr_api.g_varchar2,
843: p_evt_information10 in varchar2 default hr_api.g_varchar2,
844: p_evt_information11 in varchar2 default hr_api.g_varchar2,
845: p_evt_information12 in varchar2 default hr_api.g_varchar2,
846: p_evt_information13 in varchar2 default hr_api.g_varchar2,
847: p_evt_information14 in varchar2 default hr_api.g_varchar2,
848: p_evt_information15 in varchar2 default hr_api.g_varchar2,
849: p_evt_information16 in varchar2 default hr_api.g_varchar2,

Line 846: p_evt_information13 in varchar2 default hr_api.g_varchar2,

842: p_evt_information9 in varchar2 default hr_api.g_varchar2,
843: p_evt_information10 in varchar2 default hr_api.g_varchar2,
844: p_evt_information11 in varchar2 default hr_api.g_varchar2,
845: p_evt_information12 in varchar2 default hr_api.g_varchar2,
846: p_evt_information13 in varchar2 default hr_api.g_varchar2,
847: p_evt_information14 in varchar2 default hr_api.g_varchar2,
848: p_evt_information15 in varchar2 default hr_api.g_varchar2,
849: p_evt_information16 in varchar2 default hr_api.g_varchar2,
850: p_evt_information17 in varchar2 default hr_api.g_varchar2,

Line 847: p_evt_information14 in varchar2 default hr_api.g_varchar2,

843: p_evt_information10 in varchar2 default hr_api.g_varchar2,
844: p_evt_information11 in varchar2 default hr_api.g_varchar2,
845: p_evt_information12 in varchar2 default hr_api.g_varchar2,
846: p_evt_information13 in varchar2 default hr_api.g_varchar2,
847: p_evt_information14 in varchar2 default hr_api.g_varchar2,
848: p_evt_information15 in varchar2 default hr_api.g_varchar2,
849: p_evt_information16 in varchar2 default hr_api.g_varchar2,
850: p_evt_information17 in varchar2 default hr_api.g_varchar2,
851: p_evt_information18 in varchar2 default hr_api.g_varchar2,

Line 848: p_evt_information15 in varchar2 default hr_api.g_varchar2,

844: p_evt_information11 in varchar2 default hr_api.g_varchar2,
845: p_evt_information12 in varchar2 default hr_api.g_varchar2,
846: p_evt_information13 in varchar2 default hr_api.g_varchar2,
847: p_evt_information14 in varchar2 default hr_api.g_varchar2,
848: p_evt_information15 in varchar2 default hr_api.g_varchar2,
849: p_evt_information16 in varchar2 default hr_api.g_varchar2,
850: p_evt_information17 in varchar2 default hr_api.g_varchar2,
851: p_evt_information18 in varchar2 default hr_api.g_varchar2,
852: p_evt_information19 in varchar2 default hr_api.g_varchar2,

Line 849: p_evt_information16 in varchar2 default hr_api.g_varchar2,

845: p_evt_information12 in varchar2 default hr_api.g_varchar2,
846: p_evt_information13 in varchar2 default hr_api.g_varchar2,
847: p_evt_information14 in varchar2 default hr_api.g_varchar2,
848: p_evt_information15 in varchar2 default hr_api.g_varchar2,
849: p_evt_information16 in varchar2 default hr_api.g_varchar2,
850: p_evt_information17 in varchar2 default hr_api.g_varchar2,
851: p_evt_information18 in varchar2 default hr_api.g_varchar2,
852: p_evt_information19 in varchar2 default hr_api.g_varchar2,
853: p_evt_information20 in varchar2 default hr_api.g_varchar2,

Line 850: p_evt_information17 in varchar2 default hr_api.g_varchar2,

846: p_evt_information13 in varchar2 default hr_api.g_varchar2,
847: p_evt_information14 in varchar2 default hr_api.g_varchar2,
848: p_evt_information15 in varchar2 default hr_api.g_varchar2,
849: p_evt_information16 in varchar2 default hr_api.g_varchar2,
850: p_evt_information17 in varchar2 default hr_api.g_varchar2,
851: p_evt_information18 in varchar2 default hr_api.g_varchar2,
852: p_evt_information19 in varchar2 default hr_api.g_varchar2,
853: p_evt_information20 in varchar2 default hr_api.g_varchar2,
854: p_project_id in number default hr_api.g_number,

Line 851: p_evt_information18 in varchar2 default hr_api.g_varchar2,

847: p_evt_information14 in varchar2 default hr_api.g_varchar2,
848: p_evt_information15 in varchar2 default hr_api.g_varchar2,
849: p_evt_information16 in varchar2 default hr_api.g_varchar2,
850: p_evt_information17 in varchar2 default hr_api.g_varchar2,
851: p_evt_information18 in varchar2 default hr_api.g_varchar2,
852: p_evt_information19 in varchar2 default hr_api.g_varchar2,
853: p_evt_information20 in varchar2 default hr_api.g_varchar2,
854: p_project_id in number default hr_api.g_number,
855: p_owner_id in number default hr_api.g_number,

Line 852: p_evt_information19 in varchar2 default hr_api.g_varchar2,

848: p_evt_information15 in varchar2 default hr_api.g_varchar2,
849: p_evt_information16 in varchar2 default hr_api.g_varchar2,
850: p_evt_information17 in varchar2 default hr_api.g_varchar2,
851: p_evt_information18 in varchar2 default hr_api.g_varchar2,
852: p_evt_information19 in varchar2 default hr_api.g_varchar2,
853: p_evt_information20 in varchar2 default hr_api.g_varchar2,
854: p_project_id in number default hr_api.g_number,
855: p_owner_id in number default hr_api.g_number,
856: p_line_id in number default hr_api.g_number,

Line 853: p_evt_information20 in varchar2 default hr_api.g_varchar2,

849: p_evt_information16 in varchar2 default hr_api.g_varchar2,
850: p_evt_information17 in varchar2 default hr_api.g_varchar2,
851: p_evt_information18 in varchar2 default hr_api.g_varchar2,
852: p_evt_information19 in varchar2 default hr_api.g_varchar2,
853: p_evt_information20 in varchar2 default hr_api.g_varchar2,
854: p_project_id in number default hr_api.g_number,
855: p_owner_id in number default hr_api.g_number,
856: p_line_id in number default hr_api.g_number,
857: p_org_id in number default hr_api.g_number,

Line 854: p_project_id in number default hr_api.g_number,

850: p_evt_information17 in varchar2 default hr_api.g_varchar2,
851: p_evt_information18 in varchar2 default hr_api.g_varchar2,
852: p_evt_information19 in varchar2 default hr_api.g_varchar2,
853: p_evt_information20 in varchar2 default hr_api.g_varchar2,
854: p_project_id in number default hr_api.g_number,
855: p_owner_id in number default hr_api.g_number,
856: p_line_id in number default hr_api.g_number,
857: p_org_id in number default hr_api.g_number,
858: p_training_center_id in number default hr_api.g_number,

Line 855: p_owner_id in number default hr_api.g_number,

851: p_evt_information18 in varchar2 default hr_api.g_varchar2,
852: p_evt_information19 in varchar2 default hr_api.g_varchar2,
853: p_evt_information20 in varchar2 default hr_api.g_varchar2,
854: p_project_id in number default hr_api.g_number,
855: p_owner_id in number default hr_api.g_number,
856: p_line_id in number default hr_api.g_number,
857: p_org_id in number default hr_api.g_number,
858: p_training_center_id in number default hr_api.g_number,
859: p_location_id in number default hr_api.g_number,

Line 856: p_line_id in number default hr_api.g_number,

852: p_evt_information19 in varchar2 default hr_api.g_varchar2,
853: p_evt_information20 in varchar2 default hr_api.g_varchar2,
854: p_project_id in number default hr_api.g_number,
855: p_owner_id in number default hr_api.g_number,
856: p_line_id in number default hr_api.g_number,
857: p_org_id in number default hr_api.g_number,
858: p_training_center_id in number default hr_api.g_number,
859: p_location_id in number default hr_api.g_number,
860: p_offering_id in number default hr_api.g_number,

Line 857: p_org_id in number default hr_api.g_number,

853: p_evt_information20 in varchar2 default hr_api.g_varchar2,
854: p_project_id in number default hr_api.g_number,
855: p_owner_id in number default hr_api.g_number,
856: p_line_id in number default hr_api.g_number,
857: p_org_id in number default hr_api.g_number,
858: p_training_center_id in number default hr_api.g_number,
859: p_location_id in number default hr_api.g_number,
860: p_offering_id in number default hr_api.g_number,
861: p_timezone in varchar2 default hr_api.g_varchar2,

Line 858: p_training_center_id in number default hr_api.g_number,

854: p_project_id in number default hr_api.g_number,
855: p_owner_id in number default hr_api.g_number,
856: p_line_id in number default hr_api.g_number,
857: p_org_id in number default hr_api.g_number,
858: p_training_center_id in number default hr_api.g_number,
859: p_location_id in number default hr_api.g_number,
860: p_offering_id in number default hr_api.g_number,
861: p_timezone in varchar2 default hr_api.g_varchar2,
862: p_parent_offering_id in number default hr_api.g_number,

Line 859: p_location_id in number default hr_api.g_number,

855: p_owner_id in number default hr_api.g_number,
856: p_line_id in number default hr_api.g_number,
857: p_org_id in number default hr_api.g_number,
858: p_training_center_id in number default hr_api.g_number,
859: p_location_id in number default hr_api.g_number,
860: p_offering_id in number default hr_api.g_number,
861: p_timezone in varchar2 default hr_api.g_varchar2,
862: p_parent_offering_id in number default hr_api.g_number,
863: p_data_source in varchar2 default hr_api.g_varchar2,

Line 860: p_offering_id in number default hr_api.g_number,

856: p_line_id in number default hr_api.g_number,
857: p_org_id in number default hr_api.g_number,
858: p_training_center_id in number default hr_api.g_number,
859: p_location_id in number default hr_api.g_number,
860: p_offering_id in number default hr_api.g_number,
861: p_timezone in varchar2 default hr_api.g_varchar2,
862: p_parent_offering_id in number default hr_api.g_number,
863: p_data_source in varchar2 default hr_api.g_varchar2,
864: -- Bug#2200078 Corrected default value for offering_id and timezone

Line 861: p_timezone in varchar2 default hr_api.g_varchar2,

857: p_org_id in number default hr_api.g_number,
858: p_training_center_id in number default hr_api.g_number,
859: p_location_id in number default hr_api.g_number,
860: p_offering_id in number default hr_api.g_number,
861: p_timezone in varchar2 default hr_api.g_varchar2,
862: p_parent_offering_id in number default hr_api.g_number,
863: p_data_source in varchar2 default hr_api.g_varchar2,
864: -- Bug#2200078 Corrected default value for offering_id and timezone
865: -- p_offering_id in number default null,

Line 862: p_parent_offering_id in number default hr_api.g_number,

858: p_training_center_id in number default hr_api.g_number,
859: p_location_id in number default hr_api.g_number,
860: p_offering_id in number default hr_api.g_number,
861: p_timezone in varchar2 default hr_api.g_varchar2,
862: p_parent_offering_id in number default hr_api.g_number,
863: p_data_source in varchar2 default hr_api.g_varchar2,
864: -- Bug#2200078 Corrected default value for offering_id and timezone
865: -- p_offering_id in number default null,
866: -- p_timezone in varchar2 default null,

Line 863: p_data_source in varchar2 default hr_api.g_varchar2,

859: p_location_id in number default hr_api.g_number,
860: p_offering_id in number default hr_api.g_number,
861: p_timezone in varchar2 default hr_api.g_varchar2,
862: p_parent_offering_id in number default hr_api.g_number,
863: p_data_source in varchar2 default hr_api.g_varchar2,
864: -- Bug#2200078 Corrected default value for offering_id and timezone
865: -- p_offering_id in number default null,
866: -- p_timezone in varchar2 default null,
867: p_validate in boolean default false,

Line 868: p_event_availability in varchar2 default hr_api.g_varchar2

864: -- Bug#2200078 Corrected default value for offering_id and timezone
865: -- p_offering_id in number default null,
866: -- p_timezone in varchar2 default null,
867: p_validate in boolean default false,
868: p_event_availability in varchar2 default hr_api.g_varchar2
869: ) is
870: --
871: l_rec ota_evt_shd.g_rec_type;
872: l_proc varchar2(72) := g_package||'upd';