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 7: (p_rt_cd_va in out nocopy benutils.g_v2_150_table

3: --
4: g_package varchar2(50) := 'ben_rollup_rbvs.';
5: --
6: PROCEDURE build_rollup_sql_str
7: (p_rt_cd_va in out nocopy benutils.g_v2_150_table
8: ,p_rt_fromstr_va in out nocopy benutils.g_varchar2_table
9: ,p_rt_wherestr_va in out nocopy benutils.g_varchar2_table
10: ,p_rt_sqlstr_va in out nocopy benutils.g_varchar2_table
11: ,p_rt_typcd_va in out nocopy benutils.g_v2_150_table

Line 8: ,p_rt_fromstr_va in out nocopy benutils.g_varchar2_table

4: g_package varchar2(50) := 'ben_rollup_rbvs.';
5: --
6: PROCEDURE build_rollup_sql_str
7: (p_rt_cd_va in out nocopy benutils.g_v2_150_table
8: ,p_rt_fromstr_va in out nocopy benutils.g_varchar2_table
9: ,p_rt_wherestr_va in out nocopy benutils.g_varchar2_table
10: ,p_rt_sqlstr_va in out nocopy benutils.g_varchar2_table
11: ,p_rt_typcd_va in out nocopy benutils.g_v2_150_table
12: )

Line 9: ,p_rt_wherestr_va in out nocopy benutils.g_varchar2_table

5: --
6: PROCEDURE build_rollup_sql_str
7: (p_rt_cd_va in out nocopy benutils.g_v2_150_table
8: ,p_rt_fromstr_va in out nocopy benutils.g_varchar2_table
9: ,p_rt_wherestr_va in out nocopy benutils.g_varchar2_table
10: ,p_rt_sqlstr_va in out nocopy benutils.g_varchar2_table
11: ,p_rt_typcd_va in out nocopy benutils.g_v2_150_table
12: )
13: is

Line 10: ,p_rt_sqlstr_va in out nocopy benutils.g_varchar2_table

6: PROCEDURE build_rollup_sql_str
7: (p_rt_cd_va in out nocopy benutils.g_v2_150_table
8: ,p_rt_fromstr_va in out nocopy benutils.g_varchar2_table
9: ,p_rt_wherestr_va in out nocopy benutils.g_varchar2_table
10: ,p_rt_sqlstr_va in out nocopy benutils.g_varchar2_table
11: ,p_rt_typcd_va in out nocopy benutils.g_v2_150_table
12: )
13: is
14: --

Line 11: ,p_rt_typcd_va in out nocopy benutils.g_v2_150_table

7: (p_rt_cd_va in out nocopy benutils.g_v2_150_table
8: ,p_rt_fromstr_va in out nocopy benutils.g_varchar2_table
9: ,p_rt_wherestr_va in out nocopy benutils.g_varchar2_table
10: ,p_rt_sqlstr_va in out nocopy benutils.g_varchar2_table
11: ,p_rt_typcd_va in out nocopy benutils.g_v2_150_table
12: )
13: is
14: --
15: l_rawrt_en pls_integer;

Line 16: l_rawrt_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

12: )
13: is
14: --
15: l_rawrt_en pls_integer;
16: l_rawrt_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
17: l_rawrt_typcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
18: l_rawrt_selstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
19: l_rawrt_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
20: l_rawrt_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 17: l_rawrt_typcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

13: is
14: --
15: l_rawrt_en pls_integer;
16: l_rawrt_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
17: l_rawrt_typcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
18: l_rawrt_selstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
19: l_rawrt_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
20: l_rawrt_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
21: l_rawrt_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 18: l_rawrt_selstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();

14: --
15: l_rawrt_en pls_integer;
16: l_rawrt_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
17: l_rawrt_typcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
18: l_rawrt_selstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
19: l_rawrt_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
20: l_rawrt_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
21: l_rawrt_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
22: --

Line 19: l_rawrt_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();

15: l_rawrt_en pls_integer;
16: l_rawrt_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
17: l_rawrt_typcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
18: l_rawrt_selstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
19: l_rawrt_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
20: l_rawrt_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
21: l_rawrt_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
22: --
23: l_rt_en pls_integer;

Line 20: l_rawrt_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();

16: l_rawrt_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
17: l_rawrt_typcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
18: l_rawrt_selstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
19: l_rawrt_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
20: l_rawrt_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
21: l_rawrt_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
22: --
23: l_rt_en pls_integer;
24: l_rt_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 21: l_rawrt_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();

17: l_rawrt_typcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
18: l_rawrt_selstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
19: l_rawrt_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
20: l_rawrt_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
21: l_rawrt_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
22: --
23: l_rt_en pls_integer;
24: l_rt_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
25: l_rt_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 24: l_rt_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();

20: l_rawrt_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
21: l_rawrt_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
22: --
23: l_rt_en pls_integer;
24: l_rt_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
25: l_rt_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
26: l_rt_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
27: l_rt_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
28: l_rt_typcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

Line 25: l_rt_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();

21: l_rawrt_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
22: --
23: l_rt_en pls_integer;
24: l_rt_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
25: l_rt_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
26: l_rt_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
27: l_rt_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
28: l_rt_typcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
29: --

Line 26: l_rt_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();

22: --
23: l_rt_en pls_integer;
24: l_rt_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
25: l_rt_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
26: l_rt_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
27: l_rt_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
28: l_rt_typcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
29: --
30: l_sql_str long;

Line 27: l_rt_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

23: l_rt_en pls_integer;
24: l_rt_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
25: l_rt_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
26: l_rt_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
27: l_rt_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
28: l_rt_typcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
29: --
30: l_sql_str long;
31: l_sel_str long;

Line 28: l_rt_typcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

24: l_rt_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
25: l_rt_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
26: l_rt_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
27: l_rt_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
28: l_rt_typcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
29: --
30: l_sql_str long;
31: l_sel_str long;
32: --

Line 2547: l_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

2543: ,p_sql_str in out nocopy varchar2
2544: )
2545: is
2546: --
2547: l_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
2548: l_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
2549: l_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
2550: l_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
2551: l_rbvtypcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

Line 2548: l_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();

2544: )
2545: is
2546: --
2547: l_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
2548: l_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
2549: l_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
2550: l_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
2551: l_rbvtypcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
2552: --

Line 2549: l_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();

2545: is
2546: --
2547: l_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
2548: l_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
2549: l_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
2550: l_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
2551: l_rbvtypcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
2552: --
2553: begin

Line 2550: l_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();

2546: --
2547: l_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
2548: l_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
2549: l_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
2550: l_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
2551: l_rbvtypcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
2552: --
2553: begin
2554: --

Line 2551: l_rbvtypcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

2547: l_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
2548: l_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
2549: l_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
2550: l_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
2551: l_rbvtypcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
2552: --
2553: begin
2554: --
2555: build_rollup_sql_str

Line 2602: ,p_perid_va in out nocopy benutils.g_number_table

2598: (p_rollup_code in varchar2
2599: ,p_old_benefit_action_id in number
2600: ,p_new_benefit_action_id in number
2601: --
2602: ,p_perid_va in out nocopy benutils.g_number_table
2603: )
2604: is
2605: --
2606: TYPE cur_type IS REF CURSOR;

Line 2610: l_old_perid_va benutils.g_number_table := benutils.g_number_table();

2606: TYPE cur_type IS REF CURSOR;
2607: --
2608: c_per_list cur_type;
2609: --
2610: l_old_perid_va benutils.g_number_table := benutils.g_number_table();
2611: l_old_percnt_va benutils.g_number_table := benutils.g_number_table();
2612: l_new_perid_va benutils.g_number_table := benutils.g_number_table();
2613: l_new_percnt_va benutils.g_number_table := benutils.g_number_table();
2614: l_mmperid_va benutils.g_number_table := benutils.g_number_table();

Line 2611: l_old_percnt_va benutils.g_number_table := benutils.g_number_table();

2607: --
2608: c_per_list cur_type;
2609: --
2610: l_old_perid_va benutils.g_number_table := benutils.g_number_table();
2611: l_old_percnt_va benutils.g_number_table := benutils.g_number_table();
2612: l_new_perid_va benutils.g_number_table := benutils.g_number_table();
2613: l_new_percnt_va benutils.g_number_table := benutils.g_number_table();
2614: l_mmperid_va benutils.g_number_table := benutils.g_number_table();
2615: --

Line 2612: l_new_perid_va benutils.g_number_table := benutils.g_number_table();

2608: c_per_list cur_type;
2609: --
2610: l_old_perid_va benutils.g_number_table := benutils.g_number_table();
2611: l_old_percnt_va benutils.g_number_table := benutils.g_number_table();
2612: l_new_perid_va benutils.g_number_table := benutils.g_number_table();
2613: l_new_percnt_va benutils.g_number_table := benutils.g_number_table();
2614: l_mmperid_va benutils.g_number_table := benutils.g_number_table();
2615: --
2616: l_sel_str long;

Line 2613: l_new_percnt_va benutils.g_number_table := benutils.g_number_table();

2609: --
2610: l_old_perid_va benutils.g_number_table := benutils.g_number_table();
2611: l_old_percnt_va benutils.g_number_table := benutils.g_number_table();
2612: l_new_perid_va benutils.g_number_table := benutils.g_number_table();
2613: l_new_percnt_va benutils.g_number_table := benutils.g_number_table();
2614: l_mmperid_va benutils.g_number_table := benutils.g_number_table();
2615: --
2616: l_sel_str long;
2617: l_from_str long;

Line 2614: l_mmperid_va benutils.g_number_table := benutils.g_number_table();

2610: l_old_perid_va benutils.g_number_table := benutils.g_number_table();
2611: l_old_percnt_va benutils.g_number_table := benutils.g_number_table();
2612: l_new_perid_va benutils.g_number_table := benutils.g_number_table();
2613: l_new_percnt_va benutils.g_number_table := benutils.g_number_table();
2614: l_mmperid_va benutils.g_number_table := benutils.g_number_table();
2615: --
2616: l_sel_str long;
2617: l_from_str long;
2618: l_where_str long;

Line 2910: ,p_old_perid_va in out nocopy benutils.g_number_table

2906: ,p_old_benefit_action_id in number
2907: ,p_new_benefit_action_id in number
2908: ,p_keycol_cnt in number
2909: --
2910: ,p_old_perid_va in out nocopy benutils.g_number_table
2911: ,p_old_combid_va in out nocopy benutils.g_number_table
2912: ,p_old_combid2_va in out nocopy benutils.g_number_table
2913: ,p_old_combid3_va in out nocopy benutils.g_number_table
2914: ,p_old_combid4_va in out nocopy benutils.g_number_table

Line 2911: ,p_old_combid_va in out nocopy benutils.g_number_table

2907: ,p_new_benefit_action_id in number
2908: ,p_keycol_cnt in number
2909: --
2910: ,p_old_perid_va in out nocopy benutils.g_number_table
2911: ,p_old_combid_va in out nocopy benutils.g_number_table
2912: ,p_old_combid2_va in out nocopy benutils.g_number_table
2913: ,p_old_combid3_va in out nocopy benutils.g_number_table
2914: ,p_old_combid4_va in out nocopy benutils.g_number_table
2915: ,p_old_cnt_va in out nocopy benutils.g_number_table

Line 2912: ,p_old_combid2_va in out nocopy benutils.g_number_table

2908: ,p_keycol_cnt in number
2909: --
2910: ,p_old_perid_va in out nocopy benutils.g_number_table
2911: ,p_old_combid_va in out nocopy benutils.g_number_table
2912: ,p_old_combid2_va in out nocopy benutils.g_number_table
2913: ,p_old_combid3_va in out nocopy benutils.g_number_table
2914: ,p_old_combid4_va in out nocopy benutils.g_number_table
2915: ,p_old_cnt_va in out nocopy benutils.g_number_table
2916: ,p_new_perid_va in out nocopy benutils.g_number_table

Line 2913: ,p_old_combid3_va in out nocopy benutils.g_number_table

2909: --
2910: ,p_old_perid_va in out nocopy benutils.g_number_table
2911: ,p_old_combid_va in out nocopy benutils.g_number_table
2912: ,p_old_combid2_va in out nocopy benutils.g_number_table
2913: ,p_old_combid3_va in out nocopy benutils.g_number_table
2914: ,p_old_combid4_va in out nocopy benutils.g_number_table
2915: ,p_old_cnt_va in out nocopy benutils.g_number_table
2916: ,p_new_perid_va in out nocopy benutils.g_number_table
2917: ,p_new_combid_va in out nocopy benutils.g_number_table

Line 2914: ,p_old_combid4_va in out nocopy benutils.g_number_table

2910: ,p_old_perid_va in out nocopy benutils.g_number_table
2911: ,p_old_combid_va in out nocopy benutils.g_number_table
2912: ,p_old_combid2_va in out nocopy benutils.g_number_table
2913: ,p_old_combid3_va in out nocopy benutils.g_number_table
2914: ,p_old_combid4_va in out nocopy benutils.g_number_table
2915: ,p_old_cnt_va in out nocopy benutils.g_number_table
2916: ,p_new_perid_va in out nocopy benutils.g_number_table
2917: ,p_new_combid_va in out nocopy benutils.g_number_table
2918: ,p_new_combid2_va in out nocopy benutils.g_number_table

Line 2915: ,p_old_cnt_va in out nocopy benutils.g_number_table

2911: ,p_old_combid_va in out nocopy benutils.g_number_table
2912: ,p_old_combid2_va in out nocopy benutils.g_number_table
2913: ,p_old_combid3_va in out nocopy benutils.g_number_table
2914: ,p_old_combid4_va in out nocopy benutils.g_number_table
2915: ,p_old_cnt_va in out nocopy benutils.g_number_table
2916: ,p_new_perid_va in out nocopy benutils.g_number_table
2917: ,p_new_combid_va in out nocopy benutils.g_number_table
2918: ,p_new_combid2_va in out nocopy benutils.g_number_table
2919: ,p_new_combid3_va in out nocopy benutils.g_number_table

Line 2916: ,p_new_perid_va in out nocopy benutils.g_number_table

2912: ,p_old_combid2_va in out nocopy benutils.g_number_table
2913: ,p_old_combid3_va in out nocopy benutils.g_number_table
2914: ,p_old_combid4_va in out nocopy benutils.g_number_table
2915: ,p_old_cnt_va in out nocopy benutils.g_number_table
2916: ,p_new_perid_va in out nocopy benutils.g_number_table
2917: ,p_new_combid_va in out nocopy benutils.g_number_table
2918: ,p_new_combid2_va in out nocopy benutils.g_number_table
2919: ,p_new_combid3_va in out nocopy benutils.g_number_table
2920: ,p_new_combid4_va in out nocopy benutils.g_number_table

Line 2917: ,p_new_combid_va in out nocopy benutils.g_number_table

2913: ,p_old_combid3_va in out nocopy benutils.g_number_table
2914: ,p_old_combid4_va in out nocopy benutils.g_number_table
2915: ,p_old_cnt_va in out nocopy benutils.g_number_table
2916: ,p_new_perid_va in out nocopy benutils.g_number_table
2917: ,p_new_combid_va in out nocopy benutils.g_number_table
2918: ,p_new_combid2_va in out nocopy benutils.g_number_table
2919: ,p_new_combid3_va in out nocopy benutils.g_number_table
2920: ,p_new_combid4_va in out nocopy benutils.g_number_table
2921: ,p_new_cnt_va in out nocopy benutils.g_number_table

Line 2918: ,p_new_combid2_va in out nocopy benutils.g_number_table

2914: ,p_old_combid4_va in out nocopy benutils.g_number_table
2915: ,p_old_cnt_va in out nocopy benutils.g_number_table
2916: ,p_new_perid_va in out nocopy benutils.g_number_table
2917: ,p_new_combid_va in out nocopy benutils.g_number_table
2918: ,p_new_combid2_va in out nocopy benutils.g_number_table
2919: ,p_new_combid3_va in out nocopy benutils.g_number_table
2920: ,p_new_combid4_va in out nocopy benutils.g_number_table
2921: ,p_new_cnt_va in out nocopy benutils.g_number_table
2922: )

Line 2919: ,p_new_combid3_va in out nocopy benutils.g_number_table

2915: ,p_old_cnt_va in out nocopy benutils.g_number_table
2916: ,p_new_perid_va in out nocopy benutils.g_number_table
2917: ,p_new_combid_va in out nocopy benutils.g_number_table
2918: ,p_new_combid2_va in out nocopy benutils.g_number_table
2919: ,p_new_combid3_va in out nocopy benutils.g_number_table
2920: ,p_new_combid4_va in out nocopy benutils.g_number_table
2921: ,p_new_cnt_va in out nocopy benutils.g_number_table
2922: )
2923: is

Line 2920: ,p_new_combid4_va in out nocopy benutils.g_number_table

2916: ,p_new_perid_va in out nocopy benutils.g_number_table
2917: ,p_new_combid_va in out nocopy benutils.g_number_table
2918: ,p_new_combid2_va in out nocopy benutils.g_number_table
2919: ,p_new_combid3_va in out nocopy benutils.g_number_table
2920: ,p_new_combid4_va in out nocopy benutils.g_number_table
2921: ,p_new_cnt_va in out nocopy benutils.g_number_table
2922: )
2923: is
2924: --

Line 2921: ,p_new_cnt_va in out nocopy benutils.g_number_table

2917: ,p_new_combid_va in out nocopy benutils.g_number_table
2918: ,p_new_combid2_va in out nocopy benutils.g_number_table
2919: ,p_new_combid3_va in out nocopy benutils.g_number_table
2920: ,p_new_combid4_va in out nocopy benutils.g_number_table
2921: ,p_new_cnt_va in out nocopy benutils.g_number_table
2922: )
2923: is
2924: --
2925: TYPE cur_type IS REF CURSOR;

Line 2929: l_old_perid_va benutils.g_number_table := benutils.g_number_table();

2925: TYPE cur_type IS REF CURSOR;
2926: --
2927: c_comb_list cur_type;
2928: --
2929: l_old_perid_va benutils.g_number_table := benutils.g_number_table();
2930: l_old_combid_va benutils.g_number_table := benutils.g_number_table();
2931: l_old_combid2_va benutils.g_number_table := benutils.g_number_table();
2932: l_old_combid3_va benutils.g_number_table := benutils.g_number_table();
2933: l_old_combid4_va benutils.g_number_table := benutils.g_number_table();

Line 2930: l_old_combid_va benutils.g_number_table := benutils.g_number_table();

2926: --
2927: c_comb_list cur_type;
2928: --
2929: l_old_perid_va benutils.g_number_table := benutils.g_number_table();
2930: l_old_combid_va benutils.g_number_table := benutils.g_number_table();
2931: l_old_combid2_va benutils.g_number_table := benutils.g_number_table();
2932: l_old_combid3_va benutils.g_number_table := benutils.g_number_table();
2933: l_old_combid4_va benutils.g_number_table := benutils.g_number_table();
2934: l_old_cnt_va benutils.g_number_table := benutils.g_number_table();

Line 2931: l_old_combid2_va benutils.g_number_table := benutils.g_number_table();

2927: c_comb_list cur_type;
2928: --
2929: l_old_perid_va benutils.g_number_table := benutils.g_number_table();
2930: l_old_combid_va benutils.g_number_table := benutils.g_number_table();
2931: l_old_combid2_va benutils.g_number_table := benutils.g_number_table();
2932: l_old_combid3_va benutils.g_number_table := benutils.g_number_table();
2933: l_old_combid4_va benutils.g_number_table := benutils.g_number_table();
2934: l_old_cnt_va benutils.g_number_table := benutils.g_number_table();
2935: l_new_perid_va benutils.g_number_table := benutils.g_number_table();

Line 2932: l_old_combid3_va benutils.g_number_table := benutils.g_number_table();

2928: --
2929: l_old_perid_va benutils.g_number_table := benutils.g_number_table();
2930: l_old_combid_va benutils.g_number_table := benutils.g_number_table();
2931: l_old_combid2_va benutils.g_number_table := benutils.g_number_table();
2932: l_old_combid3_va benutils.g_number_table := benutils.g_number_table();
2933: l_old_combid4_va benutils.g_number_table := benutils.g_number_table();
2934: l_old_cnt_va benutils.g_number_table := benutils.g_number_table();
2935: l_new_perid_va benutils.g_number_table := benutils.g_number_table();
2936: l_new_combid_va benutils.g_number_table := benutils.g_number_table();

Line 2933: l_old_combid4_va benutils.g_number_table := benutils.g_number_table();

