126: --
127: hr_utility.set_location(' Leaving:'||l_proc, 10);
128: --
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: --
133: ota_off_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: --
133: ota_off_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: --
138: ota_off_shd.constraint_error
131: -- A check constraint has been violated
132: --
133: ota_off_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: --
138: ota_off_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: --
138: ota_off_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: --
143: ota_off_shd.constraint_error
136: -- Parent integrity has been violated
137: --
138: ota_off_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: --
143: ota_off_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: --
143: ota_off_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: --
147: Raise;
148: End update_dml;
434: null;
435: --
436: exception
437: --
438: when hr_api.cannot_find_prog_unit then
439: --
440: hr_api.cannot_find_prog_unit_error
441: (p_module_name => 'OTA_OFFERINGS'
442: ,p_hook_type => 'AU');
436: exception
437: --
438: when hr_api.cannot_find_prog_unit then
439: --
440: hr_api.cannot_find_prog_unit_error
441: (p_module_name => 'OTA_OFFERINGS'
442: ,p_hook_type => 'AU');
443: --
444: end;
499: -- p_rec plsql record structure
500: -- to see if a system default is being used. If a system default
501: -- is being used then we must set to the 'current' argument value.
502: --
503: If (p_rec.activity_version_id = hr_api.g_number) then
504: p_rec.activity_version_id :=
505: ota_off_shd.g_old_rec.activity_version_id;
506: End If;
507: If (p_rec.business_group_id = hr_api.g_number) then
503: If (p_rec.activity_version_id = hr_api.g_number) then
504: p_rec.activity_version_id :=
505: ota_off_shd.g_old_rec.activity_version_id;
506: End If;
507: If (p_rec.business_group_id = hr_api.g_number) then
508: p_rec.business_group_id :=
509: ota_off_shd.g_old_rec.business_group_id;
510: End If;
511: If (p_rec.start_date = hr_api.g_date) then
507: If (p_rec.business_group_id = hr_api.g_number) then
508: p_rec.business_group_id :=
509: ota_off_shd.g_old_rec.business_group_id;
510: End If;
511: If (p_rec.start_date = hr_api.g_date) then
512: p_rec.start_date :=
513: ota_off_shd.g_old_rec.start_date;
514: End If;
515: If (p_rec.end_date = hr_api.g_date) then
511: If (p_rec.start_date = hr_api.g_date) then
512: p_rec.start_date :=
513: ota_off_shd.g_old_rec.start_date;
514: End If;
515: If (p_rec.end_date = hr_api.g_date) then
516: p_rec.end_date :=
517: ota_off_shd.g_old_rec.end_date;
518: End If;
519: If (p_rec.owner_id = hr_api.g_number) then
515: If (p_rec.end_date = hr_api.g_date) then
516: p_rec.end_date :=
517: ota_off_shd.g_old_rec.end_date;
518: End If;
519: If (p_rec.owner_id = hr_api.g_number) then
520: p_rec.owner_id :=
521: ota_off_shd.g_old_rec.owner_id;
522: End If;
523: If (p_rec.delivery_mode_id = hr_api.g_number) then
519: If (p_rec.owner_id = hr_api.g_number) then
520: p_rec.owner_id :=
521: ota_off_shd.g_old_rec.owner_id;
522: End If;
523: If (p_rec.delivery_mode_id = hr_api.g_number) then
524: p_rec.delivery_mode_id :=
525: ota_off_shd.g_old_rec.delivery_mode_id;
526: End If;
527: If (p_rec.language_id = hr_api.g_number) then
523: If (p_rec.delivery_mode_id = hr_api.g_number) then
524: p_rec.delivery_mode_id :=
525: ota_off_shd.g_old_rec.delivery_mode_id;
526: End If;
527: If (p_rec.language_id = hr_api.g_number) then
528: p_rec.language_id :=
529: ota_off_shd.g_old_rec.language_id;
530: End If;
531: If (p_rec.duration = hr_api.g_number) then
527: If (p_rec.language_id = hr_api.g_number) then
528: p_rec.language_id :=
529: ota_off_shd.g_old_rec.language_id;
530: End If;
531: If (p_rec.duration = hr_api.g_number) then
532: p_rec.duration :=
533: ota_off_shd.g_old_rec.duration;
534: End If;
535: If (p_rec.duration_units = hr_api.g_varchar2) then
531: If (p_rec.duration = hr_api.g_number) then
532: p_rec.duration :=
533: ota_off_shd.g_old_rec.duration;
534: End If;
535: If (p_rec.duration_units = hr_api.g_varchar2) then
536: p_rec.duration_units :=
537: ota_off_shd.g_old_rec.duration_units;
538: End If;
539: If (p_rec.learning_object_id = hr_api.g_number) then
535: If (p_rec.duration_units = hr_api.g_varchar2) then
536: p_rec.duration_units :=
537: ota_off_shd.g_old_rec.duration_units;
538: End If;
539: If (p_rec.learning_object_id = hr_api.g_number) then
540: p_rec.learning_object_id :=
541: ota_off_shd.g_old_rec.learning_object_id;
542: End If;
543: If (p_rec.player_toolbar_flag = hr_api.g_varchar2) then
539: If (p_rec.learning_object_id = hr_api.g_number) then
540: p_rec.learning_object_id :=
541: ota_off_shd.g_old_rec.learning_object_id;
542: End If;
543: If (p_rec.player_toolbar_flag = hr_api.g_varchar2) then
544: p_rec.player_toolbar_flag :=
545: ota_off_shd.g_old_rec.player_toolbar_flag;
546: End If;
547: If (p_rec.player_toolbar_bitset = hr_api.g_number) then
543: If (p_rec.player_toolbar_flag = hr_api.g_varchar2) then
544: p_rec.player_toolbar_flag :=
545: ota_off_shd.g_old_rec.player_toolbar_flag;
546: End If;
547: If (p_rec.player_toolbar_bitset = hr_api.g_number) then
548: p_rec.player_toolbar_bitset :=
549: ota_off_shd.g_old_rec.player_toolbar_bitset;
550: End If;
551: If (p_rec.player_new_window_flag = hr_api.g_varchar2) then
547: If (p_rec.player_toolbar_bitset = hr_api.g_number) then
548: p_rec.player_toolbar_bitset :=
549: ota_off_shd.g_old_rec.player_toolbar_bitset;
550: End If;
551: If (p_rec.player_new_window_flag = hr_api.g_varchar2) then
552: p_rec.player_new_window_flag :=
553: ota_off_shd.g_old_rec.player_new_window_flag;
554: End If;
555: If (p_rec.maximum_attendees = hr_api.g_number) then
551: If (p_rec.player_new_window_flag = hr_api.g_varchar2) then
552: p_rec.player_new_window_flag :=
553: ota_off_shd.g_old_rec.player_new_window_flag;
554: End If;
555: If (p_rec.maximum_attendees = hr_api.g_number) then
556: p_rec.maximum_attendees :=
557: ota_off_shd.g_old_rec.maximum_attendees;
558: End If;
559: If (p_rec.maximum_internal_attendees = hr_api.g_number) then
555: If (p_rec.maximum_attendees = hr_api.g_number) then
556: p_rec.maximum_attendees :=
557: ota_off_shd.g_old_rec.maximum_attendees;
558: End If;
559: If (p_rec.maximum_internal_attendees = hr_api.g_number) then
560: p_rec.maximum_internal_attendees :=
561: ota_off_shd.g_old_rec.maximum_internal_attendees;
562: End If;
563: If (p_rec.minimum_attendees = hr_api.g_number) then
559: If (p_rec.maximum_internal_attendees = hr_api.g_number) then
560: p_rec.maximum_internal_attendees :=
561: ota_off_shd.g_old_rec.maximum_internal_attendees;
562: End If;
563: If (p_rec.minimum_attendees = hr_api.g_number) then
564: p_rec.minimum_attendees :=
565: ota_off_shd.g_old_rec.minimum_attendees;
566: End If;
567: If (p_rec.actual_cost = hr_api.g_number) then
563: If (p_rec.minimum_attendees = hr_api.g_number) then
564: p_rec.minimum_attendees :=
565: ota_off_shd.g_old_rec.minimum_attendees;
566: End If;
567: If (p_rec.actual_cost = hr_api.g_number) then
568: p_rec.actual_cost :=
569: ota_off_shd.g_old_rec.actual_cost;
570: End If;
571: If (p_rec.budget_cost = hr_api.g_number) then
567: If (p_rec.actual_cost = hr_api.g_number) then
568: p_rec.actual_cost :=
569: ota_off_shd.g_old_rec.actual_cost;
570: End If;
571: If (p_rec.budget_cost = hr_api.g_number) then
572: p_rec.budget_cost :=
573: ota_off_shd.g_old_rec.budget_cost;
574: End If;
575: If (p_rec.budget_currency_code = hr_api.g_varchar2) then
571: If (p_rec.budget_cost = hr_api.g_number) then
572: p_rec.budget_cost :=
573: ota_off_shd.g_old_rec.budget_cost;
574: End If;
575: If (p_rec.budget_currency_code = hr_api.g_varchar2) then
576: p_rec.budget_currency_code :=
577: ota_off_shd.g_old_rec.budget_currency_code;
578: End If;
579: If (p_rec.price_basis = hr_api.g_varchar2) then
575: If (p_rec.budget_currency_code = hr_api.g_varchar2) then
576: p_rec.budget_currency_code :=
577: ota_off_shd.g_old_rec.budget_currency_code;
578: End If;
579: If (p_rec.price_basis = hr_api.g_varchar2) then
580: p_rec.price_basis :=
581: ota_off_shd.g_old_rec.price_basis;
582: End If;
583: If (p_rec.currency_code = hr_api.g_varchar2) then
579: If (p_rec.price_basis = hr_api.g_varchar2) then
580: p_rec.price_basis :=
581: ota_off_shd.g_old_rec.price_basis;
582: End If;
583: If (p_rec.currency_code = hr_api.g_varchar2) then
584: p_rec.currency_code :=
585: ota_off_shd.g_old_rec.currency_code;
586: End If;
587: If (p_rec.standard_price = hr_api.g_number) then
583: If (p_rec.currency_code = hr_api.g_varchar2) then
584: p_rec.currency_code :=
585: ota_off_shd.g_old_rec.currency_code;
586: End If;
587: If (p_rec.standard_price = hr_api.g_number) then
588: p_rec.standard_price :=
589: ota_off_shd.g_old_rec.standard_price;
590: End If;
591: If (p_rec.attribute_category = hr_api.g_varchar2) then
587: If (p_rec.standard_price = hr_api.g_number) then
588: p_rec.standard_price :=
589: ota_off_shd.g_old_rec.standard_price;
590: End If;
591: If (p_rec.attribute_category = hr_api.g_varchar2) then
592: p_rec.attribute_category :=
593: ota_off_shd.g_old_rec.attribute_category;
594: End If;
595: If (p_rec.attribute1 = hr_api.g_varchar2) then
591: If (p_rec.attribute_category = hr_api.g_varchar2) then
592: p_rec.attribute_category :=
593: ota_off_shd.g_old_rec.attribute_category;
594: End If;
595: If (p_rec.attribute1 = hr_api.g_varchar2) then
596: p_rec.attribute1 :=
597: ota_off_shd.g_old_rec.attribute1;
598: End If;
599: If (p_rec.attribute2 = hr_api.g_varchar2) then
595: If (p_rec.attribute1 = hr_api.g_varchar2) then
596: p_rec.attribute1 :=
597: ota_off_shd.g_old_rec.attribute1;
598: End If;
599: If (p_rec.attribute2 = hr_api.g_varchar2) then
600: p_rec.attribute2 :=
601: ota_off_shd.g_old_rec.attribute2;
602: End If;
603: If (p_rec.attribute3 = hr_api.g_varchar2) then
599: If (p_rec.attribute2 = hr_api.g_varchar2) then
600: p_rec.attribute2 :=
601: ota_off_shd.g_old_rec.attribute2;
602: End If;
603: If (p_rec.attribute3 = hr_api.g_varchar2) then
604: p_rec.attribute3 :=
605: ota_off_shd.g_old_rec.attribute3;
606: End If;
607: If (p_rec.attribute4 = hr_api.g_varchar2) then
603: If (p_rec.attribute3 = hr_api.g_varchar2) then
604: p_rec.attribute3 :=
605: ota_off_shd.g_old_rec.attribute3;
606: End If;
607: If (p_rec.attribute4 = hr_api.g_varchar2) then
608: p_rec.attribute4 :=
609: ota_off_shd.g_old_rec.attribute4;
610: End If;
611: If (p_rec.attribute5 = hr_api.g_varchar2) then
607: If (p_rec.attribute4 = hr_api.g_varchar2) then
608: p_rec.attribute4 :=
609: ota_off_shd.g_old_rec.attribute4;
610: End If;
611: If (p_rec.attribute5 = hr_api.g_varchar2) then
612: p_rec.attribute5 :=
613: ota_off_shd.g_old_rec.attribute5;
614: End If;
615: If (p_rec.attribute6 = hr_api.g_varchar2) then
611: If (p_rec.attribute5 = hr_api.g_varchar2) then
612: p_rec.attribute5 :=
613: ota_off_shd.g_old_rec.attribute5;
614: End If;
615: If (p_rec.attribute6 = hr_api.g_varchar2) then
616: p_rec.attribute6 :=
617: ota_off_shd.g_old_rec.attribute6;
618: End If;
619: If (p_rec.attribute7 = hr_api.g_varchar2) then
615: If (p_rec.attribute6 = hr_api.g_varchar2) then
616: p_rec.attribute6 :=
617: ota_off_shd.g_old_rec.attribute6;
618: End If;
619: If (p_rec.attribute7 = hr_api.g_varchar2) then
620: p_rec.attribute7 :=
621: ota_off_shd.g_old_rec.attribute7;
622: End If;
623: If (p_rec.attribute8 = hr_api.g_varchar2) then
619: If (p_rec.attribute7 = hr_api.g_varchar2) then
620: p_rec.attribute7 :=
621: ota_off_shd.g_old_rec.attribute7;
622: End If;
623: If (p_rec.attribute8 = hr_api.g_varchar2) then
624: p_rec.attribute8 :=
625: ota_off_shd.g_old_rec.attribute8;
626: End If;
627: If (p_rec.attribute9 = hr_api.g_varchar2) then
623: If (p_rec.attribute8 = hr_api.g_varchar2) then
624: p_rec.attribute8 :=
625: ota_off_shd.g_old_rec.attribute8;
626: End If;
627: If (p_rec.attribute9 = hr_api.g_varchar2) then
628: p_rec.attribute9 :=
629: ota_off_shd.g_old_rec.attribute9;
630: End If;
631: If (p_rec.attribute10 = hr_api.g_varchar2) then
627: If (p_rec.attribute9 = hr_api.g_varchar2) then
628: p_rec.attribute9 :=
629: ota_off_shd.g_old_rec.attribute9;
630: End If;
631: If (p_rec.attribute10 = hr_api.g_varchar2) then
632: p_rec.attribute10 :=
633: ota_off_shd.g_old_rec.attribute10;
634: End If;
635: If (p_rec.attribute11 = hr_api.g_varchar2) then
631: If (p_rec.attribute10 = hr_api.g_varchar2) then
632: p_rec.attribute10 :=
633: ota_off_shd.g_old_rec.attribute10;
634: End If;
635: If (p_rec.attribute11 = hr_api.g_varchar2) then
636: p_rec.attribute11 :=
637: ota_off_shd.g_old_rec.attribute11;
638: End If;
639: If (p_rec.attribute12 = hr_api.g_varchar2) then
635: If (p_rec.attribute11 = hr_api.g_varchar2) then
636: p_rec.attribute11 :=
637: ota_off_shd.g_old_rec.attribute11;
638: End If;
639: If (p_rec.attribute12 = hr_api.g_varchar2) then
640: p_rec.attribute12 :=
641: ota_off_shd.g_old_rec.attribute12;
642: End If;
643: If (p_rec.attribute13 = hr_api.g_varchar2) then
639: If (p_rec.attribute12 = hr_api.g_varchar2) then
640: p_rec.attribute12 :=
641: ota_off_shd.g_old_rec.attribute12;
642: End If;
643: If (p_rec.attribute13 = hr_api.g_varchar2) then
644: p_rec.attribute13 :=
645: ota_off_shd.g_old_rec.attribute13;
646: End If;
647: If (p_rec.attribute14 = hr_api.g_varchar2) then
643: If (p_rec.attribute13 = hr_api.g_varchar2) then
644: p_rec.attribute13 :=
645: ota_off_shd.g_old_rec.attribute13;
646: End If;
647: If (p_rec.attribute14 = hr_api.g_varchar2) then
648: p_rec.attribute14 :=
649: ota_off_shd.g_old_rec.attribute14;
650: End If;
651: If (p_rec.attribute15 = hr_api.g_varchar2) then
647: If (p_rec.attribute14 = hr_api.g_varchar2) then
648: p_rec.attribute14 :=
649: ota_off_shd.g_old_rec.attribute14;
650: End If;
651: If (p_rec.attribute15 = hr_api.g_varchar2) then
652: p_rec.attribute15 :=
653: ota_off_shd.g_old_rec.attribute15;
654: End If;
655: If (p_rec.attribute16 = hr_api.g_varchar2) then
651: If (p_rec.attribute15 = hr_api.g_varchar2) then
652: p_rec.attribute15 :=
653: ota_off_shd.g_old_rec.attribute15;
654: End If;
655: If (p_rec.attribute16 = hr_api.g_varchar2) then
656: p_rec.attribute16 :=
657: ota_off_shd.g_old_rec.attribute16;
658: End If;
659: If (p_rec.attribute17 = hr_api.g_varchar2) then
655: If (p_rec.attribute16 = hr_api.g_varchar2) then
656: p_rec.attribute16 :=
657: ota_off_shd.g_old_rec.attribute16;
658: End If;
659: If (p_rec.attribute17 = hr_api.g_varchar2) then
660: p_rec.attribute17 :=
661: ota_off_shd.g_old_rec.attribute17;
662: End If;
663: If (p_rec.attribute18 = hr_api.g_varchar2) then
659: If (p_rec.attribute17 = hr_api.g_varchar2) then
660: p_rec.attribute17 :=
661: ota_off_shd.g_old_rec.attribute17;
662: End If;
663: If (p_rec.attribute18 = hr_api.g_varchar2) then
664: p_rec.attribute18 :=
665: ota_off_shd.g_old_rec.attribute18;
666: End If;
667: If (p_rec.attribute19 = hr_api.g_varchar2) then
663: If (p_rec.attribute18 = hr_api.g_varchar2) then
664: p_rec.attribute18 :=
665: ota_off_shd.g_old_rec.attribute18;
666: End If;
667: If (p_rec.attribute19 = hr_api.g_varchar2) then
668: p_rec.attribute19 :=
669: ota_off_shd.g_old_rec.attribute19;
670: End If;
671: If (p_rec.attribute20 = hr_api.g_varchar2) then
667: If (p_rec.attribute19 = hr_api.g_varchar2) then
668: p_rec.attribute19 :=
669: ota_off_shd.g_old_rec.attribute19;
670: End If;
671: If (p_rec.attribute20 = hr_api.g_varchar2) then
672: p_rec.attribute20 :=
673: ota_off_shd.g_old_rec.attribute20;
674: End If;
675: If (p_rec.data_source = hr_api.g_varchar2) then
671: If (p_rec.attribute20 = hr_api.g_varchar2) then
672: p_rec.attribute20 :=
673: ota_off_shd.g_old_rec.attribute20;
674: End If;
675: If (p_rec.data_source = hr_api.g_varchar2) then
676: p_rec.data_source :=
677: ota_off_shd.g_old_rec.data_source;
678: End If;
679: If (p_rec.vendor_id = hr_api.g_number) then
675: If (p_rec.data_source = hr_api.g_varchar2) then
676: p_rec.data_source :=
677: ota_off_shd.g_old_rec.data_source;
678: End If;
679: If (p_rec.vendor_id = hr_api.g_number) then
680: p_rec.vendor_id :=
681: ota_off_shd.g_old_rec.vendor_id;
682: End If;
683: If (p_rec.competency_update_level = hr_api.g_varchar2) then
679: If (p_rec.vendor_id = hr_api.g_number) then
680: p_rec.vendor_id :=
681: ota_off_shd.g_old_rec.vendor_id;
682: End If;
683: If (p_rec.competency_update_level = hr_api.g_varchar2) then
684: p_rec.competency_update_level :=
685: ota_off_shd.g_old_rec.competency_update_level;
686: End If;
687: If (p_rec.language_code = hr_api.g_varchar2) then -- 2733966
683: If (p_rec.competency_update_level = hr_api.g_varchar2) then
684: p_rec.competency_update_level :=
685: ota_off_shd.g_old_rec.competency_update_level;
686: End If;
687: If (p_rec.language_code = hr_api.g_varchar2) then -- 2733966
688: p_rec.language_code :=
689: ota_off_shd.g_old_rec.language_code;
690: End If;
691: --
753: Procedure upd
754: (p_effective_date in date
755: ,p_offering_id in number
756: ,p_object_version_number in out nocopy number
757: ,p_business_group_id in number default hr_api.g_number
758: ,p_name in varchar2 default hr_api.g_varchar2
759: ,p_start_date in date default hr_api.g_date
760: ,p_activity_version_id in number default hr_api.g_number
761: ,p_end_date in date default hr_api.g_date
754: (p_effective_date in date
755: ,p_offering_id in number
756: ,p_object_version_number in out nocopy number
757: ,p_business_group_id in number default hr_api.g_number
758: ,p_name in varchar2 default hr_api.g_varchar2
759: ,p_start_date in date default hr_api.g_date
760: ,p_activity_version_id in number default hr_api.g_number
761: ,p_end_date in date default hr_api.g_date
762: ,p_owner_id in number default hr_api.g_number
755: ,p_offering_id in number
756: ,p_object_version_number in out nocopy number
757: ,p_business_group_id in number default hr_api.g_number
758: ,p_name in varchar2 default hr_api.g_varchar2
759: ,p_start_date in date default hr_api.g_date
760: ,p_activity_version_id in number default hr_api.g_number
761: ,p_end_date in date default hr_api.g_date
762: ,p_owner_id in number default hr_api.g_number
763: ,p_delivery_mode_id in number default hr_api.g_number
756: ,p_object_version_number in out nocopy number
757: ,p_business_group_id in number default hr_api.g_number
758: ,p_name in varchar2 default hr_api.g_varchar2
759: ,p_start_date in date default hr_api.g_date
760: ,p_activity_version_id in number default hr_api.g_number
761: ,p_end_date in date default hr_api.g_date
762: ,p_owner_id in number default hr_api.g_number
763: ,p_delivery_mode_id in number default hr_api.g_number
764: ,p_language_id in number default hr_api.g_number
757: ,p_business_group_id in number default hr_api.g_number
758: ,p_name in varchar2 default hr_api.g_varchar2
759: ,p_start_date in date default hr_api.g_date
760: ,p_activity_version_id in number default hr_api.g_number
761: ,p_end_date in date default hr_api.g_date
762: ,p_owner_id in number default hr_api.g_number
763: ,p_delivery_mode_id in number default hr_api.g_number
764: ,p_language_id in number default hr_api.g_number
765: ,p_duration in number default hr_api.g_number
758: ,p_name in varchar2 default hr_api.g_varchar2
759: ,p_start_date in date default hr_api.g_date
760: ,p_activity_version_id in number default hr_api.g_number
761: ,p_end_date in date default hr_api.g_date
762: ,p_owner_id in number default hr_api.g_number
763: ,p_delivery_mode_id in number default hr_api.g_number
764: ,p_language_id in number default hr_api.g_number
765: ,p_duration in number default hr_api.g_number
766: ,p_duration_units in varchar2 default hr_api.g_varchar2
759: ,p_start_date in date default hr_api.g_date
760: ,p_activity_version_id in number default hr_api.g_number
761: ,p_end_date in date default hr_api.g_date
762: ,p_owner_id in number default hr_api.g_number
763: ,p_delivery_mode_id in number default hr_api.g_number
764: ,p_language_id in number default hr_api.g_number
765: ,p_duration in number default hr_api.g_number
766: ,p_duration_units in varchar2 default hr_api.g_varchar2
767: ,p_learning_object_id in number default hr_api.g_number
760: ,p_activity_version_id in number default hr_api.g_number
761: ,p_end_date in date default hr_api.g_date
762: ,p_owner_id in number default hr_api.g_number
763: ,p_delivery_mode_id in number default hr_api.g_number
764: ,p_language_id in number default hr_api.g_number
765: ,p_duration in number default hr_api.g_number
766: ,p_duration_units in varchar2 default hr_api.g_varchar2
767: ,p_learning_object_id in number default hr_api.g_number
768: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
761: ,p_end_date in date default hr_api.g_date
762: ,p_owner_id in number default hr_api.g_number
763: ,p_delivery_mode_id in number default hr_api.g_number
764: ,p_language_id in number default hr_api.g_number
765: ,p_duration in number default hr_api.g_number
766: ,p_duration_units in varchar2 default hr_api.g_varchar2
767: ,p_learning_object_id in number default hr_api.g_number
768: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
769: ,p_player_toolbar_bitset in number default hr_api.g_number
762: ,p_owner_id in number default hr_api.g_number
763: ,p_delivery_mode_id in number default hr_api.g_number
764: ,p_language_id in number default hr_api.g_number
765: ,p_duration in number default hr_api.g_number
766: ,p_duration_units in varchar2 default hr_api.g_varchar2
767: ,p_learning_object_id in number default hr_api.g_number
768: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
769: ,p_player_toolbar_bitset in number default hr_api.g_number
770: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
763: ,p_delivery_mode_id in number default hr_api.g_number
764: ,p_language_id in number default hr_api.g_number
765: ,p_duration in number default hr_api.g_number
766: ,p_duration_units in varchar2 default hr_api.g_varchar2
767: ,p_learning_object_id in number default hr_api.g_number
768: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
769: ,p_player_toolbar_bitset in number default hr_api.g_number
770: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
771: ,p_maximum_attendees in number default hr_api.g_number
764: ,p_language_id in number default hr_api.g_number
765: ,p_duration in number default hr_api.g_number
766: ,p_duration_units in varchar2 default hr_api.g_varchar2
767: ,p_learning_object_id in number default hr_api.g_number
768: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
769: ,p_player_toolbar_bitset in number default hr_api.g_number
770: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
771: ,p_maximum_attendees in number default hr_api.g_number
772: ,p_maximum_internal_attendees in number default hr_api.g_number
765: ,p_duration in number default hr_api.g_number
766: ,p_duration_units in varchar2 default hr_api.g_varchar2
767: ,p_learning_object_id in number default hr_api.g_number
768: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
769: ,p_player_toolbar_bitset in number default hr_api.g_number
770: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
771: ,p_maximum_attendees in number default hr_api.g_number
772: ,p_maximum_internal_attendees in number default hr_api.g_number
773: ,p_minimum_attendees in number default hr_api.g_number
766: ,p_duration_units in varchar2 default hr_api.g_varchar2
767: ,p_learning_object_id in number default hr_api.g_number
768: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
769: ,p_player_toolbar_bitset in number default hr_api.g_number
770: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
771: ,p_maximum_attendees in number default hr_api.g_number
772: ,p_maximum_internal_attendees in number default hr_api.g_number
773: ,p_minimum_attendees in number default hr_api.g_number
774: ,p_actual_cost in number default hr_api.g_number
767: ,p_learning_object_id in number default hr_api.g_number
768: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
769: ,p_player_toolbar_bitset in number default hr_api.g_number
770: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
771: ,p_maximum_attendees in number default hr_api.g_number
772: ,p_maximum_internal_attendees in number default hr_api.g_number
773: ,p_minimum_attendees in number default hr_api.g_number
774: ,p_actual_cost in number default hr_api.g_number
775: ,p_budget_cost in number default hr_api.g_number
768: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
769: ,p_player_toolbar_bitset in number default hr_api.g_number
770: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
771: ,p_maximum_attendees in number default hr_api.g_number
772: ,p_maximum_internal_attendees in number default hr_api.g_number
773: ,p_minimum_attendees in number default hr_api.g_number
774: ,p_actual_cost in number default hr_api.g_number
775: ,p_budget_cost in number default hr_api.g_number
776: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
769: ,p_player_toolbar_bitset in number default hr_api.g_number
770: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
771: ,p_maximum_attendees in number default hr_api.g_number
772: ,p_maximum_internal_attendees in number default hr_api.g_number
773: ,p_minimum_attendees in number default hr_api.g_number
774: ,p_actual_cost in number default hr_api.g_number
775: ,p_budget_cost in number default hr_api.g_number
776: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
777: ,p_price_basis in varchar2 default hr_api.g_varchar2
770: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
771: ,p_maximum_attendees in number default hr_api.g_number
772: ,p_maximum_internal_attendees in number default hr_api.g_number
773: ,p_minimum_attendees in number default hr_api.g_number
774: ,p_actual_cost in number default hr_api.g_number
775: ,p_budget_cost in number default hr_api.g_number
776: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
777: ,p_price_basis in varchar2 default hr_api.g_varchar2
778: ,p_currency_code in varchar2 default hr_api.g_varchar2
771: ,p_maximum_attendees in number default hr_api.g_number
772: ,p_maximum_internal_attendees in number default hr_api.g_number
773: ,p_minimum_attendees in number default hr_api.g_number
774: ,p_actual_cost in number default hr_api.g_number
775: ,p_budget_cost in number default hr_api.g_number
776: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
777: ,p_price_basis in varchar2 default hr_api.g_varchar2
778: ,p_currency_code in varchar2 default hr_api.g_varchar2
779: ,p_standard_price in number default hr_api.g_number
772: ,p_maximum_internal_attendees in number default hr_api.g_number
773: ,p_minimum_attendees in number default hr_api.g_number
774: ,p_actual_cost in number default hr_api.g_number
775: ,p_budget_cost in number default hr_api.g_number
776: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
777: ,p_price_basis in varchar2 default hr_api.g_varchar2
778: ,p_currency_code in varchar2 default hr_api.g_varchar2
779: ,p_standard_price in number default hr_api.g_number
780: ,p_attribute_category in varchar2 default hr_api.g_varchar2
773: ,p_minimum_attendees in number default hr_api.g_number
774: ,p_actual_cost in number default hr_api.g_number
775: ,p_budget_cost in number default hr_api.g_number
776: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
777: ,p_price_basis in varchar2 default hr_api.g_varchar2
778: ,p_currency_code in varchar2 default hr_api.g_varchar2
779: ,p_standard_price in number default hr_api.g_number
780: ,p_attribute_category in varchar2 default hr_api.g_varchar2
781: ,p_attribute1 in varchar2 default hr_api.g_varchar2
774: ,p_actual_cost in number default hr_api.g_number
775: ,p_budget_cost in number default hr_api.g_number
776: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
777: ,p_price_basis in varchar2 default hr_api.g_varchar2
778: ,p_currency_code in varchar2 default hr_api.g_varchar2
779: ,p_standard_price in number default hr_api.g_number
780: ,p_attribute_category in varchar2 default hr_api.g_varchar2
781: ,p_attribute1 in varchar2 default hr_api.g_varchar2
782: ,p_attribute2 in varchar2 default hr_api.g_varchar2
775: ,p_budget_cost in number default hr_api.g_number
776: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
777: ,p_price_basis in varchar2 default hr_api.g_varchar2
778: ,p_currency_code in varchar2 default hr_api.g_varchar2
779: ,p_standard_price in number default hr_api.g_number
780: ,p_attribute_category in varchar2 default hr_api.g_varchar2
781: ,p_attribute1 in varchar2 default hr_api.g_varchar2
782: ,p_attribute2 in varchar2 default hr_api.g_varchar2
783: ,p_attribute3 in varchar2 default hr_api.g_varchar2
776: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
777: ,p_price_basis in varchar2 default hr_api.g_varchar2
778: ,p_currency_code in varchar2 default hr_api.g_varchar2
779: ,p_standard_price in number default hr_api.g_number
780: ,p_attribute_category in varchar2 default hr_api.g_varchar2
781: ,p_attribute1 in varchar2 default hr_api.g_varchar2
782: ,p_attribute2 in varchar2 default hr_api.g_varchar2
783: ,p_attribute3 in varchar2 default hr_api.g_varchar2
784: ,p_attribute4 in varchar2 default hr_api.g_varchar2
777: ,p_price_basis in varchar2 default hr_api.g_varchar2
778: ,p_currency_code in varchar2 default hr_api.g_varchar2
779: ,p_standard_price in number default hr_api.g_number
780: ,p_attribute_category in varchar2 default hr_api.g_varchar2
781: ,p_attribute1 in varchar2 default hr_api.g_varchar2
782: ,p_attribute2 in varchar2 default hr_api.g_varchar2
783: ,p_attribute3 in varchar2 default hr_api.g_varchar2
784: ,p_attribute4 in varchar2 default hr_api.g_varchar2
785: ,p_attribute5 in varchar2 default hr_api.g_varchar2
778: ,p_currency_code in varchar2 default hr_api.g_varchar2
779: ,p_standard_price in number default hr_api.g_number
780: ,p_attribute_category in varchar2 default hr_api.g_varchar2
781: ,p_attribute1 in varchar2 default hr_api.g_varchar2
782: ,p_attribute2 in varchar2 default hr_api.g_varchar2
783: ,p_attribute3 in varchar2 default hr_api.g_varchar2
784: ,p_attribute4 in varchar2 default hr_api.g_varchar2
785: ,p_attribute5 in varchar2 default hr_api.g_varchar2
786: ,p_attribute6 in varchar2 default hr_api.g_varchar2
779: ,p_standard_price in number default hr_api.g_number
780: ,p_attribute_category in varchar2 default hr_api.g_varchar2
781: ,p_attribute1 in varchar2 default hr_api.g_varchar2
782: ,p_attribute2 in varchar2 default hr_api.g_varchar2
783: ,p_attribute3 in varchar2 default hr_api.g_varchar2
784: ,p_attribute4 in varchar2 default hr_api.g_varchar2
785: ,p_attribute5 in varchar2 default hr_api.g_varchar2
786: ,p_attribute6 in varchar2 default hr_api.g_varchar2
787: ,p_attribute7 in varchar2 default hr_api.g_varchar2
780: ,p_attribute_category in varchar2 default hr_api.g_varchar2
781: ,p_attribute1 in varchar2 default hr_api.g_varchar2
782: ,p_attribute2 in varchar2 default hr_api.g_varchar2
783: ,p_attribute3 in varchar2 default hr_api.g_varchar2
784: ,p_attribute4 in varchar2 default hr_api.g_varchar2
785: ,p_attribute5 in varchar2 default hr_api.g_varchar2
786: ,p_attribute6 in varchar2 default hr_api.g_varchar2
787: ,p_attribute7 in varchar2 default hr_api.g_varchar2
788: ,p_attribute8 in varchar2 default hr_api.g_varchar2
781: ,p_attribute1 in varchar2 default hr_api.g_varchar2
782: ,p_attribute2 in varchar2 default hr_api.g_varchar2
783: ,p_attribute3 in varchar2 default hr_api.g_varchar2
784: ,p_attribute4 in varchar2 default hr_api.g_varchar2
785: ,p_attribute5 in varchar2 default hr_api.g_varchar2
786: ,p_attribute6 in varchar2 default hr_api.g_varchar2
787: ,p_attribute7 in varchar2 default hr_api.g_varchar2
788: ,p_attribute8 in varchar2 default hr_api.g_varchar2
789: ,p_attribute9 in varchar2 default hr_api.g_varchar2
782: ,p_attribute2 in varchar2 default hr_api.g_varchar2
783: ,p_attribute3 in varchar2 default hr_api.g_varchar2
784: ,p_attribute4 in varchar2 default hr_api.g_varchar2
785: ,p_attribute5 in varchar2 default hr_api.g_varchar2
786: ,p_attribute6 in varchar2 default hr_api.g_varchar2
787: ,p_attribute7 in varchar2 default hr_api.g_varchar2
788: ,p_attribute8 in varchar2 default hr_api.g_varchar2
789: ,p_attribute9 in varchar2 default hr_api.g_varchar2
790: ,p_attribute10 in varchar2 default hr_api.g_varchar2
783: ,p_attribute3 in varchar2 default hr_api.g_varchar2
784: ,p_attribute4 in varchar2 default hr_api.g_varchar2
785: ,p_attribute5 in varchar2 default hr_api.g_varchar2
786: ,p_attribute6 in varchar2 default hr_api.g_varchar2
787: ,p_attribute7 in varchar2 default hr_api.g_varchar2
788: ,p_attribute8 in varchar2 default hr_api.g_varchar2
789: ,p_attribute9 in varchar2 default hr_api.g_varchar2
790: ,p_attribute10 in varchar2 default hr_api.g_varchar2
791: ,p_attribute11 in varchar2 default hr_api.g_varchar2
784: ,p_attribute4 in varchar2 default hr_api.g_varchar2
785: ,p_attribute5 in varchar2 default hr_api.g_varchar2
786: ,p_attribute6 in varchar2 default hr_api.g_varchar2
787: ,p_attribute7 in varchar2 default hr_api.g_varchar2
788: ,p_attribute8 in varchar2 default hr_api.g_varchar2
789: ,p_attribute9 in varchar2 default hr_api.g_varchar2
790: ,p_attribute10 in varchar2 default hr_api.g_varchar2
791: ,p_attribute11 in varchar2 default hr_api.g_varchar2
792: ,p_attribute12 in varchar2 default hr_api.g_varchar2
785: ,p_attribute5 in varchar2 default hr_api.g_varchar2
786: ,p_attribute6 in varchar2 default hr_api.g_varchar2
787: ,p_attribute7 in varchar2 default hr_api.g_varchar2
788: ,p_attribute8 in varchar2 default hr_api.g_varchar2
789: ,p_attribute9 in varchar2 default hr_api.g_varchar2
790: ,p_attribute10 in varchar2 default hr_api.g_varchar2
791: ,p_attribute11 in varchar2 default hr_api.g_varchar2
792: ,p_attribute12 in varchar2 default hr_api.g_varchar2
793: ,p_attribute13 in varchar2 default hr_api.g_varchar2
786: ,p_attribute6 in varchar2 default hr_api.g_varchar2
787: ,p_attribute7 in varchar2 default hr_api.g_varchar2
788: ,p_attribute8 in varchar2 default hr_api.g_varchar2
789: ,p_attribute9 in varchar2 default hr_api.g_varchar2
790: ,p_attribute10 in varchar2 default hr_api.g_varchar2
791: ,p_attribute11 in varchar2 default hr_api.g_varchar2
792: ,p_attribute12 in varchar2 default hr_api.g_varchar2
793: ,p_attribute13 in varchar2 default hr_api.g_varchar2
794: ,p_attribute14 in varchar2 default hr_api.g_varchar2
787: ,p_attribute7 in varchar2 default hr_api.g_varchar2
788: ,p_attribute8 in varchar2 default hr_api.g_varchar2
789: ,p_attribute9 in varchar2 default hr_api.g_varchar2
790: ,p_attribute10 in varchar2 default hr_api.g_varchar2
791: ,p_attribute11 in varchar2 default hr_api.g_varchar2
792: ,p_attribute12 in varchar2 default hr_api.g_varchar2
793: ,p_attribute13 in varchar2 default hr_api.g_varchar2
794: ,p_attribute14 in varchar2 default hr_api.g_varchar2
795: ,p_attribute15 in varchar2 default hr_api.g_varchar2
788: ,p_attribute8 in varchar2 default hr_api.g_varchar2
789: ,p_attribute9 in varchar2 default hr_api.g_varchar2
790: ,p_attribute10 in varchar2 default hr_api.g_varchar2
791: ,p_attribute11 in varchar2 default hr_api.g_varchar2
792: ,p_attribute12 in varchar2 default hr_api.g_varchar2
793: ,p_attribute13 in varchar2 default hr_api.g_varchar2
794: ,p_attribute14 in varchar2 default hr_api.g_varchar2
795: ,p_attribute15 in varchar2 default hr_api.g_varchar2
796: ,p_attribute16 in varchar2 default hr_api.g_varchar2
789: ,p_attribute9 in varchar2 default hr_api.g_varchar2
790: ,p_attribute10 in varchar2 default hr_api.g_varchar2
791: ,p_attribute11 in varchar2 default hr_api.g_varchar2
792: ,p_attribute12 in varchar2 default hr_api.g_varchar2
793: ,p_attribute13 in varchar2 default hr_api.g_varchar2
794: ,p_attribute14 in varchar2 default hr_api.g_varchar2
795: ,p_attribute15 in varchar2 default hr_api.g_varchar2
796: ,p_attribute16 in varchar2 default hr_api.g_varchar2
797: ,p_attribute17 in varchar2 default hr_api.g_varchar2
790: ,p_attribute10 in varchar2 default hr_api.g_varchar2
791: ,p_attribute11 in varchar2 default hr_api.g_varchar2
792: ,p_attribute12 in varchar2 default hr_api.g_varchar2
793: ,p_attribute13 in varchar2 default hr_api.g_varchar2
794: ,p_attribute14 in varchar2 default hr_api.g_varchar2
795: ,p_attribute15 in varchar2 default hr_api.g_varchar2
796: ,p_attribute16 in varchar2 default hr_api.g_varchar2
797: ,p_attribute17 in varchar2 default hr_api.g_varchar2
798: ,p_attribute18 in varchar2 default hr_api.g_varchar2
791: ,p_attribute11 in varchar2 default hr_api.g_varchar2
792: ,p_attribute12 in varchar2 default hr_api.g_varchar2
793: ,p_attribute13 in varchar2 default hr_api.g_varchar2
794: ,p_attribute14 in varchar2 default hr_api.g_varchar2
795: ,p_attribute15 in varchar2 default hr_api.g_varchar2
796: ,p_attribute16 in varchar2 default hr_api.g_varchar2
797: ,p_attribute17 in varchar2 default hr_api.g_varchar2
798: ,p_attribute18 in varchar2 default hr_api.g_varchar2
799: ,p_attribute19 in varchar2 default hr_api.g_varchar2
792: ,p_attribute12 in varchar2 default hr_api.g_varchar2
793: ,p_attribute13 in varchar2 default hr_api.g_varchar2
794: ,p_attribute14 in varchar2 default hr_api.g_varchar2
795: ,p_attribute15 in varchar2 default hr_api.g_varchar2
796: ,p_attribute16 in varchar2 default hr_api.g_varchar2
797: ,p_attribute17 in varchar2 default hr_api.g_varchar2
798: ,p_attribute18 in varchar2 default hr_api.g_varchar2
799: ,p_attribute19 in varchar2 default hr_api.g_varchar2
800: ,p_attribute20 in varchar2 default hr_api.g_varchar2
793: ,p_attribute13 in varchar2 default hr_api.g_varchar2
794: ,p_attribute14 in varchar2 default hr_api.g_varchar2
795: ,p_attribute15 in varchar2 default hr_api.g_varchar2
796: ,p_attribute16 in varchar2 default hr_api.g_varchar2
797: ,p_attribute17 in varchar2 default hr_api.g_varchar2
798: ,p_attribute18 in varchar2 default hr_api.g_varchar2
799: ,p_attribute19 in varchar2 default hr_api.g_varchar2
800: ,p_attribute20 in varchar2 default hr_api.g_varchar2
801: ,p_data_source in varchar2 default hr_api.g_varchar2
794: ,p_attribute14 in varchar2 default hr_api.g_varchar2
795: ,p_attribute15 in varchar2 default hr_api.g_varchar2
796: ,p_attribute16 in varchar2 default hr_api.g_varchar2
797: ,p_attribute17 in varchar2 default hr_api.g_varchar2
798: ,p_attribute18 in varchar2 default hr_api.g_varchar2
799: ,p_attribute19 in varchar2 default hr_api.g_varchar2
800: ,p_attribute20 in varchar2 default hr_api.g_varchar2
801: ,p_data_source in varchar2 default hr_api.g_varchar2
802: ,p_vendor_id in number default hr_api.g_number
795: ,p_attribute15 in varchar2 default hr_api.g_varchar2
796: ,p_attribute16 in varchar2 default hr_api.g_varchar2
797: ,p_attribute17 in varchar2 default hr_api.g_varchar2
798: ,p_attribute18 in varchar2 default hr_api.g_varchar2
799: ,p_attribute19 in varchar2 default hr_api.g_varchar2
800: ,p_attribute20 in varchar2 default hr_api.g_varchar2
801: ,p_data_source in varchar2 default hr_api.g_varchar2
802: ,p_vendor_id in number default hr_api.g_number
803: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
796: ,p_attribute16 in varchar2 default hr_api.g_varchar2
797: ,p_attribute17 in varchar2 default hr_api.g_varchar2
798: ,p_attribute18 in varchar2 default hr_api.g_varchar2
799: ,p_attribute19 in varchar2 default hr_api.g_varchar2
800: ,p_attribute20 in varchar2 default hr_api.g_varchar2
801: ,p_data_source in varchar2 default hr_api.g_varchar2
802: ,p_vendor_id in number default hr_api.g_number
803: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
804: ,p_language_code in varchar2 default hr_api.g_varchar2 -- 2733966
797: ,p_attribute17 in varchar2 default hr_api.g_varchar2
798: ,p_attribute18 in varchar2 default hr_api.g_varchar2
799: ,p_attribute19 in varchar2 default hr_api.g_varchar2
800: ,p_attribute20 in varchar2 default hr_api.g_varchar2
801: ,p_data_source in varchar2 default hr_api.g_varchar2
802: ,p_vendor_id in number default hr_api.g_number
803: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
804: ,p_language_code in varchar2 default hr_api.g_varchar2 -- 2733966
805: ) is
798: ,p_attribute18 in varchar2 default hr_api.g_varchar2
799: ,p_attribute19 in varchar2 default hr_api.g_varchar2
800: ,p_attribute20 in varchar2 default hr_api.g_varchar2
801: ,p_data_source in varchar2 default hr_api.g_varchar2
802: ,p_vendor_id in number default hr_api.g_number
803: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
804: ,p_language_code in varchar2 default hr_api.g_varchar2 -- 2733966
805: ) is
806: --
799: ,p_attribute19 in varchar2 default hr_api.g_varchar2
800: ,p_attribute20 in varchar2 default hr_api.g_varchar2
801: ,p_data_source in varchar2 default hr_api.g_varchar2
802: ,p_vendor_id in number default hr_api.g_number
803: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
804: ,p_language_code in varchar2 default hr_api.g_varchar2 -- 2733966
805: ) is
806: --
807: l_rec ota_off_shd.g_rec_type;
800: ,p_attribute20 in varchar2 default hr_api.g_varchar2
801: ,p_data_source in varchar2 default hr_api.g_varchar2
802: ,p_vendor_id in number default hr_api.g_number
803: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
804: ,p_language_code in varchar2 default hr_api.g_varchar2 -- 2733966
805: ) is
806: --
807: l_rec ota_off_shd.g_rec_type;
808: l_proc varchar2(72) := g_package||'upd';