APPS.PER_DPF_UPD dependencies on HR_API

Line 133: When hr_api.check_integrity_violated Then

129: --
130: hr_utility.set_location(' Leaving:'||l_proc, 10);
131: --
132: Exception
133: When hr_api.check_integrity_violated Then
134: -- A check constraint has been violated
135: per_dpf_shd.g_api_dml := false; -- Unset the api dml status
136: per_dpf_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

133: When hr_api.check_integrity_violated Then
134: -- A check constraint has been violated
135: per_dpf_shd.g_api_dml := false; -- Unset the api dml status
136: per_dpf_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.parent_integrity_violated Then
139: -- Parent integrity has been violated
140: per_dpf_shd.g_api_dml := false; -- Unset the api dml status
141: per_dpf_shd.constraint_error

Line 138: When hr_api.parent_integrity_violated Then

134: -- A check constraint has been violated
135: per_dpf_shd.g_api_dml := false; -- Unset the api dml status
136: per_dpf_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.parent_integrity_violated Then
139: -- Parent integrity has been violated
140: per_dpf_shd.g_api_dml := false; -- Unset the api dml status
141: per_dpf_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

138: When hr_api.parent_integrity_violated Then
139: -- Parent integrity has been violated
140: per_dpf_shd.g_api_dml := false; -- Unset the api dml status
141: per_dpf_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
145: per_dpf_shd.g_api_dml := false; -- Unset the api dml status
146: per_dpf_shd.constraint_error

Line 143: When hr_api.unique_integrity_violated Then

139: -- Parent integrity has been violated
140: per_dpf_shd.g_api_dml := false; -- Unset the api dml status
141: per_dpf_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
145: per_dpf_shd.g_api_dml := false; -- Unset the api dml status
146: per_dpf_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
145: per_dpf_shd.g_api_dml := false; -- Unset the api dml status
146: per_dpf_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When Others Then
149: per_dpf_shd.g_api_dml := false; -- Unset the api dml status
150: Raise;
151: End update_dml;

Line 347: when hr_api.cannot_find_prog_unit then

343: p_attribute19_o =>per_dpf_shd.g_old_rec.attribute19,
344: p_attribute20_o =>per_dpf_shd.g_old_rec.attribute20
345: );
346: exception
347: when hr_api.cannot_find_prog_unit then
348: hr_api.cannot_find_prog_unit_error
349: (
350: p_module_name => 'PER_DEPLOYMENT_FACTORS',
351: p_hook_type => 'AU'

Line 348: hr_api.cannot_find_prog_unit_error

344: p_attribute20_o =>per_dpf_shd.g_old_rec.attribute20
345: );
346: exception
347: when hr_api.cannot_find_prog_unit then
348: hr_api.cannot_find_prog_unit_error
349: (
350: p_module_name => 'PER_DEPLOYMENT_FACTORS',
351: p_hook_type => 'AU'
352: );

Line 415: If (p_rec.position_id = hr_api.g_number) then

411: -- p_rec plsql record structure
412: -- to see if a system default is being used. If a system default
413: -- is being used then we must set to the 'current' argument value.
414: --
415: If (p_rec.position_id = hr_api.g_number) then
416: p_rec.position_id :=
417: per_dpf_shd.g_old_rec.position_id;
418: End If;
419: If (p_rec.person_id = hr_api.g_number) then

Line 419: If (p_rec.person_id = hr_api.g_number) then

415: If (p_rec.position_id = hr_api.g_number) then
416: p_rec.position_id :=
417: per_dpf_shd.g_old_rec.position_id;
418: End If;
419: If (p_rec.person_id = hr_api.g_number) then
420: p_rec.person_id :=
421: per_dpf_shd.g_old_rec.person_id;
422: End If;
423: If (p_rec.job_id = hr_api.g_number) then

Line 423: If (p_rec.job_id = hr_api.g_number) then

419: If (p_rec.person_id = hr_api.g_number) then
420: p_rec.person_id :=
421: per_dpf_shd.g_old_rec.person_id;
422: End If;
423: If (p_rec.job_id = hr_api.g_number) then
424: p_rec.job_id :=
425: per_dpf_shd.g_old_rec.job_id;
426: End If;
427: If (p_rec.business_group_id = hr_api.g_number) then

