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

APPS.GHR_CMP_UPD dependencies on HR_API

Line 238: When hr_api.check_integrity_violated Then

234: --
235: hr_utility.set_location(' Leaving:'||l_proc, 10);
236: --
237: Exception
238: When hr_api.check_integrity_violated Then
239: -- A check constraint has been violated
240: --
241: ghr_cmp_shd.constraint_error
242: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

238: When hr_api.check_integrity_violated Then
239: -- A check constraint has been violated
240: --
241: ghr_cmp_shd.constraint_error
242: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
243: When hr_api.parent_integrity_violated Then
244: -- Parent integrity has been violated
245: --
246: ghr_cmp_shd.constraint_error

Line 243: When hr_api.parent_integrity_violated Then

239: -- A check constraint has been violated
240: --
241: ghr_cmp_shd.constraint_error
242: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
243: When hr_api.parent_integrity_violated Then
244: -- Parent integrity has been violated
245: --
246: ghr_cmp_shd.constraint_error
247: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

243: When hr_api.parent_integrity_violated Then
244: -- Parent integrity has been violated
245: --
246: ghr_cmp_shd.constraint_error
247: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
248: When hr_api.unique_integrity_violated Then
249: -- Unique integrity has been violated
250: --
251: ghr_cmp_shd.constraint_error

Line 248: When hr_api.unique_integrity_violated Then

244: -- Parent integrity has been violated
245: --
246: ghr_cmp_shd.constraint_error
247: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
248: When hr_api.unique_integrity_violated Then
249: -- Unique integrity has been violated
250: --
251: ghr_cmp_shd.constraint_error
252: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

248: When hr_api.unique_integrity_violated Then
249: -- Unique integrity has been violated
250: --
251: ghr_cmp_shd.constraint_error
252: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
253: When Others Then
254: --
255: Raise;
256: End update_dml;

Line 670: when hr_api.cannot_find_prog_unit then

666: );
667: --
668: exception
669: --
670: when hr_api.cannot_find_prog_unit then
671: --
672: hr_api.cannot_find_prog_unit_error
673: (p_module_name => 'GHR_COMPLAINTS2'
674: ,p_hook_type => 'AU');

Line 672: hr_api.cannot_find_prog_unit_error

668: exception
669: --
670: when hr_api.cannot_find_prog_unit then
671: --
672: hr_api.cannot_find_prog_unit_error
673: (p_module_name => 'GHR_COMPLAINTS2'
674: ,p_hook_type => 'AU');
675: --
676:

Line 737: If (p_rec.complainant_person_id = hr_api.g_number) then

733: -- p_rec plsql record structure
734: -- to see if a system default is being used. If a system default
735: -- is being used then we must set to the 'current' argument value.
736: --
737: If (p_rec.complainant_person_id = hr_api.g_number) then
738: p_rec.complainant_person_id :=
739: ghr_cmp_shd.g_old_rec.complainant_person_id;
740: End If;
741: If (p_rec.business_group_id = hr_api.g_number) then

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

737: If (p_rec.complainant_person_id = hr_api.g_number) then
738: p_rec.complainant_person_id :=
739: ghr_cmp_shd.g_old_rec.complainant_person_id;
740: End If;
741: If (p_rec.business_group_id = hr_api.g_number) then
742: p_rec.business_group_id :=
743: ghr_cmp_shd.g_old_rec.business_group_id;
744: End If;
745: If (p_rec.docket_number = hr_api.g_varchar2) then

Line 745: If (p_rec.docket_number = hr_api.g_varchar2) then

741: If (p_rec.business_group_id = hr_api.g_number) then
742: p_rec.business_group_id :=
743: ghr_cmp_shd.g_old_rec.business_group_id;
744: End If;
745: If (p_rec.docket_number = hr_api.g_varchar2) then
746: p_rec.docket_number :=
747: ghr_cmp_shd.g_old_rec.docket_number;
748: End If;
749: If (p_rec.stage = hr_api.g_varchar2) then

Line 749: If (p_rec.stage = hr_api.g_varchar2) then

745: If (p_rec.docket_number = hr_api.g_varchar2) then
746: p_rec.docket_number :=
747: ghr_cmp_shd.g_old_rec.docket_number;
748: End If;
749: If (p_rec.stage = hr_api.g_varchar2) then
750: p_rec.stage :=
751: ghr_cmp_shd.g_old_rec.stage;
752: End If;
753: If (p_rec.class_flag = hr_api.g_varchar2) then

Line 753: If (p_rec.class_flag = hr_api.g_varchar2) then

749: If (p_rec.stage = hr_api.g_varchar2) then
750: p_rec.stage :=
751: ghr_cmp_shd.g_old_rec.stage;
752: End If;
753: If (p_rec.class_flag = hr_api.g_varchar2) then
754: p_rec.class_flag :=
755: ghr_cmp_shd.g_old_rec.class_flag;
756: End If;
757: If (p_rec.mixed_flag = hr_api.g_varchar2) then

Line 757: If (p_rec.mixed_flag = hr_api.g_varchar2) then

753: If (p_rec.class_flag = hr_api.g_varchar2) then
754: p_rec.class_flag :=
755: ghr_cmp_shd.g_old_rec.class_flag;
756: End If;
757: If (p_rec.mixed_flag = hr_api.g_varchar2) then
758: p_rec.mixed_flag :=
759: ghr_cmp_shd.g_old_rec.mixed_flag;
760: End If;
761: If (p_rec.consolidated_flag = hr_api.g_varchar2) then

Line 761: If (p_rec.consolidated_flag = hr_api.g_varchar2) then

757: If (p_rec.mixed_flag = hr_api.g_varchar2) then
758: p_rec.mixed_flag :=
759: ghr_cmp_shd.g_old_rec.mixed_flag;
760: End If;
761: If (p_rec.consolidated_flag = hr_api.g_varchar2) then
762: p_rec.consolidated_flag :=
763: ghr_cmp_shd.g_old_rec.consolidated_flag;
764: End If;
765: If (p_rec.remand_flag = hr_api.g_varchar2) then

Line 765: If (p_rec.remand_flag = hr_api.g_varchar2) then

761: If (p_rec.consolidated_flag = hr_api.g_varchar2) then
762: p_rec.consolidated_flag :=
763: ghr_cmp_shd.g_old_rec.consolidated_flag;
764: End If;
765: If (p_rec.remand_flag = hr_api.g_varchar2) then
766: p_rec.remand_flag :=
767: ghr_cmp_shd.g_old_rec.remand_flag;
768: End If;
769: If (p_rec.active_flag = hr_api.g_varchar2) then

Line 769: If (p_rec.active_flag = hr_api.g_varchar2) then

765: If (p_rec.remand_flag = hr_api.g_varchar2) then
766: p_rec.remand_flag :=
767: ghr_cmp_shd.g_old_rec.remand_flag;
768: End If;
769: If (p_rec.active_flag = hr_api.g_varchar2) then
770: p_rec.active_flag :=
771: ghr_cmp_shd.g_old_rec.active_flag;
772: End If;
773: If (p_rec.information_inquiry = hr_api.g_date) then

Line 773: If (p_rec.information_inquiry = hr_api.g_date) then

769: If (p_rec.active_flag = hr_api.g_varchar2) then
770: p_rec.active_flag :=
771: ghr_cmp_shd.g_old_rec.active_flag;
772: End If;
773: If (p_rec.information_inquiry = hr_api.g_date) then
774: p_rec.information_inquiry :=
775: ghr_cmp_shd.g_old_rec.information_inquiry;
776: End If;
777: If (p_rec.pcom_init = hr_api.g_date) then

Line 777: If (p_rec.pcom_init = hr_api.g_date) then

773: If (p_rec.information_inquiry = hr_api.g_date) then
774: p_rec.information_inquiry :=
775: ghr_cmp_shd.g_old_rec.information_inquiry;
776: End If;
777: If (p_rec.pcom_init = hr_api.g_date) then
778: p_rec.pcom_init :=
779: ghr_cmp_shd.g_old_rec.pcom_init;
780: End If;
781: If (p_rec.alleg_incident = hr_api.g_date) then

Line 781: If (p_rec.alleg_incident = hr_api.g_date) then

777: If (p_rec.pcom_init = hr_api.g_date) then
778: p_rec.pcom_init :=
779: ghr_cmp_shd.g_old_rec.pcom_init;
780: End If;
781: If (p_rec.alleg_incident = hr_api.g_date) then
782: p_rec.alleg_incident :=
783: ghr_cmp_shd.g_old_rec.alleg_incident;
784: End If;
785: If (p_rec.alleg_discrim_org_id = hr_api.g_number) then

Line 785: If (p_rec.alleg_discrim_org_id = hr_api.g_number) then

781: If (p_rec.alleg_incident = hr_api.g_date) then
782: p_rec.alleg_incident :=
783: ghr_cmp_shd.g_old_rec.alleg_incident;
784: End If;
785: If (p_rec.alleg_discrim_org_id = hr_api.g_number) then
786: p_rec.alleg_discrim_org_id :=
787: ghr_cmp_shd.g_old_rec.alleg_discrim_org_id;
788: End If;
789: If (p_rec.rr_ltr_date = hr_api.g_date) then

Line 789: If (p_rec.rr_ltr_date = hr_api.g_date) then

785: If (p_rec.alleg_discrim_org_id = hr_api.g_number) then
786: p_rec.alleg_discrim_org_id :=
787: ghr_cmp_shd.g_old_rec.alleg_discrim_org_id;
788: End If;
789: If (p_rec.rr_ltr_date = hr_api.g_date) then
790: p_rec.rr_ltr_date :=
791: ghr_cmp_shd.g_old_rec.rr_ltr_date;
792: End If;
793: If (p_rec.rr_ltr_recvd = hr_api.g_date) then

Line 793: If (p_rec.rr_ltr_recvd = hr_api.g_date) then

789: If (p_rec.rr_ltr_date = hr_api.g_date) then
790: p_rec.rr_ltr_date :=
791: ghr_cmp_shd.g_old_rec.rr_ltr_date;
792: End If;
793: If (p_rec.rr_ltr_recvd = hr_api.g_date) then
794: p_rec.rr_ltr_recvd :=
795: ghr_cmp_shd.g_old_rec.rr_ltr_recvd;
796: End If;
797: If (p_rec.pre_com_elec = hr_api.g_varchar2) then

Line 797: If (p_rec.pre_com_elec = hr_api.g_varchar2) then

793: If (p_rec.rr_ltr_recvd = hr_api.g_date) then
794: p_rec.rr_ltr_recvd :=
795: ghr_cmp_shd.g_old_rec.rr_ltr_recvd;
796: End If;
797: If (p_rec.pre_com_elec = hr_api.g_varchar2) then
798: p_rec.pre_com_elec :=
799: ghr_cmp_shd.g_old_rec.pre_com_elec;
800: End If;
801: /*

Line 802: If (p_rec.adr_offered = hr_api.g_varchar2) then

798: p_rec.pre_com_elec :=
799: ghr_cmp_shd.g_old_rec.pre_com_elec;
800: End If;
801: /*
802: If (p_rec.adr_offered = hr_api.g_varchar2) then
803: p_rec.adr_offered :=
804: ghr_cmp_shd.g_old_rec.adr_offered;
805: End If;
806: */

