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_DPF_UPD dependencies on PER_DPF_SHD

Line 54: Procedure update_dml(p_rec in out nocopy per_dpf_shd.g_rec_type) is

50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy per_dpf_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: per_dpf_shd.g_api_dml := true; -- Set the api dml status

61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: per_dpf_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the per_deployment_factors Row
68: --
69: update per_deployment_factors

Line 128: per_dpf_shd.g_api_dml := false; -- Unset the api dml status

124: attribute19 = p_rec.attribute19,
125: attribute20 = p_rec.attribute20
126: where deployment_factor_id = p_rec.deployment_factor_id;
127: --
128: per_dpf_shd.g_api_dml := false; -- Unset the api dml status
129: --
130: hr_utility.set_location(' Leaving:'||l_proc, 10);
131: --
132: Exception

Line 135: per_dpf_shd.g_api_dml := false; -- Unset the api dml status

131: --
132: Exception
133: When hr_api.check_integrity_violated Then
134: -- A check constraint has been violated
135: per_dpf_shd.g_api_dml := false; -- Unset the api dml status
136: per_dpf_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.parent_integrity_violated Then
139: -- Parent integrity has been violated

Line 136: per_dpf_shd.constraint_error

132: Exception
133: When hr_api.check_integrity_violated Then
134: -- A check constraint has been violated
135: per_dpf_shd.g_api_dml := false; -- Unset the api dml status
136: per_dpf_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.parent_integrity_violated Then
139: -- Parent integrity has been violated
140: per_dpf_shd.g_api_dml := false; -- Unset the api dml status

Line 140: per_dpf_shd.g_api_dml := false; -- Unset the api dml status

136: per_dpf_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.parent_integrity_violated Then
139: -- Parent integrity has been violated
140: per_dpf_shd.g_api_dml := false; -- Unset the api dml status
141: per_dpf_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated

Line 141: per_dpf_shd.constraint_error

137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.parent_integrity_violated Then
139: -- Parent integrity has been violated
140: per_dpf_shd.g_api_dml := false; -- Unset the api dml status
141: per_dpf_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
145: per_dpf_shd.g_api_dml := false; -- Unset the api dml status

Line 145: per_dpf_shd.g_api_dml := false; -- Unset the api dml status

141: per_dpf_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
145: per_dpf_shd.g_api_dml := false; -- Unset the api dml status
146: per_dpf_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When Others Then
149: per_dpf_shd.g_api_dml := false; -- Unset the api dml status

Line 146: per_dpf_shd.constraint_error

142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
145: per_dpf_shd.g_api_dml := false; -- Unset the api dml status
146: per_dpf_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When Others Then
149: per_dpf_shd.g_api_dml := false; -- Unset the api dml status
150: Raise;

Line 149: per_dpf_shd.g_api_dml := false; -- Unset the api dml status

145: per_dpf_shd.g_api_dml := false; -- Unset the api dml status
146: per_dpf_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When Others Then
149: per_dpf_shd.g_api_dml := false; -- Unset the api dml status
150: Raise;
151: End update_dml;
152: --
153: -- ----------------------------------------------------------------------------

Line 185: Procedure pre_update(p_rec in per_dpf_shd.g_rec_type) is

181: -- Internal Row Handler Use Only.
182: --
183: -- {End Of Comments}
184: -- ----------------------------------------------------------------------------
185: Procedure pre_update(p_rec in per_dpf_shd.g_rec_type) is
186: --
187: l_proc varchar2(72) := g_package||'pre_update';
188: --
189: Begin

Line 227: Procedure post_update(p_rec in per_dpf_shd.g_rec_type,p_effective_date in date) is

223: -- Internal Row Handler Use Only.
224: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure post_update(p_rec in per_dpf_shd.g_rec_type,p_effective_date in date) is
228: --
229: l_proc varchar2(72) := g_package||'post_update';
230: --
231: Begin

Line 291: p_position_id_o =>per_dpf_shd.g_old_rec.position_id,

287: p_attribute17 =>p_rec.attribute17,
288: p_attribute18 =>p_rec.attribute18,
289: p_attribute19 =>p_rec.attribute19,
290: p_attribute20 =>p_rec.attribute20,
291: p_position_id_o =>per_dpf_shd.g_old_rec.position_id,
292: p_person_id_o =>per_dpf_shd.g_old_rec.person_id,
293: p_job_id_o =>per_dpf_shd.g_old_rec.job_id,
294: p_business_group_id_o =>per_dpf_shd.g_old_rec.business_group_id,
295: p_work_any_country_o =>per_dpf_shd.g_old_rec.work_any_country,

Line 292: p_person_id_o =>per_dpf_shd.g_old_rec.person_id,

288: p_attribute18 =>p_rec.attribute18,
289: p_attribute19 =>p_rec.attribute19,
290: p_attribute20 =>p_rec.attribute20,
291: p_position_id_o =>per_dpf_shd.g_old_rec.position_id,
292: p_person_id_o =>per_dpf_shd.g_old_rec.person_id,
293: p_job_id_o =>per_dpf_shd.g_old_rec.job_id,
294: p_business_group_id_o =>per_dpf_shd.g_old_rec.business_group_id,
295: p_work_any_country_o =>per_dpf_shd.g_old_rec.work_any_country,
296: p_work_any_location_o =>per_dpf_shd.g_old_rec.work_any_location,

Line 293: p_job_id_o =>per_dpf_shd.g_old_rec.job_id,

289: p_attribute19 =>p_rec.attribute19,
290: p_attribute20 =>p_rec.attribute20,
291: p_position_id_o =>per_dpf_shd.g_old_rec.position_id,
292: p_person_id_o =>per_dpf_shd.g_old_rec.person_id,
293: p_job_id_o =>per_dpf_shd.g_old_rec.job_id,
294: p_business_group_id_o =>per_dpf_shd.g_old_rec.business_group_id,
295: p_work_any_country_o =>per_dpf_shd.g_old_rec.work_any_country,
296: p_work_any_location_o =>per_dpf_shd.g_old_rec.work_any_location,
297: p_relocate_domestically_o =>per_dpf_shd.g_old_rec.relocate_domestically,

Line 294: p_business_group_id_o =>per_dpf_shd.g_old_rec.business_group_id,

290: p_attribute20 =>p_rec.attribute20,
291: p_position_id_o =>per_dpf_shd.g_old_rec.position_id,
292: p_person_id_o =>per_dpf_shd.g_old_rec.person_id,
293: p_job_id_o =>per_dpf_shd.g_old_rec.job_id,
294: p_business_group_id_o =>per_dpf_shd.g_old_rec.business_group_id,
295: p_work_any_country_o =>per_dpf_shd.g_old_rec.work_any_country,
296: p_work_any_location_o =>per_dpf_shd.g_old_rec.work_any_location,
297: p_relocate_domestically_o =>per_dpf_shd.g_old_rec.relocate_domestically,
298: p_relocate_internationally_o =>per_dpf_shd.g_old_rec.relocate_internationally,

Line 295: p_work_any_country_o =>per_dpf_shd.g_old_rec.work_any_country,

291: p_position_id_o =>per_dpf_shd.g_old_rec.position_id,
292: p_person_id_o =>per_dpf_shd.g_old_rec.person_id,
293: p_job_id_o =>per_dpf_shd.g_old_rec.job_id,
294: p_business_group_id_o =>per_dpf_shd.g_old_rec.business_group_id,
295: p_work_any_country_o =>per_dpf_shd.g_old_rec.work_any_country,
296: p_work_any_location_o =>per_dpf_shd.g_old_rec.work_any_location,
297: p_relocate_domestically_o =>per_dpf_shd.g_old_rec.relocate_domestically,
298: p_relocate_internationally_o =>per_dpf_shd.g_old_rec.relocate_internationally,
299: p_travel_required_o =>per_dpf_shd.g_old_rec.travel_required,

Line 296: p_work_any_location_o =>per_dpf_shd.g_old_rec.work_any_location,

292: p_person_id_o =>per_dpf_shd.g_old_rec.person_id,
293: p_job_id_o =>per_dpf_shd.g_old_rec.job_id,
294: p_business_group_id_o =>per_dpf_shd.g_old_rec.business_group_id,
295: p_work_any_country_o =>per_dpf_shd.g_old_rec.work_any_country,
296: p_work_any_location_o =>per_dpf_shd.g_old_rec.work_any_location,
297: p_relocate_domestically_o =>per_dpf_shd.g_old_rec.relocate_domestically,
298: p_relocate_internationally_o =>per_dpf_shd.g_old_rec.relocate_internationally,
299: p_travel_required_o =>per_dpf_shd.g_old_rec.travel_required,
300: p_country1_o =>per_dpf_shd.g_old_rec.country1,

Line 297: p_relocate_domestically_o =>per_dpf_shd.g_old_rec.relocate_domestically,

293: p_job_id_o =>per_dpf_shd.g_old_rec.job_id,
294: p_business_group_id_o =>per_dpf_shd.g_old_rec.business_group_id,
295: p_work_any_country_o =>per_dpf_shd.g_old_rec.work_any_country,
296: p_work_any_location_o =>per_dpf_shd.g_old_rec.work_any_location,
297: p_relocate_domestically_o =>per_dpf_shd.g_old_rec.relocate_domestically,
298: p_relocate_internationally_o =>per_dpf_shd.g_old_rec.relocate_internationally,
299: p_travel_required_o =>per_dpf_shd.g_old_rec.travel_required,
300: p_country1_o =>per_dpf_shd.g_old_rec.country1,
301: p_country2_o =>per_dpf_shd.g_old_rec.country2,

