APPS.BIS_DIMENSION_LEVEL_PUB dependencies on BSC_DIMENSION_GROUPS_PUB

Line 66: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type

62: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_DIMENSION_LEVEL_PUB';
63: --
64: PROCEDURE load_dim_levels_in_group(
65: p_commit IN VARCHAR2 := FND_API.G_FALSE
66: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
67: ,p_Bsc_Pmf_Dim_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type
68: ,x_return_status OUT NOCOPY VARCHAR2
69: ,x_msg_count OUT NOCOPY NUMBER
70: ,x_msg_data OUT NOCOPY VARCHAR2

Line 90: , p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type

86: Procedure Load_Dimension_Level_Wrapper
87: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
88: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
89: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
90: , p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
91: , p_Bsc_Pmf_Dim_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type
92: , p_Bsc_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
93: , p_Owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
94: , p_force_mode IN BOOLEAN := FALSE

Line 800: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type

796: -- Load into BSC's bsc_sys_dim_levels_by_group table by calling update/insert API of BSC
797:
798: PROCEDURE load_dim_levels_in_group(
799: p_commit IN VARCHAR2 := FND_API.G_FALSE
800: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
801: ,p_Bsc_Pmf_Dim_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type
802: ,x_return_status OUT NOCOPY VARCHAR2
803: ,x_msg_count OUT NOCOPY NUMBER
804: ,x_msg_data OUT NOCOPY VARCHAR2

Line 807: l_Bsc_Dim_Group_Rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;

803: ,x_msg_count OUT NOCOPY NUMBER
804: ,x_msg_data OUT NOCOPY VARCHAR2
805: )
806: IS
807: l_Bsc_Dim_Group_Rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
808: BEGIN
809:
810: l_Bsc_Dim_Group_Rec.Bsc_Dim_Level_Group_Name := p_Bsc_Pmf_Dim_Rec.Dimension_Long_Name;
811: l_Bsc_Dim_Group_Rec.Bsc_Dim_Level_Group_Short_Name := p_Bsc_Pmf_Dim_Rec.Dimension_Short_Name;

Line 826: BSC_DIMENSION_GROUPS_PUB.load_dim_levels_in_group(

822: l_Bsc_Dim_Group_Rec.Bsc_Group_Level_Where_Clause := p_Dim_Grp_Rec.Bsc_Group_Level_Where_Clause;
823: l_Bsc_Dim_Group_Rec.Bsc_Dim_Level_Index := p_Dim_Grp_Rec.Bsc_Dim_Level_Index;
824:
825: -- call BSC API to load dim levels in group table (either insert/update)
826: BSC_DIMENSION_GROUPS_PUB.load_dim_levels_in_group(
827: p_commit => p_commit
828: ,p_Bsc_Pmf_Dim_Rec => p_Bsc_Pmf_Dim_Rec
829: ,p_Dim_Grp_Rec => l_bsc_dim_group_rec
830: ,x_return_status => x_return_status

Line 858: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type

854:
855: --=============================================================================
856: PROCEDURE Load_Dimension_Level (
857: p_Commit IN VARCHAR2 := FND_API.G_FALSE
858: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
859: ,p_Bsc_Pmf_Dim_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type
860: ,p_Bsc_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
861: ,x_return_status OUT NOCOPY VARCHAR2
862: ,x_msg_count OUT NOCOPY NUMBER

Line 1207: BSC_DIMENSION_GROUPS_PUB.Retrieve_Sys_Dim_Lvls_Grp_Wrap (

1203: x_attribute_code := l_Dimension_Level_Rec_Out.Attribute_Code;
1204: x_application_id := l_Dimension_Level_Rec_Out.Application_ID;
1205: x_drill_to_form_function := l_Dimension_Level_Rec_Out.Drill_To_Form_Function;
1206:
1207: BSC_DIMENSION_GROUPS_PUB.Retrieve_Sys_Dim_Lvls_Grp_Wrap (
1208: p_dim_level_shortname => p_dim_level_short_name
1209: ,p_dim_shortname => p_dim_short_name
1210: ,x_dim_group_id => x_dim_group_id
1211: ,x_dim_level_id => x_dim_level_id