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 EDW_OPTION

Line 2588: if edw_option.get_option_columns(p_object_name,null,'ALIGNMENT',g_da_cols,g_number_da_cols)=false then

2584: function find_data_alignment_cols(p_object_name varchar2) return boolean is
2585: Begin
2586: g_number_da_cols:=0;
2587: if g_read_cfig_options then
2588: if edw_option.get_option_columns(p_object_name,null,'ALIGNMENT',g_da_cols,g_number_da_cols)=false then
2589: g_status_message:=edw_option.g_status_message;
2590: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n(g_status_message,FND_LOG.LEVEL_STATEMENT);
2591: g_status:=false;
2592: return false;

Line 2589: g_status_message:=edw_option.g_status_message;

2585: Begin
2586: g_number_da_cols:=0;
2587: if g_read_cfig_options then
2588: if edw_option.get_option_columns(p_object_name,null,'ALIGNMENT',g_da_cols,g_number_da_cols)=false then
2589: g_status_message:=edw_option.g_status_message;
2590: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n(g_status_message,FND_LOG.LEVEL_STATEMENT);
2591: g_status:=false;
2592: return false;
2593: end if;

Line 2624: if edw_option.get_warehouse_option(null,g_object_id,'TRACE',l_option_value)=false then

2620: l_num number;
2621: Begin
2622: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('In read_config_options',FND_LOG.LEVEL_STATEMENT);
2623: l_option_value:=null;
2624: if edw_option.get_warehouse_option(null,g_object_id,'TRACE',l_option_value)=false then
2625: null;
2626: end if;
2627: if l_option_value='Y' then
2628: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Trace turned ON',FND_LOG.LEVEL_STATEMENT);

Line 2638: if edw_option.get_warehouse_option(null,g_object_id,'DEBUG',l_option_value)=false then

2634: if g_trace then
2635: EDW_OWB_COLLECTION_UTIL.alter_session('TRACE');
2636: end if;
2637: l_option_value:=null;
2638: if edw_option.get_warehouse_option(null,g_object_id,'DEBUG',l_option_value)=false then
2639: null;
2640: end if;
2641: if l_option_value='Y' or FND_LOG.G_CURRENT_RUNTIME_LEVEL=FND_LOG.LEVEL_STATEMENT then
2642: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Debug turned ON',FND_LOG.LEVEL_STATEMENT);

Line 2650: if edw_option.get_warehouse_option(null,g_object_id,'DUPLICATE',l_option_value)=false then

2646: g_debug:=false;
2647: end if;
2648: EDW_OWB_COLLECTION_UTIL.set_debug(g_debug);
2649: l_option_value:=null;
2650: if edw_option.get_warehouse_option(null,g_object_id,'DUPLICATE',l_option_value)=false then
2651: null;
2652: end if;
2653: if l_option_value='Y' then
2654: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Duplicate Load turned ON',FND_LOG.LEVEL_STATEMENT);

Line 2661: if edw_option.get_warehouse_option(null,g_object_id,'COMMITSIZE',l_option_value)=false then

2657: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Duplicate Load turned OFF',FND_LOG.LEVEL_STATEMENT);
2658: g_duplicate_collect:=false;
2659: end if;
2660: l_option_value:=null;
2661: if edw_option.get_warehouse_option(null,g_object_id,'COMMITSIZE',l_option_value)=false then
2662: null;
2663: end if;
2664: if l_option_value is not null then
2665: g_collection_size:=to_number(l_option_value);

Line 2673: if edw_option.get_warehouse_option(null,g_object_id,'PARALLELISM',l_option_value)=false then

2669: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Collection size= '||g_collection_size,FND_LOG.LEVEL_STATEMENT);
2670: g_bis_owner:=EDW_OWB_COLLECTION_UTIL.get_db_user('BIS');
2671: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('BIS Owner is '||g_bis_owner,FND_LOG.LEVEL_STATEMENT);
2672: l_option_value:=null;
2673: if edw_option.get_warehouse_option(null,g_object_id,'PARALLELISM',l_option_value)=false then
2674: null;
2675: end if;
2676: if l_option_value is not null then
2677: g_parallel:=to_number(l_option_value);

