APPS.WSH_ITM_UTIL SQL Statements

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

Line: 48

    SELECT      priority                        ,
                service_type                    ,
                addl_country_check_req          ,
                vendor_id                       ,
                supports_combination_flag
    FROM (
       SELECT 1 priority,
              s.service_type,
              s.addl_country_check_req,
              v.vendor_id,
              v.supports_combination_flag
       FROM   WSH_ITM_SERVICE_PREFERENCES us1,
	      WSH_ITM_VENDOR_SERVICES s,
	      WSH_ITM_VENDORS v
       WHERE  us1.application_id         = p_application_id   and
              us1.master_organization_id = p_master_organization_id  and
              us1.vendor_service_id      = s.vendor_service_id and
              us1.active_flag            = 'Y'and
              s.vendor_id                = v.vendor_id
       UNION
       SELECT 2 priority,
              s.service_type,
              s.addl_country_check_req,
              v.vendor_id,
              v.supports_combination_flag
       FROM   WSH_ITM_SERVICE_PREFERENCES us1,
	      WSH_ITM_VENDOR_SERVICES s,
	      WSH_ITM_VENDORS v
       WHERE  us1.application_id         = p_application_id   and
              us1.master_organization_id   is null  and
              us1.active_flag            = 'Y'and
              us1.vendor_service_id      = s.vendor_service_id and
              s.vendor_id                = v.vendor_id
	     ) order by priority;

Line: 94

        SELECT ITM_ADDITIONAL_COUNTRY_CODE
        INTO l_addl_country_code
        FROM WSH_SHIPPING_PARAMETERS
        WHERE organization_id = p_organization_id;

Line: 165

PROCEDURE UPDATE_PROCESS_FLAG (
       p_control_id_list             IN  CONTROL_ID_LIST,
       p_process_flag                IN  NUMBER,
       x_return_status               OUT NOCOPY  VARCHAR2)
IS
    l_sql_error            VARCHAR2(2000);

Line: 177

    oe_debug_pub.add('In the procedure WSH_ITM_UTIL.UPDATE_PROCESS_FLAG');

Line: 180

     UPDATE WSH_ITM_REQUEST_CONTROL
     SET
        PROCESS_FLAG = p_process_flag
     WHERE REQUEST_CONTROL_ID = p_control_id_list(i);

Line: 185

    oe_debug_pub.add('End of the procedure WSH_ITM_UTIL.UPDATE_PROCESS_FLAG');

Line: 195

  END UPDATE_PROCESS_FLAG;

Line: 208

	SELECT VENDOR INTO x_service_provider FROM
	( SELECT 1 PRIORITY, V.SERVICE_PROVIDER VENDOR
  	  FROM WSH_ITM_SERVICE_PREFERENCES US1,
	  WSH_ITM_VENDOR_SERVICES S, WSH_ITM_VENDORS V,
  		WSH_ITM_REQUEST_CONTROL RC
  	  WHERE US1.APPLICATION_ID = RC.APPLICATION_ID AND
  	        US1.MASTER_ORGANIZATION_ID = RC.MASTER_ORGANIZATION_ID  AND
  		US1.VENDOR_SERVICE_ID = S.VENDOR_SERVICE_ID AND
  		S.VENDOR_ID = V.VENDOR_ID AND
  		US1.ACTIVE_FLAG = 'Y' AND
  		S.SERVICE_TYPE = RC.SERVICE_TYPE_CODE AND
  		RC.REQUEST_CONTROL_ID = p_request_control_id
  	 UNION
  	 SELECT 2 PRIORITY, V.SERVICE_PROVIDER VENDOR
  	 FROM WSH_ITM_SERVICE_PREFERENCES US1,
  		WSH_ITM_VENDOR_SERVICES S, WSH_ITM_VENDORS V,
  		WSH_ITM_REQUEST_CONTROL RC
  	 WHERE US1.APPLICATION_ID = RC.APPLICATION_ID AND
  		US1.MASTER_ORGANIZATION_ID IS NULL AND
  		US1.VENDOR_SERVICE_ID = S.VENDOR_SERVICE_ID AND
  		S.VENDOR_ID = V.VENDOR_ID AND
  		US1.ACTIVE_FLAG = 'Y' AND
  		S.SERVICE_TYPE = RC.SERVICE_TYPE_CODE AND
  		RC.REQUEST_CONTROL_ID = p_request_control_id
  	ORDER BY PRIORITY
	) WHERE ROWNUM < 2;