DBA Data[Home] [Help]

APPS.EDW_SRC_DANG_RECOVERY dependencies on FND_PROFILE

Line 762: l_value:=fnd_profile.value('EDW_DEBUG');

758: check_tspace_exist varchar(1);
759: check_ts_mode varchar(1);
760: physical_tspace_name varchar2(100);
761: Begin
762: l_value:=fnd_profile.value('EDW_DEBUG');
763: g_debug:=false;
764: if l_value='Y' then
765: g_debug:=true;
766: end if;

Line 789: g_src_op_table_space:=fnd_profile.value('EDW_OP_TABLE_SPACE');

785: if g_auto_dang_flag=false then
786: return true;
787: end if;
788:
789: g_src_op_table_space:=fnd_profile.value('EDW_OP_TABLE_SPACE');
790:
791: if g_src_op_table_space is null then
792: AD_TSPACE_UTIL.is_new_ts_mode (check_ts_mode);
793: If check_ts_mode ='Y' then

Line 804: g_src_parallel:=fnd_profile.value('EDW_PARALLEL');

800: if g_src_op_table_space is null then
801: g_src_op_table_space:=get_default_tablespace;
802: end if;
803:
804: g_src_parallel:=fnd_profile.value('EDW_PARALLEL');
805: return true;
806: Exception when others then
807: g_status_message:=sqlerrm;
808: write_to_log_file_n(g_status_message);

Line 1060: l_stmt:='select profile_option_name from fnd_profile_options where profile_option_name '||

1056: l_stmt varchar2(2000);
1057: TYPE CurTyp IS REF CURSOR;
1058: cv CurTyp;
1059: Begin
1060: l_stmt:='select profile_option_name from fnd_profile_options where profile_option_name '||
1061: ' like '''||g_object_name||'_PS%''';
1062: if g_debug then
1063: write_to_log_file_n(l_stmt);
1064: end if;

Line 1079: l_pk_structure:=fnd_profile.value(g_profile_options(i));

1075: if g_debug then
1076: write_to_log_file_n('Looking at '||g_profile_options(i));
1077: end if;
1078: l_pk_structure:=null;
1079: l_pk_structure:=fnd_profile.value(g_profile_options(i));
1080: if l_pk_structure is not null then
1081: l_start:=1;
1082: l_end:=1;
1083: l_length:=length(l_pk_structure);