[Home] [Help]
52: --
53: -- {End Of Comments}
54: -- ----------------------------------------------------------------------------
55: Procedure update_dml
56: (p_rec in out nocopy ota_lpm_shd.g_rec_type
57: ) is
58: --
59: l_proc varchar2(72) := g_package||'update_dml';
60: --
110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: --
114: ota_lpm_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: --
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: --
119: ota_lpm_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: --
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: --
124: ota_lpm_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When Others Then
127: --
128: Raise;
160: --
161: -- {End Of Comments}
162: -- ----------------------------------------------------------------------------
163: Procedure pre_update
164: (p_rec in ota_lpm_shd.g_rec_type
165: ) is
166: --
167: l_proc varchar2(72) := g_package||'pre_update';
168: --
205: -- {End Of Comments}
206: -- ----------------------------------------------------------------------------
207: Procedure post_update
208: (p_effective_date in date
209: ,p_rec in ota_lpm_shd.g_rec_type
210: ) is
211: --
212: l_proc varchar2(72) := g_package||'post_update';
213: --
279: => p_rec.learning_path_section_id
280: ,p_notify_days_before_target
281: => p_rec.notify_days_before_target
282: ,p_learning_path_id_o
283: => ota_lpm_shd.g_old_rec.learning_path_id
284: ,p_activity_version_id_o
285: => ota_lpm_shd.g_old_rec.activity_version_id
286: ,p_course_sequence_o
287: => ota_lpm_shd.g_old_rec.course_sequence
281: => p_rec.notify_days_before_target
282: ,p_learning_path_id_o
283: => ota_lpm_shd.g_old_rec.learning_path_id
284: ,p_activity_version_id_o
285: => ota_lpm_shd.g_old_rec.activity_version_id
286: ,p_course_sequence_o
287: => ota_lpm_shd.g_old_rec.course_sequence
288: ,p_business_group_id_o
289: => ota_lpm_shd.g_old_rec.business_group_id
283: => ota_lpm_shd.g_old_rec.learning_path_id
284: ,p_activity_version_id_o
285: => ota_lpm_shd.g_old_rec.activity_version_id
286: ,p_course_sequence_o
287: => ota_lpm_shd.g_old_rec.course_sequence
288: ,p_business_group_id_o
289: => ota_lpm_shd.g_old_rec.business_group_id
290: ,p_duration_o
291: => ota_lpm_shd.g_old_rec.duration
285: => ota_lpm_shd.g_old_rec.activity_version_id
286: ,p_course_sequence_o
287: => ota_lpm_shd.g_old_rec.course_sequence
288: ,p_business_group_id_o
289: => ota_lpm_shd.g_old_rec.business_group_id
290: ,p_duration_o
291: => ota_lpm_shd.g_old_rec.duration
292: ,p_duration_units_o
293: => ota_lpm_shd.g_old_rec.duration_units
287: => ota_lpm_shd.g_old_rec.course_sequence
288: ,p_business_group_id_o
289: => ota_lpm_shd.g_old_rec.business_group_id
290: ,p_duration_o
291: => ota_lpm_shd.g_old_rec.duration
292: ,p_duration_units_o
293: => ota_lpm_shd.g_old_rec.duration_units
294: ,p_object_version_number_o
295: => ota_lpm_shd.g_old_rec.object_version_number
289: => ota_lpm_shd.g_old_rec.business_group_id
290: ,p_duration_o
291: => ota_lpm_shd.g_old_rec.duration
292: ,p_duration_units_o
293: => ota_lpm_shd.g_old_rec.duration_units
294: ,p_object_version_number_o
295: => ota_lpm_shd.g_old_rec.object_version_number
296: ,p_attribute_category_o
297: => ota_lpm_shd.g_old_rec.attribute_category
291: => ota_lpm_shd.g_old_rec.duration
292: ,p_duration_units_o
293: => ota_lpm_shd.g_old_rec.duration_units
294: ,p_object_version_number_o
295: => ota_lpm_shd.g_old_rec.object_version_number
296: ,p_attribute_category_o
297: => ota_lpm_shd.g_old_rec.attribute_category
298: ,p_attribute1_o
299: => ota_lpm_shd.g_old_rec.attribute1
293: => ota_lpm_shd.g_old_rec.duration_units
294: ,p_object_version_number_o
295: => ota_lpm_shd.g_old_rec.object_version_number
296: ,p_attribute_category_o
297: => ota_lpm_shd.g_old_rec.attribute_category
298: ,p_attribute1_o
299: => ota_lpm_shd.g_old_rec.attribute1
300: ,p_attribute2_o
301: => ota_lpm_shd.g_old_rec.attribute2
295: => ota_lpm_shd.g_old_rec.object_version_number
296: ,p_attribute_category_o
297: => ota_lpm_shd.g_old_rec.attribute_category
298: ,p_attribute1_o
299: => ota_lpm_shd.g_old_rec.attribute1
300: ,p_attribute2_o
301: => ota_lpm_shd.g_old_rec.attribute2
302: ,p_attribute3_o
303: => ota_lpm_shd.g_old_rec.attribute3
297: => ota_lpm_shd.g_old_rec.attribute_category
298: ,p_attribute1_o
299: => ota_lpm_shd.g_old_rec.attribute1
300: ,p_attribute2_o
301: => ota_lpm_shd.g_old_rec.attribute2
302: ,p_attribute3_o
303: => ota_lpm_shd.g_old_rec.attribute3
304: ,p_attribute4_o
305: => ota_lpm_shd.g_old_rec.attribute4
299: => ota_lpm_shd.g_old_rec.attribute1
300: ,p_attribute2_o
301: => ota_lpm_shd.g_old_rec.attribute2
302: ,p_attribute3_o
303: => ota_lpm_shd.g_old_rec.attribute3
304: ,p_attribute4_o
305: => ota_lpm_shd.g_old_rec.attribute4
306: ,p_attribute5_o
307: => ota_lpm_shd.g_old_rec.attribute5
301: => ota_lpm_shd.g_old_rec.attribute2
302: ,p_attribute3_o
303: => ota_lpm_shd.g_old_rec.attribute3
304: ,p_attribute4_o
305: => ota_lpm_shd.g_old_rec.attribute4
306: ,p_attribute5_o
307: => ota_lpm_shd.g_old_rec.attribute5
308: ,p_attribute6_o
309: => ota_lpm_shd.g_old_rec.attribute6
303: => ota_lpm_shd.g_old_rec.attribute3
304: ,p_attribute4_o
305: => ota_lpm_shd.g_old_rec.attribute4
306: ,p_attribute5_o
307: => ota_lpm_shd.g_old_rec.attribute5
308: ,p_attribute6_o
309: => ota_lpm_shd.g_old_rec.attribute6
310: ,p_attribute7_o
311: => ota_lpm_shd.g_old_rec.attribute7
305: => ota_lpm_shd.g_old_rec.attribute4
306: ,p_attribute5_o
307: => ota_lpm_shd.g_old_rec.attribute5
308: ,p_attribute6_o
309: => ota_lpm_shd.g_old_rec.attribute6
310: ,p_attribute7_o
311: => ota_lpm_shd.g_old_rec.attribute7
312: ,p_attribute8_o
313: => ota_lpm_shd.g_old_rec.attribute8
307: => ota_lpm_shd.g_old_rec.attribute5
308: ,p_attribute6_o
309: => ota_lpm_shd.g_old_rec.attribute6
310: ,p_attribute7_o
311: => ota_lpm_shd.g_old_rec.attribute7
312: ,p_attribute8_o
313: => ota_lpm_shd.g_old_rec.attribute8
314: ,p_attribute9_o
315: => ota_lpm_shd.g_old_rec.attribute9
309: => ota_lpm_shd.g_old_rec.attribute6
310: ,p_attribute7_o
311: => ota_lpm_shd.g_old_rec.attribute7
312: ,p_attribute8_o
313: => ota_lpm_shd.g_old_rec.attribute8
314: ,p_attribute9_o
315: => ota_lpm_shd.g_old_rec.attribute9
316: ,p_attribute10_o
317: => ota_lpm_shd.g_old_rec.attribute10
311: => ota_lpm_shd.g_old_rec.attribute7
312: ,p_attribute8_o
313: => ota_lpm_shd.g_old_rec.attribute8
314: ,p_attribute9_o
315: => ota_lpm_shd.g_old_rec.attribute9
316: ,p_attribute10_o
317: => ota_lpm_shd.g_old_rec.attribute10
318: ,p_attribute11_o
319: => ota_lpm_shd.g_old_rec.attribute11
313: => ota_lpm_shd.g_old_rec.attribute8
314: ,p_attribute9_o
315: => ota_lpm_shd.g_old_rec.attribute9
316: ,p_attribute10_o
317: => ota_lpm_shd.g_old_rec.attribute10
318: ,p_attribute11_o
319: => ota_lpm_shd.g_old_rec.attribute11
320: ,p_attribute12_o
321: => ota_lpm_shd.g_old_rec.attribute12
315: => ota_lpm_shd.g_old_rec.attribute9
316: ,p_attribute10_o
317: => ota_lpm_shd.g_old_rec.attribute10
318: ,p_attribute11_o
319: => ota_lpm_shd.g_old_rec.attribute11
320: ,p_attribute12_o
321: => ota_lpm_shd.g_old_rec.attribute12
322: ,p_attribute13_o
323: => ota_lpm_shd.g_old_rec.attribute13
317: => ota_lpm_shd.g_old_rec.attribute10
318: ,p_attribute11_o
319: => ota_lpm_shd.g_old_rec.attribute11
320: ,p_attribute12_o
321: => ota_lpm_shd.g_old_rec.attribute12
322: ,p_attribute13_o
323: => ota_lpm_shd.g_old_rec.attribute13
324: ,p_attribute14_o
325: => ota_lpm_shd.g_old_rec.attribute14
319: => ota_lpm_shd.g_old_rec.attribute11
320: ,p_attribute12_o
321: => ota_lpm_shd.g_old_rec.attribute12
322: ,p_attribute13_o
323: => ota_lpm_shd.g_old_rec.attribute13
324: ,p_attribute14_o
325: => ota_lpm_shd.g_old_rec.attribute14
326: ,p_attribute15_o
327: => ota_lpm_shd.g_old_rec.attribute15
321: => ota_lpm_shd.g_old_rec.attribute12
322: ,p_attribute13_o
323: => ota_lpm_shd.g_old_rec.attribute13
324: ,p_attribute14_o
325: => ota_lpm_shd.g_old_rec.attribute14
326: ,p_attribute15_o
327: => ota_lpm_shd.g_old_rec.attribute15
328: ,p_attribute16_o
329: => ota_lpm_shd.g_old_rec.attribute16
323: => ota_lpm_shd.g_old_rec.attribute13
324: ,p_attribute14_o
325: => ota_lpm_shd.g_old_rec.attribute14
326: ,p_attribute15_o
327: => ota_lpm_shd.g_old_rec.attribute15
328: ,p_attribute16_o
329: => ota_lpm_shd.g_old_rec.attribute16
330: ,p_attribute17_o
331: => ota_lpm_shd.g_old_rec.attribute17
325: => ota_lpm_shd.g_old_rec.attribute14
326: ,p_attribute15_o
327: => ota_lpm_shd.g_old_rec.attribute15
328: ,p_attribute16_o
329: => ota_lpm_shd.g_old_rec.attribute16
330: ,p_attribute17_o
331: => ota_lpm_shd.g_old_rec.attribute17
332: ,p_attribute18_o
333: => ota_lpm_shd.g_old_rec.attribute18
327: => ota_lpm_shd.g_old_rec.attribute15
328: ,p_attribute16_o
329: => ota_lpm_shd.g_old_rec.attribute16
330: ,p_attribute17_o
331: => ota_lpm_shd.g_old_rec.attribute17
332: ,p_attribute18_o
333: => ota_lpm_shd.g_old_rec.attribute18
334: ,p_attribute19_o
335: => ota_lpm_shd.g_old_rec.attribute19
329: => ota_lpm_shd.g_old_rec.attribute16
330: ,p_attribute17_o
331: => ota_lpm_shd.g_old_rec.attribute17
332: ,p_attribute18_o
333: => ota_lpm_shd.g_old_rec.attribute18
334: ,p_attribute19_o
335: => ota_lpm_shd.g_old_rec.attribute19
336: ,p_attribute20_o
337: => ota_lpm_shd.g_old_rec.attribute20
331: => ota_lpm_shd.g_old_rec.attribute17
332: ,p_attribute18_o
333: => ota_lpm_shd.g_old_rec.attribute18
334: ,p_attribute19_o
335: => ota_lpm_shd.g_old_rec.attribute19
336: ,p_attribute20_o
337: => ota_lpm_shd.g_old_rec.attribute20
338: ,p_learning_path_section_id_o
339: => ota_lpm_shd.g_old_rec.learning_path_section_id
333: => ota_lpm_shd.g_old_rec.attribute18
334: ,p_attribute19_o
335: => ota_lpm_shd.g_old_rec.attribute19
336: ,p_attribute20_o
337: => ota_lpm_shd.g_old_rec.attribute20
338: ,p_learning_path_section_id_o
339: => ota_lpm_shd.g_old_rec.learning_path_section_id
340: ,p_notify_days_before_target_o
341: => ota_lpm_shd.g_old_rec.notify_days_before_target
335: => ota_lpm_shd.g_old_rec.attribute19
336: ,p_attribute20_o
337: => ota_lpm_shd.g_old_rec.attribute20
338: ,p_learning_path_section_id_o
339: => ota_lpm_shd.g_old_rec.learning_path_section_id
340: ,p_notify_days_before_target_o
341: => ota_lpm_shd.g_old_rec.notify_days_before_target
342: );
343: --
337: => ota_lpm_shd.g_old_rec.attribute20
338: ,p_learning_path_section_id_o
339: => ota_lpm_shd.g_old_rec.learning_path_section_id
340: ,p_notify_days_before_target_o
341: => ota_lpm_shd.g_old_rec.notify_days_before_target
342: );
343: --
344: exception
345: --
397: --
398: -- {End Of Comments}
399: -- ----------------------------------------------------------------------------
400: Procedure convert_defs
401: (p_rec in out nocopy ota_lpm_shd.g_rec_type
402: ) is
403: --
404: Begin
405: --
409: -- is being used then we must set to the 'current' argument value.
410: --
411: If (p_rec.learning_path_id = hr_api.g_number) then
412: p_rec.learning_path_id :=
413: ota_lpm_shd.g_old_rec.learning_path_id;
414: End If;
415: If (p_rec.activity_version_id = hr_api.g_number) then
416: p_rec.activity_version_id :=
417: ota_lpm_shd.g_old_rec.activity_version_id;
413: ota_lpm_shd.g_old_rec.learning_path_id;
414: End If;
415: If (p_rec.activity_version_id = hr_api.g_number) then
416: p_rec.activity_version_id :=
417: ota_lpm_shd.g_old_rec.activity_version_id;
418: End If;
419: If (p_rec.course_sequence = hr_api.g_number) then
420: p_rec.course_sequence :=
421: ota_lpm_shd.g_old_rec.course_sequence;
417: ota_lpm_shd.g_old_rec.activity_version_id;
418: End If;
419: If (p_rec.course_sequence = hr_api.g_number) then
420: p_rec.course_sequence :=
421: ota_lpm_shd.g_old_rec.course_sequence;
422: End If;
423: If (p_rec.business_group_id = hr_api.g_number) then
424: p_rec.business_group_id :=
425: ota_lpm_shd.g_old_rec.business_group_id;
421: ota_lpm_shd.g_old_rec.course_sequence;
422: End If;
423: If (p_rec.business_group_id = hr_api.g_number) then
424: p_rec.business_group_id :=
425: ota_lpm_shd.g_old_rec.business_group_id;
426: End If;
427: If (p_rec.duration = hr_api.g_number) then
428: p_rec.duration :=
429: ota_lpm_shd.g_old_rec.duration;
425: ota_lpm_shd.g_old_rec.business_group_id;
426: End If;
427: If (p_rec.duration = hr_api.g_number) then
428: p_rec.duration :=
429: ota_lpm_shd.g_old_rec.duration;
430: End If;
431: If (p_rec.duration_units = hr_api.g_varchar2) then
432: p_rec.duration_units :=
433: ota_lpm_shd.g_old_rec.duration_units;
429: ota_lpm_shd.g_old_rec.duration;
430: End If;
431: If (p_rec.duration_units = hr_api.g_varchar2) then
432: p_rec.duration_units :=
433: ota_lpm_shd.g_old_rec.duration_units;
434: End If;
435: If (p_rec.attribute_category = hr_api.g_varchar2) then
436: p_rec.attribute_category :=
437: ota_lpm_shd.g_old_rec.attribute_category;
433: ota_lpm_shd.g_old_rec.duration_units;
434: End If;
435: If (p_rec.attribute_category = hr_api.g_varchar2) then
436: p_rec.attribute_category :=
437: ota_lpm_shd.g_old_rec.attribute_category;
438: End If;
439: If (p_rec.attribute1 = hr_api.g_varchar2) then
440: p_rec.attribute1 :=
441: ota_lpm_shd.g_old_rec.attribute1;
437: ota_lpm_shd.g_old_rec.attribute_category;
438: End If;
439: If (p_rec.attribute1 = hr_api.g_varchar2) then
440: p_rec.attribute1 :=
441: ota_lpm_shd.g_old_rec.attribute1;
442: End If;
443: If (p_rec.attribute2 = hr_api.g_varchar2) then
444: p_rec.attribute2 :=
445: ota_lpm_shd.g_old_rec.attribute2;
441: ota_lpm_shd.g_old_rec.attribute1;
442: End If;
443: If (p_rec.attribute2 = hr_api.g_varchar2) then
444: p_rec.attribute2 :=
445: ota_lpm_shd.g_old_rec.attribute2;
446: End If;
447: If (p_rec.attribute3 = hr_api.g_varchar2) then
448: p_rec.attribute3 :=
449: ota_lpm_shd.g_old_rec.attribute3;
445: ota_lpm_shd.g_old_rec.attribute2;
446: End If;
447: If (p_rec.attribute3 = hr_api.g_varchar2) then
448: p_rec.attribute3 :=
449: ota_lpm_shd.g_old_rec.attribute3;
450: End If;
451: If (p_rec.attribute4 = hr_api.g_varchar2) then
452: p_rec.attribute4 :=
453: ota_lpm_shd.g_old_rec.attribute4;
449: ota_lpm_shd.g_old_rec.attribute3;
450: End If;
451: If (p_rec.attribute4 = hr_api.g_varchar2) then
452: p_rec.attribute4 :=
453: ota_lpm_shd.g_old_rec.attribute4;
454: End If;
455: If (p_rec.attribute5 = hr_api.g_varchar2) then
456: p_rec.attribute5 :=
457: ota_lpm_shd.g_old_rec.attribute5;
453: ota_lpm_shd.g_old_rec.attribute4;
454: End If;
455: If (p_rec.attribute5 = hr_api.g_varchar2) then
456: p_rec.attribute5 :=
457: ota_lpm_shd.g_old_rec.attribute5;
458: End If;
459: If (p_rec.attribute6 = hr_api.g_varchar2) then
460: p_rec.attribute6 :=
461: ota_lpm_shd.g_old_rec.attribute6;
457: ota_lpm_shd.g_old_rec.attribute5;
458: End If;
459: If (p_rec.attribute6 = hr_api.g_varchar2) then
460: p_rec.attribute6 :=
461: ota_lpm_shd.g_old_rec.attribute6;
462: End If;
463: If (p_rec.attribute7 = hr_api.g_varchar2) then
464: p_rec.attribute7 :=
465: ota_lpm_shd.g_old_rec.attribute7;
461: ota_lpm_shd.g_old_rec.attribute6;
462: End If;
463: If (p_rec.attribute7 = hr_api.g_varchar2) then
464: p_rec.attribute7 :=
465: ota_lpm_shd.g_old_rec.attribute7;
466: End If;
467: If (p_rec.attribute8 = hr_api.g_varchar2) then
468: p_rec.attribute8 :=
469: ota_lpm_shd.g_old_rec.attribute8;
465: ota_lpm_shd.g_old_rec.attribute7;
466: End If;
467: If (p_rec.attribute8 = hr_api.g_varchar2) then
468: p_rec.attribute8 :=
469: ota_lpm_shd.g_old_rec.attribute8;
470: End If;
471: If (p_rec.attribute9 = hr_api.g_varchar2) then
472: p_rec.attribute9 :=
473: ota_lpm_shd.g_old_rec.attribute9;
469: ota_lpm_shd.g_old_rec.attribute8;
470: End If;
471: If (p_rec.attribute9 = hr_api.g_varchar2) then
472: p_rec.attribute9 :=
473: ota_lpm_shd.g_old_rec.attribute9;
474: End If;
475: If (p_rec.attribute10 = hr_api.g_varchar2) then
476: p_rec.attribute10 :=
477: ota_lpm_shd.g_old_rec.attribute10;
473: ota_lpm_shd.g_old_rec.attribute9;
474: End If;
475: If (p_rec.attribute10 = hr_api.g_varchar2) then
476: p_rec.attribute10 :=
477: ota_lpm_shd.g_old_rec.attribute10;
478: End If;
479: If (p_rec.attribute11 = hr_api.g_varchar2) then
480: p_rec.attribute11 :=
481: ota_lpm_shd.g_old_rec.attribute11;
477: ota_lpm_shd.g_old_rec.attribute10;
478: End If;
479: If (p_rec.attribute11 = hr_api.g_varchar2) then
480: p_rec.attribute11 :=
481: ota_lpm_shd.g_old_rec.attribute11;
482: End If;
483: If (p_rec.attribute12 = hr_api.g_varchar2) then
484: p_rec.attribute12 :=
485: ota_lpm_shd.g_old_rec.attribute12;
481: ota_lpm_shd.g_old_rec.attribute11;
482: End If;
483: If (p_rec.attribute12 = hr_api.g_varchar2) then
484: p_rec.attribute12 :=
485: ota_lpm_shd.g_old_rec.attribute12;
486: End If;
487: If (p_rec.attribute13 = hr_api.g_varchar2) then
488: p_rec.attribute13 :=
489: ota_lpm_shd.g_old_rec.attribute13;
485: ota_lpm_shd.g_old_rec.attribute12;
486: End If;
487: If (p_rec.attribute13 = hr_api.g_varchar2) then
488: p_rec.attribute13 :=
489: ota_lpm_shd.g_old_rec.attribute13;
490: End If;
491: If (p_rec.attribute14 = hr_api.g_varchar2) then
492: p_rec.attribute14 :=
493: ota_lpm_shd.g_old_rec.attribute14;
489: ota_lpm_shd.g_old_rec.attribute13;
490: End If;
491: If (p_rec.attribute14 = hr_api.g_varchar2) then
492: p_rec.attribute14 :=
493: ota_lpm_shd.g_old_rec.attribute14;
494: End If;
495: If (p_rec.attribute15 = hr_api.g_varchar2) then
496: p_rec.attribute15 :=
497: ota_lpm_shd.g_old_rec.attribute15;
493: ota_lpm_shd.g_old_rec.attribute14;
494: End If;
495: If (p_rec.attribute15 = hr_api.g_varchar2) then
496: p_rec.attribute15 :=
497: ota_lpm_shd.g_old_rec.attribute15;
498: End If;
499: If (p_rec.attribute16 = hr_api.g_varchar2) then
500: p_rec.attribute16 :=
501: ota_lpm_shd.g_old_rec.attribute16;
497: ota_lpm_shd.g_old_rec.attribute15;
498: End If;
499: If (p_rec.attribute16 = hr_api.g_varchar2) then
500: p_rec.attribute16 :=
501: ota_lpm_shd.g_old_rec.attribute16;
502: End If;
503: If (p_rec.attribute17 = hr_api.g_varchar2) then
504: p_rec.attribute17 :=
505: ota_lpm_shd.g_old_rec.attribute17;
501: ota_lpm_shd.g_old_rec.attribute16;
502: End If;
503: If (p_rec.attribute17 = hr_api.g_varchar2) then
504: p_rec.attribute17 :=
505: ota_lpm_shd.g_old_rec.attribute17;
506: End If;
507: If (p_rec.attribute18 = hr_api.g_varchar2) then
508: p_rec.attribute18 :=
509: ota_lpm_shd.g_old_rec.attribute18;
505: ota_lpm_shd.g_old_rec.attribute17;
506: End If;
507: If (p_rec.attribute18 = hr_api.g_varchar2) then
508: p_rec.attribute18 :=
509: ota_lpm_shd.g_old_rec.attribute18;
510: End If;
511: If (p_rec.attribute19 = hr_api.g_varchar2) then
512: p_rec.attribute19 :=
513: ota_lpm_shd.g_old_rec.attribute19;
509: ota_lpm_shd.g_old_rec.attribute18;
510: End If;
511: If (p_rec.attribute19 = hr_api.g_varchar2) then
512: p_rec.attribute19 :=
513: ota_lpm_shd.g_old_rec.attribute19;
514: End If;
515: If (p_rec.attribute20 = hr_api.g_varchar2) then
516: p_rec.attribute20 :=
517: ota_lpm_shd.g_old_rec.attribute20;
513: ota_lpm_shd.g_old_rec.attribute19;
514: End If;
515: If (p_rec.attribute20 = hr_api.g_varchar2) then
516: p_rec.attribute20 :=
517: ota_lpm_shd.g_old_rec.attribute20;
518: End If;
519: If (p_rec.learning_path_section_id = hr_api.g_number) then
520: p_rec.learning_path_section_id :=
521: ota_lpm_shd.g_old_rec.learning_path_section_id;
517: ota_lpm_shd.g_old_rec.attribute20;
518: End If;
519: If (p_rec.learning_path_section_id = hr_api.g_number) then
520: p_rec.learning_path_section_id :=
521: ota_lpm_shd.g_old_rec.learning_path_section_id;
522: End If;
523: If (p_rec.notify_days_before_target = hr_api.g_number) then
524: p_rec.notify_days_before_target :=
525: ota_lpm_shd.g_old_rec.notify_days_before_target;
521: ota_lpm_shd.g_old_rec.learning_path_section_id;
522: End If;
523: If (p_rec.notify_days_before_target = hr_api.g_number) then
524: p_rec.notify_days_before_target :=
525: ota_lpm_shd.g_old_rec.notify_days_before_target;
526: End If;
527: --
528: End convert_defs;
529: --
531: -- |---------------------------------< upd >----------------------------------|
532: -- ----------------------------------------------------------------------------
533: Procedure upd
534: (p_effective_date in date
535: ,p_rec in out nocopy ota_lpm_shd.g_rec_type
536: ) is
537: --
538: l_proc varchar2(72) := g_package||'upd';
539: --
541: hr_utility.set_location('Entering:'||l_proc, 5);
542: --
543: -- We must lock the row which we need to update.
544: --
545: ota_lpm_shd.lck
546: (p_rec.learning_path_member_id
547: ,p_rec.object_version_number
548: );
549: --
618: ,p_learning_path_section_id in number default hr_api.g_number
619: ,p_notify_days_before_target in number default hr_api.g_number
620: ) is
621: --
622: l_rec ota_lpm_shd.g_rec_type;
623: l_proc varchar2(72) := g_package||'upd';
624: --
625: Begin
626: hr_utility.set_location('Entering:'||l_proc, 5);
628: -- Call conversion function to turn arguments into the
629: -- l_rec structure.
630: --
631: l_rec :=
632: ota_lpm_shd.convert_args
633: (p_learning_path_member_id
634: ,p_learning_path_id
635: ,p_activity_version_id
636: ,p_course_sequence