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_LPE_UPD dependencies on OTA_LPE_SHD

Line 55: (p_rec in out nocopy ota_lpe_shd.g_rec_type

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

Line 127: ota_lpe_shd.constraint_error

123: Exception
124: When hr_api.check_integrity_violated Then
125: -- A check constraint has been violated
126: --
127: ota_lpe_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated
131: --

Line 132: ota_lpe_shd.constraint_error

128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated
131: --
132: ota_lpe_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated
136: --

Line 137: ota_lpe_shd.constraint_error

133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated
136: --
137: ota_lpe_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: --
141: Raise;

Line 177: (p_rec in ota_lpe_shd.g_rec_type

173: --
174: -- {End Of Comments}
175: -- ----------------------------------------------------------------------------
176: Procedure pre_update
177: (p_rec in ota_lpe_shd.g_rec_type
178: ) is
179: --
180: l_proc varchar2(72) := g_package||'pre_update';
181: --

Line 222: ,p_rec in ota_lpe_shd.g_rec_type

218: -- {End Of Comments}
219: -- ----------------------------------------------------------------------------
220: Procedure post_update
221: (p_effective_date in date
222: ,p_rec in ota_lpe_shd.g_rec_type
223: ) is
224: --
225: l_proc varchar2(72) := g_package||'post_update';
226: --

Line 324: => ota_lpe_shd.g_old_rec.learning_path_id

320: => p_rec.attribute30
321: ,p_is_history_flag
322: => p_rec.is_history_flag
323: ,p_learning_path_id_o
324: => ota_lpe_shd.g_old_rec.learning_path_id
325: ,p_person_id_o
326: => ota_lpe_shd.g_old_rec.person_id
327: ,p_contact_id_o
328: => ota_lpe_shd.g_old_rec.contact_id

Line 326: => ota_lpe_shd.g_old_rec.person_id

322: => p_rec.is_history_flag
323: ,p_learning_path_id_o
324: => ota_lpe_shd.g_old_rec.learning_path_id
325: ,p_person_id_o
326: => ota_lpe_shd.g_old_rec.person_id
327: ,p_contact_id_o
328: => ota_lpe_shd.g_old_rec.contact_id
329: ,p_path_status_code_o
330: => ota_lpe_shd.g_old_rec.path_status_code

Line 328: => ota_lpe_shd.g_old_rec.contact_id

324: => ota_lpe_shd.g_old_rec.learning_path_id
325: ,p_person_id_o
326: => ota_lpe_shd.g_old_rec.person_id
327: ,p_contact_id_o
328: => ota_lpe_shd.g_old_rec.contact_id
329: ,p_path_status_code_o
330: => ota_lpe_shd.g_old_rec.path_status_code
331: ,p_enrollment_source_code_o
332: => ota_lpe_shd.g_old_rec.enrollment_source_code

Line 330: => ota_lpe_shd.g_old_rec.path_status_code

326: => ota_lpe_shd.g_old_rec.person_id
327: ,p_contact_id_o
328: => ota_lpe_shd.g_old_rec.contact_id
329: ,p_path_status_code_o
330: => ota_lpe_shd.g_old_rec.path_status_code
331: ,p_enrollment_source_code_o
332: => ota_lpe_shd.g_old_rec.enrollment_source_code
333: ,p_no_of_mandatory_courses_o
334: => ota_lpe_shd.g_old_rec.no_of_mandatory_courses

Line 332: => ota_lpe_shd.g_old_rec.enrollment_source_code

328: => ota_lpe_shd.g_old_rec.contact_id
329: ,p_path_status_code_o
330: => ota_lpe_shd.g_old_rec.path_status_code
331: ,p_enrollment_source_code_o
332: => ota_lpe_shd.g_old_rec.enrollment_source_code
333: ,p_no_of_mandatory_courses_o
334: => ota_lpe_shd.g_old_rec.no_of_mandatory_courses
335: ,p_no_of_completed_courses_o
336: => ota_lpe_shd.g_old_rec.no_of_completed_courses

Line 334: => ota_lpe_shd.g_old_rec.no_of_mandatory_courses

330: => ota_lpe_shd.g_old_rec.path_status_code
331: ,p_enrollment_source_code_o
332: => ota_lpe_shd.g_old_rec.enrollment_source_code
333: ,p_no_of_mandatory_courses_o
334: => ota_lpe_shd.g_old_rec.no_of_mandatory_courses
335: ,p_no_of_completed_courses_o
336: => ota_lpe_shd.g_old_rec.no_of_completed_courses
337: ,p_completion_target_date_o
338: => ota_lpe_shd.g_old_rec.completion_target_date

Line 336: => ota_lpe_shd.g_old_rec.no_of_completed_courses

332: => ota_lpe_shd.g_old_rec.enrollment_source_code
333: ,p_no_of_mandatory_courses_o
334: => ota_lpe_shd.g_old_rec.no_of_mandatory_courses
335: ,p_no_of_completed_courses_o
336: => ota_lpe_shd.g_old_rec.no_of_completed_courses
337: ,p_completion_target_date_o
338: => ota_lpe_shd.g_old_rec.completion_target_date
339: ,p_completion_date_o
340: => ota_lpe_shd.g_old_rec.completion_date

Line 338: => ota_lpe_shd.g_old_rec.completion_target_date

334: => ota_lpe_shd.g_old_rec.no_of_mandatory_courses
335: ,p_no_of_completed_courses_o
336: => ota_lpe_shd.g_old_rec.no_of_completed_courses
337: ,p_completion_target_date_o
338: => ota_lpe_shd.g_old_rec.completion_target_date
339: ,p_completion_date_o
340: => ota_lpe_shd.g_old_rec.completion_date
341: ,p_creator_person_id_o
342: => ota_lpe_shd.g_old_rec.creator_person_id

Line 340: => ota_lpe_shd.g_old_rec.completion_date

336: => ota_lpe_shd.g_old_rec.no_of_completed_courses
337: ,p_completion_target_date_o
338: => ota_lpe_shd.g_old_rec.completion_target_date
339: ,p_completion_date_o
340: => ota_lpe_shd.g_old_rec.completion_date
341: ,p_creator_person_id_o
342: => ota_lpe_shd.g_old_rec.creator_person_id
343: ,p_object_version_number_o
344: => ota_lpe_shd.g_old_rec.object_version_number

Line 342: => ota_lpe_shd.g_old_rec.creator_person_id

338: => ota_lpe_shd.g_old_rec.completion_target_date
339: ,p_completion_date_o
340: => ota_lpe_shd.g_old_rec.completion_date
341: ,p_creator_person_id_o
342: => ota_lpe_shd.g_old_rec.creator_person_id
343: ,p_object_version_number_o
344: => ota_lpe_shd.g_old_rec.object_version_number
345: ,p_business_group_id_o
346: => ota_lpe_shd.g_old_rec.business_group_id

Line 344: => ota_lpe_shd.g_old_rec.object_version_number

340: => ota_lpe_shd.g_old_rec.completion_date
341: ,p_creator_person_id_o
342: => ota_lpe_shd.g_old_rec.creator_person_id
343: ,p_object_version_number_o
344: => ota_lpe_shd.g_old_rec.object_version_number
345: ,p_business_group_id_o
346: => ota_lpe_shd.g_old_rec.business_group_id
347: ,p_attribute_category_o
348: => ota_lpe_shd.g_old_rec.attribute_category

Line 346: => ota_lpe_shd.g_old_rec.business_group_id

342: => ota_lpe_shd.g_old_rec.creator_person_id
343: ,p_object_version_number_o
344: => ota_lpe_shd.g_old_rec.object_version_number
345: ,p_business_group_id_o
346: => ota_lpe_shd.g_old_rec.business_group_id
347: ,p_attribute_category_o
348: => ota_lpe_shd.g_old_rec.attribute_category
349: ,p_attribute1_o
350: => ota_lpe_shd.g_old_rec.attribute1

Line 348: => ota_lpe_shd.g_old_rec.attribute_category

344: => ota_lpe_shd.g_old_rec.object_version_number
345: ,p_business_group_id_o
346: => ota_lpe_shd.g_old_rec.business_group_id
347: ,p_attribute_category_o
348: => ota_lpe_shd.g_old_rec.attribute_category
349: ,p_attribute1_o
350: => ota_lpe_shd.g_old_rec.attribute1
351: ,p_attribute2_o
352: => ota_lpe_shd.g_old_rec.attribute2

Line 350: => ota_lpe_shd.g_old_rec.attribute1

346: => ota_lpe_shd.g_old_rec.business_group_id
347: ,p_attribute_category_o
348: => ota_lpe_shd.g_old_rec.attribute_category
349: ,p_attribute1_o
350: => ota_lpe_shd.g_old_rec.attribute1
351: ,p_attribute2_o
352: => ota_lpe_shd.g_old_rec.attribute2
353: ,p_attribute3_o
354: => ota_lpe_shd.g_old_rec.attribute3

Line 352: => ota_lpe_shd.g_old_rec.attribute2

348: => ota_lpe_shd.g_old_rec.attribute_category
349: ,p_attribute1_o
350: => ota_lpe_shd.g_old_rec.attribute1
351: ,p_attribute2_o
352: => ota_lpe_shd.g_old_rec.attribute2
353: ,p_attribute3_o
354: => ota_lpe_shd.g_old_rec.attribute3
355: ,p_attribute4_o
356: => ota_lpe_shd.g_old_rec.attribute4

Line 354: => ota_lpe_shd.g_old_rec.attribute3

350: => ota_lpe_shd.g_old_rec.attribute1
351: ,p_attribute2_o
352: => ota_lpe_shd.g_old_rec.attribute2
353: ,p_attribute3_o
354: => ota_lpe_shd.g_old_rec.attribute3
355: ,p_attribute4_o
356: => ota_lpe_shd.g_old_rec.attribute4
357: ,p_attribute5_o
358: => ota_lpe_shd.g_old_rec.attribute5

Line 356: => ota_lpe_shd.g_old_rec.attribute4

352: => ota_lpe_shd.g_old_rec.attribute2
353: ,p_attribute3_o
354: => ota_lpe_shd.g_old_rec.attribute3
355: ,p_attribute4_o
356: => ota_lpe_shd.g_old_rec.attribute4
357: ,p_attribute5_o
358: => ota_lpe_shd.g_old_rec.attribute5
359: ,p_attribute6_o
360: => ota_lpe_shd.g_old_rec.attribute6

Line 358: => ota_lpe_shd.g_old_rec.attribute5

354: => ota_lpe_shd.g_old_rec.attribute3
355: ,p_attribute4_o
356: => ota_lpe_shd.g_old_rec.attribute4
357: ,p_attribute5_o
358: => ota_lpe_shd.g_old_rec.attribute5
359: ,p_attribute6_o
360: => ota_lpe_shd.g_old_rec.attribute6
361: ,p_attribute7_o
362: => ota_lpe_shd.g_old_rec.attribute7

Line 360: => ota_lpe_shd.g_old_rec.attribute6

356: => ota_lpe_shd.g_old_rec.attribute4
357: ,p_attribute5_o
358: => ota_lpe_shd.g_old_rec.attribute5
359: ,p_attribute6_o
360: => ota_lpe_shd.g_old_rec.attribute6
361: ,p_attribute7_o
362: => ota_lpe_shd.g_old_rec.attribute7
363: ,p_attribute8_o
364: => ota_lpe_shd.g_old_rec.attribute8

Line 362: => ota_lpe_shd.g_old_rec.attribute7

358: => ota_lpe_shd.g_old_rec.attribute5
359: ,p_attribute6_o
360: => ota_lpe_shd.g_old_rec.attribute6
361: ,p_attribute7_o
362: => ota_lpe_shd.g_old_rec.attribute7
363: ,p_attribute8_o
364: => ota_lpe_shd.g_old_rec.attribute8
365: ,p_attribute9_o
366: => ota_lpe_shd.g_old_rec.attribute9

Line 364: => ota_lpe_shd.g_old_rec.attribute8

360: => ota_lpe_shd.g_old_rec.attribute6
361: ,p_attribute7_o
362: => ota_lpe_shd.g_old_rec.attribute7
363: ,p_attribute8_o
364: => ota_lpe_shd.g_old_rec.attribute8
365: ,p_attribute9_o
366: => ota_lpe_shd.g_old_rec.attribute9
367: ,p_attribute10_o
368: => ota_lpe_shd.g_old_rec.attribute10

Line 366: => ota_lpe_shd.g_old_rec.attribute9

362: => ota_lpe_shd.g_old_rec.attribute7
363: ,p_attribute8_o
364: => ota_lpe_shd.g_old_rec.attribute8
365: ,p_attribute9_o
366: => ota_lpe_shd.g_old_rec.attribute9
367: ,p_attribute10_o
368: => ota_lpe_shd.g_old_rec.attribute10
369: ,p_attribute11_o
370: => ota_lpe_shd.g_old_rec.attribute11

Line 368: => ota_lpe_shd.g_old_rec.attribute10

364: => ota_lpe_shd.g_old_rec.attribute8
365: ,p_attribute9_o
366: => ota_lpe_shd.g_old_rec.attribute9
367: ,p_attribute10_o
368: => ota_lpe_shd.g_old_rec.attribute10
369: ,p_attribute11_o
370: => ota_lpe_shd.g_old_rec.attribute11
371: ,p_attribute12_o
372: => ota_lpe_shd.g_old_rec.attribute12

Line 370: => ota_lpe_shd.g_old_rec.attribute11

366: => ota_lpe_shd.g_old_rec.attribute9
367: ,p_attribute10_o
368: => ota_lpe_shd.g_old_rec.attribute10
369: ,p_attribute11_o
370: => ota_lpe_shd.g_old_rec.attribute11
371: ,p_attribute12_o
372: => ota_lpe_shd.g_old_rec.attribute12
373: ,p_attribute13_o
374: => ota_lpe_shd.g_old_rec.attribute13

Line 372: => ota_lpe_shd.g_old_rec.attribute12

368: => ota_lpe_shd.g_old_rec.attribute10
369: ,p_attribute11_o
370: => ota_lpe_shd.g_old_rec.attribute11
371: ,p_attribute12_o
372: => ota_lpe_shd.g_old_rec.attribute12
373: ,p_attribute13_o
374: => ota_lpe_shd.g_old_rec.attribute13
375: ,p_attribute14_o
376: => ota_lpe_shd.g_old_rec.attribute14

Line 374: => ota_lpe_shd.g_old_rec.attribute13

370: => ota_lpe_shd.g_old_rec.attribute11
371: ,p_attribute12_o
372: => ota_lpe_shd.g_old_rec.attribute12
373: ,p_attribute13_o
374: => ota_lpe_shd.g_old_rec.attribute13
375: ,p_attribute14_o
376: => ota_lpe_shd.g_old_rec.attribute14
377: ,p_attribute15_o
378: => ota_lpe_shd.g_old_rec.attribute15

Line 376: => ota_lpe_shd.g_old_rec.attribute14

372: => ota_lpe_shd.g_old_rec.attribute12
373: ,p_attribute13_o
374: => ota_lpe_shd.g_old_rec.attribute13
375: ,p_attribute14_o
376: => ota_lpe_shd.g_old_rec.attribute14
377: ,p_attribute15_o
378: => ota_lpe_shd.g_old_rec.attribute15
379: ,p_attribute16_o
380: => ota_lpe_shd.g_old_rec.attribute16

Line 378: => ota_lpe_shd.g_old_rec.attribute15

374: => ota_lpe_shd.g_old_rec.attribute13
375: ,p_attribute14_o
376: => ota_lpe_shd.g_old_rec.attribute14
377: ,p_attribute15_o
378: => ota_lpe_shd.g_old_rec.attribute15
379: ,p_attribute16_o
380: => ota_lpe_shd.g_old_rec.attribute16
381: ,p_attribute17_o
382: => ota_lpe_shd.g_old_rec.attribute17

Line 380: => ota_lpe_shd.g_old_rec.attribute16

376: => ota_lpe_shd.g_old_rec.attribute14
377: ,p_attribute15_o
378: => ota_lpe_shd.g_old_rec.attribute15
379: ,p_attribute16_o
380: => ota_lpe_shd.g_old_rec.attribute16
381: ,p_attribute17_o
382: => ota_lpe_shd.g_old_rec.attribute17
383: ,p_attribute18_o
384: => ota_lpe_shd.g_old_rec.attribute18

Line 382: => ota_lpe_shd.g_old_rec.attribute17

378: => ota_lpe_shd.g_old_rec.attribute15
379: ,p_attribute16_o
380: => ota_lpe_shd.g_old_rec.attribute16
381: ,p_attribute17_o
382: => ota_lpe_shd.g_old_rec.attribute17
383: ,p_attribute18_o
384: => ota_lpe_shd.g_old_rec.attribute18
385: ,p_attribute19_o
386: => ota_lpe_shd.g_old_rec.attribute19

Line 384: => ota_lpe_shd.g_old_rec.attribute18

380: => ota_lpe_shd.g_old_rec.attribute16
381: ,p_attribute17_o
382: => ota_lpe_shd.g_old_rec.attribute17
383: ,p_attribute18_o
384: => ota_lpe_shd.g_old_rec.attribute18
385: ,p_attribute19_o
386: => ota_lpe_shd.g_old_rec.attribute19
387: ,p_attribute20_o
388: => ota_lpe_shd.g_old_rec.attribute20

Line 386: => ota_lpe_shd.g_old_rec.attribute19

382: => ota_lpe_shd.g_old_rec.attribute17
383: ,p_attribute18_o
384: => ota_lpe_shd.g_old_rec.attribute18
385: ,p_attribute19_o
386: => ota_lpe_shd.g_old_rec.attribute19
387: ,p_attribute20_o
388: => ota_lpe_shd.g_old_rec.attribute20
389: ,p_attribute21_o
390: => ota_lpe_shd.g_old_rec.attribute21

Line 388: => ota_lpe_shd.g_old_rec.attribute20

384: => ota_lpe_shd.g_old_rec.attribute18
385: ,p_attribute19_o
386: => ota_lpe_shd.g_old_rec.attribute19
387: ,p_attribute20_o
388: => ota_lpe_shd.g_old_rec.attribute20
389: ,p_attribute21_o
390: => ota_lpe_shd.g_old_rec.attribute21
391: ,p_attribute22_o
392: => ota_lpe_shd.g_old_rec.attribute22

Line 390: => ota_lpe_shd.g_old_rec.attribute21

386: => ota_lpe_shd.g_old_rec.attribute19
387: ,p_attribute20_o
388: => ota_lpe_shd.g_old_rec.attribute20
389: ,p_attribute21_o
390: => ota_lpe_shd.g_old_rec.attribute21
391: ,p_attribute22_o
392: => ota_lpe_shd.g_old_rec.attribute22
393: ,p_attribute23_o
394: => ota_lpe_shd.g_old_rec.attribute23

Line 392: => ota_lpe_shd.g_old_rec.attribute22

388: => ota_lpe_shd.g_old_rec.attribute20
389: ,p_attribute21_o
390: => ota_lpe_shd.g_old_rec.attribute21
391: ,p_attribute22_o
392: => ota_lpe_shd.g_old_rec.attribute22
393: ,p_attribute23_o
394: => ota_lpe_shd.g_old_rec.attribute23
395: ,p_attribute24_o
396: => ota_lpe_shd.g_old_rec.attribute24

Line 394: => ota_lpe_shd.g_old_rec.attribute23

390: => ota_lpe_shd.g_old_rec.attribute21
391: ,p_attribute22_o
392: => ota_lpe_shd.g_old_rec.attribute22
393: ,p_attribute23_o
394: => ota_lpe_shd.g_old_rec.attribute23
395: ,p_attribute24_o
396: => ota_lpe_shd.g_old_rec.attribute24
397: ,p_attribute25_o
398: => ota_lpe_shd.g_old_rec.attribute25

Line 396: => ota_lpe_shd.g_old_rec.attribute24

392: => ota_lpe_shd.g_old_rec.attribute22
393: ,p_attribute23_o
394: => ota_lpe_shd.g_old_rec.attribute23
395: ,p_attribute24_o
396: => ota_lpe_shd.g_old_rec.attribute24
397: ,p_attribute25_o
398: => ota_lpe_shd.g_old_rec.attribute25
399: ,p_attribute26_o
400: => ota_lpe_shd.g_old_rec.attribute26

Line 398: => ota_lpe_shd.g_old_rec.attribute25

394: => ota_lpe_shd.g_old_rec.attribute23
395: ,p_attribute24_o
396: => ota_lpe_shd.g_old_rec.attribute24
397: ,p_attribute25_o
398: => ota_lpe_shd.g_old_rec.attribute25
399: ,p_attribute26_o
400: => ota_lpe_shd.g_old_rec.attribute26
401: ,p_attribute27_o
402: => ota_lpe_shd.g_old_rec.attribute27

Line 400: => ota_lpe_shd.g_old_rec.attribute26

396: => ota_lpe_shd.g_old_rec.attribute24
397: ,p_attribute25_o
398: => ota_lpe_shd.g_old_rec.attribute25
399: ,p_attribute26_o
400: => ota_lpe_shd.g_old_rec.attribute26
401: ,p_attribute27_o
402: => ota_lpe_shd.g_old_rec.attribute27
403: ,p_attribute28_o
404: => ota_lpe_shd.g_old_rec.attribute28

Line 402: => ota_lpe_shd.g_old_rec.attribute27

398: => ota_lpe_shd.g_old_rec.attribute25
399: ,p_attribute26_o
400: => ota_lpe_shd.g_old_rec.attribute26
401: ,p_attribute27_o
402: => ota_lpe_shd.g_old_rec.attribute27
403: ,p_attribute28_o
404: => ota_lpe_shd.g_old_rec.attribute28
405: ,p_attribute29_o
406: => ota_lpe_shd.g_old_rec.attribute29

Line 404: => ota_lpe_shd.g_old_rec.attribute28

400: => ota_lpe_shd.g_old_rec.attribute26
401: ,p_attribute27_o
402: => ota_lpe_shd.g_old_rec.attribute27
403: ,p_attribute28_o
404: => ota_lpe_shd.g_old_rec.attribute28
405: ,p_attribute29_o
406: => ota_lpe_shd.g_old_rec.attribute29
407: ,p_attribute30_o
408: => ota_lpe_shd.g_old_rec.attribute30

Line 406: => ota_lpe_shd.g_old_rec.attribute29

402: => ota_lpe_shd.g_old_rec.attribute27
403: ,p_attribute28_o
404: => ota_lpe_shd.g_old_rec.attribute28
405: ,p_attribute29_o
406: => ota_lpe_shd.g_old_rec.attribute29
407: ,p_attribute30_o
408: => ota_lpe_shd.g_old_rec.attribute30
409: ,p_is_history_flag_o
410: => ota_lpe_shd.g_old_rec.is_history_flag

Line 408: => ota_lpe_shd.g_old_rec.attribute30

404: => ota_lpe_shd.g_old_rec.attribute28
405: ,p_attribute29_o
406: => ota_lpe_shd.g_old_rec.attribute29
407: ,p_attribute30_o
408: => ota_lpe_shd.g_old_rec.attribute30
409: ,p_is_history_flag_o
410: => ota_lpe_shd.g_old_rec.is_history_flag
411: );
412: --

Line 410: => ota_lpe_shd.g_old_rec.is_history_flag

406: => ota_lpe_shd.g_old_rec.attribute29
407: ,p_attribute30_o
408: => ota_lpe_shd.g_old_rec.attribute30
409: ,p_is_history_flag_o
410: => ota_lpe_shd.g_old_rec.is_history_flag
411: );
412: --
413: exception
414: --

