[Home] [Help]
PACKAGE: APPS.PAY_US_CITY_PKG
Source
1 PACKAGE PAY_US_CITY_PKG as
2 /* $Header: pyusukno.pkh 120.1 2005/08/17 09:47:24 rmonge noship $ */
3 --
4 /*===========================================================================+
5 | Copyright (c) 1995 Oracle Corporation |
6 | All rights reserved. |
7 +============================================================================+
8 Name
9 pay_us_city_pkg
10 Purpose
11 Supports the city block in the form pyusukcy (US CITIES).
12 Notes
13
14 History
15 21-AGU-95 F. Assadi 40.0 Date created.
16 08-Dec-97 K.Mundair 40.4(110.1) Altered parameters to create_unkn_city
17 Bug 509120
18 12-AUG-05 Rosie Monge 115.5 Modified to add a new procedure
19 create_new_geocode as part of the
20 enhacement done to the CITIES
21 form (US) only to allow users
22 to add new GEOCODEs.
23
24 ============================================================================*/
25 --------------------------------------------------------------------------
26 -- Name
27 -- Validate_City
28 -- Purpose
29 -- To check whether the city is an unknown city and hence it is updateable.
30 -- Notes
31 --
32 ----------------------------------------------------------------------------
33 --
34 -----------------------------------------------------------------------------
35 --------------------------------------------------------------------------
36 -- Name --
37 -- Insert_Row --
38 -- Purpose --
39 -- Table handler procedure that supports the insert of a new city via --
40 -- the create city form. --
41 -- Notes --
42 -- --
43 -----------------------------------------------------------------------------
44 --
45 PROCEDURE Insert_Row(p_city_code IN OUT NOCOPY VARCHAR2,
46 p_zprowid IN OUT NOCOPY VARCHAR2,
47 p_cirowid IN OUT NOCOPY VARCHAR2,
48 p_gerowid IN OUT NOCOPY VARCHAR2,
49 p_state_code VARCHAR2,
50 p_county_code VARCHAR2,
51 p_state_name VARCHAR2,
52 p_county_name VARCHAR2,
53 p_city_name VARCHAR2,
54 p_zip_start VARCHAR2,
55 p_zip_end VARCHAR2,
56 p_disable VARCHAR2);
57 --
58 PROCEDURE Lock_Row( p_zprowid VARCHAR2,
59 p_cirowid VARCHAR2,
60 p_gerowid VARCHAR2,
61 p_state_code VARCHAR2,
62 p_county_code VARCHAR2,
63 p_city_code VARCHAR2,
64 p_state_name VARCHAR2,
65 p_county_name VARCHAR2,
66 p_city_name VARCHAR2,
67 p_zip_start VARCHAR2,
68 p_zip_end VARCHAR2);
69 --
70 PROCEDURE Update_Row(p_zprowid VARCHAR2,
71 p_zip_start VARCHAR2,
72 p_zip_end VARCHAR2,
73 p_state_code VARCHAR2,
74 p_county_code VARCHAR2,
75 p_city_code VARCHAR2,
76 p_city_name VARCHAR2,
77 p_disable VARCHAR2);
78 --
79 PROCEDURE Delete_Row(p_zprowid VARCHAR2,
80 p_cirowid VARCHAR2,
81 p_gerowid VARCHAR2);
82 --
83 PROCEDURE chk_city_in_addr(p_state_abbrev VARCHAR2,
84 p_county_name VARCHAR2,
85 p_city_name VARCHAR2);
86
87
88 PROCEDURE create_new_geocode (p_city_code IN OUT NOCOPY VARCHAR2,
89 p_zprowid IN OUT NOCOPY VARCHAR2,
90 p_cirowid IN OUT NOCOPY VARCHAR2,
91 p_gerowid IN OUT NOCOPY VARCHAR2,
92 p_state_code VARCHAR2,
93 p_county_code VARCHAR2,
94 p_state_name VARCHAR2,
95 p_county_name VARCHAR2,
96 p_city_name VARCHAR2,
97 p_zip_start VARCHAR2,
98 p_zip_end VARCHAR2,
99 p_disable VARCHAR2);
100
101
102 PROCEDURE create_unkn_city (p_ci_code IN OUT NOCOPY varchar2,
103 p_st_name IN varchar2,
104 p_co_name IN varchar2,
105 p_ci_name IN varchar2,
106 p_zi_start IN OUT NOCOPY varchar2,
107 p_zi_end IN OUT NOCOPY varchar2,
108 p_disable IN varchar2);
109
110 END PAY_US_CITY_PKG;