APPS.CSI_IEA_VALUES_H_PKG dependencies on CSI_IEA_VALUES_H

Line 1: PACKAGE BODY CSI_IEA_VALUES_H_PKG as

1: PACKAGE BODY CSI_IEA_VALUES_H_PKG as
2: /* $Header: csitivhb.pls 115.20 2003/09/04 00:20:55 sguthiva ship $ */
3:
4:
5: g_pkg_name CONSTANT VARCHAR2(30):= 'CSI_IEA_VALUES_H_PKG';

Line 5: g_pkg_name CONSTANT VARCHAR2(30):= 'CSI_IEA_VALUES_H_PKG';

1: PACKAGE BODY CSI_IEA_VALUES_H_PKG as
2: /* $Header: csitivhb.pls 115.20 2003/09/04 00:20:55 sguthiva ship $ */
3:
4:
5: g_pkg_name CONSTANT VARCHAR2(30):= 'CSI_IEA_VALUES_H_PKG';
6:
7: PROCEDURE Insert_Row(
8: px_ATTRIBUTE_VALUE_HISTORY_ID IN OUT NOCOPY NUMBER,
9: p_ATTRIBUTE_VALUE_ID NUMBER,

Line 57: CURSOR C2 IS SELECT CSI_IEA_VALUES_H_S.nextval FROM sys.dual;

53: p_LAST_UPDATE_DATE DATE,
54: p_LAST_UPDATE_LOGIN NUMBER,
55: p_OBJECT_VERSION_NUMBER NUMBER)
56: IS
57: CURSOR C2 IS SELECT CSI_IEA_VALUES_H_S.nextval FROM sys.dual;
58: BEGIN
59: If (px_ATTRIBUTE_VALUE_HISTORY_ID IS NULL) OR (px_ATTRIBUTE_VALUE_HISTORY_ID = FND_API.G_MISS_NUM) then
60: OPEN C2;
61: FETCH C2 INTO px_ATTRIBUTE_VALUE_HISTORY_ID;

Line 64: INSERT INTO CSI_IEA_VALUES_H(

60: OPEN C2;
61: FETCH C2 INTO px_ATTRIBUTE_VALUE_HISTORY_ID;
62: CLOSE C2;
63: End If;
64: INSERT INTO CSI_IEA_VALUES_H(
65: ATTRIBUTE_VALUE_HISTORY_ID,
66: ATTRIBUTE_VALUE_ID,
67: TRANSACTION_ID,
68: OLD_ATTRIBUTE_VALUE,

Line 216: Update CSI_IEA_VALUES_H

212: p_OBJECT_VERSION_NUMBER NUMBER)
213:
214: IS
215: BEGIN
216: Update CSI_IEA_VALUES_H
217: SET
218: ATTRIBUTE_VALUE_ID = decode( p_ATTRIBUTE_VALUE_ID, FND_API.G_MISS_NUM, ATTRIBUTE_VALUE_ID, p_ATTRIBUTE_VALUE_ID),
219: TRANSACTION_ID = decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, TRANSACTION_ID, p_TRANSACTION_ID),
220: OLD_ATTRIBUTE_VALUE = decode( p_OLD_ATTRIBUTE_VALUE, FND_API.G_MISS_CHAR, OLD_ATTRIBUTE_VALUE, p_OLD_ATTRIBUTE_VALUE),

Line 276: DELETE FROM CSI_IEA_VALUES_H

272: PROCEDURE Delete_Row(
273: p_ATTRIBUTE_VALUE_HISTORY_ID NUMBER)
274: IS
275: BEGIN
276: DELETE FROM CSI_IEA_VALUES_H
277: WHERE ATTRIBUTE_VALUE_HISTORY_ID = p_ATTRIBUTE_VALUE_HISTORY_ID;
278: If (SQL%NOTFOUND) then
279: RAISE NO_DATA_FOUND;
280: End If;

Line 336: FROM CSI_IEA_VALUES_H

332:
333: IS
334: CURSOR C IS
335: SELECT *
336: FROM CSI_IEA_VALUES_H
337: WHERE ATTRIBUTE_VALUE_HISTORY_ID = p_ATTRIBUTE_VALUE_HISTORY_ID
338: FOR UPDATE of ATTRIBUTE_VALUE_HISTORY_ID NOWAIT;
339: Recinfo C%ROWTYPE;
340: BEGIN

Line 518: End CSI_IEA_VALUES_H_PKG;

514: APP_EXCEPTION.RAISE_EXCEPTION;
515: End If;
516: END Lock_Row;
517:
518: End CSI_IEA_VALUES_H_PKG;