1 Package pqp_exr_swi AUTHID CURRENT_USER As
2 /* $Header: pqexrswi.pkh 120.1.12020000.1 2012/06/29 05:02:15 appldev ship $ */
3 -- ----------------------------------------------------------------------------
4 -- |------------------------< create_exception_report >-----------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: pqp_exr_api.create_exception_report
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_exception_report
27 (p_validate in number default hr_api.g_false_num
28 ,p_exception_report_name in varchar2
29 ,p_legislation_code in varchar2 default null
30 ,p_business_group_id in number default null
31 ,p_currency_code in varchar2 default null
32 ,p_balance_type_id in number default null
33 ,p_balance_dimension_id in number default null
34 ,p_variance_type in varchar2 default null
35 ,p_variance_value in number default null
36 ,p_comparison_type in varchar2 default null
37 ,p_comparison_value in number default null
38 ,p_language_code in varchar2 default null
39 ,p_exception_report_id out nocopy number
40 ,p_object_version_number out nocopy number
41 ,p_output_format_type in varchar2
42 ,p_variance_operator in varchar2
43 ,p_return_status out nocopy varchar2
44 );
45 -- ----------------------------------------------------------------------------
46 -- |------------------------< delete_exception_report >-----------------------|
47 -- ----------------------------------------------------------------------------
48 -- {Start of comments}
49 --
50 -- Description:
51 -- This procedure is the self-service wrapper procedure to the following
52 -- API: pqp_exr_api.delete_exception_report
53 --
54 -- Pre-requisites
55 -- All 'IN' parameters to this procedure have been appropriately derived.
56 --
57 -- Post Success:
58 -- p_return_status will return value indicating success.
59 --
60 -- Post Failure:
61 -- p_return_status will return value indication failure.
62 --
63 -- Access Status:
64 -- Internal Development use only.
65 --
66 -- {End of comments}
67 -- ----------------------------------------------------------------------------
68 PROCEDURE delete_exception_report
69 (p_validate in number default hr_api.g_false_num
70 ,p_exception_report_id in number
71 ,p_object_version_number in number
72 ,p_return_status out nocopy varchar2
73 );
74 -- ----------------------------------------------------------------------------
75 -- |------------------------< update_exception_report >-----------------------|
76 -- ----------------------------------------------------------------------------
77 -- {Start of comments}
78 --
79 -- Description:
80 -- This procedure is the self-service wrapper procedure to the following
81 -- API: pqp_exr_api.update_exception_report
82 --
83 -- Pre-requisites
84 -- All 'IN' parameters to this procedure have been appropriately derived.
85 --
86 -- Post Success:
87 -- p_return_status will return value indicating success.
88 --
89 -- Post Failure:
90 -- p_return_status will return value indication failure.
91 --
92 -- Access Status:
93 -- Internal Development use only.
94 --
95 -- {End of comments}
96 -- ----------------------------------------------------------------------------
97 PROCEDURE update_exception_report
98 (p_validate in number default hr_api.g_false_num
99 ,p_exception_report_name in varchar2 default hr_api.g_varchar2
100 ,p_legislation_code in varchar2 default hr_api.g_varchar2
101 ,p_business_group_id in number default hr_api.g_number
102 ,p_currency_code in varchar2 default hr_api.g_varchar2
103 ,p_balance_type_id in number default hr_api.g_number
104 ,p_balance_dimension_id in number default hr_api.g_number
105 ,p_variance_type in varchar2 default hr_api.g_varchar2
106 ,p_variance_value in number default hr_api.g_number
107 ,p_comparison_type in varchar2 default hr_api.g_varchar2
108 ,p_comparison_value in number default hr_api.g_number
109 ,p_exception_report_id in number default hr_api.g_number
110 ,p_language_code in varchar2 default hr_api.g_varchar2
111 ,p_object_version_number in out nocopy number
112 ,p_output_format_type in varchar2 default hr_api.g_varchar2
113 ,p_variance_operator in varchar2 default hr_api.g_varchar2
114 ,p_return_status out nocopy varchar2
115 );
116 -- ----------------------------------------------------------------------------
117 -- |------------------------< submit_request_set >-----------------------|
118 -- ----------------------------------------------------------------------------
119 -- {Start of comments}
120 --
121 -- Description:
122 -- This procedure is the self-service wrapper procedure to submitting the
123 -- request set from OF.
124 --
125 -- Pre-requisites
126 -- All 'IN' parameters to this procedure have been appropriately derived.
127 --
128 -- Post Success:
129 -- p_return_status will return value indicating success.
130 --
131 -- Post Failure:
132 -- p_return_status will return value indication failure.
133 --
134 -- Access Status:
135 -- Internal Development use only.
136 --
137 -- {End of comments}
138 -- ----------------------------------------------------------------------------
139
140 procedure submit_request_set(
141 p_validate in number default hr_api.g_false_num
142 ,p_exception_report_id in number
143 ,p_legislation_code in varchar2 default null
144 ,p_business_group_id in number default null
145 ,p_consolidation_set_id in number default null
146 ,p_payroll_id in number default null
147 ,p_variance_type in varchar2 default null
148 ,p_variance_value in number default null
149 ,p_request_type in varchar2 default null
150 ,p_gre_id in number default null
151 ,p_state_code in number default null
152 ,p_exception_grp_name in varchar2 default null
153 ,p_exception_rep_name in varchar2 default null
154 ,p_exception_group_id in number
155 ,p_effective_date in date
156 ,p_output_format in varchar2 default null
157 ,p_template_name in varchar2 default null
158 ,p_component_id in number default null
159 ,p_request_id out nocopy number
160 ,p_return_status out nocopy varchar2
161
162 ) ;
166 -- |------------------------< exception_report_xml_process >-----------------------|
163
164
165 -- ----------------------------------------------------------------------------
167 -- ----------------------------------------------------------------------------
168 -- {Start of comments}
169 --
170 -- Description:
171 -- This procedure is used to submit the XML publisher related calls.
172 --
173 -- Pre-requisites
174 -- All 'IN' parameters to this procedure have been appropriately derived.
175 --
176 -- Post Success:
177 --
178 -- Post Failure:
179 --
180 -- Access Status:
181 -- Internal Development use only.
182 --
183 -- {End of comments}
184 -- ----------------------------------------------------------------------------
185 procedure exception_report_xml_process(
186 errbuf OUT NOCOPY VARCHAR2
187 ,retcode OUT NOCOPY VARCHAR2
188 ,p_ppa_finder in varchar2 default null
189 ,p_DES_TYPE in varchar2 default null
190 ,p_business_group_id in varchar2 default null
191 ,p_request_name in varchar2 default null
192 ,p_grp_request_code in varchar2 default null
193 ,p_exception_grp_name in varchar2 default null
194 ,p_rep_request_code in varchar2 default null
195 ,p_exception_report_id in varchar2 default null
196 ,p_variance_type in varchar2 default null
197 ,p_variance_value in number default null
198 ,p_payroll_id in number default null
199 ,p_consolidation_set_id in number default null
200 ,p_effective_date in varchar2 default null
201 ,p_template_name in varchar2 default null
202 ,p_output_format in varchar2 default null
203
204 ) ;
205
206
207 end pqp_exr_swi;
[Home] [Help]