1: PACKAGE FA_RETIREMENT_PVT AUTHID CURRENT_USER as
2: /* $Header: FAVRETS.pls 120.12 2009/04/15 15:22:28 bridgway ship $ */
3:
4: FUNCTION DO_RETIREMENT(p_trans_rec IN FA_API_TYPES.trans_rec_type,
5: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
6: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
8: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1: PACKAGE FA_RETIREMENT_PVT AUTHID CURRENT_USER as
2: /* $Header: FAVRETS.pls 120.12 2009/04/15 15:22:28 bridgway ship $ */
3:
4: FUNCTION DO_RETIREMENT(p_trans_rec IN FA_API_TYPES.trans_rec_type,
5: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
6: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
8: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
9: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
2: /* $Header: FAVRETS.pls 120.12 2009/04/15 15:22:28 bridgway ship $ */
3:
4: FUNCTION DO_RETIREMENT(p_trans_rec IN FA_API_TYPES.trans_rec_type,
5: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
6: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
8: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
9: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
10: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3:
4: FUNCTION DO_RETIREMENT(p_trans_rec IN FA_API_TYPES.trans_rec_type,
5: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
6: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
8: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
9: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
10: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
11: p_period_rec IN FA_API_TYPES.period_rec_type,
4: FUNCTION DO_RETIREMENT(p_trans_rec IN FA_API_TYPES.trans_rec_type,
5: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
6: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
8: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
9: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
10: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
11: p_period_rec IN FA_API_TYPES.period_rec_type,
12: p_mrc_sob_type_code IN VARCHAR2,
5: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
6: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
8: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
9: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
10: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
11: p_period_rec IN FA_API_TYPES.period_rec_type,
12: p_mrc_sob_type_code IN VARCHAR2,
13: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
6: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
8: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
9: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
10: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
11: p_period_rec IN FA_API_TYPES.period_rec_type,
12: p_mrc_sob_type_code IN VARCHAR2,
13: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
14: return boolean;
7: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
8: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
9: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
10: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
11: p_period_rec IN FA_API_TYPES.period_rec_type,
12: p_mrc_sob_type_code IN VARCHAR2,
13: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
14: return boolean;
15:
9: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
10: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
11: p_period_rec IN FA_API_TYPES.period_rec_type,
12: p_mrc_sob_type_code IN VARCHAR2,
13: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
14: return boolean;
15:
16: FUNCTION UNDO_RETIREMENT_REINSTATEMENT(p_transaction_header_id IN NUMBER,
17: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
13: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
14: return boolean;
15:
16: FUNCTION UNDO_RETIREMENT_REINSTATEMENT(p_transaction_header_id IN NUMBER,
17: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
18: p_group_asset_id IN NUMBER,
19: p_set_of_books_id IN NUMBER,
20: p_mrc_sob_type_code IN VARCHAR2,
21: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
17: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
18: p_group_asset_id IN NUMBER,
19: p_set_of_books_id IN NUMBER,
20: p_mrc_sob_type_code IN VARCHAR2,
21: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
22: return boolean;
23:
24: FUNCTION DO_REINSTATEMENT(
25: p_trans_rec IN FA_API_TYPES.trans_rec_type,
21: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
22: return boolean;
23:
24: FUNCTION DO_REINSTATEMENT(
25: p_trans_rec IN FA_API_TYPES.trans_rec_type,
26: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
27: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
28: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
29: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
22: return boolean;
23:
24: FUNCTION DO_REINSTATEMENT(
25: p_trans_rec IN FA_API_TYPES.trans_rec_type,
26: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
27: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
28: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
29: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
30: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
23:
24: FUNCTION DO_REINSTATEMENT(
25: p_trans_rec IN FA_API_TYPES.trans_rec_type,
26: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
27: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
28: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
29: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
30: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
31: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
24: FUNCTION DO_REINSTATEMENT(
25: p_trans_rec IN FA_API_TYPES.trans_rec_type,
26: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
27: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
28: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
29: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
30: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
31: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
32: p_period_rec IN FA_API_TYPES.period_rec_type,
25: p_trans_rec IN FA_API_TYPES.trans_rec_type,
26: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
27: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
28: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
29: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
30: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
31: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
32: p_period_rec IN FA_API_TYPES.period_rec_type,
33: p_mrc_sob_type_code IN VARCHAR2,
26: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
27: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
28: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
29: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
30: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
31: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
32: p_period_rec IN FA_API_TYPES.period_rec_type,
33: p_mrc_sob_type_code IN VARCHAR2,
34: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
27: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
28: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
29: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
30: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
31: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
32: p_period_rec IN FA_API_TYPES.period_rec_type,
33: p_mrc_sob_type_code IN VARCHAR2,
34: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
35: return boolean;
28: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
29: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
30: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
31: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
32: p_period_rec IN FA_API_TYPES.period_rec_type,
33: p_mrc_sob_type_code IN VARCHAR2,
34: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
35: return boolean;
36:
30: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
31: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
32: p_period_rec IN FA_API_TYPES.period_rec_type,
33: p_mrc_sob_type_code IN VARCHAR2,
34: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
35: return boolean;
36:
37: FUNCTION Do_Retirement_in_CGL(
38: p_ret IN fa_ret_types.ret_struct,
37: FUNCTION Do_Retirement_in_CGL(
38: p_ret IN fa_ret_types.ret_struct,
39: p_bk IN fa_ret_types.book_struct,
40: p_dpr IN fa_STD_TYPES.dpr_struct,
41: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
42: p_mrc_sob_type_code IN VARCHAR2,
43: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
44: return boolean;
45:
39: p_bk IN fa_ret_types.book_struct,
40: p_dpr IN fa_STD_TYPES.dpr_struct,
41: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
42: p_mrc_sob_type_code IN VARCHAR2,
43: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
44: return boolean;
45:
46: FUNCTION Do_Reinstatement_in_CGL(
47: p_ret IN fa_ret_types.ret_struct,
47: p_ret IN fa_ret_types.ret_struct,
48: p_bk IN fa_ret_types.book_struct,
49: p_dpr IN fa_STD_TYPES.dpr_struct,
50: p_mrc_sob_type_code IN VARCHAR2,
51: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
52: return boolean;
53:
54: FUNCTION Do_Terminal_Gain_Loss (
55: p_book_type_code VARCHAR2,
55: p_book_type_code VARCHAR2,
56: p_set_of_books_id NUMBER,
57: p_total_requests NUMBER,
58: p_request_number NUMBER,
59: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)return boolean;
60:
61: FUNCTION Check_Terminal_Gain_Loss(
62: p_trans_rec IN FA_API_TYPES.trans_rec_type,
63: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
58: p_request_number NUMBER,
59: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)return boolean;
60:
61: FUNCTION Check_Terminal_Gain_Loss(
62: p_trans_rec IN FA_API_TYPES.trans_rec_type,
63: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
64: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
65: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
66: p_period_rec IN FA_API_TYPES.period_rec_type,
59: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)return boolean;
60:
61: FUNCTION Check_Terminal_Gain_Loss(
62: p_trans_rec IN FA_API_TYPES.trans_rec_type,
63: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
64: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
65: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
66: p_period_rec IN FA_API_TYPES.period_rec_type,
67: p_mrc_sob_type_code IN VARCHAR2,
60:
61: FUNCTION Check_Terminal_Gain_Loss(
62: p_trans_rec IN FA_API_TYPES.trans_rec_type,
63: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
64: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
65: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
66: p_period_rec IN FA_API_TYPES.period_rec_type,
67: p_mrc_sob_type_code IN VARCHAR2,
68: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
61: FUNCTION Check_Terminal_Gain_Loss(
62: p_trans_rec IN FA_API_TYPES.trans_rec_type,
63: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
64: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
65: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
66: p_period_rec IN FA_API_TYPES.period_rec_type,
67: p_mrc_sob_type_code IN VARCHAR2,
68: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
69: RETURN BOOLEAN;
62: p_trans_rec IN FA_API_TYPES.trans_rec_type,
63: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
64: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
65: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
66: p_period_rec IN FA_API_TYPES.period_rec_type,
67: p_mrc_sob_type_code IN VARCHAR2,
68: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
69: RETURN BOOLEAN;
70:
64: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
65: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
66: p_period_rec IN FA_API_TYPES.period_rec_type,
67: p_mrc_sob_type_code IN VARCHAR2,
68: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
69: RETURN BOOLEAN;
70:
71: FUNCTION Do_Allocation(
72: p_trans_rec IN FA_API_TYPES.trans_rec_type,
68: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
69: RETURN BOOLEAN;
70:
71: FUNCTION Do_Allocation(
72: p_trans_rec IN FA_API_TYPES.trans_rec_type,
73: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
74: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
75: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
76: p_period_rec IN FA_API_TYPES.period_rec_type,
69: RETURN BOOLEAN;
70:
71: FUNCTION Do_Allocation(
72: p_trans_rec IN FA_API_TYPES.trans_rec_type,
73: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
74: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
75: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
76: p_period_rec IN FA_API_TYPES.period_rec_type,
77: p_reserve_amount IN NUMBER,
70:
71: FUNCTION Do_Allocation(
72: p_trans_rec IN FA_API_TYPES.trans_rec_type,
73: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
74: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
75: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
76: p_period_rec IN FA_API_TYPES.period_rec_type,
77: p_reserve_amount IN NUMBER,
78: p_mem_ret_thid IN NUMBER DEFAULT NULL,
71: FUNCTION Do_Allocation(
72: p_trans_rec IN FA_API_TYPES.trans_rec_type,
73: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
74: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
75: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
76: p_period_rec IN FA_API_TYPES.period_rec_type,
77: p_reserve_amount IN NUMBER,
78: p_mem_ret_thid IN NUMBER DEFAULT NULL,
79: p_mode IN VARCHAR2 DEFAULT 'NORMAL',
72: p_trans_rec IN FA_API_TYPES.trans_rec_type,
73: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
74: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
75: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
76: p_period_rec IN FA_API_TYPES.period_rec_type,
77: p_reserve_amount IN NUMBER,
78: p_mem_ret_thid IN NUMBER DEFAULT NULL,
79: p_mode IN VARCHAR2 DEFAULT 'NORMAL',
80: p_mrc_sob_type_code IN VARCHAR2,
77: p_reserve_amount IN NUMBER,
78: p_mem_ret_thid IN NUMBER DEFAULT NULL,
79: p_mode IN VARCHAR2 DEFAULT 'NORMAL',
80: p_mrc_sob_type_code IN VARCHAR2,
81: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
82: RETURN BOOLEAN;
83:
84: END FA_RETIREMENT_PVT;