1 package fnd_oam_ws_util AUTHID CURRENT_USER as
2 /* $Header: AFOAMWSUTILS.pls 120.1 2005/08/21 12:15:07 ssuprasa noship $ */
3
4
5 /* This routine is used as a concurrent program. */
6 /* Nobody besides the concurrent manager should call it. */
7 procedure delete_by_date_cp( errbuf out NOCOPY varchar2,
8 retcode out NOCOPY varchar2,
9 start_date in varchar2,
10 end_date in varchar2 );
11
12 /* Purge Function to delete all requests Data */
13 FUNCTION delete_requests_by_date_range(
14 x_start_date IN DATE,
15 x_end_date IN DATE) return NUMBER ;
16
17 /* Purge Function to delete all response Data */
18 FUNCTION delete_responses_by_date_range(
19 x_start_date IN DATE,
20 x_end_date IN DATE) return NUMBER;
21
22 /* Purge Function to delete all method Data */
23 FUNCTION delete_method_by_date_range(
24 x_start_date IN DATE,
25 x_end_date IN DATE) return NUMBER;
26
27 /* Purge Function to delete all attachment Data */
28 FUNCTION delete_att_by_date_range(
29 x_start_date IN DATE,
30 x_end_date IN DATE) return NUMBER;
31
32 /* Purge Function to delete all attachment body Data */
33 FUNCTION delete_body_by_date_range(
34 x_start_date IN DATE,
35 x_end_date IN DATE) return NUMBER;
36 end fnd_oam_ws_util;