APPS.CSI_ITEM_INSTANCES_PKG dependencies on CSI_ITEM_INSTANCES

Line 1: PACKAGE BODY CSI_ITEM_INSTANCES_PKG AS

1: PACKAGE BODY CSI_ITEM_INSTANCES_PKG AS
2: /* $Header: csitiisb.pls 120.5 2007/10/19 23:41:04 fli ship $ */
3: -- Start of Comments
4: -- Package name : CSI_ITEM_INSTANCES_PKG
5: -- Purpose :

Line 4: -- Package name : CSI_ITEM_INSTANCES_PKG

1: PACKAGE BODY CSI_ITEM_INSTANCES_PKG AS
2: /* $Header: csitiisb.pls 120.5 2007/10/19 23:41:04 fli ship $ */
3: -- Start of Comments
4: -- Package name : CSI_ITEM_INSTANCES_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_ITEM_INSTANCES_PKG';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_ITEM_INSTANCES_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitiisb.pls';
13:
14: PROCEDURE Insert_Row(
15: px_INSTANCE_ID IN OUT NOCOPY NUMBER,

Line 137: CURSOR C2 IS SELECT CSI_ITEM_INSTANCES_S.NEXTVAL FROM sys.dual;

133: p_SOURCE_CODE VARCHAR2 -- Added Code for Siebel Genesis Project
134: )
135:
136: IS
137: CURSOR C2 IS SELECT CSI_ITEM_INSTANCES_S.NEXTVAL FROM sys.dual;
138: BEGIN
139: IF (px_INSTANCE_ID IS NULL) OR (px_INSTANCE_ID = FND_API.G_MISS_NUM) THEN
140: OPEN C2;
141: FETCH C2 INTO px_INSTANCE_ID;

Line 144: INSERT INTO CSI_ITEM_INSTANCES(

140: OPEN C2;
141: FETCH C2 INTO px_INSTANCE_ID;
142: CLOSE C2;
143: END IF;
144: INSERT INTO CSI_ITEM_INSTANCES(
145: INSTANCE_ID,
146: INSTANCE_NUMBER,
147: EXTERNAL_REFERENCE,
148: INVENTORY_ITEM_ID,

Line 512: UPDATE CSI_ITEM_INSTANCES

508: )
509: IS
510: BEGIN
511:
512: UPDATE CSI_ITEM_INSTANCES
513: SET
514: INSTANCE_NUMBER = decode( p_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, INSTANCE_NUMBER, p_INSTANCE_NUMBER),
515: EXTERNAL_REFERENCE = decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, EXTERNAL_REFERENCE, p_EXTERNAL_REFERENCE),
516: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),

Line 643: DELETE FROM CSI_ITEM_INSTANCES

639: PROCEDURE Delete_Row(
640: p_INSTANCE_ID NUMBER)
641: IS
642: BEGIN
643: DELETE FROM CSI_ITEM_INSTANCES
644: WHERE INSTANCE_ID = p_INSTANCE_ID;
645: IF (SQL%NOTFOUND) THEN
646: RAISE NO_DATA_FOUND;
647: END IF;

Line 770: FROM CSI_ITEM_INSTANCES

766:
767: IS
768: CURSOR C IS
769: SELECT *
770: FROM CSI_ITEM_INSTANCES
771: WHERE INSTANCE_ID = p_INSTANCE_ID
772: FOR UPDATE of INSTANCE_ID NOWAIT;
773: Recinfo C%ROWTYPE;
774: BEGIN

Line 1126: END CSI_ITEM_INSTANCES_PKG;

1122: APP_EXCEPTION.RAISE_EXCEPTION;
1123: END IF;
1124: END Lock_Row;
1125:
1126: END CSI_ITEM_INSTANCES_PKG;