APPS.HR_ORU_BUS dependencies on HR_ORU_SHD

Line 178: (p_rec in hr_oru_shd.g_rec_type

174: -- Internal Row Handler Use Only.
175: --
176: -- ----------------------------------------------------------------------------
177: procedure chk_df
178: (p_rec in hr_oru_shd.g_rec_type
179: ) is
180: --
181: l_proc varchar2(72) := g_package || 'chk_df';
182: --

Line 187: nvl(hr_oru_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

183: begin
184: hr_utility.set_location('Entering:'||l_proc,10);
185: --
186: if ((p_rec.organization_id is not null) and (
187: nvl(hr_oru_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
189: nvl(hr_oru_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute1, hr_api.g_varchar2) or
191: nvl(hr_oru_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 189: nvl(hr_oru_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

185: --
186: if ((p_rec.organization_id is not null) and (
187: nvl(hr_oru_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
189: nvl(hr_oru_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute1, hr_api.g_varchar2) or
191: nvl(hr_oru_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute2, hr_api.g_varchar2) or
193: nvl(hr_oru_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 191: nvl(hr_oru_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

187: nvl(hr_oru_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
188: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
189: nvl(hr_oru_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute1, hr_api.g_varchar2) or
191: nvl(hr_oru_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute2, hr_api.g_varchar2) or
193: nvl(hr_oru_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
194: nvl(p_rec.attribute3, hr_api.g_varchar2) or
195: nvl(hr_oru_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 193: nvl(hr_oru_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

Line 195: nvl(hr_oru_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

Line 197: nvl(hr_oru_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

Line 199: nvl(hr_oru_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

Line 201: nvl(hr_oru_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

Line 203: nvl(hr_oru_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

Line 205: nvl(hr_oru_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

Line 207: nvl(hr_oru_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

Line 209: nvl(hr_oru_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

Line 211: nvl(hr_oru_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

Line 213: nvl(hr_oru_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

Line 215: nvl(hr_oru_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

Line 217: nvl(hr_oru_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

Line 219: nvl(hr_oru_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

Line 221: nvl(hr_oru_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

Line 223: nvl(hr_oru_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

Line 225: nvl(hr_oru_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

221: nvl(hr_oru_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute17, hr_api.g_varchar2) or
223: nvl(hr_oru_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute18, hr_api.g_varchar2) or
225: nvl(hr_oru_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute19, hr_api.g_varchar2) or
227: nvl(hr_oru_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute20, hr_api.g_varchar2) or
229: -- Enhancement 4040086

Line 227: nvl(hr_oru_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

223: nvl(hr_oru_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute18, hr_api.g_varchar2) or
225: nvl(hr_oru_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute19, hr_api.g_varchar2) or
227: nvl(hr_oru_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute20, hr_api.g_varchar2) or
229: -- Enhancement 4040086
230: nvl(hr_oru_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute21, hr_api.g_varchar2) or

Line 230: nvl(hr_oru_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

226: nvl(p_rec.attribute19, hr_api.g_varchar2) or
227: nvl(hr_oru_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute20, hr_api.g_varchar2) or
229: -- Enhancement 4040086
230: nvl(hr_oru_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute21, hr_api.g_varchar2) or
232: nvl(hr_oru_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute22, hr_api.g_varchar2) or
234: nvl(hr_oru_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 232: nvl(hr_oru_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

228: nvl(p_rec.attribute20, hr_api.g_varchar2) or
229: -- Enhancement 4040086
230: nvl(hr_oru_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute21, hr_api.g_varchar2) or
232: nvl(hr_oru_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute22, hr_api.g_varchar2) or
234: nvl(hr_oru_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute23, hr_api.g_varchar2) or
236: nvl(hr_oru_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 234: nvl(hr_oru_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

230: nvl(hr_oru_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute21, hr_api.g_varchar2) or
232: nvl(hr_oru_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute22, hr_api.g_varchar2) or
234: nvl(hr_oru_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute23, hr_api.g_varchar2) or
236: nvl(hr_oru_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute24, hr_api.g_varchar2) or
238: nvl(hr_oru_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 236: nvl(hr_oru_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

232: nvl(hr_oru_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute22, hr_api.g_varchar2) or
234: nvl(hr_oru_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute23, hr_api.g_varchar2) or
236: nvl(hr_oru_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute24, hr_api.g_varchar2) or
238: nvl(hr_oru_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute25, hr_api.g_varchar2) or
240: nvl(hr_oru_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 238: nvl(hr_oru_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

234: nvl(hr_oru_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute23, hr_api.g_varchar2) or
236: nvl(hr_oru_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute24, hr_api.g_varchar2) or
238: nvl(hr_oru_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute25, hr_api.g_varchar2) or
240: nvl(hr_oru_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute26, hr_api.g_varchar2) or
242: nvl(hr_oru_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 240: nvl(hr_oru_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

236: nvl(hr_oru_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute24, hr_api.g_varchar2) or
238: nvl(hr_oru_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute25, hr_api.g_varchar2) or
240: nvl(hr_oru_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute26, hr_api.g_varchar2) or
242: nvl(hr_oru_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute27, hr_api.g_varchar2) or
244: nvl(hr_oru_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 242: nvl(hr_oru_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

238: nvl(hr_oru_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute25, hr_api.g_varchar2) or
240: nvl(hr_oru_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute26, hr_api.g_varchar2) or
242: nvl(hr_oru_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute27, hr_api.g_varchar2) or
244: nvl(hr_oru_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute28, hr_api.g_varchar2) or
246: nvl(hr_oru_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 244: nvl(hr_oru_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

240: nvl(hr_oru_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute26, hr_api.g_varchar2) or
242: nvl(hr_oru_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute27, hr_api.g_varchar2) or
244: nvl(hr_oru_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute28, hr_api.g_varchar2) or
246: nvl(hr_oru_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute29, hr_api.g_varchar2) or
248: nvl(hr_oru_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 246: nvl(hr_oru_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

242: nvl(hr_oru_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute27, hr_api.g_varchar2) or
244: nvl(hr_oru_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute28, hr_api.g_varchar2) or
246: nvl(hr_oru_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute29, hr_api.g_varchar2) or
248: nvl(hr_oru_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
250: -- End Enhancement 4040086

Line 248: nvl(hr_oru_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

244: nvl(hr_oru_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute28, hr_api.g_varchar2) or
246: nvl(hr_oru_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute29, hr_api.g_varchar2) or
248: nvl(hr_oru_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
250: -- End Enhancement 4040086
251: or (p_rec.organization_id is null) then
252: --

Line 361: ,p_rec in hr_oru_shd.g_rec_type

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

Line 373: IF NOT hr_oru_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 hr_oru_shd.api_updating
374: (p_organization_id => p_rec.organization_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 388: nvl(hr_oru_shd.g_old_rec.name, hr_api.g_varchar2) THEN

384: -- not been updated.
385: --
386: /* bug fix for 2999489
387: IF nvl(p_rec.name, hr_api.g_varchar2) <>
388: nvl(hr_oru_shd.g_old_rec.name, hr_api.g_varchar2) THEN
389: l_argument := 'NAME';
390: RAISE l_error;
391: END IF;
392: --

Line 716: NVL(hr_oru_shd.g_old_rec.cost_allocation_keyflex_id, hr_api.g_number) THEN

712: -- operation or the value has actually changed during an UPDATE operation
713: --
714: IF p_organization_id IS NULL OR
715: p_cost_allocation_keyflex_id <>
716: NVL(hr_oru_shd.g_old_rec.cost_allocation_keyflex_id, hr_api.g_number) THEN
717: --
718: OPEN csr_cost_allocation_keyflex_id;
719: FETCH csr_cost_allocation_keyflex_id INTO l_exists;
720: --

Line 967: if (hr_oru_shd.g_old_rec.internal_external_flag is not null

963: hr_utility.set_location('Entering:'|| l_proc, 10);
964: --
965: --
966: -- Bug 4319315
967: if (hr_oru_shd.g_old_rec.internal_external_flag is not null
968: and
969: (nvl(p_internal_external_flag,hr_oru_shd.g_old_rec.internal_external_flag)
970: <>hr_oru_shd.g_old_rec.internal_external_flag)) then
971: fnd_message.set_name('PER','PER_449606_INVALID_UPD_ORG');

Line 969: (nvl(p_internal_external_flag,hr_oru_shd.g_old_rec.internal_external_flag)

965: --
966: -- Bug 4319315
967: if (hr_oru_shd.g_old_rec.internal_external_flag is not null
968: and
969: (nvl(p_internal_external_flag,hr_oru_shd.g_old_rec.internal_external_flag)
970: <>hr_oru_shd.g_old_rec.internal_external_flag)) then
971: fnd_message.set_name('PER','PER_449606_INVALID_UPD_ORG');
972: fnd_message.raise_error;
973:

Line 970: <>hr_oru_shd.g_old_rec.internal_external_flag)) then

966: -- Bug 4319315
967: if (hr_oru_shd.g_old_rec.internal_external_flag is not null
968: and
969: (nvl(p_internal_external_flag,hr_oru_shd.g_old_rec.internal_external_flag)
970: <>hr_oru_shd.g_old_rec.internal_external_flag)) then
971: fnd_message.set_name('PER','PER_449606_INVALID_UPD_ORG');
972: fnd_message.raise_error;
973:
974: end if;

Line 1077: ,p_rec in hr_oru_shd.g_rec_type

1073: -- |---------------------------< insert_validate >----------------------------|
1074: -- ----------------------------------------------------------------------------
1075: Procedure insert_validate
1076: (p_effective_date in date
1077: ,p_rec in hr_oru_shd.g_rec_type
1078: ,p_duplicate_org_warning out nocopy boolean
1079: ) is
1080: --
1081: l_proc varchar2(72) := g_package||'insert_validate';

Line 1165: ,p_rec in hr_oru_shd.g_rec_type

1161: -- |---------------------------< update_validate >----------------------------|
1162: -- ----------------------------------------------------------------------------
1163: Procedure update_validate
1164: (p_effective_date in date
1165: ,p_rec in hr_oru_shd.g_rec_type
1166: ,p_duplicate_org_warning out nocopy boolean
1167: ) is
1168: --
1169: l_proc varchar2(72) := g_package||'update_validate';

Line 1250: (p_rec in hr_oru_shd.g_rec_type

1246: -- ----------------------------------------------------------------------------
1247: -- |---------------------------< delete_validate >----------------------------|
1248: -- ----------------------------------------------------------------------------
1249: Procedure delete_validate
1250: (p_rec in hr_oru_shd.g_rec_type
1251: ) is
1252: --
1253: l_proc varchar2(72) := g_package||'delete_validate';
1254: -- Start of fix for bug 2881808