The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_LAST_UPDATED_BY NUMBER,
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATE_LOGIN NUMBER ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
IS
l_api_name VARCHAR2(255):='create_item';
select count(*) into l_count from iem_email_classifications
where message_id=p_message_id
and classification_id=p_classification_id;
INSERT INTO IEM_EMAIL_CLASSIFICATIONS
(
MESSAGE_ID,
EMAIL_ACCOUNT_ID ,
CLASSIFICATION_ID ,
SCORE ,
CREATED_BY ,
CREATION_DATE ,
LAST_UPDATED_BY ,
LAST_UPDATE_DATE ,
LAST_UPDATE_LOGIN
)
VALUES
(
p_message_id,
p_email_account_id,
p_classification_id,
p_score,
DECODE(p_created_by,null,-1,p_created_by),
sysdate,
DECODE(p_LAST_UPDATED_BY,null,-1,p_last_updated_by),
sysdate,
DECODE(p_LAST_UPDATE_LOGIN,null,-1,p_last_update_login)
);
PROCEDURE delete_item (p_api_version_number IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
p_commit IN VARCHAR2 ,
p_email_account_id IN NUMBER,
p_classification_id IN NUMBER,
p_message_id IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) is
l_api_name VARCHAR2(255):='delete_item';
DELETE FROM IEM_EMAIL_CLASSIFICATIONS
where message_id=p_message_id
and classification_id=p_classification_id
and email_account_id=p_email_account_id;
--ROLLBACK TO delete_item_PVT;
--ROLLBACK TO delete_item_PVT;
SELECT a.classification_id,b.intent,a.score
FROM IEM_EMAIL_CLASSIFICATIONS a,IEM_INTENTS b
WHERE a.classification_id=b.intent_id
AND a.message_id = p_message_id
AND a.email_account_id = p_email_account_id;
SELECT a.classification_id,b.intent,a.score
FROM IEM_EMAIL_CLASSIFICATIONS a,IEM_INTENTS b
WHERE a.classification_id=b.intent_id
AND a.message_id = p_message_id
AND a.email_account_id = p_email_account_id;
select category_map_id into l_category_map_id
FROM IEM_RT_PROC_EMAILS
WHERE MESSAGE_ID=p_message_id;
p_LAST_UPDATED_BY NUMBER ,
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATE_LOGIN NUMBER ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) is
l_api_name VARCHAR2(255):='create_item';
select count(*) into l_count from iem_email_classifications
where message_id=p_message_id
and classification_id=p_classification_id;
INSERT INTO IEM_EMAIL_CLASSIFICATIONS
(
MESSAGE_ID,
EMAIL_ACCOUNT_ID ,
CLASSIFICATION_ID ,
SCORE ,
CLASSIFICATION_STRING,
CREATED_BY ,
CREATION_DATE ,
LAST_UPDATED_BY ,
LAST_UPDATE_DATE ,
LAST_UPDATE_LOGIN
)
VALUES
(
p_message_id,
p_email_account_id,
p_classification_id,
p_score,
p_class_string,
DECODE(p_created_by,null,-1,p_created_by),
sysdate,
DECODE(p_LAST_UPDATED_BY,null,-1,p_last_updated_by),
sysdate,
DECODE(p_LAST_UPDATE_LOGIN,null,-1,p_last_update_login)
);