Line 807: If (p_rec.class_agent_flag = hr_api.g_varchar2) then

803: p_rec.adr_offered :=
804: ghr_cmp_shd.g_old_rec.adr_offered;
805: End If;
806: */
807: If (p_rec.class_agent_flag = hr_api.g_varchar2) then
808: p_rec.class_agent_flag :=
809: ghr_cmp_shd.g_old_rec.class_agent_flag;
810: End If;
811: If (p_rec.pre_com_desc = hr_api.g_varchar2) then

Line 811: If (p_rec.pre_com_desc = hr_api.g_varchar2) then

807: If (p_rec.class_agent_flag = hr_api.g_varchar2) then
808: p_rec.class_agent_flag :=
809: ghr_cmp_shd.g_old_rec.class_agent_flag;
810: End If;
811: If (p_rec.pre_com_desc = hr_api.g_varchar2) then
812: p_rec.pre_com_desc :=
813: ghr_cmp_shd.g_old_rec.pre_com_desc;
814: End If;
815: If (p_rec.counselor_asg = hr_api.g_date) then

Line 815: If (p_rec.counselor_asg = hr_api.g_date) then

811: If (p_rec.pre_com_desc = hr_api.g_varchar2) then
812: p_rec.pre_com_desc :=
813: ghr_cmp_shd.g_old_rec.pre_com_desc;
814: End If;
815: If (p_rec.counselor_asg = hr_api.g_date) then
816: p_rec.counselor_asg :=
817: ghr_cmp_shd.g_old_rec.counselor_asg;
818: End If;
819: If (p_rec.init_counselor_interview = hr_api.g_date) then

Line 819: If (p_rec.init_counselor_interview = hr_api.g_date) then

815: If (p_rec.counselor_asg = hr_api.g_date) then
816: p_rec.counselor_asg :=
817: ghr_cmp_shd.g_old_rec.counselor_asg;
818: End If;
819: If (p_rec.init_counselor_interview = hr_api.g_date) then
820: p_rec.init_counselor_interview :=
821: ghr_cmp_shd.g_old_rec.init_counselor_interview;
822: End If;
823: If (p_rec.anonymity_requested = hr_api.g_varchar2) then

Line 823: If (p_rec.anonymity_requested = hr_api.g_varchar2) then

819: If (p_rec.init_counselor_interview = hr_api.g_date) then
820: p_rec.init_counselor_interview :=
821: ghr_cmp_shd.g_old_rec.init_counselor_interview;
822: End If;
823: If (p_rec.anonymity_requested = hr_api.g_varchar2) then
824: p_rec.anonymity_requested :=
825: ghr_cmp_shd.g_old_rec.anonymity_requested;
826: End If;
827: If (p_rec.counsel_ext_ltr = hr_api.g_date) then

Line 827: If (p_rec.counsel_ext_ltr = hr_api.g_date) then

823: If (p_rec.anonymity_requested = hr_api.g_varchar2) then
824: p_rec.anonymity_requested :=
825: ghr_cmp_shd.g_old_rec.anonymity_requested;
826: End If;
827: If (p_rec.counsel_ext_ltr = hr_api.g_date) then
828: p_rec.counsel_ext_ltr :=
829: ghr_cmp_shd.g_old_rec.counsel_ext_ltr;
830: End If;
831: If (p_rec.traditional_counsel_outcome = hr_api.g_varchar2) then

Line 831: If (p_rec.traditional_counsel_outcome = hr_api.g_varchar2) then

827: If (p_rec.counsel_ext_ltr = hr_api.g_date) then
828: p_rec.counsel_ext_ltr :=
829: ghr_cmp_shd.g_old_rec.counsel_ext_ltr;
830: End If;
831: If (p_rec.traditional_counsel_outcome = hr_api.g_varchar2) then
832: p_rec.traditional_counsel_outcome :=
833: ghr_cmp_shd.g_old_rec.traditional_counsel_outcome;
834: End If;
835: If (p_rec.final_interview = hr_api.g_date) then

Line 835: If (p_rec.final_interview = hr_api.g_date) then

831: If (p_rec.traditional_counsel_outcome = hr_api.g_varchar2) then
832: p_rec.traditional_counsel_outcome :=
833: ghr_cmp_shd.g_old_rec.traditional_counsel_outcome;
834: End If;
835: If (p_rec.final_interview = hr_api.g_date) then
836: p_rec.final_interview :=
837: ghr_cmp_shd.g_old_rec.final_interview;
838: End If;
839: If (p_rec.notice_rtf_recvd = hr_api.g_date) then

Line 839: If (p_rec.notice_rtf_recvd = hr_api.g_date) then

835: If (p_rec.final_interview = hr_api.g_date) then
836: p_rec.final_interview :=
837: ghr_cmp_shd.g_old_rec.final_interview;
838: End If;
839: If (p_rec.notice_rtf_recvd = hr_api.g_date) then
840: p_rec.notice_rtf_recvd :=
841: ghr_cmp_shd.g_old_rec.notice_rtf_recvd;
842: End If;
843: If (p_rec.precom_closed = hr_api.g_date) then

Line 843: If (p_rec.precom_closed = hr_api.g_date) then

839: If (p_rec.notice_rtf_recvd = hr_api.g_date) then
840: p_rec.notice_rtf_recvd :=
841: ghr_cmp_shd.g_old_rec.notice_rtf_recvd;
842: End If;
843: If (p_rec.precom_closed = hr_api.g_date) then
844: p_rec.precom_closed :=
845: ghr_cmp_shd.g_old_rec.precom_closed;
846: End If;
847: If (p_rec.precom_closure_nature = hr_api.g_varchar2) then

Line 847: If (p_rec.precom_closure_nature = hr_api.g_varchar2) then

843: If (p_rec.precom_closed = hr_api.g_date) then
844: p_rec.precom_closed :=
845: ghr_cmp_shd.g_old_rec.precom_closed;
846: End If;
847: If (p_rec.precom_closure_nature = hr_api.g_varchar2) then
848: p_rec.precom_closure_nature :=
849: ghr_cmp_shd.g_old_rec.precom_closure_nature;
850: End If;
851: If (p_rec.counselor_rpt_sub = hr_api.g_date) then

Line 851: If (p_rec.counselor_rpt_sub = hr_api.g_date) then

847: If (p_rec.precom_closure_nature = hr_api.g_varchar2) then
848: p_rec.precom_closure_nature :=
849: ghr_cmp_shd.g_old_rec.precom_closure_nature;
850: End If;
851: If (p_rec.counselor_rpt_sub = hr_api.g_date) then
852: p_rec.counselor_rpt_sub :=
853: ghr_cmp_shd.g_old_rec.counselor_rpt_sub;
854: End If;
855: If (p_rec.hr_office_org_id = hr_api.g_number) then

Line 855: If (p_rec.hr_office_org_id = hr_api.g_number) then

851: If (p_rec.counselor_rpt_sub = hr_api.g_date) then
852: p_rec.counselor_rpt_sub :=
853: ghr_cmp_shd.g_old_rec.counselor_rpt_sub;
854: End If;
855: If (p_rec.hr_office_org_id = hr_api.g_number) then
856: p_rec.hr_office_org_id :=
857: ghr_cmp_shd.g_old_rec.hr_office_org_id;
858: End If;
859: If (p_rec.eeo_office_org_id = hr_api.g_number) then

Line 859: If (p_rec.eeo_office_org_id = hr_api.g_number) then

855: If (p_rec.hr_office_org_id = hr_api.g_number) then
856: p_rec.hr_office_org_id :=
857: ghr_cmp_shd.g_old_rec.hr_office_org_id;
858: End If;
859: If (p_rec.eeo_office_org_id = hr_api.g_number) then
860: p_rec.eeo_office_org_id :=
861: ghr_cmp_shd.g_old_rec.eeo_office_org_id;
862: End If;
863: If (p_rec.serviced_org_id = hr_api.g_number) then

Line 863: If (p_rec.serviced_org_id = hr_api.g_number) then

859: If (p_rec.eeo_office_org_id = hr_api.g_number) then
860: p_rec.eeo_office_org_id :=
861: ghr_cmp_shd.g_old_rec.eeo_office_org_id;
862: End If;
863: If (p_rec.serviced_org_id = hr_api.g_number) then
864: p_rec.serviced_org_id :=
865: ghr_cmp_shd.g_old_rec.serviced_org_id;
866: End If;
867: If (p_rec.formal_com_filed = hr_api.g_date) then

Line 867: If (p_rec.formal_com_filed = hr_api.g_date) then

863: If (p_rec.serviced_org_id = hr_api.g_number) then
864: p_rec.serviced_org_id :=
865: ghr_cmp_shd.g_old_rec.serviced_org_id;
866: End If;
867: If (p_rec.formal_com_filed = hr_api.g_date) then
868: p_rec.formal_com_filed :=
869: ghr_cmp_shd.g_old_rec.formal_com_filed;
870: End If;
871: If (p_rec.ack_ltr = hr_api.g_date) then

Line 871: If (p_rec.ack_ltr = hr_api.g_date) then

867: If (p_rec.formal_com_filed = hr_api.g_date) then
868: p_rec.formal_com_filed :=
869: ghr_cmp_shd.g_old_rec.formal_com_filed;
870: End If;
871: If (p_rec.ack_ltr = hr_api.g_date) then
872: p_rec.ack_ltr :=
873: ghr_cmp_shd.g_old_rec.ack_ltr;
874: End If;
875: If (p_rec.clarification_ltr_date = hr_api.g_date) then

Line 875: If (p_rec.clarification_ltr_date = hr_api.g_date) then

871: If (p_rec.ack_ltr = hr_api.g_date) then
872: p_rec.ack_ltr :=
873: ghr_cmp_shd.g_old_rec.ack_ltr;
874: End If;
875: If (p_rec.clarification_ltr_date = hr_api.g_date) then
876: p_rec.clarification_ltr_date :=
877: ghr_cmp_shd.g_old_rec.clarification_ltr_date;
878: End If;
879: If (p_rec.clarification_response_recvd = hr_api.g_date) then

Line 879: If (p_rec.clarification_response_recvd = hr_api.g_date) then

875: If (p_rec.clarification_ltr_date = hr_api.g_date) then
876: p_rec.clarification_ltr_date :=
877: ghr_cmp_shd.g_old_rec.clarification_ltr_date;
878: End If;
879: If (p_rec.clarification_response_recvd = hr_api.g_date) then
880: p_rec.clarification_response_recvd :=
881: ghr_cmp_shd.g_old_rec.clarification_response_recvd;
882: End If;
883: If (p_rec.forwarded_legal_review = hr_api.g_date) then

Line 883: If (p_rec.forwarded_legal_review = hr_api.g_date) then

879: If (p_rec.clarification_response_recvd = hr_api.g_date) then
880: p_rec.clarification_response_recvd :=
881: ghr_cmp_shd.g_old_rec.clarification_response_recvd;
882: End If;
883: If (p_rec.forwarded_legal_review = hr_api.g_date) then
884: p_rec.forwarded_legal_review :=
885: ghr_cmp_shd.g_old_rec.forwarded_legal_review;
886: End If;
887: If (p_rec.returned_from_legal = hr_api.g_date) then

Line 887: If (p_rec.returned_from_legal = hr_api.g_date) then

883: If (p_rec.forwarded_legal_review = hr_api.g_date) then
884: p_rec.forwarded_legal_review :=
885: ghr_cmp_shd.g_old_rec.forwarded_legal_review;
886: End If;
887: If (p_rec.returned_from_legal = hr_api.g_date) then
888: p_rec.returned_from_legal :=
889: ghr_cmp_shd.g_old_rec.returned_from_legal;
890: End If;
891: If (p_rec.letter_type = hr_api.g_varchar2) then

Line 891: If (p_rec.letter_type = hr_api.g_varchar2) then

887: If (p_rec.returned_from_legal = hr_api.g_date) then
888: p_rec.returned_from_legal :=
889: ghr_cmp_shd.g_old_rec.returned_from_legal;
890: End If;
891: If (p_rec.letter_type = hr_api.g_varchar2) then
892: p_rec.letter_type :=
893: ghr_cmp_shd.g_old_rec.letter_type;
894: End If;
895: If (p_rec.letter_date = hr_api.g_date) then

Line 895: If (p_rec.letter_date = hr_api.g_date) then

891: If (p_rec.letter_type = hr_api.g_varchar2) then
892: p_rec.letter_type :=
893: ghr_cmp_shd.g_old_rec.letter_type;
894: End If;
895: If (p_rec.letter_date = hr_api.g_date) then
896: p_rec.letter_date :=
897: ghr_cmp_shd.g_old_rec.letter_date;
898: End If;
899: If (p_rec.letter_recvd = hr_api.g_date) then

Line 899: If (p_rec.letter_recvd = hr_api.g_date) then

895: If (p_rec.letter_date = hr_api.g_date) then
896: p_rec.letter_date :=
897: ghr_cmp_shd.g_old_rec.letter_date;
898: End If;
899: If (p_rec.letter_recvd = hr_api.g_date) then
900: p_rec.letter_recvd :=
901: ghr_cmp_shd.g_old_rec.letter_recvd;
902: End If;
903: If (p_rec.investigation_source = hr_api.g_varchar2) then

Line 903: If (p_rec.investigation_source = hr_api.g_varchar2) then

899: If (p_rec.letter_recvd = hr_api.g_date) then
900: p_rec.letter_recvd :=
901: ghr_cmp_shd.g_old_rec.letter_recvd;
902: End If;
903: If (p_rec.investigation_source = hr_api.g_varchar2) then
904: p_rec.investigation_source :=
905: ghr_cmp_shd.g_old_rec.investigation_source;
906: End If;
907: If (p_rec.investigator_recvd_req = hr_api.g_date) then

Line 907: If (p_rec.investigator_recvd_req = hr_api.g_date) then

903: If (p_rec.investigation_source = hr_api.g_varchar2) then
904: p_rec.investigation_source :=
905: ghr_cmp_shd.g_old_rec.investigation_source;
906: End If;
907: If (p_rec.investigator_recvd_req = hr_api.g_date) then
908: p_rec.investigator_recvd_req :=
909: ghr_cmp_shd.g_old_rec.investigator_recvd_req;
910: End If;
911: If (p_rec.agency_investigator_req = hr_api.g_date) then

Line 911: If (p_rec.agency_investigator_req = hr_api.g_date) then

907: If (p_rec.investigator_recvd_req = hr_api.g_date) then
908: p_rec.investigator_recvd_req :=
909: ghr_cmp_shd.g_old_rec.investigator_recvd_req;
910: End If;
911: If (p_rec.agency_investigator_req = hr_api.g_date) then
912: p_rec.agency_investigator_req :=
913: ghr_cmp_shd.g_old_rec.agency_investigator_req;
914: End If;
915: If (p_rec.investigator_asg = hr_api.g_date) then

Line 915: If (p_rec.investigator_asg = hr_api.g_date) then

911: If (p_rec.agency_investigator_req = hr_api.g_date) then
912: p_rec.agency_investigator_req :=
913: ghr_cmp_shd.g_old_rec.agency_investigator_req;
914: End If;
915: If (p_rec.investigator_asg = hr_api.g_date) then
916: p_rec.investigator_asg :=
917: ghr_cmp_shd.g_old_rec.investigator_asg;
918: End If;
919: If (p_rec.investigation_start = hr_api.g_date) then

Line 919: If (p_rec.investigation_start = hr_api.g_date) then

915: If (p_rec.investigator_asg = hr_api.g_date) then
916: p_rec.investigator_asg :=
917: ghr_cmp_shd.g_old_rec.investigator_asg;
918: End If;
919: If (p_rec.investigation_start = hr_api.g_date) then
920: p_rec.investigation_start :=
921: ghr_cmp_shd.g_old_rec.investigation_start;
922: End If;
923: If (p_rec.investigation_end = hr_api.g_date) then

Line 923: If (p_rec.investigation_end = hr_api.g_date) then

919: If (p_rec.investigation_start = hr_api.g_date) then
920: p_rec.investigation_start :=
921: ghr_cmp_shd.g_old_rec.investigation_start;
922: End If;
923: If (p_rec.investigation_end = hr_api.g_date) then
924: p_rec.investigation_end :=
925: ghr_cmp_shd.g_old_rec.investigation_end;
926: End If;
927: If (p_rec.investigation_extended = hr_api.g_date) then

Line 927: If (p_rec.investigation_extended = hr_api.g_date) then

923: If (p_rec.investigation_end = hr_api.g_date) then
924: p_rec.investigation_end :=
925: ghr_cmp_shd.g_old_rec.investigation_end;
926: End If;
927: If (p_rec.investigation_extended = hr_api.g_date) then
928: p_rec.investigation_extended :=
929: ghr_cmp_shd.g_old_rec.investigation_extended;
930: End If;
931: If (p_rec.invest_extension_desc = hr_api.g_varchar2) then

Line 931: If (p_rec.invest_extension_desc = hr_api.g_varchar2) then

927: If (p_rec.investigation_extended = hr_api.g_date) then
928: p_rec.investigation_extended :=
929: ghr_cmp_shd.g_old_rec.investigation_extended;
930: End If;
931: If (p_rec.invest_extension_desc = hr_api.g_varchar2) then
932: p_rec.invest_extension_desc :=
933: ghr_cmp_shd.g_old_rec.invest_extension_desc;
934: End If;
935: If (p_rec.agency_recvd_roi = hr_api.g_date) then

Line 935: If (p_rec.agency_recvd_roi = hr_api.g_date) then

931: If (p_rec.invest_extension_desc = hr_api.g_varchar2) then
932: p_rec.invest_extension_desc :=
933: ghr_cmp_shd.g_old_rec.invest_extension_desc;
934: End If;
935: If (p_rec.agency_recvd_roi = hr_api.g_date) then
936: p_rec.agency_recvd_roi :=
937: ghr_cmp_shd.g_old_rec.agency_recvd_roi;
938: End If;
939: If (p_rec.comrep_recvd_roi = hr_api.g_date) then

Line 939: If (p_rec.comrep_recvd_roi = hr_api.g_date) then

935: If (p_rec.agency_recvd_roi = hr_api.g_date) then
936: p_rec.agency_recvd_roi :=
937: ghr_cmp_shd.g_old_rec.agency_recvd_roi;
938: End If;
939: If (p_rec.comrep_recvd_roi = hr_api.g_date) then
940: p_rec.comrep_recvd_roi :=
941: ghr_cmp_shd.g_old_rec.comrep_recvd_roi;
942: End If;
943: If (p_rec.options_ltr_date = hr_api.g_date) then

Line 943: If (p_rec.options_ltr_date = hr_api.g_date) then

939: If (p_rec.comrep_recvd_roi = hr_api.g_date) then
940: p_rec.comrep_recvd_roi :=
941: ghr_cmp_shd.g_old_rec.comrep_recvd_roi;
942: End If;
943: If (p_rec.options_ltr_date = hr_api.g_date) then
944: p_rec.options_ltr_date :=
945: ghr_cmp_shd.g_old_rec.options_ltr_date;
946: End If;
947: If (p_rec.comrep_recvd_opt_ltr = hr_api.g_date) then

Line 947: If (p_rec.comrep_recvd_opt_ltr = hr_api.g_date) then

943: If (p_rec.options_ltr_date = hr_api.g_date) then
944: p_rec.options_ltr_date :=
945: ghr_cmp_shd.g_old_rec.options_ltr_date;
946: End If;
947: If (p_rec.comrep_recvd_opt_ltr = hr_api.g_date) then
948: p_rec.comrep_recvd_opt_ltr :=
949: ghr_cmp_shd.g_old_rec.comrep_recvd_opt_ltr;
950: End If;
951: If (p_rec.comrep_opt_ltr_response = hr_api.g_varchar2) then

Line 951: If (p_rec.comrep_opt_ltr_response = hr_api.g_varchar2) then

947: If (p_rec.comrep_recvd_opt_ltr = hr_api.g_date) then
948: p_rec.comrep_recvd_opt_ltr :=
949: ghr_cmp_shd.g_old_rec.comrep_recvd_opt_ltr;
950: End If;
951: If (p_rec.comrep_opt_ltr_response = hr_api.g_varchar2) then
952: p_rec.comrep_opt_ltr_response :=
953: ghr_cmp_shd.g_old_rec.comrep_opt_ltr_response;
954: End If;
955: If (p_rec.resolution_offer = hr_api.g_date) then

Line 955: If (p_rec.resolution_offer = hr_api.g_date) then

951: If (p_rec.comrep_opt_ltr_response = hr_api.g_varchar2) then
952: p_rec.comrep_opt_ltr_response :=
953: ghr_cmp_shd.g_old_rec.comrep_opt_ltr_response;
954: End If;
955: If (p_rec.resolution_offer = hr_api.g_date) then
956: p_rec.resolution_offer :=
957: ghr_cmp_shd.g_old_rec.resolution_offer;
958: End If;
959: If (p_rec.comrep_resol_offer_recvd = hr_api.g_date) then

Line 959: If (p_rec.comrep_resol_offer_recvd = hr_api.g_date) then

955: If (p_rec.resolution_offer = hr_api.g_date) then
956: p_rec.resolution_offer :=
957: ghr_cmp_shd.g_old_rec.resolution_offer;
958: End If;
959: If (p_rec.comrep_resol_offer_recvd = hr_api.g_date) then
960: p_rec.comrep_resol_offer_recvd :=
961: ghr_cmp_shd.g_old_rec.comrep_resol_offer_recvd;
962: End If;
963: If (p_rec.comrep_resol_offer_response = hr_api.g_date) then

Line 963: If (p_rec.comrep_resol_offer_response = hr_api.g_date) then

