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

APPS.OTA_LPS_UPD dependencies on HR_API

Line 117: When hr_api.check_integrity_violated Then

113: --
114: hr_utility.set_location(' Leaving:'||l_proc, 10);
115: --
116: Exception
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: --
120: ota_lps_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: --
120: ota_lps_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --
125: ota_lps_shd.constraint_error

Line 122: When hr_api.parent_integrity_violated Then

118: -- A check constraint has been violated
119: --
120: ota_lps_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --
125: ota_lps_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --
125: ota_lps_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --
130: ota_lps_shd.constraint_error

Line 127: When hr_api.unique_integrity_violated Then

123: -- Parent integrity has been violated
124: --
125: ota_lps_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --
130: ota_lps_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --
130: ota_lps_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: --
134: Raise;
135: End update_dml;

Line 381: when hr_api.cannot_find_prog_unit then

377:
378: --
379: exception
380: --
381: when hr_api.cannot_find_prog_unit then
382: --
383: hr_api.cannot_find_prog_unit_error
384: (p_module_name => 'OTA_LEARNING_PATHS'
385: ,p_hook_type => 'AU');

Line 383: hr_api.cannot_find_prog_unit_error

379: exception
380: --
381: when hr_api.cannot_find_prog_unit then
382: --
383: hr_api.cannot_find_prog_unit_error
384: (p_module_name => 'OTA_LEARNING_PATHS'
385: ,p_hook_type => 'AU');
386: --
387: end;

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

443: -- p_rec plsql record structure
444: -- to see if a system default is being used. If a system default
445: -- is being used then we must set to the 'current' argument value.
446: --
447: If (p_rec.business_group_id = hr_api.g_number) then
448: p_rec.business_group_id :=
449: ota_lps_shd.g_old_rec.business_group_id;
450: End If;
451: If (p_rec.duration = hr_api.g_number) then

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

447: If (p_rec.business_group_id = hr_api.g_number) then
448: p_rec.business_group_id :=
449: ota_lps_shd.g_old_rec.business_group_id;
450: End If;
451: If (p_rec.duration = hr_api.g_number) then
452: p_rec.duration :=
453: ota_lps_shd.g_old_rec.duration;
454: End If;
455: If (p_rec.duration_units = hr_api.g_varchar2) then

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

451: If (p_rec.duration = hr_api.g_number) then
452: p_rec.duration :=
453: ota_lps_shd.g_old_rec.duration;
454: End If;
455: If (p_rec.duration_units = hr_api.g_varchar2) then
456: p_rec.duration_units :=
457: ota_lps_shd.g_old_rec.duration_units;
458: End If;
459: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

455: If (p_rec.duration_units = hr_api.g_varchar2) then
456: p_rec.duration_units :=
457: ota_lps_shd.g_old_rec.duration_units;
458: End If;
459: If (p_rec.attribute_category = hr_api.g_varchar2) then
460: p_rec.attribute_category :=
461: ota_lps_shd.g_old_rec.attribute_category;
462: End If;
463: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

459: If (p_rec.attribute_category = hr_api.g_varchar2) then
460: p_rec.attribute_category :=
461: ota_lps_shd.g_old_rec.attribute_category;
462: End If;
463: If (p_rec.attribute1 = hr_api.g_varchar2) then
464: p_rec.attribute1 :=
465: ota_lps_shd.g_old_rec.attribute1;
466: End If;
467: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

463: If (p_rec.attribute1 = hr_api.g_varchar2) then
464: p_rec.attribute1 :=
465: ota_lps_shd.g_old_rec.attribute1;
466: End If;
467: If (p_rec.attribute2 = hr_api.g_varchar2) then
468: p_rec.attribute2 :=
469: ota_lps_shd.g_old_rec.attribute2;
470: End If;
471: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

467: If (p_rec.attribute2 = hr_api.g_varchar2) then
468: p_rec.attribute2 :=
469: ota_lps_shd.g_old_rec.attribute2;
470: End If;
471: If (p_rec.attribute3 = hr_api.g_varchar2) then
472: p_rec.attribute3 :=
473: ota_lps_shd.g_old_rec.attribute3;
474: End If;
475: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

471: If (p_rec.attribute3 = hr_api.g_varchar2) then
472: p_rec.attribute3 :=
473: ota_lps_shd.g_old_rec.attribute3;
474: End If;
475: If (p_rec.attribute4 = hr_api.g_varchar2) then
476: p_rec.attribute4 :=
477: ota_lps_shd.g_old_rec.attribute4;
478: End If;
479: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

475: If (p_rec.attribute4 = hr_api.g_varchar2) then
476: p_rec.attribute4 :=
477: ota_lps_shd.g_old_rec.attribute4;
478: End If;
479: If (p_rec.attribute5 = hr_api.g_varchar2) then
480: p_rec.attribute5 :=
481: ota_lps_shd.g_old_rec.attribute5;
482: End If;
483: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

