1: PACKAGE BODY FA_MASSADD_SPECIAL_PKG as
2: /* $Header: FAMADSB.pls 120.5 2009/03/26 22:02:03 bridgway ship $ */
3:
4: g_log_level_rec fa_api_types.log_level_rec_type;
5:
6: PROCEDURE Do_Validation
7: (p_posting_status IN VARCHAR2,
8: p_mass_add_rec IN FA_MASS_ADDITIONS%ROWTYPE,
11:
12: l_inv number;
13: l_dist number;
14:
15: l_trans_rec FA_API_TYPES.trans_rec_type;
16: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
17: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
18: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
19: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
12: l_inv number;
13: l_dist number;
14:
15: l_trans_rec FA_API_TYPES.trans_rec_type;
16: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
17: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
18: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
19: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
20: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
13: l_dist number;
14:
15: l_trans_rec FA_API_TYPES.trans_rec_type;
16: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
17: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
18: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
19: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
20: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
21: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
14:
15: l_trans_rec FA_API_TYPES.trans_rec_type;
16: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
17: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
18: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
19: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
20: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
21: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
22: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
15: l_trans_rec FA_API_TYPES.trans_rec_type;
16: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
17: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
18: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
19: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
20: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
21: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
22: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
23: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
16: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
17: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
18: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
19: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
20: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
21: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
22: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
23: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
24: l_inv_tbl FA_API_TYPES.inv_tbl_type;
17: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
18: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
19: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
20: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
21: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
22: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
23: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
24: l_inv_tbl FA_API_TYPES.inv_tbl_type;
25:
18: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
19: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
20: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
21: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
22: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
23: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
24: l_inv_tbl FA_API_TYPES.inv_tbl_type;
25:
26: /* Added Following two variables for bug 6597560 */
19: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
20: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
21: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
22: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
23: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
24: l_inv_tbl FA_API_TYPES.inv_tbl_type;
25:
26: /* Added Following two variables for bug 6597560 */
27: l_method_code VARCHAR2(12);
20: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
21: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
22: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
23: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
24: l_inv_tbl FA_API_TYPES.inv_tbl_type;
25:
26: /* Added Following two variables for bug 6597560 */
27: l_method_code VARCHAR2(12);
28: l_life integer;