APPS.PV_SELECTED_ATTR_VALUES_PKG dependencies on PV_SELECTED_ATTR_VALUES

Line 1: PACKAGE BODY PV_SELECTED_ATTR_VALUES_PKG as

1: PACKAGE BODY PV_SELECTED_ATTR_VALUES_PKG as
2: /* $Header: pvrtsavb.pls 115.3 2003/09/24 22:08:45 pklin ship $ */
3: -- Start of Comments
4: -- Package name : PV_SELECTED_ATTR_VALUES_PKG
5: -- Purpose :

Line 4: -- Package name : PV_SELECTED_ATTR_VALUES_PKG

1: PACKAGE BODY PV_SELECTED_ATTR_VALUES_PKG as
2: /* $Header: pvrtsavb.pls 115.3 2003/09/24 22:08:45 pklin ship $ */
3: -- Start of Comments
4: -- Package name : PV_SELECTED_ATTR_VALUES_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_SELECTED_ATTR_VALUES_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvrtsavb.pls';
13:
14: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
15: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 52: CURSOR C2 IS SELECT PV_SELECTED_ATTR_VALUES_S.nextval FROM sys.dual;

48: ,p_ATTRIBUTE15 VARCHAR2
49: ,p_SCORE NUMBER)
50:
51: IS
52: CURSOR C2 IS SELECT PV_SELECTED_ATTR_VALUES_S.nextval FROM sys.dual;
53: BEGIN
54: If (px_ATTR_VALUE_ID IS NULL) OR (px_ATTR_VALUE_ID = FND_API.G_MISS_NUM) then
55: OPEN C2;
56: FETCH C2 INTO px_ATTR_VALUE_ID;

Line 59: INSERT INTO PV_SELECTED_ATTR_VALUES(

55: OPEN C2;
56: FETCH C2 INTO px_ATTR_VALUE_ID;
57: CLOSE C2;
58: End If;
59: INSERT INTO PV_SELECTED_ATTR_VALUES(
60: ATTR_VALUE_ID
61: ,LAST_UPDATE_DATE
62: ,LAST_UPDATED_BY
63: ,CREATION_DATE

Line 160: Update PV_SELECTED_ATTR_VALUES

156: ,p_SCORE NUMBER)
157:
158: IS
159: BEGIN
160: Update PV_SELECTED_ATTR_VALUES
161: SET
162: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
163: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
164: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)

Line 203: DELETE FROM PV_SELECTED_ATTR_VALUES

199: PROCEDURE Delete_Row(
200: p_ATTR_VALUE_ID NUMBER)
201: IS
202: BEGIN
203: DELETE FROM PV_SELECTED_ATTR_VALUES
204: WHERE ATTR_VALUE_ID = p_ATTR_VALUE_ID;
205: If (SQL%NOTFOUND) then
206: RAISE NO_DATA_FOUND;
207: End If;

Line 246: FROM PV_SELECTED_ATTR_VALUES

242:
243: IS
244: CURSOR C IS
245: SELECT *
246: FROM PV_SELECTED_ATTR_VALUES
247: WHERE ATTR_VALUE_ID = p_ATTR_VALUE_ID
248: FOR UPDATE of ATTR_VALUE_ID NOWAIT;
249: Recinfo C%ROWTYPE;
250: BEGIN

Line 359: End PV_SELECTED_ATTR_VALUES_PKG;

355: APP_EXCEPTION.RAISE_EXCEPTION;
356: End If;
357: END Lock_Row;
358:
359: End PV_SELECTED_ATTR_VALUES_PKG;