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_TEST_HARNESS dependencies on BENUTILS

Line 6: g_alertsev1reas_va benutils.g_v2_150_table := benutils.g_v2_150_table();

2: /* $Header: bentsthn.pkb 120.0 2005/05/28 09:31:40 appldev noship $ */
3: --
4: g_package varchar2(50) := 'ben_test_harness.';
5: --
6: g_alertsev1reas_va benutils.g_v2_150_table := benutils.g_v2_150_table();
7: g_alertsev1bftid_va benutils.g_number_table := benutils.g_number_table();
8: g_alertsev1prevbftid_va benutils.g_number_table := benutils.g_number_table();
9: --
10: g_alertsev2reas_va benutils.g_v2_150_table := benutils.g_v2_150_table();

Line 7: g_alertsev1bftid_va benutils.g_number_table := benutils.g_number_table();

3: --
4: g_package varchar2(50) := 'ben_test_harness.';
5: --
6: g_alertsev1reas_va benutils.g_v2_150_table := benutils.g_v2_150_table();
7: g_alertsev1bftid_va benutils.g_number_table := benutils.g_number_table();
8: g_alertsev1prevbftid_va benutils.g_number_table := benutils.g_number_table();
9: --
10: g_alertsev2reas_va benutils.g_v2_150_table := benutils.g_v2_150_table();
11: g_alertsev2bftid_va benutils.g_number_table := benutils.g_number_table();

Line 8: g_alertsev1prevbftid_va benutils.g_number_table := benutils.g_number_table();

4: g_package varchar2(50) := 'ben_test_harness.';
5: --
6: g_alertsev1reas_va benutils.g_v2_150_table := benutils.g_v2_150_table();
7: g_alertsev1bftid_va benutils.g_number_table := benutils.g_number_table();
8: g_alertsev1prevbftid_va benutils.g_number_table := benutils.g_number_table();
9: --
10: g_alertsev2reas_va benutils.g_v2_150_table := benutils.g_v2_150_table();
11: g_alertsev2bftid_va benutils.g_number_table := benutils.g_number_table();
12: --

Line 10: g_alertsev2reas_va benutils.g_v2_150_table := benutils.g_v2_150_table();

6: g_alertsev1reas_va benutils.g_v2_150_table := benutils.g_v2_150_table();
7: g_alertsev1bftid_va benutils.g_number_table := benutils.g_number_table();
8: g_alertsev1prevbftid_va benutils.g_number_table := benutils.g_number_table();
9: --
10: g_alertsev2reas_va benutils.g_v2_150_table := benutils.g_v2_150_table();
11: g_alertsev2bftid_va benutils.g_number_table := benutils.g_number_table();
12: --
13: g_alertsev1_en pls_integer := 1;
14: g_alertsev2_en pls_integer := 1;

Line 11: g_alertsev2bftid_va benutils.g_number_table := benutils.g_number_table();

7: g_alertsev1bftid_va benutils.g_number_table := benutils.g_number_table();
8: g_alertsev1prevbftid_va benutils.g_number_table := benutils.g_number_table();
9: --
10: g_alertsev2reas_va benutils.g_v2_150_table := benutils.g_v2_150_table();
11: g_alertsev2bftid_va benutils.g_number_table := benutils.g_number_table();
12: --
13: g_alertsev1_en pls_integer := 1;
14: g_alertsev2_en pls_integer := 1;
15: --

Line 17: (p_clcode_va in out nocopy benutils.g_v2_150_table

13: g_alertsev1_en pls_integer := 1;
14: g_alertsev2_en pls_integer := 1;
15: --
16: PROCEDURE filter_clcode_nondiscreps
17: (p_clcode_va in out nocopy benutils.g_v2_150_table
18: ,p_clcodecnt_va in out nocopy benutils.g_number_table
19: ,p_clsumovn_va in out nocopy benutils.g_number_table
20: ,p_clminesd_va in out nocopy benutils.g_date_table
21: ,p_clmineed_va in out nocopy benutils.g_date_table

Line 18: ,p_clcodecnt_va in out nocopy benutils.g_number_table

14: g_alertsev2_en pls_integer := 1;
15: --
16: PROCEDURE filter_clcode_nondiscreps
17: (p_clcode_va in out nocopy benutils.g_v2_150_table
18: ,p_clcodecnt_va in out nocopy benutils.g_number_table
19: ,p_clsumovn_va in out nocopy benutils.g_number_table
20: ,p_clminesd_va in out nocopy benutils.g_date_table
21: ,p_clmineed_va in out nocopy benutils.g_date_table
22: )

Line 19: ,p_clsumovn_va in out nocopy benutils.g_number_table

15: --
16: PROCEDURE filter_clcode_nondiscreps
17: (p_clcode_va in out nocopy benutils.g_v2_150_table
18: ,p_clcodecnt_va in out nocopy benutils.g_number_table
19: ,p_clsumovn_va in out nocopy benutils.g_number_table
20: ,p_clminesd_va in out nocopy benutils.g_date_table
21: ,p_clmineed_va in out nocopy benutils.g_date_table
22: )
23: IS

Line 20: ,p_clminesd_va in out nocopy benutils.g_date_table

16: PROCEDURE filter_clcode_nondiscreps
17: (p_clcode_va in out nocopy benutils.g_v2_150_table
18: ,p_clcodecnt_va in out nocopy benutils.g_number_table
19: ,p_clsumovn_va in out nocopy benutils.g_number_table
20: ,p_clminesd_va in out nocopy benutils.g_date_table
21: ,p_clmineed_va in out nocopy benutils.g_date_table
22: )
23: IS
24: --

Line 21: ,p_clmineed_va in out nocopy benutils.g_date_table

17: (p_clcode_va in out nocopy benutils.g_v2_150_table
18: ,p_clcodecnt_va in out nocopy benutils.g_number_table
19: ,p_clsumovn_va in out nocopy benutils.g_number_table
20: ,p_clminesd_va in out nocopy benutils.g_date_table
21: ,p_clmineed_va in out nocopy benutils.g_date_table
22: )
23: IS
24: --
25: l_tmpclcode_va benutils.g_v2_150_table := benutils.g_v2_150_table();

Line 25: l_tmpclcode_va benutils.g_v2_150_table := benutils.g_v2_150_table();

21: ,p_clmineed_va in out nocopy benutils.g_date_table
22: )
23: IS
24: --
25: l_tmpclcode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
26: l_tmpclcodecnt_va benutils.g_number_table := benutils.g_number_table();
27: l_tmpclsumovn_va benutils.g_number_table := benutils.g_number_table();
28: l_tmpclminesd_va benutils.g_date_table := benutils.g_date_table();
29: l_tmpclmineed_va benutils.g_date_table := benutils.g_date_table();

Line 26: l_tmpclcodecnt_va benutils.g_number_table := benutils.g_number_table();

22: )
23: IS
24: --
25: l_tmpclcode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
26: l_tmpclcodecnt_va benutils.g_number_table := benutils.g_number_table();
27: l_tmpclsumovn_va benutils.g_number_table := benutils.g_number_table();
28: l_tmpclminesd_va benutils.g_date_table := benutils.g_date_table();
29: l_tmpclmineed_va benutils.g_date_table := benutils.g_date_table();
30: --

Line 27: l_tmpclsumovn_va benutils.g_number_table := benutils.g_number_table();

23: IS
24: --
25: l_tmpclcode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
26: l_tmpclcodecnt_va benutils.g_number_table := benutils.g_number_table();
27: l_tmpclsumovn_va benutils.g_number_table := benutils.g_number_table();
28: l_tmpclminesd_va benutils.g_date_table := benutils.g_date_table();
29: l_tmpclmineed_va benutils.g_date_table := benutils.g_date_table();
30: --
31: l_tmp_en pls_integer;

Line 28: l_tmpclminesd_va benutils.g_date_table := benutils.g_date_table();

24: --
25: l_tmpclcode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
26: l_tmpclcodecnt_va benutils.g_number_table := benutils.g_number_table();
27: l_tmpclsumovn_va benutils.g_number_table := benutils.g_number_table();
28: l_tmpclminesd_va benutils.g_date_table := benutils.g_date_table();
29: l_tmpclmineed_va benutils.g_date_table := benutils.g_date_table();
30: --
31: l_tmp_en pls_integer;
32: --

Line 29: l_tmpclmineed_va benutils.g_date_table := benutils.g_date_table();

25: l_tmpclcode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
26: l_tmpclcodecnt_va benutils.g_number_table := benutils.g_number_table();
27: l_tmpclsumovn_va benutils.g_number_table := benutils.g_number_table();
28: l_tmpclminesd_va benutils.g_date_table := benutils.g_date_table();
29: l_tmpclmineed_va benutils.g_date_table := benutils.g_date_table();
30: --
31: l_tmp_en pls_integer;
32: --
33: BEGIN

Line 84: (p_perid_va in benutils.g_number_table

80: --
81: end filter_clcode_nondiscreps;
82: --
83: PROCEDURE filter_discrepperids
84: (p_perid_va in benutils.g_number_table
85: ,p_mmperid_va in out nocopy benutils.g_number_table
86: ,p_mmperlud_va in out nocopy benutils.g_date_table
87: ,p_mmcombnm_va in out nocopy benutils.g_varchar2_table
88: ,p_mmcombnm2_va in out nocopy benutils.g_varchar2_table

Line 85: ,p_mmperid_va in out nocopy benutils.g_number_table

81: end filter_clcode_nondiscreps;
82: --
83: PROCEDURE filter_discrepperids
84: (p_perid_va in benutils.g_number_table
85: ,p_mmperid_va in out nocopy benutils.g_number_table
86: ,p_mmperlud_va in out nocopy benutils.g_date_table
87: ,p_mmcombnm_va in out nocopy benutils.g_varchar2_table
88: ,p_mmcombnm2_va in out nocopy benutils.g_varchar2_table
89: ,p_mmcombid_va in out nocopy benutils.g_number_table

Line 86: ,p_mmperlud_va in out nocopy benutils.g_date_table

82: --
83: PROCEDURE filter_discrepperids
84: (p_perid_va in benutils.g_number_table
85: ,p_mmperid_va in out nocopy benutils.g_number_table
86: ,p_mmperlud_va in out nocopy benutils.g_date_table
87: ,p_mmcombnm_va in out nocopy benutils.g_varchar2_table
88: ,p_mmcombnm2_va in out nocopy benutils.g_varchar2_table
89: ,p_mmcombid_va in out nocopy benutils.g_number_table
90: ,p_mmcombid2_va in out nocopy benutils.g_number_table

Line 87: ,p_mmcombnm_va in out nocopy benutils.g_varchar2_table

83: PROCEDURE filter_discrepperids
84: (p_perid_va in benutils.g_number_table
85: ,p_mmperid_va in out nocopy benutils.g_number_table
86: ,p_mmperlud_va in out nocopy benutils.g_date_table
87: ,p_mmcombnm_va in out nocopy benutils.g_varchar2_table
88: ,p_mmcombnm2_va in out nocopy benutils.g_varchar2_table
89: ,p_mmcombid_va in out nocopy benutils.g_number_table
90: ,p_mmcombid2_va in out nocopy benutils.g_number_table
91: ,p_mmcnt_va in out nocopy benutils.g_number_table

Line 88: ,p_mmcombnm2_va in out nocopy benutils.g_varchar2_table

84: (p_perid_va in benutils.g_number_table
85: ,p_mmperid_va in out nocopy benutils.g_number_table
86: ,p_mmperlud_va in out nocopy benutils.g_date_table
87: ,p_mmcombnm_va in out nocopy benutils.g_varchar2_table
88: ,p_mmcombnm2_va in out nocopy benutils.g_varchar2_table
89: ,p_mmcombid_va in out nocopy benutils.g_number_table
90: ,p_mmcombid2_va in out nocopy benutils.g_number_table
91: ,p_mmcnt_va in out nocopy benutils.g_number_table
92: ,p_exclperid_va in out nocopy benutils.g_number_table

Line 89: ,p_mmcombid_va in out nocopy benutils.g_number_table

85: ,p_mmperid_va in out nocopy benutils.g_number_table
86: ,p_mmperlud_va in out nocopy benutils.g_date_table
87: ,p_mmcombnm_va in out nocopy benutils.g_varchar2_table
88: ,p_mmcombnm2_va in out nocopy benutils.g_varchar2_table
89: ,p_mmcombid_va in out nocopy benutils.g_number_table
90: ,p_mmcombid2_va in out nocopy benutils.g_number_table
91: ,p_mmcnt_va in out nocopy benutils.g_number_table
92: ,p_exclperid_va in out nocopy benutils.g_number_table
93: )

Line 90: ,p_mmcombid2_va in out nocopy benutils.g_number_table

86: ,p_mmperlud_va in out nocopy benutils.g_date_table
87: ,p_mmcombnm_va in out nocopy benutils.g_varchar2_table
88: ,p_mmcombnm2_va in out nocopy benutils.g_varchar2_table
89: ,p_mmcombid_va in out nocopy benutils.g_number_table
90: ,p_mmcombid2_va in out nocopy benutils.g_number_table
91: ,p_mmcnt_va in out nocopy benutils.g_number_table
92: ,p_exclperid_va in out nocopy benutils.g_number_table
93: )
94: IS

Line 91: ,p_mmcnt_va in out nocopy benutils.g_number_table

87: ,p_mmcombnm_va in out nocopy benutils.g_varchar2_table
88: ,p_mmcombnm2_va in out nocopy benutils.g_varchar2_table
89: ,p_mmcombid_va in out nocopy benutils.g_number_table
90: ,p_mmcombid2_va in out nocopy benutils.g_number_table
91: ,p_mmcnt_va in out nocopy benutils.g_number_table
92: ,p_exclperid_va in out nocopy benutils.g_number_table
93: )
94: IS
95: --

Line 92: ,p_exclperid_va in out nocopy benutils.g_number_table

88: ,p_mmcombnm2_va in out nocopy benutils.g_varchar2_table
89: ,p_mmcombid_va in out nocopy benutils.g_number_table
90: ,p_mmcombid2_va in out nocopy benutils.g_number_table
91: ,p_mmcnt_va in out nocopy benutils.g_number_table
92: ,p_exclperid_va in out nocopy benutils.g_number_table
93: )
94: IS
95: --
96: l_newmmperid_va benutils.g_number_table := benutils.g_number_table();

Line 96: l_newmmperid_va benutils.g_number_table := benutils.g_number_table();

92: ,p_exclperid_va in out nocopy benutils.g_number_table
93: )
94: IS
95: --
96: l_newmmperid_va benutils.g_number_table := benutils.g_number_table();
97: l_newmmperlud_va benutils.g_date_table := benutils.g_date_table();
98: l_newmmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
99: l_newmmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
100: l_newmmcombid_va benutils.g_number_table := benutils.g_number_table();

Line 97: l_newmmperlud_va benutils.g_date_table := benutils.g_date_table();

93: )
94: IS
95: --
96: l_newmmperid_va benutils.g_number_table := benutils.g_number_table();
97: l_newmmperlud_va benutils.g_date_table := benutils.g_date_table();
98: l_newmmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
99: l_newmmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
100: l_newmmcombid_va benutils.g_number_table := benutils.g_number_table();
101: l_newmmcombid2_va benutils.g_number_table := benutils.g_number_table();

Line 98: l_newmmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();

94: IS
95: --
96: l_newmmperid_va benutils.g_number_table := benutils.g_number_table();
97: l_newmmperlud_va benutils.g_date_table := benutils.g_date_table();
98: l_newmmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
99: l_newmmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
100: l_newmmcombid_va benutils.g_number_table := benutils.g_number_table();
101: l_newmmcombid2_va benutils.g_number_table := benutils.g_number_table();
102: l_newmmcnt_va benutils.g_number_table := benutils.g_number_table();

Line 99: l_newmmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();

95: --
96: l_newmmperid_va benutils.g_number_table := benutils.g_number_table();
97: l_newmmperlud_va benutils.g_date_table := benutils.g_date_table();
98: l_newmmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
99: l_newmmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
100: l_newmmcombid_va benutils.g_number_table := benutils.g_number_table();
101: l_newmmcombid2_va benutils.g_number_table := benutils.g_number_table();
102: l_newmmcnt_va benutils.g_number_table := benutils.g_number_table();
103: --

Line 100: l_newmmcombid_va benutils.g_number_table := benutils.g_number_table();

96: l_newmmperid_va benutils.g_number_table := benutils.g_number_table();
97: l_newmmperlud_va benutils.g_date_table := benutils.g_date_table();
98: l_newmmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
99: l_newmmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
100: l_newmmcombid_va benutils.g_number_table := benutils.g_number_table();
101: l_newmmcombid2_va benutils.g_number_table := benutils.g_number_table();
102: l_newmmcnt_va benutils.g_number_table := benutils.g_number_table();
103: --
104: l_exclperid_va benutils.g_number_table := benutils.g_number_table();

Line 101: l_newmmcombid2_va benutils.g_number_table := benutils.g_number_table();

97: l_newmmperlud_va benutils.g_date_table := benutils.g_date_table();
98: l_newmmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
99: l_newmmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
100: l_newmmcombid_va benutils.g_number_table := benutils.g_number_table();
101: l_newmmcombid2_va benutils.g_number_table := benutils.g_number_table();
102: l_newmmcnt_va benutils.g_number_table := benutils.g_number_table();
103: --
104: l_exclperid_va benutils.g_number_table := benutils.g_number_table();
105: --

Line 102: l_newmmcnt_va benutils.g_number_table := benutils.g_number_table();

98: l_newmmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
99: l_newmmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
100: l_newmmcombid_va benutils.g_number_table := benutils.g_number_table();
101: l_newmmcombid2_va benutils.g_number_table := benutils.g_number_table();
102: l_newmmcnt_va benutils.g_number_table := benutils.g_number_table();
103: --
104: l_exclperid_va benutils.g_number_table := benutils.g_number_table();
105: --
106: l_exclvaen pls_integer;

Line 104: l_exclperid_va benutils.g_number_table := benutils.g_number_table();

100: l_newmmcombid_va benutils.g_number_table := benutils.g_number_table();
101: l_newmmcombid2_va benutils.g_number_table := benutils.g_number_table();
102: l_newmmcnt_va benutils.g_number_table := benutils.g_number_table();
103: --
104: l_exclperid_va benutils.g_number_table := benutils.g_number_table();
105: --
106: l_exclvaen pls_integer;
107: l_mmvaen pls_integer;
108: l_perid_match boolean;

Line 216: ,p_mmperid_va in out nocopy benutils.g_number_table

212: --
213: PROCEDURE filter_ledatachgperids
214: (p_lud in date
215: --
216: ,p_mmperid_va in out nocopy benutils.g_number_table
217: ,p_mmperlud_va in out nocopy benutils.g_date_table
218: ,p_mmcombnm_va in out nocopy benutils.g_varchar2_table
219: ,p_mmcombnm2_va in out nocopy benutils.g_varchar2_table
220: ,p_mmcombid_va in out nocopy benutils.g_number_table

Line 217: ,p_mmperlud_va in out nocopy benutils.g_date_table

213: PROCEDURE filter_ledatachgperids
214: (p_lud in date
215: --
216: ,p_mmperid_va in out nocopy benutils.g_number_table
217: ,p_mmperlud_va in out nocopy benutils.g_date_table
218: ,p_mmcombnm_va in out nocopy benutils.g_varchar2_table
219: ,p_mmcombnm2_va in out nocopy benutils.g_varchar2_table
220: ,p_mmcombid_va in out nocopy benutils.g_number_table
221: ,p_mmcombid2_va in out nocopy benutils.g_number_table

Line 218: ,p_mmcombnm_va in out nocopy benutils.g_varchar2_table

214: (p_lud in date
215: --
216: ,p_mmperid_va in out nocopy benutils.g_number_table
217: ,p_mmperlud_va in out nocopy benutils.g_date_table
218: ,p_mmcombnm_va in out nocopy benutils.g_varchar2_table
219: ,p_mmcombnm2_va in out nocopy benutils.g_varchar2_table
220: ,p_mmcombid_va in out nocopy benutils.g_number_table
221: ,p_mmcombid2_va in out nocopy benutils.g_number_table
222: ,p_mmcnt_va in out nocopy benutils.g_number_table

Line 219: ,p_mmcombnm2_va in out nocopy benutils.g_varchar2_table

215: --
216: ,p_mmperid_va in out nocopy benutils.g_number_table
217: ,p_mmperlud_va in out nocopy benutils.g_date_table
218: ,p_mmcombnm_va in out nocopy benutils.g_varchar2_table
219: ,p_mmcombnm2_va in out nocopy benutils.g_varchar2_table
220: ,p_mmcombid_va in out nocopy benutils.g_number_table
221: ,p_mmcombid2_va in out nocopy benutils.g_number_table
222: ,p_mmcnt_va in out nocopy benutils.g_number_table
223: ,p_exclperid_va in out nocopy benutils.g_number_table

Line 220: ,p_mmcombid_va in out nocopy benutils.g_number_table

216: ,p_mmperid_va in out nocopy benutils.g_number_table
217: ,p_mmperlud_va in out nocopy benutils.g_date_table
218: ,p_mmcombnm_va in out nocopy benutils.g_varchar2_table
219: ,p_mmcombnm2_va in out nocopy benutils.g_varchar2_table
220: ,p_mmcombid_va in out nocopy benutils.g_number_table
221: ,p_mmcombid2_va in out nocopy benutils.g_number_table
222: ,p_mmcnt_va in out nocopy benutils.g_number_table
223: ,p_exclperid_va in out nocopy benutils.g_number_table
224: )

Line 221: ,p_mmcombid2_va in out nocopy benutils.g_number_table

217: ,p_mmperlud_va in out nocopy benutils.g_date_table
218: ,p_mmcombnm_va in out nocopy benutils.g_varchar2_table
219: ,p_mmcombnm2_va in out nocopy benutils.g_varchar2_table
220: ,p_mmcombid_va in out nocopy benutils.g_number_table
221: ,p_mmcombid2_va in out nocopy benutils.g_number_table
222: ,p_mmcnt_va in out nocopy benutils.g_number_table
223: ,p_exclperid_va in out nocopy benutils.g_number_table
224: )
225: IS

Line 222: ,p_mmcnt_va in out nocopy benutils.g_number_table

218: ,p_mmcombnm_va in out nocopy benutils.g_varchar2_table
219: ,p_mmcombnm2_va in out nocopy benutils.g_varchar2_table
220: ,p_mmcombid_va in out nocopy benutils.g_number_table
221: ,p_mmcombid2_va in out nocopy benutils.g_number_table
222: ,p_mmcnt_va in out nocopy benutils.g_number_table
223: ,p_exclperid_va in out nocopy benutils.g_number_table
224: )
225: IS
226: --

Line 223: ,p_exclperid_va in out nocopy benutils.g_number_table

219: ,p_mmcombnm2_va in out nocopy benutils.g_varchar2_table
220: ,p_mmcombid_va in out nocopy benutils.g_number_table
221: ,p_mmcombid2_va in out nocopy benutils.g_number_table
222: ,p_mmcnt_va in out nocopy benutils.g_number_table
223: ,p_exclperid_va in out nocopy benutils.g_number_table
224: )
225: IS
226: --
227: l_newmmperid_va benutils.g_number_table := benutils.g_number_table();

Line 227: l_newmmperid_va benutils.g_number_table := benutils.g_number_table();

223: ,p_exclperid_va in out nocopy benutils.g_number_table
224: )
225: IS
226: --
227: l_newmmperid_va benutils.g_number_table := benutils.g_number_table();
228: l_newmmperlud_va benutils.g_date_table := benutils.g_date_table();
229: l_newmmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
230: l_newmmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
231: l_newmmcombid_va benutils.g_number_table := benutils.g_number_table();

Line 228: l_newmmperlud_va benutils.g_date_table := benutils.g_date_table();

224: )
225: IS
226: --
227: l_newmmperid_va benutils.g_number_table := benutils.g_number_table();
228: l_newmmperlud_va benutils.g_date_table := benutils.g_date_table();
229: l_newmmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
230: l_newmmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
231: l_newmmcombid_va benutils.g_number_table := benutils.g_number_table();
232: l_newmmcombid2_va benutils.g_number_table := benutils.g_number_table();

Line 229: l_newmmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();

225: IS
226: --
227: l_newmmperid_va benutils.g_number_table := benutils.g_number_table();
228: l_newmmperlud_va benutils.g_date_table := benutils.g_date_table();
229: l_newmmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
230: l_newmmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
231: l_newmmcombid_va benutils.g_number_table := benutils.g_number_table();
232: l_newmmcombid2_va benutils.g_number_table := benutils.g_number_table();
233: l_newmmcnt_va benutils.g_number_table := benutils.g_number_table();

Line 230: l_newmmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();

226: --
227: l_newmmperid_va benutils.g_number_table := benutils.g_number_table();
228: l_newmmperlud_va benutils.g_date_table := benutils.g_date_table();
229: l_newmmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
230: l_newmmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
231: l_newmmcombid_va benutils.g_number_table := benutils.g_number_table();
232: l_newmmcombid2_va benutils.g_number_table := benutils.g_number_table();
233: l_newmmcnt_va benutils.g_number_table := benutils.g_number_table();
234: --

Line 231: l_newmmcombid_va benutils.g_number_table := benutils.g_number_table();

227: l_newmmperid_va benutils.g_number_table := benutils.g_number_table();
228: l_newmmperlud_va benutils.g_date_table := benutils.g_date_table();
229: l_newmmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
230: l_newmmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
231: l_newmmcombid_va benutils.g_number_table := benutils.g_number_table();
232: l_newmmcombid2_va benutils.g_number_table := benutils.g_number_table();
233: l_newmmcnt_va benutils.g_number_table := benutils.g_number_table();
234: --
235: l_exclperid_va benutils.g_number_table := benutils.g_number_table();

Line 232: l_newmmcombid2_va benutils.g_number_table := benutils.g_number_table();

228: l_newmmperlud_va benutils.g_date_table := benutils.g_date_table();
229: l_newmmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
230: l_newmmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
231: l_newmmcombid_va benutils.g_number_table := benutils.g_number_table();
232: l_newmmcombid2_va benutils.g_number_table := benutils.g_number_table();
233: l_newmmcnt_va benutils.g_number_table := benutils.g_number_table();
234: --
235: l_exclperid_va benutils.g_number_table := benutils.g_number_table();
236: --

Line 233: l_newmmcnt_va benutils.g_number_table := benutils.g_number_table();

229: l_newmmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
230: l_newmmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
231: l_newmmcombid_va benutils.g_number_table := benutils.g_number_table();
232: l_newmmcombid2_va benutils.g_number_table := benutils.g_number_table();
233: l_newmmcnt_va benutils.g_number_table := benutils.g_number_table();
234: --
235: l_exclperid_va benutils.g_number_table := benutils.g_number_table();
236: --
237: l_exclvaen pls_integer;

Line 235: l_exclperid_va benutils.g_number_table := benutils.g_number_table();

231: l_newmmcombid_va benutils.g_number_table := benutils.g_number_table();
232: l_newmmcombid2_va benutils.g_number_table := benutils.g_number_table();
233: l_newmmcnt_va benutils.g_number_table := benutils.g_number_table();
234: --
235: l_exclperid_va benutils.g_number_table := benutils.g_number_table();
236: --
237: l_exclvaen pls_integer;
238: l_mmvaen pls_integer;
239: --

Line 329: ,p_errmesscd_va in out nocopy benutils.g_v2_150_table

325: --
326: PROCEDURE get_appl_error_dets
327: (p_bft_id in number
328: --
329: ,p_errmesscd_va in out nocopy benutils.g_v2_150_table
330: ,p_mxperid_va in out nocopy benutils.g_number_table
331: ,p_errcnt_va in out nocopy benutils.g_number_table
332: ,p_errtot in out nocopy number
333: )

Line 330: ,p_mxperid_va in out nocopy benutils.g_number_table

326: PROCEDURE get_appl_error_dets
327: (p_bft_id in number
328: --
329: ,p_errmesscd_va in out nocopy benutils.g_v2_150_table
330: ,p_mxperid_va in out nocopy benutils.g_number_table
331: ,p_errcnt_va in out nocopy benutils.g_number_table
332: ,p_errtot in out nocopy number
333: )
334: IS

Line 331: ,p_errcnt_va in out nocopy benutils.g_number_table

327: (p_bft_id in number
328: --
329: ,p_errmesscd_va in out nocopy benutils.g_v2_150_table
330: ,p_mxperid_va in out nocopy benutils.g_number_table
331: ,p_errcnt_va in out nocopy benutils.g_number_table
332: ,p_errtot in out nocopy number
333: )
334: IS
335: --

Line 336: l_errmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

332: ,p_errtot in out nocopy number
333: )
334: IS
335: --
336: l_errmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
337: l_mxperid_va benutils.g_number_table := benutils.g_number_table();
338: l_errcnt_va benutils.g_number_table := benutils.g_number_table();
339: --
340: l_errtot pls_integer;

Line 337: l_mxperid_va benutils.g_number_table := benutils.g_number_table();

333: )
334: IS
335: --
336: l_errmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
337: l_mxperid_va benutils.g_number_table := benutils.g_number_table();
338: l_errcnt_va benutils.g_number_table := benutils.g_number_table();
339: --
340: l_errtot pls_integer;
341: --

Line 338: l_errcnt_va benutils.g_number_table := benutils.g_number_table();

334: IS
335: --
336: l_errmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
337: l_mxperid_va benutils.g_number_table := benutils.g_number_table();
338: l_errcnt_va benutils.g_number_table := benutils.g_number_table();
339: --
340: l_errtot pls_integer;
341: --
342: cursor c_gbenrepercdsum

Line 753: ,p_v2_val_portions in out nocopy benutils.g_varchar2_table

749: procedure Var2Value_Portion
750: (p_var2_value in varchar2
751: ,p_portion_length in number
752: --
753: ,p_v2_val_portions in out nocopy benutils.g_varchar2_table
754: )
755: is
756: --
757: l_v2_val_portions benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 757: l_v2_val_portions benutils.g_varchar2_table := benutils.g_varchar2_table();

753: ,p_v2_val_portions in out nocopy benutils.g_varchar2_table
754: )
755: is
756: --
757: l_v2_val_portions benutils.g_varchar2_table := benutils.g_varchar2_table();
758: --
759: l_v2_value_length pls_integer;
760: l_v2_value_char_count pls_integer;
761: l_string_portion_count pls_integer;

Line 1015: (p_alertstr_va in out nocopy benutils.g_v2_150_table

1011: --
1012: end PerActCompAlertCheck;
1013: --
1014: procedure BuildAlertStrVa
1015: (p_alertstr_va in out nocopy benutils.g_v2_150_table
1016: )
1017: is
1018: --
1019: l_alertstr_va benutils.g_v2_150_table := benutils.g_v2_150_table();

Line 1019: l_alertstr_va benutils.g_v2_150_table := benutils.g_v2_150_table();

1015: (p_alertstr_va in out nocopy benutils.g_v2_150_table
1016: )
1017: is
1018: --
1019: l_alertstr_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1020: --
1021: l_alert_reas varchar2(1000);
1022: --
1023: begin

Line 1155: l_newbft_id_va benutils.g_number_table := benutils.g_number_table();

1151: l_mxpilper_inst MxPILPERInstType;
1152: l_bft_inst BFTInstType;
1153: l_bft_dets BFTDetType;
1154: --
1155: l_newbft_id_va benutils.g_number_table := benutils.g_number_table();
1156: l_newbftmode_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1157: l_newbftbgp_id_va benutils.g_number_table := benutils.g_number_table();
1158: l_newbftler_id_va benutils.g_number_table := benutils.g_number_table();
1159: l_newbftopt_id_va benutils.g_number_table := benutils.g_number_table();

Line 1156: l_newbftmode_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

1152: l_bft_inst BFTInstType;
1153: l_bft_dets BFTDetType;
1154: --
1155: l_newbft_id_va benutils.g_number_table := benutils.g_number_table();
1156: l_newbftmode_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1157: l_newbftbgp_id_va benutils.g_number_table := benutils.g_number_table();
1158: l_newbftler_id_va benutils.g_number_table := benutils.g_number_table();
1159: l_newbftopt_id_va benutils.g_number_table := benutils.g_number_table();
1160: l_newbftper_id_va benutils.g_number_table := benutils.g_number_table();

Line 1157: l_newbftbgp_id_va benutils.g_number_table := benutils.g_number_table();

1153: l_bft_dets BFTDetType;
1154: --
1155: l_newbft_id_va benutils.g_number_table := benutils.g_number_table();
1156: l_newbftmode_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1157: l_newbftbgp_id_va benutils.g_number_table := benutils.g_number_table();
1158: l_newbftler_id_va benutils.g_number_table := benutils.g_number_table();
1159: l_newbftopt_id_va benutils.g_number_table := benutils.g_number_table();
1160: l_newbftper_id_va benutils.g_number_table := benutils.g_number_table();
1161: l_newbftpl_id_va benutils.g_number_table := benutils.g_number_table();

Line 1158: l_newbftler_id_va benutils.g_number_table := benutils.g_number_table();

1154: --
1155: l_newbft_id_va benutils.g_number_table := benutils.g_number_table();
1156: l_newbftmode_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1157: l_newbftbgp_id_va benutils.g_number_table := benutils.g_number_table();
1158: l_newbftler_id_va benutils.g_number_table := benutils.g_number_table();
1159: l_newbftopt_id_va benutils.g_number_table := benutils.g_number_table();
1160: l_newbftper_id_va benutils.g_number_table := benutils.g_number_table();
1161: l_newbftpl_id_va benutils.g_number_table := benutils.g_number_table();
1162: l_newbftbfg_id_va benutils.g_number_table := benutils.g_number_table();

Line 1159: l_newbftopt_id_va benutils.g_number_table := benutils.g_number_table();

1155: l_newbft_id_va benutils.g_number_table := benutils.g_number_table();
1156: l_newbftmode_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1157: l_newbftbgp_id_va benutils.g_number_table := benutils.g_number_table();
1158: l_newbftler_id_va benutils.g_number_table := benutils.g_number_table();
1159: l_newbftopt_id_va benutils.g_number_table := benutils.g_number_table();
1160: l_newbftper_id_va benutils.g_number_table := benutils.g_number_table();
1161: l_newbftpl_id_va benutils.g_number_table := benutils.g_number_table();
1162: l_newbftbfg_id_va benutils.g_number_table := benutils.g_number_table();
1163: l_newbftpgm_id_va benutils.g_number_table := benutils.g_number_table();

Line 1160: l_newbftper_id_va benutils.g_number_table := benutils.g_number_table();

1156: l_newbftmode_cd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1157: l_newbftbgp_id_va benutils.g_number_table := benutils.g_number_table();
1158: l_newbftler_id_va benutils.g_number_table := benutils.g_number_table();
1159: l_newbftopt_id_va benutils.g_number_table := benutils.g_number_table();
1160: l_newbftper_id_va benutils.g_number_table := benutils.g_number_table();
1161: l_newbftpl_id_va benutils.g_number_table := benutils.g_number_table();
1162: l_newbftbfg_id_va benutils.g_number_table := benutils.g_number_table();
1163: l_newbftpgm_id_va benutils.g_number_table := benutils.g_number_table();
1164: l_newbftproc_dt_va benutils.g_date_table := benutils.g_date_table();

Line 1161: l_newbftpl_id_va benutils.g_number_table := benutils.g_number_table();

1157: l_newbftbgp_id_va benutils.g_number_table := benutils.g_number_table();
1158: l_newbftler_id_va benutils.g_number_table := benutils.g_number_table();
1159: l_newbftopt_id_va benutils.g_number_table := benutils.g_number_table();
1160: l_newbftper_id_va benutils.g_number_table := benutils.g_number_table();
1161: l_newbftpl_id_va benutils.g_number_table := benutils.g_number_table();
1162: l_newbftbfg_id_va benutils.g_number_table := benutils.g_number_table();
1163: l_newbftpgm_id_va benutils.g_number_table := benutils.g_number_table();
1164: l_newbftproc_dt_va benutils.g_date_table := benutils.g_date_table();
1165: l_newbftleodt_dt_va benutils.g_date_table := benutils.g_date_table();

Line 1162: l_newbftbfg_id_va benutils.g_number_table := benutils.g_number_table();

1158: l_newbftler_id_va benutils.g_number_table := benutils.g_number_table();
1159: l_newbftopt_id_va benutils.g_number_table := benutils.g_number_table();
1160: l_newbftper_id_va benutils.g_number_table := benutils.g_number_table();
1161: l_newbftpl_id_va benutils.g_number_table := benutils.g_number_table();
1162: l_newbftbfg_id_va benutils.g_number_table := benutils.g_number_table();
1163: l_newbftpgm_id_va benutils.g_number_table := benutils.g_number_table();
1164: l_newbftproc_dt_va benutils.g_date_table := benutils.g_date_table();
1165: l_newbftleodt_dt_va benutils.g_date_table := benutils.g_date_table();
1166: l_newbftmax_credt_va benutils.g_date_table := benutils.g_date_table();

Line 1163: l_newbftpgm_id_va benutils.g_number_table := benutils.g_number_table();

1159: l_newbftopt_id_va benutils.g_number_table := benutils.g_number_table();
1160: l_newbftper_id_va benutils.g_number_table := benutils.g_number_table();
1161: l_newbftpl_id_va benutils.g_number_table := benutils.g_number_table();
1162: l_newbftbfg_id_va benutils.g_number_table := benutils.g_number_table();
1163: l_newbftpgm_id_va benutils.g_number_table := benutils.g_number_table();
1164: l_newbftproc_dt_va benutils.g_date_table := benutils.g_date_table();
1165: l_newbftleodt_dt_va benutils.g_date_table := benutils.g_date_table();
1166: l_newbftmax_credt_va benutils.g_date_table := benutils.g_date_table();
1167: l_newbftreqid_va benutils.g_number_table := benutils.g_number_table();

Line 1164: l_newbftproc_dt_va benutils.g_date_table := benutils.g_date_table();

1160: l_newbftper_id_va benutils.g_number_table := benutils.g_number_table();
1161: l_newbftpl_id_va benutils.g_number_table := benutils.g_number_table();
1162: l_newbftbfg_id_va benutils.g_number_table := benutils.g_number_table();
1163: l_newbftpgm_id_va benutils.g_number_table := benutils.g_number_table();
1164: l_newbftproc_dt_va benutils.g_date_table := benutils.g_date_table();
1165: l_newbftleodt_dt_va benutils.g_date_table := benutils.g_date_table();
1166: l_newbftmax_credt_va benutils.g_date_table := benutils.g_date_table();
1167: l_newbftreqid_va benutils.g_number_table := benutils.g_number_table();
1168: --

Line 1165: l_newbftleodt_dt_va benutils.g_date_table := benutils.g_date_table();

1161: l_newbftpl_id_va benutils.g_number_table := benutils.g_number_table();
1162: l_newbftbfg_id_va benutils.g_number_table := benutils.g_number_table();
1163: l_newbftpgm_id_va benutils.g_number_table := benutils.g_number_table();
1164: l_newbftproc_dt_va benutils.g_date_table := benutils.g_date_table();
1165: l_newbftleodt_dt_va benutils.g_date_table := benutils.g_date_table();
1166: l_newbftmax_credt_va benutils.g_date_table := benutils.g_date_table();
1167: l_newbftreqid_va benutils.g_number_table := benutils.g_number_table();
1168: --
1169: l_clcode_va benutils.g_v2_150_table := benutils.g_v2_150_table();

Line 1166: l_newbftmax_credt_va benutils.g_date_table := benutils.g_date_table();

1162: l_newbftbfg_id_va benutils.g_number_table := benutils.g_number_table();
1163: l_newbftpgm_id_va benutils.g_number_table := benutils.g_number_table();
1164: l_newbftproc_dt_va benutils.g_date_table := benutils.g_date_table();
1165: l_newbftleodt_dt_va benutils.g_date_table := benutils.g_date_table();
1166: l_newbftmax_credt_va benutils.g_date_table := benutils.g_date_table();
1167: l_newbftreqid_va benutils.g_number_table := benutils.g_number_table();
1168: --
1169: l_clcode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1170: l_clcodecnt_va benutils.g_number_table := benutils.g_number_table();

Line 1167: l_newbftreqid_va benutils.g_number_table := benutils.g_number_table();

1163: l_newbftpgm_id_va benutils.g_number_table := benutils.g_number_table();
1164: l_newbftproc_dt_va benutils.g_date_table := benutils.g_date_table();
1165: l_newbftleodt_dt_va benutils.g_date_table := benutils.g_date_table();
1166: l_newbftmax_credt_va benutils.g_date_table := benutils.g_date_table();
1167: l_newbftreqid_va benutils.g_number_table := benutils.g_number_table();
1168: --
1169: l_clcode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1170: l_clcodecnt_va benutils.g_number_table := benutils.g_number_table();
1171: l_clsumovn_va benutils.g_number_table := benutils.g_number_table();

Line 1169: l_clcode_va benutils.g_v2_150_table := benutils.g_v2_150_table();

1165: l_newbftleodt_dt_va benutils.g_date_table := benutils.g_date_table();
1166: l_newbftmax_credt_va benutils.g_date_table := benutils.g_date_table();
1167: l_newbftreqid_va benutils.g_number_table := benutils.g_number_table();
1168: --
1169: l_clcode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1170: l_clcodecnt_va benutils.g_number_table := benutils.g_number_table();
1171: l_clsumovn_va benutils.g_number_table := benutils.g_number_table();
1172: l_clminesd_va benutils.g_date_table := benutils.g_date_table();
1173: l_clmineed_va benutils.g_date_table := benutils.g_date_table();

Line 1170: l_clcodecnt_va benutils.g_number_table := benutils.g_number_table();

1166: l_newbftmax_credt_va benutils.g_date_table := benutils.g_date_table();
1167: l_newbftreqid_va benutils.g_number_table := benutils.g_number_table();
1168: --
1169: l_clcode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1170: l_clcodecnt_va benutils.g_number_table := benutils.g_number_table();
1171: l_clsumovn_va benutils.g_number_table := benutils.g_number_table();
1172: l_clminesd_va benutils.g_date_table := benutils.g_date_table();
1173: l_clmineed_va benutils.g_date_table := benutils.g_date_table();
1174: l_clidstr_va t_v2_4000_va := t_v2_4000_va();

Line 1171: l_clsumovn_va benutils.g_number_table := benutils.g_number_table();

1167: l_newbftreqid_va benutils.g_number_table := benutils.g_number_table();
1168: --
1169: l_clcode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1170: l_clcodecnt_va benutils.g_number_table := benutils.g_number_table();
1171: l_clsumovn_va benutils.g_number_table := benutils.g_number_table();
1172: l_clminesd_va benutils.g_date_table := benutils.g_date_table();
1173: l_clmineed_va benutils.g_date_table := benutils.g_date_table();
1174: l_clidstr_va t_v2_4000_va := t_v2_4000_va();
1175: --

Line 1172: l_clminesd_va benutils.g_date_table := benutils.g_date_table();

1168: --
1169: l_clcode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1170: l_clcodecnt_va benutils.g_number_table := benutils.g_number_table();
1171: l_clsumovn_va benutils.g_number_table := benutils.g_number_table();
1172: l_clminesd_va benutils.g_date_table := benutils.g_date_table();
1173: l_clmineed_va benutils.g_date_table := benutils.g_date_table();
1174: l_clidstr_va t_v2_4000_va := t_v2_4000_va();
1175: --
1176: l_rbv_clcode_va benutils.g_v2_150_table := benutils.g_v2_150_table();

Line 1173: l_clmineed_va benutils.g_date_table := benutils.g_date_table();

1169: l_clcode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1170: l_clcodecnt_va benutils.g_number_table := benutils.g_number_table();
1171: l_clsumovn_va benutils.g_number_table := benutils.g_number_table();
1172: l_clminesd_va benutils.g_date_table := benutils.g_date_table();
1173: l_clmineed_va benutils.g_date_table := benutils.g_date_table();
1174: l_clidstr_va t_v2_4000_va := t_v2_4000_va();
1175: --
1176: l_rbv_clcode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1177: l_rbv_clcodecnt_va benutils.g_number_table := benutils.g_number_table();

Line 1176: l_rbv_clcode_va benutils.g_v2_150_table := benutils.g_v2_150_table();

1172: l_clminesd_va benutils.g_date_table := benutils.g_date_table();
1173: l_clmineed_va benutils.g_date_table := benutils.g_date_table();
1174: l_clidstr_va t_v2_4000_va := t_v2_4000_va();
1175: --
1176: l_rbv_clcode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1177: l_rbv_clcodecnt_va benutils.g_number_table := benutils.g_number_table();
1178: l_rbv_clsumovn_va benutils.g_number_table := benutils.g_number_table();
1179: l_rbv_clminesd_va benutils.g_date_table := benutils.g_date_table();
1180: l_rbv_clmineed_va benutils.g_date_table := benutils.g_date_table();

Line 1177: l_rbv_clcodecnt_va benutils.g_number_table := benutils.g_number_table();

1173: l_clmineed_va benutils.g_date_table := benutils.g_date_table();
1174: l_clidstr_va t_v2_4000_va := t_v2_4000_va();
1175: --
1176: l_rbv_clcode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1177: l_rbv_clcodecnt_va benutils.g_number_table := benutils.g_number_table();
1178: l_rbv_clsumovn_va benutils.g_number_table := benutils.g_number_table();
1179: l_rbv_clminesd_va benutils.g_date_table := benutils.g_date_table();
1180: l_rbv_clmineed_va benutils.g_date_table := benutils.g_date_table();
1181: l_rbv_clidstr_va t_v2_4000_va := t_v2_4000_va();

Line 1178: l_rbv_clsumovn_va benutils.g_number_table := benutils.g_number_table();

1174: l_clidstr_va t_v2_4000_va := t_v2_4000_va();
1175: --
1176: l_rbv_clcode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1177: l_rbv_clcodecnt_va benutils.g_number_table := benutils.g_number_table();
1178: l_rbv_clsumovn_va benutils.g_number_table := benutils.g_number_table();
1179: l_rbv_clminesd_va benutils.g_date_table := benutils.g_date_table();
1180: l_rbv_clmineed_va benutils.g_date_table := benutils.g_date_table();
1181: l_rbv_clidstr_va t_v2_4000_va := t_v2_4000_va();
1182: --

Line 1179: l_rbv_clminesd_va benutils.g_date_table := benutils.g_date_table();

1175: --
1176: l_rbv_clcode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1177: l_rbv_clcodecnt_va benutils.g_number_table := benutils.g_number_table();
1178: l_rbv_clsumovn_va benutils.g_number_table := benutils.g_number_table();
1179: l_rbv_clminesd_va benutils.g_date_table := benutils.g_date_table();
1180: l_rbv_clmineed_va benutils.g_date_table := benutils.g_date_table();
1181: l_rbv_clidstr_va t_v2_4000_va := t_v2_4000_va();
1182: --
1183: l_mmclccode_va benutils.g_v2_150_table := benutils.g_v2_150_table();

Line 1180: l_rbv_clmineed_va benutils.g_date_table := benutils.g_date_table();

1176: l_rbv_clcode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1177: l_rbv_clcodecnt_va benutils.g_number_table := benutils.g_number_table();
1178: l_rbv_clsumovn_va benutils.g_number_table := benutils.g_number_table();
1179: l_rbv_clminesd_va benutils.g_date_table := benutils.g_date_table();
1180: l_rbv_clmineed_va benutils.g_date_table := benutils.g_date_table();
1181: l_rbv_clidstr_va t_v2_4000_va := t_v2_4000_va();
1182: --
1183: l_mmclccode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1184: l_mmoclcount_va benutils.g_v2_150_table := benutils.g_v2_150_table();

Line 1183: l_mmclccode_va benutils.g_v2_150_table := benutils.g_v2_150_table();

1179: l_rbv_clminesd_va benutils.g_date_table := benutils.g_date_table();
1180: l_rbv_clmineed_va benutils.g_date_table := benutils.g_date_table();
1181: l_rbv_clidstr_va t_v2_4000_va := t_v2_4000_va();
1182: --
1183: l_mmclccode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1184: l_mmoclcount_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1185: l_mmnclcount_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1186: l_mtclccode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1187: l_mtoclcount_va benutils.g_number_table := benutils.g_number_table();

Line 1184: l_mmoclcount_va benutils.g_v2_150_table := benutils.g_v2_150_table();

1180: l_rbv_clmineed_va benutils.g_date_table := benutils.g_date_table();
1181: l_rbv_clidstr_va t_v2_4000_va := t_v2_4000_va();
1182: --
1183: l_mmclccode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1184: l_mmoclcount_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1185: l_mmnclcount_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1186: l_mtclccode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1187: l_mtoclcount_va benutils.g_number_table := benutils.g_number_table();
1188: l_mtnclcount_va benutils.g_number_table := benutils.g_number_table();

Line 1185: l_mmnclcount_va benutils.g_v2_150_table := benutils.g_v2_150_table();

1181: l_rbv_clidstr_va t_v2_4000_va := t_v2_4000_va();
1182: --
1183: l_mmclccode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1184: l_mmoclcount_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1185: l_mmnclcount_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1186: l_mtclccode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1187: l_mtoclcount_va benutils.g_number_table := benutils.g_number_table();
1188: l_mtnclcount_va benutils.g_number_table := benutils.g_number_table();
1189: --

Line 1186: l_mtclccode_va benutils.g_v2_150_table := benutils.g_v2_150_table();

1182: --
1183: l_mmclccode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1184: l_mmoclcount_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1185: l_mmnclcount_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1186: l_mtclccode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1187: l_mtoclcount_va benutils.g_number_table := benutils.g_number_table();
1188: l_mtnclcount_va benutils.g_number_table := benutils.g_number_table();
1189: --
1190: l_reptext_va benutils.g_v2_150_table := benutils.g_v2_150_table();

Line 1187: l_mtoclcount_va benutils.g_number_table := benutils.g_number_table();

1183: l_mmclccode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1184: l_mmoclcount_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1185: l_mmnclcount_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1186: l_mtclccode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1187: l_mtoclcount_va benutils.g_number_table := benutils.g_number_table();
1188: l_mtnclcount_va benutils.g_number_table := benutils.g_number_table();
1189: --
1190: l_reptext_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1191: l_num1_col benutils.g_number_table := benutils.g_number_table();

Line 1188: l_mtnclcount_va benutils.g_number_table := benutils.g_number_table();

1184: l_mmoclcount_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1185: l_mmnclcount_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1186: l_mtclccode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1187: l_mtoclcount_va benutils.g_number_table := benutils.g_number_table();
1188: l_mtnclcount_va benutils.g_number_table := benutils.g_number_table();
1189: --
1190: l_reptext_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1191: l_num1_col benutils.g_number_table := benutils.g_number_table();
1192: l_num2_col benutils.g_number_table := benutils.g_number_table();

Line 1190: l_reptext_va benutils.g_v2_150_table := benutils.g_v2_150_table();

1186: l_mtclccode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1187: l_mtoclcount_va benutils.g_number_table := benutils.g_number_table();
1188: l_mtnclcount_va benutils.g_number_table := benutils.g_number_table();
1189: --
1190: l_reptext_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1191: l_num1_col benutils.g_number_table := benutils.g_number_table();
1192: l_num2_col benutils.g_number_table := benutils.g_number_table();
1193: l_num3_col benutils.g_number_table := benutils.g_number_table();
1194: l_num4_col benutils.g_number_table := benutils.g_number_table();

Line 1191: l_num1_col benutils.g_number_table := benutils.g_number_table();

1187: l_mtoclcount_va benutils.g_number_table := benutils.g_number_table();
1188: l_mtnclcount_va benutils.g_number_table := benutils.g_number_table();
1189: --
1190: l_reptext_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1191: l_num1_col benutils.g_number_table := benutils.g_number_table();
1192: l_num2_col benutils.g_number_table := benutils.g_number_table();
1193: l_num3_col benutils.g_number_table := benutils.g_number_table();
1194: l_num4_col benutils.g_number_table := benutils.g_number_table();
1195: l_num5_col benutils.g_number_table := benutils.g_number_table();

Line 1192: l_num2_col benutils.g_number_table := benutils.g_number_table();

1188: l_mtnclcount_va benutils.g_number_table := benutils.g_number_table();
1189: --
1190: l_reptext_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1191: l_num1_col benutils.g_number_table := benutils.g_number_table();
1192: l_num2_col benutils.g_number_table := benutils.g_number_table();
1193: l_num3_col benutils.g_number_table := benutils.g_number_table();
1194: l_num4_col benutils.g_number_table := benutils.g_number_table();
1195: l_num5_col benutils.g_number_table := benutils.g_number_table();
1196: l_num6_col benutils.g_number_table := benutils.g_number_table();

Line 1193: l_num3_col benutils.g_number_table := benutils.g_number_table();

1189: --
1190: l_reptext_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1191: l_num1_col benutils.g_number_table := benutils.g_number_table();
1192: l_num2_col benutils.g_number_table := benutils.g_number_table();
1193: l_num3_col benutils.g_number_table := benutils.g_number_table();
1194: l_num4_col benutils.g_number_table := benutils.g_number_table();
1195: l_num5_col benutils.g_number_table := benutils.g_number_table();
1196: l_num6_col benutils.g_number_table := benutils.g_number_table();
1197: l_num7_col benutils.g_number_table := benutils.g_number_table();

Line 1194: l_num4_col benutils.g_number_table := benutils.g_number_table();

1190: l_reptext_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1191: l_num1_col benutils.g_number_table := benutils.g_number_table();
1192: l_num2_col benutils.g_number_table := benutils.g_number_table();
1193: l_num3_col benutils.g_number_table := benutils.g_number_table();
1194: l_num4_col benutils.g_number_table := benutils.g_number_table();
1195: l_num5_col benutils.g_number_table := benutils.g_number_table();
1196: l_num6_col benutils.g_number_table := benutils.g_number_table();
1197: l_num7_col benutils.g_number_table := benutils.g_number_table();
1198: l_num8_col benutils.g_number_table := benutils.g_number_table();

Line 1195: l_num5_col benutils.g_number_table := benutils.g_number_table();

1191: l_num1_col benutils.g_number_table := benutils.g_number_table();
1192: l_num2_col benutils.g_number_table := benutils.g_number_table();
1193: l_num3_col benutils.g_number_table := benutils.g_number_table();
1194: l_num4_col benutils.g_number_table := benutils.g_number_table();
1195: l_num5_col benutils.g_number_table := benutils.g_number_table();
1196: l_num6_col benutils.g_number_table := benutils.g_number_table();
1197: l_num7_col benutils.g_number_table := benutils.g_number_table();
1198: l_num8_col benutils.g_number_table := benutils.g_number_table();
1199: l_num9_col benutils.g_number_table := benutils.g_number_table();

Line 1196: l_num6_col benutils.g_number_table := benutils.g_number_table();

1192: l_num2_col benutils.g_number_table := benutils.g_number_table();
1193: l_num3_col benutils.g_number_table := benutils.g_number_table();
1194: l_num4_col benutils.g_number_table := benutils.g_number_table();
1195: l_num5_col benutils.g_number_table := benutils.g_number_table();
1196: l_num6_col benutils.g_number_table := benutils.g_number_table();
1197: l_num7_col benutils.g_number_table := benutils.g_number_table();
1198: l_num8_col benutils.g_number_table := benutils.g_number_table();
1199: l_num9_col benutils.g_number_table := benutils.g_number_table();
1200: l_num10_col benutils.g_number_table := benutils.g_number_table();

Line 1197: l_num7_col benutils.g_number_table := benutils.g_number_table();

1193: l_num3_col benutils.g_number_table := benutils.g_number_table();
1194: l_num4_col benutils.g_number_table := benutils.g_number_table();
1195: l_num5_col benutils.g_number_table := benutils.g_number_table();
1196: l_num6_col benutils.g_number_table := benutils.g_number_table();
1197: l_num7_col benutils.g_number_table := benutils.g_number_table();
1198: l_num8_col benutils.g_number_table := benutils.g_number_table();
1199: l_num9_col benutils.g_number_table := benutils.g_number_table();
1200: l_num10_col benutils.g_number_table := benutils.g_number_table();
1201: l_num11_col benutils.g_number_table := benutils.g_number_table();

Line 1198: l_num8_col benutils.g_number_table := benutils.g_number_table();

1194: l_num4_col benutils.g_number_table := benutils.g_number_table();
1195: l_num5_col benutils.g_number_table := benutils.g_number_table();
1196: l_num6_col benutils.g_number_table := benutils.g_number_table();
1197: l_num7_col benutils.g_number_table := benutils.g_number_table();
1198: l_num8_col benutils.g_number_table := benutils.g_number_table();
1199: l_num9_col benutils.g_number_table := benutils.g_number_table();
1200: l_num10_col benutils.g_number_table := benutils.g_number_table();
1201: l_num11_col benutils.g_number_table := benutils.g_number_table();
1202: l_num12_col benutils.g_number_table := benutils.g_number_table();

Line 1199: l_num9_col benutils.g_number_table := benutils.g_number_table();

1195: l_num5_col benutils.g_number_table := benutils.g_number_table();
1196: l_num6_col benutils.g_number_table := benutils.g_number_table();
1197: l_num7_col benutils.g_number_table := benutils.g_number_table();
1198: l_num8_col benutils.g_number_table := benutils.g_number_table();
1199: l_num9_col benutils.g_number_table := benutils.g_number_table();
1200: l_num10_col benutils.g_number_table := benutils.g_number_table();
1201: l_num11_col benutils.g_number_table := benutils.g_number_table();
1202: l_num12_col benutils.g_number_table := benutils.g_number_table();
1203: l_num13_col benutils.g_number_table := benutils.g_number_table();

Line 1200: l_num10_col benutils.g_number_table := benutils.g_number_table();

1196: l_num6_col benutils.g_number_table := benutils.g_number_table();
1197: l_num7_col benutils.g_number_table := benutils.g_number_table();
1198: l_num8_col benutils.g_number_table := benutils.g_number_table();
1199: l_num9_col benutils.g_number_table := benutils.g_number_table();
1200: l_num10_col benutils.g_number_table := benutils.g_number_table();
1201: l_num11_col benutils.g_number_table := benutils.g_number_table();
1202: l_num12_col benutils.g_number_table := benutils.g_number_table();
1203: l_num13_col benutils.g_number_table := benutils.g_number_table();
1204: l_num14_col benutils.g_number_table := benutils.g_number_table();

Line 1201: l_num11_col benutils.g_number_table := benutils.g_number_table();

1197: l_num7_col benutils.g_number_table := benutils.g_number_table();
1198: l_num8_col benutils.g_number_table := benutils.g_number_table();
1199: l_num9_col benutils.g_number_table := benutils.g_number_table();
1200: l_num10_col benutils.g_number_table := benutils.g_number_table();
1201: l_num11_col benutils.g_number_table := benutils.g_number_table();
1202: l_num12_col benutils.g_number_table := benutils.g_number_table();
1203: l_num13_col benutils.g_number_table := benutils.g_number_table();
1204: l_num14_col benutils.g_number_table := benutils.g_number_table();
1205: l_num15_col benutils.g_number_table := benutils.g_number_table();

Line 1202: l_num12_col benutils.g_number_table := benutils.g_number_table();

1198: l_num8_col benutils.g_number_table := benutils.g_number_table();
1199: l_num9_col benutils.g_number_table := benutils.g_number_table();
1200: l_num10_col benutils.g_number_table := benutils.g_number_table();
1201: l_num11_col benutils.g_number_table := benutils.g_number_table();
1202: l_num12_col benutils.g_number_table := benutils.g_number_table();
1203: l_num13_col benutils.g_number_table := benutils.g_number_table();
1204: l_num14_col benutils.g_number_table := benutils.g_number_table();
1205: l_num15_col benutils.g_number_table := benutils.g_number_table();
1206: l_num16_col benutils.g_number_table := benutils.g_number_table();

Line 1203: l_num13_col benutils.g_number_table := benutils.g_number_table();

1199: l_num9_col benutils.g_number_table := benutils.g_number_table();
1200: l_num10_col benutils.g_number_table := benutils.g_number_table();
1201: l_num11_col benutils.g_number_table := benutils.g_number_table();
1202: l_num12_col benutils.g_number_table := benutils.g_number_table();
1203: l_num13_col benutils.g_number_table := benutils.g_number_table();
1204: l_num14_col benutils.g_number_table := benutils.g_number_table();
1205: l_num15_col benutils.g_number_table := benutils.g_number_table();
1206: l_num16_col benutils.g_number_table := benutils.g_number_table();
1207: l_num17_col benutils.g_number_table := benutils.g_number_table();

Line 1204: l_num14_col benutils.g_number_table := benutils.g_number_table();

1200: l_num10_col benutils.g_number_table := benutils.g_number_table();
1201: l_num11_col benutils.g_number_table := benutils.g_number_table();
1202: l_num12_col benutils.g_number_table := benutils.g_number_table();
1203: l_num13_col benutils.g_number_table := benutils.g_number_table();
1204: l_num14_col benutils.g_number_table := benutils.g_number_table();
1205: l_num15_col benutils.g_number_table := benutils.g_number_table();
1206: l_num16_col benutils.g_number_table := benutils.g_number_table();
1207: l_num17_col benutils.g_number_table := benutils.g_number_table();
1208: l_num18_col benutils.g_number_table := benutils.g_number_table();

Line 1205: l_num15_col benutils.g_number_table := benutils.g_number_table();

1201: l_num11_col benutils.g_number_table := benutils.g_number_table();
1202: l_num12_col benutils.g_number_table := benutils.g_number_table();
1203: l_num13_col benutils.g_number_table := benutils.g_number_table();
1204: l_num14_col benutils.g_number_table := benutils.g_number_table();
1205: l_num15_col benutils.g_number_table := benutils.g_number_table();
1206: l_num16_col benutils.g_number_table := benutils.g_number_table();
1207: l_num17_col benutils.g_number_table := benutils.g_number_table();
1208: l_num18_col benutils.g_number_table := benutils.g_number_table();
1209: l_var1_col benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 1206: l_num16_col benutils.g_number_table := benutils.g_number_table();

1202: l_num12_col benutils.g_number_table := benutils.g_number_table();
1203: l_num13_col benutils.g_number_table := benutils.g_number_table();
1204: l_num14_col benutils.g_number_table := benutils.g_number_table();
1205: l_num15_col benutils.g_number_table := benutils.g_number_table();
1206: l_num16_col benutils.g_number_table := benutils.g_number_table();
1207: l_num17_col benutils.g_number_table := benutils.g_number_table();
1208: l_num18_col benutils.g_number_table := benutils.g_number_table();
1209: l_var1_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1210: l_var2_col benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 1207: l_num17_col benutils.g_number_table := benutils.g_number_table();

1203: l_num13_col benutils.g_number_table := benutils.g_number_table();
1204: l_num14_col benutils.g_number_table := benutils.g_number_table();
1205: l_num15_col benutils.g_number_table := benutils.g_number_table();
1206: l_num16_col benutils.g_number_table := benutils.g_number_table();
1207: l_num17_col benutils.g_number_table := benutils.g_number_table();
1208: l_num18_col benutils.g_number_table := benutils.g_number_table();
1209: l_var1_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1210: l_var2_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1211: l_var3_col benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 1208: l_num18_col benutils.g_number_table := benutils.g_number_table();

1204: l_num14_col benutils.g_number_table := benutils.g_number_table();
1205: l_num15_col benutils.g_number_table := benutils.g_number_table();
1206: l_num16_col benutils.g_number_table := benutils.g_number_table();
1207: l_num17_col benutils.g_number_table := benutils.g_number_table();
1208: l_num18_col benutils.g_number_table := benutils.g_number_table();
1209: l_var1_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1210: l_var2_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1211: l_var3_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1212: l_var4_col benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 1209: l_var1_col benutils.g_varchar2_table := benutils.g_varchar2_table();

1205: l_num15_col benutils.g_number_table := benutils.g_number_table();
1206: l_num16_col benutils.g_number_table := benutils.g_number_table();
1207: l_num17_col benutils.g_number_table := benutils.g_number_table();
1208: l_num18_col benutils.g_number_table := benutils.g_number_table();
1209: l_var1_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1210: l_var2_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1211: l_var3_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1212: l_var4_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1213: l_var5_col benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 1210: l_var2_col benutils.g_varchar2_table := benutils.g_varchar2_table();

1206: l_num16_col benutils.g_number_table := benutils.g_number_table();
1207: l_num17_col benutils.g_number_table := benutils.g_number_table();
1208: l_num18_col benutils.g_number_table := benutils.g_number_table();
1209: l_var1_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1210: l_var2_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1211: l_var3_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1212: l_var4_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1213: l_var5_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1214: l_var6_col benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 1211: l_var3_col benutils.g_varchar2_table := benutils.g_varchar2_table();

1207: l_num17_col benutils.g_number_table := benutils.g_number_table();
1208: l_num18_col benutils.g_number_table := benutils.g_number_table();
1209: l_var1_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1210: l_var2_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1211: l_var3_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1212: l_var4_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1213: l_var5_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1214: l_var6_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1215: l_var7_col benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 1212: l_var4_col benutils.g_varchar2_table := benutils.g_varchar2_table();

1208: l_num18_col benutils.g_number_table := benutils.g_number_table();
1209: l_var1_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1210: l_var2_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1211: l_var3_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1212: l_var4_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1213: l_var5_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1214: l_var6_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1215: l_var7_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1216: l_var8_col benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 1213: l_var5_col benutils.g_varchar2_table := benutils.g_varchar2_table();

1209: l_var1_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1210: l_var2_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1211: l_var3_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1212: l_var4_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1213: l_var5_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1214: l_var6_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1215: l_var7_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1216: l_var8_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1217: l_var9_col benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 1214: l_var6_col benutils.g_varchar2_table := benutils.g_varchar2_table();

1210: l_var2_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1211: l_var3_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1212: l_var4_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1213: l_var5_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1214: l_var6_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1215: l_var7_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1216: l_var8_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1217: l_var9_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1218: l_var10_col benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 1215: l_var7_col benutils.g_varchar2_table := benutils.g_varchar2_table();

1211: l_var3_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1212: l_var4_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1213: l_var5_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1214: l_var6_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1215: l_var7_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1216: l_var8_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1217: l_var9_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1218: l_var10_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1219: l_var11_col benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 1216: l_var8_col benutils.g_varchar2_table := benutils.g_varchar2_table();

1212: l_var4_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1213: l_var5_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1214: l_var6_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1215: l_var7_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1216: l_var8_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1217: l_var9_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1218: l_var10_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1219: l_var11_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1220: l_var12_col benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 1217: l_var9_col benutils.g_varchar2_table := benutils.g_varchar2_table();

1213: l_var5_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1214: l_var6_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1215: l_var7_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1216: l_var8_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1217: l_var9_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1218: l_var10_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1219: l_var11_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1220: l_var12_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1221: --

Line 1218: l_var10_col benutils.g_varchar2_table := benutils.g_varchar2_table();

1214: l_var6_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1215: l_var7_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1216: l_var8_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1217: l_var9_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1218: l_var10_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1219: l_var11_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1220: l_var12_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1221: --
1222: l_mmperid_va benutils.g_number_table := benutils.g_number_table();

Line 1219: l_var11_col benutils.g_varchar2_table := benutils.g_varchar2_table();

1215: l_var7_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1216: l_var8_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1217: l_var9_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1218: l_var10_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1219: l_var11_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1220: l_var12_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1221: --
1222: l_mmperid_va benutils.g_number_table := benutils.g_number_table();
1223: l_mmcombid_va benutils.g_number_table := benutils.g_number_table();

Line 1220: l_var12_col benutils.g_varchar2_table := benutils.g_varchar2_table();

1216: l_var8_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1217: l_var9_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1218: l_var10_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1219: l_var11_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1220: l_var12_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1221: --
1222: l_mmperid_va benutils.g_number_table := benutils.g_number_table();
1223: l_mmcombid_va benutils.g_number_table := benutils.g_number_table();
1224: l_mmcombid2_va benutils.g_number_table := benutils.g_number_table();

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

1218: l_var10_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1219: l_var11_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1220: l_var12_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1221: --
1222: l_mmperid_va benutils.g_number_table := benutils.g_number_table();
1223: l_mmcombid_va benutils.g_number_table := benutils.g_number_table();
1224: l_mmcombid2_va benutils.g_number_table := benutils.g_number_table();
1225: l_mmcombid3_va benutils.g_number_table := benutils.g_number_table();
1226: l_mmcombid4_va benutils.g_number_table := benutils.g_number_table();

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

1219: l_var11_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1220: l_var12_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1221: --
1222: l_mmperid_va benutils.g_number_table := benutils.g_number_table();
1223: l_mmcombid_va benutils.g_number_table := benutils.g_number_table();
1224: l_mmcombid2_va benutils.g_number_table := benutils.g_number_table();
1225: l_mmcombid3_va benutils.g_number_table := benutils.g_number_table();
1226: l_mmcombid4_va benutils.g_number_table := benutils.g_number_table();
1227: l_mmcnt_va benutils.g_number_table := benutils.g_number_table();

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

1220: l_var12_col benutils.g_varchar2_table := benutils.g_varchar2_table();
1221: --
1222: l_mmperid_va benutils.g_number_table := benutils.g_number_table();
1223: l_mmcombid_va benutils.g_number_table := benutils.g_number_table();
1224: l_mmcombid2_va benutils.g_number_table := benutils.g_number_table();
1225: l_mmcombid3_va benutils.g_number_table := benutils.g_number_table();
1226: l_mmcombid4_va benutils.g_number_table := benutils.g_number_table();
1227: l_mmcnt_va benutils.g_number_table := benutils.g_number_table();
1228: l_mmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();

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

1221: --
1222: l_mmperid_va benutils.g_number_table := benutils.g_number_table();
1223: l_mmcombid_va benutils.g_number_table := benutils.g_number_table();
1224: l_mmcombid2_va benutils.g_number_table := benutils.g_number_table();
1225: l_mmcombid3_va benutils.g_number_table := benutils.g_number_table();
1226: l_mmcombid4_va benutils.g_number_table := benutils.g_number_table();
1227: l_mmcnt_va benutils.g_number_table := benutils.g_number_table();
1228: l_mmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1229: l_mmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();

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

1222: l_mmperid_va benutils.g_number_table := benutils.g_number_table();
1223: l_mmcombid_va benutils.g_number_table := benutils.g_number_table();
1224: l_mmcombid2_va benutils.g_number_table := benutils.g_number_table();
1225: l_mmcombid3_va benutils.g_number_table := benutils.g_number_table();
1226: l_mmcombid4_va benutils.g_number_table := benutils.g_number_table();
1227: l_mmcnt_va benutils.g_number_table := benutils.g_number_table();
1228: l_mmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1229: l_mmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1230: l_mmcombnm3_va benutils.g_varchar2_table := benutils.g_varchar2_table();

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

1223: l_mmcombid_va benutils.g_number_table := benutils.g_number_table();
1224: l_mmcombid2_va benutils.g_number_table := benutils.g_number_table();
1225: l_mmcombid3_va benutils.g_number_table := benutils.g_number_table();
1226: l_mmcombid4_va benutils.g_number_table := benutils.g_number_table();
1227: l_mmcnt_va benutils.g_number_table := benutils.g_number_table();
1228: l_mmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1229: l_mmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1230: l_mmcombnm3_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1231: l_mmcombnm4_va benutils.g_varchar2_table := benutils.g_varchar2_table();

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

1224: l_mmcombid2_va benutils.g_number_table := benutils.g_number_table();
1225: l_mmcombid3_va benutils.g_number_table := benutils.g_number_table();
1226: l_mmcombid4_va benutils.g_number_table := benutils.g_number_table();
1227: l_mmcnt_va benutils.g_number_table := benutils.g_number_table();
1228: l_mmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1229: l_mmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1230: l_mmcombnm3_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1231: l_mmcombnm4_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1232: l_adfname_va benutils.g_varchar2_table := benutils.g_varchar2_table();

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

1225: l_mmcombid3_va benutils.g_number_table := benutils.g_number_table();
1226: l_mmcombid4_va benutils.g_number_table := benutils.g_number_table();
1227: l_mmcnt_va benutils.g_number_table := benutils.g_number_table();
1228: l_mmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1229: l_mmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1230: l_mmcombnm3_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1231: l_mmcombnm4_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1232: l_adfname_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1233: l_adffilver_va benutils.g_varchar2_table := benutils.g_varchar2_table();

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

1226: l_mmcombid4_va benutils.g_number_table := benutils.g_number_table();
1227: l_mmcnt_va benutils.g_number_table := benutils.g_number_table();
1228: l_mmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1229: l_mmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1230: l_mmcombnm3_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1231: l_mmcombnm4_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1232: l_adfname_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1233: l_adffilver_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1234: l_adflud_va benutils.g_date_table := benutils.g_date_table();

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

1227: l_mmcnt_va benutils.g_number_table := benutils.g_number_table();
1228: l_mmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1229: l_mmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1230: l_mmcombnm3_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1231: l_mmcombnm4_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1232: l_adfname_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1233: l_adffilver_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1234: l_adflud_va benutils.g_date_table := benutils.g_date_table();
1235: --

Line 1232: l_adfname_va benutils.g_varchar2_table := benutils.g_varchar2_table();

1228: l_mmcombnm_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1229: l_mmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1230: l_mmcombnm3_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1231: l_mmcombnm4_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1232: l_adfname_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1233: l_adffilver_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1234: l_adflud_va benutils.g_date_table := benutils.g_date_table();
1235: --
1236: l_sql_str long;

Line 1233: l_adffilver_va benutils.g_varchar2_table := benutils.g_varchar2_table();

1229: l_mmcombnm2_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1230: l_mmcombnm3_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1231: l_mmcombnm4_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1232: l_adfname_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1233: l_adffilver_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1234: l_adflud_va benutils.g_date_table := benutils.g_date_table();
1235: --
1236: l_sql_str long;
1237: l_sel_str long;

Line 1234: l_adflud_va benutils.g_date_table := benutils.g_date_table();

1230: l_mmcombnm3_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1231: l_mmcombnm4_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1232: l_adfname_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1233: l_adffilver_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1234: l_adflud_va benutils.g_date_table := benutils.g_date_table();
1235: --
1236: l_sql_str long;
1237: l_sel_str long;
1238: l_from_str long;

Line 1257: l_mmrltyp_rbvclcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

1253: --
1254: l_hist_duration pls_integer;
1255: l_show_matches boolean;
1256: --
1257: l_mmrltyp_rbvclcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1258: l_mmrltyp_rbvclcd_vaen pls_integer;
1259: --
1260: l_mmperid_rbvclcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1261: --

Line 1260: l_mmperid_rbvclcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

1256: --
1257: l_mmrltyp_rbvclcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1258: l_mmrltyp_rbvclcd_vaen pls_integer;
1259: --
1260: l_mmperid_rbvclcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1261: --
1262: l_tmpmmclccode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1263: l_bugtype_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1264: l_mmerrmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

Line 1262: l_tmpmmclccode_va benutils.g_v2_150_table := benutils.g_v2_150_table();

1258: l_mmrltyp_rbvclcd_vaen pls_integer;
1259: --
1260: l_mmperid_rbvclcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1261: --
1262: l_tmpmmclccode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1263: l_bugtype_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1264: l_mmerrmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1265: l_mmmxperid_va benutils.g_number_table := benutils.g_number_table();
1266: l_mmerrcnt_va benutils.g_number_table := benutils.g_number_table();

Line 1263: l_bugtype_va benutils.g_v2_150_table := benutils.g_v2_150_table();

1259: --
1260: l_mmperid_rbvclcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1261: --
1262: l_tmpmmclccode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1263: l_bugtype_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1264: l_mmerrmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1265: l_mmmxperid_va benutils.g_number_table := benutils.g_number_table();
1266: l_mmerrcnt_va benutils.g_number_table := benutils.g_number_table();
1267: l_errmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

Line 1264: l_mmerrmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

1260: l_mmperid_rbvclcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1261: --
1262: l_tmpmmclccode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1263: l_bugtype_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1264: l_mmerrmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1265: l_mmmxperid_va benutils.g_number_table := benutils.g_number_table();
1266: l_mmerrcnt_va benutils.g_number_table := benutils.g_number_table();
1267: l_errmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1268: l_mxperid_va benutils.g_number_table := benutils.g_number_table();

Line 1265: l_mmmxperid_va benutils.g_number_table := benutils.g_number_table();

1261: --
1262: l_tmpmmclccode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1263: l_bugtype_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1264: l_mmerrmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1265: l_mmmxperid_va benutils.g_number_table := benutils.g_number_table();
1266: l_mmerrcnt_va benutils.g_number_table := benutils.g_number_table();
1267: l_errmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1268: l_mxperid_va benutils.g_number_table := benutils.g_number_table();
1269: l_errcnt_va benutils.g_number_table := benutils.g_number_table();

Line 1266: l_mmerrcnt_va benutils.g_number_table := benutils.g_number_table();

1262: l_tmpmmclccode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1263: l_bugtype_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1264: l_mmerrmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1265: l_mmmxperid_va benutils.g_number_table := benutils.g_number_table();
1266: l_mmerrcnt_va benutils.g_number_table := benutils.g_number_table();
1267: l_errmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1268: l_mxperid_va benutils.g_number_table := benutils.g_number_table();
1269: l_errcnt_va benutils.g_number_table := benutils.g_number_table();
1270: l_oraerrtext_va benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 1267: l_errmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

1263: l_bugtype_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1264: l_mmerrmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1265: l_mmmxperid_va benutils.g_number_table := benutils.g_number_table();
1266: l_mmerrcnt_va benutils.g_number_table := benutils.g_number_table();
1267: l_errmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1268: l_mxperid_va benutils.g_number_table := benutils.g_number_table();
1269: l_errcnt_va benutils.g_number_table := benutils.g_number_table();
1270: l_oraerrtext_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1271: l_oraerrtextinst_va benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 1268: l_mxperid_va benutils.g_number_table := benutils.g_number_table();

1264: l_mmerrmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1265: l_mmmxperid_va benutils.g_number_table := benutils.g_number_table();
1266: l_mmerrcnt_va benutils.g_number_table := benutils.g_number_table();
1267: l_errmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1268: l_mxperid_va benutils.g_number_table := benutils.g_number_table();
1269: l_errcnt_va benutils.g_number_table := benutils.g_number_table();
1270: l_oraerrtext_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1271: l_oraerrtextinst_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1272: l_oraerrmxperid_va benutils.g_number_table := benutils.g_number_table();

Line 1269: l_errcnt_va benutils.g_number_table := benutils.g_number_table();

1265: l_mmmxperid_va benutils.g_number_table := benutils.g_number_table();
1266: l_mmerrcnt_va benutils.g_number_table := benutils.g_number_table();
1267: l_errmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1268: l_mxperid_va benutils.g_number_table := benutils.g_number_table();
1269: l_errcnt_va benutils.g_number_table := benutils.g_number_table();
1270: l_oraerrtext_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1271: l_oraerrtextinst_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1272: l_oraerrmxperid_va benutils.g_number_table := benutils.g_number_table();
1273: l_oraerrcnt_va benutils.g_number_table := benutils.g_number_table();

Line 1270: l_oraerrtext_va benutils.g_varchar2_table := benutils.g_varchar2_table();

1266: l_mmerrcnt_va benutils.g_number_table := benutils.g_number_table();
1267: l_errmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1268: l_mxperid_va benutils.g_number_table := benutils.g_number_table();
1269: l_errcnt_va benutils.g_number_table := benutils.g_number_table();
1270: l_oraerrtext_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1271: l_oraerrtextinst_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1272: l_oraerrmxperid_va benutils.g_number_table := benutils.g_number_table();
1273: l_oraerrcnt_va benutils.g_number_table := benutils.g_number_table();
1274: l_bugpscode_va benutils.g_v2_150_table := benutils.g_v2_150_table();

Line 1271: l_oraerrtextinst_va benutils.g_varchar2_table := benutils.g_varchar2_table();

1267: l_errmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1268: l_mxperid_va benutils.g_number_table := benutils.g_number_table();
1269: l_errcnt_va benutils.g_number_table := benutils.g_number_table();
1270: l_oraerrtext_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1271: l_oraerrtextinst_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1272: l_oraerrmxperid_va benutils.g_number_table := benutils.g_number_table();
1273: l_oraerrcnt_va benutils.g_number_table := benutils.g_number_table();
1274: l_bugpscode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1275: l_bugnum_va benutils.g_number_table := benutils.g_number_table();

Line 1272: l_oraerrmxperid_va benutils.g_number_table := benutils.g_number_table();

1268: l_mxperid_va benutils.g_number_table := benutils.g_number_table();
1269: l_errcnt_va benutils.g_number_table := benutils.g_number_table();
1270: l_oraerrtext_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1271: l_oraerrtextinst_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1272: l_oraerrmxperid_va benutils.g_number_table := benutils.g_number_table();
1273: l_oraerrcnt_va benutils.g_number_table := benutils.g_number_table();
1274: l_bugpscode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1275: l_bugnum_va benutils.g_number_table := benutils.g_number_table();
1276: l_buglud_va benutils.g_date_table := benutils.g_date_table();

Line 1273: l_oraerrcnt_va benutils.g_number_table := benutils.g_number_table();

1269: l_errcnt_va benutils.g_number_table := benutils.g_number_table();
1270: l_oraerrtext_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1271: l_oraerrtextinst_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1272: l_oraerrmxperid_va benutils.g_number_table := benutils.g_number_table();
1273: l_oraerrcnt_va benutils.g_number_table := benutils.g_number_table();
1274: l_bugpscode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1275: l_bugnum_va benutils.g_number_table := benutils.g_number_table();
1276: l_buglud_va benutils.g_date_table := benutils.g_date_table();
1277: l_tmpmmerrmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

Line 1274: l_bugpscode_va benutils.g_v2_150_table := benutils.g_v2_150_table();

1270: l_oraerrtext_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1271: l_oraerrtextinst_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1272: l_oraerrmxperid_va benutils.g_number_table := benutils.g_number_table();
1273: l_oraerrcnt_va benutils.g_number_table := benutils.g_number_table();
1274: l_bugpscode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1275: l_bugnum_va benutils.g_number_table := benutils.g_number_table();
1276: l_buglud_va benutils.g_date_table := benutils.g_date_table();
1277: l_tmpmmerrmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1278: l_tmpmmmxperid_va benutils.g_number_table := benutils.g_number_table();

Line 1275: l_bugnum_va benutils.g_number_table := benutils.g_number_table();

1271: l_oraerrtextinst_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1272: l_oraerrmxperid_va benutils.g_number_table := benutils.g_number_table();
1273: l_oraerrcnt_va benutils.g_number_table := benutils.g_number_table();
1274: l_bugpscode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1275: l_bugnum_va benutils.g_number_table := benutils.g_number_table();
1276: l_buglud_va benutils.g_date_table := benutils.g_date_table();
1277: l_tmpmmerrmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1278: l_tmpmmmxperid_va benutils.g_number_table := benutils.g_number_table();
1279: l_tmpmmerrcnt_va benutils.g_number_table := benutils.g_number_table();

Line 1276: l_buglud_va benutils.g_date_table := benutils.g_date_table();

1272: l_oraerrmxperid_va benutils.g_number_table := benutils.g_number_table();
1273: l_oraerrcnt_va benutils.g_number_table := benutils.g_number_table();
1274: l_bugpscode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1275: l_bugnum_va benutils.g_number_table := benutils.g_number_table();
1276: l_buglud_va benutils.g_date_table := benutils.g_date_table();
1277: l_tmpmmerrmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1278: l_tmpmmmxperid_va benutils.g_number_table := benutils.g_number_table();
1279: l_tmpmmerrcnt_va benutils.g_number_table := benutils.g_number_table();
1280: --

Line 1277: l_tmpmmerrmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

1273: l_oraerrcnt_va benutils.g_number_table := benutils.g_number_table();
1274: l_bugpscode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1275: l_bugnum_va benutils.g_number_table := benutils.g_number_table();
1276: l_buglud_va benutils.g_date_table := benutils.g_date_table();
1277: l_tmpmmerrmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1278: l_tmpmmmxperid_va benutils.g_number_table := benutils.g_number_table();
1279: l_tmpmmerrcnt_va benutils.g_number_table := benutils.g_number_table();
1280: --
1281: l_apperrtypdiscr_messcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

Line 1278: l_tmpmmmxperid_va benutils.g_number_table := benutils.g_number_table();

1274: l_bugpscode_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1275: l_bugnum_va benutils.g_number_table := benutils.g_number_table();
1276: l_buglud_va benutils.g_date_table := benutils.g_date_table();
1277: l_tmpmmerrmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1278: l_tmpmmmxperid_va benutils.g_number_table := benutils.g_number_table();
1279: l_tmpmmerrcnt_va benutils.g_number_table := benutils.g_number_table();
1280: --
1281: l_apperrtypdiscr_messcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1282: l_apperrtypdiscr_cnt_va benutils.g_number_table := benutils.g_number_table();

Line 1279: l_tmpmmerrcnt_va benutils.g_number_table := benutils.g_number_table();

1275: l_bugnum_va benutils.g_number_table := benutils.g_number_table();
1276: l_buglud_va benutils.g_date_table := benutils.g_date_table();
1277: l_tmpmmerrmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1278: l_tmpmmmxperid_va benutils.g_number_table := benutils.g_number_table();
1279: l_tmpmmerrcnt_va benutils.g_number_table := benutils.g_number_table();
1280: --
1281: l_apperrtypdiscr_messcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1282: l_apperrtypdiscr_cnt_va benutils.g_number_table := benutils.g_number_table();
1283: l_perid_va1 benutils.g_number_table := benutils.g_number_table();

Line 1281: l_apperrtypdiscr_messcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

1277: l_tmpmmerrmesscd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1278: l_tmpmmmxperid_va benutils.g_number_table := benutils.g_number_table();
1279: l_tmpmmerrcnt_va benutils.g_number_table := benutils.g_number_table();
1280: --
1281: l_apperrtypdiscr_messcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1282: l_apperrtypdiscr_cnt_va benutils.g_number_table := benutils.g_number_table();
1283: l_perid_va1 benutils.g_number_table := benutils.g_number_table();
1284: l_perid_va2 benutils.g_number_table := benutils.g_number_table();
1285: l_periddiscrep_perid_va benutils.g_number_table := benutils.g_number_table();

Line 1282: l_apperrtypdiscr_cnt_va benutils.g_number_table := benutils.g_number_table();

1278: l_tmpmmmxperid_va benutils.g_number_table := benutils.g_number_table();
1279: l_tmpmmerrcnt_va benutils.g_number_table := benutils.g_number_table();
1280: --
1281: l_apperrtypdiscr_messcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1282: l_apperrtypdiscr_cnt_va benutils.g_number_table := benutils.g_number_table();
1283: l_perid_va1 benutils.g_number_table := benutils.g_number_table();
1284: l_perid_va2 benutils.g_number_table := benutils.g_number_table();
1285: l_periddiscrep_perid_va benutils.g_number_table := benutils.g_number_table();
1286: l_periddiscrep_errcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

Line 1283: l_perid_va1 benutils.g_number_table := benutils.g_number_table();

1279: l_tmpmmerrcnt_va benutils.g_number_table := benutils.g_number_table();
1280: --
1281: l_apperrtypdiscr_messcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1282: l_apperrtypdiscr_cnt_va benutils.g_number_table := benutils.g_number_table();
1283: l_perid_va1 benutils.g_number_table := benutils.g_number_table();
1284: l_perid_va2 benutils.g_number_table := benutils.g_number_table();
1285: l_periddiscrep_perid_va benutils.g_number_table := benutils.g_number_table();
1286: l_periddiscrep_errcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1287: l_mmperlud_va benutils.g_date_table := benutils.g_date_table();

Line 1284: l_perid_va2 benutils.g_number_table := benutils.g_number_table();

1280: --
1281: l_apperrtypdiscr_messcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1282: l_apperrtypdiscr_cnt_va benutils.g_number_table := benutils.g_number_table();
1283: l_perid_va1 benutils.g_number_table := benutils.g_number_table();
1284: l_perid_va2 benutils.g_number_table := benutils.g_number_table();
1285: l_periddiscrep_perid_va benutils.g_number_table := benutils.g_number_table();
1286: l_periddiscrep_errcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1287: l_mmperlud_va benutils.g_date_table := benutils.g_date_table();
1288: l_mmexclperid_va benutils.g_number_table := benutils.g_number_table();

Line 1285: l_periddiscrep_perid_va benutils.g_number_table := benutils.g_number_table();

1281: l_apperrtypdiscr_messcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1282: l_apperrtypdiscr_cnt_va benutils.g_number_table := benutils.g_number_table();
1283: l_perid_va1 benutils.g_number_table := benutils.g_number_table();
1284: l_perid_va2 benutils.g_number_table := benutils.g_number_table();
1285: l_periddiscrep_perid_va benutils.g_number_table := benutils.g_number_table();
1286: l_periddiscrep_errcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1287: l_mmperlud_va benutils.g_date_table := benutils.g_date_table();
1288: l_mmexclperid_va benutils.g_number_table := benutils.g_number_table();
1289: l_newapperr_peridva benutils.g_number_table := benutils.g_number_table();

Line 1286: l_periddiscrep_errcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();

1282: l_apperrtypdiscr_cnt_va benutils.g_number_table := benutils.g_number_table();
1283: l_perid_va1 benutils.g_number_table := benutils.g_number_table();
1284: l_perid_va2 benutils.g_number_table := benutils.g_number_table();
1285: l_periddiscrep_perid_va benutils.g_number_table := benutils.g_number_table();
1286: l_periddiscrep_errcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1287: l_mmperlud_va benutils.g_date_table := benutils.g_date_table();
1288: l_mmexclperid_va benutils.g_number_table := benutils.g_number_table();
1289: l_newapperr_peridva benutils.g_number_table := benutils.g_number_table();
1290: l_mmexclperid_nwva benutils.g_number_table := benutils.g_number_table();

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

1283: l_perid_va1 benutils.g_number_table := benutils.g_number_table();
1284: l_perid_va2 benutils.g_number_table := benutils.g_number_table();
1285: l_periddiscrep_perid_va benutils.g_number_table := benutils.g_number_table();
1286: l_periddiscrep_errcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1287: l_mmperlud_va benutils.g_date_table := benutils.g_date_table();
1288: l_mmexclperid_va benutils.g_number_table := benutils.g_number_table();
1289: l_newapperr_peridva benutils.g_number_table := benutils.g_number_table();
1290: l_mmexclperid_nwva benutils.g_number_table := benutils.g_number_table();
1291: l_mmexclperid_leva benutils.g_number_table := benutils.g_number_table();

Line 1288: l_mmexclperid_va benutils.g_number_table := benutils.g_number_table();

1284: l_perid_va2 benutils.g_number_table := benutils.g_number_table();
1285: l_periddiscrep_perid_va benutils.g_number_table := benutils.g_number_table();
1286: l_periddiscrep_errcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1287: l_mmperlud_va benutils.g_date_table := benutils.g_date_table();
1288: l_mmexclperid_va benutils.g_number_table := benutils.g_number_table();
1289: l_newapperr_peridva benutils.g_number_table := benutils.g_number_table();
1290: l_mmexclperid_nwva benutils.g_number_table := benutils.g_number_table();
1291: l_mmexclperid_leva benutils.g_number_table := benutils.g_number_table();
1292: --

Line 1289: l_newapperr_peridva benutils.g_number_table := benutils.g_number_table();

1285: l_periddiscrep_perid_va benutils.g_number_table := benutils.g_number_table();
1286: l_periddiscrep_errcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1287: l_mmperlud_va benutils.g_date_table := benutils.g_date_table();
1288: l_mmexclperid_va benutils.g_number_table := benutils.g_number_table();
1289: l_newapperr_peridva benutils.g_number_table := benutils.g_number_table();
1290: l_mmexclperid_nwva benutils.g_number_table := benutils.g_number_table();
1291: l_mmexclperid_leva benutils.g_number_table := benutils.g_number_table();
1292: --
1293: l_text_va benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 1290: l_mmexclperid_nwva benutils.g_number_table := benutils.g_number_table();

1286: l_periddiscrep_errcd_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1287: l_mmperlud_va benutils.g_date_table := benutils.g_date_table();
1288: l_mmexclperid_va benutils.g_number_table := benutils.g_number_table();
1289: l_newapperr_peridva benutils.g_number_table := benutils.g_number_table();
1290: l_mmexclperid_nwva benutils.g_number_table := benutils.g_number_table();
1291: l_mmexclperid_leva benutils.g_number_table := benutils.g_number_table();
1292: --
1293: l_text_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1294: l_ccrerrcomptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 1291: l_mmexclperid_leva benutils.g_number_table := benutils.g_number_table();

1287: l_mmperlud_va benutils.g_date_table := benutils.g_date_table();
1288: l_mmexclperid_va benutils.g_number_table := benutils.g_number_table();
1289: l_newapperr_peridva benutils.g_number_table := benutils.g_number_table();
1290: l_mmexclperid_nwva benutils.g_number_table := benutils.g_number_table();
1291: l_mmexclperid_leva benutils.g_number_table := benutils.g_number_table();
1292: --
1293: l_text_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1294: l_ccrerrcomptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1295: l_ccrhanderrcomptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 1293: l_text_va benutils.g_varchar2_table := benutils.g_varchar2_table();

1289: l_newapperr_peridva benutils.g_number_table := benutils.g_number_table();
1290: l_mmexclperid_nwva benutils.g_number_table := benutils.g_number_table();
1291: l_mmexclperid_leva benutils.g_number_table := benutils.g_number_table();
1292: --
1293: l_text_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1294: l_ccrerrcomptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1295: l_ccrhanderrcomptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1296: --
1297: l_alertstr_va benutils.g_v2_150_table := benutils.g_v2_150_table();

Line 1294: l_ccrerrcomptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();

1290: l_mmexclperid_nwva benutils.g_number_table := benutils.g_number_table();
1291: l_mmexclperid_leva benutils.g_number_table := benutils.g_number_table();
1292: --
1293: l_text_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1294: l_ccrerrcomptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1295: l_ccrhanderrcomptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1296: --
1297: l_alertstr_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1298: --

Line 1295: l_ccrhanderrcomptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();

1291: l_mmexclperid_leva benutils.g_number_table := benutils.g_number_table();
1292: --
1293: l_text_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1294: l_ccrerrcomptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1295: l_ccrhanderrcomptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1296: --
1297: l_alertstr_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1298: --
1299: l_mm_elenum pls_integer;

Line 1297: l_alertstr_va benutils.g_v2_150_table := benutils.g_v2_150_table();

1293: l_text_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1294: l_ccrerrcomptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1295: l_ccrhanderrcomptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1296: --
1297: l_alertstr_va benutils.g_v2_150_table := benutils.g_v2_150_table();
1298: --
1299: l_mm_elenum pls_integer;
1300: l_mt_elenum pls_integer;
1301: --

Line 1687: l_lul_va benutils.g_number_table := benutils.g_number_table();

1683: ,p_mnchkcnt in out nocopy number
1684: )
1685: is
1686: --
1687: l_lul_va benutils.g_number_table := benutils.g_number_table();
1688: l_bftcredt_va benutils.g_date_table := benutils.g_date_table();
1689: l_lud_va benutils.g_date_table := benutils.g_date_table();
1690: l_cnt_va benutils.g_number_table := benutils.g_number_table();
1691: l_lultotsecs_va benutils.g_number_table := benutils.g_number_table();

Line 1688: l_bftcredt_va benutils.g_date_table := benutils.g_date_table();

1684: )
1685: is
1686: --
1687: l_lul_va benutils.g_number_table := benutils.g_number_table();
1688: l_bftcredt_va benutils.g_date_table := benutils.g_date_table();
1689: l_lud_va benutils.g_date_table := benutils.g_date_table();
1690: l_cnt_va benutils.g_number_table := benutils.g_number_table();
1691: l_lultotsecs_va benutils.g_number_table := benutils.g_number_table();
1692: l_lulavgsecs_va benutils.g_number_table := benutils.g_number_table();

Line 1689: l_lud_va benutils.g_date_table := benutils.g_date_table();

1685: is
1686: --
1687: l_lul_va benutils.g_number_table := benutils.g_number_table();
1688: l_bftcredt_va benutils.g_date_table := benutils.g_date_table();
1689: l_lud_va benutils.g_date_table := benutils.g_date_table();
1690: l_cnt_va benutils.g_number_table := benutils.g_number_table();
1691: l_lultotsecs_va benutils.g_number_table := benutils.g_number_table();
1692: l_lulavgsecs_va benutils.g_number_table := benutils.g_number_table();
1693: --

Line 1690: l_cnt_va benutils.g_number_table := benutils.g_number_table();

