DBA Data[Home] [Help]

APPS.EDW_OWB_COLLECTION_UTIL dependencies on EDW_OPTION

Line 1593: if edw_option.get_warehouse_option(null,l_derv_facts(i),'INCREMENTAL',l_is_name)=false then

1589: close cv;
1590: if l_number_derv_facts>0 then
1591: for i in 1..l_number_derv_facts loop
1592: l_is_name:=null;
1593: if edw_option.get_warehouse_option(null,l_derv_facts(i),'INCREMENTAL',l_is_name)=false then
1594: null;
1595: end if;
1596: if l_is_name='Y' then
1597: l_var:=1;

Line 2242: if edw_option.get_warehouse_option(null,l_dim_id,'SLOWDIM',l_is_name)=false then

2238: end if;
2239: l_is_name:=null;
2240: l_dim_id:=get_dim_id(p_dim_name);
2241: if g_read_cfig_options then
2242: if edw_option.get_warehouse_option(null,l_dim_id,'SLOWDIM',l_is_name)=false then
2243: null;
2244: end if;
2245: else
2246: l_stmt:='select 1 from edw_dimensions_md_v dim,edw_attribute_sets_md_v sis where sis.attribute_group_name=:a '||

Line 2311: if edw_option.get_warehouse_option(null,l_dim_id,'SLOWDIM',l_is_name)=false then

2307: if g_read_cfig_options then
2308: for i in 1..p_number_dims loop
2309: l_is_name:=null;
2310: l_dim_id:=get_dim_id(p_dim_names(i));
2311: if edw_option.get_warehouse_option(null,l_dim_id,'SLOWDIM',l_is_name)=false then
2312: null;
2313: end if;
2314: if l_is_name='Y' then
2315: p_number_dim_list:=p_number_dim_list+1;

Line 2484: if edw_option.get_warehouse_option(p_fact,null,'INCREMENTAL',l_is_name)=false then

2480: if g_debug then
2481: write_to_log_file_n('In is_inc_refresh_implemented '||p_fact);
2482: end if;
2483: if g_read_cfig_options then
2484: if edw_option.get_warehouse_option(p_fact,null,'INCREMENTAL',l_is_name)=false then
2485: null;
2486: end if;
2487: if l_is_name='Y' then
2488: l_res:=1;

Line 4096: if edw_option.get_warehouse_option(null,l_derv_fact_id(i),'INCREMENTAL',l_is_name)=false then

4092: close cv;
4093: if p_type='INC' and g_read_cfig_options then
4094: for i in 1..l_number_mapid loop
4095: l_is_name:=null;
4096: if edw_option.get_warehouse_option(null,l_derv_fact_id(i),'INCREMENTAL',l_is_name)=false then
4097: null;
4098: end if;
4099: if l_is_name='Y' then
4100: p_number_mapid:=p_number_mapid+1;

Line 4542: if edw_option.get_warehouse_option(p_object_name,null,'MASTER_INSTANCE',l_master)=false then

4538: cv CurTyp;
4539: l_res number:=null;
4540: Begin
4541: if g_read_cfig_options then
4542: if edw_option.get_warehouse_option(p_object_name,null,'MASTER_INSTANCE',l_master)=false then
4543: null;
4544: end if;
4545: else
4546: l_stmt:='select instr(lower(description),''master instance'') from edw_relations_md_v where relation_name=:a';

Line 5471: if edw_option.get_warehouse_option(null,l_dim_id,'AUTODANG',l_is_name)=false then

5467: l_is_name varchar2(40);
5468: Begin
5469: if g_read_cfig_options then
5470: l_dim_id:=get_dim_id(p_dim_name);
5471: if edw_option.get_warehouse_option(null,l_dim_id,'AUTODANG',l_is_name)=false then
5472: null;
5473: end if;
5474: if l_is_name='Y' then
5475: return true;