109: --
110: type g_cache_clf_rec_obj is record
111: (id number,
112: exist varchar2(1),
113: comp_lvl_uom ben_comp_lvl_fctr.comp_lvl_uom%type,
114: comp_src_cd ben_comp_lvl_fctr.comp_src_cd%type,
115: comp_lvl_det_cd ben_comp_lvl_fctr.comp_lvl_det_cd%type,
116: comp_lvl_det_rl ben_comp_lvl_fctr.comp_lvl_det_rl%type,
117: rndg_cd ben_comp_lvl_fctr.rndg_cd%type,
110: type g_cache_clf_rec_obj is record
111: (id number,
112: exist varchar2(1),
113: comp_lvl_uom ben_comp_lvl_fctr.comp_lvl_uom%type,
114: comp_src_cd ben_comp_lvl_fctr.comp_src_cd%type,
115: comp_lvl_det_cd ben_comp_lvl_fctr.comp_lvl_det_cd%type,
116: comp_lvl_det_rl ben_comp_lvl_fctr.comp_lvl_det_rl%type,
117: rndg_cd ben_comp_lvl_fctr.rndg_cd%type,
118: rndg_rl ben_comp_lvl_fctr.rndg_rl%type,
111: (id number,
112: exist varchar2(1),
113: comp_lvl_uom ben_comp_lvl_fctr.comp_lvl_uom%type,
114: comp_src_cd ben_comp_lvl_fctr.comp_src_cd%type,
115: comp_lvl_det_cd ben_comp_lvl_fctr.comp_lvl_det_cd%type,
116: comp_lvl_det_rl ben_comp_lvl_fctr.comp_lvl_det_rl%type,
117: rndg_cd ben_comp_lvl_fctr.rndg_cd%type,
118: rndg_rl ben_comp_lvl_fctr.rndg_rl%type,
119: mn_comp_val ben_comp_lvl_fctr.mn_comp_val%type,
112: exist varchar2(1),
113: comp_lvl_uom ben_comp_lvl_fctr.comp_lvl_uom%type,
114: comp_src_cd ben_comp_lvl_fctr.comp_src_cd%type,
115: comp_lvl_det_cd ben_comp_lvl_fctr.comp_lvl_det_cd%type,
116: comp_lvl_det_rl ben_comp_lvl_fctr.comp_lvl_det_rl%type,
117: rndg_cd ben_comp_lvl_fctr.rndg_cd%type,
118: rndg_rl ben_comp_lvl_fctr.rndg_rl%type,
119: mn_comp_val ben_comp_lvl_fctr.mn_comp_val%type,
120: mx_comp_val ben_comp_lvl_fctr.mx_comp_val%type,
113: comp_lvl_uom ben_comp_lvl_fctr.comp_lvl_uom%type,
114: comp_src_cd ben_comp_lvl_fctr.comp_src_cd%type,
115: comp_lvl_det_cd ben_comp_lvl_fctr.comp_lvl_det_cd%type,
116: comp_lvl_det_rl ben_comp_lvl_fctr.comp_lvl_det_rl%type,
117: rndg_cd ben_comp_lvl_fctr.rndg_cd%type,
118: rndg_rl ben_comp_lvl_fctr.rndg_rl%type,
119: mn_comp_val ben_comp_lvl_fctr.mn_comp_val%type,
120: mx_comp_val ben_comp_lvl_fctr.mx_comp_val%type,
121: bnfts_bal_id ben_comp_lvl_fctr.bnfts_bal_id%type,
114: comp_src_cd ben_comp_lvl_fctr.comp_src_cd%type,
115: comp_lvl_det_cd ben_comp_lvl_fctr.comp_lvl_det_cd%type,
116: comp_lvl_det_rl ben_comp_lvl_fctr.comp_lvl_det_rl%type,
117: rndg_cd ben_comp_lvl_fctr.rndg_cd%type,
118: rndg_rl ben_comp_lvl_fctr.rndg_rl%type,
119: mn_comp_val ben_comp_lvl_fctr.mn_comp_val%type,
120: mx_comp_val ben_comp_lvl_fctr.mx_comp_val%type,
121: bnfts_bal_id ben_comp_lvl_fctr.bnfts_bal_id%type,
122: defined_balance_id ben_comp_lvl_fctr.defined_balance_id%type,
115: comp_lvl_det_cd ben_comp_lvl_fctr.comp_lvl_det_cd%type,
116: comp_lvl_det_rl ben_comp_lvl_fctr.comp_lvl_det_rl%type,
117: rndg_cd ben_comp_lvl_fctr.rndg_cd%type,
118: rndg_rl ben_comp_lvl_fctr.rndg_rl%type,
119: mn_comp_val ben_comp_lvl_fctr.mn_comp_val%type,
120: mx_comp_val ben_comp_lvl_fctr.mx_comp_val%type,
121: bnfts_bal_id ben_comp_lvl_fctr.bnfts_bal_id%type,
122: defined_balance_id ben_comp_lvl_fctr.defined_balance_id%type,
123: sttd_sal_prdcty_cd ben_comp_lvl_fctr.sttd_sal_prdcty_cd%type,
116: comp_lvl_det_rl ben_comp_lvl_fctr.comp_lvl_det_rl%type,
117: rndg_cd ben_comp_lvl_fctr.rndg_cd%type,
118: rndg_rl ben_comp_lvl_fctr.rndg_rl%type,
119: mn_comp_val ben_comp_lvl_fctr.mn_comp_val%type,
120: mx_comp_val ben_comp_lvl_fctr.mx_comp_val%type,
121: bnfts_bal_id ben_comp_lvl_fctr.bnfts_bal_id%type,
122: defined_balance_id ben_comp_lvl_fctr.defined_balance_id%type,
123: sttd_sal_prdcty_cd ben_comp_lvl_fctr.sttd_sal_prdcty_cd%type,
124: comp_lvl_fctr_id ben_comp_lvl_fctr.comp_lvl_fctr_id%type,
117: rndg_cd ben_comp_lvl_fctr.rndg_cd%type,
118: rndg_rl ben_comp_lvl_fctr.rndg_rl%type,
119: mn_comp_val ben_comp_lvl_fctr.mn_comp_val%type,
120: mx_comp_val ben_comp_lvl_fctr.mx_comp_val%type,
121: bnfts_bal_id ben_comp_lvl_fctr.bnfts_bal_id%type,
122: defined_balance_id ben_comp_lvl_fctr.defined_balance_id%type,
123: sttd_sal_prdcty_cd ben_comp_lvl_fctr.sttd_sal_prdcty_cd%type,
124: comp_lvl_fctr_id ben_comp_lvl_fctr.comp_lvl_fctr_id%type,
125: comp_calc_rl ben_comp_lvl_fctr.comp_calc_rl%type);
118: rndg_rl ben_comp_lvl_fctr.rndg_rl%type,
119: mn_comp_val ben_comp_lvl_fctr.mn_comp_val%type,
120: mx_comp_val ben_comp_lvl_fctr.mx_comp_val%type,
121: bnfts_bal_id ben_comp_lvl_fctr.bnfts_bal_id%type,
122: defined_balance_id ben_comp_lvl_fctr.defined_balance_id%type,
123: sttd_sal_prdcty_cd ben_comp_lvl_fctr.sttd_sal_prdcty_cd%type,
124: comp_lvl_fctr_id ben_comp_lvl_fctr.comp_lvl_fctr_id%type,
125: comp_calc_rl ben_comp_lvl_fctr.comp_calc_rl%type);
126: --
119: mn_comp_val ben_comp_lvl_fctr.mn_comp_val%type,
120: mx_comp_val ben_comp_lvl_fctr.mx_comp_val%type,
121: bnfts_bal_id ben_comp_lvl_fctr.bnfts_bal_id%type,
122: defined_balance_id ben_comp_lvl_fctr.defined_balance_id%type,
123: sttd_sal_prdcty_cd ben_comp_lvl_fctr.sttd_sal_prdcty_cd%type,
124: comp_lvl_fctr_id ben_comp_lvl_fctr.comp_lvl_fctr_id%type,
125: comp_calc_rl ben_comp_lvl_fctr.comp_calc_rl%type);
126: --
127: type g_cache_clf_rec_table is table of g_cache_clf_rec_obj index
120: mx_comp_val ben_comp_lvl_fctr.mx_comp_val%type,
121: bnfts_bal_id ben_comp_lvl_fctr.bnfts_bal_id%type,
122: defined_balance_id ben_comp_lvl_fctr.defined_balance_id%type,
123: sttd_sal_prdcty_cd ben_comp_lvl_fctr.sttd_sal_prdcty_cd%type,
124: comp_lvl_fctr_id ben_comp_lvl_fctr.comp_lvl_fctr_id%type,
125: comp_calc_rl ben_comp_lvl_fctr.comp_calc_rl%type);
126: --
127: type g_cache_clf_rec_table is table of g_cache_clf_rec_obj index
128: by binary_integer;
121: bnfts_bal_id ben_comp_lvl_fctr.bnfts_bal_id%type,
122: defined_balance_id ben_comp_lvl_fctr.defined_balance_id%type,
123: sttd_sal_prdcty_cd ben_comp_lvl_fctr.sttd_sal_prdcty_cd%type,
124: comp_lvl_fctr_id ben_comp_lvl_fctr.comp_lvl_fctr_id%type,
125: comp_calc_rl ben_comp_lvl_fctr.comp_calc_rl%type);
126: --
127: type g_cache_clf_rec_table is table of g_cache_clf_rec_obj index
128: by binary_integer;
129: --