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

APPS.PER_CPN_UPD dependencies on PER_CPN_SHD

Line 49: Procedure update_dml(p_rec in out nocopy per_cpn_shd.g_rec_type) is

45: -- Internal Table Handler Use Only.
46: --
47: -- {End Of Comments}
48: -- ----------------------------------------------------------------------------
49: Procedure update_dml(p_rec in out nocopy per_cpn_shd.g_rec_type) is
50: --
51: l_proc varchar2(72) := g_package||'update_dml';
52: --
53: Begin

Line 140: per_cpn_shd.constraint_error

136: --
137: Exception
138: When hr_api.check_integrity_violated Then
139: -- A check constraint has been violated
140: per_cpn_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.parent_integrity_violated Then
143: -- Parent integrity has been violated
144: per_cpn_shd.constraint_error

Line 144: per_cpn_shd.constraint_error

140: per_cpn_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.parent_integrity_violated Then
143: -- Parent integrity has been violated
144: per_cpn_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: per_cpn_shd.constraint_error

Line 148: per_cpn_shd.constraint_error

144: per_cpn_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: per_cpn_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When Others Then
151: Raise;
152: End update_dml;

Line 186: Procedure pre_update(p_rec in per_cpn_shd.g_rec_type) is

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

Line 228: Procedure post_update(p_rec in per_cpn_shd.g_rec_type) is

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

Line 310: p_business_group_id_o => per_cpn_shd.g_old_rec.business_group_id ,

306: p_information17 => p_rec.information17 ,
307: p_information18 => p_rec.information18 ,
308: p_information19 => p_rec.information19 ,
309: p_information20 => p_rec.information20 ,
310: p_business_group_id_o => per_cpn_shd.g_old_rec.business_group_id ,
311: p_object_version_number_o => per_cpn_shd.g_old_rec.object_version_number ,
312: p_name_o => per_cpn_shd.g_old_rec.name ,
313: p_description_o => per_cpn_shd.g_old_rec.description ,
314: p_date_from_o => per_cpn_shd.g_old_rec.date_from ,

Line 311: p_object_version_number_o => per_cpn_shd.g_old_rec.object_version_number ,

307: p_information18 => p_rec.information18 ,
308: p_information19 => p_rec.information19 ,
309: p_information20 => p_rec.information20 ,
310: p_business_group_id_o => per_cpn_shd.g_old_rec.business_group_id ,
311: p_object_version_number_o => per_cpn_shd.g_old_rec.object_version_number ,
312: p_name_o => per_cpn_shd.g_old_rec.name ,
313: p_description_o => per_cpn_shd.g_old_rec.description ,
314: p_date_from_o => per_cpn_shd.g_old_rec.date_from ,
315: p_date_to_o => per_cpn_shd.g_old_rec.date_to ,

Line 312: p_name_o => per_cpn_shd.g_old_rec.name ,

308: p_information19 => p_rec.information19 ,
309: p_information20 => p_rec.information20 ,
310: p_business_group_id_o => per_cpn_shd.g_old_rec.business_group_id ,
311: p_object_version_number_o => per_cpn_shd.g_old_rec.object_version_number ,
312: p_name_o => per_cpn_shd.g_old_rec.name ,
313: p_description_o => per_cpn_shd.g_old_rec.description ,
314: p_date_from_o => per_cpn_shd.g_old_rec.date_from ,
315: p_date_to_o => per_cpn_shd.g_old_rec.date_to ,
316: p_behavioural_indicator_o => per_cpn_shd.g_old_rec.behavioural_indicator ,

Line 313: p_description_o => per_cpn_shd.g_old_rec.description ,

309: p_information20 => p_rec.information20 ,
310: p_business_group_id_o => per_cpn_shd.g_old_rec.business_group_id ,
311: p_object_version_number_o => per_cpn_shd.g_old_rec.object_version_number ,
312: p_name_o => per_cpn_shd.g_old_rec.name ,
313: p_description_o => per_cpn_shd.g_old_rec.description ,
314: p_date_from_o => per_cpn_shd.g_old_rec.date_from ,
315: p_date_to_o => per_cpn_shd.g_old_rec.date_to ,
316: p_behavioural_indicator_o => per_cpn_shd.g_old_rec.behavioural_indicator ,
317: p_certification_required_o =>

Line 314: p_date_from_o => per_cpn_shd.g_old_rec.date_from ,

310: p_business_group_id_o => per_cpn_shd.g_old_rec.business_group_id ,
311: p_object_version_number_o => per_cpn_shd.g_old_rec.object_version_number ,
312: p_name_o => per_cpn_shd.g_old_rec.name ,
313: p_description_o => per_cpn_shd.g_old_rec.description ,
314: p_date_from_o => per_cpn_shd.g_old_rec.date_from ,
315: p_date_to_o => per_cpn_shd.g_old_rec.date_to ,
316: p_behavioural_indicator_o => per_cpn_shd.g_old_rec.behavioural_indicator ,
317: p_certification_required_o =>
318: per_cpn_shd.g_old_rec.certification_required ,

Line 315: p_date_to_o => per_cpn_shd.g_old_rec.date_to ,

311: p_object_version_number_o => per_cpn_shd.g_old_rec.object_version_number ,
312: p_name_o => per_cpn_shd.g_old_rec.name ,
313: p_description_o => per_cpn_shd.g_old_rec.description ,
314: p_date_from_o => per_cpn_shd.g_old_rec.date_from ,
315: p_date_to_o => per_cpn_shd.g_old_rec.date_to ,
316: p_behavioural_indicator_o => per_cpn_shd.g_old_rec.behavioural_indicator ,
317: p_certification_required_o =>
318: per_cpn_shd.g_old_rec.certification_required ,
319: p_evaluation_method_o => per_cpn_shd.g_old_rec.evaluation_method ,

Line 316: p_behavioural_indicator_o => per_cpn_shd.g_old_rec.behavioural_indicator ,

312: p_name_o => per_cpn_shd.g_old_rec.name ,
313: p_description_o => per_cpn_shd.g_old_rec.description ,
314: p_date_from_o => per_cpn_shd.g_old_rec.date_from ,
315: p_date_to_o => per_cpn_shd.g_old_rec.date_to ,
316: p_behavioural_indicator_o => per_cpn_shd.g_old_rec.behavioural_indicator ,
317: p_certification_required_o =>
318: per_cpn_shd.g_old_rec.certification_required ,
319: p_evaluation_method_o => per_cpn_shd.g_old_rec.evaluation_method ,
320: p_renewal_period_frequency_o =>

Line 318: per_cpn_shd.g_old_rec.certification_required ,

314: p_date_from_o => per_cpn_shd.g_old_rec.date_from ,
315: p_date_to_o => per_cpn_shd.g_old_rec.date_to ,
316: p_behavioural_indicator_o => per_cpn_shd.g_old_rec.behavioural_indicator ,
317: p_certification_required_o =>
318: per_cpn_shd.g_old_rec.certification_required ,
319: p_evaluation_method_o => per_cpn_shd.g_old_rec.evaluation_method ,
320: p_renewal_period_frequency_o =>
321: per_cpn_shd.g_old_rec.renewal_period_frequency ,
322: p_renewal_period_units_o => per_cpn_shd.g_old_rec.renewal_period_units ,

Line 319: p_evaluation_method_o => per_cpn_shd.g_old_rec.evaluation_method ,

315: p_date_to_o => per_cpn_shd.g_old_rec.date_to ,
316: p_behavioural_indicator_o => per_cpn_shd.g_old_rec.behavioural_indicator ,
317: p_certification_required_o =>
318: per_cpn_shd.g_old_rec.certification_required ,
319: p_evaluation_method_o => per_cpn_shd.g_old_rec.evaluation_method ,
320: p_renewal_period_frequency_o =>
321: per_cpn_shd.g_old_rec.renewal_period_frequency ,
322: p_renewal_period_units_o => per_cpn_shd.g_old_rec.renewal_period_units ,
323: p_max_level_o => per_cpn_shd.g_old_rec.max_level ,

Line 321: per_cpn_shd.g_old_rec.renewal_period_frequency ,

317: p_certification_required_o =>
318: per_cpn_shd.g_old_rec.certification_required ,
319: p_evaluation_method_o => per_cpn_shd.g_old_rec.evaluation_method ,
320: p_renewal_period_frequency_o =>
321: per_cpn_shd.g_old_rec.renewal_period_frequency ,
322: p_renewal_period_units_o => per_cpn_shd.g_old_rec.renewal_period_units ,
323: p_max_level_o => per_cpn_shd.g_old_rec.max_level ,
324: p_min_level_o => per_cpn_shd.g_old_rec.min_level ,
325: p_rating_scale_id_o => per_cpn_shd.g_old_rec.rating_scale_id ,

Line 322: p_renewal_period_units_o => per_cpn_shd.g_old_rec.renewal_period_units ,

318: per_cpn_shd.g_old_rec.certification_required ,
319: p_evaluation_method_o => per_cpn_shd.g_old_rec.evaluation_method ,
320: p_renewal_period_frequency_o =>
321: per_cpn_shd.g_old_rec.renewal_period_frequency ,
322: p_renewal_period_units_o => per_cpn_shd.g_old_rec.renewal_period_units ,
323: p_max_level_o => per_cpn_shd.g_old_rec.max_level ,
324: p_min_level_o => per_cpn_shd.g_old_rec.min_level ,
325: p_rating_scale_id_o => per_cpn_shd.g_old_rec.rating_scale_id ,
326: p_attribute_category_o => per_cpn_shd.g_old_rec.attribute_category ,

Line 323: p_max_level_o => per_cpn_shd.g_old_rec.max_level ,

