APPS.TAPI_DEV_KIT dependencies on DBMS_SQL

Line 236: v_cursor_id := dbms_sql.open_cursor;

232: v_cursor_id INTEGER;
233: v_dummy INTEGER;
234: x_id NUMBER;
235: Begin
236: v_cursor_id := dbms_sql.open_cursor;
237: v_sql_stmt := 'Select ' || p_seq_name || '.nextval seq into :x_id from dual' ;
238: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
239: dbms_sql.define_column(v_cursor_id, 1, x_id);
240: v_dummy := dbms_sql.execute_and_fetch(v_cursor_id);

Line 238: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);

234: x_id NUMBER;
235: Begin
236: v_cursor_id := dbms_sql.open_cursor;
237: v_sql_stmt := 'Select ' || p_seq_name || '.nextval seq into :x_id from dual' ;
238: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
239: dbms_sql.define_column(v_cursor_id, 1, x_id);
240: v_dummy := dbms_sql.execute_and_fetch(v_cursor_id);
241: dbms_sql.column_value(v_cursor_id, 1, x_id);
242: return(x_id);

Line 239: dbms_sql.define_column(v_cursor_id, 1, x_id);

235: Begin
236: v_cursor_id := dbms_sql.open_cursor;
237: v_sql_stmt := 'Select ' || p_seq_name || '.nextval seq into :x_id from dual' ;
238: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
239: dbms_sql.define_column(v_cursor_id, 1, x_id);
240: v_dummy := dbms_sql.execute_and_fetch(v_cursor_id);
241: dbms_sql.column_value(v_cursor_id, 1, x_id);
242: return(x_id);
243: End get_primary_key;

Line 240: v_dummy := dbms_sql.execute_and_fetch(v_cursor_id);

236: v_cursor_id := dbms_sql.open_cursor;
237: v_sql_stmt := 'Select ' || p_seq_name || '.nextval seq into :x_id from dual' ;
238: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
239: dbms_sql.define_column(v_cursor_id, 1, x_id);
240: v_dummy := dbms_sql.execute_and_fetch(v_cursor_id);
241: dbms_sql.column_value(v_cursor_id, 1, x_id);
242: return(x_id);
243: End get_primary_key;
244: --------------------------------------------------------------------------------

Line 241: dbms_sql.column_value(v_cursor_id, 1, x_id);

237: v_sql_stmt := 'Select ' || p_seq_name || '.nextval seq into :x_id from dual' ;
238: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
239: dbms_sql.define_column(v_cursor_id, 1, x_id);
240: v_dummy := dbms_sql.execute_and_fetch(v_cursor_id);
241: dbms_sql.column_value(v_cursor_id, 1, x_id);
242: return(x_id);
243: End get_primary_key;
244: --------------------------------------------------------------------------------
245: -- FUNCTION g_miss_num_f