APPS.CSI_I_VERSION_LABELS_H_PKG dependencies on CSI_I_VERSION_LABELS_H

Line 1: PACKAGE BODY CSI_I_VERSION_LABELS_H_PKG as

1: PACKAGE BODY CSI_I_VERSION_LABELS_H_PKG as
2: /* $Header: csitlahb.pls 115.12 2003/09/04 00:21:13 sguthiva ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_I_VERSION_LABELS_H_PKG';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_I_VERSION_LABELS_H_PKG';

1: PACKAGE BODY CSI_I_VERSION_LABELS_H_PKG as
2: /* $Header: csitlahb.pls 115.12 2003/09/04 00:21:13 sguthiva ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_I_VERSION_LABELS_H_PKG';
6: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitlahb.pls';
7:
8: PROCEDURE Insert_Row(
9: px_VERSION_LABEL_HISTORY_ID IN OUT NOCOPY NUMBER,

Line 62: CURSOR C2 IS SELECT CSI_I_VERSION_LABELS_H_S.nextval FROM sys.dual;

58: p_LAST_UPDATE_DATE DATE,
59: p_LAST_UPDATE_LOGIN NUMBER,
60: p_OBJECT_VERSION_NUMBER NUMBER)
61: IS
62: CURSOR C2 IS SELECT CSI_I_VERSION_LABELS_H_S.nextval FROM sys.dual;
63: BEGIN
64: If (px_VERSION_LABEL_HISTORY_ID IS NULL) OR (px_VERSION_LABEL_HISTORY_ID = FND_API.G_MISS_NUM) then
65: OPEN C2;
66: FETCH C2 INTO px_VERSION_LABEL_HISTORY_ID;

Line 69: INSERT INTO CSI_I_VERSION_LABELS_H(

65: OPEN C2;
66: FETCH C2 INTO px_VERSION_LABEL_HISTORY_ID;
67: CLOSE C2;
68: End If;
69: INSERT INTO CSI_I_VERSION_LABELS_H(
70: VERSION_LABEL_HISTORY_ID,
71: VERSION_LABEL_ID,
72: TRANSACTION_ID,
73: OLD_VERSION_LABEL,

Line 232: Update CSI_I_VERSION_LABELS_H

228: p_LAST_UPDATE_LOGIN NUMBER,
229: p_OBJECT_VERSION_NUMBER NUMBER)
230: IS
231: BEGIN
232: Update CSI_I_VERSION_LABELS_H
233: SET
234: VERSION_LABEL_ID = decode( p_VERSION_LABEL_ID, FND_API.G_MISS_NUM, VERSION_LABEL_ID, p_VERSION_LABEL_ID),
235: TRANSACTION_ID = decode( p_TRANSACTION_ID, FND_API.G_MISS_NUM, TRANSACTION_ID, p_TRANSACTION_ID),
236: OLD_VERSION_LABEL = decode( p_OLD_VERSION_LABEL, FND_API.G_MISS_CHAR, OLD_VERSION_LABEL, p_OLD_VERSION_LABEL),

Line 297: DELETE FROM CSI_I_VERSION_LABELS_H

293: PROCEDURE Delete_Row(
294: p_VERSION_LABEL_HISTORY_ID NUMBER)
295: IS
296: BEGIN
297: DELETE FROM CSI_I_VERSION_LABELS_H
298: WHERE VERSION_LABEL_HISTORY_ID = p_VERSION_LABEL_HISTORY_ID;
299: If (SQL%NOTFOUND) then
300: RAISE NO_DATA_FOUND;
301: End If;

Line 361: FROM CSI_I_VERSION_LABELS_H

357:
358: IS
359: CURSOR C IS
360: SELECT *
361: FROM CSI_I_VERSION_LABELS_H
362: WHERE VERSION_LABEL_HISTORY_ID = p_VERSION_LABEL_HISTORY_ID
363: FOR UPDATE of VERSION_LABEL_HISTORY_ID NOWAIT;
364: Recinfo C%ROWTYPE;
365: BEGIN

Line 537: End CSI_I_VERSION_LABELS_H_PKG;

533: APP_EXCEPTION.RAISE_EXCEPTION;
534: End If;
535: END Lock_Row;
536:
537: End CSI_I_VERSION_LABELS_H_PKG;