[Home] [Help]
PACKAGE BODY: APPS.NL_FORMULA_FUNCTIONS
Source
1 PACKAGE BODY nl_formula_functions AS
2 -- $Header: penlffnc.pkb 115.1 2001/05/02 06:16:44 pkm ship $
3 --
4 -- Calculates the Target Group
5 --
6 FUNCTION get_table_value(bus_group_id number,
7 tab_name varchar2,
8 col_name varchar2,
9 row_value varchar2)
10 return varchar2
11 is
12 l_ret varchar2(1);
13 Begin
14 Begin
15 l_ret:= hruserdt.get_table_value(bus_group_id,
16 tab_name,
17 col_name,
18 row_value);
19 Exception
20 When NO_DATA_FOUND THEN
21 l_ret:='0';
22 End;
23 Return l_ret;
24 end get_table_value;
25
26 end nl_formula_functions;