eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_CO_FA_ACCOUNTING_PKG dependencies on FA_ADJUSTMENTS

Line 21: x_last_updated_by jl_co_fa_adjustments.last_updated_by%TYPE ;

17: -----------------------------------------------------------------------------
18: -- Variables corresponding to Who columns --
19: -----------------------------------------------------------------------------
20:
21: x_last_updated_by jl_co_fa_adjustments.last_updated_by%TYPE ;
22: x_last_update_login jl_co_fa_adjustments.last_update_login%TYPE;
23: x_request_id jl_co_fa_adjustments.request_id%TYPE;
24: x_program_application_id jl_co_fa_adjustments.program_application_id%TYPE;
25: x_program_id jl_co_fa_adjustments.program_id%TYPE;

Line 22: x_last_update_login jl_co_fa_adjustments.last_update_login%TYPE;

18: -- Variables corresponding to Who columns --
19: -----------------------------------------------------------------------------
20:
21: x_last_updated_by jl_co_fa_adjustments.last_updated_by%TYPE ;
22: x_last_update_login jl_co_fa_adjustments.last_update_login%TYPE;
23: x_request_id jl_co_fa_adjustments.request_id%TYPE;
24: x_program_application_id jl_co_fa_adjustments.program_application_id%TYPE;
25: x_program_id jl_co_fa_adjustments.program_id%TYPE;
26: x_sysdate date;

Line 23: x_request_id jl_co_fa_adjustments.request_id%TYPE;

19: -----------------------------------------------------------------------------
20:
21: x_last_updated_by jl_co_fa_adjustments.last_updated_by%TYPE ;
22: x_last_update_login jl_co_fa_adjustments.last_update_login%TYPE;
23: x_request_id jl_co_fa_adjustments.request_id%TYPE;
24: x_program_application_id jl_co_fa_adjustments.program_application_id%TYPE;
25: x_program_id jl_co_fa_adjustments.program_id%TYPE;
26: x_sysdate date;
27:

Line 24: x_program_application_id jl_co_fa_adjustments.program_application_id%TYPE;

20:
21: x_last_updated_by jl_co_fa_adjustments.last_updated_by%TYPE ;
22: x_last_update_login jl_co_fa_adjustments.last_update_login%TYPE;
23: x_request_id jl_co_fa_adjustments.request_id%TYPE;
24: x_program_application_id jl_co_fa_adjustments.program_application_id%TYPE;
25: x_program_id jl_co_fa_adjustments.program_id%TYPE;
26: x_sysdate date;
27:
28: -----------------------------------------------------------------------------

Line 25: x_program_id jl_co_fa_adjustments.program_id%TYPE;

21: x_last_updated_by jl_co_fa_adjustments.last_updated_by%TYPE ;
22: x_last_update_login jl_co_fa_adjustments.last_update_login%TYPE;
23: x_request_id jl_co_fa_adjustments.request_id%TYPE;
24: x_program_application_id jl_co_fa_adjustments.program_application_id%TYPE;
25: x_program_id jl_co_fa_adjustments.program_id%TYPE;
26: x_sysdate date;
27:
28: -----------------------------------------------------------------------------
29: -- PROCEDURE --

Line 178: -- Name of the accounts used in JL_CO_FA_ADJUSTMENTS.ADJUSTMENT_TYPE --

174: x_concat_segs VARCHAR2(240);
175: x_return_value NUMBER;
176:
177: -----------------------------------------------------------------------------
178: -- Name of the accounts used in JL_CO_FA_ADJUSTMENTS.ADJUSTMENT_TYPE --
179: -----------------------------------------------------------------------------
180:
181: x_cost_name fa_adjustments.adjustment_type%TYPE := 'COST';
182: x_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'CIP COST';

Line 181: x_cost_name fa_adjustments.adjustment_type%TYPE := 'COST';

177: -----------------------------------------------------------------------------
178: -- Name of the accounts used in JL_CO_FA_ADJUSTMENTS.ADJUSTMENT_TYPE --
179: -----------------------------------------------------------------------------
180:
181: x_cost_name fa_adjustments.adjustment_type%TYPE := 'COST';
182: x_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'CIP COST';
183: x_reserve_name fa_adjustments.adjustment_type%TYPE := 'RESERVE';
184: x_expense_name fa_adjustments.adjustment_type%TYPE := 'EXPENSE';
185: x_nbv_retired_name fa_adjustments.adjustment_type%TYPE := 'NBV RETIRED';

Line 182: x_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'CIP COST';

178: -- Name of the accounts used in JL_CO_FA_ADJUSTMENTS.ADJUSTMENT_TYPE --
179: -----------------------------------------------------------------------------
180:
181: x_cost_name fa_adjustments.adjustment_type%TYPE := 'COST';
182: x_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'CIP COST';
183: x_reserve_name fa_adjustments.adjustment_type%TYPE := 'RESERVE';
184: x_expense_name fa_adjustments.adjustment_type%TYPE := 'EXPENSE';
185: x_nbv_retired_name fa_adjustments.adjustment_type%TYPE := 'NBV RETIRED';
186: x_reval_amort_name fa_adjustments.adjustment_type%TYPE := 'REVAL AMORT';

Line 183: x_reserve_name fa_adjustments.adjustment_type%TYPE := 'RESERVE';

179: -----------------------------------------------------------------------------
180:
181: x_cost_name fa_adjustments.adjustment_type%TYPE := 'COST';
182: x_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'CIP COST';
183: x_reserve_name fa_adjustments.adjustment_type%TYPE := 'RESERVE';
184: x_expense_name fa_adjustments.adjustment_type%TYPE := 'EXPENSE';
185: x_nbv_retired_name fa_adjustments.adjustment_type%TYPE := 'NBV RETIRED';
186: x_reval_amort_name fa_adjustments.adjustment_type%TYPE := 'REVAL AMORT';
187: x_reval_reserve_name fa_adjustments.adjustment_type%TYPE := 'REVAL RESERVE';

Line 184: x_expense_name fa_adjustments.adjustment_type%TYPE := 'EXPENSE';

180:
181: x_cost_name fa_adjustments.adjustment_type%TYPE := 'COST';
182: x_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'CIP COST';
183: x_reserve_name fa_adjustments.adjustment_type%TYPE := 'RESERVE';
184: x_expense_name fa_adjustments.adjustment_type%TYPE := 'EXPENSE';
185: x_nbv_retired_name fa_adjustments.adjustment_type%TYPE := 'NBV RETIRED';
186: x_reval_amort_name fa_adjustments.adjustment_type%TYPE := 'REVAL AMORT';
187: x_reval_reserve_name fa_adjustments.adjustment_type%TYPE := 'REVAL RESERVE';
188: x_proceeds_name fa_adjustments.adjustment_type%TYPE := 'PROCEEDS';

Line 185: x_nbv_retired_name fa_adjustments.adjustment_type%TYPE := 'NBV RETIRED';

181: x_cost_name fa_adjustments.adjustment_type%TYPE := 'COST';
182: x_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'CIP COST';
183: x_reserve_name fa_adjustments.adjustment_type%TYPE := 'RESERVE';
184: x_expense_name fa_adjustments.adjustment_type%TYPE := 'EXPENSE';
185: x_nbv_retired_name fa_adjustments.adjustment_type%TYPE := 'NBV RETIRED';
186: x_reval_amort_name fa_adjustments.adjustment_type%TYPE := 'REVAL AMORT';
187: x_reval_reserve_name fa_adjustments.adjustment_type%TYPE := 'REVAL RESERVE';
188: x_proceeds_name fa_adjustments.adjustment_type%TYPE := 'PROCEEDS';
189: x_removal_cost_name fa_adjustments.adjustment_type%TYPE := 'REMOVALCOST';

Line 186: x_reval_amort_name fa_adjustments.adjustment_type%TYPE := 'REVAL AMORT';

182: x_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'CIP COST';
183: x_reserve_name fa_adjustments.adjustment_type%TYPE := 'RESERVE';
184: x_expense_name fa_adjustments.adjustment_type%TYPE := 'EXPENSE';
185: x_nbv_retired_name fa_adjustments.adjustment_type%TYPE := 'NBV RETIRED';
186: x_reval_amort_name fa_adjustments.adjustment_type%TYPE := 'REVAL AMORT';
187: x_reval_reserve_name fa_adjustments.adjustment_type%TYPE := 'REVAL RESERVE';
188: x_proceeds_name fa_adjustments.adjustment_type%TYPE := 'PROCEEDS';
189: x_removal_cost_name fa_adjustments.adjustment_type%TYPE := 'REMOVALCOST';
190:

Line 187: x_reval_reserve_name fa_adjustments.adjustment_type%TYPE := 'REVAL RESERVE';

183: x_reserve_name fa_adjustments.adjustment_type%TYPE := 'RESERVE';
184: x_expense_name fa_adjustments.adjustment_type%TYPE := 'EXPENSE';
185: x_nbv_retired_name fa_adjustments.adjustment_type%TYPE := 'NBV RETIRED';
186: x_reval_amort_name fa_adjustments.adjustment_type%TYPE := 'REVAL AMORT';
187: x_reval_reserve_name fa_adjustments.adjustment_type%TYPE := 'REVAL RESERVE';
188: x_proceeds_name fa_adjustments.adjustment_type%TYPE := 'PROCEEDS';
189: x_removal_cost_name fa_adjustments.adjustment_type%TYPE := 'REMOVALCOST';
190:
191: x_ia_cost_name fa_adjustments.adjustment_type%TYPE := 'IA COST';

Line 188: x_proceeds_name fa_adjustments.adjustment_type%TYPE := 'PROCEEDS';

184: x_expense_name fa_adjustments.adjustment_type%TYPE := 'EXPENSE';
185: x_nbv_retired_name fa_adjustments.adjustment_type%TYPE := 'NBV RETIRED';
186: x_reval_amort_name fa_adjustments.adjustment_type%TYPE := 'REVAL AMORT';
187: x_reval_reserve_name fa_adjustments.adjustment_type%TYPE := 'REVAL RESERVE';
188: x_proceeds_name fa_adjustments.adjustment_type%TYPE := 'PROCEEDS';
189: x_removal_cost_name fa_adjustments.adjustment_type%TYPE := 'REMOVALCOST';
190:
191: x_ia_cost_name fa_adjustments.adjustment_type%TYPE := 'IA COST';
192: x_ix_cost_name fa_adjustments.adjustment_type%TYPE := 'IX COST';

Line 189: x_removal_cost_name fa_adjustments.adjustment_type%TYPE := 'REMOVALCOST';

185: x_nbv_retired_name fa_adjustments.adjustment_type%TYPE := 'NBV RETIRED';
186: x_reval_amort_name fa_adjustments.adjustment_type%TYPE := 'REVAL AMORT';
187: x_reval_reserve_name fa_adjustments.adjustment_type%TYPE := 'REVAL RESERVE';
188: x_proceeds_name fa_adjustments.adjustment_type%TYPE := 'PROCEEDS';
189: x_removal_cost_name fa_adjustments.adjustment_type%TYPE := 'REMOVALCOST';
190:
191: x_ia_cost_name fa_adjustments.adjustment_type%TYPE := 'IA COST';
192: x_ix_cost_name fa_adjustments.adjustment_type%TYPE := 'IX COST';
193: x_ia_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'IA CIP COST';

Line 191: x_ia_cost_name fa_adjustments.adjustment_type%TYPE := 'IA COST';

187: x_reval_reserve_name fa_adjustments.adjustment_type%TYPE := 'REVAL RESERVE';
188: x_proceeds_name fa_adjustments.adjustment_type%TYPE := 'PROCEEDS';
189: x_removal_cost_name fa_adjustments.adjustment_type%TYPE := 'REMOVALCOST';
190:
191: x_ia_cost_name fa_adjustments.adjustment_type%TYPE := 'IA COST';
192: x_ix_cost_name fa_adjustments.adjustment_type%TYPE := 'IX COST';
193: x_ia_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'IA CIP COST';
194: x_ix_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'IX CIP COST';
195: x_ia_reserve_name fa_adjustments.adjustment_type%TYPE := 'IA DEPRN RESRVE';

Line 192: x_ix_cost_name fa_adjustments.adjustment_type%TYPE := 'IX COST';

