APPS.IEX_WEBSWITCH_PVT dependencies on IEX_CGI_SWITCHES

Line 38: FROM IEX_CGI_SWITCHES

34: l_cgi_switch_id NUMBER;
35: l_switch_data_id NUMBER;
36:
37: CURSOR c_cgi_switch IS SELECT CGI_SWITCH_ID
38: FROM IEX_CGI_SWITCHES
39: WHERE QUERY_STRING_ID =l_cgi_switch_rec.QUERY_STRING_ID
40: AND SWITCH_CODE = l_cgi_switch_rec.SWITCH_CODE;
41: CURSOR c_switch_data IS SELECT IEX_SWITCH_DATA_S.NEXTVAL
42: FROM SYS.DUAL;

Line 136: CURSOR c_cgi_switch_seq IS SELECT IEX_CGI_SWITCHES_S.NEXTVAL

132: FETCH c_cgi_switch INTO l_cgi_switch_id;
133: IF c_cgi_switch%NOTFOUND THEN
134: CLOSE c_cgi_switch;
135: DECLARE
136: CURSOR c_cgi_switch_seq IS SELECT IEX_CGI_SWITCHES_S.NEXTVAL
137: FROM SYS.DUAL;
138: BEGIN
139: OPEN c_cgi_switch_seq;
140: FETCH c_cgi_switch_seq INTO l_cgi_switch_id;