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_BOOKS_PKG dependencies on FA_BOOKS

Line 1: PACKAGE BODY FA_BOOKS_PKG as

1: PACKAGE BODY FA_BOOKS_PKG as
2: /* $Header: faxibkb.pls 120.20 2009/07/20 08:11:40 glchen ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Book_Type_Code VARCHAR2,

Line 138: CURSOR C_bk IS SELECT rowid FROM fa_books

134: X_prior_basic_rate NUMBER DEFAULT NULL,
135: X_prior_adjusted_rate NUMBER DEFAULT NULL, -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy End
136: X_period_counter_fully_extend NUMBER DEFAULT NULL -- Bug 7576755
137: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type ) IS
138: CURSOR C_bk IS SELECT rowid FROM fa_books
139: WHERE transaction_header_id_in = X_Transaction_Header_Id_In;
140:
141: CURSOR C_bk_mc IS SELECT rowid FROM fa_mc_books
142: WHERE transaction_header_id_in = X_Transaction_Header_Id_In

Line 392: INSERT INTO fa_books(

388: CLOSE C_bk_mc;
389:
390: else
391:
392: INSERT INTO fa_books(
393: book_type_code,
394: asset_id,
395: date_placed_in_service,
396: date_effective,

Line 665: CALLED_FN => 'fa_books_pkg.insert_row',

661: exception
662: when others then
663: if (X_Calling_Fn = 'fa_unp_dep_pkg.on_insert') then
664: FA_STANDARD_PKG.RAISE_ERROR(
665: CALLED_FN => 'fa_books_pkg.insert_row',
666: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
667: X_Return_Status := FALSE;
668: else
669: fa_srvr_msg.add_sql_error(

Line 670: calling_fn => 'fa_books_pkg.insert_row', p_log_level_rec => p_log_level_rec);

666: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
667: X_Return_Status := FALSE;
668: else
669: fa_srvr_msg.add_sql_error(
670: calling_fn => 'fa_books_pkg.insert_row', p_log_level_rec => p_log_level_rec);
671: X_Return_Status := FALSE;
672: raise; -- BUG# 1979676
673: end if;
674:

Line 818: FROM fa_books

814: old_adjusted_cost,
815: formula_factor,
816: eofy_formula_factor,
817: cash_generating_unit_id
818: FROM fa_books
819: WHERE rowid = X_Rowid
820: FOR UPDATE of Transaction_Header_Id_In NOWAIT;
821: Recinfo C%ROWTYPE;
822:

Line 1742: UPDATE fa_books

1738: AND set_of_books_id = X_set_of_books_id;
1739: end if;
1740: else
1741: if X_Rowid is not null then
1742: UPDATE fa_books
1743: SET
1744: book_type_code = decode(X_Book_Type_Code,
1745: NULL, book_type_code,
1746: FND_API.G_MISS_CHAR, NULL,

Line 2073: UPDATE fa_books

2069: FND_API.G_MISS_NUM, NULL,
2070: X_terminal_gain_loss_flag)
2071: WHERE rowid = X_Rowid;
2072: else
2073: UPDATE fa_books
2074: SET
2075: book_type_code = decode(X_Book_Type_Code,
2076: NULL, book_type_code,
2077: FND_API.G_MISS_CHAR, NULL,

Line 2457: calling_fn => 'fa_books_pkg.update_row', p_log_level_rec => p_log_level_rec);

2453:
2454: exception
2455: when others then
2456: fa_srvr_msg.add_sql_error(
2457: calling_fn => 'fa_books_pkg.update_row', p_log_level_rec => p_log_level_rec);
2458: raise;
2459: END Update_Row;
2460:
2461: PROCEDURE Delete_Row(X_Rowid VARCHAR2 DEFAULT NULL,

Line 2487: DELETE FROM fa_books

2483: null;
2484: end if;
2485: else
2486: if X_Rowid is not null then
2487: DELETE FROM fa_books
2488: WHERE rowid = X_Rowid;
2489: elsif X_Transaction_Header_Id_In is not null then
2490: DELETE FROM fa_books
2491: WHERE transaction_header_id_in = X_Transaction_Header_Id_In;

Line 2490: DELETE FROM fa_books

2486: if X_Rowid is not null then
2487: DELETE FROM fa_books
2488: WHERE rowid = X_Rowid;
2489: elsif X_Transaction_Header_Id_In is not null then
2490: DELETE FROM fa_books
2491: WHERE transaction_header_id_in = X_Transaction_Header_Id_In;
2492: elsif X_Asset_Id is not null then
2493: DELETE FROM fa_books
2494: WHERE asset_id = X_Asset_Id;

Line 2493: DELETE FROM fa_books

2489: elsif X_Transaction_Header_Id_In is not null then
2490: DELETE FROM fa_books
2491: WHERE transaction_header_id_in = X_Transaction_Header_Id_In;
2492: elsif X_Asset_Id is not null then
2493: DELETE FROM fa_books
2494: WHERE asset_id = X_Asset_Id;
2495: else
2496: -- print some error message
2497: null;

Line 2508: CALLED_FN => 'fa_books_pkg.delete_row',

2504:
2505: exception
2506: when others then
2507: FA_STANDARD_PKG.RAISE_ERROR(
2508: CALLED_FN => 'fa_books_pkg.delete_row',
2509: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
2510: END Delete_Row;
2511:
2512: PROCEDURE Reactivate_Row(X_Transaction_Header_Id_Out NUMBER,

Line 2528: UPDATE fa_books

2524: retirement_id = null
2525: WHERE transaction_header_id_out = X_Transaction_Header_Id_Out
2526: AND set_of_books_id = X_set_of_books_id;
2527: else
2528: UPDATE fa_books
2529: SET period_counter_fully_retired = null,
2530: date_ineffective = null,
2531: transaction_header_id_out = null,
2532: retirement_id = null

Line 2543: CALLED_FN => 'fa_books_pkg.reactivate_row',

2539:
2540: exception
2541: when others then
2542: FA_STANDARD_PKG.RAISE_ERROR(
2543: CALLED_FN => 'fa_books_pkg.reactivate_row',
2544: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
2545: END Reactivate_Row;
2546:
2547:

Line 2568: UPDATE fa_books

2564: AND book_type_code = X_book_type_code
2565: AND transaction_header_id_out is null
2566: AND set_of_books_id = X_set_of_books_id;
2567: else
2568: UPDATE fa_books
2569: SET date_ineffective = X_date_ineffective,
2570: last_update_date = X_date_ineffective,
2571: transaction_header_id_out = X_transaction_header_id_out
2572: WHERE asset_id = X_Asset_Id

Line 2584: CALLED_FN => 'fa_books_pkg.reactivate_row',

2580:
2581: exception
2582: when others then
2583: FA_STANDARD_PKG.RAISE_ERROR(
2584: CALLED_FN => 'fa_books_pkg.reactivate_row',
2585: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
2586: END Deactivate_Row;
2587:
2588:

Line 2589: END FA_BOOKS_PKG;

2585: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
2586: END Deactivate_Row;
2587:
2588:
2589: END FA_BOOKS_PKG;