The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT decode(on_hold_flag, 'Y', 'SLEEP', 'OPEN') wi_status,
nvl(close_flag,'N')
FROM cs_incident_statuses_b
WHERE incident_status_id = p_sr_rec.status_id;
select work_item_id
from ieu_uwqm_items
where WORKITEM_OBJ_CODE = 'SR'
and WORKITEM_PK_ID = p_incident_id;
Update_Workitem() -
******************************************************/
PROCEDURE Update_Workitem(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
p_incident_id IN NUMBER,
p_old_sr_rec IN CS_ServiceRequest_PVT.sr_oldvalues_rec_type,
p_new_sr_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
p_user_id IN NUMBER, -- Required
p_resp_appl_id IN NUMBER, -- Required
p_login_id IN NUMBER DEFAULT NULL,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2) IS
l_return_status VARCHAR2(1);
select work_item_id
from ieu_uwqm_items
where WORKITEM_OBJ_CODE = 'SR'
and WORKITEM_PK_ID = p_incident_id;
SELECT nvl(close_flag,'N'),
nvl(on_hold_flag,'N')
FROM cs_incident_statuses_b
WHERE incident_status_id = l_status_id;
SELECT incident_number
FROM cs_incidents_all_b
WHERE incident_id = p_incident_id;
-- Determine if we need to update Work Item Due Date
-- Check if inc_responded_by_date changed from NULL to
-- NOT NULL and vice versa.
Apply_Priority_Rule
(P_New_Inc_Responded_By_Date => p_new_sr_rec.inc_responded_by_date,
P_New_Obligation_Date => p_new_sr_rec.obligation_date,
P_New_Exp_Resolution_Date => p_new_sr_rec.exp_resolution_date,
P_New_Severity_Id => p_new_sr_rec.severity_id,
P_Old_Inc_Responded_By_Date => p_old_sr_rec.inc_responded_by_date,
P_Old_Obligation_Date => p_old_sr_rec.obligation_date,
P_Old_Exp_Resolution_Date => p_old_sr_rec.expected_resolution_date,
P_Old_Severity_Id => p_old_sr_rec.incident_severity_id,
P_Operation_mode => 'UPDATE',
X_Change_WI_Flag => l_change_wi_attr1,
X_Due_Date => l_due_date,
X_Priority_Code => l_priority,
X_Return_Status => X_Return_Status,
X_Msg_Count => X_Msg_Count,
X_Msg_Data => X_Msg_Data);
-- so no need to call Update work item API.
OPEN sel_status_flags_csr(p_old_sr_rec.incident_status_id);
-- The Status might have been deleted in the set-up form. Not sure
-- if this is a valid scenario.
IF sel_status_flags_csr%NOTFOUND THEN
NULL;
IEU_WR_PUB.UPDATE_WR_ITEM(
p_api_version => 1.0,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_workitem_obj_code => 'SR',
p_workitem_pk_id => p_incident_id,
p_title => l_summary,
p_party_id => l_customer_id,
p_priority_code => l_priority,
p_due_date => l_due_date,
p_owner_id => l_owner_group_id,
p_owner_type => l_group_type,
p_assignee_id => l_owner_id,
p_assignee_type => l_resource_type,
p_source_object_id => NULL,
p_source_object_type_code => NULL,
p_application_id => l_resp_appl_id,
p_work_item_status => l_work_item_status,
p_user_id => l_user_id,
p_login_id => p_login_id,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_return_status => l_return_status
);
END Update_Workitem;
SELECT priority_code
FROM cs_incident_severities_b
WHERE incident_severity_id = l_severity_id;
ELSE --p_operation_mode = 'UPDATE' THEN -- Operation Mode
IF ((p_old_inc_responded_by_date IS NULL AND
p_new_inc_responded_by_date IS NOT NULL AND
p_new_inc_responded_by_date <> FND_API.G_MISS_DATE) OR
(p_old_inc_responded_by_date IS NOT NULL AND
p_new_inc_responded_by_date IS NULL)
) THEN
--Set value for Due Date work item parameter
IF (p_new_inc_responded_by_date IS NULL) THEN
X_due_date := p_new_obligation_date;
-- in UWQ API and passing null updates UWQ schema to NULL.
X_due_date := p_old_obligation_date;
END IF; -- End of: Determine if we need to update Work Item Due Date.