DBA Data[Home] [Help]

PACKAGE: APPS.PAY_CA_ARCHIVE_RULES

Source


1 PACKAGE PAY_CA_ARCHIVE_RULES AS
2 /* $Header: paycaarcyema.pkh 120.1 2007/01/19 13:28:32 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_CA_ARCHIVE_RULES
23    Description : This package contains the rules for archiving
24                  for missing assignment report specific to CA legislation
25 --
26    Change List
27    -----------
28    Date         Name        Vers   Bug       Description
29    -----------  ----------  -----  --------  ----------------------------------
30    24-Oct-2005  pganguly    115.0            Created
31    19-JAN-2007  ydevi       115.1  4886285   adding the procedure archive_code
32 
33 ******************************************************************************/
34 
35 procedure range_cursor (pactid in number, sqlstr out nocopy varchar2);
36 
37 PROCEDURE action_creation(pactid    IN NUMBER,
38                           stperson  IN NUMBER,
39                           endperson IN NUMBER,
40                           chunk     IN NUMBER,
41                           sqlstr    OUT NOCOPY VARCHAR2);
42 
43 PROCEDURE archive_code (pactid    IN NUMBER,
44                         sqlstr    OUT NOCOPY VARCHAR2);
45 
46 END PAY_CA_ARCHIVE_RULES;