DBA Data[Home] [Help]

APPS.FA_RETIREMENT_PUB dependencies on FA_RETIREMENTS

Line 1463: select fa_retirements_s.nextval

1459: into l_trans_rec.transaction_header_id
1460: from dual;
1461:
1462: /* Bug# 4370014: Direct fetch for THID, RETID */
1463: select fa_retirements_s.nextval
1464: into l_asset_retire_rec.retirement_id
1465: from dual;
1466:
1467:

Line 2665: fa_debug_pkg.add(l_calling_fn, 'do fa_retirements_pkg.insert_row', '', p_log_level_rec);

2661: ,p_log_level_rec => p_log_level_rec);
2662: end if;
2663:
2664: if g_log_level_rec.statement_level then
2665: fa_debug_pkg.add(l_calling_fn, 'do fa_retirements_pkg.insert_row', '', p_log_level_rec);
2666: fa_debug_pkg.add(l_calling_fn, 'retirement_id: ', l_asset_retire_rec.retirement_id, p_log_level_rec);
2667: fa_debug_pkg.add(l_calling_fn, 'asset_id: ', l_asset_hdr_rec.asset_id, p_log_level_rec);
2668: fa_debug_pkg.add(l_calling_fn, 'book: ', l_asset_hdr_rec.book_type_code, p_log_level_rec);
2669: fa_debug_pkg.add(l_calling_fn, 'cost_retired: ', l_asset_retire_rec.cost_retired, p_log_level_rec);

Line 2672: fa_retirements_pkg.insert_row

2668: fa_debug_pkg.add(l_calling_fn, 'book: ', l_asset_hdr_rec.book_type_code, p_log_level_rec);
2669: fa_debug_pkg.add(l_calling_fn, 'cost_retired: ', l_asset_retire_rec.cost_retired, p_log_level_rec);
2670: end if;
2671:
2672: fa_retirements_pkg.insert_row
2673: (x_rowid => l_asset_retire_rec.detail_info.row_id,
2674: X_Retirement_Id => l_asset_retire_rec.retirement_id,
2675: X_Book_Type_Code => l_asset_hdr_rec.book_type_code,
2676: X_Asset_Id => l_asset_hdr_rec.asset_id,

Line 3333: from fa_retirements

3329:
3330: -- to get the new retirement_id for the retrieved tax book
3331: select retirement_id
3332: into lv_asset_retire_rec.retirement_id
3333: from fa_retirements
3334: where asset_id=lv_asset_hdr_rec.asset_id
3335: and book_type_code=l_tax_book_tbl(l_tax_index)
3336: and status = 'PENDING';
3337:

Line 3908: FA_RETIREMENTS_PKG.DELETE_ROW

3904: fa_debug_pkg.add(l_calling_fn, 'FA_BOOKS_PKG.DELETE_ROW', '', p_log_level_rec);
3905: fa_debug_pkg.add(l_calling_fn, 'ROW: ', l_asset_retire_rec.detail_info.row_id, p_log_level_rec);
3906: end if;
3907:
3908: FA_RETIREMENTS_PKG.DELETE_ROW
3909: (X_Rowid => l_asset_retire_rec.detail_info.row_id,
3910: X_mrc_sob_type_code => p_mrc_sob_type_code,
3911: X_Calling_Fn => l_calling_fn
3912: ,p_log_level_rec => p_log_level_rec);

Line 4072: fa_debug_pkg.add(l_calling_fn, 'FA_RETIREMENTS_PKG.DELETE_ROW', '', p_log_level_rec);

4068: X_Calling_Fn => l_calling_fn
4069: ,p_log_level_rec => p_log_level_rec);
4070:
4071: if g_log_level_rec.statement_level then
4072: fa_debug_pkg.add(l_calling_fn, 'FA_RETIREMENTS_PKG.DELETE_ROW', '', p_log_level_rec);
4073: fa_debug_pkg.add(l_calling_fn, 'ROW: ', l_asset_retire_rec.detail_info.row_id, p_log_level_rec);
4074: fa_debug_pkg.add(l_calling_fn, 'retirement_id: ', l_asset_retire_rec.retirement_id, p_log_level_rec);
4075: end if;
4076: FA_RETIREMENTS_PKG.DELETE_ROW

Line 4076: FA_RETIREMENTS_PKG.DELETE_ROW

