3:
4: g_release number := fa_cache_pkg.fazarel_release;
5:
6: FUNCTION do_adjustment
7: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
8: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
9: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
10: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
11: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
4: g_release number := fa_cache_pkg.fazarel_release;
5:
6: FUNCTION do_adjustment
7: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
8: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
9: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
10: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
11: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
12: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5:
6: FUNCTION do_adjustment
7: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
8: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
9: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
10: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
11: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
12: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
13: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
6: FUNCTION do_adjustment
7: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
8: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
9: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
10: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
11: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
12: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
13: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
14: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
8: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
9: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
10: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
11: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
12: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
13: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
14: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
8: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
9: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
10: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
11: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
12: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
13: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
14: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
16: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
9: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
10: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
11: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
12: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
13: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
14: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
16: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
17: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
10: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
11: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
12: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
13: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
14: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
16: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
17: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
18: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
11: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
12: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
13: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
14: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
16: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
17: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
18: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
19: p_period_rec IN FA_API_TYPES.period_rec_type,
12: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
13: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
14: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
16: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
17: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
18: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
19: p_period_rec IN FA_API_TYPES.period_rec_type,
20: p_reclassed_asset_id IN NUMBER default null,
13: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
14: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
16: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
17: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
18: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
19: p_period_rec IN FA_API_TYPES.period_rec_type,
20: p_reclassed_asset_id IN NUMBER default null,
21: p_reclass_src_dest IN VARCHAR2 default null,
14: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
15: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
16: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
17: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
18: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
19: p_period_rec IN FA_API_TYPES.period_rec_type,
20: p_reclassed_asset_id IN NUMBER default null,
21: p_reclass_src_dest IN VARCHAR2 default null,
22: p_reclassed_asset_dpis IN DATE default null,
15: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
16: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
17: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
18: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
19: p_period_rec IN FA_API_TYPES.period_rec_type,
20: p_reclassed_asset_id IN NUMBER default null,
21: p_reclass_src_dest IN VARCHAR2 default null,
22: p_reclassed_asset_dpis IN DATE default null,
23: p_mrc_sob_type_code IN VARCHAR2,
20: p_reclassed_asset_id IN NUMBER default null,
21: p_reclass_src_dest IN VARCHAR2 default null,
22: p_reclassed_asset_dpis IN DATE default null,
23: p_mrc_sob_type_code IN VARCHAR2,
24: p_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
25: p_calling_fn IN VARCHAR2
26: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
27:
28: l_th_rowid varchar2(30);
22: p_reclassed_asset_dpis IN DATE default null,
23: p_mrc_sob_type_code IN VARCHAR2,
24: p_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
25: p_calling_fn IN VARCHAR2
26: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
27:
28: l_th_rowid varchar2(30);
29: l_bks_rowid varchar2(30);
30:
55: l_calling_fn varchar2(35) := 'fa_adjustment_pvt.do_adjustment';
56: deprn_override_flag_default varchar2(1);
57:
58: l_reserve_adjustment_amount number;
59: l_asset_fin_rec_null FA_API_TYPES.asset_fin_rec_type;
60:
61: adj_err EXCEPTION;
62:
63: -- Track Member
66: x_group_deprn_amount number;
67: x_group_bonus_amount number;
68:
69: --Bug3548724
70: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
71:
72: -- SLA
73: l_event_status varchar2(15);
74: l_event_type_code varchar2(30);
85: l_Guaranteed_Rate NUMBER;
86: l_is_revised_rate NUMBER;
87: l_comp_val NUMBER; --bug 8639894
88: --Secondary changes
89: l_secondary_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
90: l_secondary_trans_rec fa_api_types.trans_rec_type;
91: l_secondary_sob_id NUMBER;
92: BEGIN
93:
86: l_is_revised_rate NUMBER;
87: l_comp_val NUMBER; --bug 8639894
88: --Secondary changes
89: l_secondary_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
90: l_secondary_trans_rec fa_api_types.trans_rec_type;
91: l_secondary_sob_id NUMBER;
92: BEGIN
93:
94: --set up transaction types for adjustments vs. addition voids
1052: -- now called from the public api to avoid errors resulting from
1053: -- calls from group/reclass apis that may result in no change
1054:
1055: FUNCTION validate_adjustment
1056: (p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1057: p_trans_rec IN FA_API_TYPES.trans_rec_type,
1058: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1059: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1060: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1053: -- calls from group/reclass apis that may result in no change
1054:
1055: FUNCTION validate_adjustment
1056: (p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1057: p_trans_rec IN FA_API_TYPES.trans_rec_type,
1058: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1059: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1060: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1061: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1054:
1055: FUNCTION validate_adjustment
1056: (p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1057: p_trans_rec IN FA_API_TYPES.trans_rec_type,
1058: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1059: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1060: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1061: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1062: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
1055: FUNCTION validate_adjustment
1056: (p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1057: p_trans_rec IN FA_API_TYPES.trans_rec_type,
1058: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1059: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1060: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1061: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1062: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
1063: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1056: (p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
1057: p_trans_rec IN FA_API_TYPES.trans_rec_type,
1058: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1059: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1060: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1061: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1062: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
1063: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1064: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1057: p_trans_rec IN FA_API_TYPES.trans_rec_type,
1058: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1059: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1060: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1061: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1062: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
1063: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1064: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1065:
1058: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1059: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1060: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1061: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1062: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
1063: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1064: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1065:
1066: h_asset_id number;
1059: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1060: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1061: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1062: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
1063: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1064: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1065:
1066: h_asset_id number;
1067:
1060: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1061: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1062: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
1063: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1064: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1065:
1066: h_asset_id number;
1067:
1068: CURSOR c_group_mem_no_depreciate is
1466: x_return_status OUT NOCOPY VARCHAR2,
1467: x_msg_count OUT NOCOPY NUMBER,
1468: x_msg_data OUT NOCOPY VARCHAR2,
1469: p_calling_fn IN VARCHAR2,
1470: p_log_level_rec IN FA_API_TYPES.log_level_rec_type,
1471: -- Transaction Object --
1472: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1473: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1474: -- Asset Object --
1468: x_msg_data OUT NOCOPY VARCHAR2,
1469: p_calling_fn IN VARCHAR2,
1470: p_log_level_rec IN FA_API_TYPES.log_level_rec_type,
1471: -- Transaction Object --
1472: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1473: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1474: -- Asset Object --
1475: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
1476: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
1469: p_calling_fn IN VARCHAR2,
1470: p_log_level_rec IN FA_API_TYPES.log_level_rec_type,
1471: -- Transaction Object --
1472: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1473: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1474: -- Asset Object --
1475: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
1476: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
1477: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
1471: -- Transaction Object --
1472: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1473: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1474: -- Asset Object --
1475: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
1476: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
1477: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
1478: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
1479: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
1472: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1473: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1474: -- Asset Object --
1475: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
1476: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
1477: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
1478: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
1479: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
1480: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
1473: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1474: -- Asset Object --
1475: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
1476: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
1477: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
1478: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
1479: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
1480: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
1481: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
1474: -- Asset Object --
1475: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
1476: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
1477: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
1478: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
1479: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
1480: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
1481: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
1482: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
1475: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
1476: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
1477: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
1478: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
1479: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
1480: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
1481: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
1482: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
1483: -- Invoice Object --
1476: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
1477: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
1478: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
1479: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
1480: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
1481: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
1482: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
1483: -- Invoice Object --
1484: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type,
1477: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
1478: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
1479: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
1480: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
1481: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
1482: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
1483: -- Invoice Object --
1484: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type,
1485: ---- adjustment related parameters -------------
1478: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
1479: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
1480: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
1481: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
1482: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
1483: -- Invoice Object --
1484: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type,
1485: ---- adjustment related parameters -------------
1486: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1480: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
1481: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
1482: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
1483: -- Invoice Object --
1484: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type,
1485: ---- adjustment related parameters -------------
1486: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1487: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1488: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
1482: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
1483: -- Invoice Object --
1484: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type,
1485: ---- adjustment related parameters -------------
1486: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1487: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1488: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
1489: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
1490: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
1483: -- Invoice Object --
1484: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type,
1485: ---- adjustment related parameters -------------
1486: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1487: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1488: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
1489: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
1490: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
1491: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
1484: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type,
1485: ---- adjustment related parameters -------------
1486: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1487: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1488: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
1489: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
1490: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
1491: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
1492: x_asset_deprn_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_deprn_tbl_type,
1485: ---- adjustment related parameters -------------
1486: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1487: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1488: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
1489: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
1490: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
1491: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
1492: x_asset_deprn_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_deprn_tbl_type,
1493: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type
1486: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1487: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1488: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
1489: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
1490: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
1491: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
1492: x_asset_deprn_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_deprn_tbl_type,
1493: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type
1494:
1487: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1488: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
1489: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
1490: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
1491: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
1492: x_asset_deprn_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_deprn_tbl_type,
1493: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type
1494:
1495: ) return boolean is
1488: x_asset_fin_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_fin_tbl_type,
1489: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
1490: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
1491: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
1492: x_asset_deprn_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_deprn_tbl_type,
1493: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type
1494:
1495: ) return boolean is
1496: l_original_trx_type varchar2(3) := p_orig_trx_type;
1489: px_inv_trans_rec IN OUT NOCOPY FA_API_TYPES.inv_trans_rec_type,
1490: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
1491: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
1492: x_asset_deprn_mrc_tbl_new OUT NOCOPY FA_API_TYPES.asset_deprn_tbl_type,
1493: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type
1494:
1495: ) return boolean is
1496: l_original_trx_type varchar2(3) := p_orig_trx_type;
1497: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1493: p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type
1494:
1495: ) return boolean is
1496: l_original_trx_type varchar2(3) := p_orig_trx_type;
1497: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1498: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
1499: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
1500: l_asset_fin_rec_in FA_API_TYPES.asset_fin_rec_type;
1501: l_trans_rec_in fa_api_types.trans_rec_type;
1494:
1495: ) return boolean is
1496: l_original_trx_type varchar2(3) := p_orig_trx_type;
1497: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1498: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
1499: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
1500: l_asset_fin_rec_in FA_API_TYPES.asset_fin_rec_type;
1501: l_trans_rec_in fa_api_types.trans_rec_type;
1502: l_group_asset_id number;
1495: ) return boolean is
1496: l_original_trx_type varchar2(3) := p_orig_trx_type;
1497: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1498: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
1499: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
1500: l_asset_fin_rec_in FA_API_TYPES.asset_fin_rec_type;
1501: l_trans_rec_in fa_api_types.trans_rec_type;
1502: l_group_asset_id number;
1503: l_reduction_rate number;
1496: l_original_trx_type varchar2(3) := p_orig_trx_type;
1497: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1498: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
1499: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
1500: l_asset_fin_rec_in FA_API_TYPES.asset_fin_rec_type;
1501: l_trans_rec_in fa_api_types.trans_rec_type;
1502: l_group_asset_id number;
1503: l_reduction_rate number;
1504: l_asset_id number;
1497: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1498: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
1499: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
1500: l_asset_fin_rec_in FA_API_TYPES.asset_fin_rec_type;
1501: l_trans_rec_in fa_api_types.trans_rec_type;
1502: l_group_asset_id number;
1503: l_reduction_rate number;
1504: l_asset_id number;
1505: l_adjusted_cost number;
1648: end if;
1649: for ind in 1..l_adj_count
1650: loop
1651: declare
1652: l_trans_rec FA_API_TYPES.trans_rec_type;
1653: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1654: l_asset_fin_rec_adj_1 FA_API_TYPES.asset_fin_rec_type;
1655: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1656: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1649: for ind in 1..l_adj_count
1650: loop
1651: declare
1652: l_trans_rec FA_API_TYPES.trans_rec_type;
1653: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1654: l_asset_fin_rec_adj_1 FA_API_TYPES.asset_fin_rec_type;
1655: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1656: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1657: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1650: loop
1651: declare
1652: l_trans_rec FA_API_TYPES.trans_rec_type;
1653: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1654: l_asset_fin_rec_adj_1 FA_API_TYPES.asset_fin_rec_type;
1655: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1656: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1657: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1658: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1651: declare
1652: l_trans_rec FA_API_TYPES.trans_rec_type;
1653: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1654: l_asset_fin_rec_adj_1 FA_API_TYPES.asset_fin_rec_type;
1655: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1656: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1657: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1658: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1659: l_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
1652: l_trans_rec FA_API_TYPES.trans_rec_type;
1653: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1654: l_asset_fin_rec_adj_1 FA_API_TYPES.asset_fin_rec_type;
1655: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1656: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1657: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1658: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1659: l_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
1660: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1653: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1654: l_asset_fin_rec_adj_1 FA_API_TYPES.asset_fin_rec_type;
1655: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1656: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1657: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1658: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1659: l_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
1660: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1661: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1654: l_asset_fin_rec_adj_1 FA_API_TYPES.asset_fin_rec_type;
1655: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1656: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1657: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1658: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1659: l_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
1660: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1661: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1662: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1655: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1656: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1657: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1658: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1659: l_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
1660: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1661: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1662: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1663: l_inv_rec FA_API_TYPES.inv_rec_type;
1656: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1657: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1658: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1659: l_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
1660: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1661: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1662: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1663: l_inv_rec FA_API_TYPES.inv_rec_type;
1664: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1657: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1658: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1659: l_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
1660: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1661: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1662: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1663: l_inv_rec FA_API_TYPES.inv_rec_type;
1664: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1665: l_cal_close_date date;
1658: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1659: l_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
1660: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1661: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1662: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1663: l_inv_rec FA_API_TYPES.inv_rec_type;
1664: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1665: l_cal_close_date date;
1666: begin
1659: l_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
1660: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1661: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1662: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1663: l_inv_rec FA_API_TYPES.inv_rec_type;
1664: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1665: l_cal_close_date date;
1666: begin
1667: if (p_log_level_rec.statement_level) then
1660: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1661: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1662: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1663: l_inv_rec FA_API_TYPES.inv_rec_type;
1664: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1665: l_cal_close_date date;
1666: begin
1667: if (p_log_level_rec.statement_level) then
1668: fa_debug_pkg.add(l_calling_fn, 'inside loop start ind', ind,