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_GAINLOSS_UPD_PKG dependencies on FA_ADJUSTMENTS

Line 121: from fa_adjustments

117:
118: if nvl(ret.mrc_sob_type_code,'P') <> 'R' then
119: select count(*)
120: into l_balance_tfr_in_tax
121: from fa_adjustments
122: where book_type_code = RET.book
123: and asset_id = RET.asset_id
124: and transaction_header_id = l_id_out -- Corp's TRANSFER OUT THID
125: and source_type_code in ('TRANSFER', 'RETIREMENT')

Line 174: from fa_adjustments

170: and transaction_header_id_out is NULL
171: and rownum = 1
172: and distribution_id =
173: nvl((select max(distribution_id)
174: from fa_adjustments
175: where book_type_code = RET.book
176: and asset_id = RET.asset_id
177: and adjustment_amount <> 0
178: and transaction_header_id < RET.th_id_in

Line 411: | FA_ADJUSTMENTS table. |

407: | FUNCTION |
408: | It calculates GAIN/LOSS, NBV_RETIRED, STL_DEPRN_AMOUNT. Update the |
409: | status in FA_RETIREMENTS table from 'PENDING' to 'PROCESSED'. It |
410: | also inserts GAIN/LOSS, PROCEEDS_OF_SALE, and COST_OF_REMOVAL to |
411: | FA_ADJUSTMENTS table. |
412: | |
413: | HISTORY 01/12/89 R Rumanang Created |
414: | 08/30/89 R Rumanang Updated to insert to |
415: | FA_ADJUSTMENTS. |

Line 415: | FA_ADJUSTMENTS. |

411: | FA_ADJUSTMENTS table. |
412: | |
413: | HISTORY 01/12/89 R Rumanang Created |
414: | 08/30/89 R Rumanang Updated to insert to |
415: | FA_ADJUSTMENTS. |
416: | 01/31/90 R Rumanang Insert PROCEEDS_OF_SALE to |
417: | ADJUSTMENT |
418: | 05/03/91 M Chan Rewrote for MPL 9 |
419: | 12/30/96 S Behura Rewriting in PL/SQL |

Line 561: from fa_adjustments adj

557: AND bc.book_class = 'TAX'
558: AND dist.BOOK_TYPE_CODE = bc.distribution_source_book
559: AND dist.transaction_header_id_in =
560: (select max(adj.transaction_header_id) -- get the latest THID in the same period that caused DIST ID to change
561: from fa_adjustments adj
562: where adj.book_type_code = RET.book
563: and adj.asset_id = RET.asset_id
564: and adj.source_type_code in ('RETIREMENT', 'TRANSFER') -- RETIREMENT: balance tfr for Reinstatement, TRANSFER: balance tfr for Retirement
565: and adj.period_counter_created = cpd_ctr

Line 601: FROM FA_ADJUSTMENTS

597: 'CR', ADJUSTMENT_AMOUNT,
598: -1 * ADJUSTMENT_AMOUNT), 0)*
599: DECODE(ADJUSTMENT_TYPE, 'RESERVE', -1,
600: 'IMPAIR RESERVE', -1, 1)) --hh: 6867027
601: FROM FA_ADJUSTMENTS
602: WHERE (DISTRIBUTION_ID = c_dist_id
603: OR DISTRIBUTION_ID = c_new_dist_id)
604: AND BOOK_TYPE_CODE = ret.book
605: AND PERIOD_COUNTER_CREATED = cpd_ctr

Line 647: from fa_adjustments

643: -- FA_RETIREMENT_PVT.Do_Retirement_in_CGL
644: --
645: CURSOR c_get_g_rsv_ret is
646: select adjustment_amount
647: from fa_adjustments
648: where asset_id = bk.group_asset_id
649: and book_type_code = ret.book
650: and transaction_header_id = ret.th_id_in
651: and adjustment_type = 'RESERVE';

Line 668: from fa_adjustments

664: ,'COST', decode(debit_credit_flag,'CR', nvl(adjustment_amount,0), -1 * nvl(adjustment_amount,0))
665: ,'RESERVE', decode(debit_credit_flag,'DR', -1 * nvl(adjustment_amount,0), nvl(adjustment_amount,0))
666: ,'IMPAIR RESERVE', decode(debit_credit_flag,'DR', -1 * nvl(adjustment_amount,0), nvl(adjustment_amount,0))
667: ,0))
668: from fa_adjustments
669: where asset_id = ret.asset_id
670: and book_type_code = ret.book
671: and transaction_header_id = ret.th_id_in
672: and source_type_code='RETIREMENT'

Line 1945: | FUNCTION Add a cost retired adjustment into FA_ADJUSTMENTS. Credit to |

