1 PACKAGE BIS_PMV_BSC_API_PVT AUTHID CURRENT_USER AS
2 /* $Header: BISVVEWS.pls 115.1 2002/12/03 22:45:10 kiprabha noship $ */
3 --
4 /*
5 REM +=======================================================================+
6 REM | Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA |
7 REM | All rights reserved. |
8 REM +=======================================================================+
9 REM | FILENAME |
10 REM | BISVVEWS.pls |
11 REM | |
12 REM | DESCRIPTION |
13 REM | Private API for getting information about PMV Reports |
14 REM | |
15 REM | NOTES |
16 REM | |
17 REM | HISTORY |
18 REM | Date Developer Comments |
19 REM | 22-AUG-2002 nbarik Creation |
20 REM | |
21 REM | |
22 REM +=======================================================================+
23 */
24
25 --
26 -- Data Type: Record
27 --
28
29 TYPE AK_REGION_ITEMS_REC_TYPE IS RECORD
30 ( attribute_type AK_REGION_ITEMS.attribute1%TYPE
31 , attribute_value AK_REGION_ITEMS.attribute2%TYPE
32 , required_flag AK_REGION_ITEMS.required_flag%TYPE
33 );
34
35 --
36 -- PROCEDURE Get_DimLevel_Viewby
37 --
38 -- Get all the Dimension+Dimension Level combination in the report
39 -- associated with a Measure, and whether View By and All applies to those
40 -- Dimension Levels
41 --
42 PROCEDURE Get_DimLevel_Viewby
43 ( p_api_version IN NUMBER DEFAULT NULL
44 , p_Region_Code IN VARCHAR2
45 , p_Measure_Short_Name IN VARCHAR2
46 , x_DimLevel_Viewby_Tbl OUT NOCOPY BIS_PMV_BSC_API_PUB.DimLevel_Viewby_Tbl_Type
47 , x_return_status OUT NOCOPY VARCHAR2
48 , x_msg_count OUT NOCOPY NUMBER
49 , x_msg_data OUT NOCOPY VARCHAR2
50 );
51
52 --
53 -- PROCEDURE Populate_DimLevel_Viewby_Rec
54 --
55 -- Populate each DimLevel_Viewby_Rec record depending on Attribute Type,
56 -- Attribute Value, Required Flag and Disable Viewby Parameter
57 --
58 PROCEDURE Populate_DimLevel_Viewby_Rec
59 ( p_Attribute_Type IN VARCHAR2
60 , p_Attribute_Value IN VARCHAR2
61 , p_Required_Flag IN VARCHAR2
62 , p_Disable_Viewby IN VARCHAR2
63 , x_DimLevel_Viewby_Rec OUT NOCOPY BIS_PMV_BSC_API_PUB.DimLevel_Viewby_Rec_Type
64 );
65
66 END BIS_PMV_BSC_API_PVT;