APPS.PQP_AAT_BUS dependencies on HR_API

Line 44: hr_api.mandatory_arg_error

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

Line 67: hr_api.set_security_group_id

63: close csr_sec_grp;
64: --
65: -- Set the security_group_id in CLIENT_INFO
66: --
67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 104: hr_api.mandatory_arg_error

100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error
105: (p_api_name => l_proc
106: ,p_argument => 'assignment_attribute_id'
107: ,p_argument_value => p_assignment_attribute_id
108: );

Line 110: if ( nvl(pqp_aat_bus.g_assignment_attribute_id, hr_api.g_number)

106: ,p_argument => 'assignment_attribute_id'
107: ,p_argument_value => p_assignment_attribute_id
108: );
109: --
110: if ( nvl(pqp_aat_bus.g_assignment_attribute_id, hr_api.g_number)
111: = p_assignment_attribute_id) then
112: --
113: -- The legislation code has already been found with a previous
114: -- call to this function. Just return the value in the global

Line 186: nvl(pqp_aat_shd.g_old_rec.aat_information_category, hr_api.g_varchar2) <>

182: begin
183: hr_utility.set_location('Entering:'||l_proc,10);
184: --
185: if ((p_rec.assignment_attribute_id is not null) and (
186: nvl(pqp_aat_shd.g_old_rec.aat_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.aat_information_category, hr_api.g_varchar2) or
188: nvl(pqp_aat_shd.g_old_rec.aat_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.aat_information1, hr_api.g_varchar2) or
190: nvl(pqp_aat_shd.g_old_rec.aat_information2, hr_api.g_varchar2) <>

Line 187: nvl(p_rec.aat_information_category, hr_api.g_varchar2) or

183: hr_utility.set_location('Entering:'||l_proc,10);
184: --
185: if ((p_rec.assignment_attribute_id is not null) and (
186: nvl(pqp_aat_shd.g_old_rec.aat_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.aat_information_category, hr_api.g_varchar2) or
188: nvl(pqp_aat_shd.g_old_rec.aat_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.aat_information1, hr_api.g_varchar2) or
190: nvl(pqp_aat_shd.g_old_rec.aat_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.aat_information2, hr_api.g_varchar2) or

Line 188: nvl(pqp_aat_shd.g_old_rec.aat_information1, hr_api.g_varchar2) <>

184: --
185: if ((p_rec.assignment_attribute_id is not null) and (
186: nvl(pqp_aat_shd.g_old_rec.aat_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.aat_information_category, hr_api.g_varchar2) or
188: nvl(pqp_aat_shd.g_old_rec.aat_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.aat_information1, hr_api.g_varchar2) or
190: nvl(pqp_aat_shd.g_old_rec.aat_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.aat_information2, hr_api.g_varchar2) or
192: nvl(pqp_aat_shd.g_old_rec.aat_information3, hr_api.g_varchar2) <>

Line 189: nvl(p_rec.aat_information1, hr_api.g_varchar2) or

185: if ((p_rec.assignment_attribute_id is not null) and (
186: nvl(pqp_aat_shd.g_old_rec.aat_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.aat_information_category, hr_api.g_varchar2) or
188: nvl(pqp_aat_shd.g_old_rec.aat_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.aat_information1, hr_api.g_varchar2) or
190: nvl(pqp_aat_shd.g_old_rec.aat_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.aat_information2, hr_api.g_varchar2) or
192: nvl(pqp_aat_shd.g_old_rec.aat_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.aat_information3, hr_api.g_varchar2) or

Line 190: nvl(pqp_aat_shd.g_old_rec.aat_information2, hr_api.g_varchar2) <>

186: nvl(pqp_aat_shd.g_old_rec.aat_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.aat_information_category, hr_api.g_varchar2) or
188: nvl(pqp_aat_shd.g_old_rec.aat_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.aat_information1, hr_api.g_varchar2) or
190: nvl(pqp_aat_shd.g_old_rec.aat_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.aat_information2, hr_api.g_varchar2) or
192: nvl(pqp_aat_shd.g_old_rec.aat_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.aat_information3, hr_api.g_varchar2) or
194: nvl(pqp_aat_shd.g_old_rec.aat_information4, hr_api.g_varchar2) <>

Line 191: nvl(p_rec.aat_information2, hr_api.g_varchar2) or

187: nvl(p_rec.aat_information_category, hr_api.g_varchar2) or
188: nvl(pqp_aat_shd.g_old_rec.aat_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.aat_information1, hr_api.g_varchar2) or
190: nvl(pqp_aat_shd.g_old_rec.aat_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.aat_information2, hr_api.g_varchar2) or
192: nvl(pqp_aat_shd.g_old_rec.aat_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.aat_information3, hr_api.g_varchar2) or
194: nvl(pqp_aat_shd.g_old_rec.aat_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.aat_information4, hr_api.g_varchar2) or

Line 192: nvl(pqp_aat_shd.g_old_rec.aat_information3, hr_api.g_varchar2) <>

188: nvl(pqp_aat_shd.g_old_rec.aat_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.aat_information1, hr_api.g_varchar2) or
190: nvl(pqp_aat_shd.g_old_rec.aat_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.aat_information2, hr_api.g_varchar2) or
192: nvl(pqp_aat_shd.g_old_rec.aat_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.aat_information3, hr_api.g_varchar2) or
194: nvl(pqp_aat_shd.g_old_rec.aat_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.aat_information4, hr_api.g_varchar2) or
196: nvl(pqp_aat_shd.g_old_rec.aat_information5, hr_api.g_varchar2) <>

Line 193: nvl(p_rec.aat_information3, hr_api.g_varchar2) or

189: nvl(p_rec.aat_information1, hr_api.g_varchar2) or
190: nvl(pqp_aat_shd.g_old_rec.aat_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.aat_information2, hr_api.g_varchar2) or
192: nvl(pqp_aat_shd.g_old_rec.aat_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.aat_information3, hr_api.g_varchar2) or
194: nvl(pqp_aat_shd.g_old_rec.aat_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.aat_information4, hr_api.g_varchar2) or
196: nvl(pqp_aat_shd.g_old_rec.aat_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.aat_information5, hr_api.g_varchar2) or

Line 194: nvl(pqp_aat_shd.g_old_rec.aat_information4, hr_api.g_varchar2) <>

190: nvl(pqp_aat_shd.g_old_rec.aat_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.aat_information2, hr_api.g_varchar2) or
192: nvl(pqp_aat_shd.g_old_rec.aat_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.aat_information3, hr_api.g_varchar2) or
194: nvl(pqp_aat_shd.g_old_rec.aat_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.aat_information4, hr_api.g_varchar2) or
196: nvl(pqp_aat_shd.g_old_rec.aat_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.aat_information5, hr_api.g_varchar2) or
198: nvl(pqp_aat_shd.g_old_rec.aat_information6, hr_api.g_varchar2) <>

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

191: nvl(p_rec.aat_information2, hr_api.g_varchar2) or
192: nvl(pqp_aat_shd.g_old_rec.aat_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.aat_information3, hr_api.g_varchar2) or
194: nvl(pqp_aat_shd.g_old_rec.aat_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.aat_information4, hr_api.g_varchar2) or
196: nvl(pqp_aat_shd.g_old_rec.aat_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.aat_information5, hr_api.g_varchar2) or
198: nvl(pqp_aat_shd.g_old_rec.aat_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.aat_information6, hr_api.g_varchar2) or

Line 196: nvl(pqp_aat_shd.g_old_rec.aat_information5, hr_api.g_varchar2) <>

192: nvl(pqp_aat_shd.g_old_rec.aat_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.aat_information3, hr_api.g_varchar2) or
194: nvl(pqp_aat_shd.g_old_rec.aat_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.aat_information4, hr_api.g_varchar2) or
196: nvl(pqp_aat_shd.g_old_rec.aat_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.aat_information5, hr_api.g_varchar2) or
198: nvl(pqp_aat_shd.g_old_rec.aat_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.aat_information6, hr_api.g_varchar2) or
200: nvl(pqp_aat_shd.g_old_rec.aat_information7, hr_api.g_varchar2) <>

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

193: nvl(p_rec.aat_information3, hr_api.g_varchar2) or
194: nvl(pqp_aat_shd.g_old_rec.aat_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.aat_information4, hr_api.g_varchar2) or
196: nvl(pqp_aat_shd.g_old_rec.aat_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.aat_information5, hr_api.g_varchar2) or
198: nvl(pqp_aat_shd.g_old_rec.aat_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.aat_information6, hr_api.g_varchar2) or
200: nvl(pqp_aat_shd.g_old_rec.aat_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.aat_information7, hr_api.g_varchar2) or

Line 198: nvl(pqp_aat_shd.g_old_rec.aat_information6, hr_api.g_varchar2) <>

194: nvl(pqp_aat_shd.g_old_rec.aat_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.aat_information4, hr_api.g_varchar2) or
196: nvl(pqp_aat_shd.g_old_rec.aat_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.aat_information5, hr_api.g_varchar2) or
198: nvl(pqp_aat_shd.g_old_rec.aat_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.aat_information6, hr_api.g_varchar2) or
200: nvl(pqp_aat_shd.g_old_rec.aat_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.aat_information7, hr_api.g_varchar2) or
202: nvl(pqp_aat_shd.g_old_rec.aat_information8, hr_api.g_varchar2) <>

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

195: nvl(p_rec.aat_information4, hr_api.g_varchar2) or
196: nvl(pqp_aat_shd.g_old_rec.aat_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.aat_information5, hr_api.g_varchar2) or
198: nvl(pqp_aat_shd.g_old_rec.aat_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.aat_information6, hr_api.g_varchar2) or
200: nvl(pqp_aat_shd.g_old_rec.aat_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.aat_information7, hr_api.g_varchar2) or
202: nvl(pqp_aat_shd.g_old_rec.aat_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.aat_information8, hr_api.g_varchar2) or

Line 200: nvl(pqp_aat_shd.g_old_rec.aat_information7, hr_api.g_varchar2) <>

196: nvl(pqp_aat_shd.g_old_rec.aat_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.aat_information5, hr_api.g_varchar2) or
198: nvl(pqp_aat_shd.g_old_rec.aat_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.aat_information6, hr_api.g_varchar2) or
200: nvl(pqp_aat_shd.g_old_rec.aat_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.aat_information7, hr_api.g_varchar2) or
202: nvl(pqp_aat_shd.g_old_rec.aat_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.aat_information8, hr_api.g_varchar2) or
204: nvl(pqp_aat_shd.g_old_rec.aat_information9, hr_api.g_varchar2) <>

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

197: nvl(p_rec.aat_information5, hr_api.g_varchar2) or
198: nvl(pqp_aat_shd.g_old_rec.aat_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.aat_information6, hr_api.g_varchar2) or
200: nvl(pqp_aat_shd.g_old_rec.aat_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.aat_information7, hr_api.g_varchar2) or
202: nvl(pqp_aat_shd.g_old_rec.aat_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.aat_information8, hr_api.g_varchar2) or
204: nvl(pqp_aat_shd.g_old_rec.aat_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.aat_information9, hr_api.g_varchar2) or

Line 202: nvl(pqp_aat_shd.g_old_rec.aat_information8, hr_api.g_varchar2) <>

198: nvl(pqp_aat_shd.g_old_rec.aat_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.aat_information6, hr_api.g_varchar2) or
200: nvl(pqp_aat_shd.g_old_rec.aat_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.aat_information7, hr_api.g_varchar2) or
202: nvl(pqp_aat_shd.g_old_rec.aat_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.aat_information8, hr_api.g_varchar2) or
204: nvl(pqp_aat_shd.g_old_rec.aat_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.aat_information9, hr_api.g_varchar2) or
206: nvl(pqp_aat_shd.g_old_rec.aat_information10, hr_api.g_varchar2) <>

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

199: nvl(p_rec.aat_information6, hr_api.g_varchar2) or
200: nvl(pqp_aat_shd.g_old_rec.aat_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.aat_information7, hr_api.g_varchar2) or
202: nvl(pqp_aat_shd.g_old_rec.aat_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.aat_information8, hr_api.g_varchar2) or
204: nvl(pqp_aat_shd.g_old_rec.aat_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.aat_information9, hr_api.g_varchar2) or
206: nvl(pqp_aat_shd.g_old_rec.aat_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.aat_information10, hr_api.g_varchar2) or

Line 204: nvl(pqp_aat_shd.g_old_rec.aat_information9, hr_api.g_varchar2) <>

200: nvl(pqp_aat_shd.g_old_rec.aat_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.aat_information7, hr_api.g_varchar2) or
202: nvl(pqp_aat_shd.g_old_rec.aat_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.aat_information8, hr_api.g_varchar2) or
204: nvl(pqp_aat_shd.g_old_rec.aat_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.aat_information9, hr_api.g_varchar2) or
206: nvl(pqp_aat_shd.g_old_rec.aat_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.aat_information10, hr_api.g_varchar2) or
208: nvl(pqp_aat_shd.g_old_rec.aat_information11, hr_api.g_varchar2) <>

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

201: nvl(p_rec.aat_information7, hr_api.g_varchar2) or
202: nvl(pqp_aat_shd.g_old_rec.aat_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.aat_information8, hr_api.g_varchar2) or
204: nvl(pqp_aat_shd.g_old_rec.aat_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.aat_information9, hr_api.g_varchar2) or
206: nvl(pqp_aat_shd.g_old_rec.aat_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.aat_information10, hr_api.g_varchar2) or
208: nvl(pqp_aat_shd.g_old_rec.aat_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.aat_information11, hr_api.g_varchar2) or

Line 206: nvl(pqp_aat_shd.g_old_rec.aat_information10, hr_api.g_varchar2) <>

202: nvl(pqp_aat_shd.g_old_rec.aat_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.aat_information8, hr_api.g_varchar2) or
204: nvl(pqp_aat_shd.g_old_rec.aat_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.aat_information9, hr_api.g_varchar2) or
206: nvl(pqp_aat_shd.g_old_rec.aat_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.aat_information10, hr_api.g_varchar2) or
208: nvl(pqp_aat_shd.g_old_rec.aat_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.aat_information11, hr_api.g_varchar2) or
210: nvl(pqp_aat_shd.g_old_rec.aat_information12, hr_api.g_varchar2) <>

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

203: nvl(p_rec.aat_information8, hr_api.g_varchar2) or
204: nvl(pqp_aat_shd.g_old_rec.aat_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.aat_information9, hr_api.g_varchar2) or
206: nvl(pqp_aat_shd.g_old_rec.aat_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.aat_information10, hr_api.g_varchar2) or
208: nvl(pqp_aat_shd.g_old_rec.aat_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.aat_information11, hr_api.g_varchar2) or
210: nvl(pqp_aat_shd.g_old_rec.aat_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.aat_information12, hr_api.g_varchar2) or

Line 208: nvl(pqp_aat_shd.g_old_rec.aat_information11, hr_api.g_varchar2) <>

204: nvl(pqp_aat_shd.g_old_rec.aat_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.aat_information9, hr_api.g_varchar2) or
206: nvl(pqp_aat_shd.g_old_rec.aat_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.aat_information10, hr_api.g_varchar2) or
208: nvl(pqp_aat_shd.g_old_rec.aat_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.aat_information11, hr_api.g_varchar2) or
210: nvl(pqp_aat_shd.g_old_rec.aat_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.aat_information12, hr_api.g_varchar2) or
212: nvl(pqp_aat_shd.g_old_rec.aat_information13, hr_api.g_varchar2) <>

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

205: nvl(p_rec.aat_information9, hr_api.g_varchar2) or
206: nvl(pqp_aat_shd.g_old_rec.aat_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.aat_information10, hr_api.g_varchar2) or
208: nvl(pqp_aat_shd.g_old_rec.aat_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.aat_information11, hr_api.g_varchar2) or
210: nvl(pqp_aat_shd.g_old_rec.aat_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.aat_information12, hr_api.g_varchar2) or
212: nvl(pqp_aat_shd.g_old_rec.aat_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.aat_information13, hr_api.g_varchar2) or

Line 210: nvl(pqp_aat_shd.g_old_rec.aat_information12, hr_api.g_varchar2) <>

206: nvl(pqp_aat_shd.g_old_rec.aat_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.aat_information10, hr_api.g_varchar2) or
208: nvl(pqp_aat_shd.g_old_rec.aat_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.aat_information11, hr_api.g_varchar2) or
210: nvl(pqp_aat_shd.g_old_rec.aat_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.aat_information12, hr_api.g_varchar2) or
212: nvl(pqp_aat_shd.g_old_rec.aat_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.aat_information13, hr_api.g_varchar2) or
214: nvl(pqp_aat_shd.g_old_rec.aat_information14, hr_api.g_varchar2) <>

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

207: nvl(p_rec.aat_information10, hr_api.g_varchar2) or
208: nvl(pqp_aat_shd.g_old_rec.aat_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.aat_information11, hr_api.g_varchar2) or
210: nvl(pqp_aat_shd.g_old_rec.aat_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.aat_information12, hr_api.g_varchar2) or
212: nvl(pqp_aat_shd.g_old_rec.aat_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.aat_information13, hr_api.g_varchar2) or
214: nvl(pqp_aat_shd.g_old_rec.aat_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.aat_information14, hr_api.g_varchar2) or

Line 212: nvl(pqp_aat_shd.g_old_rec.aat_information13, hr_api.g_varchar2) <>

208: nvl(pqp_aat_shd.g_old_rec.aat_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.aat_information11, hr_api.g_varchar2) or
210: nvl(pqp_aat_shd.g_old_rec.aat_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.aat_information12, hr_api.g_varchar2) or
212: nvl(pqp_aat_shd.g_old_rec.aat_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.aat_information13, hr_api.g_varchar2) or
214: nvl(pqp_aat_shd.g_old_rec.aat_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.aat_information14, hr_api.g_varchar2) or
216: nvl(pqp_aat_shd.g_old_rec.aat_information15, hr_api.g_varchar2) <>

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

209: nvl(p_rec.aat_information11, hr_api.g_varchar2) or
210: nvl(pqp_aat_shd.g_old_rec.aat_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.aat_information12, hr_api.g_varchar2) or
212: nvl(pqp_aat_shd.g_old_rec.aat_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.aat_information13, hr_api.g_varchar2) or
214: nvl(pqp_aat_shd.g_old_rec.aat_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.aat_information14, hr_api.g_varchar2) or
216: nvl(pqp_aat_shd.g_old_rec.aat_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.aat_information15, hr_api.g_varchar2) or

Line 214: nvl(pqp_aat_shd.g_old_rec.aat_information14, hr_api.g_varchar2) <>

210: nvl(pqp_aat_shd.g_old_rec.aat_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.aat_information12, hr_api.g_varchar2) or
212: nvl(pqp_aat_shd.g_old_rec.aat_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.aat_information13, hr_api.g_varchar2) or
214: nvl(pqp_aat_shd.g_old_rec.aat_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.aat_information14, hr_api.g_varchar2) or
216: nvl(pqp_aat_shd.g_old_rec.aat_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.aat_information15, hr_api.g_varchar2) or
218: nvl(pqp_aat_shd.g_old_rec.aat_information16, hr_api.g_varchar2) <>

Line 215: nvl(p_rec.aat_information14, hr_api.g_varchar2) or

211: nvl(p_rec.aat_information12, hr_api.g_varchar2) or
212: nvl(pqp_aat_shd.g_old_rec.aat_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.aat_information13, hr_api.g_varchar2) or
214: nvl(pqp_aat_shd.g_old_rec.aat_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.aat_information14, hr_api.g_varchar2) or
216: nvl(pqp_aat_shd.g_old_rec.aat_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.aat_information15, hr_api.g_varchar2) or
218: nvl(pqp_aat_shd.g_old_rec.aat_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.aat_information16, hr_api.g_varchar2) or

Line 216: nvl(pqp_aat_shd.g_old_rec.aat_information15, hr_api.g_varchar2) <>

212: nvl(pqp_aat_shd.g_old_rec.aat_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.aat_information13, hr_api.g_varchar2) or
214: nvl(pqp_aat_shd.g_old_rec.aat_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.aat_information14, hr_api.g_varchar2) or
216: nvl(pqp_aat_shd.g_old_rec.aat_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.aat_information15, hr_api.g_varchar2) or
218: nvl(pqp_aat_shd.g_old_rec.aat_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.aat_information16, hr_api.g_varchar2) or
220: nvl(pqp_aat_shd.g_old_rec.aat_information17, hr_api.g_varchar2) <>

Line 217: nvl(p_rec.aat_information15, hr_api.g_varchar2) or

213: nvl(p_rec.aat_information13, hr_api.g_varchar2) or
214: nvl(pqp_aat_shd.g_old_rec.aat_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.aat_information14, hr_api.g_varchar2) or
216: nvl(pqp_aat_shd.g_old_rec.aat_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.aat_information15, hr_api.g_varchar2) or
218: nvl(pqp_aat_shd.g_old_rec.aat_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.aat_information16, hr_api.g_varchar2) or
220: nvl(pqp_aat_shd.g_old_rec.aat_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.aat_information17, hr_api.g_varchar2) or

Line 218: nvl(pqp_aat_shd.g_old_rec.aat_information16, hr_api.g_varchar2) <>

214: nvl(pqp_aat_shd.g_old_rec.aat_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.aat_information14, hr_api.g_varchar2) or
216: nvl(pqp_aat_shd.g_old_rec.aat_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.aat_information15, hr_api.g_varchar2) or
218: nvl(pqp_aat_shd.g_old_rec.aat_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.aat_information16, hr_api.g_varchar2) or
220: nvl(pqp_aat_shd.g_old_rec.aat_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.aat_information17, hr_api.g_varchar2) or
222: nvl(pqp_aat_shd.g_old_rec.aat_information18, hr_api.g_varchar2) <>

Line 219: nvl(p_rec.aat_information16, hr_api.g_varchar2) or

215: nvl(p_rec.aat_information14, hr_api.g_varchar2) or
216: nvl(pqp_aat_shd.g_old_rec.aat_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.aat_information15, hr_api.g_varchar2) or
218: nvl(pqp_aat_shd.g_old_rec.aat_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.aat_information16, hr_api.g_varchar2) or
220: nvl(pqp_aat_shd.g_old_rec.aat_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.aat_information17, hr_api.g_varchar2) or
222: nvl(pqp_aat_shd.g_old_rec.aat_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.aat_information18, hr_api.g_varchar2) or

Line 220: nvl(pqp_aat_shd.g_old_rec.aat_information17, hr_api.g_varchar2) <>

216: nvl(pqp_aat_shd.g_old_rec.aat_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.aat_information15, hr_api.g_varchar2) or
218: nvl(pqp_aat_shd.g_old_rec.aat_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.aat_information16, hr_api.g_varchar2) or
220: nvl(pqp_aat_shd.g_old_rec.aat_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.aat_information17, hr_api.g_varchar2) or
222: nvl(pqp_aat_shd.g_old_rec.aat_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.aat_information18, hr_api.g_varchar2) or
224: nvl(pqp_aat_shd.g_old_rec.aat_information19, hr_api.g_varchar2) <>

Line 221: nvl(p_rec.aat_information17, hr_api.g_varchar2) or

217: nvl(p_rec.aat_information15, hr_api.g_varchar2) or
218: nvl(pqp_aat_shd.g_old_rec.aat_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.aat_information16, hr_api.g_varchar2) or
220: nvl(pqp_aat_shd.g_old_rec.aat_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.aat_information17, hr_api.g_varchar2) or
222: nvl(pqp_aat_shd.g_old_rec.aat_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.aat_information18, hr_api.g_varchar2) or
224: nvl(pqp_aat_shd.g_old_rec.aat_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.aat_information19, hr_api.g_varchar2) or

Line 222: nvl(pqp_aat_shd.g_old_rec.aat_information18, hr_api.g_varchar2) <>

218: nvl(pqp_aat_shd.g_old_rec.aat_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.aat_information16, hr_api.g_varchar2) or
220: nvl(pqp_aat_shd.g_old_rec.aat_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.aat_information17, hr_api.g_varchar2) or
222: nvl(pqp_aat_shd.g_old_rec.aat_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.aat_information18, hr_api.g_varchar2) or
224: nvl(pqp_aat_shd.g_old_rec.aat_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.aat_information19, hr_api.g_varchar2) or
226: nvl(pqp_aat_shd.g_old_rec.aat_information20, hr_api.g_varchar2) <>

Line 223: nvl(p_rec.aat_information18, hr_api.g_varchar2) or

219: nvl(p_rec.aat_information16, hr_api.g_varchar2) or
220: nvl(pqp_aat_shd.g_old_rec.aat_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.aat_information17, hr_api.g_varchar2) or
222: nvl(pqp_aat_shd.g_old_rec.aat_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.aat_information18, hr_api.g_varchar2) or
224: nvl(pqp_aat_shd.g_old_rec.aat_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.aat_information19, hr_api.g_varchar2) or
226: nvl(pqp_aat_shd.g_old_rec.aat_information20, hr_api.g_varchar2) <>
227: nvl(p_rec.aat_information20, hr_api.g_varchar2) ))

Line 224: nvl(pqp_aat_shd.g_old_rec.aat_information19, hr_api.g_varchar2) <>

220: nvl(pqp_aat_shd.g_old_rec.aat_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.aat_information17, hr_api.g_varchar2) or
222: nvl(pqp_aat_shd.g_old_rec.aat_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.aat_information18, hr_api.g_varchar2) or
224: nvl(pqp_aat_shd.g_old_rec.aat_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.aat_information19, hr_api.g_varchar2) or
226: nvl(pqp_aat_shd.g_old_rec.aat_information20, hr_api.g_varchar2) <>
227: nvl(p_rec.aat_information20, hr_api.g_varchar2) ))
228: or (p_rec.assignment_attribute_id is null) then

Line 225: nvl(p_rec.aat_information19, hr_api.g_varchar2) or

221: nvl(p_rec.aat_information17, hr_api.g_varchar2) or
222: nvl(pqp_aat_shd.g_old_rec.aat_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.aat_information18, hr_api.g_varchar2) or
224: nvl(pqp_aat_shd.g_old_rec.aat_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.aat_information19, hr_api.g_varchar2) or
226: nvl(pqp_aat_shd.g_old_rec.aat_information20, hr_api.g_varchar2) <>
227: nvl(p_rec.aat_information20, hr_api.g_varchar2) ))
228: or (p_rec.assignment_attribute_id is null) then
229: --

Line 226: nvl(pqp_aat_shd.g_old_rec.aat_information20, hr_api.g_varchar2) <>

222: nvl(pqp_aat_shd.g_old_rec.aat_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.aat_information18, hr_api.g_varchar2) or
224: nvl(pqp_aat_shd.g_old_rec.aat_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.aat_information19, hr_api.g_varchar2) or
226: nvl(pqp_aat_shd.g_old_rec.aat_information20, hr_api.g_varchar2) <>
227: nvl(p_rec.aat_information20, hr_api.g_varchar2) ))
228: or (p_rec.assignment_attribute_id is null) then
229: --
230: -- Only execute the validation if absolutely necessary:

