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 GHR_CMP_SHD

Line 55: (p_rec in out nocopy ghr_cmp_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy ghr_cmp_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 241: ghr_cmp_shd.constraint_error

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));
243: When hr_api.parent_integrity_violated Then
244: -- Parent integrity has been violated
245: --

Line 246: 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));
248: When hr_api.unique_integrity_violated Then
249: -- Unique integrity has been violated
250: --

Line 251: 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));
253: When Others Then
254: --
255: Raise;

Line 291: (p_rec in ghr_cmp_shd.g_rec_type

287: --
288: -- {End Of Comments}
289: -- ----------------------------------------------------------------------------
290: Procedure pre_update
291: (p_rec in ghr_cmp_shd.g_rec_type
292: ) is
293: --
294: l_proc varchar2(72) := g_package||'pre_update';
295: --

Line 336: ,p_rec in ghr_cmp_shd.g_rec_type

332: -- {End Of Comments}
333: -- ----------------------------------------------------------------------------
334: Procedure post_update
335: (p_effective_date in date
336: ,p_rec in ghr_cmp_shd.g_rec_type
337: ) is
338: --
339: l_proc varchar2(72) := g_package||'post_update';
340: --

Line 508: ,p_complainant_person_id_o => ghr_cmp_shd.g_old_rec.complainant_person_id

504: ,p_attribute27 => p_rec.attribute27
505: ,p_attribute28 => p_rec.attribute28
506: ,p_attribute29 => p_rec.attribute29
507: ,p_attribute30 => p_rec.attribute30
508: ,p_complainant_person_id_o => ghr_cmp_shd.g_old_rec.complainant_person_id
509: ,p_business_group_id_o => ghr_cmp_shd.g_old_rec.business_group_id
510: ,p_docket_number_o => ghr_cmp_shd.g_old_rec.docket_number
511: ,p_stage_o => ghr_cmp_shd.g_old_rec.stage
512: ,p_class_flag_o => ghr_cmp_shd.g_old_rec.class_flag

Line 509: ,p_business_group_id_o => ghr_cmp_shd.g_old_rec.business_group_id

505: ,p_attribute28 => p_rec.attribute28
506: ,p_attribute29 => p_rec.attribute29
507: ,p_attribute30 => p_rec.attribute30
508: ,p_complainant_person_id_o => ghr_cmp_shd.g_old_rec.complainant_person_id
509: ,p_business_group_id_o => ghr_cmp_shd.g_old_rec.business_group_id
510: ,p_docket_number_o => ghr_cmp_shd.g_old_rec.docket_number
511: ,p_stage_o => ghr_cmp_shd.g_old_rec.stage
512: ,p_class_flag_o => ghr_cmp_shd.g_old_rec.class_flag
513: ,p_mixed_flag_o => ghr_cmp_shd.g_old_rec.mixed_flag

Line 510: ,p_docket_number_o => ghr_cmp_shd.g_old_rec.docket_number

506: ,p_attribute29 => p_rec.attribute29
507: ,p_attribute30 => p_rec.attribute30
508: ,p_complainant_person_id_o => ghr_cmp_shd.g_old_rec.complainant_person_id
509: ,p_business_group_id_o => ghr_cmp_shd.g_old_rec.business_group_id
510: ,p_docket_number_o => ghr_cmp_shd.g_old_rec.docket_number
511: ,p_stage_o => ghr_cmp_shd.g_old_rec.stage
512: ,p_class_flag_o => ghr_cmp_shd.g_old_rec.class_flag
513: ,p_mixed_flag_o => ghr_cmp_shd.g_old_rec.mixed_flag
514: ,p_consolidated_flag_o => ghr_cmp_shd.g_old_rec.consolidated_flag

Line 511: ,p_stage_o => ghr_cmp_shd.g_old_rec.stage

507: ,p_attribute30 => p_rec.attribute30
508: ,p_complainant_person_id_o => ghr_cmp_shd.g_old_rec.complainant_person_id
509: ,p_business_group_id_o => ghr_cmp_shd.g_old_rec.business_group_id
510: ,p_docket_number_o => ghr_cmp_shd.g_old_rec.docket_number
511: ,p_stage_o => ghr_cmp_shd.g_old_rec.stage
512: ,p_class_flag_o => ghr_cmp_shd.g_old_rec.class_flag
513: ,p_mixed_flag_o => ghr_cmp_shd.g_old_rec.mixed_flag
514: ,p_consolidated_flag_o => ghr_cmp_shd.g_old_rec.consolidated_flag
515: ,p_remand_flag_o => ghr_cmp_shd.g_old_rec.remand_flag

Line 512: ,p_class_flag_o => ghr_cmp_shd.g_old_rec.class_flag

508: ,p_complainant_person_id_o => ghr_cmp_shd.g_old_rec.complainant_person_id
509: ,p_business_group_id_o => ghr_cmp_shd.g_old_rec.business_group_id
510: ,p_docket_number_o => ghr_cmp_shd.g_old_rec.docket_number
511: ,p_stage_o => ghr_cmp_shd.g_old_rec.stage
512: ,p_class_flag_o => ghr_cmp_shd.g_old_rec.class_flag
513: ,p_mixed_flag_o => ghr_cmp_shd.g_old_rec.mixed_flag
514: ,p_consolidated_flag_o => ghr_cmp_shd.g_old_rec.consolidated_flag
515: ,p_remand_flag_o => ghr_cmp_shd.g_old_rec.remand_flag
516: ,p_active_flag_o => ghr_cmp_shd.g_old_rec.active_flag

Line 513: ,p_mixed_flag_o => ghr_cmp_shd.g_old_rec.mixed_flag

509: ,p_business_group_id_o => ghr_cmp_shd.g_old_rec.business_group_id
510: ,p_docket_number_o => ghr_cmp_shd.g_old_rec.docket_number
511: ,p_stage_o => ghr_cmp_shd.g_old_rec.stage
512: ,p_class_flag_o => ghr_cmp_shd.g_old_rec.class_flag
513: ,p_mixed_flag_o => ghr_cmp_shd.g_old_rec.mixed_flag
514: ,p_consolidated_flag_o => ghr_cmp_shd.g_old_rec.consolidated_flag
515: ,p_remand_flag_o => ghr_cmp_shd.g_old_rec.remand_flag
516: ,p_active_flag_o => ghr_cmp_shd.g_old_rec.active_flag
517: ,p_information_inquiry_o => ghr_cmp_shd.g_old_rec.information_inquiry

Line 514: ,p_consolidated_flag_o => ghr_cmp_shd.g_old_rec.consolidated_flag

510: ,p_docket_number_o => ghr_cmp_shd.g_old_rec.docket_number
511: ,p_stage_o => ghr_cmp_shd.g_old_rec.stage
512: ,p_class_flag_o => ghr_cmp_shd.g_old_rec.class_flag
513: ,p_mixed_flag_o => ghr_cmp_shd.g_old_rec.mixed_flag
514: ,p_consolidated_flag_o => ghr_cmp_shd.g_old_rec.consolidated_flag
515: ,p_remand_flag_o => ghr_cmp_shd.g_old_rec.remand_flag
516: ,p_active_flag_o => ghr_cmp_shd.g_old_rec.active_flag
517: ,p_information_inquiry_o => ghr_cmp_shd.g_old_rec.information_inquiry
518: ,p_pcom_init_o => ghr_cmp_shd.g_old_rec.pcom_init

Line 515: ,p_remand_flag_o => ghr_cmp_shd.g_old_rec.remand_flag

511: ,p_stage_o => ghr_cmp_shd.g_old_rec.stage
512: ,p_class_flag_o => ghr_cmp_shd.g_old_rec.class_flag
513: ,p_mixed_flag_o => ghr_cmp_shd.g_old_rec.mixed_flag
514: ,p_consolidated_flag_o => ghr_cmp_shd.g_old_rec.consolidated_flag
515: ,p_remand_flag_o => ghr_cmp_shd.g_old_rec.remand_flag
516: ,p_active_flag_o => ghr_cmp_shd.g_old_rec.active_flag
517: ,p_information_inquiry_o => ghr_cmp_shd.g_old_rec.information_inquiry
518: ,p_pcom_init_o => ghr_cmp_shd.g_old_rec.pcom_init
519: ,p_alleg_incident_o => ghr_cmp_shd.g_old_rec.alleg_incident

Line 516: ,p_active_flag_o => ghr_cmp_shd.g_old_rec.active_flag

512: ,p_class_flag_o => ghr_cmp_shd.g_old_rec.class_flag
513: ,p_mixed_flag_o => ghr_cmp_shd.g_old_rec.mixed_flag
514: ,p_consolidated_flag_o => ghr_cmp_shd.g_old_rec.consolidated_flag
515: ,p_remand_flag_o => ghr_cmp_shd.g_old_rec.remand_flag
516: ,p_active_flag_o => ghr_cmp_shd.g_old_rec.active_flag
517: ,p_information_inquiry_o => ghr_cmp_shd.g_old_rec.information_inquiry
518: ,p_pcom_init_o => ghr_cmp_shd.g_old_rec.pcom_init
519: ,p_alleg_incident_o => ghr_cmp_shd.g_old_rec.alleg_incident
520: ,p_alleg_discrim_org_id_o => ghr_cmp_shd.g_old_rec.alleg_discrim_org_id

Line 517: ,p_information_inquiry_o => ghr_cmp_shd.g_old_rec.information_inquiry

513: ,p_mixed_flag_o => ghr_cmp_shd.g_old_rec.mixed_flag
514: ,p_consolidated_flag_o => ghr_cmp_shd.g_old_rec.consolidated_flag
515: ,p_remand_flag_o => ghr_cmp_shd.g_old_rec.remand_flag
516: ,p_active_flag_o => ghr_cmp_shd.g_old_rec.active_flag
517: ,p_information_inquiry_o => ghr_cmp_shd.g_old_rec.information_inquiry
518: ,p_pcom_init_o => ghr_cmp_shd.g_old_rec.pcom_init
519: ,p_alleg_incident_o => ghr_cmp_shd.g_old_rec.alleg_incident
520: ,p_alleg_discrim_org_id_o => ghr_cmp_shd.g_old_rec.alleg_discrim_org_id
521: ,p_rr_ltr_date_o => ghr_cmp_shd.g_old_rec.rr_ltr_date

Line 518: ,p_pcom_init_o => ghr_cmp_shd.g_old_rec.pcom_init

514: ,p_consolidated_flag_o => ghr_cmp_shd.g_old_rec.consolidated_flag
515: ,p_remand_flag_o => ghr_cmp_shd.g_old_rec.remand_flag
516: ,p_active_flag_o => ghr_cmp_shd.g_old_rec.active_flag
517: ,p_information_inquiry_o => ghr_cmp_shd.g_old_rec.information_inquiry
518: ,p_pcom_init_o => ghr_cmp_shd.g_old_rec.pcom_init
519: ,p_alleg_incident_o => ghr_cmp_shd.g_old_rec.alleg_incident
520: ,p_alleg_discrim_org_id_o => ghr_cmp_shd.g_old_rec.alleg_discrim_org_id
521: ,p_rr_ltr_date_o => ghr_cmp_shd.g_old_rec.rr_ltr_date
522: ,p_rr_ltr_recvd_o => ghr_cmp_shd.g_old_rec.rr_ltr_recvd

Line 519: ,p_alleg_incident_o => ghr_cmp_shd.g_old_rec.alleg_incident

515: ,p_remand_flag_o => ghr_cmp_shd.g_old_rec.remand_flag
516: ,p_active_flag_o => ghr_cmp_shd.g_old_rec.active_flag
517: ,p_information_inquiry_o => ghr_cmp_shd.g_old_rec.information_inquiry
518: ,p_pcom_init_o => ghr_cmp_shd.g_old_rec.pcom_init
519: ,p_alleg_incident_o => ghr_cmp_shd.g_old_rec.alleg_incident
520: ,p_alleg_discrim_org_id_o => ghr_cmp_shd.g_old_rec.alleg_discrim_org_id
521: ,p_rr_ltr_date_o => ghr_cmp_shd.g_old_rec.rr_ltr_date
522: ,p_rr_ltr_recvd_o => ghr_cmp_shd.g_old_rec.rr_ltr_recvd
523: ,p_pre_com_elec_o => ghr_cmp_shd.g_old_rec.pre_com_elec

Line 520: ,p_alleg_discrim_org_id_o => ghr_cmp_shd.g_old_rec.alleg_discrim_org_id

516: ,p_active_flag_o => ghr_cmp_shd.g_old_rec.active_flag
517: ,p_information_inquiry_o => ghr_cmp_shd.g_old_rec.information_inquiry
518: ,p_pcom_init_o => ghr_cmp_shd.g_old_rec.pcom_init
519: ,p_alleg_incident_o => ghr_cmp_shd.g_old_rec.alleg_incident
520: ,p_alleg_discrim_org_id_o => ghr_cmp_shd.g_old_rec.alleg_discrim_org_id
521: ,p_rr_ltr_date_o => ghr_cmp_shd.g_old_rec.rr_ltr_date
522: ,p_rr_ltr_recvd_o => ghr_cmp_shd.g_old_rec.rr_ltr_recvd
523: ,p_pre_com_elec_o => ghr_cmp_shd.g_old_rec.pre_com_elec
524: --,p_adr_offered_o => ghr_cmp_shd.g_old_rec.adr_offered

Line 521: ,p_rr_ltr_date_o => ghr_cmp_shd.g_old_rec.rr_ltr_date

517: ,p_information_inquiry_o => ghr_cmp_shd.g_old_rec.information_inquiry
518: ,p_pcom_init_o => ghr_cmp_shd.g_old_rec.pcom_init
519: ,p_alleg_incident_o => ghr_cmp_shd.g_old_rec.alleg_incident
520: ,p_alleg_discrim_org_id_o => ghr_cmp_shd.g_old_rec.alleg_discrim_org_id
521: ,p_rr_ltr_date_o => ghr_cmp_shd.g_old_rec.rr_ltr_date
522: ,p_rr_ltr_recvd_o => ghr_cmp_shd.g_old_rec.rr_ltr_recvd
523: ,p_pre_com_elec_o => ghr_cmp_shd.g_old_rec.pre_com_elec
524: --,p_adr_offered_o => ghr_cmp_shd.g_old_rec.adr_offered
525: ,p_class_agent_flag_o => ghr_cmp_shd.g_old_rec.class_agent_flag

Line 522: ,p_rr_ltr_recvd_o => ghr_cmp_shd.g_old_rec.rr_ltr_recvd

518: ,p_pcom_init_o => ghr_cmp_shd.g_old_rec.pcom_init
519: ,p_alleg_incident_o => ghr_cmp_shd.g_old_rec.alleg_incident
520: ,p_alleg_discrim_org_id_o => ghr_cmp_shd.g_old_rec.alleg_discrim_org_id
521: ,p_rr_ltr_date_o => ghr_cmp_shd.g_old_rec.rr_ltr_date
522: ,p_rr_ltr_recvd_o => ghr_cmp_shd.g_old_rec.rr_ltr_recvd
523: ,p_pre_com_elec_o => ghr_cmp_shd.g_old_rec.pre_com_elec
524: --,p_adr_offered_o => ghr_cmp_shd.g_old_rec.adr_offered
525: ,p_class_agent_flag_o => ghr_cmp_shd.g_old_rec.class_agent_flag
526: ,p_pre_com_desc_o => ghr_cmp_shd.g_old_rec.pre_com_desc

Line 523: ,p_pre_com_elec_o => ghr_cmp_shd.g_old_rec.pre_com_elec

519: ,p_alleg_incident_o => ghr_cmp_shd.g_old_rec.alleg_incident
520: ,p_alleg_discrim_org_id_o => ghr_cmp_shd.g_old_rec.alleg_discrim_org_id
521: ,p_rr_ltr_date_o => ghr_cmp_shd.g_old_rec.rr_ltr_date
522: ,p_rr_ltr_recvd_o => ghr_cmp_shd.g_old_rec.rr_ltr_recvd
523: ,p_pre_com_elec_o => ghr_cmp_shd.g_old_rec.pre_com_elec
524: --,p_adr_offered_o => ghr_cmp_shd.g_old_rec.adr_offered
525: ,p_class_agent_flag_o => ghr_cmp_shd.g_old_rec.class_agent_flag
526: ,p_pre_com_desc_o => ghr_cmp_shd.g_old_rec.pre_com_desc
527: ,p_counselor_asg_o => ghr_cmp_shd.g_old_rec.counselor_asg

Line 524: --,p_adr_offered_o => ghr_cmp_shd.g_old_rec.adr_offered

520: ,p_alleg_discrim_org_id_o => ghr_cmp_shd.g_old_rec.alleg_discrim_org_id
521: ,p_rr_ltr_date_o => ghr_cmp_shd.g_old_rec.rr_ltr_date
522: ,p_rr_ltr_recvd_o => ghr_cmp_shd.g_old_rec.rr_ltr_recvd
523: ,p_pre_com_elec_o => ghr_cmp_shd.g_old_rec.pre_com_elec
524: --,p_adr_offered_o => ghr_cmp_shd.g_old_rec.adr_offered
525: ,p_class_agent_flag_o => ghr_cmp_shd.g_old_rec.class_agent_flag
526: ,p_pre_com_desc_o => ghr_cmp_shd.g_old_rec.pre_com_desc
527: ,p_counselor_asg_o => ghr_cmp_shd.g_old_rec.counselor_asg
528: ,p_init_counselor_interview_o => ghr_cmp_shd.g_old_rec.init_counselor_interview

Line 525: ,p_class_agent_flag_o => ghr_cmp_shd.g_old_rec.class_agent_flag

521: ,p_rr_ltr_date_o => ghr_cmp_shd.g_old_rec.rr_ltr_date
522: ,p_rr_ltr_recvd_o => ghr_cmp_shd.g_old_rec.rr_ltr_recvd
523: ,p_pre_com_elec_o => ghr_cmp_shd.g_old_rec.pre_com_elec
524: --,p_adr_offered_o => ghr_cmp_shd.g_old_rec.adr_offered
525: ,p_class_agent_flag_o => ghr_cmp_shd.g_old_rec.class_agent_flag
526: ,p_pre_com_desc_o => ghr_cmp_shd.g_old_rec.pre_com_desc
527: ,p_counselor_asg_o => ghr_cmp_shd.g_old_rec.counselor_asg
528: ,p_init_counselor_interview_o => ghr_cmp_shd.g_old_rec.init_counselor_interview
529: ,p_anonymity_requested_o => ghr_cmp_shd.g_old_rec.anonymity_requested

Line 526: ,p_pre_com_desc_o => ghr_cmp_shd.g_old_rec.pre_com_desc

522: ,p_rr_ltr_recvd_o => ghr_cmp_shd.g_old_rec.rr_ltr_recvd
523: ,p_pre_com_elec_o => ghr_cmp_shd.g_old_rec.pre_com_elec
524: --,p_adr_offered_o => ghr_cmp_shd.g_old_rec.adr_offered
525: ,p_class_agent_flag_o => ghr_cmp_shd.g_old_rec.class_agent_flag
526: ,p_pre_com_desc_o => ghr_cmp_shd.g_old_rec.pre_com_desc
527: ,p_counselor_asg_o => ghr_cmp_shd.g_old_rec.counselor_asg
528: ,p_init_counselor_interview_o => ghr_cmp_shd.g_old_rec.init_counselor_interview
529: ,p_anonymity_requested_o => ghr_cmp_shd.g_old_rec.anonymity_requested
530: ,p_counsel_ext_ltr_o => ghr_cmp_shd.g_old_rec.counsel_ext_ltr

Line 527: ,p_counselor_asg_o => ghr_cmp_shd.g_old_rec.counselor_asg

523: ,p_pre_com_elec_o => ghr_cmp_shd.g_old_rec.pre_com_elec
524: --,p_adr_offered_o => ghr_cmp_shd.g_old_rec.adr_offered
525: ,p_class_agent_flag_o => ghr_cmp_shd.g_old_rec.class_agent_flag
526: ,p_pre_com_desc_o => ghr_cmp_shd.g_old_rec.pre_com_desc
527: ,p_counselor_asg_o => ghr_cmp_shd.g_old_rec.counselor_asg
528: ,p_init_counselor_interview_o => ghr_cmp_shd.g_old_rec.init_counselor_interview
529: ,p_anonymity_requested_o => ghr_cmp_shd.g_old_rec.anonymity_requested
530: ,p_counsel_ext_ltr_o => ghr_cmp_shd.g_old_rec.counsel_ext_ltr
531: ,p_traditional_counsel_outcom_o => ghr_cmp_shd.g_old_rec.traditional_counsel_outcome

Line 528: ,p_init_counselor_interview_o => ghr_cmp_shd.g_old_rec.init_counselor_interview

524: --,p_adr_offered_o => ghr_cmp_shd.g_old_rec.adr_offered
525: ,p_class_agent_flag_o => ghr_cmp_shd.g_old_rec.class_agent_flag
526: ,p_pre_com_desc_o => ghr_cmp_shd.g_old_rec.pre_com_desc
527: ,p_counselor_asg_o => ghr_cmp_shd.g_old_rec.counselor_asg
528: ,p_init_counselor_interview_o => ghr_cmp_shd.g_old_rec.init_counselor_interview
529: ,p_anonymity_requested_o => ghr_cmp_shd.g_old_rec.anonymity_requested
530: ,p_counsel_ext_ltr_o => ghr_cmp_shd.g_old_rec.counsel_ext_ltr
531: ,p_traditional_counsel_outcom_o => ghr_cmp_shd.g_old_rec.traditional_counsel_outcome
532: ,p_final_interview_o => ghr_cmp_shd.g_old_rec.final_interview

Line 529: ,p_anonymity_requested_o => ghr_cmp_shd.g_old_rec.anonymity_requested

525: ,p_class_agent_flag_o => ghr_cmp_shd.g_old_rec.class_agent_flag
526: ,p_pre_com_desc_o => ghr_cmp_shd.g_old_rec.pre_com_desc
527: ,p_counselor_asg_o => ghr_cmp_shd.g_old_rec.counselor_asg
528: ,p_init_counselor_interview_o => ghr_cmp_shd.g_old_rec.init_counselor_interview
529: ,p_anonymity_requested_o => ghr_cmp_shd.g_old_rec.anonymity_requested
530: ,p_counsel_ext_ltr_o => ghr_cmp_shd.g_old_rec.counsel_ext_ltr
531: ,p_traditional_counsel_outcom_o => ghr_cmp_shd.g_old_rec.traditional_counsel_outcome
532: ,p_final_interview_o => ghr_cmp_shd.g_old_rec.final_interview
533: ,p_notice_rtf_recvd_o => ghr_cmp_shd.g_old_rec.notice_rtf_recvd

Line 530: ,p_counsel_ext_ltr_o => ghr_cmp_shd.g_old_rec.counsel_ext_ltr

526: ,p_pre_com_desc_o => ghr_cmp_shd.g_old_rec.pre_com_desc
527: ,p_counselor_asg_o => ghr_cmp_shd.g_old_rec.counselor_asg
528: ,p_init_counselor_interview_o => ghr_cmp_shd.g_old_rec.init_counselor_interview
529: ,p_anonymity_requested_o => ghr_cmp_shd.g_old_rec.anonymity_requested
530: ,p_counsel_ext_ltr_o => ghr_cmp_shd.g_old_rec.counsel_ext_ltr
531: ,p_traditional_counsel_outcom_o => ghr_cmp_shd.g_old_rec.traditional_counsel_outcome
532: ,p_final_interview_o => ghr_cmp_shd.g_old_rec.final_interview
533: ,p_notice_rtf_recvd_o => ghr_cmp_shd.g_old_rec.notice_rtf_recvd
534: ,p_precom_closed_o => ghr_cmp_shd.g_old_rec.precom_closed

Line 531: ,p_traditional_counsel_outcom_o => ghr_cmp_shd.g_old_rec.traditional_counsel_outcome

527: ,p_counselor_asg_o => ghr_cmp_shd.g_old_rec.counselor_asg
528: ,p_init_counselor_interview_o => ghr_cmp_shd.g_old_rec.init_counselor_interview
529: ,p_anonymity_requested_o => ghr_cmp_shd.g_old_rec.anonymity_requested
530: ,p_counsel_ext_ltr_o => ghr_cmp_shd.g_old_rec.counsel_ext_ltr
531: ,p_traditional_counsel_outcom_o => ghr_cmp_shd.g_old_rec.traditional_counsel_outcome
532: ,p_final_interview_o => ghr_cmp_shd.g_old_rec.final_interview
533: ,p_notice_rtf_recvd_o => ghr_cmp_shd.g_old_rec.notice_rtf_recvd
534: ,p_precom_closed_o => ghr_cmp_shd.g_old_rec.precom_closed
535: ,p_precom_closure_nature_o => ghr_cmp_shd.g_old_rec.precom_closure_nature

Line 532: ,p_final_interview_o => ghr_cmp_shd.g_old_rec.final_interview

528: ,p_init_counselor_interview_o => ghr_cmp_shd.g_old_rec.init_counselor_interview
529: ,p_anonymity_requested_o => ghr_cmp_shd.g_old_rec.anonymity_requested
530: ,p_counsel_ext_ltr_o => ghr_cmp_shd.g_old_rec.counsel_ext_ltr
531: ,p_traditional_counsel_outcom_o => ghr_cmp_shd.g_old_rec.traditional_counsel_outcome
532: ,p_final_interview_o => ghr_cmp_shd.g_old_rec.final_interview
533: ,p_notice_rtf_recvd_o => ghr_cmp_shd.g_old_rec.notice_rtf_recvd
534: ,p_precom_closed_o => ghr_cmp_shd.g_old_rec.precom_closed
535: ,p_precom_closure_nature_o => ghr_cmp_shd.g_old_rec.precom_closure_nature
536: ,p_counselor_rpt_sub_o => ghr_cmp_shd.g_old_rec.counselor_rpt_sub

Line 533: ,p_notice_rtf_recvd_o => ghr_cmp_shd.g_old_rec.notice_rtf_recvd

529: ,p_anonymity_requested_o => ghr_cmp_shd.g_old_rec.anonymity_requested
530: ,p_counsel_ext_ltr_o => ghr_cmp_shd.g_old_rec.counsel_ext_ltr
531: ,p_traditional_counsel_outcom_o => ghr_cmp_shd.g_old_rec.traditional_counsel_outcome
532: ,p_final_interview_o => ghr_cmp_shd.g_old_rec.final_interview
533: ,p_notice_rtf_recvd_o => ghr_cmp_shd.g_old_rec.notice_rtf_recvd
534: ,p_precom_closed_o => ghr_cmp_shd.g_old_rec.precom_closed
535: ,p_precom_closure_nature_o => ghr_cmp_shd.g_old_rec.precom_closure_nature
536: ,p_counselor_rpt_sub_o => ghr_cmp_shd.g_old_rec.counselor_rpt_sub
537: ,p_hr_office_org_id_o => ghr_cmp_shd.g_old_rec.hr_office_org_id

Line 534: ,p_precom_closed_o => ghr_cmp_shd.g_old_rec.precom_closed

530: ,p_counsel_ext_ltr_o => ghr_cmp_shd.g_old_rec.counsel_ext_ltr
531: ,p_traditional_counsel_outcom_o => ghr_cmp_shd.g_old_rec.traditional_counsel_outcome
532: ,p_final_interview_o => ghr_cmp_shd.g_old_rec.final_interview
533: ,p_notice_rtf_recvd_o => ghr_cmp_shd.g_old_rec.notice_rtf_recvd
534: ,p_precom_closed_o => ghr_cmp_shd.g_old_rec.precom_closed
535: ,p_precom_closure_nature_o => ghr_cmp_shd.g_old_rec.precom_closure_nature
536: ,p_counselor_rpt_sub_o => ghr_cmp_shd.g_old_rec.counselor_rpt_sub
537: ,p_hr_office_org_id_o => ghr_cmp_shd.g_old_rec.hr_office_org_id
538: ,p_eeo_office_org_id_o => ghr_cmp_shd.g_old_rec.eeo_office_org_id

Line 535: ,p_precom_closure_nature_o => ghr_cmp_shd.g_old_rec.precom_closure_nature

531: ,p_traditional_counsel_outcom_o => ghr_cmp_shd.g_old_rec.traditional_counsel_outcome
532: ,p_final_interview_o => ghr_cmp_shd.g_old_rec.final_interview
533: ,p_notice_rtf_recvd_o => ghr_cmp_shd.g_old_rec.notice_rtf_recvd
534: ,p_precom_closed_o => ghr_cmp_shd.g_old_rec.precom_closed
535: ,p_precom_closure_nature_o => ghr_cmp_shd.g_old_rec.precom_closure_nature
536: ,p_counselor_rpt_sub_o => ghr_cmp_shd.g_old_rec.counselor_rpt_sub
537: ,p_hr_office_org_id_o => ghr_cmp_shd.g_old_rec.hr_office_org_id
538: ,p_eeo_office_org_id_o => ghr_cmp_shd.g_old_rec.eeo_office_org_id
539: ,p_serviced_org_id_o => ghr_cmp_shd.g_old_rec.serviced_org_id

Line 536: ,p_counselor_rpt_sub_o => ghr_cmp_shd.g_old_rec.counselor_rpt_sub

532: ,p_final_interview_o => ghr_cmp_shd.g_old_rec.final_interview
533: ,p_notice_rtf_recvd_o => ghr_cmp_shd.g_old_rec.notice_rtf_recvd
534: ,p_precom_closed_o => ghr_cmp_shd.g_old_rec.precom_closed
535: ,p_precom_closure_nature_o => ghr_cmp_shd.g_old_rec.precom_closure_nature
536: ,p_counselor_rpt_sub_o => ghr_cmp_shd.g_old_rec.counselor_rpt_sub
537: ,p_hr_office_org_id_o => ghr_cmp_shd.g_old_rec.hr_office_org_id
538: ,p_eeo_office_org_id_o => ghr_cmp_shd.g_old_rec.eeo_office_org_id
539: ,p_serviced_org_id_o => ghr_cmp_shd.g_old_rec.serviced_org_id
540: ,p_formal_com_filed_o => ghr_cmp_shd.g_old_rec.formal_com_filed

Line 537: ,p_hr_office_org_id_o => ghr_cmp_shd.g_old_rec.hr_office_org_id

533: ,p_notice_rtf_recvd_o => ghr_cmp_shd.g_old_rec.notice_rtf_recvd
534: ,p_precom_closed_o => ghr_cmp_shd.g_old_rec.precom_closed
535: ,p_precom_closure_nature_o => ghr_cmp_shd.g_old_rec.precom_closure_nature
536: ,p_counselor_rpt_sub_o => ghr_cmp_shd.g_old_rec.counselor_rpt_sub
537: ,p_hr_office_org_id_o => ghr_cmp_shd.g_old_rec.hr_office_org_id
538: ,p_eeo_office_org_id_o => ghr_cmp_shd.g_old_rec.eeo_office_org_id
539: ,p_serviced_org_id_o => ghr_cmp_shd.g_old_rec.serviced_org_id
540: ,p_formal_com_filed_o => ghr_cmp_shd.g_old_rec.formal_com_filed
541: ,p_ack_ltr_o => ghr_cmp_shd.g_old_rec.ack_ltr

Line 538: ,p_eeo_office_org_id_o => ghr_cmp_shd.g_old_rec.eeo_office_org_id

534: ,p_precom_closed_o => ghr_cmp_shd.g_old_rec.precom_closed
535: ,p_precom_closure_nature_o => ghr_cmp_shd.g_old_rec.precom_closure_nature
536: ,p_counselor_rpt_sub_o => ghr_cmp_shd.g_old_rec.counselor_rpt_sub
537: ,p_hr_office_org_id_o => ghr_cmp_shd.g_old_rec.hr_office_org_id
538: ,p_eeo_office_org_id_o => ghr_cmp_shd.g_old_rec.eeo_office_org_id
539: ,p_serviced_org_id_o => ghr_cmp_shd.g_old_rec.serviced_org_id
540: ,p_formal_com_filed_o => ghr_cmp_shd.g_old_rec.formal_com_filed
541: ,p_ack_ltr_o => ghr_cmp_shd.g_old_rec.ack_ltr
542: ,p_clarification_ltr_date_o => ghr_cmp_shd.g_old_rec.clarification_ltr_date

Line 539: ,p_serviced_org_id_o => ghr_cmp_shd.g_old_rec.serviced_org_id

535: ,p_precom_closure_nature_o => ghr_cmp_shd.g_old_rec.precom_closure_nature
536: ,p_counselor_rpt_sub_o => ghr_cmp_shd.g_old_rec.counselor_rpt_sub
537: ,p_hr_office_org_id_o => ghr_cmp_shd.g_old_rec.hr_office_org_id
538: ,p_eeo_office_org_id_o => ghr_cmp_shd.g_old_rec.eeo_office_org_id
539: ,p_serviced_org_id_o => ghr_cmp_shd.g_old_rec.serviced_org_id
540: ,p_formal_com_filed_o => ghr_cmp_shd.g_old_rec.formal_com_filed
541: ,p_ack_ltr_o => ghr_cmp_shd.g_old_rec.ack_ltr
542: ,p_clarification_ltr_date_o => ghr_cmp_shd.g_old_rec.clarification_ltr_date
543: ,p_clarification_response_rec_o => ghr_cmp_shd.g_old_rec.clarification_response_recvd

Line 540: ,p_formal_com_filed_o => ghr_cmp_shd.g_old_rec.formal_com_filed

536: ,p_counselor_rpt_sub_o => ghr_cmp_shd.g_old_rec.counselor_rpt_sub
537: ,p_hr_office_org_id_o => ghr_cmp_shd.g_old_rec.hr_office_org_id
538: ,p_eeo_office_org_id_o => ghr_cmp_shd.g_old_rec.eeo_office_org_id
539: ,p_serviced_org_id_o => ghr_cmp_shd.g_old_rec.serviced_org_id
540: ,p_formal_com_filed_o => ghr_cmp_shd.g_old_rec.formal_com_filed
541: ,p_ack_ltr_o => ghr_cmp_shd.g_old_rec.ack_ltr
542: ,p_clarification_ltr_date_o => ghr_cmp_shd.g_old_rec.clarification_ltr_date
543: ,p_clarification_response_rec_o => ghr_cmp_shd.g_old_rec.clarification_response_recvd
544: ,p_forwarded_legal_review_o => ghr_cmp_shd.g_old_rec.forwarded_legal_review

Line 541: ,p_ack_ltr_o => ghr_cmp_shd.g_old_rec.ack_ltr

537: ,p_hr_office_org_id_o => ghr_cmp_shd.g_old_rec.hr_office_org_id
538: ,p_eeo_office_org_id_o => ghr_cmp_shd.g_old_rec.eeo_office_org_id
539: ,p_serviced_org_id_o => ghr_cmp_shd.g_old_rec.serviced_org_id
540: ,p_formal_com_filed_o => ghr_cmp_shd.g_old_rec.formal_com_filed
541: ,p_ack_ltr_o => ghr_cmp_shd.g_old_rec.ack_ltr
542: ,p_clarification_ltr_date_o => ghr_cmp_shd.g_old_rec.clarification_ltr_date
543: ,p_clarification_response_rec_o => ghr_cmp_shd.g_old_rec.clarification_response_recvd
544: ,p_forwarded_legal_review_o => ghr_cmp_shd.g_old_rec.forwarded_legal_review
545: ,p_returned_from_legal_o => ghr_cmp_shd.g_old_rec.returned_from_legal

Line 542: ,p_clarification_ltr_date_o => ghr_cmp_shd.g_old_rec.clarification_ltr_date

538: ,p_eeo_office_org_id_o => ghr_cmp_shd.g_old_rec.eeo_office_org_id
539: ,p_serviced_org_id_o => ghr_cmp_shd.g_old_rec.serviced_org_id
540: ,p_formal_com_filed_o => ghr_cmp_shd.g_old_rec.formal_com_filed
541: ,p_ack_ltr_o => ghr_cmp_shd.g_old_rec.ack_ltr
542: ,p_clarification_ltr_date_o => ghr_cmp_shd.g_old_rec.clarification_ltr_date
543: ,p_clarification_response_rec_o => ghr_cmp_shd.g_old_rec.clarification_response_recvd
544: ,p_forwarded_legal_review_o => ghr_cmp_shd.g_old_rec.forwarded_legal_review
545: ,p_returned_from_legal_o => ghr_cmp_shd.g_old_rec.returned_from_legal
546: ,p_letter_type_o => ghr_cmp_shd.g_old_rec.letter_type

Line 543: ,p_clarification_response_rec_o => ghr_cmp_shd.g_old_rec.clarification_response_recvd

539: ,p_serviced_org_id_o => ghr_cmp_shd.g_old_rec.serviced_org_id
540: ,p_formal_com_filed_o => ghr_cmp_shd.g_old_rec.formal_com_filed
541: ,p_ack_ltr_o => ghr_cmp_shd.g_old_rec.ack_ltr
542: ,p_clarification_ltr_date_o => ghr_cmp_shd.g_old_rec.clarification_ltr_date
543: ,p_clarification_response_rec_o => ghr_cmp_shd.g_old_rec.clarification_response_recvd
544: ,p_forwarded_legal_review_o => ghr_cmp_shd.g_old_rec.forwarded_legal_review
545: ,p_returned_from_legal_o => ghr_cmp_shd.g_old_rec.returned_from_legal
546: ,p_letter_type_o => ghr_cmp_shd.g_old_rec.letter_type
547: ,p_letter_date_o => ghr_cmp_shd.g_old_rec.letter_date

Line 544: ,p_forwarded_legal_review_o => ghr_cmp_shd.g_old_rec.forwarded_legal_review

540: ,p_formal_com_filed_o => ghr_cmp_shd.g_old_rec.formal_com_filed
541: ,p_ack_ltr_o => ghr_cmp_shd.g_old_rec.ack_ltr
542: ,p_clarification_ltr_date_o => ghr_cmp_shd.g_old_rec.clarification_ltr_date
543: ,p_clarification_response_rec_o => ghr_cmp_shd.g_old_rec.clarification_response_recvd
544: ,p_forwarded_legal_review_o => ghr_cmp_shd.g_old_rec.forwarded_legal_review
545: ,p_returned_from_legal_o => ghr_cmp_shd.g_old_rec.returned_from_legal
546: ,p_letter_type_o => ghr_cmp_shd.g_old_rec.letter_type
547: ,p_letter_date_o => ghr_cmp_shd.g_old_rec.letter_date
548: ,p_letter_recvd_o => ghr_cmp_shd.g_old_rec.letter_recvd

Line 545: ,p_returned_from_legal_o => ghr_cmp_shd.g_old_rec.returned_from_legal

541: ,p_ack_ltr_o => ghr_cmp_shd.g_old_rec.ack_ltr
542: ,p_clarification_ltr_date_o => ghr_cmp_shd.g_old_rec.clarification_ltr_date
543: ,p_clarification_response_rec_o => ghr_cmp_shd.g_old_rec.clarification_response_recvd
544: ,p_forwarded_legal_review_o => ghr_cmp_shd.g_old_rec.forwarded_legal_review
545: ,p_returned_from_legal_o => ghr_cmp_shd.g_old_rec.returned_from_legal
546: ,p_letter_type_o => ghr_cmp_shd.g_old_rec.letter_type
547: ,p_letter_date_o => ghr_cmp_shd.g_old_rec.letter_date
548: ,p_letter_recvd_o => ghr_cmp_shd.g_old_rec.letter_recvd
549: ,p_investigation_source_o => ghr_cmp_shd.g_old_rec.investigation_source

Line 546: ,p_letter_type_o => ghr_cmp_shd.g_old_rec.letter_type

542: ,p_clarification_ltr_date_o => ghr_cmp_shd.g_old_rec.clarification_ltr_date
543: ,p_clarification_response_rec_o => ghr_cmp_shd.g_old_rec.clarification_response_recvd
544: ,p_forwarded_legal_review_o => ghr_cmp_shd.g_old_rec.forwarded_legal_review
545: ,p_returned_from_legal_o => ghr_cmp_shd.g_old_rec.returned_from_legal
546: ,p_letter_type_o => ghr_cmp_shd.g_old_rec.letter_type
547: ,p_letter_date_o => ghr_cmp_shd.g_old_rec.letter_date
548: ,p_letter_recvd_o => ghr_cmp_shd.g_old_rec.letter_recvd
549: ,p_investigation_source_o => ghr_cmp_shd.g_old_rec.investigation_source
550: ,p_investigator_recvd_req_o => ghr_cmp_shd.g_old_rec.investigator_recvd_req

Line 547: ,p_letter_date_o => ghr_cmp_shd.g_old_rec.letter_date

543: ,p_clarification_response_rec_o => ghr_cmp_shd.g_old_rec.clarification_response_recvd
544: ,p_forwarded_legal_review_o => ghr_cmp_shd.g_old_rec.forwarded_legal_review
545: ,p_returned_from_legal_o => ghr_cmp_shd.g_old_rec.returned_from_legal
546: ,p_letter_type_o => ghr_cmp_shd.g_old_rec.letter_type
547: ,p_letter_date_o => ghr_cmp_shd.g_old_rec.letter_date
548: ,p_letter_recvd_o => ghr_cmp_shd.g_old_rec.letter_recvd
549: ,p_investigation_source_o => ghr_cmp_shd.g_old_rec.investigation_source
550: ,p_investigator_recvd_req_o => ghr_cmp_shd.g_old_rec.investigator_recvd_req
551: ,p_agency_investigator_req_o => ghr_cmp_shd.g_old_rec.agency_investigator_req

Line 548: ,p_letter_recvd_o => ghr_cmp_shd.g_old_rec.letter_recvd

544: ,p_forwarded_legal_review_o => ghr_cmp_shd.g_old_rec.forwarded_legal_review
545: ,p_returned_from_legal_o => ghr_cmp_shd.g_old_rec.returned_from_legal
546: ,p_letter_type_o => ghr_cmp_shd.g_old_rec.letter_type
547: ,p_letter_date_o => ghr_cmp_shd.g_old_rec.letter_date
548: ,p_letter_recvd_o => ghr_cmp_shd.g_old_rec.letter_recvd
549: ,p_investigation_source_o => ghr_cmp_shd.g_old_rec.investigation_source
550: ,p_investigator_recvd_req_o => ghr_cmp_shd.g_old_rec.investigator_recvd_req
551: ,p_agency_investigator_req_o => ghr_cmp_shd.g_old_rec.agency_investigator_req
552: ,p_investigator_asg_o => ghr_cmp_shd.g_old_rec.investigator_asg

Line 549: ,p_investigation_source_o => ghr_cmp_shd.g_old_rec.investigation_source

545: ,p_returned_from_legal_o => ghr_cmp_shd.g_old_rec.returned_from_legal
546: ,p_letter_type_o => ghr_cmp_shd.g_old_rec.letter_type
547: ,p_letter_date_o => ghr_cmp_shd.g_old_rec.letter_date
548: ,p_letter_recvd_o => ghr_cmp_shd.g_old_rec.letter_recvd
549: ,p_investigation_source_o => ghr_cmp_shd.g_old_rec.investigation_source
550: ,p_investigator_recvd_req_o => ghr_cmp_shd.g_old_rec.investigator_recvd_req
551: ,p_agency_investigator_req_o => ghr_cmp_shd.g_old_rec.agency_investigator_req
552: ,p_investigator_asg_o => ghr_cmp_shd.g_old_rec.investigator_asg
553: ,p_investigation_start_o => ghr_cmp_shd.g_old_rec.investigation_start

Line 550: ,p_investigator_recvd_req_o => ghr_cmp_shd.g_old_rec.investigator_recvd_req

546: ,p_letter_type_o => ghr_cmp_shd.g_old_rec.letter_type
547: ,p_letter_date_o => ghr_cmp_shd.g_old_rec.letter_date
548: ,p_letter_recvd_o => ghr_cmp_shd.g_old_rec.letter_recvd
549: ,p_investigation_source_o => ghr_cmp_shd.g_old_rec.investigation_source
550: ,p_investigator_recvd_req_o => ghr_cmp_shd.g_old_rec.investigator_recvd_req
551: ,p_agency_investigator_req_o => ghr_cmp_shd.g_old_rec.agency_investigator_req
552: ,p_investigator_asg_o => ghr_cmp_shd.g_old_rec.investigator_asg
553: ,p_investigation_start_o => ghr_cmp_shd.g_old_rec.investigation_start
554: ,p_investigation_end_o => ghr_cmp_shd.g_old_rec.investigation_end

Line 551: ,p_agency_investigator_req_o => ghr_cmp_shd.g_old_rec.agency_investigator_req

547: ,p_letter_date_o => ghr_cmp_shd.g_old_rec.letter_date
548: ,p_letter_recvd_o => ghr_cmp_shd.g_old_rec.letter_recvd
549: ,p_investigation_source_o => ghr_cmp_shd.g_old_rec.investigation_source
550: ,p_investigator_recvd_req_o => ghr_cmp_shd.g_old_rec.investigator_recvd_req
551: ,p_agency_investigator_req_o => ghr_cmp_shd.g_old_rec.agency_investigator_req
552: ,p_investigator_asg_o => ghr_cmp_shd.g_old_rec.investigator_asg
553: ,p_investigation_start_o => ghr_cmp_shd.g_old_rec.investigation_start
554: ,p_investigation_end_o => ghr_cmp_shd.g_old_rec.investigation_end
555: ,p_investigation_extended_o => ghr_cmp_shd.g_old_rec.investigation_extended

Line 552: ,p_investigator_asg_o => ghr_cmp_shd.g_old_rec.investigator_asg

548: ,p_letter_recvd_o => ghr_cmp_shd.g_old_rec.letter_recvd
549: ,p_investigation_source_o => ghr_cmp_shd.g_old_rec.investigation_source
550: ,p_investigator_recvd_req_o => ghr_cmp_shd.g_old_rec.investigator_recvd_req
551: ,p_agency_investigator_req_o => ghr_cmp_shd.g_old_rec.agency_investigator_req
552: ,p_investigator_asg_o => ghr_cmp_shd.g_old_rec.investigator_asg
553: ,p_investigation_start_o => ghr_cmp_shd.g_old_rec.investigation_start
554: ,p_investigation_end_o => ghr_cmp_shd.g_old_rec.investigation_end
555: ,p_investigation_extended_o => ghr_cmp_shd.g_old_rec.investigation_extended
556: ,p_invest_extension_desc_o => ghr_cmp_shd.g_old_rec.invest_extension_desc

Line 553: ,p_investigation_start_o => ghr_cmp_shd.g_old_rec.investigation_start

549: ,p_investigation_source_o => ghr_cmp_shd.g_old_rec.investigation_source
550: ,p_investigator_recvd_req_o => ghr_cmp_shd.g_old_rec.investigator_recvd_req
551: ,p_agency_investigator_req_o => ghr_cmp_shd.g_old_rec.agency_investigator_req
552: ,p_investigator_asg_o => ghr_cmp_shd.g_old_rec.investigator_asg
553: ,p_investigation_start_o => ghr_cmp_shd.g_old_rec.investigation_start
554: ,p_investigation_end_o => ghr_cmp_shd.g_old_rec.investigation_end
555: ,p_investigation_extended_o => ghr_cmp_shd.g_old_rec.investigation_extended
556: ,p_invest_extension_desc_o => ghr_cmp_shd.g_old_rec.invest_extension_desc
557: ,p_agency_recvd_roi_o => ghr_cmp_shd.g_old_rec.agency_recvd_roi

Line 554: ,p_investigation_end_o => ghr_cmp_shd.g_old_rec.investigation_end

550: ,p_investigator_recvd_req_o => ghr_cmp_shd.g_old_rec.investigator_recvd_req
551: ,p_agency_investigator_req_o => ghr_cmp_shd.g_old_rec.agency_investigator_req
552: ,p_investigator_asg_o => ghr_cmp_shd.g_old_rec.investigator_asg
553: ,p_investigation_start_o => ghr_cmp_shd.g_old_rec.investigation_start
554: ,p_investigation_end_o => ghr_cmp_shd.g_old_rec.investigation_end
555: ,p_investigation_extended_o => ghr_cmp_shd.g_old_rec.investigation_extended
556: ,p_invest_extension_desc_o => ghr_cmp_shd.g_old_rec.invest_extension_desc
557: ,p_agency_recvd_roi_o => ghr_cmp_shd.g_old_rec.agency_recvd_roi
558: ,p_comrep_recvd_roi_o => ghr_cmp_shd.g_old_rec.comrep_recvd_roi

Line 555: ,p_investigation_extended_o => ghr_cmp_shd.g_old_rec.investigation_extended

551: ,p_agency_investigator_req_o => ghr_cmp_shd.g_old_rec.agency_investigator_req
552: ,p_investigator_asg_o => ghr_cmp_shd.g_old_rec.investigator_asg
553: ,p_investigation_start_o => ghr_cmp_shd.g_old_rec.investigation_start
554: ,p_investigation_end_o => ghr_cmp_shd.g_old_rec.investigation_end
555: ,p_investigation_extended_o => ghr_cmp_shd.g_old_rec.investigation_extended
556: ,p_invest_extension_desc_o => ghr_cmp_shd.g_old_rec.invest_extension_desc
557: ,p_agency_recvd_roi_o => ghr_cmp_shd.g_old_rec.agency_recvd_roi
558: ,p_comrep_recvd_roi_o => ghr_cmp_shd.g_old_rec.comrep_recvd_roi
559: ,p_options_ltr_date_o => ghr_cmp_shd.g_old_rec.options_ltr_date

Line 556: ,p_invest_extension_desc_o => ghr_cmp_shd.g_old_rec.invest_extension_desc

552: ,p_investigator_asg_o => ghr_cmp_shd.g_old_rec.investigator_asg
553: ,p_investigation_start_o => ghr_cmp_shd.g_old_rec.investigation_start
554: ,p_investigation_end_o => ghr_cmp_shd.g_old_rec.investigation_end
555: ,p_investigation_extended_o => ghr_cmp_shd.g_old_rec.investigation_extended
556: ,p_invest_extension_desc_o => ghr_cmp_shd.g_old_rec.invest_extension_desc
557: ,p_agency_recvd_roi_o => ghr_cmp_shd.g_old_rec.agency_recvd_roi
558: ,p_comrep_recvd_roi_o => ghr_cmp_shd.g_old_rec.comrep_recvd_roi
559: ,p_options_ltr_date_o => ghr_cmp_shd.g_old_rec.options_ltr_date
560: ,p_comrep_recvd_opt_ltr_o => ghr_cmp_shd.g_old_rec.comrep_recvd_opt_ltr

Line 557: ,p_agency_recvd_roi_o => ghr_cmp_shd.g_old_rec.agency_recvd_roi

553: ,p_investigation_start_o => ghr_cmp_shd.g_old_rec.investigation_start
554: ,p_investigation_end_o => ghr_cmp_shd.g_old_rec.investigation_end
555: ,p_investigation_extended_o => ghr_cmp_shd.g_old_rec.investigation_extended
556: ,p_invest_extension_desc_o => ghr_cmp_shd.g_old_rec.invest_extension_desc
557: ,p_agency_recvd_roi_o => ghr_cmp_shd.g_old_rec.agency_recvd_roi
558: ,p_comrep_recvd_roi_o => ghr_cmp_shd.g_old_rec.comrep_recvd_roi
559: ,p_options_ltr_date_o => ghr_cmp_shd.g_old_rec.options_ltr_date
560: ,p_comrep_recvd_opt_ltr_o => ghr_cmp_shd.g_old_rec.comrep_recvd_opt_ltr
561: ,p_comrep_opt_ltr_response_o => ghr_cmp_shd.g_old_rec.comrep_opt_ltr_response

Line 558: ,p_comrep_recvd_roi_o => ghr_cmp_shd.g_old_rec.comrep_recvd_roi

554: ,p_investigation_end_o => ghr_cmp_shd.g_old_rec.investigation_end
555: ,p_investigation_extended_o => ghr_cmp_shd.g_old_rec.investigation_extended
556: ,p_invest_extension_desc_o => ghr_cmp_shd.g_old_rec.invest_extension_desc
557: ,p_agency_recvd_roi_o => ghr_cmp_shd.g_old_rec.agency_recvd_roi
558: ,p_comrep_recvd_roi_o => ghr_cmp_shd.g_old_rec.comrep_recvd_roi
559: ,p_options_ltr_date_o => ghr_cmp_shd.g_old_rec.options_ltr_date
560: ,p_comrep_recvd_opt_ltr_o => ghr_cmp_shd.g_old_rec.comrep_recvd_opt_ltr
561: ,p_comrep_opt_ltr_response_o => ghr_cmp_shd.g_old_rec.comrep_opt_ltr_response
562: ,p_resolution_offer_o => ghr_cmp_shd.g_old_rec.resolution_offer

Line 559: ,p_options_ltr_date_o => ghr_cmp_shd.g_old_rec.options_ltr_date

555: ,p_investigation_extended_o => ghr_cmp_shd.g_old_rec.investigation_extended
556: ,p_invest_extension_desc_o => ghr_cmp_shd.g_old_rec.invest_extension_desc
557: ,p_agency_recvd_roi_o => ghr_cmp_shd.g_old_rec.agency_recvd_roi
558: ,p_comrep_recvd_roi_o => ghr_cmp_shd.g_old_rec.comrep_recvd_roi
559: ,p_options_ltr_date_o => ghr_cmp_shd.g_old_rec.options_ltr_date
560: ,p_comrep_recvd_opt_ltr_o => ghr_cmp_shd.g_old_rec.comrep_recvd_opt_ltr
561: ,p_comrep_opt_ltr_response_o => ghr_cmp_shd.g_old_rec.comrep_opt_ltr_response
562: ,p_resolution_offer_o => ghr_cmp_shd.g_old_rec.resolution_offer
563: ,p_comrep_resol_offer_recvd_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_recvd

Line 560: ,p_comrep_recvd_opt_ltr_o => ghr_cmp_shd.g_old_rec.comrep_recvd_opt_ltr

556: ,p_invest_extension_desc_o => ghr_cmp_shd.g_old_rec.invest_extension_desc
557: ,p_agency_recvd_roi_o => ghr_cmp_shd.g_old_rec.agency_recvd_roi
558: ,p_comrep_recvd_roi_o => ghr_cmp_shd.g_old_rec.comrep_recvd_roi
559: ,p_options_ltr_date_o => ghr_cmp_shd.g_old_rec.options_ltr_date
560: ,p_comrep_recvd_opt_ltr_o => ghr_cmp_shd.g_old_rec.comrep_recvd_opt_ltr
561: ,p_comrep_opt_ltr_response_o => ghr_cmp_shd.g_old_rec.comrep_opt_ltr_response
562: ,p_resolution_offer_o => ghr_cmp_shd.g_old_rec.resolution_offer
563: ,p_comrep_resol_offer_recvd_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_recvd
564: ,p_comrep_resol_offer_respons_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_response

Line 561: ,p_comrep_opt_ltr_response_o => ghr_cmp_shd.g_old_rec.comrep_opt_ltr_response

557: ,p_agency_recvd_roi_o => ghr_cmp_shd.g_old_rec.agency_recvd_roi
558: ,p_comrep_recvd_roi_o => ghr_cmp_shd.g_old_rec.comrep_recvd_roi
559: ,p_options_ltr_date_o => ghr_cmp_shd.g_old_rec.options_ltr_date
560: ,p_comrep_recvd_opt_ltr_o => ghr_cmp_shd.g_old_rec.comrep_recvd_opt_ltr
561: ,p_comrep_opt_ltr_response_o => ghr_cmp_shd.g_old_rec.comrep_opt_ltr_response
562: ,p_resolution_offer_o => ghr_cmp_shd.g_old_rec.resolution_offer
563: ,p_comrep_resol_offer_recvd_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_recvd
564: ,p_comrep_resol_offer_respons_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_response
565: ,p_comrep_resol_offer_desc_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_desc

Line 562: ,p_resolution_offer_o => ghr_cmp_shd.g_old_rec.resolution_offer

558: ,p_comrep_recvd_roi_o => ghr_cmp_shd.g_old_rec.comrep_recvd_roi
559: ,p_options_ltr_date_o => ghr_cmp_shd.g_old_rec.options_ltr_date
560: ,p_comrep_recvd_opt_ltr_o => ghr_cmp_shd.g_old_rec.comrep_recvd_opt_ltr
561: ,p_comrep_opt_ltr_response_o => ghr_cmp_shd.g_old_rec.comrep_opt_ltr_response
562: ,p_resolution_offer_o => ghr_cmp_shd.g_old_rec.resolution_offer
563: ,p_comrep_resol_offer_recvd_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_recvd
564: ,p_comrep_resol_offer_respons_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_response
565: ,p_comrep_resol_offer_desc_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_desc
566: ,p_resol_offer_signed_o => ghr_cmp_shd.g_old_rec.resol_offer_signed

Line 563: ,p_comrep_resol_offer_recvd_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_recvd

559: ,p_options_ltr_date_o => ghr_cmp_shd.g_old_rec.options_ltr_date
560: ,p_comrep_recvd_opt_ltr_o => ghr_cmp_shd.g_old_rec.comrep_recvd_opt_ltr
561: ,p_comrep_opt_ltr_response_o => ghr_cmp_shd.g_old_rec.comrep_opt_ltr_response
562: ,p_resolution_offer_o => ghr_cmp_shd.g_old_rec.resolution_offer
563: ,p_comrep_resol_offer_recvd_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_recvd
564: ,p_comrep_resol_offer_respons_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_response
565: ,p_comrep_resol_offer_desc_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_desc
566: ,p_resol_offer_signed_o => ghr_cmp_shd.g_old_rec.resol_offer_signed
567: ,p_resol_offer_desc_o => ghr_cmp_shd.g_old_rec.resol_offer_desc

Line 564: ,p_comrep_resol_offer_respons_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_response

560: ,p_comrep_recvd_opt_ltr_o => ghr_cmp_shd.g_old_rec.comrep_recvd_opt_ltr
561: ,p_comrep_opt_ltr_response_o => ghr_cmp_shd.g_old_rec.comrep_opt_ltr_response
562: ,p_resolution_offer_o => ghr_cmp_shd.g_old_rec.resolution_offer
563: ,p_comrep_resol_offer_recvd_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_recvd
564: ,p_comrep_resol_offer_respons_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_response
565: ,p_comrep_resol_offer_desc_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_desc
566: ,p_resol_offer_signed_o => ghr_cmp_shd.g_old_rec.resol_offer_signed
567: ,p_resol_offer_desc_o => ghr_cmp_shd.g_old_rec.resol_offer_desc
568: ,p_hearing_source_o => ghr_cmp_shd.g_old_rec.hearing_source

Line 565: ,p_comrep_resol_offer_desc_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_desc

561: ,p_comrep_opt_ltr_response_o => ghr_cmp_shd.g_old_rec.comrep_opt_ltr_response
562: ,p_resolution_offer_o => ghr_cmp_shd.g_old_rec.resolution_offer
563: ,p_comrep_resol_offer_recvd_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_recvd
564: ,p_comrep_resol_offer_respons_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_response
565: ,p_comrep_resol_offer_desc_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_desc
566: ,p_resol_offer_signed_o => ghr_cmp_shd.g_old_rec.resol_offer_signed
567: ,p_resol_offer_desc_o => ghr_cmp_shd.g_old_rec.resol_offer_desc
568: ,p_hearing_source_o => ghr_cmp_shd.g_old_rec.hearing_source
569: ,p_agency_notified_hearing_o => ghr_cmp_shd.g_old_rec.agency_notified_hearing

Line 566: ,p_resol_offer_signed_o => ghr_cmp_shd.g_old_rec.resol_offer_signed

562: ,p_resolution_offer_o => ghr_cmp_shd.g_old_rec.resolution_offer
563: ,p_comrep_resol_offer_recvd_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_recvd
564: ,p_comrep_resol_offer_respons_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_response
565: ,p_comrep_resol_offer_desc_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_desc
566: ,p_resol_offer_signed_o => ghr_cmp_shd.g_old_rec.resol_offer_signed
567: ,p_resol_offer_desc_o => ghr_cmp_shd.g_old_rec.resol_offer_desc
568: ,p_hearing_source_o => ghr_cmp_shd.g_old_rec.hearing_source
569: ,p_agency_notified_hearing_o => ghr_cmp_shd.g_old_rec.agency_notified_hearing
570: ,p_eeoc_hearing_docket_num_o => ghr_cmp_shd.g_old_rec.eeoc_hearing_docket_num

Line 567: ,p_resol_offer_desc_o => ghr_cmp_shd.g_old_rec.resol_offer_desc

563: ,p_comrep_resol_offer_recvd_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_recvd
564: ,p_comrep_resol_offer_respons_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_response
565: ,p_comrep_resol_offer_desc_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_desc
566: ,p_resol_offer_signed_o => ghr_cmp_shd.g_old_rec.resol_offer_signed
567: ,p_resol_offer_desc_o => ghr_cmp_shd.g_old_rec.resol_offer_desc
568: ,p_hearing_source_o => ghr_cmp_shd.g_old_rec.hearing_source
569: ,p_agency_notified_hearing_o => ghr_cmp_shd.g_old_rec.agency_notified_hearing
570: ,p_eeoc_hearing_docket_num_o => ghr_cmp_shd.g_old_rec.eeoc_hearing_docket_num
571: ,p_hearing_complete_o => ghr_cmp_shd.g_old_rec.hearing_complete

Line 568: ,p_hearing_source_o => ghr_cmp_shd.g_old_rec.hearing_source

564: ,p_comrep_resol_offer_respons_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_response
565: ,p_comrep_resol_offer_desc_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_desc
566: ,p_resol_offer_signed_o => ghr_cmp_shd.g_old_rec.resol_offer_signed
567: ,p_resol_offer_desc_o => ghr_cmp_shd.g_old_rec.resol_offer_desc
568: ,p_hearing_source_o => ghr_cmp_shd.g_old_rec.hearing_source
569: ,p_agency_notified_hearing_o => ghr_cmp_shd.g_old_rec.agency_notified_hearing
570: ,p_eeoc_hearing_docket_num_o => ghr_cmp_shd.g_old_rec.eeoc_hearing_docket_num
571: ,p_hearing_complete_o => ghr_cmp_shd.g_old_rec.hearing_complete
572: ,p_aj_merit_decision_date_o => ghr_cmp_shd.g_old_rec.aj_merit_decision_date

Line 569: ,p_agency_notified_hearing_o => ghr_cmp_shd.g_old_rec.agency_notified_hearing

565: ,p_comrep_resol_offer_desc_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_desc
566: ,p_resol_offer_signed_o => ghr_cmp_shd.g_old_rec.resol_offer_signed
567: ,p_resol_offer_desc_o => ghr_cmp_shd.g_old_rec.resol_offer_desc
568: ,p_hearing_source_o => ghr_cmp_shd.g_old_rec.hearing_source
569: ,p_agency_notified_hearing_o => ghr_cmp_shd.g_old_rec.agency_notified_hearing
570: ,p_eeoc_hearing_docket_num_o => ghr_cmp_shd.g_old_rec.eeoc_hearing_docket_num
571: ,p_hearing_complete_o => ghr_cmp_shd.g_old_rec.hearing_complete
572: ,p_aj_merit_decision_date_o => ghr_cmp_shd.g_old_rec.aj_merit_decision_date
573: ,p_agency_recvd_aj_merit_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_merit_dec

Line 570: ,p_eeoc_hearing_docket_num_o => ghr_cmp_shd.g_old_rec.eeoc_hearing_docket_num

566: ,p_resol_offer_signed_o => ghr_cmp_shd.g_old_rec.resol_offer_signed
567: ,p_resol_offer_desc_o => ghr_cmp_shd.g_old_rec.resol_offer_desc
568: ,p_hearing_source_o => ghr_cmp_shd.g_old_rec.hearing_source
569: ,p_agency_notified_hearing_o => ghr_cmp_shd.g_old_rec.agency_notified_hearing
570: ,p_eeoc_hearing_docket_num_o => ghr_cmp_shd.g_old_rec.eeoc_hearing_docket_num
571: ,p_hearing_complete_o => ghr_cmp_shd.g_old_rec.hearing_complete
572: ,p_aj_merit_decision_date_o => ghr_cmp_shd.g_old_rec.aj_merit_decision_date
573: ,p_agency_recvd_aj_merit_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_merit_dec
574: ,p_aj_merit_decision_o => ghr_cmp_shd.g_old_rec.aj_merit_decision

Line 571: ,p_hearing_complete_o => ghr_cmp_shd.g_old_rec.hearing_complete

567: ,p_resol_offer_desc_o => ghr_cmp_shd.g_old_rec.resol_offer_desc
568: ,p_hearing_source_o => ghr_cmp_shd.g_old_rec.hearing_source
569: ,p_agency_notified_hearing_o => ghr_cmp_shd.g_old_rec.agency_notified_hearing
570: ,p_eeoc_hearing_docket_num_o => ghr_cmp_shd.g_old_rec.eeoc_hearing_docket_num
571: ,p_hearing_complete_o => ghr_cmp_shd.g_old_rec.hearing_complete
572: ,p_aj_merit_decision_date_o => ghr_cmp_shd.g_old_rec.aj_merit_decision_date
573: ,p_agency_recvd_aj_merit_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_merit_dec
574: ,p_aj_merit_decision_o => ghr_cmp_shd.g_old_rec.aj_merit_decision
575: ,p_aj_ca_decision_date_o => ghr_cmp_shd.g_old_rec.aj_ca_decision_date

Line 572: ,p_aj_merit_decision_date_o => ghr_cmp_shd.g_old_rec.aj_merit_decision_date

568: ,p_hearing_source_o => ghr_cmp_shd.g_old_rec.hearing_source
569: ,p_agency_notified_hearing_o => ghr_cmp_shd.g_old_rec.agency_notified_hearing
570: ,p_eeoc_hearing_docket_num_o => ghr_cmp_shd.g_old_rec.eeoc_hearing_docket_num
571: ,p_hearing_complete_o => ghr_cmp_shd.g_old_rec.hearing_complete
572: ,p_aj_merit_decision_date_o => ghr_cmp_shd.g_old_rec.aj_merit_decision_date
573: ,p_agency_recvd_aj_merit_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_merit_dec
574: ,p_aj_merit_decision_o => ghr_cmp_shd.g_old_rec.aj_merit_decision
575: ,p_aj_ca_decision_date_o => ghr_cmp_shd.g_old_rec.aj_ca_decision_date
576: ,p_agency_recvd_aj_ca_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_ca_dec

Line 573: ,p_agency_recvd_aj_merit_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_merit_dec

569: ,p_agency_notified_hearing_o => ghr_cmp_shd.g_old_rec.agency_notified_hearing
570: ,p_eeoc_hearing_docket_num_o => ghr_cmp_shd.g_old_rec.eeoc_hearing_docket_num
571: ,p_hearing_complete_o => ghr_cmp_shd.g_old_rec.hearing_complete
572: ,p_aj_merit_decision_date_o => ghr_cmp_shd.g_old_rec.aj_merit_decision_date
573: ,p_agency_recvd_aj_merit_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_merit_dec
574: ,p_aj_merit_decision_o => ghr_cmp_shd.g_old_rec.aj_merit_decision
575: ,p_aj_ca_decision_date_o => ghr_cmp_shd.g_old_rec.aj_ca_decision_date
576: ,p_agency_recvd_aj_ca_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_ca_dec
577: ,p_aj_ca_decision_o => ghr_cmp_shd.g_old_rec.aj_ca_decision

Line 574: ,p_aj_merit_decision_o => ghr_cmp_shd.g_old_rec.aj_merit_decision

570: ,p_eeoc_hearing_docket_num_o => ghr_cmp_shd.g_old_rec.eeoc_hearing_docket_num
571: ,p_hearing_complete_o => ghr_cmp_shd.g_old_rec.hearing_complete
572: ,p_aj_merit_decision_date_o => ghr_cmp_shd.g_old_rec.aj_merit_decision_date
573: ,p_agency_recvd_aj_merit_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_merit_dec
574: ,p_aj_merit_decision_o => ghr_cmp_shd.g_old_rec.aj_merit_decision
575: ,p_aj_ca_decision_date_o => ghr_cmp_shd.g_old_rec.aj_ca_decision_date
576: ,p_agency_recvd_aj_ca_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_ca_dec
577: ,p_aj_ca_decision_o => ghr_cmp_shd.g_old_rec.aj_ca_decision
578: ,p_fad_requested_o => ghr_cmp_shd.g_old_rec.fad_requested

Line 575: ,p_aj_ca_decision_date_o => ghr_cmp_shd.g_old_rec.aj_ca_decision_date

571: ,p_hearing_complete_o => ghr_cmp_shd.g_old_rec.hearing_complete
572: ,p_aj_merit_decision_date_o => ghr_cmp_shd.g_old_rec.aj_merit_decision_date
573: ,p_agency_recvd_aj_merit_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_merit_dec
574: ,p_aj_merit_decision_o => ghr_cmp_shd.g_old_rec.aj_merit_decision
575: ,p_aj_ca_decision_date_o => ghr_cmp_shd.g_old_rec.aj_ca_decision_date
576: ,p_agency_recvd_aj_ca_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_ca_dec
577: ,p_aj_ca_decision_o => ghr_cmp_shd.g_old_rec.aj_ca_decision
578: ,p_fad_requested_o => ghr_cmp_shd.g_old_rec.fad_requested
579: ,p_merit_fad_o => ghr_cmp_shd.g_old_rec.merit_fad

Line 576: ,p_agency_recvd_aj_ca_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_ca_dec

572: ,p_aj_merit_decision_date_o => ghr_cmp_shd.g_old_rec.aj_merit_decision_date
573: ,p_agency_recvd_aj_merit_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_merit_dec
574: ,p_aj_merit_decision_o => ghr_cmp_shd.g_old_rec.aj_merit_decision
575: ,p_aj_ca_decision_date_o => ghr_cmp_shd.g_old_rec.aj_ca_decision_date
576: ,p_agency_recvd_aj_ca_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_ca_dec
577: ,p_aj_ca_decision_o => ghr_cmp_shd.g_old_rec.aj_ca_decision
578: ,p_fad_requested_o => ghr_cmp_shd.g_old_rec.fad_requested
579: ,p_merit_fad_o => ghr_cmp_shd.g_old_rec.merit_fad
580: ,p_attorney_fees_fad_o => ghr_cmp_shd.g_old_rec.attorney_fees_fad

Line 577: ,p_aj_ca_decision_o => ghr_cmp_shd.g_old_rec.aj_ca_decision

573: ,p_agency_recvd_aj_merit_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_merit_dec
574: ,p_aj_merit_decision_o => ghr_cmp_shd.g_old_rec.aj_merit_decision
575: ,p_aj_ca_decision_date_o => ghr_cmp_shd.g_old_rec.aj_ca_decision_date
576: ,p_agency_recvd_aj_ca_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_ca_dec
577: ,p_aj_ca_decision_o => ghr_cmp_shd.g_old_rec.aj_ca_decision
578: ,p_fad_requested_o => ghr_cmp_shd.g_old_rec.fad_requested
579: ,p_merit_fad_o => ghr_cmp_shd.g_old_rec.merit_fad
580: ,p_attorney_fees_fad_o => ghr_cmp_shd.g_old_rec.attorney_fees_fad
581: ,p_comp_damages_fad_o => ghr_cmp_shd.g_old_rec.comp_damages_fad

Line 578: ,p_fad_requested_o => ghr_cmp_shd.g_old_rec.fad_requested

574: ,p_aj_merit_decision_o => ghr_cmp_shd.g_old_rec.aj_merit_decision
575: ,p_aj_ca_decision_date_o => ghr_cmp_shd.g_old_rec.aj_ca_decision_date
576: ,p_agency_recvd_aj_ca_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_ca_dec
577: ,p_aj_ca_decision_o => ghr_cmp_shd.g_old_rec.aj_ca_decision
578: ,p_fad_requested_o => ghr_cmp_shd.g_old_rec.fad_requested
579: ,p_merit_fad_o => ghr_cmp_shd.g_old_rec.merit_fad
580: ,p_attorney_fees_fad_o => ghr_cmp_shd.g_old_rec.attorney_fees_fad
581: ,p_comp_damages_fad_o => ghr_cmp_shd.g_old_rec.comp_damages_fad
582: ,p_non_compliance_fad_o => ghr_cmp_shd.g_old_rec.non_compliance_fad

Line 579: ,p_merit_fad_o => ghr_cmp_shd.g_old_rec.merit_fad

575: ,p_aj_ca_decision_date_o => ghr_cmp_shd.g_old_rec.aj_ca_decision_date
576: ,p_agency_recvd_aj_ca_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_ca_dec
577: ,p_aj_ca_decision_o => ghr_cmp_shd.g_old_rec.aj_ca_decision
578: ,p_fad_requested_o => ghr_cmp_shd.g_old_rec.fad_requested
579: ,p_merit_fad_o => ghr_cmp_shd.g_old_rec.merit_fad
580: ,p_attorney_fees_fad_o => ghr_cmp_shd.g_old_rec.attorney_fees_fad
581: ,p_comp_damages_fad_o => ghr_cmp_shd.g_old_rec.comp_damages_fad
582: ,p_non_compliance_fad_o => ghr_cmp_shd.g_old_rec.non_compliance_fad
583: ,p_fad_req_recvd_eeo_office_o => ghr_cmp_shd.g_old_rec.fad_req_recvd_eeo_office

Line 580: ,p_attorney_fees_fad_o => ghr_cmp_shd.g_old_rec.attorney_fees_fad

576: ,p_agency_recvd_aj_ca_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_ca_dec
577: ,p_aj_ca_decision_o => ghr_cmp_shd.g_old_rec.aj_ca_decision
578: ,p_fad_requested_o => ghr_cmp_shd.g_old_rec.fad_requested
579: ,p_merit_fad_o => ghr_cmp_shd.g_old_rec.merit_fad
580: ,p_attorney_fees_fad_o => ghr_cmp_shd.g_old_rec.attorney_fees_fad
581: ,p_comp_damages_fad_o => ghr_cmp_shd.g_old_rec.comp_damages_fad
582: ,p_non_compliance_fad_o => ghr_cmp_shd.g_old_rec.non_compliance_fad
583: ,p_fad_req_recvd_eeo_office_o => ghr_cmp_shd.g_old_rec.fad_req_recvd_eeo_office
584: ,p_fad_req_forwd_to_agency_o => ghr_cmp_shd.g_old_rec.fad_req_forwd_to_agency

Line 581: ,p_comp_damages_fad_o => ghr_cmp_shd.g_old_rec.comp_damages_fad

577: ,p_aj_ca_decision_o => ghr_cmp_shd.g_old_rec.aj_ca_decision
578: ,p_fad_requested_o => ghr_cmp_shd.g_old_rec.fad_requested
579: ,p_merit_fad_o => ghr_cmp_shd.g_old_rec.merit_fad
580: ,p_attorney_fees_fad_o => ghr_cmp_shd.g_old_rec.attorney_fees_fad
581: ,p_comp_damages_fad_o => ghr_cmp_shd.g_old_rec.comp_damages_fad
582: ,p_non_compliance_fad_o => ghr_cmp_shd.g_old_rec.non_compliance_fad
583: ,p_fad_req_recvd_eeo_office_o => ghr_cmp_shd.g_old_rec.fad_req_recvd_eeo_office
584: ,p_fad_req_forwd_to_agency_o => ghr_cmp_shd.g_old_rec.fad_req_forwd_to_agency
585: ,p_agency_recvd_request_o => ghr_cmp_shd.g_old_rec.agency_recvd_request

Line 582: ,p_non_compliance_fad_o => ghr_cmp_shd.g_old_rec.non_compliance_fad

578: ,p_fad_requested_o => ghr_cmp_shd.g_old_rec.fad_requested
579: ,p_merit_fad_o => ghr_cmp_shd.g_old_rec.merit_fad
580: ,p_attorney_fees_fad_o => ghr_cmp_shd.g_old_rec.attorney_fees_fad
581: ,p_comp_damages_fad_o => ghr_cmp_shd.g_old_rec.comp_damages_fad
582: ,p_non_compliance_fad_o => ghr_cmp_shd.g_old_rec.non_compliance_fad
583: ,p_fad_req_recvd_eeo_office_o => ghr_cmp_shd.g_old_rec.fad_req_recvd_eeo_office
584: ,p_fad_req_forwd_to_agency_o => ghr_cmp_shd.g_old_rec.fad_req_forwd_to_agency
585: ,p_agency_recvd_request_o => ghr_cmp_shd.g_old_rec.agency_recvd_request
586: ,p_fad_due_o => ghr_cmp_shd.g_old_rec.fad_due

Line 583: ,p_fad_req_recvd_eeo_office_o => ghr_cmp_shd.g_old_rec.fad_req_recvd_eeo_office

579: ,p_merit_fad_o => ghr_cmp_shd.g_old_rec.merit_fad
580: ,p_attorney_fees_fad_o => ghr_cmp_shd.g_old_rec.attorney_fees_fad
581: ,p_comp_damages_fad_o => ghr_cmp_shd.g_old_rec.comp_damages_fad
582: ,p_non_compliance_fad_o => ghr_cmp_shd.g_old_rec.non_compliance_fad
583: ,p_fad_req_recvd_eeo_office_o => ghr_cmp_shd.g_old_rec.fad_req_recvd_eeo_office
584: ,p_fad_req_forwd_to_agency_o => ghr_cmp_shd.g_old_rec.fad_req_forwd_to_agency
585: ,p_agency_recvd_request_o => ghr_cmp_shd.g_old_rec.agency_recvd_request
586: ,p_fad_due_o => ghr_cmp_shd.g_old_rec.fad_due
587: ,p_fad_date_o => ghr_cmp_shd.g_old_rec.fad_date

Line 584: ,p_fad_req_forwd_to_agency_o => ghr_cmp_shd.g_old_rec.fad_req_forwd_to_agency

580: ,p_attorney_fees_fad_o => ghr_cmp_shd.g_old_rec.attorney_fees_fad
581: ,p_comp_damages_fad_o => ghr_cmp_shd.g_old_rec.comp_damages_fad
582: ,p_non_compliance_fad_o => ghr_cmp_shd.g_old_rec.non_compliance_fad
583: ,p_fad_req_recvd_eeo_office_o => ghr_cmp_shd.g_old_rec.fad_req_recvd_eeo_office
584: ,p_fad_req_forwd_to_agency_o => ghr_cmp_shd.g_old_rec.fad_req_forwd_to_agency
585: ,p_agency_recvd_request_o => ghr_cmp_shd.g_old_rec.agency_recvd_request
586: ,p_fad_due_o => ghr_cmp_shd.g_old_rec.fad_due
587: ,p_fad_date_o => ghr_cmp_shd.g_old_rec.fad_date
588: ,p_fad_decision_o => ghr_cmp_shd.g_old_rec.fad_decision

Line 585: ,p_agency_recvd_request_o => ghr_cmp_shd.g_old_rec.agency_recvd_request

581: ,p_comp_damages_fad_o => ghr_cmp_shd.g_old_rec.comp_damages_fad
582: ,p_non_compliance_fad_o => ghr_cmp_shd.g_old_rec.non_compliance_fad
583: ,p_fad_req_recvd_eeo_office_o => ghr_cmp_shd.g_old_rec.fad_req_recvd_eeo_office
584: ,p_fad_req_forwd_to_agency_o => ghr_cmp_shd.g_old_rec.fad_req_forwd_to_agency
585: ,p_agency_recvd_request_o => ghr_cmp_shd.g_old_rec.agency_recvd_request
586: ,p_fad_due_o => ghr_cmp_shd.g_old_rec.fad_due
587: ,p_fad_date_o => ghr_cmp_shd.g_old_rec.fad_date
588: ,p_fad_decision_o => ghr_cmp_shd.g_old_rec.fad_decision
589: -- ,p_fad_final_action_closure_o => ghr_cmp_shd.g_old_rec.fad_final_action_closure

Line 586: ,p_fad_due_o => ghr_cmp_shd.g_old_rec.fad_due

582: ,p_non_compliance_fad_o => ghr_cmp_shd.g_old_rec.non_compliance_fad
583: ,p_fad_req_recvd_eeo_office_o => ghr_cmp_shd.g_old_rec.fad_req_recvd_eeo_office
584: ,p_fad_req_forwd_to_agency_o => ghr_cmp_shd.g_old_rec.fad_req_forwd_to_agency
585: ,p_agency_recvd_request_o => ghr_cmp_shd.g_old_rec.agency_recvd_request
586: ,p_fad_due_o => ghr_cmp_shd.g_old_rec.fad_due
587: ,p_fad_date_o => ghr_cmp_shd.g_old_rec.fad_date
588: ,p_fad_decision_o => ghr_cmp_shd.g_old_rec.fad_decision
589: -- ,p_fad_final_action_closure_o => ghr_cmp_shd.g_old_rec.fad_final_action_closure
590: ,p_fad_forwd_to_comrep_o => ghr_cmp_shd.g_old_rec.fad_forwd_to_comrep

Line 587: ,p_fad_date_o => ghr_cmp_shd.g_old_rec.fad_date

583: ,p_fad_req_recvd_eeo_office_o => ghr_cmp_shd.g_old_rec.fad_req_recvd_eeo_office
584: ,p_fad_req_forwd_to_agency_o => ghr_cmp_shd.g_old_rec.fad_req_forwd_to_agency
585: ,p_agency_recvd_request_o => ghr_cmp_shd.g_old_rec.agency_recvd_request
586: ,p_fad_due_o => ghr_cmp_shd.g_old_rec.fad_due
587: ,p_fad_date_o => ghr_cmp_shd.g_old_rec.fad_date
588: ,p_fad_decision_o => ghr_cmp_shd.g_old_rec.fad_decision
589: -- ,p_fad_final_action_closure_o => ghr_cmp_shd.g_old_rec.fad_final_action_closure
590: ,p_fad_forwd_to_comrep_o => ghr_cmp_shd.g_old_rec.fad_forwd_to_comrep
591: ,p_fad_recvd_by_comrep_o => ghr_cmp_shd.g_old_rec.fad_recvd_by_comrep

Line 588: ,p_fad_decision_o => ghr_cmp_shd.g_old_rec.fad_decision

584: ,p_fad_req_forwd_to_agency_o => ghr_cmp_shd.g_old_rec.fad_req_forwd_to_agency
585: ,p_agency_recvd_request_o => ghr_cmp_shd.g_old_rec.agency_recvd_request
586: ,p_fad_due_o => ghr_cmp_shd.g_old_rec.fad_due
587: ,p_fad_date_o => ghr_cmp_shd.g_old_rec.fad_date
588: ,p_fad_decision_o => ghr_cmp_shd.g_old_rec.fad_decision
589: -- ,p_fad_final_action_closure_o => ghr_cmp_shd.g_old_rec.fad_final_action_closure
590: ,p_fad_forwd_to_comrep_o => ghr_cmp_shd.g_old_rec.fad_forwd_to_comrep
591: ,p_fad_recvd_by_comrep_o => ghr_cmp_shd.g_old_rec.fad_recvd_by_comrep
592: ,p_fad_imp_ltr_forwd_to_org_o => ghr_cmp_shd.g_old_rec.fad_imp_ltr_forwd_to_org

Line 589: -- ,p_fad_final_action_closure_o => ghr_cmp_shd.g_old_rec.fad_final_action_closure

585: ,p_agency_recvd_request_o => ghr_cmp_shd.g_old_rec.agency_recvd_request
586: ,p_fad_due_o => ghr_cmp_shd.g_old_rec.fad_due
587: ,p_fad_date_o => ghr_cmp_shd.g_old_rec.fad_date
588: ,p_fad_decision_o => ghr_cmp_shd.g_old_rec.fad_decision
589: -- ,p_fad_final_action_closure_o => ghr_cmp_shd.g_old_rec.fad_final_action_closure
590: ,p_fad_forwd_to_comrep_o => ghr_cmp_shd.g_old_rec.fad_forwd_to_comrep
591: ,p_fad_recvd_by_comrep_o => ghr_cmp_shd.g_old_rec.fad_recvd_by_comrep
592: ,p_fad_imp_ltr_forwd_to_org_o => ghr_cmp_shd.g_old_rec.fad_imp_ltr_forwd_to_org
593: ,p_fad_decision_forwd_legal_o => ghr_cmp_shd.g_old_rec.fad_decision_forwd_legal

Line 590: ,p_fad_forwd_to_comrep_o => ghr_cmp_shd.g_old_rec.fad_forwd_to_comrep

586: ,p_fad_due_o => ghr_cmp_shd.g_old_rec.fad_due
587: ,p_fad_date_o => ghr_cmp_shd.g_old_rec.fad_date
588: ,p_fad_decision_o => ghr_cmp_shd.g_old_rec.fad_decision
589: -- ,p_fad_final_action_closure_o => ghr_cmp_shd.g_old_rec.fad_final_action_closure
590: ,p_fad_forwd_to_comrep_o => ghr_cmp_shd.g_old_rec.fad_forwd_to_comrep
591: ,p_fad_recvd_by_comrep_o => ghr_cmp_shd.g_old_rec.fad_recvd_by_comrep
592: ,p_fad_imp_ltr_forwd_to_org_o => ghr_cmp_shd.g_old_rec.fad_imp_ltr_forwd_to_org
593: ,p_fad_decision_forwd_legal_o => ghr_cmp_shd.g_old_rec.fad_decision_forwd_legal
594: ,p_fad_decision_recvd_legal_o => ghr_cmp_shd.g_old_rec.fad_decision_recvd_legal

Line 591: ,p_fad_recvd_by_comrep_o => ghr_cmp_shd.g_old_rec.fad_recvd_by_comrep

587: ,p_fad_date_o => ghr_cmp_shd.g_old_rec.fad_date
588: ,p_fad_decision_o => ghr_cmp_shd.g_old_rec.fad_decision
589: -- ,p_fad_final_action_closure_o => ghr_cmp_shd.g_old_rec.fad_final_action_closure
590: ,p_fad_forwd_to_comrep_o => ghr_cmp_shd.g_old_rec.fad_forwd_to_comrep
591: ,p_fad_recvd_by_comrep_o => ghr_cmp_shd.g_old_rec.fad_recvd_by_comrep
592: ,p_fad_imp_ltr_forwd_to_org_o => ghr_cmp_shd.g_old_rec.fad_imp_ltr_forwd_to_org
593: ,p_fad_decision_forwd_legal_o => ghr_cmp_shd.g_old_rec.fad_decision_forwd_legal
594: ,p_fad_decision_recvd_legal_o => ghr_cmp_shd.g_old_rec.fad_decision_recvd_legal
595: ,p_fa_source_o => ghr_cmp_shd.g_old_rec.fa_source

Line 592: ,p_fad_imp_ltr_forwd_to_org_o => ghr_cmp_shd.g_old_rec.fad_imp_ltr_forwd_to_org

588: ,p_fad_decision_o => ghr_cmp_shd.g_old_rec.fad_decision
589: -- ,p_fad_final_action_closure_o => ghr_cmp_shd.g_old_rec.fad_final_action_closure
590: ,p_fad_forwd_to_comrep_o => ghr_cmp_shd.g_old_rec.fad_forwd_to_comrep
591: ,p_fad_recvd_by_comrep_o => ghr_cmp_shd.g_old_rec.fad_recvd_by_comrep
592: ,p_fad_imp_ltr_forwd_to_org_o => ghr_cmp_shd.g_old_rec.fad_imp_ltr_forwd_to_org
593: ,p_fad_decision_forwd_legal_o => ghr_cmp_shd.g_old_rec.fad_decision_forwd_legal
594: ,p_fad_decision_recvd_legal_o => ghr_cmp_shd.g_old_rec.fad_decision_recvd_legal
595: ,p_fa_source_o => ghr_cmp_shd.g_old_rec.fa_source
596: ,p_final_action_due_o => ghr_cmp_shd.g_old_rec.final_action_due

Line 593: ,p_fad_decision_forwd_legal_o => ghr_cmp_shd.g_old_rec.fad_decision_forwd_legal

589: -- ,p_fad_final_action_closure_o => ghr_cmp_shd.g_old_rec.fad_final_action_closure
590: ,p_fad_forwd_to_comrep_o => ghr_cmp_shd.g_old_rec.fad_forwd_to_comrep
591: ,p_fad_recvd_by_comrep_o => ghr_cmp_shd.g_old_rec.fad_recvd_by_comrep
592: ,p_fad_imp_ltr_forwd_to_org_o => ghr_cmp_shd.g_old_rec.fad_imp_ltr_forwd_to_org
593: ,p_fad_decision_forwd_legal_o => ghr_cmp_shd.g_old_rec.fad_decision_forwd_legal
594: ,p_fad_decision_recvd_legal_o => ghr_cmp_shd.g_old_rec.fad_decision_recvd_legal
595: ,p_fa_source_o => ghr_cmp_shd.g_old_rec.fa_source
596: ,p_final_action_due_o => ghr_cmp_shd.g_old_rec.final_action_due
597: --,p_final_action_nature_of_clo_o => ghr_cmp_shd.g_old_rec.final_action_nature_of_closure

Line 594: ,p_fad_decision_recvd_legal_o => ghr_cmp_shd.g_old_rec.fad_decision_recvd_legal

590: ,p_fad_forwd_to_comrep_o => ghr_cmp_shd.g_old_rec.fad_forwd_to_comrep
591: ,p_fad_recvd_by_comrep_o => ghr_cmp_shd.g_old_rec.fad_recvd_by_comrep
592: ,p_fad_imp_ltr_forwd_to_org_o => ghr_cmp_shd.g_old_rec.fad_imp_ltr_forwd_to_org
593: ,p_fad_decision_forwd_legal_o => ghr_cmp_shd.g_old_rec.fad_decision_forwd_legal
594: ,p_fad_decision_recvd_legal_o => ghr_cmp_shd.g_old_rec.fad_decision_recvd_legal
595: ,p_fa_source_o => ghr_cmp_shd.g_old_rec.fa_source
596: ,p_final_action_due_o => ghr_cmp_shd.g_old_rec.final_action_due
597: --,p_final_action_nature_of_clo_o => ghr_cmp_shd.g_old_rec.final_action_nature_of_closure
598: ,p_final_act_forwd_comrep_o => ghr_cmp_shd.g_old_rec.final_act_forwd_comrep

Line 595: ,p_fa_source_o => ghr_cmp_shd.g_old_rec.fa_source

591: ,p_fad_recvd_by_comrep_o => ghr_cmp_shd.g_old_rec.fad_recvd_by_comrep
592: ,p_fad_imp_ltr_forwd_to_org_o => ghr_cmp_shd.g_old_rec.fad_imp_ltr_forwd_to_org
593: ,p_fad_decision_forwd_legal_o => ghr_cmp_shd.g_old_rec.fad_decision_forwd_legal
594: ,p_fad_decision_recvd_legal_o => ghr_cmp_shd.g_old_rec.fad_decision_recvd_legal
595: ,p_fa_source_o => ghr_cmp_shd.g_old_rec.fa_source
596: ,p_final_action_due_o => ghr_cmp_shd.g_old_rec.final_action_due
597: --,p_final_action_nature_of_clo_o => ghr_cmp_shd.g_old_rec.final_action_nature_of_closure
598: ,p_final_act_forwd_comrep_o => ghr_cmp_shd.g_old_rec.final_act_forwd_comrep
599: ,p_final_act_recvd_comrep_o => ghr_cmp_shd.g_old_rec.final_act_recvd_comrep

Line 596: ,p_final_action_due_o => ghr_cmp_shd.g_old_rec.final_action_due

592: ,p_fad_imp_ltr_forwd_to_org_o => ghr_cmp_shd.g_old_rec.fad_imp_ltr_forwd_to_org
593: ,p_fad_decision_forwd_legal_o => ghr_cmp_shd.g_old_rec.fad_decision_forwd_legal
594: ,p_fad_decision_recvd_legal_o => ghr_cmp_shd.g_old_rec.fad_decision_recvd_legal
595: ,p_fa_source_o => ghr_cmp_shd.g_old_rec.fa_source
596: ,p_final_action_due_o => ghr_cmp_shd.g_old_rec.final_action_due
597: --,p_final_action_nature_of_clo_o => ghr_cmp_shd.g_old_rec.final_action_nature_of_closure
598: ,p_final_act_forwd_comrep_o => ghr_cmp_shd.g_old_rec.final_act_forwd_comrep
599: ,p_final_act_recvd_comrep_o => ghr_cmp_shd.g_old_rec.final_act_recvd_comrep
600: ,p_final_action_decision_date_o => ghr_cmp_shd.g_old_rec.final_action_decision_date

Line 597: --,p_final_action_nature_of_clo_o => ghr_cmp_shd.g_old_rec.final_action_nature_of_closure

593: ,p_fad_decision_forwd_legal_o => ghr_cmp_shd.g_old_rec.fad_decision_forwd_legal
594: ,p_fad_decision_recvd_legal_o => ghr_cmp_shd.g_old_rec.fad_decision_recvd_legal
595: ,p_fa_source_o => ghr_cmp_shd.g_old_rec.fa_source
596: ,p_final_action_due_o => ghr_cmp_shd.g_old_rec.final_action_due
597: --,p_final_action_nature_of_clo_o => ghr_cmp_shd.g_old_rec.final_action_nature_of_closure
598: ,p_final_act_forwd_comrep_o => ghr_cmp_shd.g_old_rec.final_act_forwd_comrep
599: ,p_final_act_recvd_comrep_o => ghr_cmp_shd.g_old_rec.final_act_recvd_comrep
600: ,p_final_action_decision_date_o => ghr_cmp_shd.g_old_rec.final_action_decision_date
601: ,p_final_action_decision_o => ghr_cmp_shd.g_old_rec.final_action_decision

Line 598: ,p_final_act_forwd_comrep_o => ghr_cmp_shd.g_old_rec.final_act_forwd_comrep

594: ,p_fad_decision_recvd_legal_o => ghr_cmp_shd.g_old_rec.fad_decision_recvd_legal
595: ,p_fa_source_o => ghr_cmp_shd.g_old_rec.fa_source
596: ,p_final_action_due_o => ghr_cmp_shd.g_old_rec.final_action_due
597: --,p_final_action_nature_of_clo_o => ghr_cmp_shd.g_old_rec.final_action_nature_of_closure
598: ,p_final_act_forwd_comrep_o => ghr_cmp_shd.g_old_rec.final_act_forwd_comrep
599: ,p_final_act_recvd_comrep_o => ghr_cmp_shd.g_old_rec.final_act_recvd_comrep
600: ,p_final_action_decision_date_o => ghr_cmp_shd.g_old_rec.final_action_decision_date
601: ,p_final_action_decision_o => ghr_cmp_shd.g_old_rec.final_action_decision
602: ,p_fa_imp_ltr_forwd_to_org_o => ghr_cmp_shd.g_old_rec.fa_imp_ltr_forwd_to_org

Line 599: ,p_final_act_recvd_comrep_o => ghr_cmp_shd.g_old_rec.final_act_recvd_comrep

595: ,p_fa_source_o => ghr_cmp_shd.g_old_rec.fa_source
596: ,p_final_action_due_o => ghr_cmp_shd.g_old_rec.final_action_due
597: --,p_final_action_nature_of_clo_o => ghr_cmp_shd.g_old_rec.final_action_nature_of_closure
598: ,p_final_act_forwd_comrep_o => ghr_cmp_shd.g_old_rec.final_act_forwd_comrep
599: ,p_final_act_recvd_comrep_o => ghr_cmp_shd.g_old_rec.final_act_recvd_comrep
600: ,p_final_action_decision_date_o => ghr_cmp_shd.g_old_rec.final_action_decision_date
601: ,p_final_action_decision_o => ghr_cmp_shd.g_old_rec.final_action_decision
602: ,p_fa_imp_ltr_forwd_to_org_o => ghr_cmp_shd.g_old_rec.fa_imp_ltr_forwd_to_org
603: ,p_fa_decision_forwd_legal_o => ghr_cmp_shd.g_old_rec.fa_decision_forwd_legal

Line 600: ,p_final_action_decision_date_o => ghr_cmp_shd.g_old_rec.final_action_decision_date

596: ,p_final_action_due_o => ghr_cmp_shd.g_old_rec.final_action_due
597: --,p_final_action_nature_of_clo_o => ghr_cmp_shd.g_old_rec.final_action_nature_of_closure
598: ,p_final_act_forwd_comrep_o => ghr_cmp_shd.g_old_rec.final_act_forwd_comrep
599: ,p_final_act_recvd_comrep_o => ghr_cmp_shd.g_old_rec.final_act_recvd_comrep
600: ,p_final_action_decision_date_o => ghr_cmp_shd.g_old_rec.final_action_decision_date
601: ,p_final_action_decision_o => ghr_cmp_shd.g_old_rec.final_action_decision
602: ,p_fa_imp_ltr_forwd_to_org_o => ghr_cmp_shd.g_old_rec.fa_imp_ltr_forwd_to_org
603: ,p_fa_decision_forwd_legal_o => ghr_cmp_shd.g_old_rec.fa_decision_forwd_legal
604: ,p_fa_decision_recvd_legal_o => ghr_cmp_shd.g_old_rec.fa_decision_recvd_legal

Line 601: ,p_final_action_decision_o => ghr_cmp_shd.g_old_rec.final_action_decision

597: --,p_final_action_nature_of_clo_o => ghr_cmp_shd.g_old_rec.final_action_nature_of_closure
598: ,p_final_act_forwd_comrep_o => ghr_cmp_shd.g_old_rec.final_act_forwd_comrep
599: ,p_final_act_recvd_comrep_o => ghr_cmp_shd.g_old_rec.final_act_recvd_comrep
600: ,p_final_action_decision_date_o => ghr_cmp_shd.g_old_rec.final_action_decision_date
601: ,p_final_action_decision_o => ghr_cmp_shd.g_old_rec.final_action_decision
602: ,p_fa_imp_ltr_forwd_to_org_o => ghr_cmp_shd.g_old_rec.fa_imp_ltr_forwd_to_org
603: ,p_fa_decision_forwd_legal_o => ghr_cmp_shd.g_old_rec.fa_decision_forwd_legal
604: ,p_fa_decision_recvd_legal_o => ghr_cmp_shd.g_old_rec.fa_decision_recvd_legal
605: ,p_civil_action_filed_o => ghr_cmp_shd.g_old_rec.civil_action_filed

Line 602: ,p_fa_imp_ltr_forwd_to_org_o => ghr_cmp_shd.g_old_rec.fa_imp_ltr_forwd_to_org

598: ,p_final_act_forwd_comrep_o => ghr_cmp_shd.g_old_rec.final_act_forwd_comrep
599: ,p_final_act_recvd_comrep_o => ghr_cmp_shd.g_old_rec.final_act_recvd_comrep
600: ,p_final_action_decision_date_o => ghr_cmp_shd.g_old_rec.final_action_decision_date
601: ,p_final_action_decision_o => ghr_cmp_shd.g_old_rec.final_action_decision
602: ,p_fa_imp_ltr_forwd_to_org_o => ghr_cmp_shd.g_old_rec.fa_imp_ltr_forwd_to_org
603: ,p_fa_decision_forwd_legal_o => ghr_cmp_shd.g_old_rec.fa_decision_forwd_legal
604: ,p_fa_decision_recvd_legal_o => ghr_cmp_shd.g_old_rec.fa_decision_recvd_legal
605: ,p_civil_action_filed_o => ghr_cmp_shd.g_old_rec.civil_action_filed
606: ,p_agency_closure_confirmed_o => ghr_cmp_shd.g_old_rec.agency_closure_confirmed

Line 603: ,p_fa_decision_forwd_legal_o => ghr_cmp_shd.g_old_rec.fa_decision_forwd_legal

599: ,p_final_act_recvd_comrep_o => ghr_cmp_shd.g_old_rec.final_act_recvd_comrep
600: ,p_final_action_decision_date_o => ghr_cmp_shd.g_old_rec.final_action_decision_date
601: ,p_final_action_decision_o => ghr_cmp_shd.g_old_rec.final_action_decision
602: ,p_fa_imp_ltr_forwd_to_org_o => ghr_cmp_shd.g_old_rec.fa_imp_ltr_forwd_to_org
603: ,p_fa_decision_forwd_legal_o => ghr_cmp_shd.g_old_rec.fa_decision_forwd_legal
604: ,p_fa_decision_recvd_legal_o => ghr_cmp_shd.g_old_rec.fa_decision_recvd_legal
605: ,p_civil_action_filed_o => ghr_cmp_shd.g_old_rec.civil_action_filed
606: ,p_agency_closure_confirmed_o => ghr_cmp_shd.g_old_rec.agency_closure_confirmed
607: ,p_consolidated_complaint_id_o => ghr_cmp_shd.g_old_rec.consolidated_complaint_id

Line 604: ,p_fa_decision_recvd_legal_o => ghr_cmp_shd.g_old_rec.fa_decision_recvd_legal

600: ,p_final_action_decision_date_o => ghr_cmp_shd.g_old_rec.final_action_decision_date
601: ,p_final_action_decision_o => ghr_cmp_shd.g_old_rec.final_action_decision
602: ,p_fa_imp_ltr_forwd_to_org_o => ghr_cmp_shd.g_old_rec.fa_imp_ltr_forwd_to_org
603: ,p_fa_decision_forwd_legal_o => ghr_cmp_shd.g_old_rec.fa_decision_forwd_legal
604: ,p_fa_decision_recvd_legal_o => ghr_cmp_shd.g_old_rec.fa_decision_recvd_legal
605: ,p_civil_action_filed_o => ghr_cmp_shd.g_old_rec.civil_action_filed
606: ,p_agency_closure_confirmed_o => ghr_cmp_shd.g_old_rec.agency_closure_confirmed
607: ,p_consolidated_complaint_id_o => ghr_cmp_shd.g_old_rec.consolidated_complaint_id
608: ,p_consolidated_o => ghr_cmp_shd.g_old_rec.consolidated

Line 605: ,p_civil_action_filed_o => ghr_cmp_shd.g_old_rec.civil_action_filed

601: ,p_final_action_decision_o => ghr_cmp_shd.g_old_rec.final_action_decision
602: ,p_fa_imp_ltr_forwd_to_org_o => ghr_cmp_shd.g_old_rec.fa_imp_ltr_forwd_to_org
603: ,p_fa_decision_forwd_legal_o => ghr_cmp_shd.g_old_rec.fa_decision_forwd_legal
604: ,p_fa_decision_recvd_legal_o => ghr_cmp_shd.g_old_rec.fa_decision_recvd_legal
605: ,p_civil_action_filed_o => ghr_cmp_shd.g_old_rec.civil_action_filed
606: ,p_agency_closure_confirmed_o => ghr_cmp_shd.g_old_rec.agency_closure_confirmed
607: ,p_consolidated_complaint_id_o => ghr_cmp_shd.g_old_rec.consolidated_complaint_id
608: ,p_consolidated_o => ghr_cmp_shd.g_old_rec.consolidated
609: ,p_stage_of_consolidation_o => ghr_cmp_shd.g_old_rec.stage_of_consolidation

Line 606: ,p_agency_closure_confirmed_o => ghr_cmp_shd.g_old_rec.agency_closure_confirmed

602: ,p_fa_imp_ltr_forwd_to_org_o => ghr_cmp_shd.g_old_rec.fa_imp_ltr_forwd_to_org
603: ,p_fa_decision_forwd_legal_o => ghr_cmp_shd.g_old_rec.fa_decision_forwd_legal
604: ,p_fa_decision_recvd_legal_o => ghr_cmp_shd.g_old_rec.fa_decision_recvd_legal
605: ,p_civil_action_filed_o => ghr_cmp_shd.g_old_rec.civil_action_filed
606: ,p_agency_closure_confirmed_o => ghr_cmp_shd.g_old_rec.agency_closure_confirmed
607: ,p_consolidated_complaint_id_o => ghr_cmp_shd.g_old_rec.consolidated_complaint_id
608: ,p_consolidated_o => ghr_cmp_shd.g_old_rec.consolidated
609: ,p_stage_of_consolidation_o => ghr_cmp_shd.g_old_rec.stage_of_consolidation
610: ,p_comrep_notif_consolidation_o => ghr_cmp_shd.g_old_rec.comrep_notif_consolidation

Line 607: ,p_consolidated_complaint_id_o => ghr_cmp_shd.g_old_rec.consolidated_complaint_id

603: ,p_fa_decision_forwd_legal_o => ghr_cmp_shd.g_old_rec.fa_decision_forwd_legal
604: ,p_fa_decision_recvd_legal_o => ghr_cmp_shd.g_old_rec.fa_decision_recvd_legal
605: ,p_civil_action_filed_o => ghr_cmp_shd.g_old_rec.civil_action_filed
606: ,p_agency_closure_confirmed_o => ghr_cmp_shd.g_old_rec.agency_closure_confirmed
607: ,p_consolidated_complaint_id_o => ghr_cmp_shd.g_old_rec.consolidated_complaint_id
608: ,p_consolidated_o => ghr_cmp_shd.g_old_rec.consolidated
609: ,p_stage_of_consolidation_o => ghr_cmp_shd.g_old_rec.stage_of_consolidation
610: ,p_comrep_notif_consolidation_o => ghr_cmp_shd.g_old_rec.comrep_notif_consolidation
611: ,p_consolidation_desc_o => ghr_cmp_shd.g_old_rec.consolidation_desc

Line 608: ,p_consolidated_o => ghr_cmp_shd.g_old_rec.consolidated

604: ,p_fa_decision_recvd_legal_o => ghr_cmp_shd.g_old_rec.fa_decision_recvd_legal
605: ,p_civil_action_filed_o => ghr_cmp_shd.g_old_rec.civil_action_filed
606: ,p_agency_closure_confirmed_o => ghr_cmp_shd.g_old_rec.agency_closure_confirmed
607: ,p_consolidated_complaint_id_o => ghr_cmp_shd.g_old_rec.consolidated_complaint_id
608: ,p_consolidated_o => ghr_cmp_shd.g_old_rec.consolidated
609: ,p_stage_of_consolidation_o => ghr_cmp_shd.g_old_rec.stage_of_consolidation
610: ,p_comrep_notif_consolidation_o => ghr_cmp_shd.g_old_rec.comrep_notif_consolidation
611: ,p_consolidation_desc_o => ghr_cmp_shd.g_old_rec.consolidation_desc
612: ,p_complaint_closed_o => ghr_cmp_shd.g_old_rec.complaint_closed

Line 609: ,p_stage_of_consolidation_o => ghr_cmp_shd.g_old_rec.stage_of_consolidation

605: ,p_civil_action_filed_o => ghr_cmp_shd.g_old_rec.civil_action_filed
606: ,p_agency_closure_confirmed_o => ghr_cmp_shd.g_old_rec.agency_closure_confirmed
607: ,p_consolidated_complaint_id_o => ghr_cmp_shd.g_old_rec.consolidated_complaint_id
608: ,p_consolidated_o => ghr_cmp_shd.g_old_rec.consolidated
609: ,p_stage_of_consolidation_o => ghr_cmp_shd.g_old_rec.stage_of_consolidation
610: ,p_comrep_notif_consolidation_o => ghr_cmp_shd.g_old_rec.comrep_notif_consolidation
611: ,p_consolidation_desc_o => ghr_cmp_shd.g_old_rec.consolidation_desc
612: ,p_complaint_closed_o => ghr_cmp_shd.g_old_rec.complaint_closed
613: ,p_nature_of_closure_o => ghr_cmp_shd.g_old_rec.nature_of_closure

Line 610: ,p_comrep_notif_consolidation_o => ghr_cmp_shd.g_old_rec.comrep_notif_consolidation

606: ,p_agency_closure_confirmed_o => ghr_cmp_shd.g_old_rec.agency_closure_confirmed
607: ,p_consolidated_complaint_id_o => ghr_cmp_shd.g_old_rec.consolidated_complaint_id
608: ,p_consolidated_o => ghr_cmp_shd.g_old_rec.consolidated
609: ,p_stage_of_consolidation_o => ghr_cmp_shd.g_old_rec.stage_of_consolidation
610: ,p_comrep_notif_consolidation_o => ghr_cmp_shd.g_old_rec.comrep_notif_consolidation
611: ,p_consolidation_desc_o => ghr_cmp_shd.g_old_rec.consolidation_desc
612: ,p_complaint_closed_o => ghr_cmp_shd.g_old_rec.complaint_closed
613: ,p_nature_of_closure_o => ghr_cmp_shd.g_old_rec.nature_of_closure
614: ,p_complaint_closed_desc_o => ghr_cmp_shd.g_old_rec.complaint_closed_desc

Line 611: ,p_consolidation_desc_o => ghr_cmp_shd.g_old_rec.consolidation_desc

607: ,p_consolidated_complaint_id_o => ghr_cmp_shd.g_old_rec.consolidated_complaint_id
608: ,p_consolidated_o => ghr_cmp_shd.g_old_rec.consolidated
609: ,p_stage_of_consolidation_o => ghr_cmp_shd.g_old_rec.stage_of_consolidation
610: ,p_comrep_notif_consolidation_o => ghr_cmp_shd.g_old_rec.comrep_notif_consolidation
611: ,p_consolidation_desc_o => ghr_cmp_shd.g_old_rec.consolidation_desc
612: ,p_complaint_closed_o => ghr_cmp_shd.g_old_rec.complaint_closed
613: ,p_nature_of_closure_o => ghr_cmp_shd.g_old_rec.nature_of_closure
614: ,p_complaint_closed_desc_o => ghr_cmp_shd.g_old_rec.complaint_closed_desc
615: ,p_filed_formal_class_o => ghr_cmp_shd.g_old_rec.filed_formal_class

Line 612: ,p_complaint_closed_o => ghr_cmp_shd.g_old_rec.complaint_closed

608: ,p_consolidated_o => ghr_cmp_shd.g_old_rec.consolidated
609: ,p_stage_of_consolidation_o => ghr_cmp_shd.g_old_rec.stage_of_consolidation
610: ,p_comrep_notif_consolidation_o => ghr_cmp_shd.g_old_rec.comrep_notif_consolidation
611: ,p_consolidation_desc_o => ghr_cmp_shd.g_old_rec.consolidation_desc
612: ,p_complaint_closed_o => ghr_cmp_shd.g_old_rec.complaint_closed
613: ,p_nature_of_closure_o => ghr_cmp_shd.g_old_rec.nature_of_closure
614: ,p_complaint_closed_desc_o => ghr_cmp_shd.g_old_rec.complaint_closed_desc
615: ,p_filed_formal_class_o => ghr_cmp_shd.g_old_rec.filed_formal_class
616: ,p_forwd_eeoc_o => ghr_cmp_shd.g_old_rec.forwd_eeoc

Line 613: ,p_nature_of_closure_o => ghr_cmp_shd.g_old_rec.nature_of_closure

609: ,p_stage_of_consolidation_o => ghr_cmp_shd.g_old_rec.stage_of_consolidation
610: ,p_comrep_notif_consolidation_o => ghr_cmp_shd.g_old_rec.comrep_notif_consolidation
611: ,p_consolidation_desc_o => ghr_cmp_shd.g_old_rec.consolidation_desc
612: ,p_complaint_closed_o => ghr_cmp_shd.g_old_rec.complaint_closed
613: ,p_nature_of_closure_o => ghr_cmp_shd.g_old_rec.nature_of_closure
614: ,p_complaint_closed_desc_o => ghr_cmp_shd.g_old_rec.complaint_closed_desc
615: ,p_filed_formal_class_o => ghr_cmp_shd.g_old_rec.filed_formal_class
616: ,p_forwd_eeoc_o => ghr_cmp_shd.g_old_rec.forwd_eeoc
617: ,p_aj_cert_decision_date_o => ghr_cmp_shd.g_old_rec.aj_cert_decision_date

Line 614: ,p_complaint_closed_desc_o => ghr_cmp_shd.g_old_rec.complaint_closed_desc

610: ,p_comrep_notif_consolidation_o => ghr_cmp_shd.g_old_rec.comrep_notif_consolidation
611: ,p_consolidation_desc_o => ghr_cmp_shd.g_old_rec.consolidation_desc
612: ,p_complaint_closed_o => ghr_cmp_shd.g_old_rec.complaint_closed
613: ,p_nature_of_closure_o => ghr_cmp_shd.g_old_rec.nature_of_closure
614: ,p_complaint_closed_desc_o => ghr_cmp_shd.g_old_rec.complaint_closed_desc
615: ,p_filed_formal_class_o => ghr_cmp_shd.g_old_rec.filed_formal_class
616: ,p_forwd_eeoc_o => ghr_cmp_shd.g_old_rec.forwd_eeoc
617: ,p_aj_cert_decision_date_o => ghr_cmp_shd.g_old_rec.aj_cert_decision_date
618: ,p_aj_cert_decision_recvd_o => ghr_cmp_shd.g_old_rec.aj_cert_decision_recvd

Line 615: ,p_filed_formal_class_o => ghr_cmp_shd.g_old_rec.filed_formal_class

611: ,p_consolidation_desc_o => ghr_cmp_shd.g_old_rec.consolidation_desc
612: ,p_complaint_closed_o => ghr_cmp_shd.g_old_rec.complaint_closed
613: ,p_nature_of_closure_o => ghr_cmp_shd.g_old_rec.nature_of_closure
614: ,p_complaint_closed_desc_o => ghr_cmp_shd.g_old_rec.complaint_closed_desc
615: ,p_filed_formal_class_o => ghr_cmp_shd.g_old_rec.filed_formal_class
616: ,p_forwd_eeoc_o => ghr_cmp_shd.g_old_rec.forwd_eeoc
617: ,p_aj_cert_decision_date_o => ghr_cmp_shd.g_old_rec.aj_cert_decision_date
618: ,p_aj_cert_decision_recvd_o => ghr_cmp_shd.g_old_rec.aj_cert_decision_recvd
619: ,p_aj_cert_decision_o => ghr_cmp_shd.g_old_rec.aj_cert_decision

Line 616: ,p_forwd_eeoc_o => ghr_cmp_shd.g_old_rec.forwd_eeoc

612: ,p_complaint_closed_o => ghr_cmp_shd.g_old_rec.complaint_closed
613: ,p_nature_of_closure_o => ghr_cmp_shd.g_old_rec.nature_of_closure
614: ,p_complaint_closed_desc_o => ghr_cmp_shd.g_old_rec.complaint_closed_desc
615: ,p_filed_formal_class_o => ghr_cmp_shd.g_old_rec.filed_formal_class
616: ,p_forwd_eeoc_o => ghr_cmp_shd.g_old_rec.forwd_eeoc
617: ,p_aj_cert_decision_date_o => ghr_cmp_shd.g_old_rec.aj_cert_decision_date
618: ,p_aj_cert_decision_recvd_o => ghr_cmp_shd.g_old_rec.aj_cert_decision_recvd
619: ,p_aj_cert_decision_o => ghr_cmp_shd.g_old_rec.aj_cert_decision
620: ,p_class_members_notified_o => ghr_cmp_shd.g_old_rec.class_members_notified

Line 617: ,p_aj_cert_decision_date_o => ghr_cmp_shd.g_old_rec.aj_cert_decision_date

613: ,p_nature_of_closure_o => ghr_cmp_shd.g_old_rec.nature_of_closure
614: ,p_complaint_closed_desc_o => ghr_cmp_shd.g_old_rec.complaint_closed_desc
615: ,p_filed_formal_class_o => ghr_cmp_shd.g_old_rec.filed_formal_class
616: ,p_forwd_eeoc_o => ghr_cmp_shd.g_old_rec.forwd_eeoc
617: ,p_aj_cert_decision_date_o => ghr_cmp_shd.g_old_rec.aj_cert_decision_date
618: ,p_aj_cert_decision_recvd_o => ghr_cmp_shd.g_old_rec.aj_cert_decision_recvd
619: ,p_aj_cert_decision_o => ghr_cmp_shd.g_old_rec.aj_cert_decision
620: ,p_class_members_notified_o => ghr_cmp_shd.g_old_rec.class_members_notified
621: ,p_number_of_complaintants_o => ghr_cmp_shd.g_old_rec.number_of_complaintants

Line 618: ,p_aj_cert_decision_recvd_o => ghr_cmp_shd.g_old_rec.aj_cert_decision_recvd

614: ,p_complaint_closed_desc_o => ghr_cmp_shd.g_old_rec.complaint_closed_desc
615: ,p_filed_formal_class_o => ghr_cmp_shd.g_old_rec.filed_formal_class
616: ,p_forwd_eeoc_o => ghr_cmp_shd.g_old_rec.forwd_eeoc
617: ,p_aj_cert_decision_date_o => ghr_cmp_shd.g_old_rec.aj_cert_decision_date
618: ,p_aj_cert_decision_recvd_o => ghr_cmp_shd.g_old_rec.aj_cert_decision_recvd
619: ,p_aj_cert_decision_o => ghr_cmp_shd.g_old_rec.aj_cert_decision
620: ,p_class_members_notified_o => ghr_cmp_shd.g_old_rec.class_members_notified
621: ,p_number_of_complaintants_o => ghr_cmp_shd.g_old_rec.number_of_complaintants
622: ,p_class_hearing_o => ghr_cmp_shd.g_old_rec.class_hearing

Line 619: ,p_aj_cert_decision_o => ghr_cmp_shd.g_old_rec.aj_cert_decision

615: ,p_filed_formal_class_o => ghr_cmp_shd.g_old_rec.filed_formal_class
616: ,p_forwd_eeoc_o => ghr_cmp_shd.g_old_rec.forwd_eeoc
617: ,p_aj_cert_decision_date_o => ghr_cmp_shd.g_old_rec.aj_cert_decision_date
618: ,p_aj_cert_decision_recvd_o => ghr_cmp_shd.g_old_rec.aj_cert_decision_recvd
619: ,p_aj_cert_decision_o => ghr_cmp_shd.g_old_rec.aj_cert_decision
620: ,p_class_members_notified_o => ghr_cmp_shd.g_old_rec.class_members_notified
621: ,p_number_of_complaintants_o => ghr_cmp_shd.g_old_rec.number_of_complaintants
622: ,p_class_hearing_o => ghr_cmp_shd.g_old_rec.class_hearing
623: ,p_aj_dec_o => ghr_cmp_shd.g_old_rec.aj_dec

Line 620: ,p_class_members_notified_o => ghr_cmp_shd.g_old_rec.class_members_notified

616: ,p_forwd_eeoc_o => ghr_cmp_shd.g_old_rec.forwd_eeoc
617: ,p_aj_cert_decision_date_o => ghr_cmp_shd.g_old_rec.aj_cert_decision_date
618: ,p_aj_cert_decision_recvd_o => ghr_cmp_shd.g_old_rec.aj_cert_decision_recvd
619: ,p_aj_cert_decision_o => ghr_cmp_shd.g_old_rec.aj_cert_decision
620: ,p_class_members_notified_o => ghr_cmp_shd.g_old_rec.class_members_notified
621: ,p_number_of_complaintants_o => ghr_cmp_shd.g_old_rec.number_of_complaintants
622: ,p_class_hearing_o => ghr_cmp_shd.g_old_rec.class_hearing
623: ,p_aj_dec_o => ghr_cmp_shd.g_old_rec.aj_dec
624: ,p_agency_recvd_aj_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_dec

Line 621: ,p_number_of_complaintants_o => ghr_cmp_shd.g_old_rec.number_of_complaintants

617: ,p_aj_cert_decision_date_o => ghr_cmp_shd.g_old_rec.aj_cert_decision_date
618: ,p_aj_cert_decision_recvd_o => ghr_cmp_shd.g_old_rec.aj_cert_decision_recvd
619: ,p_aj_cert_decision_o => ghr_cmp_shd.g_old_rec.aj_cert_decision
620: ,p_class_members_notified_o => ghr_cmp_shd.g_old_rec.class_members_notified
621: ,p_number_of_complaintants_o => ghr_cmp_shd.g_old_rec.number_of_complaintants
622: ,p_class_hearing_o => ghr_cmp_shd.g_old_rec.class_hearing
623: ,p_aj_dec_o => ghr_cmp_shd.g_old_rec.aj_dec
624: ,p_agency_recvd_aj_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_dec
625: ,p_aj_decision_o => ghr_cmp_shd.g_old_rec.aj_decision

Line 622: ,p_class_hearing_o => ghr_cmp_shd.g_old_rec.class_hearing

618: ,p_aj_cert_decision_recvd_o => ghr_cmp_shd.g_old_rec.aj_cert_decision_recvd
619: ,p_aj_cert_decision_o => ghr_cmp_shd.g_old_rec.aj_cert_decision
620: ,p_class_members_notified_o => ghr_cmp_shd.g_old_rec.class_members_notified
621: ,p_number_of_complaintants_o => ghr_cmp_shd.g_old_rec.number_of_complaintants
622: ,p_class_hearing_o => ghr_cmp_shd.g_old_rec.class_hearing
623: ,p_aj_dec_o => ghr_cmp_shd.g_old_rec.aj_dec
624: ,p_agency_recvd_aj_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_dec
625: ,p_aj_decision_o => ghr_cmp_shd.g_old_rec.aj_decision
626: ,p_object_version_number_o => ghr_cmp_shd.g_old_rec.object_version_number

Line 623: ,p_aj_dec_o => ghr_cmp_shd.g_old_rec.aj_dec

619: ,p_aj_cert_decision_o => ghr_cmp_shd.g_old_rec.aj_cert_decision
620: ,p_class_members_notified_o => ghr_cmp_shd.g_old_rec.class_members_notified
621: ,p_number_of_complaintants_o => ghr_cmp_shd.g_old_rec.number_of_complaintants
622: ,p_class_hearing_o => ghr_cmp_shd.g_old_rec.class_hearing
623: ,p_aj_dec_o => ghr_cmp_shd.g_old_rec.aj_dec
624: ,p_agency_recvd_aj_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_dec
625: ,p_aj_decision_o => ghr_cmp_shd.g_old_rec.aj_decision
626: ,p_object_version_number_o => ghr_cmp_shd.g_old_rec.object_version_number
627: ,p_agency_brief_eeoc_o => ghr_cmp_shd.g_old_rec.agency_brief_eeoc

Line 624: ,p_agency_recvd_aj_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_dec

620: ,p_class_members_notified_o => ghr_cmp_shd.g_old_rec.class_members_notified
621: ,p_number_of_complaintants_o => ghr_cmp_shd.g_old_rec.number_of_complaintants
622: ,p_class_hearing_o => ghr_cmp_shd.g_old_rec.class_hearing
623: ,p_aj_dec_o => ghr_cmp_shd.g_old_rec.aj_dec
624: ,p_agency_recvd_aj_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_dec
625: ,p_aj_decision_o => ghr_cmp_shd.g_old_rec.aj_decision
626: ,p_object_version_number_o => ghr_cmp_shd.g_old_rec.object_version_number
627: ,p_agency_brief_eeoc_o => ghr_cmp_shd.g_old_rec.agency_brief_eeoc
628: ,p_agency_notif_of_civil_acti_o => ghr_cmp_shd.g_old_rec.agency_notif_of_civil_action

Line 625: ,p_aj_decision_o => ghr_cmp_shd.g_old_rec.aj_decision

621: ,p_number_of_complaintants_o => ghr_cmp_shd.g_old_rec.number_of_complaintants
622: ,p_class_hearing_o => ghr_cmp_shd.g_old_rec.class_hearing
623: ,p_aj_dec_o => ghr_cmp_shd.g_old_rec.aj_dec
624: ,p_agency_recvd_aj_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_dec
625: ,p_aj_decision_o => ghr_cmp_shd.g_old_rec.aj_decision
626: ,p_object_version_number_o => ghr_cmp_shd.g_old_rec.object_version_number
627: ,p_agency_brief_eeoc_o => ghr_cmp_shd.g_old_rec.agency_brief_eeoc
628: ,p_agency_notif_of_civil_acti_o => ghr_cmp_shd.g_old_rec.agency_notif_of_civil_action
629: ,p_fad_source_o => ghr_cmp_shd.g_old_rec.fad_source

Line 626: ,p_object_version_number_o => ghr_cmp_shd.g_old_rec.object_version_number

622: ,p_class_hearing_o => ghr_cmp_shd.g_old_rec.class_hearing
623: ,p_aj_dec_o => ghr_cmp_shd.g_old_rec.aj_dec
624: ,p_agency_recvd_aj_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_dec
625: ,p_aj_decision_o => ghr_cmp_shd.g_old_rec.aj_decision
626: ,p_object_version_number_o => ghr_cmp_shd.g_old_rec.object_version_number
627: ,p_agency_brief_eeoc_o => ghr_cmp_shd.g_old_rec.agency_brief_eeoc
628: ,p_agency_notif_of_civil_acti_o => ghr_cmp_shd.g_old_rec.agency_notif_of_civil_action
629: ,p_fad_source_o => ghr_cmp_shd.g_old_rec.fad_source
630: ,p_agency_files_forwarded_eeo_o => ghr_cmp_shd.g_old_rec.agency_files_forwarded_eeoc

Line 627: ,p_agency_brief_eeoc_o => ghr_cmp_shd.g_old_rec.agency_brief_eeoc

623: ,p_aj_dec_o => ghr_cmp_shd.g_old_rec.aj_dec
624: ,p_agency_recvd_aj_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_dec
625: ,p_aj_decision_o => ghr_cmp_shd.g_old_rec.aj_decision
626: ,p_object_version_number_o => ghr_cmp_shd.g_old_rec.object_version_number
627: ,p_agency_brief_eeoc_o => ghr_cmp_shd.g_old_rec.agency_brief_eeoc
628: ,p_agency_notif_of_civil_acti_o => ghr_cmp_shd.g_old_rec.agency_notif_of_civil_action
629: ,p_fad_source_o => ghr_cmp_shd.g_old_rec.fad_source
630: ,p_agency_files_forwarded_eeo_o => ghr_cmp_shd.g_old_rec.agency_files_forwarded_eeoc
631: ,p_hearing_req_o => ghr_cmp_shd.g_old_rec.hearing_req

Line 628: ,p_agency_notif_of_civil_acti_o => ghr_cmp_shd.g_old_rec.agency_notif_of_civil_action

624: ,p_agency_recvd_aj_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_dec
625: ,p_aj_decision_o => ghr_cmp_shd.g_old_rec.aj_decision
626: ,p_object_version_number_o => ghr_cmp_shd.g_old_rec.object_version_number
627: ,p_agency_brief_eeoc_o => ghr_cmp_shd.g_old_rec.agency_brief_eeoc
628: ,p_agency_notif_of_civil_acti_o => ghr_cmp_shd.g_old_rec.agency_notif_of_civil_action
629: ,p_fad_source_o => ghr_cmp_shd.g_old_rec.fad_source
630: ,p_agency_files_forwarded_eeo_o => ghr_cmp_shd.g_old_rec.agency_files_forwarded_eeoc
631: ,p_hearing_req_o => ghr_cmp_shd.g_old_rec.hearing_req
632: ,p_agency_code_o => ghr_cmp_shd.g_old_rec.agency_code

Line 629: ,p_fad_source_o => ghr_cmp_shd.g_old_rec.fad_source

625: ,p_aj_decision_o => ghr_cmp_shd.g_old_rec.aj_decision
626: ,p_object_version_number_o => ghr_cmp_shd.g_old_rec.object_version_number
627: ,p_agency_brief_eeoc_o => ghr_cmp_shd.g_old_rec.agency_brief_eeoc
628: ,p_agency_notif_of_civil_acti_o => ghr_cmp_shd.g_old_rec.agency_notif_of_civil_action
629: ,p_fad_source_o => ghr_cmp_shd.g_old_rec.fad_source
630: ,p_agency_files_forwarded_eeo_o => ghr_cmp_shd.g_old_rec.agency_files_forwarded_eeoc
631: ,p_hearing_req_o => ghr_cmp_shd.g_old_rec.hearing_req
632: ,p_agency_code_o => ghr_cmp_shd.g_old_rec.agency_code
633: ,p_audited_by_o => ghr_cmp_shd.g_old_rec.audited_by

Line 630: ,p_agency_files_forwarded_eeo_o => ghr_cmp_shd.g_old_rec.agency_files_forwarded_eeoc

626: ,p_object_version_number_o => ghr_cmp_shd.g_old_rec.object_version_number
627: ,p_agency_brief_eeoc_o => ghr_cmp_shd.g_old_rec.agency_brief_eeoc
628: ,p_agency_notif_of_civil_acti_o => ghr_cmp_shd.g_old_rec.agency_notif_of_civil_action
629: ,p_fad_source_o => ghr_cmp_shd.g_old_rec.fad_source
630: ,p_agency_files_forwarded_eeo_o => ghr_cmp_shd.g_old_rec.agency_files_forwarded_eeoc
631: ,p_hearing_req_o => ghr_cmp_shd.g_old_rec.hearing_req
632: ,p_agency_code_o => ghr_cmp_shd.g_old_rec.agency_code
633: ,p_audited_by_o => ghr_cmp_shd.g_old_rec.audited_by
634: ,p_record_received_o => ghr_cmp_shd.g_old_rec.record_received

Line 631: ,p_hearing_req_o => ghr_cmp_shd.g_old_rec.hearing_req

627: ,p_agency_brief_eeoc_o => ghr_cmp_shd.g_old_rec.agency_brief_eeoc
628: ,p_agency_notif_of_civil_acti_o => ghr_cmp_shd.g_old_rec.agency_notif_of_civil_action
629: ,p_fad_source_o => ghr_cmp_shd.g_old_rec.fad_source
630: ,p_agency_files_forwarded_eeo_o => ghr_cmp_shd.g_old_rec.agency_files_forwarded_eeoc
631: ,p_hearing_req_o => ghr_cmp_shd.g_old_rec.hearing_req
632: ,p_agency_code_o => ghr_cmp_shd.g_old_rec.agency_code
633: ,p_audited_by_o => ghr_cmp_shd.g_old_rec.audited_by
634: ,p_record_received_o => ghr_cmp_shd.g_old_rec.record_received
635: ,p_attribute_category_o => ghr_cmp_shd.g_old_rec.attribute_category

Line 632: ,p_agency_code_o => ghr_cmp_shd.g_old_rec.agency_code

628: ,p_agency_notif_of_civil_acti_o => ghr_cmp_shd.g_old_rec.agency_notif_of_civil_action
629: ,p_fad_source_o => ghr_cmp_shd.g_old_rec.fad_source
630: ,p_agency_files_forwarded_eeo_o => ghr_cmp_shd.g_old_rec.agency_files_forwarded_eeoc
631: ,p_hearing_req_o => ghr_cmp_shd.g_old_rec.hearing_req
632: ,p_agency_code_o => ghr_cmp_shd.g_old_rec.agency_code
633: ,p_audited_by_o => ghr_cmp_shd.g_old_rec.audited_by
634: ,p_record_received_o => ghr_cmp_shd.g_old_rec.record_received
635: ,p_attribute_category_o => ghr_cmp_shd.g_old_rec.attribute_category
636: ,p_attribute1_o => ghr_cmp_shd.g_old_rec.attribute1

Line 633: ,p_audited_by_o => ghr_cmp_shd.g_old_rec.audited_by

629: ,p_fad_source_o => ghr_cmp_shd.g_old_rec.fad_source
630: ,p_agency_files_forwarded_eeo_o => ghr_cmp_shd.g_old_rec.agency_files_forwarded_eeoc
631: ,p_hearing_req_o => ghr_cmp_shd.g_old_rec.hearing_req
632: ,p_agency_code_o => ghr_cmp_shd.g_old_rec.agency_code
633: ,p_audited_by_o => ghr_cmp_shd.g_old_rec.audited_by
634: ,p_record_received_o => ghr_cmp_shd.g_old_rec.record_received
635: ,p_attribute_category_o => ghr_cmp_shd.g_old_rec.attribute_category
636: ,p_attribute1_o => ghr_cmp_shd.g_old_rec.attribute1
637: ,p_attribute2_o => ghr_cmp_shd.g_old_rec.attribute2

Line 634: ,p_record_received_o => ghr_cmp_shd.g_old_rec.record_received

630: ,p_agency_files_forwarded_eeo_o => ghr_cmp_shd.g_old_rec.agency_files_forwarded_eeoc
631: ,p_hearing_req_o => ghr_cmp_shd.g_old_rec.hearing_req
632: ,p_agency_code_o => ghr_cmp_shd.g_old_rec.agency_code
633: ,p_audited_by_o => ghr_cmp_shd.g_old_rec.audited_by
634: ,p_record_received_o => ghr_cmp_shd.g_old_rec.record_received
635: ,p_attribute_category_o => ghr_cmp_shd.g_old_rec.attribute_category
636: ,p_attribute1_o => ghr_cmp_shd.g_old_rec.attribute1
637: ,p_attribute2_o => ghr_cmp_shd.g_old_rec.attribute2
638: ,p_attribute3_o => ghr_cmp_shd.g_old_rec.attribute3

Line 635: ,p_attribute_category_o => ghr_cmp_shd.g_old_rec.attribute_category

631: ,p_hearing_req_o => ghr_cmp_shd.g_old_rec.hearing_req
632: ,p_agency_code_o => ghr_cmp_shd.g_old_rec.agency_code
633: ,p_audited_by_o => ghr_cmp_shd.g_old_rec.audited_by
634: ,p_record_received_o => ghr_cmp_shd.g_old_rec.record_received
635: ,p_attribute_category_o => ghr_cmp_shd.g_old_rec.attribute_category
636: ,p_attribute1_o => ghr_cmp_shd.g_old_rec.attribute1
637: ,p_attribute2_o => ghr_cmp_shd.g_old_rec.attribute2
638: ,p_attribute3_o => ghr_cmp_shd.g_old_rec.attribute3
639: ,p_attribute4_o => ghr_cmp_shd.g_old_rec.attribute4

Line 636: ,p_attribute1_o => ghr_cmp_shd.g_old_rec.attribute1

632: ,p_agency_code_o => ghr_cmp_shd.g_old_rec.agency_code
633: ,p_audited_by_o => ghr_cmp_shd.g_old_rec.audited_by
634: ,p_record_received_o => ghr_cmp_shd.g_old_rec.record_received
635: ,p_attribute_category_o => ghr_cmp_shd.g_old_rec.attribute_category
636: ,p_attribute1_o => ghr_cmp_shd.g_old_rec.attribute1
637: ,p_attribute2_o => ghr_cmp_shd.g_old_rec.attribute2
638: ,p_attribute3_o => ghr_cmp_shd.g_old_rec.attribute3
639: ,p_attribute4_o => ghr_cmp_shd.g_old_rec.attribute4
640: ,p_attribute5_o => ghr_cmp_shd.g_old_rec.attribute5

Line 637: ,p_attribute2_o => ghr_cmp_shd.g_old_rec.attribute2

633: ,p_audited_by_o => ghr_cmp_shd.g_old_rec.audited_by
634: ,p_record_received_o => ghr_cmp_shd.g_old_rec.record_received
635: ,p_attribute_category_o => ghr_cmp_shd.g_old_rec.attribute_category
636: ,p_attribute1_o => ghr_cmp_shd.g_old_rec.attribute1
637: ,p_attribute2_o => ghr_cmp_shd.g_old_rec.attribute2
638: ,p_attribute3_o => ghr_cmp_shd.g_old_rec.attribute3
639: ,p_attribute4_o => ghr_cmp_shd.g_old_rec.attribute4
640: ,p_attribute5_o => ghr_cmp_shd.g_old_rec.attribute5
641: ,p_attribute6_o => ghr_cmp_shd.g_old_rec.attribute6

Line 638: ,p_attribute3_o => ghr_cmp_shd.g_old_rec.attribute3

634: ,p_record_received_o => ghr_cmp_shd.g_old_rec.record_received
635: ,p_attribute_category_o => ghr_cmp_shd.g_old_rec.attribute_category
636: ,p_attribute1_o => ghr_cmp_shd.g_old_rec.attribute1
637: ,p_attribute2_o => ghr_cmp_shd.g_old_rec.attribute2
638: ,p_attribute3_o => ghr_cmp_shd.g_old_rec.attribute3
639: ,p_attribute4_o => ghr_cmp_shd.g_old_rec.attribute4
640: ,p_attribute5_o => ghr_cmp_shd.g_old_rec.attribute5
641: ,p_attribute6_o => ghr_cmp_shd.g_old_rec.attribute6
642: ,p_attribute7_o => ghr_cmp_shd.g_old_rec.attribute7

Line 639: ,p_attribute4_o => ghr_cmp_shd.g_old_rec.attribute4

635: ,p_attribute_category_o => ghr_cmp_shd.g_old_rec.attribute_category
636: ,p_attribute1_o => ghr_cmp_shd.g_old_rec.attribute1
637: ,p_attribute2_o => ghr_cmp_shd.g_old_rec.attribute2
638: ,p_attribute3_o => ghr_cmp_shd.g_old_rec.attribute3
639: ,p_attribute4_o => ghr_cmp_shd.g_old_rec.attribute4
640: ,p_attribute5_o => ghr_cmp_shd.g_old_rec.attribute5
641: ,p_attribute6_o => ghr_cmp_shd.g_old_rec.attribute6
642: ,p_attribute7_o => ghr_cmp_shd.g_old_rec.attribute7
643: ,p_attribute8_o => ghr_cmp_shd.g_old_rec.attribute8

Line 640: ,p_attribute5_o => ghr_cmp_shd.g_old_rec.attribute5

636: ,p_attribute1_o => ghr_cmp_shd.g_old_rec.attribute1
637: ,p_attribute2_o => ghr_cmp_shd.g_old_rec.attribute2
638: ,p_attribute3_o => ghr_cmp_shd.g_old_rec.attribute3
639: ,p_attribute4_o => ghr_cmp_shd.g_old_rec.attribute4
640: ,p_attribute5_o => ghr_cmp_shd.g_old_rec.attribute5
641: ,p_attribute6_o => ghr_cmp_shd.g_old_rec.attribute6
642: ,p_attribute7_o => ghr_cmp_shd.g_old_rec.attribute7
643: ,p_attribute8_o => ghr_cmp_shd.g_old_rec.attribute8
644: ,p_attribute9_o => ghr_cmp_shd.g_old_rec.attribute9

Line 641: ,p_attribute6_o => ghr_cmp_shd.g_old_rec.attribute6

637: ,p_attribute2_o => ghr_cmp_shd.g_old_rec.attribute2
638: ,p_attribute3_o => ghr_cmp_shd.g_old_rec.attribute3
639: ,p_attribute4_o => ghr_cmp_shd.g_old_rec.attribute4
640: ,p_attribute5_o => ghr_cmp_shd.g_old_rec.attribute5
641: ,p_attribute6_o => ghr_cmp_shd.g_old_rec.attribute6
642: ,p_attribute7_o => ghr_cmp_shd.g_old_rec.attribute7
643: ,p_attribute8_o => ghr_cmp_shd.g_old_rec.attribute8
644: ,p_attribute9_o => ghr_cmp_shd.g_old_rec.attribute9
645: ,p_attribute10_o => ghr_cmp_shd.g_old_rec.attribute10

Line 642: ,p_attribute7_o => ghr_cmp_shd.g_old_rec.attribute7

638: ,p_attribute3_o => ghr_cmp_shd.g_old_rec.attribute3
639: ,p_attribute4_o => ghr_cmp_shd.g_old_rec.attribute4
640: ,p_attribute5_o => ghr_cmp_shd.g_old_rec.attribute5
641: ,p_attribute6_o => ghr_cmp_shd.g_old_rec.attribute6
642: ,p_attribute7_o => ghr_cmp_shd.g_old_rec.attribute7
643: ,p_attribute8_o => ghr_cmp_shd.g_old_rec.attribute8
644: ,p_attribute9_o => ghr_cmp_shd.g_old_rec.attribute9
645: ,p_attribute10_o => ghr_cmp_shd.g_old_rec.attribute10
646: ,p_attribute11_o => ghr_cmp_shd.g_old_rec.attribute11

Line 643: ,p_attribute8_o => ghr_cmp_shd.g_old_rec.attribute8

639: ,p_attribute4_o => ghr_cmp_shd.g_old_rec.attribute4
640: ,p_attribute5_o => ghr_cmp_shd.g_old_rec.attribute5
641: ,p_attribute6_o => ghr_cmp_shd.g_old_rec.attribute6
642: ,p_attribute7_o => ghr_cmp_shd.g_old_rec.attribute7
643: ,p_attribute8_o => ghr_cmp_shd.g_old_rec.attribute8
644: ,p_attribute9_o => ghr_cmp_shd.g_old_rec.attribute9
645: ,p_attribute10_o => ghr_cmp_shd.g_old_rec.attribute10
646: ,p_attribute11_o => ghr_cmp_shd.g_old_rec.attribute11
647: ,p_attribute12_o => ghr_cmp_shd.g_old_rec.attribute12

Line 644: ,p_attribute9_o => ghr_cmp_shd.g_old_rec.attribute9

640: ,p_attribute5_o => ghr_cmp_shd.g_old_rec.attribute5
641: ,p_attribute6_o => ghr_cmp_shd.g_old_rec.attribute6
642: ,p_attribute7_o => ghr_cmp_shd.g_old_rec.attribute7
643: ,p_attribute8_o => ghr_cmp_shd.g_old_rec.attribute8
644: ,p_attribute9_o => ghr_cmp_shd.g_old_rec.attribute9
645: ,p_attribute10_o => ghr_cmp_shd.g_old_rec.attribute10
646: ,p_attribute11_o => ghr_cmp_shd.g_old_rec.attribute11
647: ,p_attribute12_o => ghr_cmp_shd.g_old_rec.attribute12
648: ,p_attribute13_o => ghr_cmp_shd.g_old_rec.attribute13

Line 645: ,p_attribute10_o => ghr_cmp_shd.g_old_rec.attribute10

641: ,p_attribute6_o => ghr_cmp_shd.g_old_rec.attribute6
642: ,p_attribute7_o => ghr_cmp_shd.g_old_rec.attribute7
643: ,p_attribute8_o => ghr_cmp_shd.g_old_rec.attribute8
644: ,p_attribute9_o => ghr_cmp_shd.g_old_rec.attribute9
645: ,p_attribute10_o => ghr_cmp_shd.g_old_rec.attribute10
646: ,p_attribute11_o => ghr_cmp_shd.g_old_rec.attribute11
647: ,p_attribute12_o => ghr_cmp_shd.g_old_rec.attribute12
648: ,p_attribute13_o => ghr_cmp_shd.g_old_rec.attribute13
649: ,p_attribute14_o => ghr_cmp_shd.g_old_rec.attribute14

Line 646: ,p_attribute11_o => ghr_cmp_shd.g_old_rec.attribute11

642: ,p_attribute7_o => ghr_cmp_shd.g_old_rec.attribute7
643: ,p_attribute8_o => ghr_cmp_shd.g_old_rec.attribute8
644: ,p_attribute9_o => ghr_cmp_shd.g_old_rec.attribute9
645: ,p_attribute10_o => ghr_cmp_shd.g_old_rec.attribute10
646: ,p_attribute11_o => ghr_cmp_shd.g_old_rec.attribute11
647: ,p_attribute12_o => ghr_cmp_shd.g_old_rec.attribute12
648: ,p_attribute13_o => ghr_cmp_shd.g_old_rec.attribute13
649: ,p_attribute14_o => ghr_cmp_shd.g_old_rec.attribute14
650: ,p_attribute15_o => ghr_cmp_shd.g_old_rec.attribute15

Line 647: ,p_attribute12_o => ghr_cmp_shd.g_old_rec.attribute12

643: ,p_attribute8_o => ghr_cmp_shd.g_old_rec.attribute8
644: ,p_attribute9_o => ghr_cmp_shd.g_old_rec.attribute9
645: ,p_attribute10_o => ghr_cmp_shd.g_old_rec.attribute10
646: ,p_attribute11_o => ghr_cmp_shd.g_old_rec.attribute11
647: ,p_attribute12_o => ghr_cmp_shd.g_old_rec.attribute12
648: ,p_attribute13_o => ghr_cmp_shd.g_old_rec.attribute13
649: ,p_attribute14_o => ghr_cmp_shd.g_old_rec.attribute14
650: ,p_attribute15_o => ghr_cmp_shd.g_old_rec.attribute15
651: ,p_attribute16_o => ghr_cmp_shd.g_old_rec.attribute16

Line 648: ,p_attribute13_o => ghr_cmp_shd.g_old_rec.attribute13

644: ,p_attribute9_o => ghr_cmp_shd.g_old_rec.attribute9
645: ,p_attribute10_o => ghr_cmp_shd.g_old_rec.attribute10
646: ,p_attribute11_o => ghr_cmp_shd.g_old_rec.attribute11
647: ,p_attribute12_o => ghr_cmp_shd.g_old_rec.attribute12
648: ,p_attribute13_o => ghr_cmp_shd.g_old_rec.attribute13
649: ,p_attribute14_o => ghr_cmp_shd.g_old_rec.attribute14
650: ,p_attribute15_o => ghr_cmp_shd.g_old_rec.attribute15
651: ,p_attribute16_o => ghr_cmp_shd.g_old_rec.attribute16
652: ,p_attribute17_o => ghr_cmp_shd.g_old_rec.attribute17

Line 649: ,p_attribute14_o => ghr_cmp_shd.g_old_rec.attribute14

645: ,p_attribute10_o => ghr_cmp_shd.g_old_rec.attribute10
646: ,p_attribute11_o => ghr_cmp_shd.g_old_rec.attribute11
647: ,p_attribute12_o => ghr_cmp_shd.g_old_rec.attribute12
648: ,p_attribute13_o => ghr_cmp_shd.g_old_rec.attribute13
649: ,p_attribute14_o => ghr_cmp_shd.g_old_rec.attribute14
650: ,p_attribute15_o => ghr_cmp_shd.g_old_rec.attribute15
651: ,p_attribute16_o => ghr_cmp_shd.g_old_rec.attribute16
652: ,p_attribute17_o => ghr_cmp_shd.g_old_rec.attribute17
653: ,p_attribute18_o => ghr_cmp_shd.g_old_rec.attribute18

Line 650: ,p_attribute15_o => ghr_cmp_shd.g_old_rec.attribute15

646: ,p_attribute11_o => ghr_cmp_shd.g_old_rec.attribute11
647: ,p_attribute12_o => ghr_cmp_shd.g_old_rec.attribute12
648: ,p_attribute13_o => ghr_cmp_shd.g_old_rec.attribute13
649: ,p_attribute14_o => ghr_cmp_shd.g_old_rec.attribute14
650: ,p_attribute15_o => ghr_cmp_shd.g_old_rec.attribute15
651: ,p_attribute16_o => ghr_cmp_shd.g_old_rec.attribute16
652: ,p_attribute17_o => ghr_cmp_shd.g_old_rec.attribute17
653: ,p_attribute18_o => ghr_cmp_shd.g_old_rec.attribute18
654: ,p_attribute19_o => ghr_cmp_shd.g_old_rec.attribute19

Line 651: ,p_attribute16_o => ghr_cmp_shd.g_old_rec.attribute16

647: ,p_attribute12_o => ghr_cmp_shd.g_old_rec.attribute12
648: ,p_attribute13_o => ghr_cmp_shd.g_old_rec.attribute13
649: ,p_attribute14_o => ghr_cmp_shd.g_old_rec.attribute14
650: ,p_attribute15_o => ghr_cmp_shd.g_old_rec.attribute15
651: ,p_attribute16_o => ghr_cmp_shd.g_old_rec.attribute16
652: ,p_attribute17_o => ghr_cmp_shd.g_old_rec.attribute17
653: ,p_attribute18_o => ghr_cmp_shd.g_old_rec.attribute18
654: ,p_attribute19_o => ghr_cmp_shd.g_old_rec.attribute19
655: ,p_attribute20_o => ghr_cmp_shd.g_old_rec.attribute20

Line 652: ,p_attribute17_o => ghr_cmp_shd.g_old_rec.attribute17

648: ,p_attribute13_o => ghr_cmp_shd.g_old_rec.attribute13
649: ,p_attribute14_o => ghr_cmp_shd.g_old_rec.attribute14
650: ,p_attribute15_o => ghr_cmp_shd.g_old_rec.attribute15
651: ,p_attribute16_o => ghr_cmp_shd.g_old_rec.attribute16
652: ,p_attribute17_o => ghr_cmp_shd.g_old_rec.attribute17
653: ,p_attribute18_o => ghr_cmp_shd.g_old_rec.attribute18
654: ,p_attribute19_o => ghr_cmp_shd.g_old_rec.attribute19
655: ,p_attribute20_o => ghr_cmp_shd.g_old_rec.attribute20
656: ,p_attribute21_o => ghr_cmp_shd.g_old_rec.attribute21

Line 653: ,p_attribute18_o => ghr_cmp_shd.g_old_rec.attribute18

649: ,p_attribute14_o => ghr_cmp_shd.g_old_rec.attribute14
650: ,p_attribute15_o => ghr_cmp_shd.g_old_rec.attribute15
651: ,p_attribute16_o => ghr_cmp_shd.g_old_rec.attribute16
652: ,p_attribute17_o => ghr_cmp_shd.g_old_rec.attribute17
653: ,p_attribute18_o => ghr_cmp_shd.g_old_rec.attribute18
654: ,p_attribute19_o => ghr_cmp_shd.g_old_rec.attribute19
655: ,p_attribute20_o => ghr_cmp_shd.g_old_rec.attribute20
656: ,p_attribute21_o => ghr_cmp_shd.g_old_rec.attribute21
657: ,p_attribute22_o => ghr_cmp_shd.g_old_rec.attribute22

Line 654: ,p_attribute19_o => ghr_cmp_shd.g_old_rec.attribute19

650: ,p_attribute15_o => ghr_cmp_shd.g_old_rec.attribute15
651: ,p_attribute16_o => ghr_cmp_shd.g_old_rec.attribute16
652: ,p_attribute17_o => ghr_cmp_shd.g_old_rec.attribute17
653: ,p_attribute18_o => ghr_cmp_shd.g_old_rec.attribute18
654: ,p_attribute19_o => ghr_cmp_shd.g_old_rec.attribute19
655: ,p_attribute20_o => ghr_cmp_shd.g_old_rec.attribute20
656: ,p_attribute21_o => ghr_cmp_shd.g_old_rec.attribute21
657: ,p_attribute22_o => ghr_cmp_shd.g_old_rec.attribute22
658: ,p_attribute23_o => ghr_cmp_shd.g_old_rec.attribute23

Line 655: ,p_attribute20_o => ghr_cmp_shd.g_old_rec.attribute20

651: ,p_attribute16_o => ghr_cmp_shd.g_old_rec.attribute16
652: ,p_attribute17_o => ghr_cmp_shd.g_old_rec.attribute17
653: ,p_attribute18_o => ghr_cmp_shd.g_old_rec.attribute18
654: ,p_attribute19_o => ghr_cmp_shd.g_old_rec.attribute19
655: ,p_attribute20_o => ghr_cmp_shd.g_old_rec.attribute20
656: ,p_attribute21_o => ghr_cmp_shd.g_old_rec.attribute21
657: ,p_attribute22_o => ghr_cmp_shd.g_old_rec.attribute22
658: ,p_attribute23_o => ghr_cmp_shd.g_old_rec.attribute23
659: ,p_attribute24_o => ghr_cmp_shd.g_old_rec.attribute24

Line 656: ,p_attribute21_o => ghr_cmp_shd.g_old_rec.attribute21

652: ,p_attribute17_o => ghr_cmp_shd.g_old_rec.attribute17
653: ,p_attribute18_o => ghr_cmp_shd.g_old_rec.attribute18
654: ,p_attribute19_o => ghr_cmp_shd.g_old_rec.attribute19
655: ,p_attribute20_o => ghr_cmp_shd.g_old_rec.attribute20
656: ,p_attribute21_o => ghr_cmp_shd.g_old_rec.attribute21
657: ,p_attribute22_o => ghr_cmp_shd.g_old_rec.attribute22
658: ,p_attribute23_o => ghr_cmp_shd.g_old_rec.attribute23
659: ,p_attribute24_o => ghr_cmp_shd.g_old_rec.attribute24
660: ,p_attribute25_o => ghr_cmp_shd.g_old_rec.attribute25

Line 657: ,p_attribute22_o => ghr_cmp_shd.g_old_rec.attribute22

653: ,p_attribute18_o => ghr_cmp_shd.g_old_rec.attribute18
654: ,p_attribute19_o => ghr_cmp_shd.g_old_rec.attribute19
655: ,p_attribute20_o => ghr_cmp_shd.g_old_rec.attribute20
656: ,p_attribute21_o => ghr_cmp_shd.g_old_rec.attribute21
657: ,p_attribute22_o => ghr_cmp_shd.g_old_rec.attribute22
658: ,p_attribute23_o => ghr_cmp_shd.g_old_rec.attribute23
659: ,p_attribute24_o => ghr_cmp_shd.g_old_rec.attribute24
660: ,p_attribute25_o => ghr_cmp_shd.g_old_rec.attribute25
661: ,p_attribute26_o => ghr_cmp_shd.g_old_rec.attribute26

Line 658: ,p_attribute23_o => ghr_cmp_shd.g_old_rec.attribute23

654: ,p_attribute19_o => ghr_cmp_shd.g_old_rec.attribute19
655: ,p_attribute20_o => ghr_cmp_shd.g_old_rec.attribute20
656: ,p_attribute21_o => ghr_cmp_shd.g_old_rec.attribute21
657: ,p_attribute22_o => ghr_cmp_shd.g_old_rec.attribute22
658: ,p_attribute23_o => ghr_cmp_shd.g_old_rec.attribute23
659: ,p_attribute24_o => ghr_cmp_shd.g_old_rec.attribute24
660: ,p_attribute25_o => ghr_cmp_shd.g_old_rec.attribute25
661: ,p_attribute26_o => ghr_cmp_shd.g_old_rec.attribute26
662: ,p_attribute27_o => ghr_cmp_shd.g_old_rec.attribute27

Line 659: ,p_attribute24_o => ghr_cmp_shd.g_old_rec.attribute24

655: ,p_attribute20_o => ghr_cmp_shd.g_old_rec.attribute20
656: ,p_attribute21_o => ghr_cmp_shd.g_old_rec.attribute21
657: ,p_attribute22_o => ghr_cmp_shd.g_old_rec.attribute22
658: ,p_attribute23_o => ghr_cmp_shd.g_old_rec.attribute23
659: ,p_attribute24_o => ghr_cmp_shd.g_old_rec.attribute24
660: ,p_attribute25_o => ghr_cmp_shd.g_old_rec.attribute25
661: ,p_attribute26_o => ghr_cmp_shd.g_old_rec.attribute26
662: ,p_attribute27_o => ghr_cmp_shd.g_old_rec.attribute27
663: ,p_attribute28_o => ghr_cmp_shd.g_old_rec.attribute28

Line 660: ,p_attribute25_o => ghr_cmp_shd.g_old_rec.attribute25

656: ,p_attribute21_o => ghr_cmp_shd.g_old_rec.attribute21
657: ,p_attribute22_o => ghr_cmp_shd.g_old_rec.attribute22
658: ,p_attribute23_o => ghr_cmp_shd.g_old_rec.attribute23
659: ,p_attribute24_o => ghr_cmp_shd.g_old_rec.attribute24
660: ,p_attribute25_o => ghr_cmp_shd.g_old_rec.attribute25
661: ,p_attribute26_o => ghr_cmp_shd.g_old_rec.attribute26
662: ,p_attribute27_o => ghr_cmp_shd.g_old_rec.attribute27
663: ,p_attribute28_o => ghr_cmp_shd.g_old_rec.attribute28
664: ,p_attribute29_o => ghr_cmp_shd.g_old_rec.attribute29

Line 661: ,p_attribute26_o => ghr_cmp_shd.g_old_rec.attribute26

657: ,p_attribute22_o => ghr_cmp_shd.g_old_rec.attribute22
658: ,p_attribute23_o => ghr_cmp_shd.g_old_rec.attribute23
659: ,p_attribute24_o => ghr_cmp_shd.g_old_rec.attribute24
660: ,p_attribute25_o => ghr_cmp_shd.g_old_rec.attribute25
661: ,p_attribute26_o => ghr_cmp_shd.g_old_rec.attribute26
662: ,p_attribute27_o => ghr_cmp_shd.g_old_rec.attribute27
663: ,p_attribute28_o => ghr_cmp_shd.g_old_rec.attribute28
664: ,p_attribute29_o => ghr_cmp_shd.g_old_rec.attribute29
665: ,p_attribute30_o => ghr_cmp_shd.g_old_rec.attribute30

Line 662: ,p_attribute27_o => ghr_cmp_shd.g_old_rec.attribute27

658: ,p_attribute23_o => ghr_cmp_shd.g_old_rec.attribute23
659: ,p_attribute24_o => ghr_cmp_shd.g_old_rec.attribute24
660: ,p_attribute25_o => ghr_cmp_shd.g_old_rec.attribute25
661: ,p_attribute26_o => ghr_cmp_shd.g_old_rec.attribute26
662: ,p_attribute27_o => ghr_cmp_shd.g_old_rec.attribute27
663: ,p_attribute28_o => ghr_cmp_shd.g_old_rec.attribute28
664: ,p_attribute29_o => ghr_cmp_shd.g_old_rec.attribute29
665: ,p_attribute30_o => ghr_cmp_shd.g_old_rec.attribute30
666: );

Line 663: ,p_attribute28_o => ghr_cmp_shd.g_old_rec.attribute28

659: ,p_attribute24_o => ghr_cmp_shd.g_old_rec.attribute24
660: ,p_attribute25_o => ghr_cmp_shd.g_old_rec.attribute25
661: ,p_attribute26_o => ghr_cmp_shd.g_old_rec.attribute26
662: ,p_attribute27_o => ghr_cmp_shd.g_old_rec.attribute27
663: ,p_attribute28_o => ghr_cmp_shd.g_old_rec.attribute28
664: ,p_attribute29_o => ghr_cmp_shd.g_old_rec.attribute29
665: ,p_attribute30_o => ghr_cmp_shd.g_old_rec.attribute30
666: );
667: --

Line 664: ,p_attribute29_o => ghr_cmp_shd.g_old_rec.attribute29

660: ,p_attribute25_o => ghr_cmp_shd.g_old_rec.attribute25
661: ,p_attribute26_o => ghr_cmp_shd.g_old_rec.attribute26
662: ,p_attribute27_o => ghr_cmp_shd.g_old_rec.attribute27
663: ,p_attribute28_o => ghr_cmp_shd.g_old_rec.attribute28
664: ,p_attribute29_o => ghr_cmp_shd.g_old_rec.attribute29
665: ,p_attribute30_o => ghr_cmp_shd.g_old_rec.attribute30
666: );
667: --
668: exception

