APPS.FA_CIP_PVT dependencies on FA_TRANSACTION_HEADERS

Line 105: select fa_transaction_headers_s.nextval

101:
102: -- SLA uptake
103: -- need the thid before calc engine
104: if (p_mrc_sob_type_code <> 'R') then
105: select fa_transaction_headers_s.nextval
106: into px_trans_rec.transaction_header_id
107: from dual;
108:
109: -- Bug 15877517 : Reinitialize who_info as well

Line 378: from fa_transaction_headers

374:
375: -- fix for 4541467
376: select rowid
377: into l_rowid
378: from fa_transaction_headers
379: where asset_id = p_asset_hdr_rec.asset_id
380: and book_type_code = p_asset_hdr_rec.book_type_code
381: and transaction_type_code = l_old_transaction_type_code;
382:

Line 389: FA_TRANSACTION_HEADERS_PKG.Update_row

385: 'got rowid before trx update_row','', p_log_level_rec => p_log_level_rec);
386: end if;
387:
388:
389: FA_TRANSACTION_HEADERS_PKG.Update_row
390: (X_Rowid => l_rowid,
391: X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
392: X_Asset_Id => p_asset_hdr_rec.asset_id,
393: X_Transaction_Type_Code => px_trans_rec.transaction_type_code,

Line 428: update fa_transaction_headers

424: X_return_status => l_status,
425: X_calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
426:
427: -- Added update for bug 4541467
428: update fa_transaction_headers
429: set transaction_date_entered = px_asset_fin_rec.date_placed_in_service
430: where asset_id = p_asset_hdr_rec.asset_id
431: and book_type_code = p_asset_hdr_rec.book_type_code
432: and transaction_type_code = 'TRANSFER IN';

Line 468: from fa_transaction_headers

464: select event_id,
465: transaction_header_id
466: into g_cap_event_id,
467: g_cap_thid
468: from fa_transaction_headers
469: where asset_id = p_asset_hdr_rec.asset_id
470: and book_type_code = p_asset_hdr_rec.book_type_code
471: and transaction_type_code = 'ADDITION';
472:

Line 543: update fa_transaction_headers

539: g_cap_thid
540: ,p_log_level_rec => p_log_level_rec);
541: end if;
542:
543: update fa_transaction_headers
544: set event_id = NULL
545: where transaction_header_id = g_cap_thid;
546:
547: end if;

Line 554: FA_TRANSACTION_HEADERS_PKG.Insert_Row

550: fa_debug_pkg.add(l_calling_fn,
551: 'calling trx insert_row','', p_log_level_rec => p_log_level_rec);
552: end if;
553:
554: FA_TRANSACTION_HEADERS_PKG.Insert_Row
555: (X_Rowid => l_rowid,
556: X_Transaction_Header_Id => px_trans_rec.transaction_header_id,
557: X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
558: X_Asset_Id => p_asset_hdr_rec.asset_id,

Line 958: FA_TRANSACTION_HEADERS_PKG.Update_Trx_Type

954: fa_debug_pkg.add(l_calling_fn,
955: 'calling th update trx type','', p_log_level_rec => p_log_level_rec);
956: end if;
957:
958: FA_TRANSACTION_HEADERS_PKG.Update_Trx_Type
959: (X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
960: X_Asset_Id => p_asset_hdr_rec.asset_id,
961: X_Transaction_Type_Code => 'ADDITION',
962: X_New_Transaction_Type => 'ADDITION/VOID',

Line 1264: from fa_transaction_headers th_add,

1260: end if;
1261:
1262: select count(*)
1263: into l_count
1264: from fa_transaction_headers th_add,
1265: fa_transaction_headers th_other
1266: where th_add.asset_id = p_asset_hdr_rec.asset_id
1267: and th_add.book_type_code = p_asset_hdr_rec.book_type_code
1268: and th_add.transaction_type_code = 'ADDITION'

Line 1265: fa_transaction_headers th_other

1261:
1262: select count(*)
1263: into l_count
1264: from fa_transaction_headers th_add,
1265: fa_transaction_headers th_other
1266: where th_add.asset_id = p_asset_hdr_rec.asset_id
1267: and th_add.book_type_code = p_asset_hdr_rec.book_type_code
1268: and th_add.transaction_type_code = 'ADDITION'
1269: and th_other.asset_id = p_asset_hdr_rec.asset_id