APPS.PV_ENTY_ATTR_VALUES_PKG dependencies on PV_ENTY_ATTR_VALUES

Line 1: PACKAGE BODY PV_ENTY_ATTR_VALUES_PKG as

1: PACKAGE BODY PV_ENTY_ATTR_VALUES_PKG as
2: /* $Header: pvxteavb.pls 115.3 2002/12/10 19:41:57 amaram ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- PV_ENTY_ATTR_VALUES_PKG

2: /* $Header: pvxteavb.pls 115.3 2002/12/10 19:41:57 amaram ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- PV_ENTY_ATTR_VALUES_PKG
7: -- Purpose
8: --
9: -- History
10: --

Line 16: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PV_ENTY_ATTR_VALUES_PKG';

12: --
13: -- End of Comments
14: -- ===============================================================
15:
16: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PV_ENTY_ATTR_VALUES_PKG';
17: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxteavb.pls';
18:
19: ----------------------------------------------------------
20: ---- MEDIA ----

Line 64: INSERT INTO PV_ENTY_ATTR_VALUES(

60: BEGIN
61:
62: px_object_version_number := 1;
63:
64: INSERT INTO PV_ENTY_ATTR_VALUES(
65: enty_attr_val_id
66: ,last_update_date
67: ,last_updated_by
68: ,creation_date

Line 149: Update PV_ENTY_ATTR_VALUES

145:
146: IS
147:
148: BEGIN
149: Update PV_ENTY_ATTR_VALUES
150: SET
151: enty_attr_val_id = DECODE( p_enty_attr_val_id, FND_API.g_miss_num, enty_attr_val_id, p_enty_attr_val_id)
152: ,last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date)
153: ,last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by)

Line 201: DELETE FROM PV_ENTY_ATTR_VALUES

197: PROCEDURE Delete_Row(
198: p_ENTY_ATTR_VAL_ID NUMBER)
199: IS
200: BEGIN
201: DELETE FROM PV_ENTY_ATTR_VALUES
202: WHERE ENTY_ATTR_VAL_ID = p_ENTY_ATTR_VAL_ID;
203: IF (SQL%NOTFOUND) THEN
204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
205: END IF;

Line 250: FROM PV_ENTY_ATTR_VALUES

246:
247: IS
248: CURSOR C IS
249: SELECT *
250: FROM PV_ENTY_ATTR_VALUES
251: WHERE ENTY_ATTR_VAL_ID = p_ENTY_ATTR_VAL_ID
252: FOR UPDATE of ENTY_ATTR_VAL_ID NOWAIT;
253: Recinfo C%ROWTYPE;
254:

Line 336: END PV_ENTY_ATTR_VALUES_PKG;

332: APP_EXCEPTION.RAISE_EXCEPTION;
333: END IF;
334: END Lock_Row;
335:
336: END PV_ENTY_ATTR_VALUES_PKG;