319: p_evaluation_method_o => per_cpn_shd.g_old_rec.evaluation_method ,
320: p_renewal_period_frequency_o =>
321: per_cpn_shd.g_old_rec.renewal_period_frequency ,
322: p_renewal_period_units_o => per_cpn_shd.g_old_rec.renewal_period_units ,
323: p_max_level_o => per_cpn_shd.g_old_rec.max_level ,
324: p_min_level_o => per_cpn_shd.g_old_rec.min_level ,
325: p_rating_scale_id_o => per_cpn_shd.g_old_rec.rating_scale_id ,
326: p_attribute_category_o => per_cpn_shd.g_old_rec.attribute_category ,
327: p_attribute1_o => per_cpn_shd.g_old_rec.attribute1 ,

Line 324: p_min_level_o => per_cpn_shd.g_old_rec.min_level ,

320: p_renewal_period_frequency_o =>
321: per_cpn_shd.g_old_rec.renewal_period_frequency ,
322: p_renewal_period_units_o => per_cpn_shd.g_old_rec.renewal_period_units ,
323: p_max_level_o => per_cpn_shd.g_old_rec.max_level ,
324: p_min_level_o => per_cpn_shd.g_old_rec.min_level ,
325: p_rating_scale_id_o => per_cpn_shd.g_old_rec.rating_scale_id ,
326: p_attribute_category_o => per_cpn_shd.g_old_rec.attribute_category ,
327: p_attribute1_o => per_cpn_shd.g_old_rec.attribute1 ,
328: p_attribute2_o => per_cpn_shd.g_old_rec.attribute2 ,

Line 325: p_rating_scale_id_o => per_cpn_shd.g_old_rec.rating_scale_id ,

321: per_cpn_shd.g_old_rec.renewal_period_frequency ,
322: p_renewal_period_units_o => per_cpn_shd.g_old_rec.renewal_period_units ,
323: p_max_level_o => per_cpn_shd.g_old_rec.max_level ,
324: p_min_level_o => per_cpn_shd.g_old_rec.min_level ,
325: p_rating_scale_id_o => per_cpn_shd.g_old_rec.rating_scale_id ,
326: p_attribute_category_o => per_cpn_shd.g_old_rec.attribute_category ,
327: p_attribute1_o => per_cpn_shd.g_old_rec.attribute1 ,
328: p_attribute2_o => per_cpn_shd.g_old_rec.attribute2 ,
329: p_attribute3_o => per_cpn_shd.g_old_rec.attribute3 ,

Line 326: p_attribute_category_o => per_cpn_shd.g_old_rec.attribute_category ,

322: p_renewal_period_units_o => per_cpn_shd.g_old_rec.renewal_period_units ,
323: p_max_level_o => per_cpn_shd.g_old_rec.max_level ,
324: p_min_level_o => per_cpn_shd.g_old_rec.min_level ,
325: p_rating_scale_id_o => per_cpn_shd.g_old_rec.rating_scale_id ,
326: p_attribute_category_o => per_cpn_shd.g_old_rec.attribute_category ,
327: p_attribute1_o => per_cpn_shd.g_old_rec.attribute1 ,
328: p_attribute2_o => per_cpn_shd.g_old_rec.attribute2 ,
329: p_attribute3_o => per_cpn_shd.g_old_rec.attribute3 ,
330: p_attribute4_o => per_cpn_shd.g_old_rec.attribute4 ,

Line 327: p_attribute1_o => per_cpn_shd.g_old_rec.attribute1 ,

323: p_max_level_o => per_cpn_shd.g_old_rec.max_level ,
324: p_min_level_o => per_cpn_shd.g_old_rec.min_level ,
325: p_rating_scale_id_o => per_cpn_shd.g_old_rec.rating_scale_id ,
326: p_attribute_category_o => per_cpn_shd.g_old_rec.attribute_category ,
327: p_attribute1_o => per_cpn_shd.g_old_rec.attribute1 ,
328: p_attribute2_o => per_cpn_shd.g_old_rec.attribute2 ,
329: p_attribute3_o => per_cpn_shd.g_old_rec.attribute3 ,
330: p_attribute4_o => per_cpn_shd.g_old_rec.attribute4 ,
331: p_attribute5_o => per_cpn_shd.g_old_rec.attribute5 ,

Line 328: p_attribute2_o => per_cpn_shd.g_old_rec.attribute2 ,

324: p_min_level_o => per_cpn_shd.g_old_rec.min_level ,
325: p_rating_scale_id_o => per_cpn_shd.g_old_rec.rating_scale_id ,
326: p_attribute_category_o => per_cpn_shd.g_old_rec.attribute_category ,
327: p_attribute1_o => per_cpn_shd.g_old_rec.attribute1 ,
328: p_attribute2_o => per_cpn_shd.g_old_rec.attribute2 ,
329: p_attribute3_o => per_cpn_shd.g_old_rec.attribute3 ,
330: p_attribute4_o => per_cpn_shd.g_old_rec.attribute4 ,
331: p_attribute5_o => per_cpn_shd.g_old_rec.attribute5 ,
332: p_attribute6_o => per_cpn_shd.g_old_rec.attribute6 ,

Line 329: p_attribute3_o => per_cpn_shd.g_old_rec.attribute3 ,

325: p_rating_scale_id_o => per_cpn_shd.g_old_rec.rating_scale_id ,
326: p_attribute_category_o => per_cpn_shd.g_old_rec.attribute_category ,
327: p_attribute1_o => per_cpn_shd.g_old_rec.attribute1 ,
328: p_attribute2_o => per_cpn_shd.g_old_rec.attribute2 ,
329: p_attribute3_o => per_cpn_shd.g_old_rec.attribute3 ,
330: p_attribute4_o => per_cpn_shd.g_old_rec.attribute4 ,
331: p_attribute5_o => per_cpn_shd.g_old_rec.attribute5 ,
332: p_attribute6_o => per_cpn_shd.g_old_rec.attribute6 ,
333: p_attribute7_o => per_cpn_shd.g_old_rec.attribute7 ,

Line 330: p_attribute4_o => per_cpn_shd.g_old_rec.attribute4 ,

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

Line 331: p_attribute5_o => per_cpn_shd.g_old_rec.attribute5 ,

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

Line 332: p_attribute6_o => per_cpn_shd.g_old_rec.attribute6 ,

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

Line 333: p_attribute7_o => per_cpn_shd.g_old_rec.attribute7 ,

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

Line 334: p_attribute8_o => per_cpn_shd.g_old_rec.attribute8 ,

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

Line 335: p_attribute9_o => per_cpn_shd.g_old_rec.attribute9 ,

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

Line 336: p_attribute10_o => per_cpn_shd.g_old_rec.attribute10 ,

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

Line 337: p_attribute11_o => per_cpn_shd.g_old_rec.attribute11 ,

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

Line 338: p_attribute12_o => per_cpn_shd.g_old_rec.attribute12 ,

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

Line 339: p_attribute13_o => per_cpn_shd.g_old_rec.attribute13 ,

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

Line 340: p_attribute14_o => per_cpn_shd.g_old_rec.attribute14 ,

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

Line 341: p_attribute15_o => per_cpn_shd.g_old_rec.attribute15 ,

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

Line 342: p_attribute16_o => per_cpn_shd.g_old_rec.attribute16 ,

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

Line 343: p_attribute17_o => per_cpn_shd.g_old_rec.attribute17 ,

339: p_attribute13_o => per_cpn_shd.g_old_rec.attribute13 ,
340: p_attribute14_o => per_cpn_shd.g_old_rec.attribute14 ,
341: p_attribute15_o => per_cpn_shd.g_old_rec.attribute15 ,
342: p_attribute16_o => per_cpn_shd.g_old_rec.attribute16 ,
343: p_attribute17_o => per_cpn_shd.g_old_rec.attribute17 ,
344: p_attribute18_o => per_cpn_shd.g_old_rec.attribute18 ,
345: p_attribute19_o => per_cpn_shd.g_old_rec.attribute19 ,
346: p_attribute20_o => per_cpn_shd.g_old_rec.attribute20 ,
347: p_competence_alias_o => per_cpn_shd.g_old_rec.competence_alias,

Line 344: p_attribute18_o => per_cpn_shd.g_old_rec.attribute18 ,

340: p_attribute14_o => per_cpn_shd.g_old_rec.attribute14 ,
341: p_attribute15_o => per_cpn_shd.g_old_rec.attribute15 ,
342: p_attribute16_o => per_cpn_shd.g_old_rec.attribute16 ,
343: p_attribute17_o => per_cpn_shd.g_old_rec.attribute17 ,
344: p_attribute18_o => per_cpn_shd.g_old_rec.attribute18 ,
345: p_attribute19_o => per_cpn_shd.g_old_rec.attribute19 ,
346: p_attribute20_o => per_cpn_shd.g_old_rec.attribute20 ,
347: p_competence_alias_o => per_cpn_shd.g_old_rec.competence_alias,
348: p_competence_definition_id_o => per_cpn_shd.g_old_rec.competence_definition_id

Line 345: p_attribute19_o => per_cpn_shd.g_old_rec.attribute19 ,

341: p_attribute15_o => per_cpn_shd.g_old_rec.attribute15 ,
342: p_attribute16_o => per_cpn_shd.g_old_rec.attribute16 ,
343: p_attribute17_o => per_cpn_shd.g_old_rec.attribute17 ,
344: p_attribute18_o => per_cpn_shd.g_old_rec.attribute18 ,
345: p_attribute19_o => per_cpn_shd.g_old_rec.attribute19 ,
346: p_attribute20_o => per_cpn_shd.g_old_rec.attribute20 ,
347: p_competence_alias_o => per_cpn_shd.g_old_rec.competence_alias,
348: p_competence_definition_id_o => per_cpn_shd.g_old_rec.competence_definition_id
349: ,p_competence_cluster_o => per_cpn_shd.g_old_rec.competence_cluster

Line 346: p_attribute20_o => per_cpn_shd.g_old_rec.attribute20 ,

