[Home] [Help]
PACKAGE: APPS.CSP_LOCATION_PKG
Source
1 package CSP_LOCATION_PKG AUTHID CURRENT_USER AS
2 /*$Header: cspgtlos.pls 115.3 2002/11/26 06:52:42 hhaugeru ship $*/
3
4 /*TYPE csp_location_rec_type IS RECORD(
5 location_id NUMBER :=FND_API.G_MISS_NUM,
6 orig_system_reference VARCHAR2(240) := FND_API.G_MISS_CHAR,
7 country VARCHAR2(60) := FND_API.G_MISS_CHAR,
8 address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
9 address2 VARCHAR2(240):= FND_API.G_MISS_CHAR,
10 address3 VARCHAR2(240):= FND_API.G_MISS_CHAR,
11 address4 VARCHAR2(240):= FND_API.G_MISS_CHAR,
12 city VARCHAR2(60) := FND_API.G_MISS_CHAR,
13 postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
14 state VARCHAR2(60) := FND_API.G_MISS_CHAR,
15 province VARCHAR2(60) := FND_API.G_MISS_CHAR,
16 county VARCHAR2(60) := FND_API.G_MISS_CHAR,
17 address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
18 validated_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
19 address_lines_phonetic VARCHAR2(560):= FND_API.G_MISS_CHAR,
20 apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
21 po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
22 house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
23 street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
24 apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
25 secondary_suffix_element VARCHAR2(240):= FND_API.G_MISS_CHAR,
26 street VARCHAR2(50) := FND_API.G_MISS_CHAR,
27 rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
28 rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
29 street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
30 building VARCHAR2(50) := FND_API.G_MISS_CHAR,
31 floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
32 suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
33 room VARCHAR2(50) := FND_API.G_MISS_CHAR,
34 postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
35 time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
36 overseas_address_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
37 post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
38 position VARCHAR2(50) := FND_API.G_MISS_CHAR,
39 delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
40 location_directions VARCHAR2(640):= FND_API.G_MISS_CHAR,
41 address_effective_date DATE := FND_API.G_MISS_DATE,
42 address_expiration_date DATE := FND_API.G_MISS_DATE,
43 address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
44 clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
45 dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
46 trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
47 language VARCHAR2(4) := FND_API.G_MISS_CHAR,
48 life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
49 short_description VARCHAR2(240):= FND_API.G_MISS_CHAR,
50 description VARCHAR2(2000):= FND_API.G_MISS_CHAR,
51 geometry MDSYS.SDO_GEOMETRY := csp_geometry_default,
52 loc_hierarchy_id NUMBER :=FND_API.G_MISS_NUM,
53 sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
54 sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
55 fa_location_id NUMBER :=FND_API.G_MISS_NUM,
56 content_source_type VARCHAR2(30):= HZ_PARTY_PUB.G_MISS_CONTENT_SOURCE_TYPE,
57 attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
58 attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
59 attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
60 attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61 attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62 attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63 attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64 attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65 attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66 attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67 attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68 attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69 attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70 attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71 attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72 attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73 attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74 attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75 attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76 attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77 attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78 global_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
79 global_attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80 global_attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81 global_attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82 global_attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83 global_attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84 global_attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85 global_attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86 global_attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87 global_attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88 global_attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89 global_attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90 global_attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91 global_attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92 global_attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93 global_attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94 global_attribute16 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95 global_attribute17 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96 global_attribute18 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97 global_attribute19 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98 global_attribute20 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99 wh_update_date DATE:= FND_API.G_MISS_DATE
100 ); */
101
102 --p_location_rec hz_location_pub.location_rec_type;
103 procedure csp_create_location (
104 p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
106 p_commit IN VARCHAR2:= FND_API.G_FALSE,
107 x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
108 x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
109 x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
110 x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
111 x_CITY VARCHAR2:= FND_API.G_FALSE,
112 x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
113 x_STATE VARCHAR2:= FND_API.G_FALSE,
114 x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
115 x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
116 x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
117 x_COUNTY VARCHAR2:= FND_API.G_FALSE,
118 x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
119 x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2,
123 x_location_id OUT NOCOPY NUMBER,
124 p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL
125 );
126
127 procedure csp_update_location (
128 p_api_version IN NUMBER,
129 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
130 p_commit IN VARCHAR2:= FND_API.G_FALSE,
131 x_location_id NUMBER,
132 x_ADDRESS1 VARCHAR2:= FND_API.G_FALSE,
133 x_ADDRESS2 VARCHAR2:= FND_API.G_FALSE,
134 x_ADDRESS3 VARCHAR2:= FND_API.G_FALSE,
135 x_ADDRESS4 VARCHAR2:= FND_API.G_FALSE,
136 x_CITY VARCHAR2:= FND_API.G_FALSE,
137 x_POSTAL_CODE VARCHAR2:= FND_API.G_FALSE,
138 x_STATE VARCHAR2:= FND_API.G_FALSE,
139 x_PROVINCE VARCHAR2:= FND_API.G_FALSE,
140 x_ADDRESS_STYLE VARCHAR2:= FND_API.G_FALSE,
141 x_ADDRESS_LINES_PHONETIC VARCHAR2:= FND_API.G_FALSE,
142 x_COUNTY VARCHAR2:= FND_API.G_FALSE,
143 x_COUNTRY VARCHAR2:= FND_API.G_FALSE,
144 x_DESCRIPTION VARCHAR2:= FND_API.G_FALSE,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL
149 ) ;
150
151 END CSP_LOCATION_PKG;