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 928: l_api_updating := irc_iof_shd.api_updating

924: -- Only proceed with validation if :
925: -- a) The current g_old_rec is current and
926: -- b) The value for respondant_id has changed
927: --
928: l_api_updating := irc_iof_shd.api_updating
929: (p_offer_id => p_offer_id
930: ,p_object_version_number => p_object_version_number);
931: --
932: hr_utility.set_location(l_proc,20);

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

931: --
932: hr_utility.set_location(l_proc,20);
933:
934: if ((l_api_updating
935: and nvl(irc_iof_shd.g_old_rec.respondent_id, hr_api.g_number) <>
936: nvl(p_respondent_id, hr_api.g_number))
937: or
938: (NOT l_api_updating)) then
939: --

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

1012: l_proc varchar2(72) := g_package || 'chk_expiry_date';
1013: l_offer_duration_value varchar2(30);
1014: l_offer_duration_measurement varchar2(30);
1015: l_expiry_date irc_offers.expiry_date%TYPE := p_expiry_date;
1016: l_prev_expiry_date irc_offers.expiry_date%TYPE := irc_iof_shd.g_old_rec.expiry_date;
1017: l_prev_offer_postal_service irc_offers.offer_postal_service%TYPE := irc_iof_shd.g_old_rec.offer_postal_service;
1018: l_prev_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE := irc_iof_shd.g_old_rec.offer_letter_tracking_code;
1019: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE := irc_iof_shd.g_old_rec.offer_shipping_date;
1020: l_effective_date date;

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

1013: l_offer_duration_value varchar2(30);
1014: l_offer_duration_measurement varchar2(30);
1015: l_expiry_date irc_offers.expiry_date%TYPE := p_expiry_date;
1016: l_prev_expiry_date irc_offers.expiry_date%TYPE := irc_iof_shd.g_old_rec.expiry_date;
1017: l_prev_offer_postal_service irc_offers.offer_postal_service%TYPE := irc_iof_shd.g_old_rec.offer_postal_service;
1018: l_prev_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE := irc_iof_shd.g_old_rec.offer_letter_tracking_code;
1019: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE := irc_iof_shd.g_old_rec.offer_shipping_date;
1020: l_effective_date date;
1021: --

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

1014: l_offer_duration_measurement varchar2(30);
1015: l_expiry_date irc_offers.expiry_date%TYPE := p_expiry_date;
1016: l_prev_expiry_date irc_offers.expiry_date%TYPE := irc_iof_shd.g_old_rec.expiry_date;
1017: l_prev_offer_postal_service irc_offers.offer_postal_service%TYPE := irc_iof_shd.g_old_rec.offer_postal_service;
1018: l_prev_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE := irc_iof_shd.g_old_rec.offer_letter_tracking_code;
1019: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE := irc_iof_shd.g_old_rec.offer_shipping_date;
1020: l_effective_date date;
1021: --
1022: Begin

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

1015: l_expiry_date irc_offers.expiry_date%TYPE := p_expiry_date;
1016: l_prev_expiry_date irc_offers.expiry_date%TYPE := irc_iof_shd.g_old_rec.expiry_date;
1017: l_prev_offer_postal_service irc_offers.offer_postal_service%TYPE := irc_iof_shd.g_old_rec.offer_postal_service;
1018: l_prev_letter_tracking_code irc_offers.offer_letter_tracking_code%TYPE := irc_iof_shd.g_old_rec.offer_letter_tracking_code;
1019: l_prev_offer_shipping_date irc_offers.offer_shipping_date%TYPE := irc_iof_shd.g_old_rec.offer_shipping_date;
1020: l_effective_date date;
1021: --
1022: Begin
1023: hr_utility.set_location('Entering:'||l_proc,10);

Line 1285: l_api_updating := irc_iof_shd.api_updating

1281: -- Only proceed with validation if :
1282: -- a) The current g_old_rec is current and
1283: -- b) The value for address_id has changed
1284: --
1285: l_api_updating := irc_iof_shd.api_updating
1286: (p_offer_id => p_offer_id
1287: ,p_object_version_number => p_object_version_number);
1288: --
1289: hr_utility.set_location(l_proc,20);

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

1288: --
1289: hr_utility.set_location(l_proc,20);
1290:
1291: if ((l_api_updating
1292: and nvl(irc_iof_shd.g_old_rec.address_id, hr_api.g_number) <>
1293: nvl(p_address_id, hr_api.g_number))
1294: or
1295: (NOT l_api_updating)) then
1296: --

Line 1419: l_api_updating := irc_iof_shd.api_updating

