1 package fnd_soa_util AUTHID CURRENT_USER as
2 /* $Header: FNDSOAUS.pls 120.3.12020000.3 2013/06/08 14:53:17 vshanmug ship $ */
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 module in varchar2);
12
13 /* Purge Function to delete all requests Data */
14 FUNCTION delete_requests_by_date_range(
15 x_direction IN VARCHAR2,
16 x_start_date IN DATE,
17 x_end_date IN DATE) return NUMBER;
18
19 /* Purge Function to delete all method Data */
20 FUNCTION delete_method_by_date_range(
21 x_start_date IN DATE,
22 x_end_date IN DATE) return NUMBER;
23
24 /* Purge Function to delete all attachment Data */
25 FUNCTION delete_att_by_date_range(
26 x_start_date IN DATE,
27 x_end_date IN DATE) return NUMBER;
28
29 /* Purge Function to delete all attachment body Data */
30 FUNCTION delete_body_by_date_range(
31 x_start_date IN DATE,
32 x_end_date IN DATE) return NUMBER;
33
34 /* Purge Function to delete all ErrorData */
35 FUNCTION delete_error_by_date_range(
36 x_start_date IN DATE,
37 x_end_date IN DATE) return NUMBER;
38
39 /* Purge Function to delete all log messages */
40 FUNCTION delete_log_by_date_range(
41 x_start_date IN DATE,
42 x_end_date IN DATE,
43 x_direction IN VARCHAR2) return NUMBER;
44
45 /* Purge Function to delete log messages for an Instance ID*/
46 FUNCTION delete_log_by_instance_id(
47 x_instance_id IN NUMBER) return NUMBER;
48
49 end fnd_soa_util;