eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.AP_VENDORS_PKG

Source


1 PACKAGE AP_VENDORS_PKG as
2 /* $Header: apvndhrs.pls 120.8 2007/12/24 10:03:29 schamaku ship $ */
3 --
4 PROCEDURE Insert_Row(
5 		x_Rowid		IN OUT NOCOPY	VARCHAR2,
6 		x_Vendor_Id	IN OUT NOCOPY	NUMBER,
7 		x_Last_Update_Date		DATE,
8 		x_Last_Updated_By		NUMBER,
9 		x_Vendor_Name			VARCHAR2,
10 		x_Segment1	IN OUT NOCOPY	VARCHAR2,
11 		x_Summary_Flag			VARCHAR2,
12 		x_Enabled_Flag			VARCHAR2,
13 		x_Last_Update_Login		NUMBER,
14 		x_Creation_Date			DATE,
15 		x_Created_By			NUMBER,
16 		x_Employee_Id			NUMBER,
17 		x_Validation_Number		NUMBER,
18 		x_Vendor_Type_Lookup_Code	VARCHAR2,
19 		x_Customer_Num			VARCHAR2,
20 		x_One_Time_Flag			VARCHAR2,
21 		x_Parent_Vendor_Id		NUMBER,
22 		x_Min_Order_Amount		NUMBER,
23 		--Bug :2809214 MOAC - Supplier Attribute Change Project
24 		/* x_Ship_To_Location_Id	NUMBER,
25 		x_Bill_To_Location_Id		NUMBER,
26 		x_Ship_Via_Lookup_Code		VARCHAR2,
27 		x_Freight_Terms_Lookup_Code	VARCHAR2,
28 		x_Fob_Lookup_Code		VARCHAR2, */
29 		x_Terms_Id			NUMBER,
30 		x_Set_Of_Books_Id		NUMBER,
31 		x_Always_Take_Disc_Flag		VARCHAR2,
32 		x_Pay_Date_Basis_Lookup_Code	VARCHAR2,
33 		x_Pay_Group_Lookup_Code		VARCHAR2,
34 		x_Payment_Priority		NUMBER,
35 		x_Invoice_Currency_Code		VARCHAR2,
36 		x_Payment_Currency_Code		VARCHAR2,
37 		x_Invoice_Amount_Limit		NUMBER,
38 		x_Hold_All_Payments_Flag	VARCHAR2,
39 		x_Hold_Future_Payments_Flag	VARCHAR2,
40 		x_Hold_Reason			VARCHAR2,
41 		--Bug :2809214 MOAC - Supplier Attribute Change Project
42 		/* x_Distribution_Set_Id	NUMBER,
43 		x_Accts_Pay_CCID		NUMBER,
44 		x_Future_Dated_Payment_CCID	NUMBER,
45 		x_Prepay_CCID			NUMBER, */
46 		x_Num_1099			VARCHAR2,
47 		x_Type_1099			VARCHAR2,
48 		x_Withholding_Stat_Lookup_Code	VARCHAR2,
49 		x_Withholding_Start_Date	DATE,
50 		x_Org_Type_Lookup_Code		VARCHAR2,
51 		-- eTax Uptake x_Vat_Code	VARCHAR2,
52 		x_Start_Date_Active		DATE,
53 		x_End_Date_Active		DATE,
54 		x_Qty_Rcv_Tolerance		NUMBER,
55 		x_Minority_Group_Lookup_Code	VARCHAR2,
56 		--4552701 x_Payment_Method_Lookup_Code	VARCHAR2,
57 		x_Bank_Account_Name		VARCHAR2,
58 		x_Bank_Account_Num		VARCHAR2,
59 		x_Bank_Num			VARCHAR2,
60 		x_Bank_Account_Type		VARCHAR2,
61 		x_Women_Owned_Flag		VARCHAR2,
62 		x_Small_Business_Flag		VARCHAR2,
63 		x_Standard_Industry_Class	VARCHAR2,
64 		x_Attribute_Category		VARCHAR2,
65 		x_Attribute1			VARCHAR2,
66 		x_Attribute2			VARCHAR2,
67 		x_Attribute3			VARCHAR2,
68 		x_Attribute4			VARCHAR2,
69 		x_Attribute5			VARCHAR2,
70 		x_Hold_Flag			VARCHAR2,
71 		x_Purchasing_Hold_Reason	VARCHAR2,
72 		x_Hold_By			NUMBER,
73 		x_Hold_Date			DATE,
74 		x_Terms_Date_Basis		VARCHAR2,
75 		x_Price_Tolerance		NUMBER,
76 		x_Attribute10			VARCHAR2,
77 		x_Attribute11			VARCHAR2,
78 		x_Attribute12			VARCHAR2,
79 		x_Attribute13			VARCHAR2,
80 		x_Attribute14			VARCHAR2,
81 		x_Attribute15			VARCHAR2,
82 		x_Attribute6			VARCHAR2,
83 		x_Attribute7			VARCHAR2,
84 		x_Attribute8			VARCHAR2,
85 		x_Attribute9			VARCHAR2,
86 		x_Days_Early_Receipt_Allowed	NUMBER,
87 		x_Days_Late_Receipt_Allowed	NUMBER,
88 		x_Enforce_Ship_To_Loc_Code	VARCHAR2,
89 		--4552701 x_Exclusive_Payment_Flag	VARCHAR2,
90 		x_Federal_Reportable_Flag	VARCHAR2,
91 		x_Hold_Unmatched_Invoices_Flag	VARCHAR2,
92 		x_match_option			VARCHAR2,
93 		x_create_debit_memo_flag	VARCHAR2,
94 		x_Inspection_Required_Flag	VARCHAR2,
95 		x_Receipt_Required_Flag		VARCHAR2,
96 		x_Receiving_Routing_Id		NUMBER,
97 		x_State_Reportable_Flag		VARCHAR2,
98 		x_Tax_Verification_Date		DATE,
99 		x_Auto_Calculate_Interest_Flag	VARCHAR2,
100 		x_Name_Control			VARCHAR2,
101 		x_Allow_Subst_Receipts_Flag	VARCHAR2,
102 		x_Allow_Unord_Receipts_Flag	VARCHAR2,
103 		x_Receipt_Days_Exception_Code	VARCHAR2,
104 		x_Qty_Rcv_Exception_Code	VARCHAR2,
105 		-- eTax Uptake x_Offset_Tax_Flag               VARCHAR2,
106 		x_Exclude_Freight_From_Disc	VARCHAR2,
107 		x_Vat_Registration_Num		VARCHAR2,
108 		x_Tax_Reporting_Name		VARCHAR2,
109 		x_Awt_Group_Id			NUMBER,
110                 x_Pay_Awt_Group_Id              NUMBER,--bug6664407
111 		x_Check_Digits			VARCHAR2,
112 		x_Bank_Number			VARCHAR2,
113 		x_Allow_Awt_Flag		VARCHAR2,
114 		x_Bank_Branch_Type		VARCHAR2,
115 		/*4552701
116                 x_EDI_Payment_Method		VARCHAR2,
117 		x_EDI_Payment_Format		VARCHAR2,
118 		x_EDI_Remittance_Method		VARCHAR2,
119 		x_EDI_Remittance_Instruction	VARCHAR2,
120 		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_Name_Alt	 	VARCHAR2,
127                 X_global_attribute_category     VARCHAR2 DEFAULT NULL,
128                 X_global_attribute1             VARCHAR2 DEFAULT NULL,
129                 X_global_attribute2             VARCHAR2 DEFAULT NULL,
130                 X_global_attribute3             VARCHAR2 DEFAULT NULL,
131                 X_global_attribute4             VARCHAR2 DEFAULT NULL,
132                 X_global_attribute5             VARCHAR2 DEFAULT NULL,
133                 X_global_attribute6             VARCHAR2 DEFAULT NULL,
134                 X_global_attribute7             VARCHAR2 DEFAULT NULL,
135                 X_global_attribute8             VARCHAR2 DEFAULT NULL,
136                 X_global_attribute9             VARCHAR2 DEFAULT NULL,
137                 X_global_attribute10            VARCHAR2 DEFAULT NULL,
138                 X_global_attribute11            VARCHAR2 DEFAULT NULL,
139                 X_global_attribute12            VARCHAR2 DEFAULT NULL,
140                 X_global_attribute13            VARCHAR2 DEFAULT NULL,
141                 X_global_attribute14            VARCHAR2 DEFAULT NULL,
142                 X_global_attribute15            VARCHAR2 DEFAULT NULL,
143                 X_global_attribute16            VARCHAR2 DEFAULT NULL,
144                 X_global_attribute17            VARCHAR2 DEFAULT NULL,
145                 X_global_attribute18            VARCHAR2 DEFAULT NULL,
146                 X_global_attribute19            VARCHAR2 DEFAULT NULL,
147                 X_global_attribute20            VARCHAR2 DEFAULT NULL,
148                 X_Bank_Charge_Bearer		VARCHAR2 DEFAULT NULL,
149 		--Bug :2809214 MOAC - Supplier Attribute Change Project
150 		X_NI_Number			VARCHAR2 DEFAULT NULL,
151 		X_calling_sequence		VARCHAR2 );
152 
153 	PROCEDURE Insert_Row(
154 		p_vendor_rec IN AP_VENDOR_PUB_PKG.r_vendor_rec_type
155                 ,p_last_update_date IN DATE
156                 ,p_last_updated_by IN NUMBER
157                 ,p_last_update_login IN NUMBER
158                 ,p_creation_date IN DATE
159                 ,p_created_by IN NUMBER
160                 ,p_request_id IN NUMBER
161                 ,p_program_application_id IN NUMBER
162                 ,p_program_id IN NUMBER
163                 ,p_program_update_date IN DATE
164                 ,x_rowid OUT NOCOPY VARCHAR2
165                 ,x_vendor_id OUT NOCOPY NUMBER);
166 --
167 --
168 	PROCEDURE Update_Row (
169 		x_Rowid 			VARCHAR2,
170 		x_Vendor_Id			NUMBER,
171 		x_Last_Update_Date		DATE,
172 		x_Last_Updated_By		NUMBER,
173 		x_Vendor_Name			VARCHAR2,
174 		x_Segment1			VARCHAR2,
175 		x_Summary_Flag			VARCHAR2,
176 		x_Enabled_Flag			VARCHAR2,
177 		x_Last_Update_Login		NUMBER,
178 		x_Employee_Id			NUMBER,
179 		x_Validation_Number		NUMBER,
180 		x_Vendor_Type_Lookup_Code	VARCHAR2,
181 		x_Customer_Num			VARCHAR2,
182 		x_One_Time_Flag			VARCHAR2,
183 		x_Parent_Vendor_Id		NUMBER,
184 		x_Min_Order_Amount		NUMBER,
185 		--Bug :2809214 MOAC - Supplier Attribute Change Project
186 		/* x_Ship_To_Location_Id	NUMBER,
187 		x_Bill_To_Location_Id		NUMBER,
188 		x_Ship_Via_Lookup_Code		VARCHAR2,
189 		x_Freight_Terms_Lookup_Code	VARCHAR2,
190 		x_Fob_Lookup_Code		VARCHAR2, */
191 		x_Terms_Id			NUMBER,
192 		x_Set_Of_Books_Id		NUMBER,
193 		x_Always_Take_Disc_Flag		VARCHAR2,
194 		x_Pay_Date_Basis_Lookup_Code	VARCHAR2,
195 		x_Pay_Group_Lookup_Code		VARCHAR2,
196 		x_Payment_Priority		NUMBER,
197 		x_Invoice_Currency_Code		VARCHAR2,
198 		x_Payment_Currency_Code		VARCHAR2,
199 		x_Invoice_Amount_Limit		NUMBER,
200 		x_Hold_All_Payments_Flag	VARCHAR2,
201 		x_Hold_Future_Payments_Flag	VARCHAR2,
202 		x_Hold_Reason			VARCHAR2,
203 		--Bug :2809214 MOAC - Supplier Attribute Change Project
204 		/* x_Distribution_Set_Id	NUMBER,
205 		x_Accts_Pay_CCID		NUMBER,
206 		x_Future_Dated_Payment_CCID	NUMBER,
207 		x_Prepay_CCID			NUMBER, */
208 		x_Num_1099			VARCHAR2,
209 		x_Type_1099			VARCHAR2,
210 		x_Withholding_Stat_Lookup_Code	VARCHAR2,
211 		x_Withholding_Start_Date	DATE,
212 		x_Org_Type_Lookup_Code		VARCHAR2,
213 		-- eTax Uptake x_Vat_Code	VARCHAR2,
214 		x_Start_Date_Active		DATE,
215 		x_End_Date_Active		DATE,
216 		x_Qty_Rcv_Tolerance		NUMBER,
217 		x_Minority_Group_Lookup_Code	VARCHAR2,
218 		--4552701 x_Payment_Method_Lookup_Code	VARCHAR2,
219 		x_Bank_Account_Name		VARCHAR2,
220 		x_Bank_Account_Num		VARCHAR2,
221 		x_Bank_Num			VARCHAR2,
222 		x_Bank_Account_Type		VARCHAR2,
223 		x_Women_Owned_Flag		VARCHAR2,
224 		x_Small_Business_Flag		VARCHAR2,
225 		x_Standard_Industry_Class	VARCHAR2,
226 		x_Attribute_Category		VARCHAR2,
227 		x_Attribute1			VARCHAR2,
228 		x_Attribute2			VARCHAR2,
229 		x_Attribute3			VARCHAR2,
230 		x_Attribute4			VARCHAR2,
231 		x_Attribute5			VARCHAR2,
232 		x_Hold_Flag			VARCHAR2,
233 		x_Purchasing_Hold_Reason	VARCHAR2,
234 		x_Hold_By			NUMBER,
235 		x_Hold_Date			DATE,
236 		x_Terms_Date_Basis		VARCHAR2,
237 		x_Price_Tolerance		NUMBER,
238 		x_Attribute10			VARCHAR2,
239 		x_Attribute11			VARCHAR2,
240 		x_Attribute12			VARCHAR2,
241 		x_Attribute13			VARCHAR2,
242 		x_Attribute14			VARCHAR2,
243 		x_Attribute15			VARCHAR2,
244 		x_Attribute6			VARCHAR2,
245 		x_Attribute7			VARCHAR2,
246 		x_Attribute8			VARCHAR2,
247 		x_Attribute9			VARCHAR2,
248 		x_Days_Early_Receipt_Allowed	NUMBER,
249 		x_Days_Late_Receipt_Allowed	NUMBER,
250 		x_Enforce_Ship_To_Loc_Code	VARCHAR2,
251 		--4552701 x_Exclusive_Payment_Flag	VARCHAR2,
252 		x_Federal_Reportable_Flag	VARCHAR2,
253 		x_Hold_Unmatched_Invoices_Flag	VARCHAR2,
254 		x_match_option			VARCHAR2,
255 		x_create_debit_memo_flag	VARCHAR2,
256 		x_Inspection_Required_Flag	VARCHAR2,
257 		x_Receipt_Required_Flag		VARCHAR2,
258 		x_Receiving_Routing_Id		NUMBER,
259 		x_State_Reportable_Flag		VARCHAR2,
260 		x_Tax_Verification_Date		DATE,
261 		x_Auto_Calculate_Interest_Flag	VARCHAR2,
262 		x_Name_Control			VARCHAR2,
263 		x_Allow_Subst_Receipts_Flag	VARCHAR2,
264 		x_Allow_Unord_Receipts_Flag	VARCHAR2,
265 		x_Receipt_Days_Exception_Code	VARCHAR2,
266 		x_Qty_Rcv_Exception_Code	VARCHAR2,
267 		-- eTax Uptake x_Offset_Tax_Flag VARCHAR2,
268 		x_Exclude_Freight_From_Disc	VARCHAR2,
269 		x_Vat_Registration_Num		VARCHAR2,
270 		x_Tax_Reporting_Name		VARCHAR2,
271 		x_Awt_Group_Id			NUMBER,
272                 x_Pay_Awt_Group_Id              NUMBER,--bug6664407
273 		x_Check_Digits			VARCHAR2,
274 		x_Bank_Number			VARCHAR2,
275 		x_Allow_Awt_Flag		VARCHAR2,
276 		x_Bank_Branch_Type		VARCHAR2,
277 		/* 4552701
278                 x_EDI_Payment_Method		VARCHAR2,
279 		x_EDI_Payment_Format		VARCHAR2,
280 		x_EDI_Remittance_Method		VARCHAR2,
281 		x_EDI_Remittance_Instruction	VARCHAR2,
282 		x_EDI_transaction_handling	VARCHAR2,
283 		 eTax Uptake
284 		x_Auto_Tax_Calc_Flag		VARCHAR2,
285 		x_Auto_Tax_Calc_Override	VARCHAR2,
286 		x_Amount_Includes_Tax_Flag	VARCHAR2,
287 		x_AP_Tax_Rounding_Rule		VARCHAR2, */
288                 x_Vendor_Name_Alt	 	VARCHAR2,
289                 X_global_attribute_category     VARCHAR2 DEFAULT NULL,
290                 X_global_attribute1             VARCHAR2 DEFAULT NULL,
291                 X_global_attribute2             VARCHAR2 DEFAULT NULL,
292                 X_global_attribute3             VARCHAR2 DEFAULT NULL,
293                 X_global_attribute4             VARCHAR2 DEFAULT NULL,
294                 X_global_attribute5             VARCHAR2 DEFAULT NULL,
295                 X_global_attribute6             VARCHAR2 DEFAULT NULL,
296                 X_global_attribute7             VARCHAR2 DEFAULT NULL,
297                 X_global_attribute8             VARCHAR2 DEFAULT NULL,
298                 X_global_attribute9             VARCHAR2 DEFAULT NULL,
299                 X_global_attribute10            VARCHAR2 DEFAULT NULL,
303                 X_global_attribute14            VARCHAR2 DEFAULT NULL,
300                 X_global_attribute11            VARCHAR2 DEFAULT NULL,
301                 X_global_attribute12            VARCHAR2 DEFAULT NULL,
302                 X_global_attribute13            VARCHAR2 DEFAULT NULL,
304                 X_global_attribute15            VARCHAR2 DEFAULT NULL,
305                 X_global_attribute16            VARCHAR2 DEFAULT NULL,
306                 X_global_attribute17            VARCHAR2 DEFAULT NULL,
307                 X_global_attribute18            VARCHAR2 DEFAULT NULL,
308                 X_global_attribute19            VARCHAR2 DEFAULT NULL,
309                 X_global_attribute20            VARCHAR2 DEFAULT NULL,
310 		X_Bank_Charge_Bearer		VARCHAR2 DEFAULT NULL,
311 		--Bug :2809214 MOAC - Supplier Attribute Change Project
312 		X_NI_Number			VARCHAR2 DEFAULT NULL,
313 		X_calling_sequence		VARCHAR2 );
314 
315         PROCEDURE update_row(
316                 p_vendor_rec  AP_VENDOR_PUB_PKG.r_vendor_rec_type,
317                 p_last_update_date DATE,
318                 p_last_updated_by  NUMBER,
319                 p_last_update_login  NUMBER,
320                 p_request_id  NUMBER,
321                 p_program_application_id NUMBER,
322                 p_program_id  NUMBER,
323                 p_program_update_date DATE,
324 		p_rowid	VARCHAR2,
325                 p_vendor_id NUMBER);
326 --
327 --
328 	PROCEDURE Lock_Row(
329 		x_Rowid				VARCHAR2,
330 		x_Vendor_Id			NUMBER,
331 		x_Vendor_Name			VARCHAR2,
332 		x_Segment1			VARCHAR2,
333 		x_Summary_Flag			VARCHAR2,
334 		x_Enabled_Flag			VARCHAR2,
335 		x_Employee_Id			NUMBER,
336 		x_Validation_Number		NUMBER,
337 		x_Vendor_Type_Lookup_Code	VARCHAR2,
338 		x_Customer_Num			VARCHAR2,
339 		x_One_Time_Flag			VARCHAR2,
340 		x_Parent_Vendor_Id		NUMBER,
341 		x_Min_Order_Amount		NUMBER,
342 		--Bug :2809214 MOAC - Supplier Attribute Change Project
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_Terms_Id			NUMBER,
349 		x_Set_Of_Books_Id		NUMBER,
350 		x_Always_Take_Disc_Flag		VARCHAR2,
351 		x_Pay_Date_Basis_Lookup_Code	VARCHAR2,
352 		x_Pay_Group_Lookup_Code		VARCHAR2,
353 		x_Payment_Priority		NUMBER,
354 		x_Invoice_Currency_Code		VARCHAR2,
355 		x_Payment_Currency_Code		VARCHAR2,
356 		x_Invoice_Amount_Limit		NUMBER,
357 		x_Hold_All_Payments_Flag	VARCHAR2,
358 		x_Hold_Future_Payments_Flag	VARCHAR2,
359 		x_Hold_Reason			VARCHAR2,
360 		--Bug :2809214 MOAC - Supplier Attribute Change Project
361 		/* x_Distribution_Set_Id	NUMBER,
362 		x_Accts_Pay_CCID		NUMBER,
363 		x_Future_Dated_Payment_CCID	NUMBER,
364 		x_Prepay_CCID			NUMBER, */
365 		x_Num_1099			VARCHAR2,
366 		x_Type_1099			VARCHAR2,
367 		x_Withholding_Stat_Lookup_Code	VARCHAR2,
368 		x_Withholding_Start_Date	DATE,
369 		x_Org_Type_Lookup_Code		VARCHAR2,
370 		-- eTax Uptake x_Vat_Code	VARCHAR2,
371 		x_Start_Date_Active		DATE,
372 		x_End_Date_Active		DATE,
373 		x_Qty_Rcv_Tolerance		NUMBER,
374 		x_Minority_Group_Lookup_Code	VARCHAR2,
375 		--4552701 x_Payment_Method_Lookup_Code	VARCHAR2,
376 		x_Bank_Account_Name		VARCHAR2,
377 		x_Bank_Account_Num		VARCHAR2,
378 		x_Bank_Num			VARCHAR2,
379 		x_Bank_Account_Type		VARCHAR2,
380 		x_Women_Owned_Flag		VARCHAR2,
381 		x_Small_Business_Flag		VARCHAR2,
382 		x_Standard_Industry_Class	VARCHAR2,
383 		x_Attribute_Category		VARCHAR2,
384 		x_Attribute1			VARCHAR2,
385 		x_Attribute2			VARCHAR2,
386 		x_Attribute3			VARCHAR2,
387 		x_Attribute4			VARCHAR2,
388 		x_Attribute5			VARCHAR2,
389 		x_Hold_Flag			VARCHAR2,
390 		x_Purchasing_Hold_Reason	VARCHAR2,
391 		x_Hold_By			NUMBER,
392 		x_Hold_Date			DATE,
393 		x_Terms_Date_Basis		VARCHAR2,
394 		x_Price_Tolerance		NUMBER,
395 		x_Attribute10			VARCHAR2,
396 		x_Attribute11			VARCHAR2,
397 		x_Attribute12			VARCHAR2,
398 		x_Attribute13			VARCHAR2,
399 		x_Attribute14			VARCHAR2,
400 		x_Attribute15			VARCHAR2,
401 		x_Attribute6			VARCHAR2,
402 		x_Attribute7			VARCHAR2,
403 		x_Attribute8			VARCHAR2,
404 		x_Attribute9			VARCHAR2,
405 		x_Days_Early_Receipt_Allowed	NUMBER,
406 		x_Days_Late_Receipt_Allowed	NUMBER,
407 		x_Enforce_Ship_To_Loc_Code	VARCHAR2,
408 		--4552701 x_Exclusive_Payment_Flag	VARCHAR2,
409 		x_Federal_Reportable_Flag	VARCHAR2,
410 		x_Hold_Unmatched_Invoices_Flag	VARCHAR2,
411 		x_match_option			VARCHAR2,
412 		x_create_debit_memo_flag	VARCHAR2,
413 		x_Inspection_Required_Flag	VARCHAR2,
414 		x_Receipt_Required_Flag		VARCHAR2,
415 		x_Receiving_Routing_Id		NUMBER,
416 		x_State_Reportable_Flag		VARCHAR2,
417 		x_Tax_Verification_Date		DATE,
418 		x_Auto_Calculate_Interest_Flag	VARCHAR2,
419 		x_Name_Control			VARCHAR2,
420 		x_Allow_Subst_Receipts_Flag	VARCHAR2,
421 		x_Allow_Unord_Receipts_Flag	VARCHAR2,
422 		x_Receipt_Days_Exception_Code	VARCHAR2,
423 		x_Qty_Rcv_Exception_Code	VARCHAR2,
424 		-- eTax Uptake x_Offset_Tax_Flag VARCHAR2,
425 		x_Exclude_Freight_From_Disc	VARCHAR2,
426 		x_Vat_Registration_Num		VARCHAR2,
427 		x_Tax_Reporting_Name		VARCHAR2,
428 		x_Awt_Group_Id			NUMBER,
429                 x_Pay_Awt_Group_Id                  NUMBER,--bug6664407
430 		x_Check_Digits			VARCHAR2,
434 		/*4552701
431 		x_Bank_Number			VARCHAR2,
432 		x_Allow_Awt_Flag		VARCHAR2,
433 		x_Bank_Branch_Type		VARCHAR2,
435                 x_EDI_Payment_Method		VARCHAR2,
436 		x_EDI_Payment_Format		VARCHAR2,
437 		x_EDI_Remittance_Method		VARCHAR2,
438 		x_EDI_Remittance_Instruction	VARCHAR2,
439 		x_EDI_transaction_handling	VARCHAR2,
440 	        eTax Uptake
441 		x_Auto_Tax_Calc_Flag		VARCHAR2,
442 		x_Auto_Tax_Calc_Override	VARCHAR2,
443 		x_Amount_Includes_Tax_Flag	VARCHAR2,
444 		x_AP_Tax_Rounding_Rule		VARCHAR2, */
445                 x_Vendor_Name_Alt	 	VARCHAR2,
446                 X_global_attribute_category     VARCHAR2 DEFAULT NULL,
447                 X_global_attribute1             VARCHAR2 DEFAULT NULL,
448                 X_global_attribute2             VARCHAR2 DEFAULT NULL,
449                 X_global_attribute3             VARCHAR2 DEFAULT NULL,
450                 X_global_attribute4             VARCHAR2 DEFAULT NULL,
451                 X_global_attribute5             VARCHAR2 DEFAULT NULL,
452                 X_global_attribute6             VARCHAR2 DEFAULT NULL,
453                 X_global_attribute7             VARCHAR2 DEFAULT NULL,
454                 X_global_attribute8             VARCHAR2 DEFAULT NULL,
455                 X_global_attribute9             VARCHAR2 DEFAULT NULL,
456                 X_global_attribute10            VARCHAR2 DEFAULT NULL,
457                 X_global_attribute11            VARCHAR2 DEFAULT NULL,
458                 X_global_attribute12            VARCHAR2 DEFAULT NULL,
459                 X_global_attribute13            VARCHAR2 DEFAULT NULL,
460                 X_global_attribute14            VARCHAR2 DEFAULT NULL,
461                 X_global_attribute15            VARCHAR2 DEFAULT NULL,
462                 X_global_attribute16            VARCHAR2 DEFAULT NULL,
463                 X_global_attribute17            VARCHAR2 DEFAULT NULL,
464                 X_global_attribute18            VARCHAR2 DEFAULT NULL,
465                 X_global_attribute19            VARCHAR2 DEFAULT NULL,
466                 X_global_attribute20            VARCHAR2 DEFAULT NULL,
467 		X_Bank_Charge_Bearer		VARCHAR2 DEFAULT NULL,
468 		--Bug :2809214 MOAC - Supplier Attribute Change Project
469 		X_NI_Number			VARCHAR2 DEFAULT NULL,
470 		X_calling_sequence		VARCHAR2 );
471 
472 
473 --
474 --
475 /* Procedure does double duty, to check if denormalized vendor name
476    exists in payables and also to check for a duplicate vendor name
477    in the PO_Vendors table.
478 */
479 
480   procedure check_unique_vendor_name (	p_vendor_id		in number,
481 					p_vendor_name		in varchar2,
482 					X_calling_sequence	in varchar2  );
483 
484   --
485   procedure check_denormalized_vendor_name (	p_vendor_id 		in	number,
486 						p_warning_flag 		in out NOCOPY  varchar2,
487 						X_calling_sequence	in	varchar2 );
488   --
489   procedure check_unique_vendor_number (	p_vendor_id		in number,
490 						p_vendor_number		in varchar2,
491 						X_calling_sequence	in varchar2 );
492 
493   --
494   PROCEDURE CHECK_SELECTED_INVOICES (		x_return_count		in out NOCOPY number,
495 						x_vendor_id		in number,
496 						X_calling_sequence	in varchar2);
497 
498   PROCEDURE CHECK_DUPLICATE_EMPLOYEE (		p_rowid			in varchar2,
499 						p_employee_id		in number,
500 						X_calling_sequence	in varchar2);
501 
502   PROCEDURE RESOLVE_EMPLOYEE (			x_employee_id		in number,
503 						x_employee_name 	in out NOCOPY varchar2,
504 						x_employee_number	in out NOCOPY varchar2,
505 						X_calling_sequence 	in varchar2);
506 
507   PROCEDURE GET_MESSAGE_TEXT (			x_application		in varchar2,
508 						x_message_name		in varchar2,
509 						x_message_text		in out NOCOPY varchar2);
510 
511   --
512 END AP_VENDORS_PKG;