1941:
1942: /*===========================================================================*
1943: | NAME fagpct |
1944: | |
1945: | FUNCTION Add a cost retired adjustment into FA_ADJUSTMENTS. Credit to |
1946: | the asset account. |
1947: | |
1948: | HISTORY 08/30/89 R Rumanang Created |
1949: | 05/03/91 M Chan Rewrote for MPL 9 |

Line 2210: | insert them into fa_adjustments table. |

2206: | |
2207: | Function |
2208: | This function is to calculate the back out deprn_expense, |
2209: | reval_expense, and reval_amort we have taken so far and |
2210: | insert them into fa_adjustments table. |
2211: | |
2212: | History 11/13/92 L. Sun Created |
2213: | |
2214: | 12/31/96 S. Behura Rewrote into PL/SQL |

Line 2426: fa_adjustments faadj

2422: FROM
2423: fa_distribution_history fadh,
2424: fa_deprn_detail fadd,
2425: fa_deprn_periods fadp,
2426: fa_adjustments faadj
2427: WHERE
2428: fadd.asset_id = h_asset_id
2429: AND fadd.distribution_id = fadh.distribution_id
2430: AND fadd.book_type_code = h_book

Line 2474: fa_adjustments faadj

2470: faadj.transaction_header_id
2471: FROM
2472: fa_distribution_history fadh,
2473: fa_deprn_periods fadp,
2474: fa_adjustments faadj
2475: WHERE
2476: fadp.period_num = h_i
2477: AND fadp.book_type_code = h_book
2478: AND fadp.fiscal_year = h_current_fiscal_yr

Line 2762: fa_adjustments faadj

2758: SELECT count(*)
2759: INTO h_ret_count
2760: FROM
2761: fa_deprn_periods fadp,
2762: fa_adjustments faadj
2763: WHERE
2764: fadp.period_num = h_i
2765: AND fadp.book_type_code = h_book
2766: AND fadp.fiscal_year = h_current_fiscal_yr

Line 2778: fa_adjustments faadj

2774: SELECT count(*)
2775: INTO h_adj_count
2776: FROM
2777: fa_deprn_periods fadp,
2778: fa_adjustments faadj
2779: WHERE
2780: fadp.period_num = h_i
2781: AND fadp.book_type_code = h_book
2782: AND fadp.fiscal_year = h_current_fiscal_yr

Line 3542: fa_adjustments adj,

3538:
3539: SELECT sum(nvl(adjustment_amount,0))--bug fix 3905436
3540: INTO h_adj_exp_row
3541: FROM
3542: fa_adjustments adj,
3543: fa_deprn_periods dp,
3544: fa_transaction_headers th
3545: WHERE
3546: th.asset_id = h_asset_id

Line 3692: fa_adjustments adj,

3688:
3689: SELECT sum(adjustment_amount), max(th.transaction_header_id)
3690: INTO h_adj_exp_row, h_old_reinst_trx_id
3691: FROM
3692: fa_adjustments adj,
3693: fa_deprn_periods dp,
3694: fa_transaction_headers th
3695: WHERE
3696: th.asset_id = h_asset_id

Line 4028: * in fa_deprn_detail and adjustment_amount in fa_adjustments

4024: * add to the total backup deprn. The following was required as
4025: * fix for 807256. May not be the most elegant but it works
4026: * without significant redesign of farboe. Always adding
4027: * h_deprn_amount which was the difference between deprn_amount
4028: * in fa_deprn_detail and adjustment_amount in fa_adjustments
4029: * does not work for all the cases. Instead the following
4030: * conditional logic adds the amounts correctly. SNARAYAN
4031: */
4032:

Line 5154: | the FA_ADJUSTMENTS table. |

5150: | FUNCTION |
5151: | |
5152: | This function figures out how much depreciation expense needs to be |
5153: | allocated to each cost center (distribution). It inserts the amount into |
5154: | the FA_ADJUSTMENTS table. |
5155: | If the number of periods to be catchup is negative or the |
5156: | DEPRECIATE_LAST_YEAR_FLAG is set to 'NO', we need to back out depreciation|
5157: | When the flag is set to NO, we need to back out the whole depreciation |
5158: | taken so far this year. |

Line 5163: | 8/24/89 R Rumanang Insert to FA_ADJUSTMENTS |

5159: | |
5160: | |
5161: | HISTORY 1/12/89 R Rumanang Created |
5162: | 6/23/89 R Rumanang Standarized |
5163: | 8/24/89 R Rumanang Insert to FA_ADJUSTMENTS |
5164: | 04/15/91 M Chan Rewritten for MPL 9 |
5165: | 01/02/96 S Behura Rewritten into PL/SQL |
5166: *===========================================================================*/
5167:

Line 5705: -- insert expense into fa_adjustments

