eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_CTK_UPD dependencies on HR_API

Line 135: When hr_api.check_integrity_violated Then

131: --
132: hr_utility.set_location(' Leaving:'||l_proc, 10);
133: --
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));

Line 139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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: --
143: per_ctk_shd.constraint_error

Line 140: When hr_api.parent_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: --
143: per_ctk_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 144: (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: --
148: per_ctk_shd.constraint_error

Line 145: When hr_api.unique_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: --
148: per_ctk_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 149: (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;
153: End update_dml;

Line 247: if ( nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number AND

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);

Line 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

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;

Line 307: if ((nvl(per_ctk_shd.g_old_rec.eligibility_profile_id, hr_api.g_number)= hr_api.g_number AND

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

Line 308: nvl(p_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number ))

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
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))

Line 310: (nvl(per_ctk_shd.g_old_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:

Line 311: nvl(p_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number AND

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:
315: open c_elig_prfl_dates(p_rec.eligibility_profile_id);

Line 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))

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;

Line 632: when hr_api.cannot_find_prog_unit then

628: );
629: --
630: exception
631: --
632: when hr_api.cannot_find_prog_unit then
633: --
634: hr_api.cannot_find_prog_unit_error
635: (p_module_name => 'PER_TASKS_IN_CHECKLIST'
636: ,p_hook_type => 'AU');

Line 634: hr_api.cannot_find_prog_unit_error

630: exception
631: --
632: when hr_api.cannot_find_prog_unit then
633: --
634: hr_api.cannot_find_prog_unit_error
635: (p_module_name => 'PER_TASKS_IN_CHECKLIST'
636: ,p_hook_type => 'AU');
637: --
638: end;

Line 697: If (p_rec.checklist_id = hr_api.g_number) then

693: -- p_rec plsql record structure
694: -- to see if a system default is being used. If a system default
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

Line 701: If (p_rec.checklist_task_name = hr_api.g_varchar2) then

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;
704: End If;
705: If (p_rec.eligibility_object_id = hr_api.g_number) then

Line 705: If (p_rec.eligibility_object_id = hr_api.g_number) then

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;
708: End If;
709: If (p_rec.eligibility_profile_id = hr_api.g_number) then

Line 709: If (p_rec.eligibility_profile_id = hr_api.g_number) then

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;
712: End If;
713: If (p_rec.ame_attribute_identifier = hr_api.g_varchar2) then

Line 713: If (p_rec.ame_attribute_identifier = hr_api.g_varchar2) then

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;
716: End If;
717: If (p_rec.description = hr_api.g_varchar2) then

Line 717: If (p_rec.description = hr_api.g_varchar2) then

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;
720: End If;
721: If (p_rec.mandatory_flag = hr_api.g_varchar2) then

Line 721: If (p_rec.mandatory_flag = hr_api.g_varchar2) then

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;
724: End If;
725: If (p_rec.target_duration = hr_api.g_number) then

Line 725: If (p_rec.target_duration = hr_api.g_number) then

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;
728: End If;
729: If (p_rec.target_duration_uom = hr_api.g_varchar2) then

Line 729: If (p_rec.target_duration_uom = hr_api.g_varchar2) then

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;
732: End If;
733: If (p_rec.task_sequence = hr_api.g_number) then

Line 733: If (p_rec.task_sequence = hr_api.g_number) then

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;
736: End If;
737: If (p_rec.action_url = hr_api.g_varchar2) then

Line 737: If (p_rec.action_url = hr_api.g_varchar2) then

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;
740: End If;
741: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 741: If (p_rec.attribute_category = hr_api.g_varchar2) then

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;
744: End If;
745: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 745: If (p_rec.attribute1 = hr_api.g_varchar2) then

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;
748: End If;
749: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 749: If (p_rec.attribute2 = hr_api.g_varchar2) then

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;
752: End If;
753: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 753: If (p_rec.attribute3 = hr_api.g_varchar2) then

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;
756: End If;
757: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 757: If (p_rec.attribute4 = hr_api.g_varchar2) then

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;
760: End If;
761: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 761: If (p_rec.attribute5 = hr_api.g_varchar2) then

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;
764: End If;
765: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 765: If (p_rec.attribute6 = hr_api.g_varchar2) then

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;
768: End If;
769: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 769: If (p_rec.attribute7 = hr_api.g_varchar2) then

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;
772: End If;
773: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 773: If (p_rec.attribute8 = hr_api.g_varchar2) then

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;
776: End If;
777: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 777: If (p_rec.attribute9 = hr_api.g_varchar2) then

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;
780: End If;
781: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 781: If (p_rec.attribute10 = hr_api.g_varchar2) then

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;
784: End If;
785: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 785: If (p_rec.attribute11 = hr_api.g_varchar2) then

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;
788: End If;
789: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 789: If (p_rec.attribute12 = hr_api.g_varchar2) then

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;
792: End If;
793: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 793: If (p_rec.attribute13 = hr_api.g_varchar2) then

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;
796: End If;
797: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 797: If (p_rec.attribute14 = hr_api.g_varchar2) then

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;
800: End If;
801: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 801: If (p_rec.attribute15 = hr_api.g_varchar2) then

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;
804: End If;
805: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 805: If (p_rec.attribute16 = hr_api.g_varchar2) then

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;
808: End If;
809: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 809: If (p_rec.attribute17 = hr_api.g_varchar2) then

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;
812: End If;
813: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 813: If (p_rec.attribute18 = hr_api.g_varchar2) then

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;
816: End If;
817: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 817: If (p_rec.attribute19 = hr_api.g_varchar2) then

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;
820: End If;
821: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 821: If (p_rec.attribute20 = hr_api.g_varchar2) then

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;
824: End If;
825: If (p_rec.information_category = hr_api.g_varchar2) then

Line 825: If (p_rec.information_category = hr_api.g_varchar2) then

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;
828: End If;
829: If (p_rec.information1 = hr_api.g_varchar2) then

Line 829: If (p_rec.information1 = hr_api.g_varchar2) then

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;
832: End If;
833: If (p_rec.information2 = hr_api.g_varchar2) then

Line 833: If (p_rec.information2 = hr_api.g_varchar2) then

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;
836: End If;
837: If (p_rec.information3 = hr_api.g_varchar2) then

Line 837: If (p_rec.information3 = hr_api.g_varchar2) then

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;
840: End If;
841: If (p_rec.information4 = hr_api.g_varchar2) then

Line 841: If (p_rec.information4 = hr_api.g_varchar2) then

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;
844: End If;
845: If (p_rec.information5 = hr_api.g_varchar2) then

Line 845: If (p_rec.information5 = hr_api.g_varchar2) then

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;
848: End If;
849: If (p_rec.information6 = hr_api.g_varchar2) then

Line 849: If (p_rec.information6 = hr_api.g_varchar2) then

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;
852: End If;
853: If (p_rec.information7 = hr_api.g_varchar2) then

Line 853: If (p_rec.information7 = hr_api.g_varchar2) then

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;
856: End If;
857: If (p_rec.information8 = hr_api.g_varchar2) then

Line 857: If (p_rec.information8 = hr_api.g_varchar2) then

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;
860: End If;
861: If (p_rec.information9 = hr_api.g_varchar2) then

Line 861: If (p_rec.information9 = hr_api.g_varchar2) then

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;
864: End If;
865: If (p_rec.information10 = hr_api.g_varchar2) then

Line 865: If (p_rec.information10 = hr_api.g_varchar2) then

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;
868: End If;
869: If (p_rec.information11 = hr_api.g_varchar2) then

Line 869: If (p_rec.information11 = hr_api.g_varchar2) then

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;
872: End If;
873: If (p_rec.information12 = hr_api.g_varchar2) then

Line 873: If (p_rec.information12 = hr_api.g_varchar2) then

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;
876: End If;
877: If (p_rec.information13 = hr_api.g_varchar2) then

Line 877: If (p_rec.information13 = hr_api.g_varchar2) then

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;
880: End If;
881: If (p_rec.information14 = hr_api.g_varchar2) then

Line 881: If (p_rec.information14 = hr_api.g_varchar2) then

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;
884: End If;
885: If (p_rec.information15 = hr_api.g_varchar2) then

Line 885: If (p_rec.information15 = hr_api.g_varchar2) then

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;
888: End If;
889: If (p_rec.information16 = hr_api.g_varchar2) then

Line 889: If (p_rec.information16 = hr_api.g_varchar2) then

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;
892: End If;
893: If (p_rec.information17 = hr_api.g_varchar2) then

Line 893: If (p_rec.information17 = hr_api.g_varchar2) then

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;
896: End If;
897: If (p_rec.information18 = hr_api.g_varchar2) then

Line 897: If (p_rec.information18 = hr_api.g_varchar2) then

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;
900: End If;
901: If (p_rec.information19 = hr_api.g_varchar2) then

Line 901: If (p_rec.information19 = hr_api.g_varchar2) then

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;
904: End If;
905: If (p_rec.information20 = hr_api.g_varchar2) then

Line 905: If (p_rec.information20 = hr_api.g_varchar2) then

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;
908: End If;
909: --

Line 973: ,p_checklist_id in number default hr_api.g_number

969: Procedure upd
970: (p_effective_date in date
971: ,p_task_in_checklist_id in number
972: ,p_object_version_number in out nocopy number
973: ,p_checklist_id in number default hr_api.g_number
974: ,p_checklist_task_name in varchar2 default hr_api.g_varchar2
975: ,p_eligibility_object_id in number default hr_api.g_number
976: ,p_eligibility_profile_id in number default hr_api.g_number
977: ,p_ame_attribute_identifier in varchar2 default hr_api.g_varchar2

Line 974: ,p_checklist_task_name in varchar2 default hr_api.g_varchar2

970: (p_effective_date in date
971: ,p_task_in_checklist_id in number
972: ,p_object_version_number in out nocopy number
973: ,p_checklist_id in number default hr_api.g_number
974: ,p_checklist_task_name in varchar2 default hr_api.g_varchar2
975: ,p_eligibility_object_id in number default hr_api.g_number
976: ,p_eligibility_profile_id in number default hr_api.g_number
977: ,p_ame_attribute_identifier in varchar2 default hr_api.g_varchar2
978: ,p_description in varchar2 default hr_api.g_varchar2

Line 975: ,p_eligibility_object_id in number default hr_api.g_number

971: ,p_task_in_checklist_id in number
972: ,p_object_version_number in out nocopy number
973: ,p_checklist_id in number default hr_api.g_number
974: ,p_checklist_task_name in varchar2 default hr_api.g_varchar2
975: ,p_eligibility_object_id in number default hr_api.g_number
976: ,p_eligibility_profile_id in number default hr_api.g_number
977: ,p_ame_attribute_identifier in varchar2 default hr_api.g_varchar2
978: ,p_description in varchar2 default hr_api.g_varchar2
979: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2

Line 976: ,p_eligibility_profile_id in number default hr_api.g_number

972: ,p_object_version_number in out nocopy number
973: ,p_checklist_id in number default hr_api.g_number
974: ,p_checklist_task_name in varchar2 default hr_api.g_varchar2
975: ,p_eligibility_object_id in number default hr_api.g_number
976: ,p_eligibility_profile_id in number default hr_api.g_number
977: ,p_ame_attribute_identifier in varchar2 default hr_api.g_varchar2
978: ,p_description in varchar2 default hr_api.g_varchar2
979: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
980: ,p_target_duration in number default hr_api.g_number

Line 977: ,p_ame_attribute_identifier in varchar2 default hr_api.g_varchar2

973: ,p_checklist_id in number default hr_api.g_number
974: ,p_checklist_task_name in varchar2 default hr_api.g_varchar2
975: ,p_eligibility_object_id in number default hr_api.g_number
976: ,p_eligibility_profile_id in number default hr_api.g_number
977: ,p_ame_attribute_identifier in varchar2 default hr_api.g_varchar2
978: ,p_description in varchar2 default hr_api.g_varchar2
979: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
980: ,p_target_duration in number default hr_api.g_number
981: ,p_target_duration_uom in varchar2 default hr_api.g_varchar2

Line 978: ,p_description in varchar2 default hr_api.g_varchar2

974: ,p_checklist_task_name in varchar2 default hr_api.g_varchar2
975: ,p_eligibility_object_id in number default hr_api.g_number
976: ,p_eligibility_profile_id in number default hr_api.g_number
977: ,p_ame_attribute_identifier in varchar2 default hr_api.g_varchar2
978: ,p_description in varchar2 default hr_api.g_varchar2
979: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
980: ,p_target_duration in number default hr_api.g_number
981: ,p_target_duration_uom in varchar2 default hr_api.g_varchar2
982: ,p_task_sequence in number default hr_api.g_number

Line 979: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2

975: ,p_eligibility_object_id in number default hr_api.g_number
976: ,p_eligibility_profile_id in number default hr_api.g_number
977: ,p_ame_attribute_identifier in varchar2 default hr_api.g_varchar2
978: ,p_description in varchar2 default hr_api.g_varchar2
979: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
980: ,p_target_duration in number default hr_api.g_number
981: ,p_target_duration_uom in varchar2 default hr_api.g_varchar2
982: ,p_task_sequence in number default hr_api.g_number
983: ,p_action_url in varchar2 default hr_api.g_varchar2

Line 980: ,p_target_duration in number default hr_api.g_number

976: ,p_eligibility_profile_id in number default hr_api.g_number
977: ,p_ame_attribute_identifier in varchar2 default hr_api.g_varchar2
978: ,p_description in varchar2 default hr_api.g_varchar2
979: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
980: ,p_target_duration in number default hr_api.g_number
981: ,p_target_duration_uom in varchar2 default hr_api.g_varchar2
982: ,p_task_sequence in number default hr_api.g_number
983: ,p_action_url in varchar2 default hr_api.g_varchar2
984: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 981: ,p_target_duration_uom in varchar2 default hr_api.g_varchar2

977: ,p_ame_attribute_identifier in varchar2 default hr_api.g_varchar2
978: ,p_description in varchar2 default hr_api.g_varchar2
979: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
980: ,p_target_duration in number default hr_api.g_number
981: ,p_target_duration_uom in varchar2 default hr_api.g_varchar2
982: ,p_task_sequence in number default hr_api.g_number
983: ,p_action_url in varchar2 default hr_api.g_varchar2
984: ,p_attribute_category in varchar2 default hr_api.g_varchar2
985: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 982: ,p_task_sequence in number default hr_api.g_number

978: ,p_description in varchar2 default hr_api.g_varchar2
979: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
980: ,p_target_duration in number default hr_api.g_number
981: ,p_target_duration_uom in varchar2 default hr_api.g_varchar2
982: ,p_task_sequence in number default hr_api.g_number
983: ,p_action_url in varchar2 default hr_api.g_varchar2
984: ,p_attribute_category in varchar2 default hr_api.g_varchar2
985: ,p_attribute1 in varchar2 default hr_api.g_varchar2
986: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 983: ,p_action_url in varchar2 default hr_api.g_varchar2

979: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
980: ,p_target_duration in number default hr_api.g_number
981: ,p_target_duration_uom in varchar2 default hr_api.g_varchar2
982: ,p_task_sequence in number default hr_api.g_number
983: ,p_action_url in varchar2 default hr_api.g_varchar2
984: ,p_attribute_category in varchar2 default hr_api.g_varchar2
985: ,p_attribute1 in varchar2 default hr_api.g_varchar2
986: ,p_attribute2 in varchar2 default hr_api.g_varchar2
987: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 984: ,p_attribute_category in varchar2 default hr_api.g_varchar2

980: ,p_target_duration in number default hr_api.g_number
981: ,p_target_duration_uom in varchar2 default hr_api.g_varchar2
982: ,p_task_sequence in number default hr_api.g_number
983: ,p_action_url in varchar2 default hr_api.g_varchar2
984: ,p_attribute_category in varchar2 default hr_api.g_varchar2
985: ,p_attribute1 in varchar2 default hr_api.g_varchar2
986: ,p_attribute2 in varchar2 default hr_api.g_varchar2
987: ,p_attribute3 in varchar2 default hr_api.g_varchar2
988: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 985: ,p_attribute1 in varchar2 default hr_api.g_varchar2

981: ,p_target_duration_uom in varchar2 default hr_api.g_varchar2
982: ,p_task_sequence in number default hr_api.g_number
983: ,p_action_url in varchar2 default hr_api.g_varchar2
984: ,p_attribute_category in varchar2 default hr_api.g_varchar2
985: ,p_attribute1 in varchar2 default hr_api.g_varchar2
986: ,p_attribute2 in varchar2 default hr_api.g_varchar2
987: ,p_attribute3 in varchar2 default hr_api.g_varchar2
988: ,p_attribute4 in varchar2 default hr_api.g_varchar2
989: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 986: ,p_attribute2 in varchar2 default hr_api.g_varchar2

982: ,p_task_sequence in number default hr_api.g_number
983: ,p_action_url in varchar2 default hr_api.g_varchar2
984: ,p_attribute_category in varchar2 default hr_api.g_varchar2
985: ,p_attribute1 in varchar2 default hr_api.g_varchar2
986: ,p_attribute2 in varchar2 default hr_api.g_varchar2
987: ,p_attribute3 in varchar2 default hr_api.g_varchar2
988: ,p_attribute4 in varchar2 default hr_api.g_varchar2
989: ,p_attribute5 in varchar2 default hr_api.g_varchar2
990: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 987: ,p_attribute3 in varchar2 default hr_api.g_varchar2

983: ,p_action_url in varchar2 default hr_api.g_varchar2
984: ,p_attribute_category in varchar2 default hr_api.g_varchar2
985: ,p_attribute1 in varchar2 default hr_api.g_varchar2
986: ,p_attribute2 in varchar2 default hr_api.g_varchar2
987: ,p_attribute3 in varchar2 default hr_api.g_varchar2
988: ,p_attribute4 in varchar2 default hr_api.g_varchar2
989: ,p_attribute5 in varchar2 default hr_api.g_varchar2
990: ,p_attribute6 in varchar2 default hr_api.g_varchar2
991: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 988: ,p_attribute4 in varchar2 default hr_api.g_varchar2

984: ,p_attribute_category in varchar2 default hr_api.g_varchar2
985: ,p_attribute1 in varchar2 default hr_api.g_varchar2
986: ,p_attribute2 in varchar2 default hr_api.g_varchar2
987: ,p_attribute3 in varchar2 default hr_api.g_varchar2
988: ,p_attribute4 in varchar2 default hr_api.g_varchar2
989: ,p_attribute5 in varchar2 default hr_api.g_varchar2
990: ,p_attribute6 in varchar2 default hr_api.g_varchar2
991: ,p_attribute7 in varchar2 default hr_api.g_varchar2
992: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 989: ,p_attribute5 in varchar2 default hr_api.g_varchar2

985: ,p_attribute1 in varchar2 default hr_api.g_varchar2
986: ,p_attribute2 in varchar2 default hr_api.g_varchar2
987: ,p_attribute3 in varchar2 default hr_api.g_varchar2
988: ,p_attribute4 in varchar2 default hr_api.g_varchar2
989: ,p_attribute5 in varchar2 default hr_api.g_varchar2
990: ,p_attribute6 in varchar2 default hr_api.g_varchar2
991: ,p_attribute7 in varchar2 default hr_api.g_varchar2
992: ,p_attribute8 in varchar2 default hr_api.g_varchar2
993: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 990: ,p_attribute6 in varchar2 default hr_api.g_varchar2

986: ,p_attribute2 in varchar2 default hr_api.g_varchar2
987: ,p_attribute3 in varchar2 default hr_api.g_varchar2
988: ,p_attribute4 in varchar2 default hr_api.g_varchar2
989: ,p_attribute5 in varchar2 default hr_api.g_varchar2
990: ,p_attribute6 in varchar2 default hr_api.g_varchar2
991: ,p_attribute7 in varchar2 default hr_api.g_varchar2
992: ,p_attribute8 in varchar2 default hr_api.g_varchar2
993: ,p_attribute9 in varchar2 default hr_api.g_varchar2
994: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 991: ,p_attribute7 in varchar2 default hr_api.g_varchar2

987: ,p_attribute3 in varchar2 default hr_api.g_varchar2
988: ,p_attribute4 in varchar2 default hr_api.g_varchar2
989: ,p_attribute5 in varchar2 default hr_api.g_varchar2
990: ,p_attribute6 in varchar2 default hr_api.g_varchar2
991: ,p_attribute7 in varchar2 default hr_api.g_varchar2
992: ,p_attribute8 in varchar2 default hr_api.g_varchar2
993: ,p_attribute9 in varchar2 default hr_api.g_varchar2
994: ,p_attribute10 in varchar2 default hr_api.g_varchar2
995: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 992: ,p_attribute8 in varchar2 default hr_api.g_varchar2

988: ,p_attribute4 in varchar2 default hr_api.g_varchar2
989: ,p_attribute5 in varchar2 default hr_api.g_varchar2
990: ,p_attribute6 in varchar2 default hr_api.g_varchar2
991: ,p_attribute7 in varchar2 default hr_api.g_varchar2
992: ,p_attribute8 in varchar2 default hr_api.g_varchar2
993: ,p_attribute9 in varchar2 default hr_api.g_varchar2
994: ,p_attribute10 in varchar2 default hr_api.g_varchar2
995: ,p_attribute11 in varchar2 default hr_api.g_varchar2
996: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 993: ,p_attribute9 in varchar2 default hr_api.g_varchar2

989: ,p_attribute5 in varchar2 default hr_api.g_varchar2
990: ,p_attribute6 in varchar2 default hr_api.g_varchar2
991: ,p_attribute7 in varchar2 default hr_api.g_varchar2
992: ,p_attribute8 in varchar2 default hr_api.g_varchar2
993: ,p_attribute9 in varchar2 default hr_api.g_varchar2
994: ,p_attribute10 in varchar2 default hr_api.g_varchar2
995: ,p_attribute11 in varchar2 default hr_api.g_varchar2
996: ,p_attribute12 in varchar2 default hr_api.g_varchar2
997: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 994: ,p_attribute10 in varchar2 default hr_api.g_varchar2

990: ,p_attribute6 in varchar2 default hr_api.g_varchar2
991: ,p_attribute7 in varchar2 default hr_api.g_varchar2
992: ,p_attribute8 in varchar2 default hr_api.g_varchar2
993: ,p_attribute9 in varchar2 default hr_api.g_varchar2
994: ,p_attribute10 in varchar2 default hr_api.g_varchar2
995: ,p_attribute11 in varchar2 default hr_api.g_varchar2
996: ,p_attribute12 in varchar2 default hr_api.g_varchar2
997: ,p_attribute13 in varchar2 default hr_api.g_varchar2
998: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 995: ,p_attribute11 in varchar2 default hr_api.g_varchar2

991: ,p_attribute7 in varchar2 default hr_api.g_varchar2
992: ,p_attribute8 in varchar2 default hr_api.g_varchar2
993: ,p_attribute9 in varchar2 default hr_api.g_varchar2
994: ,p_attribute10 in varchar2 default hr_api.g_varchar2
995: ,p_attribute11 in varchar2 default hr_api.g_varchar2
996: ,p_attribute12 in varchar2 default hr_api.g_varchar2
997: ,p_attribute13 in varchar2 default hr_api.g_varchar2
998: ,p_attribute14 in varchar2 default hr_api.g_varchar2
999: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 996: ,p_attribute12 in varchar2 default hr_api.g_varchar2

992: ,p_attribute8 in varchar2 default hr_api.g_varchar2
993: ,p_attribute9 in varchar2 default hr_api.g_varchar2
994: ,p_attribute10 in varchar2 default hr_api.g_varchar2
995: ,p_attribute11 in varchar2 default hr_api.g_varchar2
996: ,p_attribute12 in varchar2 default hr_api.g_varchar2
997: ,p_attribute13 in varchar2 default hr_api.g_varchar2
998: ,p_attribute14 in varchar2 default hr_api.g_varchar2
999: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1000: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 997: ,p_attribute13 in varchar2 default hr_api.g_varchar2

993: ,p_attribute9 in varchar2 default hr_api.g_varchar2
994: ,p_attribute10 in varchar2 default hr_api.g_varchar2
995: ,p_attribute11 in varchar2 default hr_api.g_varchar2
996: ,p_attribute12 in varchar2 default hr_api.g_varchar2
997: ,p_attribute13 in varchar2 default hr_api.g_varchar2
998: ,p_attribute14 in varchar2 default hr_api.g_varchar2
999: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1000: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1001: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 998: ,p_attribute14 in varchar2 default hr_api.g_varchar2

994: ,p_attribute10 in varchar2 default hr_api.g_varchar2
995: ,p_attribute11 in varchar2 default hr_api.g_varchar2
996: ,p_attribute12 in varchar2 default hr_api.g_varchar2
997: ,p_attribute13 in varchar2 default hr_api.g_varchar2
998: ,p_attribute14 in varchar2 default hr_api.g_varchar2
999: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1000: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1001: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1002: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 999: ,p_attribute15 in varchar2 default hr_api.g_varchar2

995: ,p_attribute11 in varchar2 default hr_api.g_varchar2
996: ,p_attribute12 in varchar2 default hr_api.g_varchar2
997: ,p_attribute13 in varchar2 default hr_api.g_varchar2
998: ,p_attribute14 in varchar2 default hr_api.g_varchar2
999: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1000: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1001: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1002: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1003: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 1000: ,p_attribute16 in varchar2 default hr_api.g_varchar2

996: ,p_attribute12 in varchar2 default hr_api.g_varchar2
997: ,p_attribute13 in varchar2 default hr_api.g_varchar2
998: ,p_attribute14 in varchar2 default hr_api.g_varchar2
999: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1000: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1001: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1002: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1003: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 1001: ,p_attribute17 in varchar2 default hr_api.g_varchar2

997: ,p_attribute13 in varchar2 default hr_api.g_varchar2
998: ,p_attribute14 in varchar2 default hr_api.g_varchar2
999: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1000: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1001: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1002: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1003: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1005: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 1002: ,p_attribute18 in varchar2 default hr_api.g_varchar2

998: ,p_attribute14 in varchar2 default hr_api.g_varchar2
999: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1000: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1001: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1002: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1003: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1005: ,p_information_category in varchar2 default hr_api.g_varchar2
1006: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 1003: ,p_attribute19 in varchar2 default hr_api.g_varchar2

999: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1000: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1001: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1002: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1003: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1005: ,p_information_category in varchar2 default hr_api.g_varchar2
1006: ,p_information1 in varchar2 default hr_api.g_varchar2
1007: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 1004: ,p_attribute20 in varchar2 default hr_api.g_varchar2

1000: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1001: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1002: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1003: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1005: ,p_information_category in varchar2 default hr_api.g_varchar2
1006: ,p_information1 in varchar2 default hr_api.g_varchar2
1007: ,p_information2 in varchar2 default hr_api.g_varchar2
1008: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 1005: ,p_information_category in varchar2 default hr_api.g_varchar2

1001: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1002: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1003: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1005: ,p_information_category in varchar2 default hr_api.g_varchar2
1006: ,p_information1 in varchar2 default hr_api.g_varchar2
1007: ,p_information2 in varchar2 default hr_api.g_varchar2
1008: ,p_information3 in varchar2 default hr_api.g_varchar2
1009: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 1006: ,p_information1 in varchar2 default hr_api.g_varchar2

1002: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1003: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1005: ,p_information_category in varchar2 default hr_api.g_varchar2
1006: ,p_information1 in varchar2 default hr_api.g_varchar2
1007: ,p_information2 in varchar2 default hr_api.g_varchar2
1008: ,p_information3 in varchar2 default hr_api.g_varchar2
1009: ,p_information4 in varchar2 default hr_api.g_varchar2
1010: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 1007: ,p_information2 in varchar2 default hr_api.g_varchar2

1003: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1004: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1005: ,p_information_category in varchar2 default hr_api.g_varchar2
1006: ,p_information1 in varchar2 default hr_api.g_varchar2
1007: ,p_information2 in varchar2 default hr_api.g_varchar2
1008: ,p_information3 in varchar2 default hr_api.g_varchar2
1009: ,p_information4 in varchar2 default hr_api.g_varchar2
1010: ,p_information5 in varchar2 default hr_api.g_varchar2
1011: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 1008: ,p_information3 in varchar2 default hr_api.g_varchar2

1004: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1005: ,p_information_category in varchar2 default hr_api.g_varchar2
1006: ,p_information1 in varchar2 default hr_api.g_varchar2
1007: ,p_information2 in varchar2 default hr_api.g_varchar2
1008: ,p_information3 in varchar2 default hr_api.g_varchar2
1009: ,p_information4 in varchar2 default hr_api.g_varchar2
1010: ,p_information5 in varchar2 default hr_api.g_varchar2
1011: ,p_information6 in varchar2 default hr_api.g_varchar2
1012: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 1009: ,p_information4 in varchar2 default hr_api.g_varchar2

1005: ,p_information_category in varchar2 default hr_api.g_varchar2
1006: ,p_information1 in varchar2 default hr_api.g_varchar2
1007: ,p_information2 in varchar2 default hr_api.g_varchar2
1008: ,p_information3 in varchar2 default hr_api.g_varchar2
1009: ,p_information4 in varchar2 default hr_api.g_varchar2
1010: ,p_information5 in varchar2 default hr_api.g_varchar2
1011: ,p_information6 in varchar2 default hr_api.g_varchar2
1012: ,p_information7 in varchar2 default hr_api.g_varchar2
1013: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 1010: ,p_information5 in varchar2 default hr_api.g_varchar2

1006: ,p_information1 in varchar2 default hr_api.g_varchar2
1007: ,p_information2 in varchar2 default hr_api.g_varchar2
1008: ,p_information3 in varchar2 default hr_api.g_varchar2
1009: ,p_information4 in varchar2 default hr_api.g_varchar2
1010: ,p_information5 in varchar2 default hr_api.g_varchar2
1011: ,p_information6 in varchar2 default hr_api.g_varchar2
1012: ,p_information7 in varchar2 default hr_api.g_varchar2
1013: ,p_information8 in varchar2 default hr_api.g_varchar2
1014: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 1011: ,p_information6 in varchar2 default hr_api.g_varchar2

1007: ,p_information2 in varchar2 default hr_api.g_varchar2
1008: ,p_information3 in varchar2 default hr_api.g_varchar2
1009: ,p_information4 in varchar2 default hr_api.g_varchar2
1010: ,p_information5 in varchar2 default hr_api.g_varchar2
1011: ,p_information6 in varchar2 default hr_api.g_varchar2
1012: ,p_information7 in varchar2 default hr_api.g_varchar2
1013: ,p_information8 in varchar2 default hr_api.g_varchar2
1014: ,p_information9 in varchar2 default hr_api.g_varchar2
1015: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 1012: ,p_information7 in varchar2 default hr_api.g_varchar2

1008: ,p_information3 in varchar2 default hr_api.g_varchar2
1009: ,p_information4 in varchar2 default hr_api.g_varchar2
1010: ,p_information5 in varchar2 default hr_api.g_varchar2
1011: ,p_information6 in varchar2 default hr_api.g_varchar2
1012: ,p_information7 in varchar2 default hr_api.g_varchar2
1013: ,p_information8 in varchar2 default hr_api.g_varchar2
1014: ,p_information9 in varchar2 default hr_api.g_varchar2
1015: ,p_information10 in varchar2 default hr_api.g_varchar2
1016: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 1013: ,p_information8 in varchar2 default hr_api.g_varchar2

1009: ,p_information4 in varchar2 default hr_api.g_varchar2
1010: ,p_information5 in varchar2 default hr_api.g_varchar2
1011: ,p_information6 in varchar2 default hr_api.g_varchar2
1012: ,p_information7 in varchar2 default hr_api.g_varchar2
1013: ,p_information8 in varchar2 default hr_api.g_varchar2
1014: ,p_information9 in varchar2 default hr_api.g_varchar2
1015: ,p_information10 in varchar2 default hr_api.g_varchar2
1016: ,p_information11 in varchar2 default hr_api.g_varchar2
1017: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 1014: ,p_information9 in varchar2 default hr_api.g_varchar2

1010: ,p_information5 in varchar2 default hr_api.g_varchar2
1011: ,p_information6 in varchar2 default hr_api.g_varchar2
1012: ,p_information7 in varchar2 default hr_api.g_varchar2
1013: ,p_information8 in varchar2 default hr_api.g_varchar2
1014: ,p_information9 in varchar2 default hr_api.g_varchar2
1015: ,p_information10 in varchar2 default hr_api.g_varchar2
1016: ,p_information11 in varchar2 default hr_api.g_varchar2
1017: ,p_information12 in varchar2 default hr_api.g_varchar2
1018: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 1015: ,p_information10 in varchar2 default hr_api.g_varchar2

1011: ,p_information6 in varchar2 default hr_api.g_varchar2
1012: ,p_information7 in varchar2 default hr_api.g_varchar2
1013: ,p_information8 in varchar2 default hr_api.g_varchar2
1014: ,p_information9 in varchar2 default hr_api.g_varchar2
1015: ,p_information10 in varchar2 default hr_api.g_varchar2
1016: ,p_information11 in varchar2 default hr_api.g_varchar2
1017: ,p_information12 in varchar2 default hr_api.g_varchar2
1018: ,p_information13 in varchar2 default hr_api.g_varchar2
1019: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 1016: ,p_information11 in varchar2 default hr_api.g_varchar2

1012: ,p_information7 in varchar2 default hr_api.g_varchar2
1013: ,p_information8 in varchar2 default hr_api.g_varchar2
1014: ,p_information9 in varchar2 default hr_api.g_varchar2
1015: ,p_information10 in varchar2 default hr_api.g_varchar2
1016: ,p_information11 in varchar2 default hr_api.g_varchar2
1017: ,p_information12 in varchar2 default hr_api.g_varchar2
1018: ,p_information13 in varchar2 default hr_api.g_varchar2
1019: ,p_information14 in varchar2 default hr_api.g_varchar2
1020: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 1017: ,p_information12 in varchar2 default hr_api.g_varchar2

1013: ,p_information8 in varchar2 default hr_api.g_varchar2
1014: ,p_information9 in varchar2 default hr_api.g_varchar2
1015: ,p_information10 in varchar2 default hr_api.g_varchar2
1016: ,p_information11 in varchar2 default hr_api.g_varchar2
1017: ,p_information12 in varchar2 default hr_api.g_varchar2
1018: ,p_information13 in varchar2 default hr_api.g_varchar2
1019: ,p_information14 in varchar2 default hr_api.g_varchar2
1020: ,p_information15 in varchar2 default hr_api.g_varchar2
1021: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 1018: ,p_information13 in varchar2 default hr_api.g_varchar2

1014: ,p_information9 in varchar2 default hr_api.g_varchar2
1015: ,p_information10 in varchar2 default hr_api.g_varchar2
1016: ,p_information11 in varchar2 default hr_api.g_varchar2
1017: ,p_information12 in varchar2 default hr_api.g_varchar2
1018: ,p_information13 in varchar2 default hr_api.g_varchar2
1019: ,p_information14 in varchar2 default hr_api.g_varchar2
1020: ,p_information15 in varchar2 default hr_api.g_varchar2
1021: ,p_information16 in varchar2 default hr_api.g_varchar2
1022: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 1019: ,p_information14 in varchar2 default hr_api.g_varchar2

1015: ,p_information10 in varchar2 default hr_api.g_varchar2
1016: ,p_information11 in varchar2 default hr_api.g_varchar2
1017: ,p_information12 in varchar2 default hr_api.g_varchar2
1018: ,p_information13 in varchar2 default hr_api.g_varchar2
1019: ,p_information14 in varchar2 default hr_api.g_varchar2
1020: ,p_information15 in varchar2 default hr_api.g_varchar2
1021: ,p_information16 in varchar2 default hr_api.g_varchar2
1022: ,p_information17 in varchar2 default hr_api.g_varchar2
1023: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 1020: ,p_information15 in varchar2 default hr_api.g_varchar2

1016: ,p_information11 in varchar2 default hr_api.g_varchar2
1017: ,p_information12 in varchar2 default hr_api.g_varchar2
1018: ,p_information13 in varchar2 default hr_api.g_varchar2
1019: ,p_information14 in varchar2 default hr_api.g_varchar2
1020: ,p_information15 in varchar2 default hr_api.g_varchar2
1021: ,p_information16 in varchar2 default hr_api.g_varchar2
1022: ,p_information17 in varchar2 default hr_api.g_varchar2
1023: ,p_information18 in varchar2 default hr_api.g_varchar2
1024: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 1021: ,p_information16 in varchar2 default hr_api.g_varchar2

1017: ,p_information12 in varchar2 default hr_api.g_varchar2
1018: ,p_information13 in varchar2 default hr_api.g_varchar2
1019: ,p_information14 in varchar2 default hr_api.g_varchar2
1020: ,p_information15 in varchar2 default hr_api.g_varchar2
1021: ,p_information16 in varchar2 default hr_api.g_varchar2
1022: ,p_information17 in varchar2 default hr_api.g_varchar2
1023: ,p_information18 in varchar2 default hr_api.g_varchar2
1024: ,p_information19 in varchar2 default hr_api.g_varchar2
1025: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 1022: ,p_information17 in varchar2 default hr_api.g_varchar2

1018: ,p_information13 in varchar2 default hr_api.g_varchar2
1019: ,p_information14 in varchar2 default hr_api.g_varchar2
1020: ,p_information15 in varchar2 default hr_api.g_varchar2
1021: ,p_information16 in varchar2 default hr_api.g_varchar2
1022: ,p_information17 in varchar2 default hr_api.g_varchar2
1023: ,p_information18 in varchar2 default hr_api.g_varchar2
1024: ,p_information19 in varchar2 default hr_api.g_varchar2
1025: ,p_information20 in varchar2 default hr_api.g_varchar2
1026: ) is

Line 1023: ,p_information18 in varchar2 default hr_api.g_varchar2

1019: ,p_information14 in varchar2 default hr_api.g_varchar2
1020: ,p_information15 in varchar2 default hr_api.g_varchar2
1021: ,p_information16 in varchar2 default hr_api.g_varchar2
1022: ,p_information17 in varchar2 default hr_api.g_varchar2
1023: ,p_information18 in varchar2 default hr_api.g_varchar2
1024: ,p_information19 in varchar2 default hr_api.g_varchar2
1025: ,p_information20 in varchar2 default hr_api.g_varchar2
1026: ) is
1027: --

Line 1024: ,p_information19 in varchar2 default hr_api.g_varchar2

1020: ,p_information15 in varchar2 default hr_api.g_varchar2
1021: ,p_information16 in varchar2 default hr_api.g_varchar2
1022: ,p_information17 in varchar2 default hr_api.g_varchar2
1023: ,p_information18 in varchar2 default hr_api.g_varchar2
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;

Line 1025: ,p_information20 in varchar2 default hr_api.g_varchar2

1021: ,p_information16 in varchar2 default hr_api.g_varchar2
1022: ,p_information17 in varchar2 default hr_api.g_varchar2
1023: ,p_information18 in varchar2 default hr_api.g_varchar2
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';