DBA Data[Home] [Help]

APPS.FA_WHATIF_DEPRN2_PKG dependencies on FA_WHATIF_DEPRN_PKG

Line 137: fa_whatif_deprn_pkg.t_request_id.delete;

133: --fa_rx_conc_mesg_pkg.log('IN HERE IN HERE 1');
134:
135: ret := TRUE;
136:
137: fa_whatif_deprn_pkg.t_request_id.delete;
138: fa_whatif_deprn_pkg.t_book_type_code.delete;
139: fa_whatif_deprn_pkg.t_asset_id.delete;
140: fa_whatif_deprn_pkg.t_asset_number.delete;
141: fa_whatif_deprn_pkg.t_description.delete;

Line 138: fa_whatif_deprn_pkg.t_book_type_code.delete;

134:
135: ret := TRUE;
136:
137: fa_whatif_deprn_pkg.t_request_id.delete;
138: fa_whatif_deprn_pkg.t_book_type_code.delete;
139: fa_whatif_deprn_pkg.t_asset_id.delete;
140: fa_whatif_deprn_pkg.t_asset_number.delete;
141: fa_whatif_deprn_pkg.t_description.delete;
142: fa_whatif_deprn_pkg.t_tag_number.delete;

Line 139: fa_whatif_deprn_pkg.t_asset_id.delete;

135: ret := TRUE;
136:
137: fa_whatif_deprn_pkg.t_request_id.delete;
138: fa_whatif_deprn_pkg.t_book_type_code.delete;
139: fa_whatif_deprn_pkg.t_asset_id.delete;
140: fa_whatif_deprn_pkg.t_asset_number.delete;
141: fa_whatif_deprn_pkg.t_description.delete;
142: fa_whatif_deprn_pkg.t_tag_number.delete;
143: fa_whatif_deprn_pkg.t_serial_number.delete;

Line 140: fa_whatif_deprn_pkg.t_asset_number.delete;

136:
137: fa_whatif_deprn_pkg.t_request_id.delete;
138: fa_whatif_deprn_pkg.t_book_type_code.delete;
139: fa_whatif_deprn_pkg.t_asset_id.delete;
140: fa_whatif_deprn_pkg.t_asset_number.delete;
141: fa_whatif_deprn_pkg.t_description.delete;
142: fa_whatif_deprn_pkg.t_tag_number.delete;
143: fa_whatif_deprn_pkg.t_serial_number.delete;
144: fa_whatif_deprn_pkg.t_period_name.delete;

Line 141: fa_whatif_deprn_pkg.t_description.delete;

137: fa_whatif_deprn_pkg.t_request_id.delete;
138: fa_whatif_deprn_pkg.t_book_type_code.delete;
139: fa_whatif_deprn_pkg.t_asset_id.delete;
140: fa_whatif_deprn_pkg.t_asset_number.delete;
141: fa_whatif_deprn_pkg.t_description.delete;
142: fa_whatif_deprn_pkg.t_tag_number.delete;
143: fa_whatif_deprn_pkg.t_serial_number.delete;
144: fa_whatif_deprn_pkg.t_period_name.delete;
145: fa_whatif_deprn_pkg.t_fiscal_year.delete;

Line 142: fa_whatif_deprn_pkg.t_tag_number.delete;

138: fa_whatif_deprn_pkg.t_book_type_code.delete;
139: fa_whatif_deprn_pkg.t_asset_id.delete;
140: fa_whatif_deprn_pkg.t_asset_number.delete;
141: fa_whatif_deprn_pkg.t_description.delete;
142: fa_whatif_deprn_pkg.t_tag_number.delete;
143: fa_whatif_deprn_pkg.t_serial_number.delete;
144: fa_whatif_deprn_pkg.t_period_name.delete;
145: fa_whatif_deprn_pkg.t_fiscal_year.delete;
146: fa_whatif_deprn_pkg.t_expense_acct.delete;

Line 143: fa_whatif_deprn_pkg.t_serial_number.delete;

