[Home] [Help]
938: WHERE CS_INCIDENT_ID = p_request_id
939: AND (STATUS_CODE IS NULL OR STATUS_CODE NOT IN (G_UMP_DEFERRED_STATUS, G_UMP_EXCEPTION_STATUS));
940:
941: CURSOR get_tasks_for_ue_csr(p_ue_id IN NUMBER) IS
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;
2231: SELECT * FROM AHL_UNIT_EFFECTIVITIES_APP_V
2232: WHERE UNIT_EFFECTIVITY_ID = p_sr_ue_id;
2233:
2234: CURSOR is_ue_assigned_to_visit_csr IS
2235: SELECT 'x' FROM AHL_VISIT_TASKS_B
2236: WHERE UNIT_EFFECTIVITY_ID = p_sr_ue_id;
2237:
2238: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Update_SR_Unit_Effectivity';
2239:
2471: PROCEDURE Handle_Type_Change(
2472: p_sr_ue_id IN NUMBER) IS
2473:
2474: CURSOR get_tasks_for_ue_csr IS
2475: SELECT 'x' from AHL_VISIT_TASKS_B
2476: WHERE UNIT_EFFECTIVITY_ID = p_sr_ue_id;
2477:
2478: CURSOR get_all_ue_and_rel_ids_csr IS
2479: SELECT UE_RELATIONSHIP_ID, RELATED_UE_ID, LEVEL
2807: x_status_changed OUT NOCOPY BOOLEAN,
2808: x_new_ue_status OUT NOCOPY AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE) IS
2809:
2810: CURSOR get_tasks_for_ue_csr IS
2811: SELECT 'x' from AHL_VISIT_TASKS_B
2812: where UNIT_EFFECTIVITY_ID = p_sr_ue_id;
2813:
2814: CURSOR get_rel_count_csr IS
2815: SELECT COUNT(*) FROM AHL_UE_RELATIONSHIPS
2946: VST.visit_number
2947: FROM
2948: AHL_WORKORDERS WO,
2949: WIP_DISCRETE_JOBS WIPJ,
2950: AHL_VISIT_TASKS_B VTSK,
2951: AHL_VISITS_B VST,
2952: AHL_UNIT_EFFECTIVITIES_B UE
2953: WHERE
2954: WO.status_code not in (4,12,7,5) AND -- Completed/Closed/Cancelled/Completed_No_Charge