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

APPS.HR_COLLECTIVE_AGREEMENT_API dependencies on HR_API

Line 407: when hr_api.cannot_find_prog_unit then

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'

Line 408: hr_api.cannot_find_prog_unit_error

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

Line 625: when hr_api.cannot_find_prog_unit then

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

Line 626: hr_api.cannot_find_prog_unit_error

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

Line 640: raise hr_api.validate_enabled;

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

Line 652: when hr_api.validate_enabled then

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

Line 685: ,p_business_group_id in number default hr_api.g_number

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

Line 687: ,p_name in varchar2 default hr_api.g_varchar2

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

Line 688: ,p_status in varchar2 default hr_api.g_varchar2

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

Line 689: ,p_cag_number in number default hr_api.g_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
693: ,p_employer_organization_id in number default hr_api.g_number

Line 690: ,p_description in varchar2 default hr_api.g_varchar2

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

Line 691: ,p_start_date in date default hr_api.g_date

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

Line 692: ,p_end_date in date default hr_api.g_date

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

Line 693: ,p_employer_organization_id in number default hr_api.g_number

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

Line 694: ,p_employer_signatory 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

Line 695: ,p_bargaining_organization_id in number default hr_api.g_number

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

Line 696: ,p_bargaining_unit_signatory in varchar2 default hr_api.g_varchar2

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

Line 697: ,p_jurisdiction 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

Line 698: ,p_authorizing_body 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

Line 699: ,p_authorized_date in date default hr_api.g_date

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

Line 700: ,p_cag_information_category 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

Line 701: ,p_cag_information1 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

Line 702: ,p_cag_information2 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

Line 703: ,p_cag_information3 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

Line 704: ,p_cag_information4 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

Line 705: ,p_cag_information5 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

Line 706: ,p_cag_information6 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

Line 707: ,p_cag_information7 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

Line 708: ,p_cag_information8 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

Line 709: ,p_cag_information9 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

Line 710: ,p_cag_information10 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

Line 711: ,p_cag_information11 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

Line 712: ,p_cag_information12 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

Line 713: ,p_cag_information13 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

Line 714: ,p_cag_information14 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

Line 715: ,p_cag_information15 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

Line 716: ,p_cag_information16 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

Line 717: ,p_cag_information17 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

Line 718: ,p_cag_information18 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

Line 719: ,p_cag_information19 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

Line 720: ,p_cag_information20 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 740: ,p_attribute19 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: --
744: -- Declare cursors and local variables

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

Line 831: when hr_api.cannot_find_prog_unit then

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'

Line 833: hr_api.cannot_find_prog_unit_error

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

Line 970: when hr_api.cannot_find_prog_unit then

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'

Line 972: hr_api.cannot_find_prog_unit_error

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

Line 986: raise hr_api.validate_enabled;

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

Line 997: when hr_api.validate_enabled then

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

Line 1086: when hr_api.cannot_find_prog_unit then

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

Line 1087: hr_api.cannot_find_prog_unit_error

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

Line 1194: when hr_api.cannot_find_prog_unit then

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

Line 1195: hr_api.cannot_find_prog_unit_error

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

Line 1209: raise hr_api.validate_enabled;

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

Line 1216: when hr_api.validate_enabled then

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