139: fa_whatif_deprn_pkg.t_asset_id.delete;
140: fa_whatif_deprn_pkg.t_asset_number.delete;
141: fa_whatif_deprn_pkg.t_description.delete;
142: fa_whatif_deprn_pkg.t_tag_number.delete;
143: fa_whatif_deprn_pkg.t_serial_number.delete;
144: fa_whatif_deprn_pkg.t_period_name.delete;
145: fa_whatif_deprn_pkg.t_fiscal_year.delete;
146: fa_whatif_deprn_pkg.t_expense_acct.delete;
147: fa_whatif_deprn_pkg.t_location.delete;

Line 144: fa_whatif_deprn_pkg.t_period_name.delete;

140: fa_whatif_deprn_pkg.t_asset_number.delete;
141: fa_whatif_deprn_pkg.t_description.delete;
142: fa_whatif_deprn_pkg.t_tag_number.delete;
143: fa_whatif_deprn_pkg.t_serial_number.delete;
144: fa_whatif_deprn_pkg.t_period_name.delete;
145: fa_whatif_deprn_pkg.t_fiscal_year.delete;
146: fa_whatif_deprn_pkg.t_expense_acct.delete;
147: fa_whatif_deprn_pkg.t_location.delete;
148: fa_whatif_deprn_pkg.t_units.delete;

Line 145: fa_whatif_deprn_pkg.t_fiscal_year.delete;

141: fa_whatif_deprn_pkg.t_description.delete;
142: fa_whatif_deprn_pkg.t_tag_number.delete;
143: fa_whatif_deprn_pkg.t_serial_number.delete;
144: fa_whatif_deprn_pkg.t_period_name.delete;
145: fa_whatif_deprn_pkg.t_fiscal_year.delete;
146: fa_whatif_deprn_pkg.t_expense_acct.delete;
147: fa_whatif_deprn_pkg.t_location.delete;
148: fa_whatif_deprn_pkg.t_units.delete;
149: fa_whatif_deprn_pkg.t_employee_name.delete;

Line 146: fa_whatif_deprn_pkg.t_expense_acct.delete;

142: fa_whatif_deprn_pkg.t_tag_number.delete;
143: fa_whatif_deprn_pkg.t_serial_number.delete;
144: fa_whatif_deprn_pkg.t_period_name.delete;
145: fa_whatif_deprn_pkg.t_fiscal_year.delete;
146: fa_whatif_deprn_pkg.t_expense_acct.delete;
147: fa_whatif_deprn_pkg.t_location.delete;
148: fa_whatif_deprn_pkg.t_units.delete;
149: fa_whatif_deprn_pkg.t_employee_name.delete;
150: fa_whatif_deprn_pkg.t_employee_number.delete;

Line 147: fa_whatif_deprn_pkg.t_location.delete;

143: fa_whatif_deprn_pkg.t_serial_number.delete;
144: fa_whatif_deprn_pkg.t_period_name.delete;
145: fa_whatif_deprn_pkg.t_fiscal_year.delete;
146: fa_whatif_deprn_pkg.t_expense_acct.delete;
147: fa_whatif_deprn_pkg.t_location.delete;
148: fa_whatif_deprn_pkg.t_units.delete;
149: fa_whatif_deprn_pkg.t_employee_name.delete;
150: fa_whatif_deprn_pkg.t_employee_number.delete;
151: fa_whatif_deprn_pkg.t_asset_key.delete;

Line 148: fa_whatif_deprn_pkg.t_units.delete;

144: fa_whatif_deprn_pkg.t_period_name.delete;
145: fa_whatif_deprn_pkg.t_fiscal_year.delete;
146: fa_whatif_deprn_pkg.t_expense_acct.delete;
147: fa_whatif_deprn_pkg.t_location.delete;
148: fa_whatif_deprn_pkg.t_units.delete;
149: fa_whatif_deprn_pkg.t_employee_name.delete;
150: fa_whatif_deprn_pkg.t_employee_number.delete;
151: fa_whatif_deprn_pkg.t_asset_key.delete;
152: fa_whatif_deprn_pkg.t_current_cost.delete;