5701: end if;
5702: end if;
5703:
5704:
5705: -- insert expense into fa_adjustments
5706: if (NOT FA_INS_ADJUST_PKG.faxinaj(adj_row,
5707: X_last_update_date,
5708: X_last_updated_by,
5709: X_last_update_login,

Line 6030: FROM FA_ADJUSTMENTS faadj

6026: if (ret.mrc_sob_type_code <> 'R') then
6027: begin
6028: SELECT SUM(faadj.adjustment_amount)
6029: INTO h_deprn_amt
6030: FROM FA_ADJUSTMENTS faadj
6031: WHERE
6032: faadj.transaction_header_id = h_th_id_in
6033: AND faadj.source_type_code = 'RETIREMENT'
6034: AND faadj.adjustment_type = 'EXPENSE'

Line 6082: FROM FA_ADJUSTMENTS faadj

6078: if (ret.mrc_sob_type_code <> 'R') then
6079: begin
6080: SELECT SUM(faadj.adjustment_amount)
6081: INTO h_bonus_deprn_amt
6082: FROM FA_ADJUSTMENTS faadj
6083: WHERE
6084: faadj.transaction_header_id = h_th_id_in
6085: AND faadj.source_type_code = 'RETIREMENT'
6086: AND faadj.adjustment_type = 'BONUS EXPENSE'

Line 6104: FROM FA_ADJUSTMENTS faadj

6100:
6101: begin
6102: SELECT SUM(faadj.adjustment_amount)
6103: INTO h_impairment_amt
6104: FROM FA_ADJUSTMENTS faadj
6105: WHERE
6106: faadj.transaction_header_id = h_th_id_in
6107: AND faadj.source_type_code = 'RETIREMENT'
6108: AND faadj.adjustment_type = 'IMPAIR EXPENSE'

Line 6184: FROM FA_ADJUSTMENTS faadj

6180: if (ret.mrc_sob_type_code <> 'R') then
6181: begin
6182: SELECT SUM(faadj.adjustment_amount)
6183: INTO h_reval_deprn_amt
6184: FROM FA_ADJUSTMENTS faadj
6185: WHERE
6186: faadj.transaction_header_id = h_th_id_in
6187: AND faadj.source_type_code = 'RETIREMENT'
6188: AND faadj.adjustment_type = 'REVAL EXPENSE'

Line 6232: FROM FA_ADJUSTMENTS faadj

6228: if (ret.mrc_sob_type_code <> 'R') then
6229: begin
6230: SELECT SUM(faadj.adjustment_amount)
6231: INTO h_reval_amort
6232: FROM FA_ADJUSTMENTS faadj
6233: WHERE
6234: faadj.transaction_header_id = h_th_id_in
6235: AND faadj.source_type_code = 'RETIREMENT'
6236: AND faadj.adjustment_type = 'REVAL AMORT'

Line 6285: | FUNCTION Calculate reserve retired and insert it into FA_ADJUSTMENTS. |

6281:
6282: /*===========================================================================*
6283: | NAME fagprv |
6284: | |
6285: | FUNCTION Calculate reserve retired and insert it into FA_ADJUSTMENTS. |
6286: | It returns the current depreciation reserve before adjusted. |
6287: | |
6288: | HISTORY 08/30/89 R Rumanang Created |
6289: | 11/21/89 R Rumanang Put distribution_id in adjustments |

Line 6325: the RETIREMENT RESERVE DR rows in fa_adjustments for the distributions

6321: and date_ineffective is null;
6322:
6323: /* New Fix for Bug# 2791196
6324: Cleared_reserves cursor will only return
6325: the RETIREMENT RESERVE DR rows in fa_adjustments for the distributions
6326: that are active and that are not the newly created rows
6327: by the partial unit retirement.
6328: The adj_amount for each of the rows will be updated
6329: with that of the corresponding row. */

Line 7075: element => 'Insert fa_adjustments in fagprv2,accnt_type',

7071:
7072: if p_log_level_rec.statement_level then
7073: fa_debug_pkg.add
7074: (fname => l_calling_fn,
7075: element => 'Insert fa_adjustments in fagprv2,accnt_type',
7076: value => adj_row.account_type, p_log_level_rec => p_log_level_rec);
7077: end if;
7078:
7079: if (NOT FA_INS_ADJUST_PKG.faxinaj(adj_row,

Line 7129: element => 'Insert fa_adjustments in fagprv2,accnt_type',

7125:
7126: if p_log_level_rec.statement_level then
7127: fa_debug_pkg.add
7128: (fname => l_calling_fn,
7129: element => 'Insert fa_adjustments in fagprv2,accnt_type',
7130: value => adj_row.account_type, p_log_level_rec => p_log_level_rec);
7131: end if;
7132:
7133: if (NOT FA_INS_ADJUST_PKG.faxinaj(adj_row,