DBA Data[Home] [Help]

APPS.FA_MASS_REC_UTILS_PKG dependencies on FA_LOAD_TBL_PKG

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

75: h_adjusted_rate NUMBER;
76: h_allowed_deprn_limit NUMBER;
77: h_percent_salvage_val NUMBER;
78: BEGIN
79: IF (FA_LOAD_TBL_PKG.g_deprn_count = 0) THEN
80: -- deprn_table is not loaded. deprn_table has to be loaded first.
81: raise load_exc;
82: END IF;
83:

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

83:
84: -- Initialize conversion_table.
85: conv_tbl.delete;
86:
87: FOR i IN FA_LOAD_TBL_PKG.deprn_table.FIRST .. FA_LOAD_TBL_PKG.deprn_table.LAST
88: LOOP
89: IF FA_LOAD_TBL_PKG.deprn_table.exists(i) THEN
90: -- Load into exactly same matching index postion.
91: conv_tbl(i).book_type_code := FA_LOAD_TBL_PKG.deprn_table(i).book_type_code;

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

85: conv_tbl.delete;
86:
87: FOR i IN FA_LOAD_TBL_PKG.deprn_table.FIRST .. FA_LOAD_TBL_PKG.deprn_table.LAST
88: LOOP
89: IF FA_LOAD_TBL_PKG.deprn_table.exists(i) THEN
90: -- Load into exactly same matching index postion.
91: conv_tbl(i).book_type_code := FA_LOAD_TBL_PKG.deprn_table(i).book_type_code;
92: conv_tbl(i).start_dpis := FA_LOAD_TBL_PKG.deprn_table(i).start_dpis;
93: conv_tbl(i).end_dpis := FA_LOAD_TBL_PKG.deprn_table(i).end_dpis;

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

87: FOR i IN FA_LOAD_TBL_PKG.deprn_table.FIRST .. FA_LOAD_TBL_PKG.deprn_table.LAST
88: LOOP
89: IF FA_LOAD_TBL_PKG.deprn_table.exists(i) THEN
90: -- Load into exactly same matching index postion.
91: conv_tbl(i).book_type_code := FA_LOAD_TBL_PKG.deprn_table(i).book_type_code;
92: conv_tbl(i).start_dpis := FA_LOAD_TBL_PKG.deprn_table(i).start_dpis;
93: conv_tbl(i).end_dpis := FA_LOAD_TBL_PKG.deprn_table(i).end_dpis;
94: h_life_in_months := FA_LOAD_TBL_PKG.deprn_table(i).life_in_months;
95: h_basic_rate := FA_LOAD_TBL_PKG.deprn_table(i).basic_rate;

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

88: LOOP
89: IF FA_LOAD_TBL_PKG.deprn_table.exists(i) THEN
90: -- Load into exactly same matching index postion.
91: conv_tbl(i).book_type_code := FA_LOAD_TBL_PKG.deprn_table(i).book_type_code;
92: conv_tbl(i).start_dpis := FA_LOAD_TBL_PKG.deprn_table(i).start_dpis;
93: conv_tbl(i).end_dpis := FA_LOAD_TBL_PKG.deprn_table(i).end_dpis;
94: h_life_in_months := FA_LOAD_TBL_PKG.deprn_table(i).life_in_months;
95: h_basic_rate := FA_LOAD_TBL_PKG.deprn_table(i).basic_rate;
96: h_adjusted_rate := FA_LOAD_TBL_PKG.deprn_table(i).adjusted_rate;

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

89: IF FA_LOAD_TBL_PKG.deprn_table.exists(i) THEN
90: -- Load into exactly same matching index postion.
91: conv_tbl(i).book_type_code := FA_LOAD_TBL_PKG.deprn_table(i).book_type_code;
92: conv_tbl(i).start_dpis := FA_LOAD_TBL_PKG.deprn_table(i).start_dpis;
93: conv_tbl(i).end_dpis := FA_LOAD_TBL_PKG.deprn_table(i).end_dpis;
94: h_life_in_months := FA_LOAD_TBL_PKG.deprn_table(i).life_in_months;
95: h_basic_rate := FA_LOAD_TBL_PKG.deprn_table(i).basic_rate;
96: h_adjusted_rate := FA_LOAD_TBL_PKG.deprn_table(i).adjusted_rate;
97: h_allowed_deprn_limit := FA_LOAD_TBL_PKG.deprn_table(i).allow_deprn_limit;

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

