1 PACKAGE JG_ZZ_SHARED_PKG AS
2 /* $Header: jgzzssas.pls 120.6.12000000.1 2007/01/18 12:12:54 appldev ship $ */
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 Country
11 -- Use this function instead of FND_PROFILE.VALUE/GET to retrieve the
12 -- value of country code
13 -----------------------------------------------------------------
14 FUNCTION GET_COUNTRY RETURN VARCHAR2;
15 -----------------------------------------------------------------
16 FUNCTION GET_COUNTRY (p_org_id IN NUMBER,
17 p_ledger_id IN NUMBER DEFAULT NULL,
18 p_inv_org_id IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
19
20 -----------------------------------------------------------------
21 -- FUNCTION Product
22 -- Use this function instead of FND_PROFILE.VALUE/GET to retrieve the
23 -- value of product code
24 -----------------------------------------------------------------
25 FUNCTION GET_PRODUCT RETURN VARCHAR2;
26 -----------------------------------------------------------------
27 FUNCTION GET_PRODUCT (p_org_id IN NUMBER,
28 p_ledger_id IN NUMBER DEFAULT NULL,
29 p_inv_org_id IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
30
31 -----------------------------------------------------------------
32 -- FUNCTION Application
33 -- Use this function instead of FND_PROFILE.VALUE/GET to retrieve the
34 -- value of application short name
35 -----------------------------------------------------------------
36 FUNCTION GET_APPLICATION RETURN VARCHAR2;
37 -----------------------------------------------------------------
38 FUNCTION GET_APPLICATION (p_curr_form_name IN VARCHAR2) RETURN VARCHAR2;
39
40 END JG_ZZ_SHARED_PKG;