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

Line 235: --cursor_id := dbms_sql.open_cursor;

231: --
232: -- REMOVED FOR BUG 3304342
233: --IF (p_set_trace = 'T') THEN
234: --dummy := 'alter session set sql_trace = true';
235: --cursor_id := dbms_sql.open_cursor;
236: --dbms_sql.parse(cursor_id, dummy, dbms_sql.v7);
237: --retval := dbms_sql.execute(dummy);
238: --dbms_sql.close_cursor(cursor_id);
239: --END IF;

Line 236: --dbms_sql.parse(cursor_id, dummy, dbms_sql.v7);

232: -- REMOVED FOR BUG 3304342
233: --IF (p_set_trace = 'T') THEN
234: --dummy := 'alter session set sql_trace = true';
235: --cursor_id := dbms_sql.open_cursor;
236: --dbms_sql.parse(cursor_id, dummy, dbms_sql.v7);
237: --retval := dbms_sql.execute(dummy);
238: --dbms_sql.close_cursor(cursor_id);
239: --END IF;
240:

Line 237: --retval := dbms_sql.execute(dummy);

233: --IF (p_set_trace = 'T') THEN
234: --dummy := 'alter session set sql_trace = true';
235: --cursor_id := dbms_sql.open_cursor;
236: --dbms_sql.parse(cursor_id, dummy, dbms_sql.v7);
237: --retval := dbms_sql.execute(dummy);
238: --dbms_sql.close_cursor(cursor_id);
239: --END IF;
240:
241: IF p_return_node_display_only = 'T' THEN

Line 238: --dbms_sql.close_cursor(cursor_id);

234: --dummy := 'alter session set sql_trace = true';
235: --cursor_id := dbms_sql.open_cursor;
236: --dbms_sql.parse(cursor_id, dummy, dbms_sql.v7);
237: --retval := dbms_sql.execute(dummy);
238: --dbms_sql.close_cursor(cursor_id);
239: --END IF;
240:
241: IF p_return_node_display_only = 'T' THEN
242: l_return_node_display_only := TRUE;

Line 485: cursor_id := dbms_sql.open_cursor;

481:
482: --
483: -- Retreive data results
484: --
485: cursor_id := dbms_sql.open_cursor;
486: dbms_sql.parse(cursor_id, l_query_stmt, dbms_sql.v7);
487:
488: IF (p_node_key_columns.count > 0) THEN
489: ak_query_pkg.bind_sql(cursor_id, p_node_key_values);

Line 486: dbms_sql.parse(cursor_id, l_query_stmt, dbms_sql.v7);

482: --
483: -- Retreive data results
484: --
485: cursor_id := dbms_sql.open_cursor;
486: dbms_sql.parse(cursor_id, l_query_stmt, dbms_sql.v7);
487:
488: IF (p_node_key_columns.count > 0) THEN
489: ak_query_pkg.bind_sql(cursor_id, p_node_key_values);
490: END IF;

Line 502: l_retval := dbms_sql.execute(cursor_id);

498: END IF;
499:
500: ak_query_pkg.define_sql(cursor_id, l_num_select + l_num_key);
501:
502: l_retval := dbms_sql.execute(cursor_id);
503:
504: -- Fetch rows
505: LOOP
506: l_retval := dbms_sql.fetch_rows(cursor_id);

Line 506: l_retval := dbms_sql.fetch_rows(cursor_id);

502: l_retval := dbms_sql.execute(cursor_id);
503:
504: -- Fetch rows
505: LOOP
506: l_retval := dbms_sql.fetch_rows(cursor_id);
507:
508: IF (l_retval = 0) THEN -- no more rows
509: -- If the region is displayed it will be the highest numbered region,
510: -- then set region with the total number of rows the query returned

Line 553: dbms_sql.close_cursor(cursor_id);

549: l_where_binds);
550: END IF;
551: END IF;
552: END LOOP;
553: dbms_sql.close_cursor(cursor_id);
554: ELSE
555: -- p_return_parents is false
556: -- don't return parents, just take the key_values and get children
557: IF p_return_children THEN

