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.PER_PPB_BUS dependencies on PER_PPB_SHD

Line 193: l_api_updating := per_ppb_shd.api_updating

189: Begin
190: --
191: hr_utility.set_location('Entering:'||l_proc, 5);
192: --
193: l_api_updating := per_ppb_shd.api_updating
194: (p_pay_basis_id => p_pay_basis_id,
195: p_object_version_number => p_object_version_number
196: );
197: --

Line 200: <> per_ppb_shd.g_old_rec.pay_basis_id) then

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: --
204: per_ppb_shd.constraint_error('PER_PAY_BASES_PK');

Line 204: per_ppb_shd.constraint_error('PER_PAY_BASES_PK');

200: <> per_ppb_shd.g_old_rec.pay_basis_id) then
201: --
202: -- raise error as PK has changed
203: --
204: per_ppb_shd.constraint_error('PER_PAY_BASES_PK');
205: --
206: elsif not l_api_updating then
207: --
208: -- check if PK is null

Line 214: per_ppb_shd.constraint_error('PER_PAY_BASES_PK');

210: if p_pay_basis_id is not null then
211: --
212: -- raise error as PK is not null
213: --
214: per_ppb_shd.constraint_error('PER_PAY_BASES_PK');
215: --
216: end if;
217: --
218: end if;

Line 279: per_ppb_shd.constraint_error(p_constraint_name => 'PER_PAY_BASES_FK2');

275: fetch csr_salary_basis into l_exists;
276: if p_rate_id is not null then
277: if csr_salary_basis%notfound then
278: close csr_salary_basis;
279: per_ppb_shd.constraint_error(p_constraint_name => 'PER_PAY_BASES_FK2');
280: end if;
281:
282: close csr_salary_basis;
283: end if;

Line 886: p_rec in per_ppb_shd.g_rec_type

882: --
883: -- {End Of Comments}
884: -- ----------------------------------------------------------------------------
885: Procedure chk_sal_basis_asg_exists(
886: p_rec in per_ppb_shd.g_rec_type
887: ) is
888:
889: --
890: l_proc varchar2(72) := g_package||'chk_sal_basis_asg_exists';

Line 906: l_api_updating := per_ppb_shd.api_updating

902: begin
903: --
904: hr_utility.set_location('Entering:'||l_proc, 10);
905:
906: l_api_updating := per_ppb_shd.api_updating
907: (p_rec.pay_basis_id
908: ,p_rec.object_version_number
909: );
910:

Line 924: = per_ppb_shd.g_old_rec.name) then

920: IF csr_sal_pay_in_asg%FOUND THEN
921: -- it belongs to an assignment
922: -- only name can be changed
923: if (p_rec.name
924: = per_ppb_shd.g_old_rec.name) then
925: hr_utility.set_location('Entering:'||l_proc, 20);
926: fnd_message.set_name('PER','HR_51268_PYP_CANT_UPD_RECORD');
927: fnd_message.raise_error;
928: else

Line 931: <> per_ppb_shd.g_old_rec.input_value_id)

927: fnd_message.raise_error;
928: else
929: hr_utility.set_location('Entering:'||l_proc, 25);
930: IF (p_rec.input_value_id
931: <> per_ppb_shd.g_old_rec.input_value_id)
932: or (p_rec.rate_id
933: <> per_ppb_shd.g_old_rec.rate_id)
934: or (p_rec.pay_basis
935: <> per_ppb_shd.g_old_rec.pay_basis)

Line 933: <> per_ppb_shd.g_old_rec.rate_id)

929: hr_utility.set_location('Entering:'||l_proc, 25);
930: IF (p_rec.input_value_id
931: <> per_ppb_shd.g_old_rec.input_value_id)
932: or (p_rec.rate_id
933: <> per_ppb_shd.g_old_rec.rate_id)
934: or (p_rec.pay_basis
935: <> per_ppb_shd.g_old_rec.pay_basis)
936: or (p_rec.rate_basis
937: <> per_ppb_shd.g_old_rec.rate_basis)

