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_RETIREMENTS

Line 1622: select fa_retirements_s.nextval

1618: select fa_transaction_headers_s.nextval
1619: into l_trans_rec.transaction_header_id
1620: from dual;
1621:
1622: select fa_retirements_s.nextval
1623: into l_asset_retire_rec.retirement_id
1624: from dual;
1625: /*Bug#8289173 - end*/
1626:

Line 2891: fa_debug_pkg.add(l_calling_fn, 'do fa_retirements_pkg.insert_row', '', p_log_level_rec => p_log_level_rec);

2887: fa_debug_pkg.add(l_calling_fn, '++ l_asset_retire_rec.status', l_asset_retire_rec.status, p_log_level_rec => p_log_level_rec);
2888: end if;
2889:
2890: if p_log_level_rec.statement_level then
2891: fa_debug_pkg.add(l_calling_fn, 'do fa_retirements_pkg.insert_row', '', p_log_level_rec => p_log_level_rec);
2892: fa_debug_pkg.add(l_calling_fn, 'retirement_id: ', l_asset_retire_rec.retirement_id, p_log_level_rec => p_log_level_rec);
2893: fa_debug_pkg.add(l_calling_fn, 'asset_id: ', l_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);
2894: fa_debug_pkg.add(l_calling_fn, 'book: ', l_asset_hdr_rec.book_type_code, p_log_level_rec => p_log_level_rec);
2895: fa_debug_pkg.add(l_calling_fn, 'cost_retired: ', l_asset_retire_rec.cost_retired, p_log_level_rec => p_log_level_rec);

Line 2898: fa_retirements_pkg.insert_row

