APPS.BSC_DESIGNER_PVT dependencies on DBMS_SQL

Line 1627: h_cursor := DBMS_SQL.OPEN_CURSOR;

1623: h_sql := h_sql || ' ORDER BY USER_CODE';
1624: END IF;
1625: --DBMS_OUTPUT.PUT_LINE(h_sql);
1626:
1627: h_cursor := DBMS_SQL.OPEN_CURSOR;
1628: DBMS_SQL.PARSE(h_cursor, h_sql, DBMS_SQL.NATIVE);
1629: DBMS_SQL.DEFINE_COLUMN(h_cursor,1,h_name,100);
1630: h_ret := DBMS_SQL.EXECUTE(h_cursor);
1631: IF DBMS_SQL.FETCH_ROWS(h_cursor) > 0 THEN

Line 1628: DBMS_SQL.PARSE(h_cursor, h_sql, DBMS_SQL.NATIVE);

1624: END IF;
1625: --DBMS_OUTPUT.PUT_LINE(h_sql);
1626:
1627: h_cursor := DBMS_SQL.OPEN_CURSOR;
1628: DBMS_SQL.PARSE(h_cursor, h_sql, DBMS_SQL.NATIVE);
1629: DBMS_SQL.DEFINE_COLUMN(h_cursor,1,h_name,100);
1630: h_ret := DBMS_SQL.EXECUTE(h_cursor);
1631: IF DBMS_SQL.FETCH_ROWS(h_cursor) > 0 THEN
1632: DBMS_SQL.COLUMN_VALUE(h_cursor, 1, h_name);

Line 1629: DBMS_SQL.DEFINE_COLUMN(h_cursor,1,h_name,100);

1625: --DBMS_OUTPUT.PUT_LINE(h_sql);
1626:
1627: h_cursor := DBMS_SQL.OPEN_CURSOR;
1628: DBMS_SQL.PARSE(h_cursor, h_sql, DBMS_SQL.NATIVE);
1629: DBMS_SQL.DEFINE_COLUMN(h_cursor,1,h_name,100);
1630: h_ret := DBMS_SQL.EXECUTE(h_cursor);
1631: IF DBMS_SQL.FETCH_ROWS(h_cursor) > 0 THEN
1632: DBMS_SQL.COLUMN_VALUE(h_cursor, 1, h_name);
1633: ELSE

Line 1630: h_ret := DBMS_SQL.EXECUTE(h_cursor);

1626:
1627: h_cursor := DBMS_SQL.OPEN_CURSOR;
1628: DBMS_SQL.PARSE(h_cursor, h_sql, DBMS_SQL.NATIVE);
1629: DBMS_SQL.DEFINE_COLUMN(h_cursor,1,h_name,100);
1630: h_ret := DBMS_SQL.EXECUTE(h_cursor);
1631: IF DBMS_SQL.FETCH_ROWS(h_cursor) > 0 THEN
1632: DBMS_SQL.COLUMN_VALUE(h_cursor, 1, h_name);
1633: ELSE
1634: h_name := ' ';

Line 1631: IF DBMS_SQL.FETCH_ROWS(h_cursor) > 0 THEN

1627: h_cursor := DBMS_SQL.OPEN_CURSOR;
1628: DBMS_SQL.PARSE(h_cursor, h_sql, DBMS_SQL.NATIVE);
1629: DBMS_SQL.DEFINE_COLUMN(h_cursor,1,h_name,100);
1630: h_ret := DBMS_SQL.EXECUTE(h_cursor);
1631: IF DBMS_SQL.FETCH_ROWS(h_cursor) > 0 THEN
1632: DBMS_SQL.COLUMN_VALUE(h_cursor, 1, h_name);
1633: ELSE
1634: h_name := ' ';
1635: END IF;

Line 1632: DBMS_SQL.COLUMN_VALUE(h_cursor, 1, h_name);

1628: DBMS_SQL.PARSE(h_cursor, h_sql, DBMS_SQL.NATIVE);
1629: DBMS_SQL.DEFINE_COLUMN(h_cursor,1,h_name,100);
1630: h_ret := DBMS_SQL.EXECUTE(h_cursor);
1631: IF DBMS_SQL.FETCH_ROWS(h_cursor) > 0 THEN
1632: DBMS_SQL.COLUMN_VALUE(h_cursor, 1, h_name);
1633: ELSE
1634: h_name := ' ';
1635: END IF;
1636: DBMS_SQL.CLOSE_CURSOR(h_cursor);

Line 1636: DBMS_SQL.CLOSE_CURSOR(h_cursor);

1632: DBMS_SQL.COLUMN_VALUE(h_cursor, 1, h_name);
1633: ELSE
1634: h_name := ' ';
1635: END IF;
1636: DBMS_SQL.CLOSE_CURSOR(h_cursor);
1637:
1638: RETURN h_name;
1639:
1640: EXCEPTION