APPS.IGIRMINP SQL Statements

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

Line: 27

      SELECT    arps.customer_trx_id, arps.payment_schedule_id,
                arps.terms_sequence_number
      FROM      ar_payment_schedules arps
      WHERE     arps.customer_Trx_id = cp_customer_trx_id
      AND       arps.status = cp_status
      order     by arps.due_date asc
      ;

Line: 44

    CURSOR c_exists is select distinct  'x'
           from ar_payment_schedules ps1
           where exists ( select 'x'
               from ar_payment_schedules ps2
               where status = 'CL'
               and   ps2.customer_trx_id = fp_customer_trx_id
               )
           and  exists ( select 'x'
               from ar_payment_schedules ps3
               where status = 'OP'
               and   ps3.customer_trx_id = fp_customer_trx_id
            )
            order by ps1.customer_Trx_id
            ;

Line: 88

       UPDATE   ar_payment_schedules
       SET      terms_sequence_number = l_arpsched( l_idx2 ).terms_sequence_number
       WHERE    customer_trx_id       = l_arpsched( l_idx2 ).customer_trx_id
       AND      payment_schedule_id   = l_arpsched( l_idx2 ).payment_schedule_id
       ;

Line: 110

 l_select_cursor    INTEGER;

Line: 141

  l_select_cursor := dbms_sql.open_cursor;

Line: 157

  dbms_sql.parse(l_select_cursor,
                 'select count( distinct invoice_currency_code ), sum(amount_due_remaining), sum(acctd_amount_due_remaining)  from '||p_from_clause||' '||l_out_where_clause,
     dbms_sql.v7);

Line: 162

 |Define columns for the select statement.                               |
 +-----------------------------------------------------------------------*/
  arp_standard.debug('Defining Columns  +');

Line: 166

  dbms_sql.define_column(l_select_cursor, 1 , l_count);

Line: 167

  dbms_sql.define_column(l_select_cursor, 2 , l_amount);

Line: 168

  dbms_sql.define_column(l_select_cursor, 3 , l_func_amount);

Line: 191

       dbms_sql.bind_variable(l_select_cursor, l_actual_bind_var, l_literal_tbl(l_ctr).stripped_value);

Line: 205

  l_ignore := dbms_sql.execute(l_select_cursor);

Line: 209

  IF dbms_sql.fetch_rows(l_select_cursor) > 0 then

  /*-----------------------------------------------------------------------+
   |Fetch the column values, into actual variables                         |
   +-----------------------------------------------------------------------*/
     arp_standard.debug('Fetching column values +');

Line: 216

     dbms_sql.column_value(l_select_cursor, 1, l_count);

Line: 217

     dbms_sql.column_value(l_select_cursor, 2, l_amount);

Line: 218

     dbms_sql.column_value(l_select_cursor, 3, l_func_amount);

Line: 244

   dbms_sql.close_cursor(l_select_cursor);

Line: 327

  select length(l_in_where_clause)
  into l_actual_length
  from dual;

Line: 336

  select instr(l_in_where_clause, 'order by')
  into l_by_clause_pos
  from dual;

Line: 347

     SELECT INSTR(l_in_where_clause, 'group by')
     INTO   l_by_clause_pos
     FROM DUAL;

Line: 371

         select substr(l_in_where_clause, l_ctr, 1)
         into l_temp_cell
         from dual;

Line: 478

     SELECT SUBSTR(l_in_where_clause, l_by_clause_pos)
     INTO l_balance_clause
     FROM dual;