1 PACKAGE OE_Sys_Parameters_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OEXVSPMS.pls 115.2 2003/10/20 07:26:40 appldev ship $ */
3
4
5 -- FUNCTION VALUE
6 -- Use this function to get the value of a system parameter.
7 -- To be used with release 110510 and above
8
9 FUNCTION VALUE
10 (p_param_code IN VARCHAR2,
11 p_org_id IN NUMBER DEFAULT NULL)
12 RETURN VARCHAR2;
13
14 FUNCTION Get_AR_Sys_Params
15 (p_org_id IN NUMBER DEFAULT NULL)
16 RETURN AR_SYSTEM_PARAMETERS_ALL%ROWTYPE;
17
18 TYPE AR_Sys_Param_Tbl_Type IS TABLE OF AR_SYSTEM_PARAMETERS_ALL%ROWTYPE
19 INDEX BY BINARY_INTEGER;
20
21 --G_AR_Sys_Param_Rec AR_SYSTEM_PARAMETERS_ALL%ROWTYPE;
22 G_AR_Sys_Param_Tbl AR_Sys_Param_Tbl_Type;
23
24 END OE_Sys_Parameters_Pvt;