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