Line 149: fa_whatif_deprn_pkg.t_employee_name.delete;

145: fa_whatif_deprn_pkg.t_fiscal_year.delete;
146: fa_whatif_deprn_pkg.t_expense_acct.delete;
147: fa_whatif_deprn_pkg.t_location.delete;
148: fa_whatif_deprn_pkg.t_units.delete;
149: fa_whatif_deprn_pkg.t_employee_name.delete;
150: fa_whatif_deprn_pkg.t_employee_number.delete;
151: fa_whatif_deprn_pkg.t_asset_key.delete;
152: fa_whatif_deprn_pkg.t_current_cost.delete;
153: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;

Line 150: fa_whatif_deprn_pkg.t_employee_number.delete;

146: fa_whatif_deprn_pkg.t_expense_acct.delete;
147: fa_whatif_deprn_pkg.t_location.delete;
148: fa_whatif_deprn_pkg.t_units.delete;
149: fa_whatif_deprn_pkg.t_employee_name.delete;
150: fa_whatif_deprn_pkg.t_employee_number.delete;
151: fa_whatif_deprn_pkg.t_asset_key.delete;
152: fa_whatif_deprn_pkg.t_current_cost.delete;
153: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
154: fa_whatif_deprn_pkg.t_current_method.delete;

Line 151: fa_whatif_deprn_pkg.t_asset_key.delete;

147: fa_whatif_deprn_pkg.t_location.delete;
148: fa_whatif_deprn_pkg.t_units.delete;
149: fa_whatif_deprn_pkg.t_employee_name.delete;
150: fa_whatif_deprn_pkg.t_employee_number.delete;
151: fa_whatif_deprn_pkg.t_asset_key.delete;
152: fa_whatif_deprn_pkg.t_current_cost.delete;
153: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
154: fa_whatif_deprn_pkg.t_current_method.delete;
155: fa_whatif_deprn_pkg.t_current_life.delete;

Line 152: fa_whatif_deprn_pkg.t_current_cost.delete;

148: fa_whatif_deprn_pkg.t_units.delete;
149: fa_whatif_deprn_pkg.t_employee_name.delete;
150: fa_whatif_deprn_pkg.t_employee_number.delete;
151: fa_whatif_deprn_pkg.t_asset_key.delete;
152: fa_whatif_deprn_pkg.t_current_cost.delete;
153: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
154: fa_whatif_deprn_pkg.t_current_method.delete;
155: fa_whatif_deprn_pkg.t_current_life.delete;
156: fa_whatif_deprn_pkg.t_current_basic_rate.delete;

Line 153: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;

149: fa_whatif_deprn_pkg.t_employee_name.delete;
150: fa_whatif_deprn_pkg.t_employee_number.delete;
151: fa_whatif_deprn_pkg.t_asset_key.delete;
152: fa_whatif_deprn_pkg.t_current_cost.delete;
153: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
154: fa_whatif_deprn_pkg.t_current_method.delete;
155: fa_whatif_deprn_pkg.t_current_life.delete;
156: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
157: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;

Line 154: fa_whatif_deprn_pkg.t_current_method.delete;

150: fa_whatif_deprn_pkg.t_employee_number.delete;
151: fa_whatif_deprn_pkg.t_asset_key.delete;
152: fa_whatif_deprn_pkg.t_current_cost.delete;
153: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
154: fa_whatif_deprn_pkg.t_current_method.delete;
155: fa_whatif_deprn_pkg.t_current_life.delete;
156: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
157: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
158: fa_whatif_deprn_pkg.t_current_salvage_value.delete;

Line 155: fa_whatif_deprn_pkg.t_current_life.delete;

151: fa_whatif_deprn_pkg.t_asset_key.delete;
152: fa_whatif_deprn_pkg.t_current_cost.delete;
153: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
154: fa_whatif_deprn_pkg.t_current_method.delete;
155: fa_whatif_deprn_pkg.t_current_life.delete;
156: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
157: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
158: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
159: fa_whatif_deprn_pkg.t_depreciation.delete;

Line 156: fa_whatif_deprn_pkg.t_current_basic_rate.delete;

152: fa_whatif_deprn_pkg.t_current_cost.delete;
153: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
154: fa_whatif_deprn_pkg.t_current_method.delete;
155: fa_whatif_deprn_pkg.t_current_life.delete;
156: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
157: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
158: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
159: fa_whatif_deprn_pkg.t_depreciation.delete;
160: fa_whatif_deprn_pkg.t_new_depreciation.delete;

Line 157: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;

153: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
154: fa_whatif_deprn_pkg.t_current_method.delete;
155: fa_whatif_deprn_pkg.t_current_life.delete;
156: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
157: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
158: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
159: fa_whatif_deprn_pkg.t_depreciation.delete;
160: fa_whatif_deprn_pkg.t_new_depreciation.delete;
161: fa_whatif_deprn_pkg.t_created_by.delete;

Line 158: fa_whatif_deprn_pkg.t_current_salvage_value.delete;

154: fa_whatif_deprn_pkg.t_current_method.delete;
155: fa_whatif_deprn_pkg.t_current_life.delete;
156: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
157: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
158: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
159: fa_whatif_deprn_pkg.t_depreciation.delete;
160: fa_whatif_deprn_pkg.t_new_depreciation.delete;
161: fa_whatif_deprn_pkg.t_created_by.delete;
162: fa_whatif_deprn_pkg.t_creation_date.delete;

Line 159: fa_whatif_deprn_pkg.t_depreciation.delete;

155: fa_whatif_deprn_pkg.t_current_life.delete;
156: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
157: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
158: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
159: fa_whatif_deprn_pkg.t_depreciation.delete;
160: fa_whatif_deprn_pkg.t_new_depreciation.delete;
161: fa_whatif_deprn_pkg.t_created_by.delete;
162: fa_whatif_deprn_pkg.t_creation_date.delete;
163: fa_whatif_deprn_pkg.t_last_update_date.delete;

Line 160: fa_whatif_deprn_pkg.t_new_depreciation.delete;

156: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
157: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
158: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
159: fa_whatif_deprn_pkg.t_depreciation.delete;
160: fa_whatif_deprn_pkg.t_new_depreciation.delete;
161: fa_whatif_deprn_pkg.t_created_by.delete;
162: fa_whatif_deprn_pkg.t_creation_date.delete;
163: fa_whatif_deprn_pkg.t_last_update_date.delete;
164: fa_whatif_deprn_pkg.t_last_updated_by.delete;

Line 161: fa_whatif_deprn_pkg.t_created_by.delete;

157: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
158: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
159: fa_whatif_deprn_pkg.t_depreciation.delete;
160: fa_whatif_deprn_pkg.t_new_depreciation.delete;
161: fa_whatif_deprn_pkg.t_created_by.delete;
162: fa_whatif_deprn_pkg.t_creation_date.delete;
163: fa_whatif_deprn_pkg.t_last_update_date.delete;
164: fa_whatif_deprn_pkg.t_last_updated_by.delete;
165: fa_whatif_deprn_pkg.t_last_update_login.delete;

Line 162: fa_whatif_deprn_pkg.t_creation_date.delete;

158: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
159: fa_whatif_deprn_pkg.t_depreciation.delete;
160: fa_whatif_deprn_pkg.t_new_depreciation.delete;
161: fa_whatif_deprn_pkg.t_created_by.delete;
162: fa_whatif_deprn_pkg.t_creation_date.delete;
163: fa_whatif_deprn_pkg.t_last_update_date.delete;
164: fa_whatif_deprn_pkg.t_last_updated_by.delete;
165: fa_whatif_deprn_pkg.t_last_update_login.delete;
166: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;

Line 163: fa_whatif_deprn_pkg.t_last_update_date.delete;

159: fa_whatif_deprn_pkg.t_depreciation.delete;
160: fa_whatif_deprn_pkg.t_new_depreciation.delete;
161: fa_whatif_deprn_pkg.t_created_by.delete;
162: fa_whatif_deprn_pkg.t_creation_date.delete;
163: fa_whatif_deprn_pkg.t_last_update_date.delete;
164: fa_whatif_deprn_pkg.t_last_updated_by.delete;
165: fa_whatif_deprn_pkg.t_last_update_login.delete;
166: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
167: fa_whatif_deprn_pkg.t_category.delete;

Line 164: fa_whatif_deprn_pkg.t_last_updated_by.delete;

160: fa_whatif_deprn_pkg.t_new_depreciation.delete;
161: fa_whatif_deprn_pkg.t_created_by.delete;
162: fa_whatif_deprn_pkg.t_creation_date.delete;
163: fa_whatif_deprn_pkg.t_last_update_date.delete;
164: fa_whatif_deprn_pkg.t_last_updated_by.delete;
165: fa_whatif_deprn_pkg.t_last_update_login.delete;
166: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
167: fa_whatif_deprn_pkg.t_category.delete;
168: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;

Line 165: fa_whatif_deprn_pkg.t_last_update_login.delete;

161: fa_whatif_deprn_pkg.t_created_by.delete;
162: fa_whatif_deprn_pkg.t_creation_date.delete;
163: fa_whatif_deprn_pkg.t_last_update_date.delete;
164: fa_whatif_deprn_pkg.t_last_updated_by.delete;
165: fa_whatif_deprn_pkg.t_last_update_login.delete;
166: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
167: fa_whatif_deprn_pkg.t_category.delete;
168: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
169: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;

Line 166: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;

162: fa_whatif_deprn_pkg.t_creation_date.delete;
163: fa_whatif_deprn_pkg.t_last_update_date.delete;
164: fa_whatif_deprn_pkg.t_last_updated_by.delete;
165: fa_whatif_deprn_pkg.t_last_update_login.delete;
166: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
167: fa_whatif_deprn_pkg.t_category.delete;
168: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
169: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
170: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;

Line 167: fa_whatif_deprn_pkg.t_category.delete;

163: fa_whatif_deprn_pkg.t_last_update_date.delete;
164: fa_whatif_deprn_pkg.t_last_updated_by.delete;
165: fa_whatif_deprn_pkg.t_last_update_login.delete;
166: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
167: fa_whatif_deprn_pkg.t_category.delete;
168: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
169: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
170: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
171: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;

Line 168: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;

164: fa_whatif_deprn_pkg.t_last_updated_by.delete;
165: fa_whatif_deprn_pkg.t_last_update_login.delete;
166: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
167: fa_whatif_deprn_pkg.t_category.delete;
168: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
169: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
170: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
171: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
172: fa_whatif_deprn_pkg.t_period_num.delete;

Line 169: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;

165: fa_whatif_deprn_pkg.t_last_update_login.delete;
166: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
167: fa_whatif_deprn_pkg.t_category.delete;
168: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
169: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
170: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
171: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
172: fa_whatif_deprn_pkg.t_period_num.delete;
173: fa_whatif_deprn_pkg.t_currency_code.delete;

Line 170: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;

166: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
167: fa_whatif_deprn_pkg.t_category.delete;
168: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
169: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
170: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
171: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
172: fa_whatif_deprn_pkg.t_period_num.delete;
173: fa_whatif_deprn_pkg.t_currency_code.delete;
174:

Line 171: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;

167: fa_whatif_deprn_pkg.t_category.delete;
168: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
169: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
170: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
171: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
172: fa_whatif_deprn_pkg.t_period_num.delete;
173: fa_whatif_deprn_pkg.t_currency_code.delete;
174:
175: if (X_exp_amt = 'YES') then X_exp_amt := 'AMORTIZED';

