eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDW_ALL_COLLECT dependencies on FND_PROFILE

Line 2940: if fnd_profile.value('EDW_TRACE')='Y' then

2936: physical_tspace_name varchar2(100);
2937:
2938: Begin
2939: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('In read_profile_options',FND_LOG.LEVEL_STATEMENT);
2940: if fnd_profile.value('EDW_TRACE')='Y' then
2941: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Trace turned ON',FND_LOG.LEVEL_STATEMENT);
2942: g_trace:=true;
2943: else
2944: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Trace turned OFF',FND_LOG.LEVEL_STATEMENT);

Line 2952: if fnd_profile.value('EDW_DEBUG')='Y' or FND_LOG.G_CURRENT_RUNTIME_LEVEL=FND_LOG.LEVEL_STATEMENT then

2948: if g_trace then
2949: EDW_OWB_COLLECTION_UTIL.alter_session('TRACE');
2950: commit;
2951: end if;
2952: if fnd_profile.value('EDW_DEBUG')='Y' or FND_LOG.G_CURRENT_RUNTIME_LEVEL=FND_LOG.LEVEL_STATEMENT then
2953: g_debug:=true;--look at the profile value for this
2954: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Debug turned ON',FND_LOG.LEVEL_STATEMENT);
2955: else
2956: g_debug:=false;

Line 2960: if fnd_profile.value('EDW_DUPLICATE_COLLECT')='Y' then

2956: g_debug:=false;
2957: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Debug turned OFF',FND_LOG.LEVEL_STATEMENT);
2958: end if;
2959: EDW_OWB_COLLECTION_UTIL.set_debug(g_debug);
2960: if fnd_profile.value('EDW_DUPLICATE_COLLECT')='Y' then
2961: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Duplicate collect is turned ON',FND_LOG.LEVEL_STATEMENT);
2962: g_duplicate_collect:=true;--look at the profile value for this
2963: else
2964: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Duplicate collect is turned OFF',FND_LOG.LEVEL_STATEMENT);

Line 2975: g_collection_size:=fnd_profile.value('EDW_COLLECTION_SIZE');

2971: else
2972: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Dimension Push Down NOT Implemented',FND_LOG.LEVEL_STATEMENT);
2973: end if;
2974: end if;
2975: g_collection_size:=fnd_profile.value('EDW_COLLECTION_SIZE');
2976: if g_collection_size is null then
2977: g_collection_size:=0;
2978: end if;
2979: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Collection size= '||g_collection_size,FND_LOG.LEVEL_STATEMENT);

Line 2982: g_parallel:=fnd_profile.value('EDW_PARALLEL');

2978: end if;
2979: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Collection size= '||g_collection_size,FND_LOG.LEVEL_STATEMENT);
2980: g_bis_owner:=EDW_OWB_COLLECTION_UTIL.get_db_user('BIS');
2981: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('BIS Owner is '||g_bis_owner,FND_LOG.LEVEL_STATEMENT);
2982: g_parallel:=fnd_profile.value('EDW_PARALLEL');
2983: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n ('Degree of parallelism (null is default)='||g_parallel,FND_LOG.LEVEL_STATEMENT);
2984: if g_parallel=0 then
2985: g_parallel:=null;
2986: end if;

Line 2992: if fnd_profile.value('EDW_TEST_MODE')='Y' then

2988: if g_parallel is not null then
2989: EDW_OWB_COLLECTION_UTIL.alter_session('PARALLEL');
2990: commit;
2991: end if;
2992: if fnd_profile.value('EDW_TEST_MODE')='Y' then
2993: g_mode:='TEST';
2994: else
2995: g_mode:='NORMAL';
2996: end if;

Line 2998: if fnd_profile.value('EDW_USE_EXP_PLAN')='Y' then

2994: else
2995: g_mode:='NORMAL';
2996: end if;
2997: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Mode is '||g_mode,FND_LOG.LEVEL_STATEMENT);
2998: if fnd_profile.value('EDW_USE_EXP_PLAN')='Y' then
2999: g_explain_plan_check:=TRUE;
3000: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Explain plan check ON',FND_LOG.LEVEL_STATEMENT);
3001: else
3002: g_explain_plan_check:=FALSE;

Line 3006: l_hash_area_size:=fnd_profile.value('EDW_HASH_AREA_SIZE');

3002: g_explain_plan_check:=FALSE;
3003: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Explain plan check OFF',FND_LOG.LEVEL_STATEMENT);
3004: end if;
3005: l_hash_area_size:=null;
3006: l_hash_area_size:=fnd_profile.value('EDW_HASH_AREA_SIZE');
3007: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('l_hash_area_size='||l_hash_area_size,FND_LOG.LEVEL_STATEMENT);
3008: if l_hash_area_size is not null then
3009: execute immediate 'alter session set hash_area_size='||l_hash_area_size;
3010: end if;

Line 3012: l_sort_area_size:=fnd_profile.value('EDW_SORT_AREA_SIZE');

3008: if l_hash_area_size is not null then
3009: execute immediate 'alter session set hash_area_size='||l_hash_area_size;
3010: end if;
3011: l_sort_area_size:=null;
3012: l_sort_area_size:=fnd_profile.value('EDW_SORT_AREA_SIZE');
3013: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('l_sort_area_size='||l_sort_area_size,FND_LOG.LEVEL_STATEMENT);
3014: if l_sort_area_size is not null then
3015: execute immediate 'alter session set sort_area_size='||l_sort_area_size;
3016: end if;

Line 3017: if fnd_profile.value('EDW_FRESH_RESTART')='Y' then

3013: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('l_sort_area_size='||l_sort_area_size,FND_LOG.LEVEL_STATEMENT);
3014: if l_sort_area_size is not null then
3015: execute immediate 'alter session set sort_area_size='||l_sort_area_size;
3016: end if;
3017: if fnd_profile.value('EDW_FRESH_RESTART')='Y' then
3018: g_fresh_restart:=true;
3019: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Fresh Restart TRUE',FND_LOG.LEVEL_STATEMENT);
3020: else
3021: g_fresh_restart:=false;

Line 3025: g_op_table_space:=fnd_profile.value('EDW_OP_TABLE_SPACE');

3021: g_fresh_restart:=false;
3022: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Fresh Restart FALSE',FND_LOG.LEVEL_STATEMENT);
3023: end if;
3024:
3025: g_op_table_space:=fnd_profile.value('EDW_OP_TABLE_SPACE');
3026: if g_op_table_space is null then
3027: AD_TSPACE_UTIL.is_new_ts_mode (check_ts_mode);
3028: If check_ts_mode ='Y' then
3029: AD_TSPACE_UTIL.get_tablespace_name ('BIS', 'INTERFACE','Y',check_tspace_exist, physical_tspace_name);

Line 3040: g_rollback:=fnd_profile.value('EDW_LOAD_ROLLBACK');

3036: g_op_table_space:=EDW_OWB_COLLECTION_UTIL.get_table_space(g_bis_owner);
3037: end if;
3038:
3039: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Operation table space='||g_op_table_space,FND_LOG.LEVEL_STATEMENT);
3040: g_rollback:=fnd_profile.value('EDW_LOAD_ROLLBACK');
3041: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Rollback Segment='||g_rollback,FND_LOG.LEVEL_STATEMENT);
3042: g_update_type:=fnd_profile.value('EDW_UPDATE_TYPE');
3043: if g_update_type is null then
3044: g_update_type:='MASS';

Line 3042: g_update_type:=fnd_profile.value('EDW_UPDATE_TYPE');

3038:
3039: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Operation table space='||g_op_table_space,FND_LOG.LEVEL_STATEMENT);
3040: g_rollback:=fnd_profile.value('EDW_LOAD_ROLLBACK');
3041: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Rollback Segment='||g_rollback,FND_LOG.LEVEL_STATEMENT);
3042: g_update_type:=fnd_profile.value('EDW_UPDATE_TYPE');
3043: if g_update_type is null then
3044: g_update_type:='MASS';
3045: end if;
3046: if g_update_type<>'MASS' and g_update_type<>'ROW-BY-ROW' then

Line 3050: if fnd_profile.value('EDW_SMART_UPDATE')='Y' then

3046: if g_update_type<>'MASS' and g_update_type<>'ROW-BY-ROW' then
3047: g_update_type:='MASS';
3048: end if;
3049: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Update Type='||g_update_type,FND_LOG.LEVEL_STATEMENT);
3050: if fnd_profile.value('EDW_SMART_UPDATE')='Y' then
3051: g_smart_update:=true;
3052: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Smart Update TRUE',FND_LOG.LEVEL_STATEMENT);
3053: else
3054: g_smart_update:=false;

Line 3071: g_fk_use_nl:=fnd_profile.value('EDW_FK_USE_NL');

3067: end loop;
3068: end if;
3069: end if;
3070: begin
3071: g_fk_use_nl:=fnd_profile.value('EDW_FK_USE_NL');
3072: if g_fk_use_nl is null then
3073: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('g_fk_use_nl null. setting to 100,000',FND_LOG.LEVEL_STATEMENT);
3074: g_fk_use_nl:=100000;
3075: end if;

Line 3082: if fnd_profile.value('EDW_LTC_COPY_MERGE_NL')='Y' then

3078: g_fk_use_nl:=100000;
3079: end;
3080: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('FK Use NL ='||g_fk_use_nl,FND_LOG.LEVEL_STATEMENT);
3081: g_ltc_merge_use_nl:=false;
3082: if fnd_profile.value('EDW_LTC_COPY_MERGE_NL')='Y' then
3083: g_ltc_merge_use_nl:=true;
3084: end if;
3085: if g_ltc_merge_use_nl then
3086: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('LTC Copy Merge TRUE',FND_LOG.LEVEL_STATEMENT);

Line 3098: l_num:=fnd_profile.value('EDW_STG_JOIN_NL');

3094: else
3095: g_dim_inc_refresh_derv:=false;
3096: end if;
3097: end if;
3098: l_num:=fnd_profile.value('EDW_STG_JOIN_NL');
3099: if l_num is not null then
3100: if l_num>0 and l_num<101 then
3101: g_stg_join_nl:=l_num;
3102: end if;

Line 3104: l_num:=fnd_profile.value('EDW_OK_UPDATE');

3100: if l_num>0 and l_num<101 then
3101: g_stg_join_nl:=l_num;
3102: end if;
3103: end if;
3104: l_num:=fnd_profile.value('EDW_OK_UPDATE');
3105: if l_num is not null then
3106: if l_num>0 and l_num<101 then
3107: g_ok_switch_update:=l_num;
3108: end if;

Line 3110: l_num:=fnd_profile.value('EDW_STG_MAKE_COPY');

3106: if l_num>0 and l_num<101 then
3107: g_ok_switch_update:=l_num;
3108: end if;
3109: end if;
3110: l_num:=fnd_profile.value('EDW_STG_MAKE_COPY');
3111: if l_num is not null then
3112: if l_num>0 and l_num<101 then
3113: g_stg_make_copy_percentage:=l_num;
3114: end if;

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

3113: g_stg_make_copy_percentage:=l_num;
3114: end if;
3115: end if;
3116: g_auto_dang_recovery:=false;
3117: if fnd_profile.value('EDW_AUTO_DANG_RECOVERY')='Y' then
3118: g_auto_dang_recovery:=true;
3119: end if;
3120: g_create_parent_table_records:=false;
3121: if g_auto_dang_recovery then

Line 3126: l_var:=fnd_profile.value('EDW_MAX_THREADS');

3122: g_create_parent_table_records:=true;
3123: end if;
3124: l_num:=null;
3125: l_var:=null;
3126: l_var:=fnd_profile.value('EDW_MAX_THREADS');
3127: begin
3128: l_num:=to_number(l_var);
3129: exception when others then
3130: l_var:='AUTO';

Line 3139: l_num:=fnd_profile.value('EDW_MIN_JOB_LOAD_SIZE');

3135: if l_num is not null and l_num>0 then
3136: g_max_threads:=l_num;
3137: end if;
3138: l_num:=null;
3139: l_num:=fnd_profile.value('EDW_MIN_JOB_LOAD_SIZE');
3140: if l_num is not null and l_num>0 then
3141: g_min_job_load_size:=l_num;
3142: end if;
3143: l_num:=null;

Line 3144: l_num:=fnd_profile.value('EDW_SLEEP_TIME');

3140: if l_num is not null and l_num>0 then
3141: g_min_job_load_size:=l_num;
3142: end if;
3143: l_num:=null;
3144: l_num:=fnd_profile.value('EDW_SLEEP_TIME');
3145: if l_num is not null and l_num>0 then
3146: g_sleep_time:=l_num;
3147: end if;
3148: l_key_set:=fnd_profile.value('EDW_FK_SET_SIZE');

Line 3148: l_key_set:=fnd_profile.value('EDW_FK_SET_SIZE');

3144: l_num:=fnd_profile.value('EDW_SLEEP_TIME');
3145: if l_num is not null and l_num>0 then
3146: g_sleep_time:=l_num;
3147: end if;
3148: l_key_set:=fnd_profile.value('EDW_FK_SET_SIZE');
3149: if l_key_set is null then
3150: g_key_set:=5;
3151: else
3152: g_key_set:=to_number(l_key_set);

Line 3183: if fnd_profile.value('EDW_FORCE_DBMS_JOB')='Y' then

3179: if g_conc_program_id >0 then
3180: --this process is a conc program
3181: l_thread_type:='CONC';
3182: --this is if someone insists on having dbms jobs when launched through oracle apps
3183: if fnd_profile.value('EDW_FORCE_DBMS_JOB')='Y' then
3184: l_thread_type:='JOB';
3185: end if;
3186: begin
3187: l_stmt:='select running_processes from FND_CONCURRENT_QUEUES where concurrent_queue_name=''STANDARD''';

Line 3316: if fnd_profile.value('EDW_NO_PARALLEL_DD')='Y' then

3312: g_parallel_drill_down:=false;
3313: return;
3314: end if;
3315: --just in case we want to turn off parallel drill down
3316: if fnd_profile.value('EDW_NO_PARALLEL_DD')='Y' then
3317: if g_debug then
3318: write_to_log_file('profile EDW_NO_PARALLEL_DD defined');
3319: end if;
3320: g_parallel_drill_down:=false;