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