The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_status_update_user_id NUMBER;
PROCEDURE UPDATE_UWQM_ITEM
( p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
p_workitem_obj_code IN VARCHAR2,
p_workitem_pk_id IN NUMBER,
p_title IN VARCHAR2,
p_party_id IN NUMBER,
p_priority_code IN VARCHAR2,
p_due_date IN DATE,
p_owner_id IN NUMBER,
p_owner_type IN VARCHAR2,
p_assignee_id IN NUMBER,
p_assignee_type IN VARCHAR2,
p_source_object_id IN NUMBER,
p_source_object_type_code IN VARCHAR2,
p_application_id IN NUMBER,
p_user_id IN NUMBER,
p_login_id IN NUMBER,
-- p_ieu_enum_type_uuid IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2) AS
l_api_version NUMBER := 1.0;
l_api_name VARCHAR2(30) := 'UPDATE_UWQM_ITEM';
END UPDATE_UWQM_ITEM;
l_status_update_user_id VARCHAR2(30);
l_status_update_user_id NUMBER;
l_old_status_update_user_id NUMBER;
l_new_status_update_user_id NUMBER;
l_status_update_user_id NUMBER;
PROCEDURE DELETE_UWQM_ITEM
( p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
p_workitem_obj_code IN VARCHAR2,
p_workitem_pk_id IN NUMBER,
p_user_id IN NUMBER,
p_login_id IN NUMBER,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2) AS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_UWQM_ITEM';
l_status_update_user_id NUMBER;
END DELETE_UWQM_ITEM;
l_old_status_update_user_id NUMBER;
l_new_status_update_user_id NUMBER;