Line 2693: if edw_option.get_warehouse_option(null,g_object_id,'AUTOKEYGEN',l_option_value)=false then

2689: l_option_value:=null;
2690: if g_object_type='FACT' then
2691: l_option_value:='Y';
2692: else
2693: if edw_option.get_warehouse_option(null,g_object_id,'AUTOKEYGEN',l_option_value)=false then
2694: null;
2695: end if;
2696: end if;
2697: if l_option_value='Y' then

Line 2708: if edw_option.get_warehouse_option(null,g_object_id,'HASHAREA',l_option_value)=false then

2704: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Mode is '||g_mode,FND_LOG.LEVEL_STATEMENT);
2705: g_explain_plan_check:=FALSE;
2706: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Explain plan check OFF',FND_LOG.LEVEL_STATEMENT);
2707: l_option_value:=null;
2708: if edw_option.get_warehouse_option(null,g_object_id,'HASHAREA',l_option_value)=false then
2709: null;
2710: end if;
2711: if l_option_value is not null then
2712: l_hash_area_size:=to_number(l_option_value);

Line 2723: if edw_option.get_warehouse_option(null,g_object_id,'SORTAREA',l_option_value)=false then

2719: if l_hash_area_size is not null then
2720: execute immediate 'alter session set hash_area_size='||l_hash_area_size;
2721: end if;
2722: l_option_value:=null;
2723: if edw_option.get_warehouse_option(null,g_object_id,'SORTAREA',l_option_value)=false then
2724: null;
2725: end if;
2726: if l_option_value is not null then
2727: l_sort_area_size:=to_number(l_option_value);

Line 2738: if edw_option.get_warehouse_option(null,g_object_id,'KEYSETSIZE',l_option_value)=false then

2734: if l_sort_area_size is not null then
2735: execute immediate 'alter session set sort_area_size='||l_sort_area_size;
2736: end if;
2737: l_option_value:=null;
2738: if edw_option.get_warehouse_option(null,g_object_id,'KEYSETSIZE',l_option_value)=false then
2739: null;
2740: end if;
2741: if l_option_value is not null then
2742: g_key_set:=to_number(l_option_value);

Line 2754: if edw_option.get_warehouse_option(null,g_object_id,'FRESHSTART',l_option_value)=false then

2750: g_key_set:=10;
2751: end if;
2752: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('g_key_set='||g_key_set,FND_LOG.LEVEL_STATEMENT);
2753: l_option_value:=null;
2754: if edw_option.get_warehouse_option(null,g_object_id,'FRESHSTART',l_option_value)=false then
2755: null;
2756: end if;
2757: if l_option_value='Y' then
2758: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Fresh Restart TRUE',FND_LOG.LEVEL_STATEMENT);

Line 2765: if edw_option.get_warehouse_option(null,g_object_id,'OPTABLESPACE',l_option_value)=false then

2761: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Fresh Restart FALSE',FND_LOG.LEVEL_STATEMENT);
2762: g_fresh_restart:=false;
2763: end if;
2764: l_option_value:=null;
2765: if edw_option.get_warehouse_option(null,g_object_id,'OPTABLESPACE',l_option_value)=false then
2766: null;
2767: end if;
2768: if l_option_value is not null then
2769: g_op_table_space:=l_option_value;

Line 2775: if edw_option.get_warehouse_option(null,g_object_id,'ROLLBACK',l_option_value)=false then

