[Home] [Help]
286: --Assigned the generated event_id into the px_trans_rec.event_id
287: px_trans_rec.event_id := l_trans_rec.event_id;
288:
289: if (l_index = 1) then
290: -- insert fa_transaction_headers
291: if not insert_txn_headers(l_trans_rec,
292: l_asset_hdr_rec
293: ,p_log_level_rec => p_log_level_rec) then
294: raise error_found;
960: l_txn_head_id := px_trans_rec.transaction_header_id; --for 3188851
961: l_transaction_type_code := px_trans_rec.transaction_type_code;
962: l_transaction_subtype := px_trans_rec.transaction_subtype;
963:
964: -- if period of addition, update fa_transaction_headers with transfer in/void
965: if (p_asset_hdr_rec.period_of_addition = 'Y' and
966: G_release = 11) then
967:
968: update fa_transaction_headers
964: -- if period of addition, update fa_transaction_headers with transfer in/void
965: if (p_asset_hdr_rec.period_of_addition = 'Y' and
966: G_release = 11) then
967:
968: update fa_transaction_headers
969: set transaction_type_code = 'TRANSFER IN/VOID',
970: transaction_subtype = decode(l_transaction_type_code,
971: 'RECLASS',l_transaction_subtype,
972: transaction_subtype)
977: l_transaction_type_code := 'TRANSFER IN';
978: end if;
979:
980: -- insert new row with transaction type associated with this transaction
981: FA_TRANSACTION_HEADERS_PKG.INSERT_ROW(
982: X_Rowid => l_rowid,
983: X_Transaction_Header_Id => l_txn_head_id,
984: X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
985: X_Asset_Id => p_asset_hdr_rec.asset_id,
1344:
1345: exit when prior_period_tfr_tax_books%notfound;
1346:
1347: select TRANSACTION_DATE_ENTERED into trx_date_entered from
1348: fa_transaction_headers where transaction_header_id = l_trx_id;
1349: if (trx_date_entered < l_tax_cal_period_open_date)
1350: then
1351: l_tax_flag:= 0;
1352: