APPS.IEX_WEBSWITCH_PKG dependencies on IEX_CGI_SWITCHES

Line 31: CURSOR c1 IS SELECT 'X' FROM iex_cgi_switches

27: l_return_status VARCHAR2(1);
28: l_msg_count NUMBER;
29: l_msg_data VARCHAR2(32767);
30:
31: CURSOR c1 IS SELECT 'X' FROM iex_cgi_switches
32: WHERE cgi_switch_id = p_cgi_switch_rec.cgi_switch_id;
33:
34: CURSOR c2 IS SELECT 'X' FROM iex_switch_data
35: WHERE switch_data_id = p_switch_data_rec.switch_data_id;

Line 68: INSERT INTO iex_cgi_switches(

64: OPEN c1;
65: FETCH c1 INTO l_dummy;
66: IF c1%notfound THEN
67:
68: INSERT INTO iex_cgi_switches(
69: cgi_switch_id,
70: query_string_id,
71: enabled_flag,
72: object_version_number,

Line 306: UPDATE iex_cgi_switches

302: -- Initialize API return status to success
303: x_return_status := FND_API.G_RET_STS_SUCCESS;
304:
305: -- API body
306: UPDATE iex_cgi_switches
307: SET
308: switch_code = p_cgi_switch_rec.switch_code,
309: switch_type = p_cgi_switch_rec.switch_type,
310: enabled_flag = p_cgi_switch_rec.enabled_flag,

Line 459: FROM iex_cgi_switches

455: -- API body
456: DECLARE
457: v_dummy CHAR(1);
458: CURSOR c1 IS SELECT 'X'
459: FROM iex_cgi_switches
460: WHERE cgi_switch_id = p_cgi_switch_rec.cgi_switch_id
461: FOR UPDATE;
462: BEGIN
463: OPEN c1;

Line 590: DELETE FROM iex_cgi_switches

586: END IF;
587:
588:
589: IF p_cgi_switch_rec.cgi_switch_id IS NOT NULL THEN
590: DELETE FROM iex_cgi_switches
591: WHERE cgi_switch_id = p_cgi_switch_rec.cgi_switch_id;
592: END IF;
593:
594: -- Standard check of p_commit.