APPS.WF_QUEUE dependencies on WF_ITEMS

Line 839: WF_ITEMS WI,

835: SELECT CWA.COST, CWIAS.BEGIN_DATE
836: into cost, l_begdate
837: FROM WF_ITEM_ACTIVITY_STATUSES CWIAS,
838: WF_PROCESS_ACTIVITIES CWPA,
839: WF_ITEMS WI,
840: WF_ACTIVITIES CWA
841: where CWIAS.ACTIVITY_STATUS = 'DEFERRED'
842: and CWIAS.PROCESS_ACTIVITY = CWPA.INSTANCE_ID
843: and CWPA.ACTIVITY_ITEM_TYPE = CWA.ITEM_TYPE

Line 915: l_inst_id WF_ITEMS.INST_ID%TYPE;

911: message_properties dbms_aq.message_properties_t;
912: l_increment_delay number;
913: l_min_delay number;
914: l_background_occurrence number;
915: l_inst_id WF_ITEMS.INST_ID%TYPE;
916: l_process WF_ITEMS.ROOT_ACTIVITY%TYPE;
917:
918: begin
919:

Line 916: l_process WF_ITEMS.ROOT_ACTIVITY%TYPE;

912: l_increment_delay number;
913: l_min_delay number;
914: l_background_occurrence number;
915: l_inst_id WF_ITEMS.INST_ID%TYPE;
916: l_process WF_ITEMS.ROOT_ACTIVITY%TYPE;
917:
918: begin
919:
920: l_increment_delay := delay;

Line 1017: from WF_ITEMS

1013: else
1014: message_properties.correlation := wf_queue.account_name||itemtype;
1015: l_inst_id := sys_context('WF_RAC_CTX','INST_ID');
1016: select ROOT_ACTIVITY into l_process
1017: from WF_ITEMS
1018: where ITEM_TYPE=itemtype
1019: and ITEM_KEY=itemkey;
1020: if l_inst_id is not null and WF_ENGINE_RAC.Process_Is_RAC_Enabled(itemtype, l_process) then
1021: message_properties.correlation := message_properties.correlation||':'||l_inst_id;

Line 1177: l_inst_id WF_ITEMS.INST_ID%TYPE;

1173: message_handle raw(16);
1174: -- first_time boolean := TRUE;
1175: nothing_processed boolean:=TRUE;
1176: lcorrelation varchar2(80);
1177: l_inst_id WF_ITEMS.INST_ID%TYPE;
1178:
1179: begin
1180:
1181: -- Bug 4005674