APPS.CSI_COUNTERS_PKG dependencies on CSI_COUNTERS_B

Line 89: SELECT CSI_COUNTERS_B_S.nextval

85: ,p_COMMENTS VARCHAR2
86: ) IS
87:
88: CURSOR C1 IS
89: SELECT CSI_COUNTERS_B_S.nextval
90: FROM sys.dual;
91: BEGIN
92: IF (px_COUNTER_ID IS NULL) OR (px_COUNTER_ID = FND_API.G_MISS_NUM) then
93: OPEN C1;

Line 98: INSERT INTO CSI_COUNTERS_B(

94: FETCH C1 INTO px_COUNTER_ID;
95: CLOSE C1;
96: END IF;
97:
98: INSERT INTO CSI_COUNTERS_B(
99: COUNTER_ID
100: ,GROUP_ID
101: ,COUNTER_TYPE
102: ,INITIAL_READING

Line 367: UPDATE CSI_COUNTERS_B

363: ,p_COMMENTS VARCHAR2
364:
365: ) IS
366: BEGIN
367: UPDATE CSI_COUNTERS_B
368: SET GROUP_ID = decode(p_GROUP_ID, NULL, GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID)
369: ,COUNTER_TYPE = decode(p_COUNTER_TYPE, NULL, COUNTER_TYPE, FND_API.G_MISS_CHAR, NULL, p_COUNTER_TYPE)
370: ,INITIAL_READING = decode(p_INITIAL_READING, NULL, INITIAL_READING, FND_API.G_MISS_NUM, NULL, p_INITIAL_READING)
371: ,INITIAL_READING_DATE = decode(To_Char(p_INITIAL_READING_DATE,'dd-mon-yyyy'), NULL, INITIAL_READING_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_INITIAL_READING_DATE)

Line 464: DELETE FROM CSI_COUNTERS_B

460: END Update_Row;
461:
462: PROCEDURE Delete_Row(p_COUNTER_ID NUMBER) IS
463: BEGIN
464: DELETE FROM CSI_COUNTERS_B
465: WHERE COUNTER_ID = p_COUNTER_ID;
466: IF (SQL%NOTFOUND) then
467: RAISE NO_DATA_FOUND;
468: END IF;

Line 554: FROM CSI_COUNTERS_B

550: ) IS
551:
552: CURSOR C1 IS
553: SELECT *
554: FROM CSI_COUNTERS_B
555: WHERE COUNTER_ID = p_COUNTER_ID
556: FOR UPDATE of COUNTER_ID NOWAIT;
557: Recinfo C1%ROWTYPE;
558:

Line 607: FROM csi_counters_b b

603: PROCEDURE add_language IS
604: BEGIN
605: DELETE FROM csi_counters_tl t
606: WHERE NOT EXISTS (SELECT NULL
607: FROM csi_counters_b b
608: WHERE b.counter_id = t.counter_id);
609:
610: UPDATE csi_counters_tl t
611: SET (name,description) = (SELECT b.name,