4: g_release number := fa_cache_pkg.fazarel_release;
5:
6: function initialize (
7: -- Transaction Object --
8: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
9: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
10: -- Asset Object --
11: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
12: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
5:
6: function initialize (
7: -- Transaction Object --
8: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
9: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
10: -- Asset Object --
11: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
12: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
13: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
7: -- Transaction Object --
8: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
9: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
10: -- Asset Object --
11: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
12: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
13: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
14: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
15: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
8: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
9: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
10: -- Asset Object --
11: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
12: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
13: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
14: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
15: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
16: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
9: px_dist_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
10: -- Asset Object --
11: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
12: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
13: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
14: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
15: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
16: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
17: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
10: -- Asset Object --
11: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
12: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
13: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
14: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
15: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
16: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
17: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
18: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
11: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
12: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
13: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
14: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
15: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
16: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
17: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
18: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
19: -- Invoice Object --
12: px_asset_desc_rec IN OUT NOCOPY fa_api_types.asset_desc_rec_type,
13: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
14: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
15: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
16: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
17: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
18: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
19: -- Invoice Object --
20: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type,
13: px_asset_type_rec IN OUT NOCOPY fa_api_types.asset_type_rec_type,
14: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
15: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
16: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
17: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
18: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
19: -- Invoice Object --
20: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type,
21: x_return_status OUT NOCOPY VARCHAR2,
14: px_asset_cat_rec IN OUT NOCOPY fa_api_types.asset_cat_rec_type,
15: px_asset_hierarchy_rec IN OUT NOCOPY fa_api_types.asset_hierarchy_rec_type,
16: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
17: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
18: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
19: -- Invoice Object --
20: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type,
21: x_return_status OUT NOCOPY VARCHAR2,
22: p_calling_fn IN VARCHAR2
16: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
17: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
18: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
19: -- Invoice Object --
20: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type,
21: x_return_status OUT NOCOPY VARCHAR2,
22: p_calling_fn IN VARCHAR2
23: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean as
24:
19: -- Invoice Object --
20: px_inv_tbl IN OUT NOCOPY fa_api_types.inv_tbl_type,
21: x_return_status OUT NOCOPY VARCHAR2,
22: p_calling_fn IN VARCHAR2
23: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean as
24:
25: l_return_status boolean;
26: l_distribution_count number;
27:
24:
25: l_return_status boolean;
26: l_distribution_count number;
27:
28: l_period_rec fa_api_types.period_rec_type;
29:
30: -- Category information
31: l_category_chart_id number;
32: l_num_segs number;
1037:
1038: end initialize;
1039:
1040: function insert_asset (
1041: p_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1042: p_dist_trans_rec IN fa_api_types.trans_rec_type,
1043: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1044: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
1045: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
1038: end initialize;
1039:
1040: function insert_asset (
1041: p_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1042: p_dist_trans_rec IN fa_api_types.trans_rec_type,
1043: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1044: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
1045: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
1046: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
1039:
1040: function insert_asset (
1041: p_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1042: p_dist_trans_rec IN fa_api_types.trans_rec_type,
1043: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1044: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
1045: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
1046: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
1047: p_asset_hierarchy_rec IN fa_api_types.asset_hierarchy_rec_type,
1040: function insert_asset (
1041: p_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1042: p_dist_trans_rec IN fa_api_types.trans_rec_type,
1043: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1044: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
1045: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
1046: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
1047: p_asset_hierarchy_rec IN fa_api_types.asset_hierarchy_rec_type,
1048: p_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
1041: p_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
1042: p_dist_trans_rec IN fa_api_types.trans_rec_type,
1043: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1044: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
1045: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
1046: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
1047: p_asset_hierarchy_rec IN fa_api_types.asset_hierarchy_rec_type,
1048: p_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
1049: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
1042: p_dist_trans_rec IN fa_api_types.trans_rec_type,
1043: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1044: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
1045: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
1046: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
1047: p_asset_hierarchy_rec IN fa_api_types.asset_hierarchy_rec_type,
1048: p_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
1049: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
1050: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
1043: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
1044: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
1045: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
1046: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
1047: p_asset_hierarchy_rec IN fa_api_types.asset_hierarchy_rec_type,
1048: p_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
1049: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
1050: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
1051: p_inv_trans_rec IN fa_api_types.inv_trans_rec_type,
1044: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
1045: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
1046: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
1047: p_asset_hierarchy_rec IN fa_api_types.asset_hierarchy_rec_type,
1048: p_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
1049: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
1050: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
1051: p_inv_trans_rec IN fa_api_types.inv_trans_rec_type,
1052: p_primary_cost IN NUMBER,
1045: p_asset_type_rec IN fa_api_types.asset_type_rec_type,
1046: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
1047: p_asset_hierarchy_rec IN fa_api_types.asset_hierarchy_rec_type,
1048: p_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
1049: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
1050: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
1051: p_inv_trans_rec IN fa_api_types.inv_trans_rec_type,
1052: p_primary_cost IN NUMBER,
1053: p_exchange_rate IN NUMBER,
1046: p_asset_cat_rec IN fa_api_types.asset_cat_rec_type,
1047: p_asset_hierarchy_rec IN fa_api_types.asset_hierarchy_rec_type,
1048: p_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
1049: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
1050: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
1051: p_inv_trans_rec IN fa_api_types.inv_trans_rec_type,
1052: p_primary_cost IN NUMBER,
1053: p_exchange_rate IN NUMBER,
1054: x_return_status OUT NOCOPY VARCHAR2,
1047: p_asset_hierarchy_rec IN fa_api_types.asset_hierarchy_rec_type,
1048: p_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
1049: p_asset_deprn_rec IN fa_api_types.asset_deprn_rec_type,
1050: px_asset_dist_tbl IN OUT NOCOPY fa_api_types.asset_dist_tbl_type,
1051: p_inv_trans_rec IN fa_api_types.inv_trans_rec_type,
1052: p_primary_cost IN NUMBER,
1053: p_exchange_rate IN NUMBER,
1054: x_return_status OUT NOCOPY VARCHAR2,
1055: p_mrc_sob_type_code IN VARCHAR2,
1052: p_primary_cost IN NUMBER,
1053: p_exchange_rate IN NUMBER,
1054: x_return_status OUT NOCOPY VARCHAR2,
1055: p_mrc_sob_type_code IN VARCHAR2,
1056: p_period_rec IN fa_api_types.period_rec_type,
1057: p_calling_fn IN VARCHAR2
1058: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean as
1059:
1060: l_rowid ROWID;
1054: x_return_status OUT NOCOPY VARCHAR2,
1055: p_mrc_sob_type_code IN VARCHAR2,
1056: p_period_rec IN fa_api_types.period_rec_type,
1057: p_calling_fn IN VARCHAR2
1058: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean as
1059:
1060: l_rowid ROWID;
1061: l_asset_id NUMBER(15);
1062: l_asset_number VARCHAR2(15);
1093: l_formula_factor NUMBER := p_asset_fin_rec.formula_factor;
1094:
1095: deprn_override_flag_default varchar2(1);
1096:
1097: l_period_rec fa_api_types.period_rec_type;
1098: l_capitalized_flag VARCHAR2(1);
1099: l_fully_reserved_flag VARCHAR2(1);
1100: l_fully_retired_flag VARCHAR2(1);
1101: l_life_complete_flag VARCHAR2(1);
1102:
1103: mrc_check_error EXCEPTION;
1104: general_error EXCEPTION;
1105:
1106: l_asset_fin_rec_null FA_API_TYPES.asset_fin_rec_type;
1107:
1108: --bug3548724
1109: l_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1110:
1105:
1106: l_asset_fin_rec_null FA_API_TYPES.asset_fin_rec_type;
1107:
1108: --bug3548724
1109: l_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1110:
1111:
1112: -- Bug:5930979:Japan Tax Reform Project
1113: l_method_type NUMBER := 0;
1131: l_source_line_id_tbl num_tbl;
1132: l_asset_invoice_id_tbl num_tbl;
1133:
1134: --Secondary Changes
1135: l_secondary_trans_rec FA_API_TYPES.trans_rec_type;
1136: l_secondary_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1137: l_secondary_sob_id number;
1138:
1139: cursor c_invoices
1132: l_asset_invoice_id_tbl num_tbl;
1133:
1134: --Secondary Changes
1135: l_secondary_trans_rec FA_API_TYPES.trans_rec_type;
1136: l_secondary_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1137: l_secondary_sob_id number;
1138:
1139: cursor c_invoices
1140: (p_asset_id number,
2530: end insert_asset;
2531: -- Bug 13022905
2532: function initialize_jp (
2533: -- Transaction Object --
2534: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
2535: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
2536: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
2537: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
2538: p_calling_fn IN VARCHAR2
2531: -- Bug 13022905
2532: function initialize_jp (
2533: -- Transaction Object --
2534: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
2535: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
2536: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
2537: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
2538: p_calling_fn IN VARCHAR2
2539: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean as
2532: function initialize_jp (
2533: -- Transaction Object --
2534: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
2535: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
2536: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
2537: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
2538: p_calling_fn IN VARCHAR2
2539: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean as
2540:
2533: -- Transaction Object --
2534: px_trans_rec IN OUT NOCOPY fa_api_types.trans_rec_type,
2535: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
2536: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
2537: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
2538: p_calling_fn IN VARCHAR2
2539: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean as
2540:
2541: -- Bug# 7698326 start
2535: px_asset_hdr_rec IN OUT NOCOPY fa_api_types.asset_hdr_rec_type,
2536: px_asset_fin_rec IN OUT NOCOPY fa_api_types.asset_fin_rec_type,
2537: px_asset_deprn_rec IN OUT NOCOPY fa_api_types.asset_deprn_rec_type,
2538: p_calling_fn IN VARCHAR2
2539: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean as
2540:
2541: -- Bug# 7698326 start
2542: l_fiscal_year number;
2543: l_number_per_fiscal_year number;