1 Package HR_DOR_REVIEW_SS AUTHID CURRENT_USER As
2 /* $Header: hrdorrevss.pkh 120.1.12020000.3 2013/03/27 07:35:07 pathota ship $ */
3 --
4
5
6 --------------------------------------------------------------------------
7 --------------------------get_approval_req--------------------------------
8 --------------------------------------------------------------------------
9
10 PROCEDURE get_approval_req (
11 itemtype IN WF_ITEMS.ITEM_TYPE%TYPE
12 ,itemkey IN WF_ITEMS.ITEM_KEY%TYPE
13 ,actid IN NUMBER
14 ,funcmode IN VARCHAR2
15 ,resultout OUT nocopy VARCHAR2 );
16
17
18
19
20 --------------------------------------------------------------------------
21 --------------------------start_transaction-------------------------------
22 -------This method creates record in tables hr_api_transactions and ------
23 -------hr_api_transaction_steps.------------------------------------------
24 --------------------------------------------------------------------------
25
26 PROCEDURE start_transaction(
27 p_item_type in varchar2
28 ,p_item_key in varchar2
29 ,p_act_id in number
30 ,p_fun_mode in varchar2
31 ,p_login_person_id in number
32 ,p_product_code in varchar2 default 'PER'
33 ,p_url in varchar2 default null
34 ,p_status in varchar2 default 'W'
35 ,p_section_display_name in varchar2 default null
36 ,p_function_id in number default null
37 ,p_transaction_ref_table in varchar2 default 'HR_DOCUMENT_EXTRA_INFO'
38 ,p_transaction_ref_id in number default null
39 ,p_transaction_type in varchar2 default 'WF'
40 ,p_assignment_id in number default null
41 ,p_api_addtnl_info in varchar2 default null
42 ,p_selected_person_id in number default null
43 ,p_transaction_effective_date in date default sysdate
44 ,p_process_name in varchar2 default null
45 ,p_plan_id in number default null
46 ,p_rptg_grp_id in number default null
47 ,p_effective_date_option in varchar2 default 'E'
48 ,p_save_mode in varchar2 default null
49 ,p_transaction_step_id out nocopy number
50 ,p_transaction_id out nocopy number
51 ,p_error_message out nocopy varchar2
52 );
53
54
55 --------------------------------------------------------------------------
56 --------------------------save_transaction_values-------------------------
57 -----This method stores the document information of a person in the ------
58 -----hr_api_transaction_values table--------------------------------------
59 --------------------------------------------------------------------------
60
61
62 PROCEDURE save_transaction_values(
63 p_transaction_step_id in varchar2
64 ,p_login_person_id in varchar2
65 ,p_person_id in number
66 ,p_document_extra_info_id in number
67 ,p_document_type_id in number
68 ,p_date_from in date
69 ,p_date_to in date default null
70 ,p_document_number in varchar2
71 ,p_issued_by in varchar2 default null
72 ,p_issued_at in varchar2 default null
73 ,p_issued_date in date default null
74 ,p_issuing_authority in varchar2 default null
75 ,p_verified_by in number default null
76 ,p_verified_date in date default null
77 ,p_related_object_name in varchar2 default null
78 ,p_related_object_id_col in varchar2 default null
79 ,p_related_object_id in number default null
80 ,p_dei_attribute_category in varchar2 default null
81 ,p_dei_attribute1 in varchar2 default null
82 ,p_dei_attribute2 in varchar2 default null
83 ,p_dei_attribute3 in varchar2 default null
84 ,p_dei_attribute4 in varchar2 default null
85 ,p_dei_attribute5 in varchar2 default null
86 ,p_dei_attribute6 in varchar2 default null
87 ,p_dei_attribute7 in varchar2 default null
88 ,p_dei_attribute8 in varchar2 default null
89 ,p_dei_attribute9 in varchar2 default null
90 ,p_dei_attribute10 in varchar2 default null
91 ,p_dei_attribute11 in varchar2 default null
92 ,p_dei_attribute12 in varchar2 default null
93 ,p_dei_attribute13 in varchar2 default null
94 ,p_dei_attribute14 in varchar2 default null
95 ,p_dei_attribute15 in varchar2 default null
96 ,p_dei_attribute16 in varchar2 default null
97 ,p_dei_attribute17 in varchar2 default null
98 ,p_dei_attribute18 in varchar2 default null
99 ,p_dei_attribute19 in varchar2 default null
100 ,p_dei_attribute20 in varchar2 default null
101 ,p_dei_attribute21 in varchar2 default null
102 ,p_dei_attribute22 in varchar2 default null
103 ,p_dei_attribute23 in varchar2 default null
104 ,p_dei_attribute24 in varchar2 default null
105 ,p_dei_attribute25 in varchar2 default null
106 ,p_dei_attribute26 in varchar2 default null
107 ,p_dei_attribute27 in varchar2 default null
108 ,p_dei_attribute28 in varchar2 default null
109 ,p_dei_attribute29 in varchar2 default null
110 ,p_dei_attribute30 in varchar2 default null
111 ,p_dei_information_category in varchar2 default null
112 ,p_dei_information1 in varchar2 default null
113 ,p_dei_information2 in varchar2 default null
114 ,p_dei_information3 in varchar2 default null
115 ,p_dei_information4 in varchar2 default null
116 ,p_dei_information5 in varchar2 default null
117 ,p_dei_information6 in varchar2 default null
118 ,p_dei_information7 in varchar2 default null
119 ,p_dei_information8 in varchar2 default null
120 ,p_dei_information9 in varchar2 default null
121 ,p_dei_information10 in varchar2 default null
122 ,p_dei_information11 in varchar2 default null
123 ,p_dei_information12 in varchar2 default null
124 ,p_dei_information13 in varchar2 default null
125 ,p_dei_information14 in varchar2 default null
126 ,p_dei_information15 in varchar2 default null
127 ,p_dei_information16 in varchar2 default null
128 ,p_dei_information17 in varchar2 default null
129 ,p_dei_information18 in varchar2 default null
130 ,p_dei_information19 in varchar2 default null
131 ,p_dei_information20 in varchar2 default null
132 ,p_dei_information21 in varchar2 default null
133 ,p_dei_information22 in varchar2 default null
134 ,p_dei_information23 in varchar2 default null
135 ,p_dei_information24 in varchar2 default null
136 ,p_dei_information25 in varchar2 default null
137 ,p_dei_information26 in varchar2 default null
138 ,p_dei_information27 in varchar2 default null
139 ,p_dei_information28 in varchar2 default null
140 ,p_dei_information29 in varchar2 default null
141 ,p_dei_information30 in varchar2 default null
142 ,p_request_id in number default null
143 ,p_program_application_id in number default null
144 ,p_program_id in number default null
145 ,p_program_update_date in date default null
146 ,p_object_version_number in out nocopy number
147 ,p_return_status out nocopy varchar2
148 );
149
150 --------------------------------------------------------------------------
151 --------------------------Process_api-------------------------------------
152 ------This method is called from commit_transaction ----------------------
153 --------------------------------------------------------------------------
154
155 procedure process_api
156 (p_validate in boolean default false
157 ,p_transaction_step_id in number
158 ,p_effective_date in varchar2 default null
159 );
160
161
162
163
164 --------------------------------------------------------------------------
165 --------------------------validate_dor------------------------------------
166 ------This method validate the api of documents of records----------------
167 --------------------------------------------------------------------------
168
169
170 PROCEDURE validate_dor(
171 p_validate in number default hr_api.g_true_num
172 ,p_person_id in number
173 ,p_document_extra_info_id in number
174 ,p_document_type_id in number
175 ,p_date_from in date
176 ,p_date_to in date default null
177 ,p_document_number in varchar2
178 ,p_issued_by in varchar2 default null
179 ,p_issued_at in varchar2 default null
180 ,p_issued_date in date default null
181 ,p_issuing_authority in varchar2 default null
182 ,p_verified_by in number default null
183 ,p_verified_date in date default null
184 ,p_related_object_name in varchar2 default null
185 ,p_related_object_id_col in varchar2 default null
186 ,p_related_object_id in number default null
187 ,p_dei_attribute_category in varchar2 default null
188 ,p_dei_attribute1 in varchar2 default null
189 ,p_dei_attribute2 in varchar2 default null
190 ,p_dei_attribute3 in varchar2 default null
191 ,p_dei_attribute4 in varchar2 default null
192 ,p_dei_attribute5 in varchar2 default null
193 ,p_dei_attribute6 in varchar2 default null
194 ,p_dei_attribute7 in varchar2 default null
195 ,p_dei_attribute8 in varchar2 default null
196 ,p_dei_attribute9 in varchar2 default null
197 ,p_dei_attribute10 in varchar2 default null
198 ,p_dei_attribute11 in varchar2 default null
199 ,p_dei_attribute12 in varchar2 default null
200 ,p_dei_attribute13 in varchar2 default null
201 ,p_dei_attribute14 in varchar2 default null
202 ,p_dei_attribute15 in varchar2 default null
203 ,p_dei_attribute16 in varchar2 default null
204 ,p_dei_attribute17 in varchar2 default null
205 ,p_dei_attribute18 in varchar2 default null
206 ,p_dei_attribute19 in varchar2 default null
207 ,p_dei_attribute20 in varchar2 default null
208 ,p_dei_attribute21 in varchar2 default null
209 ,p_dei_attribute22 in varchar2 default null
210 ,p_dei_attribute23 in varchar2 default null
211 ,p_dei_attribute24 in varchar2 default null
212 ,p_dei_attribute25 in varchar2 default null
213 ,p_dei_attribute26 in varchar2 default null
214 ,p_dei_attribute27 in varchar2 default null
215 ,p_dei_attribute28 in varchar2 default null
216 ,p_dei_attribute29 in varchar2 default null
217 ,p_dei_attribute30 in varchar2 default null
218 ,p_dei_information_category in varchar2 default null
219 ,p_dei_information1 in varchar2 default null
220 ,p_dei_information2 in varchar2 default null
221 ,p_dei_information3 in varchar2 default null
222 ,p_dei_information4 in varchar2 default null
223 ,p_dei_information5 in varchar2 default null
224 ,p_dei_information6 in varchar2 default null
225 ,p_dei_information7 in varchar2 default null
226 ,p_dei_information8 in varchar2 default null
227 ,p_dei_information9 in varchar2 default null
228 ,p_dei_information10 in varchar2 default null
229 ,p_dei_information11 in varchar2 default null
230 ,p_dei_information12 in varchar2 default null
231 ,p_dei_information13 in varchar2 default null
232 ,p_dei_information14 in varchar2 default null
233 ,p_dei_information15 in varchar2 default null
234 ,p_dei_information16 in varchar2 default null
235 ,p_dei_information17 in varchar2 default null
236 ,p_dei_information18 in varchar2 default null
237 ,p_dei_information19 in varchar2 default null
238 ,p_dei_information20 in varchar2 default null
239 ,p_dei_information21 in varchar2 default null
240 ,p_dei_information22 in varchar2 default null
241 ,p_dei_information23 in varchar2 default null
242 ,p_dei_information24 in varchar2 default null
243 ,p_dei_information25 in varchar2 default null
244 ,p_dei_information26 in varchar2 default null
245 ,p_dei_information27 in varchar2 default null
246 ,p_dei_information28 in varchar2 default null
247 ,p_dei_information29 in varchar2 default null
248 ,p_dei_information30 in varchar2 default null
249 ,p_request_id in number default null
250 ,p_program_application_id in number default null
251 ,p_program_id in number default null
252 ,p_program_update_date in date default null
253 ,p_action_mode in varchar2 default null
254 ,p_object_version_number in out nocopy number
255 ,p_return_status out nocopy varchar2
256 );
257
258
259
260 --------------------------------------------------------------------------
261 --------------------------get_review_data_from_tt-------------------------
262 ------This method retrieve the documents of records data from the --------
263 ------transaction table---------------------------------------------------
264 --------------------------------------------------------------------------
265
266
267 PROCEDURE get_review_data_from_tt(
268 p_transaction_step_id in number
269 ,p_dor_rec out nocopy HR_DOCUMENT_EXTRA_INFO%rowtype);
270
271
272 --------------------------------------------------------------------------
273 --------------------------get_transaction_values--------------------------
274 ------This method retrieve the documents of records data from the --------
275 ------transaction table and return back the values.-----------------------
276 --------------------------------------------------------------------------
277
278 PROCEDURE get_transaction_values(
279 p_transaction_step_id in varchar2
280 ,p_person_id out nocopy varchar2
281 ,p_document_extra_info_id out nocopy varchar2
282 ,p_document_type_id out nocopy varchar2
283 ,p_date_from out nocopy varchar2
284 ,p_date_to out nocopy varchar2
285 ,p_document_number out nocopy varchar2
286 ,p_issued_by out nocopy varchar2
287 ,p_issued_at out nocopy varchar2
288 ,p_issued_date out nocopy varchar2
289 ,p_issuing_authority out nocopy varchar2
290 ,p_verified_by out nocopy varchar2
291 ,p_verified_date out nocopy varchar2
292 ,p_related_object_name out nocopy varchar2
293 ,p_related_object_id_col out nocopy varchar2
294 ,p_related_object_id out nocopy varchar2
295 ,p_dei_attribute_category out nocopy varchar2
296 ,p_dei_attribute1 out nocopy varchar2
297 ,p_dei_attribute2 out nocopy varchar2
298 ,p_dei_attribute3 out nocopy varchar2
299 ,p_dei_attribute4 out nocopy varchar2
300 ,p_dei_attribute5 out nocopy varchar2
301 ,p_dei_attribute6 out nocopy varchar2
302 ,p_dei_attribute7 out nocopy varchar2
303 ,p_dei_attribute8 out nocopy varchar2
304 ,p_dei_attribute9 out nocopy varchar2
305 ,p_dei_attribute10 out nocopy varchar2
306 ,p_dei_attribute11 out nocopy varchar2
307 ,p_dei_attribute12 out nocopy varchar2
308 ,p_dei_attribute13 out nocopy varchar2
309 ,p_dei_attribute14 out nocopy varchar2
310 ,p_dei_attribute15 out nocopy varchar2
311 ,p_dei_attribute16 out nocopy varchar2
312 ,p_dei_attribute17 out nocopy varchar2
313 ,p_dei_attribute18 out nocopy varchar2
314 ,p_dei_attribute19 out nocopy varchar2
315 ,p_dei_attribute20 out nocopy varchar2
316 ,p_dei_attribute21 out nocopy varchar2
317 ,p_dei_attribute22 out nocopy varchar2
318 ,p_dei_attribute23 out nocopy varchar2
319 ,p_dei_attribute24 out nocopy varchar2
320 ,p_dei_attribute25 out nocopy varchar2
321 ,p_dei_attribute26 out nocopy varchar2
322 ,p_dei_attribute27 out nocopy varchar2
323 ,p_dei_attribute28 out nocopy varchar2
324 ,p_dei_attribute29 out nocopy varchar2
325 ,p_dei_attribute30 out nocopy varchar2
326 ,p_dei_information_category out nocopy varchar2
327 ,p_dei_information1 out nocopy varchar2
328 ,p_dei_information2 out nocopy varchar2
329 ,p_dei_information3 out nocopy varchar2
330 ,p_dei_information4 out nocopy varchar2
331 ,p_dei_information5 out nocopy varchar2
332 ,p_dei_information6 out nocopy varchar2
333 ,p_dei_information7 out nocopy varchar2
334 ,p_dei_information8 out nocopy varchar2
335 ,p_dei_information9 out nocopy varchar2
336 ,p_dei_information10 out nocopy varchar2
337 ,p_dei_information11 out nocopy varchar2
338 ,p_dei_information12 out nocopy varchar2
339 ,p_dei_information13 out nocopy varchar2
340 ,p_dei_information14 out nocopy varchar2
341 ,p_dei_information15 out nocopy varchar2
342 ,p_dei_information16 out nocopy varchar2
343 ,p_dei_information17 out nocopy varchar2
344 ,p_dei_information18 out nocopy varchar2
345 ,p_dei_information19 out nocopy varchar2
346 ,p_dei_information20 out nocopy varchar2
347 ,p_dei_information21 out nocopy varchar2
348 ,p_dei_information22 out nocopy varchar2
349 ,p_dei_information23 out nocopy varchar2
350 ,p_dei_information24 out nocopy varchar2
351 ,p_dei_information25 out nocopy varchar2
352 ,p_dei_information26 out nocopy varchar2
353 ,p_dei_information27 out nocopy varchar2
354 ,p_dei_information28 out nocopy varchar2
355 ,p_dei_information29 out nocopy varchar2
356 ,p_dei_information30 out nocopy varchar2
357 ,p_request_id out nocopy varchar2
358 ,p_program_application_id out nocopy varchar2
359 ,p_program_id out nocopy varchar2
360 ,p_program_update_date out nocopy varchar2
361 ,p_object_version_number out nocopy varchar2
362 ,p_return_status out nocopy varchar2
363 ,p_document_type out nocopy varchar2
364 ,p_category_name out nocopy varchar2
365 ,p_sub_category_name out nocopy varchar2
366 ,p_country_name out nocopy varchar2
367 ,p_system_doc_type out nocopy varchar2
368 );
369
370 PROCEDURE save_attachments(
371 p_transaction_id in number
372 ,p_document_extra_info_id in number
373 ,p_flip_flag in varchar2
374 ,p_return_status out nocopy varchar2);
375
376
377 /*===========================================================================
378 This procedure calls the fnd api to update the attachments
379 ===========================================================================*/
380
381 procedure update_attachment
382 (p_entity_name in varchar2 default null
383 ,p_pk1_value in varchar2 default null
384 ,p_rowid in varchar2 );
385
386
387 procedure delete_transaction(p_transaction_id in number);
388
389
390 function isUpdateAllowed(p_transaction_id in number default null,
391 p_transaction_status in varchar2 default null,
392 p_document_extra_info_id in number default null) return varchar2;
393
394 function isDeleteAllowed(p_transaction_id in number,
395 p_transaction_status in varchar2) return varchar2;
396
397 function isAttachAllowed(p_transaction_id in number,
398 p_transaction_status in varchar2) return varchar2;
399
400 function isTxnOwner(p_transaction_id in number,
401 p_person_id in number) return boolean;
402
403 function getActionMode(p_transaction_id in number) return varchar2;
404
405 function get_transaction_id(p_transaction_step_id in number) return number;
406
407 PROCEDURE block_for_transaction (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
408 itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
409 actid IN NUMBER,
410 funcmode IN VARCHAR2,
411 resultout OUT nocopy VARCHAR2 );
412
413 /*Added for bug#16449378*/
414 PROCEDURE create_bprv_block (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
415 itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
416 actid IN NUMBER,
417 funcmode IN VARCHAR2,
418 resultout OUT nocopy VARCHAR2 );
419
420
421 END HR_DOR_REVIEW_SS;
422