1 Package ben_PLAN_DESIGN_TXNS_api AUTHID CURRENT_USER as
2 /* $Header: becetapi.pkh 120.0 2005/05/28 01:01:17 appldev noship $ */
3 --
4 -- REUSE ENHANCEMENT
5 g_pgm_pl_prefix_suffix_text varchar2(300);
6 --
7 -- ----------------------------------------------------------------------------
8 -- |------------------------< create_PLAN_DESIGN_TXN >------------------------|
9 -- ----------------------------------------------------------------------------
10 -- {Start Of Comments}
11 --
12 -- Description:
13 --
14 -- Prerequisites:
15 --
16 --
17 -- In Parameters:
18 -- Name Reqd Type Description
19 -- p_validate Yes number Commit or Rollback.
20 -- p_transaction_category_id Yes number
21 -- p_txn_category_attribute_id Yes number Descriptive Flexfield
22 -- p_context_business_group_id No number
23 -- p_datetrack_mode No varchar2
24 -- p_proc_typ_cd No varchar2
25 -- action_date No date default null
26 -- src_effective_date No date default null
27 -- p_number_of_copies No number
28 -- p_process_name No varchar2
29 -- p_replacement_type_cd No varchar2
30 -- p_sfl_step_name No varchar2
31 -- p_increment_by No number
32 -- p_status No varchar2
33 -- p_effective_date Yes date Session Date.
34 -- p_copy_entity_txn_id Yes number
35 -- p_row_type_cd No varchar2
36 -- p_information_category No varchar2
37 -- p_prefix_suffix_text No varchar2
38 -- p_export_file_name No varchar2
39 -- p_target_typ_cd No varchar2
40 -- p_reuse_object_flag No varchar2
41 -- p_target_business_group_id No varchar2
42 -- p_search_by_cd1 No varchar2
43 -- p_search_value1 No varchar2
44 -- p_search_by_cd2 No varchar2
45 -- p_search_value2 No varchar2
46 -- p_search_by_cd3 No varchar2
47 -- p_search_value3 No varchar2
48 -- p_prefix_suffix_cd No varchar2
49 -- p_information13 No varchar2
50 -- p_information14 No varchar2
51 -- p_information15 No varchar2
52 -- p_information16 No varchar2
53 -- p_information17 No varchar2
54 -- p_information18 No varchar2
55 -- p_information19 No varchar2
56 -- p_information20 No varchar2
57 -- p_information21 No varchar2
58 -- p_information22 No varchar2
59 -- p_information23 No varchar2
60 -- p_information24 No varchar2
61 -- p_information25 No varchar2
62 -- p_information26 No varchar2
63 -- p_information27 No varchar2
64 -- p_information28 No varchar2
65 -- p_information29 No varchar2
66 -- p_information30 No varchar2
67 --
68 -- Post Success:
69 --
70 -- Out Parameters:
71 -- Name Type Description
72 -- p_copy_entity_txn_id Yes number PK of record
73 -- p_cet_object_version_number Yes number OVN of record
74 --
75 -- Post Failure:
76 --
77 -- Access Status:
78 -- Public.
79 --
80 -- {End Of Comments}
81 --
82 procedure create_PLAN_DESIGN_TXN
83 (
84 p_validate in number default 0 -- false
85 ,p_copy_entity_txn_id out nocopy number
86 ,p_transaction_category_id in number default null
87 ,p_txn_category_attribute_id in number default null
88 ,p_context_business_group_id in number default null
89 ,p_datetrack_mode in varchar2 default null
90 ,p_proc_typ_cd in varchar2 default null
91 ,p_action_date in date default null
92 ,p_src_effective_date in date default null
93 ,p_number_of_copies in number default null
94 ,p_process_name in varchar2 default null
95 ,p_replacement_type_cd in varchar2 default null
96 ,p_sfl_step_name in varchar2 default null
97 ,p_increment_by in number default null
98 ,p_status in varchar2 default null
99 ,p_cet_object_version_number out nocopy number
100 ,p_effective_date in date
104 ,p_prefix_suffix_text in varchar2 default null
101 ,p_copy_entity_attrib_id out nocopy number
102 ,p_row_type_cd in varchar2 default null
103 ,p_information_category in varchar2 default null
105 ,p_export_file_name in varchar2 default null
106 ,p_target_typ_cd in varchar2 default null
107 ,p_reuse_object_flag in varchar2 default null
108 ,p_target_business_group_id in varchar2 default null
109 ,p_search_by_cd1 in varchar2 default null
110 ,p_search_value1 in varchar2 default null
111 ,p_search_by_cd2 in varchar2 default null
112 ,p_search_value2 in varchar2 default null
113 ,p_search_by_cd3 in varchar2 default null
114 ,p_search_value3 in varchar2 default null
115 ,p_prefix_suffix_cd in varchar2 default null
116 ,p_information13 in varchar2 default null
117 ,p_information14 in varchar2 default null
118 ,p_information15 in varchar2 default null
119 ,p_information16 in varchar2 default null
120 ,p_information17 in varchar2 default null
121 ,p_information18 in varchar2 default null
122 ,p_information19 in varchar2 default null
123 ,p_information20 in varchar2 default null
124 ,p_information21 in varchar2 default null
125 ,p_information22 in varchar2 default null
126 ,p_information23 in varchar2 default null
127 ,p_information24 in varchar2 default null
128 ,p_information25 in varchar2 default null
129 ,p_information26 in varchar2 default null
130 ,p_information27 in varchar2 default null
131 ,p_information28 in varchar2 default null
132 ,p_information29 in varchar2 default null
133 ,p_information30 in varchar2 default null
137 -- |------------------------< update_PLAN_DESIGN_TXN >------------------------|
134 ,p_cea_object_version_number out nocopy number
135 );
136 -- ----------------------------------------------------------------------------
138 -- ----------------------------------------------------------------------------
139 -- {Start Of Comments}
140 --
141 -- Description:
142 --
143 -- Prerequisites:
144 --
145 --
146 -- In Parameters:
147 -- Name Reqd Type Description
148 -- p_validate Yes number Commit or Rollback.
149 -- p_copy_entity_txn_id Yes number PK of record
150 -- p_transaction_category_id Yes number
151 -- p_txn_category_attribute_id Yes number Descriptive Flexfield
152 -- p_context_business_group_id No number
153 -- p_datetrack_mode No varchar2
154 -- p_proc_typ_cd Yes varchar2
155 -- action_date in date default null
156 -- src_effective_date in date default null
157 -- p_number_of_copies No number
158 -- p_process_name No varchar2
159 -- p_replacement_type_cd No varchar2
160 -- p_sfl_step_name No varchar2
161 -- p_increment_by No number
162 -- p_status No varchar2
163 -- p_effective_date Yes date Session Date.
164 -- p_copy_entity_attrib_id Yes number PK of record
165 -- p_row_type_cd No varchar2
166 -- p_information_category No varchar2
167 -- p_prefix_suffix_text No varchar2
168 -- p_export_file_name No varchar2
169 -- p_target_typ_cd No varchar2
170 -- p_reuse_object_flag No varchar2
171 -- p_target_business_group_id No varchar2
172 -- p_search_by_cd1 No varchar2
173 -- p_search_value1 No varchar2
174 -- p_search_by_cd2 No varchar2
175 -- p_search_value2 No varchar2
176 -- p_search_by_cd3 No varchar2
177 -- p_search_value3 No varchar2
178 -- p_prefix_suffix_cd No varchar2
179 -- p_information13 No varchar2
180 -- p_information14 No varchar2
181 -- p_information15 No varchar2
182 -- p_information16 No varchar2
183 -- p_information17 No varchar2
184 -- p_information18 No varchar2
185 -- p_information19 No varchar2
186 -- p_information20 No varchar2
190 -- p_information24 No varchar2
187 -- p_information21 No varchar2
188 -- p_information22 No varchar2
189 -- p_information23 No varchar2
191 -- p_information25 No varchar2
192 -- p_information26 No varchar2
193 -- p_information27 No varchar2
194 -- p_information28 No varchar2
195 -- p_information29 No varchar2
196 -- p_information30 No varchar2
197 --
198 -- Post Success:
199 --
200 -- Name Type Description
201 -- p_cet_object_version_number Yes number OVN of record
202 --
203 -- Post Failure:
204 --
205 -- Access Status:
206 -- Public.
207 --
208 -- {End Of Comments}
209 --
210 procedure update_PLAN_DESIGN_TXN
211 (
212 p_validate in number default 0 -- false
213 ,p_copy_entity_txn_id in number
214 ,p_transaction_category_id in number default hr_api.g_number
215 ,p_txn_category_attribute_id in number default hr_api.g_number
216 ,p_context_business_group_id in number default hr_api.g_number
217 ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
218 ,p_proc_typ_cd in varchar2 default hr_api.g_varchar2
219 ,p_action_date in date default hr_api.g_date
220 ,p_src_effective_date in date default hr_api.g_date
221 ,p_number_of_copies in number default hr_api.g_number
222 ,p_process_name in varchar2 default hr_api.g_varchar2
223 ,p_replacement_type_cd in varchar2 default hr_api.g_varchar2
224 ,p_sfl_step_name in varchar2 default hr_api.g_varchar2
225 ,p_increment_by in number default hr_api.g_number
226 ,p_status in varchar2 default hr_api.g_varchar2
227 ,p_cet_object_version_number in out nocopy number
228 ,p_effective_date in date
229 ,p_copy_entity_attrib_id in number
230 ,p_row_type_cd in varchar2 default hr_api.g_varchar2
231 ,p_information_category in varchar2 default hr_api.g_varchar2
232 ,p_prefix_suffix_text in varchar2 default hr_api.g_varchar2
233 ,p_export_file_name in varchar2 default hr_api.g_varchar2
234 ,p_target_typ_cd in varchar2 default hr_api.g_varchar2
235 ,p_reuse_object_flag in varchar2 default hr_api.g_varchar2
236 ,p_target_business_group_id in varchar2 default hr_api.g_varchar2
237 ,p_search_by_cd1 in varchar2 default hr_api.g_varchar2
238 ,p_search_value1 in varchar2 default hr_api.g_varchar2
239 ,p_search_by_cd2 in varchar2 default hr_api.g_varchar2
240 ,p_search_value2 in varchar2 default hr_api.g_varchar2
241 ,p_search_by_cd3 in varchar2 default hr_api.g_varchar2
242 ,p_search_value3 in varchar2 default hr_api.g_varchar2
243 ,p_prefix_suffix_cd in varchar2 default hr_api.g_varchar2
244 ,p_information13 in varchar2 default hr_api.g_varchar2
245 ,p_information14 in varchar2 default hr_api.g_varchar2
246 ,p_information15 in varchar2 default hr_api.g_varchar2
247 ,p_information16 in varchar2 default hr_api.g_varchar2
248 ,p_information17 in varchar2 default hr_api.g_varchar2
249 ,p_information18 in varchar2 default hr_api.g_varchar2
250 ,p_information19 in varchar2 default hr_api.g_varchar2
251 ,p_information20 in varchar2 default hr_api.g_varchar2
252 ,p_information21 in varchar2 default hr_api.g_varchar2
253 ,p_information22 in varchar2 default hr_api.g_varchar2
254 ,p_information23 in varchar2 default hr_api.g_varchar2
255 ,p_information24 in varchar2 default hr_api.g_varchar2
256 ,p_information25 in varchar2 default hr_api.g_varchar2
257 ,p_information26 in varchar2 default hr_api.g_varchar2
258 ,p_information27 in varchar2 default hr_api.g_varchar2
259 ,p_information28 in varchar2 default hr_api.g_varchar2
260 ,p_information29 in varchar2 default hr_api.g_varchar2
264 );
261 ,p_information30 in varchar2 default hr_api.g_varchar2
262 ,p_upd_record_type in varchar2 default null
263 ,p_cea_object_version_number in out nocopy number
265 --
266 -- ----------------------------------------------------------------------------
267 -- |------------------------< delete_PLAN_DESIGN_TXN >------------------------|
268 -- ----------------------------------------------------------------------------
269 -- {Start Of Comments}
270 --
271 -- Description:
272 --
273 -- Prerequisites:
274 --
275 --
276 -- In Parameters:
277 -- Name Reqd Type Description
278 -- p_validate Yes number Commit or Rollback.
279 -- p_copy_entity_txn_id Yes number PK of record
280 -- p_effective_date Yes date Session Date.
281 --
282 -- Post Success:
283 --
284 -- Name Type Description
285 -- p_cet_object_version_number Yes number OVN of record
286 --
287 -- Post Failure:
288 --
289 -- Access Status:
290 -- Public.
291 --
292 -- {End Of Comments}
293 --
294 procedure delete_PLAN_DESIGN_TXN
295 (
296 p_validate in number default 0 -- false
297 ,p_copy_entity_txn_id in number
298 ,p_cet_object_version_number in number
299 ,p_effective_date in date
300 ,p_retain_log in varchar2 default 'N' -- Bug No 4281567
301 );
302 --
303 procedure create_plan_design_result
304 (
305 p_validate in number default 0 -- false
306 ,p_copy_entity_result_id out nocopy number
307 ,p_copy_entity_txn_id in number
308 ,p_pl_id in number default null
309 ,p_pgm_id in number default null
310 ,p_business_group_id in number default null
311 ,p_number_of_copies in number default 0
312 ,p_object_version_number out nocopy number
313 ,p_effective_date in date
314 ,p_no_dup_rslt in varchar2 default null
315 ) ;
316 --
317 procedure update_plan_design_result
318 (
319 p_validate in number default 0 -- false
320 ,p_copy_entity_result_id in number
321 ,p_copy_entity_txn_id in number
322 ,p_business_group_id in number default hr_api.g_number
323 ,p_number_of_copies in number default hr_api.g_number
324 ,p_object_version_number in out nocopy number
325 ,p_effective_date in date
326 ,p_information1 in varchar2 default hr_api.g_varchar2
327 ,p_information8 in varchar2 default hr_api.g_varchar2
328 ,p_information175 in varchar2 default hr_api.g_varchar2
329 ,p_information176 in varchar2 default hr_api.g_varchar2
330 ,p_information177 in varchar2 default hr_api.g_varchar2
331 ,p_information178 in varchar2 default hr_api.g_varchar2
332 ,p_information179 in varchar2 default hr_api.g_varchar2
333 ,p_information180 in varchar2 default hr_api.g_varchar2
334 ,p_called_from in varchar2 default hr_api.g_varchar2
335 ,p_mirror_entity_result_id in number default hr_api.g_number
336 ) ;
337 --
338 procedure delete_plan_design_result
339 (
340 p_validate in number default 0 -- false
341 ,p_copy_entity_txn_id in number
342 ,p_effective_date in date
343 );
344 --
345 procedure update_mapping_target_data(
346 p_validate in number default 0 -- false
347 ,p_copy_entity_txn_id in number
348 ,p_table_route_id in number
349 ,p_source_id1 in number
350 ,p_target_value1 in varchar2
351 ,p_target_id1 in number
352 ,p_source_id2 in number
353 ,p_target_value2 in varchar2
354 ,p_target_id2 in number
355 ,p_business_group_id in number default hr_api.g_number
356 ,p_effective_date in date default null
357 );
358 --
359 procedure auto_mapping(
360 p_validate in number default 0 -- false
361 ,p_copy_entity_txn_id in number
362 ,p_table_route_id in number
363 ,p_table_route_id2 in number
364 ,p_legislation_code in varchar2
365 ,p_target_business_group_id in number default hr_api.g_number
366 ,p_effective_date in date default null
367 ,p_effective_date_to_copy in date default null
368 ) ;
369 --
370
371 function get_mapping_info(
372 p_mapping_info varchar2,
373 p_table_route_id number,
374 p_entity_txn_id number) return varchar2 ;
375 --
376 procedure get_user_business_group_ids(
377 p_user_id number,
378 p_business_group_ids out nocopy varchar2
379 ) ;
380 --
381
382 procedure submit_copy_request(
383 p_validate in number default 0 -- false
384 ,p_copy_entity_txn_id in number
385 ,p_request_id out nocopy number
386 );
387 --
388
389 procedure update_hgrid_child_selection(
390 p_copy_entity_result_id in number
391 ,p_mirror_entity_result_id in number
395 );
392 ,p_copy_entity_txn_id in number
393 ,p_number_of_copies in number
394 ,p_table_route_id in number
396 --
397 procedure get_required_mapping_completed(
398 p_copy_entity_txn_id in number
399 ,p_required_mapping out nocopy varchar2
400 );
401 --
402 procedure get_mapping_column_name(
403 p_table_route_id in number
404 ,p_mapping_colum_name1 out nocopy varchar2
405 ,p_mapping_colum_name2 out nocopy varchar2
406 ,p_copy_entity_txn_id in number
407 );
408 --
409 procedure update_download_status(
410 errbuf out nocopy varchar2
411 ,retcode out nocopy number
412 ,p_request_id in number
413 ,p_copy_entity_txn_id in number
414 );
415 --
416 function get_log_display(
417 p_copy_entity_txn_id in number
418 ,p_status in varchar2
419 ,p_target_typ_cd in varchar2) return varchar2;
420 --
421 -- ----------------------------------------------------------------------------
422 -- |------------------------< write_txn_table_route >------------------------|
423 -- ----------------------------------------------------------------------------
424 -- {Start Of Comments}
425 -- This procedure is used for writing the table_rout_id column for a process
426 -- since Plan Design wizard does not write the table_route_id but the submit
427 -- process uses it. The procedure runs as a autonomous transaction so that we do not
428 -- do the same processing again.
429
430 procedure write_txn_table_route(p_copy_entity_txn_id in number);
431
432 -- submit process wrapper for Plan Design Wizard
433
434 procedure pdw_submit_copy_request(
435 p_validate in number default 0 -- false
436 ,p_copy_entity_txn_id in number
437 ,p_request_id out nocopy number
438 );
439
440 -- create_plan_design_result overloaded for Plan Design Wizard
441 -- This has been overloaded to alllow copying Plans to staging area
442 -- without setting information8 to PLNIP
443
444 procedure create_plan_design_result
445 (
446 p_validate in number default 0 -- false
447 ,p_copy_entity_result_id out nocopy number
448 ,p_copy_entity_txn_id in number
449 ,p_pl_id in number default null
450 ,p_pgm_id in number default null
451 ,p_business_group_id in number default null
452 ,p_number_of_copies in number default 0
453 ,p_object_version_number out nocopy number
454 ,p_effective_date in date
455 ,p_no_dup_rslt in varchar2 default null
456 ,p_plan_in_program in varchar2
457 ) ;
458 --
459 -- Bug 4278495
460 -- ----------------------------------------------------------------------------
461 -- |-------------------------------< create_log >-----------------------------|
462 -- ----------------------------------------------------------------------------
463 --
464 procedure create_log
465 ( p_copy_entity_txn_id in number
466 ) ;
467 --
468 --
469 --
470 -- Bug 4281567
471 -- ----------------------------------------------------------------------------
472 -- |------------------< purge_plan_design_process >--------------------|
473 -- ----------------------------------------------------------------------------
474 --
475 procedure purge_plan_design_process(
476 errbuf out nocopy varchar2 --needed by concurrent manager.
480 ,p_effective_date in varchar2
477 ,retcode out nocopy number --needed by concurrent manager.
478 ,p_process_id in number default null
479 ,p_validate in varchar2
481 ,p_status in varchar2 default null
482 ,p_transaction_short_name in varchar2
483 ,p_retain_log in varchar2
484 ,p_business_group_id in number
485 );
486 --
487 --
488 end BEN_PLAN_DESIGN_TXNS_api;