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.FA_RETIREMENT_PVT dependencies on FA_ADJUSTMENTS

Line 63: from fa_adjustments

59: debit_credit_flag,
60: adjustment_amount,
61: period_counter_adjusted,
62: period_counter_created
63: from fa_adjustments
64: where asset_id = l_asset_hdr_rec.asset_id
65: and book_type_code = l_asset_hdr_rec.book_type_code
66: and transaction_header_id = l_trans_rec.transaction_header_id
67: and source_type_code = 'DEPRECIATION';

Line 263: -- into FA_ADJUSTMENTS.

259: l_cglfr_mode := 'CR';
260: end if;
261: --
262: -- Insert COST, RESERVE, PROCEEDS CLR, and REMOVALCOST CLR
263: -- into FA_ADJUSTMENTS.
264: --
265: --tk_util.debug('Before calling CALC_GAIN_LOSS_FOR_RET');
266: if not CALC_GAIN_LOSS_FOR_RET(
267: p_trans_rec => p_trans_rec,

Line 646: from fa_adjustments

642: l_transaction_header_id NUMBER(15);
643:
644: CURSOR c_adj IS
645: select rowid
646: from fa_adjustments
647: where asset_id = p_group_asset_id
648: and book_type_code = p_asset_hdr_rec.book_type_code
649: and transaction_header_id = l_transaction_header_id;
650:

Line 653: from fa_adjustments_mrc_v

649: and transaction_header_id = l_transaction_header_id;
650:
651: CURSOR c_mc_adj IS
652: select rowid
653: from fa_adjustments_mrc_v
654: where transaction_header_id = l_transaction_header_id;
655:
656: l_calling_fn VARCHAR2(100) := 'fa_group_retirement_pvt.undo_retirement_reinstatement';
657:

Line 681: FA_ADJUSTMENTS_PKG.DELETE_ROW(

677: p_log_level_rec => p_log_level_rec);
678:
679: for l_adj in c_mc_adj loop
680:
681: FA_ADJUSTMENTS_PKG.DELETE_ROW(
682: X_Rowid => l_adj.rowid,
683: X_mrc_sob_type_code => p_mrc_sob_type_code,
684: X_Calling_Fn => l_calling_fn,
685: p_log_level_rec => p_log_level_rec);

Line 704: FA_ADJUSTMENTS_PKG.DELETE_ROW(

700: p_log_level_rec => p_log_level_rec);
701:
702: for l_adj in c_adj loop
703:
704: FA_ADJUSTMENTS_PKG.DELETE_ROW(
705: X_Rowid => l_adj.rowid,
706: X_mrc_sob_type_code => p_mrc_sob_type_code,
707: X_Calling_Fn => l_calling_fn,
708: p_log_level_rec => p_log_level_rec);

Line 1339: DELETE FROM FA_ADJUSTMENTS

1335: fa_debug_pkg.add(l_calling_fn, 'Process Member Rollup Group',
1336: l_asset_hdr_rec.asset_id,p_log_level_rec);
1337: end if;
1338: -- +++++ Remove group expense rows +++++
1339: DELETE FROM FA_ADJUSTMENTS
1340: WHERE ASSET_ID = l_asset_hdr_rec.asset_id
1341: AND BOOK_TYPE_CODE = l_asset_hdr_rec.book_type_code
1342: AND TRANSACTION_HEADER_ID = l_trans_rec.member_transaction_header_id
1343: AND SOURCE_TYPE_CODE = 'DEPRECIATION'

Line 2246: FROM FA_ADJUSTMENTS_MRC_V

2242: ANNUALIZED_ADJUSTMENT,
2243: PERIOD_COUNTER_ADJUSTED,
2244: PERIOD_COUNTER_CREATED,
2245: ASSET_INVOICE_ID
2246: FROM FA_ADJUSTMENTS_MRC_V
2247: WHERE TRANSACTION_HEADER_ID = l_group_thid
2248: AND ASSET_ID = l_group_asset_id
2249: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
2250: AND PERIOD_COUNTER_CREATED = l_period_rec.period_counter

Line 2267: FROM FA_ADJUSTMENTS

2263: ANNUALIZED_ADJUSTMENT,
2264: PERIOD_COUNTER_ADJUSTED,
2265: PERIOD_COUNTER_CREATED,
2266: ASSET_INVOICE_ID
2267: FROM FA_ADJUSTMENTS
2268: WHERE TRANSACTION_HEADER_ID = l_group_thid
2269: AND ASSET_ID = l_group_asset_id
2270: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
2271: AND PERIOD_COUNTER_CREATED = l_period_rec.period_counter

Line 3181: UPDATE FA_ADJUSTMENTS_MRC_V

3177: end if;
3178:
3179:
3180: if (p_mrc_sob_type_code = 'R') then
3181: UPDATE FA_ADJUSTMENTS_MRC_V
3182: SET TRANSACTION_HEADER_ID = l_trans_rec.transaction_header_id
3183: WHERE TRANSACTION_HEADER_ID = l_trans_rec.member_transaction_header_id
3184: AND ASSET_ID = l_asset_hdr_rec.asset_id
3185: AND BOOK_TYPE_CODE = l_asset_hdr_rec.book_type_code;

Line 3187: UPDATE FA_ADJUSTMENTS

3183: WHERE TRANSACTION_HEADER_ID = l_trans_rec.member_transaction_header_id
3184: AND ASSET_ID = l_asset_hdr_rec.asset_id
3185: AND BOOK_TYPE_CODE = l_asset_hdr_rec.book_type_code;
3186: else
3187: UPDATE FA_ADJUSTMENTS
3188: SET TRANSACTION_HEADER_ID = l_trans_rec.transaction_header_id
3189: WHERE TRANSACTION_HEADER_ID = l_trans_rec.member_transaction_header_id
3190: AND ASSET_ID = l_asset_hdr_rec.asset_id
3191: AND BOOK_TYPE_CODE = l_asset_hdr_rec.book_type_code;

Line 3302: -- and RESERVE to fa_adjustments table.

3298: l_deprn_reserve,p_log_level_rec);
3299: end if;
3300:
3301: -- If remaining resrve is not 0, insert NBV RETIRED GAIN/LOSS,
3302: -- and RESERVE to fa_adjustments table.
3303: -- update terminal gain loss amount in fa_books
3304: if (nvl(l_deprn_reserve, 0) <> 0) then
3305:
3306: if (p_log_level_rec.statement_level) then

Line 3595: UPDATE FA_ADJUSTMENTS

3591: l_asset_fin_rec_adj.allowed_deprn_limit_amount :=
3592: nvl(l_asset_fin_rec_new_m.allowed_deprn_limit_amount, 0) -
3593: nvl(p_bk.allowed_deprn_limit_amount, 0);
3594:
3595: UPDATE FA_ADJUSTMENTS
3596: SET TRANSACTION_HEADER_ID = l_trans_rec.transaction_header_id
3597: WHERE TRANSACTION_HEADER_ID = l_trans_rec.member_transaction_header_id
3598: AND ASSET_ID = l_asset_hdr_rec.asset_id
3599: AND BOOK_TYPE_CODE = l_asset_hdr_rec.book_type_code;

Line 3638: DELETE FROM FA_ADJUSTMENTS

3634: l_asset_hdr_rec.asset_id,p_log_level_rec);
3635: end if;
3636:
3637: -- +++++ Remove group expense rows +++++
3638: DELETE FROM FA_ADJUSTMENTS
3639: WHERE ASSET_ID = l_asset_hdr_rec.asset_id
3640: AND BOOK_TYPE_CODE = l_asset_hdr_rec.book_type_code
3641: AND TRANSACTION_HEADER_ID = l_trans_rec.member_transaction_header_id
3642: AND SOURCE_TYPE_CODE = 'DEPRECIATION'

Line 4371: FROM FA_ADJUSTMENTS AJ

4367: AND PERIOD_COUNTER = p_period_rec.period_counter;
4368:
4369: CURSOR C_GET_GROUP_RSV_RET IS
4370: SELECT sum(decode(AJ.DEBIT_CREDIT_FLAG, 'CR', -1, 1)*AJ.ADJUSTMENT_AMOUNT)
4371: FROM FA_ADJUSTMENTS AJ
4372: WHERE AJ.ASSET_ID = p_asset_hdr_rec.asset_id
4373: AND AJ.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4374: AND AJ.TRANSACTION_HEADER_ID = p_trans_rec.transaction_header_id;
4375:

Line 4378: FROM FA_ADJUSTMENTS AJ

