APPS.FND_SOA_UTIL dependencies on FND_SOA_RESPONSE

Line 110: FROM FND_SOA_RESPONSE

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

Line 114: FND_SOA_RESPONSE WR

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

Line 140: FND_SOA_RESPONSE ');

136: END;
137:
138: END LOOP;
139: fnd_file.put_line(fnd_file.output,'Deleted '|| rowcount ||' rows from
140: FND_SOA_RESPONSE ');
141: RETURN rowcount;
142: END;
143:
144: /* Purge Function to delete all method Data */

Line 155: FROM FND_SOA_RESPONSE_METHOD

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

Line 160: FND_SOA_RESPONSE)

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

Line 181: FND_SOA_RESPONSE_METHOD ');

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

Line 206: FND_SOA_RESPONSE)))

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

Line 253: FND_SOA_RESPONSE)))

249: OR
250: (WP.BELONGS_TO='RESPONSE' AND message_id NOT IN
251: (SELECT message_id
252: FROM
253: FND_SOA_RESPONSE)))
254: AND rownum <= 1000;
255:
256: temp_rowcount := SQL%ROWCOUNT;
257: COMMIT;