APPS.GHR_CMP_RKU SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 5

procedure AFTER_UPDATE
(P_EFFECTIVE_DATE in DATE
,P_COMPLAINT_ID in NUMBER
,P_COMPLAINANT_PERSON_ID in NUMBER
,P_BUSINESS_GROUP_ID in NUMBER
,P_DOCKET_NUMBER in VARCHAR2
,P_STAGE in VARCHAR2
,P_CLASS_FLAG in VARCHAR2
,P_MIXED_FLAG in VARCHAR2
,P_CONSOLIDATED_FLAG in VARCHAR2
,P_REMAND_FLAG in VARCHAR2
,P_ACTIVE_FLAG in VARCHAR2
,P_INFORMATION_INQUIRY in DATE
,P_PCOM_INIT in DATE
,P_ALLEG_INCIDENT in DATE
,P_ALLEG_DISCRIM_ORG_ID in NUMBER
,P_RR_LTR_DATE in DATE
,P_RR_LTR_RECVD in DATE
,P_PRE_COM_ELEC in VARCHAR2
,P_CLASS_AGENT_FLAG in VARCHAR2
,P_PRE_COM_DESC in VARCHAR2
,P_COUNSELOR_ASG in DATE
,P_INIT_COUNSELOR_INTERVIEW in DATE
,P_ANONYMITY_REQUESTED in VARCHAR2
,P_COUNSEL_EXT_LTR in DATE
,P_TRADITIONAL_COUNSEL_OUTCOME in VARCHAR2
,P_FINAL_INTERVIEW in DATE
,P_NOTICE_RTF_RECVD in DATE
,P_PRECOM_CLOSED in DATE
,P_PRECOM_CLOSURE_NATURE in VARCHAR2
,P_COUNSELOR_RPT_SUB in DATE
,P_HR_OFFICE_ORG_ID in NUMBER
,P_EEO_OFFICE_ORG_ID in NUMBER
,P_SERVICED_ORG_ID in NUMBER
,P_FORMAL_COM_FILED in DATE
,P_ACK_LTR in DATE
,P_CLARIFICATION_LTR_DATE in DATE
,P_CLARIFICATION_RESPONSE_RECVD in DATE
,P_FORWARDED_LEGAL_REVIEW in DATE
,P_RETURNED_FROM_LEGAL in DATE
,P_LETTER_TYPE in VARCHAR2
,P_LETTER_DATE in DATE
,P_LETTER_RECVD in DATE
,P_INVESTIGATION_SOURCE in VARCHAR2
,P_INVESTIGATOR_RECVD_REQ in DATE
,P_AGENCY_INVESTIGATOR_REQ in DATE
,P_INVESTIGATOR_ASG in DATE
,P_INVESTIGATION_START in DATE
,P_INVESTIGATION_END in DATE
,P_INVESTIGATION_EXTENDED in DATE
,P_INVEST_EXTENSION_DESC in VARCHAR2
,P_AGENCY_RECVD_ROI in DATE
,P_COMREP_RECVD_ROI in DATE
,P_OPTIONS_LTR_DATE in DATE
,P_COMREP_RECVD_OPT_LTR in DATE
,P_COMREP_OPT_LTR_RESPONSE in VARCHAR2
,P_RESOLUTION_OFFER in DATE
,P_COMREP_RESOL_OFFER_RECVD in DATE
,P_COMREP_RESOL_OFFER_RESPONSE in DATE
,P_COMREP_RESOL_OFFER_DESC in VARCHAR2
,P_RESOL_OFFER_SIGNED in DATE
,P_RESOL_OFFER_DESC in VARCHAR2
,P_HEARING_SOURCE in VARCHAR2
,P_AGENCY_NOTIFIED_HEARING in DATE
,P_EEOC_HEARING_DOCKET_NUM in VARCHAR2
,P_HEARING_COMPLETE in DATE
,P_AJ_MERIT_DECISION_DATE in DATE
,P_AGENCY_RECVD_AJ_MERIT_DEC in DATE
,P_AJ_MERIT_DECISION in VARCHAR2
,P_AJ_CA_DECISION_DATE in DATE
,P_AGENCY_RECVD_AJ_CA_DEC in DATE
,P_AJ_CA_DECISION in VARCHAR2
,P_FAD_REQUESTED in DATE
,P_MERIT_FAD in VARCHAR2
,P_ATTORNEY_FEES_FAD in VARCHAR2
,P_COMP_DAMAGES_FAD in VARCHAR2
,P_NON_COMPLIANCE_FAD in VARCHAR2
,P_FAD_REQ_RECVD_EEO_OFFICE in DATE
,P_FAD_REQ_FORWD_TO_AGENCY in DATE
,P_AGENCY_RECVD_REQUEST in DATE
,P_FAD_DUE in DATE
,P_FAD_DATE in DATE
,P_FAD_DECISION in VARCHAR2
,P_FAD_FORWD_TO_COMREP in DATE
,P_FAD_RECVD_BY_COMREP in DATE
,P_FAD_IMP_LTR_FORWD_TO_ORG in DATE
,P_FAD_DECISION_FORWD_LEGAL in DATE
,P_FAD_DECISION_RECVD_LEGAL in DATE
,P_FA_SOURCE in VARCHAR2
,P_FINAL_ACTION_DUE in DATE
,P_FINAL_ACT_FORWD_COMREP in DATE
,P_FINAL_ACT_RECVD_COMREP in DATE
,P_FINAL_ACTION_DECISION_DATE in DATE
,P_FINAL_ACTION_DECISION in VARCHAR2
,P_FA_IMP_LTR_FORWD_TO_ORG in DATE
,P_FA_DECISION_FORWD_LEGAL in DATE
,P_FA_DECISION_RECVD_LEGAL in DATE
,P_CIVIL_ACTION_FILED in DATE
,P_AGENCY_CLOSURE_CONFIRMED in DATE
,P_CONSOLIDATED_COMPLAINT_ID in NUMBER
,P_CONSOLIDATED in DATE
,P_STAGE_OF_CONSOLIDATION in VARCHAR2
,P_COMREP_NOTIF_CONSOLIDATION in DATE
,P_CONSOLIDATION_DESC in VARCHAR2
,P_COMPLAINT_CLOSED in DATE
,P_NATURE_OF_CLOSURE in VARCHAR2
,P_COMPLAINT_CLOSED_DESC in VARCHAR2
,P_FILED_FORMAL_CLASS in DATE
,P_FORWD_EEOC in DATE
,P_AJ_CERT_DECISION_DATE in DATE
,P_AJ_CERT_DECISION_RECVD in DATE
,P_AJ_CERT_DECISION in VARCHAR2
,P_CLASS_MEMBERS_NOTIFIED in DATE
,P_NUMBER_OF_COMPLAINTANTS in NUMBER
,P_CLASS_HEARING in DATE
,P_AJ_DEC in DATE
,P_AGENCY_RECVD_AJ_DEC in DATE
,P_AJ_DECISION in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_AGENCY_BRIEF_EEOC in DATE
,P_AGENCY_NOTIF_OF_CIVIL_ACTION in DATE
,P_FAD_SOURCE in VARCHAR2
,P_AGENCY_FILES_FORWARDED_EEOC in DATE
,P_HEARING_REQ in DATE
,P_AGENCY_CODE in VARCHAR2
,P_AUDITED_BY in VARCHAR2
,P_RECORD_RECEIVED in DATE
,P_ATTRIBUTE_CATEGORY in VARCHAR2
,P_ATTRIBUTE1 in VARCHAR2
,P_ATTRIBUTE2 in VARCHAR2
,P_ATTRIBUTE3 in VARCHAR2
,P_ATTRIBUTE4 in VARCHAR2
,P_ATTRIBUTE5 in VARCHAR2
,P_ATTRIBUTE6 in VARCHAR2
,P_ATTRIBUTE7 in VARCHAR2
,P_ATTRIBUTE8 in VARCHAR2
,P_ATTRIBUTE9 in VARCHAR2
,P_ATTRIBUTE10 in VARCHAR2
,P_ATTRIBUTE11 in VARCHAR2
,P_ATTRIBUTE12 in VARCHAR2
,P_ATTRIBUTE13 in VARCHAR2
,P_ATTRIBUTE14 in VARCHAR2
,P_ATTRIBUTE15 in VARCHAR2
,P_ATTRIBUTE16 in VARCHAR2
,P_ATTRIBUTE17 in VARCHAR2
,P_ATTRIBUTE18 in VARCHAR2
,P_ATTRIBUTE19 in VARCHAR2
,P_ATTRIBUTE20 in VARCHAR2
,P_ATTRIBUTE21 in VARCHAR2
,P_ATTRIBUTE22 in VARCHAR2
,P_ATTRIBUTE23 in VARCHAR2
,P_ATTRIBUTE24 in VARCHAR2
,P_ATTRIBUTE25 in VARCHAR2
,P_ATTRIBUTE26 in VARCHAR2
,P_ATTRIBUTE27 in VARCHAR2
,P_ATTRIBUTE28 in VARCHAR2
,P_ATTRIBUTE29 in VARCHAR2
,P_ATTRIBUTE30 in VARCHAR2
,P_COMPLAINANT_PERSON_ID_O in NUMBER
,P_BUSINESS_GROUP_ID_O in NUMBER
,P_DOCKET_NUMBER_O in VARCHAR2
,P_STAGE_O in VARCHAR2
,P_CLASS_FLAG_O in VARCHAR2
,P_MIXED_FLAG_O in VARCHAR2
,P_CONSOLIDATED_FLAG_O in VARCHAR2
,P_REMAND_FLAG_O in VARCHAR2
,P_ACTIVE_FLAG_O in VARCHAR2
,P_INFORMATION_INQUIRY_O in DATE
,P_PCOM_INIT_O in DATE
,P_ALLEG_INCIDENT_O in DATE
,P_ALLEG_DISCRIM_ORG_ID_O in NUMBER
,P_RR_LTR_DATE_O in DATE
,P_RR_LTR_RECVD_O in DATE
,P_PRE_COM_ELEC_O in VARCHAR2
,P_CLASS_AGENT_FLAG_O in VARCHAR2
,P_PRE_COM_DESC_O in VARCHAR2
,P_COUNSELOR_ASG_O in DATE
,P_INIT_COUNSELOR_INTERVIEW_O in DATE
,P_ANONYMITY_REQUESTED_O in VARCHAR2
,P_COUNSEL_EXT_LTR_O in DATE
,P_TRADITIONAL_COUNSEL_OUTCOM_O in VARCHAR2
,P_FINAL_INTERVIEW_O in DATE
,P_NOTICE_RTF_RECVD_O in DATE
,P_PRECOM_CLOSED_O in DATE
,P_PRECOM_CLOSURE_NATURE_O in VARCHAR2
,P_COUNSELOR_RPT_SUB_O in DATE
,P_HR_OFFICE_ORG_ID_O in NUMBER
,P_EEO_OFFICE_ORG_ID_O in NUMBER
,P_SERVICED_ORG_ID_O in NUMBER
,P_FORMAL_COM_FILED_O in DATE
,P_ACK_LTR_O in DATE
,P_CLARIFICATION_LTR_DATE_O in DATE
,P_CLARIFICATION_RESPONSE_REC_O in DATE
,P_FORWARDED_LEGAL_REVIEW_O in DATE
,P_RETURNED_FROM_LEGAL_O in DATE
,P_LETTER_TYPE_O in VARCHAR2
,P_LETTER_DATE_O in DATE
,P_LETTER_RECVD_O in DATE
,P_INVESTIGATION_SOURCE_O in VARCHAR2
,P_INVESTIGATOR_RECVD_REQ_O in DATE
,P_AGENCY_INVESTIGATOR_REQ_O in DATE
,P_INVESTIGATOR_ASG_O in DATE
,P_INVESTIGATION_START_O in DATE
,P_INVESTIGATION_END_O in DATE
,P_INVESTIGATION_EXTENDED_O in DATE
,P_INVEST_EXTENSION_DESC_O in VARCHAR2
,P_AGENCY_RECVD_ROI_O in DATE
,P_COMREP_RECVD_ROI_O in DATE
,P_OPTIONS_LTR_DATE_O in DATE
,P_COMREP_RECVD_OPT_LTR_O in DATE
,P_COMREP_OPT_LTR_RESPONSE_O in VARCHAR2
,P_RESOLUTION_OFFER_O in DATE
,P_COMREP_RESOL_OFFER_RECVD_O in DATE
,P_COMREP_RESOL_OFFER_RESPONS_O in DATE
,P_COMREP_RESOL_OFFER_DESC_O in VARCHAR2
,P_RESOL_OFFER_SIGNED_O in DATE
,P_RESOL_OFFER_DESC_O in VARCHAR2
,P_HEARING_SOURCE_O in VARCHAR2
,P_AGENCY_NOTIFIED_HEARING_O in DATE
,P_EEOC_HEARING_DOCKET_NUM_O in VARCHAR2
,P_HEARING_COMPLETE_O in DATE
,P_AJ_MERIT_DECISION_DATE_O in DATE
,P_AGENCY_RECVD_AJ_MERIT_DEC_O in DATE
,P_AJ_MERIT_DECISION_O in VARCHAR2
,P_AJ_CA_DECISION_DATE_O in DATE
,P_AGENCY_RECVD_AJ_CA_DEC_O in DATE
,P_AJ_CA_DECISION_O in VARCHAR2
,P_FAD_REQUESTED_O in DATE
,P_MERIT_FAD_O in VARCHAR2
,P_ATTORNEY_FEES_FAD_O in VARCHAR2
,P_COMP_DAMAGES_FAD_O in VARCHAR2
,P_NON_COMPLIANCE_FAD_O in VARCHAR2
,P_FAD_REQ_RECVD_EEO_OFFICE_O in DATE
,P_FAD_REQ_FORWD_TO_AGENCY_O in DATE
,P_AGENCY_RECVD_REQUEST_O in DATE
,P_FAD_DUE_O in DATE
,P_FAD_DATE_O in DATE
,P_FAD_DECISION_O in VARCHAR2
,P_FAD_FORWD_TO_COMREP_O in DATE
,P_FAD_RECVD_BY_COMREP_O in DATE
,P_FAD_IMP_LTR_FORWD_TO_ORG_O in DATE
,P_FAD_DECISION_FORWD_LEGAL_O in DATE
,P_FAD_DECISION_RECVD_LEGAL_O in DATE
,P_FA_SOURCE_O in VARCHAR2
,P_FINAL_ACTION_DUE_O in DATE
,P_FINAL_ACT_FORWD_COMREP_O in DATE
,P_FINAL_ACT_RECVD_COMREP_O in DATE
,P_FINAL_ACTION_DECISION_DATE_O in DATE
,P_FINAL_ACTION_DECISION_O in VARCHAR2
,P_FA_IMP_LTR_FORWD_TO_ORG_O in DATE
,P_FA_DECISION_FORWD_LEGAL_O in DATE
,P_FA_DECISION_RECVD_LEGAL_O in DATE
,P_CIVIL_ACTION_FILED_O in DATE
,P_AGENCY_CLOSURE_CONFIRMED_O in DATE
,P_CONSOLIDATED_COMPLAINT_ID_O in NUMBER
,P_CONSOLIDATED_O in DATE
,P_STAGE_OF_CONSOLIDATION_O in VARCHAR2
,P_COMREP_NOTIF_CONSOLIDATION_O in DATE
,P_CONSOLIDATION_DESC_O in VARCHAR2
,P_COMPLAINT_CLOSED_O in DATE
,P_NATURE_OF_CLOSURE_O in VARCHAR2
,P_COMPLAINT_CLOSED_DESC_O in VARCHAR2
,P_FILED_FORMAL_CLASS_O in DATE
,P_FORWD_EEOC_O in DATE
,P_AJ_CERT_DECISION_DATE_O in DATE
,P_AJ_CERT_DECISION_RECVD_O in DATE
,P_AJ_CERT_DECISION_O in VARCHAR2
,P_CLASS_MEMBERS_NOTIFIED_O in DATE
,P_NUMBER_OF_COMPLAINTANTS_O in NUMBER
,P_CLASS_HEARING_O in DATE
,P_AJ_DEC_O in DATE
,P_AGENCY_RECVD_AJ_DEC_O in DATE
,P_AJ_DECISION_O in VARCHAR2
,P_OBJECT_VERSION_NUMBER_O in NUMBER
,P_AGENCY_BRIEF_EEOC_O in DATE
,P_AGENCY_NOTIF_OF_CIVIL_ACTI_O in DATE
,P_FAD_SOURCE_O in VARCHAR2
,P_AGENCY_FILES_FORWARDED_EEO_O in DATE
,P_HEARING_REQ_O in DATE
,P_AGENCY_CODE_O in VARCHAR2
,P_AUDITED_BY_O in VARCHAR2
,P_RECORD_RECEIVED_O in DATE
,P_ATTRIBUTE_CATEGORY_O in VARCHAR2
,P_ATTRIBUTE1_O in VARCHAR2
,P_ATTRIBUTE2_O in VARCHAR2
,P_ATTRIBUTE3_O in VARCHAR2
,P_ATTRIBUTE4_O in VARCHAR2
,P_ATTRIBUTE5_O in VARCHAR2
,P_ATTRIBUTE6_O in VARCHAR2
,P_ATTRIBUTE7_O in VARCHAR2
,P_ATTRIBUTE8_O in VARCHAR2
,P_ATTRIBUTE9_O in VARCHAR2
,P_ATTRIBUTE10_O in VARCHAR2
,P_ATTRIBUTE11_O in VARCHAR2
,P_ATTRIBUTE12_O in VARCHAR2
,P_ATTRIBUTE13_O in VARCHAR2
,P_ATTRIBUTE14_O in VARCHAR2
,P_ATTRIBUTE15_O in VARCHAR2
,P_ATTRIBUTE16_O in VARCHAR2
,P_ATTRIBUTE17_O in VARCHAR2
,P_ATTRIBUTE18_O in VARCHAR2
,P_ATTRIBUTE19_O in VARCHAR2
,P_ATTRIBUTE20_O in VARCHAR2
,P_ATTRIBUTE21_O in VARCHAR2
,P_ATTRIBUTE22_O in VARCHAR2
,P_ATTRIBUTE23_O in VARCHAR2
,P_ATTRIBUTE24_O in VARCHAR2
,P_ATTRIBUTE25_O in VARCHAR2
,P_ATTRIBUTE26_O in VARCHAR2
,P_ATTRIBUTE27_O in VARCHAR2
,P_ATTRIBUTE28_O in VARCHAR2
,P_ATTRIBUTE29_O in VARCHAR2
,P_ATTRIBUTE30_O in VARCHAR2
)is
begin
hr_utility.set_location('Entering: GHR_CMP_RKU.AFTER_UPDATE', 10);

Line: 321

hr_utility.set_location(' Leaving: GHR_CMP_RKU.AFTER_UPDATE', 20);

Line: 322

end AFTER_UPDATE;