PACKAGE: APPS.FND_TS_MIG_UTIL

Source

1 PACKAGE fnd_ts_mig_util AUTHID DEFINER AS
2 /* $Header: fndptmus.pls 120.2 2005/11/15 16:27:51 mnovakov noship $ */
3  l_def_tab_tsp         VARCHAR2(30) := 'TRANSACTION_TABLES';
4  l_aq_tab_tsp          VARCHAR2(30) :=  'AQ';
5  l_md_tab_tsp          VARCHAR2(30) :=  'MEDIA';
6  l_def_ind_tsp         VARCHAR2(30) := 'TRANSACTION_INDEXES';
7  l_def_mv_tsp          VARCHAR2(30) := 'SUMMARY';
8  l_unclass_tsp         VARCHAR2(30) := 'TRANSACTION_TABLES';
9  l_unclass_ind_tsp     VARCHAR2(30) := 'TRANSACTION_INDEXES';
10 
11 
12  FUNCTION get_db_version
13   RETURN NUMBER;
14 
15  -- Set the TABLESPACE_NAME in gl_storage_parameters to INTERFACE.
16  PROCEDURE upd_gl_storage_param (p_tablespace_type VARCHAR2);
17 
18  PROCEDURE migrate_tsp_to_local;
19 
20  FUNCTION get_tablespace_name (p_tablespace_type IN VARCHAR2)
21   RETURN VARCHAR2;
22 
23  FUNCTION get_tablespace_ues (p_tablespace_name IN VARCHAR2)
24   RETURN NUMBER;
25 
26  PROCEDURE chk_new_tablespaces;
27 
28  PROCEDURE chk_new_tables;
29 
30  PROCEDURE chk_product_defaults;
31 
32  PROCEDURE crt_storage_pref (p_tablespace_type IN VARCHAR2,
33                              l_pref_name IN VARCHAR2);
34 
35  PROCEDURE upd_fot_username;
36 
37  PROCEDURE process_rules(p_apps_schema_name IN VARCHAR2);
38 
39  PROCEDURE set_defaults;
40 
41  PROCEDURE crt_txn_ind_pref;
42 
43 END fnd_ts_mig_util;