138: l_employee_number number;
139: l_npw_number number;
140: l_dummy_var varchar2(30);
141: l_dummy_boolean boolean;
142: l_phn_object_version_number per_phones.object_version_number%TYPE;
143: l_phone_id per_phones.phone_id%TYPE;
144: --
145: -- Declare additional OUT variables
146: --
139: l_npw_number number;
140: l_dummy_var varchar2(30);
141: l_dummy_boolean boolean;
142: l_phn_object_version_number per_phones.object_version_number%TYPE;
143: l_phone_id per_phones.phone_id%TYPE;
144: --
145: -- Declare additional OUT variables
146: --
147: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
816: l_employee_number number;
817: l_npw_number number;
818: l_dummy_var varchar2(30);
819: l_dummy_boolean boolean;
820: l_phn_object_version_number per_phones.object_version_number%TYPE;
821: l_phone_id per_phones.phone_id%TYPE;
822: --
823: -- Declare additional OUT variables
824: --
817: l_npw_number number;
818: l_dummy_var varchar2(30);
819: l_dummy_boolean boolean;
820: l_phn_object_version_number per_phones.object_version_number%TYPE;
821: l_phone_id per_phones.phone_id%TYPE;
822: --
823: -- Declare additional OUT variables
824: --
825: l_effective_start_date per_all_people_f.effective_start_date%TYPE;