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.5 2005/07/25 09:59:17 yyoon 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 default null) 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'

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

Line 92: FROM fa_asset_history

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

Line 150: UPDATE fa_asset_history

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

Line 196: UPDATE fa_asset_history

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

Line 249: calling_fn => 'fa_asset_history_pkg.update_row'

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

Line 270: DELETE FROM fa_asset_history

266: X_Calling_Fn VARCHAR2,
267: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
268: BEGIN
269: if X_Rowid is not null then
270: DELETE FROM fa_asset_history
271: WHERE rowid = X_Rowid;
272: elsif X_Transaction_Header_Id_In is not null then
273: DELETE FROM fa_asset_history
274: WHERE asset_id = X_asset_id

Line 273: DELETE FROM fa_asset_history

269: if X_Rowid is not null then
270: DELETE FROM fa_asset_history
271: WHERE rowid = X_Rowid;
272: elsif X_Transaction_Header_Id_In is not null then
273: DELETE FROM fa_asset_history
274: WHERE asset_id = X_asset_id
275: AND transaction_header_id_in = X_Transaction_Header_Id_In;
276: elsif X_Asset_Id is not null then
277: DELETE FROM fa_asset_history

Line 277: DELETE FROM fa_asset_history

273: DELETE FROM fa_asset_history
274: WHERE asset_id = X_asset_id
275: AND transaction_header_id_in = X_Transaction_Header_Id_In;
276: elsif X_Asset_Id is not null then
277: DELETE FROM fa_asset_history
278: WHERE asset_id = X_Asset_Id;
279: else
280: -- print error message
281: null;

Line 291: calling_fn => 'fa_asset_history_pkg.delete_row'

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

Line 310: UPDATE fa_asset_history

306: X_Calling_Fn VARCHAR2,
307: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
308: BEGIN
309:
310: UPDATE fa_asset_history
311: set Transaction_Header_Id_Out = null,
312: date_ineffective = null
313: where asset_id = X_asset_id
314: and Transaction_Header_Id_Out = X_Transaction_Header_Id_Out;

Line 328: END FA_ASSET_HISTORY_PKG;

324: CALLING_FN => X_Calling_Fn
325: ,p_log_level_rec => p_log_level_rec);
326: END Reactivate_Row;
327:
328: END FA_ASSET_HISTORY_PKG;