1 PACKAGE BOM_BOM_COPYORG_IMP AS
2 /* $Header: BOMBOCPS.pls 120.0 2006/07/04 09:31:08 myerrams noship $ */
3 /***************************************************************************
4 --
5 -- Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 --
8 -- FILENAME
9 --
10 -- BOMBOCPS.pls
11 --
12 -- DESCRIPTION
13 --
14 -- Spec of package BOM_BOM_COPYORG_IMP
15 --
16 -- NOTES
17 --
18 -- HISTORY
19 --
20 -- 05-JUN-06 Mohan Yerramsetty Bug# 5142847, Initial Creation.
21 -- This package has PL/SQL logic of Copying
22 -- BOMs. It doesn't use Exporting to XML,
23 -- Importing from XML Logic. This will fetch
24 -- all Boms from source organization and
25 -- pass all the records to Bom Interface.
26 -- Bom Interface will do the copying.
27 ***************************************************************************/
28 PROCEDURE Import_Bom (P_debug IN VARCHAR2 := 'N',
29 P_output_dir IN VARCHAR2 := NULL,
30 P_debug_filename IN VARCHAR2 := 'BOM_BO_debug.log',
31 p_model_org_id IN NUMBER,
32 p_target_orgcode IN VARCHAR2,
33 X_return_status OUT NOCOPY VARCHAR2,
34 X_msg_count OUT NOCOPY NUMBER,
35 X_G_msg_data OUT NOCOPY LONG,
36 p_bomthreshold IN VARCHAR2 );
37
38 END BOM_BOM_COPYORG_IMP;