2929: l_old_perid_va benutils.g_number_table := benutils.g_number_table();
2930: l_old_combid_va benutils.g_number_table := benutils.g_number_table();
2931: l_old_combid2_va benutils.g_number_table := benutils.g_number_table();
2932: l_old_combid3_va benutils.g_number_table := benutils.g_number_table();
2933: l_old_combid4_va benutils.g_number_table := benutils.g_number_table();
2934: l_old_cnt_va benutils.g_number_table := benutils.g_number_table();
2935: l_new_perid_va benutils.g_number_table := benutils.g_number_table();
2936: l_new_combid_va benutils.g_number_table := benutils.g_number_table();
2937: l_new_combid2_va benutils.g_number_table := benutils.g_number_table();

Line 2934: l_old_cnt_va benutils.g_number_table := benutils.g_number_table();

2930: l_old_combid_va benutils.g_number_table := benutils.g_number_table();
2931: l_old_combid2_va benutils.g_number_table := benutils.g_number_table();
2932: l_old_combid3_va benutils.g_number_table := benutils.g_number_table();
2933: l_old_combid4_va benutils.g_number_table := benutils.g_number_table();
2934: l_old_cnt_va benutils.g_number_table := benutils.g_number_table();
2935: l_new_perid_va benutils.g_number_table := benutils.g_number_table();
2936: l_new_combid_va benutils.g_number_table := benutils.g_number_table();
2937: l_new_combid2_va benutils.g_number_table := benutils.g_number_table();
2938: l_new_combid3_va benutils.g_number_table := benutils.g_number_table();

Line 2935: l_new_perid_va benutils.g_number_table := benutils.g_number_table();

2931: l_old_combid2_va benutils.g_number_table := benutils.g_number_table();
2932: l_old_combid3_va benutils.g_number_table := benutils.g_number_table();
2933: l_old_combid4_va benutils.g_number_table := benutils.g_number_table();
2934: l_old_cnt_va benutils.g_number_table := benutils.g_number_table();
2935: l_new_perid_va benutils.g_number_table := benutils.g_number_table();
2936: l_new_combid_va benutils.g_number_table := benutils.g_number_table();
2937: l_new_combid2_va benutils.g_number_table := benutils.g_number_table();
2938: l_new_combid3_va benutils.g_number_table := benutils.g_number_table();
2939: l_new_combid4_va benutils.g_number_table := benutils.g_number_table();

Line 2936: l_new_combid_va benutils.g_number_table := benutils.g_number_table();

2932: l_old_combid3_va benutils.g_number_table := benutils.g_number_table();
2933: l_old_combid4_va benutils.g_number_table := benutils.g_number_table();
2934: l_old_cnt_va benutils.g_number_table := benutils.g_number_table();
2935: l_new_perid_va benutils.g_number_table := benutils.g_number_table();
2936: l_new_combid_va benutils.g_number_table := benutils.g_number_table();
2937: l_new_combid2_va benutils.g_number_table := benutils.g_number_table();
2938: l_new_combid3_va benutils.g_number_table := benutils.g_number_table();
2939: l_new_combid4_va benutils.g_number_table := benutils.g_number_table();
2940: l_new_cnt_va benutils.g_number_table := benutils.g_number_table();

Line 2937: l_new_combid2_va benutils.g_number_table := benutils.g_number_table();

2933: l_old_combid4_va benutils.g_number_table := benutils.g_number_table();
2934: l_old_cnt_va benutils.g_number_table := benutils.g_number_table();
2935: l_new_perid_va benutils.g_number_table := benutils.g_number_table();
2936: l_new_combid_va benutils.g_number_table := benutils.g_number_table();
2937: l_new_combid2_va benutils.g_number_table := benutils.g_number_table();
2938: l_new_combid3_va benutils.g_number_table := benutils.g_number_table();
2939: l_new_combid4_va benutils.g_number_table := benutils.g_number_table();
2940: l_new_cnt_va benutils.g_number_table := benutils.g_number_table();
2941: --

Line 2938: l_new_combid3_va benutils.g_number_table := benutils.g_number_table();

2934: l_old_cnt_va benutils.g_number_table := benutils.g_number_table();
2935: l_new_perid_va benutils.g_number_table := benutils.g_number_table();
2936: l_new_combid_va benutils.g_number_table := benutils.g_number_table();
2937: l_new_combid2_va benutils.g_number_table := benutils.g_number_table();
2938: l_new_combid3_va benutils.g_number_table := benutils.g_number_table();
2939: l_new_combid4_va benutils.g_number_table := benutils.g_number_table();
2940: l_new_cnt_va benutils.g_number_table := benutils.g_number_table();
2941: --
2942: l_vaen pls_integer;

Line 2939: l_new_combid4_va benutils.g_number_table := benutils.g_number_table();

2935: l_new_perid_va benutils.g_number_table := benutils.g_number_table();
2936: l_new_combid_va benutils.g_number_table := benutils.g_number_table();
2937: l_new_combid2_va benutils.g_number_table := benutils.g_number_table();
2938: l_new_combid3_va benutils.g_number_table := benutils.g_number_table();
2939: l_new_combid4_va benutils.g_number_table := benutils.g_number_table();
2940: l_new_cnt_va benutils.g_number_table := benutils.g_number_table();
2941: --
2942: l_vaen pls_integer;
2943: --

Line 2940: l_new_cnt_va benutils.g_number_table := benutils.g_number_table();

2936: l_new_combid_va benutils.g_number_table := benutils.g_number_table();
2937: l_new_combid2_va benutils.g_number_table := benutils.g_number_table();
2938: l_new_combid3_va benutils.g_number_table := benutils.g_number_table();
2939: l_new_combid4_va benutils.g_number_table := benutils.g_number_table();
2940: l_new_cnt_va benutils.g_number_table := benutils.g_number_table();
2941: --
2942: l_vaen pls_integer;
2943: --
2944: l_person_id number;

Line 3154: ,p_perid_va in out nocopy benutils.g_number_table

