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 346: PERSON_FIRST_NAME AP_SUPPLIER_CONTACTS.FIRST_NAME%TYPE,

342: REL_PARTY_ID NUMBER,
343: PARTY_SITE_ID NUMBER,
344: ORG_CONTACT_ID NUMBER,
345: ORG_PARTY_SITE_ID NUMBER,
346: PERSON_FIRST_NAME AP_SUPPLIER_CONTACTS.FIRST_NAME%TYPE,
347: PERSON_MIDDLE_NAME AP_SUPPLIER_CONTACTS.MIDDLE_NAME%TYPE,
348: PERSON_LAST_NAME AP_SUPPLIER_CONTACTS.LAST_NAME%TYPE,
349: PERSON_TITLE AP_SUPPLIER_CONTACTS.TITLE%TYPE,
350: ORGANIZATION_NAME_PHONETIC VARCHAR2(320),

Line 347: PERSON_MIDDLE_NAME AP_SUPPLIER_CONTACTS.MIDDLE_NAME%TYPE,

343: PARTY_SITE_ID NUMBER,
344: ORG_CONTACT_ID NUMBER,
345: ORG_PARTY_SITE_ID NUMBER,
346: PERSON_FIRST_NAME AP_SUPPLIER_CONTACTS.FIRST_NAME%TYPE,
347: PERSON_MIDDLE_NAME AP_SUPPLIER_CONTACTS.MIDDLE_NAME%TYPE,
348: PERSON_LAST_NAME AP_SUPPLIER_CONTACTS.LAST_NAME%TYPE,
349: PERSON_TITLE AP_SUPPLIER_CONTACTS.TITLE%TYPE,
350: ORGANIZATION_NAME_PHONETIC VARCHAR2(320),
351: PERSON_FIRST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.FIRST_NAME_ALT%TYPE,

Line 348: PERSON_LAST_NAME AP_SUPPLIER_CONTACTS.LAST_NAME%TYPE,

344: ORG_CONTACT_ID NUMBER,
345: ORG_PARTY_SITE_ID NUMBER,
346: PERSON_FIRST_NAME AP_SUPPLIER_CONTACTS.FIRST_NAME%TYPE,
347: PERSON_MIDDLE_NAME AP_SUPPLIER_CONTACTS.MIDDLE_NAME%TYPE,
348: PERSON_LAST_NAME AP_SUPPLIER_CONTACTS.LAST_NAME%TYPE,
349: PERSON_TITLE AP_SUPPLIER_CONTACTS.TITLE%TYPE,
350: ORGANIZATION_NAME_PHONETIC VARCHAR2(320),
351: PERSON_FIRST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.FIRST_NAME_ALT%TYPE,
352: PERSON_LAST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.LAST_NAME_ALT%TYPE,

Line 349: PERSON_TITLE AP_SUPPLIER_CONTACTS.TITLE%TYPE,

345: ORG_PARTY_SITE_ID NUMBER,
346: PERSON_FIRST_NAME AP_SUPPLIER_CONTACTS.FIRST_NAME%TYPE,
347: PERSON_MIDDLE_NAME AP_SUPPLIER_CONTACTS.MIDDLE_NAME%TYPE,
348: PERSON_LAST_NAME AP_SUPPLIER_CONTACTS.LAST_NAME%TYPE,
349: PERSON_TITLE AP_SUPPLIER_CONTACTS.TITLE%TYPE,
350: ORGANIZATION_NAME_PHONETIC VARCHAR2(320),
351: PERSON_FIRST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.FIRST_NAME_ALT%TYPE,
352: PERSON_LAST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.LAST_NAME_ALT%TYPE,
353: ATTRIBUTE_CATEGORY AP_SUPPLIER_CONTACTS.ATTRIBUTE_CATEGORY%TYPE,

Line 351: PERSON_FIRST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.FIRST_NAME_ALT%TYPE,

347: PERSON_MIDDLE_NAME AP_SUPPLIER_CONTACTS.MIDDLE_NAME%TYPE,
348: PERSON_LAST_NAME AP_SUPPLIER_CONTACTS.LAST_NAME%TYPE,
349: PERSON_TITLE AP_SUPPLIER_CONTACTS.TITLE%TYPE,
350: ORGANIZATION_NAME_PHONETIC VARCHAR2(320),
351: PERSON_FIRST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.FIRST_NAME_ALT%TYPE,
352: PERSON_LAST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.LAST_NAME_ALT%TYPE,
353: ATTRIBUTE_CATEGORY AP_SUPPLIER_CONTACTS.ATTRIBUTE_CATEGORY%TYPE,
354: ATTRIBUTE1 AP_SUPPLIER_CONTACTS.ATTRIBUTE1%TYPE,
355: ATTRIBUTE2 AP_SUPPLIER_CONTACTS.ATTRIBUTE2%TYPE,

