PACKAGE BODY: APPS.OE_BIS_SALESPERSON

Source

1 package body OE_BIS_SALESPERSON AS
2 --$Header: OEXBISPB.pls 120.0 2005/06/01 02:46:14 appldev noship $
3 
4 FUNCTION GET_SALESPERSON_NAME
5 (p_salesrep_id IN number)
6 return varchar2  is
7 x_salesperson varchar2(100);
8 
9 begin
10   select name
11   into x_salesperson
12   from ra_salesreps
13   where salesrep_id = p_salesrep_id;
14 
15   return x_salesperson;
16 
17 exception
18 when others then
19   x_salesperson := null;
20   return x_salesperson;
21 
22 end GET_SALESPERSON_NAME;
23 
24 
25 END OE_BIS_SALESPERSON;