2771: g_op_table_space:=EDW_OWB_COLLECTION_UTIL.get_table_space(g_bis_owner);
2772: end if;
2773: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Operation table space='||g_op_table_space,FND_LOG.LEVEL_STATEMENT);
2774: l_option_value:=null;
2775: if edw_option.get_warehouse_option(null,g_object_id,'ROLLBACK',l_option_value)=false then
2776: null;
2777: end if;
2778: g_rollback:=l_option_value;
2779: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Rollback Segment='||g_rollback,FND_LOG.LEVEL_STATEMENT);

Line 2781: if edw_option.get_warehouse_option(null,g_object_id,'UPDATETYPE',l_option_value)=false then

2777: end if;
2778: g_rollback:=l_option_value;
2779: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Rollback Segment='||g_rollback,FND_LOG.LEVEL_STATEMENT);
2780: l_option_value:=null;
2781: if edw_option.get_warehouse_option(null,g_object_id,'UPDATETYPE',l_option_value)=false then
2782: null;
2783: end if;
2784: if l_option_value is not null then
2785: g_update_type:=l_option_value;

Line 2794: if edw_option.get_warehouse_option(null,g_object_id,'SMARTUPDATE',l_option_value)=false then

2790: g_update_type:='MASS';
2791: end if;
2792: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Update Type='||g_update_type,FND_LOG.LEVEL_STATEMENT);
2793: l_option_value:=null;
2794: if edw_option.get_warehouse_option(null,g_object_id,'SMARTUPDATE',l_option_value)=false then
2795: null;
2796: end if;
2797: if l_option_value='Y' then
2798: g_smart_update:=true;

Line 2806: if edw_option.get_option_columns(null,g_object_id,'SMARTUPDATE',g_smart_update_cols,

2802: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Smart Update FALSE',FND_LOG.LEVEL_STATEMENT);
2803: end if;
2804: g_number_smart_update_cols:=0;
2805: if g_smart_update then
2806: if edw_option.get_option_columns(null,g_object_id,'SMARTUPDATE',g_smart_update_cols,
2807: g_number_smart_update_cols)=false then
2808: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Error in getting columns for smart update '||edw_option.g_status_message,
2809: FND_LOG.LEVEL_STATEMENT);
2810: g_number_smart_update_cols:=0;

Line 2808: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Error in getting columns for smart update '||edw_option.g_status_message,

2804: g_number_smart_update_cols:=0;
2805: if g_smart_update then
2806: if edw_option.get_option_columns(null,g_object_id,'SMARTUPDATE',g_smart_update_cols,
2807: g_number_smart_update_cols)=false then
2808: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Error in getting columns for smart update '||edw_option.g_status_message,
2809: FND_LOG.LEVEL_STATEMENT);
2810: g_number_smart_update_cols:=0;
2811: end if;
2812: if g_debug then

Line 2820: if edw_option.get_warehouse_option(null,g_object_id,'FK_USE_NL',l_option_value)=false then

2816: end loop;
2817: end if;
2818: end if;
2819: l_option_value:=null;
2820: if edw_option.get_warehouse_option(null,g_object_id,'FK_USE_NL',l_option_value)=false then
2821: null;
2822: end if;
2823: if l_option_value is not null then
2824: g_fk_use_nl:=to_number(l_option_value);

Line 2833: if edw_option.get_warehouse_option(null,g_object_id,'LTC_COPY_MERGE_NL',l_option_value)=false then

2829: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('g_fk_use_nl null. setting to 100,000',FND_LOG.LEVEL_STATEMENT);
2830: g_fk_use_nl:=100000;
2831: end if;
2832: l_option_value:=null;
2833: if edw_option.get_warehouse_option(null,g_object_id,'LTC_COPY_MERGE_NL',l_option_value)=false then
2834: null;
2835: end if;
2836: if l_option_value='Y' then
2837: g_ltc_merge_use_nl:=true;

Line 2846: if edw_option.get_warehouse_option(null,g_object_id,'INCREMENTAL',l_option_value)=false then

