PACKAGE BODY: APPS.JG_ZZ_SYS_OPTIONS_PKG

Source

1 PACKAGE BODY JG_ZZ_SYS_OPTIONS_PKG AS
2 /* $Header: jgzzsopb.pls 120.2 2003/04/18 21:05:20 thwon ship $ */
3 
4 
5 /* =======================================================================*
6  | Fetches the value of Profile JGZZ_EXTENDED_AWT_CALC                    |
7  * =======================================================================*/
8 
9         FUNCTION get_extended_awt_calc_flag
10         (
11 	p_org_id IN NUMBER
12 	) RETURN    VARCHAR2 IS
13 
14         x_ext_awt_flag   ap_system_parameters_all.global_attribute6%type;
15 
16         BEGIN
17 
18           BEGIN
19 
20             /* Y-Yes; N-No */
21             Select global_attribute6
22               Into   x_ext_awt_flag
23               From   ap_system_parameters_all
24               Where  nvl(org_id,-99) = nvl(p_org_id,-99);
25           Exception
26             when others THEN
27               x_ext_awt_flag := NULL;
28           END;
29 
30         END get_extended_awt_calc_flag;
31 
32 END JG_ZZ_SYS_OPTIONS_PKG;