[Home] [Help]
PACKAGE: APPS.FA_ASSET_HISTORY_PKG
Source
1 PACKAGE FA_ASSET_HISTORY_PKG AUTHID CURRENT_USER as
2 /* $Header: faxiahs.pls 120.4 2009/03/27 01:54:53 bridgway ship $ */
3 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
4 X_Asset_Id NUMBER,
5 X_Category_Id NUMBER,
6 X_Asset_Type VARCHAR2,
7 X_Units NUMBER,
8 X_Date_Effective DATE,
9 X_Date_Ineffective DATE DEFAULT NULL,
10 X_Transaction_Header_Id_In NUMBER,
11 X_Transaction_Header_Id_Out NUMBER DEFAULT NULL,
12 X_Last_Update_Date DATE,
13 X_Last_Updated_By NUMBER,
14 X_Last_Update_Login NUMBER DEFAULT NULL,
15 X_Return_Status OUT NOCOPY BOOLEAN,
16 X_Calling_Fn VARCHAR2
17 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
18 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
19 X_Asset_Id NUMBER,
20 X_Category_Id NUMBER,
21 X_Asset_Type VARCHAR2,
22 X_Units NUMBER,
23 X_Date_Effective DATE,
24 X_Date_Ineffective DATE DEFAULT NULL,
25 X_Transaction_Header_Id_In NUMBER,
26 X_Transaction_Header_Id_Out NUMBER DEFAULT NULL,
27 X_Calling_Fn VARCHAR2
28 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
29
30 PROCEDURE Update_Row(X_Rowid VARCHAR2 DEFAULT NULL,
31 X_Asset_Id NUMBER DEFAULT NULL,
32 X_Category_Id NUMBER DEFAULT NULL,
33 X_Asset_Type VARCHAR2 DEFAULT NULL,
34 X_Units NUMBER DEFAULT NULL,
35 X_Date_Effective DATE DEFAULT NULL,
36 X_Date_Ineffective DATE DEFAULT NULL,
37 X_Transaction_Header_Id_In NUMBER DEFAULT NULL,
38 X_Transaction_Header_Id_Out NUMBER DEFAULT NULL,
39 X_Last_Update_Date DATE DEFAULT NULL,
40 X_Last_Updated_By NUMBER DEFAULT NULL,
41 X_Last_Update_Login NUMBER DEFAULT NULL,
42 X_Return_Status OUT NOCOPY BOOLEAN,
43 X_Calling_Fn VARCHAR2
44 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
45
46 PROCEDURE Delete_Row(X_Rowid VARCHAR2 DEFAULT NULL,
47 X_Asset_Id NUMBER DEFAULT NULL,
48 X_Transaction_Header_Id_In NUMBER DEFAULT NULL,
49 X_Calling_Fn VARCHAR2
50 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
51
52 PROCEDURE Reactivate_Row(X_Transaction_Header_Id_Out NUMBER,
53 X_asset_id NUMBER,
54 X_Calling_Fn VARCHAR2
55 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
56
57 END FA_ASSET_HISTORY_PKG;