APPS.CS_SYSTEMS_COMMON_PUB dependencies on CS_SYSTEMS_ALL_VL

Line 16: SELECT system_id INTO l_system_id FROM CS_SYSTEMS_ALL_VL WHERE name=p_system_name;

12: function get_system_id (p_system_name IN VARCHAR2) return NUMBER
13: is
14: l_system_id NUMBER(15);
15: begin
16: SELECT system_id INTO l_system_id FROM CS_SYSTEMS_ALL_VL WHERE name=p_system_name;
17: return l_system_id;
18: end get_system_id;
19:
20: procedure is_system_enabled(

Line 65: SELECT system_id INTO l_result FROM cs_systems_all_vl WHERE system_id=l_system_id AND (end_date_active IS null OR (end_date_active > l_curr_date));

61:
62: if (p_system_name is not null) then
63: l_system_id := get_system_id (p_system_name);
64: -- dbms_output.put_line ('system_id=' || l_system_id);
65: SELECT system_id INTO l_result FROM cs_systems_all_vl WHERE system_id=l_system_id AND (end_date_active IS null OR (end_date_active > l_curr_date));
66: -- dbms_output.put_line ('result=' || l_result);
67:
68: elsif (p_system_id > 0 ) then
69: SELECT system_id INTO l_result FROM cs_systems_all_vl WHERE system_id=p_system_id AND (end_date_active IS null OR (end_date_active > l_curr_date));

Line 69: SELECT system_id INTO l_result FROM cs_systems_all_vl WHERE system_id=p_system_id AND (end_date_active IS null OR (end_date_active > l_curr_date));

65: SELECT system_id INTO l_result FROM cs_systems_all_vl WHERE system_id=l_system_id AND (end_date_active IS null OR (end_date_active > l_curr_date));
66: -- dbms_output.put_line ('result=' || l_result);
67:
68: elsif (p_system_id > 0 ) then
69: SELECT system_id INTO l_result FROM cs_systems_all_vl WHERE system_id=p_system_id AND (end_date_active IS null OR (end_date_active > l_curr_date));
70:
71: else
72: l_result := -1;
73: end if;

Line 221: open x_system_data for SELECT distinct system_id, name FROM cs_systems_all_vl WHERE parent_system_id = l_system_id ORDER BY system_id;

217: l_system_id NUMBER(15);
218: begin
219: if (p_system_name is not null) then
220: l_system_id := get_system_id (p_system_name);
221: open x_system_data for SELECT distinct system_id, name FROM cs_systems_all_vl WHERE parent_system_id = l_system_id ORDER BY system_id;
222: x_return_status := FND_API.G_RET_STS_SUCCESS;
223:
224: elsif (p_system_id > 0) then
225: open x_system_data for SELECT distinct system_id, name FROM cs_systems_all_vl WHERE parent_system_id = p_system_id ORDER BY system_id;

Line 225: open x_system_data for SELECT distinct system_id, name FROM cs_systems_all_vl WHERE parent_system_id = p_system_id ORDER BY system_id;

221: open x_system_data for SELECT distinct system_id, name FROM cs_systems_all_vl WHERE parent_system_id = l_system_id ORDER BY system_id;
222: x_return_status := FND_API.G_RET_STS_SUCCESS;
223:
224: elsif (p_system_id > 0) then
225: open x_system_data for SELECT distinct system_id, name FROM cs_systems_all_vl WHERE parent_system_id = p_system_id ORDER BY system_id;
226: x_return_status := FND_API.G_RET_STS_SUCCESS;
227:
228: else
229: x_return_status := FND_API.G_RET_STS_ERROR;