APPS.OTA_OFF_UPD dependencies on HR_API

Line 130: When hr_api.check_integrity_violated Then

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

Line 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

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

Line 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

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

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

Line 438: when hr_api.cannot_find_prog_unit then

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

Line 440: hr_api.cannot_find_prog_unit_error

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;

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

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

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

Line 757: ,p_business_group_id in number default hr_api.g_number

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

Line 758: ,p_name in varchar2 default hr_api.g_varchar2

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

Line 759: ,p_start_date in date default hr_api.g_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
763: ,p_delivery_mode_id in number default hr_api.g_number

Line 760: ,p_activity_version_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

Line 761: ,p_end_date in date default hr_api.g_date

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

Line 762: ,p_owner_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
766: ,p_duration_units in varchar2 default hr_api.g_varchar2

Line 763: ,p_delivery_mode_id in number default hr_api.g_number

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

Line 764: ,p_language_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

Line 765: ,p_duration 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
769: ,p_player_toolbar_bitset in number default hr_api.g_number

Line 766: ,p_duration_units in varchar2 default hr_api.g_varchar2

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

Line 767: ,p_learning_object_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
771: ,p_maximum_attendees in number default hr_api.g_number

Line 768: ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2

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

Line 769: ,p_player_toolbar_bitset 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

Line 770: ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2

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

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

Line 772: ,p_maximum_internal_attendees 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

Line 773: ,p_minimum_attendees in number default hr_api.g_number

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

Line 774: ,p_actual_cost 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
778: ,p_currency_code in varchar2 default hr_api.g_varchar2

Line 775: ,p_budget_cost in number default hr_api.g_number

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

Line 776: ,p_budget_currency_code in varchar2 default hr_api.g_varchar2

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

Line 777: ,p_price_basis 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

Line 778: ,p_currency_code 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

Line 779: ,p_standard_price 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
783: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 780: ,p_attribute_category 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

Line 781: ,p_attribute1 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

Line 782: ,p_attribute2 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

Line 783: ,p_attribute3 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

Line 784: ,p_attribute4 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

Line 785: ,p_attribute5 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

Line 786: ,p_attribute6 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

Line 787: ,p_attribute7 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

Line 788: ,p_attribute8 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

Line 789: ,p_attribute9 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

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

Line 791: ,p_attribute11 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

Line 792: ,p_attribute12 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

Line 793: ,p_attribute13 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

Line 794: ,p_attribute14 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

Line 795: ,p_attribute15 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

Line 796: ,p_attribute16 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

Line 797: ,p_attribute17 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

Line 798: ,p_attribute18 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

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

Line 800: ,p_attribute20 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

Line 801: ,p_data_source 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
805: ) is

Line 802: ,p_vendor_id in number default hr_api.g_number

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

Line 803: ,p_competency_update_level 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: --
807: l_rec ota_off_shd.g_rec_type;

Line 804: ,p_language_code in varchar2 default hr_api.g_varchar2 -- 2733966

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