APPS.EDW_OPTION SQL Statements

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

Line: 32

  elsif  (p_option_code='UPDATETYPE') then
	p_option_value:=fnd_profile.value('EDW_UPDATE_TYPE');

Line: 38

  elsif  (p_option_code='SMARTUPDATE') then
	p_option_value:=fnd_profile.value('EDW_SMART_UPDATE');

Line: 53

   select  param.value into p_option_value from v$parameter param
     where param.name='hash_area_size';

Line: 58

   select param.value into p_option_value from v$parameter param
     where param.name='sort_area_size';

Line: 71

	   select default_tablespace into p_option_value from dba_users where
	   username=EDW_OWB_COLLECTION_UTIL.get_db_user('BIS');

Line: 123

function get_level_skip_update(p_object_id number,p_option_fk_key number,
p_option_cols out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,p_number_option_cols out nocopy number)
return boolean is
l_stmt varchar2(5000);

Line: 137

  edw_owb_collection_util.write_to_log_file_n('Error in get_level_skip_update '||sqlerrm);

Line: 142

function get_level_skip_delete(p_object_id number,p_option_fk_key number,
p_option_cols out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,p_number_option_cols out nocopy number)
return boolean is
l_stmt varchar2(5000);

Line: 156

  edw_owb_collection_util.write_to_log_file_n('Error in get_level_skip_delete '||sqlerrm);

Line: 200

      l_stmt :=    'select ''DIMENSION'' from cmpwbdimension_v'
                || ' where elementid=:d '
                || ' union '
                || ' select ''FACT'' from cmpwbcube_v'
                || ' where elementid=:f ';