2894: fa_debug_pkg.add(l_calling_fn, 'book: ', l_asset_hdr_rec.book_type_code, p_log_level_rec => p_log_level_rec);
2895: fa_debug_pkg.add(l_calling_fn, 'cost_retired: ', l_asset_retire_rec.cost_retired, p_log_level_rec => p_log_level_rec);
2896: end if;
2897:
2898: fa_retirements_pkg.insert_row
2899: (x_rowid => l_asset_retire_rec.detail_info.row_id,
2900: X_Retirement_Id => l_asset_retire_rec.retirement_id,
2901: X_Book_Type_Code => l_asset_hdr_rec.book_type_code,
2902: X_Asset_Id => l_asset_hdr_rec.asset_id,

Line 3605: from fa_retirements

3601:
3602: -- to get the new retirement_id for the retrieved tax book
3603: select retirement_id
3604: into lv_asset_retire_rec.retirement_id
3605: from fa_retirements
3606: where asset_id=lv_asset_hdr_rec.asset_id
3607: and book_type_code=l_tax_book_tbl(l_tax_index)
3608: and status = 'PENDING';
3609:

Line 4120: fa_retirements ret

4116: BEGIN
4117: SELECT prev.units
4118: INTO l_old_units
4119: FROM fa_asset_history prev,
4120: fa_retirements ret
4121: WHERE prev.asset_id = l_asset_hdr_rec.asset_id
4122: AND prev.transaction_header_id_out = ret.transaction_header_id_in
4123: AND ret.retirement_id = l_asset_retire_rec.retirement_id;
4124: EXCEPTION

Line 4195: FA_RETIREMENTS_PKG.DELETE_ROW

4191: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4192:
4193: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.DELETE_ROW', '', p_log_level_rec => p_log_level_rec); end if;
4194: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'ROW: ', l_asset_retire_rec.detail_info.row_id, p_log_level_rec => p_log_level_rec); end if;
4195: FA_RETIREMENTS_PKG.DELETE_ROW
4196: (X_Rowid => l_asset_retire_rec.detail_info.row_id,
4197: X_mrc_sob_type_code => p_mrc_sob_type_code,
4198: X_set_of_books_id => l_asset_hdr_rec.set_of_books_id,
4199: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

Line 4353: fa_debug_pkg.add(l_calling_fn, 'FA_RETIREMENTS_PKG.DELETE_ROW', '', p_log_level_rec => p_log_level_rec);

4349: X_set_of_books_id => l_asset_hdr_rec.set_of_books_id,
4350: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4351:
4352: if p_log_level_rec.statement_level then
4353: fa_debug_pkg.add(l_calling_fn, 'FA_RETIREMENTS_PKG.DELETE_ROW', '', p_log_level_rec => p_log_level_rec);
4354: fa_debug_pkg.add(l_calling_fn, 'ROW: ', l_asset_retire_rec.detail_info.row_id, p_log_level_rec => p_log_level_rec);
4355: fa_debug_pkg.add(l_calling_fn, 'retirement_id: ', l_asset_retire_rec.retirement_id, p_log_level_rec => p_log_level_rec);
4356: end if;
4357: FA_RETIREMENTS_PKG.DELETE_ROW

Line 4357: FA_RETIREMENTS_PKG.DELETE_ROW

4353: fa_debug_pkg.add(l_calling_fn, 'FA_RETIREMENTS_PKG.DELETE_ROW', '', p_log_level_rec => p_log_level_rec);
4354: fa_debug_pkg.add(l_calling_fn, 'ROW: ', l_asset_retire_rec.detail_info.row_id, p_log_level_rec => p_log_level_rec);
4355: fa_debug_pkg.add(l_calling_fn, 'retirement_id: ', l_asset_retire_rec.retirement_id, p_log_level_rec => p_log_level_rec);
4356: end if;
4357: FA_RETIREMENTS_PKG.DELETE_ROW
4358: (X_Rowid => l_asset_retire_rec.detail_info.row_id,
4359: X_mrc_sob_type_code => p_mrc_sob_type_code,
4360: X_set_of_books_id => l_asset_hdr_rec.set_of_books_id,
4361: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

Line 4846: from fa_retirements

4842: lv_trans_rec.transaction_header_id := null;
4843:
4844: select max(retirement_id)
4845: into lv_asset_retire_rec.retirement_id
4846: from fa_retirements
4847: where asset_id=l_asset_hdr_rec.asset_id
4848: and book_type_code=lv_asset_hdr_rec.book_type_code;
4849:
4850: if g_log_level_rec.statement_level then

Line 5731: fa_debug_pkg.add(l_calling_fn, 'do fa_retirements_pkg.update_row', '', p_log_level_rec => p_log_level_rec);

5727:
5728: end if; -- reporting_flag
5729:
5730: if p_log_level_rec.statement_level then
5731: fa_debug_pkg.add(l_calling_fn, 'do fa_retirements_pkg.update_row', '', p_log_level_rec => p_log_level_rec);
5732: fa_debug_pkg.add(l_calling_fn, 'retirement_id: ', l_asset_retire_rec.Retirement_Id, p_log_level_rec => p_log_level_rec);
5733: end if;
5734:
5735: -- ? just for now

Line 5739: FA_RETIREMENTS_PKG.UPDATE_ROW (

5735: -- ? just for now
5736: -- l_asset_retire_rec.detail_info := null;
5737:
5738:
5739: FA_RETIREMENTS_PKG.UPDATE_ROW (
5740: X_Rowid => l_asset_retire_rec.detail_info.row_id,
5741: X_Retirement_Id => l_asset_retire_rec.Retirement_Id,
5742: X_Book_Type_Code => l_asset_hdr_rec.Book_Type_Code,
5743: X_Asset_Id => l_asset_hdr_rec.Asset_Id,

Line 6099: from fa_retirements

6095:
6096: -- to get the new retirement_id for the retrieved tax book
6097: select retirement_id
6098: into lv_asset_retire_rec.retirement_id
6099: from fa_retirements
6100: where asset_id=lv_asset_hdr_rec.asset_id
6101: and book_type_code=l_tax_book_tbl(l_tax_index)
6102: and status = 'REINSTATE';
6103:

Line 6540: FA_RETIREMENTS_PKG.UPDATE_ROW(

6536: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
6537:
6538: end if; -- reporting_flag
6539:
6540: FA_RETIREMENTS_PKG.UPDATE_ROW(
6541: X_Rowid => l_asset_retire_rec.detail_info.row_id,
6542: X_Retirement_Id => l_asset_retire_rec.Retirement_Id,
6543: X_Book_Type_Code => l_asset_retire_rec.detail_info.Book_Type_Code,
6544: X_Asset_Id => l_asset_retire_rec.detail_info.Asset_Id,

Line 7469: fa_retirements_val.toggle_retire_button('UNDO RETIRE');

7465:
7466: /***** ? Need to investigate the difference between PARTIAL and PENDING in forms code
7467:
7468: elsif (:retire.status = 'PARTIAL') then
7469: fa_retirements_val.toggle_retire_button('UNDO RETIRE');
7470: set_retire_fields('OFF');
7471: --
7472: elsif (:retire.status = 'PENDING') then
7473: fa_retirements_val.toggle_retire_button('UNDO RETIRE');

Line 7473: fa_retirements_val.toggle_retire_button('UNDO RETIRE');

7469: fa_retirements_val.toggle_retire_button('UNDO RETIRE');
7470: set_retire_fields('OFF');
7471: --
7472: elsif (:retire.status = 'PENDING') then
7473: fa_retirements_val.toggle_retire_button('UNDO RETIRE');
7474: set_retire_fields('ON');
7475: --
7476: elsif (:retire.status = 'REINSTATE') then
7477: fa_retirements_val.toggle_retire_button('UNDO REINSTATE');

Line 7477: fa_retirements_val.toggle_retire_button('UNDO REINSTATE');

7473: fa_retirements_val.toggle_retire_button('UNDO RETIRE');
7474: set_retire_fields('ON');
7475: --
7476: elsif (:retire.status = 'REINSTATE') then
7477: fa_retirements_val.toggle_retire_button('UNDO REINSTATE');
7478: set_retire_fields('OFF');
7479:
7480: ***/
7481: