APPS.OTA_LPM_BUS dependencies on OTA_LPM_SHD

Line 190: (p_rec in ota_lpm_shd.g_rec_type

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

Line 199: nvl(ota_lpm_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_member_id is not null) and (
199: nvl(ota_lpm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
201: nvl(ota_lpm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
202: nvl(p_rec.attribute1, hr_api.g_varchar2) or
203: nvl(ota_lpm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 327: ,p_rec in ota_lpm_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_lpm_shd.g_rec_type
328: ) IS
329: --
330: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
331: --

Line 337: IF NOT ota_lpm_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_lpm_shd.api_updating
338: (p_learning_path_member_id => p_rec.learning_path_member_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 483: l_api_updating := ota_lpm_shd.api_updating

479: ,p_argument => 'p_business_group_id'
480: ,p_argument_value => p_business_group_id
481: );
482: --
483: l_api_updating := ota_lpm_shd.api_updating
484: (p_learning_path_member_id => p_learning_path_member_id
485: ,p_object_version_number => p_object_version_number
486: );
487: --

Line 492: NVL(ota_lpm_shd.g_old_rec.activity_version_id, hr_api.g_number) <>

488: -- If this is a changing update, or a new insert, test
489: --
490: IF p_activity_version_id IS NOT NULL THEN
491: IF (l_api_updating AND
492: NVL(ota_lpm_shd.g_old_rec.activity_version_id, hr_api.g_number) <>
493: NVL(p_activity_version_id, hr_api.g_number) )
494: OR (NOT l_api_updating)
495: THEN
496: -- Check that the definition exists

Line 649: l_api_updating := ota_lpm_shd.api_updating

645: ,p_argument => 'p_learning_path_id'
646: ,p_argument_value => p_learning_path_id
647: );
648:
649: l_api_updating := ota_lpm_shd.api_updating
650: (p_learning_path_member_id => p_learning_path_member_id
651: ,p_object_version_number => p_object_version_number);
652: --
653: -- Check if anything is changing, or this is an insert

Line 656: NVL(ota_lpm_shd.g_old_rec.activity_version_id, hr_api.g_number) <>

652: --
653: -- Check if anything is changing, or this is an insert
654: --
655: IF (l_api_updating AND
656: NVL(ota_lpm_shd.g_old_rec.activity_version_id, hr_api.g_number) <>
657: NVL(p_activity_version_id, hr_api.g_number))
658: OR (NOT l_api_updating) THEN
659: --
660: -- check the combination is unique

Line 738: l_api_updating := ota_lpm_shd.api_updating

734: ,p_argument => 'p_learning_path_id'
735: ,p_argument_value => p_learning_path_id
736: );
737:
738: l_api_updating := ota_lpm_shd.api_updating
739: (p_learning_path_member_id => p_learning_path_member_id
740: ,p_object_version_number => p_object_version_number);
741: --
742: -- Check if anything is changing, or this is an insert

Line 745: NVL(ota_lpm_shd.g_old_rec.course_sequence, hr_api.g_number) <>

741: --
742: -- Check if anything is changing, or this is an insert
743: --
744: IF (l_api_updating AND
745: NVL(ota_lpm_shd.g_old_rec.course_sequence, hr_api.g_number) <>
746: NVL(p_course_sequence, hr_api.g_number))
747: OR (NOT l_api_updating) THEN
748: --
749: -- check the sequence is unique

Line 818: l_api_updating := ota_lpm_shd.api_updating

814:
815:
816: hr_utility.set_location(' Step:'|| l_proc, 40);
817:
818: l_api_updating := ota_lpm_shd.api_updating
819: (p_learning_path_member_id => p_learning_path_member_id
820: ,p_object_version_number => p_object_version_number);
821: --
822: -- Check if anything is changing, or this is an insert

Line 825: NVL(ota_lpm_shd.g_old_rec.duration, hr_api.g_number) <>

821: --
822: -- Check if anything is changing, or this is an insert
823: --
824: IF (l_api_updating AND
825: NVL(ota_lpm_shd.g_old_rec.duration, hr_api.g_number) <>
826: NVL(p_duration, hr_api.g_number)
827: OR NVL(ota_lpm_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
828: NVL(p_duration_units, hr_api.g_varchar2))
829: OR (NOT l_api_updating AND (p_duration IS NOT NULL OR p_duration_units IS NOT NULL)) THEN

Line 827: OR NVL(ota_lpm_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>

823: --
824: IF (l_api_updating AND
825: NVL(ota_lpm_shd.g_old_rec.duration, hr_api.g_number) <>
826: NVL(p_duration, hr_api.g_number)
827: OR NVL(ota_lpm_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
828: NVL(p_duration_units, hr_api.g_varchar2))
829: OR (NOT l_api_updating AND (p_duration IS NOT NULL OR p_duration_units IS NOT NULL)) THEN
830: --
831: -- check the duration is positive

Line 888: l_api_updating := ota_lpm_shd.api_updating

884: (p_api_name => l_proc
885: ,p_argument => 'effective_date'
886: ,p_argument_value => p_effective_date);
887:
888: l_api_updating := ota_lpm_shd.api_updating
889: (p_learning_path_member_id => p_learning_path_member_id
890: ,p_object_version_number => p_object_version_number);
891:
892:

Line 894: NVL(ota_lpm_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>

890: ,p_object_version_number => p_object_version_number);
891:
892:
893: IF ((l_api_updating AND
894: NVL(ota_lpm_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
895: NVL(p_duration_units, hr_api.g_varchar2))
896: OR NOT l_api_updating AND p_duration_units IS NOT NULL) THEN
897:
898: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 938: ,p_rec in ota_lpm_shd.g_rec_type

934: -- |---------------------------< insert_validate >----------------------------|
935: -- ----------------------------------------------------------------------------
936: Procedure insert_validate
937: (p_effective_date in date
938: ,p_rec in ota_lpm_shd.g_rec_type
939: ) is
940: --
941: l_proc varchar2(72) := g_package||'insert_validate';
942: --

Line 950: ,p_associated_column1 => ota_lpm_shd.g_tab_nam

946: -- Call all supporting business operations
947: --
948: hr_api.validate_bus_grp_id
949: (p_business_group_id => p_rec.business_group_id
950: ,p_associated_column1 => ota_lpm_shd.g_tab_nam
951: || '.BUSINESS_GROUP_ID');
952: --
953: -- After validating the set of important attributes,
954: -- if Multiple Message detection is enabled and at least

Line 1016: ,p_rec in ota_lpm_shd.g_rec_type

1012: -- |---------------------------< update_validate >----------------------------|
1013: -- ----------------------------------------------------------------------------
1014: Procedure update_validate
1015: (p_effective_date in date
1016: ,p_rec in ota_lpm_shd.g_rec_type
1017: ) is
1018: --
1019: l_proc varchar2(72) := g_package||'update_validate';
1020: --

Line 1028: ,p_associated_column1 => ota_lpm_shd.g_tab_nam

1024: -- Call all supporting business operations
1025: --
1026: hr_api.validate_bus_grp_id
1027: (p_business_group_id => p_rec.business_group_id
1028: ,p_associated_column1 => ota_lpm_shd.g_tab_nam
1029: || '.BUSINESS_GROUP_ID');
1030: --
1031: -- After validating the set of important attributes,
1032: -- if Multiple Message detection is enabled and at least

Line 1076: (p_rec in ota_lpm_shd.g_rec_type

1072: -- ----------------------------------------------------------------------------
1073: -- |---------------------------< delete_validate >----------------------------|
1074: -- ----------------------------------------------------------------------------
1075: Procedure delete_validate
1076: (p_rec in ota_lpm_shd.g_rec_type
1077: ) is
1078: --
1079: l_proc varchar2(72) := g_package||'delete_validate';
1080: --