APPS.JAI_DF_DROP SQL Statements

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

Line: 15

     select
       end_user_column_name,
       flex_value_set_id
     from fnd_descr_flex_column_usages cu
     where cu.descriptive_flexfield_name    = cpv_flex_name
     and   cu.descriptive_flex_context_code = cpv_context
     and   application_id                   = cpn_application_id;

Line: 24

     select flex_value_set_name
     from   fnd_flex_value_sets
     where  flex_value_set_id = cpn_value_set_id;

Line: 29

     select application_id
       from fnd_application
     where application_short_name = cpv_app_short_name;

Line: 35

    select  descriptive_flex_context_code,
            application_column_name,
            flex_value_set_id
    from    fnd_descr_flex_column_usages
    where   application_id = cpn_application_id
    and      descriptive_flexfield_name = 'AP_INVOICES'
    and      end_user_column_name =  p_segment_name;

Line: 57

    FUNCTION check_before_delete_dff(pv_flexfield_name	VARCHAR2,
    																 pv_context					VARCHAR2)
    RETURN VARCHAR2
    IS
    	CURSOR c_flex
    	IS
    	SELECT	application_table_name,
    					context_column_name
			FROM 		fnd_descriptive_flexs
			WHERE 	descriptive_flexfield_name = pv_flexfield_name;

Line: 77

      lv_sql := 'SELECT /*+ parallel(e) */ ''1'' from '||r_flex.application_table_name||'e WHERE '||r_flex.context_column_name||' = :a AND rownum < 2' ;

Line: 91

    END check_before_delete_dff;

Line: 93

    procedure delete_context is
    	lv_flag	VARCHAR2(1);

Line: 97

    	lv_flag := check_before_delete_dff(pv_flexfield_name	=> lv_flexfield_name,
    																		 pv_context				  => lv_context);

Line: 105

      /* Delete ValueSets */
      for rec_segment in cur_segment(ln_application_id, lv_flexfield_name, lv_context) loop

        fnd_flex_dsc_api.delete_segment
        (
          appl_short_name  => lv_appl_short_name,
          flexfield_name   => lv_flexfield_name ,
          context          => lv_context ,
          segment          => rec_segment.end_user_column_name
        );

Line: 122

          fnd_flex_val_api.delete_valueset(lv_value_set_name);

Line: 127

      /* Delete Context */
      fnd_flex_dsc_api.delete_context (
       appl_short_name   => lv_appl_short_name ,
       flexfield_name    => lv_flexfield_name  ,
       context           => lv_context
      );

Line: 134

    end delete_context;

Line: 151

    delete_context;

Line: 170

    delete_context;

Line: 187

    delete_context;

Line: 204

    delete_context;

Line: 221

    delete_context;

Line: 238

    delete_context;

Line: 255

    delete_context;

Line: 273

    delete_context;

Line: 290

    delete_context;

Line: 307

    delete_context;

Line: 324

    delete_context;

Line: 341

    delete_context;

Line: 358

    delete_context;

Line: 375

    delete_context;

Line: 393

    delete_context;

Line: 410

    delete_context;

Line: 427

    delete_context;

Line: 444

    delete_context;

Line: 461

    delete_context;

Line: 478

    delete_context;

Line: 496

    delete_context;

Line: 504

  select application_id into ln_application_id
  from fnd_application
  where application_short_name = 'SQLAP';

Line: 539

	lv_flag := check_before_delete_dff(pv_flexfield_name	=> 'AP_INVOICES',
																		 pv_context				  => lv_context);

Line: 548

      fnd_flex_dsc_api.delete_segment
    (
      appl_short_name  => 'SQLAP',
      flexfield_name   => 'AP_INVOICES',
      context          => lv_context,
      segment          => lv_attribute_vat_invoice
    );

Line: 558

        fnd_flex_val_api.delete_valueset(lv_value_set_inv_name);

Line: 570

    fnd_flex_dsc_api.delete_segment
    (
      appl_short_name  => 'SQLAP',
      flexfield_name   => 'AP_INVOICES',
      context          => lv_context,
      segment          => lv_attribute_vat_date
    );

Line: 580

        fnd_flex_val_api.delete_valueset(lv_value_set_date_name);

Line: 591

    fnd_flex_dsc_api.delete_segment
    (
      appl_short_name  => 'SQLAP',
      flexfield_name   => 'AP_INVOICES',
      context          => lv_context,
      segment          => lv_attribute_vat_receipt_date
    );

Line: 601

        fnd_flex_val_api.delete_valueset(lv_value_set_rdate_name);

Line: 611

    fnd_flex_dsc_api.delete_context
    (
      appl_short_name   => 'SQLAP'         ,
      flexfield_name    => 'AP_INVOICES'   ,
      context           => 'India VAT'
    );