APPS.GMA_PURGE_DDL dependencies on FND_APPLICATION

Line 7: p_appl_short_name fnd_application.application_short_name%TYPE,

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,
11: p_debug_flag BOOLEAN)

Line 20: p_appl_short_name fnd_application.application_short_name%TYPE,

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)
24: RETURN BOOLEAN IS

Line 178: p_appl_short_name fnd_application.application_short_name%TYPE,

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:
182: l_sqlstatement sy_purg_def.sqlstatement%TYPE;

Line 223: p_appl_short_name fnd_application.application_short_name%TYPE,

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:
227: /* CURSOR l_viewtables_cur(cp_purge_type sy_purg_def.purge_type%TYPE) IS

Line 356: p_appl_short_name fnd_application.application_short_name%TYPE,

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,
360: p_debug_flag BOOLEAN)

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

Line 774: p_appl_short_name fnd_application.application_short_name%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
778: CURSOR l_idx_details_cur(c_table_name user_tables.table_name%TYPE) IS

Line 988: p_appl_short_name fnd_application.application_short_name%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;
992: l_sqlstatement user_source.text%TYPE;