1 Package PSP_Report_Template_BK2 as
2 /* $Header: PSPRTAIS.pls 120.1 2005/07/05 23:50:23 dpaudel noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------- Update_Report_Template_b -------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure Update_Report_Template_b
9 (P_TEMPLATE_ID in NUMBER
10 , P_TEMPLATE_NAME in VARCHAR2
11 , P_BUSINESS_GROUP_ID in NUMBER
12 , P_SET_OF_BOOKS_ID in NUMBER
13 , P_REPORT_TYPE in VARCHAR2
14 , P_PERIOD_FREQUENCY_ID in NUMBER
15 , P_REPORT_TEMPLATE_CODE in VARCHAR2
16 , P_DISPLAY_ALL_EMP_DISTRIB_FLAG in VARCHAR2
17 , P_MANUAL_ENTRY_OVERRIDE_FLAG in VARCHAR2
18 , P_APPROVAL_TYPE in VARCHAR2
19 , P_SUP_LEVELS in NUMBER
20 , P_PREVIEW_EFFORT_REPORT_FLAG in VARCHAR2
21 , P_NOTIFICATION_REMINDER in NUMBER
22 , P_SPRCD_TOLERANCE_AMT in NUMBER
23 , P_SPRCD_TOLERANCE_PERCENT in NUMBER
24 , P_DESCRIPTION in VARCHAR2
25 , P_EGISLATION_CODE in VARCHAR2
26 ,P_CUSTOM_APPROVAL_CODE in VARCHAR2
27 , P_HUNDRED_PCENT_EFF_AT_PER_ASG in VARCHAR2
28 , P_SELECTION_MATCH_LEVEL in VARCHAR2
29 );
30 --
31 -- ----------------------------------------------------------------------------
32 -- |------------------------- Update_Report_Template_a -------------------------|
33 -- ----------------------------------------------------------------------------
34 --
35 procedure Update_Report_Template_a
36 ( P_TEMPLATE_ID in NUMBER
37 , P_TEMPLATE_NAME in VARCHAR2
38 , P_BUSINESS_GROUP_ID in NUMBER
39 , P_SET_OF_BOOKS_ID in NUMBER
40 , P_REPORT_TYPE in VARCHAR2
41 , P_PERIOD_FREQUENCY_ID in NUMBER
42 , P_REPORT_TEMPLATE_CODE in VARCHAR2
43 , P_DISPLAY_ALL_EMP_DISTRIB_FLAG in VARCHAR2
44 , P_MANUAL_ENTRY_OVERRIDE_FLAG in VARCHAR2
45 , P_APPROVAL_TYPE in VARCHAR2
46 , P_SUP_LEVELS in NUMBER
47 , P_PREVIEW_EFFORT_REPORT_FLAG in VARCHAR2
48 , P_NOTIFICATION_REMINDER in NUMBER
49 , P_SPRCD_TOLERANCE_AMT in NUMBER
50 , P_SPRCD_TOLERANCE_PERCENT in NUMBER
51 , P_DESCRIPTION in VARCHAR2
52 , P_EGISLATION_CODE in VARCHAR2
53 , P_OBJECT_VERSION_NUMBER in number
54 , P_WARNING in boolean
55 , P_RETURN_STATUS in boolean
56 ,P_CUSTOM_APPROVAL_CODE in VARCHAR2
57 , P_HUNDRED_PCENT_EFF_AT_PER_ASG in VARCHAR2
58 , P_SELECTION_MATCH_LEVEL in VARCHAR2
59 );
60 end PSP_Report_Template_BK2;