1: PACKAGE BODY FA_ADJUSTMENT_PVT as
2: /* $Header: FAVADJB.pls 120.48.12010000.3 2008/08/14 00:55:03 tkawamur ship $ */
3:
4: FUNCTION do_adjustment
5: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
6: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
8: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2: /* $Header: FAVADJB.pls 120.48.12010000.3 2008/08/14 00:55:03 tkawamur ship $ */
3:
4: FUNCTION do_adjustment
5: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
6: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
8: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
10: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3:
4: FUNCTION do_adjustment
5: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
6: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
8: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
10: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
11: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4: FUNCTION do_adjustment
5: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
6: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
8: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
10: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
11: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
12: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
5: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
6: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
8: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
10: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
11: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
12: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
13: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
6: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
8: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
10: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
11: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
12: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
13: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
14: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
7: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
8: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
10: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
11: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
12: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
13: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
14: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
15: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
8: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
10: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
11: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
12: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
13: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
14: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
15: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
16: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
10: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
11: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
12: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
13: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
14: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
15: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
16: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
17: p_period_rec IN FA_API_TYPES.period_rec_type,
10: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
11: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
12: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
13: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
14: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
15: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
16: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
17: p_period_rec IN FA_API_TYPES.period_rec_type,
18: p_reclassed_asset_id IN NUMBER default null,
11: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
12: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
13: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
14: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
15: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
16: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
17: p_period_rec IN FA_API_TYPES.period_rec_type,
18: p_reclassed_asset_id IN NUMBER default null,
19: p_reclass_src_dest IN VARCHAR2 default null,
12: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
13: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
14: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
15: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
16: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
17: p_period_rec IN FA_API_TYPES.period_rec_type,
18: p_reclassed_asset_id IN NUMBER default null,
19: p_reclass_src_dest IN VARCHAR2 default null,
20: p_reclassed_asset_dpis IN DATE default null,
13: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
14: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
15: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
16: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
17: p_period_rec IN FA_API_TYPES.period_rec_type,
18: p_reclassed_asset_id IN NUMBER default null,
19: p_reclass_src_dest IN VARCHAR2 default null,
20: p_reclassed_asset_dpis IN DATE default null,
21: p_mrc_sob_type_code IN VARCHAR2,
18: p_reclassed_asset_id IN NUMBER default null,
19: p_reclass_src_dest IN VARCHAR2 default null,
20: p_reclassed_asset_dpis IN DATE default null,
21: p_mrc_sob_type_code IN VARCHAR2,
22: p_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
23: p_calling_fn IN VARCHAR2,
24: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
25:
26: l_th_rowid varchar2(30);
20: p_reclassed_asset_dpis IN DATE default null,
21: p_mrc_sob_type_code IN VARCHAR2,
22: p_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
23: p_calling_fn IN VARCHAR2,
24: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
25:
26: l_th_rowid varchar2(30);
27: l_bks_rowid varchar2(30);
28:
42: l_calling_fn varchar2(35) := 'fa_adjustment_pvt.do_adjustment';
43: deprn_override_flag_default varchar2(1);
44:
45: l_reserve_adjustment_amount number;
46: l_asset_fin_rec_null FA_API_TYPES.asset_fin_rec_type;
47:
48: adj_err EXCEPTION;
49:
50: -- Track Member
53: x_group_deprn_amount number;
54: x_group_bonus_amount number;
55:
56: --Bug3548724
57: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
58:
59: -- SLA
60: l_event_status varchar2(15);
61: l_event_type_code varchar2(30);
902: -- now called from the public api to avoid errors resulting from
903: -- calls from group/reclass apis that may result in no change
904:
905: FUNCTION validate_adjustment
906: (p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
907: p_trans_rec IN FA_API_TYPES.trans_rec_type,
908: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
909: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
910: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
903: -- calls from group/reclass apis that may result in no change
904:
905: FUNCTION validate_adjustment
906: (p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
907: p_trans_rec IN FA_API_TYPES.trans_rec_type,
908: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
909: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
910: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
911: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
904:
905: FUNCTION validate_adjustment
906: (p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
907: p_trans_rec IN FA_API_TYPES.trans_rec_type,
908: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
909: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
910: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
911: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
912: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
905: FUNCTION validate_adjustment
906: (p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
907: p_trans_rec IN FA_API_TYPES.trans_rec_type,
908: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
909: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
910: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
911: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
912: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
913: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
906: (p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
907: p_trans_rec IN FA_API_TYPES.trans_rec_type,
908: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
909: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
910: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
911: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
912: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
913: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
914:
907: p_trans_rec IN FA_API_TYPES.trans_rec_type,
908: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
909: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
910: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
911: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
912: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
913: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
914:
915: l_no_changes_made boolean;
908: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
909: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
910: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
911: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
912: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
913: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
914:
915: l_no_changes_made boolean;
916: l_no_changes_to_uom boolean;
909: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
910: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
911: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
912: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
913: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
914:
915: l_no_changes_made boolean;
916: l_no_changes_to_uom boolean;
917: l_no_changes_to_dep_flag boolean;