APPS.GMA_PURGE_DDL dependencies on SY_PURG_MST

Line 5: (p_purge_id sy_purg_mst.purge_id%TYPE,

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,
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,

Line 16: FUNCTION createarctable(p_purge_id sy_purg_mst.purge_id%TYPE,

12: RETURN BOOLEAN;
13:
14: /**********************************************************/
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,

Line 176: PROCEDURE droparctable(p_purge_id sy_purg_mst.purge_id%TYPE,

172:
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

Line 220: PROCEDURE createarcviews(p_purge_id sy_purg_mst.purge_id%TYPE,

216: END droparctable;
217:
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

Line 354: (p_purge_id sy_purg_mst.purge_id%TYPE,

350:
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,

Line 407: (p_purge_id sy_purg_mst.purge_id%TYPE,

403:
404: /***********************************************************/
405:
406: PROCEDURE alterconstraints
407: (p_purge_id sy_purg_mst.purge_id%TYPE,
408: p_tablenames_tab g_tablename_tab_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,

Line 419: CURSOR l_tablename_cur(P_purge_id sy_purg_mst.purge_id%TYPE) IS

415: p_action VARCHAR2,
416: p_debug_flag BOOLEAN) IS
417: -- disable or enable all constraints for named table
418:
419: CURSOR l_tablename_cur(P_purge_id sy_purg_mst.purge_id%TYPE) IS
420: SELECT table_name,archive_action
421: FROM sy_purg_def_act
422: WHERE
423: Purge_type=(select PURGE_TYPE from sy_purg_mst where Purge_id=P_purge_id);

Line 423: Purge_type=(select PURGE_TYPE from sy_purg_mst where Purge_id=P_purge_id);

419: CURSOR l_tablename_cur(P_purge_id sy_purg_mst.purge_id%TYPE) IS
420: SELECT table_name,archive_action
421: FROM sy_purg_def_act
422: WHERE
423: Purge_type=(select PURGE_TYPE from sy_purg_mst where Purge_id=P_purge_id);
424:
425: TYPE archive_table_rec_type IS RECORD(
426: archive_table user_tables.table_name%TYPE,
427: archive_action char(1));

Line 567: FUNCTION tab_size(p_purge_id sy_purg_mst.purge_id%TYPE,

563: END;
564:
565: /***********************************************************/
566:
567: FUNCTION tab_size(p_purge_id sy_purg_mst.purge_id%TYPE,
568: p_tablename user_tables.table_name%TYPE,
569: p_rowcount NUMBER,
570: p_initrans NUMBER,
571: p_pctfree NUMBER)

Line 694: (p_purge_id sy_purg_mst.purge_id%TYPE,

690:
691: /***********************************************************/
692:
693: PROCEDURE coalescetablespace
694: (p_purge_id sy_purg_mst.purge_id%TYPE,
695: p_tablespace_name user_tablespaces.tablespace_name%TYPE,
696: p_debug_flag BOOLEAN) IS
697: l_countstatement user_source.text%TYPE;
698: l_alterstatement user_source.text%TYPE;

Line 767: PROCEDURE disableindexes(p_purge_id sy_purg_mst.purge_id%TYPE,

763: END coalescetablespace;
764:
765: /***********************************************************/
766:
767: PROCEDURE disableindexes(p_purge_id sy_purg_mst.purge_id%TYPE,
768: p_tablenames_tab g_tablename_tab_type,
769: p_tableactions_tab g_tableaction_tab_type,
770: p_tablecount INTEGER,
771: p_indexes_tab IN OUT NOCOPY g_statement_tab_type,

Line 982: PROCEDURE enableindexes(p_purge_id sy_purg_mst.purge_id%TYPE,

978: END disableindexes;
979:
980: /***********************************************************/
981:
982: PROCEDURE enableindexes(p_purge_id sy_purg_mst.purge_id%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,