1: PACKAGE BODY FA_MASSTFR_PKG as
2: /* $Header: FAMTFRB.pls 120.17 2009/05/29 15:28:55 bridgway ship $ */
3:
4: g_log_level_rec fa_api_types.log_level_rec_type;
5:
6: PROCEDURE do_mass_transfer (
7: p_mass_transfer_id IN NUMBER,
8: p_parent_request_id IN NUMBER,
60: l_msg_count number := 0;
61: l_msg_data VARCHAR2(4000);
62: l_calling_fn VARCHAR2(40) := 'fa_masstfr_pkg.do_mass_transfer';
63:
64: l_trans_rec FA_API_TYPES.trans_rec_type;
65: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
66: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
67:
68: -- mass transfer info
61: l_msg_data VARCHAR2(4000);
62: l_calling_fn VARCHAR2(40) := 'fa_masstfr_pkg.do_mass_transfer';
63:
64: l_trans_rec FA_API_TYPES.trans_rec_type;
65: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
66: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
67:
68: -- mass transfer info
69:
62: l_calling_fn VARCHAR2(40) := 'fa_masstfr_pkg.do_mass_transfer';
63:
64: l_trans_rec FA_API_TYPES.trans_rec_type;
65: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
66: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
67:
68: -- mass transfer info
69:
70: cursor c_mass_tfr_info is