42: , description
43: , user_address
44: ) VALUES (
45: x_server_id
46: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
47: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
48: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
49: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
50: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
43: , user_address
44: ) VALUES (
45: x_server_id
46: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
47: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
48: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
49: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
50: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
51: , DECODE(x_type_id,FND_API.G_MISS_NUM,NULL,x_type_id)
44: ) VALUES (
45: x_server_id
46: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
47: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
48: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
49: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
50: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
51: , DECODE(x_type_id,FND_API.G_MISS_NUM,NULL,x_type_id)
52: , DECODE(x_server_name,FND_API.G_MISS_CHAR,NULL,x_server_name)
45: x_server_id
46: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
47: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
48: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
49: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
50: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
51: , DECODE(x_type_id,FND_API.G_MISS_NUM,NULL,x_type_id)
52: , DECODE(x_server_name,FND_API.G_MISS_CHAR,NULL,x_server_name)
53: , DECODE(x_member_svr_group_id,FND_API.G_MISS_NUM,NULL,x_member_svr_group_id)
46: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
47: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
48: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
49: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
50: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
51: , DECODE(x_type_id,FND_API.G_MISS_NUM,NULL,x_type_id)
52: , DECODE(x_server_name,FND_API.G_MISS_CHAR,NULL,x_server_name)
53: , DECODE(x_member_svr_group_id,FND_API.G_MISS_NUM,NULL,x_member_svr_group_id)
54: , DECODE(x_using_svr_group_id,FND_API.G_MISS_NUM,NULL,x_using_svr_group_id)
47: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
48: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
49: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
50: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
51: , DECODE(x_type_id,FND_API.G_MISS_NUM,NULL,x_type_id)
52: , DECODE(x_server_name,FND_API.G_MISS_CHAR,NULL,x_server_name)
53: , DECODE(x_member_svr_group_id,FND_API.G_MISS_NUM,NULL,x_member_svr_group_id)
54: , DECODE(x_using_svr_group_id,FND_API.G_MISS_NUM,NULL,x_using_svr_group_id)
55: , DECODE(x_dns_name,FND_API.G_MISS_CHAR,NULL,x_dns_name)
48: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
49: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
50: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
51: , DECODE(x_type_id,FND_API.G_MISS_NUM,NULL,x_type_id)
52: , DECODE(x_server_name,FND_API.G_MISS_CHAR,NULL,x_server_name)
53: , DECODE(x_member_svr_group_id,FND_API.G_MISS_NUM,NULL,x_member_svr_group_id)
54: , DECODE(x_using_svr_group_id,FND_API.G_MISS_NUM,NULL,x_using_svr_group_id)
55: , DECODE(x_dns_name,FND_API.G_MISS_CHAR,NULL,x_dns_name)
56: , DECODE(x_ip_address,FND_API.G_MISS_CHAR,NULL,x_ip_address)
49: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
50: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
51: , DECODE(x_type_id,FND_API.G_MISS_NUM,NULL,x_type_id)
52: , DECODE(x_server_name,FND_API.G_MISS_CHAR,NULL,x_server_name)
53: , DECODE(x_member_svr_group_id,FND_API.G_MISS_NUM,NULL,x_member_svr_group_id)
54: , DECODE(x_using_svr_group_id,FND_API.G_MISS_NUM,NULL,x_using_svr_group_id)
55: , DECODE(x_dns_name,FND_API.G_MISS_CHAR,NULL,x_dns_name)
56: , DECODE(x_ip_address,FND_API.G_MISS_CHAR,NULL,x_ip_address)
57: , DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
50: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
51: , DECODE(x_type_id,FND_API.G_MISS_NUM,NULL,x_type_id)
52: , DECODE(x_server_name,FND_API.G_MISS_CHAR,NULL,x_server_name)
53: , DECODE(x_member_svr_group_id,FND_API.G_MISS_NUM,NULL,x_member_svr_group_id)
54: , DECODE(x_using_svr_group_id,FND_API.G_MISS_NUM,NULL,x_using_svr_group_id)
55: , DECODE(x_dns_name,FND_API.G_MISS_CHAR,NULL,x_dns_name)
56: , DECODE(x_ip_address,FND_API.G_MISS_CHAR,NULL,x_ip_address)
57: , DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
58: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
51: , DECODE(x_type_id,FND_API.G_MISS_NUM,NULL,x_type_id)
52: , DECODE(x_server_name,FND_API.G_MISS_CHAR,NULL,x_server_name)
53: , DECODE(x_member_svr_group_id,FND_API.G_MISS_NUM,NULL,x_member_svr_group_id)
54: , DECODE(x_using_svr_group_id,FND_API.G_MISS_NUM,NULL,x_using_svr_group_id)
55: , DECODE(x_dns_name,FND_API.G_MISS_CHAR,NULL,x_dns_name)
56: , DECODE(x_ip_address,FND_API.G_MISS_CHAR,NULL,x_ip_address)
57: , DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
58: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
59: , DECODE(x_user_address,FND_API.G_MISS_CHAR,NULL,x_user_address)
52: , DECODE(x_server_name,FND_API.G_MISS_CHAR,NULL,x_server_name)
53: , DECODE(x_member_svr_group_id,FND_API.G_MISS_NUM,NULL,x_member_svr_group_id)
54: , DECODE(x_using_svr_group_id,FND_API.G_MISS_NUM,NULL,x_using_svr_group_id)
55: , DECODE(x_dns_name,FND_API.G_MISS_CHAR,NULL,x_dns_name)
56: , DECODE(x_ip_address,FND_API.G_MISS_CHAR,NULL,x_ip_address)
57: , DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
58: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
59: , DECODE(x_user_address,FND_API.G_MISS_CHAR,NULL,x_user_address)
60: );
53: , DECODE(x_member_svr_group_id,FND_API.G_MISS_NUM,NULL,x_member_svr_group_id)
54: , DECODE(x_using_svr_group_id,FND_API.G_MISS_NUM,NULL,x_using_svr_group_id)
55: , DECODE(x_dns_name,FND_API.G_MISS_CHAR,NULL,x_dns_name)
56: , DECODE(x_ip_address,FND_API.G_MISS_CHAR,NULL,x_ip_address)
57: , DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
58: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
59: , DECODE(x_user_address,FND_API.G_MISS_CHAR,NULL,x_user_address)
60: );
61:
54: , DECODE(x_using_svr_group_id,FND_API.G_MISS_NUM,NULL,x_using_svr_group_id)
55: , DECODE(x_dns_name,FND_API.G_MISS_CHAR,NULL,x_dns_name)
56: , DECODE(x_ip_address,FND_API.G_MISS_CHAR,NULL,x_ip_address)
57: , DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
58: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
59: , DECODE(x_user_address,FND_API.G_MISS_CHAR,NULL,x_user_address)
60: );
61:
62: OPEN l_insert;
55: , DECODE(x_dns_name,FND_API.G_MISS_CHAR,NULL,x_dns_name)
56: , DECODE(x_ip_address,FND_API.G_MISS_CHAR,NULL,x_ip_address)
57: , DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
58: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
59: , DECODE(x_user_address,FND_API.G_MISS_CHAR,NULL,x_user_address)
60: );
61:
62: OPEN l_insert;
63: FETCH l_insert INTO x_rowid;
98: ) IS
99: BEGIN
100: UPDATE ieo_svr_servers
101: SET
102: server_id=DECODE(x_server_id,FND_API.G_MISS_NUM,NULL,x_server_id)
103: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
104: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
105: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
106: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
99: BEGIN
100: UPDATE ieo_svr_servers
101: SET
102: server_id=DECODE(x_server_id,FND_API.G_MISS_NUM,NULL,x_server_id)
103: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
104: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
105: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
106: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
107: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
100: UPDATE ieo_svr_servers
101: SET
102: server_id=DECODE(x_server_id,FND_API.G_MISS_NUM,NULL,x_server_id)
103: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
104: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
105: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
106: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
107: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
108: , type_id=DECODE(x_type_id,FND_API.G_MISS_NUM,NULL,x_type_id)
101: SET
102: server_id=DECODE(x_server_id,FND_API.G_MISS_NUM,NULL,x_server_id)
103: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
104: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
105: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
106: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
107: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
108: , type_id=DECODE(x_type_id,FND_API.G_MISS_NUM,NULL,x_type_id)
109: , server_name=DECODE(x_server_name,FND_API.G_MISS_CHAR,NULL,x_server_name)
102: server_id=DECODE(x_server_id,FND_API.G_MISS_NUM,NULL,x_server_id)
103: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
104: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
105: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
106: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
107: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
108: , type_id=DECODE(x_type_id,FND_API.G_MISS_NUM,NULL,x_type_id)
109: , server_name=DECODE(x_server_name,FND_API.G_MISS_CHAR,NULL,x_server_name)
110: , member_svr_group_id=DECODE(x_member_svr_group_id,FND_API.G_MISS_NUM,NULL,x_member_svr_group_id)
103: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
104: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
105: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
106: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
107: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
108: , type_id=DECODE(x_type_id,FND_API.G_MISS_NUM,NULL,x_type_id)
109: , server_name=DECODE(x_server_name,FND_API.G_MISS_CHAR,NULL,x_server_name)
110: , member_svr_group_id=DECODE(x_member_svr_group_id,FND_API.G_MISS_NUM,NULL,x_member_svr_group_id)
111: , using_svr_group_id=DECODE(x_using_svr_group_id,FND_API.G_MISS_NUM,NULL,x_using_svr_group_id)
104: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
105: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
106: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
107: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
108: , type_id=DECODE(x_type_id,FND_API.G_MISS_NUM,NULL,x_type_id)
109: , server_name=DECODE(x_server_name,FND_API.G_MISS_CHAR,NULL,x_server_name)
110: , member_svr_group_id=DECODE(x_member_svr_group_id,FND_API.G_MISS_NUM,NULL,x_member_svr_group_id)
111: , using_svr_group_id=DECODE(x_using_svr_group_id,FND_API.G_MISS_NUM,NULL,x_using_svr_group_id)
112: , dns_name=DECODE(x_dns_name,FND_API.G_MISS_CHAR,NULL,x_dns_name)
105: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
106: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
107: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
108: , type_id=DECODE(x_type_id,FND_API.G_MISS_NUM,NULL,x_type_id)
109: , server_name=DECODE(x_server_name,FND_API.G_MISS_CHAR,NULL,x_server_name)
110: , member_svr_group_id=DECODE(x_member_svr_group_id,FND_API.G_MISS_NUM,NULL,x_member_svr_group_id)
111: , using_svr_group_id=DECODE(x_using_svr_group_id,FND_API.G_MISS_NUM,NULL,x_using_svr_group_id)
112: , dns_name=DECODE(x_dns_name,FND_API.G_MISS_CHAR,NULL,x_dns_name)
113: , ip_address=DECODE(x_ip_address,FND_API.G_MISS_CHAR,NULL,x_ip_address)
106: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
107: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
108: , type_id=DECODE(x_type_id,FND_API.G_MISS_NUM,NULL,x_type_id)
109: , server_name=DECODE(x_server_name,FND_API.G_MISS_CHAR,NULL,x_server_name)
110: , member_svr_group_id=DECODE(x_member_svr_group_id,FND_API.G_MISS_NUM,NULL,x_member_svr_group_id)
111: , using_svr_group_id=DECODE(x_using_svr_group_id,FND_API.G_MISS_NUM,NULL,x_using_svr_group_id)
112: , dns_name=DECODE(x_dns_name,FND_API.G_MISS_CHAR,NULL,x_dns_name)
113: , ip_address=DECODE(x_ip_address,FND_API.G_MISS_CHAR,NULL,x_ip_address)
114: , location=DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
107: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
108: , type_id=DECODE(x_type_id,FND_API.G_MISS_NUM,NULL,x_type_id)
109: , server_name=DECODE(x_server_name,FND_API.G_MISS_CHAR,NULL,x_server_name)
110: , member_svr_group_id=DECODE(x_member_svr_group_id,FND_API.G_MISS_NUM,NULL,x_member_svr_group_id)
111: , using_svr_group_id=DECODE(x_using_svr_group_id,FND_API.G_MISS_NUM,NULL,x_using_svr_group_id)
112: , dns_name=DECODE(x_dns_name,FND_API.G_MISS_CHAR,NULL,x_dns_name)
113: , ip_address=DECODE(x_ip_address,FND_API.G_MISS_CHAR,NULL,x_ip_address)
114: , location=DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
115: , description=DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
108: , type_id=DECODE(x_type_id,FND_API.G_MISS_NUM,NULL,x_type_id)
109: , server_name=DECODE(x_server_name,FND_API.G_MISS_CHAR,NULL,x_server_name)
110: , member_svr_group_id=DECODE(x_member_svr_group_id,FND_API.G_MISS_NUM,NULL,x_member_svr_group_id)
111: , using_svr_group_id=DECODE(x_using_svr_group_id,FND_API.G_MISS_NUM,NULL,x_using_svr_group_id)
112: , dns_name=DECODE(x_dns_name,FND_API.G_MISS_CHAR,NULL,x_dns_name)
113: , ip_address=DECODE(x_ip_address,FND_API.G_MISS_CHAR,NULL,x_ip_address)
114: , location=DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
115: , description=DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
116: , user_address=DECODE(x_user_address,FND_API.G_MISS_CHAR,NULL,x_user_address)
109: , server_name=DECODE(x_server_name,FND_API.G_MISS_CHAR,NULL,x_server_name)
110: , member_svr_group_id=DECODE(x_member_svr_group_id,FND_API.G_MISS_NUM,NULL,x_member_svr_group_id)
111: , using_svr_group_id=DECODE(x_using_svr_group_id,FND_API.G_MISS_NUM,NULL,x_using_svr_group_id)
112: , dns_name=DECODE(x_dns_name,FND_API.G_MISS_CHAR,NULL,x_dns_name)
113: , ip_address=DECODE(x_ip_address,FND_API.G_MISS_CHAR,NULL,x_ip_address)
114: , location=DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
115: , description=DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
116: , user_address=DECODE(x_user_address,FND_API.G_MISS_CHAR,NULL,x_user_address)
117: WHERE ROWID = x_rowid;
110: , member_svr_group_id=DECODE(x_member_svr_group_id,FND_API.G_MISS_NUM,NULL,x_member_svr_group_id)
111: , using_svr_group_id=DECODE(x_using_svr_group_id,FND_API.G_MISS_NUM,NULL,x_using_svr_group_id)
112: , dns_name=DECODE(x_dns_name,FND_API.G_MISS_CHAR,NULL,x_dns_name)
113: , ip_address=DECODE(x_ip_address,FND_API.G_MISS_CHAR,NULL,x_ip_address)
114: , location=DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
115: , description=DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
116: , user_address=DECODE(x_user_address,FND_API.G_MISS_CHAR,NULL,x_user_address)
117: WHERE ROWID = x_rowid;
118: IF (SQL%NOTFOUND) THEN
111: , using_svr_group_id=DECODE(x_using_svr_group_id,FND_API.G_MISS_NUM,NULL,x_using_svr_group_id)
112: , dns_name=DECODE(x_dns_name,FND_API.G_MISS_CHAR,NULL,x_dns_name)
113: , ip_address=DECODE(x_ip_address,FND_API.G_MISS_CHAR,NULL,x_ip_address)
114: , location=DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
115: , description=DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
116: , user_address=DECODE(x_user_address,FND_API.G_MISS_CHAR,NULL,x_user_address)
117: WHERE ROWID = x_rowid;
118: IF (SQL%NOTFOUND) THEN
119: RAISE NO_DATA_FOUND;
112: , dns_name=DECODE(x_dns_name,FND_API.G_MISS_CHAR,NULL,x_dns_name)
113: , ip_address=DECODE(x_ip_address,FND_API.G_MISS_CHAR,NULL,x_ip_address)
114: , location=DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)
115: , description=DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)
116: , user_address=DECODE(x_user_address,FND_API.G_MISS_CHAR,NULL,x_user_address)
117: WHERE ROWID = x_rowid;
118: IF (SQL%NOTFOUND) THEN
119: RAISE NO_DATA_FOUND;
120: END IF;