APPS.FLM_SEQ_ID2NAME dependencies on DBMS_SQL

Line 292: l_cursor := DBMS_SQL.OPEN_CURSOR;

288:
289: l_query := l_query || ' WHERE ID_VALUE=:column_value';
290: flm_util.add_bind(':column_value', p_value);
291:
292: l_cursor := DBMS_SQL.OPEN_CURSOR;
293: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
294: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_name, 240);
295:
296: flm_util.do_binds(l_cursor);

Line 293: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);

289: l_query := l_query || ' WHERE ID_VALUE=:column_value';
290: flm_util.add_bind(':column_value', p_value);
291:
292: l_cursor := DBMS_SQL.OPEN_CURSOR;
293: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
294: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_name, 240);
295:
296: flm_util.do_binds(l_cursor);
297:

Line 294: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_name, 240);

290: flm_util.add_bind(':column_value', p_value);
291:
292: l_cursor := DBMS_SQL.OPEN_CURSOR;
293: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
294: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_name, 240);
295:
296: flm_util.do_binds(l_cursor);
297:
298: l_dummy := DBMS_SQL.EXECUTE(l_cursor);

Line 298: l_dummy := DBMS_SQL.EXECUTE(l_cursor);

294: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_name, 240);
295:
296: flm_util.do_binds(l_cursor);
297:
298: l_dummy := DBMS_SQL.EXECUTE(l_cursor);
299: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
300: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_name);
301: END IF;
302: DBMS_SQL.CLOSE_CURSOR(l_cursor);

Line 299: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN

295:
296: flm_util.do_binds(l_cursor);
297:
298: l_dummy := DBMS_SQL.EXECUTE(l_cursor);
299: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
300: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_name);
301: END IF;
302: DBMS_SQL.CLOSE_CURSOR(l_cursor);
303:

Line 300: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_name);

296: flm_util.do_binds(l_cursor);
297:
298: l_dummy := DBMS_SQL.EXECUTE(l_cursor);
299: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
300: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_name);
301: END IF;
302: DBMS_SQL.CLOSE_CURSOR(l_cursor);
303:
304: x_name := l_name;

Line 302: DBMS_SQL.CLOSE_CURSOR(l_cursor);

298: l_dummy := DBMS_SQL.EXECUTE(l_cursor);
299: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
300: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_name);
301: END IF;
302: DBMS_SQL.CLOSE_CURSOR(l_cursor);
303:
304: x_name := l_name;
305:
306: EXCEPTION