90: l_validation_level number := FND_API.G_VALID_LEVEL_FULL;
91: l_return_status varchar2(1) := FND_API.G_FALSE;
92: l_msg_count number := 0;
93: l_msg_data varchar2(512);
94: l_trans_rec FA_API_TYPES.trans_rec_type;
95: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
96: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
97: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
98: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
91: l_return_status varchar2(1) := FND_API.G_FALSE;
92: l_msg_count number := 0;
93: l_msg_data varchar2(512);
94: l_trans_rec FA_API_TYPES.trans_rec_type;
95: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
96: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
97: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
98: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
99: l_inv_tbl FA_API_TYPES.inv_tbl_type;
92: l_msg_count number := 0;
93: l_msg_data varchar2(512);
94: l_trans_rec FA_API_TYPES.trans_rec_type;
95: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
96: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
97: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
98: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
99: l_inv_tbl FA_API_TYPES.inv_tbl_type;
100:
93: l_msg_data varchar2(512);
94: l_trans_rec FA_API_TYPES.trans_rec_type;
95: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
96: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
97: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
98: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
99: l_inv_tbl FA_API_TYPES.inv_tbl_type;
100:
101: CURSOR qualified_assets IS
94: l_trans_rec FA_API_TYPES.trans_rec_type;
95: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
96: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
97: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
98: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
99: l_inv_tbl FA_API_TYPES.inv_tbl_type;
100:
101: CURSOR qualified_assets IS
102: SELECT ret.asset_id,
95: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
96: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
97: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
98: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
99: l_inv_tbl FA_API_TYPES.inv_tbl_type;
100:
101: CURSOR qualified_assets IS
102: SELECT ret.asset_id,
103: ret.rowid,