eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CUG_GENERIC_WF_PKG dependencies on CS_INCIDENTS_ALL_VL

Line 39: FROM CS_INCIDENTS_ALL_VL

35: -- Capturing of incident address done in SR Tab
36: /*
37: CURSOR l_ServiceRequest_csr IS
38: SELECT INSTALL_SITE_USE_ID
39: FROM CS_INCIDENTS_ALL_VL
40: WHERE INCIDENT_ID = l_request_id;
41:
42: CURSOR l_IncidentAddress_csr IS
43: SELECT ADDRESS1, ADDRESS2, CITY, STATE, COUNTRY, POSTAL_CODE

Line 286: CS_INCIDENTS_ALL_VL WHERE INCIDENT_ID = l_request_id;

282: itemkey => itemkey,
283: aname => 'REQUEST_ID');
284:
285: select INCIDENT_TYPE_ID into l_incident_type_id FROM
286: CS_INCIDENTS_ALL_VL WHERE INCIDENT_ID = l_request_id;
287:
288: OPEN l_GetResourceID_csr;
289: FETCH l_GetResourceID_csr INTO l_GetResourceID_rec;
290:

Line 492: select INCIDENT_TYPE_ID into l_request_type_id from CS_INCIDENTS_ALL_VL

488: l_request_id := WF_Engine.GetItemAttrNumber(itemtype => itemtype,
489: itemkey => itemkey,
490: aname => 'REQUEST_ID');
491:
492: select INCIDENT_TYPE_ID into l_request_type_id from CS_INCIDENTS_ALL_VL
493: WHERE INCIDENT_ID = l_request_id;
494:
495: OPEN c_CheckIfDupCheckOn_csr;
496: FETCH c_CheckIfDupCheckOn_csr into l_duplicate_check_flag;

Line 571: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER

567: HZ_LOCATIONS where LOCATION_ID = l_install_at_site_id;
568: l_IncidentAddress_rec l_IncidentAddress_csr%ROWTYPE;
569:
570: CURSOR l_IncidentId_csr IS
571: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER
572: FROM CS_INCIDENTS_ALL_VL, HZ_LOCATIONS
573: WHERE HZ_LOCATIONS.LOCATION_ID = CS_INCIDENTS_ALL_VL.INSTALL_SITE_USE_ID AND
574: HZ_LOCATIONS.ADDRESS1 = l_IncidentAddress_rec.Address1 AND
575: nvl(HZ_LOCATIONS.ADDRESS2, 'Not Filled') = nvl(l_IncidentAddress_rec.Address2, 'Not Filled') AND

Line 572: FROM CS_INCIDENTS_ALL_VL, HZ_LOCATIONS

568: l_IncidentAddress_rec l_IncidentAddress_csr%ROWTYPE;
569:
570: CURSOR l_IncidentId_csr IS
571: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER
572: FROM CS_INCIDENTS_ALL_VL, HZ_LOCATIONS
573: WHERE HZ_LOCATIONS.LOCATION_ID = CS_INCIDENTS_ALL_VL.INSTALL_SITE_USE_ID AND
574: HZ_LOCATIONS.ADDRESS1 = l_IncidentAddress_rec.Address1 AND
575: nvl(HZ_LOCATIONS.ADDRESS2, 'Not Filled') = nvl(l_IncidentAddress_rec.Address2, 'Not Filled') AND
576: nvl(HZ_LOCATIONS.CITY, 'Not Filled') = nvl(l_IncidentAddress_rec.City, 'Not Filled') AND

Line 573: WHERE HZ_LOCATIONS.LOCATION_ID = CS_INCIDENTS_ALL_VL.INSTALL_SITE_USE_ID AND

569:
570: CURSOR l_IncidentId_csr IS
571: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER
572: FROM CS_INCIDENTS_ALL_VL, HZ_LOCATIONS
573: WHERE HZ_LOCATIONS.LOCATION_ID = CS_INCIDENTS_ALL_VL.INSTALL_SITE_USE_ID AND
574: HZ_LOCATIONS.ADDRESS1 = l_IncidentAddress_rec.Address1 AND
575: nvl(HZ_LOCATIONS.ADDRESS2, 'Not Filled') = nvl(l_IncidentAddress_rec.Address2, 'Not Filled') AND
576: nvl(HZ_LOCATIONS.CITY, 'Not Filled') = nvl(l_IncidentAddress_rec.City, 'Not Filled') AND
577: nvl(HZ_LOCATIONS.STATE, 'Not Filled') = nvl(l_IncidentAddress_rec.State, 'Not Filled') AND

Line 580: CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND

576: nvl(HZ_LOCATIONS.CITY, 'Not Filled') = nvl(l_IncidentAddress_rec.City, 'Not Filled') AND
577: nvl(HZ_LOCATIONS.STATE, 'Not Filled') = nvl(l_IncidentAddress_rec.State, 'Not Filled') AND
578: nvl(HZ_LOCATIONS.POSTAL_CODE, 'Not Filled') = nvl(l_IncidentAddress_rec.Postal_Code, 'Not Filled') AND
579: -- HZ_LOCATIONS.COUNTRY = l_IncidentAddress_rec.Country AND
580: CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND
581: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND
582: CS_INCIDENTS_ALL_VL.INCIDENT_ID <> l_request_id;
583: l_IncidentId_rec l_IncidentId_csr%ROWTYPE;
584: */