Line 935: <> per_ppb_shd.g_old_rec.pay_basis)

931: <> per_ppb_shd.g_old_rec.input_value_id)
932: or (p_rec.rate_id
933: <> per_ppb_shd.g_old_rec.rate_id)
934: or (p_rec.pay_basis
935: <> per_ppb_shd.g_old_rec.pay_basis)
936: or (p_rec.rate_basis
937: <> per_ppb_shd.g_old_rec.rate_basis)
938: or (p_rec.pay_annualization_factor
939: <> per_ppb_shd.g_old_rec.pay_annualization_factor)

Line 937: <> per_ppb_shd.g_old_rec.rate_basis)

933: <> per_ppb_shd.g_old_rec.rate_id)
934: or (p_rec.pay_basis
935: <> per_ppb_shd.g_old_rec.pay_basis)
936: or (p_rec.rate_basis
937: <> per_ppb_shd.g_old_rec.rate_basis)
938: or (p_rec.pay_annualization_factor
939: <> per_ppb_shd.g_old_rec.pay_annualization_factor)
940: or (p_rec.grade_annualization_factor
941: <> per_ppb_shd.g_old_rec.grade_annualization_factor)

Line 939: <> per_ppb_shd.g_old_rec.pay_annualization_factor)

935: <> per_ppb_shd.g_old_rec.pay_basis)
936: or (p_rec.rate_basis
937: <> per_ppb_shd.g_old_rec.rate_basis)
938: or (p_rec.pay_annualization_factor
939: <> per_ppb_shd.g_old_rec.pay_annualization_factor)
940: or (p_rec.grade_annualization_factor
941: <> per_ppb_shd.g_old_rec.grade_annualization_factor)
942: or (p_rec.attribute_category
943: <> per_ppb_shd.g_old_rec.attribute_category)

Line 941: <> per_ppb_shd.g_old_rec.grade_annualization_factor)

937: <> per_ppb_shd.g_old_rec.rate_basis)
938: or (p_rec.pay_annualization_factor
939: <> per_ppb_shd.g_old_rec.pay_annualization_factor)
940: or (p_rec.grade_annualization_factor
941: <> per_ppb_shd.g_old_rec.grade_annualization_factor)
942: or (p_rec.attribute_category
943: <> per_ppb_shd.g_old_rec.attribute_category)
944: or (p_rec.attribute1
945: <> per_ppb_shd.g_old_rec.attribute1)

Line 943: <> per_ppb_shd.g_old_rec.attribute_category)

939: <> per_ppb_shd.g_old_rec.pay_annualization_factor)
940: or (p_rec.grade_annualization_factor
941: <> per_ppb_shd.g_old_rec.grade_annualization_factor)
942: or (p_rec.attribute_category
943: <> per_ppb_shd.g_old_rec.attribute_category)
944: or (p_rec.attribute1
945: <> per_ppb_shd.g_old_rec.attribute1)
946: or (p_rec.attribute2
947: <> per_ppb_shd.g_old_rec.attribute2)

Line 945: <> per_ppb_shd.g_old_rec.attribute1)

941: <> per_ppb_shd.g_old_rec.grade_annualization_factor)
942: or (p_rec.attribute_category
943: <> per_ppb_shd.g_old_rec.attribute_category)
944: or (p_rec.attribute1
945: <> per_ppb_shd.g_old_rec.attribute1)
946: or (p_rec.attribute2
947: <> per_ppb_shd.g_old_rec.attribute2)
948: or (p_rec.attribute3
949: <> per_ppb_shd.g_old_rec.attribute3)

Line 947: <> per_ppb_shd.g_old_rec.attribute2)

943: <> per_ppb_shd.g_old_rec.attribute_category)
944: or (p_rec.attribute1
945: <> per_ppb_shd.g_old_rec.attribute1)
946: or (p_rec.attribute2
947: <> per_ppb_shd.g_old_rec.attribute2)
948: or (p_rec.attribute3
949: <> per_ppb_shd.g_old_rec.attribute3)
950: or (p_rec.attribute4
951: = per_ppb_shd.g_old_rec.attribute4)

