1 PACKAGE CSP_USG_TRANSACTION_TYPES_PKG AUTHID CURRENT_USER as
2 /* $Header: csptutts.pls 115.0 2003/05/29 18:00:16 sunarasi noship $ */
3 -- Start of Comments
4 -- Package name : CSP_USG_TRANSACTION_TYPES_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE Insert_Row(
11 px_USG_TRANSACTION_TYPE_ID IN OUT NOCOPY NUMBER
12 ,p_LAST_UPDATE_DATE DATE
13 ,p_LAST_UPDATED_BY NUMBER
14 ,p_CREATION_DATE DATE
15 ,p_CREATED_BY NUMBER
16 ,p_LAST_UPDATE_LOGIN NUMBER
17 ,p_FORECAST_RULE_ID NUMBER
18 ,p_TRANSACTION_TYPE_ID NUMBER);
19
20 PROCEDURE Update_Row(
21 p_USG_TRANSACTION_TYPE_ID IN NUMBER
22 ,p_LAST_UPDATE_DATE DATE
23 ,p_LAST_UPDATED_BY NUMBER
24 ,p_CREATION_DATE DATE
25 ,p_CREATED_BY NUMBER
26 ,p_LAST_UPDATE_LOGIN NUMBER
27 ,p_FORECAST_RULE_ID NUMBER
28 ,p_TRANSACTION_TYPE_ID NUMBER);
29
30 PROCEDURE Lock_Row(
31 p_USG_TRANSACTION_TYPE_ID IN NUMBER
32 ,p_LAST_UPDATE_DATE DATE
33 ,p_LAST_UPDATED_BY NUMBER
34 ,p_CREATION_DATE DATE
35 ,p_CREATED_BY NUMBER
36 ,p_LAST_UPDATE_LOGIN NUMBER
37 ,p_FORECAST_RULE_ID NUMBER
38 ,p_TRANSACTION_TYPE_ID NUMBER);
39
40 PROCEDURE Delete_Row(
41 p_USG_TRANSACTION_TYPE_ID NUMBER);
42 End CSP_USG_TRANSACTION_TYPES_PKG;