APPS.CSI_COUNTER_RELATIONSHIP_PKG dependencies on CSI_COUNTER_RELATIONSHIPS

Line 44: SELECT CSI_COUNTER_RELATIONSHIPS_S.nextval

40: ,p_FACTOR NUMBER
41: ) IS
42:
43: CURSOR C1 IS
44: SELECT CSI_COUNTER_RELATIONSHIPS_S.nextval
45: FROM dual;
46: BEGIN
47: IF (px_RELATIONSHIP_ID IS NULL) OR (px_RELATIONSHIP_ID = FND_API.G_MISS_NUM) THEN
48: OPEN C1;

Line 53: INSERT INTO CSI_COUNTER_RELATIONSHIPS(

49: FETCH C1 INTO px_RELATIONSHIP_ID;
50: CLOSE C1;
51: END IF;
52:
53: INSERT INTO CSI_COUNTER_RELATIONSHIPS(
54: RELATIONSHIP_ID
55: ,CTR_ASSOCIATION_ID
56: ,RELATIONSHIP_TYPE_CODE
57: ,SOURCE_COUNTER_ID

Line 162: UPDATE CSI_COUNTER_RELATIONSHIPS

158: ,p_BIND_VARIABLE_NAME VARCHAR2
159: ,p_FACTOR NUMBER
160: ) IS
161: BEGIN
162: UPDATE CSI_COUNTER_RELATIONSHIPS
163: SET
164: CTR_ASSOCIATION_ID = decode(p_CTR_ASSOCIATION_ID, NULL, CTR_ASSOCIATION_ID, FND_API.G_MISS_NUM, NULL, p_CTR_ASSOCIATION_ID)
165: ,RELATIONSHIP_TYPE_CODE = decode(p_RELATIONSHIP_TYPE_CODE, NULL, RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_RELATIONSHIP_TYPE_CODE)
166: ,SOURCE_COUNTER_ID = decode(p_SOURCE_COUNTER_ID, NULL, SOURCE_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_COUNTER_ID)

Line 241: FROM CSI_COUNTER_RELATIONSHIPS

237: ) IS
238:
239: CURSOR C1 IS
240: SELECT *
241: FROM CSI_COUNTER_RELATIONSHIPS
242: WHERE RELATIONSHIP_ID = p_RELATIONSHIP_ID
243: FOR UPDATE of RELATIONSHIP_ID NOWAIT;
244: Recinfo C1%ROWTYPE;
245: BEGIN

Line 302: DELETE FROM CSI_COUNTER_RELATIONSHIPS

298: PROCEDURE Delete_Row(
299: p_RELATIONSHIP_ID NUMBER
300: ) IS
301: BEGIN
302: DELETE FROM CSI_COUNTER_RELATIONSHIPS
303: WHERE RELATIONSHIP_ID = p_RELATIONSHIP_ID;
304:
305: IF (SQL%NOTFOUND) then
306: RAISE NO_DATA_FOUND;