Line 949: <> per_ppb_shd.g_old_rec.attribute3)

945: <> per_ppb_shd.g_old_rec.attribute1)
946: or (p_rec.attribute2
947: <> per_ppb_shd.g_old_rec.attribute2)
948: or (p_rec.attribute3
949: <> per_ppb_shd.g_old_rec.attribute3)
950: or (p_rec.attribute4
951: = per_ppb_shd.g_old_rec.attribute4)
952: or (p_rec.attribute5
953: <> per_ppb_shd.g_old_rec.attribute5)

Line 951: = per_ppb_shd.g_old_rec.attribute4)

947: <> per_ppb_shd.g_old_rec.attribute2)
948: or (p_rec.attribute3
949: <> per_ppb_shd.g_old_rec.attribute3)
950: or (p_rec.attribute4
951: = per_ppb_shd.g_old_rec.attribute4)
952: or (p_rec.attribute5
953: <> per_ppb_shd.g_old_rec.attribute5)
954: or (p_rec.attribute6
955: <> per_ppb_shd.g_old_rec.attribute6)

Line 953: <> per_ppb_shd.g_old_rec.attribute5)

949: <> per_ppb_shd.g_old_rec.attribute3)
950: or (p_rec.attribute4
951: = per_ppb_shd.g_old_rec.attribute4)
952: or (p_rec.attribute5
953: <> per_ppb_shd.g_old_rec.attribute5)
954: or (p_rec.attribute6
955: <> per_ppb_shd.g_old_rec.attribute6)
956: or (p_rec.attribute7
957: <> per_ppb_shd.g_old_rec.attribute7)

Line 955: <> per_ppb_shd.g_old_rec.attribute6)

951: = per_ppb_shd.g_old_rec.attribute4)
952: or (p_rec.attribute5
953: <> per_ppb_shd.g_old_rec.attribute5)
954: or (p_rec.attribute6
955: <> per_ppb_shd.g_old_rec.attribute6)
956: or (p_rec.attribute7
957: <> per_ppb_shd.g_old_rec.attribute7)
958: or (p_rec.attribute8
959: <> per_ppb_shd.g_old_rec.attribute8)

Line 957: <> per_ppb_shd.g_old_rec.attribute7)

953: <> per_ppb_shd.g_old_rec.attribute5)
954: or (p_rec.attribute6
955: <> per_ppb_shd.g_old_rec.attribute6)
956: or (p_rec.attribute7
957: <> per_ppb_shd.g_old_rec.attribute7)
958: or (p_rec.attribute8
959: <> per_ppb_shd.g_old_rec.attribute8)
960: or (p_rec.attribute9
961: <> per_ppb_shd.g_old_rec.attribute9)

Line 959: <> per_ppb_shd.g_old_rec.attribute8)

955: <> per_ppb_shd.g_old_rec.attribute6)
956: or (p_rec.attribute7
957: <> per_ppb_shd.g_old_rec.attribute7)
958: or (p_rec.attribute8
959: <> per_ppb_shd.g_old_rec.attribute8)
960: or (p_rec.attribute9
961: <> per_ppb_shd.g_old_rec.attribute9)
962: or (p_rec.attribute10
963: <> per_ppb_shd.g_old_rec.attribute10)

Line 961: <> per_ppb_shd.g_old_rec.attribute9)

957: <> per_ppb_shd.g_old_rec.attribute7)
958: or (p_rec.attribute8
959: <> per_ppb_shd.g_old_rec.attribute8)
960: or (p_rec.attribute9
961: <> per_ppb_shd.g_old_rec.attribute9)
962: or (p_rec.attribute10
963: <> per_ppb_shd.g_old_rec.attribute10)
964: or (p_rec.attribute11
965: <> per_ppb_shd.g_old_rec.attribute11)

Line 963: <> per_ppb_shd.g_old_rec.attribute10)

