APPS.PAY_PEL_BUS dependencies on HR_API

Line 15: g_eot date := hr_api.g_eot;

11: -- used by the return_legislation_code function.
12: --
13: g_legislation_code varchar2(150) default null;
14: g_element_link_id number default null;
15: g_eot date := hr_api.g_eot;
16: --
17: -- ---------------------------------------------------------------------------
18: -- |----------------------< set_security_group_id >--------------------------|
19: -- ---------------------------------------------------------------------------

Line 46: hr_api.mandatory_arg_error

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

Line 72: hr_api.set_security_group_id

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

Line 110: hr_api.mandatory_arg_error

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

Line 116: if ( nvl(pay_pel_bus.g_element_link_id, hr_api.g_number)

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

Line 191: nvl(pay_pel_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

187: begin
188: hr_utility.set_location('Entering:'||l_proc,10);
189: --
190: if ((p_rec.element_link_id is not null) and (
191: nvl(pay_pel_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
193: nvl(pay_pel_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute1, hr_api.g_varchar2) or
195: nvl(pay_pel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

188: hr_utility.set_location('Entering:'||l_proc,10);
189: --
190: if ((p_rec.element_link_id is not null) and (
191: nvl(pay_pel_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
193: nvl(pay_pel_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute1, hr_api.g_varchar2) or
195: nvl(pay_pel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 193: nvl(pay_pel_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

189: --
190: if ((p_rec.element_link_id is not null) and (
191: nvl(pay_pel_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
193: nvl(pay_pel_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute1, hr_api.g_varchar2) or
195: nvl(pay_pel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute2, hr_api.g_varchar2) or
197: nvl(pay_pel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

190: if ((p_rec.element_link_id is not null) and (
191: nvl(pay_pel_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
193: nvl(pay_pel_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute1, hr_api.g_varchar2) or
195: nvl(pay_pel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute2, hr_api.g_varchar2) or
197: nvl(pay_pel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 195: nvl(pay_pel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

191: nvl(pay_pel_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
193: nvl(pay_pel_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute1, hr_api.g_varchar2) or
195: nvl(pay_pel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute2, hr_api.g_varchar2) or
197: nvl(pay_pel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute3, hr_api.g_varchar2) or
199: nvl(pay_pel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

192: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
193: nvl(pay_pel_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute1, hr_api.g_varchar2) or
195: nvl(pay_pel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute2, hr_api.g_varchar2) or
197: nvl(pay_pel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute3, hr_api.g_varchar2) or
199: nvl(pay_pel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 197: nvl(pay_pel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

193: nvl(pay_pel_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute1, hr_api.g_varchar2) or
195: nvl(pay_pel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute2, hr_api.g_varchar2) or
197: nvl(pay_pel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute3, hr_api.g_varchar2) or
199: nvl(pay_pel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute4, hr_api.g_varchar2) or
201: nvl(pay_pel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

194: nvl(p_rec.attribute1, hr_api.g_varchar2) or
195: nvl(pay_pel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute2, hr_api.g_varchar2) or
197: nvl(pay_pel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute3, hr_api.g_varchar2) or
199: nvl(pay_pel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute4, hr_api.g_varchar2) or
201: nvl(pay_pel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 199: nvl(pay_pel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

195: nvl(pay_pel_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute2, hr_api.g_varchar2) or
197: nvl(pay_pel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute3, hr_api.g_varchar2) or
199: nvl(pay_pel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute4, hr_api.g_varchar2) or
201: nvl(pay_pel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute5, hr_api.g_varchar2) or
203: nvl(pay_pel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

196: nvl(p_rec.attribute2, hr_api.g_varchar2) or
197: nvl(pay_pel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute3, hr_api.g_varchar2) or
199: nvl(pay_pel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute4, hr_api.g_varchar2) or
201: nvl(pay_pel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute5, hr_api.g_varchar2) or
203: nvl(pay_pel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 201: nvl(pay_pel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

197: nvl(pay_pel_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute3, hr_api.g_varchar2) or
199: nvl(pay_pel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute4, hr_api.g_varchar2) or
201: nvl(pay_pel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute5, hr_api.g_varchar2) or
203: nvl(pay_pel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute6, hr_api.g_varchar2) or
205: nvl(pay_pel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

198: nvl(p_rec.attribute3, hr_api.g_varchar2) or
199: nvl(pay_pel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute4, hr_api.g_varchar2) or
201: nvl(pay_pel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute5, hr_api.g_varchar2) or
203: nvl(pay_pel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute6, hr_api.g_varchar2) or
205: nvl(pay_pel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 203: nvl(pay_pel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

199: nvl(pay_pel_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute4, hr_api.g_varchar2) or
201: nvl(pay_pel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute5, hr_api.g_varchar2) or
203: nvl(pay_pel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute6, hr_api.g_varchar2) or
205: nvl(pay_pel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute7, hr_api.g_varchar2) or
207: nvl(pay_pel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

200: nvl(p_rec.attribute4, hr_api.g_varchar2) or
201: nvl(pay_pel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute5, hr_api.g_varchar2) or
203: nvl(pay_pel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute6, hr_api.g_varchar2) or
205: nvl(pay_pel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute7, hr_api.g_varchar2) or
207: nvl(pay_pel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 205: nvl(pay_pel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

201: nvl(pay_pel_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute5, hr_api.g_varchar2) or
203: nvl(pay_pel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute6, hr_api.g_varchar2) or
205: nvl(pay_pel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute7, hr_api.g_varchar2) or
207: nvl(pay_pel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute8, hr_api.g_varchar2) or
209: nvl(pay_pel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

202: nvl(p_rec.attribute5, hr_api.g_varchar2) or
203: nvl(pay_pel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute6, hr_api.g_varchar2) or
205: nvl(pay_pel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute7, hr_api.g_varchar2) or
207: nvl(pay_pel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute8, hr_api.g_varchar2) or
209: nvl(pay_pel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 207: nvl(pay_pel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

203: nvl(pay_pel_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute6, hr_api.g_varchar2) or
205: nvl(pay_pel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute7, hr_api.g_varchar2) or
207: nvl(pay_pel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute8, hr_api.g_varchar2) or
209: nvl(pay_pel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute9, hr_api.g_varchar2) or
211: nvl(pay_pel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

204: nvl(p_rec.attribute6, hr_api.g_varchar2) or
205: nvl(pay_pel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute7, hr_api.g_varchar2) or
207: nvl(pay_pel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute8, hr_api.g_varchar2) or
209: nvl(pay_pel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute9, hr_api.g_varchar2) or
211: nvl(pay_pel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 209: nvl(pay_pel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

205: nvl(pay_pel_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute7, hr_api.g_varchar2) or
207: nvl(pay_pel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute8, hr_api.g_varchar2) or
209: nvl(pay_pel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute9, hr_api.g_varchar2) or
211: nvl(pay_pel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute10, hr_api.g_varchar2) or
213: nvl(pay_pel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

206: nvl(p_rec.attribute7, hr_api.g_varchar2) or
207: nvl(pay_pel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute8, hr_api.g_varchar2) or
209: nvl(pay_pel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute9, hr_api.g_varchar2) or
211: nvl(pay_pel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute10, hr_api.g_varchar2) or
213: nvl(pay_pel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 211: nvl(pay_pel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

207: nvl(pay_pel_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute8, hr_api.g_varchar2) or
209: nvl(pay_pel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute9, hr_api.g_varchar2) or
211: nvl(pay_pel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute10, hr_api.g_varchar2) or
213: nvl(pay_pel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute11, hr_api.g_varchar2) or
215: nvl(pay_pel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

208: nvl(p_rec.attribute8, hr_api.g_varchar2) or
209: nvl(pay_pel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute9, hr_api.g_varchar2) or
211: nvl(pay_pel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute10, hr_api.g_varchar2) or
213: nvl(pay_pel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute11, hr_api.g_varchar2) or
215: nvl(pay_pel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 213: nvl(pay_pel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

209: nvl(pay_pel_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute9, hr_api.g_varchar2) or
211: nvl(pay_pel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute10, hr_api.g_varchar2) or
213: nvl(pay_pel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute11, hr_api.g_varchar2) or
215: nvl(pay_pel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute12, hr_api.g_varchar2) or
217: nvl(pay_pel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

210: nvl(p_rec.attribute9, hr_api.g_varchar2) or
211: nvl(pay_pel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute10, hr_api.g_varchar2) or
213: nvl(pay_pel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute11, hr_api.g_varchar2) or
215: nvl(pay_pel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute12, hr_api.g_varchar2) or
217: nvl(pay_pel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 215: nvl(pay_pel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

211: nvl(pay_pel_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute10, hr_api.g_varchar2) or
213: nvl(pay_pel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute11, hr_api.g_varchar2) or
215: nvl(pay_pel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute12, hr_api.g_varchar2) or
217: nvl(pay_pel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute13, hr_api.g_varchar2) or
219: nvl(pay_pel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

212: nvl(p_rec.attribute10, hr_api.g_varchar2) or
213: nvl(pay_pel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute11, hr_api.g_varchar2) or
215: nvl(pay_pel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute12, hr_api.g_varchar2) or
217: nvl(pay_pel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute13, hr_api.g_varchar2) or
219: nvl(pay_pel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 217: nvl(pay_pel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

213: nvl(pay_pel_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute11, hr_api.g_varchar2) or
215: nvl(pay_pel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute12, hr_api.g_varchar2) or
217: nvl(pay_pel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute13, hr_api.g_varchar2) or
219: nvl(pay_pel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute14, hr_api.g_varchar2) or
221: nvl(pay_pel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

214: nvl(p_rec.attribute11, hr_api.g_varchar2) or
215: nvl(pay_pel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute12, hr_api.g_varchar2) or
217: nvl(pay_pel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute13, hr_api.g_varchar2) or
219: nvl(pay_pel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute14, hr_api.g_varchar2) or
221: nvl(pay_pel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 219: nvl(pay_pel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

215: nvl(pay_pel_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute12, hr_api.g_varchar2) or
217: nvl(pay_pel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute13, hr_api.g_varchar2) or
219: nvl(pay_pel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute14, hr_api.g_varchar2) or
221: nvl(pay_pel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute15, hr_api.g_varchar2) or
223: nvl(pay_pel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

216: nvl(p_rec.attribute12, hr_api.g_varchar2) or
217: nvl(pay_pel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute13, hr_api.g_varchar2) or
219: nvl(pay_pel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute14, hr_api.g_varchar2) or
221: nvl(pay_pel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute15, hr_api.g_varchar2) or
223: nvl(pay_pel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 221: nvl(pay_pel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

217: nvl(pay_pel_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute13, hr_api.g_varchar2) or
219: nvl(pay_pel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute14, hr_api.g_varchar2) or
221: nvl(pay_pel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute15, hr_api.g_varchar2) or
223: nvl(pay_pel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute16, hr_api.g_varchar2) or
225: nvl(pay_pel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

218: nvl(p_rec.attribute13, hr_api.g_varchar2) or
219: nvl(pay_pel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute14, hr_api.g_varchar2) or
221: nvl(pay_pel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute15, hr_api.g_varchar2) or
223: nvl(pay_pel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute16, hr_api.g_varchar2) or
225: nvl(pay_pel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 223: nvl(pay_pel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

219: nvl(pay_pel_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute14, hr_api.g_varchar2) or
221: nvl(pay_pel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute15, hr_api.g_varchar2) or
223: nvl(pay_pel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute16, hr_api.g_varchar2) or
225: nvl(pay_pel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute17, hr_api.g_varchar2) or
227: nvl(pay_pel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

220: nvl(p_rec.attribute14, hr_api.g_varchar2) or
221: nvl(pay_pel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute15, hr_api.g_varchar2) or
223: nvl(pay_pel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute16, hr_api.g_varchar2) or
225: nvl(pay_pel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute17, hr_api.g_varchar2) or
227: nvl(pay_pel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 225: nvl(pay_pel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

221: nvl(pay_pel_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute15, hr_api.g_varchar2) or
223: nvl(pay_pel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute16, hr_api.g_varchar2) or
225: nvl(pay_pel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute17, hr_api.g_varchar2) or
227: nvl(pay_pel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute18, hr_api.g_varchar2) or
229: nvl(pay_pel_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

222: nvl(p_rec.attribute15, hr_api.g_varchar2) or
223: nvl(pay_pel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute16, hr_api.g_varchar2) or
225: nvl(pay_pel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute17, hr_api.g_varchar2) or
227: nvl(pay_pel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute18, hr_api.g_varchar2) or
229: nvl(pay_pel_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 227: nvl(pay_pel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

223: nvl(pay_pel_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute16, hr_api.g_varchar2) or
225: nvl(pay_pel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute17, hr_api.g_varchar2) or
227: nvl(pay_pel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute18, hr_api.g_varchar2) or
229: nvl(pay_pel_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute19, hr_api.g_varchar2) or
231: nvl(pay_pel_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

224: nvl(p_rec.attribute16, hr_api.g_varchar2) or
225: nvl(pay_pel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute17, hr_api.g_varchar2) or
227: nvl(pay_pel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute18, hr_api.g_varchar2) or
229: nvl(pay_pel_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute19, hr_api.g_varchar2) or
231: nvl(pay_pel_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

Line 229: nvl(pay_pel_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

225: nvl(pay_pel_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute17, hr_api.g_varchar2) or
227: nvl(pay_pel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute18, hr_api.g_varchar2) or
229: nvl(pay_pel_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute19, hr_api.g_varchar2) or
231: nvl(pay_pel_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
233: or (p_rec.element_link_id is null) then

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

226: nvl(p_rec.attribute17, hr_api.g_varchar2) or
227: nvl(pay_pel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute18, hr_api.g_varchar2) or
229: nvl(pay_pel_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute19, hr_api.g_varchar2) or
231: nvl(pay_pel_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
233: or (p_rec.element_link_id is null) then
234: --

Line 231: nvl(pay_pel_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

227: nvl(pay_pel_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute18, hr_api.g_varchar2) or
229: nvl(pay_pel_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute19, hr_api.g_varchar2) or
231: nvl(pay_pel_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
233: or (p_rec.element_link_id is null) then
234: --
235: -- Only execute the validation if absolutely necessary:

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

228: nvl(p_rec.attribute18, hr_api.g_varchar2) or
229: nvl(pay_pel_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute19, hr_api.g_varchar2) or
231: nvl(pay_pel_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
233: or (p_rec.element_link_id is null) then
234: --
235: -- Only execute the validation if absolutely necessary:
236: -- a) During update, the structure column value or any

Line 371: (p_payroll_id in number default hr_api.g_number

367: --
368: -- {End Of Comments}
369: -- ----------------------------------------------------------------------------
370: Procedure dt_update_validate
371: (p_payroll_id in number default hr_api.g_number
372: ,p_element_type_id in number default hr_api.g_number
373: ,p_datetrack_mode in varchar2
374: ,p_validation_start_date in date
375: ,p_validation_end_date in date

Line 372: ,p_element_type_id in number default hr_api.g_number

368: -- {End Of Comments}
369: -- ----------------------------------------------------------------------------
370: Procedure dt_update_validate
371: (p_payroll_id in number default hr_api.g_number
372: ,p_element_type_id in number default hr_api.g_number
373: ,p_datetrack_mode in varchar2
374: ,p_validation_start_date in date
375: ,p_validation_end_date in date
376: ) Is

Line 384: hr_api.mandatory_arg_error

380: Begin
381: --
382: -- Ensure that the p_datetrack_mode argument is not null
383: --
384: hr_api.mandatory_arg_error
385: (p_api_name => l_proc
386: ,p_argument => 'datetrack_mode'
387: ,p_argument_value => p_datetrack_mode
388: );

Line 394: hr_api.mandatory_arg_error

390: -- Mode will be valid, as this is checked at the start of the upd.
391: --
392: -- Ensure the arguments are not null
393: --
394: hr_api.mandatory_arg_error
395: (p_api_name => l_proc
396: ,p_argument => 'validation_start_date'
397: ,p_argument_value => p_validation_start_date
398: );

Line 400: hr_api.mandatory_arg_error

396: ,p_argument => 'validation_start_date'
397: ,p_argument_value => p_validation_start_date
398: );
399: --
400: hr_api.mandatory_arg_error
401: (p_api_name => l_proc
402: ,p_argument => 'validation_end_date'
403: ,p_argument_value => p_validation_end_date
404: );

Line 406: If ((nvl(p_payroll_id, hr_api.g_number) <> hr_api.g_number) and

402: ,p_argument => 'validation_end_date'
403: ,p_argument_value => p_validation_end_date
404: );
405: --
406: If ((nvl(p_payroll_id, hr_api.g_number) <> hr_api.g_number) and
407: NOT (dt_api.check_min_max_dates
408: (p_base_table_name => 'pay_all_payrolls_f'
409: ,p_base_key_column => 'PAYROLL_ID'
410: ,p_base_key_value => p_payroll_id

Line 418: If ((nvl(p_element_type_id, hr_api.g_number) <> hr_api.g_number) and

414: fnd_message.set_token('TABLE_NAME','all payrolls');
415: hr_multi_message.add
416: (p_associated_column1 => pay_pel_shd.g_tab_nam || '.PAYROLL_ID');
417: End If;
418: If ((nvl(p_element_type_id, hr_api.g_number) <> hr_api.g_number) and
419: NOT (dt_api.check_min_max_dates
420: (p_base_table_name => 'pay_element_types_f'
421: ,p_base_key_column => 'ELEMENT_TYPE_ID'
422: ,p_base_key_value => p_element_type_id

Line 491: hr_api.mandatory_arg_error

487: Begin
488: --
489: -- Ensure that the p_datetrack_mode argument is not null
490: --
491: hr_api.mandatory_arg_error
492: (p_api_name => l_proc
493: ,p_argument => 'datetrack_mode'
494: ,p_argument_value => p_datetrack_mode
495: );

Line 500: If (p_datetrack_mode = hr_api.g_delete or

496: --
497: -- Only perform the validation if the datetrack mode is either
498: -- DELETE or ZAP
499: --
500: If (p_datetrack_mode = hr_api.g_delete or
501: p_datetrack_mode = hr_api.g_zap) then
502: --
503: --
504: -- Ensure the arguments are not null

Line 501: p_datetrack_mode = hr_api.g_zap) then

497: -- Only perform the validation if the datetrack mode is either
498: -- DELETE or ZAP
499: --
500: If (p_datetrack_mode = hr_api.g_delete or
501: p_datetrack_mode = hr_api.g_zap) then
502: --
503: --
504: -- Ensure the arguments are not null
505: --

Line 506: hr_api.mandatory_arg_error

502: --
503: --
504: -- Ensure the arguments are not null
505: --
506: hr_api.mandatory_arg_error
507: (p_api_name => l_proc
508: ,p_argument => 'validation_start_date'
509: ,p_argument_value => p_validation_start_date
510: );

Line 512: hr_api.mandatory_arg_error

508: ,p_argument => 'validation_start_date'
509: ,p_argument_value => p_validation_start_date
510: );
511: --
512: hr_api.mandatory_arg_error
513: (p_api_name => l_proc
514: ,p_argument => 'validation_end_date'
515: ,p_argument_value => p_validation_end_date
516: );

Line 518: hr_api.mandatory_arg_error

514: ,p_argument => 'validation_end_date'
515: ,p_argument_value => p_validation_end_date
516: );
517: --
518: hr_api.mandatory_arg_error
519: (p_api_name => l_proc
520: ,p_argument => 'element_link_id'
521: ,p_argument_value => p_element_link_id
522: );

Line 637: if hr_api.not_exists_in_hr_lookups

633: fnd_message.raise_error;
634: end;
635:
636: if p_qualifying_units is not null then
637: if hr_api.not_exists_in_hr_lookups
638: (p_effective_date
639: ,'QUALIFYING_UNITS'
640: ,p_qualifying_units) then
641: --

Line 916: If hr_api.not_exists_in_hr_lookups

912: begin
913: hr_utility.set_location('Entering:'||l_proc,10);
914: --
915: If p_employment_category is not null Then
916: If hr_api.not_exists_in_hr_lookups
917: (p_effective_date
918: ,'EMP_CAT'
919: ,p_employment_category) Then
920: --

Line 1510: and p_datetrack_mode = hr_api.g_update then

1506: l_proc varchar2(72) := g_package || 'chk_costable_type_for_upd';
1507: begin
1508: hr_utility.set_location('Entering:'||l_proc,10);
1509: if pay_pel_shd.g_old_rec.costable_type <> p_costable_type
1510: and p_datetrack_mode = hr_api.g_update then
1511: fnd_message.set_name('PAY', 'PAY_6466_LINK_NO_COST_UPD2');
1512: fnd_message.raise_error;
1513: end if;
1514: hr_utility.set_location(' Leaving:'||l_proc,20);

Line 1595: if (p_datetrack_mode <> hr_api.g_insert)

1591: begin
1592: hr_utility.set_location('Entering:'||l_proc,10);
1593: --
1594: -- Only check for change of standard link flag if not inserting
1595: if (p_datetrack_mode <> hr_api.g_insert)
1596: then
1597: if pay_pel_shd.g_old_rec.standard_link_flag = 'N'
1598: and p_standard_link_flag = 'Y' then
1599: hr_utility.set_location(l_proc,20);

Line 1602: if (csr_DateEffRecs%found or p_datetrack_mode = hr_api.g_update) then

1598: and p_standard_link_flag = 'Y' then
1599: hr_utility.set_location(l_proc,20);
1600: open csr_DateEffRecs;
1601: fetch csr_DateEffRecs into l_dummy;
1602: if (csr_DateEffRecs%found or p_datetrack_mode = hr_api.g_update) then
1603: close csr_DateEffRecs;
1604: fnd_message.set_name('PAY', 'PAY_6733_LINK_NO_UPD_STAN_FLAG');
1605: fnd_message.raise_error;
1606: end if;

Line 1691: hr_api.validate_bus_grp_id

1687: hr_utility.set_location('Entering:'||l_proc, 5);
1688: --
1689: -- Call all supporting business operations
1690: --
1691: hr_api.validate_bus_grp_id
1692: (p_business_group_id => p_rec.business_group_id
1693: ,p_associated_column1 => pay_pel_shd.g_tab_nam
1694: || '.BUSINESS_GROUP_ID');
1695: --

Line 1819: hr_api.validate_bus_grp_id

1815: hr_utility.set_location('Entering:'||l_proc, 5);
1816: --
1817: -- Call all supporting business operations
1818: --
1819: hr_api.validate_bus_grp_id
1820: (p_business_group_id => p_rec.business_group_id
1821: ,p_associated_column1 => pay_pel_shd.g_tab_nam
1822: || '.BUSINESS_GROUP_ID');
1823: --