Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\wf\sql\WFEVAGTS.pls
REM dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=pls \ REM dbdrv: checkfile:~PROD:~PATH:~FILE /*=======================================================================+ | Copyright (c) 2000 Oracle Corporation Redwood Shores, California, USA| | All rights reserved. | +=======================================================================+ | FILENAME | WFEVAGTS.pls | DESCRIPTION | PL/SQL spec for package: WF_AGENTS_PKG | | PROCEDURE insert_row | PROCEDURE update_row | PROCEDURE delete_row | PROCEDURE load_row | FUNCTION generate | PROCEDURE receive *=======================================================================*/ SET VERIFY OFF WHENEVER SQLERROR EXIT FAILURE ROLLBACK; WHENEVER OSERROR EXIT FAILURE ROLLBACK; create or replace package WF_AGENTS_PKG as /* $Header: WFEVAGTS.pls 26.6 2004/05/18 06:01:18 vshanmug ship $ */ /*# * This package provides the APIs that an Application Program or Business Event * System can call to communicate Agent objects to and from the database tables. * @rep:scope public * @rep:product OWF * @rep:displayname Workflow Agents Package * @rep:lifecycle active * @rep:compatibility S * @rep:category BUSINESS_ENTITY WF_EVENT * @rep:ihelp FND/@besrepapis See the related online help */ ----------------------------------------------------------------------------- procedure INSERT_ROW ( X_ROWID in out nocopy varchar2, X_GUID in raw, X_NAME in varchar2, X_SYSTEM_GUID in raw, X_PROTOCOL in varchar2, X_ADDRESS in varchar2, X_QUEUE_HANDLER in varchar2, X_QUEUE_NAME in varchar2, X_DIRECTION in varchar2, X_STATUS in varchar2, X_DISPLAY_NAME in varchar2, X_DESCRIPTION in varchar2, X_TYPE in varchar2 default 'AGENT', X_JAVA_QUEUE_HANDLER in varchar2 default null ); ----------------------------------------------------------------------------- procedure UPDATE_ROW ( X_GUID in raw, X_NAME in varchar2, X_SYSTEM_GUID in raw, X_PROTOCOL in varchar2, X_ADDRESS in varchar2, X_QUEUE_HANDLER in varchar2, X_QUEUE_NAME in varchar2, X_DIRECTION in varchar2, X_STATUS in varchar2, X_DISPLAY_NAME in varchar2, X_DESCRIPTION in varchar2, X_TYPE in varchar2 default null, X_JAVA_QUEUE_HANDLER in varchar2 default null ); ----------------------------------------------------------------------------- procedure DELETE_ROW ( X_GUID in raw ); ----------------------------------------------------------------------------- procedure LOAD_ROW ( X_GUID in raw, X_NAME in varchar2, X_SYSTEM_GUID in raw, X_PROTOCOL in varchar2, X_ADDRESS in varchar2, X_QUEUE_HANDLER in varchar2, X_QUEUE_NAME in varchar2, X_DIRECTION in varchar2, X_STATUS in varchar2, X_DISPLAY_NAME in varchar2, X_DESCRIPTION in varchar2, X_TYPE in varchar2 default 'AGENT', X_JAVA_QUEUE_HANDLER in varchar2 default null ); ----------------------------------------------------------------------------- /*# * Generates an XML message containing the complete information from the * WF_AGENTS table for the specified agent definition. * @param x_guid Agent GUID * @return Agent XML Message * @rep:scope public * @rep:lifecycle active * @rep:displayname Generate Agent Message * @rep:compatibility S * @rep:ihelp FND/@besrepapis#a_evagtgen See the related online help */ function GENERATE ( X_GUID in raw ) return varchar2; ----------------------------------------------------------------------------- /*# * Receives an XML message containing the complete information for an agent * definition and loads the information into the WF_AGENTS table. * @param x_message Agent XML Message * @rep:scope public * @rep:lifecycle active * @rep:displayname Receive Agent Message * @rep:compatibility S * @rep:ihelp FND/@besrepapis#a_evagtrec See the related online help */ procedure RECEIVE ( X_MESSAGE in varchar2 ); ----------------------------------------------------------------------------- end WF_AGENTS_PKG; / commit; exit;
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de