eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_RETIREMENT_PUB dependencies on FA_TRANSACTION_HEADERS

Line 1353: from fa_transaction_headers

1349:
1350: -- added this for bug 3684222
1351: select MAX(transaction_date_entered)
1352: into l_latest_reval_date
1353: from fa_transaction_headers
1354: where asset_id = l_asset_hdr_rec.asset_id
1355: and book_type_code = l_asset_hdr_rec.book_type_code
1356: and transaction_type_code in ('REVALUATION'
1357: );

Line 1458: select fa_transaction_headers_s.nextval

1454: l_asset_retire_rec.cost_of_removal := 0;
1455: end if;
1456:
1457: -- Pop the transaction_header_id for the RETIREMENT row
1458: select fa_transaction_headers_s.nextval
1459: into l_trans_rec.transaction_header_id
1460: from dual;
1461:
1462: /* Bug# 4370014: Direct fetch for THID, RETID */

Line 1828: SELECT fa_transaction_headers_s.nextval

1824:
1825: -- Due lue that came in in l_trans_to 3188851, need to insert CR row for members before calling dist api.
1826:
1827: --Need this for selection_thid
1828: SELECT fa_transaction_headers_s.nextval
1829: into l_dist_trans_rec.transaction_header_id /* 3513319 */
1830: FROM dual;
1831:
1832: if (l_asset_fin_rec.group_asset_id is not null) and

Line 2282: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_transaction_headers_pkg.insert_row', '', p_log_level_rec); end if;

2278: g_token1 := null;
2279: raise FND_API.G_EXC_ERROR;
2280: end if;
2281:
2282: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_transaction_headers_pkg.insert_row', '', p_log_level_rec); end if;
2283: fa_transaction_headers_pkg.insert_row
2284: (x_rowid => l_th_rowid,
2285: x_transaction_header_id => l_trans_rec.transaction_header_id,
2286: x_book_type_code => l_asset_hdr_rec.book_type_code,

Line 2283: fa_transaction_headers_pkg.insert_row

2279: raise FND_API.G_EXC_ERROR;
2280: end if;
2281:
2282: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_transaction_headers_pkg.insert_row', '', p_log_level_rec); end if;
2283: fa_transaction_headers_pkg.insert_row
2284: (x_rowid => l_th_rowid,
2285: x_transaction_header_id => l_trans_rec.transaction_header_id,
2286: x_book_type_code => l_asset_hdr_rec.book_type_code,
2287: x_asset_id => l_asset_hdr_rec.asset_id,

Line 3682: from fa_transaction_headers

3678: * Check to see previous retirement was source line retirement or not
3679: */
3680: cursor c_inv_trx_id (c_thid number)is
3681: select invoice_transaction_id
3682: from fa_transaction_headers
3683: where transaction_header_id = c_thid;
3684:
3685: cursor get_cost_before_ret(c_asset_id number, c_book varchar2, c_ret_id number, c_reporting_flag varchar2) is
3686: select cost

Line 4004: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_TRANSACTION_HEADERS_PKG.DELETE_ROW', '', p_log_level_rec); end if;

4000: ,p_log_level_rec => p_log_level_rec);
4001:
4002: end if; -- if corporate
4003:
4004: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_TRANSACTION_HEADERS_PKG.DELETE_ROW', '', p_log_level_rec); end if;
4005: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW -- delete PARTIAL RETIREMENT row
4006: (X_Transaction_Header_Id =>
4007: l_asset_retire_rec.detail_info.transaction_header_id_in,
4008: X_Calling_Fn => l_calling_fn);

Line 4005: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW -- delete PARTIAL RETIREMENT row

4001:
4002: end if; -- if corporate
4003:
4004: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_TRANSACTION_HEADERS_PKG.DELETE_ROW', '', p_log_level_rec); end if;
4005: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW -- delete PARTIAL RETIREMENT row
4006: (X_Transaction_Header_Id =>
4007: l_asset_retire_rec.detail_info.transaction_header_id_in,
4008: X_Calling_Fn => l_calling_fn);
4009:

Line 4010: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_TRANSACTION_HEADERS_PKG.DELETE_ROW -- delete TRANSFER OUT row', '', p_log_level_rec); end if;

4006: (X_Transaction_Header_Id =>
4007: l_asset_retire_rec.detail_info.transaction_header_id_in,
4008: X_Calling_Fn => l_calling_fn);
4009:
4010: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_TRANSACTION_HEADERS_PKG.DELETE_ROW -- delete TRANSFER OUT row', '', p_log_level_rec); end if;
4011: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW -- delete TRANSFER OUT row
4012: (X_Transaction_Header_Id =>
4013: transfer_id,
4014: X_Calling_Fn => l_calling_fn);

Line 4011: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW -- delete TRANSFER OUT row

4007: l_asset_retire_rec.detail_info.transaction_header_id_in,
4008: X_Calling_Fn => l_calling_fn);
4009:
4010: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_TRANSACTION_HEADERS_PKG.DELETE_ROW -- delete TRANSFER OUT row', '', p_log_level_rec); end if;
4011: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW -- delete TRANSFER OUT row
4012: (X_Transaction_Header_Id =>
4013: transfer_id,
4014: X_Calling_Fn => l_calling_fn);
4015:

Line 4093: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_TRANSACTION_HEADERS_PKG.DELETE_ROW', '', p_log_level_rec); end if;

4089: X_Calling_Fn => l_calling_fn
4090: ,p_log_level_rec => p_log_level_rec);
4091: end if; -- if corporate
4092:
4093: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_TRANSACTION_HEADERS_PKG.DELETE_ROW', '', p_log_level_rec); end if;
4094: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW
4095: (X_Transaction_Header_Id =>
4096: l_asset_retire_rec.detail_info.transaction_header_id_in,
4097: X_Calling_Fn => l_calling_fn

Line 4094: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW

4090: ,p_log_level_rec => p_log_level_rec);
4091: end if; -- if corporate
4092:
4093: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_TRANSACTION_HEADERS_PKG.DELETE_ROW', '', p_log_level_rec); end if;
4094: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW
4095: (X_Transaction_Header_Id =>
4096: l_asset_retire_rec.detail_info.transaction_header_id_in,
4097: X_Calling_Fn => l_calling_fn
4098: ,p_log_level_rec => p_log_level_rec);

Line 4190: ,fa_transaction_headers th

4186:
4187: cursor tde_cursor is
4188: select max(th.transaction_date_entered)
4189: from fa_deprn_periods dp
4190: ,fa_transaction_headers th
4191: ,fa_books bk
4192: where dp.book_type_code = l_asset_hdr_rec.book_type_code
4193: and dp.period_close_date is null
4194: and bk.book_type_code = dp.book_type_code

Line 4794: select fa_transaction_headers_s.nextval

4790:
4791: end if; -- date_retired
4792:
4793: -- Pop the transaction_header_id for the REINSTATEMENT row
4794: select fa_transaction_headers_s.nextval
4795: into l_trans_rec.transaction_header_id
4796: from dual;
4797:
4798: -- SLA UPTAKE

Line 5238: * Getting FA_TRANSACTION_HEADERS.INVOICE_TRANSACTION_ID

5234:
5235: l_status boolean := TRUE;
5236:
5237: /*
5238: * Getting FA_TRANSACTION_HEADERS.INVOICE_TRANSACTION_ID
5239: */
5240: cursor c_inv_trx_id (c_thid number) is
5241: select invoice_transaction_id
5242: from fa_transaction_headers

Line 5242: from fa_transaction_headers

5238: * Getting FA_TRANSACTION_HEADERS.INVOICE_TRANSACTION_ID
5239: */
5240: cursor c_inv_trx_id (c_thid number) is
5241: select invoice_transaction_id
5242: from fa_transaction_headers
5243: where transaction_header_id = c_thid;
5244:
5245: l_invoice_transaction_id number; -- Local variable to store return value of c_inv_trx_id;
5246:

Line 5336: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_transaction_headers_pkg.insert_row', '', p_log_level_rec); end if;

5332: p_log_level_rec => p_log_level_rec) then
5333: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5334: end if;
5335:
5336: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_transaction_headers_pkg.insert_row', '', p_log_level_rec); end if;
5337:
5338: fa_transaction_headers_pkg.insert_row
5339: (x_rowid => l_rowid,
5340: x_transaction_header_id => l_trans_rec.transaction_header_id,

Line 5338: fa_transaction_headers_pkg.insert_row

5334: end if;
5335:
5336: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'do fa_transaction_headers_pkg.insert_row', '', p_log_level_rec); end if;
5337:
5338: fa_transaction_headers_pkg.insert_row
5339: (x_rowid => l_rowid,
5340: x_transaction_header_id => l_trans_rec.transaction_header_id,
5341: x_book_type_code => l_asset_hdr_rec.book_type_code,
5342: x_asset_id => l_asset_hdr_rec.asset_id,

Line 6076: from fa_transaction_headers

6072: * Check to see previous retirement was source line retirement or not
6073: */
6074: cursor c_inv_trx_id (c_thid number)is
6075: select invoice_transaction_id
6076: from fa_transaction_headers
6077: where transaction_header_id = c_thid;
6078:
6079: l_invoice_transaction_id number; -- Local variable to store return value of c_inv_trx_id
6080:

Line 6186: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW

6182:
6183: if (p_mrc_sob_type_code <> 'R') then
6184: -- ? check this parameter again
6185: -- delete transaction_headers row only for primary book
6186: FA_TRANSACTION_HEADERS_PKG.DELETE_ROW
6187: (X_Transaction_Header_Id => l_asset_retire_rec.detail_info.transaction_header_id_out,
6188: X_Calling_Fn => l_calling_fn
6189: ,p_log_level_rec => p_log_level_rec);
6190:

Line 6319: from fa_transaction_headers th

6315: l_latest_ret_thid number := -1;
6316:
6317: CURSOR c_last_grp_reclass IS
6318: select th.transaction_date_entered
6319: from fa_transaction_headers th
6320: , fa_trx_references tr
6321: where th.asset_id = p_asset_hdr_rec.asset_id
6322: and th.book_type_code = p_asset_hdr_rec.book_type_code
6323: and th.transaction_header_id = tr.member_transaction_header_id

Line 6821: FROM fa_transaction_headers

6817: end if;
6818:
6819: SELECT nvl(max(transaction_header_id),0)
6820: INTO l_latest_ret_thid
6821: FROM fa_transaction_headers
6822: WHERE asset_id = l_asset_hdr_rec.asset_id
6823: AND book_type_code = l_asset_hdr_rec.book_type_code
6824: AND transaction_key = 'R'
6825: AND transaction_type_code||'' like '%RETIREMENT';

Line 7084: FA_TRANSACTION_HEADERS_PKG.UPDATE_ROW(

7080: end if;
7081: raise FND_API.G_EXC_UNEXPECTED_ERROR;
7082: end if;
7083:
7084: FA_TRANSACTION_HEADERS_PKG.UPDATE_ROW(
7085: X_Rowid => p_rowid,
7086: X_Invoice_Transaction_Id => l_inv_trans_rec.invoice_transaction_id,
7087: X_Calling_Fn => l_calling_fn
7088: ,p_log_level_rec => p_log_level_rec);