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 GMA_PURGE_DDL

Line 6: p_tablenames_tab GMA_PURGE_DDL.g_tablename_tab_type,

2: /* $Header: GMAPRGEB.pls 120.1.12010000.1 2008/07/30 06:17:23 appldev ship $ */
3:
4: FUNCTION archivecleanup
5: (p_purge_id sy_purg_mst.purge_id%TYPE,
6: p_tablenames_tab GMA_PURGE_DDL.g_tablename_tab_type,
7: p_tableactions_tab GMA_PURGE_DDL.g_tableaction_tab_type,
8: p_tablecount INTEGER,
9: p_indexes_tab GMA_PURGE_DDL.g_statement_tab_type,
10: p_indexcount INTEGER,

Line 7: p_tableactions_tab GMA_PURGE_DDL.g_tableaction_tab_type,

3:
4: FUNCTION archivecleanup
5: (p_purge_id sy_purg_mst.purge_id%TYPE,
6: p_tablenames_tab GMA_PURGE_DDL.g_tablename_tab_type,
7: p_tableactions_tab GMA_PURGE_DDL.g_tableaction_tab_type,
8: p_tablecount INTEGER,
9: p_indexes_tab GMA_PURGE_DDL.g_statement_tab_type,
10: p_indexcount INTEGER,
11: p_idx_tablespaces_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablespace_name_tab_type,

Line 9: p_indexes_tab GMA_PURGE_DDL.g_statement_tab_type,

5: (p_purge_id sy_purg_mst.purge_id%TYPE,
6: p_tablenames_tab GMA_PURGE_DDL.g_tablename_tab_type,
7: p_tableactions_tab GMA_PURGE_DDL.g_tableaction_tab_type,
8: p_tablecount INTEGER,
9: p_indexes_tab GMA_PURGE_DDL.g_statement_tab_type,
10: p_indexcount INTEGER,
11: p_idx_tablespaces_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablespace_name_tab_type,
12: p_idx_tablespaces_count IN OUT NOCOPY INTEGER,
13: p_owner user_users.username%TYPE,

Line 11: p_idx_tablespaces_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablespace_name_tab_type,

7: p_tableactions_tab GMA_PURGE_DDL.g_tableaction_tab_type,
8: p_tablecount INTEGER,
9: p_indexes_tab GMA_PURGE_DDL.g_statement_tab_type,
10: p_indexcount INTEGER,
11: p_idx_tablespaces_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablespace_name_tab_type,
12: p_idx_tablespaces_count IN OUT NOCOPY INTEGER,
13: p_owner user_users.username%TYPE,
14: p_appl_short_name fnd_application.application_short_name%TYPE,
15: p_disable_constraints BOOLEAN,

Line 28: p_arctables_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablename_tab_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,
32: p_indexcount IN OUT NOCOPY INTEGER,

Line 29: p_arcactions_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tableaction_tab_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,
32: p_indexcount IN OUT NOCOPY INTEGER,
33: p_idx_tablespaces_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablespace_name_tab_type,

Line 31: p_indexes_tab IN OUT NOCOPY GMA_PURGE_DDL.g_statement_tab_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,
32: p_indexcount IN OUT NOCOPY INTEGER,
33: p_idx_tablespaces_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablespace_name_tab_type,
34: p_idx_tablespaces_count IN OUT NOCOPY INTEGER,
35: p_disable_constraints BOOLEAN,

Line 33: p_idx_tablespaces_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablespace_name_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,
32: p_indexcount IN OUT NOCOPY INTEGER,
33: p_idx_tablespaces_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablespace_name_tab_type,
34: p_idx_tablespaces_count IN OUT NOCOPY INTEGER,
35: p_disable_constraints BOOLEAN,
36: p_sizing_flag BOOLEAN,
37: p_debug_flag BOOLEAN)

Line 47: p_arctables_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablename_tab_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,
51: p_totdeleterows IN OUT NOCOPY INTEGER,

Line 48: p_arcactions_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tableaction_tab_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,
51: p_totdeleterows IN OUT NOCOPY INTEGER,
52: p_sizing BOOLEAN,

Line 69: p_arctables_tab GMA_PURGE_DDL.g_tablename_tab_type,

65:
66: PROCEDURE logresults
67: (p_purge_id sy_purg_mst.purge_id%TYPE,
68: p_user NUMBER,
69: p_arctables_tab GMA_PURGE_DDL.g_tablename_tab_type,
70: p_arcactions_tab GMA_PURGE_DDL.g_tableaction_tab_type,
71: p_tablecount INTEGER,
72: p_totarchiverows IN OUT NOCOPY INTEGER,
73: p_totdeleterows IN OUT NOCOPY INTEGER);

Line 70: p_arcactions_tab GMA_PURGE_DDL.g_tableaction_tab_type,

66: PROCEDURE logresults
67: (p_purge_id sy_purg_mst.purge_id%TYPE,
68: p_user NUMBER,
69: p_arctables_tab GMA_PURGE_DDL.g_tablename_tab_type,
70: p_arcactions_tab GMA_PURGE_DDL.g_tableaction_tab_type,
71: p_tablecount INTEGER,
72: p_totarchiverows IN OUT NOCOPY INTEGER,
73: p_totdeleterows IN OUT NOCOPY INTEGER);
74:

Line 83: p_arctables_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablename_tab_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,
87: p_sizing BOOLEAN,

Line 84: p_arcactions_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tableaction_tab_type,

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,
87: p_sizing BOOLEAN,
88: p_commitfrequency INTEGER,

Line 173: p_arctables_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablename_tab_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,
177: p_totdeleterows IN OUT NOCOPY INTEGER,

Line 174: p_arcactions_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tableaction_tab_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,
177: p_totdeleterows IN OUT NOCOPY INTEGER,
178: p_sizing BOOLEAN,

Line 183: l_indexes_tab GMA_PURGE_DDL.g_statement_tab_type;

179: p_commitfrequency INTEGER,
180: p_disable_constraints BOOLEAN,
181: p_debug_flag BOOLEAN) IS
182:
183: l_indexes_tab GMA_PURGE_DDL.g_statement_tab_type;
184: l_idx_tablespaces_tab GMA_PURGE_DDL.g_tablespace_name_tab_type;
185: l_idx_tablespaces_count INTEGER;
186:
187: l_indexcount BINARY_INTEGER;

Line 184: l_idx_tablespaces_tab GMA_PURGE_DDL.g_tablespace_name_tab_type;

180: p_disable_constraints BOOLEAN,
181: p_debug_flag BOOLEAN) IS
182:
183: l_indexes_tab GMA_PURGE_DDL.g_statement_tab_type;
184: l_idx_tablespaces_tab GMA_PURGE_DDL.g_tablespace_name_tab_type;
185: l_idx_tablespaces_count INTEGER;
186:
187: l_indexcount BINARY_INTEGER;
188:

Line 367: p_tablenames_tab GMA_PURGE_DDL.g_tablename_tab_type,

363: /***********************************************************/
364:
365: FUNCTION archivecleanup
366: (p_purge_id sy_purg_mst.purge_id%TYPE,
367: p_tablenames_tab GMA_PURGE_DDL.g_tablename_tab_type,
368: p_tableactions_tab GMA_PURGE_DDL.g_tableaction_tab_type,
369: p_tablecount INTEGER,
370: p_indexes_tab GMA_PURGE_DDL.g_statement_tab_type,
371: p_indexcount INTEGER,

Line 368: p_tableactions_tab GMA_PURGE_DDL.g_tableaction_tab_type,

364:
365: FUNCTION archivecleanup
366: (p_purge_id sy_purg_mst.purge_id%TYPE,
367: p_tablenames_tab GMA_PURGE_DDL.g_tablename_tab_type,
368: p_tableactions_tab GMA_PURGE_DDL.g_tableaction_tab_type,
369: p_tablecount INTEGER,
370: p_indexes_tab GMA_PURGE_DDL.g_statement_tab_type,
371: p_indexcount INTEGER,
372: p_idx_tablespaces_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablespace_name_tab_type,

Line 370: p_indexes_tab GMA_PURGE_DDL.g_statement_tab_type,

366: (p_purge_id sy_purg_mst.purge_id%TYPE,
367: p_tablenames_tab GMA_PURGE_DDL.g_tablename_tab_type,
368: p_tableactions_tab GMA_PURGE_DDL.g_tableaction_tab_type,
369: p_tablecount INTEGER,
370: p_indexes_tab GMA_PURGE_DDL.g_statement_tab_type,
371: p_indexcount INTEGER,
372: p_idx_tablespaces_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablespace_name_tab_type,
373: p_idx_tablespaces_count IN OUT NOCOPY INTEGER,
374: p_owner user_users.username%TYPE,

Line 372: p_idx_tablespaces_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablespace_name_tab_type,

368: p_tableactions_tab GMA_PURGE_DDL.g_tableaction_tab_type,
369: p_tablecount INTEGER,
370: p_indexes_tab GMA_PURGE_DDL.g_statement_tab_type,
371: p_indexcount INTEGER,
372: p_idx_tablespaces_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablespace_name_tab_type,
373: p_idx_tablespaces_count IN OUT NOCOPY INTEGER,
374: p_owner user_users.username%TYPE,
375: p_appl_short_name fnd_application.application_short_name%TYPE,
376: p_disable_constraints BOOLEAN,

Line 383: GMA_PURGE_DDL.enableindexes(p_purge_id,

379: BEGIN
380:
381: -- Re-enable the constraints if we're supposed to.
382: IF (p_disable_constraints = TRUE) THEN
383: GMA_PURGE_DDL.enableindexes(p_purge_id,
384: p_indexes_tab,
385: p_indexcount,
386: p_idx_tablespaces_tab,
387: p_idx_tablespaces_count,

Line 391: GMA_PURGE_DDL.alterconstraints(p_purge_id,

387: p_idx_tablespaces_count,
388: p_owner,
389: p_appl_short_name,
390: p_debug_flag);
391: GMA_PURGE_DDL.alterconstraints(p_purge_id,
392: p_tablenames_tab,
393: p_tableactions_tab,
394: p_tablecount,
395: p_idx_tablespaces_tab,

Line 424: p_arctables_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablename_tab_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,
428: p_indexcount IN OUT NOCOPY INTEGER,

Line 425: p_arcactions_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tableaction_tab_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,
428: p_indexcount IN OUT NOCOPY INTEGER,
429: p_idx_tablespaces_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablespace_name_tab_type,

Line 427: p_indexes_tab IN OUT NOCOPY GMA_PURGE_DDL.g_statement_tab_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,
428: p_indexcount IN OUT NOCOPY INTEGER,
429: p_idx_tablespaces_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablespace_name_tab_type,
430: p_idx_tablespaces_count IN OUT NOCOPY INTEGER,
431: p_disable_constraints BOOLEAN,

Line 429: p_idx_tablespaces_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablespace_name_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,
428: p_indexcount IN OUT NOCOPY INTEGER,
429: p_idx_tablespaces_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablespace_name_tab_type,
430: p_idx_tablespaces_count IN OUT NOCOPY INTEGER,
431: p_disable_constraints BOOLEAN,
432: p_sizing_flag BOOLEAN,
433: p_debug_flag BOOLEAN)

Line 512: IF (GMA_PURGE_DDL.createarctable(p_purge_id,

508: RETURN FALSE;
509: END IF;
510:
511: -- create archive table
512: IF (GMA_PURGE_DDL.createarctable(p_purge_id,
513: l_tablename_row.arctable,
514: l_tablename_row.arctablespace,
515: p_owner,
516: p_appl_short_name,

Line 539: GMA_PURGE_DDL.alterconstraints(p_purge_id,

535: END LOOP; -- each table
536:
537: -- disable constraints if we're supposed to.
538: IF (p_disable_constraints = TRUE) THEN
539: GMA_PURGE_DDL.alterconstraints(p_purge_id,
540: p_arctables_tab,
541: p_arcactions_tab,
542: l_tablecount,
543: p_idx_tablespaces_tab,

Line 549: GMA_PURGE_DDL.disableindexes(p_purge_id,

545: p_owner,
546: p_appl_short_name,
547: 'DISABLE',
548: p_debug_flag);
549: GMA_PURGE_DDL.disableindexes(p_purge_id,
550: p_arctables_tab,
551: p_arcactions_tab,
552: l_tablecount,
553: p_indexes_tab,

Line 661: l_tablenames_tab GMA_PURGE_DDL.g_tablename_tab_type;

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:
664: l_totarchiverows INTEGER;
665: l_totdeleterows INTEGER;

Line 662: l_tableactions_tab GMA_PURGE_DDL.g_tableaction_tab_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:
664: l_totarchiverows INTEGER;
665: l_totdeleterows INTEGER;
666:

Line 1247: p_arctables_tab GMA_PURGE_DDL.g_tablename_tab_type,

1243: /***********************************************************/
1244:
1245: PROCEDURE logresults(p_purge_id sy_purg_mst.purge_id%TYPE,
1246: p_user NUMBER,
1247: p_arctables_tab GMA_PURGE_DDL.g_tablename_tab_type,
1248: p_arcactions_tab GMA_PURGE_DDL.g_tableaction_tab_type,
1249: p_tablecount INTEGER,
1250: p_totarchiverows IN OUT NOCOPY INTEGER,
1251: p_totdeleterows IN OUT NOCOPY INTEGER) IS

Line 1248: p_arcactions_tab GMA_PURGE_DDL.g_tableaction_tab_type,

1244:
1245: PROCEDURE logresults(p_purge_id sy_purg_mst.purge_id%TYPE,
1246: p_user NUMBER,
1247: p_arctables_tab GMA_PURGE_DDL.g_tablename_tab_type,
1248: p_arcactions_tab GMA_PURGE_DDL.g_tableaction_tab_type,
1249: p_tablecount INTEGER,
1250: p_totarchiverows IN OUT NOCOPY INTEGER,
1251: p_totdeleterows IN OUT NOCOPY INTEGER) IS
1252: -- distill results into log format

Line 1358: p_arctables_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tablename_tab_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,
1362: p_sizing BOOLEAN,

Line 1359: p_arcactions_tab IN OUT NOCOPY GMA_PURGE_DDL.g_tableaction_tab_type,

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,
1362: p_sizing BOOLEAN,
1363: p_commitfrequency INTEGER,

Line 1447: GMA_PURGE_DDL.createarcviews(p_purge_id,p_purge_type,p_owner,p_appl_short_name,p_debug_flag);

1443: lpad(to_char(p_totarchiverows),10) || ' ');
1444: -- lpad(to_char(p_totdeleterows),10)); commented
1445: GMA_PURGE_UTILITIES.printlong(p_purge_id,
1446: '');
1447: GMA_PURGE_DDL.createarcviews(p_purge_id,p_purge_type,p_owner,p_appl_short_name,p_debug_flag);
1448:
1449: GMA_PURGE_DDL.droparctable(p_purge_id,p_owner,p_appl_short_name,'ARCHIVEROWS');
1450:
1451: -- Drops the temporary table for GME only. KH

Line 1449: GMA_PURGE_DDL.droparctable(p_purge_id,p_owner,p_appl_short_name,'ARCHIVEROWS');

1445: GMA_PURGE_UTILITIES.printlong(p_purge_id,
1446: '');
1447: GMA_PURGE_DDL.createarcviews(p_purge_id,p_purge_type,p_owner,p_appl_short_name,p_debug_flag);
1448:
1449: GMA_PURGE_DDL.droparctable(p_purge_id,p_owner,p_appl_short_name,'ARCHIVEROWS');
1450:
1451: -- Drops the temporary table for GME only. KH
1452: IF upper(p_purge_type) in('PROD','APRD','AJNL','JRNL','OPSO','AOPS','PORD','APOR') Then
1453: GMA_PURGE_ENGINE.Tempdrop(p_purge_id,p_purge_type,p_debug_flag);

Line 1485: GMA_PURGE_DDL.droparctable(p_purge_id,p_owner,p_appl_short_name,l_viewtable_row.table_name);

1481:
1482: BEGIN
1483:
1484: FOR l_viewtable_row IN l_viewtables_cur(p_purge_type) LOOP
1485: GMA_PURGE_DDL.droparctable(p_purge_id,p_owner,p_appl_short_name,l_viewtable_row.table_name);
1486: END LOOP;
1487:
1488: GMA_PURGE_DDL.createarcviews(p_purge_id,p_purge_type,p_owner,p_appl_short_name,p_debug_flag);
1489:

Line 1488: GMA_PURGE_DDL.createarcviews(p_purge_id,p_purge_type,p_owner,p_appl_short_name,p_debug_flag);

1484: FOR l_viewtable_row IN l_viewtables_cur(p_purge_type) LOOP
1485: GMA_PURGE_DDL.droparctable(p_purge_id,p_owner,p_appl_short_name,l_viewtable_row.table_name);
1486: END LOOP;
1487:
1488: GMA_PURGE_DDL.createarcviews(p_purge_id,p_purge_type,p_owner,p_appl_short_name,p_debug_flag);
1489:
1490: EXCEPTION
1491:
1492: WHEN OTHERS THEN