APPS.FND_OAM_WS_UTIL dependencies on OAM_PAT_WS_RESPONSE

Line 110: FROM OAM_PAT_WS_RESPONSE

106:
107:
108:
109: DELETE
110: FROM OAM_PAT_WS_RESPONSE
111: WHERE message_id IN
112: (SELECT WR.message_id
113: FROM
114: OAM_PAT_WS_RESPONSE WR

Line 114: OAM_PAT_WS_RESPONSE WR

110: FROM OAM_PAT_WS_RESPONSE
111: WHERE message_id IN
112: (SELECT WR.message_id
113: FROM
114: OAM_PAT_WS_RESPONSE WR
115: WHERE
116: (x_start_date IS NOT NULL and x_end_date IS NOT NULL)
117: AND nvl(x_start_date, WR.response_timestamp)<= WR.response_timestamp
118: AND nvl(x_end_date, WR.response_timestamp)>= WR.response_timestamp

Line 154: FROM OAM_PAT_WS_RESPONSE_METHOD

150: LOOP
151: BEGIN
152:
153: DELETE
154: FROM OAM_PAT_WS_RESPONSE_METHOD
155: WHERE
156: message_id NOT IN
157: (SELECT message_id
158: FROM

Line 159: OAM_PAT_WS_RESPONSE)

155: WHERE
156: message_id NOT IN
157: (SELECT message_id
158: FROM
159: OAM_PAT_WS_RESPONSE)
160: AND rownum <= 1000;
161:
162: temp_rowcount := SQL%ROWCOUNT;
163: COMMIT;

Line 179: 'Deleted '|| rowcount ||' rows from OAM_PAT_WS_RESPONSE_METHOD ');

175: END;
176:
177: END LOOP;
178: fnd_file.put_line(fnd_file.output,
179: 'Deleted '|| rowcount ||' rows from OAM_PAT_WS_RESPONSE_METHOD ');
180: RETURN rowcount;
181: END;
182:
183: /* Purge Function to delete all attachment Data */

Line 204: OAM_PAT_WS_RESPONSE)))

200: OR
201: (WA.BELONGS_TO='RESPONSE' AND message_id NOT IN
202: (SELECT message_id
203: FROM
204: OAM_PAT_WS_RESPONSE)))
205: AND rownum <= 1000;
206:
207: temp_rowcount := SQL%ROWCOUNT;
208: COMMIT;

Line 250: OAM_PAT_WS_RESPONSE)))

246: OR
247: (WP.BELONGS_TO='RESPONSE' AND message_id NOT IN
248: (SELECT message_id
249: FROM
250: OAM_PAT_WS_RESPONSE)))
251: AND rownum <= 1000;
252:
253: temp_rowcount := SQL%ROWCOUNT;
254: COMMIT;