Line 352: PERSON_LAST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.LAST_NAME_ALT%TYPE,

348: PERSON_LAST_NAME AP_SUPPLIER_CONTACTS.LAST_NAME%TYPE,
349: PERSON_TITLE AP_SUPPLIER_CONTACTS.TITLE%TYPE,
350: ORGANIZATION_NAME_PHONETIC VARCHAR2(320),
351: PERSON_FIRST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.FIRST_NAME_ALT%TYPE,
352: PERSON_LAST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.LAST_NAME_ALT%TYPE,
353: ATTRIBUTE_CATEGORY AP_SUPPLIER_CONTACTS.ATTRIBUTE_CATEGORY%TYPE,
354: ATTRIBUTE1 AP_SUPPLIER_CONTACTS.ATTRIBUTE1%TYPE,
355: ATTRIBUTE2 AP_SUPPLIER_CONTACTS.ATTRIBUTE2%TYPE,
356: ATTRIBUTE3 AP_SUPPLIER_CONTACTS.ATTRIBUTE3%TYPE,

Line 353: ATTRIBUTE_CATEGORY AP_SUPPLIER_CONTACTS.ATTRIBUTE_CATEGORY%TYPE,

349: PERSON_TITLE AP_SUPPLIER_CONTACTS.TITLE%TYPE,
350: ORGANIZATION_NAME_PHONETIC VARCHAR2(320),
351: PERSON_FIRST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.FIRST_NAME_ALT%TYPE,
352: PERSON_LAST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.LAST_NAME_ALT%TYPE,
353: ATTRIBUTE_CATEGORY AP_SUPPLIER_CONTACTS.ATTRIBUTE_CATEGORY%TYPE,
354: ATTRIBUTE1 AP_SUPPLIER_CONTACTS.ATTRIBUTE1%TYPE,
355: ATTRIBUTE2 AP_SUPPLIER_CONTACTS.ATTRIBUTE2%TYPE,
356: ATTRIBUTE3 AP_SUPPLIER_CONTACTS.ATTRIBUTE3%TYPE,
357: ATTRIBUTE4 AP_SUPPLIER_CONTACTS.ATTRIBUTE4%TYPE,

Line 354: ATTRIBUTE1 AP_SUPPLIER_CONTACTS.ATTRIBUTE1%TYPE,

350: ORGANIZATION_NAME_PHONETIC VARCHAR2(320),
351: PERSON_FIRST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.FIRST_NAME_ALT%TYPE,
352: PERSON_LAST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.LAST_NAME_ALT%TYPE,
353: ATTRIBUTE_CATEGORY AP_SUPPLIER_CONTACTS.ATTRIBUTE_CATEGORY%TYPE,
354: ATTRIBUTE1 AP_SUPPLIER_CONTACTS.ATTRIBUTE1%TYPE,
355: ATTRIBUTE2 AP_SUPPLIER_CONTACTS.ATTRIBUTE2%TYPE,
356: ATTRIBUTE3 AP_SUPPLIER_CONTACTS.ATTRIBUTE3%TYPE,
357: ATTRIBUTE4 AP_SUPPLIER_CONTACTS.ATTRIBUTE4%TYPE,
358: ATTRIBUTE5 AP_SUPPLIER_CONTACTS.ATTRIBUTE5%TYPE,

Line 355: ATTRIBUTE2 AP_SUPPLIER_CONTACTS.ATTRIBUTE2%TYPE,

351: PERSON_FIRST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.FIRST_NAME_ALT%TYPE,
352: PERSON_LAST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.LAST_NAME_ALT%TYPE,
353: ATTRIBUTE_CATEGORY AP_SUPPLIER_CONTACTS.ATTRIBUTE_CATEGORY%TYPE,
354: ATTRIBUTE1 AP_SUPPLIER_CONTACTS.ATTRIBUTE1%TYPE,
355: ATTRIBUTE2 AP_SUPPLIER_CONTACTS.ATTRIBUTE2%TYPE,
356: ATTRIBUTE3 AP_SUPPLIER_CONTACTS.ATTRIBUTE3%TYPE,
357: ATTRIBUTE4 AP_SUPPLIER_CONTACTS.ATTRIBUTE4%TYPE,
358: ATTRIBUTE5 AP_SUPPLIER_CONTACTS.ATTRIBUTE5%TYPE,
359: ATTRIBUTE6 AP_SUPPLIER_CONTACTS.ATTRIBUTE6%TYPE,

