eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMA_PURGE_ENGINE dependencies on USER_TABLES

Line 27: p_arctablename user_tables.table_name%TYPE,

23: (p_purge_id sy_purg_mst.purge_id%TYPE,
24: p_purge_type sy_purg_def.purge_type%TYPE,
25: p_owner user_users.username%TYPE,
26: p_appl_short_name fnd_application.application_short_name%TYPE,
27: p_arctablename user_tables.table_name%TYPE,
28: p_arctables_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablename_tab_type,
29: p_arcactions_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tableaction_tab_type,
30: p_tablecount IN OUT NOCOPY INTEGER,
31: p_indexes_tab IN OUT NOCOPY GMA_PURGE_DDL.g_statement_tab_type,

Line 46: p_arcrowtable user_tables.table_name%TYPE,

42: p_purge_type sy_purg_def.purge_type%TYPE,
43: p_owner user_users.username%TYPE,
44: p_appl_short_name fnd_application.application_short_name%TYPE,
45: p_user NUMBER,
46: p_arcrowtable user_tables.table_name%TYPE,
47: p_arctables_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablename_tab_type,
48: p_arcactions_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tableaction_tab_type,
49: p_tablecount IN OUT NOCOPY INTEGER,
50: p_totarchiverows IN OUT NOCOPY INTEGER,

Line 62: p_tablespace user_tablespaces.tablespace_name%TYPE,

58: (p_purge_id sy_purg_mst.purge_id%TYPE,
59: p_owner user_users.username%TYPE,
60: p_appl_short_name fnd_application.application_short_name%TYPE,
61: p_sqlstatement sy_purg_def.sqlstatement%TYPE,
62: p_tablespace user_tablespaces.tablespace_name%TYPE,
63: p_arcrowtable user_tables.table_name%TYPE,
64: p_debug_flag BOOLEAN);
65:
66: PROCEDURE logresults

Line 63: p_arcrowtable user_tables.table_name%TYPE,

59: p_owner user_users.username%TYPE,
60: p_appl_short_name fnd_application.application_short_name%TYPE,
61: p_sqlstatement sy_purg_def.sqlstatement%TYPE,
62: p_tablespace user_tablespaces.tablespace_name%TYPE,
63: p_arcrowtable user_tables.table_name%TYPE,
64: p_debug_flag BOOLEAN);
65:
66: PROCEDURE logresults
67: (p_purge_id sy_purg_mst.purge_id%TYPE,

Line 81: p_arcrowbasename user_tables.table_name%TYPE,

77: p_owner user_users.username%TYPE,
78: p_appl_short_name fnd_application.application_short_name%TYPE,
79: p_user NUMBER,
80: p_sqlstatement sy_purg_def.sqlstatement%TYPE,
81: p_arcrowbasename user_tables.table_name%TYPE,
82: p_arctablespace user_tablespaces.tablespace_name%TYPE,
83: p_arctables_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablename_tab_type,
84: p_arcactions_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tableaction_tab_type,
85: p_totarchiverows IN OUT NOCOPY INTEGER,

Line 82: p_arctablespace user_tablespaces.tablespace_name%TYPE,

78: p_appl_short_name fnd_application.application_short_name%TYPE,
79: p_user NUMBER,
80: p_sqlstatement sy_purg_def.sqlstatement%TYPE,
81: p_arcrowbasename user_tables.table_name%TYPE,
82: p_arctablespace user_tablespaces.tablespace_name%TYPE,
83: p_arctables_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablename_tab_type,
84: p_arcactions_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tableaction_tab_type,
85: p_totarchiverows IN OUT NOCOPY INTEGER,
86: p_totdeleterows IN OUT NOCOPY INTEGER,

Line 172: p_arcrowtable user_tables.table_name%TYPE,

168: p_purge_type sy_purg_def.purge_type%TYPE,
169: p_owner user_users.username%TYPE,
170: p_appl_short_name fnd_application.application_short_name%TYPE,
171: p_user NUMBER,
172: p_arcrowtable user_tables.table_name%TYPE,
173: p_arctables_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablename_tab_type,
174: p_arcactions_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tableaction_tab_type,
175: p_tablecount IN OUT NOCOPY INTEGER,
176: p_totarchiverows IN OUT NOCOPY INTEGER,

Line 423: p_arctablename user_tables.table_name%TYPE,

419: (p_purge_id sy_purg_mst.purge_id%TYPE,
420: p_purge_type sy_purg_def.purge_type%TYPE,
421: p_owner user_users.username%TYPE,
422: p_appl_short_name fnd_application.application_short_name%TYPE,
423: p_arctablename user_tables.table_name%TYPE,
424: p_arctables_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablename_tab_type,
425: p_arcactions_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tableaction_tab_type,
426: p_tablecount IN OUT NOCOPY INTEGER,
427: p_indexes_tab IN OUT NOCOPY GMA_PURGE_DDL.g_statement_tab_type,

Line 440: c_arctablename user_tables.table_name%TYPE,

436: -- tables with the right row type (rowid). Put all table names
437: -- in p_arctablestab, with master table first.
438:
439: CURSOR l_tablename_rows_cur (c_purge_type sy_purg_def.purge_type%TYPE,
440: c_arctablename user_tables.table_name%TYPE,
441: c_schema_name VARCHAR2) IS
442: SELECT UC.column_name arctable
443: , UC.data_type drowtype
444: , decode(nvl(SD.archive_action,'K'),'D','D','K') arcaction

Line 659: l_tablespace user_tablespaces.tablespace_name%TYPE;

655:
656: l_user NUMBER;
657: l_sqlstatement sy_purg_def.sqlstatement%TYPE;
658: l_purge_type sy_purg_def.purge_type%TYPE;
659: l_tablespace user_tablespaces.tablespace_name%TYPE;
660:
661: l_tablenames_tab GMA_PURGE_DDL.g_tablename_tab_type;
662: l_tableactions_tab GMA_PURGE_DDL.g_tableaction_tab_type;
663:

Line 1191: p_tablespace user_tablespaces.tablespace_name%TYPE,

1187: PROCEDURE getrows(p_purge_id sy_purg_mst.purge_id%TYPE,
1188: p_owner user_users.username%TYPE,
1189: p_appl_short_name fnd_application.application_short_name%TYPE,
1190: p_sqlstatement sy_purg_def.sqlstatement%TYPE,
1191: p_tablespace user_tablespaces.tablespace_name%TYPE,
1192: p_arcrowtable user_tables.table_name%TYPE,
1193: p_debug_flag BOOLEAN) IS
1194:
1195: -- create master rows table for archive

Line 1192: p_arcrowtable user_tables.table_name%TYPE,

1188: p_owner user_users.username%TYPE,
1189: p_appl_short_name fnd_application.application_short_name%TYPE,
1190: p_sqlstatement sy_purg_def.sqlstatement%TYPE,
1191: p_tablespace user_tablespaces.tablespace_name%TYPE,
1192: p_arcrowtable user_tables.table_name%TYPE,
1193: p_debug_flag BOOLEAN) IS
1194:
1195: -- create master rows table for archive
1196:

Line 1356: p_arcrowbasename user_tables.table_name%TYPE,

1352: p_owner user_users.username%TYPE,
1353: p_appl_short_name fnd_application.application_short_name%TYPE,
1354: p_user NUMBER,
1355: p_sqlstatement sy_purg_def.sqlstatement%TYPE,
1356: p_arcrowbasename user_tables.table_name%TYPE,
1357: p_arctablespace user_tablespaces.tablespace_name%TYPE,
1358: p_arctables_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablename_tab_type,
1359: p_arcactions_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tableaction_tab_type,
1360: p_totarchiverows IN OUT NOCOPY INTEGER,

Line 1357: p_arctablespace user_tablespaces.tablespace_name%TYPE,

1353: p_appl_short_name fnd_application.application_short_name%TYPE,
1354: p_user NUMBER,
1355: p_sqlstatement sy_purg_def.sqlstatement%TYPE,
1356: p_arcrowbasename user_tables.table_name%TYPE,
1357: p_arctablespace user_tablespaces.tablespace_name%TYPE,
1358: p_arctables_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablename_tab_type,
1359: p_arcactions_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tableaction_tab_type,
1360: p_totarchiverows IN OUT NOCOPY INTEGER,
1361: p_totdeleterows IN OUT NOCOPY INTEGER,

Line 1369: l_arcrowtable user_tables.table_name%TYPE;

1365: p_starttime IN OUT NOCOPY DATE,
1366: p_disable_constraints BOOLEAN,
1367: p_debug_flag BOOLEAN) IS
1368:
1369: l_arcrowtable user_tables.table_name%TYPE;
1370: l_tablecount INTEGER;
1371:
1372: BEGIN
1373: