APPS.AHL_UMP_SR_PVT dependencies on CS_INCIDENTS

Line 224: FROM cs_incidents_all_b

220: -- Validate Incident ID
221: CURSOR validate_incident_id ( c_request_id in NUMBER )
222: IS
223: SELECT incident_id
224: FROM cs_incidents_all_b
225: WHERE incident_id = c_request_id;
226:
227: -- Validate Item Instance
228: CURSOR validate_instance ( c_instance_id in NUMBER)

Line 236: SELECT incident_occurred_date FROM cs_incidents

232: WHERE instance_id = c_instance_id;
233:
234: -- bachandr Bug # 13916897
235: CURSOR c_get_incident_occ_date(c_incident_id IN NUMBER) IS
236: SELECT incident_occurred_date FROM cs_incidents
237: WHERE incident_id = c_incident_id;
238:
239: l_occurred_date DATE;
240:

Line 957: FROM CS_INCIDENTS_V

953: CURSOR get_request_dtls_csr(p_request_id IN NUMBER,
954: p_request_number IN VARCHAR2,
955: p_object_version_number IN NUMBER) IS
956: /*SELECT incident_id, incident_status_id, closed_flag, customer_product_id, expected_resolution_date
957: FROM CS_INCIDENTS_V
958: WHERE INCIDENT_ID like DECODE(p_request_id, null, '%', p_request_id)
959: AND INCIDENT_NUMBER like NVL(p_request_number, '%')
960: AND OBJECT_VERSION_NUMBER = p_object_version_number;*/
961:

Line 963: FROM CS_INCIDENT_STATUSES_B STATUS,CS_INCIDENTS_ALL_B INC

959: AND INCIDENT_NUMBER like NVL(p_request_number, '%')
960: AND OBJECT_VERSION_NUMBER = p_object_version_number;*/
961:
962: SELECT INC.incident_id, INC.incident_status_id, NVL(STATUS.CLOSE_FLAG, 'N') closed_flag, INC.customer_product_id, INC.expected_resolution_date
963: FROM CS_INCIDENT_STATUSES_B STATUS,CS_INCIDENTS_ALL_B INC
964: WHERE INC.INCIDENT_STATUS_ID = STATUS.INCIDENT_STATUS_ID
965: AND INC.INCIDENT_ID like DECODE(p_request_id, null, '%', p_request_id)
966: AND INC.INCIDENT_NUMBER like NVL(p_request_number, '%')
967: AND INC.OBJECT_VERSION_NUMBER = p_object_version_number;

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

976: SELECT 'x' from AHL_VISIT_TASKS_B
977: where UNIT_EFFECTIVITY_ID = p_ue_id;
978:
979: l_sr_status_id NUMBER := NULL;
980: l_closed_flag CS_INCIDENTS_V.CLOSED_FLAG%TYPE := NULL;
981: l_dummy VARCHAR2(1);
982:
983: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Validate_Associated_Request';
984:

Line 2356: SELECT incident_occurred_date FROM cs_incidents

2352: WHERE UNIT_EFFECTIVITY_ID = p_sr_ue_id;
2353:
2354: -- bachandr Bug # 13916897
2355: CURSOR c_get_incident_occ_date(c_incident_id IN NUMBER) IS
2356: SELECT incident_occurred_date FROM cs_incidents
2357: WHERE incident_id = c_incident_id;
2358:
2359: l_occurred_date DATE;
2360: -- bachandr Bug # 13916897

Line 2540: SELECT 'x' FROM CS_INCIDENTS

2536: x_sr_ue_ovn OUT NOCOPY NUMBER,
2537: x_defer_from_ue_id OUT NOCOPY NUMBER) IS
2538:
2539: CURSOR check_request_exists_csr IS
2540: SELECT 'x' FROM CS_INCIDENTS
2541: WHERE INCIDENT_ID = CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id;
2542:
2543: CURSOR get_ue_dtls_csr IS
2544: SELECT UNIT_EFFECTIVITY_ID, OBJECT_VERSION_NUMBER, DEFER_FROM_UE_ID

Line 3170: CS_INCIDENTS_ALL CSIA,

3166: SELECT
3167: CSIA.summary,
3168: CSIT.name -- incident type name.
3169: FROM
3170: CS_INCIDENTS_ALL CSIA,
3171: CS_INCIDENT_TYPES_VL CSIT,
3172: AHL_UNIT_EFFECTIVITIES_B UE
3173: WHERE
3174: UE.unit_effectivity_id = p_sr_ue_id AND