1: package body bis_intermediate_lov_pvt as
2: /* $Header: BISVIMTB.pls 120.1 2005/10/28 08:16:02 visuri noship $ */
3: -- *******************************************************
4: -- Procedure creates the SQL query
5: -- *******************************************************
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:
63: -- (3)Build two SQL queries, one for the statement and the other for
64: -- the row count
65:
288: when others then BISVIEWER.displayError(380,SQLCODE,SQLERRM);
289: END getLOVSQL;
290:
291: -- ****************************************************
292: end bis_intermediate_lov_pvt;