eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_LME_UPD dependencies on OTA_LME_SHD

Line 55: (p_rec in out nocopy ota_lme_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy ota_lme_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 123: ota_lme_shd.constraint_error

119: Exception
120: When hr_api.check_integrity_violated Then
121: -- A check constraint has been violated
122: --
123: ota_lme_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.parent_integrity_violated Then
126: -- Parent integrity has been violated
127: --

Line 128: ota_lme_shd.constraint_error

124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.parent_integrity_violated Then
126: -- Parent integrity has been violated
127: --
128: ota_lme_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.unique_integrity_violated Then
131: -- Unique integrity has been violated
132: --

Line 133: ota_lme_shd.constraint_error

129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.unique_integrity_violated Then
131: -- Unique integrity has been violated
132: --
133: ota_lme_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When Others Then
136: --
137: Raise;

Line 173: (p_rec in ota_lme_shd.g_rec_type

169: --
170: -- {End Of Comments}
171: -- ----------------------------------------------------------------------------
172: Procedure pre_update
173: (p_rec in ota_lme_shd.g_rec_type
174: ) is
175: --
176: l_proc varchar2(72) := g_package||'pre_update';
177: --

Line 218: ,p_rec in ota_lme_shd.g_rec_type

214: -- {End Of Comments}
215: -- ----------------------------------------------------------------------------
216: Procedure post_update
217: (p_effective_date in date
218: ,p_rec in ota_lme_shd.g_rec_type
219: ) is
220: --
221: l_proc varchar2(72) := g_package||'post_update';
222: --

Line 312: => ota_lme_shd.g_old_rec.lp_enrollment_id

308: => p_rec.attribute30
309: ,p_creator_person_id
310: => p_rec.creator_person_id
311: ,p_lp_enrollment_id_o
312: => ota_lme_shd.g_old_rec.lp_enrollment_id
313: ,p_learning_path_section_id_o
314: => ota_lme_shd.g_old_rec.learning_path_section_id
315: ,p_learning_path_member_id_o
316: => ota_lme_shd.g_old_rec.learning_path_member_id

Line 314: => ota_lme_shd.g_old_rec.learning_path_section_id

310: => p_rec.creator_person_id
311: ,p_lp_enrollment_id_o
312: => ota_lme_shd.g_old_rec.lp_enrollment_id
313: ,p_learning_path_section_id_o
314: => ota_lme_shd.g_old_rec.learning_path_section_id
315: ,p_learning_path_member_id_o
316: => ota_lme_shd.g_old_rec.learning_path_member_id
317: ,p_member_status_code_o
318: => ota_lme_shd.g_old_rec.member_status_code

Line 316: => ota_lme_shd.g_old_rec.learning_path_member_id

312: => ota_lme_shd.g_old_rec.lp_enrollment_id
313: ,p_learning_path_section_id_o
314: => ota_lme_shd.g_old_rec.learning_path_section_id
315: ,p_learning_path_member_id_o
316: => ota_lme_shd.g_old_rec.learning_path_member_id
317: ,p_member_status_code_o
318: => ota_lme_shd.g_old_rec.member_status_code
319: ,p_completion_target_date_o
320: => ota_lme_shd.g_old_rec.completion_target_date

Line 318: => ota_lme_shd.g_old_rec.member_status_code

314: => ota_lme_shd.g_old_rec.learning_path_section_id
315: ,p_learning_path_member_id_o
316: => ota_lme_shd.g_old_rec.learning_path_member_id
317: ,p_member_status_code_o
318: => ota_lme_shd.g_old_rec.member_status_code
319: ,p_completion_target_date_o
320: => ota_lme_shd.g_old_rec.completion_target_date
321: ,p_completion_date_o
322: => ota_lme_shd.g_old_rec.completion_date

Line 320: => ota_lme_shd.g_old_rec.completion_target_date

316: => ota_lme_shd.g_old_rec.learning_path_member_id
317: ,p_member_status_code_o
318: => ota_lme_shd.g_old_rec.member_status_code
319: ,p_completion_target_date_o
320: => ota_lme_shd.g_old_rec.completion_target_date
321: ,p_completion_date_o
322: => ota_lme_shd.g_old_rec.completion_date
323: ,p_business_group_id_o
324: => ota_lme_shd.g_old_rec.business_group_id

Line 322: => ota_lme_shd.g_old_rec.completion_date

318: => ota_lme_shd.g_old_rec.member_status_code
319: ,p_completion_target_date_o
320: => ota_lme_shd.g_old_rec.completion_target_date
321: ,p_completion_date_o
322: => ota_lme_shd.g_old_rec.completion_date
323: ,p_business_group_id_o
324: => ota_lme_shd.g_old_rec.business_group_id
325: ,p_object_version_number_o
326: => ota_lme_shd.g_old_rec.object_version_number

Line 324: => ota_lme_shd.g_old_rec.business_group_id

320: => ota_lme_shd.g_old_rec.completion_target_date
321: ,p_completion_date_o
322: => ota_lme_shd.g_old_rec.completion_date
323: ,p_business_group_id_o
324: => ota_lme_shd.g_old_rec.business_group_id
325: ,p_object_version_number_o
326: => ota_lme_shd.g_old_rec.object_version_number
327: ,p_attribute_category_o
328: => ota_lme_shd.g_old_rec.attribute_category

Line 326: => ota_lme_shd.g_old_rec.object_version_number

322: => ota_lme_shd.g_old_rec.completion_date
323: ,p_business_group_id_o
324: => ota_lme_shd.g_old_rec.business_group_id
325: ,p_object_version_number_o
326: => ota_lme_shd.g_old_rec.object_version_number
327: ,p_attribute_category_o
328: => ota_lme_shd.g_old_rec.attribute_category
329: ,p_attribute1_o
330: => ota_lme_shd.g_old_rec.attribute1

Line 328: => ota_lme_shd.g_old_rec.attribute_category

324: => ota_lme_shd.g_old_rec.business_group_id
325: ,p_object_version_number_o
326: => ota_lme_shd.g_old_rec.object_version_number
327: ,p_attribute_category_o
328: => ota_lme_shd.g_old_rec.attribute_category
329: ,p_attribute1_o
330: => ota_lme_shd.g_old_rec.attribute1
331: ,p_attribute2_o
332: => ota_lme_shd.g_old_rec.attribute2

Line 330: => ota_lme_shd.g_old_rec.attribute1

326: => ota_lme_shd.g_old_rec.object_version_number
327: ,p_attribute_category_o
328: => ota_lme_shd.g_old_rec.attribute_category
329: ,p_attribute1_o
330: => ota_lme_shd.g_old_rec.attribute1
331: ,p_attribute2_o
332: => ota_lme_shd.g_old_rec.attribute2
333: ,p_attribute3_o
334: => ota_lme_shd.g_old_rec.attribute3

Line 332: => ota_lme_shd.g_old_rec.attribute2

328: => ota_lme_shd.g_old_rec.attribute_category
329: ,p_attribute1_o
330: => ota_lme_shd.g_old_rec.attribute1
331: ,p_attribute2_o
332: => ota_lme_shd.g_old_rec.attribute2
333: ,p_attribute3_o
334: => ota_lme_shd.g_old_rec.attribute3
335: ,p_attribute4_o
336: => ota_lme_shd.g_old_rec.attribute4

Line 334: => ota_lme_shd.g_old_rec.attribute3

330: => ota_lme_shd.g_old_rec.attribute1
331: ,p_attribute2_o
332: => ota_lme_shd.g_old_rec.attribute2
333: ,p_attribute3_o
334: => ota_lme_shd.g_old_rec.attribute3
335: ,p_attribute4_o
336: => ota_lme_shd.g_old_rec.attribute4
337: ,p_attribute5_o
338: => ota_lme_shd.g_old_rec.attribute5

Line 336: => ota_lme_shd.g_old_rec.attribute4

332: => ota_lme_shd.g_old_rec.attribute2
333: ,p_attribute3_o
334: => ota_lme_shd.g_old_rec.attribute3
335: ,p_attribute4_o
336: => ota_lme_shd.g_old_rec.attribute4
337: ,p_attribute5_o
338: => ota_lme_shd.g_old_rec.attribute5
339: ,p_attribute6_o
340: => ota_lme_shd.g_old_rec.attribute6

Line 338: => ota_lme_shd.g_old_rec.attribute5

334: => ota_lme_shd.g_old_rec.attribute3
335: ,p_attribute4_o
336: => ota_lme_shd.g_old_rec.attribute4
337: ,p_attribute5_o
338: => ota_lme_shd.g_old_rec.attribute5
339: ,p_attribute6_o
340: => ota_lme_shd.g_old_rec.attribute6
341: ,p_attribute7_o
342: => ota_lme_shd.g_old_rec.attribute7

Line 340: => ota_lme_shd.g_old_rec.attribute6

336: => ota_lme_shd.g_old_rec.attribute4
337: ,p_attribute5_o
338: => ota_lme_shd.g_old_rec.attribute5
339: ,p_attribute6_o
340: => ota_lme_shd.g_old_rec.attribute6
341: ,p_attribute7_o
342: => ota_lme_shd.g_old_rec.attribute7
343: ,p_attribute8_o
344: => ota_lme_shd.g_old_rec.attribute8

Line 342: => ota_lme_shd.g_old_rec.attribute7

338: => ota_lme_shd.g_old_rec.attribute5
339: ,p_attribute6_o
340: => ota_lme_shd.g_old_rec.attribute6
341: ,p_attribute7_o
342: => ota_lme_shd.g_old_rec.attribute7
343: ,p_attribute8_o
344: => ota_lme_shd.g_old_rec.attribute8
345: ,p_attribute9_o
346: => ota_lme_shd.g_old_rec.attribute9

Line 344: => ota_lme_shd.g_old_rec.attribute8

340: => ota_lme_shd.g_old_rec.attribute6
341: ,p_attribute7_o
342: => ota_lme_shd.g_old_rec.attribute7
343: ,p_attribute8_o
344: => ota_lme_shd.g_old_rec.attribute8
345: ,p_attribute9_o
346: => ota_lme_shd.g_old_rec.attribute9
347: ,p_attribute10_o
348: => ota_lme_shd.g_old_rec.attribute10

Line 346: => ota_lme_shd.g_old_rec.attribute9

342: => ota_lme_shd.g_old_rec.attribute7
343: ,p_attribute8_o
344: => ota_lme_shd.g_old_rec.attribute8
345: ,p_attribute9_o
346: => ota_lme_shd.g_old_rec.attribute9
347: ,p_attribute10_o
348: => ota_lme_shd.g_old_rec.attribute10
349: ,p_attribute11_o
350: => ota_lme_shd.g_old_rec.attribute11

Line 348: => ota_lme_shd.g_old_rec.attribute10

344: => ota_lme_shd.g_old_rec.attribute8
345: ,p_attribute9_o
346: => ota_lme_shd.g_old_rec.attribute9
347: ,p_attribute10_o
348: => ota_lme_shd.g_old_rec.attribute10
349: ,p_attribute11_o
350: => ota_lme_shd.g_old_rec.attribute11
351: ,p_attribute12_o
352: => ota_lme_shd.g_old_rec.attribute12

Line 350: => ota_lme_shd.g_old_rec.attribute11

346: => ota_lme_shd.g_old_rec.attribute9
347: ,p_attribute10_o
348: => ota_lme_shd.g_old_rec.attribute10
349: ,p_attribute11_o
350: => ota_lme_shd.g_old_rec.attribute11
351: ,p_attribute12_o
352: => ota_lme_shd.g_old_rec.attribute12
353: ,p_attribute13_o
354: => ota_lme_shd.g_old_rec.attribute13

Line 352: => ota_lme_shd.g_old_rec.attribute12

348: => ota_lme_shd.g_old_rec.attribute10
349: ,p_attribute11_o
350: => ota_lme_shd.g_old_rec.attribute11
351: ,p_attribute12_o
352: => ota_lme_shd.g_old_rec.attribute12
353: ,p_attribute13_o
354: => ota_lme_shd.g_old_rec.attribute13
355: ,p_attribute14_o
356: => ota_lme_shd.g_old_rec.attribute14

Line 354: => ota_lme_shd.g_old_rec.attribute13

350: => ota_lme_shd.g_old_rec.attribute11
351: ,p_attribute12_o
352: => ota_lme_shd.g_old_rec.attribute12
353: ,p_attribute13_o
354: => ota_lme_shd.g_old_rec.attribute13
355: ,p_attribute14_o
356: => ota_lme_shd.g_old_rec.attribute14
357: ,p_attribute15_o
358: => ota_lme_shd.g_old_rec.attribute15

Line 356: => ota_lme_shd.g_old_rec.attribute14

352: => ota_lme_shd.g_old_rec.attribute12
353: ,p_attribute13_o
354: => ota_lme_shd.g_old_rec.attribute13
355: ,p_attribute14_o
356: => ota_lme_shd.g_old_rec.attribute14
357: ,p_attribute15_o
358: => ota_lme_shd.g_old_rec.attribute15
359: ,p_attribute16_o
360: => ota_lme_shd.g_old_rec.attribute16

Line 358: => ota_lme_shd.g_old_rec.attribute15

354: => ota_lme_shd.g_old_rec.attribute13
355: ,p_attribute14_o
356: => ota_lme_shd.g_old_rec.attribute14
357: ,p_attribute15_o
358: => ota_lme_shd.g_old_rec.attribute15
359: ,p_attribute16_o
360: => ota_lme_shd.g_old_rec.attribute16
361: ,p_attribute17_o
362: => ota_lme_shd.g_old_rec.attribute17

Line 360: => ota_lme_shd.g_old_rec.attribute16

356: => ota_lme_shd.g_old_rec.attribute14
357: ,p_attribute15_o
358: => ota_lme_shd.g_old_rec.attribute15
359: ,p_attribute16_o
360: => ota_lme_shd.g_old_rec.attribute16
361: ,p_attribute17_o
362: => ota_lme_shd.g_old_rec.attribute17
363: ,p_attribute18_o
364: => ota_lme_shd.g_old_rec.attribute18

Line 362: => ota_lme_shd.g_old_rec.attribute17

358: => ota_lme_shd.g_old_rec.attribute15
359: ,p_attribute16_o
360: => ota_lme_shd.g_old_rec.attribute16
361: ,p_attribute17_o
362: => ota_lme_shd.g_old_rec.attribute17
363: ,p_attribute18_o
364: => ota_lme_shd.g_old_rec.attribute18
365: ,p_attribute19_o
366: => ota_lme_shd.g_old_rec.attribute19

Line 364: => ota_lme_shd.g_old_rec.attribute18

360: => ota_lme_shd.g_old_rec.attribute16
361: ,p_attribute17_o
362: => ota_lme_shd.g_old_rec.attribute17
363: ,p_attribute18_o
364: => ota_lme_shd.g_old_rec.attribute18
365: ,p_attribute19_o
366: => ota_lme_shd.g_old_rec.attribute19
367: ,p_attribute20_o
368: => ota_lme_shd.g_old_rec.attribute20

Line 366: => ota_lme_shd.g_old_rec.attribute19

362: => ota_lme_shd.g_old_rec.attribute17
363: ,p_attribute18_o
364: => ota_lme_shd.g_old_rec.attribute18
365: ,p_attribute19_o
366: => ota_lme_shd.g_old_rec.attribute19
367: ,p_attribute20_o
368: => ota_lme_shd.g_old_rec.attribute20
369: ,p_attribute21_o
370: => ota_lme_shd.g_old_rec.attribute21

Line 368: => ota_lme_shd.g_old_rec.attribute20

364: => ota_lme_shd.g_old_rec.attribute18
365: ,p_attribute19_o
366: => ota_lme_shd.g_old_rec.attribute19
367: ,p_attribute20_o
368: => ota_lme_shd.g_old_rec.attribute20
369: ,p_attribute21_o
370: => ota_lme_shd.g_old_rec.attribute21
371: ,p_attribute22_o
372: => ota_lme_shd.g_old_rec.attribute22

Line 370: => ota_lme_shd.g_old_rec.attribute21

366: => ota_lme_shd.g_old_rec.attribute19
367: ,p_attribute20_o
368: => ota_lme_shd.g_old_rec.attribute20
369: ,p_attribute21_o
370: => ota_lme_shd.g_old_rec.attribute21
371: ,p_attribute22_o
372: => ota_lme_shd.g_old_rec.attribute22
373: ,p_attribute23_o
374: => ota_lme_shd.g_old_rec.attribute23

Line 372: => ota_lme_shd.g_old_rec.attribute22

368: => ota_lme_shd.g_old_rec.attribute20
369: ,p_attribute21_o
370: => ota_lme_shd.g_old_rec.attribute21
371: ,p_attribute22_o
372: => ota_lme_shd.g_old_rec.attribute22
373: ,p_attribute23_o
374: => ota_lme_shd.g_old_rec.attribute23
375: ,p_attribute24_o
376: => ota_lme_shd.g_old_rec.attribute24

Line 374: => ota_lme_shd.g_old_rec.attribute23

370: => ota_lme_shd.g_old_rec.attribute21
371: ,p_attribute22_o
372: => ota_lme_shd.g_old_rec.attribute22
373: ,p_attribute23_o
374: => ota_lme_shd.g_old_rec.attribute23
375: ,p_attribute24_o
376: => ota_lme_shd.g_old_rec.attribute24
377: ,p_attribute25_o
378: => ota_lme_shd.g_old_rec.attribute25

Line 376: => ota_lme_shd.g_old_rec.attribute24

372: => ota_lme_shd.g_old_rec.attribute22
373: ,p_attribute23_o
374: => ota_lme_shd.g_old_rec.attribute23
375: ,p_attribute24_o
376: => ota_lme_shd.g_old_rec.attribute24
377: ,p_attribute25_o
378: => ota_lme_shd.g_old_rec.attribute25
379: ,p_attribute26_o
380: => ota_lme_shd.g_old_rec.attribute26

Line 378: => ota_lme_shd.g_old_rec.attribute25

374: => ota_lme_shd.g_old_rec.attribute23
375: ,p_attribute24_o
376: => ota_lme_shd.g_old_rec.attribute24
377: ,p_attribute25_o
378: => ota_lme_shd.g_old_rec.attribute25
379: ,p_attribute26_o
380: => ota_lme_shd.g_old_rec.attribute26
381: ,p_attribute27_o
382: => ota_lme_shd.g_old_rec.attribute27

Line 380: => ota_lme_shd.g_old_rec.attribute26

376: => ota_lme_shd.g_old_rec.attribute24
377: ,p_attribute25_o
378: => ota_lme_shd.g_old_rec.attribute25
379: ,p_attribute26_o
380: => ota_lme_shd.g_old_rec.attribute26
381: ,p_attribute27_o
382: => ota_lme_shd.g_old_rec.attribute27
383: ,p_attribute28_o
384: => ota_lme_shd.g_old_rec.attribute28

Line 382: => ota_lme_shd.g_old_rec.attribute27

378: => ota_lme_shd.g_old_rec.attribute25
379: ,p_attribute26_o
380: => ota_lme_shd.g_old_rec.attribute26
381: ,p_attribute27_o
382: => ota_lme_shd.g_old_rec.attribute27
383: ,p_attribute28_o
384: => ota_lme_shd.g_old_rec.attribute28
385: ,p_attribute29_o
386: => ota_lme_shd.g_old_rec.attribute29

Line 384: => ota_lme_shd.g_old_rec.attribute28

380: => ota_lme_shd.g_old_rec.attribute26
381: ,p_attribute27_o
382: => ota_lme_shd.g_old_rec.attribute27
383: ,p_attribute28_o
384: => ota_lme_shd.g_old_rec.attribute28
385: ,p_attribute29_o
386: => ota_lme_shd.g_old_rec.attribute29
387: ,p_attribute30_o
388: => ota_lme_shd.g_old_rec.attribute30

Line 386: => ota_lme_shd.g_old_rec.attribute29

382: => ota_lme_shd.g_old_rec.attribute27
383: ,p_attribute28_o
384: => ota_lme_shd.g_old_rec.attribute28
385: ,p_attribute29_o
386: => ota_lme_shd.g_old_rec.attribute29
387: ,p_attribute30_o
388: => ota_lme_shd.g_old_rec.attribute30
389: ,p_creator_person_id_o
390: => ota_lme_shd.g_old_rec.creator_person_id

Line 388: => ota_lme_shd.g_old_rec.attribute30

384: => ota_lme_shd.g_old_rec.attribute28
385: ,p_attribute29_o
386: => ota_lme_shd.g_old_rec.attribute29
387: ,p_attribute30_o
388: => ota_lme_shd.g_old_rec.attribute30
389: ,p_creator_person_id_o
390: => ota_lme_shd.g_old_rec.creator_person_id
391: );
392: --

Line 390: => ota_lme_shd.g_old_rec.creator_person_id

386: => ota_lme_shd.g_old_rec.attribute29
387: ,p_attribute30_o
388: => ota_lme_shd.g_old_rec.attribute30
389: ,p_creator_person_id_o
390: => ota_lme_shd.g_old_rec.creator_person_id
391: );
392: --
393: exception
394: --

