eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_CLE_BUS dependencies on HR_CLE_SHD

Line 186: (p_rec in hr_cle_shd.g_rec_type

182: -- Internal Row Handler Use Only.
183: --
184: -- ----------------------------------------------------------------------------
185: procedure chk_df
186: (p_rec in hr_cle_shd.g_rec_type
187: ) is
188: --
189: l_proc varchar2(72) := g_package || 'chk_df';
190: --

Line 195: nvl(hr_cle_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

191: begin
192: hr_utility.set_location('Entering:'||l_proc,10);
193: --
194: if ((p_rec.soc_ins_contr_lvls_id is not null) and (
195: nvl(hr_cle_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
197: nvl(hr_cle_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute1, hr_api.g_varchar2) or
199: nvl(hr_cle_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 197: nvl(hr_cle_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

193: --
194: if ((p_rec.soc_ins_contr_lvls_id is not null) and (
195: nvl(hr_cle_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
196: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
197: nvl(hr_cle_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
198: nvl(p_rec.attribute1, hr_api.g_varchar2) or
199: nvl(hr_cle_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute2, hr_api.g_varchar2) or
201: nvl(hr_cle_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 199: nvl(hr_cle_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

Line 201: nvl(hr_cle_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

Line 203: nvl(hr_cle_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

Line 205: nvl(hr_cle_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

Line 207: nvl(hr_cle_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

Line 209: nvl(hr_cle_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

Line 211: nvl(hr_cle_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

Line 213: nvl(hr_cle_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

Line 215: nvl(hr_cle_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

Line 217: nvl(hr_cle_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

Line 219: nvl(hr_cle_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

Line 221: nvl(hr_cle_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

Line 223: nvl(hr_cle_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

Line 225: nvl(hr_cle_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

Line 227: nvl(hr_cle_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

Line 229: nvl(hr_cle_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

Line 231: nvl(hr_cle_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

227: nvl(hr_cle_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute16, hr_api.g_varchar2) or
229: nvl(hr_cle_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute17, hr_api.g_varchar2) or
231: nvl(hr_cle_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute18, hr_api.g_varchar2) or
233: nvl(hr_cle_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute19, hr_api.g_varchar2) or
235: nvl(hr_cle_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 233: nvl(hr_cle_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

229: nvl(hr_cle_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute17, hr_api.g_varchar2) or
231: nvl(hr_cle_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute18, hr_api.g_varchar2) or
233: nvl(hr_cle_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute19, hr_api.g_varchar2) or
235: nvl(hr_cle_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute20, hr_api.g_varchar2) or
237: nvl(hr_cle_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

Line 235: nvl(hr_cle_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

231: nvl(hr_cle_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute18, hr_api.g_varchar2) or
233: nvl(hr_cle_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute19, hr_api.g_varchar2) or
235: nvl(hr_cle_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute20, hr_api.g_varchar2) or
237: nvl(hr_cle_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute21, hr_api.g_varchar2) or
239: nvl(hr_cle_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

Line 237: nvl(hr_cle_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

233: nvl(hr_cle_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute19, hr_api.g_varchar2) or
235: nvl(hr_cle_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute20, hr_api.g_varchar2) or
237: nvl(hr_cle_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute21, hr_api.g_varchar2) or
239: nvl(hr_cle_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute22, hr_api.g_varchar2) or
241: nvl(hr_cle_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 239: nvl(hr_cle_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

235: nvl(hr_cle_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute20, hr_api.g_varchar2) or
237: nvl(hr_cle_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute21, hr_api.g_varchar2) or
239: nvl(hr_cle_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute22, hr_api.g_varchar2) or
241: nvl(hr_cle_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
242: nvl(p_rec.attribute23, hr_api.g_varchar2) or
243: nvl(hr_cle_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 241: nvl(hr_cle_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

237: nvl(hr_cle_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute21, hr_api.g_varchar2) or
239: nvl(hr_cle_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute22, hr_api.g_varchar2) or
241: nvl(hr_cle_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
242: nvl(p_rec.attribute23, hr_api.g_varchar2) or
243: nvl(hr_cle_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
244: nvl(p_rec.attribute24, hr_api.g_varchar2) or
245: nvl(hr_cle_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 243: nvl(hr_cle_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

239: nvl(hr_cle_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute22, hr_api.g_varchar2) or
241: nvl(hr_cle_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
242: nvl(p_rec.attribute23, hr_api.g_varchar2) or
243: nvl(hr_cle_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
244: nvl(p_rec.attribute24, hr_api.g_varchar2) or
245: nvl(hr_cle_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
246: nvl(p_rec.attribute25, hr_api.g_varchar2) or
247: nvl(hr_cle_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 245: nvl(hr_cle_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

241: nvl(hr_cle_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
242: nvl(p_rec.attribute23, hr_api.g_varchar2) or
243: nvl(hr_cle_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
244: nvl(p_rec.attribute24, hr_api.g_varchar2) or
245: nvl(hr_cle_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
246: nvl(p_rec.attribute25, hr_api.g_varchar2) or
247: nvl(hr_cle_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
248: nvl(p_rec.attribute26, hr_api.g_varchar2) or
249: nvl(hr_cle_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 247: nvl(hr_cle_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

243: nvl(hr_cle_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
244: nvl(p_rec.attribute24, hr_api.g_varchar2) or
245: nvl(hr_cle_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
246: nvl(p_rec.attribute25, hr_api.g_varchar2) or
247: nvl(hr_cle_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
248: nvl(p_rec.attribute26, hr_api.g_varchar2) or
249: nvl(hr_cle_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
250: nvl(p_rec.attribute27, hr_api.g_varchar2) or
251: nvl(hr_cle_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 249: nvl(hr_cle_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

245: nvl(hr_cle_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
246: nvl(p_rec.attribute25, hr_api.g_varchar2) or
247: nvl(hr_cle_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
248: nvl(p_rec.attribute26, hr_api.g_varchar2) or
249: nvl(hr_cle_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
250: nvl(p_rec.attribute27, hr_api.g_varchar2) or
251: nvl(hr_cle_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
252: nvl(p_rec.attribute28, hr_api.g_varchar2) or
253: nvl(hr_cle_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 251: nvl(hr_cle_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

247: nvl(hr_cle_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
248: nvl(p_rec.attribute26, hr_api.g_varchar2) or
249: nvl(hr_cle_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
250: nvl(p_rec.attribute27, hr_api.g_varchar2) or
251: nvl(hr_cle_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
252: nvl(p_rec.attribute28, hr_api.g_varchar2) or
253: nvl(hr_cle_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute29, hr_api.g_varchar2) or
255: nvl(hr_cle_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 253: nvl(hr_cle_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

249: nvl(hr_cle_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
250: nvl(p_rec.attribute27, hr_api.g_varchar2) or
251: nvl(hr_cle_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
252: nvl(p_rec.attribute28, hr_api.g_varchar2) or
253: nvl(hr_cle_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute29, hr_api.g_varchar2) or
255: nvl(hr_cle_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
257: or (p_rec.soc_ins_contr_lvls_id is null) then

Line 255: nvl(hr_cle_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

251: nvl(hr_cle_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
252: nvl(p_rec.attribute28, hr_api.g_varchar2) or
253: nvl(hr_cle_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute29, hr_api.g_varchar2) or
255: nvl(hr_cle_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
257: or (p_rec.soc_ins_contr_lvls_id is null) then
258: --
259: -- Only execute the validation if absolutely necessary:

Line 363: ,p_rec in hr_cle_shd.g_rec_type

359: -- {End Of Comments}
360: -- ----------------------------------------------------------------------------
361: Procedure chk_non_updateable_args
362: (p_effective_date in date
363: ,p_rec in hr_cle_shd.g_rec_type
364: ) IS
365: --
366: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
367: l_error EXCEPTION;

Line 375: IF NOT hr_cle_shd.api_updating

371: --
372: -- Only proceed with the validation if a row exists for the current
373: -- record in the HR Schema.
374: --
375: IF NOT hr_cle_shd.api_updating
376: (p_soc_ins_contr_lvls_id => p_rec.soc_ins_contr_lvls_id
377: ,p_effective_date => p_effective_date
378: ,p_object_version_number => p_rec.object_version_number
379: ) THEN

Line 387: nvl(hr_cle_shd.g_old_rec.organization_id,hr_api.g_number) THEN

383: fnd_message.raise_error;
384: END IF;
385:
386: IF nvl(p_rec.organization_id, hr_api.g_number) <>
387: nvl(hr_cle_shd.g_old_rec.organization_id,hr_api.g_number) THEN
388: --
389: l_argument := 'organization_id';
390: RAISE l_error;
391: --

Line 627: (hr_cle_shd.g_old_rec.normal_amount <> p_normal_amount))) THEN

623:
624: IF P_NORMAL_AMOUNT IS NOT NULL THEN
625: IF ( (p_soc_ins_contr_lvls_id IS NULL) OR
626: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
627: (hr_cle_shd.g_old_rec.normal_amount <> p_normal_amount))) THEN
628: --
629: hr_utility.set_location(l_proc, 20);
630:
631: IF ( P_NORMAL_AMOUNT < 0 ) then

Line 700: (hr_cle_shd.g_old_rec.increased_amount <> p_increased_amount))) THEN

696: --
697: IF P_INCREASED_AMOUNT IS NOT NULL THEN
698: IF ( (p_soc_ins_contr_lvls_id IS NULL) OR
699: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
700: (hr_cle_shd.g_old_rec.increased_amount <> p_increased_amount))) THEN
701: --
702: hr_utility.set_location(l_proc, 20);
703:
704: IF (P_INCREASED_AMOUNT < 0) then

Line 773: (hr_cle_shd.g_old_rec.reduced_amount <> p_reduced_amount))) THEN

769: --
770: IF P_REDUCED_AMOUNT IS NOT NULL THEN
771: IF ( (p_soc_ins_contr_lvls_id IS NULL) OR
772: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
773: (hr_cle_shd.g_old_rec.reduced_amount <> p_reduced_amount))) THEN
774: --
775: hr_utility.set_location(l_proc, 20);
776:
777: IF (P_REDUCED_AMOUNT < 0) then

Line 846: (hr_cle_shd.g_old_rec.normal_percentage <> p_normal_percentage))) THEN

842: --
843:
844: IF ( (p_soc_ins_contr_lvls_id IS NULL) OR
845: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
846: (hr_cle_shd.g_old_rec.normal_percentage <> p_normal_percentage))) THEN
847: --
848: hr_utility.set_location(l_proc, 20);
849:
850: IF ( P_NORMAL_PERCENTAGE < 0 OR P_NORMAL_PERCENTAGE > 100) then

Line 917: (hr_cle_shd.g_old_rec.normal_percentage <> p_increased_percentage))) THEN

913: -- b) The value for increased percentage has changed
914: --
915: IF ( (p_soc_ins_contr_lvls_id IS NULL) OR
916: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
917: (hr_cle_shd.g_old_rec.normal_percentage <> p_increased_percentage))) THEN
918: --
919: hr_utility.set_location(l_proc, 20);
920:
921: IF ( P_INCREASED_PERCENTAGE < 0 OR P_INCREASED_PERCENTAGE > 100) then

Line 988: (hr_cle_shd.g_old_rec.normal_percentage <> p_reduced_percentage))) THEN

984: -- b) The value for reduced percentage has changed
985: --
986: IF ( (p_soc_ins_contr_lvls_id IS NULL) OR
987: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
988: (hr_cle_shd.g_old_rec.normal_percentage <> p_reduced_percentage))) THEN
989: --
990: hr_utility.set_location(l_proc, 20);
991:
992: IF ( P_REDUCED_PERCENTAGE < 0 OR P_REDUCED_PERCENTAGE > 100) then

Line 1059: (hr_cle_shd.g_old_rec.normal_percentage <> p_normal_percentage))) THEN

1055: --
1056:
1057: IF ( (p_soc_ins_contr_lvls_id IS NULL) OR
1058: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
1059: (hr_cle_shd.g_old_rec.normal_percentage <> p_normal_percentage))) THEN
1060: --
1061: hr_utility.set_location(l_proc, 20);
1062:
1063: IF ( P_NORMAL_PERCENTAGE IS NULL) then

Line 1132: (hr_cle_shd.g_old_rec.increased_percentage <> p_increased_percentage))) THEN

1128: -- b) The value for increased percentage has changed
1129: --
1130: IF ( (p_soc_ins_contr_lvls_id IS NULL) OR
1131: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
1132: (hr_cle_shd.g_old_rec.increased_percentage <> p_increased_percentage))) THEN
1133: --
1134: hr_utility.set_location(l_proc, 20);
1135:
1136: IF ( P_INCREASED_PERCENTAGE IS NULL) then

Line 1204: (hr_cle_shd.g_old_rec.reduced_percentage <> p_reduced_percentage))) THEN

1200: -- b) The value for reduced percentage has changed
1201: --
1202: IF ( (p_soc_ins_contr_lvls_id IS NULL) OR
1203: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
1204: (hr_cle_shd.g_old_rec.reduced_percentage <> p_reduced_percentage))) THEN
1205: --
1206: hr_utility.set_location(l_proc, 20);
1207:
1208: IF ( P_REDUCED_PERCENTAGE IS NULL ) then

Line 1274: (hr_cle_shd.g_old_rec.max_increased_contribution <> p_max_increased_contribution))) THEN

1270: -- b) The value for max_increased_contribution has changed
1271: --
1272: IF ( (p_soc_ins_contr_lvls_id IS NULL) OR
1273: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
1274: (hr_cle_shd.g_old_rec.max_increased_contribution <> p_max_increased_contribution))) THEN
1275: --
1276: hr_utility.set_location(l_proc, 20);
1277:
1278: IF ( p_max_increased_contribution IS NULL ) then

Line 1354: (hr_cle_shd.g_old_rec.min_increased_contribution <> p_min_increased_contribution))) THEN

1350: -- b) The value for min_increased_contribution has changed
1351: --
1352: IF ( (p_soc_ins_contr_lvls_id IS NULL) OR
1353: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
1354: (hr_cle_shd.g_old_rec.min_increased_contribution <> p_min_increased_contribution))) THEN
1355: --
1356: hr_utility.set_location(l_proc, 20);
1357:
1358: IF ( p_min_increased_contribution IS NULL ) then

Line 1435: (hr_cle_shd.g_old_rec.month1_min_contribution <> p_month1_min_contribution))) THEN

1431: -- b) The value for month1_min_contribution has changed
1432: --
1433: IF ( (p_soc_ins_contr_lvls_id IS NULL) OR
1434: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
1435: (hr_cle_shd.g_old_rec.month1_min_contribution <> p_month1_min_contribution))) THEN
1436: --
1437: hr_utility.set_location(l_proc, 20);
1438:
1439: IF ( p_month1_min_contribution IS NULL ) then

Line 1515: (hr_cle_shd.g_old_rec.month1_max_contribution <> p_month1_max_contribution))) THEN

1511: -- b) The value for month1_max_contribution has changed
1512: --
1513: IF ( (p_soc_ins_contr_lvls_id IS NULL) OR
1514: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
1515: (hr_cle_shd.g_old_rec.month1_max_contribution <> p_month1_max_contribution))) THEN
1516: --
1517: hr_utility.set_location(l_proc, 20);
1518:
1519: IF ( p_month1_max_contribution IS NULL ) then

Line 1596: (hr_cle_shd.g_old_rec.month2_min_contribution <> p_month2_min_contribution))) THEN

1592: -- b) The value for month2_min_contribution has changed
1593: --
1594: IF ( (p_soc_ins_contr_lvls_id IS NULL) OR
1595: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
1596: (hr_cle_shd.g_old_rec.month2_min_contribution <> p_month2_min_contribution))) THEN
1597: --
1598: hr_utility.set_location(l_proc, 20);
1599:
1600: IF ( p_month2_min_contribution IS NULL ) then

Line 1676: (hr_cle_shd.g_old_rec.month2_max_contribution <> p_month2_max_contribution))) THEN

1672: -- b) The value for month2_max_contribution has changed
1673: --
1674: IF ( (p_soc_ins_contr_lvls_id IS NULL) OR
1675: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
1676: (hr_cle_shd.g_old_rec.month2_max_contribution <> p_month2_max_contribution))) THEN
1677: --
1678: hr_utility.set_location(l_proc, 20);
1679:
1680: IF ( p_month2_max_contribution IS NULL ) then

Line 1756: (hr_cle_shd.g_old_rec.employee_contribution <> p_employee_contribution))) THEN

1752: --
1753:
1754: IF ( (p_soc_ins_contr_lvls_id IS NULL) OR
1755: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
1756: (hr_cle_shd.g_old_rec.employee_contribution <> p_employee_contribution))) THEN
1757: --
1758: hr_utility.set_location(l_proc, 20);
1759:
1760: IF ( P_EMPLOYEE_CONTRIBUTION < 0 OR P_EMPLOYEE_CONTRIBUTION > 100) then

Line 1835: (hr_cle_shd.g_old_rec.month1 <> p_month1))) THEN

1831: --
1832:
1833: IF ( (p_soc_ins_contr_lvls_id IS NULL) OR
1834: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
1835: (hr_cle_shd.g_old_rec.month1 <> p_month1))) THEN
1836: --
1837: hr_utility.set_location(l_proc, 20);
1838: --
1839: IF (p_month1 IS NOT NULL) THEN

Line 1922: (hr_cle_shd.g_old_rec.month2 <> p_month2))) THEN

1918: --
1919:
1920: IF ( (p_soc_ins_contr_lvls_id IS NULL) OR
1921: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
1922: (hr_cle_shd.g_old_rec.month2 <> p_month2))) THEN
1923: --
1924: hr_utility.set_location(l_proc, 20);
1925: IF (p_month2 IS NOT NULL) THEN
1926: --

Line 1998: (hr_cle_shd.g_old_rec.flat_tax_limit_per_month <> p_flat_tax_limit_per_month))) THEN

1994: -- b) The value for flat_tax_limit_per_month has changed
1995: --
1996: IF ( (p_soc_ins_contr_lvls_id IS NULL) OR
1997: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
1998: (hr_cle_shd.g_old_rec.flat_tax_limit_per_month <> p_flat_tax_limit_per_month))) THEN
1999: --
2000: hr_utility.set_location(l_proc, 20);
2001:
2002: --

Line 2070: (hr_cle_shd.g_old_rec.flat_tax_limit_per_year <> p_flat_tax_limit_per_year))) THEN

2066: -- b) The value for flat_tax_limit_per_year has changed
2067: --
2068: IF ( (p_soc_ins_contr_lvls_id IS NULL) OR
2069: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2070: (hr_cle_shd.g_old_rec.flat_tax_limit_per_year <> p_flat_tax_limit_per_year))) THEN
2071: --
2072: hr_utility.set_location(l_proc, 20);
2073:
2074: --

Line 2145: (hr_cle_shd.g_old_rec.min_increased_contribution <> p_min_increased_contribution)) OR

2141: -- b) The value for min_increased_contribution or min_increased_contribution has changed
2142: --
2143: IF ( (p_soc_ins_contr_lvls_id IS NULL) OR
2144: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2145: (hr_cle_shd.g_old_rec.min_increased_contribution <> p_min_increased_contribution)) OR
2146: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2147: (hr_cle_shd.g_old_rec.max_increased_contribution <> p_max_increased_contribution))) THEN
2148:
2149: --

Line 2147: (hr_cle_shd.g_old_rec.max_increased_contribution <> p_max_increased_contribution))) THEN

