DBA Data[Home] [Help]

APPS.IEO_SVR_SERVERS_PVT dependencies on FND_API

Line 46: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)

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)

Line 47: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)

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)

Line 48: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)

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)

Line 49: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)

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)

Line 50: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)

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)

Line 51: , DECODE(x_type_id,FND_API.G_MISS_NUM,NULL,x_type_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)

Line 52: , DECODE(x_server_name,FND_API.G_MISS_CHAR,NULL,x_server_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)

Line 53: , DECODE(x_member_svr_group_id,FND_API.G_MISS_NUM,NULL,x_member_svr_group_id)

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)

Line 54: , DECODE(x_using_svr_group_id,FND_API.G_MISS_NUM,NULL,x_using_svr_group_id)

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)

Line 55: , DECODE(x_dns_name,FND_API.G_MISS_CHAR,NULL,x_dns_name)

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)

Line 56: , DECODE(x_ip_address,FND_API.G_MISS_CHAR,NULL,x_ip_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: );

Line 57: , DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)

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:

Line 58: , DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)

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;

Line 59: , DECODE(x_user_address,FND_API.G_MISS_CHAR,NULL,x_user_address)

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;

Line 102: server_id=DECODE(x_server_id,FND_API.G_MISS_NUM,NULL,x_server_id)

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)

Line 103: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)

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)

Line 104: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)

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)

Line 105: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)

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)

Line 106: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)

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)

Line 107: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)

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)

Line 108: , type_id=DECODE(x_type_id,FND_API.G_MISS_NUM,NULL,x_type_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)

Line 109: , server_name=DECODE(x_server_name,FND_API.G_MISS_CHAR,NULL,x_server_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)

Line 110: , member_svr_group_id=DECODE(x_member_svr_group_id,FND_API.G_MISS_NUM,NULL,x_member_svr_group_id)

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)

Line 111: , using_svr_group_id=DECODE(x_using_svr_group_id,FND_API.G_MISS_NUM,NULL,x_using_svr_group_id)

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)

Line 112: , dns_name=DECODE(x_dns_name,FND_API.G_MISS_CHAR,NULL,x_dns_name)

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)

Line 113: , ip_address=DECODE(x_ip_address,FND_API.G_MISS_CHAR,NULL,x_ip_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;

Line 114: , location=DECODE(x_location,FND_API.G_MISS_CHAR,NULL,x_location)

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

Line 115: , description=DECODE(x_description,FND_API.G_MISS_CHAR,NULL,x_description)

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;

Line 116: , user_address=DECODE(x_user_address,FND_API.G_MISS_CHAR,NULL,x_user_address)

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;