2286: select select_id
2287: , select_name
2288: , from_table
2289: , where_clause
2290: from jtf_objects_vl
2291: where object_code = p_object_type_code;
2292: l_rec c_ref%rowtype;
2293: -- max data from jtf_objects_vl can be about 2600
2294: l_stmt varchar2(3000);
2289: , where_clause
2290: from jtf_objects_vl
2291: where object_code = p_object_type_code;
2292: l_rec c_ref%rowtype;
2293: -- max data from jtf_objects_vl can be about 2600
2294: l_stmt varchar2(3000);
2295: -- highest max col length found in dom1151 = 421
2296: l_name varchar2(500) := null;
2297: BEGIN
2317: FUNCTION get_object_Type_meaning(p_object_type_code varchar2) return varchar2
2318: IS
2319: CURSOR csp_object_type is
2320: select Name
2321: from JTF_OBJECTS_VL
2322: where OBJECT_CODE =p_object_type_code;
2323:
2324: l_object_type_name varchar2(200);
2325: