APPS.IEM_DIAG_OES_RULE_PVT dependencies on IEM_DB_CONNECTIONS

Line 31: l_db_link iem_db_connections.db_link%type;

27: l_mulrule_accounts varchar2(32767);
28: l_invalidrule_accounts varchar2(32767);
29: l_notauthen_accounts varchar2(32767);
30: dummy_num NUMBER;
31: l_db_link iem_db_connections.db_link%type;
32: l_apps_link iem_db_connections.db_link%type;
33: l_db_name iem_db_servers.db_name%type;
34: l_db_server_tbl jtf_varchar2_Table_100:=jtf_varchar2_Table_100();
35: l_count number;

Line 32: l_apps_link iem_db_connections.db_link%type;

28: l_invalidrule_accounts varchar2(32767);
29: l_notauthen_accounts varchar2(32767);
30: dummy_num NUMBER;
31: l_db_link iem_db_connections.db_link%type;
32: l_apps_link iem_db_connections.db_link%type;
33: l_db_name iem_db_servers.db_name%type;
34: l_db_server_tbl jtf_varchar2_Table_100:=jtf_varchar2_Table_100();
35: l_count number;
36: l_link_count number;

Line 66: select db_link into l_apps_link from iem_db_connections where is_admin='O';

62: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
63:
64: l_string := 'select email_user, domain, db_server_id, email_password, account_flag from iem_email_accounts';
65:
66: select db_link into l_apps_link from iem_db_connections where is_admin='O';
67:
68: -- Start looping through all email accounts defined in SSA
69: OPEN email_account_cur FOR l_string;
70: LOOP

Line 74: IEM_DB_CONNECTIONS_PVT.select_item(

70: LOOP
71: FETCH email_account_cur into l_account_rec;
72: EXIT WHEN email_account_cur%NOTFOUND;
73:
74: IEM_DB_CONNECTIONS_PVT.select_item(
75: p_api_version_number =>1.0,
76: p_db_server_id =>l_account_rec.db_server_id,
77: p_is_admin =>'A',
78: x_db_link=>l_im_link1,