APPS.IEO_SVR_GROUPS_PVT dependencies on IEO_SVR_GROUPS

Line 1: PACKAGE BODY ieo_svr_groups_pvt AS

1: PACKAGE BODY ieo_svr_groups_pvt AS
2: /* $Header: IEOSVRGB.pls 120.1 2005/06/12 01:21:33 appldev $ */
3:
4:
5: PROCEDURE insert_row(

Line 20: FROM ieo_svr_groups

16: , x_description VARCHAR2
17: ) IS
18: CURSOR l_insert IS
19: SELECT ROWID
20: FROM ieo_svr_groups
21: WHERE server_group_id = x_server_group_id;
22: BEGIN
23: INSERT INTO ieo_svr_groups (
24: server_group_id

Line 23: INSERT INTO ieo_svr_groups (

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

Line 59: DELETE FROM ieo_svr_groups

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

Line 80: UPDATE ieo_svr_groups

76: , x_location VARCHAR2
77: , x_description VARCHAR2
78: ) IS
79: BEGIN
80: UPDATE ieo_svr_groups
81: SET
82: server_group_id=DECODE(x_server_group_id,FND_API.G_MISS_NUM,NULL,x_server_group_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_groups

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

Line 164: END ieo_svr_groups_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_groups_pvt;