APPS.PAY_ETP_BUS 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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.g_old_rec.element_information3, hr_api.g_varchar2) <>

194: nvl(pay_etp_shd.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.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.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.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.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.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.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.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.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.g_old_rec.element_information4, hr_api.g_varchar2) <>

196: nvl(pay_etp_shd.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.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.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.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.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.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.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.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.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.g_old_rec.element_information5, hr_api.g_varchar2) <>

198: nvl(pay_etp_shd.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.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.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.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.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.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.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.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.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.g_old_rec.element_information6, hr_api.g_varchar2) <>

200: nvl(pay_etp_shd.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.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.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.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.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.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.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.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.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.g_old_rec.element_information7, hr_api.g_varchar2) <>

202: nvl(pay_etp_shd.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.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.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.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.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.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.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.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.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.g_old_rec.element_information8, hr_api.g_varchar2) <>

204: nvl(pay_etp_shd.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.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.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.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.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.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.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.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.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.g_old_rec.element_information9, hr_api.g_varchar2) <>

206: nvl(pay_etp_shd.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.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.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.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.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.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.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.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.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.g_old_rec.element_information10, hr_api.g_varchar2) <>

208: nvl(pay_etp_shd.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.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.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.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.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.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.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.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.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.g_old_rec.element_information11, hr_api.g_varchar2) <>

210: nvl(pay_etp_shd.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.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.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.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.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.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.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.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.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.g_old_rec.element_information12, hr_api.g_varchar2) <>

212: nvl(pay_etp_shd.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.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.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.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.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.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.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.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.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.g_old_rec.element_information13, hr_api.g_varchar2) <>

214: nvl(pay_etp_shd.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.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.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.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.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.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.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.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.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.g_old_rec.element_information14, hr_api.g_varchar2) <>

216: nvl(pay_etp_shd.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.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.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.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.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.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.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.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.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.g_old_rec.element_information15, hr_api.g_varchar2) <>

218: nvl(pay_etp_shd.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.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.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.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.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.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.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.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.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.g_old_rec.element_information16, hr_api.g_varchar2) <>

220: nvl(pay_etp_shd.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.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.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.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.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.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.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.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.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.g_old_rec.element_information17, hr_api.g_varchar2) <>

222: nvl(pay_etp_shd.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.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.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.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.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.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.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.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.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.g_old_rec.element_information18, hr_api.g_varchar2) <>

224: nvl(pay_etp_shd.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.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.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.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.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.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.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.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.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.g_old_rec.element_information19, hr_api.g_varchar2) <>

226: nvl(pay_etp_shd.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.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.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.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.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.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.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.g_old_rec.element_information20, hr_api.g_varchar2) <>

228: nvl(pay_etp_shd.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.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.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.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.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 329: nvl(pay_etp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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

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

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

Line 331: nvl(pay_etp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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

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

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

Line 333: nvl(pay_etp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

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

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

Line 335: nvl(pay_etp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

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

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

Line 337: nvl(pay_etp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

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

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

Line 339: nvl(pay_etp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

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

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

Line 341: nvl(pay_etp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

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

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

Line 343: nvl(pay_etp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

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

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

Line 345: nvl(pay_etp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

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

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

Line 347: nvl(pay_etp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

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

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

Line 349: nvl(pay_etp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

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

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

Line 351: nvl(pay_etp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

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

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

Line 353: nvl(pay_etp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

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

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

Line 355: nvl(pay_etp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

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

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

Line 357: nvl(pay_etp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

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

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

Line 359: nvl(pay_etp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

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

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

Line 361: nvl(pay_etp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

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

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

Line 363: nvl(pay_etp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

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

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

Line 365: nvl(pay_etp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

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

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

Line 367: nvl(pay_etp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

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

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

Line 369: nvl(pay_etp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

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

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

Line 521: hr_api.mandatory_arg_error

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

Line 531: hr_api.mandatory_arg_error

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

Line 537: hr_api.mandatory_arg_error

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

Line 605: hr_api.mandatory_arg_error

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

Line 614: If (p_datetrack_mode = hr_api.g_delete or

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

Line 615: p_datetrack_mode = hr_api.g_zap) then

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

Line 620: hr_api.mandatory_arg_error

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

Line 626: hr_api.mandatory_arg_error

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

Line 632: hr_api.mandatory_arg_error

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

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

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

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.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.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 2304: If (p_time_definition_type <> hr_api.g_varchar2) AND

2300:
2301: Begin
2302: --
2303: hr_utility.set_location('Entering:'||l_proc, 5);
2304: If (p_time_definition_type <> hr_api.g_varchar2) AND
2305: -- The below check has been added because, we treat NULL and N as same for
2306: -- the table PAY_ELEMENT_TYPES_F for the column TIME_DEFINITION_TYPE.
2307: -- So no need to check if the value is NULL or N.
2308: (p_time_definition_type IS NOT NULL AND p_time_definition_type <> 'N') AND

Line 2309: hr_api.not_exists_in_hr_lookups( p_effective_date

2305: -- The below check has been added because, we treat NULL and N as same for
2306: -- the table PAY_ELEMENT_TYPES_F for the column TIME_DEFINITION_TYPE.
2307: -- So no need to check if the value is NULL or N.
2308: (p_time_definition_type IS NOT NULL AND p_time_definition_type <> 'N') AND
2309: hr_api.not_exists_in_hr_lookups( p_effective_date
2310: ,'PAY_TIME_DEFINITION_TYPE'
2311: ,p_time_definition_type) Then
2312:
2313: hr_utility.set_location('The user has passed some value to time definition type ', 20);

Line 2983: hr_api.validate_bus_grp_id

2979: NOT IN ('GENERIC','STARTUP') THEN
2980: --
2981: -- Validate Important Attributes
2982: --
2983: hr_api.validate_bus_grp_id
2984: (p_business_group_id => p_rec.business_group_id
2985: ,p_associated_column1 => pay_etp_shd.g_tab_nam
2986: || '.BUSINESS_GROUP_ID');
2987: --

Line 3171: hr_api.validate_bus_grp_id

3167: NOT IN ('GENERIC','STARTUP') THEN
3168: --
3169: -- Validate Important Attributes
3170: --
3171: hr_api.validate_bus_grp_id
3172: (p_business_group_id => p_rec.business_group_id
3173: ,p_associated_column1 => pay_etp_shd.g_tab_nam
3174: || '.BUSINESS_GROUP_ID');
3175: --