342: p_attribute16_o => per_cpn_shd.g_old_rec.attribute16 ,
343: p_attribute17_o => per_cpn_shd.g_old_rec.attribute17 ,
344: p_attribute18_o => per_cpn_shd.g_old_rec.attribute18 ,
345: p_attribute19_o => per_cpn_shd.g_old_rec.attribute19 ,
346: p_attribute20_o => per_cpn_shd.g_old_rec.attribute20 ,
347: p_competence_alias_o => per_cpn_shd.g_old_rec.competence_alias,
348: p_competence_definition_id_o => per_cpn_shd.g_old_rec.competence_definition_id
349: ,p_competence_cluster_o => per_cpn_shd.g_old_rec.competence_cluster
350: ,p_unit_standard_id_o => per_cpn_shd.g_old_rec.unit_standard_id

Line 347: p_competence_alias_o => per_cpn_shd.g_old_rec.competence_alias,

343: p_attribute17_o => per_cpn_shd.g_old_rec.attribute17 ,
344: p_attribute18_o => per_cpn_shd.g_old_rec.attribute18 ,
345: p_attribute19_o => per_cpn_shd.g_old_rec.attribute19 ,
346: p_attribute20_o => per_cpn_shd.g_old_rec.attribute20 ,
347: p_competence_alias_o => per_cpn_shd.g_old_rec.competence_alias,
348: p_competence_definition_id_o => per_cpn_shd.g_old_rec.competence_definition_id
349: ,p_competence_cluster_o => per_cpn_shd.g_old_rec.competence_cluster
350: ,p_unit_standard_id_o => per_cpn_shd.g_old_rec.unit_standard_id
351: ,p_credit_type_o => per_cpn_shd.g_old_rec.credit_type

Line 348: p_competence_definition_id_o => per_cpn_shd.g_old_rec.competence_definition_id

344: p_attribute18_o => per_cpn_shd.g_old_rec.attribute18 ,
345: p_attribute19_o => per_cpn_shd.g_old_rec.attribute19 ,
346: p_attribute20_o => per_cpn_shd.g_old_rec.attribute20 ,
347: p_competence_alias_o => per_cpn_shd.g_old_rec.competence_alias,
348: p_competence_definition_id_o => per_cpn_shd.g_old_rec.competence_definition_id
349: ,p_competence_cluster_o => per_cpn_shd.g_old_rec.competence_cluster
350: ,p_unit_standard_id_o => per_cpn_shd.g_old_rec.unit_standard_id
351: ,p_credit_type_o => per_cpn_shd.g_old_rec.credit_type
352: ,p_credits_o => per_cpn_shd.g_old_rec.credits

Line 349: ,p_competence_cluster_o => per_cpn_shd.g_old_rec.competence_cluster

345: p_attribute19_o => per_cpn_shd.g_old_rec.attribute19 ,
346: p_attribute20_o => per_cpn_shd.g_old_rec.attribute20 ,
347: p_competence_alias_o => per_cpn_shd.g_old_rec.competence_alias,
348: p_competence_definition_id_o => per_cpn_shd.g_old_rec.competence_definition_id
349: ,p_competence_cluster_o => per_cpn_shd.g_old_rec.competence_cluster
350: ,p_unit_standard_id_o => per_cpn_shd.g_old_rec.unit_standard_id
351: ,p_credit_type_o => per_cpn_shd.g_old_rec.credit_type
352: ,p_credits_o => per_cpn_shd.g_old_rec.credits
353: ,p_level_type_o => per_cpn_shd.g_old_rec.level_type

Line 350: ,p_unit_standard_id_o => per_cpn_shd.g_old_rec.unit_standard_id

346: p_attribute20_o => per_cpn_shd.g_old_rec.attribute20 ,
347: p_competence_alias_o => per_cpn_shd.g_old_rec.competence_alias,
348: p_competence_definition_id_o => per_cpn_shd.g_old_rec.competence_definition_id
349: ,p_competence_cluster_o => per_cpn_shd.g_old_rec.competence_cluster
350: ,p_unit_standard_id_o => per_cpn_shd.g_old_rec.unit_standard_id
351: ,p_credit_type_o => per_cpn_shd.g_old_rec.credit_type
352: ,p_credits_o => per_cpn_shd.g_old_rec.credits
353: ,p_level_type_o => per_cpn_shd.g_old_rec.level_type
354: ,p_level_number_o => per_cpn_shd.g_old_rec.level_number

Line 351: ,p_credit_type_o => per_cpn_shd.g_old_rec.credit_type

347: p_competence_alias_o => per_cpn_shd.g_old_rec.competence_alias,
348: p_competence_definition_id_o => per_cpn_shd.g_old_rec.competence_definition_id
349: ,p_competence_cluster_o => per_cpn_shd.g_old_rec.competence_cluster
350: ,p_unit_standard_id_o => per_cpn_shd.g_old_rec.unit_standard_id
351: ,p_credit_type_o => per_cpn_shd.g_old_rec.credit_type
352: ,p_credits_o => per_cpn_shd.g_old_rec.credits
353: ,p_level_type_o => per_cpn_shd.g_old_rec.level_type
354: ,p_level_number_o => per_cpn_shd.g_old_rec.level_number
355: ,p_field_o => per_cpn_shd.g_old_rec.field

Line 352: ,p_credits_o => per_cpn_shd.g_old_rec.credits

348: p_competence_definition_id_o => per_cpn_shd.g_old_rec.competence_definition_id
349: ,p_competence_cluster_o => per_cpn_shd.g_old_rec.competence_cluster
350: ,p_unit_standard_id_o => per_cpn_shd.g_old_rec.unit_standard_id
351: ,p_credit_type_o => per_cpn_shd.g_old_rec.credit_type
352: ,p_credits_o => per_cpn_shd.g_old_rec.credits
353: ,p_level_type_o => per_cpn_shd.g_old_rec.level_type
354: ,p_level_number_o => per_cpn_shd.g_old_rec.level_number
355: ,p_field_o => per_cpn_shd.g_old_rec.field
356: ,p_sub_field_o => per_cpn_shd.g_old_rec.sub_field

Line 353: ,p_level_type_o => per_cpn_shd.g_old_rec.level_type

349: ,p_competence_cluster_o => per_cpn_shd.g_old_rec.competence_cluster
350: ,p_unit_standard_id_o => per_cpn_shd.g_old_rec.unit_standard_id
351: ,p_credit_type_o => per_cpn_shd.g_old_rec.credit_type
352: ,p_credits_o => per_cpn_shd.g_old_rec.credits
353: ,p_level_type_o => per_cpn_shd.g_old_rec.level_type
354: ,p_level_number_o => per_cpn_shd.g_old_rec.level_number
355: ,p_field_o => per_cpn_shd.g_old_rec.field
356: ,p_sub_field_o => per_cpn_shd.g_old_rec.sub_field
357: ,p_provider_o => per_cpn_shd.g_old_rec.provider

Line 354: ,p_level_number_o => per_cpn_shd.g_old_rec.level_number

350: ,p_unit_standard_id_o => per_cpn_shd.g_old_rec.unit_standard_id
351: ,p_credit_type_o => per_cpn_shd.g_old_rec.credit_type
352: ,p_credits_o => per_cpn_shd.g_old_rec.credits
353: ,p_level_type_o => per_cpn_shd.g_old_rec.level_type
354: ,p_level_number_o => per_cpn_shd.g_old_rec.level_number
355: ,p_field_o => per_cpn_shd.g_old_rec.field
356: ,p_sub_field_o => per_cpn_shd.g_old_rec.sub_field
357: ,p_provider_o => per_cpn_shd.g_old_rec.provider
358: ,p_qa_organization_o => per_cpn_shd.g_old_rec.qa_organization

Line 355: ,p_field_o => per_cpn_shd.g_old_rec.field

351: ,p_credit_type_o => per_cpn_shd.g_old_rec.credit_type
352: ,p_credits_o => per_cpn_shd.g_old_rec.credits
353: ,p_level_type_o => per_cpn_shd.g_old_rec.level_type
354: ,p_level_number_o => per_cpn_shd.g_old_rec.level_number
355: ,p_field_o => per_cpn_shd.g_old_rec.field
356: ,p_sub_field_o => per_cpn_shd.g_old_rec.sub_field
357: ,p_provider_o => per_cpn_shd.g_old_rec.provider
358: ,p_qa_organization_o => per_cpn_shd.g_old_rec.qa_organization
359: ,p_information_category_o => per_cpn_shd.g_old_rec.information_category

Line 356: ,p_sub_field_o => per_cpn_shd.g_old_rec.sub_field

352: ,p_credits_o => per_cpn_shd.g_old_rec.credits
353: ,p_level_type_o => per_cpn_shd.g_old_rec.level_type
354: ,p_level_number_o => per_cpn_shd.g_old_rec.level_number
355: ,p_field_o => per_cpn_shd.g_old_rec.field
356: ,p_sub_field_o => per_cpn_shd.g_old_rec.sub_field
357: ,p_provider_o => per_cpn_shd.g_old_rec.provider
358: ,p_qa_organization_o => per_cpn_shd.g_old_rec.qa_organization
359: ,p_information_category_o => per_cpn_shd.g_old_rec.information_category
360: ,p_information1_o => per_cpn_shd.g_old_rec.information1

Line 357: ,p_provider_o => per_cpn_shd.g_old_rec.provider

353: ,p_level_type_o => per_cpn_shd.g_old_rec.level_type
354: ,p_level_number_o => per_cpn_shd.g_old_rec.level_number
355: ,p_field_o => per_cpn_shd.g_old_rec.field
356: ,p_sub_field_o => per_cpn_shd.g_old_rec.sub_field
357: ,p_provider_o => per_cpn_shd.g_old_rec.provider
358: ,p_qa_organization_o => per_cpn_shd.g_old_rec.qa_organization
359: ,p_information_category_o => per_cpn_shd.g_old_rec.information_category
360: ,p_information1_o => per_cpn_shd.g_old_rec.information1
361: ,p_information2_o => per_cpn_shd.g_old_rec.information2

Line 358: ,p_qa_organization_o => per_cpn_shd.g_old_rec.qa_organization

354: ,p_level_number_o => per_cpn_shd.g_old_rec.level_number
355: ,p_field_o => per_cpn_shd.g_old_rec.field
356: ,p_sub_field_o => per_cpn_shd.g_old_rec.sub_field
357: ,p_provider_o => per_cpn_shd.g_old_rec.provider
358: ,p_qa_organization_o => per_cpn_shd.g_old_rec.qa_organization
359: ,p_information_category_o => per_cpn_shd.g_old_rec.information_category
360: ,p_information1_o => per_cpn_shd.g_old_rec.information1
361: ,p_information2_o => per_cpn_shd.g_old_rec.information2
362: ,p_information3_o => per_cpn_shd.g_old_rec.information3

Line 359: ,p_information_category_o => per_cpn_shd.g_old_rec.information_category

355: ,p_field_o => per_cpn_shd.g_old_rec.field
356: ,p_sub_field_o => per_cpn_shd.g_old_rec.sub_field
357: ,p_provider_o => per_cpn_shd.g_old_rec.provider
358: ,p_qa_organization_o => per_cpn_shd.g_old_rec.qa_organization
359: ,p_information_category_o => per_cpn_shd.g_old_rec.information_category
360: ,p_information1_o => per_cpn_shd.g_old_rec.information1
361: ,p_information2_o => per_cpn_shd.g_old_rec.information2
362: ,p_information3_o => per_cpn_shd.g_old_rec.information3
363: ,p_information4_o => per_cpn_shd.g_old_rec.information4

Line 360: ,p_information1_o => per_cpn_shd.g_old_rec.information1

356: ,p_sub_field_o => per_cpn_shd.g_old_rec.sub_field
357: ,p_provider_o => per_cpn_shd.g_old_rec.provider
358: ,p_qa_organization_o => per_cpn_shd.g_old_rec.qa_organization
359: ,p_information_category_o => per_cpn_shd.g_old_rec.information_category
360: ,p_information1_o => per_cpn_shd.g_old_rec.information1
361: ,p_information2_o => per_cpn_shd.g_old_rec.information2
362: ,p_information3_o => per_cpn_shd.g_old_rec.information3
363: ,p_information4_o => per_cpn_shd.g_old_rec.information4
364: ,p_information5_o => per_cpn_shd.g_old_rec.information5

Line 361: ,p_information2_o => per_cpn_shd.g_old_rec.information2

357: ,p_provider_o => per_cpn_shd.g_old_rec.provider
358: ,p_qa_organization_o => per_cpn_shd.g_old_rec.qa_organization
359: ,p_information_category_o => per_cpn_shd.g_old_rec.information_category
360: ,p_information1_o => per_cpn_shd.g_old_rec.information1
361: ,p_information2_o => per_cpn_shd.g_old_rec.information2
362: ,p_information3_o => per_cpn_shd.g_old_rec.information3
363: ,p_information4_o => per_cpn_shd.g_old_rec.information4
364: ,p_information5_o => per_cpn_shd.g_old_rec.information5
365: ,p_information6_o => per_cpn_shd.g_old_rec.information6

Line 362: ,p_information3_o => per_cpn_shd.g_old_rec.information3

358: ,p_qa_organization_o => per_cpn_shd.g_old_rec.qa_organization
359: ,p_information_category_o => per_cpn_shd.g_old_rec.information_category
360: ,p_information1_o => per_cpn_shd.g_old_rec.information1
361: ,p_information2_o => per_cpn_shd.g_old_rec.information2
362: ,p_information3_o => per_cpn_shd.g_old_rec.information3
363: ,p_information4_o => per_cpn_shd.g_old_rec.information4
364: ,p_information5_o => per_cpn_shd.g_old_rec.information5
365: ,p_information6_o => per_cpn_shd.g_old_rec.information6
366: ,p_information7_o => per_cpn_shd.g_old_rec.information7

Line 363: ,p_information4_o => per_cpn_shd.g_old_rec.information4

359: ,p_information_category_o => per_cpn_shd.g_old_rec.information_category
360: ,p_information1_o => per_cpn_shd.g_old_rec.information1
361: ,p_information2_o => per_cpn_shd.g_old_rec.information2
362: ,p_information3_o => per_cpn_shd.g_old_rec.information3
363: ,p_information4_o => per_cpn_shd.g_old_rec.information4
364: ,p_information5_o => per_cpn_shd.g_old_rec.information5
365: ,p_information6_o => per_cpn_shd.g_old_rec.information6
366: ,p_information7_o => per_cpn_shd.g_old_rec.information7
367: ,p_information8_o => per_cpn_shd.g_old_rec.information8

Line 364: ,p_information5_o => per_cpn_shd.g_old_rec.information5

360: ,p_information1_o => per_cpn_shd.g_old_rec.information1
361: ,p_information2_o => per_cpn_shd.g_old_rec.information2
362: ,p_information3_o => per_cpn_shd.g_old_rec.information3
363: ,p_information4_o => per_cpn_shd.g_old_rec.information4
364: ,p_information5_o => per_cpn_shd.g_old_rec.information5
365: ,p_information6_o => per_cpn_shd.g_old_rec.information6
366: ,p_information7_o => per_cpn_shd.g_old_rec.information7
367: ,p_information8_o => per_cpn_shd.g_old_rec.information8
368: ,p_information9_o => per_cpn_shd.g_old_rec.information9

Line 365: ,p_information6_o => per_cpn_shd.g_old_rec.information6

361: ,p_information2_o => per_cpn_shd.g_old_rec.information2
362: ,p_information3_o => per_cpn_shd.g_old_rec.information3
363: ,p_information4_o => per_cpn_shd.g_old_rec.information4
364: ,p_information5_o => per_cpn_shd.g_old_rec.information5
365: ,p_information6_o => per_cpn_shd.g_old_rec.information6
366: ,p_information7_o => per_cpn_shd.g_old_rec.information7
367: ,p_information8_o => per_cpn_shd.g_old_rec.information8
368: ,p_information9_o => per_cpn_shd.g_old_rec.information9
369: ,p_information10_o => per_cpn_shd.g_old_rec.information10

Line 366: ,p_information7_o => per_cpn_shd.g_old_rec.information7

362: ,p_information3_o => per_cpn_shd.g_old_rec.information3
363: ,p_information4_o => per_cpn_shd.g_old_rec.information4
364: ,p_information5_o => per_cpn_shd.g_old_rec.information5
365: ,p_information6_o => per_cpn_shd.g_old_rec.information6
366: ,p_information7_o => per_cpn_shd.g_old_rec.information7
367: ,p_information8_o => per_cpn_shd.g_old_rec.information8
368: ,p_information9_o => per_cpn_shd.g_old_rec.information9
369: ,p_information10_o => per_cpn_shd.g_old_rec.information10
370: ,p_information11_o => per_cpn_shd.g_old_rec.information11

Line 367: ,p_information8_o => per_cpn_shd.g_old_rec.information8

363: ,p_information4_o => per_cpn_shd.g_old_rec.information4
364: ,p_information5_o => per_cpn_shd.g_old_rec.information5
365: ,p_information6_o => per_cpn_shd.g_old_rec.information6
366: ,p_information7_o => per_cpn_shd.g_old_rec.information7
367: ,p_information8_o => per_cpn_shd.g_old_rec.information8
368: ,p_information9_o => per_cpn_shd.g_old_rec.information9
369: ,p_information10_o => per_cpn_shd.g_old_rec.information10
370: ,p_information11_o => per_cpn_shd.g_old_rec.information11
371: ,p_information12_o => per_cpn_shd.g_old_rec.information12

Line 368: ,p_information9_o => per_cpn_shd.g_old_rec.information9

364: ,p_information5_o => per_cpn_shd.g_old_rec.information5
365: ,p_information6_o => per_cpn_shd.g_old_rec.information6
366: ,p_information7_o => per_cpn_shd.g_old_rec.information7
367: ,p_information8_o => per_cpn_shd.g_old_rec.information8
368: ,p_information9_o => per_cpn_shd.g_old_rec.information9
369: ,p_information10_o => per_cpn_shd.g_old_rec.information10
370: ,p_information11_o => per_cpn_shd.g_old_rec.information11
371: ,p_information12_o => per_cpn_shd.g_old_rec.information12
372: ,p_information13_o => per_cpn_shd.g_old_rec.information13

Line 369: ,p_information10_o => per_cpn_shd.g_old_rec.information10

365: ,p_information6_o => per_cpn_shd.g_old_rec.information6
366: ,p_information7_o => per_cpn_shd.g_old_rec.information7
367: ,p_information8_o => per_cpn_shd.g_old_rec.information8
368: ,p_information9_o => per_cpn_shd.g_old_rec.information9
369: ,p_information10_o => per_cpn_shd.g_old_rec.information10
370: ,p_information11_o => per_cpn_shd.g_old_rec.information11
371: ,p_information12_o => per_cpn_shd.g_old_rec.information12
372: ,p_information13_o => per_cpn_shd.g_old_rec.information13
373: ,p_information14_o => per_cpn_shd.g_old_rec.information14

Line 370: ,p_information11_o => per_cpn_shd.g_old_rec.information11

366: ,p_information7_o => per_cpn_shd.g_old_rec.information7
367: ,p_information8_o => per_cpn_shd.g_old_rec.information8
368: ,p_information9_o => per_cpn_shd.g_old_rec.information9
369: ,p_information10_o => per_cpn_shd.g_old_rec.information10
370: ,p_information11_o => per_cpn_shd.g_old_rec.information11
371: ,p_information12_o => per_cpn_shd.g_old_rec.information12
372: ,p_information13_o => per_cpn_shd.g_old_rec.information13
373: ,p_information14_o => per_cpn_shd.g_old_rec.information14
374: ,p_information15_o => per_cpn_shd.g_old_rec.information15

