APPS.CSI_COUNTER_ASSOCIATIONS_PKG dependencies on CSI_COUNTER_ASSOCIATIONS

Line 1: PACKAGE BODY CSI_COUNTER_ASSOCIATIONS_PKG as

1: PACKAGE BODY CSI_COUNTER_ASSOCIATIONS_PKG as
2: /* $Header: csitciib.pls 120.4 2008/04/23 13:14:46 somitra ship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_COUNTER_ASSOCIATIONS_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitciib.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_COUNTER_ASSOCIATIONS_PKG';

1: PACKAGE BODY CSI_COUNTER_ASSOCIATIONS_PKG as
2: /* $Header: csitciib.pls 120.4 2008/04/23 13:14:46 somitra ship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_COUNTER_ASSOCIATIONS_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitciib.pls';
6:
7: PROCEDURE Insert_Row(
8: px_INSTANCE_ASSOCIATION_ID IN OUT NOCOPY NUMBER

Line 43: SELECT CSI_COUNTER_ASSOCIATIONS_S.nextval

39: ,p_PRIMARY_FAILURE_FLAG VARCHAR2
40: ) IS
41:
42: CURSOR C1 IS
43: SELECT CSI_COUNTER_ASSOCIATIONS_S.nextval
44: FROM dual;
45: BEGIN
46: IF (px_INSTANCE_ASSOCIATION_ID IS NULL) OR (px_INSTANCE_ASSOCIATION_ID = FND_API.G_MISS_NUM) then
47: OPEN C1;

Line 52: INSERT INTO CSI_COUNTER_ASSOCIATIONS(

48: FETCH C1 INTO px_INSTANCE_ASSOCIATION_ID;
49: CLOSE C1;
50: END IF;
51:
52: INSERT INTO CSI_COUNTER_ASSOCIATIONS(
53: INSTANCE_ASSOCIATION_ID
54: ,SOURCE_OBJECT_CODE
55: ,SOURCE_OBJECT_ID
56: ,OBJECT_VERSION_NUMBER

Line 157: UPDATE CSI_COUNTER_ASSOCIATIONS

153: ,p_END_DATE_ACTIVE DATE
154: ,p_MAINT_ORGANIZATION_ID NUMBER
155: ,p_PRIMARY_FAILURE_FLAG VARCHAR2) IS
156: BEGIN
157: UPDATE CSI_COUNTER_ASSOCIATIONS
158: SET SOURCE_OBJECT_CODE = decode(p_SOURCE_OBJECT_CODE, NULL, SOURCE_OBJECT_CODE, FND_API.G_MISS_CHAR,NULL, p_SOURCE_OBJECT_CODE)
159: ,SOURCE_OBJECT_ID = decode(p_SOURCE_OBJECT_ID, NULL, SOURCE_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_OBJECT_ID)
160: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
161: ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,p_LAST_UPDATE_DATE)

Line 198: DELETE FROM CSI_COUNTER_ASSOCIATIONS

194: END Update_Row;
195:
196: PROCEDURE Delete_Row(p_INSTANCE_ASSOCIATION_ID NUMBER) IS
197: BEGIN
198: DELETE FROM CSI_COUNTER_ASSOCIATIONS
199: WHERE INSTANCE_ASSOCIATION_ID = p_INSTANCE_ASSOCIATION_ID;
200: IF (SQL%NOTFOUND) then
201: RAISE NO_DATA_FOUND;
202: END IF;

Line 241: FROM CSI_COUNTER_ASSOCIATIONS

237: ,p_PRIMARY_FAILURE_FLAG VARCHAR2) IS
238:
239: CURSOR C1 IS
240: SELECT *
241: FROM CSI_COUNTER_ASSOCIATIONS
242: WHERE INSTANCE_ASSOCIATION_ID = p_INSTANCE_ASSOCIATION_ID
243: FOR UPDATE of INSTANCE_ASSOCIATION_ID NOWAIT;
244: Recinfo C1%ROWTYPE;
245: BEGIN

Line 360: End CSI_COUNTER_ASSOCIATIONS_PKG;

356:
357: END Lock_Row;
358:
359:
360: End CSI_COUNTER_ASSOCIATIONS_PKG;