1415: -- Only proceed with validation if :
1416: -- a) The current g_old_rec is current and
1417: -- b) The value for template_id has changed
1418: --
1419: l_api_updating := irc_iof_shd.api_updating
1420: (p_offer_id => p_offer_id
1421: ,p_object_version_number => p_object_version_number);
1422: --
1423: hr_utility.set_location(l_proc,20);

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

1422: --
1423: hr_utility.set_location(l_proc,20);
1424:
1425: if ((l_api_updating
1426: and nvl(irc_iof_shd.g_old_rec.template_id, hr_api.g_number) <>
1427: nvl(p_template_id, hr_api.g_number)) or
1428: (NOT l_api_updating)) then
1429: --
1430: -- Check if template id is not null and if it is active

Line 1656: l_api_updating := irc_iof_shd.api_updating

1652: -- Only proceed with validation if :
1653: -- a) The current g_old_rec is current and
1654: -- b) The value for latest_offer has changed
1655: --
1656: l_api_updating := irc_iof_shd.api_updating
1657: (p_offer_id => p_offer_id
1658: ,p_object_version_number => p_object_version_number);
1659: --
1660: hr_utility.set_location(l_proc,20);

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

1682: --
1683: end if;
1684: --
1685: elsif (l_api_updating
1686: and nvl(irc_iof_shd.g_old_rec.latest_offer, hr_api.g_varchar2) <>
1687: nvl(p_latest_offer, hr_api.g_varchar2))
1688: then
1689: if ( p_offer_status <> 'SAVED')
1690: then

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

1705: --
1706: end if;
1707: --
1708: if ((l_api_updating
1709: and nvl(irc_iof_shd.g_old_rec.latest_offer, hr_api.g_varchar2) <>
1710: nvl(p_latest_offer, hr_api.g_varchar2))
1711: or (NOT l_api_updating)) then
1712: --
1713: hr_utility.set_location(l_proc,40);

Line 1805: l_api_updating := irc_iof_shd.api_updating

