APPS.BSC_UPDATE dependencies on BSC_DB_VALIDATION

Line 2971: -- Fix bug#3813853. Delete invalid codes for this input table from bsc_db_validation

2967: FOR h_i IN 1 .. x_num_input_tables LOOP
2968: h_input_table := x_input_tables(h_i);
2969:
2970: -- Fix bug#4341554. move this delete here, we need to commit this deletion
2971: -- Fix bug#3813853. Delete invalid codes for this input table from bsc_db_validation
2972: DELETE FROM bsc_db_validation
2973: WHERE input_table_name = h_input_table;
2974: commit;
2975:

Line 2972: DELETE FROM bsc_db_validation

2968: h_input_table := x_input_tables(h_i);
2969:
2970: -- Fix bug#4341554. move this delete here, we need to commit this deletion
2971: -- Fix bug#3813853. Delete invalid codes for this input table from bsc_db_validation
2972: DELETE FROM bsc_db_validation
2973: WHERE input_table_name = h_input_table;
2974: commit;
2975:
2976: --LOCKING: need to know the base table name here

Line 6115: ' FROM bsc_db_validation'||

6111:
6112: /*
6113: c_invalid_codes t_cursor; -- g_process_name, PC_LOADER_PROCESS, 0, 2
6114: c_invalid_codes_sql VARCHAR2(2000) := 'SELECT input_table_name, column_name, invalid_code'||
6115: ' FROM bsc_db_validation'||
6116: ' WHERE input_table_name IN ('||
6117: ' SELECT table_name'||
6118: ' FROM bsc_db_tables'||
6119: ' WHERE table_type = DECODE(:1, :2, :3, :4))'||

Line 6125: FROM bsc_db_validation

6121: */
6122: --Fix bug#4581846: show invalid codes for input tables involved in this process only
6123: CURSOR c_invalid_codes (p_process_id NUMBER) IS
6124: SELECT input_table_name, column_name, invalid_code
6125: FROM bsc_db_validation
6126: WHERE input_table_name IN (
6127: SELECT input_table_name
6128: FROM bsc_db_loader_control
6129: WHERE process_id = p_process_id