DBA Data[Home] [Help]

APPS.OKC_TERMS_UTIL_PVT dependencies on OKC_BUS_VARIABLES_TL

Line 5326: l_variable_name okc_bus_variables_tl.variable_name%TYPE;

5322: l_variable_value VARCHAR2(2500) := NULL;
5323:
5324: l_procedure_name okc_bus_variables_b.procedure_name%TYPE;
5325: l_value_set_id okc_bus_variables_b.value_set_id%TYPE;
5326: l_variable_name okc_bus_variables_tl.variable_name%TYPE;
5327: l_variable_value_id VARCHAR2(2500) := NULL;
5328: l_return_status VARCHAR2(10);
5329: l_msg_count NUMBER;
5330: l_msg_data VARCHAR2(2500);

Line 5351: okc_bus_variables_tl VT

5347: SELECT VB.procedure_name,
5348: VB.value_set_id,
5349: VT.variable_name
5350: FROM okc_bus_variables_b VB,
5351: okc_bus_variables_tl VT
5352: WHERE VB.variable_code = VT.variable_code
5353: AND VT.language = USERENV('LANG')
5354: AND VB.variable_code = p_variable_code
5355: AND VB.variable_source = 'P';