DBA Data[Home] [Help]

APPS.GMA_PURGE_DDL dependencies on USER_TABLES

Line 4: TYPE g_tablename_tab_type IS TABLE OF user_tables.table_name%TYPE

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)

Line 6: TYPE g_tablespace_name_tab_type IS TABLE OF user_tablespaces.tablespace_name%TYPE

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

Line 14: p_tablename user_tables.table_name%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,

Line 15: p_tablespace user_tablespaces.tablespace_name%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,

Line 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,

Line 26: p_tablename user_tables.table_name%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,

Line 36: p_tablespace_name user_tablespaces.tablespace_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,

Line 72: p_tablename user_tables.table_name%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;