32: , location
33: , description
34: ) VALUES (
35: x_server_group_id
36: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
37: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
38: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
39: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
40: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
33: , description
34: ) VALUES (
35: x_server_group_id
36: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
37: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
38: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
39: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
40: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
41: , DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
34: ) VALUES (
35: x_server_group_id
36: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
37: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
38: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
39: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
40: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
41: , DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
42: , DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
35: x_server_group_id
36: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
37: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
38: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
39: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
40: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
41: , DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
42: , DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
43: , DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
36: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
37: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
38: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
39: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
40: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
41: , DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
42: , DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
43: , DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
44: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
37: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
38: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
39: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
40: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
41: , DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
42: , DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
43: , DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
44: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
45: );
38: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
39: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
40: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
41: , DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
42: , DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
43: , DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
44: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
45: );
46:
39: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
40: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
41: , DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
42: , DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
43: , DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
44: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
45: );
46:
47: OPEN l_insert;
40: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
41: , DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
42: , DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
43: , DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
44: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
45: );
46:
47: OPEN l_insert;
48: FETCH l_insert INTO x_rowid;
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)
85: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
86: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
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)
85: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
86: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
87: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
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)
85: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
86: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
87: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
88: , group_name=DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
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)
85: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
86: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
87: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
88: , group_name=DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
89: , group_group_id=DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
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)
85: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
86: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
87: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
88: , group_name=DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
89: , group_group_id=DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
90: , location=DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
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)
85: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
86: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
87: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
88: , group_name=DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
89: , group_group_id=DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
90: , location=DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
91: , description=DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
84: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
85: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
86: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
87: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
88: , group_name=DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
89: , group_group_id=DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
90: , location=DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
91: , description=DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
92: WHERE ROWID = x_rowid;
85: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
86: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
87: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
88: , group_name=DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
89: , group_group_id=DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
90: , location=DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
91: , description=DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
92: WHERE ROWID = x_rowid;
93: IF (SQL%NOTFOUND) THEN
86: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
87: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
88: , group_name=DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
89: , group_group_id=DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
90: , location=DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
91: , description=DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
92: WHERE ROWID = x_rowid;
93: IF (SQL%NOTFOUND) THEN
94: RAISE NO_DATA_FOUND;
87: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
88: , group_name=DECODE(x_group_name,FND_API.G_MISS_CHAR,NULL,x_group_name)
89: , group_group_id=DECODE(x_group_group_id,FND_API.G_MISS_NUM,NULL,x_group_group_id)
90: , location=DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
91: , description=DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
92: WHERE ROWID = x_rowid;
93: IF (SQL%NOTFOUND) THEN
94: RAISE NO_DATA_FOUND;
95: END IF;