APPS.BSC_SIMULATION_VIEW_PVT dependencies on BSC_UPDATE_UTIL

Line 327: x_arr_columns BSC_UPDATE_UTIL.t_array_of_varchar2;

323: h_colum VARCHAR2(100);
324: h_key_name VARCHAR2(30);
325: h_condition VARCHAR2(1000);
326: h_sql VARCHAR2(32000);
327: x_arr_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
328: x_num_columns NUMBER;
329: l_new_region_code AK_REGIONS.region_code%TYPE;
330: l_region_code AK_REGIONS.region_code%TYPE;
331: l_count NUMBER;

Line 439: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);

435: h_sql:= h_sql || ' FROM ' || p_table_name || '@'||p_DbLink_Name;
436: END IF;
437: h_sql:= h_sql || ' WHERE ' || h_condition;
438:
439: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
440: END IF;
441:
442: IF(p_table_name = 'FND_FORM_FUNCTIONS')THEN
443: UPDATE FND_FORM_FUNCTIONS

Line 472: x_arr_columns BSC_UPDATE_UTIL.t_array_of_varchar2;

468: h_colum VARCHAR2(100);
469: h_key_name VARCHAR2(30);
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:

Line 559: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);

555: END LOOP;
556: h_sql:= h_sql || ' FROM ' || p_table_name;
557: h_sql:= h_sql || ' WHERE ' || h_condition;
558:
559: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
560:
561: END IF;
562: END Copy_Record_Table;
563:

Line 1625: l_arr_columns BSC_UPDATE_UTIL.t_array_of_varchar2;

1621: l_colum VARCHAR2(100);
1622: l_key_name VARCHAR2(30);
1623: l_table_name all_tables.table_name%TYPE;
1624: l_condition VARCHAR2(1000);
1625: l_arr_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
1626: l_num_columns NUMBER;
1627: i NUMBER;
1628: l_Dim_Group_Id NUMBER;
1629: l_sql VARCHAR2(32000);