Line 356: ATTRIBUTE3 AP_SUPPLIER_CONTACTS.ATTRIBUTE3%TYPE,

352: PERSON_LAST_NAME_PHONETIC AP_SUPPLIER_CONTACTS.LAST_NAME_ALT%TYPE,
353: ATTRIBUTE_CATEGORY AP_SUPPLIER_CONTACTS.ATTRIBUTE_CATEGORY%TYPE,
354: ATTRIBUTE1 AP_SUPPLIER_CONTACTS.ATTRIBUTE1%TYPE,
355: ATTRIBUTE2 AP_SUPPLIER_CONTACTS.ATTRIBUTE2%TYPE,
356: ATTRIBUTE3 AP_SUPPLIER_CONTACTS.ATTRIBUTE3%TYPE,
357: ATTRIBUTE4 AP_SUPPLIER_CONTACTS.ATTRIBUTE4%TYPE,
358: ATTRIBUTE5 AP_SUPPLIER_CONTACTS.ATTRIBUTE5%TYPE,
359: ATTRIBUTE6 AP_SUPPLIER_CONTACTS.ATTRIBUTE6%TYPE,
360: ATTRIBUTE7 AP_SUPPLIER_CONTACTS.ATTRIBUTE7%TYPE,

Line 357: ATTRIBUTE4 AP_SUPPLIER_CONTACTS.ATTRIBUTE4%TYPE,

353: ATTRIBUTE_CATEGORY AP_SUPPLIER_CONTACTS.ATTRIBUTE_CATEGORY%TYPE,
354: ATTRIBUTE1 AP_SUPPLIER_CONTACTS.ATTRIBUTE1%TYPE,
355: ATTRIBUTE2 AP_SUPPLIER_CONTACTS.ATTRIBUTE2%TYPE,
356: ATTRIBUTE3 AP_SUPPLIER_CONTACTS.ATTRIBUTE3%TYPE,
357: ATTRIBUTE4 AP_SUPPLIER_CONTACTS.ATTRIBUTE4%TYPE,
358: ATTRIBUTE5 AP_SUPPLIER_CONTACTS.ATTRIBUTE5%TYPE,
359: ATTRIBUTE6 AP_SUPPLIER_CONTACTS.ATTRIBUTE6%TYPE,
360: ATTRIBUTE7 AP_SUPPLIER_CONTACTS.ATTRIBUTE7%TYPE,
361: ATTRIBUTE8 AP_SUPPLIER_CONTACTS.ATTRIBUTE8%TYPE,

Line 358: ATTRIBUTE5 AP_SUPPLIER_CONTACTS.ATTRIBUTE5%TYPE,

354: ATTRIBUTE1 AP_SUPPLIER_CONTACTS.ATTRIBUTE1%TYPE,
355: ATTRIBUTE2 AP_SUPPLIER_CONTACTS.ATTRIBUTE2%TYPE,
356: ATTRIBUTE3 AP_SUPPLIER_CONTACTS.ATTRIBUTE3%TYPE,
357: ATTRIBUTE4 AP_SUPPLIER_CONTACTS.ATTRIBUTE4%TYPE,
358: ATTRIBUTE5 AP_SUPPLIER_CONTACTS.ATTRIBUTE5%TYPE,
359: ATTRIBUTE6 AP_SUPPLIER_CONTACTS.ATTRIBUTE6%TYPE,
360: ATTRIBUTE7 AP_SUPPLIER_CONTACTS.ATTRIBUTE7%TYPE,
361: ATTRIBUTE8 AP_SUPPLIER_CONTACTS.ATTRIBUTE8%TYPE,
362: ATTRIBUTE9 AP_SUPPLIER_CONTACTS.ATTRIBUTE9%TYPE,

Line 359: ATTRIBUTE6 AP_SUPPLIER_CONTACTS.ATTRIBUTE6%TYPE,

355: ATTRIBUTE2 AP_SUPPLIER_CONTACTS.ATTRIBUTE2%TYPE,
356: ATTRIBUTE3 AP_SUPPLIER_CONTACTS.ATTRIBUTE3%TYPE,
357: ATTRIBUTE4 AP_SUPPLIER_CONTACTS.ATTRIBUTE4%TYPE,
358: ATTRIBUTE5 AP_SUPPLIER_CONTACTS.ATTRIBUTE5%TYPE,
359: ATTRIBUTE6 AP_SUPPLIER_CONTACTS.ATTRIBUTE6%TYPE,
360: ATTRIBUTE7 AP_SUPPLIER_CONTACTS.ATTRIBUTE7%TYPE,
361: ATTRIBUTE8 AP_SUPPLIER_CONTACTS.ATTRIBUTE8%TYPE,
362: ATTRIBUTE9 AP_SUPPLIER_CONTACTS.ATTRIBUTE9%TYPE,
363: ATTRIBUTE10 AP_SUPPLIER_CONTACTS.ATTRIBUTE10%TYPE,

