APPS.IEM_CONFIGURATION_PUB dependencies on IEM_EMAIL_ACCOUNTS

Line 28: l_email_account_rec IEM_EMAIL_ACCOUNTS%ROWTYPE;

24: l_server_group_rec IEM_SERVER_GROUPS%ROWTYPE;
25: l_db_server_rec IEM_DB_SERVERS%ROWTYPE;
26: l_db_connection_rec IEM_DB_CONNECTIONS%ROWTYPE;
27: l_email_server_rec IEM_EMAIL_SERVERS%ROWTYPE;
28: l_email_account_rec IEM_EMAIL_ACCOUNTS%ROWTYPE;
29: l_classification_rec IEM_CLASSIFICATIONS%ROWTYPE;
30: l_theme_rec IEM_THEMES%ROWTYPE;
31: l_agent_account_rec IEM_AGENT_ACCOUNTS%ROWTYPE;
32: Cursor csr_server_group is select * from iem_server_groups;

Line 36: Cursor csr_email_account is select * from iem_email_accounts;

32: Cursor csr_server_group is select * from iem_server_groups;
33: Cursor csr_db_server is select * from iem_db_servers;
34: Cursor csr_db_connection is select * from iem_db_connections;
35: Cursor csr_email_server is select * from iem_email_servers;
36: Cursor csr_email_account is select * from iem_email_accounts;
37: Cursor csr_classification is select * from iem_classifications;
38: Cursor csr_agent_account is select * from iem_agent_accounts;
39: CURSOR csr_theme( l_classification_id IN NUMBER ) IS
40: select * from iem_themes where classification_id = l_classification_id ;

Line 163: select count(*) into l_count from iem_email_accounts;

159: END LOOP;
160: close csr_email_server;
161:
162: -- Email Account
163: select count(*) into l_count from iem_email_accounts;
164: l_counter := 0;
165:
166: fnd_file.put_line(fnd_file.log, ' '); -- blank lines
167: l_Error_Message := '*** EMAIL ACCOUNT (IEM_EMAIL_ACCOUNTS) Total # of rows: ' || l_count || ' *** ';

Line 167: l_Error_Message := '*** EMAIL ACCOUNT (IEM_EMAIL_ACCOUNTS) Total # of rows: ' || l_count || ' *** ';

163: select count(*) into l_count from iem_email_accounts;
164: l_counter := 0;
165:
166: fnd_file.put_line(fnd_file.log, ' '); -- blank lines
167: l_Error_Message := '*** EMAIL ACCOUNT (IEM_EMAIL_ACCOUNTS) Total # of rows: ' || l_count || ' *** ';
168: fnd_file.put_line(fnd_file.log, l_Error_Message);
169:
170: fnd_file.put_line(fnd_file.log, 'row_id, email_account_id, account_name, email_user, domain, db_server_id, server_group_id, acct_language, reply_to_address, from_name, intent_enabled, custom_enabled');
171:

Line 205: select email_user||'@'||domain as account_name into l_account_name from iem_email_accounts where email_account_id= l_classification_rec.email_account_id;

201: LOOP
202: FETCH csr_classification INTO l_classification_rec;
203: EXIT WHEN csr_classification%NOTFOUND;
204:
205: select email_user||'@'||domain as account_name into l_account_name from iem_email_accounts where email_account_id= l_classification_rec.email_account_id;
206:
207: fnd_file.put_line(fnd_file.log, ' '); -- blank lines
208: fnd_file.put_line(fnd_file.log, 'INTENT : ' || l_counter || ', ' || l_classification_rec.classification_id || ', ' ||
209: l_account_name || ', ' || l_classification_rec.classification || ', ' ||