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

Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\wf\sql\AFSVCPTS.pls

/*=======================================================================+
 |  Copyright (c) 1997 Oracle Corporation Redwood Shores, California, USA|
 |                            All rights reserved.                       |
 +=======================================================================+
 | FILENAME
 | DESCRIPTION
 |   PL/SQL spec for package:  FND_SVC_COMP_PARAMS_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_COMP_PARAMS_PKG authid current_user as
/* $Header: AFSVCPTS.pls 26.2 2002/12/10 21:07:09 ankung ship $ */

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_PARAMETER_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER default 1,
  X_PARAMETER_NAME in VARCHAR2,
  X_COMPONENT_TYPE in VARCHAR2,
  X_DEFAULT_PARAMETER_VALUE in VARCHAR2,
  X_REQUIRED_FLAG in VARCHAR2,
  X_ALLOW_RELOAD_FLAG in VARCHAR2,
  X_ENCRYPTED_FLAG in VARCHAR2,
  X_CUSTOMIZATION_LEVEL in VARCHAR2,
  X_DISPLAY_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  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_PARAMETER_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_PARAMETER_NAME in VARCHAR2,
  X_COMPONENT_TYPE in VARCHAR2,
  X_DEFAULT_PARAMETER_VALUE in VARCHAR2,
  X_REQUIRED_FLAG in VARCHAR2,
  X_ALLOW_RELOAD_FLAG in VARCHAR2,
  X_ENCRYPTED_FLAG in VARCHAR2,
  X_CUSTOMIZATION_LEVEL in VARCHAR2,
  X_DISPLAY_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2
);

procedure UPDATE_ROW (
  X_PARAMETER_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_PARAMETER_NAME in VARCHAR2,
  X_COMPONENT_TYPE in VARCHAR2,
  X_DEFAULT_PARAMETER_VALUE in VARCHAR2,
  X_REQUIRED_FLAG in VARCHAR2,
  X_ALLOW_RELOAD_FLAG in VARCHAR2,
  X_ENCRYPTED_FLAG in VARCHAR2,
  X_CUSTOMIZATION_LEVEL in VARCHAR2,
  X_DISPLAY_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE default sysdate,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
);

procedure DELETE_ROW (
  X_PARAMETER_ID in NUMBER
);

procedure ADD_LANGUAGE;

procedure LOAD_ROW (
  X_PARAMETER_NAME in VARCHAR2, 
  X_COMPONENT_TYPE in VARCHAR2, 
  X_DEFAULT_PARAMETER_VALUE in VARCHAR2, 
  X_REQUIRED_FLAG in VARCHAR2, 
  X_ALLOW_RELOAD_FLAG in VARCHAR2, 
  X_ENCRYPTED_FLAG in VARCHAR2, 
  X_CUSTOMIZATION_LEVEL in VARCHAR2, 
  X_DISPLAY_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_OWNER in VARCHAR2
);

procedure TRANSLATE_ROW (
  X_PARAMETER_ID in NUMBER,
  X_DISPLAY_NAME in VARCHAR2, 
  X_DESCRIPTION in VARCHAR2,
  X_OWNER in VARCHAR2
);

end FND_SVC_COMP_PARAMS_PKG;

commit;
exit;

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de