DBA Data[Home] [Help]

PACKAGE: APPS.PAY_US_W2C_ARCH

Source


1 PACKAGE pay_us_w2c_arch AS
2 /* $Header: pyusw2cp.pkh 120.0.12010000.1 2008/07/27 23:59:09 appldev ship $ */
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_arch
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 get_payroll_action_info(p_payroll_action_id   in number
34                                    ,p_end_date            out nocopy date
35                                    ,p_start_date          out nocopy date
36                                    ,p_business_group_id   out nocopy number
37                                    ,p_tax_unit_id         out nocopy number
38                                    ,p_person_id           out nocopy number
39                                    ,p_asg_set             out nocopy number
40                                    );
41 
42 
43   PROCEDURE w2c_range_cursor(p_payroll_action_id in number
44                             ,p_sqlstr           out nocopy varchar2);
45 
46   PROCEDURE w2c_action_creation(p_payroll_action_id   in number
47                                ,p_start_person_id     in number
48                                ,p_end_person_id       in number
49                                ,p_chunk               in number);
50 
51 
52   FUNCTION get_parameter(name in varchar2,
53                        parameter_list varchar2) return varchar2;
54 
55   g_min_chunk    number:= -1;
56   g_archive_flag varchar2(1) := 'N';
57   g_bal_act_id   number:= -1;
58 
59 END pay_us_w2c_arch;