APPS.ORACLEPLUGS dependencies on DBMS_SQL

Line 1292: l_call := dbms_sql.open_cursor;

1288: if l_plsql_call is not null
1289: then
1290: begin
1291: l_plsql_call := l_plsql_call||'(p_session_id => '||l_session_id||', p_plug_id => '||p.plug_id||', p_delete => ''Y'')';
1292: l_call := dbms_sql.open_cursor;
1293: dbms_sql.parse(l_call,'begin '||l_plsql_call||'; end;',dbms_sql.native);
1294: l_dummy := dbms_sql.execute(l_call);
1295: dbms_sql.close_cursor(l_call);
1296: exception

Line 1293: dbms_sql.parse(l_call,'begin '||l_plsql_call||'; end;',dbms_sql.native);

1289: then
1290: begin
1291: l_plsql_call := l_plsql_call||'(p_session_id => '||l_session_id||', p_plug_id => '||p.plug_id||', p_delete => ''Y'')';
1292: l_call := dbms_sql.open_cursor;
1293: dbms_sql.parse(l_call,'begin '||l_plsql_call||'; end;',dbms_sql.native);
1294: l_dummy := dbms_sql.execute(l_call);
1295: dbms_sql.close_cursor(l_call);
1296: exception
1297: when others then

Line 1294: l_dummy := dbms_sql.execute(l_call);

1290: begin
1291: l_plsql_call := l_plsql_call||'(p_session_id => '||l_session_id||', p_plug_id => '||p.plug_id||', p_delete => ''Y'')';
1292: l_call := dbms_sql.open_cursor;
1293: dbms_sql.parse(l_call,'begin '||l_plsql_call||'; end;',dbms_sql.native);
1294: l_dummy := dbms_sql.execute(l_call);
1295: dbms_sql.close_cursor(l_call);
1296: exception
1297: when others then
1298: l_count := l_count;

Line 1295: dbms_sql.close_cursor(l_call);

1291: l_plsql_call := l_plsql_call||'(p_session_id => '||l_session_id||', p_plug_id => '||p.plug_id||', p_delete => ''Y'')';
1292: l_call := dbms_sql.open_cursor;
1293: dbms_sql.parse(l_call,'begin '||l_plsql_call||'; end;',dbms_sql.native);
1294: l_dummy := dbms_sql.execute(l_call);
1295: dbms_sql.close_cursor(l_call);
1296: exception
1297: when others then
1298: l_count := l_count;
1299: end;