APPS.CSI_TXN_TYPES_PKG dependencies on CSI_TXN_TYPES

Line 1: PACKAGE BODY CSI_TXN_TYPES_PKG as

1: PACKAGE BODY CSI_TXN_TYPES_PKG as
2: /* $Header: csittstb.pls 115.8 2002/11/12 00:25:58 rmamidip noship $ */
3: -- Start of Comments
4: -- Package name : CSI_TXN_TYPES_PKG
5: -- Purpose :

Line 4: -- Package name : CSI_TXN_TYPES_PKG

1: PACKAGE BODY CSI_TXN_TYPES_PKG as
2: /* $Header: csittstb.pls 115.8 2002/11/12 00:25:58 rmamidip noship $ */
3: -- Start of Comments
4: -- Package name : CSI_TXN_TYPES_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_TXN_TYPES_PKG';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_TXN_TYPES_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csittstb.pls';
13:
14: PROCEDURE Insert_Row(
15: px_TRANSACTION_TYPE_ID IN OUT NOCOPY NUMBER,

Line 35: CURSOR C2 IS SELECT CSI_TXN_TYPES_S.nextval FROM sys.dual;

31: p_SEEDED_FLAG VARCHAR2
32: )
33:
34: IS
35: CURSOR C2 IS SELECT CSI_TXN_TYPES_S.nextval FROM sys.dual;
36: BEGIN
37: If (px_TRANSACTION_TYPE_ID IS NULL) OR (px_TRANSACTION_TYPE_ID = FND_API.G_MISS_NUM) then
38: OPEN C2;
39: FETCH C2 INTO px_TRANSACTION_TYPE_ID;

Line 42: INSERT INTO CSI_TXN_TYPES(

38: OPEN C2;
39: FETCH C2 INTO px_TRANSACTION_TYPE_ID;
40: CLOSE C2;
41: End If;
42: INSERT INTO CSI_TXN_TYPES(
43: TRANSACTION_TYPE_ID,
44: SOURCE_APPLICATION_ID,
45: SOURCE_TRANSACTION_TYPE,
46: SOURCE_TXN_TYPE_NAME,

Line 123: Update CSI_TXN_TYPES

119:
120:
121: IS
122: BEGIN
123: Update CSI_TXN_TYPES
124: SET
125: SOURCE_APPLICATION_ID = decode( p_SOURCE_APPLICATION_ID, FND_API.G_MISS_NUM, SOURCE_APPLICATION_ID, p_SOURCE_APPLICATION_ID),
126: SOURCE_TRANSACTION_TYPE = decode( p_SOURCE_TRANSACTION_TYPE, FND_API.G_MISS_CHAR, SOURCE_TRANSACTION_TYPE, p_SOURCE_TRANSACTION_TYPE),
127: SOURCE_TXN_TYPE_NAME = decode( p_SOURCE_TXN_TYPE_NAME, FND_API.G_MISS_CHAR, SOURCE_TXN_TYPE_NAME, p_SOURCE_TXN_TYPE_NAME),

Line 165: -- DELETE FROM CSI_TXN_TYPES

161: IS
162: BEGIN
163: /* Commented as the Transaction Type should not be deleted */
164:
165: -- DELETE FROM CSI_TXN_TYPES
166: -- WHERE TRANSACTION_TYPE_ID = p_TRANSACTION_TYPE_ID;
167:
168: DELETE FROM CSI_SOURCE_IB_TYPES
169: WHERE TRANSACTION_TYPE_ID = p_TRANSACTION_TYPE_ID

Line 199: FROM CSI_TXN_TYPES

195:
196: IS
197: CURSOR C IS
198: SELECT *
199: FROM CSI_TXN_TYPES
200: WHERE TRANSACTION_TYPE_ID = p_TRANSACTION_TYPE_ID
201: FOR UPDATE of TRANSACTION_TYPE_ID NOWAIT;
202: Recinfo C%ROWTYPE;
203:

Line 311: End CSI_TXN_TYPES_PKG;

307: End Loop;
308:
309: END Lock_Row;
310:
311: End CSI_TXN_TYPES_PKG;