APPS.IEM_DIAG_KB_DOC_PVT dependencies on IEM_EMAIL_ACCOUNTS

Line 33: c_account iem_email_accounts.email_user%type;

29: l_imt_string varchar2(32000);
30: l_imt_string1 varchar2(5000);
31: l_imt_string2 varchar2(5000);
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;

Line 34: c_domain iem_email_accounts.domain%type;

30: l_imt_string1 varchar2(5000);
31: l_imt_string2 varchar2(5000);
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;

Line 58: select count(*) into l_account_count from iem_email_accounts

54: c_account := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Account', inputs);
55: c_domain := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Domain', inputs);
56: c_intent := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Intent', inputs);
57:
58: select count(*) into l_account_count from iem_email_accounts
59: where UPPER(email_user)=UPPER(c_account) and UPPER(domain)=UPPER(c_domain);
60:
61: if (l_account_count = 0) then
62: statusStr := 'FAILURE';

Line 70: select count(*) into l_classification_count from iem_email_accounts a, iem_classifications b

66: isFatal := 'FALSE';
67: else
68:
69:
70: select count(*) into l_classification_count from iem_email_accounts a, iem_classifications b
71: where a.email_account_id=b.email_account_id and upper(a.email_user)=upper(c_account)
72: and UPPER(a.domain)=UPPER(c_domain)
73: and UPPER(b.classification)=UPPER(c_intent);
74:

Line 83: select b.classification_id into l_classification_id from iem_email_accounts a, iem_classifications b

79: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
80: isFatal := 'FALSE';
81: else
82:
83: select b.classification_id into l_classification_id from iem_email_accounts a, iem_classifications b
84: where a.email_account_id=b.email_account_id and upper(a.email_user)=upper(c_account)
85: and UPPER(b.classification)=UPPER(c_intent);
86:
87: l_imt_string1 := 'select b.item_id,fl.file_name , cim.channel_category_id , score(1) score from jtf_amv_items_vl b, jtf_amv_attachments a, fnd_lobs fl, amv_c_chl_item_match cim where contains(file_data,''';