[Home] [Help]
PACKAGE: APPS.PAY_CA_CITY_PKG
Source
1 PACKAGE PAY_CA_CITY_PKG AUTHID CURRENT_USER as
2 /* $Header: pycaukno.pkh 120.0 2011/03/03 10:43:13 rgottipa noship $ */
3 --
4 /*===========================================================================+
5 | Copyright (c) 1995 Oracle Corporation |
6 | All rights reserved. |
7 +============================================================================+
8 Name
9 PAY_CA_CITY_PKG
10 Purpose
11 Supports the city block in the form pycaukcy (CA CITIES).
12 Notes
13
14 History
15 03-Mar-2011 rgottipa 9840322 115.0 Data created.
16
17 ============================================================================*/
18 --------------------------------------------------------------------------
19 -- Name
20 -- Validate_City
21 -- Purpose
22 -- To check whether the city is an unknown city and hence it is updateable.
23 -- Notes
24 --
25 ----------------------------------------------------------------------------
26 --
27 -----------------------------------------------------------------------------
28 --------------------------------------------------------------------------
29 -- Name --
30 -- Insert_Row --
31 -- Purpose --
32 -- Table handler procedure that supports the insert of a new city via --
33 -- the create city form. --
34 -- Notes --
35 -- --
36 -----------------------------------------------------------------------------
37 --
38 PROCEDURE Insert_Row(p_city_code IN OUT NOCOPY VARCHAR2,
39 p_zprowid IN OUT NOCOPY VARCHAR2,
40 p_cirowid IN OUT NOCOPY VARCHAR2,
41 p_gerowid IN OUT NOCOPY VARCHAR2,
42 p_state_code VARCHAR2,
43 p_county_code VARCHAR2,
44 p_state_name VARCHAR2,
45 p_county_name VARCHAR2,
46 p_city_name VARCHAR2,
47 p_zip_start VARCHAR2,
48 p_zip_end VARCHAR2,
49 p_disable VARCHAR2);
50 --
51 PROCEDURE Lock_Row( p_zprowid VARCHAR2,
52 p_cirowid VARCHAR2,
53 p_gerowid VARCHAR2,
54 p_state_code VARCHAR2,
55 p_county_code VARCHAR2,
56 p_city_code VARCHAR2,
57 p_state_name VARCHAR2,
58 p_county_name VARCHAR2,
59 p_city_name VARCHAR2,
60 p_zip_start VARCHAR2,
61 p_zip_end VARCHAR2);
62 --
63 PROCEDURE Update_Row(p_zprowid VARCHAR2,
64 p_zip_start VARCHAR2,
65 p_zip_end VARCHAR2,
66 p_state_code VARCHAR2,
67 p_county_code VARCHAR2,
68 p_city_code VARCHAR2,
69 p_city_name VARCHAR2,
70 p_disable VARCHAR2);
71 --
72 PROCEDURE Delete_Row(p_zprowid VARCHAR2,
73 p_cirowid VARCHAR2,
74 p_gerowid VARCHAR2);
75 --
76 PROCEDURE chk_city_in_addr(p_state_abbrev VARCHAR2,
77 p_county_name VARCHAR2,
78 p_city_name VARCHAR2);
79
80
81 PROCEDURE create_new_geocode (p_city_code IN OUT NOCOPY VARCHAR2,
82 p_zprowid IN OUT NOCOPY VARCHAR2,
83 p_cirowid IN OUT NOCOPY VARCHAR2,
84 p_gerowid IN OUT NOCOPY VARCHAR2,
85 p_state_code VARCHAR2,
86 p_county_code VARCHAR2,
87 p_state_name VARCHAR2,
88 p_county_name VARCHAR2,
89 p_city_name VARCHAR2,
90 p_zip_start VARCHAR2,
91 p_zip_end VARCHAR2,
92 p_disable VARCHAR2);
93
94
95 PROCEDURE create_unkn_city (p_ci_code IN OUT NOCOPY varchar2,
96 p_st_name IN varchar2,
97 p_co_name IN varchar2,
98 p_ci_name IN varchar2,
99 p_zi_start IN OUT NOCOPY varchar2,
100 p_zi_end IN OUT NOCOPY varchar2,
101 p_disable IN varchar2);
102
103 END PAY_CA_CITY_PKG;