APPS.GMA_PURGE_DDL dependencies on SY_PURG_MST

Line 13: FUNCTION createarctable(p_purge_id sy_purg_mst.purge_id%TYPE,

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,

Line 23: PROCEDURE droparctable(p_purge_id sy_purg_mst.purge_id%TYPE,

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:

Line 28: PROCEDURE createarcviews(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);

Line 35: (p_purge_id sy_purg_mst.purge_id%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

Line 40: (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,

Line 52: PROCEDURE disableindexes(p_purge_id sy_purg_mst.purge_id%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,

Line 62: PROCEDURE enableindexes(p_purge_id sy_purg_mst.purge_id%TYPE,

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,

Line 71: FUNCTION tab_size(p_purge_id sy_purg_mst.purge_id%TYPE,

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)