22: p_init_msg_list IN VARCHAR2 DEFAULT NULL,
23: p_party_id IN NUMBER,
24: p_orig_system IN VARCHAR2,
25: p_orig_system_reference IN VARCHAR2,
26: x_ap_supplier_contact_bo OUT NOCOPY pos_supplier_contact_bo_tbl,
27: x_return_status OUT NOCOPY VARCHAR2,
28: x_msg_count OUT NOCOPY NUMBER,
29: x_msg_data OUT NOCOPY VARCHAR2
30: ) IS
28: x_msg_count OUT NOCOPY NUMBER,
29: x_msg_data OUT NOCOPY VARCHAR2
30: ) IS
31:
32: -- l_ap_supplier_contact_typ_tbl pos_supplier_contact_bo_tbl := pos_supplier_contact_bo_tbl();
33: --l_pos_supplier_uda_bo pos_supplier_uda_bo;
34: l_party_id NUMBER;
35:
36: BEGIN
152: /*#
153: * Use this routine to create supplier contact
154: * @param p_api_version The version of API
155: * @param p_init_msg_list The Initialization message list
156: * @param p_pos_supplier_contact_bo_tbl The Supplier Contact BO table
157: * @param p_party_id The Party Id
158: * @param p_orig_system The Orig System
159: * @param p_orig_system_reference The Orig System Reference
160: * @param p_create_update_flag The Create Update Flag
174: PROCEDURE create_pos_supp_contact_bo
175: (
176: p_api_version IN NUMBER DEFAULT NULL,
177: p_init_msg_list IN VARCHAR2 DEFAULT NULL,
178: p_pos_supplier_contact_bo_tbl IN pos_supplier_contact_bo_tbl,
179: p_party_id IN NUMBER,
180: p_orig_system IN VARCHAR2,
181: p_orig_system_reference IN VARCHAR2,
182: p_create_update_flag IN VARCHAR2,
212: END IF;
213:
214: l_step := 'call ap_vendor_pub_pkg.create_vendor_contact';
215:
216: FOR i IN p_pos_supplier_contact_bo_tbl.first .. p_pos_supplier_contact_bo_tbl.last LOOP
217:
218: p_vendor_contact_rec.alt_area_code := p_pos_supplier_contact_bo_tbl(i)
219: .alt_area_code;
220: p_vendor_contact_rec.alt_phone := p_pos_supplier_contact_bo_tbl(i)
214: l_step := 'call ap_vendor_pub_pkg.create_vendor_contact';
215:
216: FOR i IN p_pos_supplier_contact_bo_tbl.first .. p_pos_supplier_contact_bo_tbl.last LOOP
217:
218: p_vendor_contact_rec.alt_area_code := p_pos_supplier_contact_bo_tbl(i)
219: .alt_area_code;
220: p_vendor_contact_rec.alt_phone := p_pos_supplier_contact_bo_tbl(i)
221: .alt_phone;
222: p_vendor_contact_rec.area_code := p_pos_supplier_contact_bo_tbl(i)
216: FOR i IN p_pos_supplier_contact_bo_tbl.first .. p_pos_supplier_contact_bo_tbl.last LOOP
217:
218: p_vendor_contact_rec.alt_area_code := p_pos_supplier_contact_bo_tbl(i)
219: .alt_area_code;
220: p_vendor_contact_rec.alt_phone := p_pos_supplier_contact_bo_tbl(i)
221: .alt_phone;
222: p_vendor_contact_rec.area_code := p_pos_supplier_contact_bo_tbl(i)
223: .area_code;
224: p_vendor_contact_rec.attribute_category := p_pos_supplier_contact_bo_tbl(i)
218: p_vendor_contact_rec.alt_area_code := p_pos_supplier_contact_bo_tbl(i)
219: .alt_area_code;
220: p_vendor_contact_rec.alt_phone := p_pos_supplier_contact_bo_tbl(i)
221: .alt_phone;
222: p_vendor_contact_rec.area_code := p_pos_supplier_contact_bo_tbl(i)
223: .area_code;
224: p_vendor_contact_rec.attribute_category := p_pos_supplier_contact_bo_tbl(i)
225: .attribute_category;
226: p_vendor_contact_rec.attribute1 := p_pos_supplier_contact_bo_tbl(i)
220: p_vendor_contact_rec.alt_phone := p_pos_supplier_contact_bo_tbl(i)
221: .alt_phone;
222: p_vendor_contact_rec.area_code := p_pos_supplier_contact_bo_tbl(i)
223: .area_code;
224: p_vendor_contact_rec.attribute_category := p_pos_supplier_contact_bo_tbl(i)
225: .attribute_category;
226: p_vendor_contact_rec.attribute1 := p_pos_supplier_contact_bo_tbl(i)
227: .attribute1;
228: p_vendor_contact_rec.attribute10 := p_pos_supplier_contact_bo_tbl(i)
222: p_vendor_contact_rec.area_code := p_pos_supplier_contact_bo_tbl(i)
223: .area_code;
224: p_vendor_contact_rec.attribute_category := p_pos_supplier_contact_bo_tbl(i)
225: .attribute_category;
226: p_vendor_contact_rec.attribute1 := p_pos_supplier_contact_bo_tbl(i)
227: .attribute1;
228: p_vendor_contact_rec.attribute10 := p_pos_supplier_contact_bo_tbl(i)
229: .attribute10;
230: p_vendor_contact_rec.attribute11 := p_pos_supplier_contact_bo_tbl(i)
224: p_vendor_contact_rec.attribute_category := p_pos_supplier_contact_bo_tbl(i)
225: .attribute_category;
226: p_vendor_contact_rec.attribute1 := p_pos_supplier_contact_bo_tbl(i)
227: .attribute1;
228: p_vendor_contact_rec.attribute10 := p_pos_supplier_contact_bo_tbl(i)
229: .attribute10;
230: p_vendor_contact_rec.attribute11 := p_pos_supplier_contact_bo_tbl(i)
231: .attribute11;
232: p_vendor_contact_rec.attribute12 := p_pos_supplier_contact_bo_tbl(i)
226: p_vendor_contact_rec.attribute1 := p_pos_supplier_contact_bo_tbl(i)
227: .attribute1;
228: p_vendor_contact_rec.attribute10 := p_pos_supplier_contact_bo_tbl(i)
229: .attribute10;
230: p_vendor_contact_rec.attribute11 := p_pos_supplier_contact_bo_tbl(i)
231: .attribute11;
232: p_vendor_contact_rec.attribute12 := p_pos_supplier_contact_bo_tbl(i)
233: .attribute12;
234: p_vendor_contact_rec.attribute13 := p_pos_supplier_contact_bo_tbl(i)
228: p_vendor_contact_rec.attribute10 := p_pos_supplier_contact_bo_tbl(i)
229: .attribute10;
230: p_vendor_contact_rec.attribute11 := p_pos_supplier_contact_bo_tbl(i)
231: .attribute11;
232: p_vendor_contact_rec.attribute12 := p_pos_supplier_contact_bo_tbl(i)
233: .attribute12;
234: p_vendor_contact_rec.attribute13 := p_pos_supplier_contact_bo_tbl(i)
235: .attribute13;
236: p_vendor_contact_rec.attribute14 := p_pos_supplier_contact_bo_tbl(i)
230: p_vendor_contact_rec.attribute11 := p_pos_supplier_contact_bo_tbl(i)
231: .attribute11;
232: p_vendor_contact_rec.attribute12 := p_pos_supplier_contact_bo_tbl(i)
233: .attribute12;
234: p_vendor_contact_rec.attribute13 := p_pos_supplier_contact_bo_tbl(i)
235: .attribute13;
236: p_vendor_contact_rec.attribute14 := p_pos_supplier_contact_bo_tbl(i)
237: .attribute14;
238: p_vendor_contact_rec.attribute15 := p_pos_supplier_contact_bo_tbl(i)
232: p_vendor_contact_rec.attribute12 := p_pos_supplier_contact_bo_tbl(i)
233: .attribute12;
234: p_vendor_contact_rec.attribute13 := p_pos_supplier_contact_bo_tbl(i)
235: .attribute13;
236: p_vendor_contact_rec.attribute14 := p_pos_supplier_contact_bo_tbl(i)
237: .attribute14;
238: p_vendor_contact_rec.attribute15 := p_pos_supplier_contact_bo_tbl(i)
239: .attribute15;
240: p_vendor_contact_rec.attribute2 := p_pos_supplier_contact_bo_tbl(i)
234: p_vendor_contact_rec.attribute13 := p_pos_supplier_contact_bo_tbl(i)
235: .attribute13;
236: p_vendor_contact_rec.attribute14 := p_pos_supplier_contact_bo_tbl(i)
237: .attribute14;
238: p_vendor_contact_rec.attribute15 := p_pos_supplier_contact_bo_tbl(i)
239: .attribute15;
240: p_vendor_contact_rec.attribute2 := p_pos_supplier_contact_bo_tbl(i)
241: .attribute2;
242: p_vendor_contact_rec.attribute3 := p_pos_supplier_contact_bo_tbl(i)
236: p_vendor_contact_rec.attribute14 := p_pos_supplier_contact_bo_tbl(i)
237: .attribute14;
238: p_vendor_contact_rec.attribute15 := p_pos_supplier_contact_bo_tbl(i)
239: .attribute15;
240: p_vendor_contact_rec.attribute2 := p_pos_supplier_contact_bo_tbl(i)
241: .attribute2;
242: p_vendor_contact_rec.attribute3 := p_pos_supplier_contact_bo_tbl(i)
243: .attribute3;
244: p_vendor_contact_rec.attribute4 := p_pos_supplier_contact_bo_tbl(i)
238: p_vendor_contact_rec.attribute15 := p_pos_supplier_contact_bo_tbl(i)
239: .attribute15;
240: p_vendor_contact_rec.attribute2 := p_pos_supplier_contact_bo_tbl(i)
241: .attribute2;
242: p_vendor_contact_rec.attribute3 := p_pos_supplier_contact_bo_tbl(i)
243: .attribute3;
244: p_vendor_contact_rec.attribute4 := p_pos_supplier_contact_bo_tbl(i)
245: .attribute4;
246: p_vendor_contact_rec.attribute5 := p_pos_supplier_contact_bo_tbl(i)
240: p_vendor_contact_rec.attribute2 := p_pos_supplier_contact_bo_tbl(i)
241: .attribute2;
242: p_vendor_contact_rec.attribute3 := p_pos_supplier_contact_bo_tbl(i)
243: .attribute3;
244: p_vendor_contact_rec.attribute4 := p_pos_supplier_contact_bo_tbl(i)
245: .attribute4;
246: p_vendor_contact_rec.attribute5 := p_pos_supplier_contact_bo_tbl(i)
247: .attribute5;
248: p_vendor_contact_rec.attribute6 := p_pos_supplier_contact_bo_tbl(i)
242: p_vendor_contact_rec.attribute3 := p_pos_supplier_contact_bo_tbl(i)
243: .attribute3;
244: p_vendor_contact_rec.attribute4 := p_pos_supplier_contact_bo_tbl(i)
245: .attribute4;
246: p_vendor_contact_rec.attribute5 := p_pos_supplier_contact_bo_tbl(i)
247: .attribute5;
248: p_vendor_contact_rec.attribute6 := p_pos_supplier_contact_bo_tbl(i)
249: .attribute6;
250: p_vendor_contact_rec.attribute7 := p_pos_supplier_contact_bo_tbl(i)
244: p_vendor_contact_rec.attribute4 := p_pos_supplier_contact_bo_tbl(i)
245: .attribute4;
246: p_vendor_contact_rec.attribute5 := p_pos_supplier_contact_bo_tbl(i)
247: .attribute5;
248: p_vendor_contact_rec.attribute6 := p_pos_supplier_contact_bo_tbl(i)
249: .attribute6;
250: p_vendor_contact_rec.attribute7 := p_pos_supplier_contact_bo_tbl(i)
251: .attribute7;
252: p_vendor_contact_rec.attribute8 := p_pos_supplier_contact_bo_tbl(i)
246: p_vendor_contact_rec.attribute5 := p_pos_supplier_contact_bo_tbl(i)
247: .attribute5;
248: p_vendor_contact_rec.attribute6 := p_pos_supplier_contact_bo_tbl(i)
249: .attribute6;
250: p_vendor_contact_rec.attribute7 := p_pos_supplier_contact_bo_tbl(i)
251: .attribute7;
252: p_vendor_contact_rec.attribute8 := p_pos_supplier_contact_bo_tbl(i)
253: .attribute8;
254: p_vendor_contact_rec.attribute9 := p_pos_supplier_contact_bo_tbl(i)
248: p_vendor_contact_rec.attribute6 := p_pos_supplier_contact_bo_tbl(i)
249: .attribute6;
250: p_vendor_contact_rec.attribute7 := p_pos_supplier_contact_bo_tbl(i)
251: .attribute7;
252: p_vendor_contact_rec.attribute8 := p_pos_supplier_contact_bo_tbl(i)
253: .attribute8;
254: p_vendor_contact_rec.attribute9 := p_pos_supplier_contact_bo_tbl(i)
255: .attribute9;
256: p_vendor_contact_rec.contact_name_phonetic := p_pos_supplier_contact_bo_tbl(i)
250: p_vendor_contact_rec.attribute7 := p_pos_supplier_contact_bo_tbl(i)
251: .attribute7;
252: p_vendor_contact_rec.attribute8 := p_pos_supplier_contact_bo_tbl(i)
253: .attribute8;
254: p_vendor_contact_rec.attribute9 := p_pos_supplier_contact_bo_tbl(i)
255: .attribute9;
256: p_vendor_contact_rec.contact_name_phonetic := p_pos_supplier_contact_bo_tbl(i)
257: .contact_name_phonetic;
258: p_vendor_contact_rec.department := p_pos_supplier_contact_bo_tbl(i)
252: p_vendor_contact_rec.attribute8 := p_pos_supplier_contact_bo_tbl(i)
253: .attribute8;
254: p_vendor_contact_rec.attribute9 := p_pos_supplier_contact_bo_tbl(i)
255: .attribute9;
256: p_vendor_contact_rec.contact_name_phonetic := p_pos_supplier_contact_bo_tbl(i)
257: .contact_name_phonetic;
258: p_vendor_contact_rec.department := p_pos_supplier_contact_bo_tbl(i)
259: .department;
260: p_vendor_contact_rec.email_address := p_pos_supplier_contact_bo_tbl(i)
254: p_vendor_contact_rec.attribute9 := p_pos_supplier_contact_bo_tbl(i)
255: .attribute9;
256: p_vendor_contact_rec.contact_name_phonetic := p_pos_supplier_contact_bo_tbl(i)
257: .contact_name_phonetic;
258: p_vendor_contact_rec.department := p_pos_supplier_contact_bo_tbl(i)
259: .department;
260: p_vendor_contact_rec.email_address := p_pos_supplier_contact_bo_tbl(i)
261: .email_address;
262:
256: p_vendor_contact_rec.contact_name_phonetic := p_pos_supplier_contact_bo_tbl(i)
257: .contact_name_phonetic;
258: p_vendor_contact_rec.department := p_pos_supplier_contact_bo_tbl(i)
259: .department;
260: p_vendor_contact_rec.email_address := p_pos_supplier_contact_bo_tbl(i)
261: .email_address;
262:
263: p_vendor_contact_rec.fax_area_code := p_pos_supplier_contact_bo_tbl(i)
264: .fax_area_code;
259: .department;
260: p_vendor_contact_rec.email_address := p_pos_supplier_contact_bo_tbl(i)
261: .email_address;
262:
263: p_vendor_contact_rec.fax_area_code := p_pos_supplier_contact_bo_tbl(i)
264: .fax_area_code;
265: p_vendor_contact_rec.fax_phone := p_pos_supplier_contact_bo_tbl(i).fax;
266: p_vendor_contact_rec.inactive_date := p_pos_supplier_contact_bo_tbl(i)
267: .inactive_date;
261: .email_address;
262:
263: p_vendor_contact_rec.fax_area_code := p_pos_supplier_contact_bo_tbl(i)
264: .fax_area_code;
265: p_vendor_contact_rec.fax_phone := p_pos_supplier_contact_bo_tbl(i).fax;
266: p_vendor_contact_rec.inactive_date := p_pos_supplier_contact_bo_tbl(i)
267: .inactive_date;
268: p_vendor_contact_rec.mail_stop := p_pos_supplier_contact_bo_tbl(i)
269: .mail_stop;
262:
263: p_vendor_contact_rec.fax_area_code := p_pos_supplier_contact_bo_tbl(i)
264: .fax_area_code;
265: p_vendor_contact_rec.fax_phone := p_pos_supplier_contact_bo_tbl(i).fax;
266: p_vendor_contact_rec.inactive_date := p_pos_supplier_contact_bo_tbl(i)
267: .inactive_date;
268: p_vendor_contact_rec.mail_stop := p_pos_supplier_contact_bo_tbl(i)
269: .mail_stop;
270: p_vendor_contact_rec.operating_unit_name := p_pos_supplier_contact_bo_tbl(i)
264: .fax_area_code;
265: p_vendor_contact_rec.fax_phone := p_pos_supplier_contact_bo_tbl(i).fax;
266: p_vendor_contact_rec.inactive_date := p_pos_supplier_contact_bo_tbl(i)
267: .inactive_date;
268: p_vendor_contact_rec.mail_stop := p_pos_supplier_contact_bo_tbl(i)
269: .mail_stop;
270: p_vendor_contact_rec.operating_unit_name := p_pos_supplier_contact_bo_tbl(i)
271: .operating_unit_name;
272: p_vendor_contact_rec.org_contact_id := p_pos_supplier_contact_bo_tbl(i)
266: p_vendor_contact_rec.inactive_date := p_pos_supplier_contact_bo_tbl(i)
267: .inactive_date;
268: p_vendor_contact_rec.mail_stop := p_pos_supplier_contact_bo_tbl(i)
269: .mail_stop;
270: p_vendor_contact_rec.operating_unit_name := p_pos_supplier_contact_bo_tbl(i)
271: .operating_unit_name;
272: p_vendor_contact_rec.org_contact_id := p_pos_supplier_contact_bo_tbl(i)
273: .org_contact_id;
274: p_vendor_contact_rec.org_id := p_pos_supplier_contact_bo_tbl(i)
268: p_vendor_contact_rec.mail_stop := p_pos_supplier_contact_bo_tbl(i)
269: .mail_stop;
270: p_vendor_contact_rec.operating_unit_name := p_pos_supplier_contact_bo_tbl(i)
271: .operating_unit_name;
272: p_vendor_contact_rec.org_contact_id := p_pos_supplier_contact_bo_tbl(i)
273: .org_contact_id;
274: p_vendor_contact_rec.org_id := p_pos_supplier_contact_bo_tbl(i)
275: .org_id;
276:
270: p_vendor_contact_rec.operating_unit_name := p_pos_supplier_contact_bo_tbl(i)
271: .operating_unit_name;
272: p_vendor_contact_rec.org_contact_id := p_pos_supplier_contact_bo_tbl(i)
273: .org_contact_id;
274: p_vendor_contact_rec.org_id := p_pos_supplier_contact_bo_tbl(i)
275: .org_id;
276:
277: p_vendor_contact_rec.org_party_site_id := p_pos_supplier_contact_bo_tbl(i)
278: .org_party_site_id;
273: .org_contact_id;
274: p_vendor_contact_rec.org_id := p_pos_supplier_contact_bo_tbl(i)
275: .org_id;
276:
277: p_vendor_contact_rec.org_party_site_id := p_pos_supplier_contact_bo_tbl(i)
278: .org_party_site_id;
279: p_vendor_contact_rec.organization_name_phonetic := p_pos_supplier_contact_bo_tbl(i)
280: .organization_name_phonetic;
281: p_vendor_contact_rec.party_number := p_pos_supplier_contact_bo_tbl(i)
275: .org_id;
276:
277: p_vendor_contact_rec.org_party_site_id := p_pos_supplier_contact_bo_tbl(i)
278: .org_party_site_id;
279: p_vendor_contact_rec.organization_name_phonetic := p_pos_supplier_contact_bo_tbl(i)
280: .organization_name_phonetic;
281: p_vendor_contact_rec.party_number := p_pos_supplier_contact_bo_tbl(i)
282: .party_number;
283: p_vendor_contact_rec.party_site_id := p_pos_supplier_contact_bo_tbl(i)
277: p_vendor_contact_rec.org_party_site_id := p_pos_supplier_contact_bo_tbl(i)
278: .org_party_site_id;
279: p_vendor_contact_rec.organization_name_phonetic := p_pos_supplier_contact_bo_tbl(i)
280: .organization_name_phonetic;
281: p_vendor_contact_rec.party_number := p_pos_supplier_contact_bo_tbl(i)
282: .party_number;
283: p_vendor_contact_rec.party_site_id := p_pos_supplier_contact_bo_tbl(i)
284: .party_site_id;
285: p_vendor_contact_rec.party_site_name := p_pos_supplier_contact_bo_tbl(i)
279: p_vendor_contact_rec.organization_name_phonetic := p_pos_supplier_contact_bo_tbl(i)
280: .organization_name_phonetic;
281: p_vendor_contact_rec.party_number := p_pos_supplier_contact_bo_tbl(i)
282: .party_number;
283: p_vendor_contact_rec.party_site_id := p_pos_supplier_contact_bo_tbl(i)
284: .party_site_id;
285: p_vendor_contact_rec.party_site_name := p_pos_supplier_contact_bo_tbl(i)
286: .party_site_name;
287: /* Suchita Change */
281: p_vendor_contact_rec.party_number := p_pos_supplier_contact_bo_tbl(i)
282: .party_number;
283: p_vendor_contact_rec.party_site_id := p_pos_supplier_contact_bo_tbl(i)
284: .party_site_id;
285: p_vendor_contact_rec.party_site_name := p_pos_supplier_contact_bo_tbl(i)
286: .party_site_name;
287: /* Suchita Change */
288: IF (p_pos_supplier_contact_bo_tbl(i).per_party_id IS NULL) THEN
289: l_per_party_id := pos_supplier_bo_dep_pkg.get_party_id(p_pos_supplier_contact_bo_tbl(i)
284: .party_site_id;
285: p_vendor_contact_rec.party_site_name := p_pos_supplier_contact_bo_tbl(i)
286: .party_site_name;
287: /* Suchita Change */
288: IF (p_pos_supplier_contact_bo_tbl(i).per_party_id IS NULL) THEN
289: l_per_party_id := pos_supplier_bo_dep_pkg.get_party_id(p_pos_supplier_contact_bo_tbl(i)
290: .per_orig_system,
291: p_pos_supplier_contact_bo_tbl(i)
292: .per_orig_system_ref);
285: p_vendor_contact_rec.party_site_name := p_pos_supplier_contact_bo_tbl(i)
286: .party_site_name;
287: /* Suchita Change */
288: IF (p_pos_supplier_contact_bo_tbl(i).per_party_id IS NULL) THEN
289: l_per_party_id := pos_supplier_bo_dep_pkg.get_party_id(p_pos_supplier_contact_bo_tbl(i)
290: .per_orig_system,
291: p_pos_supplier_contact_bo_tbl(i)
292: .per_orig_system_ref);
293: ELSE
287: /* Suchita Change */
288: IF (p_pos_supplier_contact_bo_tbl(i).per_party_id IS NULL) THEN
289: l_per_party_id := pos_supplier_bo_dep_pkg.get_party_id(p_pos_supplier_contact_bo_tbl(i)
290: .per_orig_system,
291: p_pos_supplier_contact_bo_tbl(i)
292: .per_orig_system_ref);
293: ELSE
294: l_per_party_id := p_pos_supplier_contact_bo_tbl(i).per_party_id;
295: END IF;
290: .per_orig_system,
291: p_pos_supplier_contact_bo_tbl(i)
292: .per_orig_system_ref);
293: ELSE
294: l_per_party_id := p_pos_supplier_contact_bo_tbl(i).per_party_id;
295: END IF;
296:
297: IF (l_per_party_id = 0) THEN
298: x_return_status := fnd_api.g_ret_sts_error;
302: END IF;
303:
304: p_vendor_contact_rec.per_party_id := l_per_party_id;
305:
306: p_vendor_contact_rec.person_first_name := p_pos_supplier_contact_bo_tbl(i)
307: .first_name;
308: p_vendor_contact_rec.person_first_name_phonetic := p_pos_supplier_contact_bo_tbl(i)
309: .first_name_alt;
310: p_vendor_contact_rec.person_last_name := p_pos_supplier_contact_bo_tbl(i)
304: p_vendor_contact_rec.per_party_id := l_per_party_id;
305:
306: p_vendor_contact_rec.person_first_name := p_pos_supplier_contact_bo_tbl(i)
307: .first_name;
308: p_vendor_contact_rec.person_first_name_phonetic := p_pos_supplier_contact_bo_tbl(i)
309: .first_name_alt;
310: p_vendor_contact_rec.person_last_name := p_pos_supplier_contact_bo_tbl(i)
311: .last_name;
312: p_vendor_contact_rec.person_last_name_phonetic := p_pos_supplier_contact_bo_tbl(i)
306: p_vendor_contact_rec.person_first_name := p_pos_supplier_contact_bo_tbl(i)
307: .first_name;
308: p_vendor_contact_rec.person_first_name_phonetic := p_pos_supplier_contact_bo_tbl(i)
309: .first_name_alt;
310: p_vendor_contact_rec.person_last_name := p_pos_supplier_contact_bo_tbl(i)
311: .last_name;
312: p_vendor_contact_rec.person_last_name_phonetic := p_pos_supplier_contact_bo_tbl(i)
313: .last_name_alt;
314: p_vendor_contact_rec.person_middle_name := p_pos_supplier_contact_bo_tbl(i)
308: p_vendor_contact_rec.person_first_name_phonetic := p_pos_supplier_contact_bo_tbl(i)
309: .first_name_alt;
310: p_vendor_contact_rec.person_last_name := p_pos_supplier_contact_bo_tbl(i)
311: .last_name;
312: p_vendor_contact_rec.person_last_name_phonetic := p_pos_supplier_contact_bo_tbl(i)
313: .last_name_alt;
314: p_vendor_contact_rec.person_middle_name := p_pos_supplier_contact_bo_tbl(i)
315: .middle_name;
316: p_vendor_contact_rec.person_title := p_pos_supplier_contact_bo_tbl(i)
310: p_vendor_contact_rec.person_last_name := p_pos_supplier_contact_bo_tbl(i)
311: .last_name;
312: p_vendor_contact_rec.person_last_name_phonetic := p_pos_supplier_contact_bo_tbl(i)
313: .last_name_alt;
314: p_vendor_contact_rec.person_middle_name := p_pos_supplier_contact_bo_tbl(i)
315: .middle_name;
316: p_vendor_contact_rec.person_title := p_pos_supplier_contact_bo_tbl(i)
317: .title;
318: p_vendor_contact_rec.phone := p_pos_supplier_contact_bo_tbl(i)
312: p_vendor_contact_rec.person_last_name_phonetic := p_pos_supplier_contact_bo_tbl(i)
313: .last_name_alt;
314: p_vendor_contact_rec.person_middle_name := p_pos_supplier_contact_bo_tbl(i)
315: .middle_name;
316: p_vendor_contact_rec.person_title := p_pos_supplier_contact_bo_tbl(i)
317: .title;
318: p_vendor_contact_rec.phone := p_pos_supplier_contact_bo_tbl(i)
319: .phone;
320:
314: p_vendor_contact_rec.person_middle_name := p_pos_supplier_contact_bo_tbl(i)
315: .middle_name;
316: p_vendor_contact_rec.person_title := p_pos_supplier_contact_bo_tbl(i)
317: .title;
318: p_vendor_contact_rec.phone := p_pos_supplier_contact_bo_tbl(i)
319: .phone;
320:
321: p_vendor_contact_rec.prefix := p_pos_supplier_contact_bo_tbl(i)
322: .prefix;
317: .title;
318: p_vendor_contact_rec.phone := p_pos_supplier_contact_bo_tbl(i)
319: .phone;
320:
321: p_vendor_contact_rec.prefix := p_pos_supplier_contact_bo_tbl(i)
322: .prefix;
323: p_vendor_contact_rec.rel_party_id := p_pos_supplier_contact_bo_tbl(i)
324: .rel_party_id;
325: p_vendor_contact_rec.relationship_id := p_pos_supplier_contact_bo_tbl(i)
319: .phone;
320:
321: p_vendor_contact_rec.prefix := p_pos_supplier_contact_bo_tbl(i)
322: .prefix;
323: p_vendor_contact_rec.rel_party_id := p_pos_supplier_contact_bo_tbl(i)
324: .rel_party_id;
325: p_vendor_contact_rec.relationship_id := p_pos_supplier_contact_bo_tbl(i)
326: .relationship_id;
327: p_vendor_contact_rec.url := p_pos_supplier_contact_bo_tbl(i).url;
321: p_vendor_contact_rec.prefix := p_pos_supplier_contact_bo_tbl(i)
322: .prefix;
323: p_vendor_contact_rec.rel_party_id := p_pos_supplier_contact_bo_tbl(i)
324: .rel_party_id;
325: p_vendor_contact_rec.relationship_id := p_pos_supplier_contact_bo_tbl(i)
326: .relationship_id;
327: p_vendor_contact_rec.url := p_pos_supplier_contact_bo_tbl(i).url;
328: p_vendor_contact_rec.vendor_contact_id := p_pos_supplier_contact_bo_tbl(i)
329: .vendor_contact_id;
323: p_vendor_contact_rec.rel_party_id := p_pos_supplier_contact_bo_tbl(i)
324: .rel_party_id;
325: p_vendor_contact_rec.relationship_id := p_pos_supplier_contact_bo_tbl(i)
326: .relationship_id;
327: p_vendor_contact_rec.url := p_pos_supplier_contact_bo_tbl(i).url;
328: p_vendor_contact_rec.vendor_contact_id := p_pos_supplier_contact_bo_tbl(i)
329: .vendor_contact_id;
330: p_vendor_contact_rec.vendor_contact_interface_id := p_pos_supplier_contact_bo_tbl(i)
331: .vendor_contact_interface_id;
324: .rel_party_id;
325: p_vendor_contact_rec.relationship_id := p_pos_supplier_contact_bo_tbl(i)
326: .relationship_id;
327: p_vendor_contact_rec.url := p_pos_supplier_contact_bo_tbl(i).url;
328: p_vendor_contact_rec.vendor_contact_id := p_pos_supplier_contact_bo_tbl(i)
329: .vendor_contact_id;
330: p_vendor_contact_rec.vendor_contact_interface_id := p_pos_supplier_contact_bo_tbl(i)
331: .vendor_contact_interface_id;
332: p_vendor_contact_rec.vendor_id := p_pos_supplier_contact_bo_tbl(i)
326: .relationship_id;
327: p_vendor_contact_rec.url := p_pos_supplier_contact_bo_tbl(i).url;
328: p_vendor_contact_rec.vendor_contact_id := p_pos_supplier_contact_bo_tbl(i)
329: .vendor_contact_id;
330: p_vendor_contact_rec.vendor_contact_interface_id := p_pos_supplier_contact_bo_tbl(i)
331: .vendor_contact_interface_id;
332: p_vendor_contact_rec.vendor_id := p_pos_supplier_contact_bo_tbl(i)
333: .vendor_id;
334:
328: p_vendor_contact_rec.vendor_contact_id := p_pos_supplier_contact_bo_tbl(i)
329: .vendor_contact_id;
330: p_vendor_contact_rec.vendor_contact_interface_id := p_pos_supplier_contact_bo_tbl(i)
331: .vendor_contact_interface_id;
332: p_vendor_contact_rec.vendor_id := p_pos_supplier_contact_bo_tbl(i)
333: .vendor_id;
334:
335: p_vendor_contact_rec.vendor_interface_id := p_pos_supplier_contact_bo_tbl(i)
336: .vendor_interface_id;
331: .vendor_contact_interface_id;
332: p_vendor_contact_rec.vendor_id := p_pos_supplier_contact_bo_tbl(i)
333: .vendor_id;
334:
335: p_vendor_contact_rec.vendor_interface_id := p_pos_supplier_contact_bo_tbl(i)
336: .vendor_interface_id;
337: p_vendor_contact_rec.vendor_site_code := p_pos_supplier_contact_bo_tbl(i)
338: .vendor_site_code;
339: p_vendor_contact_rec.vendor_site_id := p_pos_supplier_contact_bo_tbl(i)
333: .vendor_id;
334:
335: p_vendor_contact_rec.vendor_interface_id := p_pos_supplier_contact_bo_tbl(i)
336: .vendor_interface_id;
337: p_vendor_contact_rec.vendor_site_code := p_pos_supplier_contact_bo_tbl(i)
338: .vendor_site_code;
339: p_vendor_contact_rec.vendor_site_id := p_pos_supplier_contact_bo_tbl(i)
340: .vendor_site_id;
341:
335: p_vendor_contact_rec.vendor_interface_id := p_pos_supplier_contact_bo_tbl(i)
336: .vendor_interface_id;
337: p_vendor_contact_rec.vendor_site_code := p_pos_supplier_contact_bo_tbl(i)
338: .vendor_site_code;
339: p_vendor_contact_rec.vendor_site_id := p_pos_supplier_contact_bo_tbl(i)
340: .vendor_site_id;
341:
342: IF (p_vendor_contact_rec.vendor_id IS NULL) THEN
343: BEGIN