188: x_proceeds_name fa_adjustments.adjustment_type%TYPE := 'PROCEEDS';
189: x_removal_cost_name fa_adjustments.adjustment_type%TYPE := 'REMOVALCOST';
190:
191: x_ia_cost_name fa_adjustments.adjustment_type%TYPE := 'IA COST';
192: x_ix_cost_name fa_adjustments.adjustment_type%TYPE := 'IX COST';
193: x_ia_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'IA CIP COST';
194: x_ix_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'IX CIP COST';
195: x_ia_reserve_name fa_adjustments.adjustment_type%TYPE := 'IA DEPRN RESRVE';
196: x_ix_reserve_name fa_adjustments.adjustment_type%TYPE := 'IX DEPRN RESRVE';

Line 193: x_ia_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'IA CIP COST';

189: x_removal_cost_name fa_adjustments.adjustment_type%TYPE := 'REMOVALCOST';
190:
191: x_ia_cost_name fa_adjustments.adjustment_type%TYPE := 'IA COST';
192: x_ix_cost_name fa_adjustments.adjustment_type%TYPE := 'IX COST';
193: x_ia_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'IA CIP COST';
194: x_ix_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'IX CIP COST';
195: x_ia_reserve_name fa_adjustments.adjustment_type%TYPE := 'IA DEPRN RESRVE';
196: x_ix_reserve_name fa_adjustments.adjustment_type%TYPE := 'IX DEPRN RESRVE';
197: x_ia_expense_name fa_adjustments.adjustment_type%TYPE := 'IA DEPRN EXPNSE';

Line 194: x_ix_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'IX CIP COST';

190:
191: x_ia_cost_name fa_adjustments.adjustment_type%TYPE := 'IA COST';
192: x_ix_cost_name fa_adjustments.adjustment_type%TYPE := 'IX COST';
193: x_ia_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'IA CIP COST';
194: x_ix_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'IX CIP COST';
195: x_ia_reserve_name fa_adjustments.adjustment_type%TYPE := 'IA DEPRN RESRVE';
196: x_ix_reserve_name fa_adjustments.adjustment_type%TYPE := 'IX DEPRN RESRVE';
197: x_ia_expense_name fa_adjustments.adjustment_type%TYPE := 'IA DEPRN EXPNSE';
198: x_ix_expense_name fa_adjustments.adjustment_type%TYPE := 'IX DEPRN EXPNSE';

Line 195: x_ia_reserve_name fa_adjustments.adjustment_type%TYPE := 'IA DEPRN RESRVE';

191: x_ia_cost_name fa_adjustments.adjustment_type%TYPE := 'IA COST';
192: x_ix_cost_name fa_adjustments.adjustment_type%TYPE := 'IX COST';
193: x_ia_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'IA CIP COST';
194: x_ix_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'IX CIP COST';
195: x_ia_reserve_name fa_adjustments.adjustment_type%TYPE := 'IA DEPRN RESRVE';
196: x_ix_reserve_name fa_adjustments.adjustment_type%TYPE := 'IX DEPRN RESRVE';
197: x_ia_expense_name fa_adjustments.adjustment_type%TYPE := 'IA DEPRN EXPNSE';
198: x_ix_expense_name fa_adjustments.adjustment_type%TYPE := 'IX DEPRN EXPNSE';
199:

Line 196: x_ix_reserve_name fa_adjustments.adjustment_type%TYPE := 'IX DEPRN RESRVE';

192: x_ix_cost_name fa_adjustments.adjustment_type%TYPE := 'IX COST';
193: x_ia_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'IA CIP COST';
194: x_ix_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'IX CIP COST';
195: x_ia_reserve_name fa_adjustments.adjustment_type%TYPE := 'IA DEPRN RESRVE';
196: x_ix_reserve_name fa_adjustments.adjustment_type%TYPE := 'IX DEPRN RESRVE';
197: x_ia_expense_name fa_adjustments.adjustment_type%TYPE := 'IA DEPRN EXPNSE';
198: x_ix_expense_name fa_adjustments.adjustment_type%TYPE := 'IX DEPRN EXPNSE';
199:
200: x_ta_revaluation_name fa_adjustments.adjustment_type%TYPE := 'TA REVALUATION';

Line 197: x_ia_expense_name fa_adjustments.adjustment_type%TYPE := 'IA DEPRN EXPNSE';

193: x_ia_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'IA CIP COST';
194: x_ix_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'IX CIP COST';
195: x_ia_reserve_name fa_adjustments.adjustment_type%TYPE := 'IA DEPRN RESRVE';
196: x_ix_reserve_name fa_adjustments.adjustment_type%TYPE := 'IX DEPRN RESRVE';
197: x_ia_expense_name fa_adjustments.adjustment_type%TYPE := 'IA DEPRN EXPNSE';
198: x_ix_expense_name fa_adjustments.adjustment_type%TYPE := 'IX DEPRN EXPNSE';
199:
200: x_ta_revaluation_name fa_adjustments.adjustment_type%TYPE := 'TA REVALUATION';
201: x_ta_surplus_name fa_adjustments.adjustment_type%TYPE := 'TA SURPLUS';

Line 198: x_ix_expense_name fa_adjustments.adjustment_type%TYPE := 'IX DEPRN EXPNSE';

194: x_ix_cip_cost_name fa_adjustments.adjustment_type%TYPE := 'IX CIP COST';
195: x_ia_reserve_name fa_adjustments.adjustment_type%TYPE := 'IA DEPRN RESRVE';
196: x_ix_reserve_name fa_adjustments.adjustment_type%TYPE := 'IX DEPRN RESRVE';
197: x_ia_expense_name fa_adjustments.adjustment_type%TYPE := 'IA DEPRN EXPNSE';
198: x_ix_expense_name fa_adjustments.adjustment_type%TYPE := 'IX DEPRN EXPNSE';
199:
200: x_ta_revaluation_name fa_adjustments.adjustment_type%TYPE := 'TA REVALUATION';
201: x_ta_surplus_name fa_adjustments.adjustment_type%TYPE := 'TA SURPLUS';
202: x_ta_reserve_name fa_adjustments.adjustment_type%TYPE := 'TA RESERVE';

Line 200: x_ta_revaluation_name fa_adjustments.adjustment_type%TYPE := 'TA REVALUATION';

196: x_ix_reserve_name fa_adjustments.adjustment_type%TYPE := 'IX DEPRN RESRVE';
197: x_ia_expense_name fa_adjustments.adjustment_type%TYPE := 'IA DEPRN EXPNSE';
198: x_ix_expense_name fa_adjustments.adjustment_type%TYPE := 'IX DEPRN EXPNSE';
199:
200: x_ta_revaluation_name fa_adjustments.adjustment_type%TYPE := 'TA REVALUATION';
201: x_ta_surplus_name fa_adjustments.adjustment_type%TYPE := 'TA SURPLUS';
202: x_ta_reserve_name fa_adjustments.adjustment_type%TYPE := 'TA RESERVE';
203: x_ta_expense_name fa_adjustments.adjustment_type%TYPE := 'TA RESRVE EXPEN';
204: x_ta_recovery_name fa_adjustments.adjustment_type%TYPE := 'TA RESRVE RECOV';

Line 201: x_ta_surplus_name fa_adjustments.adjustment_type%TYPE := 'TA SURPLUS';

197: x_ia_expense_name fa_adjustments.adjustment_type%TYPE := 'IA DEPRN EXPNSE';
198: x_ix_expense_name fa_adjustments.adjustment_type%TYPE := 'IX DEPRN EXPNSE';
199:
200: x_ta_revaluation_name fa_adjustments.adjustment_type%TYPE := 'TA REVALUATION';
201: x_ta_surplus_name fa_adjustments.adjustment_type%TYPE := 'TA SURPLUS';
202: x_ta_reserve_name fa_adjustments.adjustment_type%TYPE := 'TA RESERVE';
203: x_ta_expense_name fa_adjustments.adjustment_type%TYPE := 'TA RESRVE EXPEN';
204: x_ta_recovery_name fa_adjustments.adjustment_type%TYPE := 'TA RESRVE RECOV';
205:

Line 202: x_ta_reserve_name fa_adjustments.adjustment_type%TYPE := 'TA RESERVE';

198: x_ix_expense_name fa_adjustments.adjustment_type%TYPE := 'IX DEPRN EXPNSE';
199:
200: x_ta_revaluation_name fa_adjustments.adjustment_type%TYPE := 'TA REVALUATION';
201: x_ta_surplus_name fa_adjustments.adjustment_type%TYPE := 'TA SURPLUS';
202: x_ta_reserve_name fa_adjustments.adjustment_type%TYPE := 'TA RESERVE';
203: x_ta_expense_name fa_adjustments.adjustment_type%TYPE := 'TA RESRVE EXPEN';
204: x_ta_recovery_name fa_adjustments.adjustment_type%TYPE := 'TA RESRVE RECOV';
205:
206: x_account_name fa_adjustments.adjustment_type%TYPE;

Line 203: x_ta_expense_name fa_adjustments.adjustment_type%TYPE := 'TA RESRVE EXPEN';

199:
200: x_ta_revaluation_name fa_adjustments.adjustment_type%TYPE := 'TA REVALUATION';
201: x_ta_surplus_name fa_adjustments.adjustment_type%TYPE := 'TA SURPLUS';
202: x_ta_reserve_name fa_adjustments.adjustment_type%TYPE := 'TA RESERVE';
203: x_ta_expense_name fa_adjustments.adjustment_type%TYPE := 'TA RESRVE EXPEN';
204: x_ta_recovery_name fa_adjustments.adjustment_type%TYPE := 'TA RESRVE RECOV';
205:
206: x_account_name fa_adjustments.adjustment_type%TYPE;
207:

Line 204: x_ta_recovery_name fa_adjustments.adjustment_type%TYPE := 'TA RESRVE RECOV';

200: x_ta_revaluation_name fa_adjustments.adjustment_type%TYPE := 'TA REVALUATION';
201: x_ta_surplus_name fa_adjustments.adjustment_type%TYPE := 'TA SURPLUS';
202: x_ta_reserve_name fa_adjustments.adjustment_type%TYPE := 'TA RESERVE';
203: x_ta_expense_name fa_adjustments.adjustment_type%TYPE := 'TA RESRVE EXPEN';
204: x_ta_recovery_name fa_adjustments.adjustment_type%TYPE := 'TA RESRVE RECOV';
205:
206: x_account_name fa_adjustments.adjustment_type%TYPE;
207:
208: -----------------------------------------------------------------------------

Line 206: x_account_name fa_adjustments.adjustment_type%TYPE;

202: x_ta_reserve_name fa_adjustments.adjustment_type%TYPE := 'TA RESERVE';
203: x_ta_expense_name fa_adjustments.adjustment_type%TYPE := 'TA RESRVE EXPEN';
204: x_ta_recovery_name fa_adjustments.adjustment_type%TYPE := 'TA RESRVE RECOV';
205:
206: x_account_name fa_adjustments.adjustment_type%TYPE;
207:
208: -----------------------------------------------------------------------------
209: -- Variables for transaction tracking --
210: -----------------------------------------------------------------------------

Line 221: x_debit_credit_flag fa_adjustments.debit_credit_flag%TYPE;

217: x_old_category_id fa_asset_history.category_id%TYPE;
218: x_asset_id fa_additions.asset_id%TYPE;
219:
220: x_distribution_id fa_distribution_history.distribution_id%TYPE;
221: x_debit_credit_flag fa_adjustments.debit_credit_flag%TYPE;
222: x_code_combination_id fa_adjustments.code_combination_id%TYPE;
223: x_adjustment_amount fa_adjustments.adjustment_amount%TYPE;
224: x_adjustment_type fa_adjustments.adjustment_type%TYPE;
225:

Line 222: x_code_combination_id fa_adjustments.code_combination_id%TYPE;

218: x_asset_id fa_additions.asset_id%TYPE;
219:
220: x_distribution_id fa_distribution_history.distribution_id%TYPE;
221: x_debit_credit_flag fa_adjustments.debit_credit_flag%TYPE;
222: x_code_combination_id fa_adjustments.code_combination_id%TYPE;
223: x_adjustment_amount fa_adjustments.adjustment_amount%TYPE;
224: x_adjustment_type fa_adjustments.adjustment_type%TYPE;
225:
226: x_cost_dr NUMBER;

