APPS.WSH_OTM_SYNC_REF_DATA_PKG dependencies on WSH_OTM_SYNC_REF_DATA_LOG

Line 209: FROM wsh_otm_sync_ref_data_log

205:
206: --Cursor to get sync_ref_id's for given transmission_id
207: CURSOR c_get_sync_ref_id(p_trans_id NUMBER) IS
208: SELECT distinct entity_type, sync_ref_id
209: FROM wsh_otm_sync_ref_data_log
210: WHERE transmission_id = p_trans_id
211: ORDER BY entity_type, sync_ref_id;
212:
213:

Line 224: FROM wsh_otm_sync_ref_data_log

220:
221: --Cursor to obtain the first sent_date
222: CURSOR c_get_sent_date(p_sync_id NUMBER) IS
223: SELECT sent_date
224: FROM wsh_otm_sync_ref_data_log
225: WHERE sync_ref_id = p_sync_id
226: AND rownum = 1;
227:
228:

Line 299: FROM wsh_otm_sync_ref_data_log

295: END IF;
296:
297: --Delete data from WOSRDL for l_sync_ref_id
298: DELETE
299: FROM wsh_otm_sync_ref_data_log
300: WHERE sync_ref_id = l_sync_ref_id;
301:
302: EXCEPTION
303: WHEN OTHERS THEN

Line 319: FROM wsh_otm_sync_ref_data_log

315: WSH_DEBUG_SV.log(l_module_name,'Error case. So deleting all the data from WOSRDL for transmission_id ', p_transmission_id);
316: END IF;
317:
318: DELETE
319: FROM wsh_otm_sync_ref_data_log
320: WHERE transmission_id = p_transmission_id;
321: END IF;
322:
323: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 513: INSERT INTO wsh_otm_sync_ref_data_log (transmission_id,

509: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_TYPE ',P_ENTITY_TYPE);
510: END IF;
511:
512: --Inset data into the table
513: INSERT INTO wsh_otm_sync_ref_data_log (transmission_id,
514: sync_ref_id,
515: entity_type,
516: sent_date,
517: creation_date,