54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy hr_lip_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date
130: Exception
131: When hr_api.check_integrity_violated Then
132: -- A check constraint has been violated
133: --
134: hr_lip_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: --
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: --
139: hr_lip_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When Others Then
142: --
143: Raise;
174: --
175: -- {End Of Comments}
176: -- ----------------------------------------------------------------------------
177: Procedure update_dml
178: (p_rec in out nocopy hr_lip_shd.g_rec_type
179: ,p_effective_date in date
180: ,p_datetrack_mode in varchar2
181: ,p_validation_start_date in date
182: ,p_validation_end_date in date
241: --
242: -- {End Of Comments}
243: -- ----------------------------------------------------------------------------
244: Procedure dt_pre_update
245: (p_rec in out nocopy hr_lip_shd.g_rec_type
246: ,p_effective_date in date
247: ,p_datetrack_mode in varchar2
248: ,p_validation_start_date in date
249: ,p_validation_end_date in date
257: If (p_datetrack_mode <> hr_api.g_correction) then
258: --
259: -- Update the current effective end date
260: --
261: hr_lip_shd.upd_effective_end_date
262: (p_effective_date => p_effective_date
263: ,p_base_key_value => p_rec.liability_premiums_id
264: ,p_new_effective_end_date => (p_validation_start_date - 1)
265: ,p_validation_start_date => p_validation_start_date
326: --
327: -- {End Of Comments}
328: -- ----------------------------------------------------------------------------
329: Procedure pre_update
330: (p_rec in out nocopy hr_lip_shd.g_rec_type
331: ,p_effective_date in date
332: ,p_datetrack_mode in varchar2
333: ,p_validation_start_date in date
334: ,p_validation_end_date in date
384: --
385: -- {End Of Comments}
386: -- ----------------------------------------------------------------------------
387: Procedure post_update
388: (p_rec in hr_lip_shd.g_rec_type
389: ,p_effective_date in date
390: ,p_datetrack_mode in varchar2
391: ,p_validation_start_date in date
392: ,p_validation_end_date in date
465: => p_rec.attribute20
466: ,p_object_version_number
467: => p_rec.object_version_number
468: ,p_organization_link_id_o
469: => hr_lip_shd.g_old_rec.organization_link_id
470: ,p_effective_start_date_o
471: => hr_lip_shd.g_old_rec.effective_start_date
472: ,p_effective_end_date_o
473: => hr_lip_shd.g_old_rec.effective_end_date
467: => p_rec.object_version_number
468: ,p_organization_link_id_o
469: => hr_lip_shd.g_old_rec.organization_link_id
470: ,p_effective_start_date_o
471: => hr_lip_shd.g_old_rec.effective_start_date
472: ,p_effective_end_date_o
473: => hr_lip_shd.g_old_rec.effective_end_date
474: ,p_std_percentage_o
475: => hr_lip_shd.g_old_rec.std_percentage
469: => hr_lip_shd.g_old_rec.organization_link_id
470: ,p_effective_start_date_o
471: => hr_lip_shd.g_old_rec.effective_start_date
472: ,p_effective_end_date_o
473: => hr_lip_shd.g_old_rec.effective_end_date
474: ,p_std_percentage_o
475: => hr_lip_shd.g_old_rec.std_percentage
476: ,p_calculation_method_o
477: => hr_lip_shd.g_old_rec.calculation_method
471: => hr_lip_shd.g_old_rec.effective_start_date
472: ,p_effective_end_date_o
473: => hr_lip_shd.g_old_rec.effective_end_date
474: ,p_std_percentage_o
475: => hr_lip_shd.g_old_rec.std_percentage
476: ,p_calculation_method_o
477: => hr_lip_shd.g_old_rec.calculation_method
478: ,p_std_working_hours_per_year_o
479: => hr_lip_shd.g_old_rec.std_working_hours_per_year
473: => hr_lip_shd.g_old_rec.effective_end_date
474: ,p_std_percentage_o
475: => hr_lip_shd.g_old_rec.std_percentage
476: ,p_calculation_method_o
477: => hr_lip_shd.g_old_rec.calculation_method
478: ,p_std_working_hours_per_year_o
479: => hr_lip_shd.g_old_rec.std_working_hours_per_year
480: ,p_max_remuneration_o
481: => hr_lip_shd.g_old_rec.max_remuneration
475: => hr_lip_shd.g_old_rec.std_percentage
476: ,p_calculation_method_o
477: => hr_lip_shd.g_old_rec.calculation_method
478: ,p_std_working_hours_per_year_o
479: => hr_lip_shd.g_old_rec.std_working_hours_per_year
480: ,p_max_remuneration_o
481: => hr_lip_shd.g_old_rec.max_remuneration
482: ,p_attribute_category_o
483: => hr_lip_shd.g_old_rec.attribute_category
477: => hr_lip_shd.g_old_rec.calculation_method
478: ,p_std_working_hours_per_year_o
479: => hr_lip_shd.g_old_rec.std_working_hours_per_year
480: ,p_max_remuneration_o
481: => hr_lip_shd.g_old_rec.max_remuneration
482: ,p_attribute_category_o
483: => hr_lip_shd.g_old_rec.attribute_category
484: ,p_attribute1_o
485: => hr_lip_shd.g_old_rec.attribute1
479: => hr_lip_shd.g_old_rec.std_working_hours_per_year
480: ,p_max_remuneration_o
481: => hr_lip_shd.g_old_rec.max_remuneration
482: ,p_attribute_category_o
483: => hr_lip_shd.g_old_rec.attribute_category
484: ,p_attribute1_o
485: => hr_lip_shd.g_old_rec.attribute1
486: ,p_attribute2_o
487: => hr_lip_shd.g_old_rec.attribute2
481: => hr_lip_shd.g_old_rec.max_remuneration
482: ,p_attribute_category_o
483: => hr_lip_shd.g_old_rec.attribute_category
484: ,p_attribute1_o
485: => hr_lip_shd.g_old_rec.attribute1
486: ,p_attribute2_o
487: => hr_lip_shd.g_old_rec.attribute2
488: ,p_attribute3_o
489: => hr_lip_shd.g_old_rec.attribute3
483: => hr_lip_shd.g_old_rec.attribute_category
484: ,p_attribute1_o
485: => hr_lip_shd.g_old_rec.attribute1
486: ,p_attribute2_o
487: => hr_lip_shd.g_old_rec.attribute2
488: ,p_attribute3_o
489: => hr_lip_shd.g_old_rec.attribute3
490: ,p_attribute4_o
491: => hr_lip_shd.g_old_rec.attribute4
485: => hr_lip_shd.g_old_rec.attribute1
486: ,p_attribute2_o
487: => hr_lip_shd.g_old_rec.attribute2
488: ,p_attribute3_o
489: => hr_lip_shd.g_old_rec.attribute3
490: ,p_attribute4_o
491: => hr_lip_shd.g_old_rec.attribute4
492: ,p_attribute5_o
493: => hr_lip_shd.g_old_rec.attribute5
487: => hr_lip_shd.g_old_rec.attribute2
488: ,p_attribute3_o
489: => hr_lip_shd.g_old_rec.attribute3
490: ,p_attribute4_o
491: => hr_lip_shd.g_old_rec.attribute4
492: ,p_attribute5_o
493: => hr_lip_shd.g_old_rec.attribute5
494: ,p_attribute6_o
495: => hr_lip_shd.g_old_rec.attribute6
489: => hr_lip_shd.g_old_rec.attribute3
490: ,p_attribute4_o
491: => hr_lip_shd.g_old_rec.attribute4
492: ,p_attribute5_o
493: => hr_lip_shd.g_old_rec.attribute5
494: ,p_attribute6_o
495: => hr_lip_shd.g_old_rec.attribute6
496: ,p_attribute7_o
497: => hr_lip_shd.g_old_rec.attribute7
491: => hr_lip_shd.g_old_rec.attribute4
492: ,p_attribute5_o
493: => hr_lip_shd.g_old_rec.attribute5
494: ,p_attribute6_o
495: => hr_lip_shd.g_old_rec.attribute6
496: ,p_attribute7_o
497: => hr_lip_shd.g_old_rec.attribute7
498: ,p_attribute8_o
499: => hr_lip_shd.g_old_rec.attribute8
493: => hr_lip_shd.g_old_rec.attribute5
494: ,p_attribute6_o
495: => hr_lip_shd.g_old_rec.attribute6
496: ,p_attribute7_o
497: => hr_lip_shd.g_old_rec.attribute7
498: ,p_attribute8_o
499: => hr_lip_shd.g_old_rec.attribute8
500: ,p_attribute9_o
501: => hr_lip_shd.g_old_rec.attribute9
495: => hr_lip_shd.g_old_rec.attribute6
496: ,p_attribute7_o
497: => hr_lip_shd.g_old_rec.attribute7
498: ,p_attribute8_o
499: => hr_lip_shd.g_old_rec.attribute8
500: ,p_attribute9_o
501: => hr_lip_shd.g_old_rec.attribute9
502: ,p_attribute10_o
503: => hr_lip_shd.g_old_rec.attribute10
497: => hr_lip_shd.g_old_rec.attribute7
498: ,p_attribute8_o
499: => hr_lip_shd.g_old_rec.attribute8
500: ,p_attribute9_o
501: => hr_lip_shd.g_old_rec.attribute9
502: ,p_attribute10_o
503: => hr_lip_shd.g_old_rec.attribute10
504: ,p_attribute11_o
505: => hr_lip_shd.g_old_rec.attribute11
499: => hr_lip_shd.g_old_rec.attribute8
500: ,p_attribute9_o
501: => hr_lip_shd.g_old_rec.attribute9
502: ,p_attribute10_o
503: => hr_lip_shd.g_old_rec.attribute10
504: ,p_attribute11_o
505: => hr_lip_shd.g_old_rec.attribute11
506: ,p_attribute12_o
507: => hr_lip_shd.g_old_rec.attribute12
501: => hr_lip_shd.g_old_rec.attribute9
502: ,p_attribute10_o
503: => hr_lip_shd.g_old_rec.attribute10
504: ,p_attribute11_o
505: => hr_lip_shd.g_old_rec.attribute11
506: ,p_attribute12_o
507: => hr_lip_shd.g_old_rec.attribute12
508: ,p_attribute13_o
509: => hr_lip_shd.g_old_rec.attribute13
503: => hr_lip_shd.g_old_rec.attribute10
504: ,p_attribute11_o
505: => hr_lip_shd.g_old_rec.attribute11
506: ,p_attribute12_o
507: => hr_lip_shd.g_old_rec.attribute12
508: ,p_attribute13_o
509: => hr_lip_shd.g_old_rec.attribute13
510: ,p_attribute14_o
511: => hr_lip_shd.g_old_rec.attribute14
505: => hr_lip_shd.g_old_rec.attribute11
506: ,p_attribute12_o
507: => hr_lip_shd.g_old_rec.attribute12
508: ,p_attribute13_o
509: => hr_lip_shd.g_old_rec.attribute13
510: ,p_attribute14_o
511: => hr_lip_shd.g_old_rec.attribute14
512: ,p_attribute15_o
513: => hr_lip_shd.g_old_rec.attribute15
507: => hr_lip_shd.g_old_rec.attribute12
508: ,p_attribute13_o
509: => hr_lip_shd.g_old_rec.attribute13
510: ,p_attribute14_o
511: => hr_lip_shd.g_old_rec.attribute14
512: ,p_attribute15_o
513: => hr_lip_shd.g_old_rec.attribute15
514: ,p_attribute16_o
515: => hr_lip_shd.g_old_rec.attribute16
509: => hr_lip_shd.g_old_rec.attribute13
510: ,p_attribute14_o
511: => hr_lip_shd.g_old_rec.attribute14
512: ,p_attribute15_o
513: => hr_lip_shd.g_old_rec.attribute15
514: ,p_attribute16_o
515: => hr_lip_shd.g_old_rec.attribute16
516: ,p_attribute17_o
517: => hr_lip_shd.g_old_rec.attribute17
511: => hr_lip_shd.g_old_rec.attribute14
512: ,p_attribute15_o
513: => hr_lip_shd.g_old_rec.attribute15
514: ,p_attribute16_o
515: => hr_lip_shd.g_old_rec.attribute16
516: ,p_attribute17_o
517: => hr_lip_shd.g_old_rec.attribute17
518: ,p_attribute18_o
519: => hr_lip_shd.g_old_rec.attribute18
513: => hr_lip_shd.g_old_rec.attribute15
514: ,p_attribute16_o
515: => hr_lip_shd.g_old_rec.attribute16
516: ,p_attribute17_o
517: => hr_lip_shd.g_old_rec.attribute17
518: ,p_attribute18_o
519: => hr_lip_shd.g_old_rec.attribute18
520: ,p_attribute19_o
521: => hr_lip_shd.g_old_rec.attribute19
515: => hr_lip_shd.g_old_rec.attribute16
516: ,p_attribute17_o
517: => hr_lip_shd.g_old_rec.attribute17
518: ,p_attribute18_o
519: => hr_lip_shd.g_old_rec.attribute18
520: ,p_attribute19_o
521: => hr_lip_shd.g_old_rec.attribute19
522: ,p_attribute20_o
523: => hr_lip_shd.g_old_rec.attribute20
517: => hr_lip_shd.g_old_rec.attribute17
518: ,p_attribute18_o
519: => hr_lip_shd.g_old_rec.attribute18
520: ,p_attribute19_o
521: => hr_lip_shd.g_old_rec.attribute19
522: ,p_attribute20_o
523: => hr_lip_shd.g_old_rec.attribute20
524: ,p_object_version_number_o
525: => hr_lip_shd.g_old_rec.object_version_number
519: => hr_lip_shd.g_old_rec.attribute18
520: ,p_attribute19_o
521: => hr_lip_shd.g_old_rec.attribute19
522: ,p_attribute20_o
523: => hr_lip_shd.g_old_rec.attribute20
524: ,p_object_version_number_o
525: => hr_lip_shd.g_old_rec.object_version_number
526: );
527: --
521: => hr_lip_shd.g_old_rec.attribute19
522: ,p_attribute20_o
523: => hr_lip_shd.g_old_rec.attribute20
524: ,p_object_version_number_o
525: => hr_lip_shd.g_old_rec.object_version_number
526: );
527: --
528: exception
529: --
581: --
582: -- {End Of Comments}
583: -- ----------------------------------------------------------------------------
584: Procedure convert_defs
585: (p_rec in out nocopy hr_lip_shd.g_rec_type
586: ) is
587: --
588: Begin
589: --
593: -- is being used then we must set to the 'current' argument value.
594: --
595: If (p_rec.organization_link_id = hr_api.g_number) then
596: p_rec.organization_link_id :=
597: hr_lip_shd.g_old_rec.organization_link_id;
598: End If;
599: If (p_rec.std_percentage = hr_api.g_number) then
600: p_rec.std_percentage :=
601: hr_lip_shd.g_old_rec.std_percentage;
597: hr_lip_shd.g_old_rec.organization_link_id;
598: End If;
599: If (p_rec.std_percentage = hr_api.g_number) then
600: p_rec.std_percentage :=
601: hr_lip_shd.g_old_rec.std_percentage;
602: End If;
603: If (p_rec.calculation_method = hr_api.g_varchar2) then
604: p_rec.calculation_method :=
605: hr_lip_shd.g_old_rec.calculation_method;
601: hr_lip_shd.g_old_rec.std_percentage;
602: End If;
603: If (p_rec.calculation_method = hr_api.g_varchar2) then
604: p_rec.calculation_method :=
605: hr_lip_shd.g_old_rec.calculation_method;
606: End If;
607: If (p_rec.std_working_hours_per_year = hr_api.g_number) then
608: p_rec.std_working_hours_per_year :=
609: hr_lip_shd.g_old_rec.std_working_hours_per_year;
605: hr_lip_shd.g_old_rec.calculation_method;
606: End If;
607: If (p_rec.std_working_hours_per_year = hr_api.g_number) then
608: p_rec.std_working_hours_per_year :=
609: hr_lip_shd.g_old_rec.std_working_hours_per_year;
610: End If;
611: If (p_rec.max_remuneration = hr_api.g_number) then
612: p_rec.max_remuneration :=
613: hr_lip_shd.g_old_rec.max_remuneration;
609: hr_lip_shd.g_old_rec.std_working_hours_per_year;
610: End If;
611: If (p_rec.max_remuneration = hr_api.g_number) then
612: p_rec.max_remuneration :=
613: hr_lip_shd.g_old_rec.max_remuneration;
614: End If;
615: If (p_rec.attribute_category = hr_api.g_varchar2) then
616: p_rec.attribute_category :=
617: hr_lip_shd.g_old_rec.attribute_category;
613: hr_lip_shd.g_old_rec.max_remuneration;
614: End If;
615: If (p_rec.attribute_category = hr_api.g_varchar2) then
616: p_rec.attribute_category :=
617: hr_lip_shd.g_old_rec.attribute_category;
618: End If;
619: If (p_rec.attribute1 = hr_api.g_varchar2) then
620: p_rec.attribute1 :=
621: hr_lip_shd.g_old_rec.attribute1;
617: hr_lip_shd.g_old_rec.attribute_category;
618: End If;
619: If (p_rec.attribute1 = hr_api.g_varchar2) then
620: p_rec.attribute1 :=
621: hr_lip_shd.g_old_rec.attribute1;
622: End If;
623: If (p_rec.attribute2 = hr_api.g_varchar2) then
624: p_rec.attribute2 :=
625: hr_lip_shd.g_old_rec.attribute2;
621: hr_lip_shd.g_old_rec.attribute1;
622: End If;
623: If (p_rec.attribute2 = hr_api.g_varchar2) then
624: p_rec.attribute2 :=
625: hr_lip_shd.g_old_rec.attribute2;
626: End If;
627: If (p_rec.attribute3 = hr_api.g_varchar2) then
628: p_rec.attribute3 :=
629: hr_lip_shd.g_old_rec.attribute3;
625: hr_lip_shd.g_old_rec.attribute2;
626: End If;
627: If (p_rec.attribute3 = hr_api.g_varchar2) then
628: p_rec.attribute3 :=
629: hr_lip_shd.g_old_rec.attribute3;
630: End If;
631: If (p_rec.attribute4 = hr_api.g_varchar2) then
632: p_rec.attribute4 :=
633: hr_lip_shd.g_old_rec.attribute4;
629: hr_lip_shd.g_old_rec.attribute3;
630: End If;
631: If (p_rec.attribute4 = hr_api.g_varchar2) then
632: p_rec.attribute4 :=
633: hr_lip_shd.g_old_rec.attribute4;
634: End If;
635: If (p_rec.attribute5 = hr_api.g_varchar2) then
636: p_rec.attribute5 :=
637: hr_lip_shd.g_old_rec.attribute5;
633: hr_lip_shd.g_old_rec.attribute4;
634: End If;
635: If (p_rec.attribute5 = hr_api.g_varchar2) then
636: p_rec.attribute5 :=
637: hr_lip_shd.g_old_rec.attribute5;
638: End If;
639: If (p_rec.attribute6 = hr_api.g_varchar2) then
640: p_rec.attribute6 :=
641: hr_lip_shd.g_old_rec.attribute6;
637: hr_lip_shd.g_old_rec.attribute5;
638: End If;
639: If (p_rec.attribute6 = hr_api.g_varchar2) then
640: p_rec.attribute6 :=
641: hr_lip_shd.g_old_rec.attribute6;
642: End If;
643: If (p_rec.attribute7 = hr_api.g_varchar2) then
644: p_rec.attribute7 :=
645: hr_lip_shd.g_old_rec.attribute7;
641: hr_lip_shd.g_old_rec.attribute6;
642: End If;
643: If (p_rec.attribute7 = hr_api.g_varchar2) then
644: p_rec.attribute7 :=
645: hr_lip_shd.g_old_rec.attribute7;
646: End If;
647: If (p_rec.attribute8 = hr_api.g_varchar2) then
648: p_rec.attribute8 :=
649: hr_lip_shd.g_old_rec.attribute8;
645: hr_lip_shd.g_old_rec.attribute7;
646: End If;
647: If (p_rec.attribute8 = hr_api.g_varchar2) then
648: p_rec.attribute8 :=
649: hr_lip_shd.g_old_rec.attribute8;
650: End If;
651: If (p_rec.attribute9 = hr_api.g_varchar2) then
652: p_rec.attribute9 :=
653: hr_lip_shd.g_old_rec.attribute9;
649: hr_lip_shd.g_old_rec.attribute8;
650: End If;
651: If (p_rec.attribute9 = hr_api.g_varchar2) then
652: p_rec.attribute9 :=
653: hr_lip_shd.g_old_rec.attribute9;
654: End If;
655: If (p_rec.attribute10 = hr_api.g_varchar2) then
656: p_rec.attribute10 :=
657: hr_lip_shd.g_old_rec.attribute10;
653: hr_lip_shd.g_old_rec.attribute9;
654: End If;
655: If (p_rec.attribute10 = hr_api.g_varchar2) then
656: p_rec.attribute10 :=
657: hr_lip_shd.g_old_rec.attribute10;
658: End If;
659: If (p_rec.attribute11 = hr_api.g_varchar2) then
660: p_rec.attribute11 :=
661: hr_lip_shd.g_old_rec.attribute11;
657: hr_lip_shd.g_old_rec.attribute10;
658: End If;
659: If (p_rec.attribute11 = hr_api.g_varchar2) then
660: p_rec.attribute11 :=
661: hr_lip_shd.g_old_rec.attribute11;
662: End If;
663: If (p_rec.attribute12 = hr_api.g_varchar2) then
664: p_rec.attribute12 :=
665: hr_lip_shd.g_old_rec.attribute12;
661: hr_lip_shd.g_old_rec.attribute11;
662: End If;
663: If (p_rec.attribute12 = hr_api.g_varchar2) then
664: p_rec.attribute12 :=
665: hr_lip_shd.g_old_rec.attribute12;
666: End If;
667: If (p_rec.attribute13 = hr_api.g_varchar2) then
668: p_rec.attribute13 :=
669: hr_lip_shd.g_old_rec.attribute13;
665: hr_lip_shd.g_old_rec.attribute12;
666: End If;
667: If (p_rec.attribute13 = hr_api.g_varchar2) then
668: p_rec.attribute13 :=
669: hr_lip_shd.g_old_rec.attribute13;
670: End If;
671: If (p_rec.attribute14 = hr_api.g_varchar2) then
672: p_rec.attribute14 :=
673: hr_lip_shd.g_old_rec.attribute14;
669: hr_lip_shd.g_old_rec.attribute13;
670: End If;
671: If (p_rec.attribute14 = hr_api.g_varchar2) then
672: p_rec.attribute14 :=
673: hr_lip_shd.g_old_rec.attribute14;
674: End If;
675: If (p_rec.attribute15 = hr_api.g_varchar2) then
676: p_rec.attribute15 :=
677: hr_lip_shd.g_old_rec.attribute15;
673: hr_lip_shd.g_old_rec.attribute14;
674: End If;
675: If (p_rec.attribute15 = hr_api.g_varchar2) then
676: p_rec.attribute15 :=
677: hr_lip_shd.g_old_rec.attribute15;
678: End If;
679: If (p_rec.attribute16 = hr_api.g_varchar2) then
680: p_rec.attribute16 :=
681: hr_lip_shd.g_old_rec.attribute16;
677: hr_lip_shd.g_old_rec.attribute15;
678: End If;
679: If (p_rec.attribute16 = hr_api.g_varchar2) then
680: p_rec.attribute16 :=
681: hr_lip_shd.g_old_rec.attribute16;
682: End If;
683: If (p_rec.attribute17 = hr_api.g_varchar2) then
684: p_rec.attribute17 :=
685: hr_lip_shd.g_old_rec.attribute17;
681: hr_lip_shd.g_old_rec.attribute16;
682: End If;
683: If (p_rec.attribute17 = hr_api.g_varchar2) then
684: p_rec.attribute17 :=
685: hr_lip_shd.g_old_rec.attribute17;
686: End If;
687: If (p_rec.attribute18 = hr_api.g_varchar2) then
688: p_rec.attribute18 :=
689: hr_lip_shd.g_old_rec.attribute18;
685: hr_lip_shd.g_old_rec.attribute17;
686: End If;
687: If (p_rec.attribute18 = hr_api.g_varchar2) then
688: p_rec.attribute18 :=
689: hr_lip_shd.g_old_rec.attribute18;
690: End If;
691: If (p_rec.attribute19 = hr_api.g_varchar2) then
692: p_rec.attribute19 :=
693: hr_lip_shd.g_old_rec.attribute19;
689: hr_lip_shd.g_old_rec.attribute18;
690: End If;
691: If (p_rec.attribute19 = hr_api.g_varchar2) then
692: p_rec.attribute19 :=
693: hr_lip_shd.g_old_rec.attribute19;
694: End If;
695: If (p_rec.attribute20 = hr_api.g_varchar2) then
696: p_rec.attribute20 :=
697: hr_lip_shd.g_old_rec.attribute20;
693: hr_lip_shd.g_old_rec.attribute19;
694: End If;
695: If (p_rec.attribute20 = hr_api.g_varchar2) then
696: p_rec.attribute20 :=
697: hr_lip_shd.g_old_rec.attribute20;
698: End If;
699: --
700: End convert_defs;
701: --
704: -- ----------------------------------------------------------------------------
705: Procedure upd
706: (p_effective_date in date
707: ,p_datetrack_mode in varchar2
708: ,p_rec in out nocopy hr_lip_shd.g_rec_type
709: ) is
710: --
711: l_proc varchar2(72) := g_package||'upd';
712: l_validation_start_date date;
720: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
721: --
722: -- We must lock the row which we need to update.
723: --
724: hr_lip_shd.lck
725: (p_effective_date => p_effective_date
726: ,p_datetrack_mode => p_datetrack_mode
727: ,p_liability_premiums_id => p_rec.liability_premiums_id
728: ,p_object_version_number => p_rec.object_version_number
813: ,p_effective_start_date out nocopy date
814: ,p_effective_end_date out nocopy date
815: ) is
816: --
817: l_rec hr_lip_shd.g_rec_type;
818: l_proc varchar2(72) := g_package||'upd';
819: --
820: Begin
821: hr_utility.set_location('Entering:'||l_proc, 5);
823: -- Call conversion function to turn arguments into the
824: -- l_rec structure.
825: --
826: l_rec :=
827: hr_lip_shd.convert_args
828: (p_liability_premiums_id
829: ,hr_api.g_number
830: ,null
831: ,null