Line 223: x_adjustment_amount fa_adjustments.adjustment_amount%TYPE;

219:
220: x_distribution_id fa_distribution_history.distribution_id%TYPE;
221: x_debit_credit_flag fa_adjustments.debit_credit_flag%TYPE;
222: x_code_combination_id fa_adjustments.code_combination_id%TYPE;
223: x_adjustment_amount fa_adjustments.adjustment_amount%TYPE;
224: x_adjustment_type fa_adjustments.adjustment_type%TYPE;
225:
226: x_cost_dr NUMBER;
227: x_cost_cr NUMBER;

Line 224: x_adjustment_type fa_adjustments.adjustment_type%TYPE;

220: x_distribution_id fa_distribution_history.distribution_id%TYPE;
221: x_debit_credit_flag fa_adjustments.debit_credit_flag%TYPE;
222: x_code_combination_id fa_adjustments.code_combination_id%TYPE;
223: x_adjustment_amount fa_adjustments.adjustment_amount%TYPE;
224: x_adjustment_type fa_adjustments.adjustment_type%TYPE;
225:
226: x_cost_dr NUMBER;
227: x_cost_cr NUMBER;
228: x_reserve_dr NUMBER;

Line 261: x_nbv_debit_credit_flag fa_adjustments.debit_credit_flag%TYPE;

257:
258: x_retirement_type VARCHAR2 (1);
259: x_retirement_type_code fa_transaction_headers.transaction_type_code%TYPE;
260: x_source_transaction_header_id fa_transaction_headers.transaction_header_id%TYPE;
261: x_nbv_debit_credit_flag fa_adjustments.debit_credit_flag%TYPE;
262: x_nbv_retired_ccid fa_adjustments.code_combination_id%TYPE;
263: x_ia_cost_retired NUMBER;
264: x_ia_reserve NUMBER;
265: x_ia_reserve_retired NUMBER;

Line 262: x_nbv_retired_ccid fa_adjustments.code_combination_id%TYPE;

258: x_retirement_type VARCHAR2 (1);
259: x_retirement_type_code fa_transaction_headers.transaction_type_code%TYPE;
260: x_source_transaction_header_id fa_transaction_headers.transaction_header_id%TYPE;
261: x_nbv_debit_credit_flag fa_adjustments.debit_credit_flag%TYPE;
262: x_nbv_retired_ccid fa_adjustments.code_combination_id%TYPE;
263: x_ia_cost_retired NUMBER;
264: x_ia_reserve NUMBER;
265: x_ia_reserve_retired NUMBER;
266: x_gain_loss_changed BOOLEAN;

Line 504: FROM fa_adjustments ADJ,

500: ADJ.annualized_adjustment,
501: ADJ.period_counter_adjusted,
502: ADJ.period_counter_created,
503: ADJ.asset_invoice_id
504: FROM fa_adjustments ADJ,
505: --SLA Changes. New Tables Added
506: xla_ae_headers XHD,
507: xla_ae_lines XLN,
508: xla_distribution_links XDL

Line 549: FROM fa_adjustments ADJ,

545: ADJ.annualized_adjustment,
546: ADJ.period_counter_adjusted,
547: ADJ.period_counter_created,
548: ADJ.asset_invoice_id
549: FROM fa_adjustments ADJ,
550: --SLA Changes. New Tables Added
551: xla_ae_headers XHD,
552: xla_ae_lines XLN,
553: xla_distribution_links XDL

Line 587: FROM fa_adjustments ADJ,

583: IS
584: --SELECT ADJ. code_combination_id,
585: SELECT XLN.code_combination_id,
586: ADJ.adjustment_amount
587: FROM fa_adjustments ADJ,
588: --SLA Changes. New Tables Added
589: xla_ae_headers XHD,
590: xla_ae_lines XLN,
591: xla_distribution_links XDL

Line 610: -- Get the total value for a concept recorded in FA_ADJUSTMENTS --

606: AND XLN.ae_line_num = XDL.ae_line_num
607: AND XLN.application_id = 140;
608:
609: -----------------------------------------------------------------------------
610: -- Get the total value for a concept recorded in FA_ADJUSTMENTS --
611: -----------------------------------------------------------------------------
612:
613: CURSOR c_sum_adjustments (pc_asset_id IN NUMBER,
614: pc_book_type_code IN VARCHAR2,

Line 621: FROM fa_adjustments

617: pc_debit_credit_flag IN VARCHAR2
618: )
619: IS
620: SELECT nvl (sum (nvl (adjustment_amount,0)), 0)
621: FROM fa_adjustments
622: WHERE asset_id = pc_asset_id
623: AND book_type_code = pc_book_type_code
624: AND transaction_header_id = pc_transaction_header_id
625: AND adjustment_type = pc_adjustment_type

Line 640: FROM fa_adjustments

636: pc_debit_credit_flag IN VARCHAR2
637: )
638: IS
639: SELECT nvl (sum (nvl (adjustment_amount,0)), 0)
640: FROM fa_adjustments
641: WHERE asset_id = pc_asset_id
642: AND book_type_code = pc_book_type_code
643: AND period_counter_created = pc_period_counter
644: AND adjustment_type = pc_adjustment_type

Line 2293: -- Loop for related rows in FA_ADJUSTMENTS for the transaction --

