1 package pay_ca_payrg_pkg AUTHID CURRENT_USER as
2 /* $Header: pycapreg.pkh 115.4 2003/08/17 17:02:56 ssouresr noship $ */
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 29-OCT-1999 jgoswami 110.0 Created.
28 Based on pypayreg.pkh 110.1 99/08/04 rthakur ( Originally created by meshah).
29 30-MAR-2001 jgoswami 115.1 Changed package name from
30 pay_payrg_pkg to pay_ca_payrg_pkg
31 as it was conflicting with pypayreg.pkh
32
33 --
34 */
35 procedure range_cursor ( pactid in number,
36 sqlstr out nocopy varchar2
37 );
38 procedure action_creation ( pactid in number,
39 stperson in number,
40 endperson in number,
41 chunk in number
42 );
43 procedure sort_action ( payactid in varchar2,
44 sqlstr in out nocopy varchar2,
45 len out nocopy number
46 );
47 function get_parameter(name in varchar2,
48 parameter_list varchar2) return varchar2;
49 pragma restrict_references(get_parameter, WNDS, WNPS);
50 --
51 FUNCTION hours_bal_name (p_hours_balance IN NUMBER)
52 RETURN VARCHAR2;
53
54 end pay_ca_payrg_pkg;