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

APPS.HR_ORI_BUS dependencies on HR_ORI_SHD

Line 973: (p_rec in hr_ori_shd.g_rec_type

969: -- Internal Row Handler Use Only.
970: --
971: -- ----------------------------------------------------------------------------
972: procedure chk_ddf
973: (p_rec in hr_ori_shd.g_rec_type
974: ) is
975: --
976: l_proc varchar2(72) := g_package || 'chk_ddf';
977: --

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

978: begin
979: hr_utility.set_location('Entering:'||l_proc,10);
980: --
981: if ((p_rec.org_information_id is not null) and (
982: nvl(hr_ori_shd.g_old_rec.org_information_id, hr_api.g_number) <>
983: nvl(p_rec.org_information_id, hr_api.g_number) or
984: nvl(hr_ori_shd.g_old_rec.org_information_context, hr_api.g_varchar2) <>
985: nvl(p_rec.org_information_context, hr_api.g_varchar2) or
986: nvl(hr_ori_shd.g_old_rec.org_information1, hr_api.g_varchar2) <>

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

980: --
981: if ((p_rec.org_information_id is not null) and (
982: nvl(hr_ori_shd.g_old_rec.org_information_id, hr_api.g_number) <>
983: nvl(p_rec.org_information_id, hr_api.g_number) or
984: nvl(hr_ori_shd.g_old_rec.org_information_context, hr_api.g_varchar2) <>
985: nvl(p_rec.org_information_context, hr_api.g_varchar2) or
986: nvl(hr_ori_shd.g_old_rec.org_information1, hr_api.g_varchar2) <>
987: nvl(p_rec.org_information1, hr_api.g_varchar2) or
988: nvl(hr_ori_shd.g_old_rec.org_information10, hr_api.g_varchar2) <>

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

982: nvl(hr_ori_shd.g_old_rec.org_information_id, hr_api.g_number) <>
983: nvl(p_rec.org_information_id, hr_api.g_number) or
984: nvl(hr_ori_shd.g_old_rec.org_information_context, hr_api.g_varchar2) <>
985: nvl(p_rec.org_information_context, hr_api.g_varchar2) or
986: nvl(hr_ori_shd.g_old_rec.org_information1, hr_api.g_varchar2) <>
987: nvl(p_rec.org_information1, hr_api.g_varchar2) or
988: nvl(hr_ori_shd.g_old_rec.org_information10, hr_api.g_varchar2) <>
989: nvl(p_rec.org_information10, hr_api.g_varchar2) or
990: nvl(hr_ori_shd.g_old_rec.org_information11, hr_api.g_varchar2) <>

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

984: nvl(hr_ori_shd.g_old_rec.org_information_context, hr_api.g_varchar2) <>
985: nvl(p_rec.org_information_context, hr_api.g_varchar2) or
986: nvl(hr_ori_shd.g_old_rec.org_information1, hr_api.g_varchar2) <>
987: nvl(p_rec.org_information1, hr_api.g_varchar2) or
988: nvl(hr_ori_shd.g_old_rec.org_information10, hr_api.g_varchar2) <>
989: nvl(p_rec.org_information10, hr_api.g_varchar2) or
990: nvl(hr_ori_shd.g_old_rec.org_information11, hr_api.g_varchar2) <>
991: nvl(p_rec.org_information11, hr_api.g_varchar2) or
992: nvl(hr_ori_shd.g_old_rec.org_information12, hr_api.g_varchar2) <>

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

986: nvl(hr_ori_shd.g_old_rec.org_information1, hr_api.g_varchar2) <>
987: nvl(p_rec.org_information1, hr_api.g_varchar2) or
988: nvl(hr_ori_shd.g_old_rec.org_information10, hr_api.g_varchar2) <>
989: nvl(p_rec.org_information10, hr_api.g_varchar2) or
990: nvl(hr_ori_shd.g_old_rec.org_information11, hr_api.g_varchar2) <>
991: nvl(p_rec.org_information11, hr_api.g_varchar2) or
992: nvl(hr_ori_shd.g_old_rec.org_information12, hr_api.g_varchar2) <>
993: nvl(p_rec.org_information12, hr_api.g_varchar2) or
994: nvl(hr_ori_shd.g_old_rec.org_information13, hr_api.g_varchar2) <>

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

988: nvl(hr_ori_shd.g_old_rec.org_information10, hr_api.g_varchar2) <>
989: nvl(p_rec.org_information10, hr_api.g_varchar2) or
990: nvl(hr_ori_shd.g_old_rec.org_information11, hr_api.g_varchar2) <>
991: nvl(p_rec.org_information11, hr_api.g_varchar2) or
992: nvl(hr_ori_shd.g_old_rec.org_information12, hr_api.g_varchar2) <>
993: nvl(p_rec.org_information12, hr_api.g_varchar2) or
994: nvl(hr_ori_shd.g_old_rec.org_information13, hr_api.g_varchar2) <>
995: nvl(p_rec.org_information13, hr_api.g_varchar2) or
996: nvl(hr_ori_shd.g_old_rec.org_information14, hr_api.g_varchar2) <>

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

990: nvl(hr_ori_shd.g_old_rec.org_information11, hr_api.g_varchar2) <>
991: nvl(p_rec.org_information11, hr_api.g_varchar2) or
992: nvl(hr_ori_shd.g_old_rec.org_information12, hr_api.g_varchar2) <>
993: nvl(p_rec.org_information12, hr_api.g_varchar2) or
994: nvl(hr_ori_shd.g_old_rec.org_information13, hr_api.g_varchar2) <>
995: nvl(p_rec.org_information13, hr_api.g_varchar2) or
996: nvl(hr_ori_shd.g_old_rec.org_information14, hr_api.g_varchar2) <>
997: nvl(p_rec.org_information14, hr_api.g_varchar2) or
998: nvl(hr_ori_shd.g_old_rec.org_information15, hr_api.g_varchar2) <>

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

992: nvl(hr_ori_shd.g_old_rec.org_information12, hr_api.g_varchar2) <>
993: nvl(p_rec.org_information12, hr_api.g_varchar2) or
994: nvl(hr_ori_shd.g_old_rec.org_information13, hr_api.g_varchar2) <>
995: nvl(p_rec.org_information13, hr_api.g_varchar2) or
996: nvl(hr_ori_shd.g_old_rec.org_information14, hr_api.g_varchar2) <>
997: nvl(p_rec.org_information14, hr_api.g_varchar2) or
998: nvl(hr_ori_shd.g_old_rec.org_information15, hr_api.g_varchar2) <>
999: nvl(p_rec.org_information15, hr_api.g_varchar2) or
1000: nvl(hr_ori_shd.g_old_rec.org_information16, hr_api.g_varchar2) <>

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

994: nvl(hr_ori_shd.g_old_rec.org_information13, hr_api.g_varchar2) <>
995: nvl(p_rec.org_information13, hr_api.g_varchar2) or
996: nvl(hr_ori_shd.g_old_rec.org_information14, hr_api.g_varchar2) <>
997: nvl(p_rec.org_information14, hr_api.g_varchar2) or
998: nvl(hr_ori_shd.g_old_rec.org_information15, hr_api.g_varchar2) <>
999: nvl(p_rec.org_information15, hr_api.g_varchar2) or
1000: nvl(hr_ori_shd.g_old_rec.org_information16, hr_api.g_varchar2) <>
1001: nvl(p_rec.org_information16, hr_api.g_varchar2) or
1002: nvl(hr_ori_shd.g_old_rec.org_information17, hr_api.g_varchar2) <>

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

996: nvl(hr_ori_shd.g_old_rec.org_information14, hr_api.g_varchar2) <>
997: nvl(p_rec.org_information14, hr_api.g_varchar2) or
998: nvl(hr_ori_shd.g_old_rec.org_information15, hr_api.g_varchar2) <>
999: nvl(p_rec.org_information15, hr_api.g_varchar2) or
1000: nvl(hr_ori_shd.g_old_rec.org_information16, hr_api.g_varchar2) <>
1001: nvl(p_rec.org_information16, hr_api.g_varchar2) or
1002: nvl(hr_ori_shd.g_old_rec.org_information17, hr_api.g_varchar2) <>
1003: nvl(p_rec.org_information17, hr_api.g_varchar2) or
1004: nvl(hr_ori_shd.g_old_rec.org_information18, hr_api.g_varchar2) <>

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

998: nvl(hr_ori_shd.g_old_rec.org_information15, hr_api.g_varchar2) <>
999: nvl(p_rec.org_information15, hr_api.g_varchar2) or
1000: nvl(hr_ori_shd.g_old_rec.org_information16, hr_api.g_varchar2) <>
1001: nvl(p_rec.org_information16, hr_api.g_varchar2) or
1002: nvl(hr_ori_shd.g_old_rec.org_information17, hr_api.g_varchar2) <>
1003: nvl(p_rec.org_information17, hr_api.g_varchar2) or
1004: nvl(hr_ori_shd.g_old_rec.org_information18, hr_api.g_varchar2) <>
1005: nvl(p_rec.org_information18, hr_api.g_varchar2) or
1006: nvl(hr_ori_shd.g_old_rec.org_information19, hr_api.g_varchar2) <>

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

1000: nvl(hr_ori_shd.g_old_rec.org_information16, hr_api.g_varchar2) <>
1001: nvl(p_rec.org_information16, hr_api.g_varchar2) or
1002: nvl(hr_ori_shd.g_old_rec.org_information17, hr_api.g_varchar2) <>
1003: nvl(p_rec.org_information17, hr_api.g_varchar2) or
1004: nvl(hr_ori_shd.g_old_rec.org_information18, hr_api.g_varchar2) <>
1005: nvl(p_rec.org_information18, hr_api.g_varchar2) or
1006: nvl(hr_ori_shd.g_old_rec.org_information19, hr_api.g_varchar2) <>
1007: nvl(p_rec.org_information19, hr_api.g_varchar2) or
1008: nvl(hr_ori_shd.g_old_rec.org_information2, hr_api.g_varchar2) <>

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

1002: nvl(hr_ori_shd.g_old_rec.org_information17, hr_api.g_varchar2) <>
1003: nvl(p_rec.org_information17, hr_api.g_varchar2) or
1004: nvl(hr_ori_shd.g_old_rec.org_information18, hr_api.g_varchar2) <>
1005: nvl(p_rec.org_information18, hr_api.g_varchar2) or
1006: nvl(hr_ori_shd.g_old_rec.org_information19, hr_api.g_varchar2) <>
1007: nvl(p_rec.org_information19, hr_api.g_varchar2) or
1008: nvl(hr_ori_shd.g_old_rec.org_information2, hr_api.g_varchar2) <>
1009: nvl(p_rec.org_information2, hr_api.g_varchar2) or
1010: nvl(hr_ori_shd.g_old_rec.org_information20, hr_api.g_varchar2) <>

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

1004: nvl(hr_ori_shd.g_old_rec.org_information18, hr_api.g_varchar2) <>
1005: nvl(p_rec.org_information18, hr_api.g_varchar2) or
1006: nvl(hr_ori_shd.g_old_rec.org_information19, hr_api.g_varchar2) <>
1007: nvl(p_rec.org_information19, hr_api.g_varchar2) or
1008: nvl(hr_ori_shd.g_old_rec.org_information2, hr_api.g_varchar2) <>
1009: nvl(p_rec.org_information2, hr_api.g_varchar2) or
1010: nvl(hr_ori_shd.g_old_rec.org_information20, hr_api.g_varchar2) <>
1011: nvl(p_rec.org_information20, hr_api.g_varchar2) or
1012: nvl(hr_ori_shd.g_old_rec.org_information3, hr_api.g_varchar2) <>

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

1006: nvl(hr_ori_shd.g_old_rec.org_information19, hr_api.g_varchar2) <>
1007: nvl(p_rec.org_information19, hr_api.g_varchar2) or
1008: nvl(hr_ori_shd.g_old_rec.org_information2, hr_api.g_varchar2) <>
1009: nvl(p_rec.org_information2, hr_api.g_varchar2) or
1010: nvl(hr_ori_shd.g_old_rec.org_information20, hr_api.g_varchar2) <>
1011: nvl(p_rec.org_information20, hr_api.g_varchar2) or
1012: nvl(hr_ori_shd.g_old_rec.org_information3, hr_api.g_varchar2) <>
1013: nvl(p_rec.org_information3, hr_api.g_varchar2) or
1014: nvl(hr_ori_shd.g_old_rec.org_information4, hr_api.g_varchar2) <>

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

1008: nvl(hr_ori_shd.g_old_rec.org_information2, hr_api.g_varchar2) <>
1009: nvl(p_rec.org_information2, hr_api.g_varchar2) or
1010: nvl(hr_ori_shd.g_old_rec.org_information20, hr_api.g_varchar2) <>
1011: nvl(p_rec.org_information20, hr_api.g_varchar2) or
1012: nvl(hr_ori_shd.g_old_rec.org_information3, hr_api.g_varchar2) <>
1013: nvl(p_rec.org_information3, hr_api.g_varchar2) or
1014: nvl(hr_ori_shd.g_old_rec.org_information4, hr_api.g_varchar2) <>
1015: nvl(p_rec.org_information4, hr_api.g_varchar2) or
1016: nvl(hr_ori_shd.g_old_rec.org_information5, hr_api.g_varchar2) <>

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

1010: nvl(hr_ori_shd.g_old_rec.org_information20, hr_api.g_varchar2) <>
1011: nvl(p_rec.org_information20, hr_api.g_varchar2) or
1012: nvl(hr_ori_shd.g_old_rec.org_information3, hr_api.g_varchar2) <>
1013: nvl(p_rec.org_information3, hr_api.g_varchar2) or
1014: nvl(hr_ori_shd.g_old_rec.org_information4, hr_api.g_varchar2) <>
1015: nvl(p_rec.org_information4, hr_api.g_varchar2) or
1016: nvl(hr_ori_shd.g_old_rec.org_information5, hr_api.g_varchar2) <>
1017: nvl(p_rec.org_information5, hr_api.g_varchar2) or
1018: nvl(hr_ori_shd.g_old_rec.org_information6, hr_api.g_varchar2) <>

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

1012: nvl(hr_ori_shd.g_old_rec.org_information3, hr_api.g_varchar2) <>
1013: nvl(p_rec.org_information3, hr_api.g_varchar2) or
1014: nvl(hr_ori_shd.g_old_rec.org_information4, hr_api.g_varchar2) <>
1015: nvl(p_rec.org_information4, hr_api.g_varchar2) or
1016: nvl(hr_ori_shd.g_old_rec.org_information5, hr_api.g_varchar2) <>
1017: nvl(p_rec.org_information5, hr_api.g_varchar2) or
1018: nvl(hr_ori_shd.g_old_rec.org_information6, hr_api.g_varchar2) <>
1019: nvl(p_rec.org_information6, hr_api.g_varchar2) or
1020: nvl(hr_ori_shd.g_old_rec.org_information7, hr_api.g_varchar2) <>

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

1014: nvl(hr_ori_shd.g_old_rec.org_information4, hr_api.g_varchar2) <>
1015: nvl(p_rec.org_information4, hr_api.g_varchar2) or
1016: nvl(hr_ori_shd.g_old_rec.org_information5, hr_api.g_varchar2) <>
1017: nvl(p_rec.org_information5, hr_api.g_varchar2) or
1018: nvl(hr_ori_shd.g_old_rec.org_information6, hr_api.g_varchar2) <>
1019: nvl(p_rec.org_information6, hr_api.g_varchar2) or
1020: nvl(hr_ori_shd.g_old_rec.org_information7, hr_api.g_varchar2) <>
1021: nvl(p_rec.org_information7, hr_api.g_varchar2) or
1022: nvl(hr_ori_shd.g_old_rec.org_information8, hr_api.g_varchar2) <>

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

1016: nvl(hr_ori_shd.g_old_rec.org_information5, hr_api.g_varchar2) <>
1017: nvl(p_rec.org_information5, hr_api.g_varchar2) or
1018: nvl(hr_ori_shd.g_old_rec.org_information6, hr_api.g_varchar2) <>
1019: nvl(p_rec.org_information6, hr_api.g_varchar2) or
1020: nvl(hr_ori_shd.g_old_rec.org_information7, hr_api.g_varchar2) <>
1021: nvl(p_rec.org_information7, hr_api.g_varchar2) or
1022: nvl(hr_ori_shd.g_old_rec.org_information8, hr_api.g_varchar2) <>
1023: nvl(p_rec.org_information8, hr_api.g_varchar2) or
1024: nvl(hr_ori_shd.g_old_rec.org_information9, hr_api.g_varchar2) <>

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

1018: nvl(hr_ori_shd.g_old_rec.org_information6, hr_api.g_varchar2) <>
1019: nvl(p_rec.org_information6, hr_api.g_varchar2) or
1020: nvl(hr_ori_shd.g_old_rec.org_information7, hr_api.g_varchar2) <>
1021: nvl(p_rec.org_information7, hr_api.g_varchar2) or
1022: nvl(hr_ori_shd.g_old_rec.org_information8, hr_api.g_varchar2) <>
1023: nvl(p_rec.org_information8, hr_api.g_varchar2) or
1024: nvl(hr_ori_shd.g_old_rec.org_information9, hr_api.g_varchar2) <>
1025: nvl(p_rec.org_information9, hr_api.g_varchar2) ))
1026: or (p_rec.org_information_id is null) then

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

1020: nvl(hr_ori_shd.g_old_rec.org_information7, hr_api.g_varchar2) <>
1021: nvl(p_rec.org_information7, hr_api.g_varchar2) or
1022: nvl(hr_ori_shd.g_old_rec.org_information8, hr_api.g_varchar2) <>
1023: nvl(p_rec.org_information8, hr_api.g_varchar2) or
1024: nvl(hr_ori_shd.g_old_rec.org_information9, hr_api.g_varchar2) <>
1025: nvl(p_rec.org_information9, hr_api.g_varchar2) ))
1026: or (p_rec.org_information_id is null) then
1027: --
1028: -- Only execute the validation if absolutely necessary:

Line 1132: (p_rec in hr_ori_shd.g_rec_type

1128: -- Internal Row Handler Use Only.
1129: --
1130: -- ----------------------------------------------------------------------------
1131: procedure chk_df
1132: (p_rec in hr_ori_shd.g_rec_type
1133: ) is
1134: --
1135: l_proc varchar2(72) := g_package || 'chk_df';
1136: --

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

1137: begin
1138: hr_utility.set_location('Entering:'||l_proc,10);
1139: --
1140: if ((p_rec.org_information_id is not null) and (
1141: nvl(hr_ori_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1142: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1143: nvl(hr_ori_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1144: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1145: nvl(hr_ori_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

1139: --
1140: if ((p_rec.org_information_id is not null) and (
1141: nvl(hr_ori_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1142: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1143: nvl(hr_ori_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1144: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1145: nvl(hr_ori_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1146: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1147: nvl(hr_ori_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

1141: nvl(hr_ori_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1142: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1143: nvl(hr_ori_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1144: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1145: nvl(hr_ori_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1146: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1147: nvl(hr_ori_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1148: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1149: nvl(hr_ori_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

1143: nvl(hr_ori_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1144: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1145: nvl(hr_ori_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1146: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1147: nvl(hr_ori_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1148: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1149: nvl(hr_ori_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1150: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1151: nvl(hr_ori_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

1145: nvl(hr_ori_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1146: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1147: nvl(hr_ori_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1148: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1149: nvl(hr_ori_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1150: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1151: nvl(hr_ori_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1152: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1153: nvl(hr_ori_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

1147: nvl(hr_ori_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1148: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1149: nvl(hr_ori_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1150: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1151: nvl(hr_ori_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1152: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1153: nvl(hr_ori_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1154: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1155: nvl(hr_ori_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

1149: nvl(hr_ori_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1150: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1151: nvl(hr_ori_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1152: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1153: nvl(hr_ori_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1154: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1155: nvl(hr_ori_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1156: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1157: nvl(hr_ori_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

1151: nvl(hr_ori_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1152: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1153: nvl(hr_ori_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1154: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1155: nvl(hr_ori_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1156: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1157: nvl(hr_ori_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1158: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1159: nvl(hr_ori_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

1153: nvl(hr_ori_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1154: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1155: nvl(hr_ori_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1156: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1157: nvl(hr_ori_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1158: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1159: nvl(hr_ori_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1160: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1161: nvl(hr_ori_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

1155: nvl(hr_ori_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1156: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1157: nvl(hr_ori_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1158: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1159: nvl(hr_ori_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1160: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1161: nvl(hr_ori_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1162: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1163: nvl(hr_ori_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

1157: nvl(hr_ori_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1158: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1159: nvl(hr_ori_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1160: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1161: nvl(hr_ori_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1162: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1163: nvl(hr_ori_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1164: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1165: nvl(hr_ori_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

1159: nvl(hr_ori_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1160: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1161: nvl(hr_ori_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1162: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1163: nvl(hr_ori_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1164: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1165: nvl(hr_ori_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1166: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1167: nvl(hr_ori_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

1161: nvl(hr_ori_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1162: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1163: nvl(hr_ori_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1164: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1165: nvl(hr_ori_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1166: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1167: nvl(hr_ori_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1168: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1169: nvl(hr_ori_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

1163: nvl(hr_ori_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1164: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1165: nvl(hr_ori_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1166: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1167: nvl(hr_ori_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1168: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1169: nvl(hr_ori_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1170: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1171: nvl(hr_ori_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

1165: nvl(hr_ori_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1166: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1167: nvl(hr_ori_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1168: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1169: nvl(hr_ori_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1170: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1171: nvl(hr_ori_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1172: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1173: nvl(hr_ori_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

1167: nvl(hr_ori_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1168: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1169: nvl(hr_ori_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1170: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1171: nvl(hr_ori_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1172: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1173: nvl(hr_ori_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1174: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1175: nvl(hr_ori_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

1169: nvl(hr_ori_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1170: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1171: nvl(hr_ori_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1172: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1173: nvl(hr_ori_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1174: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1175: nvl(hr_ori_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1176: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1177: nvl(hr_ori_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

1171: nvl(hr_ori_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1172: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1173: nvl(hr_ori_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1174: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1175: nvl(hr_ori_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1176: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1177: nvl(hr_ori_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1178: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1179: nvl(hr_ori_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

1173: nvl(hr_ori_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1174: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1175: nvl(hr_ori_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1176: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1177: nvl(hr_ori_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1178: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1179: nvl(hr_ori_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1180: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1181: nvl(hr_ori_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

1175: nvl(hr_ori_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1176: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1177: nvl(hr_ori_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1178: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1179: nvl(hr_ori_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1180: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1181: nvl(hr_ori_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1182: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
1183: or (p_rec.org_information_id is null) then

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

1177: nvl(hr_ori_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1178: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1179: nvl(hr_ori_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1180: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1181: nvl(hr_ori_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1182: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
1183: or (p_rec.org_information_id is null) then
1184: --
1185: -- Only execute the validation if absolutely necessary:

Line 1269: ,p_rec in hr_ori_shd.g_rec_type

1265: -- {End Of Comments}
1266: -- ----------------------------------------------------------------------------
1267: Procedure chk_non_updateable_args
1268: (p_effective_date in date
1269: ,p_rec in hr_ori_shd.g_rec_type
1270: ) IS
1271: --
1272: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
1273: l_error EXCEPTION;

Line 1281: IF NOT hr_ori_shd.api_updating

1277: --
1278: -- Only proceed with the validation if a row exists for the current
1279: -- record in the HR Schema.
1280: --
1281: IF NOT hr_ori_shd.api_updating
1282: (p_org_information_id => p_rec.org_information_id
1283: ,p_object_version_number => p_rec.object_version_number
1284: ) THEN
1285: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

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

1291: -- EDIT_HERE: Add checks to ensure non-updateable args have
1292: -- not been updated.
1293: --
1294: IF nvl(p_rec.org_information_context, hr_api.g_varchar2) <>
1295: nvl(hr_ori_shd.g_old_rec.org_information_context, hr_api.g_varchar2) THEN
1296: l_argument := 'ORG_INFORMATION_CONTEXT';
1297: RAISE l_error;
1298: END IF;
1299: --

Line 1901: ,p_rec in hr_ori_shd.g_rec_type

1897: -- |---------------------------< insert_validate >----------------------------|
1898: -- ----------------------------------------------------------------------------
1899: Procedure insert_validate
1900: (p_effective_date in date
1901: ,p_rec in hr_ori_shd.g_rec_type
1902: ) is
1903: --
1904: l_proc varchar2(72) := g_package||'insert_validate';
1905: l_bg_id number;

Line 2074: ,p_rec in hr_ori_shd.g_rec_type

2070: -- |---------------------------< update_validate >----------------------------|
2071: -- ----------------------------------------------------------------------------
2072: Procedure update_validate
2073: (p_effective_date in date
2074: ,p_rec in hr_ori_shd.g_rec_type
2075: ) is
2076: --
2077: cursor c_date (p_id number) is
2078: select min(effective_start_date), max(effective_end_date)

Line 2238: (p_rec in hr_ori_shd.g_rec_type

2234: -- ----------------------------------------------------------------------------
2235: -- |---------------------------< delete_validate >----------------------------|
2236: -- ----------------------------------------------------------------------------
2237: Procedure delete_validate
2238: (p_rec in hr_ori_shd.g_rec_type
2239: ) is
2240: --
2241: l_proc varchar2(72) := g_package||'delete_validate';
2242: --