APPS.CSI_CTR_ITEM_ASSOCIATIONS_PKG dependencies on CSI_CTR_ITEM_ASSOCIATIONS

Line 1: PACKAGE BODY CSI_CTR_ITEM_ASSOCIATIONS_PKG as

1: PACKAGE BODY CSI_CTR_ITEM_ASSOCIATIONS_PKG as
2: /* $Header: csitciab.pls 120.3 2008/04/03 21:53:54 devijay ship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_CTR_ITEM_ASSOCIATIONS_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitciab.pls';

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

1: PACKAGE BODY CSI_CTR_ITEM_ASSOCIATIONS_PKG as
2: /* $Header: csitciab.pls 120.3 2008/04/03 21:53:54 devijay ship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_CTR_ITEM_ASSOCIATIONS_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitciab.pls';
6:
7: PROCEDURE Insert_Row(
8: px_CTR_ASSOCIATION_ID IN OUT NOCOPY NUMBER

Line 47: SELECT CSI_CTR_ITEM_ASSOCIATIONS_S.nextval

43: ,p_PRIMARY_FAILURE_FLAG VARCHAR2
44: ) IS
45:
46: CURSOR C1 IS
47: SELECT CSI_CTR_ITEM_ASSOCIATIONS_S.nextval
48: FROM dual;
49: BEGIN
50: IF (px_CTR_ASSOCIATION_ID IS NULL) OR (px_CTR_ASSOCIATION_ID = FND_API.G_MISS_NUM) then
51: OPEN C1;

Line 56: INSERT INTO CSI_CTR_ITEM_ASSOCIATIONS(

52: FETCH C1 INTO px_CTR_ASSOCIATION_ID;
53: CLOSE C1;
54: END IF;
55:
56: INSERT INTO CSI_CTR_ITEM_ASSOCIATIONS(
57: CTR_ASSOCIATION_ID
58: ,GROUP_ID
59: ,INVENTORY_ITEM_ID
60: ,OBJECT_VERSION_NUMBER

Line 173: UPDATE CSI_CTR_ITEM_ASSOCIATIONS

169: ,p_ASSOCIATED_TO_GROUP VARCHAR2
170: ,p_MAINT_ORGANIZATION_ID NUMBER
171: ,p_PRIMARY_FAILURE_FLAG VARCHAR2) IS
172: BEGIN
173: UPDATE CSI_CTR_ITEM_ASSOCIATIONS
174: SET GROUP_ID = decode(p_GROUP_ID, NULL, GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID)
175: ,INVENTORY_ITEM_ID = decode(p_INVENTORY_ITEM_ID, NULL, INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
176: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
177: ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,p_LAST_UPDATE_DATE)

Line 218: DELETE FROM CSI_CTR_ITEM_ASSOCIATIONS

214: END Update_Row;
215:
216: PROCEDURE Delete_Row(p_CTR_ASSOCIATION_ID NUMBER) IS
217: BEGIN
218: DELETE FROM CSI_CTR_ITEM_ASSOCIATIONS
219: WHERE CTR_ASSOCIATION_ID = p_CTR_ASSOCIATION_ID;
220: IF (SQL%NOTFOUND) then
221: RAISE NO_DATA_FOUND;
222: END IF;

Line 265: FROM CSI_CTR_ITEM_ASSOCIATIONS

261: ,p_PRIMARY_FAILURE_FLAG VARCHAR2) IS
262:
263: CURSOR C1 IS
264: SELECT *
265: FROM CSI_CTR_ITEM_ASSOCIATIONS
266: WHERE CTR_ASSOCIATION_ID = p_CTR_ASSOCIATION_ID
267: FOR UPDATE of CTR_ASSOCIATION_ID NOWAIT;
268: Recinfo C1%ROWTYPE;
269: BEGIN

Line 396: End CSI_CTR_ITEM_ASSOCIATIONS_PKG;

392:
393: END Lock_Row;
394:
395:
396: End CSI_CTR_ITEM_ASSOCIATIONS_PKG;