DBA Data[Home] [Help]

APPS.IEX_WEBSWITCH_PVT dependencies on IEX_CGI_SWITCHES_S

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;