eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_COMPLAINANT_APPEALS_BK_2 SQL Statements

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

Line: 5


procedure UPDATE_COMPLAINANT_APPEAL_A
(P_EFFECTIVE_DATE in DATE
,P_COMPLAINT_ID in NUMBER
,P_APPEAL_DATE in DATE
,P_APPEALED_TO in VARCHAR2
,P_REASON_FOR_APPEAL in VARCHAR2
,P_SOURCE_DECISION_DATE in DATE
,P_DOCKET_NUM in VARCHAR2
,P_ORG_NOTIFIED_OF_APPEAL in DATE
,P_AGENCY_RECVD_REQ_FOR_FILES in DATE
,P_FILES_DUE in DATE
,P_FILES_FORWD in DATE
,P_AGCY_RECVD_APPELLANT_BRIEF in DATE
,P_AGENCY_BRIEF_DUE in DATE
,P_APPELLANT_BRIEF_FORWD_ORG in DATE
,P_ORG_FORWD_BRIEF_TO_AGENCY in DATE
,P_AGENCY_BRIEF_FORWD 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 in VARCHAR2
,P_RFR_DECISION_DATE in DATE
,P_AGENCY_RECVD_RFR_DEC in DATE
,P_RFR_DECISION_FORWD_TO_ORG in DATE
,P_COMPL_APPEAL_ID in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
)is
begin
hr_utility.set_location('Entering: GHR_COMPLAINANT_APPEALS_BK_2.UPDATE_COMPLAINANT_APPEAL_A', 10);

Line: 43


hr_utility.set_location(' Leaving: GHR_COMPLAINANT_APPEALS_BK_2.UPDATE_COMPLAINANT_APPEAL_A', 20);

Line: 44


end UPDATE_COMPLAINANT_APPEAL_A;

Line: 45


procedure UPDATE_COMPLAINANT_APPEAL_B
(P_EFFECTIVE_DATE in DATE
,P_COMPLAINT_ID in NUMBER
,P_APPEAL_DATE in DATE
,P_APPEALED_TO in VARCHAR2
,P_REASON_FOR_APPEAL in VARCHAR2
,P_SOURCE_DECISION_DATE in DATE
,P_DOCKET_NUM in VARCHAR2
,P_ORG_NOTIFIED_OF_APPEAL in DATE
,P_AGENCY_RECVD_REQ_FOR_FILES in DATE
,P_FILES_DUE in DATE
,P_FILES_FORWD in DATE
,P_AGCY_RECVD_APPELLANT_BRIEF in DATE
,P_AGENCY_BRIEF_DUE in DATE
,P_APPELLANT_BRIEF_FORWD_ORG in DATE
,P_ORG_FORWD_BRIEF_TO_AGENCY in DATE
,P_AGENCY_BRIEF_FORWD 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 in VARCHAR2
,P_RFR_DECISION_DATE in DATE
,P_AGENCY_RECVD_RFR_DEC in DATE
,P_RFR_DECISION_FORWD_TO_ORG in DATE
,P_COMPL_APPEAL_ID in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
)is
begin
hr_utility.set_location('Entering: GHR_COMPLAINANT_APPEALS_BK_2.UPDATE_COMPLAINANT_APPEAL_B', 10);

Line: 83


hr_utility.set_location(' Leaving: GHR_COMPLAINANT_APPEALS_BK_2.UPDATE_COMPLAINANT_APPEAL_B', 20);

Line: 84


end UPDATE_COMPLAINANT_APPEAL_B;