APPS.EDW_SEC_UTIL SQL Statements

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

Line: 32

delete from edw_sec_dim_info_t;

Line: 33

delete from edw_sec_fact_info_t;

Line: 34

delete from edw_sec_lvl_info_t;

Line: 35

delete from edw_sec_itemset_info_t;

Line: 40

insert into edw_sec_dim_info_t
(dim_id,
dim_name,
dim_long_name,
table_name,
lowest_level_col_name,
context_name)
select
dim_id,
dim_name,
dim_long_name,
table_name,
lowest_level_col_name,
context_name
from edw_sec_dim_info_v;

Line: 56

insert into edw_sec_fact_info_t
(fact_id,
fact_name,
fact_long_name,
dim_id,
fk_col_name)
select
fact_id,
fact_name,
fact_long_name,
dim_id,
fk_col_name
from edw_sec_fact_info_v;

Line: 70

insert into edw_sec_lvl_info_t
(dim_id,
level_id,
level_name,
level_long_name,
star_level_name_col_name)
select
dim_id,
level_id,
level_name,
level_long_name,
star_level_name_col_name
from edw_sec_lvl_info_v;

Line: 84

insert into edw_sec_itemset_info_t
(fact_id,
fact_name,
fact_long_name,
itemset_name,
fk_col_name)
select
fact_id,
fact_name,
fact_long_name,
itemset_name,
fk_col_name
from edw_sec_itemset_info_v;

Line: 136

        insert into edw_error_log
        (object_name, object_type, resp_id, concurrent_id, message,
        last_update_date, last_updated_by, creation_date, created_by, last_update_login)
        values
        (x_object_name, x_object_type, x_resp_id, x_conc_id, x_message,
        sysdate, 0, sysdate, 0, 0);

Line: 174

select distinct dim_short_name from edw_sec_dim_access edw
where dim_id <>
(
select
dim.dim_id
from
edw_sec_dim_info_t dim
WHERE
edw.dim_short_name = dim.dim_name
)
;

Line: 186

select distinct level_short_name from edw_sec_dim_access edw
where level_id <>
(select
lvl.level_id
from
edw_sec_lvl_info_t lvl
WHERE
edw.level_short_name = lvl.level_name
and edw.dim_id = lvl.dim_id
);

Line: 208

        select dim_id into x_dim_id
        from edw_sec_dim_info_v
        where dim_name = dim_rec.dim_short_name;

Line: 212

        update edw_sec_dim_access
        set dim_id = x_dim_id
        where dim_short_name = dim_rec.dim_short_name;

Line: 222

	select level_id into x_level_id
	from edw_sec_lvl_info_v
	where level_name = level_rec.level_short_name;

Line: 226

	update edw_sec_dim_access
	set level_id = x_level_id
	where level_short_name = level_rec.level_short_name;