APPS.BSC_SIMULATION_VIEW_PVT dependencies on BSC_SYS_IMAGES_MAP_TL

Line 136: x_kpi_metadata_tables(x_Table_Number).table_name := 'BSC_SYS_IMAGES_MAP_TL';

132: BEGIN
133: x_Table_Number := 0;
134:
135: x_Table_Number := x_Table_Number + 1;
136: x_kpi_metadata_tables(x_Table_Number).table_name := 'BSC_SYS_IMAGES_MAP_TL';
137: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_SYSTEM_TABLE ;
138: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_SOURCE_CODE;
139: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
140: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;

Line 474: l_next_image_id BSC_SYS_IMAGES_MAP_TL.image_id%TYPE;

470: h_condition VARCHAR2(1000);
471: h_sql VARCHAR2(32000);
472: x_arr_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
473: x_num_columns NUMBER;
474: l_next_image_id BSC_SYS_IMAGES_MAP_TL.image_id%TYPE;
475: l_image_id BSC_SYS_IMAGES_MAP_TL.image_id%TYPE;
476:
477:
478: BEGIN

Line 475: l_image_id BSC_SYS_IMAGES_MAP_TL.image_id%TYPE;

471: h_sql VARCHAR2(32000);
472: x_arr_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
473: x_num_columns NUMBER;
474: l_next_image_id BSC_SYS_IMAGES_MAP_TL.image_id%TYPE;
475: l_image_id BSC_SYS_IMAGES_MAP_TL.image_id%TYPE;
476:
477:
478: BEGIN
479:

Line 525: IF(p_table_name='BSC_SYS_IMAGES_MAP_TL' AND UPPER(x_arr_columns(i)) = 'IMAGE_ID') THEN

521: IF i <> 1 THEN
522: h_sql:= h_sql || ',';
523: END IF;
524:
525: IF(p_table_name='BSC_SYS_IMAGES_MAP_TL' AND UPPER(x_arr_columns(i)) = 'IMAGE_ID') THEN
526:
527: SELECT bsc_sys_image_id_s.nextval
528: INTO l_next_image_id
529: FROM dual;

Line 535: FROM BSC_SYS_IMAGES_MAP_TL

531: ELSIF(p_table_name='BSC_SYS_IMAGES' AND UPPER(x_arr_columns(i)) = 'IMAGE_ID' )THEN
532:
533: SELECT DISTINCT image_id
534: INTO l_image_id
535: FROM BSC_SYS_IMAGES_MAP_TL
536: WHERE SOURCE_TYPE =2
537: AND SOURCE_CODE =p_Src_kpi;
538:
539: h_condition := p_table_column ||' = ' || l_image_id;

Line 543: FROM BSC_SYS_IMAGES_MAP_TL

539: h_condition := p_table_column ||' = ' || l_image_id;
540:
541: SELECT distinct image_id
542: INTO l_image_id
543: FROM BSC_SYS_IMAGES_MAP_TL
544: WHERE SOURCE_TYPE =2
545: AND SOURCE_CODE =p_Trg_kpi;
546:
547: h_sql:= h_sql || l_image_id || ' AS ' || x_arr_columns(i);