172: l_api_version CONSTANT NUMBER := 1.0;
173: l_dynamic_sql VARCHAR2(32767);
174: l_sec_predicate VARCHAR2(32767);
175: BEGIN
176: -- Standard Start of API savepoint
177: SAVEPOINT search_supplier_and_site_pvt;
178: set_globals();
179: -- Standard call to check for call compatibility.
180: IF NOT fnd_api.Compatible_API_Call ( l_api_version
175: BEGIN
176: -- Standard Start of API savepoint
177: SAVEPOINT search_supplier_and_site_pvt;
178: set_globals();
179: -- Standard call to check for call compatibility.
180: IF NOT fnd_api.Compatible_API_Call ( l_api_version
181: ,p_api_version
182: ,l_api_name
183: ,G_PKG_NAME )