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.FND_TS_MIG_UTIL dependencies on FND_TABLESPACES

Line 27: FROM fnd_tablespaces

23: PROCEDURE upd_gl_storage_param (p_tablespace_type VARCHAR2)
24: IS
25: CURSOR tsp_csr IS
26: SELECT tablespace
27: FROM fnd_tablespaces
28: WHERE tablespace_type = p_tablespace_type;
29: l_tablespace_name FND_TABLESPACES.TABLESPACE%TYPE;
30: BEGIN
31: OPEN tsp_csr;

Line 29: l_tablespace_name FND_TABLESPACES.TABLESPACE%TYPE;

25: CURSOR tsp_csr IS
26: SELECT tablespace
27: FROM fnd_tablespaces
28: WHERE tablespace_type = p_tablespace_type;
29: l_tablespace_name FND_TABLESPACES.TABLESPACE%TYPE;
30: BEGIN
31: OPEN tsp_csr;
32: FETCH tsp_csr INTO l_tablespace_name;
33: if tsp_csr%NOTFOUND then

Line 34: raise_application_error(-20001, 'Tablespace of type '||p_tablespace_type||' is not present in FND_TABLESPACES table.');

30: BEGIN
31: OPEN tsp_csr;
32: FETCH tsp_csr INTO l_tablespace_name;
33: if tsp_csr%NOTFOUND then
34: raise_application_error(-20001, 'Tablespace of type '||p_tablespace_type||' is not present in FND_TABLESPACES table.');
35: end if;
36: CLOSE tsp_csr;
37:
38: UPDATE gl_storage_parameters

Line 70: FROM fnd_tablespaces

66: RETURN VARCHAR2
67: IS
68: CURSOR tbs_csr IS
69: SELECT tablespace
70: FROM fnd_tablespaces
71: WHERE tablespace_type = p_tablespace_type;
72: l_tablespace_name FND_TABLESPACES.TABLESPACE%TYPE;
73: BEGIN
74: OPEN tbs_csr;

Line 72: l_tablespace_name FND_TABLESPACES.TABLESPACE%TYPE;

68: CURSOR tbs_csr IS
69: SELECT tablespace
70: FROM fnd_tablespaces
71: WHERE tablespace_type = p_tablespace_type;
72: l_tablespace_name FND_TABLESPACES.TABLESPACE%TYPE;
73: BEGIN
74: OPEN tbs_csr;
75: FETCH tbs_csr INTO l_tablespace_name;
76: if tbs_csr%NOTFOUND then

Line 114: FROM fnd_tablespaces

110: PROCEDURE chk_new_tablespaces
111: IS
112: CURSOR tsp_csr IS
113: SELECT tablespace
114: FROM fnd_tablespaces
115: WHERE tablespace NOT IN (select tablespace_name
116: from dba_tablespaces)
117: AND tablespace_type IN ('TRANSACTION_TABLES', 'TRANSACTION_INDEXES', 'REFERENCE', 'ARCHIVE' ,'SUMMARY', 'INTERFACE', 'MEDIA', 'AQ', 'NOLOGGING', 'TOOLS');
118: l_tablespace_name VARCHAR2(30);

Line 142: FROM fnd_tablespaces;

138: end if;
139:
140: SELECT COUNT(1)
141: INTO l_cnt
142: FROM fnd_tablespaces;
143: if l_cnt < 6 then
144: raise_application_error(-20001, 'New Tablespaces definition does not exist in FND_TABLESPACES.');
145: end if;
146:

Line 144: raise_application_error(-20001, 'New Tablespaces definition does not exist in FND_TABLESPACES.');

140: SELECT COUNT(1)
141: INTO l_cnt
142: FROM fnd_tablespaces;
143: if l_cnt < 6 then
144: raise_application_error(-20001, 'New Tablespaces definition does not exist in FND_TABLESPACES.');
145: end if;
146:
147: END chk_new_tables;
148:

Line 158: from fnd_tablespaces

154: WHERE username in (select oracle_username
155: from fnd_oracle_userid
156: where read_only_flag in ('E','A','U','K','M'))
157: AND default_tablespace <> (select tablespace
158: from fnd_tablespaces
159: where tablespace_type = l_def_tab_tsp);
160:
161: CURSOR prd_inst_csr IS
162: SELECT '1'

Line 168: from fnd_tablespaces

