DBA Data[Home] [Help]

APPS.CZ_UTILS dependencies on CZ_SERVERS

Line 613: v_db_link cz_servers.fndnam_link_name%TYPE;

609: -------------------------------
610: FUNCTION retrieve_db_link(p_server_id IN PLS_INTEGER)
611: RETURN VARCHAR2
612: IS
613: v_db_link cz_servers.fndnam_link_name%TYPE;
614:
615: BEGIN
616: IF (p_server_id = 0) THEN
617: v_db_link := ' ';

Line 621: FROM cz_servers

617: v_db_link := ' ';
618: ELSE
619: SELECT FNDNAM_LINK_NAME
620: INTO v_db_link
621: FROM cz_servers
622: WHERE cz_servers.server_local_id = p_server_id;
623: v_db_link := '@'||v_db_link||' ';
624: END IF;
625: RETURN v_db_link ;

Line 622: WHERE cz_servers.server_local_id = p_server_id;

618: ELSE
619: SELECT FNDNAM_LINK_NAME
620: INTO v_db_link
621: FROM cz_servers
622: WHERE cz_servers.server_local_id = p_server_id;
623: v_db_link := '@'||v_db_link||' ';
624: END IF;
625: RETURN v_db_link ;
626: EXCEPTION