APPS.GMA_PURGE_DDL dependencies on FND_APPLICATION

Line 17: p_appl_short_name fnd_application.application_short_name%TYPE,

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;

Line 25: p_appl_short_name fnd_application.application_short_name%TYPE,

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,

Line 31: p_appl_short_name fnd_application.application_short_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,

Line 47: p_appl_short_name fnd_application.application_short_name%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:

Line 59: p_appl_short_name fnd_application.application_short_name%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,

Line 68: p_appl_short_name fnd_application.application_short_name%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,