[Home] [Help]
30: RETURN BOOLEAN
31: IS
32: CURSOR c_incident (b_incident_id NUMBER) IS
33: SELECT incident_id -- Sql Performance Fix
34: FROM CS_INCIDENTS_ALL_B
35: WHERE incident_id = b_incident_id;
36: r_incident c_incident%ROWTYPE;
37:
38: BEGIN
87: -- 11.5.10 Changes - 3430663. Get based on incident_location_id not
88: -- on install_site_id
89: SELECT customer_id, incident_location_id, customer_product_id,
90: inventory_item_id, inv_organization_id
91: FROM CS_INCIDENTS_ALL_B
92: WHERE incident_id = b_incident_id;
93: r_incident c_incident%ROWTYPE;
94:
95: l_return BOOLEAN;
277: -- 11510 3430663 Changes. Get incident_location_id not install_site_id
278: CURSOR c_incident (b_incident_id NUMBER) IS
279: SELECT customer_id, incident_location_id, customer_product_id,
280: inventory_item_id, inv_organization_id
281: FROM CS_INCIDENTS_ALL_B
282: WHERE incident_id = b_incident_id;
283: r_incident c_incident%ROWTYPE;
284:
285: l_status VARCHAR2(30);
545: IS
546: CURSOR c_incident( b_incident_id NUMBER ) IS
547: SELECT au.RESOURCE_ID
548: FROM ASG_USER au
549: , CS_INCIDENTS_ALL_B inc
550: WHERE au.USER_ID = inc.CREATED_BY
551: AND inc.INCIDENT_ID = b_incident_id;
552: r_incident c_incident%ROWTYPE;
553: l_enabled_flag VARCHAR2(30);
641: , CUSTOMER_PRODUCT_ID
642: , INVENTORY_ITEM_ID
643: , INV_ORGANIZATION_ID
644: , CONTRACT_SERVICE_ID
645: FROM CS_INCIDENTS_ALL_B
646: WHERE incident_id = b_incident_id;
647: l_enabled_flag VARCHAR2(30);
648: BEGIN
649:
722: , CUSTOMER_PRODUCT_ID
723: , INVENTORY_ITEM_ID
724: , INV_ORGANIZATION_ID
725: , CONTRACT_SERVICE_ID
726: FROM CS_INCIDENTS_ALL_B
727: WHERE incident_id = b_incident_id;
728:
729: r_incident c_incident%ROWTYPE;
730:
994:
995: CURSOR c_incident( b_resource_id NUMBER ) IS
996: SELECT inc.INCIDENT_ID
997: FROM ASG_USER au
998: , CS_INCIDENTS_ALL_B inc
999: WHERE au.USER_ID = inc.CREATED_BY
1000: AND au.RESOURCE_ID = b_resource_id;
1001: r_incident c_incident%ROWTYPE;
1002: l_dummy BOOLEAN;