PACKAGE: APPS.BSC_MIGREATION_UI

Source

1 package BSC_MIGREATION_UI AS
2 /*$Header: BSCMGUIS.pls 120.3 2005/12/16 01:43 amitgupt noship $*/
3 
4 TYPE respMapRec IS RECORD(
5   src_resp_id   BSC_RESPONSIBILITY_VL.RESPONSIBILITY_ID%TYPE,
6   src_resp_name BSC_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE,
7   tar_resp_id   BSC_RESPONSIBILITY_VL.RESPONSIBILITY_ID%TYPE,
8   tar_resp_name BSC_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE
9 );
10 
11 TYPE objectRec IS RECORD(
12   object_id     BSC_KPIS_VL.INDICATOR%TYPE,
13   object_name   BSC_KPIS_VL.NAME%TYPE
14 );
15 
16 TYPE objectList IS TABLE OF objectRec;
17 TYPE RespMapTable IS TABLE OF respMapRec;
18 
19 procedure createDbLink( p_dblink_sql IN varchar2,
20 			p_dblink_name IN varchar2,
21       		        p_create_status OUT NOCOPY NUMBER);
22 
23 procedure dropDbLink(p_dblink_name IN varchar2);
24 
25 procedure initRespTmpTable(p_process_id IN varchar2,
26                            p_dblink_name IN varchar2,
27                            num_rows OUT NOCOPY Number);
28 
29 procedure initTmpObjTable(p_process_id IN varchar2,
30                           p_dblink_name IN varchar2,
31                           pFetchMode IN varchar2,
32                           pRespList  IN varchar2);
33 
34 END BSC_MIGREATION_UI;