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

Line 252: -- Before OM inserts a record in Wsh_Itm_Request_Control table, if there exists a record

248: -- Pre-reqs : None
249: -- Function : This API can be used to get the compliance status of the ITM request control lines
250: -- In case if multiple request lines are present this will only return the first record
251: -- found with the matching i/p criteria
252: -- Before OM inserts a record in Wsh_Itm_Request_Control table, if there exists a record
253: -- in WIRC table for same order line then OM (OEXVITMB.pls) calls API
254: -- WSH_ITM_UTIL.Update_process_Flag to update the process_flag value to 4.
255: -- So, while querying from WIRC table ignore record with process_flag value 4.
256: --

Line 287: FROM wsh_itm_request_control WRC

283: CURSOR c_get_compliance_details(l_appliciation_id NUMBER,l_original_sys_reference NUMBER ,l_original_sys_line_reference NUMBER) IS
284: SELECT process_flag,
285: request_control_id,
286: request_set_id
287: FROM wsh_itm_request_control WRC
288: WHERE wrc.application_id = l_appliciation_id AND
289: wrc.original_system_reference = l_original_sys_reference AND
290: wrc.original_system_line_reference = l_original_sys_line_reference AND
291: wrc.process_flag <> 4;