1 PACKAGE PAY_US_ARCHIVE_RULES AUTHID CURRENT_USER 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;