Line 470: (p_rec in out nocopy ota_lpe_shd.g_rec_type

466: --
467: -- {End Of Comments}
468: -- ----------------------------------------------------------------------------
469: Procedure convert_defs
470: (p_rec in out nocopy ota_lpe_shd.g_rec_type
471: ) is
472: --
473: Begin
474: --

Line 482: ota_lpe_shd.g_old_rec.learning_path_id;

478: -- is being used then we must set to the 'current' argument value.
479: --
480: If (p_rec.learning_path_id = hr_api.g_number) then
481: p_rec.learning_path_id :=
482: ota_lpe_shd.g_old_rec.learning_path_id;
483: End If;
484: If (p_rec.person_id = hr_api.g_number) then
485: p_rec.person_id :=
486: ota_lpe_shd.g_old_rec.person_id;

Line 486: ota_lpe_shd.g_old_rec.person_id;

482: ota_lpe_shd.g_old_rec.learning_path_id;
483: End If;
484: If (p_rec.person_id = hr_api.g_number) then
485: p_rec.person_id :=
486: ota_lpe_shd.g_old_rec.person_id;
487: End If;
488: If (p_rec.contact_id = hr_api.g_number) then
489: p_rec.contact_id :=
490: ota_lpe_shd.g_old_rec.contact_id;

Line 490: ota_lpe_shd.g_old_rec.contact_id;

486: ota_lpe_shd.g_old_rec.person_id;
487: End If;
488: If (p_rec.contact_id = hr_api.g_number) then
489: p_rec.contact_id :=
490: ota_lpe_shd.g_old_rec.contact_id;
491: End If;
492: If (p_rec.path_status_code = hr_api.g_varchar2) then
493: p_rec.path_status_code :=
494: ota_lpe_shd.g_old_rec.path_status_code;

Line 494: ota_lpe_shd.g_old_rec.path_status_code;

490: ota_lpe_shd.g_old_rec.contact_id;
491: End If;
492: If (p_rec.path_status_code = hr_api.g_varchar2) then
493: p_rec.path_status_code :=
494: ota_lpe_shd.g_old_rec.path_status_code;
495: End If;
496: If (p_rec.enrollment_source_code = hr_api.g_varchar2) then
497: p_rec.enrollment_source_code :=
498: ota_lpe_shd.g_old_rec.enrollment_source_code;

Line 498: ota_lpe_shd.g_old_rec.enrollment_source_code;

494: ota_lpe_shd.g_old_rec.path_status_code;
495: End If;
496: If (p_rec.enrollment_source_code = hr_api.g_varchar2) then
497: p_rec.enrollment_source_code :=
498: ota_lpe_shd.g_old_rec.enrollment_source_code;
499: End If;
500: If (p_rec.no_of_mandatory_courses = hr_api.g_number) then
501: p_rec.no_of_mandatory_courses :=
502: ota_lpe_shd.g_old_rec.no_of_mandatory_courses;

Line 502: ota_lpe_shd.g_old_rec.no_of_mandatory_courses;

498: ota_lpe_shd.g_old_rec.enrollment_source_code;
499: End If;
500: If (p_rec.no_of_mandatory_courses = hr_api.g_number) then
501: p_rec.no_of_mandatory_courses :=
502: ota_lpe_shd.g_old_rec.no_of_mandatory_courses;
503: End If;
504: If (p_rec.no_of_completed_courses = hr_api.g_number) then
505: p_rec.no_of_completed_courses :=
506: ota_lpe_shd.g_old_rec.no_of_completed_courses;

Line 506: ota_lpe_shd.g_old_rec.no_of_completed_courses;

502: ota_lpe_shd.g_old_rec.no_of_mandatory_courses;
503: End If;
504: If (p_rec.no_of_completed_courses = hr_api.g_number) then
505: p_rec.no_of_completed_courses :=
506: ota_lpe_shd.g_old_rec.no_of_completed_courses;
507: End If;
508: If (p_rec.completion_target_date = hr_api.g_date) then
509: p_rec.completion_target_date :=
510: ota_lpe_shd.g_old_rec.completion_target_date;

Line 510: ota_lpe_shd.g_old_rec.completion_target_date;

506: ota_lpe_shd.g_old_rec.no_of_completed_courses;
507: End If;
508: If (p_rec.completion_target_date = hr_api.g_date) then
509: p_rec.completion_target_date :=
510: ota_lpe_shd.g_old_rec.completion_target_date;
511: End If;
512: If (p_rec.completion_date = hr_api.g_date) then
513: p_rec.completion_date :=
514: ota_lpe_shd.g_old_rec.completion_date;

Line 514: ota_lpe_shd.g_old_rec.completion_date;

510: ota_lpe_shd.g_old_rec.completion_target_date;
511: End If;
512: If (p_rec.completion_date = hr_api.g_date) then
513: p_rec.completion_date :=
514: ota_lpe_shd.g_old_rec.completion_date;
515: End If;
516: If (p_rec.creator_person_id = hr_api.g_number) then
517: p_rec.creator_person_id :=
518: ota_lpe_shd.g_old_rec.creator_person_id;

Line 518: ota_lpe_shd.g_old_rec.creator_person_id;

514: ota_lpe_shd.g_old_rec.completion_date;
515: End If;
516: If (p_rec.creator_person_id = hr_api.g_number) then
517: p_rec.creator_person_id :=
518: ota_lpe_shd.g_old_rec.creator_person_id;
519: End If;
520: If (p_rec.business_group_id = hr_api.g_number) then
521: p_rec.business_group_id :=
522: ota_lpe_shd.g_old_rec.business_group_id;

Line 522: ota_lpe_shd.g_old_rec.business_group_id;

518: ota_lpe_shd.g_old_rec.creator_person_id;
519: End If;
520: If (p_rec.business_group_id = hr_api.g_number) then
521: p_rec.business_group_id :=
522: ota_lpe_shd.g_old_rec.business_group_id;
523: End If;
524: If (p_rec.attribute_category = hr_api.g_varchar2) then
525: p_rec.attribute_category :=
526: ota_lpe_shd.g_old_rec.attribute_category;

Line 526: ota_lpe_shd.g_old_rec.attribute_category;

522: ota_lpe_shd.g_old_rec.business_group_id;
523: End If;
524: If (p_rec.attribute_category = hr_api.g_varchar2) then
525: p_rec.attribute_category :=
526: ota_lpe_shd.g_old_rec.attribute_category;
527: End If;
528: If (p_rec.attribute1 = hr_api.g_varchar2) then
529: p_rec.attribute1 :=
530: ota_lpe_shd.g_old_rec.attribute1;

Line 530: ota_lpe_shd.g_old_rec.attribute1;

526: ota_lpe_shd.g_old_rec.attribute_category;
527: End If;
528: If (p_rec.attribute1 = hr_api.g_varchar2) then
529: p_rec.attribute1 :=
530: ota_lpe_shd.g_old_rec.attribute1;
531: End If;
532: If (p_rec.attribute2 = hr_api.g_varchar2) then
533: p_rec.attribute2 :=
534: ota_lpe_shd.g_old_rec.attribute2;

Line 534: ota_lpe_shd.g_old_rec.attribute2;

530: ota_lpe_shd.g_old_rec.attribute1;
531: End If;
532: If (p_rec.attribute2 = hr_api.g_varchar2) then
533: p_rec.attribute2 :=
534: ota_lpe_shd.g_old_rec.attribute2;
535: End If;
536: If (p_rec.attribute3 = hr_api.g_varchar2) then
537: p_rec.attribute3 :=
538: ota_lpe_shd.g_old_rec.attribute3;

Line 538: ota_lpe_shd.g_old_rec.attribute3;

534: ota_lpe_shd.g_old_rec.attribute2;
535: End If;
536: If (p_rec.attribute3 = hr_api.g_varchar2) then
537: p_rec.attribute3 :=
538: ota_lpe_shd.g_old_rec.attribute3;
539: End If;
540: If (p_rec.attribute4 = hr_api.g_varchar2) then
541: p_rec.attribute4 :=
542: ota_lpe_shd.g_old_rec.attribute4;

Line 542: ota_lpe_shd.g_old_rec.attribute4;

538: ota_lpe_shd.g_old_rec.attribute3;
539: End If;
540: If (p_rec.attribute4 = hr_api.g_varchar2) then
541: p_rec.attribute4 :=
542: ota_lpe_shd.g_old_rec.attribute4;
543: End If;
544: If (p_rec.attribute5 = hr_api.g_varchar2) then
545: p_rec.attribute5 :=
546: ota_lpe_shd.g_old_rec.attribute5;

Line 546: ota_lpe_shd.g_old_rec.attribute5;

542: ota_lpe_shd.g_old_rec.attribute4;
543: End If;
544: If (p_rec.attribute5 = hr_api.g_varchar2) then
545: p_rec.attribute5 :=
546: ota_lpe_shd.g_old_rec.attribute5;
547: End If;
548: If (p_rec.attribute6 = hr_api.g_varchar2) then
549: p_rec.attribute6 :=
550: ota_lpe_shd.g_old_rec.attribute6;

Line 550: ota_lpe_shd.g_old_rec.attribute6;

546: ota_lpe_shd.g_old_rec.attribute5;
547: End If;
548: If (p_rec.attribute6 = hr_api.g_varchar2) then
549: p_rec.attribute6 :=
550: ota_lpe_shd.g_old_rec.attribute6;
551: End If;
552: If (p_rec.attribute7 = hr_api.g_varchar2) then
553: p_rec.attribute7 :=
554: ota_lpe_shd.g_old_rec.attribute7;

Line 554: ota_lpe_shd.g_old_rec.attribute7;

550: ota_lpe_shd.g_old_rec.attribute6;
551: End If;
552: If (p_rec.attribute7 = hr_api.g_varchar2) then
553: p_rec.attribute7 :=
554: ota_lpe_shd.g_old_rec.attribute7;
555: End If;
556: If (p_rec.attribute8 = hr_api.g_varchar2) then
557: p_rec.attribute8 :=
558: ota_lpe_shd.g_old_rec.attribute8;

Line 558: ota_lpe_shd.g_old_rec.attribute8;

554: ota_lpe_shd.g_old_rec.attribute7;
555: End If;
556: If (p_rec.attribute8 = hr_api.g_varchar2) then
557: p_rec.attribute8 :=
558: ota_lpe_shd.g_old_rec.attribute8;
559: End If;
560: If (p_rec.attribute9 = hr_api.g_varchar2) then
561: p_rec.attribute9 :=
562: ota_lpe_shd.g_old_rec.attribute9;

Line 562: ota_lpe_shd.g_old_rec.attribute9;

558: ota_lpe_shd.g_old_rec.attribute8;
559: End If;
560: If (p_rec.attribute9 = hr_api.g_varchar2) then
561: p_rec.attribute9 :=
562: ota_lpe_shd.g_old_rec.attribute9;
563: End If;
564: If (p_rec.attribute10 = hr_api.g_varchar2) then
565: p_rec.attribute10 :=
566: ota_lpe_shd.g_old_rec.attribute10;

Line 566: ota_lpe_shd.g_old_rec.attribute10;

562: ota_lpe_shd.g_old_rec.attribute9;
563: End If;
564: If (p_rec.attribute10 = hr_api.g_varchar2) then
565: p_rec.attribute10 :=
566: ota_lpe_shd.g_old_rec.attribute10;
567: End If;
568: If (p_rec.attribute11 = hr_api.g_varchar2) then
569: p_rec.attribute11 :=
570: ota_lpe_shd.g_old_rec.attribute11;

Line 570: ota_lpe_shd.g_old_rec.attribute11;

566: ota_lpe_shd.g_old_rec.attribute10;
567: End If;
568: If (p_rec.attribute11 = hr_api.g_varchar2) then
569: p_rec.attribute11 :=
570: ota_lpe_shd.g_old_rec.attribute11;
571: End If;
572: If (p_rec.attribute12 = hr_api.g_varchar2) then
573: p_rec.attribute12 :=
574: ota_lpe_shd.g_old_rec.attribute12;

Line 574: ota_lpe_shd.g_old_rec.attribute12;

570: ota_lpe_shd.g_old_rec.attribute11;
571: End If;
572: If (p_rec.attribute12 = hr_api.g_varchar2) then
573: p_rec.attribute12 :=
574: ota_lpe_shd.g_old_rec.attribute12;
575: End If;
576: If (p_rec.attribute13 = hr_api.g_varchar2) then
577: p_rec.attribute13 :=
578: ota_lpe_shd.g_old_rec.attribute13;

Line 578: ota_lpe_shd.g_old_rec.attribute13;

574: ota_lpe_shd.g_old_rec.attribute12;
575: End If;
576: If (p_rec.attribute13 = hr_api.g_varchar2) then
577: p_rec.attribute13 :=
578: ota_lpe_shd.g_old_rec.attribute13;
579: End If;
580: If (p_rec.attribute14 = hr_api.g_varchar2) then
581: p_rec.attribute14 :=
582: ota_lpe_shd.g_old_rec.attribute14;

Line 582: ota_lpe_shd.g_old_rec.attribute14;

578: ota_lpe_shd.g_old_rec.attribute13;
579: End If;
580: If (p_rec.attribute14 = hr_api.g_varchar2) then
581: p_rec.attribute14 :=
582: ota_lpe_shd.g_old_rec.attribute14;
583: End If;
584: If (p_rec.attribute15 = hr_api.g_varchar2) then
585: p_rec.attribute15 :=
586: ota_lpe_shd.g_old_rec.attribute15;

Line 586: ota_lpe_shd.g_old_rec.attribute15;

582: ota_lpe_shd.g_old_rec.attribute14;
583: End If;
584: If (p_rec.attribute15 = hr_api.g_varchar2) then
585: p_rec.attribute15 :=
586: ota_lpe_shd.g_old_rec.attribute15;
587: End If;
588: If (p_rec.attribute16 = hr_api.g_varchar2) then
589: p_rec.attribute16 :=
590: ota_lpe_shd.g_old_rec.attribute16;

Line 590: ota_lpe_shd.g_old_rec.attribute16;

586: ota_lpe_shd.g_old_rec.attribute15;
587: End If;
588: If (p_rec.attribute16 = hr_api.g_varchar2) then
589: p_rec.attribute16 :=
590: ota_lpe_shd.g_old_rec.attribute16;
591: End If;
592: If (p_rec.attribute17 = hr_api.g_varchar2) then
593: p_rec.attribute17 :=
594: ota_lpe_shd.g_old_rec.attribute17;

Line 594: ota_lpe_shd.g_old_rec.attribute17;

590: ota_lpe_shd.g_old_rec.attribute16;
591: End If;
592: If (p_rec.attribute17 = hr_api.g_varchar2) then
593: p_rec.attribute17 :=
594: ota_lpe_shd.g_old_rec.attribute17;
595: End If;
596: If (p_rec.attribute18 = hr_api.g_varchar2) then
597: p_rec.attribute18 :=
598: ota_lpe_shd.g_old_rec.attribute18;

Line 598: ota_lpe_shd.g_old_rec.attribute18;

594: ota_lpe_shd.g_old_rec.attribute17;
595: End If;
596: If (p_rec.attribute18 = hr_api.g_varchar2) then
597: p_rec.attribute18 :=
598: ota_lpe_shd.g_old_rec.attribute18;
599: End If;
600: If (p_rec.attribute19 = hr_api.g_varchar2) then
601: p_rec.attribute19 :=
602: ota_lpe_shd.g_old_rec.attribute19;

Line 602: ota_lpe_shd.g_old_rec.attribute19;

598: ota_lpe_shd.g_old_rec.attribute18;
599: End If;
600: If (p_rec.attribute19 = hr_api.g_varchar2) then
601: p_rec.attribute19 :=
602: ota_lpe_shd.g_old_rec.attribute19;
603: End If;
604: If (p_rec.attribute20 = hr_api.g_varchar2) then
605: p_rec.attribute20 :=
606: ota_lpe_shd.g_old_rec.attribute20;

Line 606: ota_lpe_shd.g_old_rec.attribute20;

602: ota_lpe_shd.g_old_rec.attribute19;
603: End If;
604: If (p_rec.attribute20 = hr_api.g_varchar2) then
605: p_rec.attribute20 :=
606: ota_lpe_shd.g_old_rec.attribute20;
607: End If;
608: If (p_rec.attribute21 = hr_api.g_varchar2) then
609: p_rec.attribute21 :=
610: ota_lpe_shd.g_old_rec.attribute21;

Line 610: ota_lpe_shd.g_old_rec.attribute21;

606: ota_lpe_shd.g_old_rec.attribute20;
607: End If;
608: If (p_rec.attribute21 = hr_api.g_varchar2) then
609: p_rec.attribute21 :=
610: ota_lpe_shd.g_old_rec.attribute21;
611: End If;
612: If (p_rec.attribute22 = hr_api.g_varchar2) then
613: p_rec.attribute22 :=
614: ota_lpe_shd.g_old_rec.attribute22;

Line 614: ota_lpe_shd.g_old_rec.attribute22;

610: ota_lpe_shd.g_old_rec.attribute21;
611: End If;
612: If (p_rec.attribute22 = hr_api.g_varchar2) then
613: p_rec.attribute22 :=
614: ota_lpe_shd.g_old_rec.attribute22;
615: End If;
616: If (p_rec.attribute23 = hr_api.g_varchar2) then
617: p_rec.attribute23 :=
618: ota_lpe_shd.g_old_rec.attribute23;

Line 618: ota_lpe_shd.g_old_rec.attribute23;

614: ota_lpe_shd.g_old_rec.attribute22;
615: End If;
616: If (p_rec.attribute23 = hr_api.g_varchar2) then
617: p_rec.attribute23 :=
618: ota_lpe_shd.g_old_rec.attribute23;
619: End If;
620: If (p_rec.attribute24 = hr_api.g_varchar2) then
621: p_rec.attribute24 :=
622: ota_lpe_shd.g_old_rec.attribute24;

Line 622: ota_lpe_shd.g_old_rec.attribute24;

618: ota_lpe_shd.g_old_rec.attribute23;
619: End If;
620: If (p_rec.attribute24 = hr_api.g_varchar2) then
621: p_rec.attribute24 :=
622: ota_lpe_shd.g_old_rec.attribute24;
623: End If;
624: If (p_rec.attribute25 = hr_api.g_varchar2) then
625: p_rec.attribute25 :=
626: ota_lpe_shd.g_old_rec.attribute25;

Line 626: ota_lpe_shd.g_old_rec.attribute25;

622: ota_lpe_shd.g_old_rec.attribute24;
623: End If;
624: If (p_rec.attribute25 = hr_api.g_varchar2) then
625: p_rec.attribute25 :=
626: ota_lpe_shd.g_old_rec.attribute25;
627: End If;
628: If (p_rec.attribute26 = hr_api.g_varchar2) then
629: p_rec.attribute26 :=
630: ota_lpe_shd.g_old_rec.attribute26;

Line 630: ota_lpe_shd.g_old_rec.attribute26;

626: ota_lpe_shd.g_old_rec.attribute25;
627: End If;
628: If (p_rec.attribute26 = hr_api.g_varchar2) then
629: p_rec.attribute26 :=
630: ota_lpe_shd.g_old_rec.attribute26;
631: End If;
632: If (p_rec.attribute27 = hr_api.g_varchar2) then
633: p_rec.attribute27 :=
634: ota_lpe_shd.g_old_rec.attribute27;

Line 634: ota_lpe_shd.g_old_rec.attribute27;

630: ota_lpe_shd.g_old_rec.attribute26;
631: End If;
632: If (p_rec.attribute27 = hr_api.g_varchar2) then
633: p_rec.attribute27 :=
634: ota_lpe_shd.g_old_rec.attribute27;
635: End If;
636: If (p_rec.attribute28 = hr_api.g_varchar2) then
637: p_rec.attribute28 :=
638: ota_lpe_shd.g_old_rec.attribute28;

Line 638: ota_lpe_shd.g_old_rec.attribute28;

634: ota_lpe_shd.g_old_rec.attribute27;
635: End If;
636: If (p_rec.attribute28 = hr_api.g_varchar2) then
637: p_rec.attribute28 :=
638: ota_lpe_shd.g_old_rec.attribute28;
639: End If;
640: If (p_rec.attribute29 = hr_api.g_varchar2) then
641: p_rec.attribute29 :=
642: ota_lpe_shd.g_old_rec.attribute29;

Line 642: ota_lpe_shd.g_old_rec.attribute29;

638: ota_lpe_shd.g_old_rec.attribute28;
639: End If;
640: If (p_rec.attribute29 = hr_api.g_varchar2) then
641: p_rec.attribute29 :=
642: ota_lpe_shd.g_old_rec.attribute29;
643: End If;
644: If (p_rec.attribute30 = hr_api.g_varchar2) then
645: p_rec.attribute30 :=
646: ota_lpe_shd.g_old_rec.attribute30;

Line 646: ota_lpe_shd.g_old_rec.attribute30;

642: ota_lpe_shd.g_old_rec.attribute29;
643: End If;
644: If (p_rec.attribute30 = hr_api.g_varchar2) then
645: p_rec.attribute30 :=
646: ota_lpe_shd.g_old_rec.attribute30;
647: End If;
648: If (p_rec.is_history_flag = hr_api.g_varchar2) then
649: p_rec.is_history_flag :=
650: ota_lpe_shd.g_old_rec.is_history_flag;

Line 650: ota_lpe_shd.g_old_rec.is_history_flag;

646: ota_lpe_shd.g_old_rec.attribute30;
647: End If;
648: If (p_rec.is_history_flag = hr_api.g_varchar2) then
649: p_rec.is_history_flag :=
650: ota_lpe_shd.g_old_rec.is_history_flag;
651: End If;
652: --
653: End convert_defs;
654: --

Line 660: ,p_rec in out nocopy ota_lpe_shd.g_rec_type

656: -- |---------------------------------< upd >----------------------------------|
657: -- ----------------------------------------------------------------------------
658: Procedure upd
659: (p_effective_date in date
660: ,p_rec in out nocopy ota_lpe_shd.g_rec_type
661: ) is
662: --
663: l_proc varchar2(72) := g_package||'upd';
664: --

Line 670: ota_lpe_shd.lck

666: hr_utility.set_location('Entering:'||l_proc, 5);
667: --
668: -- We must lock the row which we need to update.
669: --
670: ota_lpe_shd.lck
671: (p_rec.lp_enrollment_id
672: ,p_rec.object_version_number
673: );
674: --

Line 761: l_rec ota_lpe_shd.g_rec_type;

757: ,p_attribute30 in varchar2 default hr_api.g_varchar2
758: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
759: ) is
760: --
761: l_rec ota_lpe_shd.g_rec_type;
762: l_proc varchar2(72) := g_package||'upd';
763: --
764: Begin
765: hr_utility.set_location('Entering:'||l_proc, 5);

Line 771: ota_lpe_shd.convert_args

767: -- Call conversion function to turn arguments into the
768: -- l_rec structure.
769: --
770: l_rec :=
771: ota_lpe_shd.convert_args
772: (p_lp_enrollment_id
773: ,p_learning_path_id
774: ,p_person_id
775: ,p_contact_id