Line 227: nvl(p_rec.aat_information20, hr_api.g_varchar2) ))

223: nvl(p_rec.aat_information18, hr_api.g_varchar2) or
224: nvl(pqp_aat_shd.g_old_rec.aat_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.aat_information19, hr_api.g_varchar2) or
226: nvl(pqp_aat_shd.g_old_rec.aat_information20, hr_api.g_varchar2) <>
227: nvl(p_rec.aat_information20, hr_api.g_varchar2) ))
228: or (p_rec.assignment_attribute_id is null) then
229: --
230: -- Only execute the validation if absolutely necessary:
231: -- a) During update, the structure column value or any

Line 323: nvl(pqp_aat_shd.g_old_rec.assignment_attribute_id, hr_api.g_number) <>

319: begin
320: hr_utility.set_location('Entering:'||l_proc,10);
321: --
322: if ((p_rec.assignment_attribute_id is not null) and (
323: nvl(pqp_aat_shd.g_old_rec.assignment_attribute_id, hr_api.g_number) <>
324: nvl(p_rec.assignment_attribute_id, hr_api.g_number) or
325: nvl(pqp_aat_shd.g_old_rec.aat_attribute_category, hr_api.g_varchar2) <>
326: nvl(p_rec.aat_attribute_category, hr_api.g_varchar2) or
327: nvl(pqp_aat_shd.g_old_rec.aat_attribute1, hr_api.g_varchar2) <>

Line 324: nvl(p_rec.assignment_attribute_id, hr_api.g_number) or

320: hr_utility.set_location('Entering:'||l_proc,10);
321: --
322: if ((p_rec.assignment_attribute_id is not null) and (
323: nvl(pqp_aat_shd.g_old_rec.assignment_attribute_id, hr_api.g_number) <>
324: nvl(p_rec.assignment_attribute_id, hr_api.g_number) or
325: nvl(pqp_aat_shd.g_old_rec.aat_attribute_category, hr_api.g_varchar2) <>
326: nvl(p_rec.aat_attribute_category, hr_api.g_varchar2) or
327: nvl(pqp_aat_shd.g_old_rec.aat_attribute1, hr_api.g_varchar2) <>
328: nvl(p_rec.aat_attribute1, hr_api.g_varchar2) or

Line 325: nvl(pqp_aat_shd.g_old_rec.aat_attribute_category, hr_api.g_varchar2) <>

321: --
322: if ((p_rec.assignment_attribute_id is not null) and (
323: nvl(pqp_aat_shd.g_old_rec.assignment_attribute_id, hr_api.g_number) <>
324: nvl(p_rec.assignment_attribute_id, hr_api.g_number) or
325: nvl(pqp_aat_shd.g_old_rec.aat_attribute_category, hr_api.g_varchar2) <>
326: nvl(p_rec.aat_attribute_category, hr_api.g_varchar2) or
327: nvl(pqp_aat_shd.g_old_rec.aat_attribute1, hr_api.g_varchar2) <>
328: nvl(p_rec.aat_attribute1, hr_api.g_varchar2) or
329: nvl(pqp_aat_shd.g_old_rec.aat_attribute2, hr_api.g_varchar2) <>

Line 326: nvl(p_rec.aat_attribute_category, hr_api.g_varchar2) or

322: if ((p_rec.assignment_attribute_id is not null) and (
323: nvl(pqp_aat_shd.g_old_rec.assignment_attribute_id, hr_api.g_number) <>
324: nvl(p_rec.assignment_attribute_id, hr_api.g_number) or
325: nvl(pqp_aat_shd.g_old_rec.aat_attribute_category, hr_api.g_varchar2) <>
326: nvl(p_rec.aat_attribute_category, hr_api.g_varchar2) or
327: nvl(pqp_aat_shd.g_old_rec.aat_attribute1, hr_api.g_varchar2) <>
328: nvl(p_rec.aat_attribute1, hr_api.g_varchar2) or
329: nvl(pqp_aat_shd.g_old_rec.aat_attribute2, hr_api.g_varchar2) <>
330: nvl(p_rec.aat_attribute2, hr_api.g_varchar2) or

Line 327: nvl(pqp_aat_shd.g_old_rec.aat_attribute1, hr_api.g_varchar2) <>

323: nvl(pqp_aat_shd.g_old_rec.assignment_attribute_id, hr_api.g_number) <>
324: nvl(p_rec.assignment_attribute_id, hr_api.g_number) or
325: nvl(pqp_aat_shd.g_old_rec.aat_attribute_category, hr_api.g_varchar2) <>
326: nvl(p_rec.aat_attribute_category, hr_api.g_varchar2) or
327: nvl(pqp_aat_shd.g_old_rec.aat_attribute1, hr_api.g_varchar2) <>
328: nvl(p_rec.aat_attribute1, hr_api.g_varchar2) or
329: nvl(pqp_aat_shd.g_old_rec.aat_attribute2, hr_api.g_varchar2) <>
330: nvl(p_rec.aat_attribute2, hr_api.g_varchar2) or
331: nvl(pqp_aat_shd.g_old_rec.aat_attribute3, hr_api.g_varchar2) <>

Line 328: nvl(p_rec.aat_attribute1, hr_api.g_varchar2) or

324: nvl(p_rec.assignment_attribute_id, hr_api.g_number) or
325: nvl(pqp_aat_shd.g_old_rec.aat_attribute_category, hr_api.g_varchar2) <>
326: nvl(p_rec.aat_attribute_category, hr_api.g_varchar2) or
327: nvl(pqp_aat_shd.g_old_rec.aat_attribute1, hr_api.g_varchar2) <>
328: nvl(p_rec.aat_attribute1, hr_api.g_varchar2) or
329: nvl(pqp_aat_shd.g_old_rec.aat_attribute2, hr_api.g_varchar2) <>
330: nvl(p_rec.aat_attribute2, hr_api.g_varchar2) or
331: nvl(pqp_aat_shd.g_old_rec.aat_attribute3, hr_api.g_varchar2) <>
332: nvl(p_rec.aat_attribute3, hr_api.g_varchar2) or

Line 329: nvl(pqp_aat_shd.g_old_rec.aat_attribute2, hr_api.g_varchar2) <>

325: nvl(pqp_aat_shd.g_old_rec.aat_attribute_category, hr_api.g_varchar2) <>
326: nvl(p_rec.aat_attribute_category, hr_api.g_varchar2) or
327: nvl(pqp_aat_shd.g_old_rec.aat_attribute1, hr_api.g_varchar2) <>
328: nvl(p_rec.aat_attribute1, hr_api.g_varchar2) or
329: nvl(pqp_aat_shd.g_old_rec.aat_attribute2, hr_api.g_varchar2) <>
330: nvl(p_rec.aat_attribute2, hr_api.g_varchar2) or
331: nvl(pqp_aat_shd.g_old_rec.aat_attribute3, hr_api.g_varchar2) <>
332: nvl(p_rec.aat_attribute3, hr_api.g_varchar2) or
333: nvl(pqp_aat_shd.g_old_rec.aat_attribute4, hr_api.g_varchar2) <>

Line 330: nvl(p_rec.aat_attribute2, hr_api.g_varchar2) or

326: nvl(p_rec.aat_attribute_category, hr_api.g_varchar2) or
327: nvl(pqp_aat_shd.g_old_rec.aat_attribute1, hr_api.g_varchar2) <>
328: nvl(p_rec.aat_attribute1, hr_api.g_varchar2) or
329: nvl(pqp_aat_shd.g_old_rec.aat_attribute2, hr_api.g_varchar2) <>
330: nvl(p_rec.aat_attribute2, hr_api.g_varchar2) or
331: nvl(pqp_aat_shd.g_old_rec.aat_attribute3, hr_api.g_varchar2) <>
332: nvl(p_rec.aat_attribute3, hr_api.g_varchar2) or
333: nvl(pqp_aat_shd.g_old_rec.aat_attribute4, hr_api.g_varchar2) <>
334: nvl(p_rec.aat_attribute4, hr_api.g_varchar2) or

Line 331: nvl(pqp_aat_shd.g_old_rec.aat_attribute3, hr_api.g_varchar2) <>

327: nvl(pqp_aat_shd.g_old_rec.aat_attribute1, hr_api.g_varchar2) <>
328: nvl(p_rec.aat_attribute1, hr_api.g_varchar2) or
329: nvl(pqp_aat_shd.g_old_rec.aat_attribute2, hr_api.g_varchar2) <>
330: nvl(p_rec.aat_attribute2, hr_api.g_varchar2) or
331: nvl(pqp_aat_shd.g_old_rec.aat_attribute3, hr_api.g_varchar2) <>
332: nvl(p_rec.aat_attribute3, hr_api.g_varchar2) or
333: nvl(pqp_aat_shd.g_old_rec.aat_attribute4, hr_api.g_varchar2) <>
334: nvl(p_rec.aat_attribute4, hr_api.g_varchar2) or
335: nvl(pqp_aat_shd.g_old_rec.aat_attribute5, hr_api.g_varchar2) <>

Line 332: nvl(p_rec.aat_attribute3, hr_api.g_varchar2) or

328: nvl(p_rec.aat_attribute1, hr_api.g_varchar2) or
329: nvl(pqp_aat_shd.g_old_rec.aat_attribute2, hr_api.g_varchar2) <>
330: nvl(p_rec.aat_attribute2, hr_api.g_varchar2) or
331: nvl(pqp_aat_shd.g_old_rec.aat_attribute3, hr_api.g_varchar2) <>
332: nvl(p_rec.aat_attribute3, hr_api.g_varchar2) or
333: nvl(pqp_aat_shd.g_old_rec.aat_attribute4, hr_api.g_varchar2) <>
334: nvl(p_rec.aat_attribute4, hr_api.g_varchar2) or
335: nvl(pqp_aat_shd.g_old_rec.aat_attribute5, hr_api.g_varchar2) <>
336: nvl(p_rec.aat_attribute5, hr_api.g_varchar2) or

Line 333: nvl(pqp_aat_shd.g_old_rec.aat_attribute4, hr_api.g_varchar2) <>

329: nvl(pqp_aat_shd.g_old_rec.aat_attribute2, hr_api.g_varchar2) <>
330: nvl(p_rec.aat_attribute2, hr_api.g_varchar2) or
331: nvl(pqp_aat_shd.g_old_rec.aat_attribute3, hr_api.g_varchar2) <>
332: nvl(p_rec.aat_attribute3, hr_api.g_varchar2) or
333: nvl(pqp_aat_shd.g_old_rec.aat_attribute4, hr_api.g_varchar2) <>
334: nvl(p_rec.aat_attribute4, hr_api.g_varchar2) or
335: nvl(pqp_aat_shd.g_old_rec.aat_attribute5, hr_api.g_varchar2) <>
336: nvl(p_rec.aat_attribute5, hr_api.g_varchar2) or
337: nvl(pqp_aat_shd.g_old_rec.aat_attribute6, hr_api.g_varchar2) <>

Line 334: nvl(p_rec.aat_attribute4, hr_api.g_varchar2) or

330: nvl(p_rec.aat_attribute2, hr_api.g_varchar2) or
331: nvl(pqp_aat_shd.g_old_rec.aat_attribute3, hr_api.g_varchar2) <>
332: nvl(p_rec.aat_attribute3, hr_api.g_varchar2) or
333: nvl(pqp_aat_shd.g_old_rec.aat_attribute4, hr_api.g_varchar2) <>
334: nvl(p_rec.aat_attribute4, hr_api.g_varchar2) or
335: nvl(pqp_aat_shd.g_old_rec.aat_attribute5, hr_api.g_varchar2) <>
336: nvl(p_rec.aat_attribute5, hr_api.g_varchar2) or
337: nvl(pqp_aat_shd.g_old_rec.aat_attribute6, hr_api.g_varchar2) <>
338: nvl(p_rec.aat_attribute6, hr_api.g_varchar2) or

Line 335: nvl(pqp_aat_shd.g_old_rec.aat_attribute5, hr_api.g_varchar2) <>

331: nvl(pqp_aat_shd.g_old_rec.aat_attribute3, hr_api.g_varchar2) <>
332: nvl(p_rec.aat_attribute3, hr_api.g_varchar2) or
333: nvl(pqp_aat_shd.g_old_rec.aat_attribute4, hr_api.g_varchar2) <>
334: nvl(p_rec.aat_attribute4, hr_api.g_varchar2) or
335: nvl(pqp_aat_shd.g_old_rec.aat_attribute5, hr_api.g_varchar2) <>
336: nvl(p_rec.aat_attribute5, hr_api.g_varchar2) or
337: nvl(pqp_aat_shd.g_old_rec.aat_attribute6, hr_api.g_varchar2) <>
338: nvl(p_rec.aat_attribute6, hr_api.g_varchar2) or
339: nvl(pqp_aat_shd.g_old_rec.aat_attribute7, hr_api.g_varchar2) <>

Line 336: nvl(p_rec.aat_attribute5, hr_api.g_varchar2) or

332: nvl(p_rec.aat_attribute3, hr_api.g_varchar2) or
333: nvl(pqp_aat_shd.g_old_rec.aat_attribute4, hr_api.g_varchar2) <>
334: nvl(p_rec.aat_attribute4, hr_api.g_varchar2) or
335: nvl(pqp_aat_shd.g_old_rec.aat_attribute5, hr_api.g_varchar2) <>
336: nvl(p_rec.aat_attribute5, hr_api.g_varchar2) or
337: nvl(pqp_aat_shd.g_old_rec.aat_attribute6, hr_api.g_varchar2) <>
338: nvl(p_rec.aat_attribute6, hr_api.g_varchar2) or
339: nvl(pqp_aat_shd.g_old_rec.aat_attribute7, hr_api.g_varchar2) <>
340: nvl(p_rec.aat_attribute7, hr_api.g_varchar2) or

Line 337: nvl(pqp_aat_shd.g_old_rec.aat_attribute6, hr_api.g_varchar2) <>

333: nvl(pqp_aat_shd.g_old_rec.aat_attribute4, hr_api.g_varchar2) <>
334: nvl(p_rec.aat_attribute4, hr_api.g_varchar2) or
335: nvl(pqp_aat_shd.g_old_rec.aat_attribute5, hr_api.g_varchar2) <>
336: nvl(p_rec.aat_attribute5, hr_api.g_varchar2) or
337: nvl(pqp_aat_shd.g_old_rec.aat_attribute6, hr_api.g_varchar2) <>
338: nvl(p_rec.aat_attribute6, hr_api.g_varchar2) or
339: nvl(pqp_aat_shd.g_old_rec.aat_attribute7, hr_api.g_varchar2) <>
340: nvl(p_rec.aat_attribute7, hr_api.g_varchar2) or
341: nvl(pqp_aat_shd.g_old_rec.aat_attribute8, hr_api.g_varchar2) <>

Line 338: nvl(p_rec.aat_attribute6, hr_api.g_varchar2) or

334: nvl(p_rec.aat_attribute4, hr_api.g_varchar2) or
335: nvl(pqp_aat_shd.g_old_rec.aat_attribute5, hr_api.g_varchar2) <>
336: nvl(p_rec.aat_attribute5, hr_api.g_varchar2) or
337: nvl(pqp_aat_shd.g_old_rec.aat_attribute6, hr_api.g_varchar2) <>
338: nvl(p_rec.aat_attribute6, hr_api.g_varchar2) or
339: nvl(pqp_aat_shd.g_old_rec.aat_attribute7, hr_api.g_varchar2) <>
340: nvl(p_rec.aat_attribute7, hr_api.g_varchar2) or
341: nvl(pqp_aat_shd.g_old_rec.aat_attribute8, hr_api.g_varchar2) <>
342: nvl(p_rec.aat_attribute8, hr_api.g_varchar2) or

Line 339: nvl(pqp_aat_shd.g_old_rec.aat_attribute7, hr_api.g_varchar2) <>

335: nvl(pqp_aat_shd.g_old_rec.aat_attribute5, hr_api.g_varchar2) <>
336: nvl(p_rec.aat_attribute5, hr_api.g_varchar2) or
337: nvl(pqp_aat_shd.g_old_rec.aat_attribute6, hr_api.g_varchar2) <>
338: nvl(p_rec.aat_attribute6, hr_api.g_varchar2) or
339: nvl(pqp_aat_shd.g_old_rec.aat_attribute7, hr_api.g_varchar2) <>
340: nvl(p_rec.aat_attribute7, hr_api.g_varchar2) or
341: nvl(pqp_aat_shd.g_old_rec.aat_attribute8, hr_api.g_varchar2) <>
342: nvl(p_rec.aat_attribute8, hr_api.g_varchar2) or
343: nvl(pqp_aat_shd.g_old_rec.aat_attribute9, hr_api.g_varchar2) <>

Line 340: nvl(p_rec.aat_attribute7, hr_api.g_varchar2) or

336: nvl(p_rec.aat_attribute5, hr_api.g_varchar2) or
337: nvl(pqp_aat_shd.g_old_rec.aat_attribute6, hr_api.g_varchar2) <>
338: nvl(p_rec.aat_attribute6, hr_api.g_varchar2) or
339: nvl(pqp_aat_shd.g_old_rec.aat_attribute7, hr_api.g_varchar2) <>
340: nvl(p_rec.aat_attribute7, hr_api.g_varchar2) or
341: nvl(pqp_aat_shd.g_old_rec.aat_attribute8, hr_api.g_varchar2) <>
342: nvl(p_rec.aat_attribute8, hr_api.g_varchar2) or
343: nvl(pqp_aat_shd.g_old_rec.aat_attribute9, hr_api.g_varchar2) <>
344: nvl(p_rec.aat_attribute9, hr_api.g_varchar2) or

Line 341: nvl(pqp_aat_shd.g_old_rec.aat_attribute8, hr_api.g_varchar2) <>

337: nvl(pqp_aat_shd.g_old_rec.aat_attribute6, hr_api.g_varchar2) <>
338: nvl(p_rec.aat_attribute6, hr_api.g_varchar2) or
339: nvl(pqp_aat_shd.g_old_rec.aat_attribute7, hr_api.g_varchar2) <>
340: nvl(p_rec.aat_attribute7, hr_api.g_varchar2) or
341: nvl(pqp_aat_shd.g_old_rec.aat_attribute8, hr_api.g_varchar2) <>
342: nvl(p_rec.aat_attribute8, hr_api.g_varchar2) or
343: nvl(pqp_aat_shd.g_old_rec.aat_attribute9, hr_api.g_varchar2) <>
344: nvl(p_rec.aat_attribute9, hr_api.g_varchar2) or
345: nvl(pqp_aat_shd.g_old_rec.aat_attribute10, hr_api.g_varchar2) <>

Line 342: nvl(p_rec.aat_attribute8, hr_api.g_varchar2) or

338: nvl(p_rec.aat_attribute6, hr_api.g_varchar2) or
339: nvl(pqp_aat_shd.g_old_rec.aat_attribute7, hr_api.g_varchar2) <>
340: nvl(p_rec.aat_attribute7, hr_api.g_varchar2) or
341: nvl(pqp_aat_shd.g_old_rec.aat_attribute8, hr_api.g_varchar2) <>
342: nvl(p_rec.aat_attribute8, hr_api.g_varchar2) or
343: nvl(pqp_aat_shd.g_old_rec.aat_attribute9, hr_api.g_varchar2) <>
344: nvl(p_rec.aat_attribute9, hr_api.g_varchar2) or
345: nvl(pqp_aat_shd.g_old_rec.aat_attribute10, hr_api.g_varchar2) <>
346: nvl(p_rec.aat_attribute10, hr_api.g_varchar2) or

Line 343: nvl(pqp_aat_shd.g_old_rec.aat_attribute9, hr_api.g_varchar2) <>

339: nvl(pqp_aat_shd.g_old_rec.aat_attribute7, hr_api.g_varchar2) <>
340: nvl(p_rec.aat_attribute7, hr_api.g_varchar2) or
341: nvl(pqp_aat_shd.g_old_rec.aat_attribute8, hr_api.g_varchar2) <>
342: nvl(p_rec.aat_attribute8, hr_api.g_varchar2) or
343: nvl(pqp_aat_shd.g_old_rec.aat_attribute9, hr_api.g_varchar2) <>
344: nvl(p_rec.aat_attribute9, hr_api.g_varchar2) or
345: nvl(pqp_aat_shd.g_old_rec.aat_attribute10, hr_api.g_varchar2) <>
346: nvl(p_rec.aat_attribute10, hr_api.g_varchar2) or
347: nvl(pqp_aat_shd.g_old_rec.aat_attribute11, hr_api.g_varchar2) <>

Line 344: nvl(p_rec.aat_attribute9, hr_api.g_varchar2) or

340: nvl(p_rec.aat_attribute7, hr_api.g_varchar2) or
341: nvl(pqp_aat_shd.g_old_rec.aat_attribute8, hr_api.g_varchar2) <>
342: nvl(p_rec.aat_attribute8, hr_api.g_varchar2) or
343: nvl(pqp_aat_shd.g_old_rec.aat_attribute9, hr_api.g_varchar2) <>
344: nvl(p_rec.aat_attribute9, hr_api.g_varchar2) or
345: nvl(pqp_aat_shd.g_old_rec.aat_attribute10, hr_api.g_varchar2) <>
346: nvl(p_rec.aat_attribute10, hr_api.g_varchar2) or
347: nvl(pqp_aat_shd.g_old_rec.aat_attribute11, hr_api.g_varchar2) <>
348: nvl(p_rec.aat_attribute11, hr_api.g_varchar2) or

Line 345: nvl(pqp_aat_shd.g_old_rec.aat_attribute10, hr_api.g_varchar2) <>

341: nvl(pqp_aat_shd.g_old_rec.aat_attribute8, hr_api.g_varchar2) <>
342: nvl(p_rec.aat_attribute8, hr_api.g_varchar2) or
343: nvl(pqp_aat_shd.g_old_rec.aat_attribute9, hr_api.g_varchar2) <>
344: nvl(p_rec.aat_attribute9, hr_api.g_varchar2) or
345: nvl(pqp_aat_shd.g_old_rec.aat_attribute10, hr_api.g_varchar2) <>
346: nvl(p_rec.aat_attribute10, hr_api.g_varchar2) or
347: nvl(pqp_aat_shd.g_old_rec.aat_attribute11, hr_api.g_varchar2) <>
348: nvl(p_rec.aat_attribute11, hr_api.g_varchar2) or
349: nvl(pqp_aat_shd.g_old_rec.aat_attribute12, hr_api.g_varchar2) <>

Line 346: nvl(p_rec.aat_attribute10, hr_api.g_varchar2) or

342: nvl(p_rec.aat_attribute8, hr_api.g_varchar2) or
343: nvl(pqp_aat_shd.g_old_rec.aat_attribute9, hr_api.g_varchar2) <>
344: nvl(p_rec.aat_attribute9, hr_api.g_varchar2) or
345: nvl(pqp_aat_shd.g_old_rec.aat_attribute10, hr_api.g_varchar2) <>
346: nvl(p_rec.aat_attribute10, hr_api.g_varchar2) or
347: nvl(pqp_aat_shd.g_old_rec.aat_attribute11, hr_api.g_varchar2) <>
348: nvl(p_rec.aat_attribute11, hr_api.g_varchar2) or
349: nvl(pqp_aat_shd.g_old_rec.aat_attribute12, hr_api.g_varchar2) <>
350: nvl(p_rec.aat_attribute12, hr_api.g_varchar2) or

Line 347: nvl(pqp_aat_shd.g_old_rec.aat_attribute11, hr_api.g_varchar2) <>

343: nvl(pqp_aat_shd.g_old_rec.aat_attribute9, hr_api.g_varchar2) <>
344: nvl(p_rec.aat_attribute9, hr_api.g_varchar2) or
345: nvl(pqp_aat_shd.g_old_rec.aat_attribute10, hr_api.g_varchar2) <>
346: nvl(p_rec.aat_attribute10, hr_api.g_varchar2) or
347: nvl(pqp_aat_shd.g_old_rec.aat_attribute11, hr_api.g_varchar2) <>
348: nvl(p_rec.aat_attribute11, hr_api.g_varchar2) or
349: nvl(pqp_aat_shd.g_old_rec.aat_attribute12, hr_api.g_varchar2) <>
350: nvl(p_rec.aat_attribute12, hr_api.g_varchar2) or
351: nvl(pqp_aat_shd.g_old_rec.aat_attribute13, hr_api.g_varchar2) <>

Line 348: nvl(p_rec.aat_attribute11, hr_api.g_varchar2) or

344: nvl(p_rec.aat_attribute9, hr_api.g_varchar2) or
345: nvl(pqp_aat_shd.g_old_rec.aat_attribute10, hr_api.g_varchar2) <>
346: nvl(p_rec.aat_attribute10, hr_api.g_varchar2) or
347: nvl(pqp_aat_shd.g_old_rec.aat_attribute11, hr_api.g_varchar2) <>
348: nvl(p_rec.aat_attribute11, hr_api.g_varchar2) or
349: nvl(pqp_aat_shd.g_old_rec.aat_attribute12, hr_api.g_varchar2) <>
350: nvl(p_rec.aat_attribute12, hr_api.g_varchar2) or
351: nvl(pqp_aat_shd.g_old_rec.aat_attribute13, hr_api.g_varchar2) <>
352: nvl(p_rec.aat_attribute13, hr_api.g_varchar2) or

Line 349: nvl(pqp_aat_shd.g_old_rec.aat_attribute12, hr_api.g_varchar2) <>

345: nvl(pqp_aat_shd.g_old_rec.aat_attribute10, hr_api.g_varchar2) <>
346: nvl(p_rec.aat_attribute10, hr_api.g_varchar2) or
347: nvl(pqp_aat_shd.g_old_rec.aat_attribute11, hr_api.g_varchar2) <>
348: nvl(p_rec.aat_attribute11, hr_api.g_varchar2) or
349: nvl(pqp_aat_shd.g_old_rec.aat_attribute12, hr_api.g_varchar2) <>
350: nvl(p_rec.aat_attribute12, hr_api.g_varchar2) or
351: nvl(pqp_aat_shd.g_old_rec.aat_attribute13, hr_api.g_varchar2) <>
352: nvl(p_rec.aat_attribute13, hr_api.g_varchar2) or
353: nvl(pqp_aat_shd.g_old_rec.aat_attribute14, hr_api.g_varchar2) <>

Line 350: nvl(p_rec.aat_attribute12, hr_api.g_varchar2) or

346: nvl(p_rec.aat_attribute10, hr_api.g_varchar2) or
347: nvl(pqp_aat_shd.g_old_rec.aat_attribute11, hr_api.g_varchar2) <>
348: nvl(p_rec.aat_attribute11, hr_api.g_varchar2) or
349: nvl(pqp_aat_shd.g_old_rec.aat_attribute12, hr_api.g_varchar2) <>
350: nvl(p_rec.aat_attribute12, hr_api.g_varchar2) or
351: nvl(pqp_aat_shd.g_old_rec.aat_attribute13, hr_api.g_varchar2) <>
352: nvl(p_rec.aat_attribute13, hr_api.g_varchar2) or
353: nvl(pqp_aat_shd.g_old_rec.aat_attribute14, hr_api.g_varchar2) <>
354: nvl(p_rec.aat_attribute14, hr_api.g_varchar2) or

Line 351: nvl(pqp_aat_shd.g_old_rec.aat_attribute13, hr_api.g_varchar2) <>

347: nvl(pqp_aat_shd.g_old_rec.aat_attribute11, hr_api.g_varchar2) <>
348: nvl(p_rec.aat_attribute11, hr_api.g_varchar2) or
349: nvl(pqp_aat_shd.g_old_rec.aat_attribute12, hr_api.g_varchar2) <>
350: nvl(p_rec.aat_attribute12, hr_api.g_varchar2) or
351: nvl(pqp_aat_shd.g_old_rec.aat_attribute13, hr_api.g_varchar2) <>
352: nvl(p_rec.aat_attribute13, hr_api.g_varchar2) or
353: nvl(pqp_aat_shd.g_old_rec.aat_attribute14, hr_api.g_varchar2) <>
354: nvl(p_rec.aat_attribute14, hr_api.g_varchar2) or
355: nvl(pqp_aat_shd.g_old_rec.aat_attribute15, hr_api.g_varchar2) <>

Line 352: nvl(p_rec.aat_attribute13, hr_api.g_varchar2) or

348: nvl(p_rec.aat_attribute11, hr_api.g_varchar2) or
349: nvl(pqp_aat_shd.g_old_rec.aat_attribute12, hr_api.g_varchar2) <>
350: nvl(p_rec.aat_attribute12, hr_api.g_varchar2) or
351: nvl(pqp_aat_shd.g_old_rec.aat_attribute13, hr_api.g_varchar2) <>
352: nvl(p_rec.aat_attribute13, hr_api.g_varchar2) or
353: nvl(pqp_aat_shd.g_old_rec.aat_attribute14, hr_api.g_varchar2) <>
354: nvl(p_rec.aat_attribute14, hr_api.g_varchar2) or
355: nvl(pqp_aat_shd.g_old_rec.aat_attribute15, hr_api.g_varchar2) <>
356: nvl(p_rec.aat_attribute15, hr_api.g_varchar2) or

Line 353: nvl(pqp_aat_shd.g_old_rec.aat_attribute14, hr_api.g_varchar2) <>

349: nvl(pqp_aat_shd.g_old_rec.aat_attribute12, hr_api.g_varchar2) <>
350: nvl(p_rec.aat_attribute12, hr_api.g_varchar2) or
351: nvl(pqp_aat_shd.g_old_rec.aat_attribute13, hr_api.g_varchar2) <>
352: nvl(p_rec.aat_attribute13, hr_api.g_varchar2) or
353: nvl(pqp_aat_shd.g_old_rec.aat_attribute14, hr_api.g_varchar2) <>
354: nvl(p_rec.aat_attribute14, hr_api.g_varchar2) or
355: nvl(pqp_aat_shd.g_old_rec.aat_attribute15, hr_api.g_varchar2) <>
356: nvl(p_rec.aat_attribute15, hr_api.g_varchar2) or
357: nvl(pqp_aat_shd.g_old_rec.aat_attribute16, hr_api.g_varchar2) <>

Line 354: nvl(p_rec.aat_attribute14, hr_api.g_varchar2) or

350: nvl(p_rec.aat_attribute12, hr_api.g_varchar2) or
351: nvl(pqp_aat_shd.g_old_rec.aat_attribute13, hr_api.g_varchar2) <>
352: nvl(p_rec.aat_attribute13, hr_api.g_varchar2) or
353: nvl(pqp_aat_shd.g_old_rec.aat_attribute14, hr_api.g_varchar2) <>
354: nvl(p_rec.aat_attribute14, hr_api.g_varchar2) or
355: nvl(pqp_aat_shd.g_old_rec.aat_attribute15, hr_api.g_varchar2) <>
356: nvl(p_rec.aat_attribute15, hr_api.g_varchar2) or
357: nvl(pqp_aat_shd.g_old_rec.aat_attribute16, hr_api.g_varchar2) <>
358: nvl(p_rec.aat_attribute16, hr_api.g_varchar2) or

Line 355: nvl(pqp_aat_shd.g_old_rec.aat_attribute15, hr_api.g_varchar2) <>

351: nvl(pqp_aat_shd.g_old_rec.aat_attribute13, hr_api.g_varchar2) <>
352: nvl(p_rec.aat_attribute13, hr_api.g_varchar2) or
353: nvl(pqp_aat_shd.g_old_rec.aat_attribute14, hr_api.g_varchar2) <>
354: nvl(p_rec.aat_attribute14, hr_api.g_varchar2) or
355: nvl(pqp_aat_shd.g_old_rec.aat_attribute15, hr_api.g_varchar2) <>
356: nvl(p_rec.aat_attribute15, hr_api.g_varchar2) or
357: nvl(pqp_aat_shd.g_old_rec.aat_attribute16, hr_api.g_varchar2) <>
358: nvl(p_rec.aat_attribute16, hr_api.g_varchar2) or
359: nvl(pqp_aat_shd.g_old_rec.aat_attribute17, hr_api.g_varchar2) <>

Line 356: nvl(p_rec.aat_attribute15, hr_api.g_varchar2) or

352: nvl(p_rec.aat_attribute13, hr_api.g_varchar2) or
353: nvl(pqp_aat_shd.g_old_rec.aat_attribute14, hr_api.g_varchar2) <>
354: nvl(p_rec.aat_attribute14, hr_api.g_varchar2) or
355: nvl(pqp_aat_shd.g_old_rec.aat_attribute15, hr_api.g_varchar2) <>
356: nvl(p_rec.aat_attribute15, hr_api.g_varchar2) or
357: nvl(pqp_aat_shd.g_old_rec.aat_attribute16, hr_api.g_varchar2) <>
358: nvl(p_rec.aat_attribute16, hr_api.g_varchar2) or
359: nvl(pqp_aat_shd.g_old_rec.aat_attribute17, hr_api.g_varchar2) <>
360: nvl(p_rec.aat_attribute17, hr_api.g_varchar2) or

Line 357: nvl(pqp_aat_shd.g_old_rec.aat_attribute16, hr_api.g_varchar2) <>

353: nvl(pqp_aat_shd.g_old_rec.aat_attribute14, hr_api.g_varchar2) <>
354: nvl(p_rec.aat_attribute14, hr_api.g_varchar2) or
355: nvl(pqp_aat_shd.g_old_rec.aat_attribute15, hr_api.g_varchar2) <>
356: nvl(p_rec.aat_attribute15, hr_api.g_varchar2) or
357: nvl(pqp_aat_shd.g_old_rec.aat_attribute16, hr_api.g_varchar2) <>
358: nvl(p_rec.aat_attribute16, hr_api.g_varchar2) or
359: nvl(pqp_aat_shd.g_old_rec.aat_attribute17, hr_api.g_varchar2) <>
360: nvl(p_rec.aat_attribute17, hr_api.g_varchar2) or
361: nvl(pqp_aat_shd.g_old_rec.aat_attribute18, hr_api.g_varchar2) <>

Line 358: nvl(p_rec.aat_attribute16, hr_api.g_varchar2) or

354: nvl(p_rec.aat_attribute14, hr_api.g_varchar2) or
355: nvl(pqp_aat_shd.g_old_rec.aat_attribute15, hr_api.g_varchar2) <>
356: nvl(p_rec.aat_attribute15, hr_api.g_varchar2) or
357: nvl(pqp_aat_shd.g_old_rec.aat_attribute16, hr_api.g_varchar2) <>
358: nvl(p_rec.aat_attribute16, hr_api.g_varchar2) or
359: nvl(pqp_aat_shd.g_old_rec.aat_attribute17, hr_api.g_varchar2) <>
360: nvl(p_rec.aat_attribute17, hr_api.g_varchar2) or
361: nvl(pqp_aat_shd.g_old_rec.aat_attribute18, hr_api.g_varchar2) <>
362: nvl(p_rec.aat_attribute18, hr_api.g_varchar2) or

Line 359: nvl(pqp_aat_shd.g_old_rec.aat_attribute17, hr_api.g_varchar2) <>

355: nvl(pqp_aat_shd.g_old_rec.aat_attribute15, hr_api.g_varchar2) <>
356: nvl(p_rec.aat_attribute15, hr_api.g_varchar2) or
357: nvl(pqp_aat_shd.g_old_rec.aat_attribute16, hr_api.g_varchar2) <>
358: nvl(p_rec.aat_attribute16, hr_api.g_varchar2) or
359: nvl(pqp_aat_shd.g_old_rec.aat_attribute17, hr_api.g_varchar2) <>
360: nvl(p_rec.aat_attribute17, hr_api.g_varchar2) or
361: nvl(pqp_aat_shd.g_old_rec.aat_attribute18, hr_api.g_varchar2) <>
362: nvl(p_rec.aat_attribute18, hr_api.g_varchar2) or
363: nvl(pqp_aat_shd.g_old_rec.aat_attribute19, hr_api.g_varchar2) <>

Line 360: nvl(p_rec.aat_attribute17, hr_api.g_varchar2) or

356: nvl(p_rec.aat_attribute15, hr_api.g_varchar2) or
357: nvl(pqp_aat_shd.g_old_rec.aat_attribute16, hr_api.g_varchar2) <>
358: nvl(p_rec.aat_attribute16, hr_api.g_varchar2) or
359: nvl(pqp_aat_shd.g_old_rec.aat_attribute17, hr_api.g_varchar2) <>
360: nvl(p_rec.aat_attribute17, hr_api.g_varchar2) or
361: nvl(pqp_aat_shd.g_old_rec.aat_attribute18, hr_api.g_varchar2) <>
362: nvl(p_rec.aat_attribute18, hr_api.g_varchar2) or
363: nvl(pqp_aat_shd.g_old_rec.aat_attribute19, hr_api.g_varchar2) <>
364: nvl(p_rec.aat_attribute19, hr_api.g_varchar2) or

Line 361: nvl(pqp_aat_shd.g_old_rec.aat_attribute18, hr_api.g_varchar2) <>

357: nvl(pqp_aat_shd.g_old_rec.aat_attribute16, hr_api.g_varchar2) <>
358: nvl(p_rec.aat_attribute16, hr_api.g_varchar2) or
359: nvl(pqp_aat_shd.g_old_rec.aat_attribute17, hr_api.g_varchar2) <>
360: nvl(p_rec.aat_attribute17, hr_api.g_varchar2) or
361: nvl(pqp_aat_shd.g_old_rec.aat_attribute18, hr_api.g_varchar2) <>
362: nvl(p_rec.aat_attribute18, hr_api.g_varchar2) or
363: nvl(pqp_aat_shd.g_old_rec.aat_attribute19, hr_api.g_varchar2) <>
364: nvl(p_rec.aat_attribute19, hr_api.g_varchar2) or
365: nvl(pqp_aat_shd.g_old_rec.aat_attribute20, hr_api.g_varchar2) <>

Line 362: nvl(p_rec.aat_attribute18, hr_api.g_varchar2) or

358: nvl(p_rec.aat_attribute16, hr_api.g_varchar2) or
359: nvl(pqp_aat_shd.g_old_rec.aat_attribute17, hr_api.g_varchar2) <>
360: nvl(p_rec.aat_attribute17, hr_api.g_varchar2) or
361: nvl(pqp_aat_shd.g_old_rec.aat_attribute18, hr_api.g_varchar2) <>
362: nvl(p_rec.aat_attribute18, hr_api.g_varchar2) or
363: nvl(pqp_aat_shd.g_old_rec.aat_attribute19, hr_api.g_varchar2) <>
364: nvl(p_rec.aat_attribute19, hr_api.g_varchar2) or
365: nvl(pqp_aat_shd.g_old_rec.aat_attribute20, hr_api.g_varchar2) <>
366: nvl(p_rec.aat_attribute20, hr_api.g_varchar2) ))

Line 363: nvl(pqp_aat_shd.g_old_rec.aat_attribute19, hr_api.g_varchar2) <>

359: nvl(pqp_aat_shd.g_old_rec.aat_attribute17, hr_api.g_varchar2) <>
360: nvl(p_rec.aat_attribute17, hr_api.g_varchar2) or
361: nvl(pqp_aat_shd.g_old_rec.aat_attribute18, hr_api.g_varchar2) <>
362: nvl(p_rec.aat_attribute18, hr_api.g_varchar2) or
363: nvl(pqp_aat_shd.g_old_rec.aat_attribute19, hr_api.g_varchar2) <>
364: nvl(p_rec.aat_attribute19, hr_api.g_varchar2) or
365: nvl(pqp_aat_shd.g_old_rec.aat_attribute20, hr_api.g_varchar2) <>
366: nvl(p_rec.aat_attribute20, hr_api.g_varchar2) ))
367: or (p_rec.assignment_attribute_id is null) then

Line 364: nvl(p_rec.aat_attribute19, hr_api.g_varchar2) or

360: nvl(p_rec.aat_attribute17, hr_api.g_varchar2) or
361: nvl(pqp_aat_shd.g_old_rec.aat_attribute18, hr_api.g_varchar2) <>
362: nvl(p_rec.aat_attribute18, hr_api.g_varchar2) or
363: nvl(pqp_aat_shd.g_old_rec.aat_attribute19, hr_api.g_varchar2) <>
364: nvl(p_rec.aat_attribute19, hr_api.g_varchar2) or
365: nvl(pqp_aat_shd.g_old_rec.aat_attribute20, hr_api.g_varchar2) <>
366: nvl(p_rec.aat_attribute20, hr_api.g_varchar2) ))
367: or (p_rec.assignment_attribute_id is null) then
368: --

Line 365: nvl(pqp_aat_shd.g_old_rec.aat_attribute20, hr_api.g_varchar2) <>

361: nvl(pqp_aat_shd.g_old_rec.aat_attribute18, hr_api.g_varchar2) <>
362: nvl(p_rec.aat_attribute18, hr_api.g_varchar2) or
363: nvl(pqp_aat_shd.g_old_rec.aat_attribute19, hr_api.g_varchar2) <>
364: nvl(p_rec.aat_attribute19, hr_api.g_varchar2) or
365: nvl(pqp_aat_shd.g_old_rec.aat_attribute20, hr_api.g_varchar2) <>
366: nvl(p_rec.aat_attribute20, hr_api.g_varchar2) ))
367: or (p_rec.assignment_attribute_id is null) then
368: --
369: -- Only execute the validation if absolutely necessary:

Line 366: nvl(p_rec.aat_attribute20, hr_api.g_varchar2) ))

362: nvl(p_rec.aat_attribute18, hr_api.g_varchar2) or
363: nvl(pqp_aat_shd.g_old_rec.aat_attribute19, hr_api.g_varchar2) <>
364: nvl(p_rec.aat_attribute19, hr_api.g_varchar2) or
365: nvl(pqp_aat_shd.g_old_rec.aat_attribute20, hr_api.g_varchar2) <>
366: nvl(p_rec.aat_attribute20, hr_api.g_varchar2) ))
367: or (p_rec.assignment_attribute_id is null) then
368: --
369: -- Only execute the validation if absolutely necessary:
370: -- a) During update, the structure column value or any

Line 479: hr_api.argument_changed_error

475: --
476: --
477: EXCEPTION
478: WHEN l_error THEN
479: hr_api.argument_changed_error
480: (p_api_name => l_proc
481: ,p_argument => l_argument);
482: WHEN OTHERS THEN
483: RAISE;

Line 513: hr_api.mandatory_arg_error

509: if p_work_pattern is not null
510: or
511: p_start_day is not null then
512: --
513: hr_api.mandatory_arg_error
514: (p_api_name => l_proc
515: ,p_argument => 'Work_Pattern'
516: ,p_argument_value => p_work_pattern
517: );

Line 519: hr_api.mandatory_arg_error

515: ,p_argument => 'Work_Pattern'
516: ,p_argument_value => p_work_pattern
517: );
518:
519: hr_api.mandatory_arg_error
520: (p_api_name => l_proc
521: ,p_argument => 'Start_Day'
522: ,p_argument_value => p_start_day
523: );

Line 830: hr_api.g_varchar2) <> nvl(p_tp_is_teacher,

826: hr_utility.set_location(' Entering: '|| l_proc, 10);
827:
828: if (((p_assignment_attribute_id is not null) and
829: nvl(pqp_aat_shd.g_old_rec.tp_is_teacher,
830: hr_api.g_varchar2) <> nvl(p_tp_is_teacher,
831: hr_api.g_varchar2))
832: or
833: (p_assignment_attribute_id is null)) then
834:

Line 831: hr_api.g_varchar2))

827:
828: if (((p_assignment_attribute_id is not null) and
829: nvl(pqp_aat_shd.g_old_rec.tp_is_teacher,
830: hr_api.g_varchar2) <> nvl(p_tp_is_teacher,
831: hr_api.g_varchar2))
832: or
833: (p_assignment_attribute_id is null)) then
834:
835: hr_utility.set_location(l_proc, 20);

Line 838: if hr_api.not_exists_in_dt_hr_lookups

