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.FUN_VENDOR_PVT_PKG

Source


1 PACKAGE FUN_VENDOR_PVT_PKG AUTHID CURRENT_USER AS
2 /* $Header: funvndrs.pls 120.0 2006/02/15 14:12:48 ashikuma noship $ */
3 
4 -- Record Types
5 
6 -- External payee record and table
7 Type External_Payee_Rec_Type IS Record(
8    Payee_Party_Id        IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
9    Payment_Function      IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE,
10    Exclusive_Pay_Flag    IBY_EXTERNAL_PAYEES_ALL.exclusive_payment_flag%TYPE,
11    Payee_Party_Site_Id   IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
12    Supplier_Site_Id      IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
13    Payer_Org_Id          IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
14    Payer_Org_Type        IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
15    Default_Pmt_method    IBY_PAYMENT_METHODS_B.payment_method_code%TYPE,
16    ECE_TP_Loc_Code       IBY_EXTERNAL_PAYEES_ALL.ece_tp_location_code%TYPE,
17    Bank_Charge_Bearer    IBY_EXTERNAL_PAYEES_ALL.bank_charge_bearer%TYPE,
18    Bank_Instr1_Code      IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE,
19    Bank_Instr2_Code      IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE,
20    Bank_Instr_Detail     IBY_EXTERNAL_PAYEES_ALL.bank_instruction_details%TYPE,
21    Pay_Reason_Code       IBY_EXTERNAL_PAYEES_ALL.payment_reason_code%TYPE,
22    Pay_Reason_Com        IBY_EXTERNAL_PAYEES_ALL.payment_reason_comments%TYPE,
23    Inactive_Date         IBY_EXTERNAL_PAYEES_ALL.inactive_date%TYPE,
24    Pay_Message1          IBY_EXTERNAL_PAYEES_ALL.payment_text_message1%TYPE,
25    Pay_Message2          IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE,
26    Pay_Message3          IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE,
27    Delivery_Channel      IBY_EXTERNAL_PAYEES_ALL.delivery_channel_code%TYPE,
28    Pmt_Format            IBY_FORMATS_B.format_code%TYPE,
29    Settlement_Priority   IBY_EXTERNAL_PAYEES_ALL.settlement_priority%TYPE
30 );
31 
32 TYPE r_vendor_rec_type IS RECORD(
33 	VENDOR_ID	PO_VENDORS.VENDOR_ID%TYPE,
34 	SEGMENT1	PO_VENDORS.SEGMENT1%TYPE,
35 	VENDOR_NAME	VARCHAR2(360),
36 	VENDOR_NAME_ALT	VARCHAR2(320),
37 	SUMMARY_FLAG	PO_VENDORS.SUMMARY_FLAG%TYPE,
38 	ENABLED_FLAG	PO_VENDORS.ENABLED_FLAG%TYPE,
39 	SEGMENT2	PO_VENDORS.SEGMENT2%TYPE,
40 	SEGMENT3	PO_VENDORS.SEGMENT3%TYPE,
41 	SEGMENT4	PO_VENDORS.SEGMENT4%TYPE,
42 	SEGMENT5	PO_VENDORS.SEGMENT5%TYPE,
43 	EMPLOYEE_ID	PO_VENDORS.EMPLOYEE_ID%TYPE,
44 	VENDOR_TYPE_LOOKUP_CODE	PO_VENDORS.VENDOR_TYPE_LOOKUP_CODE%TYPE,
45 	CUSTOMER_NUM	PO_VENDORS.CUSTOMER_NUM%TYPE,
46 	ONE_TIME_FLAG	PO_VENDORS.ONE_TIME_FLAG%TYPE,
47 	PARENT_VENDOR_ID 	PO_VENDORS.PARENT_VENDOR_ID%TYPE,
48 	MIN_ORDER_AMOUNT	PO_VENDORS.MIN_ORDER_AMOUNT%TYPE,
49 	TERMS_ID	PO_VENDORS.TERMS_ID%TYPE,
50 	SET_OF_BOOKS_ID	PO_VENDORS.SET_OF_BOOKS_ID%TYPE,
51 	ALWAYS_TAKE_DISC_FLAG	PO_VENDORS.ALWAYS_TAKE_DISC_FLAG%TYPE,
52 	PAY_DATE_BASIS_LOOKUP_CODE PO_VENDORS.PAY_DATE_BASIS_LOOKUP_CODE%TYPE,
53 	PAY_GROUP_LOOKUP_CODE	PO_VENDORS.PAY_GROUP_LOOKUP_CODE%TYPE,
54 	PAYMENT_PRIORITY	PO_VENDORS.PAYMENT_PRIORITY%TYPE,
55 	INVOICE_CURRENCY_CODE	PO_VENDORS.INVOICE_CURRENCY_CODE%TYPE,
56 	PAYMENT_CURRENCY_CODE	PO_VENDORS.PAYMENT_CURRENCY_CODE%TYPE,
57 	INVOICE_AMOUNT_LIMIT	PO_VENDORS.INVOICE_AMOUNT_LIMIT%TYPE,
58 	HOLD_ALL_PAYMENTS_FLAG	PO_VENDORS.HOLD_ALL_PAYMENTS_FLAG%TYPE,
59 	HOLD_FUTURE_PAYMENTS_FLAG PO_VENDORS.HOLD_FUTURE_PAYMENTS_FLAG%TYPE,
60 	HOLD_REASON	PO_VENDORS.HOLD_REASON%TYPE,
61 	TYPE_1099	PO_VENDORS.TYPE_1099%TYPE,
62 	WITHHOLDING_STATUS_LOOKUP_CODE	PO_VENDORS.WITHHOLDING_STATUS_LOOKUP_CODE%TYPE,
63 	WITHHOLDING_START_DATE	PO_VENDORS.WITHHOLDING_START_DATE%TYPE,
64 	ORGANIZATION_TYPE_LOOKUP_CODE	PO_VENDORS.ORGANIZATION_TYPE_LOOKUP_CODE%TYPE,
65 	START_DATE_ACTIVE	PO_VENDORS.START_DATE_ACTIVE%TYPE,
66 	END_DATE_ACTIVE	PO_VENDORS.END_DATE_ACTIVE%TYPE,
67 	MINORITY_GROUP_LOOKUP_CODE	PO_VENDORS.MINORITY_GROUP_LOOKUP_CODE%TYPE,
68 	WOMEN_OWNED_FLAG	PO_VENDORS.WOMEN_OWNED_FLAG%TYPE,
69 	SMALL_BUSINESS_FLAG	PO_VENDORS.SMALL_BUSINESS_FLAG%TYPE,
70 	HOLD_FLAG	PO_VENDORS.HOLD_FLAG%TYPE,
71 	PURCHASING_HOLD_REASON	PO_VENDORS.PURCHASING_HOLD_REASON%TYPE,
72 	HOLD_BY	PO_VENDORS.HOLD_BY%TYPE,
73 	HOLD_DATE	PO_VENDORS.HOLD_DATE%TYPE,
74 	TERMS_DATE_BASIS	PO_VENDORS.TERMS_DATE_BASIS%TYPE,
75 	INSPECTION_REQUIRED_FLAG	PO_VENDORS.INSPECTION_REQUIRED_FLAG%TYPE,
76 	RECEIPT_REQUIRED_FLAG	PO_VENDORS.RECEIPT_REQUIRED_FLAG%TYPE,
77 	QTY_RCV_TOLERANCE	PO_VENDORS.QTY_RCV_TOLERANCE%TYPE,
78 	QTY_RCV_EXCEPTION_CODE	PO_VENDORS.QTY_RCV_EXCEPTION_CODE%TYPE,
79 	ENFORCE_SHIP_TO_LOCATION_CODE	PO_VENDORS.ENFORCE_SHIP_TO_LOCATION_CODE%TYPE,
80 	DAYS_EARLY_RECEIPT_ALLOWED	PO_VENDORS.DAYS_EARLY_RECEIPT_ALLOWED%TYPE,
81 	DAYS_LATE_RECEIPT_ALLOWED	PO_VENDORS.DAYS_LATE_RECEIPT_ALLOWED%TYPE,
82 	RECEIPT_DAYS_EXCEPTION_CODE	PO_VENDORS.RECEIPT_DAYS_EXCEPTION_CODE%TYPE,
83 	RECEIVING_ROUTING_ID	PO_VENDORS.RECEIVING_ROUTING_ID%TYPE,
84 	ALLOW_SUBSTITUTE_RECEIPTS_FLAG	PO_VENDORS.ALLOW_SUBSTITUTE_RECEIPTS_FLAG%TYPE,
85 	ALLOW_UNORDERED_RECEIPTS_FLAG	PO_VENDORS.ALLOW_UNORDERED_RECEIPTS_FLAG%TYPE,
86 	HOLD_UNMATCHED_INVOICES_FLAG	PO_VENDORS.HOLD_UNMATCHED_INVOICES_FLAG%TYPE,
87 	TAX_VERIFICATION_DATE	PO_VENDORS.TAX_VERIFICATION_DATE%TYPE,
88 	NAME_CONTROL	PO_VENDORS.NAME_CONTROL%TYPE,
89 	STATE_REPORTABLE_FLAG	PO_VENDORS.STATE_REPORTABLE_FLAG%TYPE,
90 	FEDERAL_REPORTABLE_FLAG	PO_VENDORS.FEDERAL_REPORTABLE_FLAG%TYPE,
91 	ATTRIBUTE_CATEGORY	PO_VENDORS.ATTRIBUTE_CATEGORY%TYPE,
92 	ATTRIBUTE1	PO_VENDORS.ATTRIBUTE1%TYPE,
93 	ATTRIBUTE2	PO_VENDORS.ATTRIBUTE2%TYPE,
94 	ATTRIBUTE3	PO_VENDORS.ATTRIBUTE3%TYPE,
95 	ATTRIBUTE4	PO_VENDORS.ATTRIBUTE4%TYPE,
96 	ATTRIBUTE5	PO_VENDORS.ATTRIBUTE5%TYPE,
97 	ATTRIBUTE6	PO_VENDORS.ATTRIBUTE6%TYPE,
98 	ATTRIBUTE7	PO_VENDORS.ATTRIBUTE7%TYPE,
99 	ATTRIBUTE8	PO_VENDORS.ATTRIBUTE8%TYPE,
100 	ATTRIBUTE9	PO_VENDORS.ATTRIBUTE9%TYPE,
101 	ATTRIBUTE10	PO_VENDORS.ATTRIBUTE10%TYPE,
102 	ATTRIBUTE11	PO_VENDORS.ATTRIBUTE11%TYPE,
103 	ATTRIBUTE12	PO_VENDORS.ATTRIBUTE12%TYPE,
104 	ATTRIBUTE13	PO_VENDORS.ATTRIBUTE13%TYPE,
105 	ATTRIBUTE14	PO_VENDORS.ATTRIBUTE14%TYPE,
106 	ATTRIBUTE15	PO_VENDORS.ATTRIBUTE15%TYPE,
107 	AUTO_CALCULATE_INTEREST_FLAG	PO_VENDORS.AUTO_CALCULATE_INTEREST_FLAG%TYPE,
108 	VALIDATION_NUMBER	PO_VENDORS.VALIDATION_NUMBER%TYPE,
109 	EXCLUDE_FREIGHT_FROM_DISCOUNT	PO_VENDORS.EXCLUDE_FREIGHT_FROM_DISCOUNT%TYPE,
110 	TAX_REPORTING_NAME	PO_VENDORS.TAX_REPORTING_NAME%TYPE,
111 	CHECK_DIGITS	PO_VENDORS.CHECK_DIGITS%TYPE,
112 	ALLOW_AWT_FLAG	PO_VENDORS.ALLOW_AWT_FLAG%TYPE,
113 	AWT_GROUP_ID	PO_VENDORS.AWT_GROUP_ID%TYPE,
114 	AWT_GROUP_NAME	VARCHAR2(255),
115 	GLOBAL_ATTRIBUTE1 PO_VENDORS.GLOBAL_ATTRIBUTE1%TYPE,
116 	GLOBAL_ATTRIBUTE2	PO_VENDORS.GLOBAL_ATTRIBUTE2%TYPE,
117 	GLOBAL_ATTRIBUTE3	PO_VENDORS.GLOBAL_ATTRIBUTE3%TYPE,
118 	GLOBAL_ATTRIBUTE4	PO_VENDORS.GLOBAL_ATTRIBUTE4%TYPE,
119 	GLOBAL_ATTRIBUTE5	PO_VENDORS.GLOBAL_ATTRIBUTE5%TYPE,
120 	GLOBAL_ATTRIBUTE6	PO_VENDORS.GLOBAL_ATTRIBUTE6%TYPE,
121 	GLOBAL_ATTRIBUTE7 PO_VENDORS.GLOBAL_ATTRIBUTE7%TYPE,
122 	GLOBAL_ATTRIBUTE8	PO_VENDORS.GLOBAL_ATTRIBUTE8%TYPE,
123 	GLOBAL_ATTRIBUTE9	PO_VENDORS.GLOBAL_ATTRIBUTE9%TYPE,
124 	GLOBAL_ATTRIBUTE10	PO_VENDORS.GLOBAL_ATTRIBUTE10%TYPE,
125 	GLOBAL_ATTRIBUTE11	PO_VENDORS.GLOBAL_ATTRIBUTE11%TYPE,
126 	GLOBAL_ATTRIBUTE12	PO_VENDORS.GLOBAL_ATTRIBUTE12%TYPE,
127 	GLOBAL_ATTRIBUTE13	PO_VENDORS.GLOBAL_ATTRIBUTE13%TYPE,
128 	GLOBAL_ATTRIBUTE14	PO_VENDORS.GLOBAL_ATTRIBUTE14%TYPE,
129 	GLOBAL_ATTRIBUTE15	PO_VENDORS.GLOBAL_ATTRIBUTE15%TYPE,
130 	GLOBAL_ATTRIBUTE16	PO_VENDORS.GLOBAL_ATTRIBUTE16%TYPE,
131 	GLOBAL_ATTRIBUTE17	PO_VENDORS.GLOBAL_ATTRIBUTE17%TYPE,
132 	GLOBAL_ATTRIBUTE18	PO_VENDORS.GLOBAL_ATTRIBUTE18%TYPE,
133 	GLOBAL_ATTRIBUTE19	PO_VENDORS.GLOBAL_ATTRIBUTE19%TYPE,
134 	GLOBAL_ATTRIBUTE20	PO_VENDORS.GLOBAL_ATTRIBUTE20%TYPE,
135 	GLOBAL_ATTRIBUTE_CATEGORY	PO_VENDORS.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,
136 	BANK_CHARGE_BEARER		PO_VENDORS.BANK_CHARGE_BEARER%TYPE,
137 	MATCH_OPTION			PO_VENDORS.MATCH_OPTION%TYPE,
138 	CREATE_DEBIT_MEMO_FLAG		PO_VENDORS.CREATE_DEBIT_MEMO_FLAG%TYPE,
139 	PARTY_ID			PO_VENDORS.PARTY_ID%TYPE,
140 	PARENT_PARTY_ID			PO_VENDORS.PARENT_PARTY_ID%TYPE,
141         JGZZ_FISCAL_CODE                VARCHAR2(20),
142         SIC_CODE                        VARCHAR2(30),
143         TAX_REFERENCE                   VARCHAR2(50),
144 	INVENTORY_ORGANIZATION_ID	NUMBER,
145 	TERMS_NAME			VARCHAR2(255),
146 	DEFAULT_TERMS_ID		NUMBER,
147     	VENDOR_INTERFACE_ID		AP_SUPPLIERS_INT.VENDOR_INTERFACE_ID%TYPE,
148 	NI_NUMBER			VARCHAR2(30),
149 	EXT_PAYEE_REC			EXTERNAL_PAYEE_REC_TYPE);
150 
151 TYPE r_vendor_site_rec_type IS RECORD(
152 	AREA_CODE	PO_VENDOR_SITES_ALL.AREA_CODE%TYPE,
153 	PHONE	PO_VENDOR_SITES_ALL.PHONE%TYPE,
154 	CUSTOMER_NUM	PO_VENDOR_SITES_ALL.CUSTOMER_NUM%TYPE,
155 	SHIP_TO_LOCATION_ID	PO_VENDOR_SITES_ALL.SHIP_TO_LOCATION_ID%TYPE,
156 	BILL_TO_LOCATION_ID	PO_VENDOR_SITES_ALL.BILL_TO_LOCATION_ID%TYPE,
157 	SHIP_VIA_LOOKUP_CODE	PO_VENDOR_SITES_ALL.SHIP_VIA_LOOKUP_CODE%TYPE,
158 	FREIGHT_TERMS_LOOKUP_CODE	PO_VENDOR_SITES_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE,
159 	FOB_LOOKUP_CODE	PO_VENDOR_SITES_ALL.FOB_LOOKUP_CODE%TYPE,
160 	INACTIVE_DATE	PO_VENDOR_SITES_ALL.INACTIVE_DATE%TYPE,
161 	FAX	PO_VENDOR_SITES_ALL.FAX	%TYPE,
162 	FAX_AREA_CODE	PO_VENDOR_SITES_ALL.FAX_AREA_CODE%TYPE,
163 	TELEX	PO_VENDOR_SITES_ALL.TELEX%TYPE,
164 	TERMS_DATE_BASIS	PO_VENDOR_SITES_ALL.TERMS_DATE_BASIS%TYPE,
165 	DISTRIBUTION_SET_ID	PO_VENDOR_SITES_ALL.DISTRIBUTION_SET_ID%TYPE,
166 	ACCTS_PAY_CODE_COMBINATION_ID	PO_VENDOR_SITES_ALL.ACCTS_PAY_CODE_COMBINATION_ID%TYPE,
167 	PREPAY_CODE_COMBINATION_ID	PO_VENDOR_SITES_ALL.PREPAY_CODE_COMBINATION_ID%TYPE,
168 	PAY_GROUP_LOOKUP_CODE	PO_VENDOR_SITES_ALL.PAY_GROUP_LOOKUP_CODE%TYPE,
169 	PAYMENT_PRIORITY	PO_VENDOR_SITES_ALL.PAYMENT_PRIORITY%TYPE,
170 	TERMS_ID	PO_VENDOR_SITES_ALL.TERMS_ID%TYPE,
171 	INVOICE_AMOUNT_LIMIT	PO_VENDOR_SITES_ALL.INVOICE_AMOUNT_LIMIT%TYPE,
172 	PAY_DATE_BASIS_LOOKUP_CODE	PO_VENDOR_SITES_ALL.PAY_DATE_BASIS_LOOKUP_CODE%TYPE,
173 	ALWAYS_TAKE_DISC_FLAG	PO_VENDOR_SITES_ALL.ALWAYS_TAKE_DISC_FLAG%TYPE,
174 	INVOICE_CURRENCY_CODE	PO_VENDOR_SITES_ALL.INVOICE_CURRENCY_CODE%TYPE,
175 	PAYMENT_CURRENCY_CODE	PO_VENDOR_SITES_ALL.PAYMENT_CURRENCY_CODE%TYPE,
176 	VENDOR_SITE_ID	PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
177 	LAST_UPDATE_DATE	PO_VENDOR_SITES_ALL.LAST_UPDATE_DATE%TYPE,
178 	LAST_UPDATED_BY	PO_VENDOR_SITES_ALL.LAST_UPDATED_BY%TYPE,
179 	VENDOR_ID	PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,
180 	VENDOR_SITE_CODE	PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE,
181 	VENDOR_SITE_CODE_ALT	PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE_ALT%TYPE,
182 	PURCHASING_SITE_FLAG	PO_VENDOR_SITES_ALL.PURCHASING_SITE_FLAG%TYPE,
183 	RFQ_ONLY_SITE_FLAG	PO_VENDOR_SITES_ALL.RFQ_ONLY_SITE_FLAG%TYPE,
184 	PAY_SITE_FLAG	PO_VENDOR_SITES_ALL.PAY_SITE_FLAG%TYPE,
185 	ATTENTION_AR_FLAG	PO_VENDOR_SITES_ALL.ATTENTION_AR_FLAG%TYPE,
186 	HOLD_ALL_PAYMENTS_FLAG	PO_VENDOR_SITES_ALL.HOLD_ALL_PAYMENTS_FLAG%TYPE,
187 	HOLD_FUTURE_PAYMENTS_FLAG	PO_VENDOR_SITES_ALL.HOLD_FUTURE_PAYMENTS_FLAG%TYPE,
191 	ATTRIBUTE_CATEGORY	PO_VENDOR_SITES_ALL.ATTRIBUTE_CATEGORY%TYPE,
188 	HOLD_REASON	PO_VENDOR_SITES_ALL.HOLD_REASON%TYPE,
189 	HOLD_UNMATCHED_INVOICES_FLAG	PO_VENDOR_SITES_ALL.HOLD_UNMATCHED_INVOICES_FLAG%TYPE,
190 	TAX_REPORTING_SITE_FLAG	PO_VENDOR_SITES_ALL.TAX_REPORTING_SITE_FLAG%TYPE,
192 	ATTRIBUTE1	PO_VENDOR_SITES_ALL.ATTRIBUTE1%TYPE,
193 	ATTRIBUTE2	PO_VENDOR_SITES_ALL.ATTRIBUTE2%TYPE,
194 	ATTRIBUTE3	PO_VENDOR_SITES_ALL.ATTRIBUTE3%TYPE,
195 	ATTRIBUTE4	PO_VENDOR_SITES_ALL.ATTRIBUTE4%TYPE,
196 	ATTRIBUTE5	PO_VENDOR_SITES_ALL.ATTRIBUTE5%TYPE,
197 	ATTRIBUTE6	PO_VENDOR_SITES_ALL.ATTRIBUTE6%TYPE,
198 	ATTRIBUTE7	PO_VENDOR_SITES_ALL.ATTRIBUTE7%TYPE,
199 	ATTRIBUTE8	PO_VENDOR_SITES_ALL.ATTRIBUTE8%TYPE,
200 	ATTRIBUTE9	PO_VENDOR_SITES_ALL.ATTRIBUTE9%TYPE,
201 	ATTRIBUTE10	PO_VENDOR_SITES_ALL.ATTRIBUTE10%TYPE,
202 	ATTRIBUTE11	PO_VENDOR_SITES_ALL.ATTRIBUTE11%TYPE,
203 	ATTRIBUTE12	PO_VENDOR_SITES_ALL.ATTRIBUTE12%TYPE,
204 	ATTRIBUTE13	PO_VENDOR_SITES_ALL.ATTRIBUTE13%TYPE,
205 	ATTRIBUTE14	PO_VENDOR_SITES_ALL.ATTRIBUTE14%TYPE,
206 	ATTRIBUTE15	PO_VENDOR_SITES_ALL.ATTRIBUTE15%TYPE,
207 	VALIDATION_NUMBER	PO_VENDOR_SITES_ALL.VALIDATION_NUMBER%TYPE,
208 	EXCLUDE_FREIGHT_FROM_DISCOUNT	PO_VENDOR_SITES_ALL.EXCLUDE_FREIGHT_FROM_DISCOUNT%TYPE,
209 	BANK_CHARGE_BEARER	PO_VENDOR_SITES_ALL.BANK_CHARGE_BEARER%TYPE,
210 	ORG_ID	PO_VENDOR_SITES_ALL.ORG_ID%TYPE,
211 	CHECK_DIGITS	PO_VENDOR_SITES_ALL.CHECK_DIGITS%TYPE,
212 	ALLOW_AWT_FLAG	PO_VENDOR_SITES_ALL.ALLOW_AWT_FLAG%TYPE,
213 	AWT_GROUP_ID	PO_VENDOR_SITES_ALL.AWT_GROUP_ID%TYPE,
214 	DEFAULT_PAY_SITE_ID	PO_VENDOR_SITES_ALL.DEFAULT_PAY_SITE_ID%TYPE,
215 	PAY_ON_CODE	PO_VENDOR_SITES_ALL.PAY_ON_CODE%TYPE,
216 	PAY_ON_RECEIPT_SUMMARY_CODE	PO_VENDOR_SITES_ALL.PAY_ON_RECEIPT_SUMMARY_CODE%TYPE,
217 	GLOBAL_ATTRIBUTE_CATEGORY	PO_VENDOR_SITES_ALL.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,
218 	GLOBAL_ATTRIBUTE1	PO_VENDOR_SITES_ALL.GLOBAL_ATTRIBUTE1%TYPE,
219 	GLOBAL_ATTRIBUTE2	PO_VENDOR_SITES_ALL.GLOBAL_ATTRIBUTE2%TYPE,
220 	GLOBAL_ATTRIBUTE3	PO_VENDOR_SITES_ALL.GLOBAL_ATTRIBUTE3%TYPE,
221 	GLOBAL_ATTRIBUTE4	PO_VENDOR_SITES_ALL.GLOBAL_ATTRIBUTE4%TYPE,
222 	GLOBAL_ATTRIBUTE5	PO_VENDOR_SITES_ALL.GLOBAL_ATTRIBUTE5%TYPE,
223 	GLOBAL_ATTRIBUTE6	PO_VENDOR_SITES_ALL.GLOBAL_ATTRIBUTE6%TYPE,
224 	GLOBAL_ATTRIBUTE7	PO_VENDOR_SITES_ALL.GLOBAL_ATTRIBUTE7%TYPE,
225 	GLOBAL_ATTRIBUTE8	PO_VENDOR_SITES_ALL.GLOBAL_ATTRIBUTE8%TYPE,
226 	GLOBAL_ATTRIBUTE9	PO_VENDOR_SITES_ALL.GLOBAL_ATTRIBUTE9%TYPE,
227 	GLOBAL_ATTRIBUTE10	PO_VENDOR_SITES_ALL.GLOBAL_ATTRIBUTE10%TYPE,
228 	GLOBAL_ATTRIBUTE11	PO_VENDOR_SITES_ALL.GLOBAL_ATTRIBUTE11%TYPE,
229 	GLOBAL_ATTRIBUTE12	PO_VENDOR_SITES_ALL.GLOBAL_ATTRIBUTE12%TYPE,
230 	GLOBAL_ATTRIBUTE13	PO_VENDOR_SITES_ALL.GLOBAL_ATTRIBUTE13%TYPE,
231 	GLOBAL_ATTRIBUTE14	PO_VENDOR_SITES_ALL.GLOBAL_ATTRIBUTE14%TYPE,
232 	GLOBAL_ATTRIBUTE15	PO_VENDOR_SITES_ALL.GLOBAL_ATTRIBUTE15%TYPE,
233 	GLOBAL_ATTRIBUTE16	PO_VENDOR_SITES_ALL.GLOBAL_ATTRIBUTE16%TYPE,
234 	GLOBAL_ATTRIBUTE17	PO_VENDOR_SITES_ALL.GLOBAL_ATTRIBUTE17%TYPE,
235 	GLOBAL_ATTRIBUTE18	PO_VENDOR_SITES_ALL.GLOBAL_ATTRIBUTE18%TYPE,
236 	GLOBAL_ATTRIBUTE19	PO_VENDOR_SITES_ALL.GLOBAL_ATTRIBUTE19%TYPE,
237 	GLOBAL_ATTRIBUTE20	PO_VENDOR_SITES_ALL.GLOBAL_ATTRIBUTE20%TYPE,
238 	TP_HEADER_ID	PO_VENDOR_SITES_ALL.TP_HEADER_ID%TYPE,
239 	ECE_TP_LOCATION_CODE	PO_VENDOR_SITES_ALL.ECE_TP_LOCATION_CODE%TYPE,
240 	PCARD_SITE_FLAG	PO_VENDOR_SITES_ALL.PCARD_SITE_FLAG%TYPE,
241 	MATCH_OPTION	PO_VENDOR_SITES_ALL.MATCH_OPTION%TYPE,
242 	COUNTRY_OF_ORIGIN_CODE	PO_VENDOR_SITES_ALL.COUNTRY_OF_ORIGIN_CODE%TYPE,
243 	FUTURE_DATED_PAYMENT_CCID	PO_VENDOR_SITES_ALL.FUTURE_DATED_PAYMENT_CCID%TYPE,
244 	CREATE_DEBIT_MEMO_FLAG	PO_VENDOR_SITES_ALL.CREATE_DEBIT_MEMO_FLAG%TYPE,
245 	SUPPLIER_NOTIF_METHOD	PO_VENDOR_SITES_ALL.SUPPLIER_NOTIF_METHOD%TYPE,
246 	EMAIL_ADDRESS	PO_VENDOR_SITES_ALL.EMAIL_ADDRESS%TYPE,
247 	PRIMARY_PAY_SITE_FLAG	PO_VENDOR_SITES_ALL.PRIMARY_PAY_SITE_FLAG%TYPE,
248 	SHIPPING_CONTROL	PO_VENDOR_SITES_ALL.SHIPPING_CONTROL%TYPE,
249 	SELLING_COMPANY_IDENTIFIER	PO_VENDOR_SITES_ALL.SELLING_COMPANY_IDENTIFIER%TYPE,
250 	GAPLESS_INV_NUM_FLAG	PO_VENDOR_SITES_ALL.GAPLESS_INV_NUM_FLAG%TYPE,
251 	LOCATION_ID	PO_VENDOR_SITES_ALL.LOCATION_ID%TYPE,
252 	PARTY_SITE_ID	PO_VENDOR_SITES_ALL.PARTY_SITE_ID%TYPE,
253 	ORG_NAME	VARCHAR2(255),
254 	DUNS_NUMBER	VARCHAR2(30),
255 	ADDRESS_STYLE 	VARCHAR2(30),
256 	LANGUAGE	VARCHAR2(4),
257 	PROVINCE	VARCHAR2(60),
258 	COUNTRY		VARCHAR2(60),
259 	ADDRESS_LINE1 	VARCHAR2(240),
260 	ADDRESS_LINE2	VARCHAR2(240),
261 	ADDRESS_LINE3	VARCHAR2(240),
262 	ADDRESS_LINE4	VARCHAR2(240),
263 	ADDRESS_LINES_ALT	VARCHAR2(560),
264 	COUNTY 		VARCHAR2(60),
265 	CITY		VARCHAR2(60),
266 	STATE		VARCHAR2(60),
267 	ZIP		VARCHAR2(60),
268 	TERMS_NAME	VARCHAR2(255),
269 	DEFAULT_TERMS_ID NUMBER,
270 	AWT_GROUP_NAME	VARCHAR2(255),
271 	 DISTRIBUTION_SET_NAME           VARCHAR2(255),
272         SHIP_TO_LOCATION_CODE           VARCHAR2(255),
273         BILL_TO_LOCATION_CODE           VARCHAR2(255),
274     	DEFAULT_DIST_SET_ID             NUMBER,
275         DEFAULT_SHIP_TO_LOC_ID          NUMBER,
276         DEFAULT_BILL_TO_LOC_ID          NUMBER,
277 	TOLERANCE_ID			NUMBER,
278 	TOLERANCE_NAME AP_TOLERANCE_TEMPLATES.tolerance_name%TYPE,
279     	VENDOR_INTERFACE_ID AP_SUPPLIER_SITES_INT.VENDOR_INTERFACE_ID%TYPE,
280     	VENDOR_SITE_INTERFACE_ID
281 		AP_SUPPLIER_SITES_INT.VENDOR_SITE_INTERFACE_ID%TYPE,
282         EXT_PAYEE_REC
283                 EXTERNAL_PAYEE_REC_TYPE,
284 	RETAINAGE_RATE			NUMBER DEFAULT NULL);
285 
286 
287 -- This procedure is invoked indirectly from the Supplier-Customer Association creation page
288 -- through the rosetta-generated java and plsql packages
289 
290 PROCEDURE Create_Vendor
291 ( 	p_api_version           	IN	NUMBER,
292   	p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE	,
293 	p_commit	    		IN  	VARCHAR2 := FND_API.G_FALSE,
294 	p_validation_level		IN  	NUMBER	:=
295 						FND_API.G_VALID_LEVEL_FULL,
296 	x_return_status		OUT	NOCOPY  VARCHAR2		  	,
297 	x_msg_count		OUT	NOCOPY  NUMBER,
298 	x_msg_data		OUT	NOCOPY  VARCHAR2,
299 	p_vendor_rec		IN	r_vendor_rec_type,
300 	x_vendor_id		OUT	NOCOPY  PO_VENDORS.VENDOR_ID%TYPE,
301 	x_party_id		OUT	NOCOPY  HZ_PARTIES.PARTY_ID%TYPE
302 );
303 
304 
305 -- This procedure is invoked indirectly from the Supplier-Customer Association updation page
306 -- through the rosetta-generated java and plsql packages
307 
308 PROCEDURE Update_Vendor
309 ( 	p_api_version           IN	NUMBER,
310   	p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE	,
311 	p_commit	    	IN  	VARCHAR2 := FND_API.G_FALSE,
312 	p_validation_level	IN  	NUMBER	:=
313 						FND_API.G_VALID_LEVEL_FULL,
314 	x_return_status		OUT	NOCOPY VARCHAR2		  	,
315 	x_msg_count		OUT	NOCOPY NUMBER,
316 	x_msg_data		OUT	NOCOPY VARCHAR2,
317 	p_vendor_rec		IN	r_vendor_rec_type,
318 	p_vendor_id		IN	NUMBER
319 );
320 
321 
322 -- This procedure is invoked indirectly from the Supplier-Customer Association creation page
323 -- through the rosetta-generated java and plsql packages
324 
325 PROCEDURE Create_Vendor_Site
326 ( 	p_api_version           IN	NUMBER,
327   	p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE	,
328 	p_commit	    	IN  	VARCHAR2 := FND_API.G_FALSE,
329 	p_validation_level	IN  	NUMBER	:=
330 						FND_API.G_VALID_LEVEL_FULL,
331 	x_return_status		OUT	NOCOPY VARCHAR2		  	,
332 	x_msg_count		OUT	NOCOPY NUMBER,
333 	x_msg_data		OUT	NOCOPY VARCHAR2,
334 	p_vendor_site_rec	IN	r_vendor_site_rec_type,
335 	x_vendor_site_id	OUT	NOCOPY NUMBER,
336 	x_party_site_id		OUT	NOCOPY NUMBER,
337 	x_location_id		OUT	NOCOPY NUMBER
338 );
339 
340 
341 -- This procedure is invoked indirectly from the Supplier-Customer Association updation page
342 -- through the rosetta-generated java and plsql packages
343 
344 PROCEDURE Update_Vendor_Site
345 ( 	p_api_version           IN	NUMBER,
346   	p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE	,
347 	p_commit	    	IN  	VARCHAR2 := FND_API.G_FALSE,
348 	p_validation_level	IN  	NUMBER	:=
349 						FND_API.G_VALID_LEVEL_FULL,
350 	x_return_status		OUT	NOCOPY VARCHAR2		  	,
351 	x_msg_count		OUT	NOCOPY NUMBER,
352 	x_msg_data		OUT	NOCOPY VARCHAR2,
353 	p_vendor_site_rec	IN	r_vendor_site_rec_type,
354 	p_vendor_site_id	IN	NUMBER
355 );
356 
357 
358 
359 END;
360 
361