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_OPTION dependencies on FND_PROFILE

Line 19: p_option_value:=fnd_profile.value('EDW_DEBUG');

15: begin
16: p_option_value :=null;
17:
18: if (p_option_code='DEBUG') then
19: p_option_value:=fnd_profile.value('EDW_DEBUG');
20: elsif (p_option_code='TRACE') then
21: p_option_value:=fnd_profile.value('EDW_TRACE');
22: elsif (p_option_code='DUPLICATE') then
23: p_option_value:=fnd_profile.value('EDW_DUPLICATE_COLLECT');

Line 21: p_option_value:=fnd_profile.value('EDW_TRACE');

17:
18: if (p_option_code='DEBUG') then
19: p_option_value:=fnd_profile.value('EDW_DEBUG');
20: elsif (p_option_code='TRACE') then
21: p_option_value:=fnd_profile.value('EDW_TRACE');
22: elsif (p_option_code='DUPLICATE') then
23: p_option_value:=fnd_profile.value('EDW_DUPLICATE_COLLECT');
24: elsif (p_option_code='HASHAREA') then
25: p_option_value:=fnd_profile.value('EDW_HASH_AREA_SIZE');

Line 23: p_option_value:=fnd_profile.value('EDW_DUPLICATE_COLLECT');

19: p_option_value:=fnd_profile.value('EDW_DEBUG');
20: elsif (p_option_code='TRACE') then
21: p_option_value:=fnd_profile.value('EDW_TRACE');
22: elsif (p_option_code='DUPLICATE') then
23: p_option_value:=fnd_profile.value('EDW_DUPLICATE_COLLECT');
24: elsif (p_option_code='HASHAREA') then
25: p_option_value:=fnd_profile.value('EDW_HASH_AREA_SIZE');
26: elsif (p_option_code='SORTAREA') then
27: p_option_value:=fnd_profile.value('EDW_EDW_SORT_AREA_SIZE');

Line 25: p_option_value:=fnd_profile.value('EDW_HASH_AREA_SIZE');

21: p_option_value:=fnd_profile.value('EDW_TRACE');
22: elsif (p_option_code='DUPLICATE') then
23: p_option_value:=fnd_profile.value('EDW_DUPLICATE_COLLECT');
24: elsif (p_option_code='HASHAREA') then
25: p_option_value:=fnd_profile.value('EDW_HASH_AREA_SIZE');
26: elsif (p_option_code='SORTAREA') then
27: p_option_value:=fnd_profile.value('EDW_EDW_SORT_AREA_SIZE');
28: elsif (p_option_code='KEYSETSIZE') then
29: p_option_value:=fnd_profile.value('EDW_FK_SET_SIZE');

Line 27: p_option_value:=fnd_profile.value('EDW_EDW_SORT_AREA_SIZE');

23: p_option_value:=fnd_profile.value('EDW_DUPLICATE_COLLECT');
24: elsif (p_option_code='HASHAREA') then
25: p_option_value:=fnd_profile.value('EDW_HASH_AREA_SIZE');
26: elsif (p_option_code='SORTAREA') then
27: p_option_value:=fnd_profile.value('EDW_EDW_SORT_AREA_SIZE');
28: elsif (p_option_code='KEYSETSIZE') then
29: p_option_value:=fnd_profile.value('EDW_FK_SET_SIZE');
30: elsif (p_option_code='FRESHSTART') then
31: p_option_value:=fnd_profile.value('EDW_FRESH_RESTART');

Line 29: p_option_value:=fnd_profile.value('EDW_FK_SET_SIZE');

25: p_option_value:=fnd_profile.value('EDW_HASH_AREA_SIZE');
26: elsif (p_option_code='SORTAREA') then
27: p_option_value:=fnd_profile.value('EDW_EDW_SORT_AREA_SIZE');
28: elsif (p_option_code='KEYSETSIZE') then
29: p_option_value:=fnd_profile.value('EDW_FK_SET_SIZE');
30: elsif (p_option_code='FRESHSTART') then
31: p_option_value:=fnd_profile.value('EDW_FRESH_RESTART');
32: elsif (p_option_code='UPDATETYPE') then
33: p_option_value:=fnd_profile.value('EDW_UPDATE_TYPE');

Line 31: p_option_value:=fnd_profile.value('EDW_FRESH_RESTART');

27: p_option_value:=fnd_profile.value('EDW_EDW_SORT_AREA_SIZE');
28: elsif (p_option_code='KEYSETSIZE') then
29: p_option_value:=fnd_profile.value('EDW_FK_SET_SIZE');
30: elsif (p_option_code='FRESHSTART') then
31: p_option_value:=fnd_profile.value('EDW_FRESH_RESTART');
32: elsif (p_option_code='UPDATETYPE') then
33: p_option_value:=fnd_profile.value('EDW_UPDATE_TYPE');
34: elsif (p_option_code='OPTABLESPACE') then
35: p_option_value:=fnd_profile.value('EDW_OP_TABLE_SPACE');

Line 33: p_option_value:=fnd_profile.value('EDW_UPDATE_TYPE');

29: p_option_value:=fnd_profile.value('EDW_FK_SET_SIZE');
30: elsif (p_option_code='FRESHSTART') then
31: p_option_value:=fnd_profile.value('EDW_FRESH_RESTART');
32: elsif (p_option_code='UPDATETYPE') then
33: p_option_value:=fnd_profile.value('EDW_UPDATE_TYPE');
34: elsif (p_option_code='OPTABLESPACE') then
35: p_option_value:=fnd_profile.value('EDW_OP_TABLE_SPACE');
36: elsif (p_option_code='FK_USE_NL') then
37: p_option_value:=fnd_profile.value('EDW_FK_USE_NL');

Line 35: p_option_value:=fnd_profile.value('EDW_OP_TABLE_SPACE');

31: p_option_value:=fnd_profile.value('EDW_FRESH_RESTART');
32: elsif (p_option_code='UPDATETYPE') then
33: p_option_value:=fnd_profile.value('EDW_UPDATE_TYPE');
34: elsif (p_option_code='OPTABLESPACE') then
35: p_option_value:=fnd_profile.value('EDW_OP_TABLE_SPACE');
36: elsif (p_option_code='FK_USE_NL') then
37: p_option_value:=fnd_profile.value('EDW_FK_USE_NL');
38: elsif (p_option_code='SMARTUPDATE') then
39: p_option_value:=fnd_profile.value('EDW_SMART_UPDATE');

Line 37: p_option_value:=fnd_profile.value('EDW_FK_USE_NL');

33: p_option_value:=fnd_profile.value('EDW_UPDATE_TYPE');
34: elsif (p_option_code='OPTABLESPACE') then
35: p_option_value:=fnd_profile.value('EDW_OP_TABLE_SPACE');
36: elsif (p_option_code='FK_USE_NL') then
37: p_option_value:=fnd_profile.value('EDW_FK_USE_NL');
38: elsif (p_option_code='SMARTUPDATE') then
39: p_option_value:=fnd_profile.value('EDW_SMART_UPDATE');
40: elsif (p_option_code='LTC_COPY_MERGE_NL') then
41: p_option_value:=fnd_profile.value('EDW_LTC_COPY_MERGE_NL');

Line 39: p_option_value:=fnd_profile.value('EDW_SMART_UPDATE');

35: p_option_value:=fnd_profile.value('EDW_OP_TABLE_SPACE');
36: elsif (p_option_code='FK_USE_NL') then
37: p_option_value:=fnd_profile.value('EDW_FK_USE_NL');
38: elsif (p_option_code='SMARTUPDATE') then
39: p_option_value:=fnd_profile.value('EDW_SMART_UPDATE');
40: elsif (p_option_code='LTC_COPY_MERGE_NL') then
41: p_option_value:=fnd_profile.value('EDW_LTC_COPY_MERGE_NL');
42: elsif (p_option_code='COMMITSIZE') then
43: p_option_value:=fnd_profile.value('EDW_COLLECTION_SIZE');

Line 41: p_option_value:=fnd_profile.value('EDW_LTC_COPY_MERGE_NL');

37: p_option_value:=fnd_profile.value('EDW_FK_USE_NL');
38: elsif (p_option_code='SMARTUPDATE') then
39: p_option_value:=fnd_profile.value('EDW_SMART_UPDATE');
40: elsif (p_option_code='LTC_COPY_MERGE_NL') then
41: p_option_value:=fnd_profile.value('EDW_LTC_COPY_MERGE_NL');
42: elsif (p_option_code='COMMITSIZE') then
43: p_option_value:=fnd_profile.value('EDW_COLLECTION_SIZE');
44: elsif (p_option_code='PARALLELISM') then
45: p_option_value:=fnd_profile.value('EDW_PARALLEL');

Line 43: p_option_value:=fnd_profile.value('EDW_COLLECTION_SIZE');

39: p_option_value:=fnd_profile.value('EDW_SMART_UPDATE');
40: elsif (p_option_code='LTC_COPY_MERGE_NL') then
41: p_option_value:=fnd_profile.value('EDW_LTC_COPY_MERGE_NL');
42: elsif (p_option_code='COMMITSIZE') then
43: p_option_value:=fnd_profile.value('EDW_COLLECTION_SIZE');
44: elsif (p_option_code='PARALLELISM') then
45: p_option_value:=fnd_profile.value('EDW_PARALLEL');
46: elsif (p_option_code='DANGLING') then
47: p_option_value:=fnd_profile.value('EDW_TEST_MODE');

Line 45: p_option_value:=fnd_profile.value('EDW_PARALLEL');

41: p_option_value:=fnd_profile.value('EDW_LTC_COPY_MERGE_NL');
42: elsif (p_option_code='COMMITSIZE') then
43: p_option_value:=fnd_profile.value('EDW_COLLECTION_SIZE');
44: elsif (p_option_code='PARALLELISM') then
45: p_option_value:=fnd_profile.value('EDW_PARALLEL');
46: elsif (p_option_code='DANGLING') then
47: p_option_value:=fnd_profile.value('EDW_TEST_MODE');
48: elsif (p_option_code='ROLLBACK') then
49: p_option_value:=fnd_profile.value('EDW_LOAD_ROLLBACK');

Line 47: p_option_value:=fnd_profile.value('EDW_TEST_MODE');

43: p_option_value:=fnd_profile.value('EDW_COLLECTION_SIZE');
44: elsif (p_option_code='PARALLELISM') then
45: p_option_value:=fnd_profile.value('EDW_PARALLEL');
46: elsif (p_option_code='DANGLING') then
47: p_option_value:=fnd_profile.value('EDW_TEST_MODE');
48: elsif (p_option_code='ROLLBACK') then
49: p_option_value:=fnd_profile.value('EDW_LOAD_ROLLBACK');
50: end if;
51:

Line 49: p_option_value:=fnd_profile.value('EDW_LOAD_ROLLBACK');

45: p_option_value:=fnd_profile.value('EDW_PARALLEL');
46: elsif (p_option_code='DANGLING') then
47: p_option_value:=fnd_profile.value('EDW_TEST_MODE');
48: elsif (p_option_code='ROLLBACK') then
49: p_option_value:=fnd_profile.value('EDW_LOAD_ROLLBACK');
50: end if;
51:
52: if (p_option_code='HASHAREA' and p_option_value is null) then
53: select param.value into p_option_value from v$parameter param