APPS.PER_PPB_BUS dependencies on HR_API

Line 45: hr_api.mandatory_arg_error

41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Ensure that all the mandatory parameter are not null
44: --
45: hr_api.mandatory_arg_error
46: (p_api_name => l_proc
47: ,p_argument => 'pay_basis_id'
48: ,p_argument_value => p_pay_basis_id
49: );

Line 71: hr_api.set_security_group_id

67: close csr_sec_grp;
68: --
69: -- Set the security_group_id in CLIENT_INFO
70: --
71: hr_api.set_security_group_id
72: (p_security_group_id => l_security_group_id
73: );
74: end if;
75: --

Line 109: hr_api.mandatory_arg_error

105: hr_utility.set_location('Entering:'|| l_proc, 10);
106: --
107: -- Ensure that all the mandatory parameter are not null
108: --
109: hr_api.mandatory_arg_error
110: (p_api_name => l_proc
111: ,p_argument => 'pay_basis_id'
112: ,p_argument_value => p_pay_basis_id
113: );

Line 115: if ( nvl(per_ppb_bus.g_pay_basis_id, hr_api.g_number)

111: ,p_argument => 'pay_basis_id'
112: ,p_argument_value => p_pay_basis_id
113: );
114: --
115: if ( nvl(per_ppb_bus.g_pay_basis_id, hr_api.g_number)
116: = p_pay_basis_id) then
117: --
118: -- The legislation code has already been found with a previous
119: -- call to this function. Just return the value in the global

Line 199: and nvl(p_pay_basis_id,hr_api.g_number)

195: p_object_version_number => p_object_version_number
196: );
197: --
198: if (l_api_updating
199: and nvl(p_pay_basis_id,hr_api.g_number)
200: <> per_ppb_shd.g_old_rec.pay_basis_id) then
201: --
202: -- raise error as PK has changed
203: --

Line 342: hr_api.mandatory_arg_error

338: BEGIN
339: --
340: hr_utility.set_location('Entering:'||l_proc, 5);
341: --
342: hr_api.mandatory_arg_error
343: (p_api_name => l_proc,
344: p_argument => 'name',
345: p_argument_value => p_name);
346: --

Line 404: hr_api.mandatory_arg_error

400: --
401: --
402: hr_utility.set_location('Entering:'||l_proc, 10);
403:
404: hr_api.mandatory_arg_error
405: (p_api_name => l_proc,
406: p_argument => 'pay_basis',
407: p_argument_value => p_pay_basis);
408:

Line 419: IF hr_api.not_exists_in_hr_lookups

415: hr_utility.set_location(l_proc, 20);
416: --
417: -- Check that the reason type exists in HR_LOOKUPS
418: --
419: IF hr_api.not_exists_in_hr_lookups
420: (p_effective_date => sysdate
421: ,p_lookup_type => 'PAY_BASIS'
422: ,p_lookup_code => p_pay_basis) THEN
423: --

Line 506: hr_api.mandatory_arg_error

502: -- fnd_message.raise_error;
503: -- end if;
504: -- else
505:
506: hr_api.mandatory_arg_error
507: (p_api_name => l_proc,
508: p_argument => 'pay_annualization_factor',
509: p_argument_value => p_pay_annualization_factor);
510: end if;

Line 583: hr_api.mandatory_arg_error

579: fnd_message.set_name('PAY','HR_51782_PPB_INVL_ANU_HOURS');
580: fnd_message.raise_error;
581: end if;
582: else
583: hr_api.mandatory_arg_error
584: (p_api_name => l_proc,
585: p_argument => 'grade_annualization_factor',
586: p_argument_value => p_grade_annualization_factor);
587: --

Line 660: hr_api.mandatory_arg_error

656: --
657: hr_utility.set_location('Entering:'||l_proc, 5);
658: --
659:
660: hr_api.mandatory_arg_error
661: (p_api_name => l_proc,
662: p_argument => 'input_value_id',
663: p_argument_value => p_input_value_id);
664:

Line 726: hr_api.mandatory_arg_error

722: --
723: --
724: hr_utility.set_location('Entering:'||l_proc, 10);
725:
726: hr_api.mandatory_arg_error
727: (p_api_name => l_proc,
728: p_argument => 'pay_basis',
729: p_argument_value => p_pay_basis);
730:

Line 740: IF hr_api.not_exists_in_hr_lookups

736: hr_utility.set_location(l_proc, 20);
737: --
738: -- Check that the reason type exists in HR_LOOKUPS
739: --
740: IF hr_api.not_exists_in_hr_lookups
741: (p_effective_date => sysdate
742: ,p_lookup_type => 'PAY_BASIS'
743: ,p_lookup_code => p_pay_basis) THEN
744: --

Line 753: IF hr_api.not_exists_in_hr_lookups

