DBA Data[Home] [Help]

PACKAGE: APPS.PAY_EOSY_AC_PKG

Source


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;