8: G_PART_RET_FLAG BOOLEAN;
9:
10: -- +++++ Forward Declarations +++++
11: FUNCTION CALC_GAIN_LOSS_FOR_RET(
12: p_trans_rec IN FA_API_TYPES.trans_rec_type,
13: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
16: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
9:
10: -- +++++ Forward Declarations +++++
11: FUNCTION CALC_GAIN_LOSS_FOR_RET(
12: p_trans_rec IN FA_API_TYPES.trans_rec_type,
13: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
16: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
17: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
10: -- +++++ Forward Declarations +++++
11: FUNCTION CALC_GAIN_LOSS_FOR_RET(
12: p_trans_rec IN FA_API_TYPES.trans_rec_type,
13: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
16: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
17: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
18: p_period_rec IN FA_API_TYPES.period_rec_type,
11: FUNCTION CALC_GAIN_LOSS_FOR_RET(
12: p_trans_rec IN FA_API_TYPES.trans_rec_type,
13: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
16: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
17: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
18: p_period_rec IN FA_API_TYPES.period_rec_type,
19: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
12: p_trans_rec IN FA_API_TYPES.trans_rec_type,
13: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
16: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
17: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
18: p_period_rec IN FA_API_TYPES.period_rec_type,
19: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
20: p_group_thid IN NUMBER,
13: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
16: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
17: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
18: p_period_rec IN FA_API_TYPES.period_rec_type,
19: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
20: p_group_thid IN NUMBER,
21: p_salvage_value_retired IN NUMBER,
14: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
15: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
16: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
17: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
18: p_period_rec IN FA_API_TYPES.period_rec_type,
19: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
20: p_group_thid IN NUMBER,
21: p_salvage_value_retired IN NUMBER,
22: p_mrc_sob_type_code IN VARCHAR2,
15: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
16: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
17: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
18: p_period_rec IN FA_API_TYPES.period_rec_type,
19: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
20: p_group_thid IN NUMBER,
21: p_salvage_value_retired IN NUMBER,
22: p_mrc_sob_type_code IN VARCHAR2,
23: p_mode IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
19: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
20: p_group_thid IN NUMBER,
21: p_salvage_value_retired IN NUMBER,
22: p_mrc_sob_type_code IN VARCHAR2,
23: p_mode IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
24: RETURN BOOLEAN;
25:
26: FUNCTION CALC_GAIN_LOSS_FOR_REI(
27: p_trans_rec IN FA_API_TYPES.trans_rec_type,
23: p_mode IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
24: RETURN BOOLEAN;
25:
26: FUNCTION CALC_GAIN_LOSS_FOR_REI(
27: p_trans_rec IN FA_API_TYPES.trans_rec_type,
28: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
29: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
30: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
31: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
24: RETURN BOOLEAN;
25:
26: FUNCTION CALC_GAIN_LOSS_FOR_REI(
27: p_trans_rec IN FA_API_TYPES.trans_rec_type,
28: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
29: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
30: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
31: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
32: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
25:
26: FUNCTION CALC_GAIN_LOSS_FOR_REI(
27: p_trans_rec IN FA_API_TYPES.trans_rec_type,
28: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
29: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
30: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
31: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
32: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
33: p_period_rec IN FA_API_TYPES.period_rec_type,
26: FUNCTION CALC_GAIN_LOSS_FOR_REI(
27: p_trans_rec IN FA_API_TYPES.trans_rec_type,
28: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
29: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
30: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
31: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
32: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
33: p_period_rec IN FA_API_TYPES.period_rec_type,
34: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
27: p_trans_rec IN FA_API_TYPES.trans_rec_type,
28: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
29: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
30: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
31: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
32: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
33: p_period_rec IN FA_API_TYPES.period_rec_type,
34: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
35: p_group_thid IN NUMBER,
28: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
29: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
30: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
31: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
32: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
33: p_period_rec IN FA_API_TYPES.period_rec_type,
34: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
35: p_group_thid IN NUMBER,
36: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
29: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
30: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
31: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
32: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
33: p_period_rec IN FA_API_TYPES.period_rec_type,
34: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
35: p_group_thid IN NUMBER,
36: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
37: p_mrc_sob_type_code IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
30: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
31: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
32: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
33: p_period_rec IN FA_API_TYPES.period_rec_type,
34: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
35: p_group_thid IN NUMBER,
36: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
37: p_mrc_sob_type_code IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
38: RETURN BOOLEAN;
32: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
33: p_period_rec IN FA_API_TYPES.period_rec_type,
34: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
35: p_group_thid IN NUMBER,
36: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
37: p_mrc_sob_type_code IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
38: RETURN BOOLEAN;
39: /*bug#15897249 */
40: FUNCTION MOVE_RESERVE_TO_ACT_DIST(
33: p_period_rec IN FA_API_TYPES.period_rec_type,
34: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
35: p_group_thid IN NUMBER,
36: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
37: p_mrc_sob_type_code IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
38: RETURN BOOLEAN;
39: /*bug#15897249 */
40: FUNCTION MOVE_RESERVE_TO_ACT_DIST(
41: p_trans_rec IN FA_API_TYPES.trans_rec_type,
37: p_mrc_sob_type_code IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
38: RETURN BOOLEAN;
39: /*bug#15897249 */
40: FUNCTION MOVE_RESERVE_TO_ACT_DIST(
41: p_trans_rec IN FA_API_TYPES.trans_rec_type,
42: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
43: p_period_rec IN FA_API_TYPES.period_rec_type,
44: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
45: p_mrc_sob_type_code IN VARCHAR2,
38: RETURN BOOLEAN;
39: /*bug#15897249 */
40: FUNCTION MOVE_RESERVE_TO_ACT_DIST(
41: p_trans_rec IN FA_API_TYPES.trans_rec_type,
42: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
43: p_period_rec IN FA_API_TYPES.period_rec_type,
44: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
45: p_mrc_sob_type_code IN VARCHAR2,
46: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
39: /*bug#15897249 */
40: FUNCTION MOVE_RESERVE_TO_ACT_DIST(
41: p_trans_rec IN FA_API_TYPES.trans_rec_type,
42: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
43: p_period_rec IN FA_API_TYPES.period_rec_type,
44: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
45: p_mrc_sob_type_code IN VARCHAR2,
46: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
47: RETURN BOOLEAN;
40: FUNCTION MOVE_RESERVE_TO_ACT_DIST(
41: p_trans_rec IN FA_API_TYPES.trans_rec_type,
42: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
43: p_period_rec IN FA_API_TYPES.period_rec_type,
44: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
45: p_mrc_sob_type_code IN VARCHAR2,
46: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
47: RETURN BOOLEAN;
48: -- +++++ End of Forward Declarations +++++
42: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
43: p_period_rec IN FA_API_TYPES.period_rec_type,
44: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
45: p_mrc_sob_type_code IN VARCHAR2,
46: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
47: RETURN BOOLEAN;
48: -- +++++ End of Forward Declarations +++++
49:
50: FUNCTION DO_RETIREMENT(p_trans_rec IN FA_API_TYPES.trans_rec_type,
46: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
47: RETURN BOOLEAN;
48: -- +++++ End of Forward Declarations +++++
49:
50: FUNCTION DO_RETIREMENT(p_trans_rec IN FA_API_TYPES.trans_rec_type,
51: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
52: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
53: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
54: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
47: RETURN BOOLEAN;
48: -- +++++ End of Forward Declarations +++++
49:
50: FUNCTION DO_RETIREMENT(p_trans_rec IN FA_API_TYPES.trans_rec_type,
51: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
52: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
53: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
54: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
55: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
48: -- +++++ End of Forward Declarations +++++
49:
50: FUNCTION DO_RETIREMENT(p_trans_rec IN FA_API_TYPES.trans_rec_type,
51: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
52: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
53: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
54: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
55: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
56: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
49:
50: FUNCTION DO_RETIREMENT(p_trans_rec IN FA_API_TYPES.trans_rec_type,
51: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
52: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
53: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
54: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
55: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
56: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
57: p_period_rec IN FA_API_TYPES.period_rec_type,
50: FUNCTION DO_RETIREMENT(p_trans_rec IN FA_API_TYPES.trans_rec_type,
51: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
52: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
53: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
54: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
55: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
56: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
57: p_period_rec IN FA_API_TYPES.period_rec_type,
58: p_mrc_sob_type_code IN VARCHAR2,
51: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
52: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
53: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
54: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
55: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
56: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
57: p_period_rec IN FA_API_TYPES.period_rec_type,
58: p_mrc_sob_type_code IN VARCHAR2,
59: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
52: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
53: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
54: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
55: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
56: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
57: p_period_rec IN FA_API_TYPES.period_rec_type,
58: p_mrc_sob_type_code IN VARCHAR2,
59: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
60: return boolean IS
53: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
54: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
55: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
56: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
57: p_period_rec IN FA_API_TYPES.period_rec_type,
58: p_mrc_sob_type_code IN VARCHAR2,
59: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
60: return boolean IS
61:
55: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
56: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
57: p_period_rec IN FA_API_TYPES.period_rec_type,
58: p_mrc_sob_type_code IN VARCHAR2,
59: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
60: return boolean IS
61:
62: l_trans_rec FA_API_TYPES.trans_rec_type;
63: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
58: p_mrc_sob_type_code IN VARCHAR2,
59: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
60: return boolean IS
61:
62: l_trans_rec FA_API_TYPES.trans_rec_type;
63: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
64:
65: CURSOR c_get_group_exp_row IS
66: select adjustment_type,
59: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
60: return boolean IS
61:
62: l_trans_rec FA_API_TYPES.trans_rec_type;
63: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
64:
65: CURSOR c_get_group_exp_row IS
66: select adjustment_type,
67: debit_credit_flag,
103: l_calling_fn VARCHAR2(100) := 'fa_retirement_pvt.do_retirement';
104:
105: l_transaction_header_id FA_TRANSACTION_HEADERS.TRANSACTION_HEADER_ID%TYPE;
106:
107: l_asset_desc_rec_m FA_API_TYPES.asset_desc_rec_type;
108: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
109: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
110: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
111: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
104:
105: l_transaction_header_id FA_TRANSACTION_HEADERS.TRANSACTION_HEADER_ID%TYPE;
106:
107: l_asset_desc_rec_m FA_API_TYPES.asset_desc_rec_type;
108: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
109: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
110: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
111: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
112: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
105: l_transaction_header_id FA_TRANSACTION_HEADERS.TRANSACTION_HEADER_ID%TYPE;
106:
107: l_asset_desc_rec_m FA_API_TYPES.asset_desc_rec_type;
108: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
109: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
110: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
111: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
112: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
113: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
106:
107: l_asset_desc_rec_m FA_API_TYPES.asset_desc_rec_type;
108: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
109: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
110: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
111: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
112: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
113: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
114: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
107: l_asset_desc_rec_m FA_API_TYPES.asset_desc_rec_type;
108: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
109: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
110: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
111: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
112: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
113: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
114: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
115: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
108: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
109: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
110: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
111: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
112: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
113: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
114: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
115: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
116: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
109: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
110: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
111: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
112: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
113: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
114: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
115: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
116: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
117: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
110: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
111: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
112: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
113: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
114: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
115: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
116: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
117: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
118: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
111: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
112: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
113: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
114: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
115: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
116: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
117: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
118: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
119:
112: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
113: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
114: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
115: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
116: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
117: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
118: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
119:
120: /*bug#15897249 starts*/
113: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
114: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
115: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
116: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
117: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
118: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
119:
120: /*bug#15897249 starts*/
121: l_asset_fin_rec_old_g FA_API_TYPES.asset_fin_rec_type;
114: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
115: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
116: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
117: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
118: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
119:
120: /*bug#15897249 starts*/
121: l_asset_fin_rec_old_g FA_API_TYPES.asset_fin_rec_type;
122: l_asset_deprn_rec_old_g FA_API_TYPES.asset_deprn_rec_type;
117: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
118: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
119:
120: /*bug#15897249 starts*/
121: l_asset_fin_rec_old_g FA_API_TYPES.asset_fin_rec_type;
122: l_asset_deprn_rec_old_g FA_API_TYPES.asset_deprn_rec_type;
123: l_trans_rec_g FA_API_TYPES.trans_rec_type;
124: /*bug#15897249 ends */
125: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
118: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
119:
120: /*bug#15897249 starts*/
121: l_asset_fin_rec_old_g FA_API_TYPES.asset_fin_rec_type;
122: l_asset_deprn_rec_old_g FA_API_TYPES.asset_deprn_rec_type;
123: l_trans_rec_g FA_API_TYPES.trans_rec_type;
124: /*bug#15897249 ends */
125: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
126:
119:
120: /*bug#15897249 starts*/
121: l_asset_fin_rec_old_g FA_API_TYPES.asset_fin_rec_type;
122: l_asset_deprn_rec_old_g FA_API_TYPES.asset_deprn_rec_type;
123: l_trans_rec_g FA_API_TYPES.trans_rec_type;
124: /*bug#15897249 ends */
125: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
126:
127: l_deprn_exp NUMBER;
121: l_asset_fin_rec_old_g FA_API_TYPES.asset_fin_rec_type;
122: l_asset_deprn_rec_old_g FA_API_TYPES.asset_deprn_rec_type;
123: l_trans_rec_g FA_API_TYPES.trans_rec_type;
124: /*bug#15897249 ends */
125: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
126:
127: l_deprn_exp NUMBER;
128: l_bonus_deprn_exp NUMBER;
129: l_impairment_exp NUMBER;
687:
688: END DO_RETIREMENT;
689:
690: FUNCTION UNDO_RETIREMENT_REINSTATEMENT(p_transaction_header_id IN NUMBER,
691: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
692: p_group_asset_id IN NUMBER,
693: p_set_of_books_id IN NUMBER,
694: p_mrc_sob_type_code IN VARCHAR2,
695: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
691: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
692: p_group_asset_id IN NUMBER,
693: p_set_of_books_id IN NUMBER,
694: p_mrc_sob_type_code IN VARCHAR2,
695: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
696: return boolean IS
697:
698: CURSOR c_get_thid IS
699: select transaction_header_id
792:
793: END UNDO_RETIREMENT_REINSTATEMENT;
794:
795: FUNCTION DO_REINSTATEMENT(
796: p_trans_rec IN FA_API_TYPES.trans_rec_type,
797: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
798: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
799: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
800: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
793: END UNDO_RETIREMENT_REINSTATEMENT;
794:
795: FUNCTION DO_REINSTATEMENT(
796: p_trans_rec IN FA_API_TYPES.trans_rec_type,
797: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
798: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
799: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
800: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
801: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
794:
795: FUNCTION DO_REINSTATEMENT(
796: p_trans_rec IN FA_API_TYPES.trans_rec_type,
797: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
798: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
799: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
800: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
801: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
802: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
795: FUNCTION DO_REINSTATEMENT(
796: p_trans_rec IN FA_API_TYPES.trans_rec_type,
797: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
798: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
799: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
800: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
801: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
802: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
803: p_period_rec IN FA_API_TYPES.period_rec_type,
796: p_trans_rec IN FA_API_TYPES.trans_rec_type,
797: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
798: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
799: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
800: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
801: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
802: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
803: p_period_rec IN FA_API_TYPES.period_rec_type,
804: p_mrc_sob_type_code IN VARCHAR2,
797: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
798: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
799: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
800: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
801: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
802: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
803: p_period_rec IN FA_API_TYPES.period_rec_type,
804: p_mrc_sob_type_code IN VARCHAR2,
805: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
798: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
799: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
800: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
801: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
802: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
803: p_period_rec IN FA_API_TYPES.period_rec_type,
804: p_mrc_sob_type_code IN VARCHAR2,
805: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
806: return boolean IS
799: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
800: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
801: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
802: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
803: p_period_rec IN FA_API_TYPES.period_rec_type,
804: p_mrc_sob_type_code IN VARCHAR2,
805: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
806: return boolean IS
807:
801: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
802: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
803: p_period_rec IN FA_API_TYPES.period_rec_type,
804: p_mrc_sob_type_code IN VARCHAR2,
805: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
806: return boolean IS
807:
808: l_calling_fn VARCHAR2(100) := 'fa_group_retirement_pvt.do_reinstatement';
809:
840: where asset_id = p_asset_hdr_rec.asset_id
841: and book_type_code = p_asset_hdr_rec.book_type_code
842: and transaction_header_id = p_asset_retire_rec.detail_info.transaction_header_id_in;
843:
844: l_trans_rec FA_API_TYPES.trans_rec_type;
845: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
846:
847:
848: CURSOR c_get_thid is
841: and book_type_code = p_asset_hdr_rec.book_type_code
842: and transaction_header_id = p_asset_retire_rec.detail_info.transaction_header_id_in;
843:
844: l_trans_rec FA_API_TYPES.trans_rec_type;
845: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
846:
847:
848: CURSOR c_get_thid is
849: select fa_transaction_headers_s.nextval
883: l_bonus_deprn_exp NUMBER;
884: l_impairment_exp NUMBER;
885:
886: -- +++++ Stores new fin_rec of member +++++
887: l_asset_fin_rec_mn FA_API_TYPES.asset_fin_rec_type;
888:
889: l_period_rec FA_API_TYPES.period_rec_type;
890: l_asset_desc_rec_m FA_API_TYPES.asset_desc_rec_type;
891: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
885:
886: -- +++++ Stores new fin_rec of member +++++
887: l_asset_fin_rec_mn FA_API_TYPES.asset_fin_rec_type;
888:
889: l_period_rec FA_API_TYPES.period_rec_type;
890: l_asset_desc_rec_m FA_API_TYPES.asset_desc_rec_type;
891: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
892: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
893: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
886: -- +++++ Stores new fin_rec of member +++++
887: l_asset_fin_rec_mn FA_API_TYPES.asset_fin_rec_type;
888:
889: l_period_rec FA_API_TYPES.period_rec_type;
890: l_asset_desc_rec_m FA_API_TYPES.asset_desc_rec_type;
891: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
892: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
893: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
894: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
887: l_asset_fin_rec_mn FA_API_TYPES.asset_fin_rec_type;
888:
889: l_period_rec FA_API_TYPES.period_rec_type;
890: l_asset_desc_rec_m FA_API_TYPES.asset_desc_rec_type;
891: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
892: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
893: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
894: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
895: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
888:
889: l_period_rec FA_API_TYPES.period_rec_type;
890: l_asset_desc_rec_m FA_API_TYPES.asset_desc_rec_type;
891: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
892: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
893: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
894: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
895: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
896: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
889: l_period_rec FA_API_TYPES.period_rec_type;
890: l_asset_desc_rec_m FA_API_TYPES.asset_desc_rec_type;
891: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
892: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
893: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
894: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
895: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
896: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
897: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
890: l_asset_desc_rec_m FA_API_TYPES.asset_desc_rec_type;
891: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
892: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
893: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
894: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
895: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
896: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
897: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
898: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
891: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
892: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
893: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
894: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
895: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
896: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
897: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
898: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
899: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
892: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
893: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
894: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
895: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
896: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
897: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
898: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
899: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
900: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
893: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
894: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
895: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
896: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
897: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
898: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
899: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
900: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
901: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
894: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
895: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
896: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
897: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
898: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
899: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
900: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
901: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
902: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
895: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
896: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
897: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
898: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
899: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
900: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
901: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
902: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
903:
896: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
897: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
898: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
899: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
900: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
901: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
902: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
903:
904: l_salvage_value_retired NUMBER;
897: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
898: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
899: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
900: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
901: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
902: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
903:
904: l_salvage_value_retired NUMBER;
905: l_cip_cost_retired NUMBER;
898: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
899: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
900: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
901: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
902: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
903:
904: l_salvage_value_retired NUMBER;
905: l_cip_cost_retired NUMBER;
906: l_adj_rec_cost_retired NUMBER;
1512: | retirement. |
1513: | |
1514: +====================================================================*/
1515: FUNCTION CALC_GAIN_LOSS_FOR_RET(
1516: p_trans_rec IN FA_API_TYPES.trans_rec_type,
1517: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1518: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1519: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1520: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1513: | |
1514: +====================================================================*/
1515: FUNCTION CALC_GAIN_LOSS_FOR_RET(
1516: p_trans_rec IN FA_API_TYPES.trans_rec_type,
1517: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1518: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1519: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1520: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1521: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
1514: +====================================================================*/
1515: FUNCTION CALC_GAIN_LOSS_FOR_RET(
1516: p_trans_rec IN FA_API_TYPES.trans_rec_type,
1517: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1518: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1519: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1520: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1521: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
1522: p_period_rec IN FA_API_TYPES.period_rec_type,
1515: FUNCTION CALC_GAIN_LOSS_FOR_RET(
1516: p_trans_rec IN FA_API_TYPES.trans_rec_type,
1517: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1518: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1519: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1520: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1521: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
1522: p_period_rec IN FA_API_TYPES.period_rec_type,
1523: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
1516: p_trans_rec IN FA_API_TYPES.trans_rec_type,
1517: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1518: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1519: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1520: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1521: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
1522: p_period_rec IN FA_API_TYPES.period_rec_type,
1523: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
1524: p_group_thid IN NUMBER,
1517: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1518: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1519: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1520: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1521: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
1522: p_period_rec IN FA_API_TYPES.period_rec_type,
1523: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
1524: p_group_thid IN NUMBER,
1525: p_salvage_value_retired IN NUMBER,
1518: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1519: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1520: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1521: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
1522: p_period_rec IN FA_API_TYPES.period_rec_type,
1523: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
1524: p_group_thid IN NUMBER,
1525: p_salvage_value_retired IN NUMBER,
1526: p_mrc_sob_type_code IN VARCHAR2,
1519: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1520: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1521: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
1522: p_period_rec IN FA_API_TYPES.period_rec_type,
1523: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
1524: p_group_thid IN NUMBER,
1525: p_salvage_value_retired IN NUMBER,
1526: p_mrc_sob_type_code IN VARCHAR2,
1527: p_mode IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
1523: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
1524: p_group_thid IN NUMBER,
1525: p_salvage_value_retired IN NUMBER,
1526: p_mrc_sob_type_code IN VARCHAR2,
1527: p_mode IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
1528: return BOOLEAN is
1529:
1530: /* --Commented out as part of fix for 3188851.
1531: -- Cursor to get transaction header id of transfer out in
1550: and mt.deprn_basis_rule_id = db.deprn_basis_rule_id; -- ENERGY
1551:
1552: l_calling_fn VARCHAR2(100) := 'fa_retirement_pvt.calc_gain_loss_for_ret';
1553:
1554: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1555: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1556:
1557: l_trans_rec FA_API_TYPES.trans_rec_type;
1558: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1551:
1552: l_calling_fn VARCHAR2(100) := 'fa_retirement_pvt.calc_gain_loss_for_ret';
1553:
1554: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1555: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1556:
1557: l_trans_rec FA_API_TYPES.trans_rec_type;
1558: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1559: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1553:
1554: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1555: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1556:
1557: l_trans_rec FA_API_TYPES.trans_rec_type;
1558: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1559: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1560: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1561:
1554: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1555: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1556:
1557: l_trans_rec FA_API_TYPES.trans_rec_type;
1558: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1559: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1560: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1561:
1562: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
1555: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1556:
1557: l_trans_rec FA_API_TYPES.trans_rec_type;
1558: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1559: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1560: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1561:
1562: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
1563:
1556:
1557: l_trans_rec FA_API_TYPES.trans_rec_type;
1558: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1559: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1560: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
1561:
1562: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
1563:
1564: l_deprn_exp NUMBER;
2314: | reinstatement. |
2315: | |
2316: +====================================================================*/
2317: FUNCTION CALC_GAIN_LOSS_FOR_REI(
2318: p_trans_rec IN FA_API_TYPES.trans_rec_type,
2319: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2320: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2321: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2322: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2315: | |
2316: +====================================================================*/
2317: FUNCTION CALC_GAIN_LOSS_FOR_REI(
2318: p_trans_rec IN FA_API_TYPES.trans_rec_type,
2319: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2320: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2321: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2322: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2323: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
2316: +====================================================================*/
2317: FUNCTION CALC_GAIN_LOSS_FOR_REI(
2318: p_trans_rec IN FA_API_TYPES.trans_rec_type,
2319: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2320: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2321: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2322: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2323: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
2324: p_period_rec IN FA_API_TYPES.period_rec_type,
2317: FUNCTION CALC_GAIN_LOSS_FOR_REI(
2318: p_trans_rec IN FA_API_TYPES.trans_rec_type,
2319: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2320: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2321: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2322: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2323: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
2324: p_period_rec IN FA_API_TYPES.period_rec_type,
2325: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
2318: p_trans_rec IN FA_API_TYPES.trans_rec_type,
2319: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2320: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2321: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2322: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2323: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
2324: p_period_rec IN FA_API_TYPES.period_rec_type,
2325: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
2326: p_group_thid IN NUMBER,
2319: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2320: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2321: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2322: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2323: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
2324: p_period_rec IN FA_API_TYPES.period_rec_type,
2325: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
2326: p_group_thid IN NUMBER,
2327: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2320: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2321: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2322: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2323: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
2324: p_period_rec IN FA_API_TYPES.period_rec_type,
2325: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
2326: p_group_thid IN NUMBER,
2327: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2328: p_mrc_sob_type_code IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
2321: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2322: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2323: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
2324: p_period_rec IN FA_API_TYPES.period_rec_type,
2325: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
2326: p_group_thid IN NUMBER,
2327: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2328: p_mrc_sob_type_code IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
2329: RETURN BOOLEAN IS
2323: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
2324: p_period_rec IN FA_API_TYPES.period_rec_type,
2325: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
2326: p_group_thid IN NUMBER,
2327: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2328: p_mrc_sob_type_code IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
2329: RETURN BOOLEAN IS
2330:
2331: l_calling_fn VARCHAR2(100) := 'fa_group_retirement_pvt.calc_gain_loss_for_rei';
2324: p_period_rec IN FA_API_TYPES.period_rec_type,
2325: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
2326: p_group_thid IN NUMBER,
2327: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2328: p_mrc_sob_type_code IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
2329: RETURN BOOLEAN IS
2330:
2331: l_calling_fn VARCHAR2(100) := 'fa_group_retirement_pvt.calc_gain_loss_for_rei';
2332:
2378:
2379: l_group_thid NUMBER(15);
2380: l_group_asset_id NUMBER(15);
2381: l_date_effective DATE;
2382: l_period_rec FA_API_TYPES.period_rec_type;
2383:
2384: -- BUG# 3031357
2385: -- adding additional columns to use N2 index for performance
2386:
2432:
2433: l_ret_period_counter NUMBER := to_number(null);
2434: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
2435:
2436: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
2437: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
2438:
2439: l_trans_rec FA_API_TYPES.trans_rec_type;
2440: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
2433: l_ret_period_counter NUMBER := to_number(null);
2434: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
2435:
2436: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
2437: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
2438:
2439: l_trans_rec FA_API_TYPES.trans_rec_type;
2440: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
2441: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
2435:
2436: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
2437: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
2438:
2439: l_trans_rec FA_API_TYPES.trans_rec_type;
2440: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
2441: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
2442: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
2443:
2436: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
2437: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
2438:
2439: l_trans_rec FA_API_TYPES.trans_rec_type;
2440: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
2441: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
2442: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
2443:
2444: l_deprn_exp NUMBER;
2437: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
2438:
2439: l_trans_rec FA_API_TYPES.trans_rec_type;
2440: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
2441: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
2442: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
2443:
2444: l_deprn_exp NUMBER;
2445: l_bonus_deprn_exp NUMBER;
2438:
2439: l_trans_rec FA_API_TYPES.trans_rec_type;
2440: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
2441: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
2442: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
2443:
2444: l_deprn_exp NUMBER;
2445: l_bonus_deprn_exp NUMBER;
2446: l_impairment_exp NUMBER;
3127: FUNCTION Do_Retirement_in_CGL(
3128: p_ret IN fa_ret_types.ret_struct,
3129: p_bk IN fa_ret_types.book_struct,
3130: p_dpr IN fa_STD_TYPES.dpr_struct,
3131: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
3132: p_mrc_sob_type_code IN VARCHAR2,
3133: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
3134: return boolean IS
3135:
3129: p_bk IN fa_ret_types.book_struct,
3130: p_dpr IN fa_STD_TYPES.dpr_struct,
3131: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
3132: p_mrc_sob_type_code IN VARCHAR2,
3133: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
3134: return boolean IS
3135:
3136: CURSOR c_get_thid is
3137: select fa_transaction_headers_s.nextval
3172: and set_of_books_id = p_ret.set_of_books_id;
3173:
3174: l_calling_fn VARCHAR2(100) := 'fa_retirement_pvt.Do_Retirement_in_CGL';
3175:
3176: l_trans_rec FA_API_TYPES.trans_rec_type;
3177: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3178: l_asset_hdr_rec_m FA_API_TYPES.asset_hdr_rec_type;
3179: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3180: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3173:
3174: l_calling_fn VARCHAR2(100) := 'fa_retirement_pvt.Do_Retirement_in_CGL';
3175:
3176: l_trans_rec FA_API_TYPES.trans_rec_type;
3177: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3178: l_asset_hdr_rec_m FA_API_TYPES.asset_hdr_rec_type;
3179: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3180: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3181: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
3174: l_calling_fn VARCHAR2(100) := 'fa_retirement_pvt.Do_Retirement_in_CGL';
3175:
3176: l_trans_rec FA_API_TYPES.trans_rec_type;
3177: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3178: l_asset_hdr_rec_m FA_API_TYPES.asset_hdr_rec_type;
3179: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3180: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3181: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
3182: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
3175:
3176: l_trans_rec FA_API_TYPES.trans_rec_type;
3177: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3178: l_asset_hdr_rec_m FA_API_TYPES.asset_hdr_rec_type;
3179: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3180: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3181: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
3182: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
3183: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3176: l_trans_rec FA_API_TYPES.trans_rec_type;
3177: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3178: l_asset_hdr_rec_m FA_API_TYPES.asset_hdr_rec_type;
3179: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3180: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3181: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
3182: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
3183: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3184: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
3177: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3178: l_asset_hdr_rec_m FA_API_TYPES.asset_hdr_rec_type;
3179: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3180: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3181: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
3182: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
3183: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3184: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
3185: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3178: l_asset_hdr_rec_m FA_API_TYPES.asset_hdr_rec_type;
3179: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3180: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3181: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
3182: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
3183: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3184: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
3185: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3186: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
3179: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3180: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3181: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
3182: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
3183: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3184: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
3185: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3186: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
3187: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
3180: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3181: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
3182: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
3183: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3184: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
3185: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3186: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
3187: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
3188: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
3181: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
3182: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
3183: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3184: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
3185: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3186: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
3187: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
3188: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
3189: l_period_rec FA_API_TYPES.period_rec_type;
3182: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
3183: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3184: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
3185: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3186: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
3187: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
3188: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
3189: l_period_rec FA_API_TYPES.period_rec_type;
3190: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
3183: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3184: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
3185: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3186: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
3187: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
3188: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
3189: l_period_rec FA_API_TYPES.period_rec_type;
3190: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
3191:
3184: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
3185: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3186: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
3187: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
3188: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
3189: l_period_rec FA_API_TYPES.period_rec_type;
3190: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
3191:
3192: l_member_exists VARCHAR2(1) := 'N';
3185: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3186: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
3187: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
3188: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
3189: l_period_rec FA_API_TYPES.period_rec_type;
3190: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
3191:
3192: l_member_exists VARCHAR2(1) := 'N';
3193: l_deprn_reserve NUMBER;
3186: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
3187: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
3188: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
3189: l_period_rec FA_API_TYPES.period_rec_type;
3190: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
3191:
3192: l_member_exists VARCHAR2(1) := 'N';
3193: l_deprn_reserve NUMBER;
3194: l_temp_num NUMBER;
3599: p_ret IN fa_ret_types.ret_struct,
3600: p_bk IN fa_ret_types.book_struct,
3601: p_dpr IN fa_STD_TYPES.dpr_struct,
3602: p_mrc_sob_type_code IN VARCHAR2,
3603: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
3604: return boolean IS
3605:
3606: CURSOR c_get_thid is
3607: select fa_transaction_headers_s.nextval
3686: and aj.set_of_books_id = p_ret.set_of_books_id;
3687:
3688: l_calling_fn VARCHAR2(100) := 'fa_retirement_pvt.Do_Reinstatement_in_CGL';
3689:
3690: l_trans_rec FA_API_TYPES.trans_rec_type;
3691: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3692: l_asset_hdr_rec_m FA_API_TYPES.asset_hdr_rec_type;
3693: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3694: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3687:
3688: l_calling_fn VARCHAR2(100) := 'fa_retirement_pvt.Do_Reinstatement_in_CGL';
3689:
3690: l_trans_rec FA_API_TYPES.trans_rec_type;
3691: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3692: l_asset_hdr_rec_m FA_API_TYPES.asset_hdr_rec_type;
3693: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3694: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3695: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
3688: l_calling_fn VARCHAR2(100) := 'fa_retirement_pvt.Do_Reinstatement_in_CGL';
3689:
3690: l_trans_rec FA_API_TYPES.trans_rec_type;
3691: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3692: l_asset_hdr_rec_m FA_API_TYPES.asset_hdr_rec_type;
3693: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3694: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3695: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
3696: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
3689:
3690: l_trans_rec FA_API_TYPES.trans_rec_type;
3691: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3692: l_asset_hdr_rec_m FA_API_TYPES.asset_hdr_rec_type;
3693: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3694: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3695: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
3696: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
3697: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3690: l_trans_rec FA_API_TYPES.trans_rec_type;
3691: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3692: l_asset_hdr_rec_m FA_API_TYPES.asset_hdr_rec_type;
3693: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3694: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3695: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
3696: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
3697: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3698: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
3691: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3692: l_asset_hdr_rec_m FA_API_TYPES.asset_hdr_rec_type;
3693: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3694: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3695: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
3696: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
3697: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3698: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
3699: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3692: l_asset_hdr_rec_m FA_API_TYPES.asset_hdr_rec_type;
3693: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3694: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3695: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
3696: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
3697: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3698: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
3699: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3700: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
3693: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3694: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3695: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
3696: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
3697: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3698: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
3699: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3700: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
3701: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
3694: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3695: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
3696: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
3697: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3698: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
3699: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3700: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
3701: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
3702: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
3695: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
3696: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
3697: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3698: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
3699: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3700: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
3701: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
3702: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
3703: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
3696: l_asset_fin_rec_new_m FA_API_TYPES.asset_fin_rec_type;
3697: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3698: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
3699: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3700: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
3701: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
3702: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
3703: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
3704: l_period_rec FA_API_TYPES.period_rec_type;
3697: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
3698: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
3699: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3700: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
3701: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
3702: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
3703: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
3704: l_period_rec FA_API_TYPES.period_rec_type;
3705: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
3698: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
3699: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3700: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
3701: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
3702: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
3703: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
3704: l_period_rec FA_API_TYPES.period_rec_type;
3705: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
3706:
3699: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
3700: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
3701: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
3702: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
3703: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
3704: l_period_rec FA_API_TYPES.period_rec_type;
3705: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
3706:
3707: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT; --Bug11886090
3700: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
3701: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
3702: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
3703: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
3704: l_period_rec FA_API_TYPES.period_rec_type;
3705: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
3706:
3707: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT; --Bug11886090
3708:
3701: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
3702: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
3703: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
3704: l_period_rec FA_API_TYPES.period_rec_type;
3705: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
3706:
3707: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT; --Bug11886090
3708:
3709: calc_err EXCEPTION;
4014:
4015: FUNCTION Do_Terminal_Gain_Loss_All_Bk (
4016: p_book_type_code VARCHAR2,
4017: p_asset_id NUMBER,
4018: p_period_rec FA_API_TYPES.period_rec_type,
4019: p_mrc_sob_type_code VARCHAR2,
4020: p_set_of_books_id NUMBER,
4021: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)RETURN BOOLEAN IS
4022:
4017: p_asset_id NUMBER,
4018: p_period_rec FA_API_TYPES.period_rec_type,
4019: p_mrc_sob_type_code VARCHAR2,
4020: p_set_of_books_id NUMBER,
4021: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)RETURN BOOLEAN IS
4022:
4023: l_calling_fn VARCHAR2(50) := 'FA_RETIREMENT_PVT.Do_Terminal_Gain_Loss_All_Bk';
4024:
4025: cursor c_member_exists IS
4083: where asset_id = p_asset_id
4084: and transaction_header_id_out is null;
4085:
4086: l_adj fa_adjust_type_pkg.fa_adj_row_struct;
4087: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
4088:
4089: l_member_exists VARCHAR2(1) := 'N';
4090: l_deprn_reserve NUMBER;
4091: l_last_update_date DATE := sysdate;
4286: p_book_type_code VARCHAR2,
4287: p_set_of_books_id NUMBER,
4288: p_total_requests NUMBER,
4289: p_request_number NUMBER,
4290: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)RETURN BOOLEAN IS
4291:
4292: l_calling_fn VARCHAR2(50) := 'FA_RETIREMENT_PVT.Do_Terminal_Gain_Loss';
4293:
4294: l_period_rec FA_API_TYPES.period_rec_type;
4290: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)RETURN BOOLEAN IS
4291:
4292: l_calling_fn VARCHAR2(50) := 'FA_RETIREMENT_PVT.Do_Terminal_Gain_Loss';
4293:
4294: l_period_rec FA_API_TYPES.period_rec_type;
4295:
4296: cursor c_get_groups is
4297: select bk.asset_id asset_id
4298: from fa_books bk,
4447:
4448: END Do_Terminal_Gain_Loss;
4449:
4450: FUNCTION Check_Terminal_Gain_Loss(
4451: p_trans_rec IN FA_API_TYPES.trans_rec_type,
4452: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4453: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4454: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
4455: p_period_rec IN FA_API_TYPES.period_rec_type,
4448: END Do_Terminal_Gain_Loss;
4449:
4450: FUNCTION Check_Terminal_Gain_Loss(
4451: p_trans_rec IN FA_API_TYPES.trans_rec_type,
4452: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4453: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4454: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
4455: p_period_rec IN FA_API_TYPES.period_rec_type,
4456: p_mrc_sob_type_code IN VARCHAR2,
4449:
4450: FUNCTION Check_Terminal_Gain_Loss(
4451: p_trans_rec IN FA_API_TYPES.trans_rec_type,
4452: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4453: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4454: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
4455: p_period_rec IN FA_API_TYPES.period_rec_type,
4456: p_mrc_sob_type_code IN VARCHAR2,
4457: p_calling_fn IN VARCHAR2
4450: FUNCTION Check_Terminal_Gain_Loss(
4451: p_trans_rec IN FA_API_TYPES.trans_rec_type,
4452: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4453: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4454: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
4455: p_period_rec IN FA_API_TYPES.period_rec_type,
4456: p_mrc_sob_type_code IN VARCHAR2,
4457: p_calling_fn IN VARCHAR2
4458: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4451: p_trans_rec IN FA_API_TYPES.trans_rec_type,
4452: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4453: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4454: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
4455: p_period_rec IN FA_API_TYPES.period_rec_type,
4456: p_mrc_sob_type_code IN VARCHAR2,
4457: p_calling_fn IN VARCHAR2
4458: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4459:
4454: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
4455: p_period_rec IN FA_API_TYPES.period_rec_type,
4456: p_mrc_sob_type_code IN VARCHAR2,
4457: p_calling_fn IN VARCHAR2
4458: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4459:
4460: l_calling_fn VARCHAR2(50) := 'FA_RETIREMENT_PVT.Check_Terminal_Gain_Loss';
4461:
4462: --
4680:
4681: END Check_Terminal_Gain_Loss;
4682:
4683: FUNCTION Do_Allocation(
4684: p_trans_rec IN FA_API_TYPES.trans_rec_type,
4685: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4686: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
4687: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4688: p_period_rec IN FA_API_TYPES.period_rec_type,
4681: END Check_Terminal_Gain_Loss;
4682:
4683: FUNCTION Do_Allocation(
4684: p_trans_rec IN FA_API_TYPES.trans_rec_type,
4685: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4686: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
4687: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4688: p_period_rec IN FA_API_TYPES.period_rec_type,
4689: p_reserve_amount IN NUMBER,
4682:
4683: FUNCTION Do_Allocation(
4684: p_trans_rec IN FA_API_TYPES.trans_rec_type,
4685: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4686: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
4687: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4688: p_period_rec IN FA_API_TYPES.period_rec_type,
4689: p_reserve_amount IN NUMBER,
4690: p_mem_ret_thid IN NUMBER DEFAULT NULL,
4683: FUNCTION Do_Allocation(
4684: p_trans_rec IN FA_API_TYPES.trans_rec_type,
4685: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4686: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
4687: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4688: p_period_rec IN FA_API_TYPES.period_rec_type,
4689: p_reserve_amount IN NUMBER,
4690: p_mem_ret_thid IN NUMBER DEFAULT NULL,
4691: p_mode IN VARCHAR2 DEFAULT 'NORMAL',
4684: p_trans_rec IN FA_API_TYPES.trans_rec_type,
4685: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4686: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
4687: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4688: p_period_rec IN FA_API_TYPES.period_rec_type,
4689: p_reserve_amount IN NUMBER,
4690: p_mem_ret_thid IN NUMBER DEFAULT NULL,
4691: p_mode IN VARCHAR2 DEFAULT 'NORMAL',
4692: p_mrc_sob_type_code IN VARCHAR2,
4689: p_reserve_amount IN NUMBER,
4690: p_mem_ret_thid IN NUMBER DEFAULT NULL,
4691: p_mode IN VARCHAR2 DEFAULT 'NORMAL',
4692: p_mrc_sob_type_code IN VARCHAR2,
4693: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
4694: RETURN BOOLEAN IS
4695:
4696: l_calling_fn varchar2(40) := 'FA_RETIREMENT_PVT.Do_Allocation';
4697: /* bug 8633654 starts*/
6728: END Do_Allocation;
6729:
6730: /*bug#15897249 starts */
6731: FUNCTION MOVE_RESERVE_TO_ACT_DIST(
6732: p_trans_rec IN FA_API_TYPES.trans_rec_type,
6733: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6734: p_period_rec IN FA_API_TYPES.period_rec_type,
6735: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
6736: p_mrc_sob_type_code IN VARCHAR2,
6729:
6730: /*bug#15897249 starts */
6731: FUNCTION MOVE_RESERVE_TO_ACT_DIST(
6732: p_trans_rec IN FA_API_TYPES.trans_rec_type,
6733: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6734: p_period_rec IN FA_API_TYPES.period_rec_type,
6735: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
6736: p_mrc_sob_type_code IN VARCHAR2,
6737: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
6730: /*bug#15897249 starts */
6731: FUNCTION MOVE_RESERVE_TO_ACT_DIST(
6732: p_trans_rec IN FA_API_TYPES.trans_rec_type,
6733: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6734: p_period_rec IN FA_API_TYPES.period_rec_type,
6735: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
6736: p_mrc_sob_type_code IN VARCHAR2,
6737: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
6738: RETURN BOOLEAN is
6731: FUNCTION MOVE_RESERVE_TO_ACT_DIST(
6732: p_trans_rec IN FA_API_TYPES.trans_rec_type,
6733: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6734: p_period_rec IN FA_API_TYPES.period_rec_type,
6735: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
6736: p_mrc_sob_type_code IN VARCHAR2,
6737: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
6738: RETURN BOOLEAN is
6739: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
6733: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6734: p_period_rec IN FA_API_TYPES.period_rec_type,
6735: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
6736: p_mrc_sob_type_code IN VARCHAR2,
6737: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
6738: RETURN BOOLEAN is
6739: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
6740: calc_err exception;
6741: l_calling_fn VARCHAR2(100) := 'fa_group_retirement_pvt.move_reserve_to_act_dist';