[Home] [Help]
136: ) RETURN VARCHAR2;
137:
138: Procedure Get_Performance_Measure_Msg
139: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
140: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
141: , p_comparison_result IN VARCHAR2
142: , x_message_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
143: );
144:
155: );
156:
157: Procedure Get_Message_Body
158: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
159: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
160: , p_comparison_result IN VARCHAR2
161: , x_message_body_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
162: );
163:
162: );
163:
164: Procedure Get_Alert_Information
165: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
166: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
167: , x_Alert_Information_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
168: );
169:
170: Procedure Get_Related_Links
168: );
169:
170: Procedure Get_Related_Links
171: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
172: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
173: , x_Related_Links_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
174: );
175:
176: Procedure Get_Report_Attachement
174: );
175:
176: Procedure Get_Report_Attachement
177: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
178: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
179: , x_attachement_url_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
180: );
181:
182: Procedure Get_Alert_Recipients
180: );
181:
182: Procedure Get_Alert_Recipients
183: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
184: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
185: , p_comparison_result IN VARCHAR2
186: , x_Alert_recipients_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
187: , x_Alert_recipients_sh_nm_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
188: , x_number_out_of_range OUT NOCOPY NUMBER
189: );
190:
191: Procedure Get_Alert_Message
192: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
193: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
194: , x_Alert_Message_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
195: );
196:
197: Procedure Set_Message
200: );
201:
202: Function Get_Role
203: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
204: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
205: , p_comparison_result IN VARCHAR2
206: ) RETURN VARCHAR2 ;
207:
208: PROCEDURE Get_Result_Owners
214: );
215:
216: Procedure Get_Workflow_Info
217: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
218: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
219: , p_comparison_result IN VARCHAR2
220: , x_item_type OUT NOCOPY VARCHAR2
221: , x_process OUT NOCOPY VARCHAR2
222: );
224: -- Starts the corrective action workflow
225: --
226: Procedure Start_Corrective_Action
227: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
228: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
229: , p_comparison_result IN VARCHAR2
230: )
231: IS
232:
321: -- Sends the Alert notification
322: --
323: Procedure Send_Alert
324: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
325: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
326: , p_comparison_result IN VARCHAR2
327: )
328: IS
329:
358: l_target_rec BIS_TARGET_PUB.Target_rec_type;
359: l_actual_rec BIS_ACTUAL_PUB.Actual_rec_type;
360: l_actual_rec1 BIS_ACTUAL_PUB.Actual_rec_type; -- 2164190 sashaik
361: l_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
362: l_dim_level_value_rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
363: l_target_level_rec BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;
364: l_measure_rec BIS_MEASURE_PUB.Measure_Rec_Type;
365:
366: l_Dim_Level_Value_Rec_oltp BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
362: l_dim_level_value_rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
363: l_target_level_rec BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;
364: l_measure_rec BIS_MEASURE_PUB.Measure_Rec_Type;
365:
366: l_Dim_Level_Value_Rec_oltp BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
367: l_dimension_level_number_oltp NUMBER;
368: l_Org_Level_Value_ID VARCHAR2(40); -- := '204';
369: l_Org_Level_Short_name VARCHAR2(40);
370:
378: l_time_level_name VARCHAR2(32000);
379: l_from VARCHAR2(32000);
380: l_to VARCHAR2(32000);
381: l_many NUMBER;
382: l_dim_level_value_tbl BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type;
383: l_dimlevel_short_name VARCHAR2(32000);
384: l_select_String VARCHAR2(32000);
385: l_table_name VARCHAR2(32000);
386: l_value_name VARCHAR2(32000);
438: l_return_message VARCHAR2(32000);
439: k NUMBER;
440:
441: l_dimension_level_rec_p BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
442: l_dim_level_value_rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
443: l_target_level_rec_p BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;
444: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
445:
446: ll_message VARCHAR2(500);
1371:
1372:
1373: Function Get_Role
1374: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
1375: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
1376: , p_comparison_result IN VARCHAR2
1377: )
1378: RETURN VARCHAR2
1379: IS
1383: END Get_Role;
1384:
1385: Procedure Get_Alert_Recipients
1386: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
1387: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
1388: , p_comparison_result IN VARCHAR2
1389: , x_Alert_recipients_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
1390: , x_Alert_recipients_sh_nm_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
1391: , x_number_out_of_range OUT NOCOPY NUMBER
1584: END Get_Result_Owners;
1585:
1586: Procedure Get_Performance_Measure_Msg
1587: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
1588: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
1589: , p_comparison_result IN VARCHAR2
1590: , x_message_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
1591: )
1592: IS
1701: END Get_Message_Intro;
1702:
1703: Procedure Get_Message_Body
1704: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
1705: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
1706: , p_comparison_result IN VARCHAR2
1707: , x_message_body_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
1708: )
1709: IS
1713: END Get_Message_Body;
1714:
1715: Procedure Get_Alert_Information
1716: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
1717: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
1718: , x_Alert_Information_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
1719: )
1720: IS
1721:
1724: END Get_Alert_Information;
1725:
1726: Procedure Get_Related_Links
1727: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
1728: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
1729: , x_Related_Links_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
1730: )
1731: IS
1732:
1735: END Get_Related_Links;
1736:
1737: Procedure Get_Report_Attachement
1738: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
1739: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
1740: , x_attachement_url_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
1741: )
1742: IS
1743:
1762:
1763:
1764: Procedure Get_Alert_Message
1765: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
1766: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
1767: , x_Alert_Message_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
1768: )
1769: IS
1770:
1990: END Format_Message;
1991:
1992: Procedure Get_Workflow_Info
1993: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
1994: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
1995: , p_comparison_result IN VARCHAR2
1996: , x_item_type OUT NOCOPY VARCHAR2
1997: , x_process OUT NOCOPY VARCHAR2
1998: )