APPS.EDW_SEC_PKG SQL Statements

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

Line: 11

  select distinct dim_id from edw_sec_dim_access
  where resp_id = ses_resp_id;

Line: 18

  select distinct level_id
  from edw_sec_dim_access
  where resp_id = ses_resp_id
  and dim_id = current_dim_id;

Line: 85

	select context_name, table_name, lowest_level_col_name
	into x_context_name, x_table_name, x_lowest_level_col_name
	from edw_sec_dim_info_t
	where dim_id = dim_access_rec.dim_id;

Line: 92

        x_context_value :=      ' select ' ||
                                x_lowest_level_col_name ||
                                ' from '||
                                x_table_name ||
                                ' where ';

Line: 105

                select  star_level_name_col_name
                into  x_star_user_col_name
                from edw_sec_lvl_info_t
                where dim_id = current_dim_id
                and level_id = access_value_rec.level_id;

Line: 116

                                                ' in ( select access_value from edw_sec_dim_access where resp_id = ' || ses_resp_id || ' and dim_id = ' || current_dim_id || ' and level_id = ' || current_level_id ||' )';

Line: 122

                                                ' in ( select access_value from edw_sec_dim_access where resp_id = ' || ses_resp_id || ' and dim_id = ' || current_dim_id || ' and level_id = ' || current_level_id ||' )';

Line: 282

	x_context_value := 'select ASGN_ASSIGNMENT_PK_KEY from EDW_HR_PERSON_M where '
				|| SYS_CONTEXT('edw_context','def_access_column')
				|| ' = '
				|| SYS_CONTEXT('edw_context','def_access_id');

Line: 305

  select dim_id into x_def_dim_id from edw_sec_dim_info_t
	where dim_name = 'EDW_HR_PERSON_M';

Line: 418

  select instance_code into x_instance_code from edw_system_parameters;

Line: 423

  select warehouse_to_instance_link into x_db_link_name from edw_source_instances
 	 where instance_code = x_instance_code;

Line: 430

  sql_stmt := 'select count(*) from fnd_user@' || x_db_link_name ||
                ' where user_name = ''' ||x_user_name || '''';

Line: 435

sql_stmt := 'select count(*) from fnd_user' ||
			' where user_name = ''' ||x_user_name || '''';

Line: 448

  sql_stmt := 'select nvl(employee_id, -1) from fnd_user@' || x_db_link_name ||
		' where user_name = ''' ||x_user_name || '''';

Line: 453

  sql_stmt := 'select nvl(employee_id, -1) from fnd_user' ||
		    ' where user_name = ''' ||x_user_name || '''';

Line: 466

  select asgn_assignment_pk_key into x_pk_key
  from edw_hr_person_m
  where asgn_assignment_pk = x_pk;

Line: 480

  sql_stmt := ' select
        s01_person_id,
        s02_person_id,
        s03_person_id,
        s04_person_id,
        s05_person_id,
        s06_person_id,
        s07_person_id,
        s08_person_id,
        s09_person_id,
        s10_person_id,
        s11_person_id,
        s12_person_id,
        s13_person_id,
        s14_person_id,
        s15_person_id
  from
        edw_hr_person_m
  where
        asgn_assignment_pk_key = '|| x_pk_key;

Line: 572

  sql_stmt := 'select ' || x_access_column || ' from edw_hr_person_m where asgn_assignment_pk_key = ' || x_pk_key;

Line: 653

  select count(*) into sorc_records from dba_tables
  where owner = EDW_OWB_COLLECTION_UTIL.get_db_user('BIS')
  and table_name = 'EDW_LOCAL_INSTANCE';

Line: 658

    sql_stmt := 'select count(*) from edw_local_instance';

Line: 676

        insert into edw_error_log
        (object_name, object_type, resp_id, message,
        last_update_date, last_updated_by, creation_date, created_by, last_update_login)
        values
        ('EDW_SEC_PKG.set_global_names_for_source', 'EDW Security Package', NULL,
	'Oracle error occured in EDW_SEC_PKG.set_global_names_for_source procedure at step : '|| x_step
         || '. Errorcode is : ' || v_ErrorCode || ' and Errortext is : ' || v_ErrorText,
        sysdate, 0, sysdate, 0, 0);

Line: 703

  cursor sec_cursor is select distinct t1.dim_id
  from edw_sec_dim_access t1, edw_sec_fact_info_t t2
  where resp_id = ses_resp_id
  and t1.dim_id = t2.dim_id
  and t2.fact_id = x_fact_id;

Line: 715

  cursor sec_def_cursor is select distinct t1.dim_id
  from edw_sec_dim_access t1, edw_sec_fact_info_t t2
  where resp_id = ses_resp_id
  and t1.dim_id = t2.dim_id
  and t2.fact_id = x_fact_id
  and t1.dim_id <> x_def_dim_id;

Line: 734

  cursor fk_cursor is select fk_col_name
  from edw_sec_fact_info_t
  where fact_id = x_fact_id
  and dim_id = current_dim_id
  and fk_col_name not in
	( select fk_col_name
	from edw_sec_ref_info_t
	where resp_id = ses_resp_id
	and fact_id = x_fact_id
	and dim_id = current_dim_id);

Line: 780

  select distinct fact_id into x_fact_id
  from edw_sec_fact_info_t
  where fact_name = obj_name;

Line: 813

	select count(*) into x_number
	from edw_sec_itemset_info_t
	where fact_id = x_fact_id;

Line: 842

		select context_name into x_context_name
		from edw_sec_dim_info_t
		where dim_id = sec_def_rec.dim_id;

Line: 855

                select SYS_CONTEXT('edw_context', x_context_name, 4000) into temp_predicate from dual;

Line: 898

		select context_name into x_context_name
		from edw_sec_dim_info_t
		where dim_id = sec_rec.dim_id;

Line: 911

                select SYS_CONTEXT('edw_context', x_context_name, 4000) into temp_predicate from dual;

Line: 1088

  select distinct fact_id into x_fact_id
  from edw_sec_fact_info_t
  where fact_name = obj_name;

Line: 1106

  select fk_col_name into x_fk_col_name
  from edw_sec_itemset_info_t
  where itemset_name = x_item_set_name
  and fact_id = x_fact_id;

Line: 1127

                select SYS_CONTEXT('edw_context', x_context_name, 4000) into temp_predicate from dual;