APPS.EDW_MAPPING_COLLECT dependencies on EDW_OPTION

Line 1773: if edw_option.get_warehouse_option(null,g_dimTableId(i),'ALIGNMENT',l_option_value)=false then

1769: end loop;
1770: for i in 1..g_numberOfDimTables loop
1771: l_option_value:=null;
1772: if g_read_cfig_options then
1773: if edw_option.get_warehouse_option(null,g_dimTableId(i),'ALIGNMENT',l_option_value)=false then
1774: g_status_message:=edw_option.g_status_message;
1775: g_status:=false;
1776: return;
1777: end if;

Line 1774: g_status_message:=edw_option.g_status_message;

1770: for i in 1..g_numberOfDimTables loop
1771: l_option_value:=null;
1772: if g_read_cfig_options then
1773: if edw_option.get_warehouse_option(null,g_dimTableId(i),'ALIGNMENT',l_option_value)=false then
1774: g_status_message:=edw_option.g_status_message;
1775: g_status:=false;
1776: return;
1777: end if;
1778: else

Line 1803: if edw_option.get_warehouse_option(null,g_dimTableId(i),'SLOWDIM',l_option_value)=false then

1799: g_dimTableName_da(i):=g_dimTableName(i);
1800: end if;
1801: l_option_value:=null;
1802: if g_read_cfig_options then
1803: if edw_option.get_warehouse_option(null,g_dimTableId(i),'SLOWDIM',l_option_value)=false then
1804: g_status_message:=edw_option.g_status_message;
1805: g_status:=false;
1806: return;
1807: end if;

Line 1804: g_status_message:=edw_option.g_status_message;

1800: end if;
1801: l_option_value:=null;
1802: if g_read_cfig_options then
1803: if edw_option.get_warehouse_option(null,g_dimTableId(i),'SLOWDIM',l_option_value)=false then
1804: g_status_message:=edw_option.g_status_message;
1805: g_status:=false;
1806: return;
1807: end if;
1808: else

Line 5210: if edw_option.get_warehouse_option(g_object_name,null,'SKIPUPDATE',l_option_value)=false then

5206: begin
5207: g_skip_update:=false;
5208: l_option_value:=null;
5209: if g_read_cfig_options then
5210: if edw_option.get_warehouse_option(g_object_name,null,'SKIPUPDATE',l_option_value)=false then
5211: null;
5212: end if;
5213: if l_option_value='Y' then
5214: if g_object_type='DIMENSION' then

Line 5215: if edw_option.get_option_columns(g_object_name,null,'SKIPUPDATE',l_table,l_number_table)=false then

5211: null;
5212: end if;
5213: if l_option_value='Y' then
5214: if g_object_type='DIMENSION' then
5215: if edw_option.get_option_columns(g_object_name,null,'SKIPUPDATE',l_table,l_number_table)=false then
5216: null;
5217: end if;
5218: if l_number_table is null then
5219: l_number_table:=0;

Line 5246: if edw_option.get_warehouse_option(g_object_name,null,'SKIPDELETE',l_option_value)=false then

5242: g_skip_delete:=false;
5243: if g_read_cfig_options then
5244: l_option_value:=null;
5245: l_number_table:=0;
5246: if edw_option.get_warehouse_option(g_object_name,null,'SKIPDELETE',l_option_value)=false then
5247: null;
5248: end if;
5249: if l_option_value='Y' then
5250: if g_object_type='DIMENSION' then

Line 5251: if edw_option.get_option_columns(g_object_name,null,'SKIPDELETE',l_table,l_number_table)=false then

5247: null;
5248: end if;
5249: if l_option_value='Y' then
5250: if g_object_type='DIMENSION' then
5251: if edw_option.get_option_columns(g_object_name,null,'SKIPDELETE',l_table,l_number_table)=false then
5252: null;
5253: end if;
5254: g_skip_delete:=true;
5255: if l_number_table is null then

Line 7469: if edw_option.get_warehouse_option(null,g_dimTableId(i),'AUTOKEYGEN',l_option_value)=false then

7465: g_number_fks_dang_load:=0;
7466: for i in 1..g_numberOfDimTables loop
7467: if g_fstg_fk_direct_load(i)=false and g_fstg_fk_value_load(i)=false then
7468: l_option_value:='N';
7469: if edw_option.get_warehouse_option(null,g_dimTableId(i),'AUTOKEYGEN',l_option_value)=false then
7470: l_option_value:='N';
7471: end if;
7472: if l_option_value='Y' then
7473: g_number_fks_dang_load:=g_number_fks_dang_load+1;