351: INTO l_order_number
352: FROM OE_ORDER_HEADERS
353: WHERE header_id = l_header_id;
354:
355: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ORDER_NUMBER', l_order_number);
356:
357: -- Set workflow activity completion result
358: resultout := 'COMPLETE:Null';
359:
545: -- Completing all blocked check for hold processes for this order
546:
547: IF curr_block_process.activity_name = 'OE_HOLD_BLOCK' THEN
548:
549: WF_ENGINE.CompleteActivity( curr_block_process.item_type
550: , curr_block_process.item_key
551: , curr_block_process.activity_name
552: , NULL
553: );
555: -- Completing all waiting credit check processes
556:
557: ELSE
558:
559: WF_ENGINE.CompleteActivity( curr_block_process.item_type
560: , curr_block_process.item_key
561: , curr_block_process.activity_name
562: , 'APPROVED'
563: );
682: END IF;
683:
684: FOR current_ntf_data IN ntf_process_data LOOP
685:
686: WF_ENGINE.CompleteActivity(current_ntf_data.item_type
687: , current_ntf_data.item_key
688: , 'OE_CREDIT_HOLD_NTF'
689: , 'WAIT'
690: );
700: INTO l_order_number
701: FROM OE_ORDER_HEADERS
702: WHERE header_id = l_header_id;
703:
704: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ORDER_NUMBER', l_order_number);
705:
706: resultout := 'COMPLETE:Null';
707: return;
708:
769: -- start data fix project
770: OE_STANDARD_WF.Set_Msg_Context(actid);
771: -- end data fix project
772: -- Do nothing in cancel or timeout mode
773: if (funcmode <> wf_engine.eng_run) then
774: resultout := wf_engine.eng_null;
775: return;
776: end if;
777:
770: OE_STANDARD_WF.Set_Msg_Context(actid);
771: -- end data fix project
772: -- Do nothing in cancel or timeout mode
773: if (funcmode <> wf_engine.eng_run) then
774: resultout := wf_engine.eng_null;
775: return;
776: end if;
777:
778: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||
774: resultout := wf_engine.eng_null;
775: return;
776: end if;
777:
778: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||
779: ':'||wf_engine.eng_null;
780: exception
781: when others then
782: Wf_Core.Context('OE_CREDIT_WF', 'CREDIT_BLOCK', itemtype,
775: return;
776: end if;
777:
778: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||
779: ':'||wf_engine.eng_null;
780: exception
781: when others then
782: Wf_Core.Context('OE_CREDIT_WF', 'CREDIT_BLOCK', itemtype,
783: itemkey, to_char(actid), funcmode);
986: -- Retrieving the instance id for the credit checking process (NOT activity)
987: -- This assumes that this activity will always be called from within
988: -- the credit check process.
989:
990: l_fromact_id := wf_engine_util.activity_parent_process(itemtype
991: ,itemkey
992: ,actid);
993:
994: -- check if the next activity after credit check PROCESS is