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_APXINAGE_XMLP_PKG dependencies on PO_VENDOR_CONTACTS

Line 530: l_last_name po_vendor_contacts.last_name%TYPE;

526:
527: DECLARE
528: l_contact_name varchar2(160);
529: l_first_name varchar2(4);
530: l_last_name po_vendor_contacts.last_name%TYPE;
531: l_phone po_vendor_contacts.phone%TYPE;
532: BEGIN
533: SELECT substr(first_name,1,1), last_name,phone
534: INTO l_first_name,l_last_name,l_phone

Line 531: l_phone po_vendor_contacts.phone%TYPE;

527: DECLARE
528: l_contact_name varchar2(160);
529: l_first_name varchar2(4);
530: l_last_name po_vendor_contacts.last_name%TYPE;
531: l_phone po_vendor_contacts.phone%TYPE;
532: BEGIN
533: SELECT substr(first_name,1,1), last_name,phone
534: INTO l_first_name,l_last_name,l_phone
535: FROM po_vendor_contacts

Line 535: FROM po_vendor_contacts

531: l_phone po_vendor_contacts.phone%TYPE;
532: BEGIN
533: SELECT substr(first_name,1,1), last_name,phone
534: INTO l_first_name,l_last_name,l_phone
535: FROM po_vendor_contacts
536: WHERE vendor_site_id = C_CONTACT_SITE_ID
537: AND rownum = 1;
538: if (l_first_name is not null or
539: l_last_name is not null or