PACKAGE: APPS.BIS_INTERMEDIATE_LOV_PVT

Source

1 package bis_intermediate_lov_pvt as
2 /* $Header: BISVIMTS.pls 120.1 2005/10/28 08:17:06 visuri noship $ */
3 c_orgid        CONSTANT varchar2(60) := 'Org Id';
4 c_organization CONSTANT varchar2(80) := 'Organization';
5 c_orglevel     CONSTANT varchar2(60) := 'Org Level Name';
6 c_percent      CONSTANT varchar2(1)  := '%';
7 
8 procedure dim_level_values_query
9 ( p_qrycnd        in varchar2    default NULL
10  ,p_jsfuncname    in varchar2    default NULL
11  ,p_startnum      in pls_integer default NULL
12  ,p_rowcount      in pls_integer default NULL
13  ,p_totalcount    in pls_integer default NULL
14  ,p_search_str    in varchar2    default NULL
15 ,Z                in pls_integer default NULL
16 ,p_dim1_lbl       in varchar2    default NULL  -- 1797465
17 ,x_string         out nocopy VARCHAR2
18 );
19 
20 -- mdamle 01/15/2001 - add getLOVSQL
21 function getLOVSQL (p_dim_level_id       in number,
22                     p_dimn_level_value       in varchar2,
23                     p_sql_type               in varchar2 default null,
24           p_user_id                in number)
25     return varchar2;
26 
27 end bis_intermediate_lov_pvt;