APPS.IEM_DIAG_CREATE_ACCOUNT_PVT dependencies on IEM_DB_SERVERS

Line 29: l_db_name iem_db_servers.db_name%type;

25: fixInfo VARCHAR2(4000);
26: isFatal VARCHAR2(50);
27: l_accounts varchar2(5000);
28: l_db_link iem_db_connections.db_link%type;
29: l_db_name iem_db_servers.db_name%type;
30: l_db_server_tbl jtf_varchar2_Table_100:=jtf_varchar2_Table_100();
31: l_count number;
32: l_link_count number;
33:

Line 34: l_db_server_rec iem_db_servers%rowtype;

30: l_db_server_tbl jtf_varchar2_Table_100:=jtf_varchar2_Table_100();
31: l_count number;
32: l_link_count number;
33:
34: l_db_server_rec iem_db_servers%rowtype;
35: l_account_rec iem_diag_oes_rule_pvt.account_type;
36: Type get_account_rec is REF CURSOR ;
37: email_account_cur get_account_rec;
38: l_str VARCHAR2(5000);

Line 61: select count(*) into l_count from iem_db_servers;

57:
58: c_userid := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM6'), inputs);
59: c_domain := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue(FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_SUM7'), inputs);
60:
61: select count(*) into l_count from iem_db_servers;
62:
63: if (l_count = 0) then
64: statusStr := 'FAILURE';
65: errStr := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_TC1_ERROR1');

Line 78: select * into l_db_server_rec from iem_db_servers;

74: isFatal := 'FALSE';
75:
76: else
77:
78: select * into l_db_server_rec from iem_db_servers;
79:
80: IEM_DB_CONNECTIONS_PVT.select_item(
81: p_api_version_number =>1.0,
82: p_db_server_id =>l_db_server_rec.db_server_id,