APPS.BIS_DIMENSION_LEVEL_PUB dependencies on BSC_PMF_UI_API_PUB

Line 67: ,p_Bsc_Pmf_Dim_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type

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
71: );

Line 77: ,p_bsc_pmf_dim_rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type

73: --=======================================================================
74:
75: PROCEDURE load_dim_levels(
76: p_commit IN VARCHAR2 := FND_API.G_FALSE
77: ,p_bsc_pmf_dim_rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type
78: ,p_Bsc_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
79: ,x_return_status OUT NOCOPY VARCHAR2
80: ,x_msg_count OUT NOCOPY NUMBER
81: ,x_msg_data OUT NOCOPY VARCHAR2

Line 91: , p_Bsc_Pmf_Dim_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type

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
95: , x_return_status OUT NOCOPY VARCHAR2

Line 170: , p_Bsc_Pmf_Dim_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type

166: Procedure Translate_Dim_Level_Wrapper
167: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
168: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
169: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
170: , p_Bsc_Pmf_Dim_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type
171: , p_Bsc_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
172: , p_Owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
173: , x_return_status OUT NOCOPY VARCHAR2
174: , x_msg_count OUT NOCOPY NUMBER

Line 675: ,p_bsc_pmf_dim_rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type

671: -- Load into BSC's bsc_sys_dim_levels_b/tl table by calling update/insert API of BSC
672:
673: PROCEDURE load_dim_levels(
674: p_commit IN VARCHAR2 := FND_API.G_FALSE
675: ,p_bsc_pmf_dim_rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type
676: ,p_Bsc_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
677: ,x_return_status OUT NOCOPY VARCHAR2
678: ,x_msg_count OUT NOCOPY NUMBER
679: ,x_msg_data OUT NOCOPY VARCHAR2

Line 682: l_Bsc_Pmf_Dim_Rec BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type;

678: ,x_msg_count OUT NOCOPY NUMBER
679: ,x_msg_data OUT NOCOPY VARCHAR2
680: )
681: IS
682: l_Bsc_Pmf_Dim_Rec BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type;
683: l_Bsc_Dim_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
684:
685: l_alternate_level_view VARCHAR2(80);
686: l_edw_sql VARCHAR2(1000);

Line 801: ,p_Bsc_Pmf_Dim_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type

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
805: )

Line 859: ,p_Bsc_Pmf_Dim_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type

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
863: ,x_msg_data OUT NOCOPY VARCHAR2