2289: END IF;
2290: END IF;
2291:
2292: -----------------------------------------------------------------------------
2293: -- Loop for related rows in FA_ADJUSTMENTS for the transaction --
2294: -----------------------------------------------------------------------------
2295:
2296: FOR ra IN c_tr_adjustments_no_adj_type (tr.transaction_header_id,
2297: tr.book_type_code,

Line 2920: -- Find all adjusted rows in FA_ADJUSTMENTS for TAX book --

2916: x_factor_2 := 0;
2917: END IF;
2918:
2919: -----------------------------------------------------------------------------
2920: -- Find all adjusted rows in FA_ADJUSTMENTS for TAX book --
2921: -----------------------------------------------------------------------------
2922:
2923: FOR ra IN c_tr_adjustments_no_adj_type (tr.transaction_header_id,
2924: p_tax_book,

Line 4031: -- Find all rows in FA_ADJUSTMENTS for the retirement transaction --

4027: END IF;
4028: END IF;
4029:
4030: -----------------------------------------------------------------------------
4031: -- Find all rows in FA_ADJUSTMENTS for the retirement transaction --
4032: -----------------------------------------------------------------------------
4033:
4034: FOR ra IN c_tr_adjustments_no_adj_type (tr.transaction_header_id,
4035: tr.book_type_code,

Line 4103: -- Insert row in JL_CO_FA_ADJUSTMENTS --

4099: -----------------------------------------------------------------------------
4100: -- Rows to add due to inflation adjustments --
4101: -- Calculate amount --
4102: -- Built accounting flexfield --
4103: -- Insert row in JL_CO_FA_ADJUSTMENTS --
4104: -----------------------------------------------------------------------------
4105:
4106: IF (x_retirement_type = 'O') THEN
4107: x_adjustment_amount := ra.adjustment_amount;

Line 4298: -- Insert new row with right account in JL_CO_FA_ADJUSTMENTS --

4294: -- Change Gain/Loss. Reverse the standard rows and create new rows with --
4295: -- the right account. --
4296: -- Get the standard row --
4297: -- Insert row reversing it --
4298: -- Insert new row with right account in JL_CO_FA_ADJUSTMENTS --
4299: -----------------------------------------------------------------------------
4300:
4301: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4302: x_char := ra.adjustment_type;

Line 5000: PROCEDURE insert_adjustment (p_transaction_header_id IN jl_co_fa_adjustments.transaction_header_id%TYPE,

4996: -- p_reference --
4997: -- p_posting_flag --
4998: ----------------------------------------------------------------------------
4999:
5000: PROCEDURE insert_adjustment (p_transaction_header_id IN jl_co_fa_adjustments.transaction_header_id%TYPE,
5001: p_source_type_code IN jl_co_fa_adjustments.source_type_code%TYPE,
5002: p_je_category_name IN jl_co_fa_adjustments.je_category_name%TYPE,
5003: p_adjustment_type IN jl_co_fa_adjustments.adjustment_type%TYPE,
5004: p_debit_credit_flag IN jl_co_fa_adjustments.debit_credit_flag%TYPE,

Line 5001: p_source_type_code IN jl_co_fa_adjustments.source_type_code%TYPE,

4997: -- p_posting_flag --
4998: ----------------------------------------------------------------------------
4999:
5000: PROCEDURE insert_adjustment (p_transaction_header_id IN jl_co_fa_adjustments.transaction_header_id%TYPE,
5001: p_source_type_code IN jl_co_fa_adjustments.source_type_code%TYPE,
5002: p_je_category_name IN jl_co_fa_adjustments.je_category_name%TYPE,
5003: p_adjustment_type IN jl_co_fa_adjustments.adjustment_type%TYPE,
5004: p_debit_credit_flag IN jl_co_fa_adjustments.debit_credit_flag%TYPE,
5005: p_code_combination_id IN jl_co_fa_adjustments.code_combination_id%TYPE,

Line 5002: p_je_category_name IN jl_co_fa_adjustments.je_category_name%TYPE,

4998: ----------------------------------------------------------------------------
4999:
5000: PROCEDURE insert_adjustment (p_transaction_header_id IN jl_co_fa_adjustments.transaction_header_id%TYPE,
5001: p_source_type_code IN jl_co_fa_adjustments.source_type_code%TYPE,
5002: p_je_category_name IN jl_co_fa_adjustments.je_category_name%TYPE,
5003: p_adjustment_type IN jl_co_fa_adjustments.adjustment_type%TYPE,
5004: p_debit_credit_flag IN jl_co_fa_adjustments.debit_credit_flag%TYPE,
5005: p_code_combination_id IN jl_co_fa_adjustments.code_combination_id%TYPE,
5006: p_book_type_code IN jl_co_fa_adjustments.book_type_code%TYPE,

Line 5003: p_adjustment_type IN jl_co_fa_adjustments.adjustment_type%TYPE,

4999:
5000: PROCEDURE insert_adjustment (p_transaction_header_id IN jl_co_fa_adjustments.transaction_header_id%TYPE,
5001: p_source_type_code IN jl_co_fa_adjustments.source_type_code%TYPE,
5002: p_je_category_name IN jl_co_fa_adjustments.je_category_name%TYPE,
5003: p_adjustment_type IN jl_co_fa_adjustments.adjustment_type%TYPE,
5004: p_debit_credit_flag IN jl_co_fa_adjustments.debit_credit_flag%TYPE,
5005: p_code_combination_id IN jl_co_fa_adjustments.code_combination_id%TYPE,
5006: p_book_type_code IN jl_co_fa_adjustments.book_type_code%TYPE,
5007: p_asset_id IN jl_co_fa_adjustments.asset_id%TYPE,

Line 5004: p_debit_credit_flag IN jl_co_fa_adjustments.debit_credit_flag%TYPE,

5000: PROCEDURE insert_adjustment (p_transaction_header_id IN jl_co_fa_adjustments.transaction_header_id%TYPE,
5001: p_source_type_code IN jl_co_fa_adjustments.source_type_code%TYPE,
5002: p_je_category_name IN jl_co_fa_adjustments.je_category_name%TYPE,
5003: p_adjustment_type IN jl_co_fa_adjustments.adjustment_type%TYPE,
5004: p_debit_credit_flag IN jl_co_fa_adjustments.debit_credit_flag%TYPE,
5005: p_code_combination_id IN jl_co_fa_adjustments.code_combination_id%TYPE,
5006: p_book_type_code IN jl_co_fa_adjustments.book_type_code%TYPE,
5007: p_asset_id IN jl_co_fa_adjustments.asset_id%TYPE,
5008: p_adjustment_amount IN jl_co_fa_adjustments.adjustment_amount%TYPE,

Line 5005: p_code_combination_id IN jl_co_fa_adjustments.code_combination_id%TYPE,

5001: p_source_type_code IN jl_co_fa_adjustments.source_type_code%TYPE,
5002: p_je_category_name IN jl_co_fa_adjustments.je_category_name%TYPE,
5003: p_adjustment_type IN jl_co_fa_adjustments.adjustment_type%TYPE,
5004: p_debit_credit_flag IN jl_co_fa_adjustments.debit_credit_flag%TYPE,
5005: p_code_combination_id IN jl_co_fa_adjustments.code_combination_id%TYPE,
5006: p_book_type_code IN jl_co_fa_adjustments.book_type_code%TYPE,
5007: p_asset_id IN jl_co_fa_adjustments.asset_id%TYPE,
5008: p_adjustment_amount IN jl_co_fa_adjustments.adjustment_amount%TYPE,
5009: p_distribution_id IN jl_co_fa_adjustments.distribution_id%TYPE,

Line 5006: p_book_type_code IN jl_co_fa_adjustments.book_type_code%TYPE,

5002: p_je_category_name IN jl_co_fa_adjustments.je_category_name%TYPE,
5003: p_adjustment_type IN jl_co_fa_adjustments.adjustment_type%TYPE,
5004: p_debit_credit_flag IN jl_co_fa_adjustments.debit_credit_flag%TYPE,
5005: p_code_combination_id IN jl_co_fa_adjustments.code_combination_id%TYPE,
5006: p_book_type_code IN jl_co_fa_adjustments.book_type_code%TYPE,
5007: p_asset_id IN jl_co_fa_adjustments.asset_id%TYPE,
5008: p_adjustment_amount IN jl_co_fa_adjustments.adjustment_amount%TYPE,
5009: p_distribution_id IN jl_co_fa_adjustments.distribution_id%TYPE,
5010: p_annualized_adjustment IN jl_co_fa_adjustments.annualized_adjustment%TYPE,

Line 5007: p_asset_id IN jl_co_fa_adjustments.asset_id%TYPE,

5003: p_adjustment_type IN jl_co_fa_adjustments.adjustment_type%TYPE,
5004: p_debit_credit_flag IN jl_co_fa_adjustments.debit_credit_flag%TYPE,
5005: p_code_combination_id IN jl_co_fa_adjustments.code_combination_id%TYPE,
5006: p_book_type_code IN jl_co_fa_adjustments.book_type_code%TYPE,
5007: p_asset_id IN jl_co_fa_adjustments.asset_id%TYPE,
5008: p_adjustment_amount IN jl_co_fa_adjustments.adjustment_amount%TYPE,
5009: p_distribution_id IN jl_co_fa_adjustments.distribution_id%TYPE,
5010: p_annualized_adjustment IN jl_co_fa_adjustments.annualized_adjustment%TYPE,
5011: p_je_header_reference_id IN jl_co_fa_adjustments.je_header_reference_id%TYPE,

Line 5008: p_adjustment_amount IN jl_co_fa_adjustments.adjustment_amount%TYPE,

5004: p_debit_credit_flag IN jl_co_fa_adjustments.debit_credit_flag%TYPE,
5005: p_code_combination_id IN jl_co_fa_adjustments.code_combination_id%TYPE,
5006: p_book_type_code IN jl_co_fa_adjustments.book_type_code%TYPE,
5007: p_asset_id IN jl_co_fa_adjustments.asset_id%TYPE,
5008: p_adjustment_amount IN jl_co_fa_adjustments.adjustment_amount%TYPE,
5009: p_distribution_id IN jl_co_fa_adjustments.distribution_id%TYPE,
5010: p_annualized_adjustment IN jl_co_fa_adjustments.annualized_adjustment%TYPE,
5011: p_je_header_reference_id IN jl_co_fa_adjustments.je_header_reference_id%TYPE,
5012: p_sequence_line IN jl_co_fa_adjustments.sequence_line%TYPE,

Line 5009: p_distribution_id IN jl_co_fa_adjustments.distribution_id%TYPE,

5005: p_code_combination_id IN jl_co_fa_adjustments.code_combination_id%TYPE,
5006: p_book_type_code IN jl_co_fa_adjustments.book_type_code%TYPE,
5007: p_asset_id IN jl_co_fa_adjustments.asset_id%TYPE,
5008: p_adjustment_amount IN jl_co_fa_adjustments.adjustment_amount%TYPE,
5009: p_distribution_id IN jl_co_fa_adjustments.distribution_id%TYPE,
5010: p_annualized_adjustment IN jl_co_fa_adjustments.annualized_adjustment%TYPE,
5011: p_je_header_reference_id IN jl_co_fa_adjustments.je_header_reference_id%TYPE,
5012: p_sequence_line IN jl_co_fa_adjustments.sequence_line%TYPE,
5013: p_period_counter_adjusted IN jl_co_fa_adjustments.period_counter_adjusted%TYPE,

Line 5010: p_annualized_adjustment IN jl_co_fa_adjustments.annualized_adjustment%TYPE,

5006: p_book_type_code IN jl_co_fa_adjustments.book_type_code%TYPE,
5007: p_asset_id IN jl_co_fa_adjustments.asset_id%TYPE,
5008: p_adjustment_amount IN jl_co_fa_adjustments.adjustment_amount%TYPE,
5009: p_distribution_id IN jl_co_fa_adjustments.distribution_id%TYPE,
5010: p_annualized_adjustment IN jl_co_fa_adjustments.annualized_adjustment%TYPE,
5011: p_je_header_reference_id IN jl_co_fa_adjustments.je_header_reference_id%TYPE,
5012: p_sequence_line IN jl_co_fa_adjustments.sequence_line%TYPE,
5013: p_period_counter_adjusted IN jl_co_fa_adjustments.period_counter_adjusted%TYPE,
5014: p_period_counter_created IN jl_co_fa_adjustments.period_counter_created%TYPE,

Line 5011: p_je_header_reference_id IN jl_co_fa_adjustments.je_header_reference_id%TYPE,

5007: p_asset_id IN jl_co_fa_adjustments.asset_id%TYPE,
5008: p_adjustment_amount IN jl_co_fa_adjustments.adjustment_amount%TYPE,
5009: p_distribution_id IN jl_co_fa_adjustments.distribution_id%TYPE,
5010: p_annualized_adjustment IN jl_co_fa_adjustments.annualized_adjustment%TYPE,
5011: p_je_header_reference_id IN jl_co_fa_adjustments.je_header_reference_id%TYPE,
5012: p_sequence_line IN jl_co_fa_adjustments.sequence_line%TYPE,
5013: p_period_counter_adjusted IN jl_co_fa_adjustments.period_counter_adjusted%TYPE,
5014: p_period_counter_created IN jl_co_fa_adjustments.period_counter_created%TYPE,
5015: p_asset_invoice_id IN jl_co_fa_adjustments.asset_invoice_id%TYPE,

Line 5012: p_sequence_line IN jl_co_fa_adjustments.sequence_line%TYPE,

5008: p_adjustment_amount IN jl_co_fa_adjustments.adjustment_amount%TYPE,
5009: p_distribution_id IN jl_co_fa_adjustments.distribution_id%TYPE,
5010: p_annualized_adjustment IN jl_co_fa_adjustments.annualized_adjustment%TYPE,
5011: p_je_header_reference_id IN jl_co_fa_adjustments.je_header_reference_id%TYPE,
5012: p_sequence_line IN jl_co_fa_adjustments.sequence_line%TYPE,
5013: p_period_counter_adjusted IN jl_co_fa_adjustments.period_counter_adjusted%TYPE,
5014: p_period_counter_created IN jl_co_fa_adjustments.period_counter_created%TYPE,
5015: p_asset_invoice_id IN jl_co_fa_adjustments.asset_invoice_id%TYPE,
5016: p_reference IN jl_co_fa_adjustments.reference%TYPE,

Line 5013: p_period_counter_adjusted IN jl_co_fa_adjustments.period_counter_adjusted%TYPE,

5009: p_distribution_id IN jl_co_fa_adjustments.distribution_id%TYPE,
5010: p_annualized_adjustment IN jl_co_fa_adjustments.annualized_adjustment%TYPE,
5011: p_je_header_reference_id IN jl_co_fa_adjustments.je_header_reference_id%TYPE,
5012: p_sequence_line IN jl_co_fa_adjustments.sequence_line%TYPE,
5013: p_period_counter_adjusted IN jl_co_fa_adjustments.period_counter_adjusted%TYPE,
5014: p_period_counter_created IN jl_co_fa_adjustments.period_counter_created%TYPE,
5015: p_asset_invoice_id IN jl_co_fa_adjustments.asset_invoice_id%TYPE,
5016: p_reference IN jl_co_fa_adjustments.reference%TYPE,
5017: p_posting_flag IN jl_co_fa_adjustments.posting_flag%TYPE

Line 5014: p_period_counter_created IN jl_co_fa_adjustments.period_counter_created%TYPE,

5010: p_annualized_adjustment IN jl_co_fa_adjustments.annualized_adjustment%TYPE,
5011: p_je_header_reference_id IN jl_co_fa_adjustments.je_header_reference_id%TYPE,
5012: p_sequence_line IN jl_co_fa_adjustments.sequence_line%TYPE,
5013: p_period_counter_adjusted IN jl_co_fa_adjustments.period_counter_adjusted%TYPE,
5014: p_period_counter_created IN jl_co_fa_adjustments.period_counter_created%TYPE,
5015: p_asset_invoice_id IN jl_co_fa_adjustments.asset_invoice_id%TYPE,
5016: p_reference IN jl_co_fa_adjustments.reference%TYPE,
5017: p_posting_flag IN jl_co_fa_adjustments.posting_flag%TYPE
5018: )

Line 5015: p_asset_invoice_id IN jl_co_fa_adjustments.asset_invoice_id%TYPE,

5011: p_je_header_reference_id IN jl_co_fa_adjustments.je_header_reference_id%TYPE,
5012: p_sequence_line IN jl_co_fa_adjustments.sequence_line%TYPE,
5013: p_period_counter_adjusted IN jl_co_fa_adjustments.period_counter_adjusted%TYPE,
5014: p_period_counter_created IN jl_co_fa_adjustments.period_counter_created%TYPE,
5015: p_asset_invoice_id IN jl_co_fa_adjustments.asset_invoice_id%TYPE,
5016: p_reference IN jl_co_fa_adjustments.reference%TYPE,
5017: p_posting_flag IN jl_co_fa_adjustments.posting_flag%TYPE
5018: )
5019: IS

Line 5016: p_reference IN jl_co_fa_adjustments.reference%TYPE,

5012: p_sequence_line IN jl_co_fa_adjustments.sequence_line%TYPE,
5013: p_period_counter_adjusted IN jl_co_fa_adjustments.period_counter_adjusted%TYPE,
5014: p_period_counter_created IN jl_co_fa_adjustments.period_counter_created%TYPE,
5015: p_asset_invoice_id IN jl_co_fa_adjustments.asset_invoice_id%TYPE,
5016: p_reference IN jl_co_fa_adjustments.reference%TYPE,
5017: p_posting_flag IN jl_co_fa_adjustments.posting_flag%TYPE
5018: )
5019: IS
5020:

Line 5017: p_posting_flag IN jl_co_fa_adjustments.posting_flag%TYPE

5013: p_period_counter_adjusted IN jl_co_fa_adjustments.period_counter_adjusted%TYPE,
5014: p_period_counter_created IN jl_co_fa_adjustments.period_counter_created%TYPE,
5015: p_asset_invoice_id IN jl_co_fa_adjustments.asset_invoice_id%TYPE,
5016: p_reference IN jl_co_fa_adjustments.reference%TYPE,
5017: p_posting_flag IN jl_co_fa_adjustments.posting_flag%TYPE
5018: )
5019: IS
5020:
5021: x_adjustment_amount NUMBER;

Line 5022: x_debit_credit_flag fa_adjustments.debit_credit_flag%TYPE;

5018: )
5019: IS
5020:
5021: x_adjustment_amount NUMBER;
5022: x_debit_credit_flag fa_adjustments.debit_credit_flag%TYPE;
5023: call_status BOOLEAN;
5024: l_original_cost NUMBER;
5025:
5026:

Line 5069: INSERT INTO jl_co_fa_adjustments

5065: x_debit_credit_flag := p_debit_credit_flag;
5066: END IF;
5067:
5068: IF p_code_combination_id IS NOT NULL THEN
5069: INSERT INTO jl_co_fa_adjustments
5070: (transaction_header_id,
5071: source_type_code,
5072: je_category_name,
5073: adjustment_type,