1 package BSC_WEB_ADI_LOADER_PKG AS
2 /*$Header: BSCWADIS.pls 120.2.12000000.2 2007/06/08 12:39:20 karthmoh ship $*/
3
4 /*---------------------------------------------------------------------------
5 API to create the WebADI Integrator, an integrator will be created with the
6 code = <table_name>_INTG, also creates a Security Rule so that this
7 integrator is accessible from PMA <table_name>_SEC
8 ----------------------------------------------------------------------------*/
9 PROCEDURE CREATE_INTEGRATOR( TABLE_NAME VARCHAR2 );
10
11 /*---------------------------------------------------------------------------
12 API to create the WebADI Interface for each table with interface code =
13 <table_name>_INTF, and assigns this interface to an already created Integrator
14 for this table( <table_name>_INTG)
15 ----------------------------------------------------------------------------*/
16 PROCEDURE CREATE_INTERFACE( TABLE_NAME VARCHAR2 );
17
18 /*---------------------------------------------------------------------------
19 API to create the WebADI Interface Columns corresponding to each Column in
20 table, plus an additional column as a place holder for the Interface Table
21 Name to be displayed in the Excel as the context
22 ----------------------------------------------------------------------------*/
23 PROCEDURE CREATE_INTERFACE_COLUMNS( TAB_NAME VARCHAR2 );
24
25 /*---------------------------------------------------------------------------
26 API to create metadata about Layouts, Layout Blocks, Layout Columns
27 Two Layout blocks are created one for the Context(Interface Table Name) and
28 other for the actual table
29 Layour code = <table_name>_L
30 ----------------------------------------------------------------------------*/
31 PROCEDURE CREATE_LAYOUT( TAB_NAME VARCHAR2 );
32
33 /*---------------------------------------------------------------------------
34 API to create Content Metadata for the Integrator.
35 COntent code = <table_name>_CNT
36 ----------------------------------------------------------------------------*/
37 PROCEDURE CREATE_CONTENT( TAB_NAME VARCHAR2, x_errbuf OUT NOCOPY VARCHAR2
38 , x_retcode OUT NOCOPY VARCHAR2);
39
40 /*---------------------------------------------------------------------------
41 API to create Mapping Metadata for the Integrator.
42 COntent code = <table_name>_MAP
43 ----------------------------------------------------------------------------*/
44 PROCEDURE CREATE_MAPPING(TAB_NAME VARCHAR2);
45
46 /*---------------------------------------------------------------------------
47 API to clear all the WebADI metadata for application=BSC and pertaining to
48 a particular Interface Table
49 ----------------------------------------------------------------------------*/
50 PROCEDURE CLEAR_METADATA( TAB_NAME VARCHAR2 );
51
52 /*---------------------------------------------------------------------------
53 API to create all the WebADI metadata for application=BSC and pertaining to
54 a particular Interface Table, this api will be called from the JAVA layer
55 ----------------------------------------------------------------------------*/
56 PROCEDURE Create_Metadata( TAB_NAME VARCHAR2, ERRBUF OUT NOCOPY VARCHAR2,RETCODE OUT NOCOPY VARCHAR2);
57
58 /*---------------------------------------------------------------------------
59 API to create Query for Duplicate Key Management for the Integrator.
60 Query Code = <table_name>_Q
61 ----------------------------------------------------------------------------*/
62 PROCEDURE CREATE_QUERY( TAB_NAME VARCHAR2 );
63
64 /*---------------------------------------------------------------------------
65 API to create 2 Parameters
66 - Rows
67 - Duplicate management
68 ----------------------------------------------------------------------------*/
69 PROCEDURE CREATE_PARAM_DEFN( TAB_NAME VARCHAR2, key_cols NUMBER );
70
71 /*---------------------------------------------------------------------------
72 API to create a Parameter List
73 Parameter List Code = <table_name>_PL
74 ----------------------------------------------------------------------------*/
75 PROCEDURE CREATE_PARAM_LIST( TAB_NAME VARCHAR2, key_cols NUMBER );
76
77 /*---------------------------------------------------------------------------
78 API to create a Duplicate Profile
79 Parameter List Code = <table_name>_REP / _ERR
80 ----------------------------------------------------------------------------*/
81 PROCEDURE CREATE_DUP_PROFILE( TAB_NAME VARCHAR2 );
82
83 /*---------------------------------------------------------------------------
84 API to create a Interface Keys
85 Interface Key Code = <table_name>_UK
86 ----------------------------------------------------------------------------*/
87 FUNCTION CREATE_INTERFACE_KEYS( TAB_NAME VARCHAR2 ) RETURN NUMBER;
88
89 FUNCTION get_lookup_value(type VARCHAR2, code VARCHAR2) return varchar2;
90
91 /* Not required in Production Mode
92 PROCEDURE clear_all_metadata;
93 */
94 END BSC_WEB_ADI_LOADER_PKG;
95
[Home] [Help]