DBA Data[Home] [Help]

APPS.BIS_DIMENSION_LEVEL_PVT dependencies on BIS_DIMENSION_PUB

Line 376: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

372: --
373: --
374: Procedure Retrieve_Dimension_Levels
375: ( p_api_version IN NUMBER
376: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
377: , x_Dimension_Level_Tbl OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type
378: , x_return_status OUT NOCOPY VARCHAR2
379: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
380: )

Line 383: l_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

379: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
380: )
381: IS
382: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
383: l_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
384: l_dim_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
385: --flag to check if there is an error
386: l_flag NUMBER :=0;
387: cursor cr_dim_id is

Line 636: l_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

632: IS
633: l_dim_id NUMBER;
634: l_dim_short_name varchar2(30);
635: l_dim_name varchar2(80);
636: l_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
637: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
638: cursor cr_lev_id is
639: select dimension_id
640: , dimension_short_name