1 package pyusdar_pkg AUTHID CURRENT_USER as
2 /* $Header: pyusdar.pkh 115.7 2004/06/08 13:19:25 rmonge ship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1992 Oracle Corporation UK Ltd., *
7 * Chertsey, England. *
8 * *
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 UK Ltd, *
18 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
19 * England. *
20 * *
21 ******************************************************************
22
23 Change List
24 -----------
25 Date Name Vers Bug No Description
26 ----------- ---------- ----- ------- -----------------------------------
27 11-DEC-2001 asasthan 110.2 2122711 Added dbdrv
28 18-MAR-1999 kkawol 110.1 Added get _parameter.
29 05-JAN-1999 kkawol 110.0 715891 Created.
30 17-JAN_2002 tclewis 115.3 Added procedure archive_action_creation for
31 the deposit advice process that runs off of
32 the external process archive.
33 18-FEB-2003 tclewis 115.4 Added NOCOPY directive.
34 16-JAN-04 rmonge 115.6 Changed the package name to
35 pay_us_deposit_advice_pkg
36 08-JUN-04 rmonge 115.7 Cahnged the name back to pyusdar_pkg. There is
37 a new file payuslivearchive.pkh/pkb that
38 delivers the package pay_us_deposit_advice_pkg.
39 All new changes/modifications should be done
40 to pay_us_deposit_advice_pkg. DO NOT MAKE
41 CHANGES to this file. This package is provided
42 for compatilibity reasons.
43 --
44 */
45 procedure range_cursor ( pactid in number,
46 sqlstr out NOCOPY varchar2
47 );
48 procedure action_creation ( pactid in number,
49 stperson in number,
50 endperson in number,
51 chunk in number
52 );
53
54 procedure archive_action_creation ( pactid in number,
55 stperson in number,
56 endperson in number,
57 chunk in number
58 );
59
60 procedure sort_action ( procname in varchar2,
61 sqlstr in out NOCOPY varchar2,
62 len out NOCOPY number
63 );
64 function get_parameter(name in varchar2,
65 parameter_list varchar2) return varchar2;
66 pragma restrict_references(get_parameter, WNDS, WNPS);
67 --
68 end pyusdar_pkg;