APPS.CSI_TXN_TYPES_PKG dependencies on CSI_SOURCE_IB_TYPES

Line 74: INSERT INTO CSI_SOURCE_IB_TYPES(

70: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
71: 'N'
72: );
73:
74: INSERT INTO CSI_SOURCE_IB_TYPES(
75: TRANSACTION_TYPE_ID,
76: SUB_TYPE_ID,
77: DEFAULT_FLAG,
78: UPDATE_IB_FLAG,

Line 140: Update CSI_SOURCE_IB_TYPES

136: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
137: --OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
138: where TRANSACTION_TYPE_ID = p_TRANSACTION_TYPE_ID;
139:
140: Update CSI_SOURCE_IB_TYPES
141: SET
142: DEFAULT_FLAG = decode( p_DEFAULT_FLAG, FND_API.G_MISS_CHAR, DEFAULT_FLAG, p_DEFAULT_FLAG),
143: UPDATE_IB_FLAG = decode( p_UPDATE_IB_FLAG, FND_API.G_MISS_CHAR, UPDATE_IB_FLAG, p_UPDATE_IB_FLAG),
144: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

Line 168: DELETE FROM CSI_SOURCE_IB_TYPES

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
170: AND SUB_TYPE_ID = p_SUB_TYPE_ID;
171:
172: If (SQL%NOTFOUND) then

Line 206: FROM CSI_SOURCE_IB_TYPES

202: Recinfo C%ROWTYPE;
203:
204: CURSOR C1 IS
205: SELECT *
206: FROM CSI_SOURCE_IB_TYPES
207: WHERE TRANSACTION_TYPE_ID = p_TRANSACTION_TYPE_ID
208: AND SUB_TYPE_ID = p_SUB_TYPE_ID
209: FOR UPDATE NOWAIT;
210: