APPS.FND_OAM_WS_UTIL dependencies on OAM_PAT_WS_REQUEST

Line 63: FROM OAM_PAT_WS_REQUEST

59: LOOP
60: BEGIN
61:
62: DELETE
63: FROM OAM_PAT_WS_REQUEST
64: WHERE message_id IN
65: (SELECT WR.message_id
66: FROM
67: OAM_PAT_WS_REQUEST WR

Line 67: OAM_PAT_WS_REQUEST WR

63: FROM OAM_PAT_WS_REQUEST
64: WHERE message_id IN
65: (SELECT WR.message_id
66: FROM
67: OAM_PAT_WS_REQUEST WR
68: WHERE
69: (x_start_date IS NOT NULL and x_end_date IS NOT NULL)
70: AND nvl(x_start_date, WR.request_timestamp)<= WR.request_timestamp
71: AND nvl(x_end_date, WR.request_timestamp)>= WR.request_timestamp

Line 90: fnd_file.put_line(fnd_file.output,'Deleted '|| rowcount ||' rows from OAM_PAT_WS_REQUEST ');

86: END IF;
87: END;
88:
89: END LOOP;
90: fnd_file.put_line(fnd_file.output,'Deleted '|| rowcount ||' rows from OAM_PAT_WS_REQUEST ');
91: RETURN rowcount;
92: END;
93:
94:

Line 199: OAM_PAT_WS_REQUEST))

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

Line 245: OAM_PAT_WS_REQUEST))

241: WHERE
242: ((WP.BELONGS_TO='REQUEST' AND message_id NOT IN
243: (SELECT message_id
244: FROM
245: OAM_PAT_WS_REQUEST))
246: OR
247: (WP.BELONGS_TO='RESPONSE' AND message_id NOT IN
248: (SELECT message_id
249: FROM