Line 360: ATTRIBUTE7 AP_SUPPLIER_CONTACTS.ATTRIBUTE7%TYPE,

356: ATTRIBUTE3 AP_SUPPLIER_CONTACTS.ATTRIBUTE3%TYPE,
357: ATTRIBUTE4 AP_SUPPLIER_CONTACTS.ATTRIBUTE4%TYPE,
358: ATTRIBUTE5 AP_SUPPLIER_CONTACTS.ATTRIBUTE5%TYPE,
359: ATTRIBUTE6 AP_SUPPLIER_CONTACTS.ATTRIBUTE6%TYPE,
360: ATTRIBUTE7 AP_SUPPLIER_CONTACTS.ATTRIBUTE7%TYPE,
361: ATTRIBUTE8 AP_SUPPLIER_CONTACTS.ATTRIBUTE8%TYPE,
362: ATTRIBUTE9 AP_SUPPLIER_CONTACTS.ATTRIBUTE9%TYPE,
363: ATTRIBUTE10 AP_SUPPLIER_CONTACTS.ATTRIBUTE10%TYPE,
364: ATTRIBUTE11 AP_SUPPLIER_CONTACTS.ATTRIBUTE11%TYPE,

Line 361: ATTRIBUTE8 AP_SUPPLIER_CONTACTS.ATTRIBUTE8%TYPE,

357: ATTRIBUTE4 AP_SUPPLIER_CONTACTS.ATTRIBUTE4%TYPE,
358: ATTRIBUTE5 AP_SUPPLIER_CONTACTS.ATTRIBUTE5%TYPE,
359: ATTRIBUTE6 AP_SUPPLIER_CONTACTS.ATTRIBUTE6%TYPE,
360: ATTRIBUTE7 AP_SUPPLIER_CONTACTS.ATTRIBUTE7%TYPE,
361: ATTRIBUTE8 AP_SUPPLIER_CONTACTS.ATTRIBUTE8%TYPE,
362: ATTRIBUTE9 AP_SUPPLIER_CONTACTS.ATTRIBUTE9%TYPE,
363: ATTRIBUTE10 AP_SUPPLIER_CONTACTS.ATTRIBUTE10%TYPE,
364: ATTRIBUTE11 AP_SUPPLIER_CONTACTS.ATTRIBUTE11%TYPE,
365: ATTRIBUTE12 AP_SUPPLIER_CONTACTS.ATTRIBUTE12%TYPE,

Line 362: ATTRIBUTE9 AP_SUPPLIER_CONTACTS.ATTRIBUTE9%TYPE,

358: ATTRIBUTE5 AP_SUPPLIER_CONTACTS.ATTRIBUTE5%TYPE,
359: ATTRIBUTE6 AP_SUPPLIER_CONTACTS.ATTRIBUTE6%TYPE,
360: ATTRIBUTE7 AP_SUPPLIER_CONTACTS.ATTRIBUTE7%TYPE,
361: ATTRIBUTE8 AP_SUPPLIER_CONTACTS.ATTRIBUTE8%TYPE,
362: ATTRIBUTE9 AP_SUPPLIER_CONTACTS.ATTRIBUTE9%TYPE,
363: ATTRIBUTE10 AP_SUPPLIER_CONTACTS.ATTRIBUTE10%TYPE,
364: ATTRIBUTE11 AP_SUPPLIER_CONTACTS.ATTRIBUTE11%TYPE,
365: ATTRIBUTE12 AP_SUPPLIER_CONTACTS.ATTRIBUTE12%TYPE,
366: ATTRIBUTE13 AP_SUPPLIER_CONTACTS.ATTRIBUTE13%TYPE,

Line 363: ATTRIBUTE10 AP_SUPPLIER_CONTACTS.ATTRIBUTE10%TYPE,