834:
835: hr_utility.set_location(l_proc, 20);
836: --
837: if p_tp_is_teacher is not null then
838: if hr_api.not_exists_in_dt_hr_lookups
839: (p_effective_date => p_effective_date
840: ,p_validation_start_date => p_validation_start_date
841: ,p_validation_end_date => p_validation_end_date
842: ,p_lookup_type => 'PQP_GB_TEACHER_JOB_STATUS'

Line 898: hr_api.g_varchar2) <> nvl(p_tp_is_teacher,

894: hr_utility.set_location(' Entering: '|| l_proc, 10);
895:
896: if (((p_assignment_attribute_id is not null) and
897: nvl(pqp_aat_shd.g_old_rec.tp_is_teacher,
898: hr_api.g_varchar2) <> nvl(p_tp_is_teacher,
899: hr_api.g_varchar2))
900: or
901: (p_assignment_attribute_id is null)) then
902:

Line 899: hr_api.g_varchar2))

895:
896: if (((p_assignment_attribute_id is not null) and
897: nvl(pqp_aat_shd.g_old_rec.tp_is_teacher,
898: hr_api.g_varchar2) <> nvl(p_tp_is_teacher,
899: hr_api.g_varchar2))
900: or
901: (p_assignment_attribute_id is null)) then
902:
903: hr_utility.set_location(l_proc, 20);

