DBA Data[Home] [Help]

APPS.WMS_CAROUSEL_INTEGRATION_PKG dependencies on DBMS_JOB

Line 205: DBMS_JOB.submit (job => v_job,

201: END IF;
202: EXCEPTION
203: WHEN NO_DATA_FOUND THEN
204: -- Submit a job
205: DBMS_JOB.submit (job => v_job,
206: what => 'begin null; end;',
207: next_date => SYSDATE,
208: INTERVAL => 'sysdate + (10/(24*3600))'
209: );

Line 217: DBMS_JOB.what (v_job, job_str);

213: || ',''' || v_cfg.subinventory_code || ''''
214: || ',' || v_cfg.device_id
215: || ',''' || v_pipename || ''');';
216:
217: DBMS_JOB.what (v_job, job_str);
218:
219: IF (l_debug > 0) THEN
220: WMS_CAROUSEL_INTEGRATION_PVT.LOG (v_cfg.device_id, 'New Job Created:'
221: || ' ID='

Line 263: DBMS_JOB.broken(v_job.job,false,null);

259: -- Start jobs
260: FOR v_job IN c_pipe_listeners(v_pipename)
261: LOOP
262: -- Start the job
263: DBMS_JOB.broken(v_job.job,false,null);
264: IF (l_debug > 0) THEN
265: wms_carousel_integration_pvt.LOG ( p_device_id, 'Job Started:'
266: || ' ID='
267: || v_job.job

Line 306: DBMS_JOB.broken(v_job.job,true,null);

302: -- Stop jobs
303: FOR v_job IN c_pipe_listeners(v_pipename)
304: LOOP
305: -- Stop the job
306: DBMS_JOB.broken(v_job.job,true,null);
307: IF (l_debug > 0) THEN
308: wms_carousel_integration_pvt.LOG ( p_device_id, 'Job Stopped:'
309: || ' ID='
310: || v_job.job

Line 337: DBMS_JOB.remove (v_job.job);

333: -- Remove jobs
334: FOR v_job IN c_pipe_listeners
335: LOOP
336: -- Remove the job
337: DBMS_JOB.remove (v_job.job);
338: IF (l_debug > 0) THEN
339: wms_carousel_integration_pvt.LOG ( NULL, 'Job Removed:'
340: || ' ID='
341: || v_job.job