959: <> per_ppb_shd.g_old_rec.attribute8)
960: or (p_rec.attribute9
961: <> per_ppb_shd.g_old_rec.attribute9)
962: or (p_rec.attribute10
963: <> per_ppb_shd.g_old_rec.attribute10)
964: or (p_rec.attribute11
965: <> per_ppb_shd.g_old_rec.attribute11)
966: or (p_rec.attribute12
967: <> per_ppb_shd.g_old_rec.attribute12)

Line 965: <> per_ppb_shd.g_old_rec.attribute11)

961: <> per_ppb_shd.g_old_rec.attribute9)
962: or (p_rec.attribute10
963: <> per_ppb_shd.g_old_rec.attribute10)
964: or (p_rec.attribute11
965: <> per_ppb_shd.g_old_rec.attribute11)
966: or (p_rec.attribute12
967: <> per_ppb_shd.g_old_rec.attribute12)
968: or (p_rec.attribute13
969: <> per_ppb_shd.g_old_rec.attribute13)

Line 967: <> per_ppb_shd.g_old_rec.attribute12)

963: <> per_ppb_shd.g_old_rec.attribute10)
964: or (p_rec.attribute11
965: <> per_ppb_shd.g_old_rec.attribute11)
966: or (p_rec.attribute12
967: <> per_ppb_shd.g_old_rec.attribute12)
968: or (p_rec.attribute13
969: <> per_ppb_shd.g_old_rec.attribute13)
970: or (p_rec.attribute14
971: <> per_ppb_shd.g_old_rec.attribute14)

Line 969: <> per_ppb_shd.g_old_rec.attribute13)

965: <> per_ppb_shd.g_old_rec.attribute11)
966: or (p_rec.attribute12
967: <> per_ppb_shd.g_old_rec.attribute12)
968: or (p_rec.attribute13
969: <> per_ppb_shd.g_old_rec.attribute13)
970: or (p_rec.attribute14
971: <> per_ppb_shd.g_old_rec.attribute14)
972: or (p_rec.attribute15
973: <> per_ppb_shd.g_old_rec.attribute15)

Line 971: <> per_ppb_shd.g_old_rec.attribute14)

967: <> per_ppb_shd.g_old_rec.attribute12)
968: or (p_rec.attribute13
969: <> per_ppb_shd.g_old_rec.attribute13)
970: or (p_rec.attribute14
971: <> per_ppb_shd.g_old_rec.attribute14)
972: or (p_rec.attribute15
973: <> per_ppb_shd.g_old_rec.attribute15)
974: or (p_rec.attribute16
975: <> per_ppb_shd.g_old_rec.attribute16)

Line 973: <> per_ppb_shd.g_old_rec.attribute15)

969: <> per_ppb_shd.g_old_rec.attribute13)
970: or (p_rec.attribute14
971: <> per_ppb_shd.g_old_rec.attribute14)
972: or (p_rec.attribute15
973: <> per_ppb_shd.g_old_rec.attribute15)
974: or (p_rec.attribute16
975: <> per_ppb_shd.g_old_rec.attribute16)
976: or (p_rec.attribute17
977: <> per_ppb_shd.g_old_rec.attribute17)

Line 975: <> per_ppb_shd.g_old_rec.attribute16)

971: <> per_ppb_shd.g_old_rec.attribute14)
972: or (p_rec.attribute15
973: <> per_ppb_shd.g_old_rec.attribute15)
974: or (p_rec.attribute16
975: <> per_ppb_shd.g_old_rec.attribute16)
976: or (p_rec.attribute17
977: <> per_ppb_shd.g_old_rec.attribute17)
978: or (p_rec.attribute18
979: <> per_ppb_shd.g_old_rec.attribute18)

Line 977: <> per_ppb_shd.g_old_rec.attribute17)

973: <> per_ppb_shd.g_old_rec.attribute15)
974: or (p_rec.attribute16
975: <> per_ppb_shd.g_old_rec.attribute16)
976: or (p_rec.attribute17
977: <> per_ppb_shd.g_old_rec.attribute17)
978: or (p_rec.attribute18
979: <> per_ppb_shd.g_old_rec.attribute18)
980: or (p_rec.attribute19
981: <> per_ppb_shd.g_old_rec.attribute19)

Line 979: <> per_ppb_shd.g_old_rec.attribute18)

975: <> per_ppb_shd.g_old_rec.attribute16)
976: or (p_rec.attribute17
977: <> per_ppb_shd.g_old_rec.attribute17)
978: or (p_rec.attribute18
979: <> per_ppb_shd.g_old_rec.attribute18)
980: or (p_rec.attribute19
981: <> per_ppb_shd.g_old_rec.attribute19)
982: or (p_rec.attribute20
983: <> per_ppb_shd.g_old_rec.attribute20)

Line 981: <> per_ppb_shd.g_old_rec.attribute19)

977: <> per_ppb_shd.g_old_rec.attribute17)
978: or (p_rec.attribute18
979: <> per_ppb_shd.g_old_rec.attribute18)
980: or (p_rec.attribute19
981: <> per_ppb_shd.g_old_rec.attribute19)
982: or (p_rec.attribute20
983: <> per_ppb_shd.g_old_rec.attribute20)
984: or (p_rec.information_category
985: <> per_ppb_shd.g_old_rec.information_category)

Line 983: <> per_ppb_shd.g_old_rec.attribute20)

979: <> per_ppb_shd.g_old_rec.attribute18)
980: or (p_rec.attribute19
981: <> per_ppb_shd.g_old_rec.attribute19)
982: or (p_rec.attribute20
983: <> per_ppb_shd.g_old_rec.attribute20)
984: or (p_rec.information_category
985: <> per_ppb_shd.g_old_rec.information_category)
986: or (p_rec.information1
987: <> per_ppb_shd.g_old_rec.information1)

Line 985: <> per_ppb_shd.g_old_rec.information_category)

981: <> per_ppb_shd.g_old_rec.attribute19)
982: or (p_rec.attribute20
983: <> per_ppb_shd.g_old_rec.attribute20)
984: or (p_rec.information_category
985: <> per_ppb_shd.g_old_rec.information_category)
986: or (p_rec.information1
987: <> per_ppb_shd.g_old_rec.information1)
988: or (p_rec.information2
989: <> per_ppb_shd.g_old_rec.information2)

Line 987: <> per_ppb_shd.g_old_rec.information1)

983: <> per_ppb_shd.g_old_rec.attribute20)
984: or (p_rec.information_category
985: <> per_ppb_shd.g_old_rec.information_category)
986: or (p_rec.information1
987: <> per_ppb_shd.g_old_rec.information1)
988: or (p_rec.information2
989: <> per_ppb_shd.g_old_rec.information2)
990: or (p_rec.information3
991: <> per_ppb_shd.g_old_rec.information3)

Line 989: <> per_ppb_shd.g_old_rec.information2)

985: <> per_ppb_shd.g_old_rec.information_category)
986: or (p_rec.information1
987: <> per_ppb_shd.g_old_rec.information1)
988: or (p_rec.information2
989: <> per_ppb_shd.g_old_rec.information2)
990: or (p_rec.information3
991: <> per_ppb_shd.g_old_rec.information3)
992: or (p_rec.information4
993: <> per_ppb_shd.g_old_rec.information4)

Line 991: <> per_ppb_shd.g_old_rec.information3)

987: <> per_ppb_shd.g_old_rec.information1)
988: or (p_rec.information2
989: <> per_ppb_shd.g_old_rec.information2)
990: or (p_rec.information3
991: <> per_ppb_shd.g_old_rec.information3)
992: or (p_rec.information4
993: <> per_ppb_shd.g_old_rec.information4)
994: or (p_rec.information5
995: = per_ppb_shd.g_old_rec.information5)

Line 993: <> per_ppb_shd.g_old_rec.information4)

