APPS.JTF_USR_HKS dependencies on DBMS_ALERT

Line 541: l_wait_time := DBMS_ALERT.MAXWAIT;

537: l_msg_type := 'ASYNC_REQUEST';
538: l_wait_time := 0;
539: elsif (p_timeout < 0) then
540: l_msg_type := 'SYNC_REQUEST';
541: l_wait_time := DBMS_ALERT.MAXWAIT;
542: else
543: l_msg_type := 'SYNC_REQUEST';
544: l_wait_time := p_timeout;
545: end if;

Line 563: DBMS_ALERT.REGISTER(l_alert_name);

559:
560: if (p_timeout <> 0) then
561: l_alert_name := 'JTF' || x_msg_id;
562:
563: DBMS_ALERT.REGISTER(l_alert_name);
564: DBMS_ALERT.WAITONE(
565: l_alert_name,
566: l_alert_message,
567: l_alert_status,

Line 564: DBMS_ALERT.WAITONE(

560: if (p_timeout <> 0) then
561: l_alert_name := 'JTF' || x_msg_id;
562:
563: DBMS_ALERT.REGISTER(l_alert_name);
564: DBMS_ALERT.WAITONE(
565: l_alert_name,
566: l_alert_message,
567: l_alert_status,
568: l_wait_time

Line 571: DBMS_ALERT.REMOVE(l_alert_name);

567: l_alert_status,
568: l_wait_time
569: );
570:
571: DBMS_ALERT.REMOVE(l_alert_name);
572:
573: if (l_alert_status = 0) then
574:
575: delete from JTF_SYNC_REPLY_MSG

Line 631: l_wait_time := DBMS_ALERT.MAXWAIT;

627:
628: if (p_timeout = 0) then
629: l_wait_time := 0;
630: elsif (p_timeout < 0) then
631: l_wait_time := DBMS_ALERT.MAXWAIT;
632: else
633: l_wait_time := p_timeout;
634: end if;
635: end if;

Line 658: DBMS_ALERT.REGISTER(l_alert_name);

654: if (( p_msg_type = 'R') AND ( p_timeout <> 0)) then
655:
656: l_alert_name := 'JTF' || x_msg_id;
657:
658: DBMS_ALERT.REGISTER(l_alert_name);
659: DBMS_ALERT.WAITONE(
660: l_alert_name,
661: l_alert_message,
662: l_alert_status,

Line 659: DBMS_ALERT.WAITONE(

655:
656: l_alert_name := 'JTF' || x_msg_id;
657:
658: DBMS_ALERT.REGISTER(l_alert_name);
659: DBMS_ALERT.WAITONE(
660: l_alert_name,
661: l_alert_message,
662: l_alert_status,
663: l_wait_time

Line 666: DBMS_ALERT.REMOVE(l_alert_name);

662: l_alert_status,
663: l_wait_time
664: );
665:
666: DBMS_ALERT.REMOVE(l_alert_name);
667:
668: if (l_alert_status = 0) then
669:
670: delete from JTF_SYNC_REPLY_MSG