APPS.IRC_IRF_BUS dependencies on HR_API

Line 97: nvl(irc_irf_shd.g_old_rec.irf_information_category, hr_api.g_varchar2) <>

93: begin
94: hr_utility.set_location('Entering:'||l_proc,10);
95: --
96: if ((p_rec.referral_info_id is not null) and (
97: nvl(irc_irf_shd.g_old_rec.irf_information_category, hr_api.g_varchar2) <>
98: nvl(p_rec.irf_information_category, hr_api.g_varchar2) or
99: nvl(irc_irf_shd.g_old_rec.irf_information1, hr_api.g_varchar2) <>
100: nvl(p_rec.irf_information1, hr_api.g_varchar2) or
101: nvl(irc_irf_shd.g_old_rec.irf_information2, hr_api.g_varchar2) <>

Line 98: nvl(p_rec.irf_information_category, hr_api.g_varchar2) or

94: hr_utility.set_location('Entering:'||l_proc,10);
95: --
96: if ((p_rec.referral_info_id is not null) and (
97: nvl(irc_irf_shd.g_old_rec.irf_information_category, hr_api.g_varchar2) <>
98: nvl(p_rec.irf_information_category, hr_api.g_varchar2) or
99: nvl(irc_irf_shd.g_old_rec.irf_information1, hr_api.g_varchar2) <>
100: nvl(p_rec.irf_information1, hr_api.g_varchar2) or
101: nvl(irc_irf_shd.g_old_rec.irf_information2, hr_api.g_varchar2) <>
102: nvl(p_rec.irf_information2, hr_api.g_varchar2) or

Line 99: nvl(irc_irf_shd.g_old_rec.irf_information1, hr_api.g_varchar2) <>

95: --
96: if ((p_rec.referral_info_id is not null) and (
97: nvl(irc_irf_shd.g_old_rec.irf_information_category, hr_api.g_varchar2) <>
98: nvl(p_rec.irf_information_category, hr_api.g_varchar2) or
99: nvl(irc_irf_shd.g_old_rec.irf_information1, hr_api.g_varchar2) <>
100: nvl(p_rec.irf_information1, hr_api.g_varchar2) or
101: nvl(irc_irf_shd.g_old_rec.irf_information2, hr_api.g_varchar2) <>
102: nvl(p_rec.irf_information2, hr_api.g_varchar2) or
103: nvl(irc_irf_shd.g_old_rec.irf_information3, hr_api.g_varchar2) <>

Line 100: nvl(p_rec.irf_information1, hr_api.g_varchar2) or

96: if ((p_rec.referral_info_id is not null) and (
97: nvl(irc_irf_shd.g_old_rec.irf_information_category, hr_api.g_varchar2) <>
98: nvl(p_rec.irf_information_category, hr_api.g_varchar2) or
99: nvl(irc_irf_shd.g_old_rec.irf_information1, hr_api.g_varchar2) <>
100: nvl(p_rec.irf_information1, hr_api.g_varchar2) or
101: nvl(irc_irf_shd.g_old_rec.irf_information2, hr_api.g_varchar2) <>
102: nvl(p_rec.irf_information2, hr_api.g_varchar2) or
103: nvl(irc_irf_shd.g_old_rec.irf_information3, hr_api.g_varchar2) <>
104: nvl(p_rec.irf_information3, hr_api.g_varchar2) or

Line 101: nvl(irc_irf_shd.g_old_rec.irf_information2, hr_api.g_varchar2) <>

97: nvl(irc_irf_shd.g_old_rec.irf_information_category, hr_api.g_varchar2) <>
98: nvl(p_rec.irf_information_category, hr_api.g_varchar2) or
99: nvl(irc_irf_shd.g_old_rec.irf_information1, hr_api.g_varchar2) <>
100: nvl(p_rec.irf_information1, hr_api.g_varchar2) or
101: nvl(irc_irf_shd.g_old_rec.irf_information2, hr_api.g_varchar2) <>
102: nvl(p_rec.irf_information2, hr_api.g_varchar2) or
103: nvl(irc_irf_shd.g_old_rec.irf_information3, hr_api.g_varchar2) <>
104: nvl(p_rec.irf_information3, hr_api.g_varchar2) or
105: nvl(irc_irf_shd.g_old_rec.irf_information4, hr_api.g_varchar2) <>

Line 102: nvl(p_rec.irf_information2, hr_api.g_varchar2) or

98: nvl(p_rec.irf_information_category, hr_api.g_varchar2) or
99: nvl(irc_irf_shd.g_old_rec.irf_information1, hr_api.g_varchar2) <>
100: nvl(p_rec.irf_information1, hr_api.g_varchar2) or
101: nvl(irc_irf_shd.g_old_rec.irf_information2, hr_api.g_varchar2) <>
102: nvl(p_rec.irf_information2, hr_api.g_varchar2) or
103: nvl(irc_irf_shd.g_old_rec.irf_information3, hr_api.g_varchar2) <>
104: nvl(p_rec.irf_information3, hr_api.g_varchar2) or
105: nvl(irc_irf_shd.g_old_rec.irf_information4, hr_api.g_varchar2) <>
106: nvl(p_rec.irf_information4, hr_api.g_varchar2) or

Line 103: nvl(irc_irf_shd.g_old_rec.irf_information3, hr_api.g_varchar2) <>

99: nvl(irc_irf_shd.g_old_rec.irf_information1, hr_api.g_varchar2) <>
100: nvl(p_rec.irf_information1, hr_api.g_varchar2) or
101: nvl(irc_irf_shd.g_old_rec.irf_information2, hr_api.g_varchar2) <>
102: nvl(p_rec.irf_information2, hr_api.g_varchar2) or
103: nvl(irc_irf_shd.g_old_rec.irf_information3, hr_api.g_varchar2) <>
104: nvl(p_rec.irf_information3, hr_api.g_varchar2) or
105: nvl(irc_irf_shd.g_old_rec.irf_information4, hr_api.g_varchar2) <>
106: nvl(p_rec.irf_information4, hr_api.g_varchar2) or
107: nvl(irc_irf_shd.g_old_rec.irf_information5, hr_api.g_varchar2) <>

Line 104: nvl(p_rec.irf_information3, hr_api.g_varchar2) or

100: nvl(p_rec.irf_information1, hr_api.g_varchar2) or
101: nvl(irc_irf_shd.g_old_rec.irf_information2, hr_api.g_varchar2) <>
102: nvl(p_rec.irf_information2, hr_api.g_varchar2) or
103: nvl(irc_irf_shd.g_old_rec.irf_information3, hr_api.g_varchar2) <>
104: nvl(p_rec.irf_information3, hr_api.g_varchar2) or
105: nvl(irc_irf_shd.g_old_rec.irf_information4, hr_api.g_varchar2) <>
106: nvl(p_rec.irf_information4, hr_api.g_varchar2) or
107: nvl(irc_irf_shd.g_old_rec.irf_information5, hr_api.g_varchar2) <>
108: nvl(p_rec.irf_information5, hr_api.g_varchar2) or

Line 105: nvl(irc_irf_shd.g_old_rec.irf_information4, hr_api.g_varchar2) <>

101: nvl(irc_irf_shd.g_old_rec.irf_information2, hr_api.g_varchar2) <>
102: nvl(p_rec.irf_information2, hr_api.g_varchar2) or
103: nvl(irc_irf_shd.g_old_rec.irf_information3, hr_api.g_varchar2) <>
104: nvl(p_rec.irf_information3, hr_api.g_varchar2) or
105: nvl(irc_irf_shd.g_old_rec.irf_information4, hr_api.g_varchar2) <>
106: nvl(p_rec.irf_information4, hr_api.g_varchar2) or
107: nvl(irc_irf_shd.g_old_rec.irf_information5, hr_api.g_varchar2) <>
108: nvl(p_rec.irf_information5, hr_api.g_varchar2) or
109: nvl(irc_irf_shd.g_old_rec.irf_information6, hr_api.g_varchar2) <>

Line 106: nvl(p_rec.irf_information4, hr_api.g_varchar2) or

102: nvl(p_rec.irf_information2, hr_api.g_varchar2) or
103: nvl(irc_irf_shd.g_old_rec.irf_information3, hr_api.g_varchar2) <>
104: nvl(p_rec.irf_information3, hr_api.g_varchar2) or
105: nvl(irc_irf_shd.g_old_rec.irf_information4, hr_api.g_varchar2) <>
106: nvl(p_rec.irf_information4, hr_api.g_varchar2) or
107: nvl(irc_irf_shd.g_old_rec.irf_information5, hr_api.g_varchar2) <>
108: nvl(p_rec.irf_information5, hr_api.g_varchar2) or
109: nvl(irc_irf_shd.g_old_rec.irf_information6, hr_api.g_varchar2) <>
110: nvl(p_rec.irf_information6, hr_api.g_varchar2) or

Line 107: nvl(irc_irf_shd.g_old_rec.irf_information5, hr_api.g_varchar2) <>

103: nvl(irc_irf_shd.g_old_rec.irf_information3, hr_api.g_varchar2) <>
104: nvl(p_rec.irf_information3, hr_api.g_varchar2) or
105: nvl(irc_irf_shd.g_old_rec.irf_information4, hr_api.g_varchar2) <>
106: nvl(p_rec.irf_information4, hr_api.g_varchar2) or
107: nvl(irc_irf_shd.g_old_rec.irf_information5, hr_api.g_varchar2) <>
108: nvl(p_rec.irf_information5, hr_api.g_varchar2) or
109: nvl(irc_irf_shd.g_old_rec.irf_information6, hr_api.g_varchar2) <>
110: nvl(p_rec.irf_information6, hr_api.g_varchar2) or
111: nvl(irc_irf_shd.g_old_rec.irf_information7, hr_api.g_varchar2) <>

Line 108: nvl(p_rec.irf_information5, hr_api.g_varchar2) or

104: nvl(p_rec.irf_information3, hr_api.g_varchar2) or
105: nvl(irc_irf_shd.g_old_rec.irf_information4, hr_api.g_varchar2) <>
106: nvl(p_rec.irf_information4, hr_api.g_varchar2) or
107: nvl(irc_irf_shd.g_old_rec.irf_information5, hr_api.g_varchar2) <>
108: nvl(p_rec.irf_information5, hr_api.g_varchar2) or
109: nvl(irc_irf_shd.g_old_rec.irf_information6, hr_api.g_varchar2) <>
110: nvl(p_rec.irf_information6, hr_api.g_varchar2) or
111: nvl(irc_irf_shd.g_old_rec.irf_information7, hr_api.g_varchar2) <>
112: nvl(p_rec.irf_information7, hr_api.g_varchar2) or

Line 109: nvl(irc_irf_shd.g_old_rec.irf_information6, hr_api.g_varchar2) <>

105: nvl(irc_irf_shd.g_old_rec.irf_information4, hr_api.g_varchar2) <>
106: nvl(p_rec.irf_information4, hr_api.g_varchar2) or
107: nvl(irc_irf_shd.g_old_rec.irf_information5, hr_api.g_varchar2) <>
108: nvl(p_rec.irf_information5, hr_api.g_varchar2) or
109: nvl(irc_irf_shd.g_old_rec.irf_information6, hr_api.g_varchar2) <>
110: nvl(p_rec.irf_information6, hr_api.g_varchar2) or
111: nvl(irc_irf_shd.g_old_rec.irf_information7, hr_api.g_varchar2) <>
112: nvl(p_rec.irf_information7, hr_api.g_varchar2) or
113: nvl(irc_irf_shd.g_old_rec.irf_information8, hr_api.g_varchar2) <>

Line 110: nvl(p_rec.irf_information6, hr_api.g_varchar2) or

106: nvl(p_rec.irf_information4, hr_api.g_varchar2) or
107: nvl(irc_irf_shd.g_old_rec.irf_information5, hr_api.g_varchar2) <>
108: nvl(p_rec.irf_information5, hr_api.g_varchar2) or
109: nvl(irc_irf_shd.g_old_rec.irf_information6, hr_api.g_varchar2) <>
110: nvl(p_rec.irf_information6, hr_api.g_varchar2) or
111: nvl(irc_irf_shd.g_old_rec.irf_information7, hr_api.g_varchar2) <>
112: nvl(p_rec.irf_information7, hr_api.g_varchar2) or
113: nvl(irc_irf_shd.g_old_rec.irf_information8, hr_api.g_varchar2) <>
114: nvl(p_rec.irf_information8, hr_api.g_varchar2) or

Line 111: nvl(irc_irf_shd.g_old_rec.irf_information7, hr_api.g_varchar2) <>

107: nvl(irc_irf_shd.g_old_rec.irf_information5, hr_api.g_varchar2) <>
108: nvl(p_rec.irf_information5, hr_api.g_varchar2) or
109: nvl(irc_irf_shd.g_old_rec.irf_information6, hr_api.g_varchar2) <>
110: nvl(p_rec.irf_information6, hr_api.g_varchar2) or
111: nvl(irc_irf_shd.g_old_rec.irf_information7, hr_api.g_varchar2) <>
112: nvl(p_rec.irf_information7, hr_api.g_varchar2) or
113: nvl(irc_irf_shd.g_old_rec.irf_information8, hr_api.g_varchar2) <>
114: nvl(p_rec.irf_information8, hr_api.g_varchar2) or
115: nvl(irc_irf_shd.g_old_rec.irf_information9, hr_api.g_varchar2) <>

Line 112: nvl(p_rec.irf_information7, hr_api.g_varchar2) or

108: nvl(p_rec.irf_information5, hr_api.g_varchar2) or
109: nvl(irc_irf_shd.g_old_rec.irf_information6, hr_api.g_varchar2) <>
110: nvl(p_rec.irf_information6, hr_api.g_varchar2) or
111: nvl(irc_irf_shd.g_old_rec.irf_information7, hr_api.g_varchar2) <>
112: nvl(p_rec.irf_information7, hr_api.g_varchar2) or
113: nvl(irc_irf_shd.g_old_rec.irf_information8, hr_api.g_varchar2) <>
114: nvl(p_rec.irf_information8, hr_api.g_varchar2) or
115: nvl(irc_irf_shd.g_old_rec.irf_information9, hr_api.g_varchar2) <>
116: nvl(p_rec.irf_information9, hr_api.g_varchar2) or

Line 113: nvl(irc_irf_shd.g_old_rec.irf_information8, hr_api.g_varchar2) <>

109: nvl(irc_irf_shd.g_old_rec.irf_information6, hr_api.g_varchar2) <>
110: nvl(p_rec.irf_information6, hr_api.g_varchar2) or
111: nvl(irc_irf_shd.g_old_rec.irf_information7, hr_api.g_varchar2) <>
112: nvl(p_rec.irf_information7, hr_api.g_varchar2) or
113: nvl(irc_irf_shd.g_old_rec.irf_information8, hr_api.g_varchar2) <>
114: nvl(p_rec.irf_information8, hr_api.g_varchar2) or
115: nvl(irc_irf_shd.g_old_rec.irf_information9, hr_api.g_varchar2) <>
116: nvl(p_rec.irf_information9, hr_api.g_varchar2) or
117: nvl(irc_irf_shd.g_old_rec.irf_information10, hr_api.g_varchar2) <>

Line 114: nvl(p_rec.irf_information8, hr_api.g_varchar2) or

110: nvl(p_rec.irf_information6, hr_api.g_varchar2) or
111: nvl(irc_irf_shd.g_old_rec.irf_information7, hr_api.g_varchar2) <>
112: nvl(p_rec.irf_information7, hr_api.g_varchar2) or
113: nvl(irc_irf_shd.g_old_rec.irf_information8, hr_api.g_varchar2) <>
114: nvl(p_rec.irf_information8, hr_api.g_varchar2) or
115: nvl(irc_irf_shd.g_old_rec.irf_information9, hr_api.g_varchar2) <>
116: nvl(p_rec.irf_information9, hr_api.g_varchar2) or
117: nvl(irc_irf_shd.g_old_rec.irf_information10, hr_api.g_varchar2) <>
118: nvl(p_rec.irf_information10, hr_api.g_varchar2) ))

Line 115: nvl(irc_irf_shd.g_old_rec.irf_information9, hr_api.g_varchar2) <>

111: nvl(irc_irf_shd.g_old_rec.irf_information7, hr_api.g_varchar2) <>
112: nvl(p_rec.irf_information7, hr_api.g_varchar2) or
113: nvl(irc_irf_shd.g_old_rec.irf_information8, hr_api.g_varchar2) <>
114: nvl(p_rec.irf_information8, hr_api.g_varchar2) or
115: nvl(irc_irf_shd.g_old_rec.irf_information9, hr_api.g_varchar2) <>
116: nvl(p_rec.irf_information9, hr_api.g_varchar2) or
117: nvl(irc_irf_shd.g_old_rec.irf_information10, hr_api.g_varchar2) <>
118: nvl(p_rec.irf_information10, hr_api.g_varchar2) ))
119: or (p_rec.referral_info_id is null) then

Line 116: nvl(p_rec.irf_information9, hr_api.g_varchar2) or

112: nvl(p_rec.irf_information7, hr_api.g_varchar2) or
113: nvl(irc_irf_shd.g_old_rec.irf_information8, hr_api.g_varchar2) <>
114: nvl(p_rec.irf_information8, hr_api.g_varchar2) or
115: nvl(irc_irf_shd.g_old_rec.irf_information9, hr_api.g_varchar2) <>
116: nvl(p_rec.irf_information9, hr_api.g_varchar2) or
117: nvl(irc_irf_shd.g_old_rec.irf_information10, hr_api.g_varchar2) <>
118: nvl(p_rec.irf_information10, hr_api.g_varchar2) ))
119: or (p_rec.referral_info_id is null) then
120: --

Line 117: nvl(irc_irf_shd.g_old_rec.irf_information10, hr_api.g_varchar2) <>

113: nvl(irc_irf_shd.g_old_rec.irf_information8, hr_api.g_varchar2) <>
114: nvl(p_rec.irf_information8, hr_api.g_varchar2) or
115: nvl(irc_irf_shd.g_old_rec.irf_information9, hr_api.g_varchar2) <>
116: nvl(p_rec.irf_information9, hr_api.g_varchar2) or
117: nvl(irc_irf_shd.g_old_rec.irf_information10, hr_api.g_varchar2) <>
118: nvl(p_rec.irf_information10, hr_api.g_varchar2) ))
119: or (p_rec.referral_info_id is null) then
120: --
121: -- Only execute the validation if absolutely necessary:

Line 118: nvl(p_rec.irf_information10, hr_api.g_varchar2) ))

114: nvl(p_rec.irf_information8, hr_api.g_varchar2) or
115: nvl(irc_irf_shd.g_old_rec.irf_information9, hr_api.g_varchar2) <>
116: nvl(p_rec.irf_information9, hr_api.g_varchar2) or
117: nvl(irc_irf_shd.g_old_rec.irf_information10, hr_api.g_varchar2) <>
118: nvl(p_rec.irf_information10, hr_api.g_varchar2) ))
119: or (p_rec.referral_info_id is null) then
120: --
121: -- Only execute the validation if absolutely necessary:
122: -- a) During update, the structure column value or any

Line 194: nvl(irc_irf_shd.g_old_rec.irf_attribute_category, hr_api.g_varchar2) <>

190: begin
191: hr_utility.set_location('Entering:'||l_proc,10);
192: --
193: if ((p_rec.referral_info_id is not null) and (
194: nvl(irc_irf_shd.g_old_rec.irf_attribute_category, hr_api.g_varchar2) <>
195: nvl(p_rec.irf_attribute_category, hr_api.g_varchar2) or
196: nvl(irc_irf_shd.g_old_rec.irf_attribute1, hr_api.g_varchar2) <>
197: nvl(p_rec.irf_attribute1, hr_api.g_varchar2) or
198: nvl(irc_irf_shd.g_old_rec.irf_attribute2, hr_api.g_varchar2) <>

Line 195: nvl(p_rec.irf_attribute_category, hr_api.g_varchar2) or

191: hr_utility.set_location('Entering:'||l_proc,10);
192: --
193: if ((p_rec.referral_info_id is not null) and (
194: nvl(irc_irf_shd.g_old_rec.irf_attribute_category, hr_api.g_varchar2) <>
195: nvl(p_rec.irf_attribute_category, hr_api.g_varchar2) or
196: nvl(irc_irf_shd.g_old_rec.irf_attribute1, hr_api.g_varchar2) <>
197: nvl(p_rec.irf_attribute1, hr_api.g_varchar2) or
198: nvl(irc_irf_shd.g_old_rec.irf_attribute2, hr_api.g_varchar2) <>
199: nvl(p_rec.irf_attribute2, hr_api.g_varchar2) or

Line 196: nvl(irc_irf_shd.g_old_rec.irf_attribute1, hr_api.g_varchar2) <>

192: --
193: if ((p_rec.referral_info_id is not null) and (
194: nvl(irc_irf_shd.g_old_rec.irf_attribute_category, hr_api.g_varchar2) <>
195: nvl(p_rec.irf_attribute_category, hr_api.g_varchar2) or
196: nvl(irc_irf_shd.g_old_rec.irf_attribute1, hr_api.g_varchar2) <>
197: nvl(p_rec.irf_attribute1, hr_api.g_varchar2) or
198: nvl(irc_irf_shd.g_old_rec.irf_attribute2, hr_api.g_varchar2) <>
199: nvl(p_rec.irf_attribute2, hr_api.g_varchar2) or
200: nvl(irc_irf_shd.g_old_rec.irf_attribute3, hr_api.g_varchar2) <>

Line 197: nvl(p_rec.irf_attribute1, hr_api.g_varchar2) or

193: if ((p_rec.referral_info_id is not null) and (
194: nvl(irc_irf_shd.g_old_rec.irf_attribute_category, hr_api.g_varchar2) <>
195: nvl(p_rec.irf_attribute_category, hr_api.g_varchar2) or
196: nvl(irc_irf_shd.g_old_rec.irf_attribute1, hr_api.g_varchar2) <>
197: nvl(p_rec.irf_attribute1, hr_api.g_varchar2) or
198: nvl(irc_irf_shd.g_old_rec.irf_attribute2, hr_api.g_varchar2) <>
199: nvl(p_rec.irf_attribute2, hr_api.g_varchar2) or
200: nvl(irc_irf_shd.g_old_rec.irf_attribute3, hr_api.g_varchar2) <>
201: nvl(p_rec.irf_attribute3, hr_api.g_varchar2) or

Line 198: nvl(irc_irf_shd.g_old_rec.irf_attribute2, hr_api.g_varchar2) <>

194: nvl(irc_irf_shd.g_old_rec.irf_attribute_category, hr_api.g_varchar2) <>
195: nvl(p_rec.irf_attribute_category, hr_api.g_varchar2) or
196: nvl(irc_irf_shd.g_old_rec.irf_attribute1, hr_api.g_varchar2) <>
197: nvl(p_rec.irf_attribute1, hr_api.g_varchar2) or
198: nvl(irc_irf_shd.g_old_rec.irf_attribute2, hr_api.g_varchar2) <>
199: nvl(p_rec.irf_attribute2, hr_api.g_varchar2) or
200: nvl(irc_irf_shd.g_old_rec.irf_attribute3, hr_api.g_varchar2) <>
201: nvl(p_rec.irf_attribute3, hr_api.g_varchar2) or
202: nvl(irc_irf_shd.g_old_rec.irf_attribute4, hr_api.g_varchar2) <>

Line 199: nvl(p_rec.irf_attribute2, hr_api.g_varchar2) or

195: nvl(p_rec.irf_attribute_category, hr_api.g_varchar2) or
196: nvl(irc_irf_shd.g_old_rec.irf_attribute1, hr_api.g_varchar2) <>
197: nvl(p_rec.irf_attribute1, hr_api.g_varchar2) or
198: nvl(irc_irf_shd.g_old_rec.irf_attribute2, hr_api.g_varchar2) <>
199: nvl(p_rec.irf_attribute2, hr_api.g_varchar2) or
200: nvl(irc_irf_shd.g_old_rec.irf_attribute3, hr_api.g_varchar2) <>
201: nvl(p_rec.irf_attribute3, hr_api.g_varchar2) or
202: nvl(irc_irf_shd.g_old_rec.irf_attribute4, hr_api.g_varchar2) <>
203: nvl(p_rec.irf_attribute4, hr_api.g_varchar2) or

Line 200: nvl(irc_irf_shd.g_old_rec.irf_attribute3, hr_api.g_varchar2) <>

196: nvl(irc_irf_shd.g_old_rec.irf_attribute1, hr_api.g_varchar2) <>
197: nvl(p_rec.irf_attribute1, hr_api.g_varchar2) or
198: nvl(irc_irf_shd.g_old_rec.irf_attribute2, hr_api.g_varchar2) <>
199: nvl(p_rec.irf_attribute2, hr_api.g_varchar2) or
200: nvl(irc_irf_shd.g_old_rec.irf_attribute3, hr_api.g_varchar2) <>
201: nvl(p_rec.irf_attribute3, hr_api.g_varchar2) or
202: nvl(irc_irf_shd.g_old_rec.irf_attribute4, hr_api.g_varchar2) <>
203: nvl(p_rec.irf_attribute4, hr_api.g_varchar2) or
204: nvl(irc_irf_shd.g_old_rec.irf_attribute5, hr_api.g_varchar2) <>

Line 201: nvl(p_rec.irf_attribute3, hr_api.g_varchar2) or

197: nvl(p_rec.irf_attribute1, hr_api.g_varchar2) or
198: nvl(irc_irf_shd.g_old_rec.irf_attribute2, hr_api.g_varchar2) <>
199: nvl(p_rec.irf_attribute2, hr_api.g_varchar2) or
200: nvl(irc_irf_shd.g_old_rec.irf_attribute3, hr_api.g_varchar2) <>
201: nvl(p_rec.irf_attribute3, hr_api.g_varchar2) or
202: nvl(irc_irf_shd.g_old_rec.irf_attribute4, hr_api.g_varchar2) <>
203: nvl(p_rec.irf_attribute4, hr_api.g_varchar2) or
204: nvl(irc_irf_shd.g_old_rec.irf_attribute5, hr_api.g_varchar2) <>
205: nvl(p_rec.irf_attribute5, hr_api.g_varchar2) or

Line 202: nvl(irc_irf_shd.g_old_rec.irf_attribute4, hr_api.g_varchar2) <>

198: nvl(irc_irf_shd.g_old_rec.irf_attribute2, hr_api.g_varchar2) <>
199: nvl(p_rec.irf_attribute2, hr_api.g_varchar2) or
200: nvl(irc_irf_shd.g_old_rec.irf_attribute3, hr_api.g_varchar2) <>
201: nvl(p_rec.irf_attribute3, hr_api.g_varchar2) or
202: nvl(irc_irf_shd.g_old_rec.irf_attribute4, hr_api.g_varchar2) <>
203: nvl(p_rec.irf_attribute4, hr_api.g_varchar2) or
204: nvl(irc_irf_shd.g_old_rec.irf_attribute5, hr_api.g_varchar2) <>
205: nvl(p_rec.irf_attribute5, hr_api.g_varchar2) or
206: nvl(irc_irf_shd.g_old_rec.irf_attribute6, hr_api.g_varchar2) <>

Line 203: nvl(p_rec.irf_attribute4, hr_api.g_varchar2) or

199: nvl(p_rec.irf_attribute2, hr_api.g_varchar2) or
200: nvl(irc_irf_shd.g_old_rec.irf_attribute3, hr_api.g_varchar2) <>
201: nvl(p_rec.irf_attribute3, hr_api.g_varchar2) or
202: nvl(irc_irf_shd.g_old_rec.irf_attribute4, hr_api.g_varchar2) <>
203: nvl(p_rec.irf_attribute4, hr_api.g_varchar2) or
204: nvl(irc_irf_shd.g_old_rec.irf_attribute5, hr_api.g_varchar2) <>
205: nvl(p_rec.irf_attribute5, hr_api.g_varchar2) or
206: nvl(irc_irf_shd.g_old_rec.irf_attribute6, hr_api.g_varchar2) <>
207: nvl(p_rec.irf_attribute6, hr_api.g_varchar2) or

Line 204: nvl(irc_irf_shd.g_old_rec.irf_attribute5, hr_api.g_varchar2) <>

200: nvl(irc_irf_shd.g_old_rec.irf_attribute3, hr_api.g_varchar2) <>
201: nvl(p_rec.irf_attribute3, hr_api.g_varchar2) or
202: nvl(irc_irf_shd.g_old_rec.irf_attribute4, hr_api.g_varchar2) <>
203: nvl(p_rec.irf_attribute4, hr_api.g_varchar2) or
204: nvl(irc_irf_shd.g_old_rec.irf_attribute5, hr_api.g_varchar2) <>
205: nvl(p_rec.irf_attribute5, hr_api.g_varchar2) or
206: nvl(irc_irf_shd.g_old_rec.irf_attribute6, hr_api.g_varchar2) <>
207: nvl(p_rec.irf_attribute6, hr_api.g_varchar2) or
208: nvl(irc_irf_shd.g_old_rec.irf_attribute7, hr_api.g_varchar2) <>

Line 205: nvl(p_rec.irf_attribute5, hr_api.g_varchar2) or

201: nvl(p_rec.irf_attribute3, hr_api.g_varchar2) or
202: nvl(irc_irf_shd.g_old_rec.irf_attribute4, hr_api.g_varchar2) <>
203: nvl(p_rec.irf_attribute4, hr_api.g_varchar2) or
204: nvl(irc_irf_shd.g_old_rec.irf_attribute5, hr_api.g_varchar2) <>
205: nvl(p_rec.irf_attribute5, hr_api.g_varchar2) or
206: nvl(irc_irf_shd.g_old_rec.irf_attribute6, hr_api.g_varchar2) <>
207: nvl(p_rec.irf_attribute6, hr_api.g_varchar2) or
208: nvl(irc_irf_shd.g_old_rec.irf_attribute7, hr_api.g_varchar2) <>
209: nvl(p_rec.irf_attribute7, hr_api.g_varchar2) or

Line 206: nvl(irc_irf_shd.g_old_rec.irf_attribute6, hr_api.g_varchar2) <>

202: nvl(irc_irf_shd.g_old_rec.irf_attribute4, hr_api.g_varchar2) <>
203: nvl(p_rec.irf_attribute4, hr_api.g_varchar2) or
204: nvl(irc_irf_shd.g_old_rec.irf_attribute5, hr_api.g_varchar2) <>
205: nvl(p_rec.irf_attribute5, hr_api.g_varchar2) or
206: nvl(irc_irf_shd.g_old_rec.irf_attribute6, hr_api.g_varchar2) <>
207: nvl(p_rec.irf_attribute6, hr_api.g_varchar2) or
208: nvl(irc_irf_shd.g_old_rec.irf_attribute7, hr_api.g_varchar2) <>
209: nvl(p_rec.irf_attribute7, hr_api.g_varchar2) or
210: nvl(irc_irf_shd.g_old_rec.irf_attribute8, hr_api.g_varchar2) <>

Line 207: nvl(p_rec.irf_attribute6, hr_api.g_varchar2) or

203: nvl(p_rec.irf_attribute4, hr_api.g_varchar2) or
204: nvl(irc_irf_shd.g_old_rec.irf_attribute5, hr_api.g_varchar2) <>
205: nvl(p_rec.irf_attribute5, hr_api.g_varchar2) or
206: nvl(irc_irf_shd.g_old_rec.irf_attribute6, hr_api.g_varchar2) <>
207: nvl(p_rec.irf_attribute6, hr_api.g_varchar2) or
208: nvl(irc_irf_shd.g_old_rec.irf_attribute7, hr_api.g_varchar2) <>
209: nvl(p_rec.irf_attribute7, hr_api.g_varchar2) or
210: nvl(irc_irf_shd.g_old_rec.irf_attribute8, hr_api.g_varchar2) <>
211: nvl(p_rec.irf_attribute8, hr_api.g_varchar2) or

Line 208: nvl(irc_irf_shd.g_old_rec.irf_attribute7, hr_api.g_varchar2) <>

204: nvl(irc_irf_shd.g_old_rec.irf_attribute5, hr_api.g_varchar2) <>
205: nvl(p_rec.irf_attribute5, hr_api.g_varchar2) or
206: nvl(irc_irf_shd.g_old_rec.irf_attribute6, hr_api.g_varchar2) <>
207: nvl(p_rec.irf_attribute6, hr_api.g_varchar2) or
208: nvl(irc_irf_shd.g_old_rec.irf_attribute7, hr_api.g_varchar2) <>
209: nvl(p_rec.irf_attribute7, hr_api.g_varchar2) or
210: nvl(irc_irf_shd.g_old_rec.irf_attribute8, hr_api.g_varchar2) <>
211: nvl(p_rec.irf_attribute8, hr_api.g_varchar2) or
212: nvl(irc_irf_shd.g_old_rec.irf_attribute9, hr_api.g_varchar2) <>

Line 209: nvl(p_rec.irf_attribute7, hr_api.g_varchar2) or

205: nvl(p_rec.irf_attribute5, hr_api.g_varchar2) or
206: nvl(irc_irf_shd.g_old_rec.irf_attribute6, hr_api.g_varchar2) <>
207: nvl(p_rec.irf_attribute6, hr_api.g_varchar2) or
208: nvl(irc_irf_shd.g_old_rec.irf_attribute7, hr_api.g_varchar2) <>
209: nvl(p_rec.irf_attribute7, hr_api.g_varchar2) or
210: nvl(irc_irf_shd.g_old_rec.irf_attribute8, hr_api.g_varchar2) <>
211: nvl(p_rec.irf_attribute8, hr_api.g_varchar2) or
212: nvl(irc_irf_shd.g_old_rec.irf_attribute9, hr_api.g_varchar2) <>
213: nvl(p_rec.irf_attribute9, hr_api.g_varchar2) or

Line 210: nvl(irc_irf_shd.g_old_rec.irf_attribute8, hr_api.g_varchar2) <>

206: nvl(irc_irf_shd.g_old_rec.irf_attribute6, hr_api.g_varchar2) <>
207: nvl(p_rec.irf_attribute6, hr_api.g_varchar2) or
208: nvl(irc_irf_shd.g_old_rec.irf_attribute7, hr_api.g_varchar2) <>
209: nvl(p_rec.irf_attribute7, hr_api.g_varchar2) or
210: nvl(irc_irf_shd.g_old_rec.irf_attribute8, hr_api.g_varchar2) <>
211: nvl(p_rec.irf_attribute8, hr_api.g_varchar2) or
212: nvl(irc_irf_shd.g_old_rec.irf_attribute9, hr_api.g_varchar2) <>
213: nvl(p_rec.irf_attribute9, hr_api.g_varchar2) or
214: nvl(irc_irf_shd.g_old_rec.irf_attribute10, hr_api.g_varchar2) <>

Line 211: nvl(p_rec.irf_attribute8, hr_api.g_varchar2) or

207: nvl(p_rec.irf_attribute6, hr_api.g_varchar2) or
208: nvl(irc_irf_shd.g_old_rec.irf_attribute7, hr_api.g_varchar2) <>
209: nvl(p_rec.irf_attribute7, hr_api.g_varchar2) or
210: nvl(irc_irf_shd.g_old_rec.irf_attribute8, hr_api.g_varchar2) <>
211: nvl(p_rec.irf_attribute8, hr_api.g_varchar2) or
212: nvl(irc_irf_shd.g_old_rec.irf_attribute9, hr_api.g_varchar2) <>
213: nvl(p_rec.irf_attribute9, hr_api.g_varchar2) or
214: nvl(irc_irf_shd.g_old_rec.irf_attribute10, hr_api.g_varchar2) <>
215: nvl(p_rec.irf_attribute10, hr_api.g_varchar2) ))

Line 212: nvl(irc_irf_shd.g_old_rec.irf_attribute9, hr_api.g_varchar2) <>

208: nvl(irc_irf_shd.g_old_rec.irf_attribute7, hr_api.g_varchar2) <>
209: nvl(p_rec.irf_attribute7, hr_api.g_varchar2) or
210: nvl(irc_irf_shd.g_old_rec.irf_attribute8, hr_api.g_varchar2) <>
211: nvl(p_rec.irf_attribute8, hr_api.g_varchar2) or
212: nvl(irc_irf_shd.g_old_rec.irf_attribute9, hr_api.g_varchar2) <>
213: nvl(p_rec.irf_attribute9, hr_api.g_varchar2) or
214: nvl(irc_irf_shd.g_old_rec.irf_attribute10, hr_api.g_varchar2) <>
215: nvl(p_rec.irf_attribute10, hr_api.g_varchar2) ))
216: or (p_rec.referral_info_id is null) then

Line 213: nvl(p_rec.irf_attribute9, hr_api.g_varchar2) or

209: nvl(p_rec.irf_attribute7, hr_api.g_varchar2) or
210: nvl(irc_irf_shd.g_old_rec.irf_attribute8, hr_api.g_varchar2) <>
211: nvl(p_rec.irf_attribute8, hr_api.g_varchar2) or
212: nvl(irc_irf_shd.g_old_rec.irf_attribute9, hr_api.g_varchar2) <>
213: nvl(p_rec.irf_attribute9, hr_api.g_varchar2) or
214: nvl(irc_irf_shd.g_old_rec.irf_attribute10, hr_api.g_varchar2) <>
215: nvl(p_rec.irf_attribute10, hr_api.g_varchar2) ))
216: or (p_rec.referral_info_id is null) then
217: --

Line 214: nvl(irc_irf_shd.g_old_rec.irf_attribute10, hr_api.g_varchar2) <>

210: nvl(irc_irf_shd.g_old_rec.irf_attribute8, hr_api.g_varchar2) <>
211: nvl(p_rec.irf_attribute8, hr_api.g_varchar2) or
212: nvl(irc_irf_shd.g_old_rec.irf_attribute9, hr_api.g_varchar2) <>
213: nvl(p_rec.irf_attribute9, hr_api.g_varchar2) or
214: nvl(irc_irf_shd.g_old_rec.irf_attribute10, hr_api.g_varchar2) <>
215: nvl(p_rec.irf_attribute10, hr_api.g_varchar2) ))
216: or (p_rec.referral_info_id is null) then
217: --
218: -- Only execute the validation if absolutely necessary:

Line 215: nvl(p_rec.irf_attribute10, hr_api.g_varchar2) ))

211: nvl(p_rec.irf_attribute8, hr_api.g_varchar2) or
212: nvl(irc_irf_shd.g_old_rec.irf_attribute9, hr_api.g_varchar2) <>
213: nvl(p_rec.irf_attribute9, hr_api.g_varchar2) or
214: nvl(irc_irf_shd.g_old_rec.irf_attribute10, hr_api.g_varchar2) <>
215: nvl(p_rec.irf_attribute10, hr_api.g_varchar2) ))
216: or (p_rec.referral_info_id is null) then
217: --
218: -- Only execute the validation if absolutely necessary:
219: -- a) During update, the structure column value or any

Line 309: hr_api.argument_changed_error

305: -- Add checks to ensure non-updateable args have
306: -- not been updated.
307: --
308: if p_rec.object_id <> irc_irf_shd.g_old_rec.object_id then
309: hr_api.argument_changed_error
310: ( p_api_name => l_proc
311: ,p_argument => 'OBJECT_ID'
312: ,p_base_table => irc_irf_shd.g_tab_name
313: );

Line 317: hr_api.argument_changed_error

313: );
314: end if;
315: --
316: if p_rec.object_type <> irc_irf_shd.g_old_rec.object_type then
317: hr_api.argument_changed_error
318: ( p_api_name => l_proc
319: ,p_argument => 'OBJECT_TYPE'
320: ,p_base_table => irc_irf_shd.g_tab_name
321: );

