APPS.BIS_DIMENSION_LEVEL_PUB dependencies on BIS_LEVELS

Line 486: FROM BIS_LEVELS

482:
483: l_Dimension_Level_Rec.Last_Update_Date := NVL(p_Dimension_Level_Rec.Last_Update_Date, SYSDATE);
484:
485: SELECT COUNT(short_name) INTO l_count
486: FROM BIS_LEVELS
487: WHERE short_name = p_Dimension_Level_Rec.Dimension_Level_Short_Name;
488:
489: IF (l_count > 0) THEN
490: BIS_UTIL.Validate_For_Update ( p_last_update_date => l_Dimension_Level_Rec.Last_Update_Date

Line 493: ,p_table_name => 'BIS_LEVELS'

489: IF (l_count > 0) THEN
490: BIS_UTIL.Validate_For_Update ( p_last_update_date => l_Dimension_Level_Rec.Last_Update_Date
491: ,p_owner => p_owner
492: ,p_force_mode => p_force_mode
493: ,p_table_name => 'BIS_LEVELS'
494: ,p_key_value => p_Dimension_Level_Rec.Dimension_Level_Short_Name
495: ,x_ret_code => l_ret_code
496: ,x_return_status => x_return_status
497: ,x_msg_data => l_return_msg

Line 707: FROM bis_levels_vl

703: l_Bsc_Pmf_Dim_Rec.Dimension_Level_Long_Name,
704: l_Bsc_Pmf_Dim_Rec.Dimension_Level_View_Name,
705: l_Bsc_Pmf_Dim_Rec.Dimension_Level_Pk_Key,
706: l_Bsc_Pmf_Dim_Rec.Dimension_Level_Name_Column
707: FROM bis_levels_vl
708: WHERE UPPER(short_name) = UPPER(p_Bsc_Pmf_Dim_Rec.Dimension_Level_Short_Name);
709:
710: l_Bsc_Pmf_Dim_Rec.Dimension_Level_Disp_Size := 250;
711:

Line 881: l_short_name BIS_LEVELS.Short_Name%TYPE;

877: AND B.short_name = p_Bsc_Pmf_Dim_Rec.Dimension_Level_Short_Name
878: AND A.dim_group_id = C.dim_grp_id
879: AND A.dim_level_id = B.dim_level_id;
880:
881: l_short_name BIS_LEVELS.Short_Name%TYPE;
882: l_owner_name VARCHAR2(100);
883: l_last_update_date DATE;
884: l_ret_code BOOLEAN := TRUE;
885: BEGIN

Line 1064: FROM bis_levels

1060: ) RETURN VARCHAR2 IS
1061:
1062: CURSOR c_master IS
1063: SELECT master_level
1064: FROM bis_levels
1065: WHERE short_name = p_dim_level_short_name;
1066:
1067: l_master_dim_level VARCHAR2(30);
1068:

Line 1301: CURSOR c_cust IS SELECT level_id FROM bis_levels WHERE short_name = p_dim_level_short_name;

1297: , x_dim_level_cust_name OUT NOCOPY VARCHAR2
1298: , x_dim_level_cust_desc OUT NOCOPY VARCHAR2
1299: , x_dim_level_cust_enabled OUT NOCOPY VARCHAR2
1300: ) AS
1301: CURSOR c_cust IS SELECT level_id FROM bis_levels WHERE short_name = p_dim_level_short_name;
1302: l_level_id NUMBER;
1303: BEGIN
1304: IF (c_cust%ISOPEN) THEN
1305: CLOSE c_cust;