Edit D:\app\Administrator\product\11.2.0\dbhome

Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\wf\sql\WFEVEVTS.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 
 |   WFEVEVTS.pls
 | DESCRIPTION
 |   PL/SQL spec for package:  WF_EVENTS_PKG
 |
 |         PROCEDURE insert_row
 |         PROCEDURE update_row
 |         PROCEDURE delete_row
 |         PROCEDURE load_row
 |         PROCEDURE add_language
 |         FUNCTION  generate
 |         PROCEDURE receive
 |	   FUNCTION is_product_licensed
 |
 | 09.27.2002   varrajar Bug 2558446. Preserve Customization of events
 |              Also sets the licensed_flag based on OWNER_TAG 
 | 10.09.2002   varrajar Bug 2558446. Implemented Force Mode and implemented
 |	 	caller specific - Loader, UI changes	
 | 11.15.2002   varrajar Bug 2558446. Implemented CUSTOM, UPGRAGE and FORCE
 |              mode as the only options.
 | 12-03-2002   kma      Add NOCOPY hint to OUT or IN OUT parameter.
 | 16-11-2003   vbhatia  Added JAVA_GENERATE_FUNC to procedures
 *=======================================================================*/
SET VERIFY OFF;
whenever sqlerror exit failure rollback;
WHENEVER OSERROR EXIT FAILURE ROLLBACK;

create or replace package WF_EVENTS_PKG as
/* $Header: WFEVEVTS.pls 26.7 2004/05/18 06:01:22 vshanmug ship $ */
/*# 
 * This package provides the APIs that an Application Program or Business Event
 * System can call to communicate Event objects to and from the database 
 * tables.
 * @rep:scope public
 * @rep:product OWF
 * @rep:displayname Workflow Events Package
 * @rep:lifecycle active
 * @rep:compatibility S
 * @rep:category BUSINESS_ENTITY WF_EVENT
 * @rep:ihelp FND/@besrepapis See the related online help
 */

g_seeduser varchar2(320) := 'DATAMERGE';
g_Mode varchar2(8) := null;

procedure setMode;

procedure FWKsetMode;

procedure LoadersetMode(x_mode in varchar2);

function is_product_licensed( X_OWNER_TAG in varchar2)
return varchar2;

function is_update_allowed(X_CUSTOM_LEVEL_NEW in varchar2,
			   X_CUSTOM_LEVEL_OLD in varchar2) return varchar2;

procedure INSERT_ROW (
  X_ROWID              in out nocopy varchar2,
  X_GUID               in     raw,
  X_NAME               in     varchar2,
  X_TYPE               in     varchar2,
  X_STATUS             in     varchar2,
  X_GENERATE_FUNCTION  in     varchar2,
  X_OWNER_NAME         in     varchar2,
  X_OWNER_TAG          in     varchar2,
  X_DISPLAY_NAME       in     varchar2,
  X_DESCRIPTION        in     varchar2,
  X_CUSTOMIZATION_LEVEL in    varchar2 default 'L',
  X_LICENSED_FLAG      in     varchar2 default 'Y',
  X_JAVA_GENERATE_FUNC in     varchar2 default null
);
-----------------------------------------------------------------------------
procedure UPDATE_ROW (
  X_GUID               in  raw,
  X_NAME               in  varchar2,
  X_TYPE               in  varchar2,
  X_STATUS             in  varchar2,
  X_GENERATE_FUNCTION  in  varchar2,
  X_OWNER_NAME         in  varchar2,
  X_OWNER_TAG          in  varchar2,
  X_DISPLAY_NAME       in  varchar2,
  X_DESCRIPTION        in  varchar2,
  X_CUSTOMIZATION_LEVEL in    varchar2 default 'L',
  X_LICENSED_FLAG      in    varchar2 default 'Y',
  X_JAVA_GENERATE_FUNC in     varchar2 default null
);
-----------------------------------------------------------------------------
procedure DELETE_ROW (
  X_GUID               in  raw
);
-----------------------------------------------------------------------------
procedure LOAD_ROW (
  X_GUID               in  raw,
  X_NAME               in  varchar2,
  X_TYPE               in  varchar2,
  X_STATUS             in  varchar2,
  X_GENERATE_FUNCTION  in  varchar2,
  X_OWNER_NAME         in  varchar2,
  X_OWNER_TAG          in  varchar2,
  X_DISPLAY_NAME       in  varchar2,
  X_DESCRIPTION        in  varchar2,
  X_CUSTOMIZATION_LEVEL in    varchar2 default 'L',
  X_LICENSED_FLAG      in    varchar2 default 'Y',
  X_JAVA_GENERATE_FUNC in     varchar2 default null
);
-----------------------------------------------------------------------------
procedure ADD_LANGUAGE;
-----------------------------------------------------------------------------
/*#
 * Generates an XML message containing the complete information from the 
 * WF_EVENTS table for the specified event definition.
 * @param x_guid Event GUID
 * @return Event XML Message
 * @rep:scope public
 * @rep:lifecycle active
 * @rep:displayname Generate Event Message
 * @rep:compatibility S
 * @rep:ihelp FND/@besrepapis#a_evtgen See the related online help
 */
function GENERATE (
  X_GUID               in raw
) return varchar2;
-----------------------------------------------------------------------------
/*#
 * Receives an XML message containing the complete information for an event 
 * definition and loads the information into the WF_EVENTS table.
 * @param x_message Event XML Message
 * @rep:scope public
 * @rep:lifecycle active
 * @rep:displayname Receive Event Message
 * @rep:compatibility S
 * @rep:ihelp FND/@besrepapis#a_evtrec See the related online help
 */
procedure RECEIVE (
  X_MESSAGE            in varchar2
);
-----------------------------------------------------------------------------
end WF_EVENTS_PKG;
/
commit;
exit;

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de