[Home] [Help]
57: ,r.units
58: into l_ret_id_in_corp
59: ,l_units_retired
60: from fa_transaction_headers sth
61: ,fa_retirements r
62: ,fa_book_controls bc
63: where sth.transaction_header_id = RET.th_id_in
64: and sth.asset_id = RET.asset_id
65: and sth.book_type_code = RET.book
89: from fa_distribution_history
90: where retirement_id =
91: (select r.retirement_id
92: from fa_transaction_headers sth
93: ,fa_retirements r
94: where sth.transaction_header_id = RET.th_id_in
95: and sth.asset_id = RET.asset_id
96: and sth.book_type_code = RET.book
97: and r.asset_id = sth.asset_id
339:
340: SELECT (MONTHS_BETWEEN(trunc(h_date_retired),
341: trunc(h_date_placed)) / 12) + 1
342: INTO h_years_kept
343: FROM FA_RETIREMENTS
344: WHERE RETIREMENT_ID = h_retirement_id;
345:
346: begin
347: SELECT farecap.itc_recapture_id ,
370: RAISE fagitc_err;
371: end if;
372:
373: if (ret.mrc_sob_type_code <> 'R') then
374: UPDATE fa_retirements fr
375: SET fr.itc_recaptured = h_recaptured,
376: fr.itc_recapture_id = h_itc_recapture_id
377: WHERE fr.retirement_id = h_retirement_id;
378: else
405: | NAME fagurt |
406: | |
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 |
954: return(FALSE);
955: end if;
956:
957: if (ret.mrc_sob_type_code <> 'R') then
958: UPDATE fa_retirements fr
959: SET fr.nbv_retired = nvl(h_g_nbv_retired, h_nbv_retired), --Bug11886090
960: fr.gain_loss_amount = h_gain_loss,
961: fr.stl_deprn_amount = h_stl_deprn,
962: fr.reval_reserve_retired = h_reval_rsv_retired,
3302: p_pers_per_yr <> 365 then
3303:
3304: select ( cp1.period_num) ,( cp2.period_num)
3305: into h_new_ret_pn,h_old_ret_pn
3306: from fa_retirements new_ret
3307: ,fa_conventions conv
3308: ,fa_calendar_periods cp1
3309: ,fa_retirements old_ret
3310: ,fa_conventions conv2
3305: into h_new_ret_pn,h_old_ret_pn
3306: from fa_retirements new_ret
3307: ,fa_conventions conv
3308: ,fa_calendar_periods cp1
3309: ,fa_retirements old_ret
3310: ,fa_conventions conv2
3311: ,fa_calendar_periods cp2
3312: where new_ret.transaction_header_id_in=ret.th_id_in
3313: and conv.prorate_convention_code=new_ret.retirement_prorate_convention
3749: into h_old_reinst_pc
3750: ,h_old_ret_pc
3751: from fa_transaction_headers trx,
3752: fa_deprn_periods dp1,
3753: fa_retirements old_ret,
3754: fa_deprn_periods dp2,
3755: fa_conventions conv
3756: where trx.transaction_header_id = h_old_reinst_trx_id
3757: and dp1.book_type_code = trx.book_type_code
3765: and dp2.CALENDAR_PERIOD_CLOSE_DATE;
3766:
3767: select dp.period_counter
3768: into h_ret_prorate_pc
3769: from fa_retirements new_ret
3770: ,fa_conventions conv
3771: ,fa_deprn_periods dp
3772: where new_ret.transaction_header_id_in=ret.th_id_in
3773: and conv.prorate_convention_code=new_ret.retirement_prorate_convention
4255: h_dwacq, h_rate_source_rule
4256: FROM FA_FISCAL_YEAR fy1,
4257: FA_FISCAL_YEAR fy2,
4258: FA_BOOKS bk,
4259: FA_RETIREMENTS rt,
4260: FA_CONVENTION_TYPES ctype,
4261: FA_METHODS mt,
4262: FA_BOOK_CONTROLS bc
4263: WHERE rt.date_retired between
6426:
6427: begin
6428: select retirement_id
6429: into l_id
6430: from fa_retirements
6431: where asset_id=ret.asset_id
6432: and book_type_code=ret.book;
6433: exception when others then null;
6434: l_id := 0;