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.IRC_IOF_BUS dependencies on IRC_IOF_SHD

Line 185: (p_rec in irc_iof_shd.g_rec_type

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

Line 194: nvl(irc_iof_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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

Line 196: nvl(irc_iof_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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

Line 198: nvl(irc_iof_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

Line 200: nvl(irc_iof_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

Line 202: nvl(irc_iof_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

Line 204: nvl(irc_iof_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

Line 206: nvl(irc_iof_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

Line 208: nvl(irc_iof_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

Line 210: nvl(irc_iof_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

Line 212: nvl(irc_iof_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

Line 214: nvl(irc_iof_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

Line 216: nvl(irc_iof_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

Line 218: nvl(irc_iof_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

Line 220: nvl(irc_iof_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

Line 222: nvl(irc_iof_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

Line 224: nvl(irc_iof_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

Line 226: nvl(irc_iof_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

Line 228: nvl(irc_iof_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

Line 230: nvl(irc_iof_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

Line 232: nvl(irc_iof_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

Line 234: nvl(irc_iof_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

Line 236: nvl(irc_iof_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

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

Line 238: nvl(irc_iof_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

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

Line 240: nvl(irc_iof_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

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

Line 242: nvl(irc_iof_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

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

Line 244: nvl(irc_iof_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

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

Line 246: nvl(irc_iof_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

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

Line 248: nvl(irc_iof_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

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

Line 250: nvl(irc_iof_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

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

Line 252: nvl(irc_iof_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

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

Line 254: nvl(irc_iof_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

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

Line 363: ,p_rec in irc_iof_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 irc_iof_shd.g_rec_type
364: ) IS
365: --
366: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
367: --

Line 373: IF NOT irc_iof_shd.api_updating

369: --
370: -- Only proceed with the validation if a row exists for the current
371: -- record in the HR Schema.
372: --
373: IF NOT irc_iof_shd.api_updating
374: (p_offer_id => p_rec.offer_id
375: ,p_object_version_number => p_rec.object_version_number
376: ) THEN
377: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 383: if irc_iof_shd.g_old_rec.offer_id <> p_rec.offer_id

379: fnd_message.set_token('STEP ', '5');
380: fnd_message.raise_error;
381: END IF;
382: --
383: if irc_iof_shd.g_old_rec.offer_id <> p_rec.offer_id
384: then
385: hr_api.argument_changed_error
386: (p_api_name => l_proc
387: ,p_argument => 'offer_id'

Line 388: ,p_base_table => irc_iof_shd.g_tab_name

384: then
385: hr_api.argument_changed_error
386: (p_api_name => l_proc
387: ,p_argument => 'offer_id'
388: ,p_base_table => irc_iof_shd.g_tab_name
389: );
390: end if;
391: --
392: if irc_iof_shd.g_old_rec.applicant_assignment_id <> p_rec.applicant_assignment_id

Line 392: if irc_iof_shd.g_old_rec.applicant_assignment_id <> p_rec.applicant_assignment_id

388: ,p_base_table => irc_iof_shd.g_tab_name
389: );
390: end if;
391: --
392: if irc_iof_shd.g_old_rec.applicant_assignment_id <> p_rec.applicant_assignment_id
393: then
394: hr_api.argument_changed_error
395: (p_api_name => l_proc
396: ,p_argument => 'applicant_assignment_id'

Line 397: ,p_base_table => irc_iof_shd.g_tab_name

393: then
394: hr_api.argument_changed_error
395: (p_api_name => l_proc
396: ,p_argument => 'applicant_assignment_id'
397: ,p_base_table => irc_iof_shd.g_tab_name
398: );
399: end if;
400: --
401: if irc_iof_shd.g_old_rec.offer_assignment_id <> p_rec.offer_assignment_id

Line 401: if irc_iof_shd.g_old_rec.offer_assignment_id <> p_rec.offer_assignment_id

397: ,p_base_table => irc_iof_shd.g_tab_name
398: );
399: end if;
400: --
401: if irc_iof_shd.g_old_rec.offer_assignment_id <> p_rec.offer_assignment_id
402: then
403: hr_api.argument_changed_error
404: (p_api_name => l_proc
405: ,p_argument => 'offer_assignment_id'

Line 406: ,p_base_table => irc_iof_shd.g_tab_name

402: then
403: hr_api.argument_changed_error
404: (p_api_name => l_proc
405: ,p_argument => 'offer_assignment_id'
406: ,p_base_table => irc_iof_shd.g_tab_name
407: );
408: end if;
409: --
410: if irc_iof_shd.g_old_rec.vacancy_id <> p_rec.vacancy_id

Line 410: if irc_iof_shd.g_old_rec.vacancy_id <> p_rec.vacancy_id

406: ,p_base_table => irc_iof_shd.g_tab_name
407: );
408: end if;
409: --
410: if irc_iof_shd.g_old_rec.vacancy_id <> p_rec.vacancy_id
411: then
412: hr_api.argument_changed_error
413: (p_api_name => l_proc
414: ,p_argument => 'vacancy_id'

Line 415: ,p_base_table => irc_iof_shd.g_tab_name

411: then
412: hr_api.argument_changed_error
413: (p_api_name => l_proc
414: ,p_argument => 'vacancy_id'
415: ,p_base_table => irc_iof_shd.g_tab_name
416: );
417: end if;
418: --
419: if irc_iof_shd.g_old_rec.offer_version <> p_rec.offer_version

Line 419: if irc_iof_shd.g_old_rec.offer_version <> p_rec.offer_version

415: ,p_base_table => irc_iof_shd.g_tab_name
416: );
417: end if;
418: --
419: if irc_iof_shd.g_old_rec.offer_version <> p_rec.offer_version
420: then
421: hr_api.argument_changed_error
422: (p_api_name => l_proc
423: ,p_argument => 'offer_version'

Line 424: ,p_base_table => irc_iof_shd.g_tab_name

420: then
421: hr_api.argument_changed_error
422: (p_api_name => l_proc
423: ,p_argument => 'offer_version'
424: ,p_base_table => irc_iof_shd.g_tab_name
425: );
426: end if;
427: --
428: End chk_non_updateable_args;

Line 955: l_api_updating := irc_iof_shd.api_updating

951: -- Only proceed with validation if :
952: -- a) The current g_old_rec is current and
953: -- b) The value for respondant_id has changed
954: --
955: l_api_updating := irc_iof_shd.api_updating
956: (p_offer_id => p_offer_id
957: ,p_object_version_number => p_object_version_number);
958: --
959: hr_utility.set_location(l_proc,20);

Line 962: and nvl(irc_iof_shd.g_old_rec.respondent_id, hr_api.g_number) <>

958: --
959: hr_utility.set_location(l_proc,20);
960:
961: if ((l_api_updating
962: and nvl(irc_iof_shd.g_old_rec.respondent_id, hr_api.g_number) <>
963: nvl(p_respondent_id, hr_api.g_number))
964: or
965: (NOT l_api_updating)) then
966: --

Line 1043: l_prev_expiry_date irc_offers.expiry_date%TYPE := irc_iof_shd.g_old_rec.expiry_date;

1039: l_proc varchar2(72) := g_package || 'chk_expiry_date';
1040: l_offer_duration_value varchar2(30);
1041: l_offer_duration_measurement varchar2(30);
1042: l_expiry_date irc_offers.expiry_date%TYPE := p_expiry_date;
1043: l_prev_expiry_date irc_offers.expiry_date%TYPE := irc_iof_shd.g_old_rec.expiry_date;
1044: l_prev_offer_postal_service irc_offers.offer_postal_service%TYPE := irc_iof_shd.g_old_rec.offer_postal_service;
1045: l_prev_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE := irc_iof_shd.g_old_rec.offer_letter_tracking_code;
1046: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE := irc_iof_shd.g_old_rec.offer_shipping_date;
1047: l_effective_date date;

Line 1044: l_prev_offer_postal_service irc_offers.offer_postal_service%TYPE := irc_iof_shd.g_old_rec.offer_postal_service;

1040: l_offer_duration_value varchar2(30);
1041: l_offer_duration_measurement varchar2(30);
1042: l_expiry_date irc_offers.expiry_date%TYPE := p_expiry_date;
1043: l_prev_expiry_date irc_offers.expiry_date%TYPE := irc_iof_shd.g_old_rec.expiry_date;
1044: l_prev_offer_postal_service irc_offers.offer_postal_service%TYPE := irc_iof_shd.g_old_rec.offer_postal_service;
1045: l_prev_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE := irc_iof_shd.g_old_rec.offer_letter_tracking_code;
1046: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE := irc_iof_shd.g_old_rec.offer_shipping_date;
1047: l_effective_date date;
1048: --

Line 1045: l_prev_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE := irc_iof_shd.g_old_rec.offer_letter_tracking_code;

1041: l_offer_duration_measurement varchar2(30);
1042: l_expiry_date irc_offers.expiry_date%TYPE := p_expiry_date;
1043: l_prev_expiry_date irc_offers.expiry_date%TYPE := irc_iof_shd.g_old_rec.expiry_date;
1044: l_prev_offer_postal_service irc_offers.offer_postal_service%TYPE := irc_iof_shd.g_old_rec.offer_postal_service;
1045: l_prev_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE := irc_iof_shd.g_old_rec.offer_letter_tracking_code;
1046: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE := irc_iof_shd.g_old_rec.offer_shipping_date;
1047: l_effective_date date;
1048: --
1049: Begin

Line 1046: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE := irc_iof_shd.g_old_rec.offer_shipping_date;

1042: l_expiry_date irc_offers.expiry_date%TYPE := p_expiry_date;
1043: l_prev_expiry_date irc_offers.expiry_date%TYPE := irc_iof_shd.g_old_rec.expiry_date;
1044: l_prev_offer_postal_service irc_offers.offer_postal_service%TYPE := irc_iof_shd.g_old_rec.offer_postal_service;
1045: l_prev_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE := irc_iof_shd.g_old_rec.offer_letter_tracking_code;
1046: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE := irc_iof_shd.g_old_rec.offer_shipping_date;
1047: l_effective_date date;
1048: --
1049: Begin
1050: hr_utility.set_location('Entering:'||l_proc,10);

Line 1312: l_api_updating := irc_iof_shd.api_updating

1308: -- Only proceed with validation if :
1309: -- a) The current g_old_rec is current and
1310: -- b) The value for address_id has changed
1311: --
1312: l_api_updating := irc_iof_shd.api_updating
1313: (p_offer_id => p_offer_id
1314: ,p_object_version_number => p_object_version_number);
1315: --
1316: hr_utility.set_location(l_proc,20);

Line 1319: and nvl(irc_iof_shd.g_old_rec.address_id, hr_api.g_number) <>

1315: --
1316: hr_utility.set_location(l_proc,20);
1317:
1318: if ((l_api_updating
1319: and nvl(irc_iof_shd.g_old_rec.address_id, hr_api.g_number) <>
1320: nvl(p_address_id, hr_api.g_number))
1321: or
1322: (NOT l_api_updating)) then
1323: --

Line 1446: l_api_updating := irc_iof_shd.api_updating

1442: -- Only proceed with validation if :
1443: -- a) The current g_old_rec is current and
1444: -- b) The value for template_id has changed
1445: --
1446: l_api_updating := irc_iof_shd.api_updating
1447: (p_offer_id => p_offer_id
1448: ,p_object_version_number => p_object_version_number);
1449: --
1450: hr_utility.set_location(l_proc,20);

Line 1453: and nvl(irc_iof_shd.g_old_rec.template_id, hr_api.g_number) <>

1449: --
1450: hr_utility.set_location(l_proc,20);
1451:
1452: if ((l_api_updating
1453: and nvl(irc_iof_shd.g_old_rec.template_id, hr_api.g_number) <>
1454: nvl(p_template_id, hr_api.g_number)) or
1455: (NOT l_api_updating)) then
1456: --
1457: -- Check if template id is not null and if it is active

Line 1693: l_api_updating := irc_iof_shd.api_updating

1689: -- Only proceed with validation if :
1690: -- a) The current g_old_rec is current and
1691: -- b) The value for latest_offer has changed
1692: --
1693: l_api_updating := irc_iof_shd.api_updating
1694: (p_offer_id => p_offer_id
1695: ,p_object_version_number => p_object_version_number);
1696: --
1697: hr_utility.set_location(l_proc,20);

Line 1723: and nvl(irc_iof_shd.g_old_rec.latest_offer, hr_api.g_varchar2) <>

1719: --
1720: end if;
1721: --
1722: elsif (l_api_updating
1723: and nvl(irc_iof_shd.g_old_rec.latest_offer, hr_api.g_varchar2) <>
1724: nvl(p_latest_offer, hr_api.g_varchar2))
1725: then
1726: if ( p_offer_status <> 'SAVED')
1727: then

Line 1746: and nvl(irc_iof_shd.g_old_rec.latest_offer, hr_api.g_varchar2) <>

1742: --
1743: end if;
1744: --
1745: if ((l_api_updating
1746: and nvl(irc_iof_shd.g_old_rec.latest_offer, hr_api.g_varchar2) <>
1747: nvl(p_latest_offer, hr_api.g_varchar2))
1748: or (NOT l_api_updating)) then
1749: --
1750: hr_utility.set_location(l_proc,40);

Line 1842: l_api_updating := irc_iof_shd.api_updating

1838: -- Only proceed with validation if :
1839: -- a) The current g_old_rec is current and
1840: -- b) The value for offer version has changed or applicant_assignment_id has changed
1841: --
1842: l_api_updating := irc_iof_shd.api_updating
1843: (p_offer_id => p_offer_id
1844: ,p_object_version_number => p_object_version_number);
1845: --
1846: if ((l_api_updating and

Line 1847: ((nvl(irc_iof_shd.g_old_rec.offer_version, hr_api.g_number) <>

1843: (p_offer_id => p_offer_id
1844: ,p_object_version_number => p_object_version_number);
1845: --
1846: if ((l_api_updating and
1847: ((nvl(irc_iof_shd.g_old_rec.offer_version, hr_api.g_number) <>
1848: nvl(p_offer_version, hr_api.g_number))
1849: or
1850: (nvl(irc_iof_shd.g_old_rec.applicant_assignment_id, hr_api.g_number) <>
1851: nvl(p_applicant_assignment_id, hr_api.g_number))

Line 1850: (nvl(irc_iof_shd.g_old_rec.applicant_assignment_id, hr_api.g_number) <>

1846: if ((l_api_updating and
1847: ((nvl(irc_iof_shd.g_old_rec.offer_version, hr_api.g_number) <>
1848: nvl(p_offer_version, hr_api.g_number))
1849: or
1850: (nvl(irc_iof_shd.g_old_rec.applicant_assignment_id, hr_api.g_number) <>
1851: nvl(p_applicant_assignment_id, hr_api.g_number))
1852: ))
1853: or
1854: (NOT l_api_updating)) then

Line 1940: l_api_updating := irc_iof_shd.api_updating

1936: -- Only proceed with validation if :
1937: -- a) The current g_old_rec is current and
1938: -- b) The value of offer status has changed
1939: --
1940: l_api_updating := irc_iof_shd.api_updating
1941: (p_offer_id => p_offer_id
1942: ,p_object_version_number => p_object_version_number);
1943: --
1944: if ((l_api_updating

Line 1945: and nvl(irc_iof_shd.g_old_rec.offer_status, hr_api.g_varchar2) <>

1941: (p_offer_id => p_offer_id
1942: ,p_object_version_number => p_object_version_number);
1943: --
1944: if ((l_api_updating
1945: and nvl(irc_iof_shd.g_old_rec.offer_status, hr_api.g_varchar2) <>
1946: nvl(p_offer_status, hr_api.g_varchar2))
1947: or
1948: (NOT l_api_updating)) then
1949: --

Line 2032: ( p_current_offer_record in irc_iof_shd.g_rec_type

2028: --
2029: -- {End Of Comments}
2030: -- ----------------------------------------------------------------------------
2031: procedure chk_offer_status_update
2032: ( p_current_offer_record in irc_iof_shd.g_rec_type
2033: )IS
2034: --
2035: l_proc varchar2(72) := g_package||'chk_offer_status_update';
2036: l_prev_offer_status irc_offers.offer_status%TYPE := irc_iof_shd.g_old_rec.offer_status;

Line 2036: l_prev_offer_status irc_offers.offer_status%TYPE := irc_iof_shd.g_old_rec.offer_status;

2032: ( p_current_offer_record in irc_iof_shd.g_rec_type
2033: )IS
2034: --
2035: l_proc varchar2(72) := g_package||'chk_offer_status_update';
2036: l_prev_offer_status irc_offers.offer_status%TYPE := irc_iof_shd.g_old_rec.offer_status;
2037: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
2038: l_mutiple_fields_updated boolean;
2039: --
2040: cursor csr_prev_to_prev_offer_status is

Line 3074: l_api_updating := irc_iof_shd.api_updating

3070: -- Only proceed with validation if :
3071: -- a) The current g_old_rec is current and
3072: -- b) The value for offer extended method has changed
3073: --
3074: l_api_updating := irc_iof_shd.api_updating
3075: (p_offer_id => p_offer_id
3076: ,p_object_version_number => p_object_version_number);
3077: --
3078: if ((l_api_updating

Line 3079: and nvl(irc_iof_shd.g_old_rec.offer_extended_method, hr_api.g_varchar2) <>

3075: (p_offer_id => p_offer_id
3076: ,p_object_version_number => p_object_version_number);
3077: --
3078: if ((l_api_updating
3079: and nvl(irc_iof_shd.g_old_rec.offer_extended_method, hr_api.g_varchar2) <>
3080: nvl(p_offer_extended_method, hr_api.g_varchar2))
3081: or
3082: (NOT l_api_updating)) then
3083: --

Line 3178: l_api_updating := irc_iof_shd.api_updating

3174: -- Only proceed with validation if :
3175: -- a) The current g_old_rec is current and
3176: -- b) The value for offer postal service has changed
3177: --
3178: l_api_updating := irc_iof_shd.api_updating
3179: (p_offer_id => p_offer_id
3180: ,p_object_version_number => p_object_version_number);
3181: --
3182: if ((l_api_updating

Line 3183: and nvl(irc_iof_shd.g_old_rec.offer_postal_service, hr_api.g_varchar2) <>

3179: (p_offer_id => p_offer_id
3180: ,p_object_version_number => p_object_version_number);
3181: --
3182: if ((l_api_updating
3183: and nvl(irc_iof_shd.g_old_rec.offer_postal_service, hr_api.g_varchar2) <>
3184: nvl(p_offer_postal_service, hr_api.g_varchar2))
3185: or
3186: (NOT l_api_updating)) then
3187: --

Line 3272: and nvl(irc_iof_shd.g_old_rec.offer_status, hr_api.g_varchar2) <>

3268: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3269: ) then
3270: --
3271: if p_offer_status = 'APPROVED'
3272: and nvl(irc_iof_shd.g_old_rec.offer_status, hr_api.g_varchar2) <>
3273: nvl(p_offer_status, hr_api.g_varchar2)
3274: then
3275: --
3276: hr_utility.set_location(l_proc, 20);

Line 3379: l_api_updating := irc_iof_shd.api_updating

3375: -- Only proceed with validation if :
3376: -- a) The current g_old_rec is current and
3377: -- b) The value for offer postal service has changed
3378: --
3379: l_api_updating := irc_iof_shd.api_updating
3380: (p_offer_id => p_offer_id
3381: ,p_object_version_number => p_object_version_number);
3382: --
3383: if ((l_api_updating

Line 3384: and nvl(irc_iof_shd.g_old_rec.offer_letter_file_type, hr_api.g_varchar2) <>

3380: (p_offer_id => p_offer_id
3381: ,p_object_version_number => p_object_version_number);
3382: --
3383: if ((l_api_updating
3384: and nvl(irc_iof_shd.g_old_rec.offer_letter_file_type, hr_api.g_varchar2) <>
3385: nvl(p_offer_letter_file_type, hr_api.g_varchar2))
3386: or
3387: (NOT l_api_updating)) then
3388: --

Line 3430: ,p_rec in out nocopy irc_iof_shd.g_rec_type

3426: -- ----------------------------------------------------------------------------
3427: --
3428: Procedure insert_validate
3429: (p_effective_date in date
3430: ,p_rec in out nocopy irc_iof_shd.g_rec_type
3431: ) is
3432: --
3433: l_proc varchar2(72) := g_package||'insert_validate';
3434: --

Line 3582: ,p_rec in out nocopy irc_iof_shd.g_rec_type

3578: -- |---------------------------< update_validate >----------------------------|
3579: -- ----------------------------------------------------------------------------
3580: Procedure update_validate
3581: (p_effective_date in date
3582: ,p_rec in out nocopy irc_iof_shd.g_rec_type
3583: ) is
3584: --
3585: l_proc varchar2(72) := g_package||'update_validate';
3586: --

Line 3715: (p_rec in irc_iof_shd.g_rec_type

3711: -- ----------------------------------------------------------------------------
3712: -- |---------------------------< delete_validate >----------------------------|
3713: -- ----------------------------------------------------------------------------
3714: Procedure delete_validate
3715: (p_rec in irc_iof_shd.g_rec_type
3716: ) is
3717: --
3718: l_proc varchar2(72) := g_package||'delete_validate';
3719: --