eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_DIMENSION_LEVEL_PUB dependencies on BSC_SYS_DIM_LEVELS_B

Line 671: -- Load into BSC's bsc_sys_dim_levels_b/tl table by calling update/insert API of BSC

667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
668: END Delete_Dimension_Level;
669:
670: --============================================================================
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

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 868: SELECT short_name FROM bsc_sys_dim_levels_b

864: ,p_force_mode IN BOOLEAN := FALSE
865: )
866: IS
867: CURSOR c_bsc_dim_obj_exists IS
868: SELECT short_name FROM bsc_sys_dim_levels_b
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

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 874: BSC_SYS_DIM_LEVELS_B B,

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
878: AND A.dim_group_id = C.dim_grp_id

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 891: in BSC_SYS_DIM_LEVELS_B table.

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
895: CLOSE c_bsc_dim_obj_exists;

Line 908: , p_table_name => 'BSC_SYS_DIM_LEVELS_B'

904: /*BIS_UTIL.Validate_For_Update
905: ( p_last_update_date => l_last_update_date
906: , p_owner => l_owner_name
907: , p_force_mode => p_force_mode
908: , p_table_name => 'BSC_SYS_DIM_LEVELS_B'
909: , p_key_value => p_Bsc_Pmf_Dim_Rec.Dimension_Level_Short_Name
910: , x_ret_code => l_ret_code
911: , x_return_status => x_return_status
912: , x_msg_data => x_msg_data);*/

Line 918: -- Load into BSC's bsc_sys_dim_levels_b/tl table by calling update/insert API of BSC

914: END IF;
915:
916: IF (l_ret_code) THEN
917:
918: -- Load into BSC's bsc_sys_dim_levels_b/tl table by calling update/insert API of BSC
919: load_dim_levels(
920: p_commit => p_commit
921: ,p_bsc_pmf_dim_rec => p_bsc_pmf_dim_rec
922: ,p_Bsc_Dim_Level_Rec => p_Bsc_Dim_Level_Rec

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