Line 427: If (p_rec.business_group_id = hr_api.g_number) then

423: If (p_rec.job_id = hr_api.g_number) then
424: p_rec.job_id :=
425: per_dpf_shd.g_old_rec.job_id;
426: End If;
427: If (p_rec.business_group_id = hr_api.g_number) then
428: p_rec.business_group_id :=
429: per_dpf_shd.g_old_rec.business_group_id;
430: End If;
431: If (p_rec.work_any_country = hr_api.g_varchar2) then

Line 431: If (p_rec.work_any_country = hr_api.g_varchar2) then

427: If (p_rec.business_group_id = hr_api.g_number) then
428: p_rec.business_group_id :=
429: per_dpf_shd.g_old_rec.business_group_id;
430: End If;
431: If (p_rec.work_any_country = hr_api.g_varchar2) then
432: p_rec.work_any_country :=
433: per_dpf_shd.g_old_rec.work_any_country;
434: End If;
435: If (p_rec.work_any_location = hr_api.g_varchar2) then

Line 435: If (p_rec.work_any_location = hr_api.g_varchar2) then

431: If (p_rec.work_any_country = hr_api.g_varchar2) then
432: p_rec.work_any_country :=
433: per_dpf_shd.g_old_rec.work_any_country;
434: End If;
435: If (p_rec.work_any_location = hr_api.g_varchar2) then
436: p_rec.work_any_location :=
437: per_dpf_shd.g_old_rec.work_any_location;
438: End If;
439: If (p_rec.relocate_domestically = hr_api.g_varchar2) then

Line 439: If (p_rec.relocate_domestically = hr_api.g_varchar2) then

435: If (p_rec.work_any_location = hr_api.g_varchar2) then
436: p_rec.work_any_location :=
437: per_dpf_shd.g_old_rec.work_any_location;
438: End If;
439: If (p_rec.relocate_domestically = hr_api.g_varchar2) then
440: p_rec.relocate_domestically :=
441: per_dpf_shd.g_old_rec.relocate_domestically;
442: End If;
443: If (p_rec.relocate_internationally = hr_api.g_varchar2) then

Line 443: If (p_rec.relocate_internationally = hr_api.g_varchar2) then

439: If (p_rec.relocate_domestically = hr_api.g_varchar2) then
440: p_rec.relocate_domestically :=
441: per_dpf_shd.g_old_rec.relocate_domestically;
442: End If;
443: If (p_rec.relocate_internationally = hr_api.g_varchar2) then
444: p_rec.relocate_internationally :=
445: per_dpf_shd.g_old_rec.relocate_internationally;
446: End If;
447: If (p_rec.travel_required = hr_api.g_varchar2) then

Line 447: If (p_rec.travel_required = hr_api.g_varchar2) then

443: If (p_rec.relocate_internationally = hr_api.g_varchar2) then
444: p_rec.relocate_internationally :=
445: per_dpf_shd.g_old_rec.relocate_internationally;
446: End If;
447: If (p_rec.travel_required = hr_api.g_varchar2) then
448: p_rec.travel_required :=
449: per_dpf_shd.g_old_rec.travel_required;
450: End If;
451: If (p_rec.country1 = hr_api.g_varchar2) then

Line 451: If (p_rec.country1 = hr_api.g_varchar2) then

447: If (p_rec.travel_required = hr_api.g_varchar2) then
448: p_rec.travel_required :=
449: per_dpf_shd.g_old_rec.travel_required;
450: End If;
451: If (p_rec.country1 = hr_api.g_varchar2) then
452: p_rec.country1 :=
453: per_dpf_shd.g_old_rec.country1;
454: End If;
455: If (p_rec.country2 = hr_api.g_varchar2) then

Line 455: If (p_rec.country2 = hr_api.g_varchar2) then

451: If (p_rec.country1 = hr_api.g_varchar2) then
452: p_rec.country1 :=
453: per_dpf_shd.g_old_rec.country1;
454: End If;
455: If (p_rec.country2 = hr_api.g_varchar2) then
456: p_rec.country2 :=
457: per_dpf_shd.g_old_rec.country2;
458: End If;
459: If (p_rec.country3 = hr_api.g_varchar2) then

