1 PACKAGE ben_rollup_rbvs AS
2 /* $Header: benrbvru.pkh 120.0 2005/05/28 09:25:35 appldev noship $ */
3 --
4 PROCEDURE build_rollup_sql_str
5 (p_rt_cd_va in out nocopy benutils.g_v2_150_table
6 ,p_rt_fromstr_va in out nocopy benutils.g_varchar2_table
7 ,p_rt_wherestr_va in out nocopy benutils.g_varchar2_table
8 ,p_rt_sqlstr_va in out nocopy benutils.g_varchar2_table
9 ,p_rt_typcd_va in out nocopy benutils.g_v2_150_table
10 );
11 --
12 PROCEDURE get_rollup_code_sql_dets
13 (p_rollup_code in varchar2
14 --
15 ,p_from_str in out nocopy varchar2
16 ,p_where_str in out nocopy varchar2
17 ,p_sql_str in out nocopy varchar2
18 );
19 --
20 PROCEDURE get_rollup_code_perid_va
21 (p_rollup_code in varchar2
22 ,p_old_benefit_action_id in number
23 ,p_new_benefit_action_id in number
24 --
25 ,p_perid_va in out nocopy benutils.g_number_table
26 );
27 --
28 PROCEDURE get_rollup_code_combkey_va
29 (p_rollup_code in varchar2
30 ,p_old_benefit_action_id in number
31 ,p_new_benefit_action_id in number
32 --
33 ,p_perid_va in out nocopy benutils.g_number_table
34 ,p_perlud_va in out nocopy benutils.g_date_table
35 ,p_combnm_va in out nocopy benutils.g_varchar2_table
36 ,p_combnm2_va in out nocopy benutils.g_varchar2_table
37 ,p_combnm3_va in out nocopy benutils.g_varchar2_table
38 ,p_combnm4_va in out nocopy benutils.g_varchar2_table
39 ,p_combid_va in out nocopy benutils.g_number_table
40 ,p_combid2_va in out nocopy benutils.g_number_table
41 ,p_combid3_va in out nocopy benutils.g_number_table
42 ,p_combid4_va in out nocopy benutils.g_number_table
43 ,p_cnt_va in out nocopy benutils.g_number_table
44 );
45 --
46 PROCEDURE rollup_benmngle_rbvs
47 (p_benefit_action_id in number
48 ,p_refresh_rollups in varchar2 default 'N'
49 );
50 --
51 END ben_rollup_rbvs;