[Home] [Help]
PACKAGE: APPS.AP_VENDOR_SITES_PKG
Source
1 PACKAGE AP_VENDOR_SITES_PKG AUTHID CURRENT_USER as
2 /* $Header: apvndsis.pls 120.8.12010000.3 2010/04/21 22:13:09 wjharris ship $ */
3 --
4 --
5 function format_address ( country_code varchar2,
6 seg1 varchar2,
7 seg2 varchar2,
8 seg3 varchar2,
9 seg4 varchar2,
10 seg5 varchar2,
11 seg6 varchar2,
12 seg7 varchar2,
13 seg8 varchar2,
14 seg9 varchar2,
15 seg10 varchar2 ) return varchar2;
16
17 PRAGMA RESTRICT_REFERENCES(format_address,WNDS,WNPS );
18
19
20 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
21 X_Vendor_Site_Id IN OUT NOCOPY NUMBER,
22 X_Last_Update_Date DATE,
23 X_Last_Updated_By NUMBER,
24 X_Vendor_Id NUMBER,
25 X_Vendor_Site_Code IN OUT NOCOPY VARCHAR2,
26 X_Last_Update_Login NUMBER,
27 X_Creation_Date DATE,
28 X_Created_By NUMBER,
29 X_Purchasing_Site_Flag VARCHAR2,
30 X_Rfq_Only_Site_Flag VARCHAR2,
31 X_Pay_Site_Flag VARCHAR2,
32 X_Attention_Ar_Flag VARCHAR2,
33 X_Address_Line1 VARCHAR2,
34 X_Address_Line2 VARCHAR2,
35 X_Address_Line3 VARCHAR2,
36 X_City VARCHAR2,
37 X_State VARCHAR2,
38 X_Zip VARCHAR2,
39 X_Province VARCHAR2,
40 X_Country VARCHAR2,
41 X_Area_Code VARCHAR2,
42 X_Phone VARCHAR2,
43 X_Customer_Num VARCHAR2,
44 X_Ship_To_Location_Id NUMBER,
45 X_Bill_To_Location_Id NUMBER,
46 X_Ship_Via_Lookup_Code VARCHAR2,
47 X_Freight_Terms_Lookup_Code VARCHAR2,
48 X_Fob_Lookup_Code VARCHAR2,
49 X_Inactive_Date DATE,
50 X_Fax VARCHAR2,
51 X_Fax_Area_Code VARCHAR2,
52 X_Telex VARCHAR2,
53 --4552701 X_Payment_Method_Lookup_Code VARCHAR2,
54 X_Bank_Account_Name VARCHAR2,
55 X_Bank_Account_Num VARCHAR2,
56 X_Bank_Num VARCHAR2,
57 X_Bank_Account_Type VARCHAR2,
58 X_Terms_Date_Basis VARCHAR2,
59 X_Current_Catalog_Num VARCHAR2,
60 -- eTax Uptake X_Vat_Code VARCHAR2,
61 X_Distribution_Set_Id NUMBER,
62 X_Accts_Pay_CCID NUMBER,
63 X_Future_Dated_Payment_CCID NUMBER,
64 X_Prepay_Code_Combination_Id NUMBER,
65 X_Pay_Group_Lookup_Code VARCHAR2,
66 X_Payment_Priority NUMBER,
67 X_Terms_Id NUMBER,
68 X_Invoice_Amount_Limit NUMBER,
69 X_Pay_Date_Basis_Lookup_Code VARCHAR2,
70 X_Always_Take_Disc_Flag VARCHAR2,
71 X_Invoice_Currency_Code VARCHAR2,
72 X_Payment_Currency_Code VARCHAR2,
73 X_Hold_All_Payments_Flag VARCHAR2,
74 X_Hold_Future_Payments_Flag VARCHAR2,
75 X_Hold_Reason VARCHAR2,
76 X_Hold_Unmatched_Invoices_Flag VARCHAR2,
77 X_Match_Option VARCHAR2,
78 X_Create_Debit_Memo_Flag VARCHAR2,
79 --4552701 X_Exclusive_Payment_Flag VARCHAR2,
80 X_Tax_Reporting_Site_Flag VARCHAR2,
81 X_Attribute_Category VARCHAR2,
82 X_Attribute1 VARCHAR2,
83 X_Attribute2 VARCHAR2,
84 X_Attribute3 VARCHAR2,
85 X_Attribute4 VARCHAR2,
86 X_Attribute5 VARCHAR2,
87 X_Attribute6 VARCHAR2,
88 X_Attribute7 VARCHAR2,
89 X_Attribute8 VARCHAR2,
90 X_Attribute9 VARCHAR2,
91 X_Attribute10 VARCHAR2,
92 X_Attribute11 VARCHAR2,
93 X_Attribute12 VARCHAR2,
94 X_Attribute13 VARCHAR2,
95 X_Attribute14 VARCHAR2,
96 X_Attribute15 VARCHAR2,
97 X_Validation_Number NUMBER,
98 X_Exclude_Freight_From_Disc VARCHAR2,
99 X_Vat_Registration_Num VARCHAR2,
100 -- eTax Uptake X_Offset_Tax_Flag VARCHAR2,
101 X_Check_Digits VARCHAR2,
102 X_Bank_Number VARCHAR2,
103 X_Address_Line4 VARCHAR2,
104 X_County VARCHAR2,
105 X_Address_Style VARCHAR2,
106 X_Language VARCHAR2,
107 X_Allow_Awt_Flag VARCHAR2,
108 X_Awt_Group_Id NUMBER,
109 X_Pay_Awt_Group_Id NUMBER,--bug6664407
110 X_pay_on_code VARCHAR2,
111 X_default_pay_site_id NUMBER,
112 X_pay_on_receipt_summary_code VARCHAR2,
113 X_Bank_Branch_Type VARCHAR2,
114 X_EDI_ID_Number VARCHAR2, --Bug 7437549
115 --4552701 X_EDI_ID_Number VARCHAR2,
116 --4552701 X_EDI_Payment_Method VARCHAR2,
117 --4552701 X_EDI_Payment_Format VARCHAR2,
118 --4552701 X_EDI_Remittance_Method VARCHAR2,
119 --4552701 X_EDI_Remittance_Instruction VARCHAR2,
120 --4552701 X_EDI_transaction_handling VARCHAR2,
121 /* eTax Uptake
122 X_Auto_Tax_Calc_Flag VARCHAR2,
123 X_Auto_Tax_Calc_Override VARCHAR2,
124 X_Amount_Includes_Tax_Flag VARCHAR2,
125 X_AP_Tax_Rounding_Rule VARCHAR2, */
126 X_Vendor_Site_Code_Alt VARCHAR2,
127 X_Address_Lines_Alt VARCHAR2,
128 X_global_attribute_category VARCHAR2 DEFAULT NULL,
129 X_global_attribute1 VARCHAR2 DEFAULT NULL,
130 X_global_attribute2 VARCHAR2 DEFAULT NULL,
131 X_global_attribute3 VARCHAR2 DEFAULT NULL,
132 X_global_attribute4 VARCHAR2 DEFAULT NULL,
133 X_global_attribute5 VARCHAR2 DEFAULT NULL,
134 X_global_attribute6 VARCHAR2 DEFAULT NULL,
135 X_global_attribute7 VARCHAR2 DEFAULT NULL,
136 X_global_attribute8 VARCHAR2 DEFAULT NULL,
137 X_global_attribute9 VARCHAR2 DEFAULT NULL,
138 X_global_attribute10 VARCHAR2 DEFAULT NULL,
139 X_global_attribute11 VARCHAR2 DEFAULT NULL,
140 X_global_attribute12 VARCHAR2 DEFAULT NULL,
141 X_global_attribute13 VARCHAR2 DEFAULT NULL,
142 X_global_attribute14 VARCHAR2 DEFAULT NULL,
143 X_global_attribute15 VARCHAR2 DEFAULT NULL,
144 X_global_attribute16 VARCHAR2 DEFAULT NULL,
145 X_global_attribute17 VARCHAR2 DEFAULT NULL,
146 X_global_attribute18 VARCHAR2 DEFAULT NULL,
147 X_global_attribute19 VARCHAR2 DEFAULT NULL,
148 X_global_attribute20 VARCHAR2 DEFAULT NULL,
149 X_Bank_Charge_Bearer VARCHAR2 DEFAULT NULL,
150 X_Ece_Tp_Location_Code VARCHAR2 DEFAULT NULL,
151 X_Pcard_Site_Flag VARCHAR2,
152 X_Country_of_Origin_Code VARCHAR2,
153 X_calling_sequence VARCHAR2,
154 X_Shipping_Location_id IN NUMBER,
155 X_Supplier_Notif_Method VARCHAR2, -- New Column
156 X_Email_Address VARCHAR2, -- New Column
157 --4552701 X_Remittance_email VARCHAR2 DEFAULT NULL,
158 X_Primary_pay_site_flag VARCHAR2 DEFAULT NULL,
159 X_Org_ID NUMBER
160 DEFAULT mo_global.get_current_org_id --MOAC
161 );
162
163 PROCEDURE Insert_Row(
164 p_vendor_site_rec IN AP_VENDOR_PUB_PKG.r_vendor_site_rec_type,
165 p_last_update_date IN DATE,
166 p_last_updated_by IN NUMBER,
167 p_last_update_login IN NUMBER,
168 p_creation_date IN DATE,
169 p_created_by IN NUMBER,
170 p_request_id IN NUMBER,
171 p_program_application_id IN NUMBER,
172 p_program_id IN NUMBER,
173 p_program_update_date IN DATE,
174 p_AP_Tax_Rounding_Rule IN VARCHAR2 DEFAULT NULL, /* 9530837 */
175 p_Amount_Includes_Tax_Flag IN VARCHAR2 DEFAULT NULL, /* 9530837 */
176 x_rowid OUT NOCOPY VARCHAR2,
177 x_vendor_site_id OUT NOCOPY NUMBER
178 );
179
180 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
181 X_Vendor_Site_Id NUMBER,
182 X_Vendor_Id NUMBER,
183 X_Vendor_Site_Code VARCHAR2,
184 X_Purchasing_Site_Flag VARCHAR2,
185 X_Rfq_Only_Site_Flag VARCHAR2,
186 X_Pay_Site_Flag VARCHAR2,
187 X_Attention_Ar_Flag VARCHAR2,
188 X_Address_Line1 VARCHAR2,
189 X_Address_Line2 VARCHAR2,
190 X_Address_Line3 VARCHAR2,
191 X_City VARCHAR2,
192 X_State VARCHAR2,
193 X_Zip VARCHAR2,
194 X_Province VARCHAR2,
195 X_Country VARCHAR2,
196 X_Area_Code VARCHAR2,
197 X_Phone VARCHAR2,
198 X_Customer_Num VARCHAR2,
199 X_Ship_To_Location_Id NUMBER,
200 X_Bill_To_Location_Id NUMBER,
201 X_Ship_Via_Lookup_Code VARCHAR2,
202 X_Freight_Terms_Lookup_Code VARCHAR2,
203 X_Fob_Lookup_Code VARCHAR2,
204 X_Inactive_Date DATE,
205 X_Fax VARCHAR2,
206 X_Fax_Area_Code VARCHAR2,
207 X_Telex VARCHAR2,
208 --4552701 X_Payment_Method_Lookup_Code VARCHAR2,
209 X_Bank_Account_Name VARCHAR2,
210 X_Bank_Account_Num VARCHAR2,
211 X_Bank_Num VARCHAR2,
212 X_Bank_Account_Type VARCHAR2,
213 X_Terms_Date_Basis VARCHAR2,
214 X_Current_Catalog_Num VARCHAR2,
215 -- eTax Uptake X_Vat_Code VARCHAR2,
216 X_Distribution_Set_Id NUMBER,
217 X_Accts_Pay_CCID NUMBER,
218 X_Future_Dated_Payment_CCID NUMBER,
219 X_Prepay_Code_Combination_Id NUMBER,
220 X_Pay_Group_Lookup_Code VARCHAR2,
221 X_Payment_Priority NUMBER,
222 X_Terms_Id NUMBER,
223 X_Invoice_Amount_Limit NUMBER,
224 X_Pay_Date_Basis_Lookup_Code VARCHAR2,
225 X_Always_Take_Disc_Flag VARCHAR2,
226 X_Invoice_Currency_Code VARCHAR2,
227 X_Payment_Currency_Code VARCHAR2,
228 X_Hold_All_Payments_Flag VARCHAR2,
229 X_Hold_Future_Payments_Flag VARCHAR2,
230 X_Hold_Reason VARCHAR2,
231 X_Hold_Unmatched_Invoices_Flag VARCHAR2,
232 X_Match_Option VARCHAR2,
233 X_Create_Debit_Memo_Flag VARCHAR2,
234 --4552701 X_Exclusive_Payment_Flag VARCHAR2,
235 X_Tax_Reporting_Site_Flag VARCHAR2,
236 X_Attribute_Category VARCHAR2,
237 X_Attribute1 VARCHAR2,
238 X_Attribute2 VARCHAR2,
239 X_Attribute3 VARCHAR2,
240 X_Attribute4 VARCHAR2,
241 X_Attribute5 VARCHAR2,
242 X_Attribute6 VARCHAR2,
243 X_Attribute7 VARCHAR2,
244 X_Attribute8 VARCHAR2,
245 X_Attribute9 VARCHAR2,
246 X_Attribute10 VARCHAR2,
247 X_Attribute11 VARCHAR2,
248 X_Attribute12 VARCHAR2,
249 X_Attribute13 VARCHAR2,
250 X_Attribute14 VARCHAR2,
251 X_Attribute15 VARCHAR2,
252 X_Validation_Number NUMBER,
253 X_Exclude_Freight_From_Disc VARCHAR2,
254 X_Vat_Registration_Num VARCHAR2,
255 -- eTax Uptake X_Offset_Tax_Flag VARCHAR2,
256 X_Check_Digits VARCHAR2,
257 X_Bank_Number VARCHAR2,
258 X_Address_Line4 VARCHAR2,
259 X_County VARCHAR2,
260 X_Address_Style VARCHAR2,
261 X_Language VARCHAR2,
262 X_Allow_Awt_Flag VARCHAR2,
263 X_Awt_Group_Id NUMBER,
264 X_Pay_Awt_Group_Id NUMBER,--bug6664407
265 X_pay_on_code VARCHAR2,
266 X_default_pay_site_id NUMBER,
267 X_pay_on_receipt_summary_code VARCHAR2,
268 X_Bank_Branch_Type VARCHAR2,
269 X_EDI_ID_Number VARCHAR2, --Bug 7437549
270 --4552701 X_EDI_ID_Number VARCHAR2,
271 --4552701 X_EDI_Payment_Method VARCHAR2,
272 --4552701 X_EDI_Payment_Format VARCHAR2,
273 --4552701 X_EDI_Remittance_Method VARCHAR2,
274 --4552701 X_EDI_Remittance_Instruction VARCHAR2,
275 --4552701 X_EDI_transaction_handling VARCHAR2,
276 /* eTax Uptake
277 X_Auto_Tax_Calc_Flag VARCHAR2,
278 X_Auto_Tax_Calc_Override VARCHAR2,
279 X_Amount_Includes_Tax_Flag VARCHAR2,
280 X_AP_Tax_Rounding_Rule VARCHAR2, */
281 X_Vendor_Site_Code_Alt VARCHAR2,
282 X_Address_Lines_Alt VARCHAR2,
283 X_global_attribute_category VARCHAR2 DEFAULT NULL,
284 X_global_attribute1 VARCHAR2 DEFAULT NULL,
285 X_global_attribute2 VARCHAR2 DEFAULT NULL,
286 X_global_attribute3 VARCHAR2 DEFAULT NULL,
287 X_global_attribute4 VARCHAR2 DEFAULT NULL,
288 X_global_attribute5 VARCHAR2 DEFAULT NULL,
289 X_global_attribute6 VARCHAR2 DEFAULT NULL,
290 X_global_attribute7 VARCHAR2 DEFAULT NULL,
291 X_global_attribute8 VARCHAR2 DEFAULT NULL,
292 X_global_attribute9 VARCHAR2 DEFAULT NULL,
293 X_global_attribute10 VARCHAR2 DEFAULT NULL,
294 X_global_attribute11 VARCHAR2 DEFAULT NULL,
295 X_global_attribute12 VARCHAR2 DEFAULT NULL,
296 X_global_attribute13 VARCHAR2 DEFAULT NULL,
297 X_global_attribute14 VARCHAR2 DEFAULT NULL,
298 X_global_attribute15 VARCHAR2 DEFAULT NULL,
299 X_global_attribute16 VARCHAR2 DEFAULT NULL,
300 X_global_attribute17 VARCHAR2 DEFAULT NULL,
301 X_global_attribute18 VARCHAR2 DEFAULT NULL,
302 X_global_attribute19 VARCHAR2 DEFAULT NULL,
303 X_global_attribute20 VARCHAR2 DEFAULT NULL,
304 X_Bank_Charge_Bearer VARCHAR2 DEFAULT NULL,
305 X_Ece_Tp_Location_Code VARCHAR2 DEFAULT NULL,
306 X_Pcard_Site_Flag VARCHAR2,
307 X_Country_of_Origin_Code VARCHAR2,
308 X_calling_sequence VARCHAR2,
309 X_Shipping_Location_id IN NUMBER,
310 X_Supplier_Notif_Method VARCHAR2, -- New Column
311 X_Email_Address VARCHAR2, -- New Column
312 --4552701 X_Remittance_email VARCHAR2 DEFAULT NULL,
313 X_Primary_pay_site_flag VARCHAR2 DEFAULT NULL,
314 X_org_id NUMBER
315 DEFAULT mo_global.get_current_org_id); --MOAC
316
317
318
319 PROCEDURE Update_Row(X_Rowid VARCHAR2,
320 X_Vendor_Site_Id NUMBER,
321 X_Last_Update_Date DATE,
322 X_Last_Updated_By NUMBER,
323 X_Vendor_Id NUMBER,
324 X_Vendor_Site_Code VARCHAR2,
325 X_Last_Update_Login NUMBER,
326 X_Creation_Date DATE,
327 X_Created_By NUMBER,
328 X_Purchasing_Site_Flag VARCHAR2,
329 X_Rfq_Only_Site_Flag VARCHAR2,
330 X_Pay_Site_Flag VARCHAR2,
331 X_Attention_Ar_Flag VARCHAR2,
332 X_Address_Line1 VARCHAR2,
333 X_Address_Line2 VARCHAR2,
334 X_Address_Line3 VARCHAR2,
335 X_City VARCHAR2,
336 X_State VARCHAR2,
337 X_Zip VARCHAR2,
338 X_Province VARCHAR2,
339 X_Country VARCHAR2,
340 X_Area_Code VARCHAR2,
341 X_Phone VARCHAR2,
342 X_Customer_Num VARCHAR2,
343 X_Ship_To_Location_Id NUMBER,
344 X_Bill_To_Location_Id NUMBER,
345 X_Ship_Via_Lookup_Code VARCHAR2,
346 X_Freight_Terms_Lookup_Code VARCHAR2,
347 X_Fob_Lookup_Code VARCHAR2,
348 X_Inactive_Date DATE,
349 X_Fax VARCHAR2,
350 X_Fax_Area_Code VARCHAR2,
351 X_Telex VARCHAR2,
352 --4552701 X_Payment_Method_Lookup_Code VARCHAR2,
353 X_Bank_Account_Name VARCHAR2,
354 X_Bank_Account_Num VARCHAR2,
355 X_Bank_Num VARCHAR2,
356 X_Bank_Account_Type VARCHAR2,
357 X_Terms_Date_Basis VARCHAR2,
358 X_Current_Catalog_Num VARCHAR2,
359 -- eTax Uptake X_Vat_Code VARCHAR2,
360 X_Distribution_Set_Id NUMBER,
361 X_Accts_Pay_CCID NUMBER,
362 X_Future_Dated_Payment_CCID NUMBER,
363 X_Prepay_Code_Combination_Id NUMBER,
364 X_Pay_Group_Lookup_Code VARCHAR2,
365 X_Payment_Priority NUMBER,
366 X_Terms_Id NUMBER,
367 X_Invoice_Amount_Limit NUMBER,
368 X_Pay_Date_Basis_Lookup_Code VARCHAR2,
369 X_Always_Take_Disc_Flag VARCHAR2,
370 X_Invoice_Currency_Code VARCHAR2,
371 X_Payment_Currency_Code VARCHAR2,
372 X_Hold_All_Payments_Flag VARCHAR2,
373 X_Hold_Future_Payments_Flag VARCHAR2,
374 X_Hold_Reason VARCHAR2,
375 X_Hold_Unmatched_Invoices_Flag VARCHAR2,
376 X_Match_Option VARCHAR2,
377 X_Create_Debit_Memo_Flag VARCHAR2,
378 --4552701 X_Exclusive_Payment_Flag VARCHAR2,
379 X_Tax_Reporting_Site_Flag VARCHAR2,
380 X_Attribute_Category VARCHAR2,
381 X_Attribute1 VARCHAR2,
382 X_Attribute2 VARCHAR2,
383 X_Attribute3 VARCHAR2,
384 X_Attribute4 VARCHAR2,
385 X_Attribute5 VARCHAR2,
386 X_Attribute6 VARCHAR2,
387 X_Attribute7 VARCHAR2,
388 X_Attribute8 VARCHAR2,
389 X_Attribute9 VARCHAR2,
390 X_Attribute10 VARCHAR2,
391 X_Attribute11 VARCHAR2,
392 X_Attribute12 VARCHAR2,
393 X_Attribute13 VARCHAR2,
394 X_Attribute14 VARCHAR2,
395 X_Attribute15 VARCHAR2,
396 X_Validation_Number NUMBER,
397 X_Exclude_Freight_From_Disc VARCHAR2,
398 X_Vat_Registration_Num VARCHAR2,
399 -- eTax Uptake X_Offset_Tax_Flag VARCHAR2,
400 X_Check_Digits VARCHAR2,
401 X_Bank_Number VARCHAR2,
402 X_Address_Line4 VARCHAR2,
403 X_County VARCHAR2,
404 X_Address_Style VARCHAR2,
405 X_Language VARCHAR2,
406 X_Allow_Awt_Flag VARCHAR2,
407 X_Awt_Group_Id NUMBER,
408 X_Pay_Awt_Group_Id NUMBER,--bug6664407
409 X_pay_on_code VARCHAR2,
410 X_default_pay_site_id NUMBER,
411 X_pay_on_receipt_summary_code VARCHAR2,
412 X_Bank_Branch_Type VARCHAR2,
413 X_EDI_ID_Number VARCHAR2, --Bug 7437549
414 /* 4552701
415 X_EDI_Payment_Method VARCHAR2,
416 X_EDI_Payment_Format VARCHAR2,
417 X_EDI_Remittance_Method VARCHAR2,
418 X_EDI_Remittance_Instruction VARCHAR2,
419 X_EDI_transaction_handling VARCHAR2,
420 eTax Uptake
421 X_Auto_Tax_Calc_Flag VARCHAR2,
422 X_Auto_Tax_Calc_Override VARCHAR2,
423 X_Amount_Includes_Tax_Flag VARCHAR2,
424 X_AP_Tax_Rounding_Rule VARCHAR2, */
425 X_Vendor_Site_Code_Alt VARCHAR2,
426 X_Address_Lines_Alt VARCHAR2,
427 X_global_attribute_category VARCHAR2 DEFAULT NULL,
428 X_global_attribute1 VARCHAR2 DEFAULT NULL,
429 X_global_attribute2 VARCHAR2 DEFAULT NULL,
430 X_global_attribute3 VARCHAR2 DEFAULT NULL,
431 X_global_attribute4 VARCHAR2 DEFAULT NULL,
432 X_global_attribute5 VARCHAR2 DEFAULT NULL,
433 X_global_attribute6 VARCHAR2 DEFAULT NULL,
434 X_global_attribute7 VARCHAR2 DEFAULT NULL,
435 X_global_attribute8 VARCHAR2 DEFAULT NULL,
436 X_global_attribute9 VARCHAR2 DEFAULT NULL,
437 X_global_attribute10 VARCHAR2 DEFAULT NULL,
438 X_global_attribute11 VARCHAR2 DEFAULT NULL,
439 X_global_attribute12 VARCHAR2 DEFAULT NULL,
440 X_global_attribute13 VARCHAR2 DEFAULT NULL,
441 X_global_attribute14 VARCHAR2 DEFAULT NULL,
442 X_global_attribute15 VARCHAR2 DEFAULT NULL,
443 X_global_attribute16 VARCHAR2 DEFAULT NULL,
444 X_global_attribute17 VARCHAR2 DEFAULT NULL,
445 X_global_attribute18 VARCHAR2 DEFAULT NULL,
446 X_global_attribute19 VARCHAR2 DEFAULT NULL,
447 X_global_attribute20 VARCHAR2 DEFAULT NULL,
448 X_Bank_Charge_Bearer VARCHAR2 DEFAULT NULL,
449 X_Ece_Tp_Location_Code VARCHAR2 DEFAULT NULL,
450 X_Pcard_Site_Flag VARCHAR2,
451 X_Country_of_Origin_Code VARCHAR2,
452 X_calling_sequence VARCHAR2,
453 X_Shipping_Location_id IN NUMBER,
454 X_Supplier_Notif_Method VARCHAR2, -- New Column
455 X_Email_Address VARCHAR2, -- New Column
456 --4552701 X_Remittance_email VARCHAR2 DEFAULT NULL,
457 X_Primary_pay_site_flag VARCHAR2 DEFAULT NULL,
458 X_Org_ID NUMBER
459 DEFAULT mo_global.get_current_org_id --MOAC
460 );
461
462 PROCEDURE update_row(
463 p_vendor_site_rec IN AP_VENDOR_PUB_PKG.r_vendor_site_rec_type,
464 p_last_update_date IN DATE,
465 p_last_updated_by IN NUMBER,
466 p_last_update_login IN NUMBER,
467 p_request_id IN NUMBER,
468 p_program_application_id IN NUMBER,
469 p_program_id IN NUMBER,
470 p_program_update_date IN DATE,
471 p_vendor_site_id IN NUMBER
472 );
473 --
474 --
475 procedure check_vendor_offsets (x_vendor_id in number,
476 x_calling_sequence in varchar2);
477 --
478 --
479 procedure check_duplicate_vendor_site ( x_vendor_id in number,
480 x_vendor_site_code in varchar2,
481 x_org_id in number
482 default mo_global.get_current_org_id, /*MOAC*/
483 x_rowid in varchar2,
484 x_calling_sequence in varchar2 );
485 --
486 --
487 procedure Check_Multiple_Tax_Sites( x_vendor_id in number,
488 x_vendor_site_id in number,
489 x_org_id in number
490 default mo_global.get_current_org_id, /*MOAC*/
491 X_calling_sequence in varchar2 );
492 --
493 --
494 procedure Check_Site_Currencies( x_vendor_id in number,
495 x_base_currency_code in varchar2,
496 x_calling_sequence in varchar2 );
497 --
498 --
499 procedure Get_Tax_Site( x_vendor_id in number,
500 x_vendor_site_code in out NOCOPY varchar2,
501 --MO Access Control
502 x_org_id in number
503 default mo_global.get_current_org_id,
504 x_calling_sequence in varchar2 );
505 --
506 --
507 procedure Check_State_Codes( x_vendor_id in number,
508 x_calling_sequence in varchar2 );
509 --
510 --
511 procedure Check_duplicate_ece_code ( x_vendor_id in number,
512 x_ece_tp_location_code in varchar2,
513 x_rowid in varchar2,
514 --MO Access Control
515 x_org_id in varchar2
516 default mo_global.get_current_org_id,
517 x_calling_sequence in varchar2 );
518 END AP_VENDOR_SITES_PKG;