Line 450: (p_rec in out nocopy ota_lme_shd.g_rec_type

446: --
447: -- {End Of Comments}
448: -- ----------------------------------------------------------------------------
449: Procedure convert_defs
450: (p_rec in out nocopy ota_lme_shd.g_rec_type
451: ) is
452: --
453: Begin
454: --

Line 462: ota_lme_shd.g_old_rec.lp_enrollment_id;

458: -- is being used then we must set to the 'current' argument value.
459: --
460: If (p_rec.lp_enrollment_id = hr_api.g_number) then
461: p_rec.lp_enrollment_id :=
462: ota_lme_shd.g_old_rec.lp_enrollment_id;
463: End If;
464: If (p_rec.learning_path_section_id = hr_api.g_number) then
465: p_rec.learning_path_section_id :=
466: ota_lme_shd.g_old_rec.learning_path_section_id;

Line 466: ota_lme_shd.g_old_rec.learning_path_section_id;

462: ota_lme_shd.g_old_rec.lp_enrollment_id;
463: End If;
464: If (p_rec.learning_path_section_id = hr_api.g_number) then
465: p_rec.learning_path_section_id :=
466: ota_lme_shd.g_old_rec.learning_path_section_id;
467: End If;
468: If (p_rec.learning_path_member_id = hr_api.g_number) then
469: p_rec.learning_path_member_id :=
470: ota_lme_shd.g_old_rec.learning_path_member_id;

Line 470: ota_lme_shd.g_old_rec.learning_path_member_id;

466: ota_lme_shd.g_old_rec.learning_path_section_id;
467: End If;
468: If (p_rec.learning_path_member_id = hr_api.g_number) then
469: p_rec.learning_path_member_id :=
470: ota_lme_shd.g_old_rec.learning_path_member_id;
471: End If;
472: If (p_rec.member_status_code = hr_api.g_varchar2) then
473: p_rec.member_status_code :=
474: ota_lme_shd.g_old_rec.member_status_code;

Line 474: ota_lme_shd.g_old_rec.member_status_code;

470: ota_lme_shd.g_old_rec.learning_path_member_id;
471: End If;
472: If (p_rec.member_status_code = hr_api.g_varchar2) then
473: p_rec.member_status_code :=
474: ota_lme_shd.g_old_rec.member_status_code;
475: End If;
476: If (p_rec.completion_target_date = hr_api.g_date) then
477: p_rec.completion_target_date :=
478: ota_lme_shd.g_old_rec.completion_target_date;

Line 478: ota_lme_shd.g_old_rec.completion_target_date;

474: ota_lme_shd.g_old_rec.member_status_code;
475: End If;
476: If (p_rec.completion_target_date = hr_api.g_date) then
477: p_rec.completion_target_date :=
478: ota_lme_shd.g_old_rec.completion_target_date;
479: End If;
480: If (p_rec.completion_date = hr_api.g_date) then
481: p_rec.completion_date :=
482: ota_lme_shd.g_old_rec.completion_date;

Line 482: ota_lme_shd.g_old_rec.completion_date;

478: ota_lme_shd.g_old_rec.completion_target_date;
479: End If;
480: If (p_rec.completion_date = hr_api.g_date) then
481: p_rec.completion_date :=
482: ota_lme_shd.g_old_rec.completion_date;
483: End If;
484: If (p_rec.business_group_id = hr_api.g_number) then
485: p_rec.business_group_id :=
486: ota_lme_shd.g_old_rec.business_group_id;

Line 486: ota_lme_shd.g_old_rec.business_group_id;

482: ota_lme_shd.g_old_rec.completion_date;
483: End If;
484: If (p_rec.business_group_id = hr_api.g_number) then
485: p_rec.business_group_id :=
486: ota_lme_shd.g_old_rec.business_group_id;
487: End If;
488: If (p_rec.attribute_category = hr_api.g_varchar2) then
489: p_rec.attribute_category :=
490: ota_lme_shd.g_old_rec.attribute_category;

Line 490: ota_lme_shd.g_old_rec.attribute_category;

486: ota_lme_shd.g_old_rec.business_group_id;
487: End If;
488: If (p_rec.attribute_category = hr_api.g_varchar2) then
489: p_rec.attribute_category :=
490: ota_lme_shd.g_old_rec.attribute_category;
491: End If;
492: If (p_rec.attribute1 = hr_api.g_varchar2) then
493: p_rec.attribute1 :=
494: ota_lme_shd.g_old_rec.attribute1;

Line 494: ota_lme_shd.g_old_rec.attribute1;

490: ota_lme_shd.g_old_rec.attribute_category;
491: End If;
492: If (p_rec.attribute1 = hr_api.g_varchar2) then
493: p_rec.attribute1 :=
494: ota_lme_shd.g_old_rec.attribute1;
495: End If;
496: If (p_rec.attribute2 = hr_api.g_varchar2) then
497: p_rec.attribute2 :=
498: ota_lme_shd.g_old_rec.attribute2;

Line 498: ota_lme_shd.g_old_rec.attribute2;

494: ota_lme_shd.g_old_rec.attribute1;
495: End If;
496: If (p_rec.attribute2 = hr_api.g_varchar2) then
497: p_rec.attribute2 :=
498: ota_lme_shd.g_old_rec.attribute2;
499: End If;
500: If (p_rec.attribute3 = hr_api.g_varchar2) then
501: p_rec.attribute3 :=
502: ota_lme_shd.g_old_rec.attribute3;

Line 502: ota_lme_shd.g_old_rec.attribute3;

498: ota_lme_shd.g_old_rec.attribute2;
499: End If;
500: If (p_rec.attribute3 = hr_api.g_varchar2) then
501: p_rec.attribute3 :=
502: ota_lme_shd.g_old_rec.attribute3;
503: End If;
504: If (p_rec.attribute4 = hr_api.g_varchar2) then
505: p_rec.attribute4 :=
506: ota_lme_shd.g_old_rec.attribute4;

Line 506: ota_lme_shd.g_old_rec.attribute4;

502: ota_lme_shd.g_old_rec.attribute3;
503: End If;
504: If (p_rec.attribute4 = hr_api.g_varchar2) then
505: p_rec.attribute4 :=
506: ota_lme_shd.g_old_rec.attribute4;
507: End If;
508: If (p_rec.attribute5 = hr_api.g_varchar2) then
509: p_rec.attribute5 :=
510: ota_lme_shd.g_old_rec.attribute5;

Line 510: ota_lme_shd.g_old_rec.attribute5;

506: ota_lme_shd.g_old_rec.attribute4;
507: End If;
508: If (p_rec.attribute5 = hr_api.g_varchar2) then
509: p_rec.attribute5 :=
510: ota_lme_shd.g_old_rec.attribute5;
511: End If;
512: If (p_rec.attribute6 = hr_api.g_varchar2) then
513: p_rec.attribute6 :=
514: ota_lme_shd.g_old_rec.attribute6;

Line 514: ota_lme_shd.g_old_rec.attribute6;

510: ota_lme_shd.g_old_rec.attribute5;
511: End If;
512: If (p_rec.attribute6 = hr_api.g_varchar2) then
513: p_rec.attribute6 :=
514: ota_lme_shd.g_old_rec.attribute6;
515: End If;
516: If (p_rec.attribute7 = hr_api.g_varchar2) then
517: p_rec.attribute7 :=
518: ota_lme_shd.g_old_rec.attribute7;

Line 518: ota_lme_shd.g_old_rec.attribute7;

514: ota_lme_shd.g_old_rec.attribute6;
515: End If;
516: If (p_rec.attribute7 = hr_api.g_varchar2) then
517: p_rec.attribute7 :=
518: ota_lme_shd.g_old_rec.attribute7;
519: End If;
520: If (p_rec.attribute8 = hr_api.g_varchar2) then
521: p_rec.attribute8 :=
522: ota_lme_shd.g_old_rec.attribute8;

Line 522: ota_lme_shd.g_old_rec.attribute8;

518: ota_lme_shd.g_old_rec.attribute7;
519: End If;
520: If (p_rec.attribute8 = hr_api.g_varchar2) then
521: p_rec.attribute8 :=
522: ota_lme_shd.g_old_rec.attribute8;
523: End If;
524: If (p_rec.attribute9 = hr_api.g_varchar2) then
525: p_rec.attribute9 :=
526: ota_lme_shd.g_old_rec.attribute9;

Line 526: ota_lme_shd.g_old_rec.attribute9;

522: ota_lme_shd.g_old_rec.attribute8;
523: End If;
524: If (p_rec.attribute9 = hr_api.g_varchar2) then
525: p_rec.attribute9 :=
526: ota_lme_shd.g_old_rec.attribute9;
527: End If;
528: If (p_rec.attribute10 = hr_api.g_varchar2) then
529: p_rec.attribute10 :=
530: ota_lme_shd.g_old_rec.attribute10;

Line 530: ota_lme_shd.g_old_rec.attribute10;

526: ota_lme_shd.g_old_rec.attribute9;
527: End If;
528: If (p_rec.attribute10 = hr_api.g_varchar2) then
529: p_rec.attribute10 :=
530: ota_lme_shd.g_old_rec.attribute10;
531: End If;
532: If (p_rec.attribute11 = hr_api.g_varchar2) then
533: p_rec.attribute11 :=
534: ota_lme_shd.g_old_rec.attribute11;

Line 534: ota_lme_shd.g_old_rec.attribute11;

530: ota_lme_shd.g_old_rec.attribute10;
531: End If;
532: If (p_rec.attribute11 = hr_api.g_varchar2) then
533: p_rec.attribute11 :=
534: ota_lme_shd.g_old_rec.attribute11;
535: End If;
536: If (p_rec.attribute12 = hr_api.g_varchar2) then
537: p_rec.attribute12 :=
538: ota_lme_shd.g_old_rec.attribute12;

Line 538: ota_lme_shd.g_old_rec.attribute12;

534: ota_lme_shd.g_old_rec.attribute11;
535: End If;
536: If (p_rec.attribute12 = hr_api.g_varchar2) then
537: p_rec.attribute12 :=
538: ota_lme_shd.g_old_rec.attribute12;
539: End If;
540: If (p_rec.attribute13 = hr_api.g_varchar2) then
541: p_rec.attribute13 :=
542: ota_lme_shd.g_old_rec.attribute13;

Line 542: ota_lme_shd.g_old_rec.attribute13;

538: ota_lme_shd.g_old_rec.attribute12;
539: End If;
540: If (p_rec.attribute13 = hr_api.g_varchar2) then
541: p_rec.attribute13 :=
542: ota_lme_shd.g_old_rec.attribute13;
543: End If;
544: If (p_rec.attribute14 = hr_api.g_varchar2) then
545: p_rec.attribute14 :=
546: ota_lme_shd.g_old_rec.attribute14;

Line 546: ota_lme_shd.g_old_rec.attribute14;

542: ota_lme_shd.g_old_rec.attribute13;
543: End If;
544: If (p_rec.attribute14 = hr_api.g_varchar2) then
545: p_rec.attribute14 :=
546: ota_lme_shd.g_old_rec.attribute14;
547: End If;
548: If (p_rec.attribute15 = hr_api.g_varchar2) then
549: p_rec.attribute15 :=
550: ota_lme_shd.g_old_rec.attribute15;

Line 550: ota_lme_shd.g_old_rec.attribute15;

546: ota_lme_shd.g_old_rec.attribute14;
547: End If;
548: If (p_rec.attribute15 = hr_api.g_varchar2) then
549: p_rec.attribute15 :=
550: ota_lme_shd.g_old_rec.attribute15;
551: End If;
552: If (p_rec.attribute16 = hr_api.g_varchar2) then
553: p_rec.attribute16 :=
554: ota_lme_shd.g_old_rec.attribute16;

Line 554: ota_lme_shd.g_old_rec.attribute16;

550: ota_lme_shd.g_old_rec.attribute15;
551: End If;
552: If (p_rec.attribute16 = hr_api.g_varchar2) then
553: p_rec.attribute16 :=
554: ota_lme_shd.g_old_rec.attribute16;
555: End If;
556: If (p_rec.attribute17 = hr_api.g_varchar2) then
557: p_rec.attribute17 :=
558: ota_lme_shd.g_old_rec.attribute17;

Line 558: ota_lme_shd.g_old_rec.attribute17;

554: ota_lme_shd.g_old_rec.attribute16;
555: End If;
556: If (p_rec.attribute17 = hr_api.g_varchar2) then
557: p_rec.attribute17 :=
558: ota_lme_shd.g_old_rec.attribute17;
559: End If;
560: If (p_rec.attribute18 = hr_api.g_varchar2) then
561: p_rec.attribute18 :=
562: ota_lme_shd.g_old_rec.attribute18;

Line 562: ota_lme_shd.g_old_rec.attribute18;

558: ota_lme_shd.g_old_rec.attribute17;
559: End If;
560: If (p_rec.attribute18 = hr_api.g_varchar2) then
561: p_rec.attribute18 :=
562: ota_lme_shd.g_old_rec.attribute18;
563: End If;
564: If (p_rec.attribute19 = hr_api.g_varchar2) then
565: p_rec.attribute19 :=
566: ota_lme_shd.g_old_rec.attribute19;

Line 566: ota_lme_shd.g_old_rec.attribute19;

562: ota_lme_shd.g_old_rec.attribute18;
563: End If;
564: If (p_rec.attribute19 = hr_api.g_varchar2) then
565: p_rec.attribute19 :=
566: ota_lme_shd.g_old_rec.attribute19;
567: End If;
568: If (p_rec.attribute20 = hr_api.g_varchar2) then
569: p_rec.attribute20 :=
570: ota_lme_shd.g_old_rec.attribute20;

Line 570: ota_lme_shd.g_old_rec.attribute20;

566: ota_lme_shd.g_old_rec.attribute19;
567: End If;
568: If (p_rec.attribute20 = hr_api.g_varchar2) then
569: p_rec.attribute20 :=
570: ota_lme_shd.g_old_rec.attribute20;
571: End If;
572: If (p_rec.attribute21 = hr_api.g_varchar2) then
573: p_rec.attribute21 :=
574: ota_lme_shd.g_old_rec.attribute21;

Line 574: ota_lme_shd.g_old_rec.attribute21;

570: ota_lme_shd.g_old_rec.attribute20;
571: End If;
572: If (p_rec.attribute21 = hr_api.g_varchar2) then
573: p_rec.attribute21 :=
574: ota_lme_shd.g_old_rec.attribute21;
575: End If;
576: If (p_rec.attribute22 = hr_api.g_varchar2) then
577: p_rec.attribute22 :=
578: ota_lme_shd.g_old_rec.attribute22;

Line 578: ota_lme_shd.g_old_rec.attribute22;

574: ota_lme_shd.g_old_rec.attribute21;
575: End If;
576: If (p_rec.attribute22 = hr_api.g_varchar2) then
577: p_rec.attribute22 :=
578: ota_lme_shd.g_old_rec.attribute22;
579: End If;
580: If (p_rec.attribute23 = hr_api.g_varchar2) then
581: p_rec.attribute23 :=
582: ota_lme_shd.g_old_rec.attribute23;

Line 582: ota_lme_shd.g_old_rec.attribute23;

578: ota_lme_shd.g_old_rec.attribute22;
579: End If;
580: If (p_rec.attribute23 = hr_api.g_varchar2) then
581: p_rec.attribute23 :=
582: ota_lme_shd.g_old_rec.attribute23;
583: End If;
584: If (p_rec.attribute24 = hr_api.g_varchar2) then
585: p_rec.attribute24 :=
586: ota_lme_shd.g_old_rec.attribute24;

Line 586: ota_lme_shd.g_old_rec.attribute24;

582: ota_lme_shd.g_old_rec.attribute23;
583: End If;
584: If (p_rec.attribute24 = hr_api.g_varchar2) then
585: p_rec.attribute24 :=
586: ota_lme_shd.g_old_rec.attribute24;
587: End If;
588: If (p_rec.attribute25 = hr_api.g_varchar2) then
589: p_rec.attribute25 :=
590: ota_lme_shd.g_old_rec.attribute25;

Line 590: ota_lme_shd.g_old_rec.attribute25;

586: ota_lme_shd.g_old_rec.attribute24;
587: End If;
588: If (p_rec.attribute25 = hr_api.g_varchar2) then
589: p_rec.attribute25 :=
590: ota_lme_shd.g_old_rec.attribute25;
591: End If;
592: If (p_rec.attribute26 = hr_api.g_varchar2) then
593: p_rec.attribute26 :=
594: ota_lme_shd.g_old_rec.attribute26;

Line 594: ota_lme_shd.g_old_rec.attribute26;

590: ota_lme_shd.g_old_rec.attribute25;
591: End If;
592: If (p_rec.attribute26 = hr_api.g_varchar2) then
593: p_rec.attribute26 :=
594: ota_lme_shd.g_old_rec.attribute26;
595: End If;
596: If (p_rec.attribute27 = hr_api.g_varchar2) then
597: p_rec.attribute27 :=
598: ota_lme_shd.g_old_rec.attribute27;

Line 598: ota_lme_shd.g_old_rec.attribute27;

594: ota_lme_shd.g_old_rec.attribute26;
595: End If;
596: If (p_rec.attribute27 = hr_api.g_varchar2) then
597: p_rec.attribute27 :=
598: ota_lme_shd.g_old_rec.attribute27;
599: End If;
600: If (p_rec.attribute28 = hr_api.g_varchar2) then
601: p_rec.attribute28 :=
602: ota_lme_shd.g_old_rec.attribute28;

Line 602: ota_lme_shd.g_old_rec.attribute28;

598: ota_lme_shd.g_old_rec.attribute27;
599: End If;
600: If (p_rec.attribute28 = hr_api.g_varchar2) then
601: p_rec.attribute28 :=
602: ota_lme_shd.g_old_rec.attribute28;
603: End If;
604: If (p_rec.attribute29 = hr_api.g_varchar2) then
605: p_rec.attribute29 :=
606: ota_lme_shd.g_old_rec.attribute29;

Line 606: ota_lme_shd.g_old_rec.attribute29;

602: ota_lme_shd.g_old_rec.attribute28;
603: End If;
604: If (p_rec.attribute29 = hr_api.g_varchar2) then
605: p_rec.attribute29 :=
606: ota_lme_shd.g_old_rec.attribute29;
607: End If;
608: If (p_rec.attribute30 = hr_api.g_varchar2) then
609: p_rec.attribute30 :=
610: ota_lme_shd.g_old_rec.attribute30;

Line 610: ota_lme_shd.g_old_rec.attribute30;

606: ota_lme_shd.g_old_rec.attribute29;
607: End If;
608: If (p_rec.attribute30 = hr_api.g_varchar2) then
609: p_rec.attribute30 :=
610: ota_lme_shd.g_old_rec.attribute30;
611: End If;
612: If (p_rec.creator_person_id = hr_api.g_number) then
613: p_rec.creator_person_id :=
614: ota_lme_shd.g_old_rec.creator_person_id;

Line 614: ota_lme_shd.g_old_rec.creator_person_id;

610: ota_lme_shd.g_old_rec.attribute30;
611: End If;
612: If (p_rec.creator_person_id = hr_api.g_number) then
613: p_rec.creator_person_id :=
614: ota_lme_shd.g_old_rec.creator_person_id;
615: End If;
616: --
617: End convert_defs;
618: --

Line 624: ,p_rec in out nocopy ota_lme_shd.g_rec_type

620: -- |---------------------------------< upd >----------------------------------|
621: -- ----------------------------------------------------------------------------
622: Procedure upd
623: (p_effective_date in date
624: ,p_rec in out nocopy ota_lme_shd.g_rec_type
625: ) is
626: --
627: l_proc varchar2(72) := g_package||'upd';
628: --

Line 634: ota_lme_shd.lck

630: hr_utility.set_location('Entering:'||l_proc, 5);
631: --
632: -- We must lock the row which we need to update.
633: --
634: ota_lme_shd.lck
635: (p_rec.lp_member_enrollment_id
636: ,p_rec.object_version_number
637: );
638: --

Line 721: l_rec ota_lme_shd.g_rec_type;

717: ,p_attribute30 in varchar2 default hr_api.g_varchar2
718: ,p_creator_person_id in number default hr_api.g_number
719: ) is
720: --
721: l_rec ota_lme_shd.g_rec_type;
722: l_proc varchar2(72) := g_package||'upd';
723: --
724: Begin
725: hr_utility.set_location('Entering:'||l_proc, 5);

Line 731: ota_lme_shd.convert_args

727: -- Call conversion function to turn arguments into the
728: -- l_rec structure.
729: --
730: l_rec :=
731: ota_lme_shd.convert_args
732: (p_lp_member_enrollment_id
733: ,p_lp_enrollment_id
734: ,p_learning_path_section_id
735: ,p_learning_path_member_id