APPS.GMA_PURGE_DDL dependencies on GMA_PURGE_DDL

Line 1: PACKAGE BODY GMA_PURGE_DDL AS

1: PACKAGE BODY GMA_PURGE_DDL AS
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,

Line 52: GMA_PURGE_DDL.coalescetablespace(p_purge_id,

48: l_newtablename := GMA_PURGE_UTILITIES.makearcname(p_purge_id,p_tablename);
49: l_cursor := DBMS_SQL.OPEN_CURSOR;
50:
51: -- coalesce the tablespace
52: GMA_PURGE_DDL.coalescetablespace(p_purge_id,
53: p_tablespace,
54: p_debug_flag);
55:
56: -- set up storage clause if so asked

Line 71: l_bytes := GMA_PURGE_DDL.tab_size(p_purge_id,

67: DBMS_SQL.DEFINE_COLUMN(l_cursor,1,l_rowcount);
68: l_dummy := DBMS_SQL.EXECUTE_AND_FETCH(l_cursor);
69: DBMS_SQL.COLUMN_VALUE(l_cursor,1,l_rowcount);
70:
71: l_bytes := GMA_PURGE_DDL.tab_size(p_purge_id,
72: p_tablename,
73: l_rowcount,
74: l_trans_allowed,
75: 0); -- p_pctfree

Line 165: 'Problem raised in GMA_PURGE_DDL.createarctable with '

161: RETURN NULL;
162:
163: WHEN OTHERS THEN
164: GMA_PURGE_UTILITIES.printlong(p_purge_id,
165: 'Problem raised in GMA_PURGE_DDL.createarctable with '
166: || p_tablename);
167: GMA_PURGE_UTILITIES.printlong(p_purge_id,
168: 'Unhandled EXCEPTION - ' || sqlerrm);
169: RAISE;

Line 211: 'Problem raised in GMA_PURGE_DDL.droparctable.');

207: EXCEPTION
208:
209: WHEN OTHERS THEN
210: GMA_PURGE_UTILITIES.printlong(p_purge_id,
211: 'Problem raised in GMA_PURGE_DDL.droparctable.');
212: GMA_PURGE_UTILITIES.printlong(p_purge_id,
213: 'Unhandled EXCEPTION - ' || sqlerrm);
214: RAISE;
215:

Line 341: 'Problem raised in GMA_PURGE_DDL.createarcviews.');

337: 'Warning: '||'A'||l_viewname||' View cannot get replaced (column mismatch)');
338: ELSE
339:
340: GMA_PURGE_UTILITIES.printlong(p_purge_id,
341: 'Problem raised in GMA_PURGE_DDL.createarcviews.');
342: GMA_PURGE_UTILITIES.printlong(p_purge_id,
343: 'Unhandled EXCEPTION - ' || SQLERRM);
344: RAISE;
345: END IF;

Line 396: 'Raised in GMA_PURGE_DDL.altertableconstraint.');

392:
393: WHEN OTHERS THEN
394: IF (p_debug_flag = TRUE) THEN
395: GMA_PURGE_UTILITIES.printlong(p_purge_id,
396: 'Raised in GMA_PURGE_DDL.altertableconstraint.');
397: GMA_PURGE_UTILITIES.printlong(p_purge_id,
398: 'Ignored EXCEPTION - ' || SQLERRM);
399: END IF;
400: RETURN FALSE;

Line 559: 'Problem raised in GMA_PURGE_DDL.alterconstraints.');

555: EXCEPTION
556:
557: WHEN OTHERS THEN
558: GMA_PURGE_UTILITIES.printlong(p_purge_id,
559: 'Problem raised in GMA_PURGE_DDL.alterconstraints.');
560: GMA_PURGE_UTILITIES.printlong(p_purge_id,
561: 'Unhandled EXCEPTION - ' || SQLERRM);
562: RAISE;
563: END;

Line 683: 'Problem raised in GMA_PURGE_DDL.tab_size with '

679: EXCEPTION
680:
681: WHEN OTHERS THEN
682: GMA_PURGE_UTILITIES.printlong(p_purge_id,
683: 'Problem raised in GMA_PURGE_DDL.tab_size with '
684: || p_tablename);
685: GMA_PURGE_UTILITIES.printlong(p_purge_id,
686: 'Unhandled EXCEPTION - ' || sqlerrm);
687: RAISE;

Line 755: 'Problem raised in GMA_PURGE_DDL.coalescetablespace ' ||

751: EXCEPTION
752:
753: WHEN OTHERS THEN
754: GMA_PURGE_UTILITIES.printlong(p_purge_id,
755: 'Problem raised in GMA_PURGE_DDL.coalescetablespace ' ||
756: 'with '
757: || p_tablespace_name);
758: GMA_PURGE_UTILITIES.printlong(p_purge_id,
759: 'Unhandled EXCEPTION - ' || sqlerrm);

Line 973: 'Problem raised in GMA_PURGE_DDL.disableindexes');

969: EXCEPTION
970:
971: WHEN OTHERS THEN
972: GMA_PURGE_UTILITIES.printlong(p_purge_id,
973: 'Problem raised in GMA_PURGE_DDL.disableindexes');
974: GMA_PURGE_UTILITIES.printlong(p_purge_id,
975: 'Unhandled EXCEPTION - ' || sqlerrm);
976: RAISE;
977:

Line 1004: GMA_PURGE_DDL.coalescetablespace(p_purge_id,

1000:
1001: -- coalesce any index tablespaces
1002: IF (p_idx_tablespace_count > 0) THEN
1003: FOR l_idx_tablespace_count IN 0 .. (p_idx_tablespace_count - 1) LOOP
1004: GMA_PURGE_DDL.coalescetablespace(p_purge_id,
1005: p_idx_tablespace_tab(l_idx_tablespace_count),
1006: p_debug_flag);
1007: END LOOP;
1008: END IF;

Line 1066: 'Problem raised in GMA_PURGE_DDL.enableindexes');

1062: EXCEPTION
1063:
1064: WHEN OTHERS THEN
1065: GMA_PURGE_UTILITIES.printlong(p_purge_id,
1066: 'Problem raised in GMA_PURGE_DDL.enableindexes');
1067: GMA_PURGE_UTILITIES.printlong(p_purge_id,
1068: 'Unhandled EXCEPTION - ' || sqlerrm);
1069: RAISE;
1070:

Line 1073: END GMA_PURGE_DDL;

1069: RAISE;
1070:
1071: END enableindexes;
1072:
1073: END GMA_PURGE_DDL;