Line 325: hr_api.argument_changed_error

321: );
322: end if;
323: --
324: if p_rec.object_created_by <> irc_irf_shd.g_old_rec.object_created_by then
325: hr_api.argument_changed_error
326: ( p_api_name => l_proc
327: ,p_argument => 'OBJECT_CREATED_BY'
328: ,p_base_table => irc_irf_shd.g_tab_name
329: );

Line 376: hr_api.mandatory_arg_error

372: Begin
373: --
374: -- Ensure that the p_datetrack_mode argument is not null
375: --
376: hr_api.mandatory_arg_error
377: (p_api_name => l_proc
378: ,p_argument => 'datetrack_mode'
379: ,p_argument_value => p_datetrack_mode
380: );

Line 386: hr_api.mandatory_arg_error

382: -- Mode will be valid, as this is checked at the start of the upd.
383: --
384: -- Ensure the arguments are not null
385: --
386: hr_api.mandatory_arg_error
387: (p_api_name => l_proc
388: ,p_argument => 'validation_start_date'
389: ,p_argument_value => p_validation_start_date
390: );

Line 392: /*hr_api.mandatory_arg_error

388: ,p_argument => 'validation_start_date'
389: ,p_argument_value => p_validation_start_date
390: );
391: --
392: /*hr_api.mandatory_arg_error
393: (p_api_name => l_proc
394: ,p_argument => 'validation_end_date'
395: ,p_argument_value => p_validation_end_date
396: );*/