Line 581: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND

577: nvl(HZ_LOCATIONS.STATE, 'Not Filled') = nvl(l_IncidentAddress_rec.State, 'Not Filled') AND
578: nvl(HZ_LOCATIONS.POSTAL_CODE, 'Not Filled') = nvl(l_IncidentAddress_rec.Postal_Code, 'Not Filled') AND
579: -- HZ_LOCATIONS.COUNTRY = l_IncidentAddress_rec.Country AND
580: CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND
581: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND
582: CS_INCIDENTS_ALL_VL.INCIDENT_ID <> l_request_id;
583: l_IncidentId_rec l_IncidentId_csr%ROWTYPE;
584: */
585:

Line 582: CS_INCIDENTS_ALL_VL.INCIDENT_ID <> l_request_id;

578: nvl(HZ_LOCATIONS.POSTAL_CODE, 'Not Filled') = nvl(l_IncidentAddress_rec.Postal_Code, 'Not Filled') AND
579: -- HZ_LOCATIONS.COUNTRY = l_IncidentAddress_rec.Country AND
580: CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND
581: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND
582: CS_INCIDENTS_ALL_VL.INCIDENT_ID <> l_request_id;
583: l_IncidentId_rec l_IncidentId_csr%ROWTYPE;
584: */
585:
586: CURSOR l_ServiceRequest_csr IS

Line 600: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER

596: WHERE location_id = l_incident_location_id;
597: l_IncidentAddress_rec l_IncidentAddress_csr%ROWTYPE;
598:
599: CURSOR l_IncidentId_csr IS
600: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER
601: FROM CS_INCIDENTS_ALL_VL, HZ_LOCATIONS
602: WHERE HZ_LOCATIONS.LOCATION_ID = CS_INCIDENTS_ALL_VL.INCIDENT_LOCATION_ID AND
603: nvl(HZ_LOCATIONS.ADDRESS1, 'Not Filled') = nvl(l_incident_address, 'Not Filled') AND
604: nvl(HZ_LOCATIONS.CITY, 'Not Filled') = nvl(l_incident_city, 'Not Filled') AND

Line 601: FROM CS_INCIDENTS_ALL_VL, HZ_LOCATIONS

597: l_IncidentAddress_rec l_IncidentAddress_csr%ROWTYPE;
598:
599: CURSOR l_IncidentId_csr IS
600: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER
601: FROM CS_INCIDENTS_ALL_VL, HZ_LOCATIONS
602: WHERE HZ_LOCATIONS.LOCATION_ID = CS_INCIDENTS_ALL_VL.INCIDENT_LOCATION_ID AND
603: nvl(HZ_LOCATIONS.ADDRESS1, 'Not Filled') = nvl(l_incident_address, 'Not Filled') AND
604: nvl(HZ_LOCATIONS.CITY, 'Not Filled') = nvl(l_incident_city, 'Not Filled') AND
605: nvl(HZ_LOCATIONS.STATE, 'Not Filled') = nvl(l_incident_state, 'Not Filled') AND

Line 602: WHERE HZ_LOCATIONS.LOCATION_ID = CS_INCIDENTS_ALL_VL.INCIDENT_LOCATION_ID AND

