APPS.CSI_ITEM_INSTANCES_H_PKG dependencies on CSI_ITEM_INSTANCES_H

Line 1: PACKAGE BODY CSI_ITEM_INSTANCES_H_PKG AS

1: PACKAGE BODY CSI_ITEM_INSTANCES_H_PKG AS
2: /* $Header: csitiihb.pls 120.5 2007/10/19 23:50:11 fli ship $ */
3: -- Start of Comments
4: -- Package name : CSI_ITEM_INSTANCES_H_PKG
5: -- Purpose :

Line 4: -- Package name : CSI_ITEM_INSTANCES_H_PKG

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

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

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

Line 233: CURSOR C2 IS SELECT CSI_ITEM_INSTANCES_H_S.NEXTVAL FROM sys.dual;

229: p_NEW_SOURCE_CODE VARCHAR2
230: -- End Add Code for Siebel Genesis Project
231: )
232: IS
233: CURSOR C2 IS SELECT CSI_ITEM_INSTANCES_H_S.NEXTVAL FROM sys.dual;
234: BEGIN
235: IF (px_INSTANCE_HISTORY_ID IS NULL) OR (px_INSTANCE_HISTORY_ID = FND_API.G_MISS_NUM) THEN
236: OPEN C2;
237: FETCH C2 INTO px_INSTANCE_HISTORY_ID;

Line 240: INSERT INTO CSI_ITEM_INSTANCES_H(

236: OPEN C2;
237: FETCH C2 INTO px_INSTANCE_HISTORY_ID;
238: CLOSE C2;
239: END IF;
240: INSERT INTO CSI_ITEM_INSTANCES_H(
241: INSTANCE_HISTORY_ID,
242: INSTANCE_ID,
243: TRANSACTION_ID,
244: OLD_INSTANCE_NUMBER,

Line 899: Update CSI_ITEM_INSTANCES_H

895: )
896:
897: IS
898: BEGIN
899: Update CSI_ITEM_INSTANCES_H
900: SET
901: INSTANCE_ID = decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, p_INSTANCE_ID),
902: TRANSACTION_ID = decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, TRANSACTION_ID, p_TRANSACTION_ID),
903: OLD_INSTANCE_NUMBER = decode( p_OLD_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, OLD_INSTANCE_NUMBER, p_OLD_INSTANCE_NUMBER),

Line 1127: DELETE FROM CSI_ITEM_INSTANCES_H

1123: PROCEDURE Delete_Row(
1124: p_INSTANCE_HISTORY_ID NUMBER)
1125: IS
1126: BEGIN
1127: DELETE FROM CSI_ITEM_INSTANCES_H
1128: WHERE INSTANCE_HISTORY_ID = p_INSTANCE_HISTORY_ID;
1129: If (SQL%NOTFOUND) then
1130: RAISE NO_DATA_FOUND;
1131: End If;

Line 1348: FROM CSI_ITEM_INSTANCES_H

1344:
1345: IS
1346: CURSOR C IS
1347: SELECT *
1348: FROM CSI_ITEM_INSTANCES_H
1349: WHERE INSTANCE_HISTORY_ID = p_INSTANCE_HISTORY_ID
1350: FOR UPDATE of INSTANCE_HISTORY_ID NOWAIT;
1351: Recinfo C%ROWTYPE;
1352: BEGIN

Line 1980: END CSI_ITEM_INSTANCES_H_PKG;

1976: APP_EXCEPTION.RAISE_EXCEPTION;
1977: END IF;
1978: END Lock_Row;
1979:
1980: END CSI_ITEM_INSTANCES_H_PKG;