APPS.CSI_SOURCE_IB_TYPES_PKG dependencies on CSI_SOURCE_IB_TYPES

Line 1: PACKAGE BODY CSI_SOURCE_IB_TYPES_PKG as

1: PACKAGE BODY CSI_SOURCE_IB_TYPES_PKG as
2: /* $Header: csitsitb.pls 115.3 2002/11/12 00:23:29 rmamidip noship $ */
3: -- Start of Comments
4: -- Package name : CSI_SOURCE_IB_TYPES_PKG
5: -- Purpose :

Line 4: -- Package name : CSI_SOURCE_IB_TYPES_PKG

1: PACKAGE BODY CSI_SOURCE_IB_TYPES_PKG as
2: /* $Header: csitsitb.pls 115.3 2002/11/12 00:23:29 rmamidip noship $ */
3: -- Start of Comments
4: -- Package name : CSI_SOURCE_IB_TYPES_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_SOURCE_IB_TYPES_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitsitb.pls';
13:
14: PROCEDURE Insert_Row(
15: p_TRANSACTION_TYPE_ID NUMBER,

Line 28: INSERT INTO CSI_SOURCE_IB_TYPES(

24: OPEN C2;
25: FETCH C2 INTO px_SUB_TYPE_ID;
26: CLOSE C2;
27: End If;
28: INSERT INTO CSI_SOURCE_IB_TYPES(
29: TRANSACTION_TYPE_ID,
30: SUB_TYPE_ID,
31: DEFAULT_FLAG,
32: UPDATE_IB_FLAG

Line 48: Update CSI_SOURCE_IB_TYPES

44: p_UPDATE_IB_FLAG VARCHAR2)
45:
46: IS
47: BEGIN
48: Update CSI_SOURCE_IB_TYPES
49: SET
50: SUB_TYPE_ID = decode( p_SUB_TYPE_ID, FND_API.G_MISS_NUM, SUB_TYPE_ID, p_SUB_TYPE_ID),
51: DEFAULT_FLAG = decode( p_DEFAULT_FLAG, FND_API.G_MISS_CHAR, DEFAULT_FLAG, p_DEFAULT_FLAG),
52: UPDATE_IB_FLAG = decode( p_UPDATE_IB_FLAG, FND_API.G_MISS_CHAR, UPDATE_IB_FLAG, p_UPDATE_IB_FLAG)

Line 64: DELETE FROM CSI_SOURCE_IB_TYPES

60: PROCEDURE Delete_Row(
61: p_SUB_TYPE_ID NUMBER)
62: IS
63: BEGIN
64: DELETE FROM CSI_SOURCE_IB_TYPES
65: WHERE SUB_TYPE_ID = p_SUB_TYPE_ID;
66: If (SQL%NOTFOUND) then
67: RAISE NO_DATA_FOUND;
68: End If;

Line 80: FROM CSI_SOURCE_IB_TYPES

76:
77: IS
78: CURSOR C IS
79: SELECT *
80: FROM CSI_SOURCE_IB_TYPES
81: WHERE SUB_TYPE_ID = p_SUB_TYPE_ID
82: FOR UPDATE of SUB_TYPE_ID NOWAIT;
83: Recinfo C%ROWTYPE;
84: BEGIN

Line 112: End CSI_SOURCE_IB_TYPES_PKG;

108: APP_EXCEPTION.RAISE_EXCEPTION;
109: End If;
110: END Lock_Row;
111:
112: End CSI_SOURCE_IB_TYPES_PKG;