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 1735: v_cursor_id := DBMS_SQL.OPEN_CURSOR;

1731: l_pos1 number;
1732: l_where_length number;
1733:
1734: BEGIN
1735: v_cursor_id := DBMS_SQL.OPEN_CURSOR;
1736:
1737: IF instr(UPPER(p_table_r.where_clause), 'ORDER BY') > 0 THEN
1738: l_order_by := substr(p_table_r.where_clause, instr(UPPER(p_table_r.where_clause), 'ORDER BY'));
1739: v_where_clause := replace(p_table_r.where_clause, l_order_by ,'');

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

1774: END IF;
1775: v_selectstmt := 'SELECT '||v_cols||' FROM '||p_table_r.table_name||' '||v_where_clause;
1776: oe_debug_pub.add('select stmt'||v_selectstmt);
1777: -- parse the query
1778: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
1779: -- Bind the input variables
1780: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
1781: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
1782: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);

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

1776: oe_debug_pub.add('select stmt'||v_selectstmt);
1777: -- parse the query
1778: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
1779: -- Bind the input variables
1780: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
1781: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
1782: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
1783: LOOP
1784: -- Fetch rows in to buffer and check the exit condition from the loop

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

1777: -- parse the query
1778: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
1779: -- Bind the input variables
1780: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
1781: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
1782: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
1783: LOOP
1784: -- Fetch rows in to buffer and check the exit condition from the loop
1785: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN

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

1778: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
1779: -- Bind the input variables
1780: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
1781: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
1782: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
1783: LOOP
1784: -- Fetch rows in to buffer and check the exit condition from the loop
1785: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN
1786: EXIT;

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

1781: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
1782: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
1783: LOOP
1784: -- Fetch rows in to buffer and check the exit condition from the loop
1785: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN
1786: EXIT;
1787: END IF;
1788: -- Retrieve the rows from buffer into PLSQL variables
1789: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);

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

1785: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN
1786: EXIT;
1787: END IF;
1788: -- Retrieve the rows from buffer into PLSQL variables
1789: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);
1790: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);
1791:
1792: IF v_id IS NULL AND (p_value = v_value) THEN
1793: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

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

1786: EXIT;
1787: END IF;
1788: -- Retrieve the rows from buffer into PLSQL variables
1789: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);
1790: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);
1791:
1792: IF v_id IS NULL AND (p_value = v_value) THEN
1793: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1794: x_id := v_id;

Line 1793: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

1789: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);
1790: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);
1791:
1792: IF v_id IS NULL AND (p_value = v_value) THEN
1793: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1794: x_id := v_id;
1795: x_value := v_value;
1796: RETURN TRUE;
1797: ELSIF (p_value = v_id) THEN

Line 1798: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

1794: x_id := v_id;
1795: x_value := v_value;
1796: RETURN TRUE;
1797: ELSIF (p_value = v_id) THEN
1798: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1799: x_id := v_id;
1800: x_value := v_value;
1801: RETURN TRUE;
1802: ELSE

Line 1807: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

1803: Null;
1804: oe_debug_pub.add('value does notmatch, continue search'||p_value||','||v_id);
1805: END IF;
1806: END LOOP;
1807: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1808: RETURN FALSE;
1809: EXCEPTION
1810: WHEN OTHERS THEN
1811: oe_debug_pub.add('value_exists_in_table exception');

Line 1812: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

1808: RETURN FALSE;
1809: EXCEPTION
1810: WHEN OTHERS THEN
1811: oe_debug_pub.add('value_exists_in_table exception');
1812: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1813: RETURN FALSE;
1814: END value_exists_in_table;
1815:
1816: PROCEDURE Compare_Credit_Card