PACKAGE: APPS.FND_GEN_MIG_CMDS

Source

1 PACKAGE fnd_gen_mig_cmds AUTHID CURRENT_USER AS
2 /* $Header: fndpgmcs.pls 120.2 2005/07/02 03:34:18 appldev noship $ */
3 
4  PROCEDURE write_out( p_owner IN VARCHAR2,
5                       p_object_type IN VARCHAR2,
6                       p_mig_cmd IN VARCHAR2,
7                       p_object_name IN VARCHAR2 DEFAULT NULL,
8                       p_old_tablespace IN VARCHAR2 DEFAULT NULL,
9                       p_new_tablespace IN VARCHAR2 DEFAULT NULL,
10                       p_subobject_type IN VARCHAR2 DEFAULT 'X',
11                       p_parent_owner IN VARCHAR2 DEFAULT NULL,
12                       p_parent_object_name IN VARCHAR2 DEFAULT NULL,
13                       p_tot_blocks IN NUMBER DEFAULT 0,
14                       p_index_parallel IN VARCHAR2 DEFAULT 'NOPARALLEL',
15                       p_execution_mode IN VARCHAR2 DEFAULT NULL,
16                       p_partitioned IN VARCHAR2 DEFAULT 'NO',
17                       p_err_text IN VARCHAR2 DEFAULT NULL,
18                       p_parent_lineno IN NUMBER DEFAULT NULL,
19                       x_lineno OUT  NOCOPY NUMBER);
20 
21  FUNCTION get_txn_idx_tablespace RETURN VARCHAR2;
22 
23  FUNCTION get_idx_tablespace(p_tablespace_type IN VARCHAR2,
24                              p_tab_tablespace  IN VARCHAR2,
25                              p_txn_idx_tablespace  IN VARCHAR2)
26   RETURN VARCHAR2;
27 
28  FUNCTION get_tot_blocks ( p_owner IN VARCHAR2,
29                            p_object_type IN VARCHAR2,
30                            p_object_name IN VARCHAR2,
31                            p_partition_name IN VARCHAR2)
32   RETURN NUMBER;
33 
34  PROCEDURE gen_move_obj ( p_owner IN VARCHAR2,
35                           p_obj_type IN VARCHAR2,
36                           p_sub_obj_type IN VARCHAR2,
37                           p_obj_name IN VARCHAR2,
38                           p_partitioned IN VARCHAR2,
39                           p_logging IN VARCHAR2,
40                           p_old_tablespace IN VARCHAR2,
41                           p_new_tablespace IN VARCHAR2,
42                           p_parent_owner IN VARCHAR2 DEFAULT NULL,
43                           p_parent_obj_name IN VARCHAR2 DEFAULT NULL,
44                           p_parent_lineno IN NUMBER DEFAULT NULL,
45                           x_execution_mode OUT  NOCOPY VARCHAR2,
46                           x_lineno OUT  NOCOPY NUMBER);
47 
48  PROCEDURE gen_rebuild_idx( p_owner IN VARCHAR2,
49                             p_table_name IN VARCHAR2,
50                             p_parent_obj_type IN VARCHAR2,
51                             p_tab_moved IN BOOLEAN,
52                             p_tablespace_name IN VARCHAR2,
53                             p_parent_lineno IN NUMBER,
54                             p_execution_mode IN VARCHAR2,
55                             p_type IN VARCHAR2 DEFAULT 'INDEX');
56 
57  FUNCTION get_iot_tablespace(p_owner IN VARCHAR2,
58                              p_iot_name IN VARCHAR2)
59    RETURN VARCHAR2;
60 
61  PROCEDURE gen_move_aqs (p_owner IN VARCHAR2);
62 
63 -- PROCEDURE gen_move_mvlogs (p_owner IN VARCHAR2);
64 
65  PROCEDURE gen_move_mvs (p_owner IN VARCHAR2);
66 
67  PROCEDURE gen_move_longs (p_owner IN VARCHAR2,
68                            p_threshold_size IN NUMBER DEFAULT NULL);
69 
70  PROCEDURE gen_move_tabs (p_owner IN VARCHAR2);
71 
72  PROCEDURE gen_migrate_schema (p_schema IN VARCHAR2,
73                                p_threshold_size IN NUMBER DEFAULT NULL);
74 
75  PROCEDURE gen_alter_constraint (p_schema IN VARCHAR2);
76 
77  PROCEDURE gen_alter_trigger (p_schema IN VARCHAR2);
78 
79  PROCEDURE gen_alter_queue (p_schema IN VARCHAR2);
80 
81  PROCEDURE gen_disable_cmds (p_schema IN VARCHAR2);
82 
83 -- PROCEDURE update_blk_size(p_owner IN VARCHAR2);
84 
85 END fnd_gen_mig_cmds;