2143: IF ( (p_soc_ins_contr_lvls_id IS NULL) OR
2144: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2145: (hr_cle_shd.g_old_rec.min_increased_contribution <> p_min_increased_contribution)) OR
2146: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2147: (hr_cle_shd.g_old_rec.max_increased_contribution <> p_max_increased_contribution))) THEN
2148:
2149: --
2150: hr_utility.set_location(l_proc, 20);
2151:

Line 2225: (hr_cle_shd.g_old_rec.month1_min_contribution <> p_month1_min_contribution)) OR

2221: -- b) The value for month1_min_contribution or month1_min_contribution has changed
2222: --
2223: IF ((p_soc_ins_contr_lvls_id IS NULL) OR
2224: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2225: (hr_cle_shd.g_old_rec.month1_min_contribution <> p_month1_min_contribution)) OR
2226: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2227: (hr_cle_shd.g_old_rec.month1_max_contribution <> p_month1_max_contribution)) OR
2228: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2229: (hr_cle_shd.g_old_rec.min_increased_contribution <> p_min_increased_contribution)) OR

Line 2227: (hr_cle_shd.g_old_rec.month1_max_contribution <> p_month1_max_contribution)) OR

2223: IF ((p_soc_ins_contr_lvls_id IS NULL) OR
2224: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2225: (hr_cle_shd.g_old_rec.month1_min_contribution <> p_month1_min_contribution)) OR
2226: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2227: (hr_cle_shd.g_old_rec.month1_max_contribution <> p_month1_max_contribution)) OR
2228: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2229: (hr_cle_shd.g_old_rec.min_increased_contribution <> p_min_increased_contribution)) OR
2230: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2231: (hr_cle_shd.g_old_rec.max_increased_contribution <> p_max_increased_contribution))) THEN

