APPS.GMA_PURGE_DDL dependencies on USER_USERS

Line 6: p_owner user_users.username%TYPE,

2: /* $Header: GMAPRGDB.pls 120.1.12010000.2 2008/11/11 20:56:38 srpuri ship $ */
3:
4: FUNCTION altertableconstraint
5: (p_purge_id sy_purg_mst.purge_id%TYPE,
6: p_owner user_users.username%TYPE,
7: p_appl_short_name fnd_application.application_short_name%TYPE,
8: p_tablename user_tables.table_name%TYPE,
9: p_constraint_name user_constraints.constraint_name%TYPE,
10: p_disable BOOLEAN,

Line 19: p_owner user_users.username%TYPE,

15:
16: FUNCTION createarctable(p_purge_id sy_purg_mst.purge_id%TYPE,
17: p_tablename user_tables.table_name%TYPE,
18: p_tablespace user_tablespaces.tablespace_name%TYPE,
19: p_owner user_users.username%TYPE,
20: p_appl_short_name fnd_application.application_short_name%TYPE,
21: p_sizing_flag BOOLEAN,
22: p_arctablename user_tables.table_name%TYPE,
23: p_debug_flag BOOLEAN)

Line 177: p_owner user_users.username%TYPE,

173:
174: /***********************************************************/
175:
176: PROCEDURE droparctable(p_purge_id sy_purg_mst.purge_id%TYPE,
177: p_owner user_users.username%TYPE,
178: p_appl_short_name fnd_application.application_short_name%TYPE,
179: p_tablename user_tables.table_name%TYPE) IS
180: -- drop named table from database
181:

Line 222: p_owner user_users.username%TYPE,

218: /***********************************************************/
219:
220: PROCEDURE createarcviews(p_purge_id sy_purg_mst.purge_id%TYPE,
221: p_purge_type sy_purg_def.purge_type%TYPE,
222: p_owner user_users.username%TYPE,
223: p_appl_short_name fnd_application.application_short_name%TYPE,
224: p_debug_flag BOOLEAN) IS
225: -- create views of archive tables
226:

Line 254: l_owner user_users.username%TYPE;

250: AND owner='GMA';
251:
252: l_tables INTEGER;
253: l_return INTEGER;
254: l_owner user_users.username%TYPE;
255:
256: l_sqlstatement sy_purg_def.sqlstatement%TYPE;
257: l_cursor INTEGER;
258:

Line 355: p_owner user_users.username%TYPE,

351: /***********************************************************/
352:
353: FUNCTION altertableconstraint
354: (p_purge_id sy_purg_mst.purge_id%TYPE,
355: p_owner user_users.username%TYPE,
356: p_appl_short_name fnd_application.application_short_name%TYPE,
357: p_tablename user_tables.table_name%TYPE,
358: p_constraint_name user_constraints.constraint_name%TYPE,
359: p_disable BOOLEAN,

Line 413: p_owner user_users.username%TYPE,

409: p_tableactions_tab g_tableaction_tab_type,
410: p_tablecount INTEGER,
411: p_idx_tablespace_tab IN OUT NOCOPY g_tablespace_name_tab_type,
412: p_idx_tablespace_count IN OUT NOCOPY INTEGER,
413: p_owner user_users.username%TYPE,
414: p_appl_short_name fnd_application.application_short_name%TYPE,
415: p_action VARCHAR2,
416: p_debug_flag BOOLEAN) IS
417: -- disable or enable all constraints for named table

Line 773: p_owner user_users.username%TYPE,

769: p_tableactions_tab g_tableaction_tab_type,
770: p_tablecount INTEGER,
771: p_indexes_tab IN OUT NOCOPY g_statement_tab_type,
772: p_indexcount IN OUT NOCOPY INTEGER,
773: p_owner user_users.username%TYPE,
774: p_appl_short_name fnd_application.application_short_name%TYPE,
775: p_debug_flag BOOLEAN) IS
776: -- This cursor selects all of the information that we'll need
777: -- to recreate the indexes later on the named table

Line 987: p_owner user_users.username%TYPE,

983: p_indexes_tab g_statement_tab_type,
984: p_indexcount INTEGER,
985: p_idx_tablespace_tab g_tablespace_name_tab_type,
986: p_idx_tablespace_count INTEGER,
987: p_owner user_users.username%TYPE,
988: p_appl_short_name fnd_application.application_short_name%TYPE,
989: p_debug_flag BOOLEAN) IS
990:
991: l_cursor INTEGER;