APPS.BIS_VG_UTIL dependencies on DBMS_SQL

Line 206: l_CursorID := DBMS_SQL.OPEN_CURSOR;

202: l_String := REPLACE(l_String, '^', '_');
203: l_String := REPLACE(l_String, '-', '_');
204: l_SQL_text := 'SELECT NULL ' || l_String || ' FROM DUAL';
205: BEGIN
206: l_CursorID := DBMS_SQL.OPEN_CURSOR;
207: DBMS_SQL.PARSE(l_CursorID, l_SQL_text, DBMS_SQL.NATIVE);
208: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
209: EXCEPTION
210: WHEN OTHERS THEN

Line 207: DBMS_SQL.PARSE(l_CursorID, l_SQL_text, DBMS_SQL.NATIVE);

203: l_String := REPLACE(l_String, '-', '_');
204: l_SQL_text := 'SELECT NULL ' || l_String || ' FROM DUAL';
205: BEGIN
206: l_CursorID := DBMS_SQL.OPEN_CURSOR;
207: DBMS_SQL.PARSE(l_CursorID, l_SQL_text, DBMS_SQL.NATIVE);
208: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
209: EXCEPTION
210: WHEN OTHERS THEN
211: l_String := '"' || l_String || '"';

Line 208: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

204: l_SQL_text := 'SELECT NULL ' || l_String || ' FROM DUAL';
205: BEGIN
206: l_CursorID := DBMS_SQL.OPEN_CURSOR;
207: DBMS_SQL.PARSE(l_CursorID, l_SQL_text, DBMS_SQL.NATIVE);
208: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
209: EXCEPTION
210: WHEN OTHERS THEN
211: l_String := '"' || l_String || '"';
212: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

Line 212: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

208: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
209: EXCEPTION
210: WHEN OTHERS THEN
211: l_String := '"' || l_String || '"';
212: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
213: END;
214: RETURN l_String;
215: bis_debug_pub.Add('< get_string_len30');
216: