APPS.CSI_CTR_ESTIMATE_METHODS_PKG dependencies on CSI_CTR_ESTIMATION_METHODS_B

Line 53: INSERT INTO CSI_CTR_ESTIMATION_METHODS_B(

49: FETCH C1 INTO px_ESTIMATION_ID;
50: CLOSE C1;
51: END IF;
52:
53: INSERT INTO CSI_CTR_ESTIMATION_METHODS_B(
54: ESTIMATION_ID
55: ,ESTIMATION_TYPE
56: ,FIXED_VALUE
57: ,USAGE_MARKUP

Line 189: UPDATE CSI_CTR_ESTIMATION_METHODS_B

185: ,p_NAME VARCHAR2
186: ,p_DESCRIPTION VARCHAR2
187: ) IS
188: BEGIN
189: UPDATE CSI_CTR_ESTIMATION_METHODS_B
190: SET
191: ESTIMATION_TYPE = decode(p_ESTIMATION_TYPE, NULL, ESTIMATION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ESTIMATION_TYPE)
192: ,FIXED_VALUE = decode(p_FIXED_VALUE, NULL, FIXED_VALUE, FND_API.G_MISS_NUM, NULL, p_FIXED_VALUE)
193: ,USAGE_MARKUP = decode(p_USAGE_MARKUP, NULL, USAGE_MARKUP, FND_API.G_MISS_NUM, NULL, p_USAGE_MARKUP)

Line 280: FROM CSI_CTR_ESTIMATION_METHODS_B

276: ) IS
277:
278: CURSOR C1 IS
279: SELECT *
280: FROM CSI_CTR_ESTIMATION_METHODS_B
281: WHERE ESTIMATION_ID = p_ESTIMATION_ID
282: FOR UPDATE of ESTIMATION_ID NOWAIT;
283: Recinfo C1%ROWTYPE;
284:

Line 330: DELETE FROM CSI_CTR_ESTIMATION_METHODS_B

326: PROCEDURE Delete_Row(
327: p_ESTIMATION_ID NUMBER
328: ) IS
329: BEGIN
330: DELETE FROM CSI_CTR_ESTIMATION_METHODS_B
331: WHERE ESTIMATION_ID = p_ESTIMATION_ID;
332: IF (SQL%NOTFOUND) then
333: RAISE NO_DATA_FOUND;
334: END IF;

Line 341: FROM CSI_CTR_ESTIMATION_METHODS_B b

337: PROCEDURE add_language IS
338: BEGIN
339: DELETE FROM CSI_CTR_ESTIMATION_METHODS_TL t
340: WHERE NOT EXISTS (SELECT NULL
341: FROM CSI_CTR_ESTIMATION_METHODS_B b
342: WHERE b.ESTIMATION_ID = t.ESTIMATION_ID);
343:
344: UPDATE CSI_CTR_ESTIMATION_METHODS_TL t
345: SET (name, description) = (SELECT b.name,