APPS.FA_IMPAIRMENT_DELETE_PVT dependencies on FA_TRANSACTION_HEADERS

Line 164: update fa_transaction_headers

160:
161: if G_release = 11 then
162: --Bug# 6766637 to update TRANSACTION_TYPE_CODE to ADDITION for period of addition.
163: forall i in 1..t_thid.count
164: update fa_transaction_headers
165: set transaction_type_code ='ADDITION'
166: where transaction_header_id = (
167: select transaction_header_id_in
168: from fa_mc_books

Line 266: update fa_transaction_headers

262:
263: --Bug# 6766637 to update TRANSACTION_TYPE_CODE to ADDITION for period of addition.
264: if G_release = 11 then
265: forall i in 1..t_thid.count
266: update fa_transaction_headers
267: set transaction_type_code='ADDITION'
268: where transaction_header_id in(
269: select transaction_header_id_in
270: from fa_books

Line 284: delete from fa_transaction_headers

280: and book_type_code = p_book_type_code
281: and transaction_header_id_out = t_thid(i);
282:
283: FORALL i in 1..t_thid.count
284: delete from fa_transaction_headers
285: where transaction_header_id = t_thid(i);
286: end if;
287:
288: FORALL i in 1..t_thid.count

Line 436: fa_debug_pkg.add(l_calling_fn, 'Updating event id in : ', 'fa_transaction_headers',p_log_level_rec => p_log_level_rec);

432: from xla_events_int_gt;
433:
434:
435: if (p_log_level_rec.statement_level) then
436: fa_debug_pkg.add(l_calling_fn, 'Updating event id in : ', 'fa_transaction_headers',p_log_level_rec => p_log_level_rec);
437: end if;
438:
439: FORALL i in 1..l_thid.count
440: UPDATE FA_TRANSACTION_HEADERS

Line 440: UPDATE FA_TRANSACTION_HEADERS

436: fa_debug_pkg.add(l_calling_fn, 'Updating event id in : ', 'fa_transaction_headers',p_log_level_rec => p_log_level_rec);
437: end if;
438:
439: FORALL i in 1..l_thid.count
440: UPDATE FA_TRANSACTION_HEADERS
441: SET event_id = l_event_id_tbl(i)
442: WHERE TRANSACTION_HEADER_ID = l_thid(i)
443: AND BOOK_TYPE_CODE = p_book_type_code;
444:

Line 1111: from fa_transaction_headers

1107: BEGIN
1108:
1109: select event_id
1110: into l_event_id
1111: from fa_transaction_headers
1112: where asset_id = p_asset_id
1113: and book_type_code = p_book_type_code
1114: and transaction_header_id = p_thid;
1115:

Line 1186: delete from fa_transaction_headers

1182: where asset_id = p_asset_id
1183: and book_type_code = p_book_type_code
1184: and transaction_header_id_out = p_thid;
1185:
1186: delete from fa_transaction_headers
1187: where transaction_header_id = p_thid;
1188:
1189: elsif (l_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED) then
1190: if (p_log_level_rec.statement_level) then

Line 1196: UPDATE FA_TRANSACTION_HEADERS

1192: end if;
1193:
1194: if (p_mrc_sob_type_code = 'R') then
1195:
1196: UPDATE FA_TRANSACTION_HEADERS
1197: SET ATTRIBUTE15 = ATTRIBUTE15
1198: WHERE ASSET_ID = p_asset_id
1199: AND BOOK_TYPE_CODE = p_book_type_code
1200: AND TRANSACTION_TYPE_CODE = 'ADJUSTMENT'

Line 1207: INSERT INTO FA_TRANSACTION_HEADERS(

1203: AND CALLING_INTERFACE = 'FAPIMP'
1204: AND MASS_TRANSACTION_ID = p_request_id
1205: RETURNING TRANSACTION_HEADER_ID INTO l_thid;
1206: else
1207: INSERT INTO FA_TRANSACTION_HEADERS(
1208: TRANSACTION_HEADER_ID
1209: , BOOK_TYPE_CODE
1210: , ASSET_ID
1211: , TRANSACTION_TYPE_CODE

Line 1222: FA_TRANSACTION_HEADERS_S.NEXTVAL

1218: , AMORTIZATION_START_DATE
1219: , CALLING_INTERFACE
1220: , MASS_TRANSACTION_ID
1221: ) VALUES (
1222: FA_TRANSACTION_HEADERS_S.NEXTVAL
1223: , p_book_type_code
1224: , p_asset_id
1225: , 'ADJUSTMENT' /*This must be some new transaction */
1226: , l_period_rec.calendar_period_open_date /* need to modify to populate correct who info */

Line 1259: update fa_transaction_headers

1255: if (p_log_level_rec.statement_level) then
1256: fa_debug_pkg.add(l_calling_fn, 'rolled back IMPAIRMENT event id', l_rev_event_id,p_log_level_rec => p_log_level_rec);
1257: end if;
1258:
1259: update fa_transaction_headers
1260: set event_id = l_rev_event_id
1261: where transaction_header_id = l_thid;
1262:
1263: if (p_log_level_rec.statement_level) then