Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\wf\sql\AFSVCMTS.pls
/*=======================================================================+ | Copyright (c) 1997 Oracle Corporation Redwood Shores, California, USA| | All rights reserved. | +=======================================================================+ | FILENAME | DESCRIPTION | PL/SQL spec for package: FND_SVC_COMPONENTS_PKG *=======================================================================*/ SET VERIFY OFF WHENEVER SQLERROR EXIT FAILURE ROLLBACK; WHENEVER OSERROR EXIT FAILURE ROLLBACK; REM Added for ARU db drv auto generation REM dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=pls \ REM dbdrv: checkfile:~PROD:~PATH:~FILE create or replace package FND_SVC_COMPONENTS_PKG authid current_user as /* $Header: AFSVCMTS.pls 26.2 2002/12/10 21:10:23 ankung ship $ */ procedure INSERT_ROW ( X_ROWID in out nocopy VARCHAR2, X_COMPONENT_ID in NUMBER, X_COMPONENT_NAME in VARCHAR2, X_COMPONENT_STATUS in VARCHAR2, X_COMPONENT_TYPE in VARCHAR2, X_STARTUP_MODE in VARCHAR2, X_CONTAINER_TYPE in VARCHAR2, X_CUSTOMIZATION_LEVEL in VARCHAR2, X_APPLICATION_ID in NUMBER, X_CONCURRENT_QUEUE_ID in NUMBER, X_STANDALONE_CONTAINER_NAME in VARCHAR2, X_INBOUND_AGENT_NAME in VARCHAR2, X_OUTBOUND_AGENT_NAME in VARCHAR2, X_CORRELATION_ID in VARCHAR2, X_MAX_IDLE_TIME in NUMBER, X_COMPONENT_STATUS_INFO in VARCHAR2, X_OBJECT_VERSION_NUMBER in NUMBER default 1, X_CREATION_DATE in DATE default sysdate, X_CREATED_BY in NUMBER, X_LAST_UPDATE_DATE in DATE default sysdate, X_LAST_UPDATED_BY in NUMBER, X_LAST_UPDATE_LOGIN in NUMBER); procedure LOCK_ROW ( X_COMPONENT_ID in NUMBER, X_COMPONENT_NAME in VARCHAR2, X_COMPONENT_STATUS in VARCHAR2, X_COMPONENT_TYPE in VARCHAR2, X_STARTUP_MODE in VARCHAR2, X_CONTAINER_TYPE in VARCHAR2, X_CUSTOMIZATION_LEVEL in VARCHAR2, X_APPLICATION_ID in NUMBER, X_CONCURRENT_QUEUE_ID in NUMBER, X_STANDALONE_CONTAINER_NAME in VARCHAR2, X_INBOUND_AGENT_NAME in VARCHAR2, X_OUTBOUND_AGENT_NAME in VARCHAR2, X_CORRELATION_ID in VARCHAR2, X_MAX_IDLE_TIME in NUMBER, X_COMPONENT_STATUS_INFO in VARCHAR2, X_OBJECT_VERSION_NUMBER in NUMBER ); procedure UPDATE_ROW ( X_COMPONENT_ID in NUMBER, X_COMPONENT_NAME in VARCHAR2, X_COMPONENT_STATUS in VARCHAR2, X_COMPONENT_TYPE in VARCHAR2, X_STARTUP_MODE in VARCHAR2, X_CONTAINER_TYPE in VARCHAR2, X_CUSTOMIZATION_LEVEL in VARCHAR2, X_APPLICATION_ID in NUMBER, X_CONCURRENT_QUEUE_ID in NUMBER, X_STANDALONE_CONTAINER_NAME in VARCHAR2, X_INBOUND_AGENT_NAME in VARCHAR2, X_OUTBOUND_AGENT_NAME in VARCHAR2, X_CORRELATION_ID in VARCHAR2, X_MAX_IDLE_TIME in NUMBER, X_COMPONENT_STATUS_INFO in VARCHAR2, X_OBJECT_VERSION_NUMBER in NUMBER, X_LAST_UPDATE_DATE in DATE default sysdate, X_LAST_UPDATED_BY in NUMBER, X_LAST_UPDATE_LOGIN in NUMBER ); procedure DELETE_ROW ( X_COMPONENT_ID in NUMBER ); procedure LOAD_ROW ( X_COMPONENT_NAME in VARCHAR2, X_COMPONENT_STATUS in VARCHAR2, X_COMPONENT_TYPE in VARCHAR2, X_STARTUP_MODE in VARCHAR2, X_CONTAINER_TYPE in VARCHAR2, X_CUSTOMIZATION_LEVEL in VARCHAR2, X_APPLICATION_SHORT_NAME in VARCHAR2, X_CONCURRENT_QUEUE_NAME in VARCHAR2, X_STANDALONE_CONTAINER_NAME in VARCHAR2, X_INBOUND_AGENT_NAME in VARCHAR2, X_OUTBOUND_AGENT_NAME in VARCHAR2, X_CORRELATION_ID in VARCHAR2, X_MAX_IDLE_TIME in NUMBER, X_COMPONENT_STATUS_INFO in VARCHAR2, X_OBJECT_VERSION_NUMBER in NUMBER, X_OWNER in VARCHAR2 ); end FND_SVC_COMPONENTS_PKG; / commit; exit;
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de