APPS.CS_SERVICEREQUEST_UTIL dependencies on CS_INCIDENT_TYPES_VL

Line 423: FROM cs_incident_types_vl

419: -- it is possible that multiple rows will be returned and hence TOO_MANY_ROWS
420: -- exception must be handled
421: BEGIN
422: SELECT incident_type_id INTO p_type_id
423: FROM cs_incident_types_vl
424: WHERE incident_subtype = p_subtype
425: AND UPPER(name) = UPPER(p_type_name);
426:
427: EXCEPTION

Line 433: p_table_name => 'CS_INCIDENT_TYPES_VL',

429: x_return_status := FND_API.G_RET_STS_ERROR;
430: Add_Invalid_Argument_Msg( p_token_an => l_api_name_full,
431: p_token_v => p_type_name,
432: p_token_p => p_parameter_name,
433: p_table_name => 'CS_INCIDENT_TYPES_VL',
434: p_column_name => 'NAME' );
435: WHEN TOO_MANY_ROWS THEN
436: x_return_status := FND_API.G_RET_STS_ERROR;
437: Add_Duplicate_Value_Msg( p_token_an => l_api_name_full,

Line 439: p_table_name => 'CS_INCIDENT_TYPES_VL',

435: WHEN TOO_MANY_ROWS THEN
436: x_return_status := FND_API.G_RET_STS_ERROR;
437: Add_Duplicate_Value_Msg( p_token_an => l_api_name_full,
438: p_token_p => p_parameter_name,
439: p_table_name => 'CS_INCIDENT_TYPES_VL',
440: p_column_name => 'NAME' );
441: WHEN OTHERS THEN
442: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
443: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);

Line 453: FROM cs_incident_types_vl

449: -- it is not possible that multiple rows will be returned and hence TOO_MANY_ROWS
450: -- exception need not be handled
451: BEGIN
452: SELECT incident_type_id INTO p_type_id
453: FROM cs_incident_types_vl
454: WHERE incident_subtype = p_subtype
455: AND UPPER(name) = UPPER(p_type_name)
456: AND ((parent_incident_type_id = p_parent_type_id)
457: OR (parent_incident_type_id IS NULL

Line 466: p_table_name => 'CS_INCIDENT_TYPES_VL',

462: x_return_status := FND_API.G_RET_STS_ERROR;
463: Add_Invalid_Argument_Msg( p_token_an => l_api_name_full,
464: p_token_v => p_type_name,
465: p_token_p => p_parameter_name,
466: p_table_name => 'CS_INCIDENT_TYPES_VL',
467: p_column_name => 'NAME' );
468: WHEN OTHERS THEN
469: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
470: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);

Line 479: FROM cs_incident_types_vl

475: ELSE
476: -- if this is a SR type
477: BEGIN
478: SELECT incident_type_id INTO p_type_id
479: FROM cs_incident_types_vl
480: WHERE incident_subtype = p_subtype
481: AND UPPER(name) = UPPER(p_type_name)
482: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
483: AND TRUNC(NVL(end_date_active, SYSDATE))

Line 491: p_table_name => 'CS_INCIDENT_TYPES_VL',

487: x_return_status := FND_API.G_RET_STS_ERROR;
488: Add_Invalid_Argument_Msg( p_token_an => l_api_name_full,
489: p_token_v => p_type_name,
490: p_token_p => p_parameter_name,
491: p_table_name => 'CS_INCIDENT_TYPES_VL',
492: p_column_name => 'NAME' );
493: WHEN OTHERS THEN
494: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
495: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);

Line 1105: from cs_incident_types_vl_sec

1101: -- and trunc(nvl(end_date_active, sysdate));
1102:
1103: cursor val_type_secure is
1104: select cmro_flag, maintenance_flag ,start_date_active,end_date_active
1105: from cs_incident_types_vl_sec
1106: where incident_type_id = p_type_id
1107: and incident_subtype = p_subtype;
1108: -- and trunc(sysdate) between trunc(nvl(start_date_active, sysdate))
1109: -- and trunc(nvl(end_date_active, sysdate));