5371: l_variable_value VARCHAR2(2500) := NULL;
5372:
5373: l_procedure_name okc_bus_variables_b.procedure_name%TYPE;
5374: l_value_set_id okc_bus_variables_b.value_set_id%TYPE;
5375: l_variable_name okc_bus_variables_tl.variable_name%TYPE;
5376: l_variable_value_id VARCHAR2(2500) := NULL;
5377: l_return_status VARCHAR2(10);
5378: l_msg_count NUMBER;
5379: l_msg_data VARCHAR2(2500);
5396: SELECT VB.procedure_name,
5397: VB.value_set_id,
5398: VT.variable_name
5399: FROM okc_bus_variables_b VB,
5400: okc_bus_variables_tl VT
5401: WHERE VB.variable_code = VT.variable_code
5402: AND VT.language = USERENV('LANG')
5403: AND VB.variable_code = p_variable_code
5404: AND VB.variable_source = 'P';