129: BEGIN
130: IF (g_initialized=false) THEN
131: init;
132: END IF;
133: DELETE FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = USERENV('SESSIONID') AND VARIABLE_ID = x_variable_id;
134: l_cond := x_column_name || ' IN (' ||
135: ' SELECT VALUE_N FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = USERENV(''SESSIONID'')'||
136: ' AND VARIABLE_ID = ' || x_variable_id || ')';
137: return l_cond;
131: init;
132: END IF;
133: DELETE FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = USERENV('SESSIONID') AND VARIABLE_ID = x_variable_id;
134: l_cond := x_column_name || ' IN (' ||
135: ' SELECT VALUE_N FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = USERENV(''SESSIONID'')'||
136: ' AND VARIABLE_ID = ' || x_variable_id || ')';
137: return l_cond;
138: EXCEPTION when others then
139: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.Get_New_Big_In_Cond_Number:'||sqlerrm);
171: BEGIN
172: IF (g_initialized=false) THEN
173: init;
174: END IF;
175: DELETE FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = USERENV('SESSIONID') AND VARIABLE_ID = x_variable_id;
176: cond := 'UPPER('|| x_column_name || ') IN ('||
177: ' SELECT UPPER(VALUE_V) FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = USERENV(''SESSIONID'') AND VARIABLE_ID = '||x_variable_id||')';
178: return cond;
179: EXCEPTION when others then
173: init;
174: END IF;
175: DELETE FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = USERENV('SESSIONID') AND VARIABLE_ID = x_variable_id;
176: cond := 'UPPER('|| x_column_name || ') IN ('||
177: ' SELECT UPPER(VALUE_V) FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = USERENV(''SESSIONID'') AND VARIABLE_ID = '||x_variable_id||')';
178: return cond;
179: EXCEPTION when others then
180: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.Get_New_Big_In_Cond_Varchar2:'||sqlerrm);
181: raise;