APPS.QLTTRAFB dependencies on DBMS_SQL

Line 29: val dbms_sql.varchar2s;

25:
26: s VARCHAR2(2000) := p_cols;
27: p INTEGER;
28: i INTEGER := 1;
29: val dbms_sql.varchar2s;
30:
31: BEGIN
32: val(1) := '';
33: val(2) := '';

Line 334: CUR := DBMS_SQL.OPEN_CURSOR;

330: PROCEDURE EXEC_SQL (STRING IN VARCHAR2) IS
331: CUR INTEGER;
332: RET INTEGER;
333: BEGIN
334: CUR := DBMS_SQL.OPEN_CURSOR;
335: DBMS_SQL.PARSE(CUR, STRING, DBMS_SQL.NATIVE);
336: RET := DBMS_SQL.EXECUTE(CUR);
337: DBMS_SQL.CLOSE_CURSOR(CUR);
338:

Line 335: DBMS_SQL.PARSE(CUR, STRING, DBMS_SQL.NATIVE);

331: CUR INTEGER;
332: RET INTEGER;
333: BEGIN
334: CUR := DBMS_SQL.OPEN_CURSOR;
335: DBMS_SQL.PARSE(CUR, STRING, DBMS_SQL.NATIVE);
336: RET := DBMS_SQL.EXECUTE(CUR);
337: DBMS_SQL.CLOSE_CURSOR(CUR);
338:
339: exception when others then

Line 336: RET := DBMS_SQL.EXECUTE(CUR);

332: RET INTEGER;
333: BEGIN
334: CUR := DBMS_SQL.OPEN_CURSOR;
335: DBMS_SQL.PARSE(CUR, STRING, DBMS_SQL.NATIVE);
336: RET := DBMS_SQL.EXECUTE(CUR);
337: DBMS_SQL.CLOSE_CURSOR(CUR);
338:
339: exception when others then
340: IF dbms_sql.is_open(cur) THEN

Line 337: DBMS_SQL.CLOSE_CURSOR(CUR);

333: BEGIN
334: CUR := DBMS_SQL.OPEN_CURSOR;
335: DBMS_SQL.PARSE(CUR, STRING, DBMS_SQL.NATIVE);
336: RET := DBMS_SQL.EXECUTE(CUR);
337: DBMS_SQL.CLOSE_CURSOR(CUR);
338:
339: exception when others then
340: IF dbms_sql.is_open(cur) THEN
341: dbms_sql.close_cursor(cur);

Line 340: IF dbms_sql.is_open(cur) THEN

336: RET := DBMS_SQL.EXECUTE(CUR);
337: DBMS_SQL.CLOSE_CURSOR(CUR);
338:
339: exception when others then
340: IF dbms_sql.is_open(cur) THEN
341: dbms_sql.close_cursor(cur);
342: END IF;
343: raise;
344: END EXEC_SQL;

Line 341: dbms_sql.close_cursor(cur);

337: DBMS_SQL.CLOSE_CURSOR(CUR);
338:
339: exception when others then
340: IF dbms_sql.is_open(cur) THEN
341: dbms_sql.close_cursor(cur);
342: END IF;
343: raise;
344: END EXEC_SQL;
345: