1 PACKAGE pay_ca_city_upd AUTHID CURRENT_USER AS
2 /* $Header: pycactup.pkh 115.2 2003/03/12 19:12:48 ssouresr noship $ */
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_ca_city_upd
22
23 Description : Package that is used to update Canadian city names
24 to their correct French Canadian spelling.
25
26 Change List
27 -----------
28 Date Name Vers Bug No Description
29 ---- ---- ------ ------- -----------
30 23-DEC-02 ssouresr 115.0 2428688 Created.
31 15-JAN-03 ssouresr 115.1 Modified to make compatible
32 with Oracle 8i
33 11-MAR-03 ssouresr 115.2 Added primary_flag_list to remove
34 duplicates from pay_us_city_names
35 */
36
37 TYPE prov_list IS TABLE OF pay_us_counties.county_abbrev%type INDEX BY BINARY_INTEGER;
38 TYPE county_code_list IS TABLE OF pay_ca_display_cities.county_code%type INDEX BY BINARY_INTEGER;
39 TYPE city_code_list IS TABLE OF pay_ca_display_cities.city_code%type INDEX BY BINARY_INTEGER;
40 TYPE old_city_name_list IS TABLE OF pay_ca_display_cities.city_name%type INDEX BY BINARY_INTEGER;
41 TYPE new_city_name_list IS TABLE OF pay_ca_display_cities.display_city_name%type INDEX BY BINARY_INTEGER;
42 TYPE primary_flag_list IS TABLE OF pay_us_city_names.primary_flag%type INDEX BY BINARY_INTEGER;
43
44 FUNCTION get_derived_locale(p_town_or_city in varchar2,
45 p_country in varchar2)
46 RETURN varchar2;
47
48 PROCEDURE cityname_bulk_upd (errbuf out nocopy varchar2,
49 retcode out nocopy number);
50
51 END pay_ca_city_upd;