DBA Data[Home] [Help]

APPS.FA_MASS_REC_UTILS_PKG dependencies on FA_LOAD_TBL_PKG

Line 80: IF (FA_LOAD_TBL_PKG.g_deprn_count = 0) THEN

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:

Line 88: FOR i IN FA_LOAD_TBL_PKG.deprn_table.FIRST .. FA_LOAD_TBL_PKG.deprn_table.LAST

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;

Line 90: IF FA_LOAD_TBL_PKG.deprn_table.exists(i) THEN

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;

Line 92: conv_tbl(i).book_type_code := FA_LOAD_TBL_PKG.deprn_table(i).book_type_code;

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;

Line 93: conv_tbl(i).start_dpis := FA_LOAD_TBL_PKG.deprn_table(i).start_dpis;

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;

Line 94: conv_tbl(i).end_dpis := FA_LOAD_TBL_PKG.deprn_table(i).end_dpis;

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;

Line 95: h_life_in_months := FA_LOAD_TBL_PKG.deprn_table(i).life_in_months;

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;

Line 96: h_basic_rate := FA_LOAD_TBL_PKG.deprn_table(i).basic_rate;

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(

Line 97: h_adjusted_rate := FA_LOAD_TBL_PKG.deprn_table(i).adjusted_rate;

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,

Line 98: h_allowed_deprn_limit := FA_LOAD_TBL_PKG.deprn_table(i).allow_deprn_limit;

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,

Line 99: h_percent_salvage_val := FA_LOAD_TBL_PKG.deprn_table(i).percent_salvage_value;

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,