Line 298: p_relocate_internationally_o =>per_dpf_shd.g_old_rec.relocate_internationally,

294: p_business_group_id_o =>per_dpf_shd.g_old_rec.business_group_id,
295: p_work_any_country_o =>per_dpf_shd.g_old_rec.work_any_country,
296: p_work_any_location_o =>per_dpf_shd.g_old_rec.work_any_location,
297: p_relocate_domestically_o =>per_dpf_shd.g_old_rec.relocate_domestically,
298: p_relocate_internationally_o =>per_dpf_shd.g_old_rec.relocate_internationally,
299: p_travel_required_o =>per_dpf_shd.g_old_rec.travel_required,
300: p_country1_o =>per_dpf_shd.g_old_rec.country1,
301: p_country2_o =>per_dpf_shd.g_old_rec.country2,
302: p_country3_o =>per_dpf_shd.g_old_rec.country3,

Line 299: p_travel_required_o =>per_dpf_shd.g_old_rec.travel_required,

295: p_work_any_country_o =>per_dpf_shd.g_old_rec.work_any_country,
296: p_work_any_location_o =>per_dpf_shd.g_old_rec.work_any_location,
297: p_relocate_domestically_o =>per_dpf_shd.g_old_rec.relocate_domestically,
298: p_relocate_internationally_o =>per_dpf_shd.g_old_rec.relocate_internationally,
299: p_travel_required_o =>per_dpf_shd.g_old_rec.travel_required,
300: p_country1_o =>per_dpf_shd.g_old_rec.country1,
301: p_country2_o =>per_dpf_shd.g_old_rec.country2,
302: p_country3_o =>per_dpf_shd.g_old_rec.country3,
303: p_work_duration_o =>per_dpf_shd.g_old_rec.work_duration,

Line 300: p_country1_o =>per_dpf_shd.g_old_rec.country1,

296: p_work_any_location_o =>per_dpf_shd.g_old_rec.work_any_location,
297: p_relocate_domestically_o =>per_dpf_shd.g_old_rec.relocate_domestically,
298: p_relocate_internationally_o =>per_dpf_shd.g_old_rec.relocate_internationally,
299: p_travel_required_o =>per_dpf_shd.g_old_rec.travel_required,
300: p_country1_o =>per_dpf_shd.g_old_rec.country1,
301: p_country2_o =>per_dpf_shd.g_old_rec.country2,
302: p_country3_o =>per_dpf_shd.g_old_rec.country3,
303: p_work_duration_o =>per_dpf_shd.g_old_rec.work_duration,
304: p_work_schedule_o =>per_dpf_shd.g_old_rec.work_schedule,

Line 301: p_country2_o =>per_dpf_shd.g_old_rec.country2,

297: p_relocate_domestically_o =>per_dpf_shd.g_old_rec.relocate_domestically,
298: p_relocate_internationally_o =>per_dpf_shd.g_old_rec.relocate_internationally,
299: p_travel_required_o =>per_dpf_shd.g_old_rec.travel_required,
300: p_country1_o =>per_dpf_shd.g_old_rec.country1,
301: p_country2_o =>per_dpf_shd.g_old_rec.country2,
302: p_country3_o =>per_dpf_shd.g_old_rec.country3,
303: p_work_duration_o =>per_dpf_shd.g_old_rec.work_duration,
304: p_work_schedule_o =>per_dpf_shd.g_old_rec.work_schedule,
305: p_work_hours_o =>per_dpf_shd.g_old_rec.work_hours,

Line 302: p_country3_o =>per_dpf_shd.g_old_rec.country3,

298: p_relocate_internationally_o =>per_dpf_shd.g_old_rec.relocate_internationally,
299: p_travel_required_o =>per_dpf_shd.g_old_rec.travel_required,
300: p_country1_o =>per_dpf_shd.g_old_rec.country1,
301: p_country2_o =>per_dpf_shd.g_old_rec.country2,
302: p_country3_o =>per_dpf_shd.g_old_rec.country3,
303: p_work_duration_o =>per_dpf_shd.g_old_rec.work_duration,
304: p_work_schedule_o =>per_dpf_shd.g_old_rec.work_schedule,
305: p_work_hours_o =>per_dpf_shd.g_old_rec.work_hours,
306: p_fte_capacity_o =>per_dpf_shd.g_old_rec.fte_capacity,

Line 303: p_work_duration_o =>per_dpf_shd.g_old_rec.work_duration,

299: p_travel_required_o =>per_dpf_shd.g_old_rec.travel_required,
300: p_country1_o =>per_dpf_shd.g_old_rec.country1,
301: p_country2_o =>per_dpf_shd.g_old_rec.country2,
302: p_country3_o =>per_dpf_shd.g_old_rec.country3,
303: p_work_duration_o =>per_dpf_shd.g_old_rec.work_duration,
304: p_work_schedule_o =>per_dpf_shd.g_old_rec.work_schedule,
305: p_work_hours_o =>per_dpf_shd.g_old_rec.work_hours,
306: p_fte_capacity_o =>per_dpf_shd.g_old_rec.fte_capacity,
307: p_visit_internationally_o =>per_dpf_shd.g_old_rec.visit_internationally,

Line 304: p_work_schedule_o =>per_dpf_shd.g_old_rec.work_schedule,

300: p_country1_o =>per_dpf_shd.g_old_rec.country1,
301: p_country2_o =>per_dpf_shd.g_old_rec.country2,
302: p_country3_o =>per_dpf_shd.g_old_rec.country3,
303: p_work_duration_o =>per_dpf_shd.g_old_rec.work_duration,
304: p_work_schedule_o =>per_dpf_shd.g_old_rec.work_schedule,
305: p_work_hours_o =>per_dpf_shd.g_old_rec.work_hours,
306: p_fte_capacity_o =>per_dpf_shd.g_old_rec.fte_capacity,
307: p_visit_internationally_o =>per_dpf_shd.g_old_rec.visit_internationally,
308: p_only_current_location_o =>per_dpf_shd.g_old_rec.only_current_location,

Line 305: p_work_hours_o =>per_dpf_shd.g_old_rec.work_hours,

301: p_country2_o =>per_dpf_shd.g_old_rec.country2,
302: p_country3_o =>per_dpf_shd.g_old_rec.country3,
303: p_work_duration_o =>per_dpf_shd.g_old_rec.work_duration,
304: p_work_schedule_o =>per_dpf_shd.g_old_rec.work_schedule,
305: p_work_hours_o =>per_dpf_shd.g_old_rec.work_hours,
306: p_fte_capacity_o =>per_dpf_shd.g_old_rec.fte_capacity,
307: p_visit_internationally_o =>per_dpf_shd.g_old_rec.visit_internationally,
308: p_only_current_location_o =>per_dpf_shd.g_old_rec.only_current_location,
309: p_no_country1_o =>per_dpf_shd.g_old_rec.no_country1,

Line 306: p_fte_capacity_o =>per_dpf_shd.g_old_rec.fte_capacity,

302: p_country3_o =>per_dpf_shd.g_old_rec.country3,
303: p_work_duration_o =>per_dpf_shd.g_old_rec.work_duration,
304: p_work_schedule_o =>per_dpf_shd.g_old_rec.work_schedule,
305: p_work_hours_o =>per_dpf_shd.g_old_rec.work_hours,
306: p_fte_capacity_o =>per_dpf_shd.g_old_rec.fte_capacity,
307: p_visit_internationally_o =>per_dpf_shd.g_old_rec.visit_internationally,
308: p_only_current_location_o =>per_dpf_shd.g_old_rec.only_current_location,
309: p_no_country1_o =>per_dpf_shd.g_old_rec.no_country1,
310: p_no_country2_o =>per_dpf_shd.g_old_rec.no_country2,

Line 307: p_visit_internationally_o =>per_dpf_shd.g_old_rec.visit_internationally,

303: p_work_duration_o =>per_dpf_shd.g_old_rec.work_duration,
304: p_work_schedule_o =>per_dpf_shd.g_old_rec.work_schedule,
305: p_work_hours_o =>per_dpf_shd.g_old_rec.work_hours,
306: p_fte_capacity_o =>per_dpf_shd.g_old_rec.fte_capacity,
307: p_visit_internationally_o =>per_dpf_shd.g_old_rec.visit_internationally,
308: p_only_current_location_o =>per_dpf_shd.g_old_rec.only_current_location,
309: p_no_country1_o =>per_dpf_shd.g_old_rec.no_country1,
310: p_no_country2_o =>per_dpf_shd.g_old_rec.no_country2,
311: p_no_country3_o =>per_dpf_shd.g_old_rec.no_country3,

Line 308: p_only_current_location_o =>per_dpf_shd.g_old_rec.only_current_location,

304: p_work_schedule_o =>per_dpf_shd.g_old_rec.work_schedule,
305: p_work_hours_o =>per_dpf_shd.g_old_rec.work_hours,
306: p_fte_capacity_o =>per_dpf_shd.g_old_rec.fte_capacity,
307: p_visit_internationally_o =>per_dpf_shd.g_old_rec.visit_internationally,
308: p_only_current_location_o =>per_dpf_shd.g_old_rec.only_current_location,
309: p_no_country1_o =>per_dpf_shd.g_old_rec.no_country1,
310: p_no_country2_o =>per_dpf_shd.g_old_rec.no_country2,
311: p_no_country3_o =>per_dpf_shd.g_old_rec.no_country3,
312: p_comments_o =>per_dpf_shd.g_old_rec.comments,

Line 309: p_no_country1_o =>per_dpf_shd.g_old_rec.no_country1,

