[Home] [Help]
487: end if;
488: /*Bug# 8394781- end */
489:
490: --
491: -- Populate FA_ITF_IMPAIRMENTS with worker_ids etc
492: --
493: if not assign_workers (p_request_id => l_request_id,
494: p_book_type_code => p_book_type_code,
495: p_total_requests => l_total_requests,
866: SET STATUS='RUNNING DEPRN FAILED'
867: WHERE REQUEST_ID = l_request_id
868: AND EXISTS
869: (SELECT 'DUPLICATE RECORD'
870: FROM FA_ITF_IMPAIRMENTS ITF
871: WHERE ITF.PERIOD_OF_ADDITION_FLAG = 'F'
872: AND ITF.IMPAIRMENT_ID = IMP.IMPAIRMENT_ID);
873: --Bug# 7045739 end
874: /*8666930 start - There could be more than one set_of_books_id attached.Need to update for all */
1539: --
1540: -- Primary Book
1541: --
1542: --Bug# 7292608 When updating uploaded impairment,existing row needs to be deleted first
1543: delete from fa_itf_impairments itmp
1544: where exists
1545: (select 'Uploaded impairment'
1546: from fa_books bk , fa_impairments imp
1547: where imp.book_type_code = p_book_type_code
1555: bk.cash_generating_unit_id = imp.cash_generating_unit_id)
1556: and bk.transaction_header_id_out is null
1557: and itmp.impairment_id = imp.impairment_id);
1558:
1559: insert into fa_itf_impairments(
1560: REQUEST_ID
1561: , IMPAIRMENT_ID
1562: , BOOK_TYPE_CODE
1563: , ASSET_ID
1654:
1655: commit;
1656:
1657: --Bug# 7292608 When updating uploaded impairment,existing row needs to be deleted first
1658: delete from fa_itf_impairments itmp
1659: where exists
1660: (select 'Uploaded impairment'
1661: from fa_books bk , fa_impairments imp
1662: where imp.book_type_code = p_book_type_code
1670: and bk.transaction_header_id_out is null
1671: and itmp.impairment_id = imp.impairment_id);
1672:
1673: -- Insert goodwill asset record into itf table
1674: insert into fa_itf_impairments(
1675: REQUEST_ID
1676: , IMPAIRMENT_ID
1677: , BOOK_TYPE_CODE
1678: , ASSET_ID