186: -- Internal Row Handler Use Only.
187: --
188: -- ----------------------------------------------------------------------------
189: procedure chk_df
190: (p_rec in ota_lpc_shd.g_rec_type
191: ) is
192: --
193: l_proc varchar2(72) := g_package || 'chk_df';
194: --
195: begin
196: hr_utility.set_location('Entering:'||l_proc,10);
197: --
198: if ((p_rec.learning_path_section_id is not null) and (
199: nvl(ota_lpc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lpc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lpc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
197: --
198: if ((p_rec.learning_path_section_id is not null) and (
199: nvl(ota_lpc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lpc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lpc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lpc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
199: nvl(ota_lpc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lpc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lpc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lpc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lpc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
201: nvl(ota_lpc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lpc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lpc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lpc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lpc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
203: nvl(ota_lpc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
204: nvl(p_rec.attribute2, hr_api.g_varchar2) or
205: nvl(ota_lpc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lpc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lpc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lpc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
205: nvl(ota_lpc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
206: nvl(p_rec.attribute3, hr_api.g_varchar2) or
207: nvl(ota_lpc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lpc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lpc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lpc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
207: nvl(ota_lpc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
208: nvl(p_rec.attribute4, hr_api.g_varchar2) or
209: nvl(ota_lpc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lpc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lpc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lpc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
209: nvl(ota_lpc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
210: nvl(p_rec.attribute5, hr_api.g_varchar2) or
211: nvl(ota_lpc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lpc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lpc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lpc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
211: nvl(ota_lpc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
212: nvl(p_rec.attribute6, hr_api.g_varchar2) or
213: nvl(ota_lpc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lpc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lpc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lpc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
213: nvl(ota_lpc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
214: nvl(p_rec.attribute7, hr_api.g_varchar2) or
215: nvl(ota_lpc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lpc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lpc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lpc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
215: nvl(ota_lpc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
216: nvl(p_rec.attribute8, hr_api.g_varchar2) or
217: nvl(ota_lpc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lpc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lpc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lpc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
217: nvl(ota_lpc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
218: nvl(p_rec.attribute9, hr_api.g_varchar2) or
219: nvl(ota_lpc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lpc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lpc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lpc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
219: nvl(ota_lpc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
220: nvl(p_rec.attribute10, hr_api.g_varchar2) or
221: nvl(ota_lpc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lpc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lpc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lpc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
221: nvl(ota_lpc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
222: nvl(p_rec.attribute11, hr_api.g_varchar2) or
223: nvl(ota_lpc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lpc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lpc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lpc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
223: nvl(ota_lpc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
224: nvl(p_rec.attribute12, hr_api.g_varchar2) or
225: nvl(ota_lpc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lpc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lpc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lpc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
225: nvl(ota_lpc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute13, hr_api.g_varchar2) or
227: nvl(ota_lpc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lpc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lpc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lpc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
227: nvl(ota_lpc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute14, hr_api.g_varchar2) or
229: nvl(ota_lpc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lpc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lpc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lpc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
229: nvl(ota_lpc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute15, hr_api.g_varchar2) or
231: nvl(ota_lpc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lpc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lpc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lpc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
231: nvl(ota_lpc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute16, hr_api.g_varchar2) or
233: nvl(ota_lpc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lpc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lpc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lpc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
233: nvl(ota_lpc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute17, hr_api.g_varchar2) or
235: nvl(ota_lpc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lpc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lpc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
241: or (p_rec.learning_path_section_id is null) then
235: nvl(ota_lpc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute18, hr_api.g_varchar2) or
237: nvl(ota_lpc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute19, hr_api.g_varchar2) or
239: nvl(ota_lpc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
241: or (p_rec.learning_path_section_id is null) then
242: --
243: -- Only execute the validation if absolutely necessary:
323: -- {End Of Comments}
324: -- ----------------------------------------------------------------------------
325: Procedure chk_non_updateable_args
326: (p_effective_date in date
327: ,p_rec in ota_lpc_shd.g_rec_type
328: ) IS
329: --
330: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
331: --
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_lpc_shd.api_updating
338: (p_learning_path_section_id => p_rec.learning_path_section_id
339: ,p_object_version_number => p_rec.object_version_number
340: ) THEN
341: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
712: -- |---------------------------< insert_validate >----------------------------|
713: -- ----------------------------------------------------------------------------
714: Procedure insert_validate
715: (p_effective_date in date
716: ,p_rec in ota_lpc_shd.g_rec_type
717: ) is
718: --
719: l_proc varchar2(72) := g_package||'insert_validate';
720: --
724: -- Call all supporting business operations
725: --
726: hr_api.validate_bus_grp_id
727: (p_business_group_id => p_rec.business_group_id
728: ,p_associated_column1 => ota_lpc_shd.g_tab_nam
729: || '.BUSINESS_GROUP_ID');
730: --
731: -- After validating the set of important attributes,
732: -- if Multiple Message detection is enabled and at least
756: -- |---------------------------< update_validate >----------------------------|
757: -- ----------------------------------------------------------------------------
758: Procedure update_validate
759: (p_effective_date in date
760: ,p_rec in ota_lpc_shd.g_rec_type
761: ) is
762: --
763: l_proc varchar2(72) := g_package||'update_validate';
764: --
762: --
763: l_proc varchar2(72) := g_package||'update_validate';
764: --
765: l_completion_type_changed BOOLEAN
766: := ota_general.value_changed(ota_lpc_shd.g_old_rec.completion_type_code,
767: p_rec.completion_type_code);
768:
769: l_no_of_courses_changed BOOLEAN
770: := ota_general.value_changed(ota_lpc_shd.g_old_rec.no_of_mandatory_courses,
766: := ota_general.value_changed(ota_lpc_shd.g_old_rec.completion_type_code,
767: p_rec.completion_type_code);
768:
769: l_no_of_courses_changed BOOLEAN
770: := ota_general.value_changed(ota_lpc_shd.g_old_rec.no_of_mandatory_courses,
771: p_rec.no_of_mandatory_courses);
772:
773: Begin
774: hr_utility.set_location('Entering:'||l_proc, 5);
776: -- Call all supporting business operations
777: --
778: hr_api.validate_bus_grp_id
779: (p_business_group_id => p_rec.business_group_id
780: ,p_associated_column1 => ota_lpc_shd.g_tab_nam
781: || '.BUSINESS_GROUP_ID');
782: --
783: -- After validating the set of important attributes,
784: -- if Multiple Message detection is enabled and at least
826: -- ----------------------------------------------------------------------------
827: -- |---------------------------< delete_validate >----------------------------|
828: -- ----------------------------------------------------------------------------
829: Procedure delete_validate
830: (p_rec in ota_lpc_shd.g_rec_type
831: ) is
832: --
833: l_proc varchar2(72) := g_package||'delete_validate';
834: --