APPS.GMO_PURGE dependencies on GMO_DEVICE_REQUESTS_T

Line 28: execute immediate 'truncate table GMO_DEVICE_REQUESTS_T';

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

Line 36: FROM GMO_DEVICE_REQUESTS_T

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 );
38:
39: DELETE FROM GMO_DEVICE_REQUESTS_T WHERE CREATION_DATE <= P_END_DATE;
40:

Line 39: DELETE FROM GMO_DEVICE_REQUESTS_T WHERE CREATION_DATE <= P_END_DATE;

35: (SELECT REQUEST_ID
36: FROM GMO_DEVICE_REQUESTS_T
37: WHERE CREATION_DATE <= P_END_DATE );
38:
39: DELETE FROM GMO_DEVICE_REQUESTS_T WHERE CREATION_DATE <= P_END_DATE;
40:
41: IF(P_COMMIT = GMO_CONSTANTS_GRP.YES) THEN
42: COMMIT;
43: END IF;