APPS.WMS_CAROUSEL_INTEGRATION_PKG dependencies on USER_JOBS

Line 189: FROM user_jobs

185: LOOP
186: BEGIN
187: select 1 INTO l_dummy from (
188: SELECT job,what, (substr(what, instr(what,'''',-1,2)+1, (instr(what,'''',-1,1) - instr(what,'''',-1,2) - 1))) pipe_name
189: FROM user_jobs
190: WHERE UPPER (what) LIKE '%WMS_CAROUSEL_INTEGRATION_PKG.PIPE_LISTENER_LOOP%')
191: where pipe_name = v_pipename;
192: IF (l_debug > 0) THEN
193: WMS_CAROUSEL_INTEGRATION_PVT.LOG (v_cfg.device_id, 'Job already exists:'

Line 241: FROM user_jobs

237: CURSOR c_pipe_listeners (p_pipe_name IN VARCHAR2)
238: IS
239: select distinct * from (
240: SELECT job,what, (substr(what, instr(what,'''',-1,2)+1, (instr(what,'''',-1,1) - instr(what,'''',-1,2) - 1))) pipe_name
241: FROM user_jobs
242: WHERE UPPER (what) LIKE '%WMS_CAROUSEL_INTEGRATION_PKG.PIPE_LISTENER_LOOP%')
243: where pipe_name = nvl(p_pipe_name, pipe_name);
244:
245: v_pipename VARCHAR2(50);

Line 284: FROM user_jobs

280: CURSOR c_pipe_listeners (p_pipe_name IN VARCHAR2)
281: IS
282: select * from (
283: SELECT job,what, (substr(what, instr(what,'''',-1,2)+1, (instr(what,'''',-1,1) - instr(what,'''',-1,2) - 1))) pipe_name
284: FROM user_jobs
285: WHERE UPPER (what) LIKE '%WMS_CAROUSEL_INTEGRATION_PKG.PIPE_LISTENER_LOOP%')
286: where pipe_name = nvl(p_pipe_name, pipe_name);
287:
288: v_pipename VARCHAR2(50) := NULL;

Line 327: FROM user_jobs

323: -- Cursor for receive pipes
324: CURSOR c_pipe_listeners
325: IS
326: SELECT job, what
327: FROM user_jobs
328: WHERE UPPER (what) LIKE '%WMS_CAROUSEL_INTEGRATION_PKG.PIPE_LISTENER_LOOP%';
329:
330: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
331: PRAGMA AUTONOMOUS_TRANSACTION;