APPS.PV_ENTY_SELECT_CRITERIA_PKG dependencies on PV_ENTY_SELECT_CRITERIA

Line 1: PACKAGE BODY PV_ENTY_SELECT_CRITERIA_PKG as

1: PACKAGE BODY PV_ENTY_SELECT_CRITERIA_PKG as
2: /* $Header: pvrtescb.pls 120.0 2005/05/27 16:05:17 appldev noship $ */
3: -- Start of Comments
4: -- Package name : PV_ENTY_SELECT_CRITERIA_PKG
5: -- Purpose :

Line 4: -- Package name : PV_ENTY_SELECT_CRITERIA_PKG

1: PACKAGE BODY PV_ENTY_SELECT_CRITERIA_PKG as
2: /* $Header: pvrtescb.pls 120.0 2005/05/27 16:05:17 appldev noship $ */
3: -- Start of Comments
4: -- Package name : PV_ENTY_SELECT_CRITERIA_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_ENTY_SELECT_CRITERIA_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvrtescb.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 53: CURSOR C2 IS SELECT PV_ENTY_SELECT_CRITERIA_S.nextval FROM sys.dual;

49: ,p_ATTRIBUTE14 VARCHAR2
50: ,p_ATTRIBUTE15 VARCHAR2
51: )
52: IS
53: CURSOR C2 IS SELECT PV_ENTY_SELECT_CRITERIA_S.nextval FROM sys.dual;
54: BEGIN
55: If (px_SELECTION_CRITERIA_ID IS NULL) OR (px_SELECTION_CRITERIA_ID = FND_API.G_MISS_NUM) then
56: OPEN C2;
57: FETCH C2 INTO px_SELECTION_CRITERIA_ID;

Line 60: INSERT INTO PV_ENTY_SELECT_CRITERIA(

56: OPEN C2;
57: FETCH C2 INTO px_SELECTION_CRITERIA_ID;
58: CLOSE C2;
59: End If;
60: INSERT INTO PV_ENTY_SELECT_CRITERIA(
61: SELECTION_CRITERIA_ID
62: ,LAST_UPDATE_DATE
63: ,LAST_UPDATED_BY
64: ,CREATION_DATE

Line 165: Update PV_ENTY_SELECT_CRITERIA

161: ,p_ATTRIBUTE15 VARCHAR2
162: )
163: IS
164: BEGIN
165: Update PV_ENTY_SELECT_CRITERIA
166: SET
167: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
168: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
169: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)

Line 209: DELETE FROM PV_ENTY_SELECT_CRITERIA

205: PROCEDURE Delete_Row(
206: p_SELECTION_CRITERIA_ID NUMBER)
207: IS
208: BEGIN
209: DELETE FROM PV_ENTY_SELECT_CRITERIA
210: WHERE SELECTION_CRITERIA_ID = p_SELECTION_CRITERIA_ID;
211: If (SQL%NOTFOUND) then
212: RAISE NO_DATA_FOUND;
213: End If;

Line 253: FROM PV_ENTY_SELECT_CRITERIA

249: )
250: IS
251: CURSOR C IS
252: SELECT *
253: FROM PV_ENTY_SELECT_CRITERIA
254: WHERE SELECTION_CRITERIA_ID = p_SELECTION_CRITERIA_ID
255: FOR UPDATE of SELECTION_CRITERIA_ID NOWAIT;
256: Recinfo C%ROWTYPE;
257: BEGIN

Line 369: End PV_ENTY_SELECT_CRITERIA_PKG;

365: APP_EXCEPTION.RAISE_EXCEPTION;
366: End If;
367: END Lock_Row;
368:
369: End PV_ENTY_SELECT_CRITERIA_PKG;