* Degignated People Name Show *

DECLARE

NAME_sv   VARCHAR2(30);
--Detail_sv VARCHAR2(30) := 'Change Details';
BEGIN

if :P9_CREATE_SW = 0 then
    select CUST_LAST_NAME || ', ' || CUST_FIRST_NAME AS NAME into NAME_sv 
    from DEMO_CUSTOMERS    where CUSTOMER_ID = :p9_CUSTOMER_ID;
   :P9_NAME := initCap(NAME_sv);
   :p9_head_detail := ' * Modfy Detail Customer';
else
   :p9_head_detail := ' Add Detail Customer';
    :P9_NAME := ' ';
end if;

exception     
  when no_data_found or TOO_MANY_ROWS then
      :P9_NAME := ' ';

END;