DBA Data[Home] [Help]

APPS.IEM_DIAG_EMC_SETUP_PVT dependencies on IEM_EMAIL_ACCOUNTS

Line 75: select count(*) into l_a_account_count from iem_email_accounts where account_flag = 'A';

71: select count(*) into l_imap_count from iem_email_servers where server_type_id=10001;
72: select count(*) into l_smtp_count from iem_email_servers where server_type_id=10002;
73:
74: -- Email Accounts
75: select count(*) into l_a_account_count from iem_email_accounts where account_flag = 'A';
76: select count(*) into l_i_account_count from iem_email_accounts where account_flag = 'I';
77:
78: -- Check if user has entered an default customer number in Profile
79: if (FND_PROFILE.VALUE('IEM_DEFAULT_CUSTOMER_NUMBER') is null or FND_PROFILE.VALUE('IEM_DEFAULT_CUSTOMER_ID') is null) then

Line 76: select count(*) into l_i_account_count from iem_email_accounts where account_flag = 'I';

72: select count(*) into l_smtp_count from iem_email_servers where server_type_id=10002;
73:
74: -- Email Accounts
75: select count(*) into l_a_account_count from iem_email_accounts where account_flag = 'A';
76: select count(*) into l_i_account_count from iem_email_accounts where account_flag = 'I';
77:
78: -- Check if user has entered an default customer number in Profile
79: if (FND_PROFILE.VALUE('IEM_DEFAULT_CUSTOMER_NUMBER') is null or FND_PROFILE.VALUE('IEM_DEFAULT_CUSTOMER_ID') is null) then
80: l_cust_prof_null := true;