[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;