[Home] [Help]
670: l_service_request_rec.summary := p_x_nonroutine_rec.problem_summary;
671:
672: SELECT incident_date, incident_occurred_date, incident_occurred_date
673: INTO l_service_request_rec.request_date, l_service_request_rec.incident_occurred_date, p_x_nonroutine_rec.incident_date
674: FROM cs_incidents_all_b
675: WHERE incident_id = p_x_nonroutine_rec.incident_id;
676:
677: SELECT p_x_nonroutine_rec.inventory_item_id,
678: inv_master_organization_id
1250: p_unit_config_header_id IN NUMBER)
1251: --p_cs_incident_id IN NUMBER)
1252: is
1253: select count(ue.cs_incident_id)
1254: from AHL_UNIT_EFFECTIVITIES_B UE, CS_INCIDENTS_ALL_B CS,
1255: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF,
1256: AHL_MEL_CDL_ATA_SEQUENCES SEQ
1257: where SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID
1258: AND UDF.UNIT_EFFECTIVITY_ID = UE.UNIT_EFFECTIVITY_ID
1279: -- check repair category for time limit.
1280: cursor get_exp_resolution_csr(p_cs_incident_id IN NUMBER)
1281: is
1282: select EXPECTED_RESOLUTION_DATE
1283: from cs_incidents_all_b cs
1284: where cs.incident_id = p_cs_incident_id;
1285:
1286: l_deferral_id NUMBER;
1287: l_deferral_ovn NUMBER;
1738: -- modified for perf fix bug# 7442102
1739: CURSOR nr_mel_cdl_csr(p_mel_cdl_header_id IN NUMBER) IS
1740: SELECT UE.unit_effectivity_id
1741: FROM
1742: AHL_UNIT_EFFECTIVITIES_APP_V UE, CS_INCIDENTS_ALL_B CS,
1743: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF--,
1744: --AHL_MEL_CDL_ATA_SEQUENCES SEQ
1745: WHERE
1746: --SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID
1758: -- query to check existence of open NRs for a pc_node_id.
1759: CURSOR nr_pc_node_csr(p_pc_node_id IN NUMBER) IS
1760: SELECT UE.unit_effectivity_id
1761: FROM
1762: AHL_UNIT_EFFECTIVITIES_APP_V UE, CS_INCIDENTS_ALL_B CS,
1763: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF,
1764: AHL_MEL_CDL_ATA_SEQUENCES SEQ, AHL_MEL_CDL_HEADERS HDR
1765: WHERE
1766: SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID
2838:
2839: CURSOR cs_incident_exists
2840: IS
2841: SELECT incident_number, incident_date
2842: FROM cs_incidents_all_b
2843: WHERE incident_id = p_x_nonroutine_rec.incident_id AND
2844: object_version_number = p_x_nonroutine_rec.incident_object_version_number;
2845:
2846: l_incident_number VARCHAR2(64);
3206: is
3207: select incident_severity_id, customer_id, caller_type,
3208: nvl(incident_occurred_date,incident_date) incident_occurred_date,
3209: expected_resolution_date , object_version_number, incident_number
3210: from cs_incidents_all_b
3211: where incident_id = p_cs_incident_id;
3212:
3213: CURSOR GetWoName(p_ue_id IN NUMBER)
3214: Is
3229: -- get ue details for SR created.
3230: cursor get_ue_detls(p_cs_incident_id IN NUMBER)
3231: is
3232: select cs.object_version_number, ue.unit_effectivity_id
3233: from ahl_unit_effectivities_b UE, cs_incidents_all_b cs
3234: where ue.cs_incident_id = cs.incident_id
3235: and cs.incident_id = p_cs_incident_id;
3236:
3237: -- get default incident type.
3303:
3304: l_return_status VARCHAR2(1);
3305: l_msg_count NUMBER;
3306: l_msg_data VARCHAR2(2000);
3307: l_summary VARCHAR2(2000); --cs_incidents_all_b.summary%TYPE;
3308:
3309: l_wo_name ahl_workorders.workorder_name%TYPE;
3310: l_individual_owner NUMBER;
3311: l_group_owner NUMBER;
3316: l_incident_type_id NUMBER;
3317: l_mr_sr_assoc_tbl AHL_UMP_SR_PVT.SR_MR_Association_Tbl_Type;
3318: l_visit_id NUMBER;
3319: l_new_incident_id NUMBER;
3320: l_new_incident_number cs_incidents_all_b.incident_number%TYPE;
3321: l_new_interaction_id NUMBER;
3322: l_new_workflow_process_id NUMBER;
3323: l_cs_object_version NUMBER;
3324: l_new_ue_id NUMBER;