DBA Data[Home] [Help]

APPS.FND_TS_MIG_UTIL dependencies on GL_STORAGE_PARAMETERS

Line 22: -- Set the TABLESPACE_NAME in gl_storage_parameters to INTERFACE.

18: CLOSE ver_csr;
19: RETURN l_version;
20: END get_db_version;
21:
22: -- Set the TABLESPACE_NAME in gl_storage_parameters to INTERFACE.
23: PROCEDURE upd_gl_storage_param (p_tablespace_type VARCHAR2)
24: IS
25: CURSOR tsp_csr IS
26: SELECT tablespace

Line 38: UPDATE gl_storage_parameters

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
39: SET tablespace_name = l_tablespace_name;
40:
41: END upd_gl_storage_param;
42:

Line 260: FROM gl_storage_parameters gsp,

256: CURSOR gl_csr IS
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:

Line 579: -- Set the TABLESPACE_NAME in gl_storage_parameters to INTERFACE.

575: index_tablespace = l_txn_ind_tablespace
576: WHERE oracle_id = usr_rec.oracle_id;
577: END LOOP;
578:
579: -- Set the TABLESPACE_NAME in gl_storage_parameters to INTERFACE.
580: fnd_ts_mig_util.upd_gl_storage_param('INTERFACE');
581:
582: -- Set the new tablespace design flag to Y in fnd_product_groups.
583: UPDATE fnd_product_groups