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