4374: AND AJ.TRANSACTION_HEADER_ID = p_trans_rec.transaction_header_id;
4375:
4376: CURSOR C_MC_GET_GROUP_RSV_RET IS
4377: SELECT sum(decode(AJ.DEBIT_CREDIT_FLAG, 'CR', -1, 1)*AJ.ADJUSTMENT_AMOUNT)
4378: FROM FA_ADJUSTMENTS AJ
4379: WHERE AJ.ASSET_ID = p_asset_hdr_rec.asset_id
4380: AND AJ.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4381: AND AJ.TRANSACTION_HEADER_ID = p_trans_rec.transaction_header_id;
4382:

Line 4464: , fa_adjustments aj

4460: , bk.adjusted_recoverable_cost
4461: , sum(aj.adjustment_amount)
4462: from fa_transaction_headers th -- member
4463: , fa_transaction_headers gth -- group
4464: , fa_adjustments aj
4465: , fa_deprn_periods dp
4466: , fa_additions_b ad
4467: , fa_books bk
4468: where th.book_type_code = p_asset_hdr_rec.book_type_code

Line 4757: -- call faxinaj to create records in FA_ADJUSTMENTS table

4753:
4754:
4755: l_loc := 'Before ADJ LOOP';
4756: -- Prepare non-common FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT parameters and
4757: -- call faxinaj to create records in FA_ADJUSTMENTS table
4758: if (p_log_level_rec.statement_level) then
4759: fa_debug_pkg.add(l_calling_fn, 'Before ADJ LOOP', t_asset_id(1),p_log_level_rec);
4760: fa_debug_pkg.add(l_calling_fn, 't_asset_id.last', t_asset_id.last,p_log_level_rec);
4761: end if;

Line 5554: UPDATE FA_ADJUSTMENTS_MRC_V

5550:
5551: -- Need to backout some reserve so do that from last processed asset
5552:
5553: if (p_mrc_sob_type_code = 'R') then
5554: UPDATE FA_ADJUSTMENTS_MRC_V
5555: SET ADJUSTMENT_AMOUNT = ADJUSTMENT_AMOUNT + l_reallocate_amount
5556: WHERE ASSET_ID = l_last_asset_id
5557: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5558: AND TRANSACTION_HEADER_ID = l_last_thid

Line 5560: FROM FA_ADJUSTMENTS_MRC_V

5556: WHERE ASSET_ID = l_last_asset_id
5557: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5558: AND TRANSACTION_HEADER_ID = l_last_thid
5559: AND DISTRIBUTION_ID = (SELECT MIN(DISTRIBUTION_ID)
5560: FROM FA_ADJUSTMENTS_MRC_V
5561: WHERE ASSET_ID = l_last_asset_id
5562: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5563: AND TRANSACTION_HEADER_ID = l_last_thid);
5564:

Line 5579: UPDATE FA_ADJUSTMENTS

5575: UPDATE FA_BOOKS_MRC_V
5576: SET ADJUSTED_COST = ADJUSTED_COST + l_reallocate_amount
5577: WHERE TRANSACTION_HEADER_ID_IN = l_last_thid;
5578: else
5579: UPDATE FA_ADJUSTMENTS
5580: SET ADJUSTMENT_AMOUNT = ADJUSTMENT_AMOUNT + l_reallocate_amount
5581: WHERE ASSET_ID = l_last_asset_id
5582: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5583: AND TRANSACTION_HEADER_ID = l_last_thid

Line 5585: FROM FA_ADJUSTMENTS

5581: WHERE ASSET_ID = l_last_asset_id
5582: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5583: AND TRANSACTION_HEADER_ID = l_last_thid
5584: AND DISTRIBUTION_ID = (SELECT MIN(DISTRIBUTION_ID)
5585: FROM FA_ADJUSTMENTS
5586: WHERE ASSET_ID = l_last_asset_id
5587: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5588: AND TRANSACTION_HEADER_ID = l_last_thid);
5589:

Line 5617: UPDATE FA_ADJUSTMENTS_MRC_V

5613:
5614: -- This asset can take all hit
5615:
5616: if (p_mrc_sob_type_code = 'R') then
5617: UPDATE FA_ADJUSTMENTS_MRC_V
5618: SET ADJUSTMENT_AMOUNT = ADJUSTMENT_AMOUNT + l_reallocate_amount
5619: WHERE ASSET_ID = t_asset_id(i)
5620: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5621: AND TRANSACTION_HEADER_ID = t_thid(i)

