APPS.IEX_WEBSWITCH_PKG dependencies on IEX_SWITCH_DATA

Line 34: CURSOR c2 IS SELECT 'X' FROM iex_switch_data

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;
36:
37: l_dummy char(1);
38:

Line 138: INSERT INTO iex_switch_data(

134:
135: OPEN c2;
136: FETCH c2 INTO l_dummy;
137: IF c2%notfound THEN
138: INSERT INTO iex_switch_data(
139: switch_data_id,
140: cgi_switch_id,
141: enabled_flag,
142: object_version_number,

Line 336: UPDATE iex_switch_data

332: attribute15 = p_cgi_switch_rec.attribute15
333: WHERE query_string_id = p_cgi_switch_rec.query_string_id
334: AND cgi_switch_id = p_cgi_switch_rec.cgi_switch_id;
335:
336: UPDATE iex_switch_data
337: SET
338: first_name_yn = p_switch_data_rec.first_name_yn,
339: last_name_yn = p_switch_data_rec.last_name_yn,
340: address_yn = p_switch_data_rec.address_yn,

Line 471: FROM iex_switch_data

467:
468: DECLARE
469: v_dummy Char(1);
470: CURSOR c1 IS SELECT 'X'
471: FROM iex_switch_data
472: WHERE switch_data_id = p_switch_data_rec.switch_data_id
473: FOR UPDATE;
474: BEGIN
475: OPEN c1;

Line 584: DELETE FROM iex_switch_data

580: x_return_status := FND_API.G_RET_STS_SUCCESS;
581:
582: -- API body
583: IF p_switch_data_rec.switch_data_id IS NOT NULL THEN
584: DELETE FROM iex_switch_data
585: WHERE switch_data_id = p_switch_data_rec.switch_data_id;
586: END IF;
587:
588: