PACKAGE: APPS.PAY_US_PSD_UPGRADE_PKG

Source

1 PACKAGE pay_us_psd_upgrade_pkg AUTHID CURRENT_USER AS
2 /*$Header: pyuspsdu.pkh 120.2.12020000.1 2012/07/04 11:53:03 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 PSDCODE Upgrade Process.
10 REM
11 REM
12 REM                     Change History
13 REM
14 REM Vers  Date        Author        Reason
15 REM 115.0 31-MAR-2012 emunisek      created.
16 */
17 --
18 
19 TYPE psdcode_change_record
20 IS RECORD
21   (psdcode_change VARCHAR2(19),
22    state_code     VARCHAR2(2),
23    county_code    VARCHAR2(3),
24    city_code      VARCHAR2(4)
25   );
26 
27 TYPE psdcode_change_table
28 IS TABLE OF psdcode_change_record INDEX BY VARCHAR2(17);
29 
30 tab_psdcode_upgrade_changes psdcode_change_table;
31 
32 g_psdcode_changes_population BOOLEAN DEFAULT FALSE;
33 
34 FUNCTION upgrade_needed (  p_state_code            VARCHAR2 DEFAULT NULL,
35                            p_county_code           VARCHAR2 DEFAULT NULL,
36                            p_city_code             VARCHAR2 DEFAULT NULL,
37                            p_psdcode_change        VARCHAR2 DEFAULT NULL
38                          )
39 RETURN VARCHAR2;
40 
41 PRAGMA RESTRICT_REFERENCES (upgrade_needed, WNDS);
42 
43 PROCEDURE range_cursor (pactid IN NUMBER,
44                         sqlstr OUT NOCOPY VARCHAR2);
45 
46 PROCEDURE action_creation (pactid IN NUMBER,
47                            stperson IN NUMBER,
48                            endperson IN NUMBER,
49                            chunk IN NUMBER);
50 
51 PROCEDURE archive_code  (p_xfr_action_id IN NUMBER,
52                          p_effective_date  IN DATE);
53 
54 PROCEDURE deinitialization (p_payroll_action_id IN NUMBER);
55 
56 PROCEDURE generate_output (p_mode IN VARCHAR2);
57 
58 END pay_us_psd_upgrade_pkg;