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.

[Home] [Help]

APPS.BSC_UPDATE_LOCK SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 13


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 14


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 28


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 45


    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 46


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 47


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 48


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 54


        SELECT periodicity_id
        FROM bsc_sys_periodicities
        WHERE calendar_id = x_calendar_id;

Line: 85


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 102


    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 103


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 104


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 105


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 111


        SELECT periodicity_id
        FROM bsc_sys_periodicities
        WHERE calendar_id = x_calendar_id;

Line: 118


        SELECT indicator
        FROM bsc_kpis_b
        WHERE calendar_id = x_calendar_id;

Line: 125


        SELECT table_name
        FROM bsc_db_tables
        WHERE periodicity_id IN (
            SELECT periodicity_id
            FROM bsc_sys_periodicities
            WHERE calendar_id = x_calendar_id
         );

Line: 194


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 211


    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 212


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 213


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 214


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 220


        select distinct table_name
        from bsc_kpi_data_tables
        where indicator = x_indicator and table_name is not null;

Line: 239


    IF BSC_UPDATE_UTIL.Get_Kpi_Impl_Type(x_indicator) = 2 THEN
        --AW indicator
        h_num_objects := h_num_objects + 1;

Line: 262


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 277


    x_indicators IN BSC_UPDATE_UTIL.t_array_of_number,
    x_num_indicators IN NUMBER
) RETURN BOOLEAN IS
    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 281


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 282


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 283


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 300


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 317


    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 318


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 319


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 320


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 326


        SELECT dim_level_id
        FROM bsc_sys_dim_levels_b
        WHERE short_name = x_dim_short_name;

Line: 350


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 365


    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 366


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 367


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 368


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 383


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 400


    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 401


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 402


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 403


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 418


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 433


    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 434


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 435


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 436


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 441


    h_indicators BSC_UPDATE_UTIL.t_array_of_number;

Line: 443


    h_input_tables BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 447


        select distinct indicator
        from bsc_kpis_vl
        where calendar_id in (
            select calendar_id
            from bsc_sys_calendars_b
            where fiscal_change = 1
        );

Line: 484


    h_sql := 'SELECT DISTINCT indicator'||
             ' FROM bsc_kpis_vl'||
             ' WHERE prototype_flag IN (6,7)';

Line: 487


    IF BSC_UPDATE.g_kpi_mode THEN
        IF BSC_UPDATE.g_num_indicators > 0 THEN
            h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'indicator');

Line: 490


            FOR h_i IN 1..BSC_UPDATE.g_num_indicators LOOP
                BSC_APPS.Add_Value_Big_In_Cond(1, BSC_UPDATE.g_indicators(h_i));

Line: 505


        IF NOT BSC_UPDATE_UTIL.Item_Belong_To_Array_Varchar2(h_indicator, h_object_keys, h_num_objects) THEN
            h_num_indicators := h_num_indicators + 1;

Line: 513


    IF NOT BSC_UPDATE.Get_Input_Tables_Kpis(h_indicators, h_num_indicators, h_input_tables, h_num_input_tables) THEN
        RETURN FALSE;

Line: 517


    IF NOT BSC_UPDATE.get_kpi_for_input_tables(h_input_tables,h_num_input_tables,h_indicators,h_num_indicators) THEN
        RETURN FALSE;

Line: 522


        IF BSC_UPDATE.g_kpi_mode THEN
            IF BSC_UPDATE_UTIL.Item_Belong_To_Array_Number(h_indicators(h_i),
                                                           BSC_UPDATE.g_indicators,
                                                           BSC_UPDATE.g_num_indicators) THEN
                IF NOT BSC_UPDATE_UTIL.Item_Belong_To_Array_Varchar2(h_indicators(h_i), h_object_keys, h_num_objects) THEN
                    h_num_objects := h_num_objects + 1;

Line: 535


            IF NOT BSC_UPDATE_UTIL.Item_Belong_To_Array_Varchar2(h_indicators(h_i), h_object_keys, h_num_objects) THEN
                h_num_objects := h_num_objects + 1;

Line: 546


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 564


    x_input_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
    x_num_input_tables IN NUMBER
) RETURN BOOLEAN IS
    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 568


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 569


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 570


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 575


    h_indicators BSC_UPDATE_UTIL.t_array_of_number;

Line: 581


    IF NOT BSC_UPDATE.get_kpi_for_input_tables(x_input_tables,x_num_input_tables,h_indicators,h_num_indicators) THEN
        RETURN FALSE;

Line: 586


        IF BSC_UPDATE.g_kpi_mode THEN
            IF BSC_UPDATE_UTIL.Item_Belong_To_Array_Number(h_indicators(h_i),
                                                           BSC_UPDATE.g_indicators,
                                                           BSC_UPDATE.g_num_indicators) THEN
                IF NOT BSC_UPDATE_UTIL.Item_Belong_To_Array_Varchar2(h_indicators(h_i), h_object_keys, h_num_objects) THEN
                    h_num_objects := h_num_objects + 1;

Line: 599


            IF NOT BSC_UPDATE_UTIL.Item_Belong_To_Array_Varchar2(h_indicators(h_i), h_object_keys, h_num_objects) THEN
                h_num_objects := h_num_objects + 1;

Line: 610


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 625


    x_calendars IN BSC_UPDATE_UTIL.t_array_of_number,
    x_num_calendars IN NUMBER
) RETURN BOOLEAN IS
    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 629


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 630


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 631


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 637


        select indicator
        from bsc_kpis_b
        where calendar_id = p_calendar_id;

Line: 662


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 674


|  FUNCTION Lock_Indicators_To_Delete
+============================================================================*/
FUNCTION Lock_Indicators_To_Delete (
    x_indicators IN BSC_UPDATE_UTIL.t_array_of_number,
    x_num_indicators IN NUMBER
) RETURN BOOLEAN IS
    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 681


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 682


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 683


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 688


    h_indicators BSC_UPDATE_UTIL.t_array_of_number;

Line: 690


    h_input_tables BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 716


    IF NOT BSC_UPDATE.Get_Input_Tables_Kpis(h_indicators, h_num_indicators, h_input_tables, h_num_input_tables) THEN
        RETURN FALSE;

Line: 720


    IF NOT BSC_UPDATE.get_kpi_for_input_tables(h_input_tables,h_num_input_tables,h_indicators,h_num_indicators) THEN
        RETURN FALSE;

Line: 725


        IF NOT BSC_UPDATE_UTIL.Item_Belong_To_Array_Number(h_indicators(h_i), x_indicators, x_num_indicators) THEN
            h_num_objects := h_num_objects + 1;

Line: 735


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 743


END Lock_Indicators_To_Delete;

Line: 753


    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 754


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 755


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 756


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 764


        SELECT dp.dim_level_id
        FROM bsc_sys_dim_levels_b d, bsc_sys_dim_levels_b dp, bsc_sys_dim_level_rels r
        WHERE d.dim_level_id = r.dim_level_id AND
              r.parent_dim_level_id = dp.dim_level_id AND
              DECODE(r.relation_type, 2, r.relation_col, d.level_table_name) = x_dim_table;

Line: 773


        select distinct dim_level_id
        from
          (select dim_level_id, parent_dim_level_id
           from bsc_sys_dim_level_rels
           where relation_type = 1
          )
        start with parent_dim_level_id = p_dim_level_id
        connect by parent_dim_level_id = prior dim_level_id;

Line: 805


    h_dim_table_type := BSC_UPDATE_DIM.Get_Dim_Table_Type(x_dim_table);

Line: 806


    IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_UNKNOWN THEN
        RETURN FALSE;

Line: 809


    IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_1N THEN
        SELECT dim_level_id
        INTO h_dim_level_id
        FROM bsc_sys_dim_levels_b
        WHERE level_table_name = x_dim_table;

Line: 843


        IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_MN THEN
            BSC_APPS.Add_Value_Big_In_Cond(1, h_parent_level_id);

Line: 850


    IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_1N THEN
        --This query gets all the child, grand child all the way down.
        OPEN c_child_dims(h_dim_level_id);

Line: 870


    h_sql := 'SELECT DISTINCT bt.table_name'||
             ' FROM ('||
             ' SELECT DISTINCT table_name FROM bsc_db_tables_rels'||
             ' WHERE source_table_name IN ('||
             ' SELECT table_name FROM bsc_db_tables WHERE table_type = :1)) bt,'||
             ' bsc_db_tables_cols c'||
             ' WHERE bt.table_name = c.table_name AND'||
             ' c.column_type = :2 AND c.column_name IN ('||
             ' SELECT level_pk_col FROM bsc_sys_dim_levels_b'||
             ' WHERE '||h_cond_for_base_tables||')';

Line: 894


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 914


    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 915


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 916


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 917


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 931


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 946


    x_indicators IN BSC_UPDATE_UTIL.t_array_of_number,
    x_num_indicators IN NUMBER
) RETURN BOOLEAN IS
    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 950


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 951


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 952


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 969


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 986


    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 987


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 988


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 989


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 995


        select distinct indicator
        from bsc_kpi_data_tables
        where table_name = x_table_name;

