9: G_times_called number := 0;
10:
11: g_release number := fa_cache_pkg.fazarel_release;
12:
13: g_log_level_rec fa_api_types.log_level_rec_type;
14:
15: TYPE num_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
16: TYPE date_tbl IS TABLE OF DATE INDEX BY BINARY_INTEGER;
17: TYPE v30_tbl IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
710: l_token varchar2(40);
711: l_value varchar2(40);
712: l_calling_fn VARCHAR2(30) := 'fa_masscp_pkg.mcp_addition';
713:
714: l_trans_rec FA_API_TYPES.trans_rec_type;
715: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
716: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
717: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
718: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
711: l_value varchar2(40);
712: l_calling_fn VARCHAR2(30) := 'fa_masscp_pkg.mcp_addition';
713:
714: l_trans_rec FA_API_TYPES.trans_rec_type;
715: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
716: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
717: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
718: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
719: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
712: l_calling_fn VARCHAR2(30) := 'fa_masscp_pkg.mcp_addition';
713:
714: l_trans_rec FA_API_TYPES.trans_rec_type;
715: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
716: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
717: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
718: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
719: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
720: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
713:
714: l_trans_rec FA_API_TYPES.trans_rec_type;
715: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
716: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
717: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
718: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
719: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
720: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
721: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
714: l_trans_rec FA_API_TYPES.trans_rec_type;
715: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
716: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
717: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
718: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
719: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
720: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
721: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
722: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
715: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
716: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
717: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
718: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
719: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
720: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
721: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
722: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
723: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
716: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
717: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
718: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
719: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
720: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
721: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
722: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
723: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
724: l_inv_tbl FA_API_TYPES.inv_tbl_type;
717: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
718: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
719: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
720: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
721: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
722: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
723: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
724: l_inv_tbl FA_API_TYPES.inv_tbl_type;
725: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
718: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
719: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
720: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
721: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
722: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
723: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
724: l_inv_tbl FA_API_TYPES.inv_tbl_type;
725: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
726:
719: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
720: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
721: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
722: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
723: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
724: l_inv_tbl FA_API_TYPES.inv_tbl_type;
725: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
726:
727: l_corp_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
720: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
721: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
722: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
723: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
724: l_inv_tbl FA_API_TYPES.inv_tbl_type;
725: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
726:
727: l_corp_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
728: l_corp_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
721: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
722: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
723: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
724: l_inv_tbl FA_API_TYPES.inv_tbl_type;
725: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
726:
727: l_corp_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
728: l_corp_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
729:
723: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
724: l_inv_tbl FA_API_TYPES.inv_tbl_type;
725: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
726:
727: l_corp_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
728: l_corp_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
729:
730: val_err1 EXCEPTION; -- invalid, non fatal
731: add_err1 EXCEPTION; -- warning
724: l_inv_tbl FA_API_TYPES.inv_tbl_type;
725: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
726:
727: l_corp_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
728: l_corp_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
729:
730: val_err1 EXCEPTION; -- invalid, non fatal
731: add_err1 EXCEPTION; -- warning
732: add_err2 EXCEPTION; -- fatal
1160: l_token varchar2(40);
1161: l_value varchar2(40);
1162: l_calling_fn VARCHAR2(30) := 'fa_masscp_pkg.mcp_adjustment';
1163:
1164: l_trans_rec FA_API_TYPES.trans_rec_type;
1165: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1166: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1167: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1168: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1161: l_value varchar2(40);
1162: l_calling_fn VARCHAR2(30) := 'fa_masscp_pkg.mcp_adjustment';
1163:
1164: l_trans_rec FA_API_TYPES.trans_rec_type;
1165: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1166: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1167: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1168: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1169: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1162: l_calling_fn VARCHAR2(30) := 'fa_masscp_pkg.mcp_adjustment';
1163:
1164: l_trans_rec FA_API_TYPES.trans_rec_type;
1165: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1166: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1167: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1168: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1169: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1170: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1163:
1164: l_trans_rec FA_API_TYPES.trans_rec_type;
1165: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1166: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1167: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1168: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1169: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1170: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1171: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1164: l_trans_rec FA_API_TYPES.trans_rec_type;
1165: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1166: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1167: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1168: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1169: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1170: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1171: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1172: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1165: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1166: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1167: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1168: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1169: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1170: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1171: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1172: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1173: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1166: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
1167: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1168: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1169: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1170: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1171: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1172: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1173: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1174: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1167: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
1168: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1169: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1170: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1171: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1172: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1173: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1174: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1175: l_group_change boolean;
1168: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
1169: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1170: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1171: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1172: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1173: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1174: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1175: l_group_change boolean;
1176: l_group_reclass_type FA_TRX_REFERENCES.src_transaction_subtype%type;
1169: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
1170: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1171: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1172: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1173: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1174: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1175: l_group_change boolean;
1176: l_group_reclass_type FA_TRX_REFERENCES.src_transaction_subtype%type;
1177:
1170: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1171: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
1172: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
1173: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
1174: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
1175: l_group_change boolean;
1176: l_group_reclass_type FA_TRX_REFERENCES.src_transaction_subtype%type;
1177:
1178:
1931: l_token varchar2(40);
1932: l_value varchar2(40);
1933: l_calling_fn VARCHAR2(30) := 'fa_masscp_pkg.mcp_retirement';
1934:
1935: l_trans_rec FA_API_TYPES.trans_rec_type;
1936: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1937: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1938: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1939: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1932: l_value varchar2(40);
1933: l_calling_fn VARCHAR2(30) := 'fa_masscp_pkg.mcp_retirement';
1934:
1935: l_trans_rec FA_API_TYPES.trans_rec_type;
1936: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1937: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1938: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1939: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1940: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1933: l_calling_fn VARCHAR2(30) := 'fa_masscp_pkg.mcp_retirement';
1934:
1935: l_trans_rec FA_API_TYPES.trans_rec_type;
1936: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1937: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1938: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1939: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1940: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1941: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1934:
1935: l_trans_rec FA_API_TYPES.trans_rec_type;
1936: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1937: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1938: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1939: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1940: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1941: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1942:
1935: l_trans_rec FA_API_TYPES.trans_rec_type;
1936: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1937: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1938: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1939: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1940: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1941: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1942:
1943: -- exceptions
1936: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1937: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1938: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1939: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1940: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1941: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1942:
1943: -- exceptions
1944: val_err EXCEPTION;
1937: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1938: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1939: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1940: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1941: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1942:
1943: -- exceptions
1944: val_err EXCEPTION;
1945: ret_err1 EXCEPTION;
2730: and prior fpw1.transaction_type_code = 'ADDITION';
2731:
2732:
2733: -- local variables
2734: l_corp_period_rec FA_API_TYPES.period_rec_type;
2735: l_tax_period_rec FA_API_TYPES.period_rec_type;
2736:
2737:
2738: -- Used for bulk fetching
2731:
2732:
2733: -- local variables
2734: l_corp_period_rec FA_API_TYPES.period_rec_type;
2735: l_tax_period_rec FA_API_TYPES.period_rec_type;
2736:
2737:
2738: -- Used for bulk fetching
2739: l_batch_size number := 200;