DBA Data[Home] [Help]

APPS.OTA_TPM_BUS dependencies on OTA_TPM_SHD

Line 185: (p_rec IN ota_tpm_shd.g_rec_type

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 362: ,p_rec IN ota_tpm_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_tpm_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_tpm_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_tpm_shd.api_updating
375: (p_training_plan_member_id => p_rec.training_plan_member_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 386: NVL(ota_tpm_shd.g_old_rec.business_group_id, hr_api.g_number) THEN

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

Line 390: ,p_base_table => ota_tpm_shd.g_tab_nam);

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

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

392: --
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_tpm_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_tpm_shd.g_tab_nam);

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

396: NVL(ota_tpm_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_tpm_shd.g_tab_nam);
401: END IF;
402: --
403:
404: END chk_non_updateable_args;

Line 411: ,p_rec IN ota_tpm_shd.g_rec_type

407: -- |---------------------------< insert_validate >----------------------------|
408: -- ----------------------------------------------------------------------------
409: PROCEDURE insert_validate
410: (p_effective_date IN date
411: ,p_rec IN ota_tpm_shd.g_rec_type
412: ) IS
413: --
414: l_proc varchar2(72) := g_package||'insert_validate';
415: l_person_id number;

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

420: --
421: -- VALIDATE IMPORTANT ATTRIBUTES
422: --
423: hr_api.validate_bus_grp_id(p_rec.business_group_id
424: ,p_associated_column1 => ota_tpm_shd.g_tab_nam ||'.BUSINESS_GROUP_ID'); -- Validate Bus Grp
425: --
426: hr_multi_message.end_validation_set;
427: --
428: --

Line 537: ,p_rec IN ota_tpm_shd.g_rec_type

533: -- |---------------------------< update_validate >----------------------------|
534: -- ----------------------------------------------------------------------------
535: PROCEDURE update_validate
536: (p_effective_date IN date
537: ,p_rec IN ota_tpm_shd.g_rec_type
538: ) IS
539: --
540: l_proc varchar2(72) := g_package||'update_validate';
541: l_person_id number;

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

547: --
548: -- VALIDATE IMPORTANT ATTRIBUTES
549: --
550: hr_api.validate_bus_grp_id(p_rec.business_group_id
551: ,p_associated_column1 => ota_tpm_shd.g_tab_nam ||'.BUSINESS_GROUP_ID'); -- Validate Bus Grp
552: --
553: hr_multi_message.end_validation_set;
554:
555: chk_non_updateable_args

Line 663: (p_rec IN ota_tpm_shd.g_rec_type

659: -- ----------------------------------------------------------------------------
660: -- |---------------------------< delete_validate >----------------------------|
661: -- ----------------------------------------------------------------------------
662: PROCEDURE delete_validate
663: (p_rec IN ota_tpm_shd.g_rec_type
664: ) IS
665: --
666: l_proc varchar2(72) := g_package||'delete_validate';
667: --

Line 673: hr_utility.set_location(' tpm is ', ota_tpm_shd.g_old_rec.training_plan_member_id);

669: hr_utility.set_location('Entering:'||l_proc, 5);
670: --
671: -- Call all supporting business operations
672: --
673: hr_utility.set_location(' tpm is ', ota_tpm_shd.g_old_rec.training_plan_member_id);
674: hr_utility.set_location(' tpm is ', ota_tpm_shd.g_old_rec.training_plan_id);
675: ota_tpm_bus1.chk_delete(
676: p_training_plan_member_id => ota_tpm_shd.g_old_rec.training_plan_member_id
677: ,p_training_plan_id => ota_tpm_shd.g_old_rec.training_plan_id );

Line 674: hr_utility.set_location(' tpm is ', ota_tpm_shd.g_old_rec.training_plan_id);

670: --
671: -- Call all supporting business operations
672: --
673: hr_utility.set_location(' tpm is ', ota_tpm_shd.g_old_rec.training_plan_member_id);
674: hr_utility.set_location(' tpm is ', ota_tpm_shd.g_old_rec.training_plan_id);
675: ota_tpm_bus1.chk_delete(
676: p_training_plan_member_id => ota_tpm_shd.g_old_rec.training_plan_member_id
677: ,p_training_plan_id => ota_tpm_shd.g_old_rec.training_plan_id );
678: --

Line 676: p_training_plan_member_id => ota_tpm_shd.g_old_rec.training_plan_member_id

672: --
673: hr_utility.set_location(' tpm is ', ota_tpm_shd.g_old_rec.training_plan_member_id);
674: hr_utility.set_location(' tpm is ', ota_tpm_shd.g_old_rec.training_plan_id);
675: ota_tpm_bus1.chk_delete(
676: p_training_plan_member_id => ota_tpm_shd.g_old_rec.training_plan_member_id
677: ,p_training_plan_id => ota_tpm_shd.g_old_rec.training_plan_id );
678: --
679: hr_utility.set_location(' Leaving:'||l_proc, 10);
680: END delete_validate;

Line 677: ,p_training_plan_id => ota_tpm_shd.g_old_rec.training_plan_id );

673: hr_utility.set_location(' tpm is ', ota_tpm_shd.g_old_rec.training_plan_member_id);
674: hr_utility.set_location(' tpm is ', ota_tpm_shd.g_old_rec.training_plan_id);
675: ota_tpm_bus1.chk_delete(
676: p_training_plan_member_id => ota_tpm_shd.g_old_rec.training_plan_member_id
677: ,p_training_plan_id => ota_tpm_shd.g_old_rec.training_plan_id );
678: --
679: hr_utility.set_location(' Leaving:'||l_proc, 10);
680: END delete_validate;
681: --