DBA Data[Home] [Help]

APPS.WFJ_QUEUE dependencies on DBMS_AQ

Line 72: lDequeue_options dbms_aq.dequeue_options_t;

68: lCorrelation VARCHAR2(80);
69: lPayLoad SYSTEM.WF_PAYLOAD_T;
70: lMessageHandle raw(16);
71: lTimeout boolean;
72: lDequeue_options dbms_aq.dequeue_options_t;
73: lMessage_properties dbms_aq.message_properties_t;
74:
75: BEGIN
76:

Line 73: lMessage_properties dbms_aq.message_properties_t;

69: lPayLoad SYSTEM.WF_PAYLOAD_T;
70: lMessageHandle raw(16);
71: lTimeout boolean;
72: lDequeue_options dbms_aq.dequeue_options_t;
73: lMessage_properties dbms_aq.message_properties_t;
74:
75: BEGIN
76:
77: wf_queue.set_queue_names;

Line 90: dbms_aq.dequeue

86: lDequeue_options.wait := wfj_queue.dequeueDelay;
87: lDequeue_options.navigation := pNavigation;
88:
89: lMessageHandle := hextoraw(pMessageHandle);
90: dbms_aq.dequeue
91: (
92: queue_name => wf_queue.OutboundQueue,
93: dequeue_options => lDequeue_options,
94: message_properties => lMessage_properties,