* UPDATE PROCESS *
begin

UPDATE DEMO_CUSTOMERS

SET
  CUST_FIRST_NAME = :P9_CUST_FIRST_NAME,
  CUST_LAST_NAME = :P9_CUST_LAST_NAME,
  CREDIT_LIMIT  = :P9_CREDIT_LIMIT,
  NLS_TERRITORY = :P9_NLS_TERRITORY,
  ACCOUNT_MGR_ID = :P9_ACCOUNT_MGR_ID,
CUST_EMAIL  =  :P9_CUST_EMAIL
 

WHERE CUSTOMER_ID  = :P9_CUSTOMER_ID;

apex_application.g_print_success_message := '<center><span style = "font-weight:bold;     color:green;font-size: 12pt;" >
    Customer has been updated to Table.</span></center>';

 
 :P9_CUST_FIRST_NAME := '';
 :P9_CUST_LAST_NAME := '';
 :P9_CREDIT_LIMIT:= '';
 :P9_NLS_TERRITORY:= '';
 :P9_ACCOUNT_MGR_ID := '';
:P9_CUST_EMAIL := '';

 Commit;
End;