1 package BIS_COMPUTED_ACTUAL_PVT AUTHID CURRENT_USER AS
2 /* $Header: BISVCPAS.pls 115.14 2003/04/18 14:50:37 sugopal ship $ */
3
4 SUBTYPE object_attribute_rec_type IS ak_region_items%ROWTYPE;
5
6 TYPE object_attribute_tbl_type IS TABLE OF object_attribute_rec_type
7 INDEX BY BINARY_INTEGER;
8
9 SUBTYPE object_rec_type IS ak_regions%ROWTYPE;
10
11 TYPE object_tbl_type IS TABLE OF object_rec_type
12 INDEX BY BINARY_INTEGER;
13
14 -- Derives the actual value for the specified set of dimension values
15 -- i.e. for a specific organization, time period, etc.
16 --
17 PROCEDURE Retrieve_Actual_from_PMV
18 ( p_api_version IN NUMBER
19 , p_all_info IN VARCHAR2 Default FND_API.G_TRUE
20 , p_Measure_Instance IN BIS_MEASURE_PUB.Measure_Instance_type
21 , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
22 , x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
23 , x_return_status OUT NOCOPY VARCHAR2
24 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
25 );
26
27 PROCEDURE Retrieve_Computed_Actual
28 ( p_api_version IN NUMBER
29 , p_all_info IN VARCHAR2 Default FND_API.G_TRUE
30 , p_Measure_Instance IN BIS_MEASURE_PUB.Measure_Instance_type
31 , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
32 , x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
33 , x_return_status OUT NOCOPY VARCHAR2
34 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
35 );
36
37 PROCEDURE Validate_Computed_Actual
38 ( p_api_version IN NUMBER
39 , p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
40 , p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
41 , x_return_status OUT NOCOPY VARCHAR2
42 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
43 );
44
45 PROCEDURE Validate_Required_Fields
46 ( p_api_version IN NUMBER
47 , p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
48 , p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
49 , x_return_status OUT NOCOPY VARCHAR2
50 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
51 );
52
53 PROCEDURE Value_ID_Conversion
54 ( p_api_version IN NUMBER
55 , p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
56 , x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
57 , x_return_status OUT NOCOPY VARCHAR2
58 , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
59 );
60
61 Procedure Get_Related_Objects
62 ( p_measure_short_name IN VARCHAR2
63 , x_object_tbl OUT NOCOPY object_tbl_type
64 , x_return_status OUT NOCOPY VARCHAR2
65 );
66
67 FUNCTION IS_TIME_DIMENSION_LEVEL
68 ( p_DimLevelId IN NUMBER := NULL
69 ,p_DimShortName OUT NOCOPY VARCHAR2
70 ,p_DimLevelShortName OUT NOCOPY VARCHAR2
71 , x_return_status OUT NOCOPY VARCHAR2
72 )
73 RETURN BOOLEAN;
74
75 PROCEDURE get_Region_Using_Function -- 2841680
76 ( p_Function_name IN VARCHAR2
77 , x_Region_code OUT NOCOPY VARCHAR2
78 , x_return_status OUT NOCOPY VARCHAR2
79 , x_error_msg OUT NOCOPY VARCHAR2
80 );
81
82
83 -- Procedure Update_Actual_Source; (PS bug 2165790)
84
85 Function get_dim_level_short_name(p_attribute IN VARCHAR2) RETURN VARCHAR2;
86
87 PRAGMA RESTRICT_REFERENCES (get_dim_level_short_name, WNDS, WNPS);
88
89 END BIS_COMPUTED_ACTUAL_PVT;