1 PACKAGE pay_us_user_city_upgrade_pkg AUTHID CURRENT_USER AS
2 /*$Header: pyususru.pkh 120.0.12020000.1 2012/07/17 04:06:07 emunisek noship $*/
3 /*===========================================================================*
4 | Copyright (c) 2012 Oracle Corporation |
5 | All rights reserved. |
6 *============================================================================*/
7 /*
8 REM DESCRIPTION
9 REM This Package delivers the Code related to User Defined City Upgrade
10 REM Process
11 REM
12 REM
13 REM Change History
14 REM
15 REM Vers Date Author Reason
16 REM 120.0 21-JUN-2012 emunisek created.
17 */
18 --
19
20 PROCEDURE range_cursor (pactid IN NUMBER,
21 sqlstr OUT NOCOPY VARCHAR2);
22
23 PROCEDURE action_creation (pactid IN NUMBER,
24 stperson IN NUMBER,
25 endperson IN NUMBER,
26 chunk IN NUMBER);
27
28 PROCEDURE archive_code (p_xfr_action_id IN NUMBER,
29 p_effective_date IN DATE);
30
31 PROCEDURE deinitialization (p_payroll_action_id IN NUMBER);
32
33 PROCEDURE generate_output (p_mode IN VARCHAR2,p_upgrade_needed IN VARCHAR2);
34
35 END pay_us_user_city_upgrade_pkg;