3150: (p_rollup_code in varchar2
3151: ,p_old_benefit_action_id in number
3152: ,p_new_benefit_action_id in number
3153: --
3154: ,p_perid_va in out nocopy benutils.g_number_table
3155: ,p_perlud_va in out nocopy benutils.g_date_table
3156: ,p_combnm_va in out nocopy benutils.g_varchar2_table
3157: ,p_combnm2_va in out nocopy benutils.g_varchar2_table
3158: ,p_combnm3_va in out nocopy benutils.g_varchar2_table

Line 3155: ,p_perlud_va in out nocopy benutils.g_date_table

3151: ,p_old_benefit_action_id in number
3152: ,p_new_benefit_action_id in number
3153: --
3154: ,p_perid_va in out nocopy benutils.g_number_table
3155: ,p_perlud_va in out nocopy benutils.g_date_table
3156: ,p_combnm_va in out nocopy benutils.g_varchar2_table
3157: ,p_combnm2_va in out nocopy benutils.g_varchar2_table
3158: ,p_combnm3_va in out nocopy benutils.g_varchar2_table
3159: ,p_combnm4_va in out nocopy benutils.g_varchar2_table

Line 3156: ,p_combnm_va in out nocopy benutils.g_varchar2_table

3152: ,p_new_benefit_action_id in number
3153: --
3154: ,p_perid_va in out nocopy benutils.g_number_table
3155: ,p_perlud_va in out nocopy benutils.g_date_table
3156: ,p_combnm_va in out nocopy benutils.g_varchar2_table
3157: ,p_combnm2_va in out nocopy benutils.g_varchar2_table
3158: ,p_combnm3_va in out nocopy benutils.g_varchar2_table
3159: ,p_combnm4_va in out nocopy benutils.g_varchar2_table
3160: ,p_combid_va in out nocopy benutils.g_number_table

Line 3157: ,p_combnm2_va in out nocopy benutils.g_varchar2_table

3153: --
3154: ,p_perid_va in out nocopy benutils.g_number_table
3155: ,p_perlud_va in out nocopy benutils.g_date_table
3156: ,p_combnm_va in out nocopy benutils.g_varchar2_table
3157: ,p_combnm2_va in out nocopy benutils.g_varchar2_table
3158: ,p_combnm3_va in out nocopy benutils.g_varchar2_table
3159: ,p_combnm4_va in out nocopy benutils.g_varchar2_table
3160: ,p_combid_va in out nocopy benutils.g_number_table
3161: ,p_combid2_va in out nocopy benutils.g_number_table

Line 3158: ,p_combnm3_va in out nocopy benutils.g_varchar2_table

3154: ,p_perid_va in out nocopy benutils.g_number_table
3155: ,p_perlud_va in out nocopy benutils.g_date_table
3156: ,p_combnm_va in out nocopy benutils.g_varchar2_table
3157: ,p_combnm2_va in out nocopy benutils.g_varchar2_table
3158: ,p_combnm3_va in out nocopy benutils.g_varchar2_table
3159: ,p_combnm4_va in out nocopy benutils.g_varchar2_table
3160: ,p_combid_va in out nocopy benutils.g_number_table
3161: ,p_combid2_va in out nocopy benutils.g_number_table
3162: ,p_combid3_va in out nocopy benutils.g_number_table

Line 3159: ,p_combnm4_va in out nocopy benutils.g_varchar2_table

3155: ,p_perlud_va in out nocopy benutils.g_date_table
3156: ,p_combnm_va in out nocopy benutils.g_varchar2_table
3157: ,p_combnm2_va in out nocopy benutils.g_varchar2_table
3158: ,p_combnm3_va in out nocopy benutils.g_varchar2_table
3159: ,p_combnm4_va in out nocopy benutils.g_varchar2_table
3160: ,p_combid_va in out nocopy benutils.g_number_table
3161: ,p_combid2_va in out nocopy benutils.g_number_table
3162: ,p_combid3_va in out nocopy benutils.g_number_table
3163: ,p_combid4_va in out nocopy benutils.g_number_table

Line 3160: ,p_combid_va in out nocopy benutils.g_number_table

3156: ,p_combnm_va in out nocopy benutils.g_varchar2_table
3157: ,p_combnm2_va in out nocopy benutils.g_varchar2_table
3158: ,p_combnm3_va in out nocopy benutils.g_varchar2_table
3159: ,p_combnm4_va in out nocopy benutils.g_varchar2_table
3160: ,p_combid_va in out nocopy benutils.g_number_table
3161: ,p_combid2_va in out nocopy benutils.g_number_table
3162: ,p_combid3_va in out nocopy benutils.g_number_table
3163: ,p_combid4_va in out nocopy benutils.g_number_table
3164: ,p_cnt_va in out nocopy benutils.g_number_table

Line 3161: ,p_combid2_va in out nocopy benutils.g_number_table

3157: ,p_combnm2_va in out nocopy benutils.g_varchar2_table
3158: ,p_combnm3_va in out nocopy benutils.g_varchar2_table
3159: ,p_combnm4_va in out nocopy benutils.g_varchar2_table
3160: ,p_combid_va in out nocopy benutils.g_number_table
3161: ,p_combid2_va in out nocopy benutils.g_number_table
3162: ,p_combid3_va in out nocopy benutils.g_number_table
3163: ,p_combid4_va in out nocopy benutils.g_number_table
3164: ,p_cnt_va in out nocopy benutils.g_number_table
3165: )

Line 3162: ,p_combid3_va in out nocopy benutils.g_number_table

3158: ,p_combnm3_va in out nocopy benutils.g_varchar2_table
3159: ,p_combnm4_va in out nocopy benutils.g_varchar2_table
3160: ,p_combid_va in out nocopy benutils.g_number_table
3161: ,p_combid2_va in out nocopy benutils.g_number_table
3162: ,p_combid3_va in out nocopy benutils.g_number_table
3163: ,p_combid4_va in out nocopy benutils.g_number_table
3164: ,p_cnt_va in out nocopy benutils.g_number_table
3165: )
3166: is

Line 3163: ,p_combid4_va in out nocopy benutils.g_number_table

3159: ,p_combnm4_va in out nocopy benutils.g_varchar2_table
3160: ,p_combid_va in out nocopy benutils.g_number_table
3161: ,p_combid2_va in out nocopy benutils.g_number_table
3162: ,p_combid3_va in out nocopy benutils.g_number_table
3163: ,p_combid4_va in out nocopy benutils.g_number_table
3164: ,p_cnt_va in out nocopy benutils.g_number_table
3165: )
3166: is
3167: --

Line 3164: ,p_cnt_va in out nocopy benutils.g_number_table

3160: ,p_combid_va in out nocopy benutils.g_number_table
3161: ,p_combid2_va in out nocopy benutils.g_number_table
3162: ,p_combid3_va in out nocopy benutils.g_number_table
3163: ,p_combid4_va in out nocopy benutils.g_number_table
3164: ,p_cnt_va in out nocopy benutils.g_number_table
3165: )
3166: is
3167: --
3168: TYPE cur_type IS REF CURSOR;

Line 3172: l_old_perid_va benutils.g_number_table := benutils.g_number_table();

3168: TYPE cur_type IS REF CURSOR;
3169: --
3170: c_rbvmaxlud cur_type;
3171: --
3172: l_old_perid_va benutils.g_number_table := benutils.g_number_table();
3173: l_old_combid_va benutils.g_number_table := benutils.g_number_table();
3174: l_old_combid2_va benutils.g_number_table := benutils.g_number_table();
3175: l_old_combid3_va benutils.g_number_table := benutils.g_number_table();
3176: l_old_combid4_va benutils.g_number_table := benutils.g_number_table();

Line 3173: l_old_combid_va benutils.g_number_table := benutils.g_number_table();

3169: --
3170: c_rbvmaxlud cur_type;
3171: --
3172: l_old_perid_va benutils.g_number_table := benutils.g_number_table();
3173: l_old_combid_va benutils.g_number_table := benutils.g_number_table();
3174: l_old_combid2_va benutils.g_number_table := benutils.g_number_table();
3175: l_old_combid3_va benutils.g_number_table := benutils.g_number_table();
3176: l_old_combid4_va benutils.g_number_table := benutils.g_number_table();
3177: l_old_cnt_va benutils.g_number_table := benutils.g_number_table();

Line 3174: l_old_combid2_va benutils.g_number_table := benutils.g_number_table();

