APPS.FA_REVALUATION_PVT dependencies on FA_TRANSACTION_HEADERS

Line 73: SELECT fa_transaction_headers_s.NEXTVAL

69: -- insert transaction headers
70: IF (p_mrc_sob_type_code <> 'R')
71: THEN
72: -- we need the thid first before reval engine or do we
73: SELECT fa_transaction_headers_s.NEXTVAL
74: INTO px_trans_rec.transaction_header_id
75: FROM DUAL;
76:
77: -- Bug 15877517 : Reinitialize who_info as well

Line 239: fa_transaction_headers_pkg.insert_row

235: end if;
236: /*Secondary Changes End
237: ==================================================================*/
238:
239: fa_transaction_headers_pkg.insert_row
240: (x_rowid => l_th_rowid,
241: x_transaction_header_id => px_trans_rec.transaction_header_id,
242: x_book_type_code => px_asset_hdr_rec.book_type_code,
243: x_asset_id => px_asset_hdr_rec.asset_id,

Line 3726: from fa_transaction_headers

3722: CURSOR c_get_new_thid IS
3723: select transaction_header_id
3724: , date_effective
3725: , last_updated_by
3726: from fa_transaction_headers
3727: where asset_id = p_asset_hdr_rec.asset_id
3728: and book_type_code = p_asset_hdr_rec.book_type_code
3729: and date_effective between l_period_rec.period_open_date
3730: and nvl(l_period_rec.period_close_date, sysdate)

Line 3788: from fa_transaction_headers

3784: -- we need to find out if the reval transaction is deleted or not
3785:
3786: select count(1)
3787: into l_reval_count
3788: from fa_transaction_headers
3789: where transaction_header_id = p_thid;
3790:
3791: if l_reval_count = 0 then /* Event and Reval transaction is deleted */
3792: l_event_status := XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED;

Line 3858: delete from fa_transaction_headers

3854: where asset_id = p_asset_hdr_rec.asset_id
3855: and book_type_code = p_asset_hdr_rec.book_type_code
3856: and transaction_header_id_out = p_thid;
3857:
3858: delete from fa_transaction_headers
3859: where transaction_header_id = p_thid;
3860:
3861: else
3862:

Line 3900: SELECT fa_transaction_headers_s.nextval

3896:
3897: -- create rollback event and transaction
3898: if p_mrc_sob_type_code <> 'R' then
3899:
3900: SELECT fa_transaction_headers_s.nextval
3901: INTO l_trans_rec.transaction_header_id
3902: FROM DUAL;
3903:
3904: --

Line 3976: INSERT INTO FA_TRANSACTION_HEADERS(

3972: fa_debug_pkg.add(l_calling_fn,'Inserting new thid: '
3973: , l_trans_rec.transaction_header_id, p_log_level_rec => p_log_level_rec);
3974: end if;
3975:
3976: INSERT INTO FA_TRANSACTION_HEADERS(
3977: TRANSACTION_HEADER_ID
3978: , BOOK_TYPE_CODE
3979: , ASSET_ID
3980: , TRANSACTION_TYPE_CODE

Line 4052: from fa_transaction_headers

4048: , MASS_TRANSACTION_ID
4049: , MEMBER_TRANSACTION_HEADER_ID
4050: , TRX_REFERENCE_ID
4051: , l_trans_rec.event_id -- EVENT_ID
4052: from fa_transaction_headers
4053: where asset_id = p_asset_hdr_rec.asset_id
4054: and book_type_code = p_asset_hdr_rec.book_type_code
4055: and transaction_header_id = p_thid
4056: ;