36: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type) IS
37:
38: CURSOR c_tax_books IS
39: select distinct book_type_code
40: from fa_books
41: where asset_id = px_asset_hdr_rec.asset_id
42: /*code fix for bug no.3768406.Changed the field from date_effective to date_ineffective*/
43: and date_ineffective is null;
44:
109: if (px_asset_hdr_rec.book_type_code is null) then
110:
111: select bk.book_type_code
112: into px_asset_hdr_rec.book_type_code
113: from fa_books bk,
114: fa_book_controls bc
115: where bk.asset_id = px_asset_hdr_rec.asset_id
116: and bk.date_ineffective is null
117: and bk.book_type_code = bc.book_type_code
387: DELETE FROM FA_ADJUSTMENTS
388: WHERE Asset_Id = px_asset_hdr_rec.asset_id
389: AND book_Type_Code = px_asset_hdr_rec.book_type_code;
390:
391: DELETE FROM FA_BOOKS
392: WHERE Asset_Id = px_asset_hdr_rec.asset_id
393: AND book_Type_Code = px_asset_hdr_rec.book_type_code;
394:
395: DELETE FROM FA_DEPRN_DETAIL