749: --
750: END IF;
751: --
752: ELSIF p_rate_basis is not null then
753: IF hr_api.not_exists_in_hr_lookups
754: (p_effective_date => sysdate
755: ,p_lookup_type => 'PAY_BASIS'
756: ,p_lookup_code => p_rate_basis) then
757:

Line 1079: nvl(per_ppb_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

1075: begin
1076: hr_utility.set_location('Entering:'||l_proc,10);
1077: --
1078: if ((p_rec.pay_basis_id is not null) and (
1079: nvl(per_ppb_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1080: nvl(p_rec.information_category, hr_api.g_varchar2) or
1081: nvl(per_ppb_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1082: nvl(p_rec.information1, hr_api.g_varchar2) or
1083: nvl(per_ppb_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 1080: nvl(p_rec.information_category, hr_api.g_varchar2) or

1076: hr_utility.set_location('Entering:'||l_proc,10);
1077: --
1078: if ((p_rec.pay_basis_id is not null) and (
1079: nvl(per_ppb_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1080: nvl(p_rec.information_category, hr_api.g_varchar2) or
1081: nvl(per_ppb_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1082: nvl(p_rec.information1, hr_api.g_varchar2) or
1083: nvl(per_ppb_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1084: nvl(p_rec.information2, hr_api.g_varchar2) or

Line 1081: nvl(per_ppb_shd.g_old_rec.information1, hr_api.g_varchar2) <>

1077: --
1078: if ((p_rec.pay_basis_id is not null) and (
1079: nvl(per_ppb_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1080: nvl(p_rec.information_category, hr_api.g_varchar2) or
1081: nvl(per_ppb_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1082: nvl(p_rec.information1, hr_api.g_varchar2) or
1083: nvl(per_ppb_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1084: nvl(p_rec.information2, hr_api.g_varchar2) or
1085: nvl(per_ppb_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 1082: nvl(p_rec.information1, hr_api.g_varchar2) or

1078: if ((p_rec.pay_basis_id is not null) and (
1079: nvl(per_ppb_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1080: nvl(p_rec.information_category, hr_api.g_varchar2) or
1081: nvl(per_ppb_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1082: nvl(p_rec.information1, hr_api.g_varchar2) or
1083: nvl(per_ppb_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1084: nvl(p_rec.information2, hr_api.g_varchar2) or
1085: nvl(per_ppb_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1086: nvl(p_rec.information3, hr_api.g_varchar2) or

Line 1083: nvl(per_ppb_shd.g_old_rec.information2, hr_api.g_varchar2) <>

1079: nvl(per_ppb_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1080: nvl(p_rec.information_category, hr_api.g_varchar2) or
1081: nvl(per_ppb_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1082: nvl(p_rec.information1, hr_api.g_varchar2) or
1083: nvl(per_ppb_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1084: nvl(p_rec.information2, hr_api.g_varchar2) or
1085: nvl(per_ppb_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1086: nvl(p_rec.information3, hr_api.g_varchar2) or
1087: nvl(per_ppb_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 1084: nvl(p_rec.information2, hr_api.g_varchar2) or

1080: nvl(p_rec.information_category, hr_api.g_varchar2) or
1081: nvl(per_ppb_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1082: nvl(p_rec.information1, hr_api.g_varchar2) or
1083: nvl(per_ppb_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1084: nvl(p_rec.information2, hr_api.g_varchar2) or
1085: nvl(per_ppb_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1086: nvl(p_rec.information3, hr_api.g_varchar2) or
1087: nvl(per_ppb_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1088: nvl(p_rec.information4, hr_api.g_varchar2) or

Line 1085: nvl(per_ppb_shd.g_old_rec.information3, hr_api.g_varchar2) <>

1081: nvl(per_ppb_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1082: nvl(p_rec.information1, hr_api.g_varchar2) or
1083: nvl(per_ppb_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1084: nvl(p_rec.information2, hr_api.g_varchar2) or
1085: nvl(per_ppb_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1086: nvl(p_rec.information3, hr_api.g_varchar2) or
1087: nvl(per_ppb_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1088: nvl(p_rec.information4, hr_api.g_varchar2) or
1089: nvl(per_ppb_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 1086: nvl(p_rec.information3, hr_api.g_varchar2) or

1082: nvl(p_rec.information1, hr_api.g_varchar2) or
1083: nvl(per_ppb_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1084: nvl(p_rec.information2, hr_api.g_varchar2) or
1085: nvl(per_ppb_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1086: nvl(p_rec.information3, hr_api.g_varchar2) or
1087: nvl(per_ppb_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1088: nvl(p_rec.information4, hr_api.g_varchar2) or
1089: nvl(per_ppb_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1090: nvl(p_rec.information5, hr_api.g_varchar2) or

Line 1087: nvl(per_ppb_shd.g_old_rec.information4, hr_api.g_varchar2) <>

1083: nvl(per_ppb_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1084: nvl(p_rec.information2, hr_api.g_varchar2) or
1085: nvl(per_ppb_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1086: nvl(p_rec.information3, hr_api.g_varchar2) or
1087: nvl(per_ppb_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1088: nvl(p_rec.information4, hr_api.g_varchar2) or
1089: nvl(per_ppb_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1090: nvl(p_rec.information5, hr_api.g_varchar2) or
1091: nvl(per_ppb_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 1088: nvl(p_rec.information4, hr_api.g_varchar2) or

1084: nvl(p_rec.information2, hr_api.g_varchar2) or
1085: nvl(per_ppb_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1086: nvl(p_rec.information3, hr_api.g_varchar2) or
1087: nvl(per_ppb_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1088: nvl(p_rec.information4, hr_api.g_varchar2) or
1089: nvl(per_ppb_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1090: nvl(p_rec.information5, hr_api.g_varchar2) or
1091: nvl(per_ppb_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1092: nvl(p_rec.information6, hr_api.g_varchar2) or

Line 1089: nvl(per_ppb_shd.g_old_rec.information5, hr_api.g_varchar2) <>

1085: nvl(per_ppb_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1086: nvl(p_rec.information3, hr_api.g_varchar2) or
1087: nvl(per_ppb_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1088: nvl(p_rec.information4, hr_api.g_varchar2) or
1089: nvl(per_ppb_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1090: nvl(p_rec.information5, hr_api.g_varchar2) or
1091: nvl(per_ppb_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1092: nvl(p_rec.information6, hr_api.g_varchar2) or
1093: nvl(per_ppb_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 1090: nvl(p_rec.information5, hr_api.g_varchar2) or

1086: nvl(p_rec.information3, hr_api.g_varchar2) or
1087: nvl(per_ppb_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1088: nvl(p_rec.information4, hr_api.g_varchar2) or
1089: nvl(per_ppb_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1090: nvl(p_rec.information5, hr_api.g_varchar2) or
1091: nvl(per_ppb_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1092: nvl(p_rec.information6, hr_api.g_varchar2) or
1093: nvl(per_ppb_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1094: nvl(p_rec.information7, hr_api.g_varchar2) or

Line 1091: nvl(per_ppb_shd.g_old_rec.information6, hr_api.g_varchar2) <>

1087: nvl(per_ppb_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1088: nvl(p_rec.information4, hr_api.g_varchar2) or
1089: nvl(per_ppb_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1090: nvl(p_rec.information5, hr_api.g_varchar2) or
1091: nvl(per_ppb_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1092: nvl(p_rec.information6, hr_api.g_varchar2) or
1093: nvl(per_ppb_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1094: nvl(p_rec.information7, hr_api.g_varchar2) or
1095: nvl(per_ppb_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 1092: nvl(p_rec.information6, hr_api.g_varchar2) or

1088: nvl(p_rec.information4, hr_api.g_varchar2) or
1089: nvl(per_ppb_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1090: nvl(p_rec.information5, hr_api.g_varchar2) or
1091: nvl(per_ppb_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1092: nvl(p_rec.information6, hr_api.g_varchar2) or
1093: nvl(per_ppb_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1094: nvl(p_rec.information7, hr_api.g_varchar2) or
1095: nvl(per_ppb_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1096: nvl(p_rec.information8, hr_api.g_varchar2) or

Line 1093: nvl(per_ppb_shd.g_old_rec.information7, hr_api.g_varchar2) <>

1089: nvl(per_ppb_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1090: nvl(p_rec.information5, hr_api.g_varchar2) or
1091: nvl(per_ppb_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1092: nvl(p_rec.information6, hr_api.g_varchar2) or
1093: nvl(per_ppb_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1094: nvl(p_rec.information7, hr_api.g_varchar2) or
1095: nvl(per_ppb_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1096: nvl(p_rec.information8, hr_api.g_varchar2) or
1097: nvl(per_ppb_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 1094: nvl(p_rec.information7, hr_api.g_varchar2) or

1090: nvl(p_rec.information5, hr_api.g_varchar2) or
1091: nvl(per_ppb_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1092: nvl(p_rec.information6, hr_api.g_varchar2) or
1093: nvl(per_ppb_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1094: nvl(p_rec.information7, hr_api.g_varchar2) or
1095: nvl(per_ppb_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1096: nvl(p_rec.information8, hr_api.g_varchar2) or
1097: nvl(per_ppb_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1098: nvl(p_rec.information9, hr_api.g_varchar2) or

Line 1095: nvl(per_ppb_shd.g_old_rec.information8, hr_api.g_varchar2) <>

1091: nvl(per_ppb_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1092: nvl(p_rec.information6, hr_api.g_varchar2) or
1093: nvl(per_ppb_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1094: nvl(p_rec.information7, hr_api.g_varchar2) or
1095: nvl(per_ppb_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1096: nvl(p_rec.information8, hr_api.g_varchar2) or
1097: nvl(per_ppb_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1098: nvl(p_rec.information9, hr_api.g_varchar2) or
1099: nvl(per_ppb_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 1096: nvl(p_rec.information8, hr_api.g_varchar2) or

1092: nvl(p_rec.information6, hr_api.g_varchar2) or
1093: nvl(per_ppb_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1094: nvl(p_rec.information7, hr_api.g_varchar2) or
1095: nvl(per_ppb_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1096: nvl(p_rec.information8, hr_api.g_varchar2) or
1097: nvl(per_ppb_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1098: nvl(p_rec.information9, hr_api.g_varchar2) or
1099: nvl(per_ppb_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1100: nvl(p_rec.information10, hr_api.g_varchar2) or

Line 1097: nvl(per_ppb_shd.g_old_rec.information9, hr_api.g_varchar2) <>

1093: nvl(per_ppb_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1094: nvl(p_rec.information7, hr_api.g_varchar2) or
1095: nvl(per_ppb_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1096: nvl(p_rec.information8, hr_api.g_varchar2) or
1097: nvl(per_ppb_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1098: nvl(p_rec.information9, hr_api.g_varchar2) or
1099: nvl(per_ppb_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1100: nvl(p_rec.information10, hr_api.g_varchar2) or
1101: nvl(per_ppb_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 1098: nvl(p_rec.information9, hr_api.g_varchar2) or

1094: nvl(p_rec.information7, hr_api.g_varchar2) or
1095: nvl(per_ppb_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1096: nvl(p_rec.information8, hr_api.g_varchar2) or
1097: nvl(per_ppb_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1098: nvl(p_rec.information9, hr_api.g_varchar2) or
1099: nvl(per_ppb_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1100: nvl(p_rec.information10, hr_api.g_varchar2) or
1101: nvl(per_ppb_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1102: nvl(p_rec.information11, hr_api.g_varchar2) or

Line 1099: nvl(per_ppb_shd.g_old_rec.information10, hr_api.g_varchar2) <>

1095: nvl(per_ppb_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1096: nvl(p_rec.information8, hr_api.g_varchar2) or
1097: nvl(per_ppb_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1098: nvl(p_rec.information9, hr_api.g_varchar2) or
1099: nvl(per_ppb_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1100: nvl(p_rec.information10, hr_api.g_varchar2) or
1101: nvl(per_ppb_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1102: nvl(p_rec.information11, hr_api.g_varchar2) or
1103: nvl(per_ppb_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 1100: nvl(p_rec.information10, hr_api.g_varchar2) or

1096: nvl(p_rec.information8, hr_api.g_varchar2) or
1097: nvl(per_ppb_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1098: nvl(p_rec.information9, hr_api.g_varchar2) or
1099: nvl(per_ppb_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1100: nvl(p_rec.information10, hr_api.g_varchar2) or
1101: nvl(per_ppb_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1102: nvl(p_rec.information11, hr_api.g_varchar2) or
1103: nvl(per_ppb_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1104: nvl(p_rec.information12, hr_api.g_varchar2) or

Line 1101: nvl(per_ppb_shd.g_old_rec.information11, hr_api.g_varchar2) <>

1097: nvl(per_ppb_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1098: nvl(p_rec.information9, hr_api.g_varchar2) or
1099: nvl(per_ppb_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1100: nvl(p_rec.information10, hr_api.g_varchar2) or
1101: nvl(per_ppb_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1102: nvl(p_rec.information11, hr_api.g_varchar2) or
1103: nvl(per_ppb_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1104: nvl(p_rec.information12, hr_api.g_varchar2) or
1105: nvl(per_ppb_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 1102: nvl(p_rec.information11, hr_api.g_varchar2) or

1098: nvl(p_rec.information9, hr_api.g_varchar2) or
1099: nvl(per_ppb_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1100: nvl(p_rec.information10, hr_api.g_varchar2) or
1101: nvl(per_ppb_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1102: nvl(p_rec.information11, hr_api.g_varchar2) or
1103: nvl(per_ppb_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1104: nvl(p_rec.information12, hr_api.g_varchar2) or
1105: nvl(per_ppb_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1106: nvl(p_rec.information13, hr_api.g_varchar2) or

Line 1103: nvl(per_ppb_shd.g_old_rec.information12, hr_api.g_varchar2) <>

1099: nvl(per_ppb_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1100: nvl(p_rec.information10, hr_api.g_varchar2) or
1101: nvl(per_ppb_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1102: nvl(p_rec.information11, hr_api.g_varchar2) or
1103: nvl(per_ppb_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1104: nvl(p_rec.information12, hr_api.g_varchar2) or
1105: nvl(per_ppb_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1106: nvl(p_rec.information13, hr_api.g_varchar2) or
1107: nvl(per_ppb_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 1104: nvl(p_rec.information12, hr_api.g_varchar2) or

1100: nvl(p_rec.information10, hr_api.g_varchar2) or
1101: nvl(per_ppb_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1102: nvl(p_rec.information11, hr_api.g_varchar2) or
1103: nvl(per_ppb_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1104: nvl(p_rec.information12, hr_api.g_varchar2) or
1105: nvl(per_ppb_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1106: nvl(p_rec.information13, hr_api.g_varchar2) or
1107: nvl(per_ppb_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1108: nvl(p_rec.information14, hr_api.g_varchar2) or

Line 1105: nvl(per_ppb_shd.g_old_rec.information13, hr_api.g_varchar2) <>

1101: nvl(per_ppb_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1102: nvl(p_rec.information11, hr_api.g_varchar2) or
1103: nvl(per_ppb_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1104: nvl(p_rec.information12, hr_api.g_varchar2) or
1105: nvl(per_ppb_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1106: nvl(p_rec.information13, hr_api.g_varchar2) or
1107: nvl(per_ppb_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1108: nvl(p_rec.information14, hr_api.g_varchar2) or
1109: nvl(per_ppb_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 1106: nvl(p_rec.information13, hr_api.g_varchar2) or

1102: nvl(p_rec.information11, hr_api.g_varchar2) or
1103: nvl(per_ppb_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1104: nvl(p_rec.information12, hr_api.g_varchar2) or
1105: nvl(per_ppb_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1106: nvl(p_rec.information13, hr_api.g_varchar2) or
1107: nvl(per_ppb_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1108: nvl(p_rec.information14, hr_api.g_varchar2) or
1109: nvl(per_ppb_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1110: nvl(p_rec.information15, hr_api.g_varchar2) or

Line 1107: nvl(per_ppb_shd.g_old_rec.information14, hr_api.g_varchar2) <>

1103: nvl(per_ppb_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1104: nvl(p_rec.information12, hr_api.g_varchar2) or
1105: nvl(per_ppb_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1106: nvl(p_rec.information13, hr_api.g_varchar2) or
1107: nvl(per_ppb_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1108: nvl(p_rec.information14, hr_api.g_varchar2) or
1109: nvl(per_ppb_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1110: nvl(p_rec.information15, hr_api.g_varchar2) or
1111: nvl(per_ppb_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 1108: nvl(p_rec.information14, hr_api.g_varchar2) or

1104: nvl(p_rec.information12, hr_api.g_varchar2) or
1105: nvl(per_ppb_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1106: nvl(p_rec.information13, hr_api.g_varchar2) or
1107: nvl(per_ppb_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1108: nvl(p_rec.information14, hr_api.g_varchar2) or
1109: nvl(per_ppb_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1110: nvl(p_rec.information15, hr_api.g_varchar2) or
1111: nvl(per_ppb_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1112: nvl(p_rec.information16, hr_api.g_varchar2) or

Line 1109: nvl(per_ppb_shd.g_old_rec.information15, hr_api.g_varchar2) <>

1105: nvl(per_ppb_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1106: nvl(p_rec.information13, hr_api.g_varchar2) or
1107: nvl(per_ppb_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1108: nvl(p_rec.information14, hr_api.g_varchar2) or
1109: nvl(per_ppb_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1110: nvl(p_rec.information15, hr_api.g_varchar2) or
1111: nvl(per_ppb_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1112: nvl(p_rec.information16, hr_api.g_varchar2) or
1113: nvl(per_ppb_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 1110: nvl(p_rec.information15, hr_api.g_varchar2) or

1106: nvl(p_rec.information13, hr_api.g_varchar2) or
1107: nvl(per_ppb_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1108: nvl(p_rec.information14, hr_api.g_varchar2) or
1109: nvl(per_ppb_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1110: nvl(p_rec.information15, hr_api.g_varchar2) or
1111: nvl(per_ppb_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1112: nvl(p_rec.information16, hr_api.g_varchar2) or
1113: nvl(per_ppb_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1114: nvl(p_rec.information17, hr_api.g_varchar2) or

Line 1111: nvl(per_ppb_shd.g_old_rec.information16, hr_api.g_varchar2) <>

1107: nvl(per_ppb_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1108: nvl(p_rec.information14, hr_api.g_varchar2) or
1109: nvl(per_ppb_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1110: nvl(p_rec.information15, hr_api.g_varchar2) or
1111: nvl(per_ppb_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1112: nvl(p_rec.information16, hr_api.g_varchar2) or
1113: nvl(per_ppb_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1114: nvl(p_rec.information17, hr_api.g_varchar2) or
1115: nvl(per_ppb_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 1112: nvl(p_rec.information16, hr_api.g_varchar2) or

1108: nvl(p_rec.information14, hr_api.g_varchar2) or
1109: nvl(per_ppb_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1110: nvl(p_rec.information15, hr_api.g_varchar2) or
1111: nvl(per_ppb_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1112: nvl(p_rec.information16, hr_api.g_varchar2) or
1113: nvl(per_ppb_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1114: nvl(p_rec.information17, hr_api.g_varchar2) or
1115: nvl(per_ppb_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1116: nvl(p_rec.information18, hr_api.g_varchar2) or

Line 1113: nvl(per_ppb_shd.g_old_rec.information17, hr_api.g_varchar2) <>

1109: nvl(per_ppb_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1110: nvl(p_rec.information15, hr_api.g_varchar2) or
1111: nvl(per_ppb_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1112: nvl(p_rec.information16, hr_api.g_varchar2) or
1113: nvl(per_ppb_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1114: nvl(p_rec.information17, hr_api.g_varchar2) or
1115: nvl(per_ppb_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1116: nvl(p_rec.information18, hr_api.g_varchar2) or
1117: nvl(per_ppb_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 1114: nvl(p_rec.information17, hr_api.g_varchar2) or

1110: nvl(p_rec.information15, hr_api.g_varchar2) or
1111: nvl(per_ppb_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1112: nvl(p_rec.information16, hr_api.g_varchar2) or
1113: nvl(per_ppb_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1114: nvl(p_rec.information17, hr_api.g_varchar2) or
1115: nvl(per_ppb_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1116: nvl(p_rec.information18, hr_api.g_varchar2) or
1117: nvl(per_ppb_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1118: nvl(p_rec.information19, hr_api.g_varchar2) or

Line 1115: nvl(per_ppb_shd.g_old_rec.information18, hr_api.g_varchar2) <>

1111: nvl(per_ppb_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1112: nvl(p_rec.information16, hr_api.g_varchar2) or
1113: nvl(per_ppb_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1114: nvl(p_rec.information17, hr_api.g_varchar2) or
1115: nvl(per_ppb_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1116: nvl(p_rec.information18, hr_api.g_varchar2) or
1117: nvl(per_ppb_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1118: nvl(p_rec.information19, hr_api.g_varchar2) or
1119: nvl(per_ppb_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 1116: nvl(p_rec.information18, hr_api.g_varchar2) or

1112: nvl(p_rec.information16, hr_api.g_varchar2) or
1113: nvl(per_ppb_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1114: nvl(p_rec.information17, hr_api.g_varchar2) or
1115: nvl(per_ppb_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1116: nvl(p_rec.information18, hr_api.g_varchar2) or
1117: nvl(per_ppb_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1118: nvl(p_rec.information19, hr_api.g_varchar2) or
1119: nvl(per_ppb_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1120: nvl(p_rec.information20, hr_api.g_varchar2) ))

Line 1117: nvl(per_ppb_shd.g_old_rec.information19, hr_api.g_varchar2) <>

1113: nvl(per_ppb_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1114: nvl(p_rec.information17, hr_api.g_varchar2) or
1115: nvl(per_ppb_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1116: nvl(p_rec.information18, hr_api.g_varchar2) or
1117: nvl(per_ppb_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1118: nvl(p_rec.information19, hr_api.g_varchar2) or
1119: nvl(per_ppb_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1120: nvl(p_rec.information20, hr_api.g_varchar2) ))
1121: or (p_rec.pay_basis_id is null) then

Line 1118: nvl(p_rec.information19, hr_api.g_varchar2) or

1114: nvl(p_rec.information17, hr_api.g_varchar2) or
1115: nvl(per_ppb_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1116: nvl(p_rec.information18, hr_api.g_varchar2) or
1117: nvl(per_ppb_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1118: nvl(p_rec.information19, hr_api.g_varchar2) or
1119: nvl(per_ppb_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1120: nvl(p_rec.information20, hr_api.g_varchar2) ))
1121: or (p_rec.pay_basis_id is null) then
1122: --

Line 1119: nvl(per_ppb_shd.g_old_rec.information20, hr_api.g_varchar2) <>

1115: nvl(per_ppb_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1116: nvl(p_rec.information18, hr_api.g_varchar2) or
1117: nvl(per_ppb_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1118: nvl(p_rec.information19, hr_api.g_varchar2) or
1119: nvl(per_ppb_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1120: nvl(p_rec.information20, hr_api.g_varchar2) ))
1121: or (p_rec.pay_basis_id is null) then
1122: --
1123: -- Only execute the validation if absolutely necessary:

Line 1120: nvl(p_rec.information20, hr_api.g_varchar2) ))

1116: nvl(p_rec.information18, hr_api.g_varchar2) or
1117: nvl(per_ppb_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1118: nvl(p_rec.information19, hr_api.g_varchar2) or
1119: nvl(per_ppb_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1120: nvl(p_rec.information20, hr_api.g_varchar2) ))
1121: or (p_rec.pay_basis_id is null) then
1122: --
1123: -- Only execute the validation if absolutely necessary:
1124: -- a) During update, the structure column value or any

Line 1216: nvl(per_ppb_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

1212: begin
1213: hr_utility.set_location('Entering:'||l_proc,10);
1214: --
1215: if ((p_rec.pay_basis_id is not null) and (
1216: nvl(per_ppb_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1218: nvl(per_ppb_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1220: nvl(per_ppb_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

1213: hr_utility.set_location('Entering:'||l_proc,10);
1214: --
1215: if ((p_rec.pay_basis_id is not null) and (
1216: nvl(per_ppb_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1218: nvl(per_ppb_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1220: nvl(per_ppb_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 1218: nvl(per_ppb_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

1214: --
1215: if ((p_rec.pay_basis_id is not null) and (
1216: nvl(per_ppb_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1218: nvl(per_ppb_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1220: nvl(per_ppb_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1222: nvl(per_ppb_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

1215: if ((p_rec.pay_basis_id is not null) and (
1216: nvl(per_ppb_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1218: nvl(per_ppb_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1220: nvl(per_ppb_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1222: nvl(per_ppb_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 1220: nvl(per_ppb_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

1216: nvl(per_ppb_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1218: nvl(per_ppb_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1220: nvl(per_ppb_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1222: nvl(per_ppb_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1224: nvl(per_ppb_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

1217: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1218: nvl(per_ppb_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1220: nvl(per_ppb_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1222: nvl(per_ppb_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1224: nvl(per_ppb_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 1222: nvl(per_ppb_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

1218: nvl(per_ppb_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1219: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1220: nvl(per_ppb_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1222: nvl(per_ppb_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1224: nvl(per_ppb_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1226: nvl(per_ppb_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

1219: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1220: nvl(per_ppb_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1222: nvl(per_ppb_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1224: nvl(per_ppb_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1226: nvl(per_ppb_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 1224: nvl(per_ppb_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

1220: nvl(per_ppb_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1221: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1222: nvl(per_ppb_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1224: nvl(per_ppb_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1226: nvl(per_ppb_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1228: nvl(per_ppb_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

1221: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1222: nvl(per_ppb_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1224: nvl(per_ppb_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1226: nvl(per_ppb_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1228: nvl(per_ppb_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 1226: nvl(per_ppb_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

1222: nvl(per_ppb_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1223: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1224: nvl(per_ppb_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1226: nvl(per_ppb_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1228: nvl(per_ppb_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1230: nvl(per_ppb_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

1223: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1224: nvl(per_ppb_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1226: nvl(per_ppb_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1228: nvl(per_ppb_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1230: nvl(per_ppb_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 1228: nvl(per_ppb_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

1224: nvl(per_ppb_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1225: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1226: nvl(per_ppb_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1228: nvl(per_ppb_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1230: nvl(per_ppb_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1232: nvl(per_ppb_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

1225: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1226: nvl(per_ppb_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1228: nvl(per_ppb_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1230: nvl(per_ppb_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1232: nvl(per_ppb_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 1230: nvl(per_ppb_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

1226: nvl(per_ppb_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1227: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1228: nvl(per_ppb_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1230: nvl(per_ppb_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1232: nvl(per_ppb_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1234: nvl(per_ppb_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

1227: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1228: nvl(per_ppb_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1230: nvl(per_ppb_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1232: nvl(per_ppb_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1234: nvl(per_ppb_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 1232: nvl(per_ppb_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

1228: nvl(per_ppb_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1229: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1230: nvl(per_ppb_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1232: nvl(per_ppb_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1234: nvl(per_ppb_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1236: nvl(per_ppb_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

1229: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1230: nvl(per_ppb_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1232: nvl(per_ppb_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1234: nvl(per_ppb_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1236: nvl(per_ppb_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 1234: nvl(per_ppb_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

1230: nvl(per_ppb_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1231: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1232: nvl(per_ppb_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1234: nvl(per_ppb_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1236: nvl(per_ppb_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1238: nvl(per_ppb_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

1231: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1232: nvl(per_ppb_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1234: nvl(per_ppb_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1236: nvl(per_ppb_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1238: nvl(per_ppb_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 1236: nvl(per_ppb_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

1232: nvl(per_ppb_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1233: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1234: nvl(per_ppb_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1236: nvl(per_ppb_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1238: nvl(per_ppb_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1240: nvl(per_ppb_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

1233: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1234: nvl(per_ppb_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1236: nvl(per_ppb_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1238: nvl(per_ppb_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1240: nvl(per_ppb_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1241: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 1238: nvl(per_ppb_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

1234: nvl(per_ppb_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1235: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1236: nvl(per_ppb_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1238: nvl(per_ppb_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1240: nvl(per_ppb_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1241: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1242: nvl(per_ppb_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

1235: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1236: nvl(per_ppb_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1238: nvl(per_ppb_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1240: nvl(per_ppb_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1241: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1242: nvl(per_ppb_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1243: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 1240: nvl(per_ppb_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

1236: nvl(per_ppb_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1237: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1238: nvl(per_ppb_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1240: nvl(per_ppb_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1241: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1242: nvl(per_ppb_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1243: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1244: nvl(per_ppb_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

1237: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1238: nvl(per_ppb_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1240: nvl(per_ppb_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1241: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1242: nvl(per_ppb_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1243: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1244: nvl(per_ppb_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1245: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 1242: nvl(per_ppb_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

1238: nvl(per_ppb_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1239: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1240: nvl(per_ppb_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1241: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1242: nvl(per_ppb_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1243: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1244: nvl(per_ppb_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1245: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1246: nvl(per_ppb_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

1239: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1240: nvl(per_ppb_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1241: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1242: nvl(per_ppb_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1243: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1244: nvl(per_ppb_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1245: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1246: nvl(per_ppb_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1247: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 1244: nvl(per_ppb_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

1240: nvl(per_ppb_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1241: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1242: nvl(per_ppb_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1243: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1244: nvl(per_ppb_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1245: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1246: nvl(per_ppb_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1247: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1248: nvl(per_ppb_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

1241: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1242: nvl(per_ppb_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1243: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1244: nvl(per_ppb_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1245: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1246: nvl(per_ppb_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1247: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1248: nvl(per_ppb_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1249: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 1246: nvl(per_ppb_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

1242: nvl(per_ppb_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1243: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1244: nvl(per_ppb_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1245: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1246: nvl(per_ppb_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1247: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1248: nvl(per_ppb_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1249: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1250: nvl(per_ppb_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

1243: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1244: nvl(per_ppb_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1245: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1246: nvl(per_ppb_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1247: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1248: nvl(per_ppb_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1249: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1250: nvl(per_ppb_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1251: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 1248: nvl(per_ppb_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

1244: nvl(per_ppb_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1245: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1246: nvl(per_ppb_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1247: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1248: nvl(per_ppb_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1249: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1250: nvl(per_ppb_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1251: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1252: nvl(per_ppb_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

1245: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1246: nvl(per_ppb_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1247: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1248: nvl(per_ppb_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1249: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1250: nvl(per_ppb_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1251: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1252: nvl(per_ppb_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1253: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 1250: nvl(per_ppb_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

1246: nvl(per_ppb_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1247: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1248: nvl(per_ppb_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1249: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1250: nvl(per_ppb_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1251: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1252: nvl(per_ppb_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1253: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1254: nvl(per_ppb_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

1247: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1248: nvl(per_ppb_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1249: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1250: nvl(per_ppb_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1251: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1252: nvl(per_ppb_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1253: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1254: nvl(per_ppb_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1255: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 1252: nvl(per_ppb_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

1248: nvl(per_ppb_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1249: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1250: nvl(per_ppb_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1251: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1252: nvl(per_ppb_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1253: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1254: nvl(per_ppb_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1255: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1256: nvl(per_ppb_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

1249: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1250: nvl(per_ppb_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1251: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1252: nvl(per_ppb_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1253: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1254: nvl(per_ppb_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1255: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1256: nvl(per_ppb_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1257: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

Line 1254: nvl(per_ppb_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

1250: nvl(per_ppb_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1251: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1252: nvl(per_ppb_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1253: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1254: nvl(per_ppb_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1255: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1256: nvl(per_ppb_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1257: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
1258: or (p_rec.pay_basis_id is null) then

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

1251: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1252: nvl(per_ppb_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1253: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1254: nvl(per_ppb_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1255: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1256: nvl(per_ppb_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1257: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
1258: or (p_rec.pay_basis_id is null) then
1259: --

Line 1256: nvl(per_ppb_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

1252: nvl(per_ppb_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1253: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1254: nvl(per_ppb_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1255: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1256: nvl(per_ppb_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1257: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
1258: or (p_rec.pay_basis_id is null) then
1259: --
1260: -- Only execute the validation if absolutely necessary:

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

1253: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1254: nvl(per_ppb_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1255: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1256: nvl(per_ppb_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1257: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
1258: or (p_rec.pay_basis_id is null) then
1259: --
1260: -- Only execute the validation if absolutely necessary:
1261: -- a) During update, the structure column value or any

Line 1391: hr_api.validate_bus_grp_id

1387: hr_utility.set_location('Entering:'||l_proc, 5);
1388: --
1389: -- Call all supporting business operations
1390: --
1391: hr_api.validate_bus_grp_id
1392: (p_business_group_id => p_rec.business_group_id
1393: ,p_associated_column1 => per_ppb_shd.g_tab_nam
1394: || '.BUSINESS_GROUP_ID');
1395: --

Line 1472: hr_api.validate_bus_grp_id

1468: hr_utility.set_location('Entering:'||l_proc, 5);
1469: --
1470: -- Call all supporting business operations
1471: --
1472: hr_api.validate_bus_grp_id
1473: (p_business_group_id => p_rec.business_group_id
1474: ,p_associated_column1 => per_ppb_shd.g_tab_nam
1475: || '.BUSINESS_GROUP_ID');
1476: --