959: If (p_rec.comrep_resol_offer_recvd = hr_api.g_date) then
960: p_rec.comrep_resol_offer_recvd :=
961: ghr_cmp_shd.g_old_rec.comrep_resol_offer_recvd;
962: End If;
963: If (p_rec.comrep_resol_offer_response = hr_api.g_date) then
964: p_rec.comrep_resol_offer_response :=
965: ghr_cmp_shd.g_old_rec.comrep_resol_offer_response;
966: End If;
967: If (p_rec.comrep_resol_offer_desc = hr_api.g_varchar2) then

Line 967: If (p_rec.comrep_resol_offer_desc = hr_api.g_varchar2) then

963: If (p_rec.comrep_resol_offer_response = hr_api.g_date) then
964: p_rec.comrep_resol_offer_response :=
965: ghr_cmp_shd.g_old_rec.comrep_resol_offer_response;
966: End If;
967: If (p_rec.comrep_resol_offer_desc = hr_api.g_varchar2) then
968: p_rec.comrep_resol_offer_desc :=
969: ghr_cmp_shd.g_old_rec.comrep_resol_offer_desc;
970: End If;
971: If (p_rec.resol_offer_signed = hr_api.g_date) then

Line 971: If (p_rec.resol_offer_signed = hr_api.g_date) then

967: If (p_rec.comrep_resol_offer_desc = hr_api.g_varchar2) then
968: p_rec.comrep_resol_offer_desc :=
969: ghr_cmp_shd.g_old_rec.comrep_resol_offer_desc;
970: End If;
971: If (p_rec.resol_offer_signed = hr_api.g_date) then
972: p_rec.resol_offer_signed :=
973: ghr_cmp_shd.g_old_rec.resol_offer_signed;
974: End If;
975: If (p_rec.resol_offer_desc = hr_api.g_varchar2) then

Line 975: If (p_rec.resol_offer_desc = hr_api.g_varchar2) then

971: If (p_rec.resol_offer_signed = hr_api.g_date) then
972: p_rec.resol_offer_signed :=
973: ghr_cmp_shd.g_old_rec.resol_offer_signed;
974: End If;
975: If (p_rec.resol_offer_desc = hr_api.g_varchar2) then
976: p_rec.resol_offer_desc :=
977: ghr_cmp_shd.g_old_rec.resol_offer_desc;
978: End If;
979: If (p_rec.hearing_source = hr_api.g_varchar2) then

Line 979: If (p_rec.hearing_source = hr_api.g_varchar2) then

975: If (p_rec.resol_offer_desc = hr_api.g_varchar2) then
976: p_rec.resol_offer_desc :=
977: ghr_cmp_shd.g_old_rec.resol_offer_desc;
978: End If;
979: If (p_rec.hearing_source = hr_api.g_varchar2) then
980: p_rec.hearing_source :=
981: ghr_cmp_shd.g_old_rec.hearing_source;
982: End If;
983: If (p_rec.agency_notified_hearing = hr_api.g_date) then

Line 983: If (p_rec.agency_notified_hearing = hr_api.g_date) then

979: If (p_rec.hearing_source = hr_api.g_varchar2) then
980: p_rec.hearing_source :=
981: ghr_cmp_shd.g_old_rec.hearing_source;
982: End If;
983: If (p_rec.agency_notified_hearing = hr_api.g_date) then
984: p_rec.agency_notified_hearing :=
985: ghr_cmp_shd.g_old_rec.agency_notified_hearing;
986: End If;
987: If (p_rec.eeoc_hearing_docket_num = hr_api.g_varchar2) then

Line 987: If (p_rec.eeoc_hearing_docket_num = hr_api.g_varchar2) then

983: If (p_rec.agency_notified_hearing = hr_api.g_date) then
984: p_rec.agency_notified_hearing :=
985: ghr_cmp_shd.g_old_rec.agency_notified_hearing;
986: End If;
987: If (p_rec.eeoc_hearing_docket_num = hr_api.g_varchar2) then
988: p_rec.eeoc_hearing_docket_num :=
989: ghr_cmp_shd.g_old_rec.eeoc_hearing_docket_num;
990: End If;
991: If (p_rec.hearing_complete = hr_api.g_date) then

Line 991: If (p_rec.hearing_complete = hr_api.g_date) then

987: If (p_rec.eeoc_hearing_docket_num = hr_api.g_varchar2) then
988: p_rec.eeoc_hearing_docket_num :=
989: ghr_cmp_shd.g_old_rec.eeoc_hearing_docket_num;
990: End If;
991: If (p_rec.hearing_complete = hr_api.g_date) then
992: p_rec.hearing_complete :=
993: ghr_cmp_shd.g_old_rec.hearing_complete;
994: End If;
995: If (p_rec.aj_merit_decision_date = hr_api.g_date) then

Line 995: If (p_rec.aj_merit_decision_date = hr_api.g_date) then

991: If (p_rec.hearing_complete = hr_api.g_date) then
992: p_rec.hearing_complete :=
993: ghr_cmp_shd.g_old_rec.hearing_complete;
994: End If;
995: If (p_rec.aj_merit_decision_date = hr_api.g_date) then
996: p_rec.aj_merit_decision_date :=
997: ghr_cmp_shd.g_old_rec.aj_merit_decision_date;
998: End If;
999: If (p_rec.agency_recvd_aj_merit_dec = hr_api.g_date) then

Line 999: If (p_rec.agency_recvd_aj_merit_dec = hr_api.g_date) then

995: If (p_rec.aj_merit_decision_date = hr_api.g_date) then
996: p_rec.aj_merit_decision_date :=
997: ghr_cmp_shd.g_old_rec.aj_merit_decision_date;
998: End If;
999: If (p_rec.agency_recvd_aj_merit_dec = hr_api.g_date) then
1000: p_rec.agency_recvd_aj_merit_dec :=
1001: ghr_cmp_shd.g_old_rec.agency_recvd_aj_merit_dec;
1002: End If;
1003: If (p_rec.aj_merit_decision = hr_api.g_varchar2) then

Line 1003: If (p_rec.aj_merit_decision = hr_api.g_varchar2) then

999: If (p_rec.agency_recvd_aj_merit_dec = hr_api.g_date) then
1000: p_rec.agency_recvd_aj_merit_dec :=
1001: ghr_cmp_shd.g_old_rec.agency_recvd_aj_merit_dec;
1002: End If;
1003: If (p_rec.aj_merit_decision = hr_api.g_varchar2) then
1004: p_rec.aj_merit_decision :=
1005: ghr_cmp_shd.g_old_rec.aj_merit_decision;
1006: End If;
1007: If (p_rec.aj_ca_decision_date = hr_api.g_date) then

Line 1007: If (p_rec.aj_ca_decision_date = hr_api.g_date) then

1003: If (p_rec.aj_merit_decision = hr_api.g_varchar2) then
1004: p_rec.aj_merit_decision :=
1005: ghr_cmp_shd.g_old_rec.aj_merit_decision;
1006: End If;
1007: If (p_rec.aj_ca_decision_date = hr_api.g_date) then
1008: p_rec.aj_ca_decision_date :=
1009: ghr_cmp_shd.g_old_rec.aj_ca_decision_date;
1010: End If;
1011: If (p_rec.agency_recvd_aj_ca_dec = hr_api.g_date) then

Line 1011: If (p_rec.agency_recvd_aj_ca_dec = hr_api.g_date) then

1007: If (p_rec.aj_ca_decision_date = hr_api.g_date) then
1008: p_rec.aj_ca_decision_date :=
1009: ghr_cmp_shd.g_old_rec.aj_ca_decision_date;
1010: End If;
1011: If (p_rec.agency_recvd_aj_ca_dec = hr_api.g_date) then
1012: p_rec.agency_recvd_aj_ca_dec :=
1013: ghr_cmp_shd.g_old_rec.agency_recvd_aj_ca_dec;
1014: End If;
1015: If (p_rec.aj_ca_decision = hr_api.g_varchar2) then

Line 1015: If (p_rec.aj_ca_decision = hr_api.g_varchar2) then

1011: If (p_rec.agency_recvd_aj_ca_dec = hr_api.g_date) then
1012: p_rec.agency_recvd_aj_ca_dec :=
1013: ghr_cmp_shd.g_old_rec.agency_recvd_aj_ca_dec;
1014: End If;
1015: If (p_rec.aj_ca_decision = hr_api.g_varchar2) then
1016: p_rec.aj_ca_decision :=
1017: ghr_cmp_shd.g_old_rec.aj_ca_decision;
1018: End If;
1019: If (p_rec.fad_requested = hr_api.g_date) then

Line 1019: If (p_rec.fad_requested = hr_api.g_date) then

1015: If (p_rec.aj_ca_decision = hr_api.g_varchar2) then
1016: p_rec.aj_ca_decision :=
1017: ghr_cmp_shd.g_old_rec.aj_ca_decision;
1018: End If;
1019: If (p_rec.fad_requested = hr_api.g_date) then
1020: p_rec.fad_requested :=
1021: ghr_cmp_shd.g_old_rec.fad_requested;
1022: End If;
1023: If (p_rec.merit_fad = hr_api.g_varchar2) then

Line 1023: If (p_rec.merit_fad = hr_api.g_varchar2) then

1019: If (p_rec.fad_requested = hr_api.g_date) then
1020: p_rec.fad_requested :=
1021: ghr_cmp_shd.g_old_rec.fad_requested;
1022: End If;
1023: If (p_rec.merit_fad = hr_api.g_varchar2) then
1024: p_rec.merit_fad :=
1025: ghr_cmp_shd.g_old_rec.merit_fad;
1026: End If;
1027: If (p_rec.attorney_fees_fad = hr_api.g_varchar2) then

Line 1027: If (p_rec.attorney_fees_fad = hr_api.g_varchar2) then

1023: If (p_rec.merit_fad = hr_api.g_varchar2) then
1024: p_rec.merit_fad :=
1025: ghr_cmp_shd.g_old_rec.merit_fad;
1026: End If;
1027: If (p_rec.attorney_fees_fad = hr_api.g_varchar2) then
1028: p_rec.attorney_fees_fad :=
1029: ghr_cmp_shd.g_old_rec.attorney_fees_fad;
1030: End If;
1031: If (p_rec.comp_damages_fad = hr_api.g_varchar2) then

Line 1031: If (p_rec.comp_damages_fad = hr_api.g_varchar2) then

1027: If (p_rec.attorney_fees_fad = hr_api.g_varchar2) then
1028: p_rec.attorney_fees_fad :=
1029: ghr_cmp_shd.g_old_rec.attorney_fees_fad;
1030: End If;
1031: If (p_rec.comp_damages_fad = hr_api.g_varchar2) then
1032: p_rec.comp_damages_fad :=
1033: ghr_cmp_shd.g_old_rec.comp_damages_fad;
1034: End If;
1035: If (p_rec.non_compliance_fad = hr_api.g_varchar2) then

Line 1035: If (p_rec.non_compliance_fad = hr_api.g_varchar2) then

1031: If (p_rec.comp_damages_fad = hr_api.g_varchar2) then
1032: p_rec.comp_damages_fad :=
1033: ghr_cmp_shd.g_old_rec.comp_damages_fad;
1034: End If;
1035: If (p_rec.non_compliance_fad = hr_api.g_varchar2) then
1036: p_rec.non_compliance_fad :=
1037: ghr_cmp_shd.g_old_rec.non_compliance_fad;
1038: End If;
1039: If (p_rec.fad_req_recvd_eeo_office = hr_api.g_date) then