2842: end if;
2843: l_option_value:=null;
2844: g_dim_inc_refresh_derv:=false;
2845: if g_object_type='DIMENSION' then
2846: if edw_option.get_warehouse_option(null,g_object_id,'INCREMENTAL',l_option_value)=false then
2847: null;
2848: end if;
2849: if l_option_value='Y' then
2850: g_dim_inc_refresh_derv:=true;--propogate dim changes to derv facts

Line 2855: if edw_option.get_warehouse_option(null,g_object_id,'STG_JOIN_NL',l_option_value)=false then

2851: else
2852: g_dim_inc_refresh_derv:=false;
2853: end if;
2854: end if;
2855: if edw_option.get_warehouse_option(null,g_object_id,'STG_JOIN_NL',l_option_value)=false then
2856: null;
2857: end if;
2858: if l_option_value is not null then
2859: if l_option_value>0 and l_option_value<=100 then

Line 2863: if edw_option.get_warehouse_option(null,g_object_id,'OK_UPDATE',l_option_value)=false then

2859: if l_option_value>0 and l_option_value<=100 then
2860: g_stg_join_nl:=to_number(l_option_value);
2861: end if;
2862: end if;
2863: if edw_option.get_warehouse_option(null,g_object_id,'OK_UPDATE',l_option_value)=false then
2864: null;
2865: end if;
2866: if l_option_value is not null then
2867: if l_option_value>0 and l_option_value<=100 then

Line 2871: if edw_option.get_warehouse_option(null,g_object_id,'STG_MAKE_COPY',l_option_value)=false then

2867: if l_option_value>0 and l_option_value<=100 then
2868: g_ok_switch_update:=to_number(l_option_value);
2869: end if;
2870: end if;
2871: if edw_option.get_warehouse_option(null,g_object_id,'STG_MAKE_COPY',l_option_value)=false then
2872: null;
2873: end if;
2874: if l_option_value is not null then
2875: if l_option_value>0 and l_option_value<=100 then

Line 2881: if edw_option.get_warehouse_option(null,g_object_id,'AUTODANG',l_option_value)=false then

2877: end if;
2878: end if;
2879: g_auto_dang_recovery:=false;
2880: l_option_value:=null;
2881: if edw_option.get_warehouse_option(null,g_object_id,'AUTODANG',l_option_value)=false then
2882: null;
2883: end if;
2884: if l_option_value='Y' then
2885: g_auto_dang_recovery:=true;

Line 2892: if edw_option.get_warehouse_option(null,g_object_id,'MAX_THREADS',l_option_value)=false then

2888: if g_auto_dang_recovery then
2889: g_create_parent_table_records:=true;
2890: end if;
2891: l_option_value:=null;
2892: if edw_option.get_warehouse_option(null,g_object_id,'MAX_THREADS',l_option_value)=false then
2893: null;
2894: end if;
2895: begin
2896: l_num:=to_number(l_option_value);

Line 2907: if edw_option.get_warehouse_option(null,g_object_id,'MIN_JOB_LOAD_SIZE',l_option_value)=false then

2903: if l_num is not null and l_num>0 then
2904: g_max_threads:=l_num;
2905: end if;
2906: l_option_value:=null;
2907: if edw_option.get_warehouse_option(null,g_object_id,'MIN_JOB_LOAD_SIZE',l_option_value)=false then
2908: null;
2909: end if;
2910: if l_option_value is not null and l_option_value>0 then
2911: g_min_job_load_size:=to_number(l_option_value);

Line 2914: if edw_option.get_warehouse_option(null,g_object_id,'SLEEP_TIME',l_option_value)=false then

2910: if l_option_value is not null and l_option_value>0 then
2911: g_min_job_load_size:=to_number(l_option_value);
2912: end if;
2913: l_option_value:=null;
2914: if edw_option.get_warehouse_option(null,g_object_id,'SLEEP_TIME',l_option_value)=false then
2915: null;
2916: end if;
2917: if l_option_value is not null and l_option_value>0 then
2918: g_sleep_time:=to_number(l_option_value);