989: <> per_ppb_shd.g_old_rec.information2)
990: or (p_rec.information3
991: <> per_ppb_shd.g_old_rec.information3)
992: or (p_rec.information4
993: <> per_ppb_shd.g_old_rec.information4)
994: or (p_rec.information5
995: = per_ppb_shd.g_old_rec.information5)
996: or (p_rec.information6
997: <> per_ppb_shd.g_old_rec.information6)

Line 995: = per_ppb_shd.g_old_rec.information5)

991: <> per_ppb_shd.g_old_rec.information3)
992: or (p_rec.information4
993: <> per_ppb_shd.g_old_rec.information4)
994: or (p_rec.information5
995: = per_ppb_shd.g_old_rec.information5)
996: or (p_rec.information6
997: <> per_ppb_shd.g_old_rec.information6)
998: or (p_rec.information7
999: = per_ppb_shd.g_old_rec.information7)

Line 997: <> per_ppb_shd.g_old_rec.information6)

993: <> per_ppb_shd.g_old_rec.information4)
994: or (p_rec.information5
995: = per_ppb_shd.g_old_rec.information5)
996: or (p_rec.information6
997: <> per_ppb_shd.g_old_rec.information6)
998: or (p_rec.information7
999: = per_ppb_shd.g_old_rec.information7)
1000: or (p_rec.information8
1001: <> per_ppb_shd.g_old_rec.information8)

Line 999: = per_ppb_shd.g_old_rec.information7)

995: = per_ppb_shd.g_old_rec.information5)
996: or (p_rec.information6
997: <> per_ppb_shd.g_old_rec.information6)
998: or (p_rec.information7
999: = per_ppb_shd.g_old_rec.information7)
1000: or (p_rec.information8
1001: <> per_ppb_shd.g_old_rec.information8)
1002: or (p_rec.information9
1003: <> per_ppb_shd.g_old_rec.information9)

Line 1001: <> per_ppb_shd.g_old_rec.information8)

997: <> per_ppb_shd.g_old_rec.information6)
998: or (p_rec.information7
999: = per_ppb_shd.g_old_rec.information7)
1000: or (p_rec.information8
1001: <> per_ppb_shd.g_old_rec.information8)
1002: or (p_rec.information9
1003: <> per_ppb_shd.g_old_rec.information9)
1004: or (p_rec.information10
1005: <> per_ppb_shd.g_old_rec.information10)

Line 1003: <> per_ppb_shd.g_old_rec.information9)

999: = per_ppb_shd.g_old_rec.information7)
1000: or (p_rec.information8
1001: <> per_ppb_shd.g_old_rec.information8)
1002: or (p_rec.information9
1003: <> per_ppb_shd.g_old_rec.information9)
1004: or (p_rec.information10
1005: <> per_ppb_shd.g_old_rec.information10)
1006: or (p_rec.information11
1007: <> per_ppb_shd.g_old_rec.information11)

Line 1005: <> per_ppb_shd.g_old_rec.information10)

1001: <> per_ppb_shd.g_old_rec.information8)
1002: or (p_rec.information9
1003: <> per_ppb_shd.g_old_rec.information9)
1004: or (p_rec.information10
1005: <> per_ppb_shd.g_old_rec.information10)
1006: or (p_rec.information11
1007: <> per_ppb_shd.g_old_rec.information11)
1008: or (p_rec.information12
1009: <> per_ppb_shd.g_old_rec.information12)

Line 1007: <> per_ppb_shd.g_old_rec.information11)

1003: <> per_ppb_shd.g_old_rec.information9)
1004: or (p_rec.information10
1005: <> per_ppb_shd.g_old_rec.information10)
1006: or (p_rec.information11
1007: <> per_ppb_shd.g_old_rec.information11)
1008: or (p_rec.information12
1009: <> per_ppb_shd.g_old_rec.information12)
1010: or (p_rec.information13
1011: <> per_ppb_shd.g_old_rec.information13)

Line 1009: <> per_ppb_shd.g_old_rec.information12)

1005: <> per_ppb_shd.g_old_rec.information10)
1006: or (p_rec.information11
1007: <> per_ppb_shd.g_old_rec.information11)
1008: or (p_rec.information12
1009: <> per_ppb_shd.g_old_rec.information12)
1010: or (p_rec.information13
1011: <> per_ppb_shd.g_old_rec.information13)
1012: or (p_rec.information14
1013: <> per_ppb_shd.g_old_rec.information14)

Line 1011: <> per_ppb_shd.g_old_rec.information13)

1007: <> per_ppb_shd.g_old_rec.information11)
1008: or (p_rec.information12
1009: <> per_ppb_shd.g_old_rec.information12)
1010: or (p_rec.information13
1011: <> per_ppb_shd.g_old_rec.information13)
1012: or (p_rec.information14
1013: <> per_ppb_shd.g_old_rec.information14)
1014: or (p_rec.information15
1015: <> per_ppb_shd.g_old_rec.information15)

Line 1013: <> per_ppb_shd.g_old_rec.information14)

1009: <> per_ppb_shd.g_old_rec.information12)
1010: or (p_rec.information13
1011: <> per_ppb_shd.g_old_rec.information13)
1012: or (p_rec.information14
1013: <> per_ppb_shd.g_old_rec.information14)
1014: or (p_rec.information15
1015: <> per_ppb_shd.g_old_rec.information15)
1016: or (p_rec.information16
1017: <> per_ppb_shd.g_old_rec.information16)

Line 1015: <> per_ppb_shd.g_old_rec.information15)

1011: <> per_ppb_shd.g_old_rec.information13)
1012: or (p_rec.information14
1013: <> per_ppb_shd.g_old_rec.information14)
1014: or (p_rec.information15
1015: <> per_ppb_shd.g_old_rec.information15)
1016: or (p_rec.information16
1017: <> per_ppb_shd.g_old_rec.information16)
1018: or (p_rec.information17
1019: <> per_ppb_shd.g_old_rec.information17)

Line 1017: <> per_ppb_shd.g_old_rec.information16)

1013: <> per_ppb_shd.g_old_rec.information14)
1014: or (p_rec.information15
1015: <> per_ppb_shd.g_old_rec.information15)
1016: or (p_rec.information16
1017: <> per_ppb_shd.g_old_rec.information16)
1018: or (p_rec.information17
1019: <> per_ppb_shd.g_old_rec.information17)
1020: or (p_rec.information18
1021: <> per_ppb_shd.g_old_rec.information18)

Line 1019: <> per_ppb_shd.g_old_rec.information17)

1015: <> per_ppb_shd.g_old_rec.information15)
1016: or (p_rec.information16
1017: <> per_ppb_shd.g_old_rec.information16)
1018: or (p_rec.information17
1019: <> per_ppb_shd.g_old_rec.information17)
1020: or (p_rec.information18
1021: <> per_ppb_shd.g_old_rec.information18)
1022: or (p_rec.information19
1023: <> per_ppb_shd.g_old_rec.information19)

Line 1021: <> per_ppb_shd.g_old_rec.information18)

1017: <> per_ppb_shd.g_old_rec.information16)
1018: or (p_rec.information17
1019: <> per_ppb_shd.g_old_rec.information17)
1020: or (p_rec.information18
1021: <> per_ppb_shd.g_old_rec.information18)
1022: or (p_rec.information19
1023: <> per_ppb_shd.g_old_rec.information19)
1024: or (p_rec.information20
1025: <> per_ppb_shd.g_old_rec.information20) THEN

Line 1023: <> per_ppb_shd.g_old_rec.information19)

1019: <> per_ppb_shd.g_old_rec.information17)
1020: or (p_rec.information18
1021: <> per_ppb_shd.g_old_rec.information18)
1022: or (p_rec.information19
1023: <> per_ppb_shd.g_old_rec.information19)
1024: or (p_rec.information20
1025: <> per_ppb_shd.g_old_rec.information20) THEN
1026: hr_utility.set_location('Entering:'||l_proc, 30);
1027: fnd_message.set_name('PER','HR_51268_PYP_CANT_UPD_RECORD');

Line 1025: <> per_ppb_shd.g_old_rec.information20) THEN

1021: <> per_ppb_shd.g_old_rec.information18)
1022: or (p_rec.information19
1023: <> per_ppb_shd.g_old_rec.information19)
1024: or (p_rec.information20
1025: <> per_ppb_shd.g_old_rec.information20) THEN
1026: hr_utility.set_location('Entering:'||l_proc, 30);
1027: fnd_message.set_name('PER','HR_51268_PYP_CANT_UPD_RECORD');
1028: fnd_message.raise_error;
1029: end if;

Line 1070: (p_rec in per_ppb_shd.g_rec_type

1066: -- Internal Row Handler Use Only.
1067: --
1068: -- ----------------------------------------------------------------------------
1069: procedure chk_ddf
1070: (p_rec in per_ppb_shd.g_rec_type
1071: ) is
1072: --
1073: l_proc varchar2(72) := g_package || 'chk_ddf';
1074: --

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 1207: (p_rec in per_ppb_shd.g_rec_type

1203: -- Internal Row Handler Use Only.
1204: --
1205: -- ----------------------------------------------------------------------------
1206: procedure chk_df
1207: (p_rec in per_ppb_shd.g_rec_type
1208: ) is
1209: --
1210: l_proc varchar2(72) := g_package || 'chk_df';
1211: --

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 1343: (p_rec in per_ppb_shd.g_rec_type

1339: --
1340: -- {End Of Comments}
1341: -- ----------------------------------------------------------------------------
1342: Procedure chk_non_updateable_args
1343: (p_rec in per_ppb_shd.g_rec_type
1344: ) IS
1345: --
1346: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
1347: --

Line 1353: IF NOT per_ppb_shd.api_updating

1349: --
1350: -- Only proceed with the validation if a row exists for the current
1351: -- record in the HR Schema.
1352: --
1353: IF NOT per_ppb_shd.api_updating
1354: (p_pay_basis_id => p_rec.pay_basis_id
1355: ,p_object_version_number => p_rec.object_version_number
1356: ) THEN
1357: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 1372: (p_rec in per_ppb_shd.g_rec_type

1368: -- ----------------------------------------------------------------------------
1369: -- |---------------------------< insert_validate >----------------------------|
1370: -- ----------------------------------------------------------------------------
1371: Procedure insert_validate
1372: (p_rec in per_ppb_shd.g_rec_type
1373: ) is
1374: --
1375: l_proc varchar2(72) := g_package||'insert_validate';
1376: l_leg_code varchar2(30);

Line 1393: ,p_associated_column1 => per_ppb_shd.g_tab_nam

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: --
1396: chk_pay_basis_id(p_pay_basis_id => p_rec.pay_basis_id,
1397: p_object_version_number => p_rec.object_version_number

Line 1454: (p_rec in per_ppb_shd.g_rec_type

1450: -- ----------------------------------------------------------------------------
1451: -- |---------------------------< update_validate >----------------------------|
1452: -- ----------------------------------------------------------------------------
1453: Procedure update_validate
1454: (p_rec in per_ppb_shd.g_rec_type
1455: ) is
1456: --
1457: l_proc varchar2(72) := g_package||'update_validate';
1458: l_leg_code varchar2(30);

Line 1474: ,p_associated_column1 => per_ppb_shd.g_tab_nam

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: --
1477: chk_pay_basis_id(p_pay_basis_id => p_rec.pay_basis_id,
1478: p_object_version_number => p_rec.object_version_number

Line 1544: (p_rec in per_ppb_shd.g_rec_type

1540: -- ----------------------------------------------------------------------------
1541: -- |---------------------------< delete_validate >----------------------------|
1542: -- ----------------------------------------------------------------------------
1543: Procedure delete_validate
1544: (p_rec in per_ppb_shd.g_rec_type
1545: ) is
1546: --
1547: l_proc varchar2(72) := g_package||'delete_validate';
1548: --