2: /* $Header: FAVADDB.pls 120.42.12010000.6 2009/01/23 21:57:03 bridgway ship $ */
3:
4: function initialize (
5: -- Transaction Object --
6: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
7: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
8: -- Asset Object --
9: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
10: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
3:
4: function initialize (
5: -- Transaction Object --
6: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
7: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
8: -- Asset Object --
9: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
10: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
11: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
5: -- Transaction Object --
6: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
7: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
8: -- Asset Object --
9: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
10: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
11: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
12: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
13: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
6: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
7: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
8: -- Asset Object --
9: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
10: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
11: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
12: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
13: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
14: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
7: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
8: -- Asset Object --
9: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
10: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
11: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
12: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
13: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
14: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
15: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
8: -- Asset Object --
9: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
10: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
11: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
12: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
13: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
14: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
15: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
16: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
9: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
10: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
11: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
12: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
13: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
14: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
15: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
16: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
17: -- Invoice Object --
10: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
11: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
12: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
13: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
14: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
15: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
16: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
17: -- Invoice Object --
18: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type,
11: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
12: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
13: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
14: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
15: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
16: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
17: -- Invoice Object --
18: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type,
19: x_return_status OUT NOCOPY VARCHAR2,
12: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
13: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
14: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
15: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
16: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
17: -- Invoice Object --
18: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type,
19: x_return_status OUT NOCOPY VARCHAR2,
20: p_calling_fn IN VARCHAR2,
14: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
15: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
16: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
17: -- Invoice Object --
18: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type,
19: x_return_status OUT NOCOPY VARCHAR2,
20: p_calling_fn IN VARCHAR2,
21: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean as
22:
17: -- Invoice Object --
18: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type,
19: x_return_status OUT NOCOPY VARCHAR2,
20: p_calling_fn IN VARCHAR2,
21: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean as
22:
23: l_return_status boolean;
24: l_distribution_count number;
25:
22:
23: l_return_status boolean;
24: l_distribution_count number;
25:
26: l_period_rec fa_api_types.period_rec_type;
27:
28: -- Category information
29: l_category_chart_id number;
30: l_num_segs number;
1018:
1019: end initialize;
1020:
1021: function insert_asset (
1022: p_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1023: p_dist_trans_rec IN fa_api_types.trans_rec_type,
1024: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1025: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
1026: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
1019: end initialize;
1020:
1021: function insert_asset (
1022: p_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1023: p_dist_trans_rec IN fa_api_types.trans_rec_type,
1024: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1025: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
1026: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
1027: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
1020:
1021: function insert_asset (
1022: p_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1023: p_dist_trans_rec IN fa_api_types.trans_rec_type,
1024: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1025: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
1026: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
1027: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
1028: p_asset_hierarchy_rec IN fa_api_types.asset_hierarchy_rec_type,
1021: function insert_asset (
1022: p_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1023: p_dist_trans_rec IN fa_api_types.trans_rec_type,
1024: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1025: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
1026: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
1027: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
1028: p_asset_hierarchy_rec IN fa_api_types.asset_hierarchy_rec_type,
1029: p_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
1022: p_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1023: p_dist_trans_rec IN fa_api_types.trans_rec_type,
1024: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1025: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
1026: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
1027: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
1028: p_asset_hierarchy_rec IN fa_api_types.asset_hierarchy_rec_type,
1029: p_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
1030: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
1023: p_dist_trans_rec IN fa_api_types.trans_rec_type,
1024: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1025: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
1026: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
1027: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
1028: p_asset_hierarchy_rec IN fa_api_types.asset_hierarchy_rec_type,
1029: p_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
1030: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
1031: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
1024: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1025: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
1026: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
1027: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
1028: p_asset_hierarchy_rec IN fa_api_types.asset_hierarchy_rec_type,
1029: p_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
1030: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
1031: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
1032: p_inv_trans_rec IN fa_api_types.inv_trans_rec_type,
1025: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
1026: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
1027: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
1028: p_asset_hierarchy_rec IN fa_api_types.asset_hierarchy_rec_type,
1029: p_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
1030: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
1031: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
1032: p_inv_trans_rec IN fa_api_types.inv_trans_rec_type,
1033: p_primary_cost IN NUMBER,
1026: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
1027: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
1028: p_asset_hierarchy_rec IN fa_api_types.asset_hierarchy_rec_type,
1029: p_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
1030: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
1031: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
1032: p_inv_trans_rec IN fa_api_types.inv_trans_rec_type,
1033: p_primary_cost IN NUMBER,
1034: p_exchange_rate IN NUMBER,
1027: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
1028: p_asset_hierarchy_rec IN fa_api_types.asset_hierarchy_rec_type,
1029: p_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
1030: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
1031: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
1032: p_inv_trans_rec IN fa_api_types.inv_trans_rec_type,
1033: p_primary_cost IN NUMBER,
1034: p_exchange_rate IN NUMBER,
1035: x_return_status OUT NOCOPY VARCHAR2,
1028: p_asset_hierarchy_rec IN fa_api_types.asset_hierarchy_rec_type,
1029: p_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
1030: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
1031: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
1032: p_inv_trans_rec IN fa_api_types.inv_trans_rec_type,
1033: p_primary_cost IN NUMBER,
1034: p_exchange_rate IN NUMBER,
1035: x_return_status OUT NOCOPY VARCHAR2,
1036: p_mrc_sob_type_code IN VARCHAR2,
1033: p_primary_cost IN NUMBER,
1034: p_exchange_rate IN NUMBER,
1035: x_return_status OUT NOCOPY VARCHAR2,
1036: p_mrc_sob_type_code IN VARCHAR2,
1037: p_period_rec IN fa_api_types.period_rec_type,
1038: p_calling_fn IN VARCHAR2,
1039: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean as
1040:
1041: l_rowid ROWID;
1035: x_return_status OUT NOCOPY VARCHAR2,
1036: p_mrc_sob_type_code IN VARCHAR2,
1037: p_period_rec IN fa_api_types.period_rec_type,
1038: p_calling_fn IN VARCHAR2,
1039: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean as
1040:
1041: l_rowid ROWID;
1042: l_asset_id NUMBER(15);
1043: l_asset_number VARCHAR2(15);
1073: l_formula_factor NUMBER := p_asset_fin_rec.formula_factor;
1074:
1075: deprn_override_flag_default varchar2(1);
1076:
1077: l_period_rec fa_api_types.period_rec_type;
1078: l_capitalized_flag VARCHAR2(1);
1079: l_fully_reserved_flag VARCHAR2(1);
1080: l_fully_retired_flag VARCHAR2(1);
1081: l_life_complete_flag VARCHAR2(1);
1082:
1083: mrc_check_error EXCEPTION;
1084: general_error EXCEPTION;
1085:
1086: l_asset_fin_rec_null FA_API_TYPES.asset_fin_rec_type;
1087:
1088: --bug3548724
1089: l_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1090:
1085:
1086: l_asset_fin_rec_null FA_API_TYPES.asset_fin_rec_type;
1087:
1088: --bug3548724
1089: l_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1090:
1091: -- sla
1092: l_adj fa_adjust_type_pkg.fa_adj_row_struct;
1093: