1 PACKAGE EDW_SOURCE_INST_PKG AUTHID CURRENT_USER AS
2 /* $Header: EDWSRCS.pls 115.0 99/09/03 14:12:45 porting shi $ */
3 /*
4 REM +=======================================================================+
5 REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |
6 REM | All rights reserved. |
7 REM +=======================================================================+
8 REM | FILENAME |
9 REM | EDWSRCS.pls |
10 REM | |
11 REM | DESCRIPTION |
12 REM | APIs to upload and download translation data for edw_source_instances |
13 REM | NOTES |
14 REM | |
15 REM | HISTORY |
16 REM | 04-AUG-99 arsantha Creation
17 REM +=======================================================================+
18 */
19 --
20 -- Data Types: Records
21 --
22 TYPE src_inst_rec_type IS RECORD
23 (
24 Instance_code VARCHAR2(30)
25 , link VARCHAR2(30)
26 , Enabled_flag VARCHAR2(1)
27 , name VARCHAR2(30)
28 , description VARCHAR2(240)
29 );
30
31 --
32 -- Data Types: Tables
33 --
34 Procedure Translate_EDW_source_instances
35 ( p_api_version IN NUMBER
36 , p_commit IN VARCHAR2 := FND_API.G_FALSE
37 , p_src_inst_rec IN EDW_SOURCE_INST_PKG.src_inst_rec_type
38 , p_OWNER IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
39 , x_return_status OUT VARCHAR2
40 );
41 --
42 Procedure Load_edw_source_instances
43 (
44 p_api_version IN NUMBER
45 , p_commit IN VARCHAR2 := FND_API.G_FALSE
46 , p_src_inst_rec IN EDW_SOURCE_INST_PKG.src_inst_rec_type
47 , p_OWNER IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
48 , x_return_status OUT VARCHAR2
49 );
50 --
51 END EDW_SOURCE_INST_PKG;