Line 459: If (p_rec.country3 = hr_api.g_varchar2) then

455: If (p_rec.country2 = hr_api.g_varchar2) then
456: p_rec.country2 :=
457: per_dpf_shd.g_old_rec.country2;
458: End If;
459: If (p_rec.country3 = hr_api.g_varchar2) then
460: p_rec.country3 :=
461: per_dpf_shd.g_old_rec.country3;
462: End If;
463: If (p_rec.work_duration = hr_api.g_varchar2) then

Line 463: If (p_rec.work_duration = hr_api.g_varchar2) then

459: If (p_rec.country3 = hr_api.g_varchar2) then
460: p_rec.country3 :=
461: per_dpf_shd.g_old_rec.country3;
462: End If;
463: If (p_rec.work_duration = hr_api.g_varchar2) then
464: p_rec.work_duration :=
465: per_dpf_shd.g_old_rec.work_duration;
466: End If;
467: If (p_rec.work_schedule = hr_api.g_varchar2) then

Line 467: If (p_rec.work_schedule = hr_api.g_varchar2) then

463: If (p_rec.work_duration = hr_api.g_varchar2) then
464: p_rec.work_duration :=
465: per_dpf_shd.g_old_rec.work_duration;
466: End If;
467: If (p_rec.work_schedule = hr_api.g_varchar2) then
468: p_rec.work_schedule :=
469: per_dpf_shd.g_old_rec.work_schedule;
470: End If;
471: If (p_rec.work_hours = hr_api.g_varchar2) then

Line 471: If (p_rec.work_hours = hr_api.g_varchar2) then

467: If (p_rec.work_schedule = hr_api.g_varchar2) then
468: p_rec.work_schedule :=
469: per_dpf_shd.g_old_rec.work_schedule;
470: End If;
471: If (p_rec.work_hours = hr_api.g_varchar2) then
472: p_rec.work_hours :=
473: per_dpf_shd.g_old_rec.work_hours;
474: End If;
475: If (p_rec.fte_capacity = hr_api.g_varchar2) then

Line 475: If (p_rec.fte_capacity = hr_api.g_varchar2) then

471: If (p_rec.work_hours = hr_api.g_varchar2) then
472: p_rec.work_hours :=
473: per_dpf_shd.g_old_rec.work_hours;
474: End If;
475: If (p_rec.fte_capacity = hr_api.g_varchar2) then
476: p_rec.fte_capacity :=
477: per_dpf_shd.g_old_rec.fte_capacity;
478: End If;
479: If (p_rec.visit_internationally = hr_api.g_varchar2) then

Line 479: If (p_rec.visit_internationally = hr_api.g_varchar2) then

475: If (p_rec.fte_capacity = hr_api.g_varchar2) then
476: p_rec.fte_capacity :=
477: per_dpf_shd.g_old_rec.fte_capacity;
478: End If;
479: If (p_rec.visit_internationally = hr_api.g_varchar2) then
480: p_rec.visit_internationally :=
481: per_dpf_shd.g_old_rec.visit_internationally;
482: End If;
483: If (p_rec.only_current_location = hr_api.g_varchar2) then

Line 483: If (p_rec.only_current_location = hr_api.g_varchar2) then

479: If (p_rec.visit_internationally = hr_api.g_varchar2) then
480: p_rec.visit_internationally :=
481: per_dpf_shd.g_old_rec.visit_internationally;
482: End If;
483: If (p_rec.only_current_location = hr_api.g_varchar2) then
484: p_rec.only_current_location :=
485: per_dpf_shd.g_old_rec.only_current_location;
486: End If;
487: If (p_rec.no_country1 = hr_api.g_varchar2) then

Line 487: If (p_rec.no_country1 = hr_api.g_varchar2) then