Line 5623: FROM FA_ADJUSTMENTS_MRC_V

5619: WHERE ASSET_ID = t_asset_id(i)
5620: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5621: AND TRANSACTION_HEADER_ID = t_thid(i)
5622: AND DISTRIBUTION_ID = (SELECT MIN(DISTRIBUTION_ID)
5623: FROM FA_ADJUSTMENTS_MRC_V
5624: WHERE ASSET_ID = t_asset_id(i)
5625: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5626: AND TRANSACTION_HEADER_ID = t_thid(i));
5627:

Line 5642: UPDATE FA_ADJUSTMENTS

5638: UPDATE FA_BOOKS_MRC_V
5639: SET ADJUSTED_COST = ADJUSTED_COST + l_reallocate_amount
5640: WHERE TRANSACTION_HEADER_ID_IN = t_thid(i);
5641: else
5642: UPDATE FA_ADJUSTMENTS
5643: SET ADJUSTMENT_AMOUNT = ADJUSTMENT_AMOUNT + l_reallocate_amount
5644: WHERE ASSET_ID = t_asset_id(i)
5645: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5646: AND TRANSACTION_HEADER_ID = t_thid(i)

Line 5648: FROM FA_ADJUSTMENTS

5644: WHERE ASSET_ID = t_asset_id(i)
5645: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5646: AND TRANSACTION_HEADER_ID = t_thid(i)
5647: AND DISTRIBUTION_ID = (SELECT MIN(DISTRIBUTION_ID)
5648: FROM FA_ADJUSTMENTS
5649: WHERE ASSET_ID = t_asset_id(i)
5650: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5651: AND TRANSACTION_HEADER_ID = t_thid(i));
5652:

Line 5679: UPDATE FA_ADJUSTMENTS_MRC_V

5675: -- fully reserved. After this, still need to look for another asset to allocate
5676: -- remaining excess amount.
5677:
5678: if (p_mrc_sob_type_code = 'R') then
5679: UPDATE FA_ADJUSTMENTS_MRC_V
5680: SET ADJUSTMENT_AMOUNT = ADJUSTMENT_AMOUNT + t_adjusted_recoverable_cost(i) - t_new_deprn_reserve(i)
5681: WHERE ASSET_ID = t_asset_id(i)
5682: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5683: AND TRANSACTION_HEADER_ID = t_thid(i)

Line 5685: FROM FA_ADJUSTMENTS_MRC_V

5681: WHERE ASSET_ID = t_asset_id(i)
5682: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5683: AND TRANSACTION_HEADER_ID = t_thid(i)
5684: AND DISTRIBUTION_ID = (SELECT MIN(DISTRIBUTION_ID)
5685: FROM FA_ADJUSTMENTS_MRC_V
5686: WHERE ASSET_ID = t_asset_id(i)
5687: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5688: AND TRANSACTION_HEADER_ID = t_thid(i));
5689:

Line 5705: UPDATE FA_ADJUSTMENTS

5701: UPDATE FA_BOOKS_MRC_V
5702: SET ADJUSTED_COST = RECOVERABLE_COST - ADJUSTED_RECOVERABLE_COST
5703: WHERE TRANSACTION_HEADER_ID_IN = t_thid(i);
5704: else
5705: UPDATE FA_ADJUSTMENTS
5706: SET ADJUSTMENT_AMOUNT = ADJUSTMENT_AMOUNT + t_adjusted_recoverable_cost(i) - t_new_deprn_reserve(i)
5707: WHERE ASSET_ID = t_asset_id(i)
5708: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5709: AND TRANSACTION_HEADER_ID = t_thid(i)

Line 5711: FROM FA_ADJUSTMENTS

5707: WHERE ASSET_ID = t_asset_id(i)
5708: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5709: AND TRANSACTION_HEADER_ID = t_thid(i)
5710: AND DISTRIBUTION_ID = (SELECT MIN(DISTRIBUTION_ID)
5711: FROM FA_ADJUSTMENTS
5712: WHERE ASSET_ID = t_asset_id(i)
5713: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5714: AND TRANSACTION_HEADER_ID = t_thid(i));
5715:

Line 5796: UPDATE FA_ADJUSTMENTS_MRC_V

