APPS.FA_CIP_PVT dependencies on FA_TRANSACTION_HEADERS

Line 99: select fa_transaction_headers_s.nextval

95:
96: -- SLA uptake
97: -- need the thid before calc engine
98: if (p_mrc_sob_type_code <> 'R') then
99: select fa_transaction_headers_s.nextval
100: into px_trans_rec.transaction_header_id
101: from dual;
102: end if;
103:

Line 278: from fa_transaction_headers

274: select event_id,
275: transaction_header_id
276: into g_cap_event_id,
277: g_cap_thid
278: from fa_transaction_headers
279: where asset_id = p_asset_hdr_rec.asset_id
280: and book_type_code = p_asset_hdr_rec.book_type_code
281: and transaction_type_code = 'ADDITION';
282:

Line 359: update fa_transaction_headers

355: g_cap_thid
356: ,p_log_level_rec => p_log_level_rec);
357: end if;
358:
359: update fa_transaction_headers
360: set event_id = NULL
361: where transaction_header_id = g_cap_thid;
362:
363: end if;

Line 371: FA_TRANSACTION_HEADERS_PKG.Insert_Row

367: 'calling trx insert_row',''
368: ,p_log_level_rec => p_log_level_rec);
369: end if;
370:
371: FA_TRANSACTION_HEADERS_PKG.Insert_Row
372: (X_Rowid => l_rowid,
373: X_Transaction_Header_Id => px_trans_rec.transaction_header_id,
374: X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
375: X_Asset_Id => p_asset_hdr_rec.asset_id,

Line 651: FA_TRANSACTION_HEADERS_PKG.Update_Trx_Type

647: ,p_log_level_rec => p_log_level_rec);
648: end if;
649:
650: -- SLA: keeping this
651: FA_TRANSACTION_HEADERS_PKG.Update_Trx_Type
652: (X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
653: X_Asset_Id => p_asset_hdr_rec.asset_id,
654: X_Transaction_Type_Code => 'ADDITION',
655: X_New_Transaction_Type => 'ADDITION/VOID',

Line 965: from fa_transaction_headers th_add,

961: end if;
962:
963: select count(*)
964: into l_count
965: from fa_transaction_headers th_add,
966: fa_transaction_headers th_other
967: where th_add.asset_id = p_asset_hdr_rec.asset_id
968: and th_add.book_type_code = p_asset_hdr_rec.book_type_code
969: and th_add.transaction_type_code = 'ADDITION'

Line 966: fa_transaction_headers th_other

962:
963: select count(*)
964: into l_count
965: from fa_transaction_headers th_add,
966: fa_transaction_headers th_other
967: where th_add.asset_id = p_asset_hdr_rec.asset_id
968: and th_add.book_type_code = p_asset_hdr_rec.book_type_code
969: and th_add.transaction_type_code = 'ADDITION'
970: and th_other.asset_id = p_asset_hdr_rec.asset_id