APPS.OKS_UTIL_PUB dependencies on OE_DEBUG_PUB

Line 410: oe_debug_pub.add('select stmt'||v_selectstmt);

406:
407:
408: v_selectstmt := 'SELECT '||v_cols||' FROM '||p_table_r.table_name||' '||v_where_clause;
409:
410: oe_debug_pub.add('select stmt'||v_selectstmt);
411:
412: ------------------
413:
414: /*

Line 429: oe_debug_pub.add('after parse');

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);
433: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);

Line 445: oe_debug_pub.add('id null, passing value'||p_value||','||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);
446: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
447: x_id := v_id;
448: x_value := v_value;
449: RETURN TRUE;

Line 451: oe_debug_pub.add('id exists, passing id'||p_value||','||v_id);

447: x_id := v_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;

Line 458: oe_debug_pub.add('value does notmatch, continue search'||p_value||','||v_id);

454: x_value := v_value;
455: RETURN TRUE;
456: ELSE
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;