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_API_TYPES

Line 8: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,

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,
10: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
11: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
12: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,

Line 9: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,

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,
10: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
11: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
12: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
13: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,

Line 10: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,

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,
10: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
11: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
12: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
13: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
14: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,

Line 11: p_asset_type_rec IN fa_api_types.asset_type_rec_type,

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,
10: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
11: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
12: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
13: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
14: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
15: p_period_rec IN fa_api_types.period_rec_type,

Line 12: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,

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,
10: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
11: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
12: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
13: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
14: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
15: p_period_rec IN fa_api_types.period_rec_type,
16: p_mrc_sob_type_code IN VARCHAR2,

Line 13: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,

9: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
10: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
11: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
12: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
13: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
14: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
15: p_period_rec IN fa_api_types.period_rec_type,
16: p_mrc_sob_type_code IN VARCHAR2,
17: p_reval_options_rec IN fa_api_types.reval_options_rec_type,

Line 14: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,

10: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
11: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
12: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
13: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
14: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
15: p_period_rec IN fa_api_types.period_rec_type,
16: p_mrc_sob_type_code IN VARCHAR2,
17: p_reval_options_rec IN fa_api_types.reval_options_rec_type,
18: p_calling_fn IN VARCHAR2

Line 15: p_period_rec IN fa_api_types.period_rec_type,

11: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
12: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
13: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
14: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
15: p_period_rec IN fa_api_types.period_rec_type,
16: p_mrc_sob_type_code IN VARCHAR2,
17: p_reval_options_rec IN fa_api_types.reval_options_rec_type,
18: p_calling_fn IN VARCHAR2
19: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)

Line 17: p_reval_options_rec IN fa_api_types.reval_options_rec_type,

13: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
14: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
15: p_period_rec IN fa_api_types.period_rec_type,
16: p_mrc_sob_type_code IN VARCHAR2,
17: p_reval_options_rec IN fa_api_types.reval_options_rec_type,
18: p_calling_fn IN VARCHAR2
19: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
20: RETURN BOOLEAN
21: IS

Line 19: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)

15: p_period_rec IN fa_api_types.period_rec_type,
16: p_mrc_sob_type_code IN VARCHAR2,
17: p_reval_options_rec IN fa_api_types.reval_options_rec_type,
18: p_calling_fn IN VARCHAR2
19: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
20: RETURN BOOLEAN
21: IS
22: l_th_rowid VARCHAR2 (30);
23: l_bks_rowid VARCHAR2 (30);

Line 25: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;

21: IS
22: l_th_rowid VARCHAR2 (30);
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);

Line 26: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;

22: l_th_rowid VARCHAR2 (30);
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;

Line 35: l_secondary_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

31: l_override_defaults VARCHAR2 (80);
32: l_reval_fully_rsvd VARCHAR2 (80);
33: l_revalue_cip_assets VARCHAR2 (80);
34: --Secondary changes
35: l_secondary_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
36: l_secondary_trans_rec fa_api_types.trans_rec_type;
37: l_secondary_sob_id number;
38:
39: CURSOR yes_no_meaning (p_lookup_code VARCHAR2)

Line 36: l_secondary_trans_rec fa_api_types.trans_rec_type;

32: l_reval_fully_rsvd VARCHAR2 (80);
33: l_revalue_cip_assets VARCHAR2 (80);
34: --Secondary changes
35: l_secondary_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
36: l_secondary_trans_rec fa_api_types.trans_rec_type;
37: l_secondary_sob_id number;
38:
39: CURSOR yes_no_meaning (p_lookup_code VARCHAR2)
40: IS

Line 854: p_trans_rec IN fa_api_types.trans_rec_type,

