[Home] [Help]
PACKAGE: APPS.AP_VENDOR_PUB_PKG
Source
1 PACKAGE AP_VENDOR_PUB_PKG AS
2 /* $Header: appvndrs.pls 120.15.12010000.11 2008/12/11 10:50:19 udhenuko 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 );
154
155 TYPE r_vendor_site_rec_type IS RECORD(
156 AREA_CODE AP_SUPPLIER_SITES_ALL.AREA_CODE%TYPE,
157 PHONE AP_SUPPLIER_SITES_ALL.PHONE%TYPE,
158 CUSTOMER_NUM AP_SUPPLIER_SITES_ALL.CUSTOMER_NUM%TYPE,
159 SHIP_TO_LOCATION_ID NUMBER,
160 BILL_TO_LOCATION_ID NUMBER,
161 SHIP_VIA_LOOKUP_CODE AP_SUPPLIER_SITES_ALL.SHIP_VIA_LOOKUP_CODE%TYPE,
162 FREIGHT_TERMS_LOOKUP_CODE AP_SUPPLIER_SITES_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE,
163 FOB_LOOKUP_CODE AP_SUPPLIER_SITES_ALL.FOB_LOOKUP_CODE%TYPE,
164 INACTIVE_DATE AP_SUPPLIER_SITES_ALL.INACTIVE_DATE%TYPE,
165 FAX AP_SUPPLIER_SITES_ALL.FAX %TYPE,
166 FAX_AREA_CODE AP_SUPPLIER_SITES_ALL.FAX_AREA_CODE%TYPE,
167 TELEX AP_SUPPLIER_SITES_ALL.TELEX%TYPE,
168 TERMS_DATE_BASIS AP_SUPPLIER_SITES_ALL.TERMS_DATE_BASIS%TYPE,
169 DISTRIBUTION_SET_ID NUMBER,
170 ACCTS_PAY_CODE_COMBINATION_ID NUMBER,
171 PREPAY_CODE_COMBINATION_ID NUMBER,
172 PAY_GROUP_LOOKUP_CODE AP_SUPPLIER_SITES_ALL.PAY_GROUP_LOOKUP_CODE%TYPE,
173 PAYMENT_PRIORITY NUMBER,
174 TERMS_ID NUMBER,
175 INVOICE_AMOUNT_LIMIT AP_SUPPLIER_SITES_ALL.INVOICE_AMOUNT_LIMIT%TYPE,
176 PAY_DATE_BASIS_LOOKUP_CODE AP_SUPPLIER_SITES_ALL.PAY_DATE_BASIS_LOOKUP_CODE%TYPE,
177 ALWAYS_TAKE_DISC_FLAG AP_SUPPLIER_SITES_ALL.ALWAYS_TAKE_DISC_FLAG%TYPE,
178 INVOICE_CURRENCY_CODE AP_SUPPLIER_SITES_ALL.INVOICE_CURRENCY_CODE%TYPE,
179 PAYMENT_CURRENCY_CODE AP_SUPPLIER_SITES_ALL.PAYMENT_CURRENCY_CODE%TYPE,
180 VENDOR_SITE_ID NUMBER,
181 LAST_UPDATE_DATE AP_SUPPLIER_SITES_ALL.LAST_UPDATE_DATE%TYPE,
182 LAST_UPDATED_BY AP_SUPPLIER_SITES_ALL.LAST_UPDATED_BY%TYPE,
183 VENDOR_ID NUMBER,
184 VENDOR_SITE_CODE AP_SUPPLIER_SITES_ALL.VENDOR_SITE_CODE%TYPE,
185 VENDOR_SITE_CODE_ALT AP_SUPPLIER_SITES_ALL.VENDOR_SITE_CODE_ALT%TYPE,
186 PURCHASING_SITE_FLAG AP_SUPPLIER_SITES_ALL.PURCHASING_SITE_FLAG%TYPE,
187 RFQ_ONLY_SITE_FLAG AP_SUPPLIER_SITES_ALL.RFQ_ONLY_SITE_FLAG%TYPE,
188 PAY_SITE_FLAG AP_SUPPLIER_SITES_ALL.PAY_SITE_FLAG%TYPE,
189 ATTENTION_AR_FLAG AP_SUPPLIER_SITES_ALL.ATTENTION_AR_FLAG%TYPE,
190 HOLD_ALL_PAYMENTS_FLAG AP_SUPPLIER_SITES_ALL.HOLD_ALL_PAYMENTS_FLAG%TYPE,
191 HOLD_FUTURE_PAYMENTS_FLAG AP_SUPPLIER_SITES_ALL.HOLD_FUTURE_PAYMENTS_FLAG%TYPE,
192 HOLD_REASON AP_SUPPLIER_SITES_ALL.HOLD_REASON%TYPE,
193 HOLD_UNMATCHED_INVOICES_FLAG AP_SUPPLIER_SITES_ALL.HOLD_UNMATCHED_INVOICES_FLAG%TYPE,
194 TAX_REPORTING_SITE_FLAG AP_SUPPLIER_SITES_ALL.TAX_REPORTING_SITE_FLAG%TYPE,
195 ATTRIBUTE_CATEGORY AP_SUPPLIER_SITES_ALL.ATTRIBUTE_CATEGORY%TYPE,
196 ATTRIBUTE1 AP_SUPPLIER_SITES_ALL.ATTRIBUTE1%TYPE,
197 ATTRIBUTE2 AP_SUPPLIER_SITES_ALL.ATTRIBUTE2%TYPE,
198 ATTRIBUTE3 AP_SUPPLIER_SITES_ALL.ATTRIBUTE3%TYPE,
199 ATTRIBUTE4 AP_SUPPLIER_SITES_ALL.ATTRIBUTE4%TYPE,
200 ATTRIBUTE5 AP_SUPPLIER_SITES_ALL.ATTRIBUTE5%TYPE,
201 ATTRIBUTE6 AP_SUPPLIER_SITES_ALL.ATTRIBUTE6%TYPE,
202 ATTRIBUTE7 AP_SUPPLIER_SITES_ALL.ATTRIBUTE7%TYPE,
203 ATTRIBUTE8 AP_SUPPLIER_SITES_ALL.ATTRIBUTE8%TYPE,
204 ATTRIBUTE9 AP_SUPPLIER_SITES_ALL.ATTRIBUTE9%TYPE,
205 ATTRIBUTE10 AP_SUPPLIER_SITES_ALL.ATTRIBUTE10%TYPE,
206 ATTRIBUTE11 AP_SUPPLIER_SITES_ALL.ATTRIBUTE11%TYPE,
207 ATTRIBUTE12 AP_SUPPLIER_SITES_ALL.ATTRIBUTE12%TYPE,
208 ATTRIBUTE13 AP_SUPPLIER_SITES_ALL.ATTRIBUTE13%TYPE,
209 ATTRIBUTE14 AP_SUPPLIER_SITES_ALL.ATTRIBUTE14%TYPE,
210 ATTRIBUTE15 AP_SUPPLIER_SITES_ALL.ATTRIBUTE15%TYPE,
211 VALIDATION_NUMBER NUMBER,
212 EXCLUDE_FREIGHT_FROM_DISCOUNT AP_SUPPLIER_SITES_ALL.EXCLUDE_FREIGHT_FROM_DISCOUNT%TYPE,
213 BANK_CHARGE_BEARER AP_SUPPLIER_SITES_ALL.BANK_CHARGE_BEARER%TYPE,
214 ORG_ID NUMBER,
215 CHECK_DIGITS AP_SUPPLIER_SITES_ALL.CHECK_DIGITS%TYPE,
216 ALLOW_AWT_FLAG AP_SUPPLIER_SITES_ALL.ALLOW_AWT_FLAG%TYPE,
217 AWT_GROUP_ID NUMBER,
218 PAY_AWT_GROUP_ID NUMBER, --bug6664407
219 DEFAULT_PAY_SITE_ID NUMBER,
220 PAY_ON_CODE AP_SUPPLIER_SITES_ALL.PAY_ON_CODE%TYPE,
221 PAY_ON_RECEIPT_SUMMARY_CODE AP_SUPPLIER_SITES_ALL.PAY_ON_RECEIPT_SUMMARY_CODE%TYPE,
222 GLOBAL_ATTRIBUTE_CATEGORY AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,
223 GLOBAL_ATTRIBUTE1 AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE1%TYPE,
224 GLOBAL_ATTRIBUTE2 AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE2%TYPE,
225 GLOBAL_ATTRIBUTE3 AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE3%TYPE,
226 GLOBAL_ATTRIBUTE4 AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE4%TYPE,
227 GLOBAL_ATTRIBUTE5 AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE5%TYPE,
228 GLOBAL_ATTRIBUTE6 AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE6%TYPE,
229 GLOBAL_ATTRIBUTE7 AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE7%TYPE,
230 GLOBAL_ATTRIBUTE8 AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE8%TYPE,
231 GLOBAL_ATTRIBUTE9 AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE9%TYPE,
232 GLOBAL_ATTRIBUTE10 AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE10%TYPE,
233 GLOBAL_ATTRIBUTE11 AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE11%TYPE,
234 GLOBAL_ATTRIBUTE12 AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE12%TYPE,
235 GLOBAL_ATTRIBUTE13 AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE13%TYPE,
236 GLOBAL_ATTRIBUTE14 AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE14%TYPE,
237 GLOBAL_ATTRIBUTE15 AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE15%TYPE,
238 GLOBAL_ATTRIBUTE16 AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE16%TYPE,
239 GLOBAL_ATTRIBUTE17 AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE17%TYPE,
240 GLOBAL_ATTRIBUTE18 AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE18%TYPE,
241 GLOBAL_ATTRIBUTE19 AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE19%TYPE,
242 GLOBAL_ATTRIBUTE20 AP_SUPPLIER_SITES_ALL.GLOBAL_ATTRIBUTE20%TYPE,
243 TP_HEADER_ID NUMBER,
244 ECE_TP_LOCATION_CODE AP_SUPPLIER_SITES_ALL.ECE_TP_LOCATION_CODE%TYPE,
245 PCARD_SITE_FLAG AP_SUPPLIER_SITES_ALL.PCARD_SITE_FLAG%TYPE,
246 MATCH_OPTION AP_SUPPLIER_SITES_ALL.MATCH_OPTION%TYPE,
247 COUNTRY_OF_ORIGIN_CODE AP_SUPPLIER_SITES_ALL.COUNTRY_OF_ORIGIN_CODE%TYPE,
248 FUTURE_DATED_PAYMENT_CCID NUMBER,
249 CREATE_DEBIT_MEMO_FLAG AP_SUPPLIER_SITES_ALL.CREATE_DEBIT_MEMO_FLAG%TYPE,
250 SUPPLIER_NOTIF_METHOD AP_SUPPLIER_SITES_ALL.SUPPLIER_NOTIF_METHOD%TYPE,
251 EMAIL_ADDRESS AP_SUPPLIER_SITES_ALL.EMAIL_ADDRESS%TYPE,
252 PRIMARY_PAY_SITE_FLAG AP_SUPPLIER_SITES_ALL.PRIMARY_PAY_SITE_FLAG%TYPE,
253 SHIPPING_CONTROL AP_SUPPLIER_SITES_ALL.SHIPPING_CONTROL%TYPE,
254 SELLING_COMPANY_IDENTIFIER AP_SUPPLIER_SITES_ALL.SELLING_COMPANY_IDENTIFIER%TYPE,
255 GAPLESS_INV_NUM_FLAG AP_SUPPLIER_SITES_ALL.GAPLESS_INV_NUM_FLAG%TYPE,
256 LOCATION_ID NUMBER,
257 PARTY_SITE_ID NUMBER,
258 ORG_NAME HR_OPERATING_UNITS.NAME%TYPE,
259 DUNS_NUMBER AP_SUPPLIER_SITES_ALL.DUNS_NUMBER%TYPE,
260 ADDRESS_STYLE AP_SUPPLIER_SITES_ALL.ADDRESS_STYLE%TYPE,
261 LANGUAGE AP_SUPPLIER_SITES_ALL.LANGUAGE%TYPE,
262 PROVINCE AP_SUPPLIER_SITES_ALL.PROVINCE%TYPE,
263 COUNTRY AP_SUPPLIER_SITES_ALL.COUNTRY%TYPE,
264 ADDRESS_LINE1 AP_SUPPLIER_SITES_ALL.ADDRESS_LINE1%TYPE,
265 ADDRESS_LINE2 AP_SUPPLIER_SITES_ALL.ADDRESS_LINE2%TYPE,
266 ADDRESS_LINE3 AP_SUPPLIER_SITES_ALL.ADDRESS_LINE3%TYPE,
267 ADDRESS_LINE4 AP_SUPPLIER_SITES_ALL.ADDRESS_LINE4%TYPE,
268 ADDRESS_LINES_ALT AP_SUPPLIER_SITES_ALL.ADDRESS_LINES_ALT%TYPE,
269 COUNTY AP_SUPPLIER_SITES_ALL.COUNTY%TYPE,
270 CITY AP_SUPPLIER_SITES_ALL.CITY%TYPE,
271 STATE AP_SUPPLIER_SITES_ALL.STATE%TYPE,
272 ZIP AP_SUPPLIER_SITES_ALL.ZIP%TYPE,
273 TERMS_NAME AP_TERMS_TL.NAME%TYPE,
274 DEFAULT_TERMS_ID NUMBER,
275 AWT_GROUP_NAME AP_AWT_GROUPS.NAME%TYPE,
276 PAY_AWT_GROUP_NAME AP_AWT_GROUPS.NAME%TYPE,--bug6664407
277 DISTRIBUTION_SET_NAME AP_DISTRIBUTION_SETS_ALL.DISTRIBUTION_SET_NAME%TYPE,
278 SHIP_TO_LOCATION_CODE HR_LOCATIONS_ALL_TL.LOCATION_CODE%TYPE,
279 BILL_TO_LOCATION_CODE HR_LOCATIONS_ALL_TL.LOCATION_CODE%TYPE,
280 DEFAULT_DIST_SET_ID NUMBER,
281 DEFAULT_SHIP_TO_LOC_ID NUMBER,
282 DEFAULT_BILL_TO_LOC_ID NUMBER,
283 TOLERANCE_ID NUMBER,
284 TOLERANCE_NAME AP_TOLERANCE_TEMPLATES.TOLERANCE_NAME%TYPE,
285 VENDOR_INTERFACE_ID NUMBER,
286 VENDOR_SITE_INTERFACE_ID NUMBER,
287 EXT_PAYEE_REC IBY_DISBURSEMENT_SETUP_PUB.EXTERNAL_PAYEE_REC_TYPE,
288 RETAINAGE_RATE NUMBER DEFAULT NULL,
289 SERVICES_TOLERANCE_ID NUMBER,
290 SERVICES_TOLERANCE_NAME AP_TOLERANCE_TEMPLATES.TOLERANCE_NAME%TYPE,
291 SHIPPING_LOCATION_ID NUMBER,
292 VAT_CODE AP_SUPPLIER_SITES_ALL.VAT_CODE%TYPE,
293 VAT_REGISTRATION_NUM AP_SUPPLIER_SITES_INT.VAT_REGISTRATION_NUM%TYPE, -- Bug 7197036
294 -- Bug 7437549 Start
295 EDI_ID_NUMBER AP_SUPPLIER_SITES_INT.EDI_ID_NUMBER%TYPE,
296 EDI_PAYMENT_FORMAT AP_SUPPLIER_SITES_INT.EDI_PAYMENT_FORMAT%TYPE,
297 EDI_TRANSACTION_HANDLING AP_SUPPLIER_SITES_INT.EDI_TRANSACTION_HANDLING%TYPE,
298 EDI_PAYMENT_METHOD AP_SUPPLIER_SITES_INT.EDI_PAYMENT_METHOD%TYPE,
299 EDI_REMITTANCE_METHOD AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_METHOD%TYPE,
300 EDI_REMITTANCE_INSTRUCTION AP_SUPPLIER_SITES_INT.EDI_REMITTANCE_INSTRUCTION%TYPE,
301 -- Bug 7437549 End
302 PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE, -- Bug 7429668
303 OFFSET_TAX_FLAG AP_SUPPLIER_SITES_INT.OFFSET_TAX_FLAG%TYPE, -- Bug#7506443
304 AUTO_TAX_CALC_FLAG AP_SUPPLIER_SITES_INT.AUTO_TAX_CALC_FLAG%TYPE -- Bug#7506443
305 );
306 -- VAT_CODE ADDED TO ABOVE STRUCTURE Bug 6645014
307 -- To Import the VAT Code in Sites.
308
309 -- bug 6745669 - added attribute_category to vendor contact record
310
311 TYPE r_vendor_contact_rec_type IS RECORD(
312 VENDOR_CONTACT_ID NUMBER,
313 VENDOR_SITE_ID NUMBER,
314 VENDOR_ID NUMBER,
315 PER_PARTY_ID NUMBER,
316 RELATIONSHIP_ID NUMBER,
317 REL_PARTY_ID NUMBER,
318 PARTY_SITE_ID NUMBER,
319 ORG_CONTACT_ID NUMBER,
320 ORG_PARTY_SITE_ID NUMBER,
321 PERSON_FIRST_NAME AP_SUPPLIER_CONTACTS.FIRST_NAME%TYPE,
322 PERSON_MIDDLE_NAME AP_SUPPLIER_CONTACTS.MIDDLE_NAME%TYPE,
323 PERSON_LAST_NAME AP_SUPPLIER_CONTACTS.LAST_NAME%TYPE,
324 PERSON_TITLE AP_SUPPLIER_CONTACTS.TITLE%TYPE,
325 ORGANIZATION_NAME_PHONETIC VARCHAR2(320),
326 PERSON_FIRST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.FIRST_NAME_ALT%TYPE,
327 PERSON_LAST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.LAST_NAME_ALT%TYPE,
328 ATTRIBUTE_CATEGORY AP_SUPPLIER_CONTACTS.ATTRIBUTE_CATEGORY%TYPE,
329 ATTRIBUTE1 AP_SUPPLIER_CONTACTS.ATTRIBUTE1%TYPE,
330 ATTRIBUTE2 AP_SUPPLIER_CONTACTS.ATTRIBUTE2%TYPE,
331 ATTRIBUTE3 AP_SUPPLIER_CONTACTS.ATTRIBUTE3%TYPE,
332 ATTRIBUTE4 AP_SUPPLIER_CONTACTS.ATTRIBUTE4%TYPE,
333 ATTRIBUTE5 AP_SUPPLIER_CONTACTS.ATTRIBUTE5%TYPE,
334 ATTRIBUTE6 AP_SUPPLIER_CONTACTS.ATTRIBUTE6%TYPE,
335 ATTRIBUTE7 AP_SUPPLIER_CONTACTS.ATTRIBUTE7%TYPE,
336 ATTRIBUTE8 AP_SUPPLIER_CONTACTS.ATTRIBUTE8%TYPE,
337 ATTRIBUTE9 AP_SUPPLIER_CONTACTS.ATTRIBUTE9%TYPE,
338 ATTRIBUTE10 AP_SUPPLIER_CONTACTS.ATTRIBUTE10%TYPE,
339 ATTRIBUTE11 AP_SUPPLIER_CONTACTS.ATTRIBUTE11%TYPE,
340 ATTRIBUTE12 AP_SUPPLIER_CONTACTS.ATTRIBUTE12%TYPE,
341 ATTRIBUTE13 AP_SUPPLIER_CONTACTS.ATTRIBUTE13%TYPE,
342 ATTRIBUTE14 AP_SUPPLIER_CONTACTS.ATTRIBUTE14%TYPE,
343 ATTRIBUTE15 AP_SUPPLIER_CONTACTS.ATTRIBUTE15%TYPE,
344 INACTIVE_DATE AP_SUPPLIER_CONTACTS.INACTIVE_DATE%TYPE,
345 PARTY_NUMBER VARCHAR2(30),
346 DEPARTMENT AP_SUPPLIER_CONTACTS.DEPARTMENT%TYPE,
347 MAIL_STOP AP_SUPPLIER_CONTACTS.MAIL_STOP%TYPE,
348 AREA_CODE AP_SUPPLIER_CONTACTS.AREA_CODE%TYPE,
349 PHONE AP_SUPPLIER_CONTACTS.PHONE%TYPE,
350 ALT_AREA_CODE AP_SUPPLIER_CONTACTS.ALT_AREA_CODE%TYPE,
351 ALT_PHONE AP_SUPPLIER_CONTACTS.ALT_PHONE%TYPE,
352 FAX_AREA_CODE AP_SUPPLIER_CONTACTS.FAX_AREA_CODE%TYPE,
353 FAX_PHONE AP_SUPPLIER_CONTACTS.FAX%TYPE,
354 EMAIL_ADDRESS AP_SUPPLIER_CONTACTS.EMAIL_ADDRESS%TYPE,
355 URL AP_SUPPLIER_CONTACTS.URL%TYPE,
356 VENDOR_CONTACT_INTERFACE_ID NUMBER,
357 VENDOR_INTERFACE_ID NUMBER,
358 VENDOR_SITE_CODE AP_SUP_SITE_CONTACT_INT.VENDOR_SITE_CODE%TYPE,
359 ORG_ID NUMBER,
360 OPERATING_UNIT_NAME AP_SUP_SITE_CONTACT_INT.OPERATING_UNIT_NAME%TYPE,
361 PREFIX AP_SUP_SITE_CONTACT_INT.PREFIX%TYPE,
362 CONTACT_NAME_PHONETIC AP_SUP_SITE_CONTACT_INT.CONTACT_NAME_ALT%TYPE,
363 PARTY_SITE_NAME HZ_PARTY_SITES.PARTY_SITE_NAME%TYPE -- Bug 7013954
364 );
365
366
367 -- Start of comments
368 -- API name : Create_Vendor
369 -- Type : Public
370 -- Function :
371 -- Pre-reqs : None.
372 -- Parameters :
373 -- IN : p_api_version IN NUMBER Required
374 -- p_init_msg_list IN VARCHAR2 Optional
375 -- Default = FND_API.G_FALSE
376 -- p_commit IN VARCHAR2 Optional
377 -- Default = FND_API.G_FALSE
378 -- p_validation_level IN NUMBER Optional
379 -- Default = FND_API.G_VALID_LEVEL_FULL
380 -- parameter1
381 -- parameter2
382 -- .
383 -- .
384 -- OUT : x_return_status OUT VARCHAR2(1)
385 -- x_msg_count OUT NUMBER
386 -- x_msg_data OUT VARCHAR2(2000)
387 -- parameter1
388 -- parameter2
389 -- .
390 -- .
391 -- Version : Current version 1.0
392 -- Initial version 1.0
393 --
394 -- Notes : Vendor API, called from various features and other
395 -- products, to create new vendors
396 --
397 -- End of comments
398 -- Bug 7553276 Added annotation for integration repository.
399 /*#
400 * This procedure is used to create Supplier in Payables and populate other
401 * internal tables with supplier information.
402 * @param p_api_version The version of the API
403 * @param p_init_msg_list The initialize message list
404 * @param p_commit The Commit flag
405 * @param p_validation_level The validation level
406 * @param x_return_status The return status
407 * @param x_msg_count The message count
408 * @param x_msg_data The message data
409 * @param p_vendor_rec The Supplier record
410 * @param x_vendor_id The Supplier Identifier
411 * @param x_party_id The Party Identifier
412 * @rep:scope public
413 * @rep:lifecycle active
414 * @rep:displayname Create Supplier
415 * @rep:category BUSINESS_ENTITY AP_SUPPLIER
416 */
417 PROCEDURE Create_Vendor
418 ( p_api_version IN NUMBER,
419 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
420 p_commit IN VARCHAR2 := FND_API.G_FALSE,
421 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
422 x_return_status OUT NOCOPY VARCHAR2,
423 x_msg_count OUT NOCOPY NUMBER,
424 x_msg_data OUT NOCOPY VARCHAR2,
425 p_vendor_rec IN r_vendor_rec_type,
426 x_vendor_id OUT NOCOPY AP_SUPPLIERS.VENDOR_ID%TYPE,
427 x_party_id OUT NOCOPY HZ_PARTIES.PARTY_ID%TYPE
428 );
429
430 -- Start of comments
431 -- API name : Update_Vendor
432 -- Type : Public
433 -- Function :
434 -- Pre-reqs : None.
435 -- Parameters :
436 -- IN : p_api_version IN NUMBER Required
437 -- p_init_msg_list IN VARCHAR2 Optional
438 -- Default = FND_API.G_FALSE
439 -- p_commit IN VARCHAR2 Optional
440 -- Default = FND_API.G_FALSE
441 -- p_validation_level IN NUMBER Optional
442 -- Default = FND_API.G_VALID_LEVEL_FULL
443 -- parameter1
444 -- parameter2
445 -- .
446 -- .
447 -- OUT : x_return_status OUT VARCHAR2(1)
448 -- x_msg_count OUT NUMBER
449 -- x_msg_data OUT VARCHAR2(2000)
450 -- parameter1
451 -- parameter2
452 -- .
453 -- .
454 -- Version : Current version 1.0
455 -- Initial version 1.0
456 --
457 -- Notes : Vendor API, called from various features and other
458 -- products, to update vendors.
459 -- This API will not update any TCA tables
460 -- End of comments
461
462 PROCEDURE Update_Vendor
463 ( p_api_version IN NUMBER,
464 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
465 p_commit IN VARCHAR2 := FND_API.G_FALSE,
466 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
467 x_return_status OUT NOCOPY VARCHAR2,
468 x_msg_count OUT NOCOPY NUMBER,
469 x_msg_data OUT NOCOPY VARCHAR2,
470 p_vendor_rec IN r_vendor_rec_type,
471 p_vendor_id IN NUMBER
472 );
473
474 -- Start of comments
475 -- API name : Validate_Vendor
476 -- Type : Public
477 -- Function :
478 -- Pre-reqs : None.
479 -- Parameters :
480 -- IN : p_api_version IN NUMBER Required
481 -- p_init_msg_list IN VARCHAR2 Optional
482 -- Default = FND_API.G_FALSE
483 -- p_commit IN VARCHAR2 Optional
484 -- Default = FND_API.G_FALSE
485 -- p_validation_level IN NUMBER Optional
486 -- Default = FND_API.G_VALID_LEVEL_FULL
487 -- parameter1
488 -- parameter2
489 -- .
490 -- .
491 -- OUT : x_return_status OUT VARCHAR2(1)
492 -- x_msg_count OUT NUMBER
493 -- x_msg_data OUT VARCHAR2(2000)
494 -- parameter1
495 -- parameter2
496 -- .
497 -- .
498 -- Version : Current version 1.0
499 -- Initial version 1.0
500 --
501 -- Notes : Vendor API, called from various features and other
502 -- products, to validate a vendor record.
503 --
504 -- End of comments
505
506 PROCEDURE Validate_Vendor
507 ( p_api_version IN NUMBER,
508 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
509 p_commit IN VARCHAR2 := FND_API.G_FALSE,
510 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
511 x_return_status OUT NOCOPY VARCHAR2,
512 x_msg_count OUT NOCOPY NUMBER,
513 x_msg_data OUT NOCOPY VARCHAR2,
514 p_vendor_rec IN OUT NOCOPY r_vendor_rec_type,
515 p_mode IN VARCHAR2,
516 p_calling_prog IN VARCHAR2,
517 x_party_valid OUT NOCOPY VARCHAR2,
518 x_payee_valid OUT NOCOPY VARCHAR2,
519 p_vendor_id IN NUMBER
520 );
521
522 -- Start of comments
523 -- API name : Create_Vendor_Site
524 -- Type : Public
525 -- Function :
526 -- Pre-reqs : None.
527 -- Parameters :
528 -- IN : p_api_version IN NUMBER Required
529 -- p_init_msg_list IN VARCHAR2 Optional
530 -- Default = FND_API.G_FALSE
531 -- p_commit IN VARCHAR2 Optional
532 -- Default = FND_API.G_FALSE
533 -- p_validation_level IN NUMBER Optional
534 -- Default = FND_API.G_VALID_LEVEL_FULL
535 -- parameter1
536 -- parameter2
537 -- .
538 -- .
539 -- OUT : x_return_status OUT VARCHAR2(1)
540 -- x_msg_count OUT NUMBER
541 -- x_msg_data OUT VARCHAR2(2000)
542 -- parameter1
543 -- parameter2
544 -- .
545 -- .
546 -- Version : Current version 1.0
547 -- Initial version 1.0
548 --
549 -- Notes : Vendor Site API, called from various features and other
550 -- products, to create new vendor site.
551 --
552 -- End of comments
553 -- Bug 7553276 Added annotation for integration repository.
554 /*#
555 * This procedure is used to create Supplier Site in Payables and populate other
556 * internal tables with the site information.
557 * @param p_api_version The version of the API
558 * @param p_init_msg_list The initialize message list
559 * @param p_commit The Commit flag
560 * @param p_validation_level The validation level
561 * @param x_return_status The return status
562 * @param x_msg_count The message count
563 * @param x_msg_data The message data
564 * @param p_vendor_site_rec Supplier Site record
565 * @param x_vendor_site_id Supplier Site Identifier
566 * @param x_party_site_id Party Site Identifier for Supplier Site
567 * @param x_location_id Location Identifier for Supplier Site
568 * @rep:scope public
569 * @rep:lifecycle active
570 * @rep:displayname Create Supplier Site
571 * @rep:category BUSINESS_ENTITY AP_SUPPLIER_SITE
572 */
573 PROCEDURE Create_Vendor_Site
574 ( p_api_version IN NUMBER,
575 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
576 p_commit IN VARCHAR2 := FND_API.G_FALSE,
577 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
578 x_return_status OUT NOCOPY VARCHAR2,
579 x_msg_count OUT NOCOPY NUMBER,
580 x_msg_data OUT NOCOPY VARCHAR2,
581 p_vendor_site_rec IN r_vendor_site_rec_type,
582 x_vendor_site_id OUT NOCOPY NUMBER,
583 x_party_site_id OUT NOCOPY NUMBER,
584 x_location_id OUT NOCOPY NUMBER
585 );
586
587 -- Start of comments
588 -- API name : Update_Vendor_Site
589 -- Type : Public
590 -- Function :
591 -- Pre-reqs : None.
592 -- Parameters :
593 -- IN : p_api_version IN NUMBER Required
594 -- p_init_msg_list IN VARCHAR2 Optional
595 -- Default = FND_API.G_FALSE
596 -- p_commit IN VARCHAR2 Optional
597 -- Default = FND_API.G_FALSE
598 -- p_validation_level IN NUMBER Optional
599 -- Default = FND_API.G_VALID_LEVEL_FULL
600 -- parameter1
601 -- parameter2
602 -- .
603 -- .
604 -- OUT : x_return_status OUT VARCHAR2(1)
605 -- x_msg_count OUT NUMBER
606 -- x_msg_data OUT VARCHAR2(2000)
607 -- parameter1
608 -- parameter2
609 -- .
610 -- .
611 -- Version : Current version 1.0
612 -- Initial version 1.0
613 --
614 -- Notes : Vendor Site API, called from various features and other
615 -- products, to update vendor site.
616 -- This API will not update any TCA records.
617 -- End of comments
618
619 PROCEDURE Update_Vendor_Site
620 ( p_api_version IN NUMBER,
621 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
622 p_commit IN VARCHAR2 := FND_API.G_FALSE,
623 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
624 x_return_status OUT NOCOPY VARCHAR2,
625 x_msg_count OUT NOCOPY NUMBER,
626 x_msg_data OUT NOCOPY VARCHAR2,
627 p_vendor_site_rec IN r_vendor_site_rec_type,
628 p_vendor_site_id IN NUMBER,
629 p_calling_prog IN VARCHAR2 DEFAULT 'NOT ISETUP'
630 );
631
632 -- Start of comments
633 -- API name : Validate_Vendor_Site
634 -- Type : Public
635 -- Function :
636 -- Pre-reqs : None.
637 -- Parameters :
638 -- IN : p_api_version IN NUMBER Required
639 -- p_init_msg_list IN VARCHAR2 Optional
640 -- Default = FND_API.G_FALSE
641 -- p_commit IN VARCHAR2 Optional
642 -- Default = FND_API.G_FALSE
643 -- p_validation_level IN NUMBER Optional
644 -- Default = FND_API.G_VALID_LEVEL_FULL
645 -- parameter1
646 -- parameter2
647 -- .
648 -- .
649 -- OUT : x_return_status OUT VARCHAR2(1)
650 -- x_msg_count OUT NUMBER
651 -- x_msg_data OUT VARCHAR2(2000)
652 -- parameter1
653 -- parameter2
654 -- .
655 -- .
656 -- Version : Current version 1.0
657 -- Initial version 1.0
658 --
659 -- Notes : Vendor Site API, called from various features and other
660 -- products, to validate vendor site record fields.
661 --
662 -- End of comments
663
664 PROCEDURE Validate_Vendor_Site
665 ( p_api_version IN NUMBER,
666 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
667 p_commit IN VARCHAR2 := FND_API.G_FALSE,
668 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
669 x_return_status OUT NOCOPY VARCHAR2,
670 x_msg_count OUT NOCOPY NUMBER,
671 x_msg_data OUT NOCOPY VARCHAR2,
672 p_vendor_site_rec IN OUT NOCOPY r_vendor_site_rec_type,
673 p_mode IN VARCHAR2,
674 p_calling_prog IN VARCHAR2,
675 x_party_site_valid OUT NOCOPY VARCHAR2,
676 x_location_valid OUT NOCOPY VARCHAR2,
677 x_payee_valid OUT NOCOPY VARCHAR2,
678 p_vendor_site_id IN NUMBER
679 );
680
681 -- Start of comments
682 -- API name : Create_Vendor_Contact
683 -- Type : Public
684 -- Function :
685 -- Pre-reqs : None.
686 -- Parameters :
687 -- IN : p_api_version IN NUMBER Required
688 -- p_init_msg_list IN VARCHAR2 Optional
689 -- Default = FND_API.G_FALSE
690 -- p_commit IN VARCHAR2 Optional
691 -- Default = FND_API.G_FALSE
692 -- p_validation_level IN NUMBER Optional
693 -- Default = FND_API.G_VALID_LEVEL_FULL
694 -- parameter1
695 -- parameter2
696 -- .
697 -- .
698 -- OUT : x_return_status OUT VARCHAR2(1)
699 -- x_msg_count OUT NUMBER
700 -- x_msg_data OUT VARCHAR2(2000)
701 -- parameter1
702 -- parameter2
703 -- .
704 -- .
705 -- Version : Current version 1.0
706 -- Initial version 1.0
707 --
708 -- Notes : Vendor Contact API, called from various features and other
709 -- products, to create new vendor contact record.
710 --
711 -- End of comments
712 /*#
713 * This procedure is used to create Supplier Contact in Payables and populate
714 * other internal tables with supplier contact information.
715 * @param p_api_version The version of the API
716 * @param p_init_msg_list The initialize message list
717 * @param p_commit The Commit flag
718 * @param p_validation_level The validation level
719 * @param x_return_status The return status
720 * @param x_msg_count The message count
721 * @param x_msg_data The message data
722 * @param p_vendor_contact_rec Supplier Contact record
723 * @param x_vendor_contact_id Supplier Contact Identifier
724 * @param x_per_party_id Person Party Identifier created for Contact
725 * @param x_rel_party_id Relationship Party Identifier created for Contact
726 * @param x_rel_id Relationship Identifier for Contact with Supplier
727 * @param x_org_contact_id Organization Identifier for Contact
728 * @param x_party_site_id Party Site Identifier for Contact
729 * @rep:scope public
730 * @rep:lifecycle active
731 * @rep:displayname Create Supplier Contact
732 * @rep:category BUSINESS_ENTITY AP_SUPPLIER_CONTACT
733 */
734 PROCEDURE Create_Vendor_Contact
735 ( p_api_version IN NUMBER,
736 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
737 p_commit IN VARCHAR2 := FND_API.G_FALSE,
738 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
739 x_return_status OUT NOCOPY VARCHAR2,
740 x_msg_count OUT NOCOPY NUMBER,
741 x_msg_data OUT NOCOPY VARCHAR2,
742 p_vendor_contact_rec IN r_vendor_contact_rec_type,
743 x_vendor_contact_id OUT NOCOPY NUMBER,
744 x_per_party_id OUT NOCOPY NUMBER,
745 x_rel_party_id OUT NOCOPY NUMBER,
746 x_rel_id OUT NOCOPY NUMBER,
747 x_org_contact_id OUT NOCOPY NUMBER,
748 x_party_site_id OUT NOCOPY NUMBER
749 );
750
751 -- Start of comments
752 -- API name : Update_Vendor_Contact
753 -- Type : Public
754 -- Function :
755 -- Pre-reqs : None.
756 -- Parameters :
757 -- IN : p_api_version IN NUMBER Required
758 -- p_init_msg_list IN VARCHAR2 Optional
759 -- Default = FND_API.G_FALSE
760 -- p_commit IN VARCHAR2 Optional
761 -- Default = FND_API.G_FALSE
762 -- p_validation_level IN NUMBER Optional
763 -- Default = FND_API.G_VALID_LEVEL_FULL
764 -- parameter1
765 -- parameter2
766 -- .
767 -- .
768 -- OUT : x_return_status OUT VARCHAR2(1)
769 -- x_msg_count OUT NUMBER
770 -- x_msg_data OUT VARCHAR2(2000)
771 -- Version : Current version 1.0
772 -- Initial version 1.0
773 --
774 -- Notes : Vendor Contact API, called from various features and other
775 -- products, to update existing vendor contact record.
776 --
777 -- End of comments
778
779 PROCEDURE Update_Vendor_Contact
780 ( p_api_version IN NUMBER,
781 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
782 p_commit IN VARCHAR2 := FND_API.G_FALSE,
783 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
784 p_vendor_contact_rec IN r_vendor_contact_rec_type,
785 x_return_status OUT NOCOPY VARCHAR2 ,
786 x_msg_count OUT NOCOPY NUMBER,
787 x_msg_data OUT NOCOPY VARCHAR2
788 );
789
790 -- Start of comments
791 -- API name : Validate_Vendor_Contact
792 -- Type : Public
793 -- Function :
794 -- Pre-reqs : None.
795 -- Parameters :
796 -- IN : p_api_version IN NUMBER Required
797 -- p_init_msg_list IN VARCHAR2 Optional
798 -- Default = FND_API.G_FALSE
799 -- p_commit IN VARCHAR2 Optional
800 -- Default = FND_API.G_FALSE
801 -- p_validation_level IN NUMBER Optional
802 -- Default = FND_API.G_VALID_LEVEL_FULL
803 -- parameter1
804 -- parameter2
805 -- .
806 -- .
807 -- OUT : x_return_status OUT VARCHAR2(1)
808 -- x_msg_count OUT NUMBER
809 -- x_msg_data OUT VARCHAR2(2000)
810 -- parameter1
811 -- parameter2
812 -- .
813 -- .
814 -- Version : Current version 1.0
815 -- Initial version 1.0
816 --
817 -- Notes : Vendor Contact API, called from various features and other
818 -- products, to validate vendor contact record fields.
819 --
820 -- End of comments
821
822 PROCEDURE Validate_Vendor_Contact
823 ( p_api_version IN NUMBER,
824 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
825 p_commit IN VARCHAR2 := FND_API.G_FALSE,
826 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
827 x_return_status OUT NOCOPY VARCHAR2,
828 x_msg_count OUT NOCOPY NUMBER,
829 x_msg_data OUT NOCOPY VARCHAR2,
830 p_vendor_contact_rec IN OUT NOCOPY r_vendor_contact_rec_type,
831 x_rel_party_valid OUT NOCOPY VARCHAR2,
832 x_per_party_valid OUT NOCOPY VARCHAR2,
833 x_rel_valid OUT NOCOPY VARCHAR2,
834 x_org_party_id OUT NOCOPY NUMBER,
835 x_org_contact_valid OUT NOCOPY VARCHAR2,
836 x_location_id OUT NOCOPY NUMBER,
837 x_party_site_valid OUT NOCOPY VARCHAR2
838 );
839
840 -- Start of comments
841 -- API name : Import_Vendors
842 -- Type : Public
843 -- Function :
844 -- Pre-reqs : None.
845 -- Parameters :
846 -- IN : p_api_version IN NUMBER Required
847 -- p_source IN VARCHAR2 Optional
848 -- Default = 'IMPORT'
849 -- p_what_to_import IN VARCHAR2 Optional
850 -- Default = NULL
851 -- p_commit_size IN NUMBER OPTIONAL
852 -- Default = 100
853 -- .
854 -- .
855 -- OUT : x_return_status OUT VARCHAR2(1)
856 -- x_msg_count OUT NUMBER
857 -- x_msg_data OUT VARCHAR2(2000)
858 -- .
859 -- .
860 -- Version : Current version 1.0
861 -- Initial version 1.0
862 --
863 -- Notes : Import Vendors,
864 -- called from Import Vendor Concurrent Program
865 -- This will call vendor APIS to
866 -- create vendors based on AP_SUPPLIERS_INT
867 --
868 -- End of comments
869
870 PROCEDURE Import_Vendors
871 ( p_api_version IN NUMBER,
872 p_source IN VARCHAR2 DEFAULT 'IMPORT',
873 p_what_to_import IN VARCHAR2 DEFAULT NULL,
874 p_commit_size IN NUMBER DEFAULT 1000,
875 x_return_status OUT NOCOPY VARCHAR2,
876 x_msg_count OUT NOCOPY NUMBER,
877 x_msg_data OUT NOCOPY VARCHAR2
878 );
879
880 -- Start of comments
881 -- API name : Import_Vendor_Sites
882 -- Type : Public
883 -- Function :
884 -- Pre-reqs : None.
885 -- Parameters :
886 -- IN : p_api_version IN NUMBER Required
887 -- p_source IN VARCHAR2 Optional
888 -- Default = 'IMPORT'
889 -- p_what_to_import IN VARCHAR2 Optional
890 -- Default = NULL
891 -- p_commit_size IN NUMBER OPTIONAL
892 -- Default = 100
893 -- .
894 -- .
895 -- OUT : x_return_status OUT VARCHAR2(1)
896 -- x_msg_count OUT NUMBER
897 -- x_msg_data OUT VARCHAR2(2000)
898 -- .
899 -- .
900 -- Version : Current version 1.0
901 -- Initial version 1.0
902 --
903 -- Notes : Import Vendor Sites,
904 -- called from Import Vendor Sites Conc Program
905 -- This will call vendor sites API to create
906 -- vendor sitess based on AP_SUPPLIER_SITES_INT
907 --
908 -- End of comments
909
910 PROCEDURE Import_Vendor_Sites
911 ( p_api_version IN NUMBER,
912 p_source IN VARCHAR2 DEFAULT 'IMPORT',
913 p_what_to_import IN VARCHAR2 DEFAULT NULL,
914 p_commit_size IN NUMBER DEFAULT 1000,
915 x_return_status OUT NOCOPY VARCHAR2,
916 x_msg_count OUT NOCOPY NUMBER,
917 x_msg_data OUT NOCOPY VARCHAR2
918 );
919
920
921 -- Start of comments
922 -- API name : Import_Vendor_Contacts
923 -- Type : Public
924 -- Function :
925 -- Pre-reqs : None.
926 -- Parameters :
927 -- IN : p_api_version IN NUMBER Required
928 -- p_source IN VARCHAR2 Optional
929 -- Default = 'IMPORT'
930 -- p_what_to_import IN VARCHAR2 Optional
931 -- Default = NULL
932 -- p_commit_size IN NUMBER OPTIONAL
933 -- Default = 100
934 -- .
935 -- .
936 -- OUT : x_return_status OUT VARCHAR2(1)
937 -- x_msg_count OUT NUMBER
938 -- x_msg_data OUT VARCHAR2(2000)
939 -- .
940 -- .
941 -- Version : Current version 1.0
942 -- Initial version 1.0
943 --
944 -- Notes : Import Vendor Contacts,
945 -- called from Import Vendor Contacts Conc Program
946 -- This will call vendor sites API to create vendor
947 -- contacts based on AP_SUP_SITE_CONTACT_INT
948 --
949 -- End of comments
950
951 PROCEDURE Import_Vendor_Contacts
952 ( p_api_version IN NUMBER,
953 p_source IN VARCHAR2 DEFAULT 'IMPORT',
954 p_what_to_import IN VARCHAR2 DEFAULT NULL,
955 p_commit_size IN NUMBER DEFAULT 1000,
956 x_return_status OUT NOCOPY VARCHAR2,
957 x_msg_count OUT NOCOPY NUMBER,
958 x_msg_data OUT NOCOPY VARCHAR2
959 );
960
961 function is_taxpayer_id_valid(
962 p_taxpayer_id IN VARCHAR2,
963 p_country IN VARCHAR2
964 )
965 RETURN VARCHAR2;
966
967 -- Bug 6745669
968 -- Start of comments
969 -- API name : Update_Address_Assignments_DFF
970 -- Type : Public
971 -- Function :
972 -- Pre-reqs : None.
973 -- Parameters :
974 -- IN : p_api_version IN NUMBER Required
975 -- p_init_msg_list IN VARCHAR2 Optional
976 -- Default = FND_API.G_FALSE
977 -- p_commit IN VARCHAR2 Optional
978 -- Default = FND_API.G_FALSE
979 -- p_attribute_category IN VARCHAR2 Optional
980 -- Default = NULL
981 -- p_attribute1-15 IN VARCHAR2 Optional
982 -- Default = NULL
983 -- .
984 -- OUT : x_return_status OUT VARCHAR2(1)
985 -- x_msg_count OUT NUMBER
986 -- x_msg_data OUT VARCHAR2(2000)
987 -- .
988 -- .
989 -- Version : Current version 1.0
990 -- Initial version 1.0
991 --
992 -- Notes : Update Address Assignments DFF,called from various
993 -- features and other products,
994 -- This will update the DFF columns of the address
995 -- assignments contacts in AP_SUPPLIER_CONTACTS
996 -- The database values of Attribute_Category and
997 -- the Attributes 1-15, will be updated to whatever is
998 -- passed to the API and the default value is null.
999 --
1000 -- End of comments
1001
1002 PROCEDURE Update_Address_Assignments_DFF(
1003 p_api_version IN NUMBER,
1004 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1005 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1006 p_contact_party_id IN NUMBER,
1007 p_org_party_site_id IN NUMBER,
1008 p_attribute_category IN VARCHAR2 DEFAULT NULL,
1009 p_attribute1 IN VARCHAR2 DEFAULT NULL,
1010 p_attribute2 IN VARCHAR2 DEFAULT NULL,
1011 p_attribute3 IN VARCHAR2 DEFAULT NULL,
1012 p_attribute4 IN VARCHAR2 DEFAULT NULL,
1013 p_attribute5 IN VARCHAR2 DEFAULT NULL,
1014 p_attribute6 IN VARCHAR2 DEFAULT NULL,
1015 p_attribute7 IN VARCHAR2 DEFAULT NULL,
1016 p_attribute8 IN VARCHAR2 DEFAULT NULL,
1017 p_attribute9 IN VARCHAR2 DEFAULT NULL,
1018 p_attribute10 IN VARCHAR2 DEFAULT NULL,
1019 p_attribute11 IN VARCHAR2 DEFAULT NULL,
1020 p_attribute12 IN VARCHAR2 DEFAULT NULL,
1021 p_attribute13 IN VARCHAR2 DEFAULT NULL,
1022 p_attribute14 IN VARCHAR2 DEFAULT NULL,
1023 p_attribute15 IN VARCHAR2 DEFAULT NULL,
1024 x_return_status OUT NOCOPY VARCHAR2,
1025 x_msg_count OUT NOCOPY NUMBER,
1026 x_msg_data OUT NOCOPY VARCHAR2
1027 );
1028
1029 -- Bug 7307669
1030 -- Start of comments
1031 -- API name : Raise_Supplier_Event
1032 -- Type : Public
1033 -- Function :
1034 -- Pre-reqs : None.
1035 -- Parameters :
1036 -- IN : i_vendor_id IN NUMBER Optional DEFAULT NULL
1037 -- i_vendor_site_id IN NUMBER Optional DEFAULT NULL
1038 -- i_vendor_contact_id IN NUMBER Optional DEFAULT NULL
1039 --
1040 -- OUT : None
1041 --
1042 -- Version : Current version 1.0
1043 -- Initial version 1.0
1044 --
1045 -- Notes : Raise_Supplier_Event is called to raise a business
1046 -- event whenever a Supplier / Supplier Site / Supplier
1047 -- Contact is created or updated
1048 -- End of comments
1049
1050 PROCEDURE Raise_Supplier_Event(
1051 i_vendor_id IN NUMBER DEFAULT NULL,
1052 i_vendor_site_id IN NUMBER DEFAULT NULL,
1053 i_vendor_contact_id IN NUMBER DEFAULT NULL
1054 );
1055
1056 END;