APPS.PV_ENTITY_ROUTINGS_PKG dependencies on PV_ENTITY_ROUTINGS

Line 1: PACKAGE BODY PV_ENTITY_ROUTINGS_PKG as

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

Line 4: -- Package name : PV_ENTITY_ROUTINGS_PKG

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

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

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

56: ,p_ATTRIBUTE14 VARCHAR2
57: ,p_ATTRIBUTE15 VARCHAR2
58: )
59: IS
60: CURSOR C2 IS SELECT PV_ENTITY_ROUTINGS_S.nextval FROM sys.dual;
61: BEGIN
62: If (px_ENTITY_ROUTING_ID IS NULL) OR (px_ENTITY_ROUTING_ID = FND_API.G_MISS_NUM) then
63: OPEN C2;
64: FETCH C2 INTO px_ENTITY_ROUTING_ID;

Line 67: INSERT INTO PV_ENTITY_ROUTINGS(

63: OPEN C2;
64: FETCH C2 INTO px_ENTITY_ROUTING_ID;
65: CLOSE C2;
66: End If;
67: INSERT INTO PV_ENTITY_ROUTINGS(
68: ENTITY_ROUTING_ID
69: ,LAST_UPDATE_DATE
70: ,LAST_UPDATED_BY
71: ,CREATION_DATE

Line 193: Update PV_ENTITY_ROUTINGS

189: ,p_ATTRIBUTE15 VARCHAR2
190: )
191: IS
192: BEGIN
193: Update PV_ENTITY_ROUTINGS
194: SET
195: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
196: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
197: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)

Line 244: DELETE FROM PV_ENTITY_ROUTINGS

240: PROCEDURE Delete_Row(
241: p_ENTITY_ROUTING_ID NUMBER)
242: IS
243: BEGIN
244: DELETE FROM PV_ENTITY_ROUTINGS
245: WHERE ENTITY_ROUTING_ID = p_ENTITY_ROUTING_ID;
246: If (SQL%NOTFOUND) then
247: RAISE NO_DATA_FOUND;
248: End If;

Line 295: FROM PV_ENTITY_ROUTINGS

291: )
292: IS
293: CURSOR C IS
294: SELECT *
295: FROM PV_ENTITY_ROUTINGS
296: WHERE ENTITY_ROUTING_ID = p_ENTITY_ROUTING_ID
297: FOR UPDATE of ENTITY_ROUTING_ID NOWAIT;
298: Recinfo C%ROWTYPE;
299: BEGIN

Line 432: End PV_ENTITY_ROUTINGS_PKG;

428: APP_EXCEPTION.RAISE_EXCEPTION;
429: End If;
430: END Lock_Row;
431:
432: End PV_ENTITY_ROUTINGS_PKG;