Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\wf\demo\wfevdems.sql
/*=======================================================================+ | Copyright (c) 2000 Oracle Corporation Redwood Shores, California, USA| | All rights reserved. | +=======================================================================+ | FILENAME | wfevdems.sql | | DESCRIPTION | PL/SQL spec for package: WF_EVENTDEMO | | NOTES | MODIFIED 10/10/00 Created *=======================================================================*/ /* $Header: wfevdems.sql 26.5 2001/05/01 19:16:26 kma ship $ */ whenever sqlerror exit failure rollback; create or replace package WF_EVENTDEMO as -- -- Procedure -- Print Error -- procedure Print_Error; -- -- Procedure -- Create Order -- -- Description Creates a Purchase Order. procedure Create_Order; -- -- Procedure -- Submit PO -- -- Description Inserts PO into table ands raises business event procedure SubmitPO (PO_Number in varchar2, Requestor in varchar2, Item_Number in varchar2, Item_Description in varchar2, Total_Cost in number, Delivery_Date in varchar2); -- -- Procedure -- Confirm Order -- -- Description Confirm Order procedure Confirm_Order( P_PO_NUMBER in varchar2); -- -- Procedure -- Process Order -- -- Description Process Order procedure Process_Order ( P_ITEM_KEY in varchar2); -- -- Procedure -- Track Order -- -- Description Track Order procedure Track_Order; -- -- Function -- Generate XML -- -- Description Generates XML PO function GenerateXML ( P_EVENT_NAME in varchar2, P_EVENT_KEY in varchar2 ) return clob; -- -- Procedure -- FindSupplier -- -- Description -- -- IN -- itemtype - A valid item type from (WF_ITEM_TYPES table). -- itemkey - A string generated from the application object's primary key. -- itemuserkey - A string generated from the application object user-friendly -- primary key. -- actid - The function activity(instance id). -- processowner - The username owner for this item instance. -- funcmode - Run/Cancel -- OUT -- resultout - Name of workflow process to run -- procedure FindSupplier ( itemtype in varchar2, itemkey in varchar2, actid in number, funcmode in varchar2, resultout out varchar2 ); -- -- Procedure -- StockCheck -- -- Description -- -- IN -- itemtype - A valid item type from (WF_ITEM_TYPES table). -- itemkey - A string generated from the application object's primary key. -- itemuserkey - A string generated from the application object user-friendly -- primary key. -- actid - The function activity(instance id). -- processowner - The username owner for this item instance. -- funcmode - Run/Cancel -- OUT -- resultout - Name of workflow process to run -- procedure StockCheck ( itemtype in varchar2, itemkey in varchar2, actid in number, funcmode in varchar2, resultout out varchar2 ); -- -- Procedure -- CheckShipping -- -- Description -- -- IN -- itemtype - A valid item type from (WF_ITEM_TYPES table). -- itemkey - A string generated from the application object's primary key. -- itemuserkey - A string generated from the application object user-friendly -- primary key. -- actid - The function activity(instance id). -- processowner - The username owner for this item instance. -- funcmode - Run/Cancel -- OUT -- resultout - Name of workflow process to run -- procedure CheckShipping ( itemtype in varchar2, itemkey in varchar2, actid in number, funcmode in varchar2, resultout out varchar2 ); -- -- Procedure -- CreateInvoice -- -- Description -- -- IN -- itemtype - A valid item type from (WF_ITEM_TYPES table). -- itemkey - A string generated from the application object's primary key. -- itemuserkey - A string generated from the application object user-friendly -- primary key. -- actid - The function activity(instance id). -- processowner - The username owner for this item instance. -- funcmode - Run/Cancel -- OUT -- resultout - Name of workflow process to run -- procedure CreateInvoice ( itemtype in varchar2, itemkey in varchar2, actid in number, funcmode in varchar2, resultout out varchar2 ); -- -- Function -- DeriveCorrelationID -- -- Description -- This rule function derives the correlation id from the event -- It will be associated with a subscription that fires before -- the main subscription which will be launch or continue a -- a workflow process. -- -- IN/OUT -- p_subscription in raw -- p_event in out wf_event_t -- RETURN -- varchar2 - SUCCESS, WARNING, ERROR -- function DeriveCorrelationID (p_subscription_guid in raw, p_event in out wf_event_t) return varchar2; end WF_EVENTDEMO; / show error package WF_EVENTDEMO commit; exit;
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de