483: If (p_rec.only_current_location = hr_api.g_varchar2) then
484: p_rec.only_current_location :=
485: per_dpf_shd.g_old_rec.only_current_location;
486: End If;
487: If (p_rec.no_country1 = hr_api.g_varchar2) then
488: p_rec.no_country1 :=
489: per_dpf_shd.g_old_rec.no_country1;
490: End If;
491: If (p_rec.no_country2 = hr_api.g_varchar2) then

Line 491: If (p_rec.no_country2 = hr_api.g_varchar2) then

487: If (p_rec.no_country1 = hr_api.g_varchar2) then
488: p_rec.no_country1 :=
489: per_dpf_shd.g_old_rec.no_country1;
490: End If;
491: If (p_rec.no_country2 = hr_api.g_varchar2) then
492: p_rec.no_country2 :=
493: per_dpf_shd.g_old_rec.no_country2;
494: End If;
495: If (p_rec.no_country3 = hr_api.g_varchar2) then

Line 495: If (p_rec.no_country3 = hr_api.g_varchar2) then

491: If (p_rec.no_country2 = hr_api.g_varchar2) then
492: p_rec.no_country2 :=
493: per_dpf_shd.g_old_rec.no_country2;
494: End If;
495: If (p_rec.no_country3 = hr_api.g_varchar2) then
496: p_rec.no_country3 :=
497: per_dpf_shd.g_old_rec.no_country3;
498: End If;
499: If (p_rec.comments = hr_api.g_varchar2) then

Line 499: If (p_rec.comments = hr_api.g_varchar2) then

495: If (p_rec.no_country3 = hr_api.g_varchar2) then
496: p_rec.no_country3 :=
497: per_dpf_shd.g_old_rec.no_country3;
498: End If;
499: If (p_rec.comments = hr_api.g_varchar2) then
500: p_rec.comments :=
501: per_dpf_shd.g_old_rec.comments;
502: End If;
503: If (p_rec.earliest_available_date = hr_api.g_date) then

Line 503: If (p_rec.earliest_available_date = hr_api.g_date) then

499: If (p_rec.comments = hr_api.g_varchar2) then
500: p_rec.comments :=
501: per_dpf_shd.g_old_rec.comments;
502: End If;
503: If (p_rec.earliest_available_date = hr_api.g_date) then
504: p_rec.earliest_available_date :=
505: per_dpf_shd.g_old_rec.earliest_available_date;
506: End If;
507: If (p_rec.available_for_transfer = hr_api.g_varchar2) then

Line 507: If (p_rec.available_for_transfer = hr_api.g_varchar2) then

503: If (p_rec.earliest_available_date = hr_api.g_date) then
504: p_rec.earliest_available_date :=
505: per_dpf_shd.g_old_rec.earliest_available_date;
506: End If;
507: If (p_rec.available_for_transfer = hr_api.g_varchar2) then
508: p_rec.available_for_transfer :=
509: per_dpf_shd.g_old_rec.available_for_transfer;
510: End If;
511: If (p_rec.relocation_preference = hr_api.g_varchar2) then

Line 511: If (p_rec.relocation_preference = hr_api.g_varchar2) then

507: If (p_rec.available_for_transfer = hr_api.g_varchar2) then
508: p_rec.available_for_transfer :=
509: per_dpf_shd.g_old_rec.available_for_transfer;
510: End If;
511: If (p_rec.relocation_preference = hr_api.g_varchar2) then
512: p_rec.relocation_preference :=
513: per_dpf_shd.g_old_rec.relocation_preference;
514: End If;
515: If (p_rec.relocation_required = hr_api.g_varchar2) then

Line 515: If (p_rec.relocation_required = hr_api.g_varchar2) then

511: If (p_rec.relocation_preference = hr_api.g_varchar2) then
512: p_rec.relocation_preference :=
513: per_dpf_shd.g_old_rec.relocation_preference;
514: End If;
515: If (p_rec.relocation_required = hr_api.g_varchar2) then
516: p_rec.relocation_required :=
517: per_dpf_shd.g_old_rec.relocation_required;
518: End If;
519: If (p_rec.passport_required = hr_api.g_varchar2) then

Line 519: If (p_rec.passport_required = hr_api.g_varchar2) then

