DBA Data[Home] [Help]

APPS.OKC_XPRT_UTIL_PVT dependencies on OKC_BUS_VARIABLES_V

Line 4841: FROM okc_bus_variables_v

4837: p_object_code IN VARCHAR2)
4838: RETURN VARCHAR2 IS
4839: CURSOR c1 IS
4840: SELECT variable_name
4841: FROM okc_bus_variables_v
4842: WHERE variable_code=p_object_code;
4843:
4844: CURSOR c2 IS
4845: SELECT question_name

Line 4915: FROM okc_bus_variables_v

4911: AND question_type= decode(p_object_value_type,'CONSTANT','C','Q');
4912:
4913: CURSOR c3 IS
4914: SELECT variable_name
4915: FROM okc_bus_variables_v
4916: WHERE variable_code=p_object_value_code;
4917:
4918:
4919: /*CURSOR c2 IS

Line 5604: FROM okc_bus_variables_v

5600: AND question_type= decode(p_object_value_type,'CONSTANT','C','Q');
5601:
5602: CURSOR c3 IS
5603: SELECT description
5604: FROM okc_bus_variables_v
5605: WHERE variable_code=p_object_value_code;
5606:
5607:
5608: l_value VARCHAR2(1000) := null;

Line 6213: FROM OKC_BUS_VARIABLES_V

6209: RETURN VARCHAR2 IS
6210:
6211: Cursor c1 is
6212: SELECT value_set_id
6213: FROM OKC_BUS_VARIABLES_V
6214: WHERE variable_code = p_object_code
6215: AND variable_type = 'U';
6216:
6217: l_value_set_id NUMBER ;