APPS.PV_ENTITY_RULES_APPLIED_PKG dependencies on PV_ENTITY_RULES_APPLIED

Line 1: PACKAGE BODY PV_ENTITY_RULES_APPLIED_PKG as

1: PACKAGE BODY PV_ENTITY_RULES_APPLIED_PKG as
2: /* $Header: pvrterab.pls 115.5 2003/06/19 18:07:33 solin ship $ */
3: -- Start of Comments
4: -- Package name : PV_ENTITY_RULES_APPLIED_PKG
5: -- Purpose :

Line 4: -- Package name : PV_ENTITY_RULES_APPLIED_PKG

1: PACKAGE BODY PV_ENTITY_RULES_APPLIED_PKG as
2: /* $Header: pvrterab.pls 115.5 2003/06/19 18:07:33 solin ship $ */
3: -- Start of Comments
4: -- Package name : PV_ENTITY_RULES_APPLIED_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

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

54: ,p_ATTRIBUTE15 VARCHAR2
55: ,p_PROCESS_STATUS VARCHAR2)
56:
57: IS
58: CURSOR C2 IS SELECT PV_ENTITY_RULES_APPLIED_S.nextval FROM sys.dual;
59: BEGIN
60: -- If (px_ENTITY_RULE_APPLIED_ID IS NULL) OR (px_ENTITY_RULE_APPLIED_ID = FND_API.G_MISS_NUM) then
61: -- OPEN C2;
62: -- FETCH C2 INTO px_ENTITY_RULE_APPLIED_ID;

Line 70: INSERT INTO PV_ENTITY_RULES_APPLIED(

66: THEN
67: RETURN;
68: END IF;
69:
70: INSERT INTO PV_ENTITY_RULES_APPLIED(
71: ENTITY_RULE_APPLIED_ID
72: ,LAST_UPDATE_DATE
73: ,LAST_UPDATED_BY
74: ,CREATION_DATE

Line 109: PV_ENTITY_RULES_APPLIED_S.nextval --px_ENTITY_RULE_APPLIED_ID

105: ,ATTRIBUTE14
106: ,ATTRIBUTE15
107: ,PROCESS_STATUS
108: ) VALUES (
109: PV_ENTITY_RULES_APPLIED_S.nextval --px_ENTITY_RULE_APPLIED_ID
110: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
111: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
112: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
113: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)

Line 190: Update PV_ENTITY_RULES_APPLIED

186: ,p_PROCESS_STATUS VARCHAR2)
187:
188: IS
189: BEGIN
190: Update PV_ENTITY_RULES_APPLIED
191: SET
192: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
193: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
194: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)

Line 239: DELETE FROM PV_ENTITY_RULES_APPLIED

235: PROCEDURE Delete_Row(
236: p_ENTITY_RULE_APPLIED_ID NUMBER)
237: IS
238: BEGIN
239: DELETE FROM PV_ENTITY_RULES_APPLIED
240: WHERE ENTITY_RULE_APPLIED_ID = p_ENTITY_RULE_APPLIED_ID;
241: If (SQL%NOTFOUND) then
242: RAISE NO_DATA_FOUND;
243: End If;

Line 288: FROM PV_ENTITY_RULES_APPLIED

284:
285: IS
286: CURSOR C IS
287: SELECT *
288: FROM PV_ENTITY_RULES_APPLIED
289: WHERE ENTITY_RULE_APPLIED_ID = p_ENTITY_RULE_APPLIED_ID
290: FOR UPDATE of ENTITY_RULE_APPLIED_ID NOWAIT;
291: Recinfo C%ROWTYPE;
292: BEGIN

Line 419: End PV_ENTITY_RULES_APPLIED_PKG;

415: APP_EXCEPTION.RAISE_EXCEPTION;
416: End If;
417: END Lock_Row;
418:
419: End PV_ENTITY_RULES_APPLIED_PKG;