DBA Data[Home] [Help]

APPS.FA_IMPAIRMENT_PREV_PVT dependencies on FA_API_TYPES

Line 30: p_period_rec IN FA_API_TYPES.period_rec_type,

26: FUNCTION process_depreciation(
27: p_request_id IN NUMBER,
28: p_book_type_code IN VARCHAR2,
29: p_worker_id IN NUMBER,
30: p_period_rec IN FA_API_TYPES.period_rec_type,
31: p_imp_period_rec IN FA_API_TYPES.period_rec_type,
32: p_mrc_sob_type_code IN VARCHAR2,
33: p_set_of_books_id IN NUMBER,
34: p_calling_fn IN VARCHAR2

Line 31: p_imp_period_rec IN FA_API_TYPES.period_rec_type,

27: p_request_id IN NUMBER,
28: p_book_type_code IN VARCHAR2,
29: p_worker_id IN NUMBER,
30: p_period_rec IN FA_API_TYPES.period_rec_type,
31: p_imp_period_rec IN FA_API_TYPES.period_rec_type,
32: p_mrc_sob_type_code IN VARCHAR2,
33: p_set_of_books_id IN NUMBER,
34: p_calling_fn IN VARCHAR2
35: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS

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

31: p_imp_period_rec IN FA_API_TYPES.period_rec_type,
32: p_mrc_sob_type_code IN VARCHAR2,
33: p_set_of_books_id IN NUMBER,
34: p_calling_fn IN VARCHAR2
35: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
36:
37: l_calling_fn varchar2(60) := 'FA_IMPAIRMENT_PREV_PVT.process_depreciation';
38:
39: CURSOR c_deprn is

Line 364: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

360: l_pa_dpr_out fa_std_types.dpr_out_struct;
361: l_pa_dpr_arr fa_std_types.dpr_arr_type;
362:
363: l_running_mode VARCHAR2(20);
364: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
365:
366: l_limit binary_integer := 200; -- limit constant for c_deprn cursor
367: dpr_err exception;
368:

Line 1198: , p_period_rec IN FA_API_TYPES.period_rec_type

1194: FUNCTION calc_total_nbv(
1195: p_request_id IN NUMBER
1196: , p_book_type_code IN VARCHAR2
1197: , p_transaction_date IN DATE
1198: , p_period_rec IN FA_API_TYPES.period_rec_type
1199: , p_mrc_sob_type_code IN VARCHAR2
1200: , p_set_of_books_id IN NUMBER
1201: , p_calling_fn IN VARCHAR2
1202: , p_asset_id OUT NOCOPY tab_num_type

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

1200: , p_set_of_books_id IN NUMBER
1201: , p_calling_fn IN VARCHAR2
1202: , p_asset_id OUT NOCOPY tab_num_type
1203: , p_nbv OUT NOCOPY tab_num_type
1204: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1205:
1206: l_calling_fn varchar2(60) := 'post_impairment';
1207:
1208:

Line 1864: , p_period_rec FA_API_TYPES.period_rec_type

1860: FUNCTION process_history(p_request_id number
1861: , p_impairment_id number
1862: , p_asset_id number
1863: , p_book_type_code varchar2
1864: , p_period_rec FA_API_TYPES.period_rec_type
1865: , p_imp_period_rec FA_API_TYPES.period_rec_type
1866: , p_date_placed_in_service date
1867: , x_dpr_out OUT NOCOPY fa_std_types.dpr_out_struct
1868: , x_dpr_in OUT NOCOPY fa_std_types.dpr_struct

Line 1865: , p_imp_period_rec FA_API_TYPES.period_rec_type

1861: , p_impairment_id number
1862: , p_asset_id number
1863: , p_book_type_code varchar2
1864: , p_period_rec FA_API_TYPES.period_rec_type
1865: , p_imp_period_rec FA_API_TYPES.period_rec_type
1866: , p_date_placed_in_service date
1867: , x_dpr_out OUT NOCOPY fa_std_types.dpr_out_struct
1868: , x_dpr_in OUT NOCOPY fa_std_types.dpr_struct
1869: , p_mrc_sob_type_code varchar2

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

1867: , x_dpr_out OUT NOCOPY fa_std_types.dpr_out_struct
1868: , x_dpr_in OUT NOCOPY fa_std_types.dpr_struct
1869: , p_mrc_sob_type_code varchar2
1870: , p_calling_fn varchar2
1871: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1872:
1873: l_calling_fn VARCHAR2(30) := 'process_history';
1874:
1875: CURSOR c_get_member_trx IS

Line 2137: l_trans_rec FA_API_TYPES.trans_rec_type;

2133: tbs_change_in_sal tab_num_type;
2134: tbs_change_in_limit tab_num_type;
2135: tbs_change_in_retirements_cost tab_num_type;
2136:
2137: l_trans_rec FA_API_TYPES.trans_rec_type;
2138: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
2139: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
2140: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
2141: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

Line 2138: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

2134: tbs_change_in_limit tab_num_type;
2135: tbs_change_in_retirements_cost tab_num_type;
2136:
2137: l_trans_rec FA_API_TYPES.trans_rec_type;
2138: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
2139: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
2140: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
2141: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
2142: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

Line 2139: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;

2135: tbs_change_in_retirements_cost tab_num_type;
2136:
2137: l_trans_rec FA_API_TYPES.trans_rec_type;
2138: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
2139: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
2140: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
2141: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
2142: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
2143: l_period_rec FA_API_TYPES.period_rec_type;

Line 2140: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

2136:
2137: l_trans_rec FA_API_TYPES.trans_rec_type;
2138: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
2139: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
2140: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
2141: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
2142: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
2143: l_period_rec FA_API_TYPES.period_rec_type;
2144:

Line 2141: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

2137: l_trans_rec FA_API_TYPES.trans_rec_type;
2138: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
2139: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
2140: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
2141: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
2142: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
2143: l_period_rec FA_API_TYPES.period_rec_type;
2144:
2145: l_dpr_in fa_std_types.dpr_struct;

Line 2142: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

2138: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
2139: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
2140: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
2141: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
2142: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
2143: l_period_rec FA_API_TYPES.period_rec_type;
2144:
2145: l_dpr_in fa_std_types.dpr_struct;
2146: l_dpr_out fa_std_types.dpr_out_struct;

Line 2143: l_period_rec FA_API_TYPES.period_rec_type;

2139: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
2140: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
2141: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
2142: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
2143: l_period_rec FA_API_TYPES.period_rec_type;
2144:
2145: l_dpr_in fa_std_types.dpr_struct;
2146: l_dpr_out fa_std_types.dpr_out_struct;
2147: l_dpr_arr fa_std_types.dpr_arr_type;

Line 2177: l_asset_retire_rec fa_api_types.asset_retire_rec_type; -- passed to deprn basis rule function

2173: l_process_this_trx boolean := TRUE; -- Become FALSE in the loop if ret has reinstated
2174: l_dummy_bool boolean;
2175:
2176: l_db_event_type varchar2(30); -- passed to deprn basis rule function
2177: l_asset_retire_rec fa_api_types.asset_retire_rec_type; -- passed to deprn basis rule function
2178: l_recoverable_cost number; -- passed to deprn basis rule function
2179: l_salvage_value number; -- passed to deprn basis rule function
2180:
2181: l_ytd_deprn number; -- used with c_get_init_rsv

Line 3255: , p_period_rec IN FA_API_TYPES.period_rec_type

3251:
3252: FUNCTION calculate_catchup(p_request_id number
3253: , p_book_type_code IN VARCHAR2
3254: , p_worker_id IN NUMBER
3255: , p_period_rec IN FA_API_TYPES.period_rec_type
3256: , p_imp_period_rec IN FA_API_TYPES.period_rec_type
3257: , p_mrc_sob_type_code IN VARCHAR2
3258: , p_calling_fn IN VARCHAR2
3259: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS

Line 3256: , p_imp_period_rec IN FA_API_TYPES.period_rec_type

3252: FUNCTION calculate_catchup(p_request_id number
3253: , p_book_type_code IN VARCHAR2
3254: , p_worker_id IN NUMBER
3255: , p_period_rec IN FA_API_TYPES.period_rec_type
3256: , p_imp_period_rec IN FA_API_TYPES.period_rec_type
3257: , p_mrc_sob_type_code IN VARCHAR2
3258: , p_calling_fn IN VARCHAR2
3259: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3260:

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

3255: , p_period_rec IN FA_API_TYPES.period_rec_type
3256: , p_imp_period_rec IN FA_API_TYPES.period_rec_type
3257: , p_mrc_sob_type_code IN VARCHAR2
3258: , p_calling_fn IN VARCHAR2
3259: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3260:
3261: l_calling_fn VARCHAR2(30) := 'calculate_catchup';
3262:
3263: CURSOR c_get_assets IS

Line 3394: l_trans_rec FA_API_TYPES.trans_rec_type;

3390: tbs_change_in_sal tab_num_type;
3391: tbs_change_in_limit tab_num_type;
3392: tbs_change_in_retirements_cost tab_num_type;
3393:
3394: l_trans_rec FA_API_TYPES.trans_rec_type;
3395: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3396: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3397: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3398: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

Line 3395: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

3391: tbs_change_in_limit tab_num_type;
3392: tbs_change_in_retirements_cost tab_num_type;
3393:
3394: l_trans_rec FA_API_TYPES.trans_rec_type;
3395: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3396: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3397: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3398: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
3399: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

Line 3396: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;

3392: tbs_change_in_retirements_cost tab_num_type;
3393:
3394: l_trans_rec FA_API_TYPES.trans_rec_type;
3395: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3396: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3397: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3398: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
3399: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3400: l_period_rec FA_API_TYPES.period_rec_type;

Line 3397: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

3393:
3394: l_trans_rec FA_API_TYPES.trans_rec_type;
3395: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3396: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3397: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3398: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
3399: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3400: l_period_rec FA_API_TYPES.period_rec_type;
3401:

Line 3398: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

3394: l_trans_rec FA_API_TYPES.trans_rec_type;
3395: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3396: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3397: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3398: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
3399: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3400: l_period_rec FA_API_TYPES.period_rec_type;
3401:
3402: l_dpr_in fa_std_types.dpr_struct;

Line 3399: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

3395: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3396: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3397: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3398: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
3399: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3400: l_period_rec FA_API_TYPES.period_rec_type;
3401:
3402: l_dpr_in fa_std_types.dpr_struct;
3403: l_dpr_out fa_std_types.dpr_out_struct;

Line 3400: l_period_rec FA_API_TYPES.period_rec_type;

3396: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3397: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3398: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
3399: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3400: l_period_rec FA_API_TYPES.period_rec_type;
3401:
3402: l_dpr_in fa_std_types.dpr_struct;
3403: l_dpr_out fa_std_types.dpr_out_struct;
3404: l_dpr_arr fa_std_types.dpr_arr_type;