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)
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
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,
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,
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,
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,
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,
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;