APPS.CSI_COUNTER_TEMPLATE_PKG dependencies on CSI_COUNTER_TEMPLATE_B

Line 97: INSERT INTO CSI_COUNTER_TEMPLATE_B(

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

Line 361: UPDATE CSI_COUNTER_TEMPLATE_B

357: ,p_DESCRIPTION VARCHAR2
358: ,p_TIME_BASED_MANUAL_ENTRY VARCHAR2
359: ,p_EAM_REQUIRED_FLAG VARCHAR2) IS
360: BEGIN
361: UPDATE CSI_COUNTER_TEMPLATE_B
362: SET GROUP_ID = decode(p_GROUP_ID, NULL, GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID)
363: ,COUNTER_TYPE = decode(p_COUNTER_TYPE, NULL, COUNTER_TYPE, FND_API.G_MISS_CHAR, NULL, p_COUNTER_TYPE)
364: ,INITIAL_READING = decode(p_INITIAL_READING, NULL, INITIAL_READING, FND_API.G_MISS_NUM, NULL, p_INITIAL_READING)
365: ,INITIAL_READING_DATE = decode(p_INITIAL_READING_DATE, NULL, INITIAL_READING_DATE, FND_API.G_MISS_DATE, NULL, p_INITIAL_READING_DATE)

Line 458: DELETE FROM CSI_COUNTER_TEMPLATE_B

454: END Update_Row;
455:
456: PROCEDURE delete_row(p_COUNTER_ID NUMBER) IS
457: BEGIN
458: DELETE FROM CSI_COUNTER_TEMPLATE_B
459: WHERE COUNTER_ID = p_COUNTER_ID;
460: IF (SQL%NOTFOUND) then
461: RAISE NO_DATA_FOUND;
462: END IF;

Line 546: FROM CSI_COUNTER_TEMPLATE_B

542: ,p_EAM_REQUIRED_FLAG VARCHAR2) IS
543:
544: CURSOR C1 IS
545: SELECT *
546: FROM CSI_COUNTER_TEMPLATE_B
547: WHERE COUNTER_ID = p_COUNTER_ID
548: FOR UPDATE of COUNTER_ID NOWAIT;
549: Recinfo C1%ROWTYPE;
550:

Line 598: FROM csi_counter_template_b b

594: PROCEDURE add_language IS
595: BEGIN
596: DELETE FROM csi_counter_template_tl t
597: WHERE NOT EXISTS (SELECT NULL
598: FROM csi_counter_template_b b
599: WHERE b.counter_id = t.counter_id);
600:
601: UPDATE csi_counter_template_tl t
602: SET (name,description) = (SELECT b.name,