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_CAD_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_ADR_ID in NUMBER
,P_COMPLAINT_ID in NUMBER
,P_STAGE in VARCHAR2
,P_START_DATE in DATE
,P_END_DATE in DATE
,P_ADR_RESOURCE in VARCHAR2
,P_TECHNIQUE in VARCHAR2
,P_OUTCOME in VARCHAR2
,P_ADR_OFFERED in VARCHAR2
,P_DATE_ACCEPTED in DATE
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_COMPLAINT_ID_O in NUMBER
,P_STAGE_O in VARCHAR2
,P_START_DATE_O in DATE
,P_END_DATE_O in DATE
,P_ADR_RESOURCE_O in VARCHAR2
,P_TECHNIQUE_O in VARCHAR2
,P_OUTCOME_O in VARCHAR2
,P_ADR_OFFERED_O in VARCHAR2
,P_DATE_ACCEPTED_O in DATE
,P_OBJECT_VERSION_NUMBER_O in NUMBER
)is
begin
hr_utility.set_location('Entering: GHR_CAD_RKU.AFTER_UPDATE', 10);

Line: 31


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

Line: 32


end AFTER_UPDATE;