DBA Data[Home] [Help]

APPS.FND_SOA_UTIL dependencies on FND_SOA_REQUEST

Line 65: FROM FND_SOA_REQUEST

61: LOOP
62: BEGIN
63:
64: DELETE
65: FROM FND_SOA_REQUEST
66: WHERE message_id IN
67: (SELECT WR.message_id
68: FROM
69: FND_SOA_REQUEST WR

Line 69: FND_SOA_REQUEST WR

65: FROM FND_SOA_REQUEST
66: WHERE message_id IN
67: (SELECT WR.message_id
68: FROM
69: FND_SOA_REQUEST WR
70: WHERE
71: (x_start_date IS NOT NULL and x_end_date IS NOT NULL)
72: AND x_start_date<= trunc(WR.request_timestamp,'DD')
73: AND x_end_date>= trunc(WR.request_timestamp,'DD')

Line 93: FND_SOA_REQUEST ');

89: END;
90:
91: END LOOP;
92: fnd_file.put_line(fnd_file.output,'Deleted '|| rowcount ||' rows from
93: FND_SOA_REQUEST ');
94: RETURN rowcount;
95: END;
96:
97:

Line 201: FND_SOA_REQUEST))

197: WHERE
198: ((WA.BELONGS_TO='REQUEST' AND message_id NOT IN
199: (SELECT message_id
200: FROM
201: FND_SOA_REQUEST))
202: OR
203: (WA.BELONGS_TO='RESPONSE' AND message_id NOT IN
204: (SELECT message_id
205: FROM

Line 248: FND_SOA_REQUEST))

244: WHERE
245: ((WP.BELONGS_TO='REQUEST' AND message_id NOT IN
246: (SELECT message_id
247: FROM
248: FND_SOA_REQUEST))
249: OR
250: (WP.BELONGS_TO='RESPONSE' AND message_id NOT IN
251: (SELECT message_id
252: FROM