The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure update_dml
(p_rec in out nocopy ghr_cmp_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'update_dml';
update ghr_complaints2
set
complaint_id = p_rec.complaint_id
,complainant_person_id = p_rec.complainant_person_id
,business_group_id = p_rec.business_group_id
,docket_number = p_rec.docket_number
,stage = p_rec.stage
,class_flag = p_rec.class_flag
,mixed_flag = p_rec.mixed_flag
,consolidated_flag = p_rec.consolidated_flag
,remand_flag = p_rec.remand_flag
,active_flag = p_rec.active_flag
,information_inquiry = p_rec.information_inquiry
,pcom_init = p_rec.pcom_init
,alleg_incident = p_rec.alleg_incident
,alleg_discrim_org_id = p_rec.alleg_discrim_org_id
,rr_ltr_date = p_rec.rr_ltr_date
,rr_ltr_recvd = p_rec.rr_ltr_recvd
,pre_com_elec = p_rec.pre_com_elec
--,adr_offered = p_rec.adr_offered
,class_agent_flag = p_rec.class_agent_flag
,pre_com_desc = p_rec.pre_com_desc
,counselor_asg = p_rec.counselor_asg
,init_counselor_interview = p_rec.init_counselor_interview
,anonymity_requested = p_rec.anonymity_requested
,counsel_ext_ltr = p_rec.counsel_ext_ltr
,traditional_counsel_outcome = p_rec.traditional_counsel_outcome
,final_interview = p_rec.final_interview
,notice_rtf_recvd = p_rec.notice_rtf_recvd
,precom_closed = p_rec.precom_closed
,precom_closure_nature = p_rec.precom_closure_nature
,counselor_rpt_sub = p_rec.counselor_rpt_sub
,hr_office_org_id = p_rec.hr_office_org_id
,eeo_office_org_id = p_rec.eeo_office_org_id
,serviced_org_id = p_rec.serviced_org_id
,formal_com_filed = p_rec.formal_com_filed
,ack_ltr = p_rec.ack_ltr
,clarification_ltr_date = p_rec.clarification_ltr_date
,clarification_response_recvd = p_rec.clarification_response_recvd
,forwarded_legal_review = p_rec.forwarded_legal_review
,returned_from_legal = p_rec.returned_from_legal
,letter_type = p_rec.letter_type
,letter_date = p_rec.letter_date
,letter_recvd = p_rec.letter_recvd
,investigation_source = p_rec.investigation_source
,investigator_recvd_req = p_rec.investigator_recvd_req
,agency_investigator_req = p_rec.agency_investigator_req
,investigator_asg = p_rec.investigator_asg
,investigation_start = p_rec.investigation_start
,investigation_end = p_rec.investigation_end
,investigation_extended = p_rec.investigation_extended
,invest_extension_desc = p_rec.invest_extension_desc
,agency_recvd_roi = p_rec.agency_recvd_roi
,comrep_recvd_roi = p_rec.comrep_recvd_roi
,options_ltr_date = p_rec.options_ltr_date
,comrep_recvd_opt_ltr = p_rec.comrep_recvd_opt_ltr
,comrep_opt_ltr_response = p_rec.comrep_opt_ltr_response
,resolution_offer = p_rec.resolution_offer
,comrep_resol_offer_recvd = p_rec.comrep_resol_offer_recvd
,comrep_resol_offer_response = p_rec.comrep_resol_offer_response
,comrep_resol_offer_desc = p_rec.comrep_resol_offer_desc
,resol_offer_signed = p_rec.resol_offer_signed
,resol_offer_desc = p_rec.resol_offer_desc
,hearing_source = p_rec.hearing_source
,agency_notified_hearing = p_rec.agency_notified_hearing
,eeoc_hearing_docket_num = p_rec.eeoc_hearing_docket_num
,hearing_complete = p_rec.hearing_complete
,aj_merit_decision_date = p_rec.aj_merit_decision_date
,agency_recvd_aj_merit_dec = p_rec.agency_recvd_aj_merit_dec
,aj_merit_decision = p_rec.aj_merit_decision
,aj_ca_decision_date = p_rec.aj_ca_decision_date
,agency_recvd_aj_ca_dec = p_rec.agency_recvd_aj_ca_dec
,aj_ca_decision = p_rec.aj_ca_decision
,fad_requested = p_rec.fad_requested
,merit_fad = p_rec.merit_fad
,attorney_fees_fad = p_rec.attorney_fees_fad
,comp_damages_fad = p_rec.comp_damages_fad
,non_compliance_fad = p_rec.non_compliance_fad
,fad_req_recvd_eeo_office = p_rec.fad_req_recvd_eeo_office
,fad_req_forwd_to_agency = p_rec.fad_req_forwd_to_agency
,agency_recvd_request = p_rec.agency_recvd_request
,fad_due = p_rec.fad_due
,fad_date = p_rec.fad_date
,fad_decision = p_rec.fad_decision
-- ,fad_final_action_closure = p_rec.fad_final_action_closure
,fad_forwd_to_comrep = p_rec.fad_forwd_to_comrep
,fad_recvd_by_comrep = p_rec.fad_recvd_by_comrep
,fad_imp_ltr_forwd_to_org = p_rec.fad_imp_ltr_forwd_to_org
,fad_decision_forwd_legal = p_rec.fad_decision_forwd_legal
,fad_decision_recvd_legal = p_rec.fad_decision_recvd_legal
,fa_source = p_rec.fa_source
,final_action_due = p_rec.final_action_due
--,final_action_nature_of_closure = p_rec.final_action_nature_of_closure
,final_act_forwd_comrep = p_rec.final_act_forwd_comrep
,final_act_recvd_comrep = p_rec.final_act_recvd_comrep
,final_action_decision_date = p_rec.final_action_decision_date
,final_action_decision = p_rec.final_action_decision
,fa_imp_ltr_forwd_to_org = p_rec.fa_imp_ltr_forwd_to_org
,fa_decision_forwd_legal = p_rec.fa_decision_forwd_legal
,fa_decision_recvd_legal = p_rec.fa_decision_recvd_legal
,civil_action_filed = p_rec.civil_action_filed
,agency_closure_confirmed = p_rec.agency_closure_confirmed
,consolidated_complaint_id = p_rec.consolidated_complaint_id
,consolidated = p_rec.consolidated
,stage_of_consolidation = p_rec.stage_of_consolidation
,comrep_notif_consolidation = p_rec.comrep_notif_consolidation
,consolidation_desc = p_rec.consolidation_desc
,complaint_closed = p_rec.complaint_closed
,nature_of_closure = p_rec.nature_of_closure
,complaint_closed_desc = p_rec.complaint_closed_desc
,filed_formal_class = p_rec.filed_formal_class
,forwd_eeoc = p_rec.forwd_eeoc
,aj_cert_decision_date = p_rec.aj_cert_decision_date
,aj_cert_decision_recvd = p_rec.aj_cert_decision_recvd
,aj_cert_decision = p_rec.aj_cert_decision
,class_members_notified = p_rec.class_members_notified
,number_of_complaintants = p_rec.number_of_complaintants
,class_hearing = p_rec.class_hearing
,aj_dec = p_rec.aj_dec
,agency_recvd_aj_dec = p_rec.agency_recvd_aj_dec
,aj_decision = p_rec.aj_decision
,object_version_number = p_rec.object_version_number
,agency_brief_eeoc = p_rec.agency_brief_eeoc
,agency_notif_of_civil_action = p_rec.agency_notif_of_civil_action
,fad_source = p_rec.fad_source
,agency_files_forwarded_eeoc = p_rec.agency_files_forwarded_eeoc
,hearing_req = p_rec.hearing_req
,agency_code = p_rec.agency_code
,audited_by = p_rec.audited_by
,record_received = p_rec.record_received
,attribute_category = p_rec.attribute_category
,attribute1 = p_rec.attribute1
,attribute2 = p_rec.attribute2
,attribute3 = p_rec.attribute3
,attribute4 = p_rec.attribute4
,attribute5 = p_rec.attribute5
,attribute6 = p_rec.attribute6
,attribute7 = p_rec.attribute7
,attribute8 = p_rec.attribute8
,attribute9 = p_rec.attribute9
,attribute10 = p_rec.attribute10
,attribute11 = p_rec.attribute11
,attribute12 = p_rec.attribute12
,attribute13 = p_rec.attribute13
,attribute14 = p_rec.attribute14
,attribute15 = p_rec.attribute15
,attribute16 = p_rec.attribute16
,attribute17 = p_rec.attribute17
,attribute18 = p_rec.attribute18
,attribute19 = p_rec.attribute19
,attribute20 = p_rec.attribute20
,attribute21 = p_rec.attribute21
,attribute22 = p_rec.attribute22
,attribute23 = p_rec.attribute23
,attribute24 = p_rec.attribute24
,attribute25 = p_rec.attribute25
,attribute26 = p_rec.attribute26
,attribute27 = p_rec.attribute27
,attribute28 = p_rec.attribute28
,attribute29 = p_rec.attribute29
,attribute30 = p_rec.attribute30
where complaint_id = p_rec.complaint_id;
End update_dml;
Procedure pre_update
(p_rec in ghr_cmp_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'pre_update';
End pre_update;
Procedure post_update
(p_effective_date in date
,p_rec in ghr_cmp_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'post_update';
ghr_cmp_rku.after_update
(p_effective_date => p_effective_date
,p_complaint_id => p_rec.complaint_id
,p_complainant_person_id => p_rec.complainant_person_id
,p_business_group_id => p_rec.business_group_id
,p_docket_number => p_rec.docket_number
,p_stage => p_rec.stage
,p_class_flag => p_rec.class_flag
,p_mixed_flag => p_rec.mixed_flag
,p_consolidated_flag => p_rec.consolidated_flag
,p_remand_flag => p_rec.remand_flag
,p_active_flag => p_rec.active_flag
,p_information_inquiry => p_rec.information_inquiry
,p_pcom_init => p_rec.pcom_init
,p_alleg_incident => p_rec.alleg_incident
,p_alleg_discrim_org_id => p_rec.alleg_discrim_org_id
,p_rr_ltr_date => p_rec.rr_ltr_date
,p_rr_ltr_recvd => p_rec.rr_ltr_recvd
,p_pre_com_elec => p_rec.pre_com_elec
--,p_adr_offered => p_rec.adr_offered
,p_class_agent_flag => p_rec.class_agent_flag
,p_pre_com_desc => p_rec.pre_com_desc
,p_counselor_asg => p_rec.counselor_asg
,p_init_counselor_interview => p_rec.init_counselor_interview
,p_anonymity_requested => p_rec.anonymity_requested
,p_counsel_ext_ltr => p_rec.counsel_ext_ltr
,p_traditional_counsel_outcome => p_rec.traditional_counsel_outcome
,p_final_interview => p_rec.final_interview
,p_notice_rtf_recvd => p_rec.notice_rtf_recvd
,p_precom_closed => p_rec.precom_closed
,p_precom_closure_nature => p_rec.precom_closure_nature
,p_counselor_rpt_sub => p_rec.counselor_rpt_sub
,p_hr_office_org_id => p_rec.hr_office_org_id
,p_eeo_office_org_id => p_rec.eeo_office_org_id
,p_serviced_org_id => p_rec.serviced_org_id
,p_formal_com_filed => p_rec.formal_com_filed
,p_ack_ltr => p_rec.ack_ltr
,p_clarification_ltr_date => p_rec.clarification_ltr_date
,p_clarification_response_recvd => p_rec.clarification_response_recvd
,p_forwarded_legal_review => p_rec.forwarded_legal_review
,p_returned_from_legal => p_rec.returned_from_legal
,p_letter_type => p_rec.letter_type
,p_letter_date => p_rec.letter_date
,p_letter_recvd => p_rec.letter_recvd
,p_investigation_source => p_rec.investigation_source
,p_investigator_recvd_req => p_rec.investigator_recvd_req
,p_agency_investigator_req => p_rec.agency_investigator_req
,p_investigator_asg => p_rec.investigator_asg
,p_investigation_start => p_rec.investigation_start
,p_investigation_end => p_rec.investigation_end
,p_investigation_extended => p_rec.investigation_extended
,p_invest_extension_desc => p_rec.invest_extension_desc
,p_agency_recvd_roi => p_rec.agency_recvd_roi
,p_comrep_recvd_roi => p_rec.comrep_recvd_roi
,p_options_ltr_date => p_rec.options_ltr_date
,p_comrep_recvd_opt_ltr => p_rec.comrep_recvd_opt_ltr
,p_comrep_opt_ltr_response => p_rec.comrep_opt_ltr_response
,p_resolution_offer => p_rec.resolution_offer
,p_comrep_resol_offer_recvd => p_rec.comrep_resol_offer_recvd
,p_comrep_resol_offer_response => p_rec.comrep_resol_offer_response
,p_comrep_resol_offer_desc => p_rec.comrep_resol_offer_desc
,p_resol_offer_signed => p_rec.resol_offer_signed
,p_resol_offer_desc => p_rec.resol_offer_desc
,p_hearing_source => p_rec.hearing_source
,p_agency_notified_hearing => p_rec.agency_notified_hearing
,p_eeoc_hearing_docket_num => p_rec.eeoc_hearing_docket_num
,p_hearing_complete => p_rec.hearing_complete
,p_aj_merit_decision_date => p_rec.aj_merit_decision_date
,p_agency_recvd_aj_merit_dec => p_rec.agency_recvd_aj_merit_dec
,p_aj_merit_decision => p_rec.aj_merit_decision
,p_aj_ca_decision_date => p_rec.aj_ca_decision_date
,p_agency_recvd_aj_ca_dec => p_rec.agency_recvd_aj_ca_dec
,p_aj_ca_decision => p_rec.aj_ca_decision
,p_fad_requested => p_rec.fad_requested
,p_merit_fad => p_rec.merit_fad
,p_attorney_fees_fad => p_rec.attorney_fees_fad
,p_comp_damages_fad => p_rec.comp_damages_fad
,p_non_compliance_fad => p_rec.non_compliance_fad
,p_fad_req_recvd_eeo_office => p_rec.fad_req_recvd_eeo_office
,p_fad_req_forwd_to_agency => p_rec.fad_req_forwd_to_agency
,p_agency_recvd_request => p_rec.agency_recvd_request
,p_fad_due => p_rec.fad_due
,p_fad_date => p_rec.fad_date
,p_fad_decision => p_rec.fad_decision
-- ,p_fad_final_action_closure => p_rec.fad_final_action_closure
,p_fad_forwd_to_comrep => p_rec.fad_forwd_to_comrep
,p_fad_recvd_by_comrep => p_rec.fad_recvd_by_comrep
,p_fad_imp_ltr_forwd_to_org => p_rec.fad_imp_ltr_forwd_to_org
,p_fad_decision_forwd_legal => p_rec.fad_decision_forwd_legal
,p_fad_decision_recvd_legal => p_rec.fad_decision_recvd_legal
,p_fa_source => p_rec.fa_source
,p_final_action_due => p_rec.final_action_due
--,p_final_action_nature_of_closu => p_rec.final_action_nature_of_closure
,p_final_act_forwd_comrep => p_rec.final_act_forwd_comrep
,p_final_act_recvd_comrep => p_rec.final_act_recvd_comrep
,p_final_action_decision_date => p_rec.final_action_decision_date
,p_final_action_decision => p_rec.final_action_decision
,p_fa_imp_ltr_forwd_to_org => p_rec.fa_imp_ltr_forwd_to_org
,p_fa_decision_forwd_legal => p_rec.fa_decision_forwd_legal
,p_fa_decision_recvd_legal => p_rec.fa_decision_recvd_legal
,p_civil_action_filed => p_rec.civil_action_filed
,p_agency_closure_confirmed => p_rec.agency_closure_confirmed
,p_consolidated_complaint_id => p_rec.consolidated_complaint_id
,p_consolidated => p_rec.consolidated
,p_stage_of_consolidation => p_rec.stage_of_consolidation
,p_comrep_notif_consolidation => p_rec.comrep_notif_consolidation
,p_consolidation_desc => p_rec.consolidation_desc
,p_complaint_closed => p_rec.complaint_closed
,p_nature_of_closure => p_rec.nature_of_closure
,p_complaint_closed_desc => p_rec.complaint_closed_desc
,p_filed_formal_class => p_rec.filed_formal_class
,p_forwd_eeoc => p_rec.forwd_eeoc
,p_aj_cert_decision_date => p_rec.aj_cert_decision_date
,p_aj_cert_decision_recvd => p_rec.aj_cert_decision_recvd
,p_aj_cert_decision => p_rec.aj_cert_decision
,p_class_members_notified => p_rec.class_members_notified
,p_number_of_complaintants => p_rec.number_of_complaintants
,p_class_hearing => p_rec.class_hearing
,p_aj_dec => p_rec.aj_dec
,p_agency_recvd_aj_dec => p_rec.agency_recvd_aj_dec
,p_aj_decision => p_rec.aj_decision
,p_object_version_number => p_rec.object_version_number
,p_agency_brief_eeoc => p_rec.agency_brief_eeoc
,p_agency_notif_of_civil_action => p_rec.agency_notif_of_civil_action
,p_fad_source => p_rec.fad_source
,p_agency_files_forwarded_eeoc => p_rec.agency_files_forwarded_eeoc
,p_hearing_req => p_rec.hearing_req
,p_agency_code => p_rec.agency_code
,p_audited_by => p_rec.audited_by
,p_record_received => p_rec.record_received
,p_attribute_category => p_rec.attribute_category
,p_attribute1 => p_rec.attribute1
,p_attribute2 => p_rec.attribute2
,p_attribute3 => p_rec.attribute3
,p_attribute4 => p_rec.attribute4
,p_attribute5 => p_rec.attribute5
,p_attribute6 => p_rec.attribute6
,p_attribute7 => p_rec.attribute7
,p_attribute8 => p_rec.attribute8
,p_attribute9 => p_rec.attribute9
,p_attribute10 => p_rec.attribute10
,p_attribute11 => p_rec.attribute11
,p_attribute12 => p_rec.attribute12
,p_attribute13 => p_rec.attribute13
,p_attribute14 => p_rec.attribute14
,p_attribute15 => p_rec.attribute15
,p_attribute16 => p_rec.attribute16
,p_attribute17 => p_rec.attribute17
,p_attribute18 => p_rec.attribute18
,p_attribute19 => p_rec.attribute19
,p_attribute20 => p_rec.attribute20
,p_attribute21 => p_rec.attribute21
,p_attribute22 => p_rec.attribute22
,p_attribute23 => p_rec.attribute23
,p_attribute24 => p_rec.attribute24
,p_attribute25 => p_rec.attribute25
,p_attribute26 => p_rec.attribute26
,p_attribute27 => p_rec.attribute27
,p_attribute28 => p_rec.attribute28
,p_attribute29 => p_rec.attribute29
,p_attribute30 => p_rec.attribute30
,p_complainant_person_id_o => ghr_cmp_shd.g_old_rec.complainant_person_id
,p_business_group_id_o => ghr_cmp_shd.g_old_rec.business_group_id
,p_docket_number_o => ghr_cmp_shd.g_old_rec.docket_number
,p_stage_o => ghr_cmp_shd.g_old_rec.stage
,p_class_flag_o => ghr_cmp_shd.g_old_rec.class_flag
,p_mixed_flag_o => ghr_cmp_shd.g_old_rec.mixed_flag
,p_consolidated_flag_o => ghr_cmp_shd.g_old_rec.consolidated_flag
,p_remand_flag_o => ghr_cmp_shd.g_old_rec.remand_flag
,p_active_flag_o => ghr_cmp_shd.g_old_rec.active_flag
,p_information_inquiry_o => ghr_cmp_shd.g_old_rec.information_inquiry
,p_pcom_init_o => ghr_cmp_shd.g_old_rec.pcom_init
,p_alleg_incident_o => ghr_cmp_shd.g_old_rec.alleg_incident
,p_alleg_discrim_org_id_o => ghr_cmp_shd.g_old_rec.alleg_discrim_org_id
,p_rr_ltr_date_o => ghr_cmp_shd.g_old_rec.rr_ltr_date
,p_rr_ltr_recvd_o => ghr_cmp_shd.g_old_rec.rr_ltr_recvd
,p_pre_com_elec_o => ghr_cmp_shd.g_old_rec.pre_com_elec
--,p_adr_offered_o => ghr_cmp_shd.g_old_rec.adr_offered
,p_class_agent_flag_o => ghr_cmp_shd.g_old_rec.class_agent_flag
,p_pre_com_desc_o => ghr_cmp_shd.g_old_rec.pre_com_desc
,p_counselor_asg_o => ghr_cmp_shd.g_old_rec.counselor_asg
,p_init_counselor_interview_o => ghr_cmp_shd.g_old_rec.init_counselor_interview
,p_anonymity_requested_o => ghr_cmp_shd.g_old_rec.anonymity_requested
,p_counsel_ext_ltr_o => ghr_cmp_shd.g_old_rec.counsel_ext_ltr
,p_traditional_counsel_outcom_o => ghr_cmp_shd.g_old_rec.traditional_counsel_outcome
,p_final_interview_o => ghr_cmp_shd.g_old_rec.final_interview
,p_notice_rtf_recvd_o => ghr_cmp_shd.g_old_rec.notice_rtf_recvd
,p_precom_closed_o => ghr_cmp_shd.g_old_rec.precom_closed
,p_precom_closure_nature_o => ghr_cmp_shd.g_old_rec.precom_closure_nature
,p_counselor_rpt_sub_o => ghr_cmp_shd.g_old_rec.counselor_rpt_sub
,p_hr_office_org_id_o => ghr_cmp_shd.g_old_rec.hr_office_org_id
,p_eeo_office_org_id_o => ghr_cmp_shd.g_old_rec.eeo_office_org_id
,p_serviced_org_id_o => ghr_cmp_shd.g_old_rec.serviced_org_id
,p_formal_com_filed_o => ghr_cmp_shd.g_old_rec.formal_com_filed
,p_ack_ltr_o => ghr_cmp_shd.g_old_rec.ack_ltr
,p_clarification_ltr_date_o => ghr_cmp_shd.g_old_rec.clarification_ltr_date
,p_clarification_response_rec_o => ghr_cmp_shd.g_old_rec.clarification_response_recvd
,p_forwarded_legal_review_o => ghr_cmp_shd.g_old_rec.forwarded_legal_review
,p_returned_from_legal_o => ghr_cmp_shd.g_old_rec.returned_from_legal
,p_letter_type_o => ghr_cmp_shd.g_old_rec.letter_type
,p_letter_date_o => ghr_cmp_shd.g_old_rec.letter_date
,p_letter_recvd_o => ghr_cmp_shd.g_old_rec.letter_recvd
,p_investigation_source_o => ghr_cmp_shd.g_old_rec.investigation_source
,p_investigator_recvd_req_o => ghr_cmp_shd.g_old_rec.investigator_recvd_req
,p_agency_investigator_req_o => ghr_cmp_shd.g_old_rec.agency_investigator_req
,p_investigator_asg_o => ghr_cmp_shd.g_old_rec.investigator_asg
,p_investigation_start_o => ghr_cmp_shd.g_old_rec.investigation_start
,p_investigation_end_o => ghr_cmp_shd.g_old_rec.investigation_end
,p_investigation_extended_o => ghr_cmp_shd.g_old_rec.investigation_extended
,p_invest_extension_desc_o => ghr_cmp_shd.g_old_rec.invest_extension_desc
,p_agency_recvd_roi_o => ghr_cmp_shd.g_old_rec.agency_recvd_roi
,p_comrep_recvd_roi_o => ghr_cmp_shd.g_old_rec.comrep_recvd_roi
,p_options_ltr_date_o => ghr_cmp_shd.g_old_rec.options_ltr_date
,p_comrep_recvd_opt_ltr_o => ghr_cmp_shd.g_old_rec.comrep_recvd_opt_ltr
,p_comrep_opt_ltr_response_o => ghr_cmp_shd.g_old_rec.comrep_opt_ltr_response
,p_resolution_offer_o => ghr_cmp_shd.g_old_rec.resolution_offer
,p_comrep_resol_offer_recvd_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_recvd
,p_comrep_resol_offer_respons_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_response
,p_comrep_resol_offer_desc_o => ghr_cmp_shd.g_old_rec.comrep_resol_offer_desc
,p_resol_offer_signed_o => ghr_cmp_shd.g_old_rec.resol_offer_signed
,p_resol_offer_desc_o => ghr_cmp_shd.g_old_rec.resol_offer_desc
,p_hearing_source_o => ghr_cmp_shd.g_old_rec.hearing_source
,p_agency_notified_hearing_o => ghr_cmp_shd.g_old_rec.agency_notified_hearing
,p_eeoc_hearing_docket_num_o => ghr_cmp_shd.g_old_rec.eeoc_hearing_docket_num
,p_hearing_complete_o => ghr_cmp_shd.g_old_rec.hearing_complete
,p_aj_merit_decision_date_o => ghr_cmp_shd.g_old_rec.aj_merit_decision_date
,p_agency_recvd_aj_merit_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_merit_dec
,p_aj_merit_decision_o => ghr_cmp_shd.g_old_rec.aj_merit_decision
,p_aj_ca_decision_date_o => ghr_cmp_shd.g_old_rec.aj_ca_decision_date
,p_agency_recvd_aj_ca_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_ca_dec
,p_aj_ca_decision_o => ghr_cmp_shd.g_old_rec.aj_ca_decision
,p_fad_requested_o => ghr_cmp_shd.g_old_rec.fad_requested
,p_merit_fad_o => ghr_cmp_shd.g_old_rec.merit_fad
,p_attorney_fees_fad_o => ghr_cmp_shd.g_old_rec.attorney_fees_fad
,p_comp_damages_fad_o => ghr_cmp_shd.g_old_rec.comp_damages_fad
,p_non_compliance_fad_o => ghr_cmp_shd.g_old_rec.non_compliance_fad
,p_fad_req_recvd_eeo_office_o => ghr_cmp_shd.g_old_rec.fad_req_recvd_eeo_office
,p_fad_req_forwd_to_agency_o => ghr_cmp_shd.g_old_rec.fad_req_forwd_to_agency
,p_agency_recvd_request_o => ghr_cmp_shd.g_old_rec.agency_recvd_request
,p_fad_due_o => ghr_cmp_shd.g_old_rec.fad_due
,p_fad_date_o => ghr_cmp_shd.g_old_rec.fad_date
,p_fad_decision_o => ghr_cmp_shd.g_old_rec.fad_decision
-- ,p_fad_final_action_closure_o => ghr_cmp_shd.g_old_rec.fad_final_action_closure
,p_fad_forwd_to_comrep_o => ghr_cmp_shd.g_old_rec.fad_forwd_to_comrep
,p_fad_recvd_by_comrep_o => ghr_cmp_shd.g_old_rec.fad_recvd_by_comrep
,p_fad_imp_ltr_forwd_to_org_o => ghr_cmp_shd.g_old_rec.fad_imp_ltr_forwd_to_org
,p_fad_decision_forwd_legal_o => ghr_cmp_shd.g_old_rec.fad_decision_forwd_legal
,p_fad_decision_recvd_legal_o => ghr_cmp_shd.g_old_rec.fad_decision_recvd_legal
,p_fa_source_o => ghr_cmp_shd.g_old_rec.fa_source
,p_final_action_due_o => ghr_cmp_shd.g_old_rec.final_action_due
--,p_final_action_nature_of_clo_o => ghr_cmp_shd.g_old_rec.final_action_nature_of_closure
,p_final_act_forwd_comrep_o => ghr_cmp_shd.g_old_rec.final_act_forwd_comrep
,p_final_act_recvd_comrep_o => ghr_cmp_shd.g_old_rec.final_act_recvd_comrep
,p_final_action_decision_date_o => ghr_cmp_shd.g_old_rec.final_action_decision_date
,p_final_action_decision_o => ghr_cmp_shd.g_old_rec.final_action_decision
,p_fa_imp_ltr_forwd_to_org_o => ghr_cmp_shd.g_old_rec.fa_imp_ltr_forwd_to_org
,p_fa_decision_forwd_legal_o => ghr_cmp_shd.g_old_rec.fa_decision_forwd_legal
,p_fa_decision_recvd_legal_o => ghr_cmp_shd.g_old_rec.fa_decision_recvd_legal
,p_civil_action_filed_o => ghr_cmp_shd.g_old_rec.civil_action_filed
,p_agency_closure_confirmed_o => ghr_cmp_shd.g_old_rec.agency_closure_confirmed
,p_consolidated_complaint_id_o => ghr_cmp_shd.g_old_rec.consolidated_complaint_id
,p_consolidated_o => ghr_cmp_shd.g_old_rec.consolidated
,p_stage_of_consolidation_o => ghr_cmp_shd.g_old_rec.stage_of_consolidation
,p_comrep_notif_consolidation_o => ghr_cmp_shd.g_old_rec.comrep_notif_consolidation
,p_consolidation_desc_o => ghr_cmp_shd.g_old_rec.consolidation_desc
,p_complaint_closed_o => ghr_cmp_shd.g_old_rec.complaint_closed
,p_nature_of_closure_o => ghr_cmp_shd.g_old_rec.nature_of_closure
,p_complaint_closed_desc_o => ghr_cmp_shd.g_old_rec.complaint_closed_desc
,p_filed_formal_class_o => ghr_cmp_shd.g_old_rec.filed_formal_class
,p_forwd_eeoc_o => ghr_cmp_shd.g_old_rec.forwd_eeoc
,p_aj_cert_decision_date_o => ghr_cmp_shd.g_old_rec.aj_cert_decision_date
,p_aj_cert_decision_recvd_o => ghr_cmp_shd.g_old_rec.aj_cert_decision_recvd
,p_aj_cert_decision_o => ghr_cmp_shd.g_old_rec.aj_cert_decision
,p_class_members_notified_o => ghr_cmp_shd.g_old_rec.class_members_notified
,p_number_of_complaintants_o => ghr_cmp_shd.g_old_rec.number_of_complaintants
,p_class_hearing_o => ghr_cmp_shd.g_old_rec.class_hearing
,p_aj_dec_o => ghr_cmp_shd.g_old_rec.aj_dec
,p_agency_recvd_aj_dec_o => ghr_cmp_shd.g_old_rec.agency_recvd_aj_dec
,p_aj_decision_o => ghr_cmp_shd.g_old_rec.aj_decision
,p_object_version_number_o => ghr_cmp_shd.g_old_rec.object_version_number
,p_agency_brief_eeoc_o => ghr_cmp_shd.g_old_rec.agency_brief_eeoc
,p_agency_notif_of_civil_acti_o => ghr_cmp_shd.g_old_rec.agency_notif_of_civil_action
,p_fad_source_o => ghr_cmp_shd.g_old_rec.fad_source
,p_agency_files_forwarded_eeo_o => ghr_cmp_shd.g_old_rec.agency_files_forwarded_eeoc
,p_hearing_req_o => ghr_cmp_shd.g_old_rec.hearing_req
,p_agency_code_o => ghr_cmp_shd.g_old_rec.agency_code
,p_audited_by_o => ghr_cmp_shd.g_old_rec.audited_by
,p_record_received_o => ghr_cmp_shd.g_old_rec.record_received
,p_attribute_category_o => ghr_cmp_shd.g_old_rec.attribute_category
,p_attribute1_o => ghr_cmp_shd.g_old_rec.attribute1
,p_attribute2_o => ghr_cmp_shd.g_old_rec.attribute2
,p_attribute3_o => ghr_cmp_shd.g_old_rec.attribute3
,p_attribute4_o => ghr_cmp_shd.g_old_rec.attribute4
,p_attribute5_o => ghr_cmp_shd.g_old_rec.attribute5
,p_attribute6_o => ghr_cmp_shd.g_old_rec.attribute6
,p_attribute7_o => ghr_cmp_shd.g_old_rec.attribute7
,p_attribute8_o => ghr_cmp_shd.g_old_rec.attribute8
,p_attribute9_o => ghr_cmp_shd.g_old_rec.attribute9
,p_attribute10_o => ghr_cmp_shd.g_old_rec.attribute10
,p_attribute11_o => ghr_cmp_shd.g_old_rec.attribute11
,p_attribute12_o => ghr_cmp_shd.g_old_rec.attribute12
,p_attribute13_o => ghr_cmp_shd.g_old_rec.attribute13
,p_attribute14_o => ghr_cmp_shd.g_old_rec.attribute14
,p_attribute15_o => ghr_cmp_shd.g_old_rec.attribute15
,p_attribute16_o => ghr_cmp_shd.g_old_rec.attribute16
,p_attribute17_o => ghr_cmp_shd.g_old_rec.attribute17
,p_attribute18_o => ghr_cmp_shd.g_old_rec.attribute18
,p_attribute19_o => ghr_cmp_shd.g_old_rec.attribute19
,p_attribute20_o => ghr_cmp_shd.g_old_rec.attribute20
,p_attribute21_o => ghr_cmp_shd.g_old_rec.attribute21
,p_attribute22_o => ghr_cmp_shd.g_old_rec.attribute22
,p_attribute23_o => ghr_cmp_shd.g_old_rec.attribute23
,p_attribute24_o => ghr_cmp_shd.g_old_rec.attribute24
,p_attribute25_o => ghr_cmp_shd.g_old_rec.attribute25
,p_attribute26_o => ghr_cmp_shd.g_old_rec.attribute26
,p_attribute27_o => ghr_cmp_shd.g_old_rec.attribute27
,p_attribute28_o => ghr_cmp_shd.g_old_rec.attribute28
,p_attribute29_o => ghr_cmp_shd.g_old_rec.attribute29
,p_attribute30_o => ghr_cmp_shd.g_old_rec.attribute30
);
End post_update;
ghr_cmp_bus.update_validate
(p_effective_date
,p_rec
);
ghr_cmp_upd.pre_update(p_rec);
ghr_cmp_upd.update_dml(p_rec);
ghr_cmp_upd.post_update
(p_effective_date
,p_rec
);