PACKAGE: APPS.CSI_TXN_TYPES_PKG

Source

1 PACKAGE CSI_TXN_TYPES_PKG AUTHID CURRENT_USER as
2 /* $Header: csittsts.pls 115.6 2002/11/12 00:26:07 rmamidip noship $ */
3 -- Start of Comments
4 -- Package name     : CSI_TXN_TYPES_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Insert_Row(
11           px_TRANSACTION_TYPE_ID   IN OUT NOCOPY NUMBER,
12           p_SOURCE_APPLICATION_ID    NUMBER,
13           p_SOURCE_TRANSACTION_TYPE    VARCHAR2,
14           p_SOURCE_TXN_TYPE_NAME    VARCHAR2,
15           p_DESCRIPTION    VARCHAR2,
16           p_SOURCE_OBJECT_CODE    VARCHAR2,
17           p_IN_OUT_FLAG    VARCHAR2,
18           p_CREATED_BY    NUMBER,
19           p_CREATION_DATE    DATE,
20           p_LAST_UPDATED_BY    NUMBER,
21           p_LAST_UPDATE_DATE    DATE,
22           p_LAST_UPDATE_LOGIN    NUMBER,
23           p_OBJECT_VERSION_NUMBER    NUMBER,
24           p_SUB_TYPE_ID     NUMBER,
25           p_DEFAULT_FLAG    VARCHAR2,
26           p_UPDATE_IB_FLAG    VARCHAR2,
27           p_SEEDED_FLAG       VARCHAR2);
28 
29 PROCEDURE Update_Row(
30           p_TRANSACTION_TYPE_ID    NUMBER,
31           p_SOURCE_APPLICATION_ID    NUMBER,
32           p_SOURCE_TRANSACTION_TYPE    VARCHAR2,
33           p_SOURCE_TXN_TYPE_NAME    VARCHAR2,
34           p_DESCRIPTION    VARCHAR2,
35           p_SOURCE_OBJECT_CODE    VARCHAR2,
36           p_IN_OUT_FLAG    VARCHAR2,
37           p_CREATED_BY    NUMBER,
38           p_CREATION_DATE    DATE,
39           p_LAST_UPDATED_BY    NUMBER,
40           p_LAST_UPDATE_DATE    DATE,
41           p_LAST_UPDATE_LOGIN    NUMBER,
42           p_OBJECT_VERSION_NUMBER    NUMBER,
43           p_SUB_TYPE_ID     NUMBER,
44           p_DEFAULT_FLAG    VARCHAR2,
45           p_UPDATE_IB_FLAG    VARCHAR2);
46 
47 PROCEDURE Lock_Row(
48           p_TRANSACTION_TYPE_ID    NUMBER,
49           p_SOURCE_APPLICATION_ID    NUMBER,
50           p_SOURCE_TRANSACTION_TYPE    VARCHAR2,
51           p_SOURCE_TXN_TYPE_NAME    VARCHAR2,
52           p_DESCRIPTION    VARCHAR2,
53           p_SOURCE_OBJECT_CODE    VARCHAR2,
54           p_IN_OUT_FLAG    VARCHAR2,
55           p_CREATED_BY    NUMBER,
56           p_CREATION_DATE    DATE,
57           p_LAST_UPDATED_BY    NUMBER,
58           p_LAST_UPDATE_DATE    DATE,
59           p_LAST_UPDATE_LOGIN    NUMBER,
60           p_OBJECT_VERSION_NUMBER    NUMBER,
61           p_SUB_TYPE_ID     NUMBER,
62           p_DEFAULT_FLAG    VARCHAR2,
63           p_UPDATE_IB_FLAG    VARCHAR2,
64           p_SEEDED_FLAG       VARCHAR2);
65 
66 
67 PROCEDURE Delete_Row(
68     p_TRANSACTION_TYPE_ID  NUMBER,
69     p_SUB_TYPE_ID     NUMBER);
70 End CSI_TXN_TYPES_PKG;