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_ORI_BUS dependencies on HR_API

Line 50: hr_api.mandatory_arg_error

46: hr_utility.set_location('Entering:'|| l_proc, 10);
47: --
48: -- Ensure that all the mandatory parameter are not null
49: --
50: hr_api.mandatory_arg_error
51: (p_api_name => l_proc
52: ,p_argument => 'org_information_id'
53: ,p_argument_value => p_org_information_id
54: );

Line 73: hr_api.set_security_group_id

69: close csr_sec_grp;
70: --
71: -- Set the security_group_id in CLIENT_INFO
72: --
73: hr_api.set_security_group_id
74: (p_security_group_id => l_security_group_id
75: );
76: --
77: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 118: > nvl(p_end_date,hr_api.g_eot);

114: where organization_id = p_organization_id
115: and org_information_context = 'Organization Name Alias'
116: and org_information_id <> nvl(p_org_information_id,-1)
117: and fnd_date.canonical_to_date(org_information3)
118: > nvl(p_end_date,hr_api.g_eot);
119: --
120: l_c2 c2%rowtype;
121: l_c1 c1%rowtype;
122: --

Line 342: and nvl(actual_termination_date,hr_api.g_eot)

338: date_start
339: from per_periods_of_service
340: where l_start_date
341: between date_start
342: and nvl(actual_termination_date,hr_api.g_eot)
343: and person_id = l_person_id
344: union
345: select period_of_placement_id worker_id,
346: date_start

Line 350: and nvl(actual_termination_date,hr_api.g_eot)

346: date_start
347: from per_periods_of_placement
348: where l_start_date
349: between date_start
350: and nvl(actual_termination_date,hr_api.g_eot)
351: and person_id = l_person_id;
352: --
353: -- They need to share the same period of service id.
354: --

Line 360: where nvl(l_end_date,hr_api.g_eot)

356: --
357: cursor c2(p_worker_id number) is
358: select actual_termination_date
359: from per_periods_of_service
360: where nvl(l_end_date,hr_api.g_eot)
361: between date_start
362: and nvl(actual_termination_date,hr_api.g_eot)
363: and period_of_service_id = p_worker_id
364: and person_id = l_person_id

Line 362: and nvl(actual_termination_date,hr_api.g_eot)

358: select actual_termination_date
359: from per_periods_of_service
360: where nvl(l_end_date,hr_api.g_eot)
361: between date_start
362: and nvl(actual_termination_date,hr_api.g_eot)
363: and period_of_service_id = p_worker_id
364: and person_id = l_person_id
365: union
366: select actual_termination_date

Line 368: where nvl(l_end_date,hr_api.g_eot)

364: and person_id = l_person_id
365: union
366: select actual_termination_date
367: from per_periods_of_placement
368: where nvl(l_end_date,hr_api.g_eot)
369: between date_start
370: and nvl(actual_termination_date,hr_api.g_eot)
371: and period_of_placement_id = p_worker_id
372: and person_id = l_person_id;

Line 370: and nvl(actual_termination_date,hr_api.g_eot)

366: select actual_termination_date
367: from per_periods_of_placement
368: where nvl(l_end_date,hr_api.g_eot)
369: between date_start
370: and nvl(actual_termination_date,hr_api.g_eot)
371: and period_of_placement_id = p_worker_id
372: and person_id = l_person_id;
373: --
374: l_c1 c1%rowtype;

Line 674: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)

670: where organization_id = p_organization_id
671: and org_information_context = 'Organization Name Alias'
672: and (l_start_date
673: between fnd_date.canonical_to_date(org_information3)
674: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)
675: or
676: nvl(l_end_date,hr_api.g_eot)
677: between fnd_date.canonical_to_date(org_information3)
678: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)

Line 676: nvl(l_end_date,hr_api.g_eot)

672: and (l_start_date
673: between fnd_date.canonical_to_date(org_information3)
674: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)
675: or
676: nvl(l_end_date,hr_api.g_eot)
677: between fnd_date.canonical_to_date(org_information3)
678: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)
679: or fnd_date.canonical_to_date(org_information3)
680: between l_start_date

Line 678: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)

674: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)
675: or
676: nvl(l_end_date,hr_api.g_eot)
677: between fnd_date.canonical_to_date(org_information3)
678: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)
679: or fnd_date.canonical_to_date(org_information3)
680: between l_start_date
681: and nvl(l_end_date,hr_api.g_eot)
682: or nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)

Line 681: and nvl(l_end_date,hr_api.g_eot)

677: between fnd_date.canonical_to_date(org_information3)
678: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)
679: or fnd_date.canonical_to_date(org_information3)
680: between l_start_date
681: and nvl(l_end_date,hr_api.g_eot)
682: or nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)
683: between l_start_date
684: and nvl(l_end_date,hr_api.g_eot))
685: and org_information_id <> nvl(p_org_information_id,-1)

Line 682: or nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)

678: and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)
679: or fnd_date.canonical_to_date(org_information3)
680: between l_start_date
681: and nvl(l_end_date,hr_api.g_eot)
682: or nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)
683: between l_start_date
684: and nvl(l_end_date,hr_api.g_eot))
685: and org_information_id <> nvl(p_org_information_id,-1)
686: and org_information3 is not null;

Line 684: and nvl(l_end_date,hr_api.g_eot))

680: between l_start_date
681: and nvl(l_end_date,hr_api.g_eot)
682: or nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot)
683: between l_start_date
684: and nvl(l_end_date,hr_api.g_eot))
685: and org_information_id <> nvl(p_org_information_id,-1)
686: and org_information3 is not null;
687: --
688: l_c1 c1%rowtype;

Line 850: hr_api.mandatory_arg_error

846: hr_utility.set_location('Entering:'|| l_proc, 10);
847: --
848: -- Ensure that all the mandatory parameter are not null
849: --
850: hr_api.mandatory_arg_error
851: (p_api_name => l_proc
852: ,p_argument => 'org_information_id'
853: ,p_argument_value => p_org_information_id
854: );

Line 856: if ( nvl(hr_ori_bus.g_org_information_id, hr_api.g_number)

852: ,p_argument => 'org_information_id'
853: ,p_argument_value => p_org_information_id
854: );
855: --
856: if ( nvl(hr_ori_bus.g_org_information_id, hr_api.g_number)
857: = p_org_information_id) then
858: --
859: -- The legislation code has already been found with a previous
860: -- call to this function. Just return the value in the global

Line 992: nvl(hr_ori_shd.g_old_rec.org_information_id, hr_api.g_number) <>

988: begin
989: hr_utility.set_location('Entering:'||l_proc,10);
990: --
991: if ((p_rec.org_information_id is not null) and (
992: nvl(hr_ori_shd.g_old_rec.org_information_id, hr_api.g_number) <>
993: nvl(p_rec.org_information_id, hr_api.g_number) or
994: nvl(hr_ori_shd.g_old_rec.org_information_context, hr_api.g_varchar2) <>
995: nvl(p_rec.org_information_context, hr_api.g_varchar2) or
996: nvl(hr_ori_shd.g_old_rec.org_information1, hr_api.g_varchar2) <>

Line 993: nvl(p_rec.org_information_id, hr_api.g_number) or

989: hr_utility.set_location('Entering:'||l_proc,10);
990: --
991: if ((p_rec.org_information_id is not null) and (
992: nvl(hr_ori_shd.g_old_rec.org_information_id, hr_api.g_number) <>
993: nvl(p_rec.org_information_id, hr_api.g_number) or
994: nvl(hr_ori_shd.g_old_rec.org_information_context, hr_api.g_varchar2) <>
995: nvl(p_rec.org_information_context, hr_api.g_varchar2) or
996: nvl(hr_ori_shd.g_old_rec.org_information1, hr_api.g_varchar2) <>
997: nvl(p_rec.org_information1, hr_api.g_varchar2) or

Line 994: nvl(hr_ori_shd.g_old_rec.org_information_context, hr_api.g_varchar2) <>

990: --
991: if ((p_rec.org_information_id is not null) and (
992: nvl(hr_ori_shd.g_old_rec.org_information_id, hr_api.g_number) <>
993: nvl(p_rec.org_information_id, hr_api.g_number) or
994: nvl(hr_ori_shd.g_old_rec.org_information_context, hr_api.g_varchar2) <>
995: nvl(p_rec.org_information_context, hr_api.g_varchar2) or
996: nvl(hr_ori_shd.g_old_rec.org_information1, hr_api.g_varchar2) <>
997: nvl(p_rec.org_information1, hr_api.g_varchar2) or
998: nvl(hr_ori_shd.g_old_rec.org_information10, hr_api.g_varchar2) <>

Line 995: nvl(p_rec.org_information_context, hr_api.g_varchar2) or

991: if ((p_rec.org_information_id is not null) and (
992: nvl(hr_ori_shd.g_old_rec.org_information_id, hr_api.g_number) <>
993: nvl(p_rec.org_information_id, hr_api.g_number) or
994: nvl(hr_ori_shd.g_old_rec.org_information_context, hr_api.g_varchar2) <>
995: nvl(p_rec.org_information_context, hr_api.g_varchar2) or
996: nvl(hr_ori_shd.g_old_rec.org_information1, hr_api.g_varchar2) <>
997: nvl(p_rec.org_information1, hr_api.g_varchar2) or
998: nvl(hr_ori_shd.g_old_rec.org_information10, hr_api.g_varchar2) <>
999: nvl(p_rec.org_information10, hr_api.g_varchar2) or

Line 996: nvl(hr_ori_shd.g_old_rec.org_information1, hr_api.g_varchar2) <>

992: nvl(hr_ori_shd.g_old_rec.org_information_id, hr_api.g_number) <>
993: nvl(p_rec.org_information_id, hr_api.g_number) or
994: nvl(hr_ori_shd.g_old_rec.org_information_context, hr_api.g_varchar2) <>
995: nvl(p_rec.org_information_context, hr_api.g_varchar2) or
996: nvl(hr_ori_shd.g_old_rec.org_information1, hr_api.g_varchar2) <>
997: nvl(p_rec.org_information1, hr_api.g_varchar2) or
998: nvl(hr_ori_shd.g_old_rec.org_information10, hr_api.g_varchar2) <>
999: nvl(p_rec.org_information10, hr_api.g_varchar2) or
1000: nvl(hr_ori_shd.g_old_rec.org_information11, hr_api.g_varchar2) <>

Line 997: nvl(p_rec.org_information1, hr_api.g_varchar2) or

993: nvl(p_rec.org_information_id, hr_api.g_number) or
994: nvl(hr_ori_shd.g_old_rec.org_information_context, hr_api.g_varchar2) <>
995: nvl(p_rec.org_information_context, hr_api.g_varchar2) or
996: nvl(hr_ori_shd.g_old_rec.org_information1, hr_api.g_varchar2) <>
997: nvl(p_rec.org_information1, hr_api.g_varchar2) or
998: nvl(hr_ori_shd.g_old_rec.org_information10, hr_api.g_varchar2) <>
999: nvl(p_rec.org_information10, hr_api.g_varchar2) or
1000: nvl(hr_ori_shd.g_old_rec.org_information11, hr_api.g_varchar2) <>
1001: nvl(p_rec.org_information11, hr_api.g_varchar2) or

Line 998: nvl(hr_ori_shd.g_old_rec.org_information10, hr_api.g_varchar2) <>

994: nvl(hr_ori_shd.g_old_rec.org_information_context, hr_api.g_varchar2) <>
995: nvl(p_rec.org_information_context, hr_api.g_varchar2) or
996: nvl(hr_ori_shd.g_old_rec.org_information1, hr_api.g_varchar2) <>
997: nvl(p_rec.org_information1, hr_api.g_varchar2) or
998: nvl(hr_ori_shd.g_old_rec.org_information10, hr_api.g_varchar2) <>
999: nvl(p_rec.org_information10, hr_api.g_varchar2) or
1000: nvl(hr_ori_shd.g_old_rec.org_information11, hr_api.g_varchar2) <>
1001: nvl(p_rec.org_information11, hr_api.g_varchar2) or
1002: nvl(hr_ori_shd.g_old_rec.org_information12, hr_api.g_varchar2) <>

Line 999: nvl(p_rec.org_information10, hr_api.g_varchar2) or

995: nvl(p_rec.org_information_context, hr_api.g_varchar2) or
996: nvl(hr_ori_shd.g_old_rec.org_information1, hr_api.g_varchar2) <>
997: nvl(p_rec.org_information1, hr_api.g_varchar2) or
998: nvl(hr_ori_shd.g_old_rec.org_information10, hr_api.g_varchar2) <>
999: nvl(p_rec.org_information10, hr_api.g_varchar2) or
1000: nvl(hr_ori_shd.g_old_rec.org_information11, hr_api.g_varchar2) <>
1001: nvl(p_rec.org_information11, hr_api.g_varchar2) or
1002: nvl(hr_ori_shd.g_old_rec.org_information12, hr_api.g_varchar2) <>
1003: nvl(p_rec.org_information12, hr_api.g_varchar2) or

Line 1000: nvl(hr_ori_shd.g_old_rec.org_information11, hr_api.g_varchar2) <>

996: nvl(hr_ori_shd.g_old_rec.org_information1, hr_api.g_varchar2) <>
997: nvl(p_rec.org_information1, hr_api.g_varchar2) or
998: nvl(hr_ori_shd.g_old_rec.org_information10, hr_api.g_varchar2) <>
999: nvl(p_rec.org_information10, hr_api.g_varchar2) or
1000: nvl(hr_ori_shd.g_old_rec.org_information11, hr_api.g_varchar2) <>
1001: nvl(p_rec.org_information11, hr_api.g_varchar2) or
1002: nvl(hr_ori_shd.g_old_rec.org_information12, hr_api.g_varchar2) <>
1003: nvl(p_rec.org_information12, hr_api.g_varchar2) or
1004: nvl(hr_ori_shd.g_old_rec.org_information13, hr_api.g_varchar2) <>

Line 1001: nvl(p_rec.org_information11, hr_api.g_varchar2) or

997: nvl(p_rec.org_information1, hr_api.g_varchar2) or
998: nvl(hr_ori_shd.g_old_rec.org_information10, hr_api.g_varchar2) <>
999: nvl(p_rec.org_information10, hr_api.g_varchar2) or
1000: nvl(hr_ori_shd.g_old_rec.org_information11, hr_api.g_varchar2) <>
1001: nvl(p_rec.org_information11, hr_api.g_varchar2) or
1002: nvl(hr_ori_shd.g_old_rec.org_information12, hr_api.g_varchar2) <>
1003: nvl(p_rec.org_information12, hr_api.g_varchar2) or
1004: nvl(hr_ori_shd.g_old_rec.org_information13, hr_api.g_varchar2) <>
1005: nvl(p_rec.org_information13, hr_api.g_varchar2) or

Line 1002: nvl(hr_ori_shd.g_old_rec.org_information12, hr_api.g_varchar2) <>

998: nvl(hr_ori_shd.g_old_rec.org_information10, hr_api.g_varchar2) <>
999: nvl(p_rec.org_information10, hr_api.g_varchar2) or
1000: nvl(hr_ori_shd.g_old_rec.org_information11, hr_api.g_varchar2) <>
1001: nvl(p_rec.org_information11, hr_api.g_varchar2) or
1002: nvl(hr_ori_shd.g_old_rec.org_information12, hr_api.g_varchar2) <>
1003: nvl(p_rec.org_information12, hr_api.g_varchar2) or
1004: nvl(hr_ori_shd.g_old_rec.org_information13, hr_api.g_varchar2) <>
1005: nvl(p_rec.org_information13, hr_api.g_varchar2) or
1006: nvl(hr_ori_shd.g_old_rec.org_information14, hr_api.g_varchar2) <>

Line 1003: nvl(p_rec.org_information12, hr_api.g_varchar2) or

999: nvl(p_rec.org_information10, hr_api.g_varchar2) or
1000: nvl(hr_ori_shd.g_old_rec.org_information11, hr_api.g_varchar2) <>
1001: nvl(p_rec.org_information11, hr_api.g_varchar2) or
1002: nvl(hr_ori_shd.g_old_rec.org_information12, hr_api.g_varchar2) <>
1003: nvl(p_rec.org_information12, hr_api.g_varchar2) or
1004: nvl(hr_ori_shd.g_old_rec.org_information13, hr_api.g_varchar2) <>
1005: nvl(p_rec.org_information13, hr_api.g_varchar2) or
1006: nvl(hr_ori_shd.g_old_rec.org_information14, hr_api.g_varchar2) <>
1007: nvl(p_rec.org_information14, hr_api.g_varchar2) or

Line 1004: nvl(hr_ori_shd.g_old_rec.org_information13, hr_api.g_varchar2) <>

1000: nvl(hr_ori_shd.g_old_rec.org_information11, hr_api.g_varchar2) <>
1001: nvl(p_rec.org_information11, hr_api.g_varchar2) or
1002: nvl(hr_ori_shd.g_old_rec.org_information12, hr_api.g_varchar2) <>
1003: nvl(p_rec.org_information12, hr_api.g_varchar2) or
1004: nvl(hr_ori_shd.g_old_rec.org_information13, hr_api.g_varchar2) <>
1005: nvl(p_rec.org_information13, hr_api.g_varchar2) or
1006: nvl(hr_ori_shd.g_old_rec.org_information14, hr_api.g_varchar2) <>
1007: nvl(p_rec.org_information14, hr_api.g_varchar2) or
1008: nvl(hr_ori_shd.g_old_rec.org_information15, hr_api.g_varchar2) <>

Line 1005: nvl(p_rec.org_information13, hr_api.g_varchar2) or

1001: nvl(p_rec.org_information11, hr_api.g_varchar2) or
1002: nvl(hr_ori_shd.g_old_rec.org_information12, hr_api.g_varchar2) <>
1003: nvl(p_rec.org_information12, hr_api.g_varchar2) or
1004: nvl(hr_ori_shd.g_old_rec.org_information13, hr_api.g_varchar2) <>
1005: nvl(p_rec.org_information13, hr_api.g_varchar2) or
1006: nvl(hr_ori_shd.g_old_rec.org_information14, hr_api.g_varchar2) <>
1007: nvl(p_rec.org_information14, hr_api.g_varchar2) or
1008: nvl(hr_ori_shd.g_old_rec.org_information15, hr_api.g_varchar2) <>
1009: nvl(p_rec.org_information15, hr_api.g_varchar2) or

Line 1006: nvl(hr_ori_shd.g_old_rec.org_information14, hr_api.g_varchar2) <>

1002: nvl(hr_ori_shd.g_old_rec.org_information12, hr_api.g_varchar2) <>
1003: nvl(p_rec.org_information12, hr_api.g_varchar2) or
1004: nvl(hr_ori_shd.g_old_rec.org_information13, hr_api.g_varchar2) <>
1005: nvl(p_rec.org_information13, hr_api.g_varchar2) or
1006: nvl(hr_ori_shd.g_old_rec.org_information14, hr_api.g_varchar2) <>
1007: nvl(p_rec.org_information14, hr_api.g_varchar2) or
1008: nvl(hr_ori_shd.g_old_rec.org_information15, hr_api.g_varchar2) <>
1009: nvl(p_rec.org_information15, hr_api.g_varchar2) or
1010: nvl(hr_ori_shd.g_old_rec.org_information16, hr_api.g_varchar2) <>

Line 1007: nvl(p_rec.org_information14, hr_api.g_varchar2) or

1003: nvl(p_rec.org_information12, hr_api.g_varchar2) or
1004: nvl(hr_ori_shd.g_old_rec.org_information13, hr_api.g_varchar2) <>
1005: nvl(p_rec.org_information13, hr_api.g_varchar2) or
1006: nvl(hr_ori_shd.g_old_rec.org_information14, hr_api.g_varchar2) <>
1007: nvl(p_rec.org_information14, hr_api.g_varchar2) or
1008: nvl(hr_ori_shd.g_old_rec.org_information15, hr_api.g_varchar2) <>
1009: nvl(p_rec.org_information15, hr_api.g_varchar2) or
1010: nvl(hr_ori_shd.g_old_rec.org_information16, hr_api.g_varchar2) <>
1011: nvl(p_rec.org_information16, hr_api.g_varchar2) or

Line 1008: nvl(hr_ori_shd.g_old_rec.org_information15, hr_api.g_varchar2) <>

1004: nvl(hr_ori_shd.g_old_rec.org_information13, hr_api.g_varchar2) <>
1005: nvl(p_rec.org_information13, hr_api.g_varchar2) or
1006: nvl(hr_ori_shd.g_old_rec.org_information14, hr_api.g_varchar2) <>
1007: nvl(p_rec.org_information14, hr_api.g_varchar2) or
1008: nvl(hr_ori_shd.g_old_rec.org_information15, hr_api.g_varchar2) <>
1009: nvl(p_rec.org_information15, hr_api.g_varchar2) or
1010: nvl(hr_ori_shd.g_old_rec.org_information16, hr_api.g_varchar2) <>
1011: nvl(p_rec.org_information16, hr_api.g_varchar2) or
1012: nvl(hr_ori_shd.g_old_rec.org_information17, hr_api.g_varchar2) <>

Line 1009: nvl(p_rec.org_information15, hr_api.g_varchar2) or

1005: nvl(p_rec.org_information13, hr_api.g_varchar2) or
1006: nvl(hr_ori_shd.g_old_rec.org_information14, hr_api.g_varchar2) <>
1007: nvl(p_rec.org_information14, hr_api.g_varchar2) or
1008: nvl(hr_ori_shd.g_old_rec.org_information15, hr_api.g_varchar2) <>
1009: nvl(p_rec.org_information15, hr_api.g_varchar2) or
1010: nvl(hr_ori_shd.g_old_rec.org_information16, hr_api.g_varchar2) <>
1011: nvl(p_rec.org_information16, hr_api.g_varchar2) or
1012: nvl(hr_ori_shd.g_old_rec.org_information17, hr_api.g_varchar2) <>
1013: nvl(p_rec.org_information17, hr_api.g_varchar2) or

Line 1010: nvl(hr_ori_shd.g_old_rec.org_information16, hr_api.g_varchar2) <>

1006: nvl(hr_ori_shd.g_old_rec.org_information14, hr_api.g_varchar2) <>
1007: nvl(p_rec.org_information14, hr_api.g_varchar2) or
1008: nvl(hr_ori_shd.g_old_rec.org_information15, hr_api.g_varchar2) <>
1009: nvl(p_rec.org_information15, hr_api.g_varchar2) or
1010: nvl(hr_ori_shd.g_old_rec.org_information16, hr_api.g_varchar2) <>
1011: nvl(p_rec.org_information16, hr_api.g_varchar2) or
1012: nvl(hr_ori_shd.g_old_rec.org_information17, hr_api.g_varchar2) <>
1013: nvl(p_rec.org_information17, hr_api.g_varchar2) or
1014: nvl(hr_ori_shd.g_old_rec.org_information18, hr_api.g_varchar2) <>

Line 1011: nvl(p_rec.org_information16, hr_api.g_varchar2) or

1007: nvl(p_rec.org_information14, hr_api.g_varchar2) or
1008: nvl(hr_ori_shd.g_old_rec.org_information15, hr_api.g_varchar2) <>
1009: nvl(p_rec.org_information15, hr_api.g_varchar2) or
1010: nvl(hr_ori_shd.g_old_rec.org_information16, hr_api.g_varchar2) <>
1011: nvl(p_rec.org_information16, hr_api.g_varchar2) or
1012: nvl(hr_ori_shd.g_old_rec.org_information17, hr_api.g_varchar2) <>
1013: nvl(p_rec.org_information17, hr_api.g_varchar2) or
1014: nvl(hr_ori_shd.g_old_rec.org_information18, hr_api.g_varchar2) <>
1015: nvl(p_rec.org_information18, hr_api.g_varchar2) or

Line 1012: nvl(hr_ori_shd.g_old_rec.org_information17, hr_api.g_varchar2) <>

1008: nvl(hr_ori_shd.g_old_rec.org_information15, hr_api.g_varchar2) <>
1009: nvl(p_rec.org_information15, hr_api.g_varchar2) or
1010: nvl(hr_ori_shd.g_old_rec.org_information16, hr_api.g_varchar2) <>
1011: nvl(p_rec.org_information16, hr_api.g_varchar2) or
1012: nvl(hr_ori_shd.g_old_rec.org_information17, hr_api.g_varchar2) <>
1013: nvl(p_rec.org_information17, hr_api.g_varchar2) or
1014: nvl(hr_ori_shd.g_old_rec.org_information18, hr_api.g_varchar2) <>
1015: nvl(p_rec.org_information18, hr_api.g_varchar2) or
1016: nvl(hr_ori_shd.g_old_rec.org_information19, hr_api.g_varchar2) <>

Line 1013: nvl(p_rec.org_information17, hr_api.g_varchar2) or

1009: nvl(p_rec.org_information15, hr_api.g_varchar2) or
1010: nvl(hr_ori_shd.g_old_rec.org_information16, hr_api.g_varchar2) <>
1011: nvl(p_rec.org_information16, hr_api.g_varchar2) or
1012: nvl(hr_ori_shd.g_old_rec.org_information17, hr_api.g_varchar2) <>
1013: nvl(p_rec.org_information17, hr_api.g_varchar2) or
1014: nvl(hr_ori_shd.g_old_rec.org_information18, hr_api.g_varchar2) <>
1015: nvl(p_rec.org_information18, hr_api.g_varchar2) or
1016: nvl(hr_ori_shd.g_old_rec.org_information19, hr_api.g_varchar2) <>
1017: nvl(p_rec.org_information19, hr_api.g_varchar2) or

Line 1014: nvl(hr_ori_shd.g_old_rec.org_information18, hr_api.g_varchar2) <>

1010: nvl(hr_ori_shd.g_old_rec.org_information16, hr_api.g_varchar2) <>
1011: nvl(p_rec.org_information16, hr_api.g_varchar2) or
1012: nvl(hr_ori_shd.g_old_rec.org_information17, hr_api.g_varchar2) <>
1013: nvl(p_rec.org_information17, hr_api.g_varchar2) or
1014: nvl(hr_ori_shd.g_old_rec.org_information18, hr_api.g_varchar2) <>
1015: nvl(p_rec.org_information18, hr_api.g_varchar2) or
1016: nvl(hr_ori_shd.g_old_rec.org_information19, hr_api.g_varchar2) <>
1017: nvl(p_rec.org_information19, hr_api.g_varchar2) or
1018: nvl(hr_ori_shd.g_old_rec.org_information2, hr_api.g_varchar2) <>

Line 1015: nvl(p_rec.org_information18, hr_api.g_varchar2) or

1011: nvl(p_rec.org_information16, hr_api.g_varchar2) or
1012: nvl(hr_ori_shd.g_old_rec.org_information17, hr_api.g_varchar2) <>
1013: nvl(p_rec.org_information17, hr_api.g_varchar2) or
1014: nvl(hr_ori_shd.g_old_rec.org_information18, hr_api.g_varchar2) <>
1015: nvl(p_rec.org_information18, hr_api.g_varchar2) or
1016: nvl(hr_ori_shd.g_old_rec.org_information19, hr_api.g_varchar2) <>
1017: nvl(p_rec.org_information19, hr_api.g_varchar2) or
1018: nvl(hr_ori_shd.g_old_rec.org_information2, hr_api.g_varchar2) <>
1019: nvl(p_rec.org_information2, hr_api.g_varchar2) or

Line 1016: nvl(hr_ori_shd.g_old_rec.org_information19, hr_api.g_varchar2) <>

1012: nvl(hr_ori_shd.g_old_rec.org_information17, hr_api.g_varchar2) <>
1013: nvl(p_rec.org_information17, hr_api.g_varchar2) or
1014: nvl(hr_ori_shd.g_old_rec.org_information18, hr_api.g_varchar2) <>
1015: nvl(p_rec.org_information18, hr_api.g_varchar2) or
1016: nvl(hr_ori_shd.g_old_rec.org_information19, hr_api.g_varchar2) <>
1017: nvl(p_rec.org_information19, hr_api.g_varchar2) or
1018: nvl(hr_ori_shd.g_old_rec.org_information2, hr_api.g_varchar2) <>
1019: nvl(p_rec.org_information2, hr_api.g_varchar2) or
1020: nvl(hr_ori_shd.g_old_rec.org_information20, hr_api.g_varchar2) <>

Line 1017: nvl(p_rec.org_information19, hr_api.g_varchar2) or

1013: nvl(p_rec.org_information17, hr_api.g_varchar2) or
1014: nvl(hr_ori_shd.g_old_rec.org_information18, hr_api.g_varchar2) <>
1015: nvl(p_rec.org_information18, hr_api.g_varchar2) or
1016: nvl(hr_ori_shd.g_old_rec.org_information19, hr_api.g_varchar2) <>
1017: nvl(p_rec.org_information19, hr_api.g_varchar2) or
1018: nvl(hr_ori_shd.g_old_rec.org_information2, hr_api.g_varchar2) <>
1019: nvl(p_rec.org_information2, hr_api.g_varchar2) or
1020: nvl(hr_ori_shd.g_old_rec.org_information20, hr_api.g_varchar2) <>
1021: nvl(p_rec.org_information20, hr_api.g_varchar2) or

Line 1018: nvl(hr_ori_shd.g_old_rec.org_information2, hr_api.g_varchar2) <>

1014: nvl(hr_ori_shd.g_old_rec.org_information18, hr_api.g_varchar2) <>
1015: nvl(p_rec.org_information18, hr_api.g_varchar2) or
1016: nvl(hr_ori_shd.g_old_rec.org_information19, hr_api.g_varchar2) <>
1017: nvl(p_rec.org_information19, hr_api.g_varchar2) or
1018: nvl(hr_ori_shd.g_old_rec.org_information2, hr_api.g_varchar2) <>
1019: nvl(p_rec.org_information2, hr_api.g_varchar2) or
1020: nvl(hr_ori_shd.g_old_rec.org_information20, hr_api.g_varchar2) <>
1021: nvl(p_rec.org_information20, hr_api.g_varchar2) or
1022: nvl(hr_ori_shd.g_old_rec.org_information3, hr_api.g_varchar2) <>

Line 1019: nvl(p_rec.org_information2, hr_api.g_varchar2) or

1015: nvl(p_rec.org_information18, hr_api.g_varchar2) or
1016: nvl(hr_ori_shd.g_old_rec.org_information19, hr_api.g_varchar2) <>
1017: nvl(p_rec.org_information19, hr_api.g_varchar2) or
1018: nvl(hr_ori_shd.g_old_rec.org_information2, hr_api.g_varchar2) <>
1019: nvl(p_rec.org_information2, hr_api.g_varchar2) or
1020: nvl(hr_ori_shd.g_old_rec.org_information20, hr_api.g_varchar2) <>
1021: nvl(p_rec.org_information20, hr_api.g_varchar2) or
1022: nvl(hr_ori_shd.g_old_rec.org_information3, hr_api.g_varchar2) <>
1023: nvl(p_rec.org_information3, hr_api.g_varchar2) or

Line 1020: nvl(hr_ori_shd.g_old_rec.org_information20, hr_api.g_varchar2) <>

1016: nvl(hr_ori_shd.g_old_rec.org_information19, hr_api.g_varchar2) <>
1017: nvl(p_rec.org_information19, hr_api.g_varchar2) or
1018: nvl(hr_ori_shd.g_old_rec.org_information2, hr_api.g_varchar2) <>
1019: nvl(p_rec.org_information2, hr_api.g_varchar2) or
1020: nvl(hr_ori_shd.g_old_rec.org_information20, hr_api.g_varchar2) <>
1021: nvl(p_rec.org_information20, hr_api.g_varchar2) or
1022: nvl(hr_ori_shd.g_old_rec.org_information3, hr_api.g_varchar2) <>
1023: nvl(p_rec.org_information3, hr_api.g_varchar2) or
1024: nvl(hr_ori_shd.g_old_rec.org_information4, hr_api.g_varchar2) <>

Line 1021: nvl(p_rec.org_information20, hr_api.g_varchar2) or

1017: nvl(p_rec.org_information19, hr_api.g_varchar2) or
1018: nvl(hr_ori_shd.g_old_rec.org_information2, hr_api.g_varchar2) <>
1019: nvl(p_rec.org_information2, hr_api.g_varchar2) or
1020: nvl(hr_ori_shd.g_old_rec.org_information20, hr_api.g_varchar2) <>
1021: nvl(p_rec.org_information20, hr_api.g_varchar2) or
1022: nvl(hr_ori_shd.g_old_rec.org_information3, hr_api.g_varchar2) <>
1023: nvl(p_rec.org_information3, hr_api.g_varchar2) or
1024: nvl(hr_ori_shd.g_old_rec.org_information4, hr_api.g_varchar2) <>
1025: nvl(p_rec.org_information4, hr_api.g_varchar2) or

Line 1022: nvl(hr_ori_shd.g_old_rec.org_information3, hr_api.g_varchar2) <>

1018: nvl(hr_ori_shd.g_old_rec.org_information2, hr_api.g_varchar2) <>
1019: nvl(p_rec.org_information2, hr_api.g_varchar2) or
1020: nvl(hr_ori_shd.g_old_rec.org_information20, hr_api.g_varchar2) <>
1021: nvl(p_rec.org_information20, hr_api.g_varchar2) or
1022: nvl(hr_ori_shd.g_old_rec.org_information3, hr_api.g_varchar2) <>
1023: nvl(p_rec.org_information3, hr_api.g_varchar2) or
1024: nvl(hr_ori_shd.g_old_rec.org_information4, hr_api.g_varchar2) <>
1025: nvl(p_rec.org_information4, hr_api.g_varchar2) or
1026: nvl(hr_ori_shd.g_old_rec.org_information5, hr_api.g_varchar2) <>

Line 1023: nvl(p_rec.org_information3, hr_api.g_varchar2) or

1019: nvl(p_rec.org_information2, hr_api.g_varchar2) or
1020: nvl(hr_ori_shd.g_old_rec.org_information20, hr_api.g_varchar2) <>
1021: nvl(p_rec.org_information20, hr_api.g_varchar2) or
1022: nvl(hr_ori_shd.g_old_rec.org_information3, hr_api.g_varchar2) <>
1023: nvl(p_rec.org_information3, hr_api.g_varchar2) or
1024: nvl(hr_ori_shd.g_old_rec.org_information4, hr_api.g_varchar2) <>
1025: nvl(p_rec.org_information4, hr_api.g_varchar2) or
1026: nvl(hr_ori_shd.g_old_rec.org_information5, hr_api.g_varchar2) <>
1027: nvl(p_rec.org_information5, hr_api.g_varchar2) or

Line 1024: nvl(hr_ori_shd.g_old_rec.org_information4, hr_api.g_varchar2) <>

1020: nvl(hr_ori_shd.g_old_rec.org_information20, hr_api.g_varchar2) <>
1021: nvl(p_rec.org_information20, hr_api.g_varchar2) or
1022: nvl(hr_ori_shd.g_old_rec.org_information3, hr_api.g_varchar2) <>
1023: nvl(p_rec.org_information3, hr_api.g_varchar2) or
1024: nvl(hr_ori_shd.g_old_rec.org_information4, hr_api.g_varchar2) <>
1025: nvl(p_rec.org_information4, hr_api.g_varchar2) or
1026: nvl(hr_ori_shd.g_old_rec.org_information5, hr_api.g_varchar2) <>
1027: nvl(p_rec.org_information5, hr_api.g_varchar2) or
1028: nvl(hr_ori_shd.g_old_rec.org_information6, hr_api.g_varchar2) <>

Line 1025: nvl(p_rec.org_information4, hr_api.g_varchar2) or

1021: nvl(p_rec.org_information20, hr_api.g_varchar2) or
1022: nvl(hr_ori_shd.g_old_rec.org_information3, hr_api.g_varchar2) <>
1023: nvl(p_rec.org_information3, hr_api.g_varchar2) or
1024: nvl(hr_ori_shd.g_old_rec.org_information4, hr_api.g_varchar2) <>
1025: nvl(p_rec.org_information4, hr_api.g_varchar2) or
1026: nvl(hr_ori_shd.g_old_rec.org_information5, hr_api.g_varchar2) <>
1027: nvl(p_rec.org_information5, hr_api.g_varchar2) or
1028: nvl(hr_ori_shd.g_old_rec.org_information6, hr_api.g_varchar2) <>
1029: nvl(p_rec.org_information6, hr_api.g_varchar2) or

Line 1026: nvl(hr_ori_shd.g_old_rec.org_information5, hr_api.g_varchar2) <>

1022: nvl(hr_ori_shd.g_old_rec.org_information3, hr_api.g_varchar2) <>
1023: nvl(p_rec.org_information3, hr_api.g_varchar2) or
1024: nvl(hr_ori_shd.g_old_rec.org_information4, hr_api.g_varchar2) <>
1025: nvl(p_rec.org_information4, hr_api.g_varchar2) or
1026: nvl(hr_ori_shd.g_old_rec.org_information5, hr_api.g_varchar2) <>
1027: nvl(p_rec.org_information5, hr_api.g_varchar2) or
1028: nvl(hr_ori_shd.g_old_rec.org_information6, hr_api.g_varchar2) <>
1029: nvl(p_rec.org_information6, hr_api.g_varchar2) or
1030: nvl(hr_ori_shd.g_old_rec.org_information7, hr_api.g_varchar2) <>

Line 1027: nvl(p_rec.org_information5, hr_api.g_varchar2) or

1023: nvl(p_rec.org_information3, hr_api.g_varchar2) or
1024: nvl(hr_ori_shd.g_old_rec.org_information4, hr_api.g_varchar2) <>
1025: nvl(p_rec.org_information4, hr_api.g_varchar2) or
1026: nvl(hr_ori_shd.g_old_rec.org_information5, hr_api.g_varchar2) <>
1027: nvl(p_rec.org_information5, hr_api.g_varchar2) or
1028: nvl(hr_ori_shd.g_old_rec.org_information6, hr_api.g_varchar2) <>
1029: nvl(p_rec.org_information6, hr_api.g_varchar2) or
1030: nvl(hr_ori_shd.g_old_rec.org_information7, hr_api.g_varchar2) <>
1031: nvl(p_rec.org_information7, hr_api.g_varchar2) or

Line 1028: nvl(hr_ori_shd.g_old_rec.org_information6, hr_api.g_varchar2) <>

1024: nvl(hr_ori_shd.g_old_rec.org_information4, hr_api.g_varchar2) <>
1025: nvl(p_rec.org_information4, hr_api.g_varchar2) or
1026: nvl(hr_ori_shd.g_old_rec.org_information5, hr_api.g_varchar2) <>
1027: nvl(p_rec.org_information5, hr_api.g_varchar2) or
1028: nvl(hr_ori_shd.g_old_rec.org_information6, hr_api.g_varchar2) <>
1029: nvl(p_rec.org_information6, hr_api.g_varchar2) or
1030: nvl(hr_ori_shd.g_old_rec.org_information7, hr_api.g_varchar2) <>
1031: nvl(p_rec.org_information7, hr_api.g_varchar2) or
1032: nvl(hr_ori_shd.g_old_rec.org_information8, hr_api.g_varchar2) <>

Line 1029: nvl(p_rec.org_information6, hr_api.g_varchar2) or

1025: nvl(p_rec.org_information4, hr_api.g_varchar2) or
1026: nvl(hr_ori_shd.g_old_rec.org_information5, hr_api.g_varchar2) <>
1027: nvl(p_rec.org_information5, hr_api.g_varchar2) or
1028: nvl(hr_ori_shd.g_old_rec.org_information6, hr_api.g_varchar2) <>
1029: nvl(p_rec.org_information6, hr_api.g_varchar2) or
1030: nvl(hr_ori_shd.g_old_rec.org_information7, hr_api.g_varchar2) <>
1031: nvl(p_rec.org_information7, hr_api.g_varchar2) or
1032: nvl(hr_ori_shd.g_old_rec.org_information8, hr_api.g_varchar2) <>
1033: nvl(p_rec.org_information8, hr_api.g_varchar2) or

Line 1030: nvl(hr_ori_shd.g_old_rec.org_information7, hr_api.g_varchar2) <>

1026: nvl(hr_ori_shd.g_old_rec.org_information5, hr_api.g_varchar2) <>
1027: nvl(p_rec.org_information5, hr_api.g_varchar2) or
1028: nvl(hr_ori_shd.g_old_rec.org_information6, hr_api.g_varchar2) <>
1029: nvl(p_rec.org_information6, hr_api.g_varchar2) or
1030: nvl(hr_ori_shd.g_old_rec.org_information7, hr_api.g_varchar2) <>
1031: nvl(p_rec.org_information7, hr_api.g_varchar2) or
1032: nvl(hr_ori_shd.g_old_rec.org_information8, hr_api.g_varchar2) <>
1033: nvl(p_rec.org_information8, hr_api.g_varchar2) or
1034: nvl(hr_ori_shd.g_old_rec.org_information9, hr_api.g_varchar2) <>

Line 1031: nvl(p_rec.org_information7, hr_api.g_varchar2) or

1027: nvl(p_rec.org_information5, hr_api.g_varchar2) or
1028: nvl(hr_ori_shd.g_old_rec.org_information6, hr_api.g_varchar2) <>
1029: nvl(p_rec.org_information6, hr_api.g_varchar2) or
1030: nvl(hr_ori_shd.g_old_rec.org_information7, hr_api.g_varchar2) <>
1031: nvl(p_rec.org_information7, hr_api.g_varchar2) or
1032: nvl(hr_ori_shd.g_old_rec.org_information8, hr_api.g_varchar2) <>
1033: nvl(p_rec.org_information8, hr_api.g_varchar2) or
1034: nvl(hr_ori_shd.g_old_rec.org_information9, hr_api.g_varchar2) <>
1035: nvl(p_rec.org_information9, hr_api.g_varchar2) ))

Line 1032: nvl(hr_ori_shd.g_old_rec.org_information8, hr_api.g_varchar2) <>

1028: nvl(hr_ori_shd.g_old_rec.org_information6, hr_api.g_varchar2) <>
1029: nvl(p_rec.org_information6, hr_api.g_varchar2) or
1030: nvl(hr_ori_shd.g_old_rec.org_information7, hr_api.g_varchar2) <>
1031: nvl(p_rec.org_information7, hr_api.g_varchar2) or
1032: nvl(hr_ori_shd.g_old_rec.org_information8, hr_api.g_varchar2) <>
1033: nvl(p_rec.org_information8, hr_api.g_varchar2) or
1034: nvl(hr_ori_shd.g_old_rec.org_information9, hr_api.g_varchar2) <>
1035: nvl(p_rec.org_information9, hr_api.g_varchar2) ))
1036: or (p_rec.org_information_id is null) then

Line 1033: nvl(p_rec.org_information8, hr_api.g_varchar2) or

1029: nvl(p_rec.org_information6, hr_api.g_varchar2) or
1030: nvl(hr_ori_shd.g_old_rec.org_information7, hr_api.g_varchar2) <>
1031: nvl(p_rec.org_information7, hr_api.g_varchar2) or
1032: nvl(hr_ori_shd.g_old_rec.org_information8, hr_api.g_varchar2) <>
1033: nvl(p_rec.org_information8, hr_api.g_varchar2) or
1034: nvl(hr_ori_shd.g_old_rec.org_information9, hr_api.g_varchar2) <>
1035: nvl(p_rec.org_information9, hr_api.g_varchar2) ))
1036: or (p_rec.org_information_id is null) then
1037: --

Line 1034: nvl(hr_ori_shd.g_old_rec.org_information9, hr_api.g_varchar2) <>

1030: nvl(hr_ori_shd.g_old_rec.org_information7, hr_api.g_varchar2) <>
1031: nvl(p_rec.org_information7, hr_api.g_varchar2) or
1032: nvl(hr_ori_shd.g_old_rec.org_information8, hr_api.g_varchar2) <>
1033: nvl(p_rec.org_information8, hr_api.g_varchar2) or
1034: nvl(hr_ori_shd.g_old_rec.org_information9, hr_api.g_varchar2) <>
1035: nvl(p_rec.org_information9, hr_api.g_varchar2) ))
1036: or (p_rec.org_information_id is null) then
1037: --
1038: -- Only execute the validation if absolutely necessary:

