DBA Data[Home] [Help]

PACKAGE: APPS.PAY_US_ARCHIVE_RULES

Source


1 PACKAGE PAY_US_ARCHIVE_RULES AS
2 /* $Header: payusarcyema.pkh 120.1 2007/01/23 09:33:59 ydevi noship $ */
3 
4 /******************************************************************************
5 
6    ******************************************************************
7    *                                                                *
8    *  Copyright (C) 1996 Oracle Corporation.                        *
9    *  All rights reserved.                                          *
10    *                                                                *
11    *  This material has been provided pursuant to an agreement      *
12    *  containing restrictions on its use.  The material is also     *
13    *  protected by copyright law.  No part of this material may     *
14    *  be copied or distributed, transmitted or transcribed, in      *
15    *  any form or by any means, electronic, mechanical, magnetic,   *
16    *  manual, or otherwise, or disCLOSEd to third parties without   *
17    *  the express written permission of Oracle Corporation,         *
18    *  500 Oracle Parkway, Redwood City, CA, 94065.                  *
19    *                                                                *
20    ******************************************************************
21 --
22    Name        : PAY_US_ARCHIVE_RULES
23    Description : This package contains the rules for archiving
24                  for missing assignment report specific to US legislation
25 --
26    Change List
27    -----------
28    Date         Name        Vers   Bug       Description
29    -----------  ----------  -----  --------  ----------------------------------
30    24-Oct-2005  rdhingra    115.0            Created
31    19-JAN-2007  ydevi       115.1  4886285   added procedure archive_code
32 
33 ******************************************************************************/
34 
35 ----------------------------------- range_cursor ------------------------------
36 procedure range_cursor (pactid in number, sqlstr out nocopy varchar2);
37 
38 ---------------------------------- action_creation ----------------------------------
39 --
40 PROCEDURE action_creation(pactid    IN NUMBER,
41                           stperson  IN NUMBER,
42                           endperson IN NUMBER,
43                           chunk     IN NUMBER,
44                           sqlstr    OUT NOCOPY VARCHAR2);
45 PROCEDURE archive_code (pactid    IN NUMBER,
46                         sqlstr    OUT NOCOPY VARCHAR2);
47 
48 END PAY_US_ARCHIVE_RULES;