51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy ota_lps_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
116: Exception
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: --
120: ota_lps_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --
125: ota_lps_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --
130: ota_lps_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: --
134: Raise;
166: --
167: -- {End Of Comments}
168: -- ----------------------------------------------------------------------------
169: Procedure pre_update
170: (p_rec in ota_lps_shd.g_rec_type
171: ) is
172: --
173: l_proc varchar2(72) := g_package||'pre_update';
174: --
211: -- {End Of Comments}
212: -- ----------------------------------------------------------------------------
213: Procedure post_update
214: (p_effective_date in date
215: ,p_rec in ota_lps_shd.g_rec_type
216: ) is
217: --
218: l_proc varchar2(72) := g_package||'post_update';
219: --
299: ,p_public_flag
300: => p_rec.public_flag
301: ,p_competency_update_level => p_rec.competency_update_level
302: ,p_business_group_id_o
303: => ota_lps_shd.g_old_rec.business_group_id
304: ,p_duration_o
305: => ota_lps_shd.g_old_rec.duration
306: ,p_duration_units_o
307: => ota_lps_shd.g_old_rec.duration_units
301: ,p_competency_update_level => p_rec.competency_update_level
302: ,p_business_group_id_o
303: => ota_lps_shd.g_old_rec.business_group_id
304: ,p_duration_o
305: => ota_lps_shd.g_old_rec.duration
306: ,p_duration_units_o
307: => ota_lps_shd.g_old_rec.duration_units
308: ,p_start_date_active_o
309: => ota_lps_shd.g_old_rec.start_date_active
303: => ota_lps_shd.g_old_rec.business_group_id
304: ,p_duration_o
305: => ota_lps_shd.g_old_rec.duration
306: ,p_duration_units_o
307: => ota_lps_shd.g_old_rec.duration_units
308: ,p_start_date_active_o
309: => ota_lps_shd.g_old_rec.start_date_active
310: ,p_end_date_active_o
311: => ota_lps_shd.g_old_rec.end_date_active
305: => ota_lps_shd.g_old_rec.duration
306: ,p_duration_units_o
307: => ota_lps_shd.g_old_rec.duration_units
308: ,p_start_date_active_o
309: => ota_lps_shd.g_old_rec.start_date_active
310: ,p_end_date_active_o
311: => ota_lps_shd.g_old_rec.end_date_active
312: ,p_object_version_number_o
313: => ota_lps_shd.g_old_rec.object_version_number
307: => ota_lps_shd.g_old_rec.duration_units
308: ,p_start_date_active_o
309: => ota_lps_shd.g_old_rec.start_date_active
310: ,p_end_date_active_o
311: => ota_lps_shd.g_old_rec.end_date_active
312: ,p_object_version_number_o
313: => ota_lps_shd.g_old_rec.object_version_number
314: ,p_attribute_category_o
315: => ota_lps_shd.g_old_rec.attribute_category
309: => ota_lps_shd.g_old_rec.start_date_active
310: ,p_end_date_active_o
311: => ota_lps_shd.g_old_rec.end_date_active
312: ,p_object_version_number_o
313: => ota_lps_shd.g_old_rec.object_version_number
314: ,p_attribute_category_o
315: => ota_lps_shd.g_old_rec.attribute_category
316: ,p_attribute1_o
317: => ota_lps_shd.g_old_rec.attribute1
311: => ota_lps_shd.g_old_rec.end_date_active
312: ,p_object_version_number_o
313: => ota_lps_shd.g_old_rec.object_version_number
314: ,p_attribute_category_o
315: => ota_lps_shd.g_old_rec.attribute_category
316: ,p_attribute1_o
317: => ota_lps_shd.g_old_rec.attribute1
318: ,p_attribute2_o
319: => ota_lps_shd.g_old_rec.attribute2
313: => ota_lps_shd.g_old_rec.object_version_number
314: ,p_attribute_category_o
315: => ota_lps_shd.g_old_rec.attribute_category
316: ,p_attribute1_o
317: => ota_lps_shd.g_old_rec.attribute1
318: ,p_attribute2_o
319: => ota_lps_shd.g_old_rec.attribute2
320: ,p_attribute3_o
321: => ota_lps_shd.g_old_rec.attribute3
315: => ota_lps_shd.g_old_rec.attribute_category
316: ,p_attribute1_o
317: => ota_lps_shd.g_old_rec.attribute1
318: ,p_attribute2_o
319: => ota_lps_shd.g_old_rec.attribute2
320: ,p_attribute3_o
321: => ota_lps_shd.g_old_rec.attribute3
322: ,p_attribute4_o
323: => ota_lps_shd.g_old_rec.attribute4
317: => ota_lps_shd.g_old_rec.attribute1
318: ,p_attribute2_o
319: => ota_lps_shd.g_old_rec.attribute2
320: ,p_attribute3_o
321: => ota_lps_shd.g_old_rec.attribute3
322: ,p_attribute4_o
323: => ota_lps_shd.g_old_rec.attribute4
324: ,p_attribute5_o
325: => ota_lps_shd.g_old_rec.attribute5
319: => ota_lps_shd.g_old_rec.attribute2
320: ,p_attribute3_o
321: => ota_lps_shd.g_old_rec.attribute3
322: ,p_attribute4_o
323: => ota_lps_shd.g_old_rec.attribute4
324: ,p_attribute5_o
325: => ota_lps_shd.g_old_rec.attribute5
326: ,p_attribute6_o
327: => ota_lps_shd.g_old_rec.attribute6
321: => ota_lps_shd.g_old_rec.attribute3
322: ,p_attribute4_o
323: => ota_lps_shd.g_old_rec.attribute4
324: ,p_attribute5_o
325: => ota_lps_shd.g_old_rec.attribute5
326: ,p_attribute6_o
327: => ota_lps_shd.g_old_rec.attribute6
328: ,p_attribute7_o
329: => ota_lps_shd.g_old_rec.attribute7
323: => ota_lps_shd.g_old_rec.attribute4
324: ,p_attribute5_o
325: => ota_lps_shd.g_old_rec.attribute5
326: ,p_attribute6_o
327: => ota_lps_shd.g_old_rec.attribute6
328: ,p_attribute7_o
329: => ota_lps_shd.g_old_rec.attribute7
330: ,p_attribute8_o
331: => ota_lps_shd.g_old_rec.attribute8
325: => ota_lps_shd.g_old_rec.attribute5
326: ,p_attribute6_o
327: => ota_lps_shd.g_old_rec.attribute6
328: ,p_attribute7_o
329: => ota_lps_shd.g_old_rec.attribute7
330: ,p_attribute8_o
331: => ota_lps_shd.g_old_rec.attribute8
332: ,p_attribute9_o
333: => ota_lps_shd.g_old_rec.attribute9
327: => ota_lps_shd.g_old_rec.attribute6
328: ,p_attribute7_o
329: => ota_lps_shd.g_old_rec.attribute7
330: ,p_attribute8_o
331: => ota_lps_shd.g_old_rec.attribute8
332: ,p_attribute9_o
333: => ota_lps_shd.g_old_rec.attribute9
334: ,p_attribute10_o
335: => ota_lps_shd.g_old_rec.attribute10
329: => ota_lps_shd.g_old_rec.attribute7
330: ,p_attribute8_o
331: => ota_lps_shd.g_old_rec.attribute8
332: ,p_attribute9_o
333: => ota_lps_shd.g_old_rec.attribute9
334: ,p_attribute10_o
335: => ota_lps_shd.g_old_rec.attribute10
336: ,p_attribute11_o
337: => ota_lps_shd.g_old_rec.attribute11
331: => ota_lps_shd.g_old_rec.attribute8
332: ,p_attribute9_o
333: => ota_lps_shd.g_old_rec.attribute9
334: ,p_attribute10_o
335: => ota_lps_shd.g_old_rec.attribute10
336: ,p_attribute11_o
337: => ota_lps_shd.g_old_rec.attribute11
338: ,p_attribute12_o
339: => ota_lps_shd.g_old_rec.attribute12
333: => ota_lps_shd.g_old_rec.attribute9
334: ,p_attribute10_o
335: => ota_lps_shd.g_old_rec.attribute10
336: ,p_attribute11_o
337: => ota_lps_shd.g_old_rec.attribute11
338: ,p_attribute12_o
339: => ota_lps_shd.g_old_rec.attribute12
340: ,p_attribute13_o
341: => ota_lps_shd.g_old_rec.attribute13
335: => ota_lps_shd.g_old_rec.attribute10
336: ,p_attribute11_o
337: => ota_lps_shd.g_old_rec.attribute11
338: ,p_attribute12_o
339: => ota_lps_shd.g_old_rec.attribute12
340: ,p_attribute13_o
341: => ota_lps_shd.g_old_rec.attribute13
342: ,p_attribute14_o
343: => ota_lps_shd.g_old_rec.attribute14
337: => ota_lps_shd.g_old_rec.attribute11
338: ,p_attribute12_o
339: => ota_lps_shd.g_old_rec.attribute12
340: ,p_attribute13_o
341: => ota_lps_shd.g_old_rec.attribute13
342: ,p_attribute14_o
343: => ota_lps_shd.g_old_rec.attribute14
344: ,p_attribute15_o
345: => ota_lps_shd.g_old_rec.attribute15
339: => ota_lps_shd.g_old_rec.attribute12
340: ,p_attribute13_o
341: => ota_lps_shd.g_old_rec.attribute13
342: ,p_attribute14_o
343: => ota_lps_shd.g_old_rec.attribute14
344: ,p_attribute15_o
345: => ota_lps_shd.g_old_rec.attribute15
346: ,p_attribute16_o
347: => ota_lps_shd.g_old_rec.attribute16
341: => ota_lps_shd.g_old_rec.attribute13
342: ,p_attribute14_o
343: => ota_lps_shd.g_old_rec.attribute14
344: ,p_attribute15_o
345: => ota_lps_shd.g_old_rec.attribute15
346: ,p_attribute16_o
347: => ota_lps_shd.g_old_rec.attribute16
348: ,p_attribute17_o
349: => ota_lps_shd.g_old_rec.attribute17
343: => ota_lps_shd.g_old_rec.attribute14
344: ,p_attribute15_o
345: => ota_lps_shd.g_old_rec.attribute15
346: ,p_attribute16_o
347: => ota_lps_shd.g_old_rec.attribute16
348: ,p_attribute17_o
349: => ota_lps_shd.g_old_rec.attribute17
350: ,p_attribute18_o
351: => ota_lps_shd.g_old_rec.attribute18
345: => ota_lps_shd.g_old_rec.attribute15
346: ,p_attribute16_o
347: => ota_lps_shd.g_old_rec.attribute16
348: ,p_attribute17_o
349: => ota_lps_shd.g_old_rec.attribute17
350: ,p_attribute18_o
351: => ota_lps_shd.g_old_rec.attribute18
352: ,p_attribute19_o
353: => ota_lps_shd.g_old_rec.attribute19
347: => ota_lps_shd.g_old_rec.attribute16
348: ,p_attribute17_o
349: => ota_lps_shd.g_old_rec.attribute17
350: ,p_attribute18_o
351: => ota_lps_shd.g_old_rec.attribute18
352: ,p_attribute19_o
353: => ota_lps_shd.g_old_rec.attribute19
354: ,p_attribute20_o
355: => ota_lps_shd.g_old_rec.attribute20
349: => ota_lps_shd.g_old_rec.attribute17
350: ,p_attribute18_o
351: => ota_lps_shd.g_old_rec.attribute18
352: ,p_attribute19_o
353: => ota_lps_shd.g_old_rec.attribute19
354: ,p_attribute20_o
355: => ota_lps_shd.g_old_rec.attribute20
356: ,p_path_source_code_o
357: => ota_lps_shd.g_old_rec.path_source_code
351: => ota_lps_shd.g_old_rec.attribute18
352: ,p_attribute19_o
353: => ota_lps_shd.g_old_rec.attribute19
354: ,p_attribute20_o
355: => ota_lps_shd.g_old_rec.attribute20
356: ,p_path_source_code_o
357: => ota_lps_shd.g_old_rec.path_source_code
358: ,p_source_function_code_o
359: => ota_lps_shd.g_old_rec.source_function_code
353: => ota_lps_shd.g_old_rec.attribute19
354: ,p_attribute20_o
355: => ota_lps_shd.g_old_rec.attribute20
356: ,p_path_source_code_o
357: => ota_lps_shd.g_old_rec.path_source_code
358: ,p_source_function_code_o
359: => ota_lps_shd.g_old_rec.source_function_code
360: ,p_assignment_id_o
361: => ota_lps_shd.g_old_rec.assignment_id
355: => ota_lps_shd.g_old_rec.attribute20
356: ,p_path_source_code_o
357: => ota_lps_shd.g_old_rec.path_source_code
358: ,p_source_function_code_o
359: => ota_lps_shd.g_old_rec.source_function_code
360: ,p_assignment_id_o
361: => ota_lps_shd.g_old_rec.assignment_id
362: ,p_source_id_o
363: => ota_lps_shd.g_old_rec.source_id
357: => ota_lps_shd.g_old_rec.path_source_code
358: ,p_source_function_code_o
359: => ota_lps_shd.g_old_rec.source_function_code
360: ,p_assignment_id_o
361: => ota_lps_shd.g_old_rec.assignment_id
362: ,p_source_id_o
363: => ota_lps_shd.g_old_rec.source_id
364: ,p_notify_days_before_target_o
365: => ota_lps_shd.g_old_rec.notify_days_before_target
359: => ota_lps_shd.g_old_rec.source_function_code
360: ,p_assignment_id_o
361: => ota_lps_shd.g_old_rec.assignment_id
362: ,p_source_id_o
363: => ota_lps_shd.g_old_rec.source_id
364: ,p_notify_days_before_target_o
365: => ota_lps_shd.g_old_rec.notify_days_before_target
366: ,p_person_id_o
367: => ota_lps_shd.g_old_rec.person_id
361: => ota_lps_shd.g_old_rec.assignment_id
362: ,p_source_id_o
363: => ota_lps_shd.g_old_rec.source_id
364: ,p_notify_days_before_target_o
365: => ota_lps_shd.g_old_rec.notify_days_before_target
366: ,p_person_id_o
367: => ota_lps_shd.g_old_rec.person_id
368: ,p_contact_id_o
369: => ota_lps_shd.g_old_rec.contact_id
363: => ota_lps_shd.g_old_rec.source_id
364: ,p_notify_days_before_target_o
365: => ota_lps_shd.g_old_rec.notify_days_before_target
366: ,p_person_id_o
367: => ota_lps_shd.g_old_rec.person_id
368: ,p_contact_id_o
369: => ota_lps_shd.g_old_rec.contact_id
370: ,p_display_to_learner_flag_o
371: => ota_lps_shd.g_old_rec.display_to_learner_flag
365: => ota_lps_shd.g_old_rec.notify_days_before_target
366: ,p_person_id_o
367: => ota_lps_shd.g_old_rec.person_id
368: ,p_contact_id_o
369: => ota_lps_shd.g_old_rec.contact_id
370: ,p_display_to_learner_flag_o
371: => ota_lps_shd.g_old_rec.display_to_learner_flag
372: ,p_public_flag_o
373: => ota_lps_shd.g_old_rec.public_flag
367: => ota_lps_shd.g_old_rec.person_id
368: ,p_contact_id_o
369: => ota_lps_shd.g_old_rec.contact_id
370: ,p_display_to_learner_flag_o
371: => ota_lps_shd.g_old_rec.display_to_learner_flag
372: ,p_public_flag_o
373: => ota_lps_shd.g_old_rec.public_flag
374: ,p_competency_update_level_o => ota_lps_shd.g_old_rec.competency_update_level
375: );
369: => ota_lps_shd.g_old_rec.contact_id
370: ,p_display_to_learner_flag_o
371: => ota_lps_shd.g_old_rec.display_to_learner_flag
372: ,p_public_flag_o
373: => ota_lps_shd.g_old_rec.public_flag
374: ,p_competency_update_level_o => ota_lps_shd.g_old_rec.competency_update_level
375: );
376:
377:
370: ,p_display_to_learner_flag_o
371: => ota_lps_shd.g_old_rec.display_to_learner_flag
372: ,p_public_flag_o
373: => ota_lps_shd.g_old_rec.public_flag
374: ,p_competency_update_level_o => ota_lps_shd.g_old_rec.competency_update_level
375: );
376:
377:
378: --
433: --
434: -- {End Of Comments}
435: -- ----------------------------------------------------------------------------
436: Procedure convert_defs
437: (p_rec in out nocopy ota_lps_shd.g_rec_type
438: ) is
439: --
440: Begin
441: --
445: -- is being used then we must set to the 'current' argument value.
446: --
447: If (p_rec.business_group_id = hr_api.g_number) then
448: p_rec.business_group_id :=
449: ota_lps_shd.g_old_rec.business_group_id;
450: End If;
451: If (p_rec.duration = hr_api.g_number) then
452: p_rec.duration :=
453: ota_lps_shd.g_old_rec.duration;
449: ota_lps_shd.g_old_rec.business_group_id;
450: End If;
451: If (p_rec.duration = hr_api.g_number) then
452: p_rec.duration :=
453: ota_lps_shd.g_old_rec.duration;
454: End If;
455: If (p_rec.duration_units = hr_api.g_varchar2) then
456: p_rec.duration_units :=
457: ota_lps_shd.g_old_rec.duration_units;
453: ota_lps_shd.g_old_rec.duration;
454: End If;
455: If (p_rec.duration_units = hr_api.g_varchar2) then
456: p_rec.duration_units :=
457: ota_lps_shd.g_old_rec.duration_units;
458: End If;
459: If (p_rec.attribute_category = hr_api.g_varchar2) then
460: p_rec.attribute_category :=
461: ota_lps_shd.g_old_rec.attribute_category;
457: ota_lps_shd.g_old_rec.duration_units;
458: End If;
459: If (p_rec.attribute_category = hr_api.g_varchar2) then
460: p_rec.attribute_category :=
461: ota_lps_shd.g_old_rec.attribute_category;
462: End If;
463: If (p_rec.attribute1 = hr_api.g_varchar2) then
464: p_rec.attribute1 :=
465: ota_lps_shd.g_old_rec.attribute1;
461: ota_lps_shd.g_old_rec.attribute_category;
462: End If;
463: If (p_rec.attribute1 = hr_api.g_varchar2) then
464: p_rec.attribute1 :=
465: ota_lps_shd.g_old_rec.attribute1;
466: End If;
467: If (p_rec.attribute2 = hr_api.g_varchar2) then
468: p_rec.attribute2 :=
469: ota_lps_shd.g_old_rec.attribute2;
465: ota_lps_shd.g_old_rec.attribute1;
466: End If;
467: If (p_rec.attribute2 = hr_api.g_varchar2) then
468: p_rec.attribute2 :=
469: ota_lps_shd.g_old_rec.attribute2;
470: End If;
471: If (p_rec.attribute3 = hr_api.g_varchar2) then
472: p_rec.attribute3 :=
473: ota_lps_shd.g_old_rec.attribute3;
469: ota_lps_shd.g_old_rec.attribute2;
470: End If;
471: If (p_rec.attribute3 = hr_api.g_varchar2) then
472: p_rec.attribute3 :=
473: ota_lps_shd.g_old_rec.attribute3;
474: End If;
475: If (p_rec.attribute4 = hr_api.g_varchar2) then
476: p_rec.attribute4 :=
477: ota_lps_shd.g_old_rec.attribute4;
473: ota_lps_shd.g_old_rec.attribute3;
474: End If;
475: If (p_rec.attribute4 = hr_api.g_varchar2) then
476: p_rec.attribute4 :=
477: ota_lps_shd.g_old_rec.attribute4;
478: End If;
479: If (p_rec.attribute5 = hr_api.g_varchar2) then
480: p_rec.attribute5 :=
481: ota_lps_shd.g_old_rec.attribute5;
477: ota_lps_shd.g_old_rec.attribute4;
478: End If;
479: If (p_rec.attribute5 = hr_api.g_varchar2) then
480: p_rec.attribute5 :=
481: ota_lps_shd.g_old_rec.attribute5;
482: End If;
483: If (p_rec.attribute6 = hr_api.g_varchar2) then
484: p_rec.attribute6 :=
485: ota_lps_shd.g_old_rec.attribute6;
481: ota_lps_shd.g_old_rec.attribute5;
482: End If;
483: If (p_rec.attribute6 = hr_api.g_varchar2) then
484: p_rec.attribute6 :=
485: ota_lps_shd.g_old_rec.attribute6;
486: End If;
487: If (p_rec.attribute7 = hr_api.g_varchar2) then
488: p_rec.attribute7 :=
489: ota_lps_shd.g_old_rec.attribute7;
485: ota_lps_shd.g_old_rec.attribute6;
486: End If;
487: If (p_rec.attribute7 = hr_api.g_varchar2) then
488: p_rec.attribute7 :=
489: ota_lps_shd.g_old_rec.attribute7;
490: End If;
491: If (p_rec.attribute8 = hr_api.g_varchar2) then
492: p_rec.attribute8 :=
493: ota_lps_shd.g_old_rec.attribute8;
489: ota_lps_shd.g_old_rec.attribute7;
490: End If;
491: If (p_rec.attribute8 = hr_api.g_varchar2) then
492: p_rec.attribute8 :=
493: ota_lps_shd.g_old_rec.attribute8;
494: End If;
495: If (p_rec.attribute9 = hr_api.g_varchar2) then
496: p_rec.attribute9 :=
497: ota_lps_shd.g_old_rec.attribute9;
493: ota_lps_shd.g_old_rec.attribute8;
494: End If;
495: If (p_rec.attribute9 = hr_api.g_varchar2) then
496: p_rec.attribute9 :=
497: ota_lps_shd.g_old_rec.attribute9;
498: End If;
499: If (p_rec.attribute10 = hr_api.g_varchar2) then
500: p_rec.attribute10 :=
501: ota_lps_shd.g_old_rec.attribute10;
497: ota_lps_shd.g_old_rec.attribute9;
498: End If;
499: If (p_rec.attribute10 = hr_api.g_varchar2) then
500: p_rec.attribute10 :=
501: ota_lps_shd.g_old_rec.attribute10;
502: End If;
503: If (p_rec.attribute11 = hr_api.g_varchar2) then
504: p_rec.attribute11 :=
505: ota_lps_shd.g_old_rec.attribute11;
501: ota_lps_shd.g_old_rec.attribute10;
502: End If;
503: If (p_rec.attribute11 = hr_api.g_varchar2) then
504: p_rec.attribute11 :=
505: ota_lps_shd.g_old_rec.attribute11;
506: End If;
507: If (p_rec.attribute12 = hr_api.g_varchar2) then
508: p_rec.attribute12 :=
509: ota_lps_shd.g_old_rec.attribute12;
505: ota_lps_shd.g_old_rec.attribute11;
506: End If;
507: If (p_rec.attribute12 = hr_api.g_varchar2) then
508: p_rec.attribute12 :=
509: ota_lps_shd.g_old_rec.attribute12;
510: End If;
511: If (p_rec.attribute13 = hr_api.g_varchar2) then
512: p_rec.attribute13 :=
513: ota_lps_shd.g_old_rec.attribute13;
509: ota_lps_shd.g_old_rec.attribute12;
510: End If;
511: If (p_rec.attribute13 = hr_api.g_varchar2) then
512: p_rec.attribute13 :=
513: ota_lps_shd.g_old_rec.attribute13;
514: End If;
515: If (p_rec.attribute14 = hr_api.g_varchar2) then
516: p_rec.attribute14 :=
517: ota_lps_shd.g_old_rec.attribute14;
513: ota_lps_shd.g_old_rec.attribute13;
514: End If;
515: If (p_rec.attribute14 = hr_api.g_varchar2) then
516: p_rec.attribute14 :=
517: ota_lps_shd.g_old_rec.attribute14;
518: End If;
519: If (p_rec.attribute15 = hr_api.g_varchar2) then
520: p_rec.attribute15 :=
521: ota_lps_shd.g_old_rec.attribute15;
517: ota_lps_shd.g_old_rec.attribute14;
518: End If;
519: If (p_rec.attribute15 = hr_api.g_varchar2) then
520: p_rec.attribute15 :=
521: ota_lps_shd.g_old_rec.attribute15;
522: End If;
523: If (p_rec.attribute16 = hr_api.g_varchar2) then
524: p_rec.attribute16 :=
525: ota_lps_shd.g_old_rec.attribute16;
521: ota_lps_shd.g_old_rec.attribute15;
522: End If;
523: If (p_rec.attribute16 = hr_api.g_varchar2) then
524: p_rec.attribute16 :=
525: ota_lps_shd.g_old_rec.attribute16;
526: End If;
527: If (p_rec.attribute17 = hr_api.g_varchar2) then
528: p_rec.attribute17 :=
529: ota_lps_shd.g_old_rec.attribute17;
525: ota_lps_shd.g_old_rec.attribute16;
526: End If;
527: If (p_rec.attribute17 = hr_api.g_varchar2) then
528: p_rec.attribute17 :=
529: ota_lps_shd.g_old_rec.attribute17;
530: End If;
531: If (p_rec.attribute18 = hr_api.g_varchar2) then
532: p_rec.attribute18 :=
533: ota_lps_shd.g_old_rec.attribute18;
529: ota_lps_shd.g_old_rec.attribute17;
530: End If;
531: If (p_rec.attribute18 = hr_api.g_varchar2) then
532: p_rec.attribute18 :=
533: ota_lps_shd.g_old_rec.attribute18;
534: End If;
535: If (p_rec.attribute19 = hr_api.g_varchar2) then
536: p_rec.attribute19 :=
537: ota_lps_shd.g_old_rec.attribute19;
533: ota_lps_shd.g_old_rec.attribute18;
534: End If;
535: If (p_rec.attribute19 = hr_api.g_varchar2) then
536: p_rec.attribute19 :=
537: ota_lps_shd.g_old_rec.attribute19;
538: End If;
539: If (p_rec.attribute20 = hr_api.g_varchar2) then
540: p_rec.attribute20 :=
541: ota_lps_shd.g_old_rec.attribute20;
537: ota_lps_shd.g_old_rec.attribute19;
538: End If;
539: If (p_rec.attribute20 = hr_api.g_varchar2) then
540: p_rec.attribute20 :=
541: ota_lps_shd.g_old_rec.attribute20;
542: End If;
543: If (p_rec.start_date_active = hr_api.g_date) then
544: p_rec.start_date_active :=
545: ota_lps_shd.g_old_rec.start_date_active;
541: ota_lps_shd.g_old_rec.attribute20;
542: End If;
543: If (p_rec.start_date_active = hr_api.g_date) then
544: p_rec.start_date_active :=
545: ota_lps_shd.g_old_rec.start_date_active;
546: End If;
547: If (p_rec.end_date_active = hr_api.g_date) then
548: p_rec.end_date_active :=
549: ota_lps_shd.g_old_rec.end_date_active;
545: ota_lps_shd.g_old_rec.start_date_active;
546: End If;
547: If (p_rec.end_date_active = hr_api.g_date) then
548: p_rec.end_date_active :=
549: ota_lps_shd.g_old_rec.end_date_active;
550: End If;
551: If (p_rec.path_source_code = hr_api.g_varchar2) then
552: p_rec.path_source_code :=
553: ota_lps_shd.g_old_rec.path_source_code;
549: ota_lps_shd.g_old_rec.end_date_active;
550: End If;
551: If (p_rec.path_source_code = hr_api.g_varchar2) then
552: p_rec.path_source_code :=
553: ota_lps_shd.g_old_rec.path_source_code;
554: End If;
555: If (p_rec.source_function_code = hr_api.g_varchar2) then
556: p_rec.source_function_code :=
557: ota_lps_shd.g_old_rec.source_function_code;
553: ota_lps_shd.g_old_rec.path_source_code;
554: End If;
555: If (p_rec.source_function_code = hr_api.g_varchar2) then
556: p_rec.source_function_code :=
557: ota_lps_shd.g_old_rec.source_function_code;
558: End If;
559: If (p_rec.assignment_id = hr_api.g_number) then
560: p_rec.assignment_id :=
561: ota_lps_shd.g_old_rec.assignment_id;
557: ota_lps_shd.g_old_rec.source_function_code;
558: End If;
559: If (p_rec.assignment_id = hr_api.g_number) then
560: p_rec.assignment_id :=
561: ota_lps_shd.g_old_rec.assignment_id;
562: End If;
563: If (p_rec.source_id = hr_api.g_number) then
564: p_rec.source_id :=
565: ota_lps_shd.g_old_rec.source_id;
561: ota_lps_shd.g_old_rec.assignment_id;
562: End If;
563: If (p_rec.source_id = hr_api.g_number) then
564: p_rec.source_id :=
565: ota_lps_shd.g_old_rec.source_id;
566: End If;
567: If (p_rec.notify_days_before_target = hr_api.g_number) then
568: p_rec.notify_days_before_target :=
569: ota_lps_shd.g_old_rec.notify_days_before_target;
565: ota_lps_shd.g_old_rec.source_id;
566: End If;
567: If (p_rec.notify_days_before_target = hr_api.g_number) then
568: p_rec.notify_days_before_target :=
569: ota_lps_shd.g_old_rec.notify_days_before_target;
570: End If;
571: If (p_rec.person_id = hr_api.g_number) then
572: p_rec.person_id :=
573: ota_lps_shd.g_old_rec.person_id;
569: ota_lps_shd.g_old_rec.notify_days_before_target;
570: End If;
571: If (p_rec.person_id = hr_api.g_number) then
572: p_rec.person_id :=
573: ota_lps_shd.g_old_rec.person_id;
574: End If;
575: If (p_rec.contact_id = hr_api.g_number) then
576: p_rec.contact_id :=
577: ota_lps_shd.g_old_rec.contact_id;
573: ota_lps_shd.g_old_rec.person_id;
574: End If;
575: If (p_rec.contact_id = hr_api.g_number) then
576: p_rec.contact_id :=
577: ota_lps_shd.g_old_rec.contact_id;
578: End If;
579: If (p_rec.display_to_learner_flag = hr_api.g_varchar2) then
580: p_rec.display_to_learner_flag :=
581: ota_lps_shd.g_old_rec.display_to_learner_flag;
577: ota_lps_shd.g_old_rec.contact_id;
578: End If;
579: If (p_rec.display_to_learner_flag = hr_api.g_varchar2) then
580: p_rec.display_to_learner_flag :=
581: ota_lps_shd.g_old_rec.display_to_learner_flag;
582: End If;
583: If (p_rec.public_flag = hr_api.g_varchar2) then
584: p_rec.public_flag :=
585: ota_lps_shd.g_old_rec.public_flag;
581: ota_lps_shd.g_old_rec.display_to_learner_flag;
582: End If;
583: If (p_rec.public_flag = hr_api.g_varchar2) then
584: p_rec.public_flag :=
585: ota_lps_shd.g_old_rec.public_flag;
586: End If;
587: If (p_rec.competency_update_level = hr_api.g_varchar2) then
588: p_rec.competency_update_level :=
589: ota_lps_shd.g_old_rec.competency_update_level;
585: ota_lps_shd.g_old_rec.public_flag;
586: End If;
587: If (p_rec.competency_update_level = hr_api.g_varchar2) then
588: p_rec.competency_update_level :=
589: ota_lps_shd.g_old_rec.competency_update_level;
590: End If;
591: --
592: End convert_defs;
593: --
595: -- |---------------------------------< upd >----------------------------------|
596: -- ----------------------------------------------------------------------------
597: Procedure upd
598: (p_effective_date in date
599: ,p_rec in out nocopy ota_lps_shd.g_rec_type
600: ) is
601: --
602: l_proc varchar2(72) := g_package||'upd';
603: --
605: hr_utility.set_location('Entering:'||l_proc, 5);
606: --
607: -- We must lock the row which we need to update.
608: --
609: ota_lps_shd.lck
610: (p_rec.learning_path_id
611: ,p_rec.object_version_number
612: );
613: --
689: ,p_public_flag in varchar2 default hr_api.g_varchar2
690: ,p_competency_update_level in varchar2 default hr_api.g_varchar2
691: ) is
692: --
693: l_rec ota_lps_shd.g_rec_type;
694: l_proc varchar2(72) := g_package||'upd';
695: --
696: Begin
697: hr_utility.set_location('Entering:'||l_proc, 5);
699: -- Call conversion function to turn arguments into the
700: -- l_rec structure.
701: --
702: l_rec :=
703: ota_lps_shd.convert_args
704: (p_learning_path_id
705: ,p_business_group_id
706: ,p_duration
707: ,p_duration_units