14: X_Last_Updated_By NUMBER,
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:
83: X_Date_Ineffective DATE DEFAULT NULL,
84: X_Transaction_Header_Id_In NUMBER,
85: X_Transaction_Header_Id_Out NUMBER DEFAULT NULL,
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
140: X_Last_Updated_By NUMBER DEFAULT NULL,
141: X_Last_Update_Login NUMBER DEFAULT NULL,
142: X_Return_Status OUT NOCOPY BOOLEAN,
143: X_Calling_Fn VARCHAR2
144: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
145:
146: BEGIN
147:
148: If x_rowid is null then
259:
260: PROCEDURE Delete_Row(X_Rowid VARCHAR2 DEFAULT NULL,
261: X_Asset_Id NUMBER DEFAULT NULL,
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;
296: END Delete_Row;
297:
298: PROCEDURE Reactivate_Row(X_Transaction_Header_Id_Out NUMBER,
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,