APPS.IEM_CONFIGURATION_PUB dependencies on IEM_THEMES

Line 30: l_theme_rec IEM_THEMES%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;
33: Cursor csr_db_server is select * from iem_db_servers;
34: Cursor csr_db_connection is select * from iem_db_connections;

Line 40: select * from iem_themes where classification_id = l_classification_id ;

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 ;
41:
42:
43: BEGIN
44: -- Standard Start of API savepoint

Line 217: select count(*) into l_count from iem_themes where classification_id=l_classification_rec.classification_id;

213: l_counter := l_counter + 1;
214: l_counter1 := 0;
215:
216: -- Keyword
217: select count(*) into l_count from iem_themes where classification_id=l_classification_rec.classification_id;
218:
219: l_Error_Message := ' *** KEYWORD (IEM_THEMES) Total # of rows: ' || l_count || ' *** ';
220: fnd_file.put_line(fnd_file.log, l_Error_Message);
221:

Line 219: l_Error_Message := ' *** KEYWORD (IEM_THEMES) Total # of rows: ' || l_count || ' *** ';

215:
216: -- Keyword
217: select count(*) into l_count from iem_themes where classification_id=l_classification_rec.classification_id;
218:
219: l_Error_Message := ' *** KEYWORD (IEM_THEMES) Total # of rows: ' || l_count || ' *** ';
220: fnd_file.put_line(fnd_file.log, l_Error_Message);
221:
222: fnd_file.put_line(fnd_file.log, ' row_id, theme_id, theme, score, query_response, created_by, creation_date, last_updated_by, last_update_date');
223: