317: REL_PARTY_ID NUMBER,
318: PARTY_SITE_ID NUMBER,
319: ORG_CONTACT_ID NUMBER,
320: ORG_PARTY_SITE_ID NUMBER,
321: PERSON_FIRST_NAME AP_SUPPLIER_CONTACTS.FIRST_NAME%TYPE,
322: PERSON_MIDDLE_NAME AP_SUPPLIER_CONTACTS.MIDDLE_NAME%TYPE,
323: PERSON_LAST_NAME AP_SUPPLIER_CONTACTS.LAST_NAME%TYPE,
324: PERSON_TITLE AP_SUPPLIER_CONTACTS.TITLE%TYPE,
325: ORGANIZATION_NAME_PHONETIC VARCHAR2(320),
318: PARTY_SITE_ID NUMBER,
319: ORG_CONTACT_ID NUMBER,
320: ORG_PARTY_SITE_ID NUMBER,
321: PERSON_FIRST_NAME AP_SUPPLIER_CONTACTS.FIRST_NAME%TYPE,
322: PERSON_MIDDLE_NAME AP_SUPPLIER_CONTACTS.MIDDLE_NAME%TYPE,
323: PERSON_LAST_NAME AP_SUPPLIER_CONTACTS.LAST_NAME%TYPE,
324: PERSON_TITLE AP_SUPPLIER_CONTACTS.TITLE%TYPE,
325: ORGANIZATION_NAME_PHONETIC VARCHAR2(320),
326: PERSON_FIRST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.FIRST_NAME_ALT%TYPE,
319: ORG_CONTACT_ID NUMBER,
320: ORG_PARTY_SITE_ID NUMBER,
321: PERSON_FIRST_NAME AP_SUPPLIER_CONTACTS.FIRST_NAME%TYPE,
322: PERSON_MIDDLE_NAME AP_SUPPLIER_CONTACTS.MIDDLE_NAME%TYPE,
323: PERSON_LAST_NAME AP_SUPPLIER_CONTACTS.LAST_NAME%TYPE,
324: PERSON_TITLE AP_SUPPLIER_CONTACTS.TITLE%TYPE,
325: ORGANIZATION_NAME_PHONETIC VARCHAR2(320),
326: PERSON_FIRST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.FIRST_NAME_ALT%TYPE,
327: PERSON_LAST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.LAST_NAME_ALT%TYPE,
320: ORG_PARTY_SITE_ID NUMBER,
321: PERSON_FIRST_NAME AP_SUPPLIER_CONTACTS.FIRST_NAME%TYPE,
322: PERSON_MIDDLE_NAME AP_SUPPLIER_CONTACTS.MIDDLE_NAME%TYPE,
323: PERSON_LAST_NAME AP_SUPPLIER_CONTACTS.LAST_NAME%TYPE,
324: PERSON_TITLE AP_SUPPLIER_CONTACTS.TITLE%TYPE,
325: ORGANIZATION_NAME_PHONETIC VARCHAR2(320),
326: PERSON_FIRST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.FIRST_NAME_ALT%TYPE,
327: PERSON_LAST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.LAST_NAME_ALT%TYPE,
328: ATTRIBUTE_CATEGORY AP_SUPPLIER_CONTACTS.ATTRIBUTE_CATEGORY%TYPE,
322: PERSON_MIDDLE_NAME AP_SUPPLIER_CONTACTS.MIDDLE_NAME%TYPE,
323: PERSON_LAST_NAME AP_SUPPLIER_CONTACTS.LAST_NAME%TYPE,
324: PERSON_TITLE AP_SUPPLIER_CONTACTS.TITLE%TYPE,
325: ORGANIZATION_NAME_PHONETIC VARCHAR2(320),
326: PERSON_FIRST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.FIRST_NAME_ALT%TYPE,
327: PERSON_LAST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.LAST_NAME_ALT%TYPE,
328: ATTRIBUTE_CATEGORY AP_SUPPLIER_CONTACTS.ATTRIBUTE_CATEGORY%TYPE,
329: ATTRIBUTE1 AP_SUPPLIER_CONTACTS.ATTRIBUTE1%TYPE,
330: ATTRIBUTE2 AP_SUPPLIER_CONTACTS.ATTRIBUTE2%TYPE,
323: PERSON_LAST_NAME AP_SUPPLIER_CONTACTS.LAST_NAME%TYPE,
324: PERSON_TITLE AP_SUPPLIER_CONTACTS.TITLE%TYPE,
325: ORGANIZATION_NAME_PHONETIC VARCHAR2(320),
326: PERSON_FIRST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.FIRST_NAME_ALT%TYPE,
327: PERSON_LAST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.LAST_NAME_ALT%TYPE,
328: ATTRIBUTE_CATEGORY AP_SUPPLIER_CONTACTS.ATTRIBUTE_CATEGORY%TYPE,
329: ATTRIBUTE1 AP_SUPPLIER_CONTACTS.ATTRIBUTE1%TYPE,
330: ATTRIBUTE2 AP_SUPPLIER_CONTACTS.ATTRIBUTE2%TYPE,
331: ATTRIBUTE3 AP_SUPPLIER_CONTACTS.ATTRIBUTE3%TYPE,
324: PERSON_TITLE AP_SUPPLIER_CONTACTS.TITLE%TYPE,
325: ORGANIZATION_NAME_PHONETIC VARCHAR2(320),
326: PERSON_FIRST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.FIRST_NAME_ALT%TYPE,
327: PERSON_LAST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.LAST_NAME_ALT%TYPE,
328: ATTRIBUTE_CATEGORY AP_SUPPLIER_CONTACTS.ATTRIBUTE_CATEGORY%TYPE,
329: ATTRIBUTE1 AP_SUPPLIER_CONTACTS.ATTRIBUTE1%TYPE,
330: ATTRIBUTE2 AP_SUPPLIER_CONTACTS.ATTRIBUTE2%TYPE,
331: ATTRIBUTE3 AP_SUPPLIER_CONTACTS.ATTRIBUTE3%TYPE,
332: ATTRIBUTE4 AP_SUPPLIER_CONTACTS.ATTRIBUTE4%TYPE,
325: ORGANIZATION_NAME_PHONETIC VARCHAR2(320),
326: PERSON_FIRST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.FIRST_NAME_ALT%TYPE,
327: PERSON_LAST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.LAST_NAME_ALT%TYPE,
328: ATTRIBUTE_CATEGORY AP_SUPPLIER_CONTACTS.ATTRIBUTE_CATEGORY%TYPE,
329: ATTRIBUTE1 AP_SUPPLIER_CONTACTS.ATTRIBUTE1%TYPE,
330: ATTRIBUTE2 AP_SUPPLIER_CONTACTS.ATTRIBUTE2%TYPE,
331: ATTRIBUTE3 AP_SUPPLIER_CONTACTS.ATTRIBUTE3%TYPE,
332: ATTRIBUTE4 AP_SUPPLIER_CONTACTS.ATTRIBUTE4%TYPE,
333: ATTRIBUTE5 AP_SUPPLIER_CONTACTS.ATTRIBUTE5%TYPE,
326: PERSON_FIRST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.FIRST_NAME_ALT%TYPE,
327: PERSON_LAST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.LAST_NAME_ALT%TYPE,
328: ATTRIBUTE_CATEGORY AP_SUPPLIER_CONTACTS.ATTRIBUTE_CATEGORY%TYPE,
329: ATTRIBUTE1 AP_SUPPLIER_CONTACTS.ATTRIBUTE1%TYPE,
330: ATTRIBUTE2 AP_SUPPLIER_CONTACTS.ATTRIBUTE2%TYPE,
331: ATTRIBUTE3 AP_SUPPLIER_CONTACTS.ATTRIBUTE3%TYPE,
332: ATTRIBUTE4 AP_SUPPLIER_CONTACTS.ATTRIBUTE4%TYPE,
333: ATTRIBUTE5 AP_SUPPLIER_CONTACTS.ATTRIBUTE5%TYPE,
334: ATTRIBUTE6 AP_SUPPLIER_CONTACTS.ATTRIBUTE6%TYPE,
327: PERSON_LAST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.LAST_NAME_ALT%TYPE,
328: ATTRIBUTE_CATEGORY AP_SUPPLIER_CONTACTS.ATTRIBUTE_CATEGORY%TYPE,
329: ATTRIBUTE1 AP_SUPPLIER_CONTACTS.ATTRIBUTE1%TYPE,
330: ATTRIBUTE2 AP_SUPPLIER_CONTACTS.ATTRIBUTE2%TYPE,
331: ATTRIBUTE3 AP_SUPPLIER_CONTACTS.ATTRIBUTE3%TYPE,
332: ATTRIBUTE4 AP_SUPPLIER_CONTACTS.ATTRIBUTE4%TYPE,
333: ATTRIBUTE5 AP_SUPPLIER_CONTACTS.ATTRIBUTE5%TYPE,
334: ATTRIBUTE6 AP_SUPPLIER_CONTACTS.ATTRIBUTE6%TYPE,
335: ATTRIBUTE7 AP_SUPPLIER_CONTACTS.ATTRIBUTE7%TYPE,
328: ATTRIBUTE_CATEGORY AP_SUPPLIER_CONTACTS.ATTRIBUTE_CATEGORY%TYPE,
329: ATTRIBUTE1 AP_SUPPLIER_CONTACTS.ATTRIBUTE1%TYPE,
330: ATTRIBUTE2 AP_SUPPLIER_CONTACTS.ATTRIBUTE2%TYPE,
331: ATTRIBUTE3 AP_SUPPLIER_CONTACTS.ATTRIBUTE3%TYPE,
332: ATTRIBUTE4 AP_SUPPLIER_CONTACTS.ATTRIBUTE4%TYPE,
333: ATTRIBUTE5 AP_SUPPLIER_CONTACTS.ATTRIBUTE5%TYPE,
334: ATTRIBUTE6 AP_SUPPLIER_CONTACTS.ATTRIBUTE6%TYPE,
335: ATTRIBUTE7 AP_SUPPLIER_CONTACTS.ATTRIBUTE7%TYPE,
336: ATTRIBUTE8 AP_SUPPLIER_CONTACTS.ATTRIBUTE8%TYPE,
329: ATTRIBUTE1 AP_SUPPLIER_CONTACTS.ATTRIBUTE1%TYPE,
330: ATTRIBUTE2 AP_SUPPLIER_CONTACTS.ATTRIBUTE2%TYPE,
331: ATTRIBUTE3 AP_SUPPLIER_CONTACTS.ATTRIBUTE3%TYPE,
332: ATTRIBUTE4 AP_SUPPLIER_CONTACTS.ATTRIBUTE4%TYPE,
333: ATTRIBUTE5 AP_SUPPLIER_CONTACTS.ATTRIBUTE5%TYPE,
334: ATTRIBUTE6 AP_SUPPLIER_CONTACTS.ATTRIBUTE6%TYPE,
335: ATTRIBUTE7 AP_SUPPLIER_CONTACTS.ATTRIBUTE7%TYPE,
336: ATTRIBUTE8 AP_SUPPLIER_CONTACTS.ATTRIBUTE8%TYPE,
337: ATTRIBUTE9 AP_SUPPLIER_CONTACTS.ATTRIBUTE9%TYPE,
330: ATTRIBUTE2 AP_SUPPLIER_CONTACTS.ATTRIBUTE2%TYPE,
331: ATTRIBUTE3 AP_SUPPLIER_CONTACTS.ATTRIBUTE3%TYPE,
332: ATTRIBUTE4 AP_SUPPLIER_CONTACTS.ATTRIBUTE4%TYPE,
333: ATTRIBUTE5 AP_SUPPLIER_CONTACTS.ATTRIBUTE5%TYPE,
334: ATTRIBUTE6 AP_SUPPLIER_CONTACTS.ATTRIBUTE6%TYPE,
335: ATTRIBUTE7 AP_SUPPLIER_CONTACTS.ATTRIBUTE7%TYPE,
336: ATTRIBUTE8 AP_SUPPLIER_CONTACTS.ATTRIBUTE8%TYPE,
337: ATTRIBUTE9 AP_SUPPLIER_CONTACTS.ATTRIBUTE9%TYPE,
338: ATTRIBUTE10 AP_SUPPLIER_CONTACTS.ATTRIBUTE10%TYPE,
331: ATTRIBUTE3 AP_SUPPLIER_CONTACTS.ATTRIBUTE3%TYPE,
332: ATTRIBUTE4 AP_SUPPLIER_CONTACTS.ATTRIBUTE4%TYPE,
333: ATTRIBUTE5 AP_SUPPLIER_CONTACTS.ATTRIBUTE5%TYPE,
334: ATTRIBUTE6 AP_SUPPLIER_CONTACTS.ATTRIBUTE6%TYPE,
335: ATTRIBUTE7 AP_SUPPLIER_CONTACTS.ATTRIBUTE7%TYPE,
336: ATTRIBUTE8 AP_SUPPLIER_CONTACTS.ATTRIBUTE8%TYPE,
337: ATTRIBUTE9 AP_SUPPLIER_CONTACTS.ATTRIBUTE9%TYPE,
338: ATTRIBUTE10 AP_SUPPLIER_CONTACTS.ATTRIBUTE10%TYPE,
339: ATTRIBUTE11 AP_SUPPLIER_CONTACTS.ATTRIBUTE11%TYPE,
332: ATTRIBUTE4 AP_SUPPLIER_CONTACTS.ATTRIBUTE4%TYPE,
333: ATTRIBUTE5 AP_SUPPLIER_CONTACTS.ATTRIBUTE5%TYPE,
334: ATTRIBUTE6 AP_SUPPLIER_CONTACTS.ATTRIBUTE6%TYPE,
335: ATTRIBUTE7 AP_SUPPLIER_CONTACTS.ATTRIBUTE7%TYPE,
336: ATTRIBUTE8 AP_SUPPLIER_CONTACTS.ATTRIBUTE8%TYPE,
337: ATTRIBUTE9 AP_SUPPLIER_CONTACTS.ATTRIBUTE9%TYPE,
338: ATTRIBUTE10 AP_SUPPLIER_CONTACTS.ATTRIBUTE10%TYPE,
339: ATTRIBUTE11 AP_SUPPLIER_CONTACTS.ATTRIBUTE11%TYPE,
340: ATTRIBUTE12 AP_SUPPLIER_CONTACTS.ATTRIBUTE12%TYPE,
333: ATTRIBUTE5 AP_SUPPLIER_CONTACTS.ATTRIBUTE5%TYPE,
334: ATTRIBUTE6 AP_SUPPLIER_CONTACTS.ATTRIBUTE6%TYPE,
335: ATTRIBUTE7 AP_SUPPLIER_CONTACTS.ATTRIBUTE7%TYPE,
336: ATTRIBUTE8 AP_SUPPLIER_CONTACTS.ATTRIBUTE8%TYPE,
337: ATTRIBUTE9 AP_SUPPLIER_CONTACTS.ATTRIBUTE9%TYPE,
338: ATTRIBUTE10 AP_SUPPLIER_CONTACTS.ATTRIBUTE10%TYPE,
339: ATTRIBUTE11 AP_SUPPLIER_CONTACTS.ATTRIBUTE11%TYPE,
340: ATTRIBUTE12 AP_SUPPLIER_CONTACTS.ATTRIBUTE12%TYPE,
341: ATTRIBUTE13 AP_SUPPLIER_CONTACTS.ATTRIBUTE13%TYPE,
334: ATTRIBUTE6 AP_SUPPLIER_CONTACTS.ATTRIBUTE6%TYPE,
335: ATTRIBUTE7 AP_SUPPLIER_CONTACTS.ATTRIBUTE7%TYPE,
336: ATTRIBUTE8 AP_SUPPLIER_CONTACTS.ATTRIBUTE8%TYPE,
337: ATTRIBUTE9 AP_SUPPLIER_CONTACTS.ATTRIBUTE9%TYPE,
338: ATTRIBUTE10 AP_SUPPLIER_CONTACTS.ATTRIBUTE10%TYPE,
339: ATTRIBUTE11 AP_SUPPLIER_CONTACTS.ATTRIBUTE11%TYPE,
340: ATTRIBUTE12 AP_SUPPLIER_CONTACTS.ATTRIBUTE12%TYPE,
341: ATTRIBUTE13 AP_SUPPLIER_CONTACTS.ATTRIBUTE13%TYPE,
342: ATTRIBUTE14 AP_SUPPLIER_CONTACTS.ATTRIBUTE14%TYPE,
335: ATTRIBUTE7 AP_SUPPLIER_CONTACTS.ATTRIBUTE7%TYPE,
336: ATTRIBUTE8 AP_SUPPLIER_CONTACTS.ATTRIBUTE8%TYPE,
337: ATTRIBUTE9 AP_SUPPLIER_CONTACTS.ATTRIBUTE9%TYPE,
338: ATTRIBUTE10 AP_SUPPLIER_CONTACTS.ATTRIBUTE10%TYPE,
339: ATTRIBUTE11 AP_SUPPLIER_CONTACTS.ATTRIBUTE11%TYPE,
340: ATTRIBUTE12 AP_SUPPLIER_CONTACTS.ATTRIBUTE12%TYPE,
341: ATTRIBUTE13 AP_SUPPLIER_CONTACTS.ATTRIBUTE13%TYPE,
342: ATTRIBUTE14 AP_SUPPLIER_CONTACTS.ATTRIBUTE14%TYPE,
343: ATTRIBUTE15 AP_SUPPLIER_CONTACTS.ATTRIBUTE15%TYPE,
336: ATTRIBUTE8 AP_SUPPLIER_CONTACTS.ATTRIBUTE8%TYPE,
337: ATTRIBUTE9 AP_SUPPLIER_CONTACTS.ATTRIBUTE9%TYPE,
338: ATTRIBUTE10 AP_SUPPLIER_CONTACTS.ATTRIBUTE10%TYPE,
339: ATTRIBUTE11 AP_SUPPLIER_CONTACTS.ATTRIBUTE11%TYPE,
340: ATTRIBUTE12 AP_SUPPLIER_CONTACTS.ATTRIBUTE12%TYPE,
341: ATTRIBUTE13 AP_SUPPLIER_CONTACTS.ATTRIBUTE13%TYPE,
342: ATTRIBUTE14 AP_SUPPLIER_CONTACTS.ATTRIBUTE14%TYPE,
343: ATTRIBUTE15 AP_SUPPLIER_CONTACTS.ATTRIBUTE15%TYPE,
344: INACTIVE_DATE AP_SUPPLIER_CONTACTS.INACTIVE_DATE%TYPE,
337: ATTRIBUTE9 AP_SUPPLIER_CONTACTS.ATTRIBUTE9%TYPE,
338: ATTRIBUTE10 AP_SUPPLIER_CONTACTS.ATTRIBUTE10%TYPE,
339: ATTRIBUTE11 AP_SUPPLIER_CONTACTS.ATTRIBUTE11%TYPE,
340: ATTRIBUTE12 AP_SUPPLIER_CONTACTS.ATTRIBUTE12%TYPE,
341: ATTRIBUTE13 AP_SUPPLIER_CONTACTS.ATTRIBUTE13%TYPE,
342: ATTRIBUTE14 AP_SUPPLIER_CONTACTS.ATTRIBUTE14%TYPE,
343: ATTRIBUTE15 AP_SUPPLIER_CONTACTS.ATTRIBUTE15%TYPE,
344: INACTIVE_DATE AP_SUPPLIER_CONTACTS.INACTIVE_DATE%TYPE,
345: PARTY_NUMBER VARCHAR2(30),
338: ATTRIBUTE10 AP_SUPPLIER_CONTACTS.ATTRIBUTE10%TYPE,
339: ATTRIBUTE11 AP_SUPPLIER_CONTACTS.ATTRIBUTE11%TYPE,
340: ATTRIBUTE12 AP_SUPPLIER_CONTACTS.ATTRIBUTE12%TYPE,
341: ATTRIBUTE13 AP_SUPPLIER_CONTACTS.ATTRIBUTE13%TYPE,
342: ATTRIBUTE14 AP_SUPPLIER_CONTACTS.ATTRIBUTE14%TYPE,
343: ATTRIBUTE15 AP_SUPPLIER_CONTACTS.ATTRIBUTE15%TYPE,
344: INACTIVE_DATE AP_SUPPLIER_CONTACTS.INACTIVE_DATE%TYPE,
345: PARTY_NUMBER VARCHAR2(30),
346: DEPARTMENT AP_SUPPLIER_CONTACTS.DEPARTMENT%TYPE,
339: ATTRIBUTE11 AP_SUPPLIER_CONTACTS.ATTRIBUTE11%TYPE,
340: ATTRIBUTE12 AP_SUPPLIER_CONTACTS.ATTRIBUTE12%TYPE,
341: ATTRIBUTE13 AP_SUPPLIER_CONTACTS.ATTRIBUTE13%TYPE,
342: ATTRIBUTE14 AP_SUPPLIER_CONTACTS.ATTRIBUTE14%TYPE,
343: ATTRIBUTE15 AP_SUPPLIER_CONTACTS.ATTRIBUTE15%TYPE,
344: INACTIVE_DATE AP_SUPPLIER_CONTACTS.INACTIVE_DATE%TYPE,
345: PARTY_NUMBER VARCHAR2(30),
346: DEPARTMENT AP_SUPPLIER_CONTACTS.DEPARTMENT%TYPE,
347: MAIL_STOP AP_SUPPLIER_CONTACTS.MAIL_STOP%TYPE,
340: ATTRIBUTE12 AP_SUPPLIER_CONTACTS.ATTRIBUTE12%TYPE,
341: ATTRIBUTE13 AP_SUPPLIER_CONTACTS.ATTRIBUTE13%TYPE,
342: ATTRIBUTE14 AP_SUPPLIER_CONTACTS.ATTRIBUTE14%TYPE,
343: ATTRIBUTE15 AP_SUPPLIER_CONTACTS.ATTRIBUTE15%TYPE,
344: INACTIVE_DATE AP_SUPPLIER_CONTACTS.INACTIVE_DATE%TYPE,
345: PARTY_NUMBER VARCHAR2(30),
346: DEPARTMENT AP_SUPPLIER_CONTACTS.DEPARTMENT%TYPE,
347: MAIL_STOP AP_SUPPLIER_CONTACTS.MAIL_STOP%TYPE,
348: AREA_CODE AP_SUPPLIER_CONTACTS.AREA_CODE%TYPE,
342: ATTRIBUTE14 AP_SUPPLIER_CONTACTS.ATTRIBUTE14%TYPE,
343: ATTRIBUTE15 AP_SUPPLIER_CONTACTS.ATTRIBUTE15%TYPE,
344: INACTIVE_DATE AP_SUPPLIER_CONTACTS.INACTIVE_DATE%TYPE,
345: PARTY_NUMBER VARCHAR2(30),
346: DEPARTMENT AP_SUPPLIER_CONTACTS.DEPARTMENT%TYPE,
347: MAIL_STOP AP_SUPPLIER_CONTACTS.MAIL_STOP%TYPE,
348: AREA_CODE AP_SUPPLIER_CONTACTS.AREA_CODE%TYPE,
349: PHONE AP_SUPPLIER_CONTACTS.PHONE%TYPE,
350: ALT_AREA_CODE AP_SUPPLIER_CONTACTS.ALT_AREA_CODE%TYPE,
343: ATTRIBUTE15 AP_SUPPLIER_CONTACTS.ATTRIBUTE15%TYPE,
344: INACTIVE_DATE AP_SUPPLIER_CONTACTS.INACTIVE_DATE%TYPE,
345: PARTY_NUMBER VARCHAR2(30),
346: DEPARTMENT AP_SUPPLIER_CONTACTS.DEPARTMENT%TYPE,
347: MAIL_STOP AP_SUPPLIER_CONTACTS.MAIL_STOP%TYPE,
348: AREA_CODE AP_SUPPLIER_CONTACTS.AREA_CODE%TYPE,
349: PHONE AP_SUPPLIER_CONTACTS.PHONE%TYPE,
350: ALT_AREA_CODE AP_SUPPLIER_CONTACTS.ALT_AREA_CODE%TYPE,
351: ALT_PHONE AP_SUPPLIER_CONTACTS.ALT_PHONE%TYPE,
344: INACTIVE_DATE AP_SUPPLIER_CONTACTS.INACTIVE_DATE%TYPE,
345: PARTY_NUMBER VARCHAR2(30),
346: DEPARTMENT AP_SUPPLIER_CONTACTS.DEPARTMENT%TYPE,
347: MAIL_STOP AP_SUPPLIER_CONTACTS.MAIL_STOP%TYPE,
348: AREA_CODE AP_SUPPLIER_CONTACTS.AREA_CODE%TYPE,
349: PHONE AP_SUPPLIER_CONTACTS.PHONE%TYPE,
350: ALT_AREA_CODE AP_SUPPLIER_CONTACTS.ALT_AREA_CODE%TYPE,
351: ALT_PHONE AP_SUPPLIER_CONTACTS.ALT_PHONE%TYPE,
352: FAX_AREA_CODE AP_SUPPLIER_CONTACTS.FAX_AREA_CODE%TYPE,
345: PARTY_NUMBER VARCHAR2(30),
346: DEPARTMENT AP_SUPPLIER_CONTACTS.DEPARTMENT%TYPE,
347: MAIL_STOP AP_SUPPLIER_CONTACTS.MAIL_STOP%TYPE,
348: AREA_CODE AP_SUPPLIER_CONTACTS.AREA_CODE%TYPE,
349: PHONE AP_SUPPLIER_CONTACTS.PHONE%TYPE,
350: ALT_AREA_CODE AP_SUPPLIER_CONTACTS.ALT_AREA_CODE%TYPE,
351: ALT_PHONE AP_SUPPLIER_CONTACTS.ALT_PHONE%TYPE,
352: FAX_AREA_CODE AP_SUPPLIER_CONTACTS.FAX_AREA_CODE%TYPE,
353: FAX_PHONE AP_SUPPLIER_CONTACTS.FAX%TYPE,
346: DEPARTMENT AP_SUPPLIER_CONTACTS.DEPARTMENT%TYPE,
347: MAIL_STOP AP_SUPPLIER_CONTACTS.MAIL_STOP%TYPE,
348: AREA_CODE AP_SUPPLIER_CONTACTS.AREA_CODE%TYPE,
349: PHONE AP_SUPPLIER_CONTACTS.PHONE%TYPE,
350: ALT_AREA_CODE AP_SUPPLIER_CONTACTS.ALT_AREA_CODE%TYPE,
351: ALT_PHONE AP_SUPPLIER_CONTACTS.ALT_PHONE%TYPE,
352: FAX_AREA_CODE AP_SUPPLIER_CONTACTS.FAX_AREA_CODE%TYPE,
353: FAX_PHONE AP_SUPPLIER_CONTACTS.FAX%TYPE,
354: EMAIL_ADDRESS AP_SUPPLIER_CONTACTS.EMAIL_ADDRESS%TYPE,
347: MAIL_STOP AP_SUPPLIER_CONTACTS.MAIL_STOP%TYPE,
348: AREA_CODE AP_SUPPLIER_CONTACTS.AREA_CODE%TYPE,
349: PHONE AP_SUPPLIER_CONTACTS.PHONE%TYPE,
350: ALT_AREA_CODE AP_SUPPLIER_CONTACTS.ALT_AREA_CODE%TYPE,
351: ALT_PHONE AP_SUPPLIER_CONTACTS.ALT_PHONE%TYPE,
352: FAX_AREA_CODE AP_SUPPLIER_CONTACTS.FAX_AREA_CODE%TYPE,
353: FAX_PHONE AP_SUPPLIER_CONTACTS.FAX%TYPE,
354: EMAIL_ADDRESS AP_SUPPLIER_CONTACTS.EMAIL_ADDRESS%TYPE,
355: URL AP_SUPPLIER_CONTACTS.URL%TYPE,
348: AREA_CODE AP_SUPPLIER_CONTACTS.AREA_CODE%TYPE,
349: PHONE AP_SUPPLIER_CONTACTS.PHONE%TYPE,
350: ALT_AREA_CODE AP_SUPPLIER_CONTACTS.ALT_AREA_CODE%TYPE,
351: ALT_PHONE AP_SUPPLIER_CONTACTS.ALT_PHONE%TYPE,
352: FAX_AREA_CODE AP_SUPPLIER_CONTACTS.FAX_AREA_CODE%TYPE,
353: FAX_PHONE AP_SUPPLIER_CONTACTS.FAX%TYPE,
354: EMAIL_ADDRESS AP_SUPPLIER_CONTACTS.EMAIL_ADDRESS%TYPE,
355: URL AP_SUPPLIER_CONTACTS.URL%TYPE,
356: VENDOR_CONTACT_INTERFACE_ID NUMBER,
349: PHONE AP_SUPPLIER_CONTACTS.PHONE%TYPE,
350: ALT_AREA_CODE AP_SUPPLIER_CONTACTS.ALT_AREA_CODE%TYPE,
351: ALT_PHONE AP_SUPPLIER_CONTACTS.ALT_PHONE%TYPE,
352: FAX_AREA_CODE AP_SUPPLIER_CONTACTS.FAX_AREA_CODE%TYPE,
353: FAX_PHONE AP_SUPPLIER_CONTACTS.FAX%TYPE,
354: EMAIL_ADDRESS AP_SUPPLIER_CONTACTS.EMAIL_ADDRESS%TYPE,
355: URL AP_SUPPLIER_CONTACTS.URL%TYPE,
356: VENDOR_CONTACT_INTERFACE_ID NUMBER,
357: VENDOR_INTERFACE_ID NUMBER,
350: ALT_AREA_CODE AP_SUPPLIER_CONTACTS.ALT_AREA_CODE%TYPE,
351: ALT_PHONE AP_SUPPLIER_CONTACTS.ALT_PHONE%TYPE,
352: FAX_AREA_CODE AP_SUPPLIER_CONTACTS.FAX_AREA_CODE%TYPE,
353: FAX_PHONE AP_SUPPLIER_CONTACTS.FAX%TYPE,
354: EMAIL_ADDRESS AP_SUPPLIER_CONTACTS.EMAIL_ADDRESS%TYPE,
355: URL AP_SUPPLIER_CONTACTS.URL%TYPE,
356: VENDOR_CONTACT_INTERFACE_ID NUMBER,
357: VENDOR_INTERFACE_ID NUMBER,
358: VENDOR_SITE_CODE AP_SUP_SITE_CONTACT_INT.VENDOR_SITE_CODE%TYPE,
351: ALT_PHONE AP_SUPPLIER_CONTACTS.ALT_PHONE%TYPE,
352: FAX_AREA_CODE AP_SUPPLIER_CONTACTS.FAX_AREA_CODE%TYPE,
353: FAX_PHONE AP_SUPPLIER_CONTACTS.FAX%TYPE,
354: EMAIL_ADDRESS AP_SUPPLIER_CONTACTS.EMAIL_ADDRESS%TYPE,
355: URL AP_SUPPLIER_CONTACTS.URL%TYPE,
356: VENDOR_CONTACT_INTERFACE_ID NUMBER,
357: VENDOR_INTERFACE_ID NUMBER,
358: VENDOR_SITE_CODE AP_SUP_SITE_CONTACT_INT.VENDOR_SITE_CODE%TYPE,
359: ORG_ID NUMBER,
991: --
992: -- Notes : Update Address Assignments DFF,called from various
993: -- features and other products,
994: -- This will update the DFF columns of the address
995: -- assignments contacts in AP_SUPPLIER_CONTACTS
996: -- The database values of Attribute_Category and
997: -- the Attributes 1-15, will be updated to whatever is
998: -- passed to the API and the default value is null.
999: --