Line 1039: If (p_rec.fad_req_recvd_eeo_office = hr_api.g_date) then

1035: If (p_rec.non_compliance_fad = hr_api.g_varchar2) then
1036: p_rec.non_compliance_fad :=
1037: ghr_cmp_shd.g_old_rec.non_compliance_fad;
1038: End If;
1039: If (p_rec.fad_req_recvd_eeo_office = hr_api.g_date) then
1040: p_rec.fad_req_recvd_eeo_office :=
1041: ghr_cmp_shd.g_old_rec.fad_req_recvd_eeo_office;
1042: End If;
1043: If (p_rec.fad_req_forwd_to_agency = hr_api.g_date) then

Line 1043: If (p_rec.fad_req_forwd_to_agency = hr_api.g_date) then

1039: If (p_rec.fad_req_recvd_eeo_office = hr_api.g_date) then
1040: p_rec.fad_req_recvd_eeo_office :=
1041: ghr_cmp_shd.g_old_rec.fad_req_recvd_eeo_office;
1042: End If;
1043: If (p_rec.fad_req_forwd_to_agency = hr_api.g_date) then
1044: p_rec.fad_req_forwd_to_agency :=
1045: ghr_cmp_shd.g_old_rec.fad_req_forwd_to_agency;
1046: End If;
1047: If (p_rec.agency_recvd_request = hr_api.g_date) then

Line 1047: If (p_rec.agency_recvd_request = hr_api.g_date) then

1043: If (p_rec.fad_req_forwd_to_agency = hr_api.g_date) then
1044: p_rec.fad_req_forwd_to_agency :=
1045: ghr_cmp_shd.g_old_rec.fad_req_forwd_to_agency;
1046: End If;
1047: If (p_rec.agency_recvd_request = hr_api.g_date) then
1048: p_rec.agency_recvd_request :=
1049: ghr_cmp_shd.g_old_rec.agency_recvd_request;
1050: End If;
1051: If (p_rec.fad_due = hr_api.g_date) then

Line 1051: If (p_rec.fad_due = hr_api.g_date) then

1047: If (p_rec.agency_recvd_request = hr_api.g_date) then
1048: p_rec.agency_recvd_request :=
1049: ghr_cmp_shd.g_old_rec.agency_recvd_request;
1050: End If;
1051: If (p_rec.fad_due = hr_api.g_date) then
1052: p_rec.fad_due :=
1053: ghr_cmp_shd.g_old_rec.fad_due;
1054: End If;
1055: If (p_rec.fad_date = hr_api.g_date) then

Line 1055: If (p_rec.fad_date = hr_api.g_date) then

1051: If (p_rec.fad_due = hr_api.g_date) then
1052: p_rec.fad_due :=
1053: ghr_cmp_shd.g_old_rec.fad_due;
1054: End If;
1055: If (p_rec.fad_date = hr_api.g_date) then
1056: p_rec.fad_date :=
1057: ghr_cmp_shd.g_old_rec.fad_date;
1058: End If;
1059: If (p_rec.fad_decision = hr_api.g_varchar2) then

Line 1059: If (p_rec.fad_decision = hr_api.g_varchar2) then

1055: If (p_rec.fad_date = hr_api.g_date) then
1056: p_rec.fad_date :=
1057: ghr_cmp_shd.g_old_rec.fad_date;
1058: End If;
1059: If (p_rec.fad_decision = hr_api.g_varchar2) then
1060: p_rec.fad_decision :=
1061: ghr_cmp_shd.g_old_rec.fad_decision;
1062: End If;
1063: /*

Line 1064: If (p_rec.fad_final_action_closure = hr_api.g_varchar2) then

1060: p_rec.fad_decision :=
1061: ghr_cmp_shd.g_old_rec.fad_decision;
1062: End If;
1063: /*
1064: If (p_rec.fad_final_action_closure = hr_api.g_varchar2) then
1065: p_rec.fad_final_action_closure :=
1066: ghr_cmp_shd.g_old_rec.fad_final_action_closure;
1067: End If;
1068: */

Line 1069: If (p_rec.fad_forwd_to_comrep = hr_api.g_date) then

1065: p_rec.fad_final_action_closure :=
1066: ghr_cmp_shd.g_old_rec.fad_final_action_closure;
1067: End If;
1068: */
1069: If (p_rec.fad_forwd_to_comrep = hr_api.g_date) then
1070: p_rec.fad_forwd_to_comrep :=
1071: ghr_cmp_shd.g_old_rec.fad_forwd_to_comrep;
1072: End If;
1073: If (p_rec.fad_recvd_by_comrep = hr_api.g_date) then

Line 1073: If (p_rec.fad_recvd_by_comrep = hr_api.g_date) then

1069: If (p_rec.fad_forwd_to_comrep = hr_api.g_date) then
1070: p_rec.fad_forwd_to_comrep :=
1071: ghr_cmp_shd.g_old_rec.fad_forwd_to_comrep;
1072: End If;
1073: If (p_rec.fad_recvd_by_comrep = hr_api.g_date) then
1074: p_rec.fad_recvd_by_comrep :=
1075: ghr_cmp_shd.g_old_rec.fad_recvd_by_comrep;
1076: End If;
1077: If (p_rec.fad_imp_ltr_forwd_to_org = hr_api.g_date) then

Line 1077: If (p_rec.fad_imp_ltr_forwd_to_org = hr_api.g_date) then

1073: If (p_rec.fad_recvd_by_comrep = hr_api.g_date) then
1074: p_rec.fad_recvd_by_comrep :=
1075: ghr_cmp_shd.g_old_rec.fad_recvd_by_comrep;
1076: End If;
1077: If (p_rec.fad_imp_ltr_forwd_to_org = hr_api.g_date) then
1078: p_rec.fad_imp_ltr_forwd_to_org :=
1079: ghr_cmp_shd.g_old_rec.fad_imp_ltr_forwd_to_org;
1080: End If;
1081: If (p_rec.fad_decision_forwd_legal = hr_api.g_date) then

Line 1081: If (p_rec.fad_decision_forwd_legal = hr_api.g_date) then

1077: If (p_rec.fad_imp_ltr_forwd_to_org = hr_api.g_date) then
1078: p_rec.fad_imp_ltr_forwd_to_org :=
1079: ghr_cmp_shd.g_old_rec.fad_imp_ltr_forwd_to_org;
1080: End If;
1081: If (p_rec.fad_decision_forwd_legal = hr_api.g_date) then
1082: p_rec.fad_decision_forwd_legal :=
1083: ghr_cmp_shd.g_old_rec.fad_decision_forwd_legal;
1084: End If;
1085: If (p_rec.fad_decision_recvd_legal = hr_api.g_date) then

Line 1085: If (p_rec.fad_decision_recvd_legal = hr_api.g_date) then

1081: If (p_rec.fad_decision_forwd_legal = hr_api.g_date) then
1082: p_rec.fad_decision_forwd_legal :=
1083: ghr_cmp_shd.g_old_rec.fad_decision_forwd_legal;
1084: End If;
1085: If (p_rec.fad_decision_recvd_legal = hr_api.g_date) then
1086: p_rec.fad_decision_recvd_legal :=
1087: ghr_cmp_shd.g_old_rec.fad_decision_recvd_legal;
1088: End If;
1089: If (p_rec.fa_source = hr_api.g_varchar2) then

Line 1089: If (p_rec.fa_source = hr_api.g_varchar2) then

1085: If (p_rec.fad_decision_recvd_legal = hr_api.g_date) then
1086: p_rec.fad_decision_recvd_legal :=
1087: ghr_cmp_shd.g_old_rec.fad_decision_recvd_legal;
1088: End If;
1089: If (p_rec.fa_source = hr_api.g_varchar2) then
1090: p_rec.fa_source :=
1091: ghr_cmp_shd.g_old_rec.fa_source;
1092: End If;
1093: If (p_rec.final_action_due = hr_api.g_date) then

Line 1093: If (p_rec.final_action_due = hr_api.g_date) then

1089: If (p_rec.fa_source = hr_api.g_varchar2) then
1090: p_rec.fa_source :=
1091: ghr_cmp_shd.g_old_rec.fa_source;
1092: End If;
1093: If (p_rec.final_action_due = hr_api.g_date) then
1094: p_rec.final_action_due :=
1095: ghr_cmp_shd.g_old_rec.final_action_due;
1096: End If;
1097: /*

Line 1098: If (p_rec.final_action_nature_of_closure = hr_api.g_varchar2) then

1094: p_rec.final_action_due :=
1095: ghr_cmp_shd.g_old_rec.final_action_due;
1096: End If;
1097: /*
1098: If (p_rec.final_action_nature_of_closure = hr_api.g_varchar2) then
1099: p_rec.final_action_nature_of_closure :=
1100: ghr_cmp_shd.g_old_rec.final_action_nature_of_closure;
1101: End If;
1102: */

Line 1103: If (p_rec.final_act_forwd_comrep = hr_api.g_date) then

1099: p_rec.final_action_nature_of_closure :=
1100: ghr_cmp_shd.g_old_rec.final_action_nature_of_closure;
1101: End If;
1102: */
1103: If (p_rec.final_act_forwd_comrep = hr_api.g_date) then
1104: p_rec.final_act_forwd_comrep :=
1105: ghr_cmp_shd.g_old_rec.final_act_forwd_comrep;
1106: End If;
1107: If (p_rec.final_act_recvd_comrep = hr_api.g_date) then

Line 1107: If (p_rec.final_act_recvd_comrep = hr_api.g_date) then

1103: If (p_rec.final_act_forwd_comrep = hr_api.g_date) then
1104: p_rec.final_act_forwd_comrep :=
1105: ghr_cmp_shd.g_old_rec.final_act_forwd_comrep;
1106: End If;
1107: If (p_rec.final_act_recvd_comrep = hr_api.g_date) then
1108: p_rec.final_act_recvd_comrep :=
1109: ghr_cmp_shd.g_old_rec.final_act_recvd_comrep;
1110: End If;
1111: If (p_rec.final_action_decision_date = hr_api.g_date) then

Line 1111: If (p_rec.final_action_decision_date = hr_api.g_date) then

1107: If (p_rec.final_act_recvd_comrep = hr_api.g_date) then
1108: p_rec.final_act_recvd_comrep :=
1109: ghr_cmp_shd.g_old_rec.final_act_recvd_comrep;
1110: End If;
1111: If (p_rec.final_action_decision_date = hr_api.g_date) then
1112: p_rec.final_action_decision_date :=
1113: ghr_cmp_shd.g_old_rec.final_action_decision_date;
1114: End If;
1115: If (p_rec.final_action_decision = hr_api.g_varchar2) then

Line 1115: If (p_rec.final_action_decision = hr_api.g_varchar2) then

