[Home] [Help]
APPS.GMO_PURGE dependencies on GMO_DEVICE_RESPONSES_T
Line 27: execute immediate 'truncate table GMO_DEVICE_RESPONSES_T';
23: RAISE INVALID_PARAM_EXCEPTION;
24: END IF ;
25:
26: IF(P_TRUNCATE_TABLE = GMO_CONSTANTS_GRP.YES) THEN
27: execute immediate 'truncate table GMO_DEVICE_RESPONSES_T';
28: execute immediate 'truncate table GMO_DEVICE_REQUESTS_T';
29: RETURN;
30: END IF;
31:
Line 33: DELETE GMO_DEVICE_RESPONSES_T
29: RETURN;
30: END IF;
31:
32:
33: DELETE GMO_DEVICE_RESPONSES_T
34: WHERE REQUEST_ID IN
35: (SELECT REQUEST_ID
36: FROM GMO_DEVICE_REQUESTS_T
37: WHERE CREATION_DATE <= P_END_DATE );