PACKAGE BODY: APPS.BIS_REQUESTSET_VIEWHISTORY

Source

1 package body BIS_REQUESTSET_VIEWHISTORY AS
2 /*$Header: BISRSVHB.pls 120.0 2005/06/01 18:20:19 appldev noship $*/
3 
4 /* for bug#3807130.
5  * no one should use this funciton any more.
6  * get_sys_lookup_meaning and get_bis_lookup_meaning
7  * should be used instead.
8  */
9 function get_lookup_meaning(p_type in varchar2,
10                             p_code in varchar2) return varchar2 is
11 
12  l_meaning varchar2(80);
13  begin
14   return null;
15  end;
16 
17 
18 function get_sys_lookup_meaning(p_type in varchar2,
19                             p_code in varchar2) return varchar2 is
20 
21  l_meaning varchar2(80);
22  begin
23    select distinct meaning into l_meaning
24    from fnd_lookups
25    where lookup_type=p_type
26    and lookup_code=NVL(p_code, 'N');
27    return l_meaning;
28  exception
29    when no_data_found then
30      return null;
31    when others then
32      raise;
33  end;
34 
35 
36 function get_bis_lookup_meaning(p_type in varchar2,
37                             p_code in varchar2) return varchar2 is
38 
39  l_meaning varchar2(80);
40  begin
41    select distinct meaning into l_meaning
42    from fnd_common_lookups
43    where lookup_type=p_type
44    and lookup_code=NVL(p_code, 'N');
45    return l_meaning;
46  exception
47    when no_data_found then
48      return null;
49    when others then
50      raise;
51  end;
52 
53 
54 END BIS_REQUESTSET_VIEWHISTORY;