54: hr_utility.set_location('Entering:'|| l_proc, 10);
55: --
56: -- Ensure that all the mandatory parameter are not null
57: --
58: hr_api.mandatory_arg_error
59: (p_api_name => l_proc
60: ,p_argument => 'organization_link_id'
61: ,p_argument_value => p_organization_link_id
62: );
77: close csr_sec_grp;
78: --
79: -- Set the security_group_id in CLIENT_INFO
80: --
81: hr_api.set_security_group_id
82: (p_security_group_id => l_security_group_id
83: );
84: --
85: hr_utility.set_location(' Leaving:'|| l_proc, 20);
114: hr_utility.set_location('Entering:'|| l_proc, 10);
115: --
116: -- Ensure that all the mandatory parameter are not null
117: --
118: hr_api.mandatory_arg_error
119: (p_api_name => l_proc
120: ,p_argument => 'organization_link_id'
121: ,p_argument_value => p_organization_link_id
122: );
120: ,p_argument => 'organization_link_id'
121: ,p_argument_value => p_organization_link_id
122: );
123: --
124: if ( nvl(hr_ord_bus.g_organization_link_id, hr_api.g_number)
125: = p_organization_link_id) then
126: --
127: -- The legislation code has already been found with a previous
128: -- call to this function. Just return the value in the global
215: --
216: --
217: -- Check mandatory parameters have been set
218: --
219: hr_api.mandatory_arg_error
220: (p_api_name => l_proc
221: ,p_argument => 'parent_organization_id'
222: ,p_argument_value => p_parent_organization_id);
223: --
322: --
323: --
324: -- Check mandatory parameters have been set
325: --
326: hr_api.mandatory_arg_error
327: (p_api_name => l_proc
328: ,p_argument => 'child_organization_id'
329: ,p_argument_value => p_child_organization_id);
330: --
407: --
408: --
409: -- Check mandatory parameters have been set
410: --
411: hr_api.mandatory_arg_error
412: (p_api_name => l_proc
413: ,p_argument => 'org_link_type'
414: ,p_argument_value => p_org_link_type);
415: --
418: --
419: -- Check that the org link type exists in hr_lookups for the
420: -- lookup type 'DE_LINK_TYPE'.
421: --
422: if hr_api.not_exists_in_hr_lookups
423: (p_effective_date => p_effective_date
424: ,p_lookup_type => 'DE_LINK_TYPE'
425: ,p_lookup_code => p_org_link_type) then
426: hr_utility.set_message(800, 'HR_DE_LINK_TYPE_CHK');
605: -- Check that the information category matches the link type if the link type is either
606: -- 'DE_SOCIAL_INSURANCE' or 'DE_LIABILITY_INSURANCE'.
607: --
608: if p_org_link_type in ('DE_SOCIAL_INSURANCE', 'DE_LIABILITY_INSURANCE') then
609: if not (nvl(p_org_link_info_category, hr_api.g_varchar2) = p_org_link_type) then
610: fnd_message.set_name('PER', 'HR_DE_LINK_TYPE_MAN_CHK');
611: fnd_message.raise_error;
612: end if;
613: end if;
697: begin
698: hr_utility.set_location('Entering:'||l_proc,10);
699: --
700: if ((p_rec.organization_link_id is not null) and (
701: nvl(hr_ord_shd.g_old_rec.org_link_information_category, hr_api.g_varchar2) <>
702: nvl(p_rec.org_link_information_category, hr_api.g_varchar2) or
703: nvl(hr_ord_shd.g_old_rec.org_link_information1, hr_api.g_varchar2) <>
704: nvl(p_rec.org_link_information1, hr_api.g_varchar2) or
705: nvl(hr_ord_shd.g_old_rec.org_link_information2, hr_api.g_varchar2) <>
698: hr_utility.set_location('Entering:'||l_proc,10);
699: --
700: if ((p_rec.organization_link_id is not null) and (
701: nvl(hr_ord_shd.g_old_rec.org_link_information_category, hr_api.g_varchar2) <>
702: nvl(p_rec.org_link_information_category, hr_api.g_varchar2) or
703: nvl(hr_ord_shd.g_old_rec.org_link_information1, hr_api.g_varchar2) <>
704: nvl(p_rec.org_link_information1, hr_api.g_varchar2) or
705: nvl(hr_ord_shd.g_old_rec.org_link_information2, hr_api.g_varchar2) <>
706: nvl(p_rec.org_link_information2, hr_api.g_varchar2) or
699: --
700: if ((p_rec.organization_link_id is not null) and (
701: nvl(hr_ord_shd.g_old_rec.org_link_information_category, hr_api.g_varchar2) <>
702: nvl(p_rec.org_link_information_category, hr_api.g_varchar2) or
703: nvl(hr_ord_shd.g_old_rec.org_link_information1, hr_api.g_varchar2) <>
704: nvl(p_rec.org_link_information1, hr_api.g_varchar2) or
705: nvl(hr_ord_shd.g_old_rec.org_link_information2, hr_api.g_varchar2) <>
706: nvl(p_rec.org_link_information2, hr_api.g_varchar2) or
707: nvl(hr_ord_shd.g_old_rec.org_link_information3, hr_api.g_varchar2) <>
700: if ((p_rec.organization_link_id is not null) and (
701: nvl(hr_ord_shd.g_old_rec.org_link_information_category, hr_api.g_varchar2) <>
702: nvl(p_rec.org_link_information_category, hr_api.g_varchar2) or
703: nvl(hr_ord_shd.g_old_rec.org_link_information1, hr_api.g_varchar2) <>
704: nvl(p_rec.org_link_information1, hr_api.g_varchar2) or
705: nvl(hr_ord_shd.g_old_rec.org_link_information2, hr_api.g_varchar2) <>
706: nvl(p_rec.org_link_information2, hr_api.g_varchar2) or
707: nvl(hr_ord_shd.g_old_rec.org_link_information3, hr_api.g_varchar2) <>
708: nvl(p_rec.org_link_information3, hr_api.g_varchar2) or
701: nvl(hr_ord_shd.g_old_rec.org_link_information_category, hr_api.g_varchar2) <>
702: nvl(p_rec.org_link_information_category, hr_api.g_varchar2) or
703: nvl(hr_ord_shd.g_old_rec.org_link_information1, hr_api.g_varchar2) <>
704: nvl(p_rec.org_link_information1, hr_api.g_varchar2) or
705: nvl(hr_ord_shd.g_old_rec.org_link_information2, hr_api.g_varchar2) <>
706: nvl(p_rec.org_link_information2, hr_api.g_varchar2) or
707: nvl(hr_ord_shd.g_old_rec.org_link_information3, hr_api.g_varchar2) <>
708: nvl(p_rec.org_link_information3, hr_api.g_varchar2) or
709: nvl(hr_ord_shd.g_old_rec.org_link_information4, hr_api.g_varchar2) <>
702: nvl(p_rec.org_link_information_category, hr_api.g_varchar2) or
703: nvl(hr_ord_shd.g_old_rec.org_link_information1, hr_api.g_varchar2) <>
704: nvl(p_rec.org_link_information1, hr_api.g_varchar2) or
705: nvl(hr_ord_shd.g_old_rec.org_link_information2, hr_api.g_varchar2) <>
706: nvl(p_rec.org_link_information2, hr_api.g_varchar2) or
707: nvl(hr_ord_shd.g_old_rec.org_link_information3, hr_api.g_varchar2) <>
708: nvl(p_rec.org_link_information3, hr_api.g_varchar2) or
709: nvl(hr_ord_shd.g_old_rec.org_link_information4, hr_api.g_varchar2) <>
710: nvl(p_rec.org_link_information4, hr_api.g_varchar2) or
703: nvl(hr_ord_shd.g_old_rec.org_link_information1, hr_api.g_varchar2) <>
704: nvl(p_rec.org_link_information1, hr_api.g_varchar2) or
705: nvl(hr_ord_shd.g_old_rec.org_link_information2, hr_api.g_varchar2) <>
706: nvl(p_rec.org_link_information2, hr_api.g_varchar2) or
707: nvl(hr_ord_shd.g_old_rec.org_link_information3, hr_api.g_varchar2) <>
708: nvl(p_rec.org_link_information3, hr_api.g_varchar2) or
709: nvl(hr_ord_shd.g_old_rec.org_link_information4, hr_api.g_varchar2) <>
710: nvl(p_rec.org_link_information4, hr_api.g_varchar2) or
711: nvl(hr_ord_shd.g_old_rec.org_link_information5, hr_api.g_varchar2) <>
704: nvl(p_rec.org_link_information1, hr_api.g_varchar2) or
705: nvl(hr_ord_shd.g_old_rec.org_link_information2, hr_api.g_varchar2) <>
706: nvl(p_rec.org_link_information2, hr_api.g_varchar2) or
707: nvl(hr_ord_shd.g_old_rec.org_link_information3, hr_api.g_varchar2) <>
708: nvl(p_rec.org_link_information3, hr_api.g_varchar2) or
709: nvl(hr_ord_shd.g_old_rec.org_link_information4, hr_api.g_varchar2) <>
710: nvl(p_rec.org_link_information4, hr_api.g_varchar2) or
711: nvl(hr_ord_shd.g_old_rec.org_link_information5, hr_api.g_varchar2) <>
712: nvl(p_rec.org_link_information5, hr_api.g_varchar2) or
705: nvl(hr_ord_shd.g_old_rec.org_link_information2, hr_api.g_varchar2) <>
706: nvl(p_rec.org_link_information2, hr_api.g_varchar2) or
707: nvl(hr_ord_shd.g_old_rec.org_link_information3, hr_api.g_varchar2) <>
708: nvl(p_rec.org_link_information3, hr_api.g_varchar2) or
709: nvl(hr_ord_shd.g_old_rec.org_link_information4, hr_api.g_varchar2) <>
710: nvl(p_rec.org_link_information4, hr_api.g_varchar2) or
711: nvl(hr_ord_shd.g_old_rec.org_link_information5, hr_api.g_varchar2) <>
712: nvl(p_rec.org_link_information5, hr_api.g_varchar2) or
713: nvl(hr_ord_shd.g_old_rec.org_link_information6, hr_api.g_varchar2) <>
706: nvl(p_rec.org_link_information2, hr_api.g_varchar2) or
707: nvl(hr_ord_shd.g_old_rec.org_link_information3, hr_api.g_varchar2) <>
708: nvl(p_rec.org_link_information3, hr_api.g_varchar2) or
709: nvl(hr_ord_shd.g_old_rec.org_link_information4, hr_api.g_varchar2) <>
710: nvl(p_rec.org_link_information4, hr_api.g_varchar2) or
711: nvl(hr_ord_shd.g_old_rec.org_link_information5, hr_api.g_varchar2) <>
712: nvl(p_rec.org_link_information5, hr_api.g_varchar2) or
713: nvl(hr_ord_shd.g_old_rec.org_link_information6, hr_api.g_varchar2) <>
714: nvl(p_rec.org_link_information6, hr_api.g_varchar2) or
707: nvl(hr_ord_shd.g_old_rec.org_link_information3, hr_api.g_varchar2) <>
708: nvl(p_rec.org_link_information3, hr_api.g_varchar2) or
709: nvl(hr_ord_shd.g_old_rec.org_link_information4, hr_api.g_varchar2) <>
710: nvl(p_rec.org_link_information4, hr_api.g_varchar2) or
711: nvl(hr_ord_shd.g_old_rec.org_link_information5, hr_api.g_varchar2) <>
712: nvl(p_rec.org_link_information5, hr_api.g_varchar2) or
713: nvl(hr_ord_shd.g_old_rec.org_link_information6, hr_api.g_varchar2) <>
714: nvl(p_rec.org_link_information6, hr_api.g_varchar2) or
715: nvl(hr_ord_shd.g_old_rec.org_link_information7, hr_api.g_varchar2) <>
708: nvl(p_rec.org_link_information3, hr_api.g_varchar2) or
709: nvl(hr_ord_shd.g_old_rec.org_link_information4, hr_api.g_varchar2) <>
710: nvl(p_rec.org_link_information4, hr_api.g_varchar2) or
711: nvl(hr_ord_shd.g_old_rec.org_link_information5, hr_api.g_varchar2) <>
712: nvl(p_rec.org_link_information5, hr_api.g_varchar2) or
713: nvl(hr_ord_shd.g_old_rec.org_link_information6, hr_api.g_varchar2) <>
714: nvl(p_rec.org_link_information6, hr_api.g_varchar2) or
715: nvl(hr_ord_shd.g_old_rec.org_link_information7, hr_api.g_varchar2) <>
716: nvl(p_rec.org_link_information7, hr_api.g_varchar2) or
709: nvl(hr_ord_shd.g_old_rec.org_link_information4, hr_api.g_varchar2) <>
710: nvl(p_rec.org_link_information4, hr_api.g_varchar2) or
711: nvl(hr_ord_shd.g_old_rec.org_link_information5, hr_api.g_varchar2) <>
712: nvl(p_rec.org_link_information5, hr_api.g_varchar2) or
713: nvl(hr_ord_shd.g_old_rec.org_link_information6, hr_api.g_varchar2) <>
714: nvl(p_rec.org_link_information6, hr_api.g_varchar2) or
715: nvl(hr_ord_shd.g_old_rec.org_link_information7, hr_api.g_varchar2) <>
716: nvl(p_rec.org_link_information7, hr_api.g_varchar2) or
717: nvl(hr_ord_shd.g_old_rec.org_link_information8, hr_api.g_varchar2) <>
710: nvl(p_rec.org_link_information4, hr_api.g_varchar2) or
711: nvl(hr_ord_shd.g_old_rec.org_link_information5, hr_api.g_varchar2) <>
712: nvl(p_rec.org_link_information5, hr_api.g_varchar2) or
713: nvl(hr_ord_shd.g_old_rec.org_link_information6, hr_api.g_varchar2) <>
714: nvl(p_rec.org_link_information6, hr_api.g_varchar2) or
715: nvl(hr_ord_shd.g_old_rec.org_link_information7, hr_api.g_varchar2) <>
716: nvl(p_rec.org_link_information7, hr_api.g_varchar2) or
717: nvl(hr_ord_shd.g_old_rec.org_link_information8, hr_api.g_varchar2) <>
718: nvl(p_rec.org_link_information8, hr_api.g_varchar2) or
711: nvl(hr_ord_shd.g_old_rec.org_link_information5, hr_api.g_varchar2) <>
712: nvl(p_rec.org_link_information5, hr_api.g_varchar2) or
713: nvl(hr_ord_shd.g_old_rec.org_link_information6, hr_api.g_varchar2) <>
714: nvl(p_rec.org_link_information6, hr_api.g_varchar2) or
715: nvl(hr_ord_shd.g_old_rec.org_link_information7, hr_api.g_varchar2) <>
716: nvl(p_rec.org_link_information7, hr_api.g_varchar2) or
717: nvl(hr_ord_shd.g_old_rec.org_link_information8, hr_api.g_varchar2) <>
718: nvl(p_rec.org_link_information8, hr_api.g_varchar2) or
719: nvl(hr_ord_shd.g_old_rec.org_link_information9, hr_api.g_varchar2) <>
712: nvl(p_rec.org_link_information5, hr_api.g_varchar2) or
713: nvl(hr_ord_shd.g_old_rec.org_link_information6, hr_api.g_varchar2) <>
714: nvl(p_rec.org_link_information6, hr_api.g_varchar2) or
715: nvl(hr_ord_shd.g_old_rec.org_link_information7, hr_api.g_varchar2) <>
716: nvl(p_rec.org_link_information7, hr_api.g_varchar2) or
717: nvl(hr_ord_shd.g_old_rec.org_link_information8, hr_api.g_varchar2) <>
718: nvl(p_rec.org_link_information8, hr_api.g_varchar2) or
719: nvl(hr_ord_shd.g_old_rec.org_link_information9, hr_api.g_varchar2) <>
720: nvl(p_rec.org_link_information9, hr_api.g_varchar2) or
713: nvl(hr_ord_shd.g_old_rec.org_link_information6, hr_api.g_varchar2) <>
714: nvl(p_rec.org_link_information6, hr_api.g_varchar2) or
715: nvl(hr_ord_shd.g_old_rec.org_link_information7, hr_api.g_varchar2) <>
716: nvl(p_rec.org_link_information7, hr_api.g_varchar2) or
717: nvl(hr_ord_shd.g_old_rec.org_link_information8, hr_api.g_varchar2) <>
718: nvl(p_rec.org_link_information8, hr_api.g_varchar2) or
719: nvl(hr_ord_shd.g_old_rec.org_link_information9, hr_api.g_varchar2) <>
720: nvl(p_rec.org_link_information9, hr_api.g_varchar2) or
721: nvl(hr_ord_shd.g_old_rec.org_link_information10, hr_api.g_varchar2) <>
714: nvl(p_rec.org_link_information6, hr_api.g_varchar2) or
715: nvl(hr_ord_shd.g_old_rec.org_link_information7, hr_api.g_varchar2) <>
716: nvl(p_rec.org_link_information7, hr_api.g_varchar2) or
717: nvl(hr_ord_shd.g_old_rec.org_link_information8, hr_api.g_varchar2) <>
718: nvl(p_rec.org_link_information8, hr_api.g_varchar2) or
719: nvl(hr_ord_shd.g_old_rec.org_link_information9, hr_api.g_varchar2) <>
720: nvl(p_rec.org_link_information9, hr_api.g_varchar2) or
721: nvl(hr_ord_shd.g_old_rec.org_link_information10, hr_api.g_varchar2) <>
722: nvl(p_rec.org_link_information10, hr_api.g_varchar2) or
715: nvl(hr_ord_shd.g_old_rec.org_link_information7, hr_api.g_varchar2) <>
716: nvl(p_rec.org_link_information7, hr_api.g_varchar2) or
717: nvl(hr_ord_shd.g_old_rec.org_link_information8, hr_api.g_varchar2) <>
718: nvl(p_rec.org_link_information8, hr_api.g_varchar2) or
719: nvl(hr_ord_shd.g_old_rec.org_link_information9, hr_api.g_varchar2) <>
720: nvl(p_rec.org_link_information9, hr_api.g_varchar2) or
721: nvl(hr_ord_shd.g_old_rec.org_link_information10, hr_api.g_varchar2) <>
722: nvl(p_rec.org_link_information10, hr_api.g_varchar2) or
723: nvl(hr_ord_shd.g_old_rec.org_link_information11, hr_api.g_varchar2) <>
716: nvl(p_rec.org_link_information7, hr_api.g_varchar2) or
717: nvl(hr_ord_shd.g_old_rec.org_link_information8, hr_api.g_varchar2) <>
718: nvl(p_rec.org_link_information8, hr_api.g_varchar2) or
719: nvl(hr_ord_shd.g_old_rec.org_link_information9, hr_api.g_varchar2) <>
720: nvl(p_rec.org_link_information9, hr_api.g_varchar2) or
721: nvl(hr_ord_shd.g_old_rec.org_link_information10, hr_api.g_varchar2) <>
722: nvl(p_rec.org_link_information10, hr_api.g_varchar2) or
723: nvl(hr_ord_shd.g_old_rec.org_link_information11, hr_api.g_varchar2) <>
724: nvl(p_rec.org_link_information11, hr_api.g_varchar2) or
717: nvl(hr_ord_shd.g_old_rec.org_link_information8, hr_api.g_varchar2) <>
718: nvl(p_rec.org_link_information8, hr_api.g_varchar2) or
719: nvl(hr_ord_shd.g_old_rec.org_link_information9, hr_api.g_varchar2) <>
720: nvl(p_rec.org_link_information9, hr_api.g_varchar2) or
721: nvl(hr_ord_shd.g_old_rec.org_link_information10, hr_api.g_varchar2) <>
722: nvl(p_rec.org_link_information10, hr_api.g_varchar2) or
723: nvl(hr_ord_shd.g_old_rec.org_link_information11, hr_api.g_varchar2) <>
724: nvl(p_rec.org_link_information11, hr_api.g_varchar2) or
725: nvl(hr_ord_shd.g_old_rec.org_link_information12, hr_api.g_varchar2) <>
718: nvl(p_rec.org_link_information8, hr_api.g_varchar2) or
719: nvl(hr_ord_shd.g_old_rec.org_link_information9, hr_api.g_varchar2) <>
720: nvl(p_rec.org_link_information9, hr_api.g_varchar2) or
721: nvl(hr_ord_shd.g_old_rec.org_link_information10, hr_api.g_varchar2) <>
722: nvl(p_rec.org_link_information10, hr_api.g_varchar2) or
723: nvl(hr_ord_shd.g_old_rec.org_link_information11, hr_api.g_varchar2) <>
724: nvl(p_rec.org_link_information11, hr_api.g_varchar2) or
725: nvl(hr_ord_shd.g_old_rec.org_link_information12, hr_api.g_varchar2) <>
726: nvl(p_rec.org_link_information12, hr_api.g_varchar2) or
719: nvl(hr_ord_shd.g_old_rec.org_link_information9, hr_api.g_varchar2) <>
720: nvl(p_rec.org_link_information9, hr_api.g_varchar2) or
721: nvl(hr_ord_shd.g_old_rec.org_link_information10, hr_api.g_varchar2) <>
722: nvl(p_rec.org_link_information10, hr_api.g_varchar2) or
723: nvl(hr_ord_shd.g_old_rec.org_link_information11, hr_api.g_varchar2) <>
724: nvl(p_rec.org_link_information11, hr_api.g_varchar2) or
725: nvl(hr_ord_shd.g_old_rec.org_link_information12, hr_api.g_varchar2) <>
726: nvl(p_rec.org_link_information12, hr_api.g_varchar2) or
727: nvl(hr_ord_shd.g_old_rec.org_link_information13, hr_api.g_varchar2) <>
720: nvl(p_rec.org_link_information9, hr_api.g_varchar2) or
721: nvl(hr_ord_shd.g_old_rec.org_link_information10, hr_api.g_varchar2) <>
722: nvl(p_rec.org_link_information10, hr_api.g_varchar2) or
723: nvl(hr_ord_shd.g_old_rec.org_link_information11, hr_api.g_varchar2) <>
724: nvl(p_rec.org_link_information11, hr_api.g_varchar2) or
725: nvl(hr_ord_shd.g_old_rec.org_link_information12, hr_api.g_varchar2) <>
726: nvl(p_rec.org_link_information12, hr_api.g_varchar2) or
727: nvl(hr_ord_shd.g_old_rec.org_link_information13, hr_api.g_varchar2) <>
728: nvl(p_rec.org_link_information13, hr_api.g_varchar2) or
721: nvl(hr_ord_shd.g_old_rec.org_link_information10, hr_api.g_varchar2) <>
722: nvl(p_rec.org_link_information10, hr_api.g_varchar2) or
723: nvl(hr_ord_shd.g_old_rec.org_link_information11, hr_api.g_varchar2) <>
724: nvl(p_rec.org_link_information11, hr_api.g_varchar2) or
725: nvl(hr_ord_shd.g_old_rec.org_link_information12, hr_api.g_varchar2) <>
726: nvl(p_rec.org_link_information12, hr_api.g_varchar2) or
727: nvl(hr_ord_shd.g_old_rec.org_link_information13, hr_api.g_varchar2) <>
728: nvl(p_rec.org_link_information13, hr_api.g_varchar2) or
729: nvl(hr_ord_shd.g_old_rec.org_link_information14, hr_api.g_varchar2) <>
722: nvl(p_rec.org_link_information10, hr_api.g_varchar2) or
723: nvl(hr_ord_shd.g_old_rec.org_link_information11, hr_api.g_varchar2) <>
724: nvl(p_rec.org_link_information11, hr_api.g_varchar2) or
725: nvl(hr_ord_shd.g_old_rec.org_link_information12, hr_api.g_varchar2) <>
726: nvl(p_rec.org_link_information12, hr_api.g_varchar2) or
727: nvl(hr_ord_shd.g_old_rec.org_link_information13, hr_api.g_varchar2) <>
728: nvl(p_rec.org_link_information13, hr_api.g_varchar2) or
729: nvl(hr_ord_shd.g_old_rec.org_link_information14, hr_api.g_varchar2) <>
730: nvl(p_rec.org_link_information14, hr_api.g_varchar2) or
723: nvl(hr_ord_shd.g_old_rec.org_link_information11, hr_api.g_varchar2) <>
724: nvl(p_rec.org_link_information11, hr_api.g_varchar2) or
725: nvl(hr_ord_shd.g_old_rec.org_link_information12, hr_api.g_varchar2) <>
726: nvl(p_rec.org_link_information12, hr_api.g_varchar2) or
727: nvl(hr_ord_shd.g_old_rec.org_link_information13, hr_api.g_varchar2) <>
728: nvl(p_rec.org_link_information13, hr_api.g_varchar2) or
729: nvl(hr_ord_shd.g_old_rec.org_link_information14, hr_api.g_varchar2) <>
730: nvl(p_rec.org_link_information14, hr_api.g_varchar2) or
731: nvl(hr_ord_shd.g_old_rec.org_link_information15, hr_api.g_varchar2) <>
724: nvl(p_rec.org_link_information11, hr_api.g_varchar2) or
725: nvl(hr_ord_shd.g_old_rec.org_link_information12, hr_api.g_varchar2) <>
726: nvl(p_rec.org_link_information12, hr_api.g_varchar2) or
727: nvl(hr_ord_shd.g_old_rec.org_link_information13, hr_api.g_varchar2) <>
728: nvl(p_rec.org_link_information13, hr_api.g_varchar2) or
729: nvl(hr_ord_shd.g_old_rec.org_link_information14, hr_api.g_varchar2) <>
730: nvl(p_rec.org_link_information14, hr_api.g_varchar2) or
731: nvl(hr_ord_shd.g_old_rec.org_link_information15, hr_api.g_varchar2) <>
732: nvl(p_rec.org_link_information15, hr_api.g_varchar2) or
725: nvl(hr_ord_shd.g_old_rec.org_link_information12, hr_api.g_varchar2) <>
726: nvl(p_rec.org_link_information12, hr_api.g_varchar2) or
727: nvl(hr_ord_shd.g_old_rec.org_link_information13, hr_api.g_varchar2) <>
728: nvl(p_rec.org_link_information13, hr_api.g_varchar2) or
729: nvl(hr_ord_shd.g_old_rec.org_link_information14, hr_api.g_varchar2) <>
730: nvl(p_rec.org_link_information14, hr_api.g_varchar2) or
731: nvl(hr_ord_shd.g_old_rec.org_link_information15, hr_api.g_varchar2) <>
732: nvl(p_rec.org_link_information15, hr_api.g_varchar2) or
733: nvl(hr_ord_shd.g_old_rec.org_link_information16, hr_api.g_varchar2) <>
726: nvl(p_rec.org_link_information12, hr_api.g_varchar2) or
727: nvl(hr_ord_shd.g_old_rec.org_link_information13, hr_api.g_varchar2) <>
728: nvl(p_rec.org_link_information13, hr_api.g_varchar2) or
729: nvl(hr_ord_shd.g_old_rec.org_link_information14, hr_api.g_varchar2) <>
730: nvl(p_rec.org_link_information14, hr_api.g_varchar2) or
731: nvl(hr_ord_shd.g_old_rec.org_link_information15, hr_api.g_varchar2) <>
732: nvl(p_rec.org_link_information15, hr_api.g_varchar2) or
733: nvl(hr_ord_shd.g_old_rec.org_link_information16, hr_api.g_varchar2) <>
734: nvl(p_rec.org_link_information16, hr_api.g_varchar2) or
727: nvl(hr_ord_shd.g_old_rec.org_link_information13, hr_api.g_varchar2) <>
728: nvl(p_rec.org_link_information13, hr_api.g_varchar2) or
729: nvl(hr_ord_shd.g_old_rec.org_link_information14, hr_api.g_varchar2) <>
730: nvl(p_rec.org_link_information14, hr_api.g_varchar2) or
731: nvl(hr_ord_shd.g_old_rec.org_link_information15, hr_api.g_varchar2) <>
732: nvl(p_rec.org_link_information15, hr_api.g_varchar2) or
733: nvl(hr_ord_shd.g_old_rec.org_link_information16, hr_api.g_varchar2) <>
734: nvl(p_rec.org_link_information16, hr_api.g_varchar2) or
735: nvl(hr_ord_shd.g_old_rec.org_link_information17, hr_api.g_varchar2) <>
728: nvl(p_rec.org_link_information13, hr_api.g_varchar2) or
729: nvl(hr_ord_shd.g_old_rec.org_link_information14, hr_api.g_varchar2) <>
730: nvl(p_rec.org_link_information14, hr_api.g_varchar2) or
731: nvl(hr_ord_shd.g_old_rec.org_link_information15, hr_api.g_varchar2) <>
732: nvl(p_rec.org_link_information15, hr_api.g_varchar2) or
733: nvl(hr_ord_shd.g_old_rec.org_link_information16, hr_api.g_varchar2) <>
734: nvl(p_rec.org_link_information16, hr_api.g_varchar2) or
735: nvl(hr_ord_shd.g_old_rec.org_link_information17, hr_api.g_varchar2) <>
736: nvl(p_rec.org_link_information17, hr_api.g_varchar2) or
729: nvl(hr_ord_shd.g_old_rec.org_link_information14, hr_api.g_varchar2) <>
730: nvl(p_rec.org_link_information14, hr_api.g_varchar2) or
731: nvl(hr_ord_shd.g_old_rec.org_link_information15, hr_api.g_varchar2) <>
732: nvl(p_rec.org_link_information15, hr_api.g_varchar2) or
733: nvl(hr_ord_shd.g_old_rec.org_link_information16, hr_api.g_varchar2) <>
734: nvl(p_rec.org_link_information16, hr_api.g_varchar2) or
735: nvl(hr_ord_shd.g_old_rec.org_link_information17, hr_api.g_varchar2) <>
736: nvl(p_rec.org_link_information17, hr_api.g_varchar2) or
737: nvl(hr_ord_shd.g_old_rec.org_link_information18, hr_api.g_varchar2) <>
730: nvl(p_rec.org_link_information14, hr_api.g_varchar2) or
731: nvl(hr_ord_shd.g_old_rec.org_link_information15, hr_api.g_varchar2) <>
732: nvl(p_rec.org_link_information15, hr_api.g_varchar2) or
733: nvl(hr_ord_shd.g_old_rec.org_link_information16, hr_api.g_varchar2) <>
734: nvl(p_rec.org_link_information16, hr_api.g_varchar2) or
735: nvl(hr_ord_shd.g_old_rec.org_link_information17, hr_api.g_varchar2) <>
736: nvl(p_rec.org_link_information17, hr_api.g_varchar2) or
737: nvl(hr_ord_shd.g_old_rec.org_link_information18, hr_api.g_varchar2) <>
738: nvl(p_rec.org_link_information18, hr_api.g_varchar2) or
731: nvl(hr_ord_shd.g_old_rec.org_link_information15, hr_api.g_varchar2) <>
732: nvl(p_rec.org_link_information15, hr_api.g_varchar2) or
733: nvl(hr_ord_shd.g_old_rec.org_link_information16, hr_api.g_varchar2) <>
734: nvl(p_rec.org_link_information16, hr_api.g_varchar2) or
735: nvl(hr_ord_shd.g_old_rec.org_link_information17, hr_api.g_varchar2) <>
736: nvl(p_rec.org_link_information17, hr_api.g_varchar2) or
737: nvl(hr_ord_shd.g_old_rec.org_link_information18, hr_api.g_varchar2) <>
738: nvl(p_rec.org_link_information18, hr_api.g_varchar2) or
739: nvl(hr_ord_shd.g_old_rec.org_link_information19, hr_api.g_varchar2) <>
732: nvl(p_rec.org_link_information15, hr_api.g_varchar2) or
733: nvl(hr_ord_shd.g_old_rec.org_link_information16, hr_api.g_varchar2) <>
734: nvl(p_rec.org_link_information16, hr_api.g_varchar2) or
735: nvl(hr_ord_shd.g_old_rec.org_link_information17, hr_api.g_varchar2) <>
736: nvl(p_rec.org_link_information17, hr_api.g_varchar2) or
737: nvl(hr_ord_shd.g_old_rec.org_link_information18, hr_api.g_varchar2) <>
738: nvl(p_rec.org_link_information18, hr_api.g_varchar2) or
739: nvl(hr_ord_shd.g_old_rec.org_link_information19, hr_api.g_varchar2) <>
740: nvl(p_rec.org_link_information19, hr_api.g_varchar2) or
733: nvl(hr_ord_shd.g_old_rec.org_link_information16, hr_api.g_varchar2) <>
734: nvl(p_rec.org_link_information16, hr_api.g_varchar2) or
735: nvl(hr_ord_shd.g_old_rec.org_link_information17, hr_api.g_varchar2) <>
736: nvl(p_rec.org_link_information17, hr_api.g_varchar2) or
737: nvl(hr_ord_shd.g_old_rec.org_link_information18, hr_api.g_varchar2) <>
738: nvl(p_rec.org_link_information18, hr_api.g_varchar2) or
739: nvl(hr_ord_shd.g_old_rec.org_link_information19, hr_api.g_varchar2) <>
740: nvl(p_rec.org_link_information19, hr_api.g_varchar2) or
741: nvl(hr_ord_shd.g_old_rec.org_link_information20, hr_api.g_varchar2) <>
734: nvl(p_rec.org_link_information16, hr_api.g_varchar2) or
735: nvl(hr_ord_shd.g_old_rec.org_link_information17, hr_api.g_varchar2) <>
736: nvl(p_rec.org_link_information17, hr_api.g_varchar2) or
737: nvl(hr_ord_shd.g_old_rec.org_link_information18, hr_api.g_varchar2) <>
738: nvl(p_rec.org_link_information18, hr_api.g_varchar2) or
739: nvl(hr_ord_shd.g_old_rec.org_link_information19, hr_api.g_varchar2) <>
740: nvl(p_rec.org_link_information19, hr_api.g_varchar2) or
741: nvl(hr_ord_shd.g_old_rec.org_link_information20, hr_api.g_varchar2) <>
742: nvl(p_rec.org_link_information20, hr_api.g_varchar2) or
735: nvl(hr_ord_shd.g_old_rec.org_link_information17, hr_api.g_varchar2) <>
736: nvl(p_rec.org_link_information17, hr_api.g_varchar2) or
737: nvl(hr_ord_shd.g_old_rec.org_link_information18, hr_api.g_varchar2) <>
738: nvl(p_rec.org_link_information18, hr_api.g_varchar2) or
739: nvl(hr_ord_shd.g_old_rec.org_link_information19, hr_api.g_varchar2) <>
740: nvl(p_rec.org_link_information19, hr_api.g_varchar2) or
741: nvl(hr_ord_shd.g_old_rec.org_link_information20, hr_api.g_varchar2) <>
742: nvl(p_rec.org_link_information20, hr_api.g_varchar2) or
743: nvl(hr_ord_shd.g_old_rec.org_link_information21, hr_api.g_varchar2) <>
736: nvl(p_rec.org_link_information17, hr_api.g_varchar2) or
737: nvl(hr_ord_shd.g_old_rec.org_link_information18, hr_api.g_varchar2) <>
738: nvl(p_rec.org_link_information18, hr_api.g_varchar2) or
739: nvl(hr_ord_shd.g_old_rec.org_link_information19, hr_api.g_varchar2) <>
740: nvl(p_rec.org_link_information19, hr_api.g_varchar2) or
741: nvl(hr_ord_shd.g_old_rec.org_link_information20, hr_api.g_varchar2) <>
742: nvl(p_rec.org_link_information20, hr_api.g_varchar2) or
743: nvl(hr_ord_shd.g_old_rec.org_link_information21, hr_api.g_varchar2) <>
744: nvl(p_rec.org_link_information21, hr_api.g_varchar2) or
737: nvl(hr_ord_shd.g_old_rec.org_link_information18, hr_api.g_varchar2) <>
738: nvl(p_rec.org_link_information18, hr_api.g_varchar2) or
739: nvl(hr_ord_shd.g_old_rec.org_link_information19, hr_api.g_varchar2) <>
740: nvl(p_rec.org_link_information19, hr_api.g_varchar2) or
741: nvl(hr_ord_shd.g_old_rec.org_link_information20, hr_api.g_varchar2) <>
742: nvl(p_rec.org_link_information20, hr_api.g_varchar2) or
743: nvl(hr_ord_shd.g_old_rec.org_link_information21, hr_api.g_varchar2) <>
744: nvl(p_rec.org_link_information21, hr_api.g_varchar2) or
745: nvl(hr_ord_shd.g_old_rec.org_link_information22, hr_api.g_varchar2) <>
738: nvl(p_rec.org_link_information18, hr_api.g_varchar2) or
739: nvl(hr_ord_shd.g_old_rec.org_link_information19, hr_api.g_varchar2) <>
740: nvl(p_rec.org_link_information19, hr_api.g_varchar2) or
741: nvl(hr_ord_shd.g_old_rec.org_link_information20, hr_api.g_varchar2) <>
742: nvl(p_rec.org_link_information20, hr_api.g_varchar2) or
743: nvl(hr_ord_shd.g_old_rec.org_link_information21, hr_api.g_varchar2) <>
744: nvl(p_rec.org_link_information21, hr_api.g_varchar2) or
745: nvl(hr_ord_shd.g_old_rec.org_link_information22, hr_api.g_varchar2) <>
746: nvl(p_rec.org_link_information22, hr_api.g_varchar2) or
739: nvl(hr_ord_shd.g_old_rec.org_link_information19, hr_api.g_varchar2) <>
740: nvl(p_rec.org_link_information19, hr_api.g_varchar2) or
741: nvl(hr_ord_shd.g_old_rec.org_link_information20, hr_api.g_varchar2) <>
742: nvl(p_rec.org_link_information20, hr_api.g_varchar2) or
743: nvl(hr_ord_shd.g_old_rec.org_link_information21, hr_api.g_varchar2) <>
744: nvl(p_rec.org_link_information21, hr_api.g_varchar2) or
745: nvl(hr_ord_shd.g_old_rec.org_link_information22, hr_api.g_varchar2) <>
746: nvl(p_rec.org_link_information22, hr_api.g_varchar2) or
747: nvl(hr_ord_shd.g_old_rec.org_link_information23, hr_api.g_varchar2) <>
740: nvl(p_rec.org_link_information19, hr_api.g_varchar2) or
741: nvl(hr_ord_shd.g_old_rec.org_link_information20, hr_api.g_varchar2) <>
742: nvl(p_rec.org_link_information20, hr_api.g_varchar2) or
743: nvl(hr_ord_shd.g_old_rec.org_link_information21, hr_api.g_varchar2) <>
744: nvl(p_rec.org_link_information21, hr_api.g_varchar2) or
745: nvl(hr_ord_shd.g_old_rec.org_link_information22, hr_api.g_varchar2) <>
746: nvl(p_rec.org_link_information22, hr_api.g_varchar2) or
747: nvl(hr_ord_shd.g_old_rec.org_link_information23, hr_api.g_varchar2) <>
748: nvl(p_rec.org_link_information23, hr_api.g_varchar2) or
741: nvl(hr_ord_shd.g_old_rec.org_link_information20, hr_api.g_varchar2) <>
742: nvl(p_rec.org_link_information20, hr_api.g_varchar2) or
743: nvl(hr_ord_shd.g_old_rec.org_link_information21, hr_api.g_varchar2) <>
744: nvl(p_rec.org_link_information21, hr_api.g_varchar2) or
745: nvl(hr_ord_shd.g_old_rec.org_link_information22, hr_api.g_varchar2) <>
746: nvl(p_rec.org_link_information22, hr_api.g_varchar2) or
747: nvl(hr_ord_shd.g_old_rec.org_link_information23, hr_api.g_varchar2) <>
748: nvl(p_rec.org_link_information23, hr_api.g_varchar2) or
749: nvl(hr_ord_shd.g_old_rec.org_link_information24, hr_api.g_varchar2) <>
742: nvl(p_rec.org_link_information20, hr_api.g_varchar2) or
743: nvl(hr_ord_shd.g_old_rec.org_link_information21, hr_api.g_varchar2) <>
744: nvl(p_rec.org_link_information21, hr_api.g_varchar2) or
745: nvl(hr_ord_shd.g_old_rec.org_link_information22, hr_api.g_varchar2) <>
746: nvl(p_rec.org_link_information22, hr_api.g_varchar2) or
747: nvl(hr_ord_shd.g_old_rec.org_link_information23, hr_api.g_varchar2) <>
748: nvl(p_rec.org_link_information23, hr_api.g_varchar2) or
749: nvl(hr_ord_shd.g_old_rec.org_link_information24, hr_api.g_varchar2) <>
750: nvl(p_rec.org_link_information24, hr_api.g_varchar2) or
743: nvl(hr_ord_shd.g_old_rec.org_link_information21, hr_api.g_varchar2) <>
744: nvl(p_rec.org_link_information21, hr_api.g_varchar2) or
745: nvl(hr_ord_shd.g_old_rec.org_link_information22, hr_api.g_varchar2) <>
746: nvl(p_rec.org_link_information22, hr_api.g_varchar2) or
747: nvl(hr_ord_shd.g_old_rec.org_link_information23, hr_api.g_varchar2) <>
748: nvl(p_rec.org_link_information23, hr_api.g_varchar2) or
749: nvl(hr_ord_shd.g_old_rec.org_link_information24, hr_api.g_varchar2) <>
750: nvl(p_rec.org_link_information24, hr_api.g_varchar2) or
751: nvl(hr_ord_shd.g_old_rec.org_link_information25, hr_api.g_varchar2) <>
744: nvl(p_rec.org_link_information21, hr_api.g_varchar2) or
745: nvl(hr_ord_shd.g_old_rec.org_link_information22, hr_api.g_varchar2) <>
746: nvl(p_rec.org_link_information22, hr_api.g_varchar2) or
747: nvl(hr_ord_shd.g_old_rec.org_link_information23, hr_api.g_varchar2) <>
748: nvl(p_rec.org_link_information23, hr_api.g_varchar2) or
749: nvl(hr_ord_shd.g_old_rec.org_link_information24, hr_api.g_varchar2) <>
750: nvl(p_rec.org_link_information24, hr_api.g_varchar2) or
751: nvl(hr_ord_shd.g_old_rec.org_link_information25, hr_api.g_varchar2) <>
752: nvl(p_rec.org_link_information25, hr_api.g_varchar2) or
745: nvl(hr_ord_shd.g_old_rec.org_link_information22, hr_api.g_varchar2) <>
746: nvl(p_rec.org_link_information22, hr_api.g_varchar2) or
747: nvl(hr_ord_shd.g_old_rec.org_link_information23, hr_api.g_varchar2) <>
748: nvl(p_rec.org_link_information23, hr_api.g_varchar2) or
749: nvl(hr_ord_shd.g_old_rec.org_link_information24, hr_api.g_varchar2) <>
750: nvl(p_rec.org_link_information24, hr_api.g_varchar2) or
751: nvl(hr_ord_shd.g_old_rec.org_link_information25, hr_api.g_varchar2) <>
752: nvl(p_rec.org_link_information25, hr_api.g_varchar2) or
753: nvl(hr_ord_shd.g_old_rec.org_link_information26, hr_api.g_varchar2) <>
746: nvl(p_rec.org_link_information22, hr_api.g_varchar2) or
747: nvl(hr_ord_shd.g_old_rec.org_link_information23, hr_api.g_varchar2) <>
748: nvl(p_rec.org_link_information23, hr_api.g_varchar2) or
749: nvl(hr_ord_shd.g_old_rec.org_link_information24, hr_api.g_varchar2) <>
750: nvl(p_rec.org_link_information24, hr_api.g_varchar2) or
751: nvl(hr_ord_shd.g_old_rec.org_link_information25, hr_api.g_varchar2) <>
752: nvl(p_rec.org_link_information25, hr_api.g_varchar2) or
753: nvl(hr_ord_shd.g_old_rec.org_link_information26, hr_api.g_varchar2) <>
754: nvl(p_rec.org_link_information26, hr_api.g_varchar2) or
747: nvl(hr_ord_shd.g_old_rec.org_link_information23, hr_api.g_varchar2) <>
748: nvl(p_rec.org_link_information23, hr_api.g_varchar2) or
749: nvl(hr_ord_shd.g_old_rec.org_link_information24, hr_api.g_varchar2) <>
750: nvl(p_rec.org_link_information24, hr_api.g_varchar2) or
751: nvl(hr_ord_shd.g_old_rec.org_link_information25, hr_api.g_varchar2) <>
752: nvl(p_rec.org_link_information25, hr_api.g_varchar2) or
753: nvl(hr_ord_shd.g_old_rec.org_link_information26, hr_api.g_varchar2) <>
754: nvl(p_rec.org_link_information26, hr_api.g_varchar2) or
755: nvl(hr_ord_shd.g_old_rec.org_link_information27, hr_api.g_varchar2) <>
748: nvl(p_rec.org_link_information23, hr_api.g_varchar2) or
749: nvl(hr_ord_shd.g_old_rec.org_link_information24, hr_api.g_varchar2) <>
750: nvl(p_rec.org_link_information24, hr_api.g_varchar2) or
751: nvl(hr_ord_shd.g_old_rec.org_link_information25, hr_api.g_varchar2) <>
752: nvl(p_rec.org_link_information25, hr_api.g_varchar2) or
753: nvl(hr_ord_shd.g_old_rec.org_link_information26, hr_api.g_varchar2) <>
754: nvl(p_rec.org_link_information26, hr_api.g_varchar2) or
755: nvl(hr_ord_shd.g_old_rec.org_link_information27, hr_api.g_varchar2) <>
756: nvl(p_rec.org_link_information27, hr_api.g_varchar2) or
749: nvl(hr_ord_shd.g_old_rec.org_link_information24, hr_api.g_varchar2) <>
750: nvl(p_rec.org_link_information24, hr_api.g_varchar2) or
751: nvl(hr_ord_shd.g_old_rec.org_link_information25, hr_api.g_varchar2) <>
752: nvl(p_rec.org_link_information25, hr_api.g_varchar2) or
753: nvl(hr_ord_shd.g_old_rec.org_link_information26, hr_api.g_varchar2) <>
754: nvl(p_rec.org_link_information26, hr_api.g_varchar2) or
755: nvl(hr_ord_shd.g_old_rec.org_link_information27, hr_api.g_varchar2) <>
756: nvl(p_rec.org_link_information27, hr_api.g_varchar2) or
757: nvl(hr_ord_shd.g_old_rec.org_link_information28, hr_api.g_varchar2) <>
750: nvl(p_rec.org_link_information24, hr_api.g_varchar2) or
751: nvl(hr_ord_shd.g_old_rec.org_link_information25, hr_api.g_varchar2) <>
752: nvl(p_rec.org_link_information25, hr_api.g_varchar2) or
753: nvl(hr_ord_shd.g_old_rec.org_link_information26, hr_api.g_varchar2) <>
754: nvl(p_rec.org_link_information26, hr_api.g_varchar2) or
755: nvl(hr_ord_shd.g_old_rec.org_link_information27, hr_api.g_varchar2) <>
756: nvl(p_rec.org_link_information27, hr_api.g_varchar2) or
757: nvl(hr_ord_shd.g_old_rec.org_link_information28, hr_api.g_varchar2) <>
758: nvl(p_rec.org_link_information28, hr_api.g_varchar2) or
751: nvl(hr_ord_shd.g_old_rec.org_link_information25, hr_api.g_varchar2) <>
752: nvl(p_rec.org_link_information25, hr_api.g_varchar2) or
753: nvl(hr_ord_shd.g_old_rec.org_link_information26, hr_api.g_varchar2) <>
754: nvl(p_rec.org_link_information26, hr_api.g_varchar2) or
755: nvl(hr_ord_shd.g_old_rec.org_link_information27, hr_api.g_varchar2) <>
756: nvl(p_rec.org_link_information27, hr_api.g_varchar2) or
757: nvl(hr_ord_shd.g_old_rec.org_link_information28, hr_api.g_varchar2) <>
758: nvl(p_rec.org_link_information28, hr_api.g_varchar2) or
759: nvl(hr_ord_shd.g_old_rec.org_link_information29, hr_api.g_varchar2) <>
752: nvl(p_rec.org_link_information25, hr_api.g_varchar2) or
753: nvl(hr_ord_shd.g_old_rec.org_link_information26, hr_api.g_varchar2) <>
754: nvl(p_rec.org_link_information26, hr_api.g_varchar2) or
755: nvl(hr_ord_shd.g_old_rec.org_link_information27, hr_api.g_varchar2) <>
756: nvl(p_rec.org_link_information27, hr_api.g_varchar2) or
757: nvl(hr_ord_shd.g_old_rec.org_link_information28, hr_api.g_varchar2) <>
758: nvl(p_rec.org_link_information28, hr_api.g_varchar2) or
759: nvl(hr_ord_shd.g_old_rec.org_link_information29, hr_api.g_varchar2) <>
760: nvl(p_rec.org_link_information29, hr_api.g_varchar2) or
753: nvl(hr_ord_shd.g_old_rec.org_link_information26, hr_api.g_varchar2) <>
754: nvl(p_rec.org_link_information26, hr_api.g_varchar2) or
755: nvl(hr_ord_shd.g_old_rec.org_link_information27, hr_api.g_varchar2) <>
756: nvl(p_rec.org_link_information27, hr_api.g_varchar2) or
757: nvl(hr_ord_shd.g_old_rec.org_link_information28, hr_api.g_varchar2) <>
758: nvl(p_rec.org_link_information28, hr_api.g_varchar2) or
759: nvl(hr_ord_shd.g_old_rec.org_link_information29, hr_api.g_varchar2) <>
760: nvl(p_rec.org_link_information29, hr_api.g_varchar2) or
761: nvl(hr_ord_shd.g_old_rec.org_link_information30, hr_api.g_varchar2) <>
754: nvl(p_rec.org_link_information26, hr_api.g_varchar2) or
755: nvl(hr_ord_shd.g_old_rec.org_link_information27, hr_api.g_varchar2) <>
756: nvl(p_rec.org_link_information27, hr_api.g_varchar2) or
757: nvl(hr_ord_shd.g_old_rec.org_link_information28, hr_api.g_varchar2) <>
758: nvl(p_rec.org_link_information28, hr_api.g_varchar2) or
759: nvl(hr_ord_shd.g_old_rec.org_link_information29, hr_api.g_varchar2) <>
760: nvl(p_rec.org_link_information29, hr_api.g_varchar2) or
761: nvl(hr_ord_shd.g_old_rec.org_link_information30, hr_api.g_varchar2) <>
762: nvl(p_rec.org_link_information30, hr_api.g_varchar2) ))
755: nvl(hr_ord_shd.g_old_rec.org_link_information27, hr_api.g_varchar2) <>
756: nvl(p_rec.org_link_information27, hr_api.g_varchar2) or
757: nvl(hr_ord_shd.g_old_rec.org_link_information28, hr_api.g_varchar2) <>
758: nvl(p_rec.org_link_information28, hr_api.g_varchar2) or
759: nvl(hr_ord_shd.g_old_rec.org_link_information29, hr_api.g_varchar2) <>
760: nvl(p_rec.org_link_information29, hr_api.g_varchar2) or
761: nvl(hr_ord_shd.g_old_rec.org_link_information30, hr_api.g_varchar2) <>
762: nvl(p_rec.org_link_information30, hr_api.g_varchar2) ))
763: or (p_rec.organization_link_id is null) then
756: nvl(p_rec.org_link_information27, hr_api.g_varchar2) or
757: nvl(hr_ord_shd.g_old_rec.org_link_information28, hr_api.g_varchar2) <>
758: nvl(p_rec.org_link_information28, hr_api.g_varchar2) or
759: nvl(hr_ord_shd.g_old_rec.org_link_information29, hr_api.g_varchar2) <>
760: nvl(p_rec.org_link_information29, hr_api.g_varchar2) or
761: nvl(hr_ord_shd.g_old_rec.org_link_information30, hr_api.g_varchar2) <>
762: nvl(p_rec.org_link_information30, hr_api.g_varchar2) ))
763: or (p_rec.organization_link_id is null) then
764: --
757: nvl(hr_ord_shd.g_old_rec.org_link_information28, hr_api.g_varchar2) <>
758: nvl(p_rec.org_link_information28, hr_api.g_varchar2) or
759: nvl(hr_ord_shd.g_old_rec.org_link_information29, hr_api.g_varchar2) <>
760: nvl(p_rec.org_link_information29, hr_api.g_varchar2) or
761: nvl(hr_ord_shd.g_old_rec.org_link_information30, hr_api.g_varchar2) <>
762: nvl(p_rec.org_link_information30, hr_api.g_varchar2) ))
763: or (p_rec.organization_link_id is null) then
764: --
765: -- Only execute the validation if absolutely necessary:
758: nvl(p_rec.org_link_information28, hr_api.g_varchar2) or
759: nvl(hr_ord_shd.g_old_rec.org_link_information29, hr_api.g_varchar2) <>
760: nvl(p_rec.org_link_information29, hr_api.g_varchar2) or
761: nvl(hr_ord_shd.g_old_rec.org_link_information30, hr_api.g_varchar2) <>
762: nvl(p_rec.org_link_information30, hr_api.g_varchar2) ))
763: or (p_rec.organization_link_id is null) then
764: --
765: -- Only execute the validation if absolutely necessary:
766: -- a) During update, the structure column value or any
874: begin
875: hr_utility.set_location('Entering:'||l_proc,10);
876: --
877: if ((p_rec.organization_link_id is not null) and (
878: nvl(hr_ord_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
879: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
880: nvl(hr_ord_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
881: nvl(p_rec.attribute1, hr_api.g_varchar2) or
882: nvl(hr_ord_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
875: hr_utility.set_location('Entering:'||l_proc,10);
876: --
877: if ((p_rec.organization_link_id is not null) and (
878: nvl(hr_ord_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
879: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
880: nvl(hr_ord_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
881: nvl(p_rec.attribute1, hr_api.g_varchar2) or
882: nvl(hr_ord_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
876: --
877: if ((p_rec.organization_link_id is not null) and (
878: nvl(hr_ord_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
879: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
880: nvl(hr_ord_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
881: nvl(p_rec.attribute1, hr_api.g_varchar2) or
882: nvl(hr_ord_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
884: nvl(hr_ord_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
877: if ((p_rec.organization_link_id is not null) and (
878: nvl(hr_ord_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
879: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
880: nvl(hr_ord_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
881: nvl(p_rec.attribute1, hr_api.g_varchar2) or
882: nvl(hr_ord_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
884: nvl(hr_ord_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
878: nvl(hr_ord_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
879: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
880: nvl(hr_ord_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
881: nvl(p_rec.attribute1, hr_api.g_varchar2) or
882: nvl(hr_ord_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
884: nvl(hr_ord_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
886: nvl(hr_ord_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
879: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
880: nvl(hr_ord_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
881: nvl(p_rec.attribute1, hr_api.g_varchar2) or
882: nvl(hr_ord_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
884: nvl(hr_ord_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
886: nvl(hr_ord_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
880: nvl(hr_ord_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
881: nvl(p_rec.attribute1, hr_api.g_varchar2) or
882: nvl(hr_ord_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
884: nvl(hr_ord_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
886: nvl(hr_ord_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
888: nvl(hr_ord_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
881: nvl(p_rec.attribute1, hr_api.g_varchar2) or
882: nvl(hr_ord_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
884: nvl(hr_ord_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
886: nvl(hr_ord_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
888: nvl(hr_ord_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
882: nvl(hr_ord_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
884: nvl(hr_ord_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
886: nvl(hr_ord_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
888: nvl(hr_ord_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
890: nvl(hr_ord_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
883: nvl(p_rec.attribute2, hr_api.g_varchar2) or
884: nvl(hr_ord_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
886: nvl(hr_ord_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
888: nvl(hr_ord_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
890: nvl(hr_ord_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
884: nvl(hr_ord_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
886: nvl(hr_ord_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
888: nvl(hr_ord_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
890: nvl(hr_ord_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
892: nvl(hr_ord_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
885: nvl(p_rec.attribute3, hr_api.g_varchar2) or
886: nvl(hr_ord_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
888: nvl(hr_ord_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
890: nvl(hr_ord_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
892: nvl(hr_ord_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
886: nvl(hr_ord_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
888: nvl(hr_ord_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
890: nvl(hr_ord_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
892: nvl(hr_ord_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
894: nvl(hr_ord_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
887: nvl(p_rec.attribute4, hr_api.g_varchar2) or
888: nvl(hr_ord_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
890: nvl(hr_ord_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
892: nvl(hr_ord_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
894: nvl(hr_ord_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
888: nvl(hr_ord_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
890: nvl(hr_ord_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
892: nvl(hr_ord_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
894: nvl(hr_ord_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
896: nvl(hr_ord_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
889: nvl(p_rec.attribute5, hr_api.g_varchar2) or
890: nvl(hr_ord_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
892: nvl(hr_ord_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
894: nvl(hr_ord_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
896: nvl(hr_ord_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
890: nvl(hr_ord_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
892: nvl(hr_ord_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
894: nvl(hr_ord_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
896: nvl(hr_ord_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
898: nvl(hr_ord_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
891: nvl(p_rec.attribute6, hr_api.g_varchar2) or
892: nvl(hr_ord_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
894: nvl(hr_ord_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
896: nvl(hr_ord_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
898: nvl(hr_ord_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
892: nvl(hr_ord_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
894: nvl(hr_ord_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
896: nvl(hr_ord_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
898: nvl(hr_ord_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
900: nvl(hr_ord_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
893: nvl(p_rec.attribute7, hr_api.g_varchar2) or
894: nvl(hr_ord_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
896: nvl(hr_ord_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
898: nvl(hr_ord_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
900: nvl(hr_ord_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
894: nvl(hr_ord_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
896: nvl(hr_ord_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
898: nvl(hr_ord_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
900: nvl(hr_ord_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
902: nvl(hr_ord_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
895: nvl(p_rec.attribute8, hr_api.g_varchar2) or
896: nvl(hr_ord_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
898: nvl(hr_ord_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
900: nvl(hr_ord_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
902: nvl(hr_ord_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
896: nvl(hr_ord_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
898: nvl(hr_ord_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
900: nvl(hr_ord_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
902: nvl(hr_ord_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
904: nvl(hr_ord_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
897: nvl(p_rec.attribute9, hr_api.g_varchar2) or
898: nvl(hr_ord_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
900: nvl(hr_ord_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
902: nvl(hr_ord_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
904: nvl(hr_ord_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
898: nvl(hr_ord_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
900: nvl(hr_ord_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
902: nvl(hr_ord_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
904: nvl(hr_ord_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
906: nvl(hr_ord_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
899: nvl(p_rec.attribute10, hr_api.g_varchar2) or
900: nvl(hr_ord_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
902: nvl(hr_ord_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
904: nvl(hr_ord_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
906: nvl(hr_ord_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
900: nvl(hr_ord_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
902: nvl(hr_ord_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
904: nvl(hr_ord_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
906: nvl(hr_ord_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
908: nvl(hr_ord_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
901: nvl(p_rec.attribute11, hr_api.g_varchar2) or
902: nvl(hr_ord_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
904: nvl(hr_ord_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
906: nvl(hr_ord_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
908: nvl(hr_ord_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
902: nvl(hr_ord_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
904: nvl(hr_ord_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
906: nvl(hr_ord_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
908: nvl(hr_ord_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
910: nvl(hr_ord_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
903: nvl(p_rec.attribute12, hr_api.g_varchar2) or
904: nvl(hr_ord_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
906: nvl(hr_ord_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
908: nvl(hr_ord_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
910: nvl(hr_ord_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
904: nvl(hr_ord_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
906: nvl(hr_ord_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
908: nvl(hr_ord_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
910: nvl(hr_ord_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
912: nvl(hr_ord_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
905: nvl(p_rec.attribute13, hr_api.g_varchar2) or
906: nvl(hr_ord_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
908: nvl(hr_ord_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
910: nvl(hr_ord_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
912: nvl(hr_ord_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
906: nvl(hr_ord_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
908: nvl(hr_ord_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
910: nvl(hr_ord_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
912: nvl(hr_ord_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
914: nvl(hr_ord_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
907: nvl(p_rec.attribute14, hr_api.g_varchar2) or
908: nvl(hr_ord_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
910: nvl(hr_ord_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
912: nvl(hr_ord_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
914: nvl(hr_ord_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
908: nvl(hr_ord_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
910: nvl(hr_ord_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
912: nvl(hr_ord_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
914: nvl(hr_ord_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
916: nvl(hr_ord_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
909: nvl(p_rec.attribute15, hr_api.g_varchar2) or
910: nvl(hr_ord_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
912: nvl(hr_ord_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
914: nvl(hr_ord_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
916: nvl(hr_ord_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
910: nvl(hr_ord_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
912: nvl(hr_ord_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
914: nvl(hr_ord_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
916: nvl(hr_ord_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
918: nvl(hr_ord_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
911: nvl(p_rec.attribute16, hr_api.g_varchar2) or
912: nvl(hr_ord_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
914: nvl(hr_ord_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
916: nvl(hr_ord_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
918: nvl(hr_ord_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
912: nvl(hr_ord_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
914: nvl(hr_ord_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
916: nvl(hr_ord_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
918: nvl(hr_ord_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
920: nvl(hr_ord_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
913: nvl(p_rec.attribute17, hr_api.g_varchar2) or
914: nvl(hr_ord_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
916: nvl(hr_ord_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
918: nvl(hr_ord_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
920: nvl(hr_ord_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
914: nvl(hr_ord_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
916: nvl(hr_ord_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
918: nvl(hr_ord_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
920: nvl(hr_ord_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
922: nvl(hr_ord_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
915: nvl(p_rec.attribute18, hr_api.g_varchar2) or
916: nvl(hr_ord_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
918: nvl(hr_ord_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
920: nvl(hr_ord_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
922: nvl(hr_ord_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
916: nvl(hr_ord_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
918: nvl(hr_ord_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
920: nvl(hr_ord_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
922: nvl(hr_ord_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
924: nvl(hr_ord_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
917: nvl(p_rec.attribute19, hr_api.g_varchar2) or
918: nvl(hr_ord_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
920: nvl(hr_ord_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
922: nvl(hr_ord_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
924: nvl(hr_ord_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
918: nvl(hr_ord_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
920: nvl(hr_ord_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
922: nvl(hr_ord_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
924: nvl(hr_ord_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
926: nvl(hr_ord_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
919: nvl(p_rec.attribute20, hr_api.g_varchar2) or
920: nvl(hr_ord_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
922: nvl(hr_ord_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
924: nvl(hr_ord_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
926: nvl(hr_ord_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
920: nvl(hr_ord_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
922: nvl(hr_ord_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
924: nvl(hr_ord_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
926: nvl(hr_ord_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
928: nvl(hr_ord_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
921: nvl(p_rec.attribute21, hr_api.g_varchar2) or
922: nvl(hr_ord_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
924: nvl(hr_ord_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
926: nvl(hr_ord_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
928: nvl(hr_ord_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
922: nvl(hr_ord_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
924: nvl(hr_ord_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
926: nvl(hr_ord_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
928: nvl(hr_ord_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
930: nvl(hr_ord_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
923: nvl(p_rec.attribute22, hr_api.g_varchar2) or
924: nvl(hr_ord_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
926: nvl(hr_ord_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
928: nvl(hr_ord_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
930: nvl(hr_ord_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
924: nvl(hr_ord_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
926: nvl(hr_ord_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
928: nvl(hr_ord_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
930: nvl(hr_ord_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
932: nvl(hr_ord_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
925: nvl(p_rec.attribute23, hr_api.g_varchar2) or
926: nvl(hr_ord_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
928: nvl(hr_ord_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
930: nvl(hr_ord_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
932: nvl(hr_ord_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
926: nvl(hr_ord_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
928: nvl(hr_ord_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
930: nvl(hr_ord_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
932: nvl(hr_ord_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
934: nvl(hr_ord_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
927: nvl(p_rec.attribute24, hr_api.g_varchar2) or
928: nvl(hr_ord_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
930: nvl(hr_ord_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
932: nvl(hr_ord_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
934: nvl(hr_ord_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
928: nvl(hr_ord_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
930: nvl(hr_ord_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
932: nvl(hr_ord_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
934: nvl(hr_ord_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
936: nvl(hr_ord_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
929: nvl(p_rec.attribute25, hr_api.g_varchar2) or
930: nvl(hr_ord_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
932: nvl(hr_ord_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
934: nvl(hr_ord_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
936: nvl(hr_ord_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute29, hr_api.g_varchar2) or
930: nvl(hr_ord_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
932: nvl(hr_ord_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
934: nvl(hr_ord_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
936: nvl(hr_ord_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute29, hr_api.g_varchar2) or
938: nvl(hr_ord_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
931: nvl(p_rec.attribute26, hr_api.g_varchar2) or
932: nvl(hr_ord_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
934: nvl(hr_ord_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
936: nvl(hr_ord_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute29, hr_api.g_varchar2) or
938: nvl(hr_ord_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
932: nvl(hr_ord_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
934: nvl(hr_ord_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
936: nvl(hr_ord_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute29, hr_api.g_varchar2) or
938: nvl(hr_ord_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
940: or (p_rec.organization_link_id is null) then
933: nvl(p_rec.attribute27, hr_api.g_varchar2) or
934: nvl(hr_ord_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
936: nvl(hr_ord_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute29, hr_api.g_varchar2) or
938: nvl(hr_ord_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
940: or (p_rec.organization_link_id is null) then
941: --
934: nvl(hr_ord_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
936: nvl(hr_ord_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute29, hr_api.g_varchar2) or
938: nvl(hr_ord_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
940: or (p_rec.organization_link_id is null) then
941: --
942: -- Only execute the validation if absolutely necessary:
935: nvl(p_rec.attribute28, hr_api.g_varchar2) or
936: nvl(hr_ord_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
937: nvl(p_rec.attribute29, hr_api.g_varchar2) or
938: nvl(hr_ord_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
939: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
940: or (p_rec.organization_link_id is null) then
941: --
942: -- Only execute the validation if absolutely necessary:
943: -- a) During update, the structure column value or any
1064: fnd_message.set_token('STEP ', '5');
1065: fnd_message.raise_error;
1066: END IF;
1067: --
1068: if nvl(p_rec.business_group_id, hr_api.g_number) <>
1069: nvl(hr_ord_shd.g_old_rec.business_group_id, hr_api.g_number) then
1070: l_argument := 'business_group_id';
1071: raise l_error;
1072: end if;
1065: fnd_message.raise_error;
1066: END IF;
1067: --
1068: if nvl(p_rec.business_group_id, hr_api.g_number) <>
1069: nvl(hr_ord_shd.g_old_rec.business_group_id, hr_api.g_number) then
1070: l_argument := 'business_group_id';
1071: raise l_error;
1072: end if;
1073: --
1070: l_argument := 'business_group_id';
1071: raise l_error;
1072: end if;
1073: --
1074: if nvl(p_rec.parent_organization_id, hr_api.g_number) <>
1075: nvl(hr_ord_shd.g_old_rec.parent_organization_id, hr_api.g_number) then
1076: l_argument := 'parent_organization_id';
1077: raise l_error;
1078: end if;
1071: raise l_error;
1072: end if;
1073: --
1074: if nvl(p_rec.parent_organization_id, hr_api.g_number) <>
1075: nvl(hr_ord_shd.g_old_rec.parent_organization_id, hr_api.g_number) then
1076: l_argument := 'parent_organization_id';
1077: raise l_error;
1078: end if;
1079: --
1076: l_argument := 'parent_organization_id';
1077: raise l_error;
1078: end if;
1079: --
1080: if nvl(p_rec.child_organization_id, hr_api.g_number) <>
1081: nvl(hr_ord_shd.g_old_rec.child_organization_id, hr_api.g_number) then
1082: l_argument := 'child_organization_id';
1083: raise l_error;
1084: end if;
1077: raise l_error;
1078: end if;
1079: --
1080: if nvl(p_rec.child_organization_id, hr_api.g_number) <>
1081: nvl(hr_ord_shd.g_old_rec.child_organization_id, hr_api.g_number) then
1082: l_argument := 'child_organization_id';
1083: raise l_error;
1084: end if;
1085: --
1082: l_argument := 'child_organization_id';
1083: raise l_error;
1084: end if;
1085: --
1086: if nvl(p_rec.org_link_type, hr_api.g_varchar2) <>
1087: nvl(hr_ord_shd.g_old_rec.org_link_type, hr_api.g_varchar2) then
1088: l_argument := 'org_link_type';
1089: raise l_error;
1090: end if;
1083: raise l_error;
1084: end if;
1085: --
1086: if nvl(p_rec.org_link_type, hr_api.g_varchar2) <>
1087: nvl(hr_ord_shd.g_old_rec.org_link_type, hr_api.g_varchar2) then
1088: l_argument := 'org_link_type';
1089: raise l_error;
1090: end if;
1091: --
1088: l_argument := 'org_link_type';
1089: raise l_error;
1090: end if;
1091: --
1092: if nvl(p_rec.org_link_information_category, hr_api.g_varchar2) <>
1093: nvl(hr_ord_shd.g_old_rec.org_link_information_category, hr_api.g_varchar2) then
1094: l_argument := 'org_link_information_category';
1095: raise l_error;
1096: end if;
1089: raise l_error;
1090: end if;
1091: --
1092: if nvl(p_rec.org_link_information_category, hr_api.g_varchar2) <>
1093: nvl(hr_ord_shd.g_old_rec.org_link_information_category, hr_api.g_varchar2) then
1094: l_argument := 'org_link_information_category';
1095: raise l_error;
1096: end if;
1097: --
1096: end if;
1097: --
1098: EXCEPTION
1099: WHEN l_error THEN
1100: hr_api.argument_changed_error
1101: (p_api_name => l_proc
1102: ,p_argument => l_argument);
1103: WHEN OTHERS THEN
1104: RAISE;
1117: l_proc varchar2(72) := g_package || 'insert_validate';
1118: Begin
1119: hr_utility.set_location('Entering:'||l_proc, 10);
1120: --
1121: hr_api.validate_bus_grp_id
1122: (p_rec.business_group_id);
1123: --
1124: hr_api.mandatory_arg_error
1125: (p_api_name => l_proc
1120: --
1121: hr_api.validate_bus_grp_id
1122: (p_rec.business_group_id);
1123: --
1124: hr_api.mandatory_arg_error
1125: (p_api_name => l_proc
1126: ,p_argument => 'effective_date'
1127: ,p_argument_value => p_effective_date);
1128: --
1177: --
1178: --
1179: -- Check mandatory parameters have been set.
1180: --
1181: hr_api.mandatory_arg_error
1182: (p_api_name => l_proc
1183: ,p_argument => 'effective_date'
1184: ,p_argument_value => p_effective_date);
1185: --
1182: (p_api_name => l_proc
1183: ,p_argument => 'effective_date'
1184: ,p_argument_value => p_effective_date);
1185: --
1186: hr_api.validate_bus_grp_id
1187: (p_rec.business_group_id);
1188: --
1189: chk_non_updateable_args
1190: (p_effective_date => p_effective_date