[Home] [Help]
1614: end if;
1615:
1616: /*Bug#8289173 - to fetch transaction_header_id and retirement_id for the RETIREMENT row
1617: to not rely on table handler (for consistency)*/
1618: select fa_transaction_headers_s.nextval
1619: into l_trans_rec.transaction_header_id
1620: from dual;
1621:
1622: select fa_retirements_s.nextval
2023: if (l_asset_fin_rec.group_asset_id is not null) and
2024: (l_asset_retire_rec.recognize_gain_loss = 'NO') then
2025:
2026: --Need this for selection_thid
2027: SELECT fa_transaction_headers_s.nextval
2028: into l_dist_trans_rec.transaction_header_id /* 3513319 */
2029: FROM dual; /* Do we need this ???? dist th_id is initialized again below */
2030:
2031: -- Bug 15877517 : Reinitialize who_info as well
2109: fa_debug_pkg.add(l_calling_fn, 'asset_id:', l_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);
2110: fa_debug_pkg.add(l_calling_fn, 'book_type_code:', l_asset_hdr_rec.book_type_code, p_log_level_rec => p_log_level_rec);
2111: end if;
2112:
2113: SELECT fa_transaction_headers_s.nextval
2114: into l_dist_trans_rec.transaction_header_id
2115: FROM dual;
2116:
2117: -- Bug 15877517 : Reinitialize who_info as well
5112:
5113: end if; -- date_retired
5114:
5115: -- Pop the transaction_header_id for the REINSTATEMENT row
5116: select fa_transaction_headers_s.nextval
5117: into l_trans_rec.transaction_header_id
5118: from dual;
5119:
5120: -- Bug 15877517 : Reinitialize who_info as well