[Home] [Help]
PACKAGE: APPS.BSC_DESIGNER_PVT
Source
1 PACKAGE BSC_DESIGNER_PVT AS
2 /* $Header: BSCDSGS.pls 120.5 2007/04/02 18:22:48 akoduri ship $ */
3 -- Bug#4587160 changed size
4 C_INDICATOR CONSTANT VARCHAR2(30) := 'INDICATOR';
5 C_KPI_TABLE CONSTANT VARCHAR2(30) := 'KPI_TABLE';
6 C_KPI_MEAS_TABLE CONSTANT VARCHAR2(30) := 'KPI_MEAS_TABLE';
7 C_SOURCE_CODE CONSTANT VARCHAR2(30) := 'SOURCE_CODE';
8 C_SYSTEM_TABLE CONSTANT VARCHAR2(30) := 'SYSTEM_TABLE';
9 C_CAUSE_INDICATOR CONSTANT VARCHAR2(30) := 'CAUSE_INDICATOR';
10 C_EFFECT_INDICATOR CONSTANT VARCHAR2(30) := 'EFFECT_INDICATOR';
11
12 C_COLOR_CHANGE CONSTANT NUMBER := 7;
13 C_PRODUCTION CONSTANT NUMBER := 0;
14
15 C_MASTER_KPI CONSTANT NUMBER := 5;
16 C_SHARED_KPI CONSTANT NUMBER := 3;
17 C_NO_COPY CONSTANT NUMBER := 0;
18
19 C_SOURCE_TYPE_SYSTEM CONSTANT NUMBER := 0;
20 C_SOURCE_TYPE_TAB CONSTANT NUMBER := 1;
21 C_SOURCE_TYPE_INDICATOR CONSTANT NUMBER := 2;
22 g_DbLink_Name all_db_links.db_link%TYPE := NULL;
23
24
25 -- Global types
26 TYPE r_kpi_metadata_tables IS RECORD (
27 table_name VARCHAR2(30),
28 table_type VARCHAR2(30),
29 table_column VARCHAR2(30),
30 duplicate_data VARCHAR2(1),
31 mls_table VARCHAR2(1),
32 copy_type NUMBER
33 );
34
35 TYPE t_kpi_metadata_tables IS TABLE OF r_kpi_metadata_tables
36 INDEX BY BINARY_INTEGER;
37 -- Procedures/Functions specification
38 PROCEDURE Init_variables(x_indicator IN NUMBER);
39 -- Deflt : Kpis Default functionality
40 PROCEDURE Deflt_RefreshInvalidKpis;
41 PROCEDURE Deflt_RefreshKpi(x_indicator IN NUMBER);
42 PROCEDURE Deflt_Clear(x_indicator IN NUMBER);
43 PROCEDURE Deflt_Update_AOPTS(x_indicator IN NUMBER);
44 PROCEDURE Deflt_Update_SN_FM_CM(x_indicator IN NUMBER);
45 PROCEDURE Deflt_Update_DIM_SET(x_indicator IN NUMBER);
46 PROCEDURE Deflt_Update_DIM_VALUES(x_indicator IN NUMBER);
47 PROCEDURE Deflt_Update_DIM_NAMES(x_indicator IN NUMBER);
48 FUNCTION getItemfromMasterTable(MASTER IN VARCHAR2, ORDER_BY IN NUMBER) RETURN VARCHAR2;
49 PROCEDURE Deflt_Update_PERIOD_NAME(x_indicator IN NUMBER);
50 --Synch shared Kpis
51 PROCEDURE Duplicate_Record_by_Indicator(x_table_name IN VARCHAR2, x_Src_kpi IN NUMBER, x_Trg_kpi IN NUMBER );
52 PROCEDURE Duplicate_KPI_Metadata(x_Src_kpi IN NUMBER, x_Trg_kpi IN NUMBER,x_Shared_apply IN NUMBER,x_Shared_tables IN VARCHAR2);
53 PROCEDURE BscKpisB_Update(x_Ind IN NUMBER, x_Field IN VARCHAR, x_Val IN VARCHAR);
54 --Utils
55 FUNCTION Decompose_Varchar_List(x_string IN VARCHAR2, x_array IN OUT NOCOPY BSC_UPDATE_UTIL.t_array_of_varchar2,x_separator IN VARCHAR2) RETURN NUMBER;
56
57 -- List Button - common dimension functions
58 FUNCTION Commdim_DefltDSetisPMFbyTab(x_Tab_id IN NUMBER) RETURN VARCHAR2;
59
60 -- Variables
61 l_indicator NUMBER;
62 l_ind_type NUMBER;
63 l_ind_config NUMBER;
64 l_current_user NUMBER;
65 l_base_lang VARCHAR2(4);
66
67 --Records
68 -- Incremental Changes Flag
69 TYPE t_ActionFlag IS RECORD(
70 Normal NUMBER := 0,
71 Prototype NUMBER := 1,
72 Delete_kpi NUMBER := 2,
73 GAA_Structure NUMBER := 3,
74 GAA_Update NUMBER := 4,
75 GAA_Color NUMBER := 7,
76 Update_Update NUMBER := 6,
77 Update_color NUMBER := 7
78 );
79 --Global Variable
80
81 G_ActionFlag t_ActionFlag;
82 -- Incremental Changes Flag
83 PROCEDURE ActionFlag_Change(x_indicator IN NUMBER, x_newflag IN NUMBER);
84
85 -- Incremental Changes Flag
86 -- Added by Aditya for PMD
87
88 PROCEDURE Dim_Object_Change(x_dim_level_id IN NUMBER);
89 PROCEDURE Dimension_Change(x_grp_short_name IN VARCHAR2, x_flag IN NUMBER);
90 PROCEDURE Dimension_Change(x_dim_group_id IN NUMBER, x_flag IN NUMBER);
91 FUNCTION FND_PROFILE_GET (name VARCHAR2) RETURN VARCHAR2;
92
93 PROCEDURE ActionFlag_Change_Cascade (
94 p_indicator IN NUMBER
95 , p_newflag IN NUMBER
96 , p_cascade_color IN BOOLEAN
97 );
98
99 PROCEDURE Update_Kpi_Prototype_Flag (
100 p_objective_id IN NUMBER
101 , p_kpi_measure_id IN NUMBER := NULL
102 , p_flag IN NUMBER
103 );
104
105 PROCEDURE Copy_Records_by_Obj_Kpi_Meas (
106 p_src_kpi IN NUMBER
107 , p_trg_kpi IN NUMBER
108 );
109
110 PROCEDURE Copy_Objective_Record (
111 p_commit IN VARCHAR2 := FND_API.G_FALSE
112 , p_DbLink_Name IN VARCHAR2
113 , p_Table_Name IN VARCHAR2
114 , p_Table_column IN VARCHAR2
115 , p_Source_Value IN NUMBER
116 , p_Target_Value IN NUMBER
117 , x_return_status OUT NOCOPY VARCHAR2
118 , x_msg_count OUT NOCOPY NUMBER
119 , x_msg_data OUT NOCOPY VARCHAR2
120 );
121
122 PROCEDURE Copy_Kpi_Metadata (
123 p_commit IN VARCHAR2 := FND_API.G_FALSE
124 , p_DbLink_Name IN VARCHAR2
125 , p_Source_Indicator IN NUMBER
126 , x_Target_Indicator OUT NOCOPY NUMBER
127 , x_return_status OUT NOCOPY VARCHAR2
128 , x_msg_count OUT NOCOPY NUMBER
129 , x_msg_data OUT NOCOPY VARCHAR2
130 );
131
132 FUNCTION Format_DbLink_String (
133 p_Sql IN VARCHAR2
134 ) RETURN VARCHAR2;
135
136 PROCEDURE Process_TL_Table (
137 p_commit IN VARCHAR2 := FND_API.G_FALSE
138 , p_DbLink_Name IN VARCHAR2
139 , p_Table_Name IN VARCHAR2
140 , p_Table_column IN VARCHAR2
141 , p_Target_Value IN NUMBER
142 , p_Target_Value_Char IN VARCHAR2
143 , x_return_status OUT NOCOPY VARCHAR2
144 , x_msg_count OUT NOCOPY NUMBER
145 , x_msg_data OUT NOCOPY VARCHAR2
146 );
147 END BSC_DESIGNER_PVT;