APPS.PV_ENTITY_ATTR_MAPPINGS_PKG dependencies on PV_ENTITY_ATTR_MAPPINGS

Line 1: PACKAGE BODY PV_ENTITY_ATTR_MAPPINGS_PKG as

1: PACKAGE BODY PV_ENTITY_ATTR_MAPPINGS_PKG as
2: /* $Header: pvrteamb.pls 120.0 2005/05/27 15:46:41 appldev noship $ */
3: -- Start of Comments
4: -- Package name : PV_ENTITY_ATTR_MAPPINGS_PKG
5: -- Purpose :

Line 4: -- Package name : PV_ENTITY_ATTR_MAPPINGS_PKG

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

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

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

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

Line 61: INSERT INTO PV_ENTITY_ATTR_MAPPINGS(

57: OPEN C2;
58: FETCH C2 INTO px_MAPPING_ID;
59: CLOSE C2;
60: End If;
61: INSERT INTO PV_ENTITY_ATTR_MAPPINGS(
62: MAPPING_ID
63: ,LAST_UPDATE_DATE
64: ,LAST_UPDATED_BY
65: ,CREATION_DATE

Line 169: Update PV_ENTITY_ATTR_MAPPINGS

165: ,p_ATTRIBUTE15 VARCHAR2
166: )
167: IS
168: BEGIN
169: Update PV_ENTITY_ATTR_MAPPINGS
170: SET
171: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
172: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
173: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)

Line 214: DELETE FROM PV_ENTITY_ATTR_MAPPINGS

210: PROCEDURE Delete_Row(
211: p_MAPPING_ID NUMBER)
212: IS
213: BEGIN
214: DELETE FROM PV_ENTITY_ATTR_MAPPINGS
215: WHERE MAPPING_ID = p_MAPPING_ID;
216: If (SQL%NOTFOUND) then
217: RAISE NO_DATA_FOUND;
218: End If;

Line 259: FROM PV_ENTITY_ATTR_MAPPINGS

255: )
256: IS
257: CURSOR C IS
258: SELECT *
259: FROM PV_ENTITY_ATTR_MAPPINGS
260: WHERE MAPPING_ID = p_MAPPING_ID
261: FOR UPDATE of MAPPING_ID NOWAIT;
262: Recinfo C%ROWTYPE;
263: BEGIN

Line 378: End PV_ENTITY_ATTR_MAPPINGS_PKG;

374: APP_EXCEPTION.RAISE_EXCEPTION;
375: End If;
376: END Lock_Row;
377:
378: End PV_ENTITY_ATTR_MAPPINGS_PKG;