APPS.PAY_ETP_BUS_ND dependencies on HR_API

Line 45: hr_api.mandatory_arg_error

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

Line 71: hr_api.set_security_group_id

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

Line 109: hr_api.mandatory_arg_error

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

Line 115: if ( nvl(pay_etp_bus_nd.g_element_type_id, hr_api.g_number)

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

Line 192: hr_api.g_varchar2) <>

188: hr_utility.set_location('Entering:'||l_proc,10);
189: --
190: if ((p_rec.element_type_id is not null) and
191: (nvl(pay_etp_shd_nd.g_old_rec.element_information_category,
192: hr_api.g_varchar2) <>
193: nvl(p_rec.element_information_category, hr_api.g_varchar2) or
194: nvl(pay_etp_shd_nd.g_old_rec.element_information1, hr_api.g_varchar2) <>
195: nvl(p_rec.element_information1, hr_api.g_varchar2) or
196: nvl(pay_etp_shd_nd.g_old_rec.element_information2, hr_api.g_varchar2) <>

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

189: --
190: if ((p_rec.element_type_id is not null) and
191: (nvl(pay_etp_shd_nd.g_old_rec.element_information_category,
192: hr_api.g_varchar2) <>
193: nvl(p_rec.element_information_category, hr_api.g_varchar2) or
194: nvl(pay_etp_shd_nd.g_old_rec.element_information1, hr_api.g_varchar2) <>
195: nvl(p_rec.element_information1, hr_api.g_varchar2) or
196: nvl(pay_etp_shd_nd.g_old_rec.element_information2, hr_api.g_varchar2) <>
197: nvl(p_rec.element_information2, hr_api.g_varchar2) or

Line 194: nvl(pay_etp_shd_nd.g_old_rec.element_information1, hr_api.g_varchar2) <>

190: if ((p_rec.element_type_id is not null) and
191: (nvl(pay_etp_shd_nd.g_old_rec.element_information_category,
192: hr_api.g_varchar2) <>
193: nvl(p_rec.element_information_category, hr_api.g_varchar2) or
194: nvl(pay_etp_shd_nd.g_old_rec.element_information1, hr_api.g_varchar2) <>
195: nvl(p_rec.element_information1, hr_api.g_varchar2) or
196: nvl(pay_etp_shd_nd.g_old_rec.element_information2, hr_api.g_varchar2) <>
197: nvl(p_rec.element_information2, hr_api.g_varchar2) or
198: nvl(pay_etp_shd_nd.g_old_rec.element_information3, hr_api.g_varchar2) <>

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

191: (nvl(pay_etp_shd_nd.g_old_rec.element_information_category,
192: hr_api.g_varchar2) <>
193: nvl(p_rec.element_information_category, hr_api.g_varchar2) or
194: nvl(pay_etp_shd_nd.g_old_rec.element_information1, hr_api.g_varchar2) <>
195: nvl(p_rec.element_information1, hr_api.g_varchar2) or
196: nvl(pay_etp_shd_nd.g_old_rec.element_information2, hr_api.g_varchar2) <>
197: nvl(p_rec.element_information2, hr_api.g_varchar2) or
198: nvl(pay_etp_shd_nd.g_old_rec.element_information3, hr_api.g_varchar2) <>
199: nvl(p_rec.element_information3, hr_api.g_varchar2) or

Line 196: nvl(pay_etp_shd_nd.g_old_rec.element_information2, hr_api.g_varchar2) <>

192: hr_api.g_varchar2) <>
193: nvl(p_rec.element_information_category, hr_api.g_varchar2) or
194: nvl(pay_etp_shd_nd.g_old_rec.element_information1, hr_api.g_varchar2) <>
195: nvl(p_rec.element_information1, hr_api.g_varchar2) or
196: nvl(pay_etp_shd_nd.g_old_rec.element_information2, hr_api.g_varchar2) <>
197: nvl(p_rec.element_information2, hr_api.g_varchar2) or
198: nvl(pay_etp_shd_nd.g_old_rec.element_information3, hr_api.g_varchar2) <>
199: nvl(p_rec.element_information3, hr_api.g_varchar2) or
200: nvl(pay_etp_shd_nd.g_old_rec.element_information4, hr_api.g_varchar2) <>

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

193: nvl(p_rec.element_information_category, hr_api.g_varchar2) or
194: nvl(pay_etp_shd_nd.g_old_rec.element_information1, hr_api.g_varchar2) <>
195: nvl(p_rec.element_information1, hr_api.g_varchar2) or
196: nvl(pay_etp_shd_nd.g_old_rec.element_information2, hr_api.g_varchar2) <>
197: nvl(p_rec.element_information2, hr_api.g_varchar2) or
198: nvl(pay_etp_shd_nd.g_old_rec.element_information3, hr_api.g_varchar2) <>
199: nvl(p_rec.element_information3, hr_api.g_varchar2) or
200: nvl(pay_etp_shd_nd.g_old_rec.element_information4, hr_api.g_varchar2) <>
201: nvl(p_rec.element_information4, hr_api.g_varchar2) or

Line 198: nvl(pay_etp_shd_nd.g_old_rec.element_information3, hr_api.g_varchar2) <>

194: nvl(pay_etp_shd_nd.g_old_rec.element_information1, hr_api.g_varchar2) <>
195: nvl(p_rec.element_information1, hr_api.g_varchar2) or
196: nvl(pay_etp_shd_nd.g_old_rec.element_information2, hr_api.g_varchar2) <>
197: nvl(p_rec.element_information2, hr_api.g_varchar2) or
198: nvl(pay_etp_shd_nd.g_old_rec.element_information3, hr_api.g_varchar2) <>
199: nvl(p_rec.element_information3, hr_api.g_varchar2) or
200: nvl(pay_etp_shd_nd.g_old_rec.element_information4, hr_api.g_varchar2) <>
201: nvl(p_rec.element_information4, hr_api.g_varchar2) or
202: nvl(pay_etp_shd_nd.g_old_rec.element_information5, hr_api.g_varchar2) <>

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

195: nvl(p_rec.element_information1, hr_api.g_varchar2) or
196: nvl(pay_etp_shd_nd.g_old_rec.element_information2, hr_api.g_varchar2) <>
197: nvl(p_rec.element_information2, hr_api.g_varchar2) or
198: nvl(pay_etp_shd_nd.g_old_rec.element_information3, hr_api.g_varchar2) <>
199: nvl(p_rec.element_information3, hr_api.g_varchar2) or
200: nvl(pay_etp_shd_nd.g_old_rec.element_information4, hr_api.g_varchar2) <>
201: nvl(p_rec.element_information4, hr_api.g_varchar2) or
202: nvl(pay_etp_shd_nd.g_old_rec.element_information5, hr_api.g_varchar2) <>
203: nvl(p_rec.element_information5, hr_api.g_varchar2) or

Line 200: nvl(pay_etp_shd_nd.g_old_rec.element_information4, hr_api.g_varchar2) <>

196: nvl(pay_etp_shd_nd.g_old_rec.element_information2, hr_api.g_varchar2) <>
197: nvl(p_rec.element_information2, hr_api.g_varchar2) or
198: nvl(pay_etp_shd_nd.g_old_rec.element_information3, hr_api.g_varchar2) <>
199: nvl(p_rec.element_information3, hr_api.g_varchar2) or
200: nvl(pay_etp_shd_nd.g_old_rec.element_information4, hr_api.g_varchar2) <>
201: nvl(p_rec.element_information4, hr_api.g_varchar2) or
202: nvl(pay_etp_shd_nd.g_old_rec.element_information5, hr_api.g_varchar2) <>
203: nvl(p_rec.element_information5, hr_api.g_varchar2) or
204: nvl(pay_etp_shd_nd.g_old_rec.element_information6, hr_api.g_varchar2) <>

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

197: nvl(p_rec.element_information2, hr_api.g_varchar2) or
198: nvl(pay_etp_shd_nd.g_old_rec.element_information3, hr_api.g_varchar2) <>
199: nvl(p_rec.element_information3, hr_api.g_varchar2) or
200: nvl(pay_etp_shd_nd.g_old_rec.element_information4, hr_api.g_varchar2) <>
201: nvl(p_rec.element_information4, hr_api.g_varchar2) or
202: nvl(pay_etp_shd_nd.g_old_rec.element_information5, hr_api.g_varchar2) <>
203: nvl(p_rec.element_information5, hr_api.g_varchar2) or
204: nvl(pay_etp_shd_nd.g_old_rec.element_information6, hr_api.g_varchar2) <>
205: nvl(p_rec.element_information6, hr_api.g_varchar2) or

Line 202: nvl(pay_etp_shd_nd.g_old_rec.element_information5, hr_api.g_varchar2) <>

198: nvl(pay_etp_shd_nd.g_old_rec.element_information3, hr_api.g_varchar2) <>
199: nvl(p_rec.element_information3, hr_api.g_varchar2) or
200: nvl(pay_etp_shd_nd.g_old_rec.element_information4, hr_api.g_varchar2) <>
201: nvl(p_rec.element_information4, hr_api.g_varchar2) or
202: nvl(pay_etp_shd_nd.g_old_rec.element_information5, hr_api.g_varchar2) <>
203: nvl(p_rec.element_information5, hr_api.g_varchar2) or
204: nvl(pay_etp_shd_nd.g_old_rec.element_information6, hr_api.g_varchar2) <>
205: nvl(p_rec.element_information6, hr_api.g_varchar2) or
206: nvl(pay_etp_shd_nd.g_old_rec.element_information7, hr_api.g_varchar2) <>

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

199: nvl(p_rec.element_information3, hr_api.g_varchar2) or
200: nvl(pay_etp_shd_nd.g_old_rec.element_information4, hr_api.g_varchar2) <>
201: nvl(p_rec.element_information4, hr_api.g_varchar2) or
202: nvl(pay_etp_shd_nd.g_old_rec.element_information5, hr_api.g_varchar2) <>
203: nvl(p_rec.element_information5, hr_api.g_varchar2) or
204: nvl(pay_etp_shd_nd.g_old_rec.element_information6, hr_api.g_varchar2) <>
205: nvl(p_rec.element_information6, hr_api.g_varchar2) or
206: nvl(pay_etp_shd_nd.g_old_rec.element_information7, hr_api.g_varchar2) <>
207: nvl(p_rec.element_information7, hr_api.g_varchar2) or

Line 204: nvl(pay_etp_shd_nd.g_old_rec.element_information6, hr_api.g_varchar2) <>

200: nvl(pay_etp_shd_nd.g_old_rec.element_information4, hr_api.g_varchar2) <>
201: nvl(p_rec.element_information4, hr_api.g_varchar2) or
202: nvl(pay_etp_shd_nd.g_old_rec.element_information5, hr_api.g_varchar2) <>
203: nvl(p_rec.element_information5, hr_api.g_varchar2) or
204: nvl(pay_etp_shd_nd.g_old_rec.element_information6, hr_api.g_varchar2) <>
205: nvl(p_rec.element_information6, hr_api.g_varchar2) or
206: nvl(pay_etp_shd_nd.g_old_rec.element_information7, hr_api.g_varchar2) <>
207: nvl(p_rec.element_information7, hr_api.g_varchar2) or
208: nvl(pay_etp_shd_nd.g_old_rec.element_information8, hr_api.g_varchar2) <>

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

201: nvl(p_rec.element_information4, hr_api.g_varchar2) or
202: nvl(pay_etp_shd_nd.g_old_rec.element_information5, hr_api.g_varchar2) <>
203: nvl(p_rec.element_information5, hr_api.g_varchar2) or
204: nvl(pay_etp_shd_nd.g_old_rec.element_information6, hr_api.g_varchar2) <>
205: nvl(p_rec.element_information6, hr_api.g_varchar2) or
206: nvl(pay_etp_shd_nd.g_old_rec.element_information7, hr_api.g_varchar2) <>
207: nvl(p_rec.element_information7, hr_api.g_varchar2) or
208: nvl(pay_etp_shd_nd.g_old_rec.element_information8, hr_api.g_varchar2) <>
209: nvl(p_rec.element_information8, hr_api.g_varchar2) or

Line 206: nvl(pay_etp_shd_nd.g_old_rec.element_information7, hr_api.g_varchar2) <>

202: nvl(pay_etp_shd_nd.g_old_rec.element_information5, hr_api.g_varchar2) <>
203: nvl(p_rec.element_information5, hr_api.g_varchar2) or
204: nvl(pay_etp_shd_nd.g_old_rec.element_information6, hr_api.g_varchar2) <>
205: nvl(p_rec.element_information6, hr_api.g_varchar2) or
206: nvl(pay_etp_shd_nd.g_old_rec.element_information7, hr_api.g_varchar2) <>
207: nvl(p_rec.element_information7, hr_api.g_varchar2) or
208: nvl(pay_etp_shd_nd.g_old_rec.element_information8, hr_api.g_varchar2) <>
209: nvl(p_rec.element_information8, hr_api.g_varchar2) or
210: nvl(pay_etp_shd_nd.g_old_rec.element_information9, hr_api.g_varchar2) <>

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

203: nvl(p_rec.element_information5, hr_api.g_varchar2) or
204: nvl(pay_etp_shd_nd.g_old_rec.element_information6, hr_api.g_varchar2) <>
205: nvl(p_rec.element_information6, hr_api.g_varchar2) or
206: nvl(pay_etp_shd_nd.g_old_rec.element_information7, hr_api.g_varchar2) <>
207: nvl(p_rec.element_information7, hr_api.g_varchar2) or
208: nvl(pay_etp_shd_nd.g_old_rec.element_information8, hr_api.g_varchar2) <>
209: nvl(p_rec.element_information8, hr_api.g_varchar2) or
210: nvl(pay_etp_shd_nd.g_old_rec.element_information9, hr_api.g_varchar2) <>
211: nvl(p_rec.element_information9, hr_api.g_varchar2) or

Line 208: nvl(pay_etp_shd_nd.g_old_rec.element_information8, hr_api.g_varchar2) <>

204: nvl(pay_etp_shd_nd.g_old_rec.element_information6, hr_api.g_varchar2) <>
205: nvl(p_rec.element_information6, hr_api.g_varchar2) or
206: nvl(pay_etp_shd_nd.g_old_rec.element_information7, hr_api.g_varchar2) <>
207: nvl(p_rec.element_information7, hr_api.g_varchar2) or
208: nvl(pay_etp_shd_nd.g_old_rec.element_information8, hr_api.g_varchar2) <>
209: nvl(p_rec.element_information8, hr_api.g_varchar2) or
210: nvl(pay_etp_shd_nd.g_old_rec.element_information9, hr_api.g_varchar2) <>
211: nvl(p_rec.element_information9, hr_api.g_varchar2) or
212: nvl(pay_etp_shd_nd.g_old_rec.element_information10, hr_api.g_varchar2) <>

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

205: nvl(p_rec.element_information6, hr_api.g_varchar2) or
206: nvl(pay_etp_shd_nd.g_old_rec.element_information7, hr_api.g_varchar2) <>
207: nvl(p_rec.element_information7, hr_api.g_varchar2) or
208: nvl(pay_etp_shd_nd.g_old_rec.element_information8, hr_api.g_varchar2) <>
209: nvl(p_rec.element_information8, hr_api.g_varchar2) or
210: nvl(pay_etp_shd_nd.g_old_rec.element_information9, hr_api.g_varchar2) <>
211: nvl(p_rec.element_information9, hr_api.g_varchar2) or
212: nvl(pay_etp_shd_nd.g_old_rec.element_information10, hr_api.g_varchar2) <>
213: nvl(p_rec.element_information10, hr_api.g_varchar2) or

Line 210: nvl(pay_etp_shd_nd.g_old_rec.element_information9, hr_api.g_varchar2) <>

206: nvl(pay_etp_shd_nd.g_old_rec.element_information7, hr_api.g_varchar2) <>
207: nvl(p_rec.element_information7, hr_api.g_varchar2) or
208: nvl(pay_etp_shd_nd.g_old_rec.element_information8, hr_api.g_varchar2) <>
209: nvl(p_rec.element_information8, hr_api.g_varchar2) or
210: nvl(pay_etp_shd_nd.g_old_rec.element_information9, hr_api.g_varchar2) <>
211: nvl(p_rec.element_information9, hr_api.g_varchar2) or
212: nvl(pay_etp_shd_nd.g_old_rec.element_information10, hr_api.g_varchar2) <>
213: nvl(p_rec.element_information10, hr_api.g_varchar2) or
214: nvl(pay_etp_shd_nd.g_old_rec.element_information11, hr_api.g_varchar2) <>

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

207: nvl(p_rec.element_information7, hr_api.g_varchar2) or
208: nvl(pay_etp_shd_nd.g_old_rec.element_information8, hr_api.g_varchar2) <>
209: nvl(p_rec.element_information8, hr_api.g_varchar2) or
210: nvl(pay_etp_shd_nd.g_old_rec.element_information9, hr_api.g_varchar2) <>
211: nvl(p_rec.element_information9, hr_api.g_varchar2) or
212: nvl(pay_etp_shd_nd.g_old_rec.element_information10, hr_api.g_varchar2) <>
213: nvl(p_rec.element_information10, hr_api.g_varchar2) or
214: nvl(pay_etp_shd_nd.g_old_rec.element_information11, hr_api.g_varchar2) <>
215: nvl(p_rec.element_information11, hr_api.g_varchar2) or

Line 212: nvl(pay_etp_shd_nd.g_old_rec.element_information10, hr_api.g_varchar2) <>

208: nvl(pay_etp_shd_nd.g_old_rec.element_information8, hr_api.g_varchar2) <>
209: nvl(p_rec.element_information8, hr_api.g_varchar2) or
210: nvl(pay_etp_shd_nd.g_old_rec.element_information9, hr_api.g_varchar2) <>
211: nvl(p_rec.element_information9, hr_api.g_varchar2) or
212: nvl(pay_etp_shd_nd.g_old_rec.element_information10, hr_api.g_varchar2) <>
213: nvl(p_rec.element_information10, hr_api.g_varchar2) or
214: nvl(pay_etp_shd_nd.g_old_rec.element_information11, hr_api.g_varchar2) <>
215: nvl(p_rec.element_information11, hr_api.g_varchar2) or
216: nvl(pay_etp_shd_nd.g_old_rec.element_information12, hr_api.g_varchar2) <>

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

209: nvl(p_rec.element_information8, hr_api.g_varchar2) or
210: nvl(pay_etp_shd_nd.g_old_rec.element_information9, hr_api.g_varchar2) <>
211: nvl(p_rec.element_information9, hr_api.g_varchar2) or
212: nvl(pay_etp_shd_nd.g_old_rec.element_information10, hr_api.g_varchar2) <>
213: nvl(p_rec.element_information10, hr_api.g_varchar2) or
214: nvl(pay_etp_shd_nd.g_old_rec.element_information11, hr_api.g_varchar2) <>
215: nvl(p_rec.element_information11, hr_api.g_varchar2) or
216: nvl(pay_etp_shd_nd.g_old_rec.element_information12, hr_api.g_varchar2) <>
217: nvl(p_rec.element_information12, hr_api.g_varchar2) or

Line 214: nvl(pay_etp_shd_nd.g_old_rec.element_information11, hr_api.g_varchar2) <>

210: nvl(pay_etp_shd_nd.g_old_rec.element_information9, hr_api.g_varchar2) <>
211: nvl(p_rec.element_information9, hr_api.g_varchar2) or
212: nvl(pay_etp_shd_nd.g_old_rec.element_information10, hr_api.g_varchar2) <>
213: nvl(p_rec.element_information10, hr_api.g_varchar2) or
214: nvl(pay_etp_shd_nd.g_old_rec.element_information11, hr_api.g_varchar2) <>
215: nvl(p_rec.element_information11, hr_api.g_varchar2) or
216: nvl(pay_etp_shd_nd.g_old_rec.element_information12, hr_api.g_varchar2) <>
217: nvl(p_rec.element_information12, hr_api.g_varchar2) or
218: nvl(pay_etp_shd_nd.g_old_rec.element_information13, hr_api.g_varchar2) <>

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

211: nvl(p_rec.element_information9, hr_api.g_varchar2) or
212: nvl(pay_etp_shd_nd.g_old_rec.element_information10, hr_api.g_varchar2) <>
213: nvl(p_rec.element_information10, hr_api.g_varchar2) or
214: nvl(pay_etp_shd_nd.g_old_rec.element_information11, hr_api.g_varchar2) <>
215: nvl(p_rec.element_information11, hr_api.g_varchar2) or
216: nvl(pay_etp_shd_nd.g_old_rec.element_information12, hr_api.g_varchar2) <>
217: nvl(p_rec.element_information12, hr_api.g_varchar2) or
218: nvl(pay_etp_shd_nd.g_old_rec.element_information13, hr_api.g_varchar2) <>
219: nvl(p_rec.element_information13, hr_api.g_varchar2) or

Line 216: nvl(pay_etp_shd_nd.g_old_rec.element_information12, hr_api.g_varchar2) <>

212: nvl(pay_etp_shd_nd.g_old_rec.element_information10, hr_api.g_varchar2) <>
213: nvl(p_rec.element_information10, hr_api.g_varchar2) or
214: nvl(pay_etp_shd_nd.g_old_rec.element_information11, hr_api.g_varchar2) <>
215: nvl(p_rec.element_information11, hr_api.g_varchar2) or
216: nvl(pay_etp_shd_nd.g_old_rec.element_information12, hr_api.g_varchar2) <>
217: nvl(p_rec.element_information12, hr_api.g_varchar2) or
218: nvl(pay_etp_shd_nd.g_old_rec.element_information13, hr_api.g_varchar2) <>
219: nvl(p_rec.element_information13, hr_api.g_varchar2) or
220: nvl(pay_etp_shd_nd.g_old_rec.element_information14, hr_api.g_varchar2) <>

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

213: nvl(p_rec.element_information10, hr_api.g_varchar2) or
214: nvl(pay_etp_shd_nd.g_old_rec.element_information11, hr_api.g_varchar2) <>
215: nvl(p_rec.element_information11, hr_api.g_varchar2) or
216: nvl(pay_etp_shd_nd.g_old_rec.element_information12, hr_api.g_varchar2) <>
217: nvl(p_rec.element_information12, hr_api.g_varchar2) or
218: nvl(pay_etp_shd_nd.g_old_rec.element_information13, hr_api.g_varchar2) <>
219: nvl(p_rec.element_information13, hr_api.g_varchar2) or
220: nvl(pay_etp_shd_nd.g_old_rec.element_information14, hr_api.g_varchar2) <>
221: nvl(p_rec.element_information14, hr_api.g_varchar2) or

Line 218: nvl(pay_etp_shd_nd.g_old_rec.element_information13, hr_api.g_varchar2) <>

214: nvl(pay_etp_shd_nd.g_old_rec.element_information11, hr_api.g_varchar2) <>
215: nvl(p_rec.element_information11, hr_api.g_varchar2) or
216: nvl(pay_etp_shd_nd.g_old_rec.element_information12, hr_api.g_varchar2) <>
217: nvl(p_rec.element_information12, hr_api.g_varchar2) or
218: nvl(pay_etp_shd_nd.g_old_rec.element_information13, hr_api.g_varchar2) <>
219: nvl(p_rec.element_information13, hr_api.g_varchar2) or
220: nvl(pay_etp_shd_nd.g_old_rec.element_information14, hr_api.g_varchar2) <>
221: nvl(p_rec.element_information14, hr_api.g_varchar2) or
222: nvl(pay_etp_shd_nd.g_old_rec.element_information15, hr_api.g_varchar2) <>

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

215: nvl(p_rec.element_information11, hr_api.g_varchar2) or
216: nvl(pay_etp_shd_nd.g_old_rec.element_information12, hr_api.g_varchar2) <>
217: nvl(p_rec.element_information12, hr_api.g_varchar2) or
218: nvl(pay_etp_shd_nd.g_old_rec.element_information13, hr_api.g_varchar2) <>
219: nvl(p_rec.element_information13, hr_api.g_varchar2) or
220: nvl(pay_etp_shd_nd.g_old_rec.element_information14, hr_api.g_varchar2) <>
221: nvl(p_rec.element_information14, hr_api.g_varchar2) or
222: nvl(pay_etp_shd_nd.g_old_rec.element_information15, hr_api.g_varchar2) <>
223: nvl(p_rec.element_information15, hr_api.g_varchar2) or

Line 220: nvl(pay_etp_shd_nd.g_old_rec.element_information14, hr_api.g_varchar2) <>

216: nvl(pay_etp_shd_nd.g_old_rec.element_information12, hr_api.g_varchar2) <>
217: nvl(p_rec.element_information12, hr_api.g_varchar2) or
218: nvl(pay_etp_shd_nd.g_old_rec.element_information13, hr_api.g_varchar2) <>
219: nvl(p_rec.element_information13, hr_api.g_varchar2) or
220: nvl(pay_etp_shd_nd.g_old_rec.element_information14, hr_api.g_varchar2) <>
221: nvl(p_rec.element_information14, hr_api.g_varchar2) or
222: nvl(pay_etp_shd_nd.g_old_rec.element_information15, hr_api.g_varchar2) <>
223: nvl(p_rec.element_information15, hr_api.g_varchar2) or
224: nvl(pay_etp_shd_nd.g_old_rec.element_information16, hr_api.g_varchar2) <>

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

217: nvl(p_rec.element_information12, hr_api.g_varchar2) or
218: nvl(pay_etp_shd_nd.g_old_rec.element_information13, hr_api.g_varchar2) <>
219: nvl(p_rec.element_information13, hr_api.g_varchar2) or
220: nvl(pay_etp_shd_nd.g_old_rec.element_information14, hr_api.g_varchar2) <>
221: nvl(p_rec.element_information14, hr_api.g_varchar2) or
222: nvl(pay_etp_shd_nd.g_old_rec.element_information15, hr_api.g_varchar2) <>
223: nvl(p_rec.element_information15, hr_api.g_varchar2) or
224: nvl(pay_etp_shd_nd.g_old_rec.element_information16, hr_api.g_varchar2) <>
225: nvl(p_rec.element_information16, hr_api.g_varchar2) or

Line 222: nvl(pay_etp_shd_nd.g_old_rec.element_information15, hr_api.g_varchar2) <>

218: nvl(pay_etp_shd_nd.g_old_rec.element_information13, hr_api.g_varchar2) <>
219: nvl(p_rec.element_information13, hr_api.g_varchar2) or
220: nvl(pay_etp_shd_nd.g_old_rec.element_information14, hr_api.g_varchar2) <>
221: nvl(p_rec.element_information14, hr_api.g_varchar2) or
222: nvl(pay_etp_shd_nd.g_old_rec.element_information15, hr_api.g_varchar2) <>
223: nvl(p_rec.element_information15, hr_api.g_varchar2) or
224: nvl(pay_etp_shd_nd.g_old_rec.element_information16, hr_api.g_varchar2) <>
225: nvl(p_rec.element_information16, hr_api.g_varchar2) or
226: nvl(pay_etp_shd_nd.g_old_rec.element_information17, hr_api.g_varchar2) <>

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

219: nvl(p_rec.element_information13, hr_api.g_varchar2) or
220: nvl(pay_etp_shd_nd.g_old_rec.element_information14, hr_api.g_varchar2) <>
221: nvl(p_rec.element_information14, hr_api.g_varchar2) or
222: nvl(pay_etp_shd_nd.g_old_rec.element_information15, hr_api.g_varchar2) <>
223: nvl(p_rec.element_information15, hr_api.g_varchar2) or
224: nvl(pay_etp_shd_nd.g_old_rec.element_information16, hr_api.g_varchar2) <>
225: nvl(p_rec.element_information16, hr_api.g_varchar2) or
226: nvl(pay_etp_shd_nd.g_old_rec.element_information17, hr_api.g_varchar2) <>
227: nvl(p_rec.element_information17, hr_api.g_varchar2) or

Line 224: nvl(pay_etp_shd_nd.g_old_rec.element_information16, hr_api.g_varchar2) <>

220: nvl(pay_etp_shd_nd.g_old_rec.element_information14, hr_api.g_varchar2) <>
221: nvl(p_rec.element_information14, hr_api.g_varchar2) or
222: nvl(pay_etp_shd_nd.g_old_rec.element_information15, hr_api.g_varchar2) <>
223: nvl(p_rec.element_information15, hr_api.g_varchar2) or
224: nvl(pay_etp_shd_nd.g_old_rec.element_information16, hr_api.g_varchar2) <>
225: nvl(p_rec.element_information16, hr_api.g_varchar2) or
226: nvl(pay_etp_shd_nd.g_old_rec.element_information17, hr_api.g_varchar2) <>
227: nvl(p_rec.element_information17, hr_api.g_varchar2) or
228: nvl(pay_etp_shd_nd.g_old_rec.element_information18, hr_api.g_varchar2) <>

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

221: nvl(p_rec.element_information14, hr_api.g_varchar2) or
222: nvl(pay_etp_shd_nd.g_old_rec.element_information15, hr_api.g_varchar2) <>
223: nvl(p_rec.element_information15, hr_api.g_varchar2) or
224: nvl(pay_etp_shd_nd.g_old_rec.element_information16, hr_api.g_varchar2) <>
225: nvl(p_rec.element_information16, hr_api.g_varchar2) or
226: nvl(pay_etp_shd_nd.g_old_rec.element_information17, hr_api.g_varchar2) <>
227: nvl(p_rec.element_information17, hr_api.g_varchar2) or
228: nvl(pay_etp_shd_nd.g_old_rec.element_information18, hr_api.g_varchar2) <>
229: nvl(p_rec.element_information18, hr_api.g_varchar2) or

Line 226: nvl(pay_etp_shd_nd.g_old_rec.element_information17, hr_api.g_varchar2) <>

222: nvl(pay_etp_shd_nd.g_old_rec.element_information15, hr_api.g_varchar2) <>
223: nvl(p_rec.element_information15, hr_api.g_varchar2) or
224: nvl(pay_etp_shd_nd.g_old_rec.element_information16, hr_api.g_varchar2) <>
225: nvl(p_rec.element_information16, hr_api.g_varchar2) or
226: nvl(pay_etp_shd_nd.g_old_rec.element_information17, hr_api.g_varchar2) <>
227: nvl(p_rec.element_information17, hr_api.g_varchar2) or
228: nvl(pay_etp_shd_nd.g_old_rec.element_information18, hr_api.g_varchar2) <>
229: nvl(p_rec.element_information18, hr_api.g_varchar2) or
230: nvl(pay_etp_shd_nd.g_old_rec.element_information19, hr_api.g_varchar2) <>

Line 227: nvl(p_rec.element_information17, hr_api.g_varchar2) or

223: nvl(p_rec.element_information15, hr_api.g_varchar2) or
224: nvl(pay_etp_shd_nd.g_old_rec.element_information16, hr_api.g_varchar2) <>
225: nvl(p_rec.element_information16, hr_api.g_varchar2) or
226: nvl(pay_etp_shd_nd.g_old_rec.element_information17, hr_api.g_varchar2) <>
227: nvl(p_rec.element_information17, hr_api.g_varchar2) or
228: nvl(pay_etp_shd_nd.g_old_rec.element_information18, hr_api.g_varchar2) <>
229: nvl(p_rec.element_information18, hr_api.g_varchar2) or
230: nvl(pay_etp_shd_nd.g_old_rec.element_information19, hr_api.g_varchar2) <>
231: nvl(p_rec.element_information19, hr_api.g_varchar2) or

Line 228: nvl(pay_etp_shd_nd.g_old_rec.element_information18, hr_api.g_varchar2) <>

224: nvl(pay_etp_shd_nd.g_old_rec.element_information16, hr_api.g_varchar2) <>
225: nvl(p_rec.element_information16, hr_api.g_varchar2) or
226: nvl(pay_etp_shd_nd.g_old_rec.element_information17, hr_api.g_varchar2) <>
227: nvl(p_rec.element_information17, hr_api.g_varchar2) or
228: nvl(pay_etp_shd_nd.g_old_rec.element_information18, hr_api.g_varchar2) <>
229: nvl(p_rec.element_information18, hr_api.g_varchar2) or
230: nvl(pay_etp_shd_nd.g_old_rec.element_information19, hr_api.g_varchar2) <>
231: nvl(p_rec.element_information19, hr_api.g_varchar2) or
232: nvl(pay_etp_shd_nd.g_old_rec.element_information20, hr_api.g_varchar2) <>

Line 229: nvl(p_rec.element_information18, hr_api.g_varchar2) or

225: nvl(p_rec.element_information16, hr_api.g_varchar2) or
226: nvl(pay_etp_shd_nd.g_old_rec.element_information17, hr_api.g_varchar2) <>
227: nvl(p_rec.element_information17, hr_api.g_varchar2) or
228: nvl(pay_etp_shd_nd.g_old_rec.element_information18, hr_api.g_varchar2) <>
229: nvl(p_rec.element_information18, hr_api.g_varchar2) or
230: nvl(pay_etp_shd_nd.g_old_rec.element_information19, hr_api.g_varchar2) <>
231: nvl(p_rec.element_information19, hr_api.g_varchar2) or
232: nvl(pay_etp_shd_nd.g_old_rec.element_information20, hr_api.g_varchar2) <>
233: nvl(p_rec.element_information20, hr_api.g_varchar2) ))

Line 230: nvl(pay_etp_shd_nd.g_old_rec.element_information19, hr_api.g_varchar2) <>

226: nvl(pay_etp_shd_nd.g_old_rec.element_information17, hr_api.g_varchar2) <>
227: nvl(p_rec.element_information17, hr_api.g_varchar2) or
228: nvl(pay_etp_shd_nd.g_old_rec.element_information18, hr_api.g_varchar2) <>
229: nvl(p_rec.element_information18, hr_api.g_varchar2) or
230: nvl(pay_etp_shd_nd.g_old_rec.element_information19, hr_api.g_varchar2) <>
231: nvl(p_rec.element_information19, hr_api.g_varchar2) or
232: nvl(pay_etp_shd_nd.g_old_rec.element_information20, hr_api.g_varchar2) <>
233: nvl(p_rec.element_information20, hr_api.g_varchar2) ))
234: or (p_rec.element_type_id is null) then

Line 231: nvl(p_rec.element_information19, hr_api.g_varchar2) or

227: nvl(p_rec.element_information17, hr_api.g_varchar2) or
228: nvl(pay_etp_shd_nd.g_old_rec.element_information18, hr_api.g_varchar2) <>
229: nvl(p_rec.element_information18, hr_api.g_varchar2) or
230: nvl(pay_etp_shd_nd.g_old_rec.element_information19, hr_api.g_varchar2) <>
231: nvl(p_rec.element_information19, hr_api.g_varchar2) or
232: nvl(pay_etp_shd_nd.g_old_rec.element_information20, hr_api.g_varchar2) <>
233: nvl(p_rec.element_information20, hr_api.g_varchar2) ))
234: or (p_rec.element_type_id is null) then
235: --

Line 232: nvl(pay_etp_shd_nd.g_old_rec.element_information20, hr_api.g_varchar2) <>

228: nvl(pay_etp_shd_nd.g_old_rec.element_information18, hr_api.g_varchar2) <>
229: nvl(p_rec.element_information18, hr_api.g_varchar2) or
230: nvl(pay_etp_shd_nd.g_old_rec.element_information19, hr_api.g_varchar2) <>
231: nvl(p_rec.element_information19, hr_api.g_varchar2) or
232: nvl(pay_etp_shd_nd.g_old_rec.element_information20, hr_api.g_varchar2) <>
233: nvl(p_rec.element_information20, hr_api.g_varchar2) ))
234: or (p_rec.element_type_id is null) then
235: --
236: -- Only execute the validation if absolutely necessary:

Line 233: nvl(p_rec.element_information20, hr_api.g_varchar2) ))

229: nvl(p_rec.element_information18, hr_api.g_varchar2) or
230: nvl(pay_etp_shd_nd.g_old_rec.element_information19, hr_api.g_varchar2) <>
231: nvl(p_rec.element_information19, hr_api.g_varchar2) or
232: nvl(pay_etp_shd_nd.g_old_rec.element_information20, hr_api.g_varchar2) <>
233: nvl(p_rec.element_information20, hr_api.g_varchar2) ))
234: or (p_rec.element_type_id is null) then
235: --
236: -- Only execute the validation if absolutely necessary:
237: -- a) During update, the structure column value or any