90: -- Load into exactly same matching index postion.
91: conv_tbl(i).book_type_code := FA_LOAD_TBL_PKG.deprn_table(i).book_type_code;
92: conv_tbl(i).start_dpis := FA_LOAD_TBL_PKG.deprn_table(i).start_dpis;
93: conv_tbl(i).end_dpis := FA_LOAD_TBL_PKG.deprn_table(i).end_dpis;
94: h_life_in_months := FA_LOAD_TBL_PKG.deprn_table(i).life_in_months;
95: h_basic_rate := FA_LOAD_TBL_PKG.deprn_table(i).basic_rate;
96: h_adjusted_rate := FA_LOAD_TBL_PKG.deprn_table(i).adjusted_rate;
97: h_allowed_deprn_limit := FA_LOAD_TBL_PKG.deprn_table(i).allow_deprn_limit;
98: h_percent_salvage_val := FA_LOAD_TBL_PKG.deprn_table(i).percent_salvage_value;

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

91: conv_tbl(i).book_type_code := FA_LOAD_TBL_PKG.deprn_table(i).book_type_code;
92: conv_tbl(i).start_dpis := FA_LOAD_TBL_PKG.deprn_table(i).start_dpis;
93: conv_tbl(i).end_dpis := FA_LOAD_TBL_PKG.deprn_table(i).end_dpis;
94: h_life_in_months := FA_LOAD_TBL_PKG.deprn_table(i).life_in_months;
95: h_basic_rate := FA_LOAD_TBL_PKG.deprn_table(i).basic_rate;
96: h_adjusted_rate := FA_LOAD_TBL_PKG.deprn_table(i).adjusted_rate;
97: h_allowed_deprn_limit := FA_LOAD_TBL_PKG.deprn_table(i).allow_deprn_limit;
98: h_percent_salvage_val := FA_LOAD_TBL_PKG.deprn_table(i).percent_salvage_value;
99: Convert_Formats(

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

92: conv_tbl(i).start_dpis := FA_LOAD_TBL_PKG.deprn_table(i).start_dpis;
93: conv_tbl(i).end_dpis := FA_LOAD_TBL_PKG.deprn_table(i).end_dpis;
94: h_life_in_months := FA_LOAD_TBL_PKG.deprn_table(i).life_in_months;
95: h_basic_rate := FA_LOAD_TBL_PKG.deprn_table(i).basic_rate;
96: h_adjusted_rate := FA_LOAD_TBL_PKG.deprn_table(i).adjusted_rate;
97: h_allowed_deprn_limit := FA_LOAD_TBL_PKG.deprn_table(i).allow_deprn_limit;
98: h_percent_salvage_val := FA_LOAD_TBL_PKG.deprn_table(i).percent_salvage_value;
99: Convert_Formats(
100: X_Life_In_Months => h_life_in_months,

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

93: conv_tbl(i).end_dpis := FA_LOAD_TBL_PKG.deprn_table(i).end_dpis;
94: h_life_in_months := FA_LOAD_TBL_PKG.deprn_table(i).life_in_months;
95: h_basic_rate := FA_LOAD_TBL_PKG.deprn_table(i).basic_rate;
96: h_adjusted_rate := FA_LOAD_TBL_PKG.deprn_table(i).adjusted_rate;
97: h_allowed_deprn_limit := FA_LOAD_TBL_PKG.deprn_table(i).allow_deprn_limit;
98: h_percent_salvage_val := FA_LOAD_TBL_PKG.deprn_table(i).percent_salvage_value;
99: Convert_Formats(
100: X_Life_In_Months => h_life_in_months,
101: X_Basic_Rate => h_basic_rate,

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

94: h_life_in_months := FA_LOAD_TBL_PKG.deprn_table(i).life_in_months;
95: h_basic_rate := FA_LOAD_TBL_PKG.deprn_table(i).basic_rate;
96: h_adjusted_rate := FA_LOAD_TBL_PKG.deprn_table(i).adjusted_rate;
97: h_allowed_deprn_limit := FA_LOAD_TBL_PKG.deprn_table(i).allow_deprn_limit;
98: h_percent_salvage_val := FA_LOAD_TBL_PKG.deprn_table(i).percent_salvage_value;
99: Convert_Formats(
100: X_Life_In_Months => h_life_in_months,
101: X_Basic_Rate => h_basic_rate,
102: X_Adjusted_Rate => h_adjusted_rate,