5792:
5793: if (t_adjusted_cost(i) >= l_reallocate_amount) then
5794:
5795: if (p_mrc_sob_type_code = 'R') then
5796: UPDATE FA_ADJUSTMENTS_MRC_V
5797: SET ADJUSTMENT_AMOUNT = ADJUSTMENT_AMOUNT + l_reallocate_amount
5798: WHERE ASSET_ID = t_asset_id(i)
5799: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5800: AND TRANSACTION_HEADER_ID = t_thid(i)

Line 5802: FROM FA_ADJUSTMENTS_MRC_V

5798: WHERE ASSET_ID = t_asset_id(i)
5799: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5800: AND TRANSACTION_HEADER_ID = t_thid(i)
5801: AND DISTRIBUTION_ID = (SELECT MIN(DISTRIBUTION_ID)
5802: FROM FA_ADJUSTMENTS_MRC_V
5803: WHERE ASSET_ID = t_asset_id(i)
5804: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5805: AND TRANSACTION_HEADER_ID = t_thid(i));
5806:

Line 5821: UPDATE FA_ADJUSTMENTS

5817: UPDATE FA_BOOKS_MRC_V
5818: SET ADJUSTED_COST = ADJUSTED_COST + l_reallocate_amount
5819: WHERE TRANSACTION_HEADER_ID_IN = t_thid(i);
5820: else
5821: UPDATE FA_ADJUSTMENTS
5822: SET ADJUSTMENT_AMOUNT = ADJUSTMENT_AMOUNT + l_reallocate_amount
5823: WHERE ASSET_ID = t_asset_id(i)
5824: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5825: AND TRANSACTION_HEADER_ID = t_thid(i)

Line 5827: FROM FA_ADJUSTMENTS

5823: WHERE ASSET_ID = t_asset_id(i)
5824: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5825: AND TRANSACTION_HEADER_ID = t_thid(i)
5826: AND DISTRIBUTION_ID = (SELECT MIN(DISTRIBUTION_ID)
5827: FROM FA_ADJUSTMENTS
5828: WHERE ASSET_ID = t_asset_id(i)
5829: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5830: AND TRANSACTION_HEADER_ID = t_thid(i));
5831:

Line 5852: UPDATE FA_ADJUSTMENTS_MRC_V

5848:
5849: else
5850:
5851: if (p_mrc_sob_type_code = 'R') then
5852: UPDATE FA_ADJUSTMENTS_MRC_V
5853: SET ADJUSTMENT_AMOUNT = ADJUSTMENT_AMOUNT + t_adjusted_cost(i)
5854: WHERE ASSET_ID = t_asset_id(i)
5855: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5856: AND TRANSACTION_HEADER_ID = t_thid(i)

Line 5858: FROM FA_ADJUSTMENTS_MRC_V

5854: WHERE ASSET_ID = t_asset_id(i)
5855: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5856: AND TRANSACTION_HEADER_ID = t_thid(i)
5857: AND DISTRIBUTION_ID = (SELECT MIN(DISTRIBUTION_ID)
5858: FROM FA_ADJUSTMENTS_MRC_V
5859: WHERE ASSET_ID = t_asset_id(i)
5860: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5861: AND TRANSACTION_HEADER_ID = t_thid(i));
5862:

Line 5876: UPDATE FA_ADJUSTMENTS

5872: UPDATE FA_BOOKS_MRC_V
5873: SET ADJUSTED_COST = RECOVERABLE_COST - ADJUSTED_RECOVERABLE_COST
5874: WHERE TRANSACTION_HEADER_ID_IN = t_thid(i);
5875: else
5876: UPDATE FA_ADJUSTMENTS
5877: SET ADJUSTMENT_AMOUNT = ADJUSTMENT_AMOUNT + t_adjusted_cost(i)
5878: WHERE ASSET_ID = t_asset_id(i)
5879: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5880: AND TRANSACTION_HEADER_ID = t_thid(i)

Line 5882: FROM FA_ADJUSTMENTS

5878: WHERE ASSET_ID = t_asset_id(i)
5879: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5880: AND TRANSACTION_HEADER_ID = t_thid(i)
5881: AND DISTRIBUTION_ID = (SELECT MIN(DISTRIBUTION_ID)
5882: FROM FA_ADJUSTMENTS
5883: WHERE ASSET_ID = t_asset_id(i)
5884: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5885: AND TRANSACTION_HEADER_ID = t_thid(i));
5886: