1 PACKAGE WSH_CARRIER_ADDRESS_PKG AUTHID CURRENT_USER as
2 /* $Header: WSHADTHS.pls 115.4 2003/08/22 10:02:31 msutar ship $ */
3
4 PROCEDURE Create_Addressinfo (
5 p_carrier_id IN NUMBER,
6 p_status IN VARCHAR2,
7 p_site_number IN OUT NOCOPY VARCHAR2,
8 p_address1 IN VARCHAR2 DEFAULT NULL,
9 p_address2 IN VARCHAR2 DEFAULT NULL,
10 p_address3 IN VARCHAR2 DEFAULT NULL,
11 p_address4 IN VARCHAR2 DEFAULT NULL,
12 p_city IN VARCHAR2 DEFAULT NULL,
13 p_state IN VARCHAR2 DEFAULT NULL,
14 p_province IN VARCHAR2 DEFAULT NULL,
15 p_postal_code IN VARCHAR2 DEFAULT NULL,
16 p_country IN VARCHAR2 DEFAULT NULL,
17 p_county IN VARCHAR2 DEFAULT NULL,
18 x_location_id IN OUT NOCOPY NUMBER,
19 x_party_site_id IN OUT NOCOPY NUMBER,
20 x_return_status OUT NOCOPY VARCHAR2,
21 x_exception_msg OUT NOCOPY VARCHAR2,
22 x_position OUT NOCOPY NUMBER,
23 x_procedure OUT NOCOPY VARCHAR2,
24 x_sqlerr OUT NOCOPY VARCHAR2,
25 x_sql_code OUT NOCOPY VARCHAR2 );
26
27
28 PROCEDURE Update_Addressinfo (
29 p_carrier_party_id IN NUMBER,
30 p_site_number IN VARCHAR2,
31 p_status IN VARCHAR2,
32 p_party_site_id IN NUMBER,
33 p_location_id IN NUMBER,
34 p_address1 IN VARCHAR2,
35 p_address2 IN VARCHAR2,
36 p_address3 IN VARCHAR2,
37 p_address4 IN VARCHAR2,
38 p_city IN VARCHAR2,
39 p_state IN VARCHAR2,
40 p_province IN VARCHAR2,
41 p_postal_code IN VARCHAR2,
42 p_country IN VARCHAR2,
43 p_county IN VARCHAR2,
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_exception_msg OUT NOCOPY VARCHAR2,
46 x_position OUT NOCOPY NUMBER,
47 x_procedure OUT NOCOPY VARCHAR2,
48 x_sqlerr OUT NOCOPY VARCHAR2,
49 x_sql_code OUT NOCOPY VARCHAR2 );
50
51
52 FUNCTION Concatenate_Address(
53 p_address1 IN VARCHAR2,
54 p_address2 IN VARCHAR2,
55 p_address3 IN VARCHAR2,
56 p_address4 IN VARCHAR2,
57 p_city IN VARCHAR2,
58 p_postal_code IN VARCHAR2,
59 p_state IN VARCHAR2,
60 p_province IN VARCHAR2,
61 p_country IN VARCHAR2,
62 p_county IN VARCHAR2 ) RETURN VARCHAR2;
63
64 END WSH_CARRIER_ADDRESS_PKG;