1 PACKAGE psp_eff_report_approvals_api AUTHID CURRENT_USER AS
2 /* $Header: PSPEAAIS.pls 120.5 2006/07/21 13:04:05 tbalacha noship $ */
3 /*#
4 * This package contains ...
5 * @rep:scope public
6 * @rep:product psp
7 * @rep:displayname Effort Approvals
8 */
9 g_pera_information1 varchar2(150);
10 g_pera_information2 varchar2(150);
11 g_pera_information3 varchar2(150);
12 g_pera_information4 varchar2(150);
13 g_pera_information5 varchar2(150);
14 g_pera_information6 varchar2(150);
15 g_pera_information7 varchar2(150);
16 g_pera_information8 varchar2(150);
17 g_pera_information9 varchar2(150);
18 g_pera_information10 varchar2(150);
19 g_pera_information11 varchar2(150);
20 g_pera_information12 varchar2(150);
21 g_pera_information13 varchar2(150);
22 g_pera_information14 varchar2(150);
23 g_pera_information15 varchar2(150);
24 g_pera_information16 varchar2(150);
25 g_pera_information17 varchar2(150);
26 g_pera_information18 varchar2(150);
27 g_pera_information19 varchar2(150);
28 g_pera_information20 varchar2(150);
29
30 g_eff_information1 varchar2(150);
31 g_eff_information2 varchar2(150);
32 g_eff_information3 varchar2(150);
33 g_eff_information4 varchar2(150);
34 g_eff_information5 varchar2(150);
35 g_eff_information6 varchar2(150);
36 g_eff_information7 varchar2(150);
37 g_eff_information8 varchar2(150);
38 g_eff_information9 varchar2(150);
42 g_eff_information13 varchar2(150);
39 g_eff_information10 varchar2(150);
40 g_eff_information11 varchar2(150);
41 g_eff_information12 varchar2(150);
43 g_eff_information14 varchar2(150);
44 g_eff_information15 varchar2(150);
45
46 --
47 -- ----------------------------------------------------------------------------
48 -- |------------------------< insert_eff_report_approvals >------------------------|
49 -- ----------------------------------------------------------------------------
50 --
51 -- {Start Of Comments}
52 --
53 -- Description:
54 -- Create a Effort Report Approval line
55 --
56 -- Prerequisites:
57 -- Effort report and Effort Report detail lines must be exist
58 --
59 -- In Parameters:
60 -- Name Reqd Type Description
61 -- p_validate Yes boolean Identifier the validation of effort report
62 -- p_effort_report_approval_id Yes number Identifier for effort report approval
63 -- p_effort_report_detail_id Yes number Effort report details identifier
64 -- p_wf_role_name Yes varchar2 Workflow Role or user name
65 -- p_wf_orig_system_id Yes number System id from where the workflow orginated
66 -- p_wf_orig_system Yes varchar2 System name from where the workflow orginated
67 -- p_approver_order_num Yes number Hierearchy for approvers
68 -- p_approval_status Yes varchar2 Status variable for approval
69 -- p_response_date Yes date Date for acting on the approval
70 -- p_actual_cost_share Yes number Actual coast share entered from screen
71 -- p_overwritten_effort_percent Yes number Overriwritten Effort Percent value
72 -- p_wf_item_key Yes varchar2 Workflow Notification identifier
73 -- p_comments Yes varchar2 Description for notification approval
74 -- p_pera_information_category Yes varchar2 Extra information category
75 -- p_pera_information1 Yes varchar2 Extra Information
76 -- p_pera_information2 Yes varchar2 Extra Information
77 -- p_pera_information3 Yes varchar2 Extra Information
78 -- p_pera_information4 Yes varchar2 Extra Information
79 -- p_pera_information5 Yes varchar2 Extra Information
80 -- p_pera_information6 Yes varchar2 Extra Information
81 -- p_pera_information7 Yes varchar2 Extra Information
82 -- p_pera_information8 Yes varchar2 Extra Information
83 -- p_pera_information9 Yes varchar2 Extra Information
84 -- p_pera_information10 Yes varchar2 Extra Information
85 -- p_pera_information11 Yes varchar2 Extra Information
86 -- p_pera_information12 Yes varchar2 Extra Information
87 -- p_pera_information13 Yes varchar2 Extra Information
88 -- p_pera_information14 Yes varchar2 Extra Information
89 -- p_pera_information15 Yes varchar2 Extra Information
90 -- p_pera_information16 Yes varchar2 Extra Information
91 -- p_pera_information17 Yes varchar2 Extra Information
92 -- p_pera_information18 Yes varchar2 Extra Information
93 -- p_pera_information19 Yes varchar2 Extra Information
94 -- p_pera_information20 Yes varchar2 Extra Information
95 -- p_wf_role_display_name Yes varchar2 Workflow Role display name
96 -- p_eff_information_category Yes varchar2 Effort Information Category
97 -- p_eff_information1 Yes varchar2 Effort Information
98 -- p_eff_information2 Yes varchar2 Effort Information
99 -- p_eff_information3 Yes varchar2 Effort Information
100 -- p_eff_information4 Yes varchar2 Effort Information
101 -- p_eff_information5 Yes varchar2 Effort Information
102 -- p_eff_information6 Yes varchar2 Effort Information
103 -- p_eff_information7 Yes varchar2 Effort Information
104 -- p_eff_information8 Yes varchar2 Effort Information
105 -- p_eff_information9 Yes varchar2 Effort Information
106 -- p_eff_information10 Yes varchar2 Effort Information
107 -- p_eff_information11 Yes varchar2 Effort Information
108 -- p_eff_information12 Yes varchar2 Effort Information
109 -- p_eff_information13 Yes varchar2 Effort Information
110 -- p_eff_information14 Yes varchar2 Effort Information
111 -- p_eff_information15 Yes varchar2 Effort Information
112 --
113 -- Post Success:
114 -- Effort Report approval line is created
115 --
116 --
117 -- Post Failure:
118 -- Effort Report approval line is not created and an error is raised
119 --
120 -- Access Status:
121 -- Internal Development Use Only.
122 --
123 -- {End Of Comments}
124 --
125 procedure insert_eff_report_approvals
126 (p_validate in boolean default false
127 ,p_effort_report_detail_id in number
128 ,p_wf_role_name in varchar2
129 ,p_wf_orig_system_id in number
130 ,p_wf_orig_system in varchar2
131 ,p_approver_order_num in number
132 ,p_approval_status in varchar2
133 ,p_response_date in date
134 ,p_actual_cost_share in number
135 ,p_overwritten_effort_percent in number
136 ,p_wf_item_key in varchar2
137 ,p_comments in varchar2
138 ,p_pera_information_category in varchar2
139 ,p_pera_information1 in varchar2
140 ,p_pera_information2 in varchar2
144 ,p_pera_information6 in varchar2
141 ,p_pera_information3 in varchar2
142 ,p_pera_information4 in varchar2
143 ,p_pera_information5 in varchar2
145 ,p_pera_information7 in varchar2
146 ,p_pera_information8 in varchar2
147 ,p_pera_information9 in varchar2
148 ,p_pera_information10 in varchar2
149 ,p_pera_information11 in varchar2
150 ,p_pera_information12 in varchar2
151 ,p_pera_information13 in varchar2
152 ,p_pera_information14 in varchar2
153 ,p_pera_information15 in varchar2
154 ,p_pera_information16 in varchar2
155 ,p_pera_information17 in varchar2
156 ,p_pera_information18 in varchar2
157 ,p_pera_information19 in varchar2
158 ,p_pera_information20 in varchar2
159 ,p_wf_role_display_name in varchar2
160 ,p_eff_information_category in varchar2
161 ,p_eff_information1 in varchar2
162 ,p_eff_information2 in varchar2
163 ,p_eff_information3 in varchar2
164 ,p_eff_information4 in varchar2
165 ,p_eff_information5 in varchar2
166 ,p_eff_information6 in varchar2
167 ,p_eff_information7 in varchar2
168 ,p_eff_information8 in varchar2
169 ,p_eff_information9 in varchar2
170 ,p_eff_information10 in varchar2
171 ,p_eff_information11 in varchar2
172 ,p_eff_information12 in varchar2
173 ,p_eff_information13 in varchar2
174 ,p_eff_information14 in varchar2
175 ,p_eff_information15 in varchar2
176 ,p_effort_report_approval_id out nocopy number
177 ,p_object_version_number out nocopy number
178 ,p_return_status out nocopy boolean
179 );
180 --
181 -- ----------------------------------------------------------------------------
182 -- |--------------------------< update_eff_report_approvals >----------------------|
183 -- ----------------------------------------------------------------------------
184 --
185 -- {Start Of Comments}
186 /*#
187 * This API updates a Effort Report Approval line.
188 *
189 * The API does update the existing effort report Approval line.
190 *
191 * <p><b>Licensing</b><br>
192 * This API is licensed for use with Oracle Human Resources..
193 *
194 * <p><b>Prerequisites</b><br>
195 * Effort report and Effort Report detail lines must be exist
196 *
197 * <p><b>Post Success</b><br>
198 * Effort Report approval line is updated
199 *
200 * <p><b>Post Failure</b><br>
201 * Effort Report approval line is not updated and an error is raised
202 *
203 * @param p_validate If true, then validation alone will be performed and the
204 * database will remain unchanged. If false and all validation checks pass,
205 * then the database will be modified.
206 * @param p_effort_report_approval_id Identifier for effort report approval
207 * @param p_effort_report_detail_id Effort report details identifier
208 * @param p_wf_role_name Workflow Role or user name
209 * @param p_wf_orig_system_id System id from where the workflow orginated
210 * @param p_wf_orig_system System name from where the workflow orginated
211 * @param p_approver_order_num Hierearchy for approvers
212 * @param p_approval_status Status variable for approval
213 * @param p_response_date Date for acting on the approval
214 * @param p_actual_cost_share Actual coast share entered from screen
215 * @param p_overwritten_effort_percent Overriwritten Effort Percent value
216 * @param p_wf_item_key Workflow Notification identifier
217 * @param p_comments Description for notification approval
218 * @param p_pera_information_category Extra information category
219 * @param p_pera_information1 Extra Information
220 * @param p_pera_information2 Extra Information
221 * @param p_pera_information3 Extra Information
222 * @param p_pera_information4 Extra Information
223 * @param p_pera_information5 Extra Information
224 * @param p_pera_information6 Extra Information
225 * @param p_pera_information7 Extra Information
226 * @param p_pera_information8 Extra Information
227 * @param p_pera_information9 Extra Information
228 * @param p_pera_information10 Extra Information
229 * @param p_pera_information11 Extra Information
230 * @param p_pera_information12 Extra Information
231 * @param p_pera_information13 Extra Information
232 * @param p_pera_information14 Extra Information
233 * @param p_pera_information15 Extra Information
234 * @param p_pera_information16 Extra Information
235 * @param p_pera_information17 Extra Information
236 * @param p_pera_information18 Extra Information
237 * @param p_pera_information19 Extra Information
238 * @param p_pera_information20 Extra Information
239 * @param p_wf_role_display_name Workflow Role display name
240 * @param p_eff_information_category Effort Information Category
241 * @param p_eff_information1 Effort Information
242 * @param p_eff_information2 Effort Information
243 * @param p_eff_information3 Effort Information
244 * @param p_eff_information4 Effort Information
245 * @param p_eff_information5 Effort Information
246 * @param p_eff_information6 Effort Information
247 * @param p_eff_information7 Effort Information
251 * @param p_eff_information11 Effort Information
248 * @param p_eff_information8 Effort Information
249 * @param p_eff_information9 Effort Information
250 * @param p_eff_information10 Effort Information
252 * @param p_eff_information12 Effort Information
253 * @param p_eff_information13 Effort Information
254 * @param p_eff_information14 Effort Information
255 * @param p_eff_information15 Effort Information
256 * @param p_object_version_number Object version number identifier used for concurrenct
257 * @param p_return_status The status whether the procedure is successful or not
258 * @rep:displayname Update Effort Report Apprvals
259 * @rep:category BUSINESS_ENTITY PSP_EFF_REPORT_DETAILS
260 * @rep:lifecycle active
261 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
262 * @rep:scope public
263 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
264 */
265 --
266 -- {End Of Comments}
267
268 procedure update_eff_report_approvals
269 (p_validate in boolean default false
270 ,p_effort_report_approval_id in number
271 ,p_effort_report_detail_id in number default hr_api.g_number
272 ,p_wf_role_name in varchar2 default hr_api.g_varchar2
273 ,p_wf_orig_system_id in number default hr_api.g_number
274 ,p_wf_orig_system in varchar2 default hr_api.g_varchar2
275 ,p_approver_order_num in number default hr_api.g_number
276 ,p_approval_status in varchar2 default hr_api.g_varchar2
277 ,p_response_date in date default hr_api.g_date
278 ,p_actual_cost_share in number default hr_api.g_number
279 ,p_overwritten_effort_percent in number default hr_api.g_number
280 ,p_wf_item_key in varchar2 default hr_api.g_varchar2
281 ,p_comments in varchar2 default hr_api.g_varchar2
282 ,p_pera_information_category in varchar2 default hr_api.g_varchar2
283 ,p_pera_information1 in varchar2 default hr_api.g_varchar2
284 ,p_pera_information2 in varchar2 default hr_api.g_varchar2
285 ,p_pera_information3 in varchar2 default hr_api.g_varchar2
286 ,p_pera_information4 in varchar2 default hr_api.g_varchar2
287 ,p_pera_information5 in varchar2 default hr_api.g_varchar2
288 ,p_pera_information6 in varchar2 default hr_api.g_varchar2
289 ,p_pera_information7 in varchar2 default hr_api.g_varchar2
290 ,p_pera_information8 in varchar2 default hr_api.g_varchar2
291 ,p_pera_information9 in varchar2 default hr_api.g_varchar2
292 ,p_pera_information10 in varchar2 default hr_api.g_varchar2
293 ,p_pera_information11 in varchar2 default hr_api.g_varchar2
294 ,p_pera_information12 in varchar2 default hr_api.g_varchar2
295 ,p_pera_information13 in varchar2 default hr_api.g_varchar2
296 ,p_pera_information14 in varchar2 default hr_api.g_varchar2
297 ,p_pera_information15 in varchar2 default hr_api.g_varchar2
298 ,p_pera_information16 in varchar2 default hr_api.g_varchar2
299 ,p_pera_information17 in varchar2 default hr_api.g_varchar2
300 ,p_pera_information18 in varchar2 default hr_api.g_varchar2
301 ,p_pera_information19 in varchar2 default hr_api.g_varchar2
302 ,p_pera_information20 in varchar2 default hr_api.g_varchar2
303 ,p_wf_role_display_name in varchar2 default hr_api.g_varchar2
304 ,p_eff_information_category in varchar2 default hr_api.g_varchar2
305 ,p_eff_information1 in varchar2 default hr_api.g_varchar2
306 ,p_eff_information2 in varchar2 default hr_api.g_varchar2
307 ,p_eff_information3 in varchar2 default hr_api.g_varchar2
308 ,p_eff_information4 in varchar2 default hr_api.g_varchar2
309 ,p_eff_information5 in varchar2 default hr_api.g_varchar2
310 ,p_eff_information6 in varchar2 default hr_api.g_varchar2
311 ,p_eff_information7 in varchar2 default hr_api.g_varchar2
312 ,p_eff_information8 in varchar2 default hr_api.g_varchar2
313 ,p_eff_information9 in varchar2 default hr_api.g_varchar2
314 ,p_eff_information10 in varchar2 default hr_api.g_varchar2
315 ,p_eff_information11 in varchar2 default hr_api.g_varchar2
316 ,p_eff_information12 in varchar2 default hr_api.g_varchar2
317 ,p_eff_information13 in varchar2 default hr_api.g_varchar2
318 ,p_eff_information14 in varchar2 default hr_api.g_varchar2
319 ,p_eff_information15 in varchar2 default hr_api.g_varchar2
320 ,p_object_version_number in out nocopy number
321 ,p_return_status out nocopy boolean
322 );
323
324 --
325 -- ----------------------------------------------------------------------------
326 -- |--------------------------< delete_eff_report_approvals >----------------------|
327 -- ----------------------------------------------------------------------------
328 --
329 -- {Start Of Comments}
330 --
331 -- Description:
332 -- Deletes a Effort Report Approval line
333 --
334 -- Prerequisites:
335 -- Effort report and Effort Report detail lines must be deleted before this
336 --
337 -- In Parameters:
338 -- Name Reqd Type Description
339 -- p_validate Yes boolean Identifier the validation of effort report
343 -- Effort Report approval line is deleted
340 -- p_effort_report_approval_id Yes number Identifier the effort report approval
341 --
342 -- Post Success:
344 --
345 --
346 -- Post Failure:
347 -- No Effort Report approval line is deleted
348 --
349 -- Access Status:
350 -- Internal Development Use Only.
351 --
352 -- {End Of Comments}
353 --
354 procedure delete_eff_report_approvals
355 ( p_validate in boolean default false
356 , p_effort_report_approval_id in number
357 , p_object_version_number in out nocopy number
358 , p_return_status out nocopy boolean
359 );
360 end psp_eff_report_approvals_api;