APPS.IEM_KNOWLEDGEBASE_PUB dependencies on IEM_KB_RESULTS

Line 30: FROM IEM_KB_RESULTS

26: KB_CATEGORY_NAME,
27: DOCUMENT_TITLE,
28: URL,
29: DOC_LAST_MODIFIED_DATE
30: FROM IEM_KB_RESULTS
31: WHERE (EMAIL_ACCOUNT_ID = p_EMAIL_ACCOUNT_ID)
32: AND (MESSAGE_ID = p_MESSAGE_ID)
33: AND classification_id = p_CLASSIFICATION_ID;
34: BEGIN

Line 248: DELETE FROM IEM_KB_RESULTS

244: FND_MSG_PUB.initialize;
245: END IF;
246: -- Initialize API return status to SUCCESS
247: x_return_status := FND_API.G_RET_STS_SUCCESS;
248: DELETE FROM IEM_KB_RESULTS
249: WHERE email_account_id=p_email_account_id
250: and message_id=p_message_id;
251: DELETE FROM IEM_email_classifications
252: WHERE email_account_id=p_email_account_id

Line 323: FROM IEM_KB_RESULTS

319: KB_CATEGORY_NAME,
320: DOCUMENT_TITLE,
321: URL,
322: DOC_LAST_MODIFIED_DATE
323: FROM IEM_KB_RESULTS
324: WHERE (EMAIL_ACCOUNT_ID = p_EMAIL_ACCOUNT_ID)
325: AND (MESSAGE_ID = p_MESSAGE_ID)
326: AND classification_id = p_CLASSIFICATION_ID;
327: BEGIN

Line 431: FROM IEM_KB_RESULTS a

427: a.KB_CATEGORY_NAME,
428: a.DOCUMENT_TITLE,
429: a.URL,
430: a.DOC_LAST_MODIFIED_DATE
431: FROM IEM_KB_RESULTS a
432: WHERE (a.EMAIL_ACCOUNT_ID = p_EMAIL_ACCOUNT_ID)
433: AND (a.MESSAGE_ID = p_MESSAGE_ID)
434: AND a.classification_id = p_CLASSIFICATION_ID
435: order by 2 desc,1 desc;

Line 458: from iem_kb_results

454: END IF;
455: -- Initialize API return status to SUCCESS
456: x_return_status := FND_API.G_RET_STS_SUCCESS;
457: select count(*) into l_doc_count
458: from iem_kb_results
459: WHERE EMAIL_ACCOUNT_ID = p_EMAIL_ACCOUNT_ID
460: AND MESSAGE_ID = p_MESSAGE_ID
461: AND classification_id = p_CLASSIFICATION_ID;
462: IF l_doc_count=0 then -- No document has retrieved .

Line 581: FROM IEM_KB_RESULTS

577: KB_CATEGORY_NAME,
578: DOCUMENT_TITLE,
579: URL,
580: DOC_LAST_MODIFIED_DATE
581: FROM IEM_KB_RESULTS
582: WHERE (EMAIL_ACCOUNT_ID = p_EMAIL_ACCOUNT_ID)
583: AND (MESSAGE_ID = p_MESSAGE_ID)
584: order by score desc;
585: BEGIN