DBA Data[Home] [Help]

APPS.CSI_GROUPING_PKG dependencies on CS_CSI_COUNTER_GROUPS

Line 56: INSERT INTO CS_CSI_COUNTER_GROUPS(

52: FETCH C1 INTO px_COUNTER_GROUP_ID;
53: CLOSE C1;
54: END IF;
55:
56: INSERT INTO CS_CSI_COUNTER_GROUPS(
57: COUNTER_GROUP_ID
58: ,NAME
59: ,DESCRIPTION
60: ,TEMPLATE_FLAG

Line 172: UPDATE CS_CSI_COUNTER_GROUPS

168: ,p_SOURCE_OBJECT_ID NUMBER
169: ,p_SOURCE_COUNTER_GROUP_ID NUMBER
170: ,p_SECURITY_GROUP_ID NUMBER) IS
171: BEGIN
172: UPDATE CS_CSI_COUNTER_GROUPS
173: SET NAME = decode(p_NAME, NULL, NAME, FND_API.G_MISS_CHAR, NULL, p_NAME)
174: ,DESCRIPTION = decode(p_DESCRIPTION, NULL, DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION)
175: ,TEMPLATE_FLAG = decode(p_TEMPLATE_FLAG, NULL, TEMPLATE_FLAG, FND_API.G_MISS_CHAR, NULL, p_TEMPLATE_FLAG)
176: ,CP_SERVICE_ID = decode(p_CP_SERVICE_ID, NULL, CP_SERVICE_ID, FND_API.G_MISS_NUM, NULL, p_CP_SERVICE_ID)

Line 217: DELETE FROM CS_CSI_COUNTER_GROUPS

213: END Update_Row;
214:
215: PROCEDURE Delete_Row(p_COUNTER_GROUP_ID NUMBER) IS
216: BEGIN
217: DELETE FROM CS_CSI_COUNTER_GROUPS
218: WHERE COUNTER_GROUP_ID = p_COUNTER_GROUP_ID;
219: IF (SQL%NOTFOUND) then
220: RAISE NO_DATA_FOUND;
221: END IF;

Line 264: FROM CS_CSI_COUNTER_GROUPS

260: ,p_SECURITY_GROUP_ID NUMBER) IS
261:
262: CURSOR C1 IS
263: SELECT *
264: FROM CS_CSI_COUNTER_GROUPS
265: WHERE COUNTER_GROUP_ID = p_COUNTER_GROUP_ID
266: FOR UPDATE of COUNTER_GROUP_ID NOWAIT;
267: Recinfo C1%ROWTYPE;
268: BEGIN