305: p_work_hours_o =>per_dpf_shd.g_old_rec.work_hours,
306: p_fte_capacity_o =>per_dpf_shd.g_old_rec.fte_capacity,
307: p_visit_internationally_o =>per_dpf_shd.g_old_rec.visit_internationally,
308: p_only_current_location_o =>per_dpf_shd.g_old_rec.only_current_location,
309: p_no_country1_o =>per_dpf_shd.g_old_rec.no_country1,
310: p_no_country2_o =>per_dpf_shd.g_old_rec.no_country2,
311: p_no_country3_o =>per_dpf_shd.g_old_rec.no_country3,
312: p_comments_o =>per_dpf_shd.g_old_rec.comments,
313: p_earliest_available_date_o =>per_dpf_shd.g_old_rec.earliest_available_date,

Line 310: p_no_country2_o =>per_dpf_shd.g_old_rec.no_country2,

306: p_fte_capacity_o =>per_dpf_shd.g_old_rec.fte_capacity,
307: p_visit_internationally_o =>per_dpf_shd.g_old_rec.visit_internationally,
308: p_only_current_location_o =>per_dpf_shd.g_old_rec.only_current_location,
309: p_no_country1_o =>per_dpf_shd.g_old_rec.no_country1,
310: p_no_country2_o =>per_dpf_shd.g_old_rec.no_country2,
311: p_no_country3_o =>per_dpf_shd.g_old_rec.no_country3,
312: p_comments_o =>per_dpf_shd.g_old_rec.comments,
313: p_earliest_available_date_o =>per_dpf_shd.g_old_rec.earliest_available_date,
314: p_available_for_transfer_o =>per_dpf_shd.g_old_rec.available_for_transfer,

Line 311: p_no_country3_o =>per_dpf_shd.g_old_rec.no_country3,

307: p_visit_internationally_o =>per_dpf_shd.g_old_rec.visit_internationally,
308: p_only_current_location_o =>per_dpf_shd.g_old_rec.only_current_location,
309: p_no_country1_o =>per_dpf_shd.g_old_rec.no_country1,
310: p_no_country2_o =>per_dpf_shd.g_old_rec.no_country2,
311: p_no_country3_o =>per_dpf_shd.g_old_rec.no_country3,
312: p_comments_o =>per_dpf_shd.g_old_rec.comments,
313: p_earliest_available_date_o =>per_dpf_shd.g_old_rec.earliest_available_date,
314: p_available_for_transfer_o =>per_dpf_shd.g_old_rec.available_for_transfer,
315: p_relocation_preference_o =>per_dpf_shd.g_old_rec.relocation_preference,

Line 312: p_comments_o =>per_dpf_shd.g_old_rec.comments,

308: p_only_current_location_o =>per_dpf_shd.g_old_rec.only_current_location,
309: p_no_country1_o =>per_dpf_shd.g_old_rec.no_country1,
310: p_no_country2_o =>per_dpf_shd.g_old_rec.no_country2,
311: p_no_country3_o =>per_dpf_shd.g_old_rec.no_country3,
312: p_comments_o =>per_dpf_shd.g_old_rec.comments,
313: p_earliest_available_date_o =>per_dpf_shd.g_old_rec.earliest_available_date,
314: p_available_for_transfer_o =>per_dpf_shd.g_old_rec.available_for_transfer,
315: p_relocation_preference_o =>per_dpf_shd.g_old_rec.relocation_preference,
316: p_relocation_required_o =>per_dpf_shd.g_old_rec.relocation_required,

Line 313: p_earliest_available_date_o =>per_dpf_shd.g_old_rec.earliest_available_date,

309: p_no_country1_o =>per_dpf_shd.g_old_rec.no_country1,
310: p_no_country2_o =>per_dpf_shd.g_old_rec.no_country2,
311: p_no_country3_o =>per_dpf_shd.g_old_rec.no_country3,
312: p_comments_o =>per_dpf_shd.g_old_rec.comments,
313: p_earliest_available_date_o =>per_dpf_shd.g_old_rec.earliest_available_date,
314: p_available_for_transfer_o =>per_dpf_shd.g_old_rec.available_for_transfer,
315: p_relocation_preference_o =>per_dpf_shd.g_old_rec.relocation_preference,
316: p_relocation_required_o =>per_dpf_shd.g_old_rec.relocation_required,
317: p_passport_required_o =>per_dpf_shd.g_old_rec.passport_required,

Line 314: p_available_for_transfer_o =>per_dpf_shd.g_old_rec.available_for_transfer,

310: p_no_country2_o =>per_dpf_shd.g_old_rec.no_country2,
311: p_no_country3_o =>per_dpf_shd.g_old_rec.no_country3,
312: p_comments_o =>per_dpf_shd.g_old_rec.comments,
313: p_earliest_available_date_o =>per_dpf_shd.g_old_rec.earliest_available_date,
314: p_available_for_transfer_o =>per_dpf_shd.g_old_rec.available_for_transfer,
315: p_relocation_preference_o =>per_dpf_shd.g_old_rec.relocation_preference,
316: p_relocation_required_o =>per_dpf_shd.g_old_rec.relocation_required,
317: p_passport_required_o =>per_dpf_shd.g_old_rec.passport_required,
318: p_location1_o =>per_dpf_shd.g_old_rec.location1,

Line 315: p_relocation_preference_o =>per_dpf_shd.g_old_rec.relocation_preference,

311: p_no_country3_o =>per_dpf_shd.g_old_rec.no_country3,
312: p_comments_o =>per_dpf_shd.g_old_rec.comments,
313: p_earliest_available_date_o =>per_dpf_shd.g_old_rec.earliest_available_date,
314: p_available_for_transfer_o =>per_dpf_shd.g_old_rec.available_for_transfer,
315: p_relocation_preference_o =>per_dpf_shd.g_old_rec.relocation_preference,
316: p_relocation_required_o =>per_dpf_shd.g_old_rec.relocation_required,
317: p_passport_required_o =>per_dpf_shd.g_old_rec.passport_required,
318: p_location1_o =>per_dpf_shd.g_old_rec.location1,
319: p_location2_o =>per_dpf_shd.g_old_rec.location2,

Line 316: p_relocation_required_o =>per_dpf_shd.g_old_rec.relocation_required,

312: p_comments_o =>per_dpf_shd.g_old_rec.comments,
313: p_earliest_available_date_o =>per_dpf_shd.g_old_rec.earliest_available_date,
314: p_available_for_transfer_o =>per_dpf_shd.g_old_rec.available_for_transfer,
315: p_relocation_preference_o =>per_dpf_shd.g_old_rec.relocation_preference,
316: p_relocation_required_o =>per_dpf_shd.g_old_rec.relocation_required,
317: p_passport_required_o =>per_dpf_shd.g_old_rec.passport_required,
318: p_location1_o =>per_dpf_shd.g_old_rec.location1,
319: p_location2_o =>per_dpf_shd.g_old_rec.location2,
320: p_location3_o =>per_dpf_shd.g_old_rec.location3,

Line 317: p_passport_required_o =>per_dpf_shd.g_old_rec.passport_required,

313: p_earliest_available_date_o =>per_dpf_shd.g_old_rec.earliest_available_date,
314: p_available_for_transfer_o =>per_dpf_shd.g_old_rec.available_for_transfer,
315: p_relocation_preference_o =>per_dpf_shd.g_old_rec.relocation_preference,
316: p_relocation_required_o =>per_dpf_shd.g_old_rec.relocation_required,
317: p_passport_required_o =>per_dpf_shd.g_old_rec.passport_required,
318: p_location1_o =>per_dpf_shd.g_old_rec.location1,
319: p_location2_o =>per_dpf_shd.g_old_rec.location2,
320: p_location3_o =>per_dpf_shd.g_old_rec.location3,
321: p_other_requirements_o =>per_dpf_shd.g_old_rec.other_requirements,

Line 318: p_location1_o =>per_dpf_shd.g_old_rec.location1,

314: p_available_for_transfer_o =>per_dpf_shd.g_old_rec.available_for_transfer,
315: p_relocation_preference_o =>per_dpf_shd.g_old_rec.relocation_preference,
316: p_relocation_required_o =>per_dpf_shd.g_old_rec.relocation_required,
317: p_passport_required_o =>per_dpf_shd.g_old_rec.passport_required,
318: p_location1_o =>per_dpf_shd.g_old_rec.location1,
319: p_location2_o =>per_dpf_shd.g_old_rec.location2,
320: p_location3_o =>per_dpf_shd.g_old_rec.location3,
321: p_other_requirements_o =>per_dpf_shd.g_old_rec.other_requirements,
322: p_service_minimum_o =>per_dpf_shd.g_old_rec.service_minimum,

Line 319: p_location2_o =>per_dpf_shd.g_old_rec.location2,

315: p_relocation_preference_o =>per_dpf_shd.g_old_rec.relocation_preference,
316: p_relocation_required_o =>per_dpf_shd.g_old_rec.relocation_required,
317: p_passport_required_o =>per_dpf_shd.g_old_rec.passport_required,
318: p_location1_o =>per_dpf_shd.g_old_rec.location1,
319: p_location2_o =>per_dpf_shd.g_old_rec.location2,
320: p_location3_o =>per_dpf_shd.g_old_rec.location3,
321: p_other_requirements_o =>per_dpf_shd.g_old_rec.other_requirements,
322: p_service_minimum_o =>per_dpf_shd.g_old_rec.service_minimum,
323: p_object_version_number_o =>per_dpf_shd.g_old_rec.object_version_number,

Line 320: p_location3_o =>per_dpf_shd.g_old_rec.location3,

