DBA Data[Home] [Help]

APPS.BIS_INTERMEDIATE_LOV_PVT dependencies on BIS_LOV_PUB

Line 25: l_col_object bis_lov_pub.colinfo_table;

21: l_sql varchar2(32000);
22: l_temp varchar2(32000);
23: l_sqlcount varchar2(32000);
24: l_procname varchar2(200);
25: l_col_object bis_lov_pub.colinfo_table;
26: l_search_str varchar2(200);
27: l_view_name varchar2(80);
28: l_short_name varchar2(30);
29: l_dimension_short_name varchar2(30);

Line 58: l_search_str := bis_lov_pub.concat_string(p_search_str);

54: --if icx_sec.validateSession then
55: -- mdamle 01/15/2001 - Modified routine to use getLOVSQL for EDW
56:
57: -- (1) Call a function to plug the the ' on both sides of the search string
58: l_search_str := bis_lov_pub.concat_string(p_search_str);
59:
60: -- (2)Set the procedure name
61: l_procname := 'bis_intermediate_lov_pvt.dim_level_values_query';
62:

Line 132: bis_lov_pub.main (p_procname => l_procname,

128:
129:
130: IF l_rel_dim_lev_g_var IS NOT NULL
131: THEN
132: bis_lov_pub.main (p_procname => l_procname,
133: p_qrycnd => p_qrycnd,
134: p_jsfuncname => p_jsfuncname,
135: p_startnum => p_startnum,
136: p_rowcount => bis_lov_pub.c_rowcount,

Line 136: p_rowcount => bis_lov_pub.c_rowcount,

132: bis_lov_pub.main (p_procname => l_procname,
133: p_qrycnd => p_qrycnd,
134: p_jsfuncname => p_jsfuncname,
135: p_startnum => p_startnum,
136: p_rowcount => bis_lov_pub.c_rowcount,
137: p_totalcount => p_totalcount,
138: p_search_str => p_search_str,
139: p_dim_level_id => l_dim_level_id,
140: p_sqlcount => l_sqlcount,

Line 152: bis_lov_pub.main (p_procname => l_procname,

148:
149:
150: ELSE
151:
152: bis_lov_pub.main (p_procname => l_procname,
153: p_qrycnd => p_qrycnd,
154: p_jsfuncname => p_jsfuncname,
155: p_startnum => p_startnum,
156: p_rowcount => bis_lov_pub.c_rowcount,

Line 156: p_rowcount => bis_lov_pub.c_rowcount,

152: bis_lov_pub.main (p_procname => l_procname,
153: p_qrycnd => p_qrycnd,
154: p_jsfuncname => p_jsfuncname,
155: p_startnum => p_startnum,
156: p_rowcount => bis_lov_pub.c_rowcount,
157: p_totalcount => p_totalcount,
158: p_search_str => p_search_str,
159: p_dim_level_id => l_dim_level_id,
160: p_sqlcount => l_sqlcount,