The following lines contain the word 'select', 'insert', 'update' or 'delete':
, P_SELECTION_MATCH_LEVEL in VARCHAR2
) is
--
-- Declare cursors and local variables
--
-- l_in_out_parameter number;
select distinct Template_Name
from Psp_Report_Templates
where Template_Name = P_TEMPLATE_NAME
and report_type = p_report_type ;
,P_SELECTION_MATCH_LEVEL => P_SELECTION_MATCH_LEVEL
);
,P_SELECTION_MATCH_LEVEL => P_SELECTION_MATCH_LEVEL
);
,P_SELECTION_MATCH_LEVEL => P_SELECTION_MATCH_LEVEL
);
procedure Update_Report_Template
(P_VALIDATE in boolean default false
, 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 out nocopy NUMBER
, P_WARNING out nocopy boolean
, P_RETURN_STATUS out nocopy boolean
,P_CUSTOM_APPROVAL_CODE in VARCHAR2
, P_HUNDRED_PCENT_EFF_AT_PER_ASG in VARCHAR2
, P_SELECTION_MATCH_LEVEL in VARCHAR2
) is
--
-- Declare cursors and local variables
--
l_in_out_parameter number;
savepoint Update_Report_Template;
PSP_Report_Template_BK2.Update_Report_Template_b
( P_TEMPLATE_ID => P_TEMPLATE_ID
, P_TEMPLATE_NAME => P_TEMPLATE_NAME
, P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
, P_SET_OF_BOOKS_ID => P_SET_OF_BOOKS_ID
, P_REPORT_TYPE => P_REPORT_TYPE
, P_PERIOD_FREQUENCY_ID => P_PERIOD_FREQUENCY_ID
, P_REPORT_TEMPLATE_CODE => P_REPORT_TEMPLATE_CODE
, P_DISPLAY_ALL_EMP_DISTRIB_FLAG => P_DISPLAY_ALL_EMP_DISTRIB_FLAG
, P_MANUAL_ENTRY_OVERRIDE_FLAG => P_MANUAL_ENTRY_OVERRIDE_FLAG
, P_APPROVAL_TYPE => P_APPROVAL_TYPE
, P_SUP_LEVELS => P_SUP_LEVELS
, P_PREVIEW_EFFORT_REPORT_FLAG => P_PREVIEW_EFFORT_REPORT_FLAG
, P_NOTIFICATION_REMINDER => P_NOTIFICATION_REMINDER
, P_SPRCD_TOLERANCE_AMT => P_SPRCD_TOLERANCE_AMT
, P_SPRCD_TOLERANCE_PERCENT => P_SPRCD_TOLERANCE_PERCENT
, P_DESCRIPTION => P_DESCRIPTION
, P_EGISLATION_CODE => P_EGISLATION_CODE
,P_CUSTOM_APPROVAL_CODE => P_CUSTOM_APPROVAL_CODE
,P_HUNDRED_PCENT_EFF_AT_PER_ASG => P_HUNDRED_PCENT_EFF_AT_PER_ASG
,P_SELECTION_MATCH_LEVEL => P_SELECTION_MATCH_LEVEL
);
(p_module_name => 'Update_Report_Template'
,p_hook_type => 'BP'
);
,P_SELECTION_MATCH_LEVEL => P_SELECTION_MATCH_LEVEL
);
PSP_Report_Template_BK2.Update_Report_Template_a
( P_TEMPLATE_ID => P_TEMPLATE_ID
, P_TEMPLATE_NAME => P_TEMPLATE_NAME
, P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
, P_SET_OF_BOOKS_ID => P_SET_OF_BOOKS_ID
, P_REPORT_TYPE => P_REPORT_TYPE
, P_PERIOD_FREQUENCY_ID => P_PERIOD_FREQUENCY_ID
, P_REPORT_TEMPLATE_CODE => P_REPORT_TEMPLATE_CODE
, P_DISPLAY_ALL_EMP_DISTRIB_FLAG => P_DISPLAY_ALL_EMP_DISTRIB_FLAG
, P_MANUAL_ENTRY_OVERRIDE_FLAG => P_MANUAL_ENTRY_OVERRIDE_FLAG
, P_APPROVAL_TYPE => P_APPROVAL_TYPE
, P_SUP_LEVELS => P_SUP_LEVELS
, P_PREVIEW_EFFORT_REPORT_FLAG => P_PREVIEW_EFFORT_REPORT_FLAG
, P_NOTIFICATION_REMINDER => P_NOTIFICATION_REMINDER
, P_SPRCD_TOLERANCE_AMT => P_SPRCD_TOLERANCE_AMT
, P_SPRCD_TOLERANCE_PERCENT => P_SPRCD_TOLERANCE_PERCENT
, P_DESCRIPTION => P_DESCRIPTION
, P_EGISLATION_CODE => P_EGISLATION_CODE
, P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
, P_WARNING => P_WARNING
, P_RETURN_STATUS => P_RETURN_STATUS
,P_CUSTOM_APPROVAL_CODE => P_CUSTOM_APPROVAL_CODE
,P_HUNDRED_PCENT_EFF_AT_PER_ASG => P_HUNDRED_PCENT_EFF_AT_PER_ASG
,P_SELECTION_MATCH_LEVEL => P_SELECTION_MATCH_LEVEL
);
(p_module_name => 'Update_Report_Template'
,p_hook_type => 'AP'
);
rollback to Update_Report_Template;
rollback to Update_Report_Template;
end Update_Report_Template;
procedure Delete_Report_Template
( P_VALIDATE in BOOLEAN default false
,P_TEMPLATE_ID in number
,P_OBJECT_VERSION_NUMBER in out nocopy number
,P_WARNING out nocopy varchar2
) is
--
-- Declare cursors and local variables
--
l_in_out_parameter number;
savepoint Delete_Report_template;
PSP_Report_Template_BK3.Delete_Report_template_b
( P_TEMPLATE_ID => P_TEMPLATE_ID
);
(p_module_name => 'Delete_Report_template'
,p_hook_type => 'BP'
);
PSP_Report_Template_BK3.Delete_Report_template_a
( P_TEMPLATE_ID => P_TEMPLATE_ID
,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
,P_WARNING => P_WARNING
);
(p_module_name => 'Delete_Report_template'
,p_hook_type => 'AP'
);
rollback to Delete_Report_template;
rollback to Delete_Report_template;
end Delete_Report_template;