APPS.BIS_PMF_GET_DIMLEVELS_PVT dependencies on BSC_DIMENSION_LEVELS_PUB

Line 192: ,x_bsc_dim_rel_info_rec OUT NOCOPY bsc_dimension_levels_pub.bsc_dim_level_rec_type

188:
189: PROCEDURE get_bsc_relationship_data (
190: p_child_dimlvl_rec IN bis_pmf_get_dimlevels_pub.dimlvl_rec_type
191: ,p_parent_dimlvl_rec IN bis_pmf_get_dimlevels_pub.dimlvl_rec_type
192: ,x_bsc_dim_rel_info_rec OUT NOCOPY bsc_dimension_levels_pub.bsc_dim_level_rec_type
193: ,x_is_relationship_found OUT NOCOPY VARCHAR2
194: ,x_is_relation_recursive OUT NOCOPY VARCHAR2
195: ,x_return_status OUT NOCOPY VARCHAR2
196: ,x_msg_count OUT NOCOPY NUMBER

Line 1710: l_bsc_dim_rel_info_rec bsc_dimension_levels_pub.bsc_dim_level_rec_type;

1706: ,x_msg_count OUT NOCOPY NUMBER
1707: ,x_msg_data OUT NOCOPY VARCHAR2
1708: )
1709: IS
1710: l_bsc_dim_rel_info_rec bsc_dimension_levels_pub.bsc_dim_level_rec_type;
1711: l_parent_dimlvl_tbl bis_pmf_get_dimlevels_pub.dimlvl_tbl_type;
1712: l_count NUMBER;
1713: err_msg VARCHAR2(3000);
1714: BEGIN

Line 1762: ,x_bsc_dim_rel_info_rec OUT NOCOPY bsc_dimension_levels_pub.bsc_dim_level_rec_type

1758:
1759: PROCEDURE get_bsc_relationship_data (
1760: p_child_dimlvl_rec IN bis_pmf_get_dimlevels_pub.dimlvl_rec_type
1761: ,p_parent_dimlvl_rec IN bis_pmf_get_dimlevels_pub.dimlvl_rec_type
1762: ,x_bsc_dim_rel_info_rec OUT NOCOPY bsc_dimension_levels_pub.bsc_dim_level_rec_type
1763: ,x_is_relationship_found OUT NOCOPY VARCHAR2
1764: ,x_is_relation_recursive OUT NOCOPY VARCHAR2
1765: ,x_return_status OUT NOCOPY VARCHAR2
1766: ,x_msg_count OUT NOCOPY NUMBER

Line 1770: l_bsc_dim_level_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

1766: ,x_msg_count OUT NOCOPY NUMBER
1767: ,x_msg_data OUT NOCOPY VARCHAR2
1768: )
1769: IS
1770: l_bsc_dim_level_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
1771: -- l_return_status VARCHAR2(10);
1772: -- l_msg_count NUMBER;
1773: -- l_msg_data VARCHAR2(3000);
1774: BEGIN

Line 1781: BSC_DIMENSION_LEVELS_PUB.Retrieve_Relationship (

1777: l_bsc_dim_level_rec.bsc_level_short_name := p_child_dimlvl_rec.dimension_level_short_name;
1778: l_bsc_dim_level_rec.bsc_parent_level_short_name := p_parent_dimlvl_rec.dimension_level_short_name;
1779:
1780: -- check if a direct parent-child relationship exists
1781: BSC_DIMENSION_LEVELS_PUB.Retrieve_Relationship (
1782: p_Dim_Level_Rec => l_bsc_dim_level_rec
1783: ,x_Dim_Level_Rec => x_bsc_dim_rel_info_rec
1784: ,x_return_status => x_return_status
1785: ,x_msg_count => x_msg_count