DBA Data[Home] [Help]

APPS.FA_ASSET_HISTORY_PKG dependencies on FA_API_TYPES

Line 18: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

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:

Line 87: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

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

Line 144: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

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

Line 263: X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

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;

Line 300: X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

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,