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: --
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: --
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: --
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;
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: --
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: --
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: );
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: --
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
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: --
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: --
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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 :=
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 :=
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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 :=
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 :=
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;
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;
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;
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;
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;
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;
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 :=
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 :=
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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: --
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: --
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);
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