[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
ELSIF p_mode = 'UPDATE' THEN
/*WIP_EAM_WORKREQUEST_PVT.update_work_request (
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_validation_level => p_validation_level,
p_org_id => decode(p_work_request_rec.organization_id,null,organization_id,p_work_request_rec.organization_id),
p_asset_group_id => decode(p_work_request_rec.asset_group,null,asset_group,p_work_request_rec.asset_group),
p_asset_number => decode(p_work_request_rec.asset_number,asset_number,p_work_request_rec.asset_number),
p_request_id => p_work_request_rec.work_request_id,
p_status_id => decode(p_work_request_rec.work_request_status_id,null,work_request_status_id,p_work_request_rec.work_request_status_id),
p_priority_id => decode(p_work_request_rec.work_request_priority_id,null,work_request_priority_id,p_work_request_rec.priority_id),
p_request_by_date => decode(p_work_request_rec.expected_resolution_date,null,expected_resolution_date,p_work_request_rec.expected_resolution_date),
p_request_log => decode(p_request_log,null,description,p_request_log),
p_work_request_type_id => decode(p_work_request_rec.work_request_type_id,null,work_request_type_id,p_work_request_rec.work_request_type_id),
p_owning_dept_id => decode(p_work_request_rec.work_request_owning_dept,null,work_request_owning_dept,p_work_request_rec.work_request_owning_dept),
p_created_for => decode(p_work_request_rec.created_for,null,created_for,p_work_request_rec.created_for),
p_phone_number => decode(p_work_request_rec.phone_number,null,p_phone_number,p_work_request_rec.phone_number),
p_email => decode(p_work_request_rec.e_mail,null,e_mail,p_work_request_rec.e_mail),
p_contact_preference => decode(p_work_request_rec.contact_preference,null,contact_preference,p_work_request_rec.contact_preference),
p_notify_originator => decode(p_work_request_rec.notify_originator,null,notify_originator,p_work_request_rec.notify_originator),
p_attribute_category => decode(p_work_request_rec.attribute_category,null,attribute_category,p_work_request_rec.attribute_category),
p_attribute1 => decode(p_work_request_rec.attribute1, NULL, ATTRIBUTE1, p_work_request_rec.attribute1),
p_attribute2 => decode(p_work_request_rec.attribute2, NULL, ATTRIBUTE2, p_work_request_rec.attribute2),
p_attribute3 => decode(p_work_request_rec.attribute3, NULL, ATTRIBUTE3, p_work_request_rec.attribute3),
p_attribute4 => decode(p_work_request_rec.attribute4, NULL, ATTRIBUTE4, p_work_request_rec.attribute4),
p_attribute5 => decode(p_work_request_rec.attribute5, NULL, ATTRIBUTE5, p_work_request_rec.attribute5),
p_attribute6 => decode(p_work_request_rec.attribute6, NULL, ATTRIBUTE6, p_work_request_rec.attribute6),
p_attribute7 => decode(p_work_request_rec.attribute7, NULL, ATTRIBUTE7, p_work_request_rec.attribute7),
p_attribute8 => decode(p_work_request_rec.attribute8, NULL, ATTRIBUTE8, p_work_request_rec.attribute8),
p_attribute9 => decode(p_work_request_rec.attribute9, NULL, ATTRIBUTE9, p_work_request_rec.attribute9),
p_attribute10 => decode(p_work_request_rec.attribute10, NULL, ATTRIBUTE10, p_work_request_rec.attribute10),
p_attribute11 => decode(p_work_request_rec.attribute11, NULL, ATTRIBUTE11, p_work_request_rec.attribute11),
p_attribute12 => decode(p_work_request_rec.attribute12, NULL, ATTRIBUTE12, p_work_request_rec.attribute12),
p_attribute13 => decode(p_work_request_rec.attribute13, NULL, ATTRIBUTE13, p_work_request_rec.attribute13),
p_attribute14 => decode(p_work_request_rec.attribute14, NULL, ATTRIBUTE14, p_work_request_rec.attribute14),
p_attribute15 => decode(p_work_request_rec.attribute15, NULL, ATTRIBUTE15, p_work_request_rec.attribute15),
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);*/
WIP_EAM_WORKREQUEST_PVT.update_work_request (
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_validation_level => p_validation_level,
p_org_id => p_work_request_rec.organization_id,
p_asset_group_id => p_work_request_rec.asset_group,
p_asset_number => p_work_request_rec.asset_number,
p_request_id => p_work_request_rec.work_request_id,
p_status_id => p_work_request_rec.work_request_status_id,
p_priority_id => p_work_request_rec.work_request_priority_id,
p_request_by_date => p_work_request_rec.expected_resolution_date,
p_request_log => p_request_log,
p_work_request_type_id => p_work_request_rec.work_request_type_id,
p_eam_linear_id => p_work_request_rec.eam_linear_location_id,
p_owning_dept_id => p_work_request_rec.work_request_owning_dept,
p_user_id => p_user_id,
p_created_for => p_work_request_rec.created_for,
p_phone_number => p_work_request_rec.phone_number,
p_email => p_work_request_rec.e_mail,
p_contact_preference => p_work_request_rec.contact_preference,
p_notify_originator => p_work_request_rec.notify_originator,
p_attribute_category => p_work_request_rec.attribute_category,
p_attribute1 => p_work_request_rec.attribute1,
p_attribute2 => p_work_request_rec.attribute2,
p_attribute3 => p_work_request_rec.attribute3,
p_attribute4 => p_work_request_rec.attribute4,
p_attribute5 => p_work_request_rec.attribute5,
p_attribute6 => p_work_request_rec.attribute6,
p_attribute7 => p_work_request_rec.attribute7,
p_attribute8 => p_work_request_rec.attribute8,
p_attribute9 => p_work_request_rec.attribute9,
p_attribute10 => p_work_request_rec.attribute10,
p_attribute11 => p_work_request_rec.attribute11,
p_attribute12 => p_work_request_rec.attribute12,
p_attribute13 => p_work_request_rec.attribute13,
p_attribute14 => p_work_request_rec.attribute14,
p_attribute15 => p_work_request_rec.attribute15,
p_from_public_api => 'Y',
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);