APPS.OTA_LPM_UPD dependencies on HR_API

Line 111: When hr_api.check_integrity_violated Then

107: --
108: hr_utility.set_location(' Leaving:'||l_proc, 10);
109: --
110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: --
114: ota_lpm_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: --
114: ota_lpm_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: --
119: ota_lpm_shd.constraint_error

Line 116: When hr_api.parent_integrity_violated Then

112: -- A check constraint has been violated
113: --
114: ota_lpm_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: --
119: ota_lpm_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: --
119: ota_lpm_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: --
124: ota_lpm_shd.constraint_error

Line 121: When hr_api.unique_integrity_violated Then

117: -- Parent integrity has been violated
118: --
119: ota_lpm_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: --
124: ota_lpm_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: --
124: ota_lpm_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When Others Then
127: --
128: Raise;
129: End update_dml;

Line 346: when hr_api.cannot_find_prog_unit then

342: );
343: --
344: exception
345: --
346: when hr_api.cannot_find_prog_unit then
347: --
348: hr_api.cannot_find_prog_unit_error
349: (p_module_name => 'OTA_LEARNING_PATH_MEMBERS'
350: ,p_hook_type => 'AU');

Line 348: hr_api.cannot_find_prog_unit_error

344: exception
345: --
346: when hr_api.cannot_find_prog_unit then
347: --
348: hr_api.cannot_find_prog_unit_error
349: (p_module_name => 'OTA_LEARNING_PATH_MEMBERS'
350: ,p_hook_type => 'AU');
351: --
352: end;

Line 411: If (p_rec.learning_path_id = hr_api.g_number) then

407: -- p_rec plsql record structure
408: -- to see if a system default is being used. If a system default
409: -- is being used then we must set to the 'current' argument value.
410: --
411: If (p_rec.learning_path_id = hr_api.g_number) then
412: p_rec.learning_path_id :=
413: ota_lpm_shd.g_old_rec.learning_path_id;
414: End If;
415: If (p_rec.activity_version_id = hr_api.g_number) then

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

411: If (p_rec.learning_path_id = hr_api.g_number) then
412: p_rec.learning_path_id :=
413: ota_lpm_shd.g_old_rec.learning_path_id;
414: End If;
415: If (p_rec.activity_version_id = hr_api.g_number) then
416: p_rec.activity_version_id :=
417: ota_lpm_shd.g_old_rec.activity_version_id;
418: End If;
419: If (p_rec.course_sequence = hr_api.g_number) then

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

415: If (p_rec.activity_version_id = hr_api.g_number) then
416: p_rec.activity_version_id :=
417: ota_lpm_shd.g_old_rec.activity_version_id;
418: End If;
419: If (p_rec.course_sequence = hr_api.g_number) then
420: p_rec.course_sequence :=
421: ota_lpm_shd.g_old_rec.course_sequence;
422: End If;
423: If (p_rec.business_group_id = hr_api.g_number) then

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

419: If (p_rec.course_sequence = hr_api.g_number) then
420: p_rec.course_sequence :=
421: ota_lpm_shd.g_old_rec.course_sequence;
422: End If;
423: If (p_rec.business_group_id = hr_api.g_number) then
424: p_rec.business_group_id :=
425: ota_lpm_shd.g_old_rec.business_group_id;
426: End If;
427: If (p_rec.duration = hr_api.g_number) then

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

423: If (p_rec.business_group_id = hr_api.g_number) then
424: p_rec.business_group_id :=
425: ota_lpm_shd.g_old_rec.business_group_id;
426: End If;
427: If (p_rec.duration = hr_api.g_number) then
428: p_rec.duration :=
429: ota_lpm_shd.g_old_rec.duration;
430: End If;
431: If (p_rec.duration_units = hr_api.g_varchar2) then

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

427: If (p_rec.duration = hr_api.g_number) then
428: p_rec.duration :=
429: ota_lpm_shd.g_old_rec.duration;
430: End If;
431: If (p_rec.duration_units = hr_api.g_varchar2) then
432: p_rec.duration_units :=
433: ota_lpm_shd.g_old_rec.duration_units;
434: End If;
435: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 435: If (p_rec.attribute_category = hr_api.g_varchar2) then

431: If (p_rec.duration_units = hr_api.g_varchar2) then
432: p_rec.duration_units :=
433: ota_lpm_shd.g_old_rec.duration_units;
434: End If;
435: If (p_rec.attribute_category = hr_api.g_varchar2) then
436: p_rec.attribute_category :=
437: ota_lpm_shd.g_old_rec.attribute_category;
438: End If;
439: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

435: If (p_rec.attribute_category = hr_api.g_varchar2) then
436: p_rec.attribute_category :=
437: ota_lpm_shd.g_old_rec.attribute_category;
438: End If;
439: If (p_rec.attribute1 = hr_api.g_varchar2) then
440: p_rec.attribute1 :=
441: ota_lpm_shd.g_old_rec.attribute1;
442: End If;
443: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

439: If (p_rec.attribute1 = hr_api.g_varchar2) then
440: p_rec.attribute1 :=
441: ota_lpm_shd.g_old_rec.attribute1;
442: End If;
443: If (p_rec.attribute2 = hr_api.g_varchar2) then
444: p_rec.attribute2 :=
445: ota_lpm_shd.g_old_rec.attribute2;
446: End If;
447: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

443: If (p_rec.attribute2 = hr_api.g_varchar2) then
444: p_rec.attribute2 :=
445: ota_lpm_shd.g_old_rec.attribute2;
446: End If;
447: If (p_rec.attribute3 = hr_api.g_varchar2) then
448: p_rec.attribute3 :=
449: ota_lpm_shd.g_old_rec.attribute3;
450: End If;
451: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

447: If (p_rec.attribute3 = hr_api.g_varchar2) then
448: p_rec.attribute3 :=
449: ota_lpm_shd.g_old_rec.attribute3;
450: End If;
451: If (p_rec.attribute4 = hr_api.g_varchar2) then
452: p_rec.attribute4 :=
453: ota_lpm_shd.g_old_rec.attribute4;
454: End If;
455: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

451: If (p_rec.attribute4 = hr_api.g_varchar2) then
452: p_rec.attribute4 :=
453: ota_lpm_shd.g_old_rec.attribute4;
454: End If;
455: If (p_rec.attribute5 = hr_api.g_varchar2) then
456: p_rec.attribute5 :=
457: ota_lpm_shd.g_old_rec.attribute5;
458: End If;
459: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

455: If (p_rec.attribute5 = hr_api.g_varchar2) then
456: p_rec.attribute5 :=
457: ota_lpm_shd.g_old_rec.attribute5;
458: End If;
459: If (p_rec.attribute6 = hr_api.g_varchar2) then
460: p_rec.attribute6 :=
461: ota_lpm_shd.g_old_rec.attribute6;
462: End If;
463: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

459: If (p_rec.attribute6 = hr_api.g_varchar2) then
460: p_rec.attribute6 :=
461: ota_lpm_shd.g_old_rec.attribute6;
462: End If;
463: If (p_rec.attribute7 = hr_api.g_varchar2) then
464: p_rec.attribute7 :=
465: ota_lpm_shd.g_old_rec.attribute7;
466: End If;
467: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

463: If (p_rec.attribute7 = hr_api.g_varchar2) then
464: p_rec.attribute7 :=
465: ota_lpm_shd.g_old_rec.attribute7;
466: End If;
467: If (p_rec.attribute8 = hr_api.g_varchar2) then
468: p_rec.attribute8 :=
469: ota_lpm_shd.g_old_rec.attribute8;
470: End If;
471: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

467: If (p_rec.attribute8 = hr_api.g_varchar2) then
468: p_rec.attribute8 :=
469: ota_lpm_shd.g_old_rec.attribute8;
470: End If;
471: If (p_rec.attribute9 = hr_api.g_varchar2) then
472: p_rec.attribute9 :=
473: ota_lpm_shd.g_old_rec.attribute9;
474: End If;
475: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

471: If (p_rec.attribute9 = hr_api.g_varchar2) then
472: p_rec.attribute9 :=
473: ota_lpm_shd.g_old_rec.attribute9;
474: End If;
475: If (p_rec.attribute10 = hr_api.g_varchar2) then
476: p_rec.attribute10 :=
477: ota_lpm_shd.g_old_rec.attribute10;
478: End If;
479: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