1686: --
1687: l_lul_va benutils.g_number_table := benutils.g_number_table();
1688: l_bftcredt_va benutils.g_date_table := benutils.g_date_table();
1689: l_lud_va benutils.g_date_table := benutils.g_date_table();
1690: l_cnt_va benutils.g_number_table := benutils.g_number_table();
1691: l_lultotsecs_va benutils.g_number_table := benutils.g_number_table();
1692: l_lulavgsecs_va benutils.g_number_table := benutils.g_number_table();
1693: --
1694: l_thread_cnt number;

Line 1691: l_lultotsecs_va benutils.g_number_table := benutils.g_number_table();

1687: l_lul_va benutils.g_number_table := benutils.g_number_table();
1688: l_bftcredt_va benutils.g_date_table := benutils.g_date_table();
1689: l_lud_va benutils.g_date_table := benutils.g_date_table();
1690: l_cnt_va benutils.g_number_table := benutils.g_number_table();
1691: l_lultotsecs_va benutils.g_number_table := benutils.g_number_table();
1692: l_lulavgsecs_va benutils.g_number_table := benutils.g_number_table();
1693: --
1694: l_thread_cnt number;
1695: l_mx_en pls_integer;

Line 1692: l_lulavgsecs_va benutils.g_number_table := benutils.g_number_table();

1688: l_bftcredt_va benutils.g_date_table := benutils.g_date_table();
1689: l_lud_va benutils.g_date_table := benutils.g_date_table();
1690: l_cnt_va benutils.g_number_table := benutils.g_number_table();
1691: l_lultotsecs_va benutils.g_number_table := benutils.g_number_table();
1692: l_lulavgsecs_va benutils.g_number_table := benutils.g_number_table();
1693: --
1694: l_thread_cnt number;
1695: l_mx_en pls_integer;
1696: l_mn_en pls_integer;

Line 1779: ,p_ccrerrcomptxt_va in out nocopy benutils.g_varchar2_table

1775: ,p_ccrscdqreq_cnt in out nocopy number
1776: ,p_ccroraerrreq_cnt in out nocopy number
1777: ,p_ccrhanderrreq_cnt in out nocopy number
1778: ,p_ccrapperrreq_cnt in out nocopy number
1779: ,p_ccrerrcomptxt_va in out nocopy benutils.g_varchar2_table
1780: ,p_ccrhanderrcomptxt_va in out nocopy benutils.g_varchar2_table
1781: )
1782: is
1783: --

Line 1780: ,p_ccrhanderrcomptxt_va in out nocopy benutils.g_varchar2_table

1776: ,p_ccroraerrreq_cnt in out nocopy number
1777: ,p_ccrhanderrreq_cnt in out nocopy number
1778: ,p_ccrapperrreq_cnt in out nocopy number
1779: ,p_ccrerrcomptxt_va in out nocopy benutils.g_varchar2_table
1780: ,p_ccrhanderrcomptxt_va in out nocopy benutils.g_varchar2_table
1781: )
1782: is
1783: --
1784: l_reqid_va benutils.g_number_table := benutils.g_number_table();

