APPS.PV_ENTY_ATTR_VALIDATIONS_PKG dependencies on PV_ENTY_ATTR_VALIDATIONS

Line 1: PACKAGE BODY PV_ENTY_ATTR_VALIDATIONS_PKG as

1: PACKAGE BODY PV_ENTY_ATTR_VALIDATIONS_PKG as
2: /* $Header: pvxtatvb.pls 115.1 2002/12/10 19:40:13 amaram ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PV_ENTY_ATTR_VALIDATIONS_PKG';

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

Line 57: INSERT INTO PV_ENTY_ATTR_VALIDATIONS (

53: BEGIN
54:
55: px_object_version_number := 1;
56:
57: INSERT INTO PV_ENTY_ATTR_VALIDATIONS (
58: VALIDATION_ID,
59: LAST_UPDATE_DATE,
60: LAST_UPDATED_BY,
61: CREATION_DATE,

Line 118: UPDATE PV_ENTY_ATTR_VALIDATIONS

114: IS
115:
116: BEGIN
117:
118: UPDATE PV_ENTY_ATTR_VALIDATIONS
119: SET
120: validation_id = DECODE( p_enty_attr_validation_id, Fnd_Api.g_miss_num, validation_id, p_enty_attr_validation_id)
121: ,last_update_date = DECODE( p_last_update_date, Fnd_Api.g_miss_date, last_update_date, p_last_update_date)
122: ,last_updated_by = DECODE( p_last_updated_by, Fnd_Api.g_miss_num, last_updated_by, p_last_updated_by)

Line 162: DELETE FROM PV_ENTY_ATTR_VALIDATIONS

158: IS
159:
160: BEGIN
161:
162: DELETE FROM PV_ENTY_ATTR_VALIDATIONS
163: WHERE validation_id = p_enty_attr_validation_id;
164:
165: IF (SQL%NOTFOUND) THEN
166: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 205: FROM PV_ENTY_ATTR_VALIDATIONS

201: IS
202:
203: CURSOR C IS
204: SELECT *
205: FROM PV_ENTY_ATTR_VALIDATIONS
206: WHERE VALIDATION_ID = p_enty_attr_validation_id
207: FOR UPDATE OF VALIDATION_ID NOWAIT;
208:
209: Recinfo C%ROWTYPE;

Line 270: END PV_ENTY_ATTR_VALIDATIONS_PKG;

266:
267: END Lock_Row;
268:
269:
270: END PV_ENTY_ATTR_VALIDATIONS_PKG;