475: If (p_rec.attribute10 = hr_api.g_varchar2) then
476: p_rec.attribute10 :=
477: ota_lpm_shd.g_old_rec.attribute10;
478: End If;
479: If (p_rec.attribute11 = hr_api.g_varchar2) then
480: p_rec.attribute11 :=
481: ota_lpm_shd.g_old_rec.attribute11;
482: End If;
483: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

479: If (p_rec.attribute11 = hr_api.g_varchar2) then
480: p_rec.attribute11 :=
481: ota_lpm_shd.g_old_rec.attribute11;
482: End If;
483: If (p_rec.attribute12 = hr_api.g_varchar2) then
484: p_rec.attribute12 :=
485: ota_lpm_shd.g_old_rec.attribute12;
486: End If;
487: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

483: If (p_rec.attribute12 = hr_api.g_varchar2) then
484: p_rec.attribute12 :=
485: ota_lpm_shd.g_old_rec.attribute12;
486: End If;
487: If (p_rec.attribute13 = hr_api.g_varchar2) then
488: p_rec.attribute13 :=
489: ota_lpm_shd.g_old_rec.attribute13;
490: End If;
491: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

487: If (p_rec.attribute13 = hr_api.g_varchar2) then
488: p_rec.attribute13 :=
489: ota_lpm_shd.g_old_rec.attribute13;
490: End If;
491: If (p_rec.attribute14 = hr_api.g_varchar2) then
492: p_rec.attribute14 :=
493: ota_lpm_shd.g_old_rec.attribute14;
494: End If;
495: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

491: If (p_rec.attribute14 = hr_api.g_varchar2) then
492: p_rec.attribute14 :=
493: ota_lpm_shd.g_old_rec.attribute14;
494: End If;
495: If (p_rec.attribute15 = hr_api.g_varchar2) then
496: p_rec.attribute15 :=
497: ota_lpm_shd.g_old_rec.attribute15;
498: End If;
499: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

495: If (p_rec.attribute15 = hr_api.g_varchar2) then
496: p_rec.attribute15 :=
497: ota_lpm_shd.g_old_rec.attribute15;
498: End If;
499: If (p_rec.attribute16 = hr_api.g_varchar2) then
500: p_rec.attribute16 :=
501: ota_lpm_shd.g_old_rec.attribute16;
502: End If;
503: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

499: If (p_rec.attribute16 = hr_api.g_varchar2) then
500: p_rec.attribute16 :=
501: ota_lpm_shd.g_old_rec.attribute16;
502: End If;
503: If (p_rec.attribute17 = hr_api.g_varchar2) then
504: p_rec.attribute17 :=
505: ota_lpm_shd.g_old_rec.attribute17;
506: End If;
507: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

503: If (p_rec.attribute17 = hr_api.g_varchar2) then
504: p_rec.attribute17 :=
505: ota_lpm_shd.g_old_rec.attribute17;
506: End If;
507: If (p_rec.attribute18 = hr_api.g_varchar2) then
508: p_rec.attribute18 :=
509: ota_lpm_shd.g_old_rec.attribute18;
510: End If;
511: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

507: If (p_rec.attribute18 = hr_api.g_varchar2) then
508: p_rec.attribute18 :=
509: ota_lpm_shd.g_old_rec.attribute18;
510: End If;
511: If (p_rec.attribute19 = hr_api.g_varchar2) then
512: p_rec.attribute19 :=
513: ota_lpm_shd.g_old_rec.attribute19;
514: End If;
515: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

511: If (p_rec.attribute19 = hr_api.g_varchar2) then
512: p_rec.attribute19 :=
513: ota_lpm_shd.g_old_rec.attribute19;
514: End If;
515: If (p_rec.attribute20 = hr_api.g_varchar2) then
516: p_rec.attribute20 :=
517: ota_lpm_shd.g_old_rec.attribute20;
518: End If;
519: If (p_rec.learning_path_section_id = hr_api.g_number) then

Line 519: If (p_rec.learning_path_section_id = hr_api.g_number) then

515: If (p_rec.attribute20 = hr_api.g_varchar2) then
516: p_rec.attribute20 :=
517: ota_lpm_shd.g_old_rec.attribute20;
518: End If;
519: If (p_rec.learning_path_section_id = hr_api.g_number) then
520: p_rec.learning_path_section_id :=
521: ota_lpm_shd.g_old_rec.learning_path_section_id;
522: End If;
523: If (p_rec.notify_days_before_target = hr_api.g_number) then

