[Home] [Help]
PACKAGE: APPS.ARP_ADDR_PKG
Source
1 PACKAGE arp_addr_pkg AUTHID CURRENT_USER as
2 /* $Header: AROADDRS.pls 115.4 99/10/11 16:15:21 porting sh $ */
3 --
4 --
5 FUNCTION format_address( address_style IN VARCHAR2,
6 address1 IN VARCHAR2,
7 address2 IN VARCHAR2,
8 address3 IN VARCHAR2,
9 address4 IN VARCHAR2,
10 city IN VARCHAR2,
11 county IN VARCHAR2,
12 state IN VARCHAR2,
13 province IN VARCHAR2,
14 postal_code IN VARCHAR2,
15 territory_short_name IN VARCHAR2,
16 country_code IN VARCHAR2 default NULL,
17 customer_name IN VARCHAR2 default NULL,
18 first_name IN VARCHAR2 default NULL,
19 last_name IN VARCHAR2 default NULL,
20 mail_stop IN VARCHAR2 default NULL,
21 default_country_code IN VARCHAR2 default NULL,
22 default_country_desc IN VARCHAR2 default NULL,
23 print_home_country_flag IN VARCHAR2 default 'Y',
24 print_default_attn_flag IN VARCHAR2 default 'N',
25 width IN NUMBER default 1000,
26 height_min IN NUMBER default 1,
27 height_max IN NUMBER default 1
28
29 )return VARCHAR2;
30
31
32 FUNCTION arxtw_format_address( address_style IN VARCHAR2,
33 address1 IN VARCHAR2,
34 address2 IN VARCHAR2,
35 address3 IN VARCHAR2,
36 address4 IN VARCHAR2,
37 city IN VARCHAR2,
38 county IN VARCHAR2,
39 state IN VARCHAR2,
40 province IN VARCHAR2,
41 postal_code IN VARCHAR2,
42 territory_short_name IN VARCHAR2
43 )return VARCHAR2;
44
45
46 FUNCTION format_last_address_line(p_address_style varchar2,
47 p_address3 varchar2,
48 p_address4 varchar2,
49 p_city varchar2,
50 p_county varchar2,
51 p_state varchar2,
52 p_province varchar2,
53 p_country varchar2,
54 p_postal_code varchar2 )
55 RETURN varchar2;
56
57
58
59 procedure check_unique_orig_system_ref(p_orig_system_reference in varchar2 );
60 --
61 --
62 procedure update_site_use_flag ( p_address_id in number,
63 p_site_use_code in varchar2,
64 p_site_use_flag in varchar2 );
65 --
66 --
67 PROCEDURE Insert_Row(X_Rowid IN OUT VARCHAR2,
68 X_Address_Id IN OUT NUMBER,
69 X_Last_Update_Date DATE,
70 X_Last_Updated_By NUMBER,
71 X_Creation_Date DATE,
72 X_Created_By NUMBER,
73 X_Customer_Id NUMBER,
74 X_Status VARCHAR2,
75 X_Orig_System_Reference IN OUT VARCHAR2,
76 X_Country VARCHAR2,
77 X_Address1 VARCHAR2,
78 X_Address2 VARCHAR2,
79 X_Address3 VARCHAR2,
80 X_Address4 VARCHAR2,
81 X_City VARCHAR2,
82 X_Postal_Code VARCHAR2,
83 X_State VARCHAR2,
84 X_Province VARCHAR2,
85 X_County VARCHAR2,
86 X_Last_Update_Login NUMBER,
87 X_Territory_Id NUMBER,
88 X_Address_Key VARCHAR2,
89 X_Attribute_Category VARCHAR2,
90 X_Attribute1 VARCHAR2,
91 X_Attribute2 VARCHAR2,
92 X_Attribute3 VARCHAR2,
93 X_Attribute4 VARCHAR2,
94 X_Attribute5 VARCHAR2,
95 X_Attribute6 VARCHAR2,
96 X_Attribute7 VARCHAR2,
97 X_Attribute8 VARCHAR2,
98 X_Attribute9 VARCHAR2,
99 X_Attribute10 VARCHAR2,
100 X_Attribute11 VARCHAR2,
101 X_Attribute12 VARCHAR2,
102 X_Attribute13 VARCHAR2,
103 X_Attribute14 VARCHAR2,
104 X_Attribute15 VARCHAR2,
105 X_Key_Account_Flag VARCHAR2,
106 X_Language VARCHAR2,
107 X_address_mode VARCHAR2,
108 X_su_Bill_To_Flag VARCHAR2,
109 X_su_Ship_To_Flag VARCHAR2,
110 X_su_Market_Flag VARCHAR2,
111 X_su_stmt_flag VARCHAR2,
112 X_su_dun_flag VARCHAR2,
113 X_su_legal_flag VARCHAR2,
114 X_Address_warning out boolean,
115 X_Address_Lines_Phonetic VARCHAR2,
116 X_Customer_Category VARCHAR2,
117 X_Global_Attribute_Category VARCHAR2,
118 X_Global_Attribute1 VARCHAR2,
119 X_Global_Attribute2 VARCHAR2,
120 X_Global_Attribute3 VARCHAR2,
121 X_Global_Attribute4 VARCHAR2,
122 X_Global_Attribute5 VARCHAR2,
123 X_Global_Attribute6 VARCHAR2,
124 X_Global_Attribute7 VARCHAR2,
125 X_Global_Attribute8 VARCHAR2,
126 X_Global_Attribute9 VARCHAR2,
127 X_Global_Attribute10 VARCHAR2,
128 X_Global_Attribute11 VARCHAR2,
129 X_Global_Attribute12 VARCHAR2,
130 X_Global_Attribute13 VARCHAR2,
131 X_Global_Attribute14 VARCHAR2,
132 X_Global_Attribute15 VARCHAR2,
133 X_Global_Attribute16 VARCHAR2,
134 X_Global_Attribute17 VARCHAR2,
135 X_Global_Attribute18 VARCHAR2,
136 X_Global_Attribute19 VARCHAR2,
137 X_Global_Attribute20 VARCHAR2,
138 X_EDI_Location VARCHAR2,
139 X_Territory VARCHAR2,
140 X_Translated_Customer_Name VARCHAR2,
141 X_Sales_Tax_Geocode VARCHAR2,
142 X_Sales_Tax_Inside_City_Limits VARCHAR2
143 );
144
145 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
146 X_Address_Id NUMBER,
147 X_Customer_Id NUMBER,
148 X_Status VARCHAR2,
149 X_Orig_System_Reference VARCHAR2,
150 X_Country VARCHAR2,
151 X_Address1 VARCHAR2,
152 X_Address2 VARCHAR2,
153 X_Address3 VARCHAR2,
154 X_Address4 VARCHAR2,
155 X_City VARCHAR2,
156 X_Postal_Code VARCHAR2,
157 X_State VARCHAR2,
158 X_Province VARCHAR2,
159 X_County VARCHAR2,
160 X_Territory_Id NUMBER,
161 X_Address_Key VARCHAR2,
162 X_Attribute_Category VARCHAR2,
163 X_Attribute1 VARCHAR2,
164 X_Attribute2 VARCHAR2,
165 X_Attribute3 VARCHAR2,
166 X_Attribute4 VARCHAR2,
167 X_Attribute5 VARCHAR2,
168 X_Attribute6 VARCHAR2,
169 X_Attribute7 VARCHAR2,
170 X_Attribute8 VARCHAR2,
171 X_Attribute9 VARCHAR2,
172 X_Attribute10 VARCHAR2,
173 X_Attribute11 VARCHAR2,
174 X_Attribute12 VARCHAR2,
175 X_Attribute13 VARCHAR2,
176 X_Attribute14 VARCHAR2,
177 X_Attribute15 VARCHAR2,
178 X_Key_Account_Flag VARCHAR2,
179 X_Language VARCHAR2,
180 X_su_Bill_To_Flag VARCHAR2,
181 X_su_Ship_To_Flag VARCHAR2,
182 X_su_Market_Flag VARCHAR2,
183 X_su_stmt_flag VARCHAR2,
184 X_su_dun_flag VARCHAR2,
185 X_su_legal_flag VARCHAR2,
186 X_Address_Lines_Phonetic VARCHAR2,
187 X_Customer_Category VARCHAR2,
188 X_Global_Attribute_Category VARCHAR2,
189 X_Global_Attribute1 VARCHAR2,
190 X_Global_Attribute2 VARCHAR2,
191 X_Global_Attribute3 VARCHAR2,
192 X_Global_Attribute4 VARCHAR2,
193 X_Global_Attribute5 VARCHAR2,
194 X_Global_Attribute6 VARCHAR2,
195 X_Global_Attribute7 VARCHAR2,
196 X_Global_Attribute8 VARCHAR2,
197 X_Global_Attribute9 VARCHAR2,
198 X_Global_Attribute10 VARCHAR2,
199 X_Global_Attribute11 VARCHAR2,
200 X_Global_Attribute12 VARCHAR2,
201 X_Global_Attribute13 VARCHAR2,
202 X_Global_Attribute14 VARCHAR2,
203 X_Global_Attribute15 VARCHAR2,
204 X_Global_Attribute16 VARCHAR2,
205 X_Global_Attribute17 VARCHAR2,
206 X_Global_Attribute18 VARCHAR2,
207 X_Global_Attribute19 VARCHAR2,
208 X_Global_Attribute20 VARCHAR2,
209 X_EDI_Location VARCHAR2,
210 X_Territory VARCHAR2,
211 X_Translated_Customer_Name VARCHAR2,
212 X_Sales_Tax_Geocode VARCHAR2,
213 X_Sales_Tax_Inside_City_Limits VARCHAR2
214 );
215
216
217
218 PROCEDURE Update_Row(X_Rowid VARCHAR2,
219 X_Address_Id NUMBER,
220 X_Last_Update_Date DATE,
221 X_Last_Updated_By NUMBER,
222 X_Customer_Id NUMBER,
223 X_Status VARCHAR2,
224 X_Orig_System_Reference VARCHAR2,
225 X_Country VARCHAR2,
226 X_Address1 VARCHAR2,
227 X_Address2 VARCHAR2,
228 X_Address3 VARCHAR2,
229 X_Address4 VARCHAR2,
230 X_City VARCHAR2,
231 X_Postal_Code VARCHAR2,
232 X_State VARCHAR2,
233 X_Province VARCHAR2,
234 X_County VARCHAR2,
235 X_Last_Update_Login NUMBER,
236 X_Territory_Id NUMBER,
237 X_Address_Key VARCHAR2,
238 X_Attribute_Category VARCHAR2,
239 X_Attribute1 VARCHAR2,
240 X_Attribute2 VARCHAR2,
241 X_Attribute3 VARCHAR2,
242 X_Attribute4 VARCHAR2,
243 X_Attribute5 VARCHAR2,
244 X_Attribute6 VARCHAR2,
245 X_Attribute7 VARCHAR2,
246 X_Attribute8 VARCHAR2,
247 X_Attribute9 VARCHAR2,
248 X_Attribute10 VARCHAR2,
249 X_Attribute11 VARCHAR2,
250 X_Attribute12 VARCHAR2,
251 X_Attribute13 VARCHAR2,
252 X_Attribute14 VARCHAR2,
253 X_Attribute15 VARCHAR2,
254 X_Key_Account_Flag VARCHAR2,
255 X_Language VARCHAR2,
256 x_address_mode VARCHAR2,
257 X_su_Bill_To_Flag VARCHAR2,
258 X_su_Ship_To_Flag VARCHAR2,
259 X_su_Market_Flag VARCHAR2,
260 X_su_stmt_flag VARCHAR2,
261 X_su_dun_flag VARCHAR2,
262 X_su_legal_flag VARCHAR2,
263 X_address_warning out boolean,
264 X_Address_Lines_Phonetic VARCHAR2,
265 X_Customer_Category VARCHAR2,
266 X_Global_Attribute_Category VARCHAR2,
267 X_Global_Attribute1 VARCHAR2,
268 X_Global_Attribute2 VARCHAR2,
269 X_Global_Attribute3 VARCHAR2,
270 X_Global_Attribute4 VARCHAR2,
271 X_Global_Attribute5 VARCHAR2,
272 X_Global_Attribute6 VARCHAR2,
273 X_Global_Attribute7 VARCHAR2,
274 X_Global_Attribute8 VARCHAR2,
275 X_Global_Attribute9 VARCHAR2,
276 X_Global_Attribute10 VARCHAR2,
277 X_Global_Attribute11 VARCHAR2,
278 X_Global_Attribute12 VARCHAR2,
279 X_Global_Attribute13 VARCHAR2,
280 X_Global_Attribute14 VARCHAR2,
281 X_Global_Attribute15 VARCHAR2,
282 X_Global_Attribute16 VARCHAR2,
283 X_Global_Attribute17 VARCHAR2,
287 X_EDI_Location VARCHAR2,
284 X_Global_Attribute18 VARCHAR2,
285 X_Global_Attribute19 VARCHAR2,
286 X_Global_Attribute20 VARCHAR2,
288 X_Territory VARCHAR2,
289 X_Translated_Customer_Name VARCHAR2,
290 X_Sales_Tax_Geocode VARCHAR2,
291 X_Sales_Tax_Inside_City_Limits VARCHAR2
292 );
293 --
294 FUNCTION location_exists (p_address_id IN Number
295 ) return BOOLEAN;
296 --
297 --
298 FUNCTION transaction_exists (p_address_id IN Number,
299 p_customer_id IN Number
300 ) return BOOLEAN;
301 --
302 --
303 procedure check_unique_edi_location(p_edi_location in varchar2,
304 p_customer_id in number,
305 p_orig_system_reference in varchar2);
306 --
307 END arp_addr_pkg;