DBA Data[Home] [Help]

APPS.OTA_EVT_UPD dependencies on HR_API

Line 145: When hr_api.check_integrity_violated Then

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));

Line 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

Line 150: When hr_api.parent_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
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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

Line 155: When hr_api.unique_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
159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

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

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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:

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

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:

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

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:

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

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:

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

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:

Line 660: Raise HR_Api.Validate_Enabled;

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

Line 766: When HR_Api.Validate_Enabled Then

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: --

Line 780: p_vendor_id in number default hr_api.g_number,

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,

Line 781: p_activity_version_id in number default hr_api.g_number,

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,

Line 782: p_business_group_id in number default hr_api.g_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,

Line 783: p_organization_id in number default hr_api.g_number,

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,

Line 784: p_event_type in varchar2 default hr_api.g_varchar2,

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,

Line 786: p_title in varchar2 default hr_api.g_varchar2,

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,

Line 787: p_budget_cost 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,
791: p_comments in varchar2 default hr_api.g_varchar2,

Line 788: p_actual_cost 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,
792: p_course_end_date in date default hr_api.g_date,

Line 789: p_budget_currency_code 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,
793: p_course_end_time in varchar2 default hr_api.g_varchar2,

Line 790: p_centre 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,

Line 791: p_comments 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,
795: p_course_start_time in varchar2 default hr_api.g_varchar2,

Line 792: p_course_end_date in date default hr_api.g_date,

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,

Line 793: p_course_end_time in varchar2 default hr_api.g_varchar2,

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,

Line 794: p_course_start_date in date default hr_api.g_date,

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,

Line 795: p_course_start_time 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,
799: p_enrolment_start_date in date default hr_api.g_date,

Line 796: p_duration in number default hr_api.g_number,

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,

Line 797: p_duration_units in varchar2 default hr_api.g_varchar2,

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,

Line 798: p_enrolment_end_date in date default hr_api.g_date,

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,

Line 799: p_enrolment_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,
803: p_event_status in varchar2 default hr_api.g_varchar2,

Line 800: p_language_id in number default hr_api.g_number,

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,

Line 801: p_user_status 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,

Line 802: p_development_event_type 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,

Line 803: p_event_status in varchar2 default hr_api.g_varchar2,

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,

Line 804: p_price_basis in varchar2 default hr_api.g_varchar2,

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,

Line 805: p_currency_code in varchar2 default hr_api.g_varchar2,

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,

Line 806: p_maximum_attendees 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,

Line 807: p_maximum_internal_attendees in number default hr_api.g_number,

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,

Line 808: p_minimum_attendees 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,

Line 809: p_standard_price in number default hr_api.g_number,

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,

Line 810: p_category_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,
814: p_secure_event_flag in varchar2 default hr_api.g_varchar2,

Line 811: p_parent_event_id 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,
815: p_evt_information_category in varchar2 default hr_api.g_varchar2,

Line 812: p_book_independent_flag 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,

Line 813: p_public_event_flag 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,

Line 814: p_secure_event_flag 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,

Line 815: p_evt_information_category 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,

Line 816: p_evt_information1 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,

Line 817: p_evt_information2 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,

Line 818: p_evt_information3 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,

Line 819: p_evt_information4 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,

Line 820: p_evt_information5 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,

Line 821: p_evt_information6 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,

Line 822: p_evt_information7 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,

Line 823: p_evt_information8 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,

Line 824: p_evt_information9 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,

Line 825: p_evt_information10 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,

Line 826: p_evt_information11 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,

Line 827: p_evt_information12 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,

Line 828: p_evt_information13 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,

Line 829: p_evt_information14 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,

Line 830: p_evt_information15 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,

Line 831: p_evt_information16 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,

Line 832: p_evt_information17 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,

Line 833: p_evt_information18 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,
837: p_owner_id in number default hr_api.g_number,

Line 834: p_evt_information19 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,
838: p_line_id in number default hr_api.g_number,

Line 835: p_evt_information20 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,
839: p_org_id in number default hr_api.g_number,

Line 836: p_project_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,

Line 837: p_owner_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,

Line 838: p_line_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,

Line 839: p_org_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,

Line 840: p_training_center_id in number default hr_api.g_number,

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,

Line 841: p_location_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,

Line 842: p_offering_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,
846: -- Bug#2200078 Corrected default value for offering_id and timezone

Line 843: p_timezone in varchar2 default hr_api.g_varchar2,

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,

Line 844: p_parent_offering_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,
848: -- p_timezone in varchar2 default null,

Line 845: p_data_source in varchar2 default hr_api.g_varchar2,

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