DBA Data[Home] [Help]

APPS.OKC_XPRT_UTIL_PVT dependencies on OKC_BUS_VARIABLES_V

Line 5039: FROM okc_bus_variables_v

5035: p_object_code IN VARCHAR2)
5036: RETURN VARCHAR2 IS
5037: CURSOR c1 IS
5038: SELECT variable_name
5039: FROM okc_bus_variables_v
5040: WHERE variable_code=p_object_code;
5041:
5042: CURSOR c2 IS
5043: SELECT question_name

Line 5113: FROM okc_bus_variables_v

5109: AND question_type= decode(p_object_value_type,'CONSTANT','C','Q');
5110:
5111: CURSOR c3 IS
5112: SELECT variable_name
5113: FROM okc_bus_variables_v
5114: WHERE variable_code=p_object_value_code;
5115:
5116:
5117: /*CURSOR c2 IS

Line 5802: FROM okc_bus_variables_v

5798: AND question_type= decode(p_object_value_type,'CONSTANT','C','Q');
5799:
5800: CURSOR c3 IS
5801: SELECT description
5802: FROM okc_bus_variables_v
5803: WHERE variable_code=p_object_value_code;
5804:
5805:
5806: l_value VARCHAR2(1000) := null;

Line 6411: FROM OKC_BUS_VARIABLES_V

6407: RETURN VARCHAR2 IS
6408:
6409: Cursor c1 is
6410: SELECT value_set_id
6411: FROM OKC_BUS_VARIABLES_V
6412: WHERE variable_code = p_object_code
6413: AND variable_type = 'U';
6414:
6415: l_value_set_id NUMBER ;