252: p_ytd_production IN NUMBER DEFAULT NULL,
253: p_ltd_production IN NUMBER DEFAULT NULL
254: ) AS
255:
256: l_trans_rec fa_api_types.trans_rec_type;
257: l_dist_trans_rec fa_api_types.trans_rec_type;
258: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
259: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
260: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
253: p_ltd_production IN NUMBER DEFAULT NULL
254: ) AS
255:
256: l_trans_rec fa_api_types.trans_rec_type;
257: l_dist_trans_rec fa_api_types.trans_rec_type;
258: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
259: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
260: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
261: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
254: ) AS
255:
256: l_trans_rec fa_api_types.trans_rec_type;
257: l_dist_trans_rec fa_api_types.trans_rec_type;
258: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
259: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
260: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
261: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
262: l_asset_type_rec fa_api_types.asset_type_rec_type;
255:
256: l_trans_rec fa_api_types.trans_rec_type;
257: l_dist_trans_rec fa_api_types.trans_rec_type;
258: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
259: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
260: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
261: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
262: l_asset_type_rec fa_api_types.asset_type_rec_type;
263: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
256: l_trans_rec fa_api_types.trans_rec_type;
257: l_dist_trans_rec fa_api_types.trans_rec_type;
258: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
259: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
260: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
261: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
262: l_asset_type_rec fa_api_types.asset_type_rec_type;
263: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
264: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
257: l_dist_trans_rec fa_api_types.trans_rec_type;
258: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
259: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
260: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
261: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
262: l_asset_type_rec fa_api_types.asset_type_rec_type;
263: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
264: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
265: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
258: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
259: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
260: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
261: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
262: l_asset_type_rec fa_api_types.asset_type_rec_type;
263: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
264: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
265: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
266: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
259: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
260: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
261: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
262: l_asset_type_rec fa_api_types.asset_type_rec_type;
263: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
264: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
265: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
266: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
267: l_inv_rec fa_api_types.inv_rec_type;
260: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
261: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
262: l_asset_type_rec fa_api_types.asset_type_rec_type;
263: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
264: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
265: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
266: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
267: l_inv_rec fa_api_types.inv_rec_type;
268: l_inv_tbl fa_api_types.inv_tbl_type;
261: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
262: l_asset_type_rec fa_api_types.asset_type_rec_type;
263: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
264: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
265: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
266: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
267: l_inv_rec fa_api_types.inv_rec_type;
268: l_inv_tbl fa_api_types.inv_tbl_type;
269: /* toru */
262: l_asset_type_rec fa_api_types.asset_type_rec_type;
263: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
264: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
265: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
266: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
267: l_inv_rec fa_api_types.inv_rec_type;
268: l_inv_tbl fa_api_types.inv_tbl_type;
269: /* toru */
270: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
263: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
264: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
265: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
266: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
267: l_inv_rec fa_api_types.inv_rec_type;
268: l_inv_tbl fa_api_types.inv_tbl_type;
269: /* toru */
270: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
271: /* Etoru */
264: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
265: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
266: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
267: l_inv_rec fa_api_types.inv_rec_type;
268: l_inv_tbl fa_api_types.inv_tbl_type;
269: /* toru */
270: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
271: /* Etoru */
272:
266: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
267: l_inv_rec fa_api_types.inv_rec_type;
268: l_inv_tbl fa_api_types.inv_tbl_type;
269: /* toru */
270: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
271: /* Etoru */
272:
273: BEGIN
274: -- Initialize message list if p_init_msg_list is set to TRUE.
893: ) AS
894:
895: adj_err exception;
896:
897: l_trans_rec fa_api_types.trans_rec_type;
898: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
899: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
900: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
901: l_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
894:
895: adj_err exception;
896:
897: l_trans_rec fa_api_types.trans_rec_type;
898: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
899: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
900: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
901: l_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
902: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
895: adj_err exception;
896:
897: l_trans_rec fa_api_types.trans_rec_type;
898: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
899: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
900: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
901: l_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
902: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
903: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
896:
897: l_trans_rec fa_api_types.trans_rec_type;
898: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
899: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
900: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
901: l_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
902: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
903: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
904: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
897: l_trans_rec fa_api_types.trans_rec_type;
898: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
899: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
900: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
901: l_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
902: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
903: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
904: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
905: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
898: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
899: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
900: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
901: l_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
902: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
903: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
904: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
905: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
906: l_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
899: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
900: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
901: l_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
902: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
903: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
904: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
905: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
906: l_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
907: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
900: l_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
901: l_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
902: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
903: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
904: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
905: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
906: l_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
907: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
908: l_asset_deprn_mrc_tbl_new fa_api_types.asset_deprn_tbl_type;
901: l_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
902: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
903: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
904: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
905: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
906: l_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
907: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
908: l_asset_deprn_mrc_tbl_new fa_api_types.asset_deprn_tbl_type;
909: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
902: l_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
903: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
904: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
905: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
906: l_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
907: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
908: l_asset_deprn_mrc_tbl_new fa_api_types.asset_deprn_tbl_type;
909: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
910: l_inv_rec fa_api_types.inv_rec_type;
903: l_asset_fin_mrc_tbl_new fa_api_types.asset_fin_tbl_type;
904: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
905: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
906: l_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
907: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
908: l_asset_deprn_mrc_tbl_new fa_api_types.asset_deprn_tbl_type;
909: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
910: l_inv_rec fa_api_types.inv_rec_type;
911: l_inv_rec_old fa_api_types.inv_rec_type;
904: l_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
905: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
906: l_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
907: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
908: l_asset_deprn_mrc_tbl_new fa_api_types.asset_deprn_tbl_type;
909: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
910: l_inv_rec fa_api_types.inv_rec_type;
911: l_inv_rec_old fa_api_types.inv_rec_type;
912: l_inv_tbl fa_api_types.inv_tbl_type;
905: l_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
906: l_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
907: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
908: l_asset_deprn_mrc_tbl_new fa_api_types.asset_deprn_tbl_type;
909: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
910: l_inv_rec fa_api_types.inv_rec_type;
911: l_inv_rec_old fa_api_types.inv_rec_type;
912: l_inv_tbl fa_api_types.inv_tbl_type;
913: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
906: l_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
907: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
908: l_asset_deprn_mrc_tbl_new fa_api_types.asset_deprn_tbl_type;
909: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
910: l_inv_rec fa_api_types.inv_rec_type;
911: l_inv_rec_old fa_api_types.inv_rec_type;
912: l_inv_tbl fa_api_types.inv_tbl_type;
913: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
914:
907: l_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
908: l_asset_deprn_mrc_tbl_new fa_api_types.asset_deprn_tbl_type;
909: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
910: l_inv_rec fa_api_types.inv_rec_type;
911: l_inv_rec_old fa_api_types.inv_rec_type;
912: l_inv_tbl fa_api_types.inv_tbl_type;
913: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
914:
915: BEGIN
908: l_asset_deprn_mrc_tbl_new fa_api_types.asset_deprn_tbl_type;
909: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
910: l_inv_rec fa_api_types.inv_rec_type;
911: l_inv_rec_old fa_api_types.inv_rec_type;
912: l_inv_tbl fa_api_types.inv_tbl_type;
913: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
914:
915: BEGIN
916: -- Initialize message list if p_init_msg_list is set to TRUE.
909: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
910: l_inv_rec fa_api_types.inv_rec_type;
911: l_inv_rec_old fa_api_types.inv_rec_type;
912: l_inv_tbl fa_api_types.inv_tbl_type;
913: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
914:
915: BEGIN
916: -- Initialize message list if p_init_msg_list is set to TRUE.
917: IF FND_API.To_Boolean(p_init_msg_list) THEN
1379: p_book_type_code IN VARCHAR2,
1380: p_set_of_books_id IN NUMBER DEFAULT NULL
1381: ) AS
1382:
1383: l_trans_rec fa_api_types.trans_rec_type;
1384: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1385: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
1386: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
1387:
1380: p_set_of_books_id IN NUMBER DEFAULT NULL
1381: ) AS
1382:
1383: l_trans_rec fa_api_types.trans_rec_type;
1384: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1385: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
1386: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
1387:
1388: BEGIN
1381: ) AS
1382:
1383: l_trans_rec fa_api_types.trans_rec_type;
1384: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1385: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
1386: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
1387:
1388: BEGIN
1389:
1382:
1383: l_trans_rec fa_api_types.trans_rec_type;
1384: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1385: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
1386: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
1387:
1388: BEGIN
1389:
1390: -- Initialize message list if p_init_msg_list is set to TRUE.
1540: p_book_type_code IN VARCHAR2,
1541: p_set_of_books_id IN NUMBER DEFAULT NULL
1542: ) AS
1543:
1544: l_trans_rec fa_api_types.trans_rec_type;
1545: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1546: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
1547: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
1548:
1541: p_set_of_books_id IN NUMBER DEFAULT NULL
1542: ) AS
1543:
1544: l_trans_rec fa_api_types.trans_rec_type;
1545: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1546: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
1547: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
1548:
1549: BEGIN
1542: ) AS
1543:
1544: l_trans_rec fa_api_types.trans_rec_type;
1545: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1546: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
1547: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
1548:
1549: BEGIN
1550:
1543:
1544: l_trans_rec fa_api_types.trans_rec_type;
1545: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1546: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
1547: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
1548:
1549: BEGIN
1550:
1551: -- Initialize message list if p_init_msg_list is set to TRUE.
1688: -- Destination Asset Header Info --
1689: p_dest_asset_id IN NUMBER
1690: ) AS
1691:
1692: l_src_trans_rec fa_api_types.trans_rec_type;
1693: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1694: l_dest_trans_rec fa_api_types.trans_rec_type;
1695: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1696: l_inv_rec fa_api_types.inv_rec_type;
1689: p_dest_asset_id IN NUMBER
1690: ) AS
1691:
1692: l_src_trans_rec fa_api_types.trans_rec_type;
1693: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1694: l_dest_trans_rec fa_api_types.trans_rec_type;
1695: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1696: l_inv_rec fa_api_types.inv_rec_type;
1697: l_inv_tbl fa_api_types.inv_tbl_type;
1690: ) AS
1691:
1692: l_src_trans_rec fa_api_types.trans_rec_type;
1693: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1694: l_dest_trans_rec fa_api_types.trans_rec_type;
1695: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1696: l_inv_rec fa_api_types.inv_rec_type;
1697: l_inv_tbl fa_api_types.inv_tbl_type;
1698:
1691:
1692: l_src_trans_rec fa_api_types.trans_rec_type;
1693: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1694: l_dest_trans_rec fa_api_types.trans_rec_type;
1695: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1696: l_inv_rec fa_api_types.inv_rec_type;
1697: l_inv_tbl fa_api_types.inv_tbl_type;
1698:
1699: BEGIN
1692: l_src_trans_rec fa_api_types.trans_rec_type;
1693: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1694: l_dest_trans_rec fa_api_types.trans_rec_type;
1695: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1696: l_inv_rec fa_api_types.inv_rec_type;
1697: l_inv_tbl fa_api_types.inv_tbl_type;
1698:
1699: BEGIN
1700:
1693: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1694: l_dest_trans_rec fa_api_types.trans_rec_type;
1695: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1696: l_inv_rec fa_api_types.inv_rec_type;
1697: l_inv_tbl fa_api_types.inv_tbl_type;
1698:
1699: BEGIN
1700:
1701: -- Initialize message list if p_init_msg_list is set to TRUE.
1991: p_copy_cat_desc_flag IN VARCHAR2 DEFAULT 'NO',
1992: p_redefault_flag IN VARCHAR2 DEFAULT 'NO'
1993: ) AS
1994:
1995: l_trans_rec fa_api_types.trans_rec_type;
1996: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1997: l_asset_cat_rec_new fa_api_types.asset_cat_rec_type;
1998: l_reclass_options_rec fa_api_types.reclass_options_rec_type;
1999:
1992: p_redefault_flag IN VARCHAR2 DEFAULT 'NO'
1993: ) AS
1994:
1995: l_trans_rec fa_api_types.trans_rec_type;
1996: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1997: l_asset_cat_rec_new fa_api_types.asset_cat_rec_type;
1998: l_reclass_options_rec fa_api_types.reclass_options_rec_type;
1999:
2000: BEGIN
1993: ) AS
1994:
1995: l_trans_rec fa_api_types.trans_rec_type;
1996: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1997: l_asset_cat_rec_new fa_api_types.asset_cat_rec_type;
1998: l_reclass_options_rec fa_api_types.reclass_options_rec_type;
1999:
2000: BEGIN
2001:
1994:
1995: l_trans_rec fa_api_types.trans_rec_type;
1996: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1997: l_asset_cat_rec_new fa_api_types.asset_cat_rec_type;
1998: l_reclass_options_rec fa_api_types.reclass_options_rec_type;
1999:
2000: BEGIN
2001:
2002: -- Initialize message list if p_init_msg_list is set to TRUE.
2232: p_ret_attribute15 IN VARCHAR2 DEFAULT NULL,
2233: p_ret_attribute_category_code IN VARCHAR2 DEFAULT NULL
2234: ) AS
2235:
2236: l_trans_rec fa_api_types.trans_rec_type;
2237: l_dist_trans_rec fa_api_types.trans_rec_type;
2238: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2239: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2240: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2233: p_ret_attribute_category_code IN VARCHAR2 DEFAULT NULL
2234: ) AS
2235:
2236: l_trans_rec fa_api_types.trans_rec_type;
2237: l_dist_trans_rec fa_api_types.trans_rec_type;
2238: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2239: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2240: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2241: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2234: ) AS
2235:
2236: l_trans_rec fa_api_types.trans_rec_type;
2237: l_dist_trans_rec fa_api_types.trans_rec_type;
2238: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2239: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2240: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2241: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2242: l_subcomp_rec fa_api_types.subcomp_rec_type;
2235:
2236: l_trans_rec fa_api_types.trans_rec_type;
2237: l_dist_trans_rec fa_api_types.trans_rec_type;
2238: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2239: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2240: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2241: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2242: l_subcomp_rec fa_api_types.subcomp_rec_type;
2243: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2236: l_trans_rec fa_api_types.trans_rec_type;
2237: l_dist_trans_rec fa_api_types.trans_rec_type;
2238: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2239: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2240: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2241: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2242: l_subcomp_rec fa_api_types.subcomp_rec_type;
2243: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2244: l_inv_rec fa_api_types.inv_rec_type;
2237: l_dist_trans_rec fa_api_types.trans_rec_type;
2238: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2239: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2240: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2241: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2242: l_subcomp_rec fa_api_types.subcomp_rec_type;
2243: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2244: l_inv_rec fa_api_types.inv_rec_type;
2245: l_inv_tbl fa_api_types.inv_tbl_type;
2238: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2239: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2240: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2241: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2242: l_subcomp_rec fa_api_types.subcomp_rec_type;
2243: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2244: l_inv_rec fa_api_types.inv_rec_type;
2245: l_inv_tbl fa_api_types.inv_tbl_type;
2246:
2239: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2240: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2241: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2242: l_subcomp_rec fa_api_types.subcomp_rec_type;
2243: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2244: l_inv_rec fa_api_types.inv_rec_type;
2245: l_inv_tbl fa_api_types.inv_tbl_type;
2246:
2247: BEGIN
2240: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2241: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2242: l_subcomp_rec fa_api_types.subcomp_rec_type;
2243: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2244: l_inv_rec fa_api_types.inv_rec_type;
2245: l_inv_tbl fa_api_types.inv_tbl_type;
2246:
2247: BEGIN
2248:
2241: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2242: l_subcomp_rec fa_api_types.subcomp_rec_type;
2243: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2244: l_inv_rec fa_api_types.inv_rec_type;
2245: l_inv_tbl fa_api_types.inv_tbl_type;
2246:
2247: BEGIN
2248:
2249: -- Initialize message list if p_init_msg_list is set to TRUE.
2537: p_retirement_id IN NUMBER DEFAULT NULL,
2538: p_status IN VARCHAR2 DEFAULT NULL
2539: ) AS
2540:
2541: l_trans_rec fa_api_types.trans_rec_type;
2542: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2543: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2544:
2545: BEGIN
2538: p_status IN VARCHAR2 DEFAULT NULL
2539: ) AS
2540:
2541: l_trans_rec fa_api_types.trans_rec_type;
2542: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2543: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2544:
2545: BEGIN
2546:
2539: ) AS
2540:
2541: l_trans_rec fa_api_types.trans_rec_type;
2542: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2543: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2544:
2545: BEGIN
2546:
2547: -- Initialize message list if p_init_msg_list is set to TRUE.
2734: p_ret_attribute15 IN VARCHAR2 DEFAULT NULL,
2735: p_ret_attribute_category_code IN VARCHAR2 DEFAULT NULL
2736: ) AS
2737:
2738: l_trans_rec fa_api_types.trans_rec_type;
2739: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2740: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2741: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2742: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2735: p_ret_attribute_category_code IN VARCHAR2 DEFAULT NULL
2736: ) AS
2737:
2738: l_trans_rec fa_api_types.trans_rec_type;
2739: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2740: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2741: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2742: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2743: l_subcomp_rec fa_api_types.subcomp_rec_type;
2736: ) AS
2737:
2738: l_trans_rec fa_api_types.trans_rec_type;
2739: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2740: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2741: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2742: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2743: l_subcomp_rec fa_api_types.subcomp_rec_type;
2744: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2737:
2738: l_trans_rec fa_api_types.trans_rec_type;
2739: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2740: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2741: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2742: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2743: l_subcomp_rec fa_api_types.subcomp_rec_type;
2744: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2745: l_inv_rec fa_api_types.inv_rec_type;
2738: l_trans_rec fa_api_types.trans_rec_type;
2739: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2740: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2741: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2742: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2743: l_subcomp_rec fa_api_types.subcomp_rec_type;
2744: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2745: l_inv_rec fa_api_types.inv_rec_type;
2746: l_inv_tbl fa_api_types.inv_tbl_type;
2739: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
2740: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2741: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2742: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2743: l_subcomp_rec fa_api_types.subcomp_rec_type;
2744: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2745: l_inv_rec fa_api_types.inv_rec_type;
2746: l_inv_tbl fa_api_types.inv_tbl_type;
2747:
2740: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
2741: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2742: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2743: l_subcomp_rec fa_api_types.subcomp_rec_type;
2744: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2745: l_inv_rec fa_api_types.inv_rec_type;
2746: l_inv_tbl fa_api_types.inv_tbl_type;
2747:
2748: BEGIN
2741: l_asset_dist_rec fa_api_types.asset_dist_rec_type;
2742: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2743: l_subcomp_rec fa_api_types.subcomp_rec_type;
2744: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2745: l_inv_rec fa_api_types.inv_rec_type;
2746: l_inv_tbl fa_api_types.inv_tbl_type;
2747:
2748: BEGIN
2749:
2742: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
2743: l_subcomp_rec fa_api_types.subcomp_rec_type;
2744: l_subcomp_tbl fa_api_types.subcomp_tbl_type;
2745: l_inv_rec fa_api_types.inv_rec_type;
2746: l_inv_tbl fa_api_types.inv_tbl_type;
2747:
2748: BEGIN
2749:
2750: -- Initialize message list if p_init_msg_list is set to TRUE.
2996: p_retirement_id IN NUMBER DEFAULT NULL,
2997: p_status IN VARCHAR2 DEFAULT NULL
2998: ) AS
2999:
3000: l_trans_rec fa_api_types.trans_rec_type;
3001: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3002: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
3003:
3004: BEGIN
2997: p_status IN VARCHAR2 DEFAULT NULL
2998: ) AS
2999:
3000: l_trans_rec fa_api_types.trans_rec_type;
3001: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3002: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
3003:
3004: BEGIN
3005:
2998: ) AS
2999:
3000: l_trans_rec fa_api_types.trans_rec_type;
3001: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3002: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
3003:
3004: BEGIN
3005:
3006: -- Initialize message list if p_init_msg_list is set to TRUE.
3169: -- Asset Financial Info --
3170: p_date_placed_in_service IN DATE
3171: ) AS
3172:
3173: l_trans_rec fa_api_types.trans_rec_type;
3174: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3175: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
3176:
3177: BEGIN
3170: p_date_placed_in_service IN DATE
3171: ) AS
3172:
3173: l_trans_rec fa_api_types.trans_rec_type;
3174: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3175: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
3176:
3177: BEGIN
3178:
3171: ) AS
3172:
3173: l_trans_rec fa_api_types.trans_rec_type;
3174: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3175: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
3176:
3177: BEGIN
3178:
3179: -- Initialize message list if p_init_msg_list is set to TRUE.
3315: -- Asset Financial Info --
3316: p_date_placed_in_service IN DATE
3317: ) AS
3318:
3319: l_trans_rec fa_api_types.trans_rec_type;
3320: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3321: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
3322:
3323: BEGIN
3316: p_date_placed_in_service IN DATE
3317: ) AS
3318:
3319: l_trans_rec fa_api_types.trans_rec_type;
3320: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3321: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
3322:
3323: BEGIN
3324:
3317: ) AS
3318:
3319: l_trans_rec fa_api_types.trans_rec_type;
3320: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3321: l_asset_fin_rec fa_api_types.asset_fin_rec_type;
3322:
3323: BEGIN
3324:
3325: -- Initialize message list if p_init_msg_list is set to TRUE.
3525: p_cat_attribute_category_code IN VARCHAR2 DEFAULT NULL,
3526: p_context IN VARCHAR2 DEFAULT NULL
3527: ) AS
3528:
3529: l_trans_rec fa_api_types.trans_rec_type;
3530: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3531: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
3532: l_asset_desc_rec_old fa_api_types.asset_desc_rec_type;
3533: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
3526: p_context IN VARCHAR2 DEFAULT NULL
3527: ) AS
3528:
3529: l_trans_rec fa_api_types.trans_rec_type;
3530: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3531: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
3532: l_asset_desc_rec_old fa_api_types.asset_desc_rec_type;
3533: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
3534: l_asset_cat_rec_old fa_api_types.asset_cat_rec_type;
3527: ) AS
3528:
3529: l_trans_rec fa_api_types.trans_rec_type;
3530: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3531: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
3532: l_asset_desc_rec_old fa_api_types.asset_desc_rec_type;
3533: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
3534: l_asset_cat_rec_old fa_api_types.asset_cat_rec_type;
3535:
3528:
3529: l_trans_rec fa_api_types.trans_rec_type;
3530: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3531: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
3532: l_asset_desc_rec_old fa_api_types.asset_desc_rec_type;
3533: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
3534: l_asset_cat_rec_old fa_api_types.asset_cat_rec_type;
3535:
3536: desc_err exception;
3529: l_trans_rec fa_api_types.trans_rec_type;
3530: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3531: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
3532: l_asset_desc_rec_old fa_api_types.asset_desc_rec_type;
3533: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
3534: l_asset_cat_rec_old fa_api_types.asset_cat_rec_type;
3535:
3536: desc_err exception;
3537:
3530: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3531: l_asset_desc_rec fa_api_types.asset_desc_rec_type;
3532: l_asset_desc_rec_old fa_api_types.asset_desc_rec_type;
3533: l_asset_cat_rec fa_api_types.asset_cat_rec_type;
3534: l_asset_cat_rec_old fa_api_types.asset_cat_rec_type;
3535:
3536: desc_err exception;
3537:
3538: BEGIN
3774: p_book_type_code IN VARCHAR2,
3775: p_set_of_books_id IN NUMBER DEFAULT NULL
3776: ) AS
3777:
3778: l_trans_rec fa_api_types.trans_rec_type;
3779: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3780: l_inv_rec fa_api_types.inv_rec_type;
3781: l_inv_rec_old fa_api_types.inv_rec_type;
3782: l_inv_tbl fa_api_types.inv_tbl_type;
3775: p_set_of_books_id IN NUMBER DEFAULT NULL
3776: ) AS
3777:
3778: l_trans_rec fa_api_types.trans_rec_type;
3779: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3780: l_inv_rec fa_api_types.inv_rec_type;
3781: l_inv_rec_old fa_api_types.inv_rec_type;
3782: l_inv_tbl fa_api_types.inv_tbl_type;
3783:
3776: ) AS
3777:
3778: l_trans_rec fa_api_types.trans_rec_type;
3779: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3780: l_inv_rec fa_api_types.inv_rec_type;
3781: l_inv_rec_old fa_api_types.inv_rec_type;
3782: l_inv_tbl fa_api_types.inv_tbl_type;
3783:
3784: desc_err exception;
3777:
3778: l_trans_rec fa_api_types.trans_rec_type;
3779: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3780: l_inv_rec fa_api_types.inv_rec_type;
3781: l_inv_rec_old fa_api_types.inv_rec_type;
3782: l_inv_tbl fa_api_types.inv_tbl_type;
3783:
3784: desc_err exception;
3785:
3778: l_trans_rec fa_api_types.trans_rec_type;
3779: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
3780: l_inv_rec fa_api_types.inv_rec_type;
3781: l_inv_rec_old fa_api_types.inv_rec_type;
3782: l_inv_tbl fa_api_types.inv_tbl_type;
3783:
3784: desc_err exception;
3785:
3786: BEGIN
4008: p_ret_attribute15 IN VARCHAR2 DEFAULT NULL,
4009: p_ret_attribute_category_code IN VARCHAR2 DEFAULT NULL
4010: ) AS
4011:
4012: l_trans_rec fa_api_types.trans_rec_type;
4013: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
4014: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
4015: l_asset_retire_rec_old fa_api_types.asset_retire_rec_type;
4016:
4009: p_ret_attribute_category_code IN VARCHAR2 DEFAULT NULL
4010: ) AS
4011:
4012: l_trans_rec fa_api_types.trans_rec_type;
4013: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
4014: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
4015: l_asset_retire_rec_old fa_api_types.asset_retire_rec_type;
4016:
4017: desc_err exception;
4010: ) AS
4011:
4012: l_trans_rec fa_api_types.trans_rec_type;
4013: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
4014: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
4015: l_asset_retire_rec_old fa_api_types.asset_retire_rec_type;
4016:
4017: desc_err exception;
4018:
4011:
4012: l_trans_rec fa_api_types.trans_rec_type;
4013: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
4014: l_asset_retire_rec fa_api_types.asset_retire_rec_type;
4015: l_asset_retire_rec_old fa_api_types.asset_retire_rec_type;
4016:
4017: desc_err exception;
4018:
4019: BEGIN
4201: p_unplanned_amount IN NUMBER,
4202: p_unplanned_type IN VARCHAR2 DEFAULT NULL
4203: ) AS
4204:
4205: l_trans_rec fa_api_types.trans_rec_type;
4206: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
4207: l_unplanned_deprn_rec fa_api_types.unplanned_deprn_rec_type;
4208:
4209: BEGIN
4202: p_unplanned_type IN VARCHAR2 DEFAULT NULL
4203: ) AS
4204:
4205: l_trans_rec fa_api_types.trans_rec_type;
4206: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
4207: l_unplanned_deprn_rec fa_api_types.unplanned_deprn_rec_type;
4208:
4209: BEGIN
4210:
4203: ) AS
4204:
4205: l_trans_rec fa_api_types.trans_rec_type;
4206: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
4207: l_unplanned_deprn_rec fa_api_types.unplanned_deprn_rec_type;
4208:
4209: BEGIN
4210:
4211: -- Initialize message list if p_init_msg_list is set to TRUE.
4358: p_transfer_amount IN NUMBER,
4359: p_dest_asset_id IN NUMBER -- Destination Asset Id
4360: ) IS
4361:
4362: l_src_trans_rec FA_API_TYPES.trans_rec_type;
4363: l_dest_trans_rec FA_API_TYPES.trans_rec_type;
4364:
4365: BEGIN
4366:
4359: p_dest_asset_id IN NUMBER -- Destination Asset Id
4360: ) IS
4361:
4362: l_src_trans_rec FA_API_TYPES.trans_rec_type;
4363: l_dest_trans_rec FA_API_TYPES.trans_rec_type;
4364:
4365: BEGIN
4366:
4367: -- Initialize message list if p_init_msg_list is set to TRUE.
4478: p_proceeds_of_sale IN NUMBER,
4479: p_cost_of_removal IN NUMBER
4480: ) IS
4481:
4482: l_trans_rec fa_api_types.trans_rec_type;
4483: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
4484:
4485: BEGIN
4486: l_trans_rec.transaction_type_code := 'GROUP ADJUSTMENT';
4479: p_cost_of_removal IN NUMBER
4480: ) IS
4481:
4482: l_trans_rec fa_api_types.trans_rec_type;
4483: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
4484:
4485: BEGIN
4486: l_trans_rec.transaction_type_code := 'GROUP ADJUSTMENT';
4487: l_trans_rec.transaction_subtype := 'AMORTIZED';
4570: p_deprn_basis_formula IN NUMBER,
4571: p_run_mode IN VARCHAR2 DEFAULT 'RUN'
4572: ) IS
4573:
4574: l_trans_rec fa_api_types.trans_rec_type;
4575: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
4576: l_asset_tax_rsv_adj_rec fa_api_types.asset_tax_rsv_adj_rec_type;
4577:
4578: BEGIN
4571: p_run_mode IN VARCHAR2 DEFAULT 'RUN'
4572: ) IS
4573:
4574: l_trans_rec fa_api_types.trans_rec_type;
4575: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
4576: l_asset_tax_rsv_adj_rec fa_api_types.asset_tax_rsv_adj_rec_type;
4577:
4578: BEGIN
4579: -- Initialize message list if p_init_msg_list is set to TRUE.
4572: ) IS
4573:
4574: l_trans_rec fa_api_types.trans_rec_type;
4575: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
4576: l_asset_tax_rsv_adj_rec fa_api_types.asset_tax_rsv_adj_rec_type;
4577:
4578: BEGIN
4579: -- Initialize message list if p_init_msg_list is set to TRUE.
4580: IF FND_API.To_Boolean(p_init_msg_list) THEN