598:
599: CURSOR l_IncidentId_csr IS
600: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER
601: FROM CS_INCIDENTS_ALL_VL, HZ_LOCATIONS
602: WHERE HZ_LOCATIONS.LOCATION_ID = CS_INCIDENTS_ALL_VL.INCIDENT_LOCATION_ID AND
603: nvl(HZ_LOCATIONS.ADDRESS1, 'Not Filled') = nvl(l_incident_address, 'Not Filled') AND
604: nvl(HZ_LOCATIONS.CITY, 'Not Filled') = nvl(l_incident_city, 'Not Filled') AND
605: nvl(HZ_LOCATIONS.STATE, 'Not Filled') = nvl(l_incident_state, 'Not Filled') AND
606: nvl(HZ_LOCATIONS.POSTAL_CODE, 'Not Filled') = nvl(l_incident_postal_Code, 'Not Filled') AND

Line 608: CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND

604: nvl(HZ_LOCATIONS.CITY, 'Not Filled') = nvl(l_incident_city, 'Not Filled') AND
605: nvl(HZ_LOCATIONS.STATE, 'Not Filled') = nvl(l_incident_state, 'Not Filled') AND
606: nvl(HZ_LOCATIONS.POSTAL_CODE, 'Not Filled') = nvl(l_incident_postal_Code, 'Not Filled') AND
607: nvl(HZ_LOCATIONS.COUNTRY, 'Not Filled') = nvl(l_incident_country, 'Not Filled') AND
608: CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND
609: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND
610: CS_INCIDENTS_ALL_VL.INCIDENT_ID <> l_request_id
611: UNION
612: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER

Line 609: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND

605: nvl(HZ_LOCATIONS.STATE, 'Not Filled') = nvl(l_incident_state, 'Not Filled') AND
606: nvl(HZ_LOCATIONS.POSTAL_CODE, 'Not Filled') = nvl(l_incident_postal_Code, 'Not Filled') AND
607: nvl(HZ_LOCATIONS.COUNTRY, 'Not Filled') = nvl(l_incident_country, 'Not Filled') AND
608: CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND
609: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND
610: CS_INCIDENTS_ALL_VL.INCIDENT_ID <> l_request_id
611: UNION
612: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER
613: FROM CS_INCIDENTS_ALL_VL

Line 610: CS_INCIDENTS_ALL_VL.INCIDENT_ID <> l_request_id

606: nvl(HZ_LOCATIONS.POSTAL_CODE, 'Not Filled') = nvl(l_incident_postal_Code, 'Not Filled') AND
607: nvl(HZ_LOCATIONS.COUNTRY, 'Not Filled') = nvl(l_incident_country, 'Not Filled') AND
608: CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND
609: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND
610: CS_INCIDENTS_ALL_VL.INCIDENT_ID <> l_request_id
611: UNION
612: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER
613: FROM CS_INCIDENTS_ALL_VL
614: WHERE nvl(incident_ADDRESS, 'Not Filled') = nvl(l_incident_address, 'Not Filled') AND

Line 612: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER

608: CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND
609: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND
610: CS_INCIDENTS_ALL_VL.INCIDENT_ID <> l_request_id
611: UNION
612: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER
613: FROM CS_INCIDENTS_ALL_VL
614: WHERE nvl(incident_ADDRESS, 'Not Filled') = nvl(l_incident_address, 'Not Filled') AND
615: nvl(incident_CITY, 'Not Filled') = nvl(l_incident_city, 'Not Filled') AND
616: nvl(incident_STATE, 'Not Filled') = nvl(l_incident_state, 'Not Filled') AND

Line 613: FROM CS_INCIDENTS_ALL_VL

609: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND
610: CS_INCIDENTS_ALL_VL.INCIDENT_ID <> l_request_id
611: UNION
612: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER
613: FROM CS_INCIDENTS_ALL_VL
614: WHERE nvl(incident_ADDRESS, 'Not Filled') = nvl(l_incident_address, 'Not Filled') AND
615: nvl(incident_CITY, 'Not Filled') = nvl(l_incident_city, 'Not Filled') AND
616: nvl(incident_STATE, 'Not Filled') = nvl(l_incident_state, 'Not Filled') AND
617: nvl(incident_POSTAL_CODE, 'Not Filled') = nvl(l_incident_postal_Code, 'Not Filled') AND

Line 629: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER

625: --
626:
627: -- Changed the where condition to fix bug # 2471602
628: CURSOR l_IncidentId_noLoc_csr IS
629: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER
630: FROM CS_INCIDENTS_ALL_VL
631: WHERE CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND
632: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND
633: CS_INCIDENTS_ALL_VL.INCIDENT_ID <> l_request_id AND

Line 630: FROM CS_INCIDENTS_ALL_VL

626:
627: -- Changed the where condition to fix bug # 2471602
628: CURSOR l_IncidentId_noLoc_csr IS
629: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER
630: FROM CS_INCIDENTS_ALL_VL
631: WHERE CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND
632: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND
633: CS_INCIDENTS_ALL_VL.INCIDENT_ID <> l_request_id AND
634: CS_INCIDENTS_ALL_VL.INCIDENT_LOCATION_ID is NULL AND

Line 631: WHERE CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND

627: -- Changed the where condition to fix bug # 2471602
628: CURSOR l_IncidentId_noLoc_csr IS
629: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER
630: FROM CS_INCIDENTS_ALL_VL
631: WHERE CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND
632: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND
633: CS_INCIDENTS_ALL_VL.INCIDENT_ID <> l_request_id AND
634: CS_INCIDENTS_ALL_VL.INCIDENT_LOCATION_ID is NULL AND
635: CS_INCIDENTS_ALL_VL.incident_ADDRESS is NULL AND

Line 632: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND

628: CURSOR l_IncidentId_noLoc_csr IS
629: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER
630: FROM CS_INCIDENTS_ALL_VL
631: WHERE CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND
632: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND
633: CS_INCIDENTS_ALL_VL.INCIDENT_ID <> l_request_id AND
634: CS_INCIDENTS_ALL_VL.INCIDENT_LOCATION_ID is NULL AND
635: CS_INCIDENTS_ALL_VL.incident_ADDRESS is NULL AND
636: CS_INCIDENTS_ALL_VL.incident_CITY is NULL AND

Line 633: CS_INCIDENTS_ALL_VL.INCIDENT_ID <> l_request_id AND

629: SELECT CS_INCIDENTS_ALL_VL.INCIDENT_ID,CS_INCIDENTS_ALL_VL.INCIDENT_NUMBER
630: FROM CS_INCIDENTS_ALL_VL
631: WHERE CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND
632: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND
633: CS_INCIDENTS_ALL_VL.INCIDENT_ID <> l_request_id AND
634: CS_INCIDENTS_ALL_VL.INCIDENT_LOCATION_ID is NULL AND
635: CS_INCIDENTS_ALL_VL.incident_ADDRESS is NULL AND
636: CS_INCIDENTS_ALL_VL.incident_CITY is NULL AND
637: CS_INCIDENTS_ALL_VL.incident_STATE is NULL AND

Line 634: CS_INCIDENTS_ALL_VL.INCIDENT_LOCATION_ID is NULL AND

630: FROM CS_INCIDENTS_ALL_VL
631: WHERE CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND
632: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND
633: CS_INCIDENTS_ALL_VL.INCIDENT_ID <> l_request_id AND
634: CS_INCIDENTS_ALL_VL.INCIDENT_LOCATION_ID is NULL AND
635: CS_INCIDENTS_ALL_VL.incident_ADDRESS is NULL AND
636: CS_INCIDENTS_ALL_VL.incident_CITY is NULL AND
637: CS_INCIDENTS_ALL_VL.incident_STATE is NULL AND
638: CS_INCIDENTS_ALL_VL.incident_POSTAL_CODE is NULL AND

Line 635: CS_INCIDENTS_ALL_VL.incident_ADDRESS is NULL AND

631: WHERE CS_INCIDENTS_ALL_VL.LAST_UPDATE_DATE > l_duplicate_date AND
632: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND
633: CS_INCIDENTS_ALL_VL.INCIDENT_ID <> l_request_id AND
634: CS_INCIDENTS_ALL_VL.INCIDENT_LOCATION_ID is NULL AND
635: CS_INCIDENTS_ALL_VL.incident_ADDRESS is NULL AND
636: CS_INCIDENTS_ALL_VL.incident_CITY is NULL AND
637: CS_INCIDENTS_ALL_VL.incident_STATE is NULL AND
638: CS_INCIDENTS_ALL_VL.incident_POSTAL_CODE is NULL AND
639: CS_INCIDENTS_ALL_VL.incident_COUNTRY is NULL;