359: ATTRIBUTE6 AP_SUPPLIER_CONTACTS.ATTRIBUTE6%TYPE,
360: ATTRIBUTE7 AP_SUPPLIER_CONTACTS.ATTRIBUTE7%TYPE,
361: ATTRIBUTE8 AP_SUPPLIER_CONTACTS.ATTRIBUTE8%TYPE,
362: ATTRIBUTE9 AP_SUPPLIER_CONTACTS.ATTRIBUTE9%TYPE,
363: ATTRIBUTE10 AP_SUPPLIER_CONTACTS.ATTRIBUTE10%TYPE,
364: ATTRIBUTE11 AP_SUPPLIER_CONTACTS.ATTRIBUTE11%TYPE,
365: ATTRIBUTE12 AP_SUPPLIER_CONTACTS.ATTRIBUTE12%TYPE,
366: ATTRIBUTE13 AP_SUPPLIER_CONTACTS.ATTRIBUTE13%TYPE,
367: ATTRIBUTE14 AP_SUPPLIER_CONTACTS.ATTRIBUTE14%TYPE,

Line 364: ATTRIBUTE11 AP_SUPPLIER_CONTACTS.ATTRIBUTE11%TYPE,

360: ATTRIBUTE7 AP_SUPPLIER_CONTACTS.ATTRIBUTE7%TYPE,
361: ATTRIBUTE8 AP_SUPPLIER_CONTACTS.ATTRIBUTE8%TYPE,
362: ATTRIBUTE9 AP_SUPPLIER_CONTACTS.ATTRIBUTE9%TYPE,
363: ATTRIBUTE10 AP_SUPPLIER_CONTACTS.ATTRIBUTE10%TYPE,
364: ATTRIBUTE11 AP_SUPPLIER_CONTACTS.ATTRIBUTE11%TYPE,
365: ATTRIBUTE12 AP_SUPPLIER_CONTACTS.ATTRIBUTE12%TYPE,
366: ATTRIBUTE13 AP_SUPPLIER_CONTACTS.ATTRIBUTE13%TYPE,
367: ATTRIBUTE14 AP_SUPPLIER_CONTACTS.ATTRIBUTE14%TYPE,
368: ATTRIBUTE15 AP_SUPPLIER_CONTACTS.ATTRIBUTE15%TYPE,

Line 365: ATTRIBUTE12 AP_SUPPLIER_CONTACTS.ATTRIBUTE12%TYPE,

361: ATTRIBUTE8 AP_SUPPLIER_CONTACTS.ATTRIBUTE8%TYPE,
362: ATTRIBUTE9 AP_SUPPLIER_CONTACTS.ATTRIBUTE9%TYPE,
363: ATTRIBUTE10 AP_SUPPLIER_CONTACTS.ATTRIBUTE10%TYPE,
364: ATTRIBUTE11 AP_SUPPLIER_CONTACTS.ATTRIBUTE11%TYPE,
365: ATTRIBUTE12 AP_SUPPLIER_CONTACTS.ATTRIBUTE12%TYPE,
366: ATTRIBUTE13 AP_SUPPLIER_CONTACTS.ATTRIBUTE13%TYPE,
367: ATTRIBUTE14 AP_SUPPLIER_CONTACTS.ATTRIBUTE14%TYPE,
368: ATTRIBUTE15 AP_SUPPLIER_CONTACTS.ATTRIBUTE15%TYPE,
369: INACTIVE_DATE AP_SUPPLIER_CONTACTS.INACTIVE_DATE%TYPE,

Line 366: ATTRIBUTE13 AP_SUPPLIER_CONTACTS.ATTRIBUTE13%TYPE,

362: ATTRIBUTE9 AP_SUPPLIER_CONTACTS.ATTRIBUTE9%TYPE,
363: ATTRIBUTE10 AP_SUPPLIER_CONTACTS.ATTRIBUTE10%TYPE,
364: ATTRIBUTE11 AP_SUPPLIER_CONTACTS.ATTRIBUTE11%TYPE,
365: ATTRIBUTE12 AP_SUPPLIER_CONTACTS.ATTRIBUTE12%TYPE,
366: ATTRIBUTE13 AP_SUPPLIER_CONTACTS.ATTRIBUTE13%TYPE,
367: ATTRIBUTE14 AP_SUPPLIER_CONTACTS.ATTRIBUTE14%TYPE,
368: ATTRIBUTE15 AP_SUPPLIER_CONTACTS.ATTRIBUTE15%TYPE,
369: INACTIVE_DATE AP_SUPPLIER_CONTACTS.INACTIVE_DATE%TYPE,
370: PARTY_NUMBER VARCHAR2(30),

Line 367: ATTRIBUTE14 AP_SUPPLIER_CONTACTS.ATTRIBUTE14%TYPE,

363: ATTRIBUTE10 AP_SUPPLIER_CONTACTS.ATTRIBUTE10%TYPE,
364: ATTRIBUTE11 AP_SUPPLIER_CONTACTS.ATTRIBUTE11%TYPE,
365: ATTRIBUTE12 AP_SUPPLIER_CONTACTS.ATTRIBUTE12%TYPE,
366: ATTRIBUTE13 AP_SUPPLIER_CONTACTS.ATTRIBUTE13%TYPE,
367: ATTRIBUTE14 AP_SUPPLIER_CONTACTS.ATTRIBUTE14%TYPE,
368: ATTRIBUTE15 AP_SUPPLIER_CONTACTS.ATTRIBUTE15%TYPE,
369: INACTIVE_DATE AP_SUPPLIER_CONTACTS.INACTIVE_DATE%TYPE,
370: PARTY_NUMBER VARCHAR2(30),
371: DEPARTMENT AP_SUPPLIER_CONTACTS.DEPARTMENT%TYPE,

Line 368: ATTRIBUTE15 AP_SUPPLIER_CONTACTS.ATTRIBUTE15%TYPE,

364: ATTRIBUTE11 AP_SUPPLIER_CONTACTS.ATTRIBUTE11%TYPE,
365: ATTRIBUTE12 AP_SUPPLIER_CONTACTS.ATTRIBUTE12%TYPE,
366: ATTRIBUTE13 AP_SUPPLIER_CONTACTS.ATTRIBUTE13%TYPE,
367: ATTRIBUTE14 AP_SUPPLIER_CONTACTS.ATTRIBUTE14%TYPE,
368: ATTRIBUTE15 AP_SUPPLIER_CONTACTS.ATTRIBUTE15%TYPE,
369: INACTIVE_DATE AP_SUPPLIER_CONTACTS.INACTIVE_DATE%TYPE,
370: PARTY_NUMBER VARCHAR2(30),
371: DEPARTMENT AP_SUPPLIER_CONTACTS.DEPARTMENT%TYPE,
372: MAIL_STOP AP_SUPPLIER_CONTACTS.MAIL_STOP%TYPE,

Line 369: INACTIVE_DATE AP_SUPPLIER_CONTACTS.INACTIVE_DATE%TYPE,

365: ATTRIBUTE12 AP_SUPPLIER_CONTACTS.ATTRIBUTE12%TYPE,
366: ATTRIBUTE13 AP_SUPPLIER_CONTACTS.ATTRIBUTE13%TYPE,
367: ATTRIBUTE14 AP_SUPPLIER_CONTACTS.ATTRIBUTE14%TYPE,
368: ATTRIBUTE15 AP_SUPPLIER_CONTACTS.ATTRIBUTE15%TYPE,
369: INACTIVE_DATE AP_SUPPLIER_CONTACTS.INACTIVE_DATE%TYPE,
370: PARTY_NUMBER VARCHAR2(30),
371: DEPARTMENT AP_SUPPLIER_CONTACTS.DEPARTMENT%TYPE,
372: MAIL_STOP AP_SUPPLIER_CONTACTS.MAIL_STOP%TYPE,
373: AREA_CODE AP_SUPPLIER_CONTACTS.AREA_CODE%TYPE,

Line 371: DEPARTMENT AP_SUPPLIER_CONTACTS.DEPARTMENT%TYPE,

367: ATTRIBUTE14 AP_SUPPLIER_CONTACTS.ATTRIBUTE14%TYPE,
368: ATTRIBUTE15 AP_SUPPLIER_CONTACTS.ATTRIBUTE15%TYPE,
369: INACTIVE_DATE AP_SUPPLIER_CONTACTS.INACTIVE_DATE%TYPE,
370: PARTY_NUMBER VARCHAR2(30),
371: DEPARTMENT AP_SUPPLIER_CONTACTS.DEPARTMENT%TYPE,
372: MAIL_STOP AP_SUPPLIER_CONTACTS.MAIL_STOP%TYPE,
373: AREA_CODE AP_SUPPLIER_CONTACTS.AREA_CODE%TYPE,
374: PHONE AP_SUPPLIER_CONTACTS.PHONE%TYPE,
375: ALT_AREA_CODE AP_SUPPLIER_CONTACTS.ALT_AREA_CODE%TYPE,

Line 372: MAIL_STOP AP_SUPPLIER_CONTACTS.MAIL_STOP%TYPE,

368: ATTRIBUTE15 AP_SUPPLIER_CONTACTS.ATTRIBUTE15%TYPE,
369: INACTIVE_DATE AP_SUPPLIER_CONTACTS.INACTIVE_DATE%TYPE,
370: PARTY_NUMBER VARCHAR2(30),
371: DEPARTMENT AP_SUPPLIER_CONTACTS.DEPARTMENT%TYPE,
372: MAIL_STOP AP_SUPPLIER_CONTACTS.MAIL_STOP%TYPE,
373: AREA_CODE AP_SUPPLIER_CONTACTS.AREA_CODE%TYPE,
374: PHONE AP_SUPPLIER_CONTACTS.PHONE%TYPE,
375: ALT_AREA_CODE AP_SUPPLIER_CONTACTS.ALT_AREA_CODE%TYPE,
376: ALT_PHONE AP_SUPPLIER_CONTACTS.ALT_PHONE%TYPE,

Line 373: AREA_CODE AP_SUPPLIER_CONTACTS.AREA_CODE%TYPE,

369: INACTIVE_DATE AP_SUPPLIER_CONTACTS.INACTIVE_DATE%TYPE,
370: PARTY_NUMBER VARCHAR2(30),
371: DEPARTMENT AP_SUPPLIER_CONTACTS.DEPARTMENT%TYPE,
372: MAIL_STOP AP_SUPPLIER_CONTACTS.MAIL_STOP%TYPE,
373: AREA_CODE AP_SUPPLIER_CONTACTS.AREA_CODE%TYPE,
374: PHONE AP_SUPPLIER_CONTACTS.PHONE%TYPE,
375: ALT_AREA_CODE AP_SUPPLIER_CONTACTS.ALT_AREA_CODE%TYPE,
376: ALT_PHONE AP_SUPPLIER_CONTACTS.ALT_PHONE%TYPE,
377: FAX_AREA_CODE AP_SUPPLIER_CONTACTS.FAX_AREA_CODE%TYPE,

Line 374: PHONE AP_SUPPLIER_CONTACTS.PHONE%TYPE,

370: PARTY_NUMBER VARCHAR2(30),
371: DEPARTMENT AP_SUPPLIER_CONTACTS.DEPARTMENT%TYPE,
372: MAIL_STOP AP_SUPPLIER_CONTACTS.MAIL_STOP%TYPE,
373: AREA_CODE AP_SUPPLIER_CONTACTS.AREA_CODE%TYPE,
374: PHONE AP_SUPPLIER_CONTACTS.PHONE%TYPE,
375: ALT_AREA_CODE AP_SUPPLIER_CONTACTS.ALT_AREA_CODE%TYPE,
376: ALT_PHONE AP_SUPPLIER_CONTACTS.ALT_PHONE%TYPE,
377: FAX_AREA_CODE AP_SUPPLIER_CONTACTS.FAX_AREA_CODE%TYPE,
378: FAX_PHONE AP_SUPPLIER_CONTACTS.FAX%TYPE,

Line 375: ALT_AREA_CODE AP_SUPPLIER_CONTACTS.ALT_AREA_CODE%TYPE,

371: DEPARTMENT AP_SUPPLIER_CONTACTS.DEPARTMENT%TYPE,
372: MAIL_STOP AP_SUPPLIER_CONTACTS.MAIL_STOP%TYPE,
373: AREA_CODE AP_SUPPLIER_CONTACTS.AREA_CODE%TYPE,
374: PHONE AP_SUPPLIER_CONTACTS.PHONE%TYPE,
375: ALT_AREA_CODE AP_SUPPLIER_CONTACTS.ALT_AREA_CODE%TYPE,
376: ALT_PHONE AP_SUPPLIER_CONTACTS.ALT_PHONE%TYPE,
377: FAX_AREA_CODE AP_SUPPLIER_CONTACTS.FAX_AREA_CODE%TYPE,
378: FAX_PHONE AP_SUPPLIER_CONTACTS.FAX%TYPE,
379: EMAIL_ADDRESS AP_SUPPLIER_CONTACTS.EMAIL_ADDRESS%TYPE,

Line 376: ALT_PHONE AP_SUPPLIER_CONTACTS.ALT_PHONE%TYPE,

372: MAIL_STOP AP_SUPPLIER_CONTACTS.MAIL_STOP%TYPE,
373: AREA_CODE AP_SUPPLIER_CONTACTS.AREA_CODE%TYPE,
374: PHONE AP_SUPPLIER_CONTACTS.PHONE%TYPE,
375: ALT_AREA_CODE AP_SUPPLIER_CONTACTS.ALT_AREA_CODE%TYPE,
376: ALT_PHONE AP_SUPPLIER_CONTACTS.ALT_PHONE%TYPE,
377: FAX_AREA_CODE AP_SUPPLIER_CONTACTS.FAX_AREA_CODE%TYPE,
378: FAX_PHONE AP_SUPPLIER_CONTACTS.FAX%TYPE,
379: EMAIL_ADDRESS AP_SUPPLIER_CONTACTS.EMAIL_ADDRESS%TYPE,
380: URL AP_SUPPLIER_CONTACTS.URL%TYPE,

Line 377: FAX_AREA_CODE AP_SUPPLIER_CONTACTS.FAX_AREA_CODE%TYPE,

373: AREA_CODE AP_SUPPLIER_CONTACTS.AREA_CODE%TYPE,
374: PHONE AP_SUPPLIER_CONTACTS.PHONE%TYPE,
375: ALT_AREA_CODE AP_SUPPLIER_CONTACTS.ALT_AREA_CODE%TYPE,
376: ALT_PHONE AP_SUPPLIER_CONTACTS.ALT_PHONE%TYPE,
377: FAX_AREA_CODE AP_SUPPLIER_CONTACTS.FAX_AREA_CODE%TYPE,
378: FAX_PHONE AP_SUPPLIER_CONTACTS.FAX%TYPE,
379: EMAIL_ADDRESS AP_SUPPLIER_CONTACTS.EMAIL_ADDRESS%TYPE,
380: URL AP_SUPPLIER_CONTACTS.URL%TYPE,
381: VENDOR_CONTACT_INTERFACE_ID NUMBER,

Line 378: FAX_PHONE AP_SUPPLIER_CONTACTS.FAX%TYPE,

374: PHONE AP_SUPPLIER_CONTACTS.PHONE%TYPE,
375: ALT_AREA_CODE AP_SUPPLIER_CONTACTS.ALT_AREA_CODE%TYPE,
376: ALT_PHONE AP_SUPPLIER_CONTACTS.ALT_PHONE%TYPE,
377: FAX_AREA_CODE AP_SUPPLIER_CONTACTS.FAX_AREA_CODE%TYPE,
378: FAX_PHONE AP_SUPPLIER_CONTACTS.FAX%TYPE,
379: EMAIL_ADDRESS AP_SUPPLIER_CONTACTS.EMAIL_ADDRESS%TYPE,
380: URL AP_SUPPLIER_CONTACTS.URL%TYPE,
381: VENDOR_CONTACT_INTERFACE_ID NUMBER,
382: VENDOR_INTERFACE_ID NUMBER,

Line 379: EMAIL_ADDRESS AP_SUPPLIER_CONTACTS.EMAIL_ADDRESS%TYPE,

375: ALT_AREA_CODE AP_SUPPLIER_CONTACTS.ALT_AREA_CODE%TYPE,
376: ALT_PHONE AP_SUPPLIER_CONTACTS.ALT_PHONE%TYPE,
377: FAX_AREA_CODE AP_SUPPLIER_CONTACTS.FAX_AREA_CODE%TYPE,
378: FAX_PHONE AP_SUPPLIER_CONTACTS.FAX%TYPE,
379: EMAIL_ADDRESS AP_SUPPLIER_CONTACTS.EMAIL_ADDRESS%TYPE,
380: URL AP_SUPPLIER_CONTACTS.URL%TYPE,
381: VENDOR_CONTACT_INTERFACE_ID NUMBER,
382: VENDOR_INTERFACE_ID NUMBER,
383: VENDOR_SITE_CODE AP_SUP_SITE_CONTACT_INT.VENDOR_SITE_CODE%TYPE,

Line 380: URL AP_SUPPLIER_CONTACTS.URL%TYPE,

376: ALT_PHONE AP_SUPPLIER_CONTACTS.ALT_PHONE%TYPE,
377: FAX_AREA_CODE AP_SUPPLIER_CONTACTS.FAX_AREA_CODE%TYPE,
378: FAX_PHONE AP_SUPPLIER_CONTACTS.FAX%TYPE,
379: EMAIL_ADDRESS AP_SUPPLIER_CONTACTS.EMAIL_ADDRESS%TYPE,
380: URL AP_SUPPLIER_CONTACTS.URL%TYPE,
381: VENDOR_CONTACT_INTERFACE_ID NUMBER,
382: VENDOR_INTERFACE_ID NUMBER,
383: VENDOR_SITE_CODE AP_SUP_SITE_CONTACT_INT.VENDOR_SITE_CODE%TYPE,
384: ORG_ID NUMBER,

Line 1021: -- assignments contacts in AP_SUPPLIER_CONTACTS

1017: --
1018: -- Notes : Update Address Assignments DFF,called from various
1019: -- features and other products,
1020: -- This will update the DFF columns of the address
1021: -- assignments contacts in AP_SUPPLIER_CONTACTS
1022: -- The database values of Attribute_Category and
1023: -- the Attributes 1-15, will be updated to whatever is
1024: -- passed to the API and the default value is null.
1025: --