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_ASSET_HISTORY_PKG dependencies on FA_ASSET_HISTORY

Line 1: PACKAGE BODY FA_ASSET_HISTORY_PKG as

1: PACKAGE BODY FA_ASSET_HISTORY_PKG as
2: /* $Header: faxiahb.pls 120.6 2009/03/27 01:54:06 bridgway ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Asset_Id NUMBER,

Line 19: CURSOR C IS SELECT rowid FROM fa_asset_history

15: X_Last_Update_Login NUMBER DEFAULT NULL,
16: X_Return_Status OUT NOCOPY BOOLEAN,
17: X_Calling_Fn VARCHAR2
18: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
19: CURSOR C IS SELECT rowid FROM fa_asset_history
20: WHERE asset_id = X_asset_id
21: AND transaction_header_id_in = X_Transaction_Header_Id_In;
22:
23: BEGIN

Line 26: INSERT INTO fa_asset_history

22:
23: BEGIN
24:
25:
26: INSERT INTO fa_asset_history
27: (asset_id,
28: category_id,
29: asset_type,
30: units,

Line 65: calling_fn => 'fa_asset_history_pkg.insert_row', p_log_level_rec => p_log_level_rec);

61:
62: exception
63: when others then
64: fa_srvr_msg.add_sql_error(
65: calling_fn => 'fa_asset_history_pkg.insert_row', p_log_level_rec => p_log_level_rec);
66: raise;
67:
68: /* Commented out for better error handling after using trx engine
69: FA_STANDARD_PKG.RAISE_ERROR(

Line 90: FROM fa_asset_history

86: X_Calling_Fn VARCHAR2
87: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
88: CURSOR C IS
89: SELECT *
90: FROM fa_asset_history
91: WHERE rowid = X_Rowid
92: FOR UPDATE of Transaction_Header_Id_In NOWAIT;
93: Recinfo C%ROWTYPE;
94:

Line 149: UPDATE fa_asset_history

145:
146: BEGIN
147:
148: If x_rowid is null then
149: UPDATE fa_asset_history
150: SET asset_id = decode(X_Asset_Id,
151: NULL, asset_id,
152: FND_API.G_MISS_NUM, null,
153: X_Asset_Id),

Line 195: UPDATE fa_asset_history

191: WHERE asset_id = X_asset_id and
192: date_ineffective is null;
193:
194: else
195: UPDATE fa_asset_history
196: SET asset_id = decode(X_Asset_Id,
197: NULL, asset_id,
198: FND_API.G_MISS_NUM, null,
199: X_Asset_Id),

Line 248: calling_fn => 'fa_asset_history_pkg.update_row', p_log_level_rec => p_log_level_rec);

244:
245: exception
246: when others then
247: fa_srvr_msg.add_sql_error(
248: calling_fn => 'fa_asset_history_pkg.update_row', p_log_level_rec => p_log_level_rec);
249: raise;
250:
251: /* Commented out for better error handling after using trx engine
252: when others then

Line 266: DELETE FROM fa_asset_history

262: X_Transaction_Header_Id_In NUMBER DEFAULT NULL,
263: X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
264: BEGIN
265: if X_Rowid is not null then
266: DELETE FROM fa_asset_history
267: WHERE rowid = X_Rowid;
268: elsif X_Transaction_Header_Id_In is not null then
269: DELETE FROM fa_asset_history
270: WHERE asset_id = X_asset_id

Line 269: DELETE FROM fa_asset_history

265: if X_Rowid is not null then
266: DELETE FROM fa_asset_history
267: WHERE rowid = X_Rowid;
268: elsif X_Transaction_Header_Id_In is not null then
269: DELETE FROM fa_asset_history
270: WHERE asset_id = X_asset_id
271: AND transaction_header_id_in = X_Transaction_Header_Id_In;
272: elsif X_Asset_Id is not null then
273: DELETE FROM fa_asset_history

Line 273: DELETE FROM fa_asset_history

269: DELETE FROM fa_asset_history
270: WHERE asset_id = X_asset_id
271: AND transaction_header_id_in = X_Transaction_Header_Id_In;
272: elsif X_Asset_Id is not null then
273: DELETE FROM fa_asset_history
274: WHERE asset_id = X_Asset_Id;
275: else
276: -- print error message
277: null;

Line 287: calling_fn => 'fa_asset_history_pkg.delete_row', p_log_level_rec => p_log_level_rec);

283:
284: exception
285: when others then
286: fa_srvr_msg.add_sql_error(
287: calling_fn => 'fa_asset_history_pkg.delete_row', p_log_level_rec => p_log_level_rec);
288: raise;
289:
290: /* Commented out for better error handling after using trx engine
291: when others then

Line 303: UPDATE fa_asset_history

299: X_asset_id NUMBER,
300: X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
301: BEGIN
302:
303: UPDATE fa_asset_history
304: set Transaction_Header_Id_Out = null,
305: date_ineffective = null
306: where asset_id = X_asset_id
307: and Transaction_Header_Id_Out = X_Transaction_Header_Id_Out;

Line 320: END FA_ASSET_HISTORY_PKG;

316: CALLED_FN => 'fa_distribution_history_pkg.reactivate_row',
317: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
318: END Reactivate_Row;
319:
320: END FA_ASSET_HISTORY_PKG;