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_REPORT_TEMPLATE_BK2 SQL Statements

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

Line: 5


procedure UPDATE_REPORT_TEMPLATE_A
(P_TEMPLATE_ID in NUMBER
,P_TEMPLATE_NAME in VARCHAR2
,P_BUSINESS_GROUP_ID in NUMBER
,P_SET_OF_BOOKS_ID in NUMBER
,P_REPORT_TYPE in VARCHAR2
,P_PERIOD_FREQUENCY_ID in NUMBER
,P_REPORT_TEMPLATE_CODE in VARCHAR2
,P_DISPLAY_ALL_EMP_DISTRIB_FLAG in VARCHAR2
,P_MANUAL_ENTRY_OVERRIDE_FLAG in VARCHAR2
,P_APPROVAL_TYPE in VARCHAR2
,P_SUP_LEVELS in NUMBER
,P_PREVIEW_EFFORT_REPORT_FLAG in VARCHAR2
,P_NOTIFICATION_REMINDER in NUMBER
,P_SPRCD_TOLERANCE_AMT in NUMBER
,P_SPRCD_TOLERANCE_PERCENT in NUMBER
,P_DESCRIPTION in VARCHAR2
,P_EGISLATION_CODE in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_WARNING in BOOLEAN
,P_RETURN_STATUS in BOOLEAN
,P_CUSTOM_APPROVAL_CODE in VARCHAR2
,P_HUNDRED_PCENT_EFF_AT_PER_ASG in VARCHAR2
,P_SELECTION_MATCH_LEVEL in VARCHAR2
)is
begin
hr_utility.set_location('Entering: PSP_REPORT_TEMPLATE_BK2.UPDATE_REPORT_TEMPLATE_A', 10);

Line: 32


hr_utility.set_location(' Leaving: PSP_REPORT_TEMPLATE_BK2.UPDATE_REPORT_TEMPLATE_A', 20);

Line: 33


end UPDATE_REPORT_TEMPLATE_A;

Line: 34


procedure UPDATE_REPORT_TEMPLATE_B
(P_TEMPLATE_ID in NUMBER
,P_TEMPLATE_NAME in VARCHAR2
,P_BUSINESS_GROUP_ID in NUMBER
,P_SET_OF_BOOKS_ID in NUMBER
,P_REPORT_TYPE in VARCHAR2
,P_PERIOD_FREQUENCY_ID in NUMBER
,P_REPORT_TEMPLATE_CODE in VARCHAR2
,P_DISPLAY_ALL_EMP_DISTRIB_FLAG in VARCHAR2
,P_MANUAL_ENTRY_OVERRIDE_FLAG in VARCHAR2
,P_APPROVAL_TYPE in VARCHAR2
,P_SUP_LEVELS in NUMBER
,P_PREVIEW_EFFORT_REPORT_FLAG in VARCHAR2
,P_NOTIFICATION_REMINDER in NUMBER
,P_SPRCD_TOLERANCE_AMT in NUMBER
,P_SPRCD_TOLERANCE_PERCENT in NUMBER
,P_DESCRIPTION in VARCHAR2
,P_EGISLATION_CODE in VARCHAR2
,P_CUSTOM_APPROVAL_CODE in VARCHAR2
,P_HUNDRED_PCENT_EFF_AT_PER_ASG in VARCHAR2
,P_SELECTION_MATCH_LEVEL in VARCHAR2
)is
begin
hr_utility.set_location('Entering: PSP_REPORT_TEMPLATE_BK2.UPDATE_REPORT_TEMPLATE_B', 10);

Line: 58


hr_utility.set_location(' Leaving: PSP_REPORT_TEMPLATE_BK2.UPDATE_REPORT_TEMPLATE_B', 20);

Line: 59


end UPDATE_REPORT_TEMPLATE_B;