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_IMPAIRMENT_POST_PVT dependencies on FA_API_TYPES

Line 27: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type

23:
24:
25: --*********************** Private functions ******************************--
26: FUNCTION call_deprn_basis(
27: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type
28: , p_trans_rec IN fa_api_types.trans_rec_type
29: , p_period_rec IN fa_api_types.period_rec_type
30: , p_asset_type_rec IN fa_api_types.asset_type_rec_type
31: , p_asset_fin_rec IN fa_api_types.asset_fin_rec_type

Line 28: , p_trans_rec IN fa_api_types.trans_rec_type

24:
25: --*********************** Private functions ******************************--
26: FUNCTION call_deprn_basis(
27: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type
28: , p_trans_rec IN fa_api_types.trans_rec_type
29: , p_period_rec IN fa_api_types.period_rec_type
30: , p_asset_type_rec IN fa_api_types.asset_type_rec_type
31: , p_asset_fin_rec IN fa_api_types.asset_fin_rec_type
32: , p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type

Line 29: , p_period_rec IN fa_api_types.period_rec_type

25: --*********************** Private functions ******************************--
26: FUNCTION call_deprn_basis(
27: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type
28: , p_trans_rec IN fa_api_types.trans_rec_type
29: , p_period_rec IN fa_api_types.period_rec_type
30: , p_asset_type_rec IN fa_api_types.asset_type_rec_type
31: , p_asset_fin_rec IN fa_api_types.asset_fin_rec_type
32: , p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type
33: , p_asset_desc_rec IN fa_api_types.asset_desc_rec_type

Line 30: , p_asset_type_rec IN fa_api_types.asset_type_rec_type

26: FUNCTION call_deprn_basis(
27: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type
28: , p_trans_rec IN fa_api_types.trans_rec_type
29: , p_period_rec IN fa_api_types.period_rec_type
30: , p_asset_type_rec IN fa_api_types.asset_type_rec_type
31: , p_asset_fin_rec IN fa_api_types.asset_fin_rec_type
32: , p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type
33: , p_asset_desc_rec IN fa_api_types.asset_desc_rec_type
34: , x_new_raf OUT NOCOPY NUMBER

Line 31: , p_asset_fin_rec IN fa_api_types.asset_fin_rec_type

27: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type
28: , p_trans_rec IN fa_api_types.trans_rec_type
29: , p_period_rec IN fa_api_types.period_rec_type
30: , p_asset_type_rec IN fa_api_types.asset_type_rec_type
31: , p_asset_fin_rec IN fa_api_types.asset_fin_rec_type
32: , p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type
33: , p_asset_desc_rec IN fa_api_types.asset_desc_rec_type
34: , x_new_raf OUT NOCOPY NUMBER
35: , x_new_formula_factor OUT NOCOPY NUMBER

Line 32: , p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type

28: , p_trans_rec IN fa_api_types.trans_rec_type
29: , p_period_rec IN fa_api_types.period_rec_type
30: , p_asset_type_rec IN fa_api_types.asset_type_rec_type
31: , p_asset_fin_rec IN fa_api_types.asset_fin_rec_type
32: , p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type
33: , p_asset_desc_rec IN fa_api_types.asset_desc_rec_type
34: , x_new_raf OUT NOCOPY NUMBER
35: , x_new_formula_factor OUT NOCOPY NUMBER
36: , x_new_adjusted_cost OUT NOCOPY NUMBER

Line 33: , p_asset_desc_rec IN fa_api_types.asset_desc_rec_type

29: , p_period_rec IN fa_api_types.period_rec_type
30: , p_asset_type_rec IN fa_api_types.asset_type_rec_type
31: , p_asset_fin_rec IN fa_api_types.asset_fin_rec_type
32: , p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type
33: , p_asset_desc_rec IN fa_api_types.asset_desc_rec_type
34: , x_new_raf OUT NOCOPY NUMBER
35: , x_new_formula_factor OUT NOCOPY NUMBER
36: , x_new_adjusted_cost OUT NOCOPY NUMBER
37: , p_mrc_sob_type_code IN VARCHAR2

Line 39: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;

35: , x_new_formula_factor OUT NOCOPY NUMBER
36: , x_new_adjusted_cost OUT NOCOPY NUMBER
37: , p_mrc_sob_type_code IN VARCHAR2
38: , p_calling_fn IN VARCHAR2
39: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
40:
41:
42: FUNCTION create_cost_entries(
43: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type

Line 43: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type

39: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
40:
41:
42: FUNCTION create_cost_entries(
43: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type
44: , p_trans_rec IN fa_api_types.trans_rec_type
45: , p_period_rec IN fa_api_types.period_rec_type
46: , p_asset_type_rec IN fa_api_types.asset_type_rec_type
47: , p_cost IN NUMBER

Line 44: , p_trans_rec IN fa_api_types.trans_rec_type

40:
41:
42: FUNCTION create_cost_entries(
43: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type
44: , p_trans_rec IN fa_api_types.trans_rec_type
45: , p_period_rec IN fa_api_types.period_rec_type
46: , p_asset_type_rec IN fa_api_types.asset_type_rec_type
47: , p_cost IN NUMBER
48: , p_current_units IN NUMBER

Line 45: , p_period_rec IN fa_api_types.period_rec_type

41:
42: FUNCTION create_cost_entries(
43: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type
44: , p_trans_rec IN fa_api_types.trans_rec_type
45: , p_period_rec IN fa_api_types.period_rec_type
46: , p_asset_type_rec IN fa_api_types.asset_type_rec_type
47: , p_cost IN NUMBER
48: , p_current_units IN NUMBER
49: , p_mrc_sob_type_code IN VARCHAR2

Line 46: , p_asset_type_rec IN fa_api_types.asset_type_rec_type

42: FUNCTION create_cost_entries(
43: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type
44: , p_trans_rec IN fa_api_types.trans_rec_type
45: , p_period_rec IN fa_api_types.period_rec_type
46: , p_asset_type_rec IN fa_api_types.asset_type_rec_type
47: , p_cost IN NUMBER
48: , p_current_units IN NUMBER
49: , p_mrc_sob_type_code IN VARCHAR2
50: , p_calling_fn IN VARCHAR2

Line 51: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;

47: , p_cost IN NUMBER
48: , p_current_units IN NUMBER
49: , p_mrc_sob_type_code IN VARCHAR2
50: , p_calling_fn IN VARCHAR2
51: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
52:
53:
54: --*********************** Public functions ******************************--
55: FUNCTION process_post(

Line 58: p_period_rec IN FA_API_TYPES.period_rec_type,

54: --*********************** Public functions ******************************--
55: FUNCTION process_post(
56: p_request_id IN NUMBER,
57: p_book_type_code IN VARCHAR2,
58: p_period_rec IN FA_API_TYPES.period_rec_type,
59: p_worker_id IN NUMBER,
60: p_mrc_sob_type_code IN VARCHAR2,
61: p_set_of_books_id IN NUMBER,
62: p_calling_fn IN VARCHAR2

Line 63: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS

59: p_worker_id IN NUMBER,
60: p_mrc_sob_type_code IN VARCHAR2,
61: p_set_of_books_id IN NUMBER,
62: p_calling_fn IN VARCHAR2
63: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
64:
65: l_calling_fn varchar2(60) := 'FA_IMPAIRMENT_POST_PVT.process_post';
66: l_mode varchar2(20) := 'RUNNING POST';
67:

Line 237: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

233: -- and ITF.PERIOD_COUNTER = p_period_rec.period_counter
234: ;
235:
236:
237: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
238:
239: CURSOR c_get_dists IS
240: select th.transaction_header_id
241: , th.transaction_date_entered

Line 393: l_trans_rec fa_api_types.trans_rec_type;

389: t_period_counter_life_complete tab_num_type; --9781938 /*changed these variable to table type*/
390: t_period_counter_fully_ext tab_num_type; --9786860
391: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
392:
393: l_trans_rec fa_api_types.trans_rec_type;
394: l_asset_type_rec fa_api_types.asset_type_rec_type;
395: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
396: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
397: l_asset_desc_rec fa_api_types.asset_desc_rec_type;

Line 394: l_asset_type_rec fa_api_types.asset_type_rec_type;

390: t_period_counter_fully_ext tab_num_type; --9786860
391: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
392:
393: l_trans_rec fa_api_types.trans_rec_type;
394: l_asset_type_rec fa_api_types.asset_type_rec_type;
395: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
396: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
397: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
398: l_asset_cat_rec fa_api_types.asset_cat_rec_type;

Line 395: l_asset_fin_rec fa_api_types.asset_fin_rec_type;

391: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
392:
393: l_trans_rec fa_api_types.trans_rec_type;
394: l_asset_type_rec fa_api_types.asset_type_rec_type;
395: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
396: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
397: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
398: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
399: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;

Line 396: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;

392:
393: l_trans_rec fa_api_types.trans_rec_type;
394: l_asset_type_rec fa_api_types.asset_type_rec_type;
395: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
396: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
397: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
398: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
399: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
400:

Line 397: l_asset_desc_rec fa_api_types.asset_desc_rec_type;

393: l_trans_rec fa_api_types.trans_rec_type;
394: l_asset_type_rec fa_api_types.asset_type_rec_type;
395: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
396: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
397: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
398: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
399: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
400:
401: l_period_counter number(15); -- store period counter impaired

Line 398: l_asset_cat_rec fa_api_types.asset_cat_rec_type;

394: l_asset_type_rec fa_api_types.asset_type_rec_type;
395: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
396: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
397: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
398: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
399: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
400:
401: l_period_counter number(15); -- store period counter impaired
402:

Line 399: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;

395: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
396: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
397: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
398: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
399: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
400:
401: l_period_counter number(15); -- store period counter impaired
402:
403: l_limit binary_integer := 200; -- limit constant for C1 cursor

Line 2279: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type

2275:
2276: END process_post;
2277:
2278: FUNCTION call_deprn_basis(
2279: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type
2280: , p_trans_rec IN fa_api_types.trans_rec_type
2281: , p_period_rec IN fa_api_types.period_rec_type
2282: , p_asset_type_rec IN fa_api_types.asset_type_rec_type
2283: , p_asset_fin_rec IN fa_api_types.asset_fin_rec_type

Line 2280: , p_trans_rec IN fa_api_types.trans_rec_type

2276: END process_post;
2277:
2278: FUNCTION call_deprn_basis(
2279: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type
2280: , p_trans_rec IN fa_api_types.trans_rec_type
2281: , p_period_rec IN fa_api_types.period_rec_type
2282: , p_asset_type_rec IN fa_api_types.asset_type_rec_type
2283: , p_asset_fin_rec IN fa_api_types.asset_fin_rec_type
2284: , p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type

Line 2281: , p_period_rec IN fa_api_types.period_rec_type

2277:
2278: FUNCTION call_deprn_basis(
2279: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type
2280: , p_trans_rec IN fa_api_types.trans_rec_type
2281: , p_period_rec IN fa_api_types.period_rec_type
2282: , p_asset_type_rec IN fa_api_types.asset_type_rec_type
2283: , p_asset_fin_rec IN fa_api_types.asset_fin_rec_type
2284: , p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type
2285: , p_asset_desc_rec IN fa_api_types.asset_desc_rec_type

Line 2282: , p_asset_type_rec IN fa_api_types.asset_type_rec_type

2278: FUNCTION call_deprn_basis(
2279: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type
2280: , p_trans_rec IN fa_api_types.trans_rec_type
2281: , p_period_rec IN fa_api_types.period_rec_type
2282: , p_asset_type_rec IN fa_api_types.asset_type_rec_type
2283: , p_asset_fin_rec IN fa_api_types.asset_fin_rec_type
2284: , p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type
2285: , p_asset_desc_rec IN fa_api_types.asset_desc_rec_type
2286: , x_new_raf OUT NOCOPY NUMBER

Line 2283: , p_asset_fin_rec IN fa_api_types.asset_fin_rec_type

2279: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type
2280: , p_trans_rec IN fa_api_types.trans_rec_type
2281: , p_period_rec IN fa_api_types.period_rec_type
2282: , p_asset_type_rec IN fa_api_types.asset_type_rec_type
2283: , p_asset_fin_rec IN fa_api_types.asset_fin_rec_type
2284: , p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type
2285: , p_asset_desc_rec IN fa_api_types.asset_desc_rec_type
2286: , x_new_raf OUT NOCOPY NUMBER
2287: , x_new_formula_factor OUT NOCOPY NUMBER

Line 2284: , p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type

2280: , p_trans_rec IN fa_api_types.trans_rec_type
2281: , p_period_rec IN fa_api_types.period_rec_type
2282: , p_asset_type_rec IN fa_api_types.asset_type_rec_type
2283: , p_asset_fin_rec IN fa_api_types.asset_fin_rec_type
2284: , p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type
2285: , p_asset_desc_rec IN fa_api_types.asset_desc_rec_type
2286: , x_new_raf OUT NOCOPY NUMBER
2287: , x_new_formula_factor OUT NOCOPY NUMBER
2288: , x_new_adjusted_cost OUT NOCOPY NUMBER

Line 2285: , p_asset_desc_rec IN fa_api_types.asset_desc_rec_type

2281: , p_period_rec IN fa_api_types.period_rec_type
2282: , p_asset_type_rec IN fa_api_types.asset_type_rec_type
2283: , p_asset_fin_rec IN fa_api_types.asset_fin_rec_type
2284: , p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type
2285: , p_asset_desc_rec IN fa_api_types.asset_desc_rec_type
2286: , x_new_raf OUT NOCOPY NUMBER
2287: , x_new_formula_factor OUT NOCOPY NUMBER
2288: , x_new_adjusted_cost OUT NOCOPY NUMBER
2289: , p_mrc_sob_type_code IN VARCHAR2

Line 2291: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS

2287: , x_new_formula_factor OUT NOCOPY NUMBER
2288: , x_new_adjusted_cost OUT NOCOPY NUMBER
2289: , p_mrc_sob_type_code IN VARCHAR2
2290: , p_calling_fn IN VARCHAR2
2291: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2292:
2293: l_calling_fn varchar2(60) := 'fa_process_impairment_pvt.call_deprn_basis';
2294:
2295: CURSOR c_get_next_period is

Line 2314: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;

2310: AND fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
2311: AND cp.start_date between fy.start_date and fy.end_date;
2312:
2313:
2314: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
2315: l_period_rec fa_api_types.period_rec_type; -- This holds info about next period
2316:
2317: --++++++++ variables for manual override ++++++++
2318: l_rate_source_rule VARCHAR2(25);

Line 2315: l_period_rec fa_api_types.period_rec_type; -- This holds info about next period

2311: AND cp.start_date between fy.start_date and fy.end_date;
2312:
2313:
2314: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
2315: l_period_rec fa_api_types.period_rec_type; -- This holds info about next period
2316:
2317: --++++++++ variables for manual override ++++++++
2318: l_rate_source_rule VARCHAR2(25);
2319: l_deprn_basis_rule VARCHAR2(25);

Line 2643: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type

2639: return false;
2640: END call_deprn_basis;
2641:
2642: FUNCTION create_cost_entries(
2643: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type
2644: , p_trans_rec IN fa_api_types.trans_rec_type
2645: , p_period_rec IN fa_api_types.period_rec_type
2646: , p_asset_type_rec IN fa_api_types.asset_type_rec_type
2647: , p_cost IN NUMBER

Line 2644: , p_trans_rec IN fa_api_types.trans_rec_type

2640: END call_deprn_basis;
2641:
2642: FUNCTION create_cost_entries(
2643: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type
2644: , p_trans_rec IN fa_api_types.trans_rec_type
2645: , p_period_rec IN fa_api_types.period_rec_type
2646: , p_asset_type_rec IN fa_api_types.asset_type_rec_type
2647: , p_cost IN NUMBER
2648: , p_current_units IN NUMBER

Line 2645: , p_period_rec IN fa_api_types.period_rec_type

2641:
2642: FUNCTION create_cost_entries(
2643: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type
2644: , p_trans_rec IN fa_api_types.trans_rec_type
2645: , p_period_rec IN fa_api_types.period_rec_type
2646: , p_asset_type_rec IN fa_api_types.asset_type_rec_type
2647: , p_cost IN NUMBER
2648: , p_current_units IN NUMBER
2649: , p_mrc_sob_type_code IN VARCHAR2

Line 2646: , p_asset_type_rec IN fa_api_types.asset_type_rec_type

2642: FUNCTION create_cost_entries(
2643: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type
2644: , p_trans_rec IN fa_api_types.trans_rec_type
2645: , p_period_rec IN fa_api_types.period_rec_type
2646: , p_asset_type_rec IN fa_api_types.asset_type_rec_type
2647: , p_cost IN NUMBER
2648: , p_current_units IN NUMBER
2649: , p_mrc_sob_type_code IN VARCHAR2
2650: , p_calling_fn IN VARCHAR2

Line 2651: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS

2647: , p_cost IN NUMBER
2648: , p_current_units IN NUMBER
2649: , p_mrc_sob_type_code IN VARCHAR2
2650: , p_calling_fn IN VARCHAR2
2651: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2652:
2653: l_calling_fn varchar2(60) := 'fa_impairment_post_pvt.create_cost_entries';
2654:
2655: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;