DBA Data[Home] [Help]

APPS.ARP_ARXCOQIT SQL Statements

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

Line: 35

 l_select_cursor integer;
Line: 51

   l_select_cursor := dbms_sql.open_cursor;
Line: 52

   dbms_sql.parse(l_select_cursor,
        'select count(distinct(currency)) from ar_app_adj_v
	 where'|| p_where_clause,dbms_sql.v7);
Line: 55

   dbms_sql.define_column(l_select_cursor, 1 , l_cur_count);
Line: 56

   l_ignore := dbms_sql.execute(l_select_cursor);
Line: 57

   if dbms_sql.fetch_rows(l_select_cursor) > 0 then
    dbms_sql.column_value(l_select_cursor, 1, l_cur_count);
Line: 65

	dbms_sql.close_cursor(l_select_cursor);
Line: 68

 	l_select_cursor := dbms_sql.open_cursor;
Line: 69

 	dbms_sql.parse(l_select_cursor,
        	'select sum(total_amount) from ar_app_adj_v
			where'|| p_where_clause, dbms_sql.v7);
Line: 72

   	dbms_sql.define_column(l_select_cursor, 1 , l_amount);
Line: 73

  	l_ignore := dbms_sql.execute(l_select_cursor);
Line: 74

  	if dbms_sql.fetch_rows(l_select_cursor) > 0 then
   		dbms_sql.column_value(l_select_cursor, 1, l_amount);
Line: 87

	dbms_sql.close_cursor(l_select_cursor);
Line: 95

	dbms_sql.close_cursor(l_select_cursor);
Line: 103

      l_select_stmt varchar2(1000);
Line: 110

       l_select_stmt := 'select count(distinct(currency)) from ar_app_adj_v
         where PAYMENT_SCHEDULE_ID= :ps_id ';
Line: 113

       l_select_cursor := dbms_sql.open_cursor;
Line: 115

       dbms_sql.parse(l_select_cursor, l_select_stmt ,dbms_sql.v7);
Line: 117

       dbms_sql.bind_variable ( l_select_cursor , ':ps_id' , l_bind_ps_id) ;
Line: 119

       dbms_sql.define_column(l_select_cursor, 1 , l_cur_count);
Line: 120

       l_ignore := dbms_sql.execute(l_select_cursor);
Line: 122

       if dbms_sql.fetch_rows(l_select_cursor) > 0 then
           dbms_sql.column_value(l_select_cursor, 1, l_cur_count);
Line: 130

          dbms_sql.close_cursor(l_select_cursor);
Line: 132

          l_select_stmt := 'select sum(total_amount) from ar_app_adj_v
                         where PAYMENT_SCHEDULE_ID= :ps_id ';
Line: 135

             arp_standard.debug('Build_And_Bind: ' || l_select_stmt);
Line: 138

           l_select_cursor := dbms_sql.open_cursor;
Line: 140

           dbms_sql.parse(l_select_cursor,l_select_stmt , dbms_sql.v7);
Line: 142

           dbms_sql.bind_variable ( l_select_cursor , ':ps_id' , l_bind_ps_id );
Line: 144

           dbms_sql.define_column(l_select_cursor, 1 , l_amount);
Line: 145

           l_ignore := dbms_sql.execute(l_select_cursor);
Line: 146

           if dbms_sql.fetch_rows(l_select_cursor) > 0 then
                dbms_sql.column_value(l_select_cursor, 1, l_amount);
Line: 159

           dbms_sql.close_cursor(l_select_cursor);
Line: 165

           dbms_sql.close_cursor(l_select_cursor);
Line: 196

 l_select_cursor    INTEGER;
Line: 232

  l_select_cursor := dbms_sql.open_cursor;
Line: 269

/* 3988361 :If the customer_id is used for selection the use n6 index */

IF p_from_clause = 'AR_PAYMENT_SCHEDULES_TRX2_V' AND INSTR(l_out_where_clause,'CUSTOMER_ID=') <> 0 AND INSTR(l_out_where_clause,'TRX_NUMBER=') <> 0 THEN
  dbms_sql.parse(l_select_cursor,
                 'select /*+ INDEX(AR_PAYMENT_SCHEDULES_TRX2_V.ps AR_PAYMENT_SCHEDULES_N11) */
                             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: 279

dbms_sql.parse(l_select_cursor,
                 'select /*+ INDEX(AR_PAYMENT_SCHEDULES_TRX2_V.ps AR_PAYMENT_SCHEDULES_N6) */
                             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: 286

  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: 295

 |Define columns for the select statement.                               |
 +-----------------------------------------------------------------------*/
  IF PG_DEBUG in ('Y', 'C') THEN
     arp_standard.debug('Build_And_Bind: ' || 'Defining Columns  +');
Line: 301

  dbms_sql.define_column(l_select_cursor, 1 , l_count);
Line: 302

  dbms_sql.define_column(l_select_cursor, 2 , l_amount);
Line: 303

  dbms_sql.define_column(l_select_cursor, 3 , l_func_amount);
Line: 334

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

  l_ignore := dbms_sql.execute(l_select_cursor);
Line: 358

  IF dbms_sql.fetch_rows(l_select_cursor) > 0 then

  /*-----------------------------------------------------------------------+
   |Fetch the column values, into actual variables                         |
   +-----------------------------------------------------------------------*/
     IF PG_DEBUG in ('Y', 'C') THEN
        arp_standard.debug('Build_And_Bind: ' || 'Fetching column values +');
Line: 367

     dbms_sql.column_value(l_select_cursor, 1, l_count);
Line: 368

     dbms_sql.column_value(l_select_cursor, 2, l_amount);
Line: 369

     dbms_sql.column_value(l_select_cursor, 3, l_func_amount);
Line: 404

   dbms_sql.close_cursor(l_select_cursor);
Line: 418

 l_select_cursor    INTEGER;
Line: 444

  l_select_cursor := dbms_sql.open_cursor;
Line: 461

  dbms_sql.parse(l_select_cursor,
                 'select invoice_currency_code  from '||p_from_clause||' '||l_out_where_clause,
                dbms_sql.v7);
Line: 466

 |Define columns for the select statement.                               |
 +-----------------------------------------------------------------------*/

  IF PG_DEBUG in ('Y', 'C') THEN
     arp_standard.debug('Build_And_Bind: ' || 'Defining Columns  +');
Line: 472

  dbms_sql.define_column(l_select_cursor, 1 ,l_currency_code,15);
Line: 501

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

  l_ignore := dbms_sql.execute(l_select_cursor);
Line: 525

  IF dbms_sql.fetch_rows(l_select_cursor) > 0 then

  /*-----------------------------------------------------------------------+
   |Fetch the column values, into actual variables                         |
   +-----------------------------------------------------------------------*/
     IF PG_DEBUG in ('Y', 'C') THEN
        arp_standard.debug('Build_And_Bind: ' || 'Fetching column values +');
Line: 534

     dbms_sql.column_value(l_select_cursor, 1, l_currency_code);
Line: 559

   dbms_sql.close_cursor(l_select_cursor);
Line: 575

 select start_date into
  p_last_dispute_date
  from ar_dispute_history
  where payment_schedule_id = p_ps_id and
  end_date is null;
Line: 593

 select count(*)
 into p_dispute_amount_changed
 from ar_payment_schedules
 where payment_schedule_id = p_ps_id
 and (( amount_in_dispute <> p_amount_in_dispute) OR
      (amount_in_dispute is NOT NULL and
           p_amount_in_dispute IS NULL ) OR
      ( p_amount_in_dispute IS NOT NULL and
          amount_in_dispute IS NULL ) );
Line: 615

  select decode(min(start_date),
                NULL , 'N',
                    'Y' )
  into p_ever_in_dispute_flag
  from ar_dispute_history
  WHERE payment_schedule_id = p_ps_id;
Line: 632

     select trunc(sysdate) - p_due_date
     into p_days_late
     from dual;
Line: 721

  select length(l_in_where_clause)
  into l_actual_length
  from dual;
Line: 730

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

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

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

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