Line 2229: (hr_cle_shd.g_old_rec.min_increased_contribution <> p_min_increased_contribution)) OR

2225: (hr_cle_shd.g_old_rec.month1_min_contribution <> p_month1_min_contribution)) OR
2226: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2227: (hr_cle_shd.g_old_rec.month1_max_contribution <> p_month1_max_contribution)) OR
2228: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2229: (hr_cle_shd.g_old_rec.min_increased_contribution <> p_min_increased_contribution)) OR
2230: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2231: (hr_cle_shd.g_old_rec.max_increased_contribution <> p_max_increased_contribution))) THEN
2232:
2233: --

Line 2231: (hr_cle_shd.g_old_rec.max_increased_contribution <> p_max_increased_contribution))) THEN

2227: (hr_cle_shd.g_old_rec.month1_max_contribution <> p_month1_max_contribution)) OR
2228: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2229: (hr_cle_shd.g_old_rec.min_increased_contribution <> p_min_increased_contribution)) OR
2230: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2231: (hr_cle_shd.g_old_rec.max_increased_contribution <> p_max_increased_contribution))) THEN
2232:
2233: --
2234: hr_utility.set_location(l_proc, 20);
2235:

Line 2319: (hr_cle_shd.g_old_rec.month2_min_contribution <> p_month2_min_contribution)) OR