Line 1396: dbms_sql.column_value(p_cursor_id, display_index + 1,

1392: IF (display_index < p_num_select) THEN
1393: --
1394: -- Retrieve display attribute values
1395: --
1396: dbms_sql.column_value(p_cursor_id, display_index + 1,
1397: display_value(display_index));
1398: print_debug('display_value('||to_char(display_index)||') = '
1399: ||display_value(display_index));
1400:

Line 1405: dbms_sql.column_value(p_cursor_id, display_index + 1,

1401: ELSE
1402: --
1403: -- Retrieve primary key values
1404: --
1405: dbms_sql.column_value(p_cursor_id, display_index + 1,
1406: key_value(key_index));
1407: print_debug('** key_value(' || to_char(key_index)
1408: || ')=' || key_value(key_index));
1409: key_index := key_index + 1;

Line 1782: dbms_sql.define_column(p_cursor_id, select_index + 1, NULL, 4000);

1778: -- define each select column with an appropriate variable
1779: --
1780:
1781: FOR select_index in 0..(p_num_select - 1) LOOP
1782: dbms_sql.define_column(p_cursor_id, select_index + 1, NULL, 4000);
1783: END LOOP;
1784: END define_sql;
1785:
1786:

Line 1816: dbms_sql.bind_variable(p_cursor_id, 'BIND' ||

1812: IF (p_key_values(key_index) IS NOT NULL) THEN
1813: BEGIN
1814: print_debug('binding bind variable :BIND'||
1815: to_char(key_index + 1));
1816: dbms_sql.bind_variable(p_cursor_id, 'BIND' ||
1817: to_char(key_index + 1),
1818: p_key_values(key_index));
1819: EXCEPTION
1820: WHEN dont_care_error THEN NULL;

Line 1855: dbms_sql.bind_variable(p_cursor_id, p_where_binds(i).name,

1851:
1852: print_debug('binding bind variable :'
1853: || p_where_binds(i).name || ' to '
1854: || '''' || p_where_binds(i).value || '''');
1855: dbms_sql.bind_variable(p_cursor_id, p_where_binds(i).name,
1856: p_where_binds(i).value);
1857: i := p_where_binds.NEXT(i);
1858: END LOOP;
1859:

Line 2138: c := dbms_sql.open_cursor;

2134:
2135: ak_query_pkg.sql_stmt := l_sql_statement;
2136:
2137: -- Now execute the select statement built above
2138: c := dbms_sql.open_cursor;
2139: dbms_sql.parse(c, l_sql_statement, dbms_sql.v7);
2140:
2141: -- Bind Values
2142:

Line 2139: dbms_sql.parse(c, l_sql_statement, dbms_sql.v7);

2135: ak_query_pkg.sql_stmt := l_sql_statement;
2136:
2137: -- Now execute the select statement built above
2138: c := dbms_sql.open_cursor;
2139: dbms_sql.parse(c, l_sql_statement, dbms_sql.v7);
2140:
2141: -- Bind Values
2142:
2143: bind_sql(c,p_current_key_values);

Line 2147: dbms_sql.define_column(c, i, NULL, 4000);

2143: bind_sql(c,p_current_key_values);
2144:
2145: -- Define select list data types
2146: FOR i in 1..p_new_key_columns.count LOOP
2147: dbms_sql.define_column(c, i, NULL, 4000);
2148: END LOOP;
2149:
2150: l_retval := dbms_sql.execute(c);
2151:

Line 2150: l_retval := dbms_sql.execute(c);

2146: FOR i in 1..p_new_key_columns.count LOOP
2147: dbms_sql.define_column(c, i, NULL, 4000);
2148: END LOOP;
2149:
2150: l_retval := dbms_sql.execute(c);
2151:
2152: -- Fetch the first row from SQL statement (there should be none or one)
2153:
2154: l_retval := dbms_sql.fetch_rows(c);

Line 2154: l_retval := dbms_sql.fetch_rows(c);

2150: l_retval := dbms_sql.execute(c);
2151:
2152: -- Fetch the first row from SQL statement (there should be none or one)
2153:
2154: l_retval := dbms_sql.fetch_rows(c);
2155: -- If the fetch returns a row then get new values, else no rows were
2156: -- returned. This may happen when a FK
2157: IF l_retval = 0 THEN
2158: RAISE NO_DATA_FOUND;

Line 2164: dbms_sql.column_value(c, i, l_new_key_values(i - 1));

2160:
2161: -- Retrieve column values
2162: FOR i in 1..p_new_key_columns.count LOOP
2163: print_debug('New Key Column'||to_char(i));
2164: dbms_sql.column_value(c, i, l_new_key_values(i - 1));
2165: print_debug(' value: '||l_new_key_values(i - 1));
2166: END LOOP;
2167:
2168: -- Assign values to OUT parameters

Line 2171: dbms_sql.close_cursor(c);

2167:
2168: -- Assign values to OUT parameters
2169:
2170: p_new_key_values := l_new_key_values;
2171: dbms_sql.close_cursor(c);
2172:
2173: END;
2174:
2175: -- ======================================================