eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ROLLUP_RBVS dependencies on BENUTILS

Line 5: (p_rt_cd_va in out nocopy benutils.g_v2_150_table

1: PACKAGE ben_rollup_rbvs AUTHID CURRENT_USER 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

Line 6: ,p_rt_fromstr_va in out nocopy benutils.g_varchar2_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: );

Line 7: ,p_rt_wherestr_va in out nocopy benutils.g_varchar2_table

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

Line 8: ,p_rt_sqlstr_va in out nocopy benutils.g_varchar2_table

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

Line 9: ,p_rt_typcd_va in out nocopy benutils.g_v2_150_table

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

Line 25: ,p_perid_va in out nocopy benutils.g_number_table

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

Line 33: ,p_perid_va in out nocopy benutils.g_number_table

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

Line 34: ,p_perlud_va in out nocopy benutils.g_date_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

Line 35: ,p_combnm_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

Line 36: ,p_combnm2_va in out nocopy benutils.g_varchar2_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

Line 37: ,p_combnm3_va in out nocopy benutils.g_varchar2_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

Line 38: ,p_combnm4_va in out nocopy benutils.g_varchar2_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

Line 39: ,p_combid_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

Line 40: ,p_combid2_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: );

Line 41: ,p_combid3_va in out nocopy benutils.g_number_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: --

Line 42: ,p_combid4_va in out nocopy benutils.g_number_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

Line 43: ,p_cnt_va in out nocopy benutils.g_number_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