APPS.WSH_U_RASS SQL Statements

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

Line: 124

     L_OUTPUT.delete;

Line: 160

						p_API_Name		=> 'RATING_AND_SERVICE_SELECTION');

Line: 967

	p_select_statement  IN       varchar2,
	x_headers           IN OUT NOCOPY    wsh_u_rass.HeaderRecTableTyp)


is

l_CursorID integer;

Line: 974

l_SelectStmt VARCHAR2(3000) := NULL;

Line: 988

/* 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: 1010

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

Line: 1014

l_SelectStmt := p_select_statement;

Line: 1015

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