APPS.JE_JEHUIAGE_XMLP_PKG dependencies on PO_VENDOR_CONTACTS

Line 503: L_LAST_NAME PO_VENDOR_CONTACTS.LAST_NAME%TYPE;

499: BEGIN
500: DECLARE
501: L_CONTACT_NAME VARCHAR2(160);
502: L_FIRST_NAME VARCHAR2(4);
503: L_LAST_NAME PO_VENDOR_CONTACTS.LAST_NAME%TYPE;
504: L_PHONE PO_VENDOR_CONTACTS.PHONE%TYPE;
505: BEGIN
506: SELECT
507: SUBSTR(FIRST_NAME

Line 504: L_PHONE PO_VENDOR_CONTACTS.PHONE%TYPE;

500: DECLARE
501: L_CONTACT_NAME VARCHAR2(160);
502: L_FIRST_NAME VARCHAR2(4);
503: L_LAST_NAME PO_VENDOR_CONTACTS.LAST_NAME%TYPE;
504: L_PHONE PO_VENDOR_CONTACTS.PHONE%TYPE;
505: BEGIN
506: SELECT
507: SUBSTR(FIRST_NAME
508: ,1

Line 514: PO_VENDOR_CONTACTS

510: LAST_NAME,
511: PHONE
512: INTO L_FIRST_NAME,L_LAST_NAME,L_PHONE
513: FROM
514: PO_VENDOR_CONTACTS
515: WHERE VENDOR_SITE_ID = C_CONTACT_SITE_ID
516: AND ROWNUM = 1;
517: IF (L_FIRST_NAME IS NOT NULL OR L_LAST_NAME IS NOT NULL OR L_PHONE IS NOT NULL) THEN
518: L_CONTACT_NAME := L_FIRST_NAME || '. ' || L_LAST_NAME || ' ' || L_PHONE;