PACKAGE BODY: APPS.JE_ZZ_SYS_OPTIONS_PKG

Source

1 PACKAGE BODY JE_ZZ_SYS_OPTIONS_PKG AS
2 /* $Header: jezzsopb.pls 120.1.12020000.2 2012/07/18 12:26:25 rshergil noship $ */
3 
4 
5 /* ==========================================================*
6  | Fetches the value of JENL : Payment Separation            |
7  * ==========================================================*/
8 
9         FUNCTION get_nl_pymt_separation
10         (
11 	p_org_id IN NUMBER
12 	) RETURN    VARCHAR2 IS
13 
14         x_pymt_sepr   ap_system_parameters_all.global_attribute1%type;
15 
16         BEGIN
17         /* Y = Yes , N = No  */
18           BEGIN
19             Select global_attribute1
20               Into   x_pymt_sepr
21               From   ap_system_parameters_all
22               Where  nvl(org_id,-99) = nvl(p_org_id,-99);
23           Exception
24             when others THEN
25               x_pymt_sepr := NULL;
26           END;
27 
28           return(x_pymt_sepr);
29 
30         END get_nl_pymt_separation;
31 
32 /* ==============================================================*
33  | Fetches the value of JEIT : Exemption Limit Tax Tag           |
34  * ==============================================================*/
35 
36         FUNCTION get_it_exempt_tax
37         (
38 	p_org_id IN NUMBER
39 	) RETURN    VARCHAR2 IS
40 
41         x_exempt_ttag  ap_system_parameters_all.global_attribute1%type;
42 
43         BEGIN
44 
45           BEGIN
46 
47             Select global_attribute1
48               Into  x_exempt_ttag
49               From  ap_system_parameters_all
50               Where  nvl(org_id,-99) = nvl(p_org_id,-99);
51           Exception
52             when others THEN
53               x_exempt_ttag := NULL;
54           END;
55 
56           return(x_exempt_ttag);
57 
58        END get_it_exempt_tax;
59 
60 
61 END JE_ZZ_SYS_OPTIONS_PKG;