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.GHR_PDI_UPD dependencies on GHR_PDI_SHD

Line 54: Procedure update_dml(p_rec in out nocopy ghr_pdi_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 ghr_pdi_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: --ghr_pdi_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: --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

Line 120: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status

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

Line 127: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status

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

Line 128: ghr_pdi_shd.constraint_error

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

Line 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

Line 133: 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
137: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status

Line 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

Line 138: 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
142: Raise;

Line 141: --ghr_pdi_shd.g_api_dml := false; -- Unset the api dml status

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

Line 177: Procedure pre_update(p_rec in ghr_pdi_shd.g_rec_type) is

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

Line 219: Procedure post_update(p_rec in ghr_pdi_shd.g_rec_type) is

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

Line 280: p_classifier_date_o => ghr_pdi_shd.g_old_rec.classifier_date,

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,

Line 281: -- p_pa_request_id_o => ghr_pdi_shd.g_old_rec.pa_request_id,

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,

Line 282: p_attribute_category_o => ghr_pdi_shd.g_old_rec.attribute_category,

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,

Line 283: p_routing_group_id_o => ghr_pdi_shd.g_old_rec.routing_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,
287: p_flsa_o => ghr_pdi_shd.g_old_rec.flsa,

Line 284: p_date_from_o => ghr_pdi_shd.g_old_rec.date_from,

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,

Line 285: p_date_to_o => ghr_pdi_shd.g_old_rec.date_to,

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,

Line 286: p_opm_cert_num_o => ghr_pdi_shd.g_old_rec.opm_cert_num,

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,

Line 287: p_flsa_o => ghr_pdi_shd.g_old_rec.flsa,

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,

Line 288: p_financial_statement_o => ghr_pdi_shd.g_old_rec.financial_statement,

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,

Line 289: p_subject_to_ia_action_o => ghr_pdi_shd.g_old_rec.subject_to_ia_action,

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,

Line 290: p_position_status_o => ghr_pdi_shd.g_old_rec.position_status,

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,

Line 291: p_position_is_o => ghr_pdi_shd.g_old_rec.position_is,

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,

Line 292: p_position_sensitivity_o => ghr_pdi_shd.g_old_rec.position_sensitivity,

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,

Line 293: p_competitive_level_o => ghr_pdi_shd.g_old_rec.competitive_level,

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,

Line 294: p_pd_remarks_o => ghr_pdi_shd.g_old_rec.pd_remarks,

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,

Line 295: p_position_class_std_o => ghr_pdi_shd.g_old_rec.position_class_std,

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,

Line 296: p_category_o => ghr_pdi_shd.g_old_rec.category,

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,

Line 297: p_career_ladder_o => ghr_pdi_shd.g_old_rec.career_ladder,

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,

Line 298: p_supervisor_name_o => ghr_pdi_shd.g_old_rec.supervisor_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,

Line 299: p_supervisor_title_o => ghr_pdi_shd.g_old_rec.supervisor_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,

Line 300: p_supervisor_date_o => ghr_pdi_shd.g_old_rec.supervisor_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,

Line 301: p_manager_name_o => ghr_pdi_shd.g_old_rec.manager_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,

Line 302: p_manager_title_o => ghr_pdi_shd.g_old_rec.manager_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,

Line 303: p_manager_date_o => ghr_pdi_shd.g_old_rec.manager_date,

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,

Line 304: p_classifier_name_o => ghr_pdi_shd.g_old_rec.classifier_name,

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,

Line 305: p_classifier_title_o => ghr_pdi_shd.g_old_rec.classifier_title,

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,

Line 306: p_attribute1_o => ghr_pdi_shd.g_old_rec.attribute1,

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,

Line 307: p_attribute2_o => ghr_pdi_shd.g_old_rec.attribute2,

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,

Line 308: p_attribute3_o => ghr_pdi_shd.g_old_rec.attribute3,

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,

Line 309: p_attribute4_o => ghr_pdi_shd.g_old_rec.attribute4,

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,

Line 310: p_attribute5_o => ghr_pdi_shd.g_old_rec.attribute5,

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,

Line 311: p_attribute6_o => ghr_pdi_shd.g_old_rec.attribute6,

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,

Line 312: p_attribute7_o => ghr_pdi_shd.g_old_rec.attribute7,

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,

Line 313: p_attribute8_o => ghr_pdi_shd.g_old_rec.attribute8,

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,

Line 314: p_attribute9_o => ghr_pdi_shd.g_old_rec.attribute9,

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,

Line 315: p_attribute10_o => ghr_pdi_shd.g_old_rec.attribute10,

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,

Line 316: p_attribute11_o => ghr_pdi_shd.g_old_rec.attribute11,

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,

Line 317: p_attribute12_o => ghr_pdi_shd.g_old_rec.attribute12,

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,

Line 318: p_attribute13_o => ghr_pdi_shd.g_old_rec.attribute13,

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,

Line 319: p_attribute14_o => ghr_pdi_shd.g_old_rec.attribute14,

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,

Line 320: p_attribute15_o => ghr_pdi_shd.g_old_rec.attribute15,

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,

Line 321: p_attribute16_o => ghr_pdi_shd.g_old_rec.attribute16,

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,

Line 322: p_attribute17_o => ghr_pdi_shd.g_old_rec.attribute17,

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,

Line 323: p_attribute18_o => ghr_pdi_shd.g_old_rec.attribute18,

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

Line 324: p_attribute19_o => ghr_pdi_shd.g_old_rec.attribute19,

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

Line 325: p_attribute20_o => ghr_pdi_shd.g_old_rec.attribute20,

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:

Line 326: p_business_group_id_o => ghr_pdi_shd.g_old_rec.business_group_id,

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

Line 327: p_object_version_number_o => ghr_pdi_shd.g_old_rec.object_version_number

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

Line 387: Procedure convert_defs(p_rec in out nocopy ghr_pdi_shd.g_rec_type) is

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

Line 402: ghr_pdi_shd.g_old_rec.routing_group_id;

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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 465: ghr_pdi_shd.g_old_rec.supervisor_name;

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;

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

Line 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 :=

Line 478: ghr_pdi_shd.g_old_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;

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

Line 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 :=

Line 491: ghr_pdi_shd.g_old_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;

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

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

Line 506: ghr_pdi_shd.g_old_rec.attribute_category;

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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 602: p_rec in out nocopy ghr_pdi_shd.g_rec_type

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

Line 613: ghr_pdi_shd.lck

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

Line 696: l_rec ghr_pdi_shd.g_rec_type;

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:

Line 708: ghr_pdi_shd.convert_args

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,