Line 172: fa_whatif_deprn_pkg.t_period_num.delete;

168: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
169: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
170: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
171: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
172: fa_whatif_deprn_pkg.t_period_num.delete;
173: fa_whatif_deprn_pkg.t_currency_code.delete;
174:
175: if (X_exp_amt = 'YES') then X_exp_amt := 'AMORTIZED';
176: elsif (X_exp_amt = 'NO') then X_exp_amt := 'EXPENSED';

Line 173: fa_whatif_deprn_pkg.t_currency_code.delete;

169: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
170: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
171: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
172: fa_whatif_deprn_pkg.t_period_num.delete;
173: fa_whatif_deprn_pkg.t_currency_code.delete;
174:
175: if (X_exp_amt = 'YES') then X_exp_amt := 'AMORTIZED';
176: elsif (X_exp_amt = 'NO') then X_exp_amt := 'EXPENSED';
177: end if;

Line 274: -- STORES RESULTS IN FA_WHATIF_DEPRN_PKG.G_DEPRN

270:
271: if h_count >= X_num_assets then exit; end if;
272:
273: -- RUN IN NORMAL MODE TO GET DEPRN GIVEN CURRENT STATE
274: -- STORES RESULTS IN FA_WHATIF_DEPRN_PKG.G_DEPRN
275:
276: h_mesg_name := 'FA_WHATIF_ASSET_NORMAL_MODE';
277:
278: ret := fa_whatif_deprn_pkg.whatif_deprn_asset (

Line 278: ret := fa_whatif_deprn_pkg.whatif_deprn_asset (

274: -- STORES RESULTS IN FA_WHATIF_DEPRN_PKG.G_DEPRN
275:
276: h_mesg_name := 'FA_WHATIF_ASSET_NORMAL_MODE';
277:
278: ret := fa_whatif_deprn_pkg.whatif_deprn_asset (
279: X_asset_id => X_assets(h_count),
280: X_mode => 'NORMAL',
281: X_book => X_book,
282: X_start_per => X_start_per,

Line 318: fa_whatif_deprn_pkg.g_deprn.delete;

314:
315: if (ret = FALSE) then
316: retcode := 2;
317:
318: fa_whatif_deprn_pkg.g_deprn.delete;
319: fnd_message.set_name('OFA','FA_WHATIF_ASSET_NORMAL_MODE');
320: fnd_message.set_token('ASSET_ID',X_assets(h_count),FALSE);
321: h_mesg_str := fnd_message.get;
322: fa_rx_conc_mesg_pkg.log(h_mesg_str);

Line 328: -- STORES RESULTS IN FA_WHATIF_DEPRN_PKG.G_DEPRN

324: end if;
325:
326:
327: -- RUN IN EXPENSED/AMORTIZED MODE TO GET DEPRN IN ADJUSTED STATE
328: -- STORES RESULTS IN FA_WHATIF_DEPRN_PKG.G_DEPRN
329:
330: h_mesg_name := 'FA_WHATIF_ASSET_ADJ_MODE';
331:
332: if (X_prorate_conv is not null) or

Line 340: ret := fa_whatif_deprn_pkg.whatif_deprn_asset (

336: (X_life is not null) or
337: (X_salvage_pct is not null) then
338: --tk_util.debug('Processing');
339:
340: ret := fa_whatif_deprn_pkg.whatif_deprn_asset (
341: X_asset_id => X_assets(h_count),
342: X_mode => X_exp_amt,
343: X_book => X_book,
344: X_start_per => X_start_per,

Line 380: fa_whatif_deprn_pkg.g_deprn.delete;

376:
377: if (ret = FALSE) then
378: retcode := 2;
379:
380: fa_whatif_deprn_pkg.g_deprn.delete;
381: fnd_message.set_name('OFA','FA_WHATIF_ASSET_ADJ_MODE');
382: fnd_message.set_token('ASSET_ID',X_assets(h_count),FALSE);
383: h_mesg_str := fnd_message.get;
384: fa_rx_conc_mesg_pkg.log(h_mesg_str);

Line 395: ret := fa_whatif_deprn_pkg.whatif_insert_itf (

391:
392: h_mesg_name := 'FA_WHATIF_ASSET_COMMIT';
393:
394: --tk_util.debug('h_count:X_num_assets: '||to_char(h_count)||':'||to_char(X_num_assets));
395: ret := fa_whatif_deprn_pkg.whatif_insert_itf (
396: X_asset_id => X_assets(h_count),
397: X_book => X_book,
398: X_request_id => X_request_id,
399: X_num_pers => X_num_per,

Line 415: fa_whatif_deprn_pkg.g_deprn.delete;

411: -- X_seg_table => seg_table,
412: if (ret = FALSE) then
413: retcode := 2;
414:
415: fa_whatif_deprn_pkg.g_deprn.delete;
416: fnd_message.set_name('OFA','FA_WHATIF_ASSET_COMMIT');
417: fnd_message.set_token('ASSET_ID',X_assets(h_count),FALSE);
418: h_mesg_str := fnd_message.get;
419: fa_rx_conc_mesg_pkg.log(h_mesg_str);

Line 431: ret := fa_whatif_deprn_pkg.whatif_deprn_asset (

427: -- HYPOTHETICAL ASSET
428:
429: --fa_rx_conc_mesg_pkg.log('IN HERE IN HERE');
430:
431: ret := fa_whatif_deprn_pkg.whatif_deprn_asset (
432: X_asset_id => 0,
433: X_mode => 'HYPOTHETICAL',
434: X_book => X_book,
435: X_start_per => X_start_per,

Line 473: fa_whatif_deprn_pkg.g_deprn.delete;

469:
470: if (ret = FALSE) then
471: retcode := 2;
472:
473: fa_whatif_deprn_pkg.g_deprn.delete;
474: fnd_message.set_name('OFA','FA_WHATIF_ASSET_NORMAL_MODE');
475: h_mesg_str := fnd_message.get;
476: fa_rx_conc_mesg_pkg.log(h_mesg_str);
477: return (FALSE);

Line 524: fa_whatif_deprn_pkg.g_deprn(h_count).period_name,

520: last_updated_by, last_update_login,category,date_placed_in_service,
521: accumulated_deprn,currency_code
522: ) values (
523: X_request_id, NULL, NULL, NULL, NULL, NULL,
524: fa_whatif_deprn_pkg.g_deprn(h_count).period_name,
525: fa_whatif_deprn_pkg.g_deprn(h_count).fiscal_year, NULL,
526: fa_whatif_deprn_pkg.g_deprn(h_count).deprn,
527: fa_whatif_deprn_pkg.g_deprn(h_count).new_deprn,
528: NULL, NULL, NULL, NULL,

Line 525: fa_whatif_deprn_pkg.g_deprn(h_count).fiscal_year, NULL,

521: accumulated_deprn,currency_code
522: ) values (
523: X_request_id, NULL, NULL, NULL, NULL, NULL,
524: fa_whatif_deprn_pkg.g_deprn(h_count).period_name,
525: fa_whatif_deprn_pkg.g_deprn(h_count).fiscal_year, NULL,
526: fa_whatif_deprn_pkg.g_deprn(h_count).deprn,
527: fa_whatif_deprn_pkg.g_deprn(h_count).new_deprn,
528: NULL, NULL, NULL, NULL,
529: NULL, X_cost, X_prorate_conv, X_method,

Line 526: fa_whatif_deprn_pkg.g_deprn(h_count).deprn,

522: ) values (
523: X_request_id, NULL, NULL, NULL, NULL, NULL,
524: fa_whatif_deprn_pkg.g_deprn(h_count).period_name,
525: fa_whatif_deprn_pkg.g_deprn(h_count).fiscal_year, NULL,
526: fa_whatif_deprn_pkg.g_deprn(h_count).deprn,
527: fa_whatif_deprn_pkg.g_deprn(h_count).new_deprn,
528: NULL, NULL, NULL, NULL,
529: NULL, X_cost, X_prorate_conv, X_method,
530: X_life, h_basic_rate, X_adjusted_rate, h_sal,

Line 527: fa_whatif_deprn_pkg.g_deprn(h_count).new_deprn,

523: X_request_id, NULL, NULL, NULL, NULL, NULL,
524: fa_whatif_deprn_pkg.g_deprn(h_count).period_name,
525: fa_whatif_deprn_pkg.g_deprn(h_count).fiscal_year, NULL,
526: fa_whatif_deprn_pkg.g_deprn(h_count).deprn,
527: fa_whatif_deprn_pkg.g_deprn(h_count).new_deprn,
528: NULL, NULL, NULL, NULL,
529: NULL, X_cost, X_prorate_conv, X_method,
530: X_life, h_basic_rate, X_adjusted_rate, h_sal,
531: fa_whatif_deprn_pkg.g_deprn(h_count).bonus_deprn,

Line 531: fa_whatif_deprn_pkg.g_deprn(h_count).bonus_deprn,

527: fa_whatif_deprn_pkg.g_deprn(h_count).new_deprn,
528: NULL, NULL, NULL, NULL,
529: NULL, X_cost, X_prorate_conv, X_method,
530: X_life, h_basic_rate, X_adjusted_rate, h_sal,
531: fa_whatif_deprn_pkg.g_deprn(h_count).bonus_deprn,
532: fa_whatif_deprn_pkg.g_deprn(h_count).new_bonus_deprn,
533: X_user_id, sysdate, sysdate, X_user_id, h_login_id,
534: h_concat_str, X_dpis,
535: fa_whatif_deprn_pkg.g_deprn(h_count).new_rsv,h_currency);

Line 532: fa_whatif_deprn_pkg.g_deprn(h_count).new_bonus_deprn,

528: NULL, NULL, NULL, NULL,
529: NULL, X_cost, X_prorate_conv, X_method,
530: X_life, h_basic_rate, X_adjusted_rate, h_sal,
531: fa_whatif_deprn_pkg.g_deprn(h_count).bonus_deprn,
532: fa_whatif_deprn_pkg.g_deprn(h_count).new_bonus_deprn,
533: X_user_id, sysdate, sysdate, X_user_id, h_login_id,
534: h_concat_str, X_dpis,
535: fa_whatif_deprn_pkg.g_deprn(h_count).new_rsv,h_currency);
536:

Line 535: fa_whatif_deprn_pkg.g_deprn(h_count).new_rsv,h_currency);

531: fa_whatif_deprn_pkg.g_deprn(h_count).bonus_deprn,
532: fa_whatif_deprn_pkg.g_deprn(h_count).new_bonus_deprn,
533: X_user_id, sysdate, sysdate, X_user_id, h_login_id,
534: h_concat_str, X_dpis,
535: fa_whatif_deprn_pkg.g_deprn(h_count).new_rsv,h_currency);
536:
537: h_count := h_count + 1;
538: end loop;
539:

Line 542: fa_whatif_deprn_pkg.g_deprn.delete;

538: end loop;
539:
540: end if;
541:
542: fa_whatif_deprn_pkg.g_deprn.delete;
543:
544: errbuf := '';
545: return ret;
546:

Line 553: fa_whatif_deprn_pkg.g_deprn.delete;

549: if SQLCODE <> 0 then
550: fa_Rx_conc_mesg_pkg.log(SQLERRM);
551: end if;
552:
553: fa_whatif_deprn_pkg.g_deprn.delete;
554: fnd_message.set_name('OFA',h_mesg_name);
555: if h_mesg_name like 'FA_WHATIF_ASSET%' then
556: fnd_message.set_token('ASSET_ID',X_assets(h_count),FALSE);
557: end if;