1 PACKAGE pay_eosy_ac_pkg AS
2 /* $Header: pyuseoac.pkh 120.1.12000000.1 2007/01/18 02:24:31 appldev 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 * ma for EO Survey report.
17 * 26-Apr-2001 fusman 115.0
18
19 Name: This package defines the cursors needed to run
20 Payroll Register Multi-Threaded
21 Change List
22 -----------
23 Date Name Vers Description
24 ----------- ---------- ----- -----------------------------------
25 28-Jun-2004 vbanner 115.1 GSCC changes, dbdrv etc.
26 02-Sep-2005 ynegoro 115.2 GSCC changes, nocopy hint
27 */
28
29 --------------------------- range_cursor ---------------------------------
30 PROCEDURE range_cursor (pactid in number,
31 sqlstr out nocopy varchar2);
32
33 ----------------------------- action_creation --------------------------------
34 PROCEDURE action_creation( pactid in number,
35 stperson in number,
36 endperson in number,
37 chunk in number);
38 PROCEDURE sort_action(
39 payactid in varchar2, /* payroll action id */
40 sqlstr in out nocopy varchar2, /* string holding the sql statement */
41 len out nocopy number /* length of the sql string */
42 );
43
44 FUNCTION get_parameter(name in varchar2,
45 parameter_list varchar2)
46 return varchar2;
47 pragma restrict_references(get_parameter, WNDS, WNPS);
48
49 end pay_eosy_ac_pkg;