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.OTA_CTL_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_CERTIFICATION_ID in NUMBER
,P_LANGUAGE in VARCHAR2
,P_NAME in VARCHAR2
,P_DESCRIPTION in VARCHAR2
,P_OBJECTIVES in VARCHAR2
,P_PURPOSE in VARCHAR2
,P_KEYWORDS in VARCHAR2
,P_END_DATE_COMMENTS in VARCHAR2
,P_INITIAL_PERIOD_COMMENTS in VARCHAR2
,P_RENEWAL_PERIOD_COMMENTS in VARCHAR2
,P_SOURCE_LANG in VARCHAR2
,P_NAME_O in VARCHAR2
,P_DESCRIPTION_O in VARCHAR2
,P_OBJECTIVES_O in VARCHAR2
,P_PURPOSE_O in VARCHAR2
,P_KEYWORDS_O in VARCHAR2
,P_END_DATE_COMMENTS_O in VARCHAR2
,P_INITIAL_PERIOD_COMMENTS_O in VARCHAR2
,P_RENEWAL_PERIOD_COMMENTS_O in VARCHAR2
,P_SOURCE_LANG_O in VARCHAR2
)is
begin
hr_utility.set_location('Entering: OTA_CTL_RKU.AFTER_UPDATE', 10);

Line: 30


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

Line: 31


end AFTER_UPDATE;