APPS.BSC_BIS_WRAPPER_PVT dependencies on BSC_BIS_WRAPPER_PUB

Line 29: p_kpi_info_rec IN BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type,

25: /************************************************************************************
26: ************************************************************************************/
27:
28: PROCEDURE Get_Actual_Value_From_PMV(
29: p_kpi_info_rec IN BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type,
30: p_user_id IN VARCHAR2,
31: p_responsibility_id IN VARCHAR2,
32: p_dimension_levels IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,
33: p_time_level_from IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,

Line 32: p_dimension_levels IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,

28: PROCEDURE Get_Actual_Value_From_PMV(
29: p_kpi_info_rec IN BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type,
30: p_user_id IN VARCHAR2,
31: p_responsibility_id IN VARCHAR2,
32: p_dimension_levels IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,
33: p_time_level_from IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
34: p_time_level_to IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
35: p_time_comparison_type IN VARCHAR2,
36: p_viewby_level IN VARCHAR2,

Line 33: p_time_level_from IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,

29: p_kpi_info_rec IN BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type,
30: p_user_id IN VARCHAR2,
31: p_responsibility_id IN VARCHAR2,
32: p_dimension_levels IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,
33: p_time_level_from IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
34: p_time_level_to IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
35: p_time_comparison_type IN VARCHAR2,
36: p_viewby_level IN VARCHAR2,
37: x_actual_value OUT NOCOPY VARCHAR2,

Line 34: p_time_level_to IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,

30: p_user_id IN VARCHAR2,
31: p_responsibility_id IN VARCHAR2,
32: p_dimension_levels IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,
33: p_time_level_from IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
34: p_time_level_to IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
35: p_time_comparison_type IN VARCHAR2,
36: p_viewby_level IN VARCHAR2,
37: x_actual_value OUT NOCOPY VARCHAR2,
38: x_compareto_value OUT NOCOPY VARCHAR2,

Line 101: p_time_dimension_level IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,

97: /************************************************************************************
98: ************************************************************************************/
99:
100: FUNCTION Get_DBI_Current_Period(
101: p_time_dimension_level IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
102: p_as_of_date IN VARCHAR2
103:
104: ) RETURN VARCHAR2;
105:

Line 151: x_kpi_info_rec OUT NOCOPY BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type

147: p_analysis_option0 IN NUMBER,
148: p_analysis_option1 IN NUMBER,
149: p_analysis_option2 IN NUMBER,
150: p_series_id IN NUMBER,
151: x_kpi_info_rec OUT NOCOPY BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type
152: );
153:
154: /************************************************************************************
155: ************************************************************************************/

Line 191: p_kpi_info_rec IN BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type,

187: /************************************************************************************
188: ************************************************************************************/
189:
190: PROCEDURE Get_Target_Value_From_PMF(
191: p_kpi_info_rec IN BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type,
192: p_user_id IN VARCHAR2,
193: p_responsibility_id IN VARCHAR2,
194: p_dimension_levels IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,
195: p_time_level IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,

Line 194: p_dimension_levels IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,

190: PROCEDURE Get_Target_Value_From_PMF(
191: p_kpi_info_rec IN BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type,
192: p_user_id IN VARCHAR2,
193: p_responsibility_id IN VARCHAR2,
194: p_dimension_levels IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,
195: p_time_level IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
196: x_target_value OUT NOCOPY VARCHAR2,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,

Line 195: p_time_level IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,

191: p_kpi_info_rec IN BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Type,
192: p_user_id IN VARCHAR2,
193: p_responsibility_id IN VARCHAR2,
194: p_dimension_levels IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,
195: p_time_level IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
196: x_target_value OUT NOCOPY VARCHAR2,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2

Line 217: ,p_dimension_levels IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type

213: ************************************************************************************/
214:
215: FUNCTION Get_Dimension_Level_Index(
216: p_dimension_short_name IN VARCHAR2
217: ,p_dimension_levels IN BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type
218: ) RETURN NUMBER;
219:
220: /************************************************************************************
221: ************************************************************************************/

Line 226: ,x_time_dimension_level OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type

222:
223: PROCEDURE Get_Default_Time_Level(
224: p_kpi_code IN NUMBER
225: ,p_dimset_id IN NUMBER
226: ,x_time_dimension_level OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type
227: );
228:
229: /************************************************************************************
230: ************************************************************************************/

Line 235: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,

231:
232: PROCEDURE Get_Default_Dimension_Levels(
233: p_kpi_code IN NUMBER,
234: p_dimset_id IN NUMBER,
235: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,
236: x_default_dimension_levels OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,
237: x_default_time_level_from OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
238: x_default_time_level_to OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type
239: );

Line 236: x_default_dimension_levels OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,

232: PROCEDURE Get_Default_Dimension_Levels(
233: p_kpi_code IN NUMBER,
234: p_dimset_id IN NUMBER,
235: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,
236: x_default_dimension_levels OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,
237: x_default_time_level_from OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
238: x_default_time_level_to OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type
239: );
240:

Line 237: x_default_time_level_from OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,

233: p_kpi_code IN NUMBER,
234: p_dimset_id IN NUMBER,
235: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,
236: x_default_dimension_levels OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,
237: x_default_time_level_from OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
238: x_default_time_level_to OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type
239: );
240:
241: /************************************************************************************

Line 238: x_default_time_level_to OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type

234: p_dimset_id IN NUMBER,
235: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,
236: x_default_dimension_levels OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Tbl_Type,
237: x_default_time_level_from OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type,
238: x_default_time_level_to OUT NOCOPY BSC_BIS_WRAPPER_PUB.Dim_level_Rec_Type
239: );
240:
241: /************************************************************************************
242: ************************************************************************************/

Line 287: x_page_parameters OUT NOCOPY BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,

283:
284: PROCEDURE Get_Page_Parameters(
285: p_user_id IN VARCHAR2,
286: p_page_id IN VARCHAR2,
287: x_page_parameters OUT NOCOPY BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,
288: x_return_status OUT NOCOPY VARCHAR2,
289: x_msg_count OUT NOCOPY NUMBER,
290: x_msg_data OUT NOCOPY VARCHAR2
291: );

Line 297: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,

293: /************************************************************************************
294: ************************************************************************************/
295:
296: PROCEDURE Get_Page_Parameter(
297: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,
298: p_page_parameter_name IN VARCHAR2,
299: x_page_parameter OUT NOCOPY BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Type
300: );
301:

Line 299: x_page_parameter OUT NOCOPY BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Type

295:
296: PROCEDURE Get_Page_Parameter(
297: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,
298: p_page_parameter_name IN VARCHAR2,
299: x_page_parameter OUT NOCOPY BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Type
300: );
301:
302: /************************************************************************************
303: ************************************************************************************/

Line 306: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type

302: /************************************************************************************
303: ************************************************************************************/
304:
305: FUNCTION Get_Time_Comparison_Parameter(
306: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type
307: ) RETURN VARCHAR2;
308:
309: /************************************************************************************
310: ************************************************************************************/

Line 315: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,

311:
312: PROCEDURE Get_Kpis_Data_From_PMF_PMV(
313: p_user_id IN VARCHAR2,
314: p_responsibility_id IN VARCHAR2,
315: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,
316: p_page_id IN VARCHAR2,
317: p_kpi_info_tbl IN OUT NOCOPY BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Tbl_Type,
318: x_return_status OUT NOCOPY VARCHAR2,
319: x_msg_count OUT NOCOPY NUMBER,

Line 317: p_kpi_info_tbl IN OUT NOCOPY BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Tbl_Type,

313: p_user_id IN VARCHAR2,
314: p_responsibility_id IN VARCHAR2,
315: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,
316: p_page_id IN VARCHAR2,
317: p_kpi_info_tbl IN OUT NOCOPY BSC_BIS_WRAPPER_PUB.Kpi_Info_Rec_Tbl_Type,
318: x_return_status OUT NOCOPY VARCHAR2,
319: x_msg_count OUT NOCOPY NUMBER,
320: x_msg_data OUT NOCOPY VARCHAR2
321: );

Line 329: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,

325:
326: PROCEDURE Get_Kpi_view_by(
327: p_kpi_code IN NUMBER,
328: p_dimset_id IN VARCHAR2,
329: p_page_parameters IN BSC_BIS_WRAPPER_PUB.Page_Parameter_Rec_Tbl_Type,
330: x_viewby_level OUT NOCOPY VARCHAR2,
331: x_return_status OUT NOCOPY VARCHAR2,
332: x_msg_count OUT NOCOPY NUMBER,
333: x_msg_data OUT NOCOPY VARCHAR2

Line 365: p_array IN BSC_BIS_WRAPPER_PUB.t_array_of_varchar2,

361: ***********************************************************************************/
362:
363: FUNCTION Item_Belong_To_Array_Varchar2(
364: p_item IN VARCHAR2,
365: p_array IN BSC_BIS_WRAPPER_PUB.t_array_of_varchar2,
366: p_num_items IN NUMBER
367: ) RETURN BOOLEAN;
368:
369: /************************************************************************************