316: p_relocation_required_o =>per_dpf_shd.g_old_rec.relocation_required,
317: p_passport_required_o =>per_dpf_shd.g_old_rec.passport_required,
318: p_location1_o =>per_dpf_shd.g_old_rec.location1,
319: p_location2_o =>per_dpf_shd.g_old_rec.location2,
320: p_location3_o =>per_dpf_shd.g_old_rec.location3,
321: p_other_requirements_o =>per_dpf_shd.g_old_rec.other_requirements,
322: p_service_minimum_o =>per_dpf_shd.g_old_rec.service_minimum,
323: p_object_version_number_o =>per_dpf_shd.g_old_rec.object_version_number,
324: p_attribute_category_o =>per_dpf_shd.g_old_rec.attribute_category,

Line 321: p_other_requirements_o =>per_dpf_shd.g_old_rec.other_requirements,

317: p_passport_required_o =>per_dpf_shd.g_old_rec.passport_required,
318: p_location1_o =>per_dpf_shd.g_old_rec.location1,
319: p_location2_o =>per_dpf_shd.g_old_rec.location2,
320: p_location3_o =>per_dpf_shd.g_old_rec.location3,
321: p_other_requirements_o =>per_dpf_shd.g_old_rec.other_requirements,
322: p_service_minimum_o =>per_dpf_shd.g_old_rec.service_minimum,
323: p_object_version_number_o =>per_dpf_shd.g_old_rec.object_version_number,
324: p_attribute_category_o =>per_dpf_shd.g_old_rec.attribute_category,
325: p_attribute1_o =>per_dpf_shd.g_old_rec.attribute1,

Line 322: p_service_minimum_o =>per_dpf_shd.g_old_rec.service_minimum,

318: p_location1_o =>per_dpf_shd.g_old_rec.location1,
319: p_location2_o =>per_dpf_shd.g_old_rec.location2,
320: p_location3_o =>per_dpf_shd.g_old_rec.location3,
321: p_other_requirements_o =>per_dpf_shd.g_old_rec.other_requirements,
322: p_service_minimum_o =>per_dpf_shd.g_old_rec.service_minimum,
323: p_object_version_number_o =>per_dpf_shd.g_old_rec.object_version_number,
324: p_attribute_category_o =>per_dpf_shd.g_old_rec.attribute_category,
325: p_attribute1_o =>per_dpf_shd.g_old_rec.attribute1,
326: p_attribute2_o =>per_dpf_shd.g_old_rec.attribute2,

Line 323: p_object_version_number_o =>per_dpf_shd.g_old_rec.object_version_number,

319: p_location2_o =>per_dpf_shd.g_old_rec.location2,
320: p_location3_o =>per_dpf_shd.g_old_rec.location3,
321: p_other_requirements_o =>per_dpf_shd.g_old_rec.other_requirements,
322: p_service_minimum_o =>per_dpf_shd.g_old_rec.service_minimum,
323: p_object_version_number_o =>per_dpf_shd.g_old_rec.object_version_number,
324: p_attribute_category_o =>per_dpf_shd.g_old_rec.attribute_category,
325: p_attribute1_o =>per_dpf_shd.g_old_rec.attribute1,
326: p_attribute2_o =>per_dpf_shd.g_old_rec.attribute2,
327: p_attribute3_o =>per_dpf_shd.g_old_rec.attribute3,

Line 324: p_attribute_category_o =>per_dpf_shd.g_old_rec.attribute_category,

320: p_location3_o =>per_dpf_shd.g_old_rec.location3,
321: p_other_requirements_o =>per_dpf_shd.g_old_rec.other_requirements,
322: p_service_minimum_o =>per_dpf_shd.g_old_rec.service_minimum,
323: p_object_version_number_o =>per_dpf_shd.g_old_rec.object_version_number,
324: p_attribute_category_o =>per_dpf_shd.g_old_rec.attribute_category,
325: p_attribute1_o =>per_dpf_shd.g_old_rec.attribute1,
326: p_attribute2_o =>per_dpf_shd.g_old_rec.attribute2,
327: p_attribute3_o =>per_dpf_shd.g_old_rec.attribute3,
328: p_attribute4_o =>per_dpf_shd.g_old_rec.attribute4,

Line 325: p_attribute1_o =>per_dpf_shd.g_old_rec.attribute1,

321: p_other_requirements_o =>per_dpf_shd.g_old_rec.other_requirements,
322: p_service_minimum_o =>per_dpf_shd.g_old_rec.service_minimum,
323: p_object_version_number_o =>per_dpf_shd.g_old_rec.object_version_number,
324: p_attribute_category_o =>per_dpf_shd.g_old_rec.attribute_category,
325: p_attribute1_o =>per_dpf_shd.g_old_rec.attribute1,
326: p_attribute2_o =>per_dpf_shd.g_old_rec.attribute2,
327: p_attribute3_o =>per_dpf_shd.g_old_rec.attribute3,
328: p_attribute4_o =>per_dpf_shd.g_old_rec.attribute4,
329: p_attribute5_o =>per_dpf_shd.g_old_rec.attribute5,

Line 326: p_attribute2_o =>per_dpf_shd.g_old_rec.attribute2,

322: p_service_minimum_o =>per_dpf_shd.g_old_rec.service_minimum,
323: p_object_version_number_o =>per_dpf_shd.g_old_rec.object_version_number,
324: p_attribute_category_o =>per_dpf_shd.g_old_rec.attribute_category,
325: p_attribute1_o =>per_dpf_shd.g_old_rec.attribute1,
326: p_attribute2_o =>per_dpf_shd.g_old_rec.attribute2,
327: p_attribute3_o =>per_dpf_shd.g_old_rec.attribute3,
328: p_attribute4_o =>per_dpf_shd.g_old_rec.attribute4,
329: p_attribute5_o =>per_dpf_shd.g_old_rec.attribute5,
330: p_attribute6_o =>per_dpf_shd.g_old_rec.attribute6,

Line 327: p_attribute3_o =>per_dpf_shd.g_old_rec.attribute3,

323: p_object_version_number_o =>per_dpf_shd.g_old_rec.object_version_number,
324: p_attribute_category_o =>per_dpf_shd.g_old_rec.attribute_category,
325: p_attribute1_o =>per_dpf_shd.g_old_rec.attribute1,
326: p_attribute2_o =>per_dpf_shd.g_old_rec.attribute2,
327: p_attribute3_o =>per_dpf_shd.g_old_rec.attribute3,
328: p_attribute4_o =>per_dpf_shd.g_old_rec.attribute4,
329: p_attribute5_o =>per_dpf_shd.g_old_rec.attribute5,
330: p_attribute6_o =>per_dpf_shd.g_old_rec.attribute6,
331: p_attribute7_o =>per_dpf_shd.g_old_rec.attribute7,

Line 328: p_attribute4_o =>per_dpf_shd.g_old_rec.attribute4,

324: p_attribute_category_o =>per_dpf_shd.g_old_rec.attribute_category,
325: p_attribute1_o =>per_dpf_shd.g_old_rec.attribute1,
326: p_attribute2_o =>per_dpf_shd.g_old_rec.attribute2,
327: p_attribute3_o =>per_dpf_shd.g_old_rec.attribute3,
328: p_attribute4_o =>per_dpf_shd.g_old_rec.attribute4,
329: p_attribute5_o =>per_dpf_shd.g_old_rec.attribute5,
330: p_attribute6_o =>per_dpf_shd.g_old_rec.attribute6,
331: p_attribute7_o =>per_dpf_shd.g_old_rec.attribute7,
332: p_attribute8_o =>per_dpf_shd.g_old_rec.attribute8,

Line 329: p_attribute5_o =>per_dpf_shd.g_old_rec.attribute5,

325: p_attribute1_o =>per_dpf_shd.g_old_rec.attribute1,
326: p_attribute2_o =>per_dpf_shd.g_old_rec.attribute2,
327: p_attribute3_o =>per_dpf_shd.g_old_rec.attribute3,
328: p_attribute4_o =>per_dpf_shd.g_old_rec.attribute4,
329: p_attribute5_o =>per_dpf_shd.g_old_rec.attribute5,
330: p_attribute6_o =>per_dpf_shd.g_old_rec.attribute6,
331: p_attribute7_o =>per_dpf_shd.g_old_rec.attribute7,
332: p_attribute8_o =>per_dpf_shd.g_old_rec.attribute8,
333: p_attribute9_o =>per_dpf_shd.g_old_rec.attribute9,

Line 330: p_attribute6_o =>per_dpf_shd.g_old_rec.attribute6,

326: p_attribute2_o =>per_dpf_shd.g_old_rec.attribute2,
327: p_attribute3_o =>per_dpf_shd.g_old_rec.attribute3,
328: p_attribute4_o =>per_dpf_shd.g_old_rec.attribute4,
329: p_attribute5_o =>per_dpf_shd.g_old_rec.attribute5,
330: p_attribute6_o =>per_dpf_shd.g_old_rec.attribute6,
331: p_attribute7_o =>per_dpf_shd.g_old_rec.attribute7,
332: p_attribute8_o =>per_dpf_shd.g_old_rec.attribute8,
333: p_attribute9_o =>per_dpf_shd.g_old_rec.attribute9,
334: p_attribute10_o =>per_dpf_shd.g_old_rec.attribute10,

Line 331: p_attribute7_o =>per_dpf_shd.g_old_rec.attribute7,

327: p_attribute3_o =>per_dpf_shd.g_old_rec.attribute3,
328: p_attribute4_o =>per_dpf_shd.g_old_rec.attribute4,
329: p_attribute5_o =>per_dpf_shd.g_old_rec.attribute5,
330: p_attribute6_o =>per_dpf_shd.g_old_rec.attribute6,
331: p_attribute7_o =>per_dpf_shd.g_old_rec.attribute7,
332: p_attribute8_o =>per_dpf_shd.g_old_rec.attribute8,
333: p_attribute9_o =>per_dpf_shd.g_old_rec.attribute9,
334: p_attribute10_o =>per_dpf_shd.g_old_rec.attribute10,
335: p_attribute11_o =>per_dpf_shd.g_old_rec.attribute11,

