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