eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_SUPPLIER_CONTACT_BO_PKG dependencies on POS_SUPPLIER_CONTACT_BO

Line 1: PACKAGE BODY pos_supplier_contact_bo_pkg AS

1: PACKAGE BODY pos_supplier_contact_bo_pkg AS
2: /* $Header: POSSPCONB.pls 120.1 2010/11/25 12:08:36 puppulur noship $ */
3: /*#
4: * Use this routine to get supplier contact
5: * @param p_api_version The version of API

Line 26: x_ap_supplier_contact_bo OUT NOCOPY pos_supplier_contact_bo_tbl,

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

Line 32: -- l_ap_supplier_contact_typ_tbl pos_supplier_contact_bo_tbl := pos_supplier_contact_bo_tbl();

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

Line 46: SELECT pos_supplier_contact_bo(apsc.vendor_contact_id,

42: ELSE
43: l_party_id := p_party_id;
44: END IF;
45:
46: SELECT pos_supplier_contact_bo(apsc.vendor_contact_id,
47: apsc.last_update_date,
48: apsc.last_updated_by,
49: apsc.vendor_site_id,
50: apsc.last_update_login,

Line 131: /* x_ap_supplier_contact_bo := pos_supplier_contact_bo(l_ap_supplier_contact_typ_tbl,

127: x_return_status,
128: x_msg_count,
129: x_msg_data);*/
130:
131: /* x_ap_supplier_contact_bo := pos_supplier_contact_bo(l_ap_supplier_contact_typ_tbl,
132: l_pos_supplier_uda_bo);*/
133: EXCEPTION
134: WHEN fnd_api.g_exc_error THEN
135:

Line 156: * @param p_pos_supplier_contact_bo_tbl The Supplier Contact BO table

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

Line 178: p_pos_supplier_contact_bo_tbl IN pos_supplier_contact_bo_tbl,

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,

Line 216: FOR i IN p_pos_supplier_contact_bo_tbl.first .. p_pos_supplier_contact_bo_tbl.last LOOP

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)

Line 218: p_vendor_contact_rec.alt_area_code := 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)

Line 220: p_vendor_contact_rec.alt_phone := 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)

Line 222: p_vendor_contact_rec.area_code := 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)

Line 224: p_vendor_contact_rec.attribute_category := 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)

Line 226: p_vendor_contact_rec.attribute1 := 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)

Line 228: p_vendor_contact_rec.attribute10 := 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)

Line 230: p_vendor_contact_rec.attribute11 := 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)

Line 232: p_vendor_contact_rec.attribute12 := 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)

Line 234: p_vendor_contact_rec.attribute13 := 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)

Line 236: p_vendor_contact_rec.attribute14 := 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)

Line 238: p_vendor_contact_rec.attribute15 := 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)

Line 240: p_vendor_contact_rec.attribute2 := 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)

Line 242: p_vendor_contact_rec.attribute3 := 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)

Line 244: p_vendor_contact_rec.attribute4 := 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)

Line 246: p_vendor_contact_rec.attribute5 := 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)

Line 248: p_vendor_contact_rec.attribute6 := 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)

Line 250: p_vendor_contact_rec.attribute7 := 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)

Line 252: p_vendor_contact_rec.attribute8 := 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)

Line 254: p_vendor_contact_rec.attribute9 := 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)

Line 256: p_vendor_contact_rec.contact_name_phonetic := 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)

Line 258: p_vendor_contact_rec.department := 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:

Line 260: p_vendor_contact_rec.email_address := p_pos_supplier_contact_bo_tbl(i)

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;

Line 263: p_vendor_contact_rec.fax_area_code := 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;
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;

Line 265: p_vendor_contact_rec.fax_phone := p_pos_supplier_contact_bo_tbl(i).fax;

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;

Line 266: p_vendor_contact_rec.inactive_date := p_pos_supplier_contact_bo_tbl(i)

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)

Line 268: p_vendor_contact_rec.mail_stop := 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)

Line 270: p_vendor_contact_rec.operating_unit_name := 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)

Line 272: p_vendor_contact_rec.org_contact_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:

Line 274: p_vendor_contact_rec.org_id := p_pos_supplier_contact_bo_tbl(i)

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;

Line 277: p_vendor_contact_rec.org_party_site_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;
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)

Line 279: p_vendor_contact_rec.organization_name_phonetic := 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)

Line 281: p_vendor_contact_rec.party_number := 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)

Line 283: p_vendor_contact_rec.party_site_id := 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 */

Line 285: p_vendor_contact_rec.party_site_name := p_pos_supplier_contact_bo_tbl(i)

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)

Line 288: IF (p_pos_supplier_contact_bo_tbl(i).per_party_id IS NULL) THEN

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

Line 289: l_per_party_id := pos_supplier_bo_dep_pkg.get_party_id(p_pos_supplier_contact_bo_tbl(i)

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

Line 291: p_pos_supplier_contact_bo_tbl(i)

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;

Line 294: l_per_party_id := p_pos_supplier_contact_bo_tbl(i).per_party_id;

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;

Line 306: p_vendor_contact_rec.person_first_name := p_pos_supplier_contact_bo_tbl(i)

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)

Line 308: p_vendor_contact_rec.person_first_name_phonetic := 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)

Line 310: p_vendor_contact_rec.person_last_name := 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)

Line 312: p_vendor_contact_rec.person_last_name_phonetic := 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)

Line 314: p_vendor_contact_rec.person_middle_name := 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)

Line 316: p_vendor_contact_rec.person_title := 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:

Line 318: p_vendor_contact_rec.phone := p_pos_supplier_contact_bo_tbl(i)

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;

Line 321: p_vendor_contact_rec.prefix := 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;
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)

Line 323: p_vendor_contact_rec.rel_party_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;

Line 325: p_vendor_contact_rec.relationship_id := p_pos_supplier_contact_bo_tbl(i)

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;

Line 327: p_vendor_contact_rec.url := p_pos_supplier_contact_bo_tbl(i).url;

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;

Line 328: p_vendor_contact_rec.vendor_contact_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;
332: p_vendor_contact_rec.vendor_id := p_pos_supplier_contact_bo_tbl(i)

Line 330: p_vendor_contact_rec.vendor_contact_interface_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:

Line 332: p_vendor_contact_rec.vendor_id := p_pos_supplier_contact_bo_tbl(i)

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;

Line 335: p_vendor_contact_rec.vendor_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;
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)

Line 337: p_vendor_contact_rec.vendor_site_code := 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:

Line 339: p_vendor_contact_rec.vendor_site_id := p_pos_supplier_contact_bo_tbl(i)

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

Line 428: 'pos_supplier_contact_bo_pkg.create_pos_supp_contact_bo',

424: -- succeed
425:
426: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
427: fnd_log.string(fnd_log.level_procedure,
428: 'pos_supplier_contact_bo_pkg.create_pos_supp_contact_bo',
429: l_step || ' x_return_status = ' || x_return_status ||
430: ' x_vendor_contact_id = ' || x_vendor_contact_id ||
431: ' x_per_party_id = ' || x_per_party_id ||
432: ' x_rel_party_id = ' || x_rel_party_id ||

Line 443: 'pos_supplier_contact_bo_pkg.create_pos_supp_contact_bo',

439:
440: --ROLLBACK TO upd_vndr_contact;
441: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
442: fnd_log.string(fnd_log.level_error,
443: 'pos_supplier_contact_bo_pkg.create_pos_supp_contact_bo',
444: l_step || ' x_return_status = ' || x_return_status ||
445: ', x_msg_count = ' || x_msg_count ||
446: ', x_msg_data = ' || x_msg_data);
447: END IF;

Line 519: 'pos_supplier_contact_bo_pkg.create_pos_supp_contact_bo',

515: x_return_status = fnd_api.g_ret_sts_success THEN
516: -- succeed
517: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
518: fnd_log.string(fnd_log.level_procedure,
519: 'pos_supplier_contact_bo_pkg.create_pos_supp_contact_bo',
520: l_step || ' x_return_status = ' ||
521: x_return_status || ' x_vendor_contact_id = ' ||
522: x_vendor_contact_id || ' x_per_party_id = ' ||
523: x_per_party_id || ' x_rel_party_id = ' ||

Line 533: 'pos_supplier_contact_bo_pkg.create_pos_supp_contact_bo',

529: -- failed
530: ROLLBACK TO upd_vndr_contact;
531: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
532: fnd_log.string(fnd_log.level_error,
533: 'pos_supplier_contact_bo_pkg.create_pos_supp_contact_bo',
534: l_step || ' x_return_status = ' ||
535: x_return_status || ', x_msg_count = ' ||
536: x_msg_count || ', x_msg_data = ' ||
537: x_msg_data);

Line 559: END pos_supplier_contact_bo_pkg;

555: x_msg_count := 1;
556: x_msg_data := SQLCODE || SQLERRM;
557: END update_pos_supp_contact_bo;
558: */
559: END pos_supplier_contact_bo_pkg;