76: h_adjusted_rate NUMBER;
77: h_allowed_deprn_limit NUMBER;
78: h_percent_salvage_val NUMBER;
79: BEGIN
80: IF (FA_LOAD_TBL_PKG.g_deprn_count = 0) THEN
81: -- deprn_table is not loaded. deprn_table has to be loaded first.
82: raise load_exc;
83: END IF;
84:
84:
85: -- Initialize conversion_table.
86: conv_tbl.delete;
87:
88: FOR i IN FA_LOAD_TBL_PKG.deprn_table.FIRST .. FA_LOAD_TBL_PKG.deprn_table.LAST
89: LOOP
90: IF FA_LOAD_TBL_PKG.deprn_table.exists(i) THEN
91: -- Load into exactly same matching index postion.
92: conv_tbl(i).book_type_code := FA_LOAD_TBL_PKG.deprn_table(i).book_type_code;
86: conv_tbl.delete;
87:
88: FOR i IN FA_LOAD_TBL_PKG.deprn_table.FIRST .. FA_LOAD_TBL_PKG.deprn_table.LAST
89: LOOP
90: IF FA_LOAD_TBL_PKG.deprn_table.exists(i) THEN
91: -- Load into exactly same matching index postion.
92: conv_tbl(i).book_type_code := FA_LOAD_TBL_PKG.deprn_table(i).book_type_code;
93: conv_tbl(i).start_dpis := FA_LOAD_TBL_PKG.deprn_table(i).start_dpis;
94: conv_tbl(i).end_dpis := FA_LOAD_TBL_PKG.deprn_table(i).end_dpis;
88: FOR i IN FA_LOAD_TBL_PKG.deprn_table.FIRST .. FA_LOAD_TBL_PKG.deprn_table.LAST
89: LOOP
90: IF FA_LOAD_TBL_PKG.deprn_table.exists(i) THEN
91: -- Load into exactly same matching index postion.
92: conv_tbl(i).book_type_code := FA_LOAD_TBL_PKG.deprn_table(i).book_type_code;
93: conv_tbl(i).start_dpis := FA_LOAD_TBL_PKG.deprn_table(i).start_dpis;
94: conv_tbl(i).end_dpis := FA_LOAD_TBL_PKG.deprn_table(i).end_dpis;
95: h_life_in_months := FA_LOAD_TBL_PKG.deprn_table(i).life_in_months;
96: h_basic_rate := FA_LOAD_TBL_PKG.deprn_table(i).basic_rate;
89: LOOP
90: IF FA_LOAD_TBL_PKG.deprn_table.exists(i) THEN
91: -- Load into exactly same matching index postion.
92: conv_tbl(i).book_type_code := FA_LOAD_TBL_PKG.deprn_table(i).book_type_code;
93: conv_tbl(i).start_dpis := FA_LOAD_TBL_PKG.deprn_table(i).start_dpis;
94: conv_tbl(i).end_dpis := FA_LOAD_TBL_PKG.deprn_table(i).end_dpis;
95: h_life_in_months := FA_LOAD_TBL_PKG.deprn_table(i).life_in_months;
96: h_basic_rate := FA_LOAD_TBL_PKG.deprn_table(i).basic_rate;
97: h_adjusted_rate := FA_LOAD_TBL_PKG.deprn_table(i).adjusted_rate;
90: IF FA_LOAD_TBL_PKG.deprn_table.exists(i) THEN
91: -- Load into exactly same matching index postion.
92: conv_tbl(i).book_type_code := FA_LOAD_TBL_PKG.deprn_table(i).book_type_code;
93: conv_tbl(i).start_dpis := FA_LOAD_TBL_PKG.deprn_table(i).start_dpis;
94: conv_tbl(i).end_dpis := FA_LOAD_TBL_PKG.deprn_table(i).end_dpis;
95: h_life_in_months := FA_LOAD_TBL_PKG.deprn_table(i).life_in_months;
96: h_basic_rate := FA_LOAD_TBL_PKG.deprn_table(i).basic_rate;
97: h_adjusted_rate := FA_LOAD_TBL_PKG.deprn_table(i).adjusted_rate;
98: h_allowed_deprn_limit := FA_LOAD_TBL_PKG.deprn_table(i).allow_deprn_limit;
91: -- Load into exactly same matching index postion.
92: conv_tbl(i).book_type_code := FA_LOAD_TBL_PKG.deprn_table(i).book_type_code;
93: conv_tbl(i).start_dpis := FA_LOAD_TBL_PKG.deprn_table(i).start_dpis;
94: conv_tbl(i).end_dpis := FA_LOAD_TBL_PKG.deprn_table(i).end_dpis;
95: h_life_in_months := FA_LOAD_TBL_PKG.deprn_table(i).life_in_months;
96: h_basic_rate := FA_LOAD_TBL_PKG.deprn_table(i).basic_rate;
97: h_adjusted_rate := FA_LOAD_TBL_PKG.deprn_table(i).adjusted_rate;
98: h_allowed_deprn_limit := FA_LOAD_TBL_PKG.deprn_table(i).allow_deprn_limit;
99: h_percent_salvage_val := FA_LOAD_TBL_PKG.deprn_table(i).percent_salvage_value;
92: conv_tbl(i).book_type_code := FA_LOAD_TBL_PKG.deprn_table(i).book_type_code;
93: conv_tbl(i).start_dpis := FA_LOAD_TBL_PKG.deprn_table(i).start_dpis;
94: conv_tbl(i).end_dpis := FA_LOAD_TBL_PKG.deprn_table(i).end_dpis;
95: h_life_in_months := FA_LOAD_TBL_PKG.deprn_table(i).life_in_months;
96: h_basic_rate := FA_LOAD_TBL_PKG.deprn_table(i).basic_rate;
97: h_adjusted_rate := FA_LOAD_TBL_PKG.deprn_table(i).adjusted_rate;
98: h_allowed_deprn_limit := FA_LOAD_TBL_PKG.deprn_table(i).allow_deprn_limit;
99: h_percent_salvage_val := FA_LOAD_TBL_PKG.deprn_table(i).percent_salvage_value;
100: Convert_Formats(
93: conv_tbl(i).start_dpis := FA_LOAD_TBL_PKG.deprn_table(i).start_dpis;
94: conv_tbl(i).end_dpis := FA_LOAD_TBL_PKG.deprn_table(i).end_dpis;
95: h_life_in_months := FA_LOAD_TBL_PKG.deprn_table(i).life_in_months;
96: h_basic_rate := FA_LOAD_TBL_PKG.deprn_table(i).basic_rate;
97: h_adjusted_rate := FA_LOAD_TBL_PKG.deprn_table(i).adjusted_rate;
98: h_allowed_deprn_limit := FA_LOAD_TBL_PKG.deprn_table(i).allow_deprn_limit;
99: h_percent_salvage_val := FA_LOAD_TBL_PKG.deprn_table(i).percent_salvage_value;
100: Convert_Formats(
101: X_Life_In_Months => h_life_in_months,
94: conv_tbl(i).end_dpis := FA_LOAD_TBL_PKG.deprn_table(i).end_dpis;
95: h_life_in_months := FA_LOAD_TBL_PKG.deprn_table(i).life_in_months;
96: h_basic_rate := FA_LOAD_TBL_PKG.deprn_table(i).basic_rate;
97: h_adjusted_rate := FA_LOAD_TBL_PKG.deprn_table(i).adjusted_rate;
98: h_allowed_deprn_limit := FA_LOAD_TBL_PKG.deprn_table(i).allow_deprn_limit;
99: h_percent_salvage_val := FA_LOAD_TBL_PKG.deprn_table(i).percent_salvage_value;
100: Convert_Formats(
101: X_Life_In_Months => h_life_in_months,
102: X_Basic_Rate => h_basic_rate,
95: h_life_in_months := FA_LOAD_TBL_PKG.deprn_table(i).life_in_months;
96: h_basic_rate := FA_LOAD_TBL_PKG.deprn_table(i).basic_rate;
97: h_adjusted_rate := FA_LOAD_TBL_PKG.deprn_table(i).adjusted_rate;
98: h_allowed_deprn_limit := FA_LOAD_TBL_PKG.deprn_table(i).allow_deprn_limit;
99: h_percent_salvage_val := FA_LOAD_TBL_PKG.deprn_table(i).percent_salvage_value;
100: Convert_Formats(
101: X_Life_In_Months => h_life_in_months,
102: X_Basic_Rate => h_basic_rate,
103: X_Adjusted_Rate => h_adjusted_rate,