DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_PVT dependencies on CS_INCIDENT_STATUSES_VL

Line 1906: FROM cs_incident_statuses_vl

1902: stops stamping of incident_resolved_date and inc_responded_by_date to audit rec
1903: smisra 12/31/2003
1904: SELECT responded_flag,resolved_flag
1905: INTO l_responded_flag,l_resolved_flag
1906: FROM cs_incident_statuses_vl
1907: WHERE incident_status_id=l_service_request_rec.status_id ;
1908:
1909: IF ((l_responded_flag='Y') OR (l_resolved_flag ='Y')) THEN
1910: IF((l_responded_flag='Y' ) AND (l_service_request_rec.inc_responded_by_date is NULL OR

Line 11269: FROM cs_incident_statuses_vl

11265: -- For bug 3512501 - added begin..exception
11266: begin
11267: SELECT responded_flag,resolved_flag
11268: INTO l_responded_flag,l_resolved_flag
11269: FROM cs_incident_statuses_vl
11270: WHERE incident_status_id=l_service_request_rec.status_id ;
11271: exception
11272: when no_data_found then
11273: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg( p_token_an => l_api_name_full,