51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_pml_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
130: Exception
131: When hr_api.check_integrity_violated Then
132: -- A check constraint has been violated
133: --
134: per_pml_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: --
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: --
139: per_pml_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.unique_integrity_violated Then
142: -- Unique integrity has been violated
143: --
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.unique_integrity_violated Then
142: -- Unique integrity has been violated
143: --
144: per_pml_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When Others Then
147: --
148: Raise;
180: --
181: -- {End Of Comments}
182: -- ----------------------------------------------------------------------------
183: Procedure pre_update
184: (p_rec in per_pml_shd.g_rec_type
185: ) is
186: --
187: l_proc varchar2(72) := g_package||'pre_update';
188: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure post_update
228: (p_effective_date in date
229: ,p_rec in per_pml_shd.g_rec_type
230: ,p_duplicate_name_warning in boolean
231: ,p_weighting_over_100_warning in boolean
232: ,p_weighting_appraisal_warning in boolean
233: ) is
350: => p_weighting_over_100_warning
351: ,p_weighting_appraisal_warning
352: => p_weighting_appraisal_warning
353: ,p_object_version_number_o
354: => per_pml_shd.g_old_rec.object_version_number
355: ,p_objective_name_o
356: => per_pml_shd.g_old_rec.objective_name
357: ,p_valid_from_o
358: => per_pml_shd.g_old_rec.valid_from
352: => p_weighting_appraisal_warning
353: ,p_object_version_number_o
354: => per_pml_shd.g_old_rec.object_version_number
355: ,p_objective_name_o
356: => per_pml_shd.g_old_rec.objective_name
357: ,p_valid_from_o
358: => per_pml_shd.g_old_rec.valid_from
359: ,p_valid_to_o
360: => per_pml_shd.g_old_rec.valid_to
354: => per_pml_shd.g_old_rec.object_version_number
355: ,p_objective_name_o
356: => per_pml_shd.g_old_rec.objective_name
357: ,p_valid_from_o
358: => per_pml_shd.g_old_rec.valid_from
359: ,p_valid_to_o
360: => per_pml_shd.g_old_rec.valid_to
361: ,p_target_date_o
362: => per_pml_shd.g_old_rec.target_date
356: => per_pml_shd.g_old_rec.objective_name
357: ,p_valid_from_o
358: => per_pml_shd.g_old_rec.valid_from
359: ,p_valid_to_o
360: => per_pml_shd.g_old_rec.valid_to
361: ,p_target_date_o
362: => per_pml_shd.g_old_rec.target_date
363: ,p_next_review_date_o
364: => per_pml_shd.g_old_rec.next_review_date
358: => per_pml_shd.g_old_rec.valid_from
359: ,p_valid_to_o
360: => per_pml_shd.g_old_rec.valid_to
361: ,p_target_date_o
362: => per_pml_shd.g_old_rec.target_date
363: ,p_next_review_date_o
364: => per_pml_shd.g_old_rec.next_review_date
365: ,p_group_code_o
366: => per_pml_shd.g_old_rec.group_code
360: => per_pml_shd.g_old_rec.valid_to
361: ,p_target_date_o
362: => per_pml_shd.g_old_rec.target_date
363: ,p_next_review_date_o
364: => per_pml_shd.g_old_rec.next_review_date
365: ,p_group_code_o
366: => per_pml_shd.g_old_rec.group_code
367: ,p_priority_code_o
368: => per_pml_shd.g_old_rec.priority_code
362: => per_pml_shd.g_old_rec.target_date
363: ,p_next_review_date_o
364: => per_pml_shd.g_old_rec.next_review_date
365: ,p_group_code_o
366: => per_pml_shd.g_old_rec.group_code
367: ,p_priority_code_o
368: => per_pml_shd.g_old_rec.priority_code
369: ,p_appraise_flag_o
370: => per_pml_shd.g_old_rec.appraise_flag
364: => per_pml_shd.g_old_rec.next_review_date
365: ,p_group_code_o
366: => per_pml_shd.g_old_rec.group_code
367: ,p_priority_code_o
368: => per_pml_shd.g_old_rec.priority_code
369: ,p_appraise_flag_o
370: => per_pml_shd.g_old_rec.appraise_flag
371: ,p_weighting_percent_o
372: => per_pml_shd.g_old_rec.weighting_percent
366: => per_pml_shd.g_old_rec.group_code
367: ,p_priority_code_o
368: => per_pml_shd.g_old_rec.priority_code
369: ,p_appraise_flag_o
370: => per_pml_shd.g_old_rec.appraise_flag
371: ,p_weighting_percent_o
372: => per_pml_shd.g_old_rec.weighting_percent
373: ,p_measurement_style_code_o
374: => per_pml_shd.g_old_rec.measurement_style_code
368: => per_pml_shd.g_old_rec.priority_code
369: ,p_appraise_flag_o
370: => per_pml_shd.g_old_rec.appraise_flag
371: ,p_weighting_percent_o
372: => per_pml_shd.g_old_rec.weighting_percent
373: ,p_measurement_style_code_o
374: => per_pml_shd.g_old_rec.measurement_style_code
375: ,p_measure_name_o
376: => per_pml_shd.g_old_rec.measure_name
370: => per_pml_shd.g_old_rec.appraise_flag
371: ,p_weighting_percent_o
372: => per_pml_shd.g_old_rec.weighting_percent
373: ,p_measurement_style_code_o
374: => per_pml_shd.g_old_rec.measurement_style_code
375: ,p_measure_name_o
376: => per_pml_shd.g_old_rec.measure_name
377: ,p_target_value_o
378: => per_pml_shd.g_old_rec.target_value
372: => per_pml_shd.g_old_rec.weighting_percent
373: ,p_measurement_style_code_o
374: => per_pml_shd.g_old_rec.measurement_style_code
375: ,p_measure_name_o
376: => per_pml_shd.g_old_rec.measure_name
377: ,p_target_value_o
378: => per_pml_shd.g_old_rec.target_value
379: ,p_uom_code_o
380: => per_pml_shd.g_old_rec.uom_code
374: => per_pml_shd.g_old_rec.measurement_style_code
375: ,p_measure_name_o
376: => per_pml_shd.g_old_rec.measure_name
377: ,p_target_value_o
378: => per_pml_shd.g_old_rec.target_value
379: ,p_uom_code_o
380: => per_pml_shd.g_old_rec.uom_code
381: ,p_measure_type_code_o
382: => per_pml_shd.g_old_rec.measure_type_code
376: => per_pml_shd.g_old_rec.measure_name
377: ,p_target_value_o
378: => per_pml_shd.g_old_rec.target_value
379: ,p_uom_code_o
380: => per_pml_shd.g_old_rec.uom_code
381: ,p_measure_type_code_o
382: => per_pml_shd.g_old_rec.measure_type_code
383: ,p_measure_comments_o
384: => per_pml_shd.g_old_rec.measure_comments
378: => per_pml_shd.g_old_rec.target_value
379: ,p_uom_code_o
380: => per_pml_shd.g_old_rec.uom_code
381: ,p_measure_type_code_o
382: => per_pml_shd.g_old_rec.measure_type_code
383: ,p_measure_comments_o
384: => per_pml_shd.g_old_rec.measure_comments
385: ,p_eligibility_type_code_o
386: => per_pml_shd.g_old_rec.eligibility_type_code
380: => per_pml_shd.g_old_rec.uom_code
381: ,p_measure_type_code_o
382: => per_pml_shd.g_old_rec.measure_type_code
383: ,p_measure_comments_o
384: => per_pml_shd.g_old_rec.measure_comments
385: ,p_eligibility_type_code_o
386: => per_pml_shd.g_old_rec.eligibility_type_code
387: ,p_details_o
388: => per_pml_shd.g_old_rec.details
382: => per_pml_shd.g_old_rec.measure_type_code
383: ,p_measure_comments_o
384: => per_pml_shd.g_old_rec.measure_comments
385: ,p_eligibility_type_code_o
386: => per_pml_shd.g_old_rec.eligibility_type_code
387: ,p_details_o
388: => per_pml_shd.g_old_rec.details
389: ,p_success_criteria_o
390: => per_pml_shd.g_old_rec.success_criteria
384: => per_pml_shd.g_old_rec.measure_comments
385: ,p_eligibility_type_code_o
386: => per_pml_shd.g_old_rec.eligibility_type_code
387: ,p_details_o
388: => per_pml_shd.g_old_rec.details
389: ,p_success_criteria_o
390: => per_pml_shd.g_old_rec.success_criteria
391: ,p_comments_o
392: => per_pml_shd.g_old_rec.comments
386: => per_pml_shd.g_old_rec.eligibility_type_code
387: ,p_details_o
388: => per_pml_shd.g_old_rec.details
389: ,p_success_criteria_o
390: => per_pml_shd.g_old_rec.success_criteria
391: ,p_comments_o
392: => per_pml_shd.g_old_rec.comments
393: ,p_attribute_category_o
394: => per_pml_shd.g_old_rec.attribute_category
388: => per_pml_shd.g_old_rec.details
389: ,p_success_criteria_o
390: => per_pml_shd.g_old_rec.success_criteria
391: ,p_comments_o
392: => per_pml_shd.g_old_rec.comments
393: ,p_attribute_category_o
394: => per_pml_shd.g_old_rec.attribute_category
395: ,p_attribute1_o
396: => per_pml_shd.g_old_rec.attribute1
390: => per_pml_shd.g_old_rec.success_criteria
391: ,p_comments_o
392: => per_pml_shd.g_old_rec.comments
393: ,p_attribute_category_o
394: => per_pml_shd.g_old_rec.attribute_category
395: ,p_attribute1_o
396: => per_pml_shd.g_old_rec.attribute1
397: ,p_attribute2_o
398: => per_pml_shd.g_old_rec.attribute2
392: => per_pml_shd.g_old_rec.comments
393: ,p_attribute_category_o
394: => per_pml_shd.g_old_rec.attribute_category
395: ,p_attribute1_o
396: => per_pml_shd.g_old_rec.attribute1
397: ,p_attribute2_o
398: => per_pml_shd.g_old_rec.attribute2
399: ,p_attribute3_o
400: => per_pml_shd.g_old_rec.attribute3
394: => per_pml_shd.g_old_rec.attribute_category
395: ,p_attribute1_o
396: => per_pml_shd.g_old_rec.attribute1
397: ,p_attribute2_o
398: => per_pml_shd.g_old_rec.attribute2
399: ,p_attribute3_o
400: => per_pml_shd.g_old_rec.attribute3
401: ,p_attribute4_o
402: => per_pml_shd.g_old_rec.attribute4
396: => per_pml_shd.g_old_rec.attribute1
397: ,p_attribute2_o
398: => per_pml_shd.g_old_rec.attribute2
399: ,p_attribute3_o
400: => per_pml_shd.g_old_rec.attribute3
401: ,p_attribute4_o
402: => per_pml_shd.g_old_rec.attribute4
403: ,p_attribute5_o
404: => per_pml_shd.g_old_rec.attribute5
398: => per_pml_shd.g_old_rec.attribute2
399: ,p_attribute3_o
400: => per_pml_shd.g_old_rec.attribute3
401: ,p_attribute4_o
402: => per_pml_shd.g_old_rec.attribute4
403: ,p_attribute5_o
404: => per_pml_shd.g_old_rec.attribute5
405: ,p_attribute6_o
406: => per_pml_shd.g_old_rec.attribute6
400: => per_pml_shd.g_old_rec.attribute3
401: ,p_attribute4_o
402: => per_pml_shd.g_old_rec.attribute4
403: ,p_attribute5_o
404: => per_pml_shd.g_old_rec.attribute5
405: ,p_attribute6_o
406: => per_pml_shd.g_old_rec.attribute6
407: ,p_attribute7_o
408: => per_pml_shd.g_old_rec.attribute7
402: => per_pml_shd.g_old_rec.attribute4
403: ,p_attribute5_o
404: => per_pml_shd.g_old_rec.attribute5
405: ,p_attribute6_o
406: => per_pml_shd.g_old_rec.attribute6
407: ,p_attribute7_o
408: => per_pml_shd.g_old_rec.attribute7
409: ,p_attribute8_o
410: => per_pml_shd.g_old_rec.attribute8
404: => per_pml_shd.g_old_rec.attribute5
405: ,p_attribute6_o
406: => per_pml_shd.g_old_rec.attribute6
407: ,p_attribute7_o
408: => per_pml_shd.g_old_rec.attribute7
409: ,p_attribute8_o
410: => per_pml_shd.g_old_rec.attribute8
411: ,p_attribute9_o
412: => per_pml_shd.g_old_rec.attribute9
406: => per_pml_shd.g_old_rec.attribute6
407: ,p_attribute7_o
408: => per_pml_shd.g_old_rec.attribute7
409: ,p_attribute8_o
410: => per_pml_shd.g_old_rec.attribute8
411: ,p_attribute9_o
412: => per_pml_shd.g_old_rec.attribute9
413: ,p_attribute10_o
414: => per_pml_shd.g_old_rec.attribute10
408: => per_pml_shd.g_old_rec.attribute7
409: ,p_attribute8_o
410: => per_pml_shd.g_old_rec.attribute8
411: ,p_attribute9_o
412: => per_pml_shd.g_old_rec.attribute9
413: ,p_attribute10_o
414: => per_pml_shd.g_old_rec.attribute10
415: ,p_attribute11_o
416: => per_pml_shd.g_old_rec.attribute11
410: => per_pml_shd.g_old_rec.attribute8
411: ,p_attribute9_o
412: => per_pml_shd.g_old_rec.attribute9
413: ,p_attribute10_o
414: => per_pml_shd.g_old_rec.attribute10
415: ,p_attribute11_o
416: => per_pml_shd.g_old_rec.attribute11
417: ,p_attribute12_o
418: => per_pml_shd.g_old_rec.attribute12
412: => per_pml_shd.g_old_rec.attribute9
413: ,p_attribute10_o
414: => per_pml_shd.g_old_rec.attribute10
415: ,p_attribute11_o
416: => per_pml_shd.g_old_rec.attribute11
417: ,p_attribute12_o
418: => per_pml_shd.g_old_rec.attribute12
419: ,p_attribute13_o
420: => per_pml_shd.g_old_rec.attribute13
414: => per_pml_shd.g_old_rec.attribute10
415: ,p_attribute11_o
416: => per_pml_shd.g_old_rec.attribute11
417: ,p_attribute12_o
418: => per_pml_shd.g_old_rec.attribute12
419: ,p_attribute13_o
420: => per_pml_shd.g_old_rec.attribute13
421: ,p_attribute14_o
422: => per_pml_shd.g_old_rec.attribute14
416: => per_pml_shd.g_old_rec.attribute11
417: ,p_attribute12_o
418: => per_pml_shd.g_old_rec.attribute12
419: ,p_attribute13_o
420: => per_pml_shd.g_old_rec.attribute13
421: ,p_attribute14_o
422: => per_pml_shd.g_old_rec.attribute14
423: ,p_attribute15_o
424: => per_pml_shd.g_old_rec.attribute15
418: => per_pml_shd.g_old_rec.attribute12
419: ,p_attribute13_o
420: => per_pml_shd.g_old_rec.attribute13
421: ,p_attribute14_o
422: => per_pml_shd.g_old_rec.attribute14
423: ,p_attribute15_o
424: => per_pml_shd.g_old_rec.attribute15
425: ,p_attribute16_o
426: => per_pml_shd.g_old_rec.attribute16
420: => per_pml_shd.g_old_rec.attribute13
421: ,p_attribute14_o
422: => per_pml_shd.g_old_rec.attribute14
423: ,p_attribute15_o
424: => per_pml_shd.g_old_rec.attribute15
425: ,p_attribute16_o
426: => per_pml_shd.g_old_rec.attribute16
427: ,p_attribute17_o
428: => per_pml_shd.g_old_rec.attribute17
422: => per_pml_shd.g_old_rec.attribute14
423: ,p_attribute15_o
424: => per_pml_shd.g_old_rec.attribute15
425: ,p_attribute16_o
426: => per_pml_shd.g_old_rec.attribute16
427: ,p_attribute17_o
428: => per_pml_shd.g_old_rec.attribute17
429: ,p_attribute18_o
430: => per_pml_shd.g_old_rec.attribute18
424: => per_pml_shd.g_old_rec.attribute15
425: ,p_attribute16_o
426: => per_pml_shd.g_old_rec.attribute16
427: ,p_attribute17_o
428: => per_pml_shd.g_old_rec.attribute17
429: ,p_attribute18_o
430: => per_pml_shd.g_old_rec.attribute18
431: ,p_attribute19_o
432: => per_pml_shd.g_old_rec.attribute19
426: => per_pml_shd.g_old_rec.attribute16
427: ,p_attribute17_o
428: => per_pml_shd.g_old_rec.attribute17
429: ,p_attribute18_o
430: => per_pml_shd.g_old_rec.attribute18
431: ,p_attribute19_o
432: => per_pml_shd.g_old_rec.attribute19
433: ,p_attribute20_o
434: => per_pml_shd.g_old_rec.attribute20
428: => per_pml_shd.g_old_rec.attribute17
429: ,p_attribute18_o
430: => per_pml_shd.g_old_rec.attribute18
431: ,p_attribute19_o
432: => per_pml_shd.g_old_rec.attribute19
433: ,p_attribute20_o
434: => per_pml_shd.g_old_rec.attribute20
435: ,p_attribute21_o
436: => per_pml_shd.g_old_rec.attribute21
430: => per_pml_shd.g_old_rec.attribute18
431: ,p_attribute19_o
432: => per_pml_shd.g_old_rec.attribute19
433: ,p_attribute20_o
434: => per_pml_shd.g_old_rec.attribute20
435: ,p_attribute21_o
436: => per_pml_shd.g_old_rec.attribute21
437: ,p_attribute22_o
438: => per_pml_shd.g_old_rec.attribute22
432: => per_pml_shd.g_old_rec.attribute19
433: ,p_attribute20_o
434: => per_pml_shd.g_old_rec.attribute20
435: ,p_attribute21_o
436: => per_pml_shd.g_old_rec.attribute21
437: ,p_attribute22_o
438: => per_pml_shd.g_old_rec.attribute22
439: ,p_attribute23_o
440: => per_pml_shd.g_old_rec.attribute23
434: => per_pml_shd.g_old_rec.attribute20
435: ,p_attribute21_o
436: => per_pml_shd.g_old_rec.attribute21
437: ,p_attribute22_o
438: => per_pml_shd.g_old_rec.attribute22
439: ,p_attribute23_o
440: => per_pml_shd.g_old_rec.attribute23
441: ,p_attribute24_o
442: => per_pml_shd.g_old_rec.attribute24
436: => per_pml_shd.g_old_rec.attribute21
437: ,p_attribute22_o
438: => per_pml_shd.g_old_rec.attribute22
439: ,p_attribute23_o
440: => per_pml_shd.g_old_rec.attribute23
441: ,p_attribute24_o
442: => per_pml_shd.g_old_rec.attribute24
443: ,p_attribute25_o
444: => per_pml_shd.g_old_rec.attribute25
438: => per_pml_shd.g_old_rec.attribute22
439: ,p_attribute23_o
440: => per_pml_shd.g_old_rec.attribute23
441: ,p_attribute24_o
442: => per_pml_shd.g_old_rec.attribute24
443: ,p_attribute25_o
444: => per_pml_shd.g_old_rec.attribute25
445: ,p_attribute26_o
446: => per_pml_shd.g_old_rec.attribute26
440: => per_pml_shd.g_old_rec.attribute23
441: ,p_attribute24_o
442: => per_pml_shd.g_old_rec.attribute24
443: ,p_attribute25_o
444: => per_pml_shd.g_old_rec.attribute25
445: ,p_attribute26_o
446: => per_pml_shd.g_old_rec.attribute26
447: ,p_attribute27_o
448: => per_pml_shd.g_old_rec.attribute27
442: => per_pml_shd.g_old_rec.attribute24
443: ,p_attribute25_o
444: => per_pml_shd.g_old_rec.attribute25
445: ,p_attribute26_o
446: => per_pml_shd.g_old_rec.attribute26
447: ,p_attribute27_o
448: => per_pml_shd.g_old_rec.attribute27
449: ,p_attribute28_o
450: => per_pml_shd.g_old_rec.attribute28
444: => per_pml_shd.g_old_rec.attribute25
445: ,p_attribute26_o
446: => per_pml_shd.g_old_rec.attribute26
447: ,p_attribute27_o
448: => per_pml_shd.g_old_rec.attribute27
449: ,p_attribute28_o
450: => per_pml_shd.g_old_rec.attribute28
451: ,p_attribute29_o
452: => per_pml_shd.g_old_rec.attribute29
446: => per_pml_shd.g_old_rec.attribute26
447: ,p_attribute27_o
448: => per_pml_shd.g_old_rec.attribute27
449: ,p_attribute28_o
450: => per_pml_shd.g_old_rec.attribute28
451: ,p_attribute29_o
452: => per_pml_shd.g_old_rec.attribute29
453: ,p_attribute30_o
454: => per_pml_shd.g_old_rec.attribute30
448: => per_pml_shd.g_old_rec.attribute27
449: ,p_attribute28_o
450: => per_pml_shd.g_old_rec.attribute28
451: ,p_attribute29_o
452: => per_pml_shd.g_old_rec.attribute29
453: ,p_attribute30_o
454: => per_pml_shd.g_old_rec.attribute30
455: );
456: --
450: => per_pml_shd.g_old_rec.attribute28
451: ,p_attribute29_o
452: => per_pml_shd.g_old_rec.attribute29
453: ,p_attribute30_o
454: => per_pml_shd.g_old_rec.attribute30
455: );
456: --
457: exception
458: --
510: --
511: -- {End Of Comments}
512: -- ----------------------------------------------------------------------------
513: Procedure convert_defs
514: (p_rec in out nocopy per_pml_shd.g_rec_type
515: ) is
516: --
517: Begin
518: --
522: -- is being used then we must set to the 'current' argument value.
523: --
524: If (p_rec.objective_name = hr_api.g_varchar2) then
525: p_rec.objective_name :=
526: per_pml_shd.g_old_rec.objective_name;
527: End If;
528: If (p_rec.valid_from = hr_api.g_date) then
529: p_rec.valid_from :=
530: per_pml_shd.g_old_rec.valid_from;
526: per_pml_shd.g_old_rec.objective_name;
527: End If;
528: If (p_rec.valid_from = hr_api.g_date) then
529: p_rec.valid_from :=
530: per_pml_shd.g_old_rec.valid_from;
531: End If;
532: If (p_rec.valid_to = hr_api.g_date) then
533: p_rec.valid_to :=
534: per_pml_shd.g_old_rec.valid_to;
530: per_pml_shd.g_old_rec.valid_from;
531: End If;
532: If (p_rec.valid_to = hr_api.g_date) then
533: p_rec.valid_to :=
534: per_pml_shd.g_old_rec.valid_to;
535: End If;
536: If (p_rec.target_date = hr_api.g_date) then
537: p_rec.target_date :=
538: per_pml_shd.g_old_rec.target_date;
534: per_pml_shd.g_old_rec.valid_to;
535: End If;
536: If (p_rec.target_date = hr_api.g_date) then
537: p_rec.target_date :=
538: per_pml_shd.g_old_rec.target_date;
539: End If;
540: If (p_rec.next_review_date = hr_api.g_date) then
541: p_rec.next_review_date :=
542: per_pml_shd.g_old_rec.next_review_date;
538: per_pml_shd.g_old_rec.target_date;
539: End If;
540: If (p_rec.next_review_date = hr_api.g_date) then
541: p_rec.next_review_date :=
542: per_pml_shd.g_old_rec.next_review_date;
543: End If;
544: If (p_rec.group_code = hr_api.g_varchar2) then
545: p_rec.group_code :=
546: per_pml_shd.g_old_rec.group_code;
542: per_pml_shd.g_old_rec.next_review_date;
543: End If;
544: If (p_rec.group_code = hr_api.g_varchar2) then
545: p_rec.group_code :=
546: per_pml_shd.g_old_rec.group_code;
547: End If;
548: If (p_rec.priority_code = hr_api.g_varchar2) then
549: p_rec.priority_code :=
550: per_pml_shd.g_old_rec.priority_code;
546: per_pml_shd.g_old_rec.group_code;
547: End If;
548: If (p_rec.priority_code = hr_api.g_varchar2) then
549: p_rec.priority_code :=
550: per_pml_shd.g_old_rec.priority_code;
551: End If;
552: If (p_rec.appraise_flag = hr_api.g_varchar2) then
553: p_rec.appraise_flag :=
554: per_pml_shd.g_old_rec.appraise_flag;
550: per_pml_shd.g_old_rec.priority_code;
551: End If;
552: If (p_rec.appraise_flag = hr_api.g_varchar2) then
553: p_rec.appraise_flag :=
554: per_pml_shd.g_old_rec.appraise_flag;
555: End If;
556: If (p_rec.weighting_percent = hr_api.g_number) then
557: p_rec.weighting_percent :=
558: per_pml_shd.g_old_rec.weighting_percent;
554: per_pml_shd.g_old_rec.appraise_flag;
555: End If;
556: If (p_rec.weighting_percent = hr_api.g_number) then
557: p_rec.weighting_percent :=
558: per_pml_shd.g_old_rec.weighting_percent;
559: End If;
560: If (p_rec.measurement_style_code = hr_api.g_varchar2) then
561: p_rec.measurement_style_code :=
562: per_pml_shd.g_old_rec.measurement_style_code;
558: per_pml_shd.g_old_rec.weighting_percent;
559: End If;
560: If (p_rec.measurement_style_code = hr_api.g_varchar2) then
561: p_rec.measurement_style_code :=
562: per_pml_shd.g_old_rec.measurement_style_code;
563: End If;
564: If (p_rec.measure_name = hr_api.g_varchar2) then
565: p_rec.measure_name :=
566: per_pml_shd.g_old_rec.measure_name;
562: per_pml_shd.g_old_rec.measurement_style_code;
563: End If;
564: If (p_rec.measure_name = hr_api.g_varchar2) then
565: p_rec.measure_name :=
566: per_pml_shd.g_old_rec.measure_name;
567: End If;
568: If (p_rec.target_value = hr_api.g_number) then
569: p_rec.target_value :=
570: per_pml_shd.g_old_rec.target_value;
566: per_pml_shd.g_old_rec.measure_name;
567: End If;
568: If (p_rec.target_value = hr_api.g_number) then
569: p_rec.target_value :=
570: per_pml_shd.g_old_rec.target_value;
571: End If;
572: If (p_rec.uom_code = hr_api.g_varchar2) then
573: p_rec.uom_code :=
574: per_pml_shd.g_old_rec.uom_code;
570: per_pml_shd.g_old_rec.target_value;
571: End If;
572: If (p_rec.uom_code = hr_api.g_varchar2) then
573: p_rec.uom_code :=
574: per_pml_shd.g_old_rec.uom_code;
575: End If;
576: If (p_rec.measure_type_code = hr_api.g_varchar2) then
577: p_rec.measure_type_code :=
578: per_pml_shd.g_old_rec.measure_type_code;
574: per_pml_shd.g_old_rec.uom_code;
575: End If;
576: If (p_rec.measure_type_code = hr_api.g_varchar2) then
577: p_rec.measure_type_code :=
578: per_pml_shd.g_old_rec.measure_type_code;
579: End If;
580: If (p_rec.measure_comments = hr_api.g_varchar2) then
581: p_rec.measure_comments :=
582: per_pml_shd.g_old_rec.measure_comments;
578: per_pml_shd.g_old_rec.measure_type_code;
579: End If;
580: If (p_rec.measure_comments = hr_api.g_varchar2) then
581: p_rec.measure_comments :=
582: per_pml_shd.g_old_rec.measure_comments;
583: End If;
584: If (p_rec.eligibility_type_code = hr_api.g_varchar2) then
585: p_rec.eligibility_type_code :=
586: per_pml_shd.g_old_rec.eligibility_type_code;
582: per_pml_shd.g_old_rec.measure_comments;
583: End If;
584: If (p_rec.eligibility_type_code = hr_api.g_varchar2) then
585: p_rec.eligibility_type_code :=
586: per_pml_shd.g_old_rec.eligibility_type_code;
587: End If;
588: If (p_rec.details = hr_api.g_varchar2) then
589: p_rec.details :=
590: per_pml_shd.g_old_rec.details;
586: per_pml_shd.g_old_rec.eligibility_type_code;
587: End If;
588: If (p_rec.details = hr_api.g_varchar2) then
589: p_rec.details :=
590: per_pml_shd.g_old_rec.details;
591: End If;
592: If (p_rec.success_criteria = hr_api.g_varchar2) then
593: p_rec.success_criteria :=
594: per_pml_shd.g_old_rec.success_criteria;
590: per_pml_shd.g_old_rec.details;
591: End If;
592: If (p_rec.success_criteria = hr_api.g_varchar2) then
593: p_rec.success_criteria :=
594: per_pml_shd.g_old_rec.success_criteria;
595: End If;
596: If (p_rec.comments = hr_api.g_varchar2) then
597: p_rec.comments :=
598: per_pml_shd.g_old_rec.comments;
594: per_pml_shd.g_old_rec.success_criteria;
595: End If;
596: If (p_rec.comments = hr_api.g_varchar2) then
597: p_rec.comments :=
598: per_pml_shd.g_old_rec.comments;
599: End If;
600: If (p_rec.attribute_category = hr_api.g_varchar2) then
601: p_rec.attribute_category :=
602: per_pml_shd.g_old_rec.attribute_category;
598: per_pml_shd.g_old_rec.comments;
599: End If;
600: If (p_rec.attribute_category = hr_api.g_varchar2) then
601: p_rec.attribute_category :=
602: per_pml_shd.g_old_rec.attribute_category;
603: End If;
604: If (p_rec.attribute1 = hr_api.g_varchar2) then
605: p_rec.attribute1 :=
606: per_pml_shd.g_old_rec.attribute1;
602: per_pml_shd.g_old_rec.attribute_category;
603: End If;
604: If (p_rec.attribute1 = hr_api.g_varchar2) then
605: p_rec.attribute1 :=
606: per_pml_shd.g_old_rec.attribute1;
607: End If;
608: If (p_rec.attribute2 = hr_api.g_varchar2) then
609: p_rec.attribute2 :=
610: per_pml_shd.g_old_rec.attribute2;
606: per_pml_shd.g_old_rec.attribute1;
607: End If;
608: If (p_rec.attribute2 = hr_api.g_varchar2) then
609: p_rec.attribute2 :=
610: per_pml_shd.g_old_rec.attribute2;
611: End If;
612: If (p_rec.attribute3 = hr_api.g_varchar2) then
613: p_rec.attribute3 :=
614: per_pml_shd.g_old_rec.attribute3;
610: per_pml_shd.g_old_rec.attribute2;
611: End If;
612: If (p_rec.attribute3 = hr_api.g_varchar2) then
613: p_rec.attribute3 :=
614: per_pml_shd.g_old_rec.attribute3;
615: End If;
616: If (p_rec.attribute4 = hr_api.g_varchar2) then
617: p_rec.attribute4 :=
618: per_pml_shd.g_old_rec.attribute4;
614: per_pml_shd.g_old_rec.attribute3;
615: End If;
616: If (p_rec.attribute4 = hr_api.g_varchar2) then
617: p_rec.attribute4 :=
618: per_pml_shd.g_old_rec.attribute4;
619: End If;
620: If (p_rec.attribute5 = hr_api.g_varchar2) then
621: p_rec.attribute5 :=
622: per_pml_shd.g_old_rec.attribute5;
618: per_pml_shd.g_old_rec.attribute4;
619: End If;
620: If (p_rec.attribute5 = hr_api.g_varchar2) then
621: p_rec.attribute5 :=
622: per_pml_shd.g_old_rec.attribute5;
623: End If;
624: If (p_rec.attribute6 = hr_api.g_varchar2) then
625: p_rec.attribute6 :=
626: per_pml_shd.g_old_rec.attribute6;
622: per_pml_shd.g_old_rec.attribute5;
623: End If;
624: If (p_rec.attribute6 = hr_api.g_varchar2) then
625: p_rec.attribute6 :=
626: per_pml_shd.g_old_rec.attribute6;
627: End If;
628: If (p_rec.attribute7 = hr_api.g_varchar2) then
629: p_rec.attribute7 :=
630: per_pml_shd.g_old_rec.attribute7;
626: per_pml_shd.g_old_rec.attribute6;
627: End If;
628: If (p_rec.attribute7 = hr_api.g_varchar2) then
629: p_rec.attribute7 :=
630: per_pml_shd.g_old_rec.attribute7;
631: End If;
632: If (p_rec.attribute8 = hr_api.g_varchar2) then
633: p_rec.attribute8 :=
634: per_pml_shd.g_old_rec.attribute8;
630: per_pml_shd.g_old_rec.attribute7;
631: End If;
632: If (p_rec.attribute8 = hr_api.g_varchar2) then
633: p_rec.attribute8 :=
634: per_pml_shd.g_old_rec.attribute8;
635: End If;
636: If (p_rec.attribute9 = hr_api.g_varchar2) then
637: p_rec.attribute9 :=
638: per_pml_shd.g_old_rec.attribute9;
634: per_pml_shd.g_old_rec.attribute8;
635: End If;
636: If (p_rec.attribute9 = hr_api.g_varchar2) then
637: p_rec.attribute9 :=
638: per_pml_shd.g_old_rec.attribute9;
639: End If;
640: If (p_rec.attribute10 = hr_api.g_varchar2) then
641: p_rec.attribute10 :=
642: per_pml_shd.g_old_rec.attribute10;
638: per_pml_shd.g_old_rec.attribute9;
639: End If;
640: If (p_rec.attribute10 = hr_api.g_varchar2) then
641: p_rec.attribute10 :=
642: per_pml_shd.g_old_rec.attribute10;
643: End If;
644: If (p_rec.attribute11 = hr_api.g_varchar2) then
645: p_rec.attribute11 :=
646: per_pml_shd.g_old_rec.attribute11;
642: per_pml_shd.g_old_rec.attribute10;
643: End If;
644: If (p_rec.attribute11 = hr_api.g_varchar2) then
645: p_rec.attribute11 :=
646: per_pml_shd.g_old_rec.attribute11;
647: End If;
648: If (p_rec.attribute12 = hr_api.g_varchar2) then
649: p_rec.attribute12 :=
650: per_pml_shd.g_old_rec.attribute12;
646: per_pml_shd.g_old_rec.attribute11;
647: End If;
648: If (p_rec.attribute12 = hr_api.g_varchar2) then
649: p_rec.attribute12 :=
650: per_pml_shd.g_old_rec.attribute12;
651: End If;
652: If (p_rec.attribute13 = hr_api.g_varchar2) then
653: p_rec.attribute13 :=
654: per_pml_shd.g_old_rec.attribute13;
650: per_pml_shd.g_old_rec.attribute12;
651: End If;
652: If (p_rec.attribute13 = hr_api.g_varchar2) then
653: p_rec.attribute13 :=
654: per_pml_shd.g_old_rec.attribute13;
655: End If;
656: If (p_rec.attribute14 = hr_api.g_varchar2) then
657: p_rec.attribute14 :=
658: per_pml_shd.g_old_rec.attribute14;
654: per_pml_shd.g_old_rec.attribute13;
655: End If;
656: If (p_rec.attribute14 = hr_api.g_varchar2) then
657: p_rec.attribute14 :=
658: per_pml_shd.g_old_rec.attribute14;
659: End If;
660: If (p_rec.attribute15 = hr_api.g_varchar2) then
661: p_rec.attribute15 :=
662: per_pml_shd.g_old_rec.attribute15;
658: per_pml_shd.g_old_rec.attribute14;
659: End If;
660: If (p_rec.attribute15 = hr_api.g_varchar2) then
661: p_rec.attribute15 :=
662: per_pml_shd.g_old_rec.attribute15;
663: End If;
664: If (p_rec.attribute16 = hr_api.g_varchar2) then
665: p_rec.attribute16 :=
666: per_pml_shd.g_old_rec.attribute16;
662: per_pml_shd.g_old_rec.attribute15;
663: End If;
664: If (p_rec.attribute16 = hr_api.g_varchar2) then
665: p_rec.attribute16 :=
666: per_pml_shd.g_old_rec.attribute16;
667: End If;
668: If (p_rec.attribute17 = hr_api.g_varchar2) then
669: p_rec.attribute17 :=
670: per_pml_shd.g_old_rec.attribute17;
666: per_pml_shd.g_old_rec.attribute16;
667: End If;
668: If (p_rec.attribute17 = hr_api.g_varchar2) then
669: p_rec.attribute17 :=
670: per_pml_shd.g_old_rec.attribute17;
671: End If;
672: If (p_rec.attribute18 = hr_api.g_varchar2) then
673: p_rec.attribute18 :=
674: per_pml_shd.g_old_rec.attribute18;
670: per_pml_shd.g_old_rec.attribute17;
671: End If;
672: If (p_rec.attribute18 = hr_api.g_varchar2) then
673: p_rec.attribute18 :=
674: per_pml_shd.g_old_rec.attribute18;
675: End If;
676: If (p_rec.attribute19 = hr_api.g_varchar2) then
677: p_rec.attribute19 :=
678: per_pml_shd.g_old_rec.attribute19;
674: per_pml_shd.g_old_rec.attribute18;
675: End If;
676: If (p_rec.attribute19 = hr_api.g_varchar2) then
677: p_rec.attribute19 :=
678: per_pml_shd.g_old_rec.attribute19;
679: End If;
680: If (p_rec.attribute20 = hr_api.g_varchar2) then
681: p_rec.attribute20 :=
682: per_pml_shd.g_old_rec.attribute20;
678: per_pml_shd.g_old_rec.attribute19;
679: End If;
680: If (p_rec.attribute20 = hr_api.g_varchar2) then
681: p_rec.attribute20 :=
682: per_pml_shd.g_old_rec.attribute20;
683: End If;
684: If (p_rec.attribute21 = hr_api.g_varchar2) then
685: p_rec.attribute21 :=
686: per_pml_shd.g_old_rec.attribute21;
682: per_pml_shd.g_old_rec.attribute20;
683: End If;
684: If (p_rec.attribute21 = hr_api.g_varchar2) then
685: p_rec.attribute21 :=
686: per_pml_shd.g_old_rec.attribute21;
687: End If;
688: If (p_rec.attribute22 = hr_api.g_varchar2) then
689: p_rec.attribute22 :=
690: per_pml_shd.g_old_rec.attribute22;
686: per_pml_shd.g_old_rec.attribute21;
687: End If;
688: If (p_rec.attribute22 = hr_api.g_varchar2) then
689: p_rec.attribute22 :=
690: per_pml_shd.g_old_rec.attribute22;
691: End If;
692: If (p_rec.attribute23 = hr_api.g_varchar2) then
693: p_rec.attribute23 :=
694: per_pml_shd.g_old_rec.attribute23;
690: per_pml_shd.g_old_rec.attribute22;
691: End If;
692: If (p_rec.attribute23 = hr_api.g_varchar2) then
693: p_rec.attribute23 :=
694: per_pml_shd.g_old_rec.attribute23;
695: End If;
696: If (p_rec.attribute24 = hr_api.g_varchar2) then
697: p_rec.attribute24 :=
698: per_pml_shd.g_old_rec.attribute24;
694: per_pml_shd.g_old_rec.attribute23;
695: End If;
696: If (p_rec.attribute24 = hr_api.g_varchar2) then
697: p_rec.attribute24 :=
698: per_pml_shd.g_old_rec.attribute24;
699: End If;
700: If (p_rec.attribute25 = hr_api.g_varchar2) then
701: p_rec.attribute25 :=
702: per_pml_shd.g_old_rec.attribute25;
698: per_pml_shd.g_old_rec.attribute24;
699: End If;
700: If (p_rec.attribute25 = hr_api.g_varchar2) then
701: p_rec.attribute25 :=
702: per_pml_shd.g_old_rec.attribute25;
703: End If;
704: If (p_rec.attribute26 = hr_api.g_varchar2) then
705: p_rec.attribute26 :=
706: per_pml_shd.g_old_rec.attribute26;
702: per_pml_shd.g_old_rec.attribute25;
703: End If;
704: If (p_rec.attribute26 = hr_api.g_varchar2) then
705: p_rec.attribute26 :=
706: per_pml_shd.g_old_rec.attribute26;
707: End If;
708: If (p_rec.attribute27 = hr_api.g_varchar2) then
709: p_rec.attribute27 :=
710: per_pml_shd.g_old_rec.attribute27;
706: per_pml_shd.g_old_rec.attribute26;
707: End If;
708: If (p_rec.attribute27 = hr_api.g_varchar2) then
709: p_rec.attribute27 :=
710: per_pml_shd.g_old_rec.attribute27;
711: End If;
712: If (p_rec.attribute28 = hr_api.g_varchar2) then
713: p_rec.attribute28 :=
714: per_pml_shd.g_old_rec.attribute28;
710: per_pml_shd.g_old_rec.attribute27;
711: End If;
712: If (p_rec.attribute28 = hr_api.g_varchar2) then
713: p_rec.attribute28 :=
714: per_pml_shd.g_old_rec.attribute28;
715: End If;
716: If (p_rec.attribute29 = hr_api.g_varchar2) then
717: p_rec.attribute29 :=
718: per_pml_shd.g_old_rec.attribute29;
714: per_pml_shd.g_old_rec.attribute28;
715: End If;
716: If (p_rec.attribute29 = hr_api.g_varchar2) then
717: p_rec.attribute29 :=
718: per_pml_shd.g_old_rec.attribute29;
719: End If;
720: If (p_rec.attribute30 = hr_api.g_varchar2) then
721: p_rec.attribute30 :=
722: per_pml_shd.g_old_rec.attribute30;
718: per_pml_shd.g_old_rec.attribute29;
719: End If;
720: If (p_rec.attribute30 = hr_api.g_varchar2) then
721: p_rec.attribute30 :=
722: per_pml_shd.g_old_rec.attribute30;
723: End If;
724: --
725: End convert_defs;
726: --
728: -- |---------------------------------< upd >----------------------------------|
729: -- ----------------------------------------------------------------------------
730: Procedure upd
731: (p_effective_date in date
732: ,p_rec in out nocopy per_pml_shd.g_rec_type
733: ,p_duplicate_name_warning out nocopy boolean
734: ,p_weighting_over_100_warning out nocopy boolean
735: ,p_weighting_appraisal_warning out nocopy boolean
736: ) is
741: hr_utility.set_location('Entering:'||l_proc, 5);
742: --
743: -- We must lock the row which we need to update.
744: --
745: per_pml_shd.lck
746: (p_rec.objective_id
747: ,p_rec.object_version_number
748: );
749: --
849: ,p_weighting_over_100_warning out nocopy boolean
850: ,p_weighting_appraisal_warning out nocopy boolean
851: ) is
852: --
853: l_rec per_pml_shd.g_rec_type;
854: l_proc varchar2(72) := g_package||'upd';
855: l_duplicate_name_warning boolean;
856: l_weighting_over_100_warning boolean;
857: l_weighting_appraisal_warning boolean;
863: -- Call conversion function to turn arguments into the
864: -- l_rec structure.
865: --
866: l_rec :=
867: per_pml_shd.convert_args
868: (p_objective_id
869: ,p_object_version_number
870: ,p_objective_name
871: ,p_valid_from