APPS.GHR_CAA_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_AGENCY_APPEAL_ID in NUMBER
,P_COMPLAINT_ID in NUMBER
,P_APPEAL_DATE in DATE
,P_REASON_FOR_APPEAL in VARCHAR2
,P_SOURCE_DECISION_DATE in DATE
,P_DOCKET_NUM in VARCHAR2
,P_AGENCY_RECVD_REQ_FOR_FILES in DATE
,P_FILES_DUE in DATE
,P_FILES_FORWD in DATE
,P_AGENCY_BRIEF_DUE in DATE
,P_AGENCY_BRIEF_FORWD in DATE
,P_AGENCY_RECVD_APPELLANT_BRIEF in DATE
,P_DECISION_DATE in DATE
,P_DEC_RECVD_BY_AGENCY in DATE
,P_DECISION in VARCHAR2
,P_DEC_FORWD_TO_ORG in DATE
,P_AGENCY_RFR_SUSPENSE in DATE
,P_REQUEST_FOR_RFR in DATE
,P_RFR_DOCKET_NUM in VARCHAR2
,P_RFR_REQUESTED_BY in VARCHAR2
,P_AGENCY_RFR_DUE in DATE
,P_RFR_FORWD_TO_ORG in DATE
,P_ORG_FORWD_RFR_TO_AGENCY in DATE
,P_AGENCY_FORWD_RFR_OFO in DATE
,P_RFR_DECISION_DATE in DATE
,P_AGENCY_RECVD_RFR_DEC in DATE
,P_RFR_DECISION_FORWD_TO_ORG in DATE
,P_RFR_DECISION in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
)is
begin
hr_utility.set_location('Entering: GHR_CAA_RKI.AFTER_INSERT', 10);

Line: 39

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

Line: 40

end AFTER_INSERT;