1 PACKAGE pay_us_w2c_rpt AS
2 /* $Header: pyusw2cr.pkh 120.0 2005/05/29 10:08:54 appldev noship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1993 Oracle Corporation. *
7 * All rights reserved. *
8 * *
9 * This material has been provided pursuant to an agreement *
10 * containing restrictions on its use. The material is also *
11 * protected by copyright law. No part of this material may *
12 * be copied or distributed, transmitted or transcribed, in *
13 * any form or by any means, electronic, mechanical, magnetic, *
14 * manual, or otherwise, or disclosed to third parties without *
15 * the express written permission of Oracle Corporation, *
16 * 500 Oracle Parkway, Redwood City, CA, 94065. *
17 * *
18 ******************************************************************
19
20 Name : pay_us_w2c_rpt
21
22 Description : This procedure is used by W-2C Pre-Process
23 to archive data for W-2C Corrections Reporting.
24
25 Change List
26 -----------
27 Date Name Vers Bug No Description
28 ----------- ---------- ----- ------- -----------------------------------
29 25-JAN-2001 Asasthan 115.0 Created.
30 */
31
32
33 PROCEDURE w2crpt_range_cursor(p_payroll_action_id in number
34 ,p_sqlstr out nocopy varchar2);
35
36 PROCEDURE w2crpt_action_creation(p_payroll_action_id in number
37 ,p_start_person_id in number
38 ,p_end_person_id in number
39 ,p_chunk in number);
40
41 PROCEDURE sort_action(p_payroll_action_id in varchar2
42 ,p_sql_string in out nocopy varchar2
43 ,p_sql_length out nocopy number);
44
45 g_min_chunk number:= -1;
46 g_archive_flag varchar2(1) := 'N';
47 g_bal_act_id number:= -1;
48
49 END pay_us_w2c_rpt;