2315: -- b) The value for month2_min_contribution or month2_min_contribution has changed
2316: --
2317: IF ( (p_soc_ins_contr_lvls_id IS NULL) OR
2318: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2319: (hr_cle_shd.g_old_rec.month2_min_contribution <> p_month2_min_contribution)) OR
2320: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2321: (hr_cle_shd.g_old_rec.month2_max_contribution <> p_month2_max_contribution)) OR
2322: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2323: (hr_cle_shd.g_old_rec.min_increased_contribution <> p_min_increased_contribution)) OR

Line 2321: (hr_cle_shd.g_old_rec.month2_max_contribution <> p_month2_max_contribution)) OR

2317: IF ( (p_soc_ins_contr_lvls_id IS NULL) OR
2318: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2319: (hr_cle_shd.g_old_rec.month2_min_contribution <> p_month2_min_contribution)) OR
2320: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2321: (hr_cle_shd.g_old_rec.month2_max_contribution <> p_month2_max_contribution)) OR
2322: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2323: (hr_cle_shd.g_old_rec.min_increased_contribution <> p_min_increased_contribution)) OR
2324: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2325: (hr_cle_shd.g_old_rec.max_increased_contribution <> p_max_increased_contribution))) THEN

Line 2323: (hr_cle_shd.g_old_rec.min_increased_contribution <> p_min_increased_contribution)) OR

2319: (hr_cle_shd.g_old_rec.month2_min_contribution <> p_month2_min_contribution)) OR
2320: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2321: (hr_cle_shd.g_old_rec.month2_max_contribution <> p_month2_max_contribution)) OR
2322: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2323: (hr_cle_shd.g_old_rec.min_increased_contribution <> p_min_increased_contribution)) OR
2324: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2325: (hr_cle_shd.g_old_rec.max_increased_contribution <> p_max_increased_contribution))) THEN
2326:
2327:

Line 2325: (hr_cle_shd.g_old_rec.max_increased_contribution <> p_max_increased_contribution))) THEN

2321: (hr_cle_shd.g_old_rec.month2_max_contribution <> p_month2_max_contribution)) OR
2322: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2323: (hr_cle_shd.g_old_rec.min_increased_contribution <> p_min_increased_contribution)) OR
2324: ((p_soc_ins_contr_lvls_id IS NOT NULL) AND
2325: (hr_cle_shd.g_old_rec.max_increased_contribution <> p_max_increased_contribution))) THEN
2326:
2327:
2328: --
2329: hr_utility.set_location(l_proc, 20);

Line 2608: (p_rec in hr_cle_shd.g_rec_type

2604: -- ----------------------------------------------------------------------------
2605: -- |---------------------------< insert_validate >----------------------------|
2606: -- ----------------------------------------------------------------------------
2607: Procedure insert_validate
2608: (p_rec in hr_cle_shd.g_rec_type
2609: ,p_effective_date in date
2610: ,p_datetrack_mode in varchar2
2611: ,p_validation_start_date in date
2612: ,p_validation_end_date in date

Line 2776: (p_rec in hr_cle_shd.g_rec_type

2772: -- ----------------------------------------------------------------------------
2773: -- |---------------------------< update_validate >----------------------------|
2774: -- ----------------------------------------------------------------------------
2775: Procedure update_validate
2776: (p_rec in hr_cle_shd.g_rec_type
2777: ,p_effective_date in date
2778: ,p_datetrack_mode in varchar2
2779: ,p_validation_start_date in date
2780: ,p_validation_end_date in date

Line 2950: (p_rec in hr_cle_shd.g_rec_type

2946: -- ----------------------------------------------------------------------------
2947: -- |---------------------------< delete_validate >----------------------------|
2948: -- ----------------------------------------------------------------------------
2949: Procedure delete_validate
2950: (p_rec in hr_cle_shd.g_rec_type
2951: ,p_effective_date in date
2952: ,p_datetrack_mode in varchar2
2953: ,p_validation_start_date in date
2954: ,p_validation_end_date in date