1 package ECX_PURGE as
2 /* $Header: ECXPRGS.pls 120.2.12010000.2 2008/08/22 20:01:48 cpeixoto ship $*/
3 -- Commit Frequency: Default - commit every 500 records.
4 -- This variable can be changed as needed to control rollback segment
5 -- growth against performance.
6 --
7 commit_frequency number := wf_purge.commit_frequency;
8 commit_frequency_ecx number:=500;
9 --
10 -- procedure PURGE
11 -- Delete records from ecx_outbound_logs which don't have item_type, item_key
12 -- (To delete records which don't have an entry in ecx_doclogs)
13 -- IN:
14 -- transaction_type - transaction type to delete, or null for all transaction type
15 -- transaction_subtype - transaction subtype to delete, or null for all transaction subtype
16 -- party_id - party id to delete, or null for all party id
17 -- party_site_id - party site id to delete, or null for all party site id
18 -- fromdate - from Date or null to start from begining
19 -- todate - end Date or null to delete till latest record
20 -- commitFlag- Do not commit if set to false
21 --
22 procedure PURGE_OUTBOUND(transaction_type in varchar2 default null,
23 transaction_subtype in varchar2 default null,
24 party_id in varchar2 default null,
25 party_site_id in varchar2 default null,
26 fromDate in date default null,
27 toDate in date default null,
28 commitFlag in boolean default true);
29
30 --
31 -- procedure PURGE
32 -- Delete ecxlog from given criteria.
33 -- IN:
34 -- itemtype - Item type to delete, or null for all itemtypes
35 -- itemkey - Item key to delete, or null for all itemkeys
36 -- transaction_type - transaction type to delete, or null for all transaction type
37 -- transaction_subtype - transaction subtype to delete, or null for all transaction subtype
38 -- party_id - party id to delete, or null for all party id
39 -- party_site_id - party site id to delete, or null for all party site id
40 -- fromdate - from Date or null to start from begining
41 -- todate - end Date or null to delete till latest record
42 -- docommit- Do not commit if set to false
43 -- runtimeonly - Delete data which is associated with workflow, if set to true
44 --
45
46 procedure PURGE(item_type in varchar2 default null,
47 item_key in varchar2 default null,
48 transaction_type in varchar2 default null,
49 transaction_subtype in varchar2 default null,
50 party_id in varchar2 default null,
51 party_site_id in varchar2 default null,
52 fromDate in date default null,
53 toDate in date default null,
54 commitFlag in boolean default true,
55 runtimeonly in boolean default false);
56 --
57 -- procedure Items
58 -- Delete items with end_time before argument.
59 -- IN:
60 -- itemtype - Item type to delete, or null for all itemtypes
61 -- itemkey - Item key to delete, or null for all itemkeys
62 -- enddate - Date to obsolete to
63 -- docommit- Do not commit if set to false
64
65 procedure PURGE_ITEMS(itemType in varchar2 default null,
66 itemKey in varchar2 default null,
67 endDate in date default null,
68 docommit in boolean default true,
69 runtimeonly in boolean default false);
70 -- procedure Purge_Transactions
71 --This procedure has been incorporated to make the CP for purging obsolete ECX data.
72 --Delete log details wihin the stipulated date range.
73 -- IN:
74 -- transaction_type - Transaction type to delete, or null for all transaction types
75 -- transaction_subtype - Transaction subtype to delete, or null for all subtypes
76 -- fromdate - Date from which the data to delete.
77 -- todate - Date upto which data has to delete.
78 -- docommit- Do not commit if set to false.
79
80 procedure PURGE_TRANSACTIONS(
81 transaction_type in varchar2 default null,
82 transaction_subtype in varchar2 default null,
83 fromdate in date default null,
84 todate in date default null,
85 docommit in boolean default true);
86 --
87 --Procedure TotalConcurrent
88 -- This wil be called from CP to purge obsolete ECX data.
89 -- IN:
90 -- errbuf - CPM error message
91 -- retcode - CPM return code (0 = success, 1 = warning, 2 = error)
92 -- transactiontype - Transaction type to delete, or null for all transactiontype
93 -- transactionsubtype - Transaction subtype to delete, or null for all transaction subtype.
94 -- fromdate - Date from which the data to delete.
95 -- todate - Date upto which data has to delete.
96 -- x_commit_frequency - The freq. at which commit will take place during deletion.
97 procedure TotalConcurrent(
98 errbuf out NOCOPY varchar2,
99 retcode out NOCOPY varchar2,
100 transaction_type in varchar2 default null,
101 transaction_subtype in varchar2 default null,
102 fromdate in date default null,
103 todate in date default null,
104 x_commit_frequency in number default 500
105 );
106 end ECX_PURGE;