850: -----------------------------------------------------------------------------
851:
852: -- this function contains validation for reval on an asset
853: FUNCTION validate_reval (
854: p_trans_rec IN fa_api_types.trans_rec_type,
855: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
856: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
857: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
858: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,

Line 855: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,

851:
852: -- this function contains validation for reval on an asset
853: FUNCTION validate_reval (
854: p_trans_rec IN fa_api_types.trans_rec_type,
855: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
856: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
857: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
858: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
859: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,

Line 856: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,

852: -- this function contains validation for reval on an asset
853: FUNCTION validate_reval (
854: p_trans_rec IN fa_api_types.trans_rec_type,
855: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
856: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
857: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
858: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
859: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
860: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,

Line 857: p_asset_type_rec IN fa_api_types.asset_type_rec_type,

853: FUNCTION validate_reval (
854: p_trans_rec IN fa_api_types.trans_rec_type,
855: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
856: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
857: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
858: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
859: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
860: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
861: p_reval_options_rec IN fa_api_types.reval_options_rec_type

Line 858: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,

854: p_trans_rec IN fa_api_types.trans_rec_type,
855: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
856: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
857: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
858: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
859: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
860: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
861: p_reval_options_rec IN fa_api_types.reval_options_rec_type
862: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)

Line 859: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,

855: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
856: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
857: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
858: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
859: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
860: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
861: p_reval_options_rec IN fa_api_types.reval_options_rec_type
862: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
863: RETURN BOOLEAN

Line 860: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,

856: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
857: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
858: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
859: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
860: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
861: p_reval_options_rec IN fa_api_types.reval_options_rec_type
862: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
863: RETURN BOOLEAN
864: IS

Line 861: p_reval_options_rec IN fa_api_types.reval_options_rec_type

857: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
858: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
859: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
860: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
861: p_reval_options_rec IN fa_api_types.reval_options_rec_type
862: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
863: RETURN BOOLEAN
864: IS
865: l_calling_fn VARCHAR2 (35) := 'do_adjustment_pvt.validate_adj';

Line 862: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)

858: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
859: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
860: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
861: p_reval_options_rec IN fa_api_types.reval_options_rec_type
862: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
863: RETURN BOOLEAN
864: IS
865: l_calling_fn VARCHAR2 (35) := 'do_adjustment_pvt.validate_adj';
866: BEGIN

Line 876: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,

872: RETURN FALSE;
873: END validate_reval;
874:
875: FUNCTION fareven (
876: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
877: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
878: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
879: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
880: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,

Line 877: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,

873: END validate_reval;
874:
875: FUNCTION fareven (
876: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
877: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
878: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
879: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
880: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
881: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,

Line 878: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,

874:
875: FUNCTION fareven (
876: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
877: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
878: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
879: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
880: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
881: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
882: px_asset_fin_rec_new IN OUT NOCOPY fa_api_types.asset_fin_rec_type,

Line 879: p_asset_type_rec IN fa_api_types.asset_type_rec_type,

875: FUNCTION fareven (
876: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
877: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
878: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
879: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
880: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
881: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
882: px_asset_fin_rec_new IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
883: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,

Line 880: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,

876: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
877: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
878: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
879: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
880: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
881: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
882: px_asset_fin_rec_new IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
883: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
884: px_asset_deprn_rec_new IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,

Line 881: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,

877: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
878: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
879: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
880: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
881: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
882: px_asset_fin_rec_new IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
883: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
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,

Line 882: px_asset_fin_rec_new IN OUT NOCOPY fa_api_types.asset_fin_rec_type,

878: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
879: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
880: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
881: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
882: px_asset_fin_rec_new IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
883: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
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,

Line 883: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,

879: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
880: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
881: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
882: px_asset_fin_rec_new IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
883: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
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,

Line 884: px_asset_deprn_rec_new IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,

880: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
881: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
882: px_asset_fin_rec_new IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
883: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
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

Line 885: p_period_rec IN fa_api_types.period_rec_type,

881: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
882: px_asset_fin_rec_new IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
883: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
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)

Line 887: p_reval_options_rec IN fa_api_types.reval_options_rec_type,

883: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
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

Line 889: , p_log_level_rec IN FA_API_TYPES.log_level_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;
893: l_reval_rate NUMBER;

Line 892: l_asset_fin_rec_adj fa_api_types.asset_fin_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;
893: l_reval_rate NUMBER;
894: l_life_extension_factor NUMBER;
895: l_life_extension_ceiling NUMBER;
896: l_method_id NUMBER;

Line 3116: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,

3112: RETURN FALSE;
3113: END fareven;
3114:
3115: FUNCTION reval_loss (
3116: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
3117: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3118: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
3119: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3120: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,

Line 3117: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,

3113: END fareven;
3114:
3115: FUNCTION reval_loss (
3116: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
3117: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3118: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
3119: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3120: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
3121: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,

Line 3118: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,

3114:
3115: FUNCTION reval_loss (
3116: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
3117: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3118: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
3119: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3120: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
3121: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3122: px_asset_fin_rec_new IN OUT NOCOPY fa_api_types.asset_fin_rec_type,

Line 3119: p_asset_type_rec IN fa_api_types.asset_type_rec_type,

3115: FUNCTION reval_loss (
3116: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
3117: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3118: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
3119: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3120: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
3121: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3122: px_asset_fin_rec_new IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
3123: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,

Line 3120: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,

3116: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
3117: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3118: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
3119: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3120: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
3121: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3122: px_asset_fin_rec_new IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
3123: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
3124: px_asset_deprn_rec_new IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,

Line 3121: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,

3117: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
3118: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
3119: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3120: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
3121: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3122: px_asset_fin_rec_new IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
3123: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
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,

Line 3122: px_asset_fin_rec_new IN OUT NOCOPY fa_api_types.asset_fin_rec_type,

3118: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
3119: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3120: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
3121: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3122: px_asset_fin_rec_new IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
3123: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
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,

Line 3123: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,

3119: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
3120: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
3121: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3122: px_asset_fin_rec_new IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
3123: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
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,

Line 3124: px_asset_deprn_rec_new IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,

3120: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
3121: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3122: px_asset_fin_rec_new IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
3123: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
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,

Line 3125: p_period_rec IN fa_api_types.period_rec_type,

3121: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
3122: px_asset_fin_rec_new IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
3123: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
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)

Line 3127: p_reval_options_rec IN fa_api_types.reval_options_rec_type,

3123: p_asset_deprn_rec_old IN fa_api_types.asset_deprn_rec_type,
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

Line 3129: p_log_level_rec IN fa_api_types.log_level_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:
3133: l_reval_rate NUMBER := 0;

Line 3136: l_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;

3132:
3133: l_reval_rate NUMBER := 0;
3134: l_reval_loss NUMBER := 0;
3135: l_reval_loss_delta NUMBER := 0;
3136: l_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
3137:
3138: l_adj_in fa_adjust_type_pkg.fa_adj_row_struct;
3139: l_cost_acct VARCHAR2 (25);
3140: l_cip_cost_acct VARCHAR2 (25);

Line 3561: (p_trans_rec IN FA_API_TYPES.trans_rec_type,

3557: RETURN FALSE;
3558: END reval_loss;
3559: /*ER 14644811 */
3560: FUNCTION process_depreciation
3561: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3562: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3563: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3564: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3565: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,

Line 3562: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

3558: END reval_loss;
3559: /*ER 14644811 */
3560: FUNCTION process_depreciation
3561: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3562: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3563: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3564: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3565: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3566: p_period_rec IN FA_API_TYPES.period_rec_type,

Line 3563: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,

3559: /*ER 14644811 */
3560: FUNCTION process_depreciation
3561: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3562: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3563: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3564: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3565: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3566: p_period_rec IN FA_API_TYPES.period_rec_type,
3567: px_asset_fin_rec_old IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

Line 3564: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,

3560: FUNCTION process_depreciation
3561: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3562: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3563: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3564: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3565: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3566: p_period_rec IN FA_API_TYPES.period_rec_type,
3567: px_asset_fin_rec_old IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3568: px_asset_deprn_rec_old IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,

Line 3565: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,

3561: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3562: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3563: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3564: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3565: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3566: p_period_rec IN FA_API_TYPES.period_rec_type,
3567: px_asset_fin_rec_old IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3568: px_asset_deprn_rec_old IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
3569: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,

Line 3566: p_period_rec IN FA_API_TYPES.period_rec_type,

3562: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3563: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3564: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3565: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3566: p_period_rec IN FA_API_TYPES.period_rec_type,
3567: px_asset_fin_rec_old IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3568: px_asset_deprn_rec_old IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
3569: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
3570: p_mrc_sob_type_code IN VARCHAR2,

Line 3567: px_asset_fin_rec_old IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

3563: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3564: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3565: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3566: p_period_rec IN FA_API_TYPES.period_rec_type,
3567: px_asset_fin_rec_old IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3568: px_asset_deprn_rec_old IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
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

Line 3568: px_asset_deprn_rec_old IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,

3564: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3565: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3566: p_period_rec IN FA_API_TYPES.period_rec_type,
3567: px_asset_fin_rec_old IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3568: px_asset_deprn_rec_old IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
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:

Line 3569: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,

3565: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3566: p_period_rec IN FA_API_TYPES.period_rec_type,
3567: px_asset_fin_rec_old IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3568: px_asset_deprn_rec_old IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
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;

Line 3571: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS

3567: px_asset_fin_rec_old IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3568: px_asset_deprn_rec_old IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
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;

Line 3708: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

3704: END process_depreciation;
3705:
3706: -- ER 14644811 : New function for rolling back Period End Revaluation
3707: FUNCTION rollback_reval(
3708: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3709: p_thid IN NUMBER,
3710: p_event_id IN NUMBER,
3711: p_mrc_sob_type_code IN VARCHAR2,
3712: p_calling_fn IN VARCHAR2,

Line 3713: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS

3709: p_thid IN NUMBER,
3710: p_event_id IN NUMBER,
3711: p_mrc_sob_type_code IN VARCHAR2,
3712: p_calling_fn IN VARCHAR2,
3713: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3714:
3715:
3716: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
3717: l_security_context XLA_EVENTS_PUB_PKG.t_security;

Line 3718: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

3714:
3715:
3716: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
3717: l_security_context XLA_EVENTS_PUB_PKG.t_security;
3718: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3719: l_trans_rec FA_API_TYPES.trans_rec_type;
3720: l_period_rec fa_api_types.period_rec_type;
3721:
3722: CURSOR c_get_new_thid IS

Line 3719: l_trans_rec FA_API_TYPES.trans_rec_type;

3715:
3716: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
3717: l_security_context XLA_EVENTS_PUB_PKG.t_security;
3718: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3719: l_trans_rec FA_API_TYPES.trans_rec_type;
3720: l_period_rec fa_api_types.period_rec_type;
3721:
3722: CURSOR c_get_new_thid IS
3723: select transaction_header_id

Line 3720: l_period_rec fa_api_types.period_rec_type;

3716: l_trx_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
3717: l_security_context XLA_EVENTS_PUB_PKG.t_security;
3718: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3719: l_trans_rec FA_API_TYPES.trans_rec_type;
3720: l_period_rec fa_api_types.period_rec_type;
3721:
3722: CURSOR c_get_new_thid IS
3723: select transaction_header_id
3724: , date_effective

Line 3739: l_secondary_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

3735:
3736: l_reval_count NUMBER := 0;
3737: l_event_status VARCHAR2(1);
3738:
3739: l_secondary_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3740: l_secondary_trans_rec fa_api_types.trans_rec_type;
3741: l_secondary_sob_id number;
3742:
3743: reval_err EXCEPTION;

Line 3740: l_secondary_trans_rec fa_api_types.trans_rec_type;

3736: l_reval_count NUMBER := 0;
3737: l_event_status VARCHAR2(1);
3738:
3739: l_secondary_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3740: l_secondary_trans_rec fa_api_types.trans_rec_type;
3741: l_secondary_sob_id number;
3742:
3743: reval_err EXCEPTION;
3744: l_calling_fn VARCHAR2 (40) := 'FA_REVALUATION_PVT.rollback_reval';