DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_UTIL dependencies on CS_INCIDENT_SEVERITIES_VL

Line 569: FROM cs_incident_severities_vl

565: x_return_status := FND_API.G_RET_STS_SUCCESS;
566:
567: BEGIN
568: SELECT incident_severity_id INTO p_severity_id
569: FROM cs_incident_severities_vl
570: WHERE incident_subtype = p_subtype
571: AND UPPER(name) = UPPER(p_severity_name)
572: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
573: AND TRUNC(NVL(end_date_active, SYSDATE))

Line 581: p_table_name => 'CS_INCIDENT_SEVERITIES_VL',

577: x_return_status := FND_API.G_RET_STS_ERROR;
578: Add_Invalid_Argument_Msg( p_token_an => l_api_name_full,
579: p_token_v => p_severity_name,
580: p_token_p => p_parameter_name,
581: p_table_name => 'CS_INCIDENT_SEVERITIES_VL',
582: p_column_name => 'NAME');
583: WHEN OTHERS THEN
584: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
585: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);