Line 332: p_attribute8_o =>per_dpf_shd.g_old_rec.attribute8,

328: p_attribute4_o =>per_dpf_shd.g_old_rec.attribute4,
329: p_attribute5_o =>per_dpf_shd.g_old_rec.attribute5,
330: p_attribute6_o =>per_dpf_shd.g_old_rec.attribute6,
331: p_attribute7_o =>per_dpf_shd.g_old_rec.attribute7,
332: p_attribute8_o =>per_dpf_shd.g_old_rec.attribute8,
333: p_attribute9_o =>per_dpf_shd.g_old_rec.attribute9,
334: p_attribute10_o =>per_dpf_shd.g_old_rec.attribute10,
335: p_attribute11_o =>per_dpf_shd.g_old_rec.attribute11,
336: p_attribute12_o =>per_dpf_shd.g_old_rec.attribute12,

Line 333: p_attribute9_o =>per_dpf_shd.g_old_rec.attribute9,

329: p_attribute5_o =>per_dpf_shd.g_old_rec.attribute5,
330: p_attribute6_o =>per_dpf_shd.g_old_rec.attribute6,
331: p_attribute7_o =>per_dpf_shd.g_old_rec.attribute7,
332: p_attribute8_o =>per_dpf_shd.g_old_rec.attribute8,
333: p_attribute9_o =>per_dpf_shd.g_old_rec.attribute9,
334: p_attribute10_o =>per_dpf_shd.g_old_rec.attribute10,
335: p_attribute11_o =>per_dpf_shd.g_old_rec.attribute11,
336: p_attribute12_o =>per_dpf_shd.g_old_rec.attribute12,
337: p_attribute13_o =>per_dpf_shd.g_old_rec.attribute13,

Line 334: p_attribute10_o =>per_dpf_shd.g_old_rec.attribute10,

330: p_attribute6_o =>per_dpf_shd.g_old_rec.attribute6,
331: p_attribute7_o =>per_dpf_shd.g_old_rec.attribute7,
332: p_attribute8_o =>per_dpf_shd.g_old_rec.attribute8,
333: p_attribute9_o =>per_dpf_shd.g_old_rec.attribute9,
334: p_attribute10_o =>per_dpf_shd.g_old_rec.attribute10,
335: p_attribute11_o =>per_dpf_shd.g_old_rec.attribute11,
336: p_attribute12_o =>per_dpf_shd.g_old_rec.attribute12,
337: p_attribute13_o =>per_dpf_shd.g_old_rec.attribute13,
338: p_attribute14_o =>per_dpf_shd.g_old_rec.attribute14,

Line 335: p_attribute11_o =>per_dpf_shd.g_old_rec.attribute11,

331: p_attribute7_o =>per_dpf_shd.g_old_rec.attribute7,
332: p_attribute8_o =>per_dpf_shd.g_old_rec.attribute8,
333: p_attribute9_o =>per_dpf_shd.g_old_rec.attribute9,
334: p_attribute10_o =>per_dpf_shd.g_old_rec.attribute10,
335: p_attribute11_o =>per_dpf_shd.g_old_rec.attribute11,
336: p_attribute12_o =>per_dpf_shd.g_old_rec.attribute12,
337: p_attribute13_o =>per_dpf_shd.g_old_rec.attribute13,
338: p_attribute14_o =>per_dpf_shd.g_old_rec.attribute14,
339: p_attribute15_o =>per_dpf_shd.g_old_rec.attribute15,

Line 336: p_attribute12_o =>per_dpf_shd.g_old_rec.attribute12,

332: p_attribute8_o =>per_dpf_shd.g_old_rec.attribute8,
333: p_attribute9_o =>per_dpf_shd.g_old_rec.attribute9,
334: p_attribute10_o =>per_dpf_shd.g_old_rec.attribute10,
335: p_attribute11_o =>per_dpf_shd.g_old_rec.attribute11,
336: p_attribute12_o =>per_dpf_shd.g_old_rec.attribute12,
337: p_attribute13_o =>per_dpf_shd.g_old_rec.attribute13,
338: p_attribute14_o =>per_dpf_shd.g_old_rec.attribute14,
339: p_attribute15_o =>per_dpf_shd.g_old_rec.attribute15,
340: p_attribute16_o =>per_dpf_shd.g_old_rec.attribute16,

Line 337: p_attribute13_o =>per_dpf_shd.g_old_rec.attribute13,

333: p_attribute9_o =>per_dpf_shd.g_old_rec.attribute9,
334: p_attribute10_o =>per_dpf_shd.g_old_rec.attribute10,
335: p_attribute11_o =>per_dpf_shd.g_old_rec.attribute11,
336: p_attribute12_o =>per_dpf_shd.g_old_rec.attribute12,
337: p_attribute13_o =>per_dpf_shd.g_old_rec.attribute13,
338: p_attribute14_o =>per_dpf_shd.g_old_rec.attribute14,
339: p_attribute15_o =>per_dpf_shd.g_old_rec.attribute15,
340: p_attribute16_o =>per_dpf_shd.g_old_rec.attribute16,
341: p_attribute17_o =>per_dpf_shd.g_old_rec.attribute17,

Line 338: p_attribute14_o =>per_dpf_shd.g_old_rec.attribute14,

334: p_attribute10_o =>per_dpf_shd.g_old_rec.attribute10,
335: p_attribute11_o =>per_dpf_shd.g_old_rec.attribute11,
336: p_attribute12_o =>per_dpf_shd.g_old_rec.attribute12,
337: p_attribute13_o =>per_dpf_shd.g_old_rec.attribute13,
338: p_attribute14_o =>per_dpf_shd.g_old_rec.attribute14,
339: p_attribute15_o =>per_dpf_shd.g_old_rec.attribute15,
340: p_attribute16_o =>per_dpf_shd.g_old_rec.attribute16,
341: p_attribute17_o =>per_dpf_shd.g_old_rec.attribute17,
342: p_attribute18_o =>per_dpf_shd.g_old_rec.attribute18,

Line 339: p_attribute15_o =>per_dpf_shd.g_old_rec.attribute15,

335: p_attribute11_o =>per_dpf_shd.g_old_rec.attribute11,
336: p_attribute12_o =>per_dpf_shd.g_old_rec.attribute12,
337: p_attribute13_o =>per_dpf_shd.g_old_rec.attribute13,
338: p_attribute14_o =>per_dpf_shd.g_old_rec.attribute14,
339: p_attribute15_o =>per_dpf_shd.g_old_rec.attribute15,
340: p_attribute16_o =>per_dpf_shd.g_old_rec.attribute16,
341: p_attribute17_o =>per_dpf_shd.g_old_rec.attribute17,
342: p_attribute18_o =>per_dpf_shd.g_old_rec.attribute18,
343: p_attribute19_o =>per_dpf_shd.g_old_rec.attribute19,

Line 340: p_attribute16_o =>per_dpf_shd.g_old_rec.attribute16,

336: p_attribute12_o =>per_dpf_shd.g_old_rec.attribute12,
337: p_attribute13_o =>per_dpf_shd.g_old_rec.attribute13,
338: p_attribute14_o =>per_dpf_shd.g_old_rec.attribute14,
339: p_attribute15_o =>per_dpf_shd.g_old_rec.attribute15,
340: p_attribute16_o =>per_dpf_shd.g_old_rec.attribute16,
341: p_attribute17_o =>per_dpf_shd.g_old_rec.attribute17,
342: p_attribute18_o =>per_dpf_shd.g_old_rec.attribute18,
343: p_attribute19_o =>per_dpf_shd.g_old_rec.attribute19,
344: p_attribute20_o =>per_dpf_shd.g_old_rec.attribute20

Line 341: p_attribute17_o =>per_dpf_shd.g_old_rec.attribute17,

337: p_attribute13_o =>per_dpf_shd.g_old_rec.attribute13,
338: p_attribute14_o =>per_dpf_shd.g_old_rec.attribute14,
339: p_attribute15_o =>per_dpf_shd.g_old_rec.attribute15,
340: p_attribute16_o =>per_dpf_shd.g_old_rec.attribute16,
341: p_attribute17_o =>per_dpf_shd.g_old_rec.attribute17,
342: p_attribute18_o =>per_dpf_shd.g_old_rec.attribute18,
343: p_attribute19_o =>per_dpf_shd.g_old_rec.attribute19,
344: p_attribute20_o =>per_dpf_shd.g_old_rec.attribute20
345: );

Line 342: p_attribute18_o =>per_dpf_shd.g_old_rec.attribute18,

338: p_attribute14_o =>per_dpf_shd.g_old_rec.attribute14,
339: p_attribute15_o =>per_dpf_shd.g_old_rec.attribute15,
340: p_attribute16_o =>per_dpf_shd.g_old_rec.attribute16,
341: p_attribute17_o =>per_dpf_shd.g_old_rec.attribute17,
342: p_attribute18_o =>per_dpf_shd.g_old_rec.attribute18,
343: p_attribute19_o =>per_dpf_shd.g_old_rec.attribute19,
344: p_attribute20_o =>per_dpf_shd.g_old_rec.attribute20
345: );
346: exception

Line 343: p_attribute19_o =>per_dpf_shd.g_old_rec.attribute19,