3170: c_rbvmaxlud cur_type;
3171: --
3172: l_old_perid_va benutils.g_number_table := benutils.g_number_table();
3173: l_old_combid_va benutils.g_number_table := benutils.g_number_table();
3174: l_old_combid2_va benutils.g_number_table := benutils.g_number_table();
3175: l_old_combid3_va benutils.g_number_table := benutils.g_number_table();
3176: l_old_combid4_va benutils.g_number_table := benutils.g_number_table();
3177: l_old_cnt_va benutils.g_number_table := benutils.g_number_table();
3178: l_new_perid_va benutils.g_number_table := benutils.g_number_table();

Line 3175: l_old_combid3_va benutils.g_number_table := benutils.g_number_table();

3171: --
3172: l_old_perid_va benutils.g_number_table := benutils.g_number_table();
3173: l_old_combid_va benutils.g_number_table := benutils.g_number_table();
3174: l_old_combid2_va benutils.g_number_table := benutils.g_number_table();
3175: l_old_combid3_va benutils.g_number_table := benutils.g_number_table();
3176: l_old_combid4_va benutils.g_number_table := benutils.g_number_table();
3177: l_old_cnt_va benutils.g_number_table := benutils.g_number_table();
3178: l_new_perid_va benutils.g_number_table := benutils.g_number_table();
3179: l_new_combid_va benutils.g_number_table := benutils.g_number_table();

Line 3176: l_old_combid4_va benutils.g_number_table := benutils.g_number_table();

3172: l_old_perid_va benutils.g_number_table := benutils.g_number_table();
3173: l_old_combid_va benutils.g_number_table := benutils.g_number_table();
3174: l_old_combid2_va benutils.g_number_table := benutils.g_number_table();
3175: l_old_combid3_va benutils.g_number_table := benutils.g_number_table();
3176: l_old_combid4_va benutils.g_number_table := benutils.g_number_table();
3177: l_old_cnt_va benutils.g_number_table := benutils.g_number_table();
3178: l_new_perid_va benutils.g_number_table := benutils.g_number_table();
3179: l_new_combid_va benutils.g_number_table := benutils.g_number_table();
3180: l_new_combid2_va benutils.g_number_table := benutils.g_number_table();

Line 3177: l_old_cnt_va benutils.g_number_table := benutils.g_number_table();

3173: l_old_combid_va benutils.g_number_table := benutils.g_number_table();
3174: l_old_combid2_va benutils.g_number_table := benutils.g_number_table();
3175: l_old_combid3_va benutils.g_number_table := benutils.g_number_table();
3176: l_old_combid4_va benutils.g_number_table := benutils.g_number_table();
3177: l_old_cnt_va benutils.g_number_table := benutils.g_number_table();
3178: l_new_perid_va benutils.g_number_table := benutils.g_number_table();
3179: l_new_combid_va benutils.g_number_table := benutils.g_number_table();
3180: l_new_combid2_va benutils.g_number_table := benutils.g_number_table();
3181: l_new_combid3_va benutils.g_number_table := benutils.g_number_table();

Line 3178: l_new_perid_va benutils.g_number_table := benutils.g_number_table();

3174: l_old_combid2_va benutils.g_number_table := benutils.g_number_table();
3175: l_old_combid3_va benutils.g_number_table := benutils.g_number_table();
3176: l_old_combid4_va benutils.g_number_table := benutils.g_number_table();
3177: l_old_cnt_va benutils.g_number_table := benutils.g_number_table();
3178: l_new_perid_va benutils.g_number_table := benutils.g_number_table();
3179: l_new_combid_va benutils.g_number_table := benutils.g_number_table();
3180: l_new_combid2_va benutils.g_number_table := benutils.g_number_table();
3181: l_new_combid3_va benutils.g_number_table := benutils.g_number_table();
3182: l_new_combid4_va benutils.g_number_table := benutils.g_number_table();

Line 3179: l_new_combid_va benutils.g_number_table := benutils.g_number_table();

3175: l_old_combid3_va benutils.g_number_table := benutils.g_number_table();
3176: l_old_combid4_va benutils.g_number_table := benutils.g_number_table();
3177: l_old_cnt_va benutils.g_number_table := benutils.g_number_table();
3178: l_new_perid_va benutils.g_number_table := benutils.g_number_table();
3179: l_new_combid_va benutils.g_number_table := benutils.g_number_table();
3180: l_new_combid2_va benutils.g_number_table := benutils.g_number_table();
3181: l_new_combid3_va benutils.g_number_table := benutils.g_number_table();
3182: l_new_combid4_va benutils.g_number_table := benutils.g_number_table();
3183: l_new_cnt_va benutils.g_number_table := benutils.g_number_table();

Line 3180: l_new_combid2_va benutils.g_number_table := benutils.g_number_table();

3176: l_old_combid4_va benutils.g_number_table := benutils.g_number_table();
3177: l_old_cnt_va benutils.g_number_table := benutils.g_number_table();
3178: l_new_perid_va benutils.g_number_table := benutils.g_number_table();
3179: l_new_combid_va benutils.g_number_table := benutils.g_number_table();
3180: l_new_combid2_va benutils.g_number_table := benutils.g_number_table();
3181: l_new_combid3_va benutils.g_number_table := benutils.g_number_table();
3182: l_new_combid4_va benutils.g_number_table := benutils.g_number_table();
3183: l_new_cnt_va benutils.g_number_table := benutils.g_number_table();
3184: l_mmperid_va benutils.g_number_table := benutils.g_number_table();

Line 3181: l_new_combid3_va benutils.g_number_table := benutils.g_number_table();

3177: l_old_cnt_va benutils.g_number_table := benutils.g_number_table();
3178: l_new_perid_va benutils.g_number_table := benutils.g_number_table();
3179: l_new_combid_va benutils.g_number_table := benutils.g_number_table();
3180: l_new_combid2_va benutils.g_number_table := benutils.g_number_table();
3181: l_new_combid3_va benutils.g_number_table := benutils.g_number_table();
3182: l_new_combid4_va benutils.g_number_table := benutils.g_number_table();
3183: l_new_cnt_va benutils.g_number_table := benutils.g_number_table();
3184: l_mmperid_va benutils.g_number_table := benutils.g_number_table();
3185: l_mmperlud_va benutils.g_date_table := benutils.g_date_table();

Line 3182: l_new_combid4_va benutils.g_number_table := benutils.g_number_table();

3178: l_new_perid_va benutils.g_number_table := benutils.g_number_table();
3179: l_new_combid_va benutils.g_number_table := benutils.g_number_table();
3180: l_new_combid2_va benutils.g_number_table := benutils.g_number_table();
3181: l_new_combid3_va benutils.g_number_table := benutils.g_number_table();
3182: l_new_combid4_va benutils.g_number_table := benutils.g_number_table();
3183: l_new_cnt_va benutils.g_number_table := benutils.g_number_table();
3184: l_mmperid_va benutils.g_number_table := benutils.g_number_table();
3185: l_mmperlud_va benutils.g_date_table := benutils.g_date_table();
3186: l_mmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 3183: l_new_cnt_va benutils.g_number_table := benutils.g_number_table();

