1 PACKAGE pay_us_geocode_report_pkg AUTHID CURRENT_USER AS
2 /* $Header: pyusgeoa.pkh 120.0.12020000.2 2012/07/15 11:12:35 emunisek ship $ */
3 --
4 /*
5 ******************************************************************
6 * *
7 * Copyright (C) 1996 Oracle Corporation. *
8 * All rights reserved. *
9 * *
10 * This material has been provided pursuant to an agreement *
11 * containing restrictions on its use. The material is also *
12 * protected by copyright law. No part of this material may *
13 * be copied or distributed, transmitted or transcribed, in *
14 * any form or by any means, electronic, mechanical, magnetic, *
15 * manual, or otherwise, or disclosed to third parties without *
16 * the express written permission of Oracle Corporation, *
17 * 500 Oracle Parkway, Redwood City, CA, 94065. *
18 * *
19 ******************************************************************
20
21 Name : pay_us_geocode_report_pkg
22
23 Description : Package for the geocode upgrade reporting
24 - HTML
25
26 Change List
27 -----------
28 Date Name Vers Bug No Description
29 ---- ---- ------ ------- -----------
30 12-SEP-2005 tclewis 115.0 Created.
31 15-JUL-2012 emunisek 115.1 Bug#14314081. Added the Procedure
32 city_name_change_report for
33 Annual Geocode 2012 Changes
34 */
35
36 PROCEDURE extract_data
37 (errbuf out nocopy varchar2
38 ,retcode out nocopy number
39 ,p_process_mode in varchar2
40 ,p_geocode_patch_name in varchar2
41 );
42
43 PROCEDURE city_name_change_report
44 (p_call varchar2,
45 p_patch_name varchar2,
46 p_mode varchar2,
47 p_geo_phase_id pay_us_geo_update.id%TYPE);
48
49 end pay_us_geocode_report_pkg;