APPS.OTA_TPS_BUS dependencies on OTA_TPS_SHD

Line 185: (p_rec IN ota_tps_shd.g_rec_type

181: -- Internal Row Handler Use Only.
182: --
183: -- ----------------------------------------------------------------------------
184: PROCEDURE chk_df
185: (p_rec IN ota_tps_shd.g_rec_type
186: ) IS
187: --
188: l_proc varchar2(72) := g_package || 'chk_df';
189: --

Line 194: NVL(ota_tps_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.training_plan_id IS NOT NULL) AND (
194: NVL(ota_tps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
195: NVL(p_rec.attribute_category, hr_api.g_varchar2) OR
196: NVL(ota_tps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
197: NVL(p_rec.attribute1, hr_api.g_varchar2) OR
198: NVL(ota_tps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 196: NVL(ota_tps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

192: --
193: IF ((p_rec.training_plan_id IS NOT NULL) AND (
194: NVL(ota_tps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
195: NVL(p_rec.attribute_category, hr_api.g_varchar2) OR
196: NVL(ota_tps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
197: NVL(p_rec.attribute1, hr_api.g_varchar2) OR
198: NVL(ota_tps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
199: NVL(p_rec.attribute2, hr_api.g_varchar2) OR
200: NVL(ota_tps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 198: NVL(ota_tps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

Line 200: NVL(ota_tps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

Line 202: NVL(ota_tps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

Line 204: NVL(ota_tps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

Line 206: NVL(ota_tps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

Line 208: NVL(ota_tps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

Line 210: NVL(ota_tps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

Line 212: NVL(ota_tps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

Line 214: NVL(ota_tps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

Line 216: NVL(ota_tps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

Line 218: NVL(ota_tps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

Line 220: NVL(ota_tps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

Line 222: NVL(ota_tps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

Line 224: NVL(ota_tps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

Line 226: NVL(ota_tps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

Line 228: NVL(ota_tps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

Line 230: NVL(ota_tps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

Line 232: NVL(ota_tps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

Line 234: NVL(ota_tps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

Line 236: NVL(ota_tps_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

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

Line 238: NVL(ota_tps_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

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

Line 240: NVL(ota_tps_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

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

Line 242: NVL(ota_tps_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

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

Line 244: NVL(ota_tps_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

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

Line 246: NVL(ota_tps_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

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

Line 248: NVL(ota_tps_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

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

Line 250: NVL(ota_tps_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

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

Line 252: NVL(ota_tps_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

248: NVL(ota_tps_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
249: NVL(p_rec.attribute27, hr_api.g_varchar2) OR
250: NVL(ota_tps_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: NVL(p_rec.attribute28, hr_api.g_varchar2) OR
252: NVL(ota_tps_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
253: NVL(p_rec.attribute29, hr_api.g_varchar2) OR
254: NVL(ota_tps_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
255: NVL(p_rec.attribute30, hr_api.g_varchar2) ) )
256: OR (p_rec.training_plan_id IS NULL) THEN

Line 254: NVL(ota_tps_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

250: NVL(ota_tps_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
251: NVL(p_rec.attribute28, hr_api.g_varchar2) OR
252: NVL(ota_tps_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
253: NVL(p_rec.attribute29, hr_api.g_varchar2) OR
254: NVL(ota_tps_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
255: NVL(p_rec.attribute30, hr_api.g_varchar2) ) )
256: OR (p_rec.training_plan_id IS NULL) THEN
257: --
258: -- Only execute the validation if absolutely necessary:

Line 362: ,p_rec IN ota_tps_shd.g_rec_type

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

Line 374: IF NOT ota_tps_shd.api_updating

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

Line 387: NVL(ota_tps_shd.g_old_rec.business_group_id, hr_api.g_number) THEN

383: --
384: --
385: hr_utility.set_location(' Step:'|| l_proc, 10);
386: IF NVL(p_rec.business_group_id, hr_api.g_number) <>
387: NVL(ota_tps_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
388: hr_api.argument_changed_error
389: (p_api_name => l_proc
390: ,p_argument => 'BUSINESS_GROUP_ID'
391: ,p_base_table => ota_tps_shd.g_tab_nam);

Line 391: ,p_base_table => ota_tps_shd.g_tab_nam);

387: NVL(ota_tps_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
388: hr_api.argument_changed_error
389: (p_api_name => l_proc
390: ,p_argument => 'BUSINESS_GROUP_ID'
391: ,p_base_table => ota_tps_shd.g_tab_nam);
392: END IF;
393: --
394: hr_utility.set_location(' Step:'|| l_proc, 20);
395: IF NVL(p_rec.training_plan_id, hr_api.g_number) <>

Line 396: NVL(ota_tps_shd.g_old_rec.training_plan_id, hr_api.g_number) THEN

392: END IF;
393: --
394: hr_utility.set_location(' Step:'|| l_proc, 20);
395: IF NVL(p_rec.training_plan_id, hr_api.g_number) <>
396: NVL(ota_tps_shd.g_old_rec.training_plan_id, hr_api.g_number) THEN
397: hr_api.argument_changed_error
398: (p_api_name => l_proc
399: ,p_argument => 'TRAINING_PLAN_ID'
400: ,p_base_table => ota_tps_shd.g_tab_nam);

Line 400: ,p_base_table => ota_tps_shd.g_tab_nam);

396: NVL(ota_tps_shd.g_old_rec.training_plan_id, hr_api.g_number) THEN
397: hr_api.argument_changed_error
398: (p_api_name => l_proc
399: ,p_argument => 'TRAINING_PLAN_ID'
400: ,p_base_table => ota_tps_shd.g_tab_nam);
401: END IF;
402: --
403: hr_utility.set_location(' Step:'|| l_proc, 30);
404: IF NVL(p_rec.organization_id, hr_api.g_number) <>

Line 405: NVL(ota_tps_shd.g_old_rec.organization_id, hr_api.g_number) THEN

401: END IF;
402: --
403: hr_utility.set_location(' Step:'|| l_proc, 30);
404: IF NVL(p_rec.organization_id, hr_api.g_number) <>
405: NVL(ota_tps_shd.g_old_rec.organization_id, hr_api.g_number) THEN
406: hr_api.argument_changed_error
407: (p_api_name => l_proc
408: ,p_argument => 'ORGANIZATION_ID'
409: ,p_base_table => ota_tps_shd.g_tab_nam);

Line 409: ,p_base_table => ota_tps_shd.g_tab_nam);

405: NVL(ota_tps_shd.g_old_rec.organization_id, hr_api.g_number) THEN
406: hr_api.argument_changed_error
407: (p_api_name => l_proc
408: ,p_argument => 'ORGANIZATION_ID'
409: ,p_base_table => ota_tps_shd.g_tab_nam);
410: END IF;
411: --
412: hr_utility.set_location(' Step:'|| l_proc, 40);
413: IF NVL(p_rec.person_id, hr_api.g_number) <>

Line 414: NVL(ota_tps_shd.g_old_rec.person_id, hr_api.g_number) THEN

410: END IF;
411: --
412: hr_utility.set_location(' Step:'|| l_proc, 40);
413: IF NVL(p_rec.person_id, hr_api.g_number) <>
414: NVL(ota_tps_shd.g_old_rec.person_id, hr_api.g_number) THEN
415: hr_api.argument_changed_error
416: (p_api_name => l_proc
417: ,p_argument => 'PERSON_ID'
418: ,p_base_table => ota_tps_shd.g_tab_nam);

Line 418: ,p_base_table => ota_tps_shd.g_tab_nam);

414: NVL(ota_tps_shd.g_old_rec.person_id, hr_api.g_number) THEN
415: hr_api.argument_changed_error
416: (p_api_name => l_proc
417: ,p_argument => 'PERSON_ID'
418: ,p_base_table => ota_tps_shd.g_tab_nam);
419: END IF;
420: --
421: EXCEPTION
422:

Line 432: ,p_rec IN ota_tps_shd.g_rec_type

428: -- |---------------------------< insert_validate >----------------------------|
429: -- ----------------------------------------------------------------------------
430: PROCEDURE insert_validate
431: (p_effective_date IN date
432: ,p_rec IN ota_tps_shd.g_rec_type
433: ) IS
434: --
435: l_proc varchar2(72) := g_package||'insert_validate';
436: --

Line 444: ,p_associated_column1 => ota_tps_shd.g_tab_nam || '.BUSINESS_GROUP_ID'); -- Validate Bus Grp

440: -- Call all supporting business operations
441: --Validate Important Attributes
442: --
443: hr_api.validate_bus_grp_id(p_rec.business_group_id
444: ,p_associated_column1 => ota_tps_shd.g_tab_nam || '.BUSINESS_GROUP_ID'); -- Validate Bus Grp
445: --
446: hr_multi_message.end_validation_set;
447:
448: --

Line 547: ,p_rec IN ota_tps_shd.g_rec_type

543: -- |---------------------------< update_validate >----------------------------|
544: -- ----------------------------------------------------------------------------
545: PROCEDURE update_validate
546: (p_effective_date IN date
547: ,p_rec IN ota_tps_shd.g_rec_type
548: ) IS
549: --
550: l_proc varchar2(72) := g_package||'update_validate';
551: l_boolean boolean := null;

Line 560: ,p_associated_column1 => ota_tps_shd.g_tab_nam || '.BUSINESS_GROUP_ID'); -- Validate Bus Grp

556: -- Call all supporting business operations
557: --Validate Important attribute
558:
559: hr_api.validate_bus_grp_id(p_rec.business_group_id
560: ,p_associated_column1 => ota_tps_shd.g_tab_nam || '.BUSINESS_GROUP_ID'); -- Validate Bus Grp
561: --
562: hr_multi_message.end_validation_set;
563:
564: chk_non_updateable_args

Line 649: (p_rec IN ota_tps_shd.g_rec_type

645: -- ----------------------------------------------------------------------------
646: -- |---------------------------< delete_validate >----------------------------|
647: -- ----------------------------------------------------------------------------
648: PROCEDURE delete_validate
649: (p_rec IN ota_tps_shd.g_rec_type
650: ) IS
651: --
652: l_proc varchar2(72) := g_package||'delete_validate';
653: --

Line 661: p_training_plan_id => ota_tps_shd.g_old_rec.training_plan_id);

657: -- Call all supporting business operations
658: --
659: hr_utility.set_location(' Step:'|| l_proc, 10);
660: ota_tps_bus1.chk_del_training_plan_id(
661: p_training_plan_id => ota_tps_shd.g_old_rec.training_plan_id);
662: --
663: hr_utility.set_location(' Leaving:'||l_proc, 20);
664: END delete_validate;
665: --