DBA Data[Home] [Help]

APPS.IEX_WEBSWITCH_PVT dependencies on DUAL

Line 42: FROM SYS.DUAL;

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;
43: begin
44: -- Standard begin of API savepoint
45: SAVEPOINT Create_WebSwitch_PUB;
46:

Line 137: FROM SYS.DUAL;

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;
141: CLOSE c_cgi_switch_seq;