APPS.BSC_UPDATE_LOCK dependencies on BSC_UPDATE_DIM

Line 805: h_dim_table_type := BSC_UPDATE_DIM.Get_Dim_Table_Type(x_dim_table);

801: h_lock_types(h_num_objects) := 'W';
802: h_cascade_levels(h_num_objects) := 0;
803:
804: -- Lock the dimension table
805: h_dim_table_type := BSC_UPDATE_DIM.Get_Dim_Table_Type(x_dim_table);
806: IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_UNKNOWN THEN
807: RETURN FALSE;
808: END IF;
809: IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_1N THEN

Line 806: IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_UNKNOWN THEN

802: h_cascade_levels(h_num_objects) := 0;
803:
804: -- Lock the dimension table
805: h_dim_table_type := BSC_UPDATE_DIM.Get_Dim_Table_Type(x_dim_table);
806: IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_UNKNOWN THEN
807: RETURN FALSE;
808: END IF;
809: IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_1N THEN
810: SELECT dim_level_id

Line 809: IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_1N THEN

805: h_dim_table_type := BSC_UPDATE_DIM.Get_Dim_Table_Type(x_dim_table);
806: IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_UNKNOWN THEN
807: RETURN FALSE;
808: END IF;
809: IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_1N THEN
810: SELECT dim_level_id
811: INTO h_dim_level_id
812: FROM bsc_sys_dim_levels_b
813: WHERE level_table_name = x_dim_table;

Line 843: IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_MN THEN

839: h_object_types(h_num_objects) := 'DIMENSION_OBJECT';
840: h_lock_types(h_num_objects) := 'W';
841: h_cascade_levels(h_num_objects) := 0;
842:
843: IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_MN THEN
844: BSC_APPS.Add_Value_Big_In_Cond(1, h_parent_level_id);
845: END IF;
846: END LOOP;
847: CLOSE c_parent_dims;

Line 850: IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_1N THEN

846: END LOOP;
847: CLOSE c_parent_dims;
848:
849: -- Lock the child dimensions (all the childs, grand childs etc)
850: IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_1N THEN
851: --This query gets all the child, grand child all the way down.
852: OPEN c_child_dims(h_dim_level_id);
853: LOOP
854: FETCH c_child_dims INTO h_child_level_id;