Line 636: CS_INCIDENTS_ALL_VL.incident_CITY is NULL AND

632: CS_INCIDENTS_ALL_VL.INCIDENT_TYPE_ID = l_request_type_id AND
633: CS_INCIDENTS_ALL_VL.INCIDENT_ID <> l_request_id AND
634: CS_INCIDENTS_ALL_VL.INCIDENT_LOCATION_ID is NULL AND
635: CS_INCIDENTS_ALL_VL.incident_ADDRESS is NULL AND
636: CS_INCIDENTS_ALL_VL.incident_CITY is NULL AND
637: CS_INCIDENTS_ALL_VL.incident_STATE is NULL AND
638: CS_INCIDENTS_ALL_VL.incident_POSTAL_CODE is NULL AND
639: CS_INCIDENTS_ALL_VL.incident_COUNTRY is NULL;
640: l_IncidentId_noLoc_rec l_IncidentId_noLoc_csr%ROWTYPE;

Line 637: CS_INCIDENTS_ALL_VL.incident_STATE is NULL AND

633: CS_INCIDENTS_ALL_VL.INCIDENT_ID <> l_request_id AND
634: CS_INCIDENTS_ALL_VL.INCIDENT_LOCATION_ID is NULL AND
635: CS_INCIDENTS_ALL_VL.incident_ADDRESS is NULL AND
636: CS_INCIDENTS_ALL_VL.incident_CITY is NULL AND
637: CS_INCIDENTS_ALL_VL.incident_STATE is NULL AND
638: CS_INCIDENTS_ALL_VL.incident_POSTAL_CODE is NULL AND
639: CS_INCIDENTS_ALL_VL.incident_COUNTRY is NULL;
640: l_IncidentId_noLoc_rec l_IncidentId_noLoc_csr%ROWTYPE;
641:

Line 638: CS_INCIDENTS_ALL_VL.incident_POSTAL_CODE is NULL AND

634: CS_INCIDENTS_ALL_VL.INCIDENT_LOCATION_ID is NULL AND
635: CS_INCIDENTS_ALL_VL.incident_ADDRESS is NULL AND
636: CS_INCIDENTS_ALL_VL.incident_CITY is NULL AND
637: CS_INCIDENTS_ALL_VL.incident_STATE is NULL AND
638: CS_INCIDENTS_ALL_VL.incident_POSTAL_CODE is NULL AND
639: CS_INCIDENTS_ALL_VL.incident_COUNTRY is NULL;
640: l_IncidentId_noLoc_rec l_IncidentId_noLoc_csr%ROWTYPE;
641:
642:

Line 639: CS_INCIDENTS_ALL_VL.incident_COUNTRY is NULL;

635: CS_INCIDENTS_ALL_VL.incident_ADDRESS is NULL AND
636: CS_INCIDENTS_ALL_VL.incident_CITY is NULL AND
637: CS_INCIDENTS_ALL_VL.incident_STATE is NULL AND
638: CS_INCIDENTS_ALL_VL.incident_POSTAL_CODE is NULL AND
639: CS_INCIDENTS_ALL_VL.incident_COUNTRY is NULL;
640: l_IncidentId_noLoc_rec l_IncidentId_noLoc_csr%ROWTYPE;
641:
642:
643: CURSOR l_DuplicateCheckAttrs_csr IS

Line 668: TYPE IncidentList IS VARRAY(400) OF CS_INCIDENTS_ALL_VL.incident_id%TYPE;

664: sr_attribute_code = l_DuplicateCheckAttrs_rec.sr_attribute_code AND
665: incident_id = l_IncidentId_noLoc_rec.Incident_Id;
666:
667:
668: TYPE IncidentList IS VARRAY(400) OF CS_INCIDENTS_ALL_VL.incident_id%TYPE;
669: l_IncidentList IncidentList := IncidentList();
670:
671:
672: TYPE SRAttrDupCheck IS REF CURSOR;

Line 674: l_SRAttrDupCheck_rec CS_INCIDENTS_ALL_VL.incident_id%TYPE;

