APPS.IEM_CONFIGURATION_PUB dependencies on IEM_SERVER_GROUPS

Line 24: l_server_group_rec IEM_SERVER_GROUPS%ROWTYPE;

20: l_msg_data varchar2(300);
21: l_Error_Message VARCHAR2(2000);
22: l_profile_value varchar2(200);
23: l_account_name varchar(500);
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;

Line 32: Cursor csr_server_group is select * from iem_server_groups;

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;
35: Cursor csr_email_server is select * from iem_email_servers;
36: Cursor csr_email_account is select * from iem_email_accounts;

Line 64: select count(*) into l_count from iem_server_groups;

60: l_Error_Message := '--------------eMail Center Configuration Details --------------';
61: fnd_file.put_line(fnd_file.log, l_Error_Message);
62:
63: -- Server Group
64: select count(*) into l_count from iem_server_groups;
65:
66: l_Error_Message := '*** SERVER GROUP (IEM_SERVER_GROUPS) Total # of rows: ' || l_count || ' *** ';
67: fnd_file.put_line(fnd_file.log, l_Error_Message);
68:

Line 66: l_Error_Message := '*** SERVER GROUP (IEM_SERVER_GROUPS) Total # of rows: ' || l_count || ' *** ';

62:
63: -- Server Group
64: select count(*) into l_count from iem_server_groups;
65:
66: l_Error_Message := '*** SERVER GROUP (IEM_SERVER_GROUPS) Total # of rows: ' || l_count || ' *** ';
67: fnd_file.put_line(fnd_file.log, l_Error_Message);
68:
69: fnd_file.put_line(fnd_file.log, 'row_id, server_group_id, group_name');
70: