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.AP_VENDOR_PUB_PKG dependencies on AP_SUPPLIER_CONTACTS

Line 321: PERSON_FIRST_NAME AP_SUPPLIER_CONTACTS.FIRST_NAME%TYPE,

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

Line 322: PERSON_MIDDLE_NAME AP_SUPPLIER_CONTACTS.MIDDLE_NAME%TYPE,

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,

Line 323: PERSON_LAST_NAME AP_SUPPLIER_CONTACTS.LAST_NAME%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,

Line 324: PERSON_TITLE AP_SUPPLIER_CONTACTS.TITLE%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,

Line 326: PERSON_FIRST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.FIRST_NAME_ALT%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,

Line 327: PERSON_LAST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.LAST_NAME_ALT%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,

Line 328: ATTRIBUTE_CATEGORY AP_SUPPLIER_CONTACTS.ATTRIBUTE_CATEGORY%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,

Line 329: ATTRIBUTE1 AP_SUPPLIER_CONTACTS.ATTRIBUTE1%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,

Line 330: ATTRIBUTE2 AP_SUPPLIER_CONTACTS.ATTRIBUTE2%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,

Line 331: ATTRIBUTE3 AP_SUPPLIER_CONTACTS.ATTRIBUTE3%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,

Line 332: ATTRIBUTE4 AP_SUPPLIER_CONTACTS.ATTRIBUTE4%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,

Line 333: ATTRIBUTE5 AP_SUPPLIER_CONTACTS.ATTRIBUTE5%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,

Line 334: ATTRIBUTE6 AP_SUPPLIER_CONTACTS.ATTRIBUTE6%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,

Line 335: ATTRIBUTE7 AP_SUPPLIER_CONTACTS.ATTRIBUTE7%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,

Line 336: ATTRIBUTE8 AP_SUPPLIER_CONTACTS.ATTRIBUTE8%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,

Line 337: ATTRIBUTE9 AP_SUPPLIER_CONTACTS.ATTRIBUTE9%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,

Line 338: ATTRIBUTE10 AP_SUPPLIER_CONTACTS.ATTRIBUTE10%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,

Line 339: ATTRIBUTE11 AP_SUPPLIER_CONTACTS.ATTRIBUTE11%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,

Line 340: ATTRIBUTE12 AP_SUPPLIER_CONTACTS.ATTRIBUTE12%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,

Line 341: ATTRIBUTE13 AP_SUPPLIER_CONTACTS.ATTRIBUTE13%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),

Line 342: ATTRIBUTE14 AP_SUPPLIER_CONTACTS.ATTRIBUTE14%TYPE,

338: ATTRIBUTE10 AP_SUPPLIER_CONTACTS.ATTRIBUTE10%TYPE,
339: ATTRIBUTE11 AP_SUPPLIER_CONTACTS.ATTRIBUTE11%TYPE,
340: ATTRIBUTE12 AP_SUPPLIER_CONTACTS.ATTRIBUTE12%TYPE,
341: ATTRIBUTE13 AP_SUPPLIER_CONTACTS.ATTRIBUTE13%TYPE,
342: ATTRIBUTE14 AP_SUPPLIER_CONTACTS.ATTRIBUTE14%TYPE,
343: ATTRIBUTE15 AP_SUPPLIER_CONTACTS.ATTRIBUTE15%TYPE,
344: INACTIVE_DATE AP_SUPPLIER_CONTACTS.INACTIVE_DATE%TYPE,
345: PARTY_NUMBER VARCHAR2(30),
346: DEPARTMENT AP_SUPPLIER_CONTACTS.DEPARTMENT%TYPE,

Line 343: ATTRIBUTE15 AP_SUPPLIER_CONTACTS.ATTRIBUTE15%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,

Line 344: INACTIVE_DATE AP_SUPPLIER_CONTACTS.INACTIVE_DATE%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,

Line 346: DEPARTMENT AP_SUPPLIER_CONTACTS.DEPARTMENT%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,

Line 347: MAIL_STOP AP_SUPPLIER_CONTACTS.MAIL_STOP%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,

Line 348: AREA_CODE AP_SUPPLIER_CONTACTS.AREA_CODE%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,

Line 349: PHONE AP_SUPPLIER_CONTACTS.PHONE%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,

Line 350: ALT_AREA_CODE AP_SUPPLIER_CONTACTS.ALT_AREA_CODE%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,

Line 351: ALT_PHONE AP_SUPPLIER_CONTACTS.ALT_PHONE%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,

Line 352: FAX_AREA_CODE AP_SUPPLIER_CONTACTS.FAX_AREA_CODE%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,

Line 353: FAX_PHONE AP_SUPPLIER_CONTACTS.FAX%TYPE,

349: PHONE AP_SUPPLIER_CONTACTS.PHONE%TYPE,
350: ALT_AREA_CODE AP_SUPPLIER_CONTACTS.ALT_AREA_CODE%TYPE,
351: ALT_PHONE AP_SUPPLIER_CONTACTS.ALT_PHONE%TYPE,
352: FAX_AREA_CODE AP_SUPPLIER_CONTACTS.FAX_AREA_CODE%TYPE,
353: FAX_PHONE AP_SUPPLIER_CONTACTS.FAX%TYPE,
354: EMAIL_ADDRESS AP_SUPPLIER_CONTACTS.EMAIL_ADDRESS%TYPE,
355: URL AP_SUPPLIER_CONTACTS.URL%TYPE,
356: VENDOR_CONTACT_INTERFACE_ID NUMBER,
357: VENDOR_INTERFACE_ID NUMBER,

Line 354: EMAIL_ADDRESS AP_SUPPLIER_CONTACTS.EMAIL_ADDRESS%TYPE,

350: ALT_AREA_CODE AP_SUPPLIER_CONTACTS.ALT_AREA_CODE%TYPE,
351: ALT_PHONE AP_SUPPLIER_CONTACTS.ALT_PHONE%TYPE,
352: FAX_AREA_CODE AP_SUPPLIER_CONTACTS.FAX_AREA_CODE%TYPE,
353: FAX_PHONE AP_SUPPLIER_CONTACTS.FAX%TYPE,
354: EMAIL_ADDRESS AP_SUPPLIER_CONTACTS.EMAIL_ADDRESS%TYPE,
355: URL AP_SUPPLIER_CONTACTS.URL%TYPE,
356: VENDOR_CONTACT_INTERFACE_ID NUMBER,
357: VENDOR_INTERFACE_ID NUMBER,
358: VENDOR_SITE_CODE AP_SUP_SITE_CONTACT_INT.VENDOR_SITE_CODE%TYPE,

Line 355: URL AP_SUPPLIER_CONTACTS.URL%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,

Line 995: -- assignments contacts in AP_SUPPLIER_CONTACTS

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: --