APPS.IEO_MEDIA_PUB dependencies on IEO_MEDIA_RT_DEVICE_MAP

Line 49: update ieo_media_rt_device_map

45: x_msg_data := null;
46:
47: -- API body
48: --dbms_output.put_line('UPDATE_DEVICE_MAP: pre update data');
49: update ieo_media_rt_device_map
50: set server_id = p_server_id, device_available = p_is_device_available
51: where server_group_id = p_server_group_id and
52: media_type = p_media_type and
53: device_type = p_device_type and

Line 67: insert into ieo_media_rt_device_map

63: EXCEPTION
64: WHEN NO_DATA_FOUND then
65: -- insert row
66: --dbms_output.put_line('UPDATE_DEVICE_MAP:no data found');
67: insert into ieo_media_rt_device_map
68: (
69: server_group_id, media_type,
70: device_type, device_id,
71: device_available, server_id,

Line 81: ieo_media_rt_device_map_s1.nextval,

77: (
78: p_server_group_id, p_media_type,
79: p_device_type, p_device_id,
80: p_is_device_available, p_server_id,
81: ieo_media_rt_device_map_s1.nextval,
82: 1, sysdate, 1, sysdate, 1
83: );
84:
85: IF FND_API.To_Boolean( p_commit ) THEN

Line 183: from ieo_media_rt_device_map

179: || ' device_id = '|| p_device_id;
180: x_msg_count := 1;
181:
182: select server_id, device_map_id into x_server_id, x_device_map_id
183: from ieo_media_rt_device_map
184: where server_group_id = l_server_group_id and
185: media_type = p_media_type and
186: device_type = p_device_type and
187: device_id = p_device_id;