339: p_attribute15_o =>per_dpf_shd.g_old_rec.attribute15,
340: p_attribute16_o =>per_dpf_shd.g_old_rec.attribute16,
341: p_attribute17_o =>per_dpf_shd.g_old_rec.attribute17,
342: p_attribute18_o =>per_dpf_shd.g_old_rec.attribute18,
343: p_attribute19_o =>per_dpf_shd.g_old_rec.attribute19,
344: p_attribute20_o =>per_dpf_shd.g_old_rec.attribute20
345: );
346: exception
347: when hr_api.cannot_find_prog_unit then

Line 344: p_attribute20_o =>per_dpf_shd.g_old_rec.attribute20

340: p_attribute16_o =>per_dpf_shd.g_old_rec.attribute16,
341: p_attribute17_o =>per_dpf_shd.g_old_rec.attribute17,
342: p_attribute18_o =>per_dpf_shd.g_old_rec.attribute18,
343: p_attribute19_o =>per_dpf_shd.g_old_rec.attribute19,
344: p_attribute20_o =>per_dpf_shd.g_old_rec.attribute20
345: );
346: exception
347: when hr_api.cannot_find_prog_unit then
348: hr_api.cannot_find_prog_unit_error

Line 402: Procedure convert_defs(p_rec in out nocopy per_dpf_shd.g_rec_type) is

398: -- Internal Row Handler Use Only.
399: --
400: -- {End Of Comments}
401: -- ----------------------------------------------------------------------------
402: Procedure convert_defs(p_rec in out nocopy per_dpf_shd.g_rec_type) is
403: --
404: l_proc varchar2(72) := g_package||'convert_defs';
405: --
406: Begin

Line 417: per_dpf_shd.g_old_rec.position_id;

413: -- is being used then we must set to the 'current' argument value.
414: --
415: If (p_rec.position_id = hr_api.g_number) then
416: p_rec.position_id :=
417: per_dpf_shd.g_old_rec.position_id;
418: End If;
419: If (p_rec.person_id = hr_api.g_number) then
420: p_rec.person_id :=
421: per_dpf_shd.g_old_rec.person_id;

Line 421: per_dpf_shd.g_old_rec.person_id;

417: per_dpf_shd.g_old_rec.position_id;
418: End If;
419: If (p_rec.person_id = hr_api.g_number) then
420: p_rec.person_id :=
421: per_dpf_shd.g_old_rec.person_id;
422: End If;
423: If (p_rec.job_id = hr_api.g_number) then
424: p_rec.job_id :=
425: per_dpf_shd.g_old_rec.job_id;

Line 425: per_dpf_shd.g_old_rec.job_id;

421: per_dpf_shd.g_old_rec.person_id;
422: End If;
423: If (p_rec.job_id = hr_api.g_number) then
424: p_rec.job_id :=
425: per_dpf_shd.g_old_rec.job_id;
426: End If;
427: If (p_rec.business_group_id = hr_api.g_number) then
428: p_rec.business_group_id :=
429: per_dpf_shd.g_old_rec.business_group_id;

Line 429: per_dpf_shd.g_old_rec.business_group_id;

425: per_dpf_shd.g_old_rec.job_id;
426: End If;
427: If (p_rec.business_group_id = hr_api.g_number) then
428: p_rec.business_group_id :=
429: per_dpf_shd.g_old_rec.business_group_id;
430: End If;
431: If (p_rec.work_any_country = hr_api.g_varchar2) then
432: p_rec.work_any_country :=
433: per_dpf_shd.g_old_rec.work_any_country;

Line 433: per_dpf_shd.g_old_rec.work_any_country;

429: per_dpf_shd.g_old_rec.business_group_id;
430: End If;
431: If (p_rec.work_any_country = hr_api.g_varchar2) then
432: p_rec.work_any_country :=
433: per_dpf_shd.g_old_rec.work_any_country;
434: End If;
435: If (p_rec.work_any_location = hr_api.g_varchar2) then
436: p_rec.work_any_location :=
437: per_dpf_shd.g_old_rec.work_any_location;

Line 437: per_dpf_shd.g_old_rec.work_any_location;

433: per_dpf_shd.g_old_rec.work_any_country;
434: End If;
435: If (p_rec.work_any_location = hr_api.g_varchar2) then
436: p_rec.work_any_location :=
437: per_dpf_shd.g_old_rec.work_any_location;
438: End If;
439: If (p_rec.relocate_domestically = hr_api.g_varchar2) then
440: p_rec.relocate_domestically :=
441: per_dpf_shd.g_old_rec.relocate_domestically;

Line 441: per_dpf_shd.g_old_rec.relocate_domestically;

437: per_dpf_shd.g_old_rec.work_any_location;
438: End If;
439: If (p_rec.relocate_domestically = hr_api.g_varchar2) then
440: p_rec.relocate_domestically :=
441: per_dpf_shd.g_old_rec.relocate_domestically;
442: End If;
443: If (p_rec.relocate_internationally = hr_api.g_varchar2) then
444: p_rec.relocate_internationally :=
445: per_dpf_shd.g_old_rec.relocate_internationally;

Line 445: per_dpf_shd.g_old_rec.relocate_internationally;

441: per_dpf_shd.g_old_rec.relocate_domestically;
442: End If;
443: If (p_rec.relocate_internationally = hr_api.g_varchar2) then
444: p_rec.relocate_internationally :=
445: per_dpf_shd.g_old_rec.relocate_internationally;
446: End If;
447: If (p_rec.travel_required = hr_api.g_varchar2) then
448: p_rec.travel_required :=
449: per_dpf_shd.g_old_rec.travel_required;

Line 449: per_dpf_shd.g_old_rec.travel_required;

445: per_dpf_shd.g_old_rec.relocate_internationally;
446: End If;
447: If (p_rec.travel_required = hr_api.g_varchar2) then
448: p_rec.travel_required :=
449: per_dpf_shd.g_old_rec.travel_required;
450: End If;
451: If (p_rec.country1 = hr_api.g_varchar2) then
452: p_rec.country1 :=
453: per_dpf_shd.g_old_rec.country1;

Line 453: per_dpf_shd.g_old_rec.country1;

449: per_dpf_shd.g_old_rec.travel_required;
450: End If;
451: If (p_rec.country1 = hr_api.g_varchar2) then
452: p_rec.country1 :=
453: per_dpf_shd.g_old_rec.country1;
454: End If;
455: If (p_rec.country2 = hr_api.g_varchar2) then
456: p_rec.country2 :=
457: per_dpf_shd.g_old_rec.country2;

Line 457: per_dpf_shd.g_old_rec.country2;

453: per_dpf_shd.g_old_rec.country1;
454: End If;
455: If (p_rec.country2 = hr_api.g_varchar2) then
456: p_rec.country2 :=
457: per_dpf_shd.g_old_rec.country2;
458: End If;
459: If (p_rec.country3 = hr_api.g_varchar2) then
460: p_rec.country3 :=
461: per_dpf_shd.g_old_rec.country3;

Line 461: per_dpf_shd.g_old_rec.country3;

457: per_dpf_shd.g_old_rec.country2;
458: End If;
459: If (p_rec.country3 = hr_api.g_varchar2) then
460: p_rec.country3 :=
461: per_dpf_shd.g_old_rec.country3;
462: End If;
463: If (p_rec.work_duration = hr_api.g_varchar2) then
464: p_rec.work_duration :=
465: per_dpf_shd.g_old_rec.work_duration;

Line 465: per_dpf_shd.g_old_rec.work_duration;

461: per_dpf_shd.g_old_rec.country3;
462: End If;
463: If (p_rec.work_duration = hr_api.g_varchar2) then
464: p_rec.work_duration :=
465: per_dpf_shd.g_old_rec.work_duration;
466: End If;
467: If (p_rec.work_schedule = hr_api.g_varchar2) then
468: p_rec.work_schedule :=
469: per_dpf_shd.g_old_rec.work_schedule;

Line 469: per_dpf_shd.g_old_rec.work_schedule;

465: per_dpf_shd.g_old_rec.work_duration;
466: End If;
467: If (p_rec.work_schedule = hr_api.g_varchar2) then
468: p_rec.work_schedule :=
469: per_dpf_shd.g_old_rec.work_schedule;
470: End If;
471: If (p_rec.work_hours = hr_api.g_varchar2) then
472: p_rec.work_hours :=
473: per_dpf_shd.g_old_rec.work_hours;

Line 473: per_dpf_shd.g_old_rec.work_hours;

469: per_dpf_shd.g_old_rec.work_schedule;
470: End If;
471: If (p_rec.work_hours = hr_api.g_varchar2) then
472: p_rec.work_hours :=
473: per_dpf_shd.g_old_rec.work_hours;
474: End If;
475: If (p_rec.fte_capacity = hr_api.g_varchar2) then
476: p_rec.fte_capacity :=
477: per_dpf_shd.g_old_rec.fte_capacity;

Line 477: per_dpf_shd.g_old_rec.fte_capacity;

473: per_dpf_shd.g_old_rec.work_hours;
474: End If;
475: If (p_rec.fte_capacity = hr_api.g_varchar2) then
476: p_rec.fte_capacity :=
477: per_dpf_shd.g_old_rec.fte_capacity;
478: End If;
479: If (p_rec.visit_internationally = hr_api.g_varchar2) then
480: p_rec.visit_internationally :=
481: per_dpf_shd.g_old_rec.visit_internationally;

Line 481: per_dpf_shd.g_old_rec.visit_internationally;

