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.CSF_SPATIAL_DATALOAD_PVT dependencies on DUAL

Line 918: select replace(l_create_sql,'l_tablespace',l_tablespace) into l_create_sql from dual;

914: END IF;
915:
916: IF l_index_name IS NOT NULL THEN
917: IF l_create_sql IS NOT NULL THEN
918: select replace(l_create_sql,'l_tablespace',l_tablespace) into l_create_sql from dual;
919: select replace(l_create_sql,'l_index',l_index_name) into l_create_sql from dual;
920: select replace(l_create_sql,'l_table',l_table) into l_create_sql from dual;
921: END IF;
922: /* The following block converts the string of comma seperated

Line 919: select replace(l_create_sql,'l_index',l_index_name) into l_create_sql from dual;

915:
916: IF l_index_name IS NOT NULL THEN
917: IF l_create_sql IS NOT NULL THEN
918: select replace(l_create_sql,'l_tablespace',l_tablespace) into l_create_sql from dual;
919: select replace(l_create_sql,'l_index',l_index_name) into l_create_sql from dual;
920: select replace(l_create_sql,'l_table',l_table) into l_create_sql from dual;
921: END IF;
922: /* The following block converts the string of comma seperated
923: index names to table of varchars.

Line 920: select replace(l_create_sql,'l_table',l_table) into l_create_sql from dual;

916: IF l_index_name IS NOT NULL THEN
917: IF l_create_sql IS NOT NULL THEN
918: select replace(l_create_sql,'l_tablespace',l_tablespace) into l_create_sql from dual;
919: select replace(l_create_sql,'l_index',l_index_name) into l_create_sql from dual;
920: select replace(l_create_sql,'l_table',l_table) into l_create_sql from dual;
921: END IF;
922: /* The following block converts the string of comma seperated
923: index names to table of varchars.
924: */

Line 930: SELECT SUBSTR(l_columns_str, 1, INSTR(l_columns_str , ',')-1) INTO l_column FROM dual;

926: l_columns_arr := CHAR30_ARR();
927: i := 1;
928: LOOP
929: EXIT WHEN INSTR(l_columns_str , ',') = 0 OR INSTR(l_columns_str , ',') is null;
930: SELECT SUBSTR(l_columns_str, 1, INSTR(l_columns_str , ',')-1) INTO l_column FROM dual;
931: SELECT SUBSTR(l_columns_str, INSTR(l_columns_str , ',')+1) INTO l_columns_str FROM dual;
932: l_columns_arr.extend(1);
933: l_columns_arr(i) := l_column;
934: i := i + 1 ;

Line 931: SELECT SUBSTR(l_columns_str, INSTR(l_columns_str , ',')+1) INTO l_columns_str FROM dual;

927: i := 1;
928: LOOP
929: EXIT WHEN INSTR(l_columns_str , ',') = 0 OR INSTR(l_columns_str , ',') is null;
930: SELECT SUBSTR(l_columns_str, 1, INSTR(l_columns_str , ',')-1) INTO l_column FROM dual;
931: SELECT SUBSTR(l_columns_str, INSTR(l_columns_str , ',')+1) INTO l_columns_str FROM dual;
932: l_columns_arr.extend(1);
933: l_columns_arr(i) := l_column;
934: i := i + 1 ;
935: END LOOP;

Line 1027: SELECT replace(l_create_sql,'l_tablespace',l_tablespace) INTO l_create_sql FROM dual;

1023: END IF;
1024: END IF;
1025:
1026: IF l_create_sql IS NOT NULL THEN
1027: SELECT replace(l_create_sql,'l_tablespace',l_tablespace) INTO l_create_sql FROM dual;
1028: SELECT replace(l_create_sql,'l_index',p_index_name) INTO l_create_sql FROM dual;
1029: SELECT replace(l_create_sql,'l_table',l_table) INTO l_create_sql FROM dual;
1030: END IF;
1031:

Line 1028: SELECT replace(l_create_sql,'l_index',p_index_name) INTO l_create_sql FROM dual;

1024: END IF;
1025:
1026: IF l_create_sql IS NOT NULL THEN
1027: SELECT replace(l_create_sql,'l_tablespace',l_tablespace) INTO l_create_sql FROM dual;
1028: SELECT replace(l_create_sql,'l_index',p_index_name) INTO l_create_sql FROM dual;
1029: SELECT replace(l_create_sql,'l_table',l_table) INTO l_create_sql FROM dual;
1030: END IF;
1031:
1032: /* The following block converts the string of comma seperated

Line 1029: SELECT replace(l_create_sql,'l_table',l_table) INTO l_create_sql FROM dual;

1025:
1026: IF l_create_sql IS NOT NULL THEN
1027: SELECT replace(l_create_sql,'l_tablespace',l_tablespace) INTO l_create_sql FROM dual;
1028: SELECT replace(l_create_sql,'l_index',p_index_name) INTO l_create_sql FROM dual;
1029: SELECT replace(l_create_sql,'l_table',l_table) INTO l_create_sql FROM dual;
1030: END IF;
1031:
1032: /* The following block converts the string of comma seperated
1033: index names to table of varchars.

Line 1040: SELECT SUBSTR(l_columns_str, 1, INSTR(l_columns_str , ',')-1) INTO l_column FROM dual;

1036: l_columns_arr := CHAR30_ARR();
1037: i := 1;
1038: LOOP
1039: EXIT WHEN INSTR(l_columns_str , ',') = 0 OR INSTR(l_columns_str , ',') is null;
1040: SELECT SUBSTR(l_columns_str, 1, INSTR(l_columns_str , ',')-1) INTO l_column FROM dual;
1041: SELECT SUBSTR(l_columns_str, INSTR(l_columns_str , ',')+1) INTO l_columns_str FROM dual;
1042: l_columns_arr.extend(1);
1043: l_columns_arr(i) := l_column;
1044: i := i + 1 ;

Line 1041: SELECT SUBSTR(l_columns_str, INSTR(l_columns_str , ',')+1) INTO l_columns_str FROM dual;

1037: i := 1;
1038: LOOP
1039: EXIT WHEN INSTR(l_columns_str , ',') = 0 OR INSTR(l_columns_str , ',') is null;
1040: SELECT SUBSTR(l_columns_str, 1, INSTR(l_columns_str , ',')-1) INTO l_column FROM dual;
1041: SELECT SUBSTR(l_columns_str, INSTR(l_columns_str , ',')+1) INTO l_columns_str FROM dual;
1042: l_columns_arr.extend(1);
1043: l_columns_arr(i) := l_column;
1044: i := i + 1 ;
1045: END LOOP;