Line 665: ,p_attribute30_o => ghr_cmp_shd.g_old_rec.attribute30

661: ,p_attribute26_o => ghr_cmp_shd.g_old_rec.attribute26
662: ,p_attribute27_o => ghr_cmp_shd.g_old_rec.attribute27
663: ,p_attribute28_o => ghr_cmp_shd.g_old_rec.attribute28
664: ,p_attribute29_o => ghr_cmp_shd.g_old_rec.attribute29
665: ,p_attribute30_o => ghr_cmp_shd.g_old_rec.attribute30
666: );
667: --
668: exception
669: --

Line 727: (p_rec in out nocopy ghr_cmp_shd.g_rec_type

723: --
724: -- {End Of Comments}
725: -- ----------------------------------------------------------------------------
726: Procedure convert_defs
727: (p_rec in out nocopy ghr_cmp_shd.g_rec_type
728: ) is
729: --
730: Begin
731: --

Line 739: ghr_cmp_shd.g_old_rec.complainant_person_id;

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
742: p_rec.business_group_id :=
743: ghr_cmp_shd.g_old_rec.business_group_id;

Line 743: ghr_cmp_shd.g_old_rec.business_group_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
746: p_rec.docket_number :=
747: ghr_cmp_shd.g_old_rec.docket_number;

Line 747: ghr_cmp_shd.g_old_rec.docket_number;

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
750: p_rec.stage :=
751: ghr_cmp_shd.g_old_rec.stage;

Line 751: ghr_cmp_shd.g_old_rec.stage;

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
754: p_rec.class_flag :=
755: ghr_cmp_shd.g_old_rec.class_flag;

Line 755: ghr_cmp_shd.g_old_rec.class_flag;

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
758: p_rec.mixed_flag :=
759: ghr_cmp_shd.g_old_rec.mixed_flag;

Line 759: ghr_cmp_shd.g_old_rec.mixed_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
762: p_rec.consolidated_flag :=
763: ghr_cmp_shd.g_old_rec.consolidated_flag;

Line 763: ghr_cmp_shd.g_old_rec.consolidated_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
766: p_rec.remand_flag :=
767: ghr_cmp_shd.g_old_rec.remand_flag;

Line 767: ghr_cmp_shd.g_old_rec.remand_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
770: p_rec.active_flag :=
771: ghr_cmp_shd.g_old_rec.active_flag;

Line 771: ghr_cmp_shd.g_old_rec.active_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
774: p_rec.information_inquiry :=
775: ghr_cmp_shd.g_old_rec.information_inquiry;

Line 775: ghr_cmp_shd.g_old_rec.information_inquiry;

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
778: p_rec.pcom_init :=
779: ghr_cmp_shd.g_old_rec.pcom_init;

Line 779: ghr_cmp_shd.g_old_rec.pcom_init;

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
782: p_rec.alleg_incident :=
783: ghr_cmp_shd.g_old_rec.alleg_incident;

Line 783: ghr_cmp_shd.g_old_rec.alleg_incident;

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
786: p_rec.alleg_discrim_org_id :=
787: ghr_cmp_shd.g_old_rec.alleg_discrim_org_id;

Line 787: ghr_cmp_shd.g_old_rec.alleg_discrim_org_id;

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
790: p_rec.rr_ltr_date :=
791: ghr_cmp_shd.g_old_rec.rr_ltr_date;

Line 791: ghr_cmp_shd.g_old_rec.rr_ltr_date;

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
794: p_rec.rr_ltr_recvd :=
795: ghr_cmp_shd.g_old_rec.rr_ltr_recvd;

Line 795: ghr_cmp_shd.g_old_rec.rr_ltr_recvd;

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
798: p_rec.pre_com_elec :=
799: ghr_cmp_shd.g_old_rec.pre_com_elec;

Line 799: ghr_cmp_shd.g_old_rec.pre_com_elec;

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: /*
802: If (p_rec.adr_offered = hr_api.g_varchar2) then
803: p_rec.adr_offered :=

Line 804: ghr_cmp_shd.g_old_rec.adr_offered;

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: */
807: If (p_rec.class_agent_flag = hr_api.g_varchar2) then
808: p_rec.class_agent_flag :=

Line 809: ghr_cmp_shd.g_old_rec.class_agent_flag;

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
812: p_rec.pre_com_desc :=
813: ghr_cmp_shd.g_old_rec.pre_com_desc;

Line 813: ghr_cmp_shd.g_old_rec.pre_com_desc;

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
816: p_rec.counselor_asg :=
817: ghr_cmp_shd.g_old_rec.counselor_asg;

Line 817: ghr_cmp_shd.g_old_rec.counselor_asg;

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
820: p_rec.init_counselor_interview :=
821: ghr_cmp_shd.g_old_rec.init_counselor_interview;

Line 821: ghr_cmp_shd.g_old_rec.init_counselor_interview;

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
824: p_rec.anonymity_requested :=
825: ghr_cmp_shd.g_old_rec.anonymity_requested;

Line 825: ghr_cmp_shd.g_old_rec.anonymity_requested;

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
828: p_rec.counsel_ext_ltr :=
829: ghr_cmp_shd.g_old_rec.counsel_ext_ltr;

Line 829: ghr_cmp_shd.g_old_rec.counsel_ext_ltr;

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
832: p_rec.traditional_counsel_outcome :=
833: ghr_cmp_shd.g_old_rec.traditional_counsel_outcome;

Line 833: ghr_cmp_shd.g_old_rec.traditional_counsel_outcome;

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
836: p_rec.final_interview :=
837: ghr_cmp_shd.g_old_rec.final_interview;

Line 837: ghr_cmp_shd.g_old_rec.final_interview;

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
840: p_rec.notice_rtf_recvd :=
841: ghr_cmp_shd.g_old_rec.notice_rtf_recvd;

Line 841: ghr_cmp_shd.g_old_rec.notice_rtf_recvd;

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
844: p_rec.precom_closed :=
845: ghr_cmp_shd.g_old_rec.precom_closed;

Line 845: ghr_cmp_shd.g_old_rec.precom_closed;

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
848: p_rec.precom_closure_nature :=
849: ghr_cmp_shd.g_old_rec.precom_closure_nature;

Line 849: ghr_cmp_shd.g_old_rec.precom_closure_nature;

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
852: p_rec.counselor_rpt_sub :=
853: ghr_cmp_shd.g_old_rec.counselor_rpt_sub;

Line 853: ghr_cmp_shd.g_old_rec.counselor_rpt_sub;

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
856: p_rec.hr_office_org_id :=
857: ghr_cmp_shd.g_old_rec.hr_office_org_id;

Line 857: ghr_cmp_shd.g_old_rec.hr_office_org_id;

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
860: p_rec.eeo_office_org_id :=
861: ghr_cmp_shd.g_old_rec.eeo_office_org_id;

Line 861: ghr_cmp_shd.g_old_rec.eeo_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
864: p_rec.serviced_org_id :=
865: ghr_cmp_shd.g_old_rec.serviced_org_id;

Line 865: ghr_cmp_shd.g_old_rec.serviced_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
868: p_rec.formal_com_filed :=
869: ghr_cmp_shd.g_old_rec.formal_com_filed;

Line 869: ghr_cmp_shd.g_old_rec.formal_com_filed;

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
872: p_rec.ack_ltr :=
873: ghr_cmp_shd.g_old_rec.ack_ltr;

Line 873: ghr_cmp_shd.g_old_rec.ack_ltr;

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
876: p_rec.clarification_ltr_date :=
877: ghr_cmp_shd.g_old_rec.clarification_ltr_date;

Line 877: ghr_cmp_shd.g_old_rec.clarification_ltr_date;

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
880: p_rec.clarification_response_recvd :=
881: ghr_cmp_shd.g_old_rec.clarification_response_recvd;

Line 881: ghr_cmp_shd.g_old_rec.clarification_response_recvd;

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
884: p_rec.forwarded_legal_review :=
885: ghr_cmp_shd.g_old_rec.forwarded_legal_review;

Line 885: ghr_cmp_shd.g_old_rec.forwarded_legal_review;

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
888: p_rec.returned_from_legal :=
889: ghr_cmp_shd.g_old_rec.returned_from_legal;

Line 889: ghr_cmp_shd.g_old_rec.returned_from_legal;

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
892: p_rec.letter_type :=
893: ghr_cmp_shd.g_old_rec.letter_type;

Line 893: ghr_cmp_shd.g_old_rec.letter_type;

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
896: p_rec.letter_date :=
897: ghr_cmp_shd.g_old_rec.letter_date;

Line 897: ghr_cmp_shd.g_old_rec.letter_date;

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
900: p_rec.letter_recvd :=
901: ghr_cmp_shd.g_old_rec.letter_recvd;

Line 901: ghr_cmp_shd.g_old_rec.letter_recvd;

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
904: p_rec.investigation_source :=
905: ghr_cmp_shd.g_old_rec.investigation_source;

Line 905: ghr_cmp_shd.g_old_rec.investigation_source;

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
908: p_rec.investigator_recvd_req :=
909: ghr_cmp_shd.g_old_rec.investigator_recvd_req;

Line 909: ghr_cmp_shd.g_old_rec.investigator_recvd_req;

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
912: p_rec.agency_investigator_req :=
913: ghr_cmp_shd.g_old_rec.agency_investigator_req;

Line 913: ghr_cmp_shd.g_old_rec.agency_investigator_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
916: p_rec.investigator_asg :=
917: ghr_cmp_shd.g_old_rec.investigator_asg;

Line 917: ghr_cmp_shd.g_old_rec.investigator_asg;

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
920: p_rec.investigation_start :=
921: ghr_cmp_shd.g_old_rec.investigation_start;

Line 921: ghr_cmp_shd.g_old_rec.investigation_start;

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
924: p_rec.investigation_end :=
925: ghr_cmp_shd.g_old_rec.investigation_end;

Line 925: ghr_cmp_shd.g_old_rec.investigation_end;

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
928: p_rec.investigation_extended :=
929: ghr_cmp_shd.g_old_rec.investigation_extended;

Line 929: ghr_cmp_shd.g_old_rec.investigation_extended;

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
932: p_rec.invest_extension_desc :=
933: ghr_cmp_shd.g_old_rec.invest_extension_desc;

Line 933: ghr_cmp_shd.g_old_rec.invest_extension_desc;

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
936: p_rec.agency_recvd_roi :=
937: ghr_cmp_shd.g_old_rec.agency_recvd_roi;

Line 937: ghr_cmp_shd.g_old_rec.agency_recvd_roi;

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
940: p_rec.comrep_recvd_roi :=
941: ghr_cmp_shd.g_old_rec.comrep_recvd_roi;

Line 941: ghr_cmp_shd.g_old_rec.comrep_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
944: p_rec.options_ltr_date :=
945: ghr_cmp_shd.g_old_rec.options_ltr_date;

Line 945: ghr_cmp_shd.g_old_rec.options_ltr_date;

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
948: p_rec.comrep_recvd_opt_ltr :=
949: ghr_cmp_shd.g_old_rec.comrep_recvd_opt_ltr;

Line 949: ghr_cmp_shd.g_old_rec.comrep_recvd_opt_ltr;

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
952: p_rec.comrep_opt_ltr_response :=
953: ghr_cmp_shd.g_old_rec.comrep_opt_ltr_response;

Line 953: ghr_cmp_shd.g_old_rec.comrep_opt_ltr_response;

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
956: p_rec.resolution_offer :=
957: ghr_cmp_shd.g_old_rec.resolution_offer;

Line 957: ghr_cmp_shd.g_old_rec.resolution_offer;

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
960: p_rec.comrep_resol_offer_recvd :=
961: ghr_cmp_shd.g_old_rec.comrep_resol_offer_recvd;

Line 961: ghr_cmp_shd.g_old_rec.comrep_resol_offer_recvd;

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
964: p_rec.comrep_resol_offer_response :=
965: ghr_cmp_shd.g_old_rec.comrep_resol_offer_response;

Line 965: ghr_cmp_shd.g_old_rec.comrep_resol_offer_response;

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
968: p_rec.comrep_resol_offer_desc :=
969: ghr_cmp_shd.g_old_rec.comrep_resol_offer_desc;

Line 969: ghr_cmp_shd.g_old_rec.comrep_resol_offer_desc;

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
972: p_rec.resol_offer_signed :=
973: ghr_cmp_shd.g_old_rec.resol_offer_signed;

Line 973: ghr_cmp_shd.g_old_rec.resol_offer_signed;

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
976: p_rec.resol_offer_desc :=
977: ghr_cmp_shd.g_old_rec.resol_offer_desc;

Line 977: ghr_cmp_shd.g_old_rec.resol_offer_desc;

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
980: p_rec.hearing_source :=
981: ghr_cmp_shd.g_old_rec.hearing_source;

Line 981: ghr_cmp_shd.g_old_rec.hearing_source;

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
984: p_rec.agency_notified_hearing :=
985: ghr_cmp_shd.g_old_rec.agency_notified_hearing;

Line 985: ghr_cmp_shd.g_old_rec.agency_notified_hearing;

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
988: p_rec.eeoc_hearing_docket_num :=
989: ghr_cmp_shd.g_old_rec.eeoc_hearing_docket_num;

Line 989: ghr_cmp_shd.g_old_rec.eeoc_hearing_docket_num;

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
992: p_rec.hearing_complete :=
993: ghr_cmp_shd.g_old_rec.hearing_complete;

Line 993: ghr_cmp_shd.g_old_rec.hearing_complete;

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
996: p_rec.aj_merit_decision_date :=
997: ghr_cmp_shd.g_old_rec.aj_merit_decision_date;

Line 997: ghr_cmp_shd.g_old_rec.aj_merit_decision_date;

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
1000: p_rec.agency_recvd_aj_merit_dec :=
1001: ghr_cmp_shd.g_old_rec.agency_recvd_aj_merit_dec;

Line 1001: ghr_cmp_shd.g_old_rec.agency_recvd_aj_merit_dec;

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
1004: p_rec.aj_merit_decision :=
1005: ghr_cmp_shd.g_old_rec.aj_merit_decision;

Line 1005: ghr_cmp_shd.g_old_rec.aj_merit_decision;

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
1008: p_rec.aj_ca_decision_date :=
1009: ghr_cmp_shd.g_old_rec.aj_ca_decision_date;

Line 1009: ghr_cmp_shd.g_old_rec.aj_ca_decision_date;

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
1012: p_rec.agency_recvd_aj_ca_dec :=
1013: ghr_cmp_shd.g_old_rec.agency_recvd_aj_ca_dec;

Line 1013: ghr_cmp_shd.g_old_rec.agency_recvd_aj_ca_dec;

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
1016: p_rec.aj_ca_decision :=
1017: ghr_cmp_shd.g_old_rec.aj_ca_decision;

Line 1017: ghr_cmp_shd.g_old_rec.aj_ca_decision;

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
1020: p_rec.fad_requested :=
1021: ghr_cmp_shd.g_old_rec.fad_requested;

Line 1021: ghr_cmp_shd.g_old_rec.fad_requested;

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
1024: p_rec.merit_fad :=
1025: ghr_cmp_shd.g_old_rec.merit_fad;

Line 1025: ghr_cmp_shd.g_old_rec.merit_fad;

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
1028: p_rec.attorney_fees_fad :=
1029: ghr_cmp_shd.g_old_rec.attorney_fees_fad;

Line 1029: ghr_cmp_shd.g_old_rec.attorney_fees_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
1032: p_rec.comp_damages_fad :=
1033: ghr_cmp_shd.g_old_rec.comp_damages_fad;

Line 1033: ghr_cmp_shd.g_old_rec.comp_damages_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
1036: p_rec.non_compliance_fad :=
1037: ghr_cmp_shd.g_old_rec.non_compliance_fad;

Line 1037: ghr_cmp_shd.g_old_rec.non_compliance_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
1040: p_rec.fad_req_recvd_eeo_office :=
1041: ghr_cmp_shd.g_old_rec.fad_req_recvd_eeo_office;

Line 1041: ghr_cmp_shd.g_old_rec.fad_req_recvd_eeo_office;

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
1044: p_rec.fad_req_forwd_to_agency :=
1045: ghr_cmp_shd.g_old_rec.fad_req_forwd_to_agency;

Line 1045: ghr_cmp_shd.g_old_rec.fad_req_forwd_to_agency;

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
1048: p_rec.agency_recvd_request :=
1049: ghr_cmp_shd.g_old_rec.agency_recvd_request;

Line 1049: ghr_cmp_shd.g_old_rec.agency_recvd_request;

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
1052: p_rec.fad_due :=
1053: ghr_cmp_shd.g_old_rec.fad_due;

Line 1053: ghr_cmp_shd.g_old_rec.fad_due;

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
1056: p_rec.fad_date :=
1057: ghr_cmp_shd.g_old_rec.fad_date;

Line 1057: ghr_cmp_shd.g_old_rec.fad_date;

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
1060: p_rec.fad_decision :=
1061: ghr_cmp_shd.g_old_rec.fad_decision;

Line 1061: ghr_cmp_shd.g_old_rec.fad_decision;

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: /*
1064: If (p_rec.fad_final_action_closure = hr_api.g_varchar2) then
1065: p_rec.fad_final_action_closure :=

Line 1066: ghr_cmp_shd.g_old_rec.fad_final_action_closure;

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: */
1069: If (p_rec.fad_forwd_to_comrep = hr_api.g_date) then
1070: p_rec.fad_forwd_to_comrep :=

Line 1071: ghr_cmp_shd.g_old_rec.fad_forwd_to_comrep;

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
1074: p_rec.fad_recvd_by_comrep :=
1075: ghr_cmp_shd.g_old_rec.fad_recvd_by_comrep;

Line 1075: ghr_cmp_shd.g_old_rec.fad_recvd_by_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
1078: p_rec.fad_imp_ltr_forwd_to_org :=
1079: ghr_cmp_shd.g_old_rec.fad_imp_ltr_forwd_to_org;

Line 1079: ghr_cmp_shd.g_old_rec.fad_imp_ltr_forwd_to_org;

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
1082: p_rec.fad_decision_forwd_legal :=
1083: ghr_cmp_shd.g_old_rec.fad_decision_forwd_legal;

Line 1083: ghr_cmp_shd.g_old_rec.fad_decision_forwd_legal;

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
1086: p_rec.fad_decision_recvd_legal :=
1087: ghr_cmp_shd.g_old_rec.fad_decision_recvd_legal;

Line 1087: ghr_cmp_shd.g_old_rec.fad_decision_recvd_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
1090: p_rec.fa_source :=
1091: ghr_cmp_shd.g_old_rec.fa_source;

Line 1091: ghr_cmp_shd.g_old_rec.fa_source;

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
1094: p_rec.final_action_due :=
1095: ghr_cmp_shd.g_old_rec.final_action_due;

Line 1095: ghr_cmp_shd.g_old_rec.final_action_due;

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: /*
1098: If (p_rec.final_action_nature_of_closure = hr_api.g_varchar2) then
1099: p_rec.final_action_nature_of_closure :=

Line 1100: ghr_cmp_shd.g_old_rec.final_action_nature_of_closure;

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: */
1103: If (p_rec.final_act_forwd_comrep = hr_api.g_date) then
1104: p_rec.final_act_forwd_comrep :=

Line 1105: ghr_cmp_shd.g_old_rec.final_act_forwd_comrep;

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
1108: p_rec.final_act_recvd_comrep :=
1109: ghr_cmp_shd.g_old_rec.final_act_recvd_comrep;

Line 1109: ghr_cmp_shd.g_old_rec.final_act_recvd_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
1112: p_rec.final_action_decision_date :=
1113: ghr_cmp_shd.g_old_rec.final_action_decision_date;

Line 1113: ghr_cmp_shd.g_old_rec.final_action_decision_date;

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
1116: p_rec.final_action_decision :=
1117: ghr_cmp_shd.g_old_rec.final_action_decision;

Line 1117: ghr_cmp_shd.g_old_rec.final_action_decision;

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
1120: p_rec.fa_imp_ltr_forwd_to_org :=
1121: ghr_cmp_shd.g_old_rec.fa_imp_ltr_forwd_to_org;

Line 1121: ghr_cmp_shd.g_old_rec.fa_imp_ltr_forwd_to_org;

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
1124: p_rec.fa_decision_forwd_legal :=
1125: ghr_cmp_shd.g_old_rec.fa_decision_forwd_legal;

Line 1125: ghr_cmp_shd.g_old_rec.fa_decision_forwd_legal;

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
1128: p_rec.fa_decision_recvd_legal :=
1129: ghr_cmp_shd.g_old_rec.fa_decision_recvd_legal;

Line 1129: ghr_cmp_shd.g_old_rec.fa_decision_recvd_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
1132: p_rec.civil_action_filed :=
1133: ghr_cmp_shd.g_old_rec.civil_action_filed;

Line 1133: ghr_cmp_shd.g_old_rec.civil_action_filed;

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
1136: p_rec.agency_closure_confirmed :=
1137: ghr_cmp_shd.g_old_rec.agency_closure_confirmed;

Line 1137: ghr_cmp_shd.g_old_rec.agency_closure_confirmed;

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
1140: p_rec.consolidated_complaint_id :=
1141: ghr_cmp_shd.g_old_rec.consolidated_complaint_id;

Line 1141: ghr_cmp_shd.g_old_rec.consolidated_complaint_id;

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
1144: p_rec.consolidated :=
1145: ghr_cmp_shd.g_old_rec.consolidated;

Line 1145: ghr_cmp_shd.g_old_rec.consolidated;

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
1148: p_rec.stage_of_consolidation :=
1149: ghr_cmp_shd.g_old_rec.stage_of_consolidation;

Line 1149: ghr_cmp_shd.g_old_rec.stage_of_consolidation;

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
1152: p_rec.comrep_notif_consolidation :=
1153: ghr_cmp_shd.g_old_rec.comrep_notif_consolidation;

Line 1153: ghr_cmp_shd.g_old_rec.comrep_notif_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
1156: p_rec.consolidation_desc :=
1157: ghr_cmp_shd.g_old_rec.consolidation_desc;

Line 1157: ghr_cmp_shd.g_old_rec.consolidation_desc;

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
1160: p_rec.complaint_closed :=
1161: ghr_cmp_shd.g_old_rec.complaint_closed;

Line 1161: ghr_cmp_shd.g_old_rec.complaint_closed;

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
1164: p_rec.nature_of_closure :=
1165: ghr_cmp_shd.g_old_rec.nature_of_closure;

Line 1165: ghr_cmp_shd.g_old_rec.nature_of_closure;

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
1168: p_rec.complaint_closed_desc :=
1169: ghr_cmp_shd.g_old_rec.complaint_closed_desc;

Line 1169: ghr_cmp_shd.g_old_rec.complaint_closed_desc;

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
1172: p_rec.filed_formal_class :=
1173: ghr_cmp_shd.g_old_rec.filed_formal_class;

Line 1173: ghr_cmp_shd.g_old_rec.filed_formal_class;

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
1176: p_rec.forwd_eeoc :=
1177: ghr_cmp_shd.g_old_rec.forwd_eeoc;

Line 1177: ghr_cmp_shd.g_old_rec.forwd_eeoc;

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
1180: p_rec.aj_cert_decision_date :=
1181: ghr_cmp_shd.g_old_rec.aj_cert_decision_date;

Line 1181: ghr_cmp_shd.g_old_rec.aj_cert_decision_date;

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
1184: p_rec.aj_cert_decision_recvd :=
1185: ghr_cmp_shd.g_old_rec.aj_cert_decision_recvd;

Line 1185: ghr_cmp_shd.g_old_rec.aj_cert_decision_recvd;

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
1188: p_rec.aj_cert_decision :=
1189: ghr_cmp_shd.g_old_rec.aj_cert_decision;

Line 1189: ghr_cmp_shd.g_old_rec.aj_cert_decision;

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
1192: p_rec.class_members_notified :=
1193: ghr_cmp_shd.g_old_rec.class_members_notified;

Line 1193: ghr_cmp_shd.g_old_rec.class_members_notified;

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
1196: p_rec.number_of_complaintants :=
1197: ghr_cmp_shd.g_old_rec.number_of_complaintants;

Line 1197: ghr_cmp_shd.g_old_rec.number_of_complaintants;

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
1200: p_rec.class_hearing :=
1201: ghr_cmp_shd.g_old_rec.class_hearing;

Line 1201: ghr_cmp_shd.g_old_rec.class_hearing;

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
1204: p_rec.aj_dec :=
1205: ghr_cmp_shd.g_old_rec.aj_dec;

Line 1205: ghr_cmp_shd.g_old_rec.aj_dec;

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
1208: p_rec.agency_recvd_aj_dec :=
1209: ghr_cmp_shd.g_old_rec.agency_recvd_aj_dec;

Line 1209: ghr_cmp_shd.g_old_rec.agency_recvd_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
1212: p_rec.aj_decision :=
1213: ghr_cmp_shd.g_old_rec.aj_decision;

Line 1213: ghr_cmp_shd.g_old_rec.aj_decision;

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
1216: p_rec.agency_brief_eeoc :=
1217: ghr_cmp_shd.g_old_rec.agency_brief_eeoc;

Line 1217: ghr_cmp_shd.g_old_rec.agency_brief_eeoc;

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
1220: p_rec.agency_notif_of_civil_action :=
1221: ghr_cmp_shd.g_old_rec.agency_notif_of_civil_action;

Line 1221: ghr_cmp_shd.g_old_rec.agency_notif_of_civil_action;

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
1224: p_rec.fad_source :=
1225: ghr_cmp_shd.g_old_rec.fad_source;

Line 1225: ghr_cmp_shd.g_old_rec.fad_source;

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
1228: p_rec.agency_files_forwarded_eeoc :=
1229: ghr_cmp_shd.g_old_rec.agency_files_forwarded_eeoc;

Line 1229: ghr_cmp_shd.g_old_rec.agency_files_forwarded_eeoc;

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
1232: p_rec.hearing_req :=
1233: ghr_cmp_shd.g_old_rec.hearing_req;

Line 1233: ghr_cmp_shd.g_old_rec.hearing_req;

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
1236: p_rec.agency_code :=
1237: ghr_cmp_shd.g_old_rec.agency_code;

Line 1237: ghr_cmp_shd.g_old_rec.agency_code;

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
1240: p_rec.audited_by :=
1241: ghr_cmp_shd.g_old_rec.audited_by;

Line 1241: ghr_cmp_shd.g_old_rec.audited_by;

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
1244: p_rec.record_received :=
1245: ghr_cmp_shd.g_old_rec.record_received;

Line 1245: ghr_cmp_shd.g_old_rec.record_received;

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: ---------------------------------------------------------------------------
1248:
1249: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 1251: ghr_cmp_shd.g_old_rec.attribute_category;

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
1254: p_rec.attribute1 :=
1255: ghr_cmp_shd.g_old_rec.attribute1;

Line 1255: ghr_cmp_shd.g_old_rec.attribute1;

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
1258: p_rec.attribute2 :=
1259: ghr_cmp_shd.g_old_rec.attribute2;

Line 1259: ghr_cmp_shd.g_old_rec.attribute2;

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
1262: p_rec.attribute3 :=
1263: ghr_cmp_shd.g_old_rec.attribute3;

Line 1263: ghr_cmp_shd.g_old_rec.attribute3;

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
1266: p_rec.attribute4 :=
1267: ghr_cmp_shd.g_old_rec.attribute4;

Line 1267: ghr_cmp_shd.g_old_rec.attribute4;

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
1270: p_rec.attribute5 :=
1271: ghr_cmp_shd.g_old_rec.attribute5;

Line 1271: ghr_cmp_shd.g_old_rec.attribute5;

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
1274: p_rec.attribute6 :=
1275: ghr_cmp_shd.g_old_rec.attribute6;

Line 1275: ghr_cmp_shd.g_old_rec.attribute6;

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
1278: p_rec.attribute7 :=
1279: ghr_cmp_shd.g_old_rec.attribute7;

Line 1279: ghr_cmp_shd.g_old_rec.attribute7;

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
1282: p_rec.attribute8 :=
1283: ghr_cmp_shd.g_old_rec.attribute8;

Line 1283: ghr_cmp_shd.g_old_rec.attribute8;

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
1286: p_rec.attribute9 :=
1287: ghr_cmp_shd.g_old_rec.attribute9;

Line 1287: ghr_cmp_shd.g_old_rec.attribute9;

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
1290: p_rec.attribute10 :=
1291: ghr_cmp_shd.g_old_rec.attribute10;

Line 1291: ghr_cmp_shd.g_old_rec.attribute10;

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
1294: p_rec.attribute11 :=
1295: ghr_cmp_shd.g_old_rec.attribute11;

Line 1295: ghr_cmp_shd.g_old_rec.attribute11;

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
1298: p_rec.attribute12 :=
1299: ghr_cmp_shd.g_old_rec.attribute12;

Line 1299: ghr_cmp_shd.g_old_rec.attribute12;

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
1302: p_rec.attribute13 :=
1303: ghr_cmp_shd.g_old_rec.attribute13;

Line 1303: ghr_cmp_shd.g_old_rec.attribute13;

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
1306: p_rec.attribute14 :=
1307: ghr_cmp_shd.g_old_rec.attribute14;

Line 1307: ghr_cmp_shd.g_old_rec.attribute14;

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
1310: p_rec.attribute15 :=
1311: ghr_cmp_shd.g_old_rec.attribute15;

Line 1311: ghr_cmp_shd.g_old_rec.attribute15;

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
1314: p_rec.attribute16 :=
1315: ghr_cmp_shd.g_old_rec.attribute16;

Line 1315: ghr_cmp_shd.g_old_rec.attribute16;

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
1318: p_rec.attribute17 :=
1319: ghr_cmp_shd.g_old_rec.attribute17;

Line 1319: ghr_cmp_shd.g_old_rec.attribute17;

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
1322: p_rec.attribute18 :=
1323: ghr_cmp_shd.g_old_rec.attribute18;

Line 1323: ghr_cmp_shd.g_old_rec.attribute18;

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
1326: p_rec.attribute19 :=
1327: ghr_cmp_shd.g_old_rec.attribute19;

Line 1327: ghr_cmp_shd.g_old_rec.attribute19;

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
1330: p_rec.attribute20 :=
1331: ghr_cmp_shd.g_old_rec.attribute20;

Line 1331: ghr_cmp_shd.g_old_rec.attribute20;

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
1334: p_rec.attribute21 :=
1335: ghr_cmp_shd.g_old_rec.attribute21;

Line 1335: ghr_cmp_shd.g_old_rec.attribute21;

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
1338: p_rec.attribute22 :=
1339: ghr_cmp_shd.g_old_rec.attribute22;

Line 1339: ghr_cmp_shd.g_old_rec.attribute22;

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
1342: p_rec.attribute23 :=
1343: ghr_cmp_shd.g_old_rec.attribute23;

Line 1343: ghr_cmp_shd.g_old_rec.attribute23;

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
1346: p_rec.attribute24 :=
1347: ghr_cmp_shd.g_old_rec.attribute24;

Line 1347: ghr_cmp_shd.g_old_rec.attribute24;

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
1350: p_rec.attribute25 :=
1351: ghr_cmp_shd.g_old_rec.attribute25;

Line 1351: ghr_cmp_shd.g_old_rec.attribute25;

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
1354: p_rec.attribute26 :=
1355: ghr_cmp_shd.g_old_rec.attribute26;

Line 1355: ghr_cmp_shd.g_old_rec.attribute26;

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
1358: p_rec.attribute27 :=
1359: ghr_cmp_shd.g_old_rec.attribute27;

Line 1359: ghr_cmp_shd.g_old_rec.attribute27;

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
1362: p_rec.attribute28 :=
1363: ghr_cmp_shd.g_old_rec.attribute28;

Line 1363: ghr_cmp_shd.g_old_rec.attribute28;

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
1366: p_rec.attribute29 :=
1367: ghr_cmp_shd.g_old_rec.attribute29;

Line 1367: ghr_cmp_shd.g_old_rec.attribute29;

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
1370: p_rec.attribute30 :=
1371: ghr_cmp_shd.g_old_rec.attribute30;

Line 1371: ghr_cmp_shd.g_old_rec.attribute30;

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:
1374: --
1375: End convert_defs;

Line 1382: ,p_rec in out nocopy ghr_cmp_shd.g_rec_type

1378: -- |---------------------------------< upd >----------------------------------|
1379: -- ----------------------------------------------------------------------------
1380: Procedure upd
1381: (p_effective_date in date
1382: ,p_rec in out nocopy ghr_cmp_shd.g_rec_type
1383: ) is
1384: --
1385: l_proc varchar2(72) := g_package||'upd';
1386: --

Line 1392: ghr_cmp_shd.lck

1388: hr_utility.set_location('Entering:'||l_proc, 5);
1389: --
1390: -- We must lock the row which we need to update.
1391: --
1392: ghr_cmp_shd.lck
1393: (p_rec.complaint_id
1394: ,p_rec.object_version_number
1395: );
1396: --

Line 1591: l_rec ghr_cmp_shd.g_rec_type;

1587: ,p_attribute29 in varchar2
1588: ,p_attribute30 in varchar2
1589: ) is
1590: --
1591: l_rec ghr_cmp_shd.g_rec_type;
1592: l_proc varchar2(72) := g_package||'upd';
1593: --
1594: Begin
1595: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1601: ghr_cmp_shd.convert_args

1597: -- Call conversion function to turn arguments into the
1598: -- l_rec structure.
1599: --
1600: l_rec :=
1601: ghr_cmp_shd.convert_args
1602: (p_complaint_id
1603: ,p_complainant_person_id
1604: ,p_business_group_id
1605: ,p_docket_number