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
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: );
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: --
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
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
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
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
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
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
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
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
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
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
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: );
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: --
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
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