Line 964: hr_api.g_varchar2) <> nvl(p_tp_elected_pension,

960: hr_utility.set_location(' Entering: '|| l_proc, 10);
961:
962: if (((p_assignment_attribute_id is not null) and
963: nvl(pqp_aat_shd.g_old_rec.tp_elected_pension,
964: hr_api.g_varchar2) <> nvl(p_tp_elected_pension,
965: hr_api.g_varchar2))
966: or
967: (p_assignment_attribute_id is null)) then
968:

Line 965: hr_api.g_varchar2))

961:
962: if (((p_assignment_attribute_id is not null) and
963: nvl(pqp_aat_shd.g_old_rec.tp_elected_pension,
964: hr_api.g_varchar2) <> nvl(p_tp_elected_pension,
965: hr_api.g_varchar2))
966: or
967: (p_assignment_attribute_id is null)) then
968:
969: hr_utility.set_location(l_proc, 20);

Line 972: if hr_api.not_exists_in_dt_hr_lookups

968:
969: hr_utility.set_location(l_proc, 20);
970: --
971: if p_tp_elected_pension is not null then
972: if hr_api.not_exists_in_dt_hr_lookups
973: (p_effective_date => p_effective_date
974: ,p_validation_start_date => p_validation_start_date
975: ,p_validation_end_date => p_validation_end_date
976: ,p_lookup_type => 'YES_NO'

Line 1058: hr_api.g_varchar2) <> nvl(p_tp_safeguarded_grade,

1054: hr_utility.set_location(' Entering: '|| l_proc, 10);
1055:
1056: if (((p_assignment_attribute_id is not null) and
1057: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_grade,
1058: hr_api.g_varchar2) <> nvl(p_tp_safeguarded_grade,
1059: hr_api.g_varchar2))
1060: or
1061: (p_assignment_attribute_id is null)) then
1062:

Line 1059: hr_api.g_varchar2))

1055:
1056: if (((p_assignment_attribute_id is not null) and
1057: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_grade,
1058: hr_api.g_varchar2) <> nvl(p_tp_safeguarded_grade,
1059: hr_api.g_varchar2))
1060: or
1061: (p_assignment_attribute_id is null)) then
1062:
1063: hr_utility.set_location(l_proc, 20);

Line 1171: if (nvl(p_old_job_status,hr_api.g_varchar2) <>

1167: hr_utility.set_location(' Entering: '|| l_proc, 5);
1168: --
1169:
1170: -- Check only if tp_is_teacher has changed and is not null
1171: if (nvl(p_old_job_status,hr_api.g_varchar2) <>
1172: nvl(p_new_job_status,hr_api.g_varchar2)
1173: ) and
1174: (p_new_job_status is not null)
1175: then -- 0

Line 1172: nvl(p_new_job_status,hr_api.g_varchar2)

1168: --
1169:
1170: -- Check only if tp_is_teacher has changed and is not null
1171: if (nvl(p_old_job_status,hr_api.g_varchar2) <>
1172: nvl(p_new_job_status,hr_api.g_varchar2)
1173: ) and
1174: (p_new_job_status is not null)
1175: then -- 0
1176:

Line 1200: if p_datetrack_mode = hr_api.g_correction then

1196: end if;
1197: close C_TTR6_Future;
1198:
1199: -- Mode : CORRECTION -------------------------------------------+
1200: if p_datetrack_mode = hr_api.g_correction then
1201: -- 1
1202:
1203: /* For new = 'TTR6'
1204: Rules Handled : 2 and 6 Refer design doc for rules table */

Line 1240: if (p_datetrack_mode = hr_api.g_update or

1236:
1237: -- Mode : UPDATE -------------------------------------------+
1238: /* For old = 'TCHR' and new = 'TTR6'
1239: Rules Handled : 8(Golder Rule) Refer design doc for rules table */
1240: if (p_datetrack_mode = hr_api.g_update or
1241: p_datetrack_mode = hr_api.g_update_override or
1242: p_datetrack_mode = hr_api.g_update_change_insert) then
1243: -- 7
1244: if p_old_job_status = 'TCHR' and p_new_job_status = 'TTR6' then

Line 1241: p_datetrack_mode = hr_api.g_update_override or

1237: -- Mode : UPDATE -------------------------------------------+
1238: /* For old = 'TCHR' and new = 'TTR6'
1239: Rules Handled : 8(Golder Rule) Refer design doc for rules table */
1240: if (p_datetrack_mode = hr_api.g_update or
1241: p_datetrack_mode = hr_api.g_update_override or
1242: p_datetrack_mode = hr_api.g_update_change_insert) then
1243: -- 7
1244: if p_old_job_status = 'TCHR' and p_new_job_status = 'TTR6' then
1245: -- 8

Line 1242: p_datetrack_mode = hr_api.g_update_change_insert) then

1238: /* For old = 'TCHR' and new = 'TTR6'
1239: Rules Handled : 8(Golder Rule) Refer design doc for rules table */
1240: if (p_datetrack_mode = hr_api.g_update or
1241: p_datetrack_mode = hr_api.g_update_override or
1242: p_datetrack_mode = hr_api.g_update_change_insert) then
1243: -- 7
1244: if p_old_job_status = 'TCHR' and p_new_job_status = 'TTR6' then
1245: -- 8
1246: pqp_aat_shd.constraint_error

Line 1252: if (p_datetrack_mode = hr_api.g_update or

1248: end if; -- 8
1249:
1250: end if; -- 7
1251:
1252: if (p_datetrack_mode = hr_api.g_update or
1253: p_datetrack_mode = hr_api.g_update_change_insert) then
1254: -- 11
1255:
1256: /* For old = 'NONT' and (new = 'TTR6' or 'TCHR')

Line 1253: p_datetrack_mode = hr_api.g_update_change_insert) then

1249:
1250: end if; -- 7
1251:
1252: if (p_datetrack_mode = hr_api.g_update or
1253: p_datetrack_mode = hr_api.g_update_change_insert) then
1254: -- 11
1255:
1256: /* For old = 'NONT' and (new = 'TTR6' or 'TCHR')
1257: Rules Handled : 3 and 4(partly) Refer design doc for rules table */

Line 1408: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type,hr_api.g_varchar2)

1404: hr_utility.set_location(' Entering: '|| l_proc, 10);
1405:
1406:
1407: if (((p_assignment_attribute_id is not null) and
1408: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type,hr_api.g_varchar2)
1409: <> nvl(p_tp_safeguarded_rate_type,hr_api.g_varchar2)
1410: )
1411: or
1412: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id,hr_api.g_number)

Line 1409: <> nvl(p_tp_safeguarded_rate_type,hr_api.g_varchar2)

1405:
1406:
1407: if (((p_assignment_attribute_id is not null) and
1408: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type,hr_api.g_varchar2)
1409: <> nvl(p_tp_safeguarded_rate_type,hr_api.g_varchar2)
1410: )
1411: or
1412: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id,hr_api.g_number)
1413: <> nvl(p_tp_safeguarded_rate_id,hr_api.g_number)

Line 1412: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id,hr_api.g_number)

1408: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type,hr_api.g_varchar2)
1409: <> nvl(p_tp_safeguarded_rate_type,hr_api.g_varchar2)
1410: )
1411: or
1412: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id,hr_api.g_number)
1413: <> nvl(p_tp_safeguarded_rate_id,hr_api.g_number)
1414: )
1415: or
1416: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_grade,hr_api.g_varchar2)

Line 1413: <> nvl(p_tp_safeguarded_rate_id,hr_api.g_number)

1409: <> nvl(p_tp_safeguarded_rate_type,hr_api.g_varchar2)
1410: )
1411: or
1412: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id,hr_api.g_number)
1413: <> nvl(p_tp_safeguarded_rate_id,hr_api.g_number)
1414: )
1415: or
1416: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_grade,hr_api.g_varchar2)
1417: <> nvl(p_tp_safeguarded_grade,hr_api.g_varchar2)

Line 1416: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_grade,hr_api.g_varchar2)

1412: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id,hr_api.g_number)
1413: <> nvl(p_tp_safeguarded_rate_id,hr_api.g_number)
1414: )
1415: or
1416: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_grade,hr_api.g_varchar2)
1417: <> nvl(p_tp_safeguarded_grade,hr_api.g_varchar2)
1418: )
1419: )
1420: or

Line 1417: <> nvl(p_tp_safeguarded_grade,hr_api.g_varchar2)

1413: <> nvl(p_tp_safeguarded_rate_id,hr_api.g_number)
1414: )
1415: or
1416: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_grade,hr_api.g_varchar2)
1417: <> nvl(p_tp_safeguarded_grade,hr_api.g_varchar2)
1418: )
1419: )
1420: or
1421: (p_assignment_attribute_id is null)

Line 1534: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id,hr_api.g_number)

1530: --
1531: hr_utility.set_location(' Entering: '|| l_proc, 10);
1532:
1533: if (((p_assignment_attribute_id is not null) and
1534: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id,hr_api.g_number)
1535: <> nvl(p_tp_spinal_point_id,hr_api.g_number))
1536: or
1537: (p_assignment_attribute_id is null)
1538: ) then

Line 1535: <> nvl(p_tp_spinal_point_id,hr_api.g_number))

1531: hr_utility.set_location(' Entering: '|| l_proc, 10);
1532:
1533: if (((p_assignment_attribute_id is not null) and
1534: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id,hr_api.g_number)
1535: <> nvl(p_tp_spinal_point_id,hr_api.g_number))
1536: or
1537: (p_assignment_attribute_id is null)
1538: ) then
1539:

Line 1641: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id,hr_api.g_number)

1637: hr_utility.set_location(' Entering: '|| l_proc, 10);
1638:
1639: if (((p_assignment_attribute_id is not null)
1640: and
1641: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id,hr_api.g_number)
1642: <> nvl(p_tp_spinal_point_id,hr_api.g_number)
1643: or
1644: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id,hr_api.g_number)
1645: <> nvl(p_tp_safeguarded_rate_id,hr_api.g_number)

Line 1642: <> nvl(p_tp_spinal_point_id,hr_api.g_number)

1638:
1639: if (((p_assignment_attribute_id is not null)
1640: and
1641: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id,hr_api.g_number)
1642: <> nvl(p_tp_spinal_point_id,hr_api.g_number)
1643: or
1644: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id,hr_api.g_number)
1645: <> nvl(p_tp_safeguarded_rate_id,hr_api.g_number)
1646: or

Line 1644: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id,hr_api.g_number)

1640: and
1641: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id,hr_api.g_number)
1642: <> nvl(p_tp_spinal_point_id,hr_api.g_number)
1643: or
1644: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id,hr_api.g_number)
1645: <> nvl(p_tp_safeguarded_rate_id,hr_api.g_number)
1646: or
1647: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type,hr_api.g_varchar2)
1648: <> nvl(p_tp_safeguarded_rate_type,hr_api.g_varchar2)

Line 1645: <> nvl(p_tp_safeguarded_rate_id,hr_api.g_number)

1641: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id,hr_api.g_number)
1642: <> nvl(p_tp_spinal_point_id,hr_api.g_number)
1643: or
1644: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id,hr_api.g_number)
1645: <> nvl(p_tp_safeguarded_rate_id,hr_api.g_number)
1646: or
1647: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type,hr_api.g_varchar2)
1648: <> nvl(p_tp_safeguarded_rate_type,hr_api.g_varchar2)
1649: or

Line 1647: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type,hr_api.g_varchar2)

1643: or
1644: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id,hr_api.g_number)
1645: <> nvl(p_tp_safeguarded_rate_id,hr_api.g_number)
1646: or
1647: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type,hr_api.g_varchar2)
1648: <> nvl(p_tp_safeguarded_rate_type,hr_api.g_varchar2)
1649: or
1650: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_grade,hr_api.g_varchar2)
1651: <> nvl(p_tp_safeguarded_grade,hr_api.g_varchar2)

Line 1648: <> nvl(p_tp_safeguarded_rate_type,hr_api.g_varchar2)

1644: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id,hr_api.g_number)
1645: <> nvl(p_tp_safeguarded_rate_id,hr_api.g_number)
1646: or
1647: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type,hr_api.g_varchar2)
1648: <> nvl(p_tp_safeguarded_rate_type,hr_api.g_varchar2)
1649: or
1650: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_grade,hr_api.g_varchar2)
1651: <> nvl(p_tp_safeguarded_grade,hr_api.g_varchar2)
1652: )

Line 1650: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_grade,hr_api.g_varchar2)

1646: or
1647: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type,hr_api.g_varchar2)
1648: <> nvl(p_tp_safeguarded_rate_type,hr_api.g_varchar2)
1649: or
1650: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_grade,hr_api.g_varchar2)
1651: <> nvl(p_tp_safeguarded_grade,hr_api.g_varchar2)
1652: )
1653: )
1654: or

Line 1651: <> nvl(p_tp_safeguarded_grade,hr_api.g_varchar2)

1647: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type,hr_api.g_varchar2)
1648: <> nvl(p_tp_safeguarded_rate_type,hr_api.g_varchar2)
1649: or
1650: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_grade,hr_api.g_varchar2)
1651: <> nvl(p_tp_safeguarded_grade,hr_api.g_varchar2)
1652: )
1653: )
1654: or
1655: (p_assignment_attribute_id is null)

Line 1732: hr_api.g_varchar2) <> nvl(p_tp_fast_track,

1728: hr_utility.set_location(' Entering: '|| l_proc, 10);
1729:
1730: if (((p_assignment_attribute_id is not null) and
1731: nvl(pqp_aat_shd.g_old_rec.tp_fast_track,
1732: hr_api.g_varchar2) <> nvl(p_tp_fast_track,
1733: hr_api.g_varchar2))
1734: or
1735: (p_assignment_attribute_id is null)) then
1736:

Line 1733: hr_api.g_varchar2))

1729:
1730: if (((p_assignment_attribute_id is not null) and
1731: nvl(pqp_aat_shd.g_old_rec.tp_fast_track,
1732: hr_api.g_varchar2) <> nvl(p_tp_fast_track,
1733: hr_api.g_varchar2))
1734: or
1735: (p_assignment_attribute_id is null)) then
1736:
1737: hr_utility.set_location(l_proc, 20);

Line 1740: if hr_api.not_exists_in_dt_hr_lookups

1736:
1737: hr_utility.set_location(l_proc, 20);
1738: --
1739: if p_tp_fast_track is not null then
1740: if hr_api.not_exists_in_dt_hr_lookups
1741: (p_effective_date => p_effective_date
1742: ,p_validation_start_date => p_validation_start_date
1743: ,p_validation_end_date => p_validation_end_date
1744: ,p_lookup_type => 'YES_NO'

Line 1805: hr_api.mandatory_arg_error

1801: Begin
1802: --
1803: -- Ensure that the p_datetrack_mode argument is not null
1804: --
1805: hr_api.mandatory_arg_error
1806: (p_api_name => l_proc
1807: ,p_argument => 'datetrack_mode'
1808: ,p_argument_value => p_datetrack_mode
1809: );

Line 1815: hr_api.mandatory_arg_error

1811: -- Mode will be valid, as this is checked at the start of the upd.
1812: --
1813: -- Ensure the arguments are not null
1814: --
1815: hr_api.mandatory_arg_error
1816: (p_api_name => l_proc
1817: ,p_argument => 'validation_start_date'
1818: ,p_argument_value => p_validation_start_date
1819: );

Line 1821: hr_api.mandatory_arg_error

1817: ,p_argument => 'validation_start_date'
1818: ,p_argument_value => p_validation_start_date
1819: );
1820: --
1821: hr_api.mandatory_arg_error
1822: (p_api_name => l_proc
1823: ,p_argument => 'validation_end_date'
1824: ,p_argument_value => p_validation_end_date
1825: );

Line 1899: hr_api.mandatory_arg_error

1895: Begin
1896: --
1897: -- Ensure that the p_datetrack_mode argument is not null
1898: --
1899: hr_api.mandatory_arg_error
1900: (p_api_name => l_proc
1901: ,p_argument => 'datetrack_mode'
1902: ,p_argument_value => p_datetrack_mode
1903: );

Line 1908: If (p_datetrack_mode = hr_api.g_delete or

1904: --
1905: -- Only perform the validation if the datetrack mode is either
1906: -- DELETE or ZAP
1907: --
1908: If (p_datetrack_mode = hr_api.g_delete or
1909: p_datetrack_mode = hr_api.g_zap) then
1910: --
1911: --
1912: -- Ensure the arguments are not null

Line 1909: p_datetrack_mode = hr_api.g_zap) then

1905: -- Only perform the validation if the datetrack mode is either
1906: -- DELETE or ZAP
1907: --
1908: If (p_datetrack_mode = hr_api.g_delete or
1909: p_datetrack_mode = hr_api.g_zap) then
1910: --
1911: --
1912: -- Ensure the arguments are not null
1913: --

Line 1914: hr_api.mandatory_arg_error

1910: --
1911: --
1912: -- Ensure the arguments are not null
1913: --
1914: hr_api.mandatory_arg_error
1915: (p_api_name => l_proc
1916: ,p_argument => 'validation_start_date'
1917: ,p_argument_value => p_validation_start_date
1918: );

Line 1920: hr_api.mandatory_arg_error

1916: ,p_argument => 'validation_start_date'
1917: ,p_argument_value => p_validation_start_date
1918: );
1919: --
1920: hr_api.mandatory_arg_error
1921: (p_api_name => l_proc
1922: ,p_argument => 'validation_end_date'
1923: ,p_argument_value => p_validation_end_date
1924: );

Line 1926: hr_api.mandatory_arg_error

1922: ,p_argument => 'validation_end_date'
1923: ,p_argument_value => p_validation_end_date
1924: );
1925: --
1926: hr_api.mandatory_arg_error
1927: (p_api_name => l_proc
1928: ,p_argument => 'assignment_attribute_id'
1929: ,p_argument_value => p_assignment_attribute_id
1930: );

Line 1975: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1971: hr_utility.set_location('Entering:'||l_proc, 5);
1972: --
1973: -- Call all supporting business operations
1974: --
1975: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1976: --
1977: --
1978: pqp_aat_bus.chk_ddf(p_rec);
1979: --

Line 2168: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

2164: hr_utility.set_location('Entering:'||l_proc, 5);
2165: --
2166: -- Call all supporting business operations
2167: --
2168: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2169: --
2170: -- Call the datetrack update integrity operation
2171: --
2172: dt_update_validate