Line 1784: l_reqid_va benutils.g_number_table := benutils.g_number_table();

1780: ,p_ccrhanderrcomptxt_va in out nocopy benutils.g_varchar2_table
1781: )
1782: is
1783: --
1784: l_reqid_va benutils.g_number_table := benutils.g_number_table();
1785: l_ospid_va benutils.g_number_table := benutils.g_number_table();
1786: l_ossid_va benutils.g_number_table := benutils.g_number_table();
1787: l_parreqid_va benutils.g_number_table := benutils.g_number_table();
1788: l_phcode_va benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 1785: l_ospid_va benutils.g_number_table := benutils.g_number_table();

1781: )
1782: is
1783: --
1784: l_reqid_va benutils.g_number_table := benutils.g_number_table();
1785: l_ospid_va benutils.g_number_table := benutils.g_number_table();
1786: l_ossid_va benutils.g_number_table := benutils.g_number_table();
1787: l_parreqid_va benutils.g_number_table := benutils.g_number_table();
1788: l_phcode_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1789: l_stcode_va benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 1786: l_ossid_va benutils.g_number_table := benutils.g_number_table();

1782: is
1783: --
1784: l_reqid_va benutils.g_number_table := benutils.g_number_table();
1785: l_ospid_va benutils.g_number_table := benutils.g_number_table();
1786: l_ossid_va benutils.g_number_table := benutils.g_number_table();
1787: l_parreqid_va benutils.g_number_table := benutils.g_number_table();
1788: l_phcode_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1789: l_stcode_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1790: l_comptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 1787: l_parreqid_va benutils.g_number_table := benutils.g_number_table();

1783: --
1784: l_reqid_va benutils.g_number_table := benutils.g_number_table();
1785: l_ospid_va benutils.g_number_table := benutils.g_number_table();
1786: l_ossid_va benutils.g_number_table := benutils.g_number_table();
1787: l_parreqid_va benutils.g_number_table := benutils.g_number_table();
1788: l_phcode_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1789: l_stcode_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1790: l_comptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1791: l_reqchkcnt_va benutils.g_number_table := benutils.g_number_table();

Line 1788: l_phcode_va benutils.g_varchar2_table := benutils.g_varchar2_table();

1784: l_reqid_va benutils.g_number_table := benutils.g_number_table();
1785: l_ospid_va benutils.g_number_table := benutils.g_number_table();
1786: l_ossid_va benutils.g_number_table := benutils.g_number_table();
1787: l_parreqid_va benutils.g_number_table := benutils.g_number_table();
1788: l_phcode_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1789: l_stcode_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1790: l_comptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1791: l_reqchkcnt_va benutils.g_number_table := benutils.g_number_table();
1792: --

Line 1789: l_stcode_va benutils.g_varchar2_table := benutils.g_varchar2_table();

1785: l_ospid_va benutils.g_number_table := benutils.g_number_table();
1786: l_ossid_va benutils.g_number_table := benutils.g_number_table();
1787: l_parreqid_va benutils.g_number_table := benutils.g_number_table();
1788: l_phcode_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1789: l_stcode_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1790: l_comptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1791: l_reqchkcnt_va benutils.g_number_table := benutils.g_number_table();
1792: --
1793: l_errcomptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 1790: l_comptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();

1786: l_ossid_va benutils.g_number_table := benutils.g_number_table();
1787: l_parreqid_va benutils.g_number_table := benutils.g_number_table();
1788: l_phcode_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1789: l_stcode_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1790: l_comptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1791: l_reqchkcnt_va benutils.g_number_table := benutils.g_number_table();
1792: --
1793: l_errcomptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1794: l_handerrcomptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 1791: l_reqchkcnt_va benutils.g_number_table := benutils.g_number_table();

1787: l_parreqid_va benutils.g_number_table := benutils.g_number_table();
1788: l_phcode_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1789: l_stcode_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1790: l_comptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1791: l_reqchkcnt_va benutils.g_number_table := benutils.g_number_table();
1792: --
1793: l_errcomptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1794: l_handerrcomptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1795: --

Line 1793: l_errcomptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();

1789: l_stcode_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1790: l_comptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1791: l_reqchkcnt_va benutils.g_number_table := benutils.g_number_table();
1792: --
1793: l_errcomptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1794: l_handerrcomptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1795: --
1796: l_req_cnt number;
1797: l_compreq_cnt number;

Line 1794: l_handerrcomptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();

1790: l_comptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1791: l_reqchkcnt_va benutils.g_number_table := benutils.g_number_table();
1792: --
1793: l_errcomptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1794: l_handerrcomptxt_va benutils.g_varchar2_table := benutils.g_varchar2_table();
1795: --
1796: l_req_cnt number;
1797: l_compreq_cnt number;
1798: l_runreq_cnt number;

Line 2100: ,p_oraerrtext_va in out nocopy benutils.g_varchar2_table

2096: procedure OracleErrs
2097: (p_bft_id in number
2098: --
2099: ,p_oraerr_tot in out nocopy number
2100: ,p_oraerrtext_va in out nocopy benutils.g_varchar2_table
2101: ,p_oraerrcnt_va in out nocopy benutils.g_number_table
2102: ,p_oraerrmxperid_va in out nocopy benutils.g_number_table
2103: ,p_oraerrtextinst_va in out nocopy benutils.g_varchar2_table
2104: )

Line 2101: ,p_oraerrcnt_va in out nocopy benutils.g_number_table

2097: (p_bft_id in number
2098: --
2099: ,p_oraerr_tot in out nocopy number
2100: ,p_oraerrtext_va in out nocopy benutils.g_varchar2_table
2101: ,p_oraerrcnt_va in out nocopy benutils.g_number_table
2102: ,p_oraerrmxperid_va in out nocopy benutils.g_number_table
2103: ,p_oraerrtextinst_va in out nocopy benutils.g_varchar2_table
2104: )
2105: is

Line 2102: ,p_oraerrmxperid_va in out nocopy benutils.g_number_table

2098: --
2099: ,p_oraerr_tot in out nocopy number
2100: ,p_oraerrtext_va in out nocopy benutils.g_varchar2_table
2101: ,p_oraerrcnt_va in out nocopy benutils.g_number_table
2102: ,p_oraerrmxperid_va in out nocopy benutils.g_number_table
2103: ,p_oraerrtextinst_va in out nocopy benutils.g_varchar2_table
2104: )
2105: is
2106: --

Line 2103: ,p_oraerrtextinst_va in out nocopy benutils.g_varchar2_table

2099: ,p_oraerr_tot in out nocopy number
2100: ,p_oraerrtext_va in out nocopy benutils.g_varchar2_table
2101: ,p_oraerrcnt_va in out nocopy benutils.g_number_table
2102: ,p_oraerrmxperid_va in out nocopy benutils.g_number_table
2103: ,p_oraerrtextinst_va in out nocopy benutils.g_varchar2_table
2104: )
2105: is
2106: --
2107: l_text_va benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 2107: l_text_va benutils.g_varchar2_table := benutils.g_varchar2_table();

2103: ,p_oraerrtextinst_va in out nocopy benutils.g_varchar2_table
2104: )
2105: is
2106: --
2107: l_text_va benutils.g_varchar2_table := benutils.g_varchar2_table();
2108: l_textinst_va benutils.g_varchar2_table := benutils.g_varchar2_table();
2109: l_mxperid_va benutils.g_number_table := benutils.g_number_table();
2110: l_cnt_va benutils.g_number_table := benutils.g_number_table();
2111: --

Line 2108: l_textinst_va benutils.g_varchar2_table := benutils.g_varchar2_table();

2104: )
2105: is
2106: --
2107: l_text_va benutils.g_varchar2_table := benutils.g_varchar2_table();
2108: l_textinst_va benutils.g_varchar2_table := benutils.g_varchar2_table();
2109: l_mxperid_va benutils.g_number_table := benutils.g_number_table();
2110: l_cnt_va benutils.g_number_table := benutils.g_number_table();
2111: --
2112: l_err_en pls_integer;

Line 2109: l_mxperid_va benutils.g_number_table := benutils.g_number_table();

2105: is
2106: --
2107: l_text_va benutils.g_varchar2_table := benutils.g_varchar2_table();
2108: l_textinst_va benutils.g_varchar2_table := benutils.g_varchar2_table();
2109: l_mxperid_va benutils.g_number_table := benutils.g_number_table();
2110: l_cnt_va benutils.g_number_table := benutils.g_number_table();
2111: --
2112: l_err_en pls_integer;
2113: l_err_tot pls_integer;

Line 2110: l_cnt_va benutils.g_number_table := benutils.g_number_table();

2106: --
2107: l_text_va benutils.g_varchar2_table := benutils.g_varchar2_table();
2108: l_textinst_va benutils.g_varchar2_table := benutils.g_varchar2_table();
2109: l_mxperid_va benutils.g_number_table := benutils.g_number_table();
2110: l_cnt_va benutils.g_number_table := benutils.g_number_table();
2111: --
2112: l_err_en pls_integer;
2113: l_err_tot pls_integer;
2114: --

Line 4754: ,p_dispout_va in out nocopy benutils.g_varchar2_table

4750: ,p_reperr_text in boolean
4751: ,p_disp_rows in number
4752: ,p_ext_rslt_id in number
4753: --
4754: ,p_dispout_va in out nocopy benutils.g_varchar2_table
4755: )
4756: is
4757: --
4758: l_dispout_va benutils.g_varchar2_table := benutils.g_varchar2_table();

Line 4758: l_dispout_va benutils.g_varchar2_table := benutils.g_varchar2_table();

4754: ,p_dispout_va in out nocopy benutils.g_varchar2_table
4755: )
4756: is
4757: --
4758: l_dispout_va benutils.g_varchar2_table := benutils.g_varchar2_table();
4759: --
4760: l_errcode varchar2(2000);
4761: l_ele_num pls_integer;
4762: l_dispout_en pls_integer;