Line 458: hr_api.mandatory_arg_error

454: Begin
455: --
456: -- Ensure that the p_datetrack_mode argument is not null
457: --
458: hr_api.mandatory_arg_error
459: (p_api_name => l_proc
460: ,p_argument => 'datetrack_mode'
461: ,p_argument_value => p_datetrack_mode
462: );

Line 467: If (p_datetrack_mode = hr_api.g_delete or

463: --
464: -- Only perform the validation if the datetrack mode is either
465: -- DELETE or ZAP
466: --
467: If (p_datetrack_mode = hr_api.g_delete or
468: p_datetrack_mode = hr_api.g_zap) then
469: --
470: --
471: -- Ensure the arguments are not null

Line 468: p_datetrack_mode = hr_api.g_zap) then

464: -- Only perform the validation if the datetrack mode is either
465: -- DELETE or ZAP
466: --
467: If (p_datetrack_mode = hr_api.g_delete or
468: p_datetrack_mode = hr_api.g_zap) then
469: --
470: --
471: -- Ensure the arguments are not null
472: --

Line 473: hr_api.mandatory_arg_error

469: --
470: --
471: -- Ensure the arguments are not null
472: --
473: hr_api.mandatory_arg_error
474: (p_api_name => l_proc
475: ,p_argument => 'validation_start_date'
476: ,p_argument_value => p_validation_start_date
477: );

Line 479: /*hr_api.mandatory_arg_error

475: ,p_argument => 'validation_start_date'
476: ,p_argument_value => p_validation_start_date
477: );
478: --
479: /*hr_api.mandatory_arg_error
480: (p_api_name => l_proc
481: ,p_argument => 'validation_end_date'
482: ,p_argument_value => p_validation_end_date
483: );*/

Line 485: hr_api.mandatory_arg_error

481: ,p_argument => 'validation_end_date'
482: ,p_argument_value => p_validation_end_date
483: );*/
484: --
485: hr_api.mandatory_arg_error
486: (p_api_name => l_proc
487: ,p_argument => 'referral_info_id'
488: ,p_argument_value => p_referral_info_id
489: );

Line 524: l_not_exists := hr_api.not_exists_in_hr_lookups

520: Begin
521: hr_utility.set_location('Entering:'||l_proc, 5);
522: --
523: if p_source_criteria is not null then
524: l_not_exists := hr_api.not_exists_in_hr_lookups
525: (p_effective_date
526: ,'IRC_REFERRAL_CRITERIA'
527: ,p_source_criteria
528: );

Line 555: l_not_exists := hr_api.not_exists_in_hr_lookups

551: Begin
552: hr_utility.set_location('Entering:'||l_proc, 5);
553: --
554: if p_source_type is not null then
555: l_not_exists := hr_api.not_exists_in_hr_lookups
556: (p_effective_date
557: ,'REC_TYPE'
558: ,p_source_type
559: );