APPS.WF_BES_CLEANUP dependencies on WF_BES_SUBSCRIBER_PINGS

Line 48: update wf_bes_subscriber_pings

44: p_subscriber_name in varchar2)
45: is
46: PRAGMA AUTONOMOUS_TRANSACTION;
47: begin
48: update wf_bes_subscriber_pings
49: set status = STATUS_RESPONDED,
50: action_time = sysdate
51: where ping_number = p_ping_number
52: and queue_name = p_queue_name

Line 75: insert into wf_bes_subscriber_pings

71: p_queue_name in varchar2,
72: p_subscriber_name in varchar2)
73: is
74: begin
75: insert into wf_bes_subscriber_pings
76: (
77: ping_number,
78: ping_time,
79: queue_name,

Line 268: update wf_bes_subscriber_pings

264: subscriber => sys.aq$_agent(p_subscriber_name, null, null));
265:
266: -- mark the subscriber removed
267:
268: update wf_bes_subscriber_pings
269: set status = STATUS_REMOVED,
270: action_time = sysdate
271: where queue_name = p_queue_name
272: and subscriber_name = p_subscriber_name

Line 287: update wf_bes_subscriber_pings

283: exception
284: when others then
285: -- the attempt to remove the subscriber failed
286:
287: update wf_bes_subscriber_pings
288: set status = STATUS_REMOVE_FAILED,
289: action_time = sysdate
290: where queue_name = p_queue_name
291: and subscriber_name = p_subscriber_name

Line 371: from wf_bes_subscriber_pings

367: -- would be STATUS_RESPONDED.
368:
369: cursor dead_subscribers is
370: select distinct queue_name, subscriber_name
371: from wf_bes_subscriber_pings
372: where ping_time < sysdate - G_MIN_WAIT_TIME
373: and status = STATUS_PINGED;
374:
375: l_owner varchar2(30);

Line 389: from wf_bes_subscriber_pings;

385: -- get the last ping time
386:
387: select max(ping_time)
388: into l_last_ping_time
389: from wf_bes_subscriber_pings;
390:
391: if(l_last_ping_time is null) then
392: -- wf_bes_subscriber_pings table is empty so set the last ping time to be very old
393:

Line 392: -- wf_bes_subscriber_pings table is empty so set the last ping time to be very old

388: into l_last_ping_time
389: from wf_bes_subscriber_pings;
390:
391: if(l_last_ping_time is null) then
392: -- wf_bes_subscriber_pings table is empty so set the last ping time to be very old
393:
394: l_last_ping_time := to_date('1900/01/01', 'YYYY/MM/DD');
395: end if;
396:

Line 489: from wf_bes_subscriber_pings

485:
486: -- remove the data older than G_MAX_RETENTION_TIME
487:
488: delete
489: from wf_bes_subscriber_pings
490: where ping_time < sysdate - G_MAX_RETENTION_TIME;
491:
492: commit;
493: