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.OE_AUDIT_HISTORY_PVT dependencies on DBMS_SQL

Line 2106: v_cursor_id := DBMS_SQL.OPEN_CURSOR;

2102: l_pos1 number;
2103: l_where_length number;
2104:
2105: BEGIN
2106: v_cursor_id := DBMS_SQL.OPEN_CURSOR;
2107:
2108: IF instr(UPPER(p_table_r.where_clause), 'ORDER BY') > 0 THEN
2109: l_order_by := substr(p_table_r.where_clause, instr(UPPER(p_table_r.where_clause), 'ORDER BY'));
2110: v_where_clause := replace(p_table_r.where_clause, l_order_by ,'');

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

2145: END IF;
2146: v_selectstmt := 'SELECT '||v_cols||' FROM '||p_table_r.table_name||' '||v_where_clause;
2147: oe_debug_pub.add('select stmt'||v_selectstmt);
2148: -- parse the query
2149: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
2150: -- Bind the input variables
2151: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
2152: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
2153: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);

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

2147: oe_debug_pub.add('select stmt'||v_selectstmt);
2148: -- parse the query
2149: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
2150: -- Bind the input variables
2151: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
2152: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
2153: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
2154: LOOP
2155: -- Fetch rows in to buffer and check the exit condition from the loop

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

2148: -- parse the query
2149: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
2150: -- Bind the input variables
2151: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
2152: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
2153: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
2154: LOOP
2155: -- Fetch rows in to buffer and check the exit condition from the loop
2156: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN

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

2149: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
2150: -- Bind the input variables
2151: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
2152: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
2153: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
2154: LOOP
2155: -- Fetch rows in to buffer and check the exit condition from the loop
2156: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN
2157: EXIT;

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

2152: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
2153: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
2154: LOOP
2155: -- Fetch rows in to buffer and check the exit condition from the loop
2156: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN
2157: EXIT;
2158: END IF;
2159: -- Retrieve the rows from buffer into PLSQL variables
2160: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);

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

2156: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN
2157: EXIT;
2158: END IF;
2159: -- Retrieve the rows from buffer into PLSQL variables
2160: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);
2161: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);
2162:
2163: IF v_id IS NULL AND (p_value = v_value) THEN
2164: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

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

2157: EXIT;
2158: END IF;
2159: -- Retrieve the rows from buffer into PLSQL variables
2160: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);
2161: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);
2162:
2163: IF v_id IS NULL AND (p_value = v_value) THEN
2164: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
2165: x_id := v_id;

Line 2164: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

2160: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);
2161: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);
2162:
2163: IF v_id IS NULL AND (p_value = v_value) THEN
2164: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
2165: x_id := v_id;
2166: x_value := v_value;
2167: RETURN TRUE;
2168: ELSIF (p_value = v_id) THEN

Line 2169: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

2165: x_id := v_id;
2166: x_value := v_value;
2167: RETURN TRUE;
2168: ELSIF (p_value = v_id) THEN
2169: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
2170: x_id := v_id;
2171: x_value := v_value;
2172: RETURN TRUE;
2173: ELSE

Line 2178: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

2174: Null;
2175: oe_debug_pub.add('value does notmatch, continue search'||p_value||','||v_id);
2176: END IF;
2177: END LOOP;
2178: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
2179: RETURN FALSE;
2180: EXCEPTION
2181: WHEN OTHERS THEN
2182: oe_debug_pub.add('value_exists_in_table exception');

Line 2183: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

2179: RETURN FALSE;
2180: EXCEPTION
2181: WHEN OTHERS THEN
2182: oe_debug_pub.add('value_exists_in_table exception');
2183: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
2184: RETURN FALSE;
2185: END value_exists_in_table;
2186:
2187: PROCEDURE Compare_Credit_Card