[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_pem_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
157: Exception
158: When hr_api.check_integrity_violated Then
159: -- A check constraint has been violated
160: --
161: per_pem_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When hr_api.parent_integrity_violated Then
164: -- Parent integrity has been violated
165: --
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When hr_api.parent_integrity_violated Then
164: -- Parent integrity has been violated
165: --
166: per_pem_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: --
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: --
171: per_pem_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When Others Then
174: --
175: Raise;
207: --
208: -- {End Of Comments}
209: -- ----------------------------------------------------------------------------
210: Procedure pre_update
211: (p_rec in per_pem_shd.g_rec_type
212: ) is
213: --
214: l_proc varchar2(72) := g_package||'pre_update';
215: --
252: -- {End Of Comments}
253: -- ----------------------------------------------------------------------------
254: Procedure post_update
255: (p_effective_date in date
256: ,p_rec in per_pem_shd.g_rec_type
257: ) is
258: --
259: l_proc varchar2(72) := g_package||'post_update';
260: --
422: => p_rec.all_assignments
423: ,p_period_months
424: => p_rec.period_months
425: ,p_business_group_id_o
426: => per_pem_shd.g_old_rec.business_group_id
427: ,p_person_id_o
428: => per_pem_shd.g_old_rec.person_id
429: ,p_party_id_o
430: => per_pem_shd.g_old_rec.party_id
424: => p_rec.period_months
425: ,p_business_group_id_o
426: => per_pem_shd.g_old_rec.business_group_id
427: ,p_person_id_o
428: => per_pem_shd.g_old_rec.person_id
429: ,p_party_id_o
430: => per_pem_shd.g_old_rec.party_id
431: ,p_start_date_o
432: => per_pem_shd.g_old_rec.start_date
426: => per_pem_shd.g_old_rec.business_group_id
427: ,p_person_id_o
428: => per_pem_shd.g_old_rec.person_id
429: ,p_party_id_o
430: => per_pem_shd.g_old_rec.party_id
431: ,p_start_date_o
432: => per_pem_shd.g_old_rec.start_date
433: ,p_end_date_o
434: => per_pem_shd.g_old_rec.end_date
428: => per_pem_shd.g_old_rec.person_id
429: ,p_party_id_o
430: => per_pem_shd.g_old_rec.party_id
431: ,p_start_date_o
432: => per_pem_shd.g_old_rec.start_date
433: ,p_end_date_o
434: => per_pem_shd.g_old_rec.end_date
435: ,p_period_years_o
436: => per_pem_shd.g_old_rec.period_years
430: => per_pem_shd.g_old_rec.party_id
431: ,p_start_date_o
432: => per_pem_shd.g_old_rec.start_date
433: ,p_end_date_o
434: => per_pem_shd.g_old_rec.end_date
435: ,p_period_years_o
436: => per_pem_shd.g_old_rec.period_years
437: ,p_period_days_o
438: => per_pem_shd.g_old_rec.period_days
432: => per_pem_shd.g_old_rec.start_date
433: ,p_end_date_o
434: => per_pem_shd.g_old_rec.end_date
435: ,p_period_years_o
436: => per_pem_shd.g_old_rec.period_years
437: ,p_period_days_o
438: => per_pem_shd.g_old_rec.period_days
439: ,p_employer_name_o
440: => per_pem_shd.g_old_rec.employer_name
434: => per_pem_shd.g_old_rec.end_date
435: ,p_period_years_o
436: => per_pem_shd.g_old_rec.period_years
437: ,p_period_days_o
438: => per_pem_shd.g_old_rec.period_days
439: ,p_employer_name_o
440: => per_pem_shd.g_old_rec.employer_name
441: ,p_employer_country_o
442: => per_pem_shd.g_old_rec.employer_country
436: => per_pem_shd.g_old_rec.period_years
437: ,p_period_days_o
438: => per_pem_shd.g_old_rec.period_days
439: ,p_employer_name_o
440: => per_pem_shd.g_old_rec.employer_name
441: ,p_employer_country_o
442: => per_pem_shd.g_old_rec.employer_country
443: ,p_employer_address_o
444: => per_pem_shd.g_old_rec.employer_address
438: => per_pem_shd.g_old_rec.period_days
439: ,p_employer_name_o
440: => per_pem_shd.g_old_rec.employer_name
441: ,p_employer_country_o
442: => per_pem_shd.g_old_rec.employer_country
443: ,p_employer_address_o
444: => per_pem_shd.g_old_rec.employer_address
445: ,p_employer_type_o
446: => per_pem_shd.g_old_rec.employer_type
440: => per_pem_shd.g_old_rec.employer_name
441: ,p_employer_country_o
442: => per_pem_shd.g_old_rec.employer_country
443: ,p_employer_address_o
444: => per_pem_shd.g_old_rec.employer_address
445: ,p_employer_type_o
446: => per_pem_shd.g_old_rec.employer_type
447: ,p_employer_subtype_o
448: => per_pem_shd.g_old_rec.employer_subtype
442: => per_pem_shd.g_old_rec.employer_country
443: ,p_employer_address_o
444: => per_pem_shd.g_old_rec.employer_address
445: ,p_employer_type_o
446: => per_pem_shd.g_old_rec.employer_type
447: ,p_employer_subtype_o
448: => per_pem_shd.g_old_rec.employer_subtype
449: ,p_description_o
450: => per_pem_shd.g_old_rec.description
444: => per_pem_shd.g_old_rec.employer_address
445: ,p_employer_type_o
446: => per_pem_shd.g_old_rec.employer_type
447: ,p_employer_subtype_o
448: => per_pem_shd.g_old_rec.employer_subtype
449: ,p_description_o
450: => per_pem_shd.g_old_rec.description
451: ,p_pem_attribute_category_o
452: => per_pem_shd.g_old_rec.pem_attribute_category
446: => per_pem_shd.g_old_rec.employer_type
447: ,p_employer_subtype_o
448: => per_pem_shd.g_old_rec.employer_subtype
449: ,p_description_o
450: => per_pem_shd.g_old_rec.description
451: ,p_pem_attribute_category_o
452: => per_pem_shd.g_old_rec.pem_attribute_category
453: ,p_pem_attribute1_o
454: => per_pem_shd.g_old_rec.pem_attribute1
448: => per_pem_shd.g_old_rec.employer_subtype
449: ,p_description_o
450: => per_pem_shd.g_old_rec.description
451: ,p_pem_attribute_category_o
452: => per_pem_shd.g_old_rec.pem_attribute_category
453: ,p_pem_attribute1_o
454: => per_pem_shd.g_old_rec.pem_attribute1
455: ,p_pem_attribute2_o
456: => per_pem_shd.g_old_rec.pem_attribute2
450: => per_pem_shd.g_old_rec.description
451: ,p_pem_attribute_category_o
452: => per_pem_shd.g_old_rec.pem_attribute_category
453: ,p_pem_attribute1_o
454: => per_pem_shd.g_old_rec.pem_attribute1
455: ,p_pem_attribute2_o
456: => per_pem_shd.g_old_rec.pem_attribute2
457: ,p_pem_attribute3_o
458: => per_pem_shd.g_old_rec.pem_attribute3
452: => per_pem_shd.g_old_rec.pem_attribute_category
453: ,p_pem_attribute1_o
454: => per_pem_shd.g_old_rec.pem_attribute1
455: ,p_pem_attribute2_o
456: => per_pem_shd.g_old_rec.pem_attribute2
457: ,p_pem_attribute3_o
458: => per_pem_shd.g_old_rec.pem_attribute3
459: ,p_pem_attribute4_o
460: => per_pem_shd.g_old_rec.pem_attribute4
454: => per_pem_shd.g_old_rec.pem_attribute1
455: ,p_pem_attribute2_o
456: => per_pem_shd.g_old_rec.pem_attribute2
457: ,p_pem_attribute3_o
458: => per_pem_shd.g_old_rec.pem_attribute3
459: ,p_pem_attribute4_o
460: => per_pem_shd.g_old_rec.pem_attribute4
461: ,p_pem_attribute5_o
462: => per_pem_shd.g_old_rec.pem_attribute5
456: => per_pem_shd.g_old_rec.pem_attribute2
457: ,p_pem_attribute3_o
458: => per_pem_shd.g_old_rec.pem_attribute3
459: ,p_pem_attribute4_o
460: => per_pem_shd.g_old_rec.pem_attribute4
461: ,p_pem_attribute5_o
462: => per_pem_shd.g_old_rec.pem_attribute5
463: ,p_pem_attribute6_o
464: => per_pem_shd.g_old_rec.pem_attribute6
458: => per_pem_shd.g_old_rec.pem_attribute3
459: ,p_pem_attribute4_o
460: => per_pem_shd.g_old_rec.pem_attribute4
461: ,p_pem_attribute5_o
462: => per_pem_shd.g_old_rec.pem_attribute5
463: ,p_pem_attribute6_o
464: => per_pem_shd.g_old_rec.pem_attribute6
465: ,p_pem_attribute7_o
466: => per_pem_shd.g_old_rec.pem_attribute7
460: => per_pem_shd.g_old_rec.pem_attribute4
461: ,p_pem_attribute5_o
462: => per_pem_shd.g_old_rec.pem_attribute5
463: ,p_pem_attribute6_o
464: => per_pem_shd.g_old_rec.pem_attribute6
465: ,p_pem_attribute7_o
466: => per_pem_shd.g_old_rec.pem_attribute7
467: ,p_pem_attribute8_o
468: => per_pem_shd.g_old_rec.pem_attribute8
462: => per_pem_shd.g_old_rec.pem_attribute5
463: ,p_pem_attribute6_o
464: => per_pem_shd.g_old_rec.pem_attribute6
465: ,p_pem_attribute7_o
466: => per_pem_shd.g_old_rec.pem_attribute7
467: ,p_pem_attribute8_o
468: => per_pem_shd.g_old_rec.pem_attribute8
469: ,p_pem_attribute9_o
470: => per_pem_shd.g_old_rec.pem_attribute9
464: => per_pem_shd.g_old_rec.pem_attribute6
465: ,p_pem_attribute7_o
466: => per_pem_shd.g_old_rec.pem_attribute7
467: ,p_pem_attribute8_o
468: => per_pem_shd.g_old_rec.pem_attribute8
469: ,p_pem_attribute9_o
470: => per_pem_shd.g_old_rec.pem_attribute9
471: ,p_pem_attribute10_o
472: => per_pem_shd.g_old_rec.pem_attribute10
466: => per_pem_shd.g_old_rec.pem_attribute7
467: ,p_pem_attribute8_o
468: => per_pem_shd.g_old_rec.pem_attribute8
469: ,p_pem_attribute9_o
470: => per_pem_shd.g_old_rec.pem_attribute9
471: ,p_pem_attribute10_o
472: => per_pem_shd.g_old_rec.pem_attribute10
473: ,p_pem_attribute11_o
474: => per_pem_shd.g_old_rec.pem_attribute11
468: => per_pem_shd.g_old_rec.pem_attribute8
469: ,p_pem_attribute9_o
470: => per_pem_shd.g_old_rec.pem_attribute9
471: ,p_pem_attribute10_o
472: => per_pem_shd.g_old_rec.pem_attribute10
473: ,p_pem_attribute11_o
474: => per_pem_shd.g_old_rec.pem_attribute11
475: ,p_pem_attribute12_o
476: => per_pem_shd.g_old_rec.pem_attribute12
470: => per_pem_shd.g_old_rec.pem_attribute9
471: ,p_pem_attribute10_o
472: => per_pem_shd.g_old_rec.pem_attribute10
473: ,p_pem_attribute11_o
474: => per_pem_shd.g_old_rec.pem_attribute11
475: ,p_pem_attribute12_o
476: => per_pem_shd.g_old_rec.pem_attribute12
477: ,p_pem_attribute13_o
478: => per_pem_shd.g_old_rec.pem_attribute13
472: => per_pem_shd.g_old_rec.pem_attribute10
473: ,p_pem_attribute11_o
474: => per_pem_shd.g_old_rec.pem_attribute11
475: ,p_pem_attribute12_o
476: => per_pem_shd.g_old_rec.pem_attribute12
477: ,p_pem_attribute13_o
478: => per_pem_shd.g_old_rec.pem_attribute13
479: ,p_pem_attribute14_o
480: => per_pem_shd.g_old_rec.pem_attribute14
474: => per_pem_shd.g_old_rec.pem_attribute11
475: ,p_pem_attribute12_o
476: => per_pem_shd.g_old_rec.pem_attribute12
477: ,p_pem_attribute13_o
478: => per_pem_shd.g_old_rec.pem_attribute13
479: ,p_pem_attribute14_o
480: => per_pem_shd.g_old_rec.pem_attribute14
481: ,p_pem_attribute15_o
482: => per_pem_shd.g_old_rec.pem_attribute15
476: => per_pem_shd.g_old_rec.pem_attribute12
477: ,p_pem_attribute13_o
478: => per_pem_shd.g_old_rec.pem_attribute13
479: ,p_pem_attribute14_o
480: => per_pem_shd.g_old_rec.pem_attribute14
481: ,p_pem_attribute15_o
482: => per_pem_shd.g_old_rec.pem_attribute15
483: ,p_pem_attribute16_o
484: => per_pem_shd.g_old_rec.pem_attribute16
478: => per_pem_shd.g_old_rec.pem_attribute13
479: ,p_pem_attribute14_o
480: => per_pem_shd.g_old_rec.pem_attribute14
481: ,p_pem_attribute15_o
482: => per_pem_shd.g_old_rec.pem_attribute15
483: ,p_pem_attribute16_o
484: => per_pem_shd.g_old_rec.pem_attribute16
485: ,p_pem_attribute17_o
486: => per_pem_shd.g_old_rec.pem_attribute17
480: => per_pem_shd.g_old_rec.pem_attribute14
481: ,p_pem_attribute15_o
482: => per_pem_shd.g_old_rec.pem_attribute15
483: ,p_pem_attribute16_o
484: => per_pem_shd.g_old_rec.pem_attribute16
485: ,p_pem_attribute17_o
486: => per_pem_shd.g_old_rec.pem_attribute17
487: ,p_pem_attribute18_o
488: => per_pem_shd.g_old_rec.pem_attribute18
482: => per_pem_shd.g_old_rec.pem_attribute15
483: ,p_pem_attribute16_o
484: => per_pem_shd.g_old_rec.pem_attribute16
485: ,p_pem_attribute17_o
486: => per_pem_shd.g_old_rec.pem_attribute17
487: ,p_pem_attribute18_o
488: => per_pem_shd.g_old_rec.pem_attribute18
489: ,p_pem_attribute19_o
490: => per_pem_shd.g_old_rec.pem_attribute19
484: => per_pem_shd.g_old_rec.pem_attribute16
485: ,p_pem_attribute17_o
486: => per_pem_shd.g_old_rec.pem_attribute17
487: ,p_pem_attribute18_o
488: => per_pem_shd.g_old_rec.pem_attribute18
489: ,p_pem_attribute19_o
490: => per_pem_shd.g_old_rec.pem_attribute19
491: ,p_pem_attribute20_o
492: => per_pem_shd.g_old_rec.pem_attribute20
486: => per_pem_shd.g_old_rec.pem_attribute17
487: ,p_pem_attribute18_o
488: => per_pem_shd.g_old_rec.pem_attribute18
489: ,p_pem_attribute19_o
490: => per_pem_shd.g_old_rec.pem_attribute19
491: ,p_pem_attribute20_o
492: => per_pem_shd.g_old_rec.pem_attribute20
493: ,p_pem_attribute21_o
494: => per_pem_shd.g_old_rec.pem_attribute21
488: => per_pem_shd.g_old_rec.pem_attribute18
489: ,p_pem_attribute19_o
490: => per_pem_shd.g_old_rec.pem_attribute19
491: ,p_pem_attribute20_o
492: => per_pem_shd.g_old_rec.pem_attribute20
493: ,p_pem_attribute21_o
494: => per_pem_shd.g_old_rec.pem_attribute21
495: ,p_pem_attribute22_o
496: => per_pem_shd.g_old_rec.pem_attribute22
490: => per_pem_shd.g_old_rec.pem_attribute19
491: ,p_pem_attribute20_o
492: => per_pem_shd.g_old_rec.pem_attribute20
493: ,p_pem_attribute21_o
494: => per_pem_shd.g_old_rec.pem_attribute21
495: ,p_pem_attribute22_o
496: => per_pem_shd.g_old_rec.pem_attribute22
497: ,p_pem_attribute23_o
498: => per_pem_shd.g_old_rec.pem_attribute23
492: => per_pem_shd.g_old_rec.pem_attribute20
493: ,p_pem_attribute21_o
494: => per_pem_shd.g_old_rec.pem_attribute21
495: ,p_pem_attribute22_o
496: => per_pem_shd.g_old_rec.pem_attribute22
497: ,p_pem_attribute23_o
498: => per_pem_shd.g_old_rec.pem_attribute23
499: ,p_pem_attribute24_o
500: => per_pem_shd.g_old_rec.pem_attribute24
494: => per_pem_shd.g_old_rec.pem_attribute21
495: ,p_pem_attribute22_o
496: => per_pem_shd.g_old_rec.pem_attribute22
497: ,p_pem_attribute23_o
498: => per_pem_shd.g_old_rec.pem_attribute23
499: ,p_pem_attribute24_o
500: => per_pem_shd.g_old_rec.pem_attribute24
501: ,p_pem_attribute25_o
502: => per_pem_shd.g_old_rec.pem_attribute25
496: => per_pem_shd.g_old_rec.pem_attribute22
497: ,p_pem_attribute23_o
498: => per_pem_shd.g_old_rec.pem_attribute23
499: ,p_pem_attribute24_o
500: => per_pem_shd.g_old_rec.pem_attribute24
501: ,p_pem_attribute25_o
502: => per_pem_shd.g_old_rec.pem_attribute25
503: ,p_pem_attribute26_o
504: => per_pem_shd.g_old_rec.pem_attribute26
498: => per_pem_shd.g_old_rec.pem_attribute23
499: ,p_pem_attribute24_o
500: => per_pem_shd.g_old_rec.pem_attribute24
501: ,p_pem_attribute25_o
502: => per_pem_shd.g_old_rec.pem_attribute25
503: ,p_pem_attribute26_o
504: => per_pem_shd.g_old_rec.pem_attribute26
505: ,p_pem_attribute27_o
506: => per_pem_shd.g_old_rec.pem_attribute27
500: => per_pem_shd.g_old_rec.pem_attribute24
501: ,p_pem_attribute25_o
502: => per_pem_shd.g_old_rec.pem_attribute25
503: ,p_pem_attribute26_o
504: => per_pem_shd.g_old_rec.pem_attribute26
505: ,p_pem_attribute27_o
506: => per_pem_shd.g_old_rec.pem_attribute27
507: ,p_pem_attribute28_o
508: => per_pem_shd.g_old_rec.pem_attribute28
502: => per_pem_shd.g_old_rec.pem_attribute25
503: ,p_pem_attribute26_o
504: => per_pem_shd.g_old_rec.pem_attribute26
505: ,p_pem_attribute27_o
506: => per_pem_shd.g_old_rec.pem_attribute27
507: ,p_pem_attribute28_o
508: => per_pem_shd.g_old_rec.pem_attribute28
509: ,p_pem_attribute29_o
510: => per_pem_shd.g_old_rec.pem_attribute29
504: => per_pem_shd.g_old_rec.pem_attribute26
505: ,p_pem_attribute27_o
506: => per_pem_shd.g_old_rec.pem_attribute27
507: ,p_pem_attribute28_o
508: => per_pem_shd.g_old_rec.pem_attribute28
509: ,p_pem_attribute29_o
510: => per_pem_shd.g_old_rec.pem_attribute29
511: ,p_pem_attribute30_o
512: => per_pem_shd.g_old_rec.pem_attribute30
506: => per_pem_shd.g_old_rec.pem_attribute27
507: ,p_pem_attribute28_o
508: => per_pem_shd.g_old_rec.pem_attribute28
509: ,p_pem_attribute29_o
510: => per_pem_shd.g_old_rec.pem_attribute29
511: ,p_pem_attribute30_o
512: => per_pem_shd.g_old_rec.pem_attribute30
513: ,p_pem_information_category_o
514: => per_pem_shd.g_old_rec.pem_information_category
508: => per_pem_shd.g_old_rec.pem_attribute28
509: ,p_pem_attribute29_o
510: => per_pem_shd.g_old_rec.pem_attribute29
511: ,p_pem_attribute30_o
512: => per_pem_shd.g_old_rec.pem_attribute30
513: ,p_pem_information_category_o
514: => per_pem_shd.g_old_rec.pem_information_category
515: ,p_pem_information1_o
516: => per_pem_shd.g_old_rec.pem_information1
510: => per_pem_shd.g_old_rec.pem_attribute29
511: ,p_pem_attribute30_o
512: => per_pem_shd.g_old_rec.pem_attribute30
513: ,p_pem_information_category_o
514: => per_pem_shd.g_old_rec.pem_information_category
515: ,p_pem_information1_o
516: => per_pem_shd.g_old_rec.pem_information1
517: ,p_pem_information2_o
518: => per_pem_shd.g_old_rec.pem_information2
512: => per_pem_shd.g_old_rec.pem_attribute30
513: ,p_pem_information_category_o
514: => per_pem_shd.g_old_rec.pem_information_category
515: ,p_pem_information1_o
516: => per_pem_shd.g_old_rec.pem_information1
517: ,p_pem_information2_o
518: => per_pem_shd.g_old_rec.pem_information2
519: ,p_pem_information3_o
520: => per_pem_shd.g_old_rec.pem_information3
514: => per_pem_shd.g_old_rec.pem_information_category
515: ,p_pem_information1_o
516: => per_pem_shd.g_old_rec.pem_information1
517: ,p_pem_information2_o
518: => per_pem_shd.g_old_rec.pem_information2
519: ,p_pem_information3_o
520: => per_pem_shd.g_old_rec.pem_information3
521: ,p_pem_information4_o
522: => per_pem_shd.g_old_rec.pem_information4
516: => per_pem_shd.g_old_rec.pem_information1
517: ,p_pem_information2_o
518: => per_pem_shd.g_old_rec.pem_information2
519: ,p_pem_information3_o
520: => per_pem_shd.g_old_rec.pem_information3
521: ,p_pem_information4_o
522: => per_pem_shd.g_old_rec.pem_information4
523: ,p_pem_information5_o
524: => per_pem_shd.g_old_rec.pem_information5
518: => per_pem_shd.g_old_rec.pem_information2
519: ,p_pem_information3_o
520: => per_pem_shd.g_old_rec.pem_information3
521: ,p_pem_information4_o
522: => per_pem_shd.g_old_rec.pem_information4
523: ,p_pem_information5_o
524: => per_pem_shd.g_old_rec.pem_information5
525: ,p_pem_information6_o
526: => per_pem_shd.g_old_rec.pem_information6
520: => per_pem_shd.g_old_rec.pem_information3
521: ,p_pem_information4_o
522: => per_pem_shd.g_old_rec.pem_information4
523: ,p_pem_information5_o
524: => per_pem_shd.g_old_rec.pem_information5
525: ,p_pem_information6_o
526: => per_pem_shd.g_old_rec.pem_information6
527: ,p_pem_information7_o
528: => per_pem_shd.g_old_rec.pem_information7
522: => per_pem_shd.g_old_rec.pem_information4
523: ,p_pem_information5_o
524: => per_pem_shd.g_old_rec.pem_information5
525: ,p_pem_information6_o
526: => per_pem_shd.g_old_rec.pem_information6
527: ,p_pem_information7_o
528: => per_pem_shd.g_old_rec.pem_information7
529: ,p_pem_information8_o
530: => per_pem_shd.g_old_rec.pem_information8
524: => per_pem_shd.g_old_rec.pem_information5
525: ,p_pem_information6_o
526: => per_pem_shd.g_old_rec.pem_information6
527: ,p_pem_information7_o
528: => per_pem_shd.g_old_rec.pem_information7
529: ,p_pem_information8_o
530: => per_pem_shd.g_old_rec.pem_information8
531: ,p_pem_information9_o
532: => per_pem_shd.g_old_rec.pem_information9
526: => per_pem_shd.g_old_rec.pem_information6
527: ,p_pem_information7_o
528: => per_pem_shd.g_old_rec.pem_information7
529: ,p_pem_information8_o
530: => per_pem_shd.g_old_rec.pem_information8
531: ,p_pem_information9_o
532: => per_pem_shd.g_old_rec.pem_information9
533: ,p_pem_information10_o
534: => per_pem_shd.g_old_rec.pem_information10
528: => per_pem_shd.g_old_rec.pem_information7
529: ,p_pem_information8_o
530: => per_pem_shd.g_old_rec.pem_information8
531: ,p_pem_information9_o
532: => per_pem_shd.g_old_rec.pem_information9
533: ,p_pem_information10_o
534: => per_pem_shd.g_old_rec.pem_information10
535: ,p_pem_information11_o
536: => per_pem_shd.g_old_rec.pem_information11
530: => per_pem_shd.g_old_rec.pem_information8
531: ,p_pem_information9_o
532: => per_pem_shd.g_old_rec.pem_information9
533: ,p_pem_information10_o
534: => per_pem_shd.g_old_rec.pem_information10
535: ,p_pem_information11_o
536: => per_pem_shd.g_old_rec.pem_information11
537: ,p_pem_information12_o
538: => per_pem_shd.g_old_rec.pem_information12
532: => per_pem_shd.g_old_rec.pem_information9
533: ,p_pem_information10_o
534: => per_pem_shd.g_old_rec.pem_information10
535: ,p_pem_information11_o
536: => per_pem_shd.g_old_rec.pem_information11
537: ,p_pem_information12_o
538: => per_pem_shd.g_old_rec.pem_information12
539: ,p_pem_information13_o
540: => per_pem_shd.g_old_rec.pem_information13
534: => per_pem_shd.g_old_rec.pem_information10
535: ,p_pem_information11_o
536: => per_pem_shd.g_old_rec.pem_information11
537: ,p_pem_information12_o
538: => per_pem_shd.g_old_rec.pem_information12
539: ,p_pem_information13_o
540: => per_pem_shd.g_old_rec.pem_information13
541: ,p_pem_information14_o
542: => per_pem_shd.g_old_rec.pem_information14
536: => per_pem_shd.g_old_rec.pem_information11
537: ,p_pem_information12_o
538: => per_pem_shd.g_old_rec.pem_information12
539: ,p_pem_information13_o
540: => per_pem_shd.g_old_rec.pem_information13
541: ,p_pem_information14_o
542: => per_pem_shd.g_old_rec.pem_information14
543: ,p_pem_information15_o
544: => per_pem_shd.g_old_rec.pem_information15
538: => per_pem_shd.g_old_rec.pem_information12
539: ,p_pem_information13_o
540: => per_pem_shd.g_old_rec.pem_information13
541: ,p_pem_information14_o
542: => per_pem_shd.g_old_rec.pem_information14
543: ,p_pem_information15_o
544: => per_pem_shd.g_old_rec.pem_information15
545: ,p_pem_information16_o
546: => per_pem_shd.g_old_rec.pem_information16
540: => per_pem_shd.g_old_rec.pem_information13
541: ,p_pem_information14_o
542: => per_pem_shd.g_old_rec.pem_information14
543: ,p_pem_information15_o
544: => per_pem_shd.g_old_rec.pem_information15
545: ,p_pem_information16_o
546: => per_pem_shd.g_old_rec.pem_information16
547: ,p_pem_information17_o
548: => per_pem_shd.g_old_rec.pem_information17
542: => per_pem_shd.g_old_rec.pem_information14
543: ,p_pem_information15_o
544: => per_pem_shd.g_old_rec.pem_information15
545: ,p_pem_information16_o
546: => per_pem_shd.g_old_rec.pem_information16
547: ,p_pem_information17_o
548: => per_pem_shd.g_old_rec.pem_information17
549: ,p_pem_information18_o
550: => per_pem_shd.g_old_rec.pem_information18
544: => per_pem_shd.g_old_rec.pem_information15
545: ,p_pem_information16_o
546: => per_pem_shd.g_old_rec.pem_information16
547: ,p_pem_information17_o
548: => per_pem_shd.g_old_rec.pem_information17
549: ,p_pem_information18_o
550: => per_pem_shd.g_old_rec.pem_information18
551: ,p_pem_information19_o
552: => per_pem_shd.g_old_rec.pem_information19
546: => per_pem_shd.g_old_rec.pem_information16
547: ,p_pem_information17_o
548: => per_pem_shd.g_old_rec.pem_information17
549: ,p_pem_information18_o
550: => per_pem_shd.g_old_rec.pem_information18
551: ,p_pem_information19_o
552: => per_pem_shd.g_old_rec.pem_information19
553: ,p_pem_information20_o
554: => per_pem_shd.g_old_rec.pem_information20
548: => per_pem_shd.g_old_rec.pem_information17
549: ,p_pem_information18_o
550: => per_pem_shd.g_old_rec.pem_information18
551: ,p_pem_information19_o
552: => per_pem_shd.g_old_rec.pem_information19
553: ,p_pem_information20_o
554: => per_pem_shd.g_old_rec.pem_information20
555: ,p_pem_information21_o
556: => per_pem_shd.g_old_rec.pem_information21
550: => per_pem_shd.g_old_rec.pem_information18
551: ,p_pem_information19_o
552: => per_pem_shd.g_old_rec.pem_information19
553: ,p_pem_information20_o
554: => per_pem_shd.g_old_rec.pem_information20
555: ,p_pem_information21_o
556: => per_pem_shd.g_old_rec.pem_information21
557: ,p_pem_information22_o
558: => per_pem_shd.g_old_rec.pem_information22
552: => per_pem_shd.g_old_rec.pem_information19
553: ,p_pem_information20_o
554: => per_pem_shd.g_old_rec.pem_information20
555: ,p_pem_information21_o
556: => per_pem_shd.g_old_rec.pem_information21
557: ,p_pem_information22_o
558: => per_pem_shd.g_old_rec.pem_information22
559: ,p_pem_information23_o
560: => per_pem_shd.g_old_rec.pem_information23
554: => per_pem_shd.g_old_rec.pem_information20
555: ,p_pem_information21_o
556: => per_pem_shd.g_old_rec.pem_information21
557: ,p_pem_information22_o
558: => per_pem_shd.g_old_rec.pem_information22
559: ,p_pem_information23_o
560: => per_pem_shd.g_old_rec.pem_information23
561: ,p_pem_information24_o
562: => per_pem_shd.g_old_rec.pem_information24
556: => per_pem_shd.g_old_rec.pem_information21
557: ,p_pem_information22_o
558: => per_pem_shd.g_old_rec.pem_information22
559: ,p_pem_information23_o
560: => per_pem_shd.g_old_rec.pem_information23
561: ,p_pem_information24_o
562: => per_pem_shd.g_old_rec.pem_information24
563: ,p_pem_information25_o
564: => per_pem_shd.g_old_rec.pem_information25
558: => per_pem_shd.g_old_rec.pem_information22
559: ,p_pem_information23_o
560: => per_pem_shd.g_old_rec.pem_information23
561: ,p_pem_information24_o
562: => per_pem_shd.g_old_rec.pem_information24
563: ,p_pem_information25_o
564: => per_pem_shd.g_old_rec.pem_information25
565: ,p_pem_information26_o
566: => per_pem_shd.g_old_rec.pem_information26
560: => per_pem_shd.g_old_rec.pem_information23
561: ,p_pem_information24_o
562: => per_pem_shd.g_old_rec.pem_information24
563: ,p_pem_information25_o
564: => per_pem_shd.g_old_rec.pem_information25
565: ,p_pem_information26_o
566: => per_pem_shd.g_old_rec.pem_information26
567: ,p_pem_information27_o
568: => per_pem_shd.g_old_rec.pem_information27
562: => per_pem_shd.g_old_rec.pem_information24
563: ,p_pem_information25_o
564: => per_pem_shd.g_old_rec.pem_information25
565: ,p_pem_information26_o
566: => per_pem_shd.g_old_rec.pem_information26
567: ,p_pem_information27_o
568: => per_pem_shd.g_old_rec.pem_information27
569: ,p_pem_information28_o
570: => per_pem_shd.g_old_rec.pem_information28
564: => per_pem_shd.g_old_rec.pem_information25
565: ,p_pem_information26_o
566: => per_pem_shd.g_old_rec.pem_information26
567: ,p_pem_information27_o
568: => per_pem_shd.g_old_rec.pem_information27
569: ,p_pem_information28_o
570: => per_pem_shd.g_old_rec.pem_information28
571: ,p_pem_information29_o
572: => per_pem_shd.g_old_rec.pem_information29
566: => per_pem_shd.g_old_rec.pem_information26
567: ,p_pem_information27_o
568: => per_pem_shd.g_old_rec.pem_information27
569: ,p_pem_information28_o
570: => per_pem_shd.g_old_rec.pem_information28
571: ,p_pem_information29_o
572: => per_pem_shd.g_old_rec.pem_information29
573: ,p_pem_information30_o
574: => per_pem_shd.g_old_rec.pem_information30
568: => per_pem_shd.g_old_rec.pem_information27
569: ,p_pem_information28_o
570: => per_pem_shd.g_old_rec.pem_information28
571: ,p_pem_information29_o
572: => per_pem_shd.g_old_rec.pem_information29
573: ,p_pem_information30_o
574: => per_pem_shd.g_old_rec.pem_information30
575: ,p_object_version_number_o
576: => per_pem_shd.g_old_rec.object_version_number
570: => per_pem_shd.g_old_rec.pem_information28
571: ,p_pem_information29_o
572: => per_pem_shd.g_old_rec.pem_information29
573: ,p_pem_information30_o
574: => per_pem_shd.g_old_rec.pem_information30
575: ,p_object_version_number_o
576: => per_pem_shd.g_old_rec.object_version_number
577: ,p_all_assignments_o
578: => per_pem_shd.g_old_rec.all_assignments
572: => per_pem_shd.g_old_rec.pem_information29
573: ,p_pem_information30_o
574: => per_pem_shd.g_old_rec.pem_information30
575: ,p_object_version_number_o
576: => per_pem_shd.g_old_rec.object_version_number
577: ,p_all_assignments_o
578: => per_pem_shd.g_old_rec.all_assignments
579: ,p_period_months_o
580: => per_pem_shd.g_old_rec.period_months
574: => per_pem_shd.g_old_rec.pem_information30
575: ,p_object_version_number_o
576: => per_pem_shd.g_old_rec.object_version_number
577: ,p_all_assignments_o
578: => per_pem_shd.g_old_rec.all_assignments
579: ,p_period_months_o
580: => per_pem_shd.g_old_rec.period_months
581: );
582: --
576: => per_pem_shd.g_old_rec.object_version_number
577: ,p_all_assignments_o
578: => per_pem_shd.g_old_rec.all_assignments
579: ,p_period_months_o
580: => per_pem_shd.g_old_rec.period_months
581: );
582: --
583: exception
584: --
636: --
637: -- {End Of Comments}
638: -- ----------------------------------------------------------------------------
639: Procedure convert_defs
640: (p_rec in out nocopy per_pem_shd.g_rec_type
641: ) is
642: --
643: Begin
644: --
648: -- is being used then we must set to the 'current' argument value.
649: --
650: If (p_rec.business_group_id = hr_api.g_number) then
651: p_rec.business_group_id :=
652: per_pem_shd.g_old_rec.business_group_id;
653: End If;
654: If (p_rec.person_id = hr_api.g_number) then
655: p_rec.person_id :=
656: per_pem_shd.g_old_rec.person_id;
652: per_pem_shd.g_old_rec.business_group_id;
653: End If;
654: If (p_rec.person_id = hr_api.g_number) then
655: p_rec.person_id :=
656: per_pem_shd.g_old_rec.person_id;
657: End If;
658: If (p_rec.party_id = hr_api.g_number) then
659: p_rec.party_id :=
660: per_pem_shd.g_old_rec.party_id;
656: per_pem_shd.g_old_rec.person_id;
657: End If;
658: If (p_rec.party_id = hr_api.g_number) then
659: p_rec.party_id :=
660: per_pem_shd.g_old_rec.party_id;
661: End If;
662: If (p_rec.start_date = hr_api.g_date) then
663: p_rec.start_date :=
664: per_pem_shd.g_old_rec.start_date;
660: per_pem_shd.g_old_rec.party_id;
661: End If;
662: If (p_rec.start_date = hr_api.g_date) then
663: p_rec.start_date :=
664: per_pem_shd.g_old_rec.start_date;
665: End If;
666: If (p_rec.end_date = hr_api.g_date) then
667: p_rec.end_date :=
668: per_pem_shd.g_old_rec.end_date;
664: per_pem_shd.g_old_rec.start_date;
665: End If;
666: If (p_rec.end_date = hr_api.g_date) then
667: p_rec.end_date :=
668: per_pem_shd.g_old_rec.end_date;
669: End If;
670: If (p_rec.period_years = hr_api.g_number) then
671: p_rec.period_years :=
672: per_pem_shd.g_old_rec.period_years;
668: per_pem_shd.g_old_rec.end_date;
669: End If;
670: If (p_rec.period_years = hr_api.g_number) then
671: p_rec.period_years :=
672: per_pem_shd.g_old_rec.period_years;
673: End If;
674: If (p_rec.period_days = hr_api.g_number) then
675: p_rec.period_days :=
676: per_pem_shd.g_old_rec.period_days;
672: per_pem_shd.g_old_rec.period_years;
673: End If;
674: If (p_rec.period_days = hr_api.g_number) then
675: p_rec.period_days :=
676: per_pem_shd.g_old_rec.period_days;
677: End If;
678: If (p_rec.employer_name = hr_api.g_varchar2) then
679: p_rec.employer_name :=
680: per_pem_shd.g_old_rec.employer_name;
676: per_pem_shd.g_old_rec.period_days;
677: End If;
678: If (p_rec.employer_name = hr_api.g_varchar2) then
679: p_rec.employer_name :=
680: per_pem_shd.g_old_rec.employer_name;
681: End If;
682: If (p_rec.employer_country = hr_api.g_varchar2) then
683: p_rec.employer_country :=
684: per_pem_shd.g_old_rec.employer_country;
680: per_pem_shd.g_old_rec.employer_name;
681: End If;
682: If (p_rec.employer_country = hr_api.g_varchar2) then
683: p_rec.employer_country :=
684: per_pem_shd.g_old_rec.employer_country;
685: End If;
686: If (p_rec.employer_address = hr_api.g_varchar2) then
687: p_rec.employer_address :=
688: per_pem_shd.g_old_rec.employer_address;
684: per_pem_shd.g_old_rec.employer_country;
685: End If;
686: If (p_rec.employer_address = hr_api.g_varchar2) then
687: p_rec.employer_address :=
688: per_pem_shd.g_old_rec.employer_address;
689: End If;
690: If (p_rec.employer_type = hr_api.g_varchar2) then
691: p_rec.employer_type :=
692: per_pem_shd.g_old_rec.employer_type;
688: per_pem_shd.g_old_rec.employer_address;
689: End If;
690: If (p_rec.employer_type = hr_api.g_varchar2) then
691: p_rec.employer_type :=
692: per_pem_shd.g_old_rec.employer_type;
693: End If;
694: If (p_rec.employer_subtype = hr_api.g_varchar2) then
695: p_rec.employer_subtype :=
696: per_pem_shd.g_old_rec.employer_subtype;
692: per_pem_shd.g_old_rec.employer_type;
693: End If;
694: If (p_rec.employer_subtype = hr_api.g_varchar2) then
695: p_rec.employer_subtype :=
696: per_pem_shd.g_old_rec.employer_subtype;
697: End If;
698: If (p_rec.description = hr_api.g_varchar2) then
699: p_rec.description :=
700: per_pem_shd.g_old_rec.description;
696: per_pem_shd.g_old_rec.employer_subtype;
697: End If;
698: If (p_rec.description = hr_api.g_varchar2) then
699: p_rec.description :=
700: per_pem_shd.g_old_rec.description;
701: End If;
702: If (p_rec.pem_attribute_category = hr_api.g_varchar2) then
703: p_rec.pem_attribute_category :=
704: per_pem_shd.g_old_rec.pem_attribute_category;
700: per_pem_shd.g_old_rec.description;
701: End If;
702: If (p_rec.pem_attribute_category = hr_api.g_varchar2) then
703: p_rec.pem_attribute_category :=
704: per_pem_shd.g_old_rec.pem_attribute_category;
705: End If;
706: If (p_rec.pem_attribute1 = hr_api.g_varchar2) then
707: p_rec.pem_attribute1 :=
708: per_pem_shd.g_old_rec.pem_attribute1;
704: per_pem_shd.g_old_rec.pem_attribute_category;
705: End If;
706: If (p_rec.pem_attribute1 = hr_api.g_varchar2) then
707: p_rec.pem_attribute1 :=
708: per_pem_shd.g_old_rec.pem_attribute1;
709: End If;
710: If (p_rec.pem_attribute2 = hr_api.g_varchar2) then
711: p_rec.pem_attribute2 :=
712: per_pem_shd.g_old_rec.pem_attribute2;
708: per_pem_shd.g_old_rec.pem_attribute1;
709: End If;
710: If (p_rec.pem_attribute2 = hr_api.g_varchar2) then
711: p_rec.pem_attribute2 :=
712: per_pem_shd.g_old_rec.pem_attribute2;
713: End If;
714: If (p_rec.pem_attribute3 = hr_api.g_varchar2) then
715: p_rec.pem_attribute3 :=
716: per_pem_shd.g_old_rec.pem_attribute3;
712: per_pem_shd.g_old_rec.pem_attribute2;
713: End If;
714: If (p_rec.pem_attribute3 = hr_api.g_varchar2) then
715: p_rec.pem_attribute3 :=
716: per_pem_shd.g_old_rec.pem_attribute3;
717: End If;
718: If (p_rec.pem_attribute4 = hr_api.g_varchar2) then
719: p_rec.pem_attribute4 :=
720: per_pem_shd.g_old_rec.pem_attribute4;
716: per_pem_shd.g_old_rec.pem_attribute3;
717: End If;
718: If (p_rec.pem_attribute4 = hr_api.g_varchar2) then
719: p_rec.pem_attribute4 :=
720: per_pem_shd.g_old_rec.pem_attribute4;
721: End If;
722: If (p_rec.pem_attribute5 = hr_api.g_varchar2) then
723: p_rec.pem_attribute5 :=
724: per_pem_shd.g_old_rec.pem_attribute5;
720: per_pem_shd.g_old_rec.pem_attribute4;
721: End If;
722: If (p_rec.pem_attribute5 = hr_api.g_varchar2) then
723: p_rec.pem_attribute5 :=
724: per_pem_shd.g_old_rec.pem_attribute5;
725: End If;
726: If (p_rec.pem_attribute6 = hr_api.g_varchar2) then
727: p_rec.pem_attribute6 :=
728: per_pem_shd.g_old_rec.pem_attribute6;
724: per_pem_shd.g_old_rec.pem_attribute5;
725: End If;
726: If (p_rec.pem_attribute6 = hr_api.g_varchar2) then
727: p_rec.pem_attribute6 :=
728: per_pem_shd.g_old_rec.pem_attribute6;
729: End If;
730: If (p_rec.pem_attribute7 = hr_api.g_varchar2) then
731: p_rec.pem_attribute7 :=
732: per_pem_shd.g_old_rec.pem_attribute7;
728: per_pem_shd.g_old_rec.pem_attribute6;
729: End If;
730: If (p_rec.pem_attribute7 = hr_api.g_varchar2) then
731: p_rec.pem_attribute7 :=
732: per_pem_shd.g_old_rec.pem_attribute7;
733: End If;
734: If (p_rec.pem_attribute8 = hr_api.g_varchar2) then
735: p_rec.pem_attribute8 :=
736: per_pem_shd.g_old_rec.pem_attribute8;
732: per_pem_shd.g_old_rec.pem_attribute7;
733: End If;
734: If (p_rec.pem_attribute8 = hr_api.g_varchar2) then
735: p_rec.pem_attribute8 :=
736: per_pem_shd.g_old_rec.pem_attribute8;
737: End If;
738: If (p_rec.pem_attribute9 = hr_api.g_varchar2) then
739: p_rec.pem_attribute9 :=
740: per_pem_shd.g_old_rec.pem_attribute9;
736: per_pem_shd.g_old_rec.pem_attribute8;
737: End If;
738: If (p_rec.pem_attribute9 = hr_api.g_varchar2) then
739: p_rec.pem_attribute9 :=
740: per_pem_shd.g_old_rec.pem_attribute9;
741: End If;
742: If (p_rec.pem_attribute10 = hr_api.g_varchar2) then
743: p_rec.pem_attribute10 :=
744: per_pem_shd.g_old_rec.pem_attribute10;
740: per_pem_shd.g_old_rec.pem_attribute9;
741: End If;
742: If (p_rec.pem_attribute10 = hr_api.g_varchar2) then
743: p_rec.pem_attribute10 :=
744: per_pem_shd.g_old_rec.pem_attribute10;
745: End If;
746: If (p_rec.pem_attribute11 = hr_api.g_varchar2) then
747: p_rec.pem_attribute11 :=
748: per_pem_shd.g_old_rec.pem_attribute11;
744: per_pem_shd.g_old_rec.pem_attribute10;
745: End If;
746: If (p_rec.pem_attribute11 = hr_api.g_varchar2) then
747: p_rec.pem_attribute11 :=
748: per_pem_shd.g_old_rec.pem_attribute11;
749: End If;
750: If (p_rec.pem_attribute12 = hr_api.g_varchar2) then
751: p_rec.pem_attribute12 :=
752: per_pem_shd.g_old_rec.pem_attribute12;
748: per_pem_shd.g_old_rec.pem_attribute11;
749: End If;
750: If (p_rec.pem_attribute12 = hr_api.g_varchar2) then
751: p_rec.pem_attribute12 :=
752: per_pem_shd.g_old_rec.pem_attribute12;
753: End If;
754: If (p_rec.pem_attribute13 = hr_api.g_varchar2) then
755: p_rec.pem_attribute13 :=
756: per_pem_shd.g_old_rec.pem_attribute13;
752: per_pem_shd.g_old_rec.pem_attribute12;
753: End If;
754: If (p_rec.pem_attribute13 = hr_api.g_varchar2) then
755: p_rec.pem_attribute13 :=
756: per_pem_shd.g_old_rec.pem_attribute13;
757: End If;
758: If (p_rec.pem_attribute14 = hr_api.g_varchar2) then
759: p_rec.pem_attribute14 :=
760: per_pem_shd.g_old_rec.pem_attribute14;
756: per_pem_shd.g_old_rec.pem_attribute13;
757: End If;
758: If (p_rec.pem_attribute14 = hr_api.g_varchar2) then
759: p_rec.pem_attribute14 :=
760: per_pem_shd.g_old_rec.pem_attribute14;
761: End If;
762: If (p_rec.pem_attribute15 = hr_api.g_varchar2) then
763: p_rec.pem_attribute15 :=
764: per_pem_shd.g_old_rec.pem_attribute15;
760: per_pem_shd.g_old_rec.pem_attribute14;
761: End If;
762: If (p_rec.pem_attribute15 = hr_api.g_varchar2) then
763: p_rec.pem_attribute15 :=
764: per_pem_shd.g_old_rec.pem_attribute15;
765: End If;
766: If (p_rec.pem_attribute16 = hr_api.g_varchar2) then
767: p_rec.pem_attribute16 :=
768: per_pem_shd.g_old_rec.pem_attribute16;
764: per_pem_shd.g_old_rec.pem_attribute15;
765: End If;
766: If (p_rec.pem_attribute16 = hr_api.g_varchar2) then
767: p_rec.pem_attribute16 :=
768: per_pem_shd.g_old_rec.pem_attribute16;
769: End If;
770: If (p_rec.pem_attribute17 = hr_api.g_varchar2) then
771: p_rec.pem_attribute17 :=
772: per_pem_shd.g_old_rec.pem_attribute17;
768: per_pem_shd.g_old_rec.pem_attribute16;
769: End If;
770: If (p_rec.pem_attribute17 = hr_api.g_varchar2) then
771: p_rec.pem_attribute17 :=
772: per_pem_shd.g_old_rec.pem_attribute17;
773: End If;
774: If (p_rec.pem_attribute18 = hr_api.g_varchar2) then
775: p_rec.pem_attribute18 :=
776: per_pem_shd.g_old_rec.pem_attribute18;
772: per_pem_shd.g_old_rec.pem_attribute17;
773: End If;
774: If (p_rec.pem_attribute18 = hr_api.g_varchar2) then
775: p_rec.pem_attribute18 :=
776: per_pem_shd.g_old_rec.pem_attribute18;
777: End If;
778: If (p_rec.pem_attribute19 = hr_api.g_varchar2) then
779: p_rec.pem_attribute19 :=
780: per_pem_shd.g_old_rec.pem_attribute19;
776: per_pem_shd.g_old_rec.pem_attribute18;
777: End If;
778: If (p_rec.pem_attribute19 = hr_api.g_varchar2) then
779: p_rec.pem_attribute19 :=
780: per_pem_shd.g_old_rec.pem_attribute19;
781: End If;
782: If (p_rec.pem_attribute20 = hr_api.g_varchar2) then
783: p_rec.pem_attribute20 :=
784: per_pem_shd.g_old_rec.pem_attribute20;
780: per_pem_shd.g_old_rec.pem_attribute19;
781: End If;
782: If (p_rec.pem_attribute20 = hr_api.g_varchar2) then
783: p_rec.pem_attribute20 :=
784: per_pem_shd.g_old_rec.pem_attribute20;
785: End If;
786: If (p_rec.pem_attribute21 = hr_api.g_varchar2) then
787: p_rec.pem_attribute21 :=
788: per_pem_shd.g_old_rec.pem_attribute21;
784: per_pem_shd.g_old_rec.pem_attribute20;
785: End If;
786: If (p_rec.pem_attribute21 = hr_api.g_varchar2) then
787: p_rec.pem_attribute21 :=
788: per_pem_shd.g_old_rec.pem_attribute21;
789: End If;
790: If (p_rec.pem_attribute22 = hr_api.g_varchar2) then
791: p_rec.pem_attribute22 :=
792: per_pem_shd.g_old_rec.pem_attribute22;
788: per_pem_shd.g_old_rec.pem_attribute21;
789: End If;
790: If (p_rec.pem_attribute22 = hr_api.g_varchar2) then
791: p_rec.pem_attribute22 :=
792: per_pem_shd.g_old_rec.pem_attribute22;
793: End If;
794: If (p_rec.pem_attribute23 = hr_api.g_varchar2) then
795: p_rec.pem_attribute23 :=
796: per_pem_shd.g_old_rec.pem_attribute23;
792: per_pem_shd.g_old_rec.pem_attribute22;
793: End If;
794: If (p_rec.pem_attribute23 = hr_api.g_varchar2) then
795: p_rec.pem_attribute23 :=
796: per_pem_shd.g_old_rec.pem_attribute23;
797: End If;
798: If (p_rec.pem_attribute24 = hr_api.g_varchar2) then
799: p_rec.pem_attribute24 :=
800: per_pem_shd.g_old_rec.pem_attribute24;
796: per_pem_shd.g_old_rec.pem_attribute23;
797: End If;
798: If (p_rec.pem_attribute24 = hr_api.g_varchar2) then
799: p_rec.pem_attribute24 :=
800: per_pem_shd.g_old_rec.pem_attribute24;
801: End If;
802: If (p_rec.pem_attribute25 = hr_api.g_varchar2) then
803: p_rec.pem_attribute25 :=
804: per_pem_shd.g_old_rec.pem_attribute25;
800: per_pem_shd.g_old_rec.pem_attribute24;
801: End If;
802: If (p_rec.pem_attribute25 = hr_api.g_varchar2) then
803: p_rec.pem_attribute25 :=
804: per_pem_shd.g_old_rec.pem_attribute25;
805: End If;
806: If (p_rec.pem_attribute26 = hr_api.g_varchar2) then
807: p_rec.pem_attribute26 :=
808: per_pem_shd.g_old_rec.pem_attribute26;
804: per_pem_shd.g_old_rec.pem_attribute25;
805: End If;
806: If (p_rec.pem_attribute26 = hr_api.g_varchar2) then
807: p_rec.pem_attribute26 :=
808: per_pem_shd.g_old_rec.pem_attribute26;
809: End If;
810: If (p_rec.pem_attribute27 = hr_api.g_varchar2) then
811: p_rec.pem_attribute27 :=
812: per_pem_shd.g_old_rec.pem_attribute27;
808: per_pem_shd.g_old_rec.pem_attribute26;
809: End If;
810: If (p_rec.pem_attribute27 = hr_api.g_varchar2) then
811: p_rec.pem_attribute27 :=
812: per_pem_shd.g_old_rec.pem_attribute27;
813: End If;
814: If (p_rec.pem_attribute28 = hr_api.g_varchar2) then
815: p_rec.pem_attribute28 :=
816: per_pem_shd.g_old_rec.pem_attribute28;
812: per_pem_shd.g_old_rec.pem_attribute27;
813: End If;
814: If (p_rec.pem_attribute28 = hr_api.g_varchar2) then
815: p_rec.pem_attribute28 :=
816: per_pem_shd.g_old_rec.pem_attribute28;
817: End If;
818: If (p_rec.pem_attribute29 = hr_api.g_varchar2) then
819: p_rec.pem_attribute29 :=
820: per_pem_shd.g_old_rec.pem_attribute29;
816: per_pem_shd.g_old_rec.pem_attribute28;
817: End If;
818: If (p_rec.pem_attribute29 = hr_api.g_varchar2) then
819: p_rec.pem_attribute29 :=
820: per_pem_shd.g_old_rec.pem_attribute29;
821: End If;
822: If (p_rec.pem_attribute30 = hr_api.g_varchar2) then
823: p_rec.pem_attribute30 :=
824: per_pem_shd.g_old_rec.pem_attribute30;
820: per_pem_shd.g_old_rec.pem_attribute29;
821: End If;
822: If (p_rec.pem_attribute30 = hr_api.g_varchar2) then
823: p_rec.pem_attribute30 :=
824: per_pem_shd.g_old_rec.pem_attribute30;
825: End If;
826: If (p_rec.pem_information_category = hr_api.g_varchar2) then
827: p_rec.pem_information_category :=
828: per_pem_shd.g_old_rec.pem_information_category;
824: per_pem_shd.g_old_rec.pem_attribute30;
825: End If;
826: If (p_rec.pem_information_category = hr_api.g_varchar2) then
827: p_rec.pem_information_category :=
828: per_pem_shd.g_old_rec.pem_information_category;
829: End If;
830: If (p_rec.pem_information1 = hr_api.g_varchar2) then
831: p_rec.pem_information1 :=
832: per_pem_shd.g_old_rec.pem_information1;
828: per_pem_shd.g_old_rec.pem_information_category;
829: End If;
830: If (p_rec.pem_information1 = hr_api.g_varchar2) then
831: p_rec.pem_information1 :=
832: per_pem_shd.g_old_rec.pem_information1;
833: End If;
834: If (p_rec.pem_information2 = hr_api.g_varchar2) then
835: p_rec.pem_information2 :=
836: per_pem_shd.g_old_rec.pem_information2;
832: per_pem_shd.g_old_rec.pem_information1;
833: End If;
834: If (p_rec.pem_information2 = hr_api.g_varchar2) then
835: p_rec.pem_information2 :=
836: per_pem_shd.g_old_rec.pem_information2;
837: End If;
838: If (p_rec.pem_information3 = hr_api.g_varchar2) then
839: p_rec.pem_information3 :=
840: per_pem_shd.g_old_rec.pem_information3;
836: per_pem_shd.g_old_rec.pem_information2;
837: End If;
838: If (p_rec.pem_information3 = hr_api.g_varchar2) then
839: p_rec.pem_information3 :=
840: per_pem_shd.g_old_rec.pem_information3;
841: End If;
842: If (p_rec.pem_information4 = hr_api.g_varchar2) then
843: p_rec.pem_information4 :=
844: per_pem_shd.g_old_rec.pem_information4;
840: per_pem_shd.g_old_rec.pem_information3;
841: End If;
842: If (p_rec.pem_information4 = hr_api.g_varchar2) then
843: p_rec.pem_information4 :=
844: per_pem_shd.g_old_rec.pem_information4;
845: End If;
846: If (p_rec.pem_information5 = hr_api.g_varchar2) then
847: p_rec.pem_information5 :=
848: per_pem_shd.g_old_rec.pem_information5;
844: per_pem_shd.g_old_rec.pem_information4;
845: End If;
846: If (p_rec.pem_information5 = hr_api.g_varchar2) then
847: p_rec.pem_information5 :=
848: per_pem_shd.g_old_rec.pem_information5;
849: End If;
850: If (p_rec.pem_information6 = hr_api.g_varchar2) then
851: p_rec.pem_information6 :=
852: per_pem_shd.g_old_rec.pem_information6;
848: per_pem_shd.g_old_rec.pem_information5;
849: End If;
850: If (p_rec.pem_information6 = hr_api.g_varchar2) then
851: p_rec.pem_information6 :=
852: per_pem_shd.g_old_rec.pem_information6;
853: End If;
854: If (p_rec.pem_information7 = hr_api.g_varchar2) then
855: p_rec.pem_information7 :=
856: per_pem_shd.g_old_rec.pem_information7;
852: per_pem_shd.g_old_rec.pem_information6;
853: End If;
854: If (p_rec.pem_information7 = hr_api.g_varchar2) then
855: p_rec.pem_information7 :=
856: per_pem_shd.g_old_rec.pem_information7;
857: End If;
858: If (p_rec.pem_information8 = hr_api.g_varchar2) then
859: p_rec.pem_information8 :=
860: per_pem_shd.g_old_rec.pem_information8;
856: per_pem_shd.g_old_rec.pem_information7;
857: End If;
858: If (p_rec.pem_information8 = hr_api.g_varchar2) then
859: p_rec.pem_information8 :=
860: per_pem_shd.g_old_rec.pem_information8;
861: End If;
862: If (p_rec.pem_information9 = hr_api.g_varchar2) then
863: p_rec.pem_information9 :=
864: per_pem_shd.g_old_rec.pem_information9;
860: per_pem_shd.g_old_rec.pem_information8;
861: End If;
862: If (p_rec.pem_information9 = hr_api.g_varchar2) then
863: p_rec.pem_information9 :=
864: per_pem_shd.g_old_rec.pem_information9;
865: End If;
866: If (p_rec.pem_information10 = hr_api.g_varchar2) then
867: p_rec.pem_information10 :=
868: per_pem_shd.g_old_rec.pem_information10;
864: per_pem_shd.g_old_rec.pem_information9;
865: End If;
866: If (p_rec.pem_information10 = hr_api.g_varchar2) then
867: p_rec.pem_information10 :=
868: per_pem_shd.g_old_rec.pem_information10;
869: End If;
870: If (p_rec.pem_information11 = hr_api.g_varchar2) then
871: p_rec.pem_information11 :=
872: per_pem_shd.g_old_rec.pem_information11;
868: per_pem_shd.g_old_rec.pem_information10;
869: End If;
870: If (p_rec.pem_information11 = hr_api.g_varchar2) then
871: p_rec.pem_information11 :=
872: per_pem_shd.g_old_rec.pem_information11;
873: End If;
874: If (p_rec.pem_information12 = hr_api.g_varchar2) then
875: p_rec.pem_information12 :=
876: per_pem_shd.g_old_rec.pem_information12;
872: per_pem_shd.g_old_rec.pem_information11;
873: End If;
874: If (p_rec.pem_information12 = hr_api.g_varchar2) then
875: p_rec.pem_information12 :=
876: per_pem_shd.g_old_rec.pem_information12;
877: End If;
878: If (p_rec.pem_information13 = hr_api.g_varchar2) then
879: p_rec.pem_information13 :=
880: per_pem_shd.g_old_rec.pem_information13;
876: per_pem_shd.g_old_rec.pem_information12;
877: End If;
878: If (p_rec.pem_information13 = hr_api.g_varchar2) then
879: p_rec.pem_information13 :=
880: per_pem_shd.g_old_rec.pem_information13;
881: End If;
882: If (p_rec.pem_information14 = hr_api.g_varchar2) then
883: p_rec.pem_information14 :=
884: per_pem_shd.g_old_rec.pem_information14;
880: per_pem_shd.g_old_rec.pem_information13;
881: End If;
882: If (p_rec.pem_information14 = hr_api.g_varchar2) then
883: p_rec.pem_information14 :=
884: per_pem_shd.g_old_rec.pem_information14;
885: End If;
886: If (p_rec.pem_information15 = hr_api.g_varchar2) then
887: p_rec.pem_information15 :=
888: per_pem_shd.g_old_rec.pem_information15;
884: per_pem_shd.g_old_rec.pem_information14;
885: End If;
886: If (p_rec.pem_information15 = hr_api.g_varchar2) then
887: p_rec.pem_information15 :=
888: per_pem_shd.g_old_rec.pem_information15;
889: End If;
890: If (p_rec.pem_information16 = hr_api.g_varchar2) then
891: p_rec.pem_information16 :=
892: per_pem_shd.g_old_rec.pem_information16;
888: per_pem_shd.g_old_rec.pem_information15;
889: End If;
890: If (p_rec.pem_information16 = hr_api.g_varchar2) then
891: p_rec.pem_information16 :=
892: per_pem_shd.g_old_rec.pem_information16;
893: End If;
894: If (p_rec.pem_information17 = hr_api.g_varchar2) then
895: p_rec.pem_information17 :=
896: per_pem_shd.g_old_rec.pem_information17;
892: per_pem_shd.g_old_rec.pem_information16;
893: End If;
894: If (p_rec.pem_information17 = hr_api.g_varchar2) then
895: p_rec.pem_information17 :=
896: per_pem_shd.g_old_rec.pem_information17;
897: End If;
898: If (p_rec.pem_information18 = hr_api.g_varchar2) then
899: p_rec.pem_information18 :=
900: per_pem_shd.g_old_rec.pem_information18;
896: per_pem_shd.g_old_rec.pem_information17;
897: End If;
898: If (p_rec.pem_information18 = hr_api.g_varchar2) then
899: p_rec.pem_information18 :=
900: per_pem_shd.g_old_rec.pem_information18;
901: End If;
902: If (p_rec.pem_information19 = hr_api.g_varchar2) then
903: p_rec.pem_information19 :=
904: per_pem_shd.g_old_rec.pem_information19;
900: per_pem_shd.g_old_rec.pem_information18;
901: End If;
902: If (p_rec.pem_information19 = hr_api.g_varchar2) then
903: p_rec.pem_information19 :=
904: per_pem_shd.g_old_rec.pem_information19;
905: End If;
906: If (p_rec.pem_information20 = hr_api.g_varchar2) then
907: p_rec.pem_information20 :=
908: per_pem_shd.g_old_rec.pem_information20;
904: per_pem_shd.g_old_rec.pem_information19;
905: End If;
906: If (p_rec.pem_information20 = hr_api.g_varchar2) then
907: p_rec.pem_information20 :=
908: per_pem_shd.g_old_rec.pem_information20;
909: End If;
910: If (p_rec.pem_information21 = hr_api.g_varchar2) then
911: p_rec.pem_information21 :=
912: per_pem_shd.g_old_rec.pem_information21;
908: per_pem_shd.g_old_rec.pem_information20;
909: End If;
910: If (p_rec.pem_information21 = hr_api.g_varchar2) then
911: p_rec.pem_information21 :=
912: per_pem_shd.g_old_rec.pem_information21;
913: End If;
914: If (p_rec.pem_information22 = hr_api.g_varchar2) then
915: p_rec.pem_information22 :=
916: per_pem_shd.g_old_rec.pem_information22;
912: per_pem_shd.g_old_rec.pem_information21;
913: End If;
914: If (p_rec.pem_information22 = hr_api.g_varchar2) then
915: p_rec.pem_information22 :=
916: per_pem_shd.g_old_rec.pem_information22;
917: End If;
918: If (p_rec.pem_information23 = hr_api.g_varchar2) then
919: p_rec.pem_information23 :=
920: per_pem_shd.g_old_rec.pem_information23;
916: per_pem_shd.g_old_rec.pem_information22;
917: End If;
918: If (p_rec.pem_information23 = hr_api.g_varchar2) then
919: p_rec.pem_information23 :=
920: per_pem_shd.g_old_rec.pem_information23;
921: End If;
922: If (p_rec.pem_information24 = hr_api.g_varchar2) then
923: p_rec.pem_information24 :=
924: per_pem_shd.g_old_rec.pem_information24;
920: per_pem_shd.g_old_rec.pem_information23;
921: End If;
922: If (p_rec.pem_information24 = hr_api.g_varchar2) then
923: p_rec.pem_information24 :=
924: per_pem_shd.g_old_rec.pem_information24;
925: End If;
926: If (p_rec.pem_information25 = hr_api.g_varchar2) then
927: p_rec.pem_information25 :=
928: per_pem_shd.g_old_rec.pem_information25;
924: per_pem_shd.g_old_rec.pem_information24;
925: End If;
926: If (p_rec.pem_information25 = hr_api.g_varchar2) then
927: p_rec.pem_information25 :=
928: per_pem_shd.g_old_rec.pem_information25;
929: End If;
930: If (p_rec.pem_information26 = hr_api.g_varchar2) then
931: p_rec.pem_information26 :=
932: per_pem_shd.g_old_rec.pem_information26;
928: per_pem_shd.g_old_rec.pem_information25;
929: End If;
930: If (p_rec.pem_information26 = hr_api.g_varchar2) then
931: p_rec.pem_information26 :=
932: per_pem_shd.g_old_rec.pem_information26;
933: End If;
934: If (p_rec.pem_information27 = hr_api.g_varchar2) then
935: p_rec.pem_information27 :=
936: per_pem_shd.g_old_rec.pem_information27;
932: per_pem_shd.g_old_rec.pem_information26;
933: End If;
934: If (p_rec.pem_information27 = hr_api.g_varchar2) then
935: p_rec.pem_information27 :=
936: per_pem_shd.g_old_rec.pem_information27;
937: End If;
938: If (p_rec.pem_information28 = hr_api.g_varchar2) then
939: p_rec.pem_information28 :=
940: per_pem_shd.g_old_rec.pem_information28;
936: per_pem_shd.g_old_rec.pem_information27;
937: End If;
938: If (p_rec.pem_information28 = hr_api.g_varchar2) then
939: p_rec.pem_information28 :=
940: per_pem_shd.g_old_rec.pem_information28;
941: End If;
942: If (p_rec.pem_information29 = hr_api.g_varchar2) then
943: p_rec.pem_information29 :=
944: per_pem_shd.g_old_rec.pem_information29;
940: per_pem_shd.g_old_rec.pem_information28;
941: End If;
942: If (p_rec.pem_information29 = hr_api.g_varchar2) then
943: p_rec.pem_information29 :=
944: per_pem_shd.g_old_rec.pem_information29;
945: End If;
946: If (p_rec.pem_information30 = hr_api.g_varchar2) then
947: p_rec.pem_information30 :=
948: per_pem_shd.g_old_rec.pem_information30;
944: per_pem_shd.g_old_rec.pem_information29;
945: End If;
946: If (p_rec.pem_information30 = hr_api.g_varchar2) then
947: p_rec.pem_information30 :=
948: per_pem_shd.g_old_rec.pem_information30;
949: End If;
950: If (p_rec.all_assignments = hr_api.g_varchar2) then
951: p_rec.all_assignments :=
952: per_pem_shd.g_old_rec.all_assignments;
948: per_pem_shd.g_old_rec.pem_information30;
949: End If;
950: If (p_rec.all_assignments = hr_api.g_varchar2) then
951: p_rec.all_assignments :=
952: per_pem_shd.g_old_rec.all_assignments;
953: End If;
954: If (p_rec.period_months = hr_api.g_number) then
955: p_rec.period_months :=
956: per_pem_shd.g_old_rec.period_months;
952: per_pem_shd.g_old_rec.all_assignments;
953: End If;
954: If (p_rec.period_months = hr_api.g_number) then
955: p_rec.period_months :=
956: per_pem_shd.g_old_rec.period_months;
957: End If;
958: --
959: End convert_defs;
960: --
962: -- |---------------------------------< upd >----------------------------------|
963: -- ----------------------------------------------------------------------------
964: Procedure upd
965: (p_effective_date in date
966: ,p_rec in out nocopy per_pem_shd.g_rec_type
967: ) is
968: --
969: l_proc varchar2(72) := g_package||'upd';
970: --
972: hr_utility.set_location('Entering:'||l_proc, 5);
973: --
974: -- We must lock the row which we need to update.
975: --
976: per_pem_shd.lck
977: (p_rec.previous_employer_id
978: ,p_rec.object_version_number
979: );
980: --
1096: ,p_all_assignments in varchar2 default hr_api.g_varchar2
1097: ,p_period_months in number default hr_api.g_number
1098: ) is
1099: --
1100: l_rec per_pem_shd.g_rec_type;
1101: l_proc varchar2(72) := g_package||'upd';
1102: --
1103: Begin
1104: hr_utility.set_location('Entering:'||l_proc, 5);
1106: -- Call conversion function to turn arguments into the
1107: -- l_rec structure.
1108: --
1109: l_rec :=
1110: per_pem_shd.convert_args
1111: (p_previous_employer_id
1112: ,p_business_group_id
1113: ,p_person_id
1114: ,p_party_id