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

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

Line: 5


procedure AFTER_DELETE
(P_TEMPLATE_ID in NUMBER
,P_TEMPLATE_NAME_O in VARCHAR2
,P_BUSINESS_GROUP_ID_O in NUMBER
,P_SET_OF_BOOKS_ID_O in NUMBER
,P_OBJECT_VERSION_NUMBER_O in NUMBER
,P_REPORT_TYPE_O in VARCHAR2
,P_PERIOD_FREQUENCY_ID_O in NUMBER
,P_REPORT_TEMPLATE_CODE_O in VARCHAR2
,P_DISPLAY_ALL_EMP_DISTRIB_FL_O in VARCHAR2
,P_MANUAL_ENTRY_OVERRIDE_FLAG_O in VARCHAR2
,P_APPROVAL_TYPE_O in VARCHAR2
,P_CUSTOM_APPROVAL_CODE_O in VARCHAR2
,P_SUP_LEVELS_O in NUMBER
,P_PREVIEW_EFFORT_REPORT_FLAG_O in VARCHAR2
,P_NOTIFICATION_REMINDER_IN_D_O in NUMBER
,P_SPRCD_TOLERANCE_AMT_O in NUMBER
,P_SPRCD_TOLERANCE_PERCENT_O in NUMBER
,P_DESCRIPTION_O in VARCHAR2
,P_LEGISLATION_CODE_O in VARCHAR2
,P_HUNDRED_PCENT_EFF_AT_PER_A_O in VARCHAR2
,P_SELECTION_MATCH_LEVEL_O in VARCHAR2
)is
begin
hr_utility.set_location('Entering: PSP_PRT_RKD.AFTER_DELETE', 10);

Line: 30


hr_utility.set_location(' Leaving: PSP_PRT_RKD.AFTER_DELETE', 20);

Line: 31


end AFTER_DELETE;