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_REVALUATION_PVT dependencies on FA_STD_TYPES

Line 5: g_dpr_out fa_std_types.dpr_out_struct;

1: PACKAGE BODY fa_revaluation_pvt AS
2: /* $Header: FAVRVLB.pls 120.21.12020000.5 2013/03/29 11:26:22 saalampa ship $ */
3: g_old_nbv NUMBER;
4: g_new_nbv NUMBER;
5: g_dpr_out fa_std_types.dpr_out_struct;
6:
7: FUNCTION do_reval (
8: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
9: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,

Line 27: l_reval_out_rec fa_std_types.reval_out_struct;

23: l_bks_rowid VARCHAR2 (30);
24: l_status BOOLEAN;
25: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
26: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
27: l_reval_out_rec fa_std_types.reval_out_struct;
28: -- rx columns
29: l_concat_cat VARCHAR2 (220);
30: l_cat_segs fa_rx_shared_pkg.seg_array;
31: l_override_defaults VARCHAR2 (80);

Line 57: l_dpr_row FA_STD_TYPES.FA_DEPRN_ROW_STRUCT;

53: l_nbv_old NUMBER := 0;
54: l_nbv_delta NUMBER := 0;
55:
56: /*ER 14644811 */
57: l_dpr_row FA_STD_TYPES.FA_DEPRN_ROW_STRUCT;
58: l_running_mode VARCHAR2(20);
59: l_capital_adj NUMBER;
60: l_general_fund NUMBER;
61:

Line 888: x_reval_out OUT NOCOPY fa_std_types.reval_out_struct

884: px_asset_deprn_rec_new IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
885: p_period_rec IN fa_api_types.period_rec_type,
886: p_mrc_sob_type_code IN VARCHAR2,
887: p_reval_options_rec IN fa_api_types.reval_options_rec_type,
888: x_reval_out OUT NOCOPY fa_std_types.reval_out_struct
889: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
890: RETURN BOOLEAN
891: IS
892: l_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;

Line 904: l_dpr_in fa_std_types.dpr_struct;

900: l_recalc_life NUMBER;
901: l_life_ceiling NUMBER;
902: l_reval_ceiling_flag BOOLEAN;
903: l_fully_rsvd_flag BOOLEAN;
904: l_dpr_in fa_std_types.dpr_struct;
905: l_dpr_out fa_std_types.dpr_out_struct;
906: l_dpr_arr fa_std_types.dpr_arr_type;
907: l_running_mode NUMBER := fa_std_types.fa_dpr_normal;
908: l_reval_amo_basis NUMBER;

Line 905: l_dpr_out fa_std_types.dpr_out_struct;

901: l_life_ceiling NUMBER;
902: l_reval_ceiling_flag BOOLEAN;
903: l_fully_rsvd_flag BOOLEAN;
904: l_dpr_in fa_std_types.dpr_struct;
905: l_dpr_out fa_std_types.dpr_out_struct;
906: l_dpr_arr fa_std_types.dpr_arr_type;
907: l_running_mode NUMBER := fa_std_types.fa_dpr_normal;
908: l_reval_amo_basis NUMBER;
909: l_bonus_deprn_exp NUMBER;

Line 906: l_dpr_arr fa_std_types.dpr_arr_type;

902: l_reval_ceiling_flag BOOLEAN;
903: l_fully_rsvd_flag BOOLEAN;
904: l_dpr_in fa_std_types.dpr_struct;
905: l_dpr_out fa_std_types.dpr_out_struct;
906: l_dpr_arr fa_std_types.dpr_arr_type;
907: l_running_mode NUMBER := fa_std_types.fa_dpr_normal;
908: l_reval_amo_basis NUMBER;
909: l_bonus_deprn_exp NUMBER;
910: l_deprn_exp NUMBER;

Line 907: l_running_mode NUMBER := fa_std_types.fa_dpr_normal;

903: l_fully_rsvd_flag BOOLEAN;
904: l_dpr_in fa_std_types.dpr_struct;
905: l_dpr_out fa_std_types.dpr_out_struct;
906: l_dpr_arr fa_std_types.dpr_arr_type;
907: l_running_mode NUMBER := fa_std_types.fa_dpr_normal;
908: l_reval_amo_basis NUMBER;
909: l_bonus_deprn_exp NUMBER;
910: l_deprn_exp NUMBER;
911: l_impairment_exp NUMBER;

Line 1019: fa_std_types.fad_rsr_flat

1015: RAISE fareven_err;
1016: END IF;
1017:
1018: IF ( fa_cache_pkg.fazccmt_record.rate_source_rule =
1019: fa_std_types.fad_rsr_flat
1020: AND l_fully_rsvd_flag
1021: )
1022: THEN
1023: x_reval_out.insert_txn_flag := FALSE;

Line 1032: IF (NVL (l_polish_rule, fa_std_types.fad_dbr_polish_none) IN

1028: THEN
1029: l_polish_rule := fa_cache_pkg.fazcdbr_record.polish_rule;
1030: END IF;
1031:
1032: IF (NVL (l_polish_rule, fa_std_types.fad_dbr_polish_none) IN
1033: (fa_std_types.fad_dbr_polish_1,
1034: fa_std_types.fad_dbr_polish_2,
1035: fa_std_types.fad_dbr_polish_3,
1036: fa_std_types.fad_dbr_polish_4,

Line 1033: (fa_std_types.fad_dbr_polish_1,

1029: l_polish_rule := fa_cache_pkg.fazcdbr_record.polish_rule;
1030: END IF;
1031:
1032: IF (NVL (l_polish_rule, fa_std_types.fad_dbr_polish_none) IN
1033: (fa_std_types.fad_dbr_polish_1,
1034: fa_std_types.fad_dbr_polish_2,
1035: fa_std_types.fad_dbr_polish_3,
1036: fa_std_types.fad_dbr_polish_4,
1037: fa_std_types.fad_dbr_polish_5

Line 1034: fa_std_types.fad_dbr_polish_2,

1030: END IF;
1031:
1032: IF (NVL (l_polish_rule, fa_std_types.fad_dbr_polish_none) IN
1033: (fa_std_types.fad_dbr_polish_1,
1034: fa_std_types.fad_dbr_polish_2,
1035: fa_std_types.fad_dbr_polish_3,
1036: fa_std_types.fad_dbr_polish_4,
1037: fa_std_types.fad_dbr_polish_5
1038: )

Line 1035: fa_std_types.fad_dbr_polish_3,

1031:
1032: IF (NVL (l_polish_rule, fa_std_types.fad_dbr_polish_none) IN
1033: (fa_std_types.fad_dbr_polish_1,
1034: fa_std_types.fad_dbr_polish_2,
1035: fa_std_types.fad_dbr_polish_3,
1036: fa_std_types.fad_dbr_polish_4,
1037: fa_std_types.fad_dbr_polish_5
1038: )
1039: )

Line 1036: fa_std_types.fad_dbr_polish_4,

1032: IF (NVL (l_polish_rule, fa_std_types.fad_dbr_polish_none) IN
1033: (fa_std_types.fad_dbr_polish_1,
1034: fa_std_types.fad_dbr_polish_2,
1035: fa_std_types.fad_dbr_polish_3,
1036: fa_std_types.fad_dbr_polish_4,
1037: fa_std_types.fad_dbr_polish_5
1038: )
1039: )
1040: THEN

Line 1037: fa_std_types.fad_dbr_polish_5

1033: (fa_std_types.fad_dbr_polish_1,
1034: fa_std_types.fad_dbr_polish_2,
1035: fa_std_types.fad_dbr_polish_3,
1036: fa_std_types.fad_dbr_polish_4,
1037: fa_std_types.fad_dbr_polish_5
1038: )
1039: )
1040: THEN
1041: x_reval_out.insert_txn_flag := FALSE;

Line 1788: p_running_mode => fa_std_types.fa_dpr_normal,

1784: px_bonus_deprn_exp => l_bonus_deprn_exp,
1785: px_impairment_exp => l_impairment_exp,
1786: px_reval_deprn_rsv_adj => x_reval_out.deprn_rsv_adj,
1787: p_mrc_sob_type_code => p_mrc_sob_type_code,
1788: p_running_mode => fa_std_types.fa_dpr_normal,
1789: p_used_by_revaluation => 1
1790: , p_log_level_rec => p_log_level_rec)
1791: THEN
1792: RAISE fareven_err;

Line 1969: IF ( (l_rate_source_rule = fa_std_types.fad_rsr_calc)

1965: END IF;
1966:
1967: -- Find if the Depreciation Method for this
1968: -- calculated life exists
1969: IF ( (l_rate_source_rule = fa_std_types.fad_rsr_calc)
1970: OR (l_rate_source_rule = fa_std_types.fad_rsr_table)
1971: OR (l_rate_source_rule = fa_std_types.fad_rsr_formula)
1972: )
1973: THEN

Line 1970: OR (l_rate_source_rule = fa_std_types.fad_rsr_table)

1966:
1967: -- Find if the Depreciation Method for this
1968: -- calculated life exists
1969: IF ( (l_rate_source_rule = fa_std_types.fad_rsr_calc)
1970: OR (l_rate_source_rule = fa_std_types.fad_rsr_table)
1971: OR (l_rate_source_rule = fa_std_types.fad_rsr_formula)
1972: )
1973: THEN
1974: IF NOT fa_cache_pkg.fazccmt

Line 1971: OR (l_rate_source_rule = fa_std_types.fad_rsr_formula)

1967: -- Find if the Depreciation Method for this
1968: -- calculated life exists
1969: IF ( (l_rate_source_rule = fa_std_types.fad_rsr_calc)
1970: OR (l_rate_source_rule = fa_std_types.fad_rsr_table)
1971: OR (l_rate_source_rule = fa_std_types.fad_rsr_formula)
1972: )
1973: THEN
1974: IF NOT fa_cache_pkg.fazccmt
1975: (x_method => p_asset_fin_rec_old.deprn_method_code,

Line 1979: IF (l_rate_source_rule = fa_std_types.fad_rsr_calc)

1975: (x_method => p_asset_fin_rec_old.deprn_method_code,
1976: x_life => l_recalc_life
1977: , p_log_level_rec => p_log_level_rec)
1978: THEN
1979: IF (l_rate_source_rule = fa_std_types.fad_rsr_calc)
1980: THEN
1981: IF (p_log_level_rec.statement_level)
1982: THEN
1983: fa_debug_pkg.ADD ('fareven',

Line 2347: IF ( (l_rate_source_rule = fa_std_types.fad_rsr_calc)

2343: END IF;
2344:
2345: -- Find if the Depreciation Method for this
2346: -- calculated life exists
2347: IF ( (l_rate_source_rule = fa_std_types.fad_rsr_calc)
2348: OR (l_rate_source_rule = fa_std_types.fad_rsr_table)
2349: OR (l_rate_source_rule = fa_std_types.fad_rsr_formula)
2350: )
2351: THEN

Line 2348: OR (l_rate_source_rule = fa_std_types.fad_rsr_table)

2344:
2345: -- Find if the Depreciation Method for this
2346: -- calculated life exists
2347: IF ( (l_rate_source_rule = fa_std_types.fad_rsr_calc)
2348: OR (l_rate_source_rule = fa_std_types.fad_rsr_table)
2349: OR (l_rate_source_rule = fa_std_types.fad_rsr_formula)
2350: )
2351: THEN
2352: IF NOT fa_cache_pkg.fazccmt

Line 2349: OR (l_rate_source_rule = fa_std_types.fad_rsr_formula)

2345: -- Find if the Depreciation Method for this
2346: -- calculated life exists
2347: IF ( (l_rate_source_rule = fa_std_types.fad_rsr_calc)
2348: OR (l_rate_source_rule = fa_std_types.fad_rsr_table)
2349: OR (l_rate_source_rule = fa_std_types.fad_rsr_formula)
2350: )
2351: THEN
2352: IF NOT fa_cache_pkg.fazccmt
2353: (x_method => p_asset_fin_rec_old.deprn_method_code,

Line 2362: IF (l_rate_source_rule = fa_std_types.fad_rsr_calc)

2358: THEN
2359: fa_debug_pkg.ADD ('fareven', 'fazccmt false', 1, p_log_level_rec => p_log_level_rec);
2360: END IF;
2361:
2362: IF (l_rate_source_rule = fa_std_types.fad_rsr_calc)
2363: THEN
2364: IF (p_log_level_rec.statement_level)
2365: THEN
2366: fa_debug_pkg.ADD ('fareven',

Line 2433: p_running_mode => fa_std_types.fa_dpr_normal,

2429: px_bonus_deprn_exp => l_bonus_deprn_exp,
2430: px_impairment_exp => l_impairment_exp,
2431: px_reval_deprn_rsv_adj => x_reval_out.deprn_rsv_adj,
2432: p_mrc_sob_type_code => p_mrc_sob_type_code,
2433: p_running_mode => fa_std_types.fa_dpr_normal,
2434: p_used_by_revaluation => 1
2435: , p_log_level_rec => p_log_level_rec)
2436: THEN
2437: RAISE fareven_err;

Line 3128: x_reval_out OUT NOCOPY fa_std_types.reval_out_struct,

3124: px_asset_deprn_rec_new IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
3125: p_period_rec IN fa_api_types.period_rec_type,
3126: p_mrc_sob_type_code IN VARCHAR2,
3127: p_reval_options_rec IN fa_api_types.reval_options_rec_type,
3128: x_reval_out OUT NOCOPY fa_std_types.reval_out_struct,
3129: p_log_level_rec IN fa_api_types.log_level_rec_type)
3130: RETURN BOOLEAN
3131: IS
3132:

Line 3274: p_running_mode => fa_std_types.fa_dpr_normal,

3270: px_bonus_deprn_exp => l_bonus_deprn_exp,
3271: px_impairment_exp => l_impairment_exp,
3272: px_reval_deprn_rsv_adj => x_reval_out.deprn_rsv_adj,
3273: p_mrc_sob_type_code => p_mrc_sob_type_code,
3274: p_running_mode => fa_std_types.fa_dpr_normal,
3275: p_used_by_revaluation => 1,
3276: p_log_level_rec => p_log_level_rec)
3277: THEN
3278: RAISE farevrl_err;

Line 3573: l_dpr_row FA_STD_TYPES.FA_DEPRN_ROW_STRUCT;

3569: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
3570: p_mrc_sob_type_code IN VARCHAR2,
3571: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3572:
3573: l_dpr_row FA_STD_TYPES.FA_DEPRN_ROW_STRUCT;
3574: l_status boolean;
3575: l_dpr_in fa_std_types.dpr_struct;
3576: l_dpr_arr fa_std_types.dpr_arr_type;
3577: l_running_mode number := fa_std_types.FA_DPR_NORMAL;

Line 3575: l_dpr_in fa_std_types.dpr_struct;

3571: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3572:
3573: l_dpr_row FA_STD_TYPES.FA_DEPRN_ROW_STRUCT;
3574: l_status boolean;
3575: l_dpr_in fa_std_types.dpr_struct;
3576: l_dpr_arr fa_std_types.dpr_arr_type;
3577: l_running_mode number := fa_std_types.FA_DPR_NORMAL;
3578: g_temp_integer binary_integer;
3579:

Line 3576: l_dpr_arr fa_std_types.dpr_arr_type;

3572:
3573: l_dpr_row FA_STD_TYPES.FA_DEPRN_ROW_STRUCT;
3574: l_status boolean;
3575: l_dpr_in fa_std_types.dpr_struct;
3576: l_dpr_arr fa_std_types.dpr_arr_type;
3577: l_running_mode number := fa_std_types.FA_DPR_NORMAL;
3578: g_temp_integer binary_integer;
3579:
3580: dpr_err exception;

Line 3577: l_running_mode number := fa_std_types.FA_DPR_NORMAL;

3573: l_dpr_row FA_STD_TYPES.FA_DEPRN_ROW_STRUCT;
3574: l_status boolean;
3575: l_dpr_in fa_std_types.dpr_struct;
3576: l_dpr_arr fa_std_types.dpr_arr_type;
3577: l_running_mode number := fa_std_types.FA_DPR_NORMAL;
3578: g_temp_integer binary_integer;
3579:
3580: dpr_err exception;
3581: l_calling_fn VARCHAR2 (40) := 'FA_REVALUATION_PVT.process_depreciation';

Line 3645: l_dpr_in.deprn_override_flag := fa_std_types.FA_NO_OVERRIDE;

3641: l_dpr_in.excess_allocation_option := px_asset_fin_rec_old.excess_allocation_option;
3642: l_dpr_in.depreciation_option := px_asset_fin_rec_old.depreciation_option;
3643: l_dpr_in.member_rollup_flag := px_asset_fin_rec_old.member_rollup_flag;
3644: l_dpr_in.pc_life_end := px_asset_fin_rec_old.period_counter_life_complete;
3645: l_dpr_in.deprn_override_flag := fa_std_types.FA_NO_OVERRIDE;
3646: l_dpr_in.rsv_known_flag := TRUE;
3647: l_dpr_in.deprn_rounding_flag := 'REV';
3648: l_dpr_in.used_by_adjustment := FALSE;
3649: l_running_mode := fa_std_types.FA_DPR_NORMAL;

Line 3649: l_running_mode := fa_std_types.FA_DPR_NORMAL;

3645: l_dpr_in.deprn_override_flag := fa_std_types.FA_NO_OVERRIDE;
3646: l_dpr_in.rsv_known_flag := TRUE;
3647: l_dpr_in.deprn_rounding_flag := 'REV';
3648: l_dpr_in.used_by_adjustment := FALSE;
3649: l_running_mode := fa_std_types.FA_DPR_NORMAL;
3650: l_dpr_in.y_begin := p_period_rec.fiscal_year;
3651: l_dpr_in.p_cl_begin := p_period_rec.period_num;
3652: l_dpr_in.y_end := p_period_rec.fiscal_year;
3653: l_dpr_in.p_cl_end := p_period_rec.period_num;