[Home] [Help]
PACKAGE: APPS.BSC_SIMULATION_VIEW_PVT
Source
1 PACKAGE BSC_SIMULATION_VIEW_PVT AS
2 /* $Header: BSCSIMVS.pls 120.3.12000000.1 2007/07/17 07:44:31 appldev noship $ */
3
4 /*REM +=======================================================================+
5 REM | Copyright (c) 2004 Oracle Corporation, Redwood Shores, CA, USA |
6 REM | All rights reserved. |
7 REM +=======================================================================+
8 REM | FILENAME |
9 REM | BSCSIMPS.pls |
10 REM | |
11 REM | DESCRIPTION |
12 REM | Module: Wrapper API for SIMULATION |
13 REM | |
14 REM | NOTES |
15 REM | |
16 REM | HISTORY |
17 REM | 22-NOV-06 ashankar Created. |
18 REM | 29/03/07 ashankar Bug#5932973 Supporting filters and key items |
19 REM | for SM tree |
20 REM | 02-ARR-07 akoduri Copy Indicator Enh#5943238 |
21 REM | 06-Jul-07 ashankar Bug#6166829 Fix the prototype_flag issues |
22 REM | +=====================================================================+*/
23
24
25 C_SOURCE_CODE CONSTANT VARCHAR2(30) := 'SOURCE_CODE';
26 C_SYSTEM_TABLE CONSTANT VARCHAR2(30) := 'SYSTEM_TABLE';
27 C_TAB_VIEW_TABLE CONSTANT VARCHAR2(50) := 'TAB_VIEW';
28 C_TAB_VIEW CONSTANT VARCHAR2(50) := 'TAB_VIEW_ID';
29 C_INDICATOR CONSTANT VARCHAR2(30) := 'INDICATOR';
30 C_KPI_TABLE CONSTANT VARCHAR2(30) := 'KPI_TABLE';
31 C_IMAGE_ID CONSTANT VARCHAR2(30) := 'IMAGE_ID';
32 C_AK_TABLE CONSTANT VARCHAR2(30) := 'AK_REGION';
33 C_AK_COLUMN CONSTANT VARCHAR2(30) := 'REGION_CODE';
34 C_SHOW_COLOR CONSTANT VARCHAR2(1) := 'F';
35 C_DISABLE_COLOR CONSTANT VARCHAR2(1) := 'T';
36 C_FORM_TABLE CONSTANT VARCHAR2(30) := 'FND_FORM';
37 C_FORM_COLUMN CONSTANT VARCHAR2(30) := 'FUNCTION_NAME';
38 C_FORM_FUNCTION_ID CONSTANT VARCHAR2(30) := 'FUNCTION_ID';
39 C_COMMA CONSTANT VARCHAR2(2) := ',';
40 C_MEASURE_NOTARGET CONSTANT VARCHAR2(50) := 'MEASURE_NOTARGET';
41 C_DEFAULT_ANA_OPTION CONSTANT NUMBER := 0;
42 C_DOT CONSTANT VARCHAR2(2) := '.';
43
44
45 TYPE Bsc_Shared_Obj_Rec is RECORD
46 (
47 region_code bsc_kpis_b.short_name%TYPE
48 ,target_kpi bsc_kpis_b.indicator%TYPE
49 ,function_id fnd_form_functions_vl.function_id%TYPE
50 );
51
52 TYPE Bsc_Shared_Obj_Tbl_Type IS TABLE OF Bsc_Shared_Obj_Rec INDEX BY BINARY_INTEGER;
53
54
55 PROCEDURE Duplicate_sim_metadata
56 (
57 p_source_kpi IN NUMBER
58 ,p_target_kpi IN NUMBER
59 ,x_return_status OUT NOCOPY VARCHAR2
60 ,x_msg_count OUT NOCOPY NUMBER
61 ,x_msg_data OUT NOCOPY VARCHAR2
62 );
63
64 PROCEDURE Add_Or_Update_YTD
65 (
66 p_indicator IN NUMBER
67 ,p_YTD IN VARCHAR2
68 ,p_prev_YTD IN VARCHAR2
69 ,x_return_status OUT NOCOPY VARCHAR2
70 ,x_msg_count OUT NOCOPY NUMBER
71 ,x_msg_data OUT NOCOPY VARCHAR2
72 );
73
74 PROCEDURE Set_Kpi_Color_Flag
75 (
76 p_indicator IN NUMBER
77 ,p_dataset_id IN NUMBER
78 ,p_color_flag IN VARCHAR2
79 ,p_color_by_total IN NUMBER
80 ,x_return_status OUT NOCOPY VARCHAR2
81 ,x_msg_count OUT NOCOPY NUMBER
82 ,x_msg_data OUT NOCOPY VARCHAR2
83 );
84
85 PROCEDURE Set_Kpi_Color_Method
86 (
87 p_indicator IN NUMBER
88 ,p_dataset_id IN NUMBER
89 ,p_color_method IN NUMBER
90 ,x_return_status OUT NOCOPY VARCHAR2
91 ,x_msg_count OUT NOCOPY NUMBER
92 ,x_msg_data OUT NOCOPY VARCHAR2
93 );
94
95
96 PROCEDURE set_default_node
97 (
98 p_indicator IN NUMBER
99 ,p_default_node IN NUMBER
100 ,p_dataset_id IN NUMBER
101 ,x_return_status OUT NOCOPY VARCHAR2
102 ,x_msg_count OUT NOCOPY NUMBER
103 ,x_msg_data OUT NOCOPY VARCHAR2
104 );
105
106 PROCEDURE copy_sim_metadata
107 (
108 p_source_kpi IN NUMBER
109 ,p_target_kpi IN NUMBER
110 ,x_return_status OUT NOCOPY VARCHAR2
111 ,x_msg_count OUT NOCOPY NUMBER
112 ,x_msg_data OUT NOCOPY VARCHAR2
113 );
114
115
116 PROCEDURE Set_Ak_Format_Id
117 (
118 p_indicator IN BSC_KPIS_B.indicator%TYPE
119 ,p_dataset_Id IN BSC_SYS_DATASETS_VL.dataset_id%TYPE
120 ,p_format_Id IN BSC_KPI_TREE_NODES_VL.format_id%TYPE
121 ,x_return_status OUT NOCOPY VARCHAR2
122 ,x_msg_count OUT NOCOPY NUMBER
123 ,x_msg_data OUT NOCOPY VARCHAR2
124 );
125
126 PROCEDURE Handle_Shared_Objectives
127 (
128 p_indicator IN BSC_KPIS_B.indicator%TYPE
129 ,x_return_status OUT NOCOPY VARCHAR2
130 ,x_msg_count OUT NOCOPY NUMBER
131 ,x_msg_data OUT NOCOPY VARCHAR2
132 );
133
134 FUNCTION Get_Format
135 (
136 p_format_Id IN VARCHAR2
137 ) RETURN VARCHAR2;
138
139
140 PROCEDURE Init_Sim_Tables_Array
141 (
142 p_copy_Ak_Tables IN VARCHAR
143 ,x_Table_Number OUT NOCOPY NUMBER
144 ,x_kpi_metadata_tables OUT NOCOPY BSC_DESIGNER_PVT.t_kpi_metadata_tables
145 );
146
147 PROCEDURE Copy_Ak_Record_Table
148 ( p_table_name IN VARCHAR2
149 , p_table_type IN VARCHAR2
150 , p_table_column IN VARCHAR2
151 , p_Src_kpi IN NUMBER
152 , p_Trg_kpi IN NUMBER
153 , p_new_region_code IN VARCHAR2
154 , p_new_form_function IN VARCHAR2
155 , p_DbLink_Name IN VARCHAR2 := NULL
156 );
157
158 PROCEDURE Copy_Dimension_Group (
159 p_commit IN VARCHAR2 := FND_API.G_FALSE
160 , p_Indicator IN NUMBER
161 , p_Region_Code IN VARCHAR2
162 , p_Old_Region_Code IN VARCHAR2
163 , p_New_Dim_Levels IN FND_TABLE_OF_NUMBER
164 , p_DbLink_Name IN VARCHAR2
165 , x_return_status OUT NOCOPY VARCHAR2
166 , x_msg_count OUT NOCOPY NUMBER
167 , x_msg_data OUT NOCOPY VARCHAR2
168 );
169
170 PROCEDURE Set_Sim_Key_Values
171 (
172 p_ind_Sht_Name IN BSC_KPIS_B.short_name%TYPE
173 ,p_indicator IN BSC_KPIS_B.indicator%TYPE
174 ,x_return_status OUT NOCOPY VARCHAR2
175 ,x_msg_count OUT NOCOPY NUMBER
176 ,x_msg_data OUT NOCOPY VARCHAR2
177 );
178
179 END BSC_SIMULATION_VIEW_PVT;