Line 523: If (p_rec.notify_days_before_target = hr_api.g_number) then

519: If (p_rec.learning_path_section_id = hr_api.g_number) then
520: p_rec.learning_path_section_id :=
521: ota_lpm_shd.g_old_rec.learning_path_section_id;
522: End If;
523: If (p_rec.notify_days_before_target = hr_api.g_number) then
524: p_rec.notify_days_before_target :=
525: ota_lpm_shd.g_old_rec.notify_days_before_target;
526: End If;
527: --

Line 591: ,p_learning_path_id in number default hr_api.g_number

587: Procedure upd
588: (p_effective_date in date
589: ,p_learning_path_member_id in number
590: ,p_object_version_number in out nocopy number
591: ,p_learning_path_id in number default hr_api.g_number
592: ,p_activity_version_id in number default hr_api.g_number
593: ,p_business_group_id in number default hr_api.g_number
594: ,p_course_sequence in number default hr_api.g_number
595: ,p_duration in number default hr_api.g_number

Line 592: ,p_activity_version_id in number default hr_api.g_number

588: (p_effective_date in date
589: ,p_learning_path_member_id in number
590: ,p_object_version_number in out nocopy number
591: ,p_learning_path_id in number default hr_api.g_number
592: ,p_activity_version_id in number default hr_api.g_number
593: ,p_business_group_id in number default hr_api.g_number
594: ,p_course_sequence in number default hr_api.g_number
595: ,p_duration in number default hr_api.g_number
596: ,p_duration_units in varchar2 default hr_api.g_varchar2

Line 593: ,p_business_group_id in number default hr_api.g_number

589: ,p_learning_path_member_id in number
590: ,p_object_version_number in out nocopy number
591: ,p_learning_path_id in number default hr_api.g_number
592: ,p_activity_version_id in number default hr_api.g_number
593: ,p_business_group_id in number default hr_api.g_number
594: ,p_course_sequence in number default hr_api.g_number
595: ,p_duration in number default hr_api.g_number
596: ,p_duration_units in varchar2 default hr_api.g_varchar2
597: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 594: ,p_course_sequence in number default hr_api.g_number

590: ,p_object_version_number in out nocopy number
591: ,p_learning_path_id in number default hr_api.g_number
592: ,p_activity_version_id in number default hr_api.g_number
593: ,p_business_group_id in number default hr_api.g_number
594: ,p_course_sequence in number default hr_api.g_number
595: ,p_duration in number default hr_api.g_number
596: ,p_duration_units in varchar2 default hr_api.g_varchar2
597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
598: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 595: ,p_duration in number default hr_api.g_number

591: ,p_learning_path_id in number default hr_api.g_number
592: ,p_activity_version_id in number default hr_api.g_number
593: ,p_business_group_id in number default hr_api.g_number
594: ,p_course_sequence in number default hr_api.g_number
595: ,p_duration in number default hr_api.g_number
596: ,p_duration_units in varchar2 default hr_api.g_varchar2
597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
599: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 596: ,p_duration_units in varchar2 default hr_api.g_varchar2

592: ,p_activity_version_id in number default hr_api.g_number
593: ,p_business_group_id in number default hr_api.g_number
594: ,p_course_sequence in number default hr_api.g_number
595: ,p_duration in number default hr_api.g_number
596: ,p_duration_units in varchar2 default hr_api.g_varchar2
597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
600: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 597: ,p_attribute_category in varchar2 default hr_api.g_varchar2

593: ,p_business_group_id in number default hr_api.g_number
594: ,p_course_sequence in number default hr_api.g_number
595: ,p_duration in number default hr_api.g_number
596: ,p_duration_units in varchar2 default hr_api.g_varchar2
597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
601: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 598: ,p_attribute1 in varchar2 default hr_api.g_varchar2

594: ,p_course_sequence in number default hr_api.g_number
595: ,p_duration in number default hr_api.g_number
596: ,p_duration_units in varchar2 default hr_api.g_varchar2
597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
602: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 599: ,p_attribute2 in varchar2 default hr_api.g_varchar2

595: ,p_duration in number default hr_api.g_number
596: ,p_duration_units in varchar2 default hr_api.g_varchar2
597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
603: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 600: ,p_attribute3 in varchar2 default hr_api.g_varchar2

596: ,p_duration_units in varchar2 default hr_api.g_varchar2
597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
604: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 601: ,p_attribute4 in varchar2 default hr_api.g_varchar2

597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
605: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 602: ,p_attribute5 in varchar2 default hr_api.g_varchar2

598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
606: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 603: ,p_attribute6 in varchar2 default hr_api.g_varchar2

599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
607: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 604: ,p_attribute7 in varchar2 default hr_api.g_varchar2

600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
608: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 605: ,p_attribute8 in varchar2 default hr_api.g_varchar2

601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
608: ,p_attribute11 in varchar2 default hr_api.g_varchar2
609: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 606: ,p_attribute9 in varchar2 default hr_api.g_varchar2

602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
608: ,p_attribute11 in varchar2 default hr_api.g_varchar2
609: ,p_attribute12 in varchar2 default hr_api.g_varchar2
610: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 607: ,p_attribute10 in varchar2 default hr_api.g_varchar2

603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
608: ,p_attribute11 in varchar2 default hr_api.g_varchar2
609: ,p_attribute12 in varchar2 default hr_api.g_varchar2
610: ,p_attribute13 in varchar2 default hr_api.g_varchar2
611: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 608: ,p_attribute11 in varchar2 default hr_api.g_varchar2

604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
608: ,p_attribute11 in varchar2 default hr_api.g_varchar2
609: ,p_attribute12 in varchar2 default hr_api.g_varchar2
610: ,p_attribute13 in varchar2 default hr_api.g_varchar2
611: ,p_attribute14 in varchar2 default hr_api.g_varchar2
612: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 609: ,p_attribute12 in varchar2 default hr_api.g_varchar2

605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
608: ,p_attribute11 in varchar2 default hr_api.g_varchar2
609: ,p_attribute12 in varchar2 default hr_api.g_varchar2
610: ,p_attribute13 in varchar2 default hr_api.g_varchar2
611: ,p_attribute14 in varchar2 default hr_api.g_varchar2
612: ,p_attribute15 in varchar2 default hr_api.g_varchar2
613: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 610: ,p_attribute13 in varchar2 default hr_api.g_varchar2

606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
608: ,p_attribute11 in varchar2 default hr_api.g_varchar2
609: ,p_attribute12 in varchar2 default hr_api.g_varchar2
610: ,p_attribute13 in varchar2 default hr_api.g_varchar2
611: ,p_attribute14 in varchar2 default hr_api.g_varchar2
612: ,p_attribute15 in varchar2 default hr_api.g_varchar2
613: ,p_attribute16 in varchar2 default hr_api.g_varchar2
614: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 611: ,p_attribute14 in varchar2 default hr_api.g_varchar2

607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
608: ,p_attribute11 in varchar2 default hr_api.g_varchar2
609: ,p_attribute12 in varchar2 default hr_api.g_varchar2
610: ,p_attribute13 in varchar2 default hr_api.g_varchar2
611: ,p_attribute14 in varchar2 default hr_api.g_varchar2
612: ,p_attribute15 in varchar2 default hr_api.g_varchar2
613: ,p_attribute16 in varchar2 default hr_api.g_varchar2
614: ,p_attribute17 in varchar2 default hr_api.g_varchar2
615: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 612: ,p_attribute15 in varchar2 default hr_api.g_varchar2

608: ,p_attribute11 in varchar2 default hr_api.g_varchar2
609: ,p_attribute12 in varchar2 default hr_api.g_varchar2
610: ,p_attribute13 in varchar2 default hr_api.g_varchar2
611: ,p_attribute14 in varchar2 default hr_api.g_varchar2
612: ,p_attribute15 in varchar2 default hr_api.g_varchar2
613: ,p_attribute16 in varchar2 default hr_api.g_varchar2
614: ,p_attribute17 in varchar2 default hr_api.g_varchar2
615: ,p_attribute18 in varchar2 default hr_api.g_varchar2
616: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 613: ,p_attribute16 in varchar2 default hr_api.g_varchar2

609: ,p_attribute12 in varchar2 default hr_api.g_varchar2
610: ,p_attribute13 in varchar2 default hr_api.g_varchar2
611: ,p_attribute14 in varchar2 default hr_api.g_varchar2
612: ,p_attribute15 in varchar2 default hr_api.g_varchar2
613: ,p_attribute16 in varchar2 default hr_api.g_varchar2
614: ,p_attribute17 in varchar2 default hr_api.g_varchar2
615: ,p_attribute18 in varchar2 default hr_api.g_varchar2
616: ,p_attribute19 in varchar2 default hr_api.g_varchar2
617: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 614: ,p_attribute17 in varchar2 default hr_api.g_varchar2

610: ,p_attribute13 in varchar2 default hr_api.g_varchar2
611: ,p_attribute14 in varchar2 default hr_api.g_varchar2
612: ,p_attribute15 in varchar2 default hr_api.g_varchar2
613: ,p_attribute16 in varchar2 default hr_api.g_varchar2
614: ,p_attribute17 in varchar2 default hr_api.g_varchar2
615: ,p_attribute18 in varchar2 default hr_api.g_varchar2
616: ,p_attribute19 in varchar2 default hr_api.g_varchar2
617: ,p_attribute20 in varchar2 default hr_api.g_varchar2
618: ,p_learning_path_section_id in number default hr_api.g_number

Line 615: ,p_attribute18 in varchar2 default hr_api.g_varchar2

611: ,p_attribute14 in varchar2 default hr_api.g_varchar2
612: ,p_attribute15 in varchar2 default hr_api.g_varchar2
613: ,p_attribute16 in varchar2 default hr_api.g_varchar2
614: ,p_attribute17 in varchar2 default hr_api.g_varchar2
615: ,p_attribute18 in varchar2 default hr_api.g_varchar2
616: ,p_attribute19 in varchar2 default hr_api.g_varchar2
617: ,p_attribute20 in varchar2 default hr_api.g_varchar2
618: ,p_learning_path_section_id in number default hr_api.g_number
619: ,p_notify_days_before_target in number default hr_api.g_number

Line 616: ,p_attribute19 in varchar2 default hr_api.g_varchar2

612: ,p_attribute15 in varchar2 default hr_api.g_varchar2
613: ,p_attribute16 in varchar2 default hr_api.g_varchar2
614: ,p_attribute17 in varchar2 default hr_api.g_varchar2
615: ,p_attribute18 in varchar2 default hr_api.g_varchar2
616: ,p_attribute19 in varchar2 default hr_api.g_varchar2
617: ,p_attribute20 in varchar2 default hr_api.g_varchar2
618: ,p_learning_path_section_id in number default hr_api.g_number
619: ,p_notify_days_before_target in number default hr_api.g_number
620: ) is

Line 617: ,p_attribute20 in varchar2 default hr_api.g_varchar2

613: ,p_attribute16 in varchar2 default hr_api.g_varchar2
614: ,p_attribute17 in varchar2 default hr_api.g_varchar2
615: ,p_attribute18 in varchar2 default hr_api.g_varchar2
616: ,p_attribute19 in varchar2 default hr_api.g_varchar2
617: ,p_attribute20 in varchar2 default hr_api.g_varchar2
618: ,p_learning_path_section_id in number default hr_api.g_number
619: ,p_notify_days_before_target in number default hr_api.g_number
620: ) is
621: --

Line 618: ,p_learning_path_section_id in number default hr_api.g_number

614: ,p_attribute17 in varchar2 default hr_api.g_varchar2
615: ,p_attribute18 in varchar2 default hr_api.g_varchar2
616: ,p_attribute19 in varchar2 default hr_api.g_varchar2
617: ,p_attribute20 in varchar2 default hr_api.g_varchar2
618: ,p_learning_path_section_id in number default hr_api.g_number
619: ,p_notify_days_before_target in number default hr_api.g_number
620: ) is
621: --
622: l_rec ota_lpm_shd.g_rec_type;

Line 619: ,p_notify_days_before_target in number default hr_api.g_number

615: ,p_attribute18 in varchar2 default hr_api.g_varchar2
616: ,p_attribute19 in varchar2 default hr_api.g_varchar2
617: ,p_attribute20 in varchar2 default hr_api.g_varchar2
618: ,p_learning_path_section_id in number default hr_api.g_number
619: ,p_notify_days_before_target in number default hr_api.g_number
620: ) is
621: --
622: l_rec ota_lpm_shd.g_rec_type;
623: l_proc varchar2(72) := g_package||'upd';