403: ,p_attribute19 => p_attribute19
404: ,p_attribute20 => p_attribute20
405: );
406: exception
407: when hr_api.cannot_find_prog_unit then
408: hr_api.cannot_find_prog_unit_error
409: (
410: p_module_name => 'CREATE_collective_agreement'
411: ,p_hook_type => 'BP'
404: ,p_attribute20 => p_attribute20
405: );
406: exception
407: when hr_api.cannot_find_prog_unit then
408: hr_api.cannot_find_prog_unit_error
409: (
410: p_module_name => 'CREATE_collective_agreement'
411: ,p_hook_type => 'BP'
412: );
621: ,p_attribute19 => p_attribute19
622: ,p_attribute20 => p_attribute20
623: );
624: exception
625: when hr_api.cannot_find_prog_unit then
626: hr_api.cannot_find_prog_unit_error
627: (p_module_name => 'CREATE_collective_agreement'
628: ,p_hook_type => 'AP'
629: );
622: ,p_attribute20 => p_attribute20
623: );
624: exception
625: when hr_api.cannot_find_prog_unit then
626: hr_api.cannot_find_prog_unit_error
627: (p_module_name => 'CREATE_collective_agreement'
628: ,p_hook_type => 'AP'
629: );
630: --
636: --
637: -- When in validation only mode raise the Validate_Enabled exception
638: --
639: if p_validate then
640: raise hr_api.validate_enabled;
641: end if;
642: --
643: -- Set all output arguments
644: --
648: hr_utility.set_location(' Leaving:'||l_proc, 70);
649: --
650: exception
651: --
652: when hr_api.validate_enabled then
653: --
654: -- As the Validate_Enabled exception has been raised
655: -- we must rollback to the savepoint
656: --
681: --
682: procedure update_collective_agreement
683: (p_validate in boolean default false
684: ,p_collective_agreement_id in number
685: ,p_business_group_id in number default hr_api.g_number
686: ,p_object_version_number in out nocopy number
687: ,p_name in varchar2 default hr_api.g_varchar2
688: ,p_status in varchar2 default hr_api.g_varchar2
689: ,p_cag_number in number default hr_api.g_number
683: (p_validate in boolean default false
684: ,p_collective_agreement_id in number
685: ,p_business_group_id in number default hr_api.g_number
686: ,p_object_version_number in out nocopy number
687: ,p_name in varchar2 default hr_api.g_varchar2
688: ,p_status in varchar2 default hr_api.g_varchar2
689: ,p_cag_number in number default hr_api.g_number
690: ,p_description in varchar2 default hr_api.g_varchar2
691: ,p_start_date in date default hr_api.g_date
684: ,p_collective_agreement_id in number
685: ,p_business_group_id in number default hr_api.g_number
686: ,p_object_version_number in out nocopy number
687: ,p_name in varchar2 default hr_api.g_varchar2
688: ,p_status in varchar2 default hr_api.g_varchar2
689: ,p_cag_number in number default hr_api.g_number
690: ,p_description in varchar2 default hr_api.g_varchar2
691: ,p_start_date in date default hr_api.g_date
692: ,p_end_date in date default hr_api.g_date
685: ,p_business_group_id in number default hr_api.g_number
686: ,p_object_version_number in out nocopy number
687: ,p_name in varchar2 default hr_api.g_varchar2
688: ,p_status in varchar2 default hr_api.g_varchar2
689: ,p_cag_number in number default hr_api.g_number
690: ,p_description in varchar2 default hr_api.g_varchar2
691: ,p_start_date in date default hr_api.g_date
692: ,p_end_date in date default hr_api.g_date
693: ,p_employer_organization_id in number default hr_api.g_number
686: ,p_object_version_number in out nocopy number
687: ,p_name in varchar2 default hr_api.g_varchar2
688: ,p_status in varchar2 default hr_api.g_varchar2
689: ,p_cag_number in number default hr_api.g_number
690: ,p_description in varchar2 default hr_api.g_varchar2
691: ,p_start_date in date default hr_api.g_date
692: ,p_end_date in date default hr_api.g_date
693: ,p_employer_organization_id in number default hr_api.g_number
694: ,p_employer_signatory in varchar2 default hr_api.g_varchar2
687: ,p_name in varchar2 default hr_api.g_varchar2
688: ,p_status in varchar2 default hr_api.g_varchar2
689: ,p_cag_number in number default hr_api.g_number
690: ,p_description in varchar2 default hr_api.g_varchar2
691: ,p_start_date in date default hr_api.g_date
692: ,p_end_date in date default hr_api.g_date
693: ,p_employer_organization_id in number default hr_api.g_number
694: ,p_employer_signatory in varchar2 default hr_api.g_varchar2
695: ,p_bargaining_organization_id in number default hr_api.g_number
688: ,p_status in varchar2 default hr_api.g_varchar2
689: ,p_cag_number in number default hr_api.g_number
690: ,p_description in varchar2 default hr_api.g_varchar2
691: ,p_start_date in date default hr_api.g_date
692: ,p_end_date in date default hr_api.g_date
693: ,p_employer_organization_id in number default hr_api.g_number
694: ,p_employer_signatory in varchar2 default hr_api.g_varchar2
695: ,p_bargaining_organization_id in number default hr_api.g_number
696: ,p_bargaining_unit_signatory in varchar2 default hr_api.g_varchar2
689: ,p_cag_number in number default hr_api.g_number
690: ,p_description in varchar2 default hr_api.g_varchar2
691: ,p_start_date in date default hr_api.g_date
692: ,p_end_date in date default hr_api.g_date
693: ,p_employer_organization_id in number default hr_api.g_number
694: ,p_employer_signatory in varchar2 default hr_api.g_varchar2
695: ,p_bargaining_organization_id in number default hr_api.g_number
696: ,p_bargaining_unit_signatory in varchar2 default hr_api.g_varchar2
697: ,p_jurisdiction in varchar2 default hr_api.g_varchar2
690: ,p_description in varchar2 default hr_api.g_varchar2
691: ,p_start_date in date default hr_api.g_date
692: ,p_end_date in date default hr_api.g_date
693: ,p_employer_organization_id in number default hr_api.g_number
694: ,p_employer_signatory in varchar2 default hr_api.g_varchar2
695: ,p_bargaining_organization_id in number default hr_api.g_number
696: ,p_bargaining_unit_signatory in varchar2 default hr_api.g_varchar2
697: ,p_jurisdiction in varchar2 default hr_api.g_varchar2
698: ,p_authorizing_body in varchar2 default hr_api.g_varchar2
691: ,p_start_date in date default hr_api.g_date
692: ,p_end_date in date default hr_api.g_date
693: ,p_employer_organization_id in number default hr_api.g_number
694: ,p_employer_signatory in varchar2 default hr_api.g_varchar2
695: ,p_bargaining_organization_id in number default hr_api.g_number
696: ,p_bargaining_unit_signatory in varchar2 default hr_api.g_varchar2
697: ,p_jurisdiction in varchar2 default hr_api.g_varchar2
698: ,p_authorizing_body in varchar2 default hr_api.g_varchar2
699: ,p_authorized_date in date default hr_api.g_date
692: ,p_end_date in date default hr_api.g_date
693: ,p_employer_organization_id in number default hr_api.g_number
694: ,p_employer_signatory in varchar2 default hr_api.g_varchar2
695: ,p_bargaining_organization_id in number default hr_api.g_number
696: ,p_bargaining_unit_signatory in varchar2 default hr_api.g_varchar2
697: ,p_jurisdiction in varchar2 default hr_api.g_varchar2
698: ,p_authorizing_body in varchar2 default hr_api.g_varchar2
699: ,p_authorized_date in date default hr_api.g_date
700: ,p_cag_information_category in varchar2 default hr_api.g_varchar2
693: ,p_employer_organization_id in number default hr_api.g_number
694: ,p_employer_signatory in varchar2 default hr_api.g_varchar2
695: ,p_bargaining_organization_id in number default hr_api.g_number
696: ,p_bargaining_unit_signatory in varchar2 default hr_api.g_varchar2
697: ,p_jurisdiction in varchar2 default hr_api.g_varchar2
698: ,p_authorizing_body in varchar2 default hr_api.g_varchar2
699: ,p_authorized_date in date default hr_api.g_date
700: ,p_cag_information_category in varchar2 default hr_api.g_varchar2
701: ,p_cag_information1 in varchar2 default hr_api.g_varchar2
694: ,p_employer_signatory in varchar2 default hr_api.g_varchar2
695: ,p_bargaining_organization_id in number default hr_api.g_number
696: ,p_bargaining_unit_signatory in varchar2 default hr_api.g_varchar2
697: ,p_jurisdiction in varchar2 default hr_api.g_varchar2
698: ,p_authorizing_body in varchar2 default hr_api.g_varchar2
699: ,p_authorized_date in date default hr_api.g_date
700: ,p_cag_information_category in varchar2 default hr_api.g_varchar2
701: ,p_cag_information1 in varchar2 default hr_api.g_varchar2
702: ,p_cag_information2 in varchar2 default hr_api.g_varchar2
695: ,p_bargaining_organization_id in number default hr_api.g_number
696: ,p_bargaining_unit_signatory in varchar2 default hr_api.g_varchar2
697: ,p_jurisdiction in varchar2 default hr_api.g_varchar2
698: ,p_authorizing_body in varchar2 default hr_api.g_varchar2
699: ,p_authorized_date in date default hr_api.g_date
700: ,p_cag_information_category in varchar2 default hr_api.g_varchar2
701: ,p_cag_information1 in varchar2 default hr_api.g_varchar2
702: ,p_cag_information2 in varchar2 default hr_api.g_varchar2
703: ,p_cag_information3 in varchar2 default hr_api.g_varchar2
696: ,p_bargaining_unit_signatory in varchar2 default hr_api.g_varchar2
697: ,p_jurisdiction in varchar2 default hr_api.g_varchar2
698: ,p_authorizing_body in varchar2 default hr_api.g_varchar2
699: ,p_authorized_date in date default hr_api.g_date
700: ,p_cag_information_category in varchar2 default hr_api.g_varchar2
701: ,p_cag_information1 in varchar2 default hr_api.g_varchar2
702: ,p_cag_information2 in varchar2 default hr_api.g_varchar2
703: ,p_cag_information3 in varchar2 default hr_api.g_varchar2
704: ,p_cag_information4 in varchar2 default hr_api.g_varchar2
697: ,p_jurisdiction in varchar2 default hr_api.g_varchar2
698: ,p_authorizing_body in varchar2 default hr_api.g_varchar2
699: ,p_authorized_date in date default hr_api.g_date
700: ,p_cag_information_category in varchar2 default hr_api.g_varchar2
701: ,p_cag_information1 in varchar2 default hr_api.g_varchar2
702: ,p_cag_information2 in varchar2 default hr_api.g_varchar2
703: ,p_cag_information3 in varchar2 default hr_api.g_varchar2
704: ,p_cag_information4 in varchar2 default hr_api.g_varchar2
705: ,p_cag_information5 in varchar2 default hr_api.g_varchar2
698: ,p_authorizing_body in varchar2 default hr_api.g_varchar2
699: ,p_authorized_date in date default hr_api.g_date
700: ,p_cag_information_category in varchar2 default hr_api.g_varchar2
701: ,p_cag_information1 in varchar2 default hr_api.g_varchar2
702: ,p_cag_information2 in varchar2 default hr_api.g_varchar2
703: ,p_cag_information3 in varchar2 default hr_api.g_varchar2
704: ,p_cag_information4 in varchar2 default hr_api.g_varchar2
705: ,p_cag_information5 in varchar2 default hr_api.g_varchar2
706: ,p_cag_information6 in varchar2 default hr_api.g_varchar2
699: ,p_authorized_date in date default hr_api.g_date
700: ,p_cag_information_category in varchar2 default hr_api.g_varchar2
701: ,p_cag_information1 in varchar2 default hr_api.g_varchar2
702: ,p_cag_information2 in varchar2 default hr_api.g_varchar2
703: ,p_cag_information3 in varchar2 default hr_api.g_varchar2
704: ,p_cag_information4 in varchar2 default hr_api.g_varchar2
705: ,p_cag_information5 in varchar2 default hr_api.g_varchar2
706: ,p_cag_information6 in varchar2 default hr_api.g_varchar2
707: ,p_cag_information7 in varchar2 default hr_api.g_varchar2
700: ,p_cag_information_category in varchar2 default hr_api.g_varchar2
701: ,p_cag_information1 in varchar2 default hr_api.g_varchar2
702: ,p_cag_information2 in varchar2 default hr_api.g_varchar2
703: ,p_cag_information3 in varchar2 default hr_api.g_varchar2
704: ,p_cag_information4 in varchar2 default hr_api.g_varchar2
705: ,p_cag_information5 in varchar2 default hr_api.g_varchar2
706: ,p_cag_information6 in varchar2 default hr_api.g_varchar2
707: ,p_cag_information7 in varchar2 default hr_api.g_varchar2
708: ,p_cag_information8 in varchar2 default hr_api.g_varchar2
701: ,p_cag_information1 in varchar2 default hr_api.g_varchar2
702: ,p_cag_information2 in varchar2 default hr_api.g_varchar2
703: ,p_cag_information3 in varchar2 default hr_api.g_varchar2
704: ,p_cag_information4 in varchar2 default hr_api.g_varchar2
705: ,p_cag_information5 in varchar2 default hr_api.g_varchar2
706: ,p_cag_information6 in varchar2 default hr_api.g_varchar2
707: ,p_cag_information7 in varchar2 default hr_api.g_varchar2
708: ,p_cag_information8 in varchar2 default hr_api.g_varchar2
709: ,p_cag_information9 in varchar2 default hr_api.g_varchar2
702: ,p_cag_information2 in varchar2 default hr_api.g_varchar2
703: ,p_cag_information3 in varchar2 default hr_api.g_varchar2
704: ,p_cag_information4 in varchar2 default hr_api.g_varchar2
705: ,p_cag_information5 in varchar2 default hr_api.g_varchar2
706: ,p_cag_information6 in varchar2 default hr_api.g_varchar2
707: ,p_cag_information7 in varchar2 default hr_api.g_varchar2
708: ,p_cag_information8 in varchar2 default hr_api.g_varchar2
709: ,p_cag_information9 in varchar2 default hr_api.g_varchar2
710: ,p_cag_information10 in varchar2 default hr_api.g_varchar2
703: ,p_cag_information3 in varchar2 default hr_api.g_varchar2
704: ,p_cag_information4 in varchar2 default hr_api.g_varchar2
705: ,p_cag_information5 in varchar2 default hr_api.g_varchar2
706: ,p_cag_information6 in varchar2 default hr_api.g_varchar2
707: ,p_cag_information7 in varchar2 default hr_api.g_varchar2
708: ,p_cag_information8 in varchar2 default hr_api.g_varchar2
709: ,p_cag_information9 in varchar2 default hr_api.g_varchar2
710: ,p_cag_information10 in varchar2 default hr_api.g_varchar2
711: ,p_cag_information11 in varchar2 default hr_api.g_varchar2
704: ,p_cag_information4 in varchar2 default hr_api.g_varchar2
705: ,p_cag_information5 in varchar2 default hr_api.g_varchar2
706: ,p_cag_information6 in varchar2 default hr_api.g_varchar2
707: ,p_cag_information7 in varchar2 default hr_api.g_varchar2
708: ,p_cag_information8 in varchar2 default hr_api.g_varchar2
709: ,p_cag_information9 in varchar2 default hr_api.g_varchar2
710: ,p_cag_information10 in varchar2 default hr_api.g_varchar2
711: ,p_cag_information11 in varchar2 default hr_api.g_varchar2
712: ,p_cag_information12 in varchar2 default hr_api.g_varchar2
705: ,p_cag_information5 in varchar2 default hr_api.g_varchar2
706: ,p_cag_information6 in varchar2 default hr_api.g_varchar2
707: ,p_cag_information7 in varchar2 default hr_api.g_varchar2
708: ,p_cag_information8 in varchar2 default hr_api.g_varchar2
709: ,p_cag_information9 in varchar2 default hr_api.g_varchar2
710: ,p_cag_information10 in varchar2 default hr_api.g_varchar2
711: ,p_cag_information11 in varchar2 default hr_api.g_varchar2
712: ,p_cag_information12 in varchar2 default hr_api.g_varchar2
713: ,p_cag_information13 in varchar2 default hr_api.g_varchar2
706: ,p_cag_information6 in varchar2 default hr_api.g_varchar2
707: ,p_cag_information7 in varchar2 default hr_api.g_varchar2
708: ,p_cag_information8 in varchar2 default hr_api.g_varchar2
709: ,p_cag_information9 in varchar2 default hr_api.g_varchar2
710: ,p_cag_information10 in varchar2 default hr_api.g_varchar2
711: ,p_cag_information11 in varchar2 default hr_api.g_varchar2
712: ,p_cag_information12 in varchar2 default hr_api.g_varchar2
713: ,p_cag_information13 in varchar2 default hr_api.g_varchar2
714: ,p_cag_information14 in varchar2 default hr_api.g_varchar2
707: ,p_cag_information7 in varchar2 default hr_api.g_varchar2
708: ,p_cag_information8 in varchar2 default hr_api.g_varchar2
709: ,p_cag_information9 in varchar2 default hr_api.g_varchar2
710: ,p_cag_information10 in varchar2 default hr_api.g_varchar2
711: ,p_cag_information11 in varchar2 default hr_api.g_varchar2
712: ,p_cag_information12 in varchar2 default hr_api.g_varchar2
713: ,p_cag_information13 in varchar2 default hr_api.g_varchar2
714: ,p_cag_information14 in varchar2 default hr_api.g_varchar2
715: ,p_cag_information15 in varchar2 default hr_api.g_varchar2
708: ,p_cag_information8 in varchar2 default hr_api.g_varchar2
709: ,p_cag_information9 in varchar2 default hr_api.g_varchar2
710: ,p_cag_information10 in varchar2 default hr_api.g_varchar2
711: ,p_cag_information11 in varchar2 default hr_api.g_varchar2
712: ,p_cag_information12 in varchar2 default hr_api.g_varchar2
713: ,p_cag_information13 in varchar2 default hr_api.g_varchar2
714: ,p_cag_information14 in varchar2 default hr_api.g_varchar2
715: ,p_cag_information15 in varchar2 default hr_api.g_varchar2
716: ,p_cag_information16 in varchar2 default hr_api.g_varchar2
709: ,p_cag_information9 in varchar2 default hr_api.g_varchar2
710: ,p_cag_information10 in varchar2 default hr_api.g_varchar2
711: ,p_cag_information11 in varchar2 default hr_api.g_varchar2
712: ,p_cag_information12 in varchar2 default hr_api.g_varchar2
713: ,p_cag_information13 in varchar2 default hr_api.g_varchar2
714: ,p_cag_information14 in varchar2 default hr_api.g_varchar2
715: ,p_cag_information15 in varchar2 default hr_api.g_varchar2
716: ,p_cag_information16 in varchar2 default hr_api.g_varchar2
717: ,p_cag_information17 in varchar2 default hr_api.g_varchar2
710: ,p_cag_information10 in varchar2 default hr_api.g_varchar2
711: ,p_cag_information11 in varchar2 default hr_api.g_varchar2
712: ,p_cag_information12 in varchar2 default hr_api.g_varchar2
713: ,p_cag_information13 in varchar2 default hr_api.g_varchar2
714: ,p_cag_information14 in varchar2 default hr_api.g_varchar2
715: ,p_cag_information15 in varchar2 default hr_api.g_varchar2
716: ,p_cag_information16 in varchar2 default hr_api.g_varchar2
717: ,p_cag_information17 in varchar2 default hr_api.g_varchar2
718: ,p_cag_information18 in varchar2 default hr_api.g_varchar2
711: ,p_cag_information11 in varchar2 default hr_api.g_varchar2
712: ,p_cag_information12 in varchar2 default hr_api.g_varchar2
713: ,p_cag_information13 in varchar2 default hr_api.g_varchar2
714: ,p_cag_information14 in varchar2 default hr_api.g_varchar2
715: ,p_cag_information15 in varchar2 default hr_api.g_varchar2
716: ,p_cag_information16 in varchar2 default hr_api.g_varchar2
717: ,p_cag_information17 in varchar2 default hr_api.g_varchar2
718: ,p_cag_information18 in varchar2 default hr_api.g_varchar2
719: ,p_cag_information19 in varchar2 default hr_api.g_varchar2
712: ,p_cag_information12 in varchar2 default hr_api.g_varchar2
713: ,p_cag_information13 in varchar2 default hr_api.g_varchar2
714: ,p_cag_information14 in varchar2 default hr_api.g_varchar2
715: ,p_cag_information15 in varchar2 default hr_api.g_varchar2
716: ,p_cag_information16 in varchar2 default hr_api.g_varchar2
717: ,p_cag_information17 in varchar2 default hr_api.g_varchar2
718: ,p_cag_information18 in varchar2 default hr_api.g_varchar2
719: ,p_cag_information19 in varchar2 default hr_api.g_varchar2
720: ,p_cag_information20 in varchar2 default hr_api.g_varchar2
713: ,p_cag_information13 in varchar2 default hr_api.g_varchar2
714: ,p_cag_information14 in varchar2 default hr_api.g_varchar2
715: ,p_cag_information15 in varchar2 default hr_api.g_varchar2
716: ,p_cag_information16 in varchar2 default hr_api.g_varchar2
717: ,p_cag_information17 in varchar2 default hr_api.g_varchar2
718: ,p_cag_information18 in varchar2 default hr_api.g_varchar2
719: ,p_cag_information19 in varchar2 default hr_api.g_varchar2
720: ,p_cag_information20 in varchar2 default hr_api.g_varchar2
721: ,p_attribute_category in varchar2 default hr_api.g_varchar2
714: ,p_cag_information14 in varchar2 default hr_api.g_varchar2
715: ,p_cag_information15 in varchar2 default hr_api.g_varchar2
716: ,p_cag_information16 in varchar2 default hr_api.g_varchar2
717: ,p_cag_information17 in varchar2 default hr_api.g_varchar2
718: ,p_cag_information18 in varchar2 default hr_api.g_varchar2
719: ,p_cag_information19 in varchar2 default hr_api.g_varchar2
720: ,p_cag_information20 in varchar2 default hr_api.g_varchar2
721: ,p_attribute_category in varchar2 default hr_api.g_varchar2
722: ,p_attribute1 in varchar2 default hr_api.g_varchar2
715: ,p_cag_information15 in varchar2 default hr_api.g_varchar2
716: ,p_cag_information16 in varchar2 default hr_api.g_varchar2
717: ,p_cag_information17 in varchar2 default hr_api.g_varchar2
718: ,p_cag_information18 in varchar2 default hr_api.g_varchar2
719: ,p_cag_information19 in varchar2 default hr_api.g_varchar2
720: ,p_cag_information20 in varchar2 default hr_api.g_varchar2
721: ,p_attribute_category in varchar2 default hr_api.g_varchar2
722: ,p_attribute1 in varchar2 default hr_api.g_varchar2
723: ,p_attribute2 in varchar2 default hr_api.g_varchar2
716: ,p_cag_information16 in varchar2 default hr_api.g_varchar2
717: ,p_cag_information17 in varchar2 default hr_api.g_varchar2
718: ,p_cag_information18 in varchar2 default hr_api.g_varchar2
719: ,p_cag_information19 in varchar2 default hr_api.g_varchar2
720: ,p_cag_information20 in varchar2 default hr_api.g_varchar2
721: ,p_attribute_category in varchar2 default hr_api.g_varchar2
722: ,p_attribute1 in varchar2 default hr_api.g_varchar2
723: ,p_attribute2 in varchar2 default hr_api.g_varchar2
724: ,p_attribute3 in varchar2 default hr_api.g_varchar2
717: ,p_cag_information17 in varchar2 default hr_api.g_varchar2
718: ,p_cag_information18 in varchar2 default hr_api.g_varchar2
719: ,p_cag_information19 in varchar2 default hr_api.g_varchar2
720: ,p_cag_information20 in varchar2 default hr_api.g_varchar2
721: ,p_attribute_category in varchar2 default hr_api.g_varchar2
722: ,p_attribute1 in varchar2 default hr_api.g_varchar2
723: ,p_attribute2 in varchar2 default hr_api.g_varchar2
724: ,p_attribute3 in varchar2 default hr_api.g_varchar2
725: ,p_attribute4 in varchar2 default hr_api.g_varchar2
718: ,p_cag_information18 in varchar2 default hr_api.g_varchar2
719: ,p_cag_information19 in varchar2 default hr_api.g_varchar2
720: ,p_cag_information20 in varchar2 default hr_api.g_varchar2
721: ,p_attribute_category in varchar2 default hr_api.g_varchar2
722: ,p_attribute1 in varchar2 default hr_api.g_varchar2
723: ,p_attribute2 in varchar2 default hr_api.g_varchar2
724: ,p_attribute3 in varchar2 default hr_api.g_varchar2
725: ,p_attribute4 in varchar2 default hr_api.g_varchar2
726: ,p_attribute5 in varchar2 default hr_api.g_varchar2
719: ,p_cag_information19 in varchar2 default hr_api.g_varchar2
720: ,p_cag_information20 in varchar2 default hr_api.g_varchar2
721: ,p_attribute_category in varchar2 default hr_api.g_varchar2
722: ,p_attribute1 in varchar2 default hr_api.g_varchar2
723: ,p_attribute2 in varchar2 default hr_api.g_varchar2
724: ,p_attribute3 in varchar2 default hr_api.g_varchar2
725: ,p_attribute4 in varchar2 default hr_api.g_varchar2
726: ,p_attribute5 in varchar2 default hr_api.g_varchar2
727: ,p_attribute6 in varchar2 default hr_api.g_varchar2
720: ,p_cag_information20 in varchar2 default hr_api.g_varchar2
721: ,p_attribute_category in varchar2 default hr_api.g_varchar2
722: ,p_attribute1 in varchar2 default hr_api.g_varchar2
723: ,p_attribute2 in varchar2 default hr_api.g_varchar2
724: ,p_attribute3 in varchar2 default hr_api.g_varchar2
725: ,p_attribute4 in varchar2 default hr_api.g_varchar2
726: ,p_attribute5 in varchar2 default hr_api.g_varchar2
727: ,p_attribute6 in varchar2 default hr_api.g_varchar2
728: ,p_attribute7 in varchar2 default hr_api.g_varchar2
721: ,p_attribute_category in varchar2 default hr_api.g_varchar2
722: ,p_attribute1 in varchar2 default hr_api.g_varchar2
723: ,p_attribute2 in varchar2 default hr_api.g_varchar2
724: ,p_attribute3 in varchar2 default hr_api.g_varchar2
725: ,p_attribute4 in varchar2 default hr_api.g_varchar2
726: ,p_attribute5 in varchar2 default hr_api.g_varchar2
727: ,p_attribute6 in varchar2 default hr_api.g_varchar2
728: ,p_attribute7 in varchar2 default hr_api.g_varchar2
729: ,p_attribute8 in varchar2 default hr_api.g_varchar2
722: ,p_attribute1 in varchar2 default hr_api.g_varchar2
723: ,p_attribute2 in varchar2 default hr_api.g_varchar2
724: ,p_attribute3 in varchar2 default hr_api.g_varchar2
725: ,p_attribute4 in varchar2 default hr_api.g_varchar2
726: ,p_attribute5 in varchar2 default hr_api.g_varchar2
727: ,p_attribute6 in varchar2 default hr_api.g_varchar2
728: ,p_attribute7 in varchar2 default hr_api.g_varchar2
729: ,p_attribute8 in varchar2 default hr_api.g_varchar2
730: ,p_attribute9 in varchar2 default hr_api.g_varchar2
723: ,p_attribute2 in varchar2 default hr_api.g_varchar2
724: ,p_attribute3 in varchar2 default hr_api.g_varchar2
725: ,p_attribute4 in varchar2 default hr_api.g_varchar2
726: ,p_attribute5 in varchar2 default hr_api.g_varchar2
727: ,p_attribute6 in varchar2 default hr_api.g_varchar2
728: ,p_attribute7 in varchar2 default hr_api.g_varchar2
729: ,p_attribute8 in varchar2 default hr_api.g_varchar2
730: ,p_attribute9 in varchar2 default hr_api.g_varchar2
731: ,p_attribute10 in varchar2 default hr_api.g_varchar2
724: ,p_attribute3 in varchar2 default hr_api.g_varchar2
725: ,p_attribute4 in varchar2 default hr_api.g_varchar2
726: ,p_attribute5 in varchar2 default hr_api.g_varchar2
727: ,p_attribute6 in varchar2 default hr_api.g_varchar2
728: ,p_attribute7 in varchar2 default hr_api.g_varchar2
729: ,p_attribute8 in varchar2 default hr_api.g_varchar2
730: ,p_attribute9 in varchar2 default hr_api.g_varchar2
731: ,p_attribute10 in varchar2 default hr_api.g_varchar2
732: ,p_attribute11 in varchar2 default hr_api.g_varchar2
725: ,p_attribute4 in varchar2 default hr_api.g_varchar2
726: ,p_attribute5 in varchar2 default hr_api.g_varchar2
727: ,p_attribute6 in varchar2 default hr_api.g_varchar2
728: ,p_attribute7 in varchar2 default hr_api.g_varchar2
729: ,p_attribute8 in varchar2 default hr_api.g_varchar2
730: ,p_attribute9 in varchar2 default hr_api.g_varchar2
731: ,p_attribute10 in varchar2 default hr_api.g_varchar2
732: ,p_attribute11 in varchar2 default hr_api.g_varchar2
733: ,p_attribute12 in varchar2 default hr_api.g_varchar2
726: ,p_attribute5 in varchar2 default hr_api.g_varchar2
727: ,p_attribute6 in varchar2 default hr_api.g_varchar2
728: ,p_attribute7 in varchar2 default hr_api.g_varchar2
729: ,p_attribute8 in varchar2 default hr_api.g_varchar2
730: ,p_attribute9 in varchar2 default hr_api.g_varchar2
731: ,p_attribute10 in varchar2 default hr_api.g_varchar2
732: ,p_attribute11 in varchar2 default hr_api.g_varchar2
733: ,p_attribute12 in varchar2 default hr_api.g_varchar2
734: ,p_attribute13 in varchar2 default hr_api.g_varchar2
727: ,p_attribute6 in varchar2 default hr_api.g_varchar2
728: ,p_attribute7 in varchar2 default hr_api.g_varchar2
729: ,p_attribute8 in varchar2 default hr_api.g_varchar2
730: ,p_attribute9 in varchar2 default hr_api.g_varchar2
731: ,p_attribute10 in varchar2 default hr_api.g_varchar2
732: ,p_attribute11 in varchar2 default hr_api.g_varchar2
733: ,p_attribute12 in varchar2 default hr_api.g_varchar2
734: ,p_attribute13 in varchar2 default hr_api.g_varchar2
735: ,p_attribute14 in varchar2 default hr_api.g_varchar2
728: ,p_attribute7 in varchar2 default hr_api.g_varchar2
729: ,p_attribute8 in varchar2 default hr_api.g_varchar2
730: ,p_attribute9 in varchar2 default hr_api.g_varchar2
731: ,p_attribute10 in varchar2 default hr_api.g_varchar2
732: ,p_attribute11 in varchar2 default hr_api.g_varchar2
733: ,p_attribute12 in varchar2 default hr_api.g_varchar2
734: ,p_attribute13 in varchar2 default hr_api.g_varchar2
735: ,p_attribute14 in varchar2 default hr_api.g_varchar2
736: ,p_attribute15 in varchar2 default hr_api.g_varchar2
729: ,p_attribute8 in varchar2 default hr_api.g_varchar2
730: ,p_attribute9 in varchar2 default hr_api.g_varchar2
731: ,p_attribute10 in varchar2 default hr_api.g_varchar2
732: ,p_attribute11 in varchar2 default hr_api.g_varchar2
733: ,p_attribute12 in varchar2 default hr_api.g_varchar2
734: ,p_attribute13 in varchar2 default hr_api.g_varchar2
735: ,p_attribute14 in varchar2 default hr_api.g_varchar2
736: ,p_attribute15 in varchar2 default hr_api.g_varchar2
737: ,p_attribute16 in varchar2 default hr_api.g_varchar2
730: ,p_attribute9 in varchar2 default hr_api.g_varchar2
731: ,p_attribute10 in varchar2 default hr_api.g_varchar2
732: ,p_attribute11 in varchar2 default hr_api.g_varchar2
733: ,p_attribute12 in varchar2 default hr_api.g_varchar2
734: ,p_attribute13 in varchar2 default hr_api.g_varchar2
735: ,p_attribute14 in varchar2 default hr_api.g_varchar2
736: ,p_attribute15 in varchar2 default hr_api.g_varchar2
737: ,p_attribute16 in varchar2 default hr_api.g_varchar2
738: ,p_attribute17 in varchar2 default hr_api.g_varchar2
731: ,p_attribute10 in varchar2 default hr_api.g_varchar2
732: ,p_attribute11 in varchar2 default hr_api.g_varchar2
733: ,p_attribute12 in varchar2 default hr_api.g_varchar2
734: ,p_attribute13 in varchar2 default hr_api.g_varchar2
735: ,p_attribute14 in varchar2 default hr_api.g_varchar2
736: ,p_attribute15 in varchar2 default hr_api.g_varchar2
737: ,p_attribute16 in varchar2 default hr_api.g_varchar2
738: ,p_attribute17 in varchar2 default hr_api.g_varchar2
739: ,p_attribute18 in varchar2 default hr_api.g_varchar2
732: ,p_attribute11 in varchar2 default hr_api.g_varchar2
733: ,p_attribute12 in varchar2 default hr_api.g_varchar2
734: ,p_attribute13 in varchar2 default hr_api.g_varchar2
735: ,p_attribute14 in varchar2 default hr_api.g_varchar2
736: ,p_attribute15 in varchar2 default hr_api.g_varchar2
737: ,p_attribute16 in varchar2 default hr_api.g_varchar2
738: ,p_attribute17 in varchar2 default hr_api.g_varchar2
739: ,p_attribute18 in varchar2 default hr_api.g_varchar2
740: ,p_attribute19 in varchar2 default hr_api.g_varchar2
733: ,p_attribute12 in varchar2 default hr_api.g_varchar2
734: ,p_attribute13 in varchar2 default hr_api.g_varchar2
735: ,p_attribute14 in varchar2 default hr_api.g_varchar2
736: ,p_attribute15 in varchar2 default hr_api.g_varchar2
737: ,p_attribute16 in varchar2 default hr_api.g_varchar2
738: ,p_attribute17 in varchar2 default hr_api.g_varchar2
739: ,p_attribute18 in varchar2 default hr_api.g_varchar2
740: ,p_attribute19 in varchar2 default hr_api.g_varchar2
741: ,p_attribute20 in varchar2 default hr_api.g_varchar2
734: ,p_attribute13 in varchar2 default hr_api.g_varchar2
735: ,p_attribute14 in varchar2 default hr_api.g_varchar2
736: ,p_attribute15 in varchar2 default hr_api.g_varchar2
737: ,p_attribute16 in varchar2 default hr_api.g_varchar2
738: ,p_attribute17 in varchar2 default hr_api.g_varchar2
739: ,p_attribute18 in varchar2 default hr_api.g_varchar2
740: ,p_attribute19 in varchar2 default hr_api.g_varchar2
741: ,p_attribute20 in varchar2 default hr_api.g_varchar2
742: ) is
735: ,p_attribute14 in varchar2 default hr_api.g_varchar2
736: ,p_attribute15 in varchar2 default hr_api.g_varchar2
737: ,p_attribute16 in varchar2 default hr_api.g_varchar2
738: ,p_attribute17 in varchar2 default hr_api.g_varchar2
739: ,p_attribute18 in varchar2 default hr_api.g_varchar2
740: ,p_attribute19 in varchar2 default hr_api.g_varchar2
741: ,p_attribute20 in varchar2 default hr_api.g_varchar2
742: ) is
743: --
736: ,p_attribute15 in varchar2 default hr_api.g_varchar2
737: ,p_attribute16 in varchar2 default hr_api.g_varchar2
738: ,p_attribute17 in varchar2 default hr_api.g_varchar2
739: ,p_attribute18 in varchar2 default hr_api.g_varchar2
740: ,p_attribute19 in varchar2 default hr_api.g_varchar2
741: ,p_attribute20 in varchar2 default hr_api.g_varchar2
742: ) is
743: --
744: -- Declare cursors and local variables
737: ,p_attribute16 in varchar2 default hr_api.g_varchar2
738: ,p_attribute17 in varchar2 default hr_api.g_varchar2
739: ,p_attribute18 in varchar2 default hr_api.g_varchar2
740: ,p_attribute19 in varchar2 default hr_api.g_varchar2
741: ,p_attribute20 in varchar2 default hr_api.g_varchar2
742: ) is
743: --
744: -- Declare cursors and local variables
745: --
827: ,p_attribute19 => p_attribute19
828: ,p_attribute20 => p_attribute20
829: );
830: exception
831: when hr_api.cannot_find_prog_unit then
832: p_object_version_number := l_temp_ovn;
833: hr_api.cannot_find_prog_unit_error
834: (p_module_name => 'UPDATE_collective_agreement'
835: ,p_hook_type => 'BP'
829: );
830: exception
831: when hr_api.cannot_find_prog_unit then
832: p_object_version_number := l_temp_ovn;
833: hr_api.cannot_find_prog_unit_error
834: (p_module_name => 'UPDATE_collective_agreement'
835: ,p_hook_type => 'BP'
836: );
837: --
966: ,p_attribute19 => p_attribute19
967: ,p_attribute20 => p_attribute20
968: );
969: exception
970: when hr_api.cannot_find_prog_unit then
971: p_object_version_number := l_temp_ovn;
972: hr_api.cannot_find_prog_unit_error
973: (p_module_name => 'UPDATE_collective_agreement'
974: ,p_hook_type => 'AP'
968: );
969: exception
970: when hr_api.cannot_find_prog_unit then
971: p_object_version_number := l_temp_ovn;
972: hr_api.cannot_find_prog_unit_error
973: (p_module_name => 'UPDATE_collective_agreement'
974: ,p_hook_type => 'AP'
975: );
976: --
982: --
983: -- When in validation only mode raise the Validate_Enabled exception
984: --
985: if p_validate then
986: raise hr_api.validate_enabled;
987: end if;
988: --
989: -- Set all output arguments
990: --
993: hr_utility.set_location(' Leaving:'||l_proc, 70);
994: --
995: exception
996: --
997: when hr_api.validate_enabled then
998: --
999: -- As the Validate_Enabled exception has been raised
1000: -- we must rollback to the savepoint
1001: --
1082: (p_collective_agreement_id => p_collective_agreement_id
1083: ,p_object_version_number => p_object_version_number);
1084: --
1085: exception
1086: when hr_api.cannot_find_prog_unit then
1087: hr_api.cannot_find_prog_unit_error
1088: (p_module_name => 'DELETE_collective_agreement'
1089: ,p_hook_type => 'BP'
1090: );
1083: ,p_object_version_number => p_object_version_number);
1084: --
1085: exception
1086: when hr_api.cannot_find_prog_unit then
1087: hr_api.cannot_find_prog_unit_error
1088: (p_module_name => 'DELETE_collective_agreement'
1089: ,p_hook_type => 'BP'
1090: );
1091: --
1190: p_collective_agreement_id => p_collective_agreement_id
1191: ,p_object_version_number => l_object_version_number
1192: );
1193: exception
1194: when hr_api.cannot_find_prog_unit then
1195: hr_api.cannot_find_prog_unit_error
1196: (p_module_name => 'DELETE_collective_agreement'
1197: ,p_hook_type => 'AP'
1198: );
1191: ,p_object_version_number => l_object_version_number
1192: );
1193: exception
1194: when hr_api.cannot_find_prog_unit then
1195: hr_api.cannot_find_prog_unit_error
1196: (p_module_name => 'DELETE_collective_agreement'
1197: ,p_hook_type => 'AP'
1198: );
1199: --
1205: --
1206: -- When in validation only mode raise the Validate_Enabled exception
1207: --
1208: if p_validate then
1209: raise hr_api.validate_enabled;
1210: end if;
1211: --
1212: hr_utility.set_location(' Leaving:'||l_proc, 70);
1213: --
1212: hr_utility.set_location(' Leaving:'||l_proc, 70);
1213: --
1214: exception
1215: --
1216: when hr_api.validate_enabled then
1217: --
1218: -- As the Validate_Enabled exception has been raised
1219: -- we must rollback to the savepoint
1220: --