PACKAGE: APPS.WSH_PARAMETERS_PVT

Source

1 PACKAGE WSH_PARAMETERS_PVT AUTHID CURRENT_USER as
2 /* $Header: WSHUPRMS.pls 115.0 99/07/16 08:23:26 porting ship $ */
3 --
4 -- Package
5 --   WSH_PARAMETERS_PVT
6 -- Purpose
7 --   Contains common routines to fetch and store parameter values
8 --   from wsh_parameters table
9 -- History
10 --   10-SEP-96	ANEOGI	Created
11 --
12 
13   --
14   -- PUBLIC VARIABLES
15   --
16 
17   --
18   -- PUBLIC FUNCTIONS
19   --
20 
21   -- Name
22   --   get_param_value
23   -- Purpose
24   --   Optionally fetches row from wsh_parameters table and pass
25   --   value of the given parameter
26   -- Arguments
27   --   organization_id (Oraginization_ID in wsh_parameters table)
28   --   param_name IN VARCHAR2
29   --   param_value OUT VARCHAR2/NUMBER
30 
31   PROCEDURE get_param_value( x_organization_id IN NUMBER,
32 			     param_name IN VARCHAR2,
33 			     param_value OUT VARCHAR2 );
34 
35   PROCEDURE get_param_value_num( x_organization_id IN NUMBER,
36 			         param_name IN VARCHAR2,
37 			         param_value OUT NUMBER );
38 
39 
40 END WSH_PARAMETERS_PVT;