APPS.AHL_UMP_SR_PVT dependencies on CS_INCIDENTS

Line 216: FROM cs_incidents_all_b

212: -- Validate Incident ID
213: CURSOR validate_incident_id ( c_request_id in NUMBER )
214: IS
215: SELECT incident_id
216: FROM cs_incidents_all_b
217: WHERE incident_id = c_request_id;
218:
219: -- Validate Item Instance
220: CURSOR validate_instance ( c_instance_id in NUMBER)

Line 923: FROM CS_INCIDENTS_V

919: CURSOR get_request_dtls_csr(p_request_id IN NUMBER,
920: p_request_number IN VARCHAR2,
921: p_object_version_number IN NUMBER) IS
922: /*SELECT incident_id, incident_status_id, closed_flag, customer_product_id, expected_resolution_date
923: FROM CS_INCIDENTS_V
924: WHERE INCIDENT_ID like DECODE(p_request_id, null, '%', p_request_id)
925: AND INCIDENT_NUMBER like NVL(p_request_number, '%')
926: AND OBJECT_VERSION_NUMBER = p_object_version_number;*/
927:

Line 929: FROM CS_INCIDENT_STATUSES_B STATUS,CS_INCIDENTS_ALL_B INC

925: AND INCIDENT_NUMBER like NVL(p_request_number, '%')
926: AND OBJECT_VERSION_NUMBER = p_object_version_number;*/
927:
928: SELECT INC.incident_id, INC.incident_status_id, NVL(STATUS.CLOSE_FLAG, 'N') closed_flag, INC.customer_product_id, INC.expected_resolution_date
929: FROM CS_INCIDENT_STATUSES_B STATUS,CS_INCIDENTS_ALL_B INC
930: WHERE INC.INCIDENT_STATUS_ID = STATUS.INCIDENT_STATUS_ID
931: AND INC.INCIDENT_ID like DECODE(p_request_id, null, '%', p_request_id)
932: AND INC.INCIDENT_NUMBER like NVL(p_request_number, '%')
933: AND INC.OBJECT_VERSION_NUMBER = p_object_version_number;

Line 946: l_closed_flag CS_INCIDENTS_V.CLOSED_FLAG%TYPE := NULL;

942: SELECT 'x' from AHL_VISIT_TASKS_B
943: where UNIT_EFFECTIVITY_ID = p_ue_id;
944:
945: l_sr_status_id NUMBER := NULL;
946: l_closed_flag CS_INCIDENTS_V.CLOSED_FLAG%TYPE := NULL;
947: l_dummy VARCHAR2(1);
948:
949: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Validate_Associated_Request';
950:

Line 2399: SELECT 'x' FROM CS_INCIDENTS

2395: x_sr_ue_id OUT NOCOPY NUMBER,
2396: x_sr_ue_ovn OUT NOCOPY NUMBER) IS
2397:
2398: CURSOR check_request_exists_csr IS
2399: SELECT 'x' FROM CS_INCIDENTS
2400: WHERE INCIDENT_ID = CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id;
2401:
2402: CURSOR get_ue_dtls_csr IS
2403: SELECT UNIT_EFFECTIVITY_ID, OBJECT_VERSION_NUMBER

Line 2978: CS_INCIDENTS_ALL CSIA,

2974: SELECT
2975: CSIA.summary,
2976: CSIT.name -- incident type name.
2977: FROM
2978: CS_INCIDENTS_ALL CSIA,
2979: CS_INCIDENT_TYPES_VL CSIT,
2980: AHL_UNIT_EFFECTIVITIES_B UE
2981: WHERE
2982: UE.unit_effectivity_id = p_sr_ue_id AND