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.15.12010000.1 2008/07/28 13:25:06 appldev ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Book_Type_Code VARCHAR2,

Line 125: CURSOR C_bk IS SELECT rowid FROM fa_books

121: X_mrc_sob_type_code VARCHAR2 DEFAULT 'P',
122: X_Return_Status OUT NOCOPY BOOLEAN,
123: X_Calling_Fn VARCHAR2,
124: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
125: CURSOR C_bk IS SELECT rowid FROM fa_books
126: WHERE transaction_header_id_in = X_Transaction_Header_Id_In;
127:
128: CURSOR C_bk_mc IS SELECT rowid FROM fa_books_mrc_v
129: WHERE transaction_header_id_in = X_Transaction_Header_Id_In;

Line 128: CURSOR C_bk_mc IS SELECT rowid FROM fa_books_mrc_v

124: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
125: CURSOR C_bk IS SELECT rowid FROM fa_books
126: WHERE transaction_header_id_in = X_Transaction_Header_Id_In;
127:
128: CURSOR C_bk_mc IS SELECT rowid FROM fa_books_mrc_v
129: WHERE transaction_header_id_in = X_Transaction_Header_Id_In;
130:
131: BEGIN
132:

Line 134: INSERT INTO fa_books_mrc_v(

130:
131: BEGIN
132:
133: if (X_mrc_sob_type_code = 'R') then
134: INSERT INTO fa_books_mrc_v(
135: book_type_code,
136: asset_id,
137: date_placed_in_service,
138: date_effective,

Line 374: INSERT INTO fa_books(

370: CLOSE C_bk_mc;
371:
372: else
373:
374: INSERT INTO fa_books(
375: book_type_code,
376: asset_id,
377: date_placed_in_service,
378: date_effective,

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

619: exception
620: when others then
621: if (X_Calling_Fn = 'fa_unp_dep_pkg.on_insert') then
622: FA_STANDARD_PKG.RAISE_ERROR(
623: CALLED_FN => 'fa_books_pkg.insert_row',
624: CALLING_FN => X_Calling_Fn
625: ,p_log_level_rec => p_log_level_rec);
626: X_Return_Status := FALSE;
627: else

Line 629: calling_fn => 'fa_books_pkg.insert_row'

625: ,p_log_level_rec => p_log_level_rec);
626: X_Return_Status := FALSE;
627: else
628: fa_srvr_msg.add_sql_error(
629: calling_fn => 'fa_books_pkg.insert_row'
630: ,p_log_level_rec => p_log_level_rec);
631: X_Return_Status := FALSE;
632: raise; -- BUG# 1979676
633: end if;

Line 776: FROM fa_books

772: original_deprn_start_date,
773: old_adjusted_cost,
774: formula_factor,
775: eofy_formula_factor
776: FROM fa_books
777: WHERE rowid = X_Rowid
778: FOR UPDATE of Transaction_Header_Id_In NOWAIT;
779: Recinfo C%ROWTYPE;
780:

Line 1009: UPDATE fa_books_mrc_v

1005: BEGIN
1006:
1007: if (X_mrc_sob_type_code = 'R') then
1008: if X_Rowid is not null then
1009: UPDATE fa_books_mrc_v
1010: SET
1011: book_type_code = decode(X_Book_Type_Code,
1012: NULL, book_type_code,
1013: FND_API.G_MISS_CHAR, NULL,

Line 1340: UPDATE fa_books_mrc_v

1336: FND_API.G_MISS_CHAR, NULL,
1337: X_Formula_Factor)
1338: WHERE rowid = X_Rowid;
1339: else
1340: UPDATE fa_books_mrc_v
1341: SET
1342: book_type_code = decode(X_Book_Type_Code,
1343: NULL, book_type_code,
1344: FND_API.G_MISS_CHAR, NULL,

Line 1675: UPDATE fa_books

1671: AND transaction_header_id_out is null;
1672: end if;
1673: else
1674: if X_Rowid is not null then
1675: UPDATE fa_books
1676: SET
1677: book_type_code = decode(X_Book_Type_Code,
1678: NULL, book_type_code,
1679: FND_API.G_MISS_CHAR, NULL,

Line 2002: UPDATE fa_books

1998: FND_API.G_MISS_CHAR, NULL,
1999: X_terminal_gain_loss_flag)
2000: WHERE rowid = X_Rowid;
2001: else
2002: UPDATE fa_books
2003: SET
2004: book_type_code = decode(X_Book_Type_Code,
2005: NULL, book_type_code,
2006: FND_API.G_MISS_CHAR, NULL,

Line 2340: calling_fn => 'fa_books_pkg.update_row'

2336:
2337: exception
2338: when others then
2339: fa_srvr_msg.add_sql_error(
2340: calling_fn => 'fa_books_pkg.update_row'
2341: ,p_log_level_rec => p_log_level_rec);
2342: raise;
2343: END Update_Row;
2344:

Line 2355: DELETE FROM fa_books_mrc_v

2351: BEGIN
2352:
2353: if (X_mrc_sob_type_code = 'R') then
2354: if X_Rowid is not null then
2355: DELETE FROM fa_books_mrc_v
2356: WHERE rowid = X_Rowid;
2357: elsif X_Transaction_Header_Id_In is not null then
2358: DELETE FROM fa_books_mrc_v
2359: WHERE transaction_header_id_in = X_Transaction_Header_Id_In;

Line 2358: DELETE FROM fa_books_mrc_v

2354: if X_Rowid is not null then
2355: DELETE FROM fa_books_mrc_v
2356: WHERE rowid = X_Rowid;
2357: elsif X_Transaction_Header_Id_In is not null then
2358: DELETE FROM fa_books_mrc_v
2359: WHERE transaction_header_id_in = X_Transaction_Header_Id_In;
2360: elsif X_Asset_Id is not null then
2361: DELETE FROM fa_books_mrc_v
2362: WHERE asset_id = X_Asset_Id;

Line 2361: DELETE FROM fa_books_mrc_v

2357: elsif X_Transaction_Header_Id_In is not null then
2358: DELETE FROM fa_books_mrc_v
2359: WHERE transaction_header_id_in = X_Transaction_Header_Id_In;
2360: elsif X_Asset_Id is not null then
2361: DELETE FROM fa_books_mrc_v
2362: WHERE asset_id = X_Asset_Id;
2363: else
2364: -- print some error message
2365: null;

Line 2369: DELETE FROM fa_books

2365: null;
2366: end if;
2367: else
2368: if X_Rowid is not null then
2369: DELETE FROM fa_books
2370: WHERE rowid = X_Rowid;
2371: elsif X_Transaction_Header_Id_In is not null then
2372: DELETE FROM fa_books
2373: WHERE transaction_header_id_in = X_Transaction_Header_Id_In;

Line 2372: DELETE FROM fa_books

2368: if X_Rowid is not null then
2369: DELETE FROM fa_books
2370: WHERE rowid = X_Rowid;
2371: elsif X_Transaction_Header_Id_In is not null then
2372: DELETE FROM fa_books
2373: WHERE transaction_header_id_in = X_Transaction_Header_Id_In;
2374: elsif X_Asset_Id is not null then
2375: DELETE FROM fa_books
2376: WHERE asset_id = X_Asset_Id;

Line 2375: DELETE FROM fa_books

2371: elsif X_Transaction_Header_Id_In is not null then
2372: DELETE FROM fa_books
2373: WHERE transaction_header_id_in = X_Transaction_Header_Id_In;
2374: elsif X_Asset_Id is not null then
2375: DELETE FROM fa_books
2376: WHERE asset_id = X_Asset_Id;
2377: else
2378: -- print some error message
2379: null;

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

2386:
2387: exception
2388: when others then
2389: FA_STANDARD_PKG.RAISE_ERROR(
2390: CALLED_FN => 'fa_books_pkg.delete_row',
2391: CALLING_FN => X_Calling_Fn
2392: ,p_log_level_rec => p_log_level_rec);
2393: END Delete_Row;
2394:

Line 2403: UPDATE fa_books_mrc_v

2399:
2400: BEGIN
2401:
2402: if (X_mrc_sob_type_code = 'R') then
2403: UPDATE fa_books_mrc_v
2404: SET period_counter_fully_retired = null,
2405: date_ineffective = null,
2406: transaction_header_id_out = null,
2407: retirement_id = null

Line 2410: UPDATE fa_books

2406: transaction_header_id_out = null,
2407: retirement_id = null
2408: WHERE transaction_header_id_out = X_Transaction_Header_Id_Out;
2409: else
2410: UPDATE fa_books
2411: SET period_counter_fully_retired = null,
2412: date_ineffective = null,
2413: transaction_header_id_out = null,
2414: retirement_id = null

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

2421:
2422: exception
2423: when others then
2424: FA_STANDARD_PKG.RAISE_ERROR(
2425: CALLED_FN => 'fa_books_pkg.reactivate_row',
2426: CALLING_FN => X_Calling_Fn
2427: ,p_log_level_rec => p_log_level_rec);
2428: END Reactivate_Row;
2429:

Line 2442: UPDATE fa_books_mrc_v

2438:
2439: BEGIN
2440:
2441: if (X_mrc_sob_type_code = 'R') then
2442: UPDATE fa_books_mrc_v
2443: SET date_ineffective = X_date_ineffective,
2444: last_update_date = X_date_ineffective,
2445: transaction_header_id_out = X_transaction_header_id_out
2446: WHERE asset_id = X_Asset_Id

Line 2450: UPDATE fa_books

2446: WHERE asset_id = X_Asset_Id
2447: AND book_type_code = X_book_type_code
2448: AND transaction_header_id_out is null;
2449: else
2450: UPDATE fa_books
2451: SET date_ineffective = X_date_ineffective,
2452: last_update_date = X_date_ineffective,
2453: transaction_header_id_out = X_transaction_header_id_out
2454: WHERE asset_id = X_Asset_Id

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

2462:
2463: exception
2464: when others then
2465: FA_STANDARD_PKG.RAISE_ERROR(
2466: CALLED_FN => 'fa_books_pkg.reactivate_row',
2467: CALLING_FN => X_Calling_Fn
2468: ,p_log_level_rec => p_log_level_rec);
2469: END Deactivate_Row;
2470:

Line 2472: END FA_BOOKS_PKG;

2468: ,p_log_level_rec => p_log_level_rec);
2469: END Deactivate_Row;
2470:
2471:
2472: END FA_BOOKS_PKG;