APPS.BIS_DIMENSION_LEVEL_PUB dependencies on BSC_SYS_DIM_LEVELS_BY_GROUP

Line 796: -- Load into BSC's bsc_sys_dim_levels_by_group table by calling update/insert API of BSC

792: END load_dim_levels;
793:
794:
795: --============================================================================
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

Line 873: FROM BSC_SYS_DIM_LEVELS_BY_GROUP A,

869: WHERE short_name = p_Bsc_Pmf_Dim_Rec.Dimension_Level_Short_Name;
870:
871: CURSOR c_dim_dimobj_mapping_exists IS
872: SELECT 1
873: FROM BSC_SYS_DIM_LEVELS_BY_GROUP A,
874: BSC_SYS_DIM_LEVELS_B B,
875: BIS_DIMENSIONS C
876: WHERE C.short_name = p_Bsc_Pmf_Dim_Rec.Dimension_Short_Name
877: AND B.short_name = p_Bsc_Pmf_Dim_Rec.Dimension_Level_Short_Name

Line 887: Bug#4172055: Even though BSC_SYS_DIM_LEVELS_BY_GROUP does not has LUD column

883: l_last_update_date DATE;
884: l_ret_code BOOLEAN := TRUE;
885: BEGIN
886: /*
887: Bug#4172055: Even though BSC_SYS_DIM_LEVELS_BY_GROUP does not has LUD column
888: still the upload of a dimension object should not modify this table unless
889: other LUDs are validated. For this, LUD check is done here both for
890: BSC_SYS_DIM_LEVELS_B and BSC_SYS_DIM_LEVELS_BY_GROUP, based on the LUD
891: in BSC_SYS_DIM_LEVELS_B table.

Line 890: BSC_SYS_DIM_LEVELS_B and BSC_SYS_DIM_LEVELS_BY_GROUP, based on the LUD

886: /*
887: Bug#4172055: Even though BSC_SYS_DIM_LEVELS_BY_GROUP does not has LUD column
888: still the upload of a dimension object should not modify this table unless
889: other LUDs are validated. For this, LUD check is done here both for
890: BSC_SYS_DIM_LEVELS_B and BSC_SYS_DIM_LEVELS_BY_GROUP, based on the LUD
891: in BSC_SYS_DIM_LEVELS_B table.
892: */
893:
894: IF (c_bsc_dim_obj_exists%ISOPEN) THEN

Line 928: -- Load into BSC's bsc_sys_dim_levels_by_group table by calling update/insert API of BSC

924: ,x_msg_count => x_msg_count
925: ,x_msg_data => x_msg_data
926: );
927:
928: -- Load into BSC's bsc_sys_dim_levels_by_group table by calling update/insert API of BSC
929: load_dim_levels_in_group(
930: p_commit => p_commit
931: ,p_Dim_Grp_Rec => p_Dim_Grp_Rec
932: ,p_Bsc_Pmf_Dim_Rec => p_Bsc_Pmf_Dim_Rec

Line 948: -- Load into BSC's bsc_sys_dim_levels_by_group table by calling update/insert API of BSC

944: FETCH c_dim_dimobj_mapping_exists INTO l_short_name;
945:
946: IF (c_dim_dimobj_mapping_exists%NOTFOUND) THEN
947:
948: -- Load into BSC's bsc_sys_dim_levels_by_group table by calling update/insert API of BSC
949: load_dim_levels_in_group(
950: p_commit => p_commit
951: ,p_Dim_Grp_Rec => p_Dim_Grp_Rec
952: ,p_Bsc_Pmf_Dim_Rec => p_Bsc_Pmf_Dim_Rec