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_SORP_REVALUATION_PKG dependencies on FA_SORP_ASSET_LINK_REVAL_V

Line 432: v_book_type_code FA_SORP_ASSET_LINK_REVAL_V.book_type_code%TYPE;

428: RETURN NUMBER
429: IS
430: -- Local variables declaration
431: v_deprn_cnt NUMBER;
432: v_book_type_code FA_SORP_ASSET_LINK_REVAL_V.book_type_code%TYPE;
433: v_asset_id FA_SORP_ASSET_LINK_REVAL_V.asset_id%TYPE;
434: v_deprn_amount NUMBER;
435: v_deprn_reserve NUMBER;
436: v_period_name VARCHAR2 (25);

Line 433: v_asset_id FA_SORP_ASSET_LINK_REVAL_V.asset_id%TYPE;

429: IS
430: -- Local variables declaration
431: v_deprn_cnt NUMBER;
432: v_book_type_code FA_SORP_ASSET_LINK_REVAL_V.book_type_code%TYPE;
433: v_asset_id FA_SORP_ASSET_LINK_REVAL_V.asset_id%TYPE;
434: v_deprn_amount NUMBER;
435: v_deprn_reserve NUMBER;
436: v_period_name VARCHAR2 (25);
437: v_period_counter_impaired NUMBER;

Line 1042: v_impairment_id FA_SORP_ASSET_LINK_REVAL_V.impairment_id%TYPE;

1038: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1039: IS
1040: -- Local Varibales declaration
1041: v_sum NUMBER; -- sum of impairments
1042: v_impairment_id FA_SORP_ASSET_LINK_REVAL_V.impairment_id%TYPE;
1043: v_book_type_code FA_SORP_ASSET_LINK_REVAL_V.book_type_code%TYPE;
1044: v_asset_id FA_SORP_ASSET_LINK_REVAL_V.asset_id%TYPE;
1045: v_IMP_LOSS_AMOUNT FA_SORP_ASSET_LINK_REVAL_V.IMP_LOSS_AMOUNT%Type;
1046: V_SPLIT_IMPAIR_FLAG varchar2(3);

Line 1043: v_book_type_code FA_SORP_ASSET_LINK_REVAL_V.book_type_code%TYPE;

1039: IS
1040: -- Local Varibales declaration
1041: v_sum NUMBER; -- sum of impairments
1042: v_impairment_id FA_SORP_ASSET_LINK_REVAL_V.impairment_id%TYPE;
1043: v_book_type_code FA_SORP_ASSET_LINK_REVAL_V.book_type_code%TYPE;
1044: v_asset_id FA_SORP_ASSET_LINK_REVAL_V.asset_id%TYPE;
1045: v_IMP_LOSS_AMOUNT FA_SORP_ASSET_LINK_REVAL_V.IMP_LOSS_AMOUNT%Type;
1046: V_SPLIT_IMPAIR_FLAG varchar2(3);
1047: v_mass_reval_id FA_SORP_ASSET_LINK_REVAL_V.mass_reval_id%TYPE;

Line 1044: v_asset_id FA_SORP_ASSET_LINK_REVAL_V.asset_id%TYPE;

1040: -- Local Varibales declaration
1041: v_sum NUMBER; -- sum of impairments
1042: v_impairment_id FA_SORP_ASSET_LINK_REVAL_V.impairment_id%TYPE;
1043: v_book_type_code FA_SORP_ASSET_LINK_REVAL_V.book_type_code%TYPE;
1044: v_asset_id FA_SORP_ASSET_LINK_REVAL_V.asset_id%TYPE;
1045: v_IMP_LOSS_AMOUNT FA_SORP_ASSET_LINK_REVAL_V.IMP_LOSS_AMOUNT%Type;
1046: V_SPLIT_IMPAIR_FLAG varchar2(3);
1047: v_mass_reval_id FA_SORP_ASSET_LINK_REVAL_V.mass_reval_id%TYPE;
1048: v_reverse_imp_amt FA_SORP_ASSET_LINK_REVAL_V.unused_imp_loss_amount%TYPE;

Line 1045: v_IMP_LOSS_AMOUNT FA_SORP_ASSET_LINK_REVAL_V.IMP_LOSS_AMOUNT%Type;

1041: v_sum NUMBER; -- sum of impairments
1042: v_impairment_id FA_SORP_ASSET_LINK_REVAL_V.impairment_id%TYPE;
1043: v_book_type_code FA_SORP_ASSET_LINK_REVAL_V.book_type_code%TYPE;
1044: v_asset_id FA_SORP_ASSET_LINK_REVAL_V.asset_id%TYPE;
1045: v_IMP_LOSS_AMOUNT FA_SORP_ASSET_LINK_REVAL_V.IMP_LOSS_AMOUNT%Type;
1046: V_SPLIT_IMPAIR_FLAG varchar2(3);
1047: v_mass_reval_id FA_SORP_ASSET_LINK_REVAL_V.mass_reval_id%TYPE;
1048: v_reverse_imp_amt FA_SORP_ASSET_LINK_REVAL_V.unused_imp_loss_amount%TYPE;
1049: -- Amount to be reversed

Line 1047: v_mass_reval_id FA_SORP_ASSET_LINK_REVAL_V.mass_reval_id%TYPE;

1043: v_book_type_code FA_SORP_ASSET_LINK_REVAL_V.book_type_code%TYPE;
1044: v_asset_id FA_SORP_ASSET_LINK_REVAL_V.asset_id%TYPE;
1045: v_IMP_LOSS_AMOUNT FA_SORP_ASSET_LINK_REVAL_V.IMP_LOSS_AMOUNT%Type;
1046: V_SPLIT_IMPAIR_FLAG varchar2(3);
1047: v_mass_reval_id FA_SORP_ASSET_LINK_REVAL_V.mass_reval_id%TYPE;
1048: v_reverse_imp_amt FA_SORP_ASSET_LINK_REVAL_V.unused_imp_loss_amount%TYPE;
1049: -- Amount to be reversed
1050: l_adj_amt NUMBER;
1051: -- Delta value NBV(Reval) - NBV(Current)

Line 1048: v_reverse_imp_amt FA_SORP_ASSET_LINK_REVAL_V.unused_imp_loss_amount%TYPE;

1044: v_asset_id FA_SORP_ASSET_LINK_REVAL_V.asset_id%TYPE;
1045: v_IMP_LOSS_AMOUNT FA_SORP_ASSET_LINK_REVAL_V.IMP_LOSS_AMOUNT%Type;
1046: V_SPLIT_IMPAIR_FLAG varchar2(3);
1047: v_mass_reval_id FA_SORP_ASSET_LINK_REVAL_V.mass_reval_id%TYPE;
1048: v_reverse_imp_amt FA_SORP_ASSET_LINK_REVAL_V.unused_imp_loss_amount%TYPE;
1049: -- Amount to be reversed
1050: l_adj_amt NUMBER;
1051: -- Delta value NBV(Reval) - NBV(Current)
1052: l_new_reverse_amt NUMBER;

Line 1119: FROM fa_sorp_asset_link_reval_v

1115: ) calc_imp_deprn_effect, --(depreciation impact on the I/E)
1116: impair_loss_acct, NULL category_id,
1117: reval_reserve_impact_flag, NVL (reval_rsv_adj_amount, 0),
1118: impair_class, reason
1119: FROM fa_sorp_asset_link_reval_v
1120: WHERE asset_id = p_asset_id
1121: AND book_type_code = p_book_type_code
1122: AND mass_reval_id = p_mass_reval_id
1123: AND imp_include_flag = 'Y'

Line 2118: FROM fa_sorp_asset_link_reval_v

2114: FROM FA_DEPRN_PERIODS
2115: WHERE book_type_code = p_asset_hdr_rec.book_type_code
2116: AND period_name in
2117: (SELECT fa_period
2118: FROM fa_sorp_asset_link_reval_v
2119: WHERE asset_id = p_asset_hdr_rec.asset_id
2120: AND book_type_code = p_asset_hdr_rec.book_type_code
2121: AND mass_reval_id = p_reval_options_rec.mass_reval_id);
2122:

Line 2126: fa_sorp_asset_link_reval_v salrv

2122:
2123: CURSOR c_get_imp_pc_c is
2124: SELECT period_counter
2125: FROM FA_DEPRN_PERIODS fdp,
2126: fa_sorp_asset_link_reval_v salrv
2127: WHERE fdp.book_type_code = p_asset_hdr_rec.book_type_code
2128: AND salrv.asset_id = p_asset_hdr_rec.asset_id
2129: AND salrv.book_type_code = p_asset_hdr_rec.book_type_code
2130: AND salrv.mass_reval_id = p_reval_options_rec.mass_reval_id