[Home] [Help]
52: --
53: -- {End Of Comments}
54: -- ----------------------------------------------------------------------------
55: Procedure update_dml
56: (p_rec in out nocopy per_ctk_shd.g_rec_type
57: ) is
58: --
59: l_proc varchar2(72) := g_package||'update_dml';
60: --
134: Exception
135: When hr_api.check_integrity_violated Then
136: -- A check constraint has been violated
137: --
138: per_ctk_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.parent_integrity_violated Then
141: -- Parent integrity has been violated
142: --
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.parent_integrity_violated Then
141: -- Parent integrity has been violated
142: --
143: per_ctk_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.unique_integrity_violated Then
146: -- Unique integrity has been violated
147: --
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.unique_integrity_violated Then
146: -- Unique integrity has been violated
147: --
148: per_ctk_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When Others Then
151: --
152: Raise;
184: --
185: -- {End Of Comments}
186: -- ----------------------------------------------------------------------------
187: Procedure pre_update
188: (p_rec in out nocopy per_ctk_shd.g_rec_type
189: ) is
190: --
191: l_proc varchar2(72) := g_package||'pre_update';
192: -- for bgid
241: Begin
242:
243: hr_utility.set_location('Entering:'||l_proc, 5);
244: --
245: -- hr_utility.set_location('g_old_rec.eligibility_profile_id='||per_ctk_shd.g_old_rec.eligibility_profile_id,10);
246: -- hr_utility.set_location('p_rec.eligibility_profile_id='||p_rec.eligibility_profile_id,10);
247: if ( nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number AND
248: nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> nvl(p_rec.eligibility_profile_id, hr_api.g_number)) then
249:
243: hr_utility.set_location('Entering:'||l_proc, 5);
244: --
245: -- hr_utility.set_location('g_old_rec.eligibility_profile_id='||per_ctk_shd.g_old_rec.eligibility_profile_id,10);
246: -- hr_utility.set_location('p_rec.eligibility_profile_id='||p_rec.eligibility_profile_id,10);
247: if ( nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number AND
248: nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> nvl(p_rec.eligibility_profile_id, hr_api.g_number)) then
249:
250: -- delete old eligy profile eligy object (child)
251: open c_elig_prfl_elig_obj(per_ctk_shd.g_old_rec.eligibility_profile_id, per_ctk_shd.g_old_rec.eligibility_object_id);
244: --
245: -- hr_utility.set_location('g_old_rec.eligibility_profile_id='||per_ctk_shd.g_old_rec.eligibility_profile_id,10);
246: -- hr_utility.set_location('p_rec.eligibility_profile_id='||p_rec.eligibility_profile_id,10);
247: if ( nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number AND
248: nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> nvl(p_rec.eligibility_profile_id, hr_api.g_number)) then
249:
250: -- delete old eligy profile eligy object (child)
251: open c_elig_prfl_elig_obj(per_ctk_shd.g_old_rec.eligibility_profile_id, per_ctk_shd.g_old_rec.eligibility_object_id);
252: fetch c_elig_prfl_elig_obj into l_elig_obj_elig_prfl_id,l_prf_obj_ovn,l_effective_date;
247: if ( nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number AND
248: nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> nvl(p_rec.eligibility_profile_id, hr_api.g_number)) then
249:
250: -- delete old eligy profile eligy object (child)
251: open c_elig_prfl_elig_obj(per_ctk_shd.g_old_rec.eligibility_profile_id, per_ctk_shd.g_old_rec.eligibility_object_id);
252: fetch c_elig_prfl_elig_obj into l_elig_obj_elig_prfl_id,l_prf_obj_ovn,l_effective_date;
253: if(c_elig_prfl_elig_obj%found) then
254: begin
255: ben_ELIG_OBJ_ELIG_PROFL_api.delete_elig_obj_elig_profl
272: --hr_utility.set_location('p_rec.l_elig_obj_elig_prfl_id='||l_elig_obj_elig_prfl_id,10);
273: --hr_utility.set_location('p_rec.l_prf_obj_ovn='||l_prf_obj_ovn,10);
274: --hr_utility.set_location('p_rec.l_effective_date='||l_effective_date,10);
275: --hr_utility.set_location('eligy_obj_elig_profile deleted',10);
276: open c_elig_obj(per_ctk_shd.g_old_rec.eligibility_object_id);
277:
278: fetch c_elig_obj into l_obj_ovn,l_effective_date;
279: if(c_elig_obj%found)then
280: begin
280: begin
281: ben_elig_obj_api.delete_elig_obj
282: (
283: p_validate=>false,
284: p_elig_obj_id=>per_ctk_shd.g_old_rec.eligibility_object_id,
285: p_effective_start_date=>l_effective_start_date,
286: p_effective_end_date=>l_effective_end_date,
287: p_object_version_number=>l_obj_ovn,
288: p_effective_date=>l_effective_date,
303: -- create old eligy profile eligy object (child)
304:
305: end if;
306:
307: if ((nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number)= hr_api.g_number AND
308: nvl(p_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number ))
309: OR -- in this case above we have deleted old records
310: (nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number AND
311: nvl(p_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number AND
306:
307: if ((nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number)= hr_api.g_number AND
308: nvl(p_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number ))
309: OR -- in this case above we have deleted old records
310: (nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number AND
311: nvl(p_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number AND
312: nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> nvl(p_rec.eligibility_profile_id, hr_api.g_number))
313: then
314:
308: nvl(p_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number ))
309: OR -- in this case above we have deleted old records
310: (nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number AND
311: nvl(p_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number AND
312: nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> nvl(p_rec.eligibility_profile_id, hr_api.g_number))
313: then
314:
315: open c_elig_prfl_dates(p_rec.eligibility_profile_id);
316: fetch c_elig_prfl_dates into l_effective_date,l_prf_ovn;
395: -- {End Of Comments}
396: -- ----------------------------------------------------------------------------
397: Procedure post_update
398: (p_effective_date in date
399: ,p_rec in per_ctk_shd.g_rec_type
400: ) is
401: --
402: l_proc varchar2(72) := g_package||'post_update';
403: --
517: => p_rec.information19
518: ,p_information20
519: => p_rec.information20
520: ,p_checklist_id_o
521: => per_ctk_shd.g_old_rec.checklist_id
522: ,p_checklist_task_name_o
523: => per_ctk_shd.g_old_rec.checklist_task_name
524: ,p_eligibility_object_id_o
525: => per_ctk_shd.g_old_rec.eligibility_object_id
519: => p_rec.information20
520: ,p_checklist_id_o
521: => per_ctk_shd.g_old_rec.checklist_id
522: ,p_checklist_task_name_o
523: => per_ctk_shd.g_old_rec.checklist_task_name
524: ,p_eligibility_object_id_o
525: => per_ctk_shd.g_old_rec.eligibility_object_id
526: ,p_eligibility_profile_id_o
527: => per_ctk_shd.g_old_rec.eligibility_profile_id
521: => per_ctk_shd.g_old_rec.checklist_id
522: ,p_checklist_task_name_o
523: => per_ctk_shd.g_old_rec.checklist_task_name
524: ,p_eligibility_object_id_o
525: => per_ctk_shd.g_old_rec.eligibility_object_id
526: ,p_eligibility_profile_id_o
527: => per_ctk_shd.g_old_rec.eligibility_profile_id
528: ,p_ame_attribute_identifier_o
529: => per_ctk_shd.g_old_rec.ame_attribute_identifier
523: => per_ctk_shd.g_old_rec.checklist_task_name
524: ,p_eligibility_object_id_o
525: => per_ctk_shd.g_old_rec.eligibility_object_id
526: ,p_eligibility_profile_id_o
527: => per_ctk_shd.g_old_rec.eligibility_profile_id
528: ,p_ame_attribute_identifier_o
529: => per_ctk_shd.g_old_rec.ame_attribute_identifier
530: ,p_description_o
531: => per_ctk_shd.g_old_rec.description
525: => per_ctk_shd.g_old_rec.eligibility_object_id
526: ,p_eligibility_profile_id_o
527: => per_ctk_shd.g_old_rec.eligibility_profile_id
528: ,p_ame_attribute_identifier_o
529: => per_ctk_shd.g_old_rec.ame_attribute_identifier
530: ,p_description_o
531: => per_ctk_shd.g_old_rec.description
532: ,p_mandatory_flag_o
533: => per_ctk_shd.g_old_rec.mandatory_flag
527: => per_ctk_shd.g_old_rec.eligibility_profile_id
528: ,p_ame_attribute_identifier_o
529: => per_ctk_shd.g_old_rec.ame_attribute_identifier
530: ,p_description_o
531: => per_ctk_shd.g_old_rec.description
532: ,p_mandatory_flag_o
533: => per_ctk_shd.g_old_rec.mandatory_flag
534: ,p_target_duration_o
535: => per_ctk_shd.g_old_rec.target_duration
529: => per_ctk_shd.g_old_rec.ame_attribute_identifier
530: ,p_description_o
531: => per_ctk_shd.g_old_rec.description
532: ,p_mandatory_flag_o
533: => per_ctk_shd.g_old_rec.mandatory_flag
534: ,p_target_duration_o
535: => per_ctk_shd.g_old_rec.target_duration
536: ,p_target_duration_uom_o
537: => per_ctk_shd.g_old_rec.target_duration_uom
531: => per_ctk_shd.g_old_rec.description
532: ,p_mandatory_flag_o
533: => per_ctk_shd.g_old_rec.mandatory_flag
534: ,p_target_duration_o
535: => per_ctk_shd.g_old_rec.target_duration
536: ,p_target_duration_uom_o
537: => per_ctk_shd.g_old_rec.target_duration_uom
538: ,p_task_sequence_o
539: => per_ctk_shd.g_old_rec.task_sequence
533: => per_ctk_shd.g_old_rec.mandatory_flag
534: ,p_target_duration_o
535: => per_ctk_shd.g_old_rec.target_duration
536: ,p_target_duration_uom_o
537: => per_ctk_shd.g_old_rec.target_duration_uom
538: ,p_task_sequence_o
539: => per_ctk_shd.g_old_rec.task_sequence
540: ,p_object_version_number_o
541: => per_ctk_shd.g_old_rec.object_version_number
535: => per_ctk_shd.g_old_rec.target_duration
536: ,p_target_duration_uom_o
537: => per_ctk_shd.g_old_rec.target_duration_uom
538: ,p_task_sequence_o
539: => per_ctk_shd.g_old_rec.task_sequence
540: ,p_object_version_number_o
541: => per_ctk_shd.g_old_rec.object_version_number
542: ,p_action_url_o
543: => per_ctk_shd.g_old_rec.action_url
537: => per_ctk_shd.g_old_rec.target_duration_uom
538: ,p_task_sequence_o
539: => per_ctk_shd.g_old_rec.task_sequence
540: ,p_object_version_number_o
541: => per_ctk_shd.g_old_rec.object_version_number
542: ,p_action_url_o
543: => per_ctk_shd.g_old_rec.action_url
544: ,p_attribute_category_o
545: => per_ctk_shd.g_old_rec.attribute_category
539: => per_ctk_shd.g_old_rec.task_sequence
540: ,p_object_version_number_o
541: => per_ctk_shd.g_old_rec.object_version_number
542: ,p_action_url_o
543: => per_ctk_shd.g_old_rec.action_url
544: ,p_attribute_category_o
545: => per_ctk_shd.g_old_rec.attribute_category
546: ,p_attribute1_o
547: => per_ctk_shd.g_old_rec.attribute1
541: => per_ctk_shd.g_old_rec.object_version_number
542: ,p_action_url_o
543: => per_ctk_shd.g_old_rec.action_url
544: ,p_attribute_category_o
545: => per_ctk_shd.g_old_rec.attribute_category
546: ,p_attribute1_o
547: => per_ctk_shd.g_old_rec.attribute1
548: ,p_attribute2_o
549: => per_ctk_shd.g_old_rec.attribute2
543: => per_ctk_shd.g_old_rec.action_url
544: ,p_attribute_category_o
545: => per_ctk_shd.g_old_rec.attribute_category
546: ,p_attribute1_o
547: => per_ctk_shd.g_old_rec.attribute1
548: ,p_attribute2_o
549: => per_ctk_shd.g_old_rec.attribute2
550: ,p_attribute3_o
551: => per_ctk_shd.g_old_rec.attribute3
545: => per_ctk_shd.g_old_rec.attribute_category
546: ,p_attribute1_o
547: => per_ctk_shd.g_old_rec.attribute1
548: ,p_attribute2_o
549: => per_ctk_shd.g_old_rec.attribute2
550: ,p_attribute3_o
551: => per_ctk_shd.g_old_rec.attribute3
552: ,p_attribute4_o
553: => per_ctk_shd.g_old_rec.attribute4
547: => per_ctk_shd.g_old_rec.attribute1
548: ,p_attribute2_o
549: => per_ctk_shd.g_old_rec.attribute2
550: ,p_attribute3_o
551: => per_ctk_shd.g_old_rec.attribute3
552: ,p_attribute4_o
553: => per_ctk_shd.g_old_rec.attribute4
554: ,p_attribute5_o
555: => per_ctk_shd.g_old_rec.attribute5
549: => per_ctk_shd.g_old_rec.attribute2
550: ,p_attribute3_o
551: => per_ctk_shd.g_old_rec.attribute3
552: ,p_attribute4_o
553: => per_ctk_shd.g_old_rec.attribute4
554: ,p_attribute5_o
555: => per_ctk_shd.g_old_rec.attribute5
556: ,p_attribute6_o
557: => per_ctk_shd.g_old_rec.attribute6
551: => per_ctk_shd.g_old_rec.attribute3
552: ,p_attribute4_o
553: => per_ctk_shd.g_old_rec.attribute4
554: ,p_attribute5_o
555: => per_ctk_shd.g_old_rec.attribute5
556: ,p_attribute6_o
557: => per_ctk_shd.g_old_rec.attribute6
558: ,p_attribute7_o
559: => per_ctk_shd.g_old_rec.attribute7
553: => per_ctk_shd.g_old_rec.attribute4
554: ,p_attribute5_o
555: => per_ctk_shd.g_old_rec.attribute5
556: ,p_attribute6_o
557: => per_ctk_shd.g_old_rec.attribute6
558: ,p_attribute7_o
559: => per_ctk_shd.g_old_rec.attribute7
560: ,p_attribute8_o
561: => per_ctk_shd.g_old_rec.attribute8
555: => per_ctk_shd.g_old_rec.attribute5
556: ,p_attribute6_o
557: => per_ctk_shd.g_old_rec.attribute6
558: ,p_attribute7_o
559: => per_ctk_shd.g_old_rec.attribute7
560: ,p_attribute8_o
561: => per_ctk_shd.g_old_rec.attribute8
562: ,p_attribute9_o
563: => per_ctk_shd.g_old_rec.attribute9
557: => per_ctk_shd.g_old_rec.attribute6
558: ,p_attribute7_o
559: => per_ctk_shd.g_old_rec.attribute7
560: ,p_attribute8_o
561: => per_ctk_shd.g_old_rec.attribute8
562: ,p_attribute9_o
563: => per_ctk_shd.g_old_rec.attribute9
564: ,p_attribute10_o
565: => per_ctk_shd.g_old_rec.attribute10
559: => per_ctk_shd.g_old_rec.attribute7
560: ,p_attribute8_o
561: => per_ctk_shd.g_old_rec.attribute8
562: ,p_attribute9_o
563: => per_ctk_shd.g_old_rec.attribute9
564: ,p_attribute10_o
565: => per_ctk_shd.g_old_rec.attribute10
566: ,p_attribute11_o
567: => per_ctk_shd.g_old_rec.attribute11
561: => per_ctk_shd.g_old_rec.attribute8
562: ,p_attribute9_o
563: => per_ctk_shd.g_old_rec.attribute9
564: ,p_attribute10_o
565: => per_ctk_shd.g_old_rec.attribute10
566: ,p_attribute11_o
567: => per_ctk_shd.g_old_rec.attribute11
568: ,p_attribute12_o
569: => per_ctk_shd.g_old_rec.attribute12
563: => per_ctk_shd.g_old_rec.attribute9
564: ,p_attribute10_o
565: => per_ctk_shd.g_old_rec.attribute10
566: ,p_attribute11_o
567: => per_ctk_shd.g_old_rec.attribute11
568: ,p_attribute12_o
569: => per_ctk_shd.g_old_rec.attribute12
570: ,p_attribute13_o
571: => per_ctk_shd.g_old_rec.attribute13
565: => per_ctk_shd.g_old_rec.attribute10
566: ,p_attribute11_o
567: => per_ctk_shd.g_old_rec.attribute11
568: ,p_attribute12_o
569: => per_ctk_shd.g_old_rec.attribute12
570: ,p_attribute13_o
571: => per_ctk_shd.g_old_rec.attribute13
572: ,p_attribute14_o
573: => per_ctk_shd.g_old_rec.attribute14
567: => per_ctk_shd.g_old_rec.attribute11
568: ,p_attribute12_o
569: => per_ctk_shd.g_old_rec.attribute12
570: ,p_attribute13_o
571: => per_ctk_shd.g_old_rec.attribute13
572: ,p_attribute14_o
573: => per_ctk_shd.g_old_rec.attribute14
574: ,p_attribute15_o
575: => per_ctk_shd.g_old_rec.attribute15
569: => per_ctk_shd.g_old_rec.attribute12
570: ,p_attribute13_o
571: => per_ctk_shd.g_old_rec.attribute13
572: ,p_attribute14_o
573: => per_ctk_shd.g_old_rec.attribute14
574: ,p_attribute15_o
575: => per_ctk_shd.g_old_rec.attribute15
576: ,p_attribute16_o
577: => per_ctk_shd.g_old_rec.attribute16
571: => per_ctk_shd.g_old_rec.attribute13
572: ,p_attribute14_o
573: => per_ctk_shd.g_old_rec.attribute14
574: ,p_attribute15_o
575: => per_ctk_shd.g_old_rec.attribute15
576: ,p_attribute16_o
577: => per_ctk_shd.g_old_rec.attribute16
578: ,p_attribute17_o
579: => per_ctk_shd.g_old_rec.attribute17
573: => per_ctk_shd.g_old_rec.attribute14
574: ,p_attribute15_o
575: => per_ctk_shd.g_old_rec.attribute15
576: ,p_attribute16_o
577: => per_ctk_shd.g_old_rec.attribute16
578: ,p_attribute17_o
579: => per_ctk_shd.g_old_rec.attribute17
580: ,p_attribute18_o
581: => per_ctk_shd.g_old_rec.attribute18
575: => per_ctk_shd.g_old_rec.attribute15
576: ,p_attribute16_o
577: => per_ctk_shd.g_old_rec.attribute16
578: ,p_attribute17_o
579: => per_ctk_shd.g_old_rec.attribute17
580: ,p_attribute18_o
581: => per_ctk_shd.g_old_rec.attribute18
582: ,p_attribute19_o
583: => per_ctk_shd.g_old_rec.attribute19
577: => per_ctk_shd.g_old_rec.attribute16
578: ,p_attribute17_o
579: => per_ctk_shd.g_old_rec.attribute17
580: ,p_attribute18_o
581: => per_ctk_shd.g_old_rec.attribute18
582: ,p_attribute19_o
583: => per_ctk_shd.g_old_rec.attribute19
584: ,p_attribute20_o
585: => per_ctk_shd.g_old_rec.attribute20
579: => per_ctk_shd.g_old_rec.attribute17
580: ,p_attribute18_o
581: => per_ctk_shd.g_old_rec.attribute18
582: ,p_attribute19_o
583: => per_ctk_shd.g_old_rec.attribute19
584: ,p_attribute20_o
585: => per_ctk_shd.g_old_rec.attribute20
586: ,p_information_category_o
587: => per_ctk_shd.g_old_rec.information_category
581: => per_ctk_shd.g_old_rec.attribute18
582: ,p_attribute19_o
583: => per_ctk_shd.g_old_rec.attribute19
584: ,p_attribute20_o
585: => per_ctk_shd.g_old_rec.attribute20
586: ,p_information_category_o
587: => per_ctk_shd.g_old_rec.information_category
588: ,p_information1_o
589: => per_ctk_shd.g_old_rec.information1
583: => per_ctk_shd.g_old_rec.attribute19
584: ,p_attribute20_o
585: => per_ctk_shd.g_old_rec.attribute20
586: ,p_information_category_o
587: => per_ctk_shd.g_old_rec.information_category
588: ,p_information1_o
589: => per_ctk_shd.g_old_rec.information1
590: ,p_information2_o
591: => per_ctk_shd.g_old_rec.information2
585: => per_ctk_shd.g_old_rec.attribute20
586: ,p_information_category_o
587: => per_ctk_shd.g_old_rec.information_category
588: ,p_information1_o
589: => per_ctk_shd.g_old_rec.information1
590: ,p_information2_o
591: => per_ctk_shd.g_old_rec.information2
592: ,p_information3_o
593: => per_ctk_shd.g_old_rec.information3
587: => per_ctk_shd.g_old_rec.information_category
588: ,p_information1_o
589: => per_ctk_shd.g_old_rec.information1
590: ,p_information2_o
591: => per_ctk_shd.g_old_rec.information2
592: ,p_information3_o
593: => per_ctk_shd.g_old_rec.information3
594: ,p_information4_o
595: => per_ctk_shd.g_old_rec.information4
589: => per_ctk_shd.g_old_rec.information1
590: ,p_information2_o
591: => per_ctk_shd.g_old_rec.information2
592: ,p_information3_o
593: => per_ctk_shd.g_old_rec.information3
594: ,p_information4_o
595: => per_ctk_shd.g_old_rec.information4
596: ,p_information5_o
597: => per_ctk_shd.g_old_rec.information5
591: => per_ctk_shd.g_old_rec.information2
592: ,p_information3_o
593: => per_ctk_shd.g_old_rec.information3
594: ,p_information4_o
595: => per_ctk_shd.g_old_rec.information4
596: ,p_information5_o
597: => per_ctk_shd.g_old_rec.information5
598: ,p_information6_o
599: => per_ctk_shd.g_old_rec.information6
593: => per_ctk_shd.g_old_rec.information3
594: ,p_information4_o
595: => per_ctk_shd.g_old_rec.information4
596: ,p_information5_o
597: => per_ctk_shd.g_old_rec.information5
598: ,p_information6_o
599: => per_ctk_shd.g_old_rec.information6
600: ,p_information7_o
601: => per_ctk_shd.g_old_rec.information7
595: => per_ctk_shd.g_old_rec.information4
596: ,p_information5_o
597: => per_ctk_shd.g_old_rec.information5
598: ,p_information6_o
599: => per_ctk_shd.g_old_rec.information6
600: ,p_information7_o
601: => per_ctk_shd.g_old_rec.information7
602: ,p_information8_o
603: => per_ctk_shd.g_old_rec.information8
597: => per_ctk_shd.g_old_rec.information5
598: ,p_information6_o
599: => per_ctk_shd.g_old_rec.information6
600: ,p_information7_o
601: => per_ctk_shd.g_old_rec.information7
602: ,p_information8_o
603: => per_ctk_shd.g_old_rec.information8
604: ,p_information9_o
605: => per_ctk_shd.g_old_rec.information9
599: => per_ctk_shd.g_old_rec.information6
600: ,p_information7_o
601: => per_ctk_shd.g_old_rec.information7
602: ,p_information8_o
603: => per_ctk_shd.g_old_rec.information8
604: ,p_information9_o
605: => per_ctk_shd.g_old_rec.information9
606: ,p_information10_o
607: => per_ctk_shd.g_old_rec.information10
601: => per_ctk_shd.g_old_rec.information7
602: ,p_information8_o
603: => per_ctk_shd.g_old_rec.information8
604: ,p_information9_o
605: => per_ctk_shd.g_old_rec.information9
606: ,p_information10_o
607: => per_ctk_shd.g_old_rec.information10
608: ,p_information11_o
609: => per_ctk_shd.g_old_rec.information11
603: => per_ctk_shd.g_old_rec.information8
604: ,p_information9_o
605: => per_ctk_shd.g_old_rec.information9
606: ,p_information10_o
607: => per_ctk_shd.g_old_rec.information10
608: ,p_information11_o
609: => per_ctk_shd.g_old_rec.information11
610: ,p_information12_o
611: => per_ctk_shd.g_old_rec.information12
605: => per_ctk_shd.g_old_rec.information9
606: ,p_information10_o
607: => per_ctk_shd.g_old_rec.information10
608: ,p_information11_o
609: => per_ctk_shd.g_old_rec.information11
610: ,p_information12_o
611: => per_ctk_shd.g_old_rec.information12
612: ,p_information13_o
613: => per_ctk_shd.g_old_rec.information13
607: => per_ctk_shd.g_old_rec.information10
608: ,p_information11_o
609: => per_ctk_shd.g_old_rec.information11
610: ,p_information12_o
611: => per_ctk_shd.g_old_rec.information12
612: ,p_information13_o
613: => per_ctk_shd.g_old_rec.information13
614: ,p_information14_o
615: => per_ctk_shd.g_old_rec.information14
609: => per_ctk_shd.g_old_rec.information11
610: ,p_information12_o
611: => per_ctk_shd.g_old_rec.information12
612: ,p_information13_o
613: => per_ctk_shd.g_old_rec.information13
614: ,p_information14_o
615: => per_ctk_shd.g_old_rec.information14
616: ,p_information15_o
617: => per_ctk_shd.g_old_rec.information15
611: => per_ctk_shd.g_old_rec.information12
612: ,p_information13_o
613: => per_ctk_shd.g_old_rec.information13
614: ,p_information14_o
615: => per_ctk_shd.g_old_rec.information14
616: ,p_information15_o
617: => per_ctk_shd.g_old_rec.information15
618: ,p_information16_o
619: => per_ctk_shd.g_old_rec.information16
613: => per_ctk_shd.g_old_rec.information13
614: ,p_information14_o
615: => per_ctk_shd.g_old_rec.information14
616: ,p_information15_o
617: => per_ctk_shd.g_old_rec.information15
618: ,p_information16_o
619: => per_ctk_shd.g_old_rec.information16
620: ,p_information17_o
621: => per_ctk_shd.g_old_rec.information17
615: => per_ctk_shd.g_old_rec.information14
616: ,p_information15_o
617: => per_ctk_shd.g_old_rec.information15
618: ,p_information16_o
619: => per_ctk_shd.g_old_rec.information16
620: ,p_information17_o
621: => per_ctk_shd.g_old_rec.information17
622: ,p_information18_o
623: => per_ctk_shd.g_old_rec.information18
617: => per_ctk_shd.g_old_rec.information15
618: ,p_information16_o
619: => per_ctk_shd.g_old_rec.information16
620: ,p_information17_o
621: => per_ctk_shd.g_old_rec.information17
622: ,p_information18_o
623: => per_ctk_shd.g_old_rec.information18
624: ,p_information19_o
625: => per_ctk_shd.g_old_rec.information19
619: => per_ctk_shd.g_old_rec.information16
620: ,p_information17_o
621: => per_ctk_shd.g_old_rec.information17
622: ,p_information18_o
623: => per_ctk_shd.g_old_rec.information18
624: ,p_information19_o
625: => per_ctk_shd.g_old_rec.information19
626: ,p_information20_o
627: => per_ctk_shd.g_old_rec.information20
621: => per_ctk_shd.g_old_rec.information17
622: ,p_information18_o
623: => per_ctk_shd.g_old_rec.information18
624: ,p_information19_o
625: => per_ctk_shd.g_old_rec.information19
626: ,p_information20_o
627: => per_ctk_shd.g_old_rec.information20
628: );
629: --
623: => per_ctk_shd.g_old_rec.information18
624: ,p_information19_o
625: => per_ctk_shd.g_old_rec.information19
626: ,p_information20_o
627: => per_ctk_shd.g_old_rec.information20
628: );
629: --
630: exception
631: --
683: --
684: -- {End Of Comments}
685: -- ----------------------------------------------------------------------------
686: Procedure convert_defs
687: (p_rec in out nocopy per_ctk_shd.g_rec_type
688: ) is
689: --
690: Begin
691: --
695: -- is being used then we must set to the 'current' argument value.
696: --
697: If (p_rec.checklist_id = hr_api.g_number) then
698: p_rec.checklist_id :=
699: per_ctk_shd.g_old_rec.checklist_id;
700: End If;
701: If (p_rec.checklist_task_name = hr_api.g_varchar2) then
702: p_rec.checklist_task_name :=
703: per_ctk_shd.g_old_rec.checklist_task_name;
699: per_ctk_shd.g_old_rec.checklist_id;
700: End If;
701: If (p_rec.checklist_task_name = hr_api.g_varchar2) then
702: p_rec.checklist_task_name :=
703: per_ctk_shd.g_old_rec.checklist_task_name;
704: End If;
705: If (p_rec.eligibility_object_id = hr_api.g_number) then
706: p_rec.eligibility_object_id :=
707: per_ctk_shd.g_old_rec.eligibility_object_id;
703: per_ctk_shd.g_old_rec.checklist_task_name;
704: End If;
705: If (p_rec.eligibility_object_id = hr_api.g_number) then
706: p_rec.eligibility_object_id :=
707: per_ctk_shd.g_old_rec.eligibility_object_id;
708: End If;
709: If (p_rec.eligibility_profile_id = hr_api.g_number) then
710: p_rec.eligibility_profile_id :=
711: per_ctk_shd.g_old_rec.eligibility_profile_id;
707: per_ctk_shd.g_old_rec.eligibility_object_id;
708: End If;
709: If (p_rec.eligibility_profile_id = hr_api.g_number) then
710: p_rec.eligibility_profile_id :=
711: per_ctk_shd.g_old_rec.eligibility_profile_id;
712: End If;
713: If (p_rec.ame_attribute_identifier = hr_api.g_varchar2) then
714: p_rec.ame_attribute_identifier :=
715: per_ctk_shd.g_old_rec.ame_attribute_identifier;
711: per_ctk_shd.g_old_rec.eligibility_profile_id;
712: End If;
713: If (p_rec.ame_attribute_identifier = hr_api.g_varchar2) then
714: p_rec.ame_attribute_identifier :=
715: per_ctk_shd.g_old_rec.ame_attribute_identifier;
716: End If;
717: If (p_rec.description = hr_api.g_varchar2) then
718: p_rec.description :=
719: per_ctk_shd.g_old_rec.description;
715: per_ctk_shd.g_old_rec.ame_attribute_identifier;
716: End If;
717: If (p_rec.description = hr_api.g_varchar2) then
718: p_rec.description :=
719: per_ctk_shd.g_old_rec.description;
720: End If;
721: If (p_rec.mandatory_flag = hr_api.g_varchar2) then
722: p_rec.mandatory_flag :=
723: per_ctk_shd.g_old_rec.mandatory_flag;
719: per_ctk_shd.g_old_rec.description;
720: End If;
721: If (p_rec.mandatory_flag = hr_api.g_varchar2) then
722: p_rec.mandatory_flag :=
723: per_ctk_shd.g_old_rec.mandatory_flag;
724: End If;
725: If (p_rec.target_duration = hr_api.g_number) then
726: p_rec.target_duration :=
727: per_ctk_shd.g_old_rec.target_duration;
723: per_ctk_shd.g_old_rec.mandatory_flag;
724: End If;
725: If (p_rec.target_duration = hr_api.g_number) then
726: p_rec.target_duration :=
727: per_ctk_shd.g_old_rec.target_duration;
728: End If;
729: If (p_rec.target_duration_uom = hr_api.g_varchar2) then
730: p_rec.target_duration_uom :=
731: per_ctk_shd.g_old_rec.target_duration_uom;
727: per_ctk_shd.g_old_rec.target_duration;
728: End If;
729: If (p_rec.target_duration_uom = hr_api.g_varchar2) then
730: p_rec.target_duration_uom :=
731: per_ctk_shd.g_old_rec.target_duration_uom;
732: End If;
733: If (p_rec.task_sequence = hr_api.g_number) then
734: p_rec.task_sequence :=
735: per_ctk_shd.g_old_rec.task_sequence;
731: per_ctk_shd.g_old_rec.target_duration_uom;
732: End If;
733: If (p_rec.task_sequence = hr_api.g_number) then
734: p_rec.task_sequence :=
735: per_ctk_shd.g_old_rec.task_sequence;
736: End If;
737: If (p_rec.action_url = hr_api.g_varchar2) then
738: p_rec.action_url :=
739: per_ctk_shd.g_old_rec.action_url;
735: per_ctk_shd.g_old_rec.task_sequence;
736: End If;
737: If (p_rec.action_url = hr_api.g_varchar2) then
738: p_rec.action_url :=
739: per_ctk_shd.g_old_rec.action_url;
740: End If;
741: If (p_rec.attribute_category = hr_api.g_varchar2) then
742: p_rec.attribute_category :=
743: per_ctk_shd.g_old_rec.attribute_category;
739: per_ctk_shd.g_old_rec.action_url;
740: End If;
741: If (p_rec.attribute_category = hr_api.g_varchar2) then
742: p_rec.attribute_category :=
743: per_ctk_shd.g_old_rec.attribute_category;
744: End If;
745: If (p_rec.attribute1 = hr_api.g_varchar2) then
746: p_rec.attribute1 :=
747: per_ctk_shd.g_old_rec.attribute1;
743: per_ctk_shd.g_old_rec.attribute_category;
744: End If;
745: If (p_rec.attribute1 = hr_api.g_varchar2) then
746: p_rec.attribute1 :=
747: per_ctk_shd.g_old_rec.attribute1;
748: End If;
749: If (p_rec.attribute2 = hr_api.g_varchar2) then
750: p_rec.attribute2 :=
751: per_ctk_shd.g_old_rec.attribute2;
747: per_ctk_shd.g_old_rec.attribute1;
748: End If;
749: If (p_rec.attribute2 = hr_api.g_varchar2) then
750: p_rec.attribute2 :=
751: per_ctk_shd.g_old_rec.attribute2;
752: End If;
753: If (p_rec.attribute3 = hr_api.g_varchar2) then
754: p_rec.attribute3 :=
755: per_ctk_shd.g_old_rec.attribute3;
751: per_ctk_shd.g_old_rec.attribute2;
752: End If;
753: If (p_rec.attribute3 = hr_api.g_varchar2) then
754: p_rec.attribute3 :=
755: per_ctk_shd.g_old_rec.attribute3;
756: End If;
757: If (p_rec.attribute4 = hr_api.g_varchar2) then
758: p_rec.attribute4 :=
759: per_ctk_shd.g_old_rec.attribute4;
755: per_ctk_shd.g_old_rec.attribute3;
756: End If;
757: If (p_rec.attribute4 = hr_api.g_varchar2) then
758: p_rec.attribute4 :=
759: per_ctk_shd.g_old_rec.attribute4;
760: End If;
761: If (p_rec.attribute5 = hr_api.g_varchar2) then
762: p_rec.attribute5 :=
763: per_ctk_shd.g_old_rec.attribute5;
759: per_ctk_shd.g_old_rec.attribute4;
760: End If;
761: If (p_rec.attribute5 = hr_api.g_varchar2) then
762: p_rec.attribute5 :=
763: per_ctk_shd.g_old_rec.attribute5;
764: End If;
765: If (p_rec.attribute6 = hr_api.g_varchar2) then
766: p_rec.attribute6 :=
767: per_ctk_shd.g_old_rec.attribute6;
763: per_ctk_shd.g_old_rec.attribute5;
764: End If;
765: If (p_rec.attribute6 = hr_api.g_varchar2) then
766: p_rec.attribute6 :=
767: per_ctk_shd.g_old_rec.attribute6;
768: End If;
769: If (p_rec.attribute7 = hr_api.g_varchar2) then
770: p_rec.attribute7 :=
771: per_ctk_shd.g_old_rec.attribute7;
767: per_ctk_shd.g_old_rec.attribute6;
768: End If;
769: If (p_rec.attribute7 = hr_api.g_varchar2) then
770: p_rec.attribute7 :=
771: per_ctk_shd.g_old_rec.attribute7;
772: End If;
773: If (p_rec.attribute8 = hr_api.g_varchar2) then
774: p_rec.attribute8 :=
775: per_ctk_shd.g_old_rec.attribute8;
771: per_ctk_shd.g_old_rec.attribute7;
772: End If;
773: If (p_rec.attribute8 = hr_api.g_varchar2) then
774: p_rec.attribute8 :=
775: per_ctk_shd.g_old_rec.attribute8;
776: End If;
777: If (p_rec.attribute9 = hr_api.g_varchar2) then
778: p_rec.attribute9 :=
779: per_ctk_shd.g_old_rec.attribute9;
775: per_ctk_shd.g_old_rec.attribute8;
776: End If;
777: If (p_rec.attribute9 = hr_api.g_varchar2) then
778: p_rec.attribute9 :=
779: per_ctk_shd.g_old_rec.attribute9;
780: End If;
781: If (p_rec.attribute10 = hr_api.g_varchar2) then
782: p_rec.attribute10 :=
783: per_ctk_shd.g_old_rec.attribute10;
779: per_ctk_shd.g_old_rec.attribute9;
780: End If;
781: If (p_rec.attribute10 = hr_api.g_varchar2) then
782: p_rec.attribute10 :=
783: per_ctk_shd.g_old_rec.attribute10;
784: End If;
785: If (p_rec.attribute11 = hr_api.g_varchar2) then
786: p_rec.attribute11 :=
787: per_ctk_shd.g_old_rec.attribute11;
783: per_ctk_shd.g_old_rec.attribute10;
784: End If;
785: If (p_rec.attribute11 = hr_api.g_varchar2) then
786: p_rec.attribute11 :=
787: per_ctk_shd.g_old_rec.attribute11;
788: End If;
789: If (p_rec.attribute12 = hr_api.g_varchar2) then
790: p_rec.attribute12 :=
791: per_ctk_shd.g_old_rec.attribute12;
787: per_ctk_shd.g_old_rec.attribute11;
788: End If;
789: If (p_rec.attribute12 = hr_api.g_varchar2) then
790: p_rec.attribute12 :=
791: per_ctk_shd.g_old_rec.attribute12;
792: End If;
793: If (p_rec.attribute13 = hr_api.g_varchar2) then
794: p_rec.attribute13 :=
795: per_ctk_shd.g_old_rec.attribute13;
791: per_ctk_shd.g_old_rec.attribute12;
792: End If;
793: If (p_rec.attribute13 = hr_api.g_varchar2) then
794: p_rec.attribute13 :=
795: per_ctk_shd.g_old_rec.attribute13;
796: End If;
797: If (p_rec.attribute14 = hr_api.g_varchar2) then
798: p_rec.attribute14 :=
799: per_ctk_shd.g_old_rec.attribute14;
795: per_ctk_shd.g_old_rec.attribute13;
796: End If;
797: If (p_rec.attribute14 = hr_api.g_varchar2) then
798: p_rec.attribute14 :=
799: per_ctk_shd.g_old_rec.attribute14;
800: End If;
801: If (p_rec.attribute15 = hr_api.g_varchar2) then
802: p_rec.attribute15 :=
803: per_ctk_shd.g_old_rec.attribute15;
799: per_ctk_shd.g_old_rec.attribute14;
800: End If;
801: If (p_rec.attribute15 = hr_api.g_varchar2) then
802: p_rec.attribute15 :=
803: per_ctk_shd.g_old_rec.attribute15;
804: End If;
805: If (p_rec.attribute16 = hr_api.g_varchar2) then
806: p_rec.attribute16 :=
807: per_ctk_shd.g_old_rec.attribute16;
803: per_ctk_shd.g_old_rec.attribute15;
804: End If;
805: If (p_rec.attribute16 = hr_api.g_varchar2) then
806: p_rec.attribute16 :=
807: per_ctk_shd.g_old_rec.attribute16;
808: End If;
809: If (p_rec.attribute17 = hr_api.g_varchar2) then
810: p_rec.attribute17 :=
811: per_ctk_shd.g_old_rec.attribute17;
807: per_ctk_shd.g_old_rec.attribute16;
808: End If;
809: If (p_rec.attribute17 = hr_api.g_varchar2) then
810: p_rec.attribute17 :=
811: per_ctk_shd.g_old_rec.attribute17;
812: End If;
813: If (p_rec.attribute18 = hr_api.g_varchar2) then
814: p_rec.attribute18 :=
815: per_ctk_shd.g_old_rec.attribute18;
811: per_ctk_shd.g_old_rec.attribute17;
812: End If;
813: If (p_rec.attribute18 = hr_api.g_varchar2) then
814: p_rec.attribute18 :=
815: per_ctk_shd.g_old_rec.attribute18;
816: End If;
817: If (p_rec.attribute19 = hr_api.g_varchar2) then
818: p_rec.attribute19 :=
819: per_ctk_shd.g_old_rec.attribute19;
815: per_ctk_shd.g_old_rec.attribute18;
816: End If;
817: If (p_rec.attribute19 = hr_api.g_varchar2) then
818: p_rec.attribute19 :=
819: per_ctk_shd.g_old_rec.attribute19;
820: End If;
821: If (p_rec.attribute20 = hr_api.g_varchar2) then
822: p_rec.attribute20 :=
823: per_ctk_shd.g_old_rec.attribute20;
819: per_ctk_shd.g_old_rec.attribute19;
820: End If;
821: If (p_rec.attribute20 = hr_api.g_varchar2) then
822: p_rec.attribute20 :=
823: per_ctk_shd.g_old_rec.attribute20;
824: End If;
825: If (p_rec.information_category = hr_api.g_varchar2) then
826: p_rec.information_category :=
827: per_ctk_shd.g_old_rec.information_category;
823: per_ctk_shd.g_old_rec.attribute20;
824: End If;
825: If (p_rec.information_category = hr_api.g_varchar2) then
826: p_rec.information_category :=
827: per_ctk_shd.g_old_rec.information_category;
828: End If;
829: If (p_rec.information1 = hr_api.g_varchar2) then
830: p_rec.information1 :=
831: per_ctk_shd.g_old_rec.information1;
827: per_ctk_shd.g_old_rec.information_category;
828: End If;
829: If (p_rec.information1 = hr_api.g_varchar2) then
830: p_rec.information1 :=
831: per_ctk_shd.g_old_rec.information1;
832: End If;
833: If (p_rec.information2 = hr_api.g_varchar2) then
834: p_rec.information2 :=
835: per_ctk_shd.g_old_rec.information2;
831: per_ctk_shd.g_old_rec.information1;
832: End If;
833: If (p_rec.information2 = hr_api.g_varchar2) then
834: p_rec.information2 :=
835: per_ctk_shd.g_old_rec.information2;
836: End If;
837: If (p_rec.information3 = hr_api.g_varchar2) then
838: p_rec.information3 :=
839: per_ctk_shd.g_old_rec.information3;
835: per_ctk_shd.g_old_rec.information2;
836: End If;
837: If (p_rec.information3 = hr_api.g_varchar2) then
838: p_rec.information3 :=
839: per_ctk_shd.g_old_rec.information3;
840: End If;
841: If (p_rec.information4 = hr_api.g_varchar2) then
842: p_rec.information4 :=
843: per_ctk_shd.g_old_rec.information4;
839: per_ctk_shd.g_old_rec.information3;
840: End If;
841: If (p_rec.information4 = hr_api.g_varchar2) then
842: p_rec.information4 :=
843: per_ctk_shd.g_old_rec.information4;
844: End If;
845: If (p_rec.information5 = hr_api.g_varchar2) then
846: p_rec.information5 :=
847: per_ctk_shd.g_old_rec.information5;
843: per_ctk_shd.g_old_rec.information4;
844: End If;
845: If (p_rec.information5 = hr_api.g_varchar2) then
846: p_rec.information5 :=
847: per_ctk_shd.g_old_rec.information5;
848: End If;
849: If (p_rec.information6 = hr_api.g_varchar2) then
850: p_rec.information6 :=
851: per_ctk_shd.g_old_rec.information6;
847: per_ctk_shd.g_old_rec.information5;
848: End If;
849: If (p_rec.information6 = hr_api.g_varchar2) then
850: p_rec.information6 :=
851: per_ctk_shd.g_old_rec.information6;
852: End If;
853: If (p_rec.information7 = hr_api.g_varchar2) then
854: p_rec.information7 :=
855: per_ctk_shd.g_old_rec.information7;
851: per_ctk_shd.g_old_rec.information6;
852: End If;
853: If (p_rec.information7 = hr_api.g_varchar2) then
854: p_rec.information7 :=
855: per_ctk_shd.g_old_rec.information7;
856: End If;
857: If (p_rec.information8 = hr_api.g_varchar2) then
858: p_rec.information8 :=
859: per_ctk_shd.g_old_rec.information8;
855: per_ctk_shd.g_old_rec.information7;
856: End If;
857: If (p_rec.information8 = hr_api.g_varchar2) then
858: p_rec.information8 :=
859: per_ctk_shd.g_old_rec.information8;
860: End If;
861: If (p_rec.information9 = hr_api.g_varchar2) then
862: p_rec.information9 :=
863: per_ctk_shd.g_old_rec.information9;
859: per_ctk_shd.g_old_rec.information8;
860: End If;
861: If (p_rec.information9 = hr_api.g_varchar2) then
862: p_rec.information9 :=
863: per_ctk_shd.g_old_rec.information9;
864: End If;
865: If (p_rec.information10 = hr_api.g_varchar2) then
866: p_rec.information10 :=
867: per_ctk_shd.g_old_rec.information10;
863: per_ctk_shd.g_old_rec.information9;
864: End If;
865: If (p_rec.information10 = hr_api.g_varchar2) then
866: p_rec.information10 :=
867: per_ctk_shd.g_old_rec.information10;
868: End If;
869: If (p_rec.information11 = hr_api.g_varchar2) then
870: p_rec.information11 :=
871: per_ctk_shd.g_old_rec.information11;
867: per_ctk_shd.g_old_rec.information10;
868: End If;
869: If (p_rec.information11 = hr_api.g_varchar2) then
870: p_rec.information11 :=
871: per_ctk_shd.g_old_rec.information11;
872: End If;
873: If (p_rec.information12 = hr_api.g_varchar2) then
874: p_rec.information12 :=
875: per_ctk_shd.g_old_rec.information12;
871: per_ctk_shd.g_old_rec.information11;
872: End If;
873: If (p_rec.information12 = hr_api.g_varchar2) then
874: p_rec.information12 :=
875: per_ctk_shd.g_old_rec.information12;
876: End If;
877: If (p_rec.information13 = hr_api.g_varchar2) then
878: p_rec.information13 :=
879: per_ctk_shd.g_old_rec.information13;
875: per_ctk_shd.g_old_rec.information12;
876: End If;
877: If (p_rec.information13 = hr_api.g_varchar2) then
878: p_rec.information13 :=
879: per_ctk_shd.g_old_rec.information13;
880: End If;
881: If (p_rec.information14 = hr_api.g_varchar2) then
882: p_rec.information14 :=
883: per_ctk_shd.g_old_rec.information14;
879: per_ctk_shd.g_old_rec.information13;
880: End If;
881: If (p_rec.information14 = hr_api.g_varchar2) then
882: p_rec.information14 :=
883: per_ctk_shd.g_old_rec.information14;
884: End If;
885: If (p_rec.information15 = hr_api.g_varchar2) then
886: p_rec.information15 :=
887: per_ctk_shd.g_old_rec.information15;
883: per_ctk_shd.g_old_rec.information14;
884: End If;
885: If (p_rec.information15 = hr_api.g_varchar2) then
886: p_rec.information15 :=
887: per_ctk_shd.g_old_rec.information15;
888: End If;
889: If (p_rec.information16 = hr_api.g_varchar2) then
890: p_rec.information16 :=
891: per_ctk_shd.g_old_rec.information16;
887: per_ctk_shd.g_old_rec.information15;
888: End If;
889: If (p_rec.information16 = hr_api.g_varchar2) then
890: p_rec.information16 :=
891: per_ctk_shd.g_old_rec.information16;
892: End If;
893: If (p_rec.information17 = hr_api.g_varchar2) then
894: p_rec.information17 :=
895: per_ctk_shd.g_old_rec.information17;
891: per_ctk_shd.g_old_rec.information16;
892: End If;
893: If (p_rec.information17 = hr_api.g_varchar2) then
894: p_rec.information17 :=
895: per_ctk_shd.g_old_rec.information17;
896: End If;
897: If (p_rec.information18 = hr_api.g_varchar2) then
898: p_rec.information18 :=
899: per_ctk_shd.g_old_rec.information18;
895: per_ctk_shd.g_old_rec.information17;
896: End If;
897: If (p_rec.information18 = hr_api.g_varchar2) then
898: p_rec.information18 :=
899: per_ctk_shd.g_old_rec.information18;
900: End If;
901: If (p_rec.information19 = hr_api.g_varchar2) then
902: p_rec.information19 :=
903: per_ctk_shd.g_old_rec.information19;
899: per_ctk_shd.g_old_rec.information18;
900: End If;
901: If (p_rec.information19 = hr_api.g_varchar2) then
902: p_rec.information19 :=
903: per_ctk_shd.g_old_rec.information19;
904: End If;
905: If (p_rec.information20 = hr_api.g_varchar2) then
906: p_rec.information20 :=
907: per_ctk_shd.g_old_rec.information20;
903: per_ctk_shd.g_old_rec.information19;
904: End If;
905: If (p_rec.information20 = hr_api.g_varchar2) then
906: p_rec.information20 :=
907: per_ctk_shd.g_old_rec.information20;
908: End If;
909: --
910: End convert_defs;
911: --
913: -- |---------------------------------< upd >----------------------------------|
914: -- ----------------------------------------------------------------------------
915: Procedure upd
916: (p_effective_date in date
917: ,p_rec in out nocopy per_ctk_shd.g_rec_type
918: ) is
919: --
920: l_proc varchar2(72) := g_package||'upd';
921: --
923: hr_utility.set_location('Entering:'||l_proc, 5);
924: --
925: -- We must lock the row which we need to update.
926: --
927: per_ctk_shd.lck
928: (p_rec.task_in_checklist_id
929: ,p_rec.object_version_number
930: );
931: --
1024: ,p_information19 in varchar2 default hr_api.g_varchar2
1025: ,p_information20 in varchar2 default hr_api.g_varchar2
1026: ) is
1027: --
1028: l_rec per_ctk_shd.g_rec_type;
1029: l_proc varchar2(72) := g_package||'upd';
1030: --
1031: Begin
1032: hr_utility.set_location('Entering:'||l_proc, 5);
1034: -- Call conversion function to turn arguments into the
1035: -- l_rec structure.
1036: --
1037: l_rec :=
1038: per_ctk_shd.convert_args
1039: (p_task_in_checklist_id
1040: ,p_checklist_id
1041: ,p_checklist_task_name
1042: ,p_eligibility_object_id