479: If (p_rec.attribute5 = hr_api.g_varchar2) then
480: p_rec.attribute5 :=
481: ota_lps_shd.g_old_rec.attribute5;
482: End If;
483: If (p_rec.attribute6 = hr_api.g_varchar2) then
484: p_rec.attribute6 :=
485: ota_lps_shd.g_old_rec.attribute6;
486: End If;
487: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

483: If (p_rec.attribute6 = hr_api.g_varchar2) then
484: p_rec.attribute6 :=
485: ota_lps_shd.g_old_rec.attribute6;
486: End If;
487: If (p_rec.attribute7 = hr_api.g_varchar2) then
488: p_rec.attribute7 :=
489: ota_lps_shd.g_old_rec.attribute7;
490: End If;
491: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

487: If (p_rec.attribute7 = hr_api.g_varchar2) then
488: p_rec.attribute7 :=
489: ota_lps_shd.g_old_rec.attribute7;
490: End If;
491: If (p_rec.attribute8 = hr_api.g_varchar2) then
492: p_rec.attribute8 :=
493: ota_lps_shd.g_old_rec.attribute8;
494: End If;
495: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

491: If (p_rec.attribute8 = hr_api.g_varchar2) then
492: p_rec.attribute8 :=
493: ota_lps_shd.g_old_rec.attribute8;
494: End If;
495: If (p_rec.attribute9 = hr_api.g_varchar2) then
496: p_rec.attribute9 :=
497: ota_lps_shd.g_old_rec.attribute9;
498: End If;
499: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

495: If (p_rec.attribute9 = hr_api.g_varchar2) then
496: p_rec.attribute9 :=
497: ota_lps_shd.g_old_rec.attribute9;
498: End If;
499: If (p_rec.attribute10 = hr_api.g_varchar2) then
500: p_rec.attribute10 :=
501: ota_lps_shd.g_old_rec.attribute10;
502: End If;
503: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

499: If (p_rec.attribute10 = hr_api.g_varchar2) then
500: p_rec.attribute10 :=
501: ota_lps_shd.g_old_rec.attribute10;
502: End If;
503: If (p_rec.attribute11 = hr_api.g_varchar2) then
504: p_rec.attribute11 :=
505: ota_lps_shd.g_old_rec.attribute11;
506: End If;
507: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

503: If (p_rec.attribute11 = hr_api.g_varchar2) then
504: p_rec.attribute11 :=
505: ota_lps_shd.g_old_rec.attribute11;
506: End If;
507: If (p_rec.attribute12 = hr_api.g_varchar2) then
508: p_rec.attribute12 :=
509: ota_lps_shd.g_old_rec.attribute12;
510: End If;
511: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

507: If (p_rec.attribute12 = hr_api.g_varchar2) then
508: p_rec.attribute12 :=
509: ota_lps_shd.g_old_rec.attribute12;
510: End If;
511: If (p_rec.attribute13 = hr_api.g_varchar2) then
512: p_rec.attribute13 :=
513: ota_lps_shd.g_old_rec.attribute13;
514: End If;
515: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

511: If (p_rec.attribute13 = hr_api.g_varchar2) then
512: p_rec.attribute13 :=
513: ota_lps_shd.g_old_rec.attribute13;
514: End If;
515: If (p_rec.attribute14 = hr_api.g_varchar2) then
516: p_rec.attribute14 :=
517: ota_lps_shd.g_old_rec.attribute14;
518: End If;
519: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

515: If (p_rec.attribute14 = hr_api.g_varchar2) then
516: p_rec.attribute14 :=
517: ota_lps_shd.g_old_rec.attribute14;
518: End If;
519: If (p_rec.attribute15 = hr_api.g_varchar2) then
520: p_rec.attribute15 :=
521: ota_lps_shd.g_old_rec.attribute15;
522: End If;
523: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

519: If (p_rec.attribute15 = hr_api.g_varchar2) then
520: p_rec.attribute15 :=
521: ota_lps_shd.g_old_rec.attribute15;
522: End If;
523: If (p_rec.attribute16 = hr_api.g_varchar2) then
524: p_rec.attribute16 :=
525: ota_lps_shd.g_old_rec.attribute16;
526: End If;
527: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

523: If (p_rec.attribute16 = hr_api.g_varchar2) then
524: p_rec.attribute16 :=
525: ota_lps_shd.g_old_rec.attribute16;
526: End If;
527: If (p_rec.attribute17 = hr_api.g_varchar2) then
528: p_rec.attribute17 :=
529: ota_lps_shd.g_old_rec.attribute17;
530: End If;
531: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

527: If (p_rec.attribute17 = hr_api.g_varchar2) then
528: p_rec.attribute17 :=
529: ota_lps_shd.g_old_rec.attribute17;
530: End If;
531: If (p_rec.attribute18 = hr_api.g_varchar2) then
532: p_rec.attribute18 :=
533: ota_lps_shd.g_old_rec.attribute18;
534: End If;
535: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