Line 1035: nvl(p_rec.org_information9, hr_api.g_varchar2) ))

1031: nvl(p_rec.org_information7, hr_api.g_varchar2) or
1032: nvl(hr_ori_shd.g_old_rec.org_information8, hr_api.g_varchar2) <>
1033: nvl(p_rec.org_information8, hr_api.g_varchar2) or
1034: nvl(hr_ori_shd.g_old_rec.org_information9, hr_api.g_varchar2) <>
1035: nvl(p_rec.org_information9, hr_api.g_varchar2) ))
1036: or (p_rec.org_information_id is null) then
1037: --
1038: -- Only execute the validation if absolutely necessary:
1039: -- a) During update, the structure column value or any

Line 1151: nvl(hr_ori_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

1147: begin
1148: hr_utility.set_location('Entering:'||l_proc,10);
1149: --
1150: if ((p_rec.org_information_id is not null) and (
1151: nvl(hr_ori_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1152: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1153: nvl(hr_ori_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1154: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1155: nvl(hr_ori_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 1152: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

1148: hr_utility.set_location('Entering:'||l_proc,10);
1149: --
1150: if ((p_rec.org_information_id is not null) and (
1151: nvl(hr_ori_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1152: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1153: nvl(hr_ori_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1154: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1155: nvl(hr_ori_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1156: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 1153: nvl(hr_ori_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

1149: --
1150: if ((p_rec.org_information_id is not null) and (
1151: nvl(hr_ori_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1152: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1153: nvl(hr_ori_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1154: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1155: nvl(hr_ori_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1156: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1157: nvl(hr_ori_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 1154: nvl(p_rec.attribute1, hr_api.g_varchar2) or

1150: if ((p_rec.org_information_id is not null) and (
1151: nvl(hr_ori_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1152: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1153: nvl(hr_ori_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1154: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1155: nvl(hr_ori_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1156: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1157: nvl(hr_ori_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1158: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 1155: nvl(hr_ori_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

1151: nvl(hr_ori_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1152: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1153: nvl(hr_ori_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1154: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1155: nvl(hr_ori_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1156: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1157: nvl(hr_ori_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1158: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1159: nvl(hr_ori_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 1156: nvl(p_rec.attribute2, hr_api.g_varchar2) or

1152: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1153: nvl(hr_ori_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1154: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1155: nvl(hr_ori_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1156: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1157: nvl(hr_ori_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1158: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1159: nvl(hr_ori_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1160: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 1157: nvl(hr_ori_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

1153: nvl(hr_ori_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1154: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1155: nvl(hr_ori_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1156: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1157: nvl(hr_ori_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1158: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1159: nvl(hr_ori_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1160: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1161: nvl(hr_ori_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 1158: nvl(p_rec.attribute3, hr_api.g_varchar2) or

1154: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1155: nvl(hr_ori_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1156: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1157: nvl(hr_ori_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1158: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1159: nvl(hr_ori_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1160: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1161: nvl(hr_ori_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1162: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 1159: nvl(hr_ori_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

1155: nvl(hr_ori_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1156: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1157: nvl(hr_ori_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1158: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1159: nvl(hr_ori_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1160: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1161: nvl(hr_ori_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1162: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1163: nvl(hr_ori_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 1160: nvl(p_rec.attribute4, hr_api.g_varchar2) or

1156: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1157: nvl(hr_ori_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1158: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1159: nvl(hr_ori_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1160: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1161: nvl(hr_ori_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1162: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1163: nvl(hr_ori_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1164: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 1161: nvl(hr_ori_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

1157: nvl(hr_ori_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1158: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1159: nvl(hr_ori_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1160: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1161: nvl(hr_ori_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1162: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1163: nvl(hr_ori_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1164: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1165: nvl(hr_ori_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 1162: nvl(p_rec.attribute5, hr_api.g_varchar2) or

1158: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1159: nvl(hr_ori_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1160: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1161: nvl(hr_ori_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1162: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1163: nvl(hr_ori_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1164: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1165: nvl(hr_ori_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1166: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 1163: nvl(hr_ori_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

1159: nvl(hr_ori_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1160: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1161: nvl(hr_ori_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1162: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1163: nvl(hr_ori_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1164: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1165: nvl(hr_ori_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1166: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1167: nvl(hr_ori_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 1164: nvl(p_rec.attribute6, hr_api.g_varchar2) or

1160: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1161: nvl(hr_ori_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1162: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1163: nvl(hr_ori_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1164: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1165: nvl(hr_ori_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1166: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1167: nvl(hr_ori_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1168: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 1165: nvl(hr_ori_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

1161: nvl(hr_ori_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1162: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1163: nvl(hr_ori_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1164: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1165: nvl(hr_ori_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1166: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1167: nvl(hr_ori_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1168: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1169: nvl(hr_ori_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 1166: nvl(p_rec.attribute7, hr_api.g_varchar2) or

1162: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1163: nvl(hr_ori_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1164: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1165: nvl(hr_ori_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1166: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1167: nvl(hr_ori_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1168: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1169: nvl(hr_ori_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1170: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 1167: nvl(hr_ori_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

1163: nvl(hr_ori_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1164: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1165: nvl(hr_ori_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1166: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1167: nvl(hr_ori_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1168: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1169: nvl(hr_ori_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1170: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1171: nvl(hr_ori_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 1168: nvl(p_rec.attribute8, hr_api.g_varchar2) or

1164: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1165: nvl(hr_ori_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1166: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1167: nvl(hr_ori_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1168: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1169: nvl(hr_ori_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1170: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1171: nvl(hr_ori_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1172: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 1169: nvl(hr_ori_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

1165: nvl(hr_ori_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1166: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1167: nvl(hr_ori_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1168: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1169: nvl(hr_ori_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1170: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1171: nvl(hr_ori_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1172: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1173: nvl(hr_ori_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 1170: nvl(p_rec.attribute9, hr_api.g_varchar2) or

1166: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1167: nvl(hr_ori_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1168: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1169: nvl(hr_ori_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1170: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1171: nvl(hr_ori_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1172: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1173: nvl(hr_ori_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1174: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 1171: nvl(hr_ori_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

1167: nvl(hr_ori_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1168: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1169: nvl(hr_ori_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1170: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1171: nvl(hr_ori_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1172: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1173: nvl(hr_ori_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1174: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1175: nvl(hr_ori_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 1172: nvl(p_rec.attribute10, hr_api.g_varchar2) or

1168: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1169: nvl(hr_ori_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1170: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1171: nvl(hr_ori_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1172: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1173: nvl(hr_ori_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1174: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1175: nvl(hr_ori_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1176: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 1173: nvl(hr_ori_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

1169: nvl(hr_ori_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1170: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1171: nvl(hr_ori_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1172: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1173: nvl(hr_ori_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1174: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1175: nvl(hr_ori_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1176: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1177: nvl(hr_ori_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 1174: nvl(p_rec.attribute11, hr_api.g_varchar2) or

1170: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1171: nvl(hr_ori_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1172: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1173: nvl(hr_ori_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1174: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1175: nvl(hr_ori_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1176: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1177: nvl(hr_ori_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1178: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 1175: nvl(hr_ori_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

1171: nvl(hr_ori_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1172: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1173: nvl(hr_ori_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1174: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1175: nvl(hr_ori_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1176: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1177: nvl(hr_ori_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1178: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1179: nvl(hr_ori_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 1176: nvl(p_rec.attribute12, hr_api.g_varchar2) or

1172: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1173: nvl(hr_ori_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1174: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1175: nvl(hr_ori_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1176: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1177: nvl(hr_ori_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1178: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1179: nvl(hr_ori_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1180: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 1177: nvl(hr_ori_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

1173: nvl(hr_ori_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1174: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1175: nvl(hr_ori_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1176: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1177: nvl(hr_ori_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1178: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1179: nvl(hr_ori_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1180: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1181: nvl(hr_ori_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 1178: nvl(p_rec.attribute13, hr_api.g_varchar2) or

1174: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1175: nvl(hr_ori_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1176: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1177: nvl(hr_ori_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1178: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1179: nvl(hr_ori_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1180: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1181: nvl(hr_ori_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1182: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 1179: nvl(hr_ori_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

1175: nvl(hr_ori_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1176: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1177: nvl(hr_ori_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1178: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1179: nvl(hr_ori_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1180: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1181: nvl(hr_ori_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1182: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1183: nvl(hr_ori_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 1180: nvl(p_rec.attribute14, hr_api.g_varchar2) or

1176: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1177: nvl(hr_ori_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1178: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1179: nvl(hr_ori_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1180: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1181: nvl(hr_ori_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1182: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1183: nvl(hr_ori_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1184: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 1181: nvl(hr_ori_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

1177: nvl(hr_ori_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1178: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1179: nvl(hr_ori_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1180: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1181: nvl(hr_ori_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1182: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1183: nvl(hr_ori_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1184: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1185: nvl(hr_ori_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 1182: nvl(p_rec.attribute15, hr_api.g_varchar2) or

1178: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1179: nvl(hr_ori_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1180: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1181: nvl(hr_ori_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1182: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1183: nvl(hr_ori_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1184: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1185: nvl(hr_ori_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1186: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 1183: nvl(hr_ori_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

1179: nvl(hr_ori_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1180: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1181: nvl(hr_ori_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1182: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1183: nvl(hr_ori_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1184: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1185: nvl(hr_ori_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1186: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1187: nvl(hr_ori_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 1184: nvl(p_rec.attribute16, hr_api.g_varchar2) or

1180: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1181: nvl(hr_ori_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1182: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1183: nvl(hr_ori_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1184: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1185: nvl(hr_ori_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1186: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1187: nvl(hr_ori_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1188: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 1185: nvl(hr_ori_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

1181: nvl(hr_ori_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1182: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1183: nvl(hr_ori_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1184: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1185: nvl(hr_ori_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1186: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1187: nvl(hr_ori_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1188: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1189: nvl(hr_ori_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 1186: nvl(p_rec.attribute17, hr_api.g_varchar2) or

1182: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1183: nvl(hr_ori_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1184: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1185: nvl(hr_ori_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1186: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1187: nvl(hr_ori_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1188: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1189: nvl(hr_ori_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1190: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 1187: nvl(hr_ori_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

1183: nvl(hr_ori_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1184: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1185: nvl(hr_ori_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1186: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1187: nvl(hr_ori_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1188: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1189: nvl(hr_ori_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1190: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1191: nvl(hr_ori_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 1188: nvl(p_rec.attribute18, hr_api.g_varchar2) or

1184: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1185: nvl(hr_ori_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1186: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1187: nvl(hr_ori_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1188: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1189: nvl(hr_ori_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1190: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1191: nvl(hr_ori_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1192: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

Line 1189: nvl(hr_ori_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

1185: nvl(hr_ori_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1186: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1187: nvl(hr_ori_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1188: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1189: nvl(hr_ori_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1190: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1191: nvl(hr_ori_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1192: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
1193: or (p_rec.org_information_id is null) then

Line 1190: nvl(p_rec.attribute19, hr_api.g_varchar2) or

1186: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1187: nvl(hr_ori_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1188: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1189: nvl(hr_ori_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1190: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1191: nvl(hr_ori_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1192: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
1193: or (p_rec.org_information_id is null) then
1194: --

Line 1191: nvl(hr_ori_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

1187: nvl(hr_ori_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1188: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1189: nvl(hr_ori_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1190: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1191: nvl(hr_ori_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1192: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
1193: or (p_rec.org_information_id is null) then
1194: --
1195: -- Only execute the validation if absolutely necessary:

Line 1192: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

1188: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1189: nvl(hr_ori_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1190: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1191: nvl(hr_ori_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1192: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
1193: or (p_rec.org_information_id is null) then
1194: --
1195: -- Only execute the validation if absolutely necessary:
1196: -- a) During update, the structure column value or any

Line 1304: IF nvl(p_rec.org_information_context, hr_api.g_varchar2) <>

1300: --
1301: -- EDIT_HERE: Add checks to ensure non-updateable args have
1302: -- not been updated.
1303: --
1304: IF nvl(p_rec.org_information_context, hr_api.g_varchar2) <>
1305: nvl(hr_ori_shd.g_old_rec.org_information_context, hr_api.g_varchar2) THEN
1306: l_argument := 'ORG_INFORMATION_CONTEXT';
1307: RAISE l_error;
1308: END IF;

Line 1305: nvl(hr_ori_shd.g_old_rec.org_information_context, hr_api.g_varchar2) THEN

1301: -- EDIT_HERE: Add checks to ensure non-updateable args have
1302: -- not been updated.
1303: --
1304: IF nvl(p_rec.org_information_context, hr_api.g_varchar2) <>
1305: nvl(hr_ori_shd.g_old_rec.org_information_context, hr_api.g_varchar2) THEN
1306: l_argument := 'ORG_INFORMATION_CONTEXT';
1307: RAISE l_error;
1308: END IF;
1309: --

Line 1312: hr_api.argument_changed_error

1308: END IF;
1309: --
1310: EXCEPTION
1311: WHEN l_error THEN
1312: hr_api.argument_changed_error
1313: (p_api_name => l_proc
1314: ,p_argument => l_argument);
1315: WHEN OTHERS THEN
1316: RAISE;

Line 1898: hr_api.validate_bus_grp_id(l_bg_id); -- Validate Bus Grp

1894:
1895: Begin
1896: Open c_bg;
1897: Fetch c_bg into l_bg_id;
1898: hr_api.validate_bus_grp_id(l_bg_id); -- Validate Bus Grp
1899: Close c_bg;
1900:
1901:
1902: End chk_bus_grp;

Line 1922: hr_api.mandatory_arg_error

1918: hr_utility.set_location('Entering:'||l_proc, 5);
1919: --
1920: -- Call all supporting business operations
1921:
1922: hr_api.mandatory_arg_error
1923: (p_api_name => l_proc
1924: ,p_argument => 'ORGANIZATION_ID'
1925: ,p_argument_value => p_rec.organization_id
1926: );

Line 1929: hr_api.mandatory_arg_error

1925: ,p_argument_value => p_rec.organization_id
1926: );
1927: --
1928: --
1929: hr_api.mandatory_arg_error
1930: (p_api_name => l_proc
1931: ,p_argument => 'ORG_INFORMATION_CONTEXT'
1932: ,p_argument_value => p_rec.org_information_context
1933: );

Line 2103: hr_api.mandatory_arg_error

2099: -- Call all supporting business operations
2100: --
2101: --
2102: --
2103: hr_api.mandatory_arg_error
2104: (p_api_name => l_proc
2105: ,p_argument => 'ORG_INFORMATION_CONTEXT'
2106: ,p_argument_value => p_rec.org_information_context
2107: );