APPS.FA_RX_UTIL_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 51

function build_select return varchar2
is
  buffer varchar2(10000);

Line: 57

     fa_rx_util_pkg.debug('fa_rx_util_pkg.build_select('||to_char(Num_Columns)||')+');

Line: 61

  while idx <= Num_Columns and Rep_Columns(idx).select_column_name is null loop
	idx := idx + 1;

Line: 64

  buffer := 'SELECT '||Hint_Clause||'
	'||Rep_Columns(idx).select_column_name;

Line: 70

    if Rep_Columns(idx).select_column_name is not null then
      buffer := buffer ||',
	'||Rep_Columns(idx).select_column_name;

Line: 92

    fa_rx_util_pkg.debug('SELECT Statement = ');

Line: 94

    fa_rx_util_pkg.debug('fa_rx_util_pkg.build_select()-');

Line: 107

end build_select;

Line: 126

function build_insert return varchar2
is
  idx number;

Line: 134

     fa_rx_util_pkg.debug('fa_rx_util_pkg.build_insert()+');

Line: 138

  while idx <= Num_Columns and Rep_Columns(idx).insert_column_name is null loop
	idx := idx + 1;

Line: 141

  buf1 := 'INSERT INTO '||Interface_Table||' (
	'||Rep_Columns(idx).insert_column_name;

Line: 149

    if Rep_Columns(idx).insert_column_name is not null then
      buf1 := buf1 ||',
	 '||Rep_Columns(idx).insert_column_name;

Line: 156

  buf1 := buf1||', request_id, created_by, creation_date, last_updated_by, last_update_date, last_update_login';

Line: 160

     fa_rx_util_pkg.debug('INSERT Statement = ');

Line: 162

     fa_rx_util_pkg.debug('fa_rx_util_pkg.build_insert()-');

Line: 166

end build_insert;

Line: 187

procedure bind_insert(p_cursor in number)
is
  buffer varchar2(30000);

Line: 195

 	fa_rx_util_pkg.debug('fa_rx_util_pkg.bind_insert()+');

Line: 200

    if Rep_Columns(idx).insert_column_name is not null then
	buffer := buffer ||'dbms_sql.bind_variable('||to_char(p_cursor)||
				', '':b'||to_char(idx)||
				''', '||Rep_Columns(idx).placeholder_name||');

Line: 210

 	fa_rx_util_pkg.debug('bind_insert: ' || buffer);

Line: 224

 	fa_rx_util_pkg.debug('fa_rx_util_pkg.bind_insert()-');

Line: 226

end bind_insert;

Line: 270

     if Rep_Columns(idx).select_column_name is not null then

        if Rep_Columns(idx).column_type = 'VARCHAR2' then

           dbms_sql.define_column(
              c           => p_cursor,
              position    => sel_idx,
              column      => l_varchar,
              column_size => to_char(Rep_Columns(idx).column_length));

Line: 308

    if Rep_Columns(idx).select_column_name is not null then
      buffer := buffer ||'dbms_sql.define_column('||
		to_char(p_cursor)||', '||
		to_char(sel_idx)||', '||
		Rep_Columns(idx).placeholder_name;

Line: 372

    if Rep_Columns(idx).select_column_name is not null then
      buffer := buffer ||'dbms_sql.column_value('||
		to_char(p_cursor)||','||
		to_char(sel_idx)||','||
		Rep_Columns(idx).placeholder_name||');

Line: 472

  	select
	  rx.interface_table
	into
	  Interface_Table
	from
	  fnd_concurrent_requests r,
	  fa_rx_reports rx
	where
	  r.request_id = p_request_id and
	  r.program_application_id = rx.application_id and
	  r.concurrent_program_id = rx.concurrent_program_id;

Line: 497

    dbms_sql.parse(c, 'delete from '||Interface_Table||' where request_id = :request_id', dbms_sql.native); --*    bug#3207863, rravunny

Line: 502

   	fa_rx_util_pkg.debug('init_request: ' || to_char(dbms_sql.last_row_count)||' row(s) deleted from table '||Interface_Table);

Line: 611

			p_select_column_name in varchar2,
			p_insert_column_name in varchar2,
			p_placeholder_name in varchar2,
			p_column_type in varchar2,
			p_column_length in number default null)
is
  l_index number;

Line: 644

			p_select_column_name||','||
			p_insert_column_name||','||
			p_placeholder_name||','||
			p_column_type||'('||to_char(p_column_length)||'))+');

Line: 665

  Rep_Columns(l_index).select_column_name := p_select_column_name;

Line: 666

  Rep_Columns(l_index).insert_column_name := p_insert_column_name;

Line: 894

  cursor_select integer;

Line: 895

  cursor_insert integer;

Line: 949

    cursor_select := dbms_sql.open_cursor;

Line: 950

    dbms_sql.parse(cursor_select,
			build_select,
			dbms_sql.native);

Line: 964

				':CURSOR_SELECT',
				cursor_select);

Line: 969

    define_columns(cursor_select);

Line: 972

   	fa_rx_util_pkg.debug('run_report: ' || 'Executing SELECT statement');

Line: 974

    rows := dbms_sql.execute(cursor_select);

Line: 977

   	fa_rx_util_pkg.debug('run_report: ' || 'Building INSERT');

Line: 979

    cursor_insert := dbms_sql.open_cursor;

Line: 980

    dbms_sql.parse(cursor_insert, build_insert, dbms_sql.native);

Line: 995

	rows := dbms_sql.fetch_rows(cursor_select);

Line: 1001

	column_values(cursor_select);

Line: 1011

		fa_rx_util_pkg.debug('run_report: ' || 'Insert Row');

Line: 1013

        bind_insert(cursor_insert);

Line: 1014

        rows := dbms_sql.execute(cursor_insert);

Line: 1019

    dbms_sql.close_cursor(cursor_insert);

Line: 1020

    dbms_sql.close_cursor(cursor_select);