DBA Data[Home] [Help]

APPS.OKC_TERMS_UTIL_PVT dependencies on OKC_BUS_VARIABLES_TL

Line 5375: l_variable_name okc_bus_variables_tl.variable_name%TYPE;

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);

Line 5400: okc_bus_variables_tl VT

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';