1: PACKAGE BODY FA_TRANS_API_PUB AS
2: /* $Header: FAPTAPIB.pls 120.27.12020000.2 2012/07/23 09:55:18 rmandali ship $ */
3:
4: g_log_level_rec fa_api_types.log_level_rec_type;
5:
6: PROCEDURE do_addition (
7: -- Standard Parameters --
8: p_api_version IN NUMBER,
269: p_extended_deprn_flag IN VARCHAR2 DEFAULT NULL
270: -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy End
271: ) AS
272:
273: l_trans_rec fa_api_types.trans_rec_type;
274: l_dist_trans_rec fa_api_types.trans_rec_type;
275: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
276: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
277: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
270: -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy End
271: ) AS
272:
273: l_trans_rec fa_api_types.trans_rec_type;
274: l_dist_trans_rec fa_api_types.trans_rec_type;
275: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
276: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
277: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
278: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
271: ) AS
272:
273: l_trans_rec fa_api_types.trans_rec_type;
274: l_dist_trans_rec fa_api_types.trans_rec_type;
275: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
276: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
277: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
278: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
279: l_asset_type_rec fa_api_types.asset_type_rec_type;
272:
273: l_trans_rec fa_api_types.trans_rec_type;
274: l_dist_trans_rec fa_api_types.trans_rec_type;
275: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
276: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
277: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
278: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
279: l_asset_type_rec fa_api_types.asset_type_rec_type;
280: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
273: l_trans_rec fa_api_types.trans_rec_type;
274: l_dist_trans_rec fa_api_types.trans_rec_type;
275: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
276: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
277: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
278: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
279: l_asset_type_rec fa_api_types.asset_type_rec_type;
280: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
281: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
274: l_dist_trans_rec fa_api_types.trans_rec_type;
275: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
276: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
277: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
278: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
279: l_asset_type_rec fa_api_types.asset_type_rec_type;
280: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
281: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
282: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
275: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
276: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
277: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
278: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
279: l_asset_type_rec fa_api_types.asset_type_rec_type;
280: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
281: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
282: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
283: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
276: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
277: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
278: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
279: l_asset_type_rec fa_api_types.asset_type_rec_type;
280: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
281: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
282: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
283: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
284: l_inv_rec fa_api_types.inv_rec_type;
277: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
278: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
279: l_asset_type_rec fa_api_types.asset_type_rec_type;
280: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
281: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
282: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
283: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
284: l_inv_rec fa_api_types.inv_rec_type;
285: l_inv_tbl fa_api_types.inv_tbl_type;
278: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
279: l_asset_type_rec fa_api_types.asset_type_rec_type;
280: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
281: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
282: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
283: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
284: l_inv_rec fa_api_types.inv_rec_type;
285: l_inv_tbl fa_api_types.inv_tbl_type;
286: /* toru */
279: l_asset_type_rec fa_api_types.asset_type_rec_type;
280: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
281: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
282: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
283: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
284: l_inv_rec fa_api_types.inv_rec_type;
285: l_inv_tbl fa_api_types.inv_tbl_type;
286: /* toru */
287: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
280: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
281: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
282: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
283: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
284: l_inv_rec fa_api_types.inv_rec_type;
285: l_inv_tbl fa_api_types.inv_tbl_type;
286: /* toru */
287: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
288: /* Etoru */
281: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
282: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
283: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
284: l_inv_rec fa_api_types.inv_rec_type;
285: l_inv_tbl fa_api_types.inv_tbl_type;
286: /* toru */
287: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
288: /* Etoru */
289:
283: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
284: l_inv_rec fa_api_types.inv_rec_type;
285: l_inv_tbl fa_api_types.inv_tbl_type;
286: /* toru */
287: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
288: /* Etoru */
289:
290: BEGIN
291: -- Initialize message list if p_init_msg_list is set to TRUE.
945: ) AS
946:
947: adj_err exception;
948:
949: l_trans_rec fa_api_types.trans_rec_type;
950: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
951: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
952: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
953: l_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
946:
947: adj_err exception;
948:
949: l_trans_rec fa_api_types.trans_rec_type;
950: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
951: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
952: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
953: l_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
954: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
947: adj_err exception;
948:
949: l_trans_rec fa_api_types.trans_rec_type;
950: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
951: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
952: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
953: l_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
954: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
955: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
948:
949: l_trans_rec fa_api_types.trans_rec_type;
950: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
951: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
952: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
953: l_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
954: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
955: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
956: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
949: l_trans_rec fa_api_types.trans_rec_type;
950: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
951: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
952: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
953: l_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
954: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
955: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
956: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
957: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
950: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
951: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
952: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
953: l_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
954: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
955: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
956: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
957: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
958: l_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
951: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
952: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
953: l_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
954: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
955: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
956: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
957: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
958: l_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
959: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
952: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
953: l_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
954: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
955: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
956: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
957: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
958: l_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
959: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
960: l_asset_deprn_mrc_tbl_new fa_api_types.asset_deprn_tbl_type;
953: l_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
954: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
955: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
956: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
957: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
958: l_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
959: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
960: l_asset_deprn_mrc_tbl_new fa_api_types.asset_deprn_tbl_type;
961: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
954: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
955: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
956: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
957: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
958: l_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
959: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
960: l_asset_deprn_mrc_tbl_new fa_api_types.asset_deprn_tbl_type;
961: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
962: l_inv_rec fa_api_types.inv_rec_type;
955: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
956: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
957: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
958: l_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
959: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
960: l_asset_deprn_mrc_tbl_new fa_api_types.asset_deprn_tbl_type;
961: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
962: l_inv_rec fa_api_types.inv_rec_type;
963: l_inv_rec_old fa_api_types.inv_rec_type;
956: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
957: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
958: l_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
959: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
960: l_asset_deprn_mrc_tbl_new fa_api_types.asset_deprn_tbl_type;
961: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
962: l_inv_rec fa_api_types.inv_rec_type;
963: l_inv_rec_old fa_api_types.inv_rec_type;
964: l_inv_tbl fa_api_types.inv_tbl_type;
957: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
958: l_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
959: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
960: l_asset_deprn_mrc_tbl_new fa_api_types.asset_deprn_tbl_type;
961: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
962: l_inv_rec fa_api_types.inv_rec_type;
963: l_inv_rec_old fa_api_types.inv_rec_type;
964: l_inv_tbl fa_api_types.inv_tbl_type;
965: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
958: l_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
959: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
960: l_asset_deprn_mrc_tbl_new fa_api_types.asset_deprn_tbl_type;
961: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
962: l_inv_rec fa_api_types.inv_rec_type;
963: l_inv_rec_old fa_api_types.inv_rec_type;
964: l_inv_tbl fa_api_types.inv_tbl_type;
965: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
966:
959: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
960: l_asset_deprn_mrc_tbl_new fa_api_types.asset_deprn_tbl_type;
961: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
962: l_inv_rec fa_api_types.inv_rec_type;
963: l_inv_rec_old fa_api_types.inv_rec_type;
964: l_inv_tbl fa_api_types.inv_tbl_type;
965: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
966:
967: BEGIN
960: l_asset_deprn_mrc_tbl_new fa_api_types.asset_deprn_tbl_type;
961: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
962: l_inv_rec fa_api_types.inv_rec_type;
963: l_inv_rec_old fa_api_types.inv_rec_type;
964: l_inv_tbl fa_api_types.inv_tbl_type;
965: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
966:
967: BEGIN
968: -- Initialize message list if p_init_msg_list is set to TRUE.
961: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
962: l_inv_rec fa_api_types.inv_rec_type;
963: l_inv_rec_old fa_api_types.inv_rec_type;
964: l_inv_tbl fa_api_types.inv_tbl_type;
965: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
966:
967: BEGIN
968: -- Initialize message list if p_init_msg_list is set to TRUE.
969: IF FND_API.To_Boolean(p_init_msg_list) THEN
1459: p_book_type_code IN VARCHAR2,
1460: p_set_of_books_id IN NUMBER DEFAULT NULL
1461: ) AS
1462:
1463: l_trans_rec fa_api_types.trans_rec_type;
1464: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1465: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
1466: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
1467:
1460: p_set_of_books_id IN NUMBER DEFAULT NULL
1461: ) AS
1462:
1463: l_trans_rec fa_api_types.trans_rec_type;
1464: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1465: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
1466: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
1467:
1468: BEGIN
1461: ) AS
1462:
1463: l_trans_rec fa_api_types.trans_rec_type;
1464: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1465: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
1466: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
1467:
1468: BEGIN
1469:
1462:
1463: l_trans_rec fa_api_types.trans_rec_type;
1464: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1465: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
1466: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
1467:
1468: BEGIN
1469:
1470: -- Initialize message list if p_init_msg_list is set to TRUE.
1621: p_book_type_code IN VARCHAR2,
1622: p_set_of_books_id IN NUMBER DEFAULT NULL
1623: ) AS
1624:
1625: l_trans_rec fa_api_types.trans_rec_type;
1626: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1627: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
1628: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
1629:
1622: p_set_of_books_id IN NUMBER DEFAULT NULL
1623: ) AS
1624:
1625: l_trans_rec fa_api_types.trans_rec_type;
1626: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1627: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
1628: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
1629:
1630: BEGIN
1623: ) AS
1624:
1625: l_trans_rec fa_api_types.trans_rec_type;
1626: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1627: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
1628: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
1629:
1630: BEGIN
1631:
1624:
1625: l_trans_rec fa_api_types.trans_rec_type;
1626: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1627: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
1628: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
1629:
1630: BEGIN
1631:
1632: -- Initialize message list if p_init_msg_list is set to TRUE.
1770: -- Destination Asset Header Info --
1771: p_dest_asset_id IN NUMBER
1772: ) AS
1773:
1774: l_src_trans_rec fa_api_types.trans_rec_type;
1775: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1776: l_dest_trans_rec fa_api_types.trans_rec_type;
1777: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1778: l_inv_rec fa_api_types.inv_rec_type;
1771: p_dest_asset_id IN NUMBER
1772: ) AS
1773:
1774: l_src_trans_rec fa_api_types.trans_rec_type;
1775: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1776: l_dest_trans_rec fa_api_types.trans_rec_type;
1777: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1778: l_inv_rec fa_api_types.inv_rec_type;
1779: l_inv_tbl fa_api_types.inv_tbl_type;
1772: ) AS
1773:
1774: l_src_trans_rec fa_api_types.trans_rec_type;
1775: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1776: l_dest_trans_rec fa_api_types.trans_rec_type;
1777: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1778: l_inv_rec fa_api_types.inv_rec_type;
1779: l_inv_tbl fa_api_types.inv_tbl_type;
1780:
1773:
1774: l_src_trans_rec fa_api_types.trans_rec_type;
1775: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1776: l_dest_trans_rec fa_api_types.trans_rec_type;
1777: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1778: l_inv_rec fa_api_types.inv_rec_type;
1779: l_inv_tbl fa_api_types.inv_tbl_type;
1780:
1781: BEGIN
1774: l_src_trans_rec fa_api_types.trans_rec_type;
1775: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1776: l_dest_trans_rec fa_api_types.trans_rec_type;
1777: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1778: l_inv_rec fa_api_types.inv_rec_type;
1779: l_inv_tbl fa_api_types.inv_tbl_type;
1780:
1781: BEGIN
1782:
1775: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1776: l_dest_trans_rec fa_api_types.trans_rec_type;
1777: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1778: l_inv_rec fa_api_types.inv_rec_type;
1779: l_inv_tbl fa_api_types.inv_tbl_type;
1780:
1781: BEGIN
1782:
1783: -- Initialize message list if p_init_msg_list is set to TRUE.
2074: p_copy_cat_desc_flag IN VARCHAR2 DEFAULT 'NO',
2075: p_redefault_flag IN VARCHAR2 DEFAULT 'NO'
2076: ) AS
2077:
2078: l_trans_rec fa_api_types.trans_rec_type;
2079: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2080: l_asset_cat_rec_new fa_api_types.asset_cat_rec_type;
2081: l_reclass_options_rec fa_api_types.reclass_options_rec_type;
2082:
2075: p_redefault_flag IN VARCHAR2 DEFAULT 'NO'
2076: ) AS
2077:
2078: l_trans_rec fa_api_types.trans_rec_type;
2079: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2080: l_asset_cat_rec_new fa_api_types.asset_cat_rec_type;
2081: l_reclass_options_rec fa_api_types.reclass_options_rec_type;
2082:
2083: BEGIN
2076: ) AS
2077:
2078: l_trans_rec fa_api_types.trans_rec_type;
2079: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2080: l_asset_cat_rec_new fa_api_types.asset_cat_rec_type;
2081: l_reclass_options_rec fa_api_types.reclass_options_rec_type;
2082:
2083: BEGIN
2084:
2077:
2078: l_trans_rec fa_api_types.trans_rec_type;
2079: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2080: l_asset_cat_rec_new fa_api_types.asset_cat_rec_type;
2081: l_reclass_options_rec fa_api_types.reclass_options_rec_type;
2082:
2083: BEGIN
2084:
2085: -- Initialize message list if p_init_msg_list is set to TRUE.
2316: p_ret_attribute15 IN VARCHAR2 DEFAULT NULL,
2317: p_ret_attribute_category_code IN VARCHAR2 DEFAULT NULL
2318: ) AS
2319:
2320: l_trans_rec fa_api_types.trans_rec_type;
2321: l_dist_trans_rec fa_api_types.trans_rec_type;
2322: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2323: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2324: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2317: p_ret_attribute_category_code IN VARCHAR2 DEFAULT NULL
2318: ) AS
2319:
2320: l_trans_rec fa_api_types.trans_rec_type;
2321: l_dist_trans_rec fa_api_types.trans_rec_type;
2322: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2323: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2324: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2325: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2318: ) AS
2319:
2320: l_trans_rec fa_api_types.trans_rec_type;
2321: l_dist_trans_rec fa_api_types.trans_rec_type;
2322: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2323: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2324: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2325: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2326: l_subcomp_rec fa_api_types.subcomp_rec_type;
2319:
2320: l_trans_rec fa_api_types.trans_rec_type;
2321: l_dist_trans_rec fa_api_types.trans_rec_type;
2322: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2323: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2324: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2325: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2326: l_subcomp_rec fa_api_types.subcomp_rec_type;
2327: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2320: l_trans_rec fa_api_types.trans_rec_type;
2321: l_dist_trans_rec fa_api_types.trans_rec_type;
2322: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2323: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2324: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2325: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2326: l_subcomp_rec fa_api_types.subcomp_rec_type;
2327: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2328: l_inv_rec fa_api_types.inv_rec_type;
2321: l_dist_trans_rec fa_api_types.trans_rec_type;
2322: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2323: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2324: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2325: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2326: l_subcomp_rec fa_api_types.subcomp_rec_type;
2327: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2328: l_inv_rec fa_api_types.inv_rec_type;
2329: l_inv_tbl fa_api_types.inv_tbl_type;
2322: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2323: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2324: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2325: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2326: l_subcomp_rec fa_api_types.subcomp_rec_type;
2327: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2328: l_inv_rec fa_api_types.inv_rec_type;
2329: l_inv_tbl fa_api_types.inv_tbl_type;
2330:
2323: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2324: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2325: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2326: l_subcomp_rec fa_api_types.subcomp_rec_type;
2327: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2328: l_inv_rec fa_api_types.inv_rec_type;
2329: l_inv_tbl fa_api_types.inv_tbl_type;
2330:
2331: BEGIN
2324: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2325: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2326: l_subcomp_rec fa_api_types.subcomp_rec_type;
2327: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2328: l_inv_rec fa_api_types.inv_rec_type;
2329: l_inv_tbl fa_api_types.inv_tbl_type;
2330:
2331: BEGIN
2332:
2325: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2326: l_subcomp_rec fa_api_types.subcomp_rec_type;
2327: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2328: l_inv_rec fa_api_types.inv_rec_type;
2329: l_inv_tbl fa_api_types.inv_tbl_type;
2330:
2331: BEGIN
2332:
2333: -- Initialize message list if p_init_msg_list is set to TRUE.
2622: p_retirement_id IN NUMBER DEFAULT NULL,
2623: p_status IN VARCHAR2 DEFAULT NULL
2624: ) AS
2625:
2626: l_trans_rec fa_api_types.trans_rec_type;
2627: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2628: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2629:
2630: BEGIN
2623: p_status IN VARCHAR2 DEFAULT NULL
2624: ) AS
2625:
2626: l_trans_rec fa_api_types.trans_rec_type;
2627: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2628: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2629:
2630: BEGIN
2631:
2624: ) AS
2625:
2626: l_trans_rec fa_api_types.trans_rec_type;
2627: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2628: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2629:
2630: BEGIN
2631:
2632: -- Initialize message list if p_init_msg_list is set to TRUE.
2820: p_ret_attribute15 IN VARCHAR2 DEFAULT NULL,
2821: p_ret_attribute_category_code IN VARCHAR2 DEFAULT NULL
2822: ) AS
2823:
2824: l_trans_rec fa_api_types.trans_rec_type;
2825: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2826: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2827: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2828: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2821: p_ret_attribute_category_code IN VARCHAR2 DEFAULT NULL
2822: ) AS
2823:
2824: l_trans_rec fa_api_types.trans_rec_type;
2825: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2826: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2827: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2828: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2829: l_subcomp_rec fa_api_types.subcomp_rec_type;
2822: ) AS
2823:
2824: l_trans_rec fa_api_types.trans_rec_type;
2825: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2826: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2827: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2828: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2829: l_subcomp_rec fa_api_types.subcomp_rec_type;
2830: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2823:
2824: l_trans_rec fa_api_types.trans_rec_type;
2825: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2826: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2827: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2828: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2829: l_subcomp_rec fa_api_types.subcomp_rec_type;
2830: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2831: l_inv_rec fa_api_types.inv_rec_type;
2824: l_trans_rec fa_api_types.trans_rec_type;
2825: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2826: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2827: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2828: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2829: l_subcomp_rec fa_api_types.subcomp_rec_type;
2830: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2831: l_inv_rec fa_api_types.inv_rec_type;
2832: l_inv_tbl fa_api_types.inv_tbl_type;
2825: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2826: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2827: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2828: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2829: l_subcomp_rec fa_api_types.subcomp_rec_type;
2830: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2831: l_inv_rec fa_api_types.inv_rec_type;
2832: l_inv_tbl fa_api_types.inv_tbl_type;
2833:
2826: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2827: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2828: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2829: l_subcomp_rec fa_api_types.subcomp_rec_type;
2830: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2831: l_inv_rec fa_api_types.inv_rec_type;
2832: l_inv_tbl fa_api_types.inv_tbl_type;
2833:
2834: BEGIN
2827: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2828: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2829: l_subcomp_rec fa_api_types.subcomp_rec_type;
2830: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2831: l_inv_rec fa_api_types.inv_rec_type;
2832: l_inv_tbl fa_api_types.inv_tbl_type;
2833:
2834: BEGIN
2835:
2828: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2829: l_subcomp_rec fa_api_types.subcomp_rec_type;
2830: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2831: l_inv_rec fa_api_types.inv_rec_type;
2832: l_inv_tbl fa_api_types.inv_tbl_type;
2833:
2834: BEGIN
2835:
2836: -- Initialize message list if p_init_msg_list is set to TRUE.
3083: p_retirement_id IN NUMBER DEFAULT NULL,
3084: p_status IN VARCHAR2 DEFAULT NULL
3085: ) AS
3086:
3087: l_trans_rec fa_api_types.trans_rec_type;
3088: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3089: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
3090:
3091: BEGIN
3084: p_status IN VARCHAR2 DEFAULT NULL
3085: ) AS
3086:
3087: l_trans_rec fa_api_types.trans_rec_type;
3088: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3089: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
3090:
3091: BEGIN
3092:
3085: ) AS
3086:
3087: l_trans_rec fa_api_types.trans_rec_type;
3088: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3089: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
3090:
3091: BEGIN
3092:
3093: -- Initialize message list if p_init_msg_list is set to TRUE.
3257: -- Asset Financial Info --
3258: p_date_placed_in_service IN DATE
3259: ) AS
3260:
3261: l_trans_rec fa_api_types.trans_rec_type;
3262: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3263: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
3264:
3265: BEGIN
3258: p_date_placed_in_service IN DATE
3259: ) AS
3260:
3261: l_trans_rec fa_api_types.trans_rec_type;
3262: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3263: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
3264:
3265: BEGIN
3266:
3259: ) AS
3260:
3261: l_trans_rec fa_api_types.trans_rec_type;
3262: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3263: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
3264:
3265: BEGIN
3266:
3267: -- Initialize message list if p_init_msg_list is set to TRUE.
3404: -- Asset Financial Info --
3405: p_date_placed_in_service IN DATE
3406: ) AS
3407:
3408: l_trans_rec fa_api_types.trans_rec_type;
3409: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3410: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
3411:
3412: BEGIN
3405: p_date_placed_in_service IN DATE
3406: ) AS
3407:
3408: l_trans_rec fa_api_types.trans_rec_type;
3409: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3410: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
3411:
3412: BEGIN
3413:
3406: ) AS
3407:
3408: l_trans_rec fa_api_types.trans_rec_type;
3409: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3410: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
3411:
3412: BEGIN
3413:
3414: -- Initialize message list if p_init_msg_list is set to TRUE.
3616: p_cat_attribute_category_code IN VARCHAR2 DEFAULT NULL,
3617: p_context IN VARCHAR2 DEFAULT NULL
3618: ) AS
3619:
3620: l_trans_rec fa_api_types.trans_rec_type;
3621: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3622: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
3623: l_asset_desc_rec_old fa_api_types.asset_desc_rec_type;
3624: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
3617: p_context IN VARCHAR2 DEFAULT NULL
3618: ) AS
3619:
3620: l_trans_rec fa_api_types.trans_rec_type;
3621: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3622: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
3623: l_asset_desc_rec_old fa_api_types.asset_desc_rec_type;
3624: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
3625: l_asset_cat_rec_old fa_api_types.asset_cat_rec_type;
3618: ) AS
3619:
3620: l_trans_rec fa_api_types.trans_rec_type;
3621: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3622: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
3623: l_asset_desc_rec_old fa_api_types.asset_desc_rec_type;
3624: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
3625: l_asset_cat_rec_old fa_api_types.asset_cat_rec_type;
3626:
3619:
3620: l_trans_rec fa_api_types.trans_rec_type;
3621: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3622: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
3623: l_asset_desc_rec_old fa_api_types.asset_desc_rec_type;
3624: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
3625: l_asset_cat_rec_old fa_api_types.asset_cat_rec_type;
3626:
3627: desc_err exception;
3620: l_trans_rec fa_api_types.trans_rec_type;
3621: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3622: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
3623: l_asset_desc_rec_old fa_api_types.asset_desc_rec_type;
3624: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
3625: l_asset_cat_rec_old fa_api_types.asset_cat_rec_type;
3626:
3627: desc_err exception;
3628:
3621: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3622: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
3623: l_asset_desc_rec_old fa_api_types.asset_desc_rec_type;
3624: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
3625: l_asset_cat_rec_old fa_api_types.asset_cat_rec_type;
3626:
3627: desc_err exception;
3628:
3629: BEGIN
3867: p_book_type_code IN VARCHAR2,
3868: p_set_of_books_id IN NUMBER DEFAULT NULL
3869: ) AS
3870:
3871: l_trans_rec fa_api_types.trans_rec_type;
3872: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3873: l_inv_rec fa_api_types.inv_rec_type;
3874: l_inv_rec_old fa_api_types.inv_rec_type;
3875: l_inv_tbl fa_api_types.inv_tbl_type;
3868: p_set_of_books_id IN NUMBER DEFAULT NULL
3869: ) AS
3870:
3871: l_trans_rec fa_api_types.trans_rec_type;
3872: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3873: l_inv_rec fa_api_types.inv_rec_type;
3874: l_inv_rec_old fa_api_types.inv_rec_type;
3875: l_inv_tbl fa_api_types.inv_tbl_type;
3876:
3869: ) AS
3870:
3871: l_trans_rec fa_api_types.trans_rec_type;
3872: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3873: l_inv_rec fa_api_types.inv_rec_type;
3874: l_inv_rec_old fa_api_types.inv_rec_type;
3875: l_inv_tbl fa_api_types.inv_tbl_type;
3876:
3877: desc_err exception;
3870:
3871: l_trans_rec fa_api_types.trans_rec_type;
3872: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3873: l_inv_rec fa_api_types.inv_rec_type;
3874: l_inv_rec_old fa_api_types.inv_rec_type;
3875: l_inv_tbl fa_api_types.inv_tbl_type;
3876:
3877: desc_err exception;
3878:
3871: l_trans_rec fa_api_types.trans_rec_type;
3872: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3873: l_inv_rec fa_api_types.inv_rec_type;
3874: l_inv_rec_old fa_api_types.inv_rec_type;
3875: l_inv_tbl fa_api_types.inv_tbl_type;
3876:
3877: desc_err exception;
3878:
3879: BEGIN
4103: p_ret_attribute15 IN VARCHAR2 DEFAULT NULL,
4104: p_ret_attribute_category_code IN VARCHAR2 DEFAULT NULL
4105: ) AS
4106:
4107: l_trans_rec fa_api_types.trans_rec_type;
4108: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
4109: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
4110: l_asset_retire_rec_old fa_api_types.asset_retire_rec_type;
4111:
4104: p_ret_attribute_category_code IN VARCHAR2 DEFAULT NULL
4105: ) AS
4106:
4107: l_trans_rec fa_api_types.trans_rec_type;
4108: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
4109: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
4110: l_asset_retire_rec_old fa_api_types.asset_retire_rec_type;
4111:
4112: desc_err exception;
4105: ) AS
4106:
4107: l_trans_rec fa_api_types.trans_rec_type;
4108: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
4109: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
4110: l_asset_retire_rec_old fa_api_types.asset_retire_rec_type;
4111:
4112: desc_err exception;
4113:
4106:
4107: l_trans_rec fa_api_types.trans_rec_type;
4108: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
4109: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
4110: l_asset_retire_rec_old fa_api_types.asset_retire_rec_type;
4111:
4112: desc_err exception;
4113:
4114: BEGIN
4298: p_unplanned_amount IN NUMBER,
4299: p_unplanned_type IN VARCHAR2 DEFAULT NULL
4300: ) AS
4301:
4302: l_trans_rec fa_api_types.trans_rec_type;
4303: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
4304: l_unplanned_deprn_rec fa_api_types.unplanned_deprn_rec_type;
4305:
4306: BEGIN
4299: p_unplanned_type IN VARCHAR2 DEFAULT NULL
4300: ) AS
4301:
4302: l_trans_rec fa_api_types.trans_rec_type;
4303: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
4304: l_unplanned_deprn_rec fa_api_types.unplanned_deprn_rec_type;
4305:
4306: BEGIN
4307:
4300: ) AS
4301:
4302: l_trans_rec fa_api_types.trans_rec_type;
4303: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
4304: l_unplanned_deprn_rec fa_api_types.unplanned_deprn_rec_type;
4305:
4306: BEGIN
4307:
4308: -- Initialize message list if p_init_msg_list is set to TRUE.
4456: p_transfer_amount IN NUMBER,
4457: p_dest_asset_id IN NUMBER -- Destination Asset Id
4458: ) IS
4459:
4460: l_src_trans_rec FA_API_TYPES.trans_rec_type;
4461: l_dest_trans_rec FA_API_TYPES.trans_rec_type;
4462:
4463: BEGIN
4464:
4457: p_dest_asset_id IN NUMBER -- Destination Asset Id
4458: ) IS
4459:
4460: l_src_trans_rec FA_API_TYPES.trans_rec_type;
4461: l_dest_trans_rec FA_API_TYPES.trans_rec_type;
4462:
4463: BEGIN
4464:
4465: -- Initialize message list if p_init_msg_list is set to TRUE.
4577: p_proceeds_of_sale IN NUMBER,
4578: p_cost_of_removal IN NUMBER
4579: ) IS
4580:
4581: l_trans_rec fa_api_types.trans_rec_type;
4582: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
4583:
4584: BEGIN
4585: l_trans_rec.transaction_type_code := 'GROUP ADJUSTMENT';
4578: p_cost_of_removal IN NUMBER
4579: ) IS
4580:
4581: l_trans_rec fa_api_types.trans_rec_type;
4582: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
4583:
4584: BEGIN
4585: l_trans_rec.transaction_type_code := 'GROUP ADJUSTMENT';
4586: l_trans_rec.transaction_subtype := 'AMORTIZED';
4670: p_deprn_basis_formula IN NUMBER,
4671: p_run_mode IN VARCHAR2 DEFAULT 'RUN'
4672: ) IS
4673:
4674: l_trans_rec fa_api_types.trans_rec_type;
4675: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
4676: l_asset_tax_rsv_adj_rec fa_api_types.asset_tax_rsv_adj_rec_type;
4677:
4678: BEGIN
4671: p_run_mode IN VARCHAR2 DEFAULT 'RUN'
4672: ) IS
4673:
4674: l_trans_rec fa_api_types.trans_rec_type;
4675: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
4676: l_asset_tax_rsv_adj_rec fa_api_types.asset_tax_rsv_adj_rec_type;
4677:
4678: BEGIN
4679: -- Initialize message list if p_init_msg_list is set to TRUE.
4672: ) IS
4673:
4674: l_trans_rec fa_api_types.trans_rec_type;
4675: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
4676: l_asset_tax_rsv_adj_rec fa_api_types.asset_tax_rsv_adj_rec_type;
4677:
4678: BEGIN
4679: -- Initialize message list if p_init_msg_list is set to TRUE.
4680: IF FND_API.To_Boolean(p_init_msg_list) THEN