3179: l_new_combid_va benutils.g_number_table := benutils.g_number_table();
3180: l_new_combid2_va benutils.g_number_table := benutils.g_number_table();
3181: l_new_combid3_va benutils.g_number_table := benutils.g_number_table();
3182: l_new_combid4_va benutils.g_number_table := benutils.g_number_table();
3183: l_new_cnt_va benutils.g_number_table := benutils.g_number_table();
3184: l_mmperid_va benutils.g_number_table := benutils.g_number_table();
3185: l_mmperlud_va benutils.g_date_table := benutils.g_date_table();
3186: l_mmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3187: l_mmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 3184: l_mmperid_va benutils.g_number_table := benutils.g_number_table();

3180: l_new_combid2_va benutils.g_number_table := benutils.g_number_table();
3181: l_new_combid3_va benutils.g_number_table := benutils.g_number_table();
3182: l_new_combid4_va benutils.g_number_table := benutils.g_number_table();
3183: l_new_cnt_va benutils.g_number_table := benutils.g_number_table();
3184: l_mmperid_va benutils.g_number_table := benutils.g_number_table();
3185: l_mmperlud_va benutils.g_date_table := benutils.g_date_table();
3186: l_mmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3187: l_mmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3188: l_mmcombnm3_va benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 3185: l_mmperlud_va benutils.g_date_table := benutils.g_date_table();

3181: l_new_combid3_va benutils.g_number_table := benutils.g_number_table();
3182: l_new_combid4_va benutils.g_number_table := benutils.g_number_table();
3183: l_new_cnt_va benutils.g_number_table := benutils.g_number_table();
3184: l_mmperid_va benutils.g_number_table := benutils.g_number_table();
3185: l_mmperlud_va benutils.g_date_table := benutils.g_date_table();
3186: l_mmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3187: l_mmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3188: l_mmcombnm3_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3189: l_mmcombnm4_va benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 3186: l_mmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();

3182: l_new_combid4_va benutils.g_number_table := benutils.g_number_table();
3183: l_new_cnt_va benutils.g_number_table := benutils.g_number_table();
3184: l_mmperid_va benutils.g_number_table := benutils.g_number_table();
3185: l_mmperlud_va benutils.g_date_table := benutils.g_date_table();
3186: l_mmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3187: l_mmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3188: l_mmcombnm3_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3189: l_mmcombnm4_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3190: l_mmcombid_va benutils.g_number_table := benutils.g_number_table();

Line 3187: l_mmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();

3183: l_new_cnt_va benutils.g_number_table := benutils.g_number_table();
3184: l_mmperid_va benutils.g_number_table := benutils.g_number_table();
3185: l_mmperlud_va benutils.g_date_table := benutils.g_date_table();
3186: l_mmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3187: l_mmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3188: l_mmcombnm3_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3189: l_mmcombnm4_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3190: l_mmcombid_va benutils.g_number_table := benutils.g_number_table();
3191: l_mmcombid2_va benutils.g_number_table := benutils.g_number_table();

Line 3188: l_mmcombnm3_va benutils.g_varchar2_table := benutils.g_varchar2_table();

3184: l_mmperid_va benutils.g_number_table := benutils.g_number_table();
3185: l_mmperlud_va benutils.g_date_table := benutils.g_date_table();
3186: l_mmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3187: l_mmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3188: l_mmcombnm3_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3189: l_mmcombnm4_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3190: l_mmcombid_va benutils.g_number_table := benutils.g_number_table();
3191: l_mmcombid2_va benutils.g_number_table := benutils.g_number_table();
3192: l_mmcombid3_va benutils.g_number_table := benutils.g_number_table();

Line 3189: l_mmcombnm4_va benutils.g_varchar2_table := benutils.g_varchar2_table();

3185: l_mmperlud_va benutils.g_date_table := benutils.g_date_table();
3186: l_mmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3187: l_mmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3188: l_mmcombnm3_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3189: l_mmcombnm4_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3190: l_mmcombid_va benutils.g_number_table := benutils.g_number_table();
3191: l_mmcombid2_va benutils.g_number_table := benutils.g_number_table();
3192: l_mmcombid3_va benutils.g_number_table := benutils.g_number_table();
3193: l_mmcombid4_va benutils.g_number_table := benutils.g_number_table();

Line 3190: l_mmcombid_va benutils.g_number_table := benutils.g_number_table();

3186: l_mmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3187: l_mmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3188: l_mmcombnm3_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3189: l_mmcombnm4_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3190: l_mmcombid_va benutils.g_number_table := benutils.g_number_table();
3191: l_mmcombid2_va benutils.g_number_table := benutils.g_number_table();
3192: l_mmcombid3_va benutils.g_number_table := benutils.g_number_table();
3193: l_mmcombid4_va benutils.g_number_table := benutils.g_number_table();
3194: l_mmcnt_va benutils.g_number_table := benutils.g_number_table();

Line 3191: l_mmcombid2_va benutils.g_number_table := benutils.g_number_table();

3187: l_mmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3188: l_mmcombnm3_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3189: l_mmcombnm4_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3190: l_mmcombid_va benutils.g_number_table := benutils.g_number_table();
3191: l_mmcombid2_va benutils.g_number_table := benutils.g_number_table();
3192: l_mmcombid3_va benutils.g_number_table := benutils.g_number_table();
3193: l_mmcombid4_va benutils.g_number_table := benutils.g_number_table();
3194: l_mmcnt_va benutils.g_number_table := benutils.g_number_table();
3195: --

Line 3192: l_mmcombid3_va benutils.g_number_table := benutils.g_number_table();

3188: l_mmcombnm3_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3189: l_mmcombnm4_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3190: l_mmcombid_va benutils.g_number_table := benutils.g_number_table();
3191: l_mmcombid2_va benutils.g_number_table := benutils.g_number_table();
3192: l_mmcombid3_va benutils.g_number_table := benutils.g_number_table();
3193: l_mmcombid4_va benutils.g_number_table := benutils.g_number_table();
3194: l_mmcnt_va benutils.g_number_table := benutils.g_number_table();
3195: --
3196: l_keycol_str long;

Line 3193: l_mmcombid4_va benutils.g_number_table := benutils.g_number_table();

3189: l_mmcombnm4_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3190: l_mmcombid_va benutils.g_number_table := benutils.g_number_table();
3191: l_mmcombid2_va benutils.g_number_table := benutils.g_number_table();
3192: l_mmcombid3_va benutils.g_number_table := benutils.g_number_table();
3193: l_mmcombid4_va benutils.g_number_table := benutils.g_number_table();
3194: l_mmcnt_va benutils.g_number_table := benutils.g_number_table();
3195: --
3196: l_keycol_str long;
3197: --

Line 3194: l_mmcnt_va benutils.g_number_table := benutils.g_number_table();

3190: l_mmcombid_va benutils.g_number_table := benutils.g_number_table();
3191: l_mmcombid2_va benutils.g_number_table := benutils.g_number_table();
3192: l_mmcombid3_va benutils.g_number_table := benutils.g_number_table();
3193: l_mmcombid4_va benutils.g_number_table := benutils.g_number_table();
3194: l_mmcnt_va benutils.g_number_table := benutils.g_number_table();
3195: --
3196: l_keycol_str long;
3197: --
3198: l_sel_str long;

Line 3993: l_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

3989: --
3990: l_rbv_summary_row t_rbvsum_rec;
3991: l_rbv_detail_row t_rbvdet_rec;
3992: --
3993: l_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
3994: l_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3995: l_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3996: l_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3997: l_rbvtypcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

Line 3994: l_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();

3990: l_rbv_summary_row t_rbvsum_rec;
3991: l_rbv_detail_row t_rbvdet_rec;
3992: --
3993: l_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
3994: l_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3995: l_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3996: l_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3997: l_rbvtypcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
3998: --

Line 3995: l_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();

3991: l_rbv_detail_row t_rbvdet_rec;
3992: --
3993: l_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
3994: l_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3995: l_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3996: l_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3997: l_rbvtypcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
3998: --
3999: l_batch_id_va benutils.g_number_table := benutils.g_number_table();

Line 3996: l_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();

3992: --
3993: l_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
3994: l_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3995: l_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3996: l_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3997: l_rbvtypcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
3998: --
3999: l_batch_id_va benutils.g_number_table := benutils.g_number_table();
4000: l_batch_type_va benutils.g_v2_150_table := benutils.g_v2_150_table();

Line 3997: l_rbvtypcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

3993: l_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
3994: l_sqlstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3995: l_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3996: l_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3997: l_rbvtypcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
3998: --
3999: l_batch_id_va benutils.g_number_table := benutils.g_number_table();
4000: l_batch_type_va benutils.g_v2_150_table := benutils.g_v2_150_table();
4001: l_class_code_va benutils.g_v2_150_table := benutils.g_v2_150_table();

Line 3999: l_batch_id_va benutils.g_number_table := benutils.g_number_table();

3995: l_fromstr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3996: l_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3997: l_rbvtypcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
3998: --
3999: l_batch_id_va benutils.g_number_table := benutils.g_number_table();
4000: l_batch_type_va benutils.g_v2_150_table := benutils.g_v2_150_table();
4001: l_class_code_va benutils.g_v2_150_table := benutils.g_v2_150_table();
4002: l_class_code_count_va benutils.g_number_table := benutils.g_number_table();
4003: l_class_sumovn_va benutils.g_number_table := benutils.g_number_table();

Line 4000: l_batch_type_va benutils.g_v2_150_table := benutils.g_v2_150_table();

3996: l_wherestr_va benutils.g_varchar2_table := benutils.g_varchar2_table();
3997: l_rbvtypcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
3998: --
3999: l_batch_id_va benutils.g_number_table := benutils.g_number_table();
4000: l_batch_type_va benutils.g_v2_150_table := benutils.g_v2_150_table();
4001: l_class_code_va benutils.g_v2_150_table := benutils.g_v2_150_table();
4002: l_class_code_count_va benutils.g_number_table := benutils.g_number_table();
4003: l_class_sumovn_va benutils.g_number_table := benutils.g_number_table();
4004: l_class_minesd_va benutils.g_date_table := benutils.g_date_table();

Line 4001: l_class_code_va benutils.g_v2_150_table := benutils.g_v2_150_table();

3997: l_rbvtypcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
3998: --
3999: l_batch_id_va benutils.g_number_table := benutils.g_number_table();
4000: l_batch_type_va benutils.g_v2_150_table := benutils.g_v2_150_table();
4001: l_class_code_va benutils.g_v2_150_table := benutils.g_v2_150_table();
4002: l_class_code_count_va benutils.g_number_table := benutils.g_number_table();
4003: l_class_sumovn_va benutils.g_number_table := benutils.g_number_table();
4004: l_class_minesd_va benutils.g_date_table := benutils.g_date_table();
4005: l_class_mineed_va benutils.g_date_table := benutils.g_date_table();

Line 4002: l_class_code_count_va benutils.g_number_table := benutils.g_number_table();

3998: --
3999: l_batch_id_va benutils.g_number_table := benutils.g_number_table();
4000: l_batch_type_va benutils.g_v2_150_table := benutils.g_v2_150_table();
4001: l_class_code_va benutils.g_v2_150_table := benutils.g_v2_150_table();
4002: l_class_code_count_va benutils.g_number_table := benutils.g_number_table();
4003: l_class_sumovn_va benutils.g_number_table := benutils.g_number_table();
4004: l_class_minesd_va benutils.g_date_table := benutils.g_date_table();
4005: l_class_mineed_va benutils.g_date_table := benutils.g_date_table();
4006: l_class_idstr_va t_v2_4000_va := t_v2_4000_va();

Line 4003: l_class_sumovn_va benutils.g_number_table := benutils.g_number_table();

3999: l_batch_id_va benutils.g_number_table := benutils.g_number_table();
4000: l_batch_type_va benutils.g_v2_150_table := benutils.g_v2_150_table();
4001: l_class_code_va benutils.g_v2_150_table := benutils.g_v2_150_table();
4002: l_class_code_count_va benutils.g_number_table := benutils.g_number_table();
4003: l_class_sumovn_va benutils.g_number_table := benutils.g_number_table();
4004: l_class_minesd_va benutils.g_date_table := benutils.g_date_table();
4005: l_class_mineed_va benutils.g_date_table := benutils.g_date_table();
4006: l_class_idstr_va t_v2_4000_va := t_v2_4000_va();
4007: l_class_datestr_va t_v2_4000_va := t_v2_4000_va();

Line 4004: l_class_minesd_va benutils.g_date_table := benutils.g_date_table();

4000: l_batch_type_va benutils.g_v2_150_table := benutils.g_v2_150_table();
4001: l_class_code_va benutils.g_v2_150_table := benutils.g_v2_150_table();
4002: l_class_code_count_va benutils.g_number_table := benutils.g_number_table();
4003: l_class_sumovn_va benutils.g_number_table := benutils.g_number_table();
4004: l_class_minesd_va benutils.g_date_table := benutils.g_date_table();
4005: l_class_mineed_va benutils.g_date_table := benutils.g_date_table();
4006: l_class_idstr_va t_v2_4000_va := t_v2_4000_va();
4007: l_class_datestr_va t_v2_4000_va := t_v2_4000_va();
4008: l_class_valuestr_va t_v2_4000_va := t_v2_4000_va();

Line 4005: l_class_mineed_va benutils.g_date_table := benutils.g_date_table();

4001: l_class_code_va benutils.g_v2_150_table := benutils.g_v2_150_table();
4002: l_class_code_count_va benutils.g_number_table := benutils.g_number_table();
4003: l_class_sumovn_va benutils.g_number_table := benutils.g_number_table();
4004: l_class_minesd_va benutils.g_date_table := benutils.g_date_table();
4005: l_class_mineed_va benutils.g_date_table := benutils.g_date_table();
4006: l_class_idstr_va t_v2_4000_va := t_v2_4000_va();
4007: l_class_datestr_va t_v2_4000_va := t_v2_4000_va();
4008: l_class_valuestr_va t_v2_4000_va := t_v2_4000_va();
4009: --