Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\reposasst\OWBDeletion.pks

--
-- $Header: whdev/2.0/owb/oracle/wh/repos/pdl/foundation/plsql/OWBDeletion.pks /main/1 2009/04/27 17:07:34 rvelisar Exp $
--
-- OWBDeletion.pks
--
-- Copyright (c) 2009, Oracle and/or its affiliates. All rights reserved. 
--
--   NAME
--     OWBDeletion.pks - This package provides deletion routines for OWB product.
--
--   DESCRIPTION
--     <short description of component this file declares/defines>
--
--   RETURNS
--
--   NOTES
--     <other useful comments, qualifications, etc.>
--
--   MODIFIED   (MM/DD/YY)
--   rvelisar    04/07/09 - Creation
--

CREATE OR REPLACE TYPE OWB_NUMBER_TABLE_TYPE AS TABLE OF NUMBER;
/

CREATE OR REPLACE PACKAGE OWBDeletion AS

-----------------------------------------------------------------------------
-- Public constants
-----------------------------------------------------------------------------

-----------------------------------------------------------------------------
-- Procedures and functions
-----------------------------------------------------------------------------

-- Procedure

PROCEDURE DELETE_IDS (list_of_ids IN OWB_NUMBER_TABLE_TYPE);
PROCEDURE DELETE_FCOS_SCOS (list_of_ids IN OWB_NUMBER_TABLE_TYPE);

END OWBDeletion;

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de