DBA Data[Home] [Help]

PACKAGE: APPS.AP_VENDOR_PUB_PKG

Source


1 PACKAGE AP_VENDOR_PUB_PKG AUTHID CURRENT_USER AS
2 /* $Header: appvndrs.pls 120.38.12020000.2 2012/07/14 21:00:42 mkmeda ship $ */
3 /*#
4  * This Package provides APIs to allow users to create supplier,
5  * supplier site and supplier contact records into Payables.
6  * @rep:scope public
7  * @rep:product AP
8  * @rep:lifecycle active
9  * @rep:displayname Suppliers Package
10  * @rep:category BUSINESS_ENTITY AP_SUPPLIER
11  */
12 -- Global variables for Import
13 
14    g_source               VARCHAR2(30) := 'NOT IMPORT';
15    g_multi_org            VARCHAR2(1)  := 'Y';
16    g_default_org_id       VARCHAR2(255);
17    g_fed_fin_installed    VARCHAR2(1);
18    g_user_id              NUMBER(15):=FND_GLOBAL.user_id;
19    g_login_id             NUMBER(15):=FND_GLOBAL.login_id;
20 
21 -- Record Types
22 
23 -- Bug 4775923: Modified fields in the record types to be of table.column instead of fixed length definitions.
24 --              Alligned the spec so that it is more readable for troubleshooting.
25 
26 TYPE r_vendor_rec_type IS RECORD(
27 	VENDOR_ID			NUMBER,
28 	SEGMENT1			AP_SUPPLIERS.SEGMENT1%TYPE,
29 	VENDOR_NAME			AP_SUPPLIERS.VENDOR_NAME%TYPE,
30 	VENDOR_NAME_ALT			AP_SUPPLIERS.VENDOR_NAME_ALT%TYPE,
31 	SUMMARY_FLAG			AP_SUPPLIERS.SUMMARY_FLAG%TYPE,
32 	ENABLED_FLAG			AP_SUPPLIERS.ENABLED_FLAG%TYPE,
33 	SEGMENT2			AP_SUPPLIERS.SEGMENT2%TYPE,
34 	SEGMENT3			AP_SUPPLIERS.SEGMENT3%TYPE,
35 	SEGMENT4			AP_SUPPLIERS.SEGMENT4%TYPE,
36 	SEGMENT5			AP_SUPPLIERS.SEGMENT5%TYPE,
37 	EMPLOYEE_ID			NUMBER,
38 	VENDOR_TYPE_LOOKUP_CODE		AP_SUPPLIERS.VENDOR_TYPE_LOOKUP_CODE%TYPE,
39 	CUSTOMER_NUM			AP_SUPPLIERS.CUSTOMER_NUM%TYPE,
40 	ONE_TIME_FLAG			AP_SUPPLIERS.ONE_TIME_FLAG%TYPE,
41 	PARENT_VENDOR_ID 		NUMBER,
42 	MIN_ORDER_AMOUNT		NUMBER,
43 	TERMS_ID			NUMBER,
44 	SET_OF_BOOKS_ID			NUMBER,
45 	ALWAYS_TAKE_DISC_FLAG		AP_SUPPLIERS.ALWAYS_TAKE_DISC_FLAG%TYPE,
46 	PAY_DATE_BASIS_LOOKUP_CODE 	AP_SUPPLIERS.PAY_DATE_BASIS_LOOKUP_CODE%TYPE,
47 	PAY_GROUP_LOOKUP_CODE		AP_SUPPLIERS.PAY_GROUP_LOOKUP_CODE%TYPE,
48 	PAYMENT_PRIORITY		NUMBER,
49 	INVOICE_CURRENCY_CODE		AP_SUPPLIERS.INVOICE_CURRENCY_CODE%TYPE,
50 	PAYMENT_CURRENCY_CODE		AP_SUPPLIERS.PAYMENT_CURRENCY_CODE%TYPE,
51 	INVOICE_AMOUNT_LIMIT		NUMBER,
52 	HOLD_ALL_PAYMENTS_FLAG		AP_SUPPLIERS.HOLD_ALL_PAYMENTS_FLAG%TYPE,
53 	HOLD_FUTURE_PAYMENTS_FLAG 	AP_SUPPLIERS.HOLD_FUTURE_PAYMENTS_FLAG%TYPE,
54 	HOLD_REASON			AP_SUPPLIERS.HOLD_REASON%TYPE,
55 	TYPE_1099			AP_SUPPLIERS.TYPE_1099%TYPE,
56 	WITHHOLDING_STATUS_LOOKUP_CODE	AP_SUPPLIERS.WITHHOLDING_STATUS_LOOKUP_CODE%TYPE,
57 	WITHHOLDING_START_DATE		AP_SUPPLIERS.WITHHOLDING_START_DATE%TYPE,
58 	ORGANIZATION_TYPE_LOOKUP_CODE	AP_SUPPLIERS.ORGANIZATION_TYPE_LOOKUP_CODE%TYPE,
59 	START_DATE_ACTIVE		AP_SUPPLIERS.START_DATE_ACTIVE%TYPE,
60 	END_DATE_ACTIVE			AP_SUPPLIERS.END_DATE_ACTIVE%TYPE,
61 	MINORITY_GROUP_LOOKUP_CODE	AP_SUPPLIERS.MINORITY_GROUP_LOOKUP_CODE%TYPE,
62 	WOMEN_OWNED_FLAG		AP_SUPPLIERS.WOMEN_OWNED_FLAG%TYPE,
63 	SMALL_BUSINESS_FLAG		AP_SUPPLIERS.SMALL_BUSINESS_FLAG%TYPE,
64 	HOLD_FLAG			AP_SUPPLIERS.HOLD_FLAG%TYPE,
65 	PURCHASING_HOLD_REASON		AP_SUPPLIERS.PURCHASING_HOLD_REASON%TYPE,
66 	HOLD_BY				NUMBER,
67 	HOLD_DATE			AP_SUPPLIERS.HOLD_DATE%TYPE,
68 	TERMS_DATE_BASIS		AP_SUPPLIERS.TERMS_DATE_BASIS%TYPE,
69 	INSPECTION_REQUIRED_FLAG	AP_SUPPLIERS.INSPECTION_REQUIRED_FLAG%TYPE,
70 	RECEIPT_REQUIRED_FLAG		AP_SUPPLIERS.RECEIPT_REQUIRED_FLAG%TYPE,
71 	QTY_RCV_TOLERANCE		NUMBER,
72 	QTY_RCV_EXCEPTION_CODE		AP_SUPPLIERS.QTY_RCV_EXCEPTION_CODE%TYPE,
73 	ENFORCE_SHIP_TO_LOCATION_CODE	AP_SUPPLIERS.ENFORCE_SHIP_TO_LOCATION_CODE%TYPE,
74 	DAYS_EARLY_RECEIPT_ALLOWED	NUMBER,
75 	DAYS_LATE_RECEIPT_ALLOWED       NUMBER,
76 	RECEIPT_DAYS_EXCEPTION_CODE	AP_SUPPLIERS.RECEIPT_DAYS_EXCEPTION_CODE%TYPE,
77 	RECEIVING_ROUTING_ID		NUMBER,
78 	ALLOW_SUBSTITUTE_RECEIPTS_FLAG	AP_SUPPLIERS.ALLOW_SUBSTITUTE_RECEIPTS_FLAG%TYPE,
79 	ALLOW_UNORDERED_RECEIPTS_FLAG	AP_SUPPLIERS.ALLOW_UNORDERED_RECEIPTS_FLAG%TYPE,
80 	HOLD_UNMATCHED_INVOICES_FLAG	AP_SUPPLIERS.HOLD_UNMATCHED_INVOICES_FLAG%TYPE,
81 	TAX_VERIFICATION_DATE		AP_SUPPLIERS.TAX_VERIFICATION_DATE%TYPE,
82 	NAME_CONTROL			AP_SUPPLIERS.NAME_CONTROL%TYPE,
83 	STATE_REPORTABLE_FLAG		AP_SUPPLIERS.STATE_REPORTABLE_FLAG%TYPE,
84 	FEDERAL_REPORTABLE_FLAG		AP_SUPPLIERS.FEDERAL_REPORTABLE_FLAG%TYPE,
85 	ATTRIBUTE_CATEGORY		AP_SUPPLIERS.ATTRIBUTE_CATEGORY%TYPE,
86 	ATTRIBUTE1			AP_SUPPLIERS.ATTRIBUTE1%TYPE,
87 	ATTRIBUTE2			AP_SUPPLIERS.ATTRIBUTE2%TYPE,
88 	ATTRIBUTE3			AP_SUPPLIERS.ATTRIBUTE3%TYPE,
89 	ATTRIBUTE4			AP_SUPPLIERS.ATTRIBUTE4%TYPE,
90 	ATTRIBUTE5			AP_SUPPLIERS.ATTRIBUTE5%TYPE,
91 	ATTRIBUTE6			AP_SUPPLIERS.ATTRIBUTE6%TYPE,
92 	ATTRIBUTE7			AP_SUPPLIERS.ATTRIBUTE7%TYPE,
93 	ATTRIBUTE8			AP_SUPPLIERS.ATTRIBUTE8%TYPE,
94 	ATTRIBUTE9			AP_SUPPLIERS.ATTRIBUTE9%TYPE,
95 	ATTRIBUTE10			AP_SUPPLIERS.ATTRIBUTE10%TYPE,
96 	ATTRIBUTE11			AP_SUPPLIERS.ATTRIBUTE11%TYPE,
97 	ATTRIBUTE12			AP_SUPPLIERS.ATTRIBUTE12%TYPE,
98 	ATTRIBUTE13			AP_SUPPLIERS.ATTRIBUTE13%TYPE,
99 	ATTRIBUTE14			AP_SUPPLIERS.ATTRIBUTE14%TYPE,
100 	ATTRIBUTE15			AP_SUPPLIERS.ATTRIBUTE15%TYPE,
101 	AUTO_CALCULATE_INTEREST_FLAG	AP_SUPPLIERS.AUTO_CALCULATE_INTEREST_FLAG%TYPE,
102 	VALIDATION_NUMBER		NUMBER,
103 	EXCLUDE_FREIGHT_FROM_DISCOUNT	AP_SUPPLIERS.EXCLUDE_FREIGHT_FROM_DISCOUNT%TYPE,
104 	TAX_REPORTING_NAME		AP_SUPPLIERS.TAX_REPORTING_NAME%TYPE,
105 	CHECK_DIGITS			AP_SUPPLIERS.CHECK_DIGITS%TYPE,
106 	ALLOW_AWT_FLAG			AP_SUPPLIERS.ALLOW_AWT_FLAG%TYPE,
107 	AWT_GROUP_ID			NUMBER,
108 	AWT_GROUP_NAME			AP_AWT_GROUPS.NAME%TYPE,
109         PAY_AWT_GROUP_ID                NUMBER,                 --bug6664407
110         PAY_AWT_GROUP_NAME              AP_AWT_GROUPS.NAME%TYPE,--bug6664407
111 	GLOBAL_ATTRIBUTE1 		AP_SUPPLIERS.GLOBAL_ATTRIBUTE1%TYPE,
112 	GLOBAL_ATTRIBUTE2		AP_SUPPLIERS.GLOBAL_ATTRIBUTE2%TYPE,
113 	GLOBAL_ATTRIBUTE3		AP_SUPPLIERS.GLOBAL_ATTRIBUTE3%TYPE,
114 	GLOBAL_ATTRIBUTE4		AP_SUPPLIERS.GLOBAL_ATTRIBUTE4%TYPE,
115 	GLOBAL_ATTRIBUTE5		AP_SUPPLIERS.GLOBAL_ATTRIBUTE5%TYPE,
116 	GLOBAL_ATTRIBUTE6		AP_SUPPLIERS.GLOBAL_ATTRIBUTE6%TYPE,
117 	GLOBAL_ATTRIBUTE7 		AP_SUPPLIERS.GLOBAL_ATTRIBUTE7%TYPE,
118 	GLOBAL_ATTRIBUTE8		AP_SUPPLIERS.GLOBAL_ATTRIBUTE8%TYPE,
119 	GLOBAL_ATTRIBUTE9		AP_SUPPLIERS.GLOBAL_ATTRIBUTE9%TYPE,
120 	GLOBAL_ATTRIBUTE10		AP_SUPPLIERS.GLOBAL_ATTRIBUTE10%TYPE,
121 	GLOBAL_ATTRIBUTE11		AP_SUPPLIERS.GLOBAL_ATTRIBUTE11%TYPE,
122 	GLOBAL_ATTRIBUTE12		AP_SUPPLIERS.GLOBAL_ATTRIBUTE12%TYPE,
123 	GLOBAL_ATTRIBUTE13		AP_SUPPLIERS.GLOBAL_ATTRIBUTE13%TYPE,
124 	GLOBAL_ATTRIBUTE14		AP_SUPPLIERS.GLOBAL_ATTRIBUTE14%TYPE,
125 	GLOBAL_ATTRIBUTE15		AP_SUPPLIERS.GLOBAL_ATTRIBUTE15%TYPE,
126 	GLOBAL_ATTRIBUTE16		AP_SUPPLIERS.GLOBAL_ATTRIBUTE16%TYPE,
127 	GLOBAL_ATTRIBUTE17		AP_SUPPLIERS.GLOBAL_ATTRIBUTE17%TYPE,
128 	GLOBAL_ATTRIBUTE18		AP_SUPPLIERS.GLOBAL_ATTRIBUTE18%TYPE,
129 	GLOBAL_ATTRIBUTE19		AP_SUPPLIERS.GLOBAL_ATTRIBUTE19%TYPE,
130 	GLOBAL_ATTRIBUTE20		AP_SUPPLIERS.GLOBAL_ATTRIBUTE20%TYPE,
131 	GLOBAL_ATTRIBUTE_CATEGORY	AP_SUPPLIERS.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,
132 	BANK_CHARGE_BEARER		AP_SUPPLIERS.BANK_CHARGE_BEARER%TYPE,
133 	MATCH_OPTION			AP_SUPPLIERS.MATCH_OPTION%TYPE,
134 	CREATE_DEBIT_MEMO_FLAG		AP_SUPPLIERS.CREATE_DEBIT_MEMO_FLAG%TYPE,
135 	PARTY_ID			NUMBER,
136 	PARENT_PARTY_ID			NUMBER,
137         JGZZ_FISCAL_CODE                VARCHAR2(20),
138         SIC_CODE                        VARCHAR2(30),
139         TAX_REFERENCE                   VARCHAR2(50),
140 	INVENTORY_ORGANIZATION_ID	NUMBER,
141 	TERMS_NAME			AP_TERMS_TL.NAME%TYPE,
142 	DEFAULT_TERMS_ID		NUMBER,
143     	VENDOR_INTERFACE_ID		NUMBER,
144 	NI_NUMBER			AP_SUPPLIERS.NI_NUMBER%TYPE,
145 	EXT_PAYEE_REC			IBY_DISBURSEMENT_SETUP_PUB.EXTERNAL_PAYEE_REC_TYPE,
146 	-- Bug 7437549 Start
147         EDI_PAYMENT_FORMAT         AP_SUPPLIERS_INT.EDI_PAYMENT_FORMAT%TYPE,
148         EDI_TRANSACTION_HANDLING   AP_SUPPLIERS_INT.EDI_TRANSACTION_HANDLING%TYPE,
149         EDI_PAYMENT_METHOD         AP_SUPPLIERS_INT.EDI_PAYMENT_METHOD%TYPE,
150         EDI_REMITTANCE_METHOD      AP_SUPPLIERS_INT.EDI_REMITTANCE_METHOD%TYPE,
151         EDI_REMITTANCE_INSTRUCTION AP_SUPPLIERS_INT.EDI_REMITTANCE_INSTRUCTION%TYPE
152         -- Bug 7437549 End
153 	,URL                            HZ_CONTACT_POINTS.URL%TYPE,	-- B# 7831956
154 	-- B# 7583123
155 	SUPPLIER_NOTIF_METHOD		AP_SUPPLIERS_INT.SUPPLIER_NOTIF_METHOD%TYPE,
156 	REMITTANCE_EMAIL                AP_SUPPLIERS_INT.REMITTANCE_EMAIL%TYPE
157 	,CEO_NAME                       AP_SUPPLIERS_INT.CEO_NAME%TYPE	-- B# 9081643
158 	,CEO_TITLE                      AP_SUPPLIERS_INT.CEO_TITLE%TYPE	-- B# 9081643
159         ,VAT_CODE                       AP_SUPPLIERS.VAT_CODE%TYPE             -- B#9202909
160         ,AUTO_TAX_CALC_FLAG             AP_SUPPLIERS.AUTO_TAX_CALC_FLAG%TYPE   -- B#9202909
161         ,OFFSET_TAX_FLAG                AP_SUPPLIERS_INT.OFFSET_TAX_FLAG%TYPE  -- B#9202909
162 	,VAT_REGISTRATION_NUM		AP_SUPPLIERS_INT.VAT_REGISTRATION_NUM%TYPE -- B#9202909
163 	);
164 
165 TYPE r_vendor_site_rec_type IS RECORD(
166 	AREA_CODE			AP_SUPPLIER_SITES_ALL.AREA_CODE%TYPE,
167 	PHONE				AP_SUPPLIER_SITES_ALL.PHONE%TYPE,
168 	CUSTOMER_NUM			AP_SUPPLIER_SITES_ALL.CUSTOMER_NUM%TYPE,
169 	SHIP_TO_LOCATION_ID		NUMBER,
170 	BILL_TO_LOCATION_ID		NUMBER,
171 	SHIP_VIA_LOOKUP_CODE		AP_SUPPLIER_SITES_ALL.SHIP_VIA_LOOKUP_CODE%TYPE,
172 	FREIGHT_TERMS_LOOKUP_CODE	AP_SUPPLIER_SITES_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE,
173 	FOB_LOOKUP_CODE			AP_SUPPLIER_SITES_ALL.FOB_LOOKUP_CODE%TYPE,
174 	INACTIVE_DATE			AP_SUPPLIER_SITES_ALL.INACTIVE_DATE%TYPE,
175 	FAX				AP_SUPPLIER_SITES_ALL.FAX	%TYPE,
176 	FAX_AREA_CODE			AP_SUPPLIER_SITES_ALL.FAX_AREA_CODE%TYPE,
177 	TELEX				AP_SUPPLIER_SITES_ALL.TELEX%TYPE,
178 	TERMS_DATE_BASIS		AP_SUPPLIER_SITES_ALL.TERMS_DATE_BASIS%TYPE,
179 	DISTRIBUTION_SET_ID		NUMBER,
180 	ACCTS_PAY_CODE_COMBINATION_ID	NUMBER,
181 	PREPAY_CODE_COMBINATION_ID	NUMBER,
182 	PAY_GROUP_LOOKUP_CODE		AP_SUPPLIER_SITES_ALL.PAY_GROUP_LOOKUP_CODE%TYPE,
183 	PAYMENT_PRIORITY		NUMBER,
184 	TERMS_ID			NUMBER,
185 	INVOICE_AMOUNT_LIMIT		AP_SUPPLIER_SITES_ALL.INVOICE_AMOUNT_LIMIT%TYPE,
186 	PAY_DATE_BASIS_LOOKUP_CODE	AP_SUPPLIER_SITES_ALL.PAY_DATE_BASIS_LOOKUP_CODE%TYPE,
187 	ALWAYS_TAKE_DISC_FLAG		AP_SUPPLIER_SITES_ALL.ALWAYS_TAKE_DISC_FLAG%TYPE,
188 	INVOICE_CURRENCY_CODE		AP_SUPPLIER_SITES_ALL.INVOICE_CURRENCY_CODE%TYPE,
189 	PAYMENT_CURRENCY_CODE		AP_SUPPLIER_SITES_ALL.PAYMENT_CURRENCY_CODE%TYPE,
190 	VENDOR_SITE_ID			NUMBER,
191 	LAST_UPDATE_DATE		AP_SUPPLIER_SITES_ALL.LAST_UPDATE_DATE%TYPE,
192 	LAST_UPDATED_BY			AP_SUPPLIER_SITES_ALL.LAST_UPDATED_BY%TYPE,
193 	VENDOR_ID		        NUMBER,
194 	VENDOR_SITE_CODE		AP_SUPPLIER_SITES_ALL.VENDOR_SITE_CODE%TYPE,
195 	VENDOR_SITE_CODE_ALT		AP_SUPPLIER_SITES_ALL.VENDOR_SITE_CODE_ALT%TYPE,
196 	PURCHASING_SITE_FLAG		AP_SUPPLIER_SITES_ALL.PURCHASING_SITE_FLAG%TYPE,
197 	RFQ_ONLY_SITE_FLAG		AP_SUPPLIER_SITES_ALL.RFQ_ONLY_SITE_FLAG%TYPE,
198 	PAY_SITE_FLAG			AP_SUPPLIER_SITES_ALL.PAY_SITE_FLAG%TYPE,
199 	ATTENTION_AR_FLAG		AP_SUPPLIER_SITES_ALL.ATTENTION_AR_FLAG%TYPE,
200 	HOLD_ALL_PAYMENTS_FLAG		AP_SUPPLIER_SITES_ALL.HOLD_ALL_PAYMENTS_FLAG%TYPE,
201 	HOLD_FUTURE_PAYMENTS_FLAG	AP_SUPPLIER_SITES_ALL.HOLD_FUTURE_PAYMENTS_FLAG%TYPE,
202 	HOLD_REASON			AP_SUPPLIER_SITES_ALL.HOLD_REASON%TYPE,
203 	HOLD_UNMATCHED_INVOICES_FLAG	AP_SUPPLIER_SITES_ALL.HOLD_UNMATCHED_INVOICES_FLAG%TYPE,
204 	TAX_REPORTING_SITE_FLAG		AP_SUPPLIER_SITES_ALL.TAX_REPORTING_SITE_FLAG%TYPE,
205 	ATTRIBUTE_CATEGORY		AP_SUPPLIER_SITES_ALL.ATTRIBUTE_CATEGORY%TYPE,
206 	ATTRIBUTE1			AP_SUPPLIER_SITES_ALL.ATTRIBUTE1%TYPE,
207 	ATTRIBUTE2			AP_SUPPLIER_SITES_ALL.ATTRIBUTE2%TYPE,
208 	ATTRIBUTE3			AP_SUPPLIER_SITES_ALL.ATTRIBUTE3%TYPE,
209 	ATTRIBUTE4			AP_SUPPLIER_SITES_ALL.ATTRIBUTE4%TYPE,
210 	ATTRIBUTE5			AP_SUPPLIER_SITES_ALL.ATTRIBUTE5%TYPE,
211 	ATTRIBUTE6			AP_SUPPLIER_SITES_ALL.ATTRIBUTE6%TYPE,
212 	ATTRIBUTE7			AP_SUPPLIER_SITES_ALL.ATTRIBUTE7%TYPE,
213 	ATTRIBUTE8			AP_SUPPLIER_SITES_ALL.ATTRIBUTE8%TYPE,
214 	ATTRIBUTE9			AP_SUPPLIER_SITES_ALL.ATTRIBUTE9%TYPE,
215 	ATTRIBUTE10			AP_SUPPLIER_SITES_ALL.ATTRIBUTE10%TYPE,
216 	ATTRIBUTE11			AP_SUPPLIER_SITES_ALL.ATTRIBUTE11%TYPE,
217 	ATTRIBUTE12			AP_SUPPLIER_SITES_ALL.ATTRIBUTE12%TYPE,
218 	ATTRIBUTE13			AP_SUPPLIER_SITES_ALL.ATTRIBUTE13%TYPE,
219 	ATTRIBUTE14			AP_SUPPLIER_SITES_ALL.ATTRIBUTE14%TYPE,
220 	ATTRIBUTE15			AP_SUPPLIER_SITES_ALL.ATTRIBUTE15%TYPE,
221 	VALIDATION_NUMBER	        NUMBER,
222 	EXCLUDE_FREIGHT_FROM_DISCOUNT	AP_SUPPLIER_SITES_ALL.EXCLUDE_FREIGHT_FROM_DISCOUNT%TYPE,
223 	BANK_CHARGE_BEARER		AP_SUPPLIER_SITES_ALL.BANK_CHARGE_BEARER%TYPE,
224 	ORG_ID				NUMBER,
225 	CHECK_DIGITS			AP_SUPPLIER_SITES_ALL.CHECK_DIGITS%TYPE,
226 	ALLOW_AWT_FLAG			AP_SUPPLIER_SITES_ALL.ALLOW_AWT_FLAG%TYPE,
227 	AWT_GROUP_ID			NUMBER,
228         PAY_AWT_GROUP_ID                NUMBER,                 --bug6664407
229 	DEFAULT_PAY_SITE_ID		NUMBER,
230 	PAY_ON_CODE			AP_SUPPLIER_SITES_ALL.PAY_ON_CODE%TYPE,
231 	PAY_ON_RECEIPT_SUMMARY_CODE	AP_SUPPLIER_SITES_ALL.PAY_ON_RECEIPT_SUMMARY_CODE%TYPE,
232 	GLOBAL_ATTRIBUTE_CATEGORY	AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,
233 	GLOBAL_ATTRIBUTE1		AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE1%TYPE,
234 	GLOBAL_ATTRIBUTE2		AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE2%TYPE,
235 	GLOBAL_ATTRIBUTE3		AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE3%TYPE,
236 	GLOBAL_ATTRIBUTE4		AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE4%TYPE,
237 	GLOBAL_ATTRIBUTE5		AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE5%TYPE,
238 	GLOBAL_ATTRIBUTE6		AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE6%TYPE,
239 	GLOBAL_ATTRIBUTE7		AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE7%TYPE,
240 	GLOBAL_ATTRIBUTE8		AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE8%TYPE,
241 	GLOBAL_ATTRIBUTE9		AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE9%TYPE,
242 	GLOBAL_ATTRIBUTE10		AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE10%TYPE,
243 	GLOBAL_ATTRIBUTE11		AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE11%TYPE,
244 	GLOBAL_ATTRIBUTE12		AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE12%TYPE,
245 	GLOBAL_ATTRIBUTE13		AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE13%TYPE,
246 	GLOBAL_ATTRIBUTE14		AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE14%TYPE,
247 	GLOBAL_ATTRIBUTE15		AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE15%TYPE,
248 	GLOBAL_ATTRIBUTE16		AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE16%TYPE,
249 	GLOBAL_ATTRIBUTE17		AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE17%TYPE,
250 	GLOBAL_ATTRIBUTE18		AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE18%TYPE,
251 	GLOBAL_ATTRIBUTE19		AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE19%TYPE,
252 	GLOBAL_ATTRIBUTE20		AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE20%TYPE,
253 	TP_HEADER_ID			NUMBER,
254 	ECE_TP_LOCATION_CODE		AP_SUPPLIER_SITES_ALL.ECE_TP_LOCATION_CODE%TYPE,
255 	PCARD_SITE_FLAG			AP_SUPPLIER_SITES_ALL.PCARD_SITE_FLAG%TYPE,
256 	MATCH_OPTION			AP_SUPPLIER_SITES_ALL.MATCH_OPTION%TYPE,
257 	COUNTRY_OF_ORIGIN_CODE		AP_SUPPLIER_SITES_ALL.COUNTRY_OF_ORIGIN_CODE%TYPE,
258 	FUTURE_DATED_PAYMENT_CCID	NUMBER,
259 	CREATE_DEBIT_MEMO_FLAG		AP_SUPPLIER_SITES_ALL.CREATE_DEBIT_MEMO_FLAG%TYPE,
260 	SUPPLIER_NOTIF_METHOD		AP_SUPPLIER_SITES_ALL.SUPPLIER_NOTIF_METHOD%TYPE,
261 	EMAIL_ADDRESS			AP_SUPPLIER_SITES_ALL.EMAIL_ADDRESS%TYPE,
262 	PRIMARY_PAY_SITE_FLAG		AP_SUPPLIER_SITES_ALL.PRIMARY_PAY_SITE_FLAG%TYPE,
263 	SHIPPING_CONTROL		AP_SUPPLIER_SITES_ALL.SHIPPING_CONTROL%TYPE,
264 	SELLING_COMPANY_IDENTIFIER	AP_SUPPLIER_SITES_ALL.SELLING_COMPANY_IDENTIFIER%TYPE,
265 	GAPLESS_INV_NUM_FLAG		AP_SUPPLIER_SITES_ALL.GAPLESS_INV_NUM_FLAG%TYPE,
266 	LOCATION_ID			NUMBER,
267 	PARTY_SITE_ID			NUMBER,
268 	ORG_NAME			HR_OPERATING_UNITS.NAME%TYPE,
269         DUNS_NUMBER     		AP_SUPPLIER_SITES_ALL.DUNS_NUMBER%TYPE,
270         ADDRESS_STYLE   		AP_SUPPLIER_SITES_ALL.ADDRESS_STYLE%TYPE,
271         LANGUAGE        		AP_SUPPLIER_SITES_ALL.LANGUAGE%TYPE,
272         PROVINCE        		AP_SUPPLIER_SITES_ALL.PROVINCE%TYPE,
273         COUNTRY         		AP_SUPPLIER_SITES_ALL.COUNTRY%TYPE,
274         ADDRESS_LINE1   		AP_SUPPLIER_SITES_ALL.ADDRESS_LINE1%TYPE,
275         ADDRESS_LINE2   		AP_SUPPLIER_SITES_ALL.ADDRESS_LINE2%TYPE,
276         ADDRESS_LINE3   		AP_SUPPLIER_SITES_ALL.ADDRESS_LINE3%TYPE,
277         ADDRESS_LINE4   		AP_SUPPLIER_SITES_ALL.ADDRESS_LINE4%TYPE,
278         ADDRESS_LINES_ALT       	AP_SUPPLIER_SITES_ALL.ADDRESS_LINES_ALT%TYPE,
279         COUNTY          		AP_SUPPLIER_SITES_ALL.COUNTY%TYPE,
280         CITY            		AP_SUPPLIER_SITES_ALL.CITY%TYPE,
281         STATE           		AP_SUPPLIER_SITES_ALL.STATE%TYPE,
282         ZIP             		AP_SUPPLIER_SITES_ALL.ZIP%TYPE,
283        	TERMS_NAME			AP_TERMS_TL.NAME%TYPE,
284 	DEFAULT_TERMS_ID		NUMBER,
285 	AWT_GROUP_NAME			AP_AWT_GROUPS.NAME%TYPE,
286         PAY_AWT_GROUP_NAME              AP_AWT_GROUPS.NAME%TYPE,--bug6664407
287         DISTRIBUTION_SET_NAME		AP_DISTRIBUTION_SETS_ALL.DISTRIBUTION_SET_NAME%TYPE,
288         SHIP_TO_LOCATION_CODE           HR_LOCATIONS_ALL_TL.LOCATION_CODE%TYPE,
289         BILL_TO_LOCATION_CODE           HR_LOCATIONS_ALL_TL.LOCATION_CODE%TYPE,
290     	DEFAULT_DIST_SET_ID             NUMBER,
291         DEFAULT_SHIP_TO_LOC_ID          NUMBER,
292         DEFAULT_BILL_TO_LOC_ID          NUMBER,
293 	TOLERANCE_ID			NUMBER,
294 	TOLERANCE_NAME			AP_TOLERANCE_TEMPLATES.TOLERANCE_NAME%TYPE,
295     	VENDOR_INTERFACE_ID		NUMBER,
296     	VENDOR_SITE_INTERFACE_ID	NUMBER,
297         EXT_PAYEE_REC			IBY_DISBURSEMENT_SETUP_PUB.EXTERNAL_PAYEE_REC_TYPE,
298 	RETAINAGE_RATE			NUMBER DEFAULT NULL,
299         SERVICES_TOLERANCE_ID           NUMBER,
300         SERVICES_TOLERANCE_NAME         AP_TOLERANCE_TEMPLATES.TOLERANCE_NAME%TYPE,
301         SHIPPING_LOCATION_ID            NUMBER,
302         VAT_CODE                        AP_SUPPLIER_SITES_ALL.VAT_CODE%TYPE,
303 	VAT_REGISTRATION_NUM		AP_SUPPLIER_SITES_INT.VAT_REGISTRATION_NUM%TYPE, -- Bug 7197036
304 	REMITTANCE_EMAIL		AP_SUPPLIER_SITES_INT.REMITTANCE_EMAIL%TYPE, -- Bug 7339389
305 	-- Bug 7437549 Start
306         EDI_ID_NUMBER              AP_SUPPLIER_SITES_INT.EDI_ID_NUMBER%TYPE,
307         EDI_PAYMENT_FORMAT         AP_SUPPLIER_SITES_INT.EDI_PAYMENT_FORMAT%TYPE,
308         EDI_TRANSACTION_HANDLING   AP_SUPPLIER_SITES_INT.EDI_TRANSACTION_HANDLING%TYPE,
309         EDI_PAYMENT_METHOD         AP_SUPPLIER_SITES_INT.EDI_PAYMENT_METHOD%TYPE,
310         EDI_REMITTANCE_METHOD      AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_METHOD%TYPE,
311         EDI_REMITTANCE_INSTRUCTION AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_INSTRUCTION%TYPE,
312         -- Bug 7437549 End
313         PARTY_SITE_NAME            HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE, -- Bug 7429668
314         OFFSET_TAX_FLAG             AP_SUPPLIER_SITES_INT.OFFSET_TAX_FLAG%TYPE, -- Bug#7506443
315         AUTO_TAX_CALC_FLAG          AP_SUPPLIER_SITES_INT.AUTO_TAX_CALC_FLAG%TYPE -- Bug#7506443
316 	,REMIT_ADVICE_DELIVERY_METHOD AP_SUPPLIER_SITES_INT.REMIT_ADVICE_DELIVERY_METHOD%TYPE  -- Bug 8422781
317 	,REMIT_ADVICE_FAX           AP_SUPPLIER_SITES_INT.REMIT_ADVICE_FAX%TYPE -- Bug 8769088
318   -- starting the Changes for CLM reference data management bug#9499174
319 	,CAGE_CODE                     AP_SUPPLIER_SITES_ALL.CAGE_CODE%TYPE ,
320         LEGAL_BUSINESS_NAME            AP_SUPPLIER_SITES_ALL.LEGAL_BUSINESS_NAME%TYPE ,
321         DOING_BUS_AS_NAME              AP_SUPPLIER_SITES_ALL.DOING_BUS_AS_NAME%TYPE ,
322         DIVISION_NAME                  AP_SUPPLIER_SITES_ALL.DIVISION_NAME%TYPE ,
323         SMALL_BUSINESS_CODE            AP_SUPPLIER_SITES_ALL.SMALL_BUSINESS_CODE%TYPE ,
324         CCR_COMMENTS                   AP_SUPPLIER_SITES_ALL.CCR_COMMENTS%TYPE ,
325         DEBARMENT_START_DATE           AP_SUPPLIER_SITES_ALL.DEBARMENT_START_DATE%TYPE ,
326         DEBARMENT_END_DATE             AP_SUPPLIER_SITES_ALL.DEBARMENT_END_DATE%TYPE
327 	,AP_TAX_ROUNDING_RULE		ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE /* Bug 9530837 */
328 	,AMOUNT_INCLUDES_TAX_FLAG	ZX_PARTY_TAX_PROFILE.INCLUSIVE_TAX_FLAG%TYPE /* Bug 9530837 */
329 	);
330   -- Ending the Changes for CLM reference data management bug#9499174
331 -- VAT_CODE ADDED TO ABOVE STRUCTURE Bug 6645014
332 -- To Import the VAT Code in Sites.
333 
334 -- bug 6745669 - added attribute_category to vendor contact record
335 
336 TYPE r_vendor_contact_rec_type IS RECORD(
337 	VENDOR_CONTACT_ID		NUMBER,
338 	VENDOR_SITE_ID			NUMBER,
339 	VENDOR_ID       		NUMBER,
340  	PER_PARTY_ID			NUMBER,
341  	RELATIONSHIP_ID			NUMBER,
342  	REL_PARTY_ID			NUMBER,
343  	PARTY_SITE_ID			NUMBER,
344  	ORG_CONTACT_ID			NUMBER,
345 	ORG_PARTY_SITE_ID		NUMBER,
346 	PERSON_FIRST_NAME		AP_SUPPLIER_CONTACTS.FIRST_NAME%TYPE,
347 	PERSON_MIDDLE_NAME		AP_SUPPLIER_CONTACTS.MIDDLE_NAME%TYPE,
348 	PERSON_LAST_NAME		AP_SUPPLIER_CONTACTS.LAST_NAME%TYPE,
349 	PERSON_TITLE			AP_SUPPLIER_CONTACTS.TITLE%TYPE,
350 	ORGANIZATION_NAME_PHONETIC	VARCHAR2(320),
351 	PERSON_FIRST_NAME_PHONETIC	AP_SUPPLIER_CONTACTS.FIRST_NAME_ALT%TYPE,
352 	PERSON_LAST_NAME_PHONETIC	AP_SUPPLIER_CONTACTS.LAST_NAME_ALT%TYPE,
353 	ATTRIBUTE_CATEGORY			AP_SUPPLIER_CONTACTS.ATTRIBUTE_CATEGORY%TYPE,
354 	ATTRIBUTE1			AP_SUPPLIER_CONTACTS.ATTRIBUTE1%TYPE,
355 	ATTRIBUTE2			AP_SUPPLIER_CONTACTS.ATTRIBUTE2%TYPE,
356 	ATTRIBUTE3			AP_SUPPLIER_CONTACTS.ATTRIBUTE3%TYPE,
357 	ATTRIBUTE4			AP_SUPPLIER_CONTACTS.ATTRIBUTE4%TYPE,
358 	ATTRIBUTE5			AP_SUPPLIER_CONTACTS.ATTRIBUTE5%TYPE,
359 	ATTRIBUTE6			AP_SUPPLIER_CONTACTS.ATTRIBUTE6%TYPE,
360 	ATTRIBUTE7			AP_SUPPLIER_CONTACTS.ATTRIBUTE7%TYPE,
361 	ATTRIBUTE8			AP_SUPPLIER_CONTACTS.ATTRIBUTE8%TYPE,
362 	ATTRIBUTE9			AP_SUPPLIER_CONTACTS.ATTRIBUTE9%TYPE,
363 	ATTRIBUTE10			AP_SUPPLIER_CONTACTS.ATTRIBUTE10%TYPE,
364 	ATTRIBUTE11			AP_SUPPLIER_CONTACTS.ATTRIBUTE11%TYPE,
365 	ATTRIBUTE12			AP_SUPPLIER_CONTACTS.ATTRIBUTE12%TYPE,
366 	ATTRIBUTE13			AP_SUPPLIER_CONTACTS.ATTRIBUTE13%TYPE,
367 	ATTRIBUTE14			AP_SUPPLIER_CONTACTS.ATTRIBUTE14%TYPE,
368 	ATTRIBUTE15			AP_SUPPLIER_CONTACTS.ATTRIBUTE15%TYPE,
369 	INACTIVE_DATE			AP_SUPPLIER_CONTACTS.INACTIVE_DATE%TYPE,
370 	PARTY_NUMBER			VARCHAR2(30),
371 	DEPARTMENT			AP_SUPPLIER_CONTACTS.DEPARTMENT%TYPE,
372 	MAIL_STOP			AP_SUPPLIER_CONTACTS.MAIL_STOP%TYPE,
373 	AREA_CODE			AP_SUPPLIER_CONTACTS.AREA_CODE%TYPE,
374 	PHONE				AP_SUPPLIER_CONTACTS.PHONE%TYPE,
375 	ALT_AREA_CODE			AP_SUPPLIER_CONTACTS.ALT_AREA_CODE%TYPE,
376 	ALT_PHONE			AP_SUPPLIER_CONTACTS.ALT_PHONE%TYPE,
377 	FAX_AREA_CODE			AP_SUPPLIER_CONTACTS.FAX_AREA_CODE%TYPE,
378 	FAX_PHONE			AP_SUPPLIER_CONTACTS.FAX%TYPE,
379 	EMAIL_ADDRESS			AP_SUPPLIER_CONTACTS.EMAIL_ADDRESS%TYPE,
380 	URL				AP_SUPPLIER_CONTACTS.URL%TYPE,
381         VENDOR_CONTACT_INTERFACE_ID	NUMBER,
382         VENDOR_INTERFACE_ID		NUMBER,
383         VENDOR_SITE_CODE		AP_SUP_SITE_CONTACT_INT.VENDOR_SITE_CODE%TYPE,
384         ORG_ID				NUMBER,
385         OPERATING_UNIT_NAME		AP_SUP_SITE_CONTACT_INT.OPERATING_UNIT_NAME%TYPE,
386         PREFIX				AP_SUP_SITE_CONTACT_INT.PREFIX%TYPE,
387         CONTACT_NAME_PHONETIC		AP_SUP_SITE_CONTACT_INT.CONTACT_NAME_ALT%TYPE,
388 	PARTY_SITE_NAME  HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE -- Bug 7013954
389         );
390 
391 
392 -- Start of comments
393 --	API name 	: Create_Vendor
394 --	Type		: Public
395 --	Function	:
396 --	Pre-reqs	: None.
397 --	Parameters	:
398 --	IN		:	p_api_version IN NUMBER  Required
399 --				p_init_msg_list	IN VARCHAR2 	Optional
400 --					Default = FND_API.G_FALSE
401 --				p_commit IN VARCHAR2 Optional
402 --					Default = FND_API.G_FALSE
403 --				p_validation_level IN NUMBER Optional
404 --					Default = FND_API.G_VALID_LEVEL_FULL
405 --				parameter1
406 --				parameter2
407 --				.
408 --				.
409 --	OUT		:	x_return_status		OUT	VARCHAR2(1)
410 --				x_msg_count		OUT	NUMBER
411 --				x_msg_data		OUT     VARCHAR2(2000)
412 --				parameter1
413 --				parameter2
414 --				.
415 --				.
416 --	Version		: Current version	1.0
417 --			  Initial version 	1.0
418 --
419 --	Notes		: Vendor API, called from various features and other
420 --			  products, to create new vendors
421 --
422 -- End of comments
423 -- Bug 7553276 Added annotation for integration repository.
424 /*#
425  * This procedure is used to create Supplier in Payables and populate other
426  * internal tables with supplier information.
427  * @param p_api_version The version of the API
428  * @param p_init_msg_list The initialize message list
429  * @param p_commit The Commit flag
430  * @param p_validation_level The validation level
431  * @param x_return_status The return status
432  * @param x_msg_count The message count
433  * @param x_msg_data The message data
434  * @param p_vendor_rec The Supplier record
435  * @param x_vendor_id The Supplier Identifier
436  * @param x_party_id The Party Identifier
437  * @rep:scope public
438  * @rep:lifecycle active
439  * @rep:displayname Create Supplier
440  * @rep:category BUSINESS_ENTITY AP_SUPPLIER
441  */
442 PROCEDURE Create_Vendor
443 ( 	p_api_version           IN	NUMBER,
444   	p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE,
445 	p_commit	    	IN  	VARCHAR2 := FND_API.G_FALSE,
446 	p_validation_level	IN  	NUMBER	 := FND_API.G_VALID_LEVEL_FULL,
447 	x_return_status		OUT	NOCOPY  VARCHAR2,
448 	x_msg_count		OUT	NOCOPY  NUMBER,
449 	x_msg_data		OUT	NOCOPY  VARCHAR2,
450 	p_vendor_rec		IN	r_vendor_rec_type,
451 	x_vendor_id		OUT	NOCOPY  AP_SUPPLIERS.VENDOR_ID%TYPE,
452 	x_party_id		OUT	NOCOPY  HZ_PARTIES.PARTY_ID%TYPE
453 );
454 
455 -- Start of comments
456 --	API name 	: Update_Vendor
457 --	Type		: Public
458 --	Function	:
459 --	Pre-reqs	: None.
460 --	Parameters	:
461 --	IN		:	p_api_version IN NUMBER  Required
462 --				p_init_msg_list	IN VARCHAR2 	Optional
463 --					Default = FND_API.G_FALSE
464 --				p_commit IN VARCHAR2 Optional
465 --					Default = FND_API.G_FALSE
466 --				p_validation_level IN NUMBER Optional
467 --					Default = FND_API.G_VALID_LEVEL_FULL
468 --				parameter1
469 --				parameter2
470 --				.
471 --				.
472 --	OUT		:	x_return_status		OUT	VARCHAR2(1)
473 --				x_msg_count		OUT	NUMBER
474 --				x_msg_data		OUT     VARCHAR2(2000)
475 --				parameter1
476 --				parameter2
477 --				.
478 --				.
479 --	Version		: Current version	1.0
480 --			  Initial version 	1.0
481 --
482 --	Notes		: Vendor API, called from various features and other
483 --			  products, to update vendors.
484 --			  This API will not update any TCA tables
485 -- End of comments
486 
487 PROCEDURE Update_Vendor
488 ( 	p_api_version           IN	NUMBER,
489   	p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE,
490 	p_commit	    	IN  	VARCHAR2 := FND_API.G_FALSE,
491 	p_validation_level	IN  	NUMBER	 := FND_API.G_VALID_LEVEL_FULL,
492 	x_return_status		OUT	NOCOPY VARCHAR2,
493 	x_msg_count		OUT	NOCOPY NUMBER,
494 	x_msg_data		OUT	NOCOPY VARCHAR2,
495 	p_vendor_rec		IN	r_vendor_rec_type,
496 	p_vendor_id		IN	NUMBER
497 );
498 
499 -- Start of comments
500 --	API name 	: Validate_Vendor
501 --	Type		: Public
502 --	Function	:
503 --	Pre-reqs	: None.
504 --	Parameters	:
505 --	IN		:	p_api_version IN NUMBER  Required
506 --				p_init_msg_list	IN VARCHAR2 	Optional
507 --					Default = FND_API.G_FALSE
508 --				p_commit IN VARCHAR2 Optional
509 --					Default = FND_API.G_FALSE
510 --				p_validation_level IN NUMBER Optional
511 --					Default = FND_API.G_VALID_LEVEL_FULL
512 --				parameter1
513 --				parameter2
514 --				.
515 --				.
516 --	OUT		:	x_return_status		OUT	VARCHAR2(1)
517 --				x_msg_count		OUT	NUMBER
518 --				x_msg_data		OUT     VARCHAR2(2000)
519 --				parameter1
520 --				parameter2
521 --				.
522 --				.
523 --	Version		: Current version	1.0
524 --			  Initial version 	1.0
525 --
526 --	Notes		: Vendor API, called from various features and other
527 --			  products, to validate a vendor record.
528 --
529 -- End of comments
530 
531 PROCEDURE Validate_Vendor
532 ( 	p_api_version           IN	NUMBER,
533   	p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE,
534 	p_commit	    	IN  	VARCHAR2 := FND_API.G_FALSE,
535 	p_validation_level	IN  	NUMBER	 := FND_API.G_VALID_LEVEL_FULL,
536 	x_return_status		OUT	NOCOPY VARCHAR2,
537 	x_msg_count		OUT	NOCOPY NUMBER,
538 	x_msg_data		OUT	NOCOPY VARCHAR2,
539 	p_vendor_rec		IN OUT	NOCOPY r_vendor_rec_type,
540 	p_mode			IN	VARCHAR2,
541 	p_calling_prog		IN	VARCHAR2,
542 	x_party_valid		OUT	NOCOPY VARCHAR2,
543 	x_payee_valid		OUT	NOCOPY VARCHAR2,
544 	p_vendor_id		IN	NUMBER
545 );
546 
547 -- Start of comments
548 --	API name 	: Create_Vendor_Site
549 --	Type		: Public
550 --	Function	:
551 --	Pre-reqs	: None.
552 --	Parameters	:
553 --	IN		:	p_api_version IN NUMBER  Required
554 --				p_init_msg_list	IN VARCHAR2 	Optional
555 --					Default = FND_API.G_FALSE
556 --				p_commit IN VARCHAR2 Optional
557 --					Default = FND_API.G_FALSE
558 --				p_validation_level IN NUMBER Optional
559 --					Default = FND_API.G_VALID_LEVEL_FULL
560 --				parameter1
561 --				parameter2
562 --				.
563 --				.
564 --	OUT		:	x_return_status		OUT	VARCHAR2(1)
565 --				x_msg_count		OUT	NUMBER
566 --				x_msg_data		OUT     VARCHAR2(2000)
567 --				parameter1
568 --				parameter2
569 --				.
570 --				.
571 --	Version		: Current version	1.0
572 --			  Initial version 	1.0
573 --
574 --	Notes		: Vendor Site API, called from various features and other
575 --			  products, to create new vendor site.
576 --
577 -- End of comments
578 -- Bug 7553276 Added annotation for integration repository.
579 /*#
580  * This procedure is used to create Supplier Site in Payables and populate other
581  * internal tables with the site information.
582  * @param p_api_version The version of the API
583  * @param p_init_msg_list The initialize message list
584  * @param p_commit The Commit flag
585  * @param p_validation_level The validation level
586  * @param x_return_status The return status
587  * @param x_msg_count The message count
588  * @param x_msg_data The message data
589  * @param p_vendor_site_rec Supplier Site record
590  * @param x_vendor_site_id Supplier Site Identifier
591  * @param x_party_site_id Party Site Identifier for Supplier Site
592  * @param x_location_id Location Identifier for Supplier Site
593  * @rep:scope public
594  * @rep:lifecycle active
595  * @rep:displayname Create Supplier Site
596  * @rep:category BUSINESS_ENTITY AP_SUPPLIER_SITE
597  */
598 PROCEDURE Create_Vendor_Site
599 ( 	p_api_version           IN	NUMBER,
600   	p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE,
601 	p_commit	    	IN  	VARCHAR2 := FND_API.G_FALSE,
602 	p_validation_level	IN  	NUMBER	 := FND_API.G_VALID_LEVEL_FULL,
603 	x_return_status		OUT	NOCOPY VARCHAR2,
604 	x_msg_count		OUT	NOCOPY NUMBER,
605 	x_msg_data		OUT	NOCOPY VARCHAR2,
606 	p_vendor_site_rec	IN	r_vendor_site_rec_type,
607 	x_vendor_site_id	OUT	NOCOPY NUMBER,
608 	x_party_site_id		OUT	NOCOPY NUMBER,
609 	x_location_id		OUT	NOCOPY NUMBER
610 );
611 
612 -- Start of comments
613 --	API name 	: Update_Vendor_Site
614 --	Type		: Public
615 --	Function	:
616 --	Pre-reqs	: None.
617 --	Parameters	:
618 --	IN		:	p_api_version IN NUMBER  Required
619 --				p_init_msg_list	IN VARCHAR2 	Optional
620 --					Default = FND_API.G_FALSE
621 --				p_commit IN VARCHAR2 Optional
622 --					Default = FND_API.G_FALSE
623 --				p_validation_level IN NUMBER Optional
624 --					Default = FND_API.G_VALID_LEVEL_FULL
625 --				parameter1
626 --				parameter2
627 --				.
628 --				.
629 --	OUT		:	x_return_status		OUT	VARCHAR2(1)
630 --				x_msg_count		OUT	NUMBER
631 --				x_msg_data		OUT     VARCHAR2(2000)
632 --				parameter1
633 --				parameter2
634 --				.
635 --				.
636 --	Version		: Current version	1.0
637 --			  Initial version 	1.0
638 --
639 --	Notes		: Vendor Site API, called from various features and other
640 --			  products, to update vendor site.
641 --			  This API will not update any TCA records.
642 -- End of comments
643 
644 PROCEDURE Update_Vendor_Site
645 ( 	p_api_version           IN	NUMBER,
646   	p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE,
647 	p_commit	    	IN  	VARCHAR2 := FND_API.G_FALSE,
648 	p_validation_level	IN  	NUMBER	 := FND_API.G_VALID_LEVEL_FULL,
649 	x_return_status		OUT	NOCOPY VARCHAR2,
650 	x_msg_count		OUT	NOCOPY NUMBER,
651 	x_msg_data		OUT	NOCOPY VARCHAR2,
652 	p_vendor_site_rec	IN	r_vendor_site_rec_type,
653 	p_vendor_site_id	IN	NUMBER,
654 	p_calling_prog		IN	VARCHAR2 DEFAULT 'NOT ISETUP'
655 );
656 
657 -- Start of comments
658 --	API name 	: Validate_Vendor_Site
659 --	Type		: Public
660 --	Function	:
661 --	Pre-reqs	: None.
662 --	Parameters	:
663 --	IN		:	p_api_version IN NUMBER  Required
664 --				p_init_msg_list	IN VARCHAR2 	Optional
665 --					Default = FND_API.G_FALSE
666 --				p_commit IN VARCHAR2 Optional
667 --					Default = FND_API.G_FALSE
668 --				p_validation_level IN NUMBER Optional
669 --					Default = FND_API.G_VALID_LEVEL_FULL
670 --				parameter1
671 --				parameter2
672 --				.
673 --				.
674 --	OUT		:	x_return_status		OUT	VARCHAR2(1)
675 --				x_msg_count		OUT	NUMBER
676 --				x_msg_data		OUT     VARCHAR2(2000)
677 --				parameter1
678 --				parameter2
679 --				.
680 --				.
681 --	Version	: Current version	1.0
682 --		  Initial version 	1.0
683 --
684 --	Notes		: Vendor Site API, called from various features and other
685 --			  products, to validate vendor site record fields.
686 --
687 -- End of comments
688 
689 PROCEDURE Validate_Vendor_Site
690 ( 	p_api_version           IN	NUMBER,
691   	p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE,
692 	p_commit	    	IN  	VARCHAR2 := FND_API.G_FALSE,
693 	p_validation_level	IN  	NUMBER	 := FND_API.G_VALID_LEVEL_FULL,
694 	x_return_status		OUT	NOCOPY VARCHAR2,
695 	x_msg_count		OUT	NOCOPY NUMBER,
696 	x_msg_data		OUT	NOCOPY VARCHAR2,
697 	p_vendor_site_rec	IN OUT	NOCOPY r_vendor_site_rec_type,
698 	p_mode			IN	VARCHAR2,
699 	p_calling_prog		IN	VARCHAR2,
700 	x_party_site_valid	OUT	NOCOPY VARCHAR2,
701 	x_location_valid	OUT	NOCOPY VARCHAR2,
702 	x_payee_valid		OUT	NOCOPY VARCHAR2,
703 	p_vendor_site_id	IN	NUMBER
704 );
705 
706 -- Start of comments
707 --	API name 	: Create_Vendor_Contact
708 --	Type		: Public
709 --	Function	:
710 --	Pre-reqs	: None.
711 --	Parameters	:
712 --	IN		:	p_api_version IN NUMBER  Required
713 --				p_init_msg_list	IN VARCHAR2 	Optional
714 --					Default = FND_API.G_FALSE
715 --				p_commit IN VARCHAR2 Optional
716 --					Default = FND_API.G_FALSE
717 --				p_validation_level IN NUMBER Optional
718 --					Default = FND_API.G_VALID_LEVEL_FULL
719 --				parameter1
720 --				parameter2
721 --				.
722 --				.
723 --	OUT		:	x_return_status		OUT	VARCHAR2(1)
724 --				x_msg_count		OUT	NUMBER
725 --				x_msg_data		OUT     VARCHAR2(2000)
726 --				parameter1
727 --				parameter2
728 --				.
729 --				.
730 --	Version		: Current version	1.0
731 --			  Initial version 	1.0
732 --
733 --	Notes		: Vendor Contact API, called from various features and other
734 --				products, to create new vendor contact record.
735 --
736 -- End of comments
737 /*#
738  * This procedure is used to create Supplier Contact in Payables and populate
739  * other internal tables with supplier contact information.
740  * @param p_api_version The version of the API
741  * @param p_init_msg_list The initialize message list
742  * @param p_commit The Commit flag
743  * @param p_validation_level The validation level
744  * @param x_return_status The return status
745  * @param x_msg_count The message count
746  * @param x_msg_data The message data
747  * @param p_vendor_contact_rec Supplier Contact record
748  * @param x_vendor_contact_id Supplier Contact Identifier
749  * @param x_per_party_id Person Party Identifier created for Contact
750  * @param x_rel_party_id Relationship Party Identifier created for Contact
751  * @param x_rel_id Relationship Identifier for Contact with Supplier
752  * @param x_org_contact_id Organization Identifier for Contact
753  * @param x_party_site_id Party Site Identifier for Contact
754  * @rep:scope public
755  * @rep:lifecycle active
756  * @rep:displayname Create Supplier Contact
757  * @rep:category BUSINESS_ENTITY AP_SUPPLIER_CONTACT
758  */
759 PROCEDURE Create_Vendor_Contact
760 ( 	p_api_version           IN	NUMBER,
761   	p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE,
762 	p_commit	    	IN  	VARCHAR2 := FND_API.G_FALSE,
763 	p_validation_level	IN  	NUMBER	 := FND_API.G_VALID_LEVEL_FULL,
764 	x_return_status		OUT	NOCOPY VARCHAR2,
765 	x_msg_count		OUT	NOCOPY NUMBER,
766 	x_msg_data		OUT	NOCOPY VARCHAR2,
767 	p_vendor_contact_rec	IN	r_vendor_contact_rec_type,
768 	x_vendor_contact_id	OUT	NOCOPY NUMBER,
769 	x_per_party_id		OUT	NOCOPY NUMBER,
770 	x_rel_party_id		OUT 	NOCOPY NUMBER,
771 	x_rel_id		OUT	NOCOPY NUMBER,
772 	x_org_contact_id	OUT	NOCOPY NUMBER,
773 	x_party_site_id		OUT	NOCOPY NUMBER
774 );
775 
776 -- Start of comments
777 --	API name 	: Update_Vendor_Contact
778 --	Type		: Public
779 --	Function	:
780 --	Pre-reqs	: None.
781 --	Parameters	:
782 --	IN		:	p_api_version IN NUMBER  Required
783 --				p_init_msg_list	IN VARCHAR2 	Optional
784 --					Default = FND_API.G_FALSE
785 --				p_commit IN VARCHAR2 Optional
786 --					Default = FND_API.G_FALSE
787 --				p_validation_level IN NUMBER Optional
788 --					Default = FND_API.G_VALID_LEVEL_FULL
789 --				parameter1
790 --				parameter2
791 --				.
792 --				.
793 --	OUT		:	x_return_status		OUT	VARCHAR2(1)
794 --				x_msg_count		OUT	NUMBER
795 --				x_msg_data		OUT     VARCHAR2(2000)
796 --	Version		: Current version	1.0
797 --			  Initial version 	1.0
798 --
799 --	Notes		: Vendor Contact API, called from various features and other
800 --				products, to update existing vendor contact record.
801 --
802 -- End of comments
803 
804 PROCEDURE Update_Vendor_Contact
805 ( 	p_api_version       IN	NUMBER,
806   	p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE	,
807 	p_commit	    	IN  	VARCHAR2 := FND_API.G_FALSE,
808 	p_validation_level	IN  	NUMBER	:=  FND_API.G_VALID_LEVEL_FULL,
809 	p_vendor_contact_rec	IN	r_vendor_contact_rec_type,
810 	x_return_status		OUT	NOCOPY VARCHAR2		  	,
811 	x_msg_count		    OUT	NOCOPY NUMBER,
812 	x_msg_data		    OUT	NOCOPY VARCHAR2
813 );
814 
815 -- Start of comments
816 --	API name 	: Validate_Vendor_Contact
817 --	Type		: Public
818 --	Function	:
819 --	Pre-reqs	: None.
820 --	Parameters	:
821 --	IN		:	p_api_version IN NUMBER  Required
822 --				p_init_msg_list	IN VARCHAR2 	Optional
823 --					Default = FND_API.G_FALSE
824 --				p_commit IN VARCHAR2 Optional
825 --					Default = FND_API.G_FALSE
826 --				p_validation_level IN NUMBER Optional
827 --					Default = FND_API.G_VALID_LEVEL_FULL
828 --				parameter1
829 --				parameter2
830 --				.
831 --				.
832 --	OUT		:	x_return_status		OUT	VARCHAR2(1)
833 --				x_msg_count		OUT	NUMBER
834 --				x_msg_data		OUT     VARCHAR2(2000)
835 --				parameter1
836 --				parameter2
837 --				.
838 --				.
839 --	Version		: Current version	1.0
840 --			  Initial version 	1.0
841 --
842 --	Notes		: Vendor Contact API, called from various features and other
843 --			  products, to validate vendor contact record fields.
844 --
845 -- End of comments
846 
847 PROCEDURE Validate_Vendor_Contact
848 ( 	p_api_version           IN	NUMBER,
849   	p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE,
850 	p_commit	    	IN  	VARCHAR2 := FND_API.G_FALSE,
851 	p_validation_level	IN  	NUMBER	 := FND_API.G_VALID_LEVEL_FULL,
852 	x_return_status		OUT	NOCOPY VARCHAR2,
853 	x_msg_count		OUT	NOCOPY NUMBER,
854 	x_msg_data		OUT	NOCOPY VARCHAR2,
855 	p_vendor_contact_rec	IN OUT	NOCOPY r_vendor_contact_rec_type,
856 	x_rel_party_valid 	OUT 	NOCOPY VARCHAR2,
857 	x_per_party_valid 	OUT 	NOCOPY VARCHAR2,
858 	x_rel_valid 		OUT 	NOCOPY VARCHAR2,
859 	x_org_party_id		OUT	NOCOPY NUMBER,
860 	x_org_contact_valid 	OUT 	NOCOPY VARCHAR2,
861 	x_location_id		OUT 	NOCOPY NUMBER,
862         x_party_site_valid      OUT     NOCOPY VARCHAR2
863 );
864 
865 -- Start of comments
866 --      API name        : Import_Vendors
867 --      Type            : Public
868 --      Function        :
869 --      Pre-reqs        : None.
870 --      Parameters      :
871 --      IN              :       p_api_version IN NUMBER  Required
872 --                              p_source IN VARCHAR2 Optional
873 --                                      Default = 'IMPORT'
874 --                              p_what_to_import IN VARCHAR2 Optional
875 --                                      Default = NULL
876 --                              p_commit_size IN NUMBER OPTIONAL
877 --                                      Default = 100
878 --                              .
879 --                              .
880 --      OUT             :       x_return_status         OUT     VARCHAR2(1)
881 --                              x_msg_count             OUT     NUMBER
882 --                              x_msg_data              OUT     VARCHAR2(2000)
883 --                              .
884 --                              .
885 --      Version 	: Current version       1.0
886 --                        Initial version       1.0
887 --
888 --      Notes           : Import Vendors,
889 --                        called from Import Vendor Concurrent Program
890 --                        This will call vendor APIS to
891 --                        create vendors based on AP_SUPPLIERS_INT
892 --
893 -- End of comments
894 
895 PROCEDURE Import_Vendors
896 (       p_api_version           IN      NUMBER,
897         p_source                IN      VARCHAR2 DEFAULT 'IMPORT',
898         p_what_to_import        IN      VARCHAR2 DEFAULT NULL,
899         p_commit_size           IN      NUMBER   DEFAULT 1000,
900         x_return_status         OUT NOCOPY VARCHAR2,
901         x_msg_count             OUT NOCOPY NUMBER,
902         x_msg_data              OUT NOCOPY VARCHAR2
903 );
904 
905 -- Start of comments
906 --      API name        : Import_Vendor_Sites
907 --      Type            : Public
908 --      Function        :
909 --      Pre-reqs        : None.
910 --      Parameters      :
911 --      IN              :       p_api_version IN NUMBER  Required
912 --                              p_source IN VARCHAR2 Optional
913 --                                      Default = 'IMPORT'
914 --                              p_what_to_import IN VARCHAR2 Optional
915 --                                      Default = NULL
916 --                              p_commit_size IN NUMBER OPTIONAL
917 --                                      Default = 100
918 --                              .
919 --                              .
920 --      OUT             :       x_return_status         OUT     VARCHAR2(1)
921 --                              x_msg_count             OUT     NUMBER
922 --                              x_msg_data              OUT     VARCHAR2(2000)
923 --                              .
924 --                              .
925 --      Version 	: Current version       1.0
926 --                        Initial version       1.0
927 --
928 --      Notes           : Import Vendor Sites,
929 --                        called from Import Vendor Sites Conc Program
930 --                        This will call vendor sites API to create
931 --                        vendor sitess based on AP_SUPPLIER_SITES_INT
932 --
933 -- End of comments
934 
935 PROCEDURE Import_Vendor_Sites
936 (       p_api_version           IN  NUMBER,
937         p_source                IN  VARCHAR2 DEFAULT 'IMPORT',
938         p_what_to_import        IN  VARCHAR2 DEFAULT NULL,
939         p_commit_size           IN  NUMBER   DEFAULT 1000,
940         p_org_id                IN  NUMBER   DEFAULT NULL, --bug13801271
941         x_return_status         OUT NOCOPY VARCHAR2,
942         x_msg_count             OUT NOCOPY NUMBER,
943         x_msg_data              OUT NOCOPY VARCHAR2
944 );
945 
946 
947 -- Start of comments
948 --      API name        : Import_Vendor_Contacts
949 --      Type            : Public
950 --      Function        :
951 --      Pre-reqs        : None.
952 --      Parameters      :
953 --      IN              :       p_api_version IN NUMBER  Required
954 --                              p_source IN VARCHAR2 Optional
955 --                                      Default = 'IMPORT'
956 --                              p_what_to_import IN VARCHAR2 Optional
957 --                                      Default = NULL
958 --                              p_commit_size IN NUMBER OPTIONAL
959 --                                      Default = 100
960 --                              .
961 --                              .
962 --      OUT             :       x_return_status         OUT     VARCHAR2(1)
963 --                              x_msg_count             OUT     NUMBER
964 --                              x_msg_data              OUT     VARCHAR2(2000)
965 --                              .
966 --                              .
967 --      Version 	: Current version       1.0
968 --                        Initial version       1.0
969 --
970 --      Notes           : Import Vendor Contacts,
971 --                        called from Import Vendor Contacts Conc Program
972 --                        This will call vendor sites API to create vendor
973 --                        contacts based on AP_SUP_SITE_CONTACT_INT
974 --
975 -- End of comments
976 
977 PROCEDURE Import_Vendor_Contacts
978 (       p_api_version           IN  NUMBER,
979         p_source                IN  VARCHAR2 DEFAULT 'IMPORT',
980         p_what_to_import        IN  VARCHAR2 DEFAULT NULL,
981         p_commit_size           IN  NUMBER   DEFAULT 1000,
982         x_return_status         OUT NOCOPY VARCHAR2,
983         x_msg_count             OUT NOCOPY NUMBER,
984         x_msg_data              OUT NOCOPY VARCHAR2
985 );
986 
987 function is_taxpayer_id_valid(
988     p_taxpayer_id     IN VARCHAR2,
989     p_country         IN VARCHAR2
990 )
991 RETURN VARCHAR2;
992 
993 -- Bug 6745669
994 -- Start of comments
995 --      API name        : Update_Address_Assignments_DFF
996 --      Type            : Public
997 --      Function        :
998 --      Pre-reqs        : None.
999 --      Parameters      :
1000 --      IN              :       p_api_version IN NUMBER  Required
1001 --				p_init_msg_list	IN VARCHAR2 	Optional
1002 --					Default = FND_API.G_FALSE
1003 --				p_commit IN VARCHAR2 Optional
1004 --					Default = FND_API.G_FALSE
1005 --                              p_attribute_category IN VARCHAR2 Optional
1006 --                                      Default = NULL
1007 --                              p_attribute1-15 IN VARCHAR2 Optional
1008 --                                      Default = NULL
1009 --                              .
1010 --      OUT             :       x_return_status         OUT     VARCHAR2(1)
1011 --                              x_msg_count             OUT     NUMBER
1012 --                              x_msg_data              OUT     VARCHAR2(2000)
1013 --                              .
1014 --                              .
1015 --      Version 	: Current version       1.0
1016 --                        Initial version       1.0
1017 --
1018 --      Notes           : Update Address Assignments DFF,called from various
1019 --      		  features and other products,
1020 --                        This will update the DFF columns of the address
1021 --                        assignments contacts in AP_SUPPLIER_CONTACTS
1022 --                        The database values of Attribute_Category and
1023 --                        the Attributes 1-15, will be updated to whatever is
1024 --                        passed to the API and the default value is null.
1025 --
1026 -- End of comments
1027 
1028 PROCEDURE Update_Address_Assignments_DFF(
1029         p_api_version           IN	NUMBER,
1030   	p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE,
1031 	p_commit	    	IN  	VARCHAR2 := FND_API.G_FALSE,
1032         p_contact_party_id      IN      NUMBER,
1033         p_org_party_site_id     IN      NUMBER,
1034         p_attribute_category    IN      VARCHAR2 DEFAULT NULL,
1035         p_attribute1            IN      VARCHAR2 DEFAULT NULL,
1036         p_attribute2            IN      VARCHAR2 DEFAULT NULL,
1037         p_attribute3            IN      VARCHAR2 DEFAULT NULL,
1038         p_attribute4            IN      VARCHAR2 DEFAULT NULL,
1039         p_attribute5            IN      VARCHAR2 DEFAULT NULL,
1040         p_attribute6            IN      VARCHAR2 DEFAULT NULL,
1041         p_attribute7            IN      VARCHAR2 DEFAULT NULL,
1042         p_attribute8            IN      VARCHAR2 DEFAULT NULL,
1043         p_attribute9            IN      VARCHAR2 DEFAULT NULL,
1044         p_attribute10           IN      VARCHAR2 DEFAULT NULL,
1045         p_attribute11           IN      VARCHAR2 DEFAULT NULL,
1046         p_attribute12           IN      VARCHAR2 DEFAULT NULL,
1047         p_attribute13           IN      VARCHAR2 DEFAULT NULL,
1048         p_attribute14           IN      VARCHAR2 DEFAULT NULL,
1049         p_attribute15           IN      VARCHAR2 DEFAULT NULL,
1050         x_return_status		OUT	NOCOPY VARCHAR2,
1051 	x_msg_count		OUT	NOCOPY NUMBER,
1052 	x_msg_data		OUT	NOCOPY VARCHAR2
1053 );
1054 
1055 -- Bug 7307669
1056 -- Start of comments
1057 --      API name        : Raise_Supplier_Event
1058 --      Type            : Public
1059 --      Function        :
1060 --      Pre-reqs        : None.
1061 --      Parameters      :
1062 --      IN              : i_vendor_id     IN  NUMBER  Optional DEFAULT NULL
1063 --			  i_vendor_site_id    IN  NUMBER  Optional DEFAULT NULL
1064 --			  i_vendor_contact_id IN  NUMBER  Optional DEFAULT NULL
1065 --
1066 --      OUT             : None
1067 --
1068 --      Version 	: Current version       1.0
1069 --                        Initial version       1.0
1070 --
1071 --      Notes           : Raise_Supplier_Event is called to raise a business
1072 --                        event whenever a Supplier / Supplier Site / Supplier
1073 --                        Contact is created or updated
1074 -- End of comments
1075 
1076 PROCEDURE Raise_Supplier_Event(
1077 			       i_vendor_id          IN  NUMBER  DEFAULT NULL,
1078 			       i_vendor_site_id     IN  NUMBER  DEFAULT NULL,
1079 			       i_vendor_contact_id  IN  NUMBER  DEFAULT NULL
1080                 	      );
1081 
1082 --Bug 9143273
1083 -- Start of comments
1084 --      API name        : is_Vendor_site_merged
1085 --      Type            : Public
1086 --      Function        :
1087 --      Pre-reqs        : None.
1088 --      Parameters      :
1089 --        IN            : p_vendor_site_id NUMBER  Required
1090 --        Return        : Varchar2
1091 --
1092 --      Version 	    : 1.0
1093 --      Notes           : This function is used tio check if the vendor site
1094 --                        is already merged or not. This function returns
1095 --                        'Y' (vendor site is already merged) or 'N'(vendor
1096 --                        site is already merged)
1097 
1098 FUNCTION Is_Vendor_Site_Merged(
1099     p_vendor_site_id     IN VARCHAR2
1100 )
1101 RETURN VARCHAR2;
1102 --Bug 9143273
1103 
1104 --GTAS Project Bug#13464635 begin
1105 PROCEDURE  CHECK_GDF(
1106 	        p_vendor_id IN VARCHAR2,
1107 		x_valid OUT NOCOPY BOOLEAN,
1108 		P_calling_sequence IN VARCHAR2);
1109  --End Bug#13464635
1110 
1111 END;