APPS.CUG_PREVENT_SR_UPDATE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 73

    l_api_name_full CONSTANT VARCHAR2(61)    := 'CS_SERVICEREQUEST_VUHK'||'.'||'Update_ServiceRequest_Pre';

Line: 76

        SELECT * FROM CS_INCIDENTS_ALL_B WHERE
            incident_id = l_request_id;

Line: 82

        SELECT * FROM CUG_INCIDNT_ATTR_VALS_VL WHERE incident_id = l_request_id;

Line: 87

        SELECT end_date from WF_ITEMS where
        item_type = 'SERVEREQ' AND
        root_activity = 'CUG_GENERIC_WORKFLOW' AND
        item_key = l_request_number_key;

Line: 94

        SELECT activity_end_date from
            wf_item_activity_statuses_v where
            item_key = l_request_number_key AND
            activity_name = 'CLOSE_REQUEST';

Line: 171

          FND_MESSAGE.Set_Name('CUG', 'CUG_SR_UPDATE_NOT_ALLOWED');

Line: 187

               FND_MESSAGE.Set_Name('CUG', 'CUG_SR_UPDATE_NOT_ALLOWED');

Line: 227

 END Update_ServiceRequest_Prevent;