[Home] [Help]
PACKAGE: APPS.BSC_UPGRADES
Source
1 PACKAGE BSC_UPGRADES AUTHID CURRENT_USER AS
2 /* $Header: BSCUPGRS.pls 120.4 2006/03/31 04:13:42 akoduri noship $ */
3 --- Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA
4 --- All rights reserved.
5 ---
6 ---==========================================================================
7 --- FILENAME
8 ---
9 --- BSCPBMSS.pls
10 ---
11 --- DESCRIPTION
12 --- Package Specification File for Upgrade scripts
13 ---
14 --- NOTES
15 ---
16 --- HISTORY
17 ---
18 --- 26-Jun-2003 mdamle Created
19 --- 22-JUL-2003 Adeulgao modified for bug fix#3047536
20 --- 25-SEP-2003 mdamle Bug#3160325 - Sync up measures for all installed languages
21 --- 29-SEP-2003 adrao Bug#3160325 - Sync up measures with source_lang
22 -- 05-Oct-2004 ankgoel Bug#3933075 - Moved Upgrade_Role_To_Tabs to BSCUPGNB.pls
23 -- BSCUPGRB.pls will now be used for API calls from bscupmdd.sql only
24 --- 10-JAN-2006 akoduri Enh#4739401 Hide Dimensions and Dimension Objects
25 --- 23-Jan-2006 akoduri Bug#4958055 Dgrp dimension not getting deleted
26 --- while disassociating from objective
27 --- 31-MAR-06 akoduri Bug #5048186 Dropping of BSC Views for obsoleted BIS dimension
28 --- objets (Only those for which the underlying view will be dropped)
29 ---===========================================================================
30
31 function synchronize_measures(
32 x_error_msg OUT NOCOPY VARCHAR2
33 ) return boolean;
34
35 /*******************************************************************************
36 FUNCTION TO SYNCHRONZIE DIMENSION OBJECTS BSC & PMF
37 ********************************************************************************/
38 FUNCTION Synchronize_Dim_Objects
39 (
40 x_error_msg OUT NOCOPY VARCHAR2
41 ) RETURN BOOLEAN;
42
43 /*******************************************************************************
44 FUNCTION TO SYNCHRONZIE DIMENSIONS IN BSC & PMF
45 ********************************************************************************/
46 FUNCTION Synchronize_Dimensions
47 (
48 x_error_msg OUT NOCOPY VARCHAR2
49 ) RETURN BOOLEAN;
50
51 /*******************************************************************************
52 FUNCTION TO ADD PERFORMANCE MANAGEMENT USER RESP TO ALL TABS AND KPIS
53 ********************************************************************************/
54
55
56 FUNCTION Add_Access_To_Tabs_Kpis (
57 x_error_msg OUT NOCOPY VARCHAR2
58 ) RETURN BOOLEAN;
59
60 -- mdamle 09/25/2003 - Sync up measures for all installed languages
61 Procedure lang_synch_BSC_To_PMF_measure(
62 p_dataset_id IN NUMBER := NULL
63 , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
64 , x_return_status OUT NOCOPY VARCHAR2
65 , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type);
66
67 Procedure lang_synch_PMF_To_BSC_measure(
68 p_indicator_id IN NUMBER := NULL
69 , p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
70 , x_return_status OUT NOCOPY VARCHAR2
71 , x_msg_count OUT NOCOPY NUMBER
72 , x_msg_data OUT NOCOPY VARCHAR2);
73
74 Procedure lang_synch_existing_measures(
75 x_msg_count OUT NOCOPY NUMBER
76 , x_msg_data OUT NOCOPY VARCHAR2
77 , x_return_status OUT NOCOPY VARCHAR2
78 , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type);
79
80 function getUniqueDisplayName(
81 p_dataset_name IN VARCHAR2
82 , p_language IN VARCHAR2) return varchar2;
83
84 PROCEDURE Lang_Synch_BSC_To_PMF_DimObj
85 (
86 p_level_short_name IN VARCHAR2
87 , x_return_status OUT NOCOPY VARCHAR2
88 , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
89 );
90
91 PROCEDURE Lang_Synch_PMF_To_BSC_DimObj
92 (
93 p_level_short_name IN VARCHAR2
94 ,x_return_status OUT NOCOPY VARCHAR2
95 ,x_msg_count OUT NOCOPY NUMBER
96 ,x_msg_data OUT NOCOPY VARCHAR2
97 );
98
99 PROCEDURE Lang_Synch_BSC_To_PMF_Dim
100 (
101 p_dim_short_name IN VARCHAR2
102 , x_return_status OUT NOCOPY VARCHAR2
103 , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
104 );
105
106 PROCEDURE Lang_Synch_PMF_To_BSC_Dim
107 (
108 p_dim_short_name IN VARCHAR2
109 ,x_return_status OUT NOCOPY VARCHAR2
110 ,x_msg_count OUT NOCOPY NUMBER
111 ,x_msg_data OUT NOCOPY VARCHAR2
112 );
113
114 FUNCTION Upgrade_Advanced_Profile(
115 x_error_msg OUT NOCOPY VARCHAR2
116 ) RETURN BOOLEAN;
117
118 FUNCTION Add_Access_To_Launchpads(
119 p_mgr_resp NUMBER
120 ,p_pmd_resp NUMBER
121 ,x_error_msg OUT NOCOPY VARCHAR2
122 ) RETURN BOOLEAN;
123
124
125 FUNCTION Upgrade_Bsc_Pmf_dim_Views(
126 x_error_msg OUT NOCOPY VARCHAR2
127 ) RETURN BOOLEAN;
128
129 FUNCTION Remove_Bsc_Pmf_Edw_dim_Views(
130 x_error_msg OUT NOCOPY VARCHAR2
131 ) RETURN BOOLEAN;
132
133 FUNCTION update_Bsc_Application_Ids
134 (
135 x_error_msg OUT NOCOPY VARCHAR2
136 )RETURN BOOLEAN;
137
138 FUNCTION Update_Dim_Hide_Properties
139 (
140 x_error_msg OUT NOCOPY VARCHAR2
141 )RETURN BOOLEAN ;
142
143 FUNCTION Hide_Unused_Import_Dim
144 (
145 x_error_msg OUT NOCOPY VARCHAR2
146 )RETURN BOOLEAN ;
147
148 PROCEDURE Drop_Update_Dim_Obj_Views(
149 p_Dim_Obj_Sht_Name IN OUT NOCOPY FND_TABLE_OF_VARCHAR2_30
150 , x_return_status OUT NOCOPY VARCHAR2
151 , x_msg_count OUT NOCOPY NUMBER
152 , x_msg_data OUT NOCOPY VARCHAR2
153 );
154
155 end BSC_UPGRADES;
156