APPS.CS_SERVICEREQUEST_PVT dependencies on JTF_OBJECTS_VL

Line 1983: --select the l_title from jtf_objects_vl

1979:
1980: -- UWQ pop up in service request
1981: -- while creating an SR from Teleservice
1982: l_imp_level := Get_Importance_Level(p_service_request_rec.severity_id);
1983: --select the l_title from jtf_objects_vl
1984: l_title := Get_Title('SR');
1985: -- Assign the value of request_id to the local variable that will be passed to the
1986: -- IEU procedure .
1987: IF l_request_id IS NULL THEN

Line 5243: --select the l_title from jtf_objects_vl

5239: l_imp_level := Get_Importance_Level(l_service_request_rec.severity_id);
5240: l_imp_level_old := Get_Old_Importance_level(p_request_id);
5241: l_old_owner_id := Get_Owner_id(p_request_id);
5242:
5243: --select the l_title from jtf_objects_vl
5244: l_title := Get_Title('SR');
5245:
5246: IF (l_service_request_rec.last_update_channel in ('PHONE', 'AGENT') AND
5247: (l_imp_level_old <> 1 OR l_imp_level_old = 1) AND

Line 20801: FROM jtf_objects_vl

20797: FUNCTION Get_Title(P_Object_Code IN VARCHAR2)
20798: RETURN VARCHAR2 IS
20799: CURSOR c_title_csr IS
20800: SELECT description
20801: FROM jtf_objects_vl
20802: WHERE object_code=P_Object_Code;
20803: --Fixed bug#2802393, changed length from 30 to 80
20804: l_title VARCHAR2(80);
20805: BEGIN