DBA Data[Home] [Help]

PACKAGE: APPS.PQP_GB_SWF_ARCHIVE

Source


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;