APPS.BIS_MEASURE_PVT dependencies on BIS_DIMENSION_PUB

Line 1492: l_dimension_tbl BIS_DIMENSION_PUB.Dimension_Tbl_Type;

1488: )
1489: IS
1490:
1491: l_measure_rec BIS_Measure_PUB.Measure_Rec_Type;
1492: l_dimension_tbl BIS_DIMENSION_PUB.Dimension_Tbl_Type;
1493: l_Measure_Rec_p BIS_Measure_PUB.Measure_Rec_Type;
1494:
1495: cursor cr_all_measures is
1496: select measure_id, measure_short_name, measure_name

Line 1569: l_dimension_rec BIS_DIMENSION_PUB.DIMENSION_REC_TYPE;

1565: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1566: )
1567: IS
1568: l_ID NUMBER;
1569: l_dimension_rec BIS_DIMENSION_PUB.DIMENSION_REC_TYPE;
1570: l_Dimension_Rec_p BIS_DIMENSION_PUB.DIMENSION_REC_TYPE;
1571: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1572: BEGIN
1573: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1570: l_Dimension_Rec_p BIS_DIMENSION_PUB.DIMENSION_REC_TYPE;

1566: )
1567: IS
1568: l_ID NUMBER;
1569: l_dimension_rec BIS_DIMENSION_PUB.DIMENSION_REC_TYPE;
1570: l_Dimension_Rec_p BIS_DIMENSION_PUB.DIMENSION_REC_TYPE;
1571: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1572: BEGIN
1573: x_return_status := FND_API.G_RET_STS_SUCCESS;
1574:

Line 2184: l_dim_tbl BIS_DIMENSION_PUB.Dimension_Tbl_Type;

2180: ) IS
2181:
2182: i NUMBER;
2183: j NUMBER;
2184: l_dim_tbl BIS_DIMENSION_PUB.Dimension_Tbl_Type;
2185: l_arranged_dim_tbl BIS_DIMENSION_PUB.Dimension_Tbl_Type;
2186: l_number_of_dims NUMBER := 0;
2187:
2188: BEGIN

Line 2185: l_arranged_dim_tbl BIS_DIMENSION_PUB.Dimension_Tbl_Type;

2181:
2182: i NUMBER;
2183: j NUMBER;
2184: l_dim_tbl BIS_DIMENSION_PUB.Dimension_Tbl_Type;
2185: l_arranged_dim_tbl BIS_DIMENSION_PUB.Dimension_Tbl_Type;
2186: l_number_of_dims NUMBER := 0;
2187:
2188: BEGIN
2189:

Line 2314: l_dim_tbl BIS_DIMENSION_PUB.Dimension_Tbl_Type;

2310: , x_Measure_Rec OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
2311: )
2312: IS
2313: l_ret VARCHAR2(32000);
2314: l_dim_tbl BIS_DIMENSION_PUB.Dimension_Tbl_Type;
2315: BEGIN
2316:
2317: x_measure_rec := p_Measure_Rec1;
2318:

Line 4366: , x_dimension_Tbl OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Tbl_Type

4362:
4363: Procedure Retrieve_Measure_Dimensions
4364: ( p_api_version IN NUMBER
4365: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
4366: , x_dimension_Tbl OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Tbl_Type
4367: , x_return_status OUT NOCOPY VARCHAR2
4368: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
4369: )
4370: IS

Line 4373: l_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

4369: )
4370: IS
4371:
4372: i NUMBER := 0;
4373: l_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
4374: l_dimension_rec_p BIS_DIMENSION_PUB.Dimension_Rec_Type;
4375: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4376:
4377: cursor ind_dim(p_measure_id number) is

Line 4374: l_dimension_rec_p BIS_DIMENSION_PUB.Dimension_Rec_Type;

4370: IS
4371:
4372: i NUMBER := 0;
4373: l_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
4374: l_dimension_rec_p BIS_DIMENSION_PUB.Dimension_Rec_Type;
4375: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4376:
4377: cursor ind_dim(p_measure_id number) is
4378: select id.dimension_id

Line 4393: BIS_DIMENSION_PUB.Retrieve_Dimension

4389: i := i+1;
4390: l_dimension_rec.dimension_id := indim.dimension_id;
4391:
4392: l_dimension_rec_p := l_dimension_rec;
4393: BIS_DIMENSION_PUB.Retrieve_Dimension
4394: ( p_api_version => 1.0
4395: , p_Dimension_Rec => l_dimension_rec_p
4396: , x_Dimension_Rec => l_dimension_rec
4397: , x_return_status => x_return_status