APPS.OTA_LPS_BUS dependencies on OTA_LPS_SHD

Line 190: (p_rec in ota_lps_shd.g_rec_type

186: -- Internal Row Handler Use Only.
187: --
188: -- ----------------------------------------------------------------------------
189: procedure chk_df
190: (p_rec in ota_lps_shd.g_rec_type
191: ) is
192: --
193: l_proc varchar2(72) := g_package || 'chk_df';
194: --

Line 199: nvl(ota_lps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

195: begin
196: hr_utility.set_location('Entering:'||l_proc,10);
197: --
198: if ((p_rec.learning_path_id is not null) and (
199: nvl(ota_lps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 201: nvl(ota_lps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

197: --
198: if ((p_rec.learning_path_id is not null) and (
199: nvl(ota_lps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

199: nvl(ota_lps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

201: nvl(ota_lps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

203: nvl(ota_lps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

205: nvl(ota_lps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

207: nvl(ota_lps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

209: nvl(ota_lps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

211: nvl(ota_lps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

213: nvl(ota_lps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

215: nvl(ota_lps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

217: nvl(ota_lps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

219: nvl(ota_lps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

221: nvl(ota_lps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

223: nvl(ota_lps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

225: nvl(ota_lps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

227: nvl(ota_lps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

229: nvl(ota_lps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

231: nvl(ota_lps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 237: nvl(ota_lps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

233: nvl(ota_lps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
241: or (p_rec.learning_path_id is null) then

Line 239: nvl(ota_lps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

235: nvl(ota_lps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
241: or (p_rec.learning_path_id is null) then
242: --
243: -- Only execute the validation if absolutely necessary:

Line 327: ,p_rec in ota_lps_shd.g_rec_type

323: -- {End Of Comments}
324: -- ----------------------------------------------------------------------------
325: Procedure chk_non_updateable_args
326: (p_effective_date in date
327: ,p_rec in ota_lps_shd.g_rec_type
328: ) IS
329: --
330: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
331: --

Line 337: IF NOT ota_lps_shd.api_updating

333: --
334: -- Only proceed with the validation if a row exists for the current
335: -- record in the HR Schema.
336: --
337: IF NOT ota_lps_shd.api_updating
338: (p_learning_path_id => p_rec.learning_path_id
339: ,p_object_version_number => p_rec.object_version_number
340: ) THEN
341: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 349: NVL(ota_lps_shd.g_old_rec.business_group_id, hr_api.g_number) THEN

345: END IF;
346: --
347: hr_utility.set_location(' Step:'|| l_proc, 10);
348: IF NVL(p_rec.business_group_id, hr_api.g_number) <>
349: NVL(ota_lps_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
350: hr_api.argument_changed_error
351: (p_api_name => l_proc
352: ,p_argument => 'BUSINESS_GROUP_ID'
353: ,p_base_table => ota_lps_shd.g_tab_nam);

Line 353: ,p_base_table => ota_lps_shd.g_tab_nam);

349: NVL(ota_lps_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
350: hr_api.argument_changed_error
351: (p_api_name => l_proc
352: ,p_argument => 'BUSINESS_GROUP_ID'
353: ,p_base_table => ota_lps_shd.g_tab_nam);
354: END IF;
355: --
356: hr_utility.set_location(' Step:'|| l_proc, 20);
357: IF NVL(p_rec.learning_path_id, hr_api.g_number) <>

Line 358: NVL(ota_lps_shd.g_old_rec.learning_path_id, hr_api.g_number) THEN

354: END IF;
355: --
356: hr_utility.set_location(' Step:'|| l_proc, 20);
357: IF NVL(p_rec.learning_path_id, hr_api.g_number) <>
358: NVL(ota_lps_shd.g_old_rec.learning_path_id, hr_api.g_number) THEN
359: hr_api.argument_changed_error
360: (p_api_name => l_proc
361: ,p_argument => 'LEARNING_PATH_ID'
362: ,p_base_table => ota_lps_shd.g_tab_nam);

Line 362: ,p_base_table => ota_lps_shd.g_tab_nam);

358: NVL(ota_lps_shd.g_old_rec.learning_path_id, hr_api.g_number) THEN
359: hr_api.argument_changed_error
360: (p_api_name => l_proc
361: ,p_argument => 'LEARNING_PATH_ID'
362: ,p_base_table => ota_lps_shd.g_tab_nam);
363: END IF;
364: --
365: EXCEPTION
366:

Line 401: l_api_updating := ota_lps_shd.api_updating

397:
398:
399: hr_utility.set_location(' Step:'|| l_proc, 40);
400:
401: l_api_updating := ota_lps_shd.api_updating
402: (p_learning_path_id => p_learning_path_id
403: ,p_object_version_number => p_object_version_number);
404: --
405: -- Check if anything is changing, or this is an insert

Line 408: NVL(ota_lps_shd.g_old_rec.duration, hr_api.g_number) <>

404: --
405: -- Check if anything is changing, or this is an insert
406: --
407: IF (l_api_updating AND
408: NVL(ota_lps_shd.g_old_rec.duration, hr_api.g_number) <>
409: NVL(p_duration, hr_api.g_number)
410: OR NVL(ota_lps_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
411: NVL(p_duration_units, hr_api.g_varchar2))
412: OR (NOT l_api_updating AND (p_duration IS NOT NULL OR p_duration_units IS NOT NULL)) THEN

Line 410: OR NVL(ota_lps_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>

406: --
407: IF (l_api_updating AND
408: NVL(ota_lps_shd.g_old_rec.duration, hr_api.g_number) <>
409: NVL(p_duration, hr_api.g_number)
410: OR NVL(ota_lps_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
411: NVL(p_duration_units, hr_api.g_varchar2))
412: OR (NOT l_api_updating AND (p_duration IS NOT NULL OR p_duration_units IS NOT NULL)) THEN
413: --
414: -- check the duration is positive

Line 471: l_api_updating := ota_lps_shd.api_updating

467: (p_api_name => l_proc
468: ,p_argument => 'effective_date'
469: ,p_argument_value => p_effective_date);
470:
471: l_api_updating := ota_lps_shd.api_updating
472: (p_learning_path_id => p_learning_path_id
473: ,p_object_version_number => p_object_version_number);
474:
475:

Line 477: NVL(ota_lps_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>

473: ,p_object_version_number => p_object_version_number);
474:
475:
476: IF ((l_api_updating AND
477: NVL(ota_lps_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
478: NVL(p_duration_units, hr_api.g_varchar2))
479: OR NOT l_api_updating AND p_duration_units IS NOT NULL) THEN
480:
481: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 585: l_api_updating := ota_lps_shd.api_updating

581: (p_api_name => l_proc
582: ,p_argument => 'effective_date'
583: ,p_argument_value => p_effective_date);
584:
585: l_api_updating := ota_lps_shd.api_updating
586: (p_learning_path_id => p_learning_path_id
587: ,p_object_version_number => p_object_version_number);
588:
589: IF ((l_api_updating AND

Line 590: NVL(ota_lps_shd.g_old_rec.path_source_code,hr_api.g_varchar2) <>

586: (p_learning_path_id => p_learning_path_id
587: ,p_object_version_number => p_object_version_number);
588:
589: IF ((l_api_updating AND
590: NVL(ota_lps_shd.g_old_rec.path_source_code,hr_api.g_varchar2) <>
591: NVL(p_path_source_code, hr_api.g_varchar2))
592: OR NOT l_api_updating AND p_path_source_code IS NOT NULL) THEN
593:
594: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 650: l_api_updating := ota_lps_shd.api_updating

646: (p_api_name => l_proc
647: ,p_argument => 'effective_date'
648: ,p_argument_value => p_effective_date);
649:
650: l_api_updating := ota_lps_shd.api_updating
651: (p_learning_path_id => p_learning_path_id
652: ,p_object_version_number => p_object_version_number);
653:
654:

Line 656: NVL(ota_lps_shd.g_old_rec.source_function_code,hr_api.g_varchar2) <>

652: ,p_object_version_number => p_object_version_number);
653:
654:
655: IF ((l_api_updating AND
656: NVL(ota_lps_shd.g_old_rec.source_function_code,hr_api.g_varchar2) <>
657: NVL(p_source_function_code, hr_api.g_varchar2))
658: OR NOT l_api_updating AND p_source_function_code IS NOT NULL) THEN
659:
660: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 715: l_api_updating := ota_lps_shd.api_updating

711: (p_api_name => l_proc
712: ,p_argument => 'effective_date'
713: ,p_argument_value => p_effective_date);
714:
715: l_api_updating := ota_lps_shd.api_updating
716: (p_learning_path_id => p_learning_path_id
717: ,p_object_version_number => p_object_version_number);
718:
719:

Line 721: NVL(ota_lps_shd.g_old_rec.competency_update_level,hr_api.g_varchar2) <>

717: ,p_object_version_number => p_object_version_number);
718:
719:
720: IF ((l_api_updating AND
721: NVL(ota_lps_shd.g_old_rec.competency_update_level,hr_api.g_varchar2) <>
722: NVL(p_competency_update_level, hr_api.g_varchar2))
723: OR NOT l_api_updating AND p_competency_update_level IS NOT NULL) THEN
724:
725: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 842: IF (NVL(ota_lps_shd.g_old_rec.start_date_active, hr_api.g_date) <>

838: ,p_check_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
839: ,p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
840: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE' ) THEN
841:
842: IF (NVL(ota_lps_shd.g_old_rec.start_date_active, hr_api.g_date) <>
843: NVL( p_start_date, hr_api.g_date )) THEN
844: l_upd_start_date := TRUE;
845: l_start_date_active := p_start_date;
846: ELSE

Line 848: l_start_date_active := ota_lps_shd.g_old_rec.start_date_active;

844: l_upd_start_date := TRUE;
845: l_start_date_active := p_start_date;
846: ELSE
847: l_upd_start_date := FALSE;
848: l_start_date_active := ota_lps_shd.g_old_rec.start_date_active;
849: END IF;
850:
851: IF (NVL(ota_lps_shd.g_old_rec.end_date_active, hr_api.g_date) <>
852: NVL( p_end_date, hr_api.g_date )) THEN

Line 851: IF (NVL(ota_lps_shd.g_old_rec.end_date_active, hr_api.g_date) <>

847: l_upd_start_date := FALSE;
848: l_start_date_active := ota_lps_shd.g_old_rec.start_date_active;
849: END IF;
850:
851: IF (NVL(ota_lps_shd.g_old_rec.end_date_active, hr_api.g_date) <>
852: NVL( p_end_date, hr_api.g_date )) THEN
853: l_upd_end_date := TRUE;
854: l_end_date_active := p_end_date;
855: ELSE

Line 857: l_end_date_active := ota_lps_shd.g_old_rec.end_date_active;

853: l_upd_end_date := TRUE;
854: l_end_date_active := p_end_date;
855: ELSE
856: l_upd_end_date := FALSE;
857: l_end_date_active := ota_lps_shd.g_old_rec.end_date_active;
858: END IF;
859:
860: IF (l_upd_start_date OR l_upd_end_date) THEN
861:

Line 954: IF (NVL(ota_lps_shd.g_old_rec.start_date_active, hr_api.g_date) <>

950: --
951: OPEN cur_cat_start_end_date;
952: FETCH cur_cat_start_end_date into l_cat_start_date, l_cat_end_date;
953:
954: IF (NVL(ota_lps_shd.g_old_rec.start_date_active, hr_api.g_date) <>
955: NVL( p_start_date, hr_api.g_date )) THEN
956: l_start_date_active := p_start_date;
957: ELSE
958: l_start_date_active := ota_lps_shd.g_old_rec.start_date_active;

Line 958: l_start_date_active := ota_lps_shd.g_old_rec.start_date_active;

954: IF (NVL(ota_lps_shd.g_old_rec.start_date_active, hr_api.g_date) <>
955: NVL( p_start_date, hr_api.g_date )) THEN
956: l_start_date_active := p_start_date;
957: ELSE
958: l_start_date_active := ota_lps_shd.g_old_rec.start_date_active;
959: END IF;
960:
961: IF (NVL(ota_lps_shd.g_old_rec.end_date_active, hr_api.g_date) <>
962: NVL( p_end_date, hr_api.g_date )) THEN

Line 961: IF (NVL(ota_lps_shd.g_old_rec.end_date_active, hr_api.g_date) <>

957: ELSE
958: l_start_date_active := ota_lps_shd.g_old_rec.start_date_active;
959: END IF;
960:
961: IF (NVL(ota_lps_shd.g_old_rec.end_date_active, hr_api.g_date) <>
962: NVL( p_end_date, hr_api.g_date )) THEN
963: l_end_date_active := p_end_date;
964: ELSE
965: l_end_date_active := ota_lps_shd.g_old_rec.end_date_active;

Line 965: l_end_date_active := ota_lps_shd.g_old_rec.end_date_active;

961: IF (NVL(ota_lps_shd.g_old_rec.end_date_active, hr_api.g_date) <>
962: NVL( p_end_date, hr_api.g_date )) THEN
963: l_end_date_active := p_end_date;
964: ELSE
965: l_end_date_active := ota_lps_shd.g_old_rec.end_date_active;
966: END IF;
967:
968: IF cur_cat_start_end_date%FOUND THEN
969: CLOSE cur_cat_start_end_date;

Line 1082: ,p_rec in ota_lps_shd.g_rec_type

1078: -- |---------------------------< insert_validate >----------------------------|
1079: -- ----------------------------------------------------------------------------
1080: Procedure insert_validate
1081: (p_effective_date in date
1082: ,p_rec in ota_lps_shd.g_rec_type
1083: ) is
1084: --
1085: l_proc varchar2(72) := g_package||'insert_validate';
1086: --

Line 1094: ,p_associated_column1 => ota_lps_shd.g_tab_nam

1090: -- Call all supporting business operations
1091: --
1092: hr_api.validate_bus_grp_id
1093: (p_business_group_id => p_rec.business_group_id
1094: ,p_associated_column1 => ota_lps_shd.g_tab_nam
1095: || '.BUSINESS_GROUP_ID');
1096: --
1097: -- After validating the set of important attributes,
1098: -- if Multiple Message detection is enabled and at least

Line 1165: ,p_rec in ota_lps_shd.g_rec_type

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

Line 1171: := ota_general.value_changed(ota_lps_shd.g_old_rec.duration,

1167: --
1168: l_proc varchar2(72) := g_package||'update_validate';
1169:
1170: l_duration_changed BOOLEAN
1171: := ota_general.value_changed(ota_lps_shd.g_old_rec.duration,
1172: p_rec.duration);
1173: l_duration_units_changed BOOLEAN
1174: := ota_general.value_changed(ota_lps_shd.g_old_rec.duration_units,
1175: p_rec.duration_units);

Line 1174: := ota_general.value_changed(ota_lps_shd.g_old_rec.duration_units,

1170: l_duration_changed BOOLEAN
1171: := ota_general.value_changed(ota_lps_shd.g_old_rec.duration,
1172: p_rec.duration);
1173: l_duration_units_changed BOOLEAN
1174: := ota_general.value_changed(ota_lps_shd.g_old_rec.duration_units,
1175: p_rec.duration_units);
1176:
1177: l_start_date_active_changed BOOLEAN
1178: := ota_general.value_changed(ota_lps_shd.g_old_rec.start_date_active,

Line 1178: := ota_general.value_changed(ota_lps_shd.g_old_rec.start_date_active,

1174: := ota_general.value_changed(ota_lps_shd.g_old_rec.duration_units,
1175: p_rec.duration_units);
1176:
1177: l_start_date_active_changed BOOLEAN
1178: := ota_general.value_changed(ota_lps_shd.g_old_rec.start_date_active,
1179: p_rec.start_date_active);
1180:
1181:
1182: --

Line 1190: ,p_associated_column1 => ota_lps_shd.g_tab_nam

1186: -- Call all supporting business operations
1187: --
1188: hr_api.validate_bus_grp_id
1189: (p_business_group_id => p_rec.business_group_id
1190: ,p_associated_column1 => ota_lps_shd.g_tab_nam
1191: || '.BUSINESS_GROUP_ID');
1192: --
1193: -- After validating the set of important attributes,
1194: -- if Multiple Message detection is enabled and at least

Line 1277: (p_rec in ota_lps_shd.g_rec_type

1273: -- ----------------------------------------------------------------------------
1274: -- |---------------------------< delete_validate >----------------------------|
1275: -- ----------------------------------------------------------------------------
1276: Procedure delete_validate
1277: (p_rec in ota_lps_shd.g_rec_type
1278: ) is
1279: --
1280: l_proc varchar2(72) := g_package||'delete_validate';
1281: --

Line 1286: IF get_path_source_code(ota_lps_shd.g_old_rec.learning_path_id) = 'CATALOG' THEN

1282: Begin
1283: hr_utility.set_location('Entering:'||l_proc, 5);
1284: --
1285: -- Call all supporting business operations
1286: IF get_path_source_code(ota_lps_shd.g_old_rec.learning_path_id) = 'CATALOG' THEN
1287:
1288: IF chk_lp_enrollments_exist(
1289: p_learning_path_id => ota_lps_shd.g_old_rec.learning_path_id) THEN
1290: fnd_message.set_name('OTA','OTA_443383_LP_TP_EXISTS');

Line 1289: p_learning_path_id => ota_lps_shd.g_old_rec.learning_path_id) THEN

1285: -- Call all supporting business operations
1286: IF get_path_source_code(ota_lps_shd.g_old_rec.learning_path_id) = 'CATALOG' THEN
1287:
1288: IF chk_lp_enrollments_exist(
1289: p_learning_path_id => ota_lps_shd.g_old_rec.learning_path_id) THEN
1290: fnd_message.set_name('OTA','OTA_443383_LP_TP_EXISTS');
1291: fnd_message.raise_error;
1292: END IF;
1293: