1 package ben_cwb_back_out_conc AUTHID CURRENT_USER as
2 /* $Header: bencwbbo.pkh 120.3 2011/05/17 11:45:15 nchinnam ship $ */
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 * 01-Sep-10 sgnanama ER 7215216 : added person_id parameter
23 * in process procedure
24 * -----------------------------------------------------------------------------
25 */
26
27 procedure restart (errbuf out nocopy varchar2
28 ,retcode out nocopy number
29 ,p_benefit_action_id in number) ;
30
31
32 procedure do_multithread
33 (errbuf out nocopy varchar2
34 ,retcode out nocopy number
35 ,p_validate in varchar2 default 'N'
36 ,p_benefit_action_id in number
37 ,p_thread_id in number
38 ,p_effective_date in varchar2
39 ,p_business_group_id in number
40 ,p_ocrd_date in varchar2
41 ,p_group_pl_id in number
42 ,p_life_event_id in number
43 ,p_bckt_stat_cd in varchar2
44 ) ;
45
46
47 procedure delete_cwb_data
48 (p_per_in_ler_id in number
49 ,p_business_group_id in number
50 ,p_update_summary in boolean default false
51 ) ;
52
53
54 procedure process
55 (errbuf out nocopy varchar2
56 ,retcode out nocopy number
57 ,p_benefit_action_id in number default null
58 ,p_effective_date in varchar2
59 ,p_validate in varchar2 default 'N'
60 ,p_business_group_id in number
61 ,p_group_pl_id in number
62 ,p_life_event_id in number
63 ,p_ocrd_date in varchar2
64 ,p_person_selection_rule_id in number default null
65 ,p_debug_messages in varchar2 default 'N'
66 ,p_bckt_stat_cd in varchar2 default 'UNPROCD'
67 ,p_person_id in number default NULL
68 ) ;
69
70 procedure p_backout_global_cwb_event
71 (
72 p_effective_date in date
73 ,p_validate in varchar2 default 'N'
74 ,p_business_group_id in number
75 ,p_group_pl_id in number
76 ,p_life_event_id in number default null
77 ,p_lf_evt_ocrd_dt in date
78 ,p_person_id in number default null
79 ,p_bckt_stat_cd in varchar2 default 'UNPROCD'
80 );
81
82 end ben_cwb_back_out_conc;