eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_K_USER_ATTRIBUTES_PUB dependencies on DBMS_SQL

Line 314: value_cursor_id := DBMS_SQL.open_cursor;

310: l_select_stmt :=
311: 'SELECT FLEX_VALUE FROM ('
312: || l_select_stmt
313: || ') WHERE FLEX_VALUE_ID = :1';
314: value_cursor_id := DBMS_SQL.open_cursor;
315: --parse the query
316: DBMS_SQL.parse (value_cursor_id, l_select_stmt, DBMS_SQL.native);
317: --Bind the input variable
318: DBMS_SQL.bind_variable (value_cursor_id, ':1', p_attr_value);

Line 316: DBMS_SQL.parse (value_cursor_id, l_select_stmt, DBMS_SQL.native);

312: || l_select_stmt
313: || ') WHERE FLEX_VALUE_ID = :1';
314: value_cursor_id := DBMS_SQL.open_cursor;
315: --parse the query
316: DBMS_SQL.parse (value_cursor_id, l_select_stmt, DBMS_SQL.native);
317: --Bind the input variable
318: DBMS_SQL.bind_variable (value_cursor_id, ':1', p_attr_value);
319: --define select lis
320: DBMS_SQL.define_column (value_cursor_id, 1, l_value, 1000);

Line 318: DBMS_SQL.bind_variable (value_cursor_id, ':1', p_attr_value);

314: value_cursor_id := DBMS_SQL.open_cursor;
315: --parse the query
316: DBMS_SQL.parse (value_cursor_id, l_select_stmt, DBMS_SQL.native);
317: --Bind the input variable
318: DBMS_SQL.bind_variable (value_cursor_id, ':1', p_attr_value);
319: --define select lis
320: DBMS_SQL.define_column (value_cursor_id, 1, l_value, 1000);
321: --execute the query
322: ret_val := DBMS_SQL.EXECUTE (value_cursor_id);

Line 320: DBMS_SQL.define_column (value_cursor_id, 1, l_value, 1000);

316: DBMS_SQL.parse (value_cursor_id, l_select_stmt, DBMS_SQL.native);
317: --Bind the input variable
318: DBMS_SQL.bind_variable (value_cursor_id, ':1', p_attr_value);
319: --define select lis
320: DBMS_SQL.define_column (value_cursor_id, 1, l_value, 1000);
321: --execute the query
322: ret_val := DBMS_SQL.EXECUTE (value_cursor_id);
323:
324: IF DBMS_SQL.fetch_rows (value_cursor_id) <> 0

Line 322: ret_val := DBMS_SQL.EXECUTE (value_cursor_id);

318: DBMS_SQL.bind_variable (value_cursor_id, ':1', p_attr_value);
319: --define select lis
320: DBMS_SQL.define_column (value_cursor_id, 1, l_value, 1000);
321: --execute the query
322: ret_val := DBMS_SQL.EXECUTE (value_cursor_id);
323:
324: IF DBMS_SQL.fetch_rows (value_cursor_id) <> 0
325: THEN
326: DBMS_SQL.COLUMN_VALUE (value_cursor_id, 1, l_value);

Line 324: IF DBMS_SQL.fetch_rows (value_cursor_id) <> 0

320: DBMS_SQL.define_column (value_cursor_id, 1, l_value, 1000);
321: --execute the query
322: ret_val := DBMS_SQL.EXECUTE (value_cursor_id);
323:
324: IF DBMS_SQL.fetch_rows (value_cursor_id) <> 0
325: THEN
326: DBMS_SQL.COLUMN_VALUE (value_cursor_id, 1, l_value);
327: ELSE
328: x_return_status := oke_api.g_ret_sts_error;

Line 326: DBMS_SQL.COLUMN_VALUE (value_cursor_id, 1, l_value);

322: ret_val := DBMS_SQL.EXECUTE (value_cursor_id);
323:
324: IF DBMS_SQL.fetch_rows (value_cursor_id) <> 0
325: THEN
326: DBMS_SQL.COLUMN_VALUE (value_cursor_id, 1, l_value);
327: ELSE
328: x_return_status := oke_api.g_ret_sts_error;
329: END IF;
330:

Line 331: DBMS_SQL.close_cursor (value_cursor_id);

327: ELSE
328: x_return_status := oke_api.g_ret_sts_error;
329: END IF;
330:
331: DBMS_SQL.close_cursor (value_cursor_id);
332: END IF;
333: EXCEPTION
334: WHEN NO_DATA_FOUND
335: THEN