APPS.IEO_SVR_VALUES_PVT dependencies on IEO_SVR_VALUES

Line 1: PACKAGE BODY ieo_svr_values_pvt AS

1: PACKAGE BODY ieo_svr_values_pvt AS
2: /* $Header: IEOSVRVB.pls 120.1 2005/06/12 01:22:19 appldev $ */
3:
4:
5: PROCEDURE insert_row(

Line 20: FROM ieo_svr_values

16: , x_value VARCHAR2
17: ) IS
18: CURSOR l_insert IS
19: SELECT ROWID
20: FROM ieo_svr_values
21: WHERE value_id = x_value_id;
22: BEGIN
23: INSERT INTO ieo_svr_values (
24: value_id

Line 23: INSERT INTO ieo_svr_values (

19: SELECT ROWID
20: FROM ieo_svr_values
21: WHERE value_id = x_value_id;
22: BEGIN
23: INSERT INTO ieo_svr_values (
24: value_id
25: , created_by
26: , creation_date
27: , last_updated_by

Line 59: DELETE FROM ieo_svr_values

55: PROCEDURE delete_row(
56: x_value_id NUMBER
57: ) IS
58: BEGIN
59: DELETE FROM ieo_svr_values
60: WHERE value_id = x_value_id;
61: IF (SQL%NOTFOUND) THEN
62: RAISE NO_DATA_FOUND;
63: END IF;

Line 80: UPDATE ieo_svr_values

76: , x_server_id NUMBER
77: , x_value VARCHAR2
78: ) IS
79: BEGIN
80: UPDATE ieo_svr_values
81: SET
82: value_id=DECODE(x_value_id,FND_API.G_MISS_NUM,NULL,x_value_id)
83: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
84: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)

Line 113: FROM ieo_svr_values

109: , x_value VARCHAR2
110: ) IS
111: CURSOR l_lock IS
112: SELECT *
113: FROM ieo_svr_values
114: WHERE rowid = x_rowid
115: FOR UPDATE OF value_id NOWAIT;
116: l_table_rec l_lock%ROWTYPE;
117: BEGIN

Line 164: END ieo_svr_values_pvt;

160: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
161: APP_EXCEPTION.RAISE_EXCEPTION;
162: END IF;
163: END lock_row;
164: END ieo_svr_values_pvt;