135: , p_description IN VARCHAR2
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: );
154: , x_Message_Intro_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
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: );
161: , x_message_body_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
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:
167: , x_Alert_Information_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
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:
173: , x_Related_Links_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
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:
179: , x_attachement_url_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
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:
199: , x_return_status OUT NOCOPY VARCHAR2
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:
213: , x_number_out_of_range OUT NOCOPY NUMBER
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
223:
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
320:
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
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;
367: l_dimension_level_number_oltp NUMBER;
368: l_Org_Level_Value_ID VARCHAR2(40); -- := '204';
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);
447:
448: l_NL VARCHAR2(1) := fnd_global.newline;
494:
495: l_measure_rec.measure_id := p_measure_instance.measure_id;
496:
497: l_measure_rec_p := l_measure_rec;
498: BIS_MEASURE_PUB.Retrieve_Measure
499: ( p_api_version => 1.0
500: , p_measure_rec => l_measure_rec_p
501: , x_measure_rec => l_measure_rec
502: , x_return_status => l_return_status
1370: END Get_User_List_From_Role;
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
1382: return null;
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
1583:
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: )
1700: null;
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: )
1712: null;
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
1723: null;
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
1734: null;
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
1761: END Get_Report_Attachement;
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
1856:
1857: End Get_Servlet_Agent;
1858:
1859: Procedure Get_Request_Info
1860: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
1861: , x_schedule_date OUT NOCOPY VARCHAR2
1862: , x_schedule_time OUT NOCOPY VARCHAR2
1863: , x_schedule_unit OUT NOCOPY VARCHAR2
1864: , x_schedule_freq OUT NOCOPY VARCHAR2
1989:
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