DBA Data[Home] [Help]

APPS.GMA_PURGE_DDL dependencies on USER_USERS

Line 16: p_owner user_users.username%TYPE,

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)

Line 24: p_owner user_users.username%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,

Line 30: p_owner user_users.username%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

Line 46: p_owner user_users.username%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

Line 58: p_owner user_users.username%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,

Line 67: p_owner user_users.username%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,