Line 371: ,p_information12_o => per_cpn_shd.g_old_rec.information12

367: ,p_information8_o => per_cpn_shd.g_old_rec.information8
368: ,p_information9_o => per_cpn_shd.g_old_rec.information9
369: ,p_information10_o => per_cpn_shd.g_old_rec.information10
370: ,p_information11_o => per_cpn_shd.g_old_rec.information11
371: ,p_information12_o => per_cpn_shd.g_old_rec.information12
372: ,p_information13_o => per_cpn_shd.g_old_rec.information13
373: ,p_information14_o => per_cpn_shd.g_old_rec.information14
374: ,p_information15_o => per_cpn_shd.g_old_rec.information15
375: ,p_information16_o => per_cpn_shd.g_old_rec.information16

Line 372: ,p_information13_o => per_cpn_shd.g_old_rec.information13

368: ,p_information9_o => per_cpn_shd.g_old_rec.information9
369: ,p_information10_o => per_cpn_shd.g_old_rec.information10
370: ,p_information11_o => per_cpn_shd.g_old_rec.information11
371: ,p_information12_o => per_cpn_shd.g_old_rec.information12
372: ,p_information13_o => per_cpn_shd.g_old_rec.information13
373: ,p_information14_o => per_cpn_shd.g_old_rec.information14
374: ,p_information15_o => per_cpn_shd.g_old_rec.information15
375: ,p_information16_o => per_cpn_shd.g_old_rec.information16
376: ,p_information17_o => per_cpn_shd.g_old_rec.information17

Line 373: ,p_information14_o => per_cpn_shd.g_old_rec.information14

369: ,p_information10_o => per_cpn_shd.g_old_rec.information10
370: ,p_information11_o => per_cpn_shd.g_old_rec.information11
371: ,p_information12_o => per_cpn_shd.g_old_rec.information12
372: ,p_information13_o => per_cpn_shd.g_old_rec.information13
373: ,p_information14_o => per_cpn_shd.g_old_rec.information14
374: ,p_information15_o => per_cpn_shd.g_old_rec.information15
375: ,p_information16_o => per_cpn_shd.g_old_rec.information16
376: ,p_information17_o => per_cpn_shd.g_old_rec.information17
377: ,p_information18_o => per_cpn_shd.g_old_rec.information18

Line 374: ,p_information15_o => per_cpn_shd.g_old_rec.information15

370: ,p_information11_o => per_cpn_shd.g_old_rec.information11
371: ,p_information12_o => per_cpn_shd.g_old_rec.information12
372: ,p_information13_o => per_cpn_shd.g_old_rec.information13
373: ,p_information14_o => per_cpn_shd.g_old_rec.information14
374: ,p_information15_o => per_cpn_shd.g_old_rec.information15
375: ,p_information16_o => per_cpn_shd.g_old_rec.information16
376: ,p_information17_o => per_cpn_shd.g_old_rec.information17
377: ,p_information18_o => per_cpn_shd.g_old_rec.information18
378: ,p_information19_o => per_cpn_shd.g_old_rec.information19

Line 375: ,p_information16_o => per_cpn_shd.g_old_rec.information16

371: ,p_information12_o => per_cpn_shd.g_old_rec.information12
372: ,p_information13_o => per_cpn_shd.g_old_rec.information13
373: ,p_information14_o => per_cpn_shd.g_old_rec.information14
374: ,p_information15_o => per_cpn_shd.g_old_rec.information15
375: ,p_information16_o => per_cpn_shd.g_old_rec.information16
376: ,p_information17_o => per_cpn_shd.g_old_rec.information17
377: ,p_information18_o => per_cpn_shd.g_old_rec.information18
378: ,p_information19_o => per_cpn_shd.g_old_rec.information19
379: ,p_information20_o => per_cpn_shd.g_old_rec.information20

Line 376: ,p_information17_o => per_cpn_shd.g_old_rec.information17

372: ,p_information13_o => per_cpn_shd.g_old_rec.information13
373: ,p_information14_o => per_cpn_shd.g_old_rec.information14
374: ,p_information15_o => per_cpn_shd.g_old_rec.information15
375: ,p_information16_o => per_cpn_shd.g_old_rec.information16
376: ,p_information17_o => per_cpn_shd.g_old_rec.information17
377: ,p_information18_o => per_cpn_shd.g_old_rec.information18
378: ,p_information19_o => per_cpn_shd.g_old_rec.information19
379: ,p_information20_o => per_cpn_shd.g_old_rec.information20
380: );

Line 377: ,p_information18_o => per_cpn_shd.g_old_rec.information18

373: ,p_information14_o => per_cpn_shd.g_old_rec.information14
374: ,p_information15_o => per_cpn_shd.g_old_rec.information15
375: ,p_information16_o => per_cpn_shd.g_old_rec.information16
376: ,p_information17_o => per_cpn_shd.g_old_rec.information17
377: ,p_information18_o => per_cpn_shd.g_old_rec.information18
378: ,p_information19_o => per_cpn_shd.g_old_rec.information19
379: ,p_information20_o => per_cpn_shd.g_old_rec.information20
380: );
381:

Line 378: ,p_information19_o => per_cpn_shd.g_old_rec.information19

374: ,p_information15_o => per_cpn_shd.g_old_rec.information15
375: ,p_information16_o => per_cpn_shd.g_old_rec.information16
376: ,p_information17_o => per_cpn_shd.g_old_rec.information17
377: ,p_information18_o => per_cpn_shd.g_old_rec.information18
378: ,p_information19_o => per_cpn_shd.g_old_rec.information19
379: ,p_information20_o => per_cpn_shd.g_old_rec.information20
380: );
381:
382: exception

Line 379: ,p_information20_o => per_cpn_shd.g_old_rec.information20

375: ,p_information16_o => per_cpn_shd.g_old_rec.information16
376: ,p_information17_o => per_cpn_shd.g_old_rec.information17
377: ,p_information18_o => per_cpn_shd.g_old_rec.information18
378: ,p_information19_o => per_cpn_shd.g_old_rec.information19
379: ,p_information20_o => per_cpn_shd.g_old_rec.information20
380: );
381:
382: exception
383: when hr_api.cannot_find_prog_unit then

Line 438: Procedure convert_defs(p_rec in out nocopy per_cpn_shd.g_rec_type) is

434: -- Internal Table Handler Use Only.
435: --
436: -- {End Of Comments}
437: -- ---------------------------------------------------------------------------
438: Procedure convert_defs(p_rec in out nocopy per_cpn_shd.g_rec_type) is
439: --
440: l_proc varchar2(72) := g_package||'convert_defs';
441: --
442: Begin

Line 453: per_cpn_shd.g_old_rec.name;

449: -- is being used then we must set to the 'current' argument value.
450: --
451: If (p_rec.name = hr_api.g_varchar2) then
452: p_rec.name :=
453: per_cpn_shd.g_old_rec.name;
454: End If;
455: If (p_rec.business_group_id = hr_api.g_number) then
456: p_rec.business_group_id :=
457: per_cpn_shd.g_old_rec.business_group_id;

Line 457: per_cpn_shd.g_old_rec.business_group_id;

453: per_cpn_shd.g_old_rec.name;
454: End If;
455: If (p_rec.business_group_id = hr_api.g_number) then
456: p_rec.business_group_id :=
457: per_cpn_shd.g_old_rec.business_group_id;
458: End If;
459: If (p_rec.description = hr_api.g_varchar2) then
460: p_rec.description :=
461: per_cpn_shd.g_old_rec.description;

Line 461: per_cpn_shd.g_old_rec.description;

457: per_cpn_shd.g_old_rec.business_group_id;
458: End If;
459: If (p_rec.description = hr_api.g_varchar2) then
460: p_rec.description :=
461: per_cpn_shd.g_old_rec.description;
462: End If;
463: If (p_rec.date_from = hr_api.g_date) then
464: p_rec.date_from :=
465: per_cpn_shd.g_old_rec.date_from;

Line 465: per_cpn_shd.g_old_rec.date_from;

461: per_cpn_shd.g_old_rec.description;
462: End If;
463: If (p_rec.date_from = hr_api.g_date) then
464: p_rec.date_from :=
465: per_cpn_shd.g_old_rec.date_from;
466: End If;
467: If (p_rec.date_to = hr_api.g_date) then
468: p_rec.date_to :=
469: per_cpn_shd.g_old_rec.date_to;

Line 469: per_cpn_shd.g_old_rec.date_to;

465: per_cpn_shd.g_old_rec.date_from;
466: End If;
467: If (p_rec.date_to = hr_api.g_date) then
468: p_rec.date_to :=
469: per_cpn_shd.g_old_rec.date_to;
470: End If;
471: If (p_rec.behavioural_indicator = hr_api.g_varchar2) then
472: p_rec.behavioural_indicator :=
473: per_cpn_shd.g_old_rec.behavioural_indicator;

Line 473: per_cpn_shd.g_old_rec.behavioural_indicator;

469: per_cpn_shd.g_old_rec.date_to;
470: End If;
471: If (p_rec.behavioural_indicator = hr_api.g_varchar2) then
472: p_rec.behavioural_indicator :=
473: per_cpn_shd.g_old_rec.behavioural_indicator;
474: End If;
475: If (p_rec.certification_required = hr_api.g_varchar2) then
476: p_rec.certification_required :=
477: per_cpn_shd.g_old_rec.certification_required;

Line 477: per_cpn_shd.g_old_rec.certification_required;

473: per_cpn_shd.g_old_rec.behavioural_indicator;
474: End If;
475: If (p_rec.certification_required = hr_api.g_varchar2) then
476: p_rec.certification_required :=
477: per_cpn_shd.g_old_rec.certification_required;
478: End If;
479: If (p_rec.evaluation_method = hr_api.g_varchar2) then
480: p_rec.evaluation_method :=
481: per_cpn_shd.g_old_rec.evaluation_method;

Line 481: per_cpn_shd.g_old_rec.evaluation_method;

477: per_cpn_shd.g_old_rec.certification_required;
478: End If;
479: If (p_rec.evaluation_method = hr_api.g_varchar2) then
480: p_rec.evaluation_method :=
481: per_cpn_shd.g_old_rec.evaluation_method;
482: End If;
483: If (p_rec.renewal_period_frequency = hr_api.g_number) then
484: p_rec.renewal_period_frequency :=
485: per_cpn_shd.g_old_rec.renewal_period_frequency;

Line 485: per_cpn_shd.g_old_rec.renewal_period_frequency;

481: per_cpn_shd.g_old_rec.evaluation_method;
482: End If;
483: If (p_rec.renewal_period_frequency = hr_api.g_number) then
484: p_rec.renewal_period_frequency :=
485: per_cpn_shd.g_old_rec.renewal_period_frequency;
486: End If;
487: If (p_rec.renewal_period_units = hr_api.g_varchar2) then
488: p_rec.renewal_period_units :=
489: per_cpn_shd.g_old_rec.renewal_period_units;

Line 489: per_cpn_shd.g_old_rec.renewal_period_units;

485: per_cpn_shd.g_old_rec.renewal_period_frequency;
486: End If;
487: If (p_rec.renewal_period_units = hr_api.g_varchar2) then
488: p_rec.renewal_period_units :=
489: per_cpn_shd.g_old_rec.renewal_period_units;
490: End If;
491: If (p_rec.min_level = hr_api.g_number) then
492: p_rec.min_level :=
493: per_cpn_shd.g_old_rec.min_level;

Line 493: per_cpn_shd.g_old_rec.min_level;

489: per_cpn_shd.g_old_rec.renewal_period_units;
490: End If;
491: If (p_rec.min_level = hr_api.g_number) then
492: p_rec.min_level :=
493: per_cpn_shd.g_old_rec.min_level;
494: End If;
495: If (p_rec.max_level = hr_api.g_number) then
496: p_rec.max_level :=
497: per_cpn_shd.g_old_rec.max_level;

Line 497: per_cpn_shd.g_old_rec.max_level;

493: per_cpn_shd.g_old_rec.min_level;
494: End If;
495: If (p_rec.max_level = hr_api.g_number) then
496: p_rec.max_level :=
497: per_cpn_shd.g_old_rec.max_level;
498: End If;
499: If (p_rec.rating_scale_id = hr_api.g_number) then
500: p_rec.rating_scale_id :=
501: per_cpn_shd.g_old_rec.rating_scale_id;

Line 501: per_cpn_shd.g_old_rec.rating_scale_id;

497: per_cpn_shd.g_old_rec.max_level;
498: End If;
499: If (p_rec.rating_scale_id = hr_api.g_number) then
500: p_rec.rating_scale_id :=
501: per_cpn_shd.g_old_rec.rating_scale_id;
502: End If;
503: If (p_rec.attribute_category = hr_api.g_varchar2) then
504: p_rec.attribute_category :=
505: per_cpn_shd.g_old_rec.attribute_category;

Line 505: per_cpn_shd.g_old_rec.attribute_category;

501: per_cpn_shd.g_old_rec.rating_scale_id;
502: End If;
503: If (p_rec.attribute_category = hr_api.g_varchar2) then
504: p_rec.attribute_category :=
505: per_cpn_shd.g_old_rec.attribute_category;
506: End If;
507: If (p_rec.attribute1 = hr_api.g_varchar2) then
508: p_rec.attribute1 :=
509: per_cpn_shd.g_old_rec.attribute1;

Line 509: per_cpn_shd.g_old_rec.attribute1;

505: per_cpn_shd.g_old_rec.attribute_category;
506: End If;
507: If (p_rec.attribute1 = hr_api.g_varchar2) then
508: p_rec.attribute1 :=
509: per_cpn_shd.g_old_rec.attribute1;
510: End If;
511: If (p_rec.attribute2 = hr_api.g_varchar2) then
512: p_rec.attribute2 :=
513: per_cpn_shd.g_old_rec.attribute2;

Line 513: per_cpn_shd.g_old_rec.attribute2;

509: per_cpn_shd.g_old_rec.attribute1;
510: End If;
511: If (p_rec.attribute2 = hr_api.g_varchar2) then
512: p_rec.attribute2 :=
513: per_cpn_shd.g_old_rec.attribute2;
514: End If;
515: If (p_rec.attribute3 = hr_api.g_varchar2) then
516: p_rec.attribute3 :=
517: per_cpn_shd.g_old_rec.attribute3;

Line 517: per_cpn_shd.g_old_rec.attribute3;

513: per_cpn_shd.g_old_rec.attribute2;
514: End If;
515: If (p_rec.attribute3 = hr_api.g_varchar2) then
516: p_rec.attribute3 :=
517: per_cpn_shd.g_old_rec.attribute3;
518: End If;
519: If (p_rec.attribute4 = hr_api.g_varchar2) then
520: p_rec.attribute4 :=
521: per_cpn_shd.g_old_rec.attribute4;

Line 521: per_cpn_shd.g_old_rec.attribute4;

517: per_cpn_shd.g_old_rec.attribute3;
518: End If;
519: If (p_rec.attribute4 = hr_api.g_varchar2) then
520: p_rec.attribute4 :=
521: per_cpn_shd.g_old_rec.attribute4;
522: End If;
523: If (p_rec.attribute5 = hr_api.g_varchar2) then
524: p_rec.attribute5 :=
525: per_cpn_shd.g_old_rec.attribute5;

Line 525: per_cpn_shd.g_old_rec.attribute5;

521: per_cpn_shd.g_old_rec.attribute4;
522: End If;
523: If (p_rec.attribute5 = hr_api.g_varchar2) then
524: p_rec.attribute5 :=
525: per_cpn_shd.g_old_rec.attribute5;
526: End If;
527: If (p_rec.attribute6 = hr_api.g_varchar2) then
528: p_rec.attribute6 :=
529: per_cpn_shd.g_old_rec.attribute6;

Line 529: per_cpn_shd.g_old_rec.attribute6;

525: per_cpn_shd.g_old_rec.attribute5;
526: End If;
527: If (p_rec.attribute6 = hr_api.g_varchar2) then
528: p_rec.attribute6 :=
529: per_cpn_shd.g_old_rec.attribute6;
530: End If;
531: If (p_rec.attribute7 = hr_api.g_varchar2) then
532: p_rec.attribute7 :=
533: per_cpn_shd.g_old_rec.attribute7;

Line 533: per_cpn_shd.g_old_rec.attribute7;

529: per_cpn_shd.g_old_rec.attribute6;
530: End If;
531: If (p_rec.attribute7 = hr_api.g_varchar2) then
532: p_rec.attribute7 :=
533: per_cpn_shd.g_old_rec.attribute7;
534: End If;
535: If (p_rec.attribute8 = hr_api.g_varchar2) then
536: p_rec.attribute8 :=
537: per_cpn_shd.g_old_rec.attribute8;

Line 537: per_cpn_shd.g_old_rec.attribute8;

533: per_cpn_shd.g_old_rec.attribute7;
534: End If;
535: If (p_rec.attribute8 = hr_api.g_varchar2) then
536: p_rec.attribute8 :=
537: per_cpn_shd.g_old_rec.attribute8;
538: End If;
539: If (p_rec.attribute9 = hr_api.g_varchar2) then
540: p_rec.attribute9 :=
541: per_cpn_shd.g_old_rec.attribute9;

Line 541: per_cpn_shd.g_old_rec.attribute9;

537: per_cpn_shd.g_old_rec.attribute8;
538: End If;
539: If (p_rec.attribute9 = hr_api.g_varchar2) then
540: p_rec.attribute9 :=
541: per_cpn_shd.g_old_rec.attribute9;
542: End If;
543: If (p_rec.attribute10 = hr_api.g_varchar2) then
544: p_rec.attribute10 :=
545: per_cpn_shd.g_old_rec.attribute10;

Line 545: per_cpn_shd.g_old_rec.attribute10;

541: per_cpn_shd.g_old_rec.attribute9;
542: End If;
543: If (p_rec.attribute10 = hr_api.g_varchar2) then
544: p_rec.attribute10 :=
545: per_cpn_shd.g_old_rec.attribute10;
546: End If;
547: If (p_rec.attribute11 = hr_api.g_varchar2) then
548: p_rec.attribute11 :=
549: per_cpn_shd.g_old_rec.attribute11;

Line 549: per_cpn_shd.g_old_rec.attribute11;

545: per_cpn_shd.g_old_rec.attribute10;
546: End If;
547: If (p_rec.attribute11 = hr_api.g_varchar2) then
548: p_rec.attribute11 :=
549: per_cpn_shd.g_old_rec.attribute11;
550: eND iF;
551: If (p_rec.attribute12 = hr_api.g_varchar2) then
552: p_rec.attribute12 :=
553: per_cpn_shd.g_old_rec.attribute12;

Line 553: per_cpn_shd.g_old_rec.attribute12;

549: per_cpn_shd.g_old_rec.attribute11;
550: eND iF;
551: If (p_rec.attribute12 = hr_api.g_varchar2) then
552: p_rec.attribute12 :=
553: per_cpn_shd.g_old_rec.attribute12;
554: End If;
555: If (p_rec.attribute13 = hr_api.g_varchar2) then
556: p_rec.attribute13 :=
557: per_cpn_shd.g_old_rec.attribute13;

Line 557: per_cpn_shd.g_old_rec.attribute13;

553: per_cpn_shd.g_old_rec.attribute12;
554: End If;
555: If (p_rec.attribute13 = hr_api.g_varchar2) then
556: p_rec.attribute13 :=
557: per_cpn_shd.g_old_rec.attribute13;
558: End If;
559: If (p_rec.attribute14 = hr_api.g_varchar2) then
560: p_rec.attribute14 :=
561: per_cpn_shd.g_old_rec.attribute14;

Line 561: per_cpn_shd.g_old_rec.attribute14;

557: per_cpn_shd.g_old_rec.attribute13;
558: End If;
559: If (p_rec.attribute14 = hr_api.g_varchar2) then
560: p_rec.attribute14 :=
561: per_cpn_shd.g_old_rec.attribute14;
562: End If;
563: If (p_rec.attribute15 = hr_api.g_varchar2) then
564: p_rec.attribute15 :=
565: per_cpn_shd.g_old_rec.attribute15;

Line 565: per_cpn_shd.g_old_rec.attribute15;

561: per_cpn_shd.g_old_rec.attribute14;
562: End If;
563: If (p_rec.attribute15 = hr_api.g_varchar2) then
564: p_rec.attribute15 :=
565: per_cpn_shd.g_old_rec.attribute15;
566: End If;
567: If (p_rec.attribute16 = hr_api.g_varchar2) then
568: p_rec.attribute16 :=
569: per_cpn_shd.g_old_rec.attribute16;

Line 569: per_cpn_shd.g_old_rec.attribute16;

565: per_cpn_shd.g_old_rec.attribute15;
566: End If;
567: If (p_rec.attribute16 = hr_api.g_varchar2) then
568: p_rec.attribute16 :=
569: per_cpn_shd.g_old_rec.attribute16;
570: End If;
571: If (p_rec.attribute17 = hr_api.g_varchar2) then
572: p_rec.attribute17 :=
573: per_cpn_shd.g_old_rec.attribute17;

Line 573: per_cpn_shd.g_old_rec.attribute17;

569: per_cpn_shd.g_old_rec.attribute16;
570: End If;
571: If (p_rec.attribute17 = hr_api.g_varchar2) then
572: p_rec.attribute17 :=
573: per_cpn_shd.g_old_rec.attribute17;
574: End If;
575: If (p_rec.attribute18 = hr_api.g_varchar2) then
576: p_rec.attribute18 :=
577: per_cpn_shd.g_old_rec.attribute18;

Line 577: per_cpn_shd.g_old_rec.attribute18;

573: per_cpn_shd.g_old_rec.attribute17;
574: End If;
575: If (p_rec.attribute18 = hr_api.g_varchar2) then
576: p_rec.attribute18 :=
577: per_cpn_shd.g_old_rec.attribute18;
578: End If;
579: If (p_rec.attribute19 = hr_api.g_varchar2) then
580: p_rec.attribute19 :=
581: per_cpn_shd.g_old_rec.attribute19;

Line 581: per_cpn_shd.g_old_rec.attribute19;

577: per_cpn_shd.g_old_rec.attribute18;
578: End If;
579: If (p_rec.attribute19 = hr_api.g_varchar2) then
580: p_rec.attribute19 :=
581: per_cpn_shd.g_old_rec.attribute19;
582: End If;
583: If (p_rec.attribute20 = hr_api.g_varchar2) then
584: p_rec.attribute20 :=
585: per_cpn_shd.g_old_rec.attribute20;

Line 585: per_cpn_shd.g_old_rec.attribute20;

581: per_cpn_shd.g_old_rec.attribute19;
582: End If;
583: If (p_rec.attribute20 = hr_api.g_varchar2) then
584: p_rec.attribute20 :=
585: per_cpn_shd.g_old_rec.attribute20;
586: End If;
587: -- ngundura changes as per pa requirements
588: If (p_rec.competence_alias = hr_api.g_varchar2) then
589: p_rec.competence_alias :=

Line 590: per_cpn_shd.g_old_rec.competence_alias;

586: End If;
587: -- ngundura changes as per pa requirements
588: If (p_rec.competence_alias = hr_api.g_varchar2) then
589: p_rec.competence_alias :=
590: per_cpn_shd.g_old_rec.competence_alias;
591: End If;
592: If (p_rec.competence_definition_id = hr_api.g_number) then
593: p_rec.competence_definition_id :=
594: per_cpn_shd.g_old_rec.competence_definition_id;

Line 594: per_cpn_shd.g_old_rec.competence_definition_id;

590: per_cpn_shd.g_old_rec.competence_alias;
591: End If;
592: If (p_rec.competence_definition_id = hr_api.g_number) then
593: p_rec.competence_definition_id :=
594: per_cpn_shd.g_old_rec.competence_definition_id;
595: End If;
596: --
597: -- BUG3356369
598: --

Line 601: per_cpn_shd.g_old_rec.competence_cluster;

597: -- BUG3356369
598: --
599: If (p_rec.competence_cluster = hr_api.g_varchar2) then
600: p_rec.competence_cluster :=
601: per_cpn_shd.g_old_rec.competence_cluster;
602: End If;
603: If (p_rec.unit_standard_id = hr_api.g_varchar2) then
604: p_rec.unit_standard_id :=
605: per_cpn_shd.g_old_rec.unit_standard_id;

Line 605: per_cpn_shd.g_old_rec.unit_standard_id;

601: per_cpn_shd.g_old_rec.competence_cluster;
602: End If;
603: If (p_rec.unit_standard_id = hr_api.g_varchar2) then
604: p_rec.unit_standard_id :=
605: per_cpn_shd.g_old_rec.unit_standard_id;
606: End If;
607: If (p_rec.credit_type = hr_api.g_varchar2) then
608: p_rec.credit_type :=
609: per_cpn_shd.g_old_rec.credit_type;

Line 609: per_cpn_shd.g_old_rec.credit_type;

605: per_cpn_shd.g_old_rec.unit_standard_id;
606: End If;
607: If (p_rec.credit_type = hr_api.g_varchar2) then
608: p_rec.credit_type :=
609: per_cpn_shd.g_old_rec.credit_type;
610: End If;
611: If (p_rec.credits = hr_api.g_number) then
612: p_rec.credits :=
613: per_cpn_shd.g_old_rec.credits;

Line 613: per_cpn_shd.g_old_rec.credits;

609: per_cpn_shd.g_old_rec.credit_type;
610: End If;
611: If (p_rec.credits = hr_api.g_number) then
612: p_rec.credits :=
613: per_cpn_shd.g_old_rec.credits;
614: End If;
615: If (p_rec.level_type = hr_api.g_varchar2) then
616: p_rec.level_type :=
617: per_cpn_shd.g_old_rec.level_type;

Line 617: per_cpn_shd.g_old_rec.level_type;

613: per_cpn_shd.g_old_rec.credits;
614: End If;
615: If (p_rec.level_type = hr_api.g_varchar2) then
616: p_rec.level_type :=
617: per_cpn_shd.g_old_rec.level_type;
618: End If;
619: If (p_rec.level_number = hr_api.g_number) then
620: p_rec.level_number :=
621: per_cpn_shd.g_old_rec.level_number;

Line 621: per_cpn_shd.g_old_rec.level_number;

617: per_cpn_shd.g_old_rec.level_type;
618: End If;
619: If (p_rec.level_number = hr_api.g_number) then
620: p_rec.level_number :=
621: per_cpn_shd.g_old_rec.level_number;
622: End If;
623: If (p_rec.field = hr_api.g_varchar2) then
624: p_rec.field :=
625: per_cpn_shd.g_old_rec.field ;

Line 625: per_cpn_shd.g_old_rec.field ;

621: per_cpn_shd.g_old_rec.level_number;
622: End If;
623: If (p_rec.field = hr_api.g_varchar2) then
624: p_rec.field :=
625: per_cpn_shd.g_old_rec.field ;
626: End If;
627: If (p_rec.sub_field = hr_api.g_varchar2) then
628: p_rec.sub_field :=
629: per_cpn_shd.g_old_rec.sub_field;

Line 629: per_cpn_shd.g_old_rec.sub_field;

625: per_cpn_shd.g_old_rec.field ;
626: End If;
627: If (p_rec.sub_field = hr_api.g_varchar2) then
628: p_rec.sub_field :=
629: per_cpn_shd.g_old_rec.sub_field;
630: End If;
631: If (p_rec.provider = hr_api.g_varchar2) then
632: p_rec.provider :=
633: per_cpn_shd.g_old_rec.provider;

Line 633: per_cpn_shd.g_old_rec.provider;

629: per_cpn_shd.g_old_rec.sub_field;
630: End If;
631: If (p_rec.provider = hr_api.g_varchar2) then
632: p_rec.provider :=
633: per_cpn_shd.g_old_rec.provider;
634: End If;
635: If (p_rec.qa_organization = hr_api.g_varchar2) then
636: p_rec.qa_organization :=
637: per_cpn_shd.g_old_rec.qa_organization;

Line 637: per_cpn_shd.g_old_rec.qa_organization;

633: per_cpn_shd.g_old_rec.provider;
634: End If;
635: If (p_rec.qa_organization = hr_api.g_varchar2) then
636: p_rec.qa_organization :=
637: per_cpn_shd.g_old_rec.qa_organization;
638: End If;
639: If (p_rec.information_category = hr_api.g_varchar2) then
640: p_rec.information_category :=
641: per_cpn_shd.g_old_rec.information_category;

Line 641: per_cpn_shd.g_old_rec.information_category;

637: per_cpn_shd.g_old_rec.qa_organization;
638: End If;
639: If (p_rec.information_category = hr_api.g_varchar2) then
640: p_rec.information_category :=
641: per_cpn_shd.g_old_rec.information_category;
642: End If;
643: If (p_rec.information1 = hr_api.g_varchar2) then
644: p_rec.information1 :=
645: per_cpn_shd.g_old_rec.information1;

Line 645: per_cpn_shd.g_old_rec.information1;

641: per_cpn_shd.g_old_rec.information_category;
642: End If;
643: If (p_rec.information1 = hr_api.g_varchar2) then
644: p_rec.information1 :=
645: per_cpn_shd.g_old_rec.information1;
646: End If;
647: If (p_rec.information2 = hr_api.g_varchar2) then
648: p_rec.information2 :=
649: per_cpn_shd.g_old_rec.information2;

