[Home] [Help]
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 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:
85: X_Date_Ineffective DATE DEFAULT NULL,
86: X_Transaction_Header_Id_In NUMBER,
87: X_Transaction_Header_Id_Out NUMBER DEFAULT NULL,
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
141: X_Last_Updated_By NUMBER DEFAULT NULL,
142: X_Last_Update_Login NUMBER DEFAULT NULL,
143: X_Return_Status OUT NOCOPY BOOLEAN,
144: X_Calling_Fn VARCHAR2,
145: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
146:
147: BEGIN
148:
149: If x_rowid is null then
263: PROCEDURE Delete_Row(X_Rowid VARCHAR2 DEFAULT NULL,
264: X_Asset_Id NUMBER DEFAULT NULL,
265: X_Transaction_Header_Id_In NUMBER DEFAULT NULL,
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;
303:
304: PROCEDURE Reactivate_Row(X_Transaction_Header_Id_Out NUMBER,
305: X_asset_id NUMBER,
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,