7:
8: g_release number := fa_cache_pkg.fazarel_release;
9:
10: FUNCTION do_validation
11: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
12: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
13: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type
14: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
15:
8: g_release number := fa_cache_pkg.fazarel_release;
9:
10: FUNCTION do_validation
11: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
12: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
13: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type
14: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
15:
16: FUNCTION do_cap_rev
9:
10: FUNCTION do_validation
11: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
12: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
13: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type
14: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
15:
16: FUNCTION do_cap_rev
17: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
10: FUNCTION do_validation
11: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
12: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
13: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type
14: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
15:
16: FUNCTION do_cap_rev
17: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
18: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
13: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type
14: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
15:
16: FUNCTION do_cap_rev
17: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
18: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
19: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
20: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
21: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
14: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
15:
16: FUNCTION do_cap_rev
17: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
18: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
19: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
20: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
21: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
22: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
15:
16: FUNCTION do_cap_rev
17: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
18: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
19: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
20: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
21: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
22: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
23: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
16: FUNCTION do_cap_rev
17: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
18: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
19: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
20: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
21: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
22: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
23: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
24: p_period_rec IN FA_API_TYPES.period_rec_type,
17: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
18: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
19: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
20: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
21: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
22: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
23: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
24: p_period_rec IN FA_API_TYPES.period_rec_type,
25: p_mrc_sob_type_code IN VARCHAR2
18: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
19: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
20: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
21: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
22: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
23: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
24: p_period_rec IN FA_API_TYPES.period_rec_type,
25: p_mrc_sob_type_code IN VARCHAR2
26: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
19: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
20: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
21: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
22: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
23: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
24: p_period_rec IN FA_API_TYPES.period_rec_type,
25: p_mrc_sob_type_code IN VARCHAR2
26: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
27:
20: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
21: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
22: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
23: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
24: p_period_rec IN FA_API_TYPES.period_rec_type,
25: p_mrc_sob_type_code IN VARCHAR2
26: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
27:
28: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
22: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
23: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
24: p_period_rec IN FA_API_TYPES.period_rec_type,
25: p_mrc_sob_type_code IN VARCHAR2
26: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
27:
28: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
29: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
30: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
24: p_period_rec IN FA_API_TYPES.period_rec_type,
25: p_mrc_sob_type_code IN VARCHAR2
26: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
27:
28: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
29: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
30: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
31: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
32: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
25: p_mrc_sob_type_code IN VARCHAR2
26: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
27:
28: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
29: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
30: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
31: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
32: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
33: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
26: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
27:
28: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
29: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
30: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
31: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
32: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
33: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
34: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
27:
28: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
29: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
30: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
31: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
32: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
33: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
34: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
35: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
28: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
29: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
30: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
31: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
32: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
33: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
34: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
35: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
36:
29: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
30: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
31: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
32: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
33: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
34: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
35: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
36:
37: l_old_transaction_type_code varchar2(30);
30: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
31: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
32: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
33: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
34: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
35: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
36:
37: l_old_transaction_type_code varchar2(30);
38: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
31: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
32: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
33: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
34: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
35: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
36:
37: l_old_transaction_type_code varchar2(30);
38: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
39:
34: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
35: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
36:
37: l_old_transaction_type_code varchar2(30);
38: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
39:
40: l_rowid rowid;
41: l_status boolean;
42: l_ret_status varchar2(1);
57: --Secondary Changes
58: l_secondary_cap_event_id number;
59: l_secondary_cap_thid number;
60: l_secondary_event_status varchar2(1);
61: l_secondary_trans_rec FA_API_TYPES.trans_rec_type;
62: l_secondary_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
63: l_secondary_sob_id number;
64:
65: CURSOR c_mrc_adjustments (p_thid number) IS
58: l_secondary_cap_event_id number;
59: l_secondary_cap_thid number;
60: l_secondary_event_status varchar2(1);
61: l_secondary_trans_rec FA_API_TYPES.trans_rec_type;
62: l_secondary_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
63: l_secondary_sob_id number;
64:
65: CURSOR c_mrc_adjustments (p_thid number) IS
66: SELECT code_combination_id ,
1197:
1198: -------------------------------------------------------------------------
1199:
1200: function do_validation
1201: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
1202: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1203: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type
1204: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is
1205:
1198: -------------------------------------------------------------------------
1199:
1200: function do_validation
1201: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
1202: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1203: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type
1204: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is
1205:
1206: l_count number;
1199:
1200: function do_validation
1201: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
1202: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1203: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type
1204: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is
1205:
1206: l_count number;
1207: l_period_of_addition varchar2(1);
1200: function do_validation
1201: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
1202: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1203: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type
1204: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is
1205:
1206: l_count number;
1207: l_period_of_addition varchar2(1);
1208: l_calling_fn varchar2(30) := 'fa_cip_pvt.do_validation';