APPS.WSH_OTM_SYNC_REF_DATA_PKG dependencies on WSH_OTM_SYNC_REF_DATA_LOG

Line 211: FROM wsh_otm_sync_ref_data_log

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

Line 226: FROM wsh_otm_sync_ref_data_log

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

Line 301: FROM wsh_otm_sync_ref_data_log

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

Line 321: FROM wsh_otm_sync_ref_data_log

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

Line 516: INSERT INTO wsh_otm_sync_ref_data_log (transmission_id,

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