1801: -- Only proceed with validation if :
1802: -- a) The current g_old_rec is current and
1803: -- b) The value for offer version has changed or applicant_assignment_id has changed
1804: --
1805: l_api_updating := irc_iof_shd.api_updating
1806: (p_offer_id => p_offer_id
1807: ,p_object_version_number => p_object_version_number);
1808: --
1809: if ((l_api_updating and

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

1806: (p_offer_id => p_offer_id
1807: ,p_object_version_number => p_object_version_number);
1808: --
1809: if ((l_api_updating and
1810: ((nvl(irc_iof_shd.g_old_rec.offer_version, hr_api.g_number) <>
1811: nvl(p_offer_version, hr_api.g_number))
1812: or
1813: (nvl(irc_iof_shd.g_old_rec.applicant_assignment_id, hr_api.g_number) <>
1814: nvl(p_applicant_assignment_id, hr_api.g_number))

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

1809: if ((l_api_updating and
1810: ((nvl(irc_iof_shd.g_old_rec.offer_version, hr_api.g_number) <>
1811: nvl(p_offer_version, hr_api.g_number))
1812: or
1813: (nvl(irc_iof_shd.g_old_rec.applicant_assignment_id, hr_api.g_number) <>
1814: nvl(p_applicant_assignment_id, hr_api.g_number))
1815: ))
1816: or
1817: (NOT l_api_updating)) then

Line 1903: l_api_updating := irc_iof_shd.api_updating

1899: -- Only proceed with validation if :
1900: -- a) The current g_old_rec is current and
1901: -- b) The value of offer status has changed
1902: --
1903: l_api_updating := irc_iof_shd.api_updating
1904: (p_offer_id => p_offer_id
1905: ,p_object_version_number => p_object_version_number);
1906: --
1907: if ((l_api_updating

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

1904: (p_offer_id => p_offer_id
1905: ,p_object_version_number => p_object_version_number);
1906: --
1907: if ((l_api_updating
1908: and nvl(irc_iof_shd.g_old_rec.offer_status, hr_api.g_varchar2) <>
1909: nvl(p_offer_status, hr_api.g_varchar2))
1910: or
1911: (NOT l_api_updating)) then
1912: --

Line 1995: ( p_current_offer_record in irc_iof_shd.g_rec_type

1991: --
1992: -- {End Of Comments}
1993: -- ----------------------------------------------------------------------------
1994: procedure chk_offer_status_update
1995: ( p_current_offer_record in irc_iof_shd.g_rec_type
1996: )IS
1997: --
1998: l_proc varchar2(72) := g_package||'chk_offer_status_update';
1999: l_prev_offer_status irc_offers.offer_status%TYPE := irc_iof_shd.g_old_rec.offer_status;

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

1995: ( p_current_offer_record in irc_iof_shd.g_rec_type
1996: )IS
1997: --
1998: l_proc varchar2(72) := g_package||'chk_offer_status_update';
1999: l_prev_offer_status irc_offers.offer_status%TYPE := irc_iof_shd.g_old_rec.offer_status;
2000: l_prev_to_prev_offer_status irc_offers.offer_status%TYPE;
2001: l_mutiple_fields_updated boolean;
2002: --
2003: cursor csr_prev_to_prev_offer_status is

Line 3023: l_api_updating := irc_iof_shd.api_updating

3019: -- Only proceed with validation if :
3020: -- a) The current g_old_rec is current and
3021: -- b) The value for offer extended method has changed
3022: --
3023: l_api_updating := irc_iof_shd.api_updating
3024: (p_offer_id => p_offer_id
3025: ,p_object_version_number => p_object_version_number);
3026: --
3027: if ((l_api_updating

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

3024: (p_offer_id => p_offer_id
3025: ,p_object_version_number => p_object_version_number);
3026: --
3027: if ((l_api_updating
3028: and nvl(irc_iof_shd.g_old_rec.offer_extended_method, hr_api.g_varchar2) <>
3029: nvl(p_offer_extended_method, hr_api.g_varchar2))
3030: or
3031: (NOT l_api_updating)) then
3032: --

Line 3127: l_api_updating := irc_iof_shd.api_updating

3123: -- Only proceed with validation if :
3124: -- a) The current g_old_rec is current and
3125: -- b) The value for offer postal service has changed
3126: --
3127: l_api_updating := irc_iof_shd.api_updating
3128: (p_offer_id => p_offer_id
3129: ,p_object_version_number => p_object_version_number);
3130: --
3131: if ((l_api_updating

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

3128: (p_offer_id => p_offer_id
3129: ,p_object_version_number => p_object_version_number);
3130: --
3131: if ((l_api_updating
3132: and nvl(irc_iof_shd.g_old_rec.offer_postal_service, hr_api.g_varchar2) <>
3133: nvl(p_offer_postal_service, hr_api.g_varchar2))
3134: or
3135: (NOT l_api_updating)) then
3136: --

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

3217: ,p_check_column3 => 'IRC_OFFERS.VACANCY_ID'
3218: ) then
3219: --
3220: if p_offer_status = 'APPROVED'
3221: and nvl(irc_iof_shd.g_old_rec.offer_status, hr_api.g_varchar2) <>
3222: nvl(p_offer_status, hr_api.g_varchar2)
3223: then
3224: --
3225: hr_utility.set_location(l_proc, 20);

Line 3328: l_api_updating := irc_iof_shd.api_updating

3324: -- Only proceed with validation if :
3325: -- a) The current g_old_rec is current and
3326: -- b) The value for offer postal service has changed
3327: --
3328: l_api_updating := irc_iof_shd.api_updating
3329: (p_offer_id => p_offer_id
3330: ,p_object_version_number => p_object_version_number);
3331: --
3332: if ((l_api_updating

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

3329: (p_offer_id => p_offer_id
3330: ,p_object_version_number => p_object_version_number);
3331: --
3332: if ((l_api_updating
3333: and nvl(irc_iof_shd.g_old_rec.offer_letter_file_type, hr_api.g_varchar2) <>
3334: nvl(p_offer_letter_file_type, hr_api.g_varchar2))
3335: or
3336: (NOT l_api_updating)) then
3337: --

Line 3379: ,p_rec in out nocopy irc_iof_shd.g_rec_type

3375: -- ----------------------------------------------------------------------------
3376: --
3377: Procedure insert_validate
3378: (p_effective_date in date
3379: ,p_rec in out nocopy irc_iof_shd.g_rec_type
3380: ) is
3381: --
3382: l_proc varchar2(72) := g_package||'insert_validate';
3383: --

Line 3528: ,p_rec in out nocopy irc_iof_shd.g_rec_type

3524: -- |---------------------------< update_validate >----------------------------|
3525: -- ----------------------------------------------------------------------------
3526: Procedure update_validate
3527: (p_effective_date in date
3528: ,p_rec in out nocopy irc_iof_shd.g_rec_type
3529: ) is
3530: --
3531: l_proc varchar2(72) := g_package||'update_validate';
3532: --

Line 3661: (p_rec in irc_iof_shd.g_rec_type

3657: -- ----------------------------------------------------------------------------
3658: -- |---------------------------< delete_validate >----------------------------|
3659: -- ----------------------------------------------------------------------------
3660: Procedure delete_validate
3661: (p_rec in irc_iof_shd.g_rec_type
3662: ) is
3663: --
3664: l_proc varchar2(72) := g_package||'delete_validate';
3665: --