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.PQH_TEM_RKU SQL Statements

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

Line: 5


procedure AFTER_UPDATE
(P_TEMPLATE_NAME in VARCHAR2
,P_SHORT_NAME in VARCHAR2
,P_TEMPLATE_ID in NUMBER
,P_ATTRIBUTE_ONLY_FLAG in VARCHAR2
,P_ENABLE_FLAG in VARCHAR2
,P_CREATE_FLAG in VARCHAR2
,P_TRANSACTION_CATEGORY_ID in NUMBER
,P_UNDER_REVIEW_FLAG in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_FREEZE_STATUS_CD in VARCHAR2
,P_TEMPLATE_TYPE_CD in VARCHAR2
,P_LEGISLATION_CODE in VARCHAR2
,P_EFFECTIVE_DATE in DATE
,P_TEMPLATE_NAME_O in VARCHAR2
,P_SHORT_NAME_O in VARCHAR2
,P_ATTRIBUTE_ONLY_FLAG_O in VARCHAR2
,P_ENABLE_FLAG_O in VARCHAR2
,P_CREATE_FLAG_O in VARCHAR2
,P_TRANSACTION_CATEGORY_ID_O in NUMBER
,P_UNDER_REVIEW_FLAG_O in VARCHAR2
,P_OBJECT_VERSION_NUMBER_O in NUMBER
,P_FREEZE_STATUS_CD_O in VARCHAR2
,P_TEMPLATE_TYPE_CD_O in VARCHAR2
,P_LEGISLATION_CODE_O in VARCHAR2
)is
begin
hr_utility.set_location('Entering: PQH_TEM_RKU.AFTER_UPDATE', 10);

Line: 33


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

Line: 34


end AFTER_UPDATE;