APPS.GHR_CAH_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_COMPL_CA_HEADER_ID in NUMBER
,P_COMPLAINT_ID in NUMBER
,P_CA_SOURCE in VARCHAR2
,P_LAST_COMPLIANCE_REPORT in DATE
,P_COMPLIANCE_CLOSED in DATE
,P_COMPL_DOCKET_NUMBER in VARCHAR2
,P_APPEAL_DOCKET_NUMBER in VARCHAR2
,P_PFE_DOCKET_NUMBER in VARCHAR2
,P_PFE_RECEIVED in DATE
,P_AGENCY_BRIEF_PFE_DUE in DATE
,P_AGENCY_BRIEF_PFE_DATE in DATE
,P_DECISION_PFE_DATE in DATE
,P_DECISION_PFE in VARCHAR2
,P_AGENCY_RECVD_PFE_DECISION in DATE
,P_AGENCY_PFE_BRIEF_FORWD in DATE
,P_AGENCY_NOTIFIED_NONCOM in DATE
,P_COMREP_NONCOM_REQ in VARCHAR2
,P_EEO_OFF_REQ_DATA_FROM_ORG in DATE
,P_ORG_FORWD_DATA_TO_EEO_OFF in DATE
,P_DEC_IMPLEMENTED in DATE
,P_COMPLAINT_REINSTATED in DATE
,P_STAGE_COMPLAINT_REINSTATED in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_COMPLAINT_ID_O in NUMBER
,P_CA_SOURCE_O in VARCHAR2
,P_LAST_COMPLIANCE_REPORT_O in DATE
,P_COMPLIANCE_CLOSED_O in DATE
,P_COMPL_DOCKET_NUMBER_O in VARCHAR2
,P_APPEAL_DOCKET_NUMBER_O in VARCHAR2
,P_PFE_DOCKET_NUMBER_O in VARCHAR2
,P_PFE_RECEIVED_O in DATE
,P_AGENCY_BRIEF_PFE_DUE_O in DATE
,P_AGENCY_BRIEF_PFE_DATE_O in DATE
,P_DECISION_PFE_DATE_O in DATE
,P_DECISION_PFE_O in VARCHAR2
,P_AGENCY_RECVD_PFE_DECISION_O in DATE
,P_AGENCY_PFE_BRIEF_FORWD_O in DATE
,P_AGENCY_NOTIFIED_NONCOM_O in DATE
,P_COMREP_NONCOM_REQ_O in VARCHAR2
,P_EEO_OFF_REQ_DATA_FROM_ORG_O in DATE
,P_ORG_FORWD_DATA_TO_EEO_OFF_O in DATE
,P_DEC_IMPLEMENTED_O in DATE
,P_COMPLAINT_REINSTATED_O in DATE
,P_STAGE_COMPLAINT_REINSTATED_O in VARCHAR2
,P_OBJECT_VERSION_NUMBER_O in NUMBER
)is
begin
hr_utility.set_location('Entering: GHR_CAH_RKU.AFTER_UPDATE', 10);

Line: 55

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

Line: 56

end AFTER_UPDATE;