1 Package psp_report_template_swi As
2 /* $Header: PSPRTSWS.pls 120.1 2005/07/05 23:50 dpaudel noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |------------------------< create_report_template >------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: psp_report_template_api.create_report_template
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_report_template
27 (p_validate in number default hr_api.g_false_num
28 ,p_template_id in number
29 ,p_template_name in varchar2
30 ,p_business_group_id in number
31 ,p_set_of_books_id in number
32 ,p_report_type in varchar2
33 ,p_period_frequency_id in number
34 ,p_report_template_code in varchar2
35 ,p_display_all_emp_distrib_flag in varchar2
36 ,p_manual_entry_override_flag in varchar2
37 ,p_approval_type in varchar2
38 ,p_sup_levels in number
39 ,p_preview_effort_report_flag in varchar2
40 ,p_notification_reminder in number
41 ,p_sprcd_tolerance_amt in number
42 ,p_sprcd_tolerance_percent in number
43 ,p_description in varchar2
44 ,p_egislation_code in varchar2
45 ,p_object_version_number out nocopy number
46 ,p_return_status_from_api out nocopy number
47 ,p_custom_approval_code in varchar2
48 ,p_hundred_pcent_eff_at_per_asg in varchar2
49 ,p_selection_match_level in varchar2
50 ,p_return_status out nocopy varchar2
51 );
52 -- ----------------------------------------------------------------------------
53 -- |------------------------< update_report_template >------------------------|
54 -- ----------------------------------------------------------------------------
55 -- {Start of comments}
56 --
57 -- Description:
58 -- This procedure is the self-service wrapper procedure to the following
59 -- API: psp_report_template_api.update_report_template
60 --
61 -- Pre-requisites
62 -- All 'IN' parameters to this procedure have been appropriately derived.
63 --
64 -- Post Success:
65 -- p_return_status will return value indicating success.
66 --
67 -- Post Failure:
68 -- p_return_status will return value indication failure.
69 --
70 -- Access Status:
71 -- Internal Development use only.
72 --
73 -- {End of comments}
74 -- ----------------------------------------------------------------------------
75 PROCEDURE update_report_template
76 (p_validate in number default hr_api.g_false_num
77 ,p_template_id in number
78 ,p_template_name in varchar2
79 ,p_business_group_id in number
80 ,p_set_of_books_id in number
81 ,p_report_type in varchar2
82 ,p_period_frequency_id in number
83 ,p_report_template_code in varchar2
84 ,p_display_all_emp_distrib_flag in varchar2
85 ,p_manual_entry_override_flag in varchar2
86 ,p_approval_type in varchar2
87 ,p_sup_levels in number
88 ,p_preview_effort_report_flag in varchar2
89 ,p_notification_reminder in number
90 ,p_sprcd_tolerance_amt in number
91 ,p_sprcd_tolerance_percent in number
92 ,p_description in varchar2
93 ,p_egislation_code in varchar2
94 ,p_object_version_number in out nocopy number
95 ,p_return_status_from_api out nocopy number
96 ,p_custom_approval_code in varchar2
97 ,p_hundred_pcent_eff_at_per_asg in varchar2
98 ,p_selection_match_level in varchar2
99 ,p_return_status out nocopy varchar2
100 );
101 -- ----------------------------------------------------------------------------
102 -- |------------------------< delete_report_template >------------------------|
103 -- ----------------------------------------------------------------------------
104 -- {Start of comments}
105 --
106 -- Description:
107 -- This procedure is the self-service wrapper procedure to the following
108 -- API: psp_report_template_api.delete_report_template
109 --
110 -- Pre-requisites
111 -- All 'IN' parameters to this procedure have been appropriately derived.
112 --
113 -- Post Success:
114 -- p_return_status will return value indicating success.
115 --
116 -- Post Failure:
117 -- p_return_status will return value indication failure.
118 --
119 -- Access Status:
120 -- Internal Development use only.
121 --
122 -- {End of comments}
123 -- ----------------------------------------------------------------------------
124 PROCEDURE delete_report_template
125 (p_validate in number default hr_api.g_false_num
126 ,p_template_id in number
127 ,p_object_version_number in out nocopy number
128 ,p_warning out nocopy varchar2
129 ,p_return_status out nocopy varchar2
130 );
131 end psp_report_template_swi;