[Home] [Help]
745: l_service_request_rec.request_attribute_15 := p_x_nonroutine_rec.request_attribute15;
746:
747: SELECT incident_date, incident_occurred_date, incident_occurred_date
748: INTO l_service_request_rec.request_date, l_service_request_rec.incident_occurred_date, p_x_nonroutine_rec.incident_date
749: FROM cs_incidents_all_b
750: WHERE incident_id = p_x_nonroutine_rec.incident_id;
751:
752: --apattark start for fp bug #9557752
753: /*
1333: p_unit_config_header_id IN NUMBER)
1334: --p_cs_incident_id IN NUMBER)
1335: is
1336: select count(ue.cs_incident_id)
1337: from AHL_UNIT_EFFECTIVITIES_B UE, CS_INCIDENTS_ALL_B CS,
1338: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF,
1339: AHL_MEL_CDL_ATA_SEQUENCES SEQ
1340: where SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID
1341: AND UDF.UNIT_EFFECTIVITY_ID = UE.UNIT_EFFECTIVITY_ID
1362: -- check repair category for time limit.
1363: cursor get_exp_resolution_csr(p_cs_incident_id IN NUMBER)
1364: is
1365: select EXPECTED_RESOLUTION_DATE
1366: from cs_incidents_all_b cs
1367: where cs.incident_id = p_cs_incident_id;
1368:
1369: l_deferral_id NUMBER;
1370: l_deferral_ovn NUMBER;
1826: -- modified for perf fix bug# 7442102
1827: CURSOR nr_mel_cdl_csr(p_mel_cdl_header_id IN NUMBER) IS
1828: SELECT UE.unit_effectivity_id
1829: FROM
1830: AHL_UNIT_EFFECTIVITIES_APP_V UE, CS_INCIDENTS_ALL_B CS,
1831: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF--,
1832: --AHL_MEL_CDL_ATA_SEQUENCES SEQ
1833: WHERE
1834: --SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID
1846: -- query to check existence of open NRs for a pc_node_id.
1847: CURSOR nr_pc_node_csr(p_pc_node_id IN NUMBER) IS
1848: SELECT UE.unit_effectivity_id
1849: FROM
1850: AHL_UNIT_EFFECTIVITIES_APP_V UE, CS_INCIDENTS_ALL_B CS,
1851: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF,
1852: AHL_MEL_CDL_ATA_SEQUENCES SEQ, AHL_MEL_CDL_HEADERS HDR
1853: WHERE
1854: SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID
2932:
2933: CURSOR cs_incident_exists
2934: IS
2935: SELECT incident_number, incident_date
2936: FROM cs_incidents_all_b
2937: WHERE incident_id = p_x_nonroutine_rec.incident_id AND
2938: object_version_number = p_x_nonroutine_rec.incident_object_version_number;
2939:
2940: l_incident_number VARCHAR2(64);
3359: is
3360: select incident_severity_id, customer_id, caller_type,
3361: nvl(incident_occurred_date,incident_date) incident_occurred_date,
3362: expected_resolution_date , object_version_number, incident_number
3363: from cs_incidents_all_b
3364: where incident_id = p_cs_incident_id;
3365:
3366: -- added vst.close_date_time, wdj.scheduled_start_date as required by bug# 7701304
3367: CURSOR GetWoName(p_ue_id IN NUMBER)
3387: -- get ue details for SR created.
3388: cursor get_ue_detls(p_cs_incident_id IN NUMBER)
3389: is
3390: select cs.object_version_number, ue.unit_effectivity_id
3391: from ahl_unit_effectivities_b UE, cs_incidents_all_b cs
3392: where ue.cs_incident_id = cs.incident_id
3393: and cs.incident_id = p_cs_incident_id;
3394:
3395: -- get default incident type.
3477:
3478: l_return_status VARCHAR2(1);
3479: l_msg_count NUMBER;
3480: l_msg_data VARCHAR2(2000);
3481: l_summary VARCHAR2(2000); --cs_incidents_all_b.summary%TYPE;
3482:
3483: l_wo_name ahl_workorders.workorder_name%TYPE;
3484: l_individual_owner NUMBER;
3485: l_group_owner NUMBER;
3490: l_incident_type_id NUMBER;
3491: l_mr_sr_assoc_tbl AHL_UMP_SR_PVT.SR_MR_Association_Tbl_Type;
3492: l_visit_id NUMBER;
3493: l_new_incident_id NUMBER;
3494: l_new_incident_number cs_incidents_all_b.incident_number%TYPE;
3495: l_new_interaction_id NUMBER;
3496: l_new_workflow_process_id NUMBER;
3497: l_cs_object_version NUMBER;
3498: l_new_ue_id NUMBER;