[Home] [Help]
PACKAGE: APPS.PSP_REPORT_TEMPLATE_API
Source
1 Package PSP_Report_Template_API as
2 /* $Header: PSPRTAIS.pls 120.1 2005/07/05 23:50:23 dpaudel noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-------------------------- Create_Report_Template --------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 --
12 -- Prerequisites:
13 --
14 --
15 -- In Parameters:
16 -- Name Reqd Type Description
17 --
18 --
19 -- Post Success:
20 --
21 --
22 -- Name Type Description
23 --
24 -- Post Failure:
25 --
26 --
27 -- Access Status:
28 -- Public.
29 --
30 -- {End Of Comments}
31 --
32 --
33 -- ----------------------------------------------------------------------------
34 -- |--------------------------< Create_Report_Template >--------------------------|
35 -- ----------------------------------------------------------------------------
36 --
37 procedure Create_Report_Template
38 (P_VALIDATE in boolean default false
39 , P_TEMPLATE_ID in NUMBER
40 , P_TEMPLATE_NAME in VARCHAR2
41 , P_BUSINESS_GROUP_ID in NUMBER
42 , P_SET_OF_BOOKS_ID in NUMBER
43 , P_REPORT_TYPE in VARCHAR2
44 , P_PERIOD_FREQUENCY_ID in NUMBER
45 , P_REPORT_TEMPLATE_CODE in VARCHAR2
46 , P_DISPLAY_ALL_EMP_DISTRIB_FLAG in VARCHAR2
47 , P_MANUAL_ENTRY_OVERRIDE_FLAG in VARCHAR2
48 , P_APPROVAL_TYPE in VARCHAR2
49 , P_SUP_LEVELS in NUMBER
50 , P_PREVIEW_EFFORT_REPORT_FLAG in VARCHAR2
51 , P_NOTIFICATION_REMINDER in NUMBER
52 , P_SPRCD_TOLERANCE_AMT in NUMBER
53 , P_SPRCD_TOLERANCE_PERCENT in NUMBER
54 , P_DESCRIPTION in VARCHAR2
55 , P_EGISLATION_CODE in VARCHAR2
56 , P_OBJECT_VERSION_NUMBER out nocopy NUMBER
57 , P_WARNING out nocopy boolean
58 , P_RETURN_STATUS out nocopy boolean
59 , P_CUSTOM_APPROVAL_CODE in VARCHAR2
60 , P_HUNDRED_PCENT_EFF_AT_PER_ASG in VARCHAR2
61 , P_SELECTION_MATCH_LEVEL in VARCHAR2
62 );
63 --
64 -- ----------------------------------------------------------------------------
65 -- |--------------------------< Update_Report_Template >--------------------------|
66 -- ----------------------------------------------------------------------------
67 --
68 procedure Update_Report_Template
69 (P_VALIDATE in boolean default false
70 , P_TEMPLATE_ID in NUMBER
71 , P_TEMPLATE_NAME in VARCHAR2
72 , P_BUSINESS_GROUP_ID in NUMBER
73 , P_SET_OF_BOOKS_ID in NUMBER
74 , P_REPORT_TYPE in VARCHAR2
75 , P_PERIOD_FREQUENCY_ID in NUMBER
76 , P_REPORT_TEMPLATE_CODE in VARCHAR2
77 , P_DISPLAY_ALL_EMP_DISTRIB_FLAG in VARCHAR2
78 , P_MANUAL_ENTRY_OVERRIDE_FLAG in VARCHAR2
79 , P_APPROVAL_TYPE in VARCHAR2
80 , P_SUP_LEVELS in NUMBER
81 , P_PREVIEW_EFFORT_REPORT_FLAG in VARCHAR2
82 , P_NOTIFICATION_REMINDER in NUMBER
83 , P_SPRCD_TOLERANCE_AMT in NUMBER
84 , P_SPRCD_TOLERANCE_PERCENT in NUMBER
85 , P_DESCRIPTION in VARCHAR2
86 , P_EGISLATION_CODE in VARCHAR2
87 , P_OBJECT_VERSION_NUMBER in out nocopy NUMBER
88 , P_WARNING out nocopy boolean
89 , P_RETURN_STATUS out nocopy boolean
90 ,P_CUSTOM_APPROVAL_CODE in VARCHAR2
91 , P_HUNDRED_PCENT_EFF_AT_PER_ASG in VARCHAR2
92 , P_SELECTION_MATCH_LEVEL in VARCHAR2
93 );
94 --
95 -- ----------------------------------------------------------------------------
96 -- |--------------------------< Delete_Report_Template >--------------------------|
97 -- ----------------------------------------------------------------------------
98 --
99 procedure Delete_Report_Template
100 (P_VALIDATE in BOOLEAN default false
101 ,P_TEMPLATE_ID in number
102 ,P_OBJECT_VERSION_NUMBER in out nocopy number
103 ,P_WARNING out nocopy varchar2
104 );
105 end PSP_Report_Template_API;