APPS.EDW_OWB_COLLECTION_UTIL dependencies on FND_PROFILE

Line 982: l_dir := fnd_profile.value('UTL_FILE_LOG');

978: l_dir varchar2(300);
979: begin
980: g_conc_program_id:=FND_GLOBAL.Conc_request_id;--my conc id
981: l_dir:=null;
982: l_dir := fnd_profile.value('UTL_FILE_LOG');
983: if l_dir is null then
984: l_dir := fnd_profile.value('EDW_LOGFILE_DIR');
985: if l_dir is null then
986: l_dir:='/sqlcom/log';

Line 984: l_dir := fnd_profile.value('EDW_LOGFILE_DIR');

980: g_conc_program_id:=FND_GLOBAL.Conc_request_id;--my conc id
981: l_dir:=null;
982: l_dir := fnd_profile.value('UTL_FILE_LOG');
983: if l_dir is null then
984: l_dir := fnd_profile.value('EDW_LOGFILE_DIR');
985: if l_dir is null then
986: l_dir:='/sqlcom/log';
987: end if;
988: end if;

Line 5478: if fnd_profile.value('EDW_AUTO_DANG_RECOVERY')='Y' then

5474: if l_is_name='Y' then
5475: return true;
5476: end if;
5477: else
5478: if fnd_profile.value('EDW_AUTO_DANG_RECOVERY')='Y' then
5479: return true;
5480: end if;
5481: end if;
5482: return false;

Line 5695: l_stmt:='select profile_option_name from fnd_profile_options'||l_db_link_stmt||' where profile_option_name '||

5691: else
5692: l_db_link_stmt:=null;
5693: end if;
5694: l_number_profile_options:=1;
5695: l_stmt:='select profile_option_name from fnd_profile_options'||l_db_link_stmt||' where profile_option_name '||
5696: ' like '''||p_parent_table_name||'_PS%''';
5697: if g_debug then
5698: write_to_log_file_n(l_stmt||get_time);
5699: end if;

Line 5717: l_stmt:='select fnd_profile.value'||l_db_link_stmt||'('''||l_profile_options(i)||''') from dual';

5713: end if;
5714: for i in 1..l_number_profile_options loop
5715: l_pk_structure:=null;
5716: begin
5717: l_stmt:='select fnd_profile.value'||l_db_link_stmt||'('''||l_profile_options(i)||''') from dual';
5718: if g_debug then
5719: write_to_log_file_n(l_stmt);
5720: end if;
5721: open cv for l_stmt;

Line 5731: l_stmt:='select B.profile_option_value from fnd_profile_options'||l_db_link_stmt||' A, '||

5727: end if;
5728: l_pk_structure:=null;
5729: end;
5730: if l_pk_structure is null then
5731: l_stmt:='select B.profile_option_value from fnd_profile_options'||l_db_link_stmt||' A, '||
5732: 'fnd_profile_option_values'||l_db_link_stmt||' B '||
5733: 'where A.profile_option_id=B.profile_option_id '||
5734: 'and A.profile_option_name=:a';
5735: if g_debug then

Line 5732: 'fnd_profile_option_values'||l_db_link_stmt||' B '||

5728: l_pk_structure:=null;
5729: end;
5730: if l_pk_structure is null then
5731: l_stmt:='select B.profile_option_value from fnd_profile_options'||l_db_link_stmt||' A, '||
5732: 'fnd_profile_option_values'||l_db_link_stmt||' B '||
5733: 'where A.profile_option_id=B.profile_option_id '||
5734: 'and A.profile_option_name=:a';
5735: if g_debug then
5736: write_to_log_file_n(l_stmt);