APPS.WMS_CAROUSEL_INTEGRATION_PKG dependencies on WMS_CAROUSEL_INTEGRATION_PKG

Line 1: PACKAGE BODY WMS_CAROUSEL_INTEGRATION_PKG AS

1: PACKAGE BODY WMS_CAROUSEL_INTEGRATION_PKG AS
2: /* $Header: WMSCSPBB.pls 120.4 2005/10/17 03:58:36 simran noship $ */
3:
4: PROCEDURE sync_device_request (
5: p_request_id IN NUMBER,

Line 190: WHERE UPPER (what) LIKE '%WMS_CAROUSEL_INTEGRATION_PKG.PIPE_LISTENER_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:'
194: || ' ID='

Line 211: 'WMS_CAROUSEL_INTEGRATION_PKG.PIPE_LISTENER_LOOP('

207: next_date => SYSDATE,
208: INTERVAL => 'sysdate + (10/(24*3600))'
209: );
210: job_str :=
211: 'WMS_CAROUSEL_INTEGRATION_PKG.PIPE_LISTENER_LOOP('
212: || v_job
213: || ',''' || v_cfg.subinventory_code || ''''
214: || ',' || v_cfg.device_id
215: || ',''' || v_pipename || ''');';

Line 242: WHERE UPPER (what) LIKE '%WMS_CAROUSEL_INTEGRATION_PKG.PIPE_LISTENER_LOOP%')

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);
246: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 285: WHERE UPPER (what) LIKE '%WMS_CAROUSEL_INTEGRATION_PKG.PIPE_LISTENER_LOOP%')

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;
289: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 328: WHERE UPPER (what) LIKE '%WMS_CAROUSEL_INTEGRATION_PKG.PIPE_LISTENER_LOOP%';

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;
332: BEGIN

Line 474: END WMS_CAROUSEL_INTEGRATION_PKG;

470: END IF;
471: CLOSE c_tasks;
472: END;
473: --
474: END WMS_CAROUSEL_INTEGRATION_PKG;