1 PACKAGE GMO_PURGE AUTHID CURRENT_USER AS
2 /* $Header: GMOVPRGS.pls 120.0 2005/09/21 06:08 bchopra noship $ */
3
4 -- Cleans the device temporary data
5 PROCEDURE PURGE_DEVICE_DATA(P_END_DATE IN DATE,
6 P_TRUNCATE_TABLE IN VARCHAR2,
7 P_COMMIT IN VARCHAR2);
8 -- Cleans the instruction temporary data
9 PROCEDURE PURGE_INSTRUCTION_DATA(P_END_DATE IN DATE,
10 P_TRUNCATE_TABLE IN VARCHAR2,
11 P_COMMIT IN VARCHAR2);
12
13 -- Clean all GMO temporary data
14 PROCEDURE PURGE_ALL(P_END_DATE IN DATE,
15 P_TRUNCATE_TABLE IN VARCHAR2,
16 P_COMMIT IN VARCHAR2);
17 --
18 -- PURGE_ALL
19 -- Concurrent Program version of PURGE_ALL
20 -- IN:
21 -- errbuf - CPM error message
22 -- retcode - CPM return code (0 = success, 1 = warning, 2 = error)
23 -- P_MODULE_NAME default null for all modules i.e. DEVICE and INSTRUCTION
24 -- P_AGE Minimum age of data to purge, default to 1 in concurrent program.
25 -- P_TRUNCATE_TABLE Y or N to indicate truncation of table instead of delete
26
27 PROCEDURE PURGE_ALL(ERRBUF OUT NOCOPY VARCHAR2,
28 RETCODE OUT NOCOPY VARCHAR2,
29 P_MODULE_NAME IN VARCHAR2 DEFAULT NULL,
30 P_AGE IN VARCHAR2 ,
31 P_TRUNCATE_TABLE IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.NO);
32
33
34 END GMO_PURGE;