[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_pjo_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
152: Exception
153: When hr_api.check_integrity_violated Then
154: -- A check constraint has been violated
155: --
156: per_pjo_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.parent_integrity_violated Then
159: -- Parent integrity has been violated
160: --
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When hr_api.parent_integrity_violated Then
159: -- Parent integrity has been violated
160: --
161: per_pjo_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When hr_api.unique_integrity_violated Then
164: -- Unique integrity has been violated
165: --
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When hr_api.unique_integrity_violated Then
164: -- Unique integrity has been violated
165: --
166: per_pjo_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When Others Then
169: --
170: Raise;
202: --
203: -- {End Of Comments}
204: -- ----------------------------------------------------------------------------
205: Procedure pre_update
206: (p_rec in per_pjo_shd.g_rec_type
207: ) is
208: --
209: l_proc varchar2(72) := g_package||'pre_update';
210: --
247: -- {End Of Comments}
248: -- ----------------------------------------------------------------------------
249: Procedure post_update
250: (p_effective_date in date
251: ,p_rec in per_pjo_shd.g_rec_type
252: ) is
253: --
254: l_proc varchar2(72) := g_package||'post_update';
255: --
407: => p_rec.all_assignments
408: ,p_period_months
409: => p_rec.period_months
410: ,p_previous_employer_id_o
411: => per_pjo_shd.g_old_rec.previous_employer_id
412: ,p_start_date_o
413: => per_pjo_shd.g_old_rec.start_date
414: ,p_end_date_o
415: => per_pjo_shd.g_old_rec.end_date
409: => p_rec.period_months
410: ,p_previous_employer_id_o
411: => per_pjo_shd.g_old_rec.previous_employer_id
412: ,p_start_date_o
413: => per_pjo_shd.g_old_rec.start_date
414: ,p_end_date_o
415: => per_pjo_shd.g_old_rec.end_date
416: ,p_period_years_o
417: => per_pjo_shd.g_old_rec.period_years
411: => per_pjo_shd.g_old_rec.previous_employer_id
412: ,p_start_date_o
413: => per_pjo_shd.g_old_rec.start_date
414: ,p_end_date_o
415: => per_pjo_shd.g_old_rec.end_date
416: ,p_period_years_o
417: => per_pjo_shd.g_old_rec.period_years
418: ,p_period_days_o
419: => per_pjo_shd.g_old_rec.period_days
413: => per_pjo_shd.g_old_rec.start_date
414: ,p_end_date_o
415: => per_pjo_shd.g_old_rec.end_date
416: ,p_period_years_o
417: => per_pjo_shd.g_old_rec.period_years
418: ,p_period_days_o
419: => per_pjo_shd.g_old_rec.period_days
420: ,p_job_name_o
421: => per_pjo_shd.g_old_rec.job_name
415: => per_pjo_shd.g_old_rec.end_date
416: ,p_period_years_o
417: => per_pjo_shd.g_old_rec.period_years
418: ,p_period_days_o
419: => per_pjo_shd.g_old_rec.period_days
420: ,p_job_name_o
421: => per_pjo_shd.g_old_rec.job_name
422: ,p_employment_category_o
423: => per_pjo_shd.g_old_rec.employment_category
417: => per_pjo_shd.g_old_rec.period_years
418: ,p_period_days_o
419: => per_pjo_shd.g_old_rec.period_days
420: ,p_job_name_o
421: => per_pjo_shd.g_old_rec.job_name
422: ,p_employment_category_o
423: => per_pjo_shd.g_old_rec.employment_category
424: ,p_description_o
425: => per_pjo_shd.g_old_rec.description
419: => per_pjo_shd.g_old_rec.period_days
420: ,p_job_name_o
421: => per_pjo_shd.g_old_rec.job_name
422: ,p_employment_category_o
423: => per_pjo_shd.g_old_rec.employment_category
424: ,p_description_o
425: => per_pjo_shd.g_old_rec.description
426: ,p_pjo_attribute_category_o
427: => per_pjo_shd.g_old_rec.pjo_attribute_category
421: => per_pjo_shd.g_old_rec.job_name
422: ,p_employment_category_o
423: => per_pjo_shd.g_old_rec.employment_category
424: ,p_description_o
425: => per_pjo_shd.g_old_rec.description
426: ,p_pjo_attribute_category_o
427: => per_pjo_shd.g_old_rec.pjo_attribute_category
428: ,p_pjo_attribute1_o
429: => per_pjo_shd.g_old_rec.pjo_attribute1
423: => per_pjo_shd.g_old_rec.employment_category
424: ,p_description_o
425: => per_pjo_shd.g_old_rec.description
426: ,p_pjo_attribute_category_o
427: => per_pjo_shd.g_old_rec.pjo_attribute_category
428: ,p_pjo_attribute1_o
429: => per_pjo_shd.g_old_rec.pjo_attribute1
430: ,p_pjo_attribute2_o
431: => per_pjo_shd.g_old_rec.pjo_attribute2
425: => per_pjo_shd.g_old_rec.description
426: ,p_pjo_attribute_category_o
427: => per_pjo_shd.g_old_rec.pjo_attribute_category
428: ,p_pjo_attribute1_o
429: => per_pjo_shd.g_old_rec.pjo_attribute1
430: ,p_pjo_attribute2_o
431: => per_pjo_shd.g_old_rec.pjo_attribute2
432: ,p_pjo_attribute3_o
433: => per_pjo_shd.g_old_rec.pjo_attribute3
427: => per_pjo_shd.g_old_rec.pjo_attribute_category
428: ,p_pjo_attribute1_o
429: => per_pjo_shd.g_old_rec.pjo_attribute1
430: ,p_pjo_attribute2_o
431: => per_pjo_shd.g_old_rec.pjo_attribute2
432: ,p_pjo_attribute3_o
433: => per_pjo_shd.g_old_rec.pjo_attribute3
434: ,p_pjo_attribute4_o
435: => per_pjo_shd.g_old_rec.pjo_attribute4
429: => per_pjo_shd.g_old_rec.pjo_attribute1
430: ,p_pjo_attribute2_o
431: => per_pjo_shd.g_old_rec.pjo_attribute2
432: ,p_pjo_attribute3_o
433: => per_pjo_shd.g_old_rec.pjo_attribute3
434: ,p_pjo_attribute4_o
435: => per_pjo_shd.g_old_rec.pjo_attribute4
436: ,p_pjo_attribute5_o
437: => per_pjo_shd.g_old_rec.pjo_attribute5
431: => per_pjo_shd.g_old_rec.pjo_attribute2
432: ,p_pjo_attribute3_o
433: => per_pjo_shd.g_old_rec.pjo_attribute3
434: ,p_pjo_attribute4_o
435: => per_pjo_shd.g_old_rec.pjo_attribute4
436: ,p_pjo_attribute5_o
437: => per_pjo_shd.g_old_rec.pjo_attribute5
438: ,p_pjo_attribute6_o
439: => per_pjo_shd.g_old_rec.pjo_attribute6
433: => per_pjo_shd.g_old_rec.pjo_attribute3
434: ,p_pjo_attribute4_o
435: => per_pjo_shd.g_old_rec.pjo_attribute4
436: ,p_pjo_attribute5_o
437: => per_pjo_shd.g_old_rec.pjo_attribute5
438: ,p_pjo_attribute6_o
439: => per_pjo_shd.g_old_rec.pjo_attribute6
440: ,p_pjo_attribute7_o
441: => per_pjo_shd.g_old_rec.pjo_attribute7
435: => per_pjo_shd.g_old_rec.pjo_attribute4
436: ,p_pjo_attribute5_o
437: => per_pjo_shd.g_old_rec.pjo_attribute5
438: ,p_pjo_attribute6_o
439: => per_pjo_shd.g_old_rec.pjo_attribute6
440: ,p_pjo_attribute7_o
441: => per_pjo_shd.g_old_rec.pjo_attribute7
442: ,p_pjo_attribute8_o
443: => per_pjo_shd.g_old_rec.pjo_attribute8
437: => per_pjo_shd.g_old_rec.pjo_attribute5
438: ,p_pjo_attribute6_o
439: => per_pjo_shd.g_old_rec.pjo_attribute6
440: ,p_pjo_attribute7_o
441: => per_pjo_shd.g_old_rec.pjo_attribute7
442: ,p_pjo_attribute8_o
443: => per_pjo_shd.g_old_rec.pjo_attribute8
444: ,p_pjo_attribute9_o
445: => per_pjo_shd.g_old_rec.pjo_attribute9
439: => per_pjo_shd.g_old_rec.pjo_attribute6
440: ,p_pjo_attribute7_o
441: => per_pjo_shd.g_old_rec.pjo_attribute7
442: ,p_pjo_attribute8_o
443: => per_pjo_shd.g_old_rec.pjo_attribute8
444: ,p_pjo_attribute9_o
445: => per_pjo_shd.g_old_rec.pjo_attribute9
446: ,p_pjo_attribute10_o
447: => per_pjo_shd.g_old_rec.pjo_attribute10
441: => per_pjo_shd.g_old_rec.pjo_attribute7
442: ,p_pjo_attribute8_o
443: => per_pjo_shd.g_old_rec.pjo_attribute8
444: ,p_pjo_attribute9_o
445: => per_pjo_shd.g_old_rec.pjo_attribute9
446: ,p_pjo_attribute10_o
447: => per_pjo_shd.g_old_rec.pjo_attribute10
448: ,p_pjo_attribute11_o
449: => per_pjo_shd.g_old_rec.pjo_attribute11
443: => per_pjo_shd.g_old_rec.pjo_attribute8
444: ,p_pjo_attribute9_o
445: => per_pjo_shd.g_old_rec.pjo_attribute9
446: ,p_pjo_attribute10_o
447: => per_pjo_shd.g_old_rec.pjo_attribute10
448: ,p_pjo_attribute11_o
449: => per_pjo_shd.g_old_rec.pjo_attribute11
450: ,p_pjo_attribute12_o
451: => per_pjo_shd.g_old_rec.pjo_attribute12
445: => per_pjo_shd.g_old_rec.pjo_attribute9
446: ,p_pjo_attribute10_o
447: => per_pjo_shd.g_old_rec.pjo_attribute10
448: ,p_pjo_attribute11_o
449: => per_pjo_shd.g_old_rec.pjo_attribute11
450: ,p_pjo_attribute12_o
451: => per_pjo_shd.g_old_rec.pjo_attribute12
452: ,p_pjo_attribute13_o
453: => per_pjo_shd.g_old_rec.pjo_attribute13
447: => per_pjo_shd.g_old_rec.pjo_attribute10
448: ,p_pjo_attribute11_o
449: => per_pjo_shd.g_old_rec.pjo_attribute11
450: ,p_pjo_attribute12_o
451: => per_pjo_shd.g_old_rec.pjo_attribute12
452: ,p_pjo_attribute13_o
453: => per_pjo_shd.g_old_rec.pjo_attribute13
454: ,p_pjo_attribute14_o
455: => per_pjo_shd.g_old_rec.pjo_attribute14
449: => per_pjo_shd.g_old_rec.pjo_attribute11
450: ,p_pjo_attribute12_o
451: => per_pjo_shd.g_old_rec.pjo_attribute12
452: ,p_pjo_attribute13_o
453: => per_pjo_shd.g_old_rec.pjo_attribute13
454: ,p_pjo_attribute14_o
455: => per_pjo_shd.g_old_rec.pjo_attribute14
456: ,p_pjo_attribute15_o
457: => per_pjo_shd.g_old_rec.pjo_attribute15
451: => per_pjo_shd.g_old_rec.pjo_attribute12
452: ,p_pjo_attribute13_o
453: => per_pjo_shd.g_old_rec.pjo_attribute13
454: ,p_pjo_attribute14_o
455: => per_pjo_shd.g_old_rec.pjo_attribute14
456: ,p_pjo_attribute15_o
457: => per_pjo_shd.g_old_rec.pjo_attribute15
458: ,p_pjo_attribute16_o
459: => per_pjo_shd.g_old_rec.pjo_attribute16
453: => per_pjo_shd.g_old_rec.pjo_attribute13
454: ,p_pjo_attribute14_o
455: => per_pjo_shd.g_old_rec.pjo_attribute14
456: ,p_pjo_attribute15_o
457: => per_pjo_shd.g_old_rec.pjo_attribute15
458: ,p_pjo_attribute16_o
459: => per_pjo_shd.g_old_rec.pjo_attribute16
460: ,p_pjo_attribute17_o
461: => per_pjo_shd.g_old_rec.pjo_attribute17
455: => per_pjo_shd.g_old_rec.pjo_attribute14
456: ,p_pjo_attribute15_o
457: => per_pjo_shd.g_old_rec.pjo_attribute15
458: ,p_pjo_attribute16_o
459: => per_pjo_shd.g_old_rec.pjo_attribute16
460: ,p_pjo_attribute17_o
461: => per_pjo_shd.g_old_rec.pjo_attribute17
462: ,p_pjo_attribute18_o
463: => per_pjo_shd.g_old_rec.pjo_attribute18
457: => per_pjo_shd.g_old_rec.pjo_attribute15
458: ,p_pjo_attribute16_o
459: => per_pjo_shd.g_old_rec.pjo_attribute16
460: ,p_pjo_attribute17_o
461: => per_pjo_shd.g_old_rec.pjo_attribute17
462: ,p_pjo_attribute18_o
463: => per_pjo_shd.g_old_rec.pjo_attribute18
464: ,p_pjo_attribute19_o
465: => per_pjo_shd.g_old_rec.pjo_attribute19
459: => per_pjo_shd.g_old_rec.pjo_attribute16
460: ,p_pjo_attribute17_o
461: => per_pjo_shd.g_old_rec.pjo_attribute17
462: ,p_pjo_attribute18_o
463: => per_pjo_shd.g_old_rec.pjo_attribute18
464: ,p_pjo_attribute19_o
465: => per_pjo_shd.g_old_rec.pjo_attribute19
466: ,p_pjo_attribute20_o
467: => per_pjo_shd.g_old_rec.pjo_attribute20
461: => per_pjo_shd.g_old_rec.pjo_attribute17
462: ,p_pjo_attribute18_o
463: => per_pjo_shd.g_old_rec.pjo_attribute18
464: ,p_pjo_attribute19_o
465: => per_pjo_shd.g_old_rec.pjo_attribute19
466: ,p_pjo_attribute20_o
467: => per_pjo_shd.g_old_rec.pjo_attribute20
468: ,p_pjo_attribute21_o
469: => per_pjo_shd.g_old_rec.pjo_attribute21
463: => per_pjo_shd.g_old_rec.pjo_attribute18
464: ,p_pjo_attribute19_o
465: => per_pjo_shd.g_old_rec.pjo_attribute19
466: ,p_pjo_attribute20_o
467: => per_pjo_shd.g_old_rec.pjo_attribute20
468: ,p_pjo_attribute21_o
469: => per_pjo_shd.g_old_rec.pjo_attribute21
470: ,p_pjo_attribute22_o
471: => per_pjo_shd.g_old_rec.pjo_attribute22
465: => per_pjo_shd.g_old_rec.pjo_attribute19
466: ,p_pjo_attribute20_o
467: => per_pjo_shd.g_old_rec.pjo_attribute20
468: ,p_pjo_attribute21_o
469: => per_pjo_shd.g_old_rec.pjo_attribute21
470: ,p_pjo_attribute22_o
471: => per_pjo_shd.g_old_rec.pjo_attribute22
472: ,p_pjo_attribute23_o
473: => per_pjo_shd.g_old_rec.pjo_attribute23
467: => per_pjo_shd.g_old_rec.pjo_attribute20
468: ,p_pjo_attribute21_o
469: => per_pjo_shd.g_old_rec.pjo_attribute21
470: ,p_pjo_attribute22_o
471: => per_pjo_shd.g_old_rec.pjo_attribute22
472: ,p_pjo_attribute23_o
473: => per_pjo_shd.g_old_rec.pjo_attribute23
474: ,p_pjo_attribute24_o
475: => per_pjo_shd.g_old_rec.pjo_attribute24
469: => per_pjo_shd.g_old_rec.pjo_attribute21
470: ,p_pjo_attribute22_o
471: => per_pjo_shd.g_old_rec.pjo_attribute22
472: ,p_pjo_attribute23_o
473: => per_pjo_shd.g_old_rec.pjo_attribute23
474: ,p_pjo_attribute24_o
475: => per_pjo_shd.g_old_rec.pjo_attribute24
476: ,p_pjo_attribute25_o
477: => per_pjo_shd.g_old_rec.pjo_attribute25
471: => per_pjo_shd.g_old_rec.pjo_attribute22
472: ,p_pjo_attribute23_o
473: => per_pjo_shd.g_old_rec.pjo_attribute23
474: ,p_pjo_attribute24_o
475: => per_pjo_shd.g_old_rec.pjo_attribute24
476: ,p_pjo_attribute25_o
477: => per_pjo_shd.g_old_rec.pjo_attribute25
478: ,p_pjo_attribute26_o
479: => per_pjo_shd.g_old_rec.pjo_attribute26
473: => per_pjo_shd.g_old_rec.pjo_attribute23
474: ,p_pjo_attribute24_o
475: => per_pjo_shd.g_old_rec.pjo_attribute24
476: ,p_pjo_attribute25_o
477: => per_pjo_shd.g_old_rec.pjo_attribute25
478: ,p_pjo_attribute26_o
479: => per_pjo_shd.g_old_rec.pjo_attribute26
480: ,p_pjo_attribute27_o
481: => per_pjo_shd.g_old_rec.pjo_attribute27
475: => per_pjo_shd.g_old_rec.pjo_attribute24
476: ,p_pjo_attribute25_o
477: => per_pjo_shd.g_old_rec.pjo_attribute25
478: ,p_pjo_attribute26_o
479: => per_pjo_shd.g_old_rec.pjo_attribute26
480: ,p_pjo_attribute27_o
481: => per_pjo_shd.g_old_rec.pjo_attribute27
482: ,p_pjo_attribute28_o
483: => per_pjo_shd.g_old_rec.pjo_attribute28
477: => per_pjo_shd.g_old_rec.pjo_attribute25
478: ,p_pjo_attribute26_o
479: => per_pjo_shd.g_old_rec.pjo_attribute26
480: ,p_pjo_attribute27_o
481: => per_pjo_shd.g_old_rec.pjo_attribute27
482: ,p_pjo_attribute28_o
483: => per_pjo_shd.g_old_rec.pjo_attribute28
484: ,p_pjo_attribute29_o
485: => per_pjo_shd.g_old_rec.pjo_attribute29
479: => per_pjo_shd.g_old_rec.pjo_attribute26
480: ,p_pjo_attribute27_o
481: => per_pjo_shd.g_old_rec.pjo_attribute27
482: ,p_pjo_attribute28_o
483: => per_pjo_shd.g_old_rec.pjo_attribute28
484: ,p_pjo_attribute29_o
485: => per_pjo_shd.g_old_rec.pjo_attribute29
486: ,p_pjo_attribute30_o
487: => per_pjo_shd.g_old_rec.pjo_attribute30
481: => per_pjo_shd.g_old_rec.pjo_attribute27
482: ,p_pjo_attribute28_o
483: => per_pjo_shd.g_old_rec.pjo_attribute28
484: ,p_pjo_attribute29_o
485: => per_pjo_shd.g_old_rec.pjo_attribute29
486: ,p_pjo_attribute30_o
487: => per_pjo_shd.g_old_rec.pjo_attribute30
488: ,p_pjo_information_category_o
489: => per_pjo_shd.g_old_rec.pjo_information_category
483: => per_pjo_shd.g_old_rec.pjo_attribute28
484: ,p_pjo_attribute29_o
485: => per_pjo_shd.g_old_rec.pjo_attribute29
486: ,p_pjo_attribute30_o
487: => per_pjo_shd.g_old_rec.pjo_attribute30
488: ,p_pjo_information_category_o
489: => per_pjo_shd.g_old_rec.pjo_information_category
490: ,p_pjo_information1_o
491: => per_pjo_shd.g_old_rec.pjo_information1
485: => per_pjo_shd.g_old_rec.pjo_attribute29
486: ,p_pjo_attribute30_o
487: => per_pjo_shd.g_old_rec.pjo_attribute30
488: ,p_pjo_information_category_o
489: => per_pjo_shd.g_old_rec.pjo_information_category
490: ,p_pjo_information1_o
491: => per_pjo_shd.g_old_rec.pjo_information1
492: ,p_pjo_information2_o
493: => per_pjo_shd.g_old_rec.pjo_information2
487: => per_pjo_shd.g_old_rec.pjo_attribute30
488: ,p_pjo_information_category_o
489: => per_pjo_shd.g_old_rec.pjo_information_category
490: ,p_pjo_information1_o
491: => per_pjo_shd.g_old_rec.pjo_information1
492: ,p_pjo_information2_o
493: => per_pjo_shd.g_old_rec.pjo_information2
494: ,p_pjo_information3_o
495: => per_pjo_shd.g_old_rec.pjo_information3
489: => per_pjo_shd.g_old_rec.pjo_information_category
490: ,p_pjo_information1_o
491: => per_pjo_shd.g_old_rec.pjo_information1
492: ,p_pjo_information2_o
493: => per_pjo_shd.g_old_rec.pjo_information2
494: ,p_pjo_information3_o
495: => per_pjo_shd.g_old_rec.pjo_information3
496: ,p_pjo_information4_o
497: => per_pjo_shd.g_old_rec.pjo_information4
491: => per_pjo_shd.g_old_rec.pjo_information1
492: ,p_pjo_information2_o
493: => per_pjo_shd.g_old_rec.pjo_information2
494: ,p_pjo_information3_o
495: => per_pjo_shd.g_old_rec.pjo_information3
496: ,p_pjo_information4_o
497: => per_pjo_shd.g_old_rec.pjo_information4
498: ,p_pjo_information5_o
499: => per_pjo_shd.g_old_rec.pjo_information5
493: => per_pjo_shd.g_old_rec.pjo_information2
494: ,p_pjo_information3_o
495: => per_pjo_shd.g_old_rec.pjo_information3
496: ,p_pjo_information4_o
497: => per_pjo_shd.g_old_rec.pjo_information4
498: ,p_pjo_information5_o
499: => per_pjo_shd.g_old_rec.pjo_information5
500: ,p_pjo_information6_o
501: => per_pjo_shd.g_old_rec.pjo_information6
495: => per_pjo_shd.g_old_rec.pjo_information3
496: ,p_pjo_information4_o
497: => per_pjo_shd.g_old_rec.pjo_information4
498: ,p_pjo_information5_o
499: => per_pjo_shd.g_old_rec.pjo_information5
500: ,p_pjo_information6_o
501: => per_pjo_shd.g_old_rec.pjo_information6
502: ,p_pjo_information7_o
503: => per_pjo_shd.g_old_rec.pjo_information7
497: => per_pjo_shd.g_old_rec.pjo_information4
498: ,p_pjo_information5_o
499: => per_pjo_shd.g_old_rec.pjo_information5
500: ,p_pjo_information6_o
501: => per_pjo_shd.g_old_rec.pjo_information6
502: ,p_pjo_information7_o
503: => per_pjo_shd.g_old_rec.pjo_information7
504: ,p_pjo_information8_o
505: => per_pjo_shd.g_old_rec.pjo_information8
499: => per_pjo_shd.g_old_rec.pjo_information5
500: ,p_pjo_information6_o
501: => per_pjo_shd.g_old_rec.pjo_information6
502: ,p_pjo_information7_o
503: => per_pjo_shd.g_old_rec.pjo_information7
504: ,p_pjo_information8_o
505: => per_pjo_shd.g_old_rec.pjo_information8
506: ,p_pjo_information9_o
507: => per_pjo_shd.g_old_rec.pjo_information9
501: => per_pjo_shd.g_old_rec.pjo_information6
502: ,p_pjo_information7_o
503: => per_pjo_shd.g_old_rec.pjo_information7
504: ,p_pjo_information8_o
505: => per_pjo_shd.g_old_rec.pjo_information8
506: ,p_pjo_information9_o
507: => per_pjo_shd.g_old_rec.pjo_information9
508: ,p_pjo_information10_o
509: => per_pjo_shd.g_old_rec.pjo_information10
503: => per_pjo_shd.g_old_rec.pjo_information7
504: ,p_pjo_information8_o
505: => per_pjo_shd.g_old_rec.pjo_information8
506: ,p_pjo_information9_o
507: => per_pjo_shd.g_old_rec.pjo_information9
508: ,p_pjo_information10_o
509: => per_pjo_shd.g_old_rec.pjo_information10
510: ,p_pjo_information11_o
511: => per_pjo_shd.g_old_rec.pjo_information11
505: => per_pjo_shd.g_old_rec.pjo_information8
506: ,p_pjo_information9_o
507: => per_pjo_shd.g_old_rec.pjo_information9
508: ,p_pjo_information10_o
509: => per_pjo_shd.g_old_rec.pjo_information10
510: ,p_pjo_information11_o
511: => per_pjo_shd.g_old_rec.pjo_information11
512: ,p_pjo_information12_o
513: => per_pjo_shd.g_old_rec.pjo_information12
507: => per_pjo_shd.g_old_rec.pjo_information9
508: ,p_pjo_information10_o
509: => per_pjo_shd.g_old_rec.pjo_information10
510: ,p_pjo_information11_o
511: => per_pjo_shd.g_old_rec.pjo_information11
512: ,p_pjo_information12_o
513: => per_pjo_shd.g_old_rec.pjo_information12
514: ,p_pjo_information13_o
515: => per_pjo_shd.g_old_rec.pjo_information13
509: => per_pjo_shd.g_old_rec.pjo_information10
510: ,p_pjo_information11_o
511: => per_pjo_shd.g_old_rec.pjo_information11
512: ,p_pjo_information12_o
513: => per_pjo_shd.g_old_rec.pjo_information12
514: ,p_pjo_information13_o
515: => per_pjo_shd.g_old_rec.pjo_information13
516: ,p_pjo_information14_o
517: => per_pjo_shd.g_old_rec.pjo_information14
511: => per_pjo_shd.g_old_rec.pjo_information11
512: ,p_pjo_information12_o
513: => per_pjo_shd.g_old_rec.pjo_information12
514: ,p_pjo_information13_o
515: => per_pjo_shd.g_old_rec.pjo_information13
516: ,p_pjo_information14_o
517: => per_pjo_shd.g_old_rec.pjo_information14
518: ,p_pjo_information15_o
519: => per_pjo_shd.g_old_rec.pjo_information15
513: => per_pjo_shd.g_old_rec.pjo_information12
514: ,p_pjo_information13_o
515: => per_pjo_shd.g_old_rec.pjo_information13
516: ,p_pjo_information14_o
517: => per_pjo_shd.g_old_rec.pjo_information14
518: ,p_pjo_information15_o
519: => per_pjo_shd.g_old_rec.pjo_information15
520: ,p_pjo_information16_o
521: => per_pjo_shd.g_old_rec.pjo_information16
515: => per_pjo_shd.g_old_rec.pjo_information13
516: ,p_pjo_information14_o
517: => per_pjo_shd.g_old_rec.pjo_information14
518: ,p_pjo_information15_o
519: => per_pjo_shd.g_old_rec.pjo_information15
520: ,p_pjo_information16_o
521: => per_pjo_shd.g_old_rec.pjo_information16
522: ,p_pjo_information17_o
523: => per_pjo_shd.g_old_rec.pjo_information17
517: => per_pjo_shd.g_old_rec.pjo_information14
518: ,p_pjo_information15_o
519: => per_pjo_shd.g_old_rec.pjo_information15
520: ,p_pjo_information16_o
521: => per_pjo_shd.g_old_rec.pjo_information16
522: ,p_pjo_information17_o
523: => per_pjo_shd.g_old_rec.pjo_information17
524: ,p_pjo_information18_o
525: => per_pjo_shd.g_old_rec.pjo_information18
519: => per_pjo_shd.g_old_rec.pjo_information15
520: ,p_pjo_information16_o
521: => per_pjo_shd.g_old_rec.pjo_information16
522: ,p_pjo_information17_o
523: => per_pjo_shd.g_old_rec.pjo_information17
524: ,p_pjo_information18_o
525: => per_pjo_shd.g_old_rec.pjo_information18
526: ,p_pjo_information19_o
527: => per_pjo_shd.g_old_rec.pjo_information19
521: => per_pjo_shd.g_old_rec.pjo_information16
522: ,p_pjo_information17_o
523: => per_pjo_shd.g_old_rec.pjo_information17
524: ,p_pjo_information18_o
525: => per_pjo_shd.g_old_rec.pjo_information18
526: ,p_pjo_information19_o
527: => per_pjo_shd.g_old_rec.pjo_information19
528: ,p_pjo_information20_o
529: => per_pjo_shd.g_old_rec.pjo_information20
523: => per_pjo_shd.g_old_rec.pjo_information17
524: ,p_pjo_information18_o
525: => per_pjo_shd.g_old_rec.pjo_information18
526: ,p_pjo_information19_o
527: => per_pjo_shd.g_old_rec.pjo_information19
528: ,p_pjo_information20_o
529: => per_pjo_shd.g_old_rec.pjo_information20
530: ,p_pjo_information21_o
531: => per_pjo_shd.g_old_rec.pjo_information21
525: => per_pjo_shd.g_old_rec.pjo_information18
526: ,p_pjo_information19_o
527: => per_pjo_shd.g_old_rec.pjo_information19
528: ,p_pjo_information20_o
529: => per_pjo_shd.g_old_rec.pjo_information20
530: ,p_pjo_information21_o
531: => per_pjo_shd.g_old_rec.pjo_information21
532: ,p_pjo_information22_o
533: => per_pjo_shd.g_old_rec.pjo_information22
527: => per_pjo_shd.g_old_rec.pjo_information19
528: ,p_pjo_information20_o
529: => per_pjo_shd.g_old_rec.pjo_information20
530: ,p_pjo_information21_o
531: => per_pjo_shd.g_old_rec.pjo_information21
532: ,p_pjo_information22_o
533: => per_pjo_shd.g_old_rec.pjo_information22
534: ,p_pjo_information23_o
535: => per_pjo_shd.g_old_rec.pjo_information23
529: => per_pjo_shd.g_old_rec.pjo_information20
530: ,p_pjo_information21_o
531: => per_pjo_shd.g_old_rec.pjo_information21
532: ,p_pjo_information22_o
533: => per_pjo_shd.g_old_rec.pjo_information22
534: ,p_pjo_information23_o
535: => per_pjo_shd.g_old_rec.pjo_information23
536: ,p_pjo_information24_o
537: => per_pjo_shd.g_old_rec.pjo_information24
531: => per_pjo_shd.g_old_rec.pjo_information21
532: ,p_pjo_information22_o
533: => per_pjo_shd.g_old_rec.pjo_information22
534: ,p_pjo_information23_o
535: => per_pjo_shd.g_old_rec.pjo_information23
536: ,p_pjo_information24_o
537: => per_pjo_shd.g_old_rec.pjo_information24
538: ,p_pjo_information25_o
539: => per_pjo_shd.g_old_rec.pjo_information25
533: => per_pjo_shd.g_old_rec.pjo_information22
534: ,p_pjo_information23_o
535: => per_pjo_shd.g_old_rec.pjo_information23
536: ,p_pjo_information24_o
537: => per_pjo_shd.g_old_rec.pjo_information24
538: ,p_pjo_information25_o
539: => per_pjo_shd.g_old_rec.pjo_information25
540: ,p_pjo_information26_o
541: => per_pjo_shd.g_old_rec.pjo_information26
535: => per_pjo_shd.g_old_rec.pjo_information23
536: ,p_pjo_information24_o
537: => per_pjo_shd.g_old_rec.pjo_information24
538: ,p_pjo_information25_o
539: => per_pjo_shd.g_old_rec.pjo_information25
540: ,p_pjo_information26_o
541: => per_pjo_shd.g_old_rec.pjo_information26
542: ,p_pjo_information27_o
543: => per_pjo_shd.g_old_rec.pjo_information27
537: => per_pjo_shd.g_old_rec.pjo_information24
538: ,p_pjo_information25_o
539: => per_pjo_shd.g_old_rec.pjo_information25
540: ,p_pjo_information26_o
541: => per_pjo_shd.g_old_rec.pjo_information26
542: ,p_pjo_information27_o
543: => per_pjo_shd.g_old_rec.pjo_information27
544: ,p_pjo_information28_o
545: => per_pjo_shd.g_old_rec.pjo_information28
539: => per_pjo_shd.g_old_rec.pjo_information25
540: ,p_pjo_information26_o
541: => per_pjo_shd.g_old_rec.pjo_information26
542: ,p_pjo_information27_o
543: => per_pjo_shd.g_old_rec.pjo_information27
544: ,p_pjo_information28_o
545: => per_pjo_shd.g_old_rec.pjo_information28
546: ,p_pjo_information29_o
547: => per_pjo_shd.g_old_rec.pjo_information29
541: => per_pjo_shd.g_old_rec.pjo_information26
542: ,p_pjo_information27_o
543: => per_pjo_shd.g_old_rec.pjo_information27
544: ,p_pjo_information28_o
545: => per_pjo_shd.g_old_rec.pjo_information28
546: ,p_pjo_information29_o
547: => per_pjo_shd.g_old_rec.pjo_information29
548: ,p_pjo_information30_o
549: => per_pjo_shd.g_old_rec.pjo_information30
543: => per_pjo_shd.g_old_rec.pjo_information27
544: ,p_pjo_information28_o
545: => per_pjo_shd.g_old_rec.pjo_information28
546: ,p_pjo_information29_o
547: => per_pjo_shd.g_old_rec.pjo_information29
548: ,p_pjo_information30_o
549: => per_pjo_shd.g_old_rec.pjo_information30
550: ,p_object_version_number_o
551: => per_pjo_shd.g_old_rec.object_version_number
545: => per_pjo_shd.g_old_rec.pjo_information28
546: ,p_pjo_information29_o
547: => per_pjo_shd.g_old_rec.pjo_information29
548: ,p_pjo_information30_o
549: => per_pjo_shd.g_old_rec.pjo_information30
550: ,p_object_version_number_o
551: => per_pjo_shd.g_old_rec.object_version_number
552: ,p_all_assignments_o
553: => per_pjo_shd.g_old_rec.all_assignments
547: => per_pjo_shd.g_old_rec.pjo_information29
548: ,p_pjo_information30_o
549: => per_pjo_shd.g_old_rec.pjo_information30
550: ,p_object_version_number_o
551: => per_pjo_shd.g_old_rec.object_version_number
552: ,p_all_assignments_o
553: => per_pjo_shd.g_old_rec.all_assignments
554: ,p_period_months_o
555: => per_pjo_shd.g_old_rec.period_months
549: => per_pjo_shd.g_old_rec.pjo_information30
550: ,p_object_version_number_o
551: => per_pjo_shd.g_old_rec.object_version_number
552: ,p_all_assignments_o
553: => per_pjo_shd.g_old_rec.all_assignments
554: ,p_period_months_o
555: => per_pjo_shd.g_old_rec.period_months
556: );
557: --
551: => per_pjo_shd.g_old_rec.object_version_number
552: ,p_all_assignments_o
553: => per_pjo_shd.g_old_rec.all_assignments
554: ,p_period_months_o
555: => per_pjo_shd.g_old_rec.period_months
556: );
557: --
558: exception
559: --
611: --
612: -- {End Of Comments}
613: -- ----------------------------------------------------------------------------
614: Procedure convert_defs
615: (p_rec in out nocopy per_pjo_shd.g_rec_type
616: ) is
617: --
618: Begin
619: --
623: -- is being used then we must set to the 'current' argument value.
624: --
625: If (p_rec.previous_employer_id = hr_api.g_number) then
626: p_rec.previous_employer_id :=
627: per_pjo_shd.g_old_rec.previous_employer_id;
628: End If;
629: If (p_rec.start_date = hr_api.g_date) then
630: p_rec.start_date :=
631: per_pjo_shd.g_old_rec.start_date;
627: per_pjo_shd.g_old_rec.previous_employer_id;
628: End If;
629: If (p_rec.start_date = hr_api.g_date) then
630: p_rec.start_date :=
631: per_pjo_shd.g_old_rec.start_date;
632: End If;
633: If (p_rec.end_date = hr_api.g_date) then
634: p_rec.end_date :=
635: per_pjo_shd.g_old_rec.end_date;
631: per_pjo_shd.g_old_rec.start_date;
632: End If;
633: If (p_rec.end_date = hr_api.g_date) then
634: p_rec.end_date :=
635: per_pjo_shd.g_old_rec.end_date;
636: End If;
637: If (p_rec.period_years = hr_api.g_number) then
638: p_rec.period_years :=
639: per_pjo_shd.g_old_rec.period_years;
635: per_pjo_shd.g_old_rec.end_date;
636: End If;
637: If (p_rec.period_years = hr_api.g_number) then
638: p_rec.period_years :=
639: per_pjo_shd.g_old_rec.period_years;
640: End If;
641: If (p_rec.period_days = hr_api.g_number) then
642: p_rec.period_days :=
643: per_pjo_shd.g_old_rec.period_days;
639: per_pjo_shd.g_old_rec.period_years;
640: End If;
641: If (p_rec.period_days = hr_api.g_number) then
642: p_rec.period_days :=
643: per_pjo_shd.g_old_rec.period_days;
644: End If;
645: If (p_rec.job_name = hr_api.g_varchar2) then
646: p_rec.job_name :=
647: per_pjo_shd.g_old_rec.job_name;
643: per_pjo_shd.g_old_rec.period_days;
644: End If;
645: If (p_rec.job_name = hr_api.g_varchar2) then
646: p_rec.job_name :=
647: per_pjo_shd.g_old_rec.job_name;
648: End If;
649: If (p_rec.employment_category = hr_api.g_varchar2) then
650: p_rec.employment_category :=
651: per_pjo_shd.g_old_rec.employment_category;
647: per_pjo_shd.g_old_rec.job_name;
648: End If;
649: If (p_rec.employment_category = hr_api.g_varchar2) then
650: p_rec.employment_category :=
651: per_pjo_shd.g_old_rec.employment_category;
652: End If;
653: If (p_rec.description = hr_api.g_varchar2) then
654: p_rec.description :=
655: per_pjo_shd.g_old_rec.description;
651: per_pjo_shd.g_old_rec.employment_category;
652: End If;
653: If (p_rec.description = hr_api.g_varchar2) then
654: p_rec.description :=
655: per_pjo_shd.g_old_rec.description;
656: End If;
657: If (p_rec.pjo_attribute_category = hr_api.g_varchar2) then
658: p_rec.pjo_attribute_category :=
659: per_pjo_shd.g_old_rec.pjo_attribute_category;
655: per_pjo_shd.g_old_rec.description;
656: End If;
657: If (p_rec.pjo_attribute_category = hr_api.g_varchar2) then
658: p_rec.pjo_attribute_category :=
659: per_pjo_shd.g_old_rec.pjo_attribute_category;
660: End If;
661: If (p_rec.pjo_attribute1 = hr_api.g_varchar2) then
662: p_rec.pjo_attribute1 :=
663: per_pjo_shd.g_old_rec.pjo_attribute1;
659: per_pjo_shd.g_old_rec.pjo_attribute_category;
660: End If;
661: If (p_rec.pjo_attribute1 = hr_api.g_varchar2) then
662: p_rec.pjo_attribute1 :=
663: per_pjo_shd.g_old_rec.pjo_attribute1;
664: End If;
665: If (p_rec.pjo_attribute2 = hr_api.g_varchar2) then
666: p_rec.pjo_attribute2 :=
667: per_pjo_shd.g_old_rec.pjo_attribute2;
663: per_pjo_shd.g_old_rec.pjo_attribute1;
664: End If;
665: If (p_rec.pjo_attribute2 = hr_api.g_varchar2) then
666: p_rec.pjo_attribute2 :=
667: per_pjo_shd.g_old_rec.pjo_attribute2;
668: End If;
669: If (p_rec.pjo_attribute3 = hr_api.g_varchar2) then
670: p_rec.pjo_attribute3 :=
671: per_pjo_shd.g_old_rec.pjo_attribute3;
667: per_pjo_shd.g_old_rec.pjo_attribute2;
668: End If;
669: If (p_rec.pjo_attribute3 = hr_api.g_varchar2) then
670: p_rec.pjo_attribute3 :=
671: per_pjo_shd.g_old_rec.pjo_attribute3;
672: End If;
673: If (p_rec.pjo_attribute4 = hr_api.g_varchar2) then
674: p_rec.pjo_attribute4 :=
675: per_pjo_shd.g_old_rec.pjo_attribute4;
671: per_pjo_shd.g_old_rec.pjo_attribute3;
672: End If;
673: If (p_rec.pjo_attribute4 = hr_api.g_varchar2) then
674: p_rec.pjo_attribute4 :=
675: per_pjo_shd.g_old_rec.pjo_attribute4;
676: End If;
677: If (p_rec.pjo_attribute5 = hr_api.g_varchar2) then
678: p_rec.pjo_attribute5 :=
679: per_pjo_shd.g_old_rec.pjo_attribute5;
675: per_pjo_shd.g_old_rec.pjo_attribute4;
676: End If;
677: If (p_rec.pjo_attribute5 = hr_api.g_varchar2) then
678: p_rec.pjo_attribute5 :=
679: per_pjo_shd.g_old_rec.pjo_attribute5;
680: End If;
681: If (p_rec.pjo_attribute6 = hr_api.g_varchar2) then
682: p_rec.pjo_attribute6 :=
683: per_pjo_shd.g_old_rec.pjo_attribute6;
679: per_pjo_shd.g_old_rec.pjo_attribute5;
680: End If;
681: If (p_rec.pjo_attribute6 = hr_api.g_varchar2) then
682: p_rec.pjo_attribute6 :=
683: per_pjo_shd.g_old_rec.pjo_attribute6;
684: End If;
685: If (p_rec.pjo_attribute7 = hr_api.g_varchar2) then
686: p_rec.pjo_attribute7 :=
687: per_pjo_shd.g_old_rec.pjo_attribute7;
683: per_pjo_shd.g_old_rec.pjo_attribute6;
684: End If;
685: If (p_rec.pjo_attribute7 = hr_api.g_varchar2) then
686: p_rec.pjo_attribute7 :=
687: per_pjo_shd.g_old_rec.pjo_attribute7;
688: End If;
689: If (p_rec.pjo_attribute8 = hr_api.g_varchar2) then
690: p_rec.pjo_attribute8 :=
691: per_pjo_shd.g_old_rec.pjo_attribute8;
687: per_pjo_shd.g_old_rec.pjo_attribute7;
688: End If;
689: If (p_rec.pjo_attribute8 = hr_api.g_varchar2) then
690: p_rec.pjo_attribute8 :=
691: per_pjo_shd.g_old_rec.pjo_attribute8;
692: End If;
693: If (p_rec.pjo_attribute9 = hr_api.g_varchar2) then
694: p_rec.pjo_attribute9 :=
695: per_pjo_shd.g_old_rec.pjo_attribute9;
691: per_pjo_shd.g_old_rec.pjo_attribute8;
692: End If;
693: If (p_rec.pjo_attribute9 = hr_api.g_varchar2) then
694: p_rec.pjo_attribute9 :=
695: per_pjo_shd.g_old_rec.pjo_attribute9;
696: End If;
697: If (p_rec.pjo_attribute10 = hr_api.g_varchar2) then
698: p_rec.pjo_attribute10 :=
699: per_pjo_shd.g_old_rec.pjo_attribute10;
695: per_pjo_shd.g_old_rec.pjo_attribute9;
696: End If;
697: If (p_rec.pjo_attribute10 = hr_api.g_varchar2) then
698: p_rec.pjo_attribute10 :=
699: per_pjo_shd.g_old_rec.pjo_attribute10;
700: End If;
701: If (p_rec.pjo_attribute11 = hr_api.g_varchar2) then
702: p_rec.pjo_attribute11 :=
703: per_pjo_shd.g_old_rec.pjo_attribute11;
699: per_pjo_shd.g_old_rec.pjo_attribute10;
700: End If;
701: If (p_rec.pjo_attribute11 = hr_api.g_varchar2) then
702: p_rec.pjo_attribute11 :=
703: per_pjo_shd.g_old_rec.pjo_attribute11;
704: End If;
705: If (p_rec.pjo_attribute12 = hr_api.g_varchar2) then
706: p_rec.pjo_attribute12 :=
707: per_pjo_shd.g_old_rec.pjo_attribute12;
703: per_pjo_shd.g_old_rec.pjo_attribute11;
704: End If;
705: If (p_rec.pjo_attribute12 = hr_api.g_varchar2) then
706: p_rec.pjo_attribute12 :=
707: per_pjo_shd.g_old_rec.pjo_attribute12;
708: End If;
709: If (p_rec.pjo_attribute13 = hr_api.g_varchar2) then
710: p_rec.pjo_attribute13 :=
711: per_pjo_shd.g_old_rec.pjo_attribute13;
707: per_pjo_shd.g_old_rec.pjo_attribute12;
708: End If;
709: If (p_rec.pjo_attribute13 = hr_api.g_varchar2) then
710: p_rec.pjo_attribute13 :=
711: per_pjo_shd.g_old_rec.pjo_attribute13;
712: End If;
713: If (p_rec.pjo_attribute14 = hr_api.g_varchar2) then
714: p_rec.pjo_attribute14 :=
715: per_pjo_shd.g_old_rec.pjo_attribute14;
711: per_pjo_shd.g_old_rec.pjo_attribute13;
712: End If;
713: If (p_rec.pjo_attribute14 = hr_api.g_varchar2) then
714: p_rec.pjo_attribute14 :=
715: per_pjo_shd.g_old_rec.pjo_attribute14;
716: End If;
717: If (p_rec.pjo_attribute15 = hr_api.g_varchar2) then
718: p_rec.pjo_attribute15 :=
719: per_pjo_shd.g_old_rec.pjo_attribute15;
715: per_pjo_shd.g_old_rec.pjo_attribute14;
716: End If;
717: If (p_rec.pjo_attribute15 = hr_api.g_varchar2) then
718: p_rec.pjo_attribute15 :=
719: per_pjo_shd.g_old_rec.pjo_attribute15;
720: End If;
721: If (p_rec.pjo_attribute16 = hr_api.g_varchar2) then
722: p_rec.pjo_attribute16 :=
723: per_pjo_shd.g_old_rec.pjo_attribute16;
719: per_pjo_shd.g_old_rec.pjo_attribute15;
720: End If;
721: If (p_rec.pjo_attribute16 = hr_api.g_varchar2) then
722: p_rec.pjo_attribute16 :=
723: per_pjo_shd.g_old_rec.pjo_attribute16;
724: End If;
725: If (p_rec.pjo_attribute17 = hr_api.g_varchar2) then
726: p_rec.pjo_attribute17 :=
727: per_pjo_shd.g_old_rec.pjo_attribute17;
723: per_pjo_shd.g_old_rec.pjo_attribute16;
724: End If;
725: If (p_rec.pjo_attribute17 = hr_api.g_varchar2) then
726: p_rec.pjo_attribute17 :=
727: per_pjo_shd.g_old_rec.pjo_attribute17;
728: End If;
729: If (p_rec.pjo_attribute18 = hr_api.g_varchar2) then
730: p_rec.pjo_attribute18 :=
731: per_pjo_shd.g_old_rec.pjo_attribute18;
727: per_pjo_shd.g_old_rec.pjo_attribute17;
728: End If;
729: If (p_rec.pjo_attribute18 = hr_api.g_varchar2) then
730: p_rec.pjo_attribute18 :=
731: per_pjo_shd.g_old_rec.pjo_attribute18;
732: End If;
733: If (p_rec.pjo_attribute19 = hr_api.g_varchar2) then
734: p_rec.pjo_attribute19 :=
735: per_pjo_shd.g_old_rec.pjo_attribute19;
731: per_pjo_shd.g_old_rec.pjo_attribute18;
732: End If;
733: If (p_rec.pjo_attribute19 = hr_api.g_varchar2) then
734: p_rec.pjo_attribute19 :=
735: per_pjo_shd.g_old_rec.pjo_attribute19;
736: End If;
737: If (p_rec.pjo_attribute20 = hr_api.g_varchar2) then
738: p_rec.pjo_attribute20 :=
739: per_pjo_shd.g_old_rec.pjo_attribute20;
735: per_pjo_shd.g_old_rec.pjo_attribute19;
736: End If;
737: If (p_rec.pjo_attribute20 = hr_api.g_varchar2) then
738: p_rec.pjo_attribute20 :=
739: per_pjo_shd.g_old_rec.pjo_attribute20;
740: End If;
741: If (p_rec.pjo_attribute21 = hr_api.g_varchar2) then
742: p_rec.pjo_attribute21 :=
743: per_pjo_shd.g_old_rec.pjo_attribute21;
739: per_pjo_shd.g_old_rec.pjo_attribute20;
740: End If;
741: If (p_rec.pjo_attribute21 = hr_api.g_varchar2) then
742: p_rec.pjo_attribute21 :=
743: per_pjo_shd.g_old_rec.pjo_attribute21;
744: End If;
745: If (p_rec.pjo_attribute22 = hr_api.g_varchar2) then
746: p_rec.pjo_attribute22 :=
747: per_pjo_shd.g_old_rec.pjo_attribute22;
743: per_pjo_shd.g_old_rec.pjo_attribute21;
744: End If;
745: If (p_rec.pjo_attribute22 = hr_api.g_varchar2) then
746: p_rec.pjo_attribute22 :=
747: per_pjo_shd.g_old_rec.pjo_attribute22;
748: End If;
749: If (p_rec.pjo_attribute23 = hr_api.g_varchar2) then
750: p_rec.pjo_attribute23 :=
751: per_pjo_shd.g_old_rec.pjo_attribute23;
747: per_pjo_shd.g_old_rec.pjo_attribute22;
748: End If;
749: If (p_rec.pjo_attribute23 = hr_api.g_varchar2) then
750: p_rec.pjo_attribute23 :=
751: per_pjo_shd.g_old_rec.pjo_attribute23;
752: End If;
753: If (p_rec.pjo_attribute24 = hr_api.g_varchar2) then
754: p_rec.pjo_attribute24 :=
755: per_pjo_shd.g_old_rec.pjo_attribute24;
751: per_pjo_shd.g_old_rec.pjo_attribute23;
752: End If;
753: If (p_rec.pjo_attribute24 = hr_api.g_varchar2) then
754: p_rec.pjo_attribute24 :=
755: per_pjo_shd.g_old_rec.pjo_attribute24;
756: End If;
757: If (p_rec.pjo_attribute25 = hr_api.g_varchar2) then
758: p_rec.pjo_attribute25 :=
759: per_pjo_shd.g_old_rec.pjo_attribute25;
755: per_pjo_shd.g_old_rec.pjo_attribute24;
756: End If;
757: If (p_rec.pjo_attribute25 = hr_api.g_varchar2) then
758: p_rec.pjo_attribute25 :=
759: per_pjo_shd.g_old_rec.pjo_attribute25;
760: End If;
761: If (p_rec.pjo_attribute26 = hr_api.g_varchar2) then
762: p_rec.pjo_attribute26 :=
763: per_pjo_shd.g_old_rec.pjo_attribute26;
759: per_pjo_shd.g_old_rec.pjo_attribute25;
760: End If;
761: If (p_rec.pjo_attribute26 = hr_api.g_varchar2) then
762: p_rec.pjo_attribute26 :=
763: per_pjo_shd.g_old_rec.pjo_attribute26;
764: End If;
765: If (p_rec.pjo_attribute27 = hr_api.g_varchar2) then
766: p_rec.pjo_attribute27 :=
767: per_pjo_shd.g_old_rec.pjo_attribute27;
763: per_pjo_shd.g_old_rec.pjo_attribute26;
764: End If;
765: If (p_rec.pjo_attribute27 = hr_api.g_varchar2) then
766: p_rec.pjo_attribute27 :=
767: per_pjo_shd.g_old_rec.pjo_attribute27;
768: End If;
769: If (p_rec.pjo_attribute28 = hr_api.g_varchar2) then
770: p_rec.pjo_attribute28 :=
771: per_pjo_shd.g_old_rec.pjo_attribute28;
767: per_pjo_shd.g_old_rec.pjo_attribute27;
768: End If;
769: If (p_rec.pjo_attribute28 = hr_api.g_varchar2) then
770: p_rec.pjo_attribute28 :=
771: per_pjo_shd.g_old_rec.pjo_attribute28;
772: End If;
773: If (p_rec.pjo_attribute29 = hr_api.g_varchar2) then
774: p_rec.pjo_attribute29 :=
775: per_pjo_shd.g_old_rec.pjo_attribute29;
771: per_pjo_shd.g_old_rec.pjo_attribute28;
772: End If;
773: If (p_rec.pjo_attribute29 = hr_api.g_varchar2) then
774: p_rec.pjo_attribute29 :=
775: per_pjo_shd.g_old_rec.pjo_attribute29;
776: End If;
777: If (p_rec.pjo_attribute30 = hr_api.g_varchar2) then
778: p_rec.pjo_attribute30 :=
779: per_pjo_shd.g_old_rec.pjo_attribute30;
775: per_pjo_shd.g_old_rec.pjo_attribute29;
776: End If;
777: If (p_rec.pjo_attribute30 = hr_api.g_varchar2) then
778: p_rec.pjo_attribute30 :=
779: per_pjo_shd.g_old_rec.pjo_attribute30;
780: End If;
781: If (p_rec.pjo_information_category = hr_api.g_varchar2) then
782: p_rec.pjo_information_category :=
783: per_pjo_shd.g_old_rec.pjo_information_category;
779: per_pjo_shd.g_old_rec.pjo_attribute30;
780: End If;
781: If (p_rec.pjo_information_category = hr_api.g_varchar2) then
782: p_rec.pjo_information_category :=
783: per_pjo_shd.g_old_rec.pjo_information_category;
784: End If;
785: If (p_rec.pjo_information1 = hr_api.g_varchar2) then
786: p_rec.pjo_information1 :=
787: per_pjo_shd.g_old_rec.pjo_information1;
783: per_pjo_shd.g_old_rec.pjo_information_category;
784: End If;
785: If (p_rec.pjo_information1 = hr_api.g_varchar2) then
786: p_rec.pjo_information1 :=
787: per_pjo_shd.g_old_rec.pjo_information1;
788: End If;
789: If (p_rec.pjo_information2 = hr_api.g_varchar2) then
790: p_rec.pjo_information2 :=
791: per_pjo_shd.g_old_rec.pjo_information2;
787: per_pjo_shd.g_old_rec.pjo_information1;
788: End If;
789: If (p_rec.pjo_information2 = hr_api.g_varchar2) then
790: p_rec.pjo_information2 :=
791: per_pjo_shd.g_old_rec.pjo_information2;
792: End If;
793: If (p_rec.pjo_information3 = hr_api.g_varchar2) then
794: p_rec.pjo_information3 :=
795: per_pjo_shd.g_old_rec.pjo_information3;
791: per_pjo_shd.g_old_rec.pjo_information2;
792: End If;
793: If (p_rec.pjo_information3 = hr_api.g_varchar2) then
794: p_rec.pjo_information3 :=
795: per_pjo_shd.g_old_rec.pjo_information3;
796: End If;
797: If (p_rec.pjo_information4 = hr_api.g_varchar2) then
798: p_rec.pjo_information4 :=
799: per_pjo_shd.g_old_rec.pjo_information4;
795: per_pjo_shd.g_old_rec.pjo_information3;
796: End If;
797: If (p_rec.pjo_information4 = hr_api.g_varchar2) then
798: p_rec.pjo_information4 :=
799: per_pjo_shd.g_old_rec.pjo_information4;
800: End If;
801: If (p_rec.pjo_information5 = hr_api.g_varchar2) then
802: p_rec.pjo_information5 :=
803: per_pjo_shd.g_old_rec.pjo_information5;
799: per_pjo_shd.g_old_rec.pjo_information4;
800: End If;
801: If (p_rec.pjo_information5 = hr_api.g_varchar2) then
802: p_rec.pjo_information5 :=
803: per_pjo_shd.g_old_rec.pjo_information5;
804: End If;
805: If (p_rec.pjo_information6 = hr_api.g_varchar2) then
806: p_rec.pjo_information6 :=
807: per_pjo_shd.g_old_rec.pjo_information6;
803: per_pjo_shd.g_old_rec.pjo_information5;
804: End If;
805: If (p_rec.pjo_information6 = hr_api.g_varchar2) then
806: p_rec.pjo_information6 :=
807: per_pjo_shd.g_old_rec.pjo_information6;
808: End If;
809: If (p_rec.pjo_information7 = hr_api.g_varchar2) then
810: p_rec.pjo_information7 :=
811: per_pjo_shd.g_old_rec.pjo_information7;
807: per_pjo_shd.g_old_rec.pjo_information6;
808: End If;
809: If (p_rec.pjo_information7 = hr_api.g_varchar2) then
810: p_rec.pjo_information7 :=
811: per_pjo_shd.g_old_rec.pjo_information7;
812: End If;
813: If (p_rec.pjo_information8 = hr_api.g_varchar2) then
814: p_rec.pjo_information8 :=
815: per_pjo_shd.g_old_rec.pjo_information8;
811: per_pjo_shd.g_old_rec.pjo_information7;
812: End If;
813: If (p_rec.pjo_information8 = hr_api.g_varchar2) then
814: p_rec.pjo_information8 :=
815: per_pjo_shd.g_old_rec.pjo_information8;
816: End If;
817: If (p_rec.pjo_information9 = hr_api.g_varchar2) then
818: p_rec.pjo_information9 :=
819: per_pjo_shd.g_old_rec.pjo_information9;
815: per_pjo_shd.g_old_rec.pjo_information8;
816: End If;
817: If (p_rec.pjo_information9 = hr_api.g_varchar2) then
818: p_rec.pjo_information9 :=
819: per_pjo_shd.g_old_rec.pjo_information9;
820: End If;
821: If (p_rec.pjo_information10 = hr_api.g_varchar2) then
822: p_rec.pjo_information10 :=
823: per_pjo_shd.g_old_rec.pjo_information10;
819: per_pjo_shd.g_old_rec.pjo_information9;
820: End If;
821: If (p_rec.pjo_information10 = hr_api.g_varchar2) then
822: p_rec.pjo_information10 :=
823: per_pjo_shd.g_old_rec.pjo_information10;
824: End If;
825: If (p_rec.pjo_information11 = hr_api.g_varchar2) then
826: p_rec.pjo_information11 :=
827: per_pjo_shd.g_old_rec.pjo_information11;
823: per_pjo_shd.g_old_rec.pjo_information10;
824: End If;
825: If (p_rec.pjo_information11 = hr_api.g_varchar2) then
826: p_rec.pjo_information11 :=
827: per_pjo_shd.g_old_rec.pjo_information11;
828: End If;
829: If (p_rec.pjo_information12 = hr_api.g_varchar2) then
830: p_rec.pjo_information12 :=
831: per_pjo_shd.g_old_rec.pjo_information12;
827: per_pjo_shd.g_old_rec.pjo_information11;
828: End If;
829: If (p_rec.pjo_information12 = hr_api.g_varchar2) then
830: p_rec.pjo_information12 :=
831: per_pjo_shd.g_old_rec.pjo_information12;
832: End If;
833: If (p_rec.pjo_information13 = hr_api.g_varchar2) then
834: p_rec.pjo_information13 :=
835: per_pjo_shd.g_old_rec.pjo_information13;
831: per_pjo_shd.g_old_rec.pjo_information12;
832: End If;
833: If (p_rec.pjo_information13 = hr_api.g_varchar2) then
834: p_rec.pjo_information13 :=
835: per_pjo_shd.g_old_rec.pjo_information13;
836: End If;
837: If (p_rec.pjo_information14 = hr_api.g_varchar2) then
838: p_rec.pjo_information14 :=
839: per_pjo_shd.g_old_rec.pjo_information14;
835: per_pjo_shd.g_old_rec.pjo_information13;
836: End If;
837: If (p_rec.pjo_information14 = hr_api.g_varchar2) then
838: p_rec.pjo_information14 :=
839: per_pjo_shd.g_old_rec.pjo_information14;
840: End If;
841: If (p_rec.pjo_information15 = hr_api.g_varchar2) then
842: p_rec.pjo_information15 :=
843: per_pjo_shd.g_old_rec.pjo_information15;
839: per_pjo_shd.g_old_rec.pjo_information14;
840: End If;
841: If (p_rec.pjo_information15 = hr_api.g_varchar2) then
842: p_rec.pjo_information15 :=
843: per_pjo_shd.g_old_rec.pjo_information15;
844: End If;
845: If (p_rec.pjo_information16 = hr_api.g_varchar2) then
846: p_rec.pjo_information16 :=
847: per_pjo_shd.g_old_rec.pjo_information16;
843: per_pjo_shd.g_old_rec.pjo_information15;
844: End If;
845: If (p_rec.pjo_information16 = hr_api.g_varchar2) then
846: p_rec.pjo_information16 :=
847: per_pjo_shd.g_old_rec.pjo_information16;
848: End If;
849: If (p_rec.pjo_information17 = hr_api.g_varchar2) then
850: p_rec.pjo_information17 :=
851: per_pjo_shd.g_old_rec.pjo_information17;
847: per_pjo_shd.g_old_rec.pjo_information16;
848: End If;
849: If (p_rec.pjo_information17 = hr_api.g_varchar2) then
850: p_rec.pjo_information17 :=
851: per_pjo_shd.g_old_rec.pjo_information17;
852: End If;
853: If (p_rec.pjo_information18 = hr_api.g_varchar2) then
854: p_rec.pjo_information18 :=
855: per_pjo_shd.g_old_rec.pjo_information18;
851: per_pjo_shd.g_old_rec.pjo_information17;
852: End If;
853: If (p_rec.pjo_information18 = hr_api.g_varchar2) then
854: p_rec.pjo_information18 :=
855: per_pjo_shd.g_old_rec.pjo_information18;
856: End If;
857: If (p_rec.pjo_information19 = hr_api.g_varchar2) then
858: p_rec.pjo_information19 :=
859: per_pjo_shd.g_old_rec.pjo_information19;
855: per_pjo_shd.g_old_rec.pjo_information18;
856: End If;
857: If (p_rec.pjo_information19 = hr_api.g_varchar2) then
858: p_rec.pjo_information19 :=
859: per_pjo_shd.g_old_rec.pjo_information19;
860: End If;
861: If (p_rec.pjo_information20 = hr_api.g_varchar2) then
862: p_rec.pjo_information20 :=
863: per_pjo_shd.g_old_rec.pjo_information20;
859: per_pjo_shd.g_old_rec.pjo_information19;
860: End If;
861: If (p_rec.pjo_information20 = hr_api.g_varchar2) then
862: p_rec.pjo_information20 :=
863: per_pjo_shd.g_old_rec.pjo_information20;
864: End If;
865: If (p_rec.pjo_information21 = hr_api.g_varchar2) then
866: p_rec.pjo_information21 :=
867: per_pjo_shd.g_old_rec.pjo_information21;
863: per_pjo_shd.g_old_rec.pjo_information20;
864: End If;
865: If (p_rec.pjo_information21 = hr_api.g_varchar2) then
866: p_rec.pjo_information21 :=
867: per_pjo_shd.g_old_rec.pjo_information21;
868: End If;
869: If (p_rec.pjo_information22 = hr_api.g_varchar2) then
870: p_rec.pjo_information22 :=
871: per_pjo_shd.g_old_rec.pjo_information22;
867: per_pjo_shd.g_old_rec.pjo_information21;
868: End If;
869: If (p_rec.pjo_information22 = hr_api.g_varchar2) then
870: p_rec.pjo_information22 :=
871: per_pjo_shd.g_old_rec.pjo_information22;
872: End If;
873: If (p_rec.pjo_information23 = hr_api.g_varchar2) then
874: p_rec.pjo_information23 :=
875: per_pjo_shd.g_old_rec.pjo_information23;
871: per_pjo_shd.g_old_rec.pjo_information22;
872: End If;
873: If (p_rec.pjo_information23 = hr_api.g_varchar2) then
874: p_rec.pjo_information23 :=
875: per_pjo_shd.g_old_rec.pjo_information23;
876: End If;
877: If (p_rec.pjo_information24 = hr_api.g_varchar2) then
878: p_rec.pjo_information24 :=
879: per_pjo_shd.g_old_rec.pjo_information24;
875: per_pjo_shd.g_old_rec.pjo_information23;
876: End If;
877: If (p_rec.pjo_information24 = hr_api.g_varchar2) then
878: p_rec.pjo_information24 :=
879: per_pjo_shd.g_old_rec.pjo_information24;
880: End If;
881: If (p_rec.pjo_information25 = hr_api.g_varchar2) then
882: p_rec.pjo_information25 :=
883: per_pjo_shd.g_old_rec.pjo_information25;
879: per_pjo_shd.g_old_rec.pjo_information24;
880: End If;
881: If (p_rec.pjo_information25 = hr_api.g_varchar2) then
882: p_rec.pjo_information25 :=
883: per_pjo_shd.g_old_rec.pjo_information25;
884: End If;
885: If (p_rec.pjo_information26 = hr_api.g_varchar2) then
886: p_rec.pjo_information26 :=
887: per_pjo_shd.g_old_rec.pjo_information26;
883: per_pjo_shd.g_old_rec.pjo_information25;
884: End If;
885: If (p_rec.pjo_information26 = hr_api.g_varchar2) then
886: p_rec.pjo_information26 :=
887: per_pjo_shd.g_old_rec.pjo_information26;
888: End If;
889: If (p_rec.pjo_information27 = hr_api.g_varchar2) then
890: p_rec.pjo_information27 :=
891: per_pjo_shd.g_old_rec.pjo_information27;
887: per_pjo_shd.g_old_rec.pjo_information26;
888: End If;
889: If (p_rec.pjo_information27 = hr_api.g_varchar2) then
890: p_rec.pjo_information27 :=
891: per_pjo_shd.g_old_rec.pjo_information27;
892: End If;
893: If (p_rec.pjo_information28 = hr_api.g_varchar2) then
894: p_rec.pjo_information28 :=
895: per_pjo_shd.g_old_rec.pjo_information28;
891: per_pjo_shd.g_old_rec.pjo_information27;
892: End If;
893: If (p_rec.pjo_information28 = hr_api.g_varchar2) then
894: p_rec.pjo_information28 :=
895: per_pjo_shd.g_old_rec.pjo_information28;
896: End If;
897: If (p_rec.pjo_information29 = hr_api.g_varchar2) then
898: p_rec.pjo_information29 :=
899: per_pjo_shd.g_old_rec.pjo_information29;
895: per_pjo_shd.g_old_rec.pjo_information28;
896: End If;
897: If (p_rec.pjo_information29 = hr_api.g_varchar2) then
898: p_rec.pjo_information29 :=
899: per_pjo_shd.g_old_rec.pjo_information29;
900: End If;
901: If (p_rec.pjo_information30 = hr_api.g_varchar2) then
902: p_rec.pjo_information30 :=
903: per_pjo_shd.g_old_rec.pjo_information30;
899: per_pjo_shd.g_old_rec.pjo_information29;
900: End If;
901: If (p_rec.pjo_information30 = hr_api.g_varchar2) then
902: p_rec.pjo_information30 :=
903: per_pjo_shd.g_old_rec.pjo_information30;
904: End If;
905: If (p_rec.all_assignments = hr_api.g_varchar2) then
906: p_rec.all_assignments :=
907: per_pjo_shd.g_old_rec.all_assignments;
903: per_pjo_shd.g_old_rec.pjo_information30;
904: End If;
905: If (p_rec.all_assignments = hr_api.g_varchar2) then
906: p_rec.all_assignments :=
907: per_pjo_shd.g_old_rec.all_assignments;
908: End If;
909: If (p_rec.period_months = hr_api.g_number) then
910: p_rec.period_months :=
911: per_pjo_shd.g_old_rec.period_months;
907: per_pjo_shd.g_old_rec.all_assignments;
908: End If;
909: If (p_rec.period_months = hr_api.g_number) then
910: p_rec.period_months :=
911: per_pjo_shd.g_old_rec.period_months;
912: End If;
913: --
914: End convert_defs;
915: --
917: -- |---------------------------------< upd >----------------------------------|
918: -- ----------------------------------------------------------------------------
919: Procedure upd
920: (p_effective_date in date
921: ,p_rec in out nocopy per_pjo_shd.g_rec_type
922: ) is
923: --
924: l_proc varchar2(72) := g_package||'upd';
925: --
927: hr_utility.set_location('Entering:'||l_proc, 5);
928: --
929: -- We must lock the row which we need to update.
930: --
931: per_pjo_shd.lck
932: (p_rec.previous_job_id
933: ,p_rec.object_version_number
934: );
935: --
1046: ,p_all_assignments in varchar2 default hr_api.g_varchar2
1047: ,p_period_months in number default hr_api.g_number
1048: ) is
1049: --
1050: l_rec per_pjo_shd.g_rec_type;
1051: l_proc varchar2(72) := g_package||'upd';
1052: --
1053: Begin
1054: hr_utility.set_location('Entering:'||l_proc, 5);
1056: -- Call conversion function to turn arguments into the
1057: -- l_rec structure.
1058: --
1059: l_rec :=
1060: per_pjo_shd.convert_args
1061: (p_previous_job_id
1062: ,p_previous_employer_id
1063: ,p_start_date
1064: ,p_end_date