DBA Data[Home] [Help]

APPS.PAY_ELE_BUS dependencies on HR_API

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_entry_id'
49: ,p_argument_value => p_element_entry_id
50: );

Line 69: hr_api.set_security_group_id

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

Line 108: hr_api.mandatory_arg_error

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

Line 114: if ( nvl(pay_ele_bus.g_element_entry_id, hr_api.g_number)

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

Line 190: nvl(pay_ele_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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

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

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

Line 192: nvl(pay_ele_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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

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

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

Line 194: nvl(pay_ele_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

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

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

Line 196: nvl(pay_ele_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

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

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

Line 198: nvl(pay_ele_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

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

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

Line 200: nvl(pay_ele_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

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

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

Line 202: nvl(pay_ele_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

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

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

Line 204: nvl(pay_ele_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

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

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

Line 206: nvl(pay_ele_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

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

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

Line 208: nvl(pay_ele_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

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

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

Line 210: nvl(pay_ele_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

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

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

Line 212: nvl(pay_ele_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

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

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

Line 214: nvl(pay_ele_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

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

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

Line 216: nvl(pay_ele_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

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

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

Line 218: nvl(pay_ele_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

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

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

Line 220: nvl(pay_ele_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

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

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

Line 222: nvl(pay_ele_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

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

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

Line 224: nvl(pay_ele_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

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

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

Line 226: nvl(pay_ele_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

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

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

Line 228: nvl(pay_ele_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

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

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

Line 230: nvl(pay_ele_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

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

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

Line 387: if nvl(p_rec.element_type_id, hr_api.g_number) <>

383: END IF;
384: --
385: hr_utility.set_location(l_proc, 10);
386: --
387: if nvl(p_rec.element_type_id, hr_api.g_number) <>
388: nvl(pay_ele_shd.g_old_rec.element_type_id, hr_api.g_number) then
389: l_argument := 'element_type_id';
390: raise l_error;
391: end if;

Line 388: nvl(pay_ele_shd.g_old_rec.element_type_id, hr_api.g_number) then

384: --
385: hr_utility.set_location(l_proc, 10);
386: --
387: if nvl(p_rec.element_type_id, hr_api.g_number) <>
388: nvl(pay_ele_shd.g_old_rec.element_type_id, hr_api.g_number) then
389: l_argument := 'element_type_id';
390: raise l_error;
391: end if;
392: hr_utility.set_location(l_proc, 20);

Line 396: hr_api.argument_changed_error

392: hr_utility.set_location(l_proc, 20);
393: --
394: EXCEPTION
395: WHEN l_error THEN
396: hr_api.argument_changed_error
397: (p_api_name => l_proc
398: ,p_argument => l_argument);
399: WHEN OTHERS THEN
400: RAISE;

Line 433: (p_assignment_id in number default hr_api.g_number

429: --
430: -- {End Of Comments}
431: -- ----------------------------------------------------------------------------
432: Procedure dt_update_validate
433: (p_assignment_id in number default hr_api.g_number
434: ,p_element_link_id in number default hr_api.g_number
435: ,p_datetrack_mode in varchar2
436: ,p_validation_start_date in date
437: ,p_validation_end_date in date

Line 434: ,p_element_link_id in number default hr_api.g_number

430: -- {End Of Comments}
431: -- ----------------------------------------------------------------------------
432: Procedure dt_update_validate
433: (p_assignment_id in number default hr_api.g_number
434: ,p_element_link_id in number default hr_api.g_number
435: ,p_datetrack_mode in varchar2
436: ,p_validation_start_date in date
437: ,p_validation_end_date in date
438: ) Is

Line 448: hr_api.mandatory_arg_error

444: Begin
445: --
446: -- Ensure that the p_datetrack_mode argument is not null
447: --
448: hr_api.mandatory_arg_error
449: (p_api_name => l_proc
450: ,p_argument => 'datetrack_mode'
451: ,p_argument_value => p_datetrack_mode
452: );

Line 458: hr_api.mandatory_arg_error

454: -- Mode will be valid, as this is checked at the start of the upd.
455: --
456: -- Ensure the arguments are not null
457: --
458: hr_api.mandatory_arg_error
459: (p_api_name => l_proc
460: ,p_argument => 'validation_start_date'
461: ,p_argument_value => p_validation_start_date
462: );

Line 464: hr_api.mandatory_arg_error

460: ,p_argument => 'validation_start_date'
461: ,p_argument_value => p_validation_start_date
462: );
463: --
464: hr_api.mandatory_arg_error
465: (p_api_name => l_proc
466: ,p_argument => 'validation_end_date'
467: ,p_argument_value => p_validation_end_date
468: );

Line 470: If ((nvl(p_assignment_id, hr_api.g_number) <> hr_api.g_number) and

466: ,p_argument => 'validation_end_date'
467: ,p_argument_value => p_validation_end_date
468: );
469: --
470: If ((nvl(p_assignment_id, hr_api.g_number) <> hr_api.g_number) and
471: NOT (dt_api.check_min_max_dates
472: (p_base_table_name => 'per_all_assignments_f'
473: ,p_base_key_column => 'ASSIGNMENT_ID'
474: ,p_base_key_value => p_assignment_id

Line 480: If ((nvl(p_element_link_id, hr_api.g_number) <> hr_api.g_number) and

476: ,p_to_date => p_validation_end_date))) Then
477: l_table_name := 'all assignments';
478: raise l_integrity_error;
479: End If;
480: If ((nvl(p_element_link_id, hr_api.g_number) <> hr_api.g_number) and
481: NOT (dt_api.check_min_max_dates
482: (p_base_table_name => 'pay_element_links_f'
483: ,p_base_key_column => 'ELEMENT_LINK_ID'
484: ,p_base_key_value => p_element_link_id

Line 561: hr_api.mandatory_arg_error

557: Begin
558: --
559: -- Ensure that the p_datetrack_mode argument is not null
560: --
561: hr_api.mandatory_arg_error
562: (p_api_name => l_proc
563: ,p_argument => 'datetrack_mode'
564: ,p_argument_value => p_datetrack_mode
565: );

Line 570: If (p_datetrack_mode = hr_api.g_delete or

566: --
567: -- Only perform the validation if the datetrack mode is either
568: -- DELETE or ZAP
569: --
570: If (p_datetrack_mode = hr_api.g_delete or
571: p_datetrack_mode = hr_api.g_zap) then
572: --
573: --
574: -- Ensure the arguments are not null

Line 571: p_datetrack_mode = hr_api.g_zap) then

567: -- Only perform the validation if the datetrack mode is either
568: -- DELETE or ZAP
569: --
570: If (p_datetrack_mode = hr_api.g_delete or
571: p_datetrack_mode = hr_api.g_zap) then
572: --
573: --
574: -- Ensure the arguments are not null
575: --

Line 576: hr_api.mandatory_arg_error

572: --
573: --
574: -- Ensure the arguments are not null
575: --
576: hr_api.mandatory_arg_error
577: (p_api_name => l_proc
578: ,p_argument => 'validation_start_date'
579: ,p_argument_value => p_validation_start_date
580: );

Line 582: hr_api.mandatory_arg_error

578: ,p_argument => 'validation_start_date'
579: ,p_argument_value => p_validation_start_date
580: );
581: --
582: hr_api.mandatory_arg_error
583: (p_api_name => l_proc
584: ,p_argument => 'validation_end_date'
585: ,p_argument_value => p_validation_end_date
586: );

Line 588: hr_api.mandatory_arg_error

584: ,p_argument => 'validation_end_date'
585: ,p_argument_value => p_validation_end_date
586: );
587: --
588: hr_api.mandatory_arg_error
589: (p_api_name => l_proc
590: ,p_argument => 'element_entry_id'
591: ,p_argument_value => p_element_entry_id
592: );