[Home] [Help]
PACKAGE: APPS.GMA_PURGE_DDL
Source
1 PACKAGE GMA_PURGE_DDL AUTHID CURRENT_USER AS
2 /* $Header: GMAPRGDS.pls 120.0.12010000.1 2008/07/30 06:17:21 appldev ship $ */
3
4 TYPE g_tablename_tab_type IS TABLE OF user_tables.table_name%TYPE
5 INDEX BY BINARY_INTEGER;
6 TYPE g_tablespace_name_tab_type IS TABLE OF user_tablespaces.tablespace_name%TYPE
7 INDEX BY BINARY_INTEGER;
8 TYPE g_tableaction_tab_type IS TABLE OF CHAR(1)
9 INDEX BY BINARY_INTEGER;
10 TYPE g_statement_tab_type IS TABLE OF user_source.text%TYPE
11 INDEX BY BINARY_INTEGER;
12
13 FUNCTION createarctable(p_purge_id sy_purg_mst.purge_id%TYPE,
14 p_tablename user_tables.table_name%TYPE,
15 p_tablespace user_tablespaces.tablespace_name%TYPE,
16 p_owner user_users.username%TYPE,
17 p_appl_short_name fnd_application.application_short_name%TYPE,
18 p_sizing_flag BOOLEAN,
19 p_arctablename user_tables.table_name%TYPE,
20 p_debug_flag BOOLEAN)
21 RETURN BOOLEAN;
22
23 PROCEDURE droparctable(p_purge_id sy_purg_mst.purge_id%TYPE,
24 p_owner user_users.username%TYPE,
25 p_appl_short_name fnd_application.application_short_name%TYPE,
26 p_tablename user_tables.table_name%TYPE);
27
28 PROCEDURE createarcviews(p_purge_id sy_purg_mst.purge_id%TYPE,
29 p_purge_type sy_purg_def.purge_type%TYPE,
30 p_owner user_users.username%TYPE,
31 p_appl_short_name fnd_application.application_short_name%TYPE,
32 p_debug_flag BOOLEAN);
33
34 PROCEDURE coalescetablespace
35 (p_purge_id sy_purg_mst.purge_id%TYPE,
36 p_tablespace_name user_tablespaces.tablespace_name%TYPE,
37 p_debug_flag BOOLEAN);
38
39 PROCEDURE alterconstraints
40 (p_purge_id sy_purg_mst.purge_id%TYPE,
41 p_tablenames_tab g_tablename_tab_type,
42 p_tableactions_tab g_tableaction_tab_type,
43 p_tablecount INTEGER,
44 p_idx_tablespace_tab IN OUT NOCOPY g_tablespace_name_tab_type,
45 p_idx_tablespace_count IN OUT NOCOPY INTEGER,
46 p_owner user_users.username%TYPE,
47 p_appl_short_name fnd_application.application_short_name%TYPE,
48 p_action VARCHAR2,
49 p_debug_flag BOOLEAN);
50 -- disable or enable all constraints for named table
51
52 PROCEDURE disableindexes(p_purge_id sy_purg_mst.purge_id%TYPE,
53 p_tablenames_tab g_tablename_tab_type,
54 p_tableactions_tab g_tableaction_tab_type,
55 p_tablecount INTEGER,
56 p_indexes_tab IN OUT NOCOPY g_statement_tab_type,
57 p_indexcount IN OUT NOCOPY INTEGER,
58 p_owner user_users.username%TYPE,
59 p_appl_short_name fnd_application.application_short_name%TYPE,
60 p_debug_flag BOOLEAN);
61
62 PROCEDURE enableindexes(p_purge_id sy_purg_mst.purge_id%TYPE,
63 p_indexes_tab g_statement_tab_type,
64 p_indexcount INTEGER,
65 p_idx_tablespace_tab g_tablespace_name_tab_type,
66 p_idx_tablespace_count INTEGER,
67 p_owner user_users.username%TYPE,
68 p_appl_short_name fnd_application.application_short_name%TYPE,
69 p_debug_flag BOOLEAN);
70
71 FUNCTION tab_size(p_purge_id sy_purg_mst.purge_id%TYPE,
72 p_tablename user_tables.table_name%TYPE,
73 p_rowcount NUMBER,
74 p_initrans NUMBER,
75 p_pctfree NUMBER)
76 RETURN NUMBER;
77 -- return size of initial extent in bytes
78
79 END GMA_PURGE_DDL;