515: If (p_rec.relocation_required = hr_api.g_varchar2) then
516: p_rec.relocation_required :=
517: per_dpf_shd.g_old_rec.relocation_required;
518: End If;
519: If (p_rec.passport_required = hr_api.g_varchar2) then
520: p_rec.passport_required :=
521: per_dpf_shd.g_old_rec.passport_required;
522: End If;
523: If (p_rec.location1 = hr_api.g_varchar2) then

Line 523: If (p_rec.location1 = hr_api.g_varchar2) then

519: If (p_rec.passport_required = hr_api.g_varchar2) then
520: p_rec.passport_required :=
521: per_dpf_shd.g_old_rec.passport_required;
522: End If;
523: If (p_rec.location1 = hr_api.g_varchar2) then
524: p_rec.location1 :=
525: per_dpf_shd.g_old_rec.location1;
526: End If;
527: If (p_rec.location2 = hr_api.g_varchar2) then

Line 527: If (p_rec.location2 = hr_api.g_varchar2) then

523: If (p_rec.location1 = hr_api.g_varchar2) then
524: p_rec.location1 :=
525: per_dpf_shd.g_old_rec.location1;
526: End If;
527: If (p_rec.location2 = hr_api.g_varchar2) then
528: p_rec.location2 :=
529: per_dpf_shd.g_old_rec.location2;
530: End If;
531: If (p_rec.location3 = hr_api.g_varchar2) then

Line 531: If (p_rec.location3 = hr_api.g_varchar2) then

527: If (p_rec.location2 = hr_api.g_varchar2) then
528: p_rec.location2 :=
529: per_dpf_shd.g_old_rec.location2;
530: End If;
531: If (p_rec.location3 = hr_api.g_varchar2) then
532: p_rec.location3 :=
533: per_dpf_shd.g_old_rec.location3;
534: End If;
535: If (p_rec.other_requirements = hr_api.g_varchar2) then

Line 535: If (p_rec.other_requirements = hr_api.g_varchar2) then

531: If (p_rec.location3 = hr_api.g_varchar2) then
532: p_rec.location3 :=
533: per_dpf_shd.g_old_rec.location3;
534: End If;
535: If (p_rec.other_requirements = hr_api.g_varchar2) then
536: p_rec.other_requirements :=
537: per_dpf_shd.g_old_rec.other_requirements;
538: End If;
539: If (p_rec.service_minimum = hr_api.g_varchar2) then

Line 539: If (p_rec.service_minimum = hr_api.g_varchar2) then

535: If (p_rec.other_requirements = hr_api.g_varchar2) then
536: p_rec.other_requirements :=
537: per_dpf_shd.g_old_rec.other_requirements;
538: End If;
539: If (p_rec.service_minimum = hr_api.g_varchar2) then
540: p_rec.service_minimum :=
541: per_dpf_shd.g_old_rec.service_minimum;
542: End If;
543: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 543: If (p_rec.attribute_category = hr_api.g_varchar2) then

539: If (p_rec.service_minimum = hr_api.g_varchar2) then
540: p_rec.service_minimum :=
541: per_dpf_shd.g_old_rec.service_minimum;
542: End If;
543: If (p_rec.attribute_category = hr_api.g_varchar2) then
544: p_rec.attribute_category :=
545: per_dpf_shd.g_old_rec.attribute_category;
546: End If;
547: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 547: If (p_rec.attribute1 = hr_api.g_varchar2) then

543: If (p_rec.attribute_category = hr_api.g_varchar2) then
544: p_rec.attribute_category :=
545: per_dpf_shd.g_old_rec.attribute_category;
546: End If;
547: If (p_rec.attribute1 = hr_api.g_varchar2) then
548: p_rec.attribute1 :=
549: per_dpf_shd.g_old_rec.attribute1;
550: End If;
551: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 551: If (p_rec.attribute2 = hr_api.g_varchar2) then

547: If (p_rec.attribute1 = hr_api.g_varchar2) then
548: p_rec.attribute1 :=
549: per_dpf_shd.g_old_rec.attribute1;
550: End If;
551: If (p_rec.attribute2 = hr_api.g_varchar2) then
552: p_rec.attribute2 :=
553: per_dpf_shd.g_old_rec.attribute2;
554: End If;
555: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 555: If (p_rec.attribute3 = hr_api.g_varchar2) then

551: If (p_rec.attribute2 = hr_api.g_varchar2) then
552: p_rec.attribute2 :=
553: per_dpf_shd.g_old_rec.attribute2;
554: End If;
555: If (p_rec.attribute3 = hr_api.g_varchar2) then
556: p_rec.attribute3 :=
557: per_dpf_shd.g_old_rec.attribute3;
558: End If;
559: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 559: If (p_rec.attribute4 = hr_api.g_varchar2) then

555: If (p_rec.attribute3 = hr_api.g_varchar2) then
556: p_rec.attribute3 :=
557: per_dpf_shd.g_old_rec.attribute3;
558: End If;
559: If (p_rec.attribute4 = hr_api.g_varchar2) then
560: p_rec.attribute4 :=
561: per_dpf_shd.g_old_rec.attribute4;
562: End If;
563: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 563: If (p_rec.attribute5 = hr_api.g_varchar2) then

559: If (p_rec.attribute4 = hr_api.g_varchar2) then
560: p_rec.attribute4 :=
561: per_dpf_shd.g_old_rec.attribute4;
562: End If;
563: If (p_rec.attribute5 = hr_api.g_varchar2) then
564: p_rec.attribute5 :=
565: per_dpf_shd.g_old_rec.attribute5;
566: End If;
567: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 567: If (p_rec.attribute6 = hr_api.g_varchar2) then

563: If (p_rec.attribute5 = hr_api.g_varchar2) then
564: p_rec.attribute5 :=
565: per_dpf_shd.g_old_rec.attribute5;
566: End If;
567: If (p_rec.attribute6 = hr_api.g_varchar2) then
568: p_rec.attribute6 :=
569: per_dpf_shd.g_old_rec.attribute6;
570: End If;
571: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 571: If (p_rec.attribute7 = hr_api.g_varchar2) then

567: If (p_rec.attribute6 = hr_api.g_varchar2) then
568: p_rec.attribute6 :=
569: per_dpf_shd.g_old_rec.attribute6;
570: End If;
571: If (p_rec.attribute7 = hr_api.g_varchar2) then
572: p_rec.attribute7 :=
573: per_dpf_shd.g_old_rec.attribute7;
574: End If;
575: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 575: If (p_rec.attribute8 = hr_api.g_varchar2) then

571: If (p_rec.attribute7 = hr_api.g_varchar2) then
572: p_rec.attribute7 :=
573: per_dpf_shd.g_old_rec.attribute7;
574: End If;
575: If (p_rec.attribute8 = hr_api.g_varchar2) then
576: p_rec.attribute8 :=
577: per_dpf_shd.g_old_rec.attribute8;
578: End If;
579: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 579: If (p_rec.attribute9 = hr_api.g_varchar2) then

575: If (p_rec.attribute8 = hr_api.g_varchar2) then
576: p_rec.attribute8 :=
577: per_dpf_shd.g_old_rec.attribute8;
578: End If;
579: If (p_rec.attribute9 = hr_api.g_varchar2) then
580: p_rec.attribute9 :=
581: per_dpf_shd.g_old_rec.attribute9;
582: End If;
583: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 583: If (p_rec.attribute10 = hr_api.g_varchar2) then

579: If (p_rec.attribute9 = hr_api.g_varchar2) then
580: p_rec.attribute9 :=
581: per_dpf_shd.g_old_rec.attribute9;
582: End If;
583: If (p_rec.attribute10 = hr_api.g_varchar2) then
584: p_rec.attribute10 :=
585: per_dpf_shd.g_old_rec.attribute10;
586: End If;
587: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 587: If (p_rec.attribute11 = hr_api.g_varchar2) then

583: If (p_rec.attribute10 = hr_api.g_varchar2) then
584: p_rec.attribute10 :=
585: per_dpf_shd.g_old_rec.attribute10;
586: End If;
587: If (p_rec.attribute11 = hr_api.g_varchar2) then
588: p_rec.attribute11 :=
589: per_dpf_shd.g_old_rec.attribute11;
590: End If;
591: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 591: If (p_rec.attribute12 = hr_api.g_varchar2) then

587: If (p_rec.attribute11 = hr_api.g_varchar2) then
588: p_rec.attribute11 :=
589: per_dpf_shd.g_old_rec.attribute11;
590: End If;
591: If (p_rec.attribute12 = hr_api.g_varchar2) then
592: p_rec.attribute12 :=
593: per_dpf_shd.g_old_rec.attribute12;
594: End If;
595: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 595: If (p_rec.attribute13 = hr_api.g_varchar2) then

591: If (p_rec.attribute12 = hr_api.g_varchar2) then
592: p_rec.attribute12 :=
593: per_dpf_shd.g_old_rec.attribute12;
594: End If;
595: If (p_rec.attribute13 = hr_api.g_varchar2) then
596: p_rec.attribute13 :=
597: per_dpf_shd.g_old_rec.attribute13;
598: End If;
599: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 599: If (p_rec.attribute14 = hr_api.g_varchar2) then

595: If (p_rec.attribute13 = hr_api.g_varchar2) then
596: p_rec.attribute13 :=
597: per_dpf_shd.g_old_rec.attribute13;
598: End If;
599: If (p_rec.attribute14 = hr_api.g_varchar2) then
600: p_rec.attribute14 :=
601: per_dpf_shd.g_old_rec.attribute14;
602: End If;
603: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 603: If (p_rec.attribute15 = hr_api.g_varchar2) then

599: If (p_rec.attribute14 = hr_api.g_varchar2) then
600: p_rec.attribute14 :=
601: per_dpf_shd.g_old_rec.attribute14;
602: End If;
603: If (p_rec.attribute15 = hr_api.g_varchar2) then
604: p_rec.attribute15 :=
605: per_dpf_shd.g_old_rec.attribute15;
606: End If;
607: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 607: If (p_rec.attribute16 = hr_api.g_varchar2) then

603: If (p_rec.attribute15 = hr_api.g_varchar2) then
604: p_rec.attribute15 :=
605: per_dpf_shd.g_old_rec.attribute15;
606: End If;
607: If (p_rec.attribute16 = hr_api.g_varchar2) then
608: p_rec.attribute16 :=
609: per_dpf_shd.g_old_rec.attribute16;
610: End If;
611: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 611: If (p_rec.attribute17 = hr_api.g_varchar2) then

607: If (p_rec.attribute16 = hr_api.g_varchar2) then
608: p_rec.attribute16 :=
609: per_dpf_shd.g_old_rec.attribute16;
610: End If;
611: If (p_rec.attribute17 = hr_api.g_varchar2) then
612: p_rec.attribute17 :=
613: per_dpf_shd.g_old_rec.attribute17;
614: End If;
615: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 615: If (p_rec.attribute18 = hr_api.g_varchar2) then

611: If (p_rec.attribute17 = hr_api.g_varchar2) then
612: p_rec.attribute17 :=
613: per_dpf_shd.g_old_rec.attribute17;
614: End If;
615: If (p_rec.attribute18 = hr_api.g_varchar2) then
616: p_rec.attribute18 :=
617: per_dpf_shd.g_old_rec.attribute18;
618: End If;
619: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 619: If (p_rec.attribute19 = hr_api.g_varchar2) then

615: If (p_rec.attribute18 = hr_api.g_varchar2) then
616: p_rec.attribute18 :=
617: per_dpf_shd.g_old_rec.attribute18;
618: End If;
619: If (p_rec.attribute19 = hr_api.g_varchar2) then
620: p_rec.attribute19 :=
621: per_dpf_shd.g_old_rec.attribute19;
622: End If;
623: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 623: If (p_rec.attribute20 = hr_api.g_varchar2) then

619: If (p_rec.attribute19 = hr_api.g_varchar2) then
620: p_rec.attribute19 :=
621: per_dpf_shd.g_old_rec.attribute19;
622: End If;
623: If (p_rec.attribute20 = hr_api.g_varchar2) then
624: p_rec.attribute20 :=
625: per_dpf_shd.g_old_rec.attribute20;
626: End If;
627: --