164: WHERE oracle_id in (select oracle_id
165: from fnd_oracle_userid
166: where read_only_flag in ('E','A','U','K','M'))
167: AND (index_tablespace <> (select tablespace
168: from fnd_tablespaces
169: where tablespace_type = l_def_ind_tsp)
170: OR
171: tablespace <> (select tablespace
172: from fnd_tablespaces

Line 172: from fnd_tablespaces

168: from fnd_tablespaces
169: where tablespace_type = l_def_ind_tsp)
170: OR
171: tablespace <> (select tablespace
172: from fnd_tablespaces
173: where tablespace_type = l_def_tab_tsp));
174: l_dummy VARCHAR2(1);
175:
176: CURSOR prd_grps_csr IS

Line 211: FROM fnd_tablespaces

207: l_pref_name IN VARCHAR2)
208: IS
209: CURSOR get_tsp_csr IS
210: SELECT tablespace
211: FROM fnd_tablespaces
212: WHERE tablespace_type = p_tablespace_type;
213: l_tablespace_name VARCHAR2(30);
214: l_ues NUMBER;
215: l_string VARCHAR2(4000);

Line 221: raise_application_error(-20001, 'Tablespace Type '||p_tablespace_type||' does not exist in FND_TABLESPACES.');

217: BEGIN
218: OPEN get_tsp_csr;
219: FETCH get_tsp_csr INTO l_tablespace_name;
220: if get_tsp_csr%NOTFOUND then
221: raise_application_error(-20001, 'Tablespace Type '||p_tablespace_type||' does not exist in FND_TABLESPACES.');
222: end if;
223: CLOSE get_tsp_csr;
224:
225: l_ues := get_tablespace_ues(l_tablespace_name);

Line 261: fnd_tablespaces ft

257: SELECT gsp.object_name,
258: gsp.tablespace_name,
259: ft.tablespace_type
260: FROM gl_storage_parameters gsp,
261: fnd_tablespaces ft
262: WHERE gsp.tablespace_name = ft.tablespace
263: AND object_type = 'T';
264:
265: CURSOR gl_tab_csr(l_table_name VARCHAR2) IS

Line 517: FROM fnd_tablespaces

513: ORDER by dtq.tablespace_name;
514:
515: CURSOR txn_tsp_csr IS
516: SELECT tablespace
517: FROM fnd_tablespaces
518: WHERE tablespace_type = l_def_tab_tsp;
519:
520: CURSOR txn_ind_tsp_csr IS
521: SELECT tablespace

Line 522: FROM fnd_tablespaces

518: WHERE tablespace_type = l_def_tab_tsp;
519:
520: CURSOR txn_ind_tsp_csr IS
521: SELECT tablespace
522: FROM fnd_tablespaces
523: WHERE tablespace_type = l_def_ind_tsp;
524:
525: CURSOR tsp_csr IS
526: SELECT ft.tablespace

Line 527: FROM fnd_tablespaces ft;

523: WHERE tablespace_type = l_def_ind_tsp;
524:
525: CURSOR tsp_csr IS
526: SELECT ft.tablespace
527: FROM fnd_tablespaces ft;
528:
529: l_string VARCHAR2(4000);
530: l_txn_tablespace VARCHAR2(30);
531: l_txn_ind_tablespace VARCHAR2(30);

Line 538: raise_application_error(-20001, 'Tablespace of type '||l_def_tab_tsp||' is not present in FND_TABLESPACES table.');

534:
535: OPEN txn_tsp_csr;
536: FETCH txn_tsp_csr INTO l_txn_tablespace;
537: if txn_tsp_csr%NOTFOUND then
538: raise_application_error(-20001, 'Tablespace of type '||l_def_tab_tsp||' is not present in FND_TABLESPACES table.');
539: end if;
540: CLOSE txn_tsp_csr;
541:
542: OPEN txn_ind_tsp_csr;

Line 545: raise_application_error(-20001, 'Tablespace of type '||l_def_ind_tsp||' is not present in FND_TABLESPACES table.');

541:
542: OPEN txn_ind_tsp_csr;
543: FETCH txn_ind_tsp_csr INTO l_txn_ind_tablespace;
544: if txn_ind_tsp_csr%NOTFOUND then
545: raise_application_error(-20001, 'Tablespace of type '||l_def_ind_tsp||' is not present in FND_TABLESPACES table.');
546: end if;
547: CLOSE txn_ind_tsp_csr;
548:
549: FOR usr_rec IN usr_csr