APPS.OKS_UTIL_PUB dependencies on DBMS_SQL

Line 368: v_cursor_id := DBMS_SQL.OPEN_CURSOR;

364: v_where_clause fnd_flex_validation_tables.additional_where_clause%type;
365: v_cols VARCHAR2(1000);
366:
367: BEGIN
368: v_cursor_id := DBMS_SQL.OPEN_CURSOR;
369:
370: if instr(upper(p_table_r.where_clause),'WHERE ') > 0 then
371: --to include the id column name in the query
372:

Line 428: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);

424: */
425:
426: -- parse the query
427:
428: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
429: oe_debug_pub.add('after parse');
430: -- Bind the input variables
431: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
432: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);

Line 431: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);

427:
428: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
429: oe_debug_pub.add('after parse');
430: -- Bind the input variables
431: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
432: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
433: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
434: LOOP
435: -- Fetch rows in to buffer and check the exit condition from the loop

Line 432: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);

428: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
429: oe_debug_pub.add('after parse');
430: -- Bind the input variables
431: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
432: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
433: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
434: LOOP
435: -- Fetch rows in to buffer and check the exit condition from the loop
436: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN

Line 433: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);

429: oe_debug_pub.add('after parse');
430: -- Bind the input variables
431: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
432: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
433: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
434: LOOP
435: -- Fetch rows in to buffer and check the exit condition from the loop
436: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN
437: EXIT;

Line 436: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN

432: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
433: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
434: LOOP
435: -- Fetch rows in to buffer and check the exit condition from the loop
436: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN
437: EXIT;
438: END IF;
439: -- Retrieve the rows from buffer into PLSQL variables
440: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);

Line 440: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);

436: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN
437: EXIT;
438: END IF;
439: -- Retrieve the rows from buffer into PLSQL variables
440: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);
441: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);
442:
443:
444: IF v_id IS NULL AND (p_value = v_value) THEN

Line 441: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);

437: EXIT;
438: END IF;
439: -- Retrieve the rows from buffer into PLSQL variables
440: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);
441: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);
442:
443:
444: IF v_id IS NULL AND (p_value = v_value) THEN
445: oe_debug_pub.add('id null, passing value'||p_value||','||v_value);

Line 446: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

442:
443:
444: IF v_id IS NULL AND (p_value = v_value) THEN
445: oe_debug_pub.add('id null, passing value'||p_value||','||v_value);
446: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
447: x_id := v_id;
448: x_value := v_value;
449: RETURN TRUE;
450: ELSIF (p_value = v_id) THEN

Line 452: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

448: x_value := v_value;
449: RETURN TRUE;
450: ELSIF (p_value = v_id) THEN
451: oe_debug_pub.add('id exists, passing id'||p_value||','||v_id);
452: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
453: x_id := v_id;
454: x_value := v_value;
455: RETURN TRUE;
456: ELSE

Line 461: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

457: Null;
458: oe_debug_pub.add('value does notmatch, continue search'||p_value||','||v_id);
459: END IF;
460: END LOOP;
461: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
462: RETURN FALSE;
463: EXCEPTION
464: WHEN OTHERS THEN
465:

Line 466: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

462: RETURN FALSE;
463: EXCEPTION
464: WHEN OTHERS THEN
465:
466: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
467: RETURN FALSE;
468: END value_exists_in_table;
469:
470: FUNCTION Get_OKS_Status RETURN VARCHAR2 IS