APPS.IEM_DIAG_KB_DOC_PVT dependencies on IEM_THEMES

Line 36: l_theme iem_themes.theme%type;

32: l_result_string varchar2(32000);
33: c_account iem_email_accounts.email_user%type;
34: c_domain iem_email_accounts.domain%type;
35: c_intent iem_classifications.classification%type;
36: l_theme iem_themes.theme%type;
37: l_classification_count number;
38: l_theme_count number;
39: l_account_count number;
40: l_kb_result_count number := 0;

Line 44: FROM IEM_THEMES

40: l_kb_result_count number := 0;
41:
42: CURSOR theme_csr IS
43: SELECT theme,score*10 score
44: FROM IEM_THEMES
45: WHERE CLASSIFICATION_ID=l_classification_id
46: AND QUERY_RESPONSE='R'
47: and score>0
48: order by score desc;

Line 93: SELECT count(*) into l_theme_count FROM IEM_THEMES

89: l_imt_string2 := ''', 1)>0 and b.application_id = 520 and nvl(b.effective_start_date, sysdate) <= sysdate+1 and nvl(b.expiration_date, sysdate) >= sysdate
90: and b.item_id = a.attachment_used_by_id and a.file_id = fl.file_id and b.item_id = cim.item_id and cim.channel_id is null
91: and cim.approval_status_type = ''APPROVED'' AND cim.table_name_code = ''ITEM'' and cim.available_for_channel_date <= sysdate order by score desc';
92:
93: SELECT count(*) into l_theme_count FROM IEM_THEMES
94: WHERE CLASSIFICATION_ID=l_classification_id AND QUERY_RESPONSE='R' and score>0;
95:
96: if (l_theme_count = 0) then
97: statusStr := 'FAILURE';