1 PACKAGE JG_ZZ_SHARED_PKG AUTHID CURRENT_USER AS
2 /* $Header: jgzzssas.pls 120.8.12020000.1 2012/06/27 12:17:13 appldev noship $ */
3
4 Type t_char_tbl is TABLE OF VARCHAR2(10) index by VARCHAR2(100);
5 p_country_tbl t_char_tbl ;
6 p_product_tbl t_char_tbl;
7 p_appl_tbl t_char_tbl;
8
9 -----------------------------------------------------------------
10 -- FUNCTION Is_Globalization_enabled
11 -- Use this function to verify whether the globalization feature is enabled for
12 -- the given country.
13 -----------------------------------------------------------------
14 FUNCTION IS_GLOBALIZATION_ENABLED (p_country_code IN VARCHAR2) RETURN VARCHAR2;
15
16 -----------------------------------------------------------------
17 -- FUNCTION Country
18 -- Use this function instead of FND_PROFILE.VALUE/GET to retrieve the
19 -- value of country code
20 -----------------------------------------------------------------
21 FUNCTION GET_COUNTRY RETURN VARCHAR2;
22 -----------------------------------------------------------------
23 FUNCTION GET_COUNTRY (p_org_id IN NUMBER,
24 p_ledger_id IN NUMBER DEFAULT NULL,
25 p_inv_org_id IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
26
27 -----------------------------------------------------------------
28 -- FUNCTION Product
29 -- Use this function instead of FND_PROFILE.VALUE/GET to retrieve the
30 -- value of product code
31 -----------------------------------------------------------------
32 FUNCTION GET_PRODUCT RETURN VARCHAR2;
33 -----------------------------------------------------------------
34 FUNCTION GET_PRODUCT (p_org_id IN NUMBER,
35 p_ledger_id IN NUMBER DEFAULT NULL,
36 p_inv_org_id IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
37
38 -----------------------------------------------------------------
39 -- FUNCTION Application
40 -- Use this function instead of FND_PROFILE.VALUE/GET to retrieve the
41 -- value of application short name
42 -----------------------------------------------------------------
43 FUNCTION GET_APPLICATION RETURN VARCHAR2;
44 -----------------------------------------------------------------
45 FUNCTION GET_APPLICATION (p_curr_form_name IN VARCHAR2) RETURN VARCHAR2;
46
47 END JG_ZZ_SHARED_PKG;