477: per_dpf_shd.g_old_rec.fte_capacity;
478: End If;
479: If (p_rec.visit_internationally = hr_api.g_varchar2) then
480: p_rec.visit_internationally :=
481: per_dpf_shd.g_old_rec.visit_internationally;
482: End If;
483: If (p_rec.only_current_location = hr_api.g_varchar2) then
484: p_rec.only_current_location :=
485: per_dpf_shd.g_old_rec.only_current_location;

Line 485: per_dpf_shd.g_old_rec.only_current_location;

481: per_dpf_shd.g_old_rec.visit_internationally;
482: End If;
483: If (p_rec.only_current_location = hr_api.g_varchar2) then
484: p_rec.only_current_location :=
485: per_dpf_shd.g_old_rec.only_current_location;
486: End If;
487: If (p_rec.no_country1 = hr_api.g_varchar2) then
488: p_rec.no_country1 :=
489: per_dpf_shd.g_old_rec.no_country1;

Line 489: per_dpf_shd.g_old_rec.no_country1;

485: per_dpf_shd.g_old_rec.only_current_location;
486: End If;
487: If (p_rec.no_country1 = hr_api.g_varchar2) then
488: p_rec.no_country1 :=
489: per_dpf_shd.g_old_rec.no_country1;
490: End If;
491: If (p_rec.no_country2 = hr_api.g_varchar2) then
492: p_rec.no_country2 :=
493: per_dpf_shd.g_old_rec.no_country2;

Line 493: per_dpf_shd.g_old_rec.no_country2;

489: per_dpf_shd.g_old_rec.no_country1;
490: End If;
491: If (p_rec.no_country2 = hr_api.g_varchar2) then
492: p_rec.no_country2 :=
493: per_dpf_shd.g_old_rec.no_country2;
494: End If;
495: If (p_rec.no_country3 = hr_api.g_varchar2) then
496: p_rec.no_country3 :=
497: per_dpf_shd.g_old_rec.no_country3;

Line 497: per_dpf_shd.g_old_rec.no_country3;

493: per_dpf_shd.g_old_rec.no_country2;
494: End If;
495: If (p_rec.no_country3 = hr_api.g_varchar2) then
496: p_rec.no_country3 :=
497: per_dpf_shd.g_old_rec.no_country3;
498: End If;
499: If (p_rec.comments = hr_api.g_varchar2) then
500: p_rec.comments :=
501: per_dpf_shd.g_old_rec.comments;

Line 501: per_dpf_shd.g_old_rec.comments;

497: per_dpf_shd.g_old_rec.no_country3;
498: End If;
499: If (p_rec.comments = hr_api.g_varchar2) then
500: p_rec.comments :=
501: per_dpf_shd.g_old_rec.comments;
502: End If;
503: If (p_rec.earliest_available_date = hr_api.g_date) then
504: p_rec.earliest_available_date :=
505: per_dpf_shd.g_old_rec.earliest_available_date;

Line 505: per_dpf_shd.g_old_rec.earliest_available_date;

501: per_dpf_shd.g_old_rec.comments;
502: End If;
503: If (p_rec.earliest_available_date = hr_api.g_date) then
504: p_rec.earliest_available_date :=
505: per_dpf_shd.g_old_rec.earliest_available_date;
506: End If;
507: If (p_rec.available_for_transfer = hr_api.g_varchar2) then
508: p_rec.available_for_transfer :=
509: per_dpf_shd.g_old_rec.available_for_transfer;

Line 509: per_dpf_shd.g_old_rec.available_for_transfer;

505: per_dpf_shd.g_old_rec.earliest_available_date;
506: End If;
507: If (p_rec.available_for_transfer = hr_api.g_varchar2) then
508: p_rec.available_for_transfer :=
509: per_dpf_shd.g_old_rec.available_for_transfer;
510: End If;
511: If (p_rec.relocation_preference = hr_api.g_varchar2) then
512: p_rec.relocation_preference :=
513: per_dpf_shd.g_old_rec.relocation_preference;

Line 513: per_dpf_shd.g_old_rec.relocation_preference;

509: per_dpf_shd.g_old_rec.available_for_transfer;
510: End If;
511: If (p_rec.relocation_preference = hr_api.g_varchar2) then
512: p_rec.relocation_preference :=
513: per_dpf_shd.g_old_rec.relocation_preference;
514: End If;
515: If (p_rec.relocation_required = hr_api.g_varchar2) then
516: p_rec.relocation_required :=
517: per_dpf_shd.g_old_rec.relocation_required;

Line 517: per_dpf_shd.g_old_rec.relocation_required;

513: per_dpf_shd.g_old_rec.relocation_preference;
514: End If;
515: If (p_rec.relocation_required = hr_api.g_varchar2) then
516: p_rec.relocation_required :=
517: per_dpf_shd.g_old_rec.relocation_required;
518: End If;
519: If (p_rec.passport_required = hr_api.g_varchar2) then
520: p_rec.passport_required :=
521: per_dpf_shd.g_old_rec.passport_required;

Line 521: per_dpf_shd.g_old_rec.passport_required;

517: per_dpf_shd.g_old_rec.relocation_required;
518: End If;
519: If (p_rec.passport_required = hr_api.g_varchar2) then
520: p_rec.passport_required :=
521: per_dpf_shd.g_old_rec.passport_required;
522: End If;
523: If (p_rec.location1 = hr_api.g_varchar2) then
524: p_rec.location1 :=
525: per_dpf_shd.g_old_rec.location1;

Line 525: per_dpf_shd.g_old_rec.location1;

521: per_dpf_shd.g_old_rec.passport_required;
522: End If;
523: If (p_rec.location1 = hr_api.g_varchar2) then
524: p_rec.location1 :=
525: per_dpf_shd.g_old_rec.location1;
526: End If;
527: If (p_rec.location2 = hr_api.g_varchar2) then
528: p_rec.location2 :=
529: per_dpf_shd.g_old_rec.location2;

Line 529: per_dpf_shd.g_old_rec.location2;

525: per_dpf_shd.g_old_rec.location1;
526: End If;
527: If (p_rec.location2 = hr_api.g_varchar2) then
528: p_rec.location2 :=
529: per_dpf_shd.g_old_rec.location2;
530: End If;
531: If (p_rec.location3 = hr_api.g_varchar2) then
532: p_rec.location3 :=
533: per_dpf_shd.g_old_rec.location3;

Line 533: per_dpf_shd.g_old_rec.location3;

529: per_dpf_shd.g_old_rec.location2;
530: End If;
531: If (p_rec.location3 = hr_api.g_varchar2) then
532: p_rec.location3 :=
533: per_dpf_shd.g_old_rec.location3;
534: End If;
535: If (p_rec.other_requirements = hr_api.g_varchar2) then
536: p_rec.other_requirements :=
537: per_dpf_shd.g_old_rec.other_requirements;

Line 537: per_dpf_shd.g_old_rec.other_requirements;

533: per_dpf_shd.g_old_rec.location3;
534: End If;
535: If (p_rec.other_requirements = hr_api.g_varchar2) then
536: p_rec.other_requirements :=
537: per_dpf_shd.g_old_rec.other_requirements;
538: End If;
539: If (p_rec.service_minimum = hr_api.g_varchar2) then
540: p_rec.service_minimum :=
541: per_dpf_shd.g_old_rec.service_minimum;

Line 541: per_dpf_shd.g_old_rec.service_minimum;

537: per_dpf_shd.g_old_rec.other_requirements;
538: End If;
539: If (p_rec.service_minimum = hr_api.g_varchar2) then
540: p_rec.service_minimum :=
541: per_dpf_shd.g_old_rec.service_minimum;
542: End If;
543: If (p_rec.attribute_category = hr_api.g_varchar2) then
544: p_rec.attribute_category :=
545: per_dpf_shd.g_old_rec.attribute_category;

Line 545: per_dpf_shd.g_old_rec.attribute_category;

541: per_dpf_shd.g_old_rec.service_minimum;
542: End If;
543: If (p_rec.attribute_category = hr_api.g_varchar2) then
544: p_rec.attribute_category :=
545: per_dpf_shd.g_old_rec.attribute_category;
546: End If;
547: If (p_rec.attribute1 = hr_api.g_varchar2) then
548: p_rec.attribute1 :=
549: per_dpf_shd.g_old_rec.attribute1;

Line 549: per_dpf_shd.g_old_rec.attribute1;

545: per_dpf_shd.g_old_rec.attribute_category;
546: End If;
547: If (p_rec.attribute1 = hr_api.g_varchar2) then
548: p_rec.attribute1 :=
549: per_dpf_shd.g_old_rec.attribute1;
550: End If;
551: If (p_rec.attribute2 = hr_api.g_varchar2) then
552: p_rec.attribute2 :=
553: per_dpf_shd.g_old_rec.attribute2;

Line 553: per_dpf_shd.g_old_rec.attribute2;

549: per_dpf_shd.g_old_rec.attribute1;
550: End If;
551: If (p_rec.attribute2 = hr_api.g_varchar2) then
552: p_rec.attribute2 :=
553: per_dpf_shd.g_old_rec.attribute2;
554: End If;
555: If (p_rec.attribute3 = hr_api.g_varchar2) then
556: p_rec.attribute3 :=
557: per_dpf_shd.g_old_rec.attribute3;

Line 557: per_dpf_shd.g_old_rec.attribute3;

553: per_dpf_shd.g_old_rec.attribute2;
554: End If;
555: If (p_rec.attribute3 = hr_api.g_varchar2) then
556: p_rec.attribute3 :=
557: per_dpf_shd.g_old_rec.attribute3;
558: End If;
559: If (p_rec.attribute4 = hr_api.g_varchar2) then
560: p_rec.attribute4 :=
561: per_dpf_shd.g_old_rec.attribute4;

Line 561: per_dpf_shd.g_old_rec.attribute4;

