APPS.BSC_UPDATE_LOCK dependencies on BSC_APPS

Line 489: h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'indicator');

485: ' FROM bsc_kpis_vl'||
486: ' WHERE prototype_flag IN (6,7)';
487: IF BSC_UPDATE.g_kpi_mode THEN
488: IF BSC_UPDATE.g_num_indicators > 0 THEN
489: h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'indicator');
490: FOR h_i IN 1..BSC_UPDATE.g_num_indicators LOOP
491: BSC_APPS.Add_Value_Big_In_Cond(1, BSC_UPDATE.g_indicators(h_i));
492: END LOOP;
493: h_sql := h_sql||' AND ('||h_where_indics||')';

Line 491: BSC_APPS.Add_Value_Big_In_Cond(1, BSC_UPDATE.g_indicators(h_i));

487: IF BSC_UPDATE.g_kpi_mode THEN
488: IF BSC_UPDATE.g_num_indicators > 0 THEN
489: h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'indicator');
490: FOR h_i IN 1..BSC_UPDATE.g_num_indicators LOOP
491: BSC_APPS.Add_Value_Big_In_Cond(1, BSC_UPDATE.g_indicators(h_i));
492: END LOOP;
493: h_sql := h_sql||' AND ('||h_where_indics||')';
494: END IF;
495: END IF;

Line 795: h_cond_for_base_tables := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'dim_level_id');

791: h_cond_for_base_tables VARCHAR2(32000);
792:
793: BEGIN
794: h_num_objects := 0;
795: h_cond_for_base_tables := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'dim_level_id');
796:
797: -- Lock the input table
798: h_num_objects := h_num_objects + 1;
799: h_object_keys(h_num_objects) := x_input_table;

Line 821: BSC_APPS.Add_Value_Big_In_Cond(1, h_dim_level_id);

817: h_object_types(h_num_objects) := 'DIMENSION_OBJECT';
818: h_lock_types(h_num_objects) := 'W';
819: h_cascade_levels(h_num_objects) := 0;
820:
821: BSC_APPS.Add_Value_Big_In_Cond(1, h_dim_level_id);
822: ELSE
823: -- mn dimension table
824: h_num_objects := h_num_objects + 1;
825: h_object_keys(h_num_objects) := x_dim_table;

Line 844: BSC_APPS.Add_Value_Big_In_Cond(1, h_parent_level_id);

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;
848:

Line 864: BSC_APPS.Add_Value_Big_In_Cond(1, h_child_level_id);

860: h_object_types(h_num_objects) := 'DIMENSION_OBJECT';
861: h_lock_types(h_num_objects) := 'W';
862: h_cascade_levels(h_num_objects) := 0;
863:
864: BSC_APPS.Add_Value_Big_In_Cond(1, h_child_level_id);
865: END LOOP;
866: CLOSE c_child_dims;
867: END IF;
868:

Line 1141: h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'indicator');

1137: ' FROM bsc_kpis_vl'||
1138: ' WHERE prototype_flag IN (6,7)';
1139: IF BSC_UPDATE.g_kpi_mode THEN
1140: IF BSC_UPDATE.g_num_indicators > 0 THEN
1141: h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'indicator');
1142: FOR h_i IN 1..BSC_UPDATE.g_num_indicators LOOP
1143: BSC_APPS.Add_Value_Big_In_Cond(1, BSC_UPDATE.g_indicators(h_i));
1144: END LOOP;
1145: h_sql := h_sql||' AND ('||h_where_indics||')';

Line 1143: BSC_APPS.Add_Value_Big_In_Cond(1, BSC_UPDATE.g_indicators(h_i));

1139: IF BSC_UPDATE.g_kpi_mode THEN
1140: IF BSC_UPDATE.g_num_indicators > 0 THEN
1141: h_where_indics := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'indicator');
1142: FOR h_i IN 1..BSC_UPDATE.g_num_indicators LOOP
1143: BSC_APPS.Add_Value_Big_In_Cond(1, BSC_UPDATE.g_indicators(h_i));
1144: END LOOP;
1145: h_sql := h_sql||' AND ('||h_where_indics||')';
1146: END IF;
1147: END IF;

Line 1658: p_user_id => BSC_APPS.apps_user_id,

1654: p_object_type => x_object_types(h_i),
1655: p_lock_type => x_lock_types(h_i),
1656: p_query_time => SYSDATE, --BSC_LOCKS_PUB.Get_System_Time,
1657: p_program_id => -101,
1658: p_user_id => BSC_APPS.apps_user_id,
1659: p_cascade_lock_level => x_cascade_levels(h_i),
1660: x_return_status => h_return_status,
1661: x_msg_count => h_msg_count,
1662: x_msg_data => h_msg_data