50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ghr_pdi_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: --ghr_pdi_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ghr_position_descriptions Row
68: --
69: update ghr_position_descriptions
116: business_group_id = p_rec.business_group_id,
117: object_version_number = p_rec.object_version_number
118: where position_description_id = p_rec.position_description_id;
119: --
120: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
121: --
122: hr_utility.set_location(' Leaving:'||l_proc, 10);
123: --
124: Exception
123: --
124: Exception
125: When hr_api.check_integrity_violated Then
126: -- A check constraint has been violated
127: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
128: ghr_pdi_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.parent_integrity_violated Then
131: -- Parent integrity has been violated
124: Exception
125: When hr_api.check_integrity_violated Then
126: -- A check constraint has been violated
127: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
128: ghr_pdi_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.parent_integrity_violated Then
131: -- Parent integrity has been violated
132: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
128: ghr_pdi_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.parent_integrity_violated Then
131: -- Parent integrity has been violated
132: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
133: ghr_pdi_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.unique_integrity_violated Then
136: -- Unique integrity has been violated
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.parent_integrity_violated Then
131: -- Parent integrity has been violated
132: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
133: ghr_pdi_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.unique_integrity_violated Then
136: -- Unique integrity has been violated
137: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
133: ghr_pdi_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.unique_integrity_violated Then
136: -- Unique integrity has been violated
137: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
138: ghr_pdi_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When Others Then
141: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.unique_integrity_violated Then
136: -- Unique integrity has been violated
137: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
138: ghr_pdi_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When Others Then
141: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
142: Raise;
137: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
138: ghr_pdi_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When Others Then
141: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status
142: Raise;
143: End update_dml;
144: --
145: -- ----------------------------------------------------------------------------
173: -- Internal Row Handler Use Only.
174: --
175: -- {End Of Comments}
176: -- ----------------------------------------------------------------------------
177: Procedure pre_update(p_rec in ghr_pdi_shd.g_rec_type) is
178: --
179: l_proc varchar2(72) := g_package||'pre_update';
180: --
181: Begin
215: -- Internal Row Handler Use Only.
216: --
217: -- {End Of Comments}
218: -- ----------------------------------------------------------------------------
219: Procedure post_update(p_rec in ghr_pdi_shd.g_rec_type) is
220: --
221: l_proc varchar2(72) := g_package||'post_update';
222: --
223: Begin
276: p_attribute19 => p_rec.attribute19,
277: p_attribute20 => p_rec.attribute20,
278: p_business_group_id => p_rec.business_group_id,
279: p_object_version_number => p_rec.object_version_number,
280: p_classifier_date_o => ghr_pdi_shd.g_old_rec.classifier_date,
281: -- p_pa_request_id_o => ghr_pdi_shd.g_old_rec.pa_request_id,
282: p_attribute_category_o => ghr_pdi_shd.g_old_rec.attribute_category,
283: p_routing_group_id_o => ghr_pdi_shd.g_old_rec.routing_group_id,
284: p_date_from_o => ghr_pdi_shd.g_old_rec.date_from,
277: p_attribute20 => p_rec.attribute20,
278: p_business_group_id => p_rec.business_group_id,
279: p_object_version_number => p_rec.object_version_number,
280: p_classifier_date_o => ghr_pdi_shd.g_old_rec.classifier_date,
281: -- p_pa_request_id_o => ghr_pdi_shd.g_old_rec.pa_request_id,
282: p_attribute_category_o => ghr_pdi_shd.g_old_rec.attribute_category,
283: p_routing_group_id_o => ghr_pdi_shd.g_old_rec.routing_group_id,
284: p_date_from_o => ghr_pdi_shd.g_old_rec.date_from,
285: p_date_to_o => ghr_pdi_shd.g_old_rec.date_to,
278: p_business_group_id => p_rec.business_group_id,
279: p_object_version_number => p_rec.object_version_number,
280: p_classifier_date_o => ghr_pdi_shd.g_old_rec.classifier_date,
281: -- p_pa_request_id_o => ghr_pdi_shd.g_old_rec.pa_request_id,
282: p_attribute_category_o => ghr_pdi_shd.g_old_rec.attribute_category,
283: p_routing_group_id_o => ghr_pdi_shd.g_old_rec.routing_group_id,
284: p_date_from_o => ghr_pdi_shd.g_old_rec.date_from,
285: p_date_to_o => ghr_pdi_shd.g_old_rec.date_to,
286: p_opm_cert_num_o => ghr_pdi_shd.g_old_rec.opm_cert_num,
279: p_object_version_number => p_rec.object_version_number,
280: p_classifier_date_o => ghr_pdi_shd.g_old_rec.classifier_date,
281: -- p_pa_request_id_o => ghr_pdi_shd.g_old_rec.pa_request_id,
282: p_attribute_category_o => ghr_pdi_shd.g_old_rec.attribute_category,
283: p_routing_group_id_o => ghr_pdi_shd.g_old_rec.routing_group_id,
284: p_date_from_o => ghr_pdi_shd.g_old_rec.date_from,
285: p_date_to_o => ghr_pdi_shd.g_old_rec.date_to,
286: p_opm_cert_num_o => ghr_pdi_shd.g_old_rec.opm_cert_num,
287: p_flsa_o => ghr_pdi_shd.g_old_rec.flsa,
280: p_classifier_date_o => ghr_pdi_shd.g_old_rec.classifier_date,
281: -- p_pa_request_id_o => ghr_pdi_shd.g_old_rec.pa_request_id,
282: p_attribute_category_o => ghr_pdi_shd.g_old_rec.attribute_category,
283: p_routing_group_id_o => ghr_pdi_shd.g_old_rec.routing_group_id,
284: p_date_from_o => ghr_pdi_shd.g_old_rec.date_from,
285: p_date_to_o => ghr_pdi_shd.g_old_rec.date_to,
286: p_opm_cert_num_o => ghr_pdi_shd.g_old_rec.opm_cert_num,
287: p_flsa_o => ghr_pdi_shd.g_old_rec.flsa,
288: p_financial_statement_o => ghr_pdi_shd.g_old_rec.financial_statement,
281: -- p_pa_request_id_o => ghr_pdi_shd.g_old_rec.pa_request_id,
282: p_attribute_category_o => ghr_pdi_shd.g_old_rec.attribute_category,
283: p_routing_group_id_o => ghr_pdi_shd.g_old_rec.routing_group_id,
284: p_date_from_o => ghr_pdi_shd.g_old_rec.date_from,
285: p_date_to_o => ghr_pdi_shd.g_old_rec.date_to,
286: p_opm_cert_num_o => ghr_pdi_shd.g_old_rec.opm_cert_num,
287: p_flsa_o => ghr_pdi_shd.g_old_rec.flsa,
288: p_financial_statement_o => ghr_pdi_shd.g_old_rec.financial_statement,
289: p_subject_to_ia_action_o => ghr_pdi_shd.g_old_rec.subject_to_ia_action,
282: p_attribute_category_o => ghr_pdi_shd.g_old_rec.attribute_category,
283: p_routing_group_id_o => ghr_pdi_shd.g_old_rec.routing_group_id,
284: p_date_from_o => ghr_pdi_shd.g_old_rec.date_from,
285: p_date_to_o => ghr_pdi_shd.g_old_rec.date_to,
286: p_opm_cert_num_o => ghr_pdi_shd.g_old_rec.opm_cert_num,
287: p_flsa_o => ghr_pdi_shd.g_old_rec.flsa,
288: p_financial_statement_o => ghr_pdi_shd.g_old_rec.financial_statement,
289: p_subject_to_ia_action_o => ghr_pdi_shd.g_old_rec.subject_to_ia_action,
290: p_position_status_o => ghr_pdi_shd.g_old_rec.position_status,
283: p_routing_group_id_o => ghr_pdi_shd.g_old_rec.routing_group_id,
284: p_date_from_o => ghr_pdi_shd.g_old_rec.date_from,
285: p_date_to_o => ghr_pdi_shd.g_old_rec.date_to,
286: p_opm_cert_num_o => ghr_pdi_shd.g_old_rec.opm_cert_num,
287: p_flsa_o => ghr_pdi_shd.g_old_rec.flsa,
288: p_financial_statement_o => ghr_pdi_shd.g_old_rec.financial_statement,
289: p_subject_to_ia_action_o => ghr_pdi_shd.g_old_rec.subject_to_ia_action,
290: p_position_status_o => ghr_pdi_shd.g_old_rec.position_status,
291: p_position_is_o => ghr_pdi_shd.g_old_rec.position_is,
284: p_date_from_o => ghr_pdi_shd.g_old_rec.date_from,
285: p_date_to_o => ghr_pdi_shd.g_old_rec.date_to,
286: p_opm_cert_num_o => ghr_pdi_shd.g_old_rec.opm_cert_num,
287: p_flsa_o => ghr_pdi_shd.g_old_rec.flsa,
288: p_financial_statement_o => ghr_pdi_shd.g_old_rec.financial_statement,
289: p_subject_to_ia_action_o => ghr_pdi_shd.g_old_rec.subject_to_ia_action,
290: p_position_status_o => ghr_pdi_shd.g_old_rec.position_status,
291: p_position_is_o => ghr_pdi_shd.g_old_rec.position_is,
292: p_position_sensitivity_o => ghr_pdi_shd.g_old_rec.position_sensitivity,
285: p_date_to_o => ghr_pdi_shd.g_old_rec.date_to,
286: p_opm_cert_num_o => ghr_pdi_shd.g_old_rec.opm_cert_num,
287: p_flsa_o => ghr_pdi_shd.g_old_rec.flsa,
288: p_financial_statement_o => ghr_pdi_shd.g_old_rec.financial_statement,
289: p_subject_to_ia_action_o => ghr_pdi_shd.g_old_rec.subject_to_ia_action,
290: p_position_status_o => ghr_pdi_shd.g_old_rec.position_status,
291: p_position_is_o => ghr_pdi_shd.g_old_rec.position_is,
292: p_position_sensitivity_o => ghr_pdi_shd.g_old_rec.position_sensitivity,
293: p_competitive_level_o => ghr_pdi_shd.g_old_rec.competitive_level,
286: p_opm_cert_num_o => ghr_pdi_shd.g_old_rec.opm_cert_num,
287: p_flsa_o => ghr_pdi_shd.g_old_rec.flsa,
288: p_financial_statement_o => ghr_pdi_shd.g_old_rec.financial_statement,
289: p_subject_to_ia_action_o => ghr_pdi_shd.g_old_rec.subject_to_ia_action,
290: p_position_status_o => ghr_pdi_shd.g_old_rec.position_status,
291: p_position_is_o => ghr_pdi_shd.g_old_rec.position_is,
292: p_position_sensitivity_o => ghr_pdi_shd.g_old_rec.position_sensitivity,
293: p_competitive_level_o => ghr_pdi_shd.g_old_rec.competitive_level,
294: p_pd_remarks_o => ghr_pdi_shd.g_old_rec.pd_remarks,
287: p_flsa_o => ghr_pdi_shd.g_old_rec.flsa,
288: p_financial_statement_o => ghr_pdi_shd.g_old_rec.financial_statement,
289: p_subject_to_ia_action_o => ghr_pdi_shd.g_old_rec.subject_to_ia_action,
290: p_position_status_o => ghr_pdi_shd.g_old_rec.position_status,
291: p_position_is_o => ghr_pdi_shd.g_old_rec.position_is,
292: p_position_sensitivity_o => ghr_pdi_shd.g_old_rec.position_sensitivity,
293: p_competitive_level_o => ghr_pdi_shd.g_old_rec.competitive_level,
294: p_pd_remarks_o => ghr_pdi_shd.g_old_rec.pd_remarks,
295: p_position_class_std_o => ghr_pdi_shd.g_old_rec.position_class_std,
288: p_financial_statement_o => ghr_pdi_shd.g_old_rec.financial_statement,
289: p_subject_to_ia_action_o => ghr_pdi_shd.g_old_rec.subject_to_ia_action,
290: p_position_status_o => ghr_pdi_shd.g_old_rec.position_status,
291: p_position_is_o => ghr_pdi_shd.g_old_rec.position_is,
292: p_position_sensitivity_o => ghr_pdi_shd.g_old_rec.position_sensitivity,
293: p_competitive_level_o => ghr_pdi_shd.g_old_rec.competitive_level,
294: p_pd_remarks_o => ghr_pdi_shd.g_old_rec.pd_remarks,
295: p_position_class_std_o => ghr_pdi_shd.g_old_rec.position_class_std,
296: p_category_o => ghr_pdi_shd.g_old_rec.category,
289: p_subject_to_ia_action_o => ghr_pdi_shd.g_old_rec.subject_to_ia_action,
290: p_position_status_o => ghr_pdi_shd.g_old_rec.position_status,
291: p_position_is_o => ghr_pdi_shd.g_old_rec.position_is,
292: p_position_sensitivity_o => ghr_pdi_shd.g_old_rec.position_sensitivity,
293: p_competitive_level_o => ghr_pdi_shd.g_old_rec.competitive_level,
294: p_pd_remarks_o => ghr_pdi_shd.g_old_rec.pd_remarks,
295: p_position_class_std_o => ghr_pdi_shd.g_old_rec.position_class_std,
296: p_category_o => ghr_pdi_shd.g_old_rec.category,
297: p_career_ladder_o => ghr_pdi_shd.g_old_rec.career_ladder,
290: p_position_status_o => ghr_pdi_shd.g_old_rec.position_status,
291: p_position_is_o => ghr_pdi_shd.g_old_rec.position_is,
292: p_position_sensitivity_o => ghr_pdi_shd.g_old_rec.position_sensitivity,
293: p_competitive_level_o => ghr_pdi_shd.g_old_rec.competitive_level,
294: p_pd_remarks_o => ghr_pdi_shd.g_old_rec.pd_remarks,
295: p_position_class_std_o => ghr_pdi_shd.g_old_rec.position_class_std,
296: p_category_o => ghr_pdi_shd.g_old_rec.category,
297: p_career_ladder_o => ghr_pdi_shd.g_old_rec.career_ladder,
298: p_supervisor_name_o => ghr_pdi_shd.g_old_rec.supervisor_name,
291: p_position_is_o => ghr_pdi_shd.g_old_rec.position_is,
292: p_position_sensitivity_o => ghr_pdi_shd.g_old_rec.position_sensitivity,
293: p_competitive_level_o => ghr_pdi_shd.g_old_rec.competitive_level,
294: p_pd_remarks_o => ghr_pdi_shd.g_old_rec.pd_remarks,
295: p_position_class_std_o => ghr_pdi_shd.g_old_rec.position_class_std,
296: p_category_o => ghr_pdi_shd.g_old_rec.category,
297: p_career_ladder_o => ghr_pdi_shd.g_old_rec.career_ladder,
298: p_supervisor_name_o => ghr_pdi_shd.g_old_rec.supervisor_name,
299: p_supervisor_title_o => ghr_pdi_shd.g_old_rec.supervisor_title,
292: p_position_sensitivity_o => ghr_pdi_shd.g_old_rec.position_sensitivity,
293: p_competitive_level_o => ghr_pdi_shd.g_old_rec.competitive_level,
294: p_pd_remarks_o => ghr_pdi_shd.g_old_rec.pd_remarks,
295: p_position_class_std_o => ghr_pdi_shd.g_old_rec.position_class_std,
296: p_category_o => ghr_pdi_shd.g_old_rec.category,
297: p_career_ladder_o => ghr_pdi_shd.g_old_rec.career_ladder,
298: p_supervisor_name_o => ghr_pdi_shd.g_old_rec.supervisor_name,
299: p_supervisor_title_o => ghr_pdi_shd.g_old_rec.supervisor_title,
300: p_supervisor_date_o => ghr_pdi_shd.g_old_rec.supervisor_date,
293: p_competitive_level_o => ghr_pdi_shd.g_old_rec.competitive_level,
294: p_pd_remarks_o => ghr_pdi_shd.g_old_rec.pd_remarks,
295: p_position_class_std_o => ghr_pdi_shd.g_old_rec.position_class_std,
296: p_category_o => ghr_pdi_shd.g_old_rec.category,
297: p_career_ladder_o => ghr_pdi_shd.g_old_rec.career_ladder,
298: p_supervisor_name_o => ghr_pdi_shd.g_old_rec.supervisor_name,
299: p_supervisor_title_o => ghr_pdi_shd.g_old_rec.supervisor_title,
300: p_supervisor_date_o => ghr_pdi_shd.g_old_rec.supervisor_date,
301: p_manager_name_o => ghr_pdi_shd.g_old_rec.manager_name,
294: p_pd_remarks_o => ghr_pdi_shd.g_old_rec.pd_remarks,
295: p_position_class_std_o => ghr_pdi_shd.g_old_rec.position_class_std,
296: p_category_o => ghr_pdi_shd.g_old_rec.category,
297: p_career_ladder_o => ghr_pdi_shd.g_old_rec.career_ladder,
298: p_supervisor_name_o => ghr_pdi_shd.g_old_rec.supervisor_name,
299: p_supervisor_title_o => ghr_pdi_shd.g_old_rec.supervisor_title,
300: p_supervisor_date_o => ghr_pdi_shd.g_old_rec.supervisor_date,
301: p_manager_name_o => ghr_pdi_shd.g_old_rec.manager_name,
302: p_manager_title_o => ghr_pdi_shd.g_old_rec.manager_title,
295: p_position_class_std_o => ghr_pdi_shd.g_old_rec.position_class_std,
296: p_category_o => ghr_pdi_shd.g_old_rec.category,
297: p_career_ladder_o => ghr_pdi_shd.g_old_rec.career_ladder,
298: p_supervisor_name_o => ghr_pdi_shd.g_old_rec.supervisor_name,
299: p_supervisor_title_o => ghr_pdi_shd.g_old_rec.supervisor_title,
300: p_supervisor_date_o => ghr_pdi_shd.g_old_rec.supervisor_date,
301: p_manager_name_o => ghr_pdi_shd.g_old_rec.manager_name,
302: p_manager_title_o => ghr_pdi_shd.g_old_rec.manager_title,
303: p_manager_date_o => ghr_pdi_shd.g_old_rec.manager_date,
296: p_category_o => ghr_pdi_shd.g_old_rec.category,
297: p_career_ladder_o => ghr_pdi_shd.g_old_rec.career_ladder,
298: p_supervisor_name_o => ghr_pdi_shd.g_old_rec.supervisor_name,
299: p_supervisor_title_o => ghr_pdi_shd.g_old_rec.supervisor_title,
300: p_supervisor_date_o => ghr_pdi_shd.g_old_rec.supervisor_date,
301: p_manager_name_o => ghr_pdi_shd.g_old_rec.manager_name,
302: p_manager_title_o => ghr_pdi_shd.g_old_rec.manager_title,
303: p_manager_date_o => ghr_pdi_shd.g_old_rec.manager_date,
304: p_classifier_name_o => ghr_pdi_shd.g_old_rec.classifier_name,
297: p_career_ladder_o => ghr_pdi_shd.g_old_rec.career_ladder,
298: p_supervisor_name_o => ghr_pdi_shd.g_old_rec.supervisor_name,
299: p_supervisor_title_o => ghr_pdi_shd.g_old_rec.supervisor_title,
300: p_supervisor_date_o => ghr_pdi_shd.g_old_rec.supervisor_date,
301: p_manager_name_o => ghr_pdi_shd.g_old_rec.manager_name,
302: p_manager_title_o => ghr_pdi_shd.g_old_rec.manager_title,
303: p_manager_date_o => ghr_pdi_shd.g_old_rec.manager_date,
304: p_classifier_name_o => ghr_pdi_shd.g_old_rec.classifier_name,
305: p_classifier_title_o => ghr_pdi_shd.g_old_rec.classifier_title,
298: p_supervisor_name_o => ghr_pdi_shd.g_old_rec.supervisor_name,
299: p_supervisor_title_o => ghr_pdi_shd.g_old_rec.supervisor_title,
300: p_supervisor_date_o => ghr_pdi_shd.g_old_rec.supervisor_date,
301: p_manager_name_o => ghr_pdi_shd.g_old_rec.manager_name,
302: p_manager_title_o => ghr_pdi_shd.g_old_rec.manager_title,
303: p_manager_date_o => ghr_pdi_shd.g_old_rec.manager_date,
304: p_classifier_name_o => ghr_pdi_shd.g_old_rec.classifier_name,
305: p_classifier_title_o => ghr_pdi_shd.g_old_rec.classifier_title,
306: p_attribute1_o => ghr_pdi_shd.g_old_rec.attribute1,
299: p_supervisor_title_o => ghr_pdi_shd.g_old_rec.supervisor_title,
300: p_supervisor_date_o => ghr_pdi_shd.g_old_rec.supervisor_date,
301: p_manager_name_o => ghr_pdi_shd.g_old_rec.manager_name,
302: p_manager_title_o => ghr_pdi_shd.g_old_rec.manager_title,
303: p_manager_date_o => ghr_pdi_shd.g_old_rec.manager_date,
304: p_classifier_name_o => ghr_pdi_shd.g_old_rec.classifier_name,
305: p_classifier_title_o => ghr_pdi_shd.g_old_rec.classifier_title,
306: p_attribute1_o => ghr_pdi_shd.g_old_rec.attribute1,
307: p_attribute2_o => ghr_pdi_shd.g_old_rec.attribute2,
300: p_supervisor_date_o => ghr_pdi_shd.g_old_rec.supervisor_date,
301: p_manager_name_o => ghr_pdi_shd.g_old_rec.manager_name,
302: p_manager_title_o => ghr_pdi_shd.g_old_rec.manager_title,
303: p_manager_date_o => ghr_pdi_shd.g_old_rec.manager_date,
304: p_classifier_name_o => ghr_pdi_shd.g_old_rec.classifier_name,
305: p_classifier_title_o => ghr_pdi_shd.g_old_rec.classifier_title,
306: p_attribute1_o => ghr_pdi_shd.g_old_rec.attribute1,
307: p_attribute2_o => ghr_pdi_shd.g_old_rec.attribute2,
308: p_attribute3_o => ghr_pdi_shd.g_old_rec.attribute3,
301: p_manager_name_o => ghr_pdi_shd.g_old_rec.manager_name,
302: p_manager_title_o => ghr_pdi_shd.g_old_rec.manager_title,
303: p_manager_date_o => ghr_pdi_shd.g_old_rec.manager_date,
304: p_classifier_name_o => ghr_pdi_shd.g_old_rec.classifier_name,
305: p_classifier_title_o => ghr_pdi_shd.g_old_rec.classifier_title,
306: p_attribute1_o => ghr_pdi_shd.g_old_rec.attribute1,
307: p_attribute2_o => ghr_pdi_shd.g_old_rec.attribute2,
308: p_attribute3_o => ghr_pdi_shd.g_old_rec.attribute3,
309: p_attribute4_o => ghr_pdi_shd.g_old_rec.attribute4,
302: p_manager_title_o => ghr_pdi_shd.g_old_rec.manager_title,
303: p_manager_date_o => ghr_pdi_shd.g_old_rec.manager_date,
304: p_classifier_name_o => ghr_pdi_shd.g_old_rec.classifier_name,
305: p_classifier_title_o => ghr_pdi_shd.g_old_rec.classifier_title,
306: p_attribute1_o => ghr_pdi_shd.g_old_rec.attribute1,
307: p_attribute2_o => ghr_pdi_shd.g_old_rec.attribute2,
308: p_attribute3_o => ghr_pdi_shd.g_old_rec.attribute3,
309: p_attribute4_o => ghr_pdi_shd.g_old_rec.attribute4,
310: p_attribute5_o => ghr_pdi_shd.g_old_rec.attribute5,
303: p_manager_date_o => ghr_pdi_shd.g_old_rec.manager_date,
304: p_classifier_name_o => ghr_pdi_shd.g_old_rec.classifier_name,
305: p_classifier_title_o => ghr_pdi_shd.g_old_rec.classifier_title,
306: p_attribute1_o => ghr_pdi_shd.g_old_rec.attribute1,
307: p_attribute2_o => ghr_pdi_shd.g_old_rec.attribute2,
308: p_attribute3_o => ghr_pdi_shd.g_old_rec.attribute3,
309: p_attribute4_o => ghr_pdi_shd.g_old_rec.attribute4,
310: p_attribute5_o => ghr_pdi_shd.g_old_rec.attribute5,
311: p_attribute6_o => ghr_pdi_shd.g_old_rec.attribute6,
304: p_classifier_name_o => ghr_pdi_shd.g_old_rec.classifier_name,
305: p_classifier_title_o => ghr_pdi_shd.g_old_rec.classifier_title,
306: p_attribute1_o => ghr_pdi_shd.g_old_rec.attribute1,
307: p_attribute2_o => ghr_pdi_shd.g_old_rec.attribute2,
308: p_attribute3_o => ghr_pdi_shd.g_old_rec.attribute3,
309: p_attribute4_o => ghr_pdi_shd.g_old_rec.attribute4,
310: p_attribute5_o => ghr_pdi_shd.g_old_rec.attribute5,
311: p_attribute6_o => ghr_pdi_shd.g_old_rec.attribute6,
312: p_attribute7_o => ghr_pdi_shd.g_old_rec.attribute7,
305: p_classifier_title_o => ghr_pdi_shd.g_old_rec.classifier_title,
306: p_attribute1_o => ghr_pdi_shd.g_old_rec.attribute1,
307: p_attribute2_o => ghr_pdi_shd.g_old_rec.attribute2,
308: p_attribute3_o => ghr_pdi_shd.g_old_rec.attribute3,
309: p_attribute4_o => ghr_pdi_shd.g_old_rec.attribute4,
310: p_attribute5_o => ghr_pdi_shd.g_old_rec.attribute5,
311: p_attribute6_o => ghr_pdi_shd.g_old_rec.attribute6,
312: p_attribute7_o => ghr_pdi_shd.g_old_rec.attribute7,
313: p_attribute8_o => ghr_pdi_shd.g_old_rec.attribute8,
306: p_attribute1_o => ghr_pdi_shd.g_old_rec.attribute1,
307: p_attribute2_o => ghr_pdi_shd.g_old_rec.attribute2,
308: p_attribute3_o => ghr_pdi_shd.g_old_rec.attribute3,
309: p_attribute4_o => ghr_pdi_shd.g_old_rec.attribute4,
310: p_attribute5_o => ghr_pdi_shd.g_old_rec.attribute5,
311: p_attribute6_o => ghr_pdi_shd.g_old_rec.attribute6,
312: p_attribute7_o => ghr_pdi_shd.g_old_rec.attribute7,
313: p_attribute8_o => ghr_pdi_shd.g_old_rec.attribute8,
314: p_attribute9_o => ghr_pdi_shd.g_old_rec.attribute9,
307: p_attribute2_o => ghr_pdi_shd.g_old_rec.attribute2,
308: p_attribute3_o => ghr_pdi_shd.g_old_rec.attribute3,
309: p_attribute4_o => ghr_pdi_shd.g_old_rec.attribute4,
310: p_attribute5_o => ghr_pdi_shd.g_old_rec.attribute5,
311: p_attribute6_o => ghr_pdi_shd.g_old_rec.attribute6,
312: p_attribute7_o => ghr_pdi_shd.g_old_rec.attribute7,
313: p_attribute8_o => ghr_pdi_shd.g_old_rec.attribute8,
314: p_attribute9_o => ghr_pdi_shd.g_old_rec.attribute9,
315: p_attribute10_o => ghr_pdi_shd.g_old_rec.attribute10,
308: p_attribute3_o => ghr_pdi_shd.g_old_rec.attribute3,
309: p_attribute4_o => ghr_pdi_shd.g_old_rec.attribute4,
310: p_attribute5_o => ghr_pdi_shd.g_old_rec.attribute5,
311: p_attribute6_o => ghr_pdi_shd.g_old_rec.attribute6,
312: p_attribute7_o => ghr_pdi_shd.g_old_rec.attribute7,
313: p_attribute8_o => ghr_pdi_shd.g_old_rec.attribute8,
314: p_attribute9_o => ghr_pdi_shd.g_old_rec.attribute9,
315: p_attribute10_o => ghr_pdi_shd.g_old_rec.attribute10,
316: p_attribute11_o => ghr_pdi_shd.g_old_rec.attribute11,
309: p_attribute4_o => ghr_pdi_shd.g_old_rec.attribute4,
310: p_attribute5_o => ghr_pdi_shd.g_old_rec.attribute5,
311: p_attribute6_o => ghr_pdi_shd.g_old_rec.attribute6,
312: p_attribute7_o => ghr_pdi_shd.g_old_rec.attribute7,
313: p_attribute8_o => ghr_pdi_shd.g_old_rec.attribute8,
314: p_attribute9_o => ghr_pdi_shd.g_old_rec.attribute9,
315: p_attribute10_o => ghr_pdi_shd.g_old_rec.attribute10,
316: p_attribute11_o => ghr_pdi_shd.g_old_rec.attribute11,
317: p_attribute12_o => ghr_pdi_shd.g_old_rec.attribute12,
310: p_attribute5_o => ghr_pdi_shd.g_old_rec.attribute5,
311: p_attribute6_o => ghr_pdi_shd.g_old_rec.attribute6,
312: p_attribute7_o => ghr_pdi_shd.g_old_rec.attribute7,
313: p_attribute8_o => ghr_pdi_shd.g_old_rec.attribute8,
314: p_attribute9_o => ghr_pdi_shd.g_old_rec.attribute9,
315: p_attribute10_o => ghr_pdi_shd.g_old_rec.attribute10,
316: p_attribute11_o => ghr_pdi_shd.g_old_rec.attribute11,
317: p_attribute12_o => ghr_pdi_shd.g_old_rec.attribute12,
318: p_attribute13_o => ghr_pdi_shd.g_old_rec.attribute13,
311: p_attribute6_o => ghr_pdi_shd.g_old_rec.attribute6,
312: p_attribute7_o => ghr_pdi_shd.g_old_rec.attribute7,
313: p_attribute8_o => ghr_pdi_shd.g_old_rec.attribute8,
314: p_attribute9_o => ghr_pdi_shd.g_old_rec.attribute9,
315: p_attribute10_o => ghr_pdi_shd.g_old_rec.attribute10,
316: p_attribute11_o => ghr_pdi_shd.g_old_rec.attribute11,
317: p_attribute12_o => ghr_pdi_shd.g_old_rec.attribute12,
318: p_attribute13_o => ghr_pdi_shd.g_old_rec.attribute13,
319: p_attribute14_o => ghr_pdi_shd.g_old_rec.attribute14,
312: p_attribute7_o => ghr_pdi_shd.g_old_rec.attribute7,
313: p_attribute8_o => ghr_pdi_shd.g_old_rec.attribute8,
314: p_attribute9_o => ghr_pdi_shd.g_old_rec.attribute9,
315: p_attribute10_o => ghr_pdi_shd.g_old_rec.attribute10,
316: p_attribute11_o => ghr_pdi_shd.g_old_rec.attribute11,
317: p_attribute12_o => ghr_pdi_shd.g_old_rec.attribute12,
318: p_attribute13_o => ghr_pdi_shd.g_old_rec.attribute13,
319: p_attribute14_o => ghr_pdi_shd.g_old_rec.attribute14,
320: p_attribute15_o => ghr_pdi_shd.g_old_rec.attribute15,
313: p_attribute8_o => ghr_pdi_shd.g_old_rec.attribute8,
314: p_attribute9_o => ghr_pdi_shd.g_old_rec.attribute9,
315: p_attribute10_o => ghr_pdi_shd.g_old_rec.attribute10,
316: p_attribute11_o => ghr_pdi_shd.g_old_rec.attribute11,
317: p_attribute12_o => ghr_pdi_shd.g_old_rec.attribute12,
318: p_attribute13_o => ghr_pdi_shd.g_old_rec.attribute13,
319: p_attribute14_o => ghr_pdi_shd.g_old_rec.attribute14,
320: p_attribute15_o => ghr_pdi_shd.g_old_rec.attribute15,
321: p_attribute16_o => ghr_pdi_shd.g_old_rec.attribute16,
314: p_attribute9_o => ghr_pdi_shd.g_old_rec.attribute9,
315: p_attribute10_o => ghr_pdi_shd.g_old_rec.attribute10,
316: p_attribute11_o => ghr_pdi_shd.g_old_rec.attribute11,
317: p_attribute12_o => ghr_pdi_shd.g_old_rec.attribute12,
318: p_attribute13_o => ghr_pdi_shd.g_old_rec.attribute13,
319: p_attribute14_o => ghr_pdi_shd.g_old_rec.attribute14,
320: p_attribute15_o => ghr_pdi_shd.g_old_rec.attribute15,
321: p_attribute16_o => ghr_pdi_shd.g_old_rec.attribute16,
322: p_attribute17_o => ghr_pdi_shd.g_old_rec.attribute17,
315: p_attribute10_o => ghr_pdi_shd.g_old_rec.attribute10,
316: p_attribute11_o => ghr_pdi_shd.g_old_rec.attribute11,
317: p_attribute12_o => ghr_pdi_shd.g_old_rec.attribute12,
318: p_attribute13_o => ghr_pdi_shd.g_old_rec.attribute13,
319: p_attribute14_o => ghr_pdi_shd.g_old_rec.attribute14,
320: p_attribute15_o => ghr_pdi_shd.g_old_rec.attribute15,
321: p_attribute16_o => ghr_pdi_shd.g_old_rec.attribute16,
322: p_attribute17_o => ghr_pdi_shd.g_old_rec.attribute17,
323: p_attribute18_o => ghr_pdi_shd.g_old_rec.attribute18,
316: p_attribute11_o => ghr_pdi_shd.g_old_rec.attribute11,
317: p_attribute12_o => ghr_pdi_shd.g_old_rec.attribute12,
318: p_attribute13_o => ghr_pdi_shd.g_old_rec.attribute13,
319: p_attribute14_o => ghr_pdi_shd.g_old_rec.attribute14,
320: p_attribute15_o => ghr_pdi_shd.g_old_rec.attribute15,
321: p_attribute16_o => ghr_pdi_shd.g_old_rec.attribute16,
322: p_attribute17_o => ghr_pdi_shd.g_old_rec.attribute17,
323: p_attribute18_o => ghr_pdi_shd.g_old_rec.attribute18,
324: p_attribute19_o => ghr_pdi_shd.g_old_rec.attribute19,
317: p_attribute12_o => ghr_pdi_shd.g_old_rec.attribute12,
318: p_attribute13_o => ghr_pdi_shd.g_old_rec.attribute13,
319: p_attribute14_o => ghr_pdi_shd.g_old_rec.attribute14,
320: p_attribute15_o => ghr_pdi_shd.g_old_rec.attribute15,
321: p_attribute16_o => ghr_pdi_shd.g_old_rec.attribute16,
322: p_attribute17_o => ghr_pdi_shd.g_old_rec.attribute17,
323: p_attribute18_o => ghr_pdi_shd.g_old_rec.attribute18,
324: p_attribute19_o => ghr_pdi_shd.g_old_rec.attribute19,
325: p_attribute20_o => ghr_pdi_shd.g_old_rec.attribute20,
318: p_attribute13_o => ghr_pdi_shd.g_old_rec.attribute13,
319: p_attribute14_o => ghr_pdi_shd.g_old_rec.attribute14,
320: p_attribute15_o => ghr_pdi_shd.g_old_rec.attribute15,
321: p_attribute16_o => ghr_pdi_shd.g_old_rec.attribute16,
322: p_attribute17_o => ghr_pdi_shd.g_old_rec.attribute17,
323: p_attribute18_o => ghr_pdi_shd.g_old_rec.attribute18,
324: p_attribute19_o => ghr_pdi_shd.g_old_rec.attribute19,
325: p_attribute20_o => ghr_pdi_shd.g_old_rec.attribute20,
326: p_business_group_id_o => ghr_pdi_shd.g_old_rec.business_group_id,
319: p_attribute14_o => ghr_pdi_shd.g_old_rec.attribute14,
320: p_attribute15_o => ghr_pdi_shd.g_old_rec.attribute15,
321: p_attribute16_o => ghr_pdi_shd.g_old_rec.attribute16,
322: p_attribute17_o => ghr_pdi_shd.g_old_rec.attribute17,
323: p_attribute18_o => ghr_pdi_shd.g_old_rec.attribute18,
324: p_attribute19_o => ghr_pdi_shd.g_old_rec.attribute19,
325: p_attribute20_o => ghr_pdi_shd.g_old_rec.attribute20,
326: p_business_group_id_o => ghr_pdi_shd.g_old_rec.business_group_id,
327: p_object_version_number_o => ghr_pdi_shd.g_old_rec.object_version_number
320: p_attribute15_o => ghr_pdi_shd.g_old_rec.attribute15,
321: p_attribute16_o => ghr_pdi_shd.g_old_rec.attribute16,
322: p_attribute17_o => ghr_pdi_shd.g_old_rec.attribute17,
323: p_attribute18_o => ghr_pdi_shd.g_old_rec.attribute18,
324: p_attribute19_o => ghr_pdi_shd.g_old_rec.attribute19,
325: p_attribute20_o => ghr_pdi_shd.g_old_rec.attribute20,
326: p_business_group_id_o => ghr_pdi_shd.g_old_rec.business_group_id,
327: p_object_version_number_o => ghr_pdi_shd.g_old_rec.object_version_number
328: );
321: p_attribute16_o => ghr_pdi_shd.g_old_rec.attribute16,
322: p_attribute17_o => ghr_pdi_shd.g_old_rec.attribute17,
323: p_attribute18_o => ghr_pdi_shd.g_old_rec.attribute18,
324: p_attribute19_o => ghr_pdi_shd.g_old_rec.attribute19,
325: p_attribute20_o => ghr_pdi_shd.g_old_rec.attribute20,
326: p_business_group_id_o => ghr_pdi_shd.g_old_rec.business_group_id,
327: p_object_version_number_o => ghr_pdi_shd.g_old_rec.object_version_number
328: );
329:
322: p_attribute17_o => ghr_pdi_shd.g_old_rec.attribute17,
323: p_attribute18_o => ghr_pdi_shd.g_old_rec.attribute18,
324: p_attribute19_o => ghr_pdi_shd.g_old_rec.attribute19,
325: p_attribute20_o => ghr_pdi_shd.g_old_rec.attribute20,
326: p_business_group_id_o => ghr_pdi_shd.g_old_rec.business_group_id,
327: p_object_version_number_o => ghr_pdi_shd.g_old_rec.object_version_number
328: );
329:
330: exception
323: p_attribute18_o => ghr_pdi_shd.g_old_rec.attribute18,
324: p_attribute19_o => ghr_pdi_shd.g_old_rec.attribute19,
325: p_attribute20_o => ghr_pdi_shd.g_old_rec.attribute20,
326: p_business_group_id_o => ghr_pdi_shd.g_old_rec.business_group_id,
327: p_object_version_number_o => ghr_pdi_shd.g_old_rec.object_version_number
328: );
329:
330: exception
331: when hr_api.cannot_find_prog_unit then
383: -- Internal Row Handler Use Only.
384: --
385: -- {End Of Comments}
386: -- ----------------------------------------------------------------------------
387: Procedure convert_defs(p_rec in out nocopy ghr_pdi_shd.g_rec_type) is
388: --
389: l_proc varchar2(72) := g_package||'convert_defs';
390: --
391: Begin
398: -- is being used then we must set to the 'current' argument value.
399: --
400: If (p_rec.routing_group_id = hr_api.g_number) then
401: p_rec.routing_group_id :=
402: ghr_pdi_shd.g_old_rec.routing_group_id;
403: End If;
404: If (p_rec.date_from = hr_api.g_date) then
405: p_rec.date_from :=
406: ghr_pdi_shd.g_old_rec.date_from;
402: ghr_pdi_shd.g_old_rec.routing_group_id;
403: End If;
404: If (p_rec.date_from = hr_api.g_date) then
405: p_rec.date_from :=
406: ghr_pdi_shd.g_old_rec.date_from;
407: End If;
408: If (p_rec.date_to = hr_api.g_date) then
409: p_rec.date_to :=
410: ghr_pdi_shd.g_old_rec.date_to;
406: ghr_pdi_shd.g_old_rec.date_from;
407: End If;
408: If (p_rec.date_to = hr_api.g_date) then
409: p_rec.date_to :=
410: ghr_pdi_shd.g_old_rec.date_to;
411: End If;
412: If (p_rec.opm_cert_num = hr_api.g_varchar2) then
413: p_rec.opm_cert_num :=
414: ghr_pdi_shd.g_old_rec.opm_cert_num;
410: ghr_pdi_shd.g_old_rec.date_to;
411: End If;
412: If (p_rec.opm_cert_num = hr_api.g_varchar2) then
413: p_rec.opm_cert_num :=
414: ghr_pdi_shd.g_old_rec.opm_cert_num;
415: End If;
416: If (p_rec.flsa = hr_api.g_varchar2) then
417: p_rec.flsa :=
418: ghr_pdi_shd.g_old_rec.flsa;
414: ghr_pdi_shd.g_old_rec.opm_cert_num;
415: End If;
416: If (p_rec.flsa = hr_api.g_varchar2) then
417: p_rec.flsa :=
418: ghr_pdi_shd.g_old_rec.flsa;
419: End If;
420: If (p_rec.financial_statement = hr_api.g_varchar2) then
421: p_rec.financial_statement :=
422: ghr_pdi_shd.g_old_rec.financial_statement;
418: ghr_pdi_shd.g_old_rec.flsa;
419: End If;
420: If (p_rec.financial_statement = hr_api.g_varchar2) then
421: p_rec.financial_statement :=
422: ghr_pdi_shd.g_old_rec.financial_statement;
423: End If;
424: If (p_rec.subject_to_ia_action = hr_api.g_varchar2) then
425: p_rec.subject_to_ia_action :=
426: ghr_pdi_shd.g_old_rec.subject_to_ia_action;
422: ghr_pdi_shd.g_old_rec.financial_statement;
423: End If;
424: If (p_rec.subject_to_ia_action = hr_api.g_varchar2) then
425: p_rec.subject_to_ia_action :=
426: ghr_pdi_shd.g_old_rec.subject_to_ia_action;
427: End If;
428: If (p_rec.position_status = hr_api.g_number) then
429: p_rec.position_status :=
430: ghr_pdi_shd.g_old_rec.position_status;
426: ghr_pdi_shd.g_old_rec.subject_to_ia_action;
427: End If;
428: If (p_rec.position_status = hr_api.g_number) then
429: p_rec.position_status :=
430: ghr_pdi_shd.g_old_rec.position_status;
431: End If;
432: If (p_rec.position_is = hr_api.g_varchar2) then
433: p_rec.position_is :=
434: ghr_pdi_shd.g_old_rec.position_is;
430: ghr_pdi_shd.g_old_rec.position_status;
431: End If;
432: If (p_rec.position_is = hr_api.g_varchar2) then
433: p_rec.position_is :=
434: ghr_pdi_shd.g_old_rec.position_is;
435: End If;
436: If (p_rec.position_sensitivity = hr_api.g_varchar2) then
437: p_rec.position_sensitivity :=
438: ghr_pdi_shd.g_old_rec.position_sensitivity;
434: ghr_pdi_shd.g_old_rec.position_is;
435: End If;
436: If (p_rec.position_sensitivity = hr_api.g_varchar2) then
437: p_rec.position_sensitivity :=
438: ghr_pdi_shd.g_old_rec.position_sensitivity;
439: End If;
440: If (p_rec.competitive_level = hr_api.g_varchar2) then
441: p_rec.competitive_level :=
442: ghr_pdi_shd.g_old_rec.competitive_level;
438: ghr_pdi_shd.g_old_rec.position_sensitivity;
439: End If;
440: If (p_rec.competitive_level = hr_api.g_varchar2) then
441: p_rec.competitive_level :=
442: ghr_pdi_shd.g_old_rec.competitive_level;
443: End If;
444: If (p_rec.pd_remarks = hr_api.g_varchar2) then
445: p_rec.pd_remarks :=
446: ghr_pdi_shd.g_old_rec.pd_remarks;
442: ghr_pdi_shd.g_old_rec.competitive_level;
443: End If;
444: If (p_rec.pd_remarks = hr_api.g_varchar2) then
445: p_rec.pd_remarks :=
446: ghr_pdi_shd.g_old_rec.pd_remarks;
447: End If;
448: If (p_rec.position_class_std = hr_api.g_varchar2) then
449: p_rec.position_class_std :=
450: ghr_pdi_shd.g_old_rec.position_class_std;
446: ghr_pdi_shd.g_old_rec.pd_remarks;
447: End If;
448: If (p_rec.position_class_std = hr_api.g_varchar2) then
449: p_rec.position_class_std :=
450: ghr_pdi_shd.g_old_rec.position_class_std;
451: End If;
452: If (p_rec.category = hr_api.g_varchar2) then
453: p_rec.category :=
454: ghr_pdi_shd.g_old_rec.category;
450: ghr_pdi_shd.g_old_rec.position_class_std;
451: End If;
452: If (p_rec.category = hr_api.g_varchar2) then
453: p_rec.category :=
454: ghr_pdi_shd.g_old_rec.category;
455: End If;
456: If (p_rec.career_ladder = hr_api.g_varchar2) then
457: p_rec.career_ladder :=
458: ghr_pdi_shd.g_old_rec.career_ladder;
454: ghr_pdi_shd.g_old_rec.category;
455: End If;
456: If (p_rec.career_ladder = hr_api.g_varchar2) then
457: p_rec.career_ladder :=
458: ghr_pdi_shd.g_old_rec.career_ladder;
459: End If;
460:
461: /* Added by Dinkar. Karumuri for PD Phase II */
462:
461: /* Added by Dinkar. Karumuri for PD Phase II */
462:
463: If (p_rec.supervisor_name = hr_api.g_varchar2) then
464: p_rec.supervisor_name :=
465: ghr_pdi_shd.g_old_rec.supervisor_name;
466: End If;
467: If (p_rec.supervisor_title = hr_api.g_varchar2) then
468: p_rec.supervisor_title :=
469: ghr_pdi_shd.g_old_rec.supervisor_title;
465: ghr_pdi_shd.g_old_rec.supervisor_name;
466: End If;
467: If (p_rec.supervisor_title = hr_api.g_varchar2) then
468: p_rec.supervisor_title :=
469: ghr_pdi_shd.g_old_rec.supervisor_title;
470: End If;
471: If (p_rec.supervisor_date = hr_api.g_date) then
472: p_rec.supervisor_date :=
473: ghr_pdi_shd.g_old_rec.supervisor_date;
469: ghr_pdi_shd.g_old_rec.supervisor_title;
470: End If;
471: If (p_rec.supervisor_date = hr_api.g_date) then
472: p_rec.supervisor_date :=
473: ghr_pdi_shd.g_old_rec.supervisor_date;
474: End If;
475:
476: If (p_rec.manager_name = hr_api.g_varchar2) then
477: p_rec.manager_name :=
474: End If;
475:
476: If (p_rec.manager_name = hr_api.g_varchar2) then
477: p_rec.manager_name :=
478: ghr_pdi_shd.g_old_rec.manager_name;
479: End If;
480: If (p_rec.manager_title = hr_api.g_varchar2) then
481: p_rec.manager_title :=
482: ghr_pdi_shd.g_old_rec.manager_title;
478: ghr_pdi_shd.g_old_rec.manager_name;
479: End If;
480: If (p_rec.manager_title = hr_api.g_varchar2) then
481: p_rec.manager_title :=
482: ghr_pdi_shd.g_old_rec.manager_title;
483: End If;
484: If (p_rec.manager_date = hr_api.g_date) then
485: p_rec.manager_date :=
486: ghr_pdi_shd.g_old_rec.manager_date;
482: ghr_pdi_shd.g_old_rec.manager_title;
483: End If;
484: If (p_rec.manager_date = hr_api.g_date) then
485: p_rec.manager_date :=
486: ghr_pdi_shd.g_old_rec.manager_date;
487: End If;
488:
489: If (p_rec.classifier_name = hr_api.g_varchar2) then
490: p_rec.classifier_name :=
487: End If;
488:
489: If (p_rec.classifier_name = hr_api.g_varchar2) then
490: p_rec.classifier_name :=
491: ghr_pdi_shd.g_old_rec.classifier_name;
492: End If;
493: If (p_rec.classifier_title = hr_api.g_varchar2) then
494: p_rec.classifier_title :=
495: ghr_pdi_shd.g_old_rec.classifier_title;
491: ghr_pdi_shd.g_old_rec.classifier_name;
492: End If;
493: If (p_rec.classifier_title = hr_api.g_varchar2) then
494: p_rec.classifier_title :=
495: ghr_pdi_shd.g_old_rec.classifier_title;
496: End If;
497: If (p_rec.classifier_date = hr_api.g_date) then
498: p_rec.classifier_date :=
499: ghr_pdi_shd.g_old_rec.classifier_date;
495: ghr_pdi_shd.g_old_rec.classifier_title;
496: End If;
497: If (p_rec.classifier_date = hr_api.g_date) then
498: p_rec.classifier_date :=
499: ghr_pdi_shd.g_old_rec.classifier_date;
500: End If;
501:
502: ---------------------------------------------------------------------------
503:
502: ---------------------------------------------------------------------------
503:
504: If (p_rec.attribute_category = hr_api.g_varchar2) then
505: p_rec.attribute_category :=
506: ghr_pdi_shd.g_old_rec.attribute_category;
507: End If;
508: If (p_rec.attribute1 = hr_api.g_varchar2) then
509: p_rec.attribute1 :=
510: ghr_pdi_shd.g_old_rec.attribute1;
506: ghr_pdi_shd.g_old_rec.attribute_category;
507: End If;
508: If (p_rec.attribute1 = hr_api.g_varchar2) then
509: p_rec.attribute1 :=
510: ghr_pdi_shd.g_old_rec.attribute1;
511: End If;
512: If (p_rec.attribute2 = hr_api.g_varchar2) then
513: p_rec.attribute2 :=
514: ghr_pdi_shd.g_old_rec.attribute2;
510: ghr_pdi_shd.g_old_rec.attribute1;
511: End If;
512: If (p_rec.attribute2 = hr_api.g_varchar2) then
513: p_rec.attribute2 :=
514: ghr_pdi_shd.g_old_rec.attribute2;
515: End If;
516: If (p_rec.attribute3 = hr_api.g_varchar2) then
517: p_rec.attribute3 :=
518: ghr_pdi_shd.g_old_rec.attribute3;
514: ghr_pdi_shd.g_old_rec.attribute2;
515: End If;
516: If (p_rec.attribute3 = hr_api.g_varchar2) then
517: p_rec.attribute3 :=
518: ghr_pdi_shd.g_old_rec.attribute3;
519: End If;
520: If (p_rec.attribute4 = hr_api.g_varchar2) then
521: p_rec.attribute4 :=
522: ghr_pdi_shd.g_old_rec.attribute4;
518: ghr_pdi_shd.g_old_rec.attribute3;
519: End If;
520: If (p_rec.attribute4 = hr_api.g_varchar2) then
521: p_rec.attribute4 :=
522: ghr_pdi_shd.g_old_rec.attribute4;
523: End If;
524: If (p_rec.attribute5 = hr_api.g_varchar2) then
525: p_rec.attribute5 :=
526: ghr_pdi_shd.g_old_rec.attribute5;
522: ghr_pdi_shd.g_old_rec.attribute4;
523: End If;
524: If (p_rec.attribute5 = hr_api.g_varchar2) then
525: p_rec.attribute5 :=
526: ghr_pdi_shd.g_old_rec.attribute5;
527: End If;
528: If (p_rec.attribute6 = hr_api.g_varchar2) then
529: p_rec.attribute6 :=
530: ghr_pdi_shd.g_old_rec.attribute6;
526: ghr_pdi_shd.g_old_rec.attribute5;
527: End If;
528: If (p_rec.attribute6 = hr_api.g_varchar2) then
529: p_rec.attribute6 :=
530: ghr_pdi_shd.g_old_rec.attribute6;
531: End If;
532: If (p_rec.attribute7 = hr_api.g_varchar2) then
533: p_rec.attribute7 :=
534: ghr_pdi_shd.g_old_rec.attribute7;
530: ghr_pdi_shd.g_old_rec.attribute6;
531: End If;
532: If (p_rec.attribute7 = hr_api.g_varchar2) then
533: p_rec.attribute7 :=
534: ghr_pdi_shd.g_old_rec.attribute7;
535: End If;
536: If (p_rec.attribute8 = hr_api.g_varchar2) then
537: p_rec.attribute8 :=
538: ghr_pdi_shd.g_old_rec.attribute8;
534: ghr_pdi_shd.g_old_rec.attribute7;
535: End If;
536: If (p_rec.attribute8 = hr_api.g_varchar2) then
537: p_rec.attribute8 :=
538: ghr_pdi_shd.g_old_rec.attribute8;
539: End If;
540: If (p_rec.attribute9 = hr_api.g_varchar2) then
541: p_rec.attribute9 :=
542: ghr_pdi_shd.g_old_rec.attribute9;
538: ghr_pdi_shd.g_old_rec.attribute8;
539: End If;
540: If (p_rec.attribute9 = hr_api.g_varchar2) then
541: p_rec.attribute9 :=
542: ghr_pdi_shd.g_old_rec.attribute9;
543: End If;
544: If (p_rec.attribute10 = hr_api.g_varchar2) then
545: p_rec.attribute10 :=
546: ghr_pdi_shd.g_old_rec.attribute10;
542: ghr_pdi_shd.g_old_rec.attribute9;
543: End If;
544: If (p_rec.attribute10 = hr_api.g_varchar2) then
545: p_rec.attribute10 :=
546: ghr_pdi_shd.g_old_rec.attribute10;
547: End If;
548: If (p_rec.attribute11 = hr_api.g_varchar2) then
549: p_rec.attribute11 :=
550: ghr_pdi_shd.g_old_rec.attribute11;
546: ghr_pdi_shd.g_old_rec.attribute10;
547: End If;
548: If (p_rec.attribute11 = hr_api.g_varchar2) then
549: p_rec.attribute11 :=
550: ghr_pdi_shd.g_old_rec.attribute11;
551: End If;
552: If (p_rec.attribute12 = hr_api.g_varchar2) then
553: p_rec.attribute12 :=
554: ghr_pdi_shd.g_old_rec.attribute12;
550: ghr_pdi_shd.g_old_rec.attribute11;
551: End If;
552: If (p_rec.attribute12 = hr_api.g_varchar2) then
553: p_rec.attribute12 :=
554: ghr_pdi_shd.g_old_rec.attribute12;
555: End If;
556: If (p_rec.attribute13 = hr_api.g_varchar2) then
557: p_rec.attribute13 :=
558: ghr_pdi_shd.g_old_rec.attribute13;
554: ghr_pdi_shd.g_old_rec.attribute12;
555: End If;
556: If (p_rec.attribute13 = hr_api.g_varchar2) then
557: p_rec.attribute13 :=
558: ghr_pdi_shd.g_old_rec.attribute13;
559: End If;
560: If (p_rec.attribute14 = hr_api.g_varchar2) then
561: p_rec.attribute14 :=
562: ghr_pdi_shd.g_old_rec.attribute14;
558: ghr_pdi_shd.g_old_rec.attribute13;
559: End If;
560: If (p_rec.attribute14 = hr_api.g_varchar2) then
561: p_rec.attribute14 :=
562: ghr_pdi_shd.g_old_rec.attribute14;
563: End If;
564: If (p_rec.attribute15 = hr_api.g_varchar2) then
565: p_rec.attribute15 :=
566: ghr_pdi_shd.g_old_rec.attribute15;
562: ghr_pdi_shd.g_old_rec.attribute14;
563: End If;
564: If (p_rec.attribute15 = hr_api.g_varchar2) then
565: p_rec.attribute15 :=
566: ghr_pdi_shd.g_old_rec.attribute15;
567: End If;
568: If (p_rec.attribute16 = hr_api.g_varchar2) then
569: p_rec.attribute16 :=
570: ghr_pdi_shd.g_old_rec.attribute16;
566: ghr_pdi_shd.g_old_rec.attribute15;
567: End If;
568: If (p_rec.attribute16 = hr_api.g_varchar2) then
569: p_rec.attribute16 :=
570: ghr_pdi_shd.g_old_rec.attribute16;
571: End If;
572: If (p_rec.attribute17 = hr_api.g_varchar2) then
573: p_rec.attribute17 :=
574: ghr_pdi_shd.g_old_rec.attribute17;
570: ghr_pdi_shd.g_old_rec.attribute16;
571: End If;
572: If (p_rec.attribute17 = hr_api.g_varchar2) then
573: p_rec.attribute17 :=
574: ghr_pdi_shd.g_old_rec.attribute17;
575: End If;
576: If (p_rec.attribute18 = hr_api.g_varchar2) then
577: p_rec.attribute18 :=
578: ghr_pdi_shd.g_old_rec.attribute18;
574: ghr_pdi_shd.g_old_rec.attribute17;
575: End If;
576: If (p_rec.attribute18 = hr_api.g_varchar2) then
577: p_rec.attribute18 :=
578: ghr_pdi_shd.g_old_rec.attribute18;
579: End If;
580: If (p_rec.attribute19 = hr_api.g_varchar2) then
581: p_rec.attribute19 :=
582: ghr_pdi_shd.g_old_rec.attribute19;
578: ghr_pdi_shd.g_old_rec.attribute18;
579: End If;
580: If (p_rec.attribute19 = hr_api.g_varchar2) then
581: p_rec.attribute19 :=
582: ghr_pdi_shd.g_old_rec.attribute19;
583: End If;
584: If (p_rec.attribute20 = hr_api.g_varchar2) then
585: p_rec.attribute20 :=
586: ghr_pdi_shd.g_old_rec.attribute20;
582: ghr_pdi_shd.g_old_rec.attribute19;
583: End If;
584: If (p_rec.attribute20 = hr_api.g_varchar2) then
585: p_rec.attribute20 :=
586: ghr_pdi_shd.g_old_rec.attribute20;
587: End If;
588: If (p_rec.business_group_id = hr_api.g_number) then
589: p_rec.business_group_id :=
590: ghr_pdi_shd.g_old_rec.business_group_id;
586: ghr_pdi_shd.g_old_rec.attribute20;
587: End If;
588: If (p_rec.business_group_id = hr_api.g_number) then
589: p_rec.business_group_id :=
590: ghr_pdi_shd.g_old_rec.business_group_id;
591: End If;
592: --
593: hr_utility.set_location(' Leaving:'||l_proc, 10);
594: --
598: -- |---------------------------------< upd >----------------------------------|
599: -- ----------------------------------------------------------------------------
600: Procedure upd
601: (
602: p_rec in out nocopy ghr_pdi_shd.g_rec_type
603: ) is
604: --
605: l_proc varchar2(72) := g_package||'upd';
606: --
609: --
610: -- We must lock the row which we need to update.
611: --
612:
613: ghr_pdi_shd.lck
614: (
615: p_rec.position_description_id,
616: p_rec.object_version_number
617: );
692: p_business_group_id in number default hr_api.g_number,
693: p_object_version_number in out nocopy number
694: ) is
695: --
696: l_rec ghr_pdi_shd.g_rec_type;
697: l_proc varchar2(72) := g_package||'upd';
698: --
699: Begin
700:
704: -- Call conversion function to turn arguments into the
705: -- l_rec structure.
706: --
707: l_rec :=
708: ghr_pdi_shd.convert_args
709: (
710: p_position_description_id,
711: p_routing_group_id,
712: p_date_from,