Line: 1019


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 1036


    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1037


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1038


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1039


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 1054


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 1071


    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1072


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1073


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1074


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 1080


        select distinct indicator
        from bsc_kpis_b
        where calendar_id = x_calendar_id;

Line: 1103


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 1119


    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1120


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1121


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1122


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 1136


    h_sql := 'SELECT DISTINCT indicator'||
             ' FROM bsc_kpis_vl'||
             ' WHERE prototype_flag IN (6,7)';

Line: 1139


    IF BSC_UPDATE.g_kpi_mode THEN
        IF BSC_UPDATE.g_num_indicators > 0 THEN
            h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'indicator');

Line: 1142


            FOR h_i IN 1..BSC_UPDATE.g_num_indicators LOOP
                BSC_APPS.Add_Value_Big_In_Cond(1, BSC_UPDATE.g_indicators(h_i));

Line: 1163


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 1183


    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1184


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1185


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1186


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 1192


        select distinct table_name
        from bsc_db_tables_rels
        start with table_name in (
            select distinct table_name
            from bsc_kpi_data_tables
            where indicator = x_indicator and
                  table_name is not null
        )
        connect by table_name = prior source_table_name;

Line: 1229


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 1246


    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1247


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1248


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1249


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 1255


        select distinct source_table_name
        from bsc_db_tables_rels
        where table_name = x_summary_table;

Line: 1286


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 1303


    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1304


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1305


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1306


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 1312


        select distinct table_name
        from bsc_db_tables
        where table_name like p_like_name;

Line: 1317


        select distinct source_table_name
        from bsc_db_tables_rels
        where table_name like p_like_name;

Line: 1347


            IF NOT BSC_UPDATE_UTIL.Item_Belong_To_Array_Varchar2(h_table_name, h_object_keys, h_num_objects) THEN
                h_num_objects := h_num_objects + 1;

Line: 1363


            IF NOT BSC_UPDATE_UTIL.Item_Belong_To_Array_Varchar2(h_table_name, h_object_keys, h_num_objects) THEN
                h_num_objects := h_num_objects + 1;

Line: 1375


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 1392


    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1393


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1394


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1395


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 1401


        select distinct source_table_name
        from bsc_db_tables_rels
        where table_name = x_summary_table;

Line: 1432


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 1444


|  FUNCTION Lock_Update_Base_Table
+============================================================================*/
FUNCTION Lock_Update_Base_Table(
    x_input_table IN VARCHAR2,
    x_base_table IN VARCHAR2
) RETURN BOOLEAN IS
    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1451


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1452


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1453


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 1475


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 1483


END Lock_Update_Base_Table;

Line: 1487


|  FUNCTION Lock_Update_Date
+============================================================================*/
FUNCTION Lock_Update_Date RETURN BOOLEAN IS
    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1491


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1492


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1493


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 1502


    h_object_types(h_num_objects) := 'UPDATE_DATE';

Line: 1507


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 1515


END Lock_Update_Date;

Line: 1524


    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1525


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1526


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1527


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 1542


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 1557


    x_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
    x_num_tables IN NUMBER
) RETURN BOOLEAN IS
    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1561


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1562


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1563


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 1580


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 1597


    h_object_keys BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1598


    h_object_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1599


    h_lock_types BSC_UPDATE_UTIL.t_array_of_varchar2;

Line: 1600


    h_cascade_levels BSC_UPDATE_UTIL.t_array_of_number;

Line: 1615


        BSC_UPDATE_LOG.Write_Line_Log('Locking: '||h_object_keys(h_i)||' '||h_object_types(h_i)||
                                      ' '||h_lock_types(h_i)||' '||h_cascade_levels(h_i),
                                      BSC_UPDATE_LOG.OUTPUT);

Line: 1630


    x_object_keys IN BSC_UPDATE_UTIL.t_array_of_varchar2,
    x_object_types IN BSC_UPDATE_UTIL.t_array_of_varchar2,
    x_lock_types IN BSC_UPDATE_UTIL.t_array_of_varchar2,
    x_cascade_levels IN BSC_UPDATE_UTIL.t_array_of_number,
    x_num_objects IN NUMBER
) RETURN BOOLEAN IS

    h_i NUMBER;

Line: 1672


                    BSC_UPDATE_LOG.Write_Line_Log(x_object_keys(h_i)||' '||x_object_types(h_i)||': '||h_msg_data,
                                                  BSC_UPDATE_LOG.OUTPUT);

Line: 1679


                    BSC_UPDATE_LOG.Write_Line_Log(h_msg_data, BSC_UPDATE_LOG.OUTPUT);