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_CCL_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_CLAIM_ID in NUMBER
,P_COMPLAINT_ID in NUMBER
,P_CLAIM in VARCHAR2
,P_INCIDENT_DATE in DATE
,P_PHASE in VARCHAR2
,P_MIXED_FLAG in VARCHAR2
,P_CLAIM_SOURCE in VARCHAR2
,P_AGENCY_ACCEPTANCE in VARCHAR2
,P_AJ_ACCEPTANCE in VARCHAR2
,P_AGENCY_APPEAL in VARCHAR2
,P_COMPLAINT_ID_O in NUMBER
,P_CLAIM_O in VARCHAR2
,P_INCIDENT_DATE_O in DATE
,P_PHASE_O in VARCHAR2
,P_MIXED_FLAG_O in VARCHAR2
,P_CLAIM_SOURCE_O in VARCHAR2
,P_AGENCY_ACCEPTANCE_O in VARCHAR2
,P_AJ_ACCEPTANCE_O in VARCHAR2
,P_AGENCY_APPEAL_O in VARCHAR2
)is
begin
hr_utility.set_location('Entering: GHR_CCL_RKU.AFTER_UPDATE', 10);

Line: 29


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

Line: 30


end AFTER_UPDATE;