1111: If (p_rec.final_action_decision_date = hr_api.g_date) then
1112: p_rec.final_action_decision_date :=
1113: ghr_cmp_shd.g_old_rec.final_action_decision_date;
1114: End If;
1115: If (p_rec.final_action_decision = hr_api.g_varchar2) then
1116: p_rec.final_action_decision :=
1117: ghr_cmp_shd.g_old_rec.final_action_decision;
1118: End If;
1119: If (p_rec.fa_imp_ltr_forwd_to_org = hr_api.g_date) then

Line 1119: If (p_rec.fa_imp_ltr_forwd_to_org = hr_api.g_date) then

1115: If (p_rec.final_action_decision = hr_api.g_varchar2) then
1116: p_rec.final_action_decision :=
1117: ghr_cmp_shd.g_old_rec.final_action_decision;
1118: End If;
1119: If (p_rec.fa_imp_ltr_forwd_to_org = hr_api.g_date) then
1120: p_rec.fa_imp_ltr_forwd_to_org :=
1121: ghr_cmp_shd.g_old_rec.fa_imp_ltr_forwd_to_org;
1122: End If;
1123: If (p_rec.fa_decision_forwd_legal = hr_api.g_date) then

Line 1123: If (p_rec.fa_decision_forwd_legal = hr_api.g_date) then

1119: If (p_rec.fa_imp_ltr_forwd_to_org = hr_api.g_date) then
1120: p_rec.fa_imp_ltr_forwd_to_org :=
1121: ghr_cmp_shd.g_old_rec.fa_imp_ltr_forwd_to_org;
1122: End If;
1123: If (p_rec.fa_decision_forwd_legal = hr_api.g_date) then
1124: p_rec.fa_decision_forwd_legal :=
1125: ghr_cmp_shd.g_old_rec.fa_decision_forwd_legal;
1126: End If;
1127: If (p_rec.fa_decision_recvd_legal = hr_api.g_date) then

Line 1127: If (p_rec.fa_decision_recvd_legal = hr_api.g_date) then

1123: If (p_rec.fa_decision_forwd_legal = hr_api.g_date) then
1124: p_rec.fa_decision_forwd_legal :=
1125: ghr_cmp_shd.g_old_rec.fa_decision_forwd_legal;
1126: End If;
1127: If (p_rec.fa_decision_recvd_legal = hr_api.g_date) then
1128: p_rec.fa_decision_recvd_legal :=
1129: ghr_cmp_shd.g_old_rec.fa_decision_recvd_legal;
1130: End If;
1131: If (p_rec.civil_action_filed = hr_api.g_date) then

Line 1131: If (p_rec.civil_action_filed = hr_api.g_date) then

1127: If (p_rec.fa_decision_recvd_legal = hr_api.g_date) then
1128: p_rec.fa_decision_recvd_legal :=
1129: ghr_cmp_shd.g_old_rec.fa_decision_recvd_legal;
1130: End If;
1131: If (p_rec.civil_action_filed = hr_api.g_date) then
1132: p_rec.civil_action_filed :=
1133: ghr_cmp_shd.g_old_rec.civil_action_filed;
1134: End If;
1135: If (p_rec.agency_closure_confirmed = hr_api.g_date) then

Line 1135: If (p_rec.agency_closure_confirmed = hr_api.g_date) then

1131: If (p_rec.civil_action_filed = hr_api.g_date) then
1132: p_rec.civil_action_filed :=
1133: ghr_cmp_shd.g_old_rec.civil_action_filed;
1134: End If;
1135: If (p_rec.agency_closure_confirmed = hr_api.g_date) then
1136: p_rec.agency_closure_confirmed :=
1137: ghr_cmp_shd.g_old_rec.agency_closure_confirmed;
1138: End If;
1139: If (p_rec.consolidated_complaint_id = hr_api.g_number) then

Line 1139: If (p_rec.consolidated_complaint_id = hr_api.g_number) then

1135: If (p_rec.agency_closure_confirmed = hr_api.g_date) then
1136: p_rec.agency_closure_confirmed :=
1137: ghr_cmp_shd.g_old_rec.agency_closure_confirmed;
1138: End If;
1139: If (p_rec.consolidated_complaint_id = hr_api.g_number) then
1140: p_rec.consolidated_complaint_id :=
1141: ghr_cmp_shd.g_old_rec.consolidated_complaint_id;
1142: End If;
1143: If (p_rec.consolidated = hr_api.g_date) then

Line 1143: If (p_rec.consolidated = hr_api.g_date) then

1139: If (p_rec.consolidated_complaint_id = hr_api.g_number) then
1140: p_rec.consolidated_complaint_id :=
1141: ghr_cmp_shd.g_old_rec.consolidated_complaint_id;
1142: End If;
1143: If (p_rec.consolidated = hr_api.g_date) then
1144: p_rec.consolidated :=
1145: ghr_cmp_shd.g_old_rec.consolidated;
1146: End If;
1147: If (p_rec.stage_of_consolidation = hr_api.g_varchar2) then

Line 1147: If (p_rec.stage_of_consolidation = hr_api.g_varchar2) then

1143: If (p_rec.consolidated = hr_api.g_date) then
1144: p_rec.consolidated :=
1145: ghr_cmp_shd.g_old_rec.consolidated;
1146: End If;
1147: If (p_rec.stage_of_consolidation = hr_api.g_varchar2) then
1148: p_rec.stage_of_consolidation :=
1149: ghr_cmp_shd.g_old_rec.stage_of_consolidation;
1150: End If;
1151: If (p_rec.comrep_notif_consolidation = hr_api.g_date) then

Line 1151: If (p_rec.comrep_notif_consolidation = hr_api.g_date) then

1147: If (p_rec.stage_of_consolidation = hr_api.g_varchar2) then
1148: p_rec.stage_of_consolidation :=
1149: ghr_cmp_shd.g_old_rec.stage_of_consolidation;
1150: End If;
1151: If (p_rec.comrep_notif_consolidation = hr_api.g_date) then
1152: p_rec.comrep_notif_consolidation :=
1153: ghr_cmp_shd.g_old_rec.comrep_notif_consolidation;
1154: End If;
1155: If (p_rec.consolidation_desc = hr_api.g_varchar2) then

Line 1155: If (p_rec.consolidation_desc = hr_api.g_varchar2) then

1151: If (p_rec.comrep_notif_consolidation = hr_api.g_date) then
1152: p_rec.comrep_notif_consolidation :=
1153: ghr_cmp_shd.g_old_rec.comrep_notif_consolidation;
1154: End If;
1155: If (p_rec.consolidation_desc = hr_api.g_varchar2) then
1156: p_rec.consolidation_desc :=
1157: ghr_cmp_shd.g_old_rec.consolidation_desc;
1158: End If;
1159: If (p_rec.complaint_closed = hr_api.g_date) then

Line 1159: If (p_rec.complaint_closed = hr_api.g_date) then

1155: If (p_rec.consolidation_desc = hr_api.g_varchar2) then
1156: p_rec.consolidation_desc :=
1157: ghr_cmp_shd.g_old_rec.consolidation_desc;
1158: End If;
1159: If (p_rec.complaint_closed = hr_api.g_date) then
1160: p_rec.complaint_closed :=
1161: ghr_cmp_shd.g_old_rec.complaint_closed;
1162: End If;
1163: If (p_rec.nature_of_closure = hr_api.g_varchar2) then

Line 1163: If (p_rec.nature_of_closure = hr_api.g_varchar2) then

1159: If (p_rec.complaint_closed = hr_api.g_date) then
1160: p_rec.complaint_closed :=
1161: ghr_cmp_shd.g_old_rec.complaint_closed;
1162: End If;
1163: If (p_rec.nature_of_closure = hr_api.g_varchar2) then
1164: p_rec.nature_of_closure :=
1165: ghr_cmp_shd.g_old_rec.nature_of_closure;
1166: End If;
1167: If (p_rec.complaint_closed_desc = hr_api.g_varchar2) then

Line 1167: If (p_rec.complaint_closed_desc = hr_api.g_varchar2) then

1163: If (p_rec.nature_of_closure = hr_api.g_varchar2) then
1164: p_rec.nature_of_closure :=
1165: ghr_cmp_shd.g_old_rec.nature_of_closure;
1166: End If;
1167: If (p_rec.complaint_closed_desc = hr_api.g_varchar2) then
1168: p_rec.complaint_closed_desc :=
1169: ghr_cmp_shd.g_old_rec.complaint_closed_desc;
1170: End If;
1171: If (p_rec.filed_formal_class = hr_api.g_date) then

Line 1171: If (p_rec.filed_formal_class = hr_api.g_date) then

1167: If (p_rec.complaint_closed_desc = hr_api.g_varchar2) then
1168: p_rec.complaint_closed_desc :=
1169: ghr_cmp_shd.g_old_rec.complaint_closed_desc;
1170: End If;
1171: If (p_rec.filed_formal_class = hr_api.g_date) then
1172: p_rec.filed_formal_class :=
1173: ghr_cmp_shd.g_old_rec.filed_formal_class;
1174: End If;
1175: If (p_rec.forwd_eeoc = hr_api.g_date) then

Line 1175: If (p_rec.forwd_eeoc = hr_api.g_date) then

1171: If (p_rec.filed_formal_class = hr_api.g_date) then
1172: p_rec.filed_formal_class :=
1173: ghr_cmp_shd.g_old_rec.filed_formal_class;
1174: End If;
1175: If (p_rec.forwd_eeoc = hr_api.g_date) then
1176: p_rec.forwd_eeoc :=
1177: ghr_cmp_shd.g_old_rec.forwd_eeoc;
1178: End If;
1179: If (p_rec.aj_cert_decision_date = hr_api.g_date) then

Line 1179: If (p_rec.aj_cert_decision_date = hr_api.g_date) then

1175: If (p_rec.forwd_eeoc = hr_api.g_date) then
1176: p_rec.forwd_eeoc :=
1177: ghr_cmp_shd.g_old_rec.forwd_eeoc;
1178: End If;
1179: If (p_rec.aj_cert_decision_date = hr_api.g_date) then
1180: p_rec.aj_cert_decision_date :=
1181: ghr_cmp_shd.g_old_rec.aj_cert_decision_date;
1182: End If;
1183: If (p_rec.aj_cert_decision_recvd = hr_api.g_date) then

Line 1183: If (p_rec.aj_cert_decision_recvd = hr_api.g_date) then

1179: If (p_rec.aj_cert_decision_date = hr_api.g_date) then
1180: p_rec.aj_cert_decision_date :=
1181: ghr_cmp_shd.g_old_rec.aj_cert_decision_date;
1182: End If;
1183: If (p_rec.aj_cert_decision_recvd = hr_api.g_date) then
1184: p_rec.aj_cert_decision_recvd :=
1185: ghr_cmp_shd.g_old_rec.aj_cert_decision_recvd;
1186: End If;
1187: If (p_rec.aj_cert_decision = hr_api.g_varchar2) then

Line 1187: If (p_rec.aj_cert_decision = hr_api.g_varchar2) then

1183: If (p_rec.aj_cert_decision_recvd = hr_api.g_date) then
1184: p_rec.aj_cert_decision_recvd :=
1185: ghr_cmp_shd.g_old_rec.aj_cert_decision_recvd;
1186: End If;
1187: If (p_rec.aj_cert_decision = hr_api.g_varchar2) then
1188: p_rec.aj_cert_decision :=
1189: ghr_cmp_shd.g_old_rec.aj_cert_decision;
1190: End If;
1191: If (p_rec.class_members_notified = hr_api.g_date) then