Line 649: per_cpn_shd.g_old_rec.information2;

645: per_cpn_shd.g_old_rec.information1;
646: End If;
647: If (p_rec.information2 = hr_api.g_varchar2) then
648: p_rec.information2 :=
649: per_cpn_shd.g_old_rec.information2;
650: End If;
651: If (p_rec.information3 = hr_api.g_varchar2) then
652: p_rec.information3 :=
653: per_cpn_shd.g_old_rec.information3;

Line 653: per_cpn_shd.g_old_rec.information3;

649: per_cpn_shd.g_old_rec.information2;
650: End If;
651: If (p_rec.information3 = hr_api.g_varchar2) then
652: p_rec.information3 :=
653: per_cpn_shd.g_old_rec.information3;
654: End If;
655: If (p_rec.information4 = hr_api.g_varchar2) then
656: p_rec.information4 :=
657: per_cpn_shd.g_old_rec.information4;

Line 657: per_cpn_shd.g_old_rec.information4;

653: per_cpn_shd.g_old_rec.information3;
654: End If;
655: If (p_rec.information4 = hr_api.g_varchar2) then
656: p_rec.information4 :=
657: per_cpn_shd.g_old_rec.information4;
658: End If;
659: If (p_rec.information5 = hr_api.g_varchar2) then
660: p_rec.information5 :=
661: per_cpn_shd.g_old_rec.information5;

Line 661: per_cpn_shd.g_old_rec.information5;

657: per_cpn_shd.g_old_rec.information4;
658: End If;
659: If (p_rec.information5 = hr_api.g_varchar2) then
660: p_rec.information5 :=
661: per_cpn_shd.g_old_rec.information5;
662: End If;
663: If (p_rec.information6 = hr_api.g_varchar2) then
664: p_rec.information6 :=
665: per_cpn_shd.g_old_rec.information6;

Line 665: per_cpn_shd.g_old_rec.information6;

661: per_cpn_shd.g_old_rec.information5;
662: End If;
663: If (p_rec.information6 = hr_api.g_varchar2) then
664: p_rec.information6 :=
665: per_cpn_shd.g_old_rec.information6;
666: End If;
667: If (p_rec.information7 = hr_api.g_varchar2) then
668: p_rec.information7 :=
669: per_cpn_shd.g_old_rec.information7;

Line 669: per_cpn_shd.g_old_rec.information7;

665: per_cpn_shd.g_old_rec.information6;
666: End If;
667: If (p_rec.information7 = hr_api.g_varchar2) then
668: p_rec.information7 :=
669: per_cpn_shd.g_old_rec.information7;
670: End If;
671: If (p_rec.information8 = hr_api.g_varchar2) then
672: p_rec.information8 :=
673: per_cpn_shd.g_old_rec.information8;

Line 673: per_cpn_shd.g_old_rec.information8;

669: per_cpn_shd.g_old_rec.information7;
670: End If;
671: If (p_rec.information8 = hr_api.g_varchar2) then
672: p_rec.information8 :=
673: per_cpn_shd.g_old_rec.information8;
674: End If;
675: If (p_rec.information9 = hr_api.g_varchar2) then
676: p_rec.information9 :=
677: per_cpn_shd.g_old_rec.information9;

Line 677: per_cpn_shd.g_old_rec.information9;

673: per_cpn_shd.g_old_rec.information8;
674: End If;
675: If (p_rec.information9 = hr_api.g_varchar2) then
676: p_rec.information9 :=
677: per_cpn_shd.g_old_rec.information9;
678: End If;
679: If (p_rec.information10 = hr_api.g_varchar2) then
680: p_rec.information10 :=
681: per_cpn_shd.g_old_rec.information10;

Line 681: per_cpn_shd.g_old_rec.information10;

677: per_cpn_shd.g_old_rec.information9;
678: End If;
679: If (p_rec.information10 = hr_api.g_varchar2) then
680: p_rec.information10 :=
681: per_cpn_shd.g_old_rec.information10;
682: End If;
683: If (p_rec.information11 = hr_api.g_varchar2) then
684: p_rec.information11 :=
685: per_cpn_shd.g_old_rec.information11;

Line 685: per_cpn_shd.g_old_rec.information11;

681: per_cpn_shd.g_old_rec.information10;
682: End If;
683: If (p_rec.information11 = hr_api.g_varchar2) then
684: p_rec.information11 :=
685: per_cpn_shd.g_old_rec.information11;
686: End If;
687: If (p_rec.information12 = hr_api.g_varchar2) then
688: p_rec.information12 :=
689: per_cpn_shd.g_old_rec.information12;

Line 689: per_cpn_shd.g_old_rec.information12;

685: per_cpn_shd.g_old_rec.information11;
686: End If;
687: If (p_rec.information12 = hr_api.g_varchar2) then
688: p_rec.information12 :=
689: per_cpn_shd.g_old_rec.information12;
690: End If;
691: If (p_rec.information13 = hr_api.g_varchar2) then
692: p_rec.information13 :=
693: per_cpn_shd.g_old_rec.information13;

Line 693: per_cpn_shd.g_old_rec.information13;

689: per_cpn_shd.g_old_rec.information12;
690: End If;
691: If (p_rec.information13 = hr_api.g_varchar2) then
692: p_rec.information13 :=
693: per_cpn_shd.g_old_rec.information13;
694: End If;
695: If (p_rec.information14 = hr_api.g_varchar2) then
696: p_rec.information14 :=
697: per_cpn_shd.g_old_rec.information14;

Line 697: per_cpn_shd.g_old_rec.information14;

693: per_cpn_shd.g_old_rec.information13;
694: End If;
695: If (p_rec.information14 = hr_api.g_varchar2) then
696: p_rec.information14 :=
697: per_cpn_shd.g_old_rec.information14;
698: End If;
699: If (p_rec.information15 = hr_api.g_varchar2) then
700: p_rec.information15 :=
701: per_cpn_shd.g_old_rec.information15;

Line 701: per_cpn_shd.g_old_rec.information15;

697: per_cpn_shd.g_old_rec.information14;
698: End If;
699: If (p_rec.information15 = hr_api.g_varchar2) then
700: p_rec.information15 :=
701: per_cpn_shd.g_old_rec.information15;
702: End If;
703: If (p_rec.information16 = hr_api.g_varchar2) then
704: p_rec.information16 :=
705: per_cpn_shd.g_old_rec.information16;

Line 705: per_cpn_shd.g_old_rec.information16;

701: per_cpn_shd.g_old_rec.information15;
702: End If;
703: If (p_rec.information16 = hr_api.g_varchar2) then
704: p_rec.information16 :=
705: per_cpn_shd.g_old_rec.information16;
706: End If;
707: If (p_rec.information17 = hr_api.g_varchar2) then
708: p_rec.information17 :=
709: per_cpn_shd.g_old_rec.information17;

Line 709: per_cpn_shd.g_old_rec.information17;

705: per_cpn_shd.g_old_rec.information16;
706: End If;
707: If (p_rec.information17 = hr_api.g_varchar2) then
708: p_rec.information17 :=
709: per_cpn_shd.g_old_rec.information17;
710: End If;
711: If (p_rec.information18 = hr_api.g_varchar2) then
712: p_rec.information18 :=
713: per_cpn_shd.g_old_rec.information18;

Line 713: per_cpn_shd.g_old_rec.information18;

709: per_cpn_shd.g_old_rec.information17;
710: End If;
711: If (p_rec.information18 = hr_api.g_varchar2) then
712: p_rec.information18 :=
713: per_cpn_shd.g_old_rec.information18;
714: End If;
715: If (p_rec.information19 = hr_api.g_varchar2) then
716: p_rec.information19 :=
717: per_cpn_shd.g_old_rec.information19;

Line 717: per_cpn_shd.g_old_rec.information19;

713: per_cpn_shd.g_old_rec.information18;
714: End If;
715: If (p_rec.information19 = hr_api.g_varchar2) then
716: p_rec.information19 :=
717: per_cpn_shd.g_old_rec.information19;
718: End If;
719: If (p_rec.information20 = hr_api.g_varchar2) then
720: p_rec.information20 :=
721: per_cpn_shd.g_old_rec.information20;

Line 721: per_cpn_shd.g_old_rec.information20;

717: per_cpn_shd.g_old_rec.information19;
718: End If;
719: If (p_rec.information20 = hr_api.g_varchar2) then
720: p_rec.information20 :=
721: per_cpn_shd.g_old_rec.information20;
722: End If;
723: --
724: hr_utility.set_location(' Leaving:'||l_proc, 10);
725: --

Line 733: p_rec in out nocopy per_cpn_shd.g_rec_type,

729: -- |---------------------------------< upd >----------------------------------|
730: -- ----------------------------------------------------------------------------
731: Procedure upd
732: (
733: p_rec in out nocopy per_cpn_shd.g_rec_type,
734: p_effective_date in date default null,
735: p_validate in boolean default false
736: ) is
737: --

Line 754: per_cpn_shd.lck

750: End If;
751: --
752: -- We must lock the row which we need to update.
753: --
754: per_cpn_shd.lck
755: (
756: p_rec.competence_id,
757: p_rec.object_version_number
758: );

Line 875: l_rec per_cpn_shd.g_rec_type;

871: ,p_information20 in varchar2 default hr_api.g_varchar2
872:
873: ) is
874: --
875: l_rec per_cpn_shd.g_rec_type;
876: l_proc varchar2(72) := g_package||'upd';
877: --
878: Begin
879: hr_utility.set_location('Entering:'||l_proc, 5);

Line 885: per_cpn_shd.convert_args

881: -- Call conversion function to turn arguments into the
882: -- l_rec structure.
883: --
884: l_rec :=
885: per_cpn_shd.convert_args
886: (
887: p_competence_id,
888: p_name,
889: hr_api.g_number,