APPS.WF_QUEUE dependencies on WF_PAYLOAD_T

Line 87: p_payload in out nocopy system.wf_payload_t)

83: procedure Process_Inbound_Event(itemtype in varchar2,
84: itemkey in varchar2,
85: actid in number,
86: message_handle in raw,
87: p_payload in out nocopy system.wf_payload_t)
88: as
89: colon number;
90: status varchar2(30);
91:

Line 295: event system.wf_payload_t;

291: procedure PurgeEvent(queuename in varchar2,
292: message_handle in raw,
293: multiconsumer in boolean default FALSE) as
294:
295: event system.wf_payload_t;
296: dequeue_options dbms_aq.dequeue_options_t;
297: message_properties dbms_aq.message_properties_t;
298: msg_id raw(16);
299: begin

Line 347: event system.wf_payload_t;

343: procedure PurgeItemtype(queuename in varchar2,
344: itemtype in varchar2 default null,
345: correlation in varchar2 default null )
346: as
347: event system.wf_payload_t;
348: dequeue_options dbms_aq.dequeue_options_t;
349: message_properties dbms_aq.message_properties_t;
350: msg_id raw(16);
351:

Line 617: payload out NOCOPY system.wf_payload_t,

613: dequeuemode in number,
614: navigation in number default 1,
615: correlation in varchar2 default null,
616: itemtype in varchar2 default null,
617: payload out NOCOPY system.wf_payload_t,
618: message_handle in out NOCOPY raw,
619: timeout out NOCOPY boolean)
620:
621: as

Line 667: event system.wf_payload_t;

663: param_list out NOCOPY varchar2,
664: message_handle in out NOCOPY raw,
665: timeout out NOCOPY boolean)
666: as
667: event system.wf_payload_t;
668: lcorrelation varchar2(80);
669: begin
670: wf_queue.set_queue_names;
671:

Line 720: payload out NOCOPY system.wf_payload_t,

716: procedure Dequeue_Event(queuename in varchar2,
717: dequeuemode in number,
718: navigation in number default 1,
719: correlation in varchar2 default null,
720: payload out NOCOPY system.wf_payload_t,
721: message_handle in out NOCOPY raw,
722: timeout out NOCOPY boolean,
723: multiconsumer in boolean default FALSE)
724: as

Line 814: function activity_valid (event in system.wf_payload_t,

810: -- message_handle of event in the deferred queue
811: -- maxthreshold - the threshold level
812: -- minthreshold
813: --
814: function activity_valid (event in system.wf_payload_t,
815: message_handle in raw,
816: maxthreshold in number default null,
817: minthreshold in number default null)
818: return BOOLEAN is

Line 911: event system.wf_payload_t;

907: message_handle in out NOCOPY raw,
908: priority in number default null)
909:
910: as
911: event system.wf_payload_t;
912: enqueue_options dbms_aq.enqueue_options_t;
913: message_properties dbms_aq.message_properties_t;
914: l_increment_delay number;
915: l_min_delay number;

Line 991: event:=system.wf_payload_t(itemtype,itemkey,actid,funcname,paramlist,result);

987: end if;
988:
989: wf_queue.set_queue_names;
990: -- construct the event object
991: event:=system.wf_payload_t(itemtype,itemkey,actid,funcname,paramlist,result);
992:
993: -- dont make the data visible on the queue until a commit is issued
994: -- this way queue data and normal table data (wf statuses) are in synch.
995: enqueue_options.visibility := DBMS_AQ.ON_COMMIT;

Line 1059: payload system.wf_payload_t;

1055: procedure ProcessInboundQueue (itemtype in varchar2 default null,
1056: correlation in varchar2 default null)
1057: as
1058:
1059: payload system.wf_payload_t;
1060: navigation varchar2(10);
1061: timeout boolean:= FALSE;
1062: cursor_name number;
1063: row_processed integer;

Line 1159: payload system.wf_payload_t;

1155: maxthreshold in number default null,
1156: correlation in varchar2 default null)
1157:
1158: as
1159: payload system.wf_payload_t;
1160: timeout boolean:= FALSE;
1161: navigation varchar2(10);
1162: row_processed integer;
1163: message_handle raw(16);

Line 1295: event system.wf_payload_t;

1291: actid in number,
1292: correlation in varchar2 default null,
1293: multiconsumer in boolean default FALSE) return raw
1294: is
1295: event system.wf_payload_t;
1296: dequeue_options dbms_aq.dequeue_options_t;
1297: message_properties dbms_aq.message_properties_t;
1298: msg_id raw(16);
1299: begin