DBA Data[Home] [Help]

APPS.BIS_DIM_LEVEL_VALUE_PVT dependencies on BIS_DIMENSION_LEVEL_PUB

Line 50: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

46: --
47: --
48: Procedure Retrieve_Dim_Level_Values
49: ( p_api_version IN NUMBER
50: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
51: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
52: , x_return_status OUT NOCOPY VARCHAR2
53: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
54: )

Line 63: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

59: --
60: --
61: PROCEDURE Get_Org_Dim_Values
62: ( p_api_version IN NUMBER
63: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
64: , p_Responsibility_Tbl IN BIS_RESPONSIBILITY_PVT.Responsibility_Tbl_Type
65: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
66: , x_return_status OUT NOCOPY VARCHAR2
67: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 242: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

238: --
239: --
240: PROCEDURE Get_Org_Dim_Values
241: ( p_api_version IN NUMBER
242: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
243: , p_Responsibility_ID IN NUMBER
244: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
245: , x_return_status OUT NOCOPY VARCHAR2
246: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 399: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

395: --
396: --
397: PROCEDURE Get_Org_Dim_Values
398: ( p_api_version IN NUMBER
399: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
400: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
401: , x_return_status OUT NOCOPY VARCHAR2
402: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
403: )

Line 539: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

535: --
536: --
537: PROCEDURE Get_DimensionX_Values
538: ( p_api_version IN NUMBER
539: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
540: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
541: , x_return_status OUT NOCOPY VARCHAR2
542: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
543: )

Line 682: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

678: --
679: --
680: PROCEDURE Get_Time_Dim_Values
681: ( p_api_version IN NUMBER
682: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
683: , p_Dim_Level_Value_Rec IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type
684: , x_Dim_Level_Value_Tbl OUT NOCOPY BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
685: , x_return_status OUT NOCOPY VARCHAR2
686: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 909: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

905: --
906: --
907: PROCEDURE Get_Start_Date
908: ( p_api_version IN NUMBER
909: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
910: , p_start_period IN VARCHAR2
911: , x_start_date OUT NOCOPY DATE
912: , x_return_status OUT NOCOPY VARCHAR2
913: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 1013: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

1009: --
1010: --
1011: PROCEDURE Get_End_Date
1012: ( p_api_version IN NUMBER
1013: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
1014: , p_end_period IN VARCHAR2
1015: , x_end_date OUT NOCOPY DATE
1016: , x_return_status OUT NOCOPY VARCHAR2
1017: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 1835: l_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

1831: IS
1832:
1833: l_sql VARCHAR2(32000);
1834: l_time_id VARCHAR2(32000) := NULL;
1835: l_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1836: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1837:
1838: l_view_name VARCHAR2(80);
1839: l_short_name VARCHAR2(30);

Line 1971: l_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

1967: IS
1968:
1969: l_sql VARCHAR2(32000);
1970: l_time_id VARCHAR2(32000) := NULL;
1971: l_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1972: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1973: --l_period_set_name VARCHAR2(32000);
1974:
1975: l_view_name VARCHAR2(80);