APPS.WSH_U_RASS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 129

   l_output.delete;

Line: 196

						p_API_Name		=> 'RATING_AND_SERVICE_SELECTION');

Line: 1042

        ( p_select_statement  IN       VARCHAR2
        , x_headers           IN OUT NOCOPY    wsh_u_rass.HeaderRecTableTyp)
IS

l_cursorid                INTEGER;

Line: 1047

l_SelectStmt              VARCHAR2(3000) := NULL;

Line: 1061

/* construct a dynamic sql select statement and get the
   records */

/* the sql statement should look like
  select distinct ship_from_location_id, ship_to_location_id
  from (
	select * from wsh_delivery_detail_id where delivery_detail_id
	in (4941, 4942))
*/

--
--
   l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line: 1084

      WSH_DEBUG_SV.log(l_module_name,'P_SELECT_STATEMENT',P_SELECT_STATEMENT);

Line: 1088

   l_SelectStmt := p_select_statement;

Line: 1089

   DBMS_SQL.PARSE(l_CursorID, l_SelectStmt, DBMS_SQL.V7);