1 package ben_cwb_back_out_conc as
2 /* $Header: bencwbbo.pkh 120.1.12000000.1 2007/01/19 15:19:44 appldev noship $ */
3 --
4 /* ============================================================================
5 * Name
6 * Back-out Compensation Life Events Concurrent Manager Processes
7 *
8 * Purpose
9 * This is a new package added to backout data created by the CWB global
10 * budget.
11 * This package houses the procedure which would be called from
12 * the concurrent manager.
13 *
14 * History
15 * Date Who Version What?
16 * ------- --------- ------- --------------------------------------
17 * 16-Jan-04 rpgupta 115.0 Created
18 * 08-Oct-04 pbodla 115.2 Added proc p_backout_global_cwb_event
19 * to be called from online call.
20 * 26-May-06 maagrawa 115.3 New paramete update_summary in
21 * delete_cwb_data
22 * -----------------------------------------------------------------------------
23 */
24
25 procedure restart (errbuf out nocopy varchar2
26 ,retcode out nocopy number
27 ,p_benefit_action_id in number) ;
28
29
30 procedure do_multithread
31 (errbuf out nocopy varchar2
32 ,retcode out nocopy number
33 ,p_validate in varchar2 default 'N'
34 ,p_benefit_action_id in number
35 ,p_thread_id in number
36 ,p_effective_date in varchar2
37 ,p_business_group_id in number
38 ,p_ocrd_date in varchar2
39 ,p_group_pl_id in number
40 ,p_life_event_id in number
41 ,p_bckt_stat_cd in varchar2
42 ) ;
43
44
45 procedure delete_cwb_data
46 (p_per_in_ler_id in number
47 ,p_business_group_id in number
48 ,p_update_summary in boolean default false
49 ) ;
50
51
52 procedure process
53 (errbuf out nocopy varchar2
54 ,retcode out nocopy number
55 ,p_benefit_action_id in number default null
56 ,p_effective_date in varchar2
57 ,p_validate in varchar2 default 'N'
58 ,p_business_group_id in number
59 ,p_group_pl_id in number
60 ,p_life_event_id in number
61 ,p_ocrd_date in varchar2
62 ,p_person_selection_rule_id in number default null
63 ,p_debug_messages in varchar2 default 'N'
64 ,p_bckt_stat_cd in varchar2 default 'UNPROCD'
65 ) ;
66
67 procedure p_backout_global_cwb_event
68 (
69 p_effective_date in date
70 ,p_validate in varchar2 default 'N'
71 ,p_business_group_id in number
72 ,p_group_pl_id in number
73 ,p_life_event_id in number default null
74 ,p_lf_evt_ocrd_dt in date
75 ,p_person_id in number default null
76 ,p_bckt_stat_cd in varchar2 default 'UNPROCD'
77 );
78
79 end ben_cwb_back_out_conc;