25: p_option_value := NULL;
26:
27: IF (p_option_code = 'DEBUG_SR')
28: THEN
29: p_option_value := fnd_profile.VALUE ('EDW_DEBUG');
30: ELSIF (p_option_code = 'TRACE_SR')
31: THEN
32: p_option_value := fnd_profile.VALUE ('EDW_TRACE');
33: ELSIF (p_option_code = 'PARALLELISM_SR')
28: THEN
29: p_option_value := fnd_profile.VALUE ('EDW_DEBUG');
30: ELSIF (p_option_code = 'TRACE_SR')
31: THEN
32: p_option_value := fnd_profile.VALUE ('EDW_TRACE');
33: ELSIF (p_option_code = 'PARALLELISM_SR')
34: THEN
35: p_option_value := fnd_profile.VALUE ('EDW_PARALLEL_SRC');
36: ELSIF (p_option_code = 'COMMITSIZE_SR')
31: THEN
32: p_option_value := fnd_profile.VALUE ('EDW_TRACE');
33: ELSIF (p_option_code = 'PARALLELISM_SR')
34: THEN
35: p_option_value := fnd_profile.VALUE ('EDW_PARALLEL_SRC');
36: ELSIF (p_option_code = 'COMMITSIZE_SR')
37: THEN
38: p_option_value := fnd_profile.VALUE ('EDW_PUSH_SIZE');
39: ELSIF (p_option_code = 'OPTABLESPACE_SR')
34: THEN
35: p_option_value := fnd_profile.VALUE ('EDW_PARALLEL_SRC');
36: ELSIF (p_option_code = 'COMMITSIZE_SR')
37: THEN
38: p_option_value := fnd_profile.VALUE ('EDW_PUSH_SIZE');
39: ELSIF (p_option_code = 'OPTABLESPACE_SR')
40: THEN
41: p_option_value := fnd_profile.VALUE ('EDW_COL_OP_TABLE_SPACE');
42: ELSIF (p_option_code = 'ROLLBACK_SR')
37: THEN
38: p_option_value := fnd_profile.VALUE ('EDW_PUSH_SIZE');
39: ELSIF (p_option_code = 'OPTABLESPACE_SR')
40: THEN
41: p_option_value := fnd_profile.VALUE ('EDW_COL_OP_TABLE_SPACE');
42: ELSIF (p_option_code = 'ROLLBACK_SR')
43: THEN
44: p_option_value := fnd_profile.VALUE ('EDW_ROLLBACK_SRC');
45: END IF;
40: THEN
41: p_option_value := fnd_profile.VALUE ('EDW_COL_OP_TABLE_SPACE');
42: ELSIF (p_option_code = 'ROLLBACK_SR')
43: THEN
44: p_option_value := fnd_profile.VALUE ('EDW_ROLLBACK_SRC');
45: END IF;
46:
47: IF (p_option_code = 'OPTABLESPACE_SR' AND p_option_value IS NULL)
48: THEN