531: If (p_rec.attribute18 = hr_api.g_varchar2) then
532: p_rec.attribute18 :=
533: ota_lps_shd.g_old_rec.attribute18;
534: End If;
535: If (p_rec.attribute19 = hr_api.g_varchar2) then
536: p_rec.attribute19 :=
537: ota_lps_shd.g_old_rec.attribute19;
538: End If;
539: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

535: If (p_rec.attribute19 = hr_api.g_varchar2) then
536: p_rec.attribute19 :=
537: ota_lps_shd.g_old_rec.attribute19;
538: End If;
539: If (p_rec.attribute20 = hr_api.g_varchar2) then
540: p_rec.attribute20 :=
541: ota_lps_shd.g_old_rec.attribute20;
542: End If;
543: If (p_rec.start_date_active = hr_api.g_date) then

Line 543: If (p_rec.start_date_active = hr_api.g_date) then

539: If (p_rec.attribute20 = hr_api.g_varchar2) then
540: p_rec.attribute20 :=
541: ota_lps_shd.g_old_rec.attribute20;
542: End If;
543: If (p_rec.start_date_active = hr_api.g_date) then
544: p_rec.start_date_active :=
545: ota_lps_shd.g_old_rec.start_date_active;
546: End If;
547: If (p_rec.end_date_active = hr_api.g_date) then

Line 547: If (p_rec.end_date_active = hr_api.g_date) then

543: If (p_rec.start_date_active = hr_api.g_date) then
544: p_rec.start_date_active :=
545: ota_lps_shd.g_old_rec.start_date_active;
546: End If;
547: If (p_rec.end_date_active = hr_api.g_date) then
548: p_rec.end_date_active :=
549: ota_lps_shd.g_old_rec.end_date_active;
550: End If;
551: If (p_rec.path_source_code = hr_api.g_varchar2) then

Line 551: If (p_rec.path_source_code = hr_api.g_varchar2) then

547: If (p_rec.end_date_active = hr_api.g_date) then
548: p_rec.end_date_active :=
549: ota_lps_shd.g_old_rec.end_date_active;
550: End If;
551: If (p_rec.path_source_code = hr_api.g_varchar2) then
552: p_rec.path_source_code :=
553: ota_lps_shd.g_old_rec.path_source_code;
554: End If;
555: If (p_rec.source_function_code = hr_api.g_varchar2) then

Line 555: If (p_rec.source_function_code = hr_api.g_varchar2) then

551: If (p_rec.path_source_code = hr_api.g_varchar2) then
552: p_rec.path_source_code :=
553: ota_lps_shd.g_old_rec.path_source_code;
554: End If;
555: If (p_rec.source_function_code = hr_api.g_varchar2) then
556: p_rec.source_function_code :=
557: ota_lps_shd.g_old_rec.source_function_code;
558: End If;
559: If (p_rec.assignment_id = hr_api.g_number) then

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

555: If (p_rec.source_function_code = hr_api.g_varchar2) then
556: p_rec.source_function_code :=
557: ota_lps_shd.g_old_rec.source_function_code;
558: End If;
559: If (p_rec.assignment_id = hr_api.g_number) then
560: p_rec.assignment_id :=
561: ota_lps_shd.g_old_rec.assignment_id;
562: End If;
563: If (p_rec.source_id = hr_api.g_number) then

Line 563: If (p_rec.source_id = hr_api.g_number) then

559: If (p_rec.assignment_id = hr_api.g_number) then
560: p_rec.assignment_id :=
561: ota_lps_shd.g_old_rec.assignment_id;
562: End If;
563: If (p_rec.source_id = hr_api.g_number) then
564: p_rec.source_id :=
565: ota_lps_shd.g_old_rec.source_id;
566: End If;
567: If (p_rec.notify_days_before_target = hr_api.g_number) then

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

563: If (p_rec.source_id = hr_api.g_number) then
564: p_rec.source_id :=
565: ota_lps_shd.g_old_rec.source_id;
566: End If;
567: If (p_rec.notify_days_before_target = hr_api.g_number) then
568: p_rec.notify_days_before_target :=
569: ota_lps_shd.g_old_rec.notify_days_before_target;
570: End If;
571: If (p_rec.person_id = hr_api.g_number) then

Line 571: If (p_rec.person_id = hr_api.g_number) then

567: If (p_rec.notify_days_before_target = hr_api.g_number) then
568: p_rec.notify_days_before_target :=
569: ota_lps_shd.g_old_rec.notify_days_before_target;
570: End If;
571: If (p_rec.person_id = hr_api.g_number) then
572: p_rec.person_id :=
573: ota_lps_shd.g_old_rec.person_id;
574: End If;
575: If (p_rec.contact_id = hr_api.g_number) then

Line 575: If (p_rec.contact_id = hr_api.g_number) then

571: If (p_rec.person_id = hr_api.g_number) then
572: p_rec.person_id :=
573: ota_lps_shd.g_old_rec.person_id;
574: End If;
575: If (p_rec.contact_id = hr_api.g_number) then
576: p_rec.contact_id :=
577: ota_lps_shd.g_old_rec.contact_id;
578: End If;
579: If (p_rec.display_to_learner_flag = hr_api.g_varchar2) then

Line 579: If (p_rec.display_to_learner_flag = hr_api.g_varchar2) then

575: If (p_rec.contact_id = hr_api.g_number) then
576: p_rec.contact_id :=
577: ota_lps_shd.g_old_rec.contact_id;
578: End If;
579: If (p_rec.display_to_learner_flag = hr_api.g_varchar2) then
580: p_rec.display_to_learner_flag :=
581: ota_lps_shd.g_old_rec.display_to_learner_flag;
582: End If;
583: If (p_rec.public_flag = hr_api.g_varchar2) then

Line 583: If (p_rec.public_flag = hr_api.g_varchar2) then

579: If (p_rec.display_to_learner_flag = hr_api.g_varchar2) then
580: p_rec.display_to_learner_flag :=
581: ota_lps_shd.g_old_rec.display_to_learner_flag;
582: End If;
583: If (p_rec.public_flag = hr_api.g_varchar2) then
584: p_rec.public_flag :=
585: ota_lps_shd.g_old_rec.public_flag;
586: End If;
587: If (p_rec.competency_update_level = hr_api.g_varchar2) then

Line 587: If (p_rec.competency_update_level = hr_api.g_varchar2) then

583: If (p_rec.public_flag = hr_api.g_varchar2) then
584: p_rec.public_flag :=
585: ota_lps_shd.g_old_rec.public_flag;
586: End If;
587: If (p_rec.competency_update_level = hr_api.g_varchar2) then
588: p_rec.competency_update_level :=
589: ota_lps_shd.g_old_rec.competency_update_level;
590: End If;
591: --

Line 655: ,p_business_group_id in number default hr_api.g_number

651: Procedure upd
652: (p_effective_date in date
653: ,p_learning_path_id in number
654: ,p_object_version_number in out nocopy number
655: ,p_business_group_id in number default hr_api.g_number
656: ,p_start_date_active in date default hr_api.g_date
657: ,p_end_date_active in date default hr_api.g_date
658: ,p_duration in number default hr_api.g_number
659: ,p_duration_units in varchar2 default hr_api.g_varchar2

Line 656: ,p_start_date_active in date default hr_api.g_date

652: (p_effective_date in date
653: ,p_learning_path_id in number
654: ,p_object_version_number in out nocopy number
655: ,p_business_group_id in number default hr_api.g_number
656: ,p_start_date_active in date default hr_api.g_date
657: ,p_end_date_active in date default hr_api.g_date
658: ,p_duration in number default hr_api.g_number
659: ,p_duration_units in varchar2 default hr_api.g_varchar2
660: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 657: ,p_end_date_active in date default hr_api.g_date

653: ,p_learning_path_id in number
654: ,p_object_version_number in out nocopy number
655: ,p_business_group_id in number default hr_api.g_number
656: ,p_start_date_active in date default hr_api.g_date
657: ,p_end_date_active in date default hr_api.g_date
658: ,p_duration in number default hr_api.g_number
659: ,p_duration_units in varchar2 default hr_api.g_varchar2
660: ,p_attribute_category in varchar2 default hr_api.g_varchar2
661: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 658: ,p_duration in number default hr_api.g_number

654: ,p_object_version_number in out nocopy number
655: ,p_business_group_id in number default hr_api.g_number
656: ,p_start_date_active in date default hr_api.g_date
657: ,p_end_date_active in date default hr_api.g_date
658: ,p_duration in number default hr_api.g_number
659: ,p_duration_units in varchar2 default hr_api.g_varchar2
660: ,p_attribute_category in varchar2 default hr_api.g_varchar2
661: ,p_attribute1 in varchar2 default hr_api.g_varchar2
662: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 659: ,p_duration_units in varchar2 default hr_api.g_varchar2

655: ,p_business_group_id in number default hr_api.g_number
656: ,p_start_date_active in date default hr_api.g_date
657: ,p_end_date_active in date default hr_api.g_date
658: ,p_duration in number default hr_api.g_number
659: ,p_duration_units in varchar2 default hr_api.g_varchar2
660: ,p_attribute_category in varchar2 default hr_api.g_varchar2
661: ,p_attribute1 in varchar2 default hr_api.g_varchar2
662: ,p_attribute2 in varchar2 default hr_api.g_varchar2
663: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 660: ,p_attribute_category in varchar2 default hr_api.g_varchar2

656: ,p_start_date_active in date default hr_api.g_date
657: ,p_end_date_active in date default hr_api.g_date
658: ,p_duration in number default hr_api.g_number
659: ,p_duration_units in varchar2 default hr_api.g_varchar2
660: ,p_attribute_category in varchar2 default hr_api.g_varchar2
661: ,p_attribute1 in varchar2 default hr_api.g_varchar2
662: ,p_attribute2 in varchar2 default hr_api.g_varchar2
663: ,p_attribute3 in varchar2 default hr_api.g_varchar2
664: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 661: ,p_attribute1 in varchar2 default hr_api.g_varchar2

657: ,p_end_date_active in date default hr_api.g_date
658: ,p_duration in number default hr_api.g_number
659: ,p_duration_units in varchar2 default hr_api.g_varchar2
660: ,p_attribute_category in varchar2 default hr_api.g_varchar2
661: ,p_attribute1 in varchar2 default hr_api.g_varchar2
662: ,p_attribute2 in varchar2 default hr_api.g_varchar2
663: ,p_attribute3 in varchar2 default hr_api.g_varchar2
664: ,p_attribute4 in varchar2 default hr_api.g_varchar2
665: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 662: ,p_attribute2 in varchar2 default hr_api.g_varchar2

658: ,p_duration in number default hr_api.g_number
659: ,p_duration_units in varchar2 default hr_api.g_varchar2
660: ,p_attribute_category in varchar2 default hr_api.g_varchar2
661: ,p_attribute1 in varchar2 default hr_api.g_varchar2
662: ,p_attribute2 in varchar2 default hr_api.g_varchar2
663: ,p_attribute3 in varchar2 default hr_api.g_varchar2
664: ,p_attribute4 in varchar2 default hr_api.g_varchar2
665: ,p_attribute5 in varchar2 default hr_api.g_varchar2
666: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 663: ,p_attribute3 in varchar2 default hr_api.g_varchar2

659: ,p_duration_units in varchar2 default hr_api.g_varchar2
660: ,p_attribute_category in varchar2 default hr_api.g_varchar2
661: ,p_attribute1 in varchar2 default hr_api.g_varchar2
662: ,p_attribute2 in varchar2 default hr_api.g_varchar2
663: ,p_attribute3 in varchar2 default hr_api.g_varchar2
664: ,p_attribute4 in varchar2 default hr_api.g_varchar2
665: ,p_attribute5 in varchar2 default hr_api.g_varchar2
666: ,p_attribute6 in varchar2 default hr_api.g_varchar2
667: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 664: ,p_attribute4 in varchar2 default hr_api.g_varchar2

660: ,p_attribute_category in varchar2 default hr_api.g_varchar2
661: ,p_attribute1 in varchar2 default hr_api.g_varchar2
662: ,p_attribute2 in varchar2 default hr_api.g_varchar2
663: ,p_attribute3 in varchar2 default hr_api.g_varchar2
664: ,p_attribute4 in varchar2 default hr_api.g_varchar2
665: ,p_attribute5 in varchar2 default hr_api.g_varchar2
666: ,p_attribute6 in varchar2 default hr_api.g_varchar2
667: ,p_attribute7 in varchar2 default hr_api.g_varchar2
668: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 665: ,p_attribute5 in varchar2 default hr_api.g_varchar2

661: ,p_attribute1 in varchar2 default hr_api.g_varchar2
662: ,p_attribute2 in varchar2 default hr_api.g_varchar2
663: ,p_attribute3 in varchar2 default hr_api.g_varchar2
664: ,p_attribute4 in varchar2 default hr_api.g_varchar2
665: ,p_attribute5 in varchar2 default hr_api.g_varchar2
666: ,p_attribute6 in varchar2 default hr_api.g_varchar2
667: ,p_attribute7 in varchar2 default hr_api.g_varchar2
668: ,p_attribute8 in varchar2 default hr_api.g_varchar2
669: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 666: ,p_attribute6 in varchar2 default hr_api.g_varchar2

662: ,p_attribute2 in varchar2 default hr_api.g_varchar2
663: ,p_attribute3 in varchar2 default hr_api.g_varchar2
664: ,p_attribute4 in varchar2 default hr_api.g_varchar2
665: ,p_attribute5 in varchar2 default hr_api.g_varchar2
666: ,p_attribute6 in varchar2 default hr_api.g_varchar2
667: ,p_attribute7 in varchar2 default hr_api.g_varchar2
668: ,p_attribute8 in varchar2 default hr_api.g_varchar2
669: ,p_attribute9 in varchar2 default hr_api.g_varchar2
670: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 667: ,p_attribute7 in varchar2 default hr_api.g_varchar2

663: ,p_attribute3 in varchar2 default hr_api.g_varchar2
664: ,p_attribute4 in varchar2 default hr_api.g_varchar2
665: ,p_attribute5 in varchar2 default hr_api.g_varchar2
666: ,p_attribute6 in varchar2 default hr_api.g_varchar2
667: ,p_attribute7 in varchar2 default hr_api.g_varchar2
668: ,p_attribute8 in varchar2 default hr_api.g_varchar2
669: ,p_attribute9 in varchar2 default hr_api.g_varchar2
670: ,p_attribute10 in varchar2 default hr_api.g_varchar2
671: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 668: ,p_attribute8 in varchar2 default hr_api.g_varchar2

664: ,p_attribute4 in varchar2 default hr_api.g_varchar2
665: ,p_attribute5 in varchar2 default hr_api.g_varchar2
666: ,p_attribute6 in varchar2 default hr_api.g_varchar2
667: ,p_attribute7 in varchar2 default hr_api.g_varchar2
668: ,p_attribute8 in varchar2 default hr_api.g_varchar2
669: ,p_attribute9 in varchar2 default hr_api.g_varchar2
670: ,p_attribute10 in varchar2 default hr_api.g_varchar2
671: ,p_attribute11 in varchar2 default hr_api.g_varchar2
672: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 669: ,p_attribute9 in varchar2 default hr_api.g_varchar2

665: ,p_attribute5 in varchar2 default hr_api.g_varchar2
666: ,p_attribute6 in varchar2 default hr_api.g_varchar2
667: ,p_attribute7 in varchar2 default hr_api.g_varchar2
668: ,p_attribute8 in varchar2 default hr_api.g_varchar2
669: ,p_attribute9 in varchar2 default hr_api.g_varchar2
670: ,p_attribute10 in varchar2 default hr_api.g_varchar2
671: ,p_attribute11 in varchar2 default hr_api.g_varchar2
672: ,p_attribute12 in varchar2 default hr_api.g_varchar2
673: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 670: ,p_attribute10 in varchar2 default hr_api.g_varchar2

666: ,p_attribute6 in varchar2 default hr_api.g_varchar2
667: ,p_attribute7 in varchar2 default hr_api.g_varchar2
668: ,p_attribute8 in varchar2 default hr_api.g_varchar2
669: ,p_attribute9 in varchar2 default hr_api.g_varchar2
670: ,p_attribute10 in varchar2 default hr_api.g_varchar2
671: ,p_attribute11 in varchar2 default hr_api.g_varchar2
672: ,p_attribute12 in varchar2 default hr_api.g_varchar2
673: ,p_attribute13 in varchar2 default hr_api.g_varchar2
674: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 671: ,p_attribute11 in varchar2 default hr_api.g_varchar2

667: ,p_attribute7 in varchar2 default hr_api.g_varchar2
668: ,p_attribute8 in varchar2 default hr_api.g_varchar2
669: ,p_attribute9 in varchar2 default hr_api.g_varchar2
670: ,p_attribute10 in varchar2 default hr_api.g_varchar2
671: ,p_attribute11 in varchar2 default hr_api.g_varchar2
672: ,p_attribute12 in varchar2 default hr_api.g_varchar2
673: ,p_attribute13 in varchar2 default hr_api.g_varchar2
674: ,p_attribute14 in varchar2 default hr_api.g_varchar2
675: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 672: ,p_attribute12 in varchar2 default hr_api.g_varchar2

668: ,p_attribute8 in varchar2 default hr_api.g_varchar2
669: ,p_attribute9 in varchar2 default hr_api.g_varchar2
670: ,p_attribute10 in varchar2 default hr_api.g_varchar2
671: ,p_attribute11 in varchar2 default hr_api.g_varchar2
672: ,p_attribute12 in varchar2 default hr_api.g_varchar2
673: ,p_attribute13 in varchar2 default hr_api.g_varchar2
674: ,p_attribute14 in varchar2 default hr_api.g_varchar2
675: ,p_attribute15 in varchar2 default hr_api.g_varchar2
676: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 673: ,p_attribute13 in varchar2 default hr_api.g_varchar2

669: ,p_attribute9 in varchar2 default hr_api.g_varchar2
670: ,p_attribute10 in varchar2 default hr_api.g_varchar2
671: ,p_attribute11 in varchar2 default hr_api.g_varchar2
672: ,p_attribute12 in varchar2 default hr_api.g_varchar2
673: ,p_attribute13 in varchar2 default hr_api.g_varchar2
674: ,p_attribute14 in varchar2 default hr_api.g_varchar2
675: ,p_attribute15 in varchar2 default hr_api.g_varchar2
676: ,p_attribute16 in varchar2 default hr_api.g_varchar2
677: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 674: ,p_attribute14 in varchar2 default hr_api.g_varchar2

670: ,p_attribute10 in varchar2 default hr_api.g_varchar2
671: ,p_attribute11 in varchar2 default hr_api.g_varchar2
672: ,p_attribute12 in varchar2 default hr_api.g_varchar2
673: ,p_attribute13 in varchar2 default hr_api.g_varchar2
674: ,p_attribute14 in varchar2 default hr_api.g_varchar2
675: ,p_attribute15 in varchar2 default hr_api.g_varchar2
676: ,p_attribute16 in varchar2 default hr_api.g_varchar2
677: ,p_attribute17 in varchar2 default hr_api.g_varchar2
678: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 675: ,p_attribute15 in varchar2 default hr_api.g_varchar2

671: ,p_attribute11 in varchar2 default hr_api.g_varchar2
672: ,p_attribute12 in varchar2 default hr_api.g_varchar2
673: ,p_attribute13 in varchar2 default hr_api.g_varchar2
674: ,p_attribute14 in varchar2 default hr_api.g_varchar2
675: ,p_attribute15 in varchar2 default hr_api.g_varchar2
676: ,p_attribute16 in varchar2 default hr_api.g_varchar2
677: ,p_attribute17 in varchar2 default hr_api.g_varchar2
678: ,p_attribute18 in varchar2 default hr_api.g_varchar2
679: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 676: ,p_attribute16 in varchar2 default hr_api.g_varchar2

672: ,p_attribute12 in varchar2 default hr_api.g_varchar2
673: ,p_attribute13 in varchar2 default hr_api.g_varchar2
674: ,p_attribute14 in varchar2 default hr_api.g_varchar2
675: ,p_attribute15 in varchar2 default hr_api.g_varchar2
676: ,p_attribute16 in varchar2 default hr_api.g_varchar2
677: ,p_attribute17 in varchar2 default hr_api.g_varchar2
678: ,p_attribute18 in varchar2 default hr_api.g_varchar2
679: ,p_attribute19 in varchar2 default hr_api.g_varchar2
680: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 677: ,p_attribute17 in varchar2 default hr_api.g_varchar2

673: ,p_attribute13 in varchar2 default hr_api.g_varchar2
674: ,p_attribute14 in varchar2 default hr_api.g_varchar2
675: ,p_attribute15 in varchar2 default hr_api.g_varchar2
676: ,p_attribute16 in varchar2 default hr_api.g_varchar2
677: ,p_attribute17 in varchar2 default hr_api.g_varchar2
678: ,p_attribute18 in varchar2 default hr_api.g_varchar2
679: ,p_attribute19 in varchar2 default hr_api.g_varchar2
680: ,p_attribute20 in varchar2 default hr_api.g_varchar2
681: ,p_path_source_code in varchar2 default hr_api.g_varchar2

Line 678: ,p_attribute18 in varchar2 default hr_api.g_varchar2

674: ,p_attribute14 in varchar2 default hr_api.g_varchar2
675: ,p_attribute15 in varchar2 default hr_api.g_varchar2
676: ,p_attribute16 in varchar2 default hr_api.g_varchar2
677: ,p_attribute17 in varchar2 default hr_api.g_varchar2
678: ,p_attribute18 in varchar2 default hr_api.g_varchar2
679: ,p_attribute19 in varchar2 default hr_api.g_varchar2
680: ,p_attribute20 in varchar2 default hr_api.g_varchar2
681: ,p_path_source_code in varchar2 default hr_api.g_varchar2
682: ,p_source_function_code in varchar2 default hr_api.g_varchar2

Line 679: ,p_attribute19 in varchar2 default hr_api.g_varchar2

675: ,p_attribute15 in varchar2 default hr_api.g_varchar2
676: ,p_attribute16 in varchar2 default hr_api.g_varchar2
677: ,p_attribute17 in varchar2 default hr_api.g_varchar2
678: ,p_attribute18 in varchar2 default hr_api.g_varchar2
679: ,p_attribute19 in varchar2 default hr_api.g_varchar2
680: ,p_attribute20 in varchar2 default hr_api.g_varchar2
681: ,p_path_source_code in varchar2 default hr_api.g_varchar2
682: ,p_source_function_code in varchar2 default hr_api.g_varchar2
683: ,p_assignment_id in number default hr_api.g_number

Line 680: ,p_attribute20 in varchar2 default hr_api.g_varchar2

676: ,p_attribute16 in varchar2 default hr_api.g_varchar2
677: ,p_attribute17 in varchar2 default hr_api.g_varchar2
678: ,p_attribute18 in varchar2 default hr_api.g_varchar2
679: ,p_attribute19 in varchar2 default hr_api.g_varchar2
680: ,p_attribute20 in varchar2 default hr_api.g_varchar2
681: ,p_path_source_code in varchar2 default hr_api.g_varchar2
682: ,p_source_function_code in varchar2 default hr_api.g_varchar2
683: ,p_assignment_id in number default hr_api.g_number
684: ,p_source_id in number default hr_api.g_number

Line 681: ,p_path_source_code in varchar2 default hr_api.g_varchar2

677: ,p_attribute17 in varchar2 default hr_api.g_varchar2
678: ,p_attribute18 in varchar2 default hr_api.g_varchar2
679: ,p_attribute19 in varchar2 default hr_api.g_varchar2
680: ,p_attribute20 in varchar2 default hr_api.g_varchar2
681: ,p_path_source_code in varchar2 default hr_api.g_varchar2
682: ,p_source_function_code in varchar2 default hr_api.g_varchar2
683: ,p_assignment_id in number default hr_api.g_number
684: ,p_source_id in number default hr_api.g_number
685: ,p_notify_days_before_target in number default hr_api.g_number

Line 682: ,p_source_function_code in varchar2 default hr_api.g_varchar2

678: ,p_attribute18 in varchar2 default hr_api.g_varchar2
679: ,p_attribute19 in varchar2 default hr_api.g_varchar2
680: ,p_attribute20 in varchar2 default hr_api.g_varchar2
681: ,p_path_source_code in varchar2 default hr_api.g_varchar2
682: ,p_source_function_code in varchar2 default hr_api.g_varchar2
683: ,p_assignment_id in number default hr_api.g_number
684: ,p_source_id in number default hr_api.g_number
685: ,p_notify_days_before_target in number default hr_api.g_number
686: ,p_person_id in number default hr_api.g_number

Line 683: ,p_assignment_id in number default hr_api.g_number

679: ,p_attribute19 in varchar2 default hr_api.g_varchar2
680: ,p_attribute20 in varchar2 default hr_api.g_varchar2
681: ,p_path_source_code in varchar2 default hr_api.g_varchar2
682: ,p_source_function_code in varchar2 default hr_api.g_varchar2
683: ,p_assignment_id in number default hr_api.g_number
684: ,p_source_id in number default hr_api.g_number
685: ,p_notify_days_before_target in number default hr_api.g_number
686: ,p_person_id in number default hr_api.g_number
687: ,p_contact_id in number default hr_api.g_number

Line 684: ,p_source_id in number default hr_api.g_number

680: ,p_attribute20 in varchar2 default hr_api.g_varchar2
681: ,p_path_source_code in varchar2 default hr_api.g_varchar2
682: ,p_source_function_code in varchar2 default hr_api.g_varchar2
683: ,p_assignment_id in number default hr_api.g_number
684: ,p_source_id in number default hr_api.g_number
685: ,p_notify_days_before_target in number default hr_api.g_number
686: ,p_person_id in number default hr_api.g_number
687: ,p_contact_id in number default hr_api.g_number
688: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2

Line 685: ,p_notify_days_before_target in number default hr_api.g_number

681: ,p_path_source_code in varchar2 default hr_api.g_varchar2
682: ,p_source_function_code in varchar2 default hr_api.g_varchar2
683: ,p_assignment_id in number default hr_api.g_number
684: ,p_source_id in number default hr_api.g_number
685: ,p_notify_days_before_target in number default hr_api.g_number
686: ,p_person_id in number default hr_api.g_number
687: ,p_contact_id in number default hr_api.g_number
688: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
689: ,p_public_flag in varchar2 default hr_api.g_varchar2

Line 686: ,p_person_id in number default hr_api.g_number

682: ,p_source_function_code in varchar2 default hr_api.g_varchar2
683: ,p_assignment_id in number default hr_api.g_number
684: ,p_source_id in number default hr_api.g_number
685: ,p_notify_days_before_target in number default hr_api.g_number
686: ,p_person_id in number default hr_api.g_number
687: ,p_contact_id in number default hr_api.g_number
688: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
689: ,p_public_flag in varchar2 default hr_api.g_varchar2
690: ,p_competency_update_level in varchar2 default hr_api.g_varchar2

Line 687: ,p_contact_id in number default hr_api.g_number

683: ,p_assignment_id in number default hr_api.g_number
684: ,p_source_id in number default hr_api.g_number
685: ,p_notify_days_before_target in number default hr_api.g_number
686: ,p_person_id in number default hr_api.g_number
687: ,p_contact_id in number default hr_api.g_number
688: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
689: ,p_public_flag in varchar2 default hr_api.g_varchar2
690: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
691: ) is

Line 688: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2

684: ,p_source_id in number default hr_api.g_number
685: ,p_notify_days_before_target in number default hr_api.g_number
686: ,p_person_id in number default hr_api.g_number
687: ,p_contact_id in number default hr_api.g_number
688: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
689: ,p_public_flag in varchar2 default hr_api.g_varchar2
690: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
691: ) is
692: --

Line 689: ,p_public_flag in varchar2 default hr_api.g_varchar2

685: ,p_notify_days_before_target in number default hr_api.g_number
686: ,p_person_id in number default hr_api.g_number
687: ,p_contact_id in number default hr_api.g_number
688: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
689: ,p_public_flag in varchar2 default hr_api.g_varchar2
690: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
691: ) is
692: --
693: l_rec ota_lps_shd.g_rec_type;

Line 690: ,p_competency_update_level in varchar2 default hr_api.g_varchar2

686: ,p_person_id in number default hr_api.g_number
687: ,p_contact_id in number default hr_api.g_number
688: ,p_display_to_learner_flag in varchar2 default hr_api.g_varchar2
689: ,p_public_flag in varchar2 default hr_api.g_varchar2
690: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
691: ) is
692: --
693: l_rec ota_lps_shd.g_rec_type;
694: l_proc varchar2(72) := g_package||'upd';