APPS.GHR_CAH_RKI SQL Statements

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

Line: 5

procedure AFTER_INSERT
(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
)is
begin
hr_utility.set_location('Entering: GHR_CAH_RKI.AFTER_INSERT', 10);

Line: 33

hr_utility.set_location(' Leaving: GHR_CAH_RKI.AFTER_INSERT', 20);

Line: 34

end AFTER_INSERT;