Line 330: nvl(pay_etp_shd_nd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

326: begin
327: hr_utility.set_location('Entering:'||l_proc,10);
328: --
329: if ((p_rec.element_type_id is not null) and (
330: nvl(pay_etp_shd_nd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
332: nvl(pay_etp_shd_nd.g_old_rec.attribute1, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute1, hr_api.g_varchar2) or
334: nvl(pay_etp_shd_nd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

327: hr_utility.set_location('Entering:'||l_proc,10);
328: --
329: if ((p_rec.element_type_id is not null) and (
330: nvl(pay_etp_shd_nd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
332: nvl(pay_etp_shd_nd.g_old_rec.attribute1, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute1, hr_api.g_varchar2) or
334: nvl(pay_etp_shd_nd.g_old_rec.attribute2, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 332: nvl(pay_etp_shd_nd.g_old_rec.attribute1, hr_api.g_varchar2) <>

328: --
329: if ((p_rec.element_type_id is not null) and (
330: nvl(pay_etp_shd_nd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
332: nvl(pay_etp_shd_nd.g_old_rec.attribute1, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute1, hr_api.g_varchar2) or
334: nvl(pay_etp_shd_nd.g_old_rec.attribute2, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute2, hr_api.g_varchar2) or
336: nvl(pay_etp_shd_nd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

329: if ((p_rec.element_type_id is not null) and (
330: nvl(pay_etp_shd_nd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
332: nvl(pay_etp_shd_nd.g_old_rec.attribute1, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute1, hr_api.g_varchar2) or
334: nvl(pay_etp_shd_nd.g_old_rec.attribute2, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute2, hr_api.g_varchar2) or
336: nvl(pay_etp_shd_nd.g_old_rec.attribute3, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 334: nvl(pay_etp_shd_nd.g_old_rec.attribute2, hr_api.g_varchar2) <>

330: nvl(pay_etp_shd_nd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
332: nvl(pay_etp_shd_nd.g_old_rec.attribute1, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute1, hr_api.g_varchar2) or
334: nvl(pay_etp_shd_nd.g_old_rec.attribute2, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute2, hr_api.g_varchar2) or
336: nvl(pay_etp_shd_nd.g_old_rec.attribute3, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute3, hr_api.g_varchar2) or
338: nvl(pay_etp_shd_nd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

331: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
332: nvl(pay_etp_shd_nd.g_old_rec.attribute1, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute1, hr_api.g_varchar2) or
334: nvl(pay_etp_shd_nd.g_old_rec.attribute2, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute2, hr_api.g_varchar2) or
336: nvl(pay_etp_shd_nd.g_old_rec.attribute3, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute3, hr_api.g_varchar2) or
338: nvl(pay_etp_shd_nd.g_old_rec.attribute4, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 336: nvl(pay_etp_shd_nd.g_old_rec.attribute3, hr_api.g_varchar2) <>

332: nvl(pay_etp_shd_nd.g_old_rec.attribute1, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute1, hr_api.g_varchar2) or
334: nvl(pay_etp_shd_nd.g_old_rec.attribute2, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute2, hr_api.g_varchar2) or
336: nvl(pay_etp_shd_nd.g_old_rec.attribute3, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute3, hr_api.g_varchar2) or
338: nvl(pay_etp_shd_nd.g_old_rec.attribute4, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute4, hr_api.g_varchar2) or
340: nvl(pay_etp_shd_nd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

333: nvl(p_rec.attribute1, hr_api.g_varchar2) or
334: nvl(pay_etp_shd_nd.g_old_rec.attribute2, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute2, hr_api.g_varchar2) or
336: nvl(pay_etp_shd_nd.g_old_rec.attribute3, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute3, hr_api.g_varchar2) or
338: nvl(pay_etp_shd_nd.g_old_rec.attribute4, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute4, hr_api.g_varchar2) or
340: nvl(pay_etp_shd_nd.g_old_rec.attribute5, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 338: nvl(pay_etp_shd_nd.g_old_rec.attribute4, hr_api.g_varchar2) <>

334: nvl(pay_etp_shd_nd.g_old_rec.attribute2, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute2, hr_api.g_varchar2) or
336: nvl(pay_etp_shd_nd.g_old_rec.attribute3, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute3, hr_api.g_varchar2) or
338: nvl(pay_etp_shd_nd.g_old_rec.attribute4, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute4, hr_api.g_varchar2) or
340: nvl(pay_etp_shd_nd.g_old_rec.attribute5, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute5, hr_api.g_varchar2) or
342: nvl(pay_etp_shd_nd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

335: nvl(p_rec.attribute2, hr_api.g_varchar2) or
336: nvl(pay_etp_shd_nd.g_old_rec.attribute3, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute3, hr_api.g_varchar2) or
338: nvl(pay_etp_shd_nd.g_old_rec.attribute4, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute4, hr_api.g_varchar2) or
340: nvl(pay_etp_shd_nd.g_old_rec.attribute5, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute5, hr_api.g_varchar2) or
342: nvl(pay_etp_shd_nd.g_old_rec.attribute6, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 340: nvl(pay_etp_shd_nd.g_old_rec.attribute5, hr_api.g_varchar2) <>

336: nvl(pay_etp_shd_nd.g_old_rec.attribute3, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute3, hr_api.g_varchar2) or
338: nvl(pay_etp_shd_nd.g_old_rec.attribute4, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute4, hr_api.g_varchar2) or
340: nvl(pay_etp_shd_nd.g_old_rec.attribute5, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute5, hr_api.g_varchar2) or
342: nvl(pay_etp_shd_nd.g_old_rec.attribute6, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute6, hr_api.g_varchar2) or
344: nvl(pay_etp_shd_nd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

337: nvl(p_rec.attribute3, hr_api.g_varchar2) or
338: nvl(pay_etp_shd_nd.g_old_rec.attribute4, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute4, hr_api.g_varchar2) or
340: nvl(pay_etp_shd_nd.g_old_rec.attribute5, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute5, hr_api.g_varchar2) or
342: nvl(pay_etp_shd_nd.g_old_rec.attribute6, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute6, hr_api.g_varchar2) or
344: nvl(pay_etp_shd_nd.g_old_rec.attribute7, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 342: nvl(pay_etp_shd_nd.g_old_rec.attribute6, hr_api.g_varchar2) <>

338: nvl(pay_etp_shd_nd.g_old_rec.attribute4, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute4, hr_api.g_varchar2) or
340: nvl(pay_etp_shd_nd.g_old_rec.attribute5, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute5, hr_api.g_varchar2) or
342: nvl(pay_etp_shd_nd.g_old_rec.attribute6, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute6, hr_api.g_varchar2) or
344: nvl(pay_etp_shd_nd.g_old_rec.attribute7, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute7, hr_api.g_varchar2) or
346: nvl(pay_etp_shd_nd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

339: nvl(p_rec.attribute4, hr_api.g_varchar2) or
340: nvl(pay_etp_shd_nd.g_old_rec.attribute5, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute5, hr_api.g_varchar2) or
342: nvl(pay_etp_shd_nd.g_old_rec.attribute6, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute6, hr_api.g_varchar2) or
344: nvl(pay_etp_shd_nd.g_old_rec.attribute7, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute7, hr_api.g_varchar2) or
346: nvl(pay_etp_shd_nd.g_old_rec.attribute8, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 344: nvl(pay_etp_shd_nd.g_old_rec.attribute7, hr_api.g_varchar2) <>

340: nvl(pay_etp_shd_nd.g_old_rec.attribute5, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute5, hr_api.g_varchar2) or
342: nvl(pay_etp_shd_nd.g_old_rec.attribute6, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute6, hr_api.g_varchar2) or
344: nvl(pay_etp_shd_nd.g_old_rec.attribute7, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute7, hr_api.g_varchar2) or
346: nvl(pay_etp_shd_nd.g_old_rec.attribute8, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute8, hr_api.g_varchar2) or
348: nvl(pay_etp_shd_nd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

341: nvl(p_rec.attribute5, hr_api.g_varchar2) or
342: nvl(pay_etp_shd_nd.g_old_rec.attribute6, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute6, hr_api.g_varchar2) or
344: nvl(pay_etp_shd_nd.g_old_rec.attribute7, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute7, hr_api.g_varchar2) or
346: nvl(pay_etp_shd_nd.g_old_rec.attribute8, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute8, hr_api.g_varchar2) or
348: nvl(pay_etp_shd_nd.g_old_rec.attribute9, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 346: nvl(pay_etp_shd_nd.g_old_rec.attribute8, hr_api.g_varchar2) <>

342: nvl(pay_etp_shd_nd.g_old_rec.attribute6, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute6, hr_api.g_varchar2) or
344: nvl(pay_etp_shd_nd.g_old_rec.attribute7, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute7, hr_api.g_varchar2) or
346: nvl(pay_etp_shd_nd.g_old_rec.attribute8, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute8, hr_api.g_varchar2) or
348: nvl(pay_etp_shd_nd.g_old_rec.attribute9, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute9, hr_api.g_varchar2) or
350: nvl(pay_etp_shd_nd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

343: nvl(p_rec.attribute6, hr_api.g_varchar2) or
344: nvl(pay_etp_shd_nd.g_old_rec.attribute7, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute7, hr_api.g_varchar2) or
346: nvl(pay_etp_shd_nd.g_old_rec.attribute8, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute8, hr_api.g_varchar2) or
348: nvl(pay_etp_shd_nd.g_old_rec.attribute9, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute9, hr_api.g_varchar2) or
350: nvl(pay_etp_shd_nd.g_old_rec.attribute10, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 348: nvl(pay_etp_shd_nd.g_old_rec.attribute9, hr_api.g_varchar2) <>

344: nvl(pay_etp_shd_nd.g_old_rec.attribute7, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute7, hr_api.g_varchar2) or
346: nvl(pay_etp_shd_nd.g_old_rec.attribute8, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute8, hr_api.g_varchar2) or
348: nvl(pay_etp_shd_nd.g_old_rec.attribute9, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute9, hr_api.g_varchar2) or
350: nvl(pay_etp_shd_nd.g_old_rec.attribute10, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute10, hr_api.g_varchar2) or
352: nvl(pay_etp_shd_nd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

345: nvl(p_rec.attribute7, hr_api.g_varchar2) or
346: nvl(pay_etp_shd_nd.g_old_rec.attribute8, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute8, hr_api.g_varchar2) or
348: nvl(pay_etp_shd_nd.g_old_rec.attribute9, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute9, hr_api.g_varchar2) or
350: nvl(pay_etp_shd_nd.g_old_rec.attribute10, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute10, hr_api.g_varchar2) or
352: nvl(pay_etp_shd_nd.g_old_rec.attribute11, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 350: nvl(pay_etp_shd_nd.g_old_rec.attribute10, hr_api.g_varchar2) <>

346: nvl(pay_etp_shd_nd.g_old_rec.attribute8, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute8, hr_api.g_varchar2) or
348: nvl(pay_etp_shd_nd.g_old_rec.attribute9, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute9, hr_api.g_varchar2) or
350: nvl(pay_etp_shd_nd.g_old_rec.attribute10, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute10, hr_api.g_varchar2) or
352: nvl(pay_etp_shd_nd.g_old_rec.attribute11, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute11, hr_api.g_varchar2) or
354: nvl(pay_etp_shd_nd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

347: nvl(p_rec.attribute8, hr_api.g_varchar2) or
348: nvl(pay_etp_shd_nd.g_old_rec.attribute9, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute9, hr_api.g_varchar2) or
350: nvl(pay_etp_shd_nd.g_old_rec.attribute10, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute10, hr_api.g_varchar2) or
352: nvl(pay_etp_shd_nd.g_old_rec.attribute11, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute11, hr_api.g_varchar2) or
354: nvl(pay_etp_shd_nd.g_old_rec.attribute12, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 352: nvl(pay_etp_shd_nd.g_old_rec.attribute11, hr_api.g_varchar2) <>

348: nvl(pay_etp_shd_nd.g_old_rec.attribute9, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute9, hr_api.g_varchar2) or
350: nvl(pay_etp_shd_nd.g_old_rec.attribute10, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute10, hr_api.g_varchar2) or
352: nvl(pay_etp_shd_nd.g_old_rec.attribute11, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute11, hr_api.g_varchar2) or
354: nvl(pay_etp_shd_nd.g_old_rec.attribute12, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute12, hr_api.g_varchar2) or
356: nvl(pay_etp_shd_nd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

349: nvl(p_rec.attribute9, hr_api.g_varchar2) or
350: nvl(pay_etp_shd_nd.g_old_rec.attribute10, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute10, hr_api.g_varchar2) or
352: nvl(pay_etp_shd_nd.g_old_rec.attribute11, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute11, hr_api.g_varchar2) or
354: nvl(pay_etp_shd_nd.g_old_rec.attribute12, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute12, hr_api.g_varchar2) or
356: nvl(pay_etp_shd_nd.g_old_rec.attribute13, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 354: nvl(pay_etp_shd_nd.g_old_rec.attribute12, hr_api.g_varchar2) <>

350: nvl(pay_etp_shd_nd.g_old_rec.attribute10, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute10, hr_api.g_varchar2) or
352: nvl(pay_etp_shd_nd.g_old_rec.attribute11, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute11, hr_api.g_varchar2) or
354: nvl(pay_etp_shd_nd.g_old_rec.attribute12, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute12, hr_api.g_varchar2) or
356: nvl(pay_etp_shd_nd.g_old_rec.attribute13, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute13, hr_api.g_varchar2) or
358: nvl(pay_etp_shd_nd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

351: nvl(p_rec.attribute10, hr_api.g_varchar2) or
352: nvl(pay_etp_shd_nd.g_old_rec.attribute11, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute11, hr_api.g_varchar2) or
354: nvl(pay_etp_shd_nd.g_old_rec.attribute12, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute12, hr_api.g_varchar2) or
356: nvl(pay_etp_shd_nd.g_old_rec.attribute13, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute13, hr_api.g_varchar2) or
358: nvl(pay_etp_shd_nd.g_old_rec.attribute14, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 356: nvl(pay_etp_shd_nd.g_old_rec.attribute13, hr_api.g_varchar2) <>

352: nvl(pay_etp_shd_nd.g_old_rec.attribute11, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute11, hr_api.g_varchar2) or
354: nvl(pay_etp_shd_nd.g_old_rec.attribute12, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute12, hr_api.g_varchar2) or
356: nvl(pay_etp_shd_nd.g_old_rec.attribute13, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute13, hr_api.g_varchar2) or
358: nvl(pay_etp_shd_nd.g_old_rec.attribute14, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute14, hr_api.g_varchar2) or
360: nvl(pay_etp_shd_nd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

353: nvl(p_rec.attribute11, hr_api.g_varchar2) or
354: nvl(pay_etp_shd_nd.g_old_rec.attribute12, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute12, hr_api.g_varchar2) or
356: nvl(pay_etp_shd_nd.g_old_rec.attribute13, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute13, hr_api.g_varchar2) or
358: nvl(pay_etp_shd_nd.g_old_rec.attribute14, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute14, hr_api.g_varchar2) or
360: nvl(pay_etp_shd_nd.g_old_rec.attribute15, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 358: nvl(pay_etp_shd_nd.g_old_rec.attribute14, hr_api.g_varchar2) <>

354: nvl(pay_etp_shd_nd.g_old_rec.attribute12, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute12, hr_api.g_varchar2) or
356: nvl(pay_etp_shd_nd.g_old_rec.attribute13, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute13, hr_api.g_varchar2) or
358: nvl(pay_etp_shd_nd.g_old_rec.attribute14, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute14, hr_api.g_varchar2) or
360: nvl(pay_etp_shd_nd.g_old_rec.attribute15, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute15, hr_api.g_varchar2) or
362: nvl(pay_etp_shd_nd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

355: nvl(p_rec.attribute12, hr_api.g_varchar2) or
356: nvl(pay_etp_shd_nd.g_old_rec.attribute13, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute13, hr_api.g_varchar2) or
358: nvl(pay_etp_shd_nd.g_old_rec.attribute14, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute14, hr_api.g_varchar2) or
360: nvl(pay_etp_shd_nd.g_old_rec.attribute15, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute15, hr_api.g_varchar2) or
362: nvl(pay_etp_shd_nd.g_old_rec.attribute16, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 360: nvl(pay_etp_shd_nd.g_old_rec.attribute15, hr_api.g_varchar2) <>

356: nvl(pay_etp_shd_nd.g_old_rec.attribute13, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute13, hr_api.g_varchar2) or
358: nvl(pay_etp_shd_nd.g_old_rec.attribute14, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute14, hr_api.g_varchar2) or
360: nvl(pay_etp_shd_nd.g_old_rec.attribute15, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute15, hr_api.g_varchar2) or
362: nvl(pay_etp_shd_nd.g_old_rec.attribute16, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute16, hr_api.g_varchar2) or
364: nvl(pay_etp_shd_nd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

357: nvl(p_rec.attribute13, hr_api.g_varchar2) or
358: nvl(pay_etp_shd_nd.g_old_rec.attribute14, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute14, hr_api.g_varchar2) or
360: nvl(pay_etp_shd_nd.g_old_rec.attribute15, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute15, hr_api.g_varchar2) or
362: nvl(pay_etp_shd_nd.g_old_rec.attribute16, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute16, hr_api.g_varchar2) or
364: nvl(pay_etp_shd_nd.g_old_rec.attribute17, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 362: nvl(pay_etp_shd_nd.g_old_rec.attribute16, hr_api.g_varchar2) <>

358: nvl(pay_etp_shd_nd.g_old_rec.attribute14, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute14, hr_api.g_varchar2) or
360: nvl(pay_etp_shd_nd.g_old_rec.attribute15, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute15, hr_api.g_varchar2) or
362: nvl(pay_etp_shd_nd.g_old_rec.attribute16, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute16, hr_api.g_varchar2) or
364: nvl(pay_etp_shd_nd.g_old_rec.attribute17, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute17, hr_api.g_varchar2) or
366: nvl(pay_etp_shd_nd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

359: nvl(p_rec.attribute14, hr_api.g_varchar2) or
360: nvl(pay_etp_shd_nd.g_old_rec.attribute15, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute15, hr_api.g_varchar2) or
362: nvl(pay_etp_shd_nd.g_old_rec.attribute16, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute16, hr_api.g_varchar2) or
364: nvl(pay_etp_shd_nd.g_old_rec.attribute17, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute17, hr_api.g_varchar2) or
366: nvl(pay_etp_shd_nd.g_old_rec.attribute18, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 364: nvl(pay_etp_shd_nd.g_old_rec.attribute17, hr_api.g_varchar2) <>

360: nvl(pay_etp_shd_nd.g_old_rec.attribute15, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute15, hr_api.g_varchar2) or
362: nvl(pay_etp_shd_nd.g_old_rec.attribute16, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute16, hr_api.g_varchar2) or
364: nvl(pay_etp_shd_nd.g_old_rec.attribute17, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute17, hr_api.g_varchar2) or
366: nvl(pay_etp_shd_nd.g_old_rec.attribute18, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute18, hr_api.g_varchar2) or
368: nvl(pay_etp_shd_nd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

361: nvl(p_rec.attribute15, hr_api.g_varchar2) or
362: nvl(pay_etp_shd_nd.g_old_rec.attribute16, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute16, hr_api.g_varchar2) or
364: nvl(pay_etp_shd_nd.g_old_rec.attribute17, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute17, hr_api.g_varchar2) or
366: nvl(pay_etp_shd_nd.g_old_rec.attribute18, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute18, hr_api.g_varchar2) or
368: nvl(pay_etp_shd_nd.g_old_rec.attribute19, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 366: nvl(pay_etp_shd_nd.g_old_rec.attribute18, hr_api.g_varchar2) <>

362: nvl(pay_etp_shd_nd.g_old_rec.attribute16, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute16, hr_api.g_varchar2) or
364: nvl(pay_etp_shd_nd.g_old_rec.attribute17, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute17, hr_api.g_varchar2) or
366: nvl(pay_etp_shd_nd.g_old_rec.attribute18, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute18, hr_api.g_varchar2) or
368: nvl(pay_etp_shd_nd.g_old_rec.attribute19, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute19, hr_api.g_varchar2) or
370: nvl(pay_etp_shd_nd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

363: nvl(p_rec.attribute16, hr_api.g_varchar2) or
364: nvl(pay_etp_shd_nd.g_old_rec.attribute17, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute17, hr_api.g_varchar2) or
366: nvl(pay_etp_shd_nd.g_old_rec.attribute18, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute18, hr_api.g_varchar2) or
368: nvl(pay_etp_shd_nd.g_old_rec.attribute19, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute19, hr_api.g_varchar2) or
370: nvl(pay_etp_shd_nd.g_old_rec.attribute20, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

Line 368: nvl(pay_etp_shd_nd.g_old_rec.attribute19, hr_api.g_varchar2) <>

364: nvl(pay_etp_shd_nd.g_old_rec.attribute17, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute17, hr_api.g_varchar2) or
366: nvl(pay_etp_shd_nd.g_old_rec.attribute18, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute18, hr_api.g_varchar2) or
368: nvl(pay_etp_shd_nd.g_old_rec.attribute19, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute19, hr_api.g_varchar2) or
370: nvl(pay_etp_shd_nd.g_old_rec.attribute20, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
372: or (p_rec.element_type_id is null) then

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

365: nvl(p_rec.attribute17, hr_api.g_varchar2) or
366: nvl(pay_etp_shd_nd.g_old_rec.attribute18, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute18, hr_api.g_varchar2) or
368: nvl(pay_etp_shd_nd.g_old_rec.attribute19, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute19, hr_api.g_varchar2) or
370: nvl(pay_etp_shd_nd.g_old_rec.attribute20, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
372: or (p_rec.element_type_id is null) then
373: --

Line 370: nvl(pay_etp_shd_nd.g_old_rec.attribute20, hr_api.g_varchar2) <>

366: nvl(pay_etp_shd_nd.g_old_rec.attribute18, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute18, hr_api.g_varchar2) or
368: nvl(pay_etp_shd_nd.g_old_rec.attribute19, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute19, hr_api.g_varchar2) or
370: nvl(pay_etp_shd_nd.g_old_rec.attribute20, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
372: or (p_rec.element_type_id is null) then
373: --
374: -- Only execute the validation if absolutely necessary:

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

367: nvl(p_rec.attribute18, hr_api.g_varchar2) or
368: nvl(pay_etp_shd_nd.g_old_rec.attribute19, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute19, hr_api.g_varchar2) or
370: nvl(pay_etp_shd_nd.g_old_rec.attribute20, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
372: or (p_rec.element_type_id is null) then
373: --
374: -- Only execute the validation if absolutely necessary:
375: -- a) During update, the structure column value or any

Line 523: hr_api.mandatory_arg_error

519: Begin
520: --
521: -- Ensure that the p_datetrack_mode argument is not null
522: --
523: hr_api.mandatory_arg_error
524: (p_api_name => l_proc
525: ,p_argument => 'datetrack_mode'
526: ,p_argument_value => p_datetrack_mode
527: );

Line 533: hr_api.mandatory_arg_error

529: -- Mode will be valid, as this is checked at the start of the upd.
530: --
531: -- Ensure the arguments are not null
532: --
533: hr_api.mandatory_arg_error
534: (p_api_name => l_proc
535: ,p_argument => 'validation_start_date'
536: ,p_argument_value => p_validation_start_date
537: );

Line 539: hr_api.mandatory_arg_error

535: ,p_argument => 'validation_start_date'
536: ,p_argument_value => p_validation_start_date
537: );
538: --
539: hr_api.mandatory_arg_error
540: (p_api_name => l_proc
541: ,p_argument => 'validation_end_date'
542: ,p_argument_value => p_validation_end_date
543: );

Line 607: hr_api.mandatory_arg_error

603: Begin
604: --
605: -- Ensure that the p_datetrack_mode argument is not null
606: --
607: hr_api.mandatory_arg_error
608: (p_api_name => l_proc
609: ,p_argument => 'datetrack_mode'
610: ,p_argument_value => p_datetrack_mode
611: );

Line 616: If (p_datetrack_mode = hr_api.g_delete or

612: --
613: -- Only perform the validation if the datetrack mode is either
614: -- DELETE or ZAP
615: --
616: If (p_datetrack_mode = hr_api.g_delete or
617: p_datetrack_mode = hr_api.g_zap) then
618: --
619: --
620: -- Ensure the arguments are not null

Line 617: p_datetrack_mode = hr_api.g_zap) then

613: -- Only perform the validation if the datetrack mode is either
614: -- DELETE or ZAP
615: --
616: If (p_datetrack_mode = hr_api.g_delete or
617: p_datetrack_mode = hr_api.g_zap) then
618: --
619: --
620: -- Ensure the arguments are not null
621: --

Line 622: hr_api.mandatory_arg_error

618: --
619: --
620: -- Ensure the arguments are not null
621: --
622: hr_api.mandatory_arg_error
623: (p_api_name => l_proc
624: ,p_argument => 'validation_start_date'
625: ,p_argument_value => p_validation_start_date
626: );

Line 628: hr_api.mandatory_arg_error

624: ,p_argument => 'validation_start_date'
625: ,p_argument_value => p_validation_start_date
626: );
627: --
628: hr_api.mandatory_arg_error
629: (p_api_name => l_proc
630: ,p_argument => 'validation_end_date'
631: ,p_argument_value => p_validation_end_date
632: );

Line 634: hr_api.mandatory_arg_error

630: ,p_argument => 'validation_end_date'
631: ,p_argument_value => p_validation_end_date
632: );
633: --
634: hr_api.mandatory_arg_error
635: (p_api_name => l_proc
636: ,p_argument => 'element_type_id'
637: ,p_argument_value => p_element_type_id
638: );

Line 763: -- and nvl(date_to, hr_api.g_eot);

759: select '1'
760: from hr_all_organization_units
761: where business_group_id = p_business_group_id;
762: -- and p_effective_date between date_from
763: -- and nvl(date_to, hr_api.g_eot);
764: --
765: Begin
766: hr_utility.set_location('Entering:'||l_proc, 5);
767: --

Line 997: where legislation_code = hr_api.return_legislation_code

993: Cursor c_leg_rule_currency
994: is
995: select rule_mode
996: from pay_legislation_rules
997: where legislation_code = hr_api.return_legislation_code
998: (p_business_group_id)
999: and rule_type = 'DC';
1000: --
1001: Begin

Line 1187: If hr_api.not_exists_in_hr_lookups

1183: --
1184: Begin
1185: hr_utility.set_location('Entering:'||l_proc, 5);
1186: --
1187: If hr_api.not_exists_in_hr_lookups
1188: (p_effective_date
1189: ,'YES_NO'
1190: ,p_addl_entry_allowed_flag) Then
1191: --

Line 1254: If hr_api.not_exists_in_hr_lookups

1250: --
1251: Begin
1252: hr_utility.set_location('Entering:'||l_proc, 5);
1253: --
1254: If hr_api.not_exists_in_hr_lookups
1255: (p_effective_date
1256: ,'YES_NO'
1257: ,p_adjustment_only_flag) Then
1258: --

Line 1266: If hr_api.not_exists_in_hr_lookups

1262: fnd_message.raise_error;
1263: --
1264: End If;
1265: --
1266: If hr_api.not_exists_in_hr_lookups
1267: (p_effective_date
1268: ,'YES_NO'
1269: ,p_closed_for_entry_flag) Then
1270: --

Line 1445: If hr_api.not_exists_in_hr_lookups

1441: --
1442: Begin
1443: hr_utility.set_location('Entering:'||l_proc, 5);
1444: --
1445: If hr_api.not_exists_in_hr_lookups
1446: (p_effective_date
1447: ,'YES_NO'
1448: ,p_multiple_entries_allowed_flg) Then
1449: --

Line 1542: If hr_api.not_exists_in_hr_lookups

1538: --
1539: Begin
1540: hr_utility.set_location('Entering:'||l_proc, 5);
1541: --
1542: If hr_api.not_exists_in_hr_lookups
1543: (p_effective_date
1544: ,'YES_NO'
1545: ,p_process_in_run_flag) Then
1546: --

Line 1554: If hr_api.not_exists_in_hr_lookups

1550: fnd_message.raise_error;
1551: --
1552: End If;
1553: --
1554: If hr_api.not_exists_in_hr_lookups
1555: (p_effective_date
1556: ,'YES_NO'
1557: ,p_indirect_only_flag) Then
1558: --

Line 1566: If hr_api.not_exists_in_hr_lookups

1562: fnd_message.raise_error;
1563: --
1564: End If;
1565: --
1566: If hr_api.not_exists_in_hr_lookups
1567: (p_effective_date
1568: ,'YES_NO'
1569: ,p_multiply_value_flag) Then
1570: --

Line 1578: If hr_api.not_exists_in_hr_lookups

1574: fnd_message.raise_error;
1575: --
1576: End If;
1577: --
1578: If hr_api.not_exists_in_hr_lookups
1579: (p_effective_date
1580: ,'TERMINATION_RULE'
1581: ,p_post_termination_rule) Then
1582: --

Line 1590: If hr_api.not_exists_in_hr_lookups

1586: fnd_message.raise_error;
1587: --
1588: End If;
1589: --
1590: If hr_api.not_exists_in_hr_lookups
1591: (p_effective_date
1592: ,'YES_NO'
1593: ,p_once_each_period_flag) Then
1594: --

Line 1737: If hr_api.not_exists_in_hr_lookups

1733: --
1734: Begin
1735: hr_utility.set_location('Entering:'||l_proc, 5);
1736: --
1737: If hr_api.not_exists_in_hr_lookups
1738: (p_effective_date
1739: ,'PROCESSING_TYPE'
1740: ,p_processing_type) Then
1741: --

Line 1801: If hr_api.not_exists_in_hr_lookups

1797: --
1798: Begin
1799: hr_utility.set_location('Entering:'||l_proc, 5);
1800: --
1801: If hr_api.not_exists_in_hr_lookups
1802: (p_effective_date
1803: ,'YES_NO'
1804: ,p_standard_link_flag) Then
1805: --

Line 1875: If nvl(p_qualifying_age,hr_api.g_number) <> hr_api.g_number Then

1871: --
1872: Begin
1873: hr_utility.set_location('Entering:'||l_proc, 5);
1874: --
1875: If nvl(p_qualifying_age,hr_api.g_number) <> hr_api.g_number Then
1876: If (sign(p_qualifying_age) = -1) or (p_qualifying_age not between 0 and 99)
1877: then
1878: --
1879: fnd_message.set_name('PAY','PAY_33096_QUALI_AGE_CHECK');

Line 1883: Elsif nvl(p_qualifying_length_of_service,hr_api.g_number) <> hr_api.g_number

1879: fnd_message.set_name('PAY','PAY_33096_QUALI_AGE_CHECK');
1880: fnd_message.raise_error;
1881: --
1882: End If;
1883: Elsif nvl(p_qualifying_length_of_service,hr_api.g_number) <> hr_api.g_number
1884: then
1885: If (sign(p_qualifying_length_of_service) = -1) Then
1886: --
1887: fnd_message.set_name('PAY','PAY_34143_QUALI_LOS_VLDTN');

Line 1892: If nvl(p_qualifying_units,hr_api.g_varchar2) = hr_api.g_varchar2 Then

1888: fnd_message.raise_error;
1889: --
1890: End If;
1891: --
1892: If nvl(p_qualifying_units,hr_api.g_varchar2) = hr_api.g_varchar2 Then
1893: --
1894: fnd_message.set_name('PAY','PAY_34137_QUALI_FACTORS_VLDTN');
1895: fnd_message.raise_error;
1896: --

Line 1899: If hr_api.not_exists_in_hr_lookups

1895: fnd_message.raise_error;
1896: --
1897: Else
1898: --
1899: If hr_api.not_exists_in_hr_lookups
1900: (p_effective_date
1901: ,'QUALIFYING_UNITS'
1902: ,p_qualifying_units) Then
1903: --

Line 1961: If hr_api.not_exists_in_hr_lookups

1957: --
1958: Begin
1959: hr_utility.set_location('Entering:'||l_proc, 5);
1960: --
1961: If hr_api.not_exists_in_hr_lookups
1962: (p_effective_date
1963: ,'YES_NO'
1964: ,nvl(p_third_party_pay_only_flag,'N')) Then
1965: --

Line 1974: nvl(pay_etp_shd_nd.g_old_rec.third_party_pay_only_flag,hr_api.g_varchar2))

1970: --
1971: End If;
1972: If p_element_type_id is not null and
1973: (p_third_party_pay_only_flag <>
1974: nvl(pay_etp_shd_nd.g_old_rec.third_party_pay_only_flag,hr_api.g_varchar2))
1975: Then
1976: --
1977: If pay_element_types_pkg.element_entries_exist
1978: (p_element_type_id

Line 2050: If nvl(p_iterative_formula_id,hr_api.g_number) <> hr_api.g_number Then

2046: --
2047: Begin
2048: hr_utility.set_location('Entering:'||l_proc, 5);
2049: --
2050: If nvl(p_iterative_formula_id,hr_api.g_number) <> hr_api.g_number Then
2051: If not (dt_api.rows_exist
2052: (p_base_table_name => 'FF_FORMULAS_F'
2053: ,p_base_key_column => 'FORMULA_ID'
2054: ,p_base_key_value => p_iterative_formula_id

Line 2067: If hr_api.not_exists_in_hr_lookups

2063: --
2064: End If;
2065: End If;
2066: --
2067: If hr_api.not_exists_in_hr_lookups
2068: (p_effective_date
2069: ,'YES_NO'
2070: ,nvl(p_iterative_flag,'N')) Then
2071: --

Line 2079: If hr_api.not_exists_in_hr_lookups

2075: fnd_message.raise_error;
2076: --
2077: End If;
2078: --
2079: If hr_api.not_exists_in_hr_lookups
2080: (p_effective_date
2081: ,'YES_NO'
2082: ,nvl(p_grossup_flag,'N')) Then
2083: --

Line 2171: If nvl(p_retro_summ_ele_id,hr_api.g_number) <> hr_api.g_number Then

2167: --
2168: Begin
2169: hr_utility.set_location('Entering:'||l_proc, 5);
2170: --
2171: If nvl(p_retro_summ_ele_id,hr_api.g_number) <> hr_api.g_number Then
2172: If not (dt_api.rows_exist
2173: (p_base_table_name => 'PAY_ELEMENT_TYPES_F'
2174: ,p_base_key_column => 'ELEMENT_TYPE_ID'
2175: ,p_base_key_value => p_retro_summ_ele_id

Line 2188: If nvl(p_proration_formula_id,hr_api.g_number) <> hr_api.g_number Then

2184: --
2185: End If;
2186: End If;
2187: --
2188: If nvl(p_proration_formula_id,hr_api.g_number) <> hr_api.g_number Then
2189: If not (dt_api.rows_exist
2190: (p_base_table_name => 'FF_FORMULAS_F'
2191: ,p_base_key_column => 'FORMULA_ID'
2192: ,p_base_key_value => p_proration_formula_id

Line 2205: If nvl(p_proration_group_id,hr_api.g_number) <> hr_api.g_number Then

2201: --
2202: End If;
2203: End If;
2204: --
2205: If nvl(p_proration_group_id,hr_api.g_number) <> hr_api.g_number Then
2206: --
2207: Open c_chk_event_group_id(p_proration_group_id);
2208: Fetch c_chk_event_group_id into l_exists, p_event_group_type;
2209: If c_chk_event_group_id%notfound Then

Line 2228: If nvl(p_recalc_event_group_id,hr_api.g_number) <> hr_api.g_number Then

2224: Close c_chk_event_group_id;
2225: --
2226: End If;
2227: --
2228: If nvl(p_recalc_event_group_id,hr_api.g_number) <> hr_api.g_number Then
2229: --
2230: Open c_chk_event_group_id(p_recalc_event_group_id);
2231: Fetch c_chk_event_group_id into l_exists, p_event_group_type;
2232: If c_chk_event_group_id%notfound Then

Line 2327: /* If hr_api.not_exists_in_hr_lookups

2323: --
2324: Begin
2325: --
2326: hr_utility.set_location('Entering:'||l_proc, 5);
2327: /* If hr_api.not_exists_in_hr_lookups
2328: (p_effective_date
2329: ,'PAY_TIME_DEFINITION_TYPE'
2330: ,p_time_definition_type) Then
2331: --

Line 2753: hr_api.validate_bus_grp_id

2749: NOT IN ('GENERIC','STARTUP') THEN
2750: --
2751: -- Validate Important Attributes
2752: --
2753: hr_api.validate_bus_grp_id
2754: (p_business_group_id => p_rec.business_group_id
2755: ,p_associated_column1 => pay_etp_shd_nd.g_tab_nam
2756: || '.BUSINESS_GROUP_ID');
2757: --

Line 2928: hr_api.validate_bus_grp_id

2924: NOT IN ('GENERIC','STARTUP') THEN
2925: --
2926: -- Validate Important Attributes
2927: --
2928: hr_api.validate_bus_grp_id
2929: (p_business_group_id => p_rec.business_group_id
2930: ,p_associated_column1 => pay_etp_shd_nd.g_tab_nam
2931: || '.BUSINESS_GROUP_ID');
2932: --