APPS.CSI_CTR_PROPERTY_TEMPLATE_PKG dependencies on CSI_CTR_PROPERTY_TEMPLATE_B

Line 57: INSERT INTO CSI_CTR_PROPERTY_TEMPLATE_B(

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

Line 207: UPDATE CSI_CTR_PROPERTY_TEMPLATE_B

203: -- Read the debug profiles values in to global variable 7197402
204: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
205: csi_ctr_gen_utility_pvt.put_line(' Default Value = '||p_default_value);
206: -- Bug 12772525
207: UPDATE CSI_CTR_PROPERTY_TEMPLATE_B
208: SET COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
209: ,PROPERTY_DATA_TYPE = decode(p_PROPERTY_DATA_TYPE, NULL, PROPERTY_DATA_TYPE, FND_API.G_MISS_CHAR, NULL, p_PROPERTY_DATA_TYPE)
210: ,IS_NULLABLE = decode(p_IS_NULLABLE, NULL, IS_NULLABLE, FND_API.G_MISS_CHAR, NULL, p_IS_NULLABLE)
211: ,DEFAULT_VALUE = decode(p_DEFAULT_VALUE, NULL, DEFAULT_VALUE, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_VALUE)

Line 265: DELETE FROM CSI_CTR_PROPERTY_TEMPLATE_B

261: END Update_Row;
262:
263: PROCEDURE delete_row(p_COUNTER_PROPERTY_ID NUMBER) IS
264: BEGIN
265: DELETE FROM CSI_CTR_PROPERTY_TEMPLATE_B
266: WHERE COUNTER_PROPERTY_ID = p_COUNTER_PROPERTY_ID;
267: IF (SQL%NOTFOUND) then
268: RAISE NO_DATA_FOUND;
269: END IF;

Line 313: FROM CSI_CTR_PROPERTY_TEMPLATE_B

309: ,p_DESCRIPTION VARCHAR2) IS
310:
311: CURSOR C1 IS
312: SELECT *
313: FROM CSI_CTR_PROPERTY_TEMPLATE_B
314: WHERE COUNTER_PROPERTY_ID = p_COUNTER_PROPERTY_ID
315: FOR UPDATE of COUNTER_PROPERTY_ID NOWAIT;
316: Recinfo C1%ROWTYPE;
317:

Line 366: FROM CSI_CTR_PROPERTY_TEMPLATE_B b

362: PROCEDURE add_language IS
363: BEGIN
364: DELETE FROM CSI_CTR_PROPERTY_TEMPLATE_TL t
365: WHERE NOT EXISTS (SELECT NULL
366: FROM CSI_CTR_PROPERTY_TEMPLATE_B b
367: WHERE b.counter_property_id = t.counter_property_id);
368:
369: UPDATE CSI_CTR_PROPERTY_TEMPLATE_TL t
370: SET (name,description) = (SELECT b.name,