APPS.CSI_COUNTER_PROPERTIES_PKG dependencies on CSI_COUNTER_PROPERTIES_B

Line 49: SELECT CSI_COUNTER_PROPERTIES_B_S.nextval

45: ,p_DESCRIPTION VARCHAR2
46: ) IS
47:
48: CURSOR C1 IS
49: SELECT CSI_COUNTER_PROPERTIES_B_S.nextval
50: FROM dual;
51: BEGIN
52: IF (px_COUNTER_PROPERTY_ID IS NULL) OR (px_COUNTER_PROPERTY_ID = FND_API.G_MISS_NUM) THEN
53: OPEN C1;

Line 58: INSERT INTO CSI_COUNTER_PROPERTIES_B(

54: FETCH C1 INTO px_COUNTER_PROPERTY_ID;
55: CLOSE C1;
56: END IF;
57:
58: INSERT INTO CSI_COUNTER_PROPERTIES_B(
59: COUNTER_PROPERTY_ID
60: ,COUNTER_ID
61: ,PROPERTY_DATA_TYPE
62: ,IS_NULLABLE

Line 210: UPDATE CSI_COUNTER_PROPERTIES_B

206: ,p_NAME VARCHAR2
207: ,p_DESCRIPTION VARCHAR2
208: ) IS
209: BEGIN
210: UPDATE CSI_COUNTER_PROPERTIES_B
211: SET
212: COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
213: ,PROPERTY_DATA_TYPE = decode(p_PROPERTY_DATA_TYPE, NULL, PROPERTY_DATA_TYPE, FND_API.G_MISS_CHAR, NULL, p_PROPERTY_DATA_TYPE)
214: ,IS_NULLABLE = decode(p_IS_NULLABLE, NULL, IS_NULLABLE, FND_API.G_MISS_CHAR, NULL, p_IS_NULLABLE)

Line 311: FROM CSI_COUNTER_PROPERTIES_B

307: ) IS
308:
309: CURSOR C1 IS
310: SELECT *
311: FROM CSI_COUNTER_PROPERTIES_B
312: WHERE COUNTER_PROPERTY_ID = p_COUNTER_PROPERTY_ID
313: FOR UPDATE of COUNTER_PROPERTY_ID NOWAIT;
314: Recinfo C1%ROWTYPE;
315:

Line 362: DELETE FROM CSI_COUNTER_PROPERTIES_B

358: PROCEDURE Delete_Row(
359: p_COUNTER_PROPERTY_ID NUMBER
360: ) IS
361: BEGIN
362: DELETE FROM CSI_COUNTER_PROPERTIES_B
363: WHERE COUNTER_PROPERTY_ID = p_COUNTER_PROPERTY_ID;
364: IF (SQL%NOTFOUND) then
365: RAISE NO_DATA_FOUND;
366: END IF;

Line 373: FROM CSI_COUNTER_PROPERTIES_B b

369: PROCEDURE add_language IS
370: BEGIN
371: DELETE FROM CSI_COUNTER_PROPERTIES_TL t
372: WHERE NOT EXISTS (SELECT NULL
373: FROM CSI_COUNTER_PROPERTIES_B b
374: WHERE b.COUNTER_PROPERTY_ID = t.COUNTER_PROPERTY_ID);
375:
376: UPDATE CSI_COUNTER_PROPERTIES_TL t
377: SET (name,description) = (SELECT b.name,