APPS.WSH_ITM_UTIL dependencies on WSH_ITM_REQUEST_CONTROL

Line 180: UPDATE WSH_ITM_REQUEST_CONTROL

176: x_return_status := FND_API.G_RET_STS_SUCCESS;
177: oe_debug_pub.add('In the procedure WSH_ITM_UTIL.UPDATE_PROCESS_FLAG');
178:
179: FORALL i IN p_control_id_list.FIRST..p_control_id_list.LAST
180: UPDATE WSH_ITM_REQUEST_CONTROL
181: SET
182: PROCESS_FLAG = p_process_flag
183: WHERE REQUEST_CONTROL_ID = p_control_id_list(i);
184:

Line 212: WSH_ITM_REQUEST_CONTROL RC

208: SELECT VENDOR INTO x_service_provider FROM
209: ( SELECT 1 PRIORITY, V.SERVICE_PROVIDER VENDOR
210: FROM WSH_ITM_SERVICE_PREFERENCES US1,
211: WSH_ITM_VENDOR_SERVICES S, WSH_ITM_VENDORS V,
212: WSH_ITM_REQUEST_CONTROL RC
213: WHERE US1.APPLICATION_ID = RC.APPLICATION_ID AND
214: US1.MASTER_ORGANIZATION_ID = RC.MASTER_ORGANIZATION_ID AND
215: US1.VENDOR_SERVICE_ID = S.VENDOR_SERVICE_ID AND
216: S.VENDOR_ID = V.VENDOR_ID AND

Line 224: WSH_ITM_REQUEST_CONTROL RC

220: UNION
221: SELECT 2 PRIORITY, V.SERVICE_PROVIDER VENDOR
222: FROM WSH_ITM_SERVICE_PREFERENCES US1,
223: WSH_ITM_VENDOR_SERVICES S, WSH_ITM_VENDORS V,
224: WSH_ITM_REQUEST_CONTROL RC
225: WHERE US1.APPLICATION_ID = RC.APPLICATION_ID AND
226: US1.MASTER_ORGANIZATION_ID IS NULL AND
227: US1.VENDOR_SERVICE_ID = S.VENDOR_SERVICE_ID AND
228: S.VENDOR_ID = V.VENDOR_ID AND