557: per_dpf_shd.g_old_rec.attribute3;
558: End If;
559: If (p_rec.attribute4 = hr_api.g_varchar2) then
560: p_rec.attribute4 :=
561: per_dpf_shd.g_old_rec.attribute4;
562: End If;
563: If (p_rec.attribute5 = hr_api.g_varchar2) then
564: p_rec.attribute5 :=
565: per_dpf_shd.g_old_rec.attribute5;

Line 565: per_dpf_shd.g_old_rec.attribute5;

561: per_dpf_shd.g_old_rec.attribute4;
562: End If;
563: If (p_rec.attribute5 = hr_api.g_varchar2) then
564: p_rec.attribute5 :=
565: per_dpf_shd.g_old_rec.attribute5;
566: End If;
567: If (p_rec.attribute6 = hr_api.g_varchar2) then
568: p_rec.attribute6 :=
569: per_dpf_shd.g_old_rec.attribute6;

Line 569: per_dpf_shd.g_old_rec.attribute6;

565: per_dpf_shd.g_old_rec.attribute5;
566: End If;
567: If (p_rec.attribute6 = hr_api.g_varchar2) then
568: p_rec.attribute6 :=
569: per_dpf_shd.g_old_rec.attribute6;
570: End If;
571: If (p_rec.attribute7 = hr_api.g_varchar2) then
572: p_rec.attribute7 :=
573: per_dpf_shd.g_old_rec.attribute7;

Line 573: per_dpf_shd.g_old_rec.attribute7;

569: per_dpf_shd.g_old_rec.attribute6;
570: End If;
571: If (p_rec.attribute7 = hr_api.g_varchar2) then
572: p_rec.attribute7 :=
573: per_dpf_shd.g_old_rec.attribute7;
574: End If;
575: If (p_rec.attribute8 = hr_api.g_varchar2) then
576: p_rec.attribute8 :=
577: per_dpf_shd.g_old_rec.attribute8;

Line 577: per_dpf_shd.g_old_rec.attribute8;

573: per_dpf_shd.g_old_rec.attribute7;
574: End If;
575: If (p_rec.attribute8 = hr_api.g_varchar2) then
576: p_rec.attribute8 :=
577: per_dpf_shd.g_old_rec.attribute8;
578: End If;
579: If (p_rec.attribute9 = hr_api.g_varchar2) then
580: p_rec.attribute9 :=
581: per_dpf_shd.g_old_rec.attribute9;

Line 581: per_dpf_shd.g_old_rec.attribute9;

577: per_dpf_shd.g_old_rec.attribute8;
578: End If;
579: If (p_rec.attribute9 = hr_api.g_varchar2) then
580: p_rec.attribute9 :=
581: per_dpf_shd.g_old_rec.attribute9;
582: End If;
583: If (p_rec.attribute10 = hr_api.g_varchar2) then
584: p_rec.attribute10 :=
585: per_dpf_shd.g_old_rec.attribute10;

Line 585: per_dpf_shd.g_old_rec.attribute10;

581: per_dpf_shd.g_old_rec.attribute9;
582: End If;
583: If (p_rec.attribute10 = hr_api.g_varchar2) then
584: p_rec.attribute10 :=
585: per_dpf_shd.g_old_rec.attribute10;
586: End If;
587: If (p_rec.attribute11 = hr_api.g_varchar2) then
588: p_rec.attribute11 :=
589: per_dpf_shd.g_old_rec.attribute11;

Line 589: per_dpf_shd.g_old_rec.attribute11;

585: per_dpf_shd.g_old_rec.attribute10;
586: End If;
587: If (p_rec.attribute11 = hr_api.g_varchar2) then
588: p_rec.attribute11 :=
589: per_dpf_shd.g_old_rec.attribute11;
590: End If;
591: If (p_rec.attribute12 = hr_api.g_varchar2) then
592: p_rec.attribute12 :=
593: per_dpf_shd.g_old_rec.attribute12;

Line 593: per_dpf_shd.g_old_rec.attribute12;

589: per_dpf_shd.g_old_rec.attribute11;
590: End If;
591: If (p_rec.attribute12 = hr_api.g_varchar2) then
592: p_rec.attribute12 :=
593: per_dpf_shd.g_old_rec.attribute12;
594: End If;
595: If (p_rec.attribute13 = hr_api.g_varchar2) then
596: p_rec.attribute13 :=
597: per_dpf_shd.g_old_rec.attribute13;

Line 597: per_dpf_shd.g_old_rec.attribute13;

593: per_dpf_shd.g_old_rec.attribute12;
594: End If;
595: If (p_rec.attribute13 = hr_api.g_varchar2) then
596: p_rec.attribute13 :=
597: per_dpf_shd.g_old_rec.attribute13;
598: End If;
599: If (p_rec.attribute14 = hr_api.g_varchar2) then
600: p_rec.attribute14 :=
601: per_dpf_shd.g_old_rec.attribute14;

Line 601: per_dpf_shd.g_old_rec.attribute14;

597: per_dpf_shd.g_old_rec.attribute13;
598: End If;
599: If (p_rec.attribute14 = hr_api.g_varchar2) then
600: p_rec.attribute14 :=
601: per_dpf_shd.g_old_rec.attribute14;
602: End If;
603: If (p_rec.attribute15 = hr_api.g_varchar2) then
604: p_rec.attribute15 :=
605: per_dpf_shd.g_old_rec.attribute15;

Line 605: per_dpf_shd.g_old_rec.attribute15;

601: per_dpf_shd.g_old_rec.attribute14;
602: End If;
603: If (p_rec.attribute15 = hr_api.g_varchar2) then
604: p_rec.attribute15 :=
605: per_dpf_shd.g_old_rec.attribute15;
606: End If;
607: If (p_rec.attribute16 = hr_api.g_varchar2) then
608: p_rec.attribute16 :=
609: per_dpf_shd.g_old_rec.attribute16;

Line 609: per_dpf_shd.g_old_rec.attribute16;

605: per_dpf_shd.g_old_rec.attribute15;
606: End If;
607: If (p_rec.attribute16 = hr_api.g_varchar2) then
608: p_rec.attribute16 :=
609: per_dpf_shd.g_old_rec.attribute16;
610: End If;
611: If (p_rec.attribute17 = hr_api.g_varchar2) then
612: p_rec.attribute17 :=
613: per_dpf_shd.g_old_rec.attribute17;

Line 613: per_dpf_shd.g_old_rec.attribute17;

609: per_dpf_shd.g_old_rec.attribute16;
610: End If;
611: If (p_rec.attribute17 = hr_api.g_varchar2) then
612: p_rec.attribute17 :=
613: per_dpf_shd.g_old_rec.attribute17;
614: End If;
615: If (p_rec.attribute18 = hr_api.g_varchar2) then
616: p_rec.attribute18 :=
617: per_dpf_shd.g_old_rec.attribute18;

Line 617: per_dpf_shd.g_old_rec.attribute18;

613: per_dpf_shd.g_old_rec.attribute17;
614: End If;
615: If (p_rec.attribute18 = hr_api.g_varchar2) then
616: p_rec.attribute18 :=
617: per_dpf_shd.g_old_rec.attribute18;
618: End If;
619: If (p_rec.attribute19 = hr_api.g_varchar2) then
620: p_rec.attribute19 :=
621: per_dpf_shd.g_old_rec.attribute19;

Line 621: per_dpf_shd.g_old_rec.attribute19;

617: per_dpf_shd.g_old_rec.attribute18;
618: End If;
619: If (p_rec.attribute19 = hr_api.g_varchar2) then
620: p_rec.attribute19 :=
621: per_dpf_shd.g_old_rec.attribute19;
622: End If;
623: If (p_rec.attribute20 = hr_api.g_varchar2) then
624: p_rec.attribute20 :=
625: per_dpf_shd.g_old_rec.attribute20;

Line 625: per_dpf_shd.g_old_rec.attribute20;

621: per_dpf_shd.g_old_rec.attribute19;
622: End If;
623: If (p_rec.attribute20 = hr_api.g_varchar2) then
624: p_rec.attribute20 :=
625: per_dpf_shd.g_old_rec.attribute20;
626: End If;
627: --
628: hr_utility.set_location(' Leaving:'||l_proc, 10);
629: --

Line 637: p_rec in out nocopy per_dpf_shd.g_rec_type,

633: -- |---------------------------------< upd >----------------------------------|
634: -- ----------------------------------------------------------------------------
635: Procedure upd
636: (
637: p_rec in out nocopy per_dpf_shd.g_rec_type,
638: p_effective_date in date
639: ) is
640: --
641: l_proc varchar2(72) := g_package||'upd';

Line 648: per_dpf_shd.lck

644: hr_utility.set_location('Entering:'||l_proc, 5);
645: --
646: -- We must lock the row which we need to update.
647: --
648: per_dpf_shd.lck
649: (
650: p_rec.deployment_factor_id,
651: p_rec.object_version_number
652: );

Line 738: l_rec per_dpf_shd.g_rec_type;

734: p_attribute18 in varchar2 ,
735: p_attribute19 in varchar2 ,
736: p_attribute20 in varchar2 ) is
737: --
738: l_rec per_dpf_shd.g_rec_type;
739: l_proc varchar2(72) := g_package||'upd';
740: --
741: Begin
742: hr_utility.set_location('Entering:'||l_proc, 5);

Line 748: per_dpf_shd.convert_args

744: -- Call conversion function to turn arguments into the
745: -- l_rec structure.
746: --
747: l_rec :=
748: per_dpf_shd.convert_args
749: (
750: p_deployment_factor_id,
751: p_position_id,
752: p_person_id,