APPS.GMA_PURGE_DDL dependencies on SY_PURG_DEF

Line 33: l_sqlstatement sy_purg_def.sqlstatement%TYPE;

29: l_objectexists EXCEPTION; -- table already exists
30: l_badtable EXCEPTION; -- table wasn't created
31: l_rowcount NUMBER; -- the number of rows in a table
32:
33: l_sqlstatement sy_purg_def.sqlstatement%TYPE;
34: l_cursor INTEGER;
35: l_dummy NUMBER;
36:
37: l_bytes NUMBER; -- size of new table in blocks

Line 43: l_storage_clause sy_purg_def.sqlstatement%TYPE;

39: l_trans_allowed NUMBER := 5;
40:
41: PRAGMA EXCEPTION_INIT(l_objectexists,-955);
42:
43: l_storage_clause sy_purg_def.sqlstatement%TYPE;
44:
45: BEGIN
46:
47: -- create new table name and create statement

Line 182: l_sqlstatement sy_purg_def.sqlstatement%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;
183: l_cursor INTEGER;
184:
185: BEGIN
186:

Line 221: p_purge_type sy_purg_def.purge_type%TYPE,

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
225: -- create views of archive tables

Line 227: /* CURSOR l_viewtables_cur(cp_purge_type sy_purg_def.purge_type%TYPE) IS

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
228: SELECT table_name
229: FROM sy_purg_def_act
230: WHERE purge_type = cp_purge_type;
231: l_tablename user_tables.table_name%TYPE;

Line 229: FROM sy_purg_def_act

225: -- create views of archive tables
226:
227: /* CURSOR l_viewtables_cur(cp_purge_type sy_purg_def.purge_type%TYPE) IS
228: SELECT table_name
229: FROM sy_purg_def_act
230: WHERE purge_type = cp_purge_type;
231: l_tablename user_tables.table_name%TYPE;
232:
233: CURSOR l_arctables_cur(cp_tablename user_tables.table_name%TYPE) IS

Line 256: l_sqlstatement sy_purg_def.sqlstatement%TYPE;

252: l_tables INTEGER;
253: l_return INTEGER;
254: l_owner user_users.username%TYPE;
255:
256: l_sqlstatement sy_purg_def.sqlstatement%TYPE;
257: l_cursor INTEGER;
258:
259: l_noobject EXCEPTION;
260: PRAGMA EXCEPTION_INIT(l_noobject,-942);

Line 421: FROM sy_purg_def_act

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);
424:
425: TYPE archive_table_rec_type IS RECORD(