DBA Data[Home] [Help]

APPS.BIS_CORRECTIVE_ACTION_PVT dependencies on BIS_MEASURE_PUB

Line 139: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type

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: );

Line 158: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type

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: );

Line 165: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type

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:

Line 171: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type

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:

Line 177: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type

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:

Line 183: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type

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

Line 192: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type

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:

Line 203: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type

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:

Line 217: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type

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

Line 227: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type

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

Line 324: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type

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

Line 364: l_measure_rec BIS_MEASURE_PUB.Measure_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;
367: l_dimension_level_number_oltp NUMBER;
368: l_Org_Level_Value_ID VARCHAR2(40); -- := '204';

Line 444: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;

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;

Line 498: BIS_MEASURE_PUB.Retrieve_Measure

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

Line 1374: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type

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

Line 1386: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type

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

Line 1587: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type

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: )

Line 1704: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type

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: )

Line 1716: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type

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

Line 1727: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type

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

Line 1738: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type

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

Line 1765: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type

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

Line 1860: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type

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

Line 1993: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type

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