4072: fa_debug_pkg.add(l_calling_fn, 'FA_RETIREMENTS_PKG.DELETE_ROW', '', p_log_level_rec);
4073: fa_debug_pkg.add(l_calling_fn, 'ROW: ', l_asset_retire_rec.detail_info.row_id, p_log_level_rec);
4074: fa_debug_pkg.add(l_calling_fn, 'retirement_id: ', l_asset_retire_rec.retirement_id, p_log_level_rec);
4075: end if;
4076: FA_RETIREMENTS_PKG.DELETE_ROW
4077: (X_Rowid => l_asset_retire_rec.detail_info.row_id,
4078: X_mrc_sob_type_code => p_mrc_sob_type_code,
4079: X_Calling_Fn => l_calling_fn
4080: ,p_log_level_rec => p_log_level_rec);

Line 4509: from fa_retirements

4505: lv_trans_rec.transaction_header_id := null;
4506:
4507: select max(retirement_id)
4508: into lv_asset_retire_rec.retirement_id
4509: from fa_retirements
4510: where asset_id=l_asset_hdr_rec.asset_id
4511: and book_type_code=lv_asset_hdr_rec.book_type_code;
4512:
4513: if g_log_level_rec.statement_level then

Line 5384: fa_debug_pkg.add(l_calling_fn, 'do fa_retirements_pkg.update_row', '', p_log_level_rec);

5380:
5381: end if; -- reporting_flag
5382:
5383: if g_log_level_rec.statement_level then
5384: fa_debug_pkg.add(l_calling_fn, 'do fa_retirements_pkg.update_row', '', p_log_level_rec);
5385: fa_debug_pkg.add(l_calling_fn, 'retirement_id: ', l_asset_retire_rec.Retirement_Id, p_log_level_rec);
5386: end if;
5387:
5388: -- ? just for now

Line 5392: FA_RETIREMENTS_PKG.UPDATE_ROW (

5388: -- ? just for now
5389: -- l_asset_retire_rec.detail_info := null;
5390:
5391:
5392: FA_RETIREMENTS_PKG.UPDATE_ROW (
5393: X_Rowid => l_asset_retire_rec.detail_info.row_id,
5394: X_Retirement_Id => l_asset_retire_rec.Retirement_Id,
5395: X_Book_Type_Code => l_asset_hdr_rec.Book_Type_Code,
5396: X_Asset_Id => l_asset_hdr_rec.Asset_Id,

Line 5761: from fa_retirements

5757:
5758: -- to get the new retirement_id for the retrieved tax book
5759: select retirement_id
5760: into lv_asset_retire_rec.retirement_id
5761: from fa_retirements
5762: where asset_id=lv_asset_hdr_rec.asset_id
5763: and book_type_code=l_tax_book_tbl(l_tax_index)
5764: and status = 'REINSTATE';
5765:

Line 6193: FA_RETIREMENTS_PKG.UPDATE_ROW(

6189: ,p_log_level_rec => p_log_level_rec);
6190:
6191: end if; -- reporting_flag
6192:
6193: FA_RETIREMENTS_PKG.UPDATE_ROW(
6194: X_Rowid => l_asset_retire_rec.detail_info.row_id,
6195: X_Retirement_Id => l_asset_retire_rec.Retirement_Id,
6196: X_Book_Type_Code => l_asset_retire_rec.detail_info.Book_Type_Code,
6197: X_Asset_Id => l_asset_retire_rec.detail_info.Asset_Id,

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

6877:
6878: /***** ? Need to investigate the difference between PARTIAL and PENDING in forms code
6879:
6880: elsif (:retire.status = 'PARTIAL') then
6881: fa_retirements_val.toggle_retire_button('UNDO RETIRE');
6882: set_retire_fields('OFF'
6883: ,p_log_level_rec => p_log_level_rec);
6884: --
6885: elsif (:retire.status = 'PENDING') then

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

6882: set_retire_fields('OFF'
6883: ,p_log_level_rec => p_log_level_rec);
6884: --
6885: elsif (:retire.status = 'PENDING') then
6886: fa_retirements_val.toggle_retire_button('UNDO RETIRE');
6887: set_retire_fields('ON'
6888: ,p_log_level_rec => p_log_level_rec);
6889: --
6890: elsif (:retire.status = 'REINSTATE') then

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

6887: set_retire_fields('ON'
6888: ,p_log_level_rec => p_log_level_rec);
6889: --
6890: elsif (:retire.status = 'REINSTATE') then
6891: fa_retirements_val.toggle_retire_button('UNDO REINSTATE');
6892: set_retire_fields('OFF'
6893: ,p_log_level_rec => p_log_level_rec);
6894:
6895: ***/