1 package pqp_gb_swf_archive AUTHID CURRENT_USER as
2 /* $Header: pqpgbswfar.pkh 120.1 2010/05/14 06:05:23 dwkrishn noship $ */
3
4 -- public procedure which archives the payroll information, then returns a
5 -- varchar2 defining a sql statement to select all the people that may be
6 -- eligible for swf processing.
7 -- the archiver uses this cursor to split the people into chunks for parallel
8 -- processing.
9 procedure range_cursor (pactid in number,
10 sqlstr out nocopy varchar2);
11 -- checks if an assignment action is created for given payroll_acion_id and assignment_id
12
13
14 procedure action_creation(pactid in number,
15 stperson in number,
16 endperson in number,
17 chunk in number) ;
18 --
19 procedure archive_code (p_assactid in number,
20 p_effective_date in date);
21 --
22 procedure deinit_code(pactid in number);
23
24 procedure archinit(p_payroll_action_id in number);
25
26 end pqp_gb_swf_archive;