1 PACKAGE JTM_PROFILE_UTL_PKG AS
2 /* $Header: jtmpfuts.pls 120.1 2005/08/24 02:17:34 saradhak noship $ */
3
4 /* comment out to prevent user accidently call this proc
5 FUNCTION Get_app_level_profile_value(
6 p_profile_name in varchar2,
7 p_app_short_name in varchar2) return varchar2;
8 */
9
10 FUNCTION Get_app_enable_flag( p_app_short_name IN varchar2) return varchar2;
11
12 FUNCTION Get_app_enable_flag(p_resp_id in number, p_app_id in number) return varchar2;
13
14 FUNCTION Get_enable_flag_at_resp(
15 p_resp_id in number,
16 p_app_short_name IN varchar2) return varchar2;
17
18 FUNCTION Get_enable_flag_at_resp(
19 p_resp_key in VARCHAR2,
20 p_app_short_name IN varchar2) return varchar2;
21
22 FUNCTION Get_enable_flag_at_resp(
23 p_app_short_name IN varchar2) return varchar2;
24
25 END JTM_PROFILE_UTL_PKG ;