Line 1191: If (p_rec.class_members_notified = hr_api.g_date) then

1187: If (p_rec.aj_cert_decision = hr_api.g_varchar2) then
1188: p_rec.aj_cert_decision :=
1189: ghr_cmp_shd.g_old_rec.aj_cert_decision;
1190: End If;
1191: If (p_rec.class_members_notified = hr_api.g_date) then
1192: p_rec.class_members_notified :=
1193: ghr_cmp_shd.g_old_rec.class_members_notified;
1194: End If;
1195: If (p_rec.number_of_complaintants = hr_api.g_number) then

Line 1195: If (p_rec.number_of_complaintants = hr_api.g_number) then

1191: If (p_rec.class_members_notified = hr_api.g_date) then
1192: p_rec.class_members_notified :=
1193: ghr_cmp_shd.g_old_rec.class_members_notified;
1194: End If;
1195: If (p_rec.number_of_complaintants = hr_api.g_number) then
1196: p_rec.number_of_complaintants :=
1197: ghr_cmp_shd.g_old_rec.number_of_complaintants;
1198: End If;
1199: If (p_rec.class_hearing = hr_api.g_date) then

Line 1199: If (p_rec.class_hearing = hr_api.g_date) then

1195: If (p_rec.number_of_complaintants = hr_api.g_number) then
1196: p_rec.number_of_complaintants :=
1197: ghr_cmp_shd.g_old_rec.number_of_complaintants;
1198: End If;
1199: If (p_rec.class_hearing = hr_api.g_date) then
1200: p_rec.class_hearing :=
1201: ghr_cmp_shd.g_old_rec.class_hearing;
1202: End If;
1203: If (p_rec.aj_dec = hr_api.g_date) then

Line 1203: If (p_rec.aj_dec = hr_api.g_date) then

1199: If (p_rec.class_hearing = hr_api.g_date) then
1200: p_rec.class_hearing :=
1201: ghr_cmp_shd.g_old_rec.class_hearing;
1202: End If;
1203: If (p_rec.aj_dec = hr_api.g_date) then
1204: p_rec.aj_dec :=
1205: ghr_cmp_shd.g_old_rec.aj_dec;
1206: End If;
1207: If (p_rec.agency_recvd_aj_dec = hr_api.g_date) then

Line 1207: If (p_rec.agency_recvd_aj_dec = hr_api.g_date) then

1203: If (p_rec.aj_dec = hr_api.g_date) then
1204: p_rec.aj_dec :=
1205: ghr_cmp_shd.g_old_rec.aj_dec;
1206: End If;
1207: If (p_rec.agency_recvd_aj_dec = hr_api.g_date) then
1208: p_rec.agency_recvd_aj_dec :=
1209: ghr_cmp_shd.g_old_rec.agency_recvd_aj_dec;
1210: End If;
1211: If (p_rec.aj_decision = hr_api.g_varchar2) then

Line 1211: If (p_rec.aj_decision = hr_api.g_varchar2) then

1207: If (p_rec.agency_recvd_aj_dec = hr_api.g_date) then
1208: p_rec.agency_recvd_aj_dec :=
1209: ghr_cmp_shd.g_old_rec.agency_recvd_aj_dec;
1210: End If;
1211: If (p_rec.aj_decision = hr_api.g_varchar2) then
1212: p_rec.aj_decision :=
1213: ghr_cmp_shd.g_old_rec.aj_decision;
1214: End If;
1215: If (p_rec.agency_brief_eeoc = hr_api.g_date) then

Line 1215: If (p_rec.agency_brief_eeoc = hr_api.g_date) then

1211: If (p_rec.aj_decision = hr_api.g_varchar2) then
1212: p_rec.aj_decision :=
1213: ghr_cmp_shd.g_old_rec.aj_decision;
1214: End If;
1215: If (p_rec.agency_brief_eeoc = hr_api.g_date) then
1216: p_rec.agency_brief_eeoc :=
1217: ghr_cmp_shd.g_old_rec.agency_brief_eeoc;
1218: End If;
1219: If (p_rec.agency_notif_of_civil_action = hr_api.g_date) then

Line 1219: If (p_rec.agency_notif_of_civil_action = hr_api.g_date) then

1215: If (p_rec.agency_brief_eeoc = hr_api.g_date) then
1216: p_rec.agency_brief_eeoc :=
1217: ghr_cmp_shd.g_old_rec.agency_brief_eeoc;
1218: End If;
1219: If (p_rec.agency_notif_of_civil_action = hr_api.g_date) then
1220: p_rec.agency_notif_of_civil_action :=
1221: ghr_cmp_shd.g_old_rec.agency_notif_of_civil_action;
1222: End If;
1223: If (p_rec.fad_source = hr_api.g_varchar2) then

Line 1223: If (p_rec.fad_source = hr_api.g_varchar2) then

1219: If (p_rec.agency_notif_of_civil_action = hr_api.g_date) then
1220: p_rec.agency_notif_of_civil_action :=
1221: ghr_cmp_shd.g_old_rec.agency_notif_of_civil_action;
1222: End If;
1223: If (p_rec.fad_source = hr_api.g_varchar2) then
1224: p_rec.fad_source :=
1225: ghr_cmp_shd.g_old_rec.fad_source;
1226: End If;
1227: If (p_rec.agency_files_forwarded_eeoc = hr_api.g_date) then

Line 1227: If (p_rec.agency_files_forwarded_eeoc = hr_api.g_date) then

1223: If (p_rec.fad_source = hr_api.g_varchar2) then
1224: p_rec.fad_source :=
1225: ghr_cmp_shd.g_old_rec.fad_source;
1226: End If;
1227: If (p_rec.agency_files_forwarded_eeoc = hr_api.g_date) then
1228: p_rec.agency_files_forwarded_eeoc :=
1229: ghr_cmp_shd.g_old_rec.agency_files_forwarded_eeoc;
1230: End If;
1231: If (p_rec.hearing_req = hr_api.g_date) then

Line 1231: If (p_rec.hearing_req = hr_api.g_date) then

1227: If (p_rec.agency_files_forwarded_eeoc = hr_api.g_date) then
1228: p_rec.agency_files_forwarded_eeoc :=
1229: ghr_cmp_shd.g_old_rec.agency_files_forwarded_eeoc;
1230: End If;
1231: If (p_rec.hearing_req = hr_api.g_date) then
1232: p_rec.hearing_req :=
1233: ghr_cmp_shd.g_old_rec.hearing_req;
1234: End If;
1235: If (p_rec.agency_code = hr_api.g_varchar2) then

Line 1235: If (p_rec.agency_code = hr_api.g_varchar2) then

1231: If (p_rec.hearing_req = hr_api.g_date) then
1232: p_rec.hearing_req :=
1233: ghr_cmp_shd.g_old_rec.hearing_req;
1234: End If;
1235: If (p_rec.agency_code = hr_api.g_varchar2) then
1236: p_rec.agency_code :=
1237: ghr_cmp_shd.g_old_rec.agency_code;
1238: End If;
1239: If (p_rec.audited_by = hr_api.g_varchar2) then

Line 1239: If (p_rec.audited_by = hr_api.g_varchar2) then

1235: If (p_rec.agency_code = hr_api.g_varchar2) then
1236: p_rec.agency_code :=
1237: ghr_cmp_shd.g_old_rec.agency_code;
1238: End If;
1239: If (p_rec.audited_by = hr_api.g_varchar2) then
1240: p_rec.audited_by :=
1241: ghr_cmp_shd.g_old_rec.audited_by;
1242: End If;
1243: If (p_rec.record_received = hr_api.g_date) then

Line 1243: If (p_rec.record_received = hr_api.g_date) then

1239: If (p_rec.audited_by = hr_api.g_varchar2) then
1240: p_rec.audited_by :=
1241: ghr_cmp_shd.g_old_rec.audited_by;
1242: End If;
1243: If (p_rec.record_received = hr_api.g_date) then
1244: p_rec.record_received :=
1245: ghr_cmp_shd.g_old_rec.record_received;
1246: End If;
1247: ---------------------------------------------------------------------------

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

1245: ghr_cmp_shd.g_old_rec.record_received;
1246: End If;
1247: ---------------------------------------------------------------------------
1248:
1249: If (p_rec.attribute_category = hr_api.g_varchar2) then
1250: p_rec.attribute_category :=
1251: ghr_cmp_shd.g_old_rec.attribute_category;
1252: End If;
1253: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

1249: If (p_rec.attribute_category = hr_api.g_varchar2) then
1250: p_rec.attribute_category :=
1251: ghr_cmp_shd.g_old_rec.attribute_category;
1252: End If;
1253: If (p_rec.attribute1 = hr_api.g_varchar2) then
1254: p_rec.attribute1 :=
1255: ghr_cmp_shd.g_old_rec.attribute1;
1256: End If;
1257: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

1253: If (p_rec.attribute1 = hr_api.g_varchar2) then
1254: p_rec.attribute1 :=
1255: ghr_cmp_shd.g_old_rec.attribute1;
1256: End If;
1257: If (p_rec.attribute2 = hr_api.g_varchar2) then
1258: p_rec.attribute2 :=
1259: ghr_cmp_shd.g_old_rec.attribute2;
1260: End If;
1261: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

1257: If (p_rec.attribute2 = hr_api.g_varchar2) then
1258: p_rec.attribute2 :=
1259: ghr_cmp_shd.g_old_rec.attribute2;
1260: End If;
1261: If (p_rec.attribute3 = hr_api.g_varchar2) then
1262: p_rec.attribute3 :=
1263: ghr_cmp_shd.g_old_rec.attribute3;
1264: End If;
1265: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

1261: If (p_rec.attribute3 = hr_api.g_varchar2) then
1262: p_rec.attribute3 :=
1263: ghr_cmp_shd.g_old_rec.attribute3;
1264: End If;
1265: If (p_rec.attribute4 = hr_api.g_varchar2) then
1266: p_rec.attribute4 :=
1267: ghr_cmp_shd.g_old_rec.attribute4;
1268: End If;
1269: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

1265: If (p_rec.attribute4 = hr_api.g_varchar2) then
1266: p_rec.attribute4 :=
1267: ghr_cmp_shd.g_old_rec.attribute4;
1268: End If;
1269: If (p_rec.attribute5 = hr_api.g_varchar2) then
1270: p_rec.attribute5 :=
1271: ghr_cmp_shd.g_old_rec.attribute5;
1272: End If;
1273: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

1269: If (p_rec.attribute5 = hr_api.g_varchar2) then
1270: p_rec.attribute5 :=
1271: ghr_cmp_shd.g_old_rec.attribute5;
1272: End If;
1273: If (p_rec.attribute6 = hr_api.g_varchar2) then
1274: p_rec.attribute6 :=
1275: ghr_cmp_shd.g_old_rec.attribute6;
1276: End If;
1277: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

