1 PACKAGE PAY_PRG_PROCESS_EVENTS AUTHID CURRENT_USER AS
2 /* $Header: pyprgevt.pkh 120.1 2010/05/21 13:52:18 pmatamsr noship $ */
3 -------------------------------------------------------------------------------------
4 -- Name : Purge_process_events _PAY_MGR
5 -- Function : This is the Manager Process called by Conc Program
6 -- Purge Process Events
7 -------------------------------------------------------------------------------------
8 PROCEDURE Purge_process_events_PAY_MGR (
9 X_errbuf out NOCOPY varchar2,
10 X_retcode out NOCOPY varchar2,
11 p_purge_date in varchar2,
12 X_batch_size in number default 1000,
13 X_Num_Workers in number default 5);
14 ----------------------------------------------------------------------------------------
15 -- Name :#Purge_process_events_PAY_WKR
16 -- Function : Worker process to Purge Process Events.
17 -- This is called by #Purge_process_events_PAY_MGR
18 ----------------------------------------------------------------------------------------
19 PROCEDURE Purge_process_events_PAY_WKR (
20 X_errbuf out NOCOPY varchar2,
21 X_retcode out NOCOPY varchar2,
22 X_batch_size in number,
23 X_Worker_Id in number,
24 X_Num_Workers in number,
25 X_Argument4 in varchar2 default null,
26 X_Argument5 in varchar2 default null,
27 X_Argument6 in varchar2 default null,
28 X_Argument7 in varchar2 default null,
29 X_Argument8 in varchar2 default null,
30 X_Argument9 in varchar2 default null,
31 X_Argument10 in varchar2 default null);
32 -------------------------------------------------------------------------------------
33 -- Name : Purge_process_events
34 -- Type : Private
35 -- Function : To purge data from pay_process_events table and archive it
36 -- deleted data into pay_process_events_shadow table.
37 -- Pre-reqs :
38 -- Parameters :
39 -- IN : p_purge_date
40 -- p_debug_flag
41 -- x_start_id
42 -- x_end_id
43 --
44 -- OUT : X_errbuf out NOCOPY varchar2,
45 -- X_retcode out NOCOPY varchar2
46 --
47 -- Notes : The Procedure is called from Purge_process_events_PAY_WKR
48 --
49 -- End of comments
50 -------------------------------------------------------------------------------------
51 PROCEDURE Purge_process_events (
52 x_errbuf out nocopy varchar2,
53 x_retcode out nocopy varchar2,
54 x_start_id in number,
55 x_end_id in number,
56 p_purge_date in varchar2,
57 p_debug_flag in varchar2 );
58 END PAY_PRG_PROCESS_EVENTS ;