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: );
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);
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: );
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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
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) <>
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) )
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
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: --
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:
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
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;
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);
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;
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
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
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: );
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: );
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: );
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
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
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: );
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
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: --
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: );
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: );
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: );