670:
671:
672: TYPE SRAttrDupCheck IS REF CURSOR;
673: l_SRAttrDupCheck_str SRAttrDupCheck;
674: l_SRAttrDupCheck_rec CS_INCIDENTS_ALL_VL.incident_id%TYPE;
675:
676:
677: BEGIN
678: IF (funmode = 'RUN') THEN

Line 694: from CS_INCIDENTS_ALL_VL where INCIDENT_ID = l_request_id;

690:
691: -- Beging of changes by ANEEMUCH date 10-May-2002
692: /*
693: select INSTALL_SITE_USE_ID into l_install_at_site_id
694: from CS_INCIDENTS_ALL_VL where INCIDENT_ID = l_request_id;
695: */
696:
697: OPEN l_ServiceRequest_csr;
698: FETCH l_ServiceRequest_csr into l_ServiceRequest_rec;

Line 726: from CS_INCIDENTS_ALL_VL where INCIDENT_ID = l_request_id;

722: CLOSE l_ServiceRequest_csr;
723: -- End of changes by ANEEMUCH date 10-May-2002
724:
725: select INCIDENT_TYPE_ID into l_request_type_id
726: from CS_INCIDENTS_ALL_VL where INCIDENT_ID = l_request_id;
727:
728: -- Begin changes by ANEEMUCH 10-May-2002
729: -- IF ( l_install_at_site_id IS NOT NULL) THEN
730: IF (l_incident_address IS NOT NULL OR l_incident_city IS NOT NULL OR

Line 939: CS_INCIDENTS_ALL_VL WHERE INCIDENT_ID = l_request_id;

935: itemkey => itemkey,
936: aname => 'REQUEST_ID');
937:
938: select INCIDENT_TYPE_ID into l_request_type_id FROM
939: CS_INCIDENTS_ALL_VL WHERE INCIDENT_ID = l_request_id;
940:
941: select RESOURCE_ID into l_default_owner_id FROM CUG_SR_TYPE_DUP_CHK_INFO
942: WHERE Incident_Type_ID = l_request_type_id;
943:

Line 1136: SELECT INCIDENT_TYPE_ID into l_request_type_id FROM CS_INCIDENTS_ALL_VL WHERE

1132: itemkey => itemkey,
1133: aname => 'REQUEST_NUMBER');
1134: /* End - 09/24/2001 - change made to accomodate Rahul's problem with update_task API */
1135:
1136: SELECT INCIDENT_TYPE_ID into l_request_type_id FROM CS_INCIDENTS_ALL_VL WHERE
1137: INCIDENT_ID = l_request_id;
1138:
1139: l_create_task := 1;
1140:

Line 1563: SELECT incident_type_id FROM CS_INCIDENTS_ALL_VL

1559:
1560: l_duplicate_uom VARCHAR2(30);
1561:
1562: CURSOR c_SRTypeID_csr IS
1563: SELECT incident_type_id FROM CS_INCIDENTS_ALL_VL
1564: WHERE INCIDENT_ID = l_request_id;
1565:
1566:
1567: CURSOR c_DuplicateTimeInfo_csr IS

Line 1978: FROM cs_incidents_all_vl inc ,cs_sr_owners_v owner, jtf_rs_resource_extns emp

1974: l_API_ERROR EXCEPTION;
1975:
1976: CURSOR l_ServiceRequest_csr IS
1977: SELECT inc.customer_product_id, inc.expected_resolution_date,inc.inventory_item_id,inc.summary, emp.source_id incident_owner_id
1978: FROM cs_incidents_all_vl inc ,cs_sr_owners_v owner, jtf_rs_resource_extns emp
1979: WHERE inc.INCIDENT_OWNER_ID = owner.resource_id(+) AND
1980: emp.resource_id = owner.resource_id AND
1981: incident_id = l_request_id;
1982:

Line 2113: FROM CS_INCIDENTS_ALL_VL

2109: l_API_ERROR EXCEPTION;
2110:
2111: CURSOR l_ServiceRequest_csr IS
2112: SELECT *
2113: FROM CS_INCIDENTS_ALL_VL
2114: WHERE INCIDENT_NUMBER = l_request_number;
2115:
2116: l_ServiceRequest_rec l_ServiceRequest_csr%ROWTYPE;
2117: l_errmsg_name VARCHAR2(30);