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 );