1273: If (p_rec.attribute6 = hr_api.g_varchar2) then
1274: p_rec.attribute6 :=
1275: ghr_cmp_shd.g_old_rec.attribute6;
1276: End If;
1277: If (p_rec.attribute7 = hr_api.g_varchar2) then
1278: p_rec.attribute7 :=
1279: ghr_cmp_shd.g_old_rec.attribute7;
1280: End If;
1281: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

1277: If (p_rec.attribute7 = hr_api.g_varchar2) then
1278: p_rec.attribute7 :=
1279: ghr_cmp_shd.g_old_rec.attribute7;
1280: End If;
1281: If (p_rec.attribute8 = hr_api.g_varchar2) then
1282: p_rec.attribute8 :=
1283: ghr_cmp_shd.g_old_rec.attribute8;
1284: End If;
1285: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

1281: If (p_rec.attribute8 = hr_api.g_varchar2) then
1282: p_rec.attribute8 :=
1283: ghr_cmp_shd.g_old_rec.attribute8;
1284: End If;
1285: If (p_rec.attribute9 = hr_api.g_varchar2) then
1286: p_rec.attribute9 :=
1287: ghr_cmp_shd.g_old_rec.attribute9;
1288: End If;
1289: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

1285: If (p_rec.attribute9 = hr_api.g_varchar2) then
1286: p_rec.attribute9 :=
1287: ghr_cmp_shd.g_old_rec.attribute9;
1288: End If;
1289: If (p_rec.attribute10 = hr_api.g_varchar2) then
1290: p_rec.attribute10 :=
1291: ghr_cmp_shd.g_old_rec.attribute10;
1292: End If;
1293: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

1289: If (p_rec.attribute10 = hr_api.g_varchar2) then
1290: p_rec.attribute10 :=
1291: ghr_cmp_shd.g_old_rec.attribute10;
1292: End If;
1293: If (p_rec.attribute11 = hr_api.g_varchar2) then
1294: p_rec.attribute11 :=
1295: ghr_cmp_shd.g_old_rec.attribute11;
1296: End If;
1297: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

1293: If (p_rec.attribute11 = hr_api.g_varchar2) then
1294: p_rec.attribute11 :=
1295: ghr_cmp_shd.g_old_rec.attribute11;
1296: End If;
1297: If (p_rec.attribute12 = hr_api.g_varchar2) then
1298: p_rec.attribute12 :=
1299: ghr_cmp_shd.g_old_rec.attribute12;
1300: End If;
1301: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

1297: If (p_rec.attribute12 = hr_api.g_varchar2) then
1298: p_rec.attribute12 :=
1299: ghr_cmp_shd.g_old_rec.attribute12;
1300: End If;
1301: If (p_rec.attribute13 = hr_api.g_varchar2) then
1302: p_rec.attribute13 :=
1303: ghr_cmp_shd.g_old_rec.attribute13;
1304: End If;
1305: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

1301: If (p_rec.attribute13 = hr_api.g_varchar2) then
1302: p_rec.attribute13 :=
1303: ghr_cmp_shd.g_old_rec.attribute13;
1304: End If;
1305: If (p_rec.attribute14 = hr_api.g_varchar2) then
1306: p_rec.attribute14 :=
1307: ghr_cmp_shd.g_old_rec.attribute14;
1308: End If;
1309: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

1305: If (p_rec.attribute14 = hr_api.g_varchar2) then
1306: p_rec.attribute14 :=
1307: ghr_cmp_shd.g_old_rec.attribute14;
1308: End If;
1309: If (p_rec.attribute15 = hr_api.g_varchar2) then
1310: p_rec.attribute15 :=
1311: ghr_cmp_shd.g_old_rec.attribute15;
1312: End If;
1313: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

1309: If (p_rec.attribute15 = hr_api.g_varchar2) then
1310: p_rec.attribute15 :=
1311: ghr_cmp_shd.g_old_rec.attribute15;
1312: End If;
1313: If (p_rec.attribute16 = hr_api.g_varchar2) then
1314: p_rec.attribute16 :=
1315: ghr_cmp_shd.g_old_rec.attribute16;
1316: End If;
1317: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

1313: If (p_rec.attribute16 = hr_api.g_varchar2) then
1314: p_rec.attribute16 :=
1315: ghr_cmp_shd.g_old_rec.attribute16;
1316: End If;
1317: If (p_rec.attribute17 = hr_api.g_varchar2) then
1318: p_rec.attribute17 :=
1319: ghr_cmp_shd.g_old_rec.attribute17;
1320: End If;
1321: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

1317: If (p_rec.attribute17 = hr_api.g_varchar2) then
1318: p_rec.attribute17 :=
1319: ghr_cmp_shd.g_old_rec.attribute17;
1320: End If;
1321: If (p_rec.attribute18 = hr_api.g_varchar2) then
1322: p_rec.attribute18 :=
1323: ghr_cmp_shd.g_old_rec.attribute18;
1324: End If;
1325: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

1321: If (p_rec.attribute18 = hr_api.g_varchar2) then
1322: p_rec.attribute18 :=
1323: ghr_cmp_shd.g_old_rec.attribute18;
1324: End If;
1325: If (p_rec.attribute19 = hr_api.g_varchar2) then
1326: p_rec.attribute19 :=
1327: ghr_cmp_shd.g_old_rec.attribute19;
1328: End If;
1329: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

1325: If (p_rec.attribute19 = hr_api.g_varchar2) then
1326: p_rec.attribute19 :=
1327: ghr_cmp_shd.g_old_rec.attribute19;
1328: End If;
1329: If (p_rec.attribute20 = hr_api.g_varchar2) then
1330: p_rec.attribute20 :=
1331: ghr_cmp_shd.g_old_rec.attribute20;
1332: End If;
1333: If (p_rec.attribute21 = hr_api.g_varchar2) then

Line 1333: If (p_rec.attribute21 = hr_api.g_varchar2) then

1329: If (p_rec.attribute20 = hr_api.g_varchar2) then
1330: p_rec.attribute20 :=
1331: ghr_cmp_shd.g_old_rec.attribute20;
1332: End If;
1333: If (p_rec.attribute21 = hr_api.g_varchar2) then
1334: p_rec.attribute21 :=
1335: ghr_cmp_shd.g_old_rec.attribute21;
1336: End If;
1337: If (p_rec.attribute22 = hr_api.g_varchar2) then

Line 1337: If (p_rec.attribute22 = hr_api.g_varchar2) then

1333: If (p_rec.attribute21 = hr_api.g_varchar2) then
1334: p_rec.attribute21 :=
1335: ghr_cmp_shd.g_old_rec.attribute21;
1336: End If;
1337: If (p_rec.attribute22 = hr_api.g_varchar2) then
1338: p_rec.attribute22 :=
1339: ghr_cmp_shd.g_old_rec.attribute22;
1340: End If;
1341: If (p_rec.attribute23 = hr_api.g_varchar2) then

Line 1341: If (p_rec.attribute23 = hr_api.g_varchar2) then

1337: If (p_rec.attribute22 = hr_api.g_varchar2) then
1338: p_rec.attribute22 :=
1339: ghr_cmp_shd.g_old_rec.attribute22;
1340: End If;
1341: If (p_rec.attribute23 = hr_api.g_varchar2) then
1342: p_rec.attribute23 :=
1343: ghr_cmp_shd.g_old_rec.attribute23;
1344: End If;
1345: If (p_rec.attribute24 = hr_api.g_varchar2) then

Line 1345: If (p_rec.attribute24 = hr_api.g_varchar2) then

1341: If (p_rec.attribute23 = hr_api.g_varchar2) then
1342: p_rec.attribute23 :=
1343: ghr_cmp_shd.g_old_rec.attribute23;
1344: End If;
1345: If (p_rec.attribute24 = hr_api.g_varchar2) then
1346: p_rec.attribute24 :=
1347: ghr_cmp_shd.g_old_rec.attribute24;
1348: End If;
1349: If (p_rec.attribute25 = hr_api.g_varchar2) then

Line 1349: If (p_rec.attribute25 = hr_api.g_varchar2) then

1345: If (p_rec.attribute24 = hr_api.g_varchar2) then
1346: p_rec.attribute24 :=
1347: ghr_cmp_shd.g_old_rec.attribute24;
1348: End If;
1349: If (p_rec.attribute25 = hr_api.g_varchar2) then
1350: p_rec.attribute25 :=
1351: ghr_cmp_shd.g_old_rec.attribute25;
1352: End If;
1353: If (p_rec.attribute26 = hr_api.g_varchar2) then

Line 1353: If (p_rec.attribute26 = hr_api.g_varchar2) then

1349: If (p_rec.attribute25 = hr_api.g_varchar2) then
1350: p_rec.attribute25 :=
1351: ghr_cmp_shd.g_old_rec.attribute25;
1352: End If;
1353: If (p_rec.attribute26 = hr_api.g_varchar2) then
1354: p_rec.attribute26 :=
1355: ghr_cmp_shd.g_old_rec.attribute26;
1356: End If;
1357: If (p_rec.attribute27 = hr_api.g_varchar2) then

Line 1357: If (p_rec.attribute27 = hr_api.g_varchar2) then

1353: If (p_rec.attribute26 = hr_api.g_varchar2) then
1354: p_rec.attribute26 :=
1355: ghr_cmp_shd.g_old_rec.attribute26;
1356: End If;
1357: If (p_rec.attribute27 = hr_api.g_varchar2) then
1358: p_rec.attribute27 :=
1359: ghr_cmp_shd.g_old_rec.attribute27;
1360: End If;
1361: If (p_rec.attribute28 = hr_api.g_varchar2) then

Line 1361: If (p_rec.attribute28 = hr_api.g_varchar2) then

1357: If (p_rec.attribute27 = hr_api.g_varchar2) then
1358: p_rec.attribute27 :=
1359: ghr_cmp_shd.g_old_rec.attribute27;
1360: End If;
1361: If (p_rec.attribute28 = hr_api.g_varchar2) then
1362: p_rec.attribute28 :=
1363: ghr_cmp_shd.g_old_rec.attribute28;
1364: End If;
1365: If (p_rec.attribute29 = hr_api.g_varchar2) then

Line 1365: If (p_rec.attribute29 = hr_api.g_varchar2) then

1361: If (p_rec.attribute28 = hr_api.g_varchar2) then
1362: p_rec.attribute28 :=
1363: ghr_cmp_shd.g_old_rec.attribute28;
1364: End If;
1365: If (p_rec.attribute29 = hr_api.g_varchar2) then
1366: p_rec.attribute29 :=
1367: ghr_cmp_shd.g_old_rec.attribute29;
1368: End If;
1369: If (p_rec.attribute30 = hr_api.g_varchar2) then

Line 1369: If (p_rec.attribute30 = hr_api.g_varchar2) then

1365: If (p_rec.attribute29 = hr_api.g_varchar2) then
1366: p_rec.attribute29 :=
1367: ghr_cmp_shd.g_old_rec.attribute29;
1368: End If;
1369: If (p_rec.attribute30 = hr_api.g_varchar2) then
1370: p_rec.attribute30 :=
1371: ghr_cmp_shd.g_old_rec.attribute30;
1372: End If;
1373: