APPS.CS_SERVICEREQUEST_UTIL dependencies on CS_INCIDENT_STATUSES_VL

Line 525: FROM cs_incident_statuses_vl

521: x_return_status := FND_API.G_RET_STS_SUCCESS;
522:
523: BEGIN
524: SELECT incident_status_id INTO p_status_id
525: FROM cs_incident_statuses_vl
526: WHERE incident_subtype = p_subtype
527: AND UPPER(name) = UPPER(p_status_name)
528: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
529: AND TRUNC(NVL(end_date_active, SYSDATE))

Line 537: p_table_name => 'CS_INCIDENT_STATUSES_VL',

533: x_return_status := FND_API.G_RET_STS_ERROR;
534: Add_Invalid_Argument_Msg( p_token_an => l_api_name_full,
535: p_token_v => p_status_name,
536: p_token_p => p_parameter_name,
537: p_table_name => 'CS_INCIDENT_STATUSES_VL',
538: p_column_name => 'NAME');
539: WHEN OTHERS THEN
540: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
541: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);

Line 9778: FROM cs_incident_statuses_vl

9774: , resolved_flag
9775: INTO
9776: l_new_responded_flag
9777: , l_new_resolved_flag
9778: FROM cs_incident_statuses_vl
9779: WHERE incident_status_id=p_incident_status_id ;
9780:
9781: SELECT
9782: responded_flag

Line 9787: FROM cs_incident_statuses_vl

9783: , resolved_flag
9784: INTO
9785: l_old_responded_flag
9786: , l_old_resolved_flag
9787: FROM cs_incident_statuses_vl
9788: WHERE incident_status_id=p_old_incident_status